public static function get_databases_by_courses($courseids = array()) {
        global $PAGE;

        $params = self::validate_parameters(self::get_databases_by_courses_parameters(), array('courseids' => $courseids));
        $warnings = array();

        $mycourses = array();
        if (empty($params['courseids'])) {
            $mycourses = enrol_get_my_courses();
            $params['courseids'] = array_keys($mycourses);
        }

        // Array to store the databases to return.
        $arrdatabases = array();

        // Ensure there are courseids to loop through.
        if (!empty($params['courseids'])) {

            list($dbcourses, $warnings) = external_util::validate_courses($params['courseids'], $mycourses);

            // Get the databases in this course, this function checks users visibility permissions.
            // We can avoid then additional validate_context calls.
            $databases = get_all_instances_in_courses("data", $dbcourses);

            foreach ($databases as $database) {

                $context = context_module::instance($database->coursemodule);
                // Remove fields added by get_all_instances_in_courses.
                unset($database->coursemodule, $database->section, $database->visible, $database->groupmode, $database->groupingid);

                // This information should be only available if the user can see the database entries.
                if (!has_capability('mod/data:viewentry', $context)) {
                    $fields = array('comments', 'timeavailablefrom', 'timeavailableto', 'timeviewfrom',
                                    'timeviewto', 'requiredentries', 'requiredentriestoview', 'maxentries', 'rssarticles',
                                    'singletemplate', 'listtemplate', 'listtemplateheader', 'listtemplatefooter', 'addtemplate',
                                    'rsstemplate', 'rsstitletemplate', 'csstemplate', 'jstemplate', 'asearchtemplate', 'approval',
                                    'manageapproved', 'defaultsort', 'defaultsortdir');

                    foreach ($fields as $field) {
                        unset($database->{$field});
                    }
                }

                // Check additional permissions for returning optional private settings.
                // I avoid intentionally to use can_[add|update]_moduleinfo.
                if (!has_capability('moodle/course:manageactivities', $context)) {

                    $fields = array('scale', 'assessed', 'assesstimestart', 'assesstimefinish', 'editany', 'notification',
                                    'timemodified');

                    foreach ($fields as $field) {
                        unset($database->{$field});
                    }
                }
                $exporter = new database_summary_exporter($database, array('context' => $context));
                $arrdatabases[] = $exporter->export($PAGE->get_renderer('core'));
            }
        }

        $result = array();
        $result['databases'] = $arrdatabases;
        $result['warnings'] = $warnings;
        return $result;
    }
public static function get_databases_by_courses($courseids = array()) {
        global $PAGE;

        $params = self::validate_parameters(self::get_databases_by_courses_parameters(), array('courseids' => $courseids));
        $warnings = array();

        $mycourses = array();
        if (empty($params['courseids'])) {
            $mycourses = enrol_get_my_courses();
            $params['courseids'] = array_keys($mycourses);
        }

        // Array to store the databases to return.
        $arrdatabases = array();

        // Ensure there are courseids to loop through.
        if (!empty($params['courseids'])) {

            list($dbcourses, $warnings) = external_util::validate_courses($params['courseids'], $mycourses);

            // Get the databases in this course, this function checks users visibility permissions.
            // We can avoid then additional validate_context calls.
            $databases = get_all_instances_in_courses("data", $dbcourses);

            foreach ($databases as $database) {

                $context = context_module::instance($database->coursemodule);
                // Remove fields added by get_all_instances_in_courses.
                unset($database->coursemodule, $database->section, $database->visible, $database->groupmode, $database->groupingid);

                // This information should be only available if the user can see the database entries.
                if (!has_capability('mod/data:viewentry', $context)) {
                    $fields = array('comments', 'timeavailablefrom', 'timeavailableto', 'timeviewfrom',
                                    'timeviewto', 'requiredentries', 'requiredentriestoview', 'maxentries', 'rssarticles',
                                    'singletemplate', 'listtemplate', 'listtemplateheader', 'listtemplatefooter', 'addtemplate',
                                    'rsstemplate', 'rsstitletemplate', 'csstemplate', 'jstemplate', 'asearchtemplate', 'approval',
                                    'manageapproved', 'defaultsort', 'defaultsortdir');

                    foreach ($fields as $field) {
                        unset($database->{$field});
                    }
                }

                // Check additional permissions for returning optional private settings.
                // I avoid intentionally to use can_[add|update]_moduleinfo.
                if (!has_capability('moodle/course:manageactivities', $context)) {

                    $fields = array('scale', 'assessed', 'assesstimestart', 'assesstimefinish', 'editany', 'notification',
                                    'timemodified');

                    foreach ($fields as $field) {
                        unset($database->{$field});
                    }
                }
                $exporter = new database_summary_exporter($database, array('context' => $context));
                $arrdatabases[] = $exporter->export($PAGE->get_renderer('core'));
            }
        }

        $result = array();
        $result['databases'] = $arrdatabases;
        $result['warnings'] = $warnings;
        return $result;
    }
public static function get_databases_by_courses ( $ courseids = array ( ) ) { global $ PAGE ; $ params = self :: validate_parameters ( self :: get_databases_by_courses_parameters ( ) , array ( 'courseids' => $ courseids ) ) ; $ warnings = array ( ) ; $ mycourses = array ( ) ; if ( empty ( $ params [ 'courseids' ] ) ) { $ mycourses = enrol_get_my_courses ( ) ; $ params [ 'courseids' ] = array_keys ( $ mycourses ) ; } // Array to store the databases to return. $ arrdatabases = array ( ) ; // Ensure there are courseids to loop through. if ( ! empty ( $ params [ 'courseids' ] ) ) { list ( $ dbcourses , $ warnings ) = external_util :: validate_courses ( $ params [ 'courseids' ] , $ mycourses ) ; // Get the databases in this course, this function checks users visibility permissions. // We can avoid then additional validate_context calls. $ databases = get_all_instances_in_courses ( "data" , $ dbcourses ) ; foreach ( $ databases as $ database ) { $ context = context_module :: instance ( $ database -> coursemodule ) ; // Remove fields added by get_all_instances_in_courses. unset ( $ database -> coursemodule , $ database -> section , $ database -> visible , $ database -> groupmode , $ database -> groupingid ) ; // This information should be only available if the user can see the database entries. if ( ! has_capability ( 'mod/data:viewentry' , $ context ) ) { $ fields = array ( 'comments' , 'timeavailablefrom' , 'timeavailableto' , 'timeviewfrom' , 'timeviewto' , 'requiredentries' , 'requiredentriestoview' , 'maxentries' , 'rssarticles' , 'singletemplate' , 'listtemplate' , 'listtemplateheader' , 'listtemplatefooter' , 'addtemplate' , 'rsstemplate' , 'rsstitletemplate' , 'csstemplate' , 'jstemplate' , 'asearchtemplate' , 'approval' , 'manageapproved' , 'defaultsort' , 'defaultsortdir' ) ; foreach ( $ fields as $ field ) { unset ( $ database -> { $ field } ) ; } } // Check additional permissions for returning optional private settings. // I avoid intentionally to use can_[add|update]_moduleinfo. if ( ! has_capability ( 'moodle/course:manageactivities' , $ context ) ) { $ fields = array ( 'scale' , 'assessed' , 'assesstimestart' , 'assesstimefinish' , 'editany' , 'notification' , 'timemodified' ) ; foreach ( $ fields as $ field ) { unset ( $ database -> { $ field } ) ; } } $ exporter = new database_summary_exporter ( $ database , array ( 'context' => $ context ) ) ; $ arrdatabases [ ] = $ exporter -> export ( $ PAGE -> get_renderer ( 'core' ) ) ; } } $ result = array ( ) ; $ result [ 'databases' ] = $ arrdatabases ; $ result [ 'warnings' ] = $ warnings ; return $ result ; }
Returns a list of databases in a provided list of courses,
if no list is provided all databases that the user can view will be returned.

@param array $courseids the course ids
@return array the database details
@since Moodle 2.9
Returns a list of databases in a provided list of courses if no list is provided all databases that the user can view will be returned .