Proyectos de Subversion Moodle

<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.

/**
 * Class users_data_source.
 *
 * @package    block_dash
 * @copyright  2019 bdecent gmbh <https://bdecent.de>
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

namespace block_dash\local\data_source;

use block_dash\local\block_builder;
use block_dash\local\dash_framework\query_builder\builder;
use block_dash\local\dash_framework\query_builder\join;
use block_dash\local\dash_framework\structure\table;
use block_dash\local\dash_framework\structure\user_table;
use block_dash\local\data_grid\filter\current_course_participants_condition;
use block_dash\local\data_grid\filter\date_filter;
use block_dash\local\data_grid\filter\filter;
use block_dash\local\data_grid\filter\group_filter;
use block_dash\local\data_grid\filter\logged_in_user_condition;
use block_dash\local\data_grid\filter\filter_collection;
use block_dash\local\data_grid\filter\filter_collection_interface;
use block_dash\local\data_grid\filter\my_groups_condition;
use block_dash\local\data_grid\filter\participants_condition;
use block_dash\local\data_grid\filter\user_field_filter;
use block_dash\local\data_grid\filter\user_profile_field_filter;
use block_dash\local\data_grid\filter\current_course_condition;
use block_dash\local\data_grid\filter\bool_filter;
use coding_exception;
use context;
/**
 * Class users_data_source.
 *
 * @package block_dash
 */
class users_data_source extends abstract_data_source {

    /**
     * Constructor.
     *
     * @param context $context
     */
    public function __construct(context $context) {
        $this->add_table(new user_table());

        parent::__construct($context);
    }

    /**
     * Get human readable name of data source.
     *
     * @return string
     * @throws coding_exception
     */
    public function get_name() {
        return get_string('users');
    }

    /**
     * Return query template for retrieving user info.
     *
     * @return builder
     * @throws coding_exception
     */
    public function get_query_template(): builder {
        global $CFG, $DB;

        require_once("$CFG->dirroot/user/profile/lib.php");

        $builder = new builder();
        $builder
            ->select('u.id', 'u_id')
            ->from('user', 'u')
            ->join('user_enrolments', 'ue', 'userid', 'u.id', join::TYPE_LEFT_JOIN)
            ->join('enrol', 'e', 'id', 'ue.enrolid', join::TYPE_LEFT_JOIN)
            ->join('course', 'c', 'id', 'e.courseid', join::TYPE_LEFT_JOIN)
            ->join('groups_members', 'gm', 'userid', 'u.id', join::TYPE_LEFT_JOIN)
            ->join('groups', 'g', 'id', 'gm.groupid', join::TYPE_LEFT_JOIN);

        foreach (profile_get_custom_fields() as $field) {
            $alias = 'u_pf_' . strtolower($field->shortname);

            $builder
                ->join('user_info_data', $alias, 'userid', 'u.id', join::TYPE_LEFT_JOIN)
                ->join_condition($alias, "$alias.fieldid = $field->id");
        }

        $builder->where('u.deleted', [0]);

        return $builder;
    }

    /**
     * Group by columns.
     *
     * @return string
     */
    public function get_groupby() {
        return false;
    }

    /**
     * Build and return filter collection.
     *
     * @return filter_collection_interface
     * @throws coding_exception
     */
    public function build_filter_collection() {
        global $CFG;

        require_once("$CFG->dirroot/user/profile/lib.php");

        $filtercollection = new filter_collection(get_class($this), $this->get_context());

        $filtercollection->add_filter(new group_filter('group', 'gm100.groupid'));

        $filtercollection->add_filter(new user_field_filter('u_department', 'u.department', 'department',
            get_string('department')));
        $filtercollection->add_filter(new user_field_filter('u_institution', 'u.institution', 'institution',
            get_string('institution')));

        $filter = new date_filter('u_lastlogin', 'u.lastlogin', date_filter::DATE_FUNCTION_FLOOR,
            get_string('lastlogin'));
        $filter->set_operation(filter::OPERATION_GREATER_THAN_EQUAL);
        $filtercollection->add_filter($filter);

        $filter = new date_filter('u_firstaccess', 'u.firstaccess', date_filter::DATE_FUNCTION_FLOOR,
            get_string('firstaccess'));
        $filter->set_operation(filter::OPERATION_GREATER_THAN_EQUAL);
        $filtercollection->add_filter($filter);

        $filtercollection->add_filter(new logged_in_user_condition('current_user', 'u.id'));
        $filtercollection->add_filter(new participants_condition('participants', 'u.id'));
        $filtercollection->add_filter(new my_groups_condition('my_groups', 'gm300.groupid'));
        $filtercollection->add_filter(new current_course_condition('current_course', 'c.id'));

        if (block_dash_has_pro()) {
            $filtercollection->add_filter(new \local_dash\data_grid\filter\parent_role_condition('parentrole', 'u.id'));
            $filtercollection->add_filter(new \local_dash\data_grid\filter\cohort_condition('cohort', 'u.id'));
            $filtercollection->add_filter(new \local_dash\data_grid\filter\users_mycohort_condition('users_mycohort', 'u.id'));
        }

        foreach (profile_get_custom_fields() as $field) {
            $alias = 'u_pf_' . strtolower($field->shortname);
            $select = $alias . '.data';
            switch ($field->datatype) {
                case 'checkbox':
                    $definitions[] = new bool_filter($alias, $select, $field->name);
                    break;
                case 'datetime':
                    $filtercollection->add_filter(new date_filter($alias, $select, date_filter::DATE_FUNCTION_FLOOR,
                            $field->name));
                    break;
                case 'textarea':
                    break;
                default:
                    $filter = new user_profile_field_filter($alias, $alias . '.data', $field->id, $field->name);
                    $filter->set_label(format_string($field->name));
                    $filtercollection->add_filter($filter);
                    break;
            }
        }

        return $filtercollection;
    }

    /**
     * Set the default preferences of the User datasource, force the set the default settings.
     *
     * @param array $data
     * @return array
     */
    public function set_default_preferences(&$data) {
        $configpreferences = $data['config_preferences'];
        $configpreferences['available_fields']['u_firstname']['visible'] = true;
        $configpreferences['available_fields']['u_lastname']['visible'] = true;
        $configpreferences['available_fields']['u_email']['visible'] = true;
        $configpreferences['available_fields']['u_lastlogin']['visible'] = true;
        $data['config_preferences'] = $configpreferences;
    }
}