invisio v2.0

<!DOCTYPE html>
<html lang="ar">
<meta charset="utf-8">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>SERVICE VOUCHER</title>
	<head>
    
    <script type="text/javascript">
<!-- 
/*var message=""; 
function clickIE() {if (document.all) {(message);return false;}} 
function clickNS(e) {if 
(document.layers||(document.getElementById&&!document.all)) { 
if (e.which==2||e.which==3) {(message);return false;}}} 
if (document.layers) 
{document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;} 
else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}

document.oncontextmenu=new Function("return false");

if(e.ctrlKey && e.shiftKey && e.keyCode == 'C'.charCodeAt(0)){
     return false;
    }      
 }*/
</script>
    
    
    <script type="text/javascript">
     /*  window.onafterprint = window.close;
       window.print();*/
      </script>
		
		<style>
			table {
				border-spacing: 3px;
				padding:2px;
			}
		</style>
		<script>
/*			function printpage() {
				window.print();
			}
*/		</script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<style>
@page {
    size: A4;
	margin: 13px !important;
    
}
@media print {
  #footer {
    position:fixed;
	margin-left:-0.75%;
	bottom:0;
  }
  body {-webkit-print-color-adjust: exact; page-break-after:always;}
  .noprint {display:none;}
  #tables
  {
	padding-left:100px;
	padding-right:100px;  
  }
}

@media print { 
   table {
        page-break-inside: auto;
      }
      tr{
        page-break-inside: avoid;
        page-break-after: auto;
      }
	  img-container{
        page-break-inside: avoid;
        page-break-after: auto;
      }
	 /* #sme{display: block; width: 100%; height: 100%;page-break-inside: avoid;}      */
      
}

#container {
  margin-bottom: 2em;
  min-height: 100%;
  clear: both;
  padding: 0 2em;
  text-align: justify;
  padding-left:100px;
  padding-right:100px;
}

</style>
	</head>
	<body style='color:#254E78;font-size:13px; '>
		<?php

$cid = $_GET['id'];
		
		$totpay = '0.000';
		
		include('config.php');
		include('example.php');
		
		$results = $js->prepare('SELECT * FROM `invoiced` WHERE cust = :cid ');
		$results->execute(array(':cid' => $cid));
		  
		while($rows = $results->fetch(PDO::FETCH_ASSOC)) 
		  {
			  	$id = $rows['id'];
				$invid = $rows['invid'];
				$descr = $rows['descr'];
				$invamount = $rows['invamount'];
				$invdate = $rows['invdate'];
				$currency = $rows['currency'];
		  }
		  
		  $duedate =  date('d-m-Y', strtotime($invdate. ' + 2 days - 1 day'));
		  /*$duedate =  date('d-m-Y', strtotime($invdate. ' + 31 days - 1 day'));*/
		  
		  $qedate = date('d-m-Y', strtotime($invdate));
		
		$i = 1;
		
		$resultq = $js->prepare('SELECT * FROM `invoicepayments` WHERE invoiceid = :id');
		$resultq->execute(array(':id' => $id));
		while($rowq = $resultq->fetch(PDO::FETCH_ASSOC)) 
		{
			$pay = $rowq['payamount'];
			$totpay += $pay;
			$balance = $rowq['balance'];
			$pcurrency = $rowq['currency'];
		}
		if($balance == '')
		{
			$balance = $invamount;	
		}
		if($pcurrency == '')
		{
			$pcurrency = $currency;	
		}
			
		$result = $js->prepare('SELECT * FROM `customer_entry` WHERE `id` = :cid');
		$result->execute(array(':cid' => $cid));
		
		while($row = $result->fetch(PDO::FETCH_ASSOC)) 
										{
											$compname = $row['companyname'];
											$custname = $row['custname'];
											$custid = $row['custid'];
											$resultid = mb_substr($custid, 3);
											$phone = $row['phone'];
											$email = $row['email'];
											$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'));
										}

$result2 = $js->prepare('SELECT * FROM `clients` WHERE `compid` = :client');
				$result2->bindParam(':client', $client);
				$result2->execute();
				while($row2 = $result2->fetch(PDO::FETCH_ASSOC)) {
					//$contact_person = $row2['contact_person'];
					
					$crno = $row2['crno'];
					$contact = $row2['contact_person'];
					$compaddr = $row2['compaddr'];
					if($client == '1409202273')
					{
						$contact = $row2['comptele'];
					}	
					$comploc = $row2['comploc'];
					$results = $js->prepare('SELECT * FROM `locations` WHERE id = :comploc ');
					$results->execute(array(':comploc' => $comploc));
					  
					  while($rows = $results->fetch(PDO::FETCH_ASSOC)) 
						{
						   $lid = $rows['id'];
						   $locname = $rows['loc_name'];
						}
						if($locname == '')
						{
							$locname = $comploc;	
						}
						$clientvat = $row2['vatno'];
						
						$results = $js->prepare('SELECT * FROM `customerdetails` WHERE cid = :cid ');
						$results->execute(array(':cid' => $cid));
						  
						  while($rows = $results->fetch(PDO::FETCH_ASSOC)) 
							{
							   $arrivalto = $rows['arrivalto'];
							   $arrivaldate = $rows['arrivaldate'];
							   $arrtime = $rows['arrivaltime'];
							   $arrflight = $rows['arrivalflight'];
							   $depto = $rows['depto'];
							   $deptdate = $rows['depdate'];
							   $deptime = $rows['deptime'];
							   $depdate = $rows['depdate'];
							   $depflight = $rows['deptflight'];
							}
				}

