package fence;
import java.awt.geom.Point2D;
import java.util.Vector;

import DataBase.DatabaseManagement;
import Method.GetNowTime;
import PbuliClass.*;
import fence.kaoqing.Dell_KaoQing;
import fence.kaoqing.TbRealKaoQing;
import jiekou.Tongji;
import person.Person;
import person.person_Dell;
import tbDataModel.TbFence;

/**
 * ÅжϵãÊÇ·ñÔÚ¿¼ÇÚÇøÓòÄÚ
 */
public class PointIsInKaoQing {
	static String prefix = "INSERT  tb_realkaoqing (id,area,name,bumen,tagid,intime,beizhu ) VALUES ";
	static String prefix2 = "INSERT tb_kaoqing (area,name,bumen,tagid,intime,outtime,alltime,beizhu) VALUES ";
	static StringBuffer suffix = new StringBuffer(); // ±£´æsqlºó׺
	static StringBuffer suffix2 = new StringBuffer(); // ±£´æsqlºó׺
	static int jishu = 0;
	static int jishu2 = 0;
	static String mark = Systems.sys().getBiaozhi();
	static Person person;
	static String tag_name;
	static String a = Systems.sys().getEng_bs();
	static boolean ispoly =false;

	public static void is_in_kaoqing_fence(
			Vector<TbFence> kaoqing_fences,
			int size,
			String tagid,
			String floor,
			int x,
			int y,
			int z,
			String battery,
			String intime,
			Point2D.Double point) {
		if (size == 0) {//Èç¹ûΧÀ¸ÇøÓò²»´æÔÚÔòÖ´ÐÐ
			return;
		}
		person = person_Dell.get_Person(tagid);
		if (person == null) {
			return;
		}
		tag_name = person.getP_name();        
		Dell_KaoQing.alert_xy(tagid, x, y);
		for (int i = 0; i < size; i++) {//±éÀúËùÓп¼ÇÚÇøÓò
			TbFence kaoqing_fence = kaoqing_fences.get(i);
			String bumen = person.getP_department();
			String bumen2 = kaoqing_fence.getBumen();
			if (!bumen.equals(bumen2) && !bumen2.equals("ϵͳĬÈÏ")) {
				continue;
			}
			String ceng = kaoqing_fence.getFloor();//¿¼ÇÚÇøÓòËùÔڵIJã
			String allFnece = kaoqing_fence.getBaoliu10();//¿¼ÇÚÇøÓòËùÔڵIJã
			if (!floor.equals(ceng) && !allFnece.equals("1")) {
				continue;
			}
			String startime = kaoqing_fence.getStart();//ΧÀ¸ÉúЧ¿ªÊ¼Ê±¼ä
			String stoptime = kaoqing_fence.getStop();//ΧÀ¸ÉúЧ½áÊøʱ¼ä
			String name = kaoqing_fence.getName();
			//Ö»ÓÐÔÚÉúЧʱ¼äÄÚ²ÅÅжϵãÔÚ²»ÔÚÇøÓòÄÚ
			boolean zai = IsInStartAndEndTime.belongCalendar(intime, startime, stoptime);//ÅжÏÊÇ·ñÔÚΧÀ¸ÉúЧµÄʱ¼äÄÚ
			if (!zai) {//²»ÔÚΧÀ¸ÉúЧʱ¼äÄÚ
				continue;
			}
			String shape=kaoqing_fence.getShape();
			int h0=Integer.parseInt(kaoqing_fence.getBaoliu12());//ΧÀ¸µ×²¿¸ß
			int h1=Integer.parseInt(kaoqing_fence.getBaoliu11());//ΧÀ¸¶¥²¿¸ß
			if(h0==-1) {//µÈÓÚ-1±íʾ²»ÅжÏΧÀ¸¸ß¶ÈÖ»¸ù¾Ý²ãÅжÏ				
				if(shape.equals("Ô²ÐÎ")) {
					ispoly=Juge_in_yuan.is_in(kaoqing_fence.getYuan_x(),x,y);
				}else {
					ispoly = IsPtInPoly.inPoly(point, kaoqing_fence.getPts());//ÅжÏID×ø±êÊÇ·ñÔÚΧÀ¸ÇøÓò
				}
			}else {
				if(z<h0 || z>h1) {//Èç¹û±êÇ©¸ß¶ÈÔÚΧÀ¸·¶Î§ÄÚ
					if(shape.equals("Ô²ÐÎ")) {						
						ispoly=Juge_in_yuan.is_in(kaoqing_fence.getYuan_x(),x,y);
					}else {
						ispoly = IsPtInPoly.inPoly(point, kaoqing_fence.getPts());//ÅжÏID×ø±êÊÇ·ñÔÚΧÀ¸ÇøÓò
					}
				}    
			}
			is_infece_or_noin_fence(name, bumen,floor,intime,tagid,x,y,z,battery);
		}
	}


