<?php 
require_once 'init.php';
error_reporting(E_ALL);
$crud   = new Admin_Model_CRUD();
try {
    $apiData = [];
    $curl = curl_init("https://globaltravelexchange.com/webservice/currency/rate");
    curl_setopt($curl, CURLOPT_POST, true);
    curl_setopt($curl, CURLOPT_POSTFIELDS, http_build_query($apiData));
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
    $curl_response = curl_exec($curl);
    curl_close($curl);
   
} catch (Exception $error) {
    echo $error->getMessage();
    die;
}

$response_array  = [];

$response_array = json_decode($curl_response,1);
$rateResult  = $crud->rv_select_all("tbl_currency_rate",['*'] ,  ['isActive'] , ['cid'=>'ASC'] );

if(isset($response_array) && !empty($response_array)){
    foreach($response_array as $key => $val){
    $match = 0;
        foreach($rateResult as $key1 => $val1){
            if($val['FCurrencyType'] == $val1['FCurrencyType'] && $val['TCurrencyType'] == $val1['TCurrencyType']){
               $match = 1; 
            }
        }
        if($match == 1){
            $updateArray = [
            'Rate'=>(float)$val['Rate'],
            ];
            $crud->rv_update('tbl_currency_rate', $updateArray, ['FCurrencyType =?' => $val['FCurrencyType'],'TCurrencyType =?' => $val['TCurrencyType']]);

        }else{
            $insertArray = [
            'FCurrencyType'=>(int)$val['FCurrencyType'],
            'TCurrencyType'=>(int)$val['TCurrencyType'],
            'Rate'=>$val['Rate'],
            ];
             $IDS[] = $crud->rv_insert('tbl_currency_rate', $insertArray);
        }  
    } 
  }
 
?>