application.yml
2.02 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
spring:
application:
name: iot-scheduler
main:
banner-mode: off
server:
port: 33221
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 * * * ?"
xkd:
third:
devicesRegisterUrl: "http://117.64.210.63:8087/api/v1/devices/register"
dataUploadUrl: "http://117.64.210.63:8087/api/v1/data/upload"
enterpriseId: "PLMOKNJIB8"
apiKey: "UiOpAsDfGhJkLzXcVbNmQwEr6TyUiOpAsD"
jdbcUrl: "jdbc:postgresql://192.168.0.61:5433/iot"
jdbcUserName: "postgres"
jdbcPassword: "postgres"
selectSql: "SELECT
dc.credentials_id AS deviceId,
de.name AS deviceName,
CASE
WHEN attrAt.long_v IS NULL
OR (attrA0.bool_v = FALSE AND attrAt.long_v IS NOT NULL) THEN
'OFF'
WHEN tkl.bool_v = 't' OR tkl.long_v = 1 THEN
'RUN'
ELSE
'STAND'
END AS status
FROM
device de
LEFT JOIN device_profile dp ON dp.id = de.device_profile_id
LEFT JOIN ts_kv_latest tkl ON de.id = tkl.entity_id
AND KEY = '65'
LEFT JOIN attribute_kv attrA0 ON de.id = attrA0.entity_id
AND attrA0.attribute_key = (SELECT key_id FROM key_dictionary WHERE KEY = 'active')
LEFT JOIN attribute_kv attrAt ON de.id = attrAt.entity_id
AND attrAt.attribute_key = (SELECT key_id FROM key_dictionary WHERE KEY = 'lastActivityTime')
AND attrAt.long_v > 0
LEFT JOIN device_credentials dc ON de.id = dc.device_id
WHERE
de.device_profile_id IN ('a232cf60-2664-11f1-b8c6-b7a06d6a5950'::UUID, 'c4f7b830-2664-11f1-b8c6-b7a06d6a5950'::UUID, 'aaaf8250-2664-11f1-b8c6-b7a06d6a5950'::UUID, 'b950a050-2664-11f1-b8c6-b7a06d6a5950'::UUID, 'bf127900-2664-11f1-b8c6-b7a06d6a5950'::UUID, 'e4d55640-f756-11f0-b8c6-b7a06d6a5950'::UUID)
AND de.tenant_id = 'e4c3a300-f756-11f0-b8c6-b7a06d6a5950'::UUID
ORDER BY
de.name"