| 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/controllers/ |
Upload File : |
<?php
class CreatepdfController extends Catabatic_ValidateCustomer {
public function init() {
parent::init();
$request = Zend_Controller_Front::getInstance()->getRequest();
$this->baseUrl = $request->getScheme() . '://' . $request->getHttpHost();
}
public function indexAction() {
$baseUrl = $this->baseUrl;
$tpID = base64_decode($this->getRequest()->getParam('id'));
$model = new Gtxwebservices_Model_GetPackageDetailForCustomer();
$resultSet = $model->getPackageDetailForCustomer($tpID);
// echo "<pre>";print_r($resultSet);exit;
// $this->view->resultSet = $resultSet;
// $this->tcpdf();
$record1 = $resultSet['Result11'];
foreach($record1 as $key => $value11)
{
if(@$value11['Icon'])
{
$icon = $value11['Icon'];
}
if(file_exists('./public/assets/images/inclusions/'.$icon))
{
$image_tag = '<img src="/public/assets/images/inclusions/'.$icon.'" alt="image" height="15px" width="15px"/>';
}
else
{
$image_tag = '';
}
@$icons .= $image_tag;
}
$pdfArray = array();
$pdfArray['PackageName'] = $resultSet['Result1'][0]['Title'];
$pdfArray['InclusionsT'] = $icons;
$pdfArray['Inclusions'] = $resultSet['Result6'][0]['Inclusions'];
$pdfArray['Exclusions'] = $resultSet['Result6'][0]['Exclusions'];
$pdfArray['TermsConditions'] = $resultSet['Result6'][0]['TermsAndConditions'];
$pdfArray['TravelBasics'] = $resultSet['Result6'][0]['TravelBasics'];
$pdfArray['BookingTerm'] = $resultSet['Result6'][0]['BookingTerms'];
$pdfArray['WhyChooseUs'] = $resultSet['Result6'][0]['WhyUseUs'];
$pdfArray['CancellationPolicy'] = $resultSet['Result6'][0]['CancellationPolicy'];
$i = 1;
foreach($resultSet['Result2'] as $key2 => $value2){
if($value2['Title'] != '0'){
$pdfArray['Itinerary'][$i]['Title'] = $value2['Title'];
$pdfArray['Itinerary'][$i]['Program'] = $value2['Details'];
$pdfArray['Itinerary'][$i]['Hotel'] = array();
$hotelCheckArray = array();
foreach ($resultSet['Result3'] as $key3 => $value3) {
if($value2['TPIntSysId'] == $value3['TPIntSysId']){
$hotelCheckArray = $value3[''];
$pdfArray['Itinerary'][$i]['Hotel'][] = $value3['Title'];
}
}
foreach ($resultSet['Result4'] as $key4 => $value4) {
if($value2['TPIntSysId'] == $value4['InvnItemSysId']){
$pdfArray['Itinerary'][$i]['SIGHTSEEING'][] = $value4['Title'];
}
}
$i++;
}
}
// foreach ($getDetail['dayView'] as $itinerariesKey => $itineraries) {
// $count = count($itineraries['day']);
// $pdfArray['Itinerary'][$itinerariesKey]['Title'] = $itineraries['day'][$count-2];
// $pdfArray['Itinerary'][$itinerariesKey]['Program'] = $itineraries['day'][$count-1];
// foreach ($itineraries['Hotel'] as $itinerariesItem) {
// foreach($itinerariesItem['Items'] as $hotelKey => $hotelVal1) {
// foreach($hotelVal1['Item'] as $hotelVal2) {
// if($hotelVal2['IsIncluded'] == true) {
// foreach($hotelHotelArrayU as $hotelId) {
// if($hotelId['RefHotelId'] == $hotelVal2['Id']){
// $pdfArray['Itinerary'][$itinerariesKey]['Hotel'][$hotelKey] = $hotelId['Name'];
// }
// }
// }
// }
// }
// }
// $pdfArray['Itinerary'][$itinerariesKey]['SIGHTSEEING'] = array();
// }
$PackageName = $pdfArray['PackageName'];
$InclusionsT = $pdfArray['InclusionsT'];
//echo "<pre>";print_r($pdfArray);exit;
$Itinerary = "";
$Itinerary .= '<tr>
<td>
<table border="0" cellpadding="0" cellspacing="1">
<tr>
<td bgcolor="#fff">
<table border="0" cellpadding="5" cellspacing="3" bgcolor="#fff">';
foreach($pdfArray['Itinerary'] as $key => $value){
$programVal = $value['Program'];
$titleVal = $value['Title'];
$Itinerary .= '<tr>
<td align="left" valign="middle" bgcolor="#666" style="font-size:14px; color:#fff; padding: 7px 10px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100;"><strong>Day : '.$key.' '.$titleVal.'</strong></td>
</tr>
<tr>
<td align="left" valign="top" style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#222222; padding: 5px 0;">'.$programVal.'</td>
</tr>';
if(!empty($value['Hotel'])) {
$Itinerary .=' <tr>
<td align="left" valign="middle" bgcolor="#fff" style="border-left:6px solid #666; padding: 7px; 10px;font:bold;> <strong style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#444;">HOTEL</strong></td>
</tr>
<tr>
<td style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#222222; padding: 5px 0;">';
foreach($value['Hotel'] as $hkey => $hvalue){
$comma = '';if($hkey > 0){$comma = ", ";}
$Itinerary .=$comma.$hvalue;
}
$Itinerary .=' </td>
</tr>
<tr>
<td> </td>
</tr>';
}
if(!empty($value['SIGHTSEEING'])) {
$Itinerary .=' <tr>
<td align="left" valign="middle" bgcolor="#fff" style="border-left:6px solid #666; padding: 7px; 10px; > <strong style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#444;">SIGHTSEEING</strong></td>
</tr>
<tr><td style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#222222; padding: 5px 0;">';
foreach($value['SIGHTSEEING'] as $skey => $svalue){
$comma = '';if($skey > 0){$comma = ", ";}
$Itinerary .=$comma.$svalue;
}
$Itinerary .=' </td></tr>
<tr>
<td> </td>
</tr>'
;
} }
$Itinerary .= ' </table>
</td>
</tr>
</table>
</td>
</tr>';
$Inclusions = "";
if(isset($pdfArray['Inclusions']) && $pdfArray['Inclusions'] != "") {
$Inclusions .= '<tr>
<td colspan="2">
<table border="0" cellspacing="0" cellpadding="10">
<tr>
<td align="left" valign="middle" bgcolor="#fff" style="border-left:6px solid #666; padding: 7px; 10px; > <strong style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#666;">INCLUSIONS</strong></td>
</tr>
<tr>
<td style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#222222; padding: 5px 0;">
'. html_entity_decode($pdfArray['Inclusions']).'
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>';
} if(isset($pdfArray['Exclusions']) && $pdfArray['Exclusions'] != "") {
$Inclusions .= '<tr>
<td colspan="2">
<table border="0" cellspacing="0" cellpadding="10">
<tr>
<td align="left" valign="middle" bgcolor="#fff" style="border-left:6px solid #666; padding: 7px; 10px; > <strong style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#444;">EXCLUSIONS</strong></td>
</tr>
<tr>
<td style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#222222; padding: 5px 0;">
'.html_entity_decode($pdfArray['Exclusions']).'
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>';
} if(isset($pdfArray['TermsConditions']) && $pdfArray['TermsConditions'] != "") {
$Inclusions .= '<tr>
<td colspan="2">
<table border="0" cellspacing="0" cellpadding="10">
<tr>
<td align="left" valign="middle" bgcolor="#fff" style="border-left:6px solid #666; padding: 7px; 10px; > <strong style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#444;">TERMS AND CONDITIONS</strong></td>
</tr>
<tr>
<td style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#222222; padding: 5px 0;">
'. html_entity_decode($pdfArray['TermsConditions']).'
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>';
} if(isset($pdfArray['CancellationPolicy']) && $pdfArray['CancellationPolicy'] != "") {
$Inclusions .= ' <tr>
<td colspan="2">
<table border="0" cellspacing="0" cellpadding="10">
<tr>
<td align="left" valign="middle" bgcolor="#fff" style="border-left:6px solid #666; padding: 7px; 10px; > <strong style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#444;">CANCELLATION POLICY</strong></td>
</tr>
<tr>
<td style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#222222; padding: 5px 0;">
'. html_entity_decode($pdfArray['CancellationPolicy']).'
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>';
} if(isset($pdfArray['TravelBasics']) && $pdfArray['TravelBasics'] != "") {
$Inclusions .= '<tr>
<td colspan="2">
<table border="0" cellspacing="0" cellpadding="10">
<tr>
<td align="left" valign="middle" bgcolor="#fff" style="border-left:6px solid #666; padding: 7px; 10px; > <strong style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#444;">TRAVEL BASICS</strong></td>
</tr>
<tr>
<td style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#222222; padding: 5px 0;">
'. html_entity_decode($pdfArray['TravelBasics']).'
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>';
} if(isset($pdfArray['BookingTerm']) && $pdfArray['BookingTerm'] != "") {
$Inclusions .= '<tr>
<td colspan="2">
<table border="0" cellspacing="0" cellpadding="10">
<tr>
<td align="left" valign="middle" bgcolor="#fff" style="border-left:6px solid #666; padding: 7px; 10px;> <strong style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#444;">BOOKING TERM</strong></td>
</tr>
<tr>
<td style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#222222; padding: 5px 0;">
'. html_entity_decode($pdfArray['BookingTerm']).'
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>';
} if(isset($pdfArray['WhyChooseUs']) && $pdfArray['WhyChooseUs'] != "") {
$Inclusions .= ' <tr>
<td colspan="2">
<table border="0" cellspacing="0" cellpadding="10">
<tr>
<td align="left" valign="middle" bgcolor="#fff" style="border-left:6px solid #666; padding: 7px; 10px;> <strong style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#444;">WHY CHOOSE US</strong></td>
</tr>
<tr>
<td style="font-size:14px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100; color:#222222; padding: 5px 0;">
' .html_entity_decode($pdfArray['WhyChooseUs']).'
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>';
}
require_once('tcpdf/tcpdf.php');
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// $pdf->Header();
$pdf->SetCreator(PDF_CREATOR);
// set default header data
$image_file = 'images/logo.png';
//$pdf->SetHeaderData("fatehpurSm.jpg", "250", "Application PDF", "Likeslomakkeet - www.likeslomakkeet.net");
$pdf->SetHeaderData( "", "80", "PDF TITLE" , "" );
// set header and footer fonts
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
// $pdf->SetMargins(10, 5, 10);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
if (@file_exists(dirname(__FILE__).'/lang/eng.php')) {
require_once(dirname(__FILE__).'/lang/eng.php');
$pdf->setLanguageArray($l);
}
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetFont('helvetica', '', 10);
$pdf->AddPage();
$html = <<<EOF
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Restitution HTML</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" >
</head>
<body style="padding: 10px; font-size: 10pt;font-family:Arial;">
<table width="650" cellpadding="0" cellspacing="0" align="left">
<tr>
<td colspan="2" > </td>
</tr>
<tr>
<td colspan="2" height="25" align="left" valign="middle" bgcolor="#666" style="border-left:8px solid #666; padding: 5px;"> <strong style="font-size:14px; color:#fff; font-family:Arial, Helvetica, sans-serif !important; font-weight:100">PACKAGE NAME : $PackageName </strong></td>
</tr>
<tr>
<td colspan="2" > </td>
</tr>
<tr>
<td colspan="2" > </td>
</tr>
$Itinerary
$Inclusions
<tr style="font-family:Arial, Helvetica, sans-serif !important; font-weight:100;">
<td colspan="2" valign="top" bgcolor="#FFFFFF" style="border-top:4px solid #666; background:#f9f9f9;">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" align="center"></td>
</tr> <tr>
<td style="font-size:11px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100;">2018 © Agency123 </td>
<td style="font-size:11px; font-family:Arial, Helvetica, sans-serif !important; font-weight:100;" align="right">Technology By: <a href="http://www.hellogtx.com/" target="_blank" style="color:#3b75c9; text-decoration:none">hello<span style="color:#f9655c;">GTX</span></a></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
EOF;
echo $html; exit;
//
// output the HTML content
$pdf->writeHTML($html, true, false, true, false, '');
$filename = "download.pdf";
$pdf->Output($filename, 'I'); // last param : I = open in browser; F = save file in folder; D = force to download
//============================================================+
// END OF FILE
//============================================================+
}
public function Header() {
$this->SetFont('helvetica', 'B', 10);
$this->Cell(0, 25, '', 0, false, 'R', 0, '', 0, false, 'M', 'M');
$image_file = 'images/logo.png';
$this->Image($image_file, 18, 5, 35, '', 'PNG', '', 'T', false, 400, '', false, false, 0, false, false, false);
// Set font
// $this->Cell(0, 15, 'PDF Ti', 0, false, 'C', 0, '', 0, false, 'M', 'M');
}
public function downloadpdfAction(){
$tpID = base64_decode($this->getRequest()->getParam('id'));
$model = new Gtxwebservices_Model_GetPackageDetailForCustomer();
$resultSet = $model->getPackageDetailForCustomer($tpID);
// echo "<pre>";print_r($resultSet);exit;
// $this->view->resultSet = $resultSet;
// $this->tcpdf();
foreach($resultSet['Result1'] as $key => $value){
$Title = $value['Title'];
$PRICE = $value['NetPrice'];
$CITY = $value['Cities'];
}
if( count($resultSet['Result2'])>0){
$citySequenceArr = array();
for ($h = 0; $h < count($resultSet['Result2']); $h++) {
$cityarr[] = $resultSet['Result2'][$h]['Cities'];
}
}
$Destination_covered = count($cityarr)>0 ? stripslashes(implode(", ",array_unique($cityarr))):'NA'; ;
if( count($resultSet['Result3'])>0){
$AccoSysId = array();
for ($h = 0; $h < count($resultSet['Result3']); $h++) {
$AccoSysIdarr[] = $resultSet['Result3'][$h]['Title'];
}
}
$AccoSysId_arr = count($AccoSysIdarr)>0 ? array_unique($AccoSysIdarr):'NA'; ;
//echo "<pre>";print_r($AccoSysId_arr);die;
$record1 = $resultSet['Result11'];
foreach($record1 as $key => $value11)
{
if(@$value11['Icon'])
{
$icon = $value11['Icon'];
}
if(file_exists('./public/assets/images/inclusions/'.$icon))
{
$image_tag = '<img src="/public/assets/images/inclusions/'.$icon.'" alt="image" height="15px" width="15px"/>';
}
else
{
$image_tag = '';
}
@$icons .= $image_tag;
}
$record2 = $resultSet['Result2'];
$counter = 0;
foreach($record2 as $key => $value)
{
if(isset($value['Sequence'])){
$counter += 1;
}
$h =0;
foreach($resultSet['Result3'] as $key => $Hotel_Details)
{
$CITYNAME = $value['Cities'];
$HOTELNAME = $Hotel_Details['Title'];
$ROOMTITLE = $Hotel_Details['RoomTypeStr'];
$STARS = $Hotel_Details['StarRating'];
$i=1;
foreach($Hotel_Details['FromDate'] as $key => $CheckInTime)
{
$CHECKINTIME = date("d-m-Y",strtotime($CheckInTime));
if($i==1){
$CHECKIN = $CHECKINTIME;
}
$i++;
}
$i=1;
foreach($Hotel_Details['ToDate'] as $key => $CheckOutTime)
{
$CHECKOUTTIME = date("d-m-Y",strtotime($CheckOutTime));
if($i==1){
$CHECKOUT = $CHECKOUTTIME;
}
$i++;
}
// if(($value['TPIntSysId'] == $Hotel_Details['TPIntSysId']) && ($value['Sequence'] == $Hotel_Details['SeqId']) ){
if(($value['TPIntSysId'] == $Hotel_Details['TPIntSysId']) && ($Hotel_Details['Title'] == @$AccoSysId_arr[$h]) ){
@$loop2 .= '<tr>
<td colspan="2" align="left" valign="top" bgcolor="#f9f9f9" style="border:1px solid #e5e5e5;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="7">
<tr>
<td style="color:#262626; font:bold 16px Arial, Helvetica, sans-serif; padding:5px 15px; border-bottom:1px solid #d3d4d4;"> '.$CITYNAME.'</td>
</tr>
<tr>
<td valign="top" style="padding:10px 15px; border-bottom:1px solid #d3d4d4;">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="30%" align="left" valign="top" style="color:#6c6c6c; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;"><b> '.$HOTELNAME.' </b></td>
<!--<td align="left" valign="top" style="color:#6c6c6c; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;"><b>Santana beach resort</b></td>-->
<td width="20%" align="left" valign="top" style="color:#262626; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;">Room Type</td>
<td width="20%" ="left" valign="top" style="color:#262626; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;">Rating</td>
<td width="15%" align="left" valign="top" style="color:#262626; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;">Check-in</td>
<td width="15%" align="left" valign="top" style="color:#262626; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;">Check-out</td>
</tr>
<tr>
<!--<td align="left" valign="top" style="color:#f23e03; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;"><a href="#" style="background:#428bca; padding:1px 5px 3px 5px; text-decoration:none; color:#FFF; font-size:12px;">View</a></td>-->
<td width="30%" align="left" valign="top" style="color:#0082b8; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;"></td>
<td width="20%" align="left" valign="top" style="color:#0082b8; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;">'.$ROOMTITLE.'</td>
<td width="20%" align="left" valign="middle" style="color:#0082b8; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;">';
for ($s = 0; $s < 7; $s++)
{
if ($STARS > $s)
{
@$loop2 .= '<img src="/public/assets/images/red-star.png" height="10px" width="10px">';
}
else
{
@$loop2 .= '<img src="/public/assets/images/gray-star.png" height="10px" width="10px">';
}
}
@$loop2 .='</td>
<td width="15%" align="left" valign="top" style="color:#0082b8; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;">'.$CHECKIN.'</td>
<td width="15%" align="left" valign="top" style="color:#0082b8; font:normal 12px/20px Segoe, Arial, Helvetica, sans-serif;">'.$CHECKOUT.'</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="padding:5px 15px;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="7">
<tr>
<td width="17%" align="left" valign="middle" bgcolor="#FFFFFF" style="color:#f23e03; font:bold 13px/20px Segoe, Arial, Helvetica, sans-serif; border:1px solid #e0e0e0; border-right:0px;">Amenities :</td>
<td width="83%" align="left" valign="middle" bgcolor="#ebecec" style="border:1px solid #e0e0e0; border-left:0px;"> ';
$record13 = $resultSet['Result13'];
foreach($record1 as $key => $value11)
{
if(@$value11['Icon'])
{
$icon = $value11['Icon'];
}
if(file_exists('./public/assets/images/inclusions/'.$icon))
{
$image_tag = '<img src="/public/assets/images/inclusions/'.$icon.'" alt="image" height="15px" width="15px"/>';
}
else
{
$image_tag = '';
}
@$loop2 .= $image_tag;
}
@$loop2 .= '</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>';
}
$h++;
}
}
$counter_day = $counter;
$counter_night = $counter_day+1;
$record3 = $resultSet['Result2'];
foreach($record3 as $key => $value)
{
@$DAY = $value['Sequence'];
@$DAYCITYNAME = $value['Cities'];
@$ITENARYNAME = $value['ITENARYNAME'];
@$ITENARYDETAILS = $value['ITENARYDETAILS'];
@$loop3 .= '<tr>
<td align="center" valign="top" bgcolor="#e8e8e8">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="10">
<tr>
<td style="border:1px solid #e0e0e0; color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;">DAY '.$DAY.' <strong style="color:#f23e03;">'.$DAYCITYNAME.'</strong></td>
</tr>
<!-- <tr>
<td align="left" bgcolor="#FFFFFF" style="border:1px solid #e0e0e0; color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;"><strong style="color:#f23e03;"> '.$ITENARYNAME.'</strong><br />'.$ITENARYDETAILS.'</td>
</tr>-->
';
if(($value['Sequence'] == @$resultSet['Result5'][0]['Sequence']) || ($value['Sequence'] == $resultSet['Result4'][0]['SeqId']) ){
@$loop3 .= '<tr>
<td>
<table width="100%" border="0" align="left" cellpadding="7" cellspacing="0">
<tr>
<td width="40%" bgcolor="#d63a07" style="color:#ffffff; font:normal 14px Arial, Helvetica, sans-serif; text-align:center;">Sightseeing / Activities</td>
<td width="60%"> </td>
</tr>
</table>
</td>
</tr>';
}
if(!empty($resultSet['Result5'])){
foreach(@$resultSet['Result5'] as $key => $valuesA)
{
if(($value['Sequence'] == $valuesA['Sequence']) && (trim($valuesA['Type']) == 'Included')){
@$ACTIVITYTITLE = $valuesA['Title'];
@$ACTIVITYDESCRIPTION = $valuesA['WriteUp'];
@$ACTIVITYIMAGE = trim($valuesA['Icon']);
@$loop3 .= '<tr>
<td bgcolor="#FFFFFF" style="border:1px solid #e0e0e0; color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="70%" align="left" style="color:#262626; font:normal 12px/25px Arial, Helvetica, sans-serif;"><strong style="color:#f23e03;">'.$ACTIVITYTITLE.'-</strong> <span style="color:#878787">Activity</span><br />'.$ACTIVITYDESCRIPTION.' </td>
<td width="30%" align="right" ><img src="'.$ACTIVITYIMAGE.'" height="120px" width="120px"/></td>
</tr>
</table>
</td>
</tr>';
}
}
}
if(!empty($resultSet['Result4'])){
foreach(@$resultSet['Result4'] as $key => $valuesB)
{
if(($value['Sequence'] == $valuesB['SeqId']) && (trim($valuesB['Type']) == 'Included')){
@$ACTIVITYTITLE = $valuesB['Title'];
@$ACTIVITYDESCRIPTION = $valuesB['WriteUp'];
@$ACTIVITYIMAGE = trim($valuesB['Icon']);
@$loop3 .= '<tr>
<td bgcolor="#FFFFFF" style="border:1px solid #e0e0e0; color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="70%" align="left" style="color:#262626; font:normal 12px/25px Arial, Helvetica, sans-serif;"><strong style="color:#f23e03;">'.$ACTIVITYTITLE.'-</strong> <span style="color:#878787">Sightseeing</span><br />'.$ACTIVITYDESCRIPTION.' </td>
<td width="30%" align="right" > </td>
</tr>
</table>
</td>
</tr>';
}
}
}
@$loop3 .= '<tr>
<td>
<table width="100%" border="0" align="left" cellpadding="7" cellspacing="0">
<tr>
<td width="30%"> </td>
<td width="40%" bgcolor="#262626" style="color:#ffffff; font:normal 14px Arial, Helvetica, sans-serif; text-align:center;">Overnight at the hotel.</td>
<td width="30%"> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>';
}
$record4 = $resultSet['Result2'];
foreach($record4 as $key => $value)
{
@$DAY = $value['Sequence'];
@$CITY = $value['Cities'];
@$loop4 .= '<tr>
<td align="left" valign="top" style="color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;">Day '.$DAY.'</td>
<td align="left" valign="top" style="color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;">'.$CITY.' <span style="color:#0195d2;">';
if(!empty($resultSet['Result5'])){
foreach(@$resultSet['Result5'] as $key => $valuesA)
{
if(($value['Sequence'] == $valuesA['Sequence']) && (trim($valuesA['Type']) == 'Included')){
$loop4 .= $valuesA['Title'];
}
}
}
foreach(@$resultSet['Result4'] as $key => $valuesB)
{
if(($value['Sequence'] == $valuesB['SeqId']) && (trim($valuesB['Type']) == 'Included')){
$loop4 .= '<strong style="color:#f23e03;">-</strong>'.$valuesB['Title'];
}
}
$loop4 .= '</span>
</td>
</tr>';
}
foreach($resultSet['Result6'] as $key => $value){
// echo "<pre>";print_r($value['TPSysId']);die;
$CANCELLATIONPOLICY = $value['CancellationPolicy'];
$TERMANDCONDITIONS = $value['TermsAndConditions'];
$TRAVELBASICS = $value['TravelBasics'];
$WHYUSEUS = $value['WhyUseUs'];
$BOOKINGTERMS = $value['BookingTerms'];
$INCLUSION = $value['Inclusions'];
$EXCLUSION = $value['Exclusions'];
}
require_once('TCPDF/tcpdf.php');
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// $pdf->Header();
$pdf->SetCreator(PDF_CREATOR);
// set default header data
$image_file = 'images/logo.png';
//$pdf->SetHeaderData("fatehpurSm.jpg", "250", "Application PDF", "Likeslomakkeet - www.likeslomakkeet.net");
$pdf->SetHeaderData( "", "80", "PDF TITLE" , "" );
// set header and footer fonts
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
// $pdf->SetMargins(10, 5, 10);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
if (@file_exists(dirname(__FILE__).'/lang/eng.php')) {
require_once(dirname(__FILE__).'/lang/eng.php');
$pdf->setLanguageArray($l);
}
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetFont('helvetica', '', 10);
$pdf->AddPage();
$html = <<<EOF
<html>
<body>
<div id="page-content" class="text-justify">
<table width="650" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="middle" style="color:#8c8b89; font:normal 11px Arial, Helvetica, sans-serif;"><img src="/public/assets/images/logo_pdf.png" width="150px" height="50px" /></td>
</tr>
<tr>
<td align="center" valign="middle" style="solid #cccccc; padding:5px 0px;">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="85%" align="right" valign="middle" style="color:#8c8b89; font:normal 11px Arial, Helvetica, sans-serif;"><img src="/public/assets/images/arrow_sm.png" /> Travel Proposal for ABC</td>
<td width="15%" align="right" valign="middle" style="color:#8c8b89; font:normal 11px Arial, Helvetica, sans-serif;"><img src="/public/assets/images/arrow_sm.png" /> Ref No:1253</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="10">
<tr>
<td width="55%" align="left" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
<td align="left" valign="top" style="color:#050000; font:normal 20px Segoe, Verdana, Arial, Helvetica, sans-serif;">$Title <strong style="color:#f23f04;"> Package</strong></td>
</tr>
<tr>
<td width="50%" align="left" valign="top">
<table border="0" align="left" cellpadding="10" cellspacing="0">
<tr>
<td bgcolor="#ffffff" style="color:#013bb1; font:normal 12px Segoe, Verdana, Arial, Helvetica, sans-serif; border:1px solid #8c8b89;"> $counter_night Nights , $counter_day DAYS </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="45%" align="right" valign="top">
<table border="0" align="right" cellpadding="10" cellspacing="0">
<tr>
<td align="left" valign="top" style="color:#050000; font:normal 20px Segoe, Verdana, Arial, Helvetica, sans-serif;">Key Inclusions</td>
</tr>
<tr>
<td align="left" valign="top">
<table width="80%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td>$icons</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td bgcolor="#428bca" style="border:1px solid #d5d5d5;">
<table width="100%" border="0" cellspacing="0" cellpadding="7">
<tr>
<td height="35" align="center" valign="middle" style="color:#ffffff; font:normal 18px Segoe, Verdana, Arial, Helvetica, sans-serif;">Program at a glance</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="padding:10px;">
<table width="100%" border="0" cellspacing="0" cellpadding="7">
<tr>
<td width="50%" align="left" valign="top" bgcolor="#ebecec" style="color:#000000; font:normal 16px Segoe, Verdana, Arial, Helvetica, sans-serif; padding:5px; border:1px solid #e5e5e5;">Destination Covered</td>
<td width="50%" align="left" valign="top" bgcolor="#f9f9f9" style="border:1px solid #e5e5e5;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td style="color:#262626; font:bold 16px Arial, Helvetica, sans-serif; padding:10px 15px;"> $Destination_covered</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="5" colspan="2"></td>
</tr>
$loop2
<tr>
<td bgcolor="#428bca" style="border:1px solid #d5d5d5;">
<table width="100%" border="0" cellspacing="0" cellpadding="7">
<tr>
<td height="35" align="center" valign="middle" style="color:#ffffff; font:normal 18px Segoe, Verdana, Arial, Helvetica, sans-serif;">Program Details</td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
$loop3
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td valign="middle" align="center" style="color:#212121; font:bold 18px Arial, Helvetica, sans-serif;">— Overall Inclusions —</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#f1f1f1" style="border:1px solid #e0e0e0;">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#FFFFFF" style="border:1px solid #e0e0e0;">
<table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
<td align="left" style="color:#f23e03; font:normal 12px/25px Arial, Helvetica, sans-serif;">Activities/Sightseeing : -</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
$loop4
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<br>
<tr>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="2%"> </td>
<td width="48%" align="left" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25" align="left" valign="top" style="color:#f23e03; font:normal 12px/20px Arial, Helvetica, sans-sif;">Inclusions</td>
</tr>
<tr>
<td align="left" valign="top" style="color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;">$INCLUSION</td>
</tr>
</table>
</td>
<td width="2%"> </td>
<td width="48%" align="left" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25" align="left" valign="top" style="color:#f23e03; font:normal 12px/20px Arial, Helvetica, sans-serif;">Exclusions</td>
</tr>
<tr>
<td align="left" valign="top" style="color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;">$EXCLUSION</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<br>
<br>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#668ab1">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td align="left" style="color:#ffffff; font:normal 12px/20px Arial, Helvetica, sans-serif;">Estimated Cost</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="7">
<tr>
<td align="left" bgcolor="#FFFFFF" style="color:#262626; font:normal 18px/30px Arial, Helvetica, sans-serif;"><span style="color:#f23e03; font-size:12px;">INR</span> $PRICE</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td valign="top" bgcolor="#f1f1f1" style="border:1px solid #e0e0e0;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center" valign="top" style="color:#f23e03; font:normal 12px/20px Arial, Helvetica, sans-serif;">Booking Terms</td>
</tr>
<tr>
<td align="left" valign="top" style="color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;">$BOOKINGTERMS</td>
</tr>
<tr>
<td height="20"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" bgcolor="#f1f1f1" style="border:1px solid #e0e0e0;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#FFFFFF" style="border:1px solid #e0e0e0;">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td align="center" valign="top" style="color:#f23e03; font:normal 12px/20px Arial, Helvetica, sans-serif;">Why Use — Demo Agency? —</td>
</tr>
<tr>
<td align="left" valign="top" style="color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;"> $WHYUSEUS</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="7">
<tr>
<td height="35" align="center" valign="middle" bgcolor="#428bca" style="color:#ffffff; font:normal 18px Segoe, Verdana, Arial, Helvetica, sans-serif; padding:0;">- Other Information Details -</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td valign="top" bgcolor="#f1f1f1" style="border:1px solid #e0e0e0;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center" valign="top" style="color:#f23e03; font:normal 12px/20px Arial, Helvetica, sans-serif;">- Travel Basics -</td>
</tr>
<tr>
<td align="left" valign="top" style="color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;"> $TRAVELBASICS</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td valign="top" bgcolor="#f1f1f1" style="border:1px solid #e0e0e0;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center" valign="top" style="color:#f23e03; font:normal 12px/20px Arial, Helvetica, sans-serif;">- Terms And Conditions -</td>
</tr>
<tr>
<td align="left" valign="top" style="color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;">$TERMANDCONDITIONS</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td valign="top" bgcolor="#f1f1f1" style="border:1px solid #e0e0e0;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center" valign="top" style="color:#f23e03; font:normal 12px/20px Arial, Helvetica, sans-serif;">- Cancellation Policy -</td>
</tr>
<tr>
<td align="left" valign="top" style="color:#262626; font:normal 12px/20px Arial, Helvetica, sans-serif;">$CANCELLATIONPOLICY</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</body>
</html>
EOF;
echo $html; exit;
//
// output the HTML content
$pdf->writeHTML($html, true, false, true, false, '');
$filename = "download.pdf";
$pdf->Output($filename, 'D'); // last param : I = open in browser; F = save file in folder; D = force to download
}
}