📄 index.php
字号:
//-----------先组织SQL语句-----------
if($SCOPE=="1" or $SCOPE=="")
$WHERE_STR.=" where SELLER='$LOGIN_USER_ID' ";
if($SCOPE=="2")
$WHERE_STR.=" where ((find_in_set( '$LOGIN_USER_ID',SHAREUSER) and SHARE='1') or (SHAREUSER='' and SELLER!='$LOGIN_USER_ID' and 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 d.DEPT_ID in ($TO_ID)";
}
if($CUSTOMER_NAME!="")
$WHERE_STR.=" and CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
if($CUSTOMER_CODE!="")
$WHERE_STR.=" and CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
if($CUSTOMER_SHORT!="")
$WHERE_STR.=" and CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
if($SOURCE!="")
$WHERE_STR.=" and SOURCE= '$SOURCE'";
if($KIND!="")
$WHERE_STR.=" and KIND= '$KIND'";
if($SELLMODE!="")
$WHERE_STR.=" and SELLMODE= '$SELLMODE'";
if($ATTRIBUTE!="")
$WHERE_STR.=" and ATTRIBUTE= '$ATTRIBUTE'";
if($ENTERTYPE!="")
$WHERE_STR.=" and ENTERTYPE= '$ENTERTYPE'";
if($AREACODE!="")
$WHERE_STR.=" and CUSTOMER_AREA= '$AREACODE'";
if($ORDERFIELD!="")
{
if($ORDERSIGN=="DOWN")
{
$ORDERTYPE="ASC";
}
if($ORDERSIGN=="UP")
{
$ORDERTYPE="DESC";
}
$OREDERBY=" ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$CUSTOMER_COUNT=0;
$query="SELECT count(*) from CUSTOMER a
LEFT OUTER JOIN SYS_CODE b ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'
LEFT OUTER JOIN SYS_CODE c ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'
LEFT OUTER JOIN SYS_CODE e ON a.CUSTOMER_AREA=e.CODE_NO AND e.PARENT_NO = 'AREA'
LEFT OUTER JOIN USER d ON a.SELLER = d.USER_ID
".$WHERE_STR;
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$CUSTOMER_COUNT=$ROW[0];
$PER_PAGE=10;
$PAGE_COUNT=ceil($CUSTOMER_COUNT/$PER_PAGE);
if($CUR_PAGE<=0 || $CUR_PAGE=="")
$CUR_PAGE=1;
if($CUR_PAGE>$PAGE_COUNT)
$CUR_PAGE=$PAGE_COUNT;
$query1="SELECT CUSTOMER_ID,CUSTOMER_NAME,TEL_NO,FAX_NO, SELLER,a.EMAIL as EMAIL,b.CODE_NAME as SELLMODE, c.CODE_NAME as KIND,d.USER_NAME as SELLER,d.USER_ID as SELLERID,e.CODE_NAME as CUSTOMER_AREA from CUSTOMER a
LEFT OUTER JOIN SYS_CODE b
ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'
LEFT OUTER JOIN SYS_CODE c
ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'
LEFT OUTER JOIN SYS_CODE e ON a.CUSTOMER_AREA=e.CODE_NO AND e.PARENT_NO = 'AREA'
LEFT OUTER JOIN USER d ON a.SELLER = d.USER_ID ".$WHERE_STR.$OREDERBY;
$offest=($CUR_PAGE-1)*10;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;
$cursor1 = exequery($connection, $query1);
if($CUSTOMER_COUNT==0)
{
Message("<br>提示","没有符合条件的客户");
exit;
}
else
{
?>
<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr>
<td align="left">
<a href="index.php?CUR_PAGE=1&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>
<a href="index.php?CUR_PAGE=<?=$CUR_PAGE-1?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>
<a href="index.php?CUR_PAGE=<?=$CUR_PAGE+1?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style="cursor:hand"></a>
<a href="index.php?CUR_PAGE=<?=$PAGE_COUNT?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last02.gif' width='24' border='0' height='15' alt='末页' style="cursor:hand"></a>
到
<input type="text" name="PAGE_NUM" size="3" maxlength="4" class="SmallInput">
页
<img id="btnGotoPage" src="/images/menu/book.gif" onclick="set_page()" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
</td>
<td align="right">
<?=$CUR_PAGE?>/<?=$PAGE_COUNT?>页 共 <?=$CUSTOMER_COUNT?> 条
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">选择</td>
<td nowrap align="center"><a href="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&ORDERFIELD=CUSTOMER_NAME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">客户名称 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CUSTOMER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CUSTOMER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&ORDERFIELD=KIND&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">客户类别 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="KIND"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="KIND"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&ORDERFIELD=CUSTOMER_AREA&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">地区 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CUSTOMER_AREA"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CUSTOMER_AREA"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&ORDERFIELD=SELLMODE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">销售方式 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SELLMODE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SELLMODE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center">电话</td>
<td nowrap align="center">传真</td>
<td nowrap align="center">电子邮件</td>
<td nowrap align="center">销售员</td>
<td nowrap align="center">操作</td>
</tr>
<?
$CUSTOMER_COUNT=0;
while($ROW=mysql_fetch_array($cursor1))
{
$CUSTOMER_COUNT++;
$CUSTOMER_ID=$ROW["CUSTOMER_ID"];
$CUSTOMER_AREA1=$ROW["CUSTOMER_AREA"];
$CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
$TEL_NO1=$ROW["TEL_NO"];
$FAX_NO1=$ROW["FAX_NO"];
$SELLER1=$ROW["SELLER"];
$SELLMODE1=$ROW["SELLMODE"];
$KIND1=$ROW["KIND"];
$EMAIL1=$ROW["EMAIL"];
$SELLER1=$ROW["SELLER"];
if($ROW["SELLERID"]!=$LOGIN_USER_ID)$SIGN="1";
if($SHARE1=="0")
$SHARE1="否";
else
$SHARE1="是";
if($CUSTOMER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td> <input type="checkbox" name="email_select" value="<?=$CUSTOMER_ID?>" <? if($SIGN=="1") echo "disabled"; ?> onClick="check_one(self);"></td>
<td nowrap align="center"><?=$CUSTOMER_NAME1?></td>
<td nowrap align="center"><?=$KIND1?></td>
<td nowrap align="center"><?=$CUSTOMER_AREA1?></td>
<td nowrap align="center"><?=$SELLMODE1?></td>
<td nowrap align="center"><?=$TEL_NO1?></td>
<td nowrap align="center"><?=$FAX_NO1?></td>
<td nowrap align="center"><?=$EMAIL1?></td>
<td nowrap align="center"><?=$SELLER1?></td>
<td nowrap align="center">
<?
if($SIGN=="1")
{
?>
<a href="javascript:show_detail(<?=$CUSTOMER_ID?>);"> 详细信息 </a>
<?
}
else
{
?>
<a href="javascript:show_detail(<?=$CUSTOMER_ID?>);"> 详细信息 </a>
<a href="edit.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>"> 编辑</a>
<a href="javascript:delete_customer(<?=$CUSTOMER_ID?>);"> 删除 </a>
<?
}
?>
</td>
</tr>
<?
}
}
?>
<tr class="TableControl">
<td colspan="10">
<input type="checkbox" name="allbox" id="allbox_for" <? if($SIGN=="1") echo "disabled"; ?> onClick="check_all();">
<label for="allbox_for">全选</label>
<input type="button" value="批量删除" class="SmallButton" onClick="delete_mail();" title="删除所选客户">
</td>
</tr>
</table>
</body>
</html>
<?
function GETALLDATE($CODE,$GETVALUE)
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
$connection=OpenConnection();
$cursor= exequery($connection,$query);
echo "<option value= ".">".""."</option>";
while($ROW=mysql_fetch_array($cursor))
{
$CODE_NO=$ROW["CODE_NO"];
$CODE_NAME=$ROW["CODE_NAME"];
if ($CODE_NO==$GETVALUE)
{echo "<option value=".$CODE_NO." selected>".$CODE_NAME."</option>";}
else
{echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";}
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -