def editquery(request):
stmt = mydb.cursor()
if request.POST:
id = request.session['Adminid']
name = request.POST['name']
mail = request.POST['email']
password = request.POST['pass']
phone = request.POST['phone']
salary = request.POST['salary']
role = request.POST['role']
sql = "UPDATE employee SET emp_name = %s, emp_email = %s, emp_pass = %s, emp_phone = %s, emp_salary = %s, emp_role = %s WHERE emp_ID = %s"
val = (name, mail, password, phone, salary, role, id)
stmt.execute(sql, val)
mydb.commit()
id = request.session['Adminid']
stmt.execute("SELECT * FROM employee WHERE emp_ID = " + str(id))
result = stmt.fetchone()
context = {
'admin': result,
}
return render(request, template_name=path + "index.html", context=context)
def reservequery(request):
stmt = mydb.cursor()
if request.POST:
id = request.session['clientid']
flight_id = request.POST["flight_id"]
priceA = request.POST['priceA']
priceB = request.POST['priceB']
priceC = request.POST['priceC']
if request.POST['flightClass'] == "ClassA":
price = priceA
elif request.POST['flightClass'] == "ClassB":
price = priceB
else:
price = priceC
sql = "INSERT INTO transactions(tr_client, tr_flight, tr_price, tr_time) VALUES (%s, %s, %s, now())"
val = (id, flight_id, price)
stmt.execute(sql, val)
mydb.commit()
stmt.execute(
"SELECT flights.*, timetable.tt_end, timetable.tt_hour_start, timetable.tt_hour_end FROM flights INNER JOIN timetable ON flights.flt_timetable = timetable.tt_ID WHERE DATE(flt_date) > CURDATE() ORDER BY flt_id ASC LIMIT 50"
)
result = stmt.fetchall()
context = {
'flights': result,
}
return render(request, template_name=path + "index.html", context=context)
def addquery(request):
stmt = mydb.cursor()
if request.POST:
day = request.POST['day']
starttime = request.POST['starttime']
endtime = request.POST['endtime']
plane = request.POST['plane']
origin = request.POST['origin']
destination = request.POST['destination']
pa = request.POST['priceA']
pb = request.POST['priceB']
pc = request.POST['priceC']
sql = 'INSERT INTO timetable(tt_plane_id, tt_start, tt_end, tt_price_a, tt_price_b, tt_price_c, tt_dayofweek, tt_hour_start, tt_hour_end) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)'
val = (plane, origin, destination, pa, pb, pc, day, starttime, endtime)
stmt.execute(sql, val)
mydb.commit()
stmt.execute(
"SELECT timetable.*, planes.pln_name FROM timetable INNER JOIN planes ON timetable.tt_plane_id = planes.pln_ID ORDER BY tt_ID ASC"
)
result = stmt.fetchall()
context = {
"times": result,
}
return render(request, template_name=path + "index.html", context=context)
def editquery(request):
stmt = mydb.cursor()
if request.POST:
id_time = request.POST['time_id']
day = request.POST['day']
starttime = request.POST['starttime']
endtime = request.POST['endtime']
plane = request.POST['plane']
origin = request.POST['origin']
destination = request.POST['destination']
pa = request.POST['priceA']
pb = request.POST['priceB']
pc = request.POST['priceC']
sql = "UPDATE timetable SET tt_plane_id = %s, tt_start = %s, tt_end = %s, tt_price_a = %s, tt_price_b = %s, tt_price_c = %s, tt_dayofweek = %s, tt_hour_start = %s, tt_hour_end = %s WHERE tt_ID = %s"
val = (plane, origin, destination, pa, pb, pc, day, starttime, endtime,
id_time)
stmt.execute(sql, val)
mydb.commit()
stmt.execute(
"SELECT timetable.*, planes.pln_name FROM timetable INNER JOIN planes ON timetable.tt_plane_id = planes.pln_ID ORDER BY tt_ID ASC"
)
result = stmt.fetchall()
context = {
"times": result,
}
return render(request, template_name=path + "index.html", context=context)
def editquery(request):
if request.POST:
id = request.session['clientid']
name = request.POST['name']
mail = request.POST['email']
password = request.POST['pass']
phone = request.POST['phone']
address = request.POST['address']
ccN = request.POST['Credit']
sql = "UPDATE client SET clnt_name = %s, clnt_email = %s, clnt_pass = %s, clnt_phone = %s, clnt_address = %s, clnt_ccnumber = %s WHERE clnt_ID = %s"
val = (name, mail, password, phone, address, ccN, id)
stmt.execute(sql, val)
mydb.commit()
return indexRec(request)
def addquery(request):
stmt = mydb.cursor()
if request.POST:
plane_name = request.POST['pln_name']
ca = request.POST['capacityA']
cb = request.POST['capacityB']
cc = request.POST['capacityC']
sql = "INSERT INTO planes(pln_name, pln_c_a, pln_c_b, pln_c_c) VALUES (%s, %s, %s, %s)"
val = (plane_name, ca, cb, cc)
stmt.execute(sql, val)
mydb.commit()
stmt.execute("SELECT * FROM planes")
result = stmt.fetchall()
context = {"planes": result}
return render(request, template_name=path + "index.html", context=context)
def editquery(request):
stmt = mydb.cursor()
if request.POST:
id = request.POST['id_plane']
plane_name = request.POST['pln_name']
ca = request.POST['capacityA']
cb = request.POST['capacityB']
cc = request.POST['capacityC']
sql = "UPDATE planes SET pln_name = %s, pln_c_a = %s, pln_c_b = %s, pln_c_c = %s WHERE pln_ID = %s"
val = (plane_name, ca, cb, cc, id)
stmt.execute(sql, val)
mydb.commit()
stmt.execute("SELECT * FROM planes")
result = stmt.fetchall()
context = {
"planes": result,
}
return render(request, template_name=path + "index.html", context=context)