📄 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 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");
}
</script>
</head>
<?
//-----------先组织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 a.SELLER in ($COPY_TO_ID)";
else
$WHERE_STR.=" and a.SELLER in ($COPY_TO_ID)";
}
if($TO_ID!="" and $TO_ID!="ALL_DEPT")
{
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($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($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($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($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($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($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($LINKMAN_NAME!="")
{
if($urlstr=="")$urlstr="LINKMAN_NAME=".$LINKMAN_NAME;
else $urlstr=$urlstr."&LINKMAN_NAME=".$LINKMAN_NAME;
if($WHERE_STR=="")
$WHERE_STR.=" where i.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
else
$WHERE_STR.=" and i.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
}
if($SEX!="")
{
if($urlstr=="")$urlstr="SEX=".$SEX;
else $urlstr=$urlstr."&SEX=".$SEX;
if($WHERE_STR=="")
$WHERE_STR.=" where i.SEX ='$SEX'";
else
$WHERE_STR.=" and i.SEX ='$SEX'";
}
if($HOBBY!="")
{
if($urlstr=="")$urlstr="HOBBY=".$HOBBY;
else $urlstr=$urlstr."&HOBBY=".$HOBBY;
if($WHERE_STR=="")
$WHERE_STR.=" where i.HOBBY like '%".$HOBBY."%'";
else
$WHERE_STR.=" and i.HOBBY like '%".$HOBBY."%'";
}
if($LINKMANUSERDEF1!="")
{
if($urlstr=="")$urlstr="LINKMANUSERDEF1=".$LINKMANUSERDEF1;
else $urlstr=$urlstr."&LINKMANUSERDEF1=".$LINKMANUSERDEF1;
if($WHERE_STR=="")
$WHERE_STR.=" where i.USERDEF1 like '%".$LINKMANUSERDEF1."%'";
else
$WHERE_STR.=" and i.USERDEF1 like '%".$LINKMANUSERDEF1."%'";
}
if($LINKMANUSERDEF2!="")
{
if($urlstr=="")$urlstr="LINKMANUSERDEF2=".$LINKMANUSERDEF2;
else $urlstr=$urlstr."&LINKMANUSERDEF2=".$LINKMANUSERDEF2;
if($WHERE_STR=="")
$WHERE_STR.=" where i.USERDEF2 like '%".$LINKMANUSERDEF2."%'";
else
$WHERE_STR.=" and i.USERDEF2 like '%".$LINKMANUSERDEF2."%'";
}
if($LINKMANUSERDEF3!="")
{
if($urlstr=="")$urlstr="LINKMANUSERDEF3=".$LINKMANUSERDEF3;
else $urlstr=$urlstr."&LINKMANUSERDEF3=".$LINKMANUSERDEF3;
if($WHERE_STR=="")
$WHERE_STR.=" where i.USERDEF3 like '%".$LINKMANUSERDEF3."%'";
else
$WHERE_STR.=" and i.USERDEF3 like '%".$LINKMANUSERDEF3."%'";
}
if($LINKMANUSERDEF4!="")
{
if($urlstr=="")$urlstr="LINKMANUSERDEF4=".$LINKMANUSERDEF4;
else $urlstr=$urlstr."&LINKMANUSERDEF4=".$LINKMANUSERDEF4;
if($WHERE_STR=="")
$WHERE_STR.=" where i.USERDEF4 like '%".$LINKMANUSERDEF4."%'";
else
$WHERE_STR.=" and i.USERDEF4 like '%".$LINKMANUSERDEF4."%'";
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -