| | |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoOnHour>> getOnHourReportsHistory(OnHourQO qo) { |
| | | String timeStart = qo.getTimeStart(); |
| | | String timeStop = qo.getTimeStop(); |
| | | if(timeStart != null) { |
| | | timeStart = timeStart + " 00:00:00"; |
| | | qo.setTimeStart(timeStart); |
| | | } |
| | | if(timeStop != null) { |
| | | timeStop = timeStop + " 23:59:59"; |
| | | qo.setTimeStop(timeStop); |
| | | } |
| | | qo.completionTime(); |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); |
| | | Long itemTotal = rmOnHourReportHistoryMapper.getOnHourReportsCount_history(params); |
| | |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoOnHour>> getOnHourReportsLast(OnHourQO qo) { |
| | | String timeStart = qo.getTimeStart(); |
| | | String timeStop = qo.getTimeStop(); |
| | | if(timeStart != null) { |
| | | timeStart = timeStart + " 00:00:00"; |
| | | qo.setTimeStart(timeStart); |
| | | } |
| | | if(timeStop != null) { |
| | | timeStop = timeStop + " 23:59:59"; |
| | | qo.setTimeStop(timeStop); |
| | | } |
| | | qo.completionTime(); |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); |
| | | Long itemTotal = rmOnHourReportLastMapper.getOnHourReportsCount_last(params); |
| | |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoOpenCloseValve>> getOpenCloseValveReports_history(OpenCloseValveQO qo) { |
| | | String timeStart_open = qo.getTimeStart_open(); |
| | | String timeStop_open = qo.getTimeStop_open(); |
| | | if(timeStart_open != null && timeStart_open != "") { |
| | | timeStart_open = timeStart_open + " 00:00:00"; |
| | | } else { |
| | | timeStart_open = LocalDateTime.now().minusDays(30) + " 00:00:00"; |
| | | } |
| | | qo.setTimeStart_open(timeStart_open); |
| | | |
| | | if(timeStop_open != null && timeStop_open != "") { |
| | | timeStop_open = timeStop_open + " 23:59:59"; |
| | | }else { |
| | | timeStop_open = LocalDate.now() + " 23:59:59"; |
| | | } |
| | | qo.setTimeStop_open(timeStop_open); |
| | | |
| | | String timeStart_close = qo.getTimeStart_close(); |
| | | String timeStop_close = qo.getTimeStop_close(); |
| | | if(timeStart_close != null && timeStart_close != "") { |
| | | timeStart_close = timeStart_close + " 00:00:00"; |
| | | } else { |
| | | timeStart_close = LocalDate.now().minusDays(30) + " 00:00:00"; |
| | | } |
| | | qo.setTimeStart_close(timeStart_close); |
| | | |
| | | if(timeStop_close != null && timeStop_close != "") { |
| | | timeStop_close = timeStop_close + " 23:59:59"; |
| | | }else { |
| | | timeStop_close = LocalDate.now() + " 23:59:59"; |
| | | } |
| | | qo.setTimeStop_close(timeStop_close); |
| | | qo.completionTimeNoEmpty() ; |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); |
| | | Long itemTotal = rmOpenCloseValveHistoryMapper.getOpenCloseValveReportsCount_history(params); |
| | |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoOpenCloseValve>> getOpenCloseValveReports_last(OpenCloseValveQO qo) { |
| | | String timeStart_open = qo.getTimeStart_open(); |
| | | String timeStop_open = qo.getTimeStop_open(); |
| | | if(timeStart_open != null) { |
| | | timeStart_open = timeStart_open + " 00:00:00"; |
| | | qo.setTimeStart_open(timeStart_open); |
| | | } |
| | | if(timeStop_open != null) { |
| | | timeStop_open = timeStop_open + " 23:59:59"; |
| | | qo.setTimeStop_open(timeStop_open); |
| | | } |
| | | |
| | | String timeStart_close = qo.getTimeStart_close(); |
| | | String timeStop_close = qo.getTimeStop_close(); |
| | | if(timeStart_close != null) { |
| | | timeStart_close = timeStart_close + " 00:00:00"; |
| | | qo.setTimeStart_close(timeStart_close); |
| | | } |
| | | if(timeStop_close != null) { |
| | | timeStop_close = timeStop_close + " 23:59:59"; |
| | | qo.setTimeStop_close(timeStop_close); |
| | | } |
| | | qo.completionTime() ; |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); |
| | | Long itemTotal = rmOpenCloseValveLastMapper.getOpenCloseValveReportsCount_last(params); |
| | |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoTiming>> getTimingReportsHistory(OnHourQO qo) { |
| | | String timeStart = qo.getTimeStart(); |
| | | String timeStop = qo.getTimeStop(); |
| | | if(timeStart != null) { |
| | | timeStart = timeStart + " 00:00:00"; |
| | | qo.setTimeStart(timeStart); |
| | | } |
| | | if(timeStop != null) { |
| | | timeStop = timeStop + " 23:59:59"; |
| | | qo.setTimeStop(timeStop); |
| | | } |
| | | qo.completionTime() ; |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); |
| | | Long itemTotal = rmTimingReportHistoryMapper.getTimingReportsCount_history(params); |
| | |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoTiming>> getTimingReportsLast(OnHourQO qo) { |
| | | String timeStart = qo.getTimeStart(); |
| | | String timeStop = qo.getTimeStop(); |
| | | if(timeStart != null) { |
| | | timeStart = timeStart + " 00:00:00"; |
| | | qo.setTimeStart(timeStart); |
| | | } |
| | | if(timeStop != null) { |
| | | timeStop = timeStop + " 23:59:59"; |
| | | qo.setTimeStop(timeStop); |
| | | } |
| | | qo.completionTime() ; |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); |
| | | Long itemTotal = rmTimingReportLastMapper.getTimingReportsCount_last(params); |
| | |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoWork>> getWorkReportsHistory(OnHourQO qo) { |
| | | String timeStart = qo.getTimeStart(); |
| | | String timeStop = qo.getTimeStop(); |
| | | if(timeStart != null) { |
| | | timeStart = timeStart + " 00:00:00"; |
| | | qo.setTimeStart(timeStart); |
| | | } |
| | | if(timeStop != null) { |
| | | timeStop = timeStop + " 23:59:59"; |
| | | qo.setTimeStop(timeStop); |
| | | } |
| | | qo.completionTime() ; |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); |
| | | Long itemTotal = rmWorkReportHistoryMapper.getWorkReportsCount_history(params); |
| | |
| | | * @return |
| | | */ |
| | | public QueryResultVo<List<VoWork>> getWorkReportsLast(OnHourQO qo) { |
| | | String timeStart = qo.getTimeStart(); |
| | | String timeStop = qo.getTimeStop(); |
| | | if(timeStart != null) { |
| | | timeStart = timeStart + " 00:00:00"; |
| | | qo.setTimeStart(timeStart); |
| | | } |
| | | if(timeStop != null) { |
| | | timeStop = timeStop + " 23:59:59"; |
| | | qo.setTimeStop(timeStop); |
| | | } |
| | | qo.completionTime() ; |
| | | |
| | | Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(qo); |
| | | Long itemTotal = rmWorkReportLastMapper.getWorkReportsCount_last(params); |