Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/dwr/table/RecyclingApplicationTableManager.java
===================================================================
diff -u -r14786 -r14812
--- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/dwr/table/RecyclingApplicationTableManager.java (.../RecyclingApplicationTableManager.java) (revision 14786)
+++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/dwr/table/RecyclingApplicationTableManager.java (.../RecyclingApplicationTableManager.java) (revision 14812)
@@ -233,11 +233,24 @@
}
}
- String showSubmitTime = sqlWhereParamMap.get("showSubmitTime");
- if (!StringUtils.isEmpty(showSubmitTime)){
- this.createSubmitTimeFilterSql(sqlBuilder,showSubmitTime);
- }
+ //根据开始时间和结束时间来查询
+ String startTime = sqlWhereParamMap.get("startTime");
+ String endTime = sqlWhereParamMap.get("endTime");
+ if (StringUtils.isNotEmpty(startTime) && StringUtils.isNotEmpty(endTime)){
+ this.createTimeFilterSql(sqlBuilder,startTime,endTime);
+ }
+ //过滤未完成或者已完成状态
+ String status = sqlWhereParamMap.get("status");
+ if (StringUtils.isNotEmpty(status)){
+ if ("unFinish".equals(status)){
+ this.createUnFinishFilterSql(sqlBuilder);
+ }
+ else if ("finish".equals(status)){
+ this.createFinishFilterSql(sqlBuilder);
+ }
+ }
+
String sql = sqlBuilder.toString();
return gridManager.renderGrid(parameterMap,
InvoicePlan.class.getSimpleName(), sql, new String[] {
@@ -247,10 +260,54 @@
}
/**
+ * 创建根据选择的时间条件过滤
+ * @param sqlBuilder 原来的sql
+ * @param startTime 开始时间
+ * @param endTime 结束时间
+ */
+ private void createTimeFilterSql(StringBuilder sqlBuilder,String startTime,String endTime){
+ String start = dateQueryAdapter.dateAdapter(DateUtils.truncate(new Date(Long.parseLong(startTime)), Calendar.DAY_OF_MONTH));
+ //因为要小于结束时间,所以加1天
+ Date dt = DateUtils.addDays(new Date(Long.parseLong(endTime)), 1);
+ String end = dateQueryAdapter.dateAdapter(DateUtils.truncate(dt, Calendar.DAY_OF_MONTH));
+ sqlBuilder.append(String.format(" AND (po.submitTime >= %s and po.submitTime < %s OR po.recyclingTime >= %s and po.recyclingTime < %s) ",start, end, start, end));
+ }
+
+
+
+ /**
+ * 创建已完成条件过滤
+ * @param sqlBuilder 原来的sql
+ */
+ private void createUnFinishFilterSql(StringBuilder sqlBuilder){
+ //回收状态:待回收,部分回收
+ String recyclingStatusSql = SqlBuilder.createStatus("recyclingStatus",InvoicePlan.RECYCLINGSTATUS_AWAITRECYCLE, InvoicePlan.RECYCLINGSTATUS_PARTRECYCLE);
+ //发货状态:待发货,部分发货
+ String deliverStatusSql = SqlBuilder.createStatus("deliverStatus",InvoicePlan.DELIVERSTATUS_AWAITDELIVER, InvoicePlan.DELIVERSTATUS_PARTDELIVERED);
+ sqlBuilder.append(String.format(" AND (%s and %s ) ",deliverStatusSql,recyclingStatusSql));
+ }
+
+
+ /**
+ * 创建未完成条件过滤
+ * @param sqlBuilder 原来的sql
+ */
+ private void createFinishFilterSql(StringBuilder sqlBuilder){
+ //回收状态:已回收
+ String recyclingStatusSql = SqlBuilder.createStatus("recyclingStatus",InvoicePlan.RECYCLINGSTATUS_RECYCLED);
+ //发货状态:已发货
+ String deliverStatusSql = SqlBuilder.createStatus("deliverStatus",InvoicePlan.DELIVERSTATUS_DELIVERED);
+ //终止状态:已终止
+ String endStatusSql = SqlBuilder.createStatus("endStatus",InvoicePlan.STATUS_END);
+ sqlBuilder.append(String.format(" AND (%s and %s or %s ) ",deliverStatusSql,recyclingStatusSql,endStatusSql));
+ }
+
+ /**
* 创建申请单申请时间过滤条件(近三天、近一周、近三个月”)
* @param sqlBuilder 原来的sql
* @param showSubmitTime 前端传过来的条件
*/
+ @Deprecated
private void createSubmitTimeFilterSql(StringBuilder sqlBuilder,String showSubmitTime){
Date now = new Date();
String today = dateQueryAdapter.dateAdapter(now);
Index: ssts-web/src/main/webapp/disinfectsystem/recyclingApplication/goodsApplicationView.jsp
===================================================================
diff -u -r14668 -r14812
--- ssts-web/src/main/webapp/disinfectsystem/recyclingApplication/goodsApplicationView.jsp (.../goodsApplicationView.jsp) (revision 14668)
+++ ssts-web/src/main/webapp/disinfectsystem/recyclingApplication/goodsApplicationView.jsp (.../goodsApplicationView.jsp) (revision 14812)
@@ -397,7 +397,9 @@
-
+
+
+