File: //home/cafsindia/allyindian_com/backend/customers/bend/availability_callback.php
<?php
require_once('../sbltt_lib/sblttObject.php');
$sbltt_session = sblttObject::newObject('sbltt_session');
$sbltt_session->startSession();
$libObject = sblttObject::newObject('sbltt_customer');
$dbObject = $libObject->getDBObject();
$frm = "";
if(isset($_POST['frm'])){
$frm = $_POST['frm'];
}
if($frm === "get_package_date"){
$package_id = "";
if(isset($_POST['package_id'])){
$package_id = $_POST['package_id'];
}
$date_info = $dbObject->query("package","package_id='$package_id'","dep_date");
$date_rslt = $dbObject->result($date_info);
echo json_encode(array('sts' => TRUE, 'result' =>$date_rslt));
}else
if($frm === "get_package_data"){
if(isset($_POST['package_id'])){
$package_id = $_POST['package_id'];
if(isset($_SESSION['package_id'])){
$sbltt_session->set_value("package_id",$package_id);
}else{
$sbltt_session->add_value("package_id",$package_id);
}
}
if(isset($_POST['package_date'])){
$package_date = $_POST['package_date'];
$package_date = date("d-M-Y",strtotime($package_date));
$s_date = date("Y-m-d",strtotime($package_date));
if(isset($_SESSION['package_date'])){
$sbltt_session->set_value("package_date",$s_date);
}else{
$sbltt_session->add_value("package_date",$s_date);
}
}
$db = $dbObject->get_db();
$pack_qry = "SELECT * FROM sblttweb_vehicletrips inner join sblttweb_package on sblttweb_package.package_id = sblttweb_vehicletrips.trippackid inner join sblttweb_vehicle on sblttweb_vehicle.vehicle_id = sblttweb_vehicletrips.vehicleid
left join sblttweb_veh_type on sblttweb_veh_type.veh_type_id = sblttweb_vehicle. vehicle_type where sblttweb_package.package_id = '$package_id' and sblttweb_package.status = '1' and sblttweb_vehicletrips.status='1'";
$result_qry = mysqli_query($db,$pack_qry);
$tr_line = "";
$seat = "";
$seatnocol_low = "";
$i = 1;
$sno = 1;
while($value = mysqli_fetch_assoc($result_qry)){
$date = $package_date;
$tripid = $value['tripid'];
if(isset($_SESSION['trip_id'])){
unset($_SESSION['trip_id']);
}
$sbltt_session->add_value("trip_id",$tripid);
$tripcode = $value['tripcode'];
$seat_capacity = $value['seat_capacity'];
$package_id = $value['package_id'];
$package_title = $value['package_title'];
$package_title2 = $value['package_title2'];
$veh_type = $value['veh_type'];
$vehicle_id = $value['vehicle_id'];
$discount = $value['discount'];
$vehiclemodel = $value['vehiclemodel'];
$discountdetail = 0;
if($discount){
$discountdetail = $value['discountdetail'];
}
if(isset($_SESSION['discount'])){
unset($_SESSION['discount']);
}
$sbltt_session->add_value("discount",$discountdetail);
//Get Booked and blocked Seats
$blocked_qry = $dbObject->runQuery("SELECT count(*) as blocked FROM sblttweb_seatquotanew where qutripid = '$tripid' and qupackdate = '$s_date' and quseatstat = '2'");
$blocked_rslt = $dbObject->result($blocked_qry);
$blocked = $blocked_rslt[0]->blocked;
$booked_qry = $dbObject->runQuery("SELECT count(sblttweb_passlist.passid) as booked FROM sblttweb_passlist inner join sblttweb_ticketorder on sblttweb_ticketorder.orderid = sblttweb_passlist.ticketorderid where passtripid = '$tripid' and doj = '$s_date' and (passstatus = '0' or passstatus = '2') and sblttweb_passlist.pnrno > 0 and orderstat IN (1,2,4)");
$booked_rslt = $dbObject->result($booked_qry);
$booked = (int)$booked_rslt[0]->booked + (int)$blocked;
$available = (int)$seat_capacity - (int)$booked;
//Get Boarding Details Session
$board_qry = "SELECT * FROM sblttweb_boarding inner join sblttweb_boarding_point on sblttweb_boarding_point.board_point_id = sblttweb_boarding.board_point_id where sblttweb_boarding.package_id = '$package_id' and sblttweb_boarding.status = '1' order by sblttweb_boarding.dep_time ASC";
$result = mysqli_query($db,$board_qry);
$option = "<option value =''>--- Select Boarding ---</option>";
$count = 0;
while($rslt = mysqli_fetch_assoc($result)){
if($count === 0){
$start = $rslt['boarding_name'];
}
$board_id = $rslt['boarding_id'];
$board_name = $rslt['boarding_name'];
$dep_time = $rslt['dep_time'];
$option .= "<option value ='$board_id'>$dep_time - $board_name</option>";
$count++;
}
//Package Tariff Cost Session
$tariff_qry = "SELECT * FROM sblttweb_packcost inner join sblttweb_package_type on sblttweb_package_type.package_type_id = sblttweb_packcost.packtypeid where sblttweb_packcost.packid = '$package_id' and pcoststatus = '1'";
$tariff_result = mysqli_query($db,$tariff_qry);
$option_t = "<option value =''>--- Select Tariff ---</option>";
while($t_rslt = mysqli_fetch_assoc($tariff_result)){
$pcostid = $t_rslt['pcostid'];
$packtype_name = $t_rslt['package_type'];
$pamount = $t_rslt['pamount'];
$option_t .= "<option value ='$pamount|$pcostid'>$pamount - $packtype_name</option>";
}
$view_btn = "<a role='button' data-toggle='collapse' data-parent='#accordion' href='#pack$tripid' class='btn btn-outline-danger btn-sm 'style='border: 1px solid #d8343f; color: #d8343f;font-weight:bold;' id='$tripid' onclick=get_seat_layout('$vehicle_id','$tripid')> View Seat </a>";
if((int)$available === 0){
$view_btn = "";
}//$('#'+holder_id).hasClass("selected_sl")
if($discount === "1"){
$discount_tr = "<tr><td class='sb_bold sb_nowrap'>Discount</td>
<td class='sb_bold sb_color sb_right' id='discount$tripid'>0</td>
</tr>";
}else{
$discount_tr = "";
}
$tr_line .= "
<div class='panel panel-default'>
<div class='panel-heading' role='tab' style='background-color:#FFFFFF;border-radius: 4px; box-shadow: 0 2px 2px 0 rgba(0,0,0,0.14), 0 3px 1px -2px rgba(0,0,0,0.12), 0 1px 5px 0 rgba(0,0,0,0.2);'>
<table>
<tr>
<td class='sb_left'>
<span class='sb_cl_gray'>Journey Date</span><span class='sb_bold sb_color'> $date</span>
</td>
<td class='sb_center'>
<span class='sb_bold'>$tripcode - $package_title $package_title2</span>
</td>
<td class='sb_right'>
<span class='sb_cl_gray'>Booked</span><span class='sb_bold'> $booked</span>
</td>
<td class='sb_right'>
<a class='sb_color' onclick=pack_info() style='cursor: pointer;'> Pack Info <i class='fa fa-info-circle fa-1x' aria-hidden='true'></i></a>
</td>
</tr>
<tr>
<td class='sb_bold sb_left'>
<span class='sb_cl_gray'>Boarding Start</span> $start
</td>
<td class='sb_bold sb_center'><span class='sb_cl_gray'>Vehicle</span> $veh_type $vehiclemodel</td>
<td class='sb_right'>
<span class='sb_cl_gray'>Available</span><span class='sb_bold'> $available</span>
</td>
<td class='sb_right'> $view_btn </td>
</tr>
</table>
</div>
<div id='pack$tripid' class='panel-collapse collapse' role='tabpanel'>
<div class='row' style='margin:0px;padding:8px;'>
<div class='col-md-8' style='background-color:#FFFFFF;'>
<div class='row' style='margin:0px;'>
<div class='col-md-12' style='margin-bottom: 15px;'>
<table style='font-size: 12px;'>
<tr>
<td class='sb_bold sb_right'>Available</td>
<td>
<img style='padding:2px;height:25px;width:25px;' src='./asset/images/seats/available_seat.png'>
<img style='padding: 0px;height:25px;width:25px;' src='./asset/images/seats/available_sl.png'>
</td>
<td class='sb_bold sb_right'>Booked Seats</td>
<td>
<img style='padding: 2px;height:25px;width:25px;' src='./asset/images/seats/cus_booked_seat.png'>
<img style='padding: 0px;height:25px;width:25px;' src='./asset/images/seats/cus_booked_sl.png'>
</td>
</tr>
</table>
</div>
<div class='col-md-12 seat_arrage' style='overflow:auto;margin-left: -20px;' id='seat_layout$tripid'>
</div>
</div>
</div>
<div class='col-md-4' align='center' id='booking_btn' title='Link Detail in Tooltip'>
<div class='row cancel_bg' style='padding: 8px; box-shadow: 0 2px 2px 0 rgba(0,0,0,0.14), 0 3px 1px -2px rgba(0,0,0,0.12), 0 1px 5px 0 rgba(0,0,0,0.2);margin: 8px 0px;'> <button type='submit' id='formsubmit$tripid' class='btn btn-default formsubmit' onclick=formsubmit() style='font-weight: bold !important; height: 40px !important; border-radius: 2px !important; color: #D8343F !important; background-color: #ffffff !important; background-image: none !important; border: 1px solid #FFFFFF !important;' data-toggle='tooltip' data-html='true' title='Click here to Book Tickets'>Going to Booking Page</button>
</div>
</div>
</div>
</div>";
}
echo "<div class='panel-group' id='accordion' role='tablist' aria-multiselectable='true'>$tr_line</div>";
}else
if($frm === "get_seat_layout"){
if(isset($_POST['vehicle_id'])){
$vehicle_id = $_POST['vehicle_id'];
}
if(isset($_POST['trip_id'])){
$trip_id = $_POST['trip_id'];
}
$seat_layout_qry = "SELECT * FROM sblttweb_vehicle where sblttweb_vehicle.vehicle_id = '$vehicle_id'";
$db = $dbObject->get_db();
$result_qry = mysqli_query($db,$seat_layout_qry);
$seat = "";
$seatnocol_low = "";
$i = 1;
$sno = 1;
$seat_array = "";
while($value = mysqli_fetch_assoc($result_qry)){
$seat_capacity = $value['seat_capacity'];
//Vehicle Data for Seat Allocation
$vehicle_id = $value['vehicle_id'];
$seat_type = $value['seat_type'];
$multi_type = $value['multi_type'];
//Upper seat data
$no_of_seats_up = $value['no_of_seats_up'];
$seats_per_row_up = $value['seats_per_row_up'];
$seats_in_last_row_up = $value['seats_in_last_row_up'];
//Lower seats data
$no_of_seats_low = $value['no_of_seats_low'];
$seats_per_row_low = $value['seats_per_row_low'];
$seats_in_last_row_low = $value['seats_in_last_row_low'];
$lower = $value['vehicle_lower'];
$upper = $value['vehicle_upper'];
if($seat_type === "1"){
$class = "available click";
}else
if($seat_type === "2"){
$class = "available_sl click";
}else
if($seat_type === "3"){
$class = "seater_sl click";
}
$seat_array = "seat_no_".$trip_id."[]";
if($multi_type === "1"){
//Lower
$low_nos = $no_of_seats_low;
$nospr_low = $seats_per_row_low;
$noslr_low = $seats_in_last_row_low;
$seatnocol_low = "";
$fseat_low = $low_nos - $noslr_low;
$totrows_low = $nospr_low+1;
$coldiv_low = ceil($fseat_low / $nospr_low);
$colms_low = $coldiv_low + 1;
$pathrow_low = ceil($nospr_low/2)+1;
if($nospr_low === $noslr_low){
$nocolumn_low = $colms_low * $nospr_low;
}else{
$nocolumn_low = ($colms_low * $nospr_low) + ($noslr_low - $nospr_low);
}
//Upper seats
$nos_up = $no_of_seats_up;
$nospr_up = $seats_per_row_up;
$noslr_up = $seats_in_last_row_up;
$seatnocol = "";
$fseat_up = $nos_up - $noslr_up;
$totrows_up = $nospr_up + 1;
$coldiv_up = ceil($fseat_up / $nospr_up);
$colms_up = $coldiv_up + 1;
$pathrow_up = ceil($nospr_up / 2)+1;
if($nospr_up == $noslr_up){
$nocolumn_up = $colms_up * $nospr_up;
}else{
$nocolumn_up = ($colms_up * $nospr_up) + ($noslr_up - $nospr_up);
}
$seat .= "<table cellpadding='2' cellspacing='2'>";
$seat .= "<h5 style='text-align:center;color:#D8343F;font-weight:bold;'>Lower Desk</h5>
<table cellpadding='2' cellspacing='2'>"; ?>
<?php
//$sno = 1;
$nobox = 0;
for($i=1;$i<=$totrows_low;$i++){
if($i == 1){ ?>
<?php $seat .="<tr>
<td style='padding: 2px 0px;' rowspan='$totrows_low' valign='top'><img src='./asset/images/driver.png' width='35' height='35' /></td>"; ?>
<?php for($j=1;$j<=$colms_low;$j++){ ?>
<?php $seat .="<td><img id='seatno_lower$trip_id' onclick=clicked($trip_id) name='seatno_lower[]' class='$class' /><input type='checkbox' name='$seat_array' id='seat_no$trip_id' value='' hidden><span name='seat[]' id='seat$trip_id' style='display: none;'></span></td>"; ?>
<?php $sno = $sno+1;
$nobox = $nobox+1;
}
?>
<?php $seat .="</tr>"; ?>
<?php }
elseif($i == $pathrow_low){
if($nospr_low == $noslr_low){
$colsp = $colms_low;
?>
<?php $seat .="<tr><td colspan='$colsp'>Path Way</td></tr>"; ?>
<?php }else{
$colsp = $colms_low-1;
?>
<?php $seat .="<tr>
<td colspan='$colsp'>Path Way</td>
<td><img id='seatno_lower$trip_id'onclick=clicked($trip_id) name='seatno_lower[]' class='$class' /><input type='checkbox' name='$seat_array' id='seat_no$trip_id' value='' hidden><span name='seat[]' id='seat$trip_id' style='display: none;'></span></td>
</tr>"; ?>
<?php $sno = $sno+1;
$nobox = $nobox+1;
}
}else{ ?>
<?php $seat .="<tr>"; ?>
<?php for($j=1;$j<=$colms_low;$j++){ ?>
<?php $seat .="<td><img id='seatno_lower$trip_id' name='seatno_lower[]' onclick=clicked($trip_id) class='$class' /><input type='checkbox' name='$seat_array' id='seat_no$trip_id' value='' hidden><span name='seat[]' id='seat$trip_id' style='display: none;'></span></td>"; ?>
<?php $sno = $sno+1;
$nobox = $nobox+1;
} ?>
<?php $seat .="</tr>"; ?>
<?php }
}
?>
<?php $seat .="</table>
<h5 style='text-align: center; color: #D8343F; font-weight: bold; border-top: 1px dashed #D8343F; margin-top: 15px; padding: 8px;'>Upper Desk</h5>
<table style='margin-left: 8%;width: 92%;' cellpadding='2' cellspacing='2'>"; ?>
<?php
$sno = 1;
$nobox = 0;
for($k=1;$k<=$totrows_up;$k++){
if($k == 1){ ?>
<?php $seat .="<tr>
<td style='padding: 2px;' rowspan='$totrows_up' valign='top'></td>"; ?>
<?php for($l=1;$l<=$colms_up;$l++){ ?>
<?php $seat .="<td><img id='seatno_upper$trip_id' name='seatno_upper[]' class='$class'onclick=clicked($trip_id) /><input type='checkbox' name='$seat_array' id='seat_no$trip_id' value='' hidden><span name='seat[]' id='seat$trip_id' style='display: none;'></span></td>"; ?>
<?php $sno = $sno+1;
$nobox = $nobox+1;
}
?>
<?php $seat .="</tr>"; ?>
<?php }
else if($k == $pathrow_up){
if($nospr_up == $noslr_up){
$colsp = $colms_up;
?>
<?php $seat .="<tr><td colspan='$colsp'>Path Way</td></tr>"; ?>
<?php }else{
$colsp = $colms_up - 1;
?>
<?php $seat .="<tr>
<td colspan='<?php echo $colsp?>'>Path Way</td>
<td><img id='seatno_upper$trip_id' name='seatno_upper[]' onclick=clicked($trip_id) class='$class' /><input type='checkbox' name='$seat_array' id='seat_no$trip_id' value='' hidden><span name='seat[]' id='seat$trip_id' style='display: none;'></span></td>
</tr>"; ?>
<?php $sno = $sno+1;
$nobox = $nobox+1;
}
}else{ ?>
<?php $seat .="<tr>"; ?>
<?php for($l=1;$l<=$colms_up;$l++){ ?>
<?php $seat .="<td><img id='seatno_upper$trip_id' name='seatno_upper[]' onclick=clicked($trip_id) class='$class' /><input type='checkbox' name='$seat_array' id='seat_no$trip_id' value='' hidden><span name='seat[]' id='seat$trip_id' style='display: none;'></span></td>"; ?>
<?php $sno = $sno+1;
$nobox = $nobox+1;
} ?>
<?php $seat .="</tr>"; ?>
<?php }
}
?>
<?php $seat .="</table>"; ?>
<?php
}else
if($multi_type === "2"){
$low_nos = $no_of_seats_low;
$nospr_low = $seats_per_row_low;
$noslr_low = $seats_in_last_row_low;
$fseat_low = $low_nos - $noslr_low;
$totrows_low = $nospr_low+1;
$coldiv_low = ceil($fseat_low / $nospr_low);
$colms_low = $coldiv_low + 1;
$pathrow_low = ceil($nospr_low/2)+1;
if($nospr_low === $noslr_low){
$nocolumn = $colms_low * $nospr_low;
}else{
$nocolumn = ($colms_low * $nospr_low) + ($noslr_low - $nospr_low);
}
$seat .= "<table cellpadding='2' cellspacing='2'>";
?>
<?php
$nobox = 0;
for($i=1;$i<=$totrows_low;$i++){
if($i == 1){ ?>
<?php
$seat .="<tr>
<td style='padding: 2px 0px;' rowspan='$totrows_low' valign='top'><img src='./asset/images/driver.png' width='35' height='35' /></td>"; ?>
<?php for($j=1;$j<=$colms_low;$j++){ ?>
<?php
$seat .="<td><img id='seatno_lower$trip_id' name='seatno_lower[]' class='$class' onclick=clicked($trip_id) /><input type='checkbox' name='$seat_array' id='seat_no$trip_id' value='' hidden><span name='seat[]' id='seat$trip_id' style='display: none;'></span></td>";
?>
<?php $sno = $sno+1;
$nobox = $nobox+1;
}
?>
<?php $seat .="</tr>"; ?>
<?php }
elseif($i == $pathrow_low){
if($nospr_low == $noslr_low){
$colsp = $colms_low;
?>
<?php $seat .="<tr><td colspan='$colsp'>Path Way</td></tr>"; ?>
<?php }else{
$colsp = $colms_low - 1;
?>
<?php
$seat .="<tr>
<td colspan='$colsp'>Path Way</td>
<td><img id='seatno_lower$trip_id' name='seatno_lower[]' onclick=clicked($trip_id) class='$class' /><input type='checkbox' class='removeseat' name='$seat_array' id='seat_no$trip_id' value='' hidden><span name='seat[]' id='seat$trip_id' style='display: none;'></span></td>
</tr>"; ?>
<?php $sno = $sno + 1;
$nobox = $nobox + 1;
}
}else{
$seat .="<tr>"; ?>
<?php for($j=1;$j<=$colms_low;$j++){ ?>
<?php
$seat .="<td><img id='seatno_lower$trip_id' name='seatno_lower[]' class='$class' onclick=clicked($trip_id) /><input type='checkbox' name='$seat_array' id='seat_no$trip_id' value='' hidden><span name='seat[]' id='seat$trip_id' style='display: none;'></span></td>"; ?>
<?php $sno = $sno+1;
$nobox = $nobox+1;
} ?>
<?php $seat .="</tr>" ?>
<?php }
}
?>
<?php $seat .="</table>"; ?>
<?php } ?>
<?php
}
echo $seat;
}else
if($frm === "get_vehicle_data"){
if(isset($_POST['vehicle_id'])){
$vehicle_id = $_POST['vehicle_id'];
}
$package_id = $sbltt_session->get_value('package_id');
$package_date = $sbltt_session->get_value('package_date');
if(isset($_POST['trip_id'])){
$trip_id = $_POST['trip_id'];
}
$emp_id = 1;
$seat_qry = "SELECT *,(SELECT GROUP_CONCAT(quseat SEPARATOR ',') from sblttweb_seatquotanew where qupackid ='$package_id' and qupackdate = '$package_date' and quseatstat = '2' and qutripid = '$trip_id') as blocked,(SELECT GROUP_CONCAT(quseat SEPARATOR ',') from sblttweb_seatquotanew where qupackid ='$package_id' and qupackdate = '$package_date' and (quseatstat = '1' or quseatstat = '0') and qutripid = '$trip_id') as active,(SELECT GROUP_CONCAT(quseat SEPARATOR ',') from sblttweb_seatquotanew where qupackid ='$package_id' and qupackdate = '$package_date' and quseatstat = '2' and qutripid = '$trip_id' and qublockuserid = '$emp_id') as b_by_u,(SELECT GROUP_CONCAT(seatno SEPARATOR ',') from sblttweb_passlist inner join sblttweb_ticketorder on sblttweb_ticketorder.orderid = sblttweb_passlist.ticketorderid inner join sblttweb_package on sblttweb_package.package_id = sblttweb_ticketorder.packid where doj = '$package_date' and (passstatus = '0' or passstatus = '2') and sblttweb_passlist.pnrno > 0 and orderstat IN (1,2,4) and otripid = '$trip_id') as booked from sblttweb_vehicle where vehicle_id = '$vehicle_id' and status = '1'";
$db = $dbObject->get_db();
$result_qry = mysqli_query($db,$seat_qry);
$seat_data = $dbObject->result($result_qry);
echo json_encode(array('sts' => TRUE, 'seat_data' =>$seat_data));
}else
if($frm === "get_package_details"){
if(isset($_POST['package_id'])){
$package_id = $_POST['package_id'];
}
$pack_qry = $dbObject->runQuery("SELECT * from sblttweb_vehicletrips inner join sblttweb_package on sblttweb_vehicletrips.trippackid = package_id inner join sblttweb_vehicle on sblttweb_vehicle.vehicle_id = sblttweb_vehicletrips.vehicleid inner join sblttweb_veh_type on veh_type_id = vehicle_type where package_id = '$package_id'");
$pack_data = $dbObject->result($pack_qry);
$packcount = count((array)$pack_data);
$trip_line = "";
for($i=0; $i< $packcount; $i++){
$package_title = $pack_data[$i]->package_title;
$package_title2 = $pack_data[$i]->package_title2;
$duration = $pack_data[$i]->duration;
$tripcode = $pack_data[$i]->tripcode;
$veh_type = $pack_data[$i]->veh_type;
$vehiclemodel = $pack_data[$i]->vehiclemodel;
$trip_line .= "<tr><td>$package_title $package_title2</td><td>$tripcode</td><td>$duration</td><td>$veh_type $vehiclemodel</td></tr>";
}
$board_qry = $dbObject->runQuery("SELECT * FROM sblttweb_boarding inner join sblttweb_boarding_point on sblttweb_boarding_point.board_point_id = sblttweb_boarding.board_point_id where sblttweb_boarding.package_id = '$package_id' and sblttweb_boarding.status = '1' order by sblttweb_boarding.dep_time ASC");
$board_data = $dbObject->result($board_qry);
$boardcount = count((array)$board_data);
$board_line = "";
for($i=0; $i< $boardcount; $i++){
$board_name = $board_data[$i]->boarding_name;
$dep_time = $board_data[$i]->dep_time;
$board_line .= "<tr><td>$board_name</td><td>$dep_time</td></tr>";
}
$tariff_qry = $dbObject->runQuery("SELECT * FROM sblttweb_packcost inner join sblttweb_package_type on sblttweb_package_type.package_type_id = sblttweb_packcost.packtypeid where sblttweb_packcost.packid = '$package_id' and pcoststatus = '1'");
$tariff_data = $dbObject->result($tariff_qry);
$tariffcount = count((array)$tariff_data);
$tariff_line = "";
for($i=0; $i< $tariffcount; $i++){
$package_type = $tariff_data[$i]->package_type;
$pamount = $tariff_data[$i]->pamount;
$tariff_line .= "<tr><td>$package_type</td><td>$pamount</td></tr>";
}
$details_qry = $dbObject->runQuery("SELECT * from sblttweb_package inner join sblttweb_itinerary on itpackid = package_id where package_id = '$package_id'");
$it_data = $dbObject->result($details_qry);
$count = count((array)$it_data);
$tr_line = "";
$j=1;
for($i=0; $i< $count; $i++){
$itday = $it_data[$i]->itday;
$itdaydetail = $it_data[$i]->itdaydetail;
$itnight = $it_data[$i]->itnight;
$tr_line .= "<tr><td>$j</td><td>$itday</td><td>$itdaydetail</td><td>$itnight</td></tr>";
$j++;
}
$package_qry = $dbObject->runQuery("SELECT cancelfee from sblttweb_package where package_id = '$package_id'");
$result = $dbObject->result($package_qry);
$cancelfee = $result[0]->cancelfee;
$cancel_qry = $dbObject->runQuery("SELECT * from sblttweb_cancelfee where FIND_IN_SET(cancelfeeid, '$cancelfee')");
$cancelfee_data = $dbObject->result($cancel_qry);
$count = count((array)$cancelfee_data);
$fee_line = "";
for($i=0; $i< $count; $i++){
$cancelfeedetail = $cancelfee_data[$i]->cancelfeedetail;
$cancelfees = $cancelfee_data[$i]->cancelfees;
$fee_line .= "<tr><td>$cancelfeedetail</td><td>$cancelfees %</td></tr>";
}
echo "<div class='pack_info_class'>
<table style='width:100%;border-collapse: collapse;border-spacing: 0;border-color: #CCCCCC !important;border: 0px;text-align: center;font-size: 12px; background-color: #FFFFFF;' border='1' cellspacing='0' cellpadding='4'>
<thead>
<h3 style='font-weight:bold';>Trip Details</h3>
<tr style='background-color:#d3434d;color:#FFFFFF;'>
<th class='sb_center'>Package Name</th>
<th class='sb_center'>Trip Code</th>
<th class='sb_center'>Duration</th>
<th class='sb_center'>Vehicle Type</th>
</tr>
</thead>
<tbody>
$trip_line
</tbody>
</table>
<table style='width:100%;border-collapse: collapse;border-spacing: 0;border-color: #CCCCCC !important;border: 0px;text-align: center;font-size: 12px; background-color: #FFFFFF;' border='1' cellspacing='0' cellpadding='4'>
<thead>
<h3>Itinerary Details</h3>
<tr style='background-color:#d3434d;color:#FFFFFF;'>
<th class='sb_center'>SNo</th>
<th class='sb_center'>Day</th>
<th class='sb_center'>Details</th>
<th class='sb_center'>Night</th>
</tr>
</thead>
<tbody>
$tr_line
</tbody>
</table>
<table style='width:100%;border-collapse: collapse;border-spacing: 0;border-color: #CCCCCC !important;border: 0px;text-align: center;font-size: 12px; background-color: #FFFFFF;' border='1' cellspacing='0' cellpadding='4'>
<thead>
<h3>Boarding Details</h3>
<tr style='background-color:#d3434d;color:#FFFFFF;'>
<th class='sb_center'>Boarding Name</th>
<th class='sb_center'>Departure Time</th>
</tr>
</thead>
<tbody>
$board_line
</tbody>
</table>
<table style='width:100%;border-collapse: collapse;border-spacing: 0;border-color: #CCCCCC !important;border: 0px;text-align: center;font-size: 12px; background-color: #FFFFFF;' border='1' cellspacing='0' cellpadding='4'>
<thead>
<h3>Tariff Details</h3>
<tr style='background-color:#d3434d;color:#FFFFFF;'>
<th class='sb_center'>Tariff</th>
<th class='sb_center'>Cost</th>
</tr>
</thead>
<tbody>
$tariff_line
</tbody>
</table>
<table style='width:100%;border-collapse: collapse;border-spacing: 0;border-color: #CCCCCC !important;border: 0px;text-align: center;font-size: 12px; background-color: #FFFFFF;' border='1' cellspacing='0' cellpadding='4'>
<thead>
<h3>Cancellation Charges</h3>
<tr style='background-color:#d3434d;color:#FFFFFF;'>
<th class='sb_center'>Detail</th>
<th class='sb_center'>Fees</th>
</tr>
</thead>
<tbody>
$fee_line
</tbody>
</table>
<p style='font-weight:bold;margin-top: 10px;font-size: 12px;'> Terms & Conditions of E-Ticketing services </p>
<ul style='line-height: 22px;font-size: 12px;'>
<li> The tickets booked are cancelable. Kindly note that once cancelled the money is transferred back to the respective credit/debit card. </li>
<li> The cancellation fee: Between 24 hours to 14 days before journey the cancellation charge is 50%. </li>
<li> After 14 days before journey the cancellation charge is 10%.Please note that the cancellation fee and cancellation period may differ from one package to another.</li>
<li> Please contact any of our executives for complete details or enter your ticket number on the print ticket tab to read the cancellation policy for your ticket.</li>
<li> The transaction charges or the home/courier delivery charges will not be refunded in the event of ticket cancellation. </li>
<li> In case a booking confirmation e-mail and sms gets delayed or fails because of technical reasons or as a result of incorrect e-mail ID / phone number provided by the user etc, a ticket will be considered 'booked' as long as the ticket shows up on the confirmation page of www.sblt.co.in </li>
<li> In case of any clarifications, please write to tours@sblt.co.in </li>
</ul>
</div>";
}
?>