paulinaurbas / bd-car-dealerships-managment-system Goto Github PK

As a seller, I want to send the car to the service to add an ordered feature or to fix car issues

Customers sometimes want custom features in their cars. Sometimes cars have issues when they came from the manufacturer and we need to fix them before the selling. We need to store clients' data to be able to contact them after the service finish

Acceptance Criteria

• database stores cars which need to be serviced or have not mounted features
• database stores clients' contact data
• database stores cars linked with clients
• seller after listing cars can add features ordered by the client to be mounted by the serviceman or mark the car as "damaged" using frontend
• seller can create a registered client with their contact data using frontend
• seller after listing cars can link the client to the ordered car using frontend
• server can update cars with their "need to be serviced" status and the ordered features in the database
• server can create and update clients contact data in the database
• server can link clients to their ordered cars in the database
• README is updated with a tutorial on how to add client, add ordered features to the existing car and link client to the ordered car

As a manager, I want to have charts representing:

• how much income the company generates presented by weeks
• which car brands do we sell the most
• how many cars we sell in comparison to how many cars we buy
• what percentage of cars need to be serviced before selling
• how many workers of different types there is hired in the company

These are the basic things I need to do while managing the company

Acceptance Criteria

• manager can see all mentioned charts using frontend
• server can prepare data necessary for charts using the database
• README is updated with a tutorial on how to open the manager tab with all charts

Reproduce:

1. Add order
2. Create new order

Things to do:

1. More info about client: name and surname
2. More info about car: VIN, model and brand

As an administrator, I want to add multiple cars to the database with ease using *.csv file provided by the manufacturer

It would make my life easier because cars are arriving from the manufacturer in large numbers and adding them manually could be pain

Acceptance Criteria

• there is an example *.csv file with cars to add prepared
• administrator can update the database by dragging and dropping *.csv files onto the frontend
• server can update multiple entities located in the *.csv file
• README is updated with a tutorial on how to drag and drop a *.csv file to the application to add data to the database and how to see updated data

Reproduce:

1. Login as Admin
2. Add car to the data base

Things to do:

• group list by salon name
• add new car by create new -> salon is ID, we want salon name

Please add status dictionary (dropdown) with car status.
[Frontend] If status field is enty remove possibility to add new order

Story

As a seller, I want to list all the cars we have with all their features and mark them as "sold" when they are sold

These are the basic things I need to do while selling the cars

Acceptance Criteria

• database stores cars with features like radio
• server can fetch all not sold cars and their features from the database
• seller can list all not sold cars with their features using frontend
• seller can mark listed cars as "sold" using frontend
• server can update the database with sold cars
• README is updated with a tutorial on how to run the project, list cars and mark them as "sold"

As a serviceman, I want to list all of the cars needed to be serviced or without the ordered features and mark them as "done" when it's done

These are the basic things I need to do while servicing the cars

Acceptance Criteria

• database stores cars which need to be serviced or have not mounted features
• server can fetch all cars which need to be serviced or have not mounted features from the database
• serviceman can list all mentioned cars with their issues and not mounted features using frontend
• serviceman can mark listed cars as "done" using frontend
• seller can list cars marked as "done" using frontend
• server can update the database with the serviced and ready to be sold cars
• README is updated with a tutorial on how to list cars and mark them as "done" from the serviceman perspective and how to list cars marked as "done" from the seller perspective

@franpog859 EDIT:
As a user, I want see help for the application functionalities

I suggest to brainstorm on for which functionalities we want to have a help page

Acceptance Criteria

• user can open help pages for two application functionalities using frontend
• README is updated with a tutorial on how to open help pages

Reproduce

1. Edit order

Things to do

1. Editing date is not possible

Reproduce

1. Login as admin
2. See serviceman adds

To do

1. Admin can see what the serviceman added

As a user, I want to see the app with consistent and beautiful UI!

Acceptance Criteria

• favicon is added to the project
• the main banner is created
• UI is refactored and looks wonderful
• README with the tutorials is updated if anything was changed

EDIT:

@paulinaurbas : can we add help page, error prevention and frontend handling error to this story?

• the help page is added
• frontend errors are handled properly without breaking the application

Reproduce:

1. Add new feature (by create new)

To do:

1. Display the car name, not VIN

As a seller, I want to give a hint to the client who wants to buy a car. I need to create a client profile with all their preferences and get a matching car given by the system

We want to store clients profiles and be able to help them with the decision of buying

Acceptance Criteria

• database stores clients' data with their preferences
• seller can update clients' profile with the preferences using frontend
• seller can get a hint for the client based on their preferences using frontend
• server can update clients' data in the database
• server can find the best matching car based on the client's preference
• README is updated with a tutorial on how to add clients' preferences and get a hint

As an user I want to log into the system using my credentials and have correct permissions set up

This is important to avoid security issues and unwanted things happen

Acceptance Criteria

• database stores users with their credentials
• user has a specific role (e.g. seller) stored in the database
• user can log into the application using credentials
• README is updated with a tutorial on how to log into the application using credentials

Story

As an administrator, I want to have CREATE, READ, UPDATE and DELETE access to all tables in the database and also an easy to use, command-like user interface to do manage it

These are the basic things I need to do while administrating the database

Acceptance Criteria

• database stores example data like cars and workers
• administrator can run every SQL command via frontend to manipulate the database
• README is updated with a tutorial on how to open administrator panel and run example SQL query

Change labels names:

• create new order
• create new issue
• client details

Please add grant permissions

EDIT:
Create final version of the project report

Acceptance Criteria
The report consists of:

• Project assumptions, scenarios, flow diagrams for two selected scenarios, logical database model, physical database model
• Selected tools
• Requirements
• External specification description 2 choices of the function of efficiency
• Internal specification, description of 2 functions
• Graph report
• Conclusions

Links
https://docs.google.com/document/d/1YVeY-L0PpFnggcVdLT8gSX184m_8jzZs_wUoNOCvgCY/edit?usp=sharing

@franpog859 EDIT:
As a manager, I want to export all charts to the consistent report in *.PDF format

Acceptance Criteria

• manager can export all charts to *.PDF using one button in the frontend
• README is updated with a tutorial on how to export charts to *.PDF

As a seller, I want to see my filtering changes in the Salon tab hot reloading. It will be easier to see if everything is typed correctly and I will see the results faster

Acceptance Criteria

• car list in the Salon tab reloads whenever some filter text field is changed
• README with the tutorial on how to filter cars in the salon is updated