Completed
Pull Request — master (#120)
by
unknown
146:16 queued 127:02
created
application/data/phinx/migrations/20161229132343_article_discussions.php 2 patches
Unused Use Statements   -1 removed lines patch added patch discarded remove patch
@@ -4,7 +4,6 @@
 block discarded – undo
4 4
 use MysqlUuid\Formats\Binary;
5 5
 use MysqlUuid\Uuid;
6 6
 use Core\Entity\ArticleType;
7
-use MysqlUuid\Formats\PlainString;
8 7
 
9 8
 class ArticleDiscussions extends AbstractMigration
10 9
 {
Please login to merge, or discard this patch.
Spacing   +8 added lines, -8 removed lines patch added patch discarded remove patch
@@ -10,11 +10,11 @@  discard block
 block discarded – undo
10 10
 {
11 11
     public function up()
12 12
     {
13
-        $this->table('article_discussions', ['id' => false])
14
-            ->addColumn('article_uuid', 'binary', ['limit' => 16])
13
+        $this->table('article_discussions', [ 'id' => false ])
14
+            ->addColumn('article_uuid', 'binary', [ 'limit' => 16 ])
15 15
             ->addColumn('title', 'text')
16 16
             ->addColumn('body', 'text')
17
-            ->addForeignKey('article_uuid', 'articles', 'article_uuid', ['delete' => 'NO_ACTION', 'update' => 'NO_ACTION'])
17
+            ->addForeignKey('article_uuid', 'articles', 'article_uuid', [ 'delete' => 'NO_ACTION', 'update' => 'NO_ACTION' ])
18 18
             ->create();
19 19
 
20 20
 //        $this->insertDummyData();
@@ -27,15 +27,15 @@  discard block
 block discarded – undo
27 27
 
28 28
     private function insertDummyData()
29 29
     {
30
-        $ids  = [];
30
+        $ids  = [ ];
31 31
         $rows = $this->fetchAll('select admin_user_uuid from admin_users;');
32
-        foreach($rows as $r){
33
-            $ids[] = $r['admin_user_uuid'];
32
+        foreach ($rows as $r) {
33
+            $ids[ ] = $r[ 'admin_user_uuid' ];
34 34
         }
35 35
 
36 36
         $faker = Faker\Factory::create();
37 37
         $count = rand(250, 300);
38
-        for($i = 0; $i < $count; $i++){
38
+        for ($i = 0; $i < $count; $i++) {
39 39
             $id        = $faker->uuid;
40 40
             $mysqluuid = (new Uuid($id))->toFormat(new Binary());
41 41
             $title     = $faker->sentence(5, 15);
@@ -45,7 +45,7 @@  discard block
 block discarded – undo
45 45
                 'article_id'      => $id,
46 46
                 'slug'            => strtolower(trim(preg_replace('~[^\pL\d]+~u', '-', $title), '-')),
47 47
                 'status'          => 1,
48
-                'admin_user_uuid' => $ids[array_rand($ids)],
48
+                'admin_user_uuid' => $ids[ array_rand($ids) ],
49 49
                 'type'            => ArticleType::DISCUSSION
50 50
             ];
51 51
 
Please login to merge, or discard this patch.
application/packages/Admin/src/Mapper/AdminUsersMapper.php 2 patches
Doc Comments   +12 added lines, -2 removed lines patch added patch discarded remove patch
@@ -31,6 +31,9 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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,11 @@  discard block
 block discarded – undo
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
+     *
66
+     * @return \Zend\Db\Sql\Select
67
+     */
61 68
     public function getPaginationSelect($userId)
62 69
     {
63 70
         $select = $this->getSql()->select()->order(['created_at' => 'desc']);
@@ -67,6 +74,9 @@  discard block
 block discarded – undo
67 74
         return $select;
68 75
     }
69 76
 
77
+    /**
78
+     * @param integer $limit
79
+     */
70 80
     public function getRandom($limit)
71 81
     {
72 82
         $select = $this->getSql()->select()
Please login to merge, or discard this patch.
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -32,7 +32,7 @@  discard block
 block discarded – undo
32 32
 
33 33
     public function get($id)
34 34
     {
35
-        return $this->select(['admin_user_id' => $id])->current();
35
+        return $this->select([ 'admin_user_id' => $id ])->current();
36 36
     }
37 37
 
38 38
     /**
@@ -43,7 +43,7 @@  discard block
 block discarded – undo
43 43
      */
44 44
     public function getByEmail(string $email)
45 45
     {
46
-        return $this->select(['email' => $email])->current();
46
+        return $this->select([ 'email' => $email ])->current();
47 47
     }
48 48
 
49 49
     /**
@@ -54,12 +54,12 @@  discard block
 block discarded – undo
54 54
      */
55 55
     public function updateLogin(string $userId): int
56 56
     {
57
-        return $this->update(['last_login' => date('Y-m-d H:i:s')], ['admin_user_id' => $userId]);
57
+        return $this->update([ 'last_login' => date('Y-m-d H:i:s') ], [ 'admin_user_id' => $userId ]);
58 58
     }
59 59
 
60 60
     public function getPaginationSelect($userId)
61 61
     {
62
-        $select = $this->getSql()->select()->order(['created_at' => 'desc']);
62
+        $select = $this->getSql()->select()->order([ 'created_at' => 'desc' ]);
63 63
 
64 64
         $select->where->notEqualTo('admin_user_id', $userId);
65 65
 
@@ -69,7 +69,7 @@  discard block
 block discarded – undo
69 69
     public function getRandom($limit)
70 70
     {
71 71
         $select = $this->getSql()->select()
72
-            ->where(['status' => 1])
72
+            ->where([ 'status' => 1 ])
73 73
             ->order(new Expression('rand()'))
74 74
             ->limit($limit);
75 75
 
@@ -78,7 +78,7 @@  discard block
 block discarded – undo
78 78
 
79 79
     public function getUuid($adminUserId)
80 80
     {
81
-        $user = $this->select(['admin_user_id' => $adminUserId])->current();
81
+        $user = $this->select([ 'admin_user_id' => $adminUserId ])->current();
82 82
 
83 83
         if (!$user) {
84 84
             throw new \Exception('Admin user does not exist!', 400);
Please login to merge, or discard this patch.
application/packages/Admin/src/View/Helper/AdminUserHelper.php 1 patch
Doc Comments   +3 added lines patch added patch discarded remove patch
@@ -22,6 +22,9 @@
 block discarded – undo
22 22
         return $this;
23 23
     }
24 24
 
25
+    /**
26
+     * @return boolean
27
+     */
25 28
     public function current()
26 29
     {
27 30
         return $this->session->getStorage()->user;
Please login to merge, or discard this patch.
application/packages/Article/src/Mapper/ArticleMapper.php 2 patches
Unused Use Statements   -1 removed lines patch added patch discarded remove patch
@@ -7,7 +7,6 @@
 block discarded – undo
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.
Please login to merge, or discard this patch.
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -44,9 +44,9 @@
 block discarded – undo
44 44
     public function getCategories($articleId)
45 45
     {
46 46
         $select = $this->getSql()->select()
47
-            ->columns([])
48
-            ->join('category', 'category.category_uuid = articles.category_uuid', ['name', 'slug', 'category_id'])
49
-            ->where(['articles.article_id' => $articleId]);
47
+            ->columns([ ])
48
+            ->join('category', 'category.category_uuid = articles.category_uuid', [ 'name', 'slug', 'category_id' ])
49
+            ->where([ 'articles.article_id' => $articleId ]);
50 50
 
51 51
         return $this->selectWith($select);
52 52
     }
Please login to merge, or discard this patch.
application/packages/Article/src/Service/ArticleServiceInterface.php 1 patch
Doc Comments   -1 removed lines patch added patch discarded remove patch
@@ -12,7 +12,6 @@
 block discarded – undo
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);
Please login to merge, or discard this patch.
application/packages/Article/src/Service/EventService.php 2 patches
Doc Comments   +3 added lines patch added patch discarded remove patch
@@ -63,6 +63,9 @@
 block discarded – undo
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);
Please login to merge, or discard this patch.
Spacing   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -101,15 +101,15 @@  discard block
 block discarded – undo
101 101
 
102 102
         $article = $articleFilter->getValues();
103 103
         $article += [
104
-            'admin_user_uuid' => $this->adminUsersMapper->getUuid($article['admin_user_id']),
104
+            'admin_user_uuid' => $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]),
105 105
             'type' => ArticleType::EVENT,
106 106
             'article_id' => $id,
107 107
             'article_uuid' => $uuId
108 108
         ];
109
-        unset($article['admin_user_id']);
109
+        unset($article[ 'admin_user_id' ]);
110 110
 
111
-        $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid;
112
-        unset($article['category_id']);
111
+        $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid;
112
+        unset($article[ 'category_id' ]);
113 113
 
114 114
         $event = $eventFilter->getValues() + [
115 115
                 'featured_img' => $this->upload->uploadImage($data, 'featured_img'),
@@ -131,31 +131,31 @@  discard block
 block discarded – undo
131 131
             throw new FilterException($articleFilter->getMessages() + $eventFilter->getMessages());
132 132
         }
133 133
 
134
-        $article = $articleFilter->getValues() + ['article_uuid' => $oldArticle->article_uuid];
134
+        $article = $articleFilter->getValues() + [ 'article_uuid' => $oldArticle->article_uuid ];
135 135
         $event = $eventFilter->getValues() + [
136 136
                 'featured_img' => $this->upload->uploadImage($data, 'featured_img'),
137 137
                 'main_img' => $this->upload->uploadImage($data, 'main_img')
138 138
             ];
139 139
 
140
-        $article['admin_user_uuid'] = $this->adminUsersMapper->getUuid($article['admin_user_id']);
141
-        $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid;
142
-        unset($article['category_id'], $article['admin_user_id']);
140
+        $article[ 'admin_user_uuid' ] = $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]);
141
+        $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid;
142
+        unset($article[ 'category_id' ], $article[ 'admin_user_id' ]);
143 143
 
144 144
         // We don't want to force user to re-upload image on edit
145
-        if (!$event['featured_img']) {
146
-            unset($event['featured_img']);
145
+        if (!$event[ 'featured_img' ]) {
146
+            unset($event[ 'featured_img' ]);
147 147
         } else {
148 148
             $this->upload->deleteFile($oldArticle->featured_img);
149 149
         }
150 150
 
151
-        if (!$event['main_img']) {
152
-            unset($event['main_img']);
151
+        if (!$event[ 'main_img' ]) {
152
+            unset($event[ 'main_img' ]);
153 153
         } else {
154 154
             $this->upload->deleteFile($oldArticle->main_img);
155 155
         }
156 156
 
157
-        $this->articleMapper->update($article, ['article_uuid' => $article['article_uuid']]);
158
-        $this->articleEventsMapper->update($event, ['article_uuid' => $article['article_uuid']]);
157
+        $this->articleMapper->update($article, [ 'article_uuid' => $article[ 'article_uuid' ] ]);
158
+        $this->articleEventsMapper->update($event, [ 'article_uuid' => $article[ 'article_uuid' ] ]);
159 159
     }
160 160
 
161 161
     public function deleteArticle($id)
@@ -168,7 +168,7 @@  discard block
 block discarded – undo
168 168
 
169 169
         $this->upload->deleteFile($event->main_img);
170 170
         $this->upload->deleteFile($event->featured_img);
171
-        $this->articleEventsMapper->delete(['article_uuid' => $event->article_uuid]);
171
+        $this->articleEventsMapper->delete([ 'article_uuid' => $event->article_uuid ]);
172 172
         $this->delete($event->article_uuid);
173 173
     }
174 174
 }
Please login to merge, or discard this patch.
application/packages/Article/src/Service/PostService.php 2 patches
Doc Comments   +3 added lines patch added patch discarded remove patch
@@ -203,6 +203,9 @@
 block discarded – undo
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);
Please login to merge, or discard this patch.
Spacing   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -137,19 +137,19 @@  discard block
 block discarded – undo
137 137
 
138 138
         $article = $articleFilter->getValues();
139 139
         $article += [
140
-            'admin_user_uuid' => $this->adminUsersMapper->getUuid($article['admin_user_id']),
140
+            'admin_user_uuid' => $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]),
141 141
             'type' => ArticleType::POST,
142 142
             'article_id' => $id,
143 143
             'article_uuid' => $uuId
144 144
         ];
145 145
 
146
-        $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid;
147
-        unset($article['category_id'], $article['admin_user_id']);
146
+        $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid;
147
+        unset($article[ 'category_id' ], $article[ 'admin_user_id' ]);
148 148
 
149 149
         $post = $postFilter->getValues() + [
150 150
                 'featured_img' => $this->upload->uploadImage($data, 'featured_img'),
151 151
                 'main_img' => $this->upload->uploadImage($data, 'main_img'),
152
-                'article_uuid' => $article['article_uuid']
152
+                'article_uuid' => $article[ 'article_uuid' ]
153 153
             ];
154 154
 
155 155
         $this->articleMapper->insert($article);
@@ -166,31 +166,31 @@  discard block
 block discarded – undo
166 166
             throw new FilterException($articleFilter->getMessages() + $postFilter->getMessages());
167 167
         }
168 168
 
169
-        $article = $articleFilter->getValues() + ['article_uuid' => $oldArticle->article_uuid];
169
+        $article = $articleFilter->getValues() + [ 'article_uuid' => $oldArticle->article_uuid ];
170 170
         $post = $postFilter->getValues() + [
171 171
                 'featured_img' => $this->upload->uploadImage($data, 'featured_img'),
172 172
                 'main_img' => $this->upload->uploadImage($data, 'main_img')
173 173
             ];
174 174
 
175
-        $article['admin_user_uuid'] = $this->adminUsersMapper->getUuid($article['admin_user_id']);
176
-        $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid;
177
-        unset($article['category_id'], $article['admin_user_id']);
175
+        $article[ 'admin_user_uuid' ] = $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]);
176
+        $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid;
177
+        unset($article[ 'category_id' ], $article[ 'admin_user_id' ]);
178 178
 
