package engbs;
import java.util.Vector;
import BaoWen.Dell_55AA01;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import anchor.Anchor_Dell;
import fence.kaoqing.Dell_KaoQing;
import person.person_Dell;
import tbDataModel_Dell.Tb_Warnig_Dell;

/**¸ÃÀàÓÃÓÚ¸üÐÂͳ¼ÆÊý¾Ý*/
public class Tongji {
	
	static int yingqingint=0;
	static int heartnum=0;
	
	
	static Vector<String> shishiv=new Vector<String>();
	static Vector<String> tongjiv=new Vector<String>();//ͳ¼ÆÊý¾Ý¿â
	static {
		shishiv.add("λÖÃ");
		shishiv.add("ÒýÇæ");
		shishiv.add("¿¼ÇÚ");
		
		for(int i=0;i<9;i++) {
			tongjiv.add(i+1+"");
		}		
	}
	

	
	public  static void gengxin() {
		String time=GetNowTime.now();		
		Vector<String> id=new Vector<String>();
		Vector<String> num=new Vector<String>();
		Vector<String> time1=new Vector<String>();
		
		Vector<String> num2=new Vector<String>();
		Vector<String> time2=new Vector<String>();
		
		int online_num=person_Dell.get_online_person();//ÔÚÏß
		int off_online=person_Dell.getPerson_vector().size()-online_num;//ÀëÏß		
		int anchor_online_num=Anchor_Dell .get_online_anchornum()[0];//»ùÕ¾ÔÚÏßÊýÁ¿
		int anchor_online_off=Anchor_Dell .get_online_anchornum()[1];//»ùÕ¾ÀëÏßÊýÁ¿		
		int onlinecar=person_Dell.get_online_car()[0];//ÔÚÏß³µÁ¾
		int offcar=person_Dell.get_online_car()[1];//ÀëÏß³µÁ¾		
		int onlinewuzi=person_Dell.get_online_wuzi()[0];//ÔÚÏßÎï×Ê
		int offwuzi=person_Dell.get_online_wuzi()[1];//ÀëÏßÎï×Ê
		int SOSwarning=Tb_Warnig_Dell.get_warning_num("SOS");//sos¸æ¾¯
		int powernum=Tb_Warnig_Dell.get_warning_num("µÍµçÁ¿");//µÍµçÁ¿¸æ¾¯
		int infencenum=Tb_Warnig_Dell.get_warning_num("½øÈë¸æ¾¯");//½øÈë¸æ¾¯
		
		StringBuffer sql=new StringBuffer("UPDATE tb_tongji SET ");
		StringBuffer sql2=new StringBuffer("UPDATE tb_shishi SET ");
		
		id.add("1");
		id.add("2");
		id.add("3");
		id.add("4");
		id.add("5");
		id.add("6");
		id.add("7");
		id.add("8");
		id.add("9");
		
		num.add(online_num+":"+off_online);
		num.add(onlinecar+":"+offcar);
		num.add(onlinewuzi+":"+offwuzi);
		num.add(anchor_online_num+":"+anchor_online_off);
		num.add(SOSwarning+"");
		num.add(powernum+"");
		num.add(infencenum+"");
		num.add(Dell_55AA01.getSs()+"");
		num.add(GetNowTime.HH_MM_SS());
		
				
		time1.add(time);
		time1.add(time);
		time1.add(time);
		time1.add(time);
		time1.add(time);
		time1.add(time);
		time1.add(time);
		time1.add(time);
		time1.add(time);
		
		
		String weizhi=String.valueOf(Dell_55AA01.getGuji());
		String yingqing=String.valueOf(yingqingint);
		String kaoqing=String.valueOf(Dell_KaoQing.size());
		time2.add(time);
		time2.add(time);
		time2.add(time);
		
		
		num2.add(weizhi);
		num2.add(yingqing);
		num2.add(kaoqing);		
		
		sql.append(engine_do.getinfo(num,"num",id,"id")+" , ");
		sql.append(engine_do.getinfo(time1,"addtime",id,"id")+"  ");
		sql.append(engine_do.getlast(id,"id"));
		
		sql2.append(engine_do.getinfo(num2,"num",shishiv,"type")+" , ");
		sql2.append(engine_do.getinfo(time2,"addtime",shishiv,"type")+"  ");
		sql2.append(engine_do.getlast(shishiv,"type"));
		
		//¸üÐÂÊý¾Ý¿â
		DatabaseManagement.update(sql.toString());
		DatabaseManagement.update(sql2.toString());
		
		sql.setLength(0);//Çå¿Õ		
		sql2.setLength(0);//Çå¿Õ
		
	
	}


	public static int getYingqingint() {
		return yingqingint;
	}


	public static void setYingqingint(int yingqingint) {
		Tongji.yingqingint = yingqingint;
	}
	
	/**ÐÄÌøÊý¾Ý´æÈëÐÄÌøÊý¾Ý¿â
	 * C/SÒýÇæÐÄÌø°ü£¬ÐÄÌøÊý¾ÝĬÈÏ10ÃëÖÓ·¢ËÍÒ»´Î¡£
	 * hxzk_heart,[length],[timestamp],[mark]*/
	public static void intsert_hear(String message) {		
		heartnum++;
		String[] a=message.split(",");
		String biaozhi=a[3];
		String[]  ziduan= {"biaozhi","time"};
		String[] zhi= {biaozhi,GetNowTime.now()};
		DatabaseManagement.insertfast("tb_heart", ziduan, zhi);
		if(heartnum==60) {
			heartnum=0;
			String deleteSql="TRUNCATE TABLE tb_heart";	
			DatabaseManagement.update(deleteSql);
		}
	}


	public static int getHeartnum() {
		return heartnum;
	}
	
	
}