<?php
require_once "db.inc.php";
require_once "facilities.inc.php";
$subheader = __("Data Center Stockroom Supplies");
if (!$person->SiteAdmin) {
// No soup for you.
header('Location: ' . redirect());
exit;
}
$sup = new Supplies();
$bc = new BinContents();
$inventory = array();
if (isset($_REQUEST["supplyid"]) && $_REQUEST["supplyid"] > 0) {
$sup->SupplyID = $_REQUEST["supplyid"];
$sup->GetSupplies();
$bc->SupplyID = $sup->SupplyID;
$inventory = $bc->FindSupplies();
}
$status = "";
if (isset($_POST["action"]) && ($_POST["action"] == "Create" || $_POST["action"] == "Update")) {
$sup->SupplyID = $_REQUEST["supplyid"];
$sup->PartNum = $_REQUEST["partnum"];
$sup->PartName = $_REQUEST["partname"];
$sup->MinQty = $_REQUEST["minqty"];
$sup->MaxQty = $_REQUEST["maxqty"];
if ($_REQUEST["action"] == "Create") {
if ($sup->PartNum != null && $sup->PartNum != "") {
$sup->CreateSupplies();
}
} else {
<?php
require_once "db.inc.php";
require_once "facilities.inc.php";
$subheader = __("Data Center Stockroom Supply Bins");
if (!$person->SiteAdmin) {
// No soup for you.
header('Location: ' . redirect());
exit;
}
$bin = new SupplyBin();
$bc = new BinContents();
$sup = new Supplies();
$supList = $sup->GetSuppliesList(true);
$formpatch = "";
$status = "";
if (isset($_REQUEST["binid"])) {
$bin->BinID = isset($_POST['binid']) ? $_POST['binid'] : $_GET['binid'];
$bin->GetBin();
$bc->BinID = $bin->BinID;
if (isset($_POST["action"]) && ($_POST["action"] == "Create" || $_POST["action"] == "Update") && ($_POST["location"] != null && $_POST["location"] != "")) {
$bin->Location = $_POST["location"];
if ($_POST["action"] == "Create") {
$bin->CreateBin();
} else {
$binContents = $bc->GetBinContents();
// We don't want someone changing the name of a bin to a blank anymore than we want them creating one as a blank name
$status = __("Updated");
$bin->UpdateBin();
// only attempt to alter the contents of the bin if we have the proper elements
if (isset($_POST['supplyid']) && count($_POST['supplyid'] > 0)) {
*/
require_once "db.inc.php";
require_once "facilities.inc.php";
require_once "mpdf/mpdf.php";
/* Version 1.0 of this report has no selectable parameters - you just get a complete dump */
$mpdf = new mPDF('win-1252', 'A4', '', '', 20, 15, 48, 25, 10, 10);
$mpdf->useOnlyCoreFonts = true;
// false is default
//$mpdf->SetProtection(array('print'));
$mpdf->SetTitle($config->ParameterArray["OrgName"] . " " . __("Supply Status Report"));
$mpdf->SetAuthor($config->ParameterArray["OrgName"]);
$mpdf->SetDisplayMode('fullpage');
$mpdf->useActiveForms = true;
$sup = new Supplies();
$bin = new SupplyBin();
$bc = new BinContents();
$SupplyList = $sup->GetSuppliesList();
$html = '
<html>
<head>
<style>
body {font-family: sans-serif;
font-size: 10pt;
}
p { margin: 0pt;
}
td { vertical-align: top; }
.items td {
border-left: 0.1mm solid #000000;
border-right: 0.1mm solid #000000;
}
function FindSupplies()
{
$this->MakeSafe();
/* Return all of the bins where this SupplyID is found */
$sql = "SELECT a.* FROM fac_BinContents a, fac_SupplyBin b WHERE \n\t\t\ta.SupplyID={$this->SupplyID} AND a.BinID=b.BinID ORDER BY b.Location ASC;";
$binList = array();
foreach ($this->query($sql) as $row) {
$binList[] = BinContents::RowToObject($row);
}
return $binList;
}
