<?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);
?>
"  />
Example #2
0
<?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";
?>
	

Example #3
0
<?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 
Example #4
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 ";
Example #5
0
<?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");
?>
	

Example #9
0
<?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>&nbsp;</td>
    <td>&nbsp;</td>
    <td width="129" align="right" valign="top">&nbsp;</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>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
<?php 
for ($i = 0; $i < $rowRowListAll; $i++) {
    if ($i % 2 == 0) {
        $bgc = "#F7F7F7";
    } else {
        $bgc = "#F1F1F1";
    }