thread_func.py
8.6 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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
from datetime import datetime
from app.models import Device, Alarm
from app import db
import app.image as img
import os
from flask import current_app
def gas_concentration(app, data):
if data is not None:
device_type = data.get("type", "")
device_addr = data.get("addr", "")
with (app.app_context()):
device = Device.query.filter_by(address=device_addr).filter_by(devicetype_id=device_type)
if device.count() == 1:
v = data.get("value", 0)
if v is not None and v > device[0].threshold and \
Alarm.query.filter_by(device_id=device[0].id).filter_by(
addtime=data["lastUpdateTime"]).count() <= 0:
alarm = Alarm(
msg="浓度高报警-浓度值:" + str(data["value"]),
device_id=device[0].id,
addtime=data["lastUpdateTime"],
preview=0,
handle=0,
)
db.session.add(db.session.merge(alarm))
db.session.commit()
def pressure(app, data):
if data is not None:
device_type = data.get("type", "")
device_addr = data.get("addr", "")
with (app.app_context()):
device = Device.query.filter_by(address=device_addr).filter_by(devicetype_id=device_type)
if device.count() == 1:
v = data.get("value", 0)
if v is not None and v > device[0].threshold and \
Alarm.query.filter_by(device_id=device[0].id).filter_by(
addtime=data["lastUpdateTime"]).count() <= 0:
alarm = Alarm(
msg="压力高报警-压力值:" + str(data["value"]),
device_id=device[0].id,
addtime=data["lastUpdateTime"],
preview=0,
handle=0,
day=str(data["lastUpdateTime"]).split(' ')[0].split('-')[2],
month=str(data["lastUpdateTime"]).split(' ')[0].split('-')[1],
year=str(data["lastUpdateTime"]).split(' ')[0].split('-')[0],
date=str(data["lastUpdateTime"]).split(' ')[0],
)
db.session.add(db.session.merge(alarm))
db.session.commit()
def switch(app, data):
if data is not None:
device_type = data.get("type", "")
device_addr = data.get("addr", "")
with (app.app_context()):
device = Device.query.filter_by(address=device_addr).filter_by(devicetype_id=device_type)
if device.count() == 1:
v = data.get("value", 0)
if v is not None and (v == 1 or v == -1) and \
Alarm.query.filter_by(device_id=device[0].id).filter_by(
addtime=data["lastUpdateTime"]).count() <= 0:
if v == 1:
msg = "急停按钮-打开:"
else:
msg = "急停按钮-离线:"
alarm = Alarm(
msg=msg,
device_id=device[0].id,
addtime=data["lastUpdateTime"],
preview=0,
handle=0,
day=str(data["lastUpdateTime"]).split(' ')[0].split('-')[2],
month=str(data["lastUpdateTime"]).split(' ')[0].split('-')[1],
year=str(data["lastUpdateTime"]).split(' ')[0].split('-')[0],
date=str(data["lastUpdateTime"]).split(' ')[0],
)
db.session.add(db.session.merge(alarm))
db.session.commit()
def video(app, data):
if data is not None:
device_type = data.get("type", "")
device_addr = data.get("addr", "")
# print(f'device_type={device_type}')
# print(f'device_addr={device_addr}')
with (app.app_context()):
device = Device.query.filter_by(address=device_addr).filter_by(devicetype_id=device_type)
if device.count() == 1:
if Alarm.query.filter_by(device_id=device[0].id).filter_by(
addtime=data["lastUpdateTime"]).count() <= 0:
if not os.path.exists(current_app.config["AL_DIR"]):
# 创建一个多级目录
os.makedirs(current_app.config["AL_DIR"]) # 创建文件夹
os.chmod(current_app.config["AL_DIR"], "rw") # 设置权限
file = str(device_type) + datetime.now().__format__('%Y%m%d%H%M%S%f') + '.png'
path = current_app.config["AL_DIR"] + file
img.save_image(img.base64_to_image(data["base64Picture"]), path)
alarm = Alarm(
msg=data["eventName"],
img=file,
device_id=device[0].id,
addtime=data["lastUpdateTime"],
preview=1,
handle=0,
day=str(data["lastUpdateTime"]).split(' ')[0].split('-')[2],
month=str(data["lastUpdateTime"]).split(' ')[0].split('-')[1],
year=str(data["lastUpdateTime"]).split(' ')[0].split('-')[0],
date=str(data["lastUpdateTime"]).split(' ')[0],
)
db.session.add(db.session.merge(alarm))
db.session.commit()
def radar(app, data):
if data is not None:
device_type = data.get("type", "")
device_addr = data.get("addr", "")
with (app.app_context()):
device = Device.query.filter_by(address=device_addr).filter_by(devicetype_id=device_type)
if device.count() == 1:
if Alarm.query.filter_by(device_id=device[0].id).filter_by(
addtime=data["lastUpdateTime"]).count() <= 0:
alarm = Alarm(
msg=data["eventName"],
device_id=device[0].id,
addtime=data["lastUpdateTime"],
preview=0,
handle=0,
day=str(data["lastUpdateTime"]).split(' ')[0].split('-')[2],
month=str(data["lastUpdateTime"]).split(' ')[0].split('-')[1],
year=str(data["lastUpdateTime"]).split(' ')[0].split('-')[0],
date=str(data["lastUpdateTime"]).split(' ')[0],
)
db.session.add(db.session.merge(alarm))
db.session.commit()
def pcm(app, data):
if data is not None:
device_type = data.get("type", "")
device_addr = data.get("addr", "")
with (app.app_context()):
device = Device.query.filter_by(address=device_addr).filter_by(devicetype_id=device_type)
if device.count() == 1:
if Alarm.query.filter_by(device_id=device[0].id).filter_by(
addtime=data["lastUpdateTime"]).count() <= 0:
msg = None
IH = data.get("IH", 0)
IA = data.get("IA", 0)
IB = data.get("IB", 0)
IC = data.get("IC", 0)
ILH0 = data.get('ILH0', 0)
IL = data.get('IL', 0)
if IH < IA:
msg = f"A相电流{IA}A大于电流上限{IH}A;"
if IH < IB:
msg = f"B相电流{IB}A大于电流上限{IH}A;"
if IH < IC:
msg = f"C相电流{IB}A大于电流上限{IH}A;"
if ILH0 < IL:
msg = f"漏电流{IL}mA大于漏电流上限{ILH0}mA;"
if msg is not None:
alarm = Alarm(
msg=msg,
device_id=device[0].id,
addtime=data["lastUpdateTime"],
preview=0,
handle=0,
day=str(data["lastUpdateTime"]).split(' ')[0].split('-')[2],
month=str(data["lastUpdateTime"]).split(' ')[0].split('-')[1],
year=str(data["lastUpdateTime"]).split(' ')[0].split('-')[0],
date=str(data["lastUpdateTime"]).split(' ')[0],
)
db.session.add(db.session.merge(alarm))
db.session.commit()