📄 list.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$PAGE_SIZE = 10;
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$MANAGER_ID = $ROW['MANAGER_ID'];
	$MANAGERS = $ROW['MANAGERS'];
	$DELETE_FLAG = $ROW['DELETE_FLAG'];
}
echo "<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 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\n  function delete_customer(COMPLAINT_ID,querstr)\r\n{\r\n msg='确认要删除该投诉记录？';\r\n if(window.confirm(msg))\r\n {\r\n  URL=\"../delete.php?querstr=\"+querstr+\"&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&COMPLAINT_ID=\" + COMPLAINT_ID;\r\n  window.location=URL;\r\n }\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</script>\r\n</head>\r\n\r\n";
$urlstr = "USER_ID=".$LOGIN_USER_ID;
$WHERE_STR .= "  where j.USER_ID='".$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 ( $CUSTOMERUSERDEF1 != "" )
{
	$urlstr = $urlstr."&CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
	$WHERE_STR .= " and a.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
}
if ( $CUSTOMERUSERDEF2 != "" )
{
	$urlstr = $urlstr."&CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
	$WHERE_STR .= " and a.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
}
if ( $CUSTOMERUSERDEF3 != "" )
{
	$urlstr = $urlstr."&CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
	$WHERE_STR .= " and a.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
}
if ( $CUSTOMERUSERDEF4 != "" )
{
	$urlstr = $urlstr."&CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
	$WHERE_STR .= " and a.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
}
if ( $CUSTOMERUSERDEF5 != "" )
{
	$urlstr = $urlstr."&CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
	$WHERE_STR .= " and a.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
}
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 ( $LINKMANUSERDEF1 != "" )
{
	$urlstr = $urlstr."&LINKMANUSERDEF1=".$LINKMANUSERDEF1;
	$WHERE_STR .= " and i.USERDEF1 like '%".$LINKMANUSERDEF1."%'";
}
if ( $LINKMANUSERDEF2 != "" )
{
	$urlstr = $urlstr."&LINKMANUSERDEF2=".$LINKMANUSERDEF2;
	$WHERE_STR .= " and i.USERDEF2 like '%".$LINKMANUSERDEF2."%'";
}
if ( $LINKMANUSERDEF3 != "" )
{
	$urlstr = $urlstr."&LINKMANUSERDEF3=".$LINKMANUSERDEF3;
	$WHERE_STR .= " and i.USERDEF3 like '%".$LINKMANUSERDEF3."%'";
}
if ( $LINKMANUSERDEF4 != "" )
{
	$urlstr = $urlstr."&LINKMANUSERDEF4=".$LINKMANUSERDEF4;
	$WHERE_STR .= " and i.USERDEF4 like '%".$LINKMANUSERDEF4."%'";
}
if ( $LINKMANUSERDEF5 != "" )
{
	$urlstr = $urlstr."&LINKMANUSERDEF5=".$LINKMANUSERDEF5;
	$WHERE_STR .= " and i.USERDEF5 like '%".$LINKMANUSERDEF5."%'";
}
if ( $COMPLAINT_TYPE != "" )
{
	$urlstr = $urlstr."&COMPLAINT_TYPE=".$COMPLAINT_TYPE;
	$WHERE_STR .= " and j.COMPLAINT_TYPE ='".$COMPLAINT_TYPE."'";
}
if ( $COMPLAINT_DATE1 != "" )
{
	$urlstr = $urlstr."&COMPLAINT_DATE1=".$COMPLAINT_DATE1;
	$WHERE_STR .= "  and j.COMPLAINT_DATE>='".$COMPLAINT_DATE1."'";
}
if ( $COMPLAINT_DATE2 != "" )
{
	$urlstr = $urlstr."&COMPLAINT_DATE2=".$COMPLAINT_DATE2;
	$WHERE_STR .= "  and j.COMPLAINT_DATE<='".$COMPLAINT_DATE2."'";
}
if ( $COMPLAINT_CONTENT != "" )
{
	$urlstr = $urlstr."&COMPLAINT_CONTENT=".$COMPLAINT_CONTENT;
	$WHERE_STR .= " and j.COMPLAINT_CONTENT like '%".$COMPLAINT_CONTENT."%'";
}
if ( $COMPLAINTUSERDEF1 != "" )
{
	$urlstr = $urlstr."&COMPLAINTUSERDEF1=".$COMPLAINTUSERDEF1;
	$WHERE_STR .= " and j.USERDEF1 like '%".$COMPLAINTUSERDEF1."%'";
}
if ( $COMPLAINTUSERDEF2 != "" )
{
	$urlstr = $urlstr."&COMPLAINTUSERDEF2=".$COMPLAINTUSERDEF2;
	$WHERE_STR .= " and j.USERDEF2 like '%".$COMPLAINTUSERDEF2."%'";
}
if ( $COMPLAINTUSERDEF3 != "" )
{
	$urlstr = $urlstr."&COMPLAINTUSERDEF3=".$COMPLAINTUSERDEF3;
	$WHERE_STR .= " and j.USERDEF3 like '%".$COMPLAINTUSERDEF3."%'";
}
if ( $COMPLAINTUSERDEF4 != "" )
{
	$urlstr = $urlstr."&COMPLAINTUSERDEF4=".$COMPLAINTUSERDEF4;
	$WHERE_STR .= " and j.USERDEF4 like '%".$COMPLAINTUSERDEF4."%'";
}
if ( $COMPLAINTUSERDEF5 != "" )
{
	$urlstr = $urlstr."&COMPLAINTUSERDEF5=".$COMPLAINTUSERDEF5;
	$WHERE_STR .= " and j.USERDEF5 like '%".$COMPLAINTUSERDEF5."%'";
}
$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 COMPLAINT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID\r\n        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 j.LINKMAN_ID = i.LINKMAN_ID\r\n        LEFT OUTER JOIN SYS_CODE k\r\n        ON j.COMPLAINT_TYPE = k.CODE_NO AND k.PARENT_NO = 'COMPLAINT_TYPE'\r\n        ".$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 ( $PAGE_COUNT < $CUR_PAGE )
{
	$CUR_PAGE = $PAGE_COUNT;
}
$query1 = "SELECT j.COMPLAINT_ID as COMPLAINT_ID ,j.TEL_NO as TEL_NO,j.ADDRESS as ADDRESS ,a.CUSTOMER_NAME as CUSTOMER_NAME,c.CODE_NAME as KIND,b.CODE_NAME as SELLMODE,k.CODE_NAME as COMPLAINT_TYPE,j.COMPLAINT_DATE as COMPLAINT_DATE,j.COMPLAINT_CONTENT as COMPLAINT_CONTENT,h.USER_NAME as USER_ID\r\n         from COMPLAINT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID\r\n         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 j.USER_ID = h.USER_ID\r\n         LEFT OUTER JOIN LINKMAN i ON j.LINKMAN_ID = i.LINKMAN_ID\r\n         LEFT OUTER JOIN SYS_CODE k\r\n         ON j.COMPLAINT_TYPE = k.CODE_NO AND k.PARENT_NO = 'COMPLAINT_TYPE'\r\n        ".$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( );
}
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 "&CUR_PAGE=1&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>\r\n        <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>\r\n        <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>\r\n        <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>\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 "页&nbsp;共&nbsp;";
echo $CUSTOMER_COUNT;
echo "&nbsp;条\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n  <tr class=\"TableHeader\">\r\n";
if ( $DELETE_FLAG == 0 || find_id( $MANAGERS, $LOGIN_USER_ID ) )
{
	echo "    \t<td nowrap align=\"center\">选择</td>\r\n ";
}
echo "     <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=";
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -