]> git.mxchange.org Git - friendica.git/blobdiff - src/Model/Event.php
Merge pull request #12277 from nupplaphil/mod/fbrowser
[friendica.git] / src / Model / Event.php
index 712e5861ac23ef40954128fd3c3c13e1c1a08e6f..6f1b29a6c3f9e36a80d8bec7f7a9600e4b94956d 100644 (file)
@@ -24,15 +24,17 @@ namespace Friendica\Model;
 use Friendica\Content\Text\BBCode;
 use Friendica\Core\Hook;
 use Friendica\Core\Logger;
-use Friendica\Core\Protocol;
 use Friendica\Core\Renderer;
 use Friendica\Core\System;
 use Friendica\Database\DBA;
 use Friendica\DI;
+use Friendica\Network\HTTPException\NotFoundException;
+use Friendica\Network\HTTPException\UnauthorizedException;
 use Friendica\Protocol\Activity;
 use Friendica\Util\DateTimeFormat;
 use Friendica\Util\Map;
 use Friendica\Util\Strings;
+use Friendica\Util\Temporal;
 use Friendica\Util\XML;
 
 /**
@@ -410,7 +412,7 @@ class Event
        public static function getStrings(): array
        {
                // First day of the week (0 = Sunday).
-               $firstDay = DI::pConfig()->get(local_user(), 'system', 'first_day_of_week', 0);
+               $firstDay = DI::pConfig()->get(DI::userSession()->getLocalUserId(), 'system', 'first_day_of_week', 0);
 
                $i18n = [
                        "firstDay" => $firstDay,
@@ -494,22 +496,65 @@ class Event
                return array_values($dates2);
        }
 
+       /**
+        * Returns the owner array of a given nickname
+        * Additionally, it can check if the owner array is selectable
+        *
+        * @param string $nickname
+        * @param bool   $check
+        *
+        * @return array the owner array
+        * @throws NotFoundException The given nickname does not exist
+        * @throws UnauthorizedException The access for the given nickname is restricted
+        */
+       public static function getOwnerForNickname(string $nickname, bool $check = true): array
+       {
+               $owner = User::getOwnerDataByNick($nickname);
+               if (empty($owner)) {
+                       throw new NotFoundException(DI::l10n()->t('User not found.'));
+               }
+
+               if ($check) {
+                       $contact_id = DI::userSession()->getRemoteContactID($owner['uid']);
+
+                       $remote_contact = $contact_id && DBA::exists('contact', ['id' => $contact_id, 'uid' => $owner['uid']]);
+
+                       $is_owner = DI::userSession()->getLocalUserId() == $owner['uid'];
+
+                       if ($owner['hidewall'] && !$is_owner && !$remote_contact) {
+                               throw new UnauthorizedException(DI::l10n()->t('Access to this profile has been restricted.'));
+                       }
+               }
+
+               return $owner;
+       }
+
        /**
         * Get an event by its event ID.
         *
-        * @param int    $owner_uid The User ID of the owner of the event
-        * @param int    $event_id  The ID of the event in the event table
-        * @param string $sql_extra
+        * @param int         $owner_uid The User ID of the owner of the event
+        * @param int         $event_id  The ID of the event in the event table
+        * @param string|null $nickname  a possible nickname to search for instead of the owner uid
         * @return array Query result
         * @throws \Exception
         */
-       public static function getListById(int $owner_uid, int $event_id, string $sql_extra = ''): array
+       public static function getByIdAndUid(int $owner_uid, int $event_id, string $nickname = null): array
        {
-               $return = [];
+               if (!empty($nickname)) {
+                       $owner = static::getOwnerForNickname($nickname, true);
+                       $owner_uid = $owner['uid'];
+
+                       // get the permissions
+                       $sql_perms = Item::getPermissionsSQLByUserId($owner_uid);
+                       // we only want to have the events of the profile owner
+                       $sql_extra = " AND `event`.`cid` = 0 " . $sql_perms;
+               } else {
+                       $sql_extra = "";
+               }
 
-               // Ownly allow events if there is a valid owner_id.
+               // Only allow events if there is a valid owner_id.
                if ($owner_uid == 0) {
-                       return $return;
+                       return [];
                }
 
                // Query for the event by event id
@@ -518,34 +563,57 @@ class Event
                        WHERE `event`.`uid` = ? AND `event`.`id` = ? $sql_extra",
                        $owner_uid, $event_id));
 
