block_cegep_enrol_admin_form.php

<?php

require_once($CFG->libdir.'/formslib.php');

class cegep_enrol_admin_form extends moodleform {

    function definition() {
        global $COURSE;
    
        $mform =& $this->_form;

        $current = cegep_local_current_term();
        $year = substr($current, 0, 4);
        $semester = substr($current, 4, 1);

        // If course isn't visible, offer the option
        if (!$COURSE->visible) {
            $mform->addElement('checkbox', 'makevisible', null, get_string('make_visible','block_cegep'));
        }

        $enrol = array();
        $enrol[] =& $mform->createElement('select', 'semester', null, array('1' => get_string('winter','block_cegep'), '2' => get_string('summer','block_cegep'), '3' => get_string('autumn','block_cegep')));
        $enrol[] =& $mform->createElement('select', 'year', null, array($year-1 => $year-1, $year => $year, $year+1 => $year+1));

        $mform->addGroup($enrol, 'semester', get_string('semester','block_cegep').' :', '&nbsp;', false);
        $mform->addRule('semester', get_string('specifysemester','block_cegep'), 'required');
        $mform->addGroupRule('semester', array(
            'trimestre' => array(
        array(get_string('specifysemester','block_cegep'), 'required')
        ),
            'year' => array(
        array(get_string('specifyyear','block_cegep'), 'required')
        )
        ), 'required', null, 2);
        $mform->setType('semester', PARAM_INT);
        $mform->setType('year', PARAM_INT);

        $mform->addElement('text', 'coursecode', get_string('coursecode','block_cegep').' :', 'size="8", maxlength="8"');
        $mform->setType('coursecode', PARAM_TEXT);
        $mform->addElement('text', 'coursegroup', get_string('coursegroup','block_cegep').' :', 'size="8", maxlength="32"');
        $mform->addRule('coursegroup', get_string('specifycoursegroup','block_cegep'), 'required');
        $mform->setType('coursegroup', PARAM_TEXT);

        $mform->SetDefaults(array(
            'year' => $year,
            'semester' => $semester,
        ));

        $mform->addElement('checkbox', 'creategroups', null, get_string('creategroups','block_cegep'));

        $this->add_action_buttons();
    }

    function validation($data, $files) {
        global $COURSE, $USER;

        $errors = parent::validation($data, $files);

        $term = "$data[year]$data[semester]";
        if (empty($data['coursecode'])) {
            $cc = explode('_', $COURSE->idnumber);
            $coursecode = $cc[0];
        } 
        else {
            $coursecode = $data['coursecode'];
        }

        if (empty($data['semester']) || empty($data['year'])) {
            $errors['semester'] = get_string('semesterinvalid','block_cegep');
        }
        elseif (empty($data['coursegroup']) || preg_match('/[^0-9,]/', $data['coursegroup'])) {
            $errors['coursegroup'] = get_string('coursegroupinvalid','block_cegep');
        }
        
        if (!empty($errors)) {
            return $errors;
        }

        if (strstr($data['coursegroup'], ',')) {
            $coursegroups = explode(',', $data['coursegroup']);
        } else {
            $coursegroups = array($data['coursegroup']);
        }

        foreach ($coursegroups as $coursegroup) {
            $coursegroup = trim($coursegroup);
            // Verify if the coursegroup is available in the system
            if (!$coursegroup_id = cegep_local_get_coursegroup_id($coursecode, $coursegroup, $term)) {
                $errors['coursegroup'] = get_string('coursegroupunavailable','block_cegep') . " ($coursegroup)";
            }
            // Verify if the coursegroup is already enrolled into this course
            elseif (self::validate_coursegroup_enrolled($coursegroup_id)) {
                $errors['coursegroup'] = get_string('coursegroupalreadyenrolled','block_cegep') . " ($coursegroup)";
            }
            // Verify if the coursegroup has students registered
            elseif (!self::validate_coursegroup_students_registered($coursegroup_id)) {
                $errors['coursegroup'] = get_string('coursegrouphasnostudents','block_cegep') . " ($coursegroup)";
            }
        }

        return $errors;
    }

    private function validate_coursegroup_enrolled($coursegroup_id) {
        global $CFG, $COURSE, $enroldb;

        $select = "SELECT COUNT(`coursegroup_id`) AS num FROM `$CFG->enrol_remoteenroltable` WHERE `$CFG->enrol_remotecoursefield` = '$COURSE->idnumber' AND `coursegroup_id` = '$coursegroup_id' LIMIT 1";

        $result = $enroldb->Execute($select);
        
        if (!$result) {
            trigger_error($enroldb->ErrorMsg() .' STATEMENT: '. $select, E_USER_ERROR);
            return false;
        } 
        else {
            return $result->fields['num'];
        }
    }
    
    private function validate_coursegroup_students_registered($coursegroup_id) {
        global $CFG, $COURSE, $sisdb;

        $select = "SELECT * FROM `$CFG->sisdb_name`.`student_enrolment` WHERE `coursegroup_id` = '$coursegroup_id';";
        $result = $sisdb->Execute($select);
        
        if (!$result) {
            trigger_error($sisdb->ErrorMsg() .' STATEMENT: '. $select, E_USER_ERROR);
            return false;
        } 
        elseif ($result->RecordCount() < 1) {
            return false;
        }
        else {
            return true;
        }
    }
}

?>