Proyectos de Subversion Moodle

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

/**

 * Mailing Class

 *

 * @package    mod_custommailing

 * @author     olivier@cblue.be

 * @copyright  2021 CBlue SPRL

 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later

 */

namespace mod_custommailing;

use dml_exception;

use stdClass;

defined('MOODLE_INTERNAL') || die();

global $CFG;

require_once $CFG->dirroot . '/mod/custommailing/lib.php';

/**

 * Class Mailing

 * @package mod_custommailing

 *

 * @property int id

 * @property int custommailingid

 * @property string mailingname

 * @property string mailinglang

 * @property string mailingsubject

 * @property string mailingcontent

 * @property int mailingcontentformat

 * @property int mailingmodle

 * @property int mailingdelay

 * @property int mailingstatus

 * @property int targetmoduleid

 * @property int customcertmoduleid

 * @property int starttime

 * @property int timecreated

 * @property int timemodified

 */

class Mailing {

    /**

     * @param stdClass $record

     * @return bool|int

     * @throws dml_exception

     */

    public static function create(stdClass $record) {

        global $DB;

        $record->timecreated = $record->timemodified = time();

        return $DB->insert_record('custommailing_mailing', $record);

    }

    /**

     * @param int $id

     * @return stdClass

     * @throws dml_exception

     */

    public static function get(int $id) {

        global $DB;

        $record = $DB->get_record('custommailing_mailing', ['id' => $id], '*', MUST_EXIST);

        $record = Mailing::format($record);

        return $record;

    }

    /**

     * @param int $id

     * @return stdClass

     * @throws dml_exception

     */

    public static function getWithCourse(int $id) {

        global $DB;

        $sql = "SELECT cm.*, c.course as courseid

                FROM {custommailing_mailing} cm

                JOIN {custommailing} c ON c.id = cm.custommailingid

                ";

        $record = $DB->get_record_sql($sql, ['id' => $id]);

        $record = Mailing::format($record);

        return $record;

    }

    /**

     * @param int $custommailing_id

     * @return stdClass[]

     * @throws dml_exception

     */

    public static function getAll(int $custommailing_id) {

        global $DB;

        $records = [];

        $rs = $DB->get_recordset('custommailing_mailing', ['custommailingid' => $custommailing_id], 'id ASC');

        foreach ($rs as $record) {

            $record = Mailing::format($record);

            $records[$record->id] = $record;

        }

        $rs->close();

        return $records;

    }

    /**

     * @param stdClass $record

     * @return bool

     * @throws dml_exception

     */

    public static function update(stdClass $record) {

        global $DB;

        $record->timemodified = time();

        return $DB->update_record('custommailing_mailing', $record);

    }

    /**

     * @param int $id

     * @throws dml_exception

     */

    public static function delete(int $id) {

        global $DB;

        $DB->delete_records('custommailing_logs', ['custommailingmailingid' => $id]);

        $DB->delete_records('custommailing_mailing', ['id' => $id]);

    }

    /**

     * @param int $custommailing_id

     * @throws dml_exception

     */

    public static function deleteAll(int $custommailing_id) {

        foreach (Mailing::getAll($custommailing_id) as $mailing) {

            Mailing::delete($mailing->id);

        }

    }

    /**

     * @return array

     * @throws dml_exception

     */

    public static function getAllToSend() {

        global $DB;

        $records = [];

        $sql = "SELECT cm.*, c.course as courseid

                FROM {custommailing_mailing} cm

                JOIN {custommailing} c ON c.id = cm.custommailingid

                ";

        $rs = $DB->get_recordset_sql($sql, ['mailingstatus' => MAILING_STATUS_ENABLED]);

        foreach ($rs as $record) {

            $record = Mailing::format($record);

            $records[$record->id] = $record;

        }

        $rs->close();

        return $records;

    }

    /**

     * @param stdClass $record

     * @return stdClass

     */

    protected static function format(stdClass $record) {

        $record->id = (int) $record->id;

        $record->custommailingid = (int) $record->custommailingid;

        $record->mailingcontentformat = (int) $record->mailingcontentformat;

        $record->mailingmode = (int) $record->mailingmode;

        $record->mailingdelay = (int) $record->mailingdelay;

        $record->mailingstatus = (bool) $record->mailingstatus;

        $record->retroactive = (bool) $record->retroactive;

        $record->targetmoduleid = (int) $record->targetmoduleid;

        $record->targetmodulestatus = (int) $record->targetmodulestatus;

        $record->customcertmoduleid = empty($record->customcertmoduleid) ? null : (int) $record->customcertmoduleid;

        $record->starttime = (int) $record->starttime;

        $record->timecreated = (int) $record->timecreated;

        $record->timemodified = (int) $record->timemodified;

        return $record;

    }

}