fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $ustk=$row['stock_ref']; $stkdesc[$ustk]=$row['OperaDescription']; if ($stkdesc[$ustk]=='') { $stkdesc[$ustk]=$row['pricedesc']; } } $sql = "SELECT * FROM viamed_customer_stock_references_groupcodes WHERE hostcompanyid = ? AND companyid = ? AND active = '0' ORDER BY groupcode"; $stmt = pdoquery($sql, array($hostcompanyid, $companyid)); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $groupcode=$row['groupcode']; $groupcodelist[$groupcode]=$row['groupcode']; } $sql = "SELECT * FROM viamed_customer_stock_references_groupcodes_links , viamed_customer_stock_references_groupcodes WHERE viamed_customer_stock_references_groupcodes_links.groupcode = viamed_customer_stock_references_groupcodes.groupcode AND viamed_customer_stock_references_groupcodes.hostcompanyid = ? AND viamed_customer_stock_references_groupcodes.companyid = ?"; $stmt = pdoquery($sql, array($hostcompanyid, $companyid)); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $stkref=$row['stockref']; $groupcode=$row['groupcode']; $link=$stkref."AXA".$groupcode; $tagged[$link]=1; } print "

Tag Stock References $filter "; print "

"; print "
"; $headertag=""; foreach ($groupcodelist as $groupcode) { if ($filter=='' || $filter==$groupcode) { $headertag .= ""; } } print "$headertag"; // Second header row with FeedBack buttons under each groupcode $feedbackheader = ""; foreach ($groupcodelist as $groupcode) { if ($filter=='' || $filter==$groupcode) { $feedbackheader .= ""; } } print $feedbackheader.""; // Third header row with Raw Report links under each groupcode $rawheader = ""; foreach ($groupcodelist as $groupcode) { if ($filter=='' || $filter==$groupcode) { $rawheader .= ""; } } print $rawheader.""; $count=0; $sql = "SELECT * FROM viamed_customer_stock_references WHERE hostcompanyid = ? AND companyid = ? AND status > '0' ORDER BY stock_ref"; $stmt = pdoquery($sql, array($hostcompanyid, $companyid)); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { $ustk=$row['stock_ref']; if (isset($stkdesc[$ustk]) && $stkdesc[$ustk] && $filter){ $pos=strpos($stkdesc[$ustk],$filter,0); } else { $pos=0; } if ($count > 10 ) { $count=0; print "$headertag"; print $feedbackheader.""; print $rawheader.""; } $showline=""; $rowblank=true; $stkdesc[$ustk] = isset ( $stkdesc[$ustk] ) ? $stkdesc[$ustk] : ''; $showline .= ""; $showline .= ""; $showline .= ""; $showline .= ""; foreach ($groupcodelist as $groupcode) { if ($filter=='' || $filter==$groupcode) { $link=$ustk."AXA".$groupcode; $tagged[$link]= isset ( $tagged[$link] ) ? $tagged[$link] : 0 ; if ($tagged[$link]==1) { $isticked="CHECKED"; $rowblank=false; } else { $isticked=""; } $showline .= ""; } } $showline .= ""; if ($rowblank || $blanks=='') { echo $showline; $count++; } } ?>

Stock Ref	Supplier Ref	Description
			Raw Report
$ustk $pos	".$row['customer_ref']."	".$stkdesc[$ustk]."