📄 list1.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$PAGE_SIZE = 10;
echo "\r\n<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 if(strwher==\"graphValuesa\")\r\n {document.all.graphValuesa.style.display='';\r\n \t document.all.graphValuesb.style.display='none';\r\n \t document.all.graphValuesc.style.display='none';\r\n \t document.all.graphValuesd.style.display='none';\r\n \t document.all.graphValuese.style.display='none';\r\n \t document.all.graphValuesf.style.display='none';\r\n \t }\r\n \t if(strwher==\"graphValuesb\")\r\n {document.all.graphValuesa.style.display='none';\r\n \t document.all.graphValuesb.style.display='';\r\n \t document.all.graphValuesc.style.display='none';\r\n \t document.all.graphValuesd.style.display='none';\r\n \t document.all.graphValuese.style.display='none';\r\n \t document.all.graphValuesf.style.display='none';\r\n \t }\r\n \t if(strwher==\"graphValuesc\")\r\n {\r\n document.all.graphValuesa.style.display='none';\r\n \t document.all.graphValuesb.style.display='none';\r\n \t document.all.graphValuesc.style.display='';\r\n \t document.all.graphValuesd.style.display='none';\r\n \t document.all.graphValuese.style.display='none';\r\n \t document.all.graphValuesf.style.display='none';\r\n \t }\r\n \t if(strwher==\"graphValuesd\")\r\n {\r\n document.all.graphValuesa.style.display='none';\r\n \t document.all.graphValuesb.style.display='none';\r\n \t document.all.graphValuesc.style.display='none';\r\n \t document.all.graphValuesd.style.display='';\r\n \t document.all.graphValuese.style.display='none';\r\n \t document.all.graphValuesf.style.display='none';\r\n \t }\r\n\r\n \t if(strwher==\"graphValuese\")\r\n {\r\n document.all.graphValuesa.style.display='none';\r\n \t document.all.graphValuesb.style.display='none';\r\n \t document.all.graphValuesc.style.display='none';\r\n \t document.all.graphValuesd.style.display='none';\r\n \t document.all.graphValuese.style.display='';\r\n \t document.all.graphValuesf.style.display='none';\r\n \t }\r\n\r\n \t if(strwher==\"graphValuesf\")\r\n {\r\n document.all.graphValuesa.style.display='none';\r\n \t document.all.graphValuesb.style.display='none';\r\n \t document.all.graphValuesc.style.display='none';\r\n \t document.all.graphValuesd.style.display='none';\r\n \t document.all.graphValuese.style.display='none';\r\n \t document.all.graphValuesf.style.display='';\r\n \t }\r\n\r\n\r\n }\r\n</script>\r\n</head>\r\n\r\n\r\n";
$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 ( $PROVIDER_NAME != "" )
{
$urlstr = $urlstr."&PROVIDER_NAME=".$PROVIDER_NAME;
$WHERE_STR .= " and a.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
if ( $PROVIDER_CODE != "" )
{
$urlstr = $urlstr."&PROVIDER_CODE=".$PROVIDER_CODE;
$WHERE_STR .= " and a.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
}
if ( $PROVIDER_SHORT != "" )
{
$urlstr = $urlstr."&PROVIDER_SHORT=".$PROVIDER_SHORT;
$WHERE_STR .= " and a.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
}
if ( $PROVIDER_AREA != "" )
{
$urlstr = $urlstr."&PROVIDER_AREA=".$PROVIDER_AREA;
$WHERE_STR .= " and a.PROVIDER_AREA='".$PROVIDER_AREA."'";
}
if ( $PROVIDER_ADD != "" )
{
$urlstr = $urlstr."&PROVIDER_ADD=".$PROVIDER_ADD;
$WHERE_STR .= " and a.PROVIDER_ADD like '%".$PROVIDER_ADD."%'";
}
if ( $SOURCE != "" )
{
$urlstr = $urlstr."&SOURCE=".$SOURCE;
if ( $flagstr == "" )
{
$flagstr = "e.CODE_NAME";
}
else
{
$flagstr .= ",e.CODE_NAME";
}
$WHERE_STR .= " and a.SOURCE ='".$SOURCE."'";
}
if ( $KIND != "" )
{
$urlstr = $urlstr."&KIND=".$KIND;
if ( $flagstr == "" )
{
$flagstr = "c.CODE_NAME";
}
else
{
$flagstr .= ",c.CODE_NAME";
}
$WHERE_STR .= " and a.KIND ='".$KIND."'";
}
if ( $SELLMODE != "" )
{
$urlstr = $urlstr."&SELLMODE=".$SELLMODE;
if ( $flagstr == "" )
{
$flagstr = "b.CODE_NAME";
}
else
{
$flagstr .= ",b.CODE_NAME";
}
$WHERE_STR .= " and a.SELLMODE ='".$SELLMODE."'";
}
if ( $ATTRIBUTE != "" )
{
$urlstr = $urlstr."&ATTRIBUTE=".$ATTRIBUTE;
if ( $flagstr == "" )
{
$flagstr = "f.CODE_NAME";
}
else
{
$flagstr .= ",f.CODE_NAME";
}
$WHERE_STR .= " and a.ATTRIBUTE ='".$ATTRIBUTE."'";
}
if ( $ENTERTYPE != "" )
{
$urlstr = $urlstr."&ENTERTYPE=".$ENTERTYPE;
if ( $flagstr == "" )
{
$flagstr = "g.CODE_NAME";
}
else
{
$flagstr .= ",g.CODE_NAME";
}
$WHERE_STR .= " and a.ENTERTYPE ='".$ENTERTYPE."'";
}
if ( $ENTERMEMO != "" )
{
$urlstr = $urlstr."&ENTERMEMO=".$ENTERMEMO;
$WHERE_STR .= " and a.ENTERMEMO like '%".$ENTERMEMO."%'";
}
if ( $PROVIDERUSERDEF1 != "" )
{
$urlstr = $urlstr."&PROVIDERUSERDEF1=".$PROVIDERUSERDEF1;
$WHERE_STR .= " and a.USERDEF1 like '%".$PROVIDERUSERDEF1."%'";
}
if ( $PROVIDERUSERDEF2 != "" )
{
$urlstr = $urlstr."&PROVIDERUSERDEF2=".$PROVIDERUSERDEF2;
$WHERE_STR .= " and a.USERDEF2 like '%".$PROVIDERUSERDEF2."%'";
}
if ( $PROVIDERUSERDEF3 != "" )
{
$urlstr = $urlstr."&PROVIDERUSERDEF3=".$PROVIDERUSERDEF3;
$WHERE_STR .= " and a.USERDEF3 like '%".$PROVIDERUSERDEF3."%'";
}
if ( $PROVIDERUSERDEF4 != "" )
{
$urlstr = $urlstr."&PROVIDERUSERDEF4=".$PROVIDERUSERDEF4;
$WHERE_STR .= " and a.USERDEF4 like '%".$PROVIDERUSERDEF4."%'";
}
if ( $PROVIDERUSERDEF5 != "" )
{
$urlstr = $urlstr."&PROVIDERUSERDEF5=".$PROVIDERUSERDEF5;
$WHERE_STR .= " and a.USERDEF5 like '%".$PROVIDERUSERDEF5."%'";
}
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\r\n from PURCHASE_HISTORY j\r\n LEFT OUTER JOIN PROVIDER a\r\n ON j.PROVIDER_ID=a.PROVIDER_ID\r\n LEFT OUTER JOIN SYS_CODE d\r\n ON a.PROVIDER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\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 PURCHASE_HISTORY j\r\n LEFT OUTER JOIN PROVIDER a\r\n ON j.PROVIDER_ID=a.PROVIDER_ID\r\n LEFT OUTER JOIN SYS_CODE d\r\n ON a.PROVIDER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\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 "<div align=\"center\">\r\n<table border=\"0\" cellspacing=\"1\" width=\"70%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n";
$PROVIDER_COUNT = 0;
$TOTAL_SUMSALE = 0;
$TOTAL_PRO_PRICE = 0;
$TOTAL_SER_PRICE = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
++$PROVIDER_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;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -