📄 index.php
字号:
<?php
function GETALLDATE( $CODE )
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."'";
$cursor = exequery( $connection, $query );
echo "<option value= ></option>";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
echo "<option value=".$CODE_NO.">".$CODE_NAME."</option>";
}
}
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$PAGE_SIZE = 10;
echo "<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<script Language=\"JavaScript\">\r\n\tfunction show_detail(ORDER_ID)\r\n {\r\n URL=\"show_detail.php?ORDER_ID=\"+ORDER_ID;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n \tfunction print_form(ORDER_ID,ITEM_ID)\r\n {\r\n URL=\"print?ORDER_ID=\"+ORDER_ID+\"&ITEM_ID=\"+ITEM_ID;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n\r\n\tfunction check_one(el)\r\n{\r\n if(!el.checked)\r\n document.all(\"allbox\").checked=false;\r\n}\r\n function delete_customer(ORDER_ID,urlstr)\r\n{\r\n msg='确认要删除该订单？这也将删除相关的订单明细和接货记录。';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?ORDER_ID=\" + ORDER_ID+\"&\"+urlstr+\"&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\";\r\n window.location=URL;\r\n }\r\n}\r\nfunction ad_query()\r\n{\r\n URL=\"ad_query\";\r\n window.location=URL;\r\n}\r\n\r\nfunction set_page(urlstr)\r\n{\r\n PAGE_START=PAGE_NUM.value;\r\n location=\"index.php?CUR_PAGE=\"+PAGE_START+\"&\"+urlstr;\r\n}\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").item(i).checked=true;\r\n else\r\n document.all(\"email_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").checked=true;\r\n else\r\n document.all(\"email_select\").checked=false;\r\n }\r\n}\r\nfunction delete_mail(urlstr)\r\n{\r\n delete_str=\"\";\r\n for(i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n\r\n el=document.all(\"email_select\").item(i);\r\n if(el.checked)\r\n { val=el.value;\r\n delete_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(i==0)\r\n {\r\n el=document.all(\"email_select\");\r\n if(el.checked)\r\n { val=el.value;\r\n delete_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(delete_str==\"\")\r\n {\r\n alert(\"请至少选择其中一个订单\");\r\n return;\r\n }\r\n\r\n msg='确认要删除所选订单？';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?delete_str=\"+delete_str+\"&\"+urlstr+\"&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\";\r\n window.location=URL;\r\n }\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\">\r\n<div align=\"left\">\r\n<fieldset style=\"width:95%;padding-bottom:5px;\">\r\n\t <legend class=\"small\" align=left>\r\n <b>快速查询</b>\r\n </legend>\r\n<table cellspacing=\"1\" class=\"small\" align=\"left\" cellpadding=\"3\">\r\n <form action=\"index.php\" method=\"post\" name=\"form1\">\r\n <tr>\r\n\r\n <td nowrap class=\"TableData\"> 供应商名称： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PROVIDER_NAME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $PROVIDER_NAME;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableData\">供应商编码： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PROVIDER_CODE\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $PROVIDER_CODE;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableData\">供应商简称： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PROVIDER_SHORT\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $PROVIDER_SHORT;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableData\"> 地区： </td>\r\n <td nowrap class=\"TableData\" >\r\n <select name=\"PROVIDER_AREA\" class=\"SmallSelect\">\r\n";
getalldate( "AREA", $PROVIDER_AREA );
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\"> 订单类型： </td>\r\n <td nowrap class=\"TableData\" >\r\n <select name=\"ORDER_TYPE\" class=\"SmallSelect\">\r\n";
getalldate( "ORDER_TYPE" );
echo " </select>\r\n </td>\r\n <td nowrap class=\"TableData\">订单编号： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"ORDER_NO\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $ORDER_NO;
echo "\">\r\n </td>\r\n\r\n <td nowrap class=\"TableData\">订单名称： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"ORDER_NAME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $ORDER_NAME;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableData\">负责人： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"RECIVER\" class=\"SmallInput\" size=\"10\" maxlength=\"100\" value=\"";
echo $RECIVER;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableData\">\r\n \t \t <select name=\"DATE_TYPE\" class=\"SmallSelect\">\r\n <option value=\"BEGIN\">接货日期</option>\r\n <option value=\"CREATE\">创建日期</option>\r\n </select>\r\n \t</td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n <input type=\"text\" name=\"DATE1\" size=\"15\" maxlength=\"10\" class=\"SmallStatic\" readonly value=\"";
echo $BEGIN_DATE;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('form1.DATE1');\">\r\n 至<input type=\"text\" name=\"DATE2\" size=\"15\" maxlength=\"10\" class=\"SmallStatic\" readonly value=\"";
echo $BEGIN_DATE;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('form1.DATE2');\">\r\n\r\n </td>\r\n <td nowrap class=\"TableData\">创建人： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"CREATOR\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $CREATOR;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableData\" colspan=\"3\" >\r\n \t <input value=\"快速查询\" type=\"submit\" class=\"SmallButton\" title=\"快速查询\" name=\"button\">\r\n <input value=\"高级查询\" type=\"button\" class=\"SmallButton\" title=\"模糊查询\" name=\"button1\" onClick=\"ad_query();\">\r\n </td>\r\n </tr>\r\n</form>\r\n</table>\r\n</fieldset>\r\n</div>\r\n<br>\r\n<br>\r\n";
if ( $PROVIDER_NAME != "" )
{
if ( $urlstr == "" )
{
$urlstr = "PROVIDER_NAME=".$PROVIDER_NAME;
}
else
{
$urlstr = $urlstr."&PROVIDER_NAME=".$PROVIDER_NAME;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where d.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
else
{
$WHERE_STR .= " and d.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
}
if ( $PROVIDER_CODE != "" )
{
if ( $urlstr == "" )
{
$urlstr = "PROVIDER_CODE=".$PROVIDER_CODE;
}
else
{
$urlstr = $urlstr."&PROVIDER_CODE=".$PROVIDER_CODE;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where d.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
}
else
{
$WHERE_STR .= " and d.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
}
}
if ( $PROVIDER_SHORT != "" )
{
if ( $urlstr == "" )
{
$urlstr = "PROVIDER_SHORT=".$PROVIDER_SHORT;
}
else
{
$urlstr = $urlstr."&PROVIDER_SHORT=".$PROVIDER_SHORT;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where d.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
}
else
{
$WHERE_STR .= " and d.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
}
}
if ( $PROVIDER_AREA != "" )
{
if ( $urlstr == "" )
{
$urlstr = "PROVIDER_AREA=".$PROVIDER_AREA;
}
else
{
$urlstr = $urlstr."&PROVIDER_AREA=".$PROVIDER_AREA;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where d.PROVIDER_AREA ='".$PROVIDER_AREA."'";
}
else
{
$WHERE_STR .= " and d.PROVIDER_AREA ='".$PROVIDER_AREA."'";
}
}
if ( $ORDER_TYPE != "" )
{
if ( $urlstr == "" )
{
$urlstr = "ORDER_TYPE=".$ORDER_TYPE;
}
else
{
$urlstr = $urlstr."&ORDER_TYPE=".$ORDER_TYPE;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.ORDER_TYPE ='".$ORDER_TYPE."'";
}
else
{
$WHERE_STR .= " and a.ORDER_TYPE ='".$ORDER_TYPE."'";
}
}
if ( $ORDER_NO != "" )
{
if ( $urlstr == "" )
{
$urlstr = "ORDER_NO=".$ORDER_NO;
}
else
{
$urlstr = $urlstr."&ORDER_NO=".$ORDER_NO;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.ORDER_NO like '%".$ORDER_NO."%'";
}
else
{
$WHERE_STR .= " and a.ORDER_NO like '%".$ORDER_NO."%'";
}
}
if ( $ORDER_NAME != "" )
{
if ( $urlstr == "" )
{
$urlstr = "ORDER_NAME=".$ORDER_NAME;
}
else
{
$urlstr = $urlstr."&ORDER_NAME=".$ORDER_NAME;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.ORDER_NAME like '%".$ORDER_NAME."%'";
}
else
{
$WHERE_STR .= " and a.ORDER_NAME like '%".$ORDER_NAME."%'";
}
}
if ( $RECIVER != "" )
{
if ( $urlstr == "" )
{
$urlstr = "RECIVER=".$RECIVER;
}
else
{
$urlstr = $urlstr."&RECIVER=".$RECIVER;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.RECIVER like '%".$RECIVER."%'";
}
else
{
$WHERE_STR .= " and a.RECIVER like '%".$RECIVER."%'";
}
}
if ( $DATE1 != "" )
{
if ( $urlstr == "" )
{
$urlstr = "DATE1=".$DATE1;
}
else
{
$urlstr = $urlstr."&DATE1=".$DATE1;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.".$DATE_TYPE.( "_DATE>='".$DATE1."'" );
}
else
{
$WHERE_STR .= " and a.".$DATE_TYPE.( "_DATE>='".$DATE1."'" );
}
}
if ( $DATE2 != "" )
{
if ( $urlstr == "" )
{
$urlstr = "DATE2=".$DATE2;
}
else
{
$urlstr = $urlstr."&DATE2=".$DATE2;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.".$DATE_TYPE.( "_DATE<='".$DATE2."'" );
}
else
{
$WHERE_STR .= " and a.".$DATE_TYPE.( "_DATE<='".$DATE2."'" );
}
}
if ( $CREATOR != "" )
{
if ( $urlstr == "" )
{
$urlstr = "CREATOR=".$CREATOR;
}
else
{
$urlstr = $urlstr."&CREATOR=".$CREATOR;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.CREATOR like '%".$CREATOR."%'";
}
else
{
$WHERE_STR .= " and a.CREATOR like '%".$CREATOR."%'";
}
}
if ( $urlstr == "" )
{
$urlstr = "DATE_TYPE=".$DATE_TYPE;
}
else
{
$urlstr = $urlstr."&DATE_TYPE=".$DATE_TYPE;
}
if ( $ORDERFIELD != "" )
{
if ( $ORDERSIGN == "DOWN" )
{
$ORDERTYPE = "ASC";
}
if ( $ORDERSIGN == "UP" )
{
$ORDERTYPE = "DESC";
}
$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
if ( $OREDERBY == "" )
{
$OREDERBY = " ORDER BY CREATE_DATE DESC";
}
$CUSTOMER_COUNT = 0;
$query = "SELECT count(*)\r\n from SUPPLY_ORDER a\r\n LEFT OUTER JOIN SYS_CODE b ON a.ORDER_TYPE=b.CODE_NO AND b.PARENT_NO = 'ORDER_TYPE'\r\n LEFT OUTER JOIN PROVIDER d ON a.PROVIDER_ID = d.PROVIDER_ID\r\n LEFT OUTER JOIN SYS_CODE e ON d.PROVIDER_AREA= e.CODE_NO AND e.PARENT_NO = 'AREACODE'\r\n ".$WHERE_STR;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$CUSTOMER_COUNT = $ROW[0];
}
$PER_PAGE = 5;
$PAGE_COUNT = ceil( $CUSTOMER_COUNT / $PER_PAGE );
if ( $CUR_PAGE <= 0 || $CUR_PAGE == "" )
{
$CUR_PAGE = 1;
}
if ( $PAGE_COUNT < $CUR_PAGE )
{
$CUR_PAGE = $PAGE_COUNT;
}
$query1 = "SELECT a.ORDER_ID ,a.ORDER_NO,a.ORDER_NAME,b.CODE_NAME as ORDER_TYPE,d.PROVIDER_NAME as PROVIDER_NAME,a.CREATE_DATE,a.BEGIN_DATE,f.USER_NAME as CREATOR,g.USER_NAME as RECIVER,sum((h.TRANS_PRICE*h.TRANS_QTY)) as TOTALPRICE,a.ORDER_PRINT\r\n from SUPPLY_ORDER a\r\n LEFT OUTER JOIN SYS_CODE b ON a.ORDER_TYPE=b.CODE_NO AND b.PARENT_NO = 'ORDER_TYPE'\r\n LEFT OUTER JOIN PROVIDER d ON a.PROVIDER_ID = d.PROVIDER_ID\r\n LEFT OUTER JOIN SYS_CODE e ON d.PROVIDER_AREA= e.CODE_NO AND e.PARENT_NO = 'AREACODE'\r\n LEFT OUTER JOIN USER f ON a.CREATOR = f.USER_ID\r\n LEFT OUTER JOIN USER g ON a.RECIVER = g.USER_ID\r\n LEFT OUTER JOIN ORDER_LINE h ON a.ORDER_ID = h.ORDER_ID\r\n ".$WHERE_STR." group by a.ORDER_ID".$OREDERBY;
$offest = ( $CUR_PAGE - 1 ) * $PER_PAGE;
if ( $offest < 0 )
{
$offest = 0;
}
$query1 = $query1." LIMIT ".$offest." ,".$PER_PAGE;
$cursor1 = exequery( $connection, $query1 );
if ( $CUSTOMER_COUNT == 0 )
{
message( "<br>提示", "没有符合条件的订单" );
exit( );
}
echo "\r\n<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" cellpadding=\"3\">\r\n <tr>\r\n <td align=\"left\">\r\n <a href=\"index.php?CUR_PAGE=1&";
echo $urlstr;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>\r\n <a href=\"index.php?CUR_PAGE=";
echo $CUR_PAGE - 1;
echo "&";
echo $urlstr;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>\r\n <a href=\"index.php?CUR_PAGE=";
echo $CUR_PAGE + 1;
echo "&";
echo $urlstr;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style=\"cursor:hand\"></a>\r\n <a href=\"index.php?CUR_PAGE=";
echo $PAGE_COUNT;
echo "&";
echo $urlstr;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last02.gif' width='24' border='0' height='15' alt='末页' style=\"cursor:hand\"></a>\r\n\r\n 到\r\n <input type=\"text\" name=\"PAGE_NUM\" size=\"3\" maxlength=\"4\" class=\"SmallInput\">\r\n 页\r\n <img id=\"btnGotoPage\" src=\"/images/menu/book.gif\" onClick=\"set_page('";
echo $urlstr;
echo "')\" border=\"0\" WIDTH=\"19\" HEIGHT=\"17\" style=\"cursor:hand\" alt=\"转到相应页面\">\r\n </td>\r\n <td align=\"right\">\r\n ";
echo $CUR_PAGE;
echo "/";
echo $PAGE_COUNT;
echo "页 共 ";
echo $CUSTOMER_COUNT;
echo " 条\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table width=\"95%\" class=\"tablelist\">\r\n <tr class=\"TableHeader\">\r\n \t <td nowrap align=\"center\">选择</td>\r\n <td nowrap align=\"center\"><a href=\"index.php?";
echo $urlstr;
echo "&ORDERFIELD=ORDER_NO&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
echo "DOWN";
}
if ( $ORDERSIGN == "" )
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -