优化SQL

czt

2025-06-12 930d29f39d115fe76c305af4320c2acbcb30c445

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
112
Êþº¾4
Œèé
èê
èë
ìí
î
ïðñò
ïó
Šô
õö    Š÷
õø
õùúû    Šüýþÿ
õ

 
õ

 
 



    ú


þ

 
 
&è


ø
&

!

&

 
&

!

 
 
&

!


 
!
&
"
!
#
&
$
!
%
 

&
&
'
!
(
!
)
 

*
&
+

,    Š
-
.
/    Š
0    
1
2    
3
4
5
Dè



#
D
6
7
D
8
9
:
;
<


=
>
L
8

?
@
A

?
B
C
D
E
F
V
G
 

H    Š
I
V

J
K
L
M
N
O
P
`è
_

`
Q
_
#
`
$
_
R
 

S
`
T
`


U
V
`
W
J
X
Y
mè
m

m

_
Z
m
[
_
\
D
]
^
_
_
_
`
m
a
_
b
m
c
_
d
m
e
_
f
m
g
_
h
m
i
m
j
m
k
m
l
_
m
_
n
m
o
J
p
q
r
s

t
u
v
log
Lorg/slf4j/Logger;
BEAN_ID
Ljava/lang/String;
 ConstantValueç
coreSerService
#Lcom/ld/igds/common/CoreSerService;
RuntimeVisibleAnnotations
8Lorg/springframework/beans/factory/annotation/Autowired;
coreCommonService
&Lcom/ld/igds/common/CoreCommonService;
 deviceService
&Lcom/ld/igds/common/CoreDeviceService;
notifyWebInvoker
(Lcom/ld/igds/io/notify/NotifyWebInvoker;
<init>
()V
Code
LineNumberTable
LocalVariableTable
this
3Lcom/ld/igds/protocol/fzzy/analysis/AnalysisSystem;
analysis1001
,(Lcom/ld/igds/protocol/fzzy/dto/ReMessage;)V
    reMessage
)Lcom/ld/igds/protocol/fzzy/dto/ReMessage;
response
-Lcom/ld/igds/protocol/fzzy/resp/Response1001;
commandBuilder
8Lcom/ld/igds/protocol/fzzy/builder/ObjectCommandBuilder;
message
+Lcom/ld/igds/protocol/fzzy/dto/SendMessage;
ser
Lcom/ld/igds/models/DeviceSer;
 StackMapTableé
w
x
y
analysis1003
J(Lcom/ld/igds/protocol/fzzy/dto/ReMessage;Lcom/ld/igds/models/DeviceSer;)V
response1003
-Lcom/ld/igds/protocol/fzzy/resp/Response1003;
device
Lcom/ld/igds/models/Device;
list
Ljava/util/List;
index

I
LocalVariableTypeTable
?Ljava/util/List<Lcom/ld/igds/protocol/fzzy/resp/Response1003;>;
s
z
{
|

 
analysis1004
request
+Lcom/ld/igds/protocol/fzzy/req/Request1004;
8Lcom/ld/igds/protocol/fzzy/builder/SimpleCommandBuilder;
analysis1005
analysis1006
+Lcom/ld/igds/protocol/fzzy/req/Request1006;
analysis1007
+Lcom/ld/igds/protocol/fzzy/req/Request1007;
status
requestList
=Ljava/util/List<Lcom/ld/igds/protocol/fzzy/req/Request1007;>;
}
~
analysis1008
analysis1009
analysis1010
resp
-Lcom/ld/igds/protocol/fzzy/resp/Response1010;
depot
Lcom/ld/igds/models/Depot;
    depotConf
Lcom/ld/igds/models/DepotConf;
?Ljava/util/List<Lcom/ld/igds/protocol/fzzy/resp/Response1010;>;
P
Y
O
<clinit>

SourceFile
AnalysisSystem.java
*Lorg/springframework/stereotype/Component;
value
fzzy.analysisSystemž
+com/ld/igds/protocol/fzzy/resp/Response1001
java/util/Date
yyyyMMddHHmmss

€

‚
ƒ
w
„
…
%com/ld/igds/protocol/fzzy/ServerUtils
1001
†
‡
ˆ
‰
z
Š
‹“”
Œ
‹

‹
Ž

Ž
v控制柜----->>>平台：组织编码={}，分机ID={}，系统没有获取到分机信息，报文无法进行解析
‘
’
“
”
‹
y
•
ƒ
–
—
˜
™
š
›
œ
com/ld/igds/constant/Constant

Y

ƒ
ž
Ÿ
;控制柜----->>>平台：控制柜上线更新完成-IP={}
 
¡
+com/ld/igds/protocol/fzzy/resp/Response1003
¢
£
¤
{
¥
¦
|
§
¨
©
ª
com/ld/igds/models/Device
«
ƒ
¬
‹
­
ƒ
®
‹
¯
ƒ
°
‹
™
±
²
—
³
´
µ
‹
¶
·
¸
¹
ƒ
º
‹
»
ƒ
¼
‹
½
¾
¿
ƒ
À
‹
Á
¨
Â
Ã
Ä
ƒ
Å
—™š
Æ
Ç
È›œ
É
Ê
Ë
Ì
Í
Î
java/lang/StringBuilder
Ï
Ð
+ è¿œç¨‹èŽ·å–设备信息并解析完成！
Ñ
‹
Ò
Ó
Ô
Q控制柜----->>>平台：控制柜设备列表同步到平台完成-控制柜={}
)com/ld/igds/protocol/fzzy/req/Request1004
Õ
Ö
B控制柜----->>>平台：控制柜推送警告信息-控制柜={}
}
„
×
1004
†
Ø
1005
)com/ld/igds/protocol/fzzy/req/Request1006
1007
)com/ld/igds/protocol/fzzy/req/Request1007
Ù
‹
Ú
Û—˜
Ü
Ý
Þ
N控制柜----->>>平台：控制柜仓库状态信息同步完成-控制柜={}
!仓库状态远程同步成功！
 è¿œç¨‹æŽˆæƒæˆåŠŸï¼
+com/ld/igds/protocol/fzzy/resp/Response1010
com/ld/igds/models/Depot
ß
ƒ
à
‹
á
Û
â
ƒ
ã
ä
å
æ
ƒ
ç
è
com/ld/igds/models/DepotConf
é
‹
ê
ƒ
ë
ì
Ï
í

-
î
ì
ï
ì
ð
ƒ
ñ
ì
ò
´
ó
ì
ô
´
õ
ì
ö
´
÷
ì
ø
´
ù
´
ú
´
û
ƒ
ü
‹
ý
‹
þ
ƒ
ÿ
+ è¿œç¨‹èŽ·å–仓库信息并解析完成！
N控制柜----->>>平台：控制柜仓库配置信息同步完成-控制柜={}
1com/ld/igds/protocol/fzzy/analysis/AnalysisSystem

0com/ld/igds/protocol/fzzy/command/BaseRemoteImpl
6com/ld/igds/protocol/fzzy/builder/ObjectCommandBuilder
)com/ld/igds/protocol/fzzy/dto/SendMessage
com/ld/igds/models/DeviceSer
'com/ld/igds/protocol/fzzy/dto/ReMessage
java/util/List
java/util/Iterator
6com/ld/igds/protocol/fzzy/builder/SimpleCommandBuilder
java/lang/String
-org/apache/commons/lang3/time/DateFormatUtils
format
6(Ljava/util/Date;Ljava/lang/String;)Ljava/lang/String;
setTime
(Ljava/lang/String;)V
getInstance
:()Lcom/ld/igds/protocol/fzzy/builder/ObjectCommandBuilder;
buildMessage
z(Lcom/ld/igds/protocol/fzzy/dto/ReMessage;Ljava/lang/String;Ljava/lang/Object;)Lcom/ld/igds/protocol/fzzy/dto/SendMessage;
send
I(Lcom/ld/igds/protocol/fzzy/dto/SendMessage;)Lcom/ld/io/api/InvokeResult;

getContent
()Ljava/lang/String;
getCompanyId
getIedId
!com/ld/igds/common/CoreSerService
getCacheSer
D(Ljava/lang/String;Ljava/lang/String;)Lcom/ld/igds/models/DeviceSer;
org/slf4j/Logger
warn
9(Ljava/lang/String;Ljava/lang/Object;Ljava/lang/Object;)V
getIp
setIp
getPort
()I
java/lang/Integer
valueOf
(I)Ljava/lang/Integer;
setPort
(Ljava/lang/Integer;)V
    setStatus
updateByData
!(Lcom/ld/igds/models/DeviceSer;)V
info
'(Ljava/lang/String;Ljava/lang/Object;)V
com/alibaba/fastjson/JSONObject

parseArray
5(Ljava/lang/String;Ljava/lang/Class;)Ljava/util/List;
iterator
()Ljava/util/Iterator;
hasNext
()Z
next
()Ljava/lang/Object;
setCompanyId

getHouseId

setDepotId
getId
setSerId
getDeviceId
'(Ljava/lang/String;)Ljava/lang/Integer;
intValue
setPassCode
(I)V
getFanId
$org/apache/commons/lang3/StringUtils

isNotEmpty
(Ljava/lang/CharSequence;)Z
setLink
getName
setName
getPos
analysisLocation
8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
setLocation
getType
isFan
analysisDeviceType
'(Ljava/lang/String;Z)Ljava/lang/String;
setType
size
$com/ld/igds/common/CoreDeviceService
updateDeviceNoId
(Lcom/ld/igds/models/Device;Z)V
%com/ld/igds/io/constant/OrderRespEnum
MSG_SUCCESS
'Lcom/ld/igds/io/constant/OrderRespEnum;
com/ld/igds/constant/BizType
SYS
Lcom/ld/igds/constant/BizType;
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
toString
&com/ld/igds/io/notify/NotifyWebInvoker
    notifyWeb
l(Ljava/lang/String;Lcom/ld/igds/io/constant/OrderRespEnum;Lcom/ld/igds/constant/BizType;Ljava/lang/String;)V
parseObject
7(Ljava/lang/String;Ljava/lang/Class;)Ljava/lang/Object;
:()Lcom/ld/igds/protocol/fzzy/builder/SimpleCommandBuilder;
](Lcom/ld/igds/models/DeviceSer;Ljava/lang/String;)Lcom/ld/igds/protocol/fzzy/dto/SendMessage;
    getStatus
analysisDepotStatus
&(Ljava/lang/String;)Ljava/lang/String;
$com/ld/igds/common/CoreCommonService
updateDepotStatus
9(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
setId
getHouseType
analysisDepotType
setDepotType
com/ld/igds/util/ContextUtil
    subDeptId
8(Lcom/bstek/bdf2/core/business/IUser;)Ljava/lang/String;
    setDeptId
updateDepot
(Lcom/ld/igds/models/Depot;)V
 getTempHumChn
    setThConf
getLay
()Ljava/lang/Integer;
-(Ljava/lang/Object;)Ljava/lang/StringBuilder;
getRow
getCol
setCableRule
getStartCol
 setCableStart
    getEndCol
setCableEnd

getStartNo
setGasStart
getEndNo
    setGasEnd
setPestStart

setPestEnd
setGrainSer
    getLayout
getLayerPerCircle
setCableCir
updateDepotConf
!(Lcom/ld/igds/models/DepotConf;)V
org/slf4j/LoggerFactory
    getLogger
%(Ljava/lang/Class;)Lorg/slf4j/Logger;!ŠŒŽ
‘’“”
•
–—˜
•
–™š
•
–›œ
•
–
ž
Ÿ/

*·
± 
,¡
¢£
¤¥
Ÿ
J˜»Y·M,»Y·¸¶¸    N-+,¶:*¶ W
+¶¦±*´+¶+¶¹:
¦²+¶+¶¹±+¶¶+¶¸¶¶*´¹²+¶¹ ± B<=>?&@-B6DIEOFaGbKkLwM~N‰R—S¡>˜¢£˜¦§
¨©|ª«&r¬­IO®¯°þ6±²³ü+´
µ¶
Ÿ'
+¶!¸"N6-¹#
:¹$
™³¹%
À!:»&Y·':,¶(¶)¶*¶+,¶,¶-¶.¸/¶0¶1¶2¸3™ ¶2¶4¶5¶6¶7¶5¸8¶9¶:¶;¸<¶=„
-¹>
 *´?¹@§*´?¹@§ÿI*´A,¶(²B²C»DY·E,¶F¶GH¶G¶I¹J²K,¶F¹ ± VV
Y Z+[4\=]G^P_``kaucd‘f£h¦j±kÀmÌoÏpør
s¡H+¡·¸4›¹º
¢£
¦§

®¯
ý»¼ ú½¾¿

ý»À°RÿÁ´Ã
Äÿ_Á´ÃÅ
ÄÆûJúÿÁ´Ã

Ƕ
Ÿ¢2+¶L¸MÀLN²N-¶O¹ ¸P:,Q¶R:*¶ W± v x{ |*}1~¡>2¢£2¦§
2®¯ %ÈÉ ªÊ*¬­
˶
Ÿs¸PN-,S¶R:*¶ W± „… †‡¡4¢£¦§
®¯ªÊ ¬­
̶
ŸZ+¶T¸MÀTN± 
Œ ¡*¢£¦§
®¯ 
ÈÍ
ζ
Ÿ
a    t¸PN-,U¶R:*¶ W+¶V¸":¹#
:¹$
™6¹%
ÀV:¶W¸X:
¥*´Y,¶(¶Z¹[§ÿƲ\,¶F¹ ± *
“” •™œ>HžbŸe¡s£¡R>$ÈÏHАt¢£t¦§
t®¯pªÊ g¬­UѼ¿
UÑÒ°Aÿ(Á´ӳÃÄÿ9Á´ӳÃÔÄù
Õ¶
ŸX*´A,¶(²B²C]¹J± 
§¨¡ ¢£¬§
®¯
Ö¶
Ÿl**´A,¶(²B²C»DY·E,¶F¶G^¶G¶I¹J± 
¬)­¡ *¢£*¬§
*®¯
׶
Ÿ¼
‚+¶_¸"N-¹#
:¹$
™
1¹%
À_:»`Y·a:¶b¶c¶d¶e¶f¸g¶h,¶(¶i
¸j¶k*´Y¹l»mY·n:,¶(¶o¶b¶p¶q¶r»DY·E¶s¶tu¶G¶v¶tu¶G¶w¶t¶I¶x¶y¶0¶z¶{¶0¶|¶}¶0¶~¶¶0¶€¶}¶0¶¶¶0¶‚,¶,¶ƒ¶„¸3™ ¶„¶x¶…¶†*´Y¹‡§þË*´A,¶(²B²C»DY·E,¶F¶Gˆ¶G¶I¹J²‰,¶F¹ ± v°
´(µ1¶;·E¸R¹[»d½o¿xÀÁ‹Â•ÃÆÅÓÆàÈíÉúË
Ì
Í
Ï
(Ð
2Ò
<Ô
GÖ
J×
sÙ
Ú¡H(
ØÙ1
ÚÛxÒÜÝ
‚¢£
‚¦§

‚®¯

x»¼¿


x»Þ°LÿÁ´ÃÄÿ
Á´ÃßàÄáÿÁ´Ãâž
Ÿ!
    Š¸‹³±
 
*ãä•
å
æsç