Pxx$orderid Suppliers Purchase Orders";
?>
fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$contactid=$row['contact_id'];
$cid=$row['company_id'];
$hostcompany=$row['hostcompanyid'];
if ($hostcompany==4) {
$narrowpor='SR'.(isset($global_company_prefix[$hostcompany]) ? $global_company_prefix[$hostcompany] : '').$orderid;
}
$orderentrynotes=str_replace("
"," ",$row['memonotes']);
$internalmemonotes=str_replace("
"," ",$row['internalmemonotes']);
}
if ($cid>'0' )
{
include ("../crm/showaddress.php");
$sql = "SELECT * FROM viamedquotecontact WHERE COMPANY_ID = ? AND polog = 'on'";
//print "$sql ";
$stmt = pdoquery($sql, array($cid));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$kemailaddressesto = isset ( $kemailaddressesto ) ? $kemailaddressesto : '';
$kemailaddressesto .= $row['INETADDR'].",";
}
$kemailaddressesto=substr($kemailaddressesto, 0, -1);
$recipient = isset ( $recipient ) ? $recipient : '';
$subject = isset ( $subject ) ? $subject : '' ;
$body = isset ( $body ) ? $body : '' ;
$mailToLink = "mailto:$recipient?subject=$subject&body=$body";
$operadoc = isset ( $operadoc ) ? $operadoc : '';
$displaymaillink = operadoclinks($x,$operadoc,$float);
$displaymaillink .= '';
$displaymaillink .= "Send Email to $kemailaddressesto
(Dont forget to attach the file and SET the from link in gmail
";
}
$sql = "SELECT * FROM viamed_po_logs WHERE porref = ?";
$stmt = pdoquery($sql, array($narrowpor));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$num = count($rows);
if ($num==0)
{
$i="INSERT INTO viamed_po_logs (porref) VALUES (?)";
pdoquery($i, array($narrowpor));
//print "$i";
}
$sql = "SELECT * FROM viamed_po_logs WHERE porref = ? AND stock_ref <> ''";
//print "$sql ";
$stmt = pdoquery($sql, array($narrowpor));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$usestk="a".$row['stock_ref'];
$countline[$usestk] = (isset($countline[$usestk]) ? $countline[$usestk] : 0) + 1;
$id=$row['contactid'];
$contactid=$row['contactid'];
$cid=$row['companyid'];
$cidcompany=$row['companyid'];
$pogenby=$row['pogenby'];
$tsetby=$row['sentby'];
$tsentvia=$row['sentvia'];
$sconfby=$row['confirmedvia'];
$tracknum=" - ".$row['tracknum'];
$defaultship=$row['shipmethod'];
}
$pogenby = isset ( $pogenby ) ? $pogenby : 0 ;
if ($pogenby==0)
{
$sql = "SELECT * FROM pw WHERE username = ?";
$stmt = pdoquery($sql, array($tsetby));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$pogenby=$row['id'];
}
}
$genopts .= "
";
$sql = "SELECT pw.id as id,pw.username as username FROM pw,pw_companys WHERE pw.active='1' AND pw.username<> ''
AND pw.id=pw_companys.vui AND company_id='1'
AND username<>'Training'
AND username<>'Xhibition'
ORDER BY pw.username";
$stmt = pdoquery($sql, array());
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$genopts .= "";
}
$sql = "SELECT * FROM viamed_po_logs_est_ship WHERE po = ? ORDER BY estship DESC";
$stmt = pdoquery($sql, array($narrowpor));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$usestk=$row['stockref'];
$prndate=date("d/m/y",$row['estship']);
$multipleship[$usestk]="(".$row['estqty'].") on $prndate";
}
// lets ensure we have the base data in the system!
$sql = "SELECT * FROM supplier_items WHERE POR = ? ORDER BY OperaReference, Quantity_Required";
$stmt = pdoquery($sql, array($narrowpor));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$usestk="a".$row['OperaReference'];
$countline2[$usestk] = (isset($countline2[$usestk]) ? $countline2[$usestk] : 0) + 1;
if ((isset($countline[$usestk]) ? $countline[$usestk] : 0) < $countline2[$usestk])
{
$i="INSERT INTO viamed_po_logs (porref,stock_ref,qty) VALUES (?, ?, ?)";
pdoquery($i, array($narrowpor, $row['OperaReference'], $row['Quantity_Required']));
//print "$i";
}
}
$sql = "SELECT * FROM viamed_po_logs WHERE porref = ?";
$stmt = pdoquery($sql, array($narrowpor));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$pogenby=$row['pogenby'];
$lineid=$row['id'];
if ($row['confirmedvalidon']>0) {
$lastvalidatedby[$lineid]=getusername($row['confirmedvalidby']);
$lastvalidatedon[$lineid]=date("d M Y",$row['confirmedvalidon']);
} else {
$lastvalidatedby[$lineid]='';
$lastvalidatedon[$lineid]='';
}
$linkcode=$row['id'];
?>
fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$shipid=$row['id'];
$shipmethod[$shipid]=$row['company']." ".$row['service'];
}
$sql = "SELECT * FROM viamedquote_global_watchlist WHERE addedby = ? AND watchkey1 = ?";
//print "$sql";
$stmt = pdoquery($sql, array($vui, $orderid));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$usestk=$row['watchkey2'];
$watchitem[$usestk]=1;
}
$sql = "SELECT * FROM viamedquote_purchase_orders WHERE id = ?";
//print "$sql";
$stmt = pdoquery($sql, array($orderid));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$supplierweblink=$row['supplierweblink'];
$supplierweblinkmd5=$row['supplierweblinkmd5'];
}
$barcodessold = "
Barcodes Sales
";
$barcodessold .= "
Stock ref
Customer
CID
Customer Ref
Qty Sent
Delivery Note
Invoice Reference
Date Invoiced
";
$sql = "SELECT count(*) as tot , Stock_ref ,Dateout , Invoicenumber , id FROM Serialnumbers WHERE Porref = ? AND Invoicenumber <> '' GROUP BY Stock_ref , Invoicenumber
ORDER BY Dateout";
$stmt = pdoquery($sql, array($narrowpor));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$num = count($rows);
foreach ($rows as $row) {
$stkref=$row['Stock_ref'];
if (substr($row['Invoicenumber'],0,2)=='ID') {
$barcodessold .= "
";
$sql = "SELECT count(*) as tot , Stock_ref ,DateBookedin ,Bookedinby FROM Serialnumbers where Porref=? group by Stock_ref,Datebookedin order by Stock_ref,Datebookedin";
$stmt = pdoquery($sql, array($narrowpor));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$stkref=$row['Stock_ref'];
$barcodereceived .= "
";
if ($stkref != $laststk) {
if ( $laststk <>'' ) {
$barcodereceived .= "
";
print $msg;
print "";
$sql = "SELECT * FROM ISO_quality_manual_files where (description like ? or Porref=? or purchaseorderid=?) and archived='' order by id desc";
$stmt = pdoquery($sql, array("%$narrowpor%", $narrowpor, $orderid));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$num = count($rows);
if ($num>0 ) {
print "Uploaded Documents:
![](\"/intranet/images/email.png\"){kind=small}
Send Email to $kemailaddressesto