Inventroy Transactions Query

\n"; if (empty($_REQUEST['date']) and empty($_REQUEST['uid']) and empty($_REQUEST['scancode']) and empty($_REQUEST['sn']) and empty($_REQUEST['owner']) and empty($_REQUEST['transfer']) and empty($_REQUEST['oLoc']) and empty($_REQUEST['oLoc']) and empty($_REQUEST['op']) and empty($_REQUEST['nLoc']) and empty($_REQUEST['empNo'])) { if (empty($_SESSION['itq']['date']) and empty($_SESSION['itq']['uid']) and empty($_SESSION['itq']['scancode']) and empty($_SESSION['itq']['sn']) and empty($_SESSION['itq']['owner']) and empty($_SESSION['itq']['transfer']) and empty($_SESSION['itq']['oLoc']) and empty($_SESSION['itq']['oLoc']) and empty($_SESSION['itq']['op']) and empty($_SESSION['itq']['nLoc']) and empty($_SESSION['itq']['empNo'])) { $_REQUEST['date'] = date("Ymd"); $_REQUEST['page'] = 1; } else { $_REQUEST['date'] = $_SESSION['itq']['date']; $_REQUEST['uid'] = $_SESSION['itq']['uid']; $_REQUEST['scancode'] = $_SESSION['itq']['scancode']; $_REQUEST['sn'] = $_SESSION['itq']['sn']; $_REQUEST['owner'] = $_SESSION['itq']['owner']; $_REQUEST['transfer'] = $_SESSION['itq']['transfer']; $_REQUEST['oLoc'] = $_SESSION['itq']['oLoc']; $_REQUEST['op'] = $_SESSION['itq']['op']; $_REQUEST['nLoc'] = $_SESSION['itq']['nLoc']; $_REQUEST['empNo'] = $_SESSION['itq']['empNo']; if (empty($_REQUEST['page'])) $_REQUEST['page'] = $_SESSION['itq']['page']; } } if (empty($_REQUEST['page'])) $_REQUEST['page'] = 1; $_SESSION['itq']['date'] = $_REQUEST['date']; $_SESSION['itq']['uid'] = $_REQUEST['uid']; $_SESSION['itq']['scancode'] = $_REQUEST['scancode']; $_SESSION['itq']['sn'] = $_REQUEST['sn']; $_SESSION['itq']['owner'] = $_REQUEST['owner']; $_SESSION['itq']['transfer'] = $_REQUEST['transfer']; $_SESSION['itq']['oLoc'] = $_REQUEST['oLoc']; $_SESSION['itq']['op'] = $_REQUEST['op']; $_SESSION['itq']['nLoc'] = $_REQUEST['nLoc']; $_SESSION['itq']['empNo'] = $_REQUEST['empNo']; $_SESSION['itq']['page'] = $_REQUEST['page']; debug(2); 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"; $q = ""; if (!empty($_REQUEST['date'])) $q = "lastmod like '".$_REQUEST['date']."%'"; if (!empty($_REQUEST['uid'])) { if ($q) $q .= " and "; $q .= "uid like '".$_REQUEST['uid']."'"; } if (!empty($_REQUEST['scancode'])) { $item = getInventoryReference($_REQUEST['scancode']); if ($q) $q .= " and "; $q .= "item like '$item'"; } if (!empty($_REQUEST['sn'])) { if ($q) $q .= " and "; $q .= "sn like '".$_REQUEST['sn']."'"; } if (!empty($_REQUEST['owner'])) { if ($q) $q .= " and "; $q .= "owner = '".strtolower($_REQUEST['owner'])."'"; } if (!empty($_REQUEST['order'])) { $oInfo = "select tid from headers where jobNo='{$_REQUEST['order']}'"; $oInfo = mysql_fetch_assoc(mysql_query($oInfo, $mLink)); if ($q) $q .= " and "; $q .= "workorder = '{$oInfo['tid']}'"; } // if (!empty($_REQUEST['transfer'])) // { if ($q) $q .= " and "; // $q .= "transfer like '".strtoupper($_REQUEST['transfer'])."'"; // } if (!empty($_REQUEST['oLoc'])) { if ($q) $q .= " and "; $q .= "oloc like '{$_REQUEST['oLoc']}'"; } if (!empty($_REQUEST['op'])) { if ($q) $q .= " and "; $q .= "opCode like '{$_REQUEST['op']}'"; } if (!empty($_REQUEST['nLoc'])) { if ($q) $q .= " and "; $q .= "nloc like '".$_REQUEST['nLoc']."'"; } if (!empty($_REQUEST['empNo'])) { if ($q) $q .= " and "; $q .= "empNo = '".$_REQUEST['empNo']."'"; } // total # of records that CAN be fetched .... $transList = mysql_query("select * from `itq` where $q", $mLink); $totalPages = intval((mysql_num_rows($transList) + $resultsPerPage - 1) / $resultsPerPage); $q = "select * from `itq` where $q order by lastmod desc, tid desc limit ".($resultsPerPage * ($_REQUEST['page'] - 1)).", $resultsPerPage"; $transList = mysql_query($q, $mLink); if (mysql_num_rows($transList)) { while ($transItem = mysql_fetch_assoc($transList)) { $date = substr($transItem['lastmod'], 0, 8); $item = getProductInfo($transItem['item']); //$item = $item['vsn']; $woDat = mysql_query("select * from headers where tid='{$transItem['workorder']}'", $mLink); $woDat = mysql_fetch_assoc($woDat); 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"; } else $msgs[] = "No matching entries"; echo "

Date

UID

Item

Owner

Order

oldLoc

newLoc

EmpNo

$date

{$transItem['uid']}

{$item['vsn']}

{$transItem['sn']}

{$transItem['owner']}

{$woDat['jobNo']}

{$transItem['oloc']}

{$transItem['opCode']}

{$transItem['nloc']}

{$transItem['empNo']}

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

Page {$_REQUEST['page']} of $totalPages

\n"; echo "

\n"; include 'comFooter.php'; ?>