<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<style>
table
{
border-collapse:collapse;
}
table, td, th
{
border:1px solid black;
font-family:Arial, Helvetica, sans-serif;
padding:5px;
}
th
{
font-weight:bold;
font-size:12px;

}
td
{
font-size:11px;

}
</style>

</head>

<body>
 <!-- Progress bar holder -->
<div id="progress" style="width:500px;border:1px solid #ccc;"></div>
<!-- Progress information -->
<div id="information" style="width"></div>

<?php

    require_once("config.inc.php");
	require_once("DBConnector1.php");
	$db = new DBConnector();
    
   // $sql="delete from tmpstkmve";
	//$result =$db->RunQuery($sql);
	
	if ($_GET["brand"]=="All"){	
		$sql_smas = "select * from s_mas ";
	}	
	if ($_GET["brand"]!="All"){	
		$sql_smas = "select * from s_mas  where   BRAND_NAME='" . $_GET["brand"] . "'";
	}	
/*	
	$result_smas =$db->RunQuery($sql_smas);
	while($row_smas = mysqli_fetch_array($result_smas)){

  		$sql_purtrn = "sElect * from s_purtrn where STK_NO='" . trim($row_smas["STK_NO"]) . "' ORDER BY ID DESC";
  		
		$balqty = $row_smas["QTYINHAND"];
  		$soldover = false;
		
  		$result_purtrn =$db->RunQuery($sql_purtrn);
		while($row_purtrn = mysqli_fetch_array($result_purtrn)){
  
     		if (($balqty > 0) or  (!$soldover)){
     
        		if ($row_purtrn["REC_QTY"] > $balqty) {
					$soldqty=$row_purtrn["REC_QTY"] - $balqty;
					
          			$sql_update="update s_purtrn set soldqty=".$soldqty." where STK_NO ='". trim($row_smas["STK_NO"]) ."'";
					$result_update =$db->RunQuery($sql_update);
					
					$row_purtrn["soldqty"] = $row_purtrn["REC_QTY"] - $balqty;
          			$balqty = 0;
          			$soldover = true;
        		} else {
					$sql_update="update s_purtrn set soldqty=0 where STK_NO ='". trim($row_smas["STK_NO"]) ."'";
					$result_update =$db->RunQuery($sql_update);
         
          			$balqty = $balqty - $row_purtrn["REC_QTY"];
          			$soldover = false;
        		}
        
     		} else {
				
				$sql_update="update s_purtrn set soldqty=".$row_purtrn["REC_QTY"]." where STK_NO ='". trim($row_smas["STK_NO"]) ."'";
				$result_update =$db->RunQuery($sql_update);
      
        		$soldover = true;
     		}
			
			$date1 = $row_purtrn["SDATE"];
			$date2 = date("Y-m-d");
			$diff = abs(strtotime($date2) - strtotime($date1));
			$days = floor($diff / (60*60*24));
				
			$sql_update="update s_purtrn set brand=".$row_smas["BRAND_NAME"].", days=".$days." where STK_NO ='". trim($row_smas["STK_NO"]) ."'";
			$result_update =$db->RunQuery($sql_update);
 
  		}
  	}

*/






		$sql_head="select * from invpara";
		$result_head =$db->RunQuery($sql_head);
		$row_head = mysqli_fetch_array($result_head);
		
		echo "<center><span class=\"style1\">".$row_head["COMPANY"]."</span></center><br>";
		
		
		echo "<center>".$heading."</center><br>";
		
		echo "<center><table border=1><tr>
		<th>AR Date</th>
		<th>AR No</th>
		<th>Supplier</th>
		<th>Ar Value Rs.</th>
		<th>Sold Amount</th>
		<th>Sold %</th>
		<th>Balance Amount</th>
		<th>Balance %</th>
		<th>Period</th>
		</tr>";
		//echo $sql;
		$totgross=0;
		$totvat=0;
		$totnet=0;
		
		if ($_GET["brand"]=="All"){	
   			$sql1 = "SELECT * from viewpur where days>=" . $_GET["txtover"]." order by REFNO";
		} else {
   			$sql1= "SELECT * from viewpur where brand='" . trim($_GET["brand"]) . "' and days>=" .$_GET["txtover"]." order by REFNO";
		}
		$totbalamou=0;
		//echo $sql1;
		$result1 =$db->RunQuery($sql1);
		while($row = mysqli_fetch_array($result1)){ 
		
			//$sql=$sql1." and REFNO ='".$row1["REFNO"]."'";		
		//echo $sql;
		//  $result =$db->RunQuery($sql);
		//  while($row = mysqli_fetch_array($result)){ 
			echo "<tr>
			<td>".$row["SDATE"]."</td>
			<td>".$row["REFNO"]."</td>
			<td>".$row["SUP_NAME"]."</td>";
			
			
			echo "<td align=\"right\">".$row["arval"]."</td>";
			echo "<td align=\"right\">".number_format($row["soldamount"], 2, ".", ",")."</td>";
			
			if ($row["arval"]>0) { 
				$sold_p=$row["soldamount"]/$row["arval"]*100;
			}
			echo "<td align=\"right\">".number_format($sold_p, 2, ".", ",")."</td>";
			
			if ($row["arval"]>$row["soldamount"]) {
				$balamou=$row["arval"]-$row["soldamount"];
			} else {
				$balamou=$row["arval"];
			}	

			$totbalamou=$totbalamou+$balamou;
			
			echo "<td align=\"right\">".number_format($balamou, 2, ".", ",")."</td>";
			
			$bal_p=100-$sold_p;
			echo "<td align=\"right\">".number_format($bal_p, 2, ".", ",")."</td>";
						
			$diff = abs(strtotime($row1["SDATE"]) - strtotime(date("Y-m-d")));
			$days = floor($diff / (60*60*24));
	
			
			echo "<td align=\"right\">".$days."</td>
			</tr>";
		 // }	
		
		}
		
		echo "<tr>
			<td colspan=6>&nbsp;</td>
			
			<td align=\"right\"><b>".number_format($totbalamou, 2, ".", ",")."</b></td>
			<td align=\"right\">&nbsp;</td>
			<td align=\"right\">&nbsp;</td>
			</tr>";
			
		echo "<table>";


?>


</body>
</html>
