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()