| Server IP : 103.234.187.230 / Your IP : 216.73.216.216 Web Server : Apache System : Linux lserver42043-ind.megavelocity.net 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/b2c.hellogtx.com/application/views/scripts/flight/ |
Upload File : |
<?php
$baseUrl = $this->baseUrl;
$tollfreenumber = $this->tollfreenumber;
$traceId = $this->traceId;
$getAgencyData = $this->getAgencyData;
$cityName = $getAgencyData['CityName'];
$AgencySysId = $getAgencyData['AgencySysId'];
$getSupportContact = $this->getSupportContact;
$objHelper = Zend_Controller_Action_HelperBroker::getStaticHelper('General');
$mydevice = Zend_Controller_Action_HelperBroker::getStaticHelper('General')->getDevice(); // get the device
$object = Zend_Controller_Front::getInstance();
$options = $object->getParam('bootstrap')->getOption('bootstrap');
$stylecss = $options['stylecss'];
$FlightBooking__ = $this->FlightBooking__;
$FlightBooking = $this->FlightBooking;
$FlightBookingInb = $this->FlightBookingInb;
$API_Response = json_decode($FlightBooking['data']['API_Response'], true);
$API_ResponseInb = json_decode($FlightBookingInb['data']['API_Response'], true);
$API_Response_Ticket = json_decode($FlightBooking['data']['API_Response_Ticket'], true);
$couponvalue = 0;
if (isset($API_Response['discountAmount'])) {
$couponvalue = $API_Response['discountAmount'];
$couponCode = $API_Response['couponCode'];
}
$FareClass = $API_Response['FairRules']['FareClass'];
$this->CurrencyRate = $API_Response['FairRules']['CurrencyRate'];
$IsRefundableTxt = $API_Response['IsRefundableTxt'];
$IsRefundableTxtInb = $API_ResponseInb['IsRefundableTxt'];
$FareClassInb = $API_ResponseInb['FairRules']['FareClass'];
$Segments = $API_Response['Segments'];
$SegmentsInb = $API_ResponseInb['Segments'];
$status = $API_Response_Ticket['order']['status'];
$tripInfos = $API_Response_Ticket['itemInfos']['AIR']['tripInfos'];
$travellerInfos = $API_Response_Ticket['itemInfos']['AIR']['travellerInfos'];
$PNR_Number = array_unique(explode('-', $FlightBooking['data']['PNR_Number']));
$PNR_Number = implode(',', $PNR_Number);
//echo"<pre>";print_r($FlightBooking['passenger']);die;
$passenger = $FlightBooking['passenger'];
$BookingId = $FlightBooking['data']['BookingId'];
$invoice = $this->InvoiceNumber;
$Currency = $FlightBooking['data']['Currency'];
$ICSourceSysId = $FlightBooking['data']['ICSourceSysId'];
$billedTo = $passenger[0];
if ($API_ResponseInb) {
$FlightBookingData = $API_ResponseInb;
}
$ARR_SALUTION = unserialize(ARR_SALUTION);
$ARR_SALUTION_CHILD = unserialize(ARR_SALUTION_CHILD);
if ($ICSourceSysId == 3) {
$ResponseStatusonward = $FlightBooking['data']['status'];
$travellerInfos = $API_Response_Ticket['Response']['Response']['FlightItinerary']['Passenger'];
if ($ResponseStatusonward == 1) {
$status = 'SUCCESS';
}
if ($ResponseStatusreturn == 1) {
$statusInb = 'SUCCESS';
}
$ARR_SALUTION = unserialize(ARR_SALUTIONTBO);
$ARR_SALUTION_CHILD = unserialize(ARR_SALUTIONTBO);
}
$IsCancellationProtection = isset($FlightBooking['data']['IsCancellationProtection']) ? $FlightBooking['data']['IsCancellationProtection'] : 0;
$CancellationProtectionPrice = isset($FlightBooking['data']['CancellationProtectionPrice']) ? $FlightBooking['data']['CancellationProtectionPrice'] : 0;
$TPSysId = isset($FlightBooking['data']['TPSysId']) ? $FlightBooking['data']['TPSysId'] : 0;
$couponApply = isset($FlightBooking['data']['couponApply']) ? $FlightBooking['data']['couponApply'] : 0;
// if ($couponApply) {
// $couponVal = isset($FlightBooking['data']['couponVal']) ? $FlightBooking['data']['couponVal'] : 0;
// } else {
// $couponVal = 0;
// }
$pnrDetails = [];
if ($FlightBookingData) {
foreach ($FlightBookingData as $Data) {
$SourceAirportCode = $Data['SourceAirportCode'];
$DestAirportCode = $Data['DestAirportCode'];
$pnrDetails[$SourceAirportCode . '-' . $DestAirportCode] = $PNR_Number;
$intNetPublishedFare += $Data['FairRules']['PublishedFare'];
}
}
$FareBreakdown = [];
if ($FlightBooking__['data']) {
foreach ($FlightBooking__['data'] as $key => $value) {
$SourceAirportCode = $value['SourceAirportCode'];
$DestAirportCode = $value['DestAirportCode'];
$pnrDetails[$SourceAirportCode . '-' . $DestAirportCode] = $PNR_Number;
// echo"<pre>ddd"; print_r($value['SourceAirportCode']);echo '</pre>';
$API_Response__ = json_decode($value['API_Response'], true);
if ($API_Response__['FairRules']['FareBreakdown']) {
foreach ($API_Response__['FairRules']['FareBreakdown'] as $keys => $values) {
// echo"<pre>";print_r($values);
//$FareBreakdown[] = $values;
$FareBreakdown[$keys]['Currency'] = $values['Currency'];
$FareBreakdown[$keys]['PassengerType'] = $values['PassengerType'];
$FareBreakdown[$keys]['PassengerCount'] = $values['PassengerCount'];
$FareBreakdown[$keys]['TaxIN'] = $values['TaxIN'];
$FareBreakdown[$keys]['BaseFareCal'] += $values['BaseFareCal'];
$FareBreakdown[$keys]['BaseFare'] += $values['BaseFare'];
$FareBreakdown[$keys]['CommissionEarned'] += $values['CommissionEarned'];
$FareBreakdown[$keys]['TDS'] += $values['TDS'];
$FareBreakdown[$keys]['MF'] += $values['MF'];
$FareBreakdown[$keys]['YQ'] += $values['YQ'];
$FareBreakdown[$keys]['AGST'] += $values['AGST'];
$FareBreakdown[$keys]['MFT'] += $values['MFT'];
// $FareBreakdown[$keys]['OT'] += $values['OT'];
$FareBreakdown[$keys]['OT'] += isset($values['OT']) ? $values['OT'] : $values['TaxBR']['OT']; //Other Charges
$FareBreakdown[$keys]['MU'] += $values['MU'];
$FareBreakdown[$keys]['YR'] += $values['YR'];
$FareBreakdown[$keys]['AddiTaxOnMarkup'] += $values['AddiTaxOnMarkup'];
$FareBreakdown[$keys]['AddiMarkup'] += $values['AddiMarkup'];
$FareBreakdown[$keys]['intTotalGST'] += $values['intTotalGST'];
$FareBreakdown[$keys]['apiMarkup'] += $values['apiMarkup'];
$FareBreakdown[$keys]['IntCommission'] += $values['IntCommission'];
$FareBreakdown[$keys]['apiTaxOnMarkup'] += $values['apiTaxOnMarkup'];
$FareBreakdown[$keys]['FixedMarkUp'] += $values['FixedMarkUp'];
$FareBreakdown[$keys]['GSTOnMarkUp'] += $values['GSTOnMarkUp'];
$FareBreakdown[$keys]['CommEarned'] += $values['CommEarned'];
$FareBreakdown[$keys]['GSTonComm'] += $values['GSTonComm'];
$FareBreakdown[$keys]['ServiceFee'] += $values['ServiceFee'];
$FareBreakdown[$keys]['CommisionPass'] += $values['CommisionPass'];
$FareBreakdown[$keys]['intGTXMarkUp'] += $values['intGTXMarkUp'];
$FareBreakdown[$keys]['GTXMarkUpGST'] += $values['GTXMarkUpGST'];
$FareBreakdown[$keys]['AdditionalTxnFeeOfrd'] += $values['AdditionalTxnFeeOfrd'];
$FareBreakdown[$keys]['AdditionalTxnFeePub'] += $values['AdditionalTxnFeePub'];
$FareBreakdown[$keys]['PGCharge'] += $values['PGCharge'];
$FareBreakdown[$keys]['Baggage'] = $values['Baggage'];
$FareBreakdown[$keys]['CabinBaggage'] = $values['CabinBaggage'];
}
}
if ($value['couponApply']) {
$couponVal += isset($value['couponVal']) ? $value['couponVal'] : 0;
}
}
}
//echo"<pre>";print_r($FareBreakdown);die;
$FlightBookingData[0] = $API_Response;
if ($API_ResponseInb) {
$FlightBookingData[1] = $API_ResponseInb;
}
$travellerInfosarr = [];
if ($travellerInfos && $ICSourceSysId == 3) {
foreach ($travellerInfos as $key => $value) {
$travellerInfos[$key] = $value;
$travellerInfos[$key]['pnrDetails'] = $pnrDetails;
//$travellerInfos[$key]['ticketNumberDetails'] = $value['Ticket']['TicketId'];
}
}
//echo"<pre>"; print_r(implode('-',$Flight));echo '</pre>';
// echo"<pre>ddd"; print_r($FlightBooking__);echo '</pre>';
if (isset($getSupportContact['EmailId']) && !empty($getSupportContact['EmailId'])) {
$MasterPrimaryEmail = trim($getSupportContact['EmailId']);
} else {
$MasterPrimaryEmail = $getAgencyData['PrimaryEmail'];
}
if (isset($getSupportContact['ContactNo1']) && !empty($getSupportContact['ContactNo1'])) {
$PrimaryMobileNo = trim($getSupportContact['ContactNo1']);
} else {
$PrimaryMobileNo = $getAgencyData['PrimaryMobileNo'];
}
if (isset($getSupportContact['countrycode']) && !empty($getSupportContact['countrycode'])) {
$countrycode = trim($getSupportContact['countrycode']);
} else {
$countrycode = $getAgencyData['countrycode'];
}
?>
<!DOCTYPE html>
<html>
<head lang="en">
<meta charset="UTF-8">
<title>INVOICE</title>
<link href="https://fonts.googleapis.com/css?family=Lato&display=swap" rel="stylesheet">
<link rel="shortcut icon" href="<?php echo $baseUrl ?>public/upload/<?php echo $stylecss ?>/images/favicon.ico">
</head>
<style>
@media print {
@page {
margin-top: 0;
margin-bottom: 0;
}
body {
padding-top: 72px;
padding-bottom: 72px;
}
}
</style>
<body onload="window.print();">
<table cellpadding="0" cellspacing="0" border="0" width="900px" style="margin: auto; border: 1px solid #eaeaea; padding: 5px; font-family: Roboto, sans-serif; font-size: 12px; color: #827878; word-spacing: 2px;">
<tr>
<td align="left" valign="top" style="padding: 4px 5px;">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="font-family: Roboto, sans-serif; font-size: 12px; color: #827878; word-spacing: 2px;">
<tr>
<td align="left" valign="middle" style="font-size: 17px; font-weight: bold; padding: 10px; ">
<span style="float: left; line-height: 40px; margin-right: 10px;"><img src="<?= $baseUrl ?>public/upload/<?php echo $stylecss ?>/images/logo_email.png" /></span>
</td>
<td align="center" valign="middle"> <span style="font-size: 17px; font-weight: bold; line-height: 40px;">INVOICE</span></td>
<td align="right" valign="middle">
<table>
<tr>
<td style="font-size: 17px; font-weight: bold;"><?= $getAgencyData['DisplayName'] ?></td>
</tr>
<tr>
<td><?= $getAgencyData['Address'] ?></td>
</tr>
<tr>
<td>Pin - <?= $getAgencyData['Pincode'] ?></td>
</tr>
<tr>
<td>Pan No. - <?= $getAgencyData['PanCardNo'] ?></td>
</tr>
<tr>
<td>GSTIN Number - <?= $getAgencyData['GSTINFO'] ?> </td>
</tr>
<tr>
<td>Ph No : <?= $countrycode ?><?= $PrimaryMobileNo ?></td>
</tr>
<tr>
<td>Email : <?= $MasterPrimaryEmail ?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center" colspan="3">
<table width="100%" border="0" style="padding:5px 8px; font-size:12px; border: solid 1px #ccc; padding: 0px;" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="56%" rowspan="6" valign="top" style="padding:5px 8px; font-size:12px; border-right: solid 1px #ccc; border-bottom: solid 1px #ccc; font-weight: 600;">
<strong style="font-size: 15px; font-weight: bold;">Customer Name</strong><br>
<?= $billedTo['FirstName'] ?> <?= $billedTo['LastName'] ?><br>
<?= $billedTo['EmailId'] ?> <br>
+<?= $billedTo['countryCode'] ?> <?= $billedTo['Contacts'] ?><br>
<?= $billedTo['Address'] ?>
</td>
<td width="23%" style=" padding:5px 8px; font-size:12px; border-right: solid 1px #ccc; border-bottom: solid 1px #ccc; font-weight: 600;">Invoice No.</td>
<td width="21%" style=" padding:5px 8px; font-size:12px; border-right: solid 1px #ccc; border-bottom: solid 1px #ccc; font-weight: 600;"><?= $FlightBooking['data']['InvoiceNo']; ?></td>
</tr>
<tr>
<td style="padding:5px 8px; font-size:12px; border-right: solid 1px #ccc; border-bottom: solid 1px #ccc; font-weight: 600;">Invoice Date</td>
<td valign="middle" style="padding:5px 8px; font-size:12px; border-right: solid 1px #ccc; border-bottom: solid 1px #ccc; font-weight: 600;"><?= date("d-m-Y", strtotime($FlightBooking['data']['created_at'])); ?></td>
</tr>
<tr>
<td style="padding:5px 8px; font-size:12px; border-right: solid 1px #ccc; border-bottom: solid 1px #ccc; font-weight: 600;">Booking ID</td>
<td style="padding:5px 8px; font-size:12px; border-right: solid 1px #ccc; border-bottom: solid 1px #ccc; font-weight: 600;"><?= $FlightBooking['data']['BookingId'] ?> </td>
</tr>
<tr>
<td style="padding:5px 8px; font-size:12px; border-right: solid 1px #ccc; border-bottom: solid 1px #ccc; font-weight: 600;">Client GST</td>
<td style="padding:5px 8px; font-size:12px; border-right: solid 1px #ccc; border-bottom: solid 1px #ccc; font-weight: 600;"><?= $this->gstnumber ?></td>
</tr>
</tbody>
</table>
</td>
</tr>
<!-- <tr>
<td align="center" valign="middle" width="30%" style="font-size: 17px; font-weight: bold; padding: 10px;">
<span style="float: left; line-height: 40px;"> Invoice No. : <span style=" font-size: 15px; text-transform: capitalize; font-weight: 600; color:#2191d0;"><?= $FlightItinerary['InvoiceNo'] ?></span></span>
</td>
<td align="left" valign="middle" width="30%" style="font-size: 17px; font-weight: bold; padding: 10px;">
<span style=" font-size: 15px; text-transform: capitalize; font-weight: 600; color:#2191d0;"><?= $Data['onward']['PNR_Number'] ?>/<?= $Data['onward']['BookingId'] ?></span>
</td>
<td align="right" valign="middle" width="30%" style="font-size: 13px; font-weight: bold; padding: 10px; color: #988c8c; line-height: 20px;">
Invoice Date: <br> <?= $Data['onward']['created_at'] ?>
</td>
</tr> -->
</table>
</td>
</tr>
<tr>
<td align="left" style=" padding: 4px 5px;" valign="top">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="border: 1px solid #eaeaea; font-family: Roboto, sans-serif; font-size: 12px; color: #827878; word-spacing: 2px;">
<tr>
<td align="left" valign="middle" width="100%" style="padding: 4px 5px;">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="font-family: Roboto, sans-serif; font-size: 12px; color: #827878; word-spacing: 2px;">
<tr bgcolor="#f7f7f7 ">
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">S No.</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">Ticket/PNR No</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">Sectors</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">Flight</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">PAX Name</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">Base Fare</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">OT Tax</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">K3/GST</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">YQ Tax</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">Bag.Ch.</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">Meal Ch.</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">Seat Ch.</td>
<td align="center" valign="middle" style="font-size: 12px; font-weight: bold; color: #727477; border: 1px solid #eaeaea; padding: 4px 5px;">Service Fee</td>
</tr>
<?php
$TotalFare = 0;
$TotalServiceFee = 0;
$TotalGST = 0;
$TotalAmount = 0;
$sl = 0;
$TotalMealFare = 0;
$TotalBaggFare = 0;
$TotalSeatFare = 0;
if ($API_Response['FairRules']['FareBreakdown']) {
//echo"<pre>";print_r($API_Response['FairRules']['FareBreakdown']);die;
foreach ($API_Response['FairRules']['FareBreakdown'] as $k => $values) {
$value = isset($FareBreakdown[$k]) ? $FareBreakdown[$k] : [];
//echo '<pre>';print_r($value);echo '</pre>';
$PassengerCount = $value['PassengerCount'];
$valueInb = [];
//
for ($i = 0; $i < $PassengerCount; $i++) {
//$Salutation = $ARR_SALUTION[$passenger[$sl]['Salutation']];
if ($passenger[$sl]['paxType'] == 1) {
$paxType = 'Adult';
$Salutation = $ARR_SALUTION[$passenger[$sl]['Salutation']];
} elseif ($passenger[$sl]['paxType'] == 2) {
$paxType = 'Child';
$Salutation = $ARR_SALUTION_CHILD[$passenger[$sl]['Salutation']];
} else {
$paxType = 'Infant';
$Salutation = $ARR_SALUTION_CHILD[$passenger[$sl]['Salutation']];
}
$paxName = $Salutation . '. ' . $passenger[$sl]['FirstName'] . ' ' . $passenger[$sl]['LastName'];
$pnrDetails = $travellerInfos[$sl]['pnrDetails'];
$ticketNumberDetails = $travellerInfos[$sl]['ticketNumberDetails'];
$ssrBaggageInfos = [];
$ssrMealInfos = [];
$ssrSeatInfos = [];
if (isset($travellerInfos[$sl]['ssrBaggageInfos'])) {
$ssrBaggageInfos = $travellerInfos[$sl]['ssrBaggageInfos'];
}
if (isset($travellerInfos[$sl]['ssrMealInfos'])) {
$ssrMealInfos = $travellerInfos[$sl]['ssrMealInfos'];
}
if (isset($travellerInfos[$sl]['ssrSeatInfos'])) {
$ssrSeatInfos = $travellerInfos[$sl]['ssrSeatInfos'];
}
$sector = implode("<br>", array_keys($pnrDetails));
$PNRNumber = implode("<br>", $pnrDetails);
$BaggageAdd = [];
$MealDynamicAdd = [];
$SeatDynamicAdd = [];
if ($ICSourceSysId == 3) {
$TicketId = $travellerInfos[$i]['Ticket']['TicketId'];
$TicketNumber = $travellerInfos[$i]['Ticket']['TicketNumber'];
$ValidatingAirline = $travellerInfos[$i]['Ticket']['ValidatingAirline'];
$BaggageAdd = isset($travellerInfos[$sl]['Baggage']) ? $travellerInfos[$sl]['Baggage'] : [];
$MealDynamicAdd = isset($travellerInfos[$sl]['MealDynamic']) ? $travellerInfos[$sl]['MealDynamic'] : [];
$SeatDynamicAdd = isset($travellerInfos[$sl]['SeatDynamic']) ? $travellerInfos[$sl]['SeatDynamic'] : [];
}
$TaxIN = (($value['TaxIN'] + $valueInb['TaxIN']) / $PassengerCount);
$inttotalgst = (($value['intTotalGST'] + $valueInb['intTotalGST']) / $PassengerCount);
$TDS = (($value['TDS'] + $valueInb['TDS']) / $PassengerCount);
$MF = (($value['MF'] + $valueInb['MF']) / $PassengerCount);
$MFT = (($value['MFT'] + $valueInb['MFT']) / $PassengerCount);
$OT = (($value['OT'] + $valueInb['OT']) / $PassengerCount);
$YQ = (($value['YQ'] + $valueInb['YQ']) / $PassengerCount);
$YR = (($value['YR'] + $valueInb['YR']) / $PassengerCount);
$AGST = (($value['AGST'] + $valueInb['AGST']) / $PassengerCount);
if ($ICSourceSysId == 3) {
$YQ = 0;
}
//$other = $MF + $MFT + $OT + $YR + $AGST;
//$mf + $YQ + $AGST + $MFT + $OT + $YR;
$basefare = ($value['BaseFare'] + $valueInb['BaseFare']);
$BaseFareCal = (($basefare) / $PassengerCount);
$MU = (($value['MU'] + $valueInb['MU']) / $PassengerCount);
$FixedMarkUp = (($value['FixedMarkUp'] + $valueInb['FixedMarkUp']) / $PassengerCount);
$GSTOnMarkUp = (($value['GSTOnMarkUp'] + $valueInb['GSTOnMarkUp']) / $PassengerCount);
$CommisionPass = (($value['CommisionPass'] + $valueInb['CommisionPass']) / $PassengerCount);
$ServiceFee = (($value['ServiceFee'] + $valueInb['ServiceFee']) / $PassengerCount);
$TotalServiceFee += $FixedMarkUp;
//$TotalGST += $GSTOnMarkUp;
$IntCommission = (($value['IntCommission'] + $valueInb['IntCommission']) / $PassengerCount);
$CommissionEarned = (($value['CommissionEarned'] + $valueInb['CommissionEarned']) / $PassengerCount);
$apiMarkup = ($value['apiMarkup'] / $PassengerCount);
//$ServiceFee = ($value['ServiceFee'] / $PassengerCount);
if ($ICSourceSysId == 8) {
$TotalGST += ($apiMarkup);
} else {
$TotalGST += ($GSTOnMarkUp);
}
$OTTax = ($MF + $MFT + $OT);
if ($ICSourceSysId == 3) {
$OTTax = ($MF + $MFT + $MU + $OT + $ServiceFee);
}
if ($ICSourceSysId == 3) {
$TotalTaxsandFees = ($MF + $YQ + $AGST + $MFT + $OT + $TDS + $MU + $ServiceFee + $YR - $CommisionPass);
$TotalFare += ($BaseFareCal + $TotalTaxsandFees);
$TotalAmount += ($BaseFareCal + $OTTax + $AGST + $YQ + $FixedMarkUp + $GSTOnMarkUp + $YR + $apiMarkup + $TDS - $CommisionPass);
} else {
$TotalFare += ($BaseFareCal + $OTTax + $AGST + $YQ + $YR + $IntCommission - $CommissionEarned);
if ($ICSourceSysId == 8) {
$TotalAmount += ($BaseFareCal + $OTTax + $AGST + $YQ + $FixedMarkUp + $GSTOnMarkUp + $YR + $apiMarkup + $IntCommission - $CommissionEarned);
} else {
$TotalAmount += ($BaseFareCal + $OTTax + $AGST + $YQ + $FixedMarkUp + $GSTOnMarkUp + $YR + $IntCommission - $CommissionEarned);
}
}
$MealFare = 0;
$BaggFare = 0;
$SeatFare = 0;
// echo '<pre>';print_r($pnrDetails);echo '</pre>';
//$TaxIN = $value['TaxIN'];
if ($AgencySysId == '12577') {
// echo '<pre>';print_r($TotalAmount);echo '</pre>';
// echo '<pre>';print_r($OTTax);echo '</pre>';
// echo '<pre>';
// print_r(($MF + $YQ + $AGST + $MFT + $OT + $MU + $YR + $IntCommission - $CommissionEarned));
// echo '</pre>';
}
?>
<tr>
<td align="center" valign="top" style="padding: 4px 5px;"><?= $sl + 1 ?>.</td>
<td align="center" valign="middle" style="padding: 4px 5px;">
<?php
if (array_keys($pnrDetails) && ($ICSourceSysId == 7 || $ICSourceSysId == 8 || $ICSourceSysId == 17 || $ICSourceSysId == 16)) {
foreach (array_keys($pnrDetails) as $sec) {
$Baggage = isset($ssrBaggageInfos[$sec]) ? $ssrBaggageInfos[$sec] : [];
$Meal = isset($ssrMealInfos[$sec]) ? $ssrMealInfos[$sec] : [];
$Seat = isset($ssrSeatInfos[$sec]) ? $ssrSeatInfos[$sec] : [];
$BaggFare += isset($Baggage['amount']) ? $Baggage['amount'] : '0';
$MealFare += isset($Meal['amount']) ? $Meal['amount'] : '0';
$SeatFare += isset($Seat['amount']) ? $Seat['amount'] : '0';
$ticketNumber = isset($ticketNumberDetails[$sec]) ? '(' . $ticketNumberDetails[$sec] . ')' : '';
?>
<div><span><?= $pnrDetails[$sec] ?> <?= $ticketNumber ?></span></div>
<?php
}
} else {
if ($BaggageAdd) {
foreach ($BaggageAdd as $m => $val) {
$BaggFare += isset($val['Price']) ? $val['Price'] : 0;
// if (isset($MealDynamicAdd[$m]) && !empty($MealDynamicAdd[$m])) {
// $MealFare += isset($MealDynamicAdd[$m]['Price']) ? $MealDynamicAdd[$m]['Price'] : 0;
// }
}
}
if ($MealDynamicAdd) {
foreach ($MealDynamicAdd as $m => $val) {
$MealFare += isset($val['Price']) ? $val['Price'] : 0;
}
}
if ($SeatDynamicAdd) {
foreach ($SeatDynamicAdd as $m => $val) {
$SeatFare += isset($val['Price']) ? $val['Price'] : 0;
}
}
echo $TicketId . $ValidatingAirline . ' / ' . $TicketNumber;
}
?>
</td>
<td align="center" valign="middle" style="padding: 4px 5px;"><?= $sector ?></td>
<td align="center" valign="middle" style="padding: 4px 5px;"><?= $API_Response['FlightNumber'] ?><?= ($API_ResponseInb['FlightNumber']) ? ',' . $API_ResponseInb['FlightNumber'] : '' ?></td>
<td align="left" valign="middle" style="padding: 4px 5px;"><span style=" font-size: 12px; text-transform: capitalize; font-weight: 600; color:#2191d0;"><?= $value['FirstName'] ?> <?= $paxName ?></span></td>
<td align="center" valign="middle" style="padding: 4px 5px;"><?= number_format($BaseFareCal * $this->CurrencyRate) ?></td>
<td align="center" valign="middle" style="padding: 4px 5px;">
<?php if ($ICSourceSysId == 3) { ?>
<?= number_format((($TotalTaxsandFees) * $this->CurrencyRate),2) ?>
<?php } else { ?>
<?= number_format((($OTTax + $YR + $IntCommission - $CommissionEarned) * $this->CurrencyRate)) ?>
<?php } ?>
</td>
<td align="center" valign="middle" style="padding: 4px 5px;">
<?= number_format($AGST * $this->CurrencyRate) ?>
</td>
<td align="center" valign="middle" style="padding: 4px 5px;"><?= number_format($YQ * $this->CurrencyRate) ?></td>
<td align="center" valign="middle" style="padding: 4px 5px;"><?= number_format($BaggFare * $this->CurrencyRate) ?></td>
<td align="center" valign="middle" style="padding: 4px 5px;"><?= number_format($MealFare * $this->CurrencyRate) ?></td>
<td align="center" valign="middle" style="padding: 4px 5px;"><?= number_format($SeatFare * $this->CurrencyRate) ?></td>
<td align="center" valign="middle" style="padding: 4px 5px;"><?= number_format($FixedMarkUp * $this->CurrencyRate) ?></td>
</tr>
<?php
$TotalBaggFare += $BaggFare;
$TotalMealFare += $MealFare;
$TotalSeatFare += $SeatFare;
$sl++;
}
}
}
$TotalFare = ($TotalFare + $TotalBaggFare + $TotalMealFare + $TotalSeatFare);
$TotalAmount = ($TotalAmount + $TotalBaggFare + $TotalMealFare + $TotalSeatFare);
?>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" style=" padding: 4px 5px;" valign="top">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="border: 1px solid #eaeaea; font-family: Roboto, sans-serif; font-size: 12px; color: #827878; word-spacing: 2px;">
<tr bgcolor="#f7f7f7 ">
<td align="left" valign="middle" style="font-size: 12px; font-weight: bold; padding: 8px; color: #727477;">Payment Details</td>
</tr>
<tr>
<td align="left" valign="middle" style="padding: 4px 5px;">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="font-family: Roboto, sans-serif; font-size: 12px; color: #827878; word-spacing: 2px;">
<tr>
<td align="left" valign="center" style="padding: 4px 5px;" width="70%"><span style=" font-size: 15px; font-weight: bold; line-height: 25px;">Note : </span>* Voidation and Refund as per fare rules. <br><span style=" font-size: 15px; font-weight: bold;">Billed by : </span> <?= $this->siteName ?></td>
<td align="left" valign="center" style="padding: 4px 5px;" width="30%">
<table cellspacing="0" cellpadding="0" border="0" width="100%" style="font-family: Roboto, sans-serif; font-size: 12px; color: #827878; word-spacing: 2px;">
<tr>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%">Total Fare : </td>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%"><?= $Currency ?> <?= number_format($TotalFare * $this->CurrencyRate) ?></td>
</tr>
<tr>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%">Service Fee : </td>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%"><?= $Currency ?> <?= number_format($TotalServiceFee * $this->CurrencyRate) ?></td>
</tr>
<?php if ($this->gstvalidate['SGST'] == 1) { ?>
<tr>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%">SGST : </td>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%"><?= $Currency ?> <?= number_format(($TotalGST * $this->CurrencyRate / 2)) ?></td>
</tr>
<?php } ?>
<?php if ($this->gstvalidate['CGST'] == 1) { ?>
<tr>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%">CGST : </td>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%"><?= $Currency ?> <?= number_format(($TotalGST * $this->CurrencyRate / 2)) ?></td>
</tr>
<?php } ?>
<?php if ($this->gstvalidate['IGST'] == 1) { ?>
<tr>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%">IGST : </td>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%"><?= $Currency ?> <?= number_format(($TotalGST * $this->CurrencyRate)) ?></td>
</tr>
<?php } ?>
<?php if ($couponvalue > 0) { ?>
<tr>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%">Discount (<?= $couponCode ?>): </td>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%"><?= $Currency ?> <?= number_format($couponvalue * $this->CurrencyRate) ?></td>
</tr>
<?php } ?>
<?php if ($couponApply == 1) { ?>
<tr>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%">Coupon Discount : </td>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%"><?= $Currency ?> <?= number_format($couponVal * $this->CurrencyRate) ?></td>
</tr>
<?php } ?>
<?php if ($IsCancellationProtection == 1) { ?>
<tr>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%">Refund Upgrade : </td>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%"><?= $Currency ?> <?= number_format($CancellationProtectionPrice * $this->CurrencyRate) ?></td>
</tr>
<?php } ?>
<tr>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%"><span style=" font-size: 14px; font-weight: bold;">Total Amount : </span></td>
<td align="left" valign="center" style="border: 1px solid #eaeaea; padding: 4px 5px;" width="50%"><span style=" font-size: 14px; font-weight: bold;"><?= $Currency ?> <?= number_format(ceil((($TotalAmount + $CancellationProtectionPrice - $couponVal) - $couponvalue) * $this->CurrencyRate)) ?></span></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" style=" padding: 4px 5px;" valign="top">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="border: 1px solid #eaeaea; font-family: Roboto, sans-serif; font-size: 14px; color: #827878; word-spacing: 2px;">
<tbody>
<tr bgcolor="#f7f7f7 ">
<td align="left" valign="middle" colspan="2" style="font-size: 14px; font-weight: bold; padding: 8px; color: #727477;">24x7 CUSTOMER SUPPORT</td>
</tr>
<tr>
<td align="left" valign="middle" width="50%" style="padding: 4px 5px;">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="font-family: Roboto, sans-serif; font-size: 14px; color: #827878; word-spacing: 2px;">
<tbody>
<tr>
<td align="left" valign="middle" width="50%" style="padding: 4px 5px;">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="border: 1px solid #eaeaea; font-family: Roboto, sans-serif; font-size: 14px; color: #827878; word-spacing: 2px;">
<tbody>
<tr bgcolor="#f7f7f7 ">
<td valign="middle" align="left" colspan="2" style="font-size: 14px; font-weight: bold; padding: 4px 5px; color: #727477;"><?= $this->siteName ?> Support</td>
</tr>
<tr>
<td align="left" style=" padding:4px 5px;" valign="top" rowspan="2">Telephone</td>
<td align="left" style="border: 1px solid #eaeaea; padding: 4px 5px;" valign="middle"><?= !empty($arrAgencyUserDetail['countrycode']) ? trim($arrAgencyUserDetail['countrycode']) : trim($getAgencyData['countrycode']) ?><?= !empty($arrAgencyUserDetail['ContactNo1']) ? $arrAgencyUserDetail['ContactNo1'] : $getAgencyData['PrimaryMobileNo'] ?></td>
</tr>
<tr>
<td align="left" valign="middle" style=" border: 1px solid #eaeaea; padding: 4px 5px;"> <?= !empty($arrAgencyUserDetail['EmailId']) ? trim($arrAgencyUserDetail['EmailId']) : $getAgencyData['PrimaryEmail'] ?> </td>
</tr>
</tbody>
</table>
</td>
<!-- <td align="left" valign="middle" width="50%" style=" padding: 4px 5px;">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="border: 1px solid #eaeaea; font-family: Roboto, sans-serif; font-size: 14px; color: #827878; word-spacing: 2px;">
<tbody>
<tr bgcolor="#f7f7f7 ">
<td valign="middle" align="left" colspan="2" style="font-size: 14px; font-weight: bold; padding: 4px 5px; color: #727477;">Airline Support</td>
</tr>
<tr>
<td align="left" style=" padding: 4px 5px;" valign="top" rowspan="2">Airlines</td>
<td align="left" style="border: 1px solid #eaeaea; padding: 4px 5px;" valign="middle">1800-0001-5456-51515 (toll free)</td>
</tr>
<tr>
<td align="left" valign="middle" style="border: 1px solid #eaeaea; padding: 4px 5px;"> </td>
</tr>
</tbody>
</table>
</td> -->
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td align="left" style=" padding: 4px 5px;" valign="top">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="border: 1px solid #eaeaea; font-family: Roboto, sans-serif; font-size: 12px; color: #827878; word-spacing: 2px;">
<tr bgcolor="#f7f7f7 ">
<td align="left" valign="middle" style="font-size: 12px; font-weight: bold; padding: 8px; color: #727477;">TERMS & CONDITIONS</td>
</tr>
<tr>
<td align="left" valign="middle" style="padding: 4px 5px;">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="font-family: Roboto, sans-serif; font-size: 12px; color: #827878; word-spacing: 2px;">
<tr>
<td align="left" valign="center" width="100%" style="padding: 4px 5px;">
<ul>
<?php if ($IsCancellationProtection == 1) { ?>
<li style="margin: 10px 0; text-align: justify;">Your have opted refund upgrade with this booking as per given terms & conditions. In case you are unable to attend this booking please submit your claim at <a target="_blank" href="https://www.refundable.me/extended/en" style="text-decoration:underline;color:red;">https://www.refundable.me/extended/en</a> and use reference ID <b><?= $TPSysId ?></b> to submit your refund.</li>
<?php } ?>
<li style="margin: 5px 0; text-align: justify;"><span style=" font-size: 15px; font-weight: bold;">IMP : </span>All Cases & Disputes are subject to <?= $cityName ?> Jurisdiction.</li>
<li style="margin: 5px 0; text-align: justify;"><span style=" font-size: 15px; font-weight: bold;">IMP : </span>Refunds & Cancellations are subject to Airlines approval .</li>
<li style="margin: 5px 0; text-align: justify;"><span style=" font-size: 15px; font-weight: bold;">IMP : </span>Service charges as included above are to be collected from the customers on our behalf.</li>
<li style="margin: 5px 0; text-align: justify;"><span style=" font-size: 15px; font-weight: bold;">CHEQUE : </span>Must be drawn in favour of '<?= $this->siteName ?>'.</li>
<li style="margin: 5px 0; text-align: justify;"><span style=" font-size: 15px; font-weight: bold;">LATE PAYMENT : </span>Interest @ 24% per annum will be charged on all outstanding bills after due date.</li>
<li style="margin: 5px 0; text-align: justify;"><span style=" font-size: 15px; font-weight: bold;">VERY IMP. : </span>Kindly check all details carefully to avoid unnecessary complications.</li>
</ul>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center">Note:- This is an electronically generated invoice and does not require a physical signature</td>
</tr>
</table>
<br /> <br />
<a href="#" onclick="window.print();">Print</a>
</body>
</html>