crm_project_info_query_list.jsp

java开发的办公系统 1.系统管理 (地区管理,部门管理,菜单管理,用户管理,角色管理,权限) 2.工作流管理 (流程类别,流程) 3.字典管理 (国家,省份,城市,公共数据字典) 4.项目

<%@ include file="../../include/configuration.jsp"%>
<%@ include file="../../include/authorizemanager.jsp"%>
<%@ page import="com.vere.crm.customer.bean.*"%>
<%@ page import="com.vere.crm.customer.item.*"%>
<%@ page import="com.vere.crm.project.bean.*"%>
<%@ page import="com.vere.crm.project.item.*"%>
<%@ page contentType="text/html; charset=gb2312" %>
<%
	ParameterUtils.setCharacterEncoding(request);
	String status=ParameterUtils.getString(request,"status");
	
	
	int pageNo=ParameterUtils.getInt(request,"page");
	if(pageNo<=0)
	{
		pageNo=1;
	}
	Crm_project_infoItem item=new Crm_project_infoItem();
	String customer_id=ParameterUtils.getString(request,"customer_id");//客户名称
	String customer_name=ParameterUtils.getString(request,"customer_name");//客户名称
	Crm_customer_infoItem crm_customer_infoItem=new Crm_customer_infoItem();
	crm_customer_infoItem.setCustomer_name(customer_name);
	
	String customer_contact_id=ParameterUtils.getString(request,"customer_contact_id");//客户联系人
	String contact_name=ParameterUtils.getString(request,"contact_name");//客户联系人
	Crm_customer_contactItem crm_customer_contactItem=new Crm_customer_contactItem();
	crm_customer_contactItem.setContact_name(contact_name);
	
	String project_rake=ParameterUtils.getString(request,"project_rake");//项目等级
	String develop_language=ParameterUtils.getString(request,"develop_language");//开发语言
	String project_language=ParameterUtils.getString(request,"project_language");//项目语种
	String project_type=ParameterUtils.getString(request,"project_type");//项目类型
	String project_origin=ParameterUtils.getString(request,"project_origin");//项目来源
	String project_business=ParameterUtils.getString(request,"project_business");//所属行业
	String project_status=ParameterUtils.getString(request,"project_status");//项目状态
		String register_name=ParameterUtils.getString(request,"register_name");//登记人
	String register_area_id=ParameterUtils.getString(request,"area_id");//登记地区
	String register_date=ParameterUtils.getString(request,"register_date");//登记日期
		String register_date_start=ParameterUtils.getString(request,"register_date_start");//登记开始日期
	String register_date_end=ParameterUtils.getString(request,"register_date_end");//登记结束日期
	String sign_date_start=ParameterUtils.getString(request,"sign_date_start");//签约开始日期
	String sign_date_end=ParameterUtils.getString(request,"sign_date_end");//签约结束日期
	String programmer=ParameterUtils.getString(request,"programmer");//参与项目人
	String workflow_state_id=ParameterUtils.getString(request,"workflow_state_id");//流转状态
	SessionFactory sessionFactory=(SessionFactory)session.getAttribute("sessionFactory");
	 Manager_usersItem usersItem=sessionFactory.getManager_usersItem();
	String receive_user=usersItem.getUsername();//接受人
	String register_area_nodepath=usersItem.getArea_id();//地区
	item.setCustomer_id(customer_id);
	item.setCrm_customer_infoItem(crm_customer_infoItem);
	item.setCustomer_contact_id(customer_contact_id);
	item.setCrm_customer_contactItem(crm_customer_contactItem);
	item.setProject_rake(project_rake);
	item.setDevelop_language(develop_language);
	item.setProject_language(project_language);
	item.setProject_type(project_type);
	item.setProject_origin(project_origin);
	item.setProject_business(project_business);
	item.setProject_status(project_status);
	item.setWorkflow_state_id(workflow_state_id);
	item.setRegister_name(register_name);
	item.setRegister_area_id(register_area_id);
	item.setProgrammer(programmer);
	item.setRegister_date(register_date);
	item.setRegister_date_start(register_date_start);
	item.setRegister_date_end(register_date_end);
	Crm_project_contractItem crm_project_contractItem=new Crm_project_contractItem();
	crm_project_contractItem.setSign_date(sign_date_start);
	crm_project_contractItem.setEnd_date(sign_date_end);
	item.setCrm_project_contractItem(crm_project_contractItem);
	
	item.setReceive_user(receive_user);
	item.setRegister_area_nodepath(register_area_nodepath);
	Crm_project_infoBean bean=new Crm_project_infoBean();
	List list=bean.find(item,pageNo,pageSize);
	int totalRecord=bean.getTotalRecord();
	int page_num=(int)Math.ceil((double)totalRecord/pageSize);

	Oa_dictionaryXmlBean oa_dictionaryXmlBean=new Oa_dictionaryXmlBean();
	List oa_dictionaryXmlList=oa_dictionaryXmlBean.findXmlByArray("19,20,21,22,15,16,23");
%>
<html>
<head>
<title><%=titleName%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/css.css" rel="stylesheet" type="text/css">
<script language="javascript" src="../../js/check.js"></script>
<link href="../../css/date.css" rel="stylesheet" type="text/css">
<script src="../../js/ShowDate.js"></script>
<script language="javascript">
    init();
</script>
</head>
<body>
<form name="form1" method="post" action="">
	<table border="0" cellpadding="0"  cellspacing="0" class="firsttable">
		<tr>
			<td align="center" valign="top">
				<table  class="centertable">
					<tr>
						<td>
						</td>
					</tr>
					<tr>
						<td align="center" valign="top">
							<table class="containContentsTable">
								<tr>
									<td colspan="2">
									<%
										out.println("<table  class='contentsTable'   border='0' cellpadding='0'  cellspacing='1'>");
										out.println("<tr class='tr1'  align=center ><td width=5% ></td><td>项目名称</td><td>客户名称</td><td>客户联系人</td><td>项目经理</td><td>设计师</td><td>程序员</td><td>客服</td><td>项目签约时间</td><td>项目结束时间</td><td>开发语言</td><td>项目语种</td><td>项目金额</td><td>城市</td><td>登记日期</td><td>登记人</td><td>登记地区</td><td>流转状态</td></tr>");
										Iterator e=list.iterator();
										while(e.hasNext()){
											Crm_project_infoItem rItem=(Crm_project_infoItem)e.next();
											out.println("<tr align='center' onMouseOver=\"old_bg=this.getAttribute('bgcolor');this.setAttribute('bgcolor', '"+Constants.T_BGCOLOR_OVER+"', 0);\" onMouseOut=\"this.setAttribute('bgcolor', old_bg, 0);\" bgColor='"+Constants.T_BGCOLOR+"' >");
											out.println("<td><input type='checkbox' name=checkvalue value='"+rItem.getId()+"'></td>");
											out.println("<td>"+rItem.getProject_name()+"</td>");//项目名称
											out.println("<td>");
											out.println(rItem.getCrm_customer_infoItem().getCustomer_name());
											out.println("</td>");
											out.println("<td>");
											out.println(rItem.getCrm_customer_contactItem().getContact_name());
											out.println("</td>");
											out.println("<td>"+rItem.getProject_manager()+"</td>");//项目经理
											out.println("<td>"+rItem.getDesigner()+"</td>");//设计师
											out.println("<td>"+rItem.getProgrammer()+"</td>");//程序员
											out.println("<td>"+rItem.getServicer()+"</td>");//客服
											out.println("<td>"+DateUtils.formatString(rItem.getCrm_project_contractItem().getSign_date())+"</td>");//项目签约时间
											out.println("<td>"+DateUtils.formatString(rItem.getCrm_project_contractItem().getEnd_date())+"</td>");//项目结束时间
											out.println("<td>");
											out.println(rItem.getDevelop_language_dictionaryname());//开发语言
											out.println("</td>");
											out.println("<td>");
											out.println(rItem.getProject_language_dictionaryname());//项目语种
											out.println("</td>");
											out.println("<td>"+rItem.getProject_price()+"</td>");//项目金额
											
											out.println("<td>");
											out.println(rItem.getDictionary_cityItem().getCity_cn_name());
											out.println("</td>");
											
											out.println("<td>"+DateUtils.formatString(rItem.getRegister_date())+"</td>");//登记日期
											out.println("<td>"+rItem.getRegister_name()+"</td>");//登记人
											out.println("<td>"+rItem.getRegister_area()+"</td>");//登记地区
					
											out.println("<td>"+rItem.getWorkflow_state_name()+"</td>");//流程状态
											out.println("</tr>");
										}
										out.println("</table>");
									%>									</td>
								</tr>
								<tr>
									<td>
										<input name="cboAll" type="checkbox" id="cboAll" value="checkbox" onClick="checkBoxAll()"> 全选									</td>
									<td align="right" class="pagelink" > 共 <%=totalRecord%> 条, 共 <%=page_num%> 页, 第 <%=pageNo%> 页 <a href="javascript:first()">第一页</a> <a href="javascript:next()">下一页</a> <a  href="javascript:pre()">上一页</a> <a  href="javascript:last()" >最后一页</a>
									<select name="position" id="position"  onChange="goposition()">
										<option value=""></option>
										<%
											for(int i=1;i<=page_num;i++)
											{
												out.println("<option ");
												if(pageNo==i){out.println("selected");}
													out.println(" value="+i+">");
												out.println(i);
												out.println("</option>");
											}
										%>
									</select>									</td>
								</tr>
							</table>
						</td>
					</tr>
					<tr>
						<td></td>
					</tr>
				</table>
			</td>
		</tr>
