package tag;
|
import java.math.BigInteger;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import BaoWen.Dell_55AA0A;
|
import DataBase.DatabaseManagement;
|
import Judge.JugeNumber;
|
import Method.GetNowTime;
|
import Method.InsertData;
|
import PbuliClass.ShowMessage;
|
import PbuliClass.Systems;
|
import engbs.engine_do;
|
import fence.kaoqing.Dell_tbreallkaoqing;
|
import home.Open_soft_dialog;
|
import person.Person;
|
import person.person_Dell;
|
import tagpower.Dell_tagpower;
|
import tbDataModel.TbWaring;
|
import tbDataModel_Dell.Dell_ReallPoint;
|
import tbDataModel_Dell.Dell_tag_gas_jiaozhun_value;
|
import tbDataModel_Dell.Department_Dell;
|
import tbDataModel_Dell.Tb_Warnig_Dell;
|
|
@SuppressWarnings("rawtypes")
|
public class Tag_Dell {
|
static Vector<Tag> tag_vector = new Vector<Tag>();// ±êÇ©µÄ¼¯ºÏ
|
static String tagon = "image/icon/tagon.png";
|
static String tagoff = "image/icon/tagoff.png";
|
static boolean suidaomoshi=Systems.sys().getTunlDw().equals("1");
|
|
/** »ñÈ¡Êý¾Ý¿âÖÐËùÓбêÇ© */
|
static {
|
Open_soft_dialog.addara("¼ÓÔØtb_tag");
|
String sql = "select * from tb_tag order by tag_id ASC ";
|
Iterator iterator = DatabaseManagement.serch(sql).iterator();
|
while (iterator.hasNext()) {// µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();// ½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
|
Tag tag = new Tag();
|
tag.setXuhao((String) info.get(0));
|
String tagid=(String)info.get(1);
|
tag.setTag_id(tagid);
|
tag.setTag_name((String) info.get(2));
|
String power=(String) info.get(3);
|
tag.setTag_power(power);
|
tag.setTag_state("0");
|
tag.setTag_pos_z((String) info.get(5));
|
String sulv=(String) info.get(6);//ËÙÂÊ
|
String tagspeed_limit=sulv;
|
if(sulv.equals("ÎÞ") || sulv.equals("")) {
|
tagspeed_limit="1000";
|
}
|
tag.setTag_sulv(tagspeed_limit);
|
String hz=(String) info.get(7);
|
if(hz.equals("0.1")) {
|
tag.setDoublehz(0.1);
|
hz="1";
|
}
|
int hzint=Integer.parseInt(hz);
|
|
if(hzint==0 || hzint<0) {
|
ShowMessage.zidingyi_24(tagid+"±êǩƵÂʲ»ÄÜΪ0");
|
}
|
|
tag.setTag_pinglv(hz);
|
tag.setSleep_satus((String) info.get(8));
|
tag.setSleep_time((String) info.get(9));
|
tag.setGongfang((String) info.get(10));
|
tag.setDong_status((String) info.get(11));
|
String vrs=(String) info.get(12);
|
if(vrs==null || vrs.equals("null")||vrs.equals("-1")) {
|
vrs="δ֪";
|
}
|
tag.setVersoin(vrs);
|
tag.setTag_greattime((String) info.get(13));
|
tag.setImu((String) info.get(14));
|
String gpsstate=(String) info.get(15);
|
tag.setSleep_satus("-1");//ÉèÖñêÇ©³õʼ״̬
|
int gps_state=0;
|
if(gpsstate !=null ) {
|
if(gpsstate.equals("1")) {
|
gps_state=1;
|
}
|
}
|
tag.setGps_state(gps_state);
|
// ³õʼ»¯½«±êÇ©µÍµçÁ¿¸æ¾¯×´Ì¬ÉèÖÃΪ0
|
tag.setTag_floor("0");
|
//±êÇ©µÄʵʱ¸ß¶È
|
String a=(String) info.get(5);
|
int tagz=150;
|
if(a.length()>2) {
|
if(!JugeNumber.isDigit(a)) {
|
a="150";
|
}
|
tagz=Integer.parseInt((a));
|
}
|
if(Dell_tagpower.get_tag(tagid)==null) {
|
Dell_tagpower.add(tagid, (String) info.get(2),(String) info.get(7), (String) info.get(3));
|
}
|
|
tag.setTag_z(tagz);
|
|
//À¡Ïß³¤¶È
|
String baoliu3=(String) info.get(19);
|
if(baoliu3==null) {
|
tag.setBaoliu3(0);
|
}else{
|
int b3=Integer.parseInt(baoliu3);
|
tag.setBaoliu3(b3);
|
}
|
|
String type=(String) info.get(27);//±êÇ©ÀàÐÍ
|
if(type==null) {
|
type="ϵͳĬÈÏ";
|
}
|
tag.setTagtype(type);
|
tag.setLixian(3);
|
tag.setXiumian(3);
|
tag.setJingzhi(3);
|
tag.setTag_sos("3");
|
tag.setAlertsucc(0);
|
tag.setWuxiaoquyu(0);
|
tag.setNowzhuceanchor("0");//±êÇ©µ±Ç°ÉÏÀ´µÄ×¢²á»ùÕ¾
|
tag.setTag_power("-1");
|
tag.setDong_status("-1");
|
Person person=person_Dell.get_Person(tagid);
|
if(person==null) {
|
person_Dell.add_person(tagid, "ϵͳĬÈÏ", (String) info.get(2), "ÄÐ","",sulv,type);
|
}else {
|
person.setTagneedhz(hzint);//±êÇ©ÐèÒªµÄƵÂÊ
|
}
|
tag_vector.add(tag);
|
|
}
|
}
|
|
/** ͨ¹ý±êÇ©id»ñȡijһ¸ö±êÇ©¶ÔÏó */
|
public static Tag get_tag(String tagid) {
|
Tag tag = null;
|
if (tag_vector.size() != 0) {
|
Iterator<Tag> it = tag_vector.iterator();
|
while (it.hasNext()) {
|
Tag tag1 = it.next();
|
String idtag = tag1.getTag_id();
|
if (tagid.equals(idtag)) {
|
tag = tag1;
|
break;
|
}
|
}
|
}
|
|
return tag;
|
}
|
|
/** ͨ¹ýÐÕÃûÕÒµ½±êÇ©ID */
|
public static String get_tagid(String name) {
|
String tagid = "";
|
int i = 0;
|
if (tag_vector.size() != 0) {
|
Iterator<Tag> it = tag_vector.iterator();
|
while (it.hasNext()) {
|
Tag tag1 = it.next();
|
String name1 = tag1.getTag_name();
|
if (name.equals(name1)) {
|
tagid = tag1.getTag_id();
|
i++;
|
}
|
}
|
}
|
|
if (i != 1) {
|
ShowMessage.zidingyi_24("ÐÕÃû" + name + "´æÔÚÖØÃû" + i + "¸öÇëÊäÈëIDºÅ²éѯ£¡");
|
tagid = "´æÔÚÖØÃû";
|
}
|
return tagid;
|
}
|
|
/**
|
* µ¼Èë±êÇ©µÄʱºòÏò±êÇ©¼¯ºÏÌí¼Ó±êÇ©
|
*
|
* @param tagid ±êÇ©id
|
* @param state ±êÇ©°ó¶¨µÄ¶ÔÏó
|
* @param tag_pos_z ±êÇ©Åå´÷¸ß¶È
|
* @param tag_pinglv ±êÇ©µÄƵÂÊ
|
* @param String tag_sulv ±êÇ©µÄËÙÂÊ
|
*/
|
public static void add_tag_from_ecxel(
|
String tagid,
|
String state,
|
String tag_pos_z,
|
String tag_pinglv,
|
String tag_sulv) {
|
if (get_tag(tagid) == null) {
|
String power = "100";
|
String tatus = "ÔÚÏß";
|
Tag newtag = new Tag();
|
newtag.setTag_id(tagid);
|
newtag.setTag_name(state);
|
newtag.setTag_pos_z(tag_pos_z);
|
newtag.setTag_pinglv(tag_pinglv);
|
newtag.setTag_power(power);
|
newtag.setTag_state(tatus);
|
newtag.setTag_sulv(tag_sulv);
|
newtag.setTag_greattime(GetNowTime.now());
|
tag_vector.add(newtag);
|
person_Dell.add_person(tagid, "ϵͳĬÈÏ", state, "ÄÐ", "",tag_sulv,"ϵͳĬÈÏ");
|
if(suidaomoshi) {
|
Dell_tbreallkaoqing.add_in_data(tagid);
|
}
|
}
|
}
|
|
/** ¸Ä±ä±êÇ©µÄ״̬ÊÇ·ñÔÚÏß */
|
public static void set_tagstatus(String tagid, String status, String power) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_state(status);
|
|
String[] ziduan = { "status", "power", "tag_id" };
|
String[] zhi = { status, power, tagid };
|
DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
|
}
|
}
|
|
/**Ð޸ıêÇ©µÄ״̬ÊÇ·ñÔÚÏß*/
|
public static void alert_online(String tagid) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_state("1");
|
}
|
}
|
|
/**Ð޸ıêǩ״̬ºÍÊý¾Ý¿âÎÞ¹Ø*/
|
public static void set_tagstatus2(String tagid, String status, String power) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_state(status);
|
get_tag(tagid).setTag_power(power);
|
}
|
}
|
|
/** ±êÇ©ÀëÏß */
|
public static void tag_offline(String tagid, String status) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_state(status);
|
String[] ziduan = { "status", "tag_id" };
|
String[] zhi = { status, tagid };
|
DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
|
ziduan = null;
|
zhi = null;
|
}
|
}
|
|
/** »ñÈ¡ËùÓбêÇ©µÄidµÄ¼¯ºÏ */
|
public static String[] get_tag_str() {
|
String[] tagsring = new String[tag_vector.size() + 1];
|
tagsring[0] = "Ñ¡Ôñ±êÇ©";
|
if (tag_vector.size() != 0) {
|
Iterator<Tag> it = tag_vector.iterator();
|
int i = 1;
|
while (it.hasNext()) {
|
Tag tag1 = it.next();
|
tagsring[i] = tag1.getTag_id();
|
i++;
|
}
|
}
|
|
return tagsring;
|
}
|
|
/** ÐÞ¸ÄËùÓбêÇ©µÄƵÂÊ */
|
public static void alert_all_tag_hz(String hz) {
|
StringBuffer updateSQL = new StringBuffer("UPDATE tb_tag SET pinglv='" + hz + "'");
|
if (DatabaseManagement.update(updateSQL.toString()) != 0) {
|
Iterator<Tag> it = tag_vector.iterator();
|
while (it.hasNext()) {
|
it.next().setTag_pinglv(hz);
|
}
|
}
|
}
|
|
/** Ð޸ıêÇ©ÐÅÏ¢ */
|
public static void alert_tag(String tagid, String gaodu, String sudu) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_id(tagid);
|
get_tag(tagid).setTag_pos_z(gaodu);
|
get_tag(tagid).setTag_sulv(sudu);
|
}
|
}
|
|
/** Ð޸ıêǩƵÂÊ */
|
public static void alert_taghz(String tagid,String pinglv) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_id(tagid);
|
get_tag(tagid).setTag_pinglv(pinglv);
|
}
|
}
|
|
/** Ð޸ļ¯ºÏÖÐËùÓеıêÇ©ÐÅÏ¢ */
|
public static void alert_all(String gaodu, String sudu, String pinglv) {
|
if (tag_vector.size() != 0) {
|
for (int i = 0; i < tag_vector.size(); i++) {
|
Tag tag = tag_vector.get(i);
|
tag.setTag_pinglv(pinglv);
|
tag.setTag_sulv(sudu);
|
tag.setTag_pos_z(gaodu);
|
}
|
}
|
}
|
|
/** Ð޸ļ¯ºÏÖÐËùÓеıêǩƵÂÊ */
|
public static void alert_hz( String pinglv) {
|
if (tag_vector.size() != 0) {
|
for (int i = 0; i < tag_vector.size(); i++) {
|
Tag tag = tag_vector.get(i);
|
tag.setTag_pinglv(pinglv);
|
}
|
}
|
}
|
|
|
/** Ð޸ıêÇ©ÐÅÏ¢ */
|
public static void alert_tag2(
|
String tagid,
|
String name,
|
String gaodu,
|
String sudu,
|
String pinglv,
|
String kuixian,
|
String tagtype) {
|
if (get_tag(tagid) != null) {
|
int baoliu3=Integer.parseInt(kuixian);
|
get_tag(tagid).setTag_id(tagid);
|
get_tag(tagid).setTag_name(name);
|
get_tag(tagid).setTag_pos_z(gaodu);
|
get_tag(tagid).setTag_sulv(sudu);
|
get_tag(tagid).setTag_pinglv(pinglv);
|
get_tag(tagid).setBaoliu3(baoliu3);
|
get_tag(tagid).setTagtype(tagtype);
|
double hz=Double.parseDouble(pinglv);
|
get_tag(tagid).setDoublehz(hz);
|
person_Dell.alert_person_name(tagid, name,tagtype);
|
}
|
}
|
|
/** Ôö¼ÓÒ»¸ö±êÇ©¶ÔÏóͬʱÊý¾Ý¿âÒ²Ôö¼ÓÌõÊý¾Ý */
|
public static void add_tag(
|
String tagid,
|
String name,
|
String gaodu,
|
String sudu,
|
String pinglv,
|
int kuixian,
|
String type,
|
int datafrom) {
|
if (get_tag(tagid) == null) {
|
Tag newtag = new Tag();
|
newtag.setTag_id(tagid);
|
newtag.setTag_name(name);
|
newtag.setTag_pos_z(gaodu);
|
newtag.setTag_sulv(sudu);
|
newtag.setTag_pinglv(pinglv);
|
newtag.setTag_power("δ֪");
|
newtag.setTag_greattime(GetNowTime.now());
|
newtag.setTag_state("1");
|
newtag.setAlertsucc(0);
|
newtag.setLixian(3);
|
newtag.setXiumian(3);
|
newtag.setJingzhi(3);
|
newtag.setTag_sos("3");
|
newtag.setAlertsucc(0);
|
newtag.setWuxiaoquyu(0);
|
newtag.setBaoliu3(kuixian);
|
newtag.setTagtype(type);
|
String kx=String.valueOf(kuixian);//À¡ÏßÎó²î
|
person_Dell.add_person(tagid, "ϵͳĬÈÏ",name, "ÄÐ", " ",sudu,type);
|
if(datafrom==1) {//Èç¹ûÊý¾ÝÀ´Ô´bs
|
String[] ziduan = { "tag_id", "state", "power", "status", "gaodu", "sudu", "pinglv", "baoliu3", "type","Addtime" };
|
String[] zhi = { tagid, name, "δ֪", "ÔÚÏß", gaodu, sudu, pinglv, kx,type,GetNowTime.now() };
|
DatabaseManagement.insertfast("tb_tag", ziduan, zhi);
|
}else {
|
String[] ziduan = { "tag_id", "state", "power", "status", "gaodu", "sudu", "pinglv", "baoliu3","type", "Addtime" };
|
String[] zhi = { tagid, name, "δ֪", "ÔÚÏß", gaodu, sudu, pinglv, kx,type,GetNowTime.now() };
|
DatabaseManagement.insertfast("tb_tag", ziduan, zhi);
|
}
|
tag_vector.add(newtag);
|
Dell_ReallPoint.add_tag_in_reallpint_vector(tagid);
|
Dell_tagpower.add(tagid, name,pinglv, "0");
|
if(suidaomoshi) {
|
Dell_tbreallkaoqing.add_in_data(tagid);
|
}
|
}
|
|
}
|
|
/** Ôö¼ÓÒ»¸ö±êÇ©´øÆøѹ¶ÔÏó */
|
public static void add_gastag(String tagid,String gaodu) {
|
if (get_tag(tagid) == null) {
|
Tag newtag = new Tag();
|
newtag.setTag_id(tagid);
|
newtag.setTag_name("Èýά²Î¿¼");
|
newtag.setBaoliu1("1");
|
newtag.setTag_sulv("10");
|
newtag.setTag_pinglv("1");
|
newtag.setTag_power("100");
|
newtag.setTag_greattime(GetNowTime.now());
|
String[] ziduan = { "tag_id", "state", "power", "status", "gaodu", "sudu", "pinglv","baoliu1", "Addtime" };
|
String[] zhi = { tagid, "Èýά²Î¿¼", "100", "ÔÚÏß", gaodu, "10", "1","1", GetNowTime.now() };
|
DatabaseManagement.insertfast("tb_tag", ziduan, zhi);
|
tag_vector.add(newtag);
|
}
|
|
}
|
|
/** Ôö¼ÓÒ»¸ö±êÇ©¶ÔÏóºÍÊý¾Ý¿âÎÞ¹Ø */
|
public static void add_tag2(String tagid, String name, String gaodu, String sudu, String pinglv) {
|
if (get_tag(tagid) == null) {
|
Tag newtag = new Tag();
|
newtag.setTag_id(tagid);
|
newtag.setTag_name(name);
|
newtag.setTag_pos_z(gaodu);
|
newtag.setTag_sulv(sudu);
|
if(pinglv.equals("0")) {
|
ShowMessage.zidingyi_24(tagid+"±êǩƵÂʲ»ÄÜΪ0");
|
return;
|
}
|
newtag.setTag_pinglv(pinglv);
|
newtag.setTag_power("100");
|
newtag.setTag_greattime(GetNowTime.now());
|
person_Dell.add_person2(tagid, "ϵͳĬÈÏ", name, "ÄÐ", " ");
|
tag_vector.add(newtag);
|
}
|
|
}
|
|
|
/**ÐÞ¸ÄGPS״̬*/
|
public static void alert_gps_state(String tagid,int state) {
|
if(get_tag(tagid) !=null) {
|
get_tag(tagid).setGps_state(state);
|
String[] ziduan = {"gps_state", "tag_id" };
|
String[] zhi = {String.valueOf(state) ,tagid};
|
DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
|
}
|
|
}
|
|
/** ÈËÔ±µ¼ÈëµÄʱºòµ÷ÓÃÓÃÓÚÔö¼Ó±êÇ©¡¢²¿ÃÅ¡¢ÈËÔ± */
|
public static boolean addtag_person_excel_into(
|
String tagid,
|
String name,
|
String bumen,
|
String sex,
|
String phone) {
|
boolean succ = false;
|
Department_Dell.add_bumen_fromperson(bumen);
|
if (get_tag(tagid) == null) {// Èç¹û±êÇ©²»´æÔÚ
|
Tag newtag = new Tag();
|
newtag.setTag_id(tagid);
|
tag_vector.add(newtag);
|
|
String[] ziduan = { "tag_id", "state", "power", "status", "gaodu", "sudu", "pinglv", "Addtime" };
|
String[] zhi = { tagid, name, "100", "ÔÚÏß", "150", "100000", "1", GetNowTime.now()};
|
DatabaseManagement.insertfast("tb_tag", ziduan, zhi);
|
|
String p_image="image/targeticon/default.png";
|
String[] ziduan2= {
|
"p_name",
|
"p_tagid",
|
"p_sex",
|
"p_minzu",
|
"p_phone",
|
"p_department",
|
"p_x",
|
"p_y",
|
"p_floor",
|
"p_sos",
|
"p_online",
|
"p_power",
|
"p_kaoqing",
|
"p_fence",
|
"p_image",
|
"p_addtiem"};
|
|
String[] zhi2= {
|
name,
|
tagid,
|
sex,
|
"ºº",
|
phone,
|
bumen,
|
"0",
|
"0",
|
"0",
|
"0",
|
"0",
|
"100",
|
"0",
|
"0",
|
p_image,
|
GetNowTime.now()
|
};
|
DatabaseManagement.insertfast("tb_person", ziduan2, zhi2);
|
if(suidaomoshi) {
|
Dell_tbreallkaoqing.add_in_data(tagid);
|
}
|
succ = true;
|
}
|
return succ;
|
}
|
|
/** ¸Ä±ä±êÇ©µÄµçÁ¿×´Ì¬ */
|
public static void set_tagpower(String tagid, String power) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_power(power);
|
get_tag(tagid).setTag_state("1");
|
get_tag(tagid).setTag_power_date(GetNowTime.now());
|
int powerint = Integer.parseInt(power);
|
alert_tag_low_power(tagid,powerint);
|
}
|
}
|
|
/** ¸Ä±ä±êÇ©µÄµçÁ¿×´Ì¬ */
|
public static void set_URTXTB(String tagid) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_state("1");
|
get_tag(tagid).setTag_power_date(GetNowTime.now());
|
}
|
}
|
|
/**
|
* Ð޸ıêÇ©µÄX,Y,Z×ø±ê
|
*
|
* @param tagid ±êÇ©µÄid
|
* @param x ±êÇ©µÄx×ø±ê
|
* @param y ±êÇ©µÄY×ø±ê
|
* @param floor ±êÇ©ËùÔÚµÄÂ¥²ã
|
*/
|
public static void alert_xy_and_floor(String tagid, int x, int y,int z,String floor) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_pos_x(x);
|
get_tag(tagid).setTag_pos_y(y);
|
get_tag(tagid).setTag_z(z);//±êÇ©µÄʵʱ¸ß¶È
|
get_tag(tagid).setTag_floor(floor);
|
}
|
|
}
|
|
/**¸üбêǩ״̬ºÍʱ¼ä*/
|
public static void tagstate(String tagid) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_state("1");
|
}
|
}
|
|
/**¸üÐÂURT±êÇ©µÄʱ¼ä¡¢×´Ì¬¡¢°æ±¾¡¢µçÁ¿*/
|
public static void tagstate3(String tagid,String versoin) {
|
if (get_tag(tagid) != null) {
|
get_tag(tagid).setTag_state("1");
|
if(versoin==null) {
|
versoin="δ֪";
|
}
|
get_tag(tagid).setVersoin(versoin);
|
}
|
}
|
|
/** ɾ³ýij¸ö±êÇ© */
|
public static void remove_tag(String tagid) {
|
if (get_tag(tagid) != null) {
|
tag_vector.remove(get_tag(tagid));
|
Dell_tagpower.delte(tagid);
|
person_Dell.remove_person_and_database(tagid);
|
Dell_tag_gas_jiaozhun_value.delete_tag_gas_jiaozhun_value(tagid, 1);
|
if(suidaomoshi) {
|
Dell_tbreallkaoqing.delete_data(tagid);
|
}
|
String deleteSql="DELETE FROM tb_tag WHERE tag_id='"+tagid+"'";
|
DatabaseManagement.update(deleteSql);
|
}
|
}
|
|
/** ɾ³ý¼¯ºÏÖÐËùÓеıêÇ© */
|
public static void removeall_tag() {
|
if (tag_vector.size() != 0) {
|
tag_vector.removeAllElements();
|
Dell_tagpower.delteall();
|
if(suidaomoshi) {
|
Dell_tbreallkaoqing.deleteall();
|
}
|
}
|
}
|
|
public static Vector<Tag> getTag_vector() {
|
return tag_vector;
|
}
|
|
/** ËÑË÷ij¸ö±êÇ© */
|
public static Vector<Tag> serchtag(String name) {
|
|
Vector<Tag> tagvect = new Vector<Tag>();
|
if (tag_vector.size() != 0) {
|
Iterator<Tag> it = tag_vector.iterator();
|
while (it.hasNext()) {
|
Tag tag1 = it.next();
|
String idtag = tag1.getTag_id();
|
String name1 = tag1.getTag_name();
|
if (idtag.equals(name) || name1.equals(name)) {
|
tagvect.add(tag1);
|
}
|
}
|
}
|
return tagvect;
|
|
}
|
|
|
/** »ñÈ¡±êÇ©×é */
|
public static Vector<String> tagzu() {
|
Vector<String> zu = new Vector<String>();
|
zu.add("FFFF");
|
zu.add("0000");
|
return zu;
|
}
|
|
/** »ñÈ¡ËùÓбêÇ©µÄ¼¯ºÏ */
|
public static String[] GetTagAllstr() {
|
int size = tag_vector.size() + 1;
|
String[] tagall = new String[size];
|
tagall[0] = "ËùÓбêÇ©";
|
if (size > 1) {
|
for (int i = 0; i < size - 1; i++) {
|
tagall[i + 1] = tag_vector.get(i).getTag_id();
|
}
|
}
|
|
return tagall;
|
}
|
|
/** 16½øÖÆתΪ10½øÖÆ */
|
public static int decodeHEX(String hexs) {
|
BigInteger bigint = new BigInteger(hexs, 16);
|
int numb = bigint.intValue();
|
return numb;
|
|
}
|
|
public static String getTagon() {
|
return tagon;
|
}
|
|
public static String getTagoff() {
|
return tagoff;
|
}
|
|
/** Ð޸ıêÇ©µÄ°æ±¾¡¢ÆµÂÊ¡¢ */
|
public static void alert_tag(
|
String tagid,
|
String version,
|
String move_open,
|
String sleep_open,
|
String button,
|
int gonglv,
|
int speed, // ¼ÓËÙ¶ÈãÐÖµ
|
int sleep_time,
|
int power,
|
int gas) {
|
|
Tag tag=get_tag(tagid);
|
if ( tag!= null) {
|
tag.setVersoin(version);
|
tag.setGongfang(String.valueOf(gonglv));
|
tag.setSleep_satus(sleep_open);
|
tag.setSleep_time(String.valueOf(sleep_time));
|
tag.setImu(String.valueOf(speed));
|
tag.setDong_status(move_open);
|
tag.setTag_power(String.valueOf(power));
|
tag.setTag_state("1");
|
String[] ziduan = { "sleep_satus", "sleep_time", "gongfang", "dong_status", "version", "imu","tag_id" };
|
String[] zhi = { sleep_open, String.valueOf(sleep_time), String.valueOf(gonglv),
|
move_open, version, String.valueOf(speed), tagid };
|
DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
|
}
|
|
}
|
|
/**ÐÞ¸ÄURTµÄ²ÎÊý*/
|
public static void alert_urtcanshu(
|
String tagid,
|
String imujingzhitime,
|
String hz,
|
String gps_open,
|
String move_open,
|
String sleep_open,
|
String gonglv,
|
String speed,
|
String sleep_time,
|
String uwb_open,
|
String jiaozhun) {
|
|
Tag tag=get_tag(tagid);
|
if ( tag!= null) {
|
int p1=1000/Integer.parseInt(hz);
|
int gpsstate=Integer.parseInt(gps_open);
|
tag.setGongfang(gonglv);
|
tag.setJinghzi_time(imujingzhitime);
|
tag.setTag_pinglv(p1+"");
|
tag.setSleep_satus(sleep_open);
|
tag.setSleep_time(sleep_time);
|
tag.setImu(speed);
|
tag.setDong_status(move_open);
|
tag.setTag_state("1");
|
tag.setGps_state(gpsstate);
|
String[] ziduan = {"gps_state","sleep_satus", "sleep_time", "gongfang", "dong_status", "imu","tag_id" };
|
String[] zhi = {gps_open,sleep_open, sleep_time,gonglv,move_open,speed, tagid };
|
DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
|
}
|
|
}
|
|
|
/** Ð޸ıêÇ©µÄµÍµçÁ¿±¨¾¯×´Ì¬ */
|
public static void alert_tag_low_power(String tagid, int power) {
|
Person person = person_Dell.get_Person(tagid);
|
if(person==null){
|
return;
|
}
|
String p_power_wanig = person.getP_power_wanig();
|
if(power<15) {
|
if (p_power_wanig==null){
|
p_power_wanig="-1";
|
}
|
if (p_power_wanig.equals("0")){
|
return;
|
}else {
|
person.setP_power_wanig("0");
|
}
|
}
|
|
}
|
|
/**Ð޸ıêÇ©°ó¶¨µÄÐÕÃû*/
|
public static void alert_tag_name(String tagid,String tag_name) {
|
if(get_tag(tagid) !=null) {
|
get_tag(tagid).setTag_name(tag_name);
|
String[] ziduan = {"state","addtime","tag_id" };
|
String[] zhi = { tag_name, GetNowTime.now(),tagid };
|
DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
|
}
|
|
}
|
|
/**¹Ì¶¨Ê±¼ä¸üбêÇ©µçÁ¿Êý¾Ý¿â±í
|
* tagid
|
* power
|
* time
|
* hz
|
* name**/
|
public static void gengxin_database_tag_power() {
|
Vector<Person> prvc=person_Dell.getPerson_vector();
|
int size=prvc.size();
|
if(size==0) {
|
return;
|
}
|
StringBuffer sql=new StringBuffer("UPDATE tb_tagpower SET ");
|
StringBuffer sql2=new StringBuffer("UPDATE tb_person SET ");
|
Vector<String> vp_tagid=new Vector<String>();
|
Vector<String> vp_name=new Vector<String>();
|
Vector<String> vp_time=new Vector<String>();
|
Vector<String> vp_hz=new Vector<String>();
|
Vector<String> vp_power=new Vector<String>();
|
for(int i=0;i<size;i++) {
|
Person pr=prvc.get(i);
|
String tagid=pr.getP_tagid();
|
vp_tagid.add(tagid);
|
String tagname=pr.getP_name();
|
vp_name.add(tagname);
|
String pw=pr.getP_power();
|
int pwr=0;
|
if(pw ==null) {
|
pw="δ֪";
|
}else {
|
if(JugeNumber.isDigit(pw)) {
|
pwr = Integer.parseInt(pw);
|
if (pwr > 100) {
|
pw = "100";
|
pwr = 100;
|
}
|
String powerstate = pr.getP_power_wanig();
|
if (pwr > 15) {
|
|
pr.setP_power_wanig("0");
|
String sqlpowerwarning = "update tb_person set p_power_wanig='0' where p_tagid='" + tagid + "';";
|
DatabaseManagement.update(sqlpowerwarning);
|
if (Tb_Warnig_Dell.get_tbwarning(tagid) != null) {
|
TbWaring tbwarning = Tb_Warnig_Dell.get_tbwarning(tagid);
|
tbwarning.setStatus("ÒÑ´¦Àí");
|
String sqlpwr = "UPDATE tb_warning SET STATUS='ÒÑ´¦Àí',baoliu1='" + pwr + "' WHERE objectid='" + tagid + "' AND `type`='µÍµçÁ¿' AND `status`='δ´¦Àí';";
|
if (Tb_Warnig_Dell.get_tbwarning(tagid) != null) {
|
DatabaseManagement.update(sqlpwr);
|
|
}
|
}
|
} else {
|
if (powerstate.equals("0")) {//±êÇ©´¦Óڵ͵çÁ¿
|
pr.setP_power_wanig("1");
|
String sqlpowerwarning = "update tb_person set p_power_wanig='1' where p_tagid='" + tagid + "';";
|
DatabaseManagement.update(sqlpowerwarning);
|
InsertData.porInsertTbWarning(tagid, "δ´¦Àí", String.valueOf(pwr));//½«¸æ¾¯¼Ç¼³öÈëµ½Êý¾Ý¿â
|
}
|
}
|
}
|
}
|
|
|
vp_power.add(String.valueOf(pwr));
|
int hz=pr.getHz();
|
vp_hz.add(hz+"");
|
vp_time.add(pr.getP_addtiem());
|
}
|
//¸üÐÂʵʱλÖÃÊý¾Ý±íx £»y £»z £»layer£»time
|
sql.append(engine_do.getinfo(vp_name,"name",vp_tagid,"tagid")+" , ");
|
sql.append(engine_do.getinfo(vp_time,"time",vp_tagid,"tagid")+" , ");
|
sql.append(engine_do.getinfo(vp_hz,"hz",vp_tagid,"tagid")+" , ");
|
sql.append(engine_do.getinfo(vp_power,"power",vp_tagid,"tagid")+" ");
|
sql.append(engine_do.getlast(vp_tagid,"tagid"));
|
//¸üÐÂÊý¾Ý¿â
|
DatabaseManagement.update(sql.toString());
|
|
sql2.append(engine_do.getinfo(vp_power,"p_power",vp_tagid,"p_tagid")+" ");
|
sql2.append(engine_do.getlast(vp_tagid,"p_tagid"));
|
DatabaseManagement.update(sql2.toString());
|
|
|
|
}
|
|
/**»ñÈ¡ËùÓÐÔÚÏß±êÇ©²¢ÇÒÆøѹ¼Æ״̬Ϊȫ²¿Ð޸ĵļ¯ºÏ*/
|
public static Vector<Tag> tagonline_and_gasstate1(int gasstate0,String onlie) {
|
Vector<Tag> vec=new Vector<Tag>();
|
int size=tag_vector.size();
|
for(int i=0;i<size;i++) {
|
Tag tag=tag_vector.get(i);
|
String oline=tag.getTag_state();
|
int gasstate=tag.getGas_alert_state();
|
if(gasstate==gasstate0 && onlie.equals(oline)) {
|
vec.add(tag);
|
}
|
}
|
return vec;
|
|
}
|
|
/**½«±êÇ©µÄµçÁ¿×´Ì¬½«±êÇ©µçÁ¿Ð´ÈëÀúÊ·µçÁ¿Êý¾Ý¿â*/
|
public static void history_power() {
|
Vector<Person> person_vector=person_Dell.getPerson_vector();
|
int size=person_vector.size();
|
for(int i=0;i<size;i++) {
|
Person pr=person_vector.get(i);
|
String online=pr.getP_online();
|
if(online.equals("1")) {
|
String power=pr.getP_power();
|
if(!JugeNumber.isDigit(power)) {
|
continue;
|
}
|
String tagid=pr.getP_tagid();
|
int pow=Integer.parseInt(power);
|
if(pow>100 && pow>1) {
|
power="100";
|
}
|
String[] ziduan= {"tagid","power","time"};
|
String[] zhi= {tagid,power,GetNowTime.now()};
|
DatabaseManagement.insertfast("tb_history_power", ziduan, zhi);
|
}
|
}
|
}
|
|
/**ÓÐ55AA0c²â¾àÊý¾ÝµÄʱºò¸Ä±ä±êÇ©µÄµçÁ¿£¬ÔÚÏß״̬£¬ÐÝÃߣ¬SOS£¬²ð³ý״̬Êý¾Ý
|
* String tagid,
|
* int sos,
|
* int xiumianÐÝÃß״̬
|
* int power
|
* hz
|
* tagoff ±êÇ©²ð³ý״̬*/
|
public static void have550c_alert_tag(Tag tag,String tagid,String sos,String xiumian,int power) {
|
if(tag !=null) {
|
tag.setTag_sos(sos);
|
tag.setTag_greattime(GetNowTime.now());
|
tag.setTag_state("1");
|
tag.setTag_power(String.valueOf(power));
|
Tag_Dell.alert_tag_low_power(tagid,power);//µÍµçÁ¿¸æ¾¯
|
if(xiumian.equals("1")) {
|
Person prs=person_Dell.get_Person(tagid);
|
Dell_55AA0A.delete_pian(tagid,prs.getRealhz(),"±êÇ©ÐÝÃß");
|
}
|
}
|
}
|
|
/**Ð޸ıêÇ©ÀëÏßÐÝÃß¾²Ö¹×´Ì¬*/
|
public static void lxj(Tag tag,String tagid,String lixians,String xiumians,String jingzhis) {
|
if(tag !=null) {
|
int lixian=Integer.parseInt(lixians);
|
int xiumian=Integer.parseInt(xiumians);
|
int jingzhi=Integer.parseInt(jingzhis);
|
tag.setLixian(lixian);
|
tag.setXiumian(xiumian);
|
tag.setJingzhi(jingzhi);
|
}
|
}
|
|
|
|
/**ÉèÖÃurt×é*/
|
public static void alert_gas_data2(String tagid,String baoliu4) {
|
if(tagid.equals("ËùÓбêÇ©")) {
|
String updateSQL="UPDATE tb_tag SET "+"baoliu4='"+baoliu4+"'";
|
DatabaseManagement.update(updateSQL);
|
}else {
|
String[] ziduan= {"baoliu4","tag_id"};
|
String[] zhi= {baoliu4,tagid};
|
DatabaseManagement.fast_alert_dbase("tb_tag", ziduan, zhi);
|
int tag_baoliu4=Integer.parseInt(baoliu4);
|
get_tag(tagid).setBaoliu4(tag_baoliu4);;
|
|
}
|
}
|
|
|
|
/**ËùÓбêÇ©Ð޸ijɹ¦×´Ì¬ÉèÖÃΪ0*/
|
public static void alert_succ() {
|
if (tag_vector.size() != 0) {
|
for (int i = 0; i < tag_vector.size(); i++) {
|
Tag tag = tag_vector.get(i);
|
tag.setAlertsucc(0);
|
}
|
}
|
}
|
|
|
}
|
