@@ -32,6 +32,6 @@ |
||
32 | 32 | * @method void setPollId(string $value) |
33 | 33 | */ |
34 | 34 | class Notification extends Entity { |
35 | - public $userId; |
|
36 | - public $pollId; |
|
35 | + public $userId; |
|
36 | + public $pollId; |
|
37 | 37 | } |
@@ -36,8 +36,8 @@ |
||
36 | 36 | * @method void setType(integer $value) |
37 | 37 | */ |
38 | 38 | class ParticipationText extends Entity { |
39 | - public $text; |
|
40 | - public $userId; |
|
41 | - public $pollId; |
|
42 | - public $type; |
|
39 | + public $text; |
|
40 | + public $userId; |
|
41 | + public $pollId; |
|
42 | + public $type; |
|
43 | 43 | } |
@@ -28,30 +28,30 @@ |
||
28 | 28 | |
29 | 29 | class TextMapper extends Mapper { |
30 | 30 | |
31 | - /** |
|
32 | - * TextMapper constructor. |
|
33 | - * @param IDBConnection $db |
|
34 | - */ |
|
35 | - public function __construct(IDBConnection $db) { |
|
36 | - parent::__construct($db, 'polls_txts', '\OCA\Polls\Db\Text'); |
|
37 | - } |
|
31 | + /** |
|
32 | + * TextMapper constructor. |
|
33 | + * @param IDBConnection $db |
|
34 | + */ |
|
35 | + public function __construct(IDBConnection $db) { |
|
36 | + parent::__construct($db, 'polls_txts', '\OCA\Polls\Db\Text'); |
|
37 | + } |
|
38 | 38 | |
39 | - /** |
|
40 | - * @param string $pollId |
|
41 | - * @param int $limit |
|
42 | - * @param int $offset |
|
43 | - * @return Text[] |
|
44 | - */ |
|
45 | - public function findByPoll($pollId, $limit = null, $offset = null) { |
|
46 | - $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
47 | - return $this->findEntities($sql, [$pollId], $limit, $offset); |
|
48 | - } |
|
39 | + /** |
|
40 | + * @param string $pollId |
|
41 | + * @param int $limit |
|
42 | + * @param int $offset |
|
43 | + * @return Text[] |
|
44 | + */ |
|
45 | + public function findByPoll($pollId, $limit = null, $offset = null) { |
|
46 | + $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
47 | + return $this->findEntities($sql, [$pollId], $limit, $offset); |
|
48 | + } |
|
49 | 49 | |
50 | - /** |
|
51 | - * @param string $pollId |
|
52 | - */ |
|
53 | - public function deleteByPoll($pollId) { |
|
54 | - $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
55 | - $this->execute($sql, [$pollId]); |
|
56 | - } |
|
50 | + /** |
|
51 | + * @param string $pollId |
|
52 | + */ |
|
53 | + public function deleteByPoll($pollId) { |
|
54 | + $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
55 | + $this->execute($sql, [$pollId]); |
|
56 | + } |
|
57 | 57 | } |
@@ -44,7 +44,7 @@ discard block |
||
44 | 44 | */ |
45 | 45 | public function findByPoll($pollId, $limit = null, $offset = null) { |
46 | 46 | $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
47 | - return $this->findEntities($sql, [$pollId], $limit, $offset); |
|
47 | + return $this->findEntities($sql, [ $pollId ], $limit, $offset); |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | /** |
@@ -52,6 +52,6 @@ discard block |
||
52 | 52 | */ |
53 | 53 | public function deleteByPoll($pollId) { |
54 | 54 | $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
55 | - $this->execute($sql, [$pollId]); |
|
55 | + $this->execute($sql, [ $pollId ]); |
|
56 | 56 | } |
57 | 57 | } |
@@ -28,55 +28,55 @@ discard block |
||
28 | 28 | |
29 | 29 | class EventMapper extends Mapper { |
30 | 30 | |
31 | - /** |
|
32 | - * EventMapper constructor. |
|
33 | - * @param IDBConnection $db |
|
34 | - */ |
|
35 | - public function __construct(IDBConnection $db) { |
|
36 | - parent::__construct($db, 'polls_events', '\OCA\Polls\Db\Event'); |
|
37 | - } |
|
31 | + /** |
|
32 | + * EventMapper constructor. |
|
33 | + * @param IDBConnection $db |
|
34 | + */ |
|
35 | + public function __construct(IDBConnection $db) { |
|
36 | + parent::__construct($db, 'polls_events', '\OCA\Polls\Db\Event'); |
|
37 | + } |
|
38 | 38 | |
39 | - /** |
|
40 | - * @param int $id |
|
41 | - * @throws \OCP\AppFramework\Db\DoesNotExistException if not found |
|
42 | - * @throws \OCP\AppFramework\Db\MultipleObjectsReturnedException if more than one result |
|
43 | - * @return Event |
|
44 | - */ |
|
45 | - public function find($id) { |
|
46 | - $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE id = ?'; |
|
47 | - return $this->findEntity($sql, [$id]); |
|
48 | - } |
|
39 | + /** |
|
40 | + * @param int $id |
|
41 | + * @throws \OCP\AppFramework\Db\DoesNotExistException if not found |
|
42 | + * @throws \OCP\AppFramework\Db\MultipleObjectsReturnedException if more than one result |
|
43 | + * @return Event |
|
44 | + */ |
|
45 | + public function find($id) { |
|
46 | + $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE id = ?'; |
|
47 | + return $this->findEntity($sql, [$id]); |
|
48 | + } |
|
49 | 49 | |
50 | - /** |
|
51 | - * @param $hash |
|
52 | - * @param int $limit |
|
53 | - * @param int $offset |
|
54 | - * @return Event |
|
55 | - */ |
|
56 | - public function findByHash($hash, $limit = null, $offset = null) { |
|
57 | - $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE hash = ?'; |
|
58 | - return $this->findEntity($sql, [$hash], $limit, $offset); |
|
59 | - } |
|
50 | + /** |
|
51 | + * @param $hash |
|
52 | + * @param int $limit |
|
53 | + * @param int $offset |
|
54 | + * @return Event |
|
55 | + */ |
|
56 | + public function findByHash($hash, $limit = null, $offset = null) { |
|
57 | + $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE hash = ?'; |
|
58 | + return $this->findEntity($sql, [$hash], $limit, $offset); |
|
59 | + } |
|
60 | 60 | |
61 | - /** |
|
62 | - * @param $userId |
|
63 | - * @param int $limit |
|
64 | - * @param int $offset |
|
65 | - * @return Event[] |
|
66 | - */ |
|
67 | - public function findAllForUser($userId, $limit = null, $offset = null) { |
|
68 | - $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE owner = ?'; |
|
69 | - return $this->findEntities($sql, [$userId], $limit, $offset); |
|
70 | - } |
|
61 | + /** |
|
62 | + * @param $userId |
|
63 | + * @param int $limit |
|
64 | + * @param int $offset |
|
65 | + * @return Event[] |
|
66 | + */ |
|
67 | + public function findAllForUser($userId, $limit = null, $offset = null) { |
|
68 | + $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE owner = ?'; |
|
69 | + return $this->findEntities($sql, [$userId], $limit, $offset); |
|
70 | + } |
|
71 | 71 | |
72 | - /** |
|
73 | - * @param string $userId |
|
74 | - * @param int $limit |
|
75 | - * @param int $offset |
|
76 | - * @return Event[] |
|
77 | - */ |
|
78 | - public function findAllForUserWithInfo($userId, $limit = null, $offset = null) { |
|
79 | - $sql = 'SELECT DISTINCT *PREFIX*polls_events.id, |
|
72 | + /** |
|
73 | + * @param string $userId |
|
74 | + * @param int $limit |
|
75 | + * @param int $offset |
|
76 | + * @return Event[] |
|
77 | + */ |
|
78 | + public function findAllForUserWithInfo($userId, $limit = null, $offset = null) { |
|
79 | + $sql = 'SELECT DISTINCT *PREFIX*polls_events.id, |
|
80 | 80 | *PREFIX*polls_events.hash, |
81 | 81 | *PREFIX*polls_events.type, |
82 | 82 | *PREFIX*polls_events.title, |
@@ -101,6 +101,6 @@ discard block |
||
101 | 101 | OR |
102 | 102 | *PREFIX*polls_comments.user_id = ? |
103 | 103 | ORDER BY created'; |
104 | - return $this->findEntities($sql, ['hidden', $userId, 'hidden', $userId, $userId], $limit, $offset); |
|
105 | - } |
|
104 | + return $this->findEntities($sql, ['hidden', $userId, 'hidden', $userId, $userId], $limit, $offset); |
|
105 | + } |
|
106 | 106 | } |
@@ -44,7 +44,7 @@ discard block |
||
44 | 44 | */ |
45 | 45 | public function find($id) { |
46 | 46 | $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE id = ?'; |
47 | - return $this->findEntity($sql, [$id]); |
|
47 | + return $this->findEntity($sql, [ $id ]); |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | /** |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | */ |
56 | 56 | public function findByHash($hash, $limit = null, $offset = null) { |
57 | 57 | $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE hash = ?'; |
58 | - return $this->findEntity($sql, [$hash], $limit, $offset); |
|
58 | + return $this->findEntity($sql, [ $hash ], $limit, $offset); |
|
59 | 59 | } |
60 | 60 | |
61 | 61 | /** |
@@ -66,7 +66,7 @@ discard block |
||
66 | 66 | */ |
67 | 67 | public function findAllForUser($userId, $limit = null, $offset = null) { |
68 | 68 | $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE owner = ?'; |
69 | - return $this->findEntities($sql, [$userId], $limit, $offset); |
|
69 | + return $this->findEntities($sql, [ $userId ], $limit, $offset); |
|
70 | 70 | } |
71 | 71 | |
72 | 72 | /** |
@@ -101,6 +101,6 @@ discard block |
||
101 | 101 | OR |
102 | 102 | *PREFIX*polls_comments.user_id = ? |
103 | 103 | ORDER BY created'; |
104 | - return $this->findEntities($sql, ['hidden', $userId, 'hidden', $userId, $userId], $limit, $offset); |
|
104 | + return $this->findEntities($sql, [ 'hidden', $userId, 'hidden', $userId, $userId ], $limit, $offset); |
|
105 | 105 | } |
106 | 106 | } |
@@ -36,8 +36,8 @@ |
||
36 | 36 | * @method void setType(integer $value) |
37 | 37 | */ |
38 | 38 | class Participation extends Entity { |
39 | - public $dt; |
|
40 | - public $userId; |
|
41 | - public $pollId; |
|
42 | - public $type; |
|
39 | + public $dt; |
|
40 | + public $userId; |
|
41 | + public $pollId; |
|
42 | + public $type; |
|
43 | 43 | } |
@@ -48,14 +48,14 @@ |
||
48 | 48 | * @method void setFullAnonymous(integer $value) |
49 | 49 | */ |
50 | 50 | class Event extends Entity { |
51 | - public $type; |
|
52 | - public $title; |
|
53 | - public $description; |
|
54 | - public $owner; |
|
55 | - public $created; |
|
56 | - public $access; |
|
57 | - public $expire; |
|
58 | - public $hash; |
|
59 | - public $isAnonymous; |
|
60 | - public $fullAnonymous; |
|
51 | + public $type; |
|
52 | + public $title; |
|
53 | + public $description; |
|
54 | + public $owner; |
|
55 | + public $created; |
|
56 | + public $access; |
|
57 | + public $expire; |
|
58 | + public $hash; |
|
59 | + public $isAnonymous; |
|
60 | + public $fullAnonymous; |
|
61 | 61 | } |
@@ -28,50 +28,50 @@ |
||
28 | 28 | |
29 | 29 | class ParticipationTextMapper extends Mapper { |
30 | 30 | |
31 | - /** |
|
32 | - * ParticipationTextMapper constructor. |
|
33 | - * @param IDBConnection $db |
|
34 | - */ |
|
35 | - public function __construct(IDBConnection $db) { |
|
36 | - parent::__construct($db, 'polls_particip_text', '\OCA\Polls\Db\ParticipationText'); |
|
37 | - } |
|
31 | + /** |
|
32 | + * ParticipationTextMapper constructor. |
|
33 | + * @param IDBConnection $db |
|
34 | + */ |
|
35 | + public function __construct(IDBConnection $db) { |
|
36 | + parent::__construct($db, 'polls_particip_text', '\OCA\Polls\Db\ParticipationText'); |
|
37 | + } |
|
38 | 38 | |
39 | - /** |
|
40 | - * @param string $pollId |
|
41 | - * @param int $limit |
|
42 | - * @param int $offset |
|
43 | - * @return ParticipationText[] |
|
44 | - */ |
|
45 | - public function findByPoll($pollId, $limit = null, $offset = null) { |
|
46 | - $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
47 | - return $this->findEntities($sql, [$pollId], $limit, $offset); |
|
48 | - } |
|
39 | + /** |
|
40 | + * @param string $pollId |
|
41 | + * @param int $limit |
|
42 | + * @param int $offset |
|
43 | + * @return ParticipationText[] |
|
44 | + */ |
|
45 | + public function findByPoll($pollId, $limit = null, $offset = null) { |
|
46 | + $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
47 | + return $this->findEntities($sql, [$pollId], $limit, $offset); |
|
48 | + } |
|
49 | 49 | |
50 | - /** |
|
51 | - * @param string $userId |
|
52 | - * @param int $limit |
|
53 | - * @param int $offset |
|
54 | - * @return ParticipationText[] |
|
55 | - */ |
|
56 | - public function findDistinctByUser($userId, $limit = null, $offset = null) { |
|
57 | - $sql = 'SELECT DISTINCT * FROM ' . $this->getTableName() . ' WHERE user_id = ?'; |
|
58 | - return $this->findEntities($sql, [$userId], $limit, $offset); |
|
59 | - } |
|
50 | + /** |
|
51 | + * @param string $userId |
|
52 | + * @param int $limit |
|
53 | + * @param int $offset |
|
54 | + * @return ParticipationText[] |
|
55 | + */ |
|
56 | + public function findDistinctByUser($userId, $limit = null, $offset = null) { |
|
57 | + $sql = 'SELECT DISTINCT * FROM ' . $this->getTableName() . ' WHERE user_id = ?'; |
|
58 | + return $this->findEntities($sql, [$userId], $limit, $offset); |
|
59 | + } |
|
60 | 60 | |
61 | - /** |
|
62 | - * @param string $pollId |
|
63 | - */ |
|
64 | - public function deleteByPoll($pollId) { |
|
65 | - $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
66 | - $this->execute($sql, [$pollId]); |
|
67 | - } |
|
61 | + /** |
|
62 | + * @param string $pollId |
|
63 | + */ |
|
64 | + public function deleteByPoll($pollId) { |
|
65 | + $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
66 | + $this->execute($sql, [$pollId]); |
|
67 | + } |
|
68 | 68 | |
69 | - /** |
|
70 | - * @param string $pollId |
|
71 | - * @param string $userId |
|
72 | - */ |
|
73 | - public function deleteByPollAndUser($pollId, $userId) { |
|
74 | - $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ? AND user_id = ?'; |
|
75 | - $this->execute($sql, [$pollId, $userId]); |
|
76 | - } |
|
69 | + /** |
|
70 | + * @param string $pollId |
|
71 | + * @param string $userId |
|
72 | + */ |
|
73 | + public function deleteByPollAndUser($pollId, $userId) { |
|
74 | + $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ? AND user_id = ?'; |
|
75 | + $this->execute($sql, [$pollId, $userId]); |
|
76 | + } |
|
77 | 77 | } |
@@ -44,7 +44,7 @@ discard block |
||
44 | 44 | */ |
45 | 45 | public function findByPoll($pollId, $limit = null, $offset = null) { |
46 | 46 | $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
47 | - return $this->findEntities($sql, [$pollId], $limit, $offset); |
|
47 | + return $this->findEntities($sql, [ $pollId ], $limit, $offset); |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | /** |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | */ |
56 | 56 | public function findDistinctByUser($userId, $limit = null, $offset = null) { |
57 | 57 | $sql = 'SELECT DISTINCT * FROM ' . $this->getTableName() . ' WHERE user_id = ?'; |
58 | - return $this->findEntities($sql, [$userId], $limit, $offset); |
|
58 | + return $this->findEntities($sql, [ $userId ], $limit, $offset); |
|
59 | 59 | } |
60 | 60 | |
61 | 61 | /** |
@@ -63,7 +63,7 @@ discard block |
||
63 | 63 | */ |
64 | 64 | public function deleteByPoll($pollId) { |
65 | 65 | $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
66 | - $this->execute($sql, [$pollId]); |
|
66 | + $this->execute($sql, [ $pollId ]); |
|
67 | 67 | } |
68 | 68 | |
69 | 69 | /** |
@@ -72,6 +72,6 @@ discard block |
||
72 | 72 | */ |
73 | 73 | public function deleteByPollAndUser($pollId, $userId) { |
74 | 74 | $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ? AND user_id = ?'; |
75 | - $this->execute($sql, [$pollId, $userId]); |
|
75 | + $this->execute($sql, [ $pollId, $userId ]); |
|
76 | 76 | } |
77 | 77 | } |
@@ -28,30 +28,30 @@ |
||
28 | 28 | |
29 | 29 | class DateMapper extends Mapper { |
30 | 30 | |
31 | - /** |
|
32 | - * DateMapper constructor. |
|
33 | - * @param IDBConnection $db |
|
34 | - */ |
|
35 | - public function __construct(IDBConnection $db) { |
|
36 | - parent::__construct($db, 'polls_dts', '\OCA\Polls\Db\Date'); |
|
37 | - } |
|
31 | + /** |
|
32 | + * DateMapper constructor. |
|
33 | + * @param IDBConnection $db |
|
34 | + */ |
|
35 | + public function __construct(IDBConnection $db) { |
|
36 | + parent::__construct($db, 'polls_dts', '\OCA\Polls\Db\Date'); |
|
37 | + } |
|
38 | 38 | |
39 | - /** |
|
40 | - * @param string $pollId |
|
41 | - * @param int $limit |
|
42 | - * @param int $offset |
|
43 | - * @return Date[] |
|
44 | - */ |
|
45 | - public function findByPoll($pollId, $limit = null, $offset = null) { |
|
46 | - $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
47 | - return $this->findEntities($sql, [$pollId], $limit, $offset); |
|
48 | - } |
|
39 | + /** |
|
40 | + * @param string $pollId |
|
41 | + * @param int $limit |
|
42 | + * @param int $offset |
|
43 | + * @return Date[] |
|
44 | + */ |
|
45 | + public function findByPoll($pollId, $limit = null, $offset = null) { |
|
46 | + $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
47 | + return $this->findEntities($sql, [$pollId], $limit, $offset); |
|
48 | + } |
|
49 | 49 | |
50 | - /** |
|
51 | - * @param string $pollId |
|
52 | - */ |
|
53 | - public function deleteByPoll($pollId) { |
|
54 | - $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
55 | - $this->execute($sql, [$pollId]); |
|
56 | - } |
|
50 | + /** |
|
51 | + * @param string $pollId |
|
52 | + */ |
|
53 | + public function deleteByPoll($pollId) { |
|
54 | + $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
|
55 | + $this->execute($sql, [$pollId]); |
|
56 | + } |
|
57 | 57 | } |
@@ -44,7 +44,7 @@ discard block |
||
44 | 44 | */ |
45 | 45 | public function findByPoll($pollId, $limit = null, $offset = null) { |
46 | 46 | $sql = 'SELECT * FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
47 | - return $this->findEntities($sql, [$pollId], $limit, $offset); |
|
47 | + return $this->findEntities($sql, [ $pollId ], $limit, $offset); |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | /** |
@@ -52,6 +52,6 @@ discard block |
||
52 | 52 | */ |
53 | 53 | public function deleteByPoll($pollId) { |
54 | 54 | $sql = 'DELETE FROM ' . $this->getTableName() . ' WHERE poll_id = ?'; |
55 | - $this->execute($sql, [$pollId]); |
|
55 | + $this->execute($sql, [ $pollId ]); |
|
56 | 56 | } |
57 | 57 | } |
@@ -36,8 +36,8 @@ |
||
36 | 36 | * @method void setPollId(integer $value) |
37 | 37 | */ |
38 | 38 | class Comment extends Entity { |
39 | - public $userId; |
|
40 | - public $dt; |
|
41 | - public $comment; |
|
42 | - public $pollId; |
|
39 | + public $userId; |
|
40 | + public $dt; |
|
41 | + public $comment; |
|
42 | + public $pollId; |
|
43 | 43 | } |