/* Decoded by unphp.net */

include("../config/Connection.php");
 $cpv=$_REQUEST['cpv'];
$rs=mysql_query("select * from ledger where Ref='$cpv' order by Cr DESC");				
	 while($newArray=mysql_fetch_array($rs)) {
								
									$Date= $newArray['Date'];
									$Time= $newArray['Time'];
									$ChDate = date("d-M-Y", strtotime($newArray['Date']));
									$Ref_Account_Id= $newArray['Ref_Account_Id'];
									}	
						$rs=mysql_query("select * from coa_level_5 where Id='$Ref_Account_Id'");				
	 while($newArray=mysql_fetch_array($rs)) {
								
									$CashName= $newArray['Name'];
									}			
	
	
	define("MAJOR", 'RUPEES');
define("MINOR", 'PISA');
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 = MAJOR, $minor = MINOR)
    {
        $this->__toWords__((int)($amount), $major);
        $whole_number_part = $this->words;
        #$right_of_decimal = (int)(($amount-(int)$amount) * 100);
        $strform = number_format($amount,2);
        $right_of_decimal = (int)substr($strform, strpos($strform,'.')+1);
        $this->__toWords__($right_of_decimal, $minor);
        $this->words = $whole_number_part . ' ' . $this->words;
    }

    function __toWords__($amount, $major)
    {
        $this->major  = $major;
        #$this->minor  = $minor;
        $this->number = number_format($amount, 2);
        list($this->pounds, $this->pence) = explode('.', $this->number);
        $this->words = " $this->major";
        if ($this->pounds == 0)
            $this->words = "Zero $this->words";
        else {
            $groups = explode(',', $this->pounds);
            $groups = array_reverse($groups);
            for ($this->magind = 0; $this->magind < count($groups); $this->magind++) {
                if (($this->magind == 1) && (strpos($this->words, 'hundred') === false) && ($groups[0] != '000'))
                    $this->words = ' and ' . $this->words;
                $this->words = $this->_build($groups[$this->magind]) . $this->words;
            }
        }
    }

    function _build($n)
    {
        $res = '';
        $na  = str_pad("$n", 3, "0", STR_PAD_LEFT);
        if ($na == '000')
            return '';
        if ($na{0} != 0)
            $res = ' ' . $this->units[$na{0}] . ' hundred';
        if (($na{1} == '0') && ($na{2} == '0'))
            return $res . ' ' . $this->mag[$this->magind];
        $res .= $res == '' ? '' : ' and';
        $t = (int) $na{1};
        $u = (int) $na{2};
        switch ($t) {
            case 0:
                $res .= ' ' . $this->units[$u];
                break;
            case 1:
                $res .= ' ' . $this->teens[$u];
                break;
            default:
                $res .= ' ' . $this->tens[$t] . ' ' . $this->units[$u];
                break;
        }
        $res .= ' ' . $this->mag[$this->magind];
        return $res;
    }
}

?>

<style>
#cusInfo{ font-family:Calibri; width:65%; float: left;}
#DI{ font-family:Calibri; width:32%;  box-shadow: 10px 10px 5px #888888; border-style:solid;
border-width:1px; float: left;}
#celspace{ height:40; width:2%;  }
#celhight{ height:20; width:500;  float: left;}

#sr{ font-family:Calibri; width:4%; border-style:solid; border-width:1px; float: left; text-align:center}
#particulars{ font-family:Calibri; width:65%; border-style:solid; border-width:1px; float: left; text-align:center; letter-spacing:6px}
#qty{ font-family:Calibri; width:9%; border-style:solid; border-width:1px; float: left; text-align:center}
#price{ font-family:Calibri; width:9%; border-style:solid; border-width:1px; float: left; text-align:center; }
#amount{ font-family:Calibri; width:9%; border-style:solid; border-width:1px; float: left; text-align:center;}

#srd{ font-family:Calibri; width:4%; border-left:solid; border-width:1px; float: left; text-align:center; }
#particularsd{ font-family:Calibri; width:65%; border-left:solid; border-width:2px; float: left; letter-spacing:6px;}
#qtyd{ font-family:Calibri; width:9%; border-left:solid; border-width:2px; float: left; text-align:right; }
#priced{ font-family:Calibri; width:9%; border-left:solid; border-width:2px; float: left; text-align:right; }
#amountd{ font-family:Calibri; width:9%; border-left:solid; border-left-width:2px; float: left; text-align:right; border-right:solid; border-right-width:1px; }

#total{ font-family:Calibri; width:88%; border-style:solid; border-width:1px; float: left; text-align:center; letter-spacing:6px; }
#amountt{ font-family:Calibri; width:8%; border-style:solid; border-width:1px; float: left; text-align:right; }
table{ font-family:Calibri; }
</style>
<? 
include("Rhead.php");
?>
<div id="cusInfo">
<table align="center">
	<tr>
		<th style="font-size:30px;letter-spacing:6px;">CASH PAYMENT VOUCHER</th>
	</tr>
</table>

</div>

