📄 timestatistics.jsp
字号:
<%@ page import="java.util.*"%>
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="cn.com.aheadsoft.util.UserInfo"%>
<%@ page import="java.sql.Date"%>
<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月9日
*/
String userID=null;
String userName=null;
String userDeptName=null; //新增
String selfDeptID=null;
//权限校验
userInfo=(UserInfo)session.getAttribute("userinfo") ;
userID=userInfo.GetUserID();
userName=userInfo.GetRealName();
userDeptName=userInfo.GetDeptName();
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||month==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();
}
-->
</script>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
<table width="98%" 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="" >
<input type="hidden" name="userNameShow">
<table border="0" cellpadding="0" cellspacing="0" width="98%" align="center" class="collapse">
<tr >
<td class="tdA" colspan="12" ><%=userDeptShow%> <%=userNameShow%> <%=year%>年<%=month%>月 时间统计(单位:小时)</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>
<td class="tdB" align="center">详细信息</td>
</tr>
<%
if(userIDShow!=null&&year!=null&&month!=null){
String workTime,contTime,meetingTime,onwayTime,onlineTime,yanqingTime,learnTime,sportTime,restTime,sleepTime;
float work=0,cont=0,meeting=0,onway=0,online=0,yanqing=0,learn=0,sport=0,rest=0,sleep=0;
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-"+month);
int num=diaryDateRecordSet.size();//新增
int i=0;
while(diaryDateRecordSet.next()){
i++;
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Float.parseFloat(workTime.trim());
learn=learn+Float.parseFloat(learnTime.trim());
sport=sport+Float.parseFloat(sportTime.trim());
rest=rest+Float.parseFloat(restTime.trim());
%>
<%
String week="";
java.sql.Date d=java.sql.Date.valueOf(diaryDateRecordSet.getDIA_writeDate());
switch(d.getDay()){
case 0: week="日";break;
case 1: week="一";break;
case 2: week="二";break;
case 3: week="三";break;
case 4: week="四";break;
case 5: week="五";break;
case 6: week="六";break;
}
%>
<tr align="center" <%if(i%2==0){%> class="bgcolor"<%}%>>
<td class="common"><%=diaryDateRecordSet.getDIA_writeDate()%>（星期<%=week%>）</td>
<td class="common"><%=diaryDateRecordSet.getDIA_workTime()%></td>
<td class="common"><%=diaryDateRecordSet.getDIA_learnTime()%></td>
<td class="common"><%=diaryDateRecordSet.getDIA_sportTime()%></td>
<td class="common"><%=diaryDateRecordSet.getDIA_restTime()%></td>
<td class="common"><a href="/krm/jsp/diamanage/diarySearch/showDetailTimeInfo.jsp?date=<%=diaryDateRecordSet.getDIA_writeDate()%>&userID=<%=userIDShow%>&userName=<%=userNameShow%>&deptName=<%=userDeptShow%>">查看</a></td>
</tr>
<%
}
float avgWork=0,/*avgCont=0,avgMeeting=0,avgOnway=0,avgOnline=0,avgYanqing=0,*/avgStudy=0,avgSport=0,avgRest=0/*,avgSleep=0*/;
String strAvgWork="0.0",strAvgStudy="0.0",strAvgSport="0.0",strAvgRest="0.0";
if(num>0){
avgWork=work/num;
avgStudy=learn/num;
avgSport=sport/num;
avgRest=rest/num;
//avgSleep=sleep/num;
strAvgWork=String.valueOf(avgWork);
strAvgStudy=String.valueOf(avgStudy);
strAvgSport=String.valueOf(avgSport);
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>-->
<tr>
<td class="common" align="center">总计</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>
<td class="common" align="center"></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>
<td class="common" align="center"></td>
</tr>
<%
}
%>
</table>
</form>
<input type="button" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" value="返 回" onClick="javascript:history.back(1);">
<br>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -