package Method;
import DataBase.DatabaseManagement;
import Frame.Tag_gas_value;
import PbuliClass.Shi_jian_cha_sss;
import PbuliClass.Systems;
import person.Person;
import tag.Tag;
import tag.Tag_Dell;
import tbDataModel.Tb_gas_anchor;

/**¸Ã·½·¨ÓÃÓÚ½«±êÇ©×ø±ê²åÈëÀúÊ·¹ì¼£Êý¾Ý¿â*/
public class PutPosInHistoryDataBase {
	static StringBuffer suffix = new StringBuffer(); // ±£´æsqlºó׺
	static StringBuffer suffix2 = new StringBuffer(); // ±£´æsqlºó׺
	static StringBuffer suffix3 = new StringBuffer(); // ±£´æsqlºó׺
	static int jishu=0;
	static int jishu3=0;
	static int baowennum=0;//±¨ÎÄÊý
	static String prefix2 = "INSERT INTO tb_yuan_shi_bao_wen (ip,str,addtime)  VALUES ";
	static String prefix3 = "INSERT INTO tag_gas_history (tagid,gasanchorid,taggas,anchorgas,reallgao,time)  VALUES ";
	
	/**baoliu1·Ã¿ÍID 
	 * baoliu2¾­¶È
	 * baoliu3γ¶È
	 * baoliu4¸ß³Ì
	 * baoliu5¾«¶È״̬
	 * baoliu6SOS״̬
	 * baoliu7µçÁ¿*/
	public static void  putInHistory(
			Person per,
			String tagid,
			String x,
			String y,
			String z,
			String layer,
			String gps_state,
			String jwd
			) {
		if(Systems.isSaveguiji()) {//Èç¹û¿ªÆô¹ì¼£±£´æ¹¦ÄÜ
			String time=GetNowTime.timestamp2();
			String baoliu1=per.getBaoliu1();//·Ã¿ÍID
			String baoliu2=per.getBaoliu2();//¾­¶È
			String baoliu3=per.getBaoliu3();//γ¶È
			String baoliu4=per.getBaoliu4();//¸ß³Ì
			String baoliu5=gps_state;//¾«¶È״̬
			String baoliu6=jwd;//¾­Î³¶È¶È¸ñʽ
			String baoliu7=per.getP_power();//µçÁ¿
			String baoliu8=per.getP_name();
			String tb_track="tb_track_"+GetNowTime.getyearmd();
			String prefix = "INSERT INTO "+tb_track
					+" (tagid,x,y,z,layer,time,baoliu1,baoliu2,baoliu3,baoliu4,baoliu5,baoliu6,baoliu8,baoliu7)  VALUES ";

			//½«±êǩʵʱλÖòåÈëÀúÊ·¹ì¼£Êý¾Ý¿âÖÐseq,tagid,x,y,z,layer,year,month,day,time,timestamp
			jishu++;					 
			suffix.append("('"+
					tagid+"','"+
					x+"','"+
					y+"','"+
					z+"','"+
					layer+"','"+
					time+"','"+
					baoliu1+"','"+
					baoliu2+"','"+
					baoliu3+"','"+	
					baoliu4+"','"+	
					baoliu5+"','"+	
					baoliu6+"','"+
					baoliu8+"','"+
					baoliu7+"'),");
			if(jishu==100) {
				StringBuffer sql =new StringBuffer(prefix + suffix.substring(0, suffix.length() - 1)) ; // ¹¹½¨ÍêÕûsql
				DatabaseManagement.insert_fast(sql.toString(),1);
				suffix.setLength(0); 
				jishu=0;
			}

			tb_track=null;
			prefix =null;
		}
	}


	public static boolean insert_baowen(String str,String ip,String time) {
		boolean inok=false;
		suffix2.append("('"+ip+"','"+str+"','"+time+"'),");
		StringBuffer sql =new StringBuffer(prefix2 + suffix2.substring(0, suffix2.length() - 1)) ; // ¹¹½¨ÍêÕûsql
		DatabaseManagement.insert_fast(sql.toString(),3); 
		suffix2.setLength(0);
		inok=true;
		return inok;
	}

	/**λÖùýÂ˹¦ÄÜ*/
	public static boolean  guijiguolv(Person per,String tagid,String x,String y) {
		boolean ok=false;		
		String lastokpostime=per.getLastokpostime();
		double xd=Double.parseDouble(x);
		double yd=Double.parseDouble(y);
		if(lastokpostime==null) {
			ok=true;
			per.setLastokpostime(GetNowTime.now());
			per.setLastokposx(xd);
			per.setLastokposy(yd);
		}else {
			double x0=per.getLastokposx();
			double y0=per.getLastokposy();
			double d2=(x0-xd)*(x0-xd)+(y0-yd)*(y0-yd);
			double d=Math.sqrt(d2);
			int b= Shi_jian_cha_sss.get_time_cha_s(GetNowTime.now(),lastokpostime);//ʱ¼ä²î
			Tag tag=Tag_Dell.get_tag(tagid);
			double sudu=Double.parseDouble(tag.getTag_sulv());
			double realsudu=d/b;
			if(realsudu<sudu) {
				ok=true;
				per.setLastokpostime(GetNowTime.now());
				per.setLastokposx(xd);
				per.setLastokposy(yd);
			}
		}

		return ok;		
	}

	/**½«ÆøѹÊý¾Ý±£´æ½øÈëÊý¾Ý¿â*/
	public static void inset_tag_gas_in_history(
			Tb_gas_anchor ancgas,
			String tagid,
			String gasanchorid,
			String taggas,			
			String reallgao,
			String time
			) {
		if(Tag_gas_value.isSave_history_gas_value()) {//Èç¹û¿ªÆô±£´æÀúÊ·Æøѹֵ
			jishu3++;
			String anchorgas=ancgas.getGasvalue();
			suffix3.append("('"+tagid+"','"+gasanchorid+"','"+taggas+"','"+anchorgas+"','"+reallgao+"','"+time+"'),");
			if(jishu3==100) {
				StringBuffer sql =new StringBuffer(prefix3 + suffix3.substring(0, suffix3.length() - 1)) ; // ¹¹½¨ÍêÕûsql
				DatabaseManagement.insert_fast(sql.toString(),1);
				suffix3.setLength(0); 
				jishu3=0;
			}
		}
		
	}

}