📄 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 delete_customer(CUSTOMER_ID,querstr)
{
msg='确认要删除该客户么？这也将删除相关的联系人、交往记录和产品销售记录。';
if(window.confirm(msg))
{
URL="../delete.php?querstr="+querstr+"&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUSTOMER_ID=" + CUSTOMER_ID;
window.location=URL;
}
}
function set_page(urlstr)
{
PAGE_START=PAGE_NUM.value;
location="list.php?"+urlstr+"&CUR_PAGE="+PAGE_START+"&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
}
function show_detail(CUSTOMER_ID)
{
URL="../showdetail.php?CUSTOMER_ID="+CUSTOMER_ID;
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 check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function check_all()
{
for (i=0;i<document.all("email_select").length;i++)
{
if(document.all("allbox").checked)
document.all("email_select").item(i).checked=true;
else
document.all("email_select").item(i).checked=false;
}
if(i==0)
{
if(document.all("allbox").checked)
document.all("email_select").checked=true;
else
document.all("email_select").checked=false;
}
}
</script>
</head>
<?
//-----------先组织SQL语句-----------
if($SCOPE=="1" or $SCOPE=="") $WHERE_STR.=" where a.SELLER='$LOGIN_USER_ID' ";
if($SCOPE=="2") $WHERE_STR.=" where ((find_in_set( '$LOGIN_USER_ID',a.SHAREUSER) and a.SHARE='1') or (a.SHAREUSER='' and a.SELLER!='$LOGIN_USER_ID' and a.SHARE='1'))";
if($SCOPE=="3")
{
$query1 = "select DEPT_ID from DEPARTMENT";
$cursor1= exequery($connection,$query1);
while($ROW=mysql_fetch_array($cursor1))
{
$DEPT_ID=$ROW["DEPT_ID"];
if (is_dept_priv($DEPT_ID)==1)
{
$TO_ID=$TO_ID.$DEPT_ID.",";
}
}
$TO_ID="'".str_replace(",","','",substr($TO_ID,0,-1))."'";
$WHERE_STR.=" where h.DEPT_ID in ($TO_ID)";
}
$urlstr="SCOPE=".$SCOPE;
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;
$WHERE_STR.=" and a.SOURCE ='$SOURCE'";
}
if($KIND!="")
{
$urlstr=$urlstr."&KIND=".$KIND;
$WHERE_STR.=" and a.KIND ='$KIND'";
}
if($SELLMODE!="")
{
$urlstr=$urlstr."&SELLMODE=".$SELLMODE;
$WHERE_STR.=" and a.SELLMODE ='$SELLMODE'";
}
if($ATTRIBUTE!="")
{
$urlstr=$urlstr."&ATTRIBUTE=".$ATTRIBUTE;
$WHERE_STR.=" and a.ATTRIBUTE ='$ATTRIBUTE'";
}
if($ENTERTYPE!="")
{
$urlstr=$urlstr."&ENTERTYPE=".$ENTERTYPE;
$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."%'";
}
if($LINKMAN_NAME!="")
{
$urlstr=$urlstr."&LINKMAN_NAME=".$LINKMAN_NAME;
$WHERE_STR.=" and i.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
}
if($SEX!="")
{
$urlstr=$urlstr."&SEX=".$SEX;
$WHERE_STR.=" and i.SEX ='$SEX'";
}
if($HOBBY!="")
{
$urlstr=$urlstr."&HOBBY=".$HOBBY;
$WHERE_STR.=" and i.HOBBY like '%".$HOBBY."%'";
}
if($LINKMANUSERDEF1!="")
{
$urlstr=$urlstr."&LINKMANUSERDEF1=".$LINKMANUSERDEF1;
$WHERE_STR.=" and i.USERDEF1 like '%".$LINKMANUSERDEF1."%'";
}
if($LINKMANUSERDEF2!="")
{
$urlstr=$urlstr."&LINKMANUSERDEF2=".$LINKMANUSERDEF2;
$WHERE_STR.=" and i.USERDEF2 like '%".$LINKMANUSERDEF2."%'";
}
if($LINKMANUSERDEF3!="")
{
$urlstr=$urlstr."&LINKMANUSERDEF3=".$LINKMANUSERDEF3;
$WHERE_STR.=" and i.USERDEF3 like '%".$LINKMANUSERDEF3."%'";
}
if($LINKMANUSERDEF4!="")
{
$urlstr=$urlstr."&LINKMANUSERDEF4=".$LINKMANUSERDEF4;
$WHERE_STR.=" and i.USERDEF4 like '%".$LINKMANUSERDEF4."%'";
}
if($LINKMANUSERDEF5!="")
{
$urlstr=$urlstr."&LINKMANUSERDEF5=".$LINKMANUSERDEF5;
$WHERE_STR.=" and i.USERDEF5 like '%".$LINKMANUSERDEF5."%'";
}
if($CONTACT_TYPE!="")
{
$urlstr=$urlstr."&CONTACT_TYPE=".$CONTACT_TYPE;
$WHERE_STR.=" and j.CONTACT_TYPE ='$CONTACT_TYPE'";
}
if($CONTACT_DATE1!="")
{
$urlstr=$urlstr."&CONTACT_DATE1=".$CONTACT_DATE1;
$WHERE_STR.=" and j.CONTACT_DATE>='$CONTACT_DATE1'";
}
if($CONTACT_DATE2!="")
{
$urlstr=$urlstr."&CONTACT_DATE2=".$CONTACT_DATE2;
$WHERE_STR.=" and j.CONTACT_DATE<='$CONTACT_DATE2'";
}
if($SATISFY!="")
{
$urlstr=$urlstr."&SATISFY=".$SATISFY;
$WHERE_STR.=" and j.SATISFY ='$SATISFY'";
}
if($CONTACT_CONTENT!="")
{
$urlstr=$urlstr."&CONTACT_CONTENT=".$CONTACT_CONTENT;
$WHERE_STR.=" and j.CONTACT_CONTENT like '%".$CONTACT_CONTENT."%'";
}
if($CONTACTUSERDEF1!="")
{
$urlstr=$urlstr."&CONTACTUSERDEF1=".$CONTACTUSERDEF1;
$WHERE_STR.=" and j.USERDEF1 like '%".$CONTACTUSERDEF1."%'";
}
if($CONTACTUSERDEF2!="")
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -