3.7

fxl

2023-03-07 632a18ee7c83441a6036b90577424d2daad8d19c

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
Êþº¾3
E
"com/hxzkoa/services/WarningService
java/lang/Object
em
!Ljavax/persistence/EntityManager;
RuntimeVisibleAnnotations
&Ljavax/persistence/PersistenceContext;
<init>
()V
Code
   

LineNumberTable
LocalVariableTable
this
$Lcom/hxzkoa/services/WarningService;
getWarningSummary
()Ljava/util/List;
    Signature
0()Ljava/util/List<Lcom/hxzkoa/json/tb_warning;>;
5SELECT id,type,objectid,`status`,time FROM tb_warning 

javax/persistence/EntityManager
createNativeQuery
-(Ljava/lang/String;)Ljavax/persistence/Query;!#"
javax/persistence/Query$
 getResultList&
java/util/ArrayList
% )+*
java/util/List,-
size
()I/
com/hxzkoa/json/tb_warning
. )234
get
(I)Ljava/lang/Object;6
[Ljava/lang/Object;8
java/lang/Integer
7:;-
intValue
.=>?
setId
(I)VA

CDE
toString
()Ljava/lang/String;
.GHI
setType
(Ljava/lang/String;)V
.KLI
setObjectid
.NOI
 setStatus
.QRI
setTime)TUV
add
(Ljava/lang/Object;)Z
sql
Ljava/lang/String;
query
Ljavax/persistence/Query;

resultList
Ljava/util/List;
tb_warningList

i

I
warning
Lcom/hxzkoa/json/tb_warning;
obj
LocalVariableTypeTable
.Ljava/util/List<Lcom/hxzkoa/json/tb_warning;>;
 StackMapTableg
java/lang/String
(I)Ljava/util/List;
1(I)Ljava/util/List<Lcom/hxzkoa/json/tb_warning;>;k
XSELECT id,type,objectid,`status`,time FROM tb_warning ORDER BY id DESC LIMIT :start,:endm
start
oqp
com/hxzkoa/util/ConfigrE
 getPageConfigt