179 179
         // We don't want to force user to re-upload image on edit
180
-        if (!$post['featured_img']) {
181
-            unset($post['featured_img']);
180
+        if (!$post[ 'featured_img' ]) {
181
+            unset($post[ 'featured_img' ]);
182 182
         } else {
183 183
             $this->upload->deleteFile($oldArticle->featured_img);
184 184
         }
185 185
 
186
-        if (!$post['main_img']) {
187
-            unset($post['main_img']);
186
+        if (!$post[ 'main_img' ]) {
187
+            unset($post[ 'main_img' ]);
188 188
         } else {
189 189
             $this->upload->deleteFile($oldArticle->main_img);
190 190
         }
191 191
 
192
-        $this->articleMapper->update($article, ['article_uuid' => $article['article_uuid']]);
193
-        $this->articlePostsMapper->update($post, ['article_uuid' => $article['article_uuid']]);
192
+        $this->articleMapper->update($article, [ 'article_uuid' => $article[ 'article_uuid' ] ]);
193
+        $this->articlePostsMapper->update($post, [ 'article_uuid' => $article[ 'article_uuid' ] ]);
194 194
     }
195 195
 
196 196
     public function deleteArticle($id)
@@ -203,7 +203,7 @@  discard block
 block discarded – undo
203 203
 
204 204
         $this->upload->deleteFile($post->main_img);
205 205
         $this->upload->deleteFile($post->featured_img);
206
-        $this->articlePostsMapper->delete(['article_uuid' => $post->article_uuid]);
206
+        $this->articlePostsMapper->delete([ 'article_uuid' => $post->article_uuid ]);
207 207
         $this->delete($post->article_uuid);
208 208
     }
