def sensoradd():
"""Add a new Sensor"""
if (session.get("user_id") != None):
sql_query_raum = "select ra_id, ra_bezeichnung, ra_nummer from raum"
raums = databasemanager.getAll(sql_query_raum)
sql_query_havc = "select havc_id, havc_name from havc"
havcs = databasemanager.getAll(sql_query_havc)
return render_template("/sensoradd.html", raums=raums, havcs=havcs)
else:
return render_template("/index.html")
def havcadd():
"""Add a new Sensor"""
if (session.get("user_id") != None):
sql_query = "select sw_id from stockwerk"
stocks = databasemanager.getAll(sql_query)
return render_template("/HAVCadd.html", stocks=stocks)
else:
return render_template("/index.html")
def stockwerk():
"""Show all the buildings"""
if (session.get("user_id") != None):
id = request.form["stockwerk_id"]
sql_query = "select * from stockwerk where stw_geb_id = " + str(id)
stocks = databasemanager.getAll(sql_query)
return render_template("/stockwerk.html", stocks=stocks)
else:
return render_template("/index.html")
def index():
"""Show all the buildings"""
if (session.get("user_id") != None):
id = session.get("user_id")
sql_query = "select ge_id, ge_name, ge_ort, ge_plz, ge_strasse, ge_hausnummer from gebaeude, personen, ln_datenbearbeiten where ln_dabe_per_id = " + str(
id) + " AND ln_dabe_ge_id = ge_id"
records = databasemanager.getAll(sql_query)
return render_template("/index.html", records=records)
else:
return render_template("/index.html")
def stockwerk():
"""Show all the Stockwerk"""
if (session.get("user_id") != None):
id = request.form["stockwerk_id"]
sql_query = "select sw_id, sw_bezeichnung from Stockwerk where sw_ge_id = " + str(
id)
stocks = databasemanager.getAll(sql_query)
return render_template("/stockwerk.html", stocks=stocks)
else:
return render_template("/index.html")
def raum():
"""Show all the rooms"""
if (session.get("user_id") != None):
id = request.form["raum_id"]
sql_query = "select ra_id, ra_bezeichnung, ra_nummer, ra_ifc_guid from Raum where ra_sw_id = " + str(
id)
raums = databasemanager.getAll(sql_query)
return render_template("/raum.html", raums=raums)
else:
return render_template("/index.html")
def sensor():
"""Show all the sensors"""
if (session.get("user_id") != None):
id = request.form["sensor_id"]
sql_query = "select sen_id, sen_name, sen_typ, sen_position, sen_ra_id from Sensor where sen_ra_id = " + str(
id)
sens = databasemanager.getAll(sql_query)
return render_template("/sensor.html", sens=sens)
else:
return render_template("/index.html")
def index():
"""Show all the buildings"""
if (session.get("user_id") != None):
id = session.get("user_id")
sql_query = "select geb_id, geb_plz, geb_strasse, geb_hausnummer,geb_ort from gebaeude where geb_blt_id = " + str(
id)
records = databasemanager.getAll(sql_query)
return render_template("/index.html", records=records)
else:
return render_template("/index.html")
def HAVC():
"""Show all the HAVCs"""
if (session.get("user_id") != None):
id = request.form["HAVC_id"]
sql_query = "select havc_id, havc_name, havc_typ, havc_position, havc_sw_id from havc where havc_sw_id = " + str(
id)
HAVCs = databasemanager.getAll(sql_query)
return render_template("/HAVC.html", HAVCs=HAVCs)
else:
return render_template("/index.html")
def havcdelete():
if (session.get("user_id") != None):
id = request.form["havc_entfernen"]
databasemanager.deletedata("havc", "havc_id", id)
stockwerk = request.form["stockwerk"]
sql_query = "select havc_id, havc_name, havc_typ, havc_position, havc_sw_id from havc where havc_sw_id = " + str(
stockwerk)
HAVCs = databasemanager.getAll(sql_query)
return render_template("/HAVC.html", HAVCs=HAVCs)
else:
return render_template("/index.html")
def sensordelete():
if (session.get("user_id") != None):
id = request.form["sen_entfernen"]
databasemanager.deletedata("sensor", "sen_id", id)
raum = request.form["raum"]
sql_query = "select sen_id, sen_name, sen_typ, sen_position, sen_ra_id from sensor where sen_ra_id = " + str(
raum)
sens = databasemanager.getAll(sql_query)
return render_template("/sensor.html", sens=sens)
else:
return render_template("/index.html")
def wand():
"""Show all the wands"""
if (session.get("user_id") != None):
id = request.form["wand_id"]
s = session.get("id")
print(s)
sql_query = "select wa_id, wa_schaden, ln_bes_wa_richtung, wa_ifc_guid from wand, ln_besitzen where ln_bes_ra_id = " + str(
id) + " and ln_bes_wa_id = wa_id"
wands = databasemanager.getAll(sql_query)
return render_template("/wand.html", wands=wands)
else:
return render_template("/index.html")
def wandspeichern():
if (session.get("user_id") != None):
ra_id = request.form["speichern"]
id = request.form["id"]
schaden = request.form["schaden"]
databasemanager.updateTable("wand", "wa_schaden", schaden, "wa_id", id)
sql_query = "select wa_id, wa_schaden, ln_bes_wa_richtung, wa_ifc_guid from wand, ln_besitzen where ln_bes_ra_id = " + str(
ra_id) + " and ln_bes_wa_id = wa_id"
wands = databasemanager.getAll(sql_query)
return render_template("/wand.html", wands=wands)
else:
return render_template("/index.html")
def stockwerkcheck():
if (session.get("user_id") != None):
tem_grenze = float(request.form["temperaturgrenze"])
feu_grenze = float(request.form["feuchtigkeitsgrenze"])
sql_query1 = "select seda_id, seda_zeit, seda_temperatur, seda_feuch, seda_sen_id from sensordaten"
sendas = databasemanager.getAll(sql_query1)
for senda in sendas:
timestamp = senda[1]
sql_query3 = "select sen_havc_id from sensor, sensordaten where seda_id = " + str(
senda[0]) + " and seda_sen_id = sen_id"
havc_id = databasemanager.getOne(sql_query3)
if (tem_grenze < senda[2] < 2 * tem_grenze
or feu_grenze < senda[3] < 2 * feu_grenze):
status = "An"
stuf = "Stufe 1"
elif (2 * tem_grenze < senda[2] < 3 * tem_grenze
or 2 * feu_grenze < senda[3] < 3 * feu_grenze):
status = "An"
stuf = "Stufe 2"
elif (senda[2] > 3 * tem_grenze or senda[3] > 3 * feu_grenze):
status = "An"
stuf = "Stufe 3"
else:
status = "Aus"
stuf = "Stufe 0"
sql_query2 = """insert into havcdaten (havcda_zeitpunkt, havcda_stufe, havcda_AnAusStatus, havcda_havc_id)
values (%s, %s, %s, %s)"""
insert_tuple = (timestamp, stuf, status, havc_id[0])
databasemanager.insertData(sql_query2, insert_tuple)
sql_query4 = "select * from havcdaten"
havcdatens = databasemanager.getAll(sql_query4)
return render_template("/stockwerkcheck.html", havcdatens=havcdatens)
else:
return render_template("/index.html")
def havcnew():
if (session.get("user_id") != None):
name = request.form["name"]
typ = request.form["typ"]
position = request.form["position"]
ebene = request.form["stockwerk"]
sql_query = "insert into havc (havc_name, havc_typ, havc_position, havc_sw_id) values (%s, %s, %s, %s)"
insert_tuple = (name, typ, position, ebene)
databasemanager.insertData(sql_query, insert_tuple)
sql_query_select = "select havc_id, havc_name, havc_typ, havc_position, havc_sw_id from havc where havc_sw_id = " + str(
ebene)
HAVCs = databasemanager.getAll(sql_query_select)
return render_template("/HAVC.html", HAVCs=HAVCs)
else:
return render_template("/index.html")
def sensornew():
if (session.get("user_id") != None):
name = request.form["name"]
typ = request.form["typ"]
position = request.form["position"]
raum = request.form["raum"]
havc = request.form["havc"]
sql_query = "insert into sensor (sen_name, sen_typ, sen_position, sen_ra_id, sen_havc_id) values (%s, %s, %s, %s, %s)"
insert_tuple = (name, typ, position, raum, havc)
databasemanager.insertData(sql_query, insert_tuple)
sql_query_select = "select sen_id, sen_name, sen_typ, sen_position from sensor where sen_ra_id = " + str(
raum)
sens = databasemanager.getAll(sql_query_select)
return render_template("/sensor.html", sens=sens)
else:
return render_template("/index.html")
def havcspeichern():
if (session.get("user_id") != None):
id = request.form["speichern"]
name = request.form["name"]
typ = request.form["typ"]
position = request.form["position"]
ebene = request.form["ebene"]
databasemanager.updateTable("havc", "havc_name", name, "havc_id", id)
databasemanager.updateTable("havc", "havc_typ", typ, "havc_id", id)
databasemanager.updateTable("havc", "havc_position", position,
"havc_id", id)
databasemanager.updateTable("havc", "havc_sw_id", ebene, "havc_id", id)
sql_query = "select havc_id, havc_name, havc_typ, havc_position, havc_sw_id from havc where havc_sw_id = " + str(
ebene)
HAVCs = databasemanager.getAll(sql_query)
return render_template("/HAVC.html", HAVCs=HAVCs)
else:
return render_template("/index.html")
def raumspeichern():
if (session.get("user_id") != None):
id = request.form["speichern"]
bezeichnung = request.form["bezeichnung"]
nummer = request.form["nummer"]
ebene = request.form["stockwerk"]
ifc_guid = request.form["ifc_guid"]
databasemanager.updateTable("raum", "ra_bezeichnung", bezeichnung,
"ra_id", id)
databasemanager.updateTable("raum", "ra_nummer", nummer, "ra_id", id)
databasemanager.updateTable("raum", "ra_sw_id", ebene, "ra_id", id)
databasemanager.updateTable("raum", "ra_ifc_guid", ifc_guid, "ra_id",
id)
sql_query = "select ra_id, ra_bezeichnung, ra_nummer, ra_ifc_guid from raum where ra_sw_id = " + str(
ebene)
raums = databasemanager.getAll(sql_query)
return render_template("/raum.html", raums=raums)
else:
return render_template("/index.html")
def sensorspeichern():
if (session.get("user_id") != None):
id = request.form["speichern"]
name = request.form["name"]
typ = request.form["typ"]
position = request.form["position"]
raum = request.form["raum"]
havc = request.form["havc"]
databasemanager.updateTable("sensor", "sen_name", name, "sen_id", id)
databasemanager.updateTable("sensor", "sen_typ", typ, "sen_id", id)
databasemanager.updateTable("sensor", "sen_position", position,
"sen_id", id)
databasemanager.updateTable("sensor", "sen_ra_id", raum, "sen_id", id)
databasemanager.updateTable("sensor", "sen_havc_id", havc, "sen_id",
id)
sql_query = "select sen_id, sen_name, sen_typ, sen_position, sen_ra_id, sen_havc_id from sensor where sen_ra_id = " + str(
raum)
sens = databasemanager.getAll(sql_query)
return render_template("/sensor.html", sens=sens)
else:
return render_template("/index.html")
