Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.