My favorites | Sign in
Project Logo
                
Search
for
Updated Dec 01, 2008 by theocharis.athanasakis
Labels: Phase-Implementation
ImplementationDetails  

Data models

User authentication

This will be required first, username and password. Users in the Person table marked with "privileges" as true will be granted access. There may just be a single Person, "gorp" with these credentials to avoid having to add authorized workers in the future.

Checking out equipment

This will be a similar procedure to the original paper form, located at www.cs.grin.edu/~gerpheid/gorp_checkout.doc. For new checkouts, all personal information will be entered. For existing people/users, only p-card will need to be filled in and this will be the unique identifier for that person. Equipment items will be added, perhaps with a drop down menu or just checkboxes, with a quantity (default 1) and optional comment. If the item is not there, then it will be added to the equipment table upon submission.

Viewing current checkouts

This will display all checkouts with a date_returned not set, simply displaying all. They could be filtered or ordered, but that is not really necessary. For each entry, you will be able to update it. This update could be checking it in, providing your name (could be taken from authentication) and any additional late fees or fines. If late fees are entered, then an entry should be made into the fines table with the amount and reference to that Person. The update could alternatively just do something like adjust the comment. This can then just display the updated current checkouts page.

Archived checkouts

This will display all checkouts with a set date_returned, sorted by date. This can just display all of them without filters, because it will not be used very often, but mainly just for the sake of archiving.

Viewing fines

This page will display all fines. We should be able delete entire entries as well as just update the amounts.


Sign in to add a comment
Hosted by Google Code