* group_name [STRING] The name of the group * group_desc [STRING] The description of the group */ $Group = new RowManager_GroupManager(); $Group->dropTable(); $Group->createTable(); /* * GroupAssociation Table * * Contains the relationship between the group and the person. * * groupAssocation_id [INTEGER] ID of the association between group and person * group_id [INTEGER] ID of the group * person_id [INTEGER] ID of the person */ $GroupAssociation = new RowManager_GroupAssociationManager(); $GroupAssociation->dropTable(); $GroupAssociation->createTable(); /* * ScheduleBlocks Table * * Object that stores information related to a person's schedule * * scheduleBlocks_id [INTEGER] primary key * schedule_id [INTEGER] foreign key to the meta-data associated with the schedule * scheduleBlocks_timeblock [INTEGER] time blocks of a person's schedule */ $ScheduleBlocks = new RowManager_ScheduleBlocksManager(); $ScheduleBlocks->dropTable(); $ScheduleBlocks->createTable(); /*
function getGroupData() { $groupAssociationManager = new RowManager_GroupAssociationManager(); $groupAssociationManager->setPersonID($this->personID); $groupAssociationArray = array(); //Go through the row returned $groupList = new ListIterator($groupAssociationManager); $groupList->setFirst(); $timeBlock = -1; while ($groupList->moveNext()) { //get the time block in that row $groupsManager = $groupList->getCurrent(new RowManager_GroupAssociationManager()); //save the timeblock to the array and keep looping to get all of them $groupAssociationArray[] = $groupsManager->getGroups(); } return $this->template->set('groupAssociationArray', $groupAssociationArray); }