📄 list.php
字号:
{
($WHERE_STR .= (((''.' where i.LINKMAN_ID in (').$LINKMANID_STR).')'));
continue;
}
else
{
($WHERE_STR .= (((''.' and i.LINKMAN_ID in (').$LINKMANID_STR).')'));
continue;
}
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 = '';
if (($urlstr == ''))
{
$urlstr = (($FIELDNO.'=').$$FIELDNO);
}
else
{
$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))).'\'');
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where j.CONTACT_ID in (').$CONTACTID_STR).')'));
continue;
}
else
{
($WHERE_STR .= (((''.' and j.CONTACT_ID in (').$CONTACTID_STR).')'));
continue;
}
continue;
}
}
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` , 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">选择</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
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">地区 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CUSTOMER_AREA')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CUSTOMER_AREA')))
{
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=KIND&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 == 'KIND')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'KIND')))
{
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=SELLMODE&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 == 'SELLMODE')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SELLMODE')))
{
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=SOURCE&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 == 'SOURCE')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SOURCE')))
{
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=ATTRIBUTE&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 == 'ATTRIBUTE')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'ATTRIBUTE')))
{
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=ENTERTYPE&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 == 'ENTERTYPE')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'ENTERTYPE')))
{
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=SELLER&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 == 'SELLER')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SELLER')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center">操作</td>
</tr>
';
$CUSTOMER_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor1))
{
++$CUSTOMER_COUNT;
$CUSTOMER_ID = $ROW['CUSTOMER_ID'];
$CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
$CUSTOMER_AREA1 = $ROW['CUSTOMER_AREA'];
$SELLER1 = $ROW['SELLER'];
$SOURCE1 = $ROW['SOURCE'];
$ATTRIBUTE1 = $ROW['ATTRIBUTE'];
$ENTERTYPE1 = $ROW['ENTERTYPE'];
$SELLMODE1 = $ROW['SELLMODE'];
$KIND1 = $ROW['KIND'];
$LINKMANCOUNT1 = $ROW['LINKMANCOUNT'];
$CONTACTCOUNT1 = $ROW['CONTACTCOUNT'];
if ((($CUSTOMER_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td> <input type="checkbox" name="email_select" value="';
echo $CUSTOMER_ID;
echo '" ';
if (($SIGN == '1'))
{
echo 'disabled';
}
echo ' onClick="check_one(self);"></td>
<td nowrap align="center">';
echo $CUSTOMER_NAME1;
echo '</td>
<td nowrap align="center">';
echo $CUSTOMER_AREA1;
echo '</td>
<td nowrap align="center">';
echo $KIND1;
echo '</td>
<td nowrap align="center">';
echo $SELLMODE1;
echo '</td>
<td nowrap align="center">';
echo $SOURCE1;
echo '</td>
<td nowrap align="center">';
echo $ATTRIBUTE1;
echo '</td>
<td nowrap align="center">';
echo $ENTERTYPE1;
echo '</td>
<td nowrap align="center">';
echo $SELLER1;
echo '</td>
<td nowrap align="center"><a href="showdetail.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '"> 详细信息 </a></td>
</tr>
';
}
}
echo ' <tr class="TableControl">
<td colspan="10">
<input type="checkbox" name="allbox" id="allbox_for" ';
if (($SIGN == '1'))
{
echo 'disabled';
}
echo ' onClick="check_all();">
<label for="allbox_for">全选</label>
<input type="button" value="客户资料转交" class="SmallButton" onClick="change_customer(\'';
echo $urlstr;
echo '\');" title="客户资料转交">
</td>
</tr>
</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onclick="location=\'index.php\'">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -