Progress 1️⃣:
We created roadmap for our project: Link to roadmap https://www.notion.so/98ade335d571433d97e999790c7ad683?v=f54791d06d81453da286384a46619775&pvs=4
Progress 2️⃣:
In the second progress, we have connected the project to the database. For our project, we use a PostgreSQL database. Then we created models in the project: users, product, order, category, payment, section and so on.
Progress 3️⃣:
In the third progress, our team created the main page, the product page, which displays a list of store products from the database, also the registration page.
Progress 4️⃣:
In fourth progress, our team created registration, users can register in the website and their data will appeared and stored in database we also have a branch here - https://github.com/Aktollkynn/GoProject/tree/Report4
PostgreSQl DB, Table: users
+------------+------------+--------+-----+------------+----------------------------------+
| Name | Data type | Length | Key | Not Null? | Default |
+------------+------------+--------+-----+------------+----------------------------------+
| id | integer | | PRI | Yes |nextval('users_id_seq'::regclass) |
| first_name | varchar | 50 | | Yes | |
| last_name | varchar | 50 | | Yes | |
| email | varchar | 355 | | Yes | |
| password | varchar | 50 | | Yes | |
+----------+--------------+------+-----+-------------------+-----------------------------+Progress 5️⃣:
| How Authorization work | --- | --- | --- | --- | --- |
|---|---|---|---|---|---|
/register |
/registerauth |
/login |
/loginauth |
/home_page |
/logout |
| register first | user is registered? | login user | checks email & password to correct | Welcome! | end session |
Overview: In the fifth progression, we created a user login and a product search by name. This way, users who have registered will be able to login to our website. Also on the home page appears information about products directly from the database, namely books; users can search for books by name and see the information.
- Registeration-> Insert data to DB
- Login System -> Users from DB(if exist, otherwise try again)
- Logout -> After session end return to Login page
- Searching -> Any information
Progress 6️⃣:
In the sixth progression, we created validation - firstname, lastname, password, email and hashing password.
- Validation for Register(Upper,small letters, numbers, min 8 symbols)
- Hashing password
Progress 7️⃣:
- Filter prices(max, min)
- Logout session, cookie(without loggin, couldn't open home page even with link)
- User data in home page(shows after login, and his fname, lname)
- Filter prices(max, min)
- Fixed issues
PostgreSQl DB, Table: products
+-------------+------------+--------+-----+------------+---------+
| Name | Data type | Length | Key | Not Null? | Default |
+-------------+------------+--------+-----+------------+---------+
| id | integer | | | Yes | |
| name | varchar | 50 | | Yes | |
| description | varchar | 355 | | Yes | |
| price | integer | | | Yes | |
+-------------+------------+--------+-----+------------+---------+home_page
Progress 8️⃣:
In the eighth progress, we created user profile, and add profile menu, edit, update profile functions
| --- | User profile | --- |
|---|---|---|
/profile |
/edit_profile |
/update_profile |
| view information about user | change information | update inside database |
-
Nav profile menu (Profile page, setting, logout,)
-
View all information about user(fname, lname, email,)
-
Edit all information about user(fname, lname, email, password)
-
Updated scripts( alerts for info such as successfully register, change information)
-
minimalize & clear code, fixed issues
Progress 9: In the ninth progression, we created product detail page and a rating for products. Users can give a rating for each product, and the average product rating will be displayed on the page.
Progress 10: In the tenth progression, we created comments, so users can add comments for products
Midterm 2: We made a page to add and improve comments function, filtering by price and product rating. In addition to comments, the user can give ratings to books. Report - https://docs.google.com/document/d/1rHcuWQ5e4GEV50PFO9r3s69sQSyI9PJ-mJjl5s7glVE/edit