Completed
Push — master ( 09092c...17f2b8 )
by
unknown
18:10
created
src/Article/src/Mapper/ArticleEventsMapper.php 1 patch
Spacing   +20 added lines, -20 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
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
 block discarded – undo
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;
@@ -54,9 +54,9 @@  discard block
 block discarded – undo
54 54
         $select = $this->getSql()->select()
55 55
             ->join('articles', 'article_events.article_uuid = articles.article_uuid')
56 56
             ->join('category', 'category.category_uuid = articles.category_uuid',
57
-                ['category_slug' => 'slug', 'category_name' => 'name', 'category_id'], 'left')
58
-            ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['admin_user_id'], 'left')
59
-            ->where(['articles.article_id' => $id]);
57
+                [ 'category_slug' => 'slug', 'category_name' => 'name', 'category_id' ], 'left')
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
     }
@@ -66,8 +66,8 @@  discard block
 block discarded – undo
66 66
         $select = $this->getSql()->select()
67 67
             ->join('articles', 'article_events.article_uuid = articles.article_uuid')
68 68
             ->join('category', 'category.category_uuid = articles.category_uuid',
69
-                ['category_slug' => 'slug', 'category_name' => 'name', 'category_id'], 'left')
70
-            ->where(['articles.slug' => $slug]);
69
+                [ 'category_slug' => 'slug', 'category_name' => 'name', 'category_id' ], 'left')
70
+            ->where([ 'articles.slug' => $slug ]);
71 71
 
72 72
         return $this->selectWith($select)->current();
73 73
     }
@@ -75,9 +75,9 @@  discard block
 block discarded – undo
75 75
     public function getLatest($limit = 50)
76 76
     {
77 77
         $select = $this->getSql()->select()
78
-            ->join('articles', 'article_events.article_uuid = articles.article_uuid', ['article_id', 'slug', 'published_at'])
79
-            ->where(['articles.status' => 1])
80
-            ->order(['published_at' => 'desc'])
78
+            ->join('articles', 'article_events.article_uuid = articles.article_uuid', [ 'article_id', 'slug', 'published_at' ])
79
+            ->where([ 'articles.status' => 1 ])
80
+            ->order([ 'published_at' => 'desc' ])
81 81
             ->limit($limit);
82 82
 
83 83
         return $this->selectWith($select);
@@ -86,8 +86,8 @@  discard block
 block discarded – undo
86 86
     public function getFuture()
87 87
     {
88 88
         $select = $this->getSql()->select()
89
-            ->where(['articles.status' => 1])
90
-            ->join('articles', 'articles.article_uuid = article_events.article_uuid', ['article_id', 'slug', 'published_at'])
89
+            ->where([ 'articles.status' => 1 ])
90
+            ->join('articles', 'articles.article_uuid = article_events.article_uuid', [ 'article_id', 'slug', 'published_at' ])
91 91
             ->order(new Expression('rand()'));
92 92
 
93 93
         $select->where->greaterThanOrEqualTo('end_at', date('Y-m-d H:i:s'));
@@ -98,9 +98,9 @@  discard block
 block discarded – undo
98 98
     public function getPastSelect()
99 99
     {
100 100
         $select = $this->getSql()->select()
101
-            ->where(['articles.status' => 1])
102
-            ->join('articles', 'articles.article_uuid = article_events.article_uuid', ['article_id', 'slug', 'published_at'])
103
-            ->order(['start_at' => 'desc']);
101
+            ->where([ 'articles.status' => 1 ])
102
+            ->join('articles', 'articles.article_uuid = article_events.article_uuid', [ 'article_id', 'slug', 'published_at' ])
103
+            ->order([ 'start_at' => 'desc' ]);
104 104
 
105 105
         $select->where->lessThan('end_at', date('Y-m-d H:i:s'));
106 106
 
Please login to merge, or discard this patch.