Example #1
0
<?php

session_start();
require_once '../../lib/mrr.class.php';
require_once '../../lib/raw_item.class.php';
$MRR = new MRR();
$stock = new rawItem();
$num = $MRR->getMRRrawId();
$userId = $_SESSION[userid];
extract($_POST);
$getData = "'{$num}','{$mrr_num}','{$date_of_submit}','{$userId}','{$PurchaseorderId}','{$selSupplier}','{$indentNo}','','',1";
extract($MRR->CreateMrrRawMaster($getData));
$getData = '';
$counter = $id;
for ($i = 0; $i < count($stock_item); $i++) {
    $getData = "'null',\t{$counter},\n\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t{$stock_item[$i]},\n\t\t\t\t\t\t\t\t{$item_qty[$i]},\n\t\t\t\t\t\t\t\t{$item_rate[$i]},\n\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t{$item_total[$i]}";
    $MRR->CreateMrrRawDetails($getData);
    $item_cl_balance_data = $stock->retriveStockItemByid($stock_item[$i]);
    $item_cl_balance = $item_cl_balance_data[0]["stock_item_cl_balance"];
    $stock->updateAddClBalance($stock_item[$i], $item_cl_balance, $item_qty[$i]);
    $prev_item_recieved_qty = $item_cl_balance_data[0]["stock_rejected_qty"];
    $current_recieved_qty = $prev_item_recieved_qty + $item_qty[$i];
    $stock->updateReceivedQty($stock_item[$i], $current_recieved_qty);
}
echo "Data Save Successfully ";
<?php

session_start();
require_once '../../lib/consumption.class.php';
require_once '../../lib/raw_item.class.php';
extract($_POST);
$consumption = new Consumption();
$stock = new rawItem();
$user_id = $_SESSION[userid];
$num = $consumption->getissueRawNewId();
$getData = "'{$num}','{$con_num}','','{$date_of_submit}','{$user_id}'";
extract($consumption->CreateConsumptionRaeMaster($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'',\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->CreateConsumptionRawDetails($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->updateIssueQtyANDlocation($item_code[$i], $currentIssueQty, $ConlocationId[$i]);
}
echo " Save Successfully";