예제 #1
0
     try {
         $branch = new Branch($_POST['key']);
         $branch->delete();
     } catch (fExpectedException $e) {
         echo $e->printMessage();
     }
 } else {
     if ($_POST['type'] == "add") {
         try {
             $branch = new Branch();
             $branch->populate();
             $branch->store();
             $theId = $branch->getId();
             $ids = Inv_item::findIdUB($db);
             foreach ($ids as $id) {
                 $stock = new Inv_stock();
                 $stock->setBranchId($theId);
                 $stock->setItemId($id);
                 $stock->setQuantity(0);
                 $stock->store();
             }
         } catch (fExpectedException $e) {
             echo $e->printMessage();
         }
     } else {
         if ($_POST['type'] == "name") {
             $branch = new Branch($_POST['key']);
             echo $branch->prepareName();
         }
     }
 }
include './resources/init.php';
$tmpl->place('header');
?>
<script type="text/javascript" src="./js/admin-branch.js"></script>
<?php 
$tmpl->place('menu');
?>
<div id="content" class="span-24 last">
	<?php 
$tmpl->place('menuReport');
?>
	<h2>User Report</h2><h3>Aging</h3>
	<?php 
$branch = "HQKL";
$items = Inv_stock::findByBranch($branch);
?>
	<table>
		<thead>
			<tr>
				<th></th>
				<?php 
for ($i = 1; $i <= 12; $i++) {
    $stringmonth = date("F", mktime(0, 0, 0, $i));
    echo "<th>" . $stringmonth . "</th>";
}
?>
			</tr>
		</thead>
		<tbody>
			<?php 
예제 #3
0
$tmpl->place('menuAdmin');
?>
	<div id="main" class="span-24 last">
		<h2>Administration</h2><h3>Stock</h3>
		<br />
		<form action = "admin-stock.php" method = "get">
			<label for="inv_item">Choose Inventory Item: </label>
			<span id="inv_item">
				<input id="autocompleteItem" name="item"></input>
			</span>
			<input id="submitBTN" type="submit" value="Submit" />
		</form>
		<?php 
if (isset($_GET['item'])) {
    try {
        $inv_stocks = Inv_stock::findByItem($_GET['item']);
        $item = new Inv_item($_GET['item']);
        printf("<br /><h3>%s - %s</h3><table><thead><tr><th>Branch</th><th>Quantity</th><th width=\"100\">Update</th></tr></thead><tbody>", $item->prepareId(), $item->prepareDescription());
        foreach ($inv_stocks as $inv_stock) {
            $branch = new Branch($inv_stock->getBranchId());
            printf("<tr><td>%s</td><td><input type=\"text\" value=\"%s\" /> %s</td><td><input class=\"updateBTN\" id=\"%s\" type=\"button\" value=\"Update\"/></td></tr>", $branch->prepareName() . " [" . $branch->prepareId() . "]", $inv_stock->getQuantity(), $item->prepareUnitOfMeasure(), $inv_stock->getId());
        }
        echo "</tbody></table>";
    } catch (fExpectedException $e) {
        echo $e->printMessage();
    }
}
?>
	</div>
