invisio v2.0

<!DOCTYPE html>
<html lang="en">
	<head>
	<meta charset="utf-8" />
	<link rel="stylesheet" href="style.css" type="text/css" / >
	<style>
	td {
		vertical-align: bottom;
	}
	</style>
	</head>
	<body>
	<?php
	include('config.php');
    $gid = addslashes(strip_tags(trim($_GET['receiptno'])));
	$sno ='';
	$rdate = '';
	$descr = '';
	$payment_mode = '';
	$cheque_num = '';
	$cheque_date = '';
	$amount = '';
	$inwords = '';
	$nname = '';
	$resgen = $js->prepare('select * from receipts_db where receipt_id = :gid');
	$resgen->bindParam(':gid', $gid);
	$resgen->execute();
	while($row = $resgen->fetch(PDO::FETCH_ASSOC)) {
		$sno = $row['receipt_id'];
		$rdate = $row['receipt_date'];
		$receiptfrom = $row['receipt_from'];
		$amount = $row['receipt_amount'];
		$narra = $row['receipt_narration'];
		$narra = strtoupper($narra);
		$payment_mode = $row['receipt_mode'];
		$receiptrem = $row['receipt_remarks'];
		$payment_status = $row['payment_status'];
		$receiptbank = $row['receipt_bank'];
		$receipt_frm_details = $row['receipt_from_details'];
		$inwords = strtoupper(getAmountInWords($amount));
		$payment_status = strtoupper($payment_status);
		if($receiptfrom == 'Client') {
			$resultgen2 = $js->prepare('SELECT * FROM customer_details where custid = :receipt_frm_details');
			$resultgen2->bindParam(':receipt_frm_details', $receipt_frm_details);
			$resultgen2->execute();
			while($row = $resultgen2->fetch(PDO::FETCH_ASSOC)) {
				$n_name = $row['comp_name'];
				$ddate = $row['entrydate'];
				$dd = substr($ddate,0,2);
				$mm = substr($ddate, 3,2);
				$yy = substr($ddate,6);
				$n_name=strtoupper($n_name);
			}
			$resultgen3 = $js->prepare('SELECT * FROM invoice where guest_id = :receipt_frm_details');
			$resultgen3->bindParam(':receipt_frm_details', $receipt_frm_details);
			$resultgen3->execute();
			while($row = $resultgen3->fetch(PDO::FETCH_ASSOC)) {
				$invoice_id = $row['invoice_id'];
			}
		} else if($receiptfrom == 'Loan') {
			$resultgen2 = $js->prepare('SELECT * FROM newuser where empid = :receipt_frm_details');
			$resultgen2->bindParam(':receipt_frm_details', $receipt_frm_details);
			$resultgen2->execute();
			while($row = $resultgen2->fetch(PDO::FETCH_ASSOC)) {
				$n_name = $row['empname'];
				$invoice_id = $row['branch'];
			}
		} else {
			$nname = $receipt_frm_details;
			$n_name = strtoupper($nname);
			$invoice_id = '';
		}
		if($payment_mode == 'Cheque') {
			$cheque_num = $row['cheque_num'];
			$cheque_date = $row['cheque_date'];
		} else {
			$cheque_num = '';
			$cheque_date = '';
		}
	}
	if($receiptbank == 'select')
    $receiptbank = '';
	?>
							<table  align='left' cellpadding='0' cellspacing='0' frame='box' width="1030px">
							<tbody>
							<tr>
							<td align="center" style="background-color:#242021; color:#fff;"><img src="logo.PNG" style="margin:5px;"><span style="font-family: Agency FB;">
							<br>PO Box 225, IBRA, 400 <span style="margin-left:630px; color:#fff">Receipt Number:<b><?php echo $sno?></b></span><br>
							SULTANATE OF OMAN, Tel : <span style="color:#fff">+968 917 31339</span>  <span style="margin-left:550px;">Date: <b style="color:#fff"><?php echo $rdate?></b></span>
							
							</td>
							</tr><hr>
							<tr>
							<td colspan='2'>
