Scribd
Upload
4 views

Assignment - PHP React

Uploaded by

sumitkr.hono
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views

Assignment - PHP React

Uploaded by

sumitkr.hono
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Create an Inventory Management System

Assumption:

• Catalogue of the products and their current inventory (balance) status are available as
DB tables

Tasks to Complete:

• Define the Data Structure for


o Product Catalogue
o Product Inventory Status
o Consumer (Person/Department/Client Business Unit)
o Note: These tables need to be filled in directly via SQL bulk uploads. No UI
required
• Create Screens (UI) for
o Record Issue Transaction (Sale entry)
▪ Search and select a Consumer
▪ Search and select a product
▪ Display available inventory (stock units)
▪ Input no of units to be issued
▪ Submit to create an Issue/Sale Transaction record
o Record Return Transaction (Sale Return entry)
▪ Search and select a Consumer
▪ List the products (with stock units) issued to the consumer in last 30
days
▪ Select a product to return
▪ Input no of units to be return
▪ Submit to create a Return/Sale Return Transaction record
o Prepare a Transaction report for a date range
▪ Input a Date Range
▪ Find and list all transactions matching with the given date range (both
start and end dates are inclusive in the report)
▪ Enable filter options for
• A Product, a Consumer, a Transaction Type (Issue vs Return)
• Ensure
o Input Validations are in place
o Transactions are recorded with date & time
o Product Inventory Status is kept up to date with every transaction

Technology Stack

• PHP for the backend services


• React or PHP for the frontend (UI)
• MySQL for the database
• Optional:
▪ Use CodeIgniter framework

You might also like