Index: ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java =================================================================== diff -u -r17114 -r17768 --- ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java (.../SterilizationRecordTableManager.java) (revision 17114) +++ ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java (.../SterilizationRecordTableManager.java) (revision 17768) @@ -42,6 +42,7 @@ import com.forgon.tools.StrutsParamUtils; import com.forgon.tools.db.DatabaseUtil; import com.forgon.tools.hibernate.ObjectDao; +import com.forgon.tools.string.StringTools; import com.forgon.tools.util.ForgonDateUtils; /** @@ -150,12 +151,6 @@ Map> parameterMap) { Map sqlWhereParamMap = gridManager .getParamFromView(parameterMap); - /* - * String sterilizerNameSearch = sqlWhereParamMap - * .get("sterilizerNameSearch"); String dateSearch = - * sqlWhereParamMap.get("dateSearch"); String sterilizationUserSearch = - * sqlWhereParamMap .get("sterilizationUserSearch"); - */ String sql = "where 1=1 "; if (StringUtils.isNotBlank(sqlWhereParamMap.get("queryType"))) {// 当天灭菌记录也包括历史灭菌中记录 Date out_beginTime = new Date(); @@ -164,12 +159,19 @@ String needFinishConfirm = sqlWhereParamMap.get("needFinishConfirm"); String comfirmSql = ""; - if(StringUtils.isNotBlank(needFinishConfirm)){ -// comfirmSql = " or (po.isSituationComfirm = 0 or po.isSituationComfirm is null)"; - + if(StringUtils.isNotBlank(needFinishConfirm)){ //针对“完成灭菌后需要确认”的医院,则需要显示出已经完成灭菌但是还未确认的灭菌记录 comfirmSql = " or ((po.isSituationComfirm = 0 or po.isSituationComfirm is null) and po.status = '" + SterilizationRecord.STERILIZATION_STATUS_END + "')"; } + + String requestTimeQuantum = sqlWhereParamMap.get("requestTimeQuantum"); + if (StringTools.isNotBlank(requestTimeQuantum)) { + String[] timeArr = requestTimeQuantum.split(";"); + if (timeArr.length == 2) { + out_beginTime = ForgonDateUtils.safelyParseDate(timeArr[0]); + out_endTime = ForgonDateUtils.safelyParseDate(timeArr[1]); + } + } sql += " and ((po.startDate between " + dateQueryAdapter.dateAdapter(out_beginTime) + " and " + dateQueryAdapter.dateAdapter(out_endTime) @@ -179,15 +181,6 @@ + ")"; } - /* - * if (StringUtils.isNotBlank(sterilizerNameSearch)) { sql = sql + - * " and po.sterilizer.name = '" + sterilizerNameSearch + "'"; } if - * (StringUtils.isNotBlank(dateSearch)) { sql = sql + - * " and po.startDate between '" + dateSearch + " 00:00:00' and '" + - * dateSearch + " 23:59:59'"; } if - * (StringUtils.isNotBlank(sterilizationUserSearch)) { sql = sql + - * " and po.sterilizationUser = '" + sterilizationUserSearch + "'"; } - */ sql += " and po.orgUnitCoding = '" + AcegiHelper.getLoginUser() .getOrgUnitCodingFromSupplyRoomConfig() + "'"; Index: ssts-web/src/main/webapp/disinfectsystem/sterilizationmanager/sterilizationrecord/sterilizationRecordView.jsp =================================================================== diff -u -r16715 -r17768 --- ssts-web/src/main/webapp/disinfectsystem/sterilizationmanager/sterilizationrecord/sterilizationRecordView.jsp (.../sterilizationRecordView.jsp) (revision 16715) +++ ssts-web/src/main/webapp/disinfectsystem/sterilizationmanager/sterilizationrecord/sterilizationRecordView.jsp (.../sterilizationRecordView.jsp) (revision 17768) @@ -48,7 +48,8 @@ - + + @@ -113,6 +114,7 @@ +