Class CompDB

Description

A minimal Database abstraction layer.

This class offers a very minimal database abstraction layer. CompInaBox is designed to run on top of the PostGreSQL Relational DataBase Management System and requires many of its features. Therefore database independence wasn't a huge concern. However having a single place to funnel all queries through is useful for future instrumentation work.

Located in /include/classes/database/CompDB.inc (line 20)

DB
   |
   --CompDB
Direct descendents
Class Description
 class StatsDB ************************************************************
Variable Summary
 mixed $lastUsed
Method Summary
 CompDB CompDB (mixed $dbname, mixed $user, mixed $pass)
 void assignCompNumbers (mixed $method, [mixed $starting = 100], [mixed $ending = 999])
 void assignCompNumbersAffil ([mixed $starting = 100], [mixed $ending = 999])
 void assignCompNumbersAlpha ([mixed $starting = 100], [mixed $ending = 999])
 void buildAffilLut ()
 void buildPeopleLut (mixed $affilLut)
 void calculatePersonTotal (mixed $peopleid, mixed $deadline)
 void checkForCentralAffiliation (mixed $fullName, [mixed $shortName = ""])
 void determineDeadlineMet (mixed $peopleid)
 void getAffilListChoicesSelect (mixed $chosen)
 void getAgeCategories (mixed $chosen, [mixed $selName = "age"])
 void getAgeCategoriesSelect (mixed $chosen, [mixed $selName = "age"])
 void getAllEmail ()
 void getAllTBAEmail ()
 void getAvgEntries (mixed $level, [mixed $style = "All"])
 void getHost ()
 void getMOTD ([mixed $label = "Main"])
 void getNextTBA ()
 void getNumCouples ()
 void getNumEntries (mixed $db)
 void getPackages (mixed $chosen, [mixed $selName = "package"])
 void getPackagesSelect (mixed $chosen, [mixed $selName = "package"])
 void getPersonPaid (mixed $peopleid)
 void getPersonWaived (mixed $peopleid)
 void getSelectMembers (mixed $affil, [mixed $chosen = "0"])
 void getStatsAffilListing (mixed $affilLut, mixed $id, mixed $fullname)
 void getStatsEventListing (mixed $affilLut, mixed $peopleLut, mixed $id, mixed $fullname)
 void getStatsFooter ()
 void getStatsHeader (mixed $title)
 void getStatsSummary ()
 void getStatus ()
 void getTotalOwed ([mixed $orgid = ""])
 void getTotalPaid ([mixed $orgid = ""])
 void getTotalWaived ([mixed $orgid = ""])
 void nameCollisionTable (mixed $people, mixed $formVars, mixed $target, [mixed $prefix = ""])
 void personConflicts (mixed $person, [mixed $includeEmail = TRUE], [mixed $exact = FALSE])
 void produceRegistrantArray (mixed $affilID)
 void rebuildCategories (mixed $affilLut, mixed $peopleLut)
 void rebuildCategorySummary (mixed $affilLut, mixed $peopleLut, mixed $style, mixed $level)
 void rebuildEvents (mixed $affilLut, mixed $peopleLut)
 void rebuildPeople (mixed $affilLut, mixed $peopleLut, mixed $role)
 void rebuildSchools (mixed $affilLut)
 void rebuildStats ()
 void retrieveAffilsRegistrations (mixed $fullName, [mixed $shortName = ""])
 void setMOTD (mixed $message, [mixed $label = "Main"])
 void setStatus (mixed $status)
Variables
mixed $lastUsed (line 22)

Redefined in descendants as:

Inherited Variables

Inherited from DB

DB::$db
DB::$dbname
DB::$lastOID
DB::$password
DB::$user
Methods
Constructor CompDB (line 33)
CompDB CompDB (mixed $dbname, mixed $user, mixed $pass)
assignCompNumbers (line 1726)
void assignCompNumbers (mixed $method, [mixed $starting = 100], [mixed $ending = 999])
assignCompNumbersAffil (line 1759)
void assignCompNumbersAffil ([mixed $starting = 100], [mixed $ending = 999])
assignCompNumbersAlpha (line 1735)
void assignCompNumbersAlpha ([mixed $starting = 100], [mixed $ending = 999])
buildAffilLut (line 1034)
void buildAffilLut ()

Redefined in descendants as:
buildPeopleLut (line 1057)
void buildPeopleLut (mixed $affilLut)

