chamilo-lms2/main/inc/lib/events_email.class.php

<?php

/* For licensing terms, see /license.txt */
/**
 * Manages the email sending action when a event requires it.
 * @package chamilo.libraries.events
 */

/**
 * EventsMail class: manages the e-mail sending action when a event requires it
 */
class EventsMail
{

    /**
     * Sends email according to an event
     *
     * @param string $event_name the name of the event that was triggered
     * @param array $event_data what to put in the mail
     *
     * Possible key :
     * - $event_data["about_user"] (= $user_id)
     * - $event_data["prior_lang"]
     *
     * Warning :
     * - $event_data["send_to"] MUST BE an array
     */
    public static function send_mail($event_name, $event_data) {
        /**
         * Global explanation :
         * 1. we get information about the user that fired the event (in $event_data["about_user"])
         * 2. we send mail to people that are in the $event_data["send_to"]
         * 2b. if a language was specified, we use that one to send the mail, else we get the user's language, if there isn't any, we get the english one
         * 3. we do the same with the people associated to the event through the admin panel
         */
        global $event_config;

        // common variable for every mail sent
        $sender_name = api_get_person_name(api_get_setting('administratorName'), api_get_setting('administratorSurname'), null, PERSON_NAME_EMAIL_ADDRESS);
        $email_admin = api_get_setting('emailAdministrator');
        // basic  keys
        $event_data["sitename"] = api_get_setting('siteName');
        $event_data["administrator_name"] = api_get_setting('administratorName');
        $event_data["administrator_surname"] = api_get_setting('administratorSurname');
        $event_data["administrator_phone"] = api_get_setting('administratorTelephone');
        $event_data["administrator_email"] = api_get_setting('emailAdministrator');
        $event_data["portal"] = api_get_path(WEB_PATH);

        // Fill the array's cells with info regarding the user that fired the event
        // (for the keys in the template)
        if (isset($event_data["about_user"])) {
            $about_user = api_get_user_info($event_data["about_user"]);
            $event_data["firstname"] = $about_user["firstname"];
            $event_data["lastname"] = $about_user["lastname"];
            $event_data["username"] = $about_user["username"];
            $event_data["usermail"] = $about_user["mail"];
            $event_data["language"] = $about_user["language"];
            $event_data["user_id"] = $about_user["user_id"];
        }

        // First, we send the mail to people we put in the $event_data["send_to"]
        if ($event_data["send_to"] != null) { // the users we precised need to receive the mail
            foreach ($event_data["send_to"] as $id) { // for every member put in the array
                // get user's info (to know where to send)
                $user_info = api_get_user_info($id);

                // get the language the email will be in
                if ($event_data["prior_lang"] != null) { // if $lang is not null, we use that lang
                    $language = $event_data["prior_lang"];
                } else {  // else we use the user's language
                    $sql = 'SELECT language FROM '.Database::get_main_table(TABLE_MAIN_USER).' u
                    WHERE u.user_id = "'.$id.'"
                    ';
                    $language = Database::store_result(Database::query($sql), 'ASSOC');
                    $language = $language[0]["language"];
                }

                // we get the message in the correct language (or in english if doesn't exist)
                $result = self::getMessage($event_name, $language);
                $message = "";
                $subject = "";
                self::getCorrectMessage($message, $subject, $language, $result);

                // replace the keycodes used in the message
                self::formatMessage($message, $subject, $event_config, $event_name, $event_data);

                // sending email
                $recipient_name = api_get_person_name($user_info['firstname'], $user_info['lastname']);

                // checks if there's a file we need to join to the mail
                if (isset($values["certificate_pdf_file"])) {
                    $message = str_replace("\n", "<br />", $message);
                    @api_mail_html($recipient_name, $user_info["mail"], $subject, $message, $sender_name, $email_admin, null, array($values['certificate_pdf_file']));
                } else {
                    @api_mail_html($recipient_name, $user_info["mail"], $subject, $message, $sender_name, $email_admin);
                }

                // If the mail only need to be send once (we know that thanks to the events.conf), we log it in the table
                if ($event_config[$event_name]["sending_mail_once"]) {
                    $sql = 'INSERT INTO '.Database::get_main_table(TABLE_EVENT_SENT).'
                        (user_from, user_to, event_type_name)
                        VALUES ('.$event_data["user_id"].', '.$id.' ,"'.Database::escape_string($event_name).'");
                        ';
                    Database::query($sql);
                }
            }
        }

        // Second, we send to people linked to the event
        // So, we get everyone
        $sql = 'SELECT u.user_id, u.language, u.email, u.firstname, u.lastname FROM '.Database::get_main_table(TABLE_EVENT_TYPE_REL_USER).' ue
                INNER JOIN '.Database::get_main_table(TABLE_MAIN_USER).' u ON u.user_id = ue.user_id
                WHERE event_type_name = "'.$event_name.'"';
        $result = Database::store_result(Database::query($sql), 'ASSOC');

        foreach ($result as $key => $value) { // for each of the linked users
            // we get the language
            if ($event_data["prior_lang"] != null) { // if $lang is not null, we use that lang
                $language = $event_data["prior_lang"];
            } else { // else we get the user's lang
                $sql = 'SELECT language FROM '.Database::get_main_table(TABLE_MAIN_USER).'
                    where user_id = '.$value["user_id"].' ';
                $result = Database::store_result(Database::query($sql), 'ASSOC');

                $language = $result[0]["language"];
            }

            // we get the message in the correct language (or in english if doesn't exist)
            $result = self::getMessage($event_name, $language);
            $message = "";
            $subject = "";
            self::getCorrectMessage($message, $subject, $language, $result);

            // replace the keycodes used in the message
            self::formatMessage($message, $subject, $event_config, $event_name, $event_data);

            // we send the mail
            $recipient_name = api_get_person_name($value['firstname'], $value['lastname']);

            @api_mail($recipient_name, $value["email"], $subject, $message, $sender_name, $email_admin);

            // If the mail only need to be send once (we know that thanks to the events.conf, we log it in the table
            if ($event_config[$event_name]["sending_mail_once"]) {
                $sql = 'INSERT INTO '.Database::get_main_table(TABLE_EVENT_SENT).'
                    (user_from, user_to, event_type_name)
                    VALUES ('.$event_data["user_id"].', '.$value["user_id"].' , "'.Database::escape_string($event_name).'");
                    ';
                Database::query($sql);
            }
        }
    }

    /**
     * Checks if a message in a language exists, if the event is activated
     * and if "manage event" is checked in admin panel.
     * If yes to three, we can use this class, else we still use api_mail.
     *
     * @param string $event_name
     * @return boolean
     */
    public static function check_if_using_class($event_name) {
        if (api_get_setting('activate_email_template') === 'false') {
            return false;
        }
        $current_language = api_get_interface_language();

        $sql = 'SELECT COUNT(*) as total FROM '.Database::get_main_table(TABLE_EVENT_EMAIL_TEMPLATE).' em
        INNER JOIN '.Database::get_main_table(TABLE_MAIN_LANGUAGE).' l on em.language_id = l.id
        WHERE em.event_type_name = "'.$event_name.'" and l.dokeos_folder = "'.$current_language.'" and em.activated = 1';

        $exists = Database::store_result(Database::query($sql), 'ASSOC');
        if ($exists[0]["total"]) {
            return true;
        } else {
            return false;
        }
    }

    /**
     * Get the record containing the good message and subject
     *
     * @param string $event_name
     * @param string $language
     * @return array
     */
    private static function getMessage($event_name, $language) {
        $sql = 'SELECT message, subject, l.dokeos_folder FROM '.Database::get_main_table(TABLE_EVENT_EMAIL_TEMPLATE).' em
                    INNER JOIN '.Database::get_main_table(TABLE_MAIN_LANGUAGE).' l on em.language_id = l.id
                    WHERE em.event_type_name = "'.$event_name.'" and (l.dokeos_folder = "'.$language.'" OR l.dokeos_folder = "english") and em.message <> ""
                    ';
        return Database::store_result(Database::query($sql), 'ASSOC');
    }

    /**
     * Get the correct message, meaning in the specified language or in english if previous one doesn't exist
     *
     * @param string $message
     * @param string $subject
     * @param string $language
     * @param array $result
     */
    private static function getCorrectMessage(&$message, &$subject, $language, $result) {
        foreach ($result as $msg) {
            if ($msg["dokeos_folder"] == $language) {
                $message = $msg["message"];
                $subject = $msg["subject"];
                break;
            } else if ($msg["dokeos_folder"] == "english") {
                $message = $msg["message"];
                $subject = $msg["subject"];
            }
        }
    }

    /**
     * Replaces the ((key)) by the good values
     *
     * @param string $message
     * @param string $subject
     * @param array $event_config
     * @param string $event_name
     */
    private static function formatMessage(&$message, &$subject, $event_config, $event_name, &$event_data) {
        foreach ($event_config[$event_name]["available_keyvars"] as $key => $word) {
            $message = str_replace('(('.$key.'))', $event_data[$word], $message);
            $subject = str_replace('(('.$key.'))', $event_data[$word], $subject);
        }
    }

}