list1.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 712 行 · 第 1/2 页
PHP
712 行
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);
echo '<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;
$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 = ($TOTAL_SUMSALE + $SUMSALE);
$TOTAL_PRO_PRICE = ($TOTAL_PRO_PRICE + $PRO_PRICE);
$TOTAL_SER_PRICE = ($TOTAL_SER_PRICE + $SER_PRICE);
$TOTAL_PRO_QTY = ($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).',');
$graphValues4 = (($graphValues4.$PRO_QTY).',');
}
if (($CUSTOMER_COUNT == 1))
{
echo ' <tr class="TableControl">
<td nowrap align="center" colspan=5><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=';
echo '"return chk(this,\'graphValuesb\');"><label for="FLAG2">产品销售额</label> <input type="radio" name=\'FLAG\' id=\'FLAG7\' value="d" onclick="return chk(this,\'graphValuesg\');"><label for="FLAG7">产品销售数量</label> <input type="radio" name=\'FLAG\' id=\'FLAG3\' value="c" onclick="return chk(this,\'graphValuesc\');"><label for="FLAG3">服务销售额</label></td>
</tr>
<tr class="TableControl';
echo '">
<td nowrap align="center" colspan=5><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';
echo '\');"><label for="FLAG5">产品销售额</label> <input type="radio" name=\'FLAG\' id=\'FLAG8\' value="d" onclick="return chk(this,\'graphValuesh\');"><label for="FLAG8">产品销售数量</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="cent';
echo 'er"><a href="list1.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') AND ($ORDERFIELD == 'SUMNAME')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SUMNAME')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list1.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') AND ($ORDERFIELD == 'SUMSALE')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SUMSALE')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list1.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') AND ($ORDERFIELD == 'PRO_PRICE')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'PRO_PRICE')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<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') AND ($ORDERFIELD == 'PRO_QTY')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'PRO_QTY')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list1.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') AND ($ORDERFIELD == 'SER_PRICE')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SER_PRICE')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
</tr>
';
}
if ((($CUSTOMER_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $SUMNAME;
echo '</td>
<td nowrap align="center">';
echo $SUMSALE;
echo '</td>
<td nowrap align="center">';
echo $PRO_PRICE;
echo '</td>
<td nowrap align="center">';
echo $PRO_QTY;
echo '</td>
<td nowrap align="center">';
echo $SER_PRICE;
echo '</td>
</tr>
';
}
echo ' <tr class="TableHeader">
<td nowrap align="center">合计：</td>
<td nowrap align="center">';
echo $TOTAL_SUMSALE;
echo '</td>
<td nowrap align="center">';
echo $TOTAL_PRO_PRICE;
echo '</td>
<td nowrap align="center">';
echo $TOTAL_PRO_QTY;
echo '</td>
<td nowrap align="center">';
echo $TOTAL_SER_PRICE;
echo '</td>
</tr>
<br>
<div align="center">
<img id="graphValuesa" src="statics/cakeimg.php?ARRAY_FIELD1=';
echo $ARRAY_FIELD;
echo '&graphValues1=';
echo $graphValues1;
echo '&MODULENAME=销售总额">
<img id="graphValuesb" style="display:none" src="statics/cakeimg.php?ARRAY_FIELD1=';
echo $ARRAY_FIELD;
echo '&graphValues1=';
echo $graphValues2;
echo '&MODULENAME=产品销售额">
<img id="graphValuesc" style="display:none" src="statics/cakeimg.php?ARRAY_FIELD1=';
echo $ARRAY_FIELD;
echo '&graphValues1=';
echo $graphValues3;
echo '&MODULENAME=服务销售额">
<img id="graphValuesg" style="display:none" src="statics/cakeimg.php?ARRAY_FIELD1=';
echo $ARRAY_FIELD;
echo '&graphValues1=';
echo $graphValues4;
echo '&MODULENAME=产品销售数量">
<img id="graphValuesd" style="display:none" src="statics/staticspaint.php?ARRAY_FIELD1=';
echo $ARRAY_FIELD;
echo '&graphValues1=';
echo $graphValues1;
echo '&MODULENAME=销售总额">
<img id="graphValuese" style="display:none" src="statics/staticspaint.php?ARRAY_FIELD1=';
echo $ARRAY_FIELD;
echo '&graphValues1=';
echo $graphValues2;
echo '&MODULENAME=产品销售额">
<img id="graphValuesf" style="display:none" src="statics/staticspaint.php?ARRAY_FIELD1=';
echo $ARRAY_FIELD;
echo '&graphValues1=';
echo $graphValues3;
echo '&MODULENAME=产品销售额">
<img id="graphValuesh" style="display:none" src="statics/staticspaint.php?ARRAY_FIELD1=';
echo $ARRAY_FIELD;
echo '&graphValues1=';
echo $graphValues4;
echo '&MODULENAME=产品销售数量">
</div>
</table>
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?