Redefined in descendants as:
calculatePersonTotal (line 305)
void calculatePersonTotal (mixed $peopleid, mixed $deadline)
checkForCentralAffiliation (line 1964)
void checkForCentralAffiliation (mixed $fullName, [mixed $shortName = ""])
determineDeadlineMet (line 220)
void determineDeadlineMet (mixed $peopleid)
getAffilListChoices (line 564)
void getAffilListChoices ()
getAffilListChoicesSelect (line 605)
void getAffilListChoicesSelect (mixed $chosen)
getAgeCategories (line 682)
void getAgeCategories (mixed $chosen, [mixed $selName = "age"])
getAgeCategoriesSelect (line 718)
void getAgeCategoriesSelect (mixed $chosen, [mixed $selName = "age"])
getAllEmail (line 521)
void getAllEmail ()
getAllTBAEmail (line 535)
void getAllTBAEmail ()
getAvgEntries (line 165)
void getAvgEntries (mixed $level, [mixed $style = "All"])
getHost (line 51)
void getHost ()
getIncompleteReg (line 491)
void getIncompleteReg ()
getMOTD (line 502)
void getMOTD ([mixed $label = "Main"])
getNextTBA (line 1020)
void getNextTBA ()
getNumAffiliations (line 70)
void getNumAffiliations ()
getNumCompetitors (line 93)
void getNumCompetitors ()
getNumCouples (line 118)
void getNumCouples ()
getNumEntries (line 139)
void getNumEntries (mixed $db)
getPackages (line 752)
void getPackages (mixed $chosen, [mixed $selName = "package"])
getPackagesSelect (line 800)
void getPackagesSelect (mixed $chosen, [mixed $selName = "package"])
getPersonPaid (line 287)
void getPersonPaid (mixed $peopleid)
getPersonWaived (line 296)
void getPersonWaived (mixed $peopleid)
getSelectMembers (line 839)
void getSelectMembers (mixed $affil, [mixed $chosen = "0"])
getStatsAffilListing (line 1174)
void getStatsAffilListing (mixed $affilLut, mixed $id, mixed $fullname)
getStatsEventListing (line 1148)
void getStatsEventListing (mixed $affilLut, mixed $peopleLut, mixed $id, mixed $fullname)
getStatsFooter (line 1139)
void getStatsFooter ()
getStatsHeader (line 1095)
void getStatsHeader (mixed $title)
getStatsSummary (line 1121)
void getStatsSummary ()

Redefined in descendants as:
getStatus (line 38)
void getStatus ()
getTotalOwed (line 384)
void getTotalOwed ([mixed $orgid = ""])
getTotalPaid (line 376)
void getTotalPaid ([mixed $orgid = ""])
getTotalWaived (line 367)
void getTotalWaived ([mixed $orgid = ""])
helper_getAgeCats (line 643)
void helper_getAgeCats ()
helper_getFeeCats (line 657)
void helper_getFeeCats ()
nameCollisionTable (line 938)
void nameCollisionTable (mixed $people, mixed $formVars, mixed $target, [mixed $prefix = ""])
personConflicts (line 862)
void personConflicts (mixed $person, [mixed $includeEmail = TRUE], [mixed $exact = FALSE])
produceRegistrantArray (line 1799)
void produceRegistrantArray (mixed $affilID)
rebuildCategories (line 1555)
void rebuildCategories (mixed $affilLut, mixed $peopleLut)
rebuildCategorySummary (line 1646)
void rebuildCategorySummary (mixed $affilLut, mixed $peopleLut, mixed $style, mixed $level)
rebuildEvents (line 1521)
void rebuildEvents (mixed $affilLut, mixed $peopleLut)
rebuildPeople (line 1226)
void rebuildPeople (mixed $affilLut, mixed $peopleLut, mixed $role)
rebuildSchoolInclude (line 1423)
void rebuildSchoolInclude ()
rebuildSchools (line 1453)
void rebuildSchools (mixed $affilLut)
rebuildStats (line 1076)
void rebuildStats ()
retrieveAffilsRegistrations (line 1984)
void retrieveAffilsRegistrations (mixed $fullName, [mixed $shortName = ""])
setMOTD (line 514)
void setMOTD (mixed $message, [mixed $label = "Main"])
setStatus (line 45)
void setStatus (mixed $status)

Inherited Methods

Inherited From DB

 DB::DB()
 DB::commit()
 DB::getDBName()
 DB::getDBpass()
 DB::getDBuser()
 DB::getLastOID()
 DB::helper_limitOffset()
 DB::helper_queryToArray()
 DB::helper_queryToArrayCategories()
 DB::helper_queryToSimpleArray()
 DB::helper_singleValueQuery()
 DB::query()
 DB::rollback()
 DB::startTransaction()

Documentation generated on Tue, 25 Apr 2006 13:00:24 -0400 by phpDocumentor 1.3.0RC3