-               if (DBA::isResult($events)) {
-                       $return = self::removeDuplicates($events);
+               if (empty($events)) {
+                       throw new NotFoundException(DI::l10n()->t('Event not found.'));
+               } else {
+                       $events = self::removeDuplicates($events);
+                       return $events[0];
                }
-
-               return $return;
        }
 
        /**
         * Get all events in a specific time frame.
         *
-        * @param int    $owner_uid    The User ID of the owner of the events.
-        * @param array  $event_params An associative array with
-        *                             int 'ignore' =>
-        *                             string 'start' => Start time of the timeframe.
-        *                             string 'finish' => Finish time of the timeframe.
-        *
-        * @param string $sql_extra    Additional sql conditions (e.g. permission request).
+        * @param int         $owner_uid The User ID of the owner of the events.
+        * @param string|null $start     Start time of the timeframe.
+        * @param string|null $finish    Finish time of the timeframe.
+        * @param bool        $ignore
+        * @param string|null $nickname
         *
         * @return array Query results.
-        * @throws \Exception
+        * @throws NotFoundException
+        * @throws UnauthorizedException
         */
-       public static function getListByDate(int $owner_uid, array $event_params, string $sql_extra = ''): array
+       public static function getListByDate(int $owner_uid, string $start = null, string $finish = null, bool $ignore = false, string $nickname = null): array
        {
-               $return = [];
+               if (!empty($nickname)) {
+                       $owner     = static::getOwnerForNickname($nickname);
+                       $owner_uid = $owner['uid'];
+
+                       // get the permissions
+                       $sql_perms = Item::getPermissionsSQLByUserId($owner_uid);
+                       // we only want to have the events of the profile owner
+                       $sql_extra = " AND `event`.`cid` = 0 " . $sql_perms;
+               } else {
+                       $sql_extra = "";
+               }
 
                // Only allow events if there is a valid owner_id.
                if ($owner_uid == 0) {
-                       return $return;
+                       return [];
+               }
+
+               if (empty($start) || empty($finish)) {
+
+                       $y = intval(DateTimeFormat::localNow('Y'));
+                       $m = intval(DateTimeFormat::localNow('m'));
+
+                       if (empty($start)) {
+                               $start = sprintf('%d-%d-%d %d:%d:%d', $y, $m, 1, 0, 0, 0);
+                       } else {
+                               $dim    = Temporal::getDaysInMonth($y, $m);
+                               $finish = sprintf('%d-%d-%d %d:%d:%d', $y, $m, $dim, 23, 59, 59);
+                       }
                }
 
                // Query for the event by date.
@@ -554,15 +622,12 @@ class Event
                                WHERE `event`.`uid` = ? AND `event`.`ignore` = ?
                                AND (`finish` >= ? OR (`nofinish` AND `start` >= ?)) AND `start` <= ?
                                " . $sql_extra,
-                               $owner_uid, $event_params['ignore'],
-                               $event_params['start'], $event_params['start'], $event_params['finish']
+                       $owner_uid, $ignore,
+                       $start, $start, $finish
                ));
 
-               if (DBA::isResult($events)) {
-                       $return = self::removeDuplicates($events);
-               }
-
-               return $return;
+               $events = self::removeDuplicates($events ?? []);
+               return self::sortByDate($events);
        }
 
        /**
@@ -577,75 +642,84 @@ class Event
        {
                $event_list = [];
 
-               $last_date = '';
-               $fmt = DI::l10n()->t('l, F j');
                foreach ($event_result as $event) {
-                       $item = Post::selectFirst(['plink', 'author-name', 'author-avatar', 'author-link', 'private', 'uri-id'], ['id' => $event['itemid']]);
-                       if (!DBA::isResult($item)) {
-                               // Using default values when no item had been found
-                               $item = ['plink' => '', 'author-name' => '', 'author-avatar' => '', 'author-link' => '', 'private' => Item::PUBLIC, 'uri-id' => ($event['uri-id'] ?? 0)];
-                       }
+                       $event_list[] = static::prepareForItem($event);
+               }
 
-                       $event = array_merge($event, $item);
+               return $event_list;
+       }
 
-                       $start = DateTimeFormat::local($event['start'], 'c');
-                       $j     = DateTimeFormat::local($event['start'], 'j');
-                       $day   = DateTimeFormat::local($event['start'], $fmt);
-                       $day   = DI::l10n()->getDay($day);
+       /**
+        * Convert an one event in an array which could be used by the events template.
+        *
+        * @param array $event Event query array.
+        * @return array Event array for the template.
+        * @throws \Friendica\Network\HTTPException\InternalServerErrorException
+        * @throws \ImagickException
+        */
+       public static function prepareForItem(array $event): array
+       {
+               $fmt = DI::l10n()->t('l, F j');
 
-                       if ($event['nofinish']) {
-                               $end = null;
-                       } else {
-                               $end = DateTimeFormat::local($event['finish'], 'c');
-                       }
+               $item = Post::selectFirst(['plink', 'author-name', 'author-network', 'author-id', 'author-avatar', 'author-link', 'private', 'uri-id'], ['id' => $event['itemid']]);
+               if (empty($item)) {
+                       // Using default values when no item had been found
+                       $item = ['plink' => '', 'author-name' => '', 'author-avatar' => '', 'author-link' => '', 'private' => Item::PUBLIC, 'uri-id' => ($event['uri-id'] ?? 0)];
+               }
 
-                       $is_first = ($day !== $last_date);
+               $event = array_merge($event, $item);
 
-                       $last_date = $day;
+               $start = DateTimeFormat::local($event['start'], 'c');
+               $j     = DateTimeFormat::local($event['start'], 'j');
+               $day   = DateTimeFormat::local($event['start'], $fmt);
+               $day   = DI::l10n()->getDay($day);
 
-                       // Show edit and drop actions only if the user is the owner of the event and the event
-                       // is a real event (no bithdays).
-                       $edit = null;
-                       $copy = null;
-                       $drop = null;
-                       if (local_user() && local_user() == $event['uid'] && $event['type'] == 'event') {
-                               $edit = !$event['cid'] ? [DI::baseUrl() . '/events/event/' . $event['id'], DI::l10n()->t('Edit event')     , '', ''] : null;
-                               $copy = !$event['cid'] ? [DI::baseUrl() . '/events/copy/' . $event['id'] , DI::l10n()->t('Duplicate event'), '', ''] : null;
-                               $drop =                  [DI::baseUrl() . '/events/drop/' . $event['id'] , DI::l10n()->t('Delete event')   , '', ''];
-                       }
+               if ($event['nofinish']) {
+                       $end = null;
+               } else {
+                       $end = DateTimeFormat::local($event['finish'], 'c');
+               }
 
-                       $title = BBCode::convertForUriId($event['uri-id'], Strings::escapeHtml($event['summary']));
-                       if (!$title) {
-                               list($title, $_trash) = explode("<br", BBCode::convertForUriId($event['uri-id'], Strings::escapeHtml($event['desc'])), BBCode::API);
-                       }
+               // Show edit and drop actions only if the user is the owner of the event and the event
+               // is a real event (no bithdays).
+               $edit = null;
+               $copy = null;
+               $drop = null;
+               if (DI::userSession()->getLocalUserId() && DI::userSession()->getLocalUserId() == $event['uid'] && $event['type'] == 'event') {
+                       $edit = !$event['cid'] ? ['calendar/event/edit/' . $event['id'], DI::l10n()->t('Edit event')     , '', ''] : null;
+                       $copy = !$event['cid'] ? ['calendar/event/copy/' . $event['id'] , DI::l10n()->t('Duplicate event'), '', ''] : null;
+                       $drop =                  ['calendar/api/delete/' . $event['id'] , DI::l10n()->t('Delete event')   , '', ''];
+               }
 
-                       $author_link = $event['author-link'];
-
-                       $event['author-link'] = Contact::magicLink($author_link);
-
-                       $html = self::getHTML($event);
-                       $event['summary']  = BBCode::convertForUriId($event['uri-id'], Strings::escapeHtml($event['summary']));
-                       $event['desc']     = BBCode::convertForUriId($event['uri-id'], Strings::escapeHtml($event['desc']));
-                       $event['location'] = BBCode::convertForUriId($event['uri-id'], Strings::escapeHtml($event['location']));
-                       $event_list[] = [
-                               'id'       => $event['id'],
-                               'start'    => $start,
-                               'end'      => $end,
-                               'allDay'   => false,
-                               'title'    => $title,
-                               'j'        => $j,
-                               'd'        => $day,
-                               'edit'     => $edit,
-                               'drop'     => $drop,
-                               'copy'     => $copy,
-                               'is_first' => $is_first,
-                               'item'     => $event,
-                               'html'     => $html,
-                               'plink'    => Item::getPlink($event),
-                       ];
+               $title = BBCode::convertForUriId($event['uri-id'], Strings::escapeHtml($event['summary']));
+               if (!$title) {
+                       [$title, $_trash] = explode("<br", BBCode::convertForUriId($event['uri-id'], Strings::escapeHtml($event['desc'])), BBCode::TWITTER_API);
                }
 
-               return $event_list;
+               $author_link = $event['author-link'];
+
+               $event['author-link'] = Contact::magicLink($author_link);
+
+               $html = self::getHTML($event);
+               $event['summary']  = BBCode::convertForUriId($event['uri-id'], Strings::escapeHtml($event['summary']));
+               $event['desc']     = BBCode::convertForUriId($event['uri-id'], Strings::escapeHtml($event['desc']));
+               $event['location'] = BBCode::convertForUriId($event['uri-id'], Strings::escapeHtml($event['location']));
+
+               return [
+                       'id'       => $event['id'],
+                       'start'    => $start,
+                       'end'      => $end,
+                       'allDay'   => false,
+                       'title'    => $title,
+                       'j'        => $j,
+                       'd'        => $day,
+                       'edit'     => $edit,
+                       'drop'     => $drop,
+                       'copy'     => $copy,
+                       'item'     => $event,
+                       'html'     => $html,
+                       'plink'    => Item::getPlink($event),
+               ];
        }
 
        /**
@@ -670,7 +744,6 @@ class Event
                switch ($format) {
                        // Format the exported data as a CSV file.
                        case "csv":
-                               header("Content-type: text/csv");
                                $o .= '"Subject", "Start Date", "Start Time", "Description", "End Date", "End Time", "Location"' . PHP_EOL;
 
                                foreach ($events as $event) {
@@ -691,7 +764,6 @@ class Event
 
                        // Format the exported data as a ics file.
                        case "ical":
-                               header("Content-type: text/ics");
                                $o = 'BEGIN:VCALENDAR' . PHP_EOL
                                        . 'VERSION:2.0' . PHP_EOL
                                        . 'PRODID:-//friendica calendar export//0.1//EN' . PHP_EOL;
@@ -705,6 +777,8 @@ class Event
                                //       also long lines SHOULD be split at 75 characters length
                                foreach ($events as $event) {
                                        $o .= 'BEGIN:VEVENT' . PHP_EOL;
+                                       $o .= 'UID:' . $event['id'] . PHP_EOL;
+                                       $o .= 'DTSTAMP:' . DateTimeFormat::utc($event['created'], 'Ymd\THis\Z') . PHP_EOL;
 
                                        if ($event['start']) {
                                                $o .= 'DTSTART:' . DateTimeFormat::utc($event['start'], 'Ymd\THis\Z') . PHP_EOL;
@@ -736,7 +810,6 @@ class Event
                                        }
 
                                        $o .= 'END:VEVENT' . PHP_EOL;
-                                       $o .= PHP_EOL;
                                }
 
                                $o .= 'END:VCALENDAR' . PHP_EOL;
@@ -768,14 +841,14 @@ class Event
                        return $return;
                }
 
-               $fields = ['start', 'finish', 'summary', 'desc', 'location', 'nofinish'];
+               $fields = ['id', 'created', 'start', 'finish', 'summary', 'desc', 'location', 'nofinish'];
 
                $conditions = ['uid' => $uid, 'cid' => 0];
 
                // Does the user who requests happen to be the owner of the events
                // requested? then show all of your events, otherwise only those that
                // don't have limitations set in allow_cid and allow_gid.
-               if (local_user() != $uid) {
+               if (DI::userSession()->getLocalUserId() != $uid) {
                        $conditions += ['allow_cid' => '', 'allow_gid' => ''];
                }
 
@@ -1019,4 +1092,9 @@ class Event
                // Check if self::store() was success
                return (self::store($values) > 0);
        }
+
+       public static function setIgnore(int $uid, int $eventId, bool $ignore = true)
+       {
+               DBA::update('event', ['ignore' => $ignore], ['id' => $eventId, 'uid' => $uid]);
+       }
 }