File: /home/cafsindia/allyindian_com/backend/dashboard/chart_call_bk04mar2019.php
<?php
require ("../app/dbconnect.php");
require_once('../customers/sbltt_lib/sblttObject.php');
$dbconnect = new dbconnect;
$db = $dbconnect->connect();
$frm = $_POST['frm'];
$url = "http://". $_SERVER['SERVER_NAME'];
$admin_email = "admin.tours@sblt.co.in";
//Feedback Save
if($frm === "save_feedback_info"){
$row_qry = mysql_query("SELECT * from sblttweb_feedback where enteredby = '1' and packageid = '".$_POST['packid']."' and seat_no = '".$_POST['seatno']."' and tourdate = '".date("Y-m-d",strtotime($_POST['dep_date']))."' and packagetourcode = '".$_POST['tripid']."'");
$rows = mysql_num_rows($row_qry);
if($rows === 0){
$insert_qry = mysql_query("INSERT into sblttweb_feedback(feedbackdate,seat_no,custname,mobile,email,packageid,packagetourcode,tourdate,driver,vehicle,food,accom,overall,other,enteredby,enteredbyid) values ('".date('Y-m-d h:i:s')."','".$_POST['seatno']."','".$_POST['passname']."','".$_POST['passmobile']."','-','".$_POST['packid']."','".$_POST['tripid']."','".date("Y-m-d-",strtotime($_POST['dep_date']))."','".$_POST['driver']."','".$_POST['vehicle']."','".$_POST['food']."','".$_POST['accomodation']."','".$_POST['overall']."','".$_POST['comments']."','1','".$_POST['emp_id']."')");
if($insert_qry){
$email_content = "<div style='width: 750px; margin-left: auto; margin-right: auto; padding: 15px; background-color: #EEEEEE; border-radius: 3px; 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);'>
<h1 style='text-align: center;color:#D8343F;'>Feedback</h1>
<p style='text-align:left;'>
Feedback Received from '".$_POST['passname']."'
</p>
<table><tbody>
<tr><td>Comments</td><td>: '".$_POST['passmobile']."'</td></tr>
</tbody></table>
</div>";
//Email Send to Admin
$email_data = array(
'to_email' => '',
'admin_email' => $admin_email,
'subject' => "Customer Feedback",
'email_content' => $email_content,
);
$libObject = sblttObject::newObject('sbltt_db');
$from = "admin";
$libObject->send_mail($email_data,$from);
if($_POST['passmobile']){
$sbltt_sms = sblttObject::newObject('sbltt_sms');
$sbltt_sms->send_sms($_POST['passmobile'],'feedback',"feedback");
}
echo json_encode(array('success' => true, 'message'=>'Feedback Saved Successfully'));
}else{
echo json_encode(array('success' => false, 'message'=>'Please Try after Sometime...'));
}
}else{
echo json_encode(array('success' => true, 'message'=>'This Seat Number Already Submit the Feedback for this Trip'));
}
}else
if($frm === "print_refund"){
if(isset($_POST['orderid'])){
$orderid = $_POST['orderid'];
}
$ticket_qry = mysql_query("SELECT *,sblttweb_passlist.ticketamt as ticketamt,sblttweb_passlist.cashpaid as cashpaid,sblttweb_passlist.cashdue as cashdue,sblttweb_cancelorder.cancelfee from sblttweb_passlist inner join sblttweb_cancelorder on sblttweb_cancelorder.orderid = sblttweb_passlist.cancelorderid inner join sblttweb_package on sblttweb_package.package_id = sblttweb_cancelorder.packid inner join sblttweb_customers on sblttweb_customers.custid = sblttweb_cancelorder.custid inner join sblttweb_payment on sblttweb_payment.orderid = sblttweb_cancelorder.orderid where bookorderid = '$orderid' and sblttweb_passlist.passstatus = '1'");
$i = 1;
$j=0;
$tr_line = "";
$cashpaid = 0;
$tariffamt = 0;
$ticketamt = 0;
$cashdue = 0;
$admin_tr = "";
$disc_tr = "";
while($rslt = mysql_fetch_array($ticket_qry)){
$passid = $rslt['passid'];
$pnrno = $rslt['pnrno'];
$orderid = $rslt['bookorderid'];
$cancel_id = $rslt['orderid'];
$order_date = date("d-M-Y",strtotime($rslt['orderdate']));
$pack_date = date("d-M-Y",strtotime($rslt['doj']));
$cancel_date = date("d-M-Y",strtotime($rslt['cancel_date']));
$order = $rslt['orderdate'];
$package_date = $rslt['doj'];
$nopass = $rslt['nopass'];
$custid = $rslt['custid'];
$custemail = $rslt['custemail'];
$package_title = $rslt['package_title'];
$package_title2 = $rslt['package_title2'];
$package_title3 = $rslt['package_title3'];
$cancelfee = $rslt['cancelfee'];
$cancelamt = $rslt['cancelamt'];
$passname = $rslt['passname'];
$passgender = $rslt['passgender'];
$passage = $rslt['passage'];
$seatno = $rslt['seatno'];
$passtripid = $rslt['passtripid'];
$packid = $rslt['packid'];
$cashpaid = $rslt['cashpaid'];
$cashdue += $rslt['cashdue'];
$discount = $rslt['discount'];
//$tariffamt += $rslt['tariffamt'];
$tariffamt += $rslt['tariffamt'];
$ticketamt += $rslt['ticketamt'];
$passmobile = $rslt['passmobile'];
$amount = $rslt['amount'];
$pack_name = $package_title." ".$package_title2." ".$package_title3;
$refund = $cashpaid - $cancelamt;
$tr_line .= "<tr>
<td>$i</td>
<td>$passname</td>
<td>$passgender</td>
<td>$passmobile</td>
<td>$passage</td>
<td>$seatno</td>
<td>$cashpaid</td>
<td>$cancelfee</td>
<td>$cancelamt</td>
<td>$refund</td>
<td>$amount</td>
</tr>";
$i++;
$j++;
}
//Get Cancel Fees Details
$cancel_qry = mysql_query("SELECT * from sblttweb_cancelfee where FIND_IN_SET(cancelfeeid, '$cancelfee')");
$fee_line = "";
while($cancelfee_data = mysql_fetch_array($cancel_qry)){
$cancelfeedetail = $cancelfee_data['cancelfeedetail'];
$cancelfees = $cancelfee_data['cancelfees'];
$fee_line .= "<li>If the Ticket Cancelled $cancelfeedetail then Cancel Fees will be $cancelfees % </li>";
}
echo "<div id='print_data' style='width:750px; margin-left: auto; margin-right: auto; padding: 15px; background-color: #EEEEEE; border-radius: 3px; 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 style='width:100%;border-collapse: collapse;border-spacing: 0;border-color: #CCCCCC !important;border: 0px;text-align: center;font-size: 14px; background-color: #FFFFFF;' border='1' cellspacing='0' cellpadding='4'>
<tr>
<td style='border-bottom:0px;border-right: 0px;'>
<img id='logo' src='$url/backend/images/logo.png' alt='sbltt'>
</td>
<td style='border-bottom:0px;border-left: 0px;'>
<table style='text-align: center; width: 100%;'>
<tr>
<td>
<h3 style='text-align:center;'>Refund Payment Sheet</h3>
<h3 style='color:#d3434d;margin:10px;font-size:21px;font-weight:bold;'>Sri Bhagiyalakshmi Tours and Travels</h3>
</td>
</tr>
<tr>
<td>
Plot No.1310, 13th Main Road, Anna Nagar,
</td>
</tr>
<tr>
<td>
Opp : Anna Nagar West Depot, Chennai - 600040.
</td>
</tr>
<tr>
<td>
Phone : 044 - 4666 4666 / Mobile : 98416 99966
</td>
</tr>
<tr>
<td>
Website : www.sblt.co.in / E-mail : tours@sblt.co.in
</td>
</tr>
</table>
</td>
</tr>
</table>
<table style='width:100%;border-collapse: collapse;border-spacing: 0;border-color: #CCCCCC !important;border: 0px;font-size: 14px;background-color:#FFFFFF;' border='1' cellspacing='0' cellpadding='4' >
<tr>
<td style='white-space: nowrap;'>Package Name</td>
<td style='font-weight: bold;' colspan='3'>$pack_name</td>
<td style='white-space: nowrap;'>Cancel Id </td>
<td style='font-weight: bold;'>$cancel_id</td>
</tr>
<tr>
<td style='white-space: nowrap;'>PNR No</td>
<td style='font-weight: bold;'>$pnrno</td>
<td style='white-space: nowrap;'>Date of Journey</td>
<td style='font-weight: bold;'>$pack_date</td>
<td style='white-space: nowrap;'>Date of Booking</td>
<td style='font-weight: bold;'>$order_date</td>
</tr>
<tr>
<td style='white-space: nowrap;border-bottom:0px;'>Ticket No</td>
<td style='border-bottom:0px;font-weight: bold;'>$orderid</td>
<td style='white-space: nowrap;border-bottom:0px;'>No of Passengers</td>
<td style='border-bottom:0px;font-weight: bold;'>$j</td>
<td style='white-space: nowrap;border-bottom:0px;'>Cancelled Date</td>
<td style='border-bottom:0px;font-weight: bold;'>$cancel_date</td>
</tr>
</table>
<table style='width:100%;border-collapse: collapse;border-spacing: 0;border-color: #CCCCCC !important;border: 0px;text-align: center;font-size: 14px; background-color: #FFFFFF;' border='1' cellspacing='0' cellpadding='4'>
<thead>
<tr style='background-color:#828181;color: #FFFFFF;font-weight:bold;'>
<th class='sb_center'>SNo</th>
<th class='sb_center'>Passenger Name</th>
<th class='sb_center'>Gender</th>
<th class='sb_center'>Mobile</th>
<th class='sb_center'>Age</th>
<th class='sb_center'>Seat No</th>
<th class='sb_center'>Paid Amount</th>
<th class='sb_center'>Cancel(%)</th>
<th class='sb_center'>Cancellation Fees</th>
<th class='sb_center'>Actual Refund</th>
<th class='sb_center'>Refunded</th>
</tr>
</thead>
<tbody>
$tr_line
</tbody>
</table>
<p> For details, rules and terms & conditions of E-Ticketing services, please visit www.sblt.co.in </p>
<h4>Cancellation Policy:</h4>
<ul style='line-height: 30px;'>
<li> The tickets booked are cancelable. Kindly note that once cancelled the money is transferred back to the respective credit/debit card. </li>
$fee_line
<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>";
}else
if($frm === "get_feedback_data"){
$trippackid = $_POST['package_id'];
$dep_date = date('Y-m-d', strtotime($_POST['dep_date']));
$tripid = $_POST['tripid'];
$journey_date = date('d-m-Y', strtotime($_POST['dep_date']));
$male_info = mysql_query("SELECT count(passid) as adultmale from sblttweb_ticketorder inner join sblttweb_customers on sblttweb_customers.custid=sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and passage > 10 and passgender='Male' and orderstat IN (1,2,4)");
$male_rslt = mysql_fetch_array($male_info);
$adultmale = $male_rslt['adultmale'];
$malechild_info = mysql_query("SELECT count(passid) as malechild from sblttweb_ticketorder inner join sblttweb_customers on sblttweb_customers.custid=sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and passage <= 10 and passgender='Male' and orderstat IN (1,2,4)");
$malechild_rslt = mysql_fetch_array($malechild_info);
$malechild = $malechild_rslt['malechild'];
$female_info = mysql_query("SELECT count(passid) as adultfemale from sblttweb_ticketorder inner join sblttweb_customers on sblttweb_customers.custid=sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and passage > 10 and passgender='Female' and orderstat IN (1,2,4)");
$female_rslt = mysql_fetch_array($female_info);
$adultfemale = $female_rslt['adultfemale'];
$femalechild_info = mysql_query("SELECT count(passid) as femalechild from sblttweb_ticketorder inner join sblttweb_customers on sblttweb_customers.custid=sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and passage <= 10 and passgender='Female' and orderstat IN (1,2,4)");
$femalechild_rslt = mysql_fetch_array($femalechild_info);
$femalechild = $femalechild_rslt['femalechild'];
$seat_details_qry = mysql_query("SELECT seat_capacity,count(passid) as booked_pass,tripcode,package_title,package_title2,sblttweb_vehicletrips.seatmap from sblttweb_ticketorder inner join sblttweb_customers on sblttweb_customers.custid=sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid inner join sblttweb_package on sblttweb_package.package_id=sblttweb_ticketorder.packid inner join sblttweb_vehicletrips on sblttweb_vehicletrips.tripid = sblttweb_ticketorder.otripid inner join sblttweb_vehicle on sblttweb_vehicle.vehicle_id = sblttweb_vehicletrips.vehicleid where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and orderstat IN (1,2,4)");
$seat_details_rslt = mysql_fetch_array($seat_details_qry);
$total_seat = $seat_details_rslt['seat_capacity'];
$booked_seat = $seat_details_rslt['booked_pass'];
$balance_seat = (int)$total_seat - (int)$booked_seat;
$tripcode = $seat_details_rslt['tripcode'];
$packname = $seat_details_rslt['package_title']." ".$seat_details_rslt['package_title2'];
$seatmap = explode(',',$seat_details_rslt['seatmap']);
$passanger_info = mysql_query("SELECT sblttweb_ticketorder.pnrno,doj,packid,sblttweb_ticketorder.custid,board_point,orderid,passname,passgender,passage,passmobile,seatno,passtripid,driver,vehicle,food,accom,overall,other from sblttweb_passlist inner join sblttweb_ticketorder on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid inner join sblttweb_customers on sblttweb_customers.custid = sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding left join sblttweb_feedback on sblttweb_feedback.seat_no
= sblttweb_passlist.seatno where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') order by ABS(seatno) and orderstat IN (1,2,4)");
$tr_line = "";
$rows = array();
while($passanger_rslt = mysql_fetch_array($passanger_info)){
$rows[$passanger_rslt['seatno']] = $passanger_rslt;
}
$count = 1;
$discount = 0;
for($i =1;$i<=count($seatmap); $i++){
if (array_key_exists($i, $rows)){
$result_array = $rows[$i];
$passname = $result_array['passname'];
$passgender = $result_array['passgender'];
$passage = $result_array['passage'];
$passmobile = $result_array['passmobile'];
$board_point = $result_array['board_point'];
$seatno = $result_array['seatno'];
$ticket_no = $result_array['orderid'];
$pnr_no = $result_array['pnrno'];
$tripid = $result_array['passtripid'];
$packid = $result_array['packid'];
$custid = $result_array['custid'];
$driver = $result_array['driver'];
$vehicle = $result_array['vehicle'];
$food = $result_array['food'];
$accom = $result_array['accom'];
$overall = $result_array['overall'];
$other = $result_array['other'];
$d_option = "";
$v_option = "";
$f_option = "";
$a_option = "";
$o_option = "";
for($j=1; $j <= 5; $j++){
if($driver == $j){
$d_option_selected = "selected";
}else{
$d_option_selected = "";
}
if($vehicle == $j){
$v_option_selected = "selected";
}else{
$v_option_selected = "";
}
if($food == $j){
$f_option_selected = "selected";
}else{
$f_option_selected = "";
}
if($accom == $j){
$a_option_selected = "selected";
}else{
$a_option_selected = "";
}
if($other == $j){
$o_option_selected = "selected";
}else{
$o_option_selected = "";
}
$d_option .= "<option value='$j' $d_option_selected>$j</option>";
$v_option .= "<option value='$j' $v_option_selected>$j</option>";
$f_option .= "<option value='$j' $f_option_selected>$j</option>";
$a_option .= "<option value='$j' $a_option_selected>$j</option>";
$o_option .= "<option value='$j' $o_option_selected>$j</option>";
}
$tr_line .= "<tr>
<td style='border: 1px solid black; border-collapse: collapse;'>$i</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$passname</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$passmobile</td>
<td style='border: 1px solid black; border-collapse: collapse;'><div class='form-group'><select id='driver_$seatno' class='form-control' ><option value=''>--- Driver ---</option>$d_option</select></div></td>
<td style='border: 1px solid black; border-collapse: collapse;'><div class='form-group'><select id='vehicle_$seatno' class='form-control' ><option value=''>--- Vehicle ---</option>$v_option</select></div></td>
<td style='border: 1px solid black; border-collapse: collapse;'><div class='form-group'><select id='food_$seatno' class='form-control' ><option value=''>--- Food ---</option>$f_option</select></div></td>
<td style='border: 1px solid black; border-collapse: collapse;'><div class='form-group'><select id='accomodation_$seatno' class='form-control' ><option value=''>--- Accomodation ---</option>$a_option</select></div></td>
<td style='border: 1px solid black; border-collapse: collapse;'><div class='form-group'><select id='overall_$seatno' class='form-control' ><option value=''>--- Overall ---</option>$o_option</select></div></td>
<td style='border: 1px solid black; border-collapse: collapse;'><div class='form-group'><textarea id='comments_$seatno' class='form-control input-sm' placeholder='Comments'>$other</textarea></div></td>
<td style='border: 1px solid black; border-collapse: collapse;'><div class='form-group'><button id='save_feedback$seatno' class='btn btn-info btn-sm cls' onclick=save_feedback_info($seatno,$tripid,'$dep_date',$packid,'$passname','$passmobile',$custid)>Submit</button></div></td>
</tr>";
}else{
$tr_line .= "<tr>
<td style='border: 1px solid black; border-collapse: collapse;'>$i</td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
</tr>";
}
$count++;
}
$passenger_info = "<table id='chart_list' class='table table-bordered col-style' style='width:100%; border: 1px solid black; border-collapse: collapse;'>
<thead style='border: 1px solid black; border-collapse: collapse;'>
<tr style='color:white;background-color:#D8343F'>
<th style='border: 1px solid black; border-collapse: collapse;'>Seat No</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Passenger Name</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Mobile</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Driver Rating</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Vehicle Rating</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Food Rating</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Accomodation Rating</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Overall Rating</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Comments</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Update</th>
</tr>
</thead>
<tbody>$tr_line</tbody>
</table>";
echo "<div id='table_list' class='row'>
<button id='btnExport' class='btn-default' onclick=fnExcelReport();> Excel </button><button onclick=printDiv(); class='btn btn-info btn-sm' id='print_id' style='float:right'><i class='fa fa-print fa-lg'></i> Print</button>
<h3 style='text-align:center'>Passengers Feedback</h3>
<table style='width:100%;' cellspacing='0' id='table'>
<tbody style='width:100%;'>
<tr>
<td style='border: 1px solid black; border-collapse: collapse; text-align:center;' colspan='2'><img src='$url/backend/images/logo.png' alt='SBLTT Logo' height='45'/></td>
<td style='border: 1px solid black; border-collapse: collapse;text-align:center;line-height:22px;' colspan='2'><h5 style='font-weight: bold;'>Sri Bhagiyalakshmi Tours & Travels</h5><br/>Plot No.1310, 13th Main Road, Anna Nagar,<br/>Opp : Anna Nagar West Depot,Chennai - 600040.<br/>Phone : 044 - 4666 4666 / Mobile : 98416 99966<br/>Website : www.sblt.co.in /E-mail : tours@sblt.co.in</td>
</tr>
<tr>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Trip Code</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;'> $tripcode</td>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Package Name</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;border-right: 3px solid #f1f1f1;'> $packname</td>
</tr>
<tr>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Date of Journey</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;'>$journey_date</td>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Total Seats</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;border-right: 3px solid #f1f1f1;'>$total_seat</td>
</tr>
<tr>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Total Passengers</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;'>$booked_seat</td>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Total Vacant Seats</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;border-right: 3px solid #f1f1f1;'>$balance_seat</td>
</tr>
<tr>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Adult Male</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;'>$adultmale</td>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Male Child</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;border-right: 3px solid #f1f1f1;'>$malechild</td>
</tr>
<tr>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Adult Female</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;'>$adultfemale</td>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Female Child</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;border-right: 3px solid #f1f1f1;'>$femalechild</td>
</tr>
</tbody>
</table>
$passenger_info
</div>";
}else
if($frm === "get_customer"){
$trippackid = $_POST['trippackid'];
$dep_date = date('Y-m-d', strtotime($_POST['dep_date']));
$tripid = $_POST['tripid'];
$journey_date = date('d-m-Y', strtotime($_POST['dep_date']));
$male_info = mysql_query("SELECT count(passid) as adultmale from sblttweb_ticketorder inner join sblttweb_customers on sblttweb_customers.custid=sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and passage > 10 and passgender='Male' and orderstat IN (1,2,4)");
$male_rslt = mysql_fetch_array($male_info);
$adultmale = $male_rslt['adultmale'];
$malechild_info = mysql_query("SELECT count(passid) as malechild from sblttweb_ticketorder inner join sblttweb_customers on sblttweb_customers.custid=sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and passage <= 10 and passgender='Male' and orderstat IN (1,2,4)");
$malechild_rslt = mysql_fetch_array($malechild_info);
$malechild = $malechild_rslt['malechild'];
$female_info = mysql_query("SELECT count(passid) as adultfemale from sblttweb_ticketorder inner join sblttweb_customers on sblttweb_customers.custid=sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and passage > 10 and passgender='Female' and orderstat IN (1,2,4)");
$female_rslt = mysql_fetch_array($female_info);
$adultfemale = $female_rslt['adultfemale'];
$femalechild_info = mysql_query("SELECT count(passid) as femalechild from sblttweb_ticketorder inner join sblttweb_customers on sblttweb_customers.custid=sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and passage <= 10 and passgender='Female' and orderstat IN (1,2,4)");
$femalechild_rslt = mysql_fetch_array($femalechild_info);
$femalechild = $femalechild_rslt['femalechild'];
$irumudi_qry = mysql_query("SELECT sblttweb_ticketorder.pnrno,doj,packid,sblttweb_ticketorder.custid,orderid,pass_name,pass_gender,pass_age,pass_mobile,irumudi_no,irumudi_amount from sblttweb_irumudi inner join sblttweb_ticketorder on sblttweb_irumudi.order_id=sblttweb_ticketorder.orderid inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid where packid = '$trippackid' and trip_id = '$tripid' and doj = '$dep_date' and (passstatus = '0' or passstatus = '2') and orderstat IN (1,2,4) GROUP BY irumudi_id order by ABS(irumudi_no)");
$irumudi_th = "";
$irumudi_td = "";
while($irumudi_rslt = mysql_fetch_array($irumudi_qry)){
$irumudi_no = $irumudi_rslt['irumudi_no'];
$pass_name = $irumudi_rslt['pass_name'];
$pass_gender = $irumudi_rslt['pass_gender'];
$pass_age = $irumudi_rslt['pass_age'];
$pass_mobile = $irumudi_rslt['pass_mobile'];
$pnrno = $irumudi_rslt['pnrno'];
$orderid = $irumudi_rslt['orderid'];
$irumudi_amount = $irumudi_rslt['irumudi_amount'];
$irumudi_td .= "<tr>
<td style='border: 1px solid black; border-collapse: collapse;'>$irumudi_no</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$pass_name</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$pass_gender</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$pass_age</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$pass_mobile</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$pnrno</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$orderid</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$irumudi_amount</td>
</tr>";
$irumudi_th = "<tr>
<th style='border: 1px solid black; border-collapse: collapse;'>No</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Name</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Gender</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Age</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Mobile</th>
<th style='border: 1px solid black; border-collapse: collapse;'>PNR</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Ticket No</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Amount</th>
</tr>";
}
$seat_details_qry = mysql_query("SELECT seat_capacity,count(passid) as booked_pass,tripcode,package_title,package_title2,sblttweb_vehicletrips.seatmap from sblttweb_ticketorder inner join sblttweb_customers on sblttweb_customers.custid=sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding inner join sblttweb_passlist on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid inner join sblttweb_package on sblttweb_package.package_id=sblttweb_ticketorder.packid inner join sblttweb_vehicletrips on sblttweb_vehicletrips.tripid = sblttweb_ticketorder.otripid inner join sblttweb_vehicle on sblttweb_vehicle.vehicle_id = sblttweb_vehicletrips.vehicleid where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and orderstat IN (1,2,4)");
$seat_details_rslt = mysql_fetch_array($seat_details_qry);
$total_seat = $seat_details_rslt['seat_capacity'];
$booked_seat = $seat_details_rslt['booked_pass'];
$balance_seat = (int)$total_seat - (int)$booked_seat;
$tripcode = $seat_details_rslt['tripcode'];
$packname = $seat_details_rslt['package_title']." ".$seat_details_rslt['package_title2'];
$seatmap = explode(',',$seat_details_rslt['seatmap']);
$passanger_info = mysql_query("SELECT sblttweb_ticketorder.pnrno,doj,packid,sblttweb_ticketorder.custid,board_point,orderid,passname,passgender,passage,passmobile,seatno,sblttweb_passlist.ticketamt,sblttweb_passlist.discountamt,admin_discountamt,cashpaid,cashdue from sblttweb_passlist inner join sblttweb_ticketorder on sblttweb_passlist.ticketorderid=sblttweb_ticketorder.orderid inner join sblttweb_customers on sblttweb_customers.custid = sblttweb_ticketorder.custid inner join sblttweb_boarding on sblttweb_boarding.boarding_id=sblttweb_ticketorder.boarding where packid = '$trippackid' and otripid = '$tripid' and doj='$dep_date' and (passstatus = '0' or passstatus = '2') and orderstat IN (1,2,4) order by ABS(seatno)");
$tr_line = "";
$rows = array();
while($passanger_rslt = mysql_fetch_array($passanger_info)){
$rows[$passanger_rslt['seatno']] = $passanger_rslt;
}
$count = 1;
$discount = 0;
for($i =1;$i<=count($seatmap); $i++) {
if (array_key_exists($i, $rows)){
$result_array = $rows[$i];
$passname = $result_array['passname'];
$passgender = $result_array['passgender'];
$passage = $result_array['passage'];
$passmobile = $result_array['passmobile'];
$board_point = $result_array['board_point'];
$seatno = $result_array['seatno'];
$ticket_no = $result_array['orderid'];
$pnr_no = $result_array['pnrno'];
$ticketamt = $result_array['ticketamt'];
$cashpaid = $result_array['cashpaid'];
$cashdue = $result_array['cashdue'];
$discountamt = $result_array['discountamt'];
$admin_discountamt = $result_array['admin_discountamt'];
$discount = $discountamt + $admin_discountamt;
$tr_line .= "<tr>
<td style='border: 1px solid black; border-collapse: collapse;'>$i</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$passname</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$passgender</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$passage</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$passmobile</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$board_point</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$pnr_no</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$ticket_no</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$ticketamt</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$discount</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$cashpaid</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$cashdue</td>
<td style='border: 1px solid black; border-collapse: collapse;'>$seatno</td>
</tr>";
}else{
$tr_line .= "<tr>
<td style='border: 1px solid black; border-collapse: collapse;'>$i</td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
<td style='border: 1px solid black; border-collapse: collapse;'></td>
</tr>";
}
$count++;
}
$passenger_info = "<table id='chart_list' class='table table-bordered col-style' style='width:100%; border: 1px solid black; border-collapse: collapse;'>
<thead style='border: 1px solid black; border-collapse: collapse;'>
<tr style='color:white;background-color:#D8343F'>
<th style='border: 1px solid black; border-collapse: collapse;'>Sl.No</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Passenger Name</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Gender</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Age</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Mobile</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Boarding Point</th>
<th style='border: 1px solid black; border-collapse: collapse;'>PNR No</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Ticket No</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Ticket Amount</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Discount</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Paid</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Due</th>
<th style='border: 1px solid black; border-collapse: collapse;'>Seat No</th>
</tr>
</thead>
<tbody>$tr_line $irumudi_th $irumudi_td</tbody>
</table>";
echo "<div id='table_list' class='row'>
<button id='btnExport' class='btn-default' onclick=fnExcelReport();> Excel </button><button onclick=printDiv(); class='btn btn-info btn-sm' id='print_id' style='float:right'><i class='fa fa-print fa-lg'></i> Print</button>
<h3 style='text-align:center'>Passengers Chart List</h3>
<table style='width:100%;' cellspacing='0' id='table'>
<tbody style='width:100%;'>
<tr>
<td style='border: 1px solid black; border-collapse: collapse; text-align:center;' colspan='2'><img src='$url/backend/images/logo.png' alt='SBLTT Logo' height='45'/></td>
<td style='border: 1px solid black; border-collapse: collapse;text-align:center;line-height:22px;' colspan='2'><h5 style='font-weight: bold;'>Sri Bhagiyalakshmi Tours & Travels</h5><br/>Plot No.1310, 13th Main Road, Anna Nagar,<br/>Opp : Anna Nagar West Depot,Chennai - 600040.<br/>Phone : 044 - 4666 4666 / Mobile : 98416 99966<br/>Website : www.sblt.co.in /E-mail : tours@sblt.co.in</td>
</tr>
<tr>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Trip Code</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;'> $tripcode</td>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Package Name</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;border-right: 3px solid #f1f1f1;'> $packname</td>
</tr>
<tr>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Date of Journey</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;'>$journey_date</td>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Total Seats</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;border-right: 3px solid #f1f1f1;'>$total_seat</td>
</tr>
<tr>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Total Passengers</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;'>$booked_seat</td>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Total Vacant Seats</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;border-right: 3px solid #f1f1f1;'>$balance_seat</td>
</tr>
<tr>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Adult Male</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;'>$adultmale</td>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Male Child</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;border-right: 3px solid #f1f1f1;'>$malechild</td>
</tr>
<tr>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Adult Female</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;'>$adultfemale</td>
<td style='border: none; font-weight: bold; text-align: left; font-size: 12px;padding: 7px;border-left: 3px solid #f1f1f1;border-bottom: 3px solid #f1f1f1;'>Female Child</td>
<td style='color:#D8343F;border: none; font-weight: bold; text-align: center; font-size: 12px;padding: 7px;border-bottom: 3px solid #f1f1f1;border-right: 3px solid #f1f1f1;'>$femalechild</td>
</tr>
</tbody>
</table>
$passenger_info
</div>";
}else{
}
if($frm === "get_customer"){
?>
<style>
.modal-body{
height: 510px !important;
}
#lead_model_body .btn-default {
color: #ffffff !important;
background: #D8343F;
padding: 1px 6px !important;
font-size: 12px !important;
}
@media (max-width: 767px){
.form-group {
width: 100% !important;
}
}
</style>
<script type="text/javascript">
function fnExcelReport(){
window.open('data:application/vnd.ms-excel,'+encodeURIComponent($('div[id=table_list]').html()));
e.preventDefault();
}
</script>
<?php
}
?>