package tag;
import java.math.BigInteger;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import BaoWen.Dell_55AA0A;
import DataBase.DatabaseManagement;
import Judge.JugeNumber;
import Method.GetNowTime;
import Method.InsertData;
import PbuliClass.ShowMessage;
import PbuliClass.Systems;
import engbs.engine_do;
import fence.kaoqing.Dell_tbreallkaoqing;
import home.Open_soft_dialog;
import person.Person;
import person.person_Dell;
import tagpower.Dell_tagpower;
import tbDataModel.TbWaring;
import tbDataModel_Dell.Dell_ReallPoint;
import tbDataModel_Dell.Dell_tag_gas_jiaozhun_value;
import tbDataModel_Dell.Department_Dell;
import tbDataModel_Dell.Tb_Warnig_Dell;

@SuppressWarnings("rawtypes")
public class 	Tag_Dell {
	static Vector<Tag> tag_vector = new Vector<Tag>();// ±êÇ©µÄ¼¯ºÏ
	static String tagon = "image/icon/tagon.png";
	static String tagoff = "image/icon/tagoff.png";
	static boolean suidaomoshi=Systems.sys().getTunlDw().equals("1");

	/** »ñÈ¡Êý¾Ý¿âÖÐËùÓбêÇ© */
	static {
		Open_soft_dialog.addara("¼ÓÔØtb_tag");
		String sql = "select * from tb_tag order by tag_id ASC ";
		Iterator iterator = DatabaseManagement.serch(sql).iterator();
		while (iterator.hasNext()) {// µü´úÆ÷´æÔÚÔªËØ
			List info = (List) iterator.next();// ½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			Tag tag = new Tag();
			tag.setXuhao((String) info.get(0));
			String tagid=(String)info.get(1);
			tag.setTag_id(tagid);
			tag.setTag_name((String) info.get(2));
			String power=(String) info.get(3);
			tag.setTag_power(power);
			tag.setTag_state("0");
			tag.setTag_pos_z((String) info.get(5));			
			String sulv=(String) info.get(6);//ËÙÂÊ
			String tagspeed_limit=sulv;
			if(sulv.equals("ÎÞ") || sulv.equals("")) {
				tagspeed_limit="1000";
			}
			tag.setTag_sulv(tagspeed_limit);
			String hz=(String) info.get(7);
			if(hz.equals("0.1")) {
				tag.setDoublehz(0.1);
				hz="1";
			}
			int hzint=Integer.parseInt(hz);

			if(hzint==0 || hzint<0) {
				ShowMessage.zidingyi_24(tagid+"±êǩƵÂʲ»ÄÜΪ0");
			}

			tag.setTag_pinglv(hz);
			tag.setSleep_satus((String) info.get(8));
			tag.setSleep_time((String) info.get(9));
			tag.setGongfang((String) info.get(10));
			tag.setDong_status((String) info.get(11));
			String vrs=(String) info.get(12);
			if(vrs==null || vrs.equals("null")||vrs.equals("-1")) {
				vrs="δ֪";
			}
			tag.setVersoin(vrs);
			tag.setTag_greattime((String) info.get(13));
			tag.setImu((String) info.get(14));
			String gpsstate=(String) info.get(15);
			tag.setSleep_satus("-1");//ÉèÖñêÇ©³õʼ״̬
			int gps_state=0;
			if(gpsstate !=null ) {
				if(gpsstate.equals("1")) {
					gps_state=1;
				}
			}
			tag.setGps_state(gps_state);
			// ³õʼ»¯½«±êÇ©µÍµçÁ¿¸æ¾¯×´Ì¬ÉèÖÃΪ0
			tag.setTag_floor("0");
			//±êÇ©µÄʵʱ¸ß¶È
			String a=(String) info.get(5);			
			int tagz=150;
			if(a.length()>2) {
				if(!JugeNumber.isDigit(a)) {
					a="150";
				}
				tagz=Integer.parseInt((a));
			}			
			if(Dell_tagpower.get_tag(tagid)==null) {
				Dell_tagpower.add(tagid, (String) info.get(2),(String) info.get(7), (String) info.get(3));
			}

			tag.setTag_z(tagz);

			//À¡Ïß³¤¶È
			String baoliu3=(String) info.get(19);
			if(baoliu3==null) {
				tag.setBaoliu3(0);
			}else{
				int b3=Integer.parseInt(baoliu3);
				tag.setBaoliu3(b3);
			}

			String type=(String) info.get(27);//±êÇ©ÀàÐÍ
			if(type==null) {
				type="ϵͳĬÈÏ";
			}
			tag.setTagtype(type);
			tag.setLixian(3);
			tag.setXiumian(3);
			tag.setJingzhi(3);
			tag.setTag_sos("3");
			tag.setAlertsucc(0);
			tag.setWuxiaoquyu(0);
			tag.setNowzhuceanchor("0");//±êÇ©µ±Ç°ÉÏÀ´µÄ×¢²á»ùÕ¾
			tag.setTag_power("-1");
			tag.setDong_status("-1");
			Person person=person_Dell.get_Person(tagid);
			if(person==null) {
				person_Dell.add_person(tagid, "ϵͳĬÈÏ", (String) info.get(2), "ÄÐ","",sulv,type);
			}else {
				person.setTagneedhz(hzint);//±êÇ©ÐèÒªµÄƵÂÊ
			}
			tag_vector.add(tag);

		}
	}

