Versions Compared

Old Version 7

changes.mady.by.user Janet Riley Bowker

Saved on

compared with

New Version Current

changes.mady.by.user Janet Riley Bowker

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

The Keys Office.

TECHNICAL

 SVN SVN LOCATION

svn+ssh://svn.mit.edu/pmdashboard

SERVER LOCATION

ppl-r1.mit.edu

DATABASE

Key Tracker runs on Oracle on ppl-r1.mit.edu .

There are three instances: production, development, and test (for unit testing). The testing database data may be eradicated at any time by unit testing scripts, and should not be used for development or any other data you wish to keep.

Here's the TNSNAMES info for dev and test:
keysdev =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=ppl-r1.mit.edu)(PORT=1521))
)
(CONNECT_DATA=(SID=PPLDEV))
)

keystest =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=ppl-r1.mit.edu)(PORT=1521))
)
(CONNECT_DATA=(SID=PPLTEST))
)

Contact Janet Riley Bowker or Peter Maloof for login information.

DEVELOPMENT ENVIRONMENT

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

...

  • CRUD a key
  • CRUD room information
  • CRUD key holder information
  • CRUD department information
  • assign keys
  • transfer keys from one holder to another
  • keyoholder returns key
  • keyholder loses key
  • show key inventory
  • show rooms and keys brief list
  • show key inventory
  • show key holders and their keys
  • show keys assigned to key holders
  • keyoholder returns key
  • keyholder loses key
  • show report list
  • run 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.

PROJECT PLAN

Iterations

1. Hello, World!
GOAL: set up environment, make sure all the pieces are in place ( dev environment, server, databases, apache configured correctly, svn)
DELIVERABLES: Deploy a simple Cake-generated page to server.  Page should do something to confirm it can connect to database.

 ... in progress ...

2. Models and simple controllers: the CRUDS

3. Assign, transfer

4. UI work

5. Reports 

This will be an agile-flavored project, using several short iterations with visible results at the end of each. The order of iterations may change.

Iterations and tasks are broken down here .?? Visit user for a test drive, get some feedback on the UI