<?php include '../../resources/init.php'; $q = strtolower($_GET["q"]); if (!$q) { return; } $items = Inv_item::findLike($q); //echo $items->count(); $jsonString = "["; foreach ($items as $item) { if (strpos(strtolower($item->getId()), $q) !== false) { $jsonString = $jsonString . "{ name: \"" . $item->prepareId() . "\", desc: \"" . $item->prepareDescription() . "\", uom:\"" . $item->prepareUnitOfMeasure() . "\" },"; } } $jsonString = substr($jsonString, 0, strlen($jsonString) - 1) . "]"; echo $jsonString;
} else { if ($_POST['type'] == "delete") { 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(); }
$branch = new Branch($production->getBranchId()); echo $branch->prepareName() . " / " . "<span id=\"branchId\">" . $production->prepareBranchId() . "</span>"; ?> <br /> <table id="formContent"> <thead> <tr><th>No</th> <th>Item Code</th><th width="400">Description</th><th>Quantity</th><th>UOM</th><th>Remarks</th><th>Icons</th></tr> </thead> <tbody> <?php $hideCancel = false; $counter = 1; foreach ($production_details as $production_detail) { echo "<tr id=\"rowNo" . $counter . "\"><td id=\"detailId\" class=\"hideFirst\">" . $production_detail->getId() . "</td><td>" . $counter . "</td><td id=\"itemCode\">" . $production_detail->prepareItemId() . "</td>"; $item = new Inv_item($production_detail->getItemId()); echo "<td class=\"itemDesc\">" . $item->prepareDescription() . "</td>\n\t\t\t\t\t\t\t\t<td id=\"itemQuan\">" . $production_detail->prepareQuantity() . "</td>\n\t\t\t\t\t\t\t \t<td>" . $item->prepareUnitOfMeasure() . "</td><td>" . $production_detail->prepareRemark() . "</td>"; if ($production_detail->getStatus() == "pending") { echo "<td id=\"iconCell\"><ul id=\"icons\" class=\"ui-widget ui-helper-clearfix\">\n\t\t\t\t\t\t\t\t<li id=\"save\" title=\"Save\" class=\"ui-state-default ui-corner-all\">\n\t\t\t\t\t\t\t\t\t<span class=\"ui-icon ui-icon-disk\"></span>\n\t\t\t\t\t\t\t\t\t<span class=\"text-icon\">Save</span>\n\t\t\t\t\t\t\t\t</li>\n\t\t\t\t\t\t\t\t<li title=\"Loading\" class=\"hideFirst ui-corner-all\">\n\t\t\t\t\t\t\t\t\t<img src=\"./img/layout/ajax-loader2.gif\" />\n\t\t\t\t\t\t\t\t</li></ul></td></tr>"; } else { echo "<td id=\"iconCell\"><ul id=\"icons\" class=\"ui-widget ui-helper-clearfix\"><li title=\"Complete\" class=\"ui-state-default ui-corner-all\"><span class=\"ui-icon ui-icon-check\"></span></li><li title=\"Loading\" class=\"hideFirst ui-corner-all\"><img src=\"./img/layout/ajax-loader2.gif\" /></li></ul></td></tr>"; $hideCancel = true; } $counter++; } ?> </tbody> </table> <label>Notes</label><br /><?php echo $production->prepareNotes(); ?>
?> <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> <?php
try { $uploader = new fUpload(); $uploader->setMIMETypes(array('image/gif', 'image/jpeg', 'image/pjpeg', 'image/png'), 'The file uploaded is not an image'); $uploader->enableOverwrite(); $file = $uploader->move($uploadDirectory, 'file'); $inv_item = new Inv_item($_POST['hiddenId']); $inv_item->setImageUrl('storage/image/' . $_POST['hiddenId'] . '/' . $file->getFilename()); $inv_item->store(); echo "Image uploaded"; } catch (fExpectedException $e) { echo $e->printMessage(); } } } } } } } } } else { if (isset($_GET['type'])) { if ($_GET['type'] == "uom") { try { $inv_item = new Inv_item($_GET['key']); echo $inv_item->prepareUnitOfMeasure(); } catch (fExpectedException $e) { echo $e->printMessage(); } } } }
<?php } ?> </div> <table id="formContent"> <thead> <tr><th>No</th> <th>Item Code</th><th width="300px">Description</th><th>Quantity</th><th>UOM</th><th>Unit Price</th><th>Extended Price</th></tr> </thead> <tbody> <?php $counter = 1; $totalchecker = 0; foreach ($purchase_details as $purchase_detail) { echo "<tr><td>" . $counter . "</td><td>" . $purchase_detail->prepareItemId() . "</td>"; $item = new Inv_item($purchase_detail->getItemId()); echo "<td>" . $purchase_detail->prepareDescription() . "</td><td>" . $purchase_detail->prepareQuantity() . "</td>\n\t\t\t\t\t\t\t \t<td>" . $item->prepareUnitOfMeasure() . "</td><td>" . $purchase_detail->prepareUnitPrice() . "</td>\n\t\t\t\t\t\t\t\t<td>" . $purchase_detail->prepareExtendedPrice() . "</td></tr>"; $totalchecker = $totalchecker + $purchase_detail->getExtendedPrice(); $counter++; } ?> </tbody> <?php $totalchecker = $totalchecker - $purchase->getDiscount(); if ($totalchecker != $purchase->getTotal()) { $purchaseNu = new Purchase($_GET['id']); $purchaseNu->setTotal($totalchecker); $purchaseNu->store(); } ?> <tfoot>
if ($row->{'detailId'} == 0) { $purchase_detail = new Purchase_detail(); } else { $purchase_detail = new Purchase_detail($row->{'detailId'}); } $purchase_detail->setDocNumber($key); $purchase_detail->setItemId($row->{'itemCode'}); $purchase_detail->setDescription($row->{'itemDesc'}); $purchase_detail->setQuantity($row->{'itemQuan'}); $purchase_detail->setUnitPrice($row->{'itemUnitP'}); $extendedPrice = $row->{'itemQuan'} * $row->{'itemUnitP'}; $total = $total + $extendedPrice; $purchase_detail->setExtendedPrice(round($extendedPrice, 2)); //$purchase_detail->setExtendedPrice($row->{'itemExtP'}); if ($_POST['approver_1'] != null && $_POST['approver_1_date'] != null) { $item = new Inv_item($row->{'itemCode'}); $item->setCurrencyId($purchase->getCurrency()); $item->setRate($row->{'itemUnitP'}); $item->store(); } if (!$error) { $purchase_detail->store(); } } catch (fExpectedException $e) { echo $e->printMessage(); $error = true; } } if (!$error) { $total = $total - $_POST['discount']; $purchase->setTotal(round($total, 2));
</tr> </table> </div> </div> <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>(A)</th></tr> </thead> <!-- <tbody> <?php $counter = 1; foreach ($grn_details as $grn_detail) { echo "<tr><td>" . $counter . "</td><td>" . $grn_detail->prepareItemId() . "</td>"; $item = new Inv_item($grn_detail->getItemId()); echo "<td>" . $item->prepareDescription() . "</td><td>" . $grn_detail->prepareQuantity() . "</td>\n\t\t\t\t\t\t\t \t<td>" . $item->prepareUnitOfMeasure() . "</td><td>" . $grn_detail->prepareRemark() . "</td>\n\t\t\t\t\t\t\t\t<td class=\"assessText\">" . $grn_detail->prepareAssessment() . "</td></tr>"; $counter++; } ?> </tbody> --> <tbody> </tbody> <tfoot> <tr><td colspan="7"> <p> <label>Assesment Of Condition (A)</label><br /> <b>OK</b> : Item received in good condition<br /> <b>NG</b> : Item is in damaged condition<br /> <b>Q </b> : Quantity supplied did not match DO quantity<br />
echo "<a href=\"inventory-stock.php?branch={$branch}&page={$times}\">Last</a></span>"; } printf("<table><thead><tr><th>Item ID</th><th>Description</th><th>Quantity</th></tr></thead><tbody>"); foreach ($inv_stocks as $inv_stock) { $inv_item = new Inv_item($inv_stock->getItemId()); printf("<tr><td>%s</td><td>%s</td><td>%s</td></tr>", $inv_item->prepareId(), $inv_item->prepareDescription(), $inv_stock->prepareQuantity() . " " . $inv_item->prepareUnitOfMeasure()); } echo "</tbody></table>"; } catch (fExpectedException $e) { echo $e->printMessage() . $inv_stock->getItemId(); } } else { 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></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>%s</td></tr>", $branch->prepareName() . " [" . $branch->prepareId() . "]", $inv_stock->prepareQuantity() . " " . $item->prepareUnitOfMeasure()); } echo "</tbody></table>"; } catch (fExpectedException $e) { echo $e->printMessage(); } } } ?> </div> </div> <?php
?> <br /> <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>";
<?php include './resources/init.php'; //Find all items $results = Inv_item::findIdUB($db); //$results = Inv_item::findAll(); foreach ($results as $result) { echo $result . " \n"; }
printf("<br /><h3 id=\"mainCategoryTitle\" key=\"%s\">%s</h3>", $_GET['maincc'], $inv_maincategory->prepareDescription()); } else { if (!isset($_GET['page']) || $_GET['page'] == 1) { $first = 0; $last = 100; } else { $first = ($_GET['page'] - 1) * 100; $last = $first + 100 - 1; } //$inv_counter = count(Inv_item::findAll()); $inv_counter = 0; $temps = $db->query('SELECT count(*) as num FROM inv_items'); foreach ($temps as $row) { $inv_counter = $row['num']; } $inv_items = Inv_item::findAllLimit($first, 100); //echo "FIRST:". $first ."LAST:". $last; $times = ceil($inv_counter / 100); //$times = 30; echo "<h3>All results</h3>"; if ($times < 2) { echo "<span id=\"pagination\"><a href=\"inventory.php?maincc=all\">First </a>"; echo "<a href=\"inventory.php?maincc=all&page={$times}\">Last</a></span>"; } else { echo "<span id=\"pagination\"><a href=\"inventory.php?maincc=all\">First </a>"; for ($i = 1; $i < $times; $i++) { echo "<a href=\"inventory.php?maincc=all&page={$i}\">{$i} </a></span>"; } echo "<a href=\"inventory.php?maincc=all&page={$times}\">Last</a></span>"; } }
include './resources/init.php'; fAuthorization::requireLoggedIn(); $tmpl->place('header'); ?> <script type="text/javascript" src="./js/inventory-view.js"></script> </head> <body> <div class = "container"> <div id="View" class = "view-frame span-23 last"> <?php if (!isset($_GET['id'])) { echo "<div class=\"ui-state-error ui-corner-all\">\r\n\t\t\t\t\t<span class=\"ui-icon ui-icon-alert\" style=\"float: left; margin-right: 30px;\"></span>\r\n\t\t\t\t\tYou arrived to this page in error</div>"; } else { try { $inv_item = new Inv_item($_GET['id']); ?> <div id="content"> <div id="Id" class="span-8"><h1 id="idCaption"><?php echo $inv_item->prepareId(); ?> </h1> <?php try { $profile = new fImage($inv_item->getImageUrl()); if ($profile->getWidth() != 300) { $profile->resize(300, 0); $profile->saveChanges(); } echo "<img class=\"view-img\" src=\"" . $inv_item->prepareImageUrl() . "\"></img>"; } catch (fExpectedException $e) {