Merge branch 'MDL-71708' of https://github.com/lostrogit/moodle
[moodle.git] / message / classes / helper.php
blob1396d8f38c90be1910dff516fa896f1f075535de
1 <?php
2 // This file is part of Moodle - http://moodle.org/
3 //
4 // Moodle is free software: you can redistribute it and/or modify
5 // it under the terms of the GNU General Public License as published by
6 // the Free Software Foundation, either version 3 of the License, or
7 // (at your option) any later version.
8 //
9 // Moodle is distributed in the hope that it will be useful,
10 // but WITHOUT ANY WARRANTY; without even the implied warranty of
11 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 // GNU General Public License for more details.
14 // You should have received a copy of the GNU General Public License
15 // along with Moodle. If not, see <http://www.gnu.org/licenses/>.
17 /**
18 * Contains helper class for the message area.
20 * @package core_message
21 * @copyright 2016 Mark Nelson <markn@moodle.com>
22 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
25 namespace core_message;
26 use DOMDocument;
28 defined('MOODLE_INTERNAL') || die();
30 require_once($CFG->dirroot . '/message/lib.php');
32 /**
33 * Helper class for the message area.
35 * @copyright 2016 Mark Nelson <markn@moodle.com>
36 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
38 class helper {
40 /**
41 * @deprecated since 3.6
43 public static function get_messages() {
44 throw new \coding_exception('\core_message\helper::get_messages has been removed.');
47 /**
48 * Helper function to retrieve conversation messages.
50 * @param int $userid The current user.
51 * @param int $convid The conversation identifier.
52 * @param int $timedeleted The time the message was deleted
53 * @param int $limitfrom Return a subset of records, starting at this point (optional).
54 * @param int $limitnum Return a subset comprising this many records in total (optional, required if $limitfrom is set).
55 * @param string $sort The column name to order by including optionally direction.
56 * @param int $timefrom The time from the message being sent.
57 * @param int $timeto The time up until the message being sent.
58 * @return array of messages
60 public static function get_conversation_messages(int $userid, int $convid, int $timedeleted = 0, int $limitfrom = 0,
61 int $limitnum = 0, string $sort = 'timecreated ASC', int $timefrom = 0,
62 int $timeto = 0) : array {
63 global $DB;
65 $sql = "SELECT m.id, m.useridfrom, m.subject, m.fullmessage, m.fullmessagehtml,
66 m.fullmessageformat, m.fullmessagetrust, m.smallmessage, m.timecreated,
67 mc.contextid, muaread.timecreated AS timeread
68 FROM {message_conversations} mc
69 INNER JOIN {messages} m
70 ON m.conversationid = mc.id
71 LEFT JOIN {message_user_actions} muaread
72 ON (muaread.messageid = m.id
73 AND muaread.userid = :userid1
74 AND muaread.action = :readaction)";
75 $params = ['userid1' => $userid, 'readaction' => api::MESSAGE_ACTION_READ, 'convid' => $convid];
77 if (empty($timedeleted)) {
78 $sql .= " LEFT JOIN {message_user_actions} mua
79 ON (mua.messageid = m.id
80 AND mua.userid = :userid2
81 AND mua.action = :deleteaction
82 AND mua.timecreated is NOT NULL)";
83 } else {
84 $sql .= " INNER JOIN {message_user_actions} mua
85 ON (mua.messageid = m.id
86 AND mua.userid = :userid2
87 AND mua.action = :deleteaction
88 AND mua.timecreated = :timedeleted)";
89 $params['timedeleted'] = $timedeleted;
92 $params['userid2'] = $userid;
93 $params['deleteaction'] = api::MESSAGE_ACTION_DELETED;
95 $sql .= " WHERE mc.id = :convid";
97 if (!empty($timefrom)) {
98 $sql .= " AND m.timecreated >= :timefrom";
99 $params['timefrom'] = $timefrom;
102 if (!empty($timeto)) {
103 $sql .= " AND m.timecreated <= :timeto";
104 $params['timeto'] = $timeto;
107 if (empty($timedeleted)) {
108 $sql .= " AND mua.id is NULL";
111 $sql .= " ORDER BY m.$sort";
113 $messages = $DB->get_records_sql($sql, $params, $limitfrom, $limitnum);
115 return $messages;
119 * Helper function to return a conversation messages with the involved members (only the ones
120 * who have sent any of these messages).
122 * @param int $userid The current userid.
123 * @param int $convid The conversation id.
124 * @param array $messages The formated array messages.
125 * @return array A conversation array with the messages and the involved members.
127 public static function format_conversation_messages(int $userid, int $convid, array $messages) : array {
128 global $USER;
130 // Create the conversation array.
131 $conversation = array(
132 'id' => $convid,
135 // Store the messages.
136 $arrmessages = array();
138 foreach ($messages as $message) {
139 // Store the message information.
140 $msg = new \stdClass();
141 $msg->id = $message->id;
142 $msg->useridfrom = $message->useridfrom;
143 $msg->text = message_format_message_text($message);
144 $msg->timecreated = $message->timecreated;
145 $arrmessages[] = $msg;
147 // Add the messages to the conversation.
148 $conversation['messages'] = $arrmessages;
150 // Get the users who have sent any of the $messages.
151 $memberids = array_unique(array_map(function($message) {
152 return $message->useridfrom;
153 }, $messages));
155 if (!empty($memberids)) {
156 // Get members information.
157 $conversation['members'] = self::get_member_info($userid, $memberids);
158 } else {
159 $conversation['members'] = array();
162 return $conversation;
166 * @deprecated since 3.6
168 public static function create_messages() {
169 throw new \coding_exception('\core_message\helper::create_messages has been removed.');
173 * Helper function for creating a contact object.
175 * @param \stdClass $contact
176 * @param string $prefix
177 * @return \stdClass
179 public static function create_contact($contact, $prefix = '') {
180 global $PAGE;
182 // Create the data we are going to pass to the renderable.
183 $userfields = \user_picture::unalias($contact, array('lastaccess'), $prefix . 'id', $prefix);
184 $data = new \stdClass();
185 $data->userid = $userfields->id;
186 $data->useridfrom = null;
187 $data->fullname = fullname($userfields);
188 // Get the user picture data.
189 $userpicture = new \user_picture($userfields);
190 $userpicture->size = 1; // Size f1.
191 $data->profileimageurl = $userpicture->get_url($PAGE)->out(false);
192 $userpicture->size = 0; // Size f2.
193 $data->profileimageurlsmall = $userpicture->get_url($PAGE)->out(false);
194 // Store the message if we have it.
195 $data->ismessaging = false;
196 $data->lastmessage = null;
197 $data->lastmessagedate = null;
198 $data->messageid = null;
199 if (isset($contact->smallmessage)) {
200 $data->ismessaging = true;
201 // Strip the HTML tags from the message for displaying in the contact area.
202 $data->lastmessage = clean_param($contact->smallmessage, PARAM_NOTAGS);
203 $data->lastmessagedate = $contact->timecreated;
204 $data->useridfrom = $contact->useridfrom;
205 if (isset($contact->messageid)) {
206 $data->messageid = $contact->messageid;
209 $data->isonline = null;
210 $user = \core_user::get_user($data->userid);
211 if (self::show_online_status($user)) {
212 $data->isonline = self::is_online($userfields->lastaccess);
214 $data->isblocked = isset($contact->blocked) ? (bool) $contact->blocked : false;
215 $data->isread = isset($contact->isread) ? (bool) $contact->isread : false;
216 $data->unreadcount = isset($contact->unreadcount) ? $contact->unreadcount : null;
217 $data->conversationid = $contact->conversationid ?? null;
219 return $data;
223 * Helper function for checking if we should show the user's online status.
225 * @param \stdClass $user
226 * @return boolean
228 public static function show_online_status($user) {
229 global $CFG;
231 require_once($CFG->dirroot . '/user/lib.php');
233 if ($lastaccess = user_get_user_details($user, null, array('lastaccess'))) {
234 if (isset($lastaccess['lastaccess'])) {
235 return true;
239 return false;
243 * Helper function for checking the time meets the 'online' condition.
245 * @param int $lastaccess
246 * @return boolean
248 public static function is_online($lastaccess) {
249 global $CFG;
251 // Variable to check if we consider this user online or not.
252 $timetoshowusers = 300; // Seconds default.
253 if (isset($CFG->block_online_users_timetosee)) {
254 $timetoshowusers = $CFG->block_online_users_timetosee * 60;
256 $time = time() - $timetoshowusers;
258 return $lastaccess >= $time;
262 * Get providers preferences.
264 * @param array $providers
265 * @param int $userid
266 * @return \stdClass
268 public static function get_providers_preferences($providers, $userid) {
269 $preferences = new \stdClass();
271 // Get providers preferences.
272 foreach ($providers as $provider) {
273 $linepref = get_user_preferences('message_provider_' . $provider->component . '_' . $provider->name
274 . '_enabled', '', $userid);
275 if ($linepref == '') {
276 continue;
278 $lineprefarray = explode(',', $linepref);
279 $preferences->{$provider->component.'_'.$provider->name.'_enabled'} = [];
280 foreach ($lineprefarray as $pref) {
281 $preferences->{$provider->component.'_'.$provider->name.'_enabled'}[$pref] = 1;
286 return $preferences;
290 * Requires the JS libraries for the toggle contact button.
292 * @return void
294 public static function togglecontact_requirejs() {
295 global $PAGE;
297 static $done = false;
298 if ($done) {
299 return;
302 $PAGE->requires->js_call_amd('core_message/toggle_contact_button', 'enhance', array('#toggle-contact-button'));
303 $done = true;
307 * Returns the attributes to place on a contact button.
309 * @param object $user User object.
310 * @param bool $iscontact
311 * @return array
313 public static function togglecontact_link_params($user, $iscontact = false) {
314 global $USER;
315 $params = array(
316 'data-currentuserid' => $USER->id,
317 'data-userid' => $user->id,
318 'data-is-contact' => $iscontact,
319 'id' => 'toggle-contact-button',
320 'role' => 'button',
321 'class' => 'ajax-contact-button',
324 return $params;
328 * Requires the JS libraries for the message user button.
330 * @return void
332 public static function messageuser_requirejs() {
333 global $PAGE;
335 static $done = false;
336 if ($done) {
337 return;
340 $PAGE->requires->js_call_amd('core_message/message_user_button', 'send', array('#message-user-button'));
341 $done = true;
345 * Returns the attributes to place on the message user button.
347 * @param int $useridto
348 * @return array
350 public static function messageuser_link_params(int $useridto) : array {
351 global $USER;
353 return [
354 'id' => 'message-user-button',
355 'role' => 'button',
356 'data-conversationid' => api::get_conversation_between_users([$USER->id, $useridto]),
357 'data-userid' => $useridto,
362 * Returns the conversation hash between users for easy look-ups in the DB.
364 * @param array $userids
365 * @return string
367 public static function get_conversation_hash(array $userids) {
368 sort($userids);
370 return sha1(implode('-', $userids));
374 * Returns the cache key for the time created value of the last message of this conversation.
376 * @param int $convid The conversation identifier.
377 * @return string The key.
379 public static function get_last_message_time_created_cache_key(int $convid) {
380 return $convid;
384 * Checks if legacy messages exist for a given user.
386 * @param int $userid
387 * @return bool
389 public static function legacy_messages_exist($userid) {
390 global $DB;
392 $sql = "SELECT id
393 FROM {message} m
394 WHERE useridfrom = ?
395 OR useridto = ?";
396 $messageexists = $DB->record_exists_sql($sql, [$userid, $userid]);
398 $sql = "SELECT id
399 FROM {message_read} m
400 WHERE useridfrom = ?
401 OR useridto = ?";
402 $messagereadexists = $DB->record_exists_sql($sql, [$userid, $userid]);
404 return $messageexists || $messagereadexists;
408 * Returns conversation member info for the supplied users, relative to the supplied referenceuserid.
410 * This is the basic structure used when returning members, and includes information about the relationship between each member
411 * and the referenceuser, such as a whether the referenceuser has marked the member as a contact, or has blocked them.
413 * @param int $referenceuserid the id of the user which check contact and blocked status.
414 * @param array $userids
415 * @param bool $includecontactrequests Do we want to include contact requests with this data?
416 * @param bool $includeprivacyinfo Do we want to include whether the user can message another, and if the user
417 * requires a contact.
418 * @return array the array of objects containing member info, indexed by userid.
419 * @throws \coding_exception
420 * @throws \dml_exception
422 public static function get_member_info(int $referenceuserid, array $userids, bool $includecontactrequests = false,
423 bool $includeprivacyinfo = false) : array {
424 global $DB, $PAGE;
426 // Prevent exception being thrown when array is empty.
427 if (empty($userids)) {
428 return [];
431 list($useridsql, $usersparams) = $DB->get_in_or_equal($userids);
432 $userfieldsapi = \core_user\fields::for_userpic()->including('lastaccess');
433 $userfields = $userfieldsapi->get_sql('u', false, '', '', false)->selects;
434 $userssql = "SELECT $userfields, u.deleted, mc.id AS contactid, mub.id AS blockedid
435 FROM {user} u
436 LEFT JOIN {message_contacts} mc
437 ON ((mc.userid = ? AND mc.contactid = u.id) OR (mc.userid = u.id AND mc.contactid = ?))
438 LEFT JOIN {message_users_blocked} mub
439 ON (mub.userid = ? AND mub.blockeduserid = u.id)
440 WHERE u.id $useridsql";
441 $usersparams = array_merge([$referenceuserid, $referenceuserid, $referenceuserid], $usersparams);
442 $otherusers = $DB->get_records_sql($userssql, $usersparams);
444 $members = [];
445 foreach ($otherusers as $member) {
446 // Set basic data.
447 $data = new \stdClass();
448 $data->id = $member->id;
449 $data->fullname = fullname($member);
451 // Create the URL for their profile.
452 $profileurl = new \moodle_url('/user/profile.php', ['id' => $member->id]);
453 $data->profileurl = $profileurl->out(false);
455 // Set the user picture data.
456 $userpicture = new \user_picture($member);
457 $userpicture->size = 1; // Size f1.
458 $data->profileimageurl = $userpicture->get_url($PAGE)->out(false);
459 $userpicture->size = 0; // Size f2.
460 $data->profileimageurlsmall = $userpicture->get_url($PAGE)->out(false);
462 // Set online status indicators.
463 $data->isonline = false;
464 $data->showonlinestatus = false;
465 if (!$member->deleted) {
466 $data->isonline = self::show_online_status($member) ? self::is_online($member->lastaccess) : null;
467 $data->showonlinestatus = is_null($data->isonline) ? false : true;
470 // Set contact and blocked status indicators.
471 $data->iscontact = ($member->contactid) ? true : false;
473 // We don't want that a user has been blocked if they can message the user anyways.
474 $canmessageifblocked = api::can_send_message($referenceuserid, $member->id, true);
475 $data->isblocked = ($member->blockedid && !$canmessageifblocked) ? true : false;
477 $data->isdeleted = ($member->deleted) ? true : false;
479 $data->requirescontact = null;
480 $data->canmessage = null;
481 $data->canmessageevenifblocked = null;
482 if ($includeprivacyinfo) {
483 $privacysetting = api::get_user_privacy_messaging_preference($member->id);
484 $data->requirescontact = $privacysetting == api::MESSAGE_PRIVACY_ONLYCONTACTS;
486 // Here we check that if the sender wanted to block the recipient, the
487 // recipient would still be able to message them regardless.
488 $data->canmessageevenifblocked = !$data->isdeleted && $canmessageifblocked;
489 $data->canmessage = !$data->isdeleted && api::can_send_message($member->id, $referenceuserid);
492 // Populate the contact requests, even if we don't need them.
493 $data->contactrequests = [];
495 $members[$data->id] = $data;
498 // Check if we want to include contact requests as well.
499 if (!empty($members) && $includecontactrequests) {
500 list($useridsql, $usersparams) = $DB->get_in_or_equal($userids);
502 $wheresql = "(userid $useridsql AND requesteduserid = ?) OR (userid = ? AND requesteduserid $useridsql)";
503 $params = array_merge($usersparams, [$referenceuserid, $referenceuserid], $usersparams);
504 if ($contactrequests = $DB->get_records_select('message_contact_requests', $wheresql, $params,
505 'timecreated ASC, id ASC')) {
506 foreach ($contactrequests as $contactrequest) {
507 if (isset($members[$contactrequest->userid])) {
508 $members[$contactrequest->userid]->contactrequests[] = $contactrequest;
510 if (isset($members[$contactrequest->requesteduserid])) {
511 $members[$contactrequest->requesteduserid]->contactrequests[] = $contactrequest;
517 // Remove any userids not in $members. This can happen in the case of a user who has been deleted
518 // from the Moodle database table (which can happen in earlier versions of Moodle).
519 $userids = array_filter($userids, function($userid) use ($members) {
520 return isset($members[$userid]);
523 // Return member information in the same order as the userids originally provided.
524 $members = array_replace(array_flip($userids), $members);
526 return $members;
529 * @deprecated since 3.6
531 public static function get_conversations_legacy_formatter() {
532 throw new \coding_exception('\core_message\helper::get_conversations_legacy_formatter has been removed.');
536 * Renders the messaging widget.
538 * @param bool $isdrawer Are we are rendering the drawer or is this on a full page?
539 * @param int|null $sendtouser The ID of the user we want to send a message to
540 * @param int|null $conversationid The ID of the conversation we want to load
541 * @param string|null $view The first view to load in the message widget
542 * @return string The HTML.
544 public static function render_messaging_widget(
545 bool $isdrawer,
546 int $sendtouser = null,
547 int $conversationid = null,
548 string $view = null
550 global $USER, $CFG, $PAGE;
552 // Early bail out conditions.
553 if (empty($CFG->messaging) || !isloggedin() || isguestuser() || \core_user::awaiting_action()) {
554 return '';
557 $renderer = $PAGE->get_renderer('core');
558 $requestcount = \core_message\api::get_received_contact_requests_count($USER->id);
559 $contactscount = \core_message\api::count_contacts($USER->id);
561 $choices = [];
562 $choices[] = [
563 'value' => \core_message\api::MESSAGE_PRIVACY_ONLYCONTACTS,
564 'text' => get_string('contactableprivacy_onlycontacts', 'message')
566 $choices[] = [
567 'value' => \core_message\api::MESSAGE_PRIVACY_COURSEMEMBER,
568 'text' => get_string('contactableprivacy_coursemember', 'message')
570 if (!empty($CFG->messagingallusers)) {
571 // Add the MESSAGE_PRIVACY_SITE option when site-wide messaging between users is enabled.
572 $choices[] = [
573 'value' => \core_message\api::MESSAGE_PRIVACY_SITE,
574 'text' => get_string('contactableprivacy_site', 'message')
578 // Enter to send.
579 $entertosend = get_user_preferences('message_entertosend', $CFG->messagingdefaultpressenter, $USER);
581 $notification = '';
582 if (!get_user_preferences('core_message_migrate_data', false)) {
583 $notification = get_string('messagingdatahasnotbeenmigrated', 'message');
586 if ($isdrawer) {
587 $template = 'core_message/message_drawer';
588 $messageurl = new \moodle_url('/message/index.php');
589 } else {
590 $template = 'core_message/message_index';
591 $messageurl = null;
594 $templatecontext = [
595 'contactrequestcount' => $requestcount,
596 'loggedinuser' => [
597 'id' => $USER->id,
598 'midnight' => usergetmidnight(time())
600 // The starting timeout value for message polling.
601 'messagepollmin' => $CFG->messagingminpoll ?? MESSAGE_DEFAULT_MIN_POLL_IN_SECONDS,
602 // The maximum value that message polling timeout can reach.
603 'messagepollmax' => $CFG->messagingmaxpoll ?? MESSAGE_DEFAULT_MAX_POLL_IN_SECONDS,
604 // The timeout to reset back to after the max polling time has been reached.
605 'messagepollaftermax' => $CFG->messagingtimeoutpoll ?? MESSAGE_DEFAULT_TIMEOUT_POLL_IN_SECONDS,
606 'contacts' => [
607 'sectioncontacts' => [
608 'placeholders' => array_fill(0, $contactscount > 50 ? 50 : $contactscount, true)
610 'sectionrequests' => [
611 'placeholders' => array_fill(0, $requestcount > 50 ? 50 : $requestcount, true)
614 'settings' => [
615 'privacy' => $choices,
616 'entertosend' => $entertosend
618 'overview' => [
619 'messageurl' => $messageurl,
620 'notification' => $notification
622 'isdrawer' => $isdrawer,
623 'showemojipicker' => !empty($CFG->allowemojipicker),
624 'messagemaxlength' => api::MESSAGE_MAX_LENGTH,
625 'caneditownmessageprofile' => has_capability('moodle/user:editownmessageprofile', \context_system::instance())
628 if ($sendtouser || $conversationid) {
629 $route = [
630 'path' => 'view-conversation',
631 'params' => $conversationid ? [$conversationid] : [null, 'create', $sendtouser]
633 } else if ($view === 'contactrequests') {
634 $route = [
635 'path' => 'view-contacts',
636 'params' => ['requests']
638 } else {
639 $route = null;
642 $templatecontext['route'] = json_encode($route);
644 return $renderer->render_from_template($template, $templatecontext);
648 * Returns user details for a user, if they are visible to the current user in the message search.
650 * This method checks the visibility of a user specifically for the purpose of inclusion in the message search results.
651 * Visibility depends on the site-wide messaging setting 'messagingallusers':
652 * If enabled, visibility depends only on the core notion of visibility; a visible site or course profile.
653 * If disabled, visibility requires that the user be sharing a course with the searching user, and have a visible profile there.
654 * The current user is always returned.
656 * You can use the $userfields parameter to reduce the amount of a user record that is required by the method.
657 * The minimum user fields are:
658 * * id
659 * * deleted
660 * * all potential fullname fields
662 * @param \stdClass $user
663 * @param array $userfields An array of userfields to be returned, the values must be a
664 * subset of user_get_default_fields (optional)
665 * @return array the array of userdetails, if visible, or an empty array otherwise.
667 public static function search_get_user_details(\stdClass $user, array $userfields = []) : array {
668 global $CFG, $USER;
669 require_once($CFG->dirroot . '/user/lib.php');
671 if ($CFG->messagingallusers || $user->id == $USER->id) {
672 return \user_get_user_details_courses($user, $userfields) ?? []; // This checks visibility of site and course profiles.
673 } else {
674 // Messaging specific: user must share a course with the searching user AND have a visible profile there.
675 $sharedcourses = enrol_get_shared_courses($USER, $user);
676 foreach ($sharedcourses as $course) {
677 if (user_can_view_profile($user, $course)) {
678 $userdetails = user_get_user_details($user, $course, $userfields);
679 if (!is_null($userdetails)) {
680 return $userdetails;
685 return [];
689 * Prevent unclosed HTML elements in a message.
691 * @param string $message The html message.
692 * @param bool $removebody True if we want to remove tag body.
693 * @return string The html properly structured.
695 public static function prevent_unclosed_html_tags(
696 string $message,
697 bool $removebody = false
698 ) : string {
699 $html = '';
700 if (!empty($message)) {
701 $doc = new DOMDocument();
702 $olderror = libxml_use_internal_errors(true);
703 $doc->loadHTML('<?xml version="1.0" encoding="UTF-8" ?>' . $message);
704 libxml_clear_errors();
705 libxml_use_internal_errors($olderror);
706 $html = $doc->getElementsByTagName('body')->item(0)->C14N(false, true);
707 if ($removebody) {
708 // Remove <body> element added in C14N function.
709 $html = preg_replace('~<(/?(?:body))[^>]*>\s*~i', '', $html);
713 return $html;