</table>
	<input type="hidden" name="status" value="">
	<input type="hidden" name="page" value=<%=pageNo%>>
	<input type="hidden" name="totalpage" value=<%=page_num%>>
	<input type="hidden" name="id" value="">
	<input type="hidden" name="ids" value="">
</form>
</body>
</html>
<script language="JavaScript" >
	function checkBoxAll()//全选
	{
		var form = form1;
		for(i=0; i<form.elements.length; i++)
		{
			if(form.elements[i].type=="checkbox" &&  form.elements[i].name=="checkvalue")
			{
				form.elements[i].checked = form.cboAll.checked;
			}
		}
	}
	
	var j=0;
	function selectBox()
	{
		var form=form1;
		j=0;
		for(i=0; i<form.elements.length; i++)
		{
			if(form.elements[i].type=="checkbox" &&  form.elements[i].name=="checkvalue")
			{
				if(form.elements[i].checked==true)
				{
					form.id.value=form.elements[i].value;
					j++;
				}
			}
		}
	}

	function jump(flag)
	{
		var form=form1;
		selectBox();
		if(form.id.value=="")
		{
			alert("请选择一条记录");
			return;
		}
		if(j>1)
		{
			alert("一次只能选择一条记录");
			return;
		}
		if(flag=='edit')
			location="crm_project_infoedit.jsp?id="+form.id.value;
		
		if(flag=='look')
			location="crm_project_infolook.jsp?id="+form.id.value;
		if(flag=='sign')
			location="crm_project_contractedit.jsp?crm_project_info_id="+form.id.value;
		if(flag=='config')
			location="crm_project_configedit.jsp?id="+form.id.value;
		if(flag=='workflow')
		{
			var url="crm_project_info_workflow.jsp?id="+form.id.value;
			location=url;
		}
		if(flag=='flowrecord')
			location="crm_project_info_flowrecord.jsp?id="+form.id.value;
		if(flag=='look_process')
			location="crm_project_progressedit.jsp?id="+form.id.value;
		if(flag=='look_space')
			location="crm_project_spaceedit.jsp?id="+form.id.value;
		if(flag=='look_report')
			location="crm_project_report.jsp?crm_project_info_id="+form.id.value;
		if(flag=='look_maintain')
			location="crm_project_service.jsp?crm_project_info_id="+form.id.value;
		
	}


	function removeSelect()
	{
		var form=form1;
		for(i=0; i<form.elements.length; i++)
		{
			if(form.elements[i].type=="checkbox" &&  form.elements[i].name=="checkvalue")
			{
				if(form.elements[i].checked==true)
				{
					form.ids.value+=form.elements[i].value+",";
				}
			}
		}
		if(form.ids.value=="")
		{
			alert("请选择要删除的记录");
			return;
		}
		if(confirm("是否要删除选择的记录")==false)
			return;
		form.status.value="removeSelect";
		form.submit();
	}

	function remove(id)
	{
		if(confirm("是否要删除选择的记录")==true)
		{
			var form=form1;
			form.id.value=id;
			form.status.value="remove";
			form.submit();
		}
	}

	

	function add()
	{
		location="crm_project_infoadd.jsp";
	}

	function query()
	{
		var form=form1;
		form.submit();
	}

	function first()
	{
		var form=form1;
		if(eval(form.page.value)==1)
			return;
		form.page.value=1;
		form.submit();
	}

	function next()
	{
		var form=form1;
		if(eval(form.page.value)>=eval(form.totalpage.value))
			return;
		form.page.value=eval(form.page.value)+1;
		form.submit();
	}

	function last()
	{
		var form=form1;
		if(eval(form.page.value)>=eval(form.totalpage.value))
			return;
		form.page.value=eval(form.totalpage.value);
		form.submit();
	}

	function pre()
	{
		var form=form1;
		if(form.page.value<=1)
			return;
		form.page.value=eval(form.page.value)-1;
		form.submit();
	}

	function  goposition()
	{
		var form=form1;
		form.page.value=form.position.value;
		form.submit();
	}
</script>