def event_sale_update(event_id):
handler = car_handler()
event_query = event.update_event(request.form, event_id)
handler.insert_values(event_query)
pos_query = pos.update_pos(request.form["assigned"], event_id)
handler.insert_values(pos_query)
# get pos_id
row = handler.select_query_values(
"select pos_id from pos where event_id=" + str(event_id))
pos_id = row[0][0]
sale_query = sale.update_sale(request.form, pos_id)
sale_id = handler.insert_values(sale_query)
view = redirect(url_for('event_view', event_id=event_id))
return view
def event_available_backroom_update(event_id):
handler = car_handler()
event_query = event.update_event(request.form, event_id)
handler.insert_values(event_query)
backroom_query = backroom.update_backroom(request.form["assigned"],
event_id)
handler.insert_values(backroom_query)
# get pos_id
row = handler.select_query_values(
"select backroom_id from backroom where event_id=" + str(event_id))
backroom_id = row[0][0]
available_query = available.update_available(request.form, "", backroom_id)
available_id = handler.insert_values(available_query)
view = redirect(url_for('event_view', event_id=event_id))
return view
def event_writeoff_update(event_id):
handler = car_handler()
event_query = event.update_event(request.form, event_id)
handler.insert_values(event_query)
backroom_query = backroom.update_backroom(request.form["assigned"],
event_id)
handler.insert_values(backroom_query)
# get pos_id
row = handler.select_query_values(
"select backroom_id from backroom where event_id=" + str(event_id))
backroom_id = row[0][0]
writeoff_query = writeoff.update_writeoff(request.form, backroom_id)
writeoff_id = handler.insert_values(writeoff_query)
view = redirect(url_for('event_view', event_id=event_id))
return view