package com.hxzkoa.services;
|
|
import java.util.ArrayList;
|
import java.util.Collections;
|
import java.util.Comparator;
|
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;
|
|
import com.hxzkoa.json.tb_achor;
|
import com.hxzkoa.json.tb_anchor_nearby;
|
import com.hxzkoa.json.tb_anchorhistory;
|
import com.hxzkoa.json.tb_shebei;
|
import com.hxzkoa.json.tb_tongbuanchor;
|
import com.hxzkoa.json.tb_wifi;
|
import com.hxzkoa.util.Config;
|
import com.hxzkoa.util.ModifyConfig;
|
|
@Service
|
public class AnchorService {
|
@PersistenceContext
|
private EntityManager em;
|
@Autowired
|
private CaozuoService cs;
|
|
public List<tb_achor> getAnchorManagementsi() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM tb_achor ORDER BY id DESC LIMIT 4";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_achor> tb_achorList = new ArrayList<tb_achor>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_achor achor = new tb_achor();
|
Object[] obj = (Object[]) resultList.get(i);
|
achor.setId((int) obj[0]);
|
achor.setAnchormode(obj[8] == null ? "" : obj[8].toString());
|
achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
|
achor.setPOSX(obj[2] == null ? "" : obj[2].toString());
|
achor.setPOSY(obj[3] == null ? "" : obj[3].toString());
|
achor.setPOSZ(obj[4] == null ? "" : obj[4].toString());
|
achor.setLayer(obj[5] == null ? "" : obj[5].toString());
|
achor.setZu(obj[6] == null ? "" : obj[6].toString());
|
achor.setLiangcheng(obj[7] == null ? "" : obj[7].toString());
|
achor.setAnchorip(obj[9] == null ? "" : obj[9].toString());
|
achor.setVersion(obj[10] == null ? "" : obj[10].toString());
|
achor.setGreateTime(obj[13] == null ? "" : obj[13].toString());
|
tb_achorList.add(achor);
|
}
|
}
|
return tb_achorList;
|
}
|
|
public List<tb_achor> getAnchorManagement() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM tb_achor ORDER BY id DESC";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_achor> tb_achorList = new ArrayList<tb_achor>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_achor achor = new tb_achor();
|
Object[] obj = (Object[]) resultList.get(i);
|
achor.setId((int) obj[0]);
|
achor.setAnchormode(obj[8] == null ? "" : obj[8].toString());
|
achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
|
achor.setPOSX(obj[2] == null ? "" : obj[2].toString());
|
achor.setPOSY(obj[3] == null ? "" : obj[3].toString());
|
achor.setPOSZ(obj[4] == null ? "" : obj[4].toString());
|
achor.setLayer(obj[5] == null ? "" : obj[5].toString());
|
achor.setZu(obj[6] == null ? "" : obj[6].toString());
|
achor.setLiangcheng(obj[7] == null ? "" : obj[7].toString());
|
achor.setAnchorip(obj[9] == null ? "" : obj[9].toString());
|
achor.setVersion(obj[10] == null ? "" : obj[10].toString());
|
achor.setGreateTime(obj[13] == null ? "" : obj[13].toString());
|
tb_achorList.add(achor);
|
}
|
}
|
return tb_achorList;
|
}
|
|
public List<tb_achor> getAnchorManagement(int page) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM (SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM tb_achor ORDER BY id DESC) s LIMIT :start,:end";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
|
query.setParameter("end", 50);
|
List resultList = query.getResultList();
|
List<tb_achor> tb_achorList = new ArrayList<tb_achor>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_achor achor = new tb_achor();
|
Object[] obj = (Object[]) resultList.get(i);
|
achor.setId((int) obj[0]);
|
achor.setAnchormode(obj[8] == null ? "" : obj[8].toString());
|
achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
|
achor.setPOSX(obj[2] == null ? "" : obj[2].toString());
|
achor.setPOSY(obj[3] == null ? "" : obj[3].toString());
|
achor.setPOSZ(obj[4] == null ? "" : obj[4].toString());
|
achor.setLayer(obj[5] == null ? "" : obj[5].toString());
|
achor.setZu(obj[6] == null ? "" : obj[6].toString());
|
achor.setLiangcheng(obj[7] == null ? "" : obj[7].toString());
|
achor.setAnchorip(obj[9] == null ? "" : obj[9].toString());
|
achor.setVersion(obj[10] == null ? "" : obj[10].toString());
|
achor.setGreateTime(obj[13] == null ? "" : obj[13].toString());
|
tb_achorList.add(achor);
|
}
|
}
|
return tb_achorList;
|
}
|
|
public List<tb_achor> getAnchorManagementa() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime,baoliu6,baoliu7 FROM (SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime,baoliu6,baoliu7 FROM tb_achor ORDER BY id DESC) s";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_achor> tb_achorList = new ArrayList<tb_achor>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_achor achor = new tb_achor();
|
Object[] obj = (Object[]) resultList.get(i);
|
achor.setId((int) obj[0]);
|
achor.setAnchormode(obj[8] == null ? "" : obj[8].toString());
|
achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
|
achor.setPOSX(obj[2] == null ? "" : obj[2].toString());
|
achor.setPOSY(obj[3] == null ? "" : obj[3].toString());
|
achor.setPOSZ(obj[4] == null ? "" : obj[4].toString());
|
achor.setLayer(obj[5] == null ? "" : obj[5].toString());
|
achor.setZu(obj[6] == null ? "" : obj[6].toString());
|
achor.setLiangcheng(obj[7] == null ? "" : obj[7].toString());
|
achor.setAnchorip(obj[9] == null ? "" : obj[9].toString());
|
achor.setVersion(obj[10] == null ? "" : obj[10].toString());
|
achor.setGreateTime(obj[13] == null ? "" : obj[13].toString());
|
tb_achorList.add(achor);
|
}
|
}
|
return tb_achorList;
|
}
|
|
public List<tb_achor> searchAnchorManagement(String input) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM tb_achor WHERE anchorid = :anchorid";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", input);
|
List resultList = query.getResultList();
|
List<tb_achor> tb_achorList = new ArrayList<tb_achor>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_achor achor = new tb_achor();
|
Object[] obj = (Object[]) resultList.get(i);
|
achor.setId((int) obj[0]);
|
achor.setAnchormode(obj[8] == null ? "" : obj[8].toString());
|
achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
|
achor.setPOSX(obj[2] == null ? "" : obj[2].toString());
|
achor.setPOSY(obj[3] == null ? "" : obj[3].toString());
|
achor.setPOSZ(obj[4] == null ? "" : obj[4].toString());
|
achor.setLayer(obj[5] == null ? "" : obj[5].toString());
|
achor.setZu(obj[6] == null ? "" : obj[6].toString());
|
achor.setLiangcheng(obj[7] == null ? "" : obj[7].toString());
|
achor.setAnchorip(obj[9] == null ? "" : obj[9].toString());
|
achor.setVersion(obj[10] == null ? "" : obj[10].toString());
|
achor.setGreateTime(obj[13] == null ? "" : obj[13].toString());
|
tb_achorList.add(achor);
|
}
|
}
|
return tb_achorList;
|
}
|
|
public List<tb_achor> searchAnchorManagementaa(String input) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime,baoliu6,baoliu7 FROM tb_achor WHERE anchorid = :anchorid";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", input);
|
List resultList = query.getResultList();
|
List<tb_achor> tb_achorList = new ArrayList<tb_achor>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_achor achor = new tb_achor();
|
Object[] obj = (Object[]) resultList.get(i);
|
achor.setId((int) obj[0]);
|
achor.setAnchormode(obj[8] == null ? "" : obj[8].toString());
|
achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
|
achor.setPOSX(obj[14] == null ? "" : obj[14].toString());
|
achor.setPOSY(obj[15] == null ? "" : obj[15].toString());
|
achor.setPOSZ(obj[4] == null ? "" : obj[4].toString());
|
achor.setLayer(obj[5] == null ? "" : obj[5].toString());
|
achor.setZu(obj[6] == null ? "" : obj[6].toString());
|
achor.setLiangcheng(obj[7] == null ? "" : obj[7].toString());
|
achor.setAnchorip(obj[9] == null ? "" : obj[9].toString());
|
achor.setVersion(obj[10] == null ? "" : obj[10].toString());
|
achor.setGreateTime(obj[13] == null ? "" : obj[13].toString());
|
tb_achorList.add(achor);
|
}
|
}
|
return tb_achorList;
|
}
|
|
public int getAnchorManagementCount() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT count(1) FROM tb_achor";
|
query = this.em.createNativeQuery(sql);
|
return Integer.parseInt(query.getSingleResult().toString());
|
}
|
|
@Transactional
|
public int anchorManagement_add(tb_achor achor) {
|
//默认值逻辑处理
|
if(("").equals(achor.getPOSX())){
|
achor.setPOSX("0");
|
}
|
if(("").equals(achor.getPOSY())){
|
achor.setPOSY("0");
|
}
|
if(("").equals(achor.getPOSZ())){
|
achor.setPOSZ("0");
|
}
|
if(("").equals(achor.getLayer())){
|
achor.setLayer("0");
|
}
|
if(("").equals(achor.getZu())){
|
achor.setZu("0");
|
}
|
if(("").equals(achor.getLiangcheng())){
|
achor.setLiangcheng("无限制");
|
}
|
String sql = null;
|
Query query = null;
|
sql = "INSERT INTO tb_achor(anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchorip,anchormode,version,greateTime) VALUES(:anchorid,:POSX,:POSY,:POSZ,:layer,:zu,:liangcheng,:anchorip,:anchormode,:version,now())";
|
cs.tb_caozuo("tb_achor", 1);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", achor.getAnchorid());
|
query.setParameter("POSX", achor.getPOSX());
|
query.setParameter("POSY", achor.getPOSY());
|
query.setParameter("POSZ", achor.getPOSZ());
|
query.setParameter("layer", achor.getLayer());
|
query.setParameter("zu", achor.getZu());
|
query.setParameter("liangcheng", achor.getLiangcheng());
|
query.setParameter("anchorip", achor.getAnchorip());
|
query.setParameter("anchormode", achor.getAnchormode());
|
query.setParameter("version", achor.getVersion());
|
int executeUpdate = query.executeUpdate();
|
return executeUpdate;
|
}
|
|
@Transactional
|
public int anchorManagement_addaa(tb_achor achor) {
|
//默认值逻辑处理
|
if(("").equals(achor.getPOSX())){
|
achor.setPOSX("0");
|
}
|
if(("").equals(achor.getPOSY())){
|
achor.setPOSY("0");
|
}
|
if(("").equals(achor.getPOSZ())){
|
achor.setPOSZ("0");
|
}
|
if(("").equals(achor.getLayer())){
|
achor.setLayer("0");
|
}
|
if(("").equals(achor.getZu())){
|
achor.setZu("0");
|
}
|
if(("").equals(achor.getLiangcheng())){
|
achor.setLiangcheng("无限制");
|
}
|
String sql = null;
|
Query query = null;
|
sql = "INSERT INTO tb_achor(anchorid,baoliu6,baoliu7,POSZ,layer,zu,liangcheng,anchorip,anchormode,version,greateTime) VALUES(:anchorid,:POSX,:POSY,:POSZ,:layer,:zu,:liangcheng,:anchorip,:anchormode,:version,now())";
|
cs.tb_caozuo("tb_achor", 1);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", achor.getAnchorid());
|
query.setParameter("POSX", achor.getPOSX());
|
query.setParameter("POSY", achor.getPOSY());
|
query.setParameter("POSZ", achor.getPOSZ());
|
query.setParameter("layer", achor.getLayer());
|
query.setParameter("zu", achor.getZu());
|
query.setParameter("liangcheng", achor.getLiangcheng());
|
query.setParameter("anchorip", achor.getAnchorip());
|
query.setParameter("anchormode", achor.getAnchormode());
|
query.setParameter("version", achor.getVersion());
|
int executeUpdate = query.executeUpdate();
|
return executeUpdate;
|
}
|
|
@Transactional
|
public int anchorManagement_modify(tb_achor achor) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_achor SET POSX=:POSX,POSY=:POSY,POSZ=:POSZ,layer=:layer,zu=:zu,liangcheng=:liangcheng,anchorip=:anchorip WHERE anchorid=:anchorid";
|
cs.tb_caozuo("tb_achor", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", achor.getAnchorid());
|
query.setParameter("POSX", achor.getPOSX());
|
query.setParameter("POSY", achor.getPOSY());
|
query.setParameter("POSZ", achor.getPOSZ());
|
query.setParameter("layer", achor.getLayer());
|
query.setParameter("zu", achor.getZu());
|
query.setParameter("liangcheng", achor.getLiangcheng());
|
query.setParameter("anchorip", achor.getAnchorip());
|
int aaa = query.executeUpdate();
|
return aaa;
|
}
|
|
@Transactional
|
public int anchorManagement_modifyaa(tb_achor achor) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_achor SET baoliu6=:POSX,baoliu7=:POSY,POSZ=:POSZ,layer=:layer,zu=:zu,liangcheng=:liangcheng,anchorip=:anchorip WHERE anchorid=:anchorid";
|
cs.tb_caozuo("tb_achor", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", achor.getAnchorid());
|
query.setParameter("POSX", achor.getPOSX());
|
query.setParameter("POSY", achor.getPOSY());
|
query.setParameter("POSZ", achor.getPOSZ());
|
query.setParameter("layer", achor.getLayer());
|
query.setParameter("zu", achor.getZu());
|
query.setParameter("liangcheng", achor.getLiangcheng());
|
query.setParameter("anchorip", achor.getAnchorip());
|
int aaa = query.executeUpdate();
|
return aaa;
|
}
|
|
@Transactional
|
public void anchorProx_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_anchor_nearby WHERE anchorid = :id";
|
cs.tb_caozuo("tb_anchor_nearby", 2);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("id", checkVal[i]);
|
query.executeUpdate();
|
}
|
}
|
|
@Transactional
|
public int anchorManagement_delete(String[] checkVal) {
|
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_achor WHERE id = :id";
|
cs.tb_caozuo("tb_achor", 2);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("id", id);
|
query.executeUpdate();
|
}
|
return aaa;
|
}
|
|
@Transactional
|
public int anchorManagement_deletea(String[] checkVal) {
|
String sql = null;
|
Query query = null;
|
int aaa = checkVal.length;
|
for (int i = 0; i < checkVal.length; i++) {
|
sql = "DELETE FROM tb_achor WHERE anchorid = :anchorid";
|
cs.tb_caozuo("tb_achor", 2);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", checkVal[i]);
|
query.executeUpdate();
|
}
|
return aaa;
|
}
|
|
@Transactional
|
public void anchorSync_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_tongbuanchor WHERE anchorid = :id";
|
cs.tb_caozuo("tb_tongbuanchor", 2);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("id", checkVal[i]);
|
query.executeUpdate();
|
}
|
}
|
|
@Transactional
|
public int anchorManagement_deleteAll() {
|
String sql = null;
|
Query query = null;
|
sql = "DELETE FROM tb_achor";
|
cs.tb_caozuo("tb_achor", 2);
|
query = this.em.createNativeQuery(sql);
|
int aaa = query.executeUpdate();
|
return aaa;
|
}
|
|
public List<tb_anchor_nearby> getProximityConfiguration() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT anchorid,near1,near2,near3,near4,near5,near6,near7,near8,qiehuan FROM tb_anchor_nearby";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_anchor_nearby> tb_anchor_nearbyList = new ArrayList<tb_anchor_nearby>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_anchor_nearby anchor_nearby = new tb_anchor_nearby();
|
Object[] obj = (Object[]) resultList.get(i);
|
anchor_nearby.setAnchorid(obj[0] == null ? "" : obj[0].toString());
|
anchor_nearby.setNear1(obj[1] == null ? "" : obj[1].toString());
|
anchor_nearby.setNear2(obj[2] == null ? "" : obj[2].toString());
|
anchor_nearby.setNear3(obj[3] == null ? "" : obj[3].toString());
|
anchor_nearby.setNear4(obj[4] == null ? "" : obj[4].toString());
|
anchor_nearby.setNear5(obj[5] == null ? "" : obj[5].toString());
|
anchor_nearby.setNear6(obj[6] == null ? "" : obj[6].toString());
|
anchor_nearby.setNear7(obj[7] == null ? "" : obj[7].toString());
|
anchor_nearby.setNear8(obj[8] == null ? "" : obj[8].toString());
|
anchor_nearby.setQiehuan(obj[9] == null ? "" : obj[9].toString());
|
tb_anchor_nearbyList.add(anchor_nearby);
|
}
|
}
|
return tb_anchor_nearbyList;
|
}
|
|
@Transactional
|
public void anchorManagement_modify_ip_ver(tb_achor achor) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_achor SET version=:version WHERE anchorip=:anchorip";
|
cs.tb_caozuo("tb_achor", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("version", achor.getVersion());
|
query.setParameter("anchorip", achor.getAnchorip());
|
query.executeUpdate();
|
}
|
|
public List<tb_anchor_nearby> searchAnchornearby(String anchorid) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT anchorid,near1,near2,near3,near4,near5,near6,near7,near8,qiehuan FROM tb_anchor_nearby WHERE anchorid=:anchorid";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", anchorid);
|
List resultList = query.getResultList();
|
List<tb_anchor_nearby> tb_anchor_nearbyList = new ArrayList<tb_anchor_nearby>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_anchor_nearby anchor_nearby = new tb_anchor_nearby();
|
Object[] obj = (Object[]) resultList.get(i);
|
anchor_nearby.setAnchorid(obj[0] == null ? "" : obj[0].toString());
|
anchor_nearby.setNear1(obj[1] == null ? "" : obj[1].toString());
|
anchor_nearby.setNear2(obj[2] == null ? "" : obj[2].toString());
|
anchor_nearby.setNear3(obj[3] == null ? "" : obj[3].toString());
|
anchor_nearby.setNear4(obj[4] == null ? "" : obj[4].toString());
|
anchor_nearby.setNear5(obj[5] == null ? "" : obj[5].toString());
|
anchor_nearby.setNear6(obj[6] == null ? "" : obj[6].toString());
|
anchor_nearby.setNear7(obj[7] == null ? "" : obj[7].toString());
|
anchor_nearby.setNear8(obj[8] == null ? "" : obj[8].toString());
|
anchor_nearby.setQiehuan(obj[9] == null ? "" : obj[9].toString());
|
tb_anchor_nearbyList.add(anchor_nearby);
|
}
|
}
|
return tb_anchor_nearbyList;
|
}
|
|
@Transactional
|
public void proximityConfiguration_add(tb_anchor_nearby anchor_nearby) {
|
String sql = null;
|
Query query = null;
|
sql = "INSERT INTO tb_anchor_nearby(anchorid,near1,near2,near3,near4,near5,near6,near7,near8,qiehuan) VALUES(:anchorid,:near1,:near2,:near3,:near4,:near5,:near6,:near7,:near8,:qiehuan)";
|
cs.tb_caozuo("tb_anchor_nearby", 1);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", anchor_nearby.getAnchorid());
|
query.setParameter("near1", anchor_nearby.getNear1());
|
query.setParameter("near2", anchor_nearby.getNear2());
|
query.setParameter("near3", anchor_nearby.getNear3());
|
query.setParameter("near4", anchor_nearby.getNear4());
|
query.setParameter("near5", anchor_nearby.getNear5());
|
query.setParameter("near6", anchor_nearby.getNear6());
|
query.setParameter("near7", anchor_nearby.getNear7());
|
query.setParameter("near8", anchor_nearby.getNear8());
|
query.setParameter("qiehuan", anchor_nearby.getQiehuan());
|
query.executeUpdate();
|
}
|
|
@Transactional
|
public void proximityConfiguration_update(tb_anchor_nearby anchor_nearby) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_anchor_nearby SET near1=:near1,near2=:near2,near3=:near3,near4=:near4,near5=:near5,near6=:near6,near7=:near7,near8=:near8,qiehuan=:qiehuan WHERE anchorid=:anchorid";
|
cs.tb_caozuo("tb_anchor_nearby", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", anchor_nearby.getAnchorid());
|
query.setParameter("near1", anchor_nearby.getNear1());
|
query.setParameter("near2", anchor_nearby.getNear2());
|
query.setParameter("near3", anchor_nearby.getNear3());
|
query.setParameter("near4", anchor_nearby.getNear4());
|
query.setParameter("near5", anchor_nearby.getNear5());
|
query.setParameter("near6", anchor_nearby.getNear6());
|
query.setParameter("near7", anchor_nearby.getNear7());
|
query.setParameter("near8", anchor_nearby.getNear8());
|
query.setParameter("qiehuan", anchor_nearby.getQiehuan());
|
query.executeUpdate();
|
}
|
|
@Transactional
|
public void proximityConfiguration_delete() {
|
String sql = null;
|
Query query = null;
|
sql = "DELETE FROM tb_anchor_nearby";
|
cs.tb_caozuo("tb_anchor_nearby", 2);
|
query = this.em.createNativeQuery(sql);
|
query.executeUpdate();
|
}
|
|
public List<tb_tongbuanchor> getSyncConfiguration() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT anchorid,rootanchorid,type,state,addtime FROM tb_tongbuanchor";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_tongbuanchor> tb_tongbuanchorList = new ArrayList<tb_tongbuanchor>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_tongbuanchor tongbuanchor = new tb_tongbuanchor();
|
Object[] obj = (Object[]) resultList.get(i);
|
tongbuanchor.setAnchorid(obj[0] == null ? "" : obj[0].toString());
|
tongbuanchor.setRootanchorid(obj[1] == null ? "" : obj[1].toString());
|
tongbuanchor.setType(obj[2] == null ? "" : obj[2].toString());
|
tongbuanchor.setState(obj[3] == null ? "" : obj[3].toString());
|
tongbuanchor.setAddtime(obj[4] == null ? "" : obj[4].toString());
|
tb_tongbuanchorList.add(tongbuanchor);
|
}
|
}
|
return tb_tongbuanchorList;
|
}
|
|
@Transactional
|
public void syncConfiguration_add(tb_tongbuanchor tongbuanchor) {
|
String sql = null;
|
Query query = null;
|
sql = "INSERT INTO tb_tongbuanchor(anchorid,rootanchorid,type,state,addtime) VALUES(:anchorid,:rootanchorid,:type,:state,now())";
|
cs.tb_caozuo("tb_tongbuanchor", 1);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", tongbuanchor.getAnchorid());
|
query.setParameter("rootanchorid", tongbuanchor.getRootanchorid());
|
query.setParameter("type", tongbuanchor.getType());
|
query.setParameter("state", tongbuanchor.getState());
|
query.executeUpdate();
|
}
|
|
public List<tb_tongbuanchor> searchTongbuanchor(String anchorid) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT anchorid,rootanchorid,type,state,addtime FROM tb_tongbuanchor WHERE anchorid=:anchorid";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", anchorid);
|
List resultList = query.getResultList();
|
List<tb_tongbuanchor> tb_tongbuanchorList = new ArrayList<tb_tongbuanchor>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_tongbuanchor tongbuanchor = new tb_tongbuanchor();
|
Object[] obj = (Object[]) resultList.get(i);
|
tongbuanchor.setAnchorid(obj[0] == null ? "" : obj[0].toString());
|
tongbuanchor.setRootanchorid(obj[1] == null ? "" : obj[1].toString());
|
tongbuanchor.setType(obj[2] == null ? "" : obj[2].toString());
|
tongbuanchor.setState(obj[3] == null ? "" : obj[3].toString());
|
tongbuanchor.setAddtime(obj[4] == null ? "" : obj[4].toString());
|
tb_tongbuanchorList.add(tongbuanchor);
|
}
|
}
|
return tb_tongbuanchorList;
|
}
|
|
@Transactional
|
public void syncConfiguration_update(tb_tongbuanchor tongbuanchor) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_tongbuanchor SET rootanchorid=:rootanchorid,type=:type,state=:state WHERE anchorid=:anchorid";
|
cs.tb_caozuo("tb_tongbuanchor", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", tongbuanchor.getAnchorid());
|
query.setParameter("rootanchorid", tongbuanchor.getRootanchorid());
|
query.setParameter("type", tongbuanchor.getType());
|
query.setParameter("state", tongbuanchor.getState());
|
query.executeUpdate();
|
}
|
|
@Transactional
|
public void syncConfiguration_delete() {
|
String sql = null;
|
Query query = null;
|
sql = "DELETE FROM tb_tongbuanchor";
|
cs.tb_caozuo("tb_tongbuanchor", 2);
|
query = this.em.createNativeQuery(sql);
|
query.executeUpdate();
|
}
|
|
@Transactional
|
public void syncConfiguration_modify(tb_tongbuanchor tongbuanchor) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_tongbuanchor SET rootanchorid=:rootanchorid,type=:type,state=:state WHERE anchorid=:anchorid";
|
cs.tb_caozuo("tb_tongbuanchor", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", tongbuanchor.getAnchorid());
|
query.setParameter("rootanchorid", tongbuanchor.getRootanchorid());
|
query.setParameter("type", tongbuanchor.getType());
|
query.setParameter("state", tongbuanchor.getState());
|
query.executeUpdate();
|
}
|
|
public tb_wifi getWifiManagement() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,webname,webPass,anchorid,port,xieyitype,model,wifiname,wifipass,ip,wangguan,ziwang,fuwuip,jiamileixing,jiamisuanfa,sousuoport,keyword FROM tb_wifi";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
tb_wifi wifi = new tb_wifi();
|
if (resultList.size() > 0) {
|
Object[] obj = (Object[]) resultList.get(0);
|
wifi.setId((int) obj[0]);
|
wifi.setWebname(obj[1] == null ? "" : obj[1].toString());
|
wifi.setWebPass(obj[2] == null ? "" : obj[2].toString());
|
wifi.setAnchorid(obj[3] == null ? "" : obj[3].toString());
|
wifi.setPort(obj[4] == null ? "" : obj[4].toString());
|
wifi.setXieyitype(obj[5] == null ? "" : obj[5].toString());
|
wifi.setModel(obj[6] == null ? "" : obj[6].toString());
|
wifi.setWifiname(obj[7] == null ? "" : obj[7].toString());
|
wifi.setWifipass(obj[8] == null ? "" : obj[8].toString());
|
wifi.setIp(obj[9] == null ? "" : obj[9].toString());
|
wifi.setWangguan(obj[10] == null ? "" : obj[10].toString());
|
wifi.setZiwang(obj[11] == null ? "" : obj[11].toString());
|
wifi.setFuwuip(obj[12] == null ? "" : obj[12].toString());
|
wifi.setJiamileixing(obj[13] == null ? "" : obj[13].toString());
|
wifi.setJiamisuanfa(obj[14] == null ? "" : obj[14].toString());
|
wifi.setSousuoport(obj[15] == null ? "" : obj[15].toString());
|
wifi.setKeyword(obj[16] == null ? "" : obj[16].toString());
|
}
|
return wifi;
|
}
|
|
@Transactional
|
public void wifiManagement_modify(tb_wifi wifi) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_wifi SET webname=:webname,webPass=:webPass,anchorid=:anchorid,port=:port,xieyitype=:xieyitype,model=:model,wifiname=:wifiname,wifipass=:wifipass,ip=:ip,wangguan=:wangguan,ziwang=:ziwang,fuwuip=:fuwuip,jiamileixing=:jiamileixing,jiamisuanfa=:jiamisuanfa,sousuoport=:sousuoport,keyword=:keyword WHERE id=:id";
|
cs.tb_caozuo("tb_wifi", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("webname", wifi.getWebname());
|
query.setParameter("webPass", wifi.getWebPass());
|
query.setParameter("anchorid", wifi.getAnchorid());
|
query.setParameter("port", wifi.getPort());
|
query.setParameter("xieyitype", wifi.getXieyitype());
|
query.setParameter("model", wifi.getModel());
|
query.setParameter("wifiname", wifi.getWifiname());
|
query.setParameter("wifipass", wifi.getWifipass());
|
query.setParameter("ip", wifi.getIp());
|
query.setParameter("wangguan", wifi.getWangguan());
|
query.setParameter("ziwang", wifi.getZiwang());
|
query.setParameter("fuwuip", wifi.getFuwuip());
|
query.setParameter("jiamileixing", wifi.getJiamileixing());
|
query.setParameter("jiamisuanfa", wifi.getJiamisuanfa());
|
query.setParameter("sousuoport", wifi.getSousuoport());
|
query.setParameter("keyword", wifi.getKeyword());
|
query.setParameter("id", wifi.getId());
|
query.executeUpdate();
|
}
|
|
@Transactional
|
public void anchorManagement_modify_mode(tb_achor achor) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_achor SET anchormode=:anchormode WHERE anchorid=:anchorid";
|
cs.tb_caozuo("tb_achor", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", achor.getAnchorid());
|
query.setParameter("anchormode", achor.getAnchormode());
|
query.executeUpdate();
|
}
|
|
@Transactional
|
public void syncConfiguration_update_state(tb_tongbuanchor tongbuanchor) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_tongbuanchor SET state=:state WHERE anchorid=:anchorid";
|
cs.tb_caozuo("tb_tongbuanchor", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", tongbuanchor.getAnchorid());
|
query.setParameter("state", tongbuanchor.getState());
|
query.executeUpdate();
|
}
|
|
@Transactional
|
public int anchor_modify_status(tb_achor achor) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_achor SET anchormode=:anchormode,anchorip=:anchorip WHERE anchorid=:anchorid";
|
cs.tb_caozuo("tb_achor", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("anchorid", achor.getAnchorid());
|
query.setParameter("anchormode", achor.getAnchormode());
|
query.setParameter("anchorip", achor.getAnchorip());
|
int executeUpdate = query.executeUpdate();
|
return executeUpdate;
|
}
|
|
public List<tb_shebei> getjizhanshebei() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT anchorid,anchormode,anchorip,version,GreateTime FROM tb_achor";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_shebei> list = new ArrayList<tb_shebei>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_shebei shebei = new tb_shebei();
|
Object[] obj = (Object[]) resultList.get(i);
|
shebei.setZhuangtai(obj[1] == null ? "" : obj[1].toString());
|
shebei.setId(obj[0] == null ? "" : obj[0].toString());
|
shebei.setDuixiang("定位基站");
|
shebei.setBanben(obj[3] == null ? "" : obj[3].toString());
|
shebei.setXiangqing(obj[2] == null ? "" : obj[2].toString());
|
shebei.setTime(obj[4] == null ? "" : obj[4].toString());
|
list.add(shebei);
|
}
|
}
|
//System.out.print(list);
|
return list;
|
}
|
|
public List<tb_shebei> getbiaoqianshebei() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT tag_id,status,state,power,version,addtime FROM tb_tag";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_shebei> list = new ArrayList<tb_shebei>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_shebei shebei = new tb_shebei();
|
Object[] obj = (Object[]) resultList.get(i);
|
shebei.setZhuangtai(obj[1] == null ? "" : obj[1].toString());
|
shebei.setId(obj[0] == null ? "" : obj[0].toString());
|
shebei.setDuixiang(obj[2] == null ? "" : obj[2].toString());
|
shebei.setBanben(obj[4] == null ? "" : obj[4].toString());
|
shebei.setXiangqing(obj[3] == null ? "" : obj[3].toString());
|
shebei.setTime(obj[5] == null ? "" : obj[5].toString());
|
list.add(shebei);
|
}
|
}
|
return list;
|
}
|
|
public List<tb_shebei> getbiaoqianshebei2() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT p.p_tagid,p.p_online,p.p_name,p.p_power,t.version,p.p_addtiem FROM tb_person AS p,tb_tag AS t WHERE p.p_tagid = t.tag_id";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_shebei> list = new ArrayList<tb_shebei>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_shebei shebei = new tb_shebei();
|
Object[] obj = (Object[]) resultList.get(i);
|
shebei.setZhuangtai(obj[1] == null ? "" : obj[1].toString());
|
shebei.setId(obj[0] == null ? "" : obj[0].toString());
|
shebei.setDuixiang(obj[2] == null ? "" : obj[2].toString());
|
shebei.setBanben(obj[4] == null ? "" : obj[4].toString());
|
shebei.setXiangqing(obj[3] == null ? "" : obj[3].toString());
|
shebei.setTime(obj[5] == null ? "" : obj[5].toString());
|
list.add(shebei);
|
}
|
}
|
return list;
|
}
|
|
public List<tb_achor> searchidAnchorManagement(String id) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM tb_achor WHERE id = :id";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("id", id);
|
List resultList = query.getResultList();
|
List<tb_achor> tb_achorList = new ArrayList<tb_achor>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_achor achor = new tb_achor();
|
Object[] obj = (Object[]) resultList.get(i);
|
achor.setId((int) obj[0]);
|
achor.setAnchormode(obj[8] == null ? "" : obj[8].toString());
|
achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
|
achor.setPOSX(obj[2] == null ? "" : obj[2].toString());
|
achor.setPOSY(obj[3] == null ? "" : obj[3].toString());
|
achor.setPOSZ(obj[4] == null ? "" : obj[4].toString());
|
achor.setLayer(obj[5] == null ? "" : obj[5].toString());
|
achor.setZu(obj[6] == null ? "" : obj[6].toString());
|
achor.setLiangcheng(obj[7] == null ? "" : obj[7].toString());
|
achor.setAnchorip(obj[9] == null ? "" : obj[9].toString());
|
achor.setVersion(obj[10] == null ? "" : obj[10].toString());
|
achor.setGreateTime(obj[13] == null ? "" : obj[13].toString());
|
tb_achorList.add(achor);
|
}
|
}
|
return tb_achorList;
|
}
|
|
public String searchidAnchorManagement2(String id) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT anchorid FROM tb_achor WHERE id = :id";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("id", id);
|
List resultList = query.getResultList();
|
String status = resultList.get(0).toString();
|
return status;
|
}
|
|
public List<tb_anchorhistory> getAnchorhistory() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,anchorid,state,addtime FROM tb_anchor_history_record ORDER BY id DESC";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_anchorhistory> tb_achorList = new ArrayList<tb_anchorhistory>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_anchorhistory achor = new tb_anchorhistory();
|
Object[] obj = (Object[]) resultList.get(i);
|
achor.setId((int) obj[0]);
|
achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
|
achor.setState(obj[2] == null ? "" : obj[2].toString());
|
achor.setAddtime(obj[3] == null ? "" : obj[3].toString());
|
tb_achorList.add(achor);
|
}
|
}
|
return tb_achorList;
|
}
|
|
public List<tb_anchorhistory> getidAnchorhistory(String aaa) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,anchorid,state,addtime FROM tb_anchor_history_record where addtime like '"+aaa+"____________'";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_anchorhistory> tb_achorList = new ArrayList<tb_anchorhistory>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_anchorhistory achor = new tb_anchorhistory();
|
Object[] obj = (Object[]) resultList.get(i);
|
achor.setId((int) obj[0]);
|
achor.setAnchorid(obj[1] == null ? "" : obj[1].toString());
|
achor.setState(obj[2] == null ? "" : obj[2].toString());
|
achor.setAddtime(obj[3] == null ? "" : obj[3].toString());
|
tb_achorList.add(achor);
|
}
|
}
|
return tb_achorList;
|
}
|
}
|
