invisio v2.0

<?php
session_start();
include ('config.php');

$fdate = $_GET['fdate'];
$stat = 'Inactive';

$bank = $_GET['bank'];

/* $sqlo = $js->prepare('SELECT * FROM bank_openingbalance WHERE bank = :bank ');
	  $sqlo->execute(array(':bank' => $bank));
	
	  while($rowo = $sqlo->fetch(PDO::FETCH_ASSOC)) 
	  {
		  $opening_entrydate = $rowo['entrydate'];
		  if(strtotime($opening_entrydate) <= strtotime($fdate))
		  {
		  	$openingbankbal = $rowo['openingamount'];			
		  }
		  
	  }
*/
$totcredit = '';
$totdebit = '';
$c=1;

$resultp = $js->prepare('SELECT * FROM `income` WHERE banks = :bank ');
	$resultp->execute(array(':bank' => $bank)); 
	while($rowp = $resultp->fetch(PDO::FETCH_ASSOC)) 
	{
		$pinvdate = $rowp['creditdate'];
		if($pinvdate < $fdate)
		{
			$ptotalpayment = $rowp['incamount'];
			/*$vatstat = $rowp['vatstatus'];
			$pvat = $row['vat'];
			$pgross = $ptotalpayment + ($ptotalpayment * $pvat / 100);
			$ptotcredit += $pgross;*/
			$ptotcredit += $ptotalpayment;
			
			$pbalance = $ptotcredit - $ptotdebit;
		}
	}
	
	$resultpi = $js->prepare('SELECT * FROM `invoicepayments` WHERE banks = :bank ');
	$resultpi->execute(array(':bank' => $bank)); 
	while($rowpi = $resultpi->fetch(PDO::FETCH_ASSOC)) 
	{
		$pinvdate = $rowpi['paydate'];
		if($pinvdate < $fdate)
		{
			$ptotalpayment = $rowpi['payamount'];
			/*$vatstat = $rowp['vatstatus'];
			$pvat = $row['vat'];
			$pgross = $ptotalpayment + ($ptotalpayment * $pvat / 100);
			$ptotcredit += $pgross;*/
			$ptotcredit += $ptotalpayment;
			
			$pbalance = $ptotcredit - $ptotdebit;
		}
	}
	
	
	
	$resultp = $js->prepare('SELECT * FROM `expenses` WHERE banks = :bank ');
	$resultp->execute(array(':bank' => $bank)); 
	while($rowp = $resultp->fetch(PDO::FETCH_ASSOC)) 
	{
		$peinvdate = $rowp['expdate'];
		if($peinvdate < $fdate)
		{
			$pramount = $rowp['expamount'];
			$ptotdebit += $pramount;
			$pbalance = $ptotcredit - $ptotdebit;
		}
				
	}
	
	$resultpex = $js->prepare('SELECT * FROM `customer_expense` WHERE banks = :bank ');
	$resultpex->execute(array(':bank' => $bank)); 
	while($rowpex = $resultpex->fetch(PDO::FETCH_ASSOC)) 
	{
		$epeinvdate = $rowpex['paydate'];
		if($epeinvdate < $fdate)
		{
			$pramount = $rowpex['payamount'];
			$ptotdebit += $pramount;
			$pbalance = $ptotcredit - $ptotdebit;
		}
				
	}
	
	
//echo "ptotal credit".$ptotcredit."<br>";
//echo "ptotal debit".$ptotdebit;

$pclosing = $openingbankbal + $ptotcredit - $ptotdebit;

$pclosing = round($pclosing, 3);

$piecest = explode(".", $pclosing);
			$mainmenut = $piecest[0];
			$submenut =  $piecest[1];
			$strt= strlen($submenut);
			if($strt == '1')
				$submenut .= '00';
			elseif($strt == '2')
				$submenut .= '0';
			elseif($strt == '0')
				$submenut .= '000';
			else{}
			if($mainmenut == '0')
				$mainmenut = '00';
			$pclosing = $mainmenut.".".$submenut;
//echo "closing".$pclosing;