-
Notifications
You must be signed in to change notification settings - Fork 0
/
PermissionManager.class.php
115 lines (102 loc) · 3.3 KB
/
PermissionManager.class.php
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
110
111
112
113
114
<?php
require_once 'Manager.class.php';
class PermissionManager extends Manager
{
public function insert(Permission $permission)
{
$request = $this->db->prepare('
INSERT INTO
permission
(
`id`,
`nom`
)
VALUES
(
:id,
:nom
)');
$request->bindValue(':id', null);
$request->bindValue(':nom', $permission->getNom());
$request->execute();
}
public function getAll()
{
$request = $this->db->prepare('
SELECT
permission.*
FROM
permission
ORDER BY
nom ASC
');
$request->execute();
$resultats = $request->fetchAll(PDO::FETCH_ASSOC);
return $resultats;
}
public function get($id)
{
$request = $this->db->prepare('
SELECT
permission.*
FROM
permission
WHERE
permission.id=:id');
$request->bindValue(':id', $id);
$request->execute();
$resultat = $request->fetch(PDO::FETCH_ASSOC);
return $resultat;
}
/*
public function getAll()
{
$request = $this->db->prepare('
SELECT
evolution.*,
iconepersonnage.chemin AS iconePersonnagePath
FROM
evolution
INNER JOIN
iconepersonnage
ON
evolution.iconePersonnageId = iconepersonnage.id
ORDER BY
personnageTypeId ASC,
palierInferieur ASC');
$request->execute();
$resultats = $request->fetchAll(PDO::FETCH_ASSOC);
return $resultats;
}
public function getBy($filtre, $valeur)
{
$request = $this->db->prepare('
SELECT
evolution.*
FROM
evolution
WHERE
evolution.'.$filtre.'='.$valeur);
$request->execute();
$resultats = $request->fetchAll(PDO::FETCH_ASSOC);
return $resultats;
}
public function update(Evolution $evolution)
{
$request = $this->db->prepare('
UPDATE
evolution
SET
personnageTypeId = :personnageTypeId,
palierInferieur = :palierInferieur,
palierSuperieur = :palierSuperieur,
iconePersonnageId = :iconePersonnageId
WHERE id = :id');
$request->bindValue(':id', $evolution->getId());
$request->bindValue(':personnageTypeId', $evolution->getPersonnageTypeId());
$request->bindValue(':palierInferieur', $evolution->getPalierInferieur());
$request->bindValue(':palierSuperieur', $evolution->getPalierSuperieur());
$request->bindValue(':iconePersonnageId', $evolution->getIconePersonnageId());
$request->execute();
} */
}