Êþº¾ 3 #com/hxzkoa/services/LocationService 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/LocationService; getRealTimeLocation $(Ljava/lang/String;)Ljava/util/List; Signature F(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; java/lang/StringBuilder /SELECT id,tagid,x,y,z,layer,time FROM tb_track_
|
(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_realocation
|
? : C D E get (I)Ljava/lang/Object; G [Ljava/lang/Object; I java/lang/Integer
|
H K L > intValue
|
? N O P setId (I)V R
|
%
|
? U V setTagid
|
? X Y setX
|
? [ \ setY
|
? ^ _ setZ
|
? a b setLayer
|
? d e setTime : g h i add (Ljava/lang/Object;)Z date Ljava/lang/String; sql query Ljavax/persistence/Query;
|
resultList Ljava/util/List; tb_realocationList i I realocation Lcom/hxzkoa/json/tb_realocation; obj LocalVariableTypeTable 2Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; StackMapTable { java/lang/String (II)Ljava/util/List; 6(II)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; FSELECT id,tagid,x,y,z,layer,time FROM tb_realocation LIMIT :start,:end start
|
H
valueOf (I)Ljava/lang/Integer; 1 setParameter ?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query; end page perPage getRealTimeLocationCount (Ljava/lang/String;)I SELECT count(1) FROM tb_track_ 1 getSingleResult ()Ljava/lang/Object;
|
H parseInt searchRealTimeLocation 6(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; X(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; WHERE tagid = :p_tagid p_tagid input realTimeLocation_delete (([Ljava/lang/String;Ljava/lang/String;)V :Lorg/springframework/transaction/annotation/Transactional; ¥ DELETE FROM tb_track_ § WHERE id = :id ©
|
« tb_realocation
|
¯ ® !com/hxzkoa/services/CaozuoService ° ± tb_caozuo (Ljava/lang/String;I)V ³ id 1 µ ¶ > executeUpdate checkVal [Ljava/lang/String; realTimeLocation_deleteAll track_add /(Ljava/lang/String;Lcom/hxzkoa/json/tb_track;)I ½ INSERT INTO tb_track_ ¿ >(tagid,x,y,z,layer,time) VALUES(:tag_id,:x,:y,:z,:layer,now()) Á tag_id
|
Ã Å Ä com/hxzkoa/json/tb_track Æ ' getTagid È x
|
Ã Ê Ë ' getX Í y
|
Ã Ï Ð ' getY Ò z
|
Ã Ô Õ ' getZ × layer
|
Ã Ù Ú ' getLayer track Lcom/hxzkoa/json/tb_track; getTrack &(Ljava/lang/String;II)Ljava/util/List; B(Ljava/lang/String;II)Ljava/util/List<Lcom/hxzkoa/json/tb_track;>; á LIMIT :start,:end
|
Ã
|
à N
|
à U
|
à X
|
à [
|
à ^
|
à a
|
à d tb_trackList ,Ljava/util/List<Lcom/hxzkoa/json/tb_track;>; getTrackDateList &()Ljava/util/List<Ljava/lang/String;>; ï wselect right(table_name,8) from information_schema.tables where table_schema='hxzkuwb' and table_name like 'tb_track_%' $Ljava/util/List<Ljava/lang/String;>; tag_time (Lcom/hxzkoa/json/tb_tag;)V ô 7UPDATE tb_tag SET addtime=:addtime WHERE tag_id=:tag_id ö tb_tag ø addtime
|
ú ü û com/hxzkoa/json/tb_tag ý '
|
getAddtime
|
ú ÿ ' getTag_id tag Lcom/hxzkoa/json/tb_tag;
|
SourceFile LocationService.java (Lorg/springframework/stereotype/Service; !
|
/ *· ± 0 MN» Y· +¶ ¶ $M*´ (,¹ * N-¹ 0 :» 6Y· 8:¹ 9 Ú6§ È» ?Y· A:¹ B À F:2À H¶ J¶ M2Ç Q§
|
2¶ S¶ T2Ç Q§
|
2¶ S¶ W2Ç Q§
|
2¶ S¶ Z2Ç Q§
|
2¶ S¶ ]2Ç Q§
|
2¶ S¶ `2Ç Q§ 2¶ S¶ c¹ f W¹ 9 ¡ÿ2° R ! " # ( $ 1 % ; & A ' J ( X ) g * + , ¯ - Ç . ß / ù 0 & 3 \ j k l k m n ( í o p 1 ä q p > Ô r s J ¹ t u X « v G w 1 ä q x y = ÿ A z z 1 : : ÿ 3 z z 1 : : ? F ?ÿ z z 1 : : ? F ? zP ?ÿ z z 1 : : ? F ? zP ?ÿ z z 1 : : ? F ? zP ?ÿ z z 1 : : ? F ? zP ?ÿ z z 1 : : ? F ? zQ ?ÿ z z 1 : : ? F ? zù ú | } O
|
*N:~N*´ (-¹ * :d h¸ ¹ W ¸ ¹ W¹ 0 :» 6Y· 8:¹ 9 Ú6§ È» ?Y· A:¹ B À F: 2À H¶ J¶ M 2Ç Q§
|
2¶ S¶ T 2Ç Q§
|
2¶ S¶ W 2Ç Q§
|
2¶ S¶ Z 2Ç Q§
|
2¶ S¶ ] 2Ç Q§
|
2¶ S¶ ` 2Ç Q§ 2¶ S¶ c¹ f W¹ 9 ¡ÿ2° Z 7 8 9 : ; & < 4 = = > F ? P @ V A _ B m C | D E ¬ F Ä G Ü H ô I J @' M f
|
* * s * s ( l k % m n = í o p F ä q p S Ô r s _ ¹ t u m « v G w F ä q x y 5 ÿ V z 1 : : ÿ 3
|
z 1 : : ? F ?ÿ
|
z 1 : : ? F ? zP ?ÿ
|
z 1 : : ? F ? zP ?ÿ
|
z 1 : : ? F ? zP ?ÿ
|
z 1 : : ? F ? zP ?ÿ
|
z 1 : : ? F ? zQ ?ÿ
|
z 1 : : ? F ? zù ú
-MN» Y· +¶ ¶ $M*´ (,¹ * N-¹ ¶ S¸ ¬ Q R S T U * - - j k + l k ) m n i
|
(N:» Y· ,¶ ¶ ¶ $N*´ (-¹ * :+¹ W¹ 0 :» 6Y· 8:¹ 9 Ú6§ È» ?Y· A:¹ B À F: 2À H¶ J¶ M 2Ç Q§
|
2¶ S¶ T 2Ç Q§
|
2¶ S¶ W 2Ç Q§
|
2¶ S¶ Z 2Ç Q§
|
2¶ S¶ ] 2Ç Q§
|
2¶ S¶ ` 2Ç Q§ 2¶ S¶ c¹ f W¹ 9 ¡ÿ2° V Y Z [ \ ' ] 2 ^ ; _ D ` N a T b ] c k d z e f ª g  h Ú i ò j k a% n f
|
( ( k ( j k & l k # m n ; í o p D ä q p Q Ô r s ] ¹ t u k « v G w D ä q x y U ÿ T z z z 1 : : ÿ 3
|
z z z 1 : : ? F ?ÿ
|
z z z 1 : : ? F ? zP ?ÿ
|
z z z 1 : : ? F ? zP ?ÿ
|
z z z 1 : : ? F ? zP ?ÿ
|
z z z 1 : : ? F ? zP ?ÿ
|
z z z 1 : : ? F ? zQ ?ÿ
|
z z z 1 : : ? F ? zù ú ¡ ¢ £ bN:6§ R+2¸ 6» Y¤· ,¶ ¦¶ ¶ $N*´ ¨ª¶ ¬*´ (-¹ * :²¸ ¹ W¹ ´ W+¾¡ÿ± . s t u v w * x 4 y @ z O { W u a } H b b · ¸ b j k ` l k ] m n Y r s C ³ s y þ z 1û N ¹ £ (MN» Y¤· +¶ ¶ $M*´ (,¹ * N-¹ ´ W±
' * ( ( j k & l k $ m n º » £ ý yN:» Y¼· +¶ ¾¶ ¶ $N*´ (-¹ * :À,¶ ¹ WÇ,¶ ɹ WÌ,¶ ι WÑ,¶ Ó¹ WÖ,¶ ع W¹ ´ 6¬ . ' 5 C Q _ m v > y y j k y Û Ü w l k t m n v ¶ s Ý Þ ß @::» Y· +¶ ච¶ $:*´ (¹ * : d h¸ ¹ W ¸ ¹ W¹ 0 :» 6Y· 8:¹ 9 Ú6§ È» ÃY· â: ¹ B À F:
|
|
2À H¶ J¶ ã
|
2Ç Q§
|
|
2¶ S¶ ä
|
2Ç Q§
|
|
2¶ S¶ å
|
2Ç Q§
|
|
2¶ S¶ æ
|
2Ç Q§
|
|
2¶ S¶ ç
|
2Ç Q§
|
|
2¶ S¶ è
|
2Ç Q§
|
2¶ S¶ é ¹ f W¹ 9 ¡ÿ2° Z * < J S \ ¡ f ¢ l £ u ¤ ¥ ¦ ª § Â ¨ Ú © ò ª
|
«$ ¬. ¢= ¯ p @ @ j k @ s @ s = l k : m n S í o p \ ä ê p i Ô r s u ¹ Û Ü « v G
|
w \ ä ê ë y M ÿ l z z 1 : : ÿ 3 z z 1 : : Ã F Ãÿ z z 1 : : Ã F Ã zP Ãÿ z z 1 : : Ã F Ã zP Ãÿ z z 1 : : Ã F Ã zP Ãÿ z z 1 : : Ã F Ã zP Ãÿ z z 1 : : Ã F Ã zQ Ãÿ z z 1 : : Ã F Ã zù ú ì 5 í LMîL*´ (+¹ * M,¹ 0 N-° ³ ´ µ ¶ · ¸ * l k m n o p w o ð ñ ò £ ¦ >MNóM*´ ¨õ¶ ¬*´ (,¹ * N-÷+¶ ù¹ W-À+¶ þ¹ W-¹ ´ W± & ½ ¾ ¿ À Á Â ) Ã 6 Ä = Å * > > < l k : m n
|
