list.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 767 行 · 第 1/2 页
PHP
767 行
<?
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 set_page(urlstr)
{
PAGE_START=PAGE_NUM.value;
location="list.php?"+urlstr+"&CUR_PAGE="+PAGE_START+"&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '";
}
</script>
</head>
';
($WHERE_STR .= ' where a.CONTRACT_ID=\'-1\' and a.LINE_ID=\'-1\' ');
if (($COPY_TO_ID != ''))
{
if (($urlstr == ''))
{
$urlstr = ('COPY_TO_ID='.$COPY_TO_ID);
}
else
{
$urlstr = (($urlstr.'©_TO_ID=').$COPY_TO_ID);
}
$COPY_TO_ID = (('\''.str_replace (',', '\',\'', substr ($COPY_TO_ID, 0, -1))).'\'');
($WHERE_STR .= (((''.' and a.SALESMAN in (').$COPY_TO_ID).')'));
}
if (($TO_ID != ''))
{
if (($urlstr == ''))
{
$urlstr = ('TO_ID='.$TO_ID);
}
else
{
$urlstr = (($urlstr.'&TO_ID=').$TO_ID);
}
$TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
($WHERE_STR .= (((''.' and e.DEPT_ID in (').$TO_ID).')'));
}
if (($CUSTOMER_NAME != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CUSTOMER_NAME='.$CUSTOMER_NAME);
}
else
{
$urlstr = (($urlstr.'&CUSTOMER_NAME=').$CUSTOMER_NAME);
}
($WHERE_STR .= ((' and b.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
}
if (($CUSTOMER_CODE != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CUSTOMER_CODE='.$CUSTOMER_CODE);
}
else
{
$urlstr = (($urlstr.'&CUSTOMER_CODE=').$CUSTOMER_CODE);
}
($WHERE_STR .= ((' and b.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
}
if (($CUSTOMER_SHORT != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CUSTOMER_SHORT='.$CUSTOMER_SHORT);
}
else
{
$urlstr = (($urlstr.'&CUSTOMER_SHORT=').$CUSTOMER_SHORT);
}
($WHERE_STR .= ((' and b.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
}
if (($CUSTOMER_AREA != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CUSTOMER_AREA='.$CUSTOMER_AREA);
}
else
{
$urlstr = (($urlstr.'&CUSTOMER_AREA=').$CUSTOMER_AREA);
}
($WHERE_STR .= ((' and b.CUSTOMER_AREA like \'%'.$CUSTOMER_AREA).'%\''));
}
if (($CUSTOMER_ADD != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CUSTOMER_ADD='.$CUSTOMER_ADD);
}
else
{
$urlstr = (($urlstr.'&CUSTOMER_ADD=').$CUSTOMER_ADD);
}
($WHERE_STR .= ((' and b.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
}
if (($SOURCE != ''))
{
if (($urlstr == ''))
{
$urlstr = ('SOURCE='.$SOURCE);
}
else
{
$urlstr = (($urlstr.'&SOURCE=').$SOURCE);
}
($WHERE_STR .= (((''.' and b.SOURCE =\'').$SOURCE).'\''));
}
if (($KIND != ''))
{
if (($urlstr == ''))
{
$urlstr = ('KIND='.$KIND);
}
else
{
$urlstr = (($urlstr.'&KIND=').$KIND);
}
($WHERE_STR .= (((''.' and b.KIND =\'').$KIND).'\''));
}
if (($SELLMODE != ''))
{
if (($urlstr == ''))
{
$urlstr = ('SELLMODE='.$SELLMODE);
}
else
{
$urlstr = (($urlstr.'&SELLMODE=').$SELLMODE);
}
($WHERE_STR .= (((''.' and b.SELLMODE =\'').$SELLMODE).'\''));
}
if (($ATTRIBUTE != ''))
{
if (($urlstr == ''))
{
$urlstr = ('ATTRIBUTE='.$ATTRIBUTE);
}
else
{
$urlstr = (($urlstr.'&ATTRIBUTE=').$ATTRIBUTE);
}
($WHERE_STR .= (((''.' and b.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
}
if (($ENTERTYPE != ''))
{
if (($urlstr == ''))
{
$urlstr = ('ENTERTYPE='.$ENTERTYPE);
}
else
{
$urlstr = (($urlstr.'&ENTERTYPE=').$ENTERTYPE);
}
($WHERE_STR .= (((''.' and b.ENTERTYPE =\'').$ENTERTYPE).'\''));
}
if (($ENTERMEMO != ''))
{
if (($urlstr == ''))
{
$urlstr = ('ENTERMEMO='.$ENTERMEMO);
}
else
{
$urlstr = (($urlstr.'&ENTERMEMO=').$ENTERMEMO);
}
($WHERE_STR .= ((' and b.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
}
if (($PRODUCT_NAME != ''))
{
if (($urlstr == ''))
{
$urlstr = ('PRODUCT_NAME='.$PRODUCT_NAME);
}
else
{
$urlstr = (($urlstr.'&PRODUCT_NAME=').$PRODUCT_NAME);
}
($WHERE_STR .= ((' and c.PRODUCT_NAME like \'%'.$PRODUCT_NAME).'%\''));
}
if (($PRODUCT_MODE != ''))
{
if (($urlstr == ''))
{
$urlstr = ('PRODUCT_MODE='.$PRODUCT_MODE);
}
else
{
$urlstr = (($urlstr.'&PRODUCT_MODE=').$PRODUCT_MODE);
}
($WHERE_STR .= (((''.' and c.PRODUCT_MODE =\'').$PRODUCT_MODE).'\''));
}
if (($PRODUCT_TYPE != ''))
{
if (($urlstr == ''))
{
$urlstr = ('PRODUCT_TYPE='.$PRODUCT_TYPE);
}
else
{
$urlstr = (($urlstr.'&PRODUCT_TYPE=').$PRODUCT_TYPE);
}
($WHERE_STR .= ((' and c.PRODUCT_TYPE like \'%'.$PRODUCT_TYPE).'%\''));
}
if (($SERVICE_NAME != ''))
{
if (($urlstr == ''))
{
$urlstr = ('SERVICE_NAME='.$SERVICE_NAME);
}
else
{
$urlstr = (($urlstr.'&SERVICE_NAME=').$SERVICE_NAME);
}
($WHERE_STR .= ((' and d.SERVICE_NAME like \'%'.$SERVICE_NAME).'%\''));
}
if (($SERVICE_DESC != ''))
{
if (($urlstr == ''))
{
$urlstr = ('SERVICE_DESC='.$SERVICE_DESC);
}
else
{
$urlstr = (($urlstr.'&SERVICE_DESC=').$SERVICE_DESC);
}
($WHERE_STR .= ((' and d.SERVICE_DESC like \'%'.$SERVICE_DESC).'%\''));
}
if (($DATE1 != ''))
{
if (($urlstr == ''))
{
$urlstr = ('DATE1='.$DATE1);
}
else
{
$urlstr = (($urlstr.'&DATE1=').$DATE1);
}
($WHERE_STR .= (((''.' and a.DATE>=\'').$DATE1).'\''));
}
if (($DATE2 != ''))
{
if (($urlstr == ''))
{
$urlstr = ('DATE2='.$DATE2);
}
else
{
$urlstr = (($urlstr.'&DATE2=').$DATE2);
}
($WHERE_STR .= (((''.' and a.DATE<=\'').$DATE2).'\''));
}
$query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'CUSTOMER\'';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$FIELDNO = ('CUSTOMER'.$ROW['FIELDNO']);
if (($$FIELDNO != ''))
{
$CUSTOMERID_STR = '';
if (($urlstr == ''))
{
$urlstr = (($FIELDNO.'=').$$FIELDNO);
}
else
{
$urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
}
$WHERE_STR1 = ((((' where TABLENAME=\'CUSTOMER\' 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 b.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
continue;
}
else
{
($WHERE_STR .= (((''.' and b.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
continue;
}
continue;
}
}
if (($ORDERFIELD != ''))
{
if (($ORDERSIGN == 'DOWN'))
{
$ORDERTYPE = 'ASC';
}
if (($ORDERSIGN == 'UP'))
{
$ORDERTYPE = 'DESC';
}
$OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
}
$CUSTOMER_COUNT = 0;
$query = ('SELECT count(*) from SALE_HISTORY a
LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE=\'PRO\'
LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE=\'SER\'
LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID
'.$WHERE_STR);
$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 c.PRODUCT_NAME as PRODUCT_NAME,d.SERVICE_NAME as SERVICE_NAME,a.PRICE as PRICE,a.AMT as AMT,a.TOTAL_PRICE as TOTAL_PRICE,a.DATE as DATE,e.USER_NAME as SELLER,b.CUSTOMER_NAME as CUSTOMER_NAME,a.HISTORY_ID as HISTORY_ID,a.TYPE as TYPE
from SALE_HISTORY a
LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE=\'PRO\'
LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE=\'SER\'
LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID
'.$WHERE_STR).$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;
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?