//
|
// Source code recreated from a .class file by IntelliJ IDEA
|
// (powered by FernFlower decompiler)
|
//
|
|
package com.hxzkoa.services;
|
|
import com.hxzkoa.json.tb_gps;
|
import com.hxzkoa.json.tb_rtkanchor;
|
import com.hxzkoa.json.tb_system;
|
import com.hxzkoa.util.Config;
|
import com.hxzkoa.util.ModifyConfig;
|
import java.io.BufferedReader;
|
import java.io.File;
|
import java.io.FileInputStream;
|
import java.io.FileNotFoundException;
|
import java.io.IOException;
|
import java.io.InputStreamReader;
|
import java.util.ArrayList;
|
import java.util.LinkedList;
|
import java.util.List;
|
import javax.persistence.EntityManager;
|
import javax.persistence.PersistenceContext;
|
import javax.persistence.Query;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
@Service
|
public class GpsService {
|
@PersistenceContext
|
private EntityManager em;
|
@Autowired
|
private CaozuoService cs;
|
|
public GpsService() {
|
}
|
|
public List<String> txt() {
|
List<String> list = new LinkedList();
|
String filePath = "D:\\baowen.txt";
|
File file = new File(filePath);
|
BufferedReader reader = null;
|
String tempString = null;
|
|
|
try {
|
FileInputStream intput = new FileInputStream(file);
|
reader = new BufferedReader(new InputStreamReader(intput));
|
|
while((tempString = reader.readLine()) != null) {
|
list.add(tempString);
|
}
|
} catch (FileNotFoundException var18) {
|
var18.printStackTrace();
|
} catch (IOException var19) {
|
var19.printStackTrace();
|
} finally {
|
if (reader != null) {
|
try {
|
reader.close();
|
} catch (IOException var17) {
|
var17.printStackTrace();
|
}
|
}
|
|
}
|
|
return list;
|
}
|
|
public List<tb_gps> getGpsManagement() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,gps_utc_time,gps_weidu,gps_NS,gsp_jingdu,gps_EW,gps_state,gps_num,gps_hdop,gps_haiba_gao,gps_tuoqiu,gps_chafen_time,gps_chafen_id,gps_jiaoyan,tagid,gps_kahao,gps_power,gps_sos,addtime,ccid FROM tb_gps";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_gps> tb_gpsList = new ArrayList();
|
if (resultList.size() > 0) {
|
for(int i = 0; i < resultList.size(); ++i) {
|
tb_gps gps = new tb_gps();
|
Object[] obj = (Object[])((Object[])resultList.get(i));
|
gps.setId((Integer)obj[0]);
|
gps.setGps_utc_time(obj[1] == null ? "" : obj[1].toString());
|
gps.setGps_weidu(obj[2] == null ? "" : obj[2].toString());
|
gps.setGps_NS(obj[3] == null ? "" : obj[3].toString());
|
gps.setGsp_jingdu(obj[4] == null ? "" : obj[4].toString());
|
gps.setGps_EW(obj[5] == null ? "" : obj[5].toString());
|
gps.setGps_state(obj[6] == null ? "" : obj[6].toString());
|
gps.setGps_num(obj[7] == null ? "" : obj[7].toString());
|
gps.setGps_hdop(obj[8] == null ? "" : obj[8].toString());
|
gps.setGps_haiba_gao(obj[9] == null ? "" : obj[9].toString());
|
gps.setGps_tuoqiu(obj[10] == null ? "" : obj[10].toString());
|
gps.setGps_chafen_time(obj[11] == null ? "" : obj[11].toString());
|
gps.setGps_chafen_id(obj[12] == null ? "" : obj[12].toString());
|
gps.setGps_jiaoyan(obj[13] == null ? "" : obj[13].toString());
|
gps.setTagid(obj[14] == null ? "" : obj[14].toString());
|
gps.setGps_kahao(obj[15] == null ? "" : obj[15].toString());
|
gps.setGps_power(obj[16] == null ? "" : obj[16].toString());
|
gps.setGps_sos(obj[17] == null ? "" : obj[17].toString());
|
gps.setAddtime(obj[18] == null ? "" : obj[18].toString());
|
gps.setCcid(obj[19] == null ? "" : obj[19].toString());
|
tb_gpsList.add(gps);
|
}
|
}
|
|
return tb_gpsList;
|
}
|
|
public List<tb_gps> getGpsManagement(int page) {
|
int perPage = Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage"));
|
int start = (page - 1) * perPage;
|
int end = 50;
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,gps_utc_time,gps_weidu,gps_NS,gsp_jingdu,gps_EW,gps_state,gps_num,gps_hdop,gps_haiba_gao,gps_tuoqiu,gps_chafen_time,gps_chafen_id,gps_jiaoyan,tagid,gps_kahao,gps_power,gps_sos,addtime,ccid FROM tb_gps order by addtime desc LIMIT :start,:end";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("start", start);
|
query.setParameter("end", Integer.valueOf(end));
|
List resultList = query.getResultList();
|
List<tb_gps> tb_gpsList = new ArrayList();
|
if (resultList.size() > 0) {
|
for(int i = 0; i < resultList.size(); ++i) {
|
tb_gps gps = new tb_gps();
|
Object[] obj = (Object[])((Object[])resultList.get(i));
|
gps.setId((Integer)obj[0]);
|
gps.setGps_utc_time(obj[1] != null && obj[1] != "" ? obj[1].toString() : "获取失败");
|
gps.setGps_weidu(obj[2] != null && obj[2] != "" ? obj[2].toString() : "获取失败");
|
gps.setGps_NS(obj[3] != null && obj[3] != "" ? obj[3].toString() : "获取失败");
|
gps.setGsp_jingdu(obj[4] != null && obj[4] != "" ? obj[4].toString() : "获取失败");
|
gps.setGps_EW(obj[5] != null && obj[5] != "" ? obj[5].toString() : "获取失败");
|
gps.setGps_state(obj[6] != null && obj[6] != "" ? obj[6].toString() : "获取失败");
|
gps.setGps_num(obj[7] != null && obj[7] != "" ? obj[7].toString() : "获取失败");
|
gps.setGps_hdop(obj[8] != null && obj[8] != "" ? obj[8].toString() : "获取失败");
|
gps.setGps_haiba_gao(obj[9] != null && obj[9] != "" ? obj[9].toString() : "获取失败");
|
gps.setGps_tuoqiu(obj[10] != null && obj[10] != "" ? obj[10].toString() : "获取失败");
|
gps.setGps_chafen_time(obj[11] != null && obj[11] != "" ? obj[11].toString() : "获取失败");
|
gps.setGps_chafen_id(obj[12] != null && obj[12] != "" ? obj[12].toString() : "获取失败");
|
gps.setGps_jiaoyan(obj[13] != null && obj[13] != "" ? obj[13].toString() : "获取失败");
|
gps.setTagid(obj[14] != null && obj[14] != "" ? obj[14].toString() : "获取失败");
|
gps.setGps_kahao(obj[15] != null && obj[15] != "" ? obj[15].toString() : "获取失败");
|
gps.setGps_power(obj[16] != null && obj[16] != "" ? obj[16].toString() : "获取失败");
|
gps.setGps_sos(obj[17] != null && obj[17] != "" ? obj[17].toString() : "获取失败");
|
gps.setAddtime(obj[18] != null && obj[18] != "" ? obj[18].toString() : "获取失败");
|
gps.setCcid(obj[19] != null && obj[19] != "" ? obj[19].toString() : "获取失败");
|
tb_gpsList.add(gps);
|
}
|
}
|
|
return tb_gpsList;
|
}
|
|
public int getGpsManagementCount() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT count(1) FROM tb_gps";
|
query = this.em.createNativeQuery(sql);
|
return Integer.parseInt(query.getSingleResult().toString());
|
}
|
|
public List<tb_gps> searchGpsManagement(String input) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT g.id,g.gps_utc_time,g.gps_weidu,g.gps_NS,g.gsp_jingdu,g.gps_EW,g.gps_state,g.gps_num,g.gps_hdop,g.gps_haiba_gao,g.gps_tuoqiu,g.gps_chafen_time,g.gps_chafen_id,g.gps_jiaoyan,g.tagid,g.gps_kahao,g.gps_power,g.gps_sos,g.addtime,g.ccid FROM tb_gps g,tb_person p WHERE p.p_tagid = g.tagid AND g.tagid = :tagid OR p.p_tagid = g.tagid AND p.p_name = :tagid";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("tagid", input);
|
List resultList = query.getResultList();
|
List<tb_gps> tb_gpsList = new ArrayList();
|
if (resultList.size() > 0) {
|
for(int i = 0; i < resultList.size(); ++i) {
|
tb_gps gps = new tb_gps();
|
Object[] obj = (Object[])((Object[])resultList.get(i));
|
gps.setId((Integer)obj[0]);
|
gps.setGps_utc_time(obj[1] == null ? "" : obj[1].toString());
|
gps.setGps_weidu(obj[2] == null ? "" : obj[2].toString());
|
gps.setGps_NS(obj[3] == null ? "" : obj[3].toString());
|
gps.setGsp_jingdu(obj[4] == null ? "" : obj[4].toString());
|
gps.setGps_EW(obj[5] == null ? "" : obj[5].toString());
|
gps.setGps_state(obj[6] == null ? "" : obj[6].toString());
|
gps.setGps_num(obj[7] == null ? "" : obj[7].toString());
|
gps.setGps_hdop(obj[8] == null ? "" : obj[8].toString());
|
gps.setGps_haiba_gao(obj[9] == null ? "" : obj[9].toString());
|
gps.setGps_tuoqiu(obj[10] == null ? "" : obj[10].toString());
|
gps.setGps_chafen_time(obj[11] == null ? "" : obj[11].toString());
|
gps.setGps_chafen_id(obj[12] == null ? "" : obj[12].toString());
|
gps.setGps_jiaoyan(obj[13] == null ? "" : obj[13].toString());
|
gps.setTagid(obj[14] == null ? "" : obj[14].toString());
|
gps.setGps_kahao(obj[15] == null ? "" : obj[15].toString());
|
gps.setGps_power(obj[16] == null ? "" : obj[16].toString());
|
gps.setGps_sos(obj[17] == null ? "" : obj[17].toString());
|
gps.setAddtime(obj[18] == null ? "" : obj[18].toString());
|
gps.setCcid(obj[19] == null ? "" : obj[19].toString());
|
tb_gpsList.add(gps);
|
}
|
}
|
|
return tb_gpsList;
|
}
|
|
public tb_gps gettagidgps(String input) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT gps_weidu,gsp_jingdu FROM tb_gps WHERE tagid = :tagid";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("tagid", input);
|
List resultlist = query.getResultList();
|
tb_gps gps = new tb_gps();
|
if (resultlist.size() != 0) {
|
Object[] obj = (Object[])((Object[])resultlist.get(0));
|
gps.setGps_weidu(obj[0] == null ? "" : obj[0].toString());
|
gps.setGsp_jingdu(obj[1] == null ? "" : obj[1].toString());
|
}
|
|
return gps;
|
}
|
|
@Transactional
|
public void gpszeng(tb_system system) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_system SET origin_jingdu=:origin_jingdu,origin_weidu=:origin_weidu,origin_jiaodu=:origin_jiaodu WHERE id=1";
|
this.cs.tb_caozuo("tb_system", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("origin_jingdu", system.getOrigin_jingdu());
|
query.setParameter("origin_weidu", system.getOrigin_weidu());
|
query.setParameter("origin_jiaodu", system.getOrigin_jiaodu());
|
query.executeUpdate();
|
}
|
|
@Transactional
|
public void gpsManagement_delete(String[] checkVal) {
|
String sql = null;
|
Query query = null;
|
|
for(int i = 0; i < checkVal.length; ++i) {
|
int tagid = Integer.parseInt(checkVal[i]);
|
sql = "DELETE FROM tb_gps WHERE tagid = :tagid";
|
this.cs.tb_caozuo("tb_gps", 2);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("tagid", tagid);
|
query.executeUpdate();
|
}
|
|
}
|
|
@Transactional
|
public int gpsManagement_deletea(String[] checkVal) {
|
String sql = null;
|
Query query = null;
|
int aaa = checkVal.length;
|
|
for(int i = 0; i < checkVal.length; ++i) {
|
int tagid = Integer.parseInt(checkVal[i]);
|
sql = "DELETE FROM tb_gps WHERE tagid = :tagid";
|
this.cs.tb_caozuo("tb_gps", 2);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("tagid", tagid);
|
query.executeUpdate();
|
}
|
|
return aaa;
|
}
|
|
public List<tb_gps> getTrack(String date, int page, int perPage) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT * FROM tb_gps_track_" + date + " LIMIT :start,:end";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("start", (page - 1) * perPage);
|
query.setParameter("end", 50);
|
List resultList = query.getResultList();
|
List<tb_gps> tb_trackList = new ArrayList();
|
if (resultList.size() > 0) {
|
for(int i = 0; i < resultList.size(); ++i) {
|
tb_gps gps = new tb_gps();
|
Object[] obj = (Object[])((Object[])resultList.get(i));
|
gps.setId((Integer)obj[0]);
|
gps.setGps_utc_time(obj[1] == null ? "" : obj[1].toString());
|
gps.setGps_weidu(obj[2] == null ? "" : obj[2].toString());
|
gps.setGps_NS(obj[3] == null ? "" : obj[3].toString());
|
gps.setGsp_jingdu(obj[4] == null ? "" : obj[4].toString());
|
gps.setGps_EW(obj[5] == null ? "" : obj[5].toString());
|
gps.setGps_state(obj[6] == null ? "" : obj[6].toString());
|
gps.setGps_num(obj[7] == null ? "" : obj[7].toString());
|
gps.setGps_hdop(obj[8] == null ? "" : obj[8].toString());
|
gps.setGps_haiba_gao(obj[9] == null ? "" : obj[9].toString());
|
gps.setGps_tuoqiu(obj[10] == null ? "" : obj[10].toString());
|
gps.setGps_chafen_time(obj[11] == null ? "" : obj[11].toString());
|
gps.setGps_chafen_id(obj[12] == null ? "" : obj[12].toString());
|
gps.setGps_jiaoyan(obj[13] == null ? "" : obj[13].toString());
|
gps.setTagid(obj[14] == null ? "" : obj[14].toString());
|
gps.setGps_kahao(obj[15] == null ? "" : obj[15].toString());
|
gps.setGps_power(obj[16] == null ? "" : obj[16].toString());
|
gps.setGps_sos(obj[17] == null ? "" : obj[17].toString());
|
gps.setAddtime(obj[18] == null ? "" : obj[18].toString());
|
tb_trackList.add(gps);
|
}
|
}
|
|
return tb_trackList;
|
}
|
|
public List<tb_gps> getTracka(String date) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT * FROM tb_gps_track_" + date + "";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_gps> tb_trackList = new ArrayList();
|
if (resultList.size() > 0) {
|
for(int i = 0; i < resultList.size(); ++i) {
|
tb_gps gps = new tb_gps();
|
Object[] obj = (Object[])((Object[])resultList.get(i));
|
gps.setId((Integer)obj[0]);
|
gps.setGps_utc_time(obj[1] == null ? "" : obj[1].toString());
|
gps.setGps_weidu(obj[2] == null ? "" : obj[2].toString());
|
gps.setGps_NS(obj[3] == null ? "" : obj[3].toString());
|
gps.setGsp_jingdu(obj[4] == null ? "" : obj[4].toString());
|
gps.setGps_EW(obj[5] == null ? "" : obj[5].toString());
|
gps.setGps_state(obj[6] == null ? "" : obj[6].toString());
|
gps.setGps_num(obj[7] == null ? "" : obj[7].toString());
|
gps.setGps_hdop(obj[8] == null ? "" : obj[8].toString());
|
gps.setGps_haiba_gao(obj[9] == null ? "" : obj[9].toString());
|
gps.setGps_tuoqiu(obj[10] == null ? "" : obj[10].toString());
|
gps.setGps_chafen_time(obj[11] == null ? "" : obj[11].toString());
|
gps.setGps_chafen_id(obj[12] == null ? "" : obj[12].toString());
|
gps.setGps_jiaoyan(obj[13] == null ? "" : obj[13].toString());
|
gps.setTagid(obj[14] == null ? "" : obj[14].toString());
|
gps.setGps_kahao(obj[15] == null ? "" : obj[15].toString());
|
gps.setGps_power(obj[16] == null ? "" : obj[16].toString());
|
gps.setGps_sos(obj[17] == null ? "" : obj[17].toString());
|
gps.setAddtime(obj[18] == null ? "" : obj[18].toString());
|
tb_trackList.add(gps);
|
}
|
}
|
|
return tb_trackList;
|
}
|
|
public int getgpsRealTimeLocationCount(String date) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT count(1) FROM tb_gps_track_" + date + "";
|
query = this.em.createNativeQuery(sql);
|
return Integer.parseInt(query.getSingleResult().toString());
|
}
|
|
public int getgpsRealTimeLocationCount2(String date, String input) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT count(1) FROM tb_gps_track_" + date + " where tagid = :tagid";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("tagid", input);
|
return Integer.parseInt(query.getSingleResult().toString());
|
}
|
|
public List<String> getgpsTrackDateList() {
|
String sql = null;
|
Query query = null;
|
sql = "select right(table_name,8) from information_schema.tables where table_schema='hxzkuwb' and table_name like 'tb_gps_track_%'";
|
query = this.em.createNativeQuery(sql);
|
List<String> resultList = query.getResultList();
|
return resultList;
|
}
|
|
@Transactional
|
public void realTimegpsLocation_delete(String[] checkVal, String date) {
|
String sql = null;
|
Query query = null;
|
|
for(int i = 0; i < checkVal.length; ++i) {
|
int id = Integer.parseInt(checkVal[i]);
|
sql = "DELETE FROM tb_gps_track_" + date + " WHERE id = :id";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("id", id);
|
query.executeUpdate();
|
}
|
|
}
|
|
@Transactional
|
public int realTimegpsLocation_deletea(String[] checkVal, String date) {
|
String sql = null;
|
Query query = null;
|
int aaa = checkVal.length;
|
|
for(int i = 0; i < checkVal.length; ++i) {
|
int id = Integer.parseInt(checkVal[i]);
|
sql = "DELETE FROM tb_gps_track_" + date + " WHERE id = :id";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("id", id);
|
query.executeUpdate();
|
}
|
|
return aaa;
|
}
|
|
@Transactional
|
public void realTimegpsLocation_deleteAll(String date) {
|
String sql = null;
|
Query query = null;
|
sql = "DELETE FROM tb_gps_track_" + date + "";
|
query = this.em.createNativeQuery(sql);
|
query.executeUpdate();
|
}
|
|
@Transactional
|
public int realTimegpsLocation_deleteAlla(String date) {
|
String sql = null;
|
Query query = null;
|
sql = "DELETE FROM tb_gps_track_" + date + "";
|
query = this.em.createNativeQuery(sql);
|
int aaa = query.executeUpdate();
|
return aaa;
|
}
|
|
public List<tb_gps> searchRealTimegpsLocation(String input, String date, int page) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT * FROM tb_gps_track_" + date + " WHERE tagid = :p_tagid ORDER BY id DESC LIMIT 0,100";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("p_tagid", input);
|
List resultList = query.getResultList();
|
List<tb_gps> tb_trackList = new ArrayList();
|
if (resultList.size() > 0) {
|
for(int i = 0; i < resultList.size(); ++i) {
|
tb_gps gps = new tb_gps();
|
Object[] obj = (Object[])((Object[])resultList.get(i));
|
gps.setId((Integer)obj[0]);
|
gps.setGps_utc_time(obj[1] == null ? "" : obj[1].toString());
|
gps.setGps_weidu(obj[2] == null ? "" : obj[2].toString());
|
gps.setGps_NS(obj[3] == null ? "" : obj[3].toString());
|
gps.setGsp_jingdu(obj[4] == null ? "" : obj[4].toString());
|
gps.setGps_EW(obj[5] == null ? "" : obj[5].toString());
|
gps.setGps_state(obj[6] == null ? "" : obj[6].toString());
|
gps.setGps_num(obj[7] == null ? "" : obj[7].toString());
|
gps.setGps_hdop(obj[8] == null ? "" : obj[8].toString());
|
gps.setGps_haiba_gao(obj[9] == null ? "" : obj[9].toString());
|
gps.setGps_tuoqiu(obj[10] == null ? "" : obj[10].toString());
|
gps.setGps_chafen_time(obj[11] == null ? "" : obj[11].toString());
|
gps.setGps_chafen_id(obj[12] == null ? "" : obj[12].toString());
|
gps.setGps_jiaoyan(obj[13] == null ? "" : obj[13].toString());
|
gps.setTagid(obj[14] == null ? "" : obj[14].toString());
|
gps.setGps_kahao(obj[15] == null ? "" : obj[15].toString());
|
gps.setGps_power(obj[16] == null ? "" : obj[16].toString());
|
gps.setGps_sos(obj[17] == null ? "" : obj[17].toString());
|
gps.setAddtime(obj[18] == null ? "" : obj[18].toString());
|
tb_trackList.add(gps);
|
}
|
}
|
|
return tb_trackList;
|
}
|
|
public List<tb_gps> getRealTimegpsLocation(String tagid, String begin, String end, String date) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,gps_weidu,gsp_jingdu,gps_state,gps_num,gps_haiba_gao,gps_chafen_id,tagid,gps_hdop,gps_chafen_time,gps_power,addtime FROM tb_gps_track_" + date + " WHERE tagid = '" + tagid + "' AND addtime>= '" + begin + "' AND addtime<= '" + end + "' ORDER BY addtime";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_gps> tb_realocationList = new ArrayList();
|
if (resultList.size() > 0) {
|
for(int i = 0; i < resultList.size(); ++i) {
|
tb_gps realocation = new tb_gps();
|
Object[] obj = (Object[])((Object[])resultList.get(i));
|
realocation.setId((Integer)obj[0]);
|
realocation.setGps_weidu(obj[1] == null ? "" : obj[1].toString());
|
realocation.setGsp_jingdu(obj[2] == null ? "" : obj[2].toString());
|
realocation.setGps_state(obj[3] == null ? "" : obj[3].toString());
|
realocation.setGps_num(obj[4] == null ? "" : obj[4].toString());
|
realocation.setGps_haiba_gao(obj[5] == null ? "" : obj[5].toString());
|
realocation.setGps_chafen_id(obj[6] == null ? "" : obj[6].toString());
|
realocation.setTagid(obj[7] == null ? "" : obj[7].toString());
|
realocation.setGps_hdop(obj[8] == null ? "" : obj[8].toString());
|
realocation.setGps_chafen_time(obj[9] == null ? "" : obj[9].toString());
|
realocation.setGps_power(obj[10] == null ? "" : obj[10].toString());
|
realocation.setAddtime(obj[11] == null ? "" : obj[11].toString());
|
tb_realocationList.add(realocation);
|
}
|
}
|
|
return tb_realocationList;
|
}
|
|
public String getpersontagid(String tagid) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT p_online FROM tb_person WHERE p_tagid ='" + tagid + "'";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
String zhuantai = resultList.get(0).toString();
|
return zhuantai;
|
}
|
|
public List getBuJu() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT anchorid,tagid,AQBJ_SCZ FROM tb_buju";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
return resultList;
|
}
|
|
public List<tb_rtkanchor> findrtkanchor(int page) {
|
String sql = null;
|
Query query = null;
|
sql = "select id,acid,state,jingdu,weidu,gaodu,posx,posy,floor,distance,port,baoliu1,baoliu2,addtime from tb_rtkanchor ORDER BY addtime DESC LIMIT :start,:end";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
|
query.setParameter("end", Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
|
List resultlist = query.getResultList();
|
List<tb_rtkanchor> permissions = new ArrayList();
|
if (resultlist.size() > 0) {
|
for(int i = 0; i < resultlist.size(); ++i) {
|
Object[] obj = (Object[])((Object[])resultlist.get(i));
|
tb_rtkanchor per = new tb_rtkanchor();
|
per.setId((Integer)obj[0]);
|
per.setAcid(obj[1] == null ? null : obj[1].toString());
|
per.setState(obj[2] == null ? null : obj[2].toString());
|
per.setJingdu(obj[3] == null ? null : obj[3].toString());
|
per.setWeidu(obj[4] == null ? null : obj[4].toString());
|
per.setGaodu(obj[5] == null ? null : obj[5].toString());
|
per.setPosx(obj[6] == null ? null : obj[6].toString());
|
per.setPosy(obj[7] == null ? null : obj[7].toString());
|
per.setFloor(obj[8] == null ? null : obj[8].toString());
|
per.setDistance(obj[9] == null ? null : obj[9].toString());
|
per.setPort(obj[10] == null ? null : obj[10].toString());
|
per.setBaoliu1(obj[11] == null ? null : obj[11].toString());
|
per.setBaoliu2(obj[12] == null ? null : obj[12].toString());
|
per.setAddtime(obj[13] == null ? null : obj[13].toString());
|
permissions.add(per);
|
}
|
}
|
|
return permissions;
|
}
|
|
public List<tb_rtkanchor> findrtkanchor3(String input) {
|
String sql = null;
|
Query query = null;
|
sql = "select id,acid,state,jingdu,weidu,gaodu,posx,posy,floor,distance,port,baoliu1,baoliu2,addtime from tb_rtkanchor WHERE acid = :acid ORDER BY addtime DESC";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("acid", input);
|
List resultlist = query.getResultList();
|
List<tb_rtkanchor> permissions = new ArrayList();
|
if (resultlist.size() > 0) {
|
for(int i = 0; i < resultlist.size(); ++i) {
|
Object[] obj = (Object[])((Object[])resultlist.get(i));
|
tb_rtkanchor per = new tb_rtkanchor();
|
per.setId((Integer)obj[0]);
|
per.setAcid(obj[1] == null ? null : obj[1].toString());
|
per.setState(obj[2] == null ? null : obj[2].toString());
|
per.setJingdu(obj[3] == null ? null : obj[3].toString());
|
per.setWeidu(obj[4] == null ? null : obj[4].toString());
|
per.setGaodu(obj[5] == null ? null : obj[5].toString());
|
per.setPosx(obj[6] == null ? null : obj[6].toString());
|
per.setPosy(obj[7] == null ? null : obj[7].toString());
|
per.setFloor(obj[8] == null ? null : obj[8].toString());
|
per.setDistance(obj[9] == null ? null : obj[9].toString());
|
per.setPort(obj[10] == null ? null : obj[10].toString());
|
per.setBaoliu1(obj[11] == null ? null : obj[11].toString());
|
per.setBaoliu2(obj[12] == null ? null : obj[12].toString());
|
per.setAddtime(obj[13] == null ? null : obj[13].toString());
|
permissions.add(per);
|
}
|
}
|
|
return permissions;
|
}
|
|
public int getrtkanchorManagementCount() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT count(1) FROM tb_rtkanchor";
|
query = this.em.createNativeQuery(sql);
|
return Integer.parseInt(query.getSingleResult().toString());
|
}
|
|
@Transactional
|
public void rtkanchor_delete(String[] checkVal) {
|
String sql = null;
|
Query query = null;
|
|
for(int i = 0; i < checkVal.length; ++i) {
|
int id = Integer.parseInt(checkVal[i]);
|
sql = "DELETE FROM tb_rtkanchor WHERE id = :id";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("id", id);
|
query.executeUpdate();
|
}
|
|
}
|
|
@Transactional
|
public void rtkanchor_deletea() {
|
String sql = null;
|
Query query = null;
|
sql = "DELETE FROM tb_rtkanchor";
|
query = this.em.createNativeQuery(sql);
|
query.executeUpdate();
|
}
|
}
|
