wuhb
/
oa


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347
							<%@ page language="java" contentType="text/html;charset=GBK"
	pageEncoding="GBK"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>	
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=GBK">
<title>流程表单统计</title>
<script src="/shares/js/jquery-1.8.2.js" type="text/javascript"></script>
<link href="${pageContext.request.contextPath }/liger/lib/ligerUI/skins/${sessionScope.css}/css/ligerui-all.css" 
	rel="stylesheet" type="text/css" />
<link href="/shares/Zebra_Datepicker-master/public/css/bootstrap.css" 
	rel="stylesheet" type="text/css" />
<link href="${pageContext.request.contextPath}/main.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="/shares/js/constant.js"></script> 
<script type="text/javascript" src="/shares/js/common.js"></script> 
<script type="text/javascript" src="/shares/js/yw/bpm/oa.js"></script>
<script type="text/javascript" src="/shares/Zebra_Datepicker-master/public/javascript/zebra_datepicker.js"></script>
<script type="text/javascript" src="/shares/js/yw/bpm/promptDefine.js"></script> 

<script type="text/javascript">

$(document).ready(function(){
	loadTypeTree("userButton",{type:"users", tab:"1", backId:"users", backName:"usersName"});
	loadTypeTree("deptButton",{type:"deptonly", tab:"1", backId:"depts", backName:"deptNames"});
	$("#starttime0").Zebra_DatePicker({
		format: 'Y',
		days: ['日', '一', '二', '三', '四', '五', '六'],
		months: ['1月', '2月', '3月', '4月', '5月', '6月', '7月', '8月', '9月', '10月', '11月', '12月'],
		lang_clear_date: '清除',
		show_select_today: '今天'
	});
	$("#starttime1").Zebra_DatePicker({
		format: 'Y-m',
		days: ['日', '一', '二', '三', '四', '五', '六'],
		months: ['1月', '2月', '3月', '4月', '5月', '6月', '7月', '8月', '9月', '10月', '11月', '12月'],
		lang_clear_date: '清除',
		show_select_today: '今天'
	});
	$("#starttime2").Zebra_DatePicker({
		format: 'Y-m-d',
		days: ['日', '一', '二', '三', '四', '五', '六'],
		months: ['1月', '2月', '3月', '4月', '5月', '6月', '7月', '8月', '9月', '10月', '11月', '12月'],
		lang_clear_date: '清除',
		show_select_today: '今天'
	});
	$("#starttime3").Zebra_DatePicker({
		format: 'Y-m-d',
		days: ['日', '一', '二', '三', '四', '五', '六'],
		months: ['1月', '2月', '3月', '4月', '5月', '6月', '7月', '8月', '9月', '10月', '11月', '12月'],
		lang_clear_date: '清除',
		show_select_today: '今天',
		pair : $("#endtime3")
	});
	$("#endtime3").Zebra_DatePicker({
		format: 'Y-m-d',
		days: ['日', '一', '二', '三', '四', '五', '六'],
		months: ['1月', '2月', '3月', '4月', '5月', '6月', '7月', '8月', '9月', '10月', '11月', '12月'],
		lang_clear_date: '清除',
		show_select_today: '今天'
	});
	changeTimer();
});

function changeTree(){
	var stype = $("#stype").val();
	if(stype == 0){
		$("#deptTree").show();
		$("#userTree").hide();
	} else {
		$("#deptTree").hide();
		$("#userTree").show();
	}
}
function changeTimer(){
	var dtype = $("#dtype").val();
	$("[id*='timer']").hide();
	if(dtype == 0){
		$("#timer0").show();
	} else if (dtype == 1){
		$("#timer1").show();
	} else if (dtype == 2){
		$("#timer2").show();
	} else if (dtype == 3){
		$("#timer3").show();
	}
}

function submitForm(submitType){
	var rs = true;
	var formStat =  $("#formStat").val();
	var stype = $("#stype").val();
	var target = null;
	var starttime = null;
	var endtime = null;
	if(formStat == ""){
		rs = $.validate({
			name : "formStat",
			model : [ {
				type : "require",
				msg : "请选择统计模板！"
			}]
		}) && rs;
	}
	if(stype == 0){
		rs = $.validate({
			name : "depts",
			model : [ {
				type : "require",
				msg : "请选择部门！"
			}]
		}) && rs;
		target = $("#depts").val();
	} else {
		rs = $.validate({
			name : "users",
			model : [ {
				type : "require",
				msg : "请选择人员！"
			}] 
		}) && rs;
		target = $("#users").val();
	}
	var dtype = $("#dtype").val();
	if(dtype == 0){
		rs = $.validate({
			name : "starttime0",
			model : [ {
				type : "require",
				msg : "请选择年份！"
			}]
		}) && rs;
		starttime = $("#starttime0").val();
	} else if (dtype == 1){
		rs = $.validate({
			name : "starttime1",
			model : [ {
				type : "require",
				msg : "请选择月份！"
			}]
		}) && rs;
		starttime = $("#starttime1").val();
	} else if (dtype == 2){
		rs = $.validate({
			name : "starttime2",
			model : [ {
				type : "require",
				msg : "请选择日期！"
			}]
		}) && rs;
		starttime = $("#starttime2").val();
	} else if (dtype == 3){
		rs = $.validate({
			name : "starttime3",
			model : [ {
				type : "require",
				msg : "请选择起始日期！" 
			}]
		}) && rs;
		rs = $.validate({
			name : "endtime3",
			model : [ {
				type : "require",
				msg : "请选择结束日期！" 
			}]
		}) && rs;
		starttime = $("#starttime3").val();
		endtime = $("#endtime3").val();
	} 
	
	if(rs){ 
		if(submitType == 'statFlowForm'){
			$.ajax({
		     		type:"POST",
		     		url:"FormStatAction.do?task=statFlowForm&formStat="+formStat+"&stype="
					+ stype + "&target=" + target + "&dtype=" + dtype + "&starttime=" + starttime + 
					"&endtime=" + endtime,
		     		data : "",
		     		async : true, 
					success:function(data){ 
		     			var jsonobj=eval('('+data+')');
		     			var result = jsonobj.result;
		     			if(result == "success"){
		     				var columnNames = jsonobj.columnNames; 
			     			var list = jsonobj.list;
			     			var titles = "";
			     			for(var i=0;i<columnNames.length;i++){ 
								titles = titles + "<th>"+columnNames[i]+"</th>";
					     	}
					     	$("#ctitle").html(titles);
							var trs = "";
					     	for(var i=0;i<list.length;i++){  
						     	var json = list[i];
						     	var tr = "";
						     	if(i%2==0){
						     		tr = "<tr class=\"one\">";
							    }else{
							    	tr = "<tr class=\"two\">";
								}
					     		for (x in json){
					     	       var r = json[x];
					     	       if(r == null){
									 r = "";
						     	   }
							       tr = tr + "<td>" + r + "</td>";
							    }
							    tr = tr + "</tr>";
							    trs = trs + tr; 
					     	}
					     	$("#trs").html(trs);
			     		}else{
							addError("数据查询错误，请检查配置！");
				     	} 
		     		} 
	 		});
			
			
			
			
			
			$.ajax({
	     		type:"POST",
	     		url:"FormStatAction.do?task=statFlowForm&formStat="+formStat+"&stype="
				+ stype + "&target=" + target + "&dtype=" + dtype + "&starttime=" + starttime + 
				"&endtime=" + endtime,
	     		data : "",
	     		async : true, 
				success:function(data){ 
	     			var jsonobj=eval('('+data+')');
	     			var result = jsonobj.result;
	     			if(result == "success"){
	     				var columnNames = jsonobj.columnNames;  
		     			var titles = "";
		     			for(var i=0;i<columnNames.length;i++){ 
							titles = titles + "<th>"+columnNames[i]+"</th>";
				     	}
				     	 
		     		}else{
						addError("数据查询错误，请检查配置！");
			     	} 
	     		} 
 		});
		}else if(submitType == 'exportFlowFormExcel'){
			document.cform.action="FormStatAction.do?task=exportFlowFormExcel&formStat="+formStat+"&stype="
			+ stype + "&target=" + target + "&dtype=" + dtype + "&starttime=" + starttime + "&endtime=" + endtime;
			document.cform.submit();
		}
	}
	return false;
}
</script>
</head>
<body>
<form action="FormStatAction.do" method="post" id="cform" name="cform" >
<div class="container-layout">
<div id="title" class="form-button" style="width: 100%;">
	<input onclick="closeTabUseInOA();" type="button" value="关闭" class="l-button">