<table style="width: 1030px; background-color:#FC9" >
<tr>
<td colspan='4'>
							
							<div>
							<p>
							<strong><h2><center>Cash Receipt</center></h2></strong>
							</p>
							</div>
							</td>
							</tr>

<tr>
							<td style="border-bottom:1px solid #000">
							Received from
							</td>
                            <?php
							if($receiptfrom == 'Client'){
							?>
							<td style="border-bottom:1px solid #000" colspan='3'><span style="font-family: Bradley Hand ITC;"><b><?php echo $n_name.' - : '.$dd.$mm.$yy.$receipt_frm_details?> </b></span></td>
                            <?php
							}
							elseif($receiptfrom == 'Loan')
							{
							?>
							<td style="border-bottom:1px solid #000" colspan='3'><span style="font-family: Bradley Hand ITC;"><b><?php echo $n_name.' - : '.$receipt_frm_details?> </b></span></td>
							<?php
							} else {}
							?>
</td>
</tr>
<tr>
							<td style="border-bottom:1px solid #000" ><br/>
							An amount of
							</td>
							<td style="border-bottom:1px solid #000" colspan='2'> <span style="font-family: Bradley Hand ITC;"><b><?php echo $inwords?> RUPEES ONLY</b> </span></td>
							<td style="border-bottom:1px solid #000">
							<table frame="box"> 
							<tr>
							<td style="vertical-align: middle;"></td>
							<td><input type='text' disabled style="border: 0px solid;text-align:center; font-weight:bold" value="INR. <?php echo $amount.'/-' ?>"></td>
							</tr>
							</table>
							</td>
							</tr>
							<tr>
							<td style="border-bottom:1px solid #000"><br/>
							Being 
							</td>
							<td style="border-bottom:1px solid #000" colspan='3'><span style="font-family: Bradley Hand ITC;"><b><?php echo $payment_status.' FOR '.$narra?></b></span></td>
							</tr>
							<tr>
							<td style="border-bottom:1px solid #000">							
							<br>
							By 
							<td style="border-bottom:1px solid #000" > <span style="font-family: Bradley Hand ITC;"><b><?php 
		if($payment_mode == 'bank')
	{
		echo $receiptbank." ".$payment_mode;
	}
	else
	{
	if (($pos = strpos($receiptbank, "_")) !== FALSE)
	{ 
        $whatIWant = substr($receiptbank, $pos+1); 
	$whatIWant = ucfirst($whatIWant);
	echo $payment_mode ." at ". $whatIWant;		
	}
else
{
		echo $receiptbank." ".$payment_mode;
}
	}
								?></b></span></td>
							<td style="border-bottom:1px solid #000"><br/>with reference</td>
							<td style="border-bottom:1px solid #000"><span style="font-family: Bradley Hand ITC;"><b><?php echo $receiptrem?></b></span></td>
							</tr>
							<tr>
							<td style="border-bottom:1px solid #000"><br/>
							Received By: 
							</td>
							<td style="border-bottom:1px solid #000" colspan='3'><span style="font-family: Bradley Hand ITC;"><b>SeeonSoft Web Technology</b></span></td>
							</tr>
							<tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr>
							<td  style="vertical-align: middle;">
							Reference / Invoice No:  
							</td>
							<td align="center" style="border:1px solid #000;vertical-align: middle;"><span style="font-family: Bradley Hand ITC;"><b><?php echo $invoice_id?></b></span></td>
<td style="border-bottom:1px solid #000" colspan='2'/>
							</tr>

</td>
							</tr>
							<tr>
							<td/>
							<td/>
							<td/>
							<td align='right'>
							<img src="AUTO SIGN logo.png" style="margin-top: -42px;"/>
							<br>
							AUTHORIZED SIGNATORY
							</td>
							</tr>
							</table>

</tbody>
							</table>

</body>
<?php
function getAmountInWords($number) {
  /**
   * Created by PhpStorm.
   * User: sakthikarthi
   * Date: 9/22/14
   * Time: 11:26 AM
   * Converting Currency Numbers to words currency format
   */
   $no = round($number);
   $point = round($number - $no, 2) * 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);
  $points = ($point) ?
    "." . $words[$point / 10] . " " . 
          $words[$point = $point % 10] : '';
  return $result;
}
?>