📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
echo "<script Language=\"JavaScript\">\r\n\r\nfunction Sum_Report(flag)\r\n{\r\n if(flag==0)\r\n {\r\n \tURL=\"report.php?FROM_DATE=\"+document.form1.FROM_DATE.value+\"&TO_DATE=\"+document.form1.TO_DATE.value+\"&PRO_ID=\"+document.form1.PRO_ID.value+\"&TRANS_FLAG=0\"+\"&OFFICE_PROTYPE=\"+document.form1.OFFICE_PROTYPE.value;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"report\",\"height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n if(flag==1)\r\n {\r\n \tURL=\"dept_Sum.php?FROM_DATE=\"+document.form1.FROM_DATE.value+\"&TO_DATE=\"+document.form1.TO_DATE.value+\"&PRO_ID=\"+document.form1.PRO_ID.value+\"&OFFICE_PROTYPE=\"+document.form1.OFFICE_PROTYPE.value;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"dept_Sum\",\"height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n if(flag==2)\r\n {\r\n \tURL=\"borrow_sum.php?FROM_DATE=\"+document.form1.FROM_DATE.value+\"&TO_DATE=\"+document.form1.TO_DATE.value+\"&PRO_ID=\"+document.form1.PRO_ID.value+\"&TRANS_FLAG=2\"+\"&OFFICE_PROTYPE=\"+document.form1.OFFICE_PROTYPE.value;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"borrow_sum\",\"height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n if(flag==3)\r\n {\r\n \tURL=\"borrow_sum.php?FROM_DATE=\"+document.form1.FROM_DATE.value+\"&TO_DATE=\"+document.form1.TO_DATE.value+\"&PRO_ID=\"+document.form1.PRO_ID.value+\"&TRANS_FLAG=3\"+\"&OFFICE_PROTYPE=\"+document.form1.OFFICE_PROTYPE.value;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"return_sum\",\"height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n if(flag==4)\r\n {\r\n \tURL=\"noreturn.php?FROM_DATE=\"+document.form1.FROM_DATE.value+\"&TO_DATE=\"+document.form1.TO_DATE.value+\"&PRO_ID=\"+document.form1.PRO_ID.value+\"&OFFICE_PROTYPE=\"+document.form1.OFFICE_PROTYPE.value;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"noreturn\",\"height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n if(flag==5)\r\n {\r\n \tURL=\"report.php?FROM_DATE=\"+document.form1.FROM_DATE.value+\"&TO_DATE=\"+document.form1.TO_DATE.value+\"&PRO_ID=\"+document.form1.PRO_ID.value+\"&TRANS_FLAG=4\"+\"&OFFICE_PROTYPE=\"+document.form1.OFFICE_PROTYPE.value;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"discard\",\"height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\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<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<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/new_email.gif\" WIDTH=\"18\" HEIGHT=\"18\" 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<table class=\"TableBlock\" align=\"center\" >\r\n <form method=\"post\" name=\"form1\">\r\n \t<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 htmlspecialchars( $PRONAME );
echo "/库存";
echo htmlspecialchars( $PROSTOCK );
echo "</option>\r\n\r\n ";
}
echo " </select>\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 <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"2\" align=\"left\">\r\n 报表类型\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine1\" colspan=\"2\" align=\"left\">\r\n <a href=\"javascript:Sum_Report('0');\">采购物品报表</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\" colspan=\"2\" align=\"left\">\r\n <a href=\"javascript:Sum_Report('1');\">部门、人员领用物品报表</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine1\" colspan=\"2\" align=\"left\">\r\n <a href=\"javascript:Sum_Report('2');\">借用物品报表</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\" colspan=\"2\" align=\"left\">\r\n <a href=\"javascript:Sum_Report('3');\">归还物品报表</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine1\" colspan=\"2\" align=\"left\">\r\n <a href=\"javascript:Sum_Report('4');\">未归还物品报表</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\" colspan=\"2\" align=\"left\">\r\n <a href=\"javascript:Sum_Report('5');\">报废物品报表</a>\r\n </td>\r\n </tr>\r\n</form>\r\n</table>\r\n</div>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -