3 * @copyright Copyright (C) 2010-2021, the Friendica project
5 * @license GNU AGPL version 3 or any later version
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.
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.
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/>.
23 * @see https://github.com/web-push-libs/web-push-php
24 * Possibly we should simply use this.
27 namespace Friendica\Model;
29 use Friendica\Core\Logger;
30 use Friendica\Database\DBA;
32 use Friendica\Util\Crypto;
37 * Select a subscription record exists
39 * @param int $applicationid
41 * @param array $fields
43 * @return bool Does it exist?
45 public static function select(int $applicationid, int $uid, array $fields = [])
47 return DBA::selectFirst('subscription', $fields, ['application-id' => $applicationid, 'uid' => $uid]);
51 * Check if a subscription record exists
53 * @param int $applicationid
56 * @return bool Does it exist?
58 public static function exists(int $applicationid, int $uid)
60 return DBA::exists('subscription', ['application-id' => $applicationid, 'uid' => $uid]);
64 * Update a subscription record
66 * @param int $applicationid
68 * @param array $fields subscription fields
70 * @return bool result of update
72 public static function update(int $applicationid, int $uid, array $fields)
74 return DBA::update('subscription', $fields, ['application-id' => $applicationid, 'uid' => $uid]);
78 * Insert or replace a subscription record
80 * @param array $fields subscription fields
82 * @return bool result of replace
84 public static function replace(array $fields)
86 return DBA::replace('subscription', $fields);
90 * Delete a subscription record
92 * @param int $applicationid
96 public static function delete(int $applicationid, int $uid)
98 return DBA::delete('subscription', ['application-id' => $applicationid, 'uid' => $uid]);
106 public static function getVapidKey(): string
108 $keypair = DI::config()->get('system', 'ec_keypair');
109 if (empty($keypair)) {
110 $keypair = Crypto::newECKeypair();
111 DI::config()->set('system', 'ec_keypair', $keypair);
113 return $keypair['vapid-public'];
117 * Prepare push notification
122 public static function pushByNotificationId(int $nid)
124 $notification = DBA::selectFirst('notification', [], ['id' => $nid]);
125 $type = Notification::getType($notification);
130 $subscriptions = DBA::select('subscription', [], ['uid' => $notification['uid'], $type => true]);
131 while ($subscription = DBA::fetch($subscriptions)) {
132 Logger::info('Push notification', ['id' => $subscription['id'], 'uid' => $subscription['uid'], 'type' => $type]);
134 DBA::close($subscriptions);