application.yml
3.62 KB
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
spring:
application:
name: iot-scheduler
main:
banner-mode: off
server:
port: 32212
logging:
level:
root: INFO
com.iot.scheduler: DEBUG
# Scheduler Configuration (Cron Expressions)
# Format: sec min hour day month day-of-week
scheduler:
huaining:
pull: "0 0/5 * * * ?" # Every 5 minutes
push: "0 0/10 * * * ?" # Every 10 minutes
chizhou:
pull: "0 0/5 * * * ?"
push: "0 0/10 * * * ?"
panji:
pull: "0 0/5 * * * ?"
push: "0 0/10 * * * ?"
ks:
pull: "0 0/5 * * * ?"
push: "0 0/5 * * * ?"
ks:
third:
jdbcUrl: "jdbc:postgresql://192.168.0.249:5432/iot"
jdbcUserName: "postgres"
jdbcPassword: "1qaz@WSX"
selectSql: "SELECT
CASE
WHEN de.id = '9d8539a0-2f27-11f1-926f-2f3182abc65f' THEN '数控车间'
WHEN de.id = 'bb1cfba0-2be5-11f1-926f-2f3182abc65f' THEN '无尘车间'
WHEN de.id = 'bb1cd490-2be5-11f1-926f-2f3182abc65f' THEN '化金线'
WHEN de.id = '77c0bf22-29c6-11f1-926f-2f3182abc65f' THEN '飞针机车间'
WHEN de.id = '77c0bf23-29c6-11f1-926f-2f3182abc65f' THEN '蚀刻生产线'
ELSE '导电膜生产线' END AS sn,
tkl1.dbl_v AS Ep,
tkl10.dbl_v AS Ua,
tkl16.dbl_v AS Ia
FROM
device de
LEFT JOIN ts_kv_latest tkl1 ON de.id = tkl1.entity_id
AND tkl1.KEY = 64
LEFT JOIN ts_kv_latest tkl2 ON de.id = tkl2.entity_id
AND tkl2.KEY = 65
LEFT JOIN ts_kv_latest tkl3 ON de.id = tkl3.entity_id
AND tkl3.KEY = 66
LEFT JOIN ts_kv_latest tkl4 ON de.id = tkl4.entity_id
AND tkl4.KEY = 67
LEFT JOIN ts_kv_latest tkl5 ON de.id = tkl5.entity_id
AND tkl5.KEY = 68
LEFT JOIN ts_kv_latest tkl6 ON de.id = tkl6.entity_id
AND tkl6.KEY = 69
LEFT JOIN ts_kv_latest tkl7 ON de.id = tkl7.entity_id
AND tkl7.KEY = 70
LEFT JOIN ts_kv_latest tkl8 ON de.id = tkl8.entity_id
AND tkl8.KEY = 71
LEFT JOIN ts_kv_latest tkl9 ON de.id = tkl9.entity_id
AND tkl9.KEY = 72
LEFT JOIN ts_kv_latest tkl10 ON de.id = tkl10.entity_id
AND tkl10.KEY = 73
LEFT JOIN ts_kv_latest tkl11 ON de.id = tkl11.entity_id
AND tkl11.KEY = 74
LEFT JOIN ts_kv_latest tkl12 ON de.id = tkl12.entity_id
AND tkl12.KEY = 75
LEFT JOIN ts_kv_latest tkl13 ON de.id = tkl13.entity_id
AND tkl13.KEY = 76
LEFT JOIN ts_kv_latest tkl14 ON de.id = tkl14.entity_id
AND tkl14.KEY = 77
LEFT JOIN ts_kv_latest tkl15 ON de.id = tkl15.entity_id
AND tkl15.KEY = 78
LEFT JOIN ts_kv_latest tkl16 ON de.id = tkl16.entity_id
AND tkl16.KEY = 79
WHERE
de.organization_id = '1697500a-dc11-45cc-88f5-2ad47472a9bb'
AND de.device_profile_id = 'c2401630-ffec-11f0-926f-2f3182abc65f'
AND de.id IN ('9d8539a0-2f27-11f1-926f-2f3182abc65f', 'bb1cfba0-2be5-11f1-926f-2f3182abc65f', 'bb1cd491-2be5-11f1-926f-2f3182abc65f', 'bb1cd490-2be5-11f1-926f-2f3182abc65f', '77c0bf22-29c6-11f1-926f-2f3182abc65f', '77c0bf23-29c6-11f1-926f-2f3182abc65f')"
selectSql1: "SELECT
CASE
WHEN de.id = '6775ad30-ffee-11f0-926f-2f3182abc65f' THEN '1号水表'
WHEN de.id = '6775d440-ffee-11f0-926f-2f3182abc65f' THEN '2号水表'
ELSE '其他' END AS sn,
tkl1.dbl_v AS zll,
tkl2.dbl_v AS ssll
FROM
device de
LEFT JOIN ts_kv_latest tkl1 ON de.id = tkl1.entity_id
AND tkl1.key = 83
LEFT JOIN ts_kv_latest tkl2 ON de.id = tkl2.entity_id
AND tkl2.key = 84
WHERE
de.organization_id='1697500a-dc11-45cc-88f5-2ad47472a9bb'
AND de.device_profile_id = '4e404b10-ffe7-11f0-926f-2f3182abc65f'
AND de.id in('6775ad30-ffee-11f0-926f-2f3182abc65f','6775d440-ffee-11f0-926f-2f3182abc65f')"