alice886 / opentaste

OpenTaste

👉Live Site

OpenTaste is a fullstack clone of OpenTable which provides reservation services among restaurants and customers.

For Restaurant owners, they can list their restaurant on OpenTaste, manage restaurant updates and check customer reservations.

For enrolled users, they can browse all listed restaurants, make reservation in Home page or in Restaurant detailed page, as well as edit/cancel unexpired reservations.

Public users can also enjoy the website without loggingin and browse all listed restaurants.

Built with

• SQL/SQLAlchemy

Project Wiki and Design

OpenTaste Wiki

db Schema

Backend API Routes

Feature List

User Stories

On OpenTaste, you can:

• Browse/Create/Edit/Delete Restaurants
• Check/Create/Edit/Delete Reservations
• (upcoming feature) Search Reservations
• (upcoming feature) Browse/Add/Edit/Delete Reviews on Restaurants
• (upcoming feature) Add restaurants to/Remove restaurants from users' Favourite List

Splash Page

• Both public and loggedin user can browse all restaurants on the site.
• Available timeslots for today's date are presented in red and else in gray.
• Clicking on each restaurant will direct to the Restaurant Detail Page.

Looking for a specific one? -- Search for it!

• Anyone could utilize the Search fearture and navigate the site with key words.
• Indicative Search is here to help.
• Sorting and Filters are available to funnel down the result.

Restaurant Detail Page

• In Restaurant Detailed Page, Overview information is available to all users on the left.
• Business details include Price Range, Cuisine, Description, Location and Business Hours.
• Reservation Form for the restaurant is located to the right and only loggedin user can make rservations.

Restaurant Owners - MyRestaurant List

• Under MyRestaurant Page, business owner can see all listed restaurants.
• Owners can update details or opt to delete the listing with the Manage/Edit button on the right.

Restaurant Owners - New Restaurant Listing Page

• By cliking [List A New Restaurant] button in MyRestaurant page, users will be direct to the Listing Page shown below.
• After completing all requirements of the form, user can sucessfully post a new restaurant on OpenTaste! Congrats!
• If any requirement is not met, submit button would be disabled.

Restaurant Owners - Customer Reservations

• Check customer reservations under tab [See Reservations] in restaurant Detail Page.

Customer -- Reserving on MainPage

• By clicking the red timeslots in Home page, customers can make reservations in the reservation modal.
• Customers can also change date and time in the modal if there is any available spots.

Customer -- MyReservation List

• customers can check their reservations in MyReservation page.
• Only unexpired reservations can be edited/cancelled, expired reservations would not be edited.

Customer -- Leave a Review!

• customers can review on their reservation experiences in MyReservation page.
• Only customers who booked reservation at a particular restaurant can create/edite/cancell reviews.

Running it locally

1. Clone this repository (only this branch)

   git clone https://github.com/alice886/OpenTaste.git

2. Install dependencies

   pipenv install -r requirements.txt

3. Create a .env file based on the example with proper settings for your development environment

4. Make sure the SQLite3 database connection URL is in the .env file

5. Get into your pipenv, migrate your database, seed your database, and run your Flask app

   pipenv shell

   flask db upgrade

   flask seed all

   flask run

Thank you for visiting OpenTaste! Let me know if you have any questions or feebacks and please feel free to connect with me on GitHub =)