perPage
vxw
com/hxzkoa/util/ModifyConfigyz
readData
8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
7|}~
parseInt
(Ljava/lang/String;)I
7€‚
valueOf
(I)Ljava/lang/Integer;!„…†
setParameter
?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query;ˆ
end
page
getWarningSummaryCountŒ
SELECT count(1) FROM tb_warning!Ž
getSingleResult
()Ljava/lang/Object;
searchWarningSummary
$(Ljava/lang/String;)Ljava/util/List;
B(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_warning;>;•
PSELECT id,type,objectid,`status`,time FROM tb_warning WHERE objectid = :objectid—
objectid
input
getWarningSummaryType
()Ljava/util/Map;
8()Ljava/util/Map<Ljava/lang/String;Ljava/lang/Integer;>;
DSELECT type,count(1) c FROM tb_warning GROUP BY type ORDER BY c DESCŸ
java/util/HashMap
ž 

¢Š-¤¦¥
 java/util/Map§¨
put
8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;ª
其他
reMap
Ljava/util/Map;
warningSummaryCount
6Ljava/util/Map<Ljava/lang/String;Ljava/lang/Integer;>;
getRealinWarning
6()Ljava/util/List<Lcom/hxzkoa/json/tb_realinwarning;>;²
<SELECT id,area,name,bumen,tagid,intime FROM tb_realinwarning´
 com/hxzkoa/json/tb_realinwarning
³ 
³=
³¸¹I
setArea
³»¼I
setName
³¾¿I
setBumen
³ÁÂI
setTagid
³ÄÅI
 setIntime
tb_realinwarningList
 realinwarning
"Lcom/hxzkoa/json/tb_realinwarning;
4Ljava/util/List<Lcom/hxzkoa/json/tb_realinwarning;>;
7(I)Ljava/util/List<Lcom/hxzkoa/json/tb_realinwarning;>;Ì
NSELECT id,area,name,bumen,tagid,intime FROM tb_realinwarning LIMIT :start,:end
getRealinWarningCountÏ
%SELECT count(1) FROM tb_realinwarning
realinWarning_delete
([Ljava/lang/String;)V
:Lorg/springframework/transaction/annotation/Transactional;Ô
+DELETE FROM tb_realinwarning WHERE id = :idÖ
id!ØÙ-
 executeUpdate
checkVal
[Ljava/lang/String;
realinWarning_deleteAllÞ
DELETE FROM tb_realinwarning
searchRealinWarning
H(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_realinwarning;>;â
RSELECT id,area,name,bumen,tagid,intime FROM tb_realinwarning WHERE tagid = :tag_idä
tag_id
getHistoricalWarning
9()Ljava/util/List<Lcom/hxzkoa/json/tb_historyinwarning;>;è
VSELECT id,area,name,bumen,tagid,intime,outtime,alltime,beizhu FROM tb_historyinwarningê
#com/hxzkoa/json/tb_historyinwarning
é 
é=
é¸
é»
é¾
éÁ
éÄ
éóôI

setOuttime
éö÷I

setAlltime
éùúI
 setBeizhu
tb_historyinwarningList
historyinwarning
%Lcom/hxzkoa/json/tb_historyinwarning;
7Ljava/util/List<Lcom/hxzkoa/json/tb_historyinwarning;>;
:(I)Ljava/util/List<Lcom/hxzkoa/json/tb_historyinwarning;>;


hSELECT id,area,name,bumen,tagid,intime,outtime,alltime,beizhu FROM tb_historyinwarning LIMIT :start,:end
getHistoricalWarningCount

(SELECT count(1) FROM tb_historyinwarning
historicalWarning_delete

.DELETE FROM tb_historyinwarning WHERE id = :id
historicalWarning_deleteAll


DELETE FROM tb_historyinwarning
historicalWarning_handle
 
=UPDATE tb_warning SET status='已处理' WHERE objectid = :id
historicalWarning_handleAll

(UPDATE tb_warning SET status='已处理'
(historicalWarning_handleAll_realpositoin

"UPDATE tb_realpositoin SET sos='0'
searchHistoricalWarning
K(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_historyinwarning;>;

nSELECT id,area,'name',bumen,tagid,intime,outtime,alltime,beizhu FROM tb_historyinwarning WHERE tagid = :tag_id
warning_add
(Lcom/hxzkoa/json/tb_warning;)V

TINSERT tb_warning (type,objectid,status,time) VALUES (:type,:objectid,:status,now())

type
.

 E
getType
fC
.
#
$E
getObjectid
&
status
.
(
)E
 getStatus
realinwarning_add
%(Lcom/hxzkoa/json/tb_realinwarning;)V
-
_INSERT tb_realinwarning (area,name,bumen,tagid,intime) VALUES (:area,:name,:bumen,:tagid,now())
/
area
³
1
2E
getArea
4
name
³
6
7E
getName
9
bumen
³
;
<E
getBumen
>
tagid
³
@
AE
getTagid

SourceFile
WarningService.java
(Lorg/springframework/stereotype/Service;!




  

/

*·±


tÑ
L
ML*´+¹M,¹ 
N»%Y·':-¹(
ž¦6§•».Y·0:-¹1À5:2À7¶9¶<2Ç@§
2¶B¶F2Ç@§
2¶B¶J2Ç@§
2¶B¶M2Ç@§
2¶B¶P¹SW„
-¹(
¡ÿf°J "!+"1#:$G%V&n'†(ž)¶*À"Î-RÑÏWX
ÍYZ¸[\"¯]\. ^_:†`aGyb6c
"¯]de×ÿ1
f!))
ÿ2
f!))
.5
.ÿ
f!))
.5.fP.ÿ
f!))
.5.fP.ÿ
f!))
.5.fP.ÿ
f!))
.5.fùú

hi   

