NotificationHandler::__construct()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 5
Code Lines 3

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 3
c 0
b 0
f 0
nc 1
nop 1
dl 0
loc 5
rs 10
1
<?php declare(strict_types=1);
2
3
namespace XoopsModules\Xhelp;
4
5
/*
6
 * You may not change or alter any portion of this comment or credits
7
 * of supporting developers from this source code or any supporting source code
8
 * which is considered copyrighted (c) material of the original comment or credit authors.
9
 *
10
 * This program is distributed in the hope that it will be useful,
11
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
13
 */
14
15
/**
16
 * @copyright    {@link https://xoops.org/ XOOPS Project}
17
 * @license      {@link https://www.gnu.org/licenses/gpl-2.0.html GNU GPL 2 or later}
18
 * @author       Eric Juden <[email protected]>
19
 * @author       XOOPS Development Team
20
 */
21
22
if (!\defined('XHELP_CLASS_PATH')) {
23
    exit();
24
}
25
26
// require_once XHELP_CLASS_PATH . '/BaseObjectHandler.php';
27
28
/**
29
 * NotificationHandler class
30
 *
31
 * Notification Handler for Notification class
32
 *
33
 * @author  Eric Juden <[email protected]> &
34
 */
35
class NotificationHandler extends BaseObjectHandler
36
{
37
    /**
38
     * Name of child class
39
     *
40
     * @var string
41
     */
42
    public $classname = Notification::class;
43
    /**
44
     * DB table name
45
     *
46
     * @var string
47
     */
48
    public $dbtable = 'xhelp_notifications';
49
    public $idfield = 'notif_id';
50
51
    private const TABLE = 'xhelp_notifications';
52
    private const ENTITY = Notification::class;
53
    private const ENTITYNAME = 'Notification';
54
    private const KEYNAME = 'notif_id';
55
    private const IDENTIFIER = 'notif_id';
56
57
    /**
58
     * Constructor
59
     *
60
     * @param \XoopsMySQLDatabase|null $db reference to a xoopsDB object
61
     */
62
    public function __construct(\XoopsMySQLDatabase $db = null)
63
    {
64
        $this->init($db);
65
        $this->helper = Helper::getInstance();
66
        parent::__construct($db, static::TABLE, static::ENTITY, static::KEYNAME, static::IDENTIFIER);
67
    }
68
69
    /**
70
     * @param \XoopsObject $object
71
     * @return string
72
     */
73
    public function insertQuery(\XoopsObject $object): string
74
    {
75
        //TODO mb replace with individual variables
76
        // Copy all object vars into local variables
77
        foreach ($object->cleanVars as $k => $v) {
78
            ${$k} = $v;
79
        }
80
81
        $sql = \sprintf('INSERT INTO `%s` (notif_id, staff_setting, user_setting, staff_options) VALUES (%u, %u, %u, %s)', $this->db->prefix($this->dbtable), $notif_id, $staff_setting, $user_setting, $this->db->quoteString($staff_options));
0 ignored issues
show
Comprehensibility Best Practice introduced by
The variable $staff_setting seems to be never defined.
Loading history...
Comprehensibility Best Practice introduced by
The variable $notif_id seems to be never defined.
Loading history...
Comprehensibility Best Practice introduced by
The variable $user_setting seems to be never defined.
Loading history...
Comprehensibility Best Practice introduced by
The variable $staff_options seems to be never defined.
Loading history...
82
83
        return $sql;
84
    }
85
86
    /**
87
     * @param \XoopsObject $object
88
     * @return string
89
     */
90
    public function updateQuery(\XoopsObject $object): string
91
    {
92
        //TODO mb replace with individual variables
93
        // Copy all object vars into local variables
94
        foreach ($object->cleanVars as $k => $v) {
95
            ${$k} = $v;
96
        }
97
98
        $sql = \sprintf('UPDATE `%s` SET staff_setting = %u, user_setting = %u, staff_options = %s WHERE notif_id = %u', $this->db->prefix($this->dbtable), $staff_setting, $user_setting, $this->db->quoteString($staff_options), $notif_id);
0 ignored issues
show
Comprehensibility Best Practice introduced by
The variable $staff_setting seems to be never defined.
Loading history...
Comprehensibility Best Practice introduced by
The variable $user_setting seems to be never defined.
Loading history...
Comprehensibility Best Practice introduced by
The variable $notif_id seems to be never defined.
Loading history...
Comprehensibility Best Practice introduced by
The variable $staff_options seems to be never defined.
Loading history...
99
100
        return $sql;
101
    }
102
103
    /**
104
     * @param \XoopsObject $object
105
     * @return string
106
     */
107
    public function deleteQuery(\XoopsObject $object): string
108
    {
109
        $sql = \sprintf('DELETE FROM `%s` WHERE id = %u', $this->db->prefix($this->dbtable), $object->getVar('id'));
0 ignored issues
show
Bug introduced by
It seems like $object->getVar('id') can also be of type array and array; however, parameter $values of sprintf() does only seem to accept double|integer|string, maybe add an additional type check? ( Ignorable by Annotation )

If this is a false-positive, you can also ignore this issue in your code via the ignore-type  annotation

109
        $sql = \sprintf('DELETE FROM `%s` WHERE id = %u', $this->db->prefix($this->dbtable), /** @scrutinizer ignore-type */ $object->getVar('id'));
Loading history...
110
111
        return $sql;
112
    }
113
}
114