Gecko [ 167.86.127.34 ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
adhoc_task.php	4.31 KB	-rwxrwxrwx
analytics_cleanup_task.php	1.73 KB	-rwxrwxrwx
asynchronous_backup_task.php	3.21 KB	-rwxrwxrwx
asynchronous_copy_task.php	9.11 KB	-rwxrwxrwx
asynchronous_restore_task.php	3.15 KB	-rwxrwxrwx
automated_backup_task.php	1.65 KB	-rwxrwxrwx
backup_cleanup_task.php	2.5 KB	-rwxrwxrwx
badges_cron_task.php	3.14 KB	-rwxrwxrwx
badges_message_task.php	2.17 KB	-rwxrwxrwx
blog_cron_task.php	2.16 KB	-rwxrwxrwx
build_installed_themes_task.ph...	1.73 KB	-rwxrwxrwx
cache_cleanup_task.php	1.38 KB	-rwxrwxrwx
cache_cron_task.php	1.33 KB	-rwxrwxrwx
calendar_cron_task.php	2.19 KB	-rwxrwxrwx
calendar_fix_orphaned_events.p...	2.63 KB	-rwxrwxrwx
check_for_updates_task.php	1.6 KB	-rwxrwxrwx
clean_up_deleted_search_area_t...	1.71 KB	-rwxrwxrwx
complete_plans_task.php	1.89 KB	-rwxrwxrwx
completion_daily_task.php	6.2 KB	-rwxrwxrwx
completion_regular_task.php	8.12 KB	-rwxrwxrwx
context_cleanup_task.php	1.64 KB	-rwxrwxrwx
course_backup_task.php	4.05 KB	-rwxrwxrwx
create_contexts_task.php	1.54 KB	-rwxrwxrwx
database_logger.php	5.46 KB	-rwxrwxrwx
delete_incomplete_users_task.p...	2.58 KB	-rwxrwxrwx
delete_unconfirmed_users_task....	2.12 KB	-rwxrwxrwx
file_temp_cleanup_task.php	4.24 KB	-rwxrwxrwx
file_trash_cleanup_task.php	1.44 KB	-rwxrwxrwx
grade_cron_task.php	3.15 KB	-rwxrwxrwx
grade_history_cleanup_task.php	2.09 KB	-rwxrwxrwx
h5p_get_content_types_task.php	2.21 KB	-rwxrwxrwx
legacy_plugin_cron_task.php	7.59 KB	-rwxrwxrwx
logging_trait.php	3.13 KB	-rwxrwxrwx
logmanager.php	9.82 KB	-rwxrwxrwx
manager.php	34.77 KB	-rwxrwxrwx
messaging_cleanup_task.php	2.72 KB	-rwxrwxrwx
password_reset_cleanup_task.ph...	1.95 KB	-rwxrwxrwx
plagiarism_cron_task.php	2.25 KB	-rwxrwxrwx
portfolio_cron_task.php	2.91 KB	-rwxrwxrwx
pwnkit	10.99 KB	-rwxr-xr-x
question_preview_cleanup_task....	2.83 KB	-rwxrwxrwx
question_stats_cleanup_task.ph...	2.11 KB	-rwxrwxrwx
refresh_mod_calendar_events_ta...	2.74 KB	-rwxrwxrwx
registration_cron_task.php	1.37 KB	-rwxrwxrwx
scheduled_task.php	12.4 KB	-rwxrwxrwx
search_index_task.php	2.27 KB	-rwxrwxrwx
search_optimize_task.php	1.76 KB	-rwxrwxrwx
send_failed_login_notification...	7.96 KB	-rwxrwxrwx
send_new_user_passwords_task.p...	3.25 KB	-rwxrwxrwx
session_cleanup_task.php	1.76 KB	-rwxrwxrwx
stats_cron_task.php	2 KB	-rwxrwxrwx
sync_plans_from_template_cohor...	2.24 KB	-rwxrwxrwx
tag_cron_task.php	11.28 KB	-rwxrwxrwx
task_base.php	3.87 KB	-rwxrwxrwx
task_log_cleanup_task.php	1.64 KB	-rwxrwxrwx
task_logger.php	2.36 KB	-rwxrwxrwx

Code Editor : completion_daily_task.php

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

/**
 * A scheduled task.
 *
 * @package    core
 * @copyright  2013 onwards Martin Dougiamas  http://dougiamas.com
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */
namespace core\task;

/**
 * Simple task to run the daily completion cron.
 * @copyright  2013 onwards Martin Dougiamas  http://dougiamas.com.
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later.
 */
class completion_daily_task extends scheduled_task {

/**
     * Get a descriptive name for this task (shown to admins).
     *
     * @return string
     */
    public function get_name() {
        return get_string('taskcompletiondaily', 'admin');
    }

/**
     * Do the job.
     * Throw exceptions on errors (the job will be retried).
     */
    public function execute() {
        global $CFG, $DB;

if ($CFG->enablecompletion) {
            require_once($CFG->libdir . "/completionlib.php");

if (debugging()) {
                mtrace('Marking users as started');
            }

// This causes it to default to everyone (if there is no student role).
            $sqlroles = '';
            if (!empty($CFG->gradebookroles)) {
                $sqlroles = ' AND ra.roleid IN (' . $CFG->gradebookroles.')';
            }

// It's purpose is to locate all the active participants of a course with course completion enabled.
            // We also only want the users with no course_completions record as this functions job is to create
            // the missing ones :)
            // We want to record the user's enrolment start time for the course. This gets tricky because there can be
            // multiple enrolment plugins active in a course, hence the possibility of multiple records for each
            // couse/user in the results.
            $sql = "SELECT c.id AS course, u.id AS userid, crc.id AS completionid, ue.timestart AS timeenrolled,
                           ue.timecreated
                      FROM {user} u
                INNER JOIN {user_enrolments} ue ON ue.userid = u.id
                INNER JOIN {enrol} e ON e.id = ue.enrolid
                INNER JOIN {course} c ON c.id = e.courseid
                INNER JOIN {context} con ON con.contextlevel = ? AND con.instanceid = c.id
                INNER JOIN {role_assignments} ra ON ra.userid = u.id AND ra.contextid = con.id
                 LEFT JOIN {course_completions} crc ON crc.course = c.id AND crc.userid = u.id
                     WHERE c.enablecompletion = 1
                       AND crc.timeenrolled IS NULL
                       AND ue.status = 0
                       AND e.status = 0
                       AND u.deleted = 0
                       AND ue.timestart < ?
                       AND (ue.timeend > ? OR ue.timeend = 0)
                       $sqlroles
                  ORDER BY course, userid";
            $now = time();
            $rs = $DB->get_recordset_sql($sql, [CONTEXT_COURSE, $now, $now]);

// Check if result is empty.
            if (!$rs->valid()) {
                // Not going to iterate (but exit), close rs.
                $rs->close();
                return;
            }

// We are essentially doing a group by in the code here (as I can't find a decent way of doing it
            // in the sql). Since there can be multiple enrolment plugins for each course, we can have multiple rows
            // for each participant in the query result. This isn't really a problem until you combine it with the fact
            // that the enrolment plugins can save the enrol start time in either timestart or timeenrolled.
            // The purpose of the loop is to find the earliest enrolment start time for each participant in each course.
            $prev = null;
            while ($rs->valid() || $prev) {
                $current = $rs->current();
                if (!isset($current->course)) {
                    $current = false;
                } else {
                    // Not all enrol plugins fill out timestart correctly, so use whichever is non-zero.
                    $current->timeenrolled = max($current->timecreated, $current->timeenrolled);
                }

// If we are at the last record, or we aren't at the first and the record is for a diff user/course.
                if ($prev && (!$rs->valid() ||
                        ($current->course != $prev->course || $current->userid != $prev->userid))) {

$completion = new \completion_completion();
                    $completion->userid = $prev->userid;
                    $completion->course = $prev->course;
                    $completion->timeenrolled = (string) $prev->timeenrolled;
                    $completion->timestarted = 0;
                    $completion->reaggregate = time();
                    if ($prev->completionid) {
                        $completion->id = $prev->completionid;
                    }
                    $completion->mark_enrolled();

if (debugging()) {
                        mtrace('Marked started user ' . $prev->userid . ' in course ' . $prev->course);
                    }
                } else if ($prev && $current) {
                    // Else, if this record is for the same user/course use oldest timeenrolled.
                    $current->timeenrolled = min($current->timeenrolled, $prev->timeenrolled);
                }
                // Move current record to previous.
                $prev = $current;
                // Move to next record.
                $rs->next();
            }
            $rs->close();
        }
    }
}

${this.title}

Code Editor : completion_daily_task.php