Search New System
"; $stmt = pdoquery($s); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $curid=$row['id']; $curdisp[$curid]=$row['currency']; } $s="SELECT count(id) as stktot , Stock_ref, Porref FROM Serialnumbers where Porref like ? group by Stock_ref,Porref"; //print "$s"; $stmt = pdoquery($s, array('%'.$searchorderid.'%')); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $stkref=$row['Stock_ref']; $porref=$row['Porref']; $link=$porref."A".$stkref; $stkrec[$stkref] = isset($stkrec[$stkref]) ? $stkrec[$stkref] : 0; $stkrec[$link] = $stkrec[$stkref]+$row['stktot']+0; } $s="SELECT * FROM ISO_quality_manual_files where porref<>'' and archived=''"; $stmt = pdoquery($s); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $porref=$row['porref']; $supplierrefdoclinks[$porref] = isset ( $supplierrefdoclinks[$porref] ) ? $supplierrefdoclinks[$porref] : '' ; $supplierrefdoclinks[$porref] .= "
![](\"../../images/pdf.png\"){kind=small}
".$row['description'].""; } if ($narrowpor=='') { print "
Showing Outstanding Purchase Orders
"; $s="SELECT sum(qty) as qty , viamedquote_purchase_orders_details.stockref, viamedquote_purchase_orders.hostcompanyid, viamedquote_purchase_orders.company_id, viamedquote_purchase_orders_details.supplier_ref, viamedquote_purchase_orders_details.supplier_description, viamedquote_purchase_orders.currency_id, viamedquote_purchase_orders_details.orderid, viamedquote_purchase_orders.commitedon, price FROM viamedquote_purchase_orders,viamedquote_purchase_orders_details WHERE viamedquote_purchase_orders.id like ? AND viamedquote_purchase_orders.id=viamedquote_purchase_orders_details.orderid AND viamedquote_purchase_orders_details.qty <> viamedquote_purchase_orders_details.qty_received AND viamedquote_purchase_orders.commitedon >'0' and viamedquote_purchase_orders.completedon='0' $hostsearch group by stockref,viamedquote_purchase_orders_details.orderid order by viamedquote_purchase_orders_details.orderid desc "; $params = array('%'.$searchorderid.'%'); } else { if ($searchorderid=='') { $searchorderid="IGNOREME"; } $s=" SELECT sum(qty) as qty , sum(qty_received) as qty_received, viamedquote_purchase_orders_details.stockref, viamedquote_purchase_orders.hostcompanyid, viamedquote_purchase_orders.company_id, viamedquote_purchase_orders_details.supplier_ref, viamedquote_purchase_orders_details.supplier_description, viamedquote_purchase_orders.currency_id, viamedquote_purchase_orders_details.orderid, viamedquote_purchase_orders.commitedon, viamedquote_purchase_orders.cancelledon, viamedquote_purchase_orders.completedon, price, viamedquote_purchase_orders.contact_id FROM viamedquote_purchase_orders,viamedquote_purchase_orders_details WHERE (viamedquote_purchase_orders.id like ? or viamedquote_purchase_orders_details.stockref like ? or viamedquote_purchase_orders_details.supplier_ref like ? ) AND viamedquote_purchase_orders.id=viamedquote_purchase_orders_details.orderid $hostsearch group by stockref,viamedquote_purchase_orders_details.orderid order by viamedquote_purchase_orders_details.orderid desc "; $params = array('%'.$searchorderid.'%', '%'.$narrowpor.'%', '%'.$narrowpor.'%'); } print "| Host | Purchase Order | Edit | Supplier | Stock Ref | Supplier Ref | Description | "; print "Qty | Qty Delivered | Qty Remain | Currency | Unit Price | Files |
| $global_company_logo24[$hostid] | "; if ($row['supplier_ref']=='') { $row['supplier_ref']=$stkref; } print "".linkpurchaseorder($x,$porref,$float,$size)."$porref";
if ($row['completedon']>'0') {
print " Completed Order "; } if ($row['cancelledon']>'0') { print " Cancelled Order "; } print " | ";
print ""; if ($row['commitedon']==0 ){ print ""; } if ( $usersecurity > 6){ print ""; } print " | "; print "".linkcrm($x,$companyid,$contactid).getcompanyname($companyid)." | "; print "".linkstkref($x,$row['stockref'],$float,$size,$hostid).$row['stockref']." | "; print "".$row['supplier_ref']." | "; print "".$row['supplier_description']." | "; print "".$row['qty']." | "; print "".$recqty." | "; print "".$outs." | "; print "".$curdisp[$curid]." | "; print "".$row['price']." | ";
$supplierrefdoclinks[$porref] = isset ( $supplierrefdoclinks[$porref] ) ? $supplierrefdoclinks[$porref] : '';
if ($supplierrefdoclinks[$porref] != '') {
print $supplierrefdoclinks[$porref]." "; } $operadoc=$porref; print " ADD $porref Paperwork Type | ";
print "
Opera DAta Lookup
"; $s="SELECT * FROM Supp"; $stmt = pdoquery($s); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $useac=$row['ACCOUNT']; $usename[$useac]=$row['NAME']; } $s="SELECT * FROM stocklist"; $stmt = pdoquery($s); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $usestk=$row['STOCK_REFE']; $stkdesc[$usestk]=$row['DESCRIPTIO']; } if ($narrowpor=='') { include("viamedquoteposearch.php"); ?> fetchAll(PDO::FETCH_ASSOC); $numfound = count($rows); $s="SELECT * FROM supplier_items WHERE POR like ? "; $stmt = pdoquery($s, array('%'.$narrowpor.'%')); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); if ($numfound==1) { foreach($rows as $row2) { $narrowpor=$row2['POR']; } ?> "; foreach($rows as $row2) { if ($row2['Order_complete']=='') { print "