72 lines
2.4 KiB
PHP
72 lines
2.4 KiB
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 for storing issued certificates.
|
|
*
|
|
* @package local_certlog
|
|
* @copyright 2017 Mark Nelson <markn@moodle.com>, 2021 Klaus-Uwe Mitterer <kumitterer@kumi.systems>
|
|
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
|
|
*/
|
|
namespace local_certlog\task;
|
|
|
|
defined('MOODLE_INTERNAL') || die();
|
|
|
|
/**
|
|
* A scheduled task for storing issued certificates.
|
|
*
|
|
* @package local_certlog
|
|
* @copyright 2017 Mark Nelson <markn@moodle.com>, 2021 Klaus-Uwe Mitterer <kumitterer@kumi.systems>
|
|
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
|
|
*/
|
|
class get_issues_task extends \core\task\scheduled_task {
|
|
|
|
/**
|
|
* Get a descriptive name for this task (shown to admins).
|
|
*
|
|
* @return string
|
|
*/
|
|
public function get_name() {
|
|
return get_string('taskgetissues', 'local_certlog');
|
|
}
|
|
|
|
/**
|
|
* Execute.
|
|
*/
|
|
public function execute() {
|
|
global $DB, $PAGE;
|
|
|
|
foreach (array("customcert", "htmlcert") as $module) {
|
|
$issuetable = $module . '_issues';
|
|
$certidfield = $module . 'id';
|
|
$lb = "{";
|
|
$rb = "}";
|
|
$cur = $DB->get_field("certlog", "MAX(originid)", array("originname" => $module)) ?: 0;
|
|
|
|
$sql = "SELECT i.id AS originid, i.timecreated AS timestamp,
|
|
m.course AS course, i.userid AS user,
|
|
\"$module\" AS originname
|
|
FROM $lb$issuetable$rb i
|
|
JOIN $lb$module$rb m
|
|
ON i.$certidfield = m.id
|
|
WHERE i.id > :id";
|
|
|
|
$newer = $DB->get_records_sql($sql, array('id' => $cur));
|
|
|
|
$DB->insert_records("certlog", $newer);
|
|
}
|
|
}
|
|
}
|