📄 list.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)
{
URL="list1.php?"+strwher+"&SUMFIELD="+input.value;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function LoadWindow1(ARRAY_FIELD,graphValuesa,graphValuesb,graphValuesc,type)
{
if(document.all("FLAG").item(0).checked)
URL="statics?ARRAY_FIELD="+ARRAY_FIELD+"&graphValues="+graphValuesa+"&type="+type+"&unit=次";
if(document.all("FLAG").item(1).checked)
URL="statics?ARRAY_FIELD="+ARRAY_FIELD+"&graphValues="+graphValuesb+"&type="+type+"&unit=小时";
if(document.all("FLAG").item(2).checked)
URL="statics?ARRAY_FIELD="+ARRAY_FIELD+"&graphValues="+graphValuesc+"&type="+type+"&unit=元";
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" WIDTH="22" HEIGHT="22" align="absmiddle"><span class="big3"> 客户服务统计结果</span><br>
</td>
</tr>
</table>
<?
//echo $SUMFIELD;
$TYPENAME_ARRAY=explode(",",$SUMFIELD);
//-----------先组织SQL语句-----------
if($COPY_TO_ID!="")
{
if($urlstr=="")$urlstr="COPY_TO_ID=".$COPY_TO_ID;
else $urlstr=$urlstr."©_TO_ID=".$COPY_TO_ID;
$COPY_TO_ID="'".str_replace(",","','",substr($COPY_TO_ID,0,-1))."'";
if($WHERE_STR=="")
$WHERE_STR.=" where j.SELLER in ($COPY_TO_ID)";
else
$WHERE_STR.=" and j.SELLER in ($COPY_TO_ID)";
}
if($TO_ID!="")
{
if($urlstr=="")$urlstr="TO_ID=".$TO_ID;
else $urlstr=$urlstr."&TO_ID=".$TO_ID;
$TO_ID="'".str_replace(",","','",substr($TO_ID,0,-1))."'";
if($WHERE_STR=="")
$WHERE_STR.=" where h.DEPT_ID in ($TO_ID)";
else
$WHERE_STR.=" and h.DEPT_ID in ($TO_ID)";
}
if($SELL_MANAGEID!="")
{
$COPY_TO_ID="'".str_replace(",","','",substr($COPY_TO_ID,0,-1))."'";
if($WHERE_STR=="")
$WHERE_STR.=" where j.SELLER in ($COPY_TO_ID)";
else
$WHERE_STR.=" and j.SELLER in ($COPY_TO_ID)";
}
if($CUSTOMER_NAME!="")
{
if($urlstr=="")$urlstr="CUSTOMER_NAME=".$CUSTOMER_NAME;
else $urlstr=$urlstr."&CUSTOMER_NAME=".$CUSTOMER_NAME;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
else
$WHERE_STR.=" and a.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
}
if($CUSTOMER_CODE!="")
{
if($urlstr=="")$urlstr="CUSTOMER_CODE=".$CUSTOMER_CODE;
else $urlstr=$urlstr."&CUSTOMER_CODE=".$CUSTOMER_CODE;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
else
$WHERE_STR.=" and a.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
}
if($CUSTOMER_SHORT!="")
{
if($urlstr=="")$urlstr="CUSTOMER_SHORT=".$CUSTOMER_SHORT;
else $urlstr=$urlstr."&CUSTOMER_SHORT=".$CUSTOMER_SHORT;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
else
$WHERE_STR.=" and a.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
}
if($CUSTOMER_AREA!="")
{
if($urlstr=="")$urlstr="CUSTOMER_AREA=".$CUSTOMER_AREA;
else $urlstr=$urlstr."&CUSTOMER_AREA=".$CUSTOMER_AREA;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CUSTOMER_AREA='$CUSTOMER_AREA'";
else
$WHERE_STR.=" and a.CUSTOMER_AREA='$CUSTOMER_AREA'";
}
if($CUSTOMER_ADD!="")
{
if($urlstr=="")$urlstr="CUSTOMER_ADD=".$CUSTOMER_ADD;
else $urlstr=$urlstr."&CUSTOMER_ADD=".$CUSTOMER_ADD;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
else
$WHERE_STR.=" and a.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
}
if($SOURCE!="")
{
if($flagstr=="")$flagstr="e.CODE_NAME";
else $flagstr=$flagstr.",e.CODE_NAME";
if($urlstr=="")$urlstr="SOURCE=".$SOURCE;
else $urlstr=$urlstr."&SOURCE=".$SOURCE;
if($WHERE_STR=="")
$WHERE_STR.=" where a.SOURCE ='$SOURCE'";
else
$WHERE_STR.=" and a.SOURCE ='$SOURCE'";
}
if($KIND!="")
{
if($flagstr=="")$flagstr="c.CODE_NAME";
else $flagstr=$flagstr.",c.CODE_NAME";
if($urlstr=="")$urlstr="KIND=".$KIND;
else $urlstr=$urlstr."&KIND=".$KIND;
if($WHERE_STR=="")
$WHERE_STR.=" where a.KIND ='$KIND'";
else
$WHERE_STR.=" and a.KIND ='$KIND'";
}
if($SELLMODE!="")
{
if($flagstr=="")$flagstr="b.CODE_NAME";
else $flagstr=$flagstr.",b.CODE_NAME";
if($urlstr=="")$urlstr="SELLMODE=".$SELLMODE;
else $urlstr=$urlstr."&SELLMODE=".$SELLMODE;
if($WHERE_STR=="")
$WHERE_STR.=" where a.SELLMODE ='$SELLMODE'";
else
$WHERE_STR.=" and a.SELLMODE ='$SELLMODE'";
}
if($ATTRIBUTE!="")
{
if($urlstr=="")$urlstr="ATTRIBUTE=".$ATTRIBUTE;
else $urlstr=$urlstr."&ATTRIBUTE=".$ATTRIBUTE;
if($flagstr=="")$flagstr="f.CODE_NAME";
else $flagstr=$flagstr.",f.CODE_NAME";
if($WHERE_STR=="")
$WHERE_STR.=" where a.ATTRIBUTE ='$ATTRIBUTE'";
else
$WHERE_STR.=" and a.ATTRIBUTE ='$ATTRIBUTE'";
}
if($ENTERTYPE!="")
{
if($urlstr=="")$urlstr="ENTERTYPE=".$ENTERTYPE;
else $urlstr=$urlstr."&ENTERTYPE=".$ENTERTYPE;
if($flagstr=="")$flagstr="g.CODE_NAME";
else $flagstr=$flagstr.",g.CODE_NAME";
if($WHERE_STR=="")
$WHERE_STR.=" where a.ENTERTYPE ='$ENTERTYPE'";
else
$WHERE_STR.=" and a.ENTERTYPE ='$ENTERTYPE'";
}
if($ENTERMEMO!="")
{
if($urlstr=="")$urlstr="ENTERMEMO=".$ENTERMEMO;
else $urlstr=$urlstr."&ENTERMEMO=".$ENTERMEMO;
if($WHERE_STR=="")
$WHERE_STR.=" where a.ENTERMEMO like '%".$ENTERMEMO."%'";
else
$WHERE_STR.=" and a.ENTERMEMO like '%".$ENTERMEMO."%'";
}
if($CUSTOMERUSERDEF1!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
else $urlstr=$urlstr."&CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
if($WHERE_STR=="")
$WHERE_STR.=" where a.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
else
$WHERE_STR.=" and a.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
}
if($CUSTOMERUSERDEF2!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
else $urlstr=$urlstr."&CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
if($WHERE_STR=="")
$WHERE_STR.=" where a.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
else
$WHERE_STR.=" and a.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
}
if($CUSTOMERUSERDEF3!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
else $urlstr=$urlstr."&CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
if($WHERE_STR=="")
$WHERE_STR.=" where a.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
else
$WHERE_STR.=" and a.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
}
if($CUSTOMERUSERDEF4!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
else $urlstr=$urlstr."&CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
if($WHERE_STR=="")
$WHERE_STR.=" where a.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
else
$WHERE_STR.=" and a.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
}
if($CUSTOMERUSERDEF5!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
else $urlstr=$urlstr."&CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
if($WHERE_STR=="")
$WHERE_STR.=" where a.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
else
$WHERE_STR.=" and a.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
}
if($CONTACT_TYPE!="")
{
if($urlstr=="")$urlstr="CONTACT_TYPE=".$CONTACT_TYPE;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -