<?php

require_once('config.php');
require_once(DIR_SYSTEM.'class/class.inc.php');

//$db->update("inventory_items","closing='0'","id!='2000000'");
$location=7;
$adj=37;
$res=$db->select("*","inventory_items","","","");
while($row=$db->fetch($res))
{
	$ress=$db->select("*","stocks","item='".$row['id']."' AND location='".$location."'","","");
	$rows=$db->fetch($ress);

	$db->insert("inventory_adjustments_items","adj_id , `type` , item , qty , cost","'".$adj."' , 'a' , '".$row['id']."' , '".$rows['qty']."' , '".$row['cost']."'");
						
	$adjlineid=$db->lastId();
	
	
	$db->insert("stock_transactions","`added_date`, `note_type`, `note_id`, `note_line_id`, `trn_type`, `item` , `qty`, `amount`, `location_from`, `location_rcvd`","'2017-05-21' , 'ADJ' , '".$adj."' , '".$adjlineid."' , 'in' , '".$row['id']."' , '".$rows['qty']."' , '".$row['cost']."' , '' , '".$location."'");
	

}
/**/

/*
$db->delete("inventory_adjustments_items","adj_id='37'");
$db->delete("stock_transactions","note_id='37'");
*/


?>