123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230 |
- <?php
- class EventsMail
- {
-
- public static function send_mail($event_name, $event_data) {
-
- global $event_config;
-
- $sender_name = api_get_person_name(api_get_setting('platform.administrator_name'), api_get_setting('platform.administrator_surname'), null, PERSON_NAME_EMAIL_ADDRESS);
- $email_admin = api_get_setting('platform.administrator_email');
-
- $event_data["sitename"] = api_get_setting('platform.site_name');
- $event_data["administrator_name"] = api_get_setting('platform.administrator_name');
- $event_data["administrator_surname"] = api_get_setting('platform.administrator_surname');
- $event_data["administrator_phone"] = api_get_setting('administratorTelephone');
- $event_data["administrator_email"] = api_get_setting('platform.administrator_email');
- $event_data["portal"] = api_get_path(WEB_PATH);
-
-
- 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"];
- }
-
- if ($event_data["send_to"] != null) {
- foreach ($event_data["send_to"] as $id) {
-
- $user_info = api_get_user_info($id);
-
- if ($event_data["prior_lang"] != null) {
- $language = $event_data["prior_lang"];
- } else {
- $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"];
- }
-
- $result = self::getMessage($event_name, $language);
- $message = "";
- $subject = "";
- self::getCorrectMessage($message, $subject, $language, $result);
-
- self::formatMessage($message, $subject, $event_config, $event_name, $event_data);
-
- $recipient_name = api_get_person_name($user_info['firstname'], $user_info['lastname']);
-
- 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 ($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);
- }
- }
- }
-
-
- $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) {
-
- if ($event_data["prior_lang"] != null) {
- $language = $event_data["prior_lang"];
- } else {
- $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"];
- }
-
- $result = self::getMessage($event_name, $language);
- $message = "";
- $subject = "";
- self::getCorrectMessage($message, $subject, $language, $result);
-
- self::formatMessage($message, $subject, $event_config, $event_name, $event_data);
-
- $recipient_name = api_get_person_name($value['firstname'], $value['lastname']);
- @api_mail($recipient_name, $value["email"], $subject, $message, $sender_name, $email_admin);
-
- 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);
- }
- }
- }
-
- 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;
- }
- }
-
- 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');
- }
-
- 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"];
- }
- }
- }
-
- 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);
- }
- }
- }
|