Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
<?php
/**
* Copyright Maarch since 2008 under licence GPLv3.
* See LICENCE.txt file at the root folder for more details.
* This file is part of Maarch software.
*
*/
/**
* @brief Notifications Model
* @author dev@maarch.org
* @ingroup Module
*/
namespace Notifications\Models;
use Core\Models\DatabaseModel;
use Core\Models\ValidatorModel;
class NotificationModelAbstract
{
public static function get(array $aArgs = [])
{
ValidatorModel::notEmpty($aArgs, ['select']);
$aNotifications = DatabaseModel::select([
'select' => empty($aArgs['select']) ? ['*'] : $aArgs['select'],
'table' => ['notifications']
]);
return $aNotifications;
}
public static function getById(array $aArgs = [])
{
ValidatorModel::notEmpty($aArgs, ['notificationId']);
$aNotification = DatabaseModel::select([
'select' => empty($aArgs['select']) ? ['*'] : $aArgs['select'],
'table' => ['notifications'],
'where' => ['notification_id = ?'],
'data' => [$aArgs['notificationId']]
]);
if (empty($aNotification[0])) {
return [];
}
return $aNotification[0];
}
public static function delete(array $aArgs = [])
{
ValidatorModel::notEmpty($aArgs, ['notification_sid']);
ValidatorModel::intVal($aArgs, ['notification_sid']);
DatabaseModel::delete([
'table' => 'notifications',
'where' => ['notification_sid = ?'],
'data' => [$aArgs['notification_sid']],
]);
return true;
}
public static function create(array $aArgs = [])
{
ValidatorModel::notEmpty($aArgs, ['notification_id', 'description', 'is_enabled', 'event_id', 'notification_mode', 'template_id', 'diffusion_type', 'diffusion_properties']);
ValidatorModel::intVal($aArgs, ['template_id']);
ValidatorModel::stringType($aArgs, ['notification_id','description','is_enabled','event_id','notification_mode',]);
DatabaseModel::insert([
'table' => 'notifications',
'columnsValues' => [
'notification_id' => $aArgs['notification_id'],
'description' => $aArgs['description'],
'is_enabled' => $aArgs['is_enabled'],
'event_id' => $aArgs['event_id'],
'notification_mode' => $aArgs['notification_mode'],
'template_id' => $aArgs['template_id'],
'rss_url_template' => $aArgs['rss_url_template'],
'diffusion_type' => $aArgs['diffusion_type'],
'diffusion_properties' => $aArgs['diffusion_properties'],
'attachfor_type' => $aArgs['attachfor_type'],
'attachfor_properties' => $aArgs['attachfor_properties']
]
]);
return true;
}
public static function update(array $aArgs)
{
ValidatorModel::notEmpty($aArgs, ['notification_sid']);
ValidatorModel::intVal($aArgs, ['notification_sid']);
$where['notification_sid'] = $aArgs['notification_sid'];
//unset($aArgs['notification_id']);
unset($aArgs['notification_sid']);
$aReturn = DatabaseModel::update([
'table' => 'notifications',
'set' => $aArgs,
'where' => ['notification_sid = ?'],
'data' => [$where['notification_sid']]
]);
return $aReturn;
}
}