package com.taskManage.action;
import java.util.Date;
import java.util.List;
import org.apache.struts2.ServletActionContext;
import com.model.Task;
import com.taskManage.service.FeeInputService;
import com.taskManage.service.TaskInputService;
public class QueryTaskByUnitAction {
private Date doDate;// 根据办结日期分月查询所有任务单。
private TaskInputService taskInputService;
private List<Task> taskPeop;// 用于查询市委的任务单集合
private List<Task> taskGov;// 用于查询市政府的任务单集合
private Long year;// (年)根据办结日期分月查询所有任务单。
private Long month;// (月)根据办结日期分月查询所有任务单。
private Long peop;// 市委出现的次数
private Long gov;// 市政府出现的次数
private FeeInputService feeInputService;// 用于计算费用。
private Long taskId;// 用于计算任务费用。
Long[] totalFee = null;// 用于每个任务单的总费用。
private boolean b;// 判断查询结果是否为空
public boolean isB() {
return b;
}
public void setB(boolean b) {
this.b = b;
}
public Long[] getTotalFee() {
return totalFee;
}
public void setTotalFee(Long[] totalFee) {
this.totalFee = totalFee;
}
public List<Task> getTaskPeop() {
return taskPeop;
}
public void setTaskPeop(List<Task> taskPeop) {
this.taskPeop = taskPeop;
}
public List<Task> getTaskGov() {
return taskGov;
}
public void setTaskGov(List<Task> taskGov) {
this.taskGov = taskGov;
}
public Long getTaskId() {
return taskId;
}
public void setTaskId(Long taskId) {
this.taskId = taskId;
}
public FeeInputService getFeeInputService() {
return feeInputService;
}
public void setFeeInputService(FeeInputService feeInputService) {
this.feeInputService = feeInputService;
}
public Long getPeop() {
return peop;
}
public void setPeop(Long peop) {
this.peop = peop;
}
public Long getGov() {
return gov;
}
public void setGov(Long gov) {
this.gov = gov;
}
public Long getYear() {
return year;
}
public void setYear(Long year) {
this.year = year;
}
public Long getMonth() {
return month;
}
public void setMonth(Long month) {
this.month = month;
}
public Date getDoDate() {
return doDate;
}
public void setDoDate(Date doDate) {
this.doDate = doDate;
}
public TaskInputService getTaskInputService() {
return taskInputService;
}
public void setTaskInputService(TaskInputService taskInputService) {
this.taskInputService = taskInputService;
}
public String queryTaskByUnit() throws Exception {
taskPeop = taskInputService.queryTaskByUnit(year, month, "市委");
taskGov = taskInputService.queryTaskByUnit(year, month, "市政府");
peop = taskInputService.times(year, month, "市委");
gov = taskInputService.times(year, month, "市政府");
int s = peop.intValue() + gov.intValue();
totalFee = new Long[s];
Long peopFeeSum = new Long(0);
Long govFeeSum = new Long(0);
for (int i = 0; i < peop; i++) {
Long fee = (Long) feeInputService
.total(taskPeop.get(i).getTaskId());
totalFee[i] = fee == null ? new Long(0) : fee; //条件表达式。
peopFeeSum += fee == null ? 0 : fee;
}
for (int j = 0; j < gov; j++) {
Long fee = (Long) feeInputService.total(taskGov.get(j).getTaskId());
totalFee[peop.intValue() + j] = fee == null ? new Long(0) : fee;
govFeeSum += fee == null ? 0 : fee;
}
ServletActionContext.getRequest()
.setAttribute("peopFeeSum", peopFeeSum);
ServletActionContext.getRequest().setAttribute("govFeeSum", govFeeSum);
System.out.println("------peopFeeSum---------" + peopFeeSum);
if (peop > 0 || gov> 0) { //判断:只要市委和市政府存在,b就为真,结果显示页面就有值。
b = true;
} else {
b = false;
}
return "success";
}
}
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<%@ taglib prefix="s" uri="/struts-tags"%>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<link href="<%=request.getContextPath()%>/css/default.css"
type="text/css" rel="stylesheet" />
<script language="javascript" type="text/javascript"
src="<%=request.getContextPath()%>/datePicker/WdatePicker.js"></script>
</head>
<body>
<s:form action="queryTaskByUnit_queryTaskByUnit" theme="simple">
<table align="center" cellpadding="3" cellspacing="3" width="100%"
height="100%" border="0">
<thead>
<th height="30" align="left" class="title"> 各机关费用月报表</th>
</thead>
<tr>
<td align="center"><br> 请选择月份: <select
class="input_2" name="year">
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<option value="2011" selected="true">2011</option>
</select> 年 <select class="input_2" name="month">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select> 月 <input type="submit" value="查询" />
<input type="button" value="导出报表" /> <br><br>
<table class="query_table">
<thead>
<th>机关(任务下发单位)</th>
<th>任务编号</th>
<th>来宾单位</th>
<th>承办单位</th>
<th>下发日期</th>
<th>办结日期</th>
<th>任务费用(元)</th>
<th>费用合计(元)</th>
</thead>
<s:if test="b">
<tr>
<td rowspan="<s:property value="peop"/>">市委</td>
<s:set name="flag" value="0" id="flag" />
<s:subset source="#request.taskPeop " start="0" count="peop">
<s:iterator var="task" status="counts">
<s:if test="#flag<peop">
<td><s:property value="#task.taskId"></s:property></td>
<td><s:property value="#task.guestUnit"></s:property></td>
<td><s:property value="#task.doUnit"></s:property></td>
<td><s:date name="#task.lssuedDate" format="yyyy-MM-dd" /></td>
<td><s:date name="#task.doDate" format="yyyy-MM-dd" /></td>
<td><s:property value="totalFee[#flag]"></s:property></td>
<s:if test="#flag==0">
<td rowspan="<s:property value="peop"/>"><s:property
value="#request.peopFeeSum" /></td>
</s:if>
<s:set name="flag" value="#flag+1" id="flag" />
</s:if>
</tr>
</s:iterator>
</s:subset>
<tr>
<td rowspan="<s:property value="gov"/>">市政府</td>
<s:set name="flag" value="peop" id="flag" />
<s:subset source="#request.taskGov" start="0" count="gov">
<s:iterator var="taskGov" status="counts">
<s:if test="#flag<peop+gov">
<td><s:property value="#taskGov.taskId"></s:property></td>
<td><s:property value="#taskGov.guestUnit"></s:property></td>
<td><s:property value="#taskGov.doUnit"></s:property></td>
<td><s:date name="#taskGov.lssuedDate" format="yyyy-MM-dd" /></td>
<td><s:date name="#taskGov.doDate" format="yyyy-MM-dd" /></td>
<td><s:property value="totalFee[#flag]"></s:property></td>
<s:if test="#flag==peop">
<td rowspan="<s:property value="gov"/>"><s:property
value="#request.govFeeSum" /></td>
</s:if>
<s:set name="flag" value="#flag+1" id="flag" />
</s:if>
</tr>
</s:iterator>
</s:subset>
<tr>
<td colspan="6">合计(元)</td>
<td colspan="2"><s:property
value="#request.govFeeSum+#request.peopFeeSum" /></td>
</tr>
</s:if>
</table>
</td>
</tr>
</table>
</s:form>
</body>
</html>
分享到:
相关推荐
滴南凸起存在“凹槽冶,东道海子北凹陷来源油气不能运移到克拉美丽气田石炭系储层聚集成藏,克拉美丽气田亿吨级油气应来自滴水泉凹陷;石东油气田深浅层油气特征基本一致,与石西油田不同,与克拉美丽石炭系油气相似,都...
Calltest.exe(CALL调试器 滴水版) 慧星小助手.exe(V4.1.4.0版) 指令字典.exe(2005XT版) 记事本.exe(非常不错的记时记事本,支持多标签) 函数查看.exe(叮咚茶制作,非常不错的函数查看工具) 计算器....
基于飞思卡尔智能车大赛的在线调试与开发的上位机软件
D. 有界函数与无穷小的和是无穷小.pdf
不容易下载的jar
包含: springside3-core-3.3.4.jar springside3-extension-3.3.4.jar springside-core-4.2.2.GA.jar
不容易找的jar
不容易找到的jar
pinyin4j-2.5.0.jar
傅里叶变换轮廓术的MATLAB实现。基于参考光栅和变形光栅得出折叠相位,进过相位展开,最后根据相位高度关系得出物体高度信息。
jar包,maven中已经无法找到。下面曾经的引用: <groupId>org.noo <artifactId>mybatis-paging <version>0.1 </dependency>
3个不容易找打jar: bcprov-jdk15-1.45.jar bcprov-jdk15-1.46.jar bcprov-jdk16-1.45.jar