📄 list.php
字号:
$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 a.CUSTOMER_ID in (".$CUSTOMERID_STR.")";
}
else
{
$WHERE_STR .= " and a.CUSTOMER_ID in (".$CUSTOMERID_STR.")";
}
}
}
if ( $ORDERFIELD != "" )
{
if ( $ORDERSIGN == "DOWN" )
{
$ORDERTYPE = "ASC";
}
if ( $ORDERSIGN == "UP" )
{
$ORDERTYPE = "DESC";
}
$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
if ( $flagstr != "" )
{
$query1 = "SELECT ".$TYPENAME_ARRAY[1]." as SUMNAME, sum(j.TOTAL_PRICE) AS SUMSALE,sum(j.AMT) as PRO_QTY,sum(j.AMT*PRICE) as PRO_PRICE,(sum(j.TOTAL_PRICE)-sum(j.AMT*PRICE)) as SER_PRICE,CONCAT_WS('/',".$flagstr.") as WHNAME,".$TYPENAME_ARRAY[0]." as KINDID\r\n from SALE_HISTORY j\r\n LEFT OUTER JOIN CUSTOMER a\r\n ON j.CUSTOMER_ID=a.CUSTOMER_ID\r\n LEFT OUTER JOIN SYS_CODE b\r\n ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n LEFT OUTER JOIN SYS_CODE c\r\n ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n LEFT OUTER JOIN SYS_CODE d\r\n ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\r\n LEFT OUTER JOIN SYS_CODE e\r\n ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'\r\n LEFT OUTER JOIN SYS_CODE f\r\n ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'\r\n LEFT OUTER JOIN SYS_CODE g\r\n ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'\r\n LEFT OUTER JOIN USER h ON j.SALESMAN = h.USER_ID\r\n LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID\r\n LEFT OUTER JOIN PRODUCT k ON j.PRODUCT_ID=k.PRODUCT_ID and j.TYPE='PRO'\r\n LEFT OUTER JOIN SYS_CODE m\r\n ON k.PRODUCT_TYPE = m.CODE_NO AND m.PARENT_NO = 'PRODUCT_MODE'\r\n LEFT OUTER JOIN SERVICE l ON j.SERVICE_ID=l.SERVICE_ID and j.TYPE='SER'\r\n ".$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0].$OREDERBY;
}
else
{
$query1 = "SELECT ".$TYPENAME_ARRAY[1]." as SUMNAME, sum(j.TOTAL_PRICE) AS SUMSALE,sum(j.AMT) as PRO_QTY,sum(j.AMT*PRICE) as PRO_PRICE,(sum(j.TOTAL_PRICE)-sum(j.AMT*PRICE)) as SER_PRICE,".$TYPENAME_ARRAY[0]." as KINDID\r\n from SALE_HISTORY j\r\n LEFT OUTER JOIN CUSTOMER a\r\n ON j.CUSTOMER_ID=a.CUSTOMER_ID\r\n LEFT OUTER JOIN SYS_CODE b\r\n ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n LEFT OUTER JOIN SYS_CODE c\r\n ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n LEFT OUTER JOIN SYS_CODE d\r\n ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\r\n LEFT OUTER JOIN SYS_CODE e\r\n ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'\r\n LEFT OUTER JOIN SYS_CODE f\r\n ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'\r\n LEFT OUTER JOIN SYS_CODE g\r\n ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'\r\n LEFT OUTER JOIN USER h ON j.SALESMAN = h.USER_ID\r\n LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID\r\n LEFT OUTER JOIN PRODUCT k ON j.PRODUCT_ID=k.PRODUCT_ID and j.TYPE='PRO'\r\n LEFT OUTER JOIN SYS_CODE m\r\n ON k.PRODUCT_MODE=m.CODE_NO AND m.PARENT_NO = 'PRODUCT_MODE'\r\n LEFT OUTER JOIN SERVICE l ON j.SERVICE_ID=l.SERVICE_ID and j.TYPE='SER'\r\n ".$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0].$OREDERBY;
}
$cursor1 = exequery( $connection, $query1 );
echo "<br>\r\n<div align=\"center\">\r\n\r\n\r\n\r\n";
$CUSTOMER_COUNT = 0;
$TOTAL_SUMSALE = 0;
$TOTAL_PRO_PRICE = 0;
$TOTAL_SER_PRICE = 0;
$TOTAL_PRO_QTY = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
++$CUSTOMER_COUNT;
$SUMNAME = $ROW['SUMNAME'];
$SUMSALE = $ROW['SUMSALE'];
$PRO_QTY = $ROW['PRO_QTY'];
$PRO_PRICE = $ROW['PRO_PRICE'];
$SER_PRICE = $ROW['SER_PRICE'];
$TOTAL_SUMSALE += $SUMSALE;
$TOTAL_PRO_PRICE += $PRO_PRICE;
$TOTAL_SER_PRICE += $SER_PRICE;
$TOTAL_PRO_QTY += $PRO_QTY;
$WHNAME = $ROW['WHNAME'];
if ( $WHNAME != "" )
{
$WHNAME = "(".$WHNAME.")";
}
if ( $SUMNAME == "" )
{
$SUMNAME = "其他";
}
else
{
$ARRAY_FIELD = $ARRAY_FIELD.$SUMNAME.",";
$graphValues1 = $graphValues1.$SUMSALE.",";
$graphValues2 = $graphValues2.$PRO_PRICE.",";
$graphValues3 = $graphValues3.$SER_PRICE.",";
}
if ( $TEMPMONTH == "1" )
{
if ( $urlstr == "" )
{
$WHERE_STR1 = "strwhr1=month&strvalue=".$ROW['KINDID']."&TYPENAME=".$SUMNAME."&TYPEIDNAME=".$TYPENAME_ARRAY[2];
}
else
{
$WHERE_STR1 = $urlstr."&strvalue=".$ROW['KINDID']."&strwhr1=month&TYPENAME=".$SUMNAME."&TYPEIDNAME=".$TYPENAME_ARRAY[2];
}
}
else if ( $urlstr == "" )
{
$WHERE_STR1 = "strwhr1=".$TYPENAME_ARRAY[0]."&strvalue=".$ROW['KINDID']."&TYPENAME=".$SUMNAME."&TYPEIDNAME=".$TYPENAME_ARRAY[2];
}
else
{
$WHERE_STR1 = $urlstr."&strvalue=".$ROW['KINDID']."&strwhr1=".$TYPENAME_ARRAY[0]."&TYPENAME=".$SUMNAME."&TYPEIDNAME=".$TYPENAME_ARRAY[2];
}
if ( $CUSTOMER_COUNT == 1 )
{
echo " <table width=\"70%\" class=\"TableBlock\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\"><a href=\"list.php?SUMFIELD=";
echo $SUMFIELD;
echo "&";
echo $urlstr;
echo "&ORDERFIELD=SUMNAME&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 "\">";
echo $TYPENAME_ARRAY[2];
echo " ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "SUMNAME" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SUMNAME" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\"><a href=\"list.php?SUMFIELD=";
echo $SUMFIELD;
echo "&";
echo $urlstr;
echo "&ORDERFIELD=SUMSALE&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" && $ORDERFIELD == "SUMSALE" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SUMSALE" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\"><a href=\"list.php?SUMFIELD=";
echo $SUMFIELD;
echo "&";
echo $urlstr;
echo "&ORDERFIELD=PRO_PRICE&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" && $ORDERFIELD == "PRO_PRICE" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "PRO_PRICE" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\"><a href=\"list.php?SUMFIELD=";
echo $SUMFIELD;
echo "&";
echo $urlstr;
echo "&ORDERFIELD=PRO_QTY&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" && $ORDERFIELD == "PRO_QTY" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "PRO_QTY" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\"><a href=\"list.php?SUMFIELD=";
echo $SUMFIELD;
echo "&";
echo $urlstr;
echo "&ORDERFIELD=SER_PRICE&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" && $ORDERFIELD == "SER_PRICE" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SER_PRICE" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\">进一步统计</td>\r\n </tr>\r\n";
}
if ( $CUSTOMER_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
echo $SUMNAME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $SUMSALE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $PRO_PRICE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $PRO_QTY;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $SER_PRICE;
echo "</td>\r\n <td nowrap align=\"left\">\r\n <div align=\"center\"><input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "1' value=\"YEAR(j.DATE),YEAR(j.DATE),年\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "1\">年</label> \r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "2' value=\"MONTH,MONTH,月\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "2\">月</label> \r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "3' value=\"a.CUSTOMER_AREA,d.CODE_NAME,地区\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "3\">地区</label> \r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "4' value=\"j.CUSTOMER_ID,a.CUSTOMER_NAME,客户\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "4\">客户</label>\r\n <br></div>\r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "5' value=\"h.DEPT_ID,i.DEPT_NAME,销售部门\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "5\">销售部门</label> \r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "6' value=\"h.USER_NAME,h.USER_NAME,销售人员\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "6\">销售人员</label> \r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "7' value=\"j.PRODUCT_ID,k.PRODUCT_NAME,产品名称\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "7\">产品名称</label> \r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "8' value=\"k.PRODUCT_MODE,m.CODE_NAME,产品类别\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "8\">产品类别</label> \r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "9' value=\"j.SERVICE_ID,l.SERVICE_NAME,服务名称\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "9\">服务名称</label>\r\n <br>\r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "10' value=\"a.SOURCE,e.CODE_NAME,客户来源\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "10\">客户来源</label> \r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "11' value=\"a.KIND,c.CODE_NAME,客户类别\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "11\">客户类别</label> \r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "12' value=\"a.SELLMODE,b.CODE_NAME,销售方式\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "12\">销售方式</label>\r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "13' value=\"a.ATTRIBUTE,f.CODE_NAME,行业属性\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "13\">行业属性</label> \r\n <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
echo $CUSTOMER_COUNT;
echo "14' value=\"a.ENTERTYPE,g.CODE_NAME,企业性质\" onclick=\"return chk(this,'";
echo $WHERE_STR1;
echo "');\"><label for=\"SUMFIELD";
echo $CUSTOMER_COUNT;
echo "14\">企业性质</label> \r\n </td>\r\n </tr>\r\n\r\n";
}
if ( $CUSTOMER_COUNT == 0 )
{
message( "", "无满足条件的销售记录" );
button_back( );
exit( );
}
echo " <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">合计：</td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_SUMSALE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_PRO_PRICE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_PRO_QTY;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_SER_PRICE;
echo "</td>\r\n <td nowrap align=\"center\"></td>\r\n </tr>\r\n\r\n<tr class=\"TableHeader\">\r\n <td nowrap align=\"center\" colspan=5>统计图</td>\r\n <td nowrap align=\"center\"><a href=\"javascript:LoadWindow1('";
echo $ARRAY_FIELD;
echo "','";
echo $graphValues1;
echo "','";
echo $graphValues2;
echo "','";
echo $graphValues3;
echo "','";
echo $TYPENAME_ARRAY[2];
echo "','1');\"><img src=\"/images/finance1.gif\" align=\"absmiddle\" WIDTH=\"22\" HEIGHT=\"22\" border=0 title=\"柱状图\"></a>\r\n <a href=\"javascript:LoadWindow1('";
echo $ARRAY_FIELD;
echo "','";
echo $graphValues1;
echo "','";
echo $graphValues2;
echo "','";
echo $graphValues3;
echo "','";
echo $TYPENAME_ARRAY[2];
echo "','2');\"><img src=\"/images/cake.gif\" align=\"absmiddle\" WIDTH=\"22\" HEIGHT=\"22\" border=0 title=\"饼状图\"></a></td>\r\n</tr>\r\n\r\n</table>\r\n</div>\r\n<br>\r\n<div align=\"center\">\r\n<input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='index.php'\">\r\n</div>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -