/invoice_print.php
PHP | 258 lines | 219 code | 12 blank | 27 comment | 14 complexity | d0e95327b9135275d06e35a86792c6b7 MD5 | raw file
- <?
- ob_start();
- session_start();
- define( '_TEXEC', 1 );
- define('TPATH_BASE', dirname(__FILE__) );
- define( 'DS', DIRECTORY_SEPARATOR );
- require_once ( TPATH_BASE .DS.'includes'.DS.'defines.php' );
- require_once ( TPATH_BASE .DS.'includes'.DS.'configuration.php' );
- if($_GET['id'] != ""){
- $iBookingId=$_GET['id'];
- }else{
- $iBookingId = $id;
- }
- if($_GET['print'] != ""){
- $print_page=$_GET['print'];
- }
- //$sql = "SELECT b.*,c.vName as currency FROM booking as b LEFT JOIN currency as c ON c.iCurrencyId=b.iCurrencyId WHERE iBookingId = '".$iBookingId."'";
- $sql="select * from booking_new where iBookingId='".$iBookingId."'";
- $db_booking = $obj->MySQLSelect($sql);
- #echo "<pre>"; print_r($db_booking); exit;
- $tot_commision = $db_booking[0]['fCommission'];
- $tot_vat = $db_booking[0]['fVat'];
- $tot_ride_price = $db_booking[0]['fRidePrice'];
- $tot_price = $db_booking[0]['fAmount'];
- /*$sql="select SUM(fPrice) as ride_price, SUM(fCommission) as sitecommission,SUM(fVat) as totvat,SUM(fTotPrice) as totprice from ride_points_new where iRideId='".$db_booking[0]['iRideId']."' AND iRidePointId IN(".$db_booking[0]['iRidePointId'].")";
- $db_tot_price = $obj->MySQLSelect($sql);
- $tot_commision = $db_tot_price[0]['sitecommission'];
- $tot_vat = $db_tot_price[0]['totvat'];
- $tot_ride_price = $db_tot_price[0]['ride_price'];
- $tot_price = $db_tot_price[0]['totprice'];*/
-
- /*$ridepoint = explode(",",$db_booking[0]['iRidePointId']);
- $tot_commision = 0;
- $tot_vat = 0;
- $tot_ride_price = 0;
- $tot_price = 0;
- for($i=0;$i<count($ridepoint);$i++){
- $sql="select fPrice, fCommission, fVat,fTotPrice from ride_points_new where iRideId='".$db_booking[0]['iRideId']."' AND iRidePointId = '".$ridepoint[$i]."'";
- $db_tot = $obj->MySQLSelect($sql);
- $tot_commision = $tot_commision + $db_tot[0]['fCommission'];
- $tot_vat = $tot_vat + $db_tot[0]['fVat'];
- $tot_ride_price= $tot_ride_price + $db_tot[0]['fPrice'];
- $tot_price = $tot_price + $db_tot[0]['fTotPrice'];
- } */
- #echo $tot_commision." ".$tot_vat." ".$tot_ride_price." ".$tot_price; exit;
- if($print_page == "yes")
- {
- ?>
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
- <html>
- <head>
- <title>Details of Booking No : <?=$db_booking[0]["vBookingNo"];?></title>
- <meta http-equiv=content-type content=text/html;charset=UTF-8>
- <script language="JavaScript1.1">
- function popupwin()
- {
- ans=confirm("Ready To Print");
- if(ans==true)
- {
- document.getElementById("printbtn1").style.display="none";
- document.getElementById("closebtn1").style.display="none";
- /*document.getElementById("printbtn2").style.display="none";
- document.getElementById("closebtn2").style.display="none";*/
- window.print();
- document.getElementById("printbtn1").style.display="";
- document.getElementById("closebtn1").style.display="";
- /*document.getElementById("printbtn2").style.display="";
- document.getElementById("closebtn2").style.display="";*/
- }
- }
- function closed()
- {
- var win = window.open('', '_self');
- win.close();
- }
- </script>
- </head>
- <body>
- <table width="100%" border="0">
- <tr>
- <td>
- <img src="<? echo $tconfig['tsite_images']; ?>cp/admin-logo.png">
- </td>
- <td align="right"><input class="btn" type="button" onClick="popupwin()" id="printbtn1" name="printbtn1" value="Print" title="Print" /> <input class="btn" type="button" onClick="javascript:closed();" id="closebtn1" name="closebtn1" value="Close" title="Close" />
- </td>
- </tr>
- <tr>
- <td>
-
- </td>
- </tr>
- </table>
- <?
- }
- else
- {
- ?>
- <table width="600">
- <?
- }
- ?>
- <tr>
- <td colspan="2" bgcolor="#EAEAEA"><font style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:14px; font-weight:bold; color:#000000; text-decoration:none;">Details of Booking #<?echo $db_booking[0]["vBookingNo"];?></font></td>
- </tr>
- <tr>
- <td colspan="2">
- <table width="100%" align="center" style="border-left:1px solid #D4D2C8; border-right:1px solid #D4D2C8; border-top:1px solid #D4D2C8; border-bottom:1px solid #D4D2C8;margin-top:10px;" border="0">
- <tr bgcolor="#ffffff">
- <td style="padding:5px;">
- <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
- <tr>
- <td width="50%" valign="top">
- <table width="100%" border="0">
- <tr style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;">
- <td width="48%"><strong>Booking No.</strong></td>
- <td width="4%">:</td>
- <td width="48%"><?=$db_booking[0]["vBookingNo"];?></td>
- </tr>
- <tr style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;">
- <td><strong>Booking Payment Date</strong></td>
- <td>:</td>
- <td><?=$generalobj->DateTime($db_booking[0]["dPaymentDate"],'10')?></td>
- </tr>
- <tr style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;">
- <td><strong>Booker Payment Status</strong></td>
- <td>:</td>
- <?if($db_booking[0]["eBookerPaymentPaid"] == 'Yes'){?>
- <td>Paid</td>
- <? }elseif($db_booking[0]["eBookerPaymentPaid"] == 'No'){ ?>
- <td>Unpaid</td>
- <? }else{ ?>
- <td>Refund</td>
- <? } ?>
- </tr>
- <tr style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;">
- <td><strong>Payment Method</strong></td>
- <td>:</td>
- <td>
- <?=$db_booking[0]["ePaymentType"];?>
- </td>
- </tr>
- </table>
- <br>
- </td>
- <td align="right" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;">
- <b><?echo $STORE_NAME;?></b><br />
- <?echo nl2br($STORE_ADDRESS);?><br /><br />
- <?echo nl2br($STORE_CONTACT_NO);?><br />
- <?=$site_url?><br />
- <br />
- </td>
- </tr>
-
- <tr>
- <td colspan="2">
- <?
- if(count($db_booking) > 0)
- {
- ?>
- <table align="center" style="border-left:1px solid #D4D2C8; border-right:1px solid #D4D2C8; border-top:1px solid #D4D2C8; border-bottom:1px solid #D4D2C8;" border="0" cellpadding="0" cellspacing="1" width="100%">
- <tr style="background-color:#D4D2C8; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold; color:#000000; height:20px;">
- <td height="20" align="left" width="80%" style="padding-left:3px;">Booking Details</td>
- <td align="right" width="20%">Booking Amount</td>
- </tr>
-
- <tr>
- <td height="24" valign="top" align="left" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;padding-left:3px;"><?=stripslashes($db_order_detail[$i]["vMainRidePlaceDetails"]);?>
- <table width="100%" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;">
- <tr><td width="20%">Number of Seats </td><td width="80%">: <?=$db_booking[0]['iNoOfSeats'];?></td></tr>
- <tr>
- <td width="20%">Categories </td>
- <td width="80%">:
- <?=($db_booking[0]['fBoxPrice']!='0.00')?' Box ('.$db_booking[0]['vBookerCurrencyCode'].' '.$db_booking[0]['fBoxPrice'].')':'';?>
- <?=($db_booking[0]['fDocPrice']!='0.00')?' Document ('.$db_booking[0]['vBookerCurrencyCode'].' '.$db_booking[0]['fDocPrice'].')':'';?>
- <?=($db_booking[0]['fLuggagePrice']!='0.00')?' Luggage ('.$db_booking[0]['vBookerCurrencyCode'].' '.$db_booking[0]['fLuggagePrice'].')':'';?>
- </td>
- </tr>
- <tr><td>Booking Date. </td><td>: <?=$generalobj->DateTime($db_booking[0]["dBookingDate"],'10')?></td></tr>
- </table>
- </td>
- <td align="right" valign="top" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;"><?=$db_booking[0]['vBookerCurrencyCode']." ".$db_booking[0]['fAmount'];?></td>
- <!--<td align="right" valign="top" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;"><?=$generalobj->booking_currency($db_booking[0]['fAmount'], $db_booking[0]['vBookerCurrencyCode']);?></td>-->
- </tr>
-
-
- <tr bgcolor="#ffffff">
- <td width="80%" align="right" style="background-color: #FAF9F3;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold; color:#610103; text-decoration:none;" height="17"><strong>Ride Price :</strong></td>
- <td width="20%" align="right" style="background-color: #FAF9F3;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold; color:#610103; text-decoration:none;"><strong><?=$db_booking[0]['vBookerCurrencyCode']." ".$tot_ride_price;?></strong></td>
- </tr>
- <tr bgcolor="#ffffff">
- <td width="80%" align="right" style="background-color: #FAF9F3;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold; color:#610103; text-decoration:none;" height="17"><strong>Platform fee :</strong></td>
- <td width="20%" align="right" style="background-color: #FAF9F3;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold; color:#610103; text-decoration:none;"><strong><?=$db_booking[0]['vBookerCurrencyCode']." ".$tot_commision;?></strong></td>
- </tr>
- <tr bgcolor="#ffffff">
- <td width="80%" align="right" style="background-color: #FAF9F3;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold; color:#610103; text-decoration:none;" height="17"><strong>VAT :</strong></td>
- <td width="20%" align="right" style="background-color: #FAF9F3;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold; color:#610103; text-decoration:none;"><strong><?=$db_booking[0]['vBookerCurrencyCode']." ".$tot_vat;?></strong></td>
- </tr>
- <tr bgcolor="#ffffff">
- <td width="80%" align="right" style="background-color: #FAF9F3;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold; color:#610103; text-decoration:none;" height="17"><strong>Grand Total :</strong></td>
- <td width="20%" align="right" style="background-color: #FAF9F3;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold; color:#610103; text-decoration:none;"><strong><?=$db_booking[0]['vBookerCurrencyCode']." ".$tot_price;?></strong></td>
- </tr>
- </table>
- <? } ?>
- </td>
- </tr>
- <tr>
- <td colspan="2"> </td>
- </tr>
-
- <tr>
- <td colspan="2">
- <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%">
- <tr>
- <td style="background-color:#FAF9F3; border:1px solid #D4D2C8; padding:5px;line-height:17px;" valign="top" width="49%">
- <span style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;"><strong>Booker Details</strong>
- <hr size="1" />
- <table width="100%" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; text-decoration:none;">
- <tr><td width="15%">Name</td><td width="85%">: <b><?=$db_booking[0]['vBookerFirstName']." ".$db_booking[0]['vBookerLastName'];?></b></td></tr>
- <tr><td>Booking Date</td><td>: <b><?=$generalobj->DateTime($db_booking[0]["dBookingDate"],'10');?></b></td></tr>
- <tr><td>Email</td><td>: <b><?=$db_booking[0]['vBookerEmail'];?></b></td></tr>
- <tr><td>Phone</td><td>: <b><?=$db_booking[0]['vBookerPhone'];?></b></td></tr>
- <tr><td>Address</td><td>: <b><?=$db_booking[0]['vBookerAddress'];?></b></td></tr>
- </table>
- </span>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </td>
- <?
- if($print_page == "yes")
- {
- ?>
- </td>
- </tr>
- </table>
- </body>
- </html>
- <?}else{?>
- </table>
- <? } ?>
- <?
- if($print_page == "yes")
- {
- exit;
- }
- ?>