</div>
<div id="messageBox" style="display: none;">Loading</div>
             $grn_detail->setDescription($row->{'itemDesc'});
             $grn_detail->setQuantity($row->{'itemQuan'});
             $grn_detail->setAssessment($row->{'assess'});
             $grn_detail->setRemark($row->{'remarks'});
             if (!$error) {
                 $grn_detail->store();
             }
         } catch (fExpectedException $e) {
             echo $e->printMessage();
             $error = true;
         }
     }
 }
 $details = Good_receipt_note_detail::findDetail($grn->getDocNumber());
 foreach ($details as $detail) {
     Inv_stock::addStock($detail->getItemId(), $grn->getBranchId(), $detail->getQuantity());
 }
 $grn->setStatus("completed");
 $grn->store();
 if ($_POST['cloneNew'] == "yes") {
     //if(substr($grn->getDocNumber(),-3) != "rev")
     $newGRNNo = $grn->getDocNumber() . "/rev";
     //else{
     //	$newGRNNo = $grn->getDocNumber().Good_receipt_note::findRev($grn->getPoNo());
     //}
     $newGRN = $grn->replicate();
     $newGRN->setDocNumber($newGRNNo);
     $newGRN->setDocType("GRNRev");
     $newGRN->setStatus('incomplete');
     $newGRN->store();
     foreach ($jsonForm as $row) {
예제 #5
0
<?php

include '../resources/init.php';
if (isset($_POST['type'])) {
    if ($_POST['type'] == "add") {
        try {
            $inv_item = new Inv_item();
            $inv_item->populate();
            $inv_item->store();
            $branches = Branch::findAll();
            foreach ($branches as $branch) {
                $stock = new Inv_stock();
                $stock->setBranchId($branch->getId());
                $stock->setItemId($inv_item->getId());
                $stock->setQuantity(0);
                $stock->store();
            }
        } catch (fExpectedException $e) {
            echo $e->printMessage();
        }
    } else {
        if ($_POST['type'] == "delete") {
            try {
                $inv_item = new Inv_item($_POST['key']);
                $inv_item->delete();
            } catch (fExpectedException $e) {
                echo $e->printMessage();
            }
        } else {
            if ($_POST['type'] == "edit") {
                try {
                 $error = true;
             }
         }
     } catch (fExpectedException $e) {
         echo $e->printMessage();
         $error = true;
     }
 } else {
     if ($_POST['type'] == "removeStock") {
         $records = Inv_stock::gotoStock($_POST['itemCode'], $_POST['branch']);
         if ($records->count()) {
             foreach ($records as $record) {
                 if ($record->getQuantity() < $_POST['itemQuan']) {
                     echo "Item not enough quantity";
                 } else {
                     Inv_stock::removeStock($_POST['itemCode'], $_POST['branch'], $_POST['itemQuan']);
                     $stock = new Production_issue_detail($_POST['detailId']);
                     $stock->setStatus('completed');
                     $stock->store();
                 }
             }
         } else {
             echo "Item not enough quantity.";
         }
     } else {
         if ($_POST['type'] == "save") {
             try {
                 $production = new Production_issue($_POST['key']);
                 //$production->populate();
                 if ($_POST['issuer'] != "") {
                     $production->setIssuer($_POST['issuer']);
                 $mattrans->setStatus("pending");
             }
         }
         $mattrans->store();
     } catch (fExpectedException $e) {
         echo $e->printMessage();
     }
 } else {
     if ($_POST['type'] == "accept") {
         try {
             $mattrans_detail = new Material_transfer_detail($_POST['key']);
             $mattrans = new Material_transfer($mattrans_detail->getDocNumber());
             if ($mattrans_detail->getStatus() != "transit") {
                 throw new fProgrammerException('Status Overidden: ' . $mattrans_detail->getStatus());
             }
             Inv_stock::moveTransit($mattrans_detail->getItemId(), $mattrans->getBranchFrom(), $mattrans->getBranchTo(), $mattrans_detail->getQuantity());
             $mattrans_detail->setStatus("completed");
             $mattrans_detail->setReceiver($_POST['user']);
             $mattrans_detail->store();
             $mat_details = Material_transfer_detail::findDetail($mattrans->getDocNumber());
             foreach ($mat_details as $mat_detail) {
                 if ($mat_detail->getStatus() == "completed") {
                     $mattrans->setStatus("completed");
                 } else {
                     $mattrans->setStatus("pending");
                 }
             }
             $mattrans->store();
         } catch (fExpectedException $e) {
             echo $e->printMessage();
         }
		<table id="formContent">
			<thead>
				<tr><th>No</th>
					<th>Item Code</th><th width="300px">Description</th><th>Quantity</th><th>UOM</th><th>Remarks</th><th>In <?php 
        echo $fromBranch->getId();
        ?>
</th><th width="75px">Receiver</th></tr>
			</thead>
			<tbody>
				<?php 
        $counter = 1;
        foreach ($mattrans_details as $mattrans_detail) {
            echo "<tr class=\"jsonRow\"><td>" . $counter . "</td><td class=\"itemCode\">" . $mattrans_detail->prepareItemId() . "<input class=\"itemId\" type=\"hidden\" value=\"" . $mattrans_detail->getId() . "\"></input></td>";
            $item = new Inv_item($mattrans_detail->getItemId());
            echo "<td>" . $item->prepareDescription() . "</td><td class=\"itemQuan\">" . $mattrans_detail->prepareQuantity() . "</td>\n\t\t\t\t\t\t\t \t<td>" . $item->prepareUnitOfMeasure() . "</td><td>" . $mattrans_detail->prepareRemark() . "</td>";
            $tempRecords = Inv_stock::findStockByBranch($mattrans_detail->getItemId(), $mattrans->getBranchFrom());
            $quanRow = 0;
            foreach ($tempRecords as $tempRecord) {
                $quanRow = $tempRecord->getQuantity();
            }
            echo "<td>" . $quanRow . "</td>";
            if (fAuthorization::checkAuthLevel('admin')) {
                echo "<td><span class=\"loader hideFirst\"><img src=\"./img/layout/ajax-loader2.gif\" /></span>";
                if ($mattrans_detail->getStatus() == "pending" && $quanRow >= $mattrans_detail->getQuantity()) {
                    echo "<input type=\"button\" value=\"Transit\" \n\t\t\t\t\t\t\t\t\t\tkey=\"" . $mattrans_detail->getId() . "\" class=\"transitBTN\"></input></td>";
                } else {
                    if ($mattrans_detail->getStatus() == "transit") {
                        echo "<input type=\"button\" value=\"Reject\" \n\t\t\t\t\t\t\t\t\t\tkey=\"" . $mattrans_detail->getId() . "\" class=\"rejectBTN\"></input>";
                        echo "<input type=\"button\" value=\"Accept\" \n\t\t\t\t\t\t\t\t\t\tkey=\"" . $mattrans_detail->getId() . "\" class=\"acceptBTN\"></input>";
                        echo "</td>";
                    } else {
예제 #9
0
            try {
                Inv_stock::removeStock($row->{'itemCode'}, $row->{'branch'}, $row->{'quantity'});
                $mattrans = new Material_transfer($_POST['doc_num']);
                $mattrans->setStatus("completed");
                $mattrans->store();
                $mattrans_detail = new Material_transfer_detail($row->{'id'});
                $mattrans_detail->setFromBranch($row->{'branch'});
                $mattrans_detail->store();
            } catch (fExpectedException $e) {
                echo $e->printMessage();
            }
            Inv_stock::addStock($row->{'itemCode'}, $_POST['branch'], $row->{'quantity'});
        }
    } else {
        if ($_POST['type'] == "ACcount") {
            try {
                $branch = fRequest::get('branch');
                $itemcode = fRequest::get('item');
                $stocks = Inv_stock::findStockByBranch($itemcode, $branch);
                $stock = $stocks[0];
                echo $stock->prepareQuantity();
            } catch (fExpectedException $e) {
                echo $e->printMessage();
            }
        } else {
            if ($_POST['type'] == "reset") {
                echo Inv_stock::resetStock(fRequest::get('target'), fRequest::get('quantity', 'integer'));
            }
        }
    }
}