Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/ReAppTableSqlHandler.java
===================================================================
diff -u -r28358 -r28362
--- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/ReAppTableSqlHandler.java	(.../ReAppTableSqlHandler.java)	(revision 28358)
+++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/ReAppTableSqlHandler.java	(.../ReAppTableSqlHandler.java)	(revision 28362)
@@ -272,7 +272,7 @@
             String end;
             start = dateQueryAdapter.dateAdapter(new java.sql.Date(Long.parseLong(startTime)));
             end = dateQueryAdapter.dateAdapter(new java.sql.Date(Long.parseLong(endTime)));
-            sqlBuilder.append(String.format(" AND (po.submitTime >= %s and po.submitTime < %s OR po.recyclingTime >= %s and po.recyclingTime < %s) ", start, end, start, end));
+            sqlBuilder.append(String.format(" AND (po.applicationTime >= %s and po.applicationTime < %s) ", start, end));
         }
     }