invisio v2.0

<!DOCTYPE html>
<html lang="en">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<head>
    <script type="text/javascript">
         window.onafterprint = window.close;
         window.print();
      </script>
	<meta charset="utf-8" />
	<style>
	td {
		vertical-align: bottom;
	}
	</style>
	</head>
	
	<?php
	include('config.php');
	ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
	
	
	$id = $_GET['payment'];
	
	$result = $js->prepare('SELECT * FROM `invoicepayments` WHERE id = :id');
	$result->execute(array(':id' => $id));
	while($rowinv0 = $result->fetch(PDO::FETCH_ASSOC)) 
	{
		$payid = $rowinv0['payid'];
		$invid = $rowinv0['invoiceid'];
		$expdate = date('d-m-Y', strtotime($rowinv0['paydate']));
		$payamount = $rowinv0['payamount'];
	
		//$words = displaywords(722.01);
		$mode = $rowinv0['mode'];
		$premarks = $rowinv0['remarks'];
	}
	
	$resultinv1 = $js->prepare('SELECT * FROM `invoiced` WHERE id = :invid');
	$resultinv1->execute(array(':invid' => $invid));
	while($rowinv = $resultinv1->fetch(PDO::FETCH_ASSOC)) 
	{
		$project = strtoupper($rowinv['descr']);
		$comid = $rowinv['cust'];
		$invamount = $rowinv['invamount'];
		$currency = $rowinv['currency'];
		$invoice = $rowinv['invid'];
	}
	
	$net = $invamount;

$result2 = $js->prepare('SELECT * FROM `customer_entry` WHERE `id` = :comid');
	$result2->bindParam(':comid', $comid);
	$result2->execute();
	while($row2 = $result2->fetch(PDO::FETCH_ASSOC)) {
		$contact_person = $row2['custname'];
		$compname = $row2['companyname'];
		$pdate = date('d-m-Y', strtotime($row2['plannningdate']));
		$days = $row2['daysplanning'];
		$todate = date('d-m-Y', strtotime($pdate.' + '.$days.' days - 1 day'));
	}

?>
<script>
function myFunction() {
    window.print();
}
</script>

@media print {
	
  
	.noprint {display:none;}
	
	body
	{
	  margin: 5mm 5mm 5mm 5mm;
	  zoom:90%; 
	  font-size:14px;
	}
}
</style>
<body>

<table cellpadding='0' cellspacing='0' width="100%" style=" font-size:18px;">
                            <span> 
							<tr>
                            	<td align="left"> 
                           <strong><span style="font-size:35px"> رحلات الصقر للتجارة ش م م </span><br> <span style="font-size:24px;"> FALCON EXPEDITIONS TRADE LLC</span> </strong>
                           		<br> PO Box: 102 , Postal Code: 114, Bousher, Muscat, Sultanate of Oman <br>
                                 <span>Tel : +968 941 55255 | Email : reservations@thefalconexpeditions.com </span> 
                            </td>
                            	<td align="center"><img src="images/falcons.PNG" style="margin:5px;" ></td>
                           
                           
							</tr>
                            </table>
                            
                            <hr style="width:100%; border-color:#0046A5; color:#0046A5">
<table style="width:100%;" cellpadding="5" cellspacing="5" >
							
                            
<tr>
<td colspan='4' align="center" style="font-size:20px;">
							
							
							<strong><center>PAYMENT RECEIPT</center></strong>
							
							</td>
							</tr>
                            <tr>
                            	<td colspan="2">Date : <?php echo $expdate?></td>
                                <td align="right" colspan="2">Receipt No : <?php echo $payid?></td>
                            </tr>
							<tr>
							<td style="border-bottom:1px solid #000"> 
							<br>Received from / مستلم من
							</td>
                            
							<td style="border-bottom:1px solid #000" colspan='3'><span style=" font-size:14px;"><?php echo strtoupper($contact_person);?> </span></td>
						
</td>
</tr>
							<tr>
							<td style="border-bottom:1px solid #000"><br>
							Against / ضد
							</td>
                            
							<td style="border-bottom:1px solid #000" colspan='3'><span style=" font-size:14px;">INVOICE : <?php echo $invoice?> </span></td>
						
</td>
</tr>
							<tr>
							<td style="border-bottom:1px solid #000"><br/>
							Towards  / تجاه
							</td>
							<td style="border-bottom:1px solid #000" colspan='3'><span style="font-size:14px;"><?php echo $project; ?> (<?php echo $pdate?> To <?php echo $todate?>)</span></td>
							</tr>
<tr>
							<td style="border-bottom:1px solid #000" ><br/>
							An amount of / كمية من
							</td>
							<td style="border-bottom:1px solid #000" colspan='3'> <?php echo $currency?> <?php echo $payamount ?></td>
							
							</tr>
							
							<tr>
							<td style="border-bottom:1px solid #000">							
							<br>
							By  / بواسطة
							<td style="border-bottom:1px solid #000" > <span style=" font-size:14px;"><?php echo $mode;	?></span></td>
							<td style="border-bottom:1px solid #000"><br/>with reference / مع مرجع</td>
							<td style="border-bottom:1px solid #000"><span style=" font-size:14px;"><?php echo $premarks ?></span></td>
							</tr>
							
							<tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr>
                           <tr>
                           	<td colspan="2" align="left"> </td>
							<td colspan="3" align="right"><br><img src="images/STAMP AND SIGN.jpg"><BR>AUTHORIZED SIGNATORY</td>

</tr>
                            </td>
							</table>
<div class="noprint" style="margin-top:30px;">
<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="invoicepayments.php" style="border:5px solid; background-color:#093; color:#FFF; padding:8px; text-decoration:none;">CLOSE</a> </p>
</div>
</body>

<?php
function displaywords($number){
   $no = (int)floor($number);
   $point = (int)round(($number - $no) * 100);
   $hundred = null;
   $digits_1 = strlen($no);
   $i = 0;
   $str = array();
   $words = array('0' => '', '1' => 'one', '2' => 'two',
    '3' => 'three', '4' => 'four', '5' => 'five', '6' => 'six',
    '7' => 'seven', '8' => 'eight', '9' => 'nine',
    '10' => 'ten', '11' => 'eleven', '12' => 'twelve',
    '13' => 'thirteen', '14' => 'fourteen',
    '15' => 'fifteen', '16' => 'sixteen', '17' => 'seventeen',
    '18' => 'eighteen', '19' =>'nineteen', '20' => 'twenty',
    '30' => 'thirty', '40' => 'forty', '50' => 'fifty',
    '60' => 'sixty', '70' => 'seventy',
    '80' => 'eighty', '90' => 'ninety');
   $digits = array('', 'hundred', 'thousand', 'lakh', 'crore');
   while ($i < $digits_1) {
     $divider = ($i == 2) ? 10 : 100;
     $number = floor($no % $divider);
     $no = floor($no / $divider);
     $i += ($divider == 10) ? 1 : 2;

if ($number) {
        $plural = (($counter = count($str)) && $number > 9) ? 's' : null;
        $hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
        $str [] = ($number < 21) ? $words[$number] .
            " " . $digits[$counter] . $plural . " " . $hundred
            :
            $words[floor($number / 10) * 10]
            . " " . $words[$number % 10] . " "
            . $digits[$counter] . $plural . " " . $hundred;
     } else $str[] = null;
  }
  $str = array_reverse($str);
  $result = implode('', $str);

if ($point > 20) {
    $points = ($point) ?
      "" . $words[floor($point / 10) * 10] . " " . 
          $words[$point = $point % 10] : ''; 
  } else {
      $points = $words[$point];
  }
  if($points != ''){        
      echo $result . "Rupees  " . $points . " Paise Only";
  } else {

echo $result . "Rupees Only";
  }

}