]> git.mxchange.org Git - friendica.git/blobdiff - src/Model/Mail.php
Merge pull request #10860 from nupplaphil/feat/depository_profilefield
[friendica.git] / src / Model / Mail.php
index ae30859be1849632df70bac1cbe96ad2ebf94e0d..75515c5df53c8166e5d0240ea570a4120f6525cf 100644 (file)
 <?php
 /**
- * @file src/Model/Mail.php
+ * @copyright Copyright (C) 2010-2021, the Friendica project
+ *
+ * @license GNU AGPL version 3 or any later version
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ *
+ * This program 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 Affero General Public License for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ *
  */
+
 namespace Friendica\Model;
 
-use Friendica\App;
+use Friendica\Core\Logger;
 use Friendica\Core\System;
 use Friendica\Core\Worker;
-use Friendica\Database\DBM;
-use dba;
-
-require_once 'include/dba.php';
+use Friendica\Database\DBA;
+use Friendica\DI;
+use Friendica\Protocol\Activity;
+use Friendica\Util\DateTimeFormat;
+use Friendica\Worker\Delivery;
 
 /**
  * Class to handle private messages
  */
 class Mail
 {
-       function send_message($recipient = 0, $body = '', $subject = '', $replyto = '')
+       /**
+        * Insert private message
+        *
+        * @param array $msg
+        * @param bool  $notifiction
+        * @return int|boolean Message ID or false on error
+        */
+       public static function insert($msg, $notifiction = true)
        {
-               $a = get_app();
+               if (!isset($msg['reply'])) {
+                       $msg['reply'] = DBA::exists('mail', ['parent-uri' => $msg['parent-uri']]);
+               }
+
+               if (empty($msg['convid'])) {
+                       $mail = DBA::selectFirst('mail', ['convid'], ["`convid` != 0 AND `parent-uri` = ?", $msg['parent-uri']]);
+                       if (DBA::isResult($mail)) {
+                               $msg['convid'] = $mail['convid'];
+                       }
+               }
+
+               if (empty($msg['guid'])) {
+                       $host = parse_url($msg['from-url'], PHP_URL_HOST);
+                       $msg['guid'] = Item::guidFromUri($msg['uri'], $host);
+               }
+
+               $msg['created'] = (!empty($msg['created']) ? DateTimeFormat::utc($msg['created']) : DateTimeFormat::utcNow());
+
+               $msg['author-id']     = Contact::getIdForURL($msg['from-url'], 0, false);
+               $msg['uri-id']        = ItemURI::insert(['uri' => $msg['uri'], 'guid' => $msg['guid']]);
+               $msg['parent-uri-id'] = ItemURI::getIdByURI($msg['parent-uri']);
+
+               DBA::lock('mail');
+
+               if (DBA::exists('mail', ['uri' => $msg['uri'], 'uid' => $msg['uid']])) {
+                       DBA::unlock();
+                       Logger::info('duplicate message already delivered.');
+                       return false;
+               }
+
+               if ($msg['reply'] && DBA::isResult($reply = DBA::selectFirst('mail', ['uri', 'uri-id'], ['parent-uri' => $msg['parent-uri'], 'reply' => false]))) {
+                       $msg['thr-parent']    = $reply['uri'];
+                       $msg['thr-parent-id'] = $reply['uri-id'];
+               } else {
+                       $msg['thr-parent']    = $msg['uri'];
+                       $msg['thr-parent-id'] = $msg['uri-id'];
+               }
+
+               DBA::insert('mail', $msg);
+
+               $msg['id'] = DBA::lastInsertId();
+
+               DBA::unlock();
+
+               if (!empty($msg['convid'])) {
+                       DBA::update('conv', ['updated' => DateTimeFormat::utcNow()], ['id' => $msg['convid']]);
+               }
+
+               if ($notifiction) {
+                       $user = User::getById($msg['uid']);
+                       // send notifications.
+                       $notif_params = [
+                               'type'  => Notification\Type::MAIL,
+                               'otype' => Notification\ObjectType::MAIL,
+                               'verb'  => Activity::POST,
+                               'uid'   => $user['uid'],
+                               'cid'   => $msg['contact-id'],
+                               'link'  => DI::baseUrl() . '/message/' . $msg['id'],
+                       ];
+
+                       notification($notif_params);
+
+                       Logger::info('Mail is processed, notification was sent.', ['id' => $msg['id'], 'uri' => $msg['uri']]);
+               }
+
+               return $msg['id'];
+       }
+
+       /**
+        * Send private message
+        *
+        * @param integer $recipient recipient id, default 0
+        * @param string  $body      message body, default empty
+        * @param string  $subject   message subject, default empty
+        * @param string  $replyto   reply to
+        * @return int
+        * @throws \Friendica\Network\HTTPException\InternalServerErrorException
+        */
+       public static function send($recipient = 0, $body = '', $subject = '', $replyto = '')
+       {
+               $a = DI::app();
 
                if (!$recipient) {
                        return -1;
                }
 
                if (!strlen($subject)) {
-                       $subject = t('[no subject]');
+                       $subject = DI::l10n()->t('[no subject]');
                }
 
-               $me = q("SELECT * FROM `contact` WHERE `uid` = %d AND `self` = 1 LIMIT 1",
-                       intval(local_user())
-               );
-               $contact = q("SELECT * FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
-                       intval($recipient),
-                       intval(local_user())
-               );
+               $me = DBA::selectFirst('contact', [], ['uid' => local_user(), 'self' => true]);
+               if (!DBA::isResult($me)) {
+                       return -2;
+               }
 
-               if (!(count($me) && (count($contact)))) {
+               $contact = DBA::selectFirst('contact', [], ['id' => $recipient, 'uid' => local_user()]);
+               if (!DBA::isResult($contact)) {
                        return -2;
                }
 
-               $guid = get_guid(32);
-               $uri = 'urn:X-dfrn:' . System::baseUrl() . ':' . local_user() . ':' . $guid;
+               Photo::setPermissionFromBody($body, local_user(), $me['id'],  '<' . $contact['id'] . '>', '', '', '');
+
+               $guid = System::createUUID();
+               $uri = Item::newURI(local_user(), $guid);
 
                $convid = 0;
                $reply = false;
@@ -51,39 +156,38 @@ class Mail
 
                if (strlen($replyto)) {
                        $reply = true;
-                       $r = q("SELECT `convid` FROM `mail` WHERE `uid` = %d AND (`uri` = '%s' OR `parent-uri` = '%s') LIMIT 1",
-                               intval(local_user()),
-                               dbesc($replyto),
-                               dbesc($replyto)
-                       );
-                       if (DBM::is_result($r)) {
-                               $convid = $r[0]['convid'];
+                       $condition = ["`uid` = ? AND (`uri` = ? OR `parent-uri` = ?)",
+                               local_user(), $replyto, $replyto];
+                       $mail = DBA::selectFirst('mail', ['convid'], $condition);
+                       if (DBA::isResult($mail)) {
+                               $convid = $mail['convid'];
                        }
                }
 
+               $convuri = '';
                if (!$convid) {
                        // create a new conversation
-                       $recip_host = substr($contact[0]['url'], strpos($contact[0]['url'], '://') + 3);
+                       $recip_host = substr($contact['url'], strpos($contact['url'], '://') + 3);
                        $recip_host = substr($recip_host, 0, strpos($recip_host, '/'));
 
-                       $recip_handle = (($contact[0]['addr']) ? $contact[0]['addr'] : $contact[0]['nick'] . '@' . $recip_host);
-                       $sender_handle = $a->user['nickname'] . '@' . substr(System::baseUrl(), strpos(System::baseUrl(), '://') + 3);
+                       $recip_handle = (($contact['addr']) ? $contact['addr'] : $contact['nick'] . '@' . $recip_host);
+                       $sender_handle = $a->getLoggedInUserNickname() . '@' . substr(DI::baseUrl(), strpos(DI::baseUrl(), '://') + 3);
 
-                       $conv_guid = get_guid(32);
+                       $conv_guid = System::createUUID();
                        $convuri = $recip_handle . ':' . $conv_guid;
 
                        $handles = $recip_handle . ';' . $sender_handle;
 
-                       $fields = array('uid' => local_user(), 'guid' => $conv_guid, 'creator' => $sender_handle,
-                               'created' => datetime_convert(), 'updated' => datetime_convert(),
-                               'subject' => $subject, 'recips' => $handles);
-                       if (dba::insert('conv', $fields)) {
-                               $convid = dba::lastInsertId();
+                       $fields = ['uid' => local_user(), 'guid' => $conv_guid, 'creator' => $sender_handle,
+                               'created' => DateTimeFormat::utcNow(), 'updated' => DateTimeFormat::utcNow(),
+                               'subject' => $subject, 'recips' => $handles];
+                       if (DBA::insert('conv', $fields)) {
+                               $convid = DBA::lastInsertId();
                        }
                }
 
                if (!$convid) {
-                       logger('send message: conversation not found.');
+                       Logger::log('send message: conversation not found.');
                        return -4;
                }
 
@@ -91,29 +195,25 @@ class Mail
                        $replyto = $convuri;
                }
 
-               $post_id = null;
-               $result = q("INSERT INTO `mail` ( `uid`, `guid`, `convid`, `from-name`, `from-photo`, `from-url`,
-                       `contact-id`, `title`, `body`, `seen`, `reply`, `replied`, `uri`, `parent-uri`, `created`)
-                       VALUES ( %d, '%s', %d, '%s', '%s', '%s', %d, '%s', '%s', %d, %d, %d, '%s', '%s', '%s' )",
-                       intval(local_user()),
-                       dbesc($guid),
-                       intval($convid),
-                       dbesc($me[0]['name']),
-                       dbesc($me[0]['thumb']),
-                       dbesc($me[0]['url']),
-                       intval($recipient),
-                       dbesc($subject),
-                       dbesc($body),
-                       1,
-                       intval($reply),
-                       0,
-                       dbesc($uri),
-                       dbesc($replyto),
-                       datetime_convert()
+               $post_id = self::insert(
+                       [
+                               'uid' => local_user(),
+                               'guid' => $guid,
+                               'convid' => $convid,
+                               'from-name' => $me['name'],
+                               'from-photo' => $me['thumb'],
+                               'from-url' => $me['url'],
+                               'contact-id' => $recipient,
+                               'title' => $subject,
+                               'body' => $body,
+                               'seen' => 1,
+                               'reply' => $reply,
+                               'replied' => 0,
+                               'uri' => $uri,
+                               'parent-uri' => $replyto,
+                               'created' => DateTimeFormat::utcNow()
+                       ], false
                );
-               if ($result) {
-                       $post_id = dba::lastInsertId();
-               }
 
                /**
                 *
@@ -131,92 +231,89 @@ class Mail
                        $images = $match[1];
                        if (count($images)) {
                                foreach ($images as $image) {
-                                       if (!stristr($image, System::baseUrl() . '/photo/')) {
-                                               continue;
+                                       $image_rid = Photo::ridFromURI($image);
+                                       if (!empty($image_rid)) {
+                                               Photo::update(['allow-cid' => '<' . $recipient . '>'], ['resource-id' => $image_rid, 'album' => 'Wall Photos', 'uid' => local_user()]);
                                        }
-                                       $image_uri = substr($image, strrpos($image, '/') + 1);
-                                       $image_uri = substr($image_uri, 0, strpos($image_uri, '-'));
-                                       q("UPDATE `photo` SET `allow_cid` = '%s'
-                                               WHERE `resource-id` = '%s' AND `album` = '%s' AND `uid` = %d ",
-                                               dbesc('<' . $recipient . '>'),
-                                               dbesc($image_uri),
-                                               dbesc( t('Wall Photos')),
-                                               intval(local_user())
-                                       );
                                }
                        }
                }
 
                if ($post_id) {
-                       Worker::add(PRIORITY_HIGH, "Notifier", "mail", $post_id);
+                       Worker::add(PRIORITY_HIGH, "Notifier", Delivery::MAIL, $post_id);
                        return intval($post_id);
                } else {
                        return -3;
                }
        }
 
-       function send_wallmessage($recipient = '', $body = '', $subject = '', $replyto = '')
+       /**
+        * @param array  $recipient recipient, default empty
+        * @param string $body      message body, default empty
+        * @param string $subject   message subject, default empty
+        * @param string $replyto   reply to, default empty
+        * @return int
+        * @throws \Friendica\Network\HTTPException\InternalServerErrorException
+        * @throws \ImagickException
+        */
+       public static function sendWall(array $recipient = [], $body = '', $subject = '', $replyto = '')
        {
                if (!$recipient) {
                        return -1;
                }
 
                if (!strlen($subject)) {
-                       $subject = t('[no subject]');
+                       $subject = DI::l10n()->t('[no subject]');
                }
 
-               $guid = get_guid(32);
-               $uri = 'urn:X-dfrn:' . System::baseUrl() . ':' . local_user() . ':' . $guid;
-
-               $me = Probe::uri($replyto);
+               $guid = System::createUUID();
+               $uri = Item::newURI(local_user(), $guid);
 
+               $me = Contact::getByURL($replyto);
                if (!$me['name']) {
                        return -2;
                }
 
-               $conv_guid = get_guid(32);
+               $conv_guid = System::createUUID();
 
-               $recip_handle = $recipient['nickname'] . '@' . substr(System::baseUrl(), strpos(System::baseUrl(), '://') + 3);
+               $recip_handle = $recipient['nickname'] . '@' . substr(DI::baseUrl(), strpos(DI::baseUrl(), '://') + 3);
 
-               $sender_nick = basename($replyto);
-               $sender_host = substr($replyto, strpos($replyto, '://') + 3);
-               $sender_host = substr($sender_host, 0, strpos($sender_host, '/'));
-               $sender_handle = $sender_nick . '@' . $sender_host;
+               $sender_handle = $me['addr'];
 
                $handles = $recip_handle . ';' . $sender_handle;
 
                $convid = null;
-               $fields = array('uid' => $recipient['uid'], 'guid' => $conv_guid, 'creator' => $sender_handle,
-                       'created' => datetime_convert(), 'updated' => datetime_convert(),
-                       'subject' => $subject, 'recips' => $handles);
-               if (dba::insert('conv', $fields)) {
-                       $convid = dba::lastInsertId();
+               $fields = ['uid' => $recipient['uid'], 'guid' => $conv_guid, 'creator' => $sender_handle,
+                       'created' => DateTimeFormat::utcNow(), 'updated' => DateTimeFormat::utcNow(),
+                       'subject' => $subject, 'recips' => $handles];
+               if (DBA::insert('conv', $fields)) {
+                       $convid = DBA::lastInsertId();
                }
-               
+
                if (!$convid) {
-                       logger('send message: conversation not found.');
+                       Logger::log('send message: conversation not found.');
                        return -4;
                }
 
-               q("INSERT INTO `mail` ( `uid`, `guid`, `convid`, `from-name`, `from-photo`, `from-url`,
-                       `contact-id`, `title`, `body`, `seen`, `reply`, `replied`, `uri`, `parent-uri`, `created`, `unknown`)
-                       VALUES ( %d, '%s', %d, '%s', '%s', '%s', %d, '%s', '%s', %d, %d, %d, '%s', '%s', '%s', %d )",
-                       intval($recipient['uid']),
-                       dbesc($guid),
-                       intval($convid),
-                       dbesc($me['name']),
-                       dbesc($me['photo']),
-                       dbesc($me['url']),
-                       0,
-                       dbesc($subject),
-                       dbesc($body),
-                       0,
-                       0,
-                       0,
-                       dbesc($uri),
-                       dbesc($replyto),
-                       datetime_convert(),
-                       1
+               self::insert(
+                       [
+                               'uid' => $recipient['uid'],
+                               'guid' => $guid,
+                               'convid' => $convid,
+                               'from-name' => $me['name'],
+                               'from-photo' => $me['photo'],
+                               'from-url' => $me['url'],
+                               'contact-id' => 0,
+                               'title' => $subject,
+                               'body' => $body,
+                               'seen' => 0,
+                               'reply' => 0,
+                               'replied' => 0,
+                               'uri' => $uri,
+                               'parent-uri' => $me['url'],
+                               'created' => DateTimeFormat::utcNow(),
+                               'unknown' => 1
+                       ], false
                );
 
                return 0;