package engbs;
|
import java.util.Vector;
|
import BaoWen.Urt_7000_port;
|
import DataBase.DatabaseManagement;
|
import Method.GetNowTime;
|
import PbuliClass.Get_Tb_Gass;
|
import PbuliClass.Leds;
|
import PbuliClass.Shi_jian_cha_sss;
|
import PbuliClass.Systems;
|
import fence.Fences;
|
import fence.kaoqing.Dell_KaoQing;
|
import fence.kaoqing.TbRealKaoQing;
|
import person.Person;
|
import person.person_Dell;
|
import tag.Tag;
|
import tag.Tag_Dell;
|
import tbDataModel.TbGas;
|
import tbDataModel.Tb_gps;
|
import tbDataModel.Tb_led;
|
import urt.Dell_gps;
|
import urt.xytognss;
|
|
public class engine_do {
|
static boolean a=Systems.sys().getEng_bs().equals("1");
|
/**time 10·ÖÖÓ¸üÐÂÒ»´ÎµãÁÁÊý¾Ý*/
|
public static void tb_person(int time10) {
|
//Èç¹û¿ªÆôÁË×÷ΪBSÒýÇæģʽ
|
/***
|
* UPDATE tb_person SET p_x = CASE p_tagid
|
* WHEN '3225' THEN '121'
|
* WHEN '1222' THEN '1231'
|
* WHEN '1233' THEN '41'
|
* END,
|
* p_y = CASE p_tagid
|
* WHEN '3225' THEN '121'
|
* WHEN '1222' THEN '1231'
|
* WHEN '1233' THEN '41'
|
* END
|
* WHERE p_tagid IN ('3225','1222','1233')*/
|
|
//Èç¹ûʱ¼ä²î´óÓÚ60Ãë±íʾûÓÐÊý¾ÝÉÏÀ´
|
if(a) {
|
Vector<Person> person_vector=person_Dell.getPerson_vector();
|
int size=person_vector.size();
|
if(size==0) {
|
return;
|
}
|
|
StringBuffer sql=new StringBuffer("UPDATE tb_person SET ");
|
StringBuffer sql2=new StringBuffer("UPDATE tb_realocation SET ");
|
Vector<String> vp_tagid=new Vector<String>();
|
Vector<String> vp_x=new Vector<String>();
|
Vector<String> vp_y=new Vector<String>();
|
Vector<String> vp_floor=new Vector<String>();
|
Vector<String> vp_sos=new Vector<String>();
|
Vector<String> vp_online=new Vector<String>();
|
Vector<String> vp_power=new Vector<String>();
|
Vector<String> vp_kaoqing=new Vector<String>();
|
Vector<String> vp_fence=new Vector<String>();
|
Vector<String> vp_fencename=new Vector<String>();
|
Vector<String> vp_kaoqqingname=new Vector<String>();
|
Vector<String> vp_addtiem=new Vector<String>();
|
Vector<String> vp_shipin=new Vector<String>();
|
Vector<String> vp_shipingname=new Vector<String>();
|
Vector<String> vp_baoliu2=new Vector<String>();//¾¶È
|
Vector<String> vp_baoliu3=new Vector<String>();//γ¶È
|
Vector<String> vp_baoliu4=new Vector<String>();//¸ß¶È
|
Vector<String> vp_baoliu6=new Vector<String>();
|
Vector<String> vp_baoliu5=new Vector<String>();//±êÇ©ÀàÐÍ
|
Vector<String> vp_baoliu8=new Vector<String>();//±êÇ©IPµØÖ·
|
Vector<String> vp_baoliu9=new Vector<String>();//±êÇ©¶Ë¿Ú
|
Vector<String> vp_baoliu10=new Vector<String>();//±êÇ©Ïà¶Ôº£°Î¸ß¶È
|
Vector<String> vp_baoliu13=new Vector<String>();//GPSµ±Ç°×´Ì¬
|
Vector<String> vp_baoliu14=new Vector<String>();//GPS¾¶È¶È·Ö¸ñʽ
|
Vector<String> vp_baoliu15=new Vector<String>();//GPSά¶È¶È·Ö¸ñʽ
|
Vector<String> vp_baoliu16=new Vector<String>();//ÐÄÂʸüÐÂ
|
Vector<String> vp_baoliu20=new Vector<String>();//ÊÇ·ñÔÚ½øß澯ÇøÓò1ÔÚ,0²»ÔÚ
|
Vector<String> vp_baoliu21=new Vector<String>();//ÊÇ·ñÔÚ³öß澯ÇøÓò1ÔÚ£¬0²»ÔÚ
|
Vector<String> vp_baoliu22=new Vector<String>();//XY½âµÄÀ´Ô´
|
Vector<String> vp_baoliu23=new Vector<String>();//±êÇ©µÄËÙ¶È
|
|
if(size !=0) {
|
for(int i=0;i<size;i++) {
|
Person ps=person_vector.get(i);
|
String p_online=ps.getP_online();
|
if(p_online.equals("1")) {
|
vp_online.add(p_online);
|
String p_tagid=ps.getP_tagid();
|
vp_tagid.add(p_tagid);
|
|
int intpx=ps.getP_x();
|
int intpy=ps.getP_y();
|
|
String p_x=String.valueOf(intpx);
|
vp_x.add(p_x);
|
|
String p_y=String.valueOf(intpy);
|
vp_y.add(p_y);
|
|
String p_floor=String.valueOf(ps.getP_floor());
|
vp_floor.add(p_floor);
|
|
String p_sos=ps.getSos_state();
|
vp_sos.add(p_sos);
|
|
String p_power=ps.getP_power();
|
vp_power.add(p_power);
|
|
String p_kaoqing=ps.getP_kaoqing();
|
vp_kaoqing.add(p_kaoqing);
|
|
String p_fence=ps.getP_fence();
|
vp_fence.add(p_fence);
|
|
String p_fencename=ps.getP_fencename();
|
vp_fencename.add(p_fencename);
|
|
String p_kaoqqingname=ps.getP_kaoqqingname();
|
vp_kaoqqingname.add(p_kaoqqingname);
|
|
String p_addtiem=ps.getP_addtiem();
|
vp_addtiem.add(p_addtiem);
|
|
String p_shipin=ps.getP_shipin();
|
vp_shipin.add(p_shipin);
|
|
String p_shipingname=ps.getP_shipingname();
|
vp_shipingname.add(p_shipingname);
|
|
//¾¶È
|
String jingdu=ps.getBaoliu2();
|
vp_baoliu2.add(jingdu);
|
|
//γ¶È
|
String weidu=ps.getBaoliu3();
|
vp_baoliu3.add(weidu);
|
|
//¸ß¶È
|
String gaodu=ps.getBaoliu4();
|
vp_baoliu4.add(gaodu);
|
|
//±êÇ©ÀàÐÍ
|
String baoliu5=ps.getBaoliu5();
|
vp_baoliu5.add(baoliu5);
|
|
//±êÇ©±»²ð³ý
|
String tagoff=ps.getTagoff();
|
vp_baoliu6.add(tagoff);
|
|
//±êÇ©µØÖ·
|
String baoliu8=ps.getBaoliu8();
|
vp_baoliu8.add(baoliu8);
|
|
//±êÇ©¶Ë¿Ú
|
String baoliu9=ps.getBaoliu9();
|
vp_baoliu9.add(baoliu9);
|
|
//Ïà¶Ôº£°Î¸ß¶È
|
String baoliu10=ps.getBaoliu10();
|
vp_baoliu10.add(baoliu10);
|
|
//GPS״̬
|
String baoliu13=ps.getGpsstate();
|
vp_baoliu13.add(baoliu13);
|
|
//GPS¾¶È¶È·Ö¸ñʽ
|
String baoliu14=ps.getJingdu();
|
vp_baoliu14.add(baoliu14);
|
|
//GPSά¶È¶È·Ö¸ñʽ
|
String baoliu15=ps.getWeidu();
|
vp_baoliu15.add(baoliu15);
|
//ÐÄÂʸüÐÂ
|
String baoliu16=ps.getBaoliu16();
|
vp_baoliu16.add(baoliu16);
|
|
//½øÃÅ״̬
|
String baoliu20=ps.getJinmenstate()+"";
|
vp_baoliu20.add(baoliu20);
|
|
//³öÃÅ״̬
|
String baoliu21=ps.getChumenstate()+"";
|
vp_baoliu21.add(baoliu21);
|
|
//XY½âÀ´Ô´
|
String baoliu22=ps.getPosfrom()+"";
|
vp_baoliu22.add(baoliu22);
|
|
//±êÇ©µÄËÙ¶È
|
String baoliu23=get_sudu(intpx,intpy,ps);
|
vp_baoliu23.add(baoliu23);//´íÎó
|
}
|
}
|
|
if(vp_online.size() !=0) {
|
sql.append(getinfo(vp_x,"p_x",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_y,"p_y",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_floor,"p_floor",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_sos,"p_sos",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_online,"p_online",vp_tagid,"p_tagid")+" , ");
|
if(time10==10) {//10·ÖÖÓ¸üÐÂÒ»´ÎµçÁ¿
|
sql.append(getinfo(vp_power,"p_power",vp_tagid,"p_tagid")+" , ");
|
}
|
sql.append(getinfo(vp_kaoqing,"p_kaoqing",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_fence,"p_fence",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_fencename,"p_fencename",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_kaoqqingname,"p_kaoqqingname",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_addtiem,"p_addtiem",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_shipin,"p_shipin",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu2,"baoliu2",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu3,"baoliu3",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu4,"baoliu4",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu5,"baoliu5",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu6,"baoliu6",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu8,"baoliu8",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu9,"baoliu9",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu10,"baoliu10",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu13,"baoliu13",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu14,"baoliu14",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu15,"baoliu15",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu16,"baoliu16",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu20,"baoliu20",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu21,"baoliu21",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu22,"baoliu22",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_baoliu23,"baoliu23",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_shipingname,"p_shipingname",vp_tagid,"p_tagid")+" ");
|
sql.append(getlast(vp_tagid,"p_tagid"));
|
|
//¸üÐÂʵʱλÖÃÊý¾Ý±íx £»y £»z £»layer£»time
|
sql2.append(getinfo(vp_x,"x",vp_tagid,"tagid")+" , ");
|
sql2.append(getinfo(vp_y,"y",vp_tagid,"tagid")+" , ");
|
sql2.append(getinfo(vp_addtiem,"time",vp_tagid,"tagid")+" , ");
|
sql2.append(getinfo(vp_floor,"layer",vp_tagid,"tagid")+" ");
|
sql2.append(getlast(vp_tagid,"tagid"));
|
|
//¸üÐÂÊý¾Ý¿â
|
DatabaseManagement.update(sql.toString());
|
DatabaseManagement.update(sql2.toString());
|
}
|
}
|
//Çå¿Õ
|
sql.setLength(0);
|
//Çå¿Õ
|
sql2.setLength(0);
|
|
}
|
}
|
|
|
public static String getinfo(Vector<String> zhi,String name,Vector<String> tagid,String ziduan) {
|
StringBuffer sql=new StringBuffer(name+"= CASE "+ziduan+" ");
|
int size=tagid.size();
|
|
for (int i = 0; i < size; i++) {
|
if (zhi.size()>0) {
|
sql.append(" WHEN '" + tagid.get(i) + "' THEN '" + zhi.get(i) + "' ");
|
}else {
|
sql.append(" WHEN '" + tagid.get(i) + "' THEN '" + "-1" + "' ");
|
}
|
}
|
sql.append(" END ");
|
return sql.toString();
|
}
|
|
public static String getlast(Vector<String> tagid,String name) {
|
StringBuffer sql=new StringBuffer("WHERE "+name+" IN (");
|
int size=tagid.size();
|
for(int i=0;i<size;i++) {
|
|
if(i !=size-1) {
|
sql.append("'"+tagid.get(i)+"', ");
|
}else {
|
sql.append("'"+tagid.get(i)+"' )");
|
}
|
}
|
return sql.toString();
|
|
}
|
|
|
/**¸üÐÂtb_gpsÊý¾Ý±í*/
|
public static void tb_gps(int time10) {
|
|
int time= Shi_jian_cha_sss.get_time_cha_s(GetNowTime.now(),Urt_7000_port.getGspgengxin());
|
//Èç¹ûʱ¼ä²î´óÓÚ60Ãë±íʾûÓÐÊý¾ÝÉÏÀ´
|
if(time<120) {
|
StringBuffer sql=new StringBuffer("UPDATE tb_gps SET ");
|
Vector<String> vgps_utc_time=new Vector<String>();
|
Vector<String> vgps_weidu=new Vector<String>();
|
Vector<String> vgps_NS=new Vector<String>();
|
Vector<String> vgsp_jingdu=new Vector<String>();
|
Vector<String> vgps_EW=new Vector<String>();
|
Vector<String> vgps_state=new Vector<String>();
|
Vector<String> vgps_num=new Vector<String>();
|
Vector<String> vgps_hdop=new Vector<String>();
|
Vector<String> vgps_haiba_gao=new Vector<String>();
|
Vector<String> vgps_tuoqiu=new Vector<String>();
|
Vector<String> vgps_chafen_time=new Vector<String>();
|
Vector<String> vgps_chafen_id=new Vector<String>();
|
Vector<String> vgps_jiaoyan=new Vector<String>();
|
Vector<String> vtagid=new Vector<String>();
|
Vector<String> vgps_power=new Vector<String>();
|
Vector<String> vgps_sos=new Vector<String>();
|
Vector<String> vccid=new Vector<String>();
|
Vector<String> vversion=new Vector<String>();
|
Vector<String> vaddtime=new Vector<String>();
|
Vector<String> vbaoliu2=new Vector<String>();
|
Vector<String> vadress=new Vector<String>();
|
Vector<Tb_gps> gps_vector= Dell_gps.getGps_vector();
|
int size=gps_vector.size();
|
if(size !=0) {
|
for(int i=0;i<size;i++) {
|
Tb_gps gps=gps_vector.get(i);
|
String tagid=gps.getTagid();
|
Person prs=person_Dell.get_Person(tagid);
|
if(prs !=null) {
|
String onlie=prs.getP_online();
|
if(onlie.equals("1")) {
|
String wd=gps.getGps_weidu();
|
String jd=gps.getGsp_jingdu();
|
if(wd==null || wd.length()<3) {
|
continue;
|
}
|
jd=xytognss.dd2d(wd,jd)[0];
|
wd=xytognss.dd2d(wd,jd)[1];
|
vadress.add(gps.getAdress());
|
vgps_utc_time.add(gps.getGps_chafen_time());
|
vgps_weidu.add(wd);
|
vgps_NS.add(gps.getGps_NS());
|
vgsp_jingdu.add(jd);
|
vgps_EW.add(gps.getGps_EW());
|
vgps_state.add(gps.getGps_state());
|
vgps_num.add(gps.getGps_num());
|
vgps_hdop.add(gps.getGps_hdop());
|
vgps_haiba_gao.add(gps.getGps_haiba_gao());
|
vgps_tuoqiu.add(gps.getGps_tuoqiu());
|
vgps_chafen_time.add(gps.getGps_chafen_time());
|
vgps_chafen_id.add(gps.getGps_chafen_id());
|
vgps_jiaoyan.add(gps.getGps_jiaoyan());
|
vtagid.add(gps.getTagid());
|
vgps_power.add(gps.getGps_power());
|
vgps_sos.add(gps.getGps_sos());
|
vccid.add(gps.getCcid());
|
vversion.add(gps.getVersion());
|
vaddtime.add(gps.getAddtime());
|
vbaoliu2.add(prs.getP_shipin()+";"+prs.getP_shipingname());
|
}
|
}
|
}
|
}
|
|
if(vgps_weidu.size()>0) {
|
sql.append(getinfo(vgps_utc_time,"gps_utc_time",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_weidu,"gps_weidu",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_NS,"gps_NS",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgsp_jingdu,"gsp_jingdu",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_EW,"gps_EW",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_state,"gps_state",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_num,"gps_num",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_hdop,"gps_hdop",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_haiba_gao,"gps_haiba_gao",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_tuoqiu,"gps_tuoqiu",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_chafen_id,"gps_chafen_id",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_jiaoyan,"gps_jiaoyan",vtagid,"tagid")+" , ");
|
if(time10==10) {//10·ÖÖÓ¸üÐÂÒ»´ÎµçÁ¿
|
sql.append(getinfo(vgps_power,"gps_power",vtagid,"tagid")+" , ");
|
}
|
if(vadress.size()!=0) {
|
sql.append(getinfo(vadress,"adress",vtagid,"tagid")+" , ");
|
}
|
sql.append(getinfo(vgps_sos,"gps_sos",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vaddtime,"addtime",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vccid,"ccid",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vversion,"version",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vbaoliu2,"baoliu2",vtagid,"tagid")+" , ");
|
sql.append(getinfo(vgps_chafen_time,"gps_chafen_time",vtagid,"tagid")+" ");
|
sql.append(getlast(vtagid,"tagid"));
|
DatabaseManagement.update(sql.toString());
|
sql.setLength(0);//Çå¿Õ
|
}
|
}
|
}
|
|
|
/**¸üÐÂtb_tag±êÇ©*/
|
public static void tb_tag() {
|
Vector<Tag> tag_vector =Tag_Dell.getTag_vector();
|
int size=tag_vector.size();
|
if(size !=0) {
|
StringBuffer sql=new StringBuffer("UPDATE tb_tag SET ");
|
Vector<String> vtag_id=new Vector<String>();
|
Vector<String> vpower=new Vector<String>();
|
Vector<String> vstatus=new Vector<String>();
|
Vector<String> vgaodu=new Vector<String>();
|
Vector<String> vversion=new Vector<String>();
|
Vector<String> vpinglv=new Vector<String>();
|
for(int i=0;i<size;i++) {
|
Tag tb=tag_vector.get(i);
|
vtag_id.add(tb.getTag_id());
|
vpower.add(tb.getTag_power());
|
vstatus.add(tb.getTag_state());
|
vgaodu.add(tb.getTag_pos_z());
|
vversion.add(tb.getVersoin());
|
vpinglv.add(tb.getTag_pinglv());
|
}
|
|
sql.append(getinfo(vpower,"power",vtag_id,"tag_id")+" , ");
|
sql.append(getinfo(vstatus,"status",vtag_id,"tag_id")+" , ");
|
sql.append(getinfo(vgaodu,"gaodu",vtag_id,"tag_id")+" , ");
|
sql.append(getinfo(vversion,"version",vtag_id,"tag_id")+" , ");
|
sql.append(getinfo(vpinglv,"pinglv",vtag_id,"tag_id")+" ");
|
sql.append(getlast(vtag_id,"tag_id"));
|
//¸üÐÂÊý¾Ý¿â
|
DatabaseManagement.update(sql.toString());
|
//Çå¿Õ
|
sql.setLength(0);
|
|
}
|
}
|
|
/**¹Ø»úʱºò¸üÐÂ×îºóλÖÃ*/
|
public static void alert_last_pos() {
|
Vector<Person> person_vector=person_Dell.getPerson_vector();
|
int size=person_vector.size();
|
if(size !=0) {
|
StringBuffer sql=new StringBuffer("UPDATE tb_person SET ");
|
StringBuffer sql2=new StringBuffer("UPDATE tb_realocation SET ");
|
Vector<String> vp_tagid=new Vector<String>();
|
Vector<String> vp_x=new Vector<String>();
|
Vector<String> vp_y=new Vector<String>();
|
Vector<String> vp_floor=new Vector<String>();
|
Vector<String> vp_sos=new Vector<String>();
|
Vector<String> vp_online=new Vector<String>();
|
Vector<String> vp_power=new Vector<String>();
|
Vector<String> vp_kaoqing=new Vector<String>();
|
Vector<String> vp_fence=new Vector<String>();
|
Vector<String> vp_fencename=new Vector<String>();
|
Vector<String> vp_kaoqqingname=new Vector<String>();
|
Vector<String> vp_addtiem=new Vector<String>();
|
Vector<String> vp_shipin=new Vector<String>();
|
Vector<String> vp_shipingname=new Vector<String>();
|
|
for(int i=0;i<size;i++) {
|
Person ps=person_vector.get(i);
|
String p_tagid=ps.getP_tagid();
|
vp_tagid.add(p_tagid);
|
|
|
String p_x=String.valueOf(ps.getP_x());
|
vp_x.add(p_x);
|
|
String p_y=String.valueOf(ps.getP_y());
|
vp_y.add(p_y);
|
|
String p_floor=String.valueOf(ps.getP_floor());
|
vp_floor.add(p_floor);
|
|
String p_sos=ps.getSos_state();
|
vp_sos.add(p_sos);
|
|
String p_online=ps.getP_online();
|
vp_online.add(p_online);
|
|
String p_power=ps.getP_power();
|
vp_power.add(p_power);
|
|
String p_kaoqing=ps.getP_kaoqing();
|
vp_kaoqing.add(p_kaoqing);
|
|
String p_fence=ps.getP_fence();
|
vp_fence.add(p_fence);
|
|
String p_fencename=ps.getP_fencename();
|
vp_fencename.add(p_fencename);
|
|
String p_kaoqqingname=ps.getP_kaoqqingname();
|
vp_kaoqqingname.add(p_kaoqqingname);
|
|
String p_addtiem=ps.getP_addtiem();
|
vp_addtiem.add(p_addtiem);
|
|
String p_shipin=ps.getP_shipin();
|
vp_shipin.add(p_shipin);
|
|
String p_shipingname=ps.getP_shipingname();
|
vp_shipingname.add(p_shipingname);
|
|
|
}
|
sql.append(getinfo(vp_x,"p_x",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_y,"p_y",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_floor,"p_floor",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_sos,"p_sos",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_online,"p_online",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_power,"p_power",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_kaoqing,"p_kaoqing",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_fence,"p_fence",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_fencename,"p_fencename",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_kaoqqingname,"p_kaoqqingname",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_addtiem,"p_addtiem",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_shipin,"p_shipin",vp_tagid,"p_tagid")+" , ");
|
sql.append(getinfo(vp_shipingname,"p_shipingname",vp_tagid,"p_tagid")+" ");
|
sql.append(getlast(vp_tagid,"p_tagid"));
|
|
//¸üÐÂʵʱλÖÃÊý¾Ý±íx £»y £»z £»layer£»time
|
sql2.append(getinfo(vp_x,"x",vp_tagid,"tagid")+" , ");
|
sql2.append(getinfo(vp_y,"y",vp_tagid,"tagid")+" , ");
|
sql2.append(getinfo(vp_addtiem,"time",vp_tagid,"tagid")+" , ");
|
sql2.append(getinfo(vp_floor,"layer",vp_tagid,"tagid")+" ");
|
sql2.append(getlast(vp_tagid,"tagid"));
|
|
|
//¸üÐÂÊý¾Ý¿â
|
DatabaseManagement.update(sql.toString());
|
DatabaseManagement.update(sql2.toString());
|
//Çå¿Õ
|
sql.setLength(0);
|
//Çå¿Õ
|
sql2.setLength(0);
|
|
}
|
|
}
|
|
|
/**¸üÐÂʵʱ¿¼ÇÚÊý¾Ý*/
|
public static void alert_realkaoqing() {
|
Vector<TbRealKaoQing> rkq=Dell_KaoQing.getrealkaoqings();
|
Tb_led tb_led = Leds.get_tb_led();
|
if (tb_led==null){
|
return;
|
}
|
boolean aled=tb_led.getShow_distance().equals("1");
|
int size=rkq.size();
|
if(size !=0) {
|
StringBuffer sql=new StringBuffer("UPDATE tb_realkaoqing SET ");
|
Vector<String> vcarea=new Vector<String>();
|
Vector<String> vcname=new Vector<String>();
|
Vector<String> vcbumen=new Vector<String>();
|
Vector<String> vctagid=new Vector<String>();
|
Vector<String> vcintime=new Vector<String>();
|
Vector<String> vcjuli=new Vector<String>();
|
Vector<String> vcbaoliu1=new Vector<String>();
|
|
for(int i=0;i<size;i++) {
|
TbRealKaoQing tbrk=rkq.get(i);
|
vcarea.add(tbrk.getArea());
|
vcname.add(tbrk.getName());
|
vcbumen.add(tbrk.getBumen());
|
vctagid.add(tbrk.getTagid());
|
vcintime.add(tbrk.getTime2());
|
if(aled) {
|
int x=tbrk.getX();
|
int y=tbrk.getY();
|
int x00=0;
|
int y00=0;
|
String name=tbrk.getArea();
|
String kq1name=Fences.kaoqing_name(0);//¿¼ÇÚÇøÓò1Ãû³Æ
|
if(name.equals(kq1name)) {
|
String x0y0=Leds.get_tb_led().getBaoliu1();
|
String[] a=x0y0.split(",");
|
if(a.length==2) {
|
x00=Integer.parseInt(a[0]);
|
y00=Integer.parseInt(a[1]);
|
}
|
}else {
|
String x1y1=Leds.get_tb_led().getBaoliu2();
|
String[] a=x1y1.split(",");
|
if(a.length==2) {
|
x00=Integer.parseInt(a[0]);
|
y00=Integer.parseInt(a[1]);
|
}
|
}
|
|
double dis=Math.sqrt((x-x00)*(x-x00)+(y-y00)*(y-y00))/100;
|
int distance=new Double(dis).intValue();
|
vcjuli.add(distance+"");
|
}
|
|
vcbaoliu1.add("1");
|
}
|
//¸üÐÂʵÊý¾Ý±í
|
try {
|
sql.append(getinfo(vcarea,"area",vctagid,"tagid")+" , ");
|
sql.append(getinfo(vcname,"name",vctagid,"tagid")+" , ");
|
sql.append(getinfo(vcbumen,"bumen",vctagid,"tagid")+" , ");
|
sql.append(getinfo(vcjuli,"juli",vctagid,"tagid")+" , ");
|
sql.append(getinfo(vcbaoliu1,"baoliu1",vctagid,"tagid")+" , ");
|
sql.append(getinfo(vcintime,"intime",vctagid,"tagid")+" ");
|
sql.append(getlast(vctagid,"tagid"));
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
//¸üÐÂÊý¾Ý¿â
|
DatabaseManagement.update(sql.toString());
|
//Çå¿Õ
|
sql.setLength(0);
|
}
|
}
|
|
|
/**¸üÐÂʵʱÆøÌåÊý¾Ý*/
|
public static void alert_realgas() {
|
Vector<TbGas> TbGass=Get_Tb_Gass .get_gass();
|
int size=TbGass.size();
|
if(size !=0) {
|
StringBuffer sql=new StringBuffer("UPDATE tb_gas SET ");
|
|
Vector<String> vcid=new Vector<String>();
|
Vector<String> vcnong_du=new Vector<String>();
|
Vector<String> vcstatus=new Vector<String>();
|
Vector<String> vcaddtime=new Vector<String>();
|
|
for(int i=0;i<size;i++) {
|
TbGas tbgs=TbGass.get(i);
|
vcid.add(String.valueOf(tbgs.getId()));
|
vcnong_du.add(tbgs.getNong_du());
|
vcstatus.add(tbgs.getStatus());
|
vcaddtime.add(tbgs.getAddtime());
|
}
|
//¸üÐÂʵÊý¾Ý±í
|
sql.append(getinfo(vcnong_du,"nong_du",vcid,"id")+" , ");
|
sql.append(getinfo(vcstatus,"status",vcid,"id")+" , ");
|
sql.append(getinfo(vcaddtime,"addtime",vcid,"id")+" ");
|
sql.append(getlast(vcid,"id"));
|
//¸üÐÂÊý¾Ý¿â
|
DatabaseManagement.update(sql.toString());
|
//Çå¿Õ
|
sql.setLength(0);
|
}
|
}
|
|
/**»ñÈ¡±êÇ©5ÃëµÄËÙ¶È*/
|
public static String get_sudu(int x,int y,Person ps) {
|
String sudu="0,0";
|
String time=ps.getLasttime();//ÉÏÒ»´ÎλÖøüÐÂʱ¼ä
|
String time5=ps.getLast5s();//ÉÏÒ»¸ö5Ãëʱ¼ä
|
if(time !=null) {
|
if(time5 ==null) {
|
ps.setLast5s(GetNowTime.now());
|
}else {
|
int b= Shi_jian_cha_sss.get_time_cha_s(time,time5);
|
if(b>5) {//Èç¹ûʱ¼ä²î´óÓÚ5Ãë
|
int x5=ps.getPosx5s();//±êÇ©5ÃëÇ°µÄx×ø±ê
|
int y5=ps.getPosy5s();//±êÇ©5ÃëÇ°µÄy×ø±ê
|
sudu=(x-x5)+","+(y-y5);
|
ps.setPosx5s(x);
|
ps.setPosy5s(y);
|
ps.setLast5s(GetNowTime.now());
|
}
|
}
|
}
|
return sudu;
|
}
|
|
}
|
