Demo - Githubissues

kucukaslan / CS-353

Travel Agency Data Management System

https://kucukaslan.github.io/CS-353/

1 stars 0 forks source link

Demo #17

Closed kucukaslan closed 2 years ago

kucukaslan commented 2 years ago

[x] offer to Tour guide
[ ] Employee Home page "available hotels" buttons doesn't work
[x] Employee home page: remove random numbers between buttons
[x] Rename the navbar items
[x] employee/details.php navbar
[x] admin pages for the "report"

Ahmet-Salman commented 2 years ago

Presentation @MuhammedCanKucukaslan and @MustafaYasirAltunhan

[ ] create a hotel and a room for it (2-3 rooms)
[ ] create a tour and offer/assign a tour guide for it, also create several activities (2 basic, and 2 extra)
[ ] login as a tour guide and accept it @Ahmet-Salman and @guvengergerli
[ ] login in as a customer
[ ] showcase that you can cancel pending tours
[ ] reserve a flight
[ ] reserve 2 hotel booking
[ ] reserve a tour
[ ] show profile @MuhammedCanKucukaslan and @MustafaYasirAltunhan
[ ] accept a hotel booking, reject the other
[ ] accept the user's tour request @Ahmet-Salman and @guvengergerli
[ ] login in as a customer, show the accepted/rejected requests
[ ] in the tour details, reserve an extra activity and showcase that it can be canceled
[ ] go to past tours and show the tour guide profile
[ ] rate it and show that the button disappears after rating

kucukaslan commented 2 years ago

He will probably ask things about these http://mustafa.cavdar.bilkent.edu.tr/cs353/EvaluationSheet.pdf We should not forget to mention/show them. @Ahmet-Salman & guven

[x] Secondary indices
[x] At least one search GUI including range conditions (e.g., between dates, between weights of products, etc.) and flexible conditions for example queries with LIKE, etc.

@MuhammedCanKucukaslan && @MustafaYasirAltunhan

[x] Advanced features (storedprocedure, view)
[x] At least 2 reports with a complex query (including GROUP BY, MAX, MIN, nested queries) and a nicely formatted output screen

Ahmet-Salman commented 2 years ago

For the secondary indices, should I open the PhpMyAdmin page and show him? Edit: We put the secondary index on the airport, right?

kucukaslan commented 2 years ago

@Ahmet-Salman showing "phpmyadmin" might be a bad idea.

Yes.

I made the "email" columns of thecustomer, employee and guide indices. We can mention it and say "we use e-mail for login, it is important for efficience etc." sample quert to add an index: ALTER TABLEemployeeADD INDEX( email);

Ahmet-Salman commented 2 years ago

Okay so we just have to mention it, I will do it in the beginning