📄 list1.php
字号:
}
if($PRODUCT_NAME!="")
{
$urlstr=$urlstr."&PRODUCT_NAME=".$PRODUCT_NAME;
$WHERE_STR.=" and k.PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
}
if($PRODUCT_MODE!="")
{
$urlstr=$urlstr."&PRODUCT_MODE=".$PRODUCT_MODE;
$WHERE_STR.=" and k.PRODUCT_MODE ='$PRODUCT_MODE'";
}
if($PRODUCT_TYPE!="")
{
$urlstr=$urlstr."&PRODUCT_TYPE=".$PRODUCT_TYPE;
$WHERE_STR.=" and k.PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
}
if($SERVICE_NAME!="")
{
$urlstr=$urlstr."&SERVICE_NAME=".$SERVICE_NAME;
$WHERE_STR.=" and l.SERVICE_NAME like '%".$SERVICE_NAME."%'";
}
if($SERVICE_DESC!="")
{
$urlstr=$urlstr."&SERVICE_DESC=".$SERVICE_DESC;
$WHERE_STR.=" and l.SERVICE_DESC like '%".$SERVICE_DESC."%'";
}
if($DATE1!="")
{
$urlstr=$urlstr."&DATE1=".$DATE1;
$WHERE_STR.=" and j.DATE>='$DATE1'";
}
if($DATE2!="")
{
$urlstr=$urlstr."&DATE2=".$DATE2;
$WHERE_STR.=" and j.DATE<='$DATE2'";
}
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
from SALE_HISTORY j
LEFT OUTER JOIN CUSTOMER a
ON j.CUSTOMER_ID=a.CUSTOMER_ID
LEFT OUTER JOIN SYS_CODE b
ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'
LEFT OUTER JOIN SYS_CODE c
ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'
LEFT OUTER JOIN SYS_CODE d
ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'
LEFT OUTER JOIN SYS_CODE e
ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'
LEFT OUTER JOIN SYS_CODE f
ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'
LEFT OUTER JOIN SYS_CODE g
ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'
LEFT OUTER JOIN USER h ON j.SALESMAN = h.USER_ID
LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID
LEFT OUTER JOIN PRODUCT k ON j.PRODUCT_ID=k.PRODUCT_ID and j.TYPE='PRO'
LEFT OUTER JOIN SYS_CODE m
ON k.PRODUCT_TYPE = m.CODE_NO AND m.PARENT_NO = 'PRODUCT_MODE'
LEFT OUTER JOIN SERVICE l ON j.SERVICE_ID=l.SERVICE_ID and j.TYPE='SER'
".$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
from SALE_HISTORY j
LEFT OUTER JOIN CUSTOMER a
ON j.CUSTOMER_ID=a.CUSTOMER_ID
LEFT OUTER JOIN SYS_CODE b
ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'
LEFT OUTER JOIN SYS_CODE c
ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'
LEFT OUTER JOIN SYS_CODE d
ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'
LEFT OUTER JOIN SYS_CODE e
ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'
LEFT OUTER JOIN SYS_CODE f
ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'
LEFT OUTER JOIN SYS_CODE g
ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'
LEFT OUTER JOIN USER h ON j.SALESMAN = h.USER_ID
LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID
LEFT OUTER JOIN PRODUCT k ON j.PRODUCT_ID=k.PRODUCT_ID and j.TYPE='PRO'
LEFT OUTER JOIN SYS_CODE m
ON k.PRODUCT_MODE=m.CODE_NO AND m.PARENT_NO = 'PRODUCT_MODE'
LEFT OUTER JOIN SERVICE l ON j.SERVICE_ID=l.SERVICE_ID and j.TYPE='SER'
".$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0].$OREDERBY;
}
$cursor1 = exequery($connection, $query1);
?>
<div align="center">
<table border="0" cellspacing="1" width="70%" class="small" bgcolor="#000000" cellpadding="3">
<?
$CUSTOMER_COUNT=0;
$TOTAL_SUMSALE=0;
$TOTAL_PRO_PRICE=0;
$TOTAL_SER_PRICE=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=$TOTAL_SUMSALE+$SUMSALE;
$TOTAL_PRO_PRICE=$TOTAL_PRO_PRICE+$PRO_PRICE;
$TOTAL_SER_PRICE=$TOTAL_SER_PRICE+$SER_PRICE;
$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($CUSTOMER_COUNT==1)
{
?>
<tr class="TableControl">
<td nowrap align="center" colspan=4><img src="/images/cake.gif" WIDTH="20" HEIGHT="18" align="absmiddle" border=0 title="饼状图"> <input type="radio" name='FLAG' id='FLAG1' value="a" checked onclick="return chk(this,'graphValuesa');"><label for="FLAG1">销售总额</label> <input type="radio" name='FLAG' id='FLAG2' value="b" onclick="return chk(this,'graphValuesb');"><label for="FLAG2">产品销售额</label> <input type="radio" name='FLAG' id='FLAG3' value="c" onclick="return chk(this,'graphValuesc');"><label for="FLAG3">服务销售额</label></td>
</tr>
<tr class="TableControl">
<td nowrap align="center" colspan=4><img src="/images/finance1.gif" WIDTH="20" HEIGHT="18" align="absmiddle" border=0 title="柱状图"> <input type="radio" name='FLAG' id='FLAG4' value="a" onclick="return chk(this,'graphValuesd');"><label for="FLAG4">销售总额</label> <input type="radio" name='FLAG' id='FLAG5' value="b" onclick="return chk(this,'graphValuese');"><label for="FLAG5">产品销售额</label> <input type="radio" name='FLAG' id='FLAG6' value="c" onclick="return chk(this,'graphValuesf');"><label for="FLAG6">服务销售额</label></td>
</tr>
<tr class="TableHeader">
<td nowrap align="center"><a href="list1.php?SUMFIELD=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=SUMNAME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>"><?=$TYPENAME_ARRAY[2]?> <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SUMNAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SUMNAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list1.php?SUMFIELD=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=SUMSALE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">销售总额 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SUMSALE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SUMSALE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list1.php?SUMFIELD=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=PRO_PRICE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">产品销售额 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="PRO_PRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PRO_PRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list1.php?SUMFIELD=<?=$SUMFIELD?>&<?=$urlstr?>&ORDERFIELD=SER_PRICE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">服务销售额 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SER_PRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SER_PRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
</tr>
<?
}
if($CUSTOMER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$SUMNAME?></td>
<td nowrap align="center"><?=$SUMSALE?></td>
<td nowrap align="center"><?=$PRO_PRICE?></td>
<td nowrap align="center"><?=$SER_PRICE?></td>
</tr>
<?
}
?>
<tr class="TableHeader">
<td nowrap align="center">合计：</td>
<td nowrap align="center"><?=$TOTAL_SUMSALE?></td>
<td nowrap align="center"><?=$TOTAL_PRO_PRICE?></td>
<td nowrap align="center"><?=$TOTAL_SER_PRICE?></td>
</tr>
<br>
<div align="center">
<img id="graphValuesa" src="statics/cakeimg.php?ARRAY_FIELD1=<?=$ARRAY_FIELD?>&graphValues1=<?=$graphValues1?>&MODULENAME=销售总额">
<img id="graphValuesb" style="display:none" src="statics/cakeimg.php?ARRAY_FIELD1=<?=$ARRAY_FIELD?>&graphValues1=<?=$graphValues2?>&MODULENAME=产品销售额">
<img id="graphValuesc" style="display:none" src="statics/cakeimg.php?ARRAY_FIELD1=<?=$ARRAY_FIELD?>&graphValues1=<?=$graphValues3?>&MODULENAME=服务销售额">
<img id="graphValuesd" style="display:none" src="statics/staticspaint.php?ARRAY_FIELD1=<?=$ARRAY_FIELD?>&graphValues1=<?=$graphValues1?>&MODULENAME=销售总额">
<img id="graphValuese" style="display:none" src="statics/staticspaint.php?ARRAY_FIELD1=<?=$ARRAY_FIELD?>&graphValues1=<?=$graphValues2?>&MODULENAME=产品销售额">
<img id="graphValuesf" style="display:none" src="statics/staticspaint.php?ARRAY_FIELD1=<?=$ARRAY_FIELD?>&graphValues1=<?=$graphValues3?>&MODULENAME=产品销售额">
</div>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -