...
PHP 5.2
Cake 1.1.15.x (the latest stable, non 1.2 version)
Oracle - whatever version Ops currently recommends
Apache - whatever version Ops currently recommends
FUNCTIONALITY
The functionality will match the current system. Functionality is fully described in the Key System User Guide. Most functionality is CRUD - create, read, update, delete. Functionality includes:
- CRUD a key
- CRUD room information
- CRUD key holder information
- CRUD department information
- assign keys
- transfer keys from one holder to another
- show key inventory
- show rooms and keys brief list
- show key inventory
- show key holders and their keys
- show keys assigned to key holders
- show reports
We need more information about reports. The user guide names nine reports, but doesn't give a detailed description of what they show. We may be able to copy the SQL from the existing system.