📄 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 show_detail(CONTACT_ID)
{
URL="../showdetail.php?CONTACT_ID="+CONTACT_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 set_page(urlstr)
{
PAGE_START=PAGE_NUM.value;
location="list.php?"+urlstr+"';
echo '&CUR_PAGE="+PAGE_START+"&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '";
}
function delete_customer(CONTACT_ID,querstr)
{
msg=\'确认要删除该服务记录？\';
if(window.confirm(msg))
{
URL="../delete.php?querstr="+querstr+"&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '&CONTACT_ID=" + CONTACT_ID;
window.location=URL;
}
}
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;';
echo '
}
if(i==0)
{
if(document.all("allbox").checked)
document.all("email_select").checked=true;
else
document.all("email_select").checked=false;
}
}
function td_detail(I)
{
if(document.all(I).style.display=="none")
{document.all(I).style.display="";
document.all(I).style.cursor="hand";
}
else
document.all(I).style.display="none";
';
echo '
}
</script>
</head>
';
$urlstr = ('SELLER='.$LOGIN_USER_ID);
($WHERE_STR .= (((''.' where j.SELLER=\'').$LOGIN_USER_ID).'\''));
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_SHORT=').$CUSTOMER_SHORT);
($WHERE_STR .= ((' and a.CUSTOMER_AREA like \'%'.$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 (($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 count(*) from CONTACT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID
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 j.LINKMAN_ID = i.LINKMAN_ID
LEFT OUTER JOIN SYS_CODE k
ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = \'CONTACT_TYPE\'
'.$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) OR ($CUR_PAGE == '')))
{
$CUR_PAGE = 1;
}
if (($PAGE_COUNT < $CUR_PAGE))
{
$CUR_PAGE = $PAGE_COUNT;
}
$query1 = (('SELECT j.CONTACT_ID as CONTACT_ID ,j.MONEY_COST as MONEY_COST,j.TIME_COST as TIME_COST ,a.CUSTOMER_NAME as CUSTOMER_NAME,c.CODE_NAME as KIND,b.CODE_NAME as SELLMODE,k.CODE_NAME as CONTACT_TYPE,j.CONTACT_DATE as CONTACT_DATE,j.CONTACT_CONTENT as CONTACT_CONTENT,h.USER_NAME as SELLER
from CONTACT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID
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 j.SELLER = h.USER_ID
LEFT OUTER JOIN LINKMAN i ON j.LINKMAN_ID = i.LINKMAN_ID
LEFT OUTER JOIN SYS_CODE k
ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = \'CONTACT_TYPE\'
'.$WHERE_STR).$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 '&CUR_PAGE=1&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
<a href="list.php?';
echo $urlstr;
echo '&CUR_PAGE=';
echo ($CUR_PAGE - 1);
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '"><img src=\'/images/first01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'上一页\'></a>
<a href="list.php?';
echo $urlstr;
echo '&CUR_PAGE=';
echo ($CUR_PAGE + 1);
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '"><img src=\'/images/last01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'下一页\' style="cursor:hand"></a>
<a href="list.php?';
echo $urlstr;
echo '&CUR_PAGE=';
echo $PAGE_COUNT;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
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="100%" 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>';
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -