src/Model/Post/Delayed.php

   1 <?php
   2 /**
   3  * @copyright Copyright (C) 2010-2021, the Friendica project
   4  *
   5  * @license GNU AGPL version 3 or any later version
   6  *
   7  * This program is free software: you can redistribute it and/or modify
   8  * it under the terms of the GNU Affero General Public License as
   9  * published by the Free Software Foundation, either version 3 of the
  10  * License, or (at your option) any later version.
  11  *
  12  * This program is distributed in the hope that it will be useful,
  13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15  * GNU Affero General Public License for more details.
  16  *
  17  * You should have received a copy of the GNU Affero General Public License
  18  * along with this program.  If not, see <https://www.gnu.org/licenses/>.
  19  *
  20  */
  21
  22 namespace Friendica\Model\Post;
  23
  24 use Friendica\Core\Logger;
  25 use Friendica\Database\DBA;
  26 use Friendica\Core\Worker;
  27 use Friendica\Database\Database;
  28 use Friendica\DI;
  29 use Friendica\Model\Item;
  30 use Friendica\Model\Post;
  31 use Friendica\Model\Tag;
  32 use Friendica\Util\DateTimeFormat;
  33
  34 class Delayed
  35 {
  36         /**
  37          * Insert a new delayed post
  38          *
  39          * @param string  $uri
  40          * @param array   $item
  41          * @param integer $notify
  42          * @param bool    $unprepared
  43          * @param string  $delayed
  44          * @param array   $taglist
  45          * @param array   $attachments
  46          * @return int    ID of the created delayed post entry
  47          */
  48         public static function add(string $uri, array $item, int $notify = 0, bool $unprepared = false, string $delayed = '', array $taglist = [], array $attachments = [])
  49         {
  50                 if (empty($item['uid']) || self::exists($uri, $item['uid'])) {
  51                         Logger::notice('No uid or already found');
  52                         return 0;
  53                 }
  54
  55                 if (empty($delayed)) {
  56                         $min_posting = DI::config()->get('system', 'minimum_posting_interval', 0);
  57
  58                         $last_publish = DI::pConfig()->get($item['uid'], 'system', 'last_publish', 0, true);
  59                         $next_publish = max($last_publish + (60 * $min_posting), time());
  60                         $delayed = date(DateTimeFormat::MYSQL, $next_publish);
  61                 } else {
  62                         $next_publish = strtotime($delayed);
  63                 }
  64
  65                 Logger::notice('Adding post for delayed publishing', ['uid' => $item['uid'], 'delayed' => $delayed, 'uri' => $uri]);
  66
  67                 $wid = Worker::add(['priority' => PRIORITY_HIGH, 'delayed' => $delayed], 'DelayedPublish', $item, $notify, $taglist, $attachments, $unprepared, $uri);
  68                 if (!$wid) {
  69                         return 0;
  70                 }
  71
  72                 DI::pConfig()->set($item['uid'], 'system', 'last_publish', $next_publish);
  73
  74                 $delayed_post = [
  75                         'uri'     => $uri,
  76                         'uid'     => $item['uid'],
  77                         'delayed' => $delayed,
  78                         'wid'     => $wid,
  79                 ];
  80
  81                 if (DBA::insert('delayed-post', $delayed_post, Database::INSERT_IGNORE)) {
  82                         return DBA::lastInsertId();
  83                 } else {
  84                         return 0;
  85                 }
  86         }
  87
  88         /**
  89          * Delete a delayed post
  90          *
  91          * @param string $uri
  92          * @param int    $uid
  93          *
  94          * @return bool delete success
  95          */
  96         private static function delete(string $uri, int $uid)
  97         {
  98                 return DBA::delete('delayed-post', ['uri' => $uri, 'uid' => $uid]);
  99         }
 100
 101         /**
 102          * Delete scheduled posts and the associated workerqueue entry
 103          *
 104          * @param integer $id
 105          * @return void
 106          */
 107         public static function deleteById(int $id)
 108         {
 109                 $post = DBA::selectFirst('delayed-post', ['wid'], ['id' => $id]);
 110                 if (empty($post['wid'])) {
 111                         return;
 112                 }
 113
 114                 DBA::delete('delayed-post', ['id' => $id]);
 115                 DBA::delete('workerqueue', ['id' => $post['wid']]);
 116         }
 117
 118         /**
 119          * Check if an entry exists
 120          *
 121          * @param string $uri
 122          * @param int    $uid
 123          *
 124          * @return bool "true" if an entry with that URI exists
 125          */
 126         public static function exists(string $uri, int $uid)
 127         {
 128                 return DBA::exists('delayed-post', ['uri' => $uri, 'uid' => $uid]);
 129         }
 130
 131         /**
 132          * Fetch parameters for delayed posts
 133          *
 134          * @param integer $id
 135          * @return array
 136          */
 137         public static function getParametersForid(int $id)
 138         {
 139                 $delayed = DBA::selectFirst('delayed-post', ['id', 'uid', 'wid', 'delayed'], ['id' => $id]);
 140                 if (empty($delayed['wid'])) {
 141                         return [];
 142                 }
 143
 144                 $worker = DBA::selectFirst('workerqueue', ['parameter'], ['id' => $delayed['wid'], 'command' => 'DelayedPublish']);
 145                 if (empty($worker)) {
 146                         return [];
 147                 }
 148
 149                 $parameters = json_decode($worker['parameter'], true);
 150                 if (empty($parameters)) {
 151                         return [];
 152                 }
 153
 154                 // Make sure to only publish the attachments in the dedicated array field
 155                 if (empty($parameters[3]) && !empty($parameters[0]['attachments'])) {
 156                         $parameters[3] = $parameters[0]['attachments'];
 157                         unset($parameters[0]['attachments']);
 158                 }
 159
 160                 return [
 161                         'parameters' => $delayed,
 162                         'item' => $parameters[0],
 163                         'notify' => $parameters[1],
 164                         'taglist' => $parameters[2],
 165                         'attachments' => $parameters[3],
 166                         'unprepared' => $parameters[4],
 167                         'uri' => $parameters[5],
 168                 ];
 169         }
 170
 171         /**
 172          * Publish a delayed post
 173          *
 174          * @param array $item
 175          * @param integer $notify
 176          * @param array $taglist
 177          * @param array $attachments
 178          * @param bool  $unprepared
 179          * @param string $uri
 180          * @return bool
 181          */
 182         public static function publish(array $item, int $notify = 0, array $taglist = [], array $attachments = [], bool $unprepared = false, string $uri = '')
 183         {
 184                 if (!empty($attachments)) {
 185                         $item['attachments'] = $attachments;
 186                 }
 187
 188                 if ($unprepared) {
 189                         $_SESSION['authenticated'] = true;
 190                         $_SESSION['uid'] = $item['uid'];
 191
 192                         $_REQUEST = $item;
 193                         $_REQUEST['api_source'] = true;
 194                         $_REQUEST['profile_uid'] = $item['uid'];
 195                         $_REQUEST['title'] = $item['title'] ?? '';
 196
 197                         if (!empty($item['app'])) {
 198                                 $_REQUEST['source'] = $item['app'];
 199                         }
 200
 201                         require_once 'mod/item.php';
 202                         $id = item_post(DI::app());
 203
 204                         if (empty($uri) && !empty($item['extid'])) {
 205                                 $uri = $item['extid'];
 206                         }
 207
 208                         Logger::notice('Unprepared post stored', ['id' => $id, 'uid' => $item['uid'], 'uri' => $uri]);
 209                         if (self::exists($uri, $item['uid'])) {
 210                                 self::delete($uri, $item['uid']);
 211                         }
 212
 213                         return $id;
 214                 }
 215                 $id = Item::insert($item, $notify);
 216
 217                 Logger::notice('Post stored', ['id' => $id, 'uid' => $item['uid'], 'cid' => $item['contact-id']]);
 218
 219                 if (empty($uri) && !empty($item['uri'])) {
 220                         $uri = $item['uri'];
 221                 }
 222
 223                 if (!empty($uri) && self::exists($uri, $item['uid'])) {
 224                         self::delete($uri, $item['uid']);
 225                 }
 226
 227                 if (!empty($id) && (!empty($taglist) || !empty($attachments))) {
 228                         $feeditem = Post::selectFirst(['uri-id'], ['id' => $id]);
 229
 230                         foreach ($taglist as $tag) {
 231                                 Tag::store($feeditem['uri-id'], Tag::HASHTAG, $tag);
 232                         }
 233                 }
 234
 235                 return $id;
 236         }
 237 }