def insertSeats(): modelCode = request.form.get('modelCode') seatClass = request.form.get('seatClass') model = PlaneModel.SelectPlaneModelsID(modelCode) Seat = Seats("NULL", model, seatClass) Seat.InsertSeats() return redirect('/seats')
def editSeats(): seatNumber = request.form.get('seatNumber') modelCode = request.form.get('modelCode') seatClass = request.form.get('seatClass') model = PlaneModel.SelectPlaneModelsID(modelCode) Seat = Seats.SelectSeatsID(seatNumber) Seat.UpdateSeats(model, seatClass) return redirect('/seats')
def insertFlightUser(): idFlight = request.form.get('idFlight') idUser = request.form.get('idUser') seatNumber = request.form.get('seatNumber') flight = Flight.SelectFlightsID(idFlight) user = User.SelectUserID(idUser) seat = Seats.SelectSeatsID(seatNumber) flightUser = FlightUser(flight, user, seat) flightUser.InsertFlightUser() return redirect('/flightUser')
def reservarViaje(): idFlight = request.form.get('idFlight') idSeat = request.form.get('idSeat') flight = Flight.SelectFlightsID(idFlight) user = User.SelectUserID(session['idUser']) seat = Seats.SelectSeatsID(idSeat) flightUser = FlightUser(flight, user, seat) if flightUser not in FlightUser.SelectFlightUser(): flightUser.InsertFlightUser() return redirect('home')
def editFlightUser(): oldIDFlight = request.form.get('oldIDFlight') oldIDUser = request.form.get('oldIDUser') idFlight = request.form.get('idFlight') idUser = request.form.get('idUser') seatNumber = request.form.get('seatNumber') flight = Flight.SelectFlightsID(idFlight) user = User.SelectUserID(idUser) seat = Seats.SelectSeatsID(seatNumber) flightUser = FlightUser.SelectFlightUserID(oldIDFlight, oldIDUser) flightUser.UpdateFlightUser(flight, user, seat) return redirect('/flightUser')
def elegirAsiento(): salida = request.form.get('salida') llegada = request.form.get('llegada') fechaIda = request.form.get('fechaIda') fechaVuelta = request.form.get('fechaVuelta') listaFlight = Flight.BuscarSalidaLLegadaFechaIdaFechaVuelta( salida, llegada, fechaIda, fechaVuelta) asientos = Seats.SelectSeats() listaAsientos = [] for item in listaFlight: for item2 in asientos: if item2.Model.code == item.Plane.Model.code: listaAsientos.append(item2) return render_template('elegirAsiento.html', listaAsientos=listaAsientos, salida=salida, llegada=llegada, fechaIda=fechaIda, fechaVuelta=fechaVuelta)
def deleteSeats(): seatNumber = request.args.get('seatNumber') Seats.DeleteSeats(seatNumber) return redirect('/seats')
def seat(): seatLista = Seats.SelectSeats() return render_template('Seats.html', seatLista=seatLista)
def GetFlightUser(dic): flight = Flight.SelectFlightsID(dic["idFlight"]) user = User.SelectUserID(dic["idUser"]) seat = Seats.SelectSeatsID(dic["seatNumber"]) return flight, user, seat