. /** * This file contains the cohort membership badge award criteria type class * * @package core * @subpackage badges * @copyright 2016 onwards Catalyst IT {@link https://www.catalyst.net.nz/} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later * @author Eugene Venter */ defined('MOODLE_INTERNAL') || die(); require_once($CFG->dirroot.'/cohort/lib.php'); /** * Badge award criteria -- award on cohort membership * * @package core * @subpackage badges * @copyright 2016 onwards Catalyst IT {@link https://www.catalyst.net.nz/} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later * @author Eugene Venter */ class award_criteria_cohort extends award_criteria { /* @var int $criteriatype Criteria [BADGE_CRITERIA_TYPE_COHORT] */ public $criteriatype = BADGE_CRITERIA_TYPE_COHORT; /* @var string $required_param Required form param */ public $required_param = 'cohort'; /* @var array $optional_params Optional form params */ public $optional_params = array(); /** * Get criteria details for displaying to users * @param string $short Print short version of criteria * @return string */ public function get_details($short = '') { global $DB, $OUTPUT; $output = array(); foreach ($this->params as $p) { $cohortname = $DB->get_field('cohort', 'name', array('id' => $p['cohort'])); if (!$cohortname) { $str = $OUTPUT->error_text(get_string('error:nosuchcohort', 'badges')); } else { $str = html_writer::tag('b', '"' . format_string($cohortname, true) . '"'); } $output[] = $str; } if ($short) { return implode(', ', $output); } else { return html_writer::alist($output, array(), 'ul'); } } /** * Add appropriate new criteria options to the form * * @param object $mform moodle form */ public function get_options(&$mform) { global $DB; $none = false; $mform->addElement('header', 'first_header', $this->get_title()); $mform->addHelpButton('first_header', 'criteria_' . $this->criteriatype, 'badges'); // Get cohorts. $cohorts = $DB->get_records_menu('cohort', array(), 'name ASC', 'id, name'); if (!empty($cohorts)) { $select = array(); $selected = array(); foreach ($cohorts as $cid => $cohortname) { $select[$cid] = format_string($cohortname, true); } if ($this->id !== 0) { $selected = array_keys($this->params); } $settings = array('multiple' => 'multiple', 'size' => 20, 'class' => 'selectcohort'); $mform->addElement('select', 'cohort_cohorts', get_string('addcohort', 'badges'), $select, $settings); $mform->addRule('cohort_cohorts', get_string('requiredcohort', 'badges'), 'required'); $mform->addHelpButton('cohort_cohorts', 'addcohort', 'badges'); if ($this->id !== 0) { $mform->setDefault('cohort_cohorts', $selected); } } else { $mform->addElement('static', 'nocohorts', '', get_string('error:nocohorts', 'badges')); $none = true; } // Add aggregation. if (!$none) { $mform->addElement('header', 'aggregation', get_string('method', 'badges')); $agg = array(); $agg[] =& $mform->createElement('radio', 'agg', '', get_string('allmethodcohort', 'badges'), 1); $agg[] =& $mform->createElement('radio', 'agg', '', get_string('anymethodcohort', 'badges'), 2); $mform->addGroup($agg, 'methodgr', '', array('
'), false); if ($this->id !== 0) { $mform->setDefault('agg', $this->method); } else { $mform->setDefault('agg', BADGE_CRITERIA_AGGREGATION_ANY); } } return array($none, get_string('noparamstoadd', 'badges')); } /** * Save criteria records * * @param array $params Values from the form or any other array. */ public function save($params = array()) { $cohorts = $params['cohort_cohorts']; unset($params['cohort_cohorts']); foreach ($cohorts as $cohortid) { $params["cohort_{$cohortid}"] = $cohortid; } parent::save($params); } /** * Review this criteria and decide if it has been completed * * @param int $userid User whose criteria completion needs to be reviewed. * @param bool $filtered An additional parameter indicating that user list * has been reduced and some expensive checks can be skipped. * * @return bool Whether criteria is complete. */ public function review($userid, $filtered = false) { global $DB; $overall = false; foreach ($this->params as $param) { $cohort = $DB->get_record('cohort', array('id' => $param['cohort'])); // Extra check in case a cohort was deleted while badge is still active. if (!$cohort) { if ($this->method == BADGE_CRITERIA_AGGREGATION_ALL) { return false; } else { continue; } } if ($this->method == BADGE_CRITERIA_AGGREGATION_ALL) { if (cohort_is_member($cohort->id, $userid)) { $overall = true; continue; } else { return false; } } else if ($this->method == BADGE_CRITERIA_AGGREGATION_ANY) { if (cohort_is_member($cohort->id, $userid)) { return true; } else { $overall = false; continue; } } } return $overall; } /** * Checks criteria for any major problems. * * @return array A list containing status and an error message (if any). */ public function validate() { global $DB; $params = array_keys($this->params); $method = ($this->method == BADGE_CRITERIA_AGGREGATION_ALL); $singleparam = (count($params) == 1); foreach ($params as $param) { // Perform check if there only one parameter with any type of aggregation, // Or there are more than one parameter with aggregation ALL. if (($singleparam || $method) && !$DB->record_exists('cohort', array('id' => $param))) { return array(false, get_string('error:invalidparamcohort', 'badges')); } } return array(true, ''); } /** * Returns array with sql code and parameters returning all ids * of users who meet this particular criterion. * * @return array list($join, $where, $params) */ public function get_completed_criteria_sql() { $join = ''; $where = ''; $params = array(); if ($this->method == BADGE_CRITERIA_AGGREGATION_ANY) { // User is a member of ANY of the specified cohorts. $join = " LEFT JOIN {cohort_members} cm ON cm.userid = u.id"; $where = "AND ("; $i = 0; foreach ($this->params as $param) { if ($i == 0) { $where .= ' cm.cohortid = :cohortid'.$i; } else { $where .= ' OR cm.cohortid = :cohortid'.$i; } $params['cohortid'.$i] = $param['cohort']; $i++; } $where .= ") "; return array($join, $where, $params); } else { // User is a member of ALL of the specified cohorts. $join = " LEFT JOIN {cohort_members} cm ON cm.userid = u.id"; $i = 0; foreach ($this->params as $param) { $i++; $where = ' AND cm.cohortid = :cohortid'.$i; $params['cohortid'.$i] = $param['cohort']; } return array($join, $where, $params); } } }