?>
<meta charset="utf-8" />
		<title><?php echo $custname?> - SERVICE VOUCHER FOR <?php echo strtoupper($descr); ?> </title>
<script>
function myFunction() {
    window.print();
}
</script>
<style type="text/css" media="print">

body {
 /* zoom:75%;*/ /*or whatever percentage you need, play around with this number*/
}

</style>

@media print {
	
	table.paging thead td, table.paging tfoot td {
        height: .5in;
    }
footer{
	position: fixed;
}
    footer {
        bottom: 0;
    }
	.noprint {display:none;}
}
</style>

</table>
  </tfoot>

<tr>
            
            <td align="center" style='width:32%;text-align:center;'><span style='font-weight:bold;'><h2>SERVICE VOUCHER</h2></span></td>
            
        </tr>
        </table>
         <p align="left"><strong>CLIENT DETAILS</strong></p> <hr>
        <table align="left" style="margin-top:0px;" width="50%">
        
        <tr>
        	<td>Client Name</td>
            <td>:</td>
            <td><?php echo $custname?></td>
        </tr> 
        <tr>
        	<td>No of Pax</td>
            <td>:</td>
            <td>6 ADULTS & 1 CHILD OF 6 YEARS</td>
        </tr> 
        <tr>
        	<td>Arrival To</td>
            <td>:</td>
            <td><?php echo strtoupper($arrivalto);?></td>
        </tr>
        <tr>
        	<td>Arrival Time</td>
            <td>:</td>
            <td><?php echo strtoupper($arrtime." on ".$arrivaldate);?></td>
        </tr>
        <tr>
        	<td>Arrival Flight No</td>
            <td>:</td>
            <td><?php echo $arrflight?></td>
            
        </tr>  
		</table>
        <table align="right" style="margin-top:0px;" width="50%">
        <tr>
        	<td>Package Name</td>
            <td>:</td>
            <td>5 DAYS OMAN PACKAGE </td>
        </tr> 
        <tr>
        	<td>Travel Dates</td>
            <td>:</td>
            <td><?php echo $pdate?> to <?php echo $todate?></td> 
        </tr> 
        <tr>
        	<td>Departure From</td>
            <td>:</td>
            <td><?php echo strtoupper($depto);?></td>
        </tr>
        <tr>
        	<td>Departure Time</td>
            <td>:</td>
            <td><?php echo strtoupper($deptime." on ".$depdate);?></td>
        </tr>
        <tr>
        	<td>Departure Flight No</td>
            <td>:</td>
            <td><?php echo $depflight?></td> 
        </tr> 
		</table> 
        </div>
		
       <div style="margin-top:20px;" >
       	
       
      <?php
	  	
		  
	  	
		  $resultserp = $js->prepare('SELECT * FROM `hotelreservations` WHERE custid = :cid ORDER BY `cindate` ');
		  $resultserp->execute(array(':cid' => $cid)); 
		  $hcount = $resultserp->rowCount();
		  
		  if($hcount != '0')
		  {
	  ?>
        <table class="table table-bordered" id="mydatatable" width="100%" cellpadding="7" border="1" style="border-collapse:collapse;"> 
        	<thead>
            <tr>
            	<td colspan="8" style="padding-left:30px;"> <strong>ACCOMMODATIONS</strong></td>
            </tr>	
            
            	<tr align="center" >
            	<th style="padding-left:5px; padding-right:5px;">SL No</th>
                <th>Location </th>
                <th>Hotel Name</th>
                <th>Check-In</th>
                <th>Check-Out</th>
                <th>Room Type</th> 
                <th>No. of Rooms</th>
                <th>Meals Included</th>               
            </tr>
            </thead>
            
            <?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 >= '1')
													{
														$norooms = $norooms.' + '.$noebs.' Extra-bed';	
													}
													$meals = $rowserp['meals'];
													$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'>$norooms</td>";
														echo "<td align='center'>$meals</td>";
													echo "</tr>";
													
												
													$x++;
													
													
												}
																							
											
											
			?>
            
        </table><br>
        <?php
		  }
		  
		  $resultserpt = $js->prepare('SELECT * FROM `travelassistance` WHERE custid = :cid ORDER BY `id` ');
		  $resultserpt->execute(array(':cid' => $cid)); 
		  $tcount = $resultserpt->rowCount();
		  if($tcount != '0')
		  {
		?>
         <table class="table table-bordered" id="mydatatable" width="100%" cellspacing="0" border="1" style="border-collapse:collapse;"> 
        	<thead>
            <tr>
            	<td colspan="6" style="padding-left:30px;"><strong>TRANSFERS AND TOURS</strong></td>
            </tr>	
            
            	<tr align="center" >
            	<th style="padding-left:5px; padding-right:5px;">SL No</th>
                <th>Vehicle Type </th>
                <th>Description </th>
        
            </tr>
            </thead>
            
            <?php
											
												$x = 1;
													
												
												while($rowserp = $resultserpt->fetch(PDO::FETCH_ASSOC)) 
												{
													$vehicle = $rowserp['vehicle'];
													$descr = $rowserp['descr'];
													$des = nl2br($descr);

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 "</tr>";
													
												
													$x++;
													
													
												}
			?>
            
        </table>
        <?php
		  }
			$resultother = $js->prepare('SELECT * FROM `otherservices` WHERE custid = :cid ORDER BY `id` ');
			$resultother->execute(array(':cid' => $cid)); 
			$count = $resultother->rowCount();
			if($count != '0')
			{
		?>
        
        <br>
         <table class="table table-bordered" id="mydatatable" width="100%" cellspacing="0" border="1" style="border-collapse:collapse;"> 
        	<thead>
            <tr>
            	<td colspan="6" style="padding-left:30px;"> <strong>ACTIVITIES</strong></td>
            </tr>	
            
            	<tr align="center" >
            	<th style="padding-left:5px; padding-right:5px;">SL No</th>
                <th>Service </th>
                <th>Description </th>
        		
            </tr>
            </thead>
            
            <?php
											
												$x = 1;
													
												
												while($rowserp = $resultother->fetch(PDO::FETCH_ASSOC)) 
												{
													$services = $rowserp['services'];
													$descr = $rowserp['descr'];
													$amount = $rowserp['amount'];
													$totother += $amount;

echo "<tr>";
														echo "<td align='center'>$x</td>"; 
														echo "<td align='center'>$services</td>";
														echo "<td style='padding-left:10px; padding-top:10px; padding-bottom:10px; padding-right:10px;'>$descr</td>";
														/*echo "<td align='right' style='padding-right:10px;'>$amount</td>";*/
													echo "</tr>";
													
												
													$x++;
													
													
												}
			?>
            
        </table> </div>
        <?php
			
			
			}
			$totalcost = $invamount;
		?>
        <br>
        
        <h3>TOUR CORDINATOR CONTACT IN OMAN</h3>
        <p align="justify" style="line-height:30px;">
        	<table>
            <tr>
            	<td>NAME</td><td> : JAMES </td>
            </tr>
            <tr>
            	<td>MOBILE</td><td> : +968 941 55255</td>
            </tr>
            <tr>
            	<td> EMAIL</td><td> : james@thefalconexpeditions.com </td>
            </tr>
            </table>
        </p>
        
          <?php
		  //	if($additional != '')
			//{
		  ?>
         
          <?php //echo $additional?>
          <?php
			//}
		  ?>
         
        
						
        
