Êþº¾ 3w com/hxzkoa/services/GpsService 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/GpsService; txt ()Ljava/util/List; Signature &()Ljava/util/List<Ljava/lang/String;>; java/util/LinkedList
|
D:\baowen.txt java/io/File
|
! " (Ljava/lang/String;)V $ java/io/FileInputStream
|
# & ' (Ljava/io/File;)V ) java/io/BufferedReader + java/io/InputStreamReader
|
* - . (Ljava/io/InputStream;)V
|
( 0 1 (Ljava/io/Reader;)V 3 5 4 java/util/List 6 7 add (Ljava/lang/Object;)Z
|
( 9 : ; readLine ()Ljava/lang/String;
|
= ? > java/io/FileNotFoundException @ printStackTrace
|
( B C close
|
E ? F java/io/IOException list Ljava/util/List; filePath Ljava/lang/String; file Ljava/io/File; reader Ljava/io/BufferedReader;
|
tempString line I intput Ljava/io/FileInputStream; e Ljava/io/FileNotFoundException; Ljava/io/IOException; LocalVariableTypeTable $Ljava/util/List<Ljava/lang/String;>; StackMapTable [ java/lang/String ] java/lang/Throwable getGpsManagement ,()Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>; a ÍSELECT id,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_kahao,gps_power,gps_sos,addtime FROM tb_gps c e g f javax/persistence/EntityManager h i createNativeQuery -(Ljava/lang/String;)Ljavax/persistence/Query; k m l javax/persistence/Query n getResultList p java/util/ArrayList
|
o 3 s t u size ()I w com/hxzkoa/json/tb_gps
|
v 3 z { | get (I)Ljava/lang/Object; ~ [Ljava/lang/Object; java/lang/Integer
|
u intValue
|
v
setId (I)V
|
; toString
|
v " setGps_utc_time
|
v " setGps_weidu
|
v " setGps_NS
|
v " setGsp_jingdu
|
v " setGps_EW
|
v " setGps_state
|
v ¡ "
|
setGps_num
|
v £ ¤ " setGps_hdop
|
v ¦ § " setGps_haiba_gao
|
v © ª " setGps_tuoqiu
|
v ¬ " setGps_chafen_time
|
v ¯ ° " setGps_chafen_id
|
v ² ³ " setTagid
|
v µ ¶ " setGps_kahao
|
v ¸ ¹ " setGps_power
|
v » ¼ "
|
setGps_sos
|
v ¾ ¿ "
|
setAddtime sql query Ljavax/persistence/Query;
|
resultList
|
tb_gpsList i gps Lcom/hxzkoa/json/tb_gps; obj *Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>; (I)Ljava/util/List; -(I)Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>;
|
Í Ï Î com/hxzkoa/util/Config Ð ; getPageConfig Ò perPage
|
Ô Ö Õ com/hxzkoa/util/ModifyConfig × Ø readData 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
|
Ú Û Ü parseInt (Ljava/lang/String;)I Þ õSELECT id,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_kahao,gps_power,gps_sos,addtime FROM tb_gps order by addtime desc LIMIT :start,:end à start
|
â ã ä valueOf (I)Ljava/lang/Integer; k æ ç è setParameter ?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query; ê end
|
v ì í " setGps_jiaoyan page getGpsManagementCount ñ SELECT count(1) FROM tb_gps k ó ô õ getSingleResult ()Ljava/lang/Object; searchGpsManagement $(Ljava/lang/String;)Ljava/util/List; >(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>; ú âSELECT id,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_kahao,gps_power,gps_sos,addtime FROM tb_gps WHERE tagid = :tagid ü tagid input gpszeng (Lcom/hxzkoa/json/tb_system;)V :Lorg/springframework/transaction/annotation/Transactional; tUPDATE tb_system SET origin_jingdu=:origin_jingdu,origin_weidu=:origin_weidu,origin_jiaodu=:origin_jiaodu WHERE id=1
|
tb_system
|
|
!com/hxzkoa/services/CaozuoService tb_caozuo (Ljava/lang/String;I)V origin_jingdu
|
com/hxzkoa/json/tb_system ; getOrigin_jingdu origin_weidu
|
; getOrigin_weidu origin_jiaodu
|
; getOrigin_jiaodu k u executeUpdate system Lcom/hxzkoa/json/tb_system; gpsManagement_delete ([Ljava/lang/String;)V& 'DELETE FROM tb_gps WHERE tagid = :tagid( tb_gps checkVal [Ljava/lang/String; getTrack &(Ljava/lang/String;II)Ljava/util/List; @(Ljava/lang/String;II)Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>;/ java/lang/StringBuilder1 SELECT * FROM tb_gps_track_
|
. !
|
.4 56 append -(Ljava/lang/String;)Ljava/lang/StringBuilder;8 LIMIT :start,:end
|
. date tb_trackList getgpsRealTimeLocationCount> "SELECT count(1) FROM tb_gps_track_ getgpsTrackDateListA {select right(table_name,8) from information_schema.tables where table_schema='hxzkuwb' and table_name like 'tb_gps_track_%' realTimegpsLocation_delete (([Ljava/lang/String;Ljava/lang/String;)VE DELETE FROM tb_gps_track_G WHERE id = :idI id realTimegpsLocation_deleteAll searchRealTimegpsLocation 6(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; P(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>;O WHERE tagid = :p_tagidQ p_tagid getRealTimegpsLocation Z(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; t(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>;V wSELECT id,gps_weidu,gsp_jingdu,gps_state,gps_num,gps_haiba_gao,gps_chafen_id,tagid,gps_power,addtime FROM tb_gps_track_X WHERE tagid = 'Z ' AND addtime>= '\ ' AND addtime<= '^ ' ORDER BY addtime `ba java/lang/System cd out Ljava/io/PrintStream;
|
fhg java/io/PrintStream i " print begin tb_realocationList realocation getpersontagid &(Ljava/lang/String;)Ljava/lang/String;p /SELECT p_online FROM tb_person WHERE p_tagid ='r ' zhuantai
|
SourceFile GpsService.java (Lorg/springframework/stereotype/Service; !
|
/ *· ± & Ô
|
¾» Y· L M» Y,· N::6» #Y-· %:» (Y» *Y· ,· /:§ +¹ 2 W¶ 8Y:Çÿï§ X:¶ <Æ `¶ A§ X: ¶ D§ N:¶ DÆ B¶ A§ :: ¶ D§ 0:Æ ¶ A§
|
: ¶ D¿Æ ¶ A§
|
: ¶ D+° P S = _ d g E P q E }
E Z q x E ² µ E " . 0 2 4 6 8 < ' @ 9 B < C E B P F U G Z K _ M d N i O q H s I x K } M N O J K M N O ¥ R ¨ K M ² N · O ¼ S ¾ ¶ G H ³ I J ª K L § M N ¤ O J ¡ P Q ' ) R S U T U s T V i T V T V T V · T V W ¶ G X Y ÿ < 3 Z ( Z # ÿ 3 Z ( Z =S EI ES EI \ÿ 3 Z ( Z \ Eÿ 3 Z ( Z L E ^ _ ó !LM`L*´ b+¹ d M,¹ j N» oY· q:-¹ r ö6§å» vY· x:-¹ y À }:2À ¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç § 2¶ ¶ 2Ç § 2¶ ¶ 2Ç § 2¶ ¶ ¢ 2Ç § 2¶ ¶ ¥
|
2Ç §
|
2¶ ¶ ¨ 2Ç § 2¶ ¶ « 2Ç § 2¶ ¶ ® 2Ç § 2¶ ¶ ±2Ç § 2¶ ¶ ´2Ç § 2¶ ¶ ·2Ç § 2¶ ¶ º2Ç § 2¶ ¶ ½¹ 2 W-¹ r ¡þ° ~ W X Y Z [ \ " ] + ^ 1 _ : ` G a V b n c d e ¶ f Î g è h i j6 kP lj m n o¸ pÒ qì r s ^ v R ! À J Á Â Ã H "ÿ Ä H .ð Å Q :Ö Æ Ç GÉ È ~ W "ÿ Ä É Y Ò %ÿ 1 Z k 3 3 ÿ 2 Z k 3 3 v } vÿ Z k 3 3 v } v ZP vÿ Z k 3 3 v } v ZP vÿ Z k 3 3 v } v ZP vÿ Z k 3 3 v } v ZP vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v Zù ú
|
^ Ê Ë w¸ ÌѸ Ó¸ Ù=d h> 6::Ý:*´ b¹ d :ß ¸ á¹ å Wé¸ á¹ å W¹ j :» oY· q:¹ r 6 § » vY· x:
|
¹ y À }:
|
2À ¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç § 2¶ ¶
|
2Ç § 2¶ ¶
|
2Ç § 2¶ ¶ ¢
|
2Ç § 2¶ ¶ ¥
|
|
2Ç §
|
2¶ ¶ ¨
|
2Ç § 2¶ ¶ «
|
2Ç § 2¶ ¶ ®
|
2Ç § 2¶ ¶ ë
|
2Ç § 2¶ ¶ ±
|
2Ç § 2¶ ¶ ´
|
2Ç § 2¶ ¶ ·
|
2Ç § 2¶ ¶ º
|
2Ç § 2¶ ¶ ½
|
¹ 2 W ¹ r ¡ýú° % z { | } ~ , : I R [
e k t © Á Ù ñ # = W q ¥ ¿ Ù ó ' A [ e t z w w î Q k Ò Q e à Q b ê Q _ À J \ Á Â R% Ã H [ Ä H h Å Q tñ Æ Ç
|
ã È ~ W [ Ä É Y I 'ÿ k
|
Z k 3 3 ÿ 3 Z k 3 3 v } vÿ Z k 3 3 v } v ZP vÿ Z k 3 3 v } v ZP vÿ Z k 3 3 v } v ZP vÿ Z k 3 3 v } v ZP vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v ZQ vÿ Z k 3 3 v } v Zù ú ï u m LMðL*´ b+¹ d M,¹ ò ¶ ¸ Ù¬ £ ¤ ¥ ¦ § À J Á Â ö ÷ ø à
|
O+MN:ùN*´ b-¹ d :û,¹ å W¹ j :» oY· q:¹ r 6§ » vY· x:¹ y À }: 2À ¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç § 2¶ ¶ 2Ç § 2¶ ¶ 2Ç § 2¶ ¶ ¢ 2Ç § 2¶ ¶ ¥
|
2Ç §
|
2¶ ¶ ¨ 2Ç § 2¶ ¶ « 2Ç § 2¶ ¶ ® 2Ç § 2¶ ¶ ë 2Ç § 2¶ ¶ ± 2Ç § 2¶ ¶ ´ 2Ç § 2¶ ¶ · 2Ç § 2¶ ¶ º 2Ç § 2¶ ¶ ½¹ 2 W¹ r ¡ýú° " « ¬ ®
|
¯ ° ! ± * ² 3 ³ = ´ C µ L ¶ Z · i ¸ ¹ º ± » É ¼ á ½ û ¾ ¿/ ÀI Ác Â} à ı ÅË Æå Çÿ È É3 Ê= ´L Í f
|
O O ý J M ü J K À J H Á Â *% Ã H 3 Ä H @ Å Q Lñ Æ Ç Zã È ~ W 3 Ä É Y q 'ÿ C Z Z Z k 3 3 ÿ 3
|
Z Z Z k 3 3 v } vÿ
|
Z Z Z k 3 3 v } v ZP vÿ
|
Z Z Z k 3 3 v } v ZP vÿ
|
Z Z Z k 3 3 v } v ZP vÿ
|
Z Z Z k 3 3 v } v ZP vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v Zù ú þ ÿ ¼ PMNM*´¶*´ b,¹ d N- +¶¹ å W-+¶¹ å W-+¶¹ å W-¹ W± *
|
Ò Ó Ô Õ Ö × , Ø : Ù H Ú O Û * P P!" N À J L Á  #$ ä MMN6§ >+2¸ Ù6%M*´'¶*´ b,¹ d N-û¸ á¹ å W-¹ W+¾¡ÿÁ± . ß à á
|
â ã ä " å - æ ; ç B á L é > M M)* K À J I Á Â E Å Q / ü Q Y þ
|
Z k: +, - z::».Y0·2+¶37¶3¶9:*´ b¹ d :ß d h¸ á¹ å Wé ¸ á¹ å W¹ j :» oY· q:¹ r 6§ » vY· x: ¹ y À }:
|
|
2À ¶ ¶
|
2Ç §
|
|
2¶ ¶
|
2Ç §
|
|
2¶ ¶
|
2Ç §
|
|
2¶ ¶
|
2Ç §
|
|
2¶ ¶
|
2Ç §
|
|
2¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç §
|
2¶ ¶ ¢
|
2Ç §
|
2¶ ¶ ¥
|
|
2Ç §
|
|
2¶ ¶ ¨
|
2Ç §
|
2¶ ¶ «
|
2Ç §
|
2¶ ¶ ®
|
2Ç §
|
2¶ ¶ ë
|
2Ç §
|
2¶ ¶ ±
|
2Ç §
|
2¶ ¶ ´
|
2Ç §
|
2¶ ¶ ·
|
2Ç §
|
2¶ ¶ º
|
2Ç §
|
2¶ ¶ ½ ¹ 2 W¹ r ¡ýú° " í î ï ð , ñ > ò L ó U ô ^ õ h ö n ÷ w ø
ù ú ¬ û Ä ü Ü ý ô þ ÿ& @Zt¨ÂÜö *
|
D ^ h öw p z z: J z î Q z Ò Q w À J t Á Â U% Ã H ^ ; H k Å Q wñ Æ Ç
ã È ~
|
W ^ ; É Y ] 'ÿ n Z Z k 3 3 ÿ 3 Z Z k 3 3 v } vÿ Z Z k 3 3 v } v ZP vÿ Z Z k 3 3 v } v ZP vÿ Z Z k 3 3 v } v ZP vÿ Z Z k 3 3 v } v ZP vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v ZQ vÿ Z Z k 3 3 v } v Zù ú < Ü .MN».Y=·2+¶3¶9M*´ b,¹ d N-¹ ò ¶ ¸ Ù¬ ! * . .: J , À J * Á  ? LM@L*´ b+¹ d M,¹ j N-° * À J Á  à H W à X BC ú [N:6§ K+2¸ Ù6».YD·2,¶3F¶3¶9N*´ b-¹ d :H¸ á¹ å W¹ W+¾¡ÿ´± *
|
% & ' ( ) ,* 8+ H, P' Z. H [ [)* [: J Y À J V Á Â R Å Q <I Q Y þ Z kû G J "
)MN».YD·2+¶3¶9M*´ b,¹ d N-¹ W± 2 3 4 5 !6 (7 * ) ): J ' À J % Á Â KL M ð
|
cN:».Y0·2,¶3N¶3¶9N*´ b-¹ d :P+¹ å W¹ j :» oY· q:¹ r 6§ » vY· x:¹ y À }: 2À ¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç §
|
2¶ ¶ 2Ç § 2¶ ¶ 2Ç § 2¶ ¶ 2Ç § 2¶ ¶ ¢ 2Ç § 2¶ ¶ ¥
|
2Ç §
|
2¶ ¶ ¨ 2Ç § 2¶ ¶ « 2Ç § 2¶ ¶ ® 2Ç § 2¶ ¶ ë 2Ç § 2¶ ¶ ± 2Ç § 2¶ ¶ ´ 2Ç § 2¶ ¶ · 2Ç § 2¶ ¶ º 2Ç § 2¶ ¶ ½¹ 2 W¹ r ¡ýú° ! : ; < = )> 5? >@ GA QB WC `D nE }F G H ÅI ÝJ õKL)MCN]OwPQ«RÅSßTùUV-WGXQB`[ f
|
c c ý J c: J a À J ^ Á Â >% Ã H G ; H T Å Q `ñ Æ Ç nã È ~ W G ; É Y q 'ÿ W Z Z Z k 3 3 ÿ 3
|
Z Z Z k 3 3 v } vÿ
|
Z Z Z k 3 3 v } v ZP vÿ
|
Z Z Z k 3 3 v } v ZP vÿ
|
Z Z Z k 3 3 v } v ZP vÿ
|
Z Z Z k 3 3 v } v ZP vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v ZQ vÿ
|
Z Z Z k 3 3 v } v Zù ú RS T Á ::».YU·2¶3W¶3+¶3Y¶3,¶3[¶3-¶3]¶3¶9:²_¶e*´ b¹ d :¹ j :» oY· q:¹ r (6 §» vY· x:
|
¹ y À }:
|
2À ¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç §
|
2¶ ¶
|
2Ç §
|
2¶ ¶ ¥
|
2Ç § 2¶ ¶ ®
|
2Ç § 2¶ ¶ ±
|
2Ç § 2¶ ¶ ·
|
2Ç § 2¶ ¶ ½
|
¹ 2 W ¹ r ¡þä° b _ ` a >b Fc Sd \e ef og uh ~i j k ³l Ëm ãn ûop-qGras{t
gw z ü J j J ê J : J À J Á Â \; Ã H e2k H r" Å Q ~l Ç
|
ù È ~ W e2k É Y ÿ u
|
Z Z Z Z Z k 3 3 ÿ 3 Z Z Z Z Z k 3 3 v } vÿ Z Z Z Z Z k 3 3 v } v ZP vÿ Z Z Z Z Z k 3 3 v } v ZP vÿ Z Z Z Z Z k 3 3 v } v ZP vÿ Z Z Z Z Z k 3 3 v } v ZP vÿ Z Z Z Z Z k 3 3 v } v ZQ vÿ Z Z Z Z Z k 3 3 v } v ZQ vÿ Z Z Z Z Z k 3 3 v } v ZQ vÿ Z Z Z Z Z k 3 3 v } v ZQ vÿ Z Z Z Z Z k 3 3 v } v Zù ú mn ³ ?MN».Yo·2+¶3q¶3¶9M*´ b,¹ d N-¹ j :¹ y ¶ :° { | } ~ ' / < > ? ? ü J = À J ; Á Â / Ã H < s J t u v
|