</div>
<div class="default_search" style="margin: 0; width: 100%;">
	<ul class="list_search" style="width:600px;">
		<li class="title">统计模板：</li>
		<li class="text">
			<select id="formStat" name="formStat" style="width : 100px;">
			<option value="" >===请选择===</option>
				<c:forEach items="${requestScope.formStats }" var="item">
	 				<option value="${item.formStatId }" >${item.formStatName }</option>
	 			</c:forEach>
			</select>
		</li>
	</ul>
</div>
<div class="default_search" style="margin: 0; width: 100%; padding:0;">
	<ul class="list_search" style="width:600px;">
		<li class="title">统计对象：</li>
		<li class="text">
			<select id="stype" name="stype" style="width : 100px;" onchange="changeTree()">
				<option value="0" selected="selected">部门</option>
				<option value="1">员工</option>
			</select>
		</li>
		<li class="text" style="width : 300px;" id="deptTree">
			<input type="text" style="width : 200px;" id="deptNames" name="deptNames" value="${requestScope.companyname }">
			<input type="button" class="l-button" id="deptButton" name="deptButton" value="选择部门">
			<input type="hidden" id="depts" name="depts" value="${requestScope.companyid }">
		</li>
		<li class="text" style="display: none; width : 300px;" id="userTree">
			<input type="text" style="width : 200px;" id="usersName" name="usersName" value="">
			<input type="button" class="l-button" id="userButton" name="userButton" value="选择人员">
			<input type="hidden" id="users" name="users" value="">
		</li>
	</ul>
</div>
<div class="default_search" style="margin: 0; width: 100%; padding:0;">
	<ul class="list_search" style="width:700px;">
		<li class="title">统计时间：</li>
		<li class="text">
			<select id="dtype" name="dtype" style="width : 100px;" onchange="changeTimer()">
				<option value="0" selected="selected">年</option>
				<option value="1">月</option>
<!-- 				<option value="2">日</option> -->
				 <option value="3">区间</option>
			</select>
		</li>
		<li id="timer0" class="text" style="width : 300px; " >
			<input type="text" id="starttime0" name="starttime0" style="width: 100px;" value="${requestScope.nowyear}">
		</li>
		<li id="timer1" class="text" style="width : 300px; " >
			<input type="text" id="starttime1" name="starttime1" style="width: 100px;">
		</li>
		<li id="timer2" class="text" style="width : 300px;" >
			<input type="text" id="starttime2" name="starttime2" style="width: 100px;">
		</li>
		<li id="timer3" class="text" style="width : 450px; " >
			<input type="text" id="starttime3" name="starttime3" style="width: 100px;">
			&nbsp;至
			<input type="text" id="endtime3" name="endtime3" style="width: 100px;">
		</li>
	</ul>
</div>
<div class="default_search" style="margin: 0; width: 100%; padding:0;">
	<ul class="list_search" style="width:600px;">
		<li class="title">&nbsp;
		<input type="hidden" id="task" name="task" value="statFlowForm">
		</li>
		<li class="text">
			<input type="button" class="l-button" value="开始统计" onclick="submitForm('statFlowForm')">
		</li>
		<li class="text">
			<input type="button" class="l-button" value="导出EXCEL" onclick="submitForm('exportFlowFormExcel')">
		</li> 
	</ul>
</div>
</div>

<div class="forum-container">
		<span style="display:none"></span>
		<table class="index-table line" width="100%">
			<tr id="ctitle"> 
			</tr>
			<tbody id="trs">
			</tbody>
		</table>
	</div>
 
</form>
</body>
</html>