209 209
 
Please login to merge, or discard this patch.
application/packages/Article/src/Service/VideoService.php 2 patches
Doc Comments   +3 added lines patch added patch discarded remove patch
@@ -91,6 +91,9 @@
 block discarded – undo
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);
Please login to merge, or discard this patch.
Spacing   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -127,14 +127,14 @@  discard block
 block discarded – undo
127 127
 
128 128
         $article = $articleFilter->getValues();
129 129
         $article += [
130
-            'admin_user_uuid' => $this->adminUsersMapper->getUuid($article['admin_user_id']),
130
+            'admin_user_uuid' => $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]),
131 131
             'type' => ArticleType::VIDEO,
132 132
             'article_id' => $id,
133 133
             'article_uuid' => $uuId
134 134
         ];
135 135
 
136
-        $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid;
137
-        unset($article['category_id'], $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
         $videos = $videosFilter->getValues() + [
140 140
                 'featured_img' => $this->upload->uploadImage($data, 'featured_img'),
@@ -156,11 +156,11 @@  discard block
 block discarded – undo
156 156
             throw new FilterException($articleFilter->getMessages() + $videosFilter->getMessages());
157 157
         }
158 158
 
159
-        $article = $articleFilter->getValues() + ['article_uuid' => $oldArticle->article_uuid];
160
-        $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid;
161
-        $article['admin_user_uuid'] = $this->adminUsersMapper->getUuid($article['admin_user_id']);
162
-        unset($article['category_id']);
163
-        unset($article['admin_user_id']);
159
+        $article = $articleFilter->getValues() + [ 'article_uuid' => $oldArticle->article_uuid ];
160
+        $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid;
161
+        $article[ 'admin_user_uuid' ] = $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]);
162
+        unset($article[ 'category_id' ]);
163
+        unset($article[ 'admin_user_id' ]);
164 164
 
