📄 query.php
字号:
<?php
include_once( "inc/auth.php" );
echo "<script Language=\"JavaScript\">\r\n\r\nfunction query()\r\n{\r\n location=\"detail.php?TRANS_FLAG=\"+document.form1.TRANS_FLAG.value+\"&PRO_ID=\"+document.form1.PRO_ID.value+\"&FROM_DATE=\"+document.form1.FROM_DATE.value+\"&TO_DATE=\"+document.form1.TO_DATE.value+\"&PRO_NAME=\"+document.form1.PRO_NAME.value+\"&BORROWER=\"+document.form1.TO_ID.value+\"&OFFICE_PROTYPE=\"+document.form1.OFFICE_PROTYPE.value;\r\n}\r\n\r\nvar PRODUCT=[\r\n";
$query = "SELECT CODE_NO from SYS_CODE where PARENT_NO='OFFICE_PROTYPE' order by CODE_NAME";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NO = "";
$STR_PRONAME1 = "";
$STR_PROID1 = "";
$CODE_NO = $ROW['CODE_NO'];
$query = "SELECT * from OFFICE_PRODUCTS where OFFICE_PROTYPE='".$CODE_NO."' and ((PRO_MANAGER='{$LOGIN_USER_ID}' or find_in_set('{$LOGIN_DEPT_ID}',PRO_DEPT)) or (PRO_MANAGER='' and PRO_DEPT='') or PRO_DEPT='ALL_DEPT')";
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PROSTOCK = htmlspecialchars( $ROW['PRO_STOCK'] );
$PROUNIT = htmlspecialchars( $ROW['PRO_UNIT'] );
$PRONAME = htmlspecialchars( $ROW['PRO_NAME'] );
$STR_PRONAME1 = $STR_PRONAME1."\"".$PRONAME."/库存".$PROSTOCK.$PROUNIT."\",";
$STR_PROID1 = $STR_PROID1."\"".$ROW['PRO_ID']."\",";
}
$STR_PRONAME1 = substr( $STR_PRONAME1, 0, strlen( $STR_PRONAME1 ) - 1 );
$STR_PROID1 = substr( $STR_PROID1, 0, strlen( $STR_PROID1 ) - 1 );
$STR_TEMP = $STR_TEMP."[".$STR_PRONAME1."],[".$STR_PROID1."],";
}
$STR_TEMP = substr( $STR_TEMP, 0, strlen( $STR_TEMP ) - 1 );
echo $STR_TEMP;
echo "];\r\nfunction getProduct()\r\n{\r\nvar OFFICE_PROTYPE=document.form1.OFFICE_PROTYPE;\r\nvar PRO_ID=document.form1.PRO_ID;\r\nvar PRODUCT_NAME=PRODUCT[(OFFICE_PROTYPE.selectedIndex-1)*2];\r\nvar PRODUCT_VALUE=PRODUCT[(OFFICE_PROTYPE.selectedIndex-1)*2+1];\r\nPRO_ID.length=1;\r\nfor(var i=0;i<PRODUCT_NAME.length;i++)\r\n{\r\nPRO_ID[i+1]=new Option(PRODUCT_NAME[i],PRODUCT_VALUE[i]);\r\n}\r\n}\r\n</script>\r\n\r\n<html>\r\n<head>\r\n<title>办公用品登记查询</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"><script src=\"/inc/js/module.js\"></script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
$query = "SELECT count(*) from SCORE_FLOW where END_DATE<='".$CUR_DATE."' and END_DATE <> '0000-00-00' order by SEND_TIME desc";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$HISTORY_COUNT = $ROW[0];
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/infofind.gif\" align=\"absmiddle\"><span class=\"big3\"> 办公用品登记查询</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n<div align=\"center\">\r\n\r\n<table class=\"TableBlock\" align=\"center\" >\r\n <form method=\"post\" name=\"form1\" >\r\n <tr>\r\n <td nowrap class=\"TableContent\">登记类型：</td>\r\n <td class=\"TableData\">\r\n <select name=\"TRANS_FLAG\" class=\"BigSelect\" onChange=\"sel_change()\">\r\n <option value=\"-1\"></option>\r\n <option value=\"0\">采购入库</option>\r\n <option value=\"1\">领用</option>\r\n <option value=\"2\">借用</option>\r\n <option value=\"3\">归还</option>\r\n <option value=\"4\">报废</option>\r\n </select>\r\n\r\n </td>\r\n </tr>\r\n <tr id=\"BORROWER\" style=display:none>\r\n <td nowrap id=\"t1\" class=\"TableContent\" style=display:none>领用人：</td>\r\n <td nowrap id=\"t2\" class=\"TableContent\" style=display:none>借用人：</td>\r\n <td nowrap id=\"t3\" class=\"TableContent\" style=display:none>归还人：</td>\r\n <td class=\"TableData\">\r\n <input type=\"hidden\" name=\"TO_ID\" value=\"\">\r\n <input type=\"text\" name=\"TO_NAME\" size=\"20\" class=\"BigStatic\" maxlength=\"20\" value=\"\" readonly>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectUserSingle('','TO_ID', 'TO_NAME','1')\">选择</a>\r\n <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser('TO_ID', 'TO_NAME')\">清空</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">办公用品类别：</td>\r\n <td class=\"TableData\">\r\n <select name=\"OFFICE_PROTYPE\" class=\"BigSelect\" onChange=\"getProduct()\">\r\n <option value=\"\"></option>\r\n";
$query = "SELECT CODE_NO,CODE_NAME from SYS_CODE where PARENT_NO='OFFICE_PROTYPE' order by CODE_NAME";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VOTE_COUNT;
$CODENAME = $ROW['CODE_NAME'];
$CODENO = $ROW['CODE_NO'];
echo " <option value=\"";
echo $CODENO;
echo "\">";
echo $CODENAME;
echo "</option>\r\n";
}
echo " </select>\r\n </td>\r\n </tr>\r\n \t<tr>\r\n <td nowrap class=\"TableContent\">办公用品：</td>\r\n <td class=\"TableData\">\r\n <select name=\"PRO_ID\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n ";
$query = "SELECT * from OFFICE_PRODUCTS where (PRO_MANAGER='".$LOGIN_USER_ID."' or find_in_set('{$LOGIN_DEPT_ID}',PRO_DEPT)) or (PRO_MANAGER='' and PRO_DEPT='') or PRO_DEPT='ALL_DEPT'";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VOTE_COUNT;
$PROID = $ROW['PRO_ID'];
$PRONAME = $ROW['PRO_NAME'];
$PROSTOCK = $ROW['PRO_STOCK'];
echo " <option value=\"";
echo $PROID;
echo "\">";
echo $PRONAME;
echo "/库存";
echo $PROSTOCK;
echo "</option>\r\n\r\n ";
}
echo " </select>\r\n </td>\r\n </tr>\r\n\r\n <tr>\r\n <td nowrap class=\"TableContent\">办公用品名称(模糊)：</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRO_NAME\" class=\"BigInput\" size=\"15\" maxlength=\"10\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">日期： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"FROM_DATE\" class=\"BigInput\" size=\"15\" maxlength=\"10\" value=\"";
echo $DATE;
echo "\"> \r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('form1.FROM_DATE');\">\r\n 至 \r\n <input type=\"text\" name=\"TO_DATE\" class=\"BigInput\" size=\"15\" maxlength=\"10\" value=\"";
echo $DATE;
echo "\"> \r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('form1.TO_DATE');\">\r\n </td>\r\n </tr>\r\n <tfoot align=\"center\" class=\"TableFooter\">\r\n <td colspan=\"2\" align=\"center\">\r\n <input value=\"查询\" class=\"BigButton\" title=\"模糊查询\" type=\"button\" onClick=\"query();\">\r\n </td>\r\n </tfoot>\r\n </form>\r\n</table>\r\n\r\n</div>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -