⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 querycustlist.jsp

📁 JAVA实现的中小型企业CRM客户关系管理系统
💻 JSP
字号:
<%@ page language="java" pageEncoding="gbk"%>
<jsp:directive.page import="com.crm.common.CommUtil"/>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean" %>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html" %>
<%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic" %>
<jsp:directive.page import="java.util.Date"/>
<jsp:directive.page import="java.text.SimpleDateFormat"/>

<%

	
	SimpleDateFormat sd = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
	String strnow = sd.format(new Date());
	request.setAttribute("now",strnow);
	
 
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
if(null==request.getAttribute("stype")){
	request.setAttribute("stype",request.getParameter("stype"));
}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<base href="<%=basePath %>"/>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>所有客户列表</title>
<link href="<%=basePath %>skin/default/default.css" rel="stylesheet" type="text/css" />
<script src="<%=basePath %>js/util.js" language="javascript" type="text/javascript"></script>
</head>

<body class="mainbody">
<table width="100%" border="0" cellspacing="2" cellpadding="0">
  <tr>
    <td class="tdgriud">首页&nbsp;&gt;&gt;&nbsp;
    <logic:equal name="stype" value="1">客服管理&nbsp;&gt;&gt;&nbsp;客户查询(添加客户服务信息)
    </logic:equal>
    <logic:equal name="stype" value="2">客服管理&nbsp;&gt;&gt;&nbsp;客户查询(添加客户投诉信息)
    </logic:equal>
    <logic:equal name="stype" value="3">短信管理&nbsp;&gt;&gt;&nbsp;客户查询(短信发送)
    </logic:equal>     
    </td>
  </tr>
</table>
<fieldset>
	<table width="100%" border="0" cellspacing="0" cellpadding="0" class="querytable">
	<html:form action="manage/custinfo">
	<html:hidden property="paramtype"/>
	<input type="hidden" name="stype" value="<%=request.getParameter("stype") %>">
		<tr>
			<td align="right">客户姓名:</td>
			<td><html:text property="cust_name"/></td>
			<td align="right">客户电话号码:</td>
			<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<html:text property="telephone"/></td>
		</tr>
		<tr>
			<td align="right">性别:</td>
			<td>
			    <html:select property="sex">
					<html:option value="">全部</html:option>			    
			    	<html:option value="0">女</html:option>
			    	<html:option value="1">男</html:option>
			    </html:select>
			</td>
			<td align="right">日期:</td>
    		<td ><html:text property="start_date"></html:text>
		    	<a href="javascript:void(0)" onclick="if(self.gfPop)gfPop.fPopCalendar(document.all.item('start_date'));return false;">
		 		<html:img align="absmiddle" page="/include/calendar/calbtn.gif" width="34" height="22" border="0" alt=""/>
		 		</a>	
		</tr>
		<tr>
			<td align="right">客户状态:</td>
			<td>
				<html:select property="state">
				<html:option value="">全部</html:option>
					<html:options collection="custstatelist" labelProperty="fieldname" property="fieldcode"/>
			    </html:select>
			</td>
			<td align="right">客户类别:</td>
			<td>
			    <html:select property="type">
				<html:option value="">全部</html:option>
					<html:options collection="custtypelist" labelProperty="fieldname" property="fieldcode"/>
			    </html:select>
			</td>
		</tr>
		<tr>
			<td align="right">资金范围:</td>
			<td>
				<html:text property="minFunds"/>
				--<html:text property="maxFunds"/>
			</td>
			<td align="right">定价范围:</td>
			<td>
				<html:text property="minPay"/>
				--<html:text property="maxPay"/>
			</td>
		</tr>	
		<tr>
			<td align="right">客服人员:</td>
			<td>
    	<html:select property="employee_id">
    		<html:option value="">全部</html:option>
    		<html:options collection="userlist" property="id" labelProperty="employee_name"/>
    	</html:select>
			</td>
			<td align="right">排序字段:</td>
			<td>
			    <html:select property="orderbycolumn">
				<html:option value="">创建日期</html:option>
					<html:option value="funds desc">资金</html:option>
					<html:option value="pay desc">定价</html:option>
					<html:option value="state">状态</html:option>
			    </html:select>
			</td>
		</tr>
		<tr>
			<td colspan="4" align="center"><input type="submit" name="Submit" class="btn_save" value="查 询" />
			
			&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
			<font color="blue">友情提示:红色表示客户已经被停止服务,黄色表示服务已经到期</font>
			</td>
		</tr>
	</html:form>
	</table>
