📄 list.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$PAGE_SIZE = 10;
echo '
<html>
<head>
<title>客户查询结果 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript Language="JavaScript">
function delete_customer(CUSTOMER_ID,querstr)
{
msg=\'确认要删除该客户么？这也将删除相关的联系人、交往记录和产品销售记录。\';
if(window.confirm(msg))
{
URL="../delete.php?querstr="+querstr+"&CUR_PAGE=';
echo $CUR_PAGE;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&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=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '";
}
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;
}
fun';
echo 'ction 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").ch';
echo 'ecked=false;
}
}
</script>
</head>
';
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).',');
continue;
}
}
$TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
($WHERE_STR .= (((((''.' where h.DEPT_ID in (').$TO_ID).') and a.SELLER!=\'').$LOGIN_USER_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 (($TEL_NO != ''))
{
$urlstr = (($urlstr.'&TEL_NO=').$TEL_NO);
($WHERE_STR .= ((' and a.TEL_NO like \'%'.$TEL_NO).'%\''));
}
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 (($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 (($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).'%\''));
}
$query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'CUSTOMER\'';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$FIELDNO = ('CUSTOMER'.$ROW['FIELDNO']);
if (($$FIELDNO != ''))
{
$CUSTOMERID_STR = '';
$urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
$WHERE_STR1 = ((((' where TABLENAME=\'CUSTOMER\' and (FIELDNO=\''.$ROW['FIELDNO']).'\' and ITEM_DATE like \'%').$$FIELDNO).'%\')');
$query1 = ('SELECT IDENTY_ID FROM `FIELD_DATE`'.$WHERE_STR1);
$cursor1 = exequery ($connection, $query1);
while ($ROW1 = mysql_fetch_array ($cursor1))
{
$CUSTOMERID_STR = (($CUSTOMERID_STR.$ROW1['IDENTY_ID']).',');
}
$CUSTOMERID_STR = (('\''.str_replace (',', '\',\'', substr ($CUSTOMERID_STR, 0, -1))).'\'');
($WHERE_STR .= (((''.' and a.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
continue;
}
}
$query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'LINKMAN\'';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$FIELDNO = ('LINKMAN'.$ROW['FIELDNO']);
if (($$FIELDNO != ''))
{
$LINKMANID_STR = '';
$urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
$WHERE_STR1 = ((((' where TABLENAME=\'LINKMAN\' and (FIELDNO=\''.$ROW['FIELDNO']).'\' and ITEM_DATE like \'%').$$FIELDNO).'%\')');
$query1 = ('SELECT IDENTY_ID FROM `FIELD_DATE`'.$WHERE_STR1);
$cursor1 = exequery ($connection, $query1);
while ($ROW1 = mysql_fetch_array ($cursor1))
{
$LINKMANID_STR = (($LINKMANID_STR.$ROW1['IDENTY_ID']).',');
}
$LINKMANID_STR = (('\''.str_replace (',', '\',\'', substr ($LINKMANID_STR, 0, -1))).'\'');
($WHERE_STR .= (((''.' and i.LINKMAN_ID in (').$LINKMANID_STR).')'));
continue;
}
}
$query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'CONTACT\'';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$FIELDNO = ('CONTACT'.$ROW['FIELDNO']);
if (($$FIELDNO != ''))
{
$CONTACTID_STR = '';
$urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
$WHERE_STR1 = ((((' where TABLENAME=\'CONTACT\' and (FIELDNO=\''.$ROW['FIELDNO']).'\' and ITEM_DATE like \'%').$$FIELDNO).'%\')');
$query1 = ('SELECT IDENTY_ID FROM `FIELD_DATE`'.$WHERE_STR1);
$cursor1 = exequery ($connection, $query1);
while ($ROW1 = mysql_fetch_array ($cursor1))
{
$CONTACTID_STR = (($CONTACTID_STR.$ROW1['IDENTY_ID']).',');
}
$CONTACTID_STR = (('\''.str_replace (',', '\',\'', substr ($CONTACTID_STR, 0, -1))).'\'');
($WHERE_STR .= (((''.' and j.CONTACT_ID in (').$CONTACTID_STR).')'));
continue;
}
}
$urlstr1 = str_replace ('&', '%', $urlstr);
if (($ORDERFIELD != ''))
{
if (($ORDERSIGN == 'DOWN'))
{
$ORDERTYPE = 'ASC';
}
if (($ORDERSIGN == 'UP'))
{
$ORDERTYPE = 'DESC';
}
$OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
}
$CUSTOMER_COUNT = 0;
$query = (('SELECT a.CUSTOMER_ID 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 d
ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = \'AREA\'
LEFT OUTER JOIN SYS_CODE e
ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = \'CRM_SOURCE\'
LEFT OUTER JOIN SYS_CODE f
ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = \'CRM_ATTRIBUTE\'
LEFT OUTER JOIN SYS_CODE g
ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = \'CRM_TYPE\'
LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID
LEFT OUTER JOIN LINKMAN i ON a.CUSTOMER_ID = i.CUSTOMER_ID
LEFT OUTER JOIN CONTACT j ON a.CUSTOMER_ID = j.CUSTOMER_ID
LEFT OUTER JOIN SYS_CODE k
ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = \'CONTACT_TYPE\'
'.$WHERE_STR).' GROUP BY a.CUSTOMER_ID');
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
++$CUSTOMER_COUNT;
}
$PER_PAGE = 10;
$PAGE_COUNT = ceil (($CUSTOMER_COUNT / $PER_PAGE));
if ((($CUR_PAGE <= 0) OR ($CUR_PAGE == '')))
{
$CUR_PAGE = 1;
}
if (($PAGE_COUNT < $CUR_PAGE))
{
$CUR_PAGE = $PAGE_COUNT;
}
$query1 = ((('SELECT a.CUSTOMER_ID, a.`CUSTOMER_NAME` , b.CODE_NAME AS \'SELLMODE\', c.CODE_NAME AS KIND, d.CODE_NAME AS CUSTOMER_AREA, e.CODE_NAME AS `SOURCE` , f.CODE_NAME AS `ATTRIBUTE` , g.CODE_NAME AS `ENTERTYPE` , a.SELLER as SELLERID,h.USER_NAME AS SELLER, count(DISTINCT i.LINKMAN_ID) AS LINKMANCOUNT, count(DISTINCT j.CONTACT_ID) AS CONTACTCOUNT
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 d
ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = \'AREA\'
LEFT OUTER JOIN SYS_CODE e
ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = \'CRM_SOURCE\'
LEFT OUTER JOIN SYS_CODE f
ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = \'CRM_ATTRIBUTE\'
LEFT OUTER JOIN SYS_CODE g
ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = \'CRM_TYPE\'
LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID
LEFT OUTER JOIN LINKMAN i ON a.CUSTOMER_ID = i.CUSTOMER_ID
LEFT OUTER JOIN CONTACT j ON a.CUSTOMER_ID = j.CUSTOMER_ID
LEFT OUTER JOIN SYS_CODE k
ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = \'CONTACT_TYPE\'
'.$WHERE_STR).' GROUP BY a.CUSTOMER_ID').$OREDERBY);
$offest = (($CUR_PAGE - 1) * 10);
$query1 = (((($query1.' LIMIT ').$offest).' ,').$PER_PAGE);
$cursor1 = exequery ($connection, $query1);
if (($CUSTOMER_COUNT == 0))
{
message ('<br>提示', '没有符合条件的客户');
button_back ();
exit ();
}
else
{
echo '
<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr>
<td align="left">
<a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=1"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
<a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo ($CUR_PAGE - 1);
echo '"><img src=\'/images/first01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'上一页\'></a>
<a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo ($CUR_PAGE + 1);
echo '"><img src=\'/images/last01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'下一页\' style="cursor:hand"></a>
<a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $PAGE_COUNT;
echo '"><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(\'';
echo $urlstr;
echo '\')" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
</td>
<td align="right">
';
echo $CUR_PAGE;
echo '/';
echo $PAGE_COUNT;
echo '页 共 ';
echo $CUSTOMER_COUNT;
echo ' 条
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center" ';
if (($SCOPE == '2'))
{
echo 'style=display:none';
}
echo '>选择</td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=CUSTOMER_NAME&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">客户名称 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CUSTOMER_NAME')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CUSTOMER_NAME')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=CUSTOMER_AREA&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -