fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $opera = $row['KEY5']; } ?> ","
","
"); include ("showaddress.php"); $usedesc="$company $contact"; $iopera = "I" . substr($opera, 1); $oopera = "0" . substr($opera, 1); $currentnotes = ''; $currentoption = ''; $checknotes = ''; $checkby = ''; $checkon = ''; $mainconotes = ''; $mainconotesby = ''; $mainconoteson = ''; $optdes = array(); $memois = array(); $memoby = array(); $memoon = array(); if ($opera=='') { print "Error Account requires an Opera Field
"; } else { $sql = "SELECT * FROM viamed_shipping_options GROUP BY company, service"; $stmt = pdoquery($sql); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $optid = $row['id']; $optdes[$optid] = $row['company'] . " " . $row['service']; } $sql = "SELECT * FROM viamed_shipping_options_account WHERE (opera = ? OR opera = ?)"; $stmt = pdoquery($sql, array($oopera, $iopera)); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $currentnotes = $row['notes']; $currentoption = $row['optionid']; } $sql = "SELECT * FROM viamedquoteaddress WHERE ID = ?"; $stmt = pdoquery($sql, array($companyid)); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $checknotes = $row['checkingnotes']; $checkby = $row['checkingnotesby']; $checkon = $row['checkingnoteson']; $mainconotes = $row['mainconotes']; $mainconotesby = $row['mainconotesby']; $mainconoteson = $row['mainconoteson']; } $currentnotes=str_replace("
","\n",$currentnotes); $currentnotes=str_replace("
","\n",$currentnotes); $checknotes=str_replace("
","\n",$checknotes); $checknotes=str_replace("
","\n",$checknotes); $mainconotes=str_replace("
","\n",$mainconotes); $mainconotes=str_replace("
","\n",$mainconotes); ?>

Memos


Notes to Picking Department as goods are picked

Shipping Option:"; ?>
fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $memoid = $row['memotype']; $memois[$memoid] = str_replace("
", "\n", $row['memo']); $memoby[$memoid] = getusername($row['addedby']); $memoon[$memoid] = date("d M Y", $row['addedon']); } ?>
Notes to Checking Screen as Orders are checked
'') { $prndate=date("d M Y",$checkon); print getusername($checkby)." On ".$prndate; } ?>
General Contact Notes - show on main company page

Add Order Screen

Notes to Goods in Pre Labeling

Notes to Purchasing Stock ordering Screens if applicable

Memo For Purchase Orders / Freight Instructions to Supplier - Adds to PaperWork