Exemplo n.º 1
0
////////////////////////////////////////////////
$StockCatInfo_options = options_for_select($StockCatInfo, 'stock_cat_id', 'stock_cat_name', true);
$stockDept = options_for_select($stock->retriveStockDepartmentInfo(), 'stock_dept_id', 'stock_dept_name', true);
$stockSection = options_for_select($stock->retriveStockSection(), 'sec_id', 'sec_name', true);
$stockMachineName = options_for_select($stock->retriveMachineName(), 'm_id', 'm_name', true);
$stockMachineModelName = options_for_select($stock->retriveMachineModelName(), 'machine_model_id', 'machine_model_name', true);
$stockManufecturer = options_for_select($stock->retriveManufecturer(), 'manu_id', 'manu_name', true);
$stockItemName = options_for_select($stock->retriveStockItem(), 'stock_item_id', 'stock_item_name', true);
/////////////////////////////////
//// Retrive Stock Unit Name
$unitName = options_for_select($stock->retriveStockUnit(), 'stock_item_unit_id', 'stock_item_unit_name', true);
/////////////////////////////////
@session_start();
$user_level = $_SESSION[user_level];
$stc_itm_id = $_GET['stc_itm_id'];
$stockItemByID = $objStockGroupInfo->retriveStockItemByid($stc_itm_id);
$allStockItem = $objStockGroupInfo->retriveStockItem();
$rowStockItem = count($allStockItem);
$stock_p_id = $stockItemByID["0"]["stock_p_id"];
$allStockItemUnit = $objStockGroupInfo->retriveStockUnit();
$rowStockItemUnit = count($allStockItemUnit);
$stock_item_unit_id = $stockItemByID["0"]["stock_item_unit_id"];
$allStockGroup = $objStockGroupInfo->retriveStockGroupListAll();
$rowStockGroup = count($allStockGroup);
$stock_Group_id = $stockItemByID["0"]["stock_item_grp_id"];
$allStockDepartment = $objStockGroupInfo->retriveStockDepartmentListAll();
$rowStockDepartment = count($allStockDepartment);
$stock_dep_id = $stockItemByID["0"]["stock_dept_id"];
$allStockSection = $objStockGroupInfo->retriveStockSection();
$rowStockSection = count($allStockSection);
$stock_sec_id = $stockItemByID["0"]["stock_section_id"];
Exemplo n.º 2
0
session_start();
require_once '../../lib/mrr.class.php';
require_once '../../lib/stock.class.php';
extract($_POST);
//print_r($_POST);
$userId = $_SESSION[userid];
$MRR = new MRR();
$stock = new Stock();
$num = $MRR->getNewId();
$getData = "'{$num}','{$mrr_num}','{$date_of_submit}','{$userId}','{$PurchaseorderId}','{$selSupplier}','{$indentNo}','','',1";
extract($MRR->CreateMRRMaster($getData));
$getData = '';
$counter = $id;
if ($check == 1) {
    for ($i = 0; $i < count($item_code); $i++) {
        $getData = "'null',\t'{$counter}',\n\t\t\t \t\t\t\t\t\t'{$locationId[$i]}',\n\t\t\t\t\t\t\t\t\t'{$item_code[$i]}',\n\t\t\t\t\t\t\t\t\t'{$item_qty[$i]}',\n\t\t\t\t\t\t\t\t\t'{$item_rate[$i]}',\n\t\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t\t'{$item_amount[$i]}'";
        $MRR->CreateMRRDetails($getData);
    }
} else {
    for ($i = 0; $i < count($item_qty); $i++) {
        $getData = "'null',\t'{$counter}',\n\t\t\t \t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t\t'{$item_code[$i]}',\n\t\t\t\t\t\t\t\t\t'{$item_qty[$i]}',\n\t\t\t\t\t\t\t\t\t'{$item_rate[$i]}',\n\t\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t\t'{$item_amount[$i]}'";
        $MRR->CreateMRRDetails($getData);
        $item_cl_balance_data = $stock->retriveStockItemByid($item_code[$i]);
        $item_cl_balance = $item_cl_balance_data[0]["stock_item_cl_balance"];
        $stock->updateAddClBalance($item_code[$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($item_code[$i], $current_recieved_qty);
    }
}
echo "Save Successfully";
Exemplo n.º 3
0
<?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";