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