AutorÃa | Ultima modificación | Ver Log |
<?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 performs bulk changes on reengagment users.
*
* @package mod_reengagement
* @author Dan Marsden <dan@danmarsden.com>
* @copyright 2018 Catalyst IT {@link http://www.catalyst.net.nz}
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/
require_once(dirname(dirname(dirname(__FILE__))).'/config.php');
require_once(dirname(__FILE__).'/lib.php');
$id = required_param('id', PARAM_INT); // Course_module ID.
$formaction = required_param('formaction', PARAM_LOCALURL);
$userids = optional_param('userids', array(), PARAM_TEXT);
$confirm = optional_param('confirm', 0, PARAM_INT);
$cm = get_coursemodule_from_id('reengagement', $id, 0, false, MUST_EXIST);
$course = $DB->get_record('course', array('id' => $cm->course), '*', MUST_EXIST);
$reengagement = $DB->get_record('reengagement', array('id' => $cm->instance), '*', MUST_EXIST);
$default = new moodle_url('/mod/reengagement/view.php', ['id' => $cm->id]);
$returnurl = new moodle_url(optional_param('returnto', $default, PARAM_URL));
require_sesskey(); // This is an action script.
$PAGE->set_url('/mod/reengagement/view.php', array('id' => $id, 'formaction' => $formaction));
require_login($course, true, $cm);
$context = context_module::instance($cm->id);
require_capability('mod/reengagement:bulkactions', $context);
$PAGE->set_title(format_string($reengagement->name));
$PAGE->set_heading(format_string($course->fullname));
$PAGE->set_context($context);
if (!empty($userids)) {
$userids = explode(',', $userids);
}
// First initial post from view.php - users stored in array as "userX" => "on" - get the userids.
if (empty($userids) && $post = data_submitted()) {
foreach ($post as $k => $v) {
if (preg_match('/^user(\d+)$/', $k, $m)) {
$userids[] = $m[1];
}
}
}
if (!$confirm) {
echo $OUTPUT->header();
}
if ($formaction == 'resetbyspecificdate') {
for ($i = 1; $i <= 31; $i++) {
$days[$i] = $i;
}
for ($i = 1; $i <= 12; $i++) {
$months[$i] = userdate(gmmktime(12, 0, 0, $i, 15, 2000), "%B");
}
for ($i = 2017; $i <= date('Y') + 4; $i++) {
$years[$i] = $i;
}
echo '<div align="center">';
echo '<h4>'.get_string('specifydate', 'mod_reengagement').'</h4>';
echo '<form action="'.$CFG->wwwroot.'/mod/reengagement/bulkchange.php" method="POST"
id="reengagementbulkchange" class="popupform">';
echo html_writer::select($days, 'day', date('n'));
echo html_writer::select($months, 'month', date('n'));
echo html_writer::select($years, 'year', date('Y'));
echo '<input name="userids" value="'. implode(',', $userids).'" type="hidden" />';
echo '<input name="id" value="'.$id.'" type="hidden" />';
echo '<input name="sesskey" value="'.sesskey().'" type="hidden" />';
echo '<input name="formaction" value="resetbyspecificdate2" type="hidden" />';
echo '<input name="submit" value="Go" type="submit" id="id_submit" />';
echo '</form></div>';
echo $OUTPUT->footer();
exit;
}
$usernamefields = \core_user\fields::for_name()->get_sql($alias = 'u', false, '', '', false)->selects;
list($usql, $params) = $DB->get_in_or_equal($userids, SQL_PARAMS_NAMED, 'u');
if ($formaction == 'resetbyfirstaccess') {
$sql = "SELECT u.id, $usernamefields, rip.id as ripid,
rip.completiontime, rip.emailtime, rip.completiontime, rip.completed,
min(l.timecreated) as firstaccess
FROM {reengagement_inprogress} rip
JOIN {user} u on u.id = rip.userid
LEFT JOIN {logstore_standard_log} l ON l.userid = u.id AND l.courseid = :courseid
WHERE rip.reengagement = :re AND u.id ".$usql ."
GROUP BY u.id, u.firstname, u.lastname, rip.id,
rip.completiontime, rip.emailtime, rip.completiontime, rip.completed";
$params['courseid'] = $course->id;
$params['re'] = $reengagement->id;
$users = $DB->get_records_sql($sql, $params);
$duration = $reengagement->duration;
} else if ($formaction == 'resetbyenrolment') {
$sql = "SELECT u.id, $usernamefields, rip.id as ripid,
rip.completiontime, rip.emailtime, rip.completiontime, rip.completed,
min(ue.timecreated) as firstaccess
FROM {reengagement_inprogress} rip
JOIN {user} u on u.id = rip.userid
JOIN {user_enrolments} ue ON ue.userid = u.id
JOIN {enrol} e ON (e.id = ue.enrolid) AND e.courseid = :courseid
WHERE rip.reengagement = :re AND u.id ".$usql ."
GROUP BY u.id, u.firstname, u.lastname, rip.id,
rip.completiontime, rip.emailtime, rip.completiontime, rip.completed";
$params['courseid'] = $course->id;
$params['re'] = $reengagement->id;
$users = $DB->get_records_sql($sql, $params);
$duration = $reengagement->duration;
} else if ($formaction == 'resetbyspecificdate2') {
$timestamp = optional_param('timestamp', 0, PARAM_INT);
if (empty($timestamp)) {
$day = required_param('day', PARAM_INT);
$month = required_param('month', PARAM_INT);
$year = required_param('year', PARAM_INT);
$timestamp = make_timestamp($year, $month, $day, 9);
}
$sql = "SELECT u.id, $usernamefields, rip.id as ripid,
rip.completiontime, rip.emailtime, rip.completiontime, rip.completed,
'".$timestamp."' as firstaccess
FROM {reengagement_inprogress} rip
JOIN {user} u on u.id = rip.userid
WHERE rip.reengagement = :re AND u.id ".$usql ."
GROUP BY u.id, u.firstname, u.lastname, rip.id,
rip.completiontime, rip.emailtime, rip.completiontime, rip.completed";
$params['courseid'] = $course->id;
$params['re'] = $reengagement->id;
$users = $DB->get_records_sql($sql, $params);
$duration = 0; // Don't add duration to this status - use specified date instead.
}
if (!empty($formaction) && !empty($users)) {
// Get information on users and the updated date.
if (!$confirm) {
print '<table class="reengagementlist">' . "\n";
print "<tr><th>" . get_string('user') . "</th>";
print "<th>" . get_string('completiontime', 'reengagement') . '</th>';
print "<th>" . get_string('newcompletiontime', 'reengagement') . '</th>';
print "</tr>";
foreach ($users as $user) {
if (!empty($user->firstaccess)) {
$newdate = $user->firstaccess + $duration;
if ($newdate == $user->completiontime) {
// Date is already based on firstaccess.
$newdate = get_string('nochange', 'mod_reengagement');
} else {
$newdate = userdate($newdate, get_string('strftimedatetimeshort', 'langconfig'));
}
} else {
$newdate = get_string('nochangenoaccess', 'mod_reengagement');
}
print '<tr><td>' . fullname($user) . '</td>';
print '<td>' . userdate($user->completiontime, get_string('strftimedatetimeshort', 'langconfig'))."</td>";
print '<td>'. $newdate."</td></tr>";
}
print '</table>';
$yesurl = new moodle_url('/mod/reengagement/bulkchange.php');
$yesparams = array('id' => $cm->id, 'formaction' => $formaction,
'userids' => implode(',', $userids), 'confirm' => 1);
if ($formaction == 'resetbyspecificdate2') {
// Add timestamp to form.
$yesparams['timestamp'] = $timestamp;
}
$areyousure = get_string('areyousure', 'mod_reengagement');
echo $OUTPUT->confirm($areyousure, new moodle_url($yesurl, $yesparams), $returnurl);
echo $OUTPUT->footer();
die;
} else {
foreach ($users as $user) {
if (!empty($user->firstaccess)) {
$newdate = $user->firstaccess + $duration;
if ($newdate !== $user->completiontime) {
$rip = new stdClass();
$rip->id = $user->ripid;
$rip->userid = $user->id;
$rip->reengagement = $reengagement->id;
$rip->completiontime = $newdate;
$DB->update_record('reengagement_inprogress', $rip);
}
}
}
redirect($returnurl, get_string('completiondatesupdated', 'reengagement'));
}
}
redirect($returnurl);