Inventory Definition

\n"; } if (!empty($_REQUEST['delete_item'])) { // an item was entered to be removed from the package. } // describe the package $pkg = mysql_query("select * from idesc where tid='{$_REQUEST['pkgref']}'", $mLink); $pkg = mysql_fetch_assoc($pkg); echo $pkg['vend']." ".$pkg['vsn']." - ".$pkg['description']."
\n"; // get (and show) a list of all items registered as part of the package echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $pkgList = mysql_query("select * from ipkg where linkref='{$_REQUEST['pkgref']}'", $mLink); if (mysql_num_rows($pkgList)) { while ($pkgItem = mysql_fetch_assoc($pkgList)) { echo " \m"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } } else echo " \n"; echo "
QtyMFGVSNDESCRIPTION
{$pkgItem['qty']}{$pkgItem['vend']}{$pkgItem['vsn']}{$pkgItem['description']}
No Items in Package
\n"; } else if (empty($_REQUEST['ref'])) { // nothing has been entered yet echo "\n"; echo " \n"; echo " \n"; echo "Product Code: \n"; echo " \n"; echo "
\n"; setFocus("ref"); } else if (!empty($_REQUEST['ref'])) { // item has been entered if ($iList = getInventoryReference($_REQUEST['ref'])) { $item = getProductInfo($iList); echo " \n"; } else { $item['vsn'] = $_REQUEST['ref']; $item['reorder_float_qty'] = 0; $item['reorder_qty'] = 0; $item['reorder_units'] = 0; } echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " $r = mysql_query("SELECT category FROM idesc GROUP BY category ORDER BY category", $mLink); echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $owners = sqlSelect("iowners", "", "", "full_name"); $q = "select owner from `ivsn` where scancode = '{$_REQUEST[ref]}'"; echo "\n"; $kodeOwner = sqlEx($q); if (mysql_num_rows($kodeOwner)) { $kodeOwner = mysql_fetch_assoc($kodeOwner); $kodeOwner = $kodeOwner['owner']; } else $kodeOwner = ""; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
Scan Code:
Category"; echo " "; echo " \n";//
Supplier\n"; echo " \n"; echo "
Mfg
VSN
Description
ReOrder Level
ReOrder Float
ReOrder Qty
Track?
Track SN
Package
Owner Specific?\n"; echo " \n"; echo "
\n"; $q = "select * from idesc where tid='{$item['tid']}' and vsn != '{$_REQUEST['ref']}'"; $vsn = sqlEx($q); $q = "select * from ivsn where linkref='{$item['tid']}' and scancode != '{$_REQUEST['ref']}'"; $aliases = sqlEx($q); if (mysql_num_rows($aliases) or mysql_num_rows($vsn)) { echo "
Alternate Product Codes:
\n"; while ($alias = mysql_fetch_assoc($vsn)) { echo "[MFG] ".$alias['vsn']."
\n"; } while ($alias = mysql_fetch_assoc($aliases)) { if (!empty($alias['owner'])) echo "[".strtoupper($alias['owner'])."] "; echo $alias['scancode']."
\n"; } } echo "\n"; } else { echo "Houston, we have a problem!

\n"; debug("2", true); } include 'comFooter.php'; ?>