| @@ 75-84 (lines=10) @@ | ||
| 72 | /** |
|
| 73 | * @return array |
|
| 74 | */ |
|
| 75 | public function fetchAllItems() |
|
| 76 | { |
|
| 77 | $connection = $this->_em->getConnection(); |
|
| 78 | $statement = $connection->prepare('SELECT * FROM nv_request_limit_items'); |
|
| 79 | $statement->execute(); |
|
| 80 | $result = $statement->fetchAll(); |
|
| 81 | $connection->close(); |
|
| 82 | ||
| 83 | return $result; |
|
| 84 | } |
|
| 85 | ||
| 86 | /** |
|
| 87 | * @return int |
|
| @@ 89-98 (lines=10) @@ | ||
| 86 | /** |
|
| 87 | * @return int |
|
| 88 | */ |
|
| 89 | public function getItemsCount() |
|
| 90 | { |
|
| 91 | $connection = $this->_em->getConnection(); |
|
| 92 | $statement = $connection->prepare('SELECT COUNT(*) FROM nv_request_limit_items'); |
|
| 93 | $statement->execute(); |
|
| 94 | $result = $statement->fetchColumn(0); |
|
| 95 | $connection->close(); |
|
| 96 | ||
| 97 | return $result; |
|
| 98 | } |
|
| 99 | } |
|
| 100 | ||