📄 list.php
字号:
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.COMPLAINT_DATE>='".$COMPLAINT_DATE1."'";
}
else
{
$WHERE_STR .= " and j.COMPLAINT_DATE>='".$COMPLAINT_DATE1."'";
}
}
if ( $COMPLAINT_DATE2 != "" )
{
if ( $urlstr == "" )
{
$urlstr = "COMPLAINT_DATE2=".$COMPLAINT_DATE2;
}
else
{
$urlstr = $urlstr."&COMPLAINT_DATE2=".$COMPLAINT_DATE2;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.COMPLAINT_DATE<='".$COMPLAINT_DATE2."'";
}
else
{
$WHERE_STR .= " and j.COMPLAINT_DATE<='".$COMPLAINT_DATE2."'";
}
}
if ( $COMPLAINT_CONTENT != "" )
{
if ( $urlstr == "" )
{
$urlstr = "COMPLAINT_CONTENT=".$COMPLAINT_CONTENT;
}
else
{
$urlstr = $urlstr."&COMPLAINT_CONTENT=".$COMPLAINT_CONTENT;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.COMPLAINT_CONTENT like '%".$COMPLAINT_CONTENT."%'";
}
else
{
$WHERE_STR .= " and j.COMPLAINT_CONTENT like '%".$COMPLAINT_CONTENT."%'";
}
}
if ( $COMPLAINTUSERDEF1 != "" )
{
if ( $urlstr == "" )
{
$urlstr = "COMPLAINTUSERDEF1=".$COMPLAINTUSERDEF1;
}
else
{
$urlstr = $urlstr."&COMPLAINTUSERDEF1=".$COMPLAINTUSERDEF1;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.USERDEF1 like '%".$COMPLAINTUSERDEF1."%'";
}
else
{
$WHERE_STR .= " and j.USERDEF1 like '%".$COMPLAINTUSERDEF1."%'";
}
}
if ( $COMPLAINTUSERDEF2 != "" )
{
if ( $urlstr == "" )
{
$urlstr = "COMPLAINTUSERDEF2=".$COMPLAINTUSERDEF2;
}
else
{
$urlstr = $urlstr."&COMPLAINTUSERDEF2=".$COMPLAINTUSERDEF2;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.USERDEF2 like '%".$COMPLAINTUSERDEF2."%'";
}
else
{
$WHERE_STR .= " and j.USERDEF2 like '%".$COMPLAINTUSERDEF2."%'";
}
}
if ( $COMPLAINTUSERDEF3 != "" )
{
if ( $urlstr == "" )
{
$urlstr = "COMPLAINTUSERDEF3=".$COMPLAINTUSERDEF3;
}
else
{
$urlstr = $urlstr."&COMPLAINTUSERDEF3=".$COMPLAINTUSERDEF3;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.USERDEF3 like '%".$COMPLAINTUSERDEF3."%'";
}
else
{
$WHERE_STR .= " and j.USERDEF3 like '%".$COMPLAINTUSERDEF3."%'";
}
}
if ( $COMPLAINTUSERDEF4 != "" )
{
if ( $urlstr == "" )
{
$urlstr = "COMPLAINTUSERDEF4=".$COMPLAINTUSERDEF4;
}
else
{
$urlstr = $urlstr."&COMPLAINTUSERDEF4=".$COMPLAINTUSERDEF4;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.USERDEF4 like '%".$COMPLAINTUSERDEF4."%'";
}
else
{
$WHERE_STR .= " and j.USERDEF4 like '%".$COMPLAINTUSERDEF4."%'";
}
}
if ( $COMPLAINTUSERDEF5 != "" )
{
if ( $urlstr == "" )
{
$urlstr = "COMPLAINTUSERDEF5=".$COMPLAINTUSERDEF5;
}
else
{
$urlstr = $urlstr."&COMPLAINTUSERDEF5=".$COMPLAINTUSERDEF5;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where j.USERDEF5 like '%".$COMPLAINTUSERDEF5."%'";
}
else
{
$WHERE_STR .= " and j.USERDEF5 like '%".$COMPLAINTUSERDEF5."%'";
}
}
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 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;
$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 SELLER\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>提示", "没有符合条件的投诉记录" );
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 "页 共 ";
echo $CUSTOMER_COUNT;
echo " 条\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr class=\"TableHeader\">\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=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" && $ORDERFIELD == "KIND" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "KIND" )
{
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=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" && $ORDERFIELD == "SELLMODE" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SELLMODE" )
{
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=COMPLAINT_TYPE&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 == "COMPLAINT_TYPE" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "COMPLAINT_TYPE" )
{
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=COMPLAINT_DATE&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 == "COMPLAINT_DATE" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "COMPLAINT_DATE" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\">投诉内容</td>\r\n <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=TEL_NO&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 == "TEL_NO" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "TEL_NO" )
{
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=ADDRESS&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 == "ADDRESS" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "ADDRESS" )
{
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=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" && $ORDERFIELD == "SELLER" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SELLER" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\">操作</td>\r\n </tr>\r\n\r\n";
$CUSTOMER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
++$CUSTOMER_COUNT;
$COMPLAINT_ID1 = $ROW['COMPLAINT_ID'];
$CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
$KIND1 = $ROW['KIND'];
$SELLMODE1 = $ROW['SELLMODE'];
$COMPLAINT_TYPE1 = $ROW['COMPLAINT_TYPE'];
$COMPLAINT_DATE1 = $ROW['COMPLAINT_DATE'];
$COMPLAINT_CONTENT1 = $ROW['COMPLAINT_CONTENT'];
$SELLER1 = $ROW['SELLER'];
$TEL_NO1 = $ROW['TEL_NO'];
$ADDRESS1 = $ROW['ADDRESS'];
if ( $CUSTOMER_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
echo $CUSTOMER_NAME1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $KIND1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $SELLMODE1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $COMPLAINT_TYPE1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $COMPLAINT_DATE1;
echo "</td>\r\n <td nowrap align=\"center\" style=\"cursor:hand\" onclick=\"td_detail('";
echo $COMPLAINT_ID1;
echo "');\">点击查看</td>\r\n <td nowrap align=\"center\">";
echo $TEL_NO1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $ADDRESS1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $SELLER1;
echo "</td>\r\n <td nowrap align=\"center\"> <a href=\"javascript:show_detail(";
echo $COMPLAINT_ID1;
echo ");\"> 详细信息 </a></td>\r\n </tr>\r\n <tr class=\"TableData\" id=";
echo $COMPLAINT_ID1;
echo " style=\"display:none\" onDblClick=\"td_close('";
echo $COMPLAINT_ID1;
echo "');\" title=\"双击关闭子窗口\">\r\n <td align=\"left\" colspan=10>\r\n <span class=\"big4\">投诉内容:";
echo $COMPLAINT_CONTENT1;
echo "</span>\r\n </td>\t\r\n </tr>\r\n\r\n";
}
echo "</table>\r\n<br>\r\n<div align=\"center\">\r\n<input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='index.php'\">\r\n</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -