'') { $userid = $vui; } ?>
'0'"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $orderid = $row['orderid']; $dprndate = date("d M Y", $row['timestampraised']); $visitlognotes[$orderid] = isset ( $visitlognotes[$orderid] ) ? $visitlognotes[$orderid] : ''; $visitlognotes[$orderid] .= "
" . $dprndate . " - " . $row['status'] . " - " . $row['contact'] . "
" . $row['memo'] . "
"; } $useropts = ""; $sql = "SELECT id, username FROM pw WHERE active='1' ORDER BY username"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $useropts .= "\n"; } $isallowed = array(); $sql = "SELECT company_id FROM pw_companys WHERE vui = ?"; $stmt = pdoquery($sql, array($vui)); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $allowedhostid = $row['company_id']; $isallowed[$allowedhostid] = $allowedhostid; } $msg = "

Please Select Host Company

"; $msg .= ""; $sql = "SELECT global_companys.id as id, global_companys.fullname as fullname FROM global_companys, pw_companys WHERE pw_companys.company_id = global_companys.id AND pw_companys.vui = ? AND global_companys.active = '0' ORDER BY name"; $stmt = pdoquery($sql, array($vui)); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $hostid = $row['id']; if (isset($isallowed[$hostid]) && $isallowed[$hostid] <> '') { $msg .= ""; $msg .= ""; } } $msg .= "
" . $global_company_logo48[$hostid] . "