	/** ͨ¹ý±êÇ©id»ñȡijһ¸ö±êÇ©¶ÔÏó */
	public static Tag get_tag(String tagid) {
		Tag tag = null;
		if (tag_vector.size() != 0) {
			Iterator<Tag> it = tag_vector.iterator();
			while (it.hasNext()) {
				Tag tag1 = it.next();
				String idtag = tag1.getTag_id();
				if (tagid.equals(idtag)) {
					tag = tag1;
					break;
				}
			}
		}

		return tag;
	}

	/** ͨ¹ýÐÕÃûÕÒµ½±êÇ©ID */
	public static String get_tagid(String name) {
		String tagid = "";
		int i = 0;
		if (tag_vector.size() != 0) {
			Iterator<Tag> it = tag_vector.iterator();
			while (it.hasNext()) {
				Tag tag1 = it.next();
				String name1 = tag1.getTag_name();
				if (name.equals(name1)) {
					tagid = tag1.getTag_id();
					i++;
				}
			}
		}

		if (i != 1) {
			ShowMessage.zidingyi_24("ÐÕÃû" + name + "´æÔÚÖØÃû" + i + "¸öÇëÊäÈëIDºÅ²éѯ£¡");
			tagid = "´æÔÚÖØÃû";
		}
		return tagid;
	}

	/**
	 * µ¼Èë±êÇ©µÄʱºòÏò±êÇ©¼¯ºÏÌí¼Ó±êÇ©
	 * 
	 * @param tagid      ±êÇ©id
	 * @param state      ±êÇ©°ó¶¨µÄ¶ÔÏó
	 * @param tag_pos_z  ±êÇ©Åå´÷¸ß¶È
	 * @param tag_pinglv ±êÇ©µÄƵÂÊ
	 * @param String     tag_sulv ±êÇ©µÄËÙÂÊ
	 */
	public static void add_tag_from_ecxel(
			String tagid, 
			String state, 
			String tag_pos_z, 
			String tag_pinglv,
			String tag_sulv) {
		if (get_tag(tagid) == null) {
			String power = "100";
			String tatus = "ÔÚÏß";
			Tag newtag = new Tag();
			newtag.setTag_id(tagid);
			newtag.setTag_name(state);
			newtag.setTag_pos_z(tag_pos_z);
			newtag.setTag_pinglv(tag_pinglv);
			newtag.setTag_power(power);
			newtag.setTag_state(tatus);
			newtag.setTag_sulv(tag_sulv);
			newtag.setTag_greattime(GetNowTime.now());
			tag_vector.add(newtag);
			person_Dell.add_person(tagid, "ϵͳĬÈÏ", state, "ÄÐ", "",tag_sulv,"ϵͳĬÈÏ");
			if(suidaomoshi) {
				Dell_tbreallkaoqing.add_in_data(tagid);
			}
		}
	}

	/** ¸Ä±ä±êÇ©µÄ״̬ÊÇ·ñÔÚÏß */
	public static void set_tagstatus(String tagid, String status, String power) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_state(status);

