From 9b8bb10acf41929d9fa2750fa069302ad317c8cf Mon Sep 17 00:00:00 2001
From: zhangnaisong <2434969829@qq.com>
Date: 星期六, 06 七月 2024 14:40:26 +0800
Subject: [PATCH] 电磁锁车辆查询修改提交
---
ard-work/src/main/java/com/ruoyi/sy/controller/ArdTankLockController.java | 6 +++---
ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLockMapper.java | 2 ++
ard-work/src/main/java/com/ruoyi/sy/service/IArdTankLockService.java | 2 +-
ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml | 4 ++++
ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankLockServiceImpl.java | 16 ++++++++++------
5 files changed, 20 insertions(+), 10 deletions(-)
diff --git a/ard-work/src/main/java/com/ruoyi/sy/controller/ArdTankLockController.java b/ard-work/src/main/java/com/ruoyi/sy/controller/ArdTankLockController.java
index 25a4e20..d26c725 100644
--- a/ard-work/src/main/java/com/ruoyi/sy/controller/ArdTankLockController.java
+++ b/ard-work/src/main/java/com/ruoyi/sy/controller/ArdTankLockController.java
@@ -158,11 +158,11 @@
PageHelper.startPage((Integer) para.get("pageNum"), (Integer) para.get("pageSize"));
String userId = SecurityUtils.getUserId();
- List<Map<String,Object>> result = ardTankLockService.getAll(userId);
+ Map<String,Object> result = ardTankLockService.getAll(userId);
TableDataInfo dataTable = new TableDataInfo();
- dataTable.setRows(result);
- dataTable.setTotal(result.size());
+ dataTable.setRows((List<Map<String,Object>>) result.get("list"));
+ dataTable.setTotal((Long) result.get("total"));
dataTable.setCode(200);
dataTable.setMsg("鏌ヨ鎴愬姛");
return dataTable;
diff --git a/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLockMapper.java b/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLockMapper.java
index ade8035..4c89d68 100644
--- a/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLockMapper.java
+++ b/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLockMapper.java
@@ -71,4 +71,6 @@
public int deleteLockByCarId(String carId);
public int deleteArdTankLockByIdSet(@Param("idSet") Set<String> idSet);
+
+ public Long selectArdTankLockTotal();
}
diff --git a/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankLockService.java b/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankLockService.java
index 5a32b74..d081f3d 100644
--- a/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankLockService.java
+++ b/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankLockService.java
@@ -63,7 +63,7 @@
public int deleteArdTankLockById(String id);
//public Results getAll(String usersId);
- public List<Map<String,Object>> getAll(String usersId);
+ public Map<String,Object> getAll(String usersId);
public Map<String, Object> getLockByCarId(String carId,String usersId);
diff --git a/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankLockServiceImpl.java b/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankLockServiceImpl.java
index 8b84e12..c708f40 100644
--- a/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankLockServiceImpl.java
+++ b/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankLockServiceImpl.java
@@ -138,22 +138,23 @@
@Override
//public Results List<Map<String,Object>> getAll(String usersId) {
- public List<Map<String,Object>> getAll(String usersId) {
+ public Map<String,Object> getAll(String usersId) {
+ List<ArdTankLock> ardTankLockList = ardTankLockMapper.getAll();
ArdSyUser ardSyUser = ardSyUserMapper.userById(usersId);
if(ardSyUser == null){
- return new ArrayList();
+ return new HashMap();
}
List<SysConfig> syURLResult = sysConfigMapper.selectByType("syCarPT");
String syURL = "";
if(syURLResult.size() != 0){
syURL = syURLResult.get(0).getConfigValue();
}else{
- return new ArrayList();
+ return new HashMap();
}
String passwordMd5 = DigestUtils.md5Hex(ardSyUser.getPassword());
Map<String, Object> LogInResult = sYClient.logIn(syURL, passwordMd5, ardSyUser.getUserId());
String sessionId = (String) LogInResult.get("sessionId");
- List<ArdTankLock> ardTankLockList = ardTankLockMapper.getAll();
+ //List<ArdTankLock> ardTankLockList = ardTankLockMapper.getAll();
List<Map<String,Object>> result = new ArrayList();
for(ArdTankLock ardTankLock : ardTankLockList){
Map<String,Object> map = new HashMap();
@@ -200,8 +201,11 @@
}
}
}
- //return Results.succeed(result0);
- return result0;
+ Long total = ardTankLockMapper.selectArdTankLockTotal();
+ Map<String,Object> resultMap = new HashMap();
+ resultMap.put("list",result0);
+ resultMap.put("total",total);
+ return resultMap;
}
@Override
diff --git a/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml b/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml
index c8e672e..1286241 100644
--- a/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml
+++ b/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml
@@ -122,4 +122,8 @@
#{id}
</foreach>
</delete>
+
+ <select id="selectArdTankLockTotal" resultType="java.lang.Long">
+ select count(distinct atl.car_id) from ard_tank_lock atl
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3