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

• 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 -- who's in what program, who's waiting to get in, where are they in the process, etc.
  • gizmo reports -- how many gizmos of which types were received, recycled, etc.