1

81041

2018-12-17 299f3a8a31cf05127b708b4985b8b0f4236a027b

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
119
120
121
122
123
Êþº¾2
(com/fgkj/dao/impl/Batt_devalarm_dataImpl
java/lang/Object
com/fgkj/dao/BaseDAO
com/fgkj/dao/CallBack
<init>
()V
Code
     

LineNumberTable
LocalVariableTable
this
*Lcom/fgkj/dao/impl/Batt_devalarm_dataImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
java/util/ArrayList
 
com/fgkj/dto/Batt_devalarm_data
 
num
java/sql/ResultSet !
getInt
(Ljava/lang/String;)I
#%$
java/lang/Integer&'
valueOf
(I)Ljava/lang/Integer;
)*+
setNum
(Ljava/lang/Integer;)V-
    record_id
/0+
setRecord_id2
dev_id
45+
    setDev_id7
dev_ip9:;
    getString
&(Ljava/lang/String;)Ljava/lang/String;
=>?
    setDev_ip
(Ljava/lang/String;)VA
alm_type
CD+
setAlm_typeF
    alm_level
HI+
setAlm_levelK
alm_start_timeMNO
getTimestamp
((Ljava/lang/String;)Ljava/sql/Timestamp;
QRS
setAlm_start_time
(Ljava/util/Date;)VU
alm_end_time
WXS
setAlm_end_timeZ
alm_is_confirmed
\]+
setAlm_is_confirmed_
alm_confirmed_time
abS
setAlm_confirmed_timed
alm_cleared_type
fg+
setAlm_cleared_typei
usr_id
kl+
    setUsr_idnpo
