]> git.mxchange.org Git - friendica.git/blobdiff - src/Model/Mail.php
Merge pull request #4387 from MrPetovan/task/3878-move-datetime-to-src
[friendica.git] / src / Model / Mail.php
index ae30859be1849632df70bac1cbe96ad2ebf94e0d..b2e9e1a48734770b4b2ec5a0b9fcf05287eb0eda 100644 (file)
@@ -1,13 +1,16 @@
 <?php
+
 /**
  * @file src/Model/Mail.php
  */
 namespace Friendica\Model;
 
-use Friendica\App;
+use Friendica\Core\L10n;
 use Friendica\Core\System;
 use Friendica\Core\Worker;
 use Friendica\Database\DBM;
+use Friendica\Network\Probe;
+use Friendica\Util\DateTimeFormat;
 use dba;
 
 require_once 'include/dba.php';
@@ -17,7 +20,15 @@ require_once 'include/dba.php';
  */
 class Mail
 {
-       function send_message($recipient = 0, $body = '', $subject = '', $replyto = '')
+       /**
+        * 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
+        */
+       public static function send($recipient = 0, $body = '', $subject = '', $replyto = '')
        {
                $a = get_app();
 
@@ -26,16 +37,11 @@ class Mail
                }
 
                if (!strlen($subject)) {
-                       $subject = t('[no subject]');
+                       $subject = 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]);
+               $contact = dba::selectFirst('contact', [], ['id' => $recipient, 'uid' => local_user()]);
 
                if (!(count($me) && (count($contact)))) {
                        return -2;
@@ -63,10 +69,10 @@ class Mail
 
                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);
+                       $recip_handle = (($contact['addr']) ? $contact['addr'] : $contact['nick'] . '@' . $recip_host);
                        $sender_handle = $a->user['nickname'] . '@' . substr(System::baseUrl(), strpos(System::baseUrl(), '://') + 3);
 
                        $conv_guid = get_guid(32);
@@ -74,9 +80,9 @@ class Mail
 
                        $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);
+                       $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();
                        }
@@ -92,26 +98,28 @@ class Mail
                }
 
                $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()
+               $success = dba::insert(
+                       'mail',
+                       [
+                               '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()
+                       ]
                );
-               if ($result) {
+
+               if ($success) {
                        $post_id = dba::lastInsertId();
                }
 
@@ -136,13 +144,7 @@ class Mail
                                        }
                                        $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())
-                                       );
+                                       dba::update('photo', ['allow-cid' => '<' . $recipient . '>'], ['resource-id' => $image_uri, 'album' => 'Wall Photos', 'uid' => local_user()]);
                                }
                        }
                }
@@ -155,14 +157,20 @@ class Mail
                }
        }
 
-       function send_wallmessage($recipient = '', $body = '', $subject = '', $replyto = '')
+       /**
+        * @param string $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
+        */
+       public static function sendWall($recipient = '', $body = '', $subject = '', $replyto = '')
        {
                if (!$recipient) {
                        return -1;
                }
 
                if (!strlen($subject)) {
-                       $subject = t('[no subject]');
+                       $subject = L10n::t('[no subject]');
                }
 
                $guid = get_guid(32);
@@ -186,37 +194,38 @@ class Mail
                $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);
+               $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.');
                        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
+               dba::insert(
+                       'mail',
+                       [
+                               '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' => $replyto,
+                               'created' => DateTimeFormat::utcNow(),
+                               'unknown' => 1
+                       ]
                );
 
                return 0;