Difference between revisions of "FGdb"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
==Sub-projects== | ==Sub-projects== | ||
| − | * Contacts -- Anything relating to tracking volunteers, donors, customers, or other contact information for people '''or organizations''' in the database. | + | * Contacts -- Anything relating to tracking volunteers, donors, customers, or other contact information for people '''or organizations''' in the database. -- Martin Chase is working on these related projects. |
** Volunteer tracking and volunteer hours maintenance | ** Volunteer tracking and volunteer hours maintenance | ||
** Membership program tracking (people making regular cash contributions to Free Geek) | ** Membership program tracking (people making regular cash contributions to Free Geek) | ||
| Line 23: | Line 23: | ||
* Reports -- Anything that only requires read access to the database. Some report groups are: | * Reports -- Anything that only requires read access to the database. Some report groups are: | ||
| − | ** volunteer reports -- who's in what program, who's waiting to get in, where are they in the process, etc. | + | ** volunteer reports -- who's in what program, who's waiting to get in, where are they in the process, etc. -- Douglas Howard is working on this. |
** gizmo reports -- how many gizmos of which types were received, recycled, etc. | ** gizmo reports -- how many gizmos of which types were received, recycled, etc. | ||
| + | |||
| + | * Data Integrity and Cleaning -- Finding old problem in the data itself, removing them, and preventing their reoccurance. This is SQL intensive and less about PHP. -- David Jencks and Richard Seymour are working on this. | ||
Revision as of 19:46, 30 November 2004
Description
This is PHP code ( http://www.php.net/ ) that talks to a PostgreSQL database ( http://www.postgresql.org/ ). It is responsible for tracking all our gizmos and their statuses, all our volunteers and the hours they've worked, all our receipts for donations and sales, and more. Everything runs in a web browser.
Project Status
This code is in a constant state of change. There's always work needed.
Queue
The RT queue for this project is called FGdb.
Sub-projects
- Contacts -- Anything relating to tracking volunteers, donors, customers, or other contact information for people or organizations in the database. -- Martin Chase is working on these related projects.
- Volunteer tracking and volunteer hours maintenance
- Membership program tracking (people making regular cash contributions to Free Geek)
- Sales receipts (we sell stuff to customers)
- Donation receipts (donors give us stuff)
- Gizmos -- Anything relating to tracking gizmos in the database. This includes:
- new gizmo entry (at receiving)
- editing existing gizmos
- cloning of several similar gizmos at the same time
- System checkout -- The process of tying a system's component gizmos to it, assigning an adopter to it, assigning an appropriate value and status to each gizmo, and attributing (in hours) the "value" of the system. This happens when a system is sent to the store, adopted, or granted out.
- Reports -- Anything that only requires read access to the database. Some report groups are:
- volunteer reports -- who's in what program, who's waiting to get in, where are they in the process, etc. -- Douglas Howard is working on this.
- gizmo reports -- how many gizmos of which types were received, recycled, etc.
- Data Integrity and Cleaning -- Finding old problem in the data itself, removing them, and preventing their reoccurance. This is SQL intensive and less about PHP. -- David Jencks and Richard Seymour are working on this.