Receiving
Fill Backorders"; $availPartsList = mysql_query("select * from inventory where uid!='' and workorder='' and iloc!='' and sof=''", $mLink); while ($oldEnt = mysql_fetch_assoc($availPartsList)) { $reqPart = mysql_query("select * from inventory where uid='' and item='{$oldEnt['item']}' and owner='{$_REQUEST['owner']}' and iloc='' and workorder!='' and purchaseorder='' limit 1", $mLink); if (mysql_num_rows($reqPart)) { $reqPart = mysql_fetch_assoc($reqPart); // reserve this to the workorder sqlUpdate("inventory", "workorder='{$reqPart['workorder']}'", "tid='{$oldEnt['tid']}'"); $newEnt = doITQprefetch($oldEnt['tid']); doItq($oldEnt, $newEnt, "BOF"); $filled[$reqPart['workorder']][$oldEnt['item']] += 1; // remove reference to placeholder part entry sqlUpdate("inventory", "item='',owner='',iloc='',workorder='',status=''", "tid='{$reqPart['tid']}'"); } } } if (!empty($_REQUEST['product'])) { if (!empty($_REQUEST['sn'])) $_REQUEST['qty'] = 1; // look up actual product code for this scan code $iCode = getInventoryReference($_REQUEST['product']); if (isTrackable($_REQUEST['owner'], $iCode, "tid") or !empty($_REQUEST['sn'])) { echo "\n"; //$q = "`uid` ='', "; //$q .= "`qty` ='{$_REQUEST['qty']}', "; $q = "`qty` ='1', "; $q .= "`item` ='$iCode', "; $q .= "`sn` ='{$_REQUEST['sn']}', "; $q .= "`owner` ='{$_REQUEST['owner']}', "; $q .= "`iloc` ='{$_REQUEST['reclocation']}', "; $q .= "`workorder` ='', "; $q .= "`purchaseorder` ='', "; $q .= "`transfer` ='', "; $q .= "`status` ='', "; $q .= "`sof` ='', "; $q .= "`retail` ='0.00', "; $q .= "`hst` ='0.00', "; $q .= "`gst` ='0.00', "; $q .= "`pst` ='0.00'"; while ($_REQUEST['qty'] > 0) { $uid = getNextUID(); $r = sqlRecycle("inventory", "uid='$uid', $q", "item=''"); doItq("", doITQprefetch($r['t']), "RCV"); $_REQUEST['qty'] -= 1; } } else $msgs[] = "
Item is not tracked\n"; if (empty($_REQUEST['qty'])) $_REQUEST['qty'] = 1; echo "
\n"; echo "
\n"; echo "
\n"; echo "
Qty
\n"; echo "
Stock Num
\n"; echo "
Owner
\n"; echo "
Receive Location
\n"; echo "
Serial Number
\n"; echo "
Document Reference
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; if (empty($_REQUEST['owner'])) $_REQUEST['owner'] = "nss"; $owners = sqlSelect("iowners", "", "", "full_name"); echo "
\n"; while ($owner = mysql_fetch_assoc($owners['r'])) { echo "
".strtoupper($owner['short_name'])."\n"; } echo "
\n"; echo "
\n"; if (empty($_REQUEST['reclocation'])) $_REQUEST['reclocation'] = "STKRM"; $r = sqlSelect("iloc", "", "", "shortname"); while ($loc = mysql_fetch_assoc($r['r'])) { echo "
{$loc['description']}\n"; } echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; ?>