@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -declare(strict_types=1); |
|
2 | +declare(strict_types = 1); |
|
3 | 3 | |
4 | 4 | namespace Category\Service; |
5 | 5 | |
@@ -76,7 +76,7 @@ discard block |
||
76 | 76 | */ |
77 | 77 | public function getCategoryBySlug($urlSlug) |
78 | 78 | { |
79 | - return $this->categoryMapper->select(['slug' => $urlSlug])->current(); |
|
79 | + return $this->categoryMapper->select([ 'slug' => $urlSlug ])->current(); |
|
80 | 80 | } |
81 | 81 | |
82 | 82 | /** |
@@ -89,14 +89,14 @@ discard block |
||
89 | 89 | { |
90 | 90 | $filter = $this->categoryFilter->getInputFilter()->setData($data); |
91 | 91 | |
92 | - if(!$filter->isValid()) { |
|
92 | + if (!$filter->isValid()) { |
|
93 | 93 | throw new FilterException($filter->getMessages()); |
94 | 94 | } |
95 | 95 | |
96 | 96 | $values = $filter->getValues(); |
97 | - $values['category_id'] = Uuid::uuid1()->toString(); |
|
98 | - $values['category_uuid'] = (new MysqlUuid($values['category_id']))->toFormat(new Binary); |
|
99 | - $values['main_img'] = $this->upload->uploadImage($data, 'main_img'); |
|
97 | + $values[ 'category_id' ] = Uuid::uuid1()->toString(); |
|
98 | + $values[ 'category_uuid' ] = (new MysqlUuid($values[ 'category_id' ]))->toFormat(new Binary); |
|
99 | + $values[ 'main_img' ] = $this->upload->uploadImage($data, 'main_img'); |
|
100 | 100 | |
101 | 101 | $this->categoryMapper->insert($values); |
102 | 102 | } |
@@ -117,7 +117,7 @@ discard block |
||
117 | 117 | |
118 | 118 | $filter = $this->categoryFilter->getInputFilter()->setData($data); |
119 | 119 | |
120 | - if(!$filter->isValid()) { |
|
120 | + if (!$filter->isValid()) { |
|
121 | 121 | throw new FilterException($filter->getMessages()); |
122 | 122 | } |
123 | 123 | |
@@ -126,14 +126,14 @@ discard block |
||
126 | 126 | ]; |
127 | 127 | |
128 | 128 | // We don't want to force user to re-upload image on edit |
129 | - if(!$values['main_img']) { |
|
130 | - unset($values['main_img']); |
|
129 | + if (!$values[ 'main_img' ]) { |
|
130 | + unset($values[ 'main_img' ]); |
|
131 | 131 | } |
132 | - else{ |
|
132 | + else { |
|
133 | 133 | $this->upload->deleteFile($oldCategory->main_img); |
134 | 134 | } |
135 | 135 | |
136 | - $this->categoryMapper->update($values, ['category_id' => $categoryId]); |
|
136 | + $this->categoryMapper->update($values, [ 'category_id' => $categoryId ]); |
|
137 | 137 | } |
138 | 138 | |
139 | 139 | /** |
@@ -148,7 +148,7 @@ discard block |
||
148 | 148 | |
149 | 149 | $this->upload->deleteFile($category->main_img); |
150 | 150 | |
151 | - return (bool)$this->categoryMapper->delete(['category_id' => $categoryId]); |
|
151 | + return (bool) $this->categoryMapper->delete([ 'category_id' => $categoryId ]); |
|
152 | 152 | } |
153 | 153 | |
154 | 154 | /** |
@@ -172,10 +172,10 @@ discard block |
||
172 | 172 | { |
173 | 173 | $categories = $this->categoryMapper->getWeb(7, null, $inHomepage, $inCategoryList)->toArray(); |
174 | 174 | |
175 | - foreach($categories as $ctn => $category) { |
|
176 | - $select = $this->categoryMapper->getCategoryPostsSelect($category['category_id'], 4); |
|
175 | + foreach ($categories as $ctn => $category) { |
|
176 | + $select = $this->categoryMapper->getCategoryPostsSelect($category[ 'category_id' ], 4); |
|
177 | 177 | $posts = $this->categoryMapper->selectWith($select)->toArray(); |
178 | - $categories[$ctn]['posts'] = $posts; |
|
178 | + $categories[ $ctn ][ 'posts' ] = $posts; |
|
179 | 179 | } |
180 | 180 | |
181 | 181 | return $categories; |
@@ -189,7 +189,7 @@ discard block |
||
189 | 189 | */ |
190 | 190 | public function getCategories($inCategoryList = null) |
191 | 191 | { |
192 | - return $this->categoryMapper->getWeb(null, ['name' => 'asc'], null, $inCategoryList); |
|
192 | + return $this->categoryMapper->getWeb(null, [ 'name' => 'asc' ], null, $inCategoryList); |
|
193 | 193 | } |
194 | 194 | |
195 | 195 | /** |
@@ -128,8 +128,7 @@ |
||
128 | 128 | // We don't want to force user to re-upload image on edit |
129 | 129 | if(!$values['main_img']) { |
130 | 130 | unset($values['main_img']); |
131 | - } |
|
132 | - else{ |
|
131 | + } else{ |
|
133 | 132 | $this->upload->deleteFile($oldCategory->main_img); |
134 | 133 | } |
135 | 134 |
@@ -164,7 +164,7 @@ discard block |
||
164 | 164 | /** |
165 | 165 | * Return categories with posts/articles |
166 | 166 | * |
167 | - * @param null $inHomepage |
|
167 | + * @param boolean $inHomepage |
|
168 | 168 | * @param null $inCategoryList |
169 | 169 | * @return mixed |
170 | 170 | */ |
@@ -184,7 +184,7 @@ discard block |
||
184 | 184 | /** |
185 | 185 | * Return categories posts/articles |
186 | 186 | * |
187 | - * @param null $inCategoryList |
|
187 | + * @param boolean $inCategoryList |
|
188 | 188 | * @return null|\Zend\Db\ResultSet\ResultSetInterface |
189 | 189 | */ |
190 | 190 | public function getCategories($inCategoryList = null) |
@@ -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); |
@@ -53,13 +53,13 @@ discard block |
||
53 | 53 | ); |
54 | 54 | } |
55 | 55 | |
56 | - public function edit($errors = []) |
|
56 | + public function edit($errors = [ ]) |
|
57 | 57 | { |
58 | 58 | $id = $this->request->getAttribute('id'); |
59 | 59 | $item = $this->menuService->get($id); |
60 | 60 | |
61 | - if($this->request->getParsedBody()) { |
|
62 | - $item = (object)($this->request->getParsedBody() + (array)$item); |
|
61 | + if ($this->request->getParsedBody()) { |
|
62 | + $item = (object) ($this->request->getParsedBody() + (array) $item); |
|
63 | 63 | $item->menu_id = $id; |
64 | 64 | } |
65 | 65 | |
@@ -78,36 +78,36 @@ discard block |
||
78 | 78 | |
79 | 79 | public function save() |
80 | 80 | { |
81 | - try{ |
|
81 | + try { |
|
82 | 82 | $id = $this->request->getAttribute('id'); |
83 | 83 | $data = $this->request->getParsedBody(); |
84 | 84 | |
85 | - if($id) { |
|
85 | + if ($id) { |
|
86 | 86 | $this->menuService->updateMenuItem($data, $id); |
87 | 87 | } |
88 | - else{ |
|
88 | + else { |
|
89 | 89 | $this->menuService->addMenuItem($data); |
90 | 90 | } |
91 | 91 | |
92 | 92 | return $this->response->withStatus(302)->withHeader('Location', $this->router->generateUri('admin.menu')); |
93 | 93 | } |
94 | - catch(FilterException $fe){ |
|
94 | + catch (FilterException $fe) { |
|
95 | 95 | return $this->edit($fe->getArrayMessages()); |
96 | 96 | } |
97 | - catch(\Exception $e){ |
|
97 | + catch (\Exception $e) { |
|
98 | 98 | throw $e; |
99 | 99 | } |
100 | 100 | } |
101 | 101 | |
102 | 102 | public function delete() |
103 | 103 | { |
104 | - try{ |
|
104 | + try { |
|
105 | 105 | $id = $this->request->getAttribute('id'); |
106 | 106 | $this->menuService->delete($id); |
107 | 107 | |
108 | 108 | return $this->response->withStatus(302)->withHeader('Location', $this->router->generateUri('admin.menu')); |
109 | 109 | } |
110 | - catch(\Exception $e){ |
|
110 | + catch (\Exception $e) { |
|
111 | 111 | throw $e; |
112 | 112 | } |
113 | 113 | } |
@@ -115,9 +115,9 @@ discard block |
||
115 | 115 | public function updateOrder() |
116 | 116 | { |
117 | 117 | $data = $this->request->getParsedBody(); |
118 | - $menuOrder = isset($data['order']) ? json_decode($data['order']) : []; |
|
118 | + $menuOrder = isset($data[ 'order' ]) ? json_decode($data[ 'order' ]) : [ ]; |
|
119 | 119 | $status = $this->menuService->updateMenuOrder($menuOrder); |
120 | 120 | |
121 | - return new JsonResponse(['status' => $status]); |
|
121 | + return new JsonResponse([ 'status' => $status ]); |
|
122 | 122 | } |
123 | 123 | } |
@@ -84,17 +84,14 @@ discard block |
||
84 | 84 | |
85 | 85 | if($id) { |
86 | 86 | $this->menuService->updateMenuItem($data, $id); |
87 | - } |
|
88 | - else{ |
|
87 | + } else{ |
|
89 | 88 | $this->menuService->addMenuItem($data); |
90 | 89 | } |
91 | 90 | |
92 | 91 | return $this->response->withStatus(302)->withHeader('Location', $this->router->generateUri('admin.menu')); |
93 | - } |
|
94 | - catch(FilterException $fe){ |
|
92 | + } catch(FilterException $fe){ |
|
95 | 93 | return $this->edit($fe->getArrayMessages()); |
96 | - } |
|
97 | - catch(\Exception $e){ |
|
94 | + } catch(\Exception $e){ |
|
98 | 95 | throw $e; |
99 | 96 | } |
100 | 97 | } |
@@ -106,8 +103,7 @@ discard block |
||
106 | 103 | $this->menuService->delete($id); |
107 | 104 | |
108 | 105 | return $this->response->withStatus(302)->withHeader('Location', $this->router->generateUri('admin.menu')); |
109 | - } |
|
110 | - catch(\Exception $e){ |
|
106 | + } catch(\Exception $e){ |
|
111 | 107 | throw $e; |
112 | 108 | } |
113 | 109 | } |
@@ -29,16 +29,16 @@ |
||
29 | 29 | |
30 | 30 | public function getHeaderMenu() |
31 | 31 | { |
32 | - return $this->menuService->getNestedAll(true, ['is_in_header' => true]); |
|
32 | + return $this->menuService->getNestedAll(true, [ 'is_in_header' => true ]); |
|
33 | 33 | } |
34 | 34 | |
35 | 35 | public function getFooterMenu() |
36 | 36 | { |
37 | - return $this->menuService->getNestedAll(true, ['is_in_footer' => true]); |
|
37 | + return $this->menuService->getNestedAll(true, [ 'is_in_footer' => true ]); |
|
38 | 38 | } |
39 | 39 | |
40 | 40 | public function getSideMenu() |
41 | 41 | { |
42 | - return $this->menuService->getNestedAll(true, ['is_in_side' => true]); |
|
42 | + return $this->menuService->getNestedAll(true, [ 'is_in_side' => true ]); |
|
43 | 43 | } |
44 | 44 | } |
@@ -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\Mapper; |
6 | 6 | |
@@ -36,14 +36,14 @@ discard block |
||
36 | 36 | public function getPaginationSelect($status = null) |
37 | 37 | { |
38 | 38 | $select = $this->getSql()->select() |
39 | - ->columns(['title', 'body', 'longitude', 'latitude']) |
|
39 | + ->columns([ 'title', 'body', 'longitude', 'latitude' ]) |
|
40 | 40 | ->join('articles', 'article_events.article_uuid = articles.article_uuid') |
41 | - ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['admin_user_id', 'first_name', 'last_name']) |
|
42 | - ->where(['articles.type' => ArticleType::EVENT]) |
|
43 | - ->order(['created_at' => 'desc']); |
|
41 | + ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'admin_user_id', 'first_name', 'last_name' ]) |
|
42 | + ->where([ 'articles.type' => ArticleType::EVENT ]) |
|
43 | + ->order([ 'created_at' => 'desc' ]); |
|
44 | 44 | |
45 | - if($status) { |
|
46 | - $select->where(['articles.status' => (int)$status]); |
|
45 | + if ($status) { |
|
46 | + $select->where([ 'articles.status' => (int) $status ]); |
|
47 | 47 | } |
48 | 48 | |
49 | 49 | return $select; |
@@ -55,10 +55,10 @@ discard block |
||
55 | 55 | ->join('articles', 'article_events.article_uuid = articles.article_uuid') |
56 | 56 | ->join( |
57 | 57 | 'category', 'category.category_uuid = articles.category_uuid', |
58 | - ['category_slug' => 'slug', 'category_name' => 'name', 'category_id'], 'left' |
|
58 | + [ 'category_slug' => 'slug', 'category_name' => 'name', 'category_id' ], 'left' |
|
59 | 59 | ) |
60 | - ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['admin_user_id'], 'left') |
|
61 | - ->where(['articles.article_id' => $id]); |
|
60 | + ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'admin_user_id' ], 'left') |
|
61 | + ->where([ 'articles.article_id' => $id ]); |
|
62 | 62 | |
63 | 63 | return $this->selectWith($select)->current(); |
64 | 64 | } |
@@ -69,9 +69,9 @@ discard block |
||
69 | 69 | ->join('articles', 'article_events.article_uuid = articles.article_uuid') |
70 | 70 | ->join( |
71 | 71 | 'category', 'category.category_uuid = articles.category_uuid', |
72 | - ['category_slug' => 'slug', 'category_name' => 'name', 'category_id'], 'left' |
|
72 | + [ 'category_slug' => 'slug', 'category_name' => 'name', 'category_id' ], 'left' |
|
73 | 73 | ) |
74 | - ->where(['articles.slug' => $slug]); |
|
74 | + ->where([ 'articles.slug' => $slug ]); |
|
75 | 75 | |
76 | 76 | return $this->selectWith($select)->current(); |
77 | 77 | } |
@@ -79,9 +79,9 @@ discard block |
||
79 | 79 | public function getLatest($limit = 50) |
80 | 80 | { |
81 | 81 | $select = $this->getSql()->select() |
82 | - ->join('articles', 'article_events.article_uuid = articles.article_uuid', ['article_id', 'slug', 'published_at']) |
|
83 | - ->where(['articles.status' => 1]) |
|
84 | - ->order(['published_at' => 'desc']) |
|
82 | + ->join('articles', 'article_events.article_uuid = articles.article_uuid', [ 'article_id', 'slug', 'published_at' ]) |
|
83 | + ->where([ 'articles.status' => 1 ]) |
|
84 | + ->order([ 'published_at' => 'desc' ]) |
|
85 | 85 | ->limit($limit); |
86 | 86 | |
87 | 87 | return $this->selectWith($select); |
@@ -90,8 +90,8 @@ discard block |
||
90 | 90 | public function getFuture() |
91 | 91 | { |
92 | 92 | $select = $this->getSql()->select() |
93 | - ->where(['articles.status' => 1]) |
|
94 | - ->join('articles', 'articles.article_uuid = article_events.article_uuid', ['article_id', 'slug', 'published_at']) |
|
93 | + ->where([ 'articles.status' => 1 ]) |
|
94 | + ->join('articles', 'articles.article_uuid = article_events.article_uuid', [ 'article_id', 'slug', 'published_at' ]) |
|
95 | 95 | ->order(new Expression('rand()')); |
96 | 96 | |
97 | 97 | $select->where->greaterThanOrEqualTo('end_at', date('Y-m-d H:i:s')); |
@@ -102,9 +102,9 @@ discard block |
||
102 | 102 | public function getPastSelect() |
103 | 103 | { |
104 | 104 | $select = $this->getSql()->select() |
105 | - ->where(['articles.status' => 1]) |
|
106 | - ->join('articles', 'articles.article_uuid = article_events.article_uuid', ['article_id', 'slug', 'published_at']) |
|
107 | - ->order(['start_at' => 'desc']); |
|
105 | + ->where([ 'articles.status' => 1 ]) |
|
106 | + ->join('articles', 'articles.article_uuid = article_events.article_uuid', [ 'article_id', 'slug', 'published_at' ]) |
|
107 | + ->order([ 'start_at' => 'desc' ]); |
|
108 | 108 | |
109 | 109 | $select->where->lessThan('end_at', date('Y-m-d H:i:s')); |
110 | 110 |
@@ -33,6 +33,9 @@ |
||
33 | 33 | $this->adapter = $adapter; |
34 | 34 | } |
35 | 35 | |
36 | + /** |
|
37 | + * @param integer $status |
|
38 | + */ |
|
36 | 39 | public function getPaginationSelect($status = null) |
37 | 40 | { |
38 | 41 | $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 Article\Mapper; |
5 | 5 | |
@@ -34,24 +34,24 @@ discard block |
||
34 | 34 | public function getPaginationSelect() |
35 | 35 | { |
36 | 36 | return $this->getSql()->select() |
37 | - ->columns(['title', 'body', 'lead', 'featured_img', 'main_img']) |
|
37 | + ->columns([ 'title', 'body', 'lead', 'featured_img', 'main_img' ]) |
|
38 | 38 | ->join('articles', 'article_posts.article_uuid = articles.article_uuid') |
39 | - ->join('category', 'articles.category_uuid = category.category_uuid', ['category_name' => 'name'], 'left') |
|
40 | - ->where(['articles.type' => ArticleType::POST]) |
|
41 | - ->order(['created_at' => 'desc']); |
|
39 | + ->join('category', 'articles.category_uuid = category.category_uuid', [ 'category_name' => 'name' ], 'left') |
|
40 | + ->where([ 'articles.type' => ArticleType::POST ]) |
|
41 | + ->order([ 'created_at' => 'desc' ]); |
|
42 | 42 | } |
43 | 43 | |
44 | 44 | public function get($id) |
45 | 45 | { |
46 | 46 | $select = $this->getSql()->select() |
47 | - ->columns(['title', 'body', 'lead', 'featured_img', 'main_img', 'has_layout']) |
|
47 | + ->columns([ 'title', 'body', 'lead', 'featured_img', 'main_img', 'has_layout' ]) |
|
48 | 48 | ->join('articles', 'article_posts.article_uuid = articles.article_uuid') |
49 | 49 | ->join( |
50 | 50 | 'category', 'category.category_uuid = articles.category_uuid', |
51 | - ['category_slug' => 'slug', 'category_name' => 'name', 'category_id'], 'left' |
|
51 | + [ 'category_slug' => 'slug', 'category_name' => 'name', 'category_id' ], 'left' |
|
52 | 52 | ) |
53 | - ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['admin_user_id'], 'left') |
|
54 | - ->where(['articles.article_id' => $id]); |
|
53 | + ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'admin_user_id' ], 'left') |
|
54 | + ->where([ 'articles.article_id' => $id ]); |
|
55 | 55 | |
56 | 56 | return $this->selectWith($select)->current(); |
57 | 57 | } |
@@ -60,16 +60,16 @@ discard block |
||
60 | 60 | { |
61 | 61 | $select = $this->getSql()->select() |
62 | 62 | ->join('articles', 'article_posts.article_uuid = articles.article_uuid') |
63 | - ->join('category', 'category.category_uuid = articles.category_uuid', ['category_slug' => 'slug']) |
|
64 | - ->where(['articles.status' => 1]) |
|
63 | + ->join('category', 'category.category_uuid = articles.category_uuid', [ 'category_slug' => 'slug' ]) |
|
64 | + ->where([ 'articles.status' => 1 ]) |
|
65 | 65 | ->limit(1); |
66 | 66 | |
67 | - if($direction > 0) { |
|
67 | + if ($direction > 0) { |
|
68 | 68 | $select->where->greaterThan('published_at', $publishedAt); |
69 | - $select->order(['published_at' => 'asc']); |
|
70 | - } elseif($direction < 0) { |
|
69 | + $select->order([ 'published_at' => 'asc' ]); |
|
70 | + } elseif ($direction < 0) { |
|
71 | 71 | $select->where->lessThan('published_at', $publishedAt); |
72 | - $select->order(['published_at' => 'desc']); |
|
72 | + $select->order([ 'published_at' => 'desc' ]); |
|
73 | 73 | } |
74 | 74 | |
75 | 75 | return $this->selectWith($select)->current(); |
@@ -78,11 +78,11 @@ discard block |
||
78 | 78 | public function getBySlug($slug) |
79 | 79 | { |
80 | 80 | $select = $this->getSql()->select() |
81 | - ->columns(['title', 'body', 'lead', 'featured_img', 'main_img']) |
|
81 | + ->columns([ 'title', 'body', 'lead', 'featured_img', 'main_img' ]) |
|
82 | 82 | ->join('articles', 'article_posts.article_uuid = articles.article_uuid') |
83 | - ->join('category', 'category.category_uuid = articles.category_uuid', ['category_name' => 'name', 'category_slug' => 'slug']) |
|
84 | - ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['first_name', 'last_name']) |
|
85 | - ->where(['articles.slug' => $slug, 'articles.status' => 1]); |
|
83 | + ->join('category', 'category.category_uuid = articles.category_uuid', [ 'category_name' => 'name', 'category_slug' => 'slug' ]) |
|
84 | + ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'first_name', 'last_name' ]) |
|
85 | + ->where([ 'articles.slug' => $slug, 'articles.status' => 1 ]); |
|
86 | 86 | |
87 | 87 | return $this->selectWith($select)->current(); |
88 | 88 | } |
@@ -90,7 +90,7 @@ discard block |
||
90 | 90 | public function getAll() |
91 | 91 | { |
92 | 92 | $select = $this->getSql()->select() |
93 | - ->join('articles', 'article_posts.article_uuid = articles.article_uuid', ['article_id', 'slug']); |
|
93 | + ->join('articles', 'article_posts.article_uuid = articles.article_uuid', [ 'article_id', 'slug' ]); |
|
94 | 94 | |
95 | 95 | return $this->selectWith($select); |
96 | 96 | } |
@@ -99,13 +99,13 @@ discard block |
||
99 | 99 | { |
100 | 100 | $select = $this->getSql()->select() |
101 | 101 | ->join('articles', 'article_posts.article_uuid = articles.article_uuid') |
102 | - ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['first_name', 'last_name']) |
|
102 | + ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'first_name', 'last_name' ]) |
|
103 | 103 | ->join( |
104 | 104 | 'category', 'category.category_uuid = articles.category_uuid', |
105 | - ['category_name' => 'name', 'category_id', 'category_slug' => 'slug'] |
|
105 | + [ 'category_name' => 'name', 'category_id', 'category_slug' => 'slug' ] |
|
106 | 106 | ) |
107 | - ->where(['articles.status' => 1]) |
|
108 | - ->order(['articles.published_at' => 'desc']) |
|
107 | + ->where([ 'articles.status' => 1 ]) |
|
108 | + ->order([ 'articles.published_at' => 'desc' ]) |
|
109 | 109 | ->limit($limit); |
110 | 110 | |
111 | 111 | return $this->selectWith($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 Article\Mapper; |
6 | 6 | |
@@ -24,23 +24,23 @@ discard block |
||
24 | 24 | public function getPaginationSelect() |
25 | 25 | { |
26 | 26 | return $this->getSql()->select() |
27 | - ->columns(['title', 'body']) |
|
27 | + ->columns([ 'title', 'body' ]) |
|
28 | 28 | ->join('articles', 'article_discussions.article_uuid = articles.article_uuid') |
29 | - ->where(['articles.type' => ArticleType::DISCUSSION]) |
|
30 | - ->order(['created_at' => 'desc']); |
|
29 | + ->where([ 'articles.type' => ArticleType::DISCUSSION ]) |
|
30 | + ->order([ 'created_at' => 'desc' ]); |
|
31 | 31 | } |
32 | 32 | |
33 | 33 | public function get($id) |
34 | 34 | { |
35 | 35 | $select = $this->getSql()->select() |
36 | - ->columns(['title', 'body']) |
|
36 | + ->columns([ 'title', 'body' ]) |
|
37 | 37 | ->join('articles', 'article_discussions.article_uuid = articles.article_uuid') |
38 | 38 | ->join( |
39 | 39 | 'category', 'category.category_uuid = articles.category_uuid', |
40 | - ['category_slug' => 'slug', 'category_name' => 'name', 'category_id'], 'left' |
|
40 | + [ 'category_slug' => 'slug', 'category_name' => 'name', 'category_id' ], 'left' |
|
41 | 41 | ) |
42 | - ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['admin_user_id'], 'left') |
|
43 | - ->where(['articles.article_id' => $id]); |
|
42 | + ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'admin_user_id' ], 'left') |
|
43 | + ->where([ 'articles.article_id' => $id ]); |
|
44 | 44 | |
45 | 45 | return $this->selectWith($select)->current(); |
46 | 46 | } |
@@ -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 | |
@@ -34,13 +34,13 @@ discard block |
||
34 | 34 | public function getPaginationSelect($isActive = null) |
35 | 35 | { |
36 | 36 | $select = $this->getSql()->select() |
37 | - ->join('articles', 'article_videos.article_uuid = articles.article_uuid', ['slug', 'published_at', 'status', 'article_id']) |
|
38 | - ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['admin_user_id', 'first_name', 'last_name']) |
|
39 | - ->where(['articles.type' => ArticleType::VIDEO]) |
|
40 | - ->order(['articles.created_at' => 'desc']); |
|
37 | + ->join('articles', 'article_videos.article_uuid = articles.article_uuid', [ 'slug', 'published_at', 'status', 'article_id' ]) |
|
38 | + ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'admin_user_id', 'first_name', 'last_name' ]) |
|
39 | + ->where([ 'articles.type' => ArticleType::VIDEO ]) |
|
40 | + ->order([ 'articles.created_at' => 'desc' ]); |
|
41 | 41 | |
42 | - if($isActive !== null) { |
|
43 | - $select->where(['articles.status' => (int)$isActive]); |
|
42 | + if ($isActive !== null) { |
|
43 | + $select->where([ 'articles.status' => (int) $isActive ]); |
|
44 | 44 | } |
45 | 45 | |
46 | 46 | return $select; |
@@ -49,14 +49,14 @@ discard block |
||
49 | 49 | public function get($id) |
50 | 50 | { |
51 | 51 | $select = $this->getSql()->select() |
52 | - ->columns(['title', 'body', 'lead', 'featured_img', 'main_img', 'video_url', 'sub_title']) |
|
52 | + ->columns([ 'title', 'body', 'lead', 'featured_img', 'main_img', 'video_url', 'sub_title' ]) |
|
53 | 53 | ->join('articles', 'article_videos.article_uuid = articles.article_uuid') |
54 | 54 | ->join( |
55 | 55 | 'category', 'category.category_uuid = articles.category_uuid', |
56 | - ['category_slug' => 'slug', 'category_name' => 'name', 'category_id'], 'left' |
|
56 | + [ 'category_slug' => 'slug', 'category_name' => 'name', 'category_id' ], 'left' |
|
57 | 57 | ) |
58 | - ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['admin_user_id'], 'left') |
|
59 | - ->where(['articles.article_id' => $id]); |
|
58 | + ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'admin_user_id' ], 'left') |
|
59 | + ->where([ 'articles.article_id' => $id ]); |
|
60 | 60 | |
61 | 61 | return $this->selectWith($select)->current(); |
62 | 62 | } |
@@ -64,9 +64,9 @@ discard block |
||
64 | 64 | public function getLatest($limit = 50) |
65 | 65 | { |
66 | 66 | $select = $this->getSql()->select() |
67 | - ->join('articles', 'article_videos.article_uuid = articles.article_uuid', ['article_id', 'slug', 'published_at']) |
|
68 | - ->where(['articles.status' => 1]) |
|
69 | - ->order(['published_at' => 'desc']) |
|
67 | + ->join('articles', 'article_videos.article_uuid = articles.article_uuid', [ 'article_id', 'slug', 'published_at' ]) |
|
68 | + ->where([ 'articles.status' => 1 ]) |
|
69 | + ->order([ 'published_at' => 'desc' ]) |
|
70 | 70 | ->limit($limit); |
71 | 71 | |
72 | 72 | return $this->selectWith($select); |
@@ -76,7 +76,7 @@ discard block |
||
76 | 76 | { |
77 | 77 | $select = $this->getSql()->select() |
78 | 78 | ->join('articles', 'article_videos.article_uuid = articles.article_uuid') |
79 | - ->where(['articles.slug' => $slug]); |
|
79 | + ->where([ 'articles.slug' => $slug ]); |
|
80 | 80 | |
81 | 81 | return $this->selectWith($select)->current(); |
82 | 82 | } |
@@ -68,11 +68,11 @@ discard block |
||
68 | 68 | public function index() : HtmlResponse |
69 | 69 | { |
70 | 70 | $params = $this->request->getQueryParams(); |
71 | - $page = isset($params['page']) ? $params['page'] : 1; |
|
72 | - $limit = isset($params['limit']) ? $params['limit'] : 15; |
|
71 | + $page = isset($params[ 'page' ]) ? $params[ 'page' ] : 1; |
|
72 | + $limit = isset($params[ 'limit' ]) ? $params[ 'limit' ] : 15; |
|
73 | 73 | $posts = $this->postService->fetchAllArticles($page, $limit); |
74 | 74 | |
75 | - return new HtmlResponse($this->template->render('article::post/index', ['list' => $posts, 'layout' => 'layout/admin'])); |
|
75 | + return new HtmlResponse($this->template->render('article::post/index', [ 'list' => $posts, 'layout' => 'layout/admin' ])); |
|
76 | 76 | } |
77 | 77 | |
78 | 78 | /** |
@@ -80,14 +80,14 @@ discard block |
||
80 | 80 | * |
81 | 81 | * @return \Psr\Http\Message\ResponseInterface |
82 | 82 | */ |
83 | - public function edit($errors = []) : \Psr\Http\Message\ResponseInterface |
|
83 | + public function edit($errors = [ ]) : \Psr\Http\Message\ResponseInterface |
|
84 | 84 | { |
85 | 85 | $id = $this->request->getAttribute('id'); |
86 | 86 | $post = $this->postService->fetchSingleArticle($id); |
87 | 87 | $categories = $this->categoryService->getAll(); |
88 | 88 | |
89 | - if($this->request->getParsedBody()) { |
|
90 | - $post = (object)($this->request->getParsedBody() + (array)$post); |
|
89 | + if ($this->request->getParsedBody()) { |
|
90 | + $post = (object) ($this->request->getParsedBody() + (array) $post); |
|
91 | 91 | $post->article_id = $id; |
92 | 92 | } |
93 | 93 | |
@@ -112,23 +112,23 @@ discard block |
||
112 | 112 | */ |
113 | 113 | public function save() : \Psr\Http\Message\ResponseInterface |
114 | 114 | { |
115 | - try{ |
|
115 | + try { |
|
116 | 116 | $id = $this->request->getAttribute('id'); |
117 | 117 | $user = $this->session->getStorage()->user; |
118 | 118 | $data = $this->request->getParsedBody(); |
119 | 119 | $data += (new Request())->getFiles()->toArray(); |
120 | 120 | |
121 | - if($id) { |
|
121 | + if ($id) { |
|
122 | 122 | $this->postService->updateArticle($data, $id); |
123 | 123 | } |
124 | - else{ |
|
124 | + else { |
|
125 | 125 | $this->postService->createArticle($user, $data); |
126 | 126 | } |
127 | 127 | } |
128 | - catch(FilterException $fe){ |
|
128 | + catch (FilterException $fe) { |
|
129 | 129 | return $this->edit($fe->getArrayMessages()); |
130 | 130 | } |
131 | - catch(\Exception $e){ |
|
131 | + catch (\Exception $e) { |
|
132 | 132 | throw $e; |
133 | 133 | } |
134 | 134 | |
@@ -143,15 +143,15 @@ discard block |
||
143 | 143 | */ |
144 | 144 | public function delete() : \Psr\Http\Message\ResponseInterface |
145 | 145 | { |
146 | - try{ |
|
146 | + try { |
|
147 | 147 | $this->postService->deleteArticle($this->request->getAttribute('id')); |
148 | 148 | } |
149 | - catch(\Exception $e){ |
|
149 | + catch (\Exception $e) { |
|
150 | 150 | throw $e; |
151 | 151 | } |
152 | 152 | |
153 | 153 | return $this->response->withStatus(302)->withHeader( |
154 | - 'Location', $this->router->generateUri('admin.posts', ['action' => 'index']) |
|
154 | + 'Location', $this->router->generateUri('admin.posts', [ 'action' => 'index' ]) |
|
155 | 155 | ); |
156 | 156 | } |
157 | 157 | } |
@@ -120,15 +120,12 @@ discard block |
||
120 | 120 | |
121 | 121 | if($id) { |
122 | 122 | $this->postService->updateArticle($data, $id); |
123 | - } |
|
124 | - else{ |
|
123 | + } else{ |
|
125 | 124 | $this->postService->createArticle($user, $data); |
126 | 125 | } |
127 | - } |
|
128 | - catch(FilterException $fe){ |
|
126 | + } catch(FilterException $fe){ |
|
129 | 127 | return $this->edit($fe->getArrayMessages()); |
130 | - } |
|
131 | - catch(\Exception $e){ |
|
128 | + } catch(\Exception $e){ |
|
132 | 129 | throw $e; |
133 | 130 | } |
134 | 131 | |
@@ -145,8 +142,7 @@ discard block |
||
145 | 142 | { |
146 | 143 | try{ |
147 | 144 | $this->postService->deleteArticle($this->request->getAttribute('id')); |
148 | - } |
|
149 | - catch(\Exception $e){ |
|
145 | + } catch(\Exception $e){ |
|
150 | 146 | throw $e; |
151 | 147 | } |
152 | 148 |