📄 list.php
字号:
<?php
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\">\r\n<script Language=\"JavaScript\">\r\nfunction chk(input,strwher)\r\n{\r\n URL=\"list1.php?\"+strwher+\"&SUMFIELD=\"+input.value;\r\n myleft=(screen.availWidth-1250)/2;\r\n window.open(URL,\"formul_edit\",\"height=600,width=1000,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=50,left=\"+myleft+\",resizable=yes\");\r\n}\r\nfunction LoadWindow1(ARRAY_FIELD,graphValues1,graphValues2,graphValues3,showname,type)\r\n{ \r\n URL=\"statics?ARRAY_FIELD=\"+ARRAY_FIELD+\"&graphValues1=\"+graphValues1+\"&graphValues2=\"+graphValues2+\"&graphValues3=\"+graphValues3+\"&showname=\"+showname+\"&type=\"+type; \r\n myleft=(screen.availWidth-1250)/2;\r\n window.open(URL,\"formul_edit\",\"height=600,width=1000,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=50,left=\"+myleft+\",resizable=yes\");\r\n}\r\n</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/notify_open.gif\" WIDTH=\"22\" HEIGHT=\"22\" align=\"absmiddle\"><span class=\"big3\"> 销售统计结果</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n";
$TYPENAME_ARRAY = explode( ",", $SUMFIELD );
if ( $TYPENAME_ARRAY[0] == "MONTH" )
{
$TYPENAME_ARRAY[0] = "CONCAT_WS('-', YEAR(j.DATE) , MONTH(j.DATE))";
$TYPENAME_ARRAY[1] = "CONCAT_WS('-', YEAR(j.DATE) , MONTH(j.DATE))";
$TEMPMONTH = "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 ) )."'";
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.SALESMAN in (".$COPY_TO_ID.")";
}
else
{
$WHERE_STR .= " and j.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 ) )."'";
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where h.DEPT_ID in (".$TO_ID.")";
}
else
{
$WHERE_STR .= " and h.DEPT_ID in (".$TO_ID.")";
}
}
if ( $CUSTOMER_NAME != "" )
{
if ( $urlstr == "" )
{
$urlstr = "CUSTOMER_NAME=".$CUSTOMER_NAME;
}
else
{
$urlstr = $urlstr."&CUSTOMER_NAME=".$CUSTOMER_NAME;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
}
else
{
$WHERE_STR .= " and a.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
}
}
if ( $CUSTOMER_CODE != "" )
{
if ( $urlstr == "" )
{
$urlstr = "CUSTOMER_CODE=".$CUSTOMER_CODE;
}
else
{
$urlstr = $urlstr."&CUSTOMER_CODE=".$CUSTOMER_CODE;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
}
else
{
$WHERE_STR .= " and a.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
}
}
if ( $CUSTOMER_SHORT != "" )
{
if ( $urlstr == "" )
{
$urlstr = "CUSTOMER_SHORT=".$CUSTOMER_SHORT;
}
else
{
$urlstr = $urlstr."&CUSTOMER_SHORT=".$CUSTOMER_SHORT;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
}
else
{
$WHERE_STR .= " and a.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
}
}
if ( $CUSTOMER_AREA != "" )
{
if ( $urlstr == "" )
{
$urlstr = "CUSTOMER_AREA=".$CUSTOMER_AREA;
}
else
{
$urlstr = $urlstr."&CUSTOMER_AREA=".$CUSTOMER_AREA;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.CUSTOMER_AREA='".$CUSTOMER_AREA."'";
}
else
{
$WHERE_STR .= " and a.CUSTOMER_AREA='".$CUSTOMER_AREA."'";
}
}
if ( $CUSTOMER_ADD != "" )
{
if ( $urlstr == "" )
{
$urlstr = "CUSTOMER_ADD=".$CUSTOMER_ADD;
}
else
{
$urlstr = $urlstr."&CUSTOMER_ADD=".$CUSTOMER_ADD;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
}
else
{
$WHERE_STR .= " and a.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
}
}
if ( $SOURCE != "" )
{
if ( $flagstr == "" )
{
$flagstr = "e.CODE_NAME";
}
else
{
$flagstr .= ",e.CODE_NAME";
}
if ( $urlstr == "" )
{
$urlstr = "SOURCE=".$SOURCE;
}
else
{
$urlstr = $urlstr."&SOURCE=".$SOURCE;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.SOURCE ='".$SOURCE."'";
}
else
{
$WHERE_STR .= " and a.SOURCE ='".$SOURCE."'";
}
}
if ( $KIND != "" )
{
if ( $flagstr == "" )
{
$flagstr = "c.CODE_NAME";
}
else
{
$flagstr .= ",c.CODE_NAME";
}
if ( $urlstr == "" )
{
$urlstr = "KIND=".$KIND;
}
else
{
$urlstr = $urlstr."&KIND=".$KIND;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.KIND ='".$KIND."'";
}
else
{
$WHERE_STR .= " and a.KIND ='".$KIND."'";
}
}
if ( $SELLMODE != "" )
{
if ( $flagstr == "" )
{
$flagstr = "b.CODE_NAME";
}
else
{
$flagstr .= ",b.CODE_NAME";
}
if ( $urlstr == "" )
{
$urlstr = "SELLMODE=".$SELLMODE;
}
else
{
$urlstr = $urlstr."&SELLMODE=".$SELLMODE;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.SELLMODE ='".$SELLMODE."'";
}
else
{
$WHERE_STR .= " and a.SELLMODE ='".$SELLMODE."'";
}
}
if ( $ATTRIBUTE != "" )
{
if ( $urlstr == "" )
{
$urlstr = "ATTRIBUTE=".$ATTRIBUTE;
}
else
{
$urlstr = $urlstr."&ATTRIBUTE=".$ATTRIBUTE;
}
if ( $flagstr == "" )
{
$flagstr = "f.CODE_NAME";
}
else
{
$flagstr .= ",f.CODE_NAME";
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.ATTRIBUTE ='".$ATTRIBUTE."'";
}
else
{
$WHERE_STR .= " and a.ATTRIBUTE ='".$ATTRIBUTE."'";
}
}
if ( $ENTERTYPE != "" )
{
if ( $urlstr == "" )
{
$urlstr = "ENTERTYPE=".$ENTERTYPE;
}
else
{
$urlstr = $urlstr."&ENTERTYPE=".$ENTERTYPE;
}
if ( $flagstr == "" )
{
$flagstr = "g.CODE_NAME";
}
else
{
$flagstr .= ",g.CODE_NAME";
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.ENTERTYPE ='".$ENTERTYPE."'";
}
else
{
$WHERE_STR .= " and a.ENTERTYPE ='".$ENTERTYPE."'";
}
}
if ( $ENTERMEMO != "" )
{
if ( $urlstr == "" )
{
$urlstr = "ENTERMEMO=".$ENTERMEMO;
}
else
{
$urlstr = $urlstr."&ENTERMEMO=".$ENTERMEMO;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.ENTERMEMO like '%".$ENTERMEMO."%'";
}
else
{
$WHERE_STR .= " and a.ENTERMEMO like '%".$ENTERMEMO."%'";
}
}
if ( $PRODUCT_NAME != "" )
{
if ( $urlstr == "" )
{
$urlstr = "PRODUCT_NAME=".$PRODUCT_NAME;
}
else
{
$urlstr = $urlstr."&PRODUCT_NAME=".$PRODUCT_NAME;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where k.PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
}
else
{
$WHERE_STR .= " and k.PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
}
}
if ( $PRODUCT_MODE != "" )
{
if ( $urlstr == "" )
{
$urlstr = "PRODUCT_MODE=".$PRODUCT_MODE;
}
else
{
$urlstr = $urlstr."&PRODUCT_MODE=".$PRODUCT_MODE;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where k.PRODUCT_MODE ='".$PRODUCT_MODE."'";
}
else
{
$WHERE_STR .= " and k.PRODUCT_MODE ='".$PRODUCT_MODE."'";
}
}
if ( $PRODUCT_TYPE != "" )
{
if ( $urlstr == "" )
{
$urlstr = "PRODUCT_TYPE=".$PRODUCT_TYPE;
}
else
{
$urlstr = $urlstr."&PRODUCT_TYPE=".$PRODUCT_TYPE;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where k.PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
}
else
{
$WHERE_STR .= " and k.PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
}
}
if ( $SERVICE_NAME != "" )
{
if ( $urlstr == "" )
{
$urlstr = "SERVICE_NAME=".$SERVICE_NAME;
}
else
{
$urlstr = $urlstr."&SERVICE_NAME=".$SERVICE_NAME;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where l.SERVICE_NAME like '%".$SERVICE_NAME."%'";
}
else
{
$WHERE_STR .= " and l.SERVICE_NAME like '%".$SERVICE_NAME."%'";
}
}
if ( $SERVICE_DESC != "" )
{
if ( $urlstr == "" )
{
$urlstr = "SERVICE_DESC=".$SERVICE_DESC;
}
else
{
$urlstr = $urlstr."&SERVICE_DESC=".$SERVICE_DESC;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where l.SERVICE_DESC like '%".$SERVICE_DESC."%'";
}
else
{
$WHERE_STR .= " and l.SERVICE_DESC like '%".$SERVICE_DESC."%'";
}
}
if ( $DATE1 != "" )
{
if ( $urlstr == "" )
{
$urlstr = "DATE1=".$DATE1;
}
else
{
$urlstr = $urlstr."&DATE1=".$DATE1;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.DATE>='".$DATE1."'";
}
else
{
$WHERE_STR .= " and j.DATE>='".$DATE1."'";
}
}
if ( $DATE2 != "" )
{
if ( $urlstr == "" )
{
$urlstr = "DATE2=".$DATE2;
}
else
{
$urlstr = $urlstr."&DATE2=".$DATE2;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.DATE<='".$DATE2."'";
}
else
{
$WHERE_STR .= " and j.DATE<='".$DATE2."'";
}
}
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='CUSTOMER'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -