You are tasked with designing, building and implementing an interactive web portal. Start with a landing page that allows users to self-register with e-mail authentication and password reset functionality. Registered users will have the ability to access user specific pages/menus. The purpose of the portal is to allow customers to search the community database for biospecimens they require for research studies. Additionally, customers have the ability to enter their own inventory of biospecimens onto the website, therefore further populating the database with usable biospecimens for research studies. Therefore, customers can be both consumers and suppliers of biospecimens to the community database.
When customers are searching for biospecimens in the database, they are able to filter all fields within the biospecimen data table. Records they select are added to their shopping cart.
Before checking-out, customers are required to enter their “Study” data before they are able to check-out. This study data is published to another table and is linked to the order number. If not all study data is completed, the order will still progress, but it cannot be completed closed out until this data is completed.
Once they check out, a series of workflows and triggers will automate the process of procuring the order for the customer. The orders are then passed to the admin team to begin the fulfilment process. Once the order is ready for shipment, charges will be posted to the customer’s order. Each individual biospecimen in the customers shopping cart has a price of $5 per record. They will receive an e-mail notification asking them to login and submit payment. Once payment is received from the customer, admin team will ship the order to the customer and the order will be fulfilled.
Admins should have access to create, read, update and delete all records in every table including: users, biospecimens, orders, and study. Reports and dashboard functionality with all pieces of the website including all tables to track user registration, biospecimens in database, total orders, total closed sales, etc.