📄 deptyearcount.jsp
字号:
<%@ page import="java.util.*"%>
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="cn.com.aheadsoft.util.UserInfo"%>
<%@ page import="cn.com.aheadsoft.recordset.PersonInfoRecordSet"%>
<jsp:useBean id="userPurviewManage" scope="page" class="cn.com.aheadsoft.manage.UserPurviewManage" />
<jsp:useBean id="userInfo" scope="page" class="cn.com.aheadsoft.util.UserInfo" />
<jsp:useBean id="periodManage" scope="page" class="cn.com.aheadsoft.manage.PeriodManage" />
<jsp:useBean id="diaryManage" scope="page" class="cn.com.aheadsoft.manage.DiaryManage" />
<jsp:useBean id="periodRecordSet" scope="page" class="cn.com.aheadsoft.recordset.PeriodRecordSet" />
<jsp:useBean id="userDeptManage" scope="page" class="cn.com.aheadsoft.manage.UserDeptManage" />
<html>
<head>
<link rel="stylesheet" type="text/css" href="/krm/jsp/css/css.css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<%
/*
新增：曾红立
时间：2004年2月18日
说明：部门年度统计页面
*/
String userID;
String userName;
String userDeptName; //新增
String selfDeptID;
//String error;
//权限校验
userInfo=(UserInfo)session.getAttribute("userinfo") ;
/*List userList=userPurviewManage.getUserPurview(userInfo,"5","1","q");
if(userList==null){
response.sendRedirect("/krm/jsp/nologin.htm");
return;
}*/
String[][] userDept;
int deptNum=1;
String deptID[];
userID=userInfo.GetUserID();
userName=userInfo.GetRealName();
userDeptName=userInfo.GetDeptName();
//userDept=userDeptManage.serReset(userList);
userDept=userDeptManage.serReset();
selfDeptID=userInfo.GetDeptID();
PersonInfoRecordSet personInfoRecordSet=null;
String showDeptName=null;//用于显示选择的部门名称
String showSelectYear=null;//用于显示选择的年度
String userIDShow=request.getParameter("user");
String year=request.getParameter("year");
String month=request.getParameter("month");
String deptIDShow=request.getParameter("dept");
//String existRecordSet=(String)session.getAttribute("existRecordSet");//是否存在项目设置记录
String existRecordSet=(String)request.getAttribute("existRecordSet");//是否存在项目设置记录
if(null==existRecordSet){
/* 如果为空，则进行提示，以防止用户刷新页面时进行报错显示！*/
//response.sendRedirect("/krm/jsp/diamanage/diarySearch/tip.htm");
response.sendRedirect("/krm/jsp/util/info.jsp?msg=请点击部门年度统计刷新本页面!");
return;
}
if(existRecordSet.equals("1")){
personInfoRecordSet=(PersonInfoRecordSet)request.getAttribute("personInfoRecordSet");
showDeptName=(String)request.getAttribute("deptName");
showSelectYear=(String)request.getAttribute("year");
}else {
personInfoRecordSet=null;
}
int size=personInfoRecordSet.size();
personInfoRecordSet.beforefirst();
String[] userNames=new String[size];
List workCount=new ArrayList();
List studyCount=new ArrayList();
List sportCount=new ArrayList();
List restCount=new ArrayList();
workCount=(List)request.getAttribute("workCount");
studyCount=(List)request.getAttribute("studyCount");
sportCount=(List)request.getAttribute("sportCount");
restCount=(List)request.getAttribute("restCount");
selfDeptID=deptIDShow;
String self[]=userDeptManage.getName(userIDShow);
String userNameShow=self[3];
String userDeptShow=self[1]; //新增
Calendar calendar= Calendar.getInstance();
int nowYear=calendar.get(Calendar.YEAR);
if(userIDShow==null||year==null){
deptIDShow=userInfo.GetDeptID();
selfDeptID=userInfo.GetDeptID();
userIDShow=userID;
userNameShow=userName;
userDeptShow=userDeptName; //新增
year=String.valueOf(nowYear);
month=String.valueOf(calendar.get(Calendar.MONTH)+1);
}
%>
<script language="JavaScript">
<!--
isNav = (navigator.appName.indexOf("Netscape") != -1) ? true : false;
isIE = (navigator.appName.indexOf("Microsoft") != -1) ? true : false;
function fsubmit(){
document.form2.submit();
}
/*function sub() {
var name=document.form1.select1.value;
if(name==null||name==""){
//document.form1.study.focus();
alert("请选择好人员在看！");
return false;
}else{
document.form1.userNameShow.value=name;
return true;
}
}*/
function useSet(){
var deptID=document.form1.deptSel.value;
var deptUser=new Array();
var len=document.form1.user.options.length;
<%
for(int i=0;i<userDept.length;i++){
out.println("deptUser["+i+"]=new Array();");
for(int j=0;j<4;j++){
/*
如果 userDept[i][2]为空，则不显示
userDept[i][2]存储的是系统所有用户的 userID，该用户被禁用，则不显示
修改：曾红立
时间：2004年3月2日
*/
if(null==userDept[i][2])
continue;
out.println("deptUser["+i+"]["+j+"]='"+userDept[i][j]+"'");
}
}
%>
for(var i=len;i>=0;i--){
document.form1.user.remove(i);
}
for(i=0;i<deptUser.length;i++){
if(deptID==deptUser[i][0]){
if(isIE){
document.form1.user.options.add(new Option(deptUser[i][3],deptUser[i][2]));
}else{
infoid=document.createElement("option");
infoid.value=deptUser[i][2];
infoid.text=deptUser[i][3];
document.form1.user.appendChild(infoid);
}
}
}
}
function atSubmit(){
//alert(document.form1.chkuser.checked);
//alert(document.form1.chkmonth.checked);
if((document.form1.chkuser.checked==true)&&(document.form1.chkmonth.checked==true)){
document.form1.status.value="usermonth";
//alert(document.form1.status.value);
}else if((document.form1.chkuser.checked==true)&&(document.form1.chkmonth.checked==false)){
document.form1.status.value="useryear";
//alert(document.form1.status.value);
}else if((document.form1.chkuser.checked==false)&&(document.form1.chkmonth.checked==true)){
document.form1.status.value="deptmonth";
//alert(document.form1.status.value);
}else
document.form1.status.value="deptyear";
document.form1.submit();
return true;
}
function changeuser(){
//zenghongli 2004.4.27
/*if(document.form1.user.disabled=="")
{
document.form1.user.disabled="true";
}
else
{
document.form1.user.disabled="";
}*/
//alert("A"+document.form1.user.disabled);
document.form1.user.disabled=!document.form1.chkuser.checked;
}
function changemonth(){
//alert("A"+document.form1.month.disabled);
document.form1.month.disabled=!document.form1.chkmonth.checked;
}
-->
</script>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
<table width="100%" align="center" border="0" cellpadding="0" cellspacing="0">
<tr height="8">
<td class="trA"> 您的位置：工作日记 >> <font class="fontcolor">日记统计</font></td>
</tr>
<tr height="8">
<td></td>
</tr>
<tr>
<td align="center">
<form name="form1" method="post" action="/krm/servlet/DiaryTimeCountServlet" onSubmit="return atSubmit();">
<input type="hidden" name="status" value="">
<table border="0" cellpadding="0" cellspacing="0" width="98%" align="center">
<tr>
<td class="tdA" colspan="7" >
部门年度时间统计</td>
</tr>
<input type="hidden" name="userNameShow">
<tr>
<td width="50%" class="common bgcolor"> 部门：
<select name="deptSel" onChange="useSet()">
<%
String checked="";
if(deptIDShow!=null&&deptIDShow.equals(userDept[0][0])){
checked=" selected";
}
out.println("<option value=\""+userDept[0][0]+"\""+checked+">"+userDept[0][1]+"</option>");
for(int i=0;i<userDept.length-1;i++){
String temp[]=userDept[i];
String deptID1="";
checked="";
deptID1=userDept[i][0];
if(null==userDept[i+1][0])
continue;
userDeptName=userDept[i][1];
if(deptIDShow.equals(userDept[i+1][0])){
checked=" selected";
}
if(!deptID1.equals(userDept[i+1][0])){
out.println("<option value=\""+userDept[i+1][0]+"\""+checked+">"+userDept[i+1][1]+"</option>");
}
}
%>
</select>
<!-- add by zenghongli 2004.6.1 -->
<td width="50%" class="common bgcolor">
<input type="checkbox" name="chkuser" value="0" onClick="changeuser()" >
姓名：
<select name="user" disabled>
<%
checked="";
for(int i=0;i<userDept.length;i++){
if(userIDShow.equals(userDept[i][2])){
checked=" selected";
}else{
checked="";
}
/*
如果 userDept[i][2]为空 则不显示
*/
if(null==userDept[i][2])
continue;
if(selfDeptID.equals(userDept[i][0])){
out.println("<option value=\""+userDept[i][2]+"\""+checked+">"+userDept[i][3]+"</option>");
}
}
%>
</select>
<input type="hidden" name=UserID value=<%=userIDShow%>>
</td>
<!-- end -->
</tr>
<tr>
<td width="50%" class="common bgcolor" > 年份：
<select name="select2">
<%
checked="";
for(int i=nowYear;i>2003;i--){
if(year!=null&&year.equals(String.valueOf(i))){
checked=" selected";
}
%>
<option value="<%=i%>"<%=checked%>><%=i%></option>
<%
}
%>
</select>
年
</td>
<td width="50%" class="common bgcolor">
<input type="checkbox" name="chkmonth" value="0" onClick="changemonth()" >
月份：
<select name="month" disabled>
<%
for(int i=1;i<=12;i++){
checked="";
if(month!=null&&month.equals(String.valueOf(i))){
checked=" selected";
}
%>
<option value="<%=i%>"<%=checked%>><%=i%></option>
<%
}
%>
</select>
月 </td>
</tr>
<tr>
<td align="center" colspan="2" class="tdC" height="25"><input name="imageField" type="submit" value="统 计" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1">
<input name="button" type="button" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" onClick="document.location.href='/krm/jsp/diamanage/diaryMod/diaryMod.jsp'" value="返 回" ></td>
</tr>
</table>
</form>
<table border="0" cellpadding="0" cellspacing="0" width="98%" align="center" class="collapse">
<tr >
<td class="tdA" colspan="12" ><%=showDeptName%> <%=showSelectYear%>年 时间统计(单位:小时)</td>
</tr>
<tr >
<td class="tdB" align="center">姓名</td>
<td class="tdB" align="center">工作</td>
<td class="tdB" align="center">学习</td>
<td class="tdB" align="center">运动</td>
<td class="tdB" align="center">休息</td>
</tr>
<%
int work=0,study=0,sport=0,rest=0;
if(null!=personInfoRecordSet){
for(int i=0;i<size;i++){
personInfoRecordSet.next();
%>
<tr <%if((i+1)%2==0){%> class="bgcolor"<%}%>>
<td class="common" align="center"><%=personInfoRecordSet.getI_Name()%></td>
<td class="common" align="center"><%=workCount.get(i).toString()%></td>
<td class="common" align="center"><%=studyCount.get(i).toString()%></td>
<td class="common" align="center"><%=sportCount.get(i).toString()%></td>
<td class="common" align="center"><%=restCount.get(i).toString()%></td>
</tr>
<%
work=work+Integer.parseInt(workCount.get(i).toString());
study=study+Integer.parseInt(studyCount.get(i).toString());
sport=sport+Integer.parseInt(sportCount.get(i).toString());
rest=rest+Integer.parseInt(restCount.get(i).toString());
}
}
float avgWork=0,avgStudy=0,avgSport=0,avgRest=0;
avgWork=work/size;
avgStudy=study/size;
avgSport=sport/size;
avgRest=rest/size;
String strAvgWork=String.valueOf(avgWork);
String strAvgStudy=String.valueOf(avgStudy);
String strAvgSport=String.valueOf(avgSport);
String strAvgRest=String.valueOf(avgRest);
int iPos=strAvgWork.indexOf(".");
strAvgWork=strAvgWork.substring(0,iPos+2);
iPos=strAvgRest.indexOf(".");
strAvgRest=strAvgRest.substring(0,iPos+2);
iPos=strAvgStudy.indexOf(".");
strAvgStudy=strAvgStudy.substring(0,iPos+2);
iPos=strAvgSport.indexOf(".");
strAvgSport=strAvgSport.substring(0,iPos+2);
%>
<tr>
<td class="common" align="center">总计</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=study%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<tr class="bgcolor">
<td class="common" align="center">平均</td>
<td class="common" align="center"><%=strAvgWork%></td>
<td class="common" align="center"><%=strAvgStudy%></td>
<td class="common" align="center"><%=strAvgSport%></td>
<td class="common" align="center"><%=strAvgRest%></td>
</tr>
<tr>
<td class="tdC" colspan="5"> </td>
</tr>
</table>
<br>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -