Beispiel #1
0
 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();
 }
Beispiel #2
0
 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);
         }
     }
 }