📄 list.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$PAGE_SIZE = 10;
echo "\r\n<html>\r\n<head>\r\n<title>销售记录查询结果 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script Language=\"JavaScript\">\r\nfunction set_page(urlstr)\r\n{\r\n PAGE_START=PAGE_NUM.value;\r\n location=\"list.php?\"+urlstr+\"&CUR_PAGE=\"+PAGE_START+\"&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\";\r\n}\r\n</script>\r\n</head>\r\n";
$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.")";
}
else
{
$WHERE_STR .= " and b.CUSTOMER_ID in (".$CUSTOMERID_STR.")";
}
}
}
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\r\n LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID\r\n LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'\r\n LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'\r\n LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID\r\n ".$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 || $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,a.MEMO as MEMO\r\n from SALE_HISTORY a\r\n LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID\r\n LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'\r\n LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'\r\n LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID\r\n ".$WHERE_STR.$OREDERBY;
$offest = ( $CUR_PAGE - 1 ) * 10;
if ( $offest < 0 )
{
$offest = 0;
}
$query1 = $query1." LIMIT ".$offest." ,".$PER_PAGE;
$cursor1 = exequery( $connection, $query1 );
if ( $CUSTOMER_COUNT == 0 )
{
message( "<br>提示", "没有符合条件的销售记录" );
button_back( );
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=\"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>\r\n <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>\r\n <a href=\"list.php?";
echo $urlstr;
echo "&CUR_PAGE=";
echo $CUR_PAGE + 1;
echo "&ORDERFIELD=";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -