\n"; while ($item = mysql_fetch_assoc($itemsList)) { if ($owner != $item['owner'] or $supplier != $item['supplier']) { if ($ttlCnt) { // close off existing report echo "$ttlCnt{$curItemDat['vsn']}"; if ($curItemDat['vend']) echo "[{$curItemDat['vend']}]"; echo "\n"; foreach ($ordersList as $v) echo $v; unset($ordersList); echo "\n"; } // new PO ..... either the vendor or the owner has changed $owner = $item['owner']; $supplier = $item['supplier']; // do a header here ... make subroutine? $vDat = "select * from ivends where vCode='$supplier'"; $vDat = mysql_fetch_assoc(mysql_query($vDat, $mLink)); $oDat = "select * from iowners where short_name='$owner'"; $oDat = mysql_fetch_assoc(mysql_query($oDat, $mLink)); echo "
\n
\n"; $ttlCnt = 0; } if ($curItem != $item['item'] and $ttlCnt) { echo "$ttlCnt{$curItemDat['vsn']}"; if ($curItemDat['vend']) echo "[{$curItemDat['vend']}]"; echo "\n"; foreach ($ordersList as $v) echo $v; unset($ordersList); $ttlCnt = 0; } $curItem = $item['item']; $curItemDat = getProductInfo($item['item']); // get count of this item required for each order of this owner $q = "select count(*) as cnt from inventory where uid='' and item='$curItem'and workorder='{$item['workorder']}' and owner='$owner' and purchaseorder='' and iloc='' and status='' and sof=''"; $cnt = mysql_query($q, $mLink); $cnt = mysql_fetch_assoc($cnt); $cnt = $cnt['cnt']; $ttlCnt += $cnt; $woDat = "select * from headers where tid='{$item['workorder']}'"; $woDat = mysql_fetch_assoc(mysql_query($woDat, $mLink)); $ordersList[] = "\n"; $ordersList[] = "\n"; $ordersList[] = "$cnt\n"; $ordersList[] = "{$woDat['jobNo']}\n"; $ordersList[] = "".fixName($woDat['fName'], $woDat['lName'])."\n"; $ordersList[] = "\n"; } if ($ttlCnt) { // close off existing report echo "$ttlCnt{$curItemDat['vsn']}"; if ($curItemDat['vend']) echo "[{$curItemDat['vend']}]"; echo "\n"; foreach ($ordersList as $v) echo $v; } echo "
\n\n"; } include 'comFooter.php'; ?>