M
NjM*´,¹N-ld¸ns¸u¸{h¸¹ƒW-‡¸ns¸u¸{¸¹ƒW-¹ 
:»%Y·':¹(
ž¨6§–».Y·0:¹1À5:2À7¶9¶<2Ç@§
2¶B¶F2Ç@§
2¶B¶J2Ç@§
2¶B¶M2Ç@§
2¶B¶P¹SW„
¹(
¡ÿd°R12345-6D7L8U9_:e;n<|=‹>£?»@ÓAëBõ:
E\   

‰_

WX
YZL»[\U²]\b¢^_n‡`a|yb6c
U²]deÝÿe

f!))
ÿ3    

f!))
.5
.ÿ    

f!))
.5.fP.ÿ 

f!))
.5.fP.ÿ 

f!))
.5.fP.ÿ 

f!))
.5.fùú
Š-
m
L
M‹L*´+¹M,¹
¶B¸{¬IJKLM WX
YZ
‘’“¢   ß
M
N”M*´,¹N-–+¹ƒW-¹ 
:»%Y·':¹(
ž¨6§–».Y·0:¹1À5:2À7¶9¶<2Ç@§
2¶B¶F2Ç@§
2¶B¶J2Ç@§
2¶B¶M2Ç@§
2¶B¶P¹SW„
¹(
¡ÿd°NQRSTUV$W-X7Y=ZF[T\c]{^“_«`ÃaÍYÜd\   ßߘX
ÝWXÛYZ$»[\-²]\:¢^_F‡`aTyb6c
-²]deéÿ=
ff!))
ÿ3  
ff!))
.5
.ÿ  
ff!))
.5.fP.ÿ   
ff!))
.5.fP.ÿ   
ff!))
.5.fP.ÿ   
ff!))
.5.fùú
™š›
ÙË
L
MœL*´+¹M,¹ 
N»žY· :*¶¡6-¹(
¤\6§>-¹1À5:2¶B2¶B¸{¸¹£W2¶B¸{d6„
¡ÿ©¸¹£W§@6§/-¹1À5:2¶B2¶B¸{¸¹£W„
-¹(
¡ÿÌ°Rhijklm"n(o2p8qErasppyuˆv‹w‘xžyºwÈ|f
ËÉWX
ÇYZ²[\"©«¬(£­_5D^_E+b6Ž:^_žb6c
"©«®e&ÿ8
f!)¤

:úü
+ú

¯°·é
L
M±L*´+¹M,¹ 
N»%Y·':-¹(
ž¾6§­»³Y·µ:-¹1À5:2À7¶9¶¶2Ç@§
2¶B¶·2Ç@§
2¶B¶º2Ç@§
2¶B¶½2Ç@§
2¶B¶À2Ç@§
2¶B¶Ã¹SW„
-¹(
¡ÿN°N€‚ƒ„…"†+‡1ˆ:‰GŠV‹nŒ†žŽ¶ÎØ‡æ“RéçWX
åYZÐ[\"ÇÆ\.¸^_:žÇÈG‘b6c
"ÇÆÉeþ ÿ1
f!))
ÿ2
f!))
³5
³ÿ
f!))
³5³fP³ÿ
f!))
³5³fP³ÿ
f!))
³5³fP³ÿ
f!))
³5³fP³ÿ
f!))
³5³fùú

¯hÊ   

M
NËM*´,¹N-ld¸ns¸u¸{h¸¹ƒW-‡¸ns¸u¸{¸¹ƒW-¹ 
:»%Y·':¹(
žÀ6§®»³Y·µ:¹1À5:2À7¶9¶¶2Ç@§
2¶B¶·2Ç@§
2¶B¶º2Ç@§
2¶B¶½2Ç@§
2¶B¶À2Ç@§
2¶B¶Ã¹SW„
¹(
¡ÿL°V—˜™š›-œDLžUŸ_ e¡n¢|£‹¤£¥»¦Ó§ë¨
©
  
¬\   

‰_

WX
YZLÓ[\UÊÆ\bº^_nŸÇÈ|‘b6c
UÊÆÉe
 ÿe

f!))
ÿ3    

f!))
³5
³ÿ    

f!))
³5³fP³ÿ 

f!))
³5³fP³ÿ 

f!))
³5³fP³ÿ 

f!))
³5³fP³ÿ 

f!))
³5³fùú
Í-
m
L
MÎL*´+¹M,¹
¶B¸{¬°±²³´ WX
YZ
ÐÑ
ÒÔA
M
N6§2+2¸{6ÓM*´,¹N-Õ¸¹ƒW-¹×
W„
+¾¡ÿͱ*
¹º»
¼½¾!¿/À6»@Â>AAÚÛ
?WX=YZ9^_#Ö_e þ
f!
.
Ü

Òl
L
MÝL*´+¹M,¹×
W±ÆÇÈÉÊË WX
YZ
ߒàÕ   è
M
NáM*´,¹N-ã+¹ƒW-¹ 
:»%Y·':¹(
ž±6§Ÿ»³Y·µ:¹1À5:2Ç@§
2¶B¶·2Ç@§
2¶B¶º2Ç@§
2¶B¶½2Ç@§
2¶B¶À2Ç@§
2¶B¶Ã¹SW„
¹(
¡ÿ[°NÎÏÐÑÒÓ$Ô-Õ7Ö=×FØTÙlڄܴۜÝÌÞÖÖåá\   èè˜X
æWXäYZ$Ä[\-»Æ\:«^_FÇÈT‚b6c
-»ÆÉe
 ÿ=
ff!))
ÿ$  
ff!))
³5
³ÿ  
ff!))
³5³fP³ÿ   
ff!))
³5³fP³ÿ   
ff!))
³5³fP³ÿ   
ff!))
³5³fP³ÿ   
ff!))
³5³fùú
åæ†
7
L
MçL*´+¹M,¹ 
N»%Y·':-¹(
ž
6§û-¹1À5:»éY·ë:2À7¶9¶ì2Ç@§
2¶B¶í2Ç@§
2¶B¶î2Ç@§
2¶B¶ï2Ç@§
2¶B¶ð2Ç@§
2¶B¶ñ2Ç@§2¶B¶ò2Ç@§2¶B¶õ2Ç@§2¶B¶ø¹SW„
-¹(
¡ÿ°Zåæçèéê"ë+ì1í>îGïVðnñ†òžó¶ôÎõèö
÷
ø
&ì
4ûR
7
5WX

3YZ
[\"
û\.
^_>èb6Gßüýc
"
ûþe
sÿ1
f!))
ÿ2
f!))
5é
éÿ
f!))
5ééfPéÿ
f!))
5ééfPéÿ
f!))
5ééfPéÿ
f!))
5ééfPéÿ
f!))
5ééfQéÿ
f!))
5ééfQéÿ
f!))
5ééfQéÿ
f!))
5ééfùú

åhÿÙ   
n
M
N
M*´,¹N-ld¸ns¸u¸{h¸¹ƒW-‡¸ns¸u¸{¸¹ƒW-¹ 
:»%Y·':¹(
ž
6§ü¹1À5:»éY·ë:2À7¶9¶ì2Ç@§
2¶B¶í2Ç@§
2¶B¶î2Ç@§
2¶B¶ï2Ç@§
2¶B¶ð2Ç@§
2¶B¶ñ2Ç@§2¶B¶ò2Ç@§2¶B¶õ2Ç@§2¶B¶ø¹SW„
¹(
¡þþ°bÿ




.
E
M
V
`
f
 t

}
Œ
¤
 ¼
Ô
ì





8

R

\

k
\ 
n
n‰_

lWX
jYZM
![\V
û\c
^_tèb6}ßüýc
V
ûþe
}ÿf

f!))
ÿ3    