"; $hostcompanyid = safetext2(isset($_GET['hostcompanyid']) ? $_GET['hostcompanyid'] : ''); if ($hostcompanyid == '') { echo $msg; } print "
"; // CAN BE OPTIMISED to only search active quotes!! $sql = "SELECT id, quote, addedon FROM viamed_quotes_history WHERE daylink = ''"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $quote = $row['quote']; $qlist[$quote] = $quote; $datelink = date("dmy", $row['addedon']); $usql = "UPDATE viamed_quotes_history SET daylink = ? WHERE id = ?"; pdoquery($usql, array($datelink, $row['id'])); } $chasecount = array(); $sql = "SELECT count(*) as tot, quote FROM viamed_quotes_history GROUP BY quote, daylink"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $quote = $row['quote']; $chasecount[$quote] = $row['tot']; } // First lets See if any new quotes need adding to the list from the New system $quoteinviamed_quotes = array(); $sql = "SELECT quote FROM viamed_quotes"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $orderid = $row['quote']; $quoteinviamed_quotes[$orderid] = 1; } $accountname = array(); $accountac = array(); $sql = "SELECT ID, COMPANY, KEY5 FROM viamedquoteaddress"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $companyid = $row['ID']; $accountname[$companyid] = $row['COMPANY']; $accountac[$companyid] = $row['KEY5']; } // Determine the hosttopricelist currency $currency = array(); $prefix = array(); $sql = "SELECT global_companys_bankaccounts.companyid, global_companys_bankaccounts.pricelist, global_companys_bankaccounts.currency, global_companys.prefix FROM global_companys_bankaccounts, global_companys WHERE global_companys.id = global_companys_bankaccounts.companyid"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $hostid = $row['companyid']; $pricelist = $row['pricelist']; $hostpricelink = $hostid . "A" . $pricelist; $currency[$hostpricelink] = $row['currency']; $prefix[$hostid] = $row['prefix']; } $quotevalue = array(); $ordernotes = array(); $usecol = array(); $sql = "SELECT viamedquote_orders.id as orderid, viamedquote_orders.id as notes, viamedquote_orders_details.pricelist as pricelist, viamedquote_orders_details.unitprice as unitprice, viamedquote_orders_details.qty as qty, viamedquote_orders.hostcompany as hostcompany_id FROM viamedquote_orders, viamedquote_orders_details WHERE (viamedquote_orders.quote_proforma = '1' OR viamedquote_orders.quote_proforma = '2') AND viamedquote_orders.order_stage = '1' AND viamedquote_orders_details.orderid = viamedquote_orders.id GROUP BY viamedquote_orders_details.pricelist"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $quote = $row['orderid']; $ordernotes[$quote] = $row['notes']; $quotevalue[$quote] = (isset($quotevalue[$quote]) ? $quotevalue[$quote] : 0) + ($row['unitprice'] * $row['qty']); $hostid = $row['hostcompany_id']; $pricelist = $row['pricelist']; $hostpricelink = $hostid . "A" . $pricelist; $usecol[$quote] = ""; if (isset($currency[$hostpricelink]) && $currency[$hostpricelink] == 'EUR') { $usecol[$quote] = ""; } if (isset($currency[$hostpricelink]) && $currency[$hostpricelink] == 'USD') { $usecol[$quote] = ""; } } $quoteagreedby = array(); $quoteagreedon = array(); $sql = "SELECT id, quoteagreedby, quoteagreedon FROM viamedquote_orders WHERE quote_proforma = '1'"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $quote = $row['id']; $quoteagreedby[$quote] = getusername($row['quoteagreedby']); $quoteagreedon[$quote] = $row['quoteagreedon']; } $quoteslist = array(); $quotelink = array(); $quotehost = array(); $ordercompany = array(); $usequotedate = array(); $usename = array(); $usenameid = array(); $quotedisplay = array(); $quotedoc = array(); $accounts = array(); $sql = "SELECT id, quote_proforma, order_stage, hostcompany, company_id, notes, createdon, paperworkname, quoteagreedby, quoteagreedon FROM viamedquote_orders WHERE (quote_proforma = '1' OR quote_proforma = '2') AND order_stage = '1'"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $quote = $row['id']; $quoteslist[$quote] = $quote; $quotelink[$quote] = $quote; $hostid = $row['hostcompany']; $companyid = $row['company_id']; $quotehost[$quote] = $row['hostcompany']; $ordernotes[$quote] = $row['notes']; $accounts[$quote] = isset($accountac[$companyid]) ? $accountac[$companyid] : ''; $ordercompany[$quote] = $companyid; $accountname[$quote] = isset($accountname[$companyid]) ? $accountname[$companyid] : ''; $usequotedate[$quote] = date("d M Y", $row['createdon']); $usename[$quote] = getusername($row['paperworkname']); $usenameid[$quote] = $row['paperworkname']; $quoteagreedby[$quote] = getusername($row['quoteagreedby']); $quoteagreedon[$quote] = $row['quoteagreedon']; if ($row['quote_proforma'] == 1) { $quotedisplay[$quote] = "Q" . $prefix[$hostid] . $quote . "(" . (isset($quotevalue[$quote]) ? $quotevalue[$quote] : 0) . ")"; $quotedoc[$quote] = "Q" . $prefix[$hostid] . $quote; } else { $quotedisplay[$quote] = "M" . $prefix[$hostid] . $quote . "(" . (isset($quotevalue[$quote]) ? $quotevalue[$quote] : 0) . ")"; $quotedoc[$quote] = "M" . $prefix[$hostid] . $quote; } if (!isset($quoteinviamed_quotes[$quote]) || $quoteinviamed_quotes[$quote] <> 1) { $isql = "INSERT INTO viamed_quotes (quote) VALUES (?)"; pdoquery($isql, array($quote)); } } $pricesymbol = array(); $sql = "SELECT companyid, pricelist, bankcurrsymbol FROM global_companys_bankaccounts"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $hostid = $row['companyid']; $pricelist = $row['pricelist']; $pricelink = $hostid . "SSS" . $pricelist; $pricesymbol[$pricelink] = $row['bankcurrsymbol']; } // Can now go pick up the viamed_quotes data including any new entries $quotestatus = array(); $quotechance = array(); $quoteby = array(); $quoteon = array(); $quoteoncheck = array(); $statusrespuser = array(); $statusrespuserid = array(); $quotenotes = array(); $logged = array(); $sql = "SELECT quote, status, chance, updatedby, updatedon, responsibleuser, notes FROM viamed_quotes"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $quote = $row['quote']; $quotestatus[$quote] = $row['status']; $quotechance[$quote] = $row['chance']; // viamed_quotes has no addedby column; use updatedby only $quoteby[$quote] = ($row['updatedby'] != 0) ? getusername($row['updatedby']) : ''; if ($row['updatedon'] > 0) { $quoteon[$quote] = date("d M Y", $row['updatedon']); $quoteoncheck[$quote] = $row['updatedon'] + (86400 * 25); } else { $quoteon[$quote] = ''; } $statusrespuser[$quote] = getusername($row['responsibleuser']); $statusrespuserid[$quote] = $row['responsibleuser']; $quotenotes[$quote] = $row['notes']; $logged[$quote] = 1; } // Just pick up Address Details FROM Opera Address $creditlimit = array(); $sql = "SELECT KEY5, Opera_Creditlimit FROM viamedquoteaddress WHERE hideme = ''"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $useaccount = $row['KEY5']; $creditlimit[$useaccount] = $row['Opera_Creditlimit']; } $accountstop = array(); $sql = "SELECT KEY5 FROM viamedquoteaddress WHERE stoponaccount = '1'"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $useaccount = $row['KEY5']; $accountstop[$useaccount] = 'Yes'; } $quoteopts = ""; $statusdescription = array(); $sql = "SELECT id, description FROM viamed_quotes_status ORDER BY description"; $stmt = pdoquery($sql, array()); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $qoptid = $row['id']; $statusdescription[$qoptid] = ucwords($row['description']); $quoteopts .= ""; } $chanceopts = " "; $usercode = ''; if ($userid <> '') { $usercode = getusername($userid) . "'s "; } print "

" . $usercode . " Outstanding Quotes and proforma's

"; print "

