def edit_funeral(id):
cursor = None
try:
cursor = mysql.get_db().cursor()
sql = "SELECT FuneralId, FuneralDate, FuneralStatus, cemetery.CemeteryName, funeral.cemeteryId, deceased.DeceasedFullName, funeral.DeceasedId" \
" FROM funeral " \
"LEFT JOIN cemetery ON funeral.cemeteryId = cemetery.cemeteryId " \
"LEFT JOIN deceased ON funeral.deceasedId = deceased.deceasedId " \
"WHERE funeralid=%s"
cursor.execute(sql,(id,))
row = cursor.fetchone() # tuples
if row is None:
return render_template("404.html")
sql = "SELECT CemeteryId, CemeteryName FROM Cemetery"
cursor.execute(sql)
cemetery_rows = cursor.fetchall()
sql = "SELECT DeceasedId, DeceasedFullName FROM deceased"
cursor.execute(sql)
clients_rows = cursor.fetchall()
funeral = Funeral(*row)
form = FuneralForm(funeral=funeral, client_list=clients_rows, cemeteries_list=cemetery_rows, cemeteries=funeral.cemetery_id, clients=funeral.client_id)
return render_template("new_funeral.html", form=form, url=url_for('.update_funeral'), action='edit')
finally:
if cursor is not None:
cursor.close()
def get_freeplaces():
cursor = None
try:
cursor = mysql.get_db().cursor()
sql = "SELECT CemeteryId, CemeteryName FROM cemetery"
cursor.execute(sql)
cemeteries_rows = cursor.fetchall()
form = SelectForm("Cemetery", select_list=cemeteries_rows)
if request.method == 'GET':
return render_template("ReportsIntParam.html",
form=form,
url=url_for('.get_freeplaces'),
name='Free places')
id = request.form['select']
sql = "CALL GetCemeteryFreePlacesNumber(%s)"
cursor.execute(sql, id)
rows = cursor.fetchone()
return render_template('ReportsIntParam.html',
form=form,
url=url_for('.get_freeplaces'),
name="Free places",
table=rows[0])
finally:
if cursor is not None:
cursor.close()
def get_cemetery_clients():
cursor = None
try:
cursor = mysql.get_db().cursor()
sql = "SELECT CemeteryId, CemeteryName FROM cemetery"
cursor.execute(sql)
cemeteries_rows = cursor.fetchall()
form = SelectForm("Cemetery", select_list=cemeteries_rows)
if request.method == 'GET':
return render_template("ReportsIntParam.html",
form=form,
url=url_for('.get_cemetery_clients'),
name='Clients in cemeteries')
id = request.form['select']
sql = "CALL GetCemeteryDeceased(%s)"
cursor.execute(sql, id)
rows = cursor.fetchall()
clients = ShortClientsTable(list(map(lambda x: ShortClient(*x), rows)))
clients.border = True
return render_template('ReportsIntParam.html',
form=form,
url=url_for('.get_cemetery_clients'),
name="Clients in cemeteries",
table=clients)
finally:
if cursor is not None:
cursor.close()
def cemeteries():
cursor = mysql.get_db().cursor()
sql = "SELECT * FROM cemetery"
cursor.execute(sql)
rows = cursor.fetchall() # tuples
cemeteries = CemeteriesTable(list(map(lambda x: Cemetery(*x), rows)))
cursor.close()
cemeteries.border = True
return render_template('cemeteries.html', table=cemeteries)
def get_free_workers():
cursor = mysql.get_db().cursor()
sql = "CALL GetFreeWorkers()"
cursor.execute(sql)
rows = cursor.fetchall()
workers = FreeWorkersTable(list(map(lambda x: FreeWorker(*x), rows)))
cursor.close()
workers.border = True
return render_template('Reports.html', table=workers, name="FreeWorkers")
def workers():
cursor = mysql.get_db().cursor()
sql = "SELECT * FROM worker"
cursor.execute(sql)
rows = cursor.fetchall() # tuples
workers = WorkersTable(list(map(lambda x: Worker(*x), rows)))
cursor.close()
workers.border = True
return render_template('workers.html', table=workers)
def mortuaries():
cursor = mysql.get_db().cursor()
sql = "SELECT * FROM mortuary"
cursor.execute(sql)
rows = cursor.fetchall() # tuples
mortuaries = MortuariesTable(list(map(lambda x: Mortuary(*x), rows)))
cursor.close()
mortuaries.border = True
return render_template('mortuaries.html', table=mortuaries)
def cars():
cursor = mysql.get_db().cursor()
sql = "SELECT * FROM car"
cursor.execute(sql)
rows = cursor.fetchall() # tuples
cars = CarsTable(list(map(lambda x: Car(*x), rows)))
cursor.close()
cars.border = True
return render_template('cars.html', table=cars)
def get_incompleted_funerals():
cursor = mysql.get_db().cursor()
sql = "CALL GetIncompletedFunerals()"
cursor.execute(sql)
rows = cursor.fetchall()
funerals = IncompletedFuneralsTable(
list(map(lambda x: IncompletedFuneral(*x), rows)))
cursor.close()
funerals.border = True
return render_template('Reports.html',
table=funerals,
name="IncompletedFunerals")
def funerals():
cursor = mysql.get_db().cursor()
sql = "SELECT FuneralId, FuneralDate, FuneralStatus, cemetery.CemeteryName, funeral.cemeteryId, deceased.DeceasedFullName, funeral.DeceasedId " \
"FROM funeral " \
"LEFT JOIN cemetery ON funeral.cemeteryId = cemetery.cemeteryId " \
"LEFT JOIN deceased ON funeral.deceasedId = deceased.deceasedId "
cursor.execute(sql)
rows = cursor.fetchall() # tuples
funerals = FuneralsTable(list(map(lambda x: Funeral(*x), rows)))
cursor.close()
funerals.border = True
return render_template('funerals.html', table=funerals)
def clients():
cursor = mysql.get_db().cursor()
sql = "SELECT DeceasedId, DeceasedFullName, DeceasedPassportNumber, DeceasedBirthDate, DeceasedDeathDate, DeceasedSizeMeasurements," \
"DeceasedWeight, CemeteryName, MortuaryName, deceased.cemeteryId, deceased.mortuaryId" \
" FROM deceased " \
"LEFT JOIN cemetery ON deceased.cemeteryId = cemetery.cemeteryId " \
"LEFT JOIN mortuary ON deceased.mortuaryId = mortuary.mortuaryId"
cursor.execute(sql)
rows = cursor.fetchall() # tuples
clients = ClientsTable(list(map(lambda x: Client(*x), rows)))
cursor.close()
clients.border = True
return render_template('clients.html', table=clients)
def show_create_funeral_dialog():
cursor = mysql.get_db().cursor()
sql = "SELECT CemeteryId, CemeteryName FROM Cemetery"
cursor.execute(sql)
cemetery_rows = cursor.fetchall() # tuples
sql = "SELECT DeceasedId, DeceasedFullName FROM deceased"
cursor.execute(sql)
clients_rows = cursor.fetchall()
cursor.close()
form = FuneralForm(cemeteries_list=cemetery_rows, client_list=clients_rows);
return render_template("new_funeral.html", form=form, url=url_for('.create_funeral'), action='creation')
def edit_cemetery(id):
cursor = None
try:
cursor = mysql.get_db().cursor()
sql = "SELECT * FROM cemetery WHERE cemeteryid=%s";
cursor.execute(sql,(id,))
row = cursor.fetchone() # tuples
if row is None:
return render_template("404.html")
return render_template("edit_cemetery.html", cemetery=Cemetery(*row))
# except Exception as e:
# return render_template("500.html", e=e)
finally:
if cursor is not None:
cursor.close()
def show_create_client_dialog():
cursor = mysql.get_db().cursor()
sql = "SELECT MortuaryId, MortuaryName FROM Mortuary"
cursor.execute(sql)
mortuary_rows = cursor.fetchall() # tuples
sql = "SELECT CemeteryId, CemeteryName FROM Cemetery"
cursor.execute(sql)
cemetery_rows = cursor.fetchall() # tuples
cursor.close()
form = ClientForm(mortuaries_list=mortuary_rows,
cemeteries_list=cemetery_rows)
return render_template("new_client.html",
form=form,
url=url_for('.create_client'),
action='creation')
def edit_client(id):
cursor = None
try:
cursor = mysql.get_db().cursor()
sql = "SELECT DeceasedId, DeceasedFullName, DeceasedPassportNumber, DeceasedBirthDate, DeceasedDeathDate, DeceasedSizeMeasurements," \
"DeceasedWeight, CemeteryName, MortuaryName, deceased.cemeteryId, deceased.mortuaryId" \
" FROM deceased " \
"LEFT JOIN cemetery ON deceased.cemeteryId = cemetery.cemeteryId " \
"LEFT JOIN mortuary ON deceased.mortuaryId = mortuary.mortuaryId " \
"WHERE deceasedid=%s"
cursor.execute(sql, (id, ))
row = cursor.fetchone() # tuples
if row is None:
return render_template("404.html")
sql = "SELECT MortuaryId, MortuaryName FROM Mortuary"
cursor.execute(sql)
mortuary_rows = cursor.fetchall() # tuples
sql = "SELECT CemeteryId, CemeteryName FROM Cemetery"
cursor.execute(sql)
cemetery_rows = cursor.fetchall()
client = Client(*row)
form = ClientForm(client=client,
mortuaries_list=mortuary_rows,
cemeteries_list=cemetery_rows,
cemeteries=client.cemetery_id,
mortuaries=client.mortuary_id)
return render_template("new_client.html",
form=form,
url=url_for('.update_client'),
action='edit')
finally:
if cursor is not None:
cursor.close()
