@@ -7,7 +7,6 @@ |
||
7 | 7 | use Zend\Db\Adapter\AdapterAwareInterface; |
8 | 8 | use Zend\Db\TableGateway\AbstractTableGateway; |
9 | 9 | use Zend\Db\Sql\Delete; |
10 | -use Zend\Db\Sql\Insert; |
|
11 | 10 | |
12 | 11 | /** |
13 | 12 | * Class ArticleMapper. |
@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -declare(strict_types=1); |
|
2 | +declare(strict_types = 1); |
|
3 | 3 | |
4 | 4 | namespace Article\Mapper; |
5 | 5 | |
@@ -45,9 +45,9 @@ discard block |
||
45 | 45 | public function getCategories($articleId) |
46 | 46 | { |
47 | 47 | $select = $this->getSql()->select() |
48 | - ->columns([]) |
|
49 | - ->join('category', 'category.category_uuid = articles.category_uuid', ['name', 'slug', 'category_id']) |
|
50 | - ->where(['articles.article_id' => $articleId]); |
|
48 | + ->columns([ ]) |
|
49 | + ->join('category', 'category.category_uuid = articles.category_uuid', [ 'name', 'slug', 'category_id' ]) |
|
50 | + ->where([ 'articles.article_id' => $articleId ]); |
|
51 | 51 | |
52 | 52 | return $this->selectWith($select); |
53 | 53 | } |
@@ -12,7 +12,6 @@ |
||
12 | 12 | /** |
13 | 13 | * Fetches a list of ArticleEntity models. |
14 | 14 | * |
15 | - * @param array $params |
|
16 | 15 | * @return ArrayObject |
17 | 16 | */ |
18 | 17 | public function fetchAllArticles($page, $limit); |
@@ -63,6 +63,9 @@ |
||
63 | 63 | return $this->getPagination($select, $page, $limit); |
64 | 64 | } |
65 | 65 | |
66 | + /** |
|
67 | + * @param integer $limit |
|
68 | + */ |
|
66 | 69 | public function fetchLatest($limit) |
67 | 70 | { |
68 | 71 | return $this->articleEventsMapper->getLatest($limit); |
@@ -87,7 +87,7 @@ discard block |
||
87 | 87 | $articleFilter = $this->articleFilter->getInputFilter()->setData($data); |
88 | 88 | $eventFilter = $this->eventFilter->getInputFilter()->setData($data); |
89 | 89 | |
90 | - if(!$articleFilter->isValid() || !$eventFilter->isValid()) { |
|
90 | + if (!$articleFilter->isValid() || !$eventFilter->isValid()) { |
|
91 | 91 | throw new FilterException($articleFilter->getMessages() + $eventFilter->getMessages()); |
92 | 92 | } |
93 | 93 | |
@@ -96,15 +96,15 @@ discard block |
||
96 | 96 | |
97 | 97 | $article = $articleFilter->getValues(); |
98 | 98 | $article += [ |
99 | - 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article['admin_user_id']), |
|
99 | + 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]), |
|
100 | 100 | 'type' => ArticleType::EVENT, |
101 | 101 | 'article_id' => $id, |
102 | 102 | 'article_uuid' => $uuId |
103 | 103 | ]; |
104 | - unset($article['admin_user_id']); |
|
104 | + unset($article[ 'admin_user_id' ]); |
|
105 | 105 | |
106 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
107 | - unset($article['category_id']); |
|
106 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
107 | + unset($article[ 'category_id' ]); |
|
108 | 108 | |
109 | 109 | $event = $eventFilter->getValues() + [ |
110 | 110 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
@@ -122,50 +122,50 @@ discard block |
||
122 | 122 | $articleFilter = $this->articleFilter->getInputFilter()->setData($data); |
123 | 123 | $eventFilter = $this->eventFilter->getInputFilter()->setData($data); |
124 | 124 | |
125 | - if(!$articleFilter->isValid() || !$eventFilter->isValid()) { |
|
125 | + if (!$articleFilter->isValid() || !$eventFilter->isValid()) { |
|
126 | 126 | throw new FilterException($articleFilter->getMessages() + $eventFilter->getMessages()); |
127 | 127 | } |
128 | 128 | |
129 | - $article = $articleFilter->getValues() + ['article_uuid' => $oldArticle->article_uuid]; |
|
129 | + $article = $articleFilter->getValues() + [ 'article_uuid' => $oldArticle->article_uuid ]; |
|
130 | 130 | $event = $eventFilter->getValues() + [ |
131 | 131 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
132 | 132 | 'main_img' => $this->upload->uploadImage($data, 'main_img') |
133 | 133 | ]; |
134 | 134 | |
135 | - $article['admin_user_uuid'] = $this->adminUsersMapper->getUuid($article['admin_user_id']); |
|
136 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
137 | - unset($article['category_id'], $article['admin_user_id']); |
|
135 | + $article[ 'admin_user_uuid' ] = $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]); |
|
136 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
137 | + unset($article[ 'category_id' ], $article[ 'admin_user_id' ]); |
|
138 | 138 | |
139 | 139 | // We don't want to force user to re-upload image on edit |
140 | - if (!$event['featured_img']) { |
|
141 | - unset($event['featured_img']); |
|
140 | + if (!$event[ 'featured_img' ]) { |
|
141 | + unset($event[ 'featured_img' ]); |
|
142 | 142 | } |
143 | 143 | else { |
144 | 144 | $this->upload->deleteFile($oldArticle->featured_img); |
145 | 145 | } |
146 | 146 | |
147 | - if (!$event['main_img']) { |
|
148 | - unset($event['main_img']); |
|
147 | + if (!$event[ 'main_img' ]) { |
|
148 | + unset($event[ 'main_img' ]); |
|
149 | 149 | } |
150 | 150 | else { |
151 | 151 | $this->upload->deleteFile($oldArticle->main_img); |
152 | 152 | } |
153 | 153 | |
154 | - $this->articleMapper->update($article, ['article_uuid' => $article['article_uuid']]); |
|
155 | - $this->articleEventsMapper->update($event, ['article_uuid' => $article['article_uuid']]); |
|
154 | + $this->articleMapper->update($article, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
155 | + $this->articleEventsMapper->update($event, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
156 | 156 | } |
157 | 157 | |
158 | 158 | public function deleteArticle($id) |
159 | 159 | { |
160 | 160 | $event = $this->articleEventsMapper->get($id); |
161 | 161 | |
162 | - if(!$event) { |
|
162 | + if (!$event) { |
|
163 | 163 | throw new \Exception('Article not found!'); |
164 | 164 | } |
165 | 165 | |
166 | 166 | $this->upload->deleteFile($event->main_img); |
167 | 167 | $this->upload->deleteFile($event->featured_img); |
168 | - $this->articleEventsMapper->delete(['article_uuid' => $event->article_uuid]); |
|
168 | + $this->articleEventsMapper->delete([ 'article_uuid' => $event->article_uuid ]); |
|
169 | 169 | $this->delete($event->article_uuid); |
170 | 170 | } |
171 | 171 |
@@ -139,15 +139,13 @@ |
||
139 | 139 | // We don't want to force user to re-upload image on edit |
140 | 140 | if (!$event['featured_img']) { |
141 | 141 | unset($event['featured_img']); |
142 | - } |
|
143 | - else { |
|
142 | + } else { |
|
144 | 143 | $this->upload->deleteFile($oldArticle->featured_img); |
145 | 144 | } |
146 | 145 | |
147 | 146 | if (!$event['main_img']) { |
148 | 147 | unset($event['main_img']); |
149 | - } |
|
150 | - else { |
|
148 | + } else { |
|
151 | 149 | $this->upload->deleteFile($oldArticle->main_img); |
152 | 150 | } |
153 | 151 |
@@ -203,6 +203,9 @@ |
||
203 | 203 | return $this->articleMapper->getCategories($articleId); |
204 | 204 | } |
205 | 205 | |
206 | + /** |
|
207 | + * @param integer $limit |
|
208 | + */ |
|
206 | 209 | public function getLatestWeb($limit) |
207 | 210 | { |
208 | 211 | return $this->articlePostsMapper->getLatest($limit); |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -declare(strict_types=1); |
|
3 | +declare(strict_types = 1); |
|
4 | 4 | |
5 | 5 | namespace Article\Service; |
6 | 6 | |
@@ -95,7 +95,7 @@ discard block |
||
95 | 95 | $articleFilter = $this->articleFilter->getInputFilter()->setData($data); |
96 | 96 | $postFilter = $this->postFilter->getInputFilter()->setData($data); |
97 | 97 | |
98 | - if(!$articleFilter->isValid() || !$postFilter->isValid()) { |
|
98 | + if (!$articleFilter->isValid() || !$postFilter->isValid()) { |
|
99 | 99 | throw new FilterException($articleFilter->getMessages() + $postFilter->getMessages()); |
100 | 100 | } |
101 | 101 | |
@@ -104,19 +104,19 @@ discard block |
||
104 | 104 | |
105 | 105 | $article = $articleFilter->getValues(); |
106 | 106 | $article += [ |
107 | - 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article['admin_user_id']), |
|
107 | + 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]), |
|
108 | 108 | 'type' => ArticleType::POST, |
109 | 109 | 'article_id' => $id, |
110 | 110 | 'article_uuid' => $uuId |
111 | 111 | ]; |
112 | 112 | |
113 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
114 | - unset($article['category_id'], $article['admin_user_id']); |
|
113 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
114 | + unset($article[ 'category_id' ], $article[ 'admin_user_id' ]); |
|
115 | 115 | |
116 | 116 | $post = $postFilter->getValues() + [ |
117 | 117 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
118 | 118 | 'main_img' => $this->upload->uploadImage($data, 'main_img'), |
119 | - 'article_uuid' => $article['article_uuid'] |
|
119 | + 'article_uuid' => $article[ 'article_uuid' ] |
|
120 | 120 | ]; |
121 | 121 | |
122 | 122 | $this->articleMapper->insert($article); |
@@ -129,37 +129,37 @@ discard block |
||
129 | 129 | $articleFilter = $this->articleFilter->getInputFilter()->setData($data); |
130 | 130 | $postFilter = $this->postFilter->getInputFilter()->setData($data); |
131 | 131 | |
132 | - if(!$articleFilter->isValid() || !$postFilter->isValid()) { |
|
132 | + if (!$articleFilter->isValid() || !$postFilter->isValid()) { |
|
133 | 133 | throw new FilterException($articleFilter->getMessages() + $postFilter->getMessages()); |
134 | 134 | } |
135 | 135 | |
136 | - $article = $articleFilter->getValues() + ['article_uuid' => $oldArticle->article_uuid]; |
|
136 | + $article = $articleFilter->getValues() + [ 'article_uuid' => $oldArticle->article_uuid ]; |
|
137 | 137 | $post = $postFilter->getValues() + [ |
138 | 138 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
139 | 139 | 'main_img' => $this->upload->uploadImage($data, 'main_img') |
140 | 140 | ]; |
141 | 141 | |
142 | - $article['admin_user_uuid'] = $this->adminUsersMapper->getUuid($article['admin_user_id']); |
|
143 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
144 | - unset($article['category_id'], $article['admin_user_id']); |
|
142 | + $article[ 'admin_user_uuid' ] = $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]); |
|
143 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
144 | + unset($article[ 'category_id' ], $article[ 'admin_user_id' ]); |
|
145 | 145 | |
146 | 146 | // We don't want to force user to re-upload image on edit |
147 | - if (!$post['featured_img']) { |
|
148 | - unset($post['featured_img']); |
|
147 | + if (!$post[ 'featured_img' ]) { |
|
148 | + unset($post[ 'featured_img' ]); |
|
149 | 149 | } |
150 | 150 | else { |
151 | 151 | $this->upload->deleteFile($oldArticle->featured_img); |
152 | 152 | } |
153 | 153 | |
154 | - if (!$post['main_img']) { |
|
155 | - unset($post['main_img']); |
|
154 | + if (!$post[ 'main_img' ]) { |
|
155 | + unset($post[ 'main_img' ]); |
|
156 | 156 | } |
157 | 157 | else { |
158 | 158 | $this->upload->deleteFile($oldArticle->main_img); |
159 | 159 | } |
160 | 160 | |
161 | - $this->articleMapper->update($article, ['article_uuid' => $article['article_uuid']]); |
|
162 | - $this->articlePostsMapper->update($post, ['article_uuid' => $article['article_uuid']]); |
|
161 | + $this->articleMapper->update($article, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
162 | + $this->articlePostsMapper->update($post, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
163 | 163 | } |
164 | 164 | |
165 | 165 | public function deleteArticle($id) |
@@ -172,7 +172,7 @@ discard block |
||
172 | 172 | |
173 | 173 | $this->upload->deleteFile($post->main_img); |
174 | 174 | $this->upload->deleteFile($post->featured_img); |
175 | - $this->articlePostsMapper->delete(['article_uuid' => $post->article_uuid]); |
|
175 | + $this->articlePostsMapper->delete([ 'article_uuid' => $post->article_uuid ]); |
|
176 | 176 | $this->delete($post->article_uuid); |
177 | 177 | } |
178 | 178 |
@@ -146,15 +146,13 @@ |
||
146 | 146 | // We don't want to force user to re-upload image on edit |
147 | 147 | if (!$post['featured_img']) { |
148 | 148 | unset($post['featured_img']); |
149 | - } |
|
150 | - else { |
|
149 | + } else { |
|
151 | 150 | $this->upload->deleteFile($oldArticle->featured_img); |
152 | 151 | } |
153 | 152 | |
154 | 153 | if (!$post['main_img']) { |
155 | 154 | unset($post['main_img']); |
156 | - } |
|
157 | - else { |
|
155 | + } else { |
|
158 | 156 | $this->upload->deleteFile($oldArticle->main_img); |
159 | 157 | } |
160 | 158 |
@@ -91,6 +91,9 @@ |
||
91 | 91 | return $this->getPagination($select, $page, $limit); |
92 | 92 | } |
93 | 93 | |
94 | + /** |
|
95 | + * @param integer $limit |
|
96 | + */ |
|
94 | 97 | public function fetchLatest($limit) |
95 | 98 | { |
96 | 99 | return $this->articleVideosMapper->getLatest($limit); |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -declare(strict_types=1); |
|
3 | +declare(strict_types = 1); |
|
4 | 4 | |
5 | 5 | namespace Article\Service; |
6 | 6 | |
@@ -106,7 +106,7 @@ discard block |
||
106 | 106 | $articleFilter = $this->articleFilter->getInputFilter()->setData($data); |
107 | 107 | $videosFilter = $this->videosFilter->getInputFilter()->setData($data); |
108 | 108 | |
109 | - if(!$articleFilter->isValid() || !$videosFilter->isValid()) { |
|
109 | + if (!$articleFilter->isValid() || !$videosFilter->isValid()) { |
|
110 | 110 | throw new FilterException($articleFilter->getMessages() + $videosFilter->getMessages()); |
111 | 111 | } |
112 | 112 | |
@@ -115,14 +115,14 @@ discard block |
||
115 | 115 | |
116 | 116 | $article = $articleFilter->getValues(); |
117 | 117 | $article += [ |
118 | - 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article['admin_user_id']), |
|
118 | + 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]), |
|
119 | 119 | 'type' => ArticleType::VIDEO, |
120 | 120 | 'article_id' => $id, |
121 | 121 | 'article_uuid' => $uuId |
122 | 122 | ]; |
123 | 123 | |
124 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
125 | - unset($article['category_id'], $article['admin_user_id']); |
|
124 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
125 | + unset($article[ 'category_id' ], $article[ 'admin_user_id' ]); |
|
126 | 126 | |
127 | 127 | $videos = $videosFilter->getValues() + [ |
128 | 128 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
@@ -140,15 +140,15 @@ discard block |
||
140 | 140 | $articleFilter = $this->articleFilter->getInputFilter()->setData($data); |
141 | 141 | $videosFilter = $this->videosFilter->getInputFilter()->setData($data); |
142 | 142 | |
143 | - if(!$articleFilter->isValid() || !$videosFilter->isValid()) { |
|
143 | + if (!$articleFilter->isValid() || !$videosFilter->isValid()) { |
|
144 | 144 | throw new FilterException($articleFilter->getMessages() + $videosFilter->getMessages()); |
145 | 145 | } |
146 | 146 | |
147 | - $article = $articleFilter->getValues() + ['article_uuid' => $oldArticle->article_uuid]; |
|
148 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
149 | - $article['admin_user_uuid'] = $this->adminUsersMapper->getUuid($article['admin_user_id']); |
|
150 | - unset($article['category_id']); |
|
151 | - unset($article['admin_user_id']); |
|
147 | + $article = $articleFilter->getValues() + [ 'article_uuid' => $oldArticle->article_uuid ]; |
|
148 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
149 | + $article[ 'admin_user_uuid' ] = $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]); |
|
150 | + unset($article[ 'category_id' ]); |
|
151 | + unset($article[ 'admin_user_id' ]); |
|
152 | 152 | |
153 | 153 | $videos = $videosFilter->getValues() + [ |
154 | 154 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
@@ -156,35 +156,35 @@ discard block |
||
156 | 156 | ]; |
157 | 157 | |
158 | 158 | // We don't want to force user to re-upload image on edit |
159 | - if(!$videos['featured_img']) { |
|
160 | - unset($videos['featured_img']); |
|
159 | + if (!$videos[ 'featured_img' ]) { |
|
160 | + unset($videos[ 'featured_img' ]); |
|
161 | 161 | } |
162 | 162 | else { |
163 | 163 | $this->upload->deleteFile($oldArticle->featured_img); |
164 | 164 | } |
165 | 165 | |
166 | - if(!$videos['main_img']) { |
|
167 | - unset($videos['main_img']); |
|
166 | + if (!$videos[ 'main_img' ]) { |
|
167 | + unset($videos[ 'main_img' ]); |
|
168 | 168 | } |
169 | 169 | else { |
170 | 170 | $this->upload->deleteFile($oldArticle->main_img); |
171 | 171 | } |
172 | 172 | |
173 | - $this->articleMapper->update($article, ['article_uuid' => $article['article_uuid']]); |
|
174 | - $this->articleVideosMapper->update($videos, ['article_uuid' => $article['article_uuid']]); |
|
173 | + $this->articleMapper->update($article, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
174 | + $this->articleVideosMapper->update($videos, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
175 | 175 | } |
176 | 176 | |
177 | 177 | public function deleteArticle($id) |
178 | 178 | { |
179 | 179 | $video = $this->articleVideosMapper->get($id); |
180 | 180 | |
181 | - if(!$video) { |
|
181 | + if (!$video) { |
|
182 | 182 | throw new \Exception('Article not found!'); |
183 | 183 | } |
184 | 184 | |
185 | 185 | $this->upload->deleteFile($video->main_img); |
186 | 186 | $this->upload->deleteFile($video->featured_img); |
187 | - $this->articleVideosMapper->delete(['article_uuid' => $video->article_uuid]); |
|
187 | + $this->articleVideosMapper->delete([ 'article_uuid' => $video->article_uuid ]); |
|
188 | 188 | $this->delete($video->article_uuid); |
189 | 189 | } |
190 | 190 |
@@ -158,15 +158,13 @@ |
||
158 | 158 | // We don't want to force user to re-upload image on edit |
159 | 159 | if(!$videos['featured_img']) { |
160 | 160 | unset($videos['featured_img']); |
161 | - } |
|
162 | - else { |
|
161 | + } else { |
|
163 | 162 | $this->upload->deleteFile($oldArticle->featured_img); |
164 | 163 | } |
165 | 164 | |
166 | 165 | if(!$videos['main_img']) { |
167 | 166 | unset($videos['main_img']); |
168 | - } |
|
169 | - else { |
|
167 | + } else { |
|
170 | 168 | $this->upload->deleteFile($oldArticle->main_img); |
171 | 169 | } |
172 | 170 |
@@ -44,6 +44,9 @@ |
||
44 | 44 | return $select; |
45 | 45 | } |
46 | 46 | |
47 | + /** |
|
48 | + * @param integer $limit |
|
49 | + */ |
|
47 | 50 | public function getCategoryPostsSelect($categoryId = null, $limit = null) |
48 | 51 | { |
49 | 52 | $select = $this->getSql()->select() |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -declare(strict_types=1); |
|
3 | +declare(strict_types = 1); |
|
4 | 4 | |
5 | 5 | namespace Category\Mapper; |
6 | 6 | |
@@ -34,12 +34,12 @@ discard block |
||
34 | 34 | |
35 | 35 | public function get($id) |
36 | 36 | { |
37 | - return $this->select(['category_id' => $id])->current(); |
|
37 | + return $this->select([ 'category_id' => $id ])->current(); |
|
38 | 38 | } |
39 | 39 | |
40 | 40 | public function getPaginationSelect() |
41 | 41 | { |
42 | - $select = $this->getSql()->select()->order(['name' => 'asc']); |
|
42 | + $select = $this->getSql()->select()->order([ 'name' => 'asc' ]); |
|
43 | 43 | |
44 | 44 | return $select; |
45 | 45 | } |
@@ -47,18 +47,18 @@ discard block |
||
47 | 47 | public function getCategoryPostsSelect($categoryId = null, $limit = null) |
48 | 48 | { |
49 | 49 | $select = $this->getSql()->select() |
50 | - ->columns(['category_name' => 'name', 'category_slug' => 'slug']) |
|
51 | - ->join('articles', 'articles.category_uuid = category.category_uuid', ['article_id', 'slug', 'admin_user_uuid', 'published_at']) |
|
52 | - ->join('article_posts', 'article_posts.article_uuid = articles.article_uuid', ['*'], 'right') |
|
53 | - ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['admin_user_id', 'first_name', 'last_name', 'face_img']) |
|
54 | - ->where(['articles.status' => 1]) |
|
55 | - ->order(['published_at' => 'desc']); |
|
56 | - |
|
57 | - if($categoryId) { |
|
58 | - $select->where(['category_id' => $categoryId]); |
|
50 | + ->columns([ 'category_name' => 'name', 'category_slug' => 'slug' ]) |
|
51 | + ->join('articles', 'articles.category_uuid = category.category_uuid', [ 'article_id', 'slug', 'admin_user_uuid', 'published_at' ]) |
|
52 | + ->join('article_posts', 'article_posts.article_uuid = articles.article_uuid', [ '*' ], 'right') |
|
53 | + ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'admin_user_id', 'first_name', 'last_name', 'face_img' ]) |
|
54 | + ->where([ 'articles.status' => 1 ]) |
|
55 | + ->order([ 'published_at' => 'desc' ]); |
|
56 | + |
|
57 | + if ($categoryId) { |
|
58 | + $select->where([ 'category_id' => $categoryId ]); |
|
59 | 59 | } |
60 | 60 | |
61 | - if($limit) { |
|
61 | + if ($limit) { |
|
62 | 62 | $select->limit($limit); |
63 | 63 | } |
64 | 64 | |
@@ -86,19 +86,19 @@ discard block |
||
86 | 86 | $select->where->notEqualTo('slug', 'videos'); |
87 | 87 | $select->where->notEqualTo('slug', 'events'); |
88 | 88 | |
89 | - if($inHomepage !== null){ |
|
90 | - $select->where(['is_in_homepage' => $inHomepage]); |
|
89 | + if ($inHomepage !== null) { |
|
90 | + $select->where([ 'is_in_homepage' => $inHomepage ]); |
|
91 | 91 | } |
92 | 92 | |
93 | - if($inCategoryList !== null){ |
|
94 | - $select->where(['is_in_category_list' => $inCategoryList]); |
|
93 | + if ($inCategoryList !== null) { |
|
94 | + $select->where([ 'is_in_category_list' => $inCategoryList ]); |
|
95 | 95 | } |
96 | 96 | |
97 | - if($limit) { |
|
97 | + if ($limit) { |
|
98 | 98 | $select->limit($limit); |
99 | 99 | } |
100 | 100 | |
101 | - if($order) { |
|
101 | + if ($order) { |
|
102 | 102 | $select->order($order); |
103 | 103 | } else { |
104 | 104 | $select->order(new Expression('rand()')); |
@@ -31,6 +31,9 @@ discard block |
||
31 | 31 | $this->adapter = $adapter; |
32 | 32 | } |
33 | 33 | |
34 | + /** |
|
35 | + * @param string $id |
|
36 | + */ |
|
34 | 37 | public function get($id) |
35 | 38 | { |
36 | 39 | return $this->select(['admin_user_id' => $id])->current(); |
@@ -40,7 +43,7 @@ discard block |
||
40 | 43 | * Get admin user by email. |
41 | 44 | * |
42 | 45 | * @param string $email email |
43 | - * @return array|\ArrayObject|null |
|
46 | + * @return string |
|
44 | 47 | */ |
45 | 48 | public function getByEmail(string $email) |
46 | 49 | { |
@@ -50,7 +53,6 @@ discard block |
||
50 | 53 | /** |
51 | 54 | * Updates login data. |
52 | 55 | * |
53 | - * @param string $uuid admin user id |
|
54 | 56 | * @return int number of affected rows |
55 | 57 | */ |
56 | 58 | public function updateLogin(string $userId): int |
@@ -58,6 +60,9 @@ discard block |
||
58 | 60 | return $this->update(['last_login' => date('Y-m-d H:i:s')], ['admin_user_id' => $userId]); |
59 | 61 | } |
60 | 62 | |
63 | + /** |
|
64 | + * @param string $userId |
|
65 | + */ |
|
61 | 66 | public function getPaginationSelect($userId) |
62 | 67 | { |
63 | 68 | $select = $this->getSql()->select()->order(['created_at' => 'desc']); |
@@ -67,6 +72,9 @@ discard block |
||
67 | 72 | return $select; |
68 | 73 | } |
69 | 74 | |
75 | + /** |
|
76 | + * @param integer $limit |
|
77 | + */ |
|
70 | 78 | public function getRandom($limit) |
71 | 79 | { |
72 | 80 | $select = $this->getSql()->select() |
@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -declare(strict_types=1); |
|
2 | +declare(strict_types = 1); |
|
3 | 3 | |
4 | 4 | namespace Core\Mapper; |
5 | 5 | |
@@ -33,7 +33,7 @@ discard block |
||
33 | 33 | |
34 | 34 | public function get($id) |
35 | 35 | { |
36 | - return $this->select(['admin_user_id' => $id])->current(); |
|
36 | + return $this->select([ 'admin_user_id' => $id ])->current(); |
|
37 | 37 | } |
38 | 38 | |
39 | 39 | /** |
@@ -44,7 +44,7 @@ discard block |
||
44 | 44 | */ |
45 | 45 | public function getByEmail(string $email) |
46 | 46 | { |
47 | - return $this->select(['email' => $email])->current(); |
|
47 | + return $this->select([ 'email' => $email ])->current(); |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | /** |
@@ -55,12 +55,12 @@ discard block |
||
55 | 55 | */ |
56 | 56 | public function updateLogin(string $userId): int |
57 | 57 | { |
58 | - return $this->update(['last_login' => date('Y-m-d H:i:s')], ['admin_user_id' => $userId]); |
|
58 | + return $this->update([ 'last_login' => date('Y-m-d H:i:s') ], [ 'admin_user_id' => $userId ]); |
|
59 | 59 | } |
60 | 60 | |
61 | 61 | public function getPaginationSelect($userId) |
62 | 62 | { |
63 | - $select = $this->getSql()->select()->order(['created_at' => 'desc']); |
|
63 | + $select = $this->getSql()->select()->order([ 'created_at' => 'desc' ]); |
|
64 | 64 | |
65 | 65 | $select->where->notEqualTo('admin_user_id', $userId); |
66 | 66 | |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | public function getRandom($limit) |
71 | 71 | { |
72 | 72 | $select = $this->getSql()->select() |
73 | - ->where(['status' => 1]) |
|
73 | + ->where([ 'status' => 1 ]) |
|
74 | 74 | ->order(new Expression('rand()')) |
75 | 75 | ->limit($limit); |
76 | 76 | |
@@ -79,9 +79,9 @@ discard block |
||
79 | 79 | |
80 | 80 | public function getUuid($adminUserId) |
81 | 81 | { |
82 | - $user = $this->select(['admin_user_id' => $adminUserId])->current(); |
|
82 | + $user = $this->select([ 'admin_user_id' => $adminUserId ])->current(); |
|
83 | 83 | |
84 | - if(!$user) { |
|
84 | + if (!$user) { |
|
85 | 85 | throw new \Exception('Admin user does not exist!', 400); |
86 | 86 | } |
87 | 87 |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | $articleFilter = $this->articleFilter->getInputFilter()->setData($data); |
54 | 54 | $discussionFilter = $this->discussionFilter->getInputFilter()->setData($data); |
55 | 55 | |
56 | - if(!$articleFilter->isValid() || !$discussionFilter->isValid()) { |
|
56 | + if (!$articleFilter->isValid() || !$discussionFilter->isValid()) { |
|
57 | 57 | throw new FilterException($articleFilter->getMessages() + $discussionFilter->getMessages()); |
58 | 58 | } |
59 | 59 | |
@@ -62,16 +62,16 @@ discard block |
||
62 | 62 | |
63 | 63 | $article = $articleFilter->getValues(); |
64 | 64 | $article += [ |
65 | - 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article['admin_user_id']), |
|
65 | + 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]), |
|
66 | 66 | 'type' => ArticleType::DISCUSSION, |
67 | 67 | 'article_id' => $id, |
68 | 68 | 'article_uuid' => $uuId |
69 | 69 | ]; |
70 | 70 | |
71 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
72 | - unset($article['category_id'], $article['admin_user_id']); |
|
71 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
72 | + unset($article[ 'category_id' ], $article[ 'admin_user_id' ]); |
|
73 | 73 | |
74 | - $discussion = $discussionFilter->getValues() + ['article_uuid' => $uuId]; |
|
74 | + $discussion = $discussionFilter->getValues() + [ 'article_uuid' => $uuId ]; |
|
75 | 75 | |
76 | 76 | $this->articleMapper->insert($article); |
77 | 77 | $this->articleDiscussionsMapper->insert($discussion); |
@@ -83,30 +83,30 @@ discard block |
||
83 | 83 | $articleFilter = $this->articleFilter->getInputFilter()->setData($data); |
84 | 84 | $discussionFilter = $this->discussionFilter->getInputFilter()->setData($data); |
85 | 85 | |
86 | - if(!$articleFilter->isValid() || !$discussionFilter->isValid()) { |
|
86 | + if (!$articleFilter->isValid() || !$discussionFilter->isValid()) { |
|
87 | 87 | throw new FilterException($articleFilter->getMessages() + $discussionFilter->getMessages()); |
88 | 88 | } |
89 | 89 | |
90 | - $article = $articleFilter->getValues() + ['article_uuid' => $article->article_uuid]; |
|
90 | + $article = $articleFilter->getValues() + [ 'article_uuid' => $article->article_uuid ]; |
|
91 | 91 | $discussion = $discussionFilter->getValues(); |
92 | 92 | |
93 | - $article['admin_user_uuid'] = $this->adminUsersMapper->getUuid($article['admin_user_id']); |
|
94 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
95 | - unset($article['category_id'], $article['admin_user_id']); |
|
93 | + $article[ 'admin_user_uuid' ] = $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]); |
|
94 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
95 | + unset($article[ 'category_id' ], $article[ 'admin_user_id' ]); |
|
96 | 96 | |
97 | - $this->articleMapper->update($article, ['article_uuid' => $article['article_uuid']]); |
|
98 | - $this->articleDiscussionsMapper->update($discussion, ['article_uuid' => $article['article_uuid']]); |
|
97 | + $this->articleMapper->update($article, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
98 | + $this->articleDiscussionsMapper->update($discussion, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
99 | 99 | } |
100 | 100 | |
101 | 101 | public function deleteArticle($id) |
102 | 102 | { |
103 | 103 | $discussion = $this->articleDiscussionsMapper->get($id); |
104 | 104 | |
105 | - if(!$discussion) { |
|
105 | + if (!$discussion) { |
|
106 | 106 | throw new \Exception('Article not found!'); |
107 | 107 | } |
108 | 108 | |
109 | - $this->articleDiscussionsMapper->delete(['article_uuid' => $discussion->article_uuid]); |
|
109 | + $this->articleDiscussionsMapper->delete([ 'article_uuid' => $discussion->article_uuid ]); |
|
110 | 110 | $this->delete($discussion->article_uuid); |
111 | 111 | } |
112 | 112 | } |
@@ -31,9 +31,9 @@ discard block |
||
31 | 31 | |
32 | 32 | public function getCategoryIds($articleId) |
33 | 33 | { |
34 | - $categories = []; |
|
35 | - foreach($this->articleMapper->getCategories($articleId) as $category) { |
|
36 | - $categories[] = $category->category_id; |
|
34 | + $categories = [ ]; |
|
35 | + foreach ($this->articleMapper->getCategories($articleId) as $category) { |
|
36 | + $categories[ ] = $category->category_id; |
|
37 | 37 | } |
38 | 38 | |
39 | 39 | return $categories; |
@@ -41,6 +41,6 @@ discard block |
||
41 | 41 | |
42 | 42 | public function delete($articleId) |
43 | 43 | { |
44 | - $this->articleMapper->delete(['article_uuid' => $articleId]); |
|
44 | + $this->articleMapper->delete([ 'article_uuid' => $articleId ]); |
|
45 | 45 | } |
46 | 46 | } |
47 | 47 | \ No newline at end of file |