def car_update(car_id):
handler = car_handler()
query_string = car.update_car(request.form)
handler.insert_values(query_string)
#view = render_template("cars/index.html", data=info)
view = redirect(url_for('car_view', car_id=request.form['vin']))
return view
def car_view(car_id):
handler = car_handler()
rows = handler.select_query_values("select * from car where vin_no=" +
str(car_id))
info = car_id
view = render_template("cars/show.html", data=info, row_data=rows)
return view
def car_available():
#user_info = "[username]"
handler = car_handler()
# query_string should select ONLY available cars
query_string = "select * from car"
rows = handler.select_query_values(query_string)
view = render_template("cars/available.html", row_data=rows)
return view
def customers_created():
handler = car_handler()
if (request.form['license_no'] != ""):
query_string = customer.create_customer(request.form)
handler.insert_values(query_string)
view = render_template("customers/created.html")
else:
view = render_template("customers/notCreated.html")
return view
def users_created():
handler = car_handler()
if (request.form['employee_no'] != ""):
query_string = user.create_user(request.form)
handler.insert_values(query_string)
view = render_template("/users/created.html")
else:
view = render_template("/users/notCreated.html")
return view
def event_sale_create(car_id):
handler = car_handler()
event_query = event.create_event(request.form, car_id,
session.get("employee_no"))
event_id = handler.insert_values(event_query)
pos_query = pos.create_pos(event_id, request.form["assigned"])
pos_id = handler.insert_values(pos_query)
sale_query = sale.create_sale(request.form, pos_id)
sale_id = handler.insert_values(sale_query)
info = car_id
view = redirect(url_for('event_view', event_id=event_id))
return view
def event_inspection_create(car_id):
handler = car_handler()
event_query = event.create_event(request.form, car_id,
session.get("employee_no"))
event_id = handler.insert_values(event_query)
backroom_query = backroom.create_backroom(event_id,
request.form["assigned"])
backroom_id = handler.insert_values(backroom_query)
inspection_query = inspection.create_inspection(request.form, backroom_id)
inspection_id = handler.insert_values(inspection_query)
info = car_id
view = redirect(url_for('event_view', event_id=event_id))
return view
def car_edit(car_id):
handler = car_handler()
rows = handler.select_query_values("select * from car where vin_no=" +
str(car_id))
new_data = []
for val in rows[0]:
if val == None:
new_data.append("")
else:
new_data.append(val)
info = car_id
view = render_template("cars/edit.html", car_id=info, row_data=[new_data])
return view
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_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
def event_available_backroom_create(car_id):
handler = car_handler()
event_query = event.create_event(request.form, car_id,
session.get("employee_no"))
event_id = handler.insert_values(event_query)
backroom_query = backroom.create_backroom(event_id,
request.form["assigned"])
backroom_id = handler.insert_values(backroom_query)
print("Creating backroom")
available_query = available.create_available(request.form, "", backroom_id)
available_id = handler.insert_values(available_query)
info = car_id
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_view(event_id):
handler = car_handler()
queries = event.view_events_all(event_id)
index = 0
for query in queries:
row = handler.select_query_values(query)
if (len(row) != 0):
break
else:
index += 1
event_type = event.get_type_event(index)
view = render_template('events/' + event_type[0] + '/' + event_type[1] +
'/view.html',
row_data=row)
return view
def login():
if request.method == "GET":
view = render_template("auth/login.html", data="")
else:
handler = car_handler()
if handler.check_valid_user(request.form['eid']):
session["logged_in"] = True
user_values = handler.select_query_values(
"select * from user where employee_no=" + request.form['eid'])
session["employee_no"] = user_values[0][0]
session["phone"] = user_values[0][1]
session["fname"] = user_values[0][2]
session["lname"] = user_values[0][3]
session["is_admin"] = user_values[0][4]
session["address"] = user_values[0][5]
view = redirect(url_for("homepage"))
else:
message = "Not a valid employee ID"
view = render_template("auth/login.html", data=message)
return view
def event_edit(event_id):
handler = car_handler()
queries = event.view_events_all(event_id)
index = 0
for query in queries:
row = handler.select_query_values(query)
if (len(row) != 0):
break
else:
index += 1
event_type = event.get_type_event(index)
new_data = []
for val in row[0]:
if val == None:
new_data.append("")
else:
new_data.append(val)
view = render_template('events/' + event_type[0] + '/' + event_type[1] +
'/edit.html',
row_data=[new_data],
event_id=event_id)
return view
def users_search():
handler = car_handler()
query_string = user.search_user(request.form)
rows = handler.select_query_values(query_string)
view = render_template("users/results.html", row_data=rows)
return view
def customer_delete(cust_id):
handler = car_handler()
rows = handler.insert_values("delete from customer where license_no=\"" +
str(cust_id) + "\"")
view = redirect(url_for('customers'))
return view
def car_delete(car_id):
handler = car_handler()
rows = handler.insert_values("delete from car where vin_no=" + str(car_id))
view = redirect(url_for('cars'))
return view
def event_results():
handler = car_handler()
query_string = event.search_event(request.form)
rows = handler.select_query_values(query_string)
view = render_template("events/results.html", row_data=rows)
return view
def events():
handler = car_handler()
rows = handler.select_query_values("select * from event;")
view = render_template("events/results.html", row_data=rows)
return view
def event_delete(event_id):
handler = car_handler()
rows = handler.insert_values("delete from event where event_id=" +
str(event_id))
view = redirect(url_for('homepage'))
return view
def event_new(car_id):
handler = car_handler()
info = handler.insert_query("input")
info = car_id
view = render_template("events/new.html", data=info)
return view
def user_delete(user_id):
handler = car_handler()
rows = handler.insert_values("delete from user where employee_no=\"" +
str(user_id) + "\"")
view = redirect(url_for('users'))
return view
def cars_events(car_id):
handler = car_handler()
query_string = "select * from event where car_vin=" + str(car_id)
rows = handler.select_query_values(query_string)
view = render_template("events/results.html", row_data=rows)
return view
