list1.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 712 行 · 第 1/2 页
PHP
712 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$PAGE_SIZE = 10;
echo '<html>
<head>
<title>销售额统计结果 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript Language="JavaScript">
function chk(input,strwher)
{
if(strwher=="graphValuesa")
{document.all.graphValuesa.style.display=\'\';
document.all.graphValuesb.style.display=\'none\';
document.all.graphValuesc.style.display=\'none\';
document.all.graphValuesd.style.display=\'none\';
document.all.graphValuese.style.display=\'none\';
document.all.graphValue';
echo 'sf.style.display=\'none\';
document.all.graphValuesg.style.display=\'none\';
document.all.graphValuesh.style.display=\'none\';
}
if(strwher=="graphValuesb")
{document.all.graphValuesa.style.display=\'none\';
document.all.graphValuesb.style.display=\'\';
document.all.graphValuesc.style.display=\'none\';
document.all.graphValuesd.style.display=\'none\';
';
echo ' document.all.graphValuese.style.display=\'none\';
document.all.graphValuesf.style.display=\'none\';
document.all.graphValuesg.style.display=\'none\';
document.all.graphValuesh.style.display=\'none\';
}
if(strwher=="graphValuesc")
{
document.all.graphValuesa.style.display=\'none\';
document.all.graphValuesb.style.display=\'none\';
document.all.';
echo 'graphValuesc.style.display=\'\';
document.all.graphValuesd.style.display=\'none\';
document.all.graphValuese.style.display=\'none\';
document.all.graphValuesf.style.display=\'none\';
document.all.graphValuesg.style.display=\'none\';
document.all.graphValuesh.style.display=\'none\';
}
if(strwher=="graphValuesd")
{
document.all.graphValuesa.style.d';
echo 'isplay=\'none\';
document.all.graphValuesb.style.display=\'none\';
document.all.graphValuesc.style.display=\'none\';
document.all.graphValuesd.style.display=\'\';
document.all.graphValuese.style.display=\'none\';
document.all.graphValuesf.style.display=\'none\';
document.all.graphValuesg.style.display=\'none\';
document.all.graphValuesh.style.display=\'none\';
';
echo ' }
if(strwher=="graphValuese")
{
document.all.graphValuesa.style.display=\'none\';
document.all.graphValuesb.style.display=\'none\';
document.all.graphValuesc.style.display=\'none\';
document.all.graphValuesd.style.display=\'none\';
document.all.graphValuese.style.display=\'\';
document.all.graphValuesf.style.display=\'none\';
document.all.g';
echo 'raphValuesg.style.display=\'none\';
document.all.graphValuesh.style.display=\'none\';
}
if(strwher=="graphValuesf")
{
document.all.graphValuesa.style.display=\'none\';
document.all.graphValuesb.style.display=\'none\';
document.all.graphValuesc.style.display=\'none\';
document.all.graphValuesd.style.display=\'none\';
document.all.graphValuese.styl';
echo 'e.display=\'none\';
document.all.graphValuesf.style.display=\'\';
document.all.graphValuesg.style.display=\'none\';
document.all.graphValuesh.style.display=\'none\';
}
if(strwher=="graphValuesg")
{
document.all.graphValuesa.style.display=\'none\';
document.all.graphValuesb.style.display=\'none\';
document.all.graphValuesc.style.display=\'none\';
';
echo ' document.all.graphValuesd.style.display=\'none\';
document.all.graphValuese.style.display=\'none\';
document.all.graphValuesf.style.display=\'none\';
document.all.graphValuesg.style.display=\'\';
document.all.graphValuesh.style.display=\'none\';
}
if(strwher=="graphValuesh")
{
document.all.graphValuesa.style.display=\'none\';
document.';
echo 'all.graphValuesb.style.display=\'none\';
document.all.graphValuesc.style.display=\'none\';
document.all.graphValuesd.style.display=\'none\';
document.all.graphValuese.style.display=\'none\';
document.all.graphValuesf.style.display=\'none\';
document.all.graphValuesg.style.display=\'none\';
document.all.graphValuesh.style.display=\'\';
}
}
</script>
</';
echo 'head>
';
$TYPENAME_ARRAY = explode (',', $SUMFIELD);
$urlstr = ('strwhr1='.$strwhr1);
$urlstr = (($urlstr.'&strvalue=').$strvalue);
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))';
}
if (($strwhr1 == 'month'))
{
$WHERE_STR = (((''.' where CONCAT_WS(\'-\', YEAR(j.DATE) , MONTH(j.DATE))=\'').$strvalue).'\'');
}
else
{
$WHERE_STR = ((' where '.$strwhr1).(((''.'=\'').$strvalue).'\''));
}
if (($COPY_TO_ID != ''))
{
$urlstr = (($urlstr.'©_TO_ID=').$COPY_TO_ID);
$COPY_TO_ID = (('\''.str_replace (',', '\',\'', substr ($COPY_TO_ID, 0, -1))).'\'');
($WHERE_STR .= (((''.' and j.SALESMAN in (').$COPY_TO_ID).')'));
}
if (($TO_ID != ''))
{
$urlstr = (($urlstr.'&TO_ID=').$TO_ID);
$TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
($WHERE_STR .= (((''.' and h.DEPT_ID in (').$TO_ID).')'));
}
if (($CUSTOMER_NAME != ''))
{
$urlstr = (($urlstr.'&CUSTOMER_NAME=').$CUSTOMER_NAME);
($WHERE_STR .= ((' and a.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
}
if (($CUSTOMER_CODE != ''))
{
$urlstr = (($urlstr.'&CUSTOMER_CODE=').$CUSTOMER_CODE);
($WHERE_STR .= ((' and a.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
}
if (($CUSTOMER_SHORT != ''))
{
$urlstr = (($urlstr.'&CUSTOMER_SHORT=').$CUSTOMER_SHORT);
($WHERE_STR .= ((' and a.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
}
if (($CUSTOMER_AREA != ''))
{
$urlstr = (($urlstr.'&CUSTOMER_AREA=').$CUSTOMER_AREA);
($WHERE_STR .= (((''.' and a.CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\''));
}
if (($CUSTOMER_ADD != ''))
{
$urlstr = (($urlstr.'&CUSTOMER_ADD=').$CUSTOMER_ADD);
($WHERE_STR .= ((' and a.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
}
if (($SOURCE != ''))
{
$urlstr = (($urlstr.'&SOURCE=').$SOURCE);
if (($flagstr == ''))
{
$flagstr = 'e.CODE_NAME';
}
else
{
$flagstr = ($flagstr.',e.CODE_NAME');
}
($WHERE_STR .= (((''.' and a.SOURCE =\'').$SOURCE).'\''));
}
if (($KIND != ''))
{
$urlstr = (($urlstr.'&KIND=').$KIND);
if (($flagstr == ''))
{
$flagstr = 'c.CODE_NAME';
}
else
{
$flagstr = ($flagstr.',c.CODE_NAME');
}
($WHERE_STR .= (((''.' and a.KIND =\'').$KIND).'\''));
}
if (($SELLMODE != ''))
{
$urlstr = (($urlstr.'&SELLMODE=').$SELLMODE);
if (($flagstr == ''))
{
$flagstr = 'b.CODE_NAME';
}
else
{
$flagstr = ($flagstr.',b.CODE_NAME');
}
($WHERE_STR .= (((''.' and a.SELLMODE =\'').$SELLMODE).'\''));
}
if (($ATTRIBUTE != ''))
{
$urlstr = (($urlstr.'&ATTRIBUTE=').$ATTRIBUTE);
if (($flagstr == ''))
{
$flagstr = 'f.CODE_NAME';
}
else
{
$flagstr = ($flagstr.',f.CODE_NAME');
}
($WHERE_STR .= (((''.' and a.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
}
if (($ENTERTYPE != ''))
{
$urlstr = (($urlstr.'&ENTERTYPE=').$ENTERTYPE);
if (($flagstr == ''))
{
$flagstr = 'g.CODE_NAME';
}
else
{
$flagstr = ($flagstr.',g.CODE_NAME');
}
($WHERE_STR .= (((''.' and a.ENTERTYPE =\'').$ENTERTYPE).'\''));
}
if (($ENTERMEMO != ''))
{
$urlstr = (($urlstr.'&ENTERMEMO=').$ENTERMEMO);
($WHERE_STR .= ((' and a.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
}
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).'\''));
}
$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 a.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
continue;
}
else
{
($WHERE_STR .= (((''.' and a.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
continue;
}
continue;
}
}
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\'
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?