📄 yearcount.jsp
字号:
<%@ page import="java.util.*"%>
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="cn.com.aheadsoft.util.UserInfo"%>
<jsp:useBean id="userInfo" scope="page" class="cn.com.aheadsoft.util.UserInfo" />
<jsp:useBean id="diaryManage" scope="page" class="cn.com.aheadsoft.manage.DiaryManage" />
<jsp:useBean id="diaryDateRecordSet" scope="page" class="cn.com.aheadsoft.recordset.DiaryDateRecordSet" />
<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月15日
工作日记个人年度时间统计
*/
String userID=null;
String userName=null;
String userDeptName=null; //新增
String selfDeptID=null;
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);
selfDeptID=userInfo.GetDeptID();
String userIDShow=request.getParameter("user");
String year=request.getParameter("year");
String month=request.getParameter("month");
String deptIDShow=request.getParameter("dept");
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;
}
}
-->
</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" class="tdC">
<form name="form1" method="post" action="" onSubmit="return sub();">
<input type="hidden" name="userNameShow">
<table border="0" width="98%" align="center" height="20%" bordercolor="A1B7DB" class="collapse">
<tr >
<td class="tdA" colspan="12" ><%=userDeptShow%> <%=userNameShow%> <%=year%>年 时间统计(单位：小时)</td>
</tr>
<tr >
<td class="tdB" align="center" width="20%">月份</td>
<td class="tdB" align="center" width="20%">工作</td>
<td class="tdB" align="center" width="20%">学习</td>
<td class="tdB" align="center" width="20%">运动</td>
<td class="tdB" align="center" width="20%">休息</td>
</tr>
<%
if(userIDShow!=null&&year!=null/*&&month!=null*/){
//人员权限校验，用户对该ID有查看权
String restTime,sportTime,workTime,learnTime;
//float rest=0,sport=0,work=0,learn=0;
int rest=0,sport=0,work=0,learn=0;
float avgWork=0,avgLearn=0,avgSport=0,avgRest=0;
//int year1=Integer.parseInt(year)-1;
//int year2=Integer.parseInt(year)+1;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-"+month);
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year1+"-12-31",year2+"-01-01");
float[] iCount=new float[4];
iCount[0]=0f;
iCount[1]=0f;
iCount[2]=0f;
iCount[3]=0f;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-01-01",year+"-01-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-01");
if(null!=diaryDateRecordSet){
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr>
<td class="common" align="center">1</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-02-01",year+"-02-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-02");
if(null!=diaryDateRecordSet){
//int num=diaryDateRecordSet.size();//新增
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr class="bgcolor">
<td class="common" align="center">2</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-03-01",year+"-03-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-03");
if(null!=diaryDateRecordSet){
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr>
<td class="common" align="center">3</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-04-01",year+"-04-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-04");
if(null!=diaryDateRecordSet){
//int num=diaryDateRecordSet.size();//新增
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr class="bgcolor">
<td class="common" align="center">4</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-05-01",year+"-05-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-05");
if(null!=diaryDateRecordSet){
//int num=diaryDateRecordSet.size();//新增
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -