From 52cffc4ab8e9787a6f233295502c7c9788dddae1 Mon Sep 17 00:00:00 2001
From: fxl <473369119@qq.com>
Date: 星期二, 07 三月 2023 10:45:17 +0800
Subject: [PATCH] 3.7
---
src/main/java/com/hxzkoa/services/LocationService.java | 16 +++++++++++++++-
1 files changed, 15 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/hxzkoa/services/LocationService.java b/src/main/java/com/hxzkoa/services/LocationService.java
index 02d5fea..39f913e 100644
--- a/src/main/java/com/hxzkoa/services/LocationService.java
+++ b/src/main/java/com/hxzkoa/services/LocationService.java
@@ -88,7 +88,7 @@
public List<tb_realocation> searchRealTimeLocation(String input,String date) {
String sql = null;
Query query = null;
- sql = "SELECT id,tagid,x,y,z,layer,time,baoliu1,baoliu2,baoliu3,baoliu4 FROM tb_track_" +date+ " WHERE tagid = :p_tagid";
+ sql = "SELECT t.id,t.tagid,t.x,t.y,t.z,t.layer,t.time,t.baoliu1,t.baoliu2,t.baoliu3,t.baoliu4 FROM tb_track_" +date+ " t,tb_person p WHERE t.tagid = p.p_tagid AND p.p_name = :p_tagid OR t.tagid = p.p_tagid AND t.tagid = :p_tagid";
query = this.em.createNativeQuery(sql);
query.setParameter("p_tagid", input);
List resultList = query.getResultList();
@@ -263,4 +263,18 @@
query.setParameter("tag_id", tag.getTag_id());
query.executeUpdate();
}
+
+ public List<String> panduanweiyi(String name){
+ String sql = null;
+ Query query = null;
+ sql = "select p_tagid from tb_person where p_name = :name";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("name", name);
+ List resultlist = query.getResultList();
+ List<String> strs = new ArrayList<>();
+ for (int i=0; i<resultlist.size(); i++) {
+ strs.add(resultlist.get(i).toString());
+ }
+ return strs;
+ }
}
--
Gitblit v1.10.0