Êþº¾ 3â com/hxzkoa/services/ZhwService java/lang/Object em !Ljavax/persistence/EntityManager; RuntimeVisibleAnnotations &Ljavax/persistence/PersistenceContext; cs #Lcom/hxzkoa/services/CaozuoService; 8Lorg/springframework/beans/factory/annotation/Autowired; <init> ()V Code
|
LineNumberTable LocalVariableTable this Lcom/hxzkoa/services/ZhwService; getMap $(Ljava/lang/String;)Ljava/util/List; Signature >(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_map;>; java/lang/StringBuilder iSELECT floor,mapname,x_Truelength,y_Truewidth,x0_length,y0_width,x_Pixel,y_Pixel FROM tb_map WHERE floor=
|
(Ljava/lang/String;)V
|
! " # append -(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
% & ' toString ()Ljava/lang/String; ) + - , javax/persistence/EntityManager . / createNativeQuery -(Ljava/lang/String;)Ljavax/persistence/Query; 1 3 2 javax/persistence/Query 4 5 getResultList ()Ljava/util/List; 7 java/util/ArrayList
|
6 : < ; java/util/List = > size ()I @ com/hxzkoa/json/tb_map
|
? : C D E get (I)Ljava/lang/Object; G [Ljava/lang/Object; I java/lang/String
|
? K L setFloor
|
? N O
|
setMapname
|
? Q R setX_Truelength
|
? T U setY_Truewidth
|
? W X setX0_length
|
? Z [ setY0_width
|
? ] ^
|
setX_Pixel
|
? ` a
|
setY_Pixel : c d e add (Ljava/lang/Object;)Z floor_number Ljava/lang/String; sql query Ljavax/persistence/Query;
|
resultList Ljava/util/List;
|
tb_mapList i I map Lcom/hxzkoa/json/tb_map; obj LocalVariableTypeTable *Ljava/util/List<Lcom/hxzkoa/json/tb_map;>; StackMapTable getpersonid A(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_person;>; y >SELECT p_x,p_y,p_tagid,p_addtiem FROM tb_person WHERE p_tagid= { com/hxzkoa/json/tb_person
|
z
|
z ~ setP_x
|
z setP_y
|
z
|
setP_tagid
|
z setP_addtiem tagid Lcom/hxzkoa/json/tb_person; -Ljava/util/List<Lcom/hxzkoa/json/tb_person;>; getgpsid >(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>; HSELECT gps_weidu,gsp_jingdu,tagid,gps_haiba_gao FROM tb_gps WHERE tagid= com/hxzkoa/json/tb_gps
|
|
setGps_weidu
|
setGsp_jingdu
|
setTagid
|
setGps_haiba_gao Lcom/hxzkoa/json/tb_gps; *Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>;
|
getMap_all ,()Ljava/util/List<Lcom/hxzkoa/json/tb_map;>; ¤ \SELECT floor,mapname,x_Truelength,y_Truewidth,x0_length,y0_width,x_Pixel,y_Pixel FROM tb_map getMap_all2 § sSELECT floor,mapname,x_Truelength,y_Truewidth,x0_length,y0_width,x_Pixel,y_Pixel FROM tb_map WHERE mapname = :floor © floor 1 « ¬ setParameter ?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query; getFloor ° SELECT floor,mapname FROM tb_map getFloor2 ³ 7SELECT floor,mapname FROM tb_map WHERE mapname = :floor getFloorByMapname ¶ 0SELECT floor,mapname FROM tb_map WHERE mapname=' ¸ ' mapname getAnchor .()Ljava/util/List<Lcom/hxzkoa/json/tb_achor;>; ½ &SELECT anchorid,anchorip FROM tb_achor ¿ com/hxzkoa/json/tb_achor
|
¾
|
¾ Â Ã setAnchorid
|
¾ Å Æ setAnchorip tb_anchorList anchor Lcom/hxzkoa/json/tb_achor; ,Ljava/util/List<Lcom/hxzkoa/json/tb_achor;>; getFence @(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_fence;>; Î ^SELECT floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color FROM tb_fence WHERE floor= Ð com/hxzkoa/json/tb_fence
|
Ï
|
Ï K
|
Ï Ô Õ setType
|
Ï × Ø setBumen
|
Ï Ú Û setName
|
% Þ ; à ,
|
H â ã ä
|
replaceAll 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
|
Ï æ ç
|
setZuobiao
|
Ï é ê setShape ì
|
Ï î ï setStart
|
Ï ñ ò setStop
|
Ï ô õ
|
setAddtime
|
Ï ÷ ø setColor tb_fenceList fence Lcom/hxzkoa/json/tb_fence; ,Ljava/util/List<Lcom/hxzkoa/json/tb_fence;>; getFence_all .()Ljava/util/List<Lcom/hxzkoa/json/tb_fence;>; kSELECT floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color FROM tb_fence where type != 'åçµç«' getFenceaaa bSELECT floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color FROM tb_fence WHERE name=:name name drawFence_add (Lcom/hxzkoa/json/tb_fence;)I :Lorg/springframework/transaction/annotation/Transactional;
|
¥INSERT INTO tb_fence(id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color) VALUES(:id,:floor,:type,:bumen,:name,:zuobiao,:shape,:start,:stop,now(),:color)
|
tb_fence
|
!com/hxzkoa/services/CaozuoService tb_caozuo (Ljava/lang/String;I)V id
|
Ï > getId
|
java/lang/Integer valueOf (I)Ljava/lang/Integer;
|
Ï! ® '# type
|
Ï% & ' getType( bumen
|
Ï* + ' getBumen
|
Ï- . ' getName0 zuobiao
|
Ï2 3 '
|
getZuobiao5 shape
|
Ï7 8 ' getShape: start
|
Ï< = ' getStart? stop
|
ÏA B ' getStopD color
|
ÏF G ' getColor 1I J > executeUpdate drawFence_add2
|
ÏM N '
|
getBaoliu7P 0
|
ÏR S
|
setBaoliu7U óINSERT INTO tb_fence(floor,type,name,zuobiao,shape,start,stop,addtime,color,baoliu1,baoliu3,baoliu4,bumen,baoliu6,baoliu7) VALUES(:floor,:type,:name,:zuobiao,:shape,:start,:stop,now(),:color,:baoliu1,:baoliu3,:baoliu4,:bumen,:baoliu6,:baoliu7)W baoliu1
|
ÏY Z '
|
getBaoliu1\ baoliu3
|
Ï^ _ '
|
getBaoliu3a baoliu4
|
Ïc d '
|
getBaoliu4f baoliu6
|
Ïh i '
|
getBaoliu6k baoliu7 sanweiFence_addn ¶INSERT INTO tb_fence(id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color,baoliu1) VALUES(:id,:floor,:type,:bumen,:name,:zuobiao,:shape,:start,:stop,now(),:color,:baoliu1) xunjianSet_add (Ljava/lang/String;)Ir INSERT INTO tb_xunjianset(quyu,startime,stoptime,xunshu,tagid,needstoptime,cishu,addtime) VALUES(:name,'23:59:00','æ ','æ ','æææ ç¾','1','1',now())t tb_xunjianset fenceInout_add K(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ix java/lang/StringBuffer
|
w { ç©å½¢} 4 1,1,1,1
|
w \;
|
H
split '(Ljava/lang/String;)[Ljava/lang/String;
|
H (I)Ljava/lang/String; 1,
|
w " ,(Ljava/lang/String;)Ljava/lang/StringBuffer; 1 INSERT INTO tb_fence_inout(name, zuobiao, bianshu, canin, canout, floor, addtime) VALUES(:name,:zuobiao,:bianshu,:canin,:canout,:floor,now()) tb_fence_inout bianshu canin
|
w % canout zuobiaos Ljava/lang/StringBuffer; zb [Ljava/lang/String; getTagtrack Z(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List;
|
Exceptions¥ java/text/ParseException v(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_track;>;¨ java/text/SimpleDateFormatª yyyy-MM-dd HH:mm:ss
|
§
|
§ ®¯ parse $(Ljava/lang/String;)Ljava/util/Date;± yyyyMMdd
|
§³ ´µ format $(Ljava/util/Date;)Ljava/lang/String;· LSELECT tagid,x,y,z,layer,time,baoliu1,baoliu2,baoliu3,baoliu4 FROM tb_track_¹ WHERE layer= '» ' AND tagid= '½ ' AND time>= '¿ ' AND time<= 'Á ' ORDER BY timeà com/hxzkoa/json/tb_track
|
Â
|
Â
|
ÂÇ È setX
|
ÂÊ Ë setY
|
ÂÍ Î setZ
|
ÂÐ Ñ setLayer
|
ÂÓ Ô setTime
|
ÂÖ × setFangkeid
|
ÂÙ Ú setJingdu
|
ÂÜ Ý setWeidu
|
Âß à setGaocheng tag_id
|
begin_time end_time
|
dateFormat Ljava/text/SimpleDateFormat; now Ljava/util/Date; dateFormat2 now2 tb_trackList Lcom/hxzkoa/json/tb_track; ,Ljava/util/List<Lcom/hxzkoa/json/tb_track;>;î java/util/Date getTagtrack2ñ ' AND baoliu8= ' getTagtrack3 H(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; d(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_track;>;ö WHERE tagid= ' getAnchorip @(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_achor;>;ú 6SELECT anchorid,anchorip FROM tb_achor WHERE anchorid= anchorid getAnchorInfoþ ´SELECT a.* FROM tb_achor AS a,( SELECT anchorid, max( GreateTime ) time FROM tb_achor GROUP BY anchorid ) AS b WHERE a.GreateTime = b.time AND a.anchorid = b.anchorid AND a.layer='
|
¾ setPOSX
|
¾ setPOSY
|
¾ setPOSZ
|
¾Ð
|
¾
|
setAnchormode
|
¾ setGreateTime getAnchorInfo_all ¦SELECT a.* FROM tb_achor AS a,( SELECT anchorid, max( GreateTime ) time FROM tb_achor GROUP BY anchorid ) AS b WHERE a.GreateTime = b.time AND a.anchorid = b.anchorid getALlAnchor getRealTagState >(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_tag;>; #SELECT * FROM tb_tag WHERE tag_id=' ' ORDER BY addtime DESC LIMIT 1 com/hxzkoa/json/tb_tag
|
|
setTag_id
|
! setState
|
# $ setPower
|
& ' setStatus
|
ô tb_realtagList tag Lcom/hxzkoa/json/tb_tag; *Ljava/util/List<Lcom/hxzkoa/json/tb_tag;>; getRealpersonState/ 'SELECT * FROM tb_person WHERE p_tagid='1 !' ORDER BY p_addtiem DESC LIMIT 1
|
z3 4 setP_online
|
z6 7
|
setP_power tb_realpersonList person getpersonLocation< 'SELECT * FROM tb_person WHERE p_floor='
|
z> ? setP_name
|
zA B
|
setP_phone
|
zD E setP_department
|
zG H setP_idcardnum
|
zJ K
|
setP_floor
|
zM N setP_sos
|
zP Q setP_kaoqing
|
zS T
|
setP_fence
|
zV W setP_fencename
|
zY Z setP_kaoqqingname
|
z\ ]
|
setP_image
|
z_ ` setP_sousuo
|
zb c setP_shipin
|
ze f setP_jingdu
|
zh i
|
setP_weidu
|
zk l setP_gaocheng
|
zn o setBaoliu10
|
zq r setBaoliu22 tb_realocationList realocation getpersonLocationsan /()Ljava/util/List<Lcom/hxzkoa/json/tb_person;>;x SELECT * FROM tb_person
|
zz { setP_sex
|
z} ~
|
setP_minzu
|
z setP_fangkeid
|
z setBaoliu23
|
z setBaoliu24 getpersonLocationsan3 &SELECT * FROM tb_person where p_floor= getpersonLocationsan2-SELECT a.p_name,a.p_tagid,a.p_idcardnum,a.p_x,a.p_y,a.p_floor,a.p_sos,a.p_online,a.p_power,a.p_kaoqing,a.p_fence,a.p_fencename,a.p_kaoqqingname,a.p_image,a.p_addtiem,a.p_sousuo,a.p_shipin,a.baoliu1,a.baoliu2,a.baoliu3,a.baoliu4,a.p_phone,b.type FROM tb_person AS a,tb_tag AS b WHERE a.p_tagid=b.tag_id
|
z setP_type getpersonLocation_all
|
z setP_shipingname
|
z
|
setBaoliu6
|
z setBaoliu20
|
z setBaoliu21 getRealPosTrack I([Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; e([Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_track;>;
|
í £ YYYYMMdd¥ SELECT * FROM tb_track_§ WHERE time >='© ' AND layer='« ' AND (
|
H ® &(Ljava/lang/Object;)Ljava/lang/String;° tagid='² OR ´ ) ¶ ORDER BY time taglist
|
start_time date tb_realTrackList realtrack getRealPosTrack_all 7([Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; S([Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_track;>;À ' AND ( getGas ,()Ljava/util/List<Lcom/hxzkoa/json/tb_gas;>;Ä )SELECT gas_type, nong_du, x,y FROM tb_gasÆ com/hxzkoa/json/tb_gas
|
Å
|
ÅÉ Ê setGas_type
|
ÅÌ Í
|
setNong_du
|
ÅÇ
|
ÅÊ
|
tb_gasList gas Lcom/hxzkoa/json/tb_gas; *Ljava/util/List<Lcom/hxzkoa/json/tb_gas;>; getGPS ,()Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>;×ýSELECT a.id,a.gps_utc_time,a.gps_weidu,a.gps_NS,a.gsp_jingdu,a.gps_EW,a.gps_state,a.gps_num,a.gps_hdop,a.gps_haiba_gao,a.gps_tuoqiu,a.gps_chafen_time,a.gps_chafen_id,a.gps_jiaoyan,a.tagid,a.gps_kahao,a.gps_power,a.gps_sos,a.addtime,c.p_name,c.p_online,c.p_sex,c.p_minzu,c.p_phone,c.p_department,c.baoliu13,c.baoliu14,c.baoliu15,c.p_addtiem FROM tb_gps AS a,( SELECT tagid, max(addtime) time FROM tb_gps GROUP BY tagid ) AS b, tb_person as c WHERE a.addtime = b.time AND a.tagid = b.tagid AND c.p_tagid=a.tagid
|
Ù Ú setGps_utc_time
|
Ü Ý setGps_NS
|
ß à setGps_EW
|
â ã setGps_state
|
å æ
|
setGps_num
|
è é setGps_hdop
|
ë ì setGps_tuoqiu
|
î ï setGps_chafen_time
|
ñ ò setGps_chafen_id
|
ô õ setGps_jiaoyan
|
÷ ø setGps_kahao
|
ú û setGps_power
|
ý þ
|
setGps_sos
|
ô
|
Ú
|
setSex
|
setMinzu
|
|
setDianhua
|
×
|
setBaoliu13
|
setBaoliu14
|
setBaoliu15
|
|
tb_gpsList gps getGPStrack b(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>; &SELECT a.*,b.p_name FROM tb_gps_track_ & AS a, tb_person AS b WHERE a.tagid= ' ' AND a.addtime>= ' ' AND a.addtime<= '" (' AND a.tagid=b.p_tagid ORDER BY addtime gpsRecord_add (Lcom/hxzkoa/json/tb_gps;)I&®INSERT INTO tb_gps(`gps_utc_time`, `gps_weidu`, `gps_NS`, `gsp_jingdu`, `gps_EW`, `gps_state`, `gps_num`, `gps_hdop`, `gps_haiba_gao`, `gps_tuoqiu`, `gps_chafen_time`, `gps_chafen_id`, `gps_jiaoyan`, `tagid`, `gps_power`, `addtime`) VALUES(:gps_utc_time, :gps_weidu, :gps_NS,:gsp_jingdu, :gps_EW, :gps_state, :gps_num, :gps_hdop, :gps_haiba_gao, :gps_tuoqiu, :gps_chafen_time, :gps_chafen_id, :gps_jiaoyan, :tagid, :power, now(3))( tb_gps* gps_utc_time
|
, - ' getGps_utc_time/ gps_weidu
|
1 2 ' getGps_weidu4 gps_NS
|
6 7 ' getGps_NS9
|
gsp_jingdu
|
; < ' getGsp_jingdu> gps_EW
|
@ A ' getGps_EWC gps_state
|
E F ' getGps_stateH gps_num
|
J K '
|
getGps_numM gps_hdop
|
O P ' getGps_hdopR gps_haiba_gao
|
T U ' getGps_haiba_gaoW
|
gps_tuoqiu
|
Y Z ' getGps_tuoqiu\ gps_chafen_time
|
^ _ ' getGps_chafen_timea gps_chafen_id
|
c d ' getGps_chafen_idf gps_jiaoyan
|
h i ' getGps_jiaoyan
|
l m ' getTagido power
|
q r ' getGps_power searchGpsu )SELECT * FROM tb_gps WHERE tagid = :tagid input gpsRecord_modifyyoUPDATE tb_gps SET gps_utc_time=:gps_utc_time,gps_weidu=:gps_weidu,gps_NS=:gps_NS,gsp_jingdu=:gsp_jingdu,gps_EW=:gps_EW,gps_state=:gps_state,gps_num=:gps_num,gps_hdop=:gps_hdop,gps_haiba_gao=:gps_haiba_gao,gps_tuoqiu=:gps_tuoqiu,gps_chafen_time=:gps_chafen_time ,gps_chafen_id=:gps_chafen_id,gps_jiaoyan=:gps_jiaoyan,gps_power=:power, addtime=now(3) WHERE tagid=:tagid gpsTrack_add|³INSERT INTO tb_gps_track(`gps_utc_time`, `gps_weidu`, `gps_NS`, `gsp_jingdu`, `gps_EW`, `gps_state`, `gps_num`, `gps_hdop`, `gps_haiba_gao`, `gps_tuoqiu`, `gps_chafen_time`, `gps_chafen_id`, `gps_jiaoyan`, `tagid`, `gps_power`, `addtime`) VALUES(:gps_utc_time, :gps_weidu, :gps_NS,:gsp_jingdu, :gps_EW, :gps_state, :gps_num, :gps_hdop, :gps_haiba_gao, :gps_tuoqiu, :gps_chafen_time, :gps_chafen_id, :gps_jiaoyan, :tagid, :power, now()) fencegao 3UPDATE tb_person SET p_fence=0 WHERE p_tagid=:tagid tb_person sosgao 1UPDATE tb_person SET p_sos=0 WHERE p_tagid=:tagid
|
chaichugao 3UPDATE tb_person SET baoliu6=0 WHERE p_tagid=:tagid jinmengao 4UPDATE tb_person SET baoliu20=0 WHERE p_tagid=:tagid chumengao 4UPDATE tb_person SET baoliu21=0 WHERE p_tagid=:tagid shipin 4UPDATE tb_person SET p_shipin=0 WHERE p_tagid=:tagid getstatus &(Ljava/lang/String;)Ljava/lang/String; -SELECT status from tb_tag WHERE tag_id=:tagid status getfencezuobiao 4SELECT zuobiao from tb_linshi_fence_22414 WHERE id=1 getfencehaibagao 4SELECT baoliu4 from tb_linshi_fence_22414 WHERE id=1 getfencename 0SELECT p_fencename from tb_person WHERE p_tagid= getshebeiid A(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_shipin;>;¢ CSELECT shebeiid,tongdaoid from tb_shipin WHERE fencename=:fencename¤ fencename¦ com/hxzkoa/json/tb_shipin
|
¥
|
¥© ª setYonghuming
|
¥¬ setMima tb_shipinList Lcom/hxzkoa/json/tb_shipin; -Ljava/util/List<Lcom/hxzkoa/json/tb_shipin;>; qihoucha .()Ljava/util/List<Lcom/hxzkoa/json/tb_qihou;>;´ 0SELECT id,time,place,weather,wd,sd FROM tb_qihou¶ com/hxzkoa/json/tb_qihou
|
µ
|
¹ º > intValue
|
µ¼ ½¾ setId (I)V
|
µÓ
|
µÁ  setPlace
|
µÄ Å
|
setWeather
|
µÇ È setWd
|
µÊ Ë setSd tb_qihouList qihou Lcom/hxzkoa/json/tb_qihou; ,Ljava/util/List<Lcom/hxzkoa/json/tb_qihou;>; (I)Ljava/util/List; /(I)Ljava/util/List<Lcom/hxzkoa/json/tb_qihou;>;Ó SELECT id,time,place,weather,wd,sd FROM (SELECT id,time,place,weather,wd,sd FROM tb_qihou ORDER BY time DESC) s LIMIT :start,:end
|
Õ×Ö com/hxzkoa/util/Config Ø ' getPageConfigÚ perPage
|
ÜÞÝ com/hxzkoa/util/ModifyConfig ß ä readData
|
á âp parseIntä end page qihouzeng (Lcom/hxzkoa/json/tb_qihou;)Ié TINSERT INTO tb_qihou(time,place,weather,wd,sd) VALUES(now(),:place,:weather,:wd,:sd)ë place
|
µí î ' getPlaceð weather
|
µò ó '
|
getWeatherõ wd
|
µ÷ ø ' getWdú sd
|
µü ý ' getSd qihoudelete ([Ljava/lang/String;)V #DELETE FROM tb_qihou WHERE id = :id checkVal qihoudeleteAll DELETE FROM tb_qihou qihougai (Lcom/hxzkoa/json/tb_qihou;)V LUPDATE tb_qihou SET place=:place,weather=:weather,wd=:wd,sd=:sd WHERE id=:id
|
µ getqihouManagementCount SELECT count(1) FROM tb_qihou 1 getSingleResult ()Ljava/lang/Object; getkaoqinsan 4()Ljava/util/List<Lcom/hxzkoa/json/tb_realkaoqing;>; SELECT * FROM tb_realkaoqing com/hxzkoa/json/tb_realkaoqing
|
|
setArea
|
Ú
|
×
|
|
! setIntime
|
# $ setJuli tb_realkaoqinList Lcom/hxzkoa/json/tb_realkaoqing; 2Ljava/util/List<Lcom/hxzkoa/json/tb_realkaoqing;>; getsosgaojing* /select p_tagid from tb_person where p_sos = '1' soslist getfencegaojing. 1select p_tagid from tb_person where p_fence = '1' getchufencegaojing1 1select p_tagid from tb_person where p_fence = '2' getjinchumengaojing4 Eselect p_tagid from tb_person where baoliu20 = '1' and baoliu21 = '1'
|
getjingwei 0()Ljava/util/List<Lcom/hxzkoa/json/tb_jingwei;>;8 MSELECT id,qishi,zhongzhi,jieguo,addtime FROM tb_jingwei ORDER BY addtime DESC: com/hxzkoa/json/tb_jingwei
|
9
|
9= ½> (Ljava/lang/Integer;)V
|
9@ A setQishi
|
9C D setZhongzhi
|
9F G setJieguo
|
9 ô tb_jingweiList jingwei Lcom/hxzkoa/json/tb_jingwei; .Ljava/util/List<Lcom/hxzkoa/json/tb_jingwei;>;
|
addjingwei (Lcom/hxzkoa/json/tb_jingwei;)IP _insert into tb_jingwei(qishi,zhongzhi,jieguo,addtime) values(:qishi,:zhongzhi,:jieguo,:addtime)R qishi
|
9T U ' getQishiW zhongzhi
|
9Y Z ' getZhongzhi\ jieguo
|
9^ _ ' getJieguoa addtime
|
9c d '
|
getAddtime getnav ,()Ljava/util/List<Lcom/hxzkoa/json/tb_nav;>;h ZSELECT id,label,achor,gps,fence,warning,history,attendance,basiclnfo,video,gas FROM tb_navj com/hxzkoa/json/tb_nav
|
i
|
i¼
|
in o setLabel
|
iq r setAchor
|
it u setGps
|
iw x setFence
|
iz {
|
setWarning
|
i} ~
|
setHistory
|
i setAttendance
|
i setBasiclnfo
|
i setVideo
|
i setGas navlist nav Lcom/hxzkoa/json/tb_nav; *Ljava/util/List<Lcom/hxzkoa/json/tb_nav;>; updatenav (Lcom/hxzkoa/json/tb_nav;)I Æupdate tb_nav set label = :label,achor = :achor,gps = :gps,fence = :fence,warning = :warning,history = :history,attendance = :attendance,basiclnfo = :basiclnfo,video = :video,gas = :gas where id = 1 label
|
i ' getLabel achor
|
i ' getAchor
|
i ' getGps ú
|
i£ Ë '¥ warning
|
i§ ¨ '
|
getWarningª history
|
i¬ '
|
getHistory¯
|
attendance
|
i± ² ' getAttendance´ basiclnfo
|
i¶ · ' getBasiclnfo¹ video
|
i» ¼ ' getVideoÑ
|
i¿ Á ' getbumen 1select p_name,p_department,p_tagid from tb_person
|
resultlist persons
|
getmessage 0()Ljava/util/List<Lcom/hxzkoa/json/tb_message;>;È TSELECT * FROM tb_message_history WHERE Replytime IS NOT NULL order by Replytime descÊ com/hxzkoa/json/tb_message
|
É
|
ɼ
|
ÉÎ Ï
|
setMessage
|
É ô
|
ÉÒ Ó
|
setBaoliu2 messages mess Lcom/hxzkoa/json/tb_message; .Ljava/util/List<Lcom/hxzkoa/json/tb_message;>; deletemessageÚ 6delete from tb_message_history where Replytime < :date¹ getlixianÞ 6SELECT baoliu5 FROM tb_linshi_fence_22414 WHERE id = 1
|
SourceFile ZhwService.java (Lorg/springframework/stereotype/Service; !
|
H / *· ± C Ú ÖMN» Y· +¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 6§ » ?Y· A:¹ B À F:2À H¶ J2À H¶ M2À H¶ P2À H¶ S2À H¶ V2À H¶ Y2À H¶ \2À H¶ _¹ b W¹ 9 ¡ÿq° V K L M N O ( P 1 Q ; R A S J T X U d V p W | X Y Z [ \ º ] Ä R Ó ` \ Ö Ö f g Ô h g Ò i j ( ® k l 1 ¥ m l > n o J z p q X l r G s 1 ¥ m t u " ÿ A H H 1 : : û
ú v w ¤MN» Yx· +¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 i6§ W» zY· |:¹ B À F:2À H¶ }2À H¶ 2À H¶ 2À H¶ ¹ b W¹ 9 ¡ÿ£° F d e f g h ( i 1 j ; k A l J m X n d o p p | q r k ¡ u \ ¤ ¤ g ¢ h g i j ( | k l 1 s m l > c n o J H p X : r G s 1 s m u " ÿ A H H 1 : : û Sú ¤MN» Y· +¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 i6§ W» Y· :¹ B À F:2À H¶ 2À H¶ 2À H¶ 2À H¶ ¹ b W¹ 9 ¡ÿ£° F y z { | } ( ~ 1 ; A J X d p
| ¡ \ ¤ ¤ g ¢ h g i j ( | k l 1 s m l > c n o J H p X : r G s 1 s m u " ÿ A H H 1 : : û Sú ¡ 5 ¢ » ÄLM£L*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 6§ » ?Y· A:-¹ B À F:2À H¶ J2À H¶ M2À H¶ P2À H¶ S2À H¶ V2À H¶ Y2À H¶ \2À H¶ _¹ b W-¹ 9 ¡ÿs° V " + 1 : G S _ k w © ³ Á £ R Ä Â h g À i j « k l " ¢ m l . n o : y p q G l r G s " ¢ m t u ÿ 1 H 1 : : û ú
|
¥ Ú ÒMN¦M*´ (,¹ * N-¨+¹ ª W-¹ 0 :» 6Y· 8:¹ 9 6§ » ?Y· A:¹ B À F:2À H¶ J2À H¶ M2À H¶ P2À H¶ S2À H¶ V2À H¶ Y2À H¶ \2À H¶ _¹ b W¹ 9 ¡ÿq° Z § ¨ © ª « ¬ $ - ® 7 ¯ = ° F ± T ² ` ³ l ´ x µ ¶ · ¸ © ¹ ¶ º À ¯ Ï ½ \ Ò Ò © g Ð h g Î i j $ ® k l - ¥ m l : n o F z p q T l r G s - ¥ m t u " ÿ = H H 1 : : û
ú ® 5 ¢ W zLM¯L*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 O6§ >» ?Y· A:-¹ B À F:2À H¶ J2À H¶ M¹ b W-¹ 9 ¡ÿ½° > Á Â Ã Ä Å Æ " Ç + È 1 É : Ê G Ë S Ì _ Í i È w Ð R z x h g v i j a k l " X m l . I n o : / p q G " r G s " X m t u ÿ 1 H 1 : : :ú
|
± v MN²M*´ (,¹ * N-¨+¹ ª W-¹ 0 :» 6Y· 8:¹ 9 Q6§ ?» ?Y· A:¹ B À F:2À H¶ J2À H¶ M¹ b W¹ 9 ¡ÿ»° B Ô Õ Ö × Ø Ù $ Ú - Û 7 Ü = Ý F Þ T ß ` à l á v Ü
ä \ © g h g i j $ d k l - [ m l : K n o F 0 p q T " r G s - [ m t u ÿ = H H 1 : : ;ú ´ { MN» Yµ· +¶ ·¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 Q6§ ?» ?Y· A:¹ B À F:2À H¶ J2À H¶ M¹ b W¹ 9 ¡ÿ»° > è é ê ë % ì - í 6 î @ ï F ð O ñ ] ò i ó u ô ï ÷ \ ¹ g h g i j - d k l 6 [ m l C K n o O 0 p q ] " r G s 6 [ m t u ÿ F H H 1 : : ;ú º 5 » W zLM¼L*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 O6§ >» ¾Y· À:-¹ B À F:2À H¶ Á2À H¶ Ĺ b W-¹ 9 ¡ÿ½° > û ü ý þ ÿ " + 1 : G S _ i w
|
R z x h g v i j a k l " X Ç l . I n o : / È É G " r G s " X Ç Ê u ÿ 1 H 1 : : :ú
|
Ë Ì MN» YÍ· +¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 Ö6§ Ä» ÏY· Ñ:¹ B À F:2À H¶ Ò2À H¶ Ó2À H¶ Ö2À H¶ Ù2¶ ÜÝ߶ ᶠå2À H¶ è2Ç ë§ 2¶ ܶ í2Ç ë§ 2¶ ܶ ð2À H¶ ó 2À H¶ ö¹ b W¹ 9 ¡ÿ6° ^ ( 1 ; A J X d p | § Á Û è! õ" ÿ% \ f g h g i j ( é k l 1 à ù l > Ð n o J µ ú û X § r G s 1 à ù ü u ÿ A H H 1 : : ÿ t H H 1 : : Ï F Ïÿ H H 1 : : Ï F Ï HQ Ïÿ H H 1 : : Ï F Ï Hù )ú ý 5 þ h ÿLMÿL*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 Ô6§ û ÏY· Ñ:-¹ B À F:2À H¶ Ò2À H¶ Ó2À H¶ Ö2À H¶ Ù2¶ ÜÝ߶ ᶠå2À H¶ è2Ç ë§ 2¶ ܶ í2Ç ë§ 2¶ ܶ ð2À H¶ ó 2À H¶ ö¹ b W-¹ 9 ¡ÿ8° ^ ) * + , - . "/ +0 11 :2 G3 S4 _5 k6 w7 8 9 °: Ê; ×< ä= î0 ü@ R ÿ ý h g û i j æ k l " Ý ù l . Î n o : ´ ú û G § r G s " Ý ù ü u ÿ 1 H 1 : : ÿ s H 1 : : Ï F Ïÿ H 1 : : Ï F Ï HQ Ïÿ H 1 : : Ï F Ï Hù )ú
|
Ì MNM*´ (,¹ * N-+¹ ª W-¹ 0 :» 6Y· 8:¹ 9 Ö6§ Ä» ÏY· Ñ:¹ B À F:2À H¶ Ò2À H¶ Ó2À H¶ Ö2À H¶ Ù2¶ ÜÝ߶ ᶠå2À H¶ è2Ç ë§ 2¶ ܶ í2Ç ë§ 2¶ ܶ ð2À H¶ ó 2À H¶ ö¹ b W¹ 9 ¡ÿ6° b D E F G H I &J /K 9L ?M HN VO bP nQ zR S T ¥U ¿V ÙW æX óY ýL \ \ g h g i j & é k l / à ù l < Ð n o H µ ú û V § r G s / à ù ü u ÿ ? H H 1 : : ÿ t H H 1 : : Ï F Ïÿ H H 1 : : Ï F Ï HQ Ïÿ H H 1 : : Ï F Ï Hù )ú I ·MN M*´ ¶*´ (,¹ * N-+¶¸¹ ª W-¨+¶ ¹ ª W-"+¶$¹ ª W-'+¶)¹ ª W-+¶,¹ ª W-/+¶1¹ ª W-4+¶6¹ ª W-9+¶;¹ ª W->+¶@¹ ª W-C+¶E¹ ª W-¹H 6¬ F a b c d e f /g <h Ji Xj fk tl m n o ¬p ´q 4 · · ú û µ h g ³ i j ´ J o K ¯ ü+¶Lë¦
|
+O¶QMNTM*´ ¶*´ (,¹ * N-¨+¶ ¹ ª W-"+¶$¹ ª W-+¶,¹ ª W-/+¶1¹ ª W-4+¶6¹ ª W-9+¶;¹ ª W->+¶@¹ ª W-C+¶E¹ ª W-V+¶X¹ ª W-[+¶]¹ ª W-`+¶b¹ ª W-'+¶)¹ ª W-e+¶g¹ ª W-j+¶L¹ ª W-¹H 6¬ ^ v w y z { | #} .~ ; I W e s
« ¹ Ç Õ ã ñ ù 4 ü ü ú û ê h g è i j ù J o u l [ ÅMNmM*´ ¶*´ (,¹ * N-+¶¸¹ ª W-¨+¶ ¹ ª W-"+¶$¹ ª W-'+¶)¹ ª W-+¶,¹ ª W-/+¶1¹ ª W-4+¶6¹ ª W-9+¶;¹ ª W->+¶@¹ ª W-C+¶E¹ ª W-V+¶X¹ ª W-¹H 6¬ J / < J X f t ¡ ¬¢ º£ ¤ 4 Å Å ú û à h g Á i j  J o op ¢ 4MNqM*´ s¶*´ (,¹ * N-+¹ ª W-¹H 6¬ " © ª « ¬ ® )¯ 1° 4 4 4 g 2 h g 0 i j 1 J o uv ^ ::ë:»wY·y:»wY·y: -z¦ #|:»wY~·:»wY~·: § U,¶:
|
|
¾¸:6 § 4¶W ¶W
|
¾d ¶W ¶W
|
¾d¡ÿÈ:*´ ¶*´ (¹ * :+¹ ª W/,¹ ª W¹ ª W¶¹ ª W ¶¹ ª W¨¹ ª W¹H 6
|
|
¬ z µ ¶ ¸
|
¹ º » #¼ (½ 4¾ @¿ CÀ LÁ T Zà cÄ lÅ vÆ Ç Â Ë Ì ¥Í ²Î ¾Ï ÊÐ ×Ñ çÒ ÷ÓÔ Õ g g 5 g © g h g i j
|
g ü ó L I
|
W > n o J o
|
u 3 ÿ C
|
H H H H H 1 Hww ý -ù ¡¢ £ ¤ ¦ Ç P::»§Y©·«:,¶¬:»§Y°·«: ¶²:
|
» Y¶·
|
¶ ¸¶ ¶ º¶ +¶ ¼¶ ,¶ ¾¶ -¶ À¶ ¶ $:*´ (¹ * :¹ 0 : » 6Y· 8: ¹ 9 µ6 § £»ÂY·Ä: ¹ B À F:2À H¶Å2À H¶Æ2À H¶É2À H¶Ì2À H¶Ï2À H¶Ò2À H¶Õ2À H¶Ø2À H¶Û 2À H¶Þ ¹ b W ¹ 9 ¡ÿW ° n Û Ü Ý Þ à &á /è rì í î ï ð ¡ñ ªò ¸ó Äô Ðõ Üö è÷ ôø ù úû'ü4ý>ðM ¢ P Pá g Pâ g Pã g P © g M h g J i j >äå 6æç &*èå /!é g
|
È k l ¿ê l ¯ n o ª pë ¸ r G s ¿êì u 7 ÿ ¡ H H H H H 1§í§ H : : û ú ï¢ £ ¤ ¦ Ç P::»§Y©·«:,¶¬:»§Y°·«: ¶²:
|
» Y¶·
|
¶ ¸¶ ¶ ð¶ +¶ ¼¶ ,¶ ¾¶ -¶ À¶ ¶ $:*´ (¹ * :¹ 0 : » 6Y· 8: ¹ 9 µ6 § £»ÂY·Ä: ¹ B À F:2À H¶Å2À H¶Æ2À H¶É2À H¶Ì2À H¶Ï2À H¶Ò2À H¶Õ2À H¶Ø2À H¶Û 2À H¶Þ ¹ b W ¹ 9 ¡ÿW ° n &
|
/ r ¡ ª ¸ Ä Ð Ü è ô! " #$'%4&>M) ¢ P P g Pâ g Pã g P © g M h g J i j >äå 6æç &*èå /!é g
|
È k l ¿ê l ¯ n o ª pë ¸ r G s ¿êì u 7 ÿ ¡ H H H H H 1§í§ H : : û ú òó £ ¤ ô ¯ E::»§Y©·«:,¶¬:»§Y°·«:¶²: » Y¶· ¶ õ¶ +¶ ¼¶ ,¶ ¾¶ -¶ À¶ ¶ $:*´ (¹ * :¹ 0 :
|
» 6Y· 8:
|
¹ 9 µ6 § £»ÂY·Ä:
|
¹ B À F: 2À H¶Å 2À H¶Æ 2À H¶É 2À H¶Ì 2À H¶Ï 2À H¶Ò 2À H¶Õ 2À H¶Ø 2À H¶Û 2À H¶Þ ¹ b W
|
¹ 9 ¡ÿW ° n - . / 0 1 &2 /4 g6 t7 }8 9 : ; < = ¹> Å? Ñ@ ÝA éB õCDE F)G3:BJ E Eá g Eâ g Eã g B h g ? i j 3äå +æç & èå /é g } È k l
|
¿ê l ¯ n o pë r G s ¿êì u 4 ÿ H H H H 1§í§ H : : û ú ÷ ø w MN» Yù· +¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 Q6§ ?» ¾Y· À:¹ B À F:2À H¶ Á2À H¶ Ĺ b W¹ 9 ¡ÿ»° > N O P Q !R )S 2T <U BV KW YX eY qZ {U ] \ û g h g i j ) d k l 2 [ Ç l ? K n o K 0 È É Y " r G s 2 [ Ç Ê u ÿ B H H 1 : : ;ú ü ø á ÝMN» Yý· +¶ ·¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 6§ » ¾Y· À:¹ B À F:2À H¶ Á2À H¶ÿ2À H¶2À H¶2À H¶2À H¶ 2À H¶ Ä 2À H¶ ¹ b W¹ 9 ¡ÿp° V a b c d &e .f 7g Ah Gi Pj ^k jl vm n o p §q ´r Ás Ëh Úv \ Ý Ý © g Û h g Ù i j . ¯ k l 7 ¦ Ç l D n o P { È É ^ m r G s 7 ¦ Ç Ê u " ÿ G H H 1 : : û ú 5 » ½ ÆLML*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 6§ » ¾Y· À:-¹ B À F:2À H¶ Á2À H¶ÿ2À H¶2À H¶2À H¶2À H¶ 2À H¶ Ä 2À H¶ ¹ b W-¹ 9 ¡ÿr° V z { | } ~ # , 2 ; H T
` l x « µ à R Æ Ä h g  i j ¬ k l # £ Ç l / n o ; z È É H m r G s # £ Ç Ê u ÿ 2 H 1 : : û
ú
|
5 » ¬ ¹LML*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 6§ |» ¾Y· À:-¹ B À F:2À H¶ Á2À H¶ÿ2À H¶2À H¶2À H¶ 2À H¶ Ä 2À H¶ ¹ b W-¹ 9 ¡ÿ° R # , 2 ; H T ` l x¡ ¢ £ ¤ ¨ ¶§ R ¹ · h g µ i j k l # Ç l / n o ; m È É H ` r G s # Ç Ê u ÿ 2 H 1 : : û xú
|
Ü óMN» Y· +¶ ¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 ±6§ »Y·:¹ B À F:2Ç ë§
|
2¶ ܶ 2Ç ë§
|
2¶ ܶ 2Ç ë§
|
2¶ ܶ"2Ç ë§
|
2¶ ܶ%2Ç ë§
|
2¶ ܶ(¹ b W¹ 9 ¡ÿ[° J « ¬ ® '¯ /° 8± B² H³ Q´ _µ w¶ · §¸ ¿¹ ׺ á² ð½ \ ó ó g ñ h g ï i j / Ä k l 8 ») l E « n o Q *+ _ r G s 8 »), u ÿ H H H 1 : : ÿ $ H H 1 : : F ÿ H H 1 : : F HPÿ H H 1 : : F HPÿ H H 1 : : F HPÿ H H 1 : : F HPÿ H H 1 : : F Hù ú - w ¯MN» Y.· +¶ 0¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 m6§ [» zY· |:¹ B À F:2Ç ë§ 2¶ ܶ22Ç ë§ 2¶ ܶ5¹ b W¹ 9 ¡ÿ° > Á Â Ã Ä 'Å /Æ 8Ç BÈ HÉ QÊ _Ë yÌ Í È ¬Ð \ ¯ ¯ g h g « i j / k l 8 w8 l E g n o Q L9 _ > r G s 8 w8 u ÿ H H H 1 : : ÿ % H H 1 : : z F zÿ H H 1 : : z F z HQ zÿ H H 1 : : z F z Hù ú : w ó ¯MN» Y;· +¶ ·¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 n6§\» zY· |:¹ B À F:2À H¶=2À H¶ 2À H¶@2À H¶C 2À H¶F 2À H¶ } 2À H¶ 2À H¶I2À H¶L2À H¶22À H¶52À H¶O2À H¶R2À H¶U2À H¶X2À H¶[2À H¶ 2À H¶^2À H¶a 2À H¶d 2À H¶g 2À H¶j%2À H¶m12À H¶p¹ b W¹ 9 ¡þ° % Ô Õ Ö × &Ø .Ù 7Ú AÛ GÜ PÝ ^Þ jß và á â ã ©ä ¶å Ãæ Ðç Ýè êé ÷êëì í+î8ïEðRñ_òlóyôõöÛ¬ù \ ¯ ¯ © g h g « i j . k l 7xs l Dh n o PMt ^? r G s 7xs u " ÿ G H H 1 : : ûXú u 5 v ½LMwL*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 6§» zY· |:-¹ B À F:2À H¶=2À H¶ 2À H¶y2À H¶|2À H¶@2À H¶C 2À H¶ } 2À H¶ 2À H¶I2À H¶L2À H¶22À H¶52À H¶O2À H¶R2À H¶U2À H¶X2À H¶[2À H¶ 2À H¶^2À H¶a 2À H¶ 2À H¶d 2À H¶g 2À H¶j12À H¶p22À H¶32À H¶
¹ b W-¹ 9 ¡þ{° ¢ ( ý þ ÿ # , 2 ; H T ` l
|
x « ¸ Å Ò ß ì ù -:GT a n { !¢"¬º% R ½ » h g ¹ i j £ k l #s l / n o ;qt Hd r G s #s u ÿ 2 H 1 : : û|ú
|
w ÏMN» Y· +¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 6§» zY· |:¹ B À F:2À H¶=2À H¶ 2À H¶y2À H¶|2À H¶@2À H¶C 2À H¶ } 2À H¶ 2À H¶I2À H¶L2À H¶22À H¶52À H¶O2À H¶R2À H¶U2À H¶X2À H¶[2À H¶ 2À H¶^2À H¶a 2À H¶ 2À H¶d 2À H¶g 2À H¶j12À H¶p22À H¶32À H¶
¹ b W¹ 9 ¡þy° ¢ ( ) * + , !- ). 2/ <0 B1 K2 Y3 e4 q5 }6 7 8 ¢9 ¯: ¼; É< Ö= ã> ð? ý@
|
AB$C1D>EKFXGeHrIJKL¦M³N½0ÌQ \ Ï Ï © g Í h g Ë i j )¦ k l 2s l ? n o Krt Yd r G s 2s u " ÿ B H H 1 : : û}ú 5 v » LML*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 \6§K» zY· |:-¹ B À F:2À H¶=2À H¶ 2À H¶F2À H¶ }2À H¶ 2À H¶I2À H¶L2À H¶22À H¶5 2À H¶O
|
2À H¶R 2À H¶U 2À H¶X 2À H¶[2À H¶ 2À H¶^2À H¶a2À H¶2À H¶d2À H¶g2À H¶j2À H¶@2À H¶¹ b W-¹ 9 ¡þ°° $ U V W X Y Z #[ ,\ 2] ;^ H_ T` `a lb xc d e f ªg ·h Äi Ñj Þk ël ømno p,q9rFsSt`umvw\
y R h g i j n k l #es l /V n o ;<t H/ r G s #es u ÿ 2 H 1 : : ûGú
|
5 v { XLMwL*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 ,6§» zY· |:-¹ B À F:2À H¶=2À H¶ 2À H¶ } 2À H¶ 2À H¶I2À H¶L2À H¶22À H¶52À H¶O2À H¶R2À H¶U2À H¶X2À H¶[2À H¶ 2À H¶a2À H¶!2À H¶/2À H¶02À H¶¹ b W-¹ 9 ¡þà° } ~ # , 2
; H T ` m z ¡ ® » È Õ â ï ü #0=GU R X V h g T i j > k l #5s l /& n o ; t H ÿ r G s #5s u ÿ 2 H 1 : : ûú
|
::»íY·¡:»§Y¢·«:¶²:» Y¤· ¶ ¦¶ ,¶ ¨¶ -¶ ª¶ ¶ $:6 § c» Y¸¬· ¯¶ + 2¶ ·¶ ¶ $: +¾d » Y¸¬· ±¶ ¶ $:§ » Y¸¬· ³¶ ¶ $: +¾¡ÿ» Y¸¬· µ¶ ¶ $:*´ (¹ * :¹ 0 : » 6Y· 8:
|
¹ 9 6 § p»ÂY·Ä: ¹ B À F: 2À H¶Å 2À H¶Æ 2À H¶É 2À H¶Ì 2À H¶Ï 2À H¶Ò
|
¹ b W ¹ 9 ¡ÿ
|
° z ¢ £ ¤ ¥ ¦ $¨ R« X¬ { ® ¯ ° µ« ¿³ Ö´ ãµ ì¶ õ· ÿ¸¹º »(¼4½@¾L¿XÀeÁo¸~Ä · ¸ g © g ~ h g { i j r¹ç fäå $]æ g U j n o ì k l õ º l
|
| n o a»ë S r G s õ ºì
|
u Y ÿ X
|
H H H 1í§ H û Eÿ L H H H 1í§ H : : û lú ¼½ ¾ ÷ lN:»íY·¡:»§Y¢·«:¶²:» Y¤· ¶ ¦¶ ,¶ ¿¶ ¶ $N6§ ]» Y-¸¬· ¯¶ +2¶ ·¶ ¶ $N+¾d » Y-¸¬· ±¶ ¶ $N§ » Y-¸¬· ³¶ ¶ $N+¾¡ÿ¢» Y-¸¬· µ¶ ¶ $N*´ (-¹ * :¹ 0 :» 6Y· 8: ¹ 9 6
|
§ p»ÂY·Ä:
|
¹ B À F: 2À H¶Å 2À H¶Æ 2À H¶É 2À H¶Ì 2À H¶Ï 2À H¶Ò ¹ b W
|
|
¹ 9 ¡ÿ ° z È É Ê Ë Ì #Ð FÒ LÓ mÔ vÕ Ö × £Ò Ú ÂÜ ÎÝ ×Þ àß êà ðá ùâãä å+æ7çCèPéZàiì l l· l¸ g j h g g i j ^¹ç Räå #Iæ g I d n o × k l à º l í | n o
|
ù a»ë S r G s à ºì u S ÿ L H H 1í§ H û Aÿ I H H 1í§ H : : û lú Á 5  z LMÃL*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 g6§ V»ÅY·Ç:-¹ B À F:2À H¶È2À H¶Ë2À H¶Î2À H¶Ï¹ b W-¹ 9 ¡ÿ¥° F ñ ò ó ô õ ö #÷ ,ø 2ù ;ú Hû Tü `ý lþ xÿ ø R h g i j y k l # pÐ l / a n o ; GÑÒ H : r G s # pÐÓ u ÿ 2 H 1 : : û Rú
|
Ô 5 Õ ½LMÖL*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 6§» Y· :-¹ B À F:2À H¶Ø2À H¶ 2À H¶Û2À H¶ 2À H¶Þ2À H¶á2À H¶ä2À H¶ç 2À H¶
|
2À H¶ê 2À H¶í 2À H¶ð 2À H¶ó2À H¶ 2À H¶ö2À H¶ù2À H¶ü2À H¶ÿ2À H¶ 2À H¶2À H¶2À H¶2À H¶
|
2À H¶ 2À H¶2À H¶ 2À H¶¹ b W-¹ 9 ¡þ{° ¢ (
|
# , 2 ; H T ` l x « ¸ Å Ò ß ì ù !-":#G$T%a&n'{()*¢+¬ º. R ½ » h g ¹ i j £ k l # l / n o ;q Hd r G s # u ÿ 2 H 1 : : û|ú
|
ó £ ¤ I »::»§Y©·«:,¶¬:»§Y°·«:¶²: » Y· ¶ ¶ +¶ ¶ ,¶ ¶ -¶ !¶ ¶ $:*´ (¹ * :¹ 0 :
|
» 6Y· 8:
|
¹ 9 +6 §» Y· :
|
¹ B À F: 2À H¶Ø 2À H¶ 2À H¶Û 2À H¶ 2À H¶Þ 2À H¶á 2À H¶ä 2À H¶ç 2À H¶
|
2À H¶ê 2À H¶í 2À H¶ð 2À H¶ó 2À H¶ 2À H¶ö 2À H¶ù 2À H¶ü 2À H¶ÿ 2À H¶ ¹ b W
|
¹ 9 ¡þá ° $ 2 3 4 5 6 &7 /8 g: t; }< = > ? @ A ¹B ÅC ÑD ÝE éF öGHI J*K7LDMQN^OkPxQ
RST©>¸W » »á g »â g »ã g ¸ h g µ i j ©äå ¡æç &èå /é g }> k l
|
5ê l % n o
|
ü r G s 5ê u 4 ÿ H H H H 1§í§ H : : ûú #$ ¡ ûMN%M*´ '¶*´ (,¹ * N-)+¶+¹ ª W-.+¶0¹ ª W-3+¶5¹ ª W-8+¶:¹ ª W-=+¶?¹ ª W-B+¶D¹ ª W-G+¶I¹ ª W-L+¶N¹ ª W-Q+¶S¹ ª W-V+¶X¹ ª W-[+¶]¹ ª W-`+¶b¹ ª W-e+¶g¹ ª W-j+¶k¹ ª W-n+¶p¹ ª W-¹H 6¬ Z \ ] ^ c d e ,f :g Hh Vi dj rk l m n ªo ¸p Æq Ôr âs ðt øu 4 û û ù h g ÷ i j ø J o s WMNtM*´ (,¹ * N-j+¹ ª W-¹ 0 :» 6Y· 8:¹ 9 6§ » Y· :¹ B À F:2À H¶Ø2À H¶ 2À H¶Û2À H¶ 2À H¶Þ2À H¶á2À H¶ä2À H¶ç 2À H¶
|
2À H¶ê 2À H¶í 2À H¶ð 2À H¶ó2À H¶ 2À H¶ö2À H¶ù2À H¶ü2À H¶ÿ¹ b W¹ 9 ¡þî° y z { | } ~ & / 9 ? H V b
n z ¬ ¹ Æ Ó à í ú!.;ET \ W Wv g U h g S i j &1 k l /( l < n o H ý V ï r G s /( u " ÿ ? H H 1 : : ûú w$ ¡ ûMNxM*´ '¶*´ (,¹ * N-)+¶+¹ ª W-.+¶0¹ ª W-3+¶5¹ ª W-8+¶:¹ ª W-=+¶?¹ ª W-B+¶D¹ ª W-G+¶I¹ ª W-L+¶N¹ ª W-Q+¶S¹ ª W-V+¶X¹ ª W-[+¶]¹ ª W-`+¶b¹ ª W-e+¶g¹ ª W-j+¶k¹ ª W-n+¶p¹ ª W-¹H 6¬ Z ¤ ¥ ¦ ,§ :¨ H© Vª d« r¬ ® ¯ ª° ¸± Ʋ Ô³ â´ ðµ ø¶ 4 û û ù h g ÷ i j ø J o z$ ðMN{M*´ (,¹ * N-)+¶+¹ ª W-.+¶0¹ ª W-3+¶5¹ ª W-8+¶:¹ ª W-=+¶?¹ ª W-B+¶D¹ ª W-G+¶I¹ ª W-L+¶N¹ ª W-Q+¶S¹ ª W-V+¶X¹ ª W-[+¶]¹ ª W-`+¶b¹ ª W-e+¶g¹ ª W-j+¶k¹ ª W-n+¶p¹ ª W-¹H 6¬ V » ¼ ½  à !Ä /Å =Æ KÇ YÈ gÉ uÊ Ë Ì Í Î »Ï ÉÐ ×Ñ åÒ íÓ 4 ð ð î h g ì i j í J o }p ¢ 4MN~M*´ ¶*´ (,¹ * N-j+¹ ª W-¹H 6¬ " Ø Ù Ú Û Ü Ý )Þ 1ß 4 4 4 g 2 h g 0 i j 1 J o p ¢ 4MNM*´ ¶*´ (,¹ * N-j+¹ ª W-¹H 6¬ " ä å æ ç è é )ê 1ë 4 4 4 g 2 h g 0 i j 1 J o
p ¢ 4MNM*´ ¶*´ (,¹ * N-j+¹ ª W-¹H 6¬ " ð ñ ò ó ô õ )ö 1÷ 4 4 4 g 2 h g 0 i j 1 J o p ¢ 4MNM*´ ¶*´ (,¹ * N-j+¹ ª W-¹H 6¬ " ü ý þ ÿ ) 1 4 4 4 g 2 h g 0 i j 1 J o p ¢ 4MNM*´ ¶*´ (,¹ * N-j+¹ ª W-¹H 6¬ "
|
) 1 4 4 4 g 2 h g 0 i j 1 J o p ¢ 4MNM*´ ¶*´ (,¹ * N-j+¹ ª W-¹H 6¬ " ) 1 4 4 4 g 2 h g 0 i j 1 J o ½ AMNM*´ '¶*´ (,¹ * N-j+¹ ª W-¹ 0 :¹ B ¶ Ü:° & ! " # $ )% 1& >' > A A g ? h g = i j 1 k l > g ' )LML*´ (+¹ * M,¹ 0 N-¹ B ¶ Ü:° + , - . / 0 &1 4 ) ' h g % i j k l & g ' )LML*´ (+¹ * M,¹ 0 N-¹ B ¶ Ü:° 5 6 7 8 9 : &; 4 ) ' h g % i j k l & g w ¦ MN» Y· +¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 M6§ ;» zY· |:¹ B Ç ë§ ¹ B ¶ ܶU¹ b W¹ 9 ¡ÿ¿° 6 ? @ A B !D )F 2G <H BI KK mM wH P R g h g
i j ) ` k l 2 W l ? G n o K ,9 s 2 W u e ÿ B H H 1 : : ÿ H H 1 : : z zÿ H H 1 : : z z Hú ú x MN¡M*´ (,¹ * N-£+¹ ª W-¹ 0 :» 6Y· 8:¹ 9 Q6§ ?»¥Y·§:¹ B À F:2À H¶¨2À H¶«¹ b W¹ 9 ¡ÿ»° B T U V W X Y &Z /[ 9\ ?] H^ V_ b` na x\ d \ ¤ g h g i j & d k l / [® l < K n o H 0¯ V " r G s / [®° u ÿ ? H H 1 : : ;ú ± 5 ² ¸ êLM³L*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 ¾6§ »µY··:-¹ B À F:2À¶¸¶»2Ç ë§
|
2¶ ܶ¿2Ç ë§
|
2¶ ܶÀ2Ç ë§
|
2¶ ܶÃ2Ç ë§
|
2¶ ܶÆ2Ç ë§
|
2¶ ܶɹ b W-¹ 9 ¡ÿN° N h i j k l m #n ,o 2p ;q Hr Ws ot u v ·w Ïx Ùo ç{ R ê è h g æ i j Ð k l # ÇÌ l / ¸ n o ; ÍÎ H r G s # ÇÌÏ u þ ÿ 2 H 1 : : ÿ 2 H 1 : :µ F µÿ H 1 : :µ F µ HPµÿ H 1 : :µ F µ HPµÿ H 1 : :µ F µ HPµÿ H 1 : :µ F µ HPµÿ H 1 : :µ F µ Hù ú
|
±Ð Ñ $MNÒM*´ (,¹ * N-9d¸ÔÙ¸Û¸àh¸¹ ª W-ã¸Ôٸ۸ู ª W-¹ 0 :» 6Y· 8:¹ 9 À6§ ®»µY··:¹ B À F:2À¶¸¶»2Ç ë§
|
2¶ ܶ¿2Ç ë§
|
2¶ ܶÀ2Ç ë§
|
2¶ ܶÃ2Ç ë§
|
2¶ ܶÆ2Ç ë§
|
2¶ ܶɹ b W¹ 9 ¡ÿL° V 0 I
Q Z d j s ¨ À Ø ð! \ $ $å o " h g i j Q Ó k l Z ÊÌ l g º n o s ÍÎ r G s Z ÊÌÏ u ÿ j H 1 : : ÿ 3 H 1 : :µ F µÿ H 1 : :µ F µ HPµÿ H 1 : :µ F µ HPµÿ H 1 : :µ F µ HPµÿ H 1 : :µ F µ HPµÿ H 1 : :µ F µ Hù ú æç Ì VMNèM*´ (,¹ * N-ê+¶ì¹ ª W-ï+¶ñ¹ ª W-ô+¶ö¹ ª W-ù+¶û¹ ª W-¹H 6¬ *
|
! / = K¡ S¢ 4 V VÍÎ T h g R i j S J o þÿ ¾ 9MN6§ * M*´ (,¹ * N-+2¹ ª W-¹H W+¾¡ÿÕ± & § ¨ ©
|
ª « ¬ ' .© 8¯ 4 9 9 7 h g 5 i j 1 n o u þ
|
H 1& m LML*´ (+¹ * M,¹H W± ³ ´ µ ¶ · ¸ h g i j Ô dMNM*´ (,¹ * N-+¶
|
¸¹ ª W-ê+¶ì¹ ª W-ï+¶ñ¹ ª W-ô+¶ö¹ ª W-ù+¶û¹ ª W-¹H W± . ¼ ½ ¾ ¿ À $Á 2 @à NÄ \Å cÆ * d dÍÎ b h g ` i j > n LM L*´ (+¹ * M,¹ ¶ Ü¸à¬ É Ê Ë Ì Í h g i j 5 ¬LML*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 6§ o»Y·:-¹ B À F:2À H¶2À H¶ 2À H¶ 2À H¶ 2À H¶ 2À H¶"¹ b W-¹ 9 ¡ÿ° N Ñ Ò Ó Ô Õ Ö #× ,Ø 2Ù ;Ú HÛ TÜ `Ý lÞ xß à á Ø ©ä R ¬ ª h g ¨ i j k l # % l / z n o ; `t& H S r G s # %' u ÿ 2 H 1 : : û kú
|
( 5 v vLM)L*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 J6§ 9» zY· |:-¹ B Ç ë§ -¹ B ¶ ܶ ¹ b W-¹ 9 ¡ÿ° 6 è é ê ë ì í #î ,ï 2ð ;ñ [ò eï sõ H v t h g r i j \ k l # S+ l / D n o ; *9 s # S+ u \ ÿ 2 H 1 : : ÿ H 1 : : z zÿ
|
H 1 : : z z Hú ú
|
, 5 v vLM-L*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 J6§ 9» zY· |:-¹ B Ç ë§ -¹ B ¶ ܶ ¹ b W-¹ 9 ¡ÿ° 6 ù ú û ü ý þ #ÿ , 2 ; [ e s H v t h g r i j \ k l # S+ l / D n o ; *9 s # S+ u \ ÿ 2 H 1 : : ÿ H 1 : : z zÿ
|
H 1 : : z z Hú ú
|
/ 5 v vLM0L*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 J6§ 9» zY· |:-¹ B Ç ë§ -¹ B ¶ ܶ ¹ b W-¹ 9 ¡ÿ° 6
|
# , 2 ; [ e s H v t h g r i j \ k l # S+ l / D n o ; *9 s # S+ u \ ÿ 2 H 1 : : ÿ H 1 : : z zÿ
|
H 1 : : z z Hú ú
|
2 5 v vLM3L*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 J6§ 9» zY· |:-¹ B Ç ë§ -¹ B ¶ ܶ ¹ b W-¹ 9 ¡ÿ° 6 #! ," 2# ;$ [% e" s( H v t h g r i j \ k l # S+ l / D n o ; *9 s # S+ u \ ÿ 2 H 1 : : ÿ H 1 : : z zÿ
|
H 1 : : z z Hú ú
|
5 5 6 ¥LM7L*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 y6§ h»9Y·;:-¹ B À F:2À¶¸¸¶<2À H¶?2À H¶B2À H¶E2À H¶H¹ b W-¹ 9 ¡ÿ° J , - . / 0 1 #2 ,3 24 ;5 H6 Z7 f8 r9 ~: ; 3 ¢> R ¥ £ h g ¡ i j k l # I l / s n o ; YJK H L r G s # IL u ÿ 2 H 1 : : û dú
|
MN Ì VMNOM*´ (,¹ * N-Q+¶S¹ ª W-V+¶X¹ ª W-[+¶]¹ ª W-`+¶b¹ ª W-¹H 6¬ *
|
C D E F G !H /I =J KK SL 4 V VJK T h g R i j S J o e 5 f ò ïLMgL*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 Ã6§ ²»iY·k:-¹ B À F:2À¶¸¶l2À H¶m2À H¶p2À H¶s2À H¶v2À H¶y2À H¶|2À H¶2À H¶ 2À H¶
|
2À H¶¹ b W-¹ 9 ¡ÿI° b P Q R S T U #V ,W 2X ;Y HZ W[ c\ o] {^ _ ` a b ºc Çd Ôe ÞW ìh R ï í h g ë i j Õ k l # Ì l / ½ n o ; £ H r G s # Ì u ÿ 2 H 1 : : û ®ú
|
8 ªMNM*´ (,¹ * N-+¶¹ ª W-+¶¹ ª W-+¶¹ ª W-¡+¶¢¹ ª W-¤+¶¦¹ ª W-©+¶«¹ ª W-®+¶°¹ ª W-³+¶µ¹ ª W-¸+¶º¹ ª W-½+¶¾¹ ª W-¹H 6¬ B m n o p q !r /s =t Ku Yv gw ux y z { §| 4 ª ª ¨ h g ¦ i j § J o À 5 v ¨LMÁL*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 |6§ k-¹ B À F:» zY· |:2Ç §
|
2¶ ܶ=2Ç §
|
2¶ ܶC2Ç §
|
2¶ ܶ ¹ b W-¹ 9 ¡ÿ° B
# , 2 ? H _ v ¥ R ¨ ¦ h g ¤ i j à l #
Ä l / v n o ? X r G H O9 s #
Ä u ° ÿ 2 H 1 : : ÿ " H 1 : : F z zÿ H 1 : : F z z HO zÿ H 1 : : F z z HO zÿ H 1 : : F z z Hù ú
|
Å 5 Æ 5 ½LMÇL*´ (+¹ * M,¹ 0 N» 6Y· 8:-¹ 9 6§ -¹ B À F:»ÉY·Ë:2À¶¸¶Ì2Ç § 2¶ ܶÍ2Ç § 2¶ ܶÐ2Ç § 2¶ ܶѹ b W-¹ 9 ¡ÿ{° F # , 2 ? H W p ¡ ¢¢ ¬ º¥ R ½ » h g ¹ i j £Ã l # Ô l / n o ? m r G H dÕÖ s # Ô× u ° ÿ 2 H 1 : : ÿ 2 H 1 : : FÉ Éÿ H 1 : : FÉ É HPÉÿ H 1 : : FÉ É HPÉÿ H 1 : : FÉ É Hù ú
|
Ø &MNÙM*´ (,¹ * N-Û+¹ ª W-¹H W± ª « ¬ ® ¯ %° * & &¹ g $ h g " i j Ü ' %LMÝL*´ (+¹ * M,¹ 0 N-¹ B ¶ Ü° ³ ´ µ ¶ · ¸ * % # h g ! i j à l ß à á
|
