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;
	}
}