bertearazvan/chemical_industry

Chemical industy A/S project

chemical_industry's Issues

createForgotPasswordPages

The reset password form flow is at it follows:

• the user presses on forgot password and it is being redirected to a page that contains a form with one input for email.
• We send the reset password email to the specified email where the user will have a button/link to click and to reset the password.
• The user is being redirected to the page where we have a form that contains two fields: newPassword and confirmNewPassword.

Therefore we have to create two components:

• Reset password form where he inputs the email.
• Reset password form where he inputs the new password.
• The design for these pages.

pickupPageForWorker

Here we have the page where the workers land on after selecting pickup on the main page.

We have to create a stepper component with 3 steps:

• Checking pickup - inputs the delivery number.
• View the stock overview for that specific pickup.
• Confirm the pickup and view the "receipt"

Steps:

• Build the stepper component that fetches the right endpoint at the right time.
• Apply the styling on this component

createTableForDisplayingAllDeliveries

Create this component in order to have an overview of all the deliveries.

It would be great if we could filter data based on the following criteria :

• Status type
• Dates
• Company for which the delivery was made
• type of chemical
• Drivers
• Trucks

This component is optional but it is nice to have.

Steps:

• Create the table to display all the info
• Create a filtering component that can handle multiple choices
• Bind the filtering with the table
• Apply the design

implementEscapeHTMLForAllTheForms

We want to prevent SQL Injection attacks, therefore it would be nice to use escape-html npm package for our endpoints.

createWorkerLandingPage

Create the page component that contains the useful buttons for a warehouse & depot worker.
For warehouse workers:

• Delivery
• Pickup
• Storage

For warehouse workers:

• Delivery
• Pickup
• Warehouses overview with storage
• Button to raise a job/create a delivery/create pickup

Steps:

• Create the component and conditionally render the right buttons for different types of users.
• Apply the style

createDesignForLoginPage

Create the design of the current login page.

createTheAuditTable

I currently know that the only way to build triggers is to use knex.raw(). That is not really an easy way to go and I am open to other suggestions :D

raiseJobPageForDepotWorker

This component is available for the depot worker who can raise different jobs depending on the type of delivery.

The user will be redirected to a form where he can select the following stuff:

• if it is a delivery or a pickup
• the company for which this delivery is made
• the drivers that are assigned on this delivery
• the truck used for this delivery
• to/from the depot/warehouse we send this delivery

Steps:

• Create the component and display the right options.
• Create the styling for it

writingDatabaseSeeds

implementSessionOrJWTForTheBackend

We have to implement some form of a session in our backend.

upcoming deliveries for the day.

Based on the user type we return the deliveries and pickups for the following 24h

initiate a delivery with status 3 and do a check based on depots for storage, and then based on warehouses storage and regulations.

insert ticket number and retrieve the details for that specific delivery. Based on the type of user we return the delivery stock.

For a warehouse worker, we return more data for the receipt of confirmation. We build a separate route for confirming the delivery for the warehouse worker,

*4 possibilities:

• depot worker delivery
• depot worker pickup
• warehouse worker delivery
• warehouse worker pickup

Steps

• delivery
• pickup

Alert fire brigade if more than 15 kt of chemical A is present in a depot.

ImplementCORSForTheBackendAndFrontend

Implement cors()

deliveryPageForWorker

Here we have the page where the workers land on after selecting delivery on the main page. Based on the user type (depot or warehouse) we display conditional data.

We have to create a stepper component with 3 steps:

• Checking pickup - inputs the delivery number.
• View the stock overview for that specific pickup.
• Confirm the pickup and view the "receipt"

Steps:

• Build the stepper component that fetches the right endpoint at the right time.
• Apply the styling on this component

cheManagerFirstLandingPage

Build the first landing page that appears on the XD prototype

• Build the page and style it

createUsersCrudRoutes

We have to create the backend routes for:

• Create
• Read
• Update
• Delete

storagePageForWorker

Here we have the page where the worker lands on after clicking Storage on the main page. Based on the user type (storage/depot) we have to either show one warehouse or to be able to select from all of the warehouses in the depot for the depot worker.

It is being displayed the current storage for that specific warehouse based on the different chemicals.

Steps:

• Build the component
• Apply the styling on the component

createWarehouseRoute

implementTransactionForDeliveries

We have to implement some form of transaction in order to make sure that when the deliveries are not successful, we still have space in our warehouses to store the chemicals when they come back.

implementCSRFProtectionToOurForms

Let's try and implement CSRF protection for our forms.

upcomingDeliveriesForTheDay

This feature helps the workes have an overview of the upcoming deliveries of that day.

The table should include a list of:

• The deliveries for the day
• Every delivery should include the time
• Every delivery should include the status
• Every delivery should include the chemicals
• Every delivery should include the company the delivery is for
• Every delivery should have the warehouse/s associated with it

Depending on if the user is a depot or warehouse worker we display the needed data.

Steps:

• Create the component and display all the data needed
• Conditionally render the data based on the user type
• Apply the design