MRR PHP Code Examples

Example #1

0

Show file

File: mrr_order_actions.php Project: rajibahmed/IIMS

<?php

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);
    }

Example #2

0

Show file

File: create_mrr_with_po.php Project: rajibahmed/IIMS

<?php

require_once '../../lib/defination.class.php';
include '../../lib/supplier.class.php';
include '../../lib/stock.class.php';
include '../../lib/purchaseOrder.class.php';
include '../../lib/mrr.class.php';
$stock = new Stock();
$MRR = new MRR();
$output = options_for_select($stock->retriveStockItem(), 'stock_item_id', 'stock_item_name');
// get suppliers info for combo box;
$Supplier = new Supplier();
$outputSupplierItem = options_for_select($Supplier->retriveSupplierInfo(), 'sup_id', 'sup_name', true);
$Purchase = new Purchaseorder();
$outputPurchaseorder = options_for_select($Purchase->RetrivePurchaseOrder(), 'pm_id', 'pm_no', true);
$locations = options_for_select($stock->retriveLocation(), 'stock_location_id', 'stock_location_name');
$num = $MRR->getNewId();
?>
<link href="../../css/stylesheet.css" rel="stylesheet" type="text/css" />
<div id="note"> </div>
<form id="mrrForm" name="mrrForm" method="post"  action="includes/model/mrr_order_actions.php" >
	
	<div class='morelabel'>
		
		<p>
			
				<label>MRR # </label>
			<input type="text" disabled value="<?php 
echo generate_timestamp('MRR', $num);
?>
"  />

Example #3

0

Show file

File: list_all_mrr.php Project: rajibahmed/IIMS

<?php

require_once "../../../lib/mrr.class.php";
require_once "../../../lib/helper_functions.php";
$mrr = new MRR();
//	echo "<pre>";
//		var_dump($mrr->findMrrList());
//	echo "</pre>";
$mrrs = $mrr->findMrrList();
?>

	 <div id="inline_form">
			
			<div class="mediumbody">
				<div class="lowbanner1"> </div>
	            <div class="lowbannertest">	
					<ul>
						<li style="width:220px">Items </li>
						<li style="width:90px">MRR # </li>
						<li style="width:130px">MRR Create Date</li>  
						
						<li style="width:80px"></li> 
						<li style="width:50px"></li> 
					</ul>
				</div>
	            <div class="lowbanner3"> </div>	
		</div> 

	
	<?php 