<div id="DI">
<table width="100%" align="RIGHT">
		<tr>
				
				<td width="35%" style="border-bottom:dotted; border-width:1px;"><b>VOUCHER NO</b></td>
				<td width="65%" style="border-bottom:dotted; border-width:1px;"><? echo $cpv; ?></td>
		</tr>
		<tr>
				
				<td ><b>DATE/TIME</b></td>
				<td ><? echo $ChDate.'  &nbsp;&nbsp;&nbsp;'.$Time; ?></td>
		</tr>
	
	
</table>
</div>
<div style="width:100%; height:7%"></div>
<table  width="97%" style="border-style:solid; border-width:1px;">
		<tr align="center" bgcolor="#548DD4" >
			<th width="15%" style='border:none;border-right:solid 1.0pt;border-bottom:solid 1.0pt;'>CODE</th>
			<th width="34%" style='border:none;border-right:solid 1.0pt;border-bottom:solid 1.0pt;'>ACCOUNT</th>
			<th width="38%" style='border:none;border-right:solid 1.0pt;border-bottom:solid 1.0pt;letter-spacing:6px;'>DESCRIPTION</th>

		<th width="13%" style='border:none;border-bottom:solid 1.0pt;'>AMOUNT</th>
		
		</tr>
<?php 
 $sr=1;
$TDR=0;
$TCR=0;
$rs=mysql_query("select * from ledger where Ref='$cpv' and Dr!=0 ");				
	 while($newArray=mysql_fetch_array($rs)) {
								
									$Date= $newArray['Date'];
									$ChDate = date("d-M-Y", strtotime($newArray['Date']));
									$Account_Id= $newArray['Account_Id'];
									$Ref= $newArray['Ref'];
									$Description= $newArray['Description'];
									$Dr= $newArray['Dr'];
									$Cr= $newArray['Cr'];
						
						$rsp=mysql_query("select * from coa_level_5 where Id='$Account_Id'");
	 while ($newArray = mysql_fetch_array($rsp)) 
	 									{
					
					$Name= $newArray['Name'];				}
		

 ?>
		<tr <?php if ($sr%2){ echo 'bgcolor="#CCCCCC"'; }?>>
			<td align="center" style=" border-right:solid; border-width:1px;"><? echo $Account_Id; ?></td>

			<td style="border-right:solid; border-width:1px;"><?php echo $Name;?></td>
			<td style="border-right:solid; border-width:1px;"><?php echo $Description;?></td>

		<td align="right" style="border-width:1px;"><?php echo number_format($Dr); ?></td>
	
		
		</tr>
<?php 
$TDR=$TDR+$Dr;
$TCR=$TCR+$Cr;
 $sr=$sr+1; }
 

   $s=$sr;
   for ($i=$sr;$i<=13;$i++){

 ?>
		<tr <?php if ($s%2){ echo 'bgcolor="#CCCCCC"'; }?>>
			<td align="center" style="border-right:solid; border-width:1px;">&nbsp;</td>
		<td align="right" style="border-right:solid; border-width:1px;">&nbsp;</td>
			<td align="right" style="border-right:solid; border-width:1px;">&nbsp;</td>
<td align="right">&nbsp;</td>

		
			
		</tr>
<?php $s=$s+1; } 			
		

 /*for ($i=$sr;$i<=4;$i++){

 ?>
		<tr <?php if ($s%2){ echo 'bgcolor="#CCCCCC"'; }?>>
			<td align="center">&nbsp;</td>
		<td align="right">&nbsp;</td>
			<td align="right">&nbsp;</td>
<td align="right">&nbsp;</td>
			<td align="right">&nbsp;</td>
			
		</tr>
<?php $s=$s+1; } */
$obj    = new toWords($TDR);


$rs=mysql_query("select * from ledger where Ref='$cpv' and Cr!=0 order by Dr DESC LIMIT 0 , 1");				
	 while($newArray=mysql_fetch_array($rs)) {
								
									$Date= $newArray['Date'];
									$ChDate = date("d-M-Y", strtotime($newArray['Date']));
									$Account_Id= $newArray['Account_Id'];
									$Ref= $newArray['Ref'];
									$Description= $newArray['Description'];
									$Dr= $newArray['Dr'];
									$Cr= $newArray['Cr'];
						
						$rsp=mysql_query("select * from coa_level_5 where Id='$Account_Id'");
	 while ($newArray = mysql_fetch_array($rsp)) 
	 									{
					
					$Name= $newArray['Name'];				}
		

 ?>

<tr <?php if ($s%2){ echo 'bgcolor="#CCCCCC"'; }?>>
			<td align="center" style="border:solid; border-width:1px;"><? echo $Account_Id; ?></td>

			<td style="border:solid; border-width:1px;"><?php echo $Name;?></td>
			<td style="border:solid; border-width:1px;"><? echo $obj->words; ?> ONLY</td>

		<td align="right" style="border:solid; border-width:1px;"><?php echo number_format($TDR); ?></td>
						
  </tr><? } ?>
</table>



<table width="98%">
  <th width="20%" ><u>PREPARED BY </u></th>
		<th width="20%" ><u>CHECKED BY </u></th>
		<th width="20%" ><u>APROVED BY </u></th>		
		<th width="22%" align="right"><u>RECEIVED BY </u></th>
</table><br /><br /><br />
<?php  echo "<font size='1'><b>CREATED BY:</b> PAK DEVELOPER 0314-3550448 , 0300-6974770</font>";