function run()
{
$name = CRM_Utils_Request::retrieve('name', 'String', $this, true);
$day = CRM_Utils_Request::retrieve('day', 'String', $this, true);
$sess = CRM_Utils_Request::retrieve('sess', 'String', $this, true);
$sql = "\nSELECT c.display_name, c.id\nFROM civicrm_contact c,\n civicrm_value_extended_care s\nWHERE s.name = %1\nAND s.term = %2\nAND s.day_of_week = %3\nAND s.session = %4\nAND s.has_cancelled = 0\nAND s.entity_id = c.id\n";
require_once 'SFS/Utils/ExtendedCare.php';
$params = array(1 => array($name, 'String'), 2 => array(SFS_Utils_ExtendedCare::getTerm(), 'String'), 3 => array($day, 'String'), 4 => array($sess, 'String'));
$dao = CRM_Core_DAO::executeQuery($sql, $params);
$values = array();
while ($dao->fetch()) {
$values[] = array('contact_id' => $dao->id, 'display_name' => $dao->display_name, 'url' => CRM_Utils_System::url('civicrm/profile/view', "reset=1&gid=4&id={$dao->id}"));
}
$this->assign_by_ref('values', $values);
$classDetails = array('name' => $name, 'time' => SFS_Utils_ExtendedCare::getTime($sess), 'day' => $day);
$this->assign($classDetails);
parent::run();
}
function browse($action = null)
{
$this->assign('editClass', false);
$permission = false;
if (CRM_Core_Permission::check('access CiviCRM')) {
$this->assign('editClass', true);
$permission = true;
$addClassUrl = CRM_Utils_System::url(CRM_Utils_System::currentPath(), 'reset=1&action=add');
$this->assign('addClass', $addClassUrl);
}
require_once 'SFS/Utils/ExtendedCare.php';
if ($permission) {
$classInfo = SFS_Utils_ExtendedCare::getClassCount(null, true, $this->_term);
}
$activities = array();
$activities =& SFS_Utils_ExtendedCare::getActivities(null, CRM_Core_DAO::$_nullObject, true, $this->_term);
$actionEnable -= CRM_Core_Action::ENABLE + 1;
$values = array();
foreach ($activities as $day => &$dayValues) {
$values[$day] = array();
foreach ($dayValues as $session => &$sessionValues) {
foreach ($sessionValues['details'] as $id => &$idValues) {
if ($permission) {
$idValues['action'] = CRM_Core_Action::formLink(self::actionLinks(), $actionEnable, array('id' => $idValues['index']));
}
if ($permission && isset($classInfo[$idValues['id']])) {
$name = urlencode($idValues['name']);
$url = CRM_Utils_System::url('civicrm/sfschool/extended/detail', "reset=1&name={$name}&day={$idValues['day']}&sess={$idValues['session']}");
$idValues['num_url'] = $url;
$idValues['num_students'] = $classInfo[$idValues['id']]['current'];
}
$idValues['session'] = SFS_Utils_ExtendedCare::getTime($idValues['session']);
$values[$day][] =& $idValues;
}
}
}
$this->assign('schedule', $values);
if ($permission) {
$disableActivities = array();
$disableActivities =& SFS_Utils_ExtendedCare::getActivities(null, CRM_Core_DAO::$_nullObject, false);
$actionDisable -= CRM_Core_Action::DISABLE + 1;
$disable = array();
foreach ($disableActivities as $day => $valueDay) {
$values[$day] = array();
foreach ($valueDay as $session => $valueSession) {
foreach ($valueSession['details'] as $id => $valueId) {
$valueId['action'] = CRM_Core_Action::formLink(self::actionLinks(), $actionDisable, array('id' => $valueId['index']));
if (isset($classInfo[$valueId['id']])) {
$name = urlencode($valueId['name']);
$url = CRM_Utils_System::url('civicrm/sfschool/extended/detail', "reset=1&name={$name}&day={$valueId['day']}&sess={$valueId['session']}");
$valueId['num_url'] = $url;
$valueId['num_students'] = $classInfo[$valueId['id']]['current'];
}
$valueId['session'] = SFS_Utils_ExtendedCare::getTime($valueId['session']);
$disable[$day][] = $valueId;
}
}
}
if (!empty($disable)) {
$this->assign('disableActivities', $disable);
}
}
}
