📄 showmonth.jsp
字号:
/*
如果 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>
<td width="23%" height="15" align="left" class="common" nowrap>年月
<select name="select2">
<%
for(int i=nowYear;i>2000;i--){
%>
<option value="<%=i%>" <%if(yyear!=null&&yyear.equals(String.valueOf(i))){%> selected <%}%>><%=i%></option>
<%
}
%>
</select>
年
<select name="select3">
<%
for(int i=1;i<=12;i++){
checked="";
if(mmonth!=null&&mmonth.equals(String.valueOf(i))){
checked=" selected";
}
%>
<option value="<%=i%>"<%=checked%>><%=i%></option>
<%
}
%>
</select>
月 </td>
<td width="30%" height="15" colspan="3" align="left" class="common" nowrap>
<input type="submit" value="查 询" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" >
<!-- <input type="button" value="返 回 " onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" onClick="history.back(1);">-->
</td>
</tr>
<!--add by tang 2004.06.02 end-->
</table>
<table border="0" width="98%" class="collapse">
<tr>
<td height="18" colspan="8" class="tdC" ><%=yyear%>年<%=mmonth%>月份实施计划列表
</td>
</tr>
<tr>
<!--<td width="6%" height="15" align="center" class="common" nowrap>序号</td>-->
<td width="6%" height="15" align="center" class="tdB" nowrap>编号</th>
<td width="10%" height="15" align="center" class="tdB" nowrap>任务名称</th>
<td width="12%" height="15" align="center" class="tdB" nowrap>计划完成时间</th>
<td width="12%" height="15" align="center" class="tdB" nowrap>计划完成时间</th>
<td width="36%" height="15" align="center" class="tdB" nowrap>实施计划概述</td>
<td width="8%" height="15" align="left" class="tdB" nowrap>分管</th>
<td width="8%" height="15" align="left" class="tdB" nowrap>负责人</td>
<td width="8%" height="15" align="left" class="tdB" nowrap>考核</td>
</tr>
<%int i = 0;%>
<%if(null != set){
set.beforefirst();
while(set.next()){
DetailBusiness dbus = new DetailBusiness();
DetailRecordSet dset = new DetailRecordSet();
dbus.setQueryWhereforD_Serial(set.getD_Serial());
flag = dbus.execute("query");
dset = dbus.getRecordSet();
if(dset!=null){
dset.beforefirst();
dset.next();
// boolean hasRight=false;
String deptid=userInfo.GetDeptID();
hasRight=false;
Iterator it = userids.iterator();
while(it.hasNext())
{
//System.out.println(it.next().toString());
//out.println(set.getD_IntendPerson());
String strit = it.next().toString();
if( (strit.toString()).equals(dset.getD_ManagerID())
|| (strit.toString()).equals(dset.getUser_ID())
|| (strit.toString()).equals(dset.getD_AidPerson())
|| ( ((dset.getD_IntendPerson()).indexOf("#"+strit.toString()+"#"))!=-1)
)
{
hasRight=true;
}
}
}
Date jFinishDate=Date.valueOf(set.getP_Date());
java.util.Date nowDate=new java.util.Date();
int fday=jFinishDate.getDate();
int nday=nowDate.getDate();
int fmonth=jFinishDate.getMonth();
int nmonth=nowDate.getMonth();
boolean jredcheck=false;
boolean jyellowcheck=false;
boolean jblackcheck=false;
if(fmonth<nmonth){
jblackcheck=true;
}else if(fmonth==nmonth){
if((fday-nday<=3)&&(fday-nday>=0)){
jredcheck=true;
}
if((fday-nday<=10)&&(fday-nday>=0)){
jyellowcheck=true;
}
if(fday-nday<0){
jblackcheck=true;
}
}
%>
<tr <%
if((i+1)%2==0){
%> class="bgcolor"<%}%>>
<!-- <td width="6%" height="15" align="center" class="common" bgcolor="#F7FDF3"><%//=i+1%></td>-->
<td width="6%" height="15" align="left" class="common" nowrap><%if(null != set.getD_Num()){%><%=StringFormat.changeHTMLTags(set.getD_Num())%><%}%></td>
<td width="10%" height="15" align="left" class="common" nowrap><%if(null != set.getD_Topic()){%><a <%if(hasRight){%> href="#" onClick="MM_openBrWindow('/krm/servlet/DetailServlet?module=detail&&status=q&&queryterm=primarykey&&id=<%=set.getD_Serial()%>&&isproblem=0','detail','scrollbars=yes,resizable=yes,width=800,height=500,left=0,top=0')"<%}%>><%=StringFormat.changeHTMLTags(set.getD_Topic())%></a><%}%></td>
<td width="12%" height="15" align="center" class="common" nowrap><%=set.getP_StartDate()%></td>
<td width="12%" height="15" align="center" class="common" nowrap><%=set.getP_Date()%></td>
<td width="36%" height="15" align="left" class="common" >
<a href="/krm/servlet/DetailServlet?module=deplan&&status=q&&id=<%=set.getP_ID()%>&&D_Serial=<%=set.getD_Serial()%>">
<%if(jredcheck){%> <font color="#FF0000"> <%}
else if(jyellowcheck){%><font color="#FF9900"> <%}
else if(jblackcheck){%> <font color="#666666"> <%}
else{%> <font color="#0000FF"><%}%>
<%=StringFormat.changeHTMLTags(set.getP_Brief())%>
</font>
</a></td>
<td width="8%" height="15" align="left" class="common" nowrap>
<%//System.out.print("----------"+set.getUser_ID());
if((null != dset.getUser_ID()) && (!dset.getUser_ID().trim().equals(""))){
String aidpersonid = dset.getUser_ID();
PersonInfoBusiness bibu = new PersonInfoBusiness();
bibu.setQueryWhere(aidpersonid);
bibu.execute("query");
PersonInfoRecordSet PiRdSet = bibu.getRecordSet();
PiRdSet.beforefirst();
PiRdSet.next();
out.println(StringFormat.changeHTMLTags(PiRdSet.getI_Name()));
}else{
out.println("无");}
%></td>
<td width="8%" height="15" align="left" class="common" ><%=set.getI_Name()%></td>
<td width="8%" height="15" align="left" class="common" ><%=set.getP_Check()%></td>
</tr>
<%i++;
}}%>
<tr><td colspan="8" class="tdC"> </td>
</tr>
</table>
<br>
<table border="0" width="98%" class="collapse">
<tr>
<td height="18" colspan="6" class="tdC" ><%=yyear%>年<%=mmonth%>月份实施过程列表</td>
</tr>
<tr>
<td width="6%" height="20" align="center" class="tdB" nowrap>编号</td>
<td width="10%" height="15" align="center" class="tdB" nowrap>任务名称</th>
<td width="12%" height="20" align="center" class="tdB" nowrap>过程完成时间</td>
<td width="56%" height="20" align="center" class="tdB" nowrap>实施过程概述</td>
<td width="8%" height="15" align="left" class="tdB" nowrap>分管</th>
<td width="8%" height="15" align="left" class="tdB" nowrap>负责人</td>
</tr>
<%int j = 0;%>
<%if(null != dpset){
while(dpset.next()){
DetailBusiness detbus = new DetailBusiness();
DetailRecordSet detset = new DetailRecordSet();
detbus.setQueryWhereforD_Serial(dpset.getD_Serial());
flag = detbus.execute("query");
detset = detbus.getRecordSet();
if(detset!=null){
detset.beforefirst();
detset.next();
//boolean hasRight=false;
hasRight=false;
Iterator it = userids.iterator();
while(it.hasNext())
{
//System.out.println(it.next().toString());
//out.println(set.getD_IntendPerson());
String strit = it.next().toString();
if( (strit.toString()).equals(detset.getD_ManagerID())
|| (strit.toString()).equals(detset.getUser_ID())
|| (strit.toString()).equals(detset.getD_AidPerson())
|| ( ((detset.getD_IntendPerson()).indexOf("#"+strit.toString()+"#"))!=-1)
)
{
hasRight=true;
}
}
}
Date FinishDate=Date.valueOf(dpset.getP_FinishDate());
java.util.Date nowDate=new java.util.Date();
int day1=FinishDate.getDate();
int day2=nowDate.getDate();
int month1=FinishDate.getMonth();
int month2=nowDate.getMonth();
boolean redcheck=false;
boolean yellowcheck=false;
boolean blackcheck=false;
if(month1<month2){
blackcheck=true;
}else if(month1==month2){
if((day1-day2<=3)&&(day1-day2>=0)){
redcheck=true;
}
if((day1-day2<=10)&&(day1-day2>=0)){
yellowcheck=true;
}
if(day1-day2<0){
blackcheck=true;
}
}
%>
<tr <%
if((j+1)%2==0){
%> class="bgcolor"<%}%>>
<td width="6%" height="15" align="left" class="common" nowrap><%if(null != detset.getD_Topic()){%><%=StringFormat.changeHTMLTags(detset.getD_Num())%><%}%></td>
<td width="10%" height="15" align="left" class="common" nowrap><%if(null != detset.getD_Topic()){%><a <%if(hasRight){%> href="#" onClick="MM_openBrWindow('/krm/servlet/DetailServlet?module=detail&&status=q&&queryterm=primarykey&&id=<%=detset.getD_Serial()%>&&isproblem=0','detail','scrollbars=yes,resizable=yes,width=800,height=500,left=0,top=0')"<%}%>><%=StringFormat.changeHTMLTags(detset.getD_Topic())%></a><%}%></td>
<td width="12%" height="15" align="center" class="common" nowrap><%=dpset.getP_FinishDate()%></td>
<td width="56%" height="15" align="left" class="common" >
<a href="/krm/servlet/DetailServlet?module=deproccess&&status=q&&id=<%=dpset.getP_ID()%>&&D_Serial=<%=dpset.getD_Serial()%>">
<%if(redcheck){%> <font color="#FF0000"> <%}
else if(yellowcheck){%><font color="#FF9900"> <%}
else if(blackcheck){%> <font color="#666666"> <%}
else{%> <font color="#0000FF"><%}%>
<%=StringFormat.changeHTMLTags(dpset.getP_Brief())%>
</font>
</a></td>
<td width="8%" height="15" align="left" class="common" nowrap>
<%if((null != detset.getUser_ID()) && (!detset.getUser_ID().trim().equals(""))){
String aidpersonid = detset.getUser_ID();
PersonInfoBusiness bibu = new PersonInfoBusiness();
bibu.setQueryWhere(aidpersonid);
bibu.execute("query");
PersonInfoRecordSet PiRdSet = bibu.getRecordSet();
PiRdSet.beforefirst();
PiRdSet.next();
out.println(StringFormat.changeHTMLTags(PiRdSet.getI_Name()));
}else{
out.println("无");}
%></td>
<td align="left" class="common" width="8%" nowrap >
<%if(null != detset.getD_ManagerName())
out.println(StringFormat.changeHTMLTags(detset.getD_ManagerName()));
%>
</td>
</tr>
<%j++;
}}%>
<tr><td colspan="6" class="tdC"> </td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -