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

/**

 * MailingLog 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 core_h5p\core;

use dml_exception;

use stdClass;

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

global $CFG;

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

/**

 * Class Mailing

 * @package mod_custommailing

 */

class MailingLog

{

    /**

     * @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_logs', $record);

    }

    /**

     * @param null|array $conditions

     * @return array

     * @throws dml_exception

     */

    public static function getAll($conditions = null) {

        global $DB;

        $records = [];

        $rs = $DB->get_recordset('custommailing_logs', $conditions, 'ORDER BY id');

        foreach ($rs as $record) {

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

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

        }

        $rs->close();

        return $records;

    }

    /**

     * @param int $custommailingid

     * @return array

     * @throws dml_exception

     */

    public static function getAllForTable(int $custommailingid) {

        global $DB;

        $user_name_fields_raw = \core_user\fields::get_name_fields();

        foreach ($user_name_fields_raw as $field) {

            $field = 'u.' . $field . ' as user_' . $field;

        }

        $user_name_fields = implode(', ', $user_name_fields_raw);

        $records = [];

        $sql = "SELECT cl.id, cm.mailingname, u.id AS user_id, $user_name_fields, u.email AS user_email, cl.timecreated, cl.emailstatus

                FROM {custommailing_logs} cl

                JOIN {custommailing_mailing} cm ON cm.id = cl.custommailingmailingid

                JOIN {user} u ON u.id = cl.emailtouserid

                WHERE cm.custommailingid = :custommailingid

                ORDER BY cl.id DESC";

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

        foreach ($rs as $record) {

            $record = (array) $record;

            $user = new stdClass();

            $log = new stdClass();

            foreach ($record as $property => $value) {

                if (preg_match('/^user\_/', $property)) {

                    $property = preg_replace('/^user\_/','',$property);

                    $user->$property = $value;

                }

                else {

                    $log->$property = $value;

                }

            }

            $log->user = fullname($user) . ' - '. $user->email;

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

        }

        $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_logs', $record);

    }

    /**

     * @param int $userid

     * @throws dml_exception

     */

    public static function deleteByUser(int $userid) {

        global $DB;

        $DB->delete_records('custommailing_logs', ['emailtouserid' => $userid]);

    }

    /**

     * @param stdClass $record

     * @return stdClass

     */

    protected static function format(stdClass $record) {

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

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

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

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

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

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

        return $record;

    }

}