package Method;
import DataBase.DatabaseManagement;
import PbuliClass.Systems;

/**¸ÃÀàÓÃÓÚ¹ÜÀíÀúÊ·¹ì¼£±í*/
public class About_tb_track {

	//¹ì¼£±£´æµÄÌìÊý
	static int saveday=Integer.parseInt(Systems.sys().getGui_ji());

	/**´´½¨±£´æÈÕÆÚÕÅÀúÊ·¹ì¼£±í£¬Èç±£´æÈÕÆÚ30Ìì¾Í´´½¨µ±Ç°µ½30ÌìºóµÄ±í*/
	public static void create_tb_track() {

		//´´½¨¹ì¼£±£´æÌìÊýÕűí
		for(int i=0;i<saveday;i++) {

			//±íÃû³ÆΪ
			String table_name="tb_track_"+GetNowTime.addDay(i);

			String sql="CREATE TABLE  IF NOT EXISTS "+table_name+" ("
					+ " id INT AUTO_INCREMENT PRIMARY KEY,"
					+ " tagid VARCHAR(10),"
					+ " x VARCHAR(30),"
					+ " y VARCHAR(30),"
					+ " z VARCHAR(30),"
					+ " layer VARCHAR(10),"
					+ " time VARCHAR(100),"
					+ " baoliu1 VARCHAR(50),"//·Ã¿ÍID
					+ " baoliu2 VARCHAR(50),"//¾­¶È
					+ " baoliu3 VARCHAR(50),"//γ¶È
					+ " baoliu4 VARCHAR(50),"//¸ß³Ì
					+ " baoliu5 VARCHAR(50),"
					+ " baoliu6 VARCHAR(50),"
					+ " baoliu7 VARCHAR(50),"
					+ " baoliu8 VARCHAR(50),"
					+ " baoliu9 VARCHAR(50),"
					+ " baoliu10 VARCHAR(100))";

			DatabaseManagement.update(sql);


		}
		delte_tb_track();
	}

	/**×Ô¶¯Ôö¼Ógps¹ì¼£±í*/
	public static void  tb_gps_track() {
		//´´½¨¹ì¼£±£´æÌìÊýÕűí
		for(int i=0;i<saveday;i++) {					//±íÃû³ÆΪ
			String table_name="tb_gps_track_"+GetNowTime.addDay(i);
			String sql="CREATE TABLE IF NOT EXISTS "+table_name+" ("
					+" id INT AUTO_INCREMENT PRIMARY KEY,"
					+" gps_utc_time VARCHAR(50),"
					+" gps_weidu VARCHAR(50),"
					+" gps_NS VARCHAR(50),"
					+" gsp_jingdu VARCHAR(50),"
					+" gps_EW VARCHAR(50),"
					+" gps_state VARCHAR(50),"
					+" gps_num VARCHAR(50),"
					+" gps_hdop VARCHAR(50),"
					+" gps_haiba_gao VARCHAR(50),"
					+" gps_tuoqiu VARCHAR(50),"
					+" gps_chafen_time VARCHAR(50),"
					+" gps_chafen_id VARCHAR(50),"
					+" gps_jiaoyan VARCHAR(50),"
					+" tagid VARCHAR(50),"
					+" gps_kahao VARCHAR(50),"
					+" gps_power VARCHAR(10),"
					+" gps_sos VARCHAR(10),"
					+" addtime VARCHAR(100))";
			DatabaseManagement.update(sql);


		}
		
	}


	/**Çå¿ÕËùÓбíÖеÄÊý¾Ý*/
	public static void delete_all() {

		//´´½¨¹ì¼£±£´æÌìÊýÕűí
		for(int i=1;i<saveday;i++) {
			//±íÃû³ÆΪ
			String table_name="tb_track_"+GetNowTime.addDay(-i);					
			String deleteSql="TRUNCATE TABLE "+table_name;
			DatabaseManagement.update(deleteSql);

			String table_name2="tb_gps_track_"+GetNowTime.addDay(-i);
			String deleteSql2="TRUNCATE TABLE "+table_name2;
			DatabaseManagement.update(deleteSql2);
		}

	}
	
	/**ɾ³ýÊý¾Ý±í*/
	public static void dropt(String data) {
		String a=data.replace("-", "");
		String name="tb_track_"+a;
		String deleteSql="DROP TABLE "+name;
		DatabaseManagement.update(deleteSql);
		
		String table_name2="tb_gps_track_"+a;
		String deleteSql2="DROP TABLE "+table_name2;
		DatabaseManagement.update(deleteSql2);
	}


	/**ɾ³ý³¬¹ý±£´æÈÕÆÚµÄÇ°30ÌìµÄ±í*/
	public static void delte_tb_track() {
		//ɾ³ýÒª±£´æÈÕÆÚÇ°30ÌìÊý¾Ý±í
		for(int i=saveday;i<4*saveday;i++) {
			//±íÃû³ÆΪ
			String table_name="tb_track_"+GetNowTime.addDay(-i);
			String sql1="DROP TABLE IF EXISTS "+table_name;
			
			String table_name2="tb_gps_track_"+GetNowTime.addDay(-i);
			String sql2="DROP TABLE IF EXISTS "+table_name2;
			DatabaseManagement.update(sql1);
			DatabaseManagement.update(sql2);
		}	

	}


	/**ÐÂÔö±£´æÈÕÆÚÌìÊý+1ÌìµÄ¹ì¼£±íͬʱɾ³ýµ±Ç°ÈÕÆÚ¼õÈ¥¼õÈ¥±£´æÌìÊý+1ÌìµÄ±í*/
	public static  void add_and_delete_a_tbtrack() {
		//±íÃû³ÆΪ
		String table_name="tb_track_"+GetNowTime.addDay(saveday+1);
		String sql="DROP TABLE IF EXISTS "+ table_name;
		DatabaseManagement.update(sql);

		String table_name2="tb_track_"+GetNowTime.addDay(-(saveday+1));

		String sql2="DROP TABLE IF EXISTS "+ table_name2;
		DatabaseManagement.update(sql2);


		String table_name3="tb_gps_track_"+GetNowTime.addDay(saveday+1);
		String sql3="DROP TABLE IF EXISTS "+ table_name3;
		DatabaseManagement.update(sql3);

		String table_name4="tb_gps_track_"+GetNowTime.addDay(-(saveday+1));

		String sql4="DROP TABLE IF EXISTS "+ table_name4;
		DatabaseManagement.update(sql4);

	}

	/**¹ì¼£ÈÕÆڵļ¯ºÏ*/
	public static String[] get_tbtrack() {
		String[] datas=new String[saveday];
		for(int i=0;i<saveday;i++) {
			datas[i]=GetNowTime.addDay1(-i);
		}
		return datas;
	}

}