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 index(request): stmt = mydb.cursor() stmt.execute("SELECT * FROM planes") result = stmt.fetchall() context = {"planes": result} return render(request, template_name=path + "index.html", context=context)
def index(request): id = request.session['Adminid'] stmt = mydb.cursor() 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 gotoedit(request, plane_id): stmt = mydb.cursor() stmt.execute("SELECT * FROM planes WHERE pln_ID = " + str(plane_id)) result = stmt.fetchone() context = { "plane": result, } return render(request, template_name=path + "edit.html", context=context)
def index(request): stmt = mydb.cursor() 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 index(request): stmt = mydb.cursor() 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 gotoedit(request, time_table_id): stmt = mydb.cursor() stmt.execute("SELECT * FROM timetable WHERE tt_ID = " + str(time_table_id)) result = stmt.fetchone() context = { "time": result, } stmt.execute("SELECT * FROM planes") result = stmt.fetchall() context['planes'] = result return render(request, template_name=path + "edit.html", context=context)
def gotoreserve(request, flight_id): stmt = mydb.cursor() stmt.execute( "SELECT flights.*, timetable.* FROM flights INNER JOIN timetable ON flights.flt_timetable = timetable.tt_ID WHERE flt_ID = " + str(flight_id)) result = stmt.fetchone() context = { 'flight': result, } return render(request, template_name=path + "reserve.html", context=context)
def loginadmin(request): stmt = mydb.cursor() if request.POST: name = request.POST['name'] pas = request.POST['password'] stmt.execute( "SELECT * FROM employee WHERE emp_name = %s AND emp_pass = %s", (name, pas)) result = stmt.fetchone() if result: request.session['Admin'] = name request.session['Adminid'] = result[0] return render(request, template_name="main/templates/index.html")
def signin(request): stmt = mydb.cursor() if request.POST: name = request.POST['name'] pssword = request.POST['password'] stmt.execute( "SELECT * FROM client WHERE clnt_name = %s AND clnt_pass = %s", (name, pssword)) result = stmt.fetchone() if result: request.session['client'] = name request.session['clientid'] = result[0] else: request.session[ 'msg'] = "<div class='alert alert-danger'>Something is Wrong</div>" return render(request, template_name="main/templates/index.html")
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 index(request): stmt = mydb.cursor() stmt.execute("SELECT SUM(flt_cost) FROM flights") cost = stmt.fetchone() context = {'cost': cost[0]} stmt.execute("SELECT COUNT(flt_id) FROM flights") flights = stmt.fetchone() context['flights'] = flights[0] stmt.execute("SELECT COUNT(pln_id) FROM planes") planes = stmt.fetchone() context['planes'] = planes[0] stmt.execute("SELECT COUNT(clnt_id) FROM client") clients = stmt.fetchone() context['clients'] = clients[0] 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)
from django.shortcuts import render from royalFlight.db import mydb path = "userProfile/templates/" stmt = mydb.cursor(buffered=True) def index(request): return indexRec(request) def gotoedit(request): id = request.session['clientid'] stmt.execute("SELECT * FROM client WHERE clnt_ID = " + str(id)) result = stmt.fetchone() context = { 'client': result } return render(request, template_name=path + "edit.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']