📄 list.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_org.php" );
$PAGE_SIZE = 10;
echo "\r\n<html>\r\n<head>\r\n<title>客户查询结果 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script Language=\"JavaScript\">\r\nfunction delete_customer(CUSTOMER_ID,querstr)\r\n{\r\n msg='确认要删除该客户么？这也将删除相关的联系人、交往记录和产品销售记录。';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"../delete.php?querstr=\"+querstr+\"&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUSTOMER_ID=\" + CUSTOMER_ID;\r\n window.location=URL;\r\n }\r\n}\r\nfunction set_page(urlstr)\r\n{\r\n PAGE_START=PAGE_NUM.value;\r\n location=\"list.php?\"+urlstr+\"&CUR_PAGE=\"+PAGE_START+\"&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\";\r\n}\r\nfunction show_detail(CUSTOMER_ID)\r\n {\r\n URL=\"../showdetail.php?CUSTOMER_ID=\"+CUSTOMER_ID;\r\n myleft=(screen.availWidth-650)/2;\r\n 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\");\r\n }\r\nfunction check_one(el)\r\n{\r\n if(!el.checked)\r\n document.all(\"allbox\").checked=false;\r\n}\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").item(i).checked=true;\r\n else\r\n document.all(\"email_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").checked=true;\r\n else\r\n document.all(\"email_select\").checked=false;\r\n }\r\n}\r\n\r\n</script>\r\n</head>\r\n\r\n";
if ( $SCOPE == "1" || $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.",";
}
}
$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.")";
}
}
$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.")";
}
}
$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.")";
}
}
$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\r\n ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n LEFT OUTER JOIN SYS_CODE c\r\n ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n LEFT OUTER JOIN SYS_CODE d\r\n ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\r\n LEFT OUTER JOIN SYS_CODE e\r\n ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'\r\n LEFT OUTER JOIN SYS_CODE f\r\n ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'\r\n LEFT OUTER JOIN SYS_CODE g\r\n ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'\r\n LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID\r\n LEFT OUTER JOIN LINKMAN i ON a.CUSTOMER_ID = i.CUSTOMER_ID\r\n LEFT OUTER JOIN CONTACT j ON a.CUSTOMER_ID = j.CUSTOMER_ID\r\n LEFT OUTER JOIN SYS_CODE k\r\n ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = 'CONTACT_TYPE'\r\n ".$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 || $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\r\n from CUSTOMER a LEFT OUTER JOIN SYS_CODE b\r\n ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n LEFT OUTER JOIN SYS_CODE c\r\n ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n LEFT OUTER JOIN SYS_CODE d\r\n ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\r\n LEFT OUTER JOIN SYS_CODE e\r\n ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'\r\n LEFT OUTER JOIN SYS_CODE f\r\n ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'\r\n LEFT OUTER JOIN SYS_CODE g\r\n ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'\r\n LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID\r\n LEFT OUTER JOIN LINKMAN i ON a.CUSTOMER_ID = i.CUSTOMER_ID\r\n LEFT OUTER JOIN CONTACT j ON a.CUSTOMER_ID = j.CUSTOMER_ID\r\n LEFT OUTER JOIN SYS_CODE k\r\n ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = 'CONTACT_TYPE'\r\n ".$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( );
}
echo "\r\n<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" cellpadding=\"3\">\r\n <tr>\r\n <td align=\"left\">\r\n <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>\r\n <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>\r\n <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>\r\n <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>\r\n\r\n 到\r\n <input type=\"text\" name=\"PAGE_NUM\" size=\"3\" maxlength=\"4\" class=\"SmallInput\">\r\n 页\r\n <img id=\"btnGotoPage\" src=\"/images/menu/book.gif\" onclick=\"set_page('";
echo $urlstr;
echo "')\" border=\"0\" WIDTH=\"19\" HEIGHT=\"17\" style=\"cursor:hand\" alt=\"转到相应页面\">\r\n </td>\r\n <td align=\"right\">\r\n ";
echo $CUR_PAGE;
echo "/";
echo $PAGE_COUNT;
echo "页 共 ";
echo $CUSTOMER_COUNT;
echo " 条\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table class=\"TableList\" width=\"95%\">\r\n <tr class=\"TableHeader\">\r\n \t <td nowrap align=\"center\" ";
if ( $SCOPE == "2" )
{
echo "style=display:none";
}
echo ">选择</td>\r\n <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" && $ORDERFIELD == "CUSTOMER_NAME" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CUSTOMER_NAME" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <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";
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -