<?php
$product_item = array();
$AgencySysId = isset($_POST['AgencySysId']) ? $_POST['AgencySysId'] : null;
$FCurrency = isset($_POST['FCurrency']) ? $_POST['FCurrency'] : null;
$TCurrency = isset($_POST['TCurrency']) ? $_POST['TCurrency'] : null;
if ($AgencySysId && $FCurrency && $TCurrency) {
    $DBhost = "localhost";
    $DBuser = "root";
    $DBpassword = "At07Y#2zLWk@?mVP";
    $DBname = "CommanDB";
    $conn1 = mysqli_connect($DBhost, $DBuser, $DBpassword, $DBname);
    if (!$conn1) {
        die("Connection failed: " . mysqli_connect_error());
    }
    $selectQuery = "SELECT markup FROM tbl_currency_markup WHERE agency_id = $AgencySysId";
    $resultQuery = mysqli_query($conn1, $selectQuery) or die(mysqli_error($conn1));
    $markup = 0;
    while ($val1 = mysqli_fetch_array($resultQuery)) {
        $markup = $val1['markup'];
    }
	if(!empty($FCurrency) && is_array($FCurrency)){
		$Condition = '';
		foreach($FCurrency as $fcKey => $fcValue){
			if($fcKey > 0){
				$Condition .= ' OR ';
			}
			$Condition .= ' FCurrencyType = '.(int)$fcValue;
		}
		if($Condition != ''){
			$selectQuery1 = "SELECT FCurrencyType,TCurrencyType,Rate FROM tbl_currency_rate WHERE ($Condition) AND TCurrencyType = $TCurrency ";
		} 
	}else{
		$selectQuery1 = "SELECT FCurrencyType,TCurrencyType,Rate FROM tbl_currency_rate WHERE FCurrencyType = $FCurrency AND TCurrencyType = $TCurrency ";
	}
    $resultQuery1 = mysqli_query($conn1, $selectQuery1) or die(mysqli_error($conn1));
    $i = 0;
    while ($row = mysqli_fetch_array($resultQuery1)) {
		$product_item[$i]["FCurrencyType"] = $row['FCurrencyType'];
		$product_item[$i]["TCurrencyType"] = $row['TCurrencyType'];
        if ($row['FCurrencyType'] == $row['TCurrencyType']) {
            $product_item[$i]["Rate"] = $row['Rate'];
        } else {
			$markupValue = 0;
			if($markup > 0){
				$markupValue = (((float)$row['Rate'] * $markup) / 100);
			}
			$product_item[$i]["Rate"] = (float)$row['Rate'] + $markupValue;
        }
        $i++;
    }
}
echo json_encode($product_item); exit;
?>