@@ -16,21 +16,21 @@ |
||
| 16 | 16 | /** |
| 17 | 17 | * |
| 18 | 18 | * |
| 19 | - * @var Template |
|
| 19 | + * @var Template |
|
| 20 | 20 | */ |
| 21 | 21 | private $template; |
| 22 | 22 | |
| 23 | 23 | /** |
| 24 | 24 | * |
| 25 | 25 | * |
| 26 | - * @var Router |
|
| 26 | + * @var Router |
|
| 27 | 27 | */ |
| 28 | 28 | private $router; |
| 29 | 29 | |
| 30 | 30 | /** |
| 31 | 31 | * |
| 32 | 32 | * |
| 33 | - * @var MenuService |
|
| 33 | + * @var MenuService |
|
| 34 | 34 | */ |
| 35 | 35 | private $menuService; |
| 36 | 36 | |
@@ -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 | } |
@@ -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 | } |
@@ -11,14 +11,14 @@ |
||
| 11 | 11 | /** |
| 12 | 12 | * |
| 13 | 13 | * |
| 14 | - * @var UrlHelper |
|
| 14 | + * @var UrlHelper |
|
| 15 | 15 | */ |
| 16 | 16 | private $url; |
| 17 | 17 | |
| 18 | 18 | /** |
| 19 | 19 | * |
| 20 | 20 | * |
| 21 | - * @var PostService |
|
| 21 | + * @var PostService |
|
| 22 | 22 | */ |
| 23 | 23 | private $postService; |
| 24 | 24 | |
@@ -20,17 +20,17 @@ discard block |
||
| 20 | 20 | |
| 21 | 21 | public function getInputFilter() |
| 22 | 22 | { |
| 23 | - if(!$this->inputFilter) { |
|
| 23 | + if (!$this->inputFilter) { |
|
| 24 | 24 | $inputFilter = new InputFilter(); |
| 25 | 25 | |
| 26 | 26 | $inputFilter->add( |
| 27 | 27 | [ |
| 28 | 28 | 'name' => 'title', |
| 29 | 29 | 'required' => true, |
| 30 | - 'filters' => [['name' => 'StripTags'], ['name' => 'StringTrim']], |
|
| 30 | + 'filters' => [ [ 'name' => 'StripTags' ], [ 'name' => 'StringTrim' ] ], |
|
| 31 | 31 | 'validators' => [ |
| 32 | - ['name' => 'NotEmpty'], |
|
| 33 | - ['name' => 'StringLength', 'options' => ['max' => '255']], |
|
| 32 | + [ 'name' => 'NotEmpty' ], |
|
| 33 | + [ 'name' => 'StringLength', 'options' => [ 'max' => '255' ] ], |
|
| 34 | 34 | ], |
| 35 | 35 | ] |
| 36 | 36 | ); |
@@ -39,7 +39,7 @@ discard block |
||
| 39 | 39 | [ |
| 40 | 40 | 'name' => 'href', |
| 41 | 41 | 'required' => false, |
| 42 | - 'filters' => [['name' => 'StripTags'], ['name' => 'StringTrim']] |
|
| 42 | + 'filters' => [ [ 'name' => 'StripTags' ], [ 'name' => 'StringTrim' ] ] |
|
| 43 | 43 | ] |
| 44 | 44 | ); |
| 45 | 45 | |
@@ -47,9 +47,9 @@ discard block |
||
| 47 | 47 | [ |
| 48 | 48 | 'name' => 'article_id', |
| 49 | 49 | 'required' => false, |
| 50 | - 'filters' => [['name' => 'Null']], |
|
| 50 | + 'filters' => [ [ 'name' => 'Null' ] ], |
|
| 51 | 51 | 'validators' => [ |
| 52 | - ['name' => RecordExists::class, 'options' => ['table' => 'articles', 'field' => 'article_id', 'adapter' => $this->db]] |
|
| 52 | + [ 'name' => RecordExists::class, 'options' => [ 'table' => 'articles', 'field' => 'article_id', 'adapter' => $this->db ] ] |
|
| 53 | 53 | ] |
| 54 | 54 | ] |
| 55 | 55 | ); |
@@ -58,9 +58,9 @@ discard block |
||
| 58 | 58 | [ |
| 59 | 59 | 'name' => 'category_id', |
| 60 | 60 | 'required' => false, |
| 61 | - 'filters' => [['name' => 'Null']], |
|
| 61 | + 'filters' => [ [ 'name' => 'Null' ] ], |
|
| 62 | 62 | 'validators' => [ |
| 63 | - ['name' => RecordExists::class, 'options' => ['table' => 'category', 'field' => 'category_id', 'adapter' => $this->db]] |
|
| 63 | + [ 'name' => RecordExists::class, 'options' => [ 'table' => 'category', 'field' => 'category_id', 'adapter' => $this->db ] ] |
|
| 64 | 64 | ] |
| 65 | 65 | ] |
| 66 | 66 | ); |
@@ -69,7 +69,7 @@ discard block |
||
| 69 | 69 | [ |
| 70 | 70 | 'name' => 'is_active', |
| 71 | 71 | 'required' => false, |
| 72 | - 'filters' => [['name' => 'Boolean']] |
|
| 72 | + 'filters' => [ [ 'name' => 'Boolean' ] ] |
|
| 73 | 73 | ] |
| 74 | 74 | ); |
| 75 | 75 | |
@@ -77,7 +77,7 @@ discard block |
||
| 77 | 77 | [ |
| 78 | 78 | 'name' => 'is_in_header', |
| 79 | 79 | 'required' => false, |
| 80 | - 'filters' => [['name' => 'Boolean']] |
|
| 80 | + 'filters' => [ [ 'name' => 'Boolean' ] ] |
|
| 81 | 81 | ] |
| 82 | 82 | ); |
| 83 | 83 | |
@@ -85,7 +85,7 @@ discard block |
||
| 85 | 85 | [ |
| 86 | 86 | 'name' => 'is_in_footer', |
| 87 | 87 | 'required' => false, |
| 88 | - 'filters' => [['name' => 'Boolean']] |
|
| 88 | + 'filters' => [ [ 'name' => 'Boolean' ] ] |
|
| 89 | 89 | ] |
| 90 | 90 | ); |
| 91 | 91 | |
@@ -93,7 +93,7 @@ discard block |
||
| 93 | 93 | [ |
| 94 | 94 | 'name' => 'is_in_side', |
| 95 | 95 | 'required' => false, |
| 96 | - 'filters' => [['name' => 'Boolean']] |
|
| 96 | + 'filters' => [ [ 'name' => 'Boolean' ] ] |
|
| 97 | 97 | ] |
| 98 | 98 | ); |
| 99 | 99 | |
@@ -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 | |
@@ -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 | } |
@@ -18,35 +18,35 @@ |
||
| 18 | 18 | /** |
| 19 | 19 | * |
| 20 | 20 | * |
| 21 | - * @var Template |
|
| 21 | + * @var Template |
|
| 22 | 22 | */ |
| 23 | 23 | private $template; |
| 24 | 24 | |
| 25 | 25 | /** |
| 26 | 26 | * |
| 27 | 27 | * |
| 28 | - * @var Router |
|
| 28 | + * @var Router |
|
| 29 | 29 | */ |
| 30 | 30 | private $router; |
| 31 | 31 | |
| 32 | 32 | /** |
| 33 | 33 | * |
| 34 | 34 | * |
| 35 | - * @var DiscussionService |
|
| 35 | + * @var DiscussionService |
|
| 36 | 36 | */ |
| 37 | 37 | private $discussionService; |
| 38 | 38 | |
| 39 | 39 | /** |
| 40 | 40 | * |
| 41 | 41 | * |
| 42 | - * @var SessionManager |
|
| 42 | + * @var SessionManager |
|
| 43 | 43 | */ |
| 44 | 44 | private $session; |
| 45 | 45 | |
| 46 | 46 | /** |
| 47 | 47 | * |
| 48 | 48 | * |
| 49 | - * @var CategoryService |
|
| 49 | + * @var CategoryService |
|
| 50 | 50 | */ |
| 51 | 51 | private $categoryService; |
| 52 | 52 | |