def getAdminData(self):
"""
Deliver admin content of module alarms (ajax)
:return: rendered template as string or json dict
"""
if request.args.get('action') == 'upload':
if request.files:
ufile = request.files['uploadfile']
fname = os.path.join(current_app.config.get('PATH_TMP'), ufile.filename)
ufile.save(fname)
scheduler.add_job(processFile, args=[current_app.config.get('PATH_TMP'), ufile.filename]) # schedule operation
return ""
elif request.args.get('action') == 'uploadchecker':
if request.files:
ufile = request.files['uploadfile']
if not os.path.exists('%s/emonitor/modules/alarms/inc/%s' % (current_app.config.get('PROJECT_ROOT'), ufile.filename)):
ufile.save('%s/emonitor/modules/alarms/inc/%s' % (current_app.config.get('PROJECT_ROOT'), ufile.filename))
try:
cls = imp.load_source('emonitor.modules.alarms.inc', 'emonitor/modules/alarms/inc/%s' % ufile.filename)
if isinstance(getattr(cls, cls.__all__[0])(), AlarmFaxChecker):
return "ok"
except:
pass
os.remove('%s/emonitor/modules/alarms/inc/%s' % (current_app.config.get('PROJECT_ROOT'), ufile.filename))
return babel.gettext(u'admin.alarms.checkernotvalid')
return ""
elif request.args.get('action') == 'uploaddefinition':
"""
add alarmtype with given config for uploadfile
"""
alarmtype = AlarmType.buildFromConfigFile(request.files['uploadfile'])
if not alarmtype:
db.session.rollback()
return babel.gettext(u'admin.alarms.incorrecttypedefinition')
db.session.add(alarmtype)
db.session.commit()
return "ok"
elif request.args.get('action') == 'gettypedefinition':
"""
export alarmtype definition as cfg-file
"""
alarmtype = AlarmType.getAlarmTypes(request.args.get('alarmtype'))
if alarmtype:
return Response(alarmtype.getConfigFile(), mimetype="application/x.download; charset=utf-8")
else:
return None
elif request.args.get('action') == 'getkeywords':
"""
send list with all keywords of alarmtype
"""
for f in [f for f in os.listdir('%s/emonitor/modules/alarms/inc/' % current_app.config.get('PROJECT_ROOT')) if f.endswith('.py')]:
if f == request.args.get('checker'):
cls = imp.load_source('emonitor.modules.alarms.inc', 'emonitor/modules/alarms/inc/%s' % f)
cls = getattr(cls, cls.__all__[0])()
return {u'keywords': "\n".join(cls.getDefaultConfig()[u'keywords']), u'variables': cls.getDefaultConfig()[u'translations'], u'attributes': cls.getDefaultConfig()[u'attributes']}
return ""
elif request.args.get('action') == 'alarmsforstate':
alarms = Alarm.getAlarms(state=int(request.args.get('state')))
return render_template('admin.alarms_alarm.html', alarms=alarms)
elif request.args.get('action') == 'alarmsarchive':
for id in request.args.get('alarmids').split(','):
Alarm.changeState(int(id), 3)
return ""
elif request.args.get('action') == 'savefieldorder': # change order of fields
fields = []
deptid = '0'
for f in request.args.get('order').split(','):
t, deptid, name = f.split('.')
fields.append(name)
if int(deptid):
for dbfield in AlarmField.getAlarmFields(dept=deptid):
dbfield.position = fields.index(dbfield.fieldtype)
db.session.commit()
return ""
elif request.args.get('action') == 'addreport':
f = request.files['template']
fname = "{}.{}".format(random.random(), f.filename.split('.')[-1])
fpath = '{}alarmreports/{}'.format(current_app.config.get('PATH_DATA'), fname[2:])
f.save(fpath)
if f.filename.endswith('pdf'):
fields = getFormFields(fpath)
content = render_template('admin.alarms.report_fields.html', filepath='{}alarmreports/{}'.format(current_app.config.get('PATH_DATA'), fname[2:]), fileinfo=getPDFInformation(fpath), fields=fields, multi=max(fields.values()) > 1)
else:
content = ""
fields = []
return {'filename': fname, 'content': content}
elif request.args.get('action') == 'reportdetails':
return render_template('admin.alarms.report_details.html', report=AlarmReport.getReports(id=request.args.get('reportid')), reporttype=AlarmReport.getReportTypes(request.args.get('template')), departments=request.args.get('departments'))
elif request.args.get('action') == 'reportfieldlookup':
ret = OrderedDict()
ret['basic'] = [] # add basic information from AFBasic class
for f in AFBasic().getFields():
ret['basic'].append({'id': f.name, 'value': f.id})
alarmfields = {}
for alarmfield in AlarmField.getAlarmFields():
if str(alarmfield.dept) not in request.args.get('departments').split(','):
continue
if alarmfield.fieldtype not in alarmfields:
alarmfields[alarmfield.fieldtype] = []
alarmfields[alarmfield.fieldtype].append(alarmfield)
l = ""
for alarmfield in list(chain.from_iterable([f for f in alarmfields.values() if len(f) == len(request.args.get('departments').split(','))])):
if '%s' % alarmfield.name not in ret:
ret['%s' % alarmfield.name] = [{'id': '%s-list' % alarmfield.fieldtype, 'value': '%s (%s)' % (alarmfield.name, babel.gettext('admin.alarms.list'))}]
for f in alarmfield.getFields():
if f.getLabel().strip() not in ["", '<leer>']: # dismiss empty values
if f.name[0] != ' ':
value = '%s' % babel.gettext(f.getLabel())
l = value
else: # add name of kategory
value = '%s > %s' % (l, babel.gettext(f.getLabel()))
ret['%s' % alarmfield.name].append({'id': '%s-%s' % (alarmfield.fieldtype, f.id), 'value': value})
return ret
def getFrontendContent(**params):
"""
Deliver frontend content of module alarms
:return: data of alarms
"""
from emonitor.extensions import monitorserver
if 'alarmfilter' not in session:
session['alarmfilter'] = '7'
if request.args.get('alarmfilter'): # filter for alarms last x days, -1 no filter set
session['alarmfilter'] = request.args.get('alarmfilter', '7')
if 'area' in request.args:
params['area'] = request.args.get('area')
if 'state' in request.args:
params['activeacc'] = request.args.get('state')
if request.form.get('action') == 'updatealarm':
if request.form.get('alarm_id') != 'None': # update alarm
alarm = Alarm.getAlarms(request.form.get('alarm_id'))
else: # create new alarm
d = datetime.datetime.strptime('%s %s' % (request.form.get('edit_timestamp_date'), request.form.get('edit_timestamp_time')), "%d.%m.%Y %H:%M:%S")
alarm = Alarm(d, request.form.get('edit_keyid'), 2, 0)
db.session.add(alarm)
params['activeacc'] = 1
try:
alarm.timestamp = datetime.datetime.strptime('%s %s' % (request.form.get('edit_timestamp_date'), request.form.get('edit_timestamp_time')), "%d.%m.%Y %H:%M:%S")
except ValueError:
alarm.timestamp = datetime.datetime.now()
alarm._key = request.form.get('edit_key')
alarm.set(u'id.key', request.form.get('edit_keyid'))
alarm.set(u'k.cars1', request.form.get('val_cars1'))
alarm.set(u'k.cars2', request.form.get('val_cars2'))
alarm.set(u'k.material', request.form.get('val_material'))
alarm.set(u'marker', request.form.get('marker'))
alarm.set(u'id.city', request.form.get('edit_city'))
_city = City.getCities(id=request.form.get('edit_cityname'))
if _city:
alarm.set(u'city', _city.name)
else:
alarm.set(u'city', request.form.get('edit_cityname'))
alarm.set(u'streetno', request.form.get('edit_streetno'))
street = Street.getStreets(id=request.form.get('edit_addressid'))
hnumber = None
if street:
alarm.set(u'id.address', street.id)
try:
hnumber = [h for h in street.housenumbers if h.number == request.form.get('edit_streetno').split()[0]]
if len(hnumber) > 0:
alarm.set(u'lat', hnumber[0].points[0][0])
alarm.set(u'lng', hnumber[0].points[0][1])
except IndexError:
pass
elif request.form.get('edit_addressid') == 'None':
alarm.set(u'id.address', '')
else:
alarm.set(u'id.address', request.form.get('edit_addressid'))
alarm.set(u'address', request.form.get('edit_address'))
if request.form.get('edit_object') != '0':
alarm.set(u'id.object', request.form.get('edit_object'))
else: # remove object definition if present
if u'id.object' in alarm.attributes:
del alarm.attributes[u'id.object']
if u'object' in alarm.attributes:
del alarm.attributes[u'object']
alarm.set(u'priority', request.form.get('edit_priority'))
alarm.set(u'remark', request.form.get('edit_remark'))
alarm.set(u'person', request.form.get('edit_person'))
if request.form.get(u'edit_address2').strip() != '':
alarm.set(u'address2', request.form.get('edit_address2'))
if (request.form.get(u'marker') == '1' and not hnumber) or request.form.get('update_position') == '1':
alarm.set(u'routing', '')
alarm.set(u'lat', request.form.get('lat'))
alarm.set(u'lng', request.form.get('lng'))
alarm.set(u'zoom', request.form.get('zoom'))
try:
d = datetime.datetime.strptime('%s %s' % (request.form.get('edit_endtimestamp_date'), request.form.get('edit_endtimestamp_time')), "%d.%m.%Y %H:%M:%S")
except ValueError:
d = datetime.datetime.now()
alarm.set(u'endtimestamp', d)
db.session.commit()
signal.send('alarm', 'updated', alarmid=alarm.id)
if request.form.get('alarm_id') == u'None': # create new
Alarm.changeState(alarm.id, 0) # prepare alarm
return redirect('/alarms?area=%s&state=1' % params['area'])
elif alarm.state == 1: # active alarm update
monitorserver.sendMessage('0', 'reset') # refresh monitor layout
return redirect('/alarms?area=%s&state=0' % params['area'])
elif request.args.get('action') == 'editalarm':
if request.args.get('alarmid', '0') == '0': # add new alarm
alarm = Alarm(datetime.datetime.now(), '', 2, 0)
#flash(babel.gettext(u'alarms.alarmadded'), 'alarms.add')
else: # edit alarm
alarm = Alarm.getAlarms(id=request.args.get('alarmid'))
return render_template('frontend.alarms_edit.html', alarm=alarm, cities=City.getCities(), objects=AlarmObject.getAlarmObjects(), cars=Car.getCars(), departments=Department.getDepartments(), frontendarea=params['area'], frontendmodules=frontend.modules, frontendmoduledef=Settings.get('frontend.default'))
elif request.args.get('action') == 'refresh': # refresh alarm section
params['area'] = request.args.get('area')
params['activeacc'] = int(request.args.get('activeacc'))
elif request.args.get('action') == 'finishalarm': # finish selected alarm
Alarm.changeState(int(request.args.get('alarmid')), 2)
params['area'] = request.args.get('area')
elif request.args.get('action') == 'activatealarm': # activate selected alarm
ret = Alarm.changeState(int(request.args.get('alarmid')), 1)
if len(ret) > 0:
flash(render_template_string("{{ _('alarms.carsinuse') }}</br><b>" + ", ".join([r.name for r in sorted(ret, key=attrgetter('name'))]) + "</b>"), 'alarms')
params['area'] = request.args.get('area')
params['activeacc'] = 0
elif request.args.get('action') == 'deletealarm': # delete selected alarm
alarm = Alarm.getAlarms(id=request.args.get('alarmid'))
refresh = 1 or alarm.state == 1 # check if alarm is active
try:
# delete file if not used in any other alarm
c = Alarm.query.filter(Alarm.attributes.any(value=alarm.get('filename'), name="filename")).count()
if c == 1 and os.path.exists("{}{}".format(current_app.config.get('PATH_DONE'), alarm.get('filename'))):
os.remove("{}{}".format(current_app.config.get('PATH_DONE'), alarm.get('filename')))
except:
pass
alarm.state = -1
alarm.updateSchedules()
db.session.delete(alarm)
db.session.commit()
if refresh:
monitorserver.sendMessage('0', 'reset') # refresh monitor layout
signal.send('alarm', 'deleted', alarmid=request.args.get('alarmid'))
elif request.args.get('action') == 'archivealarm': # archive selected alarms, id=0 == all
if ";" in request.args.get('alarmid'): # archive selected alarms
for alarmid in request.args.get('alarmid').split(';'):
Alarm.changeState(int(alarmid), 3)
elif int(request.args.get('alarmid')) == 0: # archive all alarms
Alarm.changeStates(3)
else: # archive single selected alarm
Alarm.changeState(int(request.args.get('alarmid')), 3)
params['area'] = request.args.get('area')
stats = dict.fromkeys(Alarm.ALARMSTATES.keys() + ['3'], 0)
for s, c in Alarm.getAlarmCount(days=int(session['alarmfilter'])): # s=state, c=count(ids of state)
if str(s) in stats.keys():
stats[str(s)] = c
if 'area' not in params:
params['area'] = 'center'
if 'activeacc' not in params:
params['activeacc'] = 0
return render_template('frontend.alarms_smallarea.html', alarmstates=Alarm.ALARMSTATES, stats=stats, frontendarea=params['area'], activeacc=str(params['activeacc']), printdefs=Printers.getActivePrintersOfModule('alarms'), frontendmodules=frontend.modules, frontendmoduledef=Settings.get('frontend.default'), alarmfilter=session['alarmfilter'])
def getFrontendContent(**params):
"""
Deliver frontend content of module alarms
:return: data of alarms
"""
from emonitor.extensions import monitorserver
if 'alarmfilter' not in session:
session['alarmfilter'] = '7'
if request.args.get(
'alarmfilter'): # filter for alarms last x days, -1 no filter set
session['alarmfilter'] = request.args.get('alarmfilter', '7')
if 'area' in request.args:
params['area'] = request.args.get('area')
if 'state' in request.args:
params['activeacc'] = request.args.get('state')
if request.form.get('action') == 'updatealarm':
if request.form.get('alarm_id') != 'None': # update alarm
alarm = Alarm.getAlarms(request.form.get('alarm_id'))
else: # create new alarm
d = datetime.datetime.strptime(
'%s %s' % (request.form.get('edit_timestamp_date'),
request.form.get('edit_timestamp_time')),
"%d.%m.%Y %H:%M:%S")
alarm = Alarm(d, request.form.get('edit_keyid'), 2, 0)
db.session.add(alarm)
params['activeacc'] = 1
try:
alarm.timestamp = datetime.datetime.strptime(
'%s %s' % (request.form.get('edit_timestamp_date'),
request.form.get('edit_timestamp_time')),
"%d.%m.%Y %H:%M:%S")
except ValueError:
alarm.timestamp = datetime.datetime.now()
alarm._key = request.form.get('edit_key')
alarm.set(u'id.key', request.form.get('edit_keyid'))
alarm.set(u'k.cars1', request.form.get('val_cars1'))
alarm.set(u'k.cars2', request.form.get('val_cars2'))
alarm.set(u'k.material', request.form.get('val_material'))
alarm.set(u'marker', request.form.get('marker'))
alarm.set(u'id.city', request.form.get('edit_city'))
_city = City.getCities(id=request.form.get('edit_cityname'))
if _city:
alarm.set(u'city', _city.name)
else:
alarm.set(u'city', request.form.get('edit_cityname'))
alarm.set(u'streetno', request.form.get('edit_streetno'))
street = Street.getStreets(id=request.form.get('edit_addressid'))
hnumber = None
if street:
alarm.set(u'id.address', street.id)
try:
hnumber = [
h for h in street.housenumbers
if h.number == request.form.get('edit_streetno').split()[0]
]
if len(hnumber) > 0:
alarm.set(u'lat', hnumber[0].points[0][0])
alarm.set(u'lng', hnumber[0].points[0][1])
except IndexError:
pass
elif request.form.get('edit_addressid') == 'None':
alarm.set(u'id.address', '')
else:
alarm.set(u'id.address', request.form.get('edit_addressid'))
alarm.set(u'address', request.form.get('edit_address'))
if request.form.get('edit_object') != '0':
alarm.set(u'id.object', request.form.get('edit_object'))
else: # remove object definition if present
if u'id.object' in alarm.attributes:
del alarm.attributes[u'id.object']
if u'object' in alarm.attributes:
del alarm.attributes[u'object']
alarm.set(u'priority', request.form.get('edit_priority'))
alarm.set(u'remark', request.form.get('edit_remark'))
alarm.set(u'person', request.form.get('edit_person'))
if request.form.get(u'edit_address2').strip() != '':
alarm.set(u'address2', request.form.get('edit_address2'))
if (request.form.get(u'marker') == '1'
and not hnumber) or request.form.get('update_position') == '1':
alarm.set(u'routing', '')
alarm.set(u'lat', request.form.get('lat'))
alarm.set(u'lng', request.form.get('lng'))
alarm.set(u'zoom', request.form.get('zoom'))
try:
d = datetime.datetime.strptime(
'%s %s' % (request.form.get('edit_endtimestamp_date'),
request.form.get('edit_endtimestamp_time')),
"%d.%m.%Y %H:%M:%S")
except ValueError:
d = datetime.datetime.now()
alarm.set(u'endtimestamp', d)
db.session.commit()
signal.send('alarm', 'updated', alarmid=alarm.id)
if request.form.get('alarm_id') == u'None': # create new
Alarm.changeState(alarm.id, 0) # prepare alarm
return redirect('/alarms?area=%s&state=1' % params['area'])
elif alarm.state == 1: # active alarm update
monitorserver.sendMessage('0', 'reset') # refresh monitor layout
return redirect('/alarms?area=%s&state=0' % params['area'])
elif request.args.get('action') == 'editalarm':
if request.args.get('alarmid', '0') == '0': # add new alarm
alarm = Alarm(datetime.datetime.now(), '', 2, 0)
#flash(babel.gettext(u'alarms.alarmadded'), 'alarms.add')
else: # edit alarm
alarm = Alarm.getAlarms(id=request.args.get('alarmid'))
return render_template(
'frontend.alarms_edit.html',
alarm=alarm,
cities=City.getCities(),
objects=AlarmObject.getAlarmObjects(),
cars=Car.getCars(),
departments=Department.getDepartments(),
frontendarea=params['area'],
frontendmodules=frontend.modules,
frontendmoduledef=Settings.get('frontend.default'))
elif request.args.get('action') == 'refresh': # refresh alarm section
params['area'] = request.args.get('area')
params['activeacc'] = int(request.args.get('activeacc'))
elif request.args.get('action') == 'finishalarm': # finish selected alarm
Alarm.changeState(int(request.args.get('alarmid')), 2)
params['area'] = request.args.get('area')
elif request.args.get(
'action') == 'activatealarm': # activate selected alarm
ret = Alarm.changeState(int(request.args.get('alarmid')), 1)
if len(ret) > 0:
flash(
render_template_string(
"{{ _('alarms.carsinuse') }}</br><b>" + ", ".join(
[r.name
for r in sorted(ret, key=attrgetter('name'))]) +
"</b>"), 'alarms')
params['area'] = request.args.get('area')
params['activeacc'] = 0
elif request.args.get('action') == 'deletealarm': # delete selected alarm
alarm = Alarm.getAlarms(id=request.args.get('alarmid'))
refresh = 1 or alarm.state == 1 # check if alarm is active
try:
# delete file if not used in any other alarm
c = Alarm.query.filter(
Alarm.attributes.any(value=alarm.get('filename'),
name="filename")).count()
if c == 1 and os.path.exists("{}{}".format(
current_app.config.get('PATH_DONE'),
alarm.get('filename'))):
os.remove("{}{}".format(current_app.config.get('PATH_DONE'),
alarm.get('filename')))
except:
pass
alarm.state = -1
alarm.updateSchedules()
db.session.delete(alarm)
db.session.commit()
if refresh:
monitorserver.sendMessage('0', 'reset') # refresh monitor layout
signal.send('alarm', 'deleted', alarmid=request.args.get('alarmid'))
elif request.args.get(
'action'
) == 'archivealarm': # archive selected alarms, id=0 == all
if ";" in request.args.get('alarmid'): # archive selected alarms
for alarmid in request.args.get('alarmid').split(';'):
Alarm.changeState(int(alarmid), 3)
elif int(request.args.get('alarmid')) == 0: # archive all alarms
Alarm.changeStates(3)
else: # archive single selected alarm
Alarm.changeState(int(request.args.get('alarmid')), 3)
params['area'] = request.args.get('area')
stats = dict.fromkeys(Alarm.ALARMSTATES.keys() + ['3'], 0)
for s, c in Alarm.getAlarmCount(days=int(
session['alarmfilter'])): # s=state, c=count(ids of state)
if str(s) in stats.keys():
stats[str(s)] = c
if 'area' not in params:
params['area'] = 'center'
if 'activeacc' not in params:
params['activeacc'] = 0
return render_template(
'frontend.alarms_smallarea.html',
alarmstates=Alarm.ALARMSTATES,
stats=stats,
frontendarea=params['area'],
activeacc=str(params['activeacc']),
printdefs=Printers.getActivePrintersOfModule('alarms'),
frontendmodules=frontend.modules,
frontendmoduledef=Settings.get('frontend.default'),
alarmfilter=session['alarmfilter'])
