PHP Decode

use App\InitializeAppModule;
function encode($str){
if($str!=''){
$val=0;  
$n = 1457893;  
$val = ((int)$n + (int)$str);
return str_replace('--','0x0x',strtr(base64_encode($val), '+/=', '-_-')); 
}
}

function getArivalDepatureName($id){ 

$res = getRecord('name','arrivalDepartureMaster','id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}

function decode($str){ 
if($str!=''){
$val=0;  
$val = str_replace('0x0x','--',base64_decode(strtr($str, '-_-', '+/='))); 
$n = 1457893; 
$val = ((int)$val-(int)$n);  
return max($val,0);  

}
}



function encodeString($str){
if($str!=''){ 
return base64_encode(base64_encode(base64_encode($str))); 
}
}


function decodeString($str){ 
if($str!=''){ 
return base64_decode(base64_decode(base64_decode($str)));  

}
}
 

function strip($str){  
return stripslashes(htmlentities(trim($str)));  
}

 

function loginCheck($email,$password){   
$query = 'SELECT id,email,firstName,lastName,currentIp,currentLogin FROM '._USER_MASTER_.' WHERE email="'.$email.'" and password="'.md5($password).'" and activeStatus=0';

$res = InitializeAppModule::query($query);

if(mysqli_num_rows($res)>0){ 

$result = mysqli_fetch_array($res);

$_SESSION['userId'] = strip($result['id']);

$_SESSION['email'] = strip($result['email']); 



if (!empty($_SERVER['HTTP_CLIENT_IP'])) {

    $ip = $_SERVER['HTTP_CLIENT_IP'];

} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {

    $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];

} else {

    $ip = $_SERVER['REMOTE_ADDR'];

}  
$updateQuery = 'UPDATE '._USER_MASTER_.' SET currentLogin="'.time().'",currentIp="'.$ip.'",lastLogin="'.strip($result['currentLogin']).'",lastIp="'.strip($result['currentIp']).'"'; 

InitializeAppModule::query($updateQuery);
 
return 'true'; 

} 

}
 



function getRecord($nameValues,$tableName,$where){ 
if($nameValues=='*'){ 
$result=0; 
}else{ 
$query = 'SELECT '.$nameValues.' FROM '.$tableName.' WHERE '.$where.''; 
$result = InitializeAppModule::query($query); 
} 
return $result; 
}




 


function maketree($id){  
$html = ''; 
$result = ''; 
$getData = ''; 
$result = getRecord('id,name,parentId,details',_ROLE_MASTER_,'parentId="'.$id.'" and deleteStatus=0 order by id asc');  
if(mysqli_num_rows($result)>0){
$html.='<ul>'; 
while($getData = mysqli_fetch_array($result)){  
$html.='<li>
					<a href="#">'.strip($getData['name']).'</a>'.maketree(strip($getData['id'])).'</li>';  
} 
$html.='</ul>'; 
return $html; 
}
}





  




function inserRecord($nameValues,$tableName){  
$insertQuery = 'INSERT INTO '.$tableName.' SET '.$nameValues.'';  
InitializeAppModule::query($insertQuery);  
}
 



function inserRecordLastId($nameValues,$tableName){  
$insertQuery = 'INSERT INTO '.$tableName.' SET '.$nameValues.'';  
InitializeAppModule::query($insertQuery);  
 
$sql = getRecord('id',$tableName,'1 order by id desc'); 
$lastId = mysqli_fetch_array($sql); 
return $lastId['id'];
}



function updateRecord($nameValues,$tableName,$where){ 

$updateQuery = 'UPDATE '.$tableName.' SET '.$nameValues.' WHERE '.$where.'';   
InitializeAppModule::query($updateQuery);  

}



function getUserName($id){ 

$res = getRecord('firstName,lastName',_USER_MASTER_,'id="'.$id.'"');  

$result = mysqli_fetch_array($res);

return $result['firstName'].' '.$result['lastName'];

}





function getUserProfileName($id){ 

$res = getRecord('name',_ROLE_PERMISSION_MASTER_,'id="'.$id.'"');  

$result = mysqli_fetch_array($res);

return $result['name'];

}



function generateToken( $formName ) 
{
    $secretKey = 'dsaf879sdfk343!@$#@';
    if ( !session_id() ) {
        session_start();
    }
    $sessionId = session_id();

    return sha1( $formName.$sessionId.$secretKey );

}



function checkToken( $token, $formName ) 
{
    return $token === generateToken( $formName );
}






function getsupplierServiceType($id){ 

$res = getRecord('name',_SUPPLIER_SERVICE_TYPE_MASTER_,'id="'.$id.'"');  

$result = mysqli_fetch_array($res);

return $result['name'];

}






function getCountryName($id){ 

$res = getRecord('name,sortname',_COUNTRY_MASTER_,'id="'.$id.'"');  

$result = mysqli_fetch_array($res);

return $result['name'];  

}

 




function getStateName($id){ 

$res = getRecord('name',_STATE_MASTER_,'id="'.$id.'"');  

$result = mysqli_fetch_array($res);

return $result['name'];

}





function getCityName($id){ 

$res = getRecord('name',_CITY_MASTER_,'id="'.$id.'"');  

$result = mysqli_fetch_array($res);

return $result['name'];

}





function getpagination($table,$where,$limit,$page,$module){ 

$result = getRecord('COUNT(id)',$table,' 1 '.$where.' order by id asc');
$row_db = mysqli_fetch_row($result);   
$total_records = $row_db[0];
$total_pages = ceil($total_records / $limit); 

echo '<div class="row">
<div class="col-sm-12 col-md-5">
<div class="dataTables_info" id="datatable-buttons_info" role="status" aria-live="polite">Showing '.$limit.' to '.$total_pages.' of '.$total_records.' entries</div>
</div>

<div class="col-sm-12 col-md-7">
<div class="dataTables_paginate paging_simple_numbers" id="datatable-buttons_paginate" style=" float: right;">';
											
											
											
$previous='disabled';
if(($page-1)>0){
$previous='';
}

$loadpage=0;
if($total_pages>=$page){
$remainpage = $total_pages-$page;
if($remainpage>=3){
$loadpage=(3+$page);
}else{
$loadpage=$total_pages;
}
}

$loadloop=0;
if($page>=4){
$loadloop=($page-3);
}else{
$loadloop=$page;
}											
											

$pagLink = '<ul class="pagination">
<li class="paginate_button page-item previous '.$previous.'" id="datatable-buttons_previous"><a href="travelMaster.sys?tm='.$module.'&page='.($page-1).'" aria-controls="datatable-buttons" data-dt-idx="0" tabindex="0" class="page-link">Previous</a>
</li>'; 

for ($i=$loadloop; $i<=$loadpage; $i++){
$active="";
if($i==$page){
$active="active";
} 
if($i==1 && $page<2){
$active="active";
} 
$pagLink .= '<li class="paginate_button page-item '.$active.'"><a aria-controls="datatable-buttons" data-dt-idx="1" tabindex="0" class="page-link" href="travelMaster.sys?tm='.$module.'&page='.$i.'">'.$i.'</a></li>';	
}

$next='';
if($page==$total_pages){
$next='disabled';
}											
											
echo $pagLink . '<li class="paginate_button page-item next '.$next.'" id="datatable-buttons_next"><a href="travelMaster.sys?tm='.$module.'&page='.($page+1).'" aria-controls="datatable-buttons" data-dt-idx="7" tabindex="0" class="page-link">Next</a></li></ul>
</div>
</div>
</div>';											
											
											

}


 
function getRecordPage($nameValues,$tableName,$where,$start_from,$limit,$page,$module,$pageurl){ 
 
if($nameValues=='*'){ 
$result=0; 
}else{ 
$query = 'SELECT '.$nameValues.' FROM '.$tableName.' WHERE '.$where.' LIMIT '.$start_from.', '.$limit.''; 
$result = InitializeAppModule::query($query); 
} 



$res = getRecord('COUNT(id)',$tableName,' '.$where.'');
$row_db = mysqli_fetch_row($res);   
$total_records = $row_db[0];
$total_pages = ceil($total_records / $limit); 

$pagLink = '<div class="row">
<div class="col-sm-12 col-md-5">
<div class="dataTables_info" id="datatable-buttons_info" role="status" aria-live="polite">Showing '.$limit.' to '.$total_pages.' of '.$total_records.' entries</div>
</div>

<div class="col-sm-12 col-md-7">
<div class="dataTables_paginate paging_simple_numbers" id="datatable-buttons_paginate" style=" float: right;">';
											
											
											
$previous='disabled';
if(($page-1)>0){
$previous='';
}

$loadpage=0;
if($total_pages>=$page){
$remainpage = $total_pages-$page;
if($remainpage>=3){
$loadpage=(3+$page);
}else{
$loadpage=$total_pages;
}
}

$loadloop=0;
if($page>=4){
$loadloop=($page-3);
}else{
$loadloop=$page;
}											
											

$pagLink .= '<ul class="pagination">
<li class="paginate_button page-item previous '.$previous.'" id="datatable-buttons_previous"><a href="travelMaster.sys?tm='.$module.'&page='.($page-1).$pageurl.'" aria-controls="datatable-buttons" data-dt-idx="0" tabindex="0" class="page-link">Previous</a>
</li>'; 

for ($i=$loadloop; $i<=$loadpage; $i++){
$active="";
if($i==$page){
$active="active";
} 
if($i==1 && $page<2){
$active="active";
} 
$pagLink .= '<li class="paginate_button page-item '.$active.'"><a aria-controls="datatable-buttons" data-dt-idx="1" tabindex="0" class="page-link" href="travelMaster.sys?tm='.$module.'&page='.$i.$pageurl.'">'.$i.'</a></li>';	
}

$next='';
if($page==$total_pages){
$next='disabled';
}											
											
$pagLink .= '<li class="paginate_button page-item next '.$next.'" id="datatable-buttons_next"><a href="travelMaster.sys?tm='.$module.'&page='.($page+1).$pageurl.'" aria-controls="datatable-buttons" data-dt-idx="7" tabindex="0" class="page-link">Next</a></li></ul>
</div>
</div>
</div>';											

$arr = array($result,$pagLink);

return $arr; 										
	
}







function getHotelCategory($id){ 

$res = getRecord('name',_HOTEL_CATEGORY_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}


function getHotelCategoryStar($id){ 

$res = getRecord('name,starCategory',_HOTEL_CATEGORY_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['starCategory'];

}

function getRoomType($id){ 

$res = getRecord('name',_ROOM_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}

function getAmenities($id){ 

$res = getRecord('name',_AMENITIES_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}


function getDestination($id){ 

$res = getRecord('name',_DESTINATION_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}

function getInvCompanyName($id){ 

$res = getRecord('companyName',_INVOICE_SETTING_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['companyName'];

}

function getHotelLocation($id){ 

$res = getRecord('name',_HOTEL_LOCATION_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}





function getHotePriceType($id){ 

$res = getRecord('name',_PRICE_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}




function getSupplierName($id){ 

$res = getRecord('name',_SUPPLIER_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}

 




function getMealPlanName($id){ 

$res = getRecord('name',_MEAL_PLAN_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}


 




function getRateType($rateType){ 

if($rateType==0){ $type = 'Non-Refundable'; }else{ $type = 'Refundable'; } 
return $type;

}

 
 




function getCurrencyName($id){ 

$res = getRecord('name',_CURRENCY_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}


function getDateFormat($date){ 

if($date!='1970-01-01' && $date!=''){
$date=date('d-m-Y', strtotime($date));
} 
return $date;

}



function getDayName($id){ 

$res = getRecord('name',_DAYS_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}





function getFullAddress($countryId,$stateId,$cityId){ 

$res = getRecord('name',_COUNTRY_MASTER_,'id="'.$countryId.'"');   
$resultCon = mysqli_fetch_array($res);

$res1 = getRecord('name',_STATE_MASTER_,'id="'.$stateId.'"');   
$resultSt = mysqli_fetch_array($res1);

$res2 = getRecord('name',_CITY_MASTER_,'id="'.$cityId.'"');  
$resultCt = mysqli_fetch_array($res2);


$address= $resultCt['name'].', '.$resultSt['name'].', '.$resultCon['name'];


return $address;  
}



function deleteRecord($where,$tableName){ 

$query = 'DELETE FROM '.$tableName.' WHERE '.$where.''; 
$result = InitializeAppModule::query($query);  
return $result; 

}





function getTime($id){ 

$res = getRecord('name',_TIME_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}






function getVehicleName($id){  
$res = getRecord('name',_VEHICLE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}





function getTransferName($id){  
$res = getRecord('name',_TRANSFER_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}








function getTransferLocation($id){  
$res = getRecord('name',_TRANSFER_LOCATION_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}






function getMealName($id){  
$res = getRecord('name',_MEALS_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}







function getVisaName($id){  
$res = getRecord('name',_VISA_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}






function getLeadSourceName($id){  
$res = getRecord('name',_LEAD_SOURCE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}







function getUserType($id){  
$res = getRecord('name',_USER_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}






function getQueryType($id){  
$res = getRecord('name',_QUERY_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
} 





function getCompanyName($id,$type){  
if($type==1){
$res = getRecord('companyName',_AGENT_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['companyName']; 
} 

if($type==2){ 
return getClientName($id); 
} 
}







function getQueryStatus($id){  
$res = getRecord('name',_QUERY_STATUS_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
} 



function makeLog($parentId,$parentType,$subject,$description){  
$nameValues='parentId="'.$parentId.'",parentType="'.$parentType.'",subject="'.$subject.'",description="'.$description.'",addedBy="'.$_SESSION['userId'].'",dateAdded="'.date('Y-m-d H:i:s').'"';
inserRecord($nameValues,_LOG_MASTER_);
} 








function getClientName($id){  
$res = getRecord('name',_CLIENT_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
} 








function getUserEmail($id){  
$res = getRecord('email',_USER_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['email'];

}



function getUserPhone($id){  
$res = getRecord('mobileNo',_USER_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['mobileNo'];

}







function makeQueryId($id){  
$res = getRecord('queryId,agentId,clientType,queryStatus,assignedCompanyId',_QUERY_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
 
$cl = getRecord('id,companyName',_INVOICE_SETTING_MASTER_,'id="'.$result['assignedCompanyId'].'"'); 
$resultCli = mysqli_fetch_array($cl); 
 


return '#'.$result['queryId'].'<div class="text-muted" style="color: #ffffff!important;">
								<span style="display: inline-block; padding: .25em .4em; font-size: 10px; font-weight: 500; line-height: 1; text-align: center; white-space: nowrap; vertical-align: baseline; border-radius: .25rem; transition: color .15s ease-in-out,background-color .15s ease-in-out,border-color .15s ease-in-out,box-shadow .15s ease-in-out,-webkit-box-shadow .15s ease-in-out; background-color: #34c38f!important; "><i class="mdi mdi-star"></i> '.strip($resultCli['companyName']).'&nbsp;</span>
								</div>';

}


function makeQueryIdMail($id){  
$res = getRecord('queryId,countryId',_QUERY_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return '#'.$result['queryId'];

}
 
function makeInvoiceId($id){   
$res = getRecord('dateAdded',_INVOICE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res);
$resultDate = date('d',strtotime($result['dateAdded']));
$resultMonth = date('m',strtotime($result['dateAdded']));
$resultYear = date('y',strtotime($result['dateAdded']));
return 'BV'.$resultDate.$resultMonth.$resultYear.$id; 
}



 
function makeVoucherId($id){    
return 'VHR'.str_pad($id, 6, '0', STR_PAD_LEFT); 
}

function countQueryMails($id){  
$res = getRecord('COUNT(id) as totalMails',_QUERY_CLIENT_COMMUNICATION_MASTER_,'queryId="'.$id.'" and readStatus=1'); 
$result = mysqli_fetch_array($res); 
return $result['totalMails']; 
}



function removeSpecialCharacters($content){
$string = htmlentities($content, null, 'utf-8');
$content = str_replace("&nbsp;", "", $string);
$content = html_entity_decode($content);
return $content;
}




function makeQuotationId($id){ 

$res = getRecord('assignedCompanyId','quotationMaster','id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
 
$cl = getRecord('id,companyName',_INVOICE_SETTING_MASTER_,'id="'.$result['assignedCompanyId'].'"'); 
$resultCli = mysqli_fetch_array($cl);

$companyName  = $resultCli['companyName'];
$arr = explode(" ", $companyName);
$first = ucfirst(substr($arr[0],0,1)); 
$second = ucfirst(substr($arr[1],0,1)); 



$quotName=$first.$second;

return $quotName.str_pad($id, 6, '0', STR_PAD_LEFT);
}





function removeSpecialChar($html){
$html=mb_convert_encoding($html, 'UTF-8',mb_detect_encoding($html, 'UTF-8, ISO-8859-1', true));
return $html;
}






function getFromTravelDate($queryId){
$startDate=''; 
$result = getRecord('id,fromDate',_QUERY_DESTINATION_MASTER_,'queryId="'.$queryId.'" order by id asc');    
$destData=mysqli_fetch_array($result);
$startDate=date('d-m-Y', strtotime($destData['fromDate']));
return $startDate;
}



function getToTravelDate($queryId){
$endDate=''; 
$result = getRecord('id,toDate',_QUERY_DESTINATION_MASTER_,'queryId="'.$queryId.'" order by id desc');    
$destData=mysqli_fetch_array($result);
$endDate=date('d-m-Y', strtotime($destData['toDate']));
return $endDate;
}



function getQueryDestination($queryId){
$destinations='';
$re = 'id,destinationId'; 
$result = getRecord($re,_QUERY_DESTINATION_MASTER_,'queryId="'.$queryId.'" order by id asc');    
while($destData=mysqli_fetch_array($result)){
$destinations.=getDestination($destData['destinationId']).', ';
}
return rtrim($destinations,', ');
}



function getMarkup($quotationId,$cost,$markupVal){
$totalCost=$cost;
$re = 'id,markup,markupType,currencyValue'; 
$result = getRecord($re,_QUOTATION_MASTER_,'id="'.$quotationId.'" order by id asc');  
$getQuotationData=mysqli_fetch_array($result); 

if($getQuotationData['markupType']=='Flat'){
$totalCost=round($cost+$markupVal);
}

if($getQuotationData['markupType']=='%'){
$totalCost=round(($cost/100*$markupVal)+$cost);
} 
 
return $totalCost;
}


function getAgentMarkup($quotationId,$cost,$markupVal){
$totalCost=$cost;
$re = 'id,markup,markupTypeAgent,currencyValue';  
$result = getRecord($re,_QUOTATION_MASTER_,'id="'.$quotationId.'" order by id asc');  
$getQuotationData=mysqli_fetch_array($result); 

if($getQuotationData['markupTypeAgent']=='Flat'){
$totalCost=round($cost+$markupVal);
}

if($getQuotationData['markupTypeAgent']=='%'){
$totalCost=round(($cost/100*$markupVal)+$cost);
} 
 
return $totalCost;
}


function getOnlyMarkupCost($quotationId,$cost,$markupVal){
$totalCost=0;
$re = 'id,markup,markupType,currencyValue'; 
$result = getRecord($re,_QUOTATION_MASTER_,'id="'.$quotationId.'" order by id asc');  
$getQuotationData=mysqli_fetch_array($result); 

if($getQuotationData['markupType']=='Flat' && $markupVal>0){
$totalCost=round($markupVal);
}

if($getQuotationData['markupType']=='%' && $markupVal>0){
$totalCost=round(($cost/100*$markupVal));
} 
 
return $totalCost;
}


function getAgentOnlyMarkupCost($quotationId,$cost,$markupVal){
$totalCost=0;
$re = 'id,markup,markupTypeAgent,currencyValue'; 
$result = getRecord($re,_QUOTATION_MASTER_,'id="'.$quotationId.'" order by id asc');  
$getQuotationData=mysqli_fetch_array($result);  
if($getQuotationData['markupTypeAgent']=='Flat' && $markupVal>0){
$totalCost=round($markupVal);
}

if($getQuotationData['markupTypeAgent']=='%' && $markupVal>0){
$totalCost=round(($cost/100*$markupVal));
} 
 
return $totalCost;
}




function getAEDCostWithMarkup($a,$b){}

function getNewCurrencyCost($oldCurr,$newCurr,$cost){
 
$a = getRecord('value',_CURRENCY_MASTER_,' id="'.$newCurr.'"');
$newcurrData = mysqli_fetch_array($a); 


return ($cost*$newcurrData['value']);
}




function getUSDCostToAED($queryId,$cost){

$totalCost=0;
if($cost>0){ 
 
$result = getRecord('id,AEDCurrencyValue',_QUERY_MASTER_,'id="'.$queryId.'" order by id asc');  
$getQueryData=mysqli_fetch_array($result);
 
$totalCost=$cost*$getQueryData['AEDCurrencyValue']; 
}
return $totalCost;
}



function getWithOutMarkup($quotationId,$cost){
$totalCost=0;  
$re = 'id,markup,markupType,currencyValue'; 
$result = getRecord($re,_QUOTATION_MASTER_,'id="'.$quotationId.'" order by id asc');  
$getQuotationData=mysqli_fetch_array($result);
 
$totalCost=$cost;
if($getQuotationData['currencyValue']>1){ 
$totalCost=round($totalCost/$getQuotationData['currencyValue']); 
 
}
return $totalCost;
}
 


function getINRtoUSD($currencyINR,$cost,$currencyUSD){
$usdCost = 0;
$inr = getRecord('value',_CURRENCY_MASTER_,'id="'.$currencyINR.'"'); 
$resultINR = mysqli_fetch_array($inr); 
$usdCost=$cost/$resultINR['value']; 

$usd = getRecord('value',_CURRENCY_MASTER_,'id="'.$currencyUSD.'"'); 
$resultUSD = mysqli_fetch_array($usd); 
$usdCost=$usdCost/$resultUSD['value'];


return $usdCost;
}














function clean($str)
{       
    $str = utf8_decode($str);
    $str = str_replace("&nbsp;", "", $str);
    $str = preg_replace("/\s+/", " ", $str);
    $str = trim($str);
    return $str;
}


function getApartmentRoomType($id){ 

$res = getRecord('name',_APARTMENT_ROOM_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}






function getFinalCost($quotationId,$cost){
$totalCost=0;
$re = 'id,markup,markupType,currencyValue'; 
$result = getRecord($re,_QUOTATION_MASTER_,'id="'.$quotationId.'" order by id asc');  
$getQuotationData=mysqli_fetch_array($result);

if($getQuotationData['markup']>0){   

if($getQuotationData['markupType']=='Flat'){
$totalCost=round($cost+$getQuotationData['markup']);
}

if($getQuotationData['markupType']=='%'){
$totalCost=round(($cost/100*$getQuotationData['markup'])+$cost);
}

if($getQuotationData['currencyValue']>1){ 
$totalCost=round($totalCost/1); 
}

}else{
$totalCost=$cost;
if($getQuotationData['currencyValue']>1){ 
$totalCost=round($totalCost/1); 
}
}
return $totalCost;
}







function getPaymentMethodType($id){ 

$res = getRecord('name',_PAYMENT_METHOD_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}



 

function numbertoword(float $number)
{
    $decimal = round($number - ($no = floor($number)), 2) * 100;
    $hundred = null;
    $digits_length = strlen($no);
    $i = 0;
    $str = array();
    $words = array(0 => '', 1 => 'one', 2 => 'two',
        3 => 'three', 4 => 'four', 5 => 'five', 6 => 'six',
        7 => 'seven', 8 => 'eight', 9 => 'nine',
        10 => 'ten', 11 => 'eleven', 12 => 'twelve',
        13 => 'thirteen', 14 => 'fourteen', 15 => 'fifteen',
        16 => 'sixteen', 17 => 'seventeen', 18 => 'eighteen',
        19 => 'nineteen', 20 => 'twenty', 30 => 'thirty',
        40 => 'forty', 50 => 'fifty', 60 => 'sixty',
        70 => 'seventy', 80 => 'eighty', 90 => 'ninety');
    $digits = array('', 'hundred','thousand','lakh', 'crore');

    while( $i < $digits_length ) {
        $divider = ($i == 2) ? 10 : 100;
        $number = floor($no % $divider);
        $no = floor($no / $divider);
        $i += $divider == 10 ? 1 : 2;
        if ($number) {
            $plural = (($counter = count($str)) && $number > 9) ? 's' : null;
            $hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
            $str [] = ($number < 21) ? $words[$number].' '. $digits[$counter]. $plural.' '.$hundred:$words[floor($number / 10) * 10].' '.$words[$number % 10]. ' '.$digits[$counter].$plural.' '.$hundred;
        } else $str[] = null;
    }

    $rupees = implode('', array_reverse($str));
    $paise = '';

    if ($decimal) {
        $paise = 'and ';
        $decimal_length = strlen($decimal);

        if ($decimal_length == 2) {
            if ($decimal >= 20) {
                $dc = $decimal % 10;
                $td = $decimal - $dc;
                $ps = ($dc == 0) ? '' : '-' . $words[$dc];

                $paise .= $words[$td] . $ps;
            } else {
                $paise .= $words[$decimal];
            }
        } else {
            $paise .= $words[$decimal % 10];
        }

        $paise .= ' paise';
    }

    return ucwords(($rupees ? $rupees . 'rupees ' : '') . $paise) ;
}

 



 

function getGuideName($id){  
$res = getRecord('name',_GUIDE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}

 

function getDriverName($id){  
$res = getRecord('name',_DRIVER_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}



function getHotelName($id){  
$res = getRecord('name',_HOTEL_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}





function getQuotationAcivityName($id,$type){  
if($type=='Hotel'){
$res = getRecord('name',_HOTEL_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}

if($type=='Transfer'){
$res = getRecord('name',_TRANSFER_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}

if($type=='Sightseeing'){
$res = getRecord('name',_SIGHTSEEING_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}

if($type=='Meal'){
$res = getRecord('name',_MEALS_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}

if($type=='Flight'){
$res = getRecord('name','flightMaster','id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
}
  
}




function getQueryPax($id){  
if($id!=''){
$re = 'id,adults,childs,infants'; 
$result = getRecord($re,_QUERY_MASTER_,'id="'.$id.'" order by id asc');    
$getData=mysqli_fetch_array($result); 

return $getData['adults']+$getData['childs']+$getData['infants']; 
}
}





function getEmployeeName($id){ 

$res = getRecord('name',_EMPLOYEE_MASTER_,'id="'.$id.'"');  

$result = mysqli_fetch_array($res);

return $result['name'];  

}





function getexpenseServicesType($id){  
$res = getRecord('name',_EXPENSE_SERVICE_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name']; 
} 





function getNationality($id){  
$res = getRecord('nationality',_COUNTRY_MASTER_,'id="'.$id.'"');   
$result = mysqli_fetch_array($res); 
return $result['nationality'];  
}




function getSightseeingExclusiveService($id){  
$res = getRecord('name',_SIGHTSEEING_EXCLUSIVE_SERVICE_MASTER_,'id="'.$id.'"');   
$result = mysqli_fetch_array($res); 
return $result['name'];  
}


function getBankName($id){  
$res = getRecord('name',_BANK_MASTER_,'id="'.$id.'"');   
$result = mysqli_fetch_array($res); 
return $result['name'];  
}






function time_elapsed_string($datetime, $full = false) {
    $now = new DateTime;
    $ago = new DateTime($datetime);
    $diff = $now->diff($ago);

    $diff->w = floor($diff->d / 7);
    $diff->d -= $diff->w * 7;

    $string = array(
        'y' => 'year',
        'm' => 'month',
        'w' => 'week',
        'd' => 'day',
        'h' => 'hour',
        'i' => 'minute',
        's' => 'second',
    );
    foreach ($string as $k => &$v) {
        if ($diff->$k) {
            $v = $diff->$k . ' ' . $v . ($diff->$k > 1 ? 's' : '');
        } else {
            unset($string[$k]);
        }
    }

    if (!$full) $string = array_slice($string, 0, 1);
    return $string ? implode(', ', $string) . ' ago' : 'just now';
}




function getRestaurantName($id){ 

$res = getRecord('name',_RESTAURANT_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}




function getMealPriceTypeName($id){ 

$res = getRecord('name',_MEAL_PRICE_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}



function getRestaurantTypeName($id){ 

$res = getRecord('name',_RESTAURANT_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}



function getHotelOfferName($id){ 

$res = getRecord('name',_HOTEL_OFFER_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}

function getRestaurantsLocation($id){ 

$res = getRecord('name',_RESTAURANT_LOCATION_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}



function getGuestStatusCategoryTypeName($id){ 

$res = getRecord('name',_APP_GUEST_STATUS_CATEGORY_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}



function getDriverExpenseTypeName($id){ 

$res = getRecord('name',_APP_DRIVER_EXPENSE_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}



function getGuestCommentTypeName($id){ 

$res = getRecord('name',_APP_GUEST_COMMENTS_TYPE_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}

function getDefaultCurrencyName(){ 

$res = getRecord('name',_CURRENCY_MASTER_,' baseCurrency=1'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}



function getHotelCategoryName($id){ 

$res = getRecord('name','hotelCategoryMaster','id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}



function getFerryClassName($id){ 

$res = getRecord('name','ferryClassMaster','id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
return $result['name'];

}

function getNights($fromDate,$toDate){
$date1 = new DateTime($fromDate); 
$date2 = new DateTime($toDate); 
// this calculates the diff between two dates, which is the number of nights 
$nights= $date2->diff($date1)->format("%a"); 
if($nights==0){
$nights=1;
}
return $nights;
}

function getPaymentMethod($id){ 

$res = getRecord('name','paymentMethodTypeMaster','id="'.$id.'"');  

$result = mysqli_fetch_array($res);

return $result['name'];  

}



function getAssignedCompanyName($id){   

$res = getRecord('assignedCompanyId',_DESTINATION_MASTER_,'id="'.$id.'"'); 
$result = mysqli_fetch_array($res); 
 
$cl = getRecord('id,companyName',_INVOICE_SETTING_MASTER_,'id="'.$result['assignedCompanyId'].'"'); 
$result1 = mysqli_fetch_array($cl); 
return $result1['companyName'];

}



function checkFileSize($fileSize,$requiredSize)
{
	$requiredSize = $requiredSize * 1024;
	if ($fileSize > 0 && $fileSize <= $requiredSize) { 
	    return true;
	} else {
	    return false;
	}
}


function getEmailSignature(){ 

$res = getRecord('emailSignature',_USER_MASTER_,' id="'.$_SESSION['userId'].'"'); 
$result = mysqli_fetch_array($res); 
return $result['emailSignature'];

}



function getTravelAge($id){ 
$res = getRecord('name',_TRAVEL_INSURANCE_AGE_MASTER_,'id="'.$id.'"');  
$result = mysqli_fetch_array($res);
return $result['name'];  
}

function getTravelDays($id){ 
$res = getRecord('name',_TRAVEL_INSURANCE_DAY_MASTER_,'id="'.$id.'"');  
$result = mysqli_fetch_array($res);
return $result['name'];  
}
function getTravelCompany($id){ 
$res = getRecord('name',_TRAVEL_INSURANCE_COMPANY_MASTER_,'id="'.$id.'"');  
$result = mysqli_fetch_array($res);
return $result['name'];  
}
function getsumInsurance($id){ 
$res = getRecord('name',_TRAVEL_INSURANCE_SUM_INSURANCE_MASTER_,'id="'.$id.'"');  
$result = mysqli_fetch_array($res);
return $result['name'];  
}
function getinsurancePlan($id){ 
$res = getRecord('name',_TRAVEL_INSURANCE_PLAN_MASTER_,'id="'.$id.'"');  
$result = mysqli_fetch_array($res);
return $result['name'];  
}
function getinsurancetype($id){ 
$res = getRecord('name','travelInsuranceTypeMaster','id="'.$id.'"');  
$result = mysqli_fetch_array($res);
return $result['name'];  
}


// Online Chat================
function getUserData($conn)
{
    $userMasterSql = "SELECT um.id, um.firstName,um.lastLoginTime, um.lastName, um.profilePhoto, ut.name as userTypeName FROM usermaster um LEFT JOIN userTypeMaster ut ON um.userType = ut.id;";
    $userMasterSql = "SELECT 
                            um.id, 
                            um.firstName, 
                            um.lastName,
                            um.lastLoginTime, 
                            um.profilePhoto, 
                            ut.name AS userTypeName,
                            unread_chats_count
                        FROM usermaster um 
                        LEFT JOIN userTypeMaster ut ON um.userType = ut.id
                        LEFT JOIN (
                            SELECT receiver_id, COUNT(*) AS unread_chats_count
                            FROM user_chats
                            WHERE is_read = false
                            GROUP BY receiver_id
                        ) uc ON um.id = uc.receiver_id;
                        ";
    return $conn->InitializeAppModule::query($userMasterSql);
}

function getDivisionVal($a,$b){ 
if($b!=0 && $b>0 && $b!=''){
return ($a/$b);  
}else{
return 0;
}
}