fetch_assoc()) { $hid = $row['company_id']; $allowtoview[$hid] = 1; } } $submenu = ""; $x = getsecurity(); if (isset($_POST['hostcompanyid']) && $_POST['hostcompanyid'] == 0) { $_POST['hostcompanyid'] = ''; } if (isset($_GET['hostcompanyid']) && $_GET['hostcompanyid'] == 0) { $_GET['hostcompanyid'] = ''; } $tablewidth = '75%'; // DATABASE LOOK UPS $stkref = safetext2(trim(isset($_POST['stkref']) ? $_POST['stkref'] : '')); $companyid = safetext2(isset($_POST['companyid']) ? $_POST['companyid'] : ''); $usedescription = safetext2(isset($_POST['description']) ? $_POST['description'] : ''); $showhidden = isset($_POST['showhidden']) ? $_POST['showhidden'] : ''; $usehostid = safetext2(isset($_POST['hostcompanyid']) ? $_POST['hostcompanyid'] : ''); // Code confirmed for PHP 5.6 and 8.x compatibility if ($stkref != '') { //print "Posted Redirect:"; $relink = "stock_search.php" . $x . "&stkref=$stkref&companyid=$companyid&description=$usedescription&showhidden=$showhidden&hostcompanyid=$usehostid&directlink=2"; //print "Test"; print ' '; } $directlink = 0; if ($stkref == '') { $stkref = trim(isset($_GET['stkref']) ? $_GET['stkref'] : ''); $companyid = isset($_GET['companyid']) ? $_GET['companyid'] : ''; $usedescription = safetext2(isset($_GET['description']) ? $_GET['description'] : ''); $directlink = safetext2(isset($_GET['directlink']) ? $_GET['directlink'] : ''); $showhidden = isset($_GET['showhidden']) ? $_GET['showhidden'] : ''; if ($directlink == 2) { $directlink = ''; } else { $directlink = 1; } $usehostid = safetext2(isset($_GET['hostcompanyid']) ? $_GET['hostcompanyid'] : ''); } if ($showhidden != '') { $showhiddencheck = "CHECKED"; } $prncompanyid = substr($companyid, 1); if ($stkref == '') { $stkref = 'Search'; $directlink = 0; } if ($usedescription == '') { $usedescription = 'opera'; } ?>

Stock Search

