moodle-mod-customcert/load_template_cli.php

<?php
// This file is part of the customcert module for 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/>.

define('CLI_SCRIPT', true);
require_once('../../config.php');

$tid = $argv[1];
$ltid = $argv[2];

$template = $DB->get_record('customcert_templates', array('id' => $tid), '*', MUST_EXIST);
$template = new \mod_customcert\template($template);

$loadtemplate = $DB->get_record('customcert_templates', array('id' => $ltid), '*', MUST_EXIST);
$loadtemplate = new \mod_customcert\template($loadtemplate);

$cm = $template->get_cm();

if ($template->get_context()->contextlevel == CONTEXT_MODULE) {
    $customcert = $DB->get_record('customcert', ['id' => $cm->instance], '*', MUST_EXIST);
    $title = $customcert->name;
    $heading = format_string($title);
} else {
    $title = $SITE->fullname;
    $heading = $title;
}

$sql = "SELECT e.*
          FROM {customcert_elements} e
          INNER JOIN {customcert_pages} p
          ON e.pageid = p.id
          WHERE p.templateid = :templateid";

if ($elements = $DB->get_records_sql($sql, array('templateid' => $template->get_id()))) {
    foreach ($elements as $element) {
        if ($e = \mod_customcert\element_factory::get_element_instance($element)) {
            $e->delete();
        }
    }
}

$DB->delete_records('customcert_pages', array('templateid' => $template->get_id()));

$loadtemplate->copy_to_template($template->get_id());