Inventory Admin System (IAS)
Working Demo: http://zachgosling.com/inv-master username: [email protected] password: 123456
Based entirely on CakePHP This is a simple inventory system built to keep track of cable modems/routers/gateways and laptops.
Key Features
- jQuery inventory page lists all devices and laptops and is filterable/searchable from any field
- Mac address for each item integrates nicely with barcode scanner to filter by mac
- Checkouts allow users to checkout one or multiple items for extended periods of time
- Ability to import devices/models/vendors from csv
- View count of devices for each vendor
- View count of devices for each model
- View count of each model in each location
- Uses cake php 2.3
Things that need to be added to be an awesome inventory admin system -Checkout multiple items at a time -Vendors page needs to be formated to suite all the info better -Delete multiple items at a time
- Copy directory to webserver
- Update default database settings in inv/app/Config/database.php
- Install databaase from inv/app/Config/Schema/inventory.sql
- Go to inv in a web browser and use the following credentials to login: username: [email protected] password: 123456
- Enjoy!
Important things to note:
- CakePHP is a MVC framework so further development questions can be directed at the CakePHP comunity
- Referenced http://datatables.net/development/server-side/php_cake to help format Devices/Laptops pages
- Referenced http://www.willis-owen.co.uk/2011/11/dynamic-select-box-with-cakephp-2-0/ to help make the dependent select boxes in the add/edit device view
- Referenced http://stackoverflow.com/questions/15301055/how-to-print-count-of-unique-values-in-cakephp to build the counts of devices into the vendors page
- Referenced http://stackoverflow.com/questions/15119680/cakephp-combine-input-values-to-create-hidden-name-input to create the names from multiple fields
- Referenced http://stackoverflow.com/questions/15098117/cakephp-pass-product-id-value-to-checkout-add-page to add chekout button in devices/laptops index page