	/**ÔÚ»òÕß²»ÔÚ¿¼ÇÚÇøÓòÐèÒª×öµÄÊÂÇéyang20230915*/
	public static void is_infece_or_noin_fence(String name,String bumen,String floor,
			String intime,String tagid,int x,int y,int z,String battery) {
		if (ispoly) {//Èç¹ûÔÚ¿¼ÇÚÇøÓòÄÚ
			String inkaoqingname=person.getP_kaoqqingname();
			if(inkaoqingname.equals(name)) {//Èç¹ûµ±Ç°ËùÔڵĿ¼ÇÚÇøÓòºÍ֮ǰһÑùÔò·µ»Ø
				return;
			}
			String phone = person.getP_phone();
			String time2 = GetNowTime.HH_MM_SS();
			TbRealKaoQing tbr = new TbRealKaoQing();
			tbr.setArea(name);
			tbr.setBumen(bumen);
			tbr.setFloor(Integer.parseInt(floor));
			tbr.setIntime(intime);
			tbr.setName(tag_name);
			tbr.setTagid(tagid);
			tbr.setX(x);
			tbr.setY(y);
			tbr.setZ(z);
			tbr.setBeizhu(phone);
			tbr.setPower(battery);
			tbr.setTime2(time2);
			Dell_KaoQing.add_tbkaoq(name, floor, tagid, tbr);//ʵʱ¿¼ÇÚ¼¯ºÏÖÐÌí¼ÓÒ»¸ö¼Ç¼
			add_data_indatabase(name, tag_name, tagid, time2, phone, bumen);//Êý¾Ý¿âÖÐÌí¼ÓÒ»Ìõ¼Ç¼
			person.setP_kaoqing("1");//±êÇ©½øÈ뿼ÇÚÇøÓò½«ÊµÊ±Î»ÖÃÖп¼ÇÚ״̬ÐÞ¸ÄΪ1
			person.setP_kaoqqingname(name);
			return;
		} else {//Èç¹û²»ÔÚ¿¼ÇÚÇøÓò
			String arename = person.getP_kaoqqingname();			
			if(arename==null ||  arename.length()<1 || !arename.equals(name)) {//֮ǰ²»ÔÚÈκο¼ÇÚÇøÓò·µ»Ø
				return;
			}
			
			TbRealKaoQing tbkq = Dell_KaoQing.get_tbkq(arename, tagid);
			if (tbkq != null) {
				add2(tbkq, tag_name, tagid, intime);
				Dell_KaoQing.delete_TbRealKaoQing(tbkq, arename);//½«Ä³ÇøÓòÖеĿ¼ÇÚ¶ÔÏóÒƳý
				if (a.equals("1")) {
					String deleteSql = "DELETE FROM tb_realkaoqing WHERE tagid='" + tagid + "'";
					DatabaseManagement.update(deleteSql);
				}
			}
			person.setP_kaoqing("0");
			person.setP_kaoqqingname("");
		}
	}

	public static void add_data_indatabase(String name, String tag_name, String tagid, String time2, String phone, String bumen) {
		jishu++;
		suffix.append("(default,'" + name + "','" + tag_name + "','" + bumen + "','" + tagid + "','" + time2 + "','" + phone + "'),");
		if (jishu == 1) {
			StringBuffer sql = new StringBuffer(prefix + suffix.substring(0, suffix.length() - 1)); // ¹¹½¨ÍêÕûsql
			DatabaseManagement.insert_fast(sql.toString(), 4);
			suffix = new StringBuffer(); // Çå¿ÕÉÏÒ»´ÎÌí¼ÓµÄÊý¾Ý
			jishu = 0;
		}
	}

	public static void add2(TbRealKaoQing tbkq, String name, String tagid, String intime) {
		String in = tbkq.getIntime();
		if (in == null) {
			return;
		}
		int alltime = Shi_jian_cha_sss.get_time_cha_s(in, intime);
		jishu2++;
		String are = tbkq.getArea();
		String bumen = tbkq.getBumen();
		String tagname = tbkq.getName();
		suffix2.append("('" + are + "','" + tagname + "','" + bumen + "','" + tagid + "','" + in + "','" + intime + "','" + alltime + "','" + "power:" + tbkq.getPower() + "'),");

		if (jishu2 == 1) {
			StringBuffer sql = new StringBuffer(prefix2 + suffix2.substring(0, suffix2.length() - 1)); // ¹¹½¨ÍêÕûsql
			DatabaseManagement.insert_fast(sql.toString(), 5);
			suffix2 = new StringBuffer(); // Çå¿ÕÉÏÒ»´ÎÌí¼ÓµÄÊý¾Ý
			jishu2 = 0;
			String message = "$statistics_time," + tagid + "," + are + "," + tagname + "," +
					bumen + "," + in + "," + intime + "," + alltime + "," + mark;
			Tongji.zhuanfa(message, tagid);
		}
	}

	/**
	 * ÀëÏßÔÚ¿¼ÇÚÇøÓòÖÐÇå³ý
	 */
	public static void lixianclear(Person person) {
		if (!Systems.isLixianoff()) {
			return;
		}
		int kqsize = Fences.getKaoqing_fences().size();
		if (kqsize == 0) {
			return;
		}
		String inkq = person.getP_kaoqing();
		if (inkq.equals("1")) {
			String area = person.getP_kaoqqingname();
			String tagid = person.getP_tagid();
			TbRealKaoQing tbkq = Dell_KaoQing.get_tbkq(area, tagid);
			Dell_KaoQing.delete_TbRealKaoQing(tbkq, area);//½«Ä³ÇøÓòÖеĿ¼ÇÚ¶ÔÏóÒƳý
			String deleteSql = "DELETE FROM tb_realkaoqing WHERE tagid='" + tagid + "'";
			DatabaseManagement.update(deleteSql);
			person.setP_kaoqing("0");
			person.setP_kaoqqingname("");
		}
	}

}