text_tj_area_status.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");
	
	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 listR=bean.getArea_Status_tj(item);
	List list=(ArrayList)listR.get(0);
	int status_count=Integer.parseInt(listR.get(1).toString());
%>
<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>
									<%
										out.println("<table  class='contentsTable'   border='0' cellpadding='0'  cellspacing='1'>");
										out.println("<tr class='tr1'  align=center ><td></td>");
										int[] column_count=new int[status_count];//列总数
										int column_total_count=0;
										for(int i=0;i<status_count;i++)
										{
											Crm_project_infoItem rItem=(Crm_project_infoItem)list.get(i);
											out.println("<td>"+rItem.getWorkflow_state_name()+"</td>");
										}
										out.println("<td>总项目数</td></tr>");
										for(int i=0;i<list.size();i=i+status_count)
										{
											Crm_project_infoItem rItem=(Crm_project_infoItem)list.get(i);
											int row_count=0;
											out.println("<tr align='center' class='tr2' ><td>"+rItem.getRegister_area()+"</td>");
											for(int j=i;j<i+status_count;j++)
											{
												rItem=(Crm_project_infoItem)list.get(j);
												out.println("<td>"+rItem.getWorkflow_state_num()+"</td>");
												column_count[j%status_count]+=Integer.parseInt(rItem.getWorkflow_state_num());
												row_count+=Integer.parseInt(rItem.getWorkflow_state_num());
											}
											out.println("<td>"+row_count+"</td></tr>");
										}
										out.println("<tr align='center' class='tr2' ><td>状态项目总数</td>");
										for(int i=0;i<status_count;i++)
										{
											out.println("<td>"+column_count[i]+"</td>");
											column_total_count+=column_count[i];
										}
										out.println("<td>"+column_total_count+"</td></tr>");
										out.println("</table>");
									%>									</td>
								</tr>
							</table>
						</td>
					</tr>
					<tr>
						<td></td>
					</tr>
				</table>
			</td>
		</tr>
</table>
	</form>
</body>
</html>