G:
/
PleskVhosts
/
seeonsoft.com
/
hp.thefalconunited.com
/
up file
home
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <script type="text/javascript"> window.onafterprint = window.close; window.print(); </script> <style> #firsttable td { padding-left:20px; } </style> </head> <body> <?php date_default_timezone_set('Asia/Muscat'); $t_date = date('d-m-Y'); $t_time = date('H:i'); $tot = 0; $profit = ''; include('config.php'); $cid = $_GET['id']; $result = $js->prepare('SELECT * FROM `customer_entry` WHERE `id` = :cid'); $result->execute(array(':cid' => $cid)); while($row = $result->fetch(PDO::FETCH_ASSOC)) { $custname = $row['custname']; $custid = $row['custid']; $resultid = mb_substr($custid, 3); $phone = $row['phone']; $email = $row['email']; $pax = $row['pax']; $address = $row['address']; $location = $row['location']; $pdate = date('d-m-Y', strtotime($row['plannningdate'])); $days = $row['daysplanning']; $todate = date('d-m-Y', strtotime($pdate.' + '.$days.' days - 1 day')); } $results = $js->prepare('SELECT * FROM `invoiced` WHERE cust = :cid '); $results->execute(array(':cid' => $cid)); while($rows = $results->fetch(PDO::FETCH_ASSOC)) { $invid = $rows['invid']; $descr = $rows['descr']; $invamount = $rows['invamount']; $package = $rows['package']; $currency = $rows['currency']; $invdate = $rows['invdate']; } ?> <title>JOB ORDER - <?php echo $custname?></title> <div style="width:955px;border:1px solid;padding:20px;"> <table style='width:100%'> <tr> <td><img src="images/logodmc.png" /></td> <td style='text-align:right;vertical-align: bottom;'><?php echo $t_date.' '. $t_time; ?></td> </tr> </table> <hr/> <table id='firsttable' style='width:100%;border-collapse: collapse;'> <th colspan='4' style='font-size: 24px;text-decoration: underline;'>JOB ORDER<br></th> </tr> <tr> <td style="font-weight:bold;">GUEST NAME</td> <td style="">: <?php echo $custname?> </td> <td style="font-weight:bold;">CRN</td> <td style="">: <?php echo $resultid?></td> </tr> <tr> <td style="font-weight:bold;">PHONE NUMBER </td> <td>: <?php echo $phone?></td> <td style="font-weight:bold;">DATE</td> <td>: <?php echo date('d-m-Y'); ?></td> </tr> <tr> <td style="font-weight:bold;">E-MAIL</td> <td style="">: <?php echo $email?></td> <td style="font-weight:bold;">NO OF PAX</td> <td>: <?php echo $pax?></td> </tr> <tr> <td style="font-weight:bold;">PLACE</td> <td style="">: <?php echo $location?></td> <td style="font-weight:bold;">PERIOD</td> <td>: <?php echo $pdate?> to <?php echo $todate?></td> </tr> <tr> <td style="font-weight:bold;">HANDLED BY</td> <td style="">: BINU JAMES</td> <td style="font-weight:bold;">INVOICE AMOUNT</td> <td style="font-weight:bold;">: <?php echo $currency." ".$invamount?></td> </tr> <tr> <td style="font-weight:bold;">AGENT</td> <td style="">: <input type='text'/></td> <td style="font-weight:bold;">AMOUNT IN OMR</tD> <td style="font-weight:bold;">: <strong><?php echo $package?></strong></td> </tr> </table> <br /> <table border='1' style="width:100%;font-size:13px;" cellpadding="8"> <tr style="border:none;"> <th colspan="12" style="color:#FF0000;">HOTEL RESERVATIONS</th> </tr> <tr> <th style='width:4%'>#</th> <th style='width:9%'>Location</th> <th style='width:10%'>Hotel Name</th> <th style='width:7%'>Check-In Date</th> <th style='width:7%'>Check-Out Date</th> <th style='width:10%'>Room Type</th> <th style='width:10%'>No. Of Rooms</th> <th style='width:4%'>Plan</th> <th style='width:8%'>Special Rate</th> <th style='width:9%'>Confirmation Number</th> <th style='width:10%'>Additional Services</th> </tr> <?php $resultserp = $js->prepare('SELECT * FROM `hotelreservations` WHERE custid = :cid ORDER BY `cindate` '); $resultserp->execute(array(':cid' => $cid)); ?> <?php $x = 1; while($rowserp = $resultserp->fetch(PDO::FETCH_ASSOC)) { $hotel = $rowserp['hotel']; $cindate = date('d-m-Y', strtotime($rowserp['cindate'])); $coutdate = date('d-m-Y', strtotime($rowserp['coutdate'])); $roomtype = $rowserp['roomtype']; $norooms = $rowserp['norooms']; $noebs = $rowserp['noebs']; if($noebs != '') { $rooms = $norooms.' + '.$noebs.' Extra-Bed'; } else { $rooms = $norooms." Room(s)"; } $meals = $rowserp['meals']; $roomrate = $rowserp['roomrate']; $remhotel = $rowserp['remarks']; $ebrate = $rowserp['ebrate']; if($ebrate != '') { $roomrate += $ebrate; } else { $roomrate = $roomrate; } $addservices = $rowserp['addservices']; $totals = $roomrate; $grand_total += $totals; $resultprod = $js->prepare('SELECT * FROM `hotelvendor` WHERE id = :hotel '); $resultprod->execute(array(':hotel' => $hotel)); while($rowprod = $resultprod->fetch(PDO::FETCH_ASSOC)) { $location = $rowprod['location']; $hotelname = $rowprod['hotelname']; } echo "<tr>"; echo "<td align='center'>$x</td>"; echo "<td align='center'>$location</td>"; echo "<td align='center'>$hotelname</td>"; echo "<td align='center'>$cindate</td>"; echo "<td align='center'>$coutdate</td>"; echo "<td align='center'>$roomtype</td>"; echo "<td align='center'>$rooms</td>"; echo "<td align='center'>$meals</td>"; echo "<td align='right' style='padding-right:10px;'>$totals</td> <td>$remhotel</td> <td>$addservices</td>"; echo "</tr>"; $x++; } ?> <tr> <td colspan='8'>Total</td> <td colspan='4' style="font-weight:bolder;padding-left: 20px;"><?php echo $grand_total.'/-';?></td> </tr> </table> <br /> <table border="1" style="width:100%;font-size:13px;"> <tr> <th colspan="6" style="font-size:14px; color:#FF0000;">TRANSFERS & SIGHTSEEING</th> </tr> <tr> <th style='width:5%'>Sl_No</th> <th style='width:15%'>Vehicle Type</th> <th style='width:50%'>Description</th> <th style='width:10%'>Cab Charges</th> <th style='width:10%'>Advance</th> <th style='width:10%'>Balance</th> </tr> <?php $resultserpt = $js->prepare('SELECT * FROM `travelassistance` WHERE custid = :cid ORDER BY `id` '); $resultserpt->execute(array(':cid' => $cid)); ?> <?php $x = 1; while($rowserp = $resultserpt->fetch(PDO::FETCH_ASSOC)) { $vehicle = $rowserp['vehicle']; $descr = $rowserp['descr']; $des = nl2br($descr); $charge = $rowserp['vehiclecharge']; $vehcharge += $charge; echo "<tr>"; echo "<td align='center'>$x</td>"; echo "<td style='padding-left:10px; padding-top:10px; padding-bottom:10px; padding-right:10px;'>$vehicle</td>"; echo "<td style='padding-left:10px; padding-top:10px; padding-bottom:10px; padding-right:10px;'>$des</td>"; echo "<td align='center'>$charge</td> <td></td> <td></td>"; echo "</tr>"; $x++; } ?> </table> <br /> <table border="1" style="font-size:13px;width:100%"> <tr> <th colspan="6" style="font-size:14px; color:#FF0000;">OTHER SERVICES</th> </tr> <tr> <th style='width:5%'>#</th> <th style='width:20%'>Item</th> <th style='width:45%'>Description</th> <th style='width:10%'>Actual Cost</th> <th style='width:10%'>Guest Rate</th> <th style='width:10%'>Profit</th> </tr> <?php $resultother = $js->prepare('SELECT * FROM `otherservices` WHERE custid = :cid ORDER BY `id` '); $resultother->execute(array(':cid' => $cid)); ?> <?php $x = 1; while($rowserp = $resultother->fetch(PDO::FETCH_ASSOC)) { $services = $rowserp['services']; $descr = $rowserp['descr']; $amount = $rowserp['amount']; $totother += $amount; echo "<tr style='line-height:28px;'>"; echo "<td align='center'>$x</td>"; echo "<td align='center'>$services</td>"; echo "<td align='center'>$descr</td>"; echo "<td align='right' style='padding-right:10px;'>$amount</td>"; echo "<td></td><td></td>"; echo "</tr>"; $x++; } ?> <!-- <tr> <td><input type='text' style='border:none;width:100px;'></td> <td><input type='text' style='border:none;width:100px;'></td> <td><input type='text' style='border:none;width:400px;'></td> <td><input type='text' style='border:none;width:100px;'></td> <td><input type='text' style='border:none;width:100px;'></td> <td><input type='text' style='border:none;width:100px;'></td> </tr> <tr> <td><input type='text' style='border:none;width:100px;'></td> <td><input type='text' style='border:none;width:100px;'></td> <td><input type='text' style='border:none;width:400px;'></td> <td><input type='text' style='border:none;width:100px;'></td> <td><input type='text' style='border:none;width:100px;'></td> <td><input type='text' style='border:none;width:100px;'></td> </tr> --> </table> <?php $add = 'additional'; $resultadd = $js->prepare('SELECT * FROM `customer_expense` WHERE custid = :cid AND payhead = :add '); $resultadd->execute(array(':cid' => $cid, ':add' => $add)); $addcount = $resultadd->rowCount(); if($addcount > '0') { $z=1; ?> <table border="1" style="font-size:13px;width:100%"> <tr> <th colspan="6" style="font-size:14px; padding:8px;">ADDITIONAL EXPENSES</th> </tr> <tr> <th style='width:5%'>#</th> <th style='width:20%'>Paid To</th> <th style='width:45%'>Paid for / Description</th> <th style='width:10%'>Payment Mode</th> <th style='width:10%'>Paid</th> </tr> <?php while($rowadd = $resultadd->fetch(PDO::FETCH_ASSOC)) { $paidto = $rowadd['paidto']; $paidfor = $rowadd['pdescription']; $addamount = $rowadd['payamount']; $addexp += $addamount; $pmode = $rowadd['pmode']; echo "<tr>"; echo "<td>$z</td>"; echo "<td>$paidto</td>"; echo "<td>$paidfor</td>"; echo "<td>$pmode</td>"; echo "<td align='right'>$addamount</td>"; echo "</tr>"; $z++; } ?> </table> <?php } $totexp = $totother + $vehcharge + $grand_total + $addexp; $profit = $package - $totexp; ?> <br> <table style='width:100%' > <tr> <td width="50%" > <table style='width:100%'> <tr> <td colspan='3'><span style='text-decoration:underline;font-weight:bold'>CheckList</span></td> </tr> <tr> <td>1.</td> <td>Payment</td> <td>:<input type="text"/></td> </tr> <tr> <td>2.</td> <td>Voucher</td> <td>:<input type="text"/></td> </tr> <tr> <td>3.</td> <td>Reconfirmation</td> <td>:<input type="text"/></td> </tr> </table> </td> <td style='vertical_align:center'> <table style='width:100%' border='1' style="float: right;border: 1px solid #8A8A7F;"> <tr> <th style='width:33%'>Package Amount</th> <th style='width:33%'>Package Expense</th> <th style='width:33%'>Profit</th> </tr> <tr style="line-height:100px;"> <td align='center'><span><?php echo $package?></span></td> <td align="center"><?php echo $totexp?></td> <td align="center"><?php echo $profit?></td> </tr> </table> </td> </tr> </table> </div> </body> </html>