Dev-Int /
glsr
| @@ 25-66 (lines=42) @@ | ||
| 22 | * |
|
| 23 | * @category Entity |
|
| 24 | */ |
|
| 25 | class SettingsRepository extends EntityRepository |
|
| 26 | { |
|
| 27 | /** |
|
| 28 | * Affiche toutes les configurations. |
|
| 29 | * |
|
| 30 | * @return QueryBuilder Requête DQL |
|
| 31 | */ |
|
| 32 | public function getAllItems() |
|
| 33 | { |
|
| 34 | $query = $this->createQueryBuilder('s') |
|
| 35 | ->getQuery()->getResult(); |
|
| 36 | ||
| 37 | return $query; |
|
| 38 | } |
|
| 39 | ||
| 40 | /** |
|
| 41 | * Affiche les configurations actives. |
|
| 42 | * |
|
| 43 | * @return QueryBuilder Requête DQL |
|
| 44 | */ |
|
| 45 | public function getItems() |
|
| 46 | { |
|
| 47 | $query = $this->getAllItems(); |
|
| 48 | ||
| 49 | return $query; |
|
| 50 | } |
|
| 51 | ||
| 52 | /** |
|
| 53 | * Affiche le premier enregistrement. |
|
| 54 | * |
|
| 55 | * @return QueryBuilder Requête DQL |
|
| 56 | */ |
|
| 57 | public function findFirst() |
|
| 58 | { |
|
| 59 | $query = $this->createQueryBuilder('s') |
|
| 60 | ->setMaxResults(1) |
|
| 61 | ->orderBy('s.id', 'ASC') |
|
| 62 | ->getQuery()->getSingleResult(); |
|
| 63 | ||
| 64 | return $query; |
|
| 65 | } |
|
| 66 | } |
|
| 67 | ||
| @@ 25-67 (lines=43) @@ | ||
| 22 | * |
|
| 23 | * @category Entity |
|
| 24 | */ |
|
| 25 | class InventoryRepository extends EntityRepository |
|
| 26 | { |
|
| 27 | /** |
|
| 28 | * Affiche tous les inventaires. |
|
| 29 | * |
|
| 30 | * @return QueryBuilder Requête DQL |
|
| 31 | */ |
|
| 32 | public function getAllItems() |
|
| 33 | { |
|
| 34 | $query = $this->createQueryBuilder('i') |
|
| 35 | ->orderBy('i.id', 'DESC'); |
|
| 36 | ||
| 37 | return $query; |
|
| 38 | } |
|
| 39 | ||
| 40 | /** |
|
| 41 | * Affiche les inventaires actifs. |
|
| 42 | * |
|
| 43 | * @return QueryBuilder Requête DQL |
|
| 44 | */ |
|
| 45 | public function getItems() |
|
| 46 | { |
|
| 47 | $query = $this->getAllItems() |
|
| 48 | ->where('i.status > 0'); |
|
| 49 | ||
| 50 | return $query; |
|
| 51 | } |
|
| 52 | ||
| 53 | /** |
|
| 54 | * Renvoi les derniers inventaires. |
|
| 55 | * |
|
| 56 | * @param integer $count Nombre d'élément à afficher |
|
| 57 | * @return array Query result |
|
| 58 | */ |
|
| 59 | public function getLastInventory($count) |
|
| 60 | { |
|
| 61 | $query = $this->getItems() |
|
| 62 | ->setMaxResults($count) |
|
| 63 | ->getQuery(); |
|
| 64 | ||
| 65 | return $query->getResult(); |
|
| 66 | } |
|
| 67 | } |
|
| 68 | ||
