package tbDataModel_Dell;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import PbuliClass.ShowMessage;
import home.Open_soft_dialog;
import tbDataModel.Point_fence_inout;
import tbDataModel.Tb_fence_inout;

public class Dell_Fenceinout {

	static Vector<Tb_fence_inout> finout_vec=new Vector<>();
	static Vector<Point_fence_inout> point_finout_vec=new Vector<>();

	/**³õʼ»¯Êý¾Ý*/
	@SuppressWarnings("rawtypes")
	public static void chushihua(){	
		Open_soft_dialog.addara("¼ÓÔØtb_fence_inout");
		Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_fence_inout").iterator();
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ			
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			Tb_fence_inout tbinout=new Tb_fence_inout();
			tbinout.setId(Integer.parseInt((String)info.get(0)));
			tbinout.setName((String)info.get(1));
			tbinout.setZuobiao((String)info.get(2));			
			tbinout.setBianshu((String)info.get(3));
			tbinout.setCanin((String)info.get(4));
			tbinout.setCanout((String)info.get(5));
			tbinout.setFloor((String)info.get(6));
			tbinout.setAddtime((String)info.get(7));
			String zu=(String)info.get(8);
			String allFloor=(String)info.get(9);
			int group=Integer.parseInt(zu);
			if (allFloor==null){
				allFloor="0";
			}
			tbinout.setBaoliu1("0");
			tbinout.setGoroup(group);
			finout_vec.add(tbinout);		
			get_point_fencinout((String)info.get(2),(String)info.get(6));
		}
	}


	/**ij¸ö»ñÈ¡¶à±ßÐεÄÇøÓò¶ÔÏó*/
	public static  Tb_fence_inout get_finout(String name) {
		Tb_fence_inout tbinout=null;
		int size=finout_vec.size(); 
		if(size!=0) {
			for(int i=0;i<size;i++) {
				Tb_fence_inout tbinout1=finout_vec.get(i);
				if(tbinout1.getName().equals(name)) {
					tbinout=tbinout1;
					break;
				}
			}
		}
		return tbinout;
	}


	/**»ñÈ¡ÇøÓò×ø±êX¼¯ºÏ*/
	//85,86;87,88;100,477
	public static int[]  py(String name) {

		int j=0;
		int size= Integer.parseInt(get_finout(name).getBianshu());
		int py[]=new int[size];

		String zuobiao=get_finout(name).getZuobiao().replace(";", ",");

		String zuobiaos[]=zuobiao.split("\\,");

		for(int i=0;i<size*2;i++) {

			if((i%2) !=0) {
				double wd=Double.parseDouble(zuobiaos[i]);
				py[j]=(int) wd;
				j++;
			}
		}


		return py;		
	}

	/**»ñÈ¡ÇøÓò×ø±êY¼¯ºÏ*/
	//[85,86;87,88;100,477]
	public static int[]  px(String name) {

		int j=0;
		int size= Integer.parseInt(get_finout(name).getBianshu());
		int px[]=new int[size];

		String zuobiao=get_finout(name).getZuobiao().replace(";", ",");

		String zuobiaos[]=zuobiao.split("\\,");

		for(int i=0;i<size*2;i++) {

			if((i%2) ==0) {
				double wd=Double.parseDouble(zuobiaos[i]);
				px[j]=(int) wd;
				j++;
			}
		}


		return px;		
	}


	/**»ñÈ¡ÊÇ·ñ¿ÉÒÔ½øÈ뼯ºÏ*/
	public static int[] entrance(String name) {
		int size= Integer.parseInt(get_finout(name).getBianshu());
		int entrance[]=new int[size];
		String entrances[]=get_finout(name).getCanin().split(",");
		for(int i=0;i<size;i++) {
			String a=entrances[i].replaceAll(" ", "");
			entrance[i]=Integer.parseInt(a);
		}
		return entrance;
	}

	/**»ñÈ¡ÊÇ·ñ¿ÉÒÔ³öÈ¥µÄ¼¯ºÏ*/
	public static int[] exit(String name) {
		int size= Integer.parseInt(get_finout(name).getBianshu());
		int exit[]=new int[size];
		String exits[]=get_finout(name).getCanout().split(",");
		for(int i=0;i<size;i++) {
			String a=exits[i].replaceAll(" ", "");
			exit[i]=Integer.parseInt(a);
		}
		return exit;
	}


	public static Vector<Tb_fence_inout> getFinout_vec() {
		return finout_vec;
	}

	public static void alert(String name,String zuobiao,String canin,String canout,String ceng,String group) {
		get_finout(name).setZuobiao(zuobiao);
		get_finout(name).setCanin(canin);
		get_finout(name).setCanout(canout);
		get_finout(name).setFloor(ceng);
		get_finout(name).setGoroup(Integer.parseInt(group));
		String[] ziduan= { "zuobiao","canin", "canout","addtime","floor","zu","name"};
		String[] zhi= {zuobiao,canin,canout,GetNowTime.now(),ceng,group,name};
		String[] ziduan2= { "zuobiao","addtime","floor","name"};
		String[] zhi2= {zuobiao,GetNowTime.now(),ceng,name};
		DatabaseManagement.fast_alert_dbase("tb_fence", ziduan2, zhi2);
		if(DatabaseManagement.fast_alert_dbase("tb_fence_inout", ziduan, zhi)) {
			ShowMessage.zidingyi_24("Ð޸ijɹ¦£¬ÖØÆôÈí¼þºóÉúЧ...");
		}

	}

	public static void insert(String name,String zuobiaos,String type,String floor,Integer group,String allFloor) {
		String bianshu="4";
		StringBuffer canin=new StringBuffer();
		StringBuffer canout=new StringBuffer();

		if(type.equals("¾ØÐÎ")) {			
			canin=new StringBuffer("1,1,1,1");
			canout=new StringBuffer("1,1,1,1");
		}else if (type.equals("¶à±ßÐÎ")){
			String[] zb=zuobiaos.split("\\;");
			bianshu=String.valueOf(zb.length);
			for(int i=0;i<zb.length-1;i++) {
				canin.append("1,");
				canout.append("1,");
				if(i==(zb.length-2)) {
					canin.append("1");
					canout.append("1");
				}
			}
		}else if (type.equals("һάÏß")){
			String[] zb=zuobiaos.split("\\;");
			bianshu=String.valueOf(zb.length);
			for(int i=0;i<zb.length-1;i++) {
				canin.append("0,");
				canout.append("0,");
				if(i==(zb.length-2)) {
					canin.append("0");
					canout.append("0");
				}
			}
		}

		String[]  ziduan= {"name", "zuobiao",  "bianshu",  "canin", "canout",  "floor", "addtime","zu","baoliu1"};
		String[] zhi= {name,zuobiaos,bianshu,canin.toString(),canout.toString(),floor,GetNowTime.now(), String.valueOf(group),allFloor};
		boolean a=DatabaseManagement.insertfast("tb_fence_inout", ziduan, zhi);
		if(a) {
		Tb_fence_inout tbinout=new Tb_fence_inout();
		tbinout.setName(name);
		tbinout.setZuobiao(zuobiaos);
		tbinout.setBianshu(bianshu);
		tbinout.setCanin(canin.toString());
		tbinout.setCanout(canout.toString());
		tbinout.setFloor(floor);
		tbinout.setGoroup(group);
		tbinout.setAddtime(GetNowTime.now());
		tbinout.setBaoliu1(allFloor);
		finout_vec.add(tbinout);
		}else {
			ShowMessage.zidingyi("±£´æΧÀ¸Ê§°Ü£¬Ð´ÈëÊý¾Ý¿âʧ°Ü");
		}
	}

	/**ɾ³ýij¸ö¶ÔÏó*/
	public static void delte(String name) {
		if(get_finout(name) !=null) {
			finout_vec.removeElement(get_finout(name));
			String deleteSql="DELETE FROM tb_fence_inout WHERE name='"+name+"'";
			DatabaseManagement.update(deleteSql);
		}
	}
	
	/**È«²¿É¾³ý*/
	public static void delteall() {
		if(finout_vec.size() !=0) {
			finout_vec.removeAllElements();
			String deleteSql="TRUNCATE TABLE tb_fence_inout";
			DatabaseManagement.update(deleteSql);
			
		}
	}
	
	public static void get_point_fencinout(String message,String floor) {
		String[] mes=message.split(";");
		///
		for(int i=0;i<mes.length;i++) {
			String name=mes[i];			
			String[] xy=name.split(",");
			double x0=Double.parseDouble(xy[0]);
			double y0=Double.parseDouble(xy[1]);
			int x=(int)x0;
			int y=(int)y0;
			Point_fence_inout pfi=new Point_fence_inout();
			pfi.setName(name);
			pfi.setX(x);
			pfi.setY(y);
			pfi.setFloor(floor);
			point_finout_vec.add(pfi);			
			xy=null;			
		}
		mes=null;
	}


	public static Vector<Point_fence_inout> getPoint_finout_vec() {
		return point_finout_vec;
	}

}