includes/DataObjects/User.php 1 location
|
@@ 252-265 (lines=14) @@
|
| 249 |
|
* |
| 250 |
|
* @return User[] |
| 251 |
|
*/ |
| 252 |
|
public static function getAllWithStatus($status, PdoDatabase $database) |
| 253 |
|
{ |
| 254 |
|
$statement = $database->prepare("SELECT * FROM user WHERE status = :status"); |
| 255 |
|
$statement->execute(array(":status" => $status)); |
| 256 |
|
|
| 257 |
|
$resultObject = $statement->fetchAll(PDO::FETCH_CLASS, get_called_class()); |
| 258 |
|
|
| 259 |
|
/** @var User $u */ |
| 260 |
|
foreach ($resultObject as $u) { |
| 261 |
|
$u->setDatabase($database); |
| 262 |
|
} |
| 263 |
|
|
| 264 |
|
return $resultObject; |
| 265 |
|
} |
| 266 |
|
|
| 267 |
|
/** |
| 268 |
|
* Gets all checkusers |
includes/DataObjects/EmailTemplate.php 1 location
|
@@ 115-128 (lines=14) @@
|
| 112 |
|
* |
| 113 |
|
* @return array |
| 114 |
|
*/ |
| 115 |
|
public static function getAllInactiveTemplates(PdoDatabase $database) |
| 116 |
|
{ |
| 117 |
|
$statement = $database->prepare("SELECT * FROM `emailtemplate` WHERE active = 0;"); |
| 118 |
|
$statement->execute(); |
| 119 |
|
|
| 120 |
|
$resultObject = $statement->fetchAll(PDO::FETCH_CLASS, get_called_class()); |
| 121 |
|
|
| 122 |
|
/** @var EmailTemplate $t */ |
| 123 |
|
foreach ($resultObject as $t) { |
| 124 |
|
$t->setDatabase($database); |
| 125 |
|
} |
| 126 |
|
|
| 127 |
|
return $resultObject; |
| 128 |
|
} |
| 129 |
|
|
| 130 |
|
/** |
| 131 |
|
* @param string $name |
includes/DataObjects/WelcomeTemplate.php 1 location
|
@@ 36-50 (lines=15) @@
|
| 33 |
|
* |
| 34 |
|
* @return WelcomeTemplate[] |
| 35 |
|
*/ |
| 36 |
|
public static function getAll(PdoDatabase $database) |
| 37 |
|
{ |
| 38 |
|
$statement = $database->prepare("SELECT * FROM welcometemplate WHERE deleted = 0;"); |
| 39 |
|
|
| 40 |
|
$statement->execute(); |
| 41 |
|
|
| 42 |
|
$result = array(); |
| 43 |
|
/** @var WelcomeTemplate $v */ |
| 44 |
|
foreach ($statement->fetchAll(PDO::FETCH_CLASS, self::class) as $v) { |
| 45 |
|
$v->setDatabase($database); |
| 46 |
|
$result[] = $v; |
| 47 |
|
} |
| 48 |
|
|
| 49 |
|
return $result; |
| 50 |
|
} |
| 51 |
|
|
| 52 |
|
/** |
| 53 |
|
* @throws Exception |