</td></tr></tbody><tfoot><tr><td>&nbsp;</td></tr></tfoot></table>

<div class="noprint">
<p align="center"><a href="#" onClick="myFunction()" style="border:5px solid; background-color:#093; color:#FFF; padding:8px; text-decoration:none;">PRINT</a> </p>
<p align="center"><a href="home.php" style="border:5px solid; background-color:#093; color:#FFF; padding:8px; text-decoration:none;">CLOSE</a> </p>
</div>

<?php
define("Riyals", 'pounds'); 
define("Baise", 'p');
class toWords
{
    var $pounds;
    var $pence;
    var $major;
    var $minor;
    var $words = '';
    var $number;
    var $magind;
    var $units = array('', 'one', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight', 'nine');
    var $teens = array('ten', 'eleven', 'twelve', 'thirteen', 'fourteen', 'fifteen', 'sixteen', 'seventeen', 'eighteen', 'nineteen');
    var $tens = array('', 'ten', 'twenty', 'thirty', 'forty', 'fifty', 'sixty', 'seventy', 'eighty', 'ninety');
    var $mag = array('', 'thousand', 'million', 'billion', 'trillion');

function toWords($amount, $major = Riyals, $minor = Baise)
    {
        $this->__toWords__((int)($amount), $major);
        $whole_number_part = $this->words;
        #$right_of_decimal = (int)(($amount-(int)$amount) * 100);
        $strform = number_format($amount,3);
        $right_of_decimal = (int)substr($strform, strpos($strform,'.')+1);
        $this->__toWords__($right_of_decimal, $minor);
        $this->words = $whole_number_part . ' ' . $this->words;
    }