From 6bce1b35246ed695a4272c24254c7073a524818a Mon Sep 17 00:00:00 2001
From: zhangnaisong <2434969829@qq.com>
Date: 星期二, 30 七月 2024 13:33:12 +0800
Subject: [PATCH] 电磁锁查询加入状态修改提交
---
ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml b/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml
index c8af3b5..768041d 100644
--- a/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml
+++ b/ard-work/src/main/resources/mapper/sy/ArdTankLockMapper.xml
@@ -174,7 +174,7 @@
when '寮�閿佺姸鎬�' then true
else false
end as lock_state_mark,
- rank() over(partition by atls.lock_num order by atls.upload_time desc,atl.lock_num) rn
+ rank() over(partition by atl.lock_num order by atls.upload_time desc,atl.lock_num) rn
from ard_tank_lock atl
left join ard_tank_lock_state atls on atl."id" = atls.lock_id
where car_id = #{carId} order by atls.upload_time desc,atl.lock_num)t where t.rn = 1
--
Gitblit v1.9.3