优化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
113
114
115
116
117
118
Êþº¾4X
¢
6

7
8
9

:
;
<

6
=

>
?

@
A

B
C

7
D    ¡
E

F
G
H
I

J
¡
K
L

6

7
MÐ

N    ¡
O

P
Q
RÑ
S
T

6
U
V

W

X    ¡
Y

Z
[Õ    ¡
\

]
^
_
(
6×
`    
a
b

a
c
d
e
f    ¡
g

h
iØ

P
jÚ

P
k

l
m
n

:
o

P
p
q

r

:
sÞ
t

P
uß
v

w

Z
x

h
y

h
z
{

B
|
}¼
~

L
6
L
W
L
€

L
‚


ƒ

„
V

„
W

„
…

„
X    ¡
†

‡
ˆ
‰    
Š
‹

Š
c
Œ
Z

Ž

P



‘

‡
’
“
”
•

‡
–
—
˜
™
q
š
q
›
k
œ
k
š

ž
Ÿ
 
¡
¢
£
U
¤
U
¥
t
¦

§
¨
©
ª
U
«
¬
­
®
¯|
r
°|
±

P
²

P
³


P
´


¡
µ

¶
¬
·
¸
¹
¸
º
»
¼
Ž
6

±

‡
½

‡
¾
¬
¿
À
Á
”
Â
Ž
Ã
Ž
Ä
Å
Ž
Æ
Ž
Ç
Ž
È
Ž
É
Ž
Ê
Ž
Ë
Ì
Í
Î
Ï
grainManager
(Lcom/ld/igds/grain/manager/GrainManager;
RuntimeVisibleAnnotations
8Lorg/springframework/beans/factory/annotation/Autowired;

gasManager
$Lcom/ld/igds/gas/manager/GasManager;
 commonManager
*Lcom/ld/igds/common/manager/CommonManager;
inoutCommonManager
.Lcom/ld/igds/inout/manager/InoutCommonManager;
sysUserService
(Lcom/ld/igds/sys/service/SysUserService;
databoardManager
0Lcom/ld/igds/databoard/manager/DataboardManager;
<init>
()V
Code
LineNumberTable
LocalVariableTable
this
6Lcom/ld/igds/databoard/controller/DataboardController;
indexGateway
8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;

u
Ljava/lang/String;
tag
    companyId
 StackMapTable
Ð
8Lorg/springframework/web/bind/annotation/RequestMapping;
value
/index-gateway
"RuntimeVisibleParameterAnnotations
6Lorg/springframework/web/bind/annotation/RequestParam;
required
index
B(Ljava/lang/String;)Lorg/springframework/web/servlet/ModelAndView;
user
'Lcom/bstek/bdf2/core/model/DefaultUser;
defaultDept
'Lcom/bstek/bdf2/core/model/DefaultDept;
$Lcom/bstek/bdf2/core/business/IUser;
view
.Lorg/springframework/web/servlet/ModelAndView;
deptId
    listDepot
Ljava/util/List;
param
"Lcom/ld/igds/grain/dto/GrainParam;
mapGrain
Ljava/util/Map;
mapGas
deptInfo
%Lcom/ld/igds/databoard/data/DeptInfo;
    dicSlogan
Lcom/ld/igds/models/DicSlogan;
sysConf
Lcom/ld/igds/models/DicSysConf;
largeScreenName
weatherInfo
 Lcom/ld/igds/models/WeatherInfo;
LocalVariableTypeTable
,Ljava/util/List<Lcom/ld/igds/models/Depot;>;
DLjava/util/Map<Ljava/lang/String;Lcom/ld/igds/grain/dto/GrainData;>;
@Ljava/util/Map<Ljava/lang/String;Lcom/ld/igds/gas/dto/GasData;>;

Î
Ñ
L
Ò
T
Ó
Ô
Õ
Ö
»
×
queryGrainData
C(Lcom/ld/igds/grain/dto/GrainParam;)Lcom/ld/igds/data/PageResponse;
    Signature
‰(Lcom/ld/igds/grain/dto/GrainParam;)Lcom/ld/igds/data/PageResponse<Ljava/util/Map<Ljava/lang/String;Lcom/ld/igds/grain/dto/GrainData;>;>;
/query-grain-data-map
6Lorg/springframework/web/bind/annotation/ResponseBody;
5Lorg/springframework/web/bind/annotation/RequestBody;
    index5303
T(Ljava/lang/String;Ljava/lang/String;)Lorg/springframework/web/servlet/ModelAndView;
depotGrainList
 chartFood5303
'Lcom/ld/igds/screen/data/ChartFood5303;
:Ljava/util/List<Lcom/ld/igds/screen/data/DepotGrainData;>;
Ø
Ù

index-5303
inout
 initInoutData
=(Lcom/ld/igds/data/BaseParam;)Lcom/ld/igds/data/PageResponse;
Lcom/ld/igds/data/BaseParam;
Q(Lcom/ld/igds/data/BaseParam;)Lcom/ld/igds/data/PageResponse<Ljava/lang/String;>;
/init-inout-data
check
user2
sort
 listInoutConf
conf
Lcom/ld/igds/models/InoutConf;
0Ljava/util/List<Lcom/ld/igds/models/InoutConf;>;
 initCheckData
/init-check-data
registerLoginInfo
'(Lcom/bstek/bdf2/core/business/IUser;)V
holder
DLorg/springframework/security/web/context/HttpRequestResponseHolder;
auth
QLorg/springframework/security/authentication/UsernamePasswordAuthenticationToken;
group
depts
iDept
$Lcom/bstek/bdf2/core/business/IDept;
deptList
warnList
inoutMap
6Ljava/util/List<Lcom/bstek/bdf2/core/business/IDept;>;
9Ljava/util/List<Lcom/bstek/bdf2/core/model/DefaultDept;>;
2Ljava/util/List<Lcom/ld/igds/warn/data/WarnData;>;
FLjava/util/Map<Ljava/lang/String;Lcom/ld/igds/inout/dto/InoutSumDto;>;
®

d
listInoutByDeptId
!(Ljava/util/List;)Ljava/util/Map;
    inoutData
!Lcom/ld/igds/inout/dto/InoutData;
dept
inoutDto
#Lcom/ld/igds/inout/dto/InoutSumDto;
map
list1
list2
3Ljava/util/List<Lcom/ld/igds/inout/dto/InoutData;>;
Ú
¼
À
(Ljava/util/List<Lcom/bstek/bdf2/core/model/DefaultDept;>;)Ljava/util/Map<Ljava/lang/String;Lcom/ld/igds/inout/dto/InoutSumDto;>;

SourceFile
DataboardController.java
+Lorg/springframework/stereotype/Controller;
basic/databoard±²
Û
Ü
Ý
5303
Ð
Þ
ß
java/lang/StringBuilder
redirect:index-5303?u=
à
á
&tag=
â
Ý
redirect:index?u=
ã
ä
å
æ
ç­®
è
é
ê
0com/bstek/bdf2/core/exception/NoneLoginException
NO Login User Info±
ë


,org/springframework/web/servlet/ModelAndView
ì
í
î
ï©ª
ðÑ
ñ
com/ld/igds/constant/Constant
    loginUser
 com/ld/igds/grain/dto/GrainParam
Ñ
ò
Ý
ó
ë
ô
ë£¤
õ
ö
÷§¨
ø
ù
ú
java/util/HashMap
bizType
û
ü
ý
þ
Ý
bizTag
%com/ld/igds/websocket/WebSocketPacket
common¯°
ÿ

Ö
Ý
SUB_NAME    


Ý 
综合大屏
databoard/databoard
ëò
    chartFood
å

1
databoard/databoard-5303
%com/bstek/bdf2/core/model/DefaultUser
ë
出入库大屏
ë
databoard/databoard-inout
Ý«¬
com/ld/igds/data/PageResponse 
    æˆåŠŸï¼±
化验大屏Ñ!
智慧粮库化验室引导
化验室引导"
com/ld/igds/inout/InoutConstant
60
CHECK#$
camera
databoard/databoard-check
Borg/springframework/security/web/context/HttpRequestResponseHolder%&'(±)*+,
)com/bstek/bdf2/core/context/ContextHolder
BDF_LOGIN_USER_-./
Oorg/springframework/security/authentication/UsernamePasswordAuthenticationToken0
Ý12±3456789:;
Ò<=
"com/bstek/bdf2/core/business/IDept
$智慧粮库综合管理数字大屏
数字大屏>
Ý?@
ñA
ñ
#
$
databoard/databoard-groupBC
ÚDEFG
%com/bstek/bdf2/core/model/DefaultDept
!com/ld/igds/inout/dto/InoutSumDtoH
ñI
ñJK
com/ld/igds/inout/dto/InoutData
INL
ÝMKNO
OUTPKQORKSOTKUO
ÓVW
4com/ld/igds/databoard/controller/DataboardController
java/lang/Object
java/lang/String
"com/bstek/bdf2/core/business/IUser
java/util/List
 java/util/Map
#com/ld/igds/databoard/data/DeptInfo
com/ld/igds/models/DicSlogan
com/ld/igds/models/DicSysConf
java/lang/CharSequence
com/ld/igds/models/WeatherInfo
%com/ld/igds/screen/data/ChartFood5303
java/util/Iterator
com/ld/igds/util/ContextUtil
getDefaultCompanyId
()Ljava/lang/String;
equals
(Ljava/lang/Object;)Z
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
toString
$org/apache/commons/lang3/StringUtils

isNotEmpty
(Ljava/lang/CharSequence;)Z
getLoginUser
&()Lcom/bstek/bdf2/core/business/IUser;
&com/ld/igds/sys/service/SysUserService
loadUser
;(Ljava/lang/String;)Lcom/bstek/bdf2/core/model/DefaultUser;
(Ljava/lang/String;)V
    subDeptId
8(Lcom/bstek/bdf2/core/business/IUser;)Ljava/lang/String;
    addObject
T(Ljava/lang/String;Ljava/lang/Object;)Lorg/springframework/web/servlet/ModelAndView;
(com/ld/igds/common/manager/CommonManager
$(Ljava/lang/String;)Ljava/util/List;
getCompanyId
setCompanyId
    setDeptId
&com/ld/igds/grain/manager/GrainManager
getCacheGrainDateMap
3(Lcom/ld/igds/grain/dto/GrainParam;)Ljava/util/Map;
"com/ld/igds/gas/manager/GasManager
getCacheGasMap
5(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Map;
com/ld/igds/constant/BizType
SCREEN
Lcom/ld/igds/constant/BizType;
getCode
.com/ld/igds/databoard/manager/DataboardManager
getDeptInfo
9(Ljava/lang/String;)Lcom/ld/igds/databoard/data/DeptInfo;
getDicSlogan
 ()Lcom/ld/igds/models/DicSlogan;

getSysConf
3(Ljava/lang/String;)Lcom/ld/igds/models/DicSysConf;
getScreeName
indexOf
(Ljava/lang/String;)I

getSubDept
_(Lcom/bstek/bdf2/core/business/IUser;Ljava/lang/String;)Lcom/bstek/bdf2/core/model/DefaultDept;
getName
replace
D(Ljava/lang/CharSequence;Ljava/lang/CharSequence;)Ljava/lang/String;

getWeather
"()Lcom/ld/igds/models/WeatherInfo;
setViewName
queryCheckDateMap
listDepotAndGrain
6(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List;
 getFoodNumber
M(Ljava/lang/String;Ljava/lang/String;)Lcom/ld/igds/screen/data/ChartFood5303;
isEmpty
setUsername
setCname
com/ld/igds/data/BaseParam
    getDeptId
,com/ld/igds/inout/manager/InoutCommonManager
initInoutScreen
'(Ljava/lang/String;Ljava/lang/String;)V
!com/ld/igds/constant/RespCodeEnum
    CODE_0000
#Lcom/ld/igds/constant/RespCodeEnum;
%(ZLjava/lang/String;)Ljava/util/List;
getListInoutConf
getInoutConf
g(Ljava/util/List;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;I)Lcom/ld/igds/models/InoutConf;

getRequest
)()Ljavax/servlet/http/HttpServletRequest;
getResponse
*()Ljavax/servlet/http/HttpServletResponse;
R(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V
%javax/servlet/http/HttpServletRequest

getSession
"()Ljavax/servlet/http/HttpSession;
javax/servlet/http/HttpSession
setAttribute
'(Ljava/lang/String;Ljava/lang/Object;)V
getPassword
getAuthorities
()Ljava/util/Collection;
=(Ljava/lang/Object;Ljava/lang/Object;Ljava/util/Collection;)V
?org/springframework/security/core/context/SecurityContextHolder

getContext
=()Lorg/springframework/security/core/context/SecurityContext;
9org/springframework/security/core/context/SecurityContext
setAuthentication
5(Lorg/springframework/security/core/Authentication;)V
getDepts
()Ljava/util/List;
get
(I)Ljava/lang/Object;
getId
listDepotByDeptId
getDeptListByDeptId
listWarnByDeptId
iterator
()Ljava/util/Iterator;
hasNext
()Z
next
()Ljava/lang/Object;
getListInoutCache
getCompleteListInoutCache
size
()I
getType
getInSumNum
setInSumNum
(I)V
getOutSumNum
setOutSumNum
getInComplateNum
setInComplateNum
getOutComplateNum
setOutComplateNum
put
8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;!¡¢£¤
¥
¦§¨
¥
¦©ª
¥
¦«¬
¥
¦­®
¥
¦¯°
¥
¦
±²
³/

*·
±´
:µ
¶·
¸¹³ >¸N-¶™ »Y·¶+¶    ¶,¶¶
°»Y·¶+¶¶
°´RT U*Yµ*>¶·>º»
>¼»:½»¾
ü*¿¥
À
Á[
sÂÃ!
ÄÁsºÅZÆ
ÄÁs¼ÅZÆ
Çȳ”
o+¸™'
¸ ¦ *´+¶M
,¦ »Y·¿*,¶¸ M»Y·N,¸:-¶W*´¶:-¶W-,¶W»Y·:,¹ 
¶!¶"*´#¶$:-%¶W*´&,¹ 
¶':Ç»(Y·):-*¶W-+²,¶-¶W-.0¶W*´1¶2:    -3    ¶W*´¶4:
-5
¶W*´,¹ 
¶6:¶7:8¶9Ÿ'*´,¶:: 8 Ç;§ ¶<¶=:->»Y·¶?¶¶
¶W*´¶@: -A ¶W-B¶C-°´ž'ghij&l+n/p7r=sFuQvZxb{k|v}}~ˆ‘‚¢ƒ§„°†¹‡ÆˆÏ‹ÚŒãì‘õ”
•
–
—
"˜
2™
5˜
:›
U
^ž
gŸ
m µ¢ÉÊ
"ËÌ 
o¶·
oº»
/
@ÉÍ7
8ÎÏ=
2лQ
ÑÒk
ÓÔˆçÕÖ¢Í×ÖڕØÙ    ìƒÚÛ

kÜÝ
dÞ»
^ßà á Q
ÑâˆçÕã¢Í×価ü&åúÿ„    æ¿çè¿éêëëÿæ¿çè¿éêëëìíî¿ï¿¿ÿæ¿çè¿éêëëìíî¿ï¿¿ðú¥
À
Á[
sÇÃ

ÄÁsºÅZÆ
ñò³=    *´#+¶D°´
­µ    ¶·    ÓÔ
óô¥À
Á[
sõöÃ

÷
øù³Ê
++¸™'
¸ ¦ *´+¶N
-¦ »Y·¿*-¶»Y·N¸ :-¶W¸:-¶W-+²,¶-¶W-.0¶W*´¹ 
¶6:¶7:8¶9Ÿ(*´¶::8Ç;§¶<¶=:->»Y·¶?¶¶
¶W*´¶@:-A¶W*´1¹ 
¶E:    -    ¶W*´1¹ 
¶F:
-G
¶W,¸H™IM-J,¶W-K¶C-°´~»¼½¾&À+Â3Ä8ÅAÈHÉQÊ^ËgÎwÏ~ЉіҦөҮÕÉØÒÙÛÜíÝöß
à
ã
ä
æ
#è
)鵄 ÉÊ–ËÌ
+¶·
+º»

+¼»3øÎÏ8óÉÍHãлw´ÜÝ~­Þ»ÒYßàí>úÒ    
#ûü
á
í>úý    ¾mü&åúÿx    æ¿¿èç¿î¿ï¿¿ÿ    æ¿¿èç¿î¿ï¿¿ðúþlþéÿ¥
À
Á[
s
Ã!
ÄÁsºÅZÆ
ÄÁs¼ÅZÆ


ȳ

    +¸™)
¸ ¦"»LY·MM,¸¶N,+¶O,P¶Q*,¶»Y·M*´
¶N,-¶W,¸ ¶W,+²,¶-¶W,.R¶W*´¶4:,5¶W¸ :¸:,¶W*´¹ 
¶6:¶7:8¶9Ÿ(*´¶::    8    Ç;§    ¶<¶=:,>»Y·¶P¶¶
¶W*´¶@:    ,A    ¶W,S¶C,°´~ö÷øù"ú(û-þ5ÿ>
F

I
L

P
]
f
o
x

}
„


¤
¯
¼
Ì
Ï
Ô
ï
ø





µzÉʼËÌ    
    ¶·
    º»
5ÔÎÏ>ËÑÒošÚÛ}ŒÉÍ„…лlÜݤeÞ»øßà    á
>ËÑâ¾_-ÿœ
æ¿èéíç¿î¿ï¿¿ÿ
æ¿èéíç¿î¿ï¿¿ðú¥
À
Á[
s

Ã

ÄÁsºÅZÆ


³¤E
+¶T¦!¸ M+,¹ 
¶U
+¶V¦+,¸¶W*´X+¶T+¶V¶Y»ZY²[¶\]·^°´
)
*
,
.
/&
35
5µ ÉÍE¶·EÓ

¾
&ó
¥À
Á[
s
öÃ

÷

ù³•
)¸ N+¸™.
¸ ¦'»LY·M:¸¶N+¶O_¶Q*¶
-¦¸ N-¸:»Y·:*´¶`:¶W-¶W¶W+²,¶-¶W.a¶W*´¶4:5¶W*´-¶::
¦>b¶W§">»Y·¶<¶c¶¶
¶W*´X-¹ 
¶d:    *´X    ,fg¶h:
i
¶W*´¶@:A¶Wj¶C°´‚ 
E
G
H
I#
J)
K0
L6
O;
P?
SE
UN
VZ
Wd
Zm
\w
^…
`
b˜
c¢
f®
g´
hÁ
jà
nå
oì
nñ
p

s

u

v

x
&
yµ„ 
Ê
)¶·
)º»

)
    »
%ÉÍEäлNÛÎÏZÏÑÒ˜‘ÚÛ®{ËÌñ8

Ò    
'



ßàáZÏÑâñ8


     ¾,ü6çÿ    æ¿¿ç¿èéíï¥
À
Á[
s
Ã!
ÄÁsºÅZÆ
ÄÁs
    ÅZÆ


³¤E
+¶T¦!¸ M+,¹ 
¶U
+¶V¦+,¸¶W*´X+¶T+¶V¶Y»ZY²[¶\]·^°´
†
‡
‰
‹
Œ&
‘5
”µ ÉÍE¶·EÓ

¾
&ó
¥À
Á[
s
öÃ

÷


³¢>»kY¸l¸m·nM,¶o¹p
r+¹s»tY++¹u
+¹v
·wN¸x-¹y±´"
˜
™
š
›
œ%
4
ž=
Ÿµ*>¶·>ÉÍ
0

4




ù³Ç
K¸ N+¸™,
-¦'»LY·M:¸¶N+¶OP¶Q*¶
-¦¸ N»Y·:-¹z
:¹{À|:
¦>}¶W§$>»Y·¹~
¶¶¶
¶W-¶W¹€
¶W*´-¹ 
¹€
¶:¶W*´¹€
¶‚:ƒ¶W*´¹€
¶„:    …    ¶W,¶W+²,¶-¶W.†¶W*¶‡:
ˆ
¶W*´¶@:A¶W‰¶C°´Š"
¯
±
²
³!
´'
µ.
¶4
¹9
º=
½F
¿N
À[
Ãa
Än
Ə
Ș
ɧ
̽
ÍÇ
ÐÍ
ÑÒ
Ð×
Òá
Õñ
Öû
Ø

Ù

Ú

Ý
$
Þ
.
á
7
â
A
ä
H
嵄 
Ê
K¶·
Kº»

Kл
GÉÍF
ÎÏNý
Ò[ð

½ŽÑÒ×t
ÒñZ
Ò    
$'
Ö

7ßàá4Ný

½ŽÑâ×t

ñZ

    
$'

 
¾ü4çþ0èé
! ¥
À
Á[
s
Ã!
ÄÁsºÅZÆ
ÄÁs
"ÅZÆ

#
$³²

?»(Y·)M
N
:+¹Š
:¹‹
™
!¹Œ
À:»ŽY·:*´X¶¶‘N*´X¶¶’:
-¥_-¹“
žV-¹Š
:¹‹
™D¹Œ
À”:    •    ¶–¶™¶—`¶˜™    ¶–¶™¶š`¶›§ÿ¸
¥y¹“
žo¹Š
:¹‹
™\¹Œ
À”:    •    ¶–¶™¶—`¶˜¶œ`¶™    ¶–¶™¶š`¶›¶ž`¶Ÿ§ÿ ,¶¹ W§þÛ,°´j
ð
ñ

ò 
ô+
õ4
öA
÷O
ø]
ù{
úˆ
û”
ý¡
þ­°Àßìø
    



) 
,
:
=µ\    {2
%
&    ßJ
%
&    +

'Ì4
    
(
)
?¶·
?
Ò

7
*Ö

5
+Ò 
2
,Òá*
?



7
*
 

5
+
- 
2
,
-¾_
ÿæéëéé
.ÿO    æéëéé
/
.ï
.ü.
0úúü
.ü:
0ú$úøó
1
2
3¥
4À
Á[
s
5