"; print "

"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print "
KEY
GBP
Euros
Dollars
Account on Stop

"; print ""; foreach ($quoteslist as $quote) { $line = ''; $hostid = $quotehost[$quote]; if (isset($isallowed[$hostid]) && $isallowed[$hostid] <> '' && ($hostcompanyid == '' || $hostcompanyid == $hostid)) { $col = isset($usecol[$quote]) ? $usecol[$quote] : ''; $ac = $accounts[$quote]; if (isset($accountstop[$ac]) && $accountstop[$ac] <> '') { $col = ""; } if ($col == '') { $col = ""; } $qoptid = isset($quotestatus[$quote]) ? $quotestatus[$quote] : ''; if ($userid == '' || $userid == $statusrespuserid[$quote]) { $line .= $col; $line .= ""; $line .= ""; $line .= ""; $line .= ""; $line .= ""; $line .= ""; $line .= ""; $line .= ""; $line .= ""; if ($filter == '' || $iscross == 1) { print $line; } } } } print "
Chased25D+ Quote / Proforma Users / Status
/ Notes		Status Update byStatus onApprovedUpdate
"; $line .= (isset($chasecount[$quote]) ? $chasecount[$quote] : '') . ""; $udate2 = $usequotedate[$quote]; try { $year = substr($udate2, 0, 4); $month = substr($udate2, 5, 2); $day = substr($udate2, 8, 2); $expdate = mktime(1, 1, 1, $month + 0, $day + 25, $year + 0); $expiredate = date("d/M/Y", $expdate); if (isset($quoteoncheck[$quote]) && $quoteoncheck[$quote] > 0) { $expiredate2 = "\nNext Check Date: " . date("d/M/Y", $quoteoncheck[$quote]); } else { $expiredate2 = ""; } $iscross = 0; if ($expdate < $nowis && (!isset($quoteoncheck[$quote]) || $quoteoncheck[$quote] == '' || $quoteoncheck[$quote] < $nowis)) { $line .= ""; $iscross = 1; } else { $line .= ""; } } catch (Exception $e) { $line .= $e; } if (isset($statusrespuser[$quote]) && $statusrespuser[$quote] == 'Other') { $statusrespuser[$quote] = 'Office'; } $line .= ""; if (isset($isrep[$quote]) && $isrep[$quote] == 1) { $line .= ""; } $line .= "

"; $line .= "
"; $line .= $global_company_logo24[$hostid] . $global_company_name[$hostid]; $line .= " Ref: "; $line .= " " . neworderlinks($x, $quote, $float, $size) . "" . operadoclinks($x, $quotedoc[$quote], '') . " " . $quotedisplay[$quote] . "
Entered Date  " . $usequotedate[$quote] . "  
Entered By" . $usename[$quote] . "
Account   " . $ac . "  
Name "; if ($ordercompany[$quote] > 0) { $line .= linkcrm($x, $ordercompany[$quote], '') . "CID" . $ordercompany[$quote] . " "; } $line .= " " . $accountname[$quote] . "
"; if ($statusrespuserid[$quote] == 0 && $usenameid[$quote] != 0) { $statusrespuserid[$quote] = $usenameid[$quote]; $statusrespuser[$quote] = $usename[$quote]; } $line .= ""; $line .= ""; $line .= ""; $prnnotes = str_replace("\n", "
", isset($quotenotes[$quote]) ? $quotenotes[$quote] : ''); $line .= "
User"; $line .= ""; $line .= "
Status"; $line .= "
Chance"; $line .= "
Notes"; if (isset($visitlognotes[$quote]) && $visitlognotes[$quote]) { $line .= $visitlognotes[$quote]; } $line .= "Order Notes: " . (isset($ordernotes[$quote]) ? $ordernotes[$quote] : '') . "

Quote Notes " . $prnnotes . "
Add Quote Notes:
"; if (isset($quoteby[$quote]) && $quoteby[$quote] == 'Other') { $line .= " "; } else { $line .= isset($quoteby[$quote]) ? $quoteby[$quote] : ''; } $line .= "" . (isset($quoteon[$quote]) ? $quoteon[$quote] : '') . ""; if (isset($quoteagreedon[$quote]) && $quoteagreedon[$quote] > 0) { $ddate = date("d M Y", $quoteagreedon[$quote]); $line .= (isset($quoteagreedby[$quote]) ? $quoteagreedby[$quote] : '') . " " . $ddate; } $line .= "
 
"; if ($userid == '') { ksort($stockquotelist); print "

Stock Items in Quotes and Proforma's

"; foreach ($stockquotelist as $stkref => $count) { print ""; print ""; } print "
Stock Reference#QuotesTotal Qty in QuotesMore Information
" . $stkref . " " . $count . "" . (isset($qtystockinquotes[$stkref]) ? $qtystockinquotes[$stkref] : '') . "
"; } ?>