From 139f7015c2373a5bba03a7d66045cf40faa1728c Mon Sep 17 00:00:00 2001 From: whyclxw <810412026@qq.com> Date: 星期六, 08 二月 2025 11:16:02 +0800 Subject: [PATCH] 实时界面点击查看历史信息 --- src/main/java/com/whyc/util/SubTablePageInfoUtil.java | 29 +++++++++++++++++++++++++++++ 1 files changed, 29 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/whyc/util/SubTablePageInfoUtil.java b/src/main/java/com/whyc/util/SubTablePageInfoUtil.java index 7f09caf..f61b95b 100644 --- a/src/main/java/com/whyc/util/SubTablePageInfoUtil.java +++ b/src/main/java/com/whyc/util/SubTablePageInfoUtil.java @@ -300,4 +300,33 @@ } return resultTableList; } + //瀹炴椂鐣岄潰鐐瑰嚮鏌ョ湅鍘嗗彶淇℃伅 + public List getLockHisWithReal(Date startTime,Date endTime, + String dbName,String tablePrefix, + Object pojo) throws ParseException { + Map<String, List<Date>> queryTimeForSubTables = DateUtil.getQueryTimeForSubTablesDescWithOutDefault(startTime, endTime); + Set<String> tableYearKeySet = queryTimeForSubTables.keySet(); + List<Object> dataList = new LinkedList<>(); + for (String tableYear : tableYearKeySet) { + List<Date> queryTime = queryTimeForSubTables.get(tableYear); + + //鏁板�� + String tableName = tablePrefix+"_"+tableYear; + String existTableName = commonMapper.existTable(dbName, tableName); + if(existTableName == null){ + continue; + } + //====== 鏍规嵁涓嶅悓绫诲瀷绫诲瀷瀵硅薄瀵瑰簲璋冩暣 ====== + if(pojo instanceof LockHis) { + LockHis his = new LockHis(); + BeanUtils.copyProperties(pojo, his); + his.setStartTime(queryTime.get(0)); + his.setEndTime(queryTime.get(1)); + his.setRecordYear(tableName); + List<LockHis> list = service.getLockHisWithReal(his); + dataList.addAll(list); + } + } + return dataList; + } } \ No newline at end of file -- Gitblit v1.9.1