* 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);
}
