package com.hxzkoa.services;

import java.util.ArrayList;
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_bsbaowen;
import com.hxzkoa.json.tb_collector;
import com.hxzkoa.json.tb_department;
import com.hxzkoa.json.tb_forward_data;
import com.hxzkoa.json.tb_suanfa;
import com.hxzkoa.json.tb_system;
import com.hxzkoa.json.tb_tag;
import com.hxzkoa.json.tb_user;
import com.hxzkoa.json.tb_yuan_shi_bao_wen;
import com.hxzkoa.util.Config;
import com.hxzkoa.util.ModifyConfig;

@Service
public class SysSettingService {
	@PersistenceContext
	private EntityManager em;
	@Autowired
	private CaozuoService cs;
	
	public List<tb_bsbaowen> bsbaowen() {
		String sql = null;
		Query query = null;
		sql = "SELECT id,Receive_time,type,tagid,neirong FROM (SELECT id,Receive_time,type,tagid,neirong FROM tb_bsbaowen ORDER BY id DESC) s LIMIT 13";
		query = this.em.createNativeQuery(sql);
		List resultList = query.getResultList();
		List<tb_bsbaowen> tb_bsbaowenList = new ArrayList<tb_bsbaowen>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_bsbaowen bsbaowen = new tb_bsbaowen();
				bsbaowen.setId((Integer)obj[0]);
				bsbaowen.setReceive_time(obj[1] == null ? "" : obj[1].toString());
				bsbaowen.setType(obj[2] == null ? "" : obj[2].toString());
				bsbaowen.setTagid(obj[3] == null ? "" : obj[3].toString());
				bsbaowen.setNeirong(obj[4] == null ? "" : obj[4].toString());
				tb_bsbaowenList.add(bsbaowen);
			}
		}
		return tb_bsbaowenList;
	}
	
	public List<tb_forward_data> getmessageTransfer(int page) {
		int perPage = Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage"));
		int start = (page - 1) * perPage;
		int end = perPage;
		String sql = null;
		Query query = null;
		sql = "SELECT id,type,ip,port,datatype,addtime FROM tb_forward_data LIMIT :start,:end";
		query = this.em.createNativeQuery(sql);
		query.setParameter("start", start);
		query.setParameter("end", end);
		List resultList = query.getResultList();
		List<tb_forward_data> tb_forward_dataList = new ArrayList<tb_forward_data>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_forward_data forward_data = new tb_forward_data();
				forward_data.setId((Integer)obj[0]);
				forward_data.setType(obj[1] == null ? "" : obj[1].toString());
				forward_data.setIp(obj[2] == null ? "" : obj[2].toString());
				forward_data.setPort(obj[3] == null ? "" : obj[3].toString());
				forward_data.setDatatype(obj[4] == null ? "" : obj[4].toString());
				forward_data.setAddtime(obj[5] == null ? "" : obj[5].toString());
				tb_forward_dataList.add(forward_data);
			}
		}
		return tb_forward_dataList;
	}
	
	public List<tb_forward_data> getALLMessageTransfer(String dataType) {
		String sql = null;
		Query query = null;
		sql = "SELECT id,type,ip,port,datatype,addtime FROM tb_forward_data WHERE datatype=:dataType OR datatype='全部数据'";
		query = this.em.createNativeQuery(sql);
		query.setParameter("dataType", dataType);
		List resultList = query.getResultList();	
		List<tb_forward_data> tb_forward_dataList = new ArrayList<tb_forward_data>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_forward_data forward_data = new tb_forward_data();
				forward_data.setId((Integer)obj[0]);
				forward_data.setType(obj[1] == null ? "" : obj[1].toString());
				forward_data.setIp(obj[2] == null ? "" : obj[2].toString());
				forward_data.setPort(obj[3] == null ? "" : obj[3].toString());
				forward_data.setDatatype(obj[4] == null ? "" : obj[4].toString());
				forward_data.setAddtime(obj[5] == null ? "" : obj[5].toString());
				tb_forward_dataList.add(forward_data);
			}
		}
		return tb_forward_dataList;
	}
	
	public List<tb_forward_data> searchmessageTransfer(String input) {
		int id = Integer.parseInt(input);
		String sql = null;
		Query query = null;
		sql = "SELECT id,type,ip,port,datatype,addtime FROM tb_forward_data WHERE id = :id";
		query = this.em.createNativeQuery(sql);
		query.setParameter("id", id);
		List resultList = query.getResultList();
		List<tb_forward_data> tb_forward_dataList = new ArrayList<tb_forward_data>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_forward_data forward_data = new tb_forward_data();
				forward_data.setId((Integer)obj[0]);
				forward_data.setType(obj[1] == null ? "" : obj[1].toString());
				forward_data.setIp(obj[2] == null ? "" : obj[2].toString());
				forward_data.setPort(obj[3] == null ? "" : obj[3].toString());
				forward_data.setDatatype(obj[4] == null ? "" : obj[4].toString());
				forward_data.setAddtime(obj[5] == null ? "" : obj[5].toString());
				tb_forward_dataList.add(forward_data);
			}
		}
		return tb_forward_dataList;
	}

	public int getmessageTransferCount() {
		String sql = null;
		Query query = null;
		sql = "SELECT count(1) FROM tb_forward_data";
		query = this.em.createNativeQuery(sql);
		return Integer.parseInt(query.getSingleResult().toString());
	}
	
	@Transactional
	public void messageTransfer_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_forward_data WHERE id = :id";
			cs.tb_caozuo("tb_forward_data", 2);
			query = this.em.createNativeQuery(sql);
			query.setParameter("id", id);
			query.executeUpdate();
		}
	}

	@Transactional
	public void messageTransfer_deleteAll() {
		String sql = null;
		Query query = null;
		sql = "DELETE FROM tb_forward_data";
		cs.tb_caozuo("tb_forward_data", 2);
		query = this.em.createNativeQuery(sql);
		query.executeUpdate();
	}
	
	@Transactional
	public int messageTransfer_add(tb_forward_data data) {
		String sql = null;
		Query query = null;
		sql = "INSERT INTO tb_forward_data(type,ip,port,datatype,addtime) VALUES(:type,:ip,:port,:datatype,now())";
		cs.tb_caozuo("tb_forward_data", 1);
		query = this.em.createNativeQuery(sql);
		query.setParameter("type", data.getType());
		query.setParameter("ip", data.getIp());
		query.setParameter("port", data.getPort());
		query.setParameter("datatype", data.getDatatype());
		int executeUpdate = query.executeUpdate();
		return executeUpdate;
	}
	
	
	@Transactional
	public int messageTransfer_modify(tb_forward_data data) {
		String sql = null;
		Query query = null;
		sql = "UPDATE tb_forward_data SET type = :type,port = :port,datatype = :datatype,ip = :ip,addtime = now() WHERE id= :id";
		cs.tb_caozuo("tb_forward_data", 3);
		query = this.em.createNativeQuery(sql);
		query.setParameter("id", data.getId());
		query.setParameter("type", data.getType());
		query.setParameter("ip", data.getIp());
		query.setParameter("port", data.getPort());
		query.setParameter("datatype", data.getDatatype());
		int executeUpdate = query.executeUpdate();
		return executeUpdate;
	}
	
	public List<tb_user> getuserManagement() {
		String sql = null;
		Query query = null;
		sql = "SELECT id,username,superuser,deleteq,alertq,deleteall,justlook,addtime,fenceq FROM tb_user";
		query = this.em.createNativeQuery(sql);
		List resultList = query.getResultList();
		List<tb_user> tb_userList = new ArrayList<tb_user>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_user user = new tb_user();
				user.setId((Integer)obj[0]);
				user.setUsername(obj[1] == null ? "" : obj[1].toString());
				user.setSuperuser(obj[2] == null ? "" : obj[2].toString());
				user.setDeleteq(obj[3] == null ? "" : obj[3].toString());
				user.setAlertq(obj[4] == null ? "" : obj[4].toString());
				user.setDeleteall(obj[5] == null ? "" : obj[5].toString());
				user.setJustlook(obj[6] == null ? "" : obj[6].toString());
				user.setAddtime(obj[7] == null ? "" : obj[7].toString());
				user.setFenceq(obj[8] == null ? "" : obj[8].toString());
				tb_userList.add(user);
			}
		}
		return tb_userList;
	}
	
	public List<tb_user> getuserManagement(int page) {
		int perPage = Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage"));
		int start = (page - 1) * perPage;
		int end = perPage;
		String sql = null;
		Query query = null;
		sql = "SELECT id,username,superuser,deleteq,alertq,deleteall,justlook,addtime,fenceq FROM tb_user LIMIT :start,:end";
		query = this.em.createNativeQuery(sql);
		query.setParameter("start", start);
		query.setParameter("end", end);
		List resultList = query.getResultList();
		List<tb_user> tb_userList = new ArrayList<tb_user>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_user user = new tb_user();
				user.setId((Integer)obj[0]);
				user.setUsername(obj[1] == null ? "" : obj[1].toString());
				user.setSuperuser(obj[2] == null ? "" : obj[2].toString());
				user.setDeleteq(obj[3] == null ? "" : obj[3].toString());
				user.setAlertq(obj[4] == null ? "" : obj[4].toString());
				user.setDeleteall(obj[5] == null ? "" : obj[5].toString());
				user.setJustlook(obj[6] == null ? "" : obj[6].toString());
				user.setAddtime(obj[7] == null ? "" : obj[7].toString());
				user.setFenceq(obj[8] == null ? "" : obj[8].toString());
				tb_userList.add(user);
			}
		}
		return tb_userList;
	}
	
	public List<tb_user> getuserManagement2() {
		String sql = null;
		Query query = null;
		sql = "SELECT id,username,superuser,deleteq,alertq,deleteall,justlook,addtime FROM tb_user";
		query = this.em.createNativeQuery(sql);
		List resultList = query.getResultList();
		List<tb_user> tb_userList = new ArrayList<tb_user>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_user user = new tb_user();
				user.setId((Integer)obj[0]);
				user.setUsername(obj[1] == null ? "" : obj[1].toString());
				user.setSuperuser(obj[2] == null ? "" : obj[2].toString());
				user.setDeleteq(obj[3] == null ? "" : obj[3].toString());
				user.setAlertq(obj[4] == null ? "" : obj[4].toString());
				user.setDeleteall(obj[5] == null ? "" : obj[5].toString());
				user.setJustlook(obj[6] == null ? "" : obj[6].toString());
				user.setAddtime(obj[7] == null ? "" : obj[7].toString());
				tb_userList.add(user);
			}
		}
		return tb_userList;
	}
	
	public List<tb_user> searchuserManagement(String input) {
		String username = input;
		String sql = null;
		Query query = null;
		sql = "SELECT id,username,superuser,deleteq,alertq,deleteall,justlook,addtime,fenceq FROM tb_user WHERE username = :username";
		query = this.em.createNativeQuery(sql);
		query.setParameter("username", username);
		List resultList = query.getResultList();
		List<tb_user> tb_userList = new ArrayList<tb_user>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_user user = new tb_user();
				user.setId((Integer)obj[0]);
				user.setUsername(obj[1] == null ? "" : obj[1].toString());
				user.setSuperuser(obj[2] == null ? "" : obj[2].toString());
				user.setDeleteq(obj[3] == null ? "" : obj[3].toString());
				user.setAlertq(obj[4] == null ? "" : obj[4].toString());
				user.setDeleteall(obj[5] == null ? "" : obj[5].toString());
				user.setJustlook(obj[6] == null ? "" : obj[6].toString());
				user.setAddtime(obj[7] == null ? "" : obj[7].toString());
				user.setFenceq(obj[8] == null ? "" : obj[8].toString());
				tb_userList.add(user);
			}
		}
		return tb_userList;
	}

	public int getuserManagementCount() {
		String sql = null;
		Query query = null;
		sql = "SELECT count(1) FROM tb_user";
		query = this.em.createNativeQuery(sql);
		return Integer.parseInt(query.getSingleResult().toString());
	}
	
	@Transactional
	public void userManagement_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_user WHERE id = :id";
			cs.tb_caozuo("tb_user", 2);
			query = this.em.createNativeQuery(sql);
			query.setParameter("id", id);
			query.executeUpdate();
		}
	}
	
	@Transactional
	public int userManagement_deletea(String[] checkVal) {
		String sql = null;
		Query query = null;
		int aaa = 0;
		for (int i = 0; i < checkVal.length; i++) {
			int id = Integer.parseInt(checkVal[i]);
			sql = "DELETE FROM tb_user WHERE id = :id";
			cs.tb_caozuo("tb_user", 2);
			query = this.em.createNativeQuery(sql);
			query.setParameter("id", id);
			aaa = query.executeUpdate();
		}
		return aaa;
	}

	@Transactional
	public void userManagement_deleteAll() {
		String sql = null;
		Query query = null;
		sql = "DELETE FROM tb_user";
		cs.tb_caozuo("tb_user", 2);
		query = this.em.createNativeQuery(sql);
		query.executeUpdate();
	}
	
	@Transactional
	public int userManagement_deleteAlla() {
		String sql = null;
		Query query = null;
		sql = "DELETE FROM tb_user";
		cs.tb_caozuo("tb_user", 2);
		query = this.em.createNativeQuery(sql);
		int aaa = query.executeUpdate();
		return aaa;
	}
	
	@Transactional
	public int userManagement_add(tb_user user) {
		String sql = null;
		Query query = null;
		sql = "INSERT INTO tb_user(username,password,superuser,deleteq,alertq,deleteall,justlook,addtime,fenceq) "
				+ "VALUES(:username,:password,:superuser,:deleteq,:alertq,:deleteall,:justlook,now(),:fenceq)";
		cs.tb_caozuo("tb_user", 1);
		query = this.em.createNativeQuery(sql);
		query.setParameter("username", user.getUsername());
		query.setParameter("password", user.getPassword());
		query.setParameter("superuser", user.getSuperuser());
		query.setParameter("deleteq", user.getDeleteq());
		query.setParameter("alertq", user.getAlertq());
		query.setParameter("deleteall", user.getDeleteall());
		query.setParameter("justlook", user.getJustlook());
		query.setParameter("fenceq", user.getFenceq());
		int executeUpdate = query.executeUpdate();
		return executeUpdate;
	}
	
	@Transactional
	public int userManagement_check(String name) {
		String sql = null;
		Query query = null;
		sql = "SELECT count(1) FROM tb_user WHERE username= :username";
		query = this.em.createNativeQuery(sql);
		query.setParameter("username", name);
		return Integer.parseInt(query.getSingleResult().toString());
	}
	
	
	@Transactional
	public int userManagement_modify(tb_user user) {
		String sql = null;
		Query query = null;
		sql = "UPDATE tb_user SET username = :username,password = :password,superuser = :superuser,"
				+ "deleteq = :deleteq,alertq = :alertq,deleteall = :deleteall,justlook = :justlook,addtime = now(),fenceq = :fenceq WHERE id= :id";
		cs.tb_caozuo("tb_user", 3);
		query = this.em.createNativeQuery(sql);
		query.setParameter("id", user.getId());
		query.setParameter("username", user.getUsername());
		query.setParameter("password", user.getPassword());
		query.setParameter("superuser", user.getSuperuser());
		query.setParameter("deleteq", user.getDeleteq());
		query.setParameter("alertq", user.getAlertq());
		query.setParameter("deleteall", user.getDeleteall());
		query.setParameter("justlook", user.getJustlook());
		query.setParameter("fenceq", user.getFenceq());
		int executeUpdate = query.executeUpdate();
		return executeUpdate;
	}
	
	public List<tb_yuan_shi_bao_wen> getreplay() {
		String sql = null;
		Query query = null;
		sql = "SELECT id,ip,str,addtime FROM tb_yuan_shi_bao_wen";
		query = this.em.createNativeQuery(sql);
		List resultList = query.getResultList();
		List<tb_yuan_shi_bao_wen> tb_yuan_shi_bao_wenList = new ArrayList<tb_yuan_shi_bao_wen>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_yuan_shi_bao_wen yuan_shi_bao_wen = new tb_yuan_shi_bao_wen();
				yuan_shi_bao_wen.setId((Integer)obj[0]);
				yuan_shi_bao_wen.setIp(obj[1] == null ? "" : obj[1].toString());
				yuan_shi_bao_wen.setStr(obj[2] == null ? "" : obj[2].toString());
				yuan_shi_bao_wen.setAddtime(obj[3] == null ? "" : obj[3].toString());
				tb_yuan_shi_bao_wenList.add(yuan_shi_bao_wen);
			}
		}
		return tb_yuan_shi_bao_wenList;
	}
	
	public List<tb_system> getSetting() {
		String sql = null;
		Query query = null;
		sql = "SELECT dataname,datapass,gui_ji,bei_fen_di_zhi,data_time,title,udpPort,udpAdress,openudp,"
				+ "know_tag_zu,wifi_mdel,tagZb,diskaoqing,viewAnckid,viewName,tunlDw,guiji_sava,viewPower,"
				+ "viewTagid,viewAnckzb,offView,anckicon,gas_show,quiet,real_trak_time,"
				+ "real_trak_color,gas_open,gas_port,gas_hz,rssid,bs_udp,origin_jingdu,origin_weidu,origin_jiaodu,fence_show,yulan_map,baidu_j,baidu_w,cs_udp,baoliu10,baoliu13,baoliu14,baoliu15,baoliu16,baoliu17,baoliu19,baoliu20 FROM tb_system";
		query = this.em.createNativeQuery(sql);
		List resultList = query.getResultList();
		List<tb_system> tb_systemList = new ArrayList<tb_system>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_system setting = new tb_system();
				setting.setDataname(obj[0] == null ? "" : obj[0].toString());
				setting.setDatapass(obj[1] == null ? "" : obj[1].toString());
				setting.setGui_ji(obj[2] == null ? "" : obj[2].toString());
				setting.setBei_fen_di_zhi(obj[3] == null ? "" : obj[3].toString());
				setting.setData_time(obj[4] == null ? "" : obj[4].toString());
				setting.setTitle(obj[5] == null ? "" : obj[5].toString());
				setting.setUdpPort(obj[6] == null ? "" : obj[6].toString());
				setting.setUdpAdress(obj[7] == null ? "" : obj[7].toString());
				setting.setOpenudp(obj[8] == null ? "" : obj[8].toString());
				setting.setKnow_tag_zu(obj[9] == null ? "" : obj[9].toString());
				setting.setWifi_mdel(obj[10] == null ? "" : obj[10].toString());
				setting.setTagZb(obj[11] == null ? "" : obj[11].toString());
				setting.setDiskaoqing(obj[12] == null ? "" : obj[12].toString());
				setting.setViewAnckid(obj[13] == null ? "" : obj[13].toString());
				setting.setViewName(obj[14] == null ? "" : obj[14].toString());
				setting.setTunlDw(obj[15] == null ? "" : obj[15].toString());
				setting.setGuiji_sava(obj[16] == null ? "" : obj[16].toString());
				setting.setViewPower(obj[17] == null ? "" : obj[17].toString());
				setting.setViewTagid(obj[18] == null ? "" : obj[18].toString());
				setting.setViewAnckzb(obj[19] == null ? "" : obj[19].toString());
				setting.setOffView(obj[20] == null ? "" : obj[20].toString());
				setting.setAnckicon(obj[21] == null ? "" : obj[21].toString());
				setting.setGas_show(obj[22] == null ? "" : obj[22].toString());
				setting.setQuiet(obj[23] == null ? "" : obj[23].toString());
				setting.setReal_trak_time(obj[24] == null ? "" : obj[24].toString());
				setting.setReal_trak_color(obj[25] == null ? "" : obj[25].toString());
				setting.setGas_open(obj[26] == null ? "" : obj[26].toString());
				setting.setGas_port(obj[27] == null ? "" : obj[27].toString());
				setting.setGas_hz(obj[28] == null ? "" : obj[28].toString());
				setting.setRssid(obj[29] == null ? "" : obj[29].toString());
				setting.setBs_udp(obj[30] == null ? "" : obj[30].toString());
				setting.setOrigin_jingdu(obj[31] == null ?"" :obj[31].toString());
				setting.setOrigin_weidu(obj[32] == null ?"" :obj[32].toString());
				setting.setOrigin_jiaodu(obj[33] == null ?"" :obj[33].toString());
				setting.setFence_show(obj[34] == null ?"" :obj[34].toString());
				setting.setYulan_map(obj[35] == null ?"" :obj[35].toString());
				setting.setBaidu_j(obj[36] == null ?"" :obj[36].toString());
				setting.setBaidu_w(obj[37] == null ?"" :obj[37].toString());
				setting.setCs_udp(obj[38] == null ?"" :obj[38].toString());
				setting.setBaoliu10(obj[39] == null ?"" :obj[39].toString());
				setting.setBaoliu13(obj[40] == null ?"" :obj[40].toString());
				setting.setBaoliu14(obj[41] == null ?"" :obj[41].toString());
				setting.setBaoliu15(obj[42] == null ?"" :obj[42].toString());
				setting.setBaoliu16(obj[43] == null ?"" :obj[43].toString());
				setting.setBaoliu17(obj[44] == null ?"" :obj[44].toString());
				setting.setBaoliu19(obj[45] == null ?"" :obj[45].toString());
				setting.setBaoliu20(obj[46] == null ?"" :obj[46].toString());
				tb_systemList.add(setting);
			}
		}
		return tb_systemList;
	}
	
	@Transactional
	public int sysSetting_modify(tb_system setting) {
		String sql = null;
		Query query = null;
		sql = "UPDATE tb_system SET dataname=:dataname,datapass=:datapass,gui_ji=:gui_ji,bei_fen_di_zhi=:bei_fen_di_zhi,data_time=:data_time,title=:title,udpPort=:udpPort,udpAdress=:udpAdress,openudp=:openudp,"
				+ "know_tag_zu=:know_tag_zu,wifi_mdel=:wifi_mdel,tagZb=:tagZb,diskaoqing=:diskaoqing,viewAnckid=:viewAnckid,viewName=:viewName,tunlDw=:tunlDw,guiji_sava=:guiji_sava,viewPower=:viewPower,"
				+ "viewTagid=:viewTagid,viewAnckzb=:viewAnckzb,offView=:offView,anckicon=:anckicon,gas_show=:gas_show,real_trak_time=:real_trak_time,"
				+ "real_trak_color=:real_trak_color,gas_open=:gas_open,gas_port=:gas_port,gas_hz=:gas_hz,rssid=:rssid,fence_show=:fence_show,yulan_map=:yulan_map,baidu_j=:baidu_j,baidu_w=:baidu_w WHERE id= 1";
		query = this.em.createNativeQuery(sql);
		query.setParameter("dataname", setting.getDataname());
		query.setParameter("datapass", setting.getDatapass());
		query.setParameter("gui_ji", setting.getGui_ji());
		query.setParameter("bei_fen_di_zhi", setting.getBei_fen_di_zhi());
		query.setParameter("data_time", setting.getData_time());
		query.setParameter("title", setting.getTitle());
		query.setParameter("udpPort", setting.getUdpPort());
		query.setParameter("udpAdress", setting.getUdpAdress());
		query.setParameter("openudp", setting.getOpenudp());
		query.setParameter("know_tag_zu", setting.getKnow_tag_zu());
		query.setParameter("wifi_mdel", setting.getWifi_mdel());
		query.setParameter("tagZb", setting.getTagZb());
		query.setParameter("diskaoqing", setting.getDiskaoqing());
		query.setParameter("viewAnckid", setting.getViewAnckid());
		query.setParameter("viewName", setting.getViewName());
		query.setParameter("tunlDw", setting.getTunlDw());
		query.setParameter("guiji_sava", setting.getGuiji_sava());
		query.setParameter("viewPower", setting.getViewPower());
		query.setParameter("viewTagid", setting.getViewTagid());
		query.setParameter("viewAnckzb", setting.getViewAnckzb());
		query.setParameter("offView", setting.getOffView());
		query.setParameter("anckicon", setting.getAnckicon());
		query.setParameter("gas_show", setting.getGas_show());
//		query.setParameter("quiet", setting.getQuiet());
		query.setParameter("real_trak_time", setting.getReal_trak_time());
		query.setParameter("real_trak_color", setting.getReal_trak_color());
		query.setParameter("gas_open", setting.getGas_open());
		query.setParameter("gas_port", setting.getGas_port());
		query.setParameter("gas_hz", setting.getGas_hz());
		query.setParameter("rssid", setting.getRssid());
		query.setParameter("fence_show", setting.getFence_show());
		query.setParameter("yulan_map", setting.getYulan_map());
		query.setParameter("baidu_j", setting.getBaidu_j());
		query.setParameter("baidu_w", setting.getBaidu_w());
		int executeUpdate = query.executeUpdate();
		return executeUpdate;
	}
	
	@Transactional
	public int sysSetting_modifya(tb_system setting) {
		String sql = null;
		Query query = null;
		sql = "UPDATE tb_system SET udpAdress=:udpAdress,baoliu13=:baoliu13,baoliu14=:baoliu14,baoliu15=:baoliu15,real_trak_time=:real_trak_time,fence_show=:fence_show,viewAnckid=:viewAnckid,baoliu16=:baoliu16,baoliu17=:baoliu17,yulan_map=:yulan_map,baoliu20=:baoliu20 WHERE id= 1";
		cs.tb_caozuo("tb_system", 3);
		query = this.em.createNativeQuery(sql);
		query.setParameter("udpAdress", setting.getUdpAdress());
		query.setParameter("baoliu20", setting.getBaoliu20());
		query.setParameter("baoliu13", setting.getBaoliu13());
		query.setParameter("baoliu14", setting.getBaoliu14());
		query.setParameter("baoliu15", setting.getBaoliu15());
		query.setParameter("real_trak_time", setting.getReal_trak_time());
		query.setParameter("fence_show", setting.getFence_show());
		query.setParameter("viewAnckid", setting.getViewAnckid());
		query.setParameter("baoliu16", setting.getBaoliu16());
		query.setParameter("baoliu17", setting.getBaoliu17());
		query.setParameter("yulan_map", setting.getYulan_map());
		
		int executeUpdate = query.executeUpdate();
		return executeUpdate;
	}
	
	public List<tb_achor> getLayer() {
		String sql = null;
		Query query = null;
		sql = "SELECT DISTINCT layer,zu FROM tb_achor";
		query = this.em.createNativeQuery(sql);
		List resultList = query.getResultList();
		List<tb_achor> layerList = new ArrayList<tb_achor>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_achor layer = new tb_achor();
				layer.setLayer(obj[0] == null ? "" : obj[0].toString());
				layerList.add(layer);
			}
		}
		return layerList;
	}
	
	public List<tb_achor> getGroup() {
		String sql = null;
		Query query = null;
		sql = "SELECT DISTINCT layer,zu FROM tb_achor";
		query = this.em.createNativeQuery(sql);
		List resultList = query.getResultList();
		List<tb_achor> zuList = new ArrayList<tb_achor>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_achor zu = new tb_achor();
				zu.setZu(obj[1] == null ? "" : obj[1].toString());
				zuList.add(zu);
			}
		}
		return zuList;
	}
	
	@Transactional
	public int algorithmConfiguration_modify(tb_suanfa suanfa) {
		String sql = null;
		Query query = null;
		sql = "UPDATE tb_suanfa SET sufa=:sufa,anchor_num=:anchor_num,jieji=:jieji,xinhao_qiangdu=:xinhao_qiangdu,youxiao_qu=:youxiao_qu,wuxiao_qu=:wuxiao_qu,"
				+ "caiyang_guolv=:caiyang_guolv,caiyang_canshu=:caiyang_canshu,kuansong_model=:kuansong_model,pingmian_buju=:pingmian_buju,dunjiao=:dunjiao,bujuqu_youxiao=:bujuqu_youxiao,"
				+ "bujuqu_youxian=:bujuqu_youxian WHERE floor=:floor AND zu=:zu";
		cs.tb_caozuo("tb_suanfa", 3);
		query = this.em.createNativeQuery(sql);
		query.setParameter("floor", suanfa.getFloor());
		query.setParameter("zu", suanfa.getZu());
		query.setParameter("sufa", suanfa.getSufa());
		query.setParameter("anchor_num", suanfa.getAnchor_num());
		query.setParameter("jieji", suanfa.getJieji());
		query.setParameter("xinhao_qiangdu", suanfa.getXinhao_qiangdu());
		query.setParameter("youxiao_qu", suanfa.getYouxiao_qu());
		query.setParameter("wuxiao_qu", suanfa.getWuxiao_qu());
		query.setParameter("caiyang_guolv", suanfa.getCaiyang_guolv());
		query.setParameter("caiyang_canshu", suanfa.getCaiyang_canshu());
		query.setParameter("kuansong_model", suanfa.getKuansong_model());
		query.setParameter("pingmian_buju", suanfa.getPingmian_buju());
		query.setParameter("dunjiao", suanfa.getDunjiao());
		query.setParameter("bujuqu_youxiao", suanfa.getBujuqu_youxiao());
		query.setParameter("bujuqu_youxian", suanfa.getBujuqu_youxian());
		int executeUpdate = query.executeUpdate();
		return executeUpdate;
	}
	
	public List<tb_tag> getLabel() {
		String sql = null;
		Query query = null;
		sql = "SELECT id,tag_id,state,power,status,gaodu,sudu,pinglv,sleep_satus,sleep_time,gongfang,dong_status,version,addtime,imu FROM tb_tag";
		query = this.em.createNativeQuery(sql);
		List resultList = query.getResultList();
		List<tb_tag> tb_tagList = new ArrayList<tb_tag>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_tag tag = new tb_tag();
				tag.setId((int) obj[0]);
				tag.setStatus(obj[4] == null ? "" : obj[4].toString());
				tag.setTag_id(obj[1] == null ? "" : obj[1].toString());
				tag.setState(obj[2] == null ? "" : obj[2].toString());
				tag.setPower(obj[3] == null ? "" : obj[3].toString());
				tag.setGaodu(obj[5] == null ? "" : obj[5].toString());
				tag.setSudu(obj[6] == null ? "" : obj[6].toString());
				tag.setPinglv(obj[7] == null ? "" : obj[7].toString());
				tag.setVersion(obj[12] == null ? "" : obj[12].toString());
				tag.setAddtime(obj[13] == null ? "" : obj[13].toString());
				tb_tagList.add(tag);
			}
		}
		return tb_tagList;
	}
	
	@Transactional
	public int baowen_add(tb_yuan_shi_bao_wen yuanshibaowen) {
		String sql = null;
		Query query = null;
		sql = "INSERT INTO tb_baowen (ip,str,addtime) VALUES((SELECT udpAdress FROM tb_system WHERE id = 1),:yuanshibaowen,now())";
		cs.tb_caozuo("tb_baowen", 1);
		query = this.em.createNativeQuery(sql);
		query.setParameter("yuanshibaowen", yuanshibaowen.getStr());
		int executeUpdate = query.executeUpdate();
		return executeUpdate;
	}
	
	public List<tb_suanfa> searchAlgorithmConfiguration(String input) {
		String sql = null;
		Query query = null;
		sql = "SELECT sufa,anchor_num,jieji,xinhao_qiangdu,youxiao_qu,wuxiao_qu,caiyang_guolv,caiyang_canshu,kuansong_model,pingmian_buju,dunjiao,bujuqu_youxiao,bujuqu_youxian,floor,zu FROM tb_suanfa WHERE anchorid = :anchorid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("anchorid", input);
		List resultList = query.getResultList();
		List<tb_suanfa> tb_suanfaList = new ArrayList<tb_suanfa>();
		if (resultList.size() > 0) {
			for (int i = 0; i < resultList.size(); i++) {
				Object[] obj = (Object[]) resultList.get(i);
				tb_suanfa suanfa = new tb_suanfa();
				suanfa.setSufa(obj[0] == null ? "" : obj[0].toString());
				suanfa.setAnchor_num(obj[1] == null ? "" : obj[1].toString());
				suanfa.setZu(obj[14] == null ? "" : obj[14].toString());
				tb_suanfaList.add(suanfa);
			}
		}
		return tb_suanfaList;
	}
	
	@Transactional
	public int guiling() {
		String sql = null;
		Query query = null;
		sql = "UPDATE tb_system SET baoliu10=null WHERE id = 1";
		cs.tb_caozuo("tb_suanfa", 3);
		query = this.em.createNativeQuery(sql);
		int executeUpdate = query.executeUpdate();
		return executeUpdate;
	}
}