</fieldset>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tdborder">
  <tr>
    <td width="4%" class="tdtitle">编号</td>
    <td width="6%" class="tdtitle">客户姓名</td>
    <td width="4%" class="tdtitle">性别</td>
    <td width="6%" class="tdtitle">客户资金</td>
    <td width="5%" class="tdtitle">定价</td>
    <td width="10%" class="tdtitle">
    <logic:equal name="stype" value="3">短信</logic:equal>服务开始日期
    </td>
    <td width="10%" class="tdtitle">
    <logic:equal name="stype" value="3">短信</logic:equal>服务结束日期</td>
    <td width="8%" class="tdtitle">客户类型</td>
    <td width="4%" class="tdtitle">状态</td>
    <td width="15%" class="tdtitle">联系电话</td>    
    <td width="4%" class="tdtitle">客服人员</td>
    <td width="7%" class="tdtitle">
    <logic:equal name="stype" value="1">增加客户服务
    </logic:equal>
    <logic:equal name="stype" value="2">增加客户投诉
    </logic:equal>
    <logic:equal name="stype" value="3">发送短信
    </logic:equal>    
    </td>
  </tr>
  <logic:notEmpty name="custinfolist"> 
  <logic:iterate id="custinfo" name="custinfolist" indexId="index">
  <tr  onmouseover="TdMouseOver(this);" onmouseout="TdMouseOver(this);" 
  ondblclick="window.open('<%=basePath %>manage/custinfo.do?paramtype=detail&id=<bean:write property="id" name="custinfo"/>','_new')"
  <logic:equal name="custinfo" property="state" value="2">
   bgcolor="red"
  </logic:equal>
    <logic:lessThan name="custinfo" property="end_date" value="${now}">
  bgcolor="yellow"
  </logic:lessThan> 
  <logic:equal name="stype" value="3">
     <logic:lessThan name="custinfo" property="message_end_date" value="${now}">
  bgcolor="yellow"
  </logic:lessThan>  
	</logic:equal>    
  >
    <td align="center" class="tdbg">
    <bean:write name="custinfo" property="id"/>
    </td>
    <td class="tdbg" style="cursor:hand;" onclick="window.open('<%=basePath %>manage/custinfo.do?paramtype=detail&id=<bean:write property="id" name="custinfo"/>','_new')">
    	<u><bean:write name="custinfo" property="cust_name" /></u>
    </td>
    <td class="tdbg"><bean:write name="custinfo" property="sex_name" /></td>
    <td class="tdbg"><bean:write name="custinfo" property="funds" /></td>
    <td class="tdbg"><bean:write name="custinfo" property="pay" /></td>
    <td class="tdbg"><bean:write name="custinfo" property="start_date" /></td>
    <td class="tdbg"><bean:write name="custinfo" property="end_date" /></td>
    <td class="tdbg"><bean:write name="custinfo" property="type_name" /></td>
    <td class="tdbg"><bean:write name="custinfo" property="state_name" /></td>
    <td class="tdbg"><bean:write name="custinfo" property="telephone" />
    
    ,<bean:write name="custinfo" property="mobile" />
    
    ,<bean:write name="custinfo" property="elesephone" /></td>
      <td class="tdbg">
    <logic:empty name="custinfo" property="employee_name">
	&nbsp;
    </logic:empty>
    <bean:write name="custinfo" property="employee_name" />
    
    </td>  
    <td align="center" class="tdbg">
   
        <logic:equal name="stype" value="1">
        <%
			if(CommUtil.hasRight(session,"20101")){
		%>    
    		<input type="button"  value="增加客户服务" onclick="location.href='<%=basePath %>manage/custserv.do?paramtype=initinsert&service_type=1&id=<bean:write property="id" name="custinfo"/>'"/>
    	<%
    		}
    	 %>	
    	 </logic:equal>
        <logic:equal name="stype" value="2">
        <%
			if(CommUtil.hasRight(session,"20201")){
		%>    
    	<input type="button"  value="增加客户投诉" onclick="location.href='<%=basePath %>manage/custserv.do?paramtype=initinsert&service_type=2&id=<bean:write property="id" name="custinfo"/>'"/>&nbsp;
    	<%
    		}
    	 %>	
    	 </logic:equal>

   
        <%
			if(CommUtil.hasRight(session,"40101")){
		%> 
    <logic:equal name="stype" value="3">
    <input type="button"  value="发送短信" onclick="location.href='<%=basePath %>manage/message.do?task=initadd&service_type=3&cust_id=<bean:write property="id" name="custinfo"/>'"/>&nbsp;
     </logic:equal> 
    	<%
    		}
    	 %>	     
  
    </td>
  </tr>
  </logic:iterate> 
  </logic:notEmpty>  
  
</table>
<logic:present name="pagetool">  
    <bean:write name="pagetool" filter="false"/>
   </logic:present>
</body>
</html>

⌨️ 快捷键说明

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