function showPurchaseOrderUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$any = new Anylist();
if ($this->poid != '') {
$q = "SELECT *,DATE_FORMAT(PO_Date,'%d-%m-%Y') as pod,DATE_FORMAT(Supp_Ref_Date,'%d-%m-%Y') as srd,DATE_FORMAT(Required_Date,'%d-%m-%Y') as rdate,DATE_FORMAT(Not_Later_Date,'%d-%m-%Y') as nldate FROM Purchase_Order WHERE PO_ID={$this->poid}";
if (!($res = $cxn->query($q))) {
exit("error (showPurchaseOrderUI) {$q} : {$cxn->error}");
}
$r = mysqli_fetch_assoc($res);
$this->pono = $r['PO_NO'];
$this->supplierid = $r['Supplier_ID'];
$this->podatedb = $r['PO_Date'];
$this->podate = $r['pod'];
$this->suppref = $r['Supp_Ref'];
$this->supprefdatedb = $r['Supp_Ref_Date'];
$this->supprefdate = $r['srd'];
$this->potermid = $r['Terms_ID'];
$this->currency = $r['Currency'];
$this->notes = $r['Notes'];
$this->requireddatedb = $r['Required_Date'];
$this->requireddate = $r['rdate'];
$this->notlaterdatedb = $r['Not_Later_Date'];
$this->notlaterdate = $r['nldate'];
$qi = "SELECT * FROM PO_Item WHERE PO_ID={$this->poid}";
if (!($res2 = $cxn->query($qi))) {
exit("error (showPurchaseOrderUI2) {$qi} : {$cxn->error}");
}
$desc = array();
$i = 0;
while ($ri = mysqli_fetch_assoc($res2)) {
$desc[$i] = ['poitemid' => $ri['PO_Item_ID'], 'desc' => $ri['Description'], 'qty' => $ri['Item_Qty'], 'price' => $ri['Unit_Price'], 'discount' => $ri['Discount']];
$i++;
}
}
echo '<fieldset><legend>Enter Purchase Order Details</legend>';
echo '<p><label>Purchase Order No</label><input id="pono" name="pono" class="required" value="' . $this->pono . '">';
echo '<p><label>Purchase Order Date</label><input id="podate" name="podate" class="required" value="' . $this->podate . '"><input id="podatedb" name="podatedb" type="hidden" value="' . $this->podatedb . '">';
echo '<p><label>Supplier Ref No</label><input id="suppref" name="suppref" value="' . $this->suppref . '">';
echo '<p><label>Supplier Ref Date</label><input id="supprefdate" name="supprefdate" class="required" value="' . $this->supprefdate . '"><input id="supprefdatedb" name="supprefdatedb" type="hidden" value="' . $this->supprefdatedb . '">';
echo '<p><label>Currency</label><input id="currency" name="currency" value="' . $this->currency . '">';
echo '<p><label>Notes</label><input id="notes" name="notes" value="' . $this->notes . '" size="100">';
echo '<p><label>Required Date</label><input id="requireddate" name="requireddate" class="required" value="' . $this->requireddate . '"><input id="requireddatedb" name="requireddatedb" type="hidden" value="' . $this->requireddatedb . '">';
echo '<p><label>Not Later Then Date</label><input id="notlaterdate" name="notlaterdate" class="required" value="' . $this->notlaterdate . '"><input id="notlaterdatedb" name="notlaterdatedb" type="hidden" value="' . $this->notlaterdatedb . '">';
echo '<p><label>Purchase Order Item Details</label><input type="button" id="additem" value="Add One More Item">';
echo '<table class="pcd" id="item"><tr><th>Sl No</th><th>Description</th><th>Quantity</th><th>Unit Price</th><th>Discount</th></tr>';
if ($this->poid != '') {
if (isset($desc[0]['poitemid'])) {
$i = 0;
$j = count($desc);
while ($i < $j) {
$slno = $i + 1;
echo '<tr><td><input id="poitemid[' . $i . ']" name="poitemid[' . $i . ']" value="' . $desc[$i]['poitemid'] . '" type="hidden">' . $slno . '</td><td><input id="description[' . $i . ']" name="description[' . $i . ']" class="required" value="' . $desc[$i]['desc'] . '"></td>';
echo '<td><input i="itemqty[' . $i . ']" name="itemqty[' . $i . ']" class="required" value="' . $desc[$i]['qty'] . '"></td>';
echo '<td><input i="price[' . $i . ']" name="price[' . $i . ']" class="required" value="' . $desc[$i]['price'] . '"></td>';
echo '<td><input i="discount[' . $i . ']" name="discount[' . $i . ']" value="' . $desc[$i]['discount'] . '"></td></tr>';
$i++;
}
} else {
$this->addItemRow('0');
}
} else {
$this->addItemRow('0');
}
echo '</table>';
echo '<fieldset><legend>Select Terms and Condition</legend>';
$any->createAnyGrid('PO_Terms', 'Term', 'PO_Term_ID', $this->potermid);
echo '<input type="button" id="preview" value="Preview PO">';
echo '<input type="checkbox" id="previewok" name="previewok" value="1">PreView Checked OK';
echo '</fieldset>';
}
//machine list
$l = new Operator();
$l->createLEaveList();
$sel = new selectlist('Leave_ID', $l->getLeaveList(), 'Select Leave to Approve', 'Leave_ID', 'leavedesc', '', '', '1');
break;
case 'qmsactivity':
//machine list
$l = new QMS();
if (isset($_GET['id'])) {
$id = $_GET['id'];
} else {
$id = '';
}
$l->createQMSTitleList();
$sel = new selectlist('QMS_Sch_ID', $l->getQMSTitleList(), 'Select QMS Activity', 'QMS_Sch_ID', 'QMS_Title', 'class="required"', $id, '1');
break;
case 'qmsdesc':
//machine list
$any = new Anylist();
if (isset($_GET['qmsdescid'])) {
$qmsdescid = $_GET['qmsdescid'];
} else {
$qmsdescid = '';
}
$any->createAnyGrid('QMS_Desc', 'QMS_Desc', 'QMS_Desc_ID', $qmsdescid, 'QMS_Sch_ID', $_GET['qmsschid']);
break;
default:
# code...
break;
}
}
function showSpareUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$any = new Anylist();
if ($this->spareid != '') {
$q = "SELECT * FROM Spare WHERE Spare_ID={$this->spareid}";
if (!($res = $cxn->query($q))) {
exit("error (showSpareUI) : {$cxn->error}");
}
$r = mysqli_fetch_assoc($res);
$this->description = $r['Description'];
$this->supppartno = $r['Supplier_Part_NO'];
$this->mfgpartno = $r['Mfg_Part_NO'];
$this->machineid = $r['Machine_ID'];
}
echo '<fieldset><legend>Enter Spare Details</legend>';
echo '<p><label>Description</label><input id="description" name="description" class="required" value="' . $this->description . '">';
echo '<p><label>Supplier Part No</label><input id="supppartno" name="supppartno" class="required" value="' . $this->supppartno . '">';
echo '<p><label>Manufacturres\'s Part No</label><input id="mfgpartno" name="mfgpartno" value="' . $this->mfgpartno . '">';
echo '<fieldset><legend>Select Machines This Spare is Used For</legend>';
$any->createAnyGrid('Machine', 'Machine_Name', 'Machine_ID', $this->machineid);
echo '</fieldset>';
}
