<?php require_once '../../lib/defination.class.php'; include '../../lib/stock.class.php'; include '../../lib/raw_item.class.php'; require_once '../../lib/consumption.class.php'; $stock = new Stock(); $Consumption = new Consumption(); $stock_info = $stock->retriveStockItem(); $rawItem = new rawItem(); $output = options_for_select($rawItem->retriveRawItem(), 'stock_item_id', 'stock_item_name'); //echo $output; $part_number = options_for_select($stock->retriveStockItem(), 'stock_item_part_id', 'stock_item_part_id'); $locations = options_for_select($stock->retriveLocation(), 'stock_location_name', 'stock_location_name'); $num = $Consumption->getissueRawNewId(); ?> <div id="note"> </div> <form id="consumptionForm" name="consumptionForm" method="post" action="includes/model/consumption_raw_actions.php" > <div class='morelabel'> <p> <label>Consumption # </label> <input type="text" disabled value="<?php echo generate_timestamp('CON-R', $num); ?> " />
<?php require_once "../../lib/raw_item.class.php"; $rawItem = new rawItem(); require_once "../../lib/stock.class.php"; $objStockItemInfo = new Stock(); extract($_POST); //get a new id $StockItemId = $rawItem->getNewId(); ///////////////////////////// //get stock code Id $getData = "'{$StockItemId}','{$stkName}','{$stkGrp}','{$unitId}','{$altUnitId}','{$unitRel1}','{$unitRel2}','{$length}','{$date}','{$lc}','{$suplier}','{$lot}','','{$locationID}','{$qa}','{$txtStkcode}','{$desc}','','','','{$opQnty}','{$OpRate}','{$opValue}','{$opQnty}','','',''"; $rawItem->CreateRawStockItem($getData); echo "<b>Data Save Successsfull</b>"; require_once "../contents/create_raw_item.php"; ?>
<?php require_once '../../lib/defination.class.php'; include '../../lib/stock.class.php'; include '../../lib/raw_item.class.php'; include '../../lib/mrr.class.php'; include '../../lib/supplier.class.php'; $stock = new Stock(); $MRR = new MRR(); $rawItem = new rawItem(); $stock_info = $rawItem->retriveRawItem(); $output = options_for_select($stock_info, 'stock_item_id', 'stock_item_name'); //echo $output; $part_number = options_for_select($stock_info, 'stock_item_part_id', 'stock_item_part_id'); $locations = options_for_select($stock->retriveLocation(), 'stock_location_id', 'stock_location_name'); $Supplier = new Supplier(); $outputSupplierItem = options_for_select($Supplier->retriveSupplierInfo(), 'sup_id', 'sup_name', true); $num = $MRR->getMRRrawId(); ?> <form id="consumptionForm" name="consumptionForm" method="post" action="includes/model/mrr_by_lc_actions.php" > <div id="note"> </div> <div class='morelabel'> <p> <label>MRR # </label> <input type="text" disabled value="<?php
<?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 require_once '../../../lib/defination.class.php'; require_once '../../../lib/stock.class.php'; require_once "../../../lib/raw_item.class.php"; include '../../../lib/supplier.class.php'; include '../../../lib/lc.class.php'; include '../../../lib/lot.class.php'; //Object $objStockGroupInfo = new Stock(); $stock = new Stock(); $objRawItemInfo = new rawItem(); @session_start(); $user_level = $_SESSION[user_level]; $stc_itm_id = $_GET['stc_itm_id']; $rawItemByID = $objRawItemInfo->retriveRawItemByID($stc_itm_id); $stock_item_id = $rawItemByID[0]['stock_item_id']; $StockGroupId = $rawItemByID[0]['stock_item_grp_id']; $StockUnitId = $rawItemByID[0]['stock_item_unit_id']; $StockAltUnitId = $rawItemByID[0]['stock_alt_unit']; $date = $rawItemByID[0]['date']; $lc = $rawItemByID[0]['lc']; $supplier = $rawItemByID[0]['supplier']; $qa = $rawItemByID[0]['qa']; $locationId = $rawItemByID[0]['location']; $lot = $rawItemByID[0]['lot']; //// Retrive Stock Group Name $StockGrpInfo = $objStockGroupInfo->retriveStockGroupUnderInfo(); $StockGrpInfo_options = options_for_select($StockGrpInfo, 'stock_group_id', 'stock_group_name', true, $StockGroupId); //// Retrive Stock Unit Name $unitName = options_for_select($stock->retriveStockUnit(), 'stock_item_unit_id', 'stock_item_unit_name', true, $StockUnitId);
<?php require_once "../../lib/stock.class.php"; $objStockItemInfo = new Stock(); require_once "../../lib/raw_item.class.php"; $rawItem = new rawItem(); extract($_POST); $StockItemId = $rawItem->getNewId(); for ($i = 0; $i < count($locationID); $i++) { $getData = "'null','{$StockItemId}',\n\t\t\t\t\t\t'{$date_of_submit['i']}',\n\t\t\t\t\t\t'{$locationID[$i]}',\n\t\t\t\t\t\t'{$lot[$i]}',\n\t\t\t\t\t\t'{$lc[$i]}',\n\t\t\t\t\t\t'{$suplier[$i]}',\n\t\t\t\t\t\t'{$stkMName[$i]}',\n\t\t\t\t\t\t{$item_qty[$i]},\n\t\t\t\t\t\t{$item_rate[$i]},\n\t\t\t\t\t\t{$item_total[$i]}\n\t\t\t\t\t\t\n\t\t\t\t\t"; $objStockItemInfo->CreateLocWiseRawStockDetails($getData); } //echo "<b>Data Save Successsfull</b>"; require_once "../contents/localtionRawOpQty.php"; ?>
<?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";
<?php require_once "../../lib/raw_item.class.php"; $rawItem = new rawItem(); require_once "../../lib/stock.class.php"; $objStockItemInfo = new Stock(); extract($_POST); $rawItem->UpadteRawItemByID($stock_item_id, $stkName, $stkGrp, $unitId, $altUnitId, $unitRel1, $unitRel2, $length, $txtStkcode, $desc, $opQnty, $OpRate, $opValue); echo "<b>Data Save Successsfull</b>"; //require_once("../contents/list_all/list_all_raw_item.php"); ?>
<?php require_once "../../../lib/raw_item.class.php"; require_once "../../../lib/stock.class.php"; $objFinishGoodsList = new Stock(); $objRawItemList = new rawItem(); $RawListAll = $objRawItemList->retriveRawItem(); $rowRowListAll = count($RawListAll); ?> <table width="100%" border="0"> <tr> <td> </td> <td> </td> <td width="129" align="right" valign="top"> </td> <td width="158" align="right" valign="top"><a class="thickbox" href="includes/contents/create_engn_item.php">Back</a></td> </tr> <tr> <td width="243"><b>Item Name</b></td> <td width="280"><b>Stock Group Name</b></td> <td> </td> <td> </td> </tr> <?php for ($i = 0; $i < $rowRowListAll; $i++) { if ($i % 2 == 0) { $bgc = "#F7F7F7"; } else { $bgc = "#F1F1F1"; }