if (!empty($mrrs)) {

Example #4

0

Show file

File: create_mrr_by_LC.php Project: rajibahmed/IIMS

<?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 #5

0

Show file

File: mrr_by_lc_actions.php Project: rajibahmed/IIMS

<?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 #6

0

Show file

File: print_mrr.php Project: rajibahmed/IIMS

<?php

require_once "../../../lib/mrr.class.php";
require_once "../../../lib/helper_functions.php";
$mrr = new MRR();
$mrr_details = $mrr->PrintDetailsOfMrr((int) $_GET[id]);
// echo "<pre>";
// 	var_dump($getPassDetails);
// echo "</pre>";
$row = count($mrr_details);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Print MRR</title>
<link href="../../../css/report.css" rel="stylesheet" type="text/css" />
</head>

<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
    <td width="25%" height="94" align="center" valign="top">
        <td width="50%" height="26" align="center" valign="top"><h1>Square Textiles Ltd.</h1>
          <p class="style1">Saradaganj, Kashimpur, Gazipur </p>
          <h3>MRR</h3>
    <h4>&nbsp;</h4>		</td>
  <tr>
    <td colspan="2">Consumption No. &nbsp;<?php 
echo $mrr_details[0]["mrr_number"];
?>

Example #7

0

Show file

File: create_qc.php Project: rajibahmed/IIMS

<?php

require_once '../../lib/defination.class.php';
include '../../lib/supplier.class.php';
include '../../lib/stock.class.php';
include '../../lib/qc.class.php';
include '../../lib/mrr.class.php';
$stock = new Stock();
$QC = new QC();
$output = options_for_select($stock->retriveStockItem(), 'stock_item_id', 'stock_item_name');
// get suppliers info for combo box;
$Supplier = new Supplier();
$outputSupplierItem = options_for_select($Supplier->retriveSupplierInfo(), 'sup_id', 'sup_name', true);
$MRR = new MRR();
$outputMRRtNo = options_for_select($MRR->retriveMRRInfo(), 'mrr_id', 'mrr_number', true);
$locations = options_for_select($stock->retriveLocation(), 'stock_location_id', 'stock_location_name');
$num = $QC->getNewId();
?>
<div id="note"> </div>
<form id="mrrForm" name="mrrForm" method="post"  action="includes/model/qc_order_actions.php" >
	
	<div class='morelabel'>
		
		<p>
			
				<label>QC # </label>
			<input type="text" disabled value="<?php 
echo generate_timestamp('QC', $num);
?>
"  />
			<input type="hidden" name="qc_num"

Example #8

0

Show file

File: create_mrr_finished.php Project: rajibahmed/IIMS

<?php

require_once '../../lib/defination.class.php';
include '../../lib/supplier.class.php';
include '../../lib/finish_item.class.php';
include '../../lib/indent.class.php';
include '../../lib/mrr.class.php';
include '../../lib/stock.class.php';
$stock = new Stock();
$finishItem = new finishItem();
$MRR = new MRR();
$output = options_for_select($finishItem->retriveFinishItem(), 'stock_item_id', 'stock_item_name');
// get suppliers info for combo box;
$Supplier = new Supplier();
$outputSupplierItem = options_for_select($Supplier->retriveSupplierInfo(), 'sup_id', 'sup_name', true);
$Indent = new Indent();
$outputIndentNo = options_for_select($Indent->retriveIndendInfo(), 'indent_id', 'indent_code', true);
$locations = options_for_select($stock->retriveLocation(), 'stock_location_id', 'stock_location_name');
$num = $MRR->getMRRFinishId();
?>

<form id="consumptionForm" name="consumptionForm" method="post"   action="includes/model/mrr_finish_actions.php" >	

		
	
	<div id="note"> </div>

	<div class='morelabel'>
		<p>
			
				<label>MRR # </label>

Example #9

0

Show file

File: mrr_finish_actions.php Project: rajibahmed/IIMS

<?php

session_start();
require_once '../../lib/mrr.class.php';
require_once '../../lib/finish_item.class.php';
extract($_POST);
//print_r($_POST);
$userId = $_SESSION[userid];
$MRR = new MRR();
$stock = new finishItem();
$num = $MRR->getMRRFinishId();
$getData = "'{$num}','{$mrr_num}','{$date_of_submit}','{$userId}','{$PurchaseorderId}','{$selSupplier}','{$indentNo}','','',1";
extract($MRR->CreateMRRFinishMaster($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->CreateMRRFinishDetails($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->CreateMRRFinishDetails($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);
    }

Example #10

0

Show file

File: mrr_view.php Project: rajibahmed/IIMS

<?php

require_once "../../../lib/mrr.class.php";
require_once "../../../lib/helper_functions.php";
$Mrr = new MRR();
$consumptions = $Mrr->FindDetailsOfMrr((int) $_GET[id]);
?>
<table width="200" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><a class="button" href="includes/contents/voucher_print/print_mrr.php?id=<?php 
echo $_GET[id];
?>
"  title="Print Mrr">Print</a></td>
  </tr>
</table>

	 <div id="inline_form">
			
			<div class="mediumbody">
				<div class="lowbanner1"> </div>
	            <div class="lowbannertest">	
					<ul>
						<li style="width:250px">Items </li>
						<li style="width:90px">Code #</li>  
						<li style="width:90px">Part #</li> 
						<li style="width:70px">Qty.</li> 
						<li style="width:100px">Price</li> 
						<li style="width:50px">Value</li> 
					</ul>
				</div>
	            <div class="lowbanner3"> </div>

PHP MRR Examples