dbString("id");
########################### Get Token ##############################
if(isset($_REQUEST['token'])){ $token=$_REQUEST['token']; }else{ $token=''; }
if(!$token)
{
if(isset($_SESSION['snplq2l_token']))
{
header('location:'.HTTP_SERVER."stockhistory.php?id=".$iddb."&token=".$_SESSION['snplq2l_token']);
}
else{ header('location:'.HTTP_SERVER); }
}
else
{
require_once(DIR_SYSTEM.'inc/sign_verify.php');
$ressys=$db->select("*","store_master","id='1'","","");
$rowsys=$db->fetch($ressys);
$res=$db->select("*","inventory_items","id='".$iddb."'","","");
$row=$db->fetch($res);
?>
Untitled Document
=$stock_last_update){ $avqty+=$row['opening_balance']; }
?>
O/BALANCE:
| Date |
Note |
Note Id |
Type |
Qty |
Balance |
Cost |
select("*","stock_transactions","item='".$row['id']."' AND (added_date BETWEEN '".$rowsys['stock_last_update']."' AND '".$date->todayDate('Y-m-d')."')","","added_date ASC");
while($rows=$db->fetch($ress))
{
if($rows['trn_type']=='in'){ $avqty+=$rows['qty']; }
if($rows['trn_type']=='out'){ $avqty-=$rows['qty']; }
?>
|
|
|
|
|
|
|
| BALANCE |
|
| ITEM ROW BALANCE |
|