CHIEFSOFT\ameye
100 lines
3.0 KiB
PHP
100 lines
3.0 KiB
PHP
<?php
|
|
|
|
/**
|
|
* @file classes/notification/NotificationSettingsDAO.php
|
|
*
|
|
* Copyright (c) 2014-2021 Simon Fraser University
|
|
* Copyright (c) 2000-2021 John Willinsky
|
|
* Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
|
|
*
|
|
* @class NotificationSettingsDAO
|
|
*
|
|
* @ingroup notification
|
|
*
|
|
* @see Notification
|
|
*
|
|
* @brief Operations for retrieving and modifying Notification metadata.
|
|
*/
|
|
|
|
namespace PKP\notification;
|
|
|
|
use APP\notification\Notification;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class NotificationSettingsDAO extends \PKP\db\DAO
|
|
{
|
|
/**
|
|
* Update a notification's metadata
|
|
*
|
|
* @param int $notificationId
|
|
*
|
|
* @return $params array
|
|
*/
|
|
public function getNotificationSettings($notificationId)
|
|
{
|
|
$result = $this->retrieve(
|
|
'SELECT * FROM notification_settings WHERE notification_id = ?',
|
|
[(int) $notificationId]
|
|
);
|
|
|
|
$params = [];
|
|
foreach ($result as $row) {
|
|
$name = $row->setting_name;
|
|
$value = $this->convertFromDB($row->setting_value, $row->setting_type);
|
|
$locale = $row->locale;
|
|
|
|
if ($locale == '') {
|
|
$params[$name] = $value;
|
|
} else {
|
|
$params[$name][$locale] = $value;
|
|
}
|
|
}
|
|
return $params;
|
|
}
|
|
|
|
/**
|
|
* Store a notification's metadata
|
|
*
|
|
* @param int $notificationId
|
|
* @param string $name
|
|
* @param string $value
|
|
* @param bool $isLocalized optional
|
|
* @param string $type optional
|
|
*/
|
|
public function updateNotificationSetting($notificationId, $name, $value, $isLocalized = false, $type = null)
|
|
{
|
|
if (!$isLocalized) {
|
|
$value = $this->convertToDB($value, $type);
|
|
DB::table('notification_settings')->updateOrInsert(
|
|
['notification_id' => (int) $notificationId, 'setting_name' => $name, 'locale' => ''],
|
|
['setting_value' => $value, 'setting_type' => $type]
|
|
);
|
|
} else {
|
|
if (is_array($value)) {
|
|
foreach ($value as $locale => $localeValue) {
|
|
$this->update('DELETE FROM notification_settings WHERE notification_id = ? AND setting_name = ? AND locale = ?', [$notificationId, $name, $locale]);
|
|
if (empty($localeValue)) {
|
|
continue;
|
|
}
|
|
$type = null;
|
|
$this->update(
|
|
'INSERT INTO notification_settings
|
|
(notification_id, setting_name, setting_value, setting_type, locale)
|
|
VALUES (?, ?, ?, ?, ?)',
|
|
[
|
|
(int) $notificationId,
|
|
$name, $this->convertToDB($localeValue, $type),
|
|
$type,
|
|
$locale
|
|
]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
if (!PKP_STRICT_MODE) {
|
|
class_alias('\PKP\notification\NotificationSettingsDAO', '\NotificationSettingsDAO');
|
|
}
|