Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/foreigntousseapplication/service/ForeignTousseApplicationManagerImpl.java
===================================================================
diff -u -r33416 -r33423
--- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/foreigntousseapplication/service/ForeignTousseApplicationManagerImpl.java	(.../ForeignTousseApplicationManagerImpl.java)	(revision 33416)
+++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/foreigntousseapplication/service/ForeignTousseApplicationManagerImpl.java	(.../ForeignTousseApplicationManagerImpl.java)	(revision 33423)
@@ -2353,7 +2353,7 @@
 		String dateSql = dateQueryAdapter.dateAreaSql("po.applicationTime",
 				DateTools.getFormatDateStr(startDate, DateTools.COMMON_DATE_HMS),
 				DateTools.getFormatDateStr(endDate, DateTools.COMMON_DATE_HMS));
-		String hql = String.format("select po from %s po where po.recyclingStatus in ('%s','%s') and %s %s order by po.applicationTime ",
+		String hql = String.format("select po from %s po where po.recyclingStatus in ('%s','%s') and %s %s order by po.departCoding, po.applicationTime ",
 				ForeignTousseApplication.class.getSimpleName(),
 				ForeignTousseApplication.RECYCLINGSTATUS_AWAITRECEIVE,
 				ForeignTousseApplication.RECYCLINGSTATUS_PARTAWAITRECEIVE,