def singleSupplementDataCenter(country, destination, trip_id, package_trip_id,
rate_card_id):
# Fit the Package Bracket Price Form Class
form = AddSingleSupplementData(request.form)
# Fetch the Price Segment Data
price_segment_data = adminPriceSegmentModel.priceSegmentFetchData()
# Fetch admin_id
admin_data = adminModel.adminIdFetchOne(session['username'])
# Fetch Single Supplement Data
single_supplement_data = adminSingleSupplementModel.singleSupplementFetchData(
rate_card_id)
# Fetch One Package Trip Data
package_trip_data = adminPackageTripModel.packageTripDataFetchOne(
package_trip_id)
# Fetch The Rate Card Data
rate_card_data = adminRateCardModel.rateCardDataFetchOne(rate_card_id)
# Add the Data
if request.method == 'POST' and form.validate():
admin_id = admin_data['admin_id']
min_pax = form.min_pax.data
max_pax = form.max_pax.data
price_per_person = form.price_per_person.data
price_segment_id = form.price_segment_id.data
rate_card_id = rate_card_id
# Execute the query
adminSingleSupplementModel.addSingleSupplementData(
price_segment_id, admin_id, min_pax, max_pax, price_per_person,
rate_card_id)
# Send the notification
flash('Single Supplement has been added', 'success')
# Redirect
return redirect(
url_for('singleSupplementDataCenter',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id,
rate_card_id=rate_card_id))
return render_template('admin/adminSingleSupplementDataCenter.html',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id,
form=form,
price_segment_data=price_segment_data,
single_supplement_data=single_supplement_data,
rate_card_id=rate_card_id,
package_trip_data=package_trip_data,
rate_card_data=rate_card_data)
def componentPackageTripAddSightseeingTransfer(country, destination, trip_id,
package_trip_id):
# Fetch One Package Trip Data from package_trip_id
package_trip_data = adminPackageTripModel.packageTripDataFetchOne(
package_trip_id)
# Fit the Add Component of Package Trip Form Class
form = AddComponentPackageTripData(request.form)
# FEtch the Sightseeing Transfer Data
sightseeing_transfer_data = adminSightseeingTransferModel.sightseeingTransferFetchData(
trip_id)
# Add the Data
if request.method == 'POST' and form.validate():
day_no = form.day_no.data
sightseeing_transfer_id = form.sightseeing_transfer_id.data
# Fetch One the sightseeing_transfer refer to sightseeing_transfer_id
sightseeing_transfer_fetch_one = adminSightseeingTransferModel.sightseeingTransferDataFetchOne(
sightseeing_transfer_id)
# Execute Query : add the itinerary
adminItineraryModel.addItinerary(
day_no, package_trip_id,
sightseeing_transfer_fetch_one['sightseeing_transfer_title'],
sightseeing_transfer_fetch_one['sightseeing_transfer_description'],
"Sightseeing Transfer")
# Fetch the Itinerary data
itinerary_data = adminItineraryModel.lastUpdateItinerary()
# Execute Query : add the data
adminPackageTripTRSightseeingTransferModel.addPackageTripSightseeingTransferData(
sightseeing_transfer_id, package_trip_id, day_no,
itinerary_data['itinerary_id'])
# Send notification
flash('Sightseeing Transfer has been added as component', 'success')
# redirect to the package trip component
return redirect(
url_for('componentPackageTrip',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id))
return render_template(
'admin/adminPackageTripTRAddSightseeingTransfer.html',
form=form,
package_trip_data=package_trip_data,
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id,
sightseeing_transfer_data=sightseeing_transfer_data)
def componentPackageTripAddDayExcursion(country, destination, trip_id,
package_trip_id):
# Fetch One Package Trip Data from package_trip_id
package_trip_data = adminPackageTripModel.packageTripDataFetchOne(
package_trip_id)
# Fit the Add Component of Package Trip Form Class
form = AddComponentPackageTripData(request.form)
# Fetch the Day Excursion Data
day_excursion_data = adminDayExcursionModel.dayExcursionDataFetchOneServiceId(
trip_id)
# Add the Data
if request.method == 'POST' and form.validate():
day_no = form.day_no.data
day_excursion_id = form.day_excursion_id.data
# Fetch One the Day Excursion Data
day_excursion_fetch_one = adminDayExcursionModel.dayExcursionDataFetchOne(
day_excursion_id)
# Execute query : ad the Itinerary
adminItineraryModel.addItinerary(
day_no, package_trip_id,
day_excursion_fetch_one['day_excursion_title'],
day_excursion_fetch_one['day_excursions_description'],
"Day Excursion")
# Fetch the Itinerary Data
itinerary_data = adminItineraryModel.lastUpdateItinerary()
# Execute Query : add the data
adminPackageTripTRDayExcursionModel.addPackageTripDayExcursionData(
day_excursion_id, package_trip_id, day_no,
itinerary_data['itinerary_id'])
# send notification
flash('Package Trip Component Added', 'success')
return redirect(
url_for('componentPackageTrip',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id))
return render_template('admin/adminPackageTripTRAddDayExcursion.html',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id,
package_trip_data=package_trip_data,
form=form,
day_excursion_data=day_excursion_data)
def componentPackageTripEditDayExcursion(country, destination, trip_id,
package_trip_id, itinerary_id):
# Fetch One Package Trip Data from package_trip_id
package_trip_data = adminPackageTripModel.packageTripDataFetchOne(
package_trip_id)
# Fit the Add Component of Package Trip Form Class
form = AddComponentPackageTripData(request.form)
# Fetch the Itinerary Data
itinerary_data = adminItineraryModel.itineraryFetchDataFromId(itinerary_id)
# Populate Package Trip Component from fields
form.day_no.data = itinerary_data['day_no']
# Update Package Trip Data
if request.method == 'POST' and form.validate():
# asign the variable value from request form value
day_no = request.form['day_no']
# Execute query for update Day No of Itinerary Table
adminItineraryModel.updateDayNo(day_no, itinerary_id)
# Execute query for update Day No of Day Excursion Transaction
adminPackageTripTRDayExcursionModel.updatePackageTripDayExcursionData(
day_no, itinerary_id)
# Send notification to the dashboard
flash('Package Trip Compnent has been updated', 'success')
return redirect(
url_for('componentPackageTrip',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id))
return render_template('admin/adminPackageTripTREditDayExcursion.html',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id,
package_trip_data=package_trip_data,
form=form,
itinerary_data=itinerary_data)
def editPackageBracketPrice(country, destination, trip_id, package_trip_id,
rate_card_id, package_bracket_price_id):
# Fit the Package Bracket Price Form Class
form = AddPackageBracketPriceData(request.form)
# Fetch the Price Segment Data
price_segment_data = adminPriceSegmentModel.priceSegmentFetchData()
# Fetch One Package Trip Data
package_trip_data = adminPackageTripModel.packageTripDataFetchOne(
package_trip_id)
# Fetch One Package Bracket Price Data
package_bracket_price_data_fo = adminPackageBracketPriceModel.packageBracketPriceFetchOne(
package_bracket_price_id)
# Fetch The Rate Card Data
rate_card_data = adminRateCardModel.rateCardDataFetchOne(rate_card_id)
# Populate Day Excursion form fields
form.min_pax.data = package_bracket_price_data_fo['min_pax']
form.max_pax.data = package_bracket_price_data_fo['max_pax']
form.price_per_person.data = package_bracket_price_data_fo[
'price_per_person']
# Update Package Bracket Price
if request.method == 'POST' and form.validate():
# asign the variable value from request form value
min_pax = request.form['min_pax']
max_pax = request.form['max_pax']
price_per_person = request.form['price_per_person']
price_segment_id = request.form['price_segment_id']
# Execute the query
adminPackageBracketPriceModel.updatePackageBracketPriceData(
min_pax, max_pax, price_per_person, price_segment_id,
package_bracket_price_id)
# Send the notification to the dashboard
flash('Package Bracket Price has been updated', 'success')
# retur the the certain page
return redirect(
url_for('packageBracketPrice',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id,
rate_card_id=rate_card_id))
return render_template(
'admin/adminPackageBracketPriceDataCenterEdit.html',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id,
form=form,
price_segment_data=price_segment_data,
rate_card_id=rate_card_id,
package_bracket_price_data_fo=package_bracket_price_data_fo,
package_trip_data=package_trip_data,
rate_card_data=rate_card_data)
def editSingleSupplement(country, destination, trip_id, package_trip_id,
rate_card_id, single_supplement_id):
# Fit the Single Supplement Form class
form = AddSingleSupplementData(request.form)
# Fetch the Price Segment Data
price_segment_data = adminPriceSegmentModel.priceSegmentFetchData()
# Fetch One Single Supplement Data
single_supplement_data_fo = adminSingleSupplementModel.singleSupplementFetchOne(
single_supplement_id)
# Fetch One Package Trip Data
package_trip_data = adminPackageTripModel.packageTripDataFetchOne(
package_trip_id)
# Fetch The Rate Card Data
rate_card_data = adminRateCardModel.rateCardDataFetchOne(rate_card_id)
# Populate Single Supplement Form Fields
form.min_pax.data = single_supplement_data_fo['min_pax']
form.max_pax.data = single_supplement_data_fo['max_pax']
form.price_per_person.data = single_supplement_data_fo['price_per_person']
# Update Package Bracket Price
if request.method == 'POST' and form.validate():
# asign the variable value from request form value
min_pax = request.form['min_pax']
max_pax = request.form['max_pax']
price_per_person = request.form['price_per_person']
price_segment_id = request.form['price_segment_id']
# Execute the query
adminSingleSupplementModel.updateSingleSupplementData(
min_pax, max_pax, price_per_person, price_segment_id,
single_supplement_id)
# Send the notification to the dashboard
flash('Single Supplement has been updated', 'success')
# Redirect
return redirect(
url_for('singleSupplementDataCenter',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id,
rate_card_id=rate_card_id))
return render_template('admin/adminSingleSupplementDataCenterEdit.html',
country=country,
destination=destination,
trip_id=trip_id,
package_trip_id=package_trip_id,
form=form,
price_segment_data=price_segment_data,
rate_card_id=rate_card_id,
single_supplement_data_fo=single_supplement_data_fo,
package_trip_data=package_trip_data,
rate_card_data=rate_card_data)