From 321a74059773cfecc01d6313f7c2e2d45545d6d3 Mon Sep 17 00:00:00 2001
From: fei.wang <wf18701153496@163.com>
Date: 星期五, 18 四月 2025 17:46:31 +0800
Subject: [PATCH] 4.18v1.1.0
---
src/main/java/com/hxzkappboot/mapper/TbWarningMapper.java | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/hxzkappboot/mapper/TbWarningMapper.java b/src/main/java/com/hxzkappboot/mapper/TbWarningMapper.java
index d166e39..2b42e09 100644
--- a/src/main/java/com/hxzkappboot/mapper/TbWarningMapper.java
+++ b/src/main/java/com/hxzkappboot/mapper/TbWarningMapper.java
@@ -28,19 +28,19 @@
@Select("SELECT w.*,p.p_name as pName,p.p_x as pX,p.p_y as pY,p.p_floor as pFloor,p.baoliu2 as lat,p.baoliu3 as lng,p.baoliu4 as gao\n" +
"FROM tb_warning w\n" +
"INNER JOIN tb_person p ON w.objectid = p.p_tagid\n" +
- "WHERE status='鏈鐞�' and p.companyid = #{company} LIMIT #{current}, #{size}")
+ "WHERE status='鏈鐞�' and p.company = #{company} LIMIT #{current}, #{size}")
List<TbWarning> findwarper(@Param("company")String company,@Param("current") long current, @Param("size") long size);
@Select("SELECT w.*,p.*\n" +
"FROM tb_warning w\n" +
"INNER JOIN tb_person p ON w.objectid = p.p_tagid\n" +
- "WHERE status='鏈鐞�' and w.objectid = #{objectid} and p.companyid = #{company} LIMIT #{current}, #{size}")
+ "WHERE status='鏈鐞�' and w.objectid = #{objectid} and p.company = #{company} LIMIT #{current}, #{size}")
List<TbWarning> findwarper1(@Param("company")String company, @Param("objectid")String objectid,@Param("current") long current, @Param("size") long size);
@Select("SELECT w.*,p.p_name as pName,p.p_x as pX,p.p_y as pY,p.p_floor as pFloor,p.baoliu2 as lat,p.baoliu3 as lng,p.baoliu4 as gao\n" +
"FROM tb_warning w\n" +
"INNER JOIN tb_person p ON w.objectid = p.p_tagid\n" +
- "WHERE status='鏈鐞�' and p.companyid = #{company}")
+ "WHERE status='鏈鐞�' and p.company = #{company}")
List<TbWarning> findwarper2(@Param("company")String company);
--
Gitblit v1.9.3