165 165
         $videos = $videosFilter->getValues() + [
166 166
                 'featured_img' => $this->upload->uploadImage($data, 'featured_img'),
@@ -168,20 +168,20 @@  discard block
 block discarded – undo
168 168
             ];
169 169
 
170 170
         // We don't want to force user to re-upload image on edit
171
-        if (!$videos['featured_img']) {
172
-            unset($videos['featured_img']);
171
+        if (!$videos[ 'featured_img' ]) {
172
+            unset($videos[ 'featured_img' ]);
173 173
         } else {
174 174
             $this->upload->deleteFile($oldArticle->featured_img);
175 175
         }
176 176
 
177
-        if (!$videos['main_img']) {
178
-            unset($videos['main_img']);
177
+        if (!$videos[ 'main_img' ]) {
178
+            unset($videos[ 'main_img' ]);
179 179
         } else {
180 180
             $this->upload->deleteFile($oldArticle->main_img);
181 181
         }
182 182
 
183
-        $this->articleMapper->update($article, ['article_uuid' => $article['article_uuid']]);
184
-        $this->articleVideosMapper->update($videos, ['article_uuid' => $article['article_uuid']]);
183
+        $this->articleMapper->update($article, [ 'article_uuid' => $article[ 'article_uuid' ] ]);
184
+        $this->articleVideosMapper->update($videos, [ 'article_uuid' => $article[ 'article_uuid' ] ]);
185 185
     }
186 186
 
187 187
     public function deleteArticle($id)
@@ -194,7 +194,7 @@  discard block
 block discarded – undo
194 194
 
195 195
         $this->upload->deleteFile($video->main_img);
196 196
         $this->upload->deleteFile($video->featured_img);
197
-        $this->articleVideosMapper->delete(['article_uuid' => $video->article_uuid]);
197
+        $this->articleVideosMapper->delete([ 'article_uuid' => $video->article_uuid ]);
198 198
         $this->delete($video->article_uuid);
199 199
     }
200 200
 }
Please login to merge, or discard this patch.
application/packages/Category/src/Mapper/CategoryMapper.php 2 patches
Doc Comments   +3 added lines patch added patch discarded remove patch
@@ -44,6 +44,9 @@
 block discarded – undo
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()
Please login to merge, or discard this patch.
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch
@@ -33,12 +33,12 @@  discard block
 block discarded – undo
33 33
 
34 34
     public function get($id)
35 35
     {
36
-        return $this->select(['category_id' => $id])->current();
36
+        return $this->select([ 'category_id' => $id ])->current();
37 37
     }
38 38
 
39 39
     public function getPaginationSelect()
40 40
     {
41
-        $select = $this->getSql()->select()->order(['name' => 'asc']);
41
+        $select = $this->getSql()->select()->order([ 'name' => 'asc' ]);
42 42
 
43 43
         return $select;
44 44
     }
@@ -46,17 +46,17 @@  discard block
 block discarded – undo
46 46
     public function getCategoryPostsSelect($categoryId = null, $limit = null)
47 47
     {
48 48
         $select = $this->getSql()->select()
49
-            ->columns(['category_name' => 'name', 'category_slug' => 'slug'])
49
+            ->columns([ 'category_name' => 'name', 'category_slug' => 'slug' ])
50 50
             ->join('articles', 'articles.category_uuid = category.category_uuid',
51
-                ['article_id', 'slug', 'admin_user_uuid', 'published_at']
52
-            )->join('article_posts', 'article_posts.article_uuid = articles.article_uuid', ['*'], 'right')
51
+                [ 'article_id', 'slug', 'admin_user_uuid', 'published_at' ]
52
+            )->join('article_posts', 'article_posts.article_uuid = articles.article_uuid', [ '*' ], 'right')
53 53
             ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid',
