Difference between revisions of "FGdb"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| + | ==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. | 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. | This code is in a constant state of change. There's always work needed. | ||
| − | The RT queue for this project is called FGdb. | + | ==Queue== |
| + | The [[RT]] queue for this project is called FGdb. | ||
| + | |||
| + | ==Sub-projects== | ||
| + | * People -- Anything relating to tracking volunteers, donors, customers, or other contact information for people '''or organizations''' in the database. This includes: | ||
| + | ** 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 | ||
| + | ** gizmo reports | ||
Revision as of 13:34, 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
- People -- Anything relating to tracking volunteers, donors, customers, or other contact information for people or organizations in the database. This includes:
- 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
- gizmo reports