| 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/b2bzend/application/views/scripts/booking-flight/ |
Upload File : |
<?php
error_reporting(0);
$arrStatusType = Zend_Controller_Action_HelperBroker::getStaticHelper('Flight')->getAllStatusType();
$getCustomerDetails = $this->getCustomerDetails;
$arrCustomerInvoiceData = $this->arrCustomerInvoiceData;
$arrtravellerList = $this->arrtravellerList;
$arrAgencyDetail = $this->arrAgencyDetail;
//echo "<pre>";print_r($arrtravellerList);echo "</pre>";
$AgencySysId = $arrCustomerInvoiceData[0]['AgencySysId'];
$RoomInfoJson = $arrCustomerInvoiceData[0]['RoomInfoJson'];
$CompanyName = $arrCustomerInvoiceData[0]['CompanyName'];
$strCompanyAddress = $arrCustomerInvoiceData[0]['CompanyAddress'];
$Pincode = $arrCustomerInvoiceData[0]['Pincode'];
$strCityTitle = $arrCustomerInvoiceData[0]['CityTitle'];
$strCountry = $arrCustomerInvoiceData[0]['Country'];
$PrimaryMobileNo = $arrCustomerInvoiceData[0]['PrimaryMobileNo'];
$PrimaryContactNo = $arrCustomerInvoiceData[0]['PrimaryContactNo'];
$PrimaryEmail = $arrCustomerInvoiceData[0]['PrimaryEmail'];
$companyLogo = $arrCustomerInvoiceData[0]['Logo'];
$TotalTcs = $arrCustomerInvoiceData[0]['TotalTcs'];
$GTXMarkup = $arrCustomerInvoiceData[0]['GTXMarkup'];
$Cost = ($arrCustomerInvoiceData[0]['Cost'] + $GTXMarkup);
$AgencyMarkUp = ($arrCustomerInvoiceData[0]['AgencyMarkUp'] + $arrCustomerInvoiceData[0]['AgencyCommission'] + $arrCustomerInvoiceData[0]['MarkUp']);
$AgentServiceTaxAmount = ($arrCustomerInvoiceData[0]['AgentServiceTaxAmount'] + $arrCustomerInvoiceData[0]['AgentsCustomServiceTaxAmount']);
$TotalCost = $arrCustomerInvoiceData[0]['TotalCost'];
$CurrencySymbol = $arrCustomerInvoiceData[0]['CurrencySymbol'];
$ExtraMarkup = $arrCustomerInvoiceData[0]['ExtraMarkup'];
$ExtraMarkupOnGST = $arrCustomerInvoiceData[0]['ExtraMarkupOnGST'];
$LeadSource = $arrCustomerInvoiceData[0]['LeadSource'];
$AgencyGst = $arrCustomerInvoiceData[0]['AgencyGst'];
$InvoiceNumber = $arrCustomerInvoiceData[0]['InvoiceNumber'];
$InvoiceDate = (array)$arrCustomerInvoiceData[0]['InvoiceDate'];
// echo "<pre>";
// print_r($arrCustomerInvoiceData[0]);
// echo "</pre>";
//customer Details
$arrTrevllerDetails = $this->arrTrevllerDetails;
$intTotalOfferedForAllPaxs = $this->intTotalOfferedForAllPax;
$FirstName = $arrTrevllerDetails[0][0]['FirstName'];
$LastName = $arrTrevllerDetails[0][0]['LastName'];
$Address = $arrTrevllerDetails[0][0]['Address'];
$CityTitle = $arrTrevllerDetails[0][0]['CityTitle'];
$CountryTitle = $arrTrevllerDetails[0][0]['CountryTitle'];
$EmailId = $arrTrevllerDetails[0][0]['EmailId'];
$Contacts = $arrTrevllerDetails[0][0]['Contacts'];
$name = $FirstName . '' . $LastName;
//customer Details
// echo "<pre>";
// print_r($arrCustomerInvoiceData[0]);
// echo "</pre>";
$IsB2BProposal = $arrCustomerInvoiceData[0]['IsB2BProposal'];
$GstNumber = $arrCustomerInvoiceData[0]['GstNumber'];
$JourneyType = $arrCustomerInvoiceData[0]['JourneyType'];
$TBQAirInvenSysId = $arrCustomerInvoiceData[0]['TBQAirInvenSysId'];
$IsInternational = $arrCustomerInvoiceData[0]['IsInternational'];
$TripType = $arrCustomerInvoiceData[0]['TripType'];
$strFlightNumber = $arrCustomerInvoiceData[0]['FlightNumber'];
$strSourceAirportCode = $arrCustomerInvoiceData[0]['SourceAirportCode'];
$strDestAirportCode = $arrCustomerInvoiceData[0]['DestAirportCode'];
$strXRefBookingId = $arrCustomerInvoiceData[0]['XRefBookingId'];
$strAirLineTitle = $arrCustomerInvoiceData[0]['AirLineTitle'];
$strAirLineCode = $arrCustomerInvoiceData[0]['AirLineCode'];
$ICSourceSysId = $arrCustomerInvoiceData[0]['ICSourceSysId'];
if ($IsB2BProposal == 1) {
$Contacts = $arrAgencyDetail['ContactInfo'];
$Address = $arrAgencyDetail['CompanyAddress'];
$EmailId = $arrAgencyDetail['PrimaryEmail'];
$name = $arrCustomerInvoiceData[0]['AgentAgencyName'];
}
$arrBookingId = explode("/", $strXRefBookingId);
$strXRefBookingId = trim($arrBookingId[0]);
$strBookingPNR = trim($arrBookingId[1]);
$strStatusType = $arrCustomerInvoiceData[0]['StatusType'];
$bookingStatus = $arrStatusType[$strStatusType];
if ($IsInternational) {
$intCountryCode = "INTERNATIONAL";
} else {
$intCountryCode = "IN";
}
$arrBookingDate = (array) $arrCustomerInvoiceData[0]['bookingDate'];
//$strBookingDate = Zend_Controller_Action_HelperBroker::getStaticHelper('Flight')->getDateFormatFromDbDates($arrBookingDate['date']);
$arrFromUTCTime = (array) $arrCustomerInvoiceData[0]['FromUTCTime'];
$arrToUTCTime = (array) $arrCustomerInvoiceData[0]['ToUTCTime'];
$XRefBookingId = $arrCustomerInvoiceData[0]['XRefBookingId'];
$sourceDepartueTime = Zend_Controller_Action_HelperBroker::getStaticHelper('Flight')->getDateFormatFromDbDates($arrFromUTCTime['date']);
$destinationArrivalTime = Zend_Controller_Action_HelperBroker::getStaticHelper('Flight')->getDateFormatFromDbDates($arrToUTCTime['date']);
//$arrAPIBookingRes = Zend_Controller_Action_HelperBroker::getStaticHelper('Flight')->json_clean_decode($arrCustomerInvoiceData[0]['APIBookingRes']);
$arrAPIBookingRes = json_decode($arrCustomerInvoiceData[0]['APIBookingRes'], true);
if (isset($arrCustomerInvoiceData[1]['APIBookingRes']) && !empty($arrCustomerInvoiceData[1]['APIBookingRes'])) {
$arrAPIBookingRes1 = json_decode($arrCustomerInvoiceData[1]['APIBookingRes'], true);
$SECTORSINB = trim($arrCustomerInvoiceData[1]['SourceAirportCode']) . '-' . trim($arrCustomerInvoiceData[1]['DestAirportCode']);
}
$arrAPIBookingRes = json_decode($arrCustomerInvoiceData[0]['APIBookingRes'], true);
if (is_array($arrAPIBookingRes)) {
$arrAPIBookingRes = $arrAPIBookingRes;
} else {
$arrAPIBookingRes = json_decode($arrAPIBookingRes, true);
}
$this->CurrencyRate = isset($arrAPIBookingRes['value']['FairRules']['CurrencyRate']) ? $arrAPIBookingRes['value']['FairRules']['CurrencyRate'] : 1;
$couponApply = isset($arrAPIBookingRes['value']['FairRules']['couponApply']) ? $arrAPIBookingRes['value']['FairRules']['couponApply'] : 0;
$couponVal = isset($arrAPIBookingRes['value']['FairRules']['couponVal']) ? $arrAPIBookingRes['value']['FairRules']['couponVal'] : 0;
$couponVal1 = isset($arrAPIBookingRes1['value']['FairRules']['couponVal']) ? $arrAPIBookingRes1['value']['FairRules']['couponVal'] : 0;
if ($couponApply) {
$couponVal = $couponVal + $couponVal1;
} else {
$couponVal = 0;
}
// echo "<pre>";
// print_r($arrAPIBookingRes);
// echo "</pre>";
// die;
$arrPassenger = isset($arrAPIBookingRes['Response']['Response']['FlightItinerary']['Passenger']) ? $arrAPIBookingRes['Response']['Response']['FlightItinerary']['Passenger'] : '';
$Segments = isset($arrAPIBookingRes['Response']['Response']['FlightItinerary']['Segments']) ? $arrAPIBookingRes['Response']['Response']['FlightItinerary']['Segments'] : '';
$InvoiceNo = isset($arrAPIBookingRes['Response']['Response']['FlightItinerary']['InvoiceNo']) ? $arrAPIBookingRes['Response']['Response']['FlightItinerary']['InvoiceNo'] : '';
$InvoiceCreatedOn = isset($arrAPIBookingRes['Response']['Response']['FlightItinerary']['InvoiceCreatedOn']) ? $arrAPIBookingRes['Response']['Response']['FlightItinerary']['InvoiceCreatedOn'] : '';
$CancellationCharges = isset($arrAPIBookingRes['Response']['Response']['FlightItinerary']['CancellationCharges']) ? $arrAPIBookingRes['Response']['Response']['FlightItinerary']['CancellationCharges'] : '';
$FareRuleDetails = isset($arrAPIBookingRes['Response']['Response']['FlightItinerary']['FareRules']) ? $arrAPIBookingRes['Response']['Response']['FlightItinerary']['FareRules'] : '';
$strBookingDate = Zend_Controller_Action_HelperBroker::getStaticHelper('Flight')->getDateFormatFromDbDates($InvoiceCreatedOn);
$intAdultsCT = 0;
$intChildsCT = 0;
$intInfantsCT = 0;
$paxTOtalArr = json_decode($RoomInfoJson);
if (!empty($paxTOtalArr)) {
foreach ($paxTOtalArr as $PaxTotal) {
$intAdultsCT += @$PaxTotal->Adult;
$intChildsCT += @$PaxTotal->Child;
$intInfantsCT += @$PaxTotal->Infant;
$departuredate = @$PaxTotal->departuredate;
$returndate = trim(@$PaxTotal->returndate);
$totalmember = trim(@$PaxTotal->totalmember);
}
}
$intTatalPaxCTForMarkUp = $intAdultsCT + $intChildsCT + $intInfantsCT;
$API_Response = $arrAPIBookingRes['value'];
if ($arrAPIBookingRes1) {
$API_ResponseInb = $arrAPIBookingRes1['value'];
}
$status = $arrAPIBookingRes['response']['order']['status'];
$travellerInfos = $arrAPIBookingRes['response']['itemInfos']['AIR']['travellerInfos'];
$SECTORS = trim($arrCustomerInvoiceData[0]['SourceAirportCode']) . '-' . trim($arrCustomerInvoiceData[0]['DestAirportCode']);
if ($IsInternational == 1 && $TripType == 2) {
if (isset($arrAPIBookingRes['value']['InternationalData']['Fare']['FareBreakdown'])) {
$FareBreakdown = $arrAPIBookingRes['value']['InternationalData']['Fare']['FareBreakdown'];
} elseif (isset($arrAPIBookingRes['value']['InternationalData']['FairRules']['FareBreakdown'])) {
$FareBreakdown = $arrAPIBookingRes['value']['InternationalData']['FairRules']['FareBreakdown'];
} else {
$FareBreakdown = $API_Response['FairRules']['FareBreakdown'];
}
//$FareBreakdown = $arrAPIBookingRes['value']['InternationalData']['Fare']['FareBreakdown'];
} else {
$FareBreakdown = $API_Response['FairRules']['FareBreakdown'];
}
if ($IsInternational == 1 && $TripType == 2 && $ICSourceSysId != 9 && $ICSourceSysId != 8) {
$CustomeSegment = [];
foreach ($arrAPIBookingRes['value']['InternationalData']['Segments'] as $seg) {
foreach ($seg as $val) {
$CustomeSegment[] = $val;
}
}
} else {
$CustomeSegment = $arrAPIBookingRes['value']['Segments'];
}
$sectorArr = [];
$sectorArrInb = [];
if ($CustomeSegment) {
foreach ($CustomeSegment as $key => $value) {
$sectorKey = $value['originAirportCode'] . '-' . $value['destinationAirportCode'];
$sectorArr[$sectorKey] = $value['originAirportCode'] . '-' . $value['destinationAirportCode'];
$sectorKeyinb = $value['destinationAirportCode'] . '-' . $value['originAirportCode'];
$sectorArrInb[$sectorKeyinb] = $value['destinationAirportCode'] . '-' . $value['originAirportCode'];
}
}
if ($TripType == 3) {
$CustomeSegment = [];
$FareBreakdown = [];
if ($arrCustomerInvoiceData) {
foreach ($arrCustomerInvoiceData as $values) {
$arrAPIBookingRes = json_decode($values['APIBookingRes'], true);
$Segments__ = $arrAPIBookingRes['value']['Segments'];
$FairRules = $arrAPIBookingRes['value']['FairRules']['FareBreakdown'];
foreach ($Segments__ as $seg) {
$CustomeSegment[] = $seg;
}
foreach ($FairRules as $sk => $fare) {
//$FareBreakdown[$sk] = $fare;
$FareBreakdown[$sk]['Currency'] = $fare['Currency'];
$FareBreakdown[$sk]['PassengerType'] = $fare['PassengerType'];
$FareBreakdown[$sk]['PassengerCount'] = $fare['PassengerCount'];
$FareBreakdown[$sk]['TaxIN'] += $fare['TaxIN'];
$FareBreakdown[$sk]['BaseFareCal'] += $fare['BaseFareCal'];
$FareBreakdown[$sk]['BaseFare'] += $fare['BaseFare'];
$FareBreakdown[$sk]['CommissionEarned'] += $fare['CommissionEarned'];
$FareBreakdown[$sk]['TDS'] += $fare['TDS'];
$FareBreakdown[$sk]['MF'] += $fare['MF'];
$FareBreakdown[$sk]['YQ'] += $fare['YQ'];
$FareBreakdown[$sk]['AGST'] += $fare['AGST'];
$FareBreakdown[$sk]['MFT'] += $fare['MFT'];
$FareBreakdown[$sk]['OT'] += $fare['OT'];
$FareBreakdown[$sk]['MU'] += $fare['MU'];
$FareBreakdown[$sk]['YR'] += $fare['YR'];
$FareBreakdown[$sk]['AddiTaxOnMarkup'] += $fare['AddiTaxOnMarkup'];
$FareBreakdown[$sk]['AddiMarkup'] += $fare['AddiMarkup'];
$FareBreakdown[$sk]['intTotalGST'] += $fare['intTotalGST'];
$FareBreakdown[$sk]['apiMarkup'] += $fare['apiMarkup'];
$FareBreakdown[$sk]['IntCommission'] += $fare['IntCommission'];
$FareBreakdown[$sk]['apiTaxOnMarkup'] += $fare['apiTaxOnMarkup'];
$FareBreakdown[$sk]['FixedMarkUp'] += $fare['FixedMarkUp'];
$FareBreakdown[$sk]['GSTOnMarkUp'] += $fare['GSTOnMarkUp'];
$FareBreakdown[$sk]['CommEarned'] += $fare['CommEarned'];
$FareBreakdown[$sk]['GSTonComm'] += $fare['GSTonComm'];
$FareBreakdown[$sk]['intGTXMarkUp'] += $fare['intGTXMarkUp'];
$FareBreakdown[$sk]['GTXMarkUpGST'] += $fare['GTXMarkUpGST'];
$FareBreakdown[$sk]['ExtraMarkup'] += $fare['ExtraMarkup'];
$FareBreakdown[$sk]['ExtraMarkupOnGST'] += $fare['ExtraMarkupOnGST'];
$FareBreakdown[$sk]['DiscountCoupon'] = $fare['DiscountCoupon'];
$FareBreakdown[$sk]['DiscountValue'] += $fare['DiscountValue'];
$FareBreakdown[$sk]['AdditionalTxnFeeOfrd'] += $fare['AdditionalTxnFeeOfrd'];
$FareBreakdown[$sk]['AdditionalTxnFeePub'] += $fare['AdditionalTxnFeePub'];
$FareBreakdown[$sk]['PGCharge'] += $fare['PGCharge'];
$FareBreakdown[$sk]['Baggage'] = $fare['Baggage'];
$FareBreakdown[$sk]['CabinBaggage'] = $fare['CabinBaggage'];
}
}
}
}
$AddTotalCost = 0;
if ($arrCustomerInvoiceData) {
foreach ($arrCustomerInvoiceData as $vl) {
$AddTotalCost += isset($vl['AddTotalCost']) ? $vl['AddTotalCost'] : 0;
}
}
$TaxLabel = 'NA';
if ($this->TaxLabelId == 1) {
$TaxLabel = 'GSTIN';
} elseif ($this->TaxLabelId == 2) {
$TaxLabel = 'VAT';
}
// echo '<pre>';
// print_r($FareBreakdown);
// echo '</pre>';
//die;
?>
<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/html">
<head>
<title>INVOICE</title>
<link rel="shortcut icon" href="<?php echo $this->baseUrl('public/assets/images/ico/fab.ico'); ?>">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js" type="text/javascript"> </script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/jquery-ui.min.js">
</script>
</head>
<body>
<style>
.alert {
padding: 15px;
margin-bottom: 20px;
border: 1px solid transparent;
border-radius: 2px;
}
.alert-success {
color: #333333;
background-color: #d9edf7;
border-color: #bce8f1;
}
.alert-warning {
color: #333333;
background-color: #ffffff;
border-color: #faebcc;
}
th {
text-align: left;
}
@media(max-width:992px) {
td {
font-size: 11px;
}
}
@media print {
@page {
margin-top: 0;
margin-bottom: 0;
}
body {
padding-top: 72px;
padding-bottom: 72px;
}
}
</style>
<table width="800px" align="center" border="0" style="border:1px solid #e2e2e2;" cellspacing="0" cellpadding="5">
<tr>
<td style="border-bottom:3px solid #e2e2e2;">
<table width="100%" style="font-family: arial, sans-serif; color: #000; font-size: 9pt;">
<tr>
<td align="left" valign="top">
<a href="javascript:void(0);">
<img style="max-height: 68px;" src="<?php echo $this->baseUrl('public/upload/media/agency/' . $AgencySysId . '/' . $companyLogo); ?>" alt="" title="" border="0" />
</a>
</td>
<td align="center" valign="top"> </td>
<td align="right" valign="top">
<table style="font-family: arial, sans-serif; color: #000; font-size: 8pt; line-height: 1em">
<tr>
<td style="font-size:18px; font-weight:bold; color:#1077c5; padding-bottom:10px;" align="right"><?php echo $CompanyName; ?></td>
</tr>
<tr>
<td align="right"><?php echo $strCompanyAddress; ?><br />
<?php echo $strCityTitle; ?> <?php echo $strCountry; ?><br />
<strong>Pin :</strong> <?php echo $Pincode; ?><br />
<strong>Ph No :</strong> <?php echo $PrimaryContactNo; ?> ,
<?php echo $PrimaryMobileNo; ?><br />
<strong>Email :</strong> <a href="#" style="font-size:12px;color:#ff6600;"><?php echo $PrimaryEmail; ?></a><br /><br />
<strong><?= $TaxLabel ?> :</strong> <?php echo $AgencyGst; ?><br />
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#E2E2E2">
<tr>
<td bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" style="color: #000; font:bold 15px Arial, Helvetica, sans-serif;">INVOICE </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td style="color: #000; font:normal 13px Arial, Helvetica, sans-serif;" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25%" style="font:bold 13px Arial, Helvetica, sans-serif;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td style="font:bold 13px Arial, Helvetica, sans-serif;">To
</td>
</tr>
<tr>
<td style="font:normal 13px Arial, Helvetica, sans-serif; font-weight:600;">
<?= $name ?> </td>
</tr>
<tr>
<td style="font:normal 13px Arial, Helvetica, sans-serif;">
Address: <?= $Address ?> </td>
</tr>
<tr>
<td style="font:normal 13px Arial, Helvetica, sans-serif;">
Email: <?= $EmailId ?> </td>
</tr>
<tr>
<td style="font:normal 13px Arial, Helvetica, sans-serif;">
Mobile: <?= $Contacts ?> </td>
</tr>
</table>
</td>
<td width="44%" style="font:bold 13px Arial, Helvetica, sans-serif;" align="center">Booking ID<br> <?= $XRefBookingId ?></td>
<td width="26%" style="font:normal 13px Arial, Helvetica, sans-serif;" align="right">
Invoice No.: <?= $InvoiceNumber ?><br>
Invoice Date:
<?= date('d-M-Y', strtotime($InvoiceDate['date'])) ?><br>
Client <?= $TaxLabel ?>: <?= $GstNumber ?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-bottom: solid 1px #bce8f1; border-right: solid 1px #bce8f1; border-left: solid 1px #bce8f1;">
<tr>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">S
No.</span></td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">Ticket/PNR
No</span></td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">Sectors</span>
</td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">Flight</span>
</td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">PAX
Name</span></td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">Base
Fare</span></td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">OT
Tax</span></td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">K3/GST</span>
</td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">YQ
Tax</span></td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">Bag.Ch.</span>
</td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">Meal
Ch.</span></td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">Seat
Ch.</span></td>
<td align="center" bgcolor="#d9edf7" style="padding:5px;"><span style=" padding:0px; font:bold 10px Arial; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;">OT
Fee</span></td>
</tr>
<?php
$TotalFare = 0;
$TotalServiceFee = 0;
$TotalDiscountValue = 0;
$TotalGST = 0;
$TotalAmount = 0;
$sl = 0;
$TotalMealFare = 0;
$TotalBaggFare = 0;
$TotalSeatFare = 0;
if ($FareBreakdown) {
foreach ($FareBreakdown as $k => $value) {
$PassengerCount = $value['PassengerCount'];
$valueInb = isset($API_ResponseInb['FairRules']['FareBreakdown'][$k]) ? $API_ResponseInb['FairRules']['FareBreakdown'][$k] : [];
if ($TripType == 3) {
$valueInb = [];
}
for ($i = 0; $i < $PassengerCount; $i++) {
$pnrDetails = $travellerInfos[$sl]['pnrDetails'];
$ticketNumberDetails = $travellerInfos[$sl]['ticketNumberDetails'];
$paxName = $travellerInfos[$sl]['ti'] . '. ' . $travellerInfos[$sl]['fN'] . ' ' . $travellerInfos[$sl]['lN'];
$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);
$OT_IN = isset($valueInb['OT']) ? $valueInb['OT'] : $valueInb['TaxBR']['OT'];
$OT_ = isset($value['OT']) ? $value['OT'] : $value['TaxBR']['OT'];
$TaxIN = (($value['TaxIN'] + $valueInb['TaxIN']) / $PassengerCount);
$YR = (($value['YR'] + $valueInb['YR']) / $PassengerCount);
$MF = (($value['MF'] + $valueInb['MF']) / $PassengerCount);
$MFT = (($value['MFT'] + $valueInb['MFT']) / $PassengerCount);
$MU = (($value['MU'] + $valueInb['MU']) / $PassengerCount);
$OT = (($OT_ + $OT_IN) / $PassengerCount);
$TDS = (($value['TDS'] + $valueInb['TDS']) / $PassengerCount);
$BaseFareCal = (($value['BaseFare'] + $valueInb['BaseFare']) / $PassengerCount);
$YQ = (($value['YQ'] + $valueInb['YQ']) / $PassengerCount);
$AGST = (($value['AGST'] + $valueInb['AGST']) / $PassengerCount);
$FixedMarkUp = (($value['FixedMarkUp'] + $valueInb['FixedMarkUp']) / $PassengerCount);
$GSTOnMarkUp = (($value['GSTOnMarkUp'] + $valueInb['GSTOnMarkUp']) / $PassengerCount);
$intTotalGST = (($value['intTotalGST'] + $valueInb['intTotalGST']) / $PassengerCount);
$apiMarkup = (($value['apiMarkup'] + $valueInb['apiMarkup']) / $PassengerCount);
$apiTaxOnMarkup = (($value['apiTaxOnMarkup'] + $valueInb['apiTaxOnMarkup']) / $PassengerCount);
$CommEarned = (($value['CommEarned'] + $valueInb['CommEarned']) / $PassengerCount);
$CommissionEarned = (($value['CommissionEarned'] + $valueInb['CommissionEarned']) / $PassengerCount);
$intGTXMarkUp = (($value['intGTXMarkUp'] + $valueInb['intGTXMarkUp']) / $PassengerCount);
$GTXMarkUpGST = (($value['GTXMarkUpGST'] + $valueInb['GTXMarkUpGST']) / $PassengerCount);
$ExtraMarkup = (($value['ExtraMarkup'] + $valueInb['ExtraMarkup']) / $PassengerCount);
$ExtraMarkupOnGST = (($value['ExtraMarkupOnGST'] + $valueInb['ExtraMarkupOnGST']) / $PassengerCount);
if ($LeadSource == 'Website B2B') {
$ExtraMarkup = 0;
$ExtraMarkupOnGST = 0;
}
$DiscountValue = (($value['DiscountValue'] + $valueInb['DiscountValue']) / $PassengerCount);
$AgentMarkUp = 0; //(($value['AgentMarkUp'] + $valueInb['AgentMarkUp']) / $PassengerCount);
$showintax = ($value['showintax']) ? $value['showintax'] : 0;
//$ProcessingAmount = isset($value['ProcessingAmount']) ? ($value['ProcessingAmount'] + $valueInb['ProcessingAmount']) / $PassengerCount : 0;
//$GSTOnProcessing = isset($value['GSTOnProcessing']) ? ($value['GSTOnProcessing'] + $valueInb['GSTOnProcessing']) / $PassengerCount : 0;
$ProcessingAmount = ($AddTotalCost / count($FareBreakdown) / $PassengerCount);
$GSTOnProcessing = 0;
$ServiceFee = ($intGTXMarkUp + $GTXMarkUpGST);
$OTTax = (($MF + $MFT + $OT + $YR + $AgentMarkUp + $CommEarned + $ProcessingAmount + $GSTOnProcessing) - $CommissionEarned);
$BaseFareCal = ($BaseFareCal);
//$OTTax = ($apiTaxOnMarkup);
$OtherCharges = ($ExtraMarkup + $ExtraMarkupOnGST);
$TotalExtraCharge = ($ExtraMarkup + $ExtraMarkupOnGST);
$TotalAmount += ($BaseFareCal + $OTTax + $AGST + $YQ + $GSTOnMarkUp + $FixedMarkUp + $apiMarkup + $apiTaxOnMarkup + $intGTXMarkUp + $GTXMarkUpGST + $TotalExtraCharge);
if ($showintax == 1) {
$OtherCharges = $OtherCharges;
$ExtraMarkup = 0;
$ExtraMarkupOnGST = 0;
$TotalExtraProfit = $TotalExtraCharge;
$BaseFareCal = $BaseFareCal + $TotalExtraCharge;
} else {
$ExtraMarkup = $ExtraMarkup;
$ExtraMarkupOnGST = $ExtraMarkupOnGST;
$OtherCharges = 0;
$TotalExtraProfit = $ExtraMarkup;
$BaseFareCal = $BaseFareCal;
}
$TotalDiscountValue += ($DiscountValue);
$TotalServiceFee += ($FixedMarkUp + $ExtraMarkup + $apiMarkup);
$TotalGST += ($GSTOnMarkUp + $ExtraMarkupOnGST + $apiTaxOnMarkup);
$TotalFare += (($BaseFareCal + $OTTax + $AGST + $YQ + $intGTXMarkUp + $GTXMarkUpGST));
// $OTTax = ($MF + $MFT + $MU + $OT + $YR);
// $TotalFare += ($BaseFareCal + $OTTax + $AGST + $YQ);
// $TotalServiceFee += $FixedMarkUp;
// $TotalGST += $GSTOnMarkUp;
// $TotalAmount += ($BaseFareCal + $OTTax + $AGST + $YQ + $FixedMarkUp + $GSTOnMarkUp);
$MealFare = 0;
$BaggFare = 0;
$SeatFare = 0;
if (array_keys($pnrDetails)) {
foreach (array_keys($pnrDetails) as $tick => $sec) {
$Newsec = $sec; //isset($sectorArr[$sec]) ? $sectorArr[$sec] : '';
$NewsecInb = isset($sectorArrInb[$sec]) ? $sectorArrInb[$sec] : '';
$Baggage = isset($ssrBaggageInfos[$Newsec]['amount']) ? $ssrBaggageInfos[$Newsec]['amount'] : 0;
$BaggageInb = 0; //isset($ssrBaggageInfos[$NewsecInb]['amount']) ? $ssrBaggageInfos[$NewsecInb]['amount'] : 0;
$Meal = isset($ssrMealInfos[$Newsec]['amount']) ? $ssrMealInfos[$Newsec]['amount'] : 0;
$MealInb = 0; //isset($ssrMealInfos[$NewsecInb]['amount']) ? $ssrMealInfos[$NewsecInb]['amount'] : 0;
$Seat = isset($ssrSeatInfos[$Newsec]['amount']) ? $ssrSeatInfos[$Newsec]['amount'] : 0;
$SeatInb = 0; //isset($ssrSeatInfos[$NewsecInb]['amount']) ? $ssrSeatInfos[$NewsecInb]['amount'] : 0;
$BaggFare += ((float)$Baggage + (float)$BaggageInb) * $this->CurrencyRate;
$MealFare += ((float)$Meal + (float)$MealInb) * $this->CurrencyRate;
$SeatFare += ((float)$Seat + (float)$SeatInb) * $this->CurrencyRate;
}
}
$sector = implode("<br>", array_keys($sectorArr));
$sectorInb = implode("<br>", array_keys($sectorArrInb));
// echo '<pre>';
// print_r($value);
// echo '</pre>';
?>
<tr>
<td align="center" valign="middle"><span style="padding:5px;font-weight: 600;font: 10px Arial;"><?= $sl + 1 ?>.</span>
</td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?php
$ticketNumber = isset($ticketNumberDetails[$SECTORS]) ? '(' . $ticketNumberDetails[$SECTORS] . ')' : '';
$ticketNumberInb = isset($ticketNumberDetails[$SECTORSINB]) ? '(' . $ticketNumberDetails[$SECTORSINB] . ')' : '';
?>
<div><span><?= $PNRNumber ?> <?= $ticketNumber ?>
<?= ($TripType == 2) ? $ticketNumberInb : '' ?></span></div>
</td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?= $sector ?> <br> <?= ($TripType == 2) ? $sectorInb : ''; ?></td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?= $API_Response['FlightNumber'] ?><?= ($API_ResponseInb['FlightNumber']) ? ',' . $API_ResponseInb['FlightNumber'] : '' ?>
</td>
<td align="left" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<span style=" font-size: 11px; text-transform: capitalize; font-weight: normal;"><?= $value['FirstName'] ?>
<?= $paxName ?></span>
</td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?= number_format($BaseFareCal, 2) ?></td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?= number_format($OTTax, 2) ?></td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?= number_format($AGST, 2) ?></td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?= number_format($YQ, 2) ?></td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?= number_format($BaggFare, 2) ?></td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?= number_format($MealFare, 2) ?></td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?= number_format($SeatFare, 2) ?></td>
<td align="center" valign="middle" style=" padding:5px ; font-weight: 600; font: 10px Arial, Helvetica, sans-serif; ">
<?= number_format($ServiceFee, 2) ?></td>
</tr>
<?php
$TotalBaggFare += $BaggFare;
$TotalMealFare += $MealFare;
$TotalSeatFare += $SeatFare;
$sl++;
}
}
}
$TotalFare = ($TotalFare + $TotalBaggFare + $TotalMealFare + $TotalSeatFare);
$TotalAmount = ($TotalAmount + $TotalBaggFare + $TotalMealFare + $TotalSeatFare);
$TotalDiscountValue = ($TotalDiscountValue + $couponVal);
?>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-bottom: solid 1px #bce8f1; border-right: solid 1px #bce8f1; border-left: solid 1px #bce8f1;">
<tr>
<td valign="middle" style="padding:5px;font-weight: 600;font: 12px Arial;line-height: 16px;">
<strong>Note</strong>: * Voidation and Refund as per fare rules
<br /><strong>Billed by</strong>: <?php echo $CompanyName; ?>
</td>
<td align="right" valign="middle" style=" padding:5px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif; ">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="right">
<tr>
<td style=" padding:2px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif;">
Fare :</td>
<td align="right" style=" padding:2px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif;">
<?= $CurrencySymbol ?>
<?= number_format($TotalFare, 2) ?>
</td>
</tr>
<tr>
<td style=" padding:2px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif;">
Service Fee :</td>
<td align="right" style=" padding:2px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif;">
<?= $CurrencySymbol ?>
<?= number_format($TotalServiceFee, 2) ?>
</td>
</tr>
<tr>
<td style=" padding:2px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif;">
<?= ($TaxLabel == 'GSTIN') ? 'GST' : $TaxLabel ?> :</td>
<td align="right" style=" padding:2px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif;">
<?= $CurrencySymbol ?>
<?= number_format($TotalGST, 2) ?>
</td>
</tr>
<tr>
<td style=" padding:2px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif;">
Discount :</td>
<td align="right" style=" padding:2px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif;">
<?= $CurrencySymbol ?>
<?= number_format($TotalDiscountValue, 2) ?>
</td>
</tr>
<?php if ($TotalTcs > 0) { ?>
<tr>
<td style=" padding:2px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif;">
Refund Upgrade :</td>
<td align="right" style=" padding:2px ; font-weight: 600; font: 12px Arial, Helvetica, sans-serif;">
<?= $CurrencySymbol ?>
<?= number_format($TotalTcs, 2) ?>
</td>
</tr>
<?php } ?>
<tr>
<td style=" padding:5px 2px; font-weight: 600; font:bold 12px Arial, Helvetica, sans-serif;">
Total Amount :</td>
<td align="right" style=" padding:5px 2px ; font-weight: 600; font:bold 12px Arial, Helvetica, sans-serif;">
<?= $CurrencySymbol ?>
<?= number_format(ceil($TotalFare + $TotalServiceFee + $TotalGST + $TotalTcs - $TotalDiscountValue), 2) ?>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-bottom: solid 1px #bce8f1; border-right: solid 1px #bce8f1; border-left: solid 1px #bce8f1;">
<tr>
<td colspan="3" style=" padding:5px; font-weight: 600; color:red; font:bold 13px Arial, Helvetica, sans-serif; background: #d9edf7; border-bottom: solid 1px #bce8f1; border-top: solid 1px #bce8f1;border-right: solid 1px #bce8f1;">
Terms & Conditions :</td>
</tr>
<tr>
<td valign="middle" style="padding:5px;">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="font-family: Roboto, sans-serif; font-size: 12px; color: #4f4f50; word-spacing: 2px;">
<?php if ($TotalTcs > 0) { ?>
<tr>
<td align="left" valign="center" width="100%" style="padding: 4px 5px;">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><?= base64_decode($this->intTPSysId) ?></b> to submit
your refund.
</td>
</tr>
<?php } ?>
<tr>
<td align="left" valign="center" width="100%" style="padding: 4px 5px;"><?= $this->FlightInvoice ?></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="right">
<a href="#" style="background: #FF4906;font:bold 12px Arial, Helvetica, sans-serif; color:#fff;padding:7px 10px;text-decoration: none;border-radius: 5px;-moz-border-radius: 5px;-o-border-radius: 5px;-webkit-border-radius: 5px;" id="emailTicket" class="SendMail">Send Mail</a>
<a href="#" style="background: #FF4906;font:bold 12px Arial, Helvetica, sans-serif; color:#fff;padding:7px 10px;text-decoration: none;border-radius: 5px;-moz-border-radius: 5px;-o-border-radius: 5px;-webkit-border-radius: 5px;" id="printTicket" class="printMe">Print</a>
<a target="_blank" href="/booking-flight/download-customer-invoicetj/id/<?= ($this->intTPSysId) ?>" style="background: #FF4906;font:bold 12px Arial, Helvetica, sans-serif; color:#fff;padding:7px 10px;text-decoration: none;border-radius: 5px;-moz-border-radius: 5px;-o-border-radius: 5px;-webkit-border-radius: 5px;" id="printTicket" withprice="2" class="dddd">Download</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<input type="hidden" id="intTPSysId" value="<?= $this->intTPSysId ?>" />
<input type="hidden" id="version" value="<?= $this->version ?>" />
<div id="emailBlock" class="width-200 display-none" style="display: none; position: absolute; z-index: 500; left: 60%; top: 50%;">
<div style="float: left; border: 1px solid #D7DFF4; background: #fff; border-radius: 8px; -webkit-border-radius: 8px; -ms-border-radius: 8px; width: 240px; padding-bottom: 1%; box-shadow: 2px 2px 3px #D5DCEF;">
<div style="background: #FFFFFF; border: 3px solid #DEE4F6; border-radius: 10px; cursor: pointer; float: right; font-size: 0; height: 8px; margin: -10px -6px 0 0; padding: 5px; width: 8px;">
<img alt="Close" id="emailClose" src="<?php echo $this->baseUrl('public/images/close.png'); ?>" width="10" />
</div>
<div style="float: left; width: 90%; padding: 5%;">
<span id="emailMsg" style="font-size: 10px; height: 20px; margin-left: 11px;"></span>
<div style="float: left; font-weight: bold; padding-bottom: 15px; width: 100%; margin-left: 10px; font-family: arial;">
<span style="width: 150px; float: left; font-size: 12px; padding-bottom: 10px;">Enter
email address :</span>
<input id="addressBox" name="" type="text" style="width: 180px; padding: 3px;" />
</div>
<div style="float: left; width: 80%; text-align: left; margin-left: 10px;">
<input id="sendEmail" type="button" value="Send mail" style="margin-right: 10px;" />
<input id="emailCancel" type="button" value="Cancel" />
</div>
</div>
</div>
</div>
<script>
$('.printMe').click(function() {
$("#emailmessage").hide();
$('.SendMail').hide();
$('.printMe').hide();
window.print();
$('.SendMail').show();
$('.printMe').show();
});
//Show Block of Email
$("#emailTicket").click(function(e) {
e.preventDefault();
$("#emailBlock").show();
$("#addressBox").val("")
$("#addressBox").focus();
$("#emailMsg").html("");
return false;
});
$("#emailCancel").click(function() {
$("#emailBlock").hide();
$("#emailMsg").html("");
});
$("#emailClose").click(function() {
$("#emailBlock").hide();
$("#emailMsg").html("");
});
//Code for sending Email
$("#sendEmail").click(function(e) {
e.preventDefault();
var emailReg = /^([\w-\.]+@([\w-]+\.)+[\w-]{2,4})?$/;
if ($.trim($("#addressBox").val()) == "") {
$("#emailMsg").html("Please enter emailId .");
$("#emailMsg").css('color', 'red');
$("#addressBox").focus();
return;
}
if (!emailReg.test($("#addressBox").val())) {
$("#emailMsg").html("Please enter valid emailId .");
$("#emailMsg").css('color', 'red');
$("#addressBox").focus();
return;
}
$("#emailMsg").html("Please wait, email is sending ...");
$("#emailMsg").css('color', 'blue');
$("#sendEmail").hide();
var intTPSysId = $("#intTPSysId").val();
var version = $("#version").val();
var emailId = $("#addressBox").val();
$.ajax({
type: "POST",
url: "/booking-flight/sendinvoice",
data: {
intTPSysId: intTPSysId,
version: version,
emailId: emailId
},
success: function(response) {
var guestArr = JSON.parse(response);
if (guestArr.success) {
alert("Email sent successfully.");
$("#emailBlock").hide();
} else {
$("#emailMsg").css('color', 'red');
$("#emailMsg").html("Email is not sent. Error: ");
$("#emailMsg").css('color', 'red');
}
},
//success: ShowEmailDetails,
error: function(XMLHttpRequest, textStatus, errorThrown) {
$("#emailMsg").html("Email is not sent. Error: ");
$("#emailMsg").css('color', 'red');
//error message
}
});
});
</script>
</body>
</html>