<?php session_start(); require_once '../../lib/consumption.class.php'; require_once '../../lib/stock.class.php'; extract($_POST); $consumption = new Consumption(); $stock = new Stock(); $user_id = $_SESSION[userid]; $num = $consumption->getNewId(); $getData = "'{$num}','{$con_num}','','{$date_of_submit}','{$user_id}'"; extract($consumption->CreateConsumptionMaster($getData)); $getData = ''; $counter = $id; for ($i = 0; $i < count($item_code); $i++) { $getData = "'null','{$counter}',\n\t\t\t\t\t\t\t'{$item_code[$i]}',\n\t\t\t\t\t\t\t'{$ConlocationId[$i]}',\n\t\t\t\t\t\t\t'{$item_qty[$i]}',\n\t\t\t\t\t\t\t'{$item_rate[$i]}',\n\t\t\t\t\t\t\t'{$item_total[$i]}'\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t"; #echo "<br />".$getData; $consumption->CreateConsumptionDetails($getData); $item_data = $stock->retriveStockItemByid($item_code[$i]); $item_cl_balance = $item_data[0]["stock_item_cl_balance"]; $prev_item_issue_qty = $item_data[0]["stock_issue_qty"]; $stock->updateClBalance($item_code[$i], $item_cl_balance, $item_qty[$i]); $currentIssueQty = $prev_item_issue_qty + $item_qty[$i]; $stock->updateIssueQty($item_code[$i], $currentIssueQty); } echo " Save Successfully";