FGdb

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.
  • 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.
  • 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.