📄 list1.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=10;
?>
<html>
<head>
<title>销售额统计结果 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script 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.graphValuesf.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';
document.all.graphValuese.style.display='none';
document.all.graphValuesf.style.display='none';
}
if(strwher=="graphValuesc")
{
document.all.graphValuesa.style.display='none';
document.all.graphValuesb.style.display='none';
document.all.graphValuesc.style.display='';
document.all.graphValuesd.style.display='none';
document.all.graphValuese.style.display='none';
document.all.graphValuesf.style.display='none';
}
if(strwher=="graphValuesd")
{
document.all.graphValuesa.style.display='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';
}
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';
}
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.style.display='none';
document.all.graphValuesf.style.display='';
}
}
</script>
</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))";
}
//-----------先组织SQL语句-----------
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($CUSTOMERUSERDEF1!="")
{
$urlstr=$urlstr."&CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
$WHERE_STR.=" and a.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
}
if($CUSTOMERUSERDEF2!="")
{
$urlstr=$urlstr."&CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
$WHERE_STR.=" and a.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
}
if($CUSTOMERUSERDEF3!="")
{
$urlstr=$urlstr."&CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
$WHERE_STR.=" and a.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
}
if($CUSTOMERUSERDEF4!="")
{
$urlstr=$urlstr."&CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
$WHERE_STR.=" and a.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
}
if($CUSTOMERUSERDEF5!="")
{
$urlstr=$urlstr."&CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
$WHERE_STR.=" and a.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -