The inventory system is to maintain an inventory of all devices and tracks borrowable devices that are assigned to a user. The inventory will be maintained by the admin.
An inventory-table contains the entire Inventory info for all devices, when Admin set devices is allowed to Borrow by - Add to Borrowing Process (Yes/ No); then system should add that device to borrowable’s tables. Admin can change a device anytime to update the status to borrowable items (yes/no).
If devices are allowed to borrow, then it will be available for any user in the system to borrow devices for period of time.
Device is borrowed by one user at a time;
User will have the following:
• A User will be assigned with few Devices permanently.
• A User can borrow devices from inventory for period of time. (This will be maintained by Check in/out process).
• If admin set the Devices to: Add to Borrowing Process (Yes/ No) – Yes; then device should be available for user borrow it.
• If admin set the Devices to: Add to Borrowing Process (Yes/ No) – NO; then that Device is not available for Borrowing Process.
• Keep a field in borrowing table to maintain the devices availability: If user borrow an item; the item status should be set to “Not Available”; if the item is available then it should be “Available” status.
• If item is disabled by Admin from inventory section; the Item should not be available to anyone to view or borrow.
• Admin will be able to edit all the fields.
• Sort function with the fields that are available in the admin table view.
• Export Function where ever a table view for admin only: Admin will have an Export Function to export as (Excel format - BIFF 8 (.xls) Excel 95 and above, Office Open XML (.xlsx) Excel 2007 and above and CSV
Please review the attached documents.
QR Code library & PHP Excel export library are available.
10 freelancers are bidding on average $471 for this job
Hi Thanks for posting your [login to view URL] have reviewed your job details and [login to view URL] can do that job in a normal [login to view URL] have great experience of preparing Complete Scope,Complete documentation,attractive design ,Webdeve More