<?php
//error_reporting(0);
require_once('config.php');
require_once(DIR_SYSTEM.'class/class.inc.php');


$ressys=$db->select("*","store_master","id='1'","","");
$rowsys=$db->fetch($ressys);
	

$res=$db->select("*","inventory_items","","","id ASC");
while($row=$db->fetch($res))
{
	
	$avqtye=0;

	$stock_last_update=strtotime(date('Y-m-d',strtotime($rowsys['stock_last_update'])));
	$open_bl_datestr=strtotime($row['opening_stock_date']);
	
	if($open_bl_datestr>=$stock_last_update){ $avqtye+=$row['opening_balance']; }
	
	$ressii=$db->select("*","stock_transactions","item='".$row['id']."' AND (added_date BETWEEN '".$rowsys['stock_last_update']."' AND '".$date->todayDate('Y-m-d')."')","","added_date ASC");
	while($rowsii=$db->fetch($ressii))
	{
	  if($rowsii['trn_type']=='in'){ $avqtye+=$rowsii['qty']; }
	  if($rowsii['trn_type']=='out'){ $avqtye-=$rowsii['qty']; }
	}
	
	echo $row['id'].'-exp-'.$row['group_id'].'-exp-'.$row['model'].'-exp-'.$row['name'].'-exp-'.$row['warranty'].'-exp-'.$row['brand'].'-exp-'.$row['unit'].'-exp-'.$row['selling_price'].'-exp-'.$row['status'].'-exp-'.$row['added_date'].'-exp-none-exp-'.$avqtye.'-exp-'.$row['bar_code'].'--exp--';
	
}
?>