			String[] ziduan = { "status", "power", "tag_id" };
			String[] zhi = { status, power, tagid };
			DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
		}
	}

	/**Ð޸ıêÇ©µÄ״̬ÊÇ·ñÔÚÏß*/
	public static void alert_online(String tagid) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_state("1");
		}
	}

	/**Ð޸ıêǩ״̬ºÍÊý¾Ý¿âÎÞ¹Ø*/
	public static void set_tagstatus2(String tagid, String status, String power) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_state(status);
			get_tag(tagid).setTag_power(power);
		}
	}

	/** ±êÇ©ÀëÏß */
	public static void tag_offline(String tagid, String status) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_state(status);
			String[] ziduan = { "status", "tag_id" };
			String[] zhi = { status, tagid };
			DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
			ziduan = null;
			zhi = null;
		}
	}

	/** »ñÈ¡ËùÓбêÇ©µÄidµÄ¼¯ºÏ */
	public static String[] get_tag_str() {
		String[] tagsring = new String[tag_vector.size() + 1];
		tagsring[0] = "Ñ¡Ôñ±êÇ©";
		if (tag_vector.size() != 0) {
			Iterator<Tag> it = tag_vector.iterator();
			int i = 1;
			while (it.hasNext()) {
				Tag tag1 = it.next();
				tagsring[i] = tag1.getTag_id();
				i++;
			}
		}

		return tagsring;
	}

	/** ÐÞ¸ÄËùÓбêÇ©µÄƵÂÊ */
	public static void alert_all_tag_hz(String hz) {
		StringBuffer updateSQL = new StringBuffer("UPDATE tb_tag SET pinglv='" + hz + "'");
		if (DatabaseManagement.update(updateSQL.toString()) != 0) {
			Iterator<Tag> it = tag_vector.iterator();
			while (it.hasNext()) {
				it.next().setTag_pinglv(hz);
			}
		}
	}

	/** Ð޸ıêÇ©ÐÅÏ¢ */
	public static void alert_tag(String tagid, String gaodu, String sudu) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_id(tagid);
			get_tag(tagid).setTag_pos_z(gaodu);
			get_tag(tagid).setTag_sulv(sudu);
		}
	}

	/** Ð޸ıêǩƵÂÊ */
	public static void alert_taghz(String tagid,String pinglv) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_id(tagid);
			get_tag(tagid).setTag_pinglv(pinglv);
		}
	}

	/** Ð޸ļ¯ºÏÖÐËùÓеıêÇ©ÐÅÏ¢ */
	public static void alert_all(String gaodu, String sudu, String pinglv) {
		if (tag_vector.size() != 0) {
			for (int i = 0; i < tag_vector.size(); i++) {
				Tag tag = tag_vector.get(i);
				tag.setTag_pinglv(pinglv);
				tag.setTag_sulv(sudu);
				tag.setTag_pos_z(gaodu);
			}
		}
	}

	/** Ð޸ļ¯ºÏÖÐËùÓеıêǩƵÂÊ */
	public static void alert_hz( String pinglv) {
		if (tag_vector.size() != 0) {
			for (int i = 0; i < tag_vector.size(); i++) {
				Tag tag = tag_vector.get(i);
				tag.setTag_pinglv(pinglv);
			}
		}
	}


	/** Ð޸ıêÇ©ÐÅÏ¢ */
	public static void alert_tag2(
			String tagid, 
			String name, 
			String gaodu, 
			String sudu, 
			String pinglv,
			String kuixian,
			String tagtype) {
		if (get_tag(tagid) != null) {
			int baoliu3=Integer.parseInt(kuixian);
			get_tag(tagid).setTag_id(tagid);
			get_tag(tagid).setTag_name(name);
			get_tag(tagid).setTag_pos_z(gaodu);
			get_tag(tagid).setTag_sulv(sudu);
			get_tag(tagid).setTag_pinglv(pinglv);
			get_tag(tagid).setBaoliu3(baoliu3);
			get_tag(tagid).setTagtype(tagtype);
			double hz=Double.parseDouble(pinglv);
			get_tag(tagid).setDoublehz(hz);
			person_Dell.alert_person_name(tagid, name,tagtype);
		}
	}

	/** Ôö¼ÓÒ»¸ö±êÇ©¶ÔÏóͬʱÊý¾Ý¿âÒ²Ôö¼ÓÌõÊý¾Ý */
	public static void add_tag(
			String tagid, 
			String name, 
			String gaodu, 
			String sudu, 
			String pinglv,
			int kuixian,
			String type,
			int datafrom) {
		if (get_tag(tagid) == null) {
			Tag newtag = new Tag();
			newtag.setTag_id(tagid);
			newtag.setTag_name(name);
			newtag.setTag_pos_z(gaodu);
			newtag.setTag_sulv(sudu);
			newtag.setTag_pinglv(pinglv);
			newtag.setTag_power("δ֪");
			newtag.setTag_greattime(GetNowTime.now());
			newtag.setTag_state("1");
			newtag.setAlertsucc(0);			
			newtag.setLixian(3);
			newtag.setXiumian(3);
			newtag.setJingzhi(3);
			newtag.setTag_sos("3");
			newtag.setAlertsucc(0);
			newtag.setWuxiaoquyu(0);
			newtag.setBaoliu3(kuixian);
			newtag.setTagtype(type);
			String kx=String.valueOf(kuixian);//À¡ÏßÎó²î	
			person_Dell.add_person(tagid, "ϵͳĬÈÏ",name, "ÄÐ", " ",sudu,type);	
			if(datafrom==1) {//Èç¹ûÊý¾ÝÀ´Ô´bs
				String[] ziduan = { "tag_id", "state", "power", "status", "gaodu", "sudu", "pinglv", "baoliu3", "type","Addtime" };
				String[] zhi = { tagid, name, "δ֪", "ÔÚÏß", gaodu, sudu, pinglv, kx,type,GetNowTime.now() };
				DatabaseManagement.insertfast("tb_tag", ziduan, zhi);
			}else {
				String[] ziduan = { "tag_id", "state", "power", "status", "gaodu", "sudu", "pinglv", "baoliu3","type", "Addtime" };
				String[] zhi = { tagid, name, "δ֪", "ÔÚÏß", gaodu, sudu, pinglv, kx,type,GetNowTime.now() };
				DatabaseManagement.insertfast("tb_tag", ziduan, zhi);
			}				
			tag_vector.add(newtag);
			Dell_ReallPoint.add_tag_in_reallpint_vector(tagid);
			Dell_tagpower.add(tagid, name,pinglv, "0");
			if(suidaomoshi) {
				Dell_tbreallkaoqing.add_in_data(tagid);
			}
		}

	}

	/** Ôö¼ÓÒ»¸ö±êÇ©´øÆøѹ¶ÔÏó */
	public static void add_gastag(String tagid,String gaodu) {
		if (get_tag(tagid) == null) {
			Tag newtag = new Tag();
			newtag.setTag_id(tagid);
			newtag.setTag_name("Èýά²Î¿¼");
			newtag.setBaoliu1("1");
			newtag.setTag_sulv("10");
			newtag.setTag_pinglv("1");
			newtag.setTag_power("100");
			newtag.setTag_greattime(GetNowTime.now());
			String[] ziduan = { "tag_id", "state", "power", "status", "gaodu", "sudu", "pinglv","baoliu1", "Addtime" };
			String[] zhi = { tagid, "Èýά²Î¿¼", "100", "ÔÚÏß", gaodu, "10", "1","1", GetNowTime.now() };
			DatabaseManagement.insertfast("tb_tag", ziduan, zhi);
			tag_vector.add(newtag);
		}

	}

	/** Ôö¼ÓÒ»¸ö±êÇ©¶ÔÏóºÍÊý¾Ý¿âÎÞ¹Ø */
	public static void add_tag2(String tagid, String name, String gaodu, String sudu, String pinglv) {
		if (get_tag(tagid) == null) {
			Tag newtag = new Tag();
			newtag.setTag_id(tagid);
			newtag.setTag_name(name);
			newtag.setTag_pos_z(gaodu);
			newtag.setTag_sulv(sudu);
			if(pinglv.equals("0")) {
				ShowMessage.zidingyi_24(tagid+"±êǩƵÂʲ»ÄÜΪ0");
				return;
			}
			newtag.setTag_pinglv(pinglv);
			newtag.setTag_power("100");
			newtag.setTag_greattime(GetNowTime.now());
			person_Dell.add_person2(tagid, "ϵͳĬÈÏ", name, "ÄÐ", " ");
			tag_vector.add(newtag);
		}

	}


	/**ÐÞ¸ÄGPS״̬*/
	public static void alert_gps_state(String tagid,int state) {
		if(get_tag(tagid) !=null) {
			get_tag(tagid).setGps_state(state);
			String[] ziduan = {"gps_state", "tag_id" };
			String[] zhi = {String.valueOf(state) ,tagid};
			DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
		}

	}

	/** ÈËÔ±µ¼ÈëµÄʱºòµ÷ÓÃÓÃÓÚÔö¼Ó±êÇ©¡¢²¿ÃÅ¡¢ÈËÔ± */
	public static boolean addtag_person_excel_into(
			String tagid, 
			String name, 
			String bumen, 
			String sex, 
			String phone) {
		boolean succ = false;
		Department_Dell.add_bumen_fromperson(bumen);
		if (get_tag(tagid) == null) {// Èç¹û±êÇ©²»´æÔÚ
			Tag newtag = new Tag();
			newtag.setTag_id(tagid);
			tag_vector.add(newtag);

			String[] ziduan = { "tag_id", "state", "power", "status", "gaodu", "sudu", "pinglv", "Addtime" };
			String[] zhi = { tagid, name, "100", "ÔÚÏß", "150", "100000", "1", GetNowTime.now()};
			DatabaseManagement.insertfast("tb_tag", ziduan, zhi);

			String p_image="image/targeticon/default.png";
			String[]  ziduan2= {
					"p_name",     
					"p_tagid",  
					"p_sex",
					"p_minzu",
					"p_phone",
					"p_department",
					"p_x",
					"p_y",     
					"p_floor",
					"p_sos",
					"p_online",
					"p_power",
					"p_kaoqing",
					"p_fence",
					"p_image",
			"p_addtiem"};

			String[] zhi2= {
					name,     
					tagid,  
					sex,
					"ºº",
					phone,
					bumen,
					"0",
					"0",     
					"0",
					"0",
					"0",
					"100",
					"0",
					"0",
					p_image,
					GetNowTime.now()
			};
			DatabaseManagement.insertfast("tb_person", ziduan2, zhi2);
			if(suidaomoshi) {
				Dell_tbreallkaoqing.add_in_data(tagid);
			}
			succ = true;
		}
		return succ;
	}

	/** ¸Ä±ä±êÇ©µÄµçÁ¿×´Ì¬ */
	public static void set_tagpower(String tagid, String power) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_power(power);
			get_tag(tagid).setTag_state("1");
			get_tag(tagid).setTag_power_date(GetNowTime.now());
			int powerint = Integer.parseInt(power);
			alert_tag_low_power(tagid,powerint);
		}
	}

	/** ¸Ä±ä±êÇ©µÄµçÁ¿×´Ì¬ */
	public static void set_URTXTB(String tagid) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_state("1");
			get_tag(tagid).setTag_power_date(GetNowTime.now());
		}
	}

	/**
	 * Ð޸ıêÇ©µÄX,Y,Z×ø±ê
	 * 
	 * @param tagid ±êÇ©µÄid
	 * @param x ±êÇ©µÄx×ø±ê
	 * @param y ±êÇ©µÄY×ø±ê
	 * @param floor ±êÇ©ËùÔÚµÄÂ¥²ã
	 */
	public static void alert_xy_and_floor(String tagid, int x, int y,int z,String floor) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_pos_x(x);
			get_tag(tagid).setTag_pos_y(y);
			get_tag(tagid).setTag_z(z);//±êÇ©µÄʵʱ¸ß¶È
			get_tag(tagid).setTag_floor(floor);
		}

	}

	/**¸üбêǩ״̬ºÍʱ¼ä*/
	public static void tagstate(String tagid) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_state("1");
		}
	}

	/**¸üÐÂURT±êÇ©µÄʱ¼ä¡¢×´Ì¬¡¢°æ±¾¡¢µçÁ¿*/
	public static void tagstate3(String tagid,String versoin) {
		if (get_tag(tagid) != null) {
			get_tag(tagid).setTag_state("1");
			if(versoin==null) {
				versoin="δ֪";
			}
			get_tag(tagid).setVersoin(versoin);
		}
	}

	/** ɾ³ýij¸ö±êÇ© */
	public static void remove_tag(String tagid) {
		if (get_tag(tagid) != null) {
			tag_vector.remove(get_tag(tagid));
			Dell_tagpower.delte(tagid);
			person_Dell.remove_person_and_database(tagid);	
			Dell_tag_gas_jiaozhun_value.delete_tag_gas_jiaozhun_value(tagid, 1);
			if(suidaomoshi) {
				Dell_tbreallkaoqing.delete_data(tagid);
			}
			String deleteSql="DELETE FROM tb_tag WHERE tag_id='"+tagid+"'";
			DatabaseManagement.update(deleteSql);
		}
	}

	/** ɾ³ý¼¯ºÏÖÐËùÓеıêÇ© */
	public static void removeall_tag() {
		if (tag_vector.size() != 0) {
			tag_vector.removeAllElements();
			Dell_tagpower.delteall();
			if(suidaomoshi) {
				Dell_tbreallkaoqing.deleteall();
			}
		}
	}

	public static Vector<Tag> getTag_vector() {
		return tag_vector;
	}

	/** ËÑË÷ij¸ö±êÇ© */
	public static Vector<Tag> serchtag(String name) {

		Vector<Tag> tagvect = new Vector<Tag>();
		if (tag_vector.size() != 0) {
			Iterator<Tag> it = tag_vector.iterator();
			while (it.hasNext()) {
				Tag tag1 = it.next();
				String idtag = tag1.getTag_id();
				String name1 = tag1.getTag_name();
				if (idtag.equals(name) || name1.equals(name)) {
					tagvect.add(tag1);
				}
			}
		}
		return tagvect;

	}


	/** »ñÈ¡±êÇ©×é */
	public static Vector<String> tagzu() {
		Vector<String> zu = new Vector<String>();
		zu.add("FFFF");
		zu.add("0000");
		return zu;
	}

	/** »ñÈ¡ËùÓбêÇ©µÄ¼¯ºÏ */
	public static String[] GetTagAllstr() {
		int size = tag_vector.size() + 1;
		String[] tagall = new String[size];
		tagall[0] = "ËùÓбêÇ©";
		if (size > 1) {
			for (int i = 0; i < size - 1; i++) {
				tagall[i + 1] = tag_vector.get(i).getTag_id();
			}
		}

		return tagall;
	}

	/** 16½øÖÆתΪ10½øÖÆ */
	public static int decodeHEX(String hexs) {
		BigInteger bigint = new BigInteger(hexs, 16);
		int numb = bigint.intValue();
		return numb;

	}

	public static String getTagon() {
		return tagon;
	}

	public static String getTagoff() {
		return tagoff;
	}

	/** Ð޸ıêÇ©µÄ°æ±¾¡¢ÆµÂÊ¡¢ */
	public static void alert_tag(
			String tagid, 
			String version, 
			String move_open,
			String sleep_open,
			String button, 
			int gonglv, 
			int speed, // ¼ÓËÙ¶ÈãÐÖµ
			int sleep_time, 
			int power,
			int gas) {

		Tag tag=get_tag(tagid);
		if ( tag!= null) {
			tag.setVersoin(version);
			tag.setGongfang(String.valueOf(gonglv));
			tag.setSleep_satus(sleep_open);	
			tag.setSleep_time(String.valueOf(sleep_time));
			tag.setImu(String.valueOf(speed));
			tag.setDong_status(move_open);
			tag.setTag_power(String.valueOf(power));
			tag.setTag_state("1");
			String[] ziduan = { "sleep_satus", "sleep_time", "gongfang", "dong_status", "version", "imu","tag_id" };
			String[] zhi = { sleep_open, String.valueOf(sleep_time), String.valueOf(gonglv),
					move_open, version, String.valueOf(speed), tagid };
			DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
		}

	}

	/**ÐÞ¸ÄURTµÄ²ÎÊý*/
	public static void alert_urtcanshu(
			String tagid,
			String imujingzhitime,
			String hz,
			String gps_open, 
			String move_open, 
			String sleep_open, 
			String gonglv,
			String speed,
			String sleep_time,
			String uwb_open,
			String jiaozhun) {

		Tag tag=get_tag(tagid);
		if ( tag!= null) {
			int p1=1000/Integer.parseInt(hz);	
			int gpsstate=Integer.parseInt(gps_open);
			tag.setGongfang(gonglv);
			tag.setJinghzi_time(imujingzhitime);
			tag.setTag_pinglv(p1+"");
			tag.setSleep_satus(sleep_open);	
			tag.setSleep_time(sleep_time);
			tag.setImu(speed);
			tag.setDong_status(move_open);
			tag.setTag_state("1");
			tag.setGps_state(gpsstate);
			String[] ziduan = {"gps_state","sleep_satus", "sleep_time", "gongfang", "dong_status", "imu","tag_id" };
			String[] zhi = {gps_open,sleep_open, sleep_time,gonglv,move_open,speed, tagid };
			DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
		}

	}


	/** Ð޸ıêÇ©µÄµÍµçÁ¿±¨¾¯×´Ì¬ */
	public static void alert_tag_low_power(String tagid, int power) {
		Person person = person_Dell.get_Person(tagid);
		if(person==null){
			return;
		}
		String p_power_wanig = person.getP_power_wanig();
		if(power<15) {
			if (p_power_wanig==null){
				p_power_wanig="-1";
			}
			if (p_power_wanig.equals("0")){
				return;
			}else {
				person.setP_power_wanig("0");
			}
		}

	}

	/**Ð޸ıêÇ©°ó¶¨µÄÐÕÃû*/
	public static void alert_tag_name(String tagid,String tag_name) {
		if(get_tag(tagid) !=null) {
			get_tag(tagid).setTag_name(tag_name);			
			String[] ziduan = {"state","addtime","tag_id" };
			String[] zhi = { tag_name, GetNowTime.now(),tagid };
			DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
		}

	}

	/**¹Ì¶¨Ê±¼ä¸üбêÇ©µçÁ¿Êý¾Ý¿â±í
	 * tagid   
	 * power   
	 * time                 
	 * hz      
	 * name**/
	public static void gengxin_database_tag_power() {
		Vector<Person>  prvc=person_Dell.getPerson_vector();
		int size=prvc.size();
		if(size==0) {
			return;
		}
		StringBuffer sql=new StringBuffer("UPDATE tb_tagpower SET ");
		StringBuffer sql2=new StringBuffer("UPDATE tb_person SET ");		
		Vector<String> vp_tagid=new Vector<String>();
		Vector<String> vp_name=new Vector<String>();
		Vector<String> vp_time=new Vector<String>();
		Vector<String> vp_hz=new Vector<String>();
		Vector<String> vp_power=new Vector<String>();
		for(int i=0;i<size;i++) {	
			Person pr=prvc.get(i);
			String tagid=pr.getP_tagid();
			vp_tagid.add(tagid);
			String tagname=pr.getP_name();
			vp_name.add(tagname);
			String pw=pr.getP_power();			
			int pwr=0;
			if(pw ==null) {
				pw="δ֪";
			}else {
				if(JugeNumber.isDigit(pw)) {
					pwr = Integer.parseInt(pw);
					if (pwr > 100) {
						pw = "100";
						pwr = 100;
					}
					String powerstate = pr.getP_power_wanig();
					if (pwr > 15) {

						pr.setP_power_wanig("0");
						String sqlpowerwarning = "update tb_person set p_power_wanig='0' where p_tagid='" + tagid + "';";
						DatabaseManagement.update(sqlpowerwarning);
						if (Tb_Warnig_Dell.get_tbwarning(tagid) != null) {
							TbWaring tbwarning = Tb_Warnig_Dell.get_tbwarning(tagid);
							tbwarning.setStatus("ÒÑ´¦Àí");
							String sqlpwr = "UPDATE tb_warning SET STATUS='ÒÑ´¦Àí',baoliu1='" + pwr + "' WHERE objectid='" + tagid + "' AND `type`='µÍµçÁ¿' AND `status`='δ´¦Àí';";
							if (Tb_Warnig_Dell.get_tbwarning(tagid) != null) {
								DatabaseManagement.update(sqlpwr);

							}
						}
					} else {
						if (powerstate.equals("0")) {//±êÇ©´¦Óڵ͵çÁ¿
							pr.setP_power_wanig("1");
							String sqlpowerwarning = "update tb_person set p_power_wanig='1' where p_tagid='" + tagid + "';";
							DatabaseManagement.update(sqlpowerwarning);
							InsertData.porInsertTbWarning(tagid, "δ´¦Àí", String.valueOf(pwr));//½«¸æ¾¯¼Ç¼³öÈëµ½Êý¾Ý¿â
						}
					}
				}
			}


			vp_power.add(String.valueOf(pwr));			
			int hz=pr.getHz();			
			vp_hz.add(hz+"");			
			vp_time.add(pr.getP_addtiem());
		}
		//¸üÐÂʵʱλÖÃÊý¾Ý±íx £»y £»z £»layer£»time 
		sql.append(engine_do.getinfo(vp_name,"name",vp_tagid,"tagid")+" , ");
		sql.append(engine_do.getinfo(vp_time,"time",vp_tagid,"tagid")+" , ");
		sql.append(engine_do.getinfo(vp_hz,"hz",vp_tagid,"tagid")+" , ");
		sql.append(engine_do.getinfo(vp_power,"power",vp_tagid,"tagid")+"  ");
		sql.append(engine_do.getlast(vp_tagid,"tagid"));
		//¸üÐÂÊý¾Ý¿â
		DatabaseManagement.update(sql.toString());

		sql2.append(engine_do.getinfo(vp_power,"p_power",vp_tagid,"p_tagid")+"  ");
		sql2.append(engine_do.getlast(vp_tagid,"p_tagid"));
		DatabaseManagement.update(sql2.toString());



	}

	/**»ñÈ¡ËùÓÐÔÚÏß±êÇ©²¢ÇÒÆøѹ¼Æ״̬Ϊȫ²¿Ð޸ĵļ¯ºÏ*/
	public static Vector<Tag> tagonline_and_gasstate1(int gasstate0,String onlie) {
		Vector<Tag> vec=new Vector<Tag>();
		int size=tag_vector.size();
		for(int i=0;i<size;i++) {
			Tag tag=tag_vector.get(i);
			String oline=tag.getTag_state();
			int gasstate=tag.getGas_alert_state();
			if(gasstate==gasstate0 && onlie.equals(oline)) {
				vec.add(tag);
			}
		}
		return vec;

	}

	/**½«±êÇ©µÄµçÁ¿×´Ì¬½«±êÇ©µçÁ¿Ð´ÈëÀúÊ·µçÁ¿Êý¾Ý¿â*/
	public static void history_power() {
		Vector<Person> person_vector=person_Dell.getPerson_vector();
		int size=person_vector.size();
		for(int i=0;i<size;i++) {
			Person pr=person_vector.get(i);
			String online=pr.getP_online();
			if(online.equals("1")) {
				String power=pr.getP_power();
				if(!JugeNumber.isDigit(power)) {
					continue;
				}
				String tagid=pr.getP_tagid();
				int pow=Integer.parseInt(power);
				if(pow>100 && pow>1) {
					power="100";
				}
				String[] ziduan= {"tagid","power","time"};
				String[] zhi= {tagid,power,GetNowTime.now()};		
				DatabaseManagement.insertfast("tb_history_power", ziduan, zhi);
			}
		}
	}

	/**ÓÐ55AA0c²â¾àÊý¾ÝµÄʱºò¸Ä±ä±êÇ©µÄµçÁ¿£¬ÔÚÏß״̬£¬ÐÝÃߣ¬SOS£¬²ð³ý״̬Êý¾Ý
	 * String tagid,
	 * int sos,
	 * int xiumianÐÝÃß״̬
	 * int power
	 * hz 
	 * tagoff ±êÇ©²ð³ý״̬*/
	public static void have550c_alert_tag(Tag tag,String tagid,String sos,String xiumian,int power) {		
		if(tag !=null) {
			tag.setTag_sos(sos);
			tag.setTag_greattime(GetNowTime.now());
			tag.setTag_state("1");
			tag.setTag_power(String.valueOf(power));			
			Tag_Dell.alert_tag_low_power(tagid,power);//µÍµçÁ¿¸æ¾¯
			if(xiumian.equals("1")) {
				Person prs=person_Dell.get_Person(tagid);
				Dell_55AA0A.delete_pian(tagid,prs.getRealhz(),"±êÇ©ÐÝÃß");
			}
		}
	}

	/**Ð޸ıêÇ©ÀëÏßÐÝÃß¾²Ö¹×´Ì¬*/
	public static void lxj(Tag tag,String tagid,String lixians,String xiumians,String jingzhis) {		
		if(tag !=null) {
			int lixian=Integer.parseInt(lixians);
			int xiumian=Integer.parseInt(xiumians);
			int jingzhi=Integer.parseInt(jingzhis);
			tag.setLixian(lixian);
			tag.setXiumian(xiumian);
			tag.setJingzhi(jingzhi);
		}
	}

	

	/**ÉèÖÃurt×é*/
	public static void  alert_gas_data2(String tagid,String baoliu4) {
		if(tagid.equals("ËùÓбêÇ©")) {
			String updateSQL="UPDATE tb_tag SET "+"baoliu4='"+baoliu4+"'";	
			DatabaseManagement.update(updateSQL);
		}else {
			String[] ziduan= {"baoliu4","tag_id"};
			String[] zhi= {baoliu4,tagid};
			DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
			int tag_baoliu4=Integer.parseInt(baoliu4);
			get_tag(tagid).setBaoliu4(tag_baoliu4);;

		}
	}

	

	/**ËùÓбêÇ©Ð޸ijɹ¦×´Ì¬ÉèÖÃΪ0*/
	public static void alert_succ() {
		if (tag_vector.size() != 0) {
			for (int i = 0; i < tag_vector.size(); i++) {
				Tag tag = tag_vector.get(i);
				tag.setAlertsucc(0);			
			}
		}
	}


}