<?php

require_once('config.php');
require_once(DIR_SYSTEM.'class/class.inc.php');


$res=$db->select("*","sales_invoices","","21400,1000","");
while($row=$db->fetch($res))
{
	
	
	//////////////
	$invoice_total=0;
	$invoice_total_cost=0;
	
	
	$res_tmp_inv_itm=$db->select("*","sales_invoice_items","invoice_id='".$row['id']."'","","id ASC");
	while($row_tmp_inv_itm=$db->fetch($res_tmp_inv_itm))
	{				
		if($row_tmp_inv_itm['discount']!=='0.0000')
		{
			$thisprice=$row_tmp_inv_itm['unit_price']-($row_tmp_inv_itm['unit_price']*$row_tmp_inv_itm['discount']/100);
			$invoice_total+=$thisprice*$row_tmp_inv_itm['qty'];
		}
		else
		{
			$invoice_total+=$row_tmp_inv_itm['unit_price']*$row_tmp_inv_itm['qty'];
		}
		$invoice_total_cost+=$row_tmp_inv_itm['cost']*$row_tmp_inv_itm['qty'];
	}
	
	$res_tmp_inv=$db->select("id,gsd","sales_invoices","id='".$row['id']."'","","");
	$row_tmp_inv=$db->fetch($res_tmp_inv);
			
	if($row_tmp_inv['gsd']!=='0.0000')
	{
		$inv_amount=$invoice_total-($invoice_total*$row_tmp_inv['gsd']/100);
	}
	else
	{
		$inv_amount=$invoice_total;
	}
	
	$cash=0;
	$cheque=0;
	$card=0;
	$credit=0;
	$return=0;
	
	$respayf=$db->select("*","sales_invoice_payments","invoice_id='".$row['id']."'","","id ASC");
	while($rowpayf=$db->fetch($respayf))
	{
		
		if($rowpayf['type']=='Cash')
		{
			$cash+=$rowpayf['amount'];
		}
		if($rowpayf['type']=='Cheque')
		{
			$cheque+=$rowpayf['amount'];
		}
		if($rowpayf['type']=='Card')
		{
			$card+=$rowpayf['amount'];
		}
		if($rowpayf['type']=='Credit')
		{
			$credit+=$rowpayf['amount'];
		}
		if($rowpayf['type']=='Return')
		{
			$return+=$rowpayf['amount'];
		}
		
	}
	
	$db->update("sales_invoices","`total_sale`='".$inv_amount."', `total_sale_cost`='".$invoice_total_cost."', `cash`='".$cash."', `cheque`='".$cheque."', `card`='".$card."', `credit`='".$credit."', `return`='".$return."'","id='".$row['id']."'");
	
	
}
?>