fetch_assoc()) { $stkref4 = $row['stock_ref']; $hasuniquie[$stkref4] = 1; } } $r2 = "SELECT * FROM ISO_quality_manual_files WHERE archived='' AND exp_date < '$nowis' AND exp_date_ignore='0' AND exp_date > '1000' AND type <> 'PRICE' ORDER BY description"; $result2 = sqlquery($r2); // Replaces deprecated getquery() $docout = array(); // initialize to avoid undefined warnings if ($result2) { while ($row2 = $result2->fetch_assoc()) { $udocid = $row2['docid']; $docout[$udocid] = -1; } } $s = "SELECT * FROM viamed_xref GROUP BY stock_ref"; $result = sqlquery($s); // Replaces deprecated getquery() $onxref = array(); // initialize before use if ($result) { while ($row = $result->fetch_assoc()) { $xrefstk = $row['stock_ref']; $onxref[$xrefstk] = 1; } } if ($usedescription == "opera") { //print "Using $usedescription
"; $s = "SELECT * FROM stocklist_tarriffs"; $result = sqlquery($s); // Replaces deprecated getquery() $uselistdesc = array(); // initialize to avoid undefined warnings if ($result) { while ($row = $result->fetch_assoc()) { $usestk = $row['stock_ref']; $uselistdesc[$usestk] = $row['OperaDescription']; } } } if ($usedescription == "label") { //print "Using $usedescription
"; $s = "SELECT * FROM stocklist_tarriffs"; $result = sqlquery($s); // Replaces deprecated getquery() $uselistdesc = array(); // initialize to avoid undefined warnings if ($result) { while ($row = $result->fetch_assoc()) { $usestk = $row['stock_ref']; $uselistdesc[$usestk] = $row['label_description']; } } } if ($usedescription == "pricelist") { //print "Using $usedescription
"; $s = "SELECT * FROM stocklist_tarriffs"; $result = sqlquery($s); // Replaces deprecated getquery() $uselistdesc = array(); // initialize to avoid undefined warnings if ($result) { while ($row = $result->fetch_assoc()) { $usestk = $row['stock_ref']; $uselistdesc[$usestk] = str_replace("\n", "
", $row['pricedesc']); } } } if ($usedescription == "ghxdescription") { //print "Using $usedescription
"; $s = "SELECT * FROM stocklist_tarriffs"; $result = sqlquery($s); // Replaces deprecated getquery() $uselistdesc = array(); // initialize to avoid undefined warnings if ($result) { while ($row = $result->fetch_assoc()) { $usestk = $row['stock_ref']; $uselistdesc[$usestk] = str_replace("\n", "
", $row['GHX_description']); } } } if ( "$usedescription" == "ghxextendeddescription") { //print "Using $usedescription
"; $s="SELECT * FROM stocklist_tarriffs"; $result=sqlquery($s); while ($row = $result->fetch_assoc()) { $usestk=$row[stock_ref]; $uselistdesc[$usestk]=str_replace("\n","
",$row[GHX_description_extend]); } } if ($usedescription == "ghxextendeddescription") { //print "Using $usedescription
"; $s = "SELECT * FROM stocklist_tarriffs"; $result = sqlquery($s); // Replaces deprecated getquery() $uselistdesc = array(); // initialize to avoid undefined warnings if ($result) { while ($row = $result->fetch_assoc()) { $usestk = $row['stock_ref']; $uselistdesc[$usestk] = str_replace("\n", "
", $row['GHX_description_extend']); } } } $xt1search = "(1=0 "; $s = "SELECT * FROM viamed_customer_stock_references WHERE customer_ref LIKE '%$stkref%' AND customer_ref <> '' GROUP BY customer_ref, stock_ref ORDER BY stock_ref"; $result = sqlquery($s); // Replaces deprecated getquery() if ($result) { while ($row = $result->fetch_assoc()) { $usestk = $row['stock_ref']; $xt1search .= " OR stock_ref = '" . $row['stock_ref'] . "'"; } } $xt1search .= " )"; $stseextra = "(1=2 "; $memoddate = array(); // Store memo update dates by hostcompany and stockref // Build SQL statement $s = "SELECT stocklist_tarriffs_fieldhistory.stockref, stocklist_tarriffs_fieldhistory.updatedon, stocklist_tarriffs_fieldhistory.updatedby, stocklist_tarriffs_fieldhistory.hostcompanyid FROM stocklist_tarriffs, stocklist_tarriffs_fieldhistory WHERE ($xt1search OR stocklist_tarriffs.stock_ref LIKE '%$stkref%' OR stocklist_tarriffs.OperaDescription LIKE '%$stkref%' OR stocklist_tarriffs.DescriptionExtra LIKE '%$stkref%' OR stocklist_tarriffs.paperworkdescription LIKE '%$stkref%' OR stocklist_tarriffs.ean13 LIKE '%$stkref%' OR stocklist_tarriffs.pricedesc LIKE '%$stkref%' OR stocklist_tarriffs.label_description LIKE '%$stkref%') AND stocklist_tarriffs.stock_ref <> '' AND stocklist_tarriffs_fieldhistory.stockref = stocklist_tarriffs.stock_ref AND stocklist_tarriffs_fieldhistory.hostcompanyid = stocklist_tarriffs.hostcompany_id AND (stocklist_tarriffs_fieldhistory.fieldname = 'tempnote' OR stocklist_tarriffs_fieldhistory.fieldname = 'permnote') ORDER BY stocklist_tarriffs_fieldhistory.id"; // Run SQL using mysqli (preferred in PHP 5.6+ and 8.x) $result = sqlquery($s); // Replaces deprecated getquery() if ($result) { while ($row = $result->fetch_assoc()) { $usestk = $row['stockref']; $hostid = $row['hostcompanyid']; $hostklink = $hostid . "S" . $usestk; $memoddate[$hostklink] = date("d M Y", $row['updatedon']) . " By " . getusername($row['updatedby']); } } $hostsearch = ""; if ($usehostid != '') { $hostsearch = " AND hostcompany_id='$usehostid'"; } $s = "SELECT stockref FROM feedbacksurveymonkey GROUP BY stockref"; //print "$s
"; $result = sqlquery($s); // Replaces deprecated getquery() $hasmonkeyfeedback = array(); // initialize to avoid undefined warnings if ($result) { while ($row = $result->fetch_assoc()) { $xstk = safetext2(trim($row['stockref'])); $hasmonkeyfeedback[$xstk] = "e"; } } if ($showhidden=='') { // LETS SEE HOE MANY WE ARE HIDING $s="SELECT * FROM stocklist_tarriffs where ($xt1search or stock_ref LIKE '%$stkref%' or OperaDescription LIKE '%$stkref%' or extrasearch LIKE '%$stkref%' or DescriptionExtra LIKE '%$stkref%' or paperworkdescription LIKE '%$stkref%' or ean13 LIKE '%$stkref%' or pricedesc LIKE '%$stkref%' or label_description LIKE '%$stkref%') and stock_ref<>'' and hidefromsystemreports='Yes' $hostsearch order by stock_ref , hostcompany_id"; $result = sqlquery($s); // Replaces deprecated getquery() // Get number of rows $hiddennum = 0; // Initialize to avoid undefined warning if ($result) { $hiddennum = $result->num_rows; } // ACTUAL END SEARCH FOR REFERENCES $s="SELECT * FROM stocklist_tarriffs where ($xt1search or stock_ref LIKE '%$stkref%' or OperaDescription LIKE '%$stkref%' or DescriptionExtra LIKE '%$stkref%' or paperworkdescription LIKE '%$stkref%' or ean13 LIKE '%$stkref%' or extrasearch LIKE '%$stkref%' or pricedesc LIKE '%$stkref%' or label_description LIKE '%$stkref%') and stock_ref<>'' and (hidefromsystemreports='0' or hidefromsystemreports='No') $hostsearch order by stock_ref , hostcompany_id"; } else { $s="SELECT * FROM stocklist_tarriffs where ($xt1search or stock_ref LIKE '%$stkref%' or OperaDescription LIKE '%$stkref%' or DescriptionExtra LIKE '%$stkref%' or paperworkdescription LIKE '%$stkref%' or ean13 LIKE '%$stkref%' or pricedesc LIKE '%$stkref%' or label_description LIKE '%$stkref%') and stock_ref<>'' $hostsearch order by stock_ref , hostcompany_id"; } $result = sqlquery($s); // Replaces deprecated getquery() $num=mysqli_num_rows($result); $num = 0; $ean13 = array(); $lbldesc = array(); $pricedesc = array(); $tempnotice = array(); $permnotice = array(); $cedoc = array(); $stklisting = array(); $hostlist = array(); $isactive = array(); $searchtext = array(); $sellingp = array(); $superceedlist = array(); $operamemo = array(); $opera_description = array(); $priceldesc = array(); $ghxdesc = array(); $ghxedesc = array(); $paperworkdescription = array(); $superceedtarrif = array(); $whilestockstockslast = array(); if ($result) { $num = $result->num_rows; while ($row = $result->fetch_assoc()) { $usestk = $row['stock_ref']; $ean13[$usestk] = isset ( $ean13[$usestk] ) ? $ean13[$usestk] : '' ; $ean13[$usestk] .= $row['ean13']; if ($row['label_description'] == '') { $lbldesc[$usestk] = ''; } else { $lbldesc[$usestk] = $row['label_description']; $uselistdesc[$usestk] = $lbldesc[$usestk]; } if ($row['pricedesc'] == '') { $pricedesc[$usestk] = 'No Pricelist Description'; } else { $pricedesc[$usestk] = str_replace("\n", "
", $row['pricedesc']); $uselistdesc[$usestk] = $pricedesc[$usestk]; } $hostid = $row['hostcompany_id']; $hostklink = $hostid . "S" . $usestk; $lbldesc[$hostklink] = $row['label_description']; $tempnotice[$hostklink] = $row['tempnote']; $permnotice[$hostklink] = str_replace("\n", " ", $row['permnote']); $permnotice[$hostklink] .= $row['exclusivetomemo']; $udocid = $row['ce_docid']; $cedoc[$usestk] = isset($docout[$udocid]) ? $docout[$udocid] : ''; if ($cedoc[$usestk] == -1) { $tempnotice[$usestk] = "We have a Temporary Issue with the EC Certification unable to send out this product until we receive the new certificate
" . $tempnotice[$usestk]; } $stkref2 = $row['stock_ref']; $stklisting[$stkref2] = $stkref2; $hostlist[$hostid] = $hostid; $hostklink = $hostid . "S" . $stkref2; $isactive[$hostklink] = 1; $searchtext[$stkref2] = "- - -
- - -"; $sellingp[$stkref2] = "- - -"; $searchtext[$hostklink] = $row['DescriptionExtra']; $superceedlist[$stkref2] = $row['SUPERSEDED']; $stseextra .= "OR STOCK_REFE='" . $stkref2 . "' "; $operamemo[$stkref2] = $row['operamemo']; $opera_description[$hostklink] = $row['OperaDescription']; $priceldesc[$hostklink] = $row['pricedesc']; $ghxdesc[$hostklink] = $row['GHX_description']; $ghxedesc[$hostklink] = $row['GHX_description_extend']; $paperworkdescription[$hostklink] = str_replace("\n", "
", $row['paperworkdescription']); $superlink = $row['hostcompany_id'] . "S" . $stkref2; $superceedtarrif[$superlink] = $row['SUPERSEDED']; $whilestockstockslast[$hostklink] = $row['whilestockslast']; } } $stseextra .= ") "; $s = "SELECT * FROM specialprices WHERE Pricelist='0001' AND hostcompanyid='1'"; $result = sqlquery($s); // Replaces deprecated getquery() $singleprices = array(); // initialize before use if ($result) { while ($row = $result->fetch_assoc()) { $hostcompanyid = $row['hostcompanyid']; $stkref2 = $row['Stock_ref']; $superlink = $hostcompanyid . "S" . $stkref2; $singleprices[$superlink] = number_format(($row['Price'] / pow(10, (int)$row['D'])), 2, '.', ','); } } $thirtydaysofseconds = 86400 * 30; $date30dayback = $nowis - $thirtydaysofseconds; $s = "SELECT * FROM specialprices_history WHERE Pricelist='0001' AND hostcompanyid='1' AND datereplaced > '$date30dayback' ORDER BY id"; //print "$s"; $result = sqlquery($s); // Replaces deprecated getquery() $singlepricesold = array(); // initialize before use if ($result) { while ($row = $result->fetch_assoc()) { $hostcompanyid = $row['hostcompanyid']; $stkref2 = $row['Stock_ref']; $superlink = $hostcompanyid . "S" . $stkref2; $singlepricesold[$superlink] = "/ £ " . number_format(($row['Price'] / pow(10, $row['D'])), 2, '.', ','); } } // Retrieve quantities on quotes and proformas $proformaqty = array(); $quoteqty = array(); $orderqty = array(); $s = "SELECT viamedquote_orders.quote_proforma, viamedquote_orders_details.stockref, SUM(viamedquote_orders_details.qty - viamedquote_orders_details.qty_shipped) as totalqty FROM viamedquote_orders, viamedquote_orders_details WHERE viamedquote_orders.signofascompleteon='0' AND viamedquote_orders.quote_proforma != '0' AND viamedquote_orders.order_stage > '0' AND viamedquote_orders.order_stage < '3' AND viamedquote_orders.id = viamedquote_orders_details.orderid AND viamedquote_orders_details.qty <> viamedquote_orders_details.qty_shipped GROUP BY viamedquote_orders.quote_proforma, viamedquote_orders_details.stockref"; $result = sqlquery($s); while ($row = $result->fetch_assoc()) { $stk = $row['stockref']; $qty = $row['totalqty']; if ($row['quote_proforma'] == '1') { $quoteqty[$stk] = isset($quoteqty[$stk]) ? $quoteqty[$stk] + $qty : $qty; } elseif ($row['quote_proforma'] == '2') { $proformaqty[$stk] = isset($proformaqty[$stk]) ? $proformaqty[$stk] + $qty : $qty; } } // For orders (backorders) $s = "SELECT viamedquote_orders_details.stockref, SUM(viamedquote_orders_details.qty - viamedquote_orders_details.qty_shipped) as totalqty FROM viamedquote_orders, viamedquote_orders_details WHERE viamedquote_orders.signofascompleteon='0' AND viamedquote_orders.quote_proforma = '0' AND viamedquote_orders.order_stage > '0' AND viamedquote_orders.order_stage < '3' AND viamedquote_orders.id = viamedquote_orders_details.orderid AND viamedquote_orders_details.qty <> viamedquote_orders_details.qty_shipped GROUP BY viamedquote_orders_details.stockref"; $result = sqlquery($s); while ($row = $result->fetch_assoc()) { $stk = $row['stockref']; $qty = $row['totalqty']; $orderqty[$stk] = isset($orderqty[$stk]) ? $orderqty[$stk] + $qty : $qty; } // Code confirmed for PHP 5.6 and 8.x compatibility // do a line by line search ?> 0) { ?>
Search:
" onkeyup="search()" autocomplete="off">
Display Description Host Company
Include hidden results >
"; foreach ($stklisting as $stkref2 => $stkref2vaule) { foreach ($hostlist as $hostid => $vhost){ $hostklink=$hostid."S".$stkref2; $isactive[$hostklink] = isset($isactive[$hostklink]) ? $isactive[$hostklink] : ''; $allowtoview[$hostid] = isset($allowtoview[$hostid]) ? $allowtoview[$hostid] : ''; if ($isactive[$hostklink]==1 and $allowtoview[$hostid]==1) { $hostcompanyid=$hostid; $superlink=$hostcompanyid."S".$stkref2; $supper= $superceedtarrif[$superlink]; $repmsg=""; $msgcolor="00aacc"; if ($supper<>"" and $supper<>'- - -') { $repmsg=""; $msgcolor="dddd00"; } if ($supper=="9919999" ) { $supper2=$supper; $repmsg=""; $msgcolor="dd0000"; } if ($supper=="9919998" ) { $repmsg="Unreleased:"; $msgcolor="dddd00"; } if ($supper=="9919997" ) { $repmsg="RELEASE SCHEDULED:"; $msgcolor="dddd00"; } if ($supper=="9919996" ) { $repmsg="NON-STOCK BUT AVAILABLE:"; $msgcolor="dddd00"; } if ($supper=="9919995" ) { $repmsg="ONLY FOR SPECIFIC OEM CUSTOMER:"; $msgcolor="dddd00"; } if ($supper=="9919994" ) { $repmsg="EBay Only:"; $msgcolor="8B008B"; } if ($supper=="MEMO" ) { $repmsg="SEE MEMO"; $msgcolor="8B008B"; } print ""; print ""; // Description Type print ""; $searchtext[$hostklink]= isset($searchtext[$hostklink]) ? $searchtext[$hostklink]: ''; $ean13[$stkref2]= isset($ean13[$stkref2]) ? $ean13[$stkref2]: ''; print ""; $orderqty_val = isset($orderqty[$stkref2]) ? $orderqty[$stkref2] : 0; $quoteqty_val = isset($quoteqty[$stkref2]) ? $quoteqty[$stkref2] : 0; $proformaqty_val = isset($proformaqty[$stkref2]) ? $proformaqty[$stkref2] : 0; $outstanding = ''; if ($orderqty_val > 0) $outstanding .= $orderqty_val . ' Orders
'; if ($proformaqty_val > 0) $outstanding .= $proformaqty_val . ' Proformas
'; if ($quoteqty_val > 0) $outstanding .= $quoteqty_val . ' Quotes
'; print ""; print "\n"; $tempnotice[$hostklink] = isset($tempnotice[$hostklink]) ? $tempnotice[$hostklink]: ''; $memoddate[$hostklink] = isset($memoddate[$hostklink]) ? $memoddate[$hostklink]: ''; if ($tempnotice[$hostklink]<>'' ) { print ""; } print ""; // end is active loop } // End of host loop } // End of $stklisting } // End of null listing check } // End of Try Fail Check } catch (Exception $e) { print "Nothing found!"; } ?>
OptionsStock Reference".ucwords($usedescription)." DescriptionSearchGtin/EanUK End UserComment/NoteOutstanding
"; if ($global_access_updatestock[$hostcompanyid]==1 ) { ?> &hostcompanyid=" title="Edit Extra Information"> "; } //$dispcomp=ucwords($row['companyid']); print "".$global_company_logo24[$hostcompanyid].""; ?> ','')" src="../../images/stocklevels.jpg" border=0 width=24 height=24 title=" Stock Levels"> ','')" src="../../images/prices.jpg" border=0 width=24 height=24 title=" Prices"> ','')" src="../../images/infom.png" border=0 width=24 height=24 title=" Extra Information"> ','')" src="../../images/faq.jpg" border=0 width=24 height=24 title=" Frequently asked questions"> ','')" src="../../images/xref.png" border=0 width=24 height=24 title=" Cross Reference Data to competitors"> ','')" src="../../images/relate.jpg" border=0 width=24 height=24 title=" Similar / related stock"> ','')" src="../../images/warranty_bl.jpg" border=0 width=24 height=24 title=" Repair Statistics"> ','')" src="../../images/warranty_sup.jpg" border=0 width=24 height=24 title=" Supplier Returns"> ','')" src="../../images/manufacture.jpg" border=0 width=24 height=24 title=" Suppliers"> ','','')" src="../../images/barcode1.jpg" border=0 width=24 height=24 title=" Barcodes Generated"> ','')" src="../../images/is_dist22.png" border=0 width=24 height=24 title=" Distributors"> ','')" src="../../images/menu/scales.png" border=0 width=24 height=24 title=" Weights and Dimensions"> 0) { ?> ','')" src="../../images/photo.png" border=0 width=24 height=24 title=" Show Photos"> ','')" src="../../images/photo.png" border=0 width=24 height=24 title=" No Photos"> ','')" src="../../images/menu/ranked.png" border=0 width=24 height=24 title=" Ranked Sales / best customers"> ','')" src="../../images/menu/x_sm.jpg" border=0 width=24 height=24 title=" HeaderBar"> ','','')" src="../../images/menu/add_issue.png" border=0 width=24 height=24 title=" "> '' or $operamemo[$stkref2]<>'') { ?> ','')" src="../../images/redm.jpg" border=0 width=24 height=24 title=" "> ','')" src="../../images/menu/unique.png" border=0 width=24 height=24 title=" Show Unique QA Field Answers"> ','','')" border=0 width=24 height=24 title=" Sales"> ','','')" border=0 width=24 height=24 title=" Unique Customers"> '') { ?> ','')" border=0 width=24 height=24 title=" Survey Feedback"> 7) { ?> ','')" border=0 width=24 height=24 title=" Overview"> &stkref="> Warehouse Request &stkref=&hostcompanyid=&action=refresh"> $stkref2"; print ""; if ($usedescription=='opera') { print "$opera_description[$hostklink] "; } if ($usedescription=='label') { print "$lbldesc[$hostklink]"; } if ($usedescription=='paperworkdescription') { print "$paperworkdescription[$hostklink]"; } if ($usedescription=='pricelist') { print "$priceldesc[$hostklink]"; } if ($usedescription=='ghxdescription') { print "$ghxdesc[$hostklink]"; } if ($usedescription=='ghxextendeddescription') { print "$ghxedesc[$hostklink]"; } print "$searchtext[$hostklink]$ean13[$stkref2]"; $singlepricesold[$superlink]= isset($singlepricesold[$superlink]) ? $singlepricesold[$superlink]: ''; $singleprices[$superlink]= isset($singleprices[$superlink]) ? $singleprices[$superlink]: ''; if ($singlepricesold[$superlink]=='') { print "£ $singleprices[$superlink]"; } else { print "Pending Change"; } print ""; $whilestockstockslast[$hostklink]= isset($whilestockstockslast[$hostklink]) ? $whilestockstockslast[$hostklink]: ''; if ($whilestockstockslast[$hostklink]=='Yes') { print "AVAILABLE While Stocks Last
"; } $repmsg = isset($repmsg) ? $repmsg: ''; if ( $repmsg <>'' ) { if ($supper=='MEMO') { print ""; } else { print $repmsg."$supper"; } } print "		"; $ustkref= isset($ustkref) ? $ustkref: ''; $lastrecieved[$ustkref] = isset($lastrecieved[$ustkref]) ? $lastrecieved[$ustkref]: ''; if ($lastrecieved[$ustkref]<>'') { print "$lastrecieved[$stkref2]"; } print "$outstanding
$stkref2 Memo (Memos updated $memoddate[$hostklink])
$tempnotice[$hostklink]