Issue 13221: Diaspora posts are now stored correctly

[friendica.git] / src / Model / Subscription.php

diff --git a/src/Model/Subscription.php b/src/Model/Subscription.php
index fac585e992bd95849826011d641dfdce1f976039..10a2d9b4d10d1af6b9b0e051b2c5a4db7c6b4e06 100644 (file)
--- a/src/Model/Subscription.php
+++ b/src/Model/Subscription.php
@@ -1,6 +1,6 @@
 <?php
 /**
- * @copyright Copyright (C) 2010-2021, the Friendica project
+ * @copyright Copyright (C) 2010-2023, the Friendica project
  *
  * @license GNU AGPL version 3 or any later version
  *
@@ -21,46 +21,139 @@
 
 namespace Friendica\Model;
 
+use Friendica\Core\Logger;
+use Friendica\Core\Worker;
 use Friendica\Database\DBA;
 use Friendica\DI;
-use Friendica\Util\Crypto;
+use Friendica\Factory\Api\Mastodon\Notification as NotificationFactory;
+use Friendica\Navigation\Notifications\Entity;
+use Friendica\Object\Api\Mastodon\Notification;
+use Minishlink\WebPush\VAPID;
 
 class Subscription
 {
        /**
-        * Insert an Subscription record
+        * Select a subscription record exists
         *
+        * @param int   $applicationid
+        * @param int   $uid
+        * @param array $fields
+        * @return array|bool Array on success, false on failure
+        */
+       public static function select(int $applicationid, int $uid, array $fields = [])
+       {
+               return DBA::selectFirst('subscription', $fields, ['application-id' => $applicationid, 'uid' => $uid]);
+       }
+
+       /**
+        * Check if a subscription record exists
+        *
+        * @param int   $applicationid
+        * @param int   $uid
+        *
+        * @return bool Does it exist?
+        */
+       public static function exists(int $applicationid, int $uid): bool
+       {
+               return DBA::exists('subscription', ['application-id' => $applicationid, 'uid' => $uid]);
+       }
+
+       /**
+        * Update a subscription record
+        *
+        * @param int   $applicationid
+        * @param int   $uid
         * @param array $fields subscription fields
+        * @return bool result of update
+        */
+       public static function update(int $applicationid, int $uid, array $fields): bool
+       {
+               return DBA::update('subscription', $fields, ['application-id' => $applicationid, 'uid' => $uid]);
+       }
+
+       /**
+        * Insert or replace a subscription record
         *
+        * @param array $fields subscription fields
         * @return bool result of replace
         */
-       public static function replace(array $fields)
+       public static function replace(array $fields): bool
        {
                return DBA::replace('subscription', $fields);
        }
 
        /**
         * Delete a subscription record
+        *
         * @param int $applicationid
         * @param int $uid
         * @return bool
         */
-       public static function delete(int $applicationid, int $uid)
+       public static function delete(int $applicationid, int $uid): bool
        {
                return DBA::delete('subscription', ['application-id' => $applicationid, 'uid' => $uid]);
        }
 
        /**
-        * Fetch a VAPID key
-        * @return string
+        * Fetch a VAPID keypair
+        *
+        * @return array
         */
-       public static function getVapidKey(): string
+       private static function getKeyPair(): array
        {
                $keypair = DI::config()->get('system', 'ec_keypair');
-               if (empty($keypair)) {
-                       $keypair = Crypto::newECKeypair();
+               if (empty($keypair['publicKey']) || empty($keypair['privateKey'])) {
+                       $keypair = VAPID::createVapidKeys();
                        DI::config()->set('system', 'ec_keypair', $keypair);
                }
-               return $keypair['vapid'];
+               return $keypair;
+       }
+
+       /**
+        * Fetch the public VAPID key
+        *
+        * @return string
+        */
+       public static function getPublicVapidKey(): string
+       {
+               $keypair = self::getKeyPair();
+               return $keypair['publicKey'];
+       }
+
+       /**
+        * Fetch the public VAPID key
+        *
+        * @return string
+        */
+       public static function getPrivateVapidKey(): string
+       {
+               $keypair = self::getKeyPair();
+               return $keypair['privateKey'];
+       }
+
+       /**
+        * Prepare push notification
+        *
+        * @param Notification $Notification
+        * @return void
+        */
+       public static function pushByNotification(Entity\Notification $notification)
+       {
+               $type = NotificationFactory::getType($notification);
+
+               if (DI::notify()->shouldShowOnDesktop($notification, $type)) {
+                       DI::notify()->createFromNotification($notification);
+               }
+
+               if (empty($type)) {
+                       return;
+               }
+
+               $subscriptions = DBA::select('subscription', [], ['uid' => $notification->uid, $type => true]);
+               while ($subscription = DBA::fetch($subscriptions)) {
+                       Logger::info('Push notification', ['id' => $subscription['id'], 'uid' => $subscription['uid'], 'type' => $type]);
+                       Worker::add(Worker::PRIORITY_HIGH, 'PushSubscription', $subscription['id'], $notification->id);
+               }
+               DBA::close($subscriptions);
        }
 }