📄 historydiarysearch.jsp
字号:
<%@ page import="java.util.*"%>
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="cn.com.aheadsoft.util.UserInfo"%>
<%@ page import="cn.com.aheadsoft.recordset.DiaryDateRecordSet"%>
<%@ page import="java.sql.Date"%>
<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="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>
<%
/**
* 工作日记历史数据查询
* zenghongli
* 2004.9.14
*/
String userID=null;
String userName=null;
String selfDeptID=null;
userInfo=(UserInfo)session.getAttribute("userinfo") ;
String[][] userDept;
String deptID[];
userID=userInfo.GetUserID();
userName=userInfo.GetRealName();
userDept=userDeptManage.serReset();
String userIDShow=request.getParameter("select1");
//add by zenghongli 2004.6.10 根据时段查询日记
String startdate=request.getParameter("startdate");
String enddate=request.getParameter("enddate");
if(null==startdate)
startdate="";
if(null==enddate)
enddate="";
// --------- end
String deptIDShow=request.getParameter("deptSel");
selfDeptID=deptIDShow;
String[] self=userDeptManage.getName(userIDShow);
String userNameShow=self[3];
String deptName=self[1];
Calendar calendar= Calendar.getInstance();
int nowYear=calendar.get(Calendar.YEAR);
if(userIDShow==null){
deptIDShow=userInfo.GetDeptID();
selfDeptID=userInfo.GetDeptID();
userIDShow=userID;
userNameShow=userName;
deptName=userInfo.GetDeptName();
}
%>
<script src="/krm/jsp/jscript/Calendar.js"></script>
<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(id,date) {
document.form2.diaryDate_ID.value =id;
document.form2.dateStr.value=date;
document.form2.submit();
return true;
}
function popup(){
var dateP="[1-9]\\d{3}-((0[1-9])|(1[0-2]))-((0[1-9])|[1-2]\\d|(3[0-1]))";
var date1=document.form1.startdate.value;
var date2=document.form1.enddate.value;
var user=document.form1.select1.value;
var index=document.form1.select1.selectedIndex;
var userNameShow=document.form1.select1.options[index].text;
if((date1!=null)&&(date1!="")&&(date2!=null)&&(date2!="")){
//防止日期类型非空，如果为空达梦数据库会瘫痪 2004.9.14
if((date1.match(dateP))&&(date2.match(dateP))){
alert("您现在正在查询历史数据，此过程将会比较费时！请耐心等待！");
window.open('/krm/jsp/diamanage/diarySearch/historyDiaryDisplay.jsp?startdate=' + date1 + '&enddate=' + date2 + '&user=' + user + '&userNameShow=' + userNameShow,'查看工作日记','width=600,height=400,left=50,top=50,resizable=1,scrollbars=yes');
}
}
}
function subNameSel() {
var dateP="[1-9]\\d{3}-((0[1-9])|(1[0-2]))-((0[1-9])|[1-2]\\d|(3[0-1]))";
if(document.form1.startdate.value==null||document.form1.startdate.value==""){
alert("请选择开始日期");
return false;
}
else if(((document.form1.startdate.value!=null)||(document.form1.startdate.value!=""))&&(!document.form1.startdate.value.match(dateP))){
alert("请输入合乎“0000-00-00”的时间！");
document.form1.startdate.focus();
return false;
}
else if(document.form1.enddate.value==null||document.form1.enddate.value==""){
alert("请选择结束日期");
return false;
}
else if(((document.form1.enddate.value!=null)||(document.form1.enddate.value!=""))&&(!document.form1.enddate.value.match(dateP))){
alert("请输入合乎“0000-00-00”的时间！");
document.form1.enddate.focus();
return false;
}
else
return true;
}
function useSet(){
var deptID=document.form1.deptSel.value;
var deptUser=new Array();
var len=document.form1.select1.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.select1.remove(i);
}
for(i=0;i<deptUser.length;i++){
if(deptID==deptUser[i][0]){
if(isIE){
document.form1.select1.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.select1.appendChild(infoid);
}
}
}
}
-->
</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/DiarySearchServlet" onSubmit="return subNameSel();">
<input type="hidden" name="userIDShow" value="<%=userIDShow%>">
<input type="hidden" name="status" value="historysearch">
<%//if(userList.size()!=0){%>
<table border="0" cellpadding="0" cellspacing="0" width="98%" align="center">
<tr><td colspan="2" class="tdA">工作日记历史数据查询</td></tr>
<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;
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></td>
<td width="50%" class="common bgcolor" > 姓名：
<select name="select1">
<%
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></td>
</tr>
<tr>
<td class="common bgcolor" colspan="2"> 日期：
<input type="text" class="middle" name="startdate" value="<%=startdate%>" >
<a href="javascript:show_calendar('form1.startdate');"><image src="/krm/jsp/image/selectdate.gif" border="0"></a>
至
<input type="text" class="middle" name="enddate" value="<%=enddate%>" >
<a href="javascript:show_calendar('form1.enddate');" id="DateSelect"><image src="/krm/jsp/image/selectdate.gif" border="0"></a>
</td>
</tr>
<tr>
<td class="tdC" colspan="4" align="center">
<input name="imageField" type="submit" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" value="查 询" onClick="return popup()">
<input name="button" type="button" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" onClick="document.location.href='javascript:history.back(1);'" value="返 回" >
</td>
</tr>
</table>
</form>
<form name="form2" method="post" action="/krm/servlet/DiaryDefaultSetServlet">
<input type="hidden" name="diaryDate_ID">
<input type=hidden name="dateStr">
<%
String status="jumpToSearchAmend";
%>
<input type="hidden" name="status" value=<%=status%>>
<table border="0" width="98%" align="center" height="20%" class="collapse">
<tr width="95%">
<%
String StartDate = (String)request.getAttribute("startdate");
if(null==StartDate)
//StartDate="";
StartDate=startdate;
String EndDate=(String)request.getAttribute("enddate");
if(null==EndDate)
//EndDate="";
EndDate=enddate;
%>
<td class="tdB" colspan="13" ><%=deptName%> <%=userNameShow%> <%=StartDate%>
至 <%=EndDate%> 工作日记列表</td>
</tr>
<tr align="center">
<td class="tdB">日期</td>
<td class="tdB">姓名</td>
<td class="tdB">工作</td>
<td class="tdB">学习</td>
<td class="tdB">运动</td>
<td class="tdB">休息</td>
<td class="tdB">个人</td>
<td class="tdB">部门</td>
<td class="tdB">考核</td>
</tr>
<%
String week=null;
if(userIDShow!=null){
//人员权限校验，用户对该ID有查看权
/*if(!userPurviewManage.havePurview(userList,userIDShow)){
//response.sendRedirect("/krm/jsp/diamanage/noPopedom.htm");
response.sendRedirect("/krm/jsp/util/info.jsp?msg=您没有权限操作!如有疑问请与系统管理员联系!");
return;
}*/
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-"+month);
/*if(null!=startdate){
diaryDateRecordSet=diaryManage.getDiaryDateByUser_Date(userID,startdate,enddate);
startdate=null;
}else{
diaryDateRecordSet=(DiaryDateRecordSet)request.getAttribute("DiaryDateRecordSet");
}*/
diaryDateRecordSet=(DiaryDateRecordSet)request.getAttribute("DiaryDateRecordSet");
/*if(null==diaryDateRecordSet){
diaryDateRecordSet=diaryManage.getDiaryDateByUser_Date(userID,startdate,enddate);
}*/
if((null!=diaryDateRecordSet)&&(diaryDateRecordSet.size()>0)){int i=0;
while(diaryDateRecordSet.next()){ i++;
%>
<tr align="center" <%if(i%2==0){%> class="bgcolor"<%}%>>
<%
//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;
}
%>
<td class="common"><a href="/krm/servlet/DiaryQueryCountServlet?status=i&diaryDate_ID=<%=diaryDateRecordSet.getDIA_ID()%>&userIDShow=<%=userIDShow%>&userNameShow=<%=userNameShow%>&dateStr=<%=diaryDateRecordSet.getDIA_writeDate()%>"><%=diaryDateRecordSet.getDIA_writeDate()%></a>（星期<%=week%>）</td>
<td class="common"><%=userNameShow%></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"><%=diaryDateRecordSet.getDIA_selfInfo()%></td>
<td class="common"><%=diaryDateRecordSet.getDIA_deptCheck()%></td>
<td class="common"><%=diaryDateRecordSet.getDIA_checkInfo()%></td>
</tr>
<%
}
%>
<%
}
}
%><tr ><td colspan="13" class="tdC"> </td>
</tr>
</table>
<%//}else{%>
<!--<table border="0" width="98%" align="center" height="20%" class="collapse">
<tr>
<td class="common" align="center">您没有可查看的数据！请与管理员联系</td>
</tr>
</table>-->
<%//}%>
</form>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -