<?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/>.

/**
 * This page handles listing of lesson overrides
 *
 * @package    mod_lesson
 * @copyright  2015 Jean-Michel Vedrine
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */


require_once(__DIR__ . '/../../config.php');
require_once($CFG->dirroot.'/mod/lesson/lib.php');
require_once($CFG->dirroot.'/mod/lesson/locallib.php');
require_once($CFG->dirroot.'/mod/lesson/override_form.php');


$cmid = required_param('cmid', PARAM_INT);
$mode = optional_param('mode', '', PARAM_ALPHA); // One of 'user' or 'group', default is 'group'.

list($course, $cm) = get_course_and_cm_from_cmid($cmid, 'lesson');
$lesson = $DB->get_record('lesson', array('id' => $cm->instance), '*', MUST_EXIST);

require_login($course, false, $cm);

$context = context_module::instance($cm->id);

// Check the user has the required capabilities to list overrides.
require_capability('mod/lesson:manageoverrides', $context);

$lessongroupmode = groups_get_activity_groupmode($cm);
$accessallgroups = ($lessongroupmode == NOGROUPS) || has_capability('moodle/site:accessallgroups', $context);

// Get the course groups that the current user can access.
$groups = $accessallgroups ? groups_get_all_groups($cm->course) : groups_get_activity_allowed_groups($cm);

// Default mode is "group", unless there are no groups.
if ($mode != "user" and $mode != "group") {
    if (!empty($groups)) {
        $mode = "group";
    } else {
        $mode = "user";
    }
}
$groupmode = ($mode == "group");

$url = new moodle_url('/mod/lesson/overrides.php', array('cmid' => $cm->id, 'mode' => $mode));

$PAGE->set_url($url);

// Display a list of overrides.
$PAGE->set_pagelayout('admin');

> $PAGE->add_body_class('limitedwidth');


$PAGE->set_title(get_string('overrides', 'lesson'));
$PAGE->set_heading($course->fullname);

> $PAGE->activityheader->set_attrs([
echo $OUTPUT->header();
>     'hidecompletion' => true,
echo $OUTPUT->heading(format_string($lesson->name, true, array('context' => $context)));
>     'description' => ''

> ]);
// Delete orphaned group overrides.
> navigation_node::override_active_url(new moodle_url('/mod/lesson/overrides.php', ['cmid' => $cmid]));
$sql = 'SELECT o.id
> 
          FROM {lesson_overrides} o
> $renderer = $PAGE->get_renderer('mod_lesson');
     LEFT JOIN {groups} g ON o.groupid = g.id
> 



< echo $OUTPUT->heading(format_string($lesson->name, true, array('context' => $context)));


               AND g.id IS NULL
               AND o.lessonid = ?';
$params = array($lesson->id);
$orphaned = $DB->get_records_sql($sql, $params);
if (!empty($orphaned)) {
    $DB->delete_records_list('lesson_overrides', 'id', array_keys($orphaned));
}

$overrides = [];

// Fetch all overrides.
if ($groupmode) {
    $colname = get_string('group');
    // To filter the result by the list of groups that the current user has access to.
    if ($groups) {
        $params = ['lessonid' => $lesson->id];
        list($insql, $inparams) = $DB->get_in_or_equal(array_keys($groups), SQL_PARAMS_NAMED);
        $params += $inparams;

        $sql = "SELECT o.*, g.name
                  FROM {lesson_overrides} o
                  JOIN {groups} g ON o.groupid = g.id
                 WHERE o.lessonid = :lessonid AND g.id $insql
              ORDER BY g.name";

        $overrides = $DB->get_records_sql($sql, $params);
    }
} else {
    $colname = get_string('user');
    list($sort, $params) = users_order_by_sql('u');
    $params['lessonid'] = $lesson->id;


>     $userfieldsapi = \core_user\fields::for_name();


    if ($accessallgroups) {

<         $sql = 'SELECT o.*, ' . get_all_user_name_fields(true, 'u') . '



>         $sql = 'SELECT o.*, ' . $userfieldsapi->get_sql('u', false, '', '', false)->selects . '


                  FROM {lesson_overrides} o
                  JOIN {user} u ON o.userid = u.id
                 WHERE o.lessonid = :lessonid
              ORDER BY ' . $sort;

        $overrides = $DB->get_records_sql($sql, $params);
    } else if ($groups) {
        list($insql, $inparams) = $DB->get_in_or_equal(array_keys($groups), SQL_PARAMS_NAMED);
        $params += $inparams;


<         $sql = 'SELECT o.*, ' . get_all_user_name_fields(true, 'u') . '



>         $sql = 'SELECT o.*, ' . $userfieldsapi->get_sql('u', false, '', '', false)->selects . '


                  FROM {lesson_overrides} o
                  JOIN {user} u ON o.userid = u.id
                  JOIN {groups_members} gm ON u.id = gm.userid
                 WHERE o.lessonid = :lessonid AND gm.groupid ' . $insql . '
              ORDER BY ' . $sort;

        $overrides = $DB->get_records_sql($sql, $params);
    }
}

$overrides = $DB->get_records_sql($sql, $params);


> $canoverride = true;
// Initialise table.
> $errormessage = '';
$table = new html_table();
> 
$table->headspan = array(1, 2, 1);
> if ($groupmode) {
$table->colclasses = array('colname', 'colsetting', 'colvalue', 'colaction');
>     if (empty($groups)) {
$table->head = array(
>         // There are no groups.
        $colname,
>         $canoverride = false;
        get_string('overrides', 'lesson'),
>         $errormessage = get_string('groupsnone', 'lesson');
        get_string('action'),
>     }
);
> } else {

>     $users = array();
$userurl = new moodle_url('/user/view.php', array());
>     // See if there are any users in the lesson.
$groupurl = new moodle_url('/group/overview.php', array('id' => $cm->course));
>     if ($accessallgroups) {

>         $users = get_enrolled_users($context, '', 0, 'u.id');
$overridedeleteurl = new moodle_url('/mod/lesson/overridedelete.php');
>         $nousermessage = get_string('usersnone', 'lesson');
$overrideediturl = new moodle_url('/mod/lesson/overrideedit.php');
>     } else if ($groups) {

>         $enrolledjoin = get_enrolled_join($context, 'u.id');
$hasinactive = false; // Whether there are any inactive overrides.
>         list($ingroupsql, $ingroupparams) = $DB->get_in_or_equal(array_keys($groups), SQL_PARAMS_NAMED);

>         $params = $enrolledjoin->params + $ingroupparams;
foreach ($overrides as $override) {
>         $sql = "SELECT u.id

>                   FROM {user} u
    $fields = array();
>                   JOIN {groups_members} gm ON gm.userid = u.id
    $values = array();
>                        {$enrolledjoin->joins}
    $active = true;
>                  WHERE gm.groupid $ingroupsql

>                        AND {$enrolledjoin->wheres}
    // Check for inactive overrides.
>               ORDER BY $sort";
    if (!$groupmode) {
>         $users = $DB->get_records_sql($sql, $params);
        if (!is_enrolled($context, $override->userid)) {
>         $nousermessage = get_string('usersnone', 'lesson');
            // User not enrolled.
>     } else {
            $active = false;
>         $nousermessage = get_string('groupsnone', 'lesson');
        } else if (!\core_availability\info_module::is_user_visible($cm, $override->userid)) {
>     }
            // User cannot access the module.
>     $info = new \core_availability\info_module($cm);
            $active = false;
>     $users = $info->filter_user_list($users);
        }
> 
    }
>     if (empty($users)) {

>         // There are no users.
    // Format available.
>         $canoverride = false;
    if (isset($override->available)) {
>         $errormessage = $nousermessage;
        $fields[] = get_string('lessonopens', 'lesson');
>     }
        $values[] = $override->available > 0 ?
> }
                userdate($override->available) : get_string('noopen', 'lesson');
> 


    }

    // Format deadline.
    if (isset($override->deadline)) {
        $fields[] = get_string('lessoncloses', 'lesson');
        $values[] = $override->deadline > 0 ?
                userdate($override->deadline) : get_string('noclose', 'lesson');
    }

    // Format timelimit.
    if (isset($override->timelimit)) {
        $fields[] = get_string('timelimit', 'lesson');
        $values[] = $override->timelimit > 0 ?
                format_time($override->timelimit) : get_string('none', 'lesson');
    }

    // Format option to try a question again.
    if (isset($override->review)) {
        $fields[] = get_string('displayreview', 'lesson');
        $values[] = $override->review ?
                get_string('yes') : get_string('no');
    }

    // Format number of attempts.
    if (isset($override->maxattempts)) {
        $fields[] = get_string('maximumnumberofattempts', 'lesson');
        $values[] = $override->maxattempts > 0 ?
                $override->maxattempts : get_string('unlimited');
    }

    // Format retake allowed.
    if (isset($override->retake)) {
        $fields[] = get_string('retakesallowed', 'lesson');
        $values[] = $override->retake ?
                get_string('yes') : get_string('no');
    }

    // Format password.
    if (isset($override->password)) {
        $fields[] = get_string('usepassword', 'lesson');
        $values[] = $override->password !== '' ?
                get_string('enabled', 'lesson') : get_string('none', 'lesson');
    }

    // Icons.
    $iconstr = '';

    // Edit.
    $editurlstr = $overrideediturl->out(true, array('id' => $override->id));
    $iconstr = '<a title="' . get_string('edit') . '" href="'. $editurlstr . '">' .
            $OUTPUT->pix_icon('t/edit', get_string('edit')) . '</a> ';
    // Duplicate.
    $copyurlstr = $overrideediturl->out(true,
            array('id' => $override->id, 'action' => 'duplicate'));
    $iconstr .= '<a title="' . get_string('copy') . '" href="' . $copyurlstr . '">' .
            $OUTPUT->pix_icon('t/copy', get_string('copy')) . '</a> ';
    // Delete.
    $deleteurlstr = $overridedeleteurl->out(true,
            array('id' => $override->id, 'sesskey' => sesskey()));
    $iconstr .= '<a title="' . get_string('delete') . '" href="' . $deleteurlstr . '">' .
                $OUTPUT->pix_icon('t/delete', get_string('delete')) . '</a> ';

    if ($groupmode) {

<         $usergroupstr = '<a href="' . $groupurl->out(true,
<                 array('group' => $override->groupid)) . '" >' . $override->name . '</a>';



>         $usergroupstr = '<a href="' . $groupurl->out(true, ['group' => $override->groupid]) . '" >' .
>             format_string($override->name, true, ['context' => $context]) . '</a>';


    } else {
        $usergroupstr = '<a href="' . $userurl->out(true,
                array('id' => $override->userid)) . '" >' . fullname($override) . '</a>';
    }

    $class = '';
    if (!$active) {
        $class = "dimmed_text";
        $usergroupstr .= '*';
        $hasinactive = true;
    }

    $usergroupcell = new html_table_cell();
    $usergroupcell->rowspan = count($fields);
    $usergroupcell->text = $usergroupstr;
    $actioncell = new html_table_cell();
    $actioncell->rowspan = count($fields);
    $actioncell->text = $iconstr;

    for ($i = 0; $i < count($fields); ++$i) {
        $row = new html_table_row();
        $row->attributes['class'] = $class;
        if ($i == 0) {
            $row->cells[] = $usergroupcell;
        }
        $cell1 = new html_table_cell();
        $cell1->text = $fields[$i];
        $row->cells[] = $cell1;
        $cell2 = new html_table_cell();
        $cell2->text = $values[$i];
        $row->cells[] = $cell2;
        if ($i == 0) {
            $row->cells[] = $actioncell;
        }
        $table->data[] = $row;
    }
}


> $overrideselect = new \mod_lesson\output\override_action_menu($cm->id, $url, $canoverride);
// Output the table and button.
> echo $renderer->render($overrideselect);
echo html_writer::start_tag('div', array('id' => 'lessonoverrides'));
> 


if (count($table->data)) {
    echo html_writer::table($table);
}

> 
if ($hasinactive) {
> // No overrides to be displayed.
    echo $OUTPUT->notification(get_string('inactiveoverridehelp', 'lesson'), 'dimmed_text');
> if (!$overrides) {
}
>     echo $OUTPUT->notification(get_string('nooverridecreated', 'lesson'), 'info', false);

> }
echo html_writer::start_tag('div', array('class' => 'buttons'));
> 



< $options = array();
< if ($groupmode) {
<     if (empty($groups)) {
<         // There are no groups.
<         echo $OUTPUT->notification(get_string('groupsnone', 'lesson'), 'error');
<         $options['disabled'] = true;
<     }
<     echo $OUTPUT->single_button($overrideediturl->out(true,
<             array('action' => 'addgroup', 'cmid' => $cm->id)),
<             get_string('addnewgroupoverride', 'lesson'), 'post', $options);
< } else {
<     $users = array();
<     // See if there are any users in the lesson.
<     if ($accessallgroups) {
<         $users = get_enrolled_users($context, '', 0, 'u.id');
<         $nousermessage = get_string('usersnone', 'lesson');
<     } else if ($groups) {
<         $enrolledjoin = get_enrolled_join($context, 'u.id');
<         list($ingroupsql, $ingroupparams) = $DB->get_in_or_equal(array_keys($groups), SQL_PARAMS_NAMED);
<         $params = $enrolledjoin->params + $ingroupparams;
<         $sql = "SELECT u.id
<                   FROM {user} u
<                   JOIN {groups_members} gm ON gm.userid = u.id
<                        {$enrolledjoin->joins}
<                  WHERE gm.groupid $ingroupsql
<                        AND {$enrolledjoin->wheres}
<               ORDER BY $sort";
<         $users = $DB->get_records_sql($sql, $params);
<         $nousermessage = get_string('usersnone', 'lesson');
<     } else {
<         $nousermessage = get_string('groupsnone', 'lesson');
<     }
<     $info = new \core_availability\info_module($cm);
<     $users = $info->filter_user_list($users);
< 
<     if (empty($users)) {
<         // There are no users.
<         echo $OUTPUT->notification($nousermessage, 'error');
<         $options['disabled'] = true;
<     }
<     echo $OUTPUT->single_button($overrideediturl->out(true,
<             array('action' => 'adduser', 'cmid' => $cm->id)),
<             get_string('addnewuseroverride', 'lesson'), 'get', $options);



> if (!empty($errormessage)) {
>     echo $OUTPUT->notification($errormessage, 'error');


}
echo html_writer::end_tag('div');
echo html_writer::end_tag('div');

// Finish the page.
echo $OUTPUT->footer();