@@ -47,13 +47,13 @@ discard block |
||
| 47 | 47 | public function find($id) { |
| 48 | 48 | $qb = $this->db->getQueryBuilder(); |
| 49 | 49 | |
| 50 | - $qb->select('*') |
|
| 51 | - ->from($this->getTableName()) |
|
| 52 | - ->where( |
|
| 53 | - $qb->expr()->eq('id', $qb->createNamedParameter($id, IQueryBuilder::PARAM_INT)) |
|
| 54 | - ); |
|
| 50 | + $qb->select('*') |
|
| 51 | + ->from($this->getTableName()) |
|
| 52 | + ->where( |
|
| 53 | + $qb->expr()->eq('id', $qb->createNamedParameter($id, IQueryBuilder::PARAM_INT)) |
|
| 54 | + ); |
|
| 55 | 55 | |
| 56 | - return $this->findEntity($qb); |
|
| 56 | + return $this->findEntity($qb); |
|
| 57 | 57 | } |
| 58 | 58 | |
| 59 | 59 | /** |
@@ -65,13 +65,13 @@ discard block |
||
| 65 | 65 | public function findByHash($hash) { |
| 66 | 66 | $qb = $this->db->getQueryBuilder(); |
| 67 | 67 | |
| 68 | - $qb->select('*') |
|
| 69 | - ->from($this->getTableName()) |
|
| 70 | - ->where( |
|
| 71 | - $qb->expr()->eq('hash', $qb->createNamedParameter($hash, IQueryBuilder::PARAM_STR)) |
|
| 72 | - ); |
|
| 68 | + $qb->select('*') |
|
| 69 | + ->from($this->getTableName()) |
|
| 70 | + ->where( |
|
| 71 | + $qb->expr()->eq('hash', $qb->createNamedParameter($hash, IQueryBuilder::PARAM_STR)) |
|
| 72 | + ); |
|
| 73 | 73 | |
| 74 | - return $this->findEntity($qb); |
|
| 74 | + return $this->findEntity($qb); |
|
| 75 | 75 | } |
| 76 | 76 | |
| 77 | 77 | /** |
@@ -81,10 +81,10 @@ discard block |
||
| 81 | 81 | public function findAll() { |
| 82 | 82 | $qb = $this->db->getQueryBuilder(); |
| 83 | 83 | |
| 84 | - $qb->select('*') |
|
| 85 | - ->from($this->getTableName()); |
|
| 84 | + $qb->select('*') |
|
| 85 | + ->from($this->getTableName()); |
|
| 86 | 86 | |
| 87 | - return $this->findEntities($qb); |
|
| 87 | + return $this->findEntities($qb); |
|
| 88 | 88 | } |
| 89 | 89 | |
| 90 | 90 | } |
@@ -47,13 +47,13 @@ discard block |
||
| 47 | 47 | public function findByPoll($pollId) { |
| 48 | 48 | $qb = $this->db->getQueryBuilder(); |
| 49 | 49 | |
| 50 | - $qb->select('*') |
|
| 51 | - ->from($this->getTableName()) |
|
| 52 | - ->where( |
|
| 53 | - $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 54 | - ); |
|
| 50 | + $qb->select('*') |
|
| 51 | + ->from($this->getTableName()) |
|
| 52 | + ->where( |
|
| 53 | + $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 54 | + ); |
|
| 55 | 55 | |
| 56 | - return $this->findEntities($qb); |
|
| 56 | + return $this->findEntities($qb); |
|
| 57 | 57 | } |
| 58 | 58 | |
| 59 | 59 | /** |
@@ -64,13 +64,13 @@ discard block |
||
| 64 | 64 | public function findParticipantsByPoll($pollId, $limit = null, $offset = null) { |
| 65 | 65 | $qb = $this->db->getQueryBuilder(); |
| 66 | 66 | |
| 67 | - $qb->select('user_id') |
|
| 68 | - ->from($this->getTableName()) |
|
| 69 | - ->where( |
|
| 70 | - $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 71 | - ); |
|
| 67 | + $qb->select('user_id') |
|
| 68 | + ->from($this->getTableName()) |
|
| 69 | + ->where( |
|
| 70 | + $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 71 | + ); |
|
| 72 | 72 | |
| 73 | - return $this->findEntities($qb); |
|
| 73 | + return $this->findEntities($qb); |
|
| 74 | 74 | } |
| 75 | 75 | |
| 76 | 76 | /** |
@@ -80,20 +80,20 @@ discard block |
||
| 80 | 80 | public function deleteByPollAndUser($pollId, $userId) { |
| 81 | 81 | $qb = $this->db->getQueryBuilder(); |
| 82 | 82 | |
| 83 | - $qb->delete($this->getTableName()) |
|
| 84 | - ->where( |
|
| 85 | - $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 86 | - ) |
|
| 87 | - ->andWhere( |
|
| 88 | - $qb->expr()->eq('user_id', $qb->createNamedParameter($userId, IQueryBuilder::PARAM_STR)) |
|
| 89 | - ); |
|
| 83 | + $qb->delete($this->getTableName()) |
|
| 84 | + ->where( |
|
| 85 | + $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 86 | + ) |
|
| 87 | + ->andWhere( |
|
| 88 | + $qb->expr()->eq('user_id', $qb->createNamedParameter($userId, IQueryBuilder::PARAM_STR)) |
|
| 89 | + ); |
|
| 90 | 90 | |
| 91 | 91 | $qb->execute(); |
| 92 | 92 | } |
| 93 | 93 | |
| 94 | 94 | /** |
| 95 | - * @param int $pollId |
|
| 96 | - */ |
|
| 95 | + * @param int $pollId |
|
| 96 | + */ |
|
| 97 | 97 | public function deleteByPoll($pollId) { |
| 98 | 98 | $qb = $this->db->getQueryBuilder(); |
| 99 | 99 | |
@@ -69,9 +69,9 @@ |
||
| 69 | 69 | ->where( |
| 70 | 70 | $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
| 71 | 71 | ) |
| 72 | - ->andWhere( |
|
| 73 | - $qb->expr()->eq('user_id', $qb->createNamedParameter($userId, IQueryBuilder::PARAM_STR)) |
|
| 74 | - ); |
|
| 72 | + ->andWhere( |
|
| 73 | + $qb->expr()->eq('user_id', $qb->createNamedParameter($userId, IQueryBuilder::PARAM_STR)) |
|
| 74 | + ); |
|
| 75 | 75 | |
| 76 | 76 | return $this->findEntities($qb); |
| 77 | 77 | } |
@@ -47,13 +47,13 @@ discard block |
||
| 47 | 47 | public function findByPoll($pollId) { |
| 48 | 48 | $qb = $this->db->getQueryBuilder(); |
| 49 | 49 | |
| 50 | - $qb->select('*') |
|
| 51 | - ->from($this->getTableName()) |
|
| 52 | - ->where( |
|
| 53 | - $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 54 | - ); |
|
| 50 | + $qb->select('*') |
|
| 51 | + ->from($this->getTableName()) |
|
| 52 | + ->where( |
|
| 53 | + $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 54 | + ); |
|
| 55 | 55 | |
| 56 | - return $this->findEntities($qb); |
|
| 56 | + return $this->findEntities($qb); |
|
| 57 | 57 | } |
| 58 | 58 | |
| 59 | 59 | /** |
@@ -62,10 +62,10 @@ discard block |
||
| 62 | 62 | public function deleteByPoll($pollId) { |
| 63 | 63 | $qb = $this->db->getQueryBuilder(); |
| 64 | 64 | |
| 65 | - $qb->delete($this->getTableName()) |
|
| 66 | - ->where( |
|
| 67 | - $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 68 | - ); |
|
| 65 | + $qb->delete($this->getTableName()) |
|
| 66 | + ->where( |
|
| 67 | + $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 68 | + ); |
|
| 69 | 69 | |
| 70 | 70 | $qb->execute(); |
| 71 | 71 | } |
@@ -47,13 +47,13 @@ discard block |
||
| 47 | 47 | public function findByPoll($pollId) { |
| 48 | 48 | $qb = $this->db->getQueryBuilder(); |
| 49 | 49 | |
| 50 | - $qb->select('*') |
|
| 51 | - ->from($this->getTableName()) |
|
| 52 | - ->where( |
|
| 53 | - $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 54 | - ); |
|
| 50 | + $qb->select('*') |
|
| 51 | + ->from($this->getTableName()) |
|
| 52 | + ->where( |
|
| 53 | + $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 54 | + ); |
|
| 55 | 55 | |
| 56 | - return $this->findEntities($qb); |
|
| 56 | + return $this->findEntities($qb); |
|
| 57 | 57 | } |
| 58 | 58 | |
| 59 | 59 | /** |
@@ -62,10 +62,10 @@ discard block |
||
| 62 | 62 | public function deleteByPoll($pollId) { |
| 63 | 63 | $qb = $this->db->getQueryBuilder(); |
| 64 | 64 | |
| 65 | - $qb->delete($this->getTableName()) |
|
| 66 | - ->where( |
|
| 67 | - $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 68 | - ); |
|
| 65 | + $qb->delete($this->getTableName()) |
|
| 66 | + ->where( |
|
| 67 | + $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) |
|
| 68 | + ); |
|
| 69 | 69 | |
| 70 | 70 | $qb->execute(); |
| 71 | 71 | } |