java/util/Listqr
add
(Ljava/lang/Object;)Ztuv
next
()Z
xzy
java/sql/SQLException{

printStackTrace
rs
Ljava/sql/ResultSet;
list
Ljava/util/List;
ddata
!Lcom/fgkj/dto/Batt_devalarm_data;

e
Ljava/sql/SQLException;
 StackMapTable
obj
Ljava/lang/Object;
update‰
G UPDATE db_alarm.tb_devalarm_data SET  alm_is_confirmed=? WHERE num=?  
‹Œ
com/fgkj/db/DBUtilŽ
getConn
()Ljava/sql/Connection;
‘’“
getAlm_is_confirmed
()Ljava/lang/Integer;
•–“
getNum
˜š™
com/fgkj/dao/DAOHelper›œ
 executeUpdate
=(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z
sql
Ljava/lang/String;
bl

Z
del£
= DELETE FROM db_alarm.db_alarm.tb_devalarm_data WHERE num=?  
    updatePro
&(Ljava/lang/Object;)Ljava/lang/String;§
java/lang/StringBuilder©
8 UPDATE db_alarm.tb_devalarm_data SET  alm_is_confirmed=
¦«    ?
¦­®¯
append
-(Ljava/lang/Object;)Ljava/lang/StringBuilder;±
,alm_confirmed_time='
¦³®´
-(Ljava/lang/String;)Ljava/lang/StringBuilder;    ˜¶·¸
sdf
Ljava/text/SimpleDateFormat;
º»¼
getAlm_confirmed_time
()Ljava/util/Date;
¾À¿
java/text/SimpleDateFormatÁÂ
format
$(Ljava/util/Date;)Ljava/lang/String;Ä
' WHERE num=
¦ÆÇÈ
toString
()Ljava/lang/String;
    cancelProË
1 UPDATE db_alarm.tb_devalarm_data SET  record_id=
ÍΓ
getRecord_idÐ
,alm_end_time='
ÒÓ¼
getAlm_end_timeÕ
',alm_cleared_type=
×ؓ
getAlm_cleared_typeÚ
 WHERE num=
delProÝ
1 DELETE FROM db_alarm.tb_devalarm_data WHERE num=
    searchAll
()Ljava/util/List;
serchByCondition
$(Ljava/lang/Object;)Ljava/util/List;ã
com/fgkj/dto/Batt_Maint_Dealarm
âåæç
getUinf
()Lcom/fgkj/dto/User_inf;
âéêë
getBinf
()Lcom/fgkj/dto/BattInf;
âíîï
getPage
()Lcom/fgkj/dto/Page;ñ
 SELECT FOUND_ROWS() numberó
õ
t SELECT SQL_CALC_FOUND_ROWS tb_devalarm_data.num,record_id,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time, alm_is_confirmed,alm_confirmed_time,alm_cleared_type,  DISTINCTbinf.stationName,DISTINCTbinf.FbsDeviceName  FROM db_alarm.tb_devalarm_data,(SELECT DISTINCT db_battinf.tb_battinf.FbsDeviceId,db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.FbsDeviceName from db_battinf.tb_battinf  where db_battinf.tb_battinf.StationName LIKE ?  AND db_battinf.tb_battinf.StationName1 LIKE ? )  as DISTINCTbinf     WHERE  tb_devalarm_data.dev_id=DISTINCTbinf.FbsDeviceId   AND alm_start_time>=? and alm_start_time<=? ÷
 AND alm_cleared_type!=0
ùûú
java/lang/String&¥ý
2 and db_alarm.tb_devalarm_data.dev_id in(select distinct db_battinf.tb_battinf.FbsDeviceId  from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId    and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id   and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid   and db_user.tb_user_inf.uid=? )ÿ
 ORDER BY alm_start_time DESC 


 LIMIT ?,? 


%




com/fgkj/dto/BattInf
È
getStationName
 

È
getStationName1


 
¼
getBattProductDate



¼
getBattProductDate1




com/fgkj/dto/User_inf
“
getUId




com/fgkj/dto/Page
“
getPageCurr
#



intValue
()I


!
"“
getPageSize
$
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$1

#
&    
'
-(Lcom/fgkj/dao/impl/Batt_devalarm_dataImpl;)V
˜
)
*
+
executeQueryLimit
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;

-
/
.
com/fgkj/dao/LimitNumberFactory
0
1
GetLimtitNumber
*(Ljava/sql/Connection;Ljava/lang/String;)In
3
4

sizen
6
7
8
get
(I)Ljava/lang/Object;
bmd
!Lcom/fgkj/dto/Batt_Maint_Dealarm;
uinf
Lcom/fgkj/dto/User_inf;
binf
Lcom/fgkj/dto/BattInf;
page
Lcom/fgkj/dto/Page;
conn
Ljava/sql/Connection;
    numberSql
baseSql
alarmTypeSql

stationSql
endSql
limitSql
number

I
LocalVariableTypeTable
3Ljava/util/List<Lcom/fgkj/dto/Batt_devalarm_data;>;
N
java/sql/Connection
serchByInfo
å
í
S
 SELECT FOUND_ROWS() number 
U

³ SELECT SQL_CALC_FOUND_ROWS distinct tb_devalarm_data.num,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time, alm_is_confirmed,alm_confirmed_time,alm_cleared_type, db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.stationName5,db_battinf.tb_battinf.FbsDeviceName   FROM db_alarm.tb_devalarm_data,db_battinf.tb_battinf  WHERE   tb_devalarm_data.dev_id=db_battinf.tb_battinf.FbsDeviceId  and tb_battinf.station_install=1 
W
 AND alm_cleared_type=0 
Y
 and stationname1!=? 
[
 and stationname1=? 
 
 
ù
^
_r
equals
a
 and stationname!=? 
c
 and stationname=? 


f
 and stationname2!=? 
h
 and stationname2=? 

j
kÈ
getStationName2
m
 and stationname5!=? 
o
 and stationname5=? 

q
rÈ
getStationName5
t
 and alm_type!=? 
v
 and alm_type=? 

x
y“
getAlm_type
{
2 and db_alarm.tb_devalarm_data.dev_id in(select distinct db_battinf.tb_battinf.FbsDeviceId  from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId    and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id   and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid   and db_user.tb_user_inf.uid=?) 
}
D ORDER BY alm_start_time DESC,db_alarm.tb_devalarm_data.dev_id asc  

*com/fgkj/dao/impl/Batt_devalarm_dataImpl$2

~
&
station1SqlT
station1SqlF
stationSqlT
stationSqlF
stationSql2T
stationSql2F
stationSql5T
stationSql5F
almTypeT
almTypeF

searchNums
(Ljava/lang/Object;)I
Ž
°select distinct num,dev_id,alm_start_time  from db_alarm.tb_devalarm_data where alm_cleared_type=0  and tb_devalarm_data.dev_id in (select distinct db_battinf.tb_battinf.FbsDeviceId  from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId    and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id   and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid   and db_user.tb_user_inf.uid=?  and tb_battinf.station_install=1 ) 

*com/fgkj/dao/impl/Batt_devalarm_dataImpl$3


&
˜
“
”
+
executeQuery
nums
serchTopAlmInDev
˜

oselect db_alarm.tb_devalarm_data.dev_id,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.fbsdevicename,dev_ip,alm_type,alm_start_time   from db_alarm.tb_devalarm_data,db_battinf.tb_battinf  where alm_cleared_type=0   and db_alarm.tb_devalarm_data.dev_id=db_battinf.tb_battinf.fbsdeviceid   order by alm_start_time desc   limit 1
š
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$4

™
&
serchTopDevTen
ž
Ïselect distinct db_alarm.tb_devalarm_data.dev_id,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.fbsdevicename,dev_ip,alm_type,alm_start_time   from db_alarm.tb_devalarm_data,db_battinf.tb_battinf  where alm_cleared_type=0   and db_alarm.tb_devalarm_data.dev_id=db_battinf.tb_battinf.fbsdeviceid and tb_battinf.station_install=1   and  db_alarm.tb_devalarm_data.dev_id  in (select distinct db_battinf.tb_battinf.FbsDeviceId  from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId    and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id   and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid   and db_user.tb_user_inf.uid=?) order by alm_start_time desc   limit 0,5
 
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$5

Ÿ
&
    serchIn30
¤

Ðselect distinct db_alarm.tb_devalarm_data.dev_id,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.fbsdevicename,dev_ip,alm_type,alm_start_time   from db_alarm.tb_devalarm_data,db_battinf.tb_battinf  where alm_cleared_type=0   and db_alarm.tb_devalarm_data.dev_id=db_battinf.tb_battinf.fbsdeviceid and tb_battinf.station_install=1   and (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(alm_start_time))<30
¦

v and tb_battinf.StationId in( select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id  and db_user.tb_user_battgroup_baojigroup_usr.uId=? ) 
¨
  order by alm_start_time desc 
ª
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$6

©
&
userSql
orderSql
serchDev_alarm
°

¸select distinct db_alarm.tb_devalarm_data.dev_id,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.fbsdevicename,dev_ip,alm_type,alm_start_time,alm_cleared_type   from db_alarm.tb_devalarm_data,db_battinf.tb_battinf   where db_alarm.tb_devalarm_data.dev_id=db_battinf.tb_battinf.fbsdeviceid and tb_battinf.station_install=1   and  db_alarm.tb_devalarm_data.dev_id=? and alm_type=? and alm_start_time=? 

²
³“
    getDev_id

µ
¶¼
getAlm_start_time
¸
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$7

·
&
main
([Ljava/lang/String;)V

Exceptions
¾
java/text/ParseException

 
Á

yyyy-MM-dd
¾«
Ä

2000-01-01
¾
Æ
Ç
È
parse
$(Ljava/lang/String;)Ljava/util/Date;
Ê

2020-01-01

Ì
Î
Í
com/fgkj/actions/ActionUtil
Ï
Ð
getSimpDate
"(Ljava/util/Date;)Ljava/util/Date;

Ò
ÓS
setAlm_start_time1

Õ
Ö?
setStationName1

Ø
Ù?
setStationName

Û
Ü?
setStationName2

Þ
ß?
setStationName5
 


â
ã+
setPageCurr


å
æ+
setPageSize
 


é
ê+
setUId

ì
í
î
setPage
(Lcom/fgkj/dto/Page;)V

ð
ñ
ò
setUinf
(Lcom/fgkj/dto/User_inf;)V
â 
 


Ø


Õ


Û


Þ


ú
ûS
setBattProductDate


ý
þS
setBattProductDate1
â

setBinf
(Lcom/fgkj/dto/BattInf;)V
â
ì
â
ð


‹
Œ    
    
java/lang/System
out
Ljava/io/PrintStream;

java/io/PrintStream
println
(I)V
args
[Ljava/lang/String;
dimpl
date1
Ljava/util/Date;
date2

SourceFile
Batt_devalarm_dataImpl.java
InnerClasses!

    

/

*·±




’Ö»Y·M§»»Y·N-+¹¸"¶(-+,¹¸"¶.-+1¹¸"¶3-+6¹8¶<-+@¹¸"¶B-+E¹¸"¶G-+J¹L¶P-+T¹L¶V-+Y¹¸"¶[-+^¹L¶`-+c¹¸"¶e-+h¹¸"¶j,-¹mW+¹s
šÿB§N-¶w,°
ÌÏxR !""#1$@%L&['j(v)‚*‘+,¬-».àÌ0Ð2Ô44ÖÖ|}
Î~°€Ð‚ƒ„ünû·Kx
qr
6
¬
9…†

‡r
„&+ÀMˆN¸Š-½Y,¶SY,¶”S¸—6¬>?@#A4&&…†
!€ž#Ÿ 
¡r
}+ÀM¢N¸Š-½Y,¶”S¸—6¬EFGH4…†
€žŸ 
¤¥
‰9+ÀM»¦Y¨·ª,¶¶¬°¶²²µ,¶¹¶½¶²ö²,¶”¶¬¶ÅN-°MN7O*99…†
4€7ž
É¥
•E+ÀM»¦YÊ·ª,¶Ì¶¬϶²²µ,¶Ñ¶½¶²Ô¶²,¶Ö¶¬Ù¶²,¶”¶¬¶ÅN-°STCU*EE…†
@€Cž
Û¥
k+ÀM»¦YÜ·ª,¶”¶¬¶ÅN-°Z[\*…†
€ž
Þß
,


°
a

àá
§
@+ÀâM,¶äN,¶è:,¶ì:¸Š:ð:ò:ô:    ö:
»¦Y    ¸ø·ª
¶²¶Å:    ü:»¦Y    ¸ø·ª¶²¶Å:    þ:
: »¦Y    ¸ø·ª¶² ¶²¶Å:½Y»¦Y
Ủ
¶²
¶²¶ÅSY»¦Y
Ủ
    ¶²
¶²¶ÅSY¶
SY¶
SY-¶
SY¶
¶
d¶
 ¶
h¸"SY¶
 S»
#Y*·
%¸
(:¸
,6Æ(¹
2
ž¹
2
d¹
5À¸"¶j°^§¨
©ª«¬­#®'¶+·A¹E¿[Â_ÄdÆÈÖÉ÷Ê
È

ê
ì
"í
=ï¢
@
@…†

;
9
:

6
;
<
0
=
>
*
?
@
%
A
B
!
Cž#
ž'

Dž    +

Ež
Eû
Fž_á
GždÜ
Hž 

6~
-
I
J
K


6~
L„7
ÿ
=
â



Mùùùùùùùn


Oá
n+ÀM,¶
PN,¶
Q:¸Š:
R:ò:
T:
V:    »¦Y¸ø·ª    ¶²¶Å:
X:

Z:,¶
\ò¶
]™»¦Y¸ø·ª
¶²¶Å:§»¦Y¸ø·ª¶²¶Å:
`:
b: ,¶
dò¶
]™»¦Y¸ø·ª¶²¶Å:§»¦Y¸ø·ª ¶²¶Å:
e:
g:,¶
iò¶
]™»¦Y¸ø·ª¶²¶Å:§»¦Y¸ø·ª¶²¶Å:
l:
n:,¶
pò¶
]™»¦Y¸ø·ª¶²¶Å:§»¦Y¸ø·ª¶²¶Å:
s:
u:,¶
w¶
š»¦Y¸ø·ª¶²¶Å:§»¦Y¸ø·ª¶²¶Å:
z:»¦Y¸ø·ª¶²¶Å:
|:
:»¦Y¸ø·ª¶²¶²¶Å:½Y,¶
\SY,¶
dSY,¶
iSY,¶
pSY,¶
wSY-¶
SY¶
¶
d¶
 ¶
h¸"SY¶
 S»
~Y*·
€¸
(:¸
,6Æ(¹
2
ž¹
2
d¹
5À¸"¶j°Æ1
-
.

/
0
1
2
3#
:(
;>
=C
>H
?T
@j
Am
Bƒ
Eˆ
F
G™
H¯
I²
JÈ
MÍ
NÒ
OÞ
Pô
Q÷
R
 
U

V

W
#
X
9
Y
<
Z
R
]
W
^
\
_
f
`
|
a

b
•
e
š
k
°
m
µ
o
º
p
Õ
q8
A
’P
“k
•ünn…†
i€
d
;
<^
?
@Y
A
BT
CžPž#K
Dž(F
Ež    C+
ž
H&
‚žˆ
æ
ƒž
á
„ž Í
¡
…žÒ
œ
†ž

\
‡ž

W
ˆž
W

‰ž
\

Šž
šÔ
Fž
µ¹
Gž
º´
Hž86~A-
I
J
K
86~
L„¦ÿm



Mùùùùùùý.ùùý.ùùý.ùùý,ùùÿÕ



Mùùùùùùùùùùùùùùùùùn


‹
Œ
ÜI+À
M
N-¸Š½Y,¶
S»
Y*·
‘¸
’:6ƹ
2
ž¹
2
¸"¶
6¬
¶
·    
Á%
Ô(
Õ7
ÖF
Ø>II…†
D
;
<    @ž%$~(!
•
J„
ÿF

ùn


–ß
]
—L+¸Š
»
™Y*·
›¸
’M,°
Ý
ã
ú ž
~

χ
†(+À
M
N-¸Š½Y,¶
S»
ŸY*·
¡¸
’:°%&    2%O4((…†
#
;
<    ž%~

¢á
ÜZ+À
M
£N
¥:»¦Y-¸ø·ª¶²¶ÅN
§:»¦Y-¸ø·ª¶²¶ÅN-¸Š½Y,¶
S»
©Y*·
«¸
’:°"ST    Z]"^'_;`W}HZZ…†
U
;
<    QžL
¬ž'3
­žW~

®á
”6+ÀM
¯N-¸Š½Y,¶
±SY,¶
wSY,¶
´S»
·Y*·
¹¸
’:°‚    †3ž466…†
1€    -ž3~    
º
»
¼

½
»
Y·
¿L»¾Y
À·
ÂM,
ö
ÅN,
ɶ
Å:»Y·:-¸
˶P¸
˶
Ñò¶
Ôò¶
×ò¶
Úò¶
ݸ"¶B»
Y·
à:¸"¶
áN ¸"¶
ä»
Y·
ç:ê¸"¶
è¶
ë¶
ï»âY·
ó:»
Y·
ô:        ò¶
õ    ò¶
ö    ò¶
÷    ò¶
ø    -¸
˶
ù    ¸
˶
ü    ¶
ÿ¶¶+¶6
²
¶ ±†!¡¢£¤$¥-¦6§@¨G©NªU«\¬e­n®w¯‚°‹±–²³¤´­µ¶¶½·Ä¸Ë¹ÒºÛ»å½ì¾ó¿úÇ
È

Ép


ø·¸ð$ç-ހn
?
@‹€
;
<­^
9
:¶U
=
>    
    
•
J
:
#
~

™
Ÿ
©
·