PHP student::get_students方法代码示例

 function count_users_avail($namesearch = '', $alpha = '')
 {
     global $CFG, $CURMAN;
     $LIKE = $CURMAN->db->sql_compare();
     $FULLNAME = sql_concat('usr.firstname', "' '", 'usr.lastname');
     $select = 'SELECT COUNT(usr.id) ';
     $tables = 'FROM ' . $CURMAN->db->prefix_table(USRTABLE) . ' usr ';
     $join = 'LEFT JOIN ' . $CURMAN->db->prefix_table(INSTABLE) . ' ins ';
     $on = 'ON ins.userid = usr.id ';
     /// If limiting returns to specific teams, set that up now.
     if (!empty($CFG->curr_configteams)) {
         $where = 'usr.team IN (' . $CFG->curr_configteams . ') ';
     } else {
         $where = '';
     }
     if (!empty($namesearch)) {
         $namesearch = trim($namesearch);
         $where .= (!empty($where) ? ' AND ' : '') . "({$FULLNAME} {$LIKE} '%{$namesearch}%') ";
     }
     if ($alpha) {
         $where .= (!empty($where) ? ' AND ' : '') . "({$FULLNAME} {$LIKE} '{$alpha}%') ";
     }
     /*
             switch ($type) {
                 case 'student':
                     $where .= (!empty($where) ? ' AND ' : '') . 'usr.type = \'Student\' ';
                     break;
     
                 case 'instructor':
                     $where .= (!empty($where) ? ' AND ' : '') . 'usr.type = \'Instructor\' ';
                     break;
     
                 case '':
                     $where .= (!empty($where) ? ' AND ' : '') . '(usr.type = \'Student\' OR usr.type = \'Instructor\') ';
                     break;
             }
     */
     $uids = array();
     $stu = new student();
     if ($users = $stu->get_students()) {
         foreach ($users as $user) {
             $uids[] = $user->id;
         }
     }
     if ($users = $this->get_instructors()) {
         foreach ($users as $user) {
             $uids[] = $user->id;
         }
     }
     if (!empty($uids)) {
         $where .= (!empty($where) ? ' AND ' : '') . 'usr.id NOT IN ( ' . implode(', ', $uids) . ' ) ';
     }
     if (!empty($where)) {
         $where = 'WHERE ' . $where . ' ';
     }
     $sql = $select . $tables . $join . $on . $where;
     return $CURMAN->db->count_records_sql($sql);
 }

 function count_users_avail($namesearch = '', $alpha = '')
 {
     global $CFG;
     $params = array();
     $FULLNAME = $this->_db->sql_concat('usr.firstname', "' '", 'usr.lastname');
     $FULLNAME_LIKE = $this->_db->sql_like($FULLNAME, ':name_like', FALSE);
     $LASTNAME_STARTSWITH = $this->_db->sql_like('usr.lastname', ':lastname_startswith', FALSE);
     $select = 'SELECT COUNT(usr.id) ';
     $tables = 'FROM {' . user::TABLE . '} usr ';
     $join = 'LEFT JOIN {' . instructor::TABLE . '} ins ';
     $on = 'ON ins.userid = usr.id ';
     /// If limiting returns to specific teams, set that up now.
     if (!empty($CFG->curr_configteams)) {
         $where = 'usr.team IN (' . $CFG->curr_configteams . ') ';
     } else {
         $where = '';
     }
     if (!empty($namesearch)) {
         $namesearch = trim($namesearch);
         $where .= (!empty($where) ? ' AND ' : ' ') . "{$FULLNAME_LIKE} ";
         $params['name_like'] = "%{$namesearch}%";
     }
     if ($alpha) {
         $where .= (!empty($where) ? ' AND ' : ' ') . "{$LASTNAME_STARTSWITH}  ";
         $params['lastname_startswith'] = "{$alpha}%";
     }
     /*
             switch ($type) {
                 case 'student':
                     $where .= (!empty($where) ? ' AND ' : '') . 'usr.type = \'Student\' ';
                     break;
     
                 case 'instructor':
                     $where .= (!empty($where) ? ' AND ' : '') . 'usr.type = \'Instructor\' ';
                     break;
     
                 case '':
                     $where .= (!empty($where) ? ' AND ' : '') . '(usr.type = \'Student\' OR usr.type = \'Instructor\') ';
                     break;
             }
     */
     $uids = array();
     $stu = new student();
     if ($users = $stu->get_students($this->classid)) {
         foreach ($users as $user) {
             $uids[] = $user->id;
         }
     }
     unset($users);
     if ($users = $this->get_instructors()) {
         foreach ($users as $user) {
             $uids[] = $user->id;
         }
     }
     unset($users);
     if (!empty($uids)) {
         $where .= (!empty($where) ? ' AND ' : '') . 'usr.id NOT IN ( ' . implode(', ', $uids) . ' ) ';
     }
     //if appropriate, limit selection to users belonging to clusters that
     //the current user can manage instructor assignments for
     // TODO: Ugly, this needs to be overhauled
     $cpage = new pmclasspage();
     if (!$cpage->_has_capability('local/elisprogram:assign_class_instructor', $this->classid)) {
         //perform SQL filtering for the more "conditional" capability
         $allowed_clusters = instructor::get_allowed_clusters($this->classid);
         if (empty($allowed_clusters)) {
             $where .= (!empty($where) ? ' AND ' : '') . '0=1 ';
         } else {
             $cluster_filter = implode(',', $allowed_clusters);
             $where .= (!empty($where) ? ' AND ' : '') . 'usr.id IN (
                          SELECT userid FROM {' . clusterassignment::TABLE . "}\n                             WHERE clusterid IN ({$cluster_filter}))";
         }
     }
     if (!empty($where)) {
         $where = 'WHERE ' . $where . ' ';
     }
     $sql = $select . $tables . $join . $on . $where;
     return $this->_db->count_records_sql($sql, $params);
 }

 /**
  * Enrol the students associated with the class into the attached Moodle
  * course.
  *
  * @param none
  * @return bool True on success, False otherwise.
  */
 function data_enrol_students()
 {
     if (empty($this->classid) || empty($this->moodlecourseid) || !empty($this->siteconfig) && !file_exists($this->siteconfig)) {
         return false;
     }
     $stu = new student();
     if ($students = $stu->get_students($this->classid)) {
         /// At this point we must switch over the other Moodle site's DB config, if needed
         if (!empty($this->siteconfig)) {
             $cfgbak = moodle_load_config($this->siteconfig);
         }
         /// This has to be put here in case we have a site config reload.
         $CFG = $GLOBALS['CFG'];
         $CURMAN = $GLOBALS['CURMAN'];
         $db = $GLOBALS['db'];
         $role = get_default_course_role($this->moodlecourseid);
         if (!($context = get_context_instance(CONTEXT_COURSE, $this->moodlecourseid))) {
             return false;
         }
         foreach ($students as $student) {
             /// Make sure that a Moodle account exists for this user already.
             $user = new user($student->id);
             if (!($muser = $CURMAN->db->get_record('user', 'idnumber', addslashes($user->idnumber)))) {
                 $muser = addslashes_recursive($muser);
                 /// Create a new record.
                 $muser = new stdClass();
                 $muser->idnumber = $user->idnumber;
                 $muser->username = $user->uname;
                 $muser->passwword = $user->passwd;
                 $muser->firstname = $user->firstname;
                 $muser->lastname = $user->lastname;
                 $muser->auth = 'manual';
                 $muser->timemodified = time();
                 $muser->id = $CURMAN->db->insert_record('user', $muser);
             }
             /// If we have a vald Moodle user account, apply the role.
             if (!empty($muser->id)) {
                 role_assign($role->id, $muser->id, 0, $context->id, 0, 0, 0, 'manual');
             }
         }
         /// Reset $CFG object.
         if (!empty($this->siteconfig)) {
             moodle_load_config($cfgbak->dirroot . '/config.php');
         }
     }
     return true;
 }

 public function test_get_students()
 {
     // Fixture.
     $dataset = $this->createCsvDataSet(array(user::TABLE => elispm::file('tests/fixtures/pmuser.csv'), student::TABLE => elispm::file('tests/fixtures/student.csv')));
     $this->loadDataSet($dataset);
     // Test.
     $student = new student();
     $student->classid = 100;
     $students = $student->get_students();
     $this->assertNotEmpty($students);
     // Verify.
     $found = false;
     foreach ($students as $userrec) {
         if ($userrec->id === '103') {
             $found = true;
             break;
         }
     }
     $this->assertTrue($found);
 }