f!))
5é
éÿ    

f!))
5ééfPéÿ 

f!))
5ééfPéÿ 

f!))
5ééfPéÿ 

f!))
5ééfPéÿ 

f!))
5ééfQéÿ 

f!))
5ééfQéÿ 

f!))
5ééfQéÿ 

f!))
5ééfùú

-
n 
L
M
L*´+¹M,¹
¶B¸{¬




  WX
YZ

Ñ
ÒÕB
M
N6§3+2¸{6
M*´,¹N-Õ¸¹ƒW-¹×
W„
+¾¡ÿ̱*

$
%
&

'
(
)"
*0
+7
&A
->BBÚÛ
@WX>YZ:^_$Ö_e þ
f!
/



Òm
L
M
  L*´+¹M,¹×
W±
1
2
3
4
5
6 WX
YZ

Ñ
ÒÕB
M
N6§3+2¸{6
M*´,¹N-Õ¸¹ƒW-¹×
W„
+¾¡ÿ̱*

:
;
<

=
>
?"
@0
A7
<A
C>BBÚÛ
@WX>YZ:^_$Ö_e þ
f!
/



Òm
L
M
L*´+¹M,¹×
W±
G
H
I
J
K
L WX
YZ



Òm
L
M
L*´+¹M,¹×
W±
P
Q
R
S
T
U WX
YZ

’
®  
7
M
N
M*´,¹N-ã+¹ƒW-¹ 
:»%Y·':¹(
žÿ6§í¹1À5:»éY·ë:2Ç@§
2¶B¶í2Ç@§
2¶B¶î2Ç@§
2¶B¶ï2Ç@§
2¶B¶ð2Ç@§
2¶B¶ñ2Ç@§2¶B¶ò2Ç@§2¶B¶õ2Ç@§2¶B¶ø¹SW„
¹(
¡ÿ °Z
X
Y
Z
[
\
]%
^.
_8
`>
aL
bU
cm
d…
e
fµ
gÍ
hç
i


j

k
%
`
4
n\ 
7
7˜X

5WX
3YZ%
[\.
   û\;ù^_LÙb6UÐüýc
.
 ûþe
‘ÿ>
ff!))
ÿ$    
ff!))
5é
éÿ  
ff!))
5ééfPéÿ   
ff!))
5ééfPéÿ   
ff!))
5ééfPéÿ   
ff!))
5ééfPéÿ   
ff!))
5ééfQéÿ   
ff!))
5ééfQéÿ   
ff!))
5ééfQéÿ   
ff!))
5ééfùú



Ò¯G
M
N
M*´,¹N-
+¶
¶
!¹ƒW-–+¶
"¹ƒW-
%+¶
'¹ƒW-¹×
W±& 
s
t
u
v
w$
x1
y?
zF
{*GG`a
EWXCYZ

*
+
Ò¿S
M
N
,M*´,¹N-
.+¶
0¹ƒW-
3+¶
5¹ƒW-
8+¶
:¹ƒW-
=+¶
?¹ƒW-¹×
W±*


€

‚
ƒ!
„/
…=
†K
‡R
ˆ*SSÇÈ
QWXOYZ
B
C

D