54
-                ['admin_user_id', 'first_name', 'last_name', 'face_img']
55
-            )->where(['articles.status' => 1])
56
-            ->order(['published_at' => 'desc']);
54
+                [ 'admin_user_id', 'first_name', 'last_name', 'face_img' ]
55
+            )->where([ 'articles.status' => 1 ])
56
+            ->order([ 'published_at' => 'desc' ]);
57 57
 
58 58
         if ($categoryId) {
59
-            $select->where(['category_id' => $categoryId]);
59
+            $select->where([ 'category_id' => $categoryId ]);
60 60
         }
61 61
 
62 62
         if ($limit) {
@@ -83,14 +83,14 @@  discard block
 block discarded – undo
83 83
         $inHomepage = null,
84 84
         $inCategoryList = null
85 85
     ) {
86
-        $select = $this->getSql()->select()->where(['type' => ArticleType::POST]);
86
+        $select = $this->getSql()->select()->where([ 'type' => ArticleType::POST ]);
87 87
 
88 88
         if ($inHomepage !== null) {
89
-            $select->where(['is_in_homepage' => $inHomepage]);
89
+            $select->where([ 'is_in_homepage' => $inHomepage ]);
90 90
         }
91 91
 
92 92
         if ($inCategoryList !== null) {
93
-            $select->where(['is_in_category_list' => $inCategoryList]);
93
+            $select->where([ 'is_in_category_list' => $inCategoryList ]);
94 94
         }
95 95
 
96 96
         if ($limit) {
Please login to merge, or discard this patch.