📄 list.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$PAGE_SIZE = 10;
echo '
<html>
<head>
<title>订单查询结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript Language="JavaScript">
function delete_customer(ORDER_ID,querstr)
{
msg=\'确认要删除该订单？\';
if(window.confirm(msg))
{
URL="../delete.php?querstr="+querstr+"&CUR_PAGE=';
echo $CUR_PAGE;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&ORDER_ID=" + ORDER_ID;
window.location=URL;
}
}
function set_page(urlstr)
{
PAGE_START=PAGE_NUM.value;
location="list.php?"+urlstr+"&CUR_PAGE="+PAGE_START+"&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '";
}
function check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function check_all()
{
for (i=0;i<document.all("email_select").length;i++)
{
if(document.all("allbox").checked)
document.all("email_select").item(i).checked=true;
else
document.all("email_select").item(i).checked=false;
}
if(i==0)
{
if(document.all("allbox").';
echo 'checked)
document.all("email_select").checked=true;
else
document.all("email_select").checked=false;
}
}
</script>
</head>
';
$urlstr = ('DATE_TYPE='.$DATE_TYPE);
if (($PROVIDER_NAME != ''))
{
$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 != ''))
{
$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 != ''))
{
$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 != ''))
{
$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 (($PROVIDER_ADD != ''))
{
$urlstr = (($urlstr.'&PROVIDER_ADD=').$PROVIDER_AREA);
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where d.PROVIDER_ADD like \'%'.$PROVIDER_ADD).'%\''));
}
else
{
($WHERE_STR .= ((' and d.PROVIDER_ADD like \'%'.$PROVIDER_ADD).'%\''));
}
}
if (($ORDER_TYPE != ''))
{
$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 != ''))
{
$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 != ''))
{
$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 (($ORDER_MEMO != ''))
{
$urlstr = (($urlstr.'&ORDER_MEMO=').$ORDER_MEMO);
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where a.ORDER_MEMO like \'%'.$ORDER_MEMO).'%\''));
}
else
{
($WHERE_STR .= ((' and a.ORDER_MEMO like \'%'.$ORDER_MEMO).'%\''));
}
}
if (($REMARK != ''))
{
$urlstr = (($urlstr.'&REMARK=').$REMARK);
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where a.REMARK like \'%'.$REMARK).'%\''));
}
else
{
($WHERE_STR .= ((' and a.REMARK like \'%'.$REMARK).'%\''));
}
}
if (($LDATE1 != ''))
{
$urlstr = (($urlstr.'&LDATE1=').$LDATE1);
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where a.'.$DATE_TYPE).(((''.'_DATE>=\'').$LDATE1).'\'')));
}
else
{
($WHERE_STR .= ((' and a.'.$DATE_TYPE).(((''.'_DATE>=\'').$LDATE1).'\'')));
}
}
if (($LDATE2 != ''))
{
$urlstr = (($urlstr.'&LDATE2=').$LDATE2);
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where a.'.$DATE_TYPE).(((''.'_DATE<=\'').$LDATE2).'\'')));
}
else
{
($WHERE_STR .= ((' and a.'.$DATE_TYPE).(((''.'_DATE<=\'').$LDATE2).'\'')));
}
}
$query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'SUPPLY_ORDER\'';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$FIELDNO = ('SUPPLY_ORDER'.$ROW['FIELDNO']);
if (($$FIELDNO != ''))
{
$CUSTOMERID_STR = '';
$urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
$WHERE_STR1 = ((((' where TABLENAME=\'SUPPLY_ORDER\' and (FIELDNO=\''.$ROW['FIELDNO']).'\' and ITEM_DATE like \'%').$$FIELDNO).'%\')');
$query1 = ('SELECT IDENTY_ID FROM `FIELD_DATE`'.$WHERE_STR1);
$cursor1 = exequery ($connection, $query1);
while ($ROW1 = mysql_fetch_array ($cursor1))
{
$CUSTOMERID_STR = (($CUSTOMERID_STR.$ROW1['IDENTY_ID']).',');
}
$CUSTOMERID_STR = (('\''.str_replace (',', '\',\'', substr ($CUSTOMERID_STR, 0, -1))).'\'');
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where a.ORDER_ID in (').$CUSTOMERID_STR).')'));
continue;
}
else
{
($WHERE_STR .= (((''.' and a.ORDER_ID in (').$CUSTOMERID_STR).')'));
continue;
}
continue;
}
}
$query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'PROVIDER\'';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$FIELDNO = ('PROVIDER'.$ROW['FIELDNO']);
if (($$FIELDNO != ''))
{
$CONTACTID_STR = '';
$urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
$WHERE_STR1 = ((((' where TABLENAME=\'PROVIDER\' and (FIELDNO=\''.$ROW['FIELDNO']).'\' and ITEM_DATE like \'%').$$FIELDNO).'%\')');
$query1 = ('SELECT IDENTY_ID FROM `FIELD_DATE`'.$WHERE_STR1);
$cursor1 = exequery ($connection, $query1);
while ($ROW1 = mysql_fetch_array ($cursor1))
{
$CONTACTID_STR = (($CONTACTID_STR.$ROW1['IDENTY_ID']).',');
}
$CONTACTID_STR = (('\''.str_replace (',', '\',\'', substr ($CONTACTID_STR, 0, -1))).'\'');
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where d.PROVIDER_ID in (').$CONTACTID_STR).')'));
continue;
}
else
{
($WHERE_STR .= (((''.' and d.PROVIDER_ID in (').$CONTACTID_STR).')'));
continue;
}
continue;
}
}
$urlstr1 = str_replace ('&', '%', $urlstr);
if (($ORDERFIELD != ''))
{
if (($ORDERSIGN == 'DOWN'))
{
$ORDERTYPE = 'ASC';
}
if (($ORDERSIGN == 'UP'))
{
$ORDERTYPE = 'DESC';
}
$OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
}
$CUSTOMER_COUNT = 0;
$query = (('SELECT count(*)
from SUPPLY_ORDER a
LEFT OUTER JOIN SYS_CODE b ON a.ORDER_TYPE=b.CODE_NO AND b.PARENT_NO = \'ORDER_TYPE\'
LEFT OUTER JOIN PROVIDER d ON a.PROVIDER_ID = d.PROVIDER_ID
LEFT OUTER JOIN SYS_CODE e ON d.PROVIDER_AREA= e.CODE_NO AND e.PARENT_NO = \'AREACODE\'
'.$WHERE_STR).' group by a.ORDER_ID');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$CUSTOMER_COUNT = $ROW[0];
}
$PER_PAGE = 10;
$PAGE_COUNT = ceil (($CUSTOMER_COUNT / $PER_PAGE));
if ((($CUR_PAGE <= 0) OR ($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
from SUPPLY_ORDER a
LEFT OUTER JOIN SYS_CODE b ON a.ORDER_TYPE=b.CODE_NO AND b.PARENT_NO = \'ORDER_TYPE\'
LEFT OUTER JOIN PROVIDER d ON a.PROVIDER_ID = d.PROVIDER_ID
LEFT OUTER JOIN SYS_CODE e ON d.PROVIDER_AREA= e.CODE_NO AND e.PARENT_NO = \'AREACODE\'
LEFT OUTER JOIN USER f ON a.CREATOR = f.USER_ID
LEFT OUTER JOIN USER g ON a.RECIVER = g.USER_ID
LEFT OUTER JOIN ORDER_LINE h ON a.ORDER_ID = h.ORDER_ID
'.$WHERE_STR).' group by a.ORDER_ID').$HAVING).$OREDERBY);
$offest = (($CUR_PAGE - 1) * 10);
$query1 = (((($query1.' LIMIT ').$offest).' ,').$PER_PAGE);
$cursor1 = exequery ($connection, $query1);
if (($CUSTOMER_COUNT == 0))
{
message ('<br>提示', '没有符合条件的订单记录');
button_back ();
exit ();
}
else
{
echo '
<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr>
<td align="left">
<a href="list.php?';
echo $urlstr;
echo '&CUR_PAGE=1&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
<a href="list.php?';
echo $urlstr;
echo '&CUR_PAGE=';
echo ($CUR_PAGE - 1);
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '"><img src=\'/images/first01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'上一页\'></a>
<a href="list.php?';
echo $urlstr;
echo '&CUR_PAGE=';
echo ($CUR_PAGE + 1);
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>
<a href="list.php?';
echo $urlstr;
echo '&CUR_PAGE=';
echo $PAGE_COUNT;
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>
到
<input type="text" name="PAGE_NUM" size="3" maxlength="4" class="SmallInput">
页
<img id="btnGotoPage" src="/images/menu/book.gif" onclick="set_page(\'';
echo $urlstr;
echo '\')" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
</td>
<td align="right">
';
echo $CUR_PAGE;
echo '/';
echo $PAGE_COUNT;
echo '页 共 ';
echo $CUSTOMER_COUNT;
echo ' 条
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">选择</td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=ORDER_NO&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">订单编号 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'ORDER_NO')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'ORDER_NO')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=ORDER_NAME&ORDERSIGN=';
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -