View GitHub Repository unfinished

Schedule Inspection
Subscribe
Completed
Push — master ( 072543...66893c )
by Aleksandar
69:44 queued 49:14
created
Status
Category
Toggle Patches
src/Article/src/Mapper/ArticleEventsMapper.php 1 patch
Spacing   +19 added lines, -19 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,8 +54,8 @@  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 
-            ->where(['articles.article_id' => $id]);
57 
+                [ 'category_slug' => 'slug', 'category_name' => 'name', 'category_id' ], 'left')
58 
+            ->where([ 'articles.article_id' => $id ]);
59 59
60 60 
         return $this->selectWith($select)->current();
61 61 
     }
 
@@ -64,8 +64,8 @@  discard block
 
 block discarded – undo
64 64 
     {
65 65 
         $select = $this->getSql()->select()
66 66 
             ->join('articles', 'article_events.article_uuid = articles.article_uuid')
67 
-            ->join('category', 'category.category_uuid = articles.category_uuid', ['*'], 'left')
68 
-            ->where(['articles.slug' => $slug]);
67 
+            ->join('category', 'category.category_uuid = articles.category_uuid', [ '*' ], 'left')
68 
+            ->where([ 'articles.slug' => $slug ]);
69 69
70 70 
         return $this->selectWith($select)->current();
71 71 
     }
 
@@ -73,9 +73,9 @@  discard block
 
 block discarded – undo
73 73 
     public function getLatest($limit = 50)
74 74 
     {
75 75 
         $select = $this->getSql()->select()
76 
-            ->join('articles', 'article_events.article_uuid = articles.article_uuid', ['article_id', 'slug', 'published_at'])
77 
-            ->where(['articles.status' => 1])
78 
-            ->order(['published_at' => 'desc'])
76 
+            ->join('articles', 'article_events.article_uuid = articles.article_uuid', [ 'article_id', 'slug', 'published_at' ])
77 
+            ->where([ 'articles.status' => 1 ])
78 
+            ->order([ 'published_at' => 'desc' ])
79 79 
             ->limit($limit);
80 80
81 81 
         return $this->selectWith($select);
 
@@ -84,8 +84,8 @@  discard block
 
 block discarded – undo
84 84 
     public function getFuture()
85 85 
     {
86 86 
         $select = $this->getSql()->select()
87 
-            ->where(['articles.status' => 1])
88 
-            ->join('articles', 'articles.article_uuid = article_events.article_uuid', ['article_id', 'slug', 'published_at'])
87 
+            ->where([ 'articles.status' => 1 ])
88 
+            ->join('articles', 'articles.article_uuid = article_events.article_uuid', [ 'article_id', 'slug', 'published_at' ])
89 89 
             ->order(new Expression('rand()'));
90 90
91 91 
         $select->where->greaterThanOrEqualTo('end_at', date('Y-m-d H:i:s'));
 
@@ -96,9 +96,9 @@  discard block
 
 block discarded – undo
96 96 
     public function getPastSelect()
97 97 
     {
98 98 
         $select = $this->getSql()->select()
99 
-            ->where(['articles.status' => 1])
100 
-            ->join('articles', 'articles.article_uuid = article_events.article_uuid', ['article_id', 'slug', 'published_at'])
101 
-            ->order(['start_at' => 'desc']);
99 
+            ->where([ 'articles.status' => 1 ])
100 
+            ->join('articles', 'articles.article_uuid = article_events.article_uuid', [ 'article_id', 'slug', 'published_at' ])
101 
+            ->order([ 'start_at' => 'desc' ]);
102 102
103 103 
         $select->where->lessThan('end_at', date('Y-m-d H:i:s'));
104 104
Please login to merge, or discard this patch.
src/Article/src/Mapper/ArticleVideosMapper.php 1 patch
Spacing   +14 added lines, -14 removed lines patch added patch discarded remove patch 
@@ -1,5 +1,5 @@  discard block
 
 block discarded – undo
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
 
 block discarded – undo
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::POST])
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::POST ])
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,11 +49,11 @@  discard block
 
 block discarded – undo
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('category', 'category.category_uuid = articles.category_uuid',
55 
-                ['category_slug' => 'slug', 'category_name' => 'name', 'category_id'], 'left')
56 
-            ->where(['articles.article_id' => $id]);
55 
+                [ 'category_slug' => 'slug', 'category_name' => 'name', 'category_id' ], 'left')
56 
+            ->where([ 'articles.article_id' => $id ]);
57 57
58 58 
         return $this->selectWith($select)->current();
59 59 
     }
 
@@ -61,9 +61,9 @@  discard block
 
 block discarded – undo
61 61 
     public function getLatest($limit = 50)
62 62 
     {
63 63 
         $select = $this->getSql()->select()
64 
-            ->join('articles', 'article_videos.article_uuid = articles.article_uuid', ['article_id', 'slug', 'published_at'])
65 
-            ->where(['articles.status' => 1])
66 
-            ->order(['published_at' => 'desc'])
64 
+            ->join('articles', 'article_videos.article_uuid = articles.article_uuid', [ 'article_id', 'slug', 'published_at' ])
65 
+            ->where([ 'articles.status' => 1 ])
66 
+            ->order([ 'published_at' => 'desc' ])
67 67 
             ->limit($limit);
68 68
69 69 
         return $this->selectWith($select);
 
@@ -73,7 +73,7 @@  discard block
 
 block discarded – undo
73 73 
     {
74 74 
         $select = $this->getSql()->select()
75 75 
             ->join('articles', 'article_videos.article_uuid = articles.article_uuid')
76 
-            ->where(['articles.slug' => $slug]);
76 
+            ->where([ 'articles.slug' => $slug ]);
77 77
78 78 
         return $this->selectWith($select)->current();
79 79 
     }
Please login to merge, or discard this patch.
data/phinx/migrations/20161229132350_article_events.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch 
@@ -10,20 +10,20 @@  discard block
 
 block discarded – undo
10 10 
 {
11 11 
     public function up()
12 12 
     {
13 
-        $this->table('article_events', ['id' => false])
14 
-            ->addColumn('article_uuid', 'binary', ['limit' => 16])
13 
+        $this->table('article_events', [ 'id' => false ])
14 
+            ->addColumn('article_uuid', 'binary', [ 'limit' => 16 ])
15 15 
             ->addColumn('title', 'text')
16 
-            ->addColumn('sub_title', 'text', ['null' => true])
16 
+            ->addColumn('sub_title', 'text', [ 'null' => true ])
17 17 
             ->addColumn('place_name', 'text')
18 18 
             ->addColumn('body', 'text')
19 19 
             ->addColumn('longitude', 'text')
20 20 
             ->addColumn('latitude', 'text')
21 
-            ->addColumn('featured_img', 'text', ['null' => true])
22 
-            ->addColumn('main_img', 'text', ['null' => true])
21 
+            ->addColumn('featured_img', 'text', [ 'null' => true ])
22 
+            ->addColumn('main_img', 'text', [ 'null' => true ])
23 23 
             ->addColumn('start_at', 'datetime')
24 24 
             ->addColumn('end_at', 'datetime')
25 
-            ->addColumn('event_url', 'text', ['null' => true])
26 
-            ->addForeignKey('article_uuid', 'articles', 'article_uuid', ['delete' => 'NO_ACTION', 'update' => 'NO_ACTION'])
25 
+            ->addColumn('event_url', 'text', [ 'null' => true ])
26 
+            ->addForeignKey('article_uuid', 'articles', 'article_uuid', [ 'delete' => 'NO_ACTION', 'update' => 'NO_ACTION' ])
27 27 
             ->create();
28 28
29 29 
 //        $this->insertDummyData();
 
@@ -36,10 +36,10 @@  discard block
 
 block discarded – undo
36 36
37 37 
     private function insertDummyData()
38 38 
     {
39 
-        $ids  = [];
39 
+        $ids  = [ ];
40 40 
         $rows = $this->fetchAll('select admin_user_uuid from admin_users;');
41 
-        foreach($rows as $r){
42 
-            $ids[] = $r['admin_user_uuid'];
41 
+        foreach ($rows as $r) {
42 
+            $ids[ ] = $r[ 'admin_user_uuid' ];
43 43 
         }
44 44
45 45 
         $faker  = Faker\Factory::create();
 
@@ -47,19 +47,19 @@  discard block
 
 block discarded – undo
47 47 
         $count  = rand(25, 300);
48 48
49 49 
         // Download N images and set it randomly to the events
50 
-        for($i = 0; $i < 5; $i++){
50 
+        for ($i = 0; $i < 5; $i++) {
51 51 
             $image       = $faker->image();
52 52 
             $destination = $upload->getPath(basename($image));
53 53 
             rename($image, $destination);
54 
-            $mainImg[] = substr($destination, strlen('/var/www/unfinished/public'));
54 
+            $mainImg[ ] = substr($destination, strlen('/var/www/unfinished/public'));
55 55
56 56 
             $image       = $faker->image();
57 57 
             $destination = $upload->getPath(basename($image));
58 58 
             rename($image, $destination);
59 
-            $featuredImg[] = substr($destination, strlen('/var/www/unfinished/public'));
59 
+            $featuredImg[ ] = substr($destination, strlen('/var/www/unfinished/public'));
60 60 
         }
61 61
62 
-        for($i = 0; $i < $count; $i++){
62 
+        for ($i = 0; $i < $count; $i++) {
63 63 
             $start     = rand(1, 20);
64 64 
             $id        = $faker->uuid;
65 65 
             $mysqluuid = (new Uuid($id))->toFormat(new Binary());
 
@@ -70,7 +70,7 @@  discard block
 
 block discarded – undo
70 70 
                 'article_id'      => $id,
71 71 
                 'slug'            => strtolower(trim(preg_replace('~[^\pL\d]+~u', '-', $title), '-')),
72 72 
                 'status'          => 1,
73 
-                'admin_user_uuid' => $ids[array_rand($ids)],
73 
+                'admin_user_uuid' => $ids[ array_rand($ids) ],
74 74 
                 'type'            => ArticleType::EVENT
75 75 
             ];
76 76 
 
@@ -81,8 +81,8 @@  discard block
 
 block discarded – undo
81 81 
                 'longitude'    => $faker->longitude,
82 82 
                 'latitude'     => $faker->latitude,
83 83 
                 'place_name'   => $faker->sentence(1),
84 
-                'main_img'     => $mainImg[array_rand($mainImg)],
85 
-                'featured_img' => $featuredImg[array_rand($featuredImg)],
84 
+                'main_img'     => $mainImg[ array_rand($mainImg) ],
85 
+                'featured_img' => $featuredImg[ array_rand($featuredImg) ],
86 86 
                 'start_at'     => date("Y-m-d H:i:s", strtotime("+$start  day +$start hours")),
87 87 
                 'end_at'       => date("Y-m-d H:i:s", strtotime("+$start  day +" . ($start + rand(1, 5)) . " hours"))
88 88 
             ];
Please login to merge, or discard this patch.
data/phinx/migrations/20160908142829_admin_users.php 1 patch
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch 
@@ -8,20 +8,20 @@
 
 block discarded – undo
8 8 
 {
9 9 
     public function up()
10 10 
     {
11 
-        $this->table('admin_users', ['id' => false, 'primary_key' => 'admin_user_uuid'])
12 
-            ->addColumn('admin_user_uuid', 'binary', ['limit' => 16])
11 
+        $this->table('admin_users', [ 'id' => false, 'primary_key' => 'admin_user_uuid' ])
12 
+            ->addColumn('admin_user_uuid', 'binary', [ 'limit' => 16 ])
13 13 
             ->addColumn('admin_user_id', 'text')
14 14 
             ->addColumn('first_name', 'text')
15 15 
             ->addColumn('last_name', 'text')
16 
-            ->addColumn('introduction', 'text', ['null' => true])
17 
-            ->addColumn('email', 'string', ['limit' => 128])
18 
-            ->addColumn('password', 'char', ['limit' => 60])
19 
-            ->addColumn('status', 'integer', ['default' => 0])// 0 => not active, 1 = active
20 
-            ->addColumn('face_img', 'text', ['null' => true])
21 
-            ->addColumn('profile_img', 'text', ['null' => true])
22 
-            ->addColumn('created_at', 'datetime', ['default' => 'CURRENT_TIMESTAMP'])
23 
-            ->addColumn('last_login', 'datetime', ['null' => true])
24 
-            ->addIndex(['email'], ['name' => 'email_INDEX'])
16 
+            ->addColumn('introduction', 'text', [ 'null' => true ])
17 
+            ->addColumn('email', 'string', [ 'limit' => 128 ])
18 
+            ->addColumn('password', 'char', [ 'limit' => 60 ])
19 
+            ->addColumn('status', 'integer', [ 'default' => 0 ])// 0 => not active, 1 = active
20 
+            ->addColumn('face_img', 'text', [ 'null' => true ])
21 
+            ->addColumn('profile_img', 'text', [ 'null' => true ])
22 
+            ->addColumn('created_at', 'datetime', [ 'default' => 'CURRENT_TIMESTAMP' ])
23 
+            ->addColumn('last_login', 'datetime', [ 'null' => true ])
24 
+            ->addIndex([ 'email' ], [ 'name' => 'email_INDEX' ])
25 25 
             ->create();
26 26
27 27 
         $faker = Faker\Factory::create();
Please login to merge, or discard this patch.
data/phinx/migrations/20161003183353_articles.php 1 patch
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch 
@@ -6,21 +6,21 @@
 
 block discarded – undo
6 6 
 {
7 7 
     public function up()
8 8 
     {
9 
-        $this->table('articles', ['id' => false, 'primary_key' => 'article_uuid'])
10 
-            ->addColumn('article_uuid', 'binary', ['limit' => 16])
9 
+        $this->table('articles', [ 'id' => false, 'primary_key' => 'article_uuid' ])
10 
+            ->addColumn('article_uuid', 'binary', [ 'limit' => 16 ])
11 11 
             ->addColumn('article_id', 'text')
12 
-            ->addColumn('slug', 'text', ['null' => true])
13 
-            ->addColumn('created_at', 'datetime', ['default' => 'CURRENT_TIMESTAMP'])
14 
-            ->addColumn('published_at', 'datetime', ['default' => 'CURRENT_TIMESTAMP'])
12 
+            ->addColumn('slug', 'text', [ 'null' => true ])
13 
+            ->addColumn('created_at', 'datetime', [ 'default' => 'CURRENT_TIMESTAMP' ])
14 
+            ->addColumn('published_at', 'datetime', [ 'default' => 'CURRENT_TIMESTAMP' ])
15 15 
             ->addColumn('type', 'integer')// see Core\Entity\ArticleType
16 16 
             ->addColumn('status', 'integer')// active, not active, ...
17 
-            ->addColumn('admin_user_uuid', 'binary', ['limit' => 16])
18 
-            ->addColumn('is_wysiwyg_editor', 'boolean', ['default' => false])
19 
-            ->addColumn('category_uuid', 'binary', ['limit' => 16])
20 
-            ->addForeignKey('category_uuid', 'category', 'category_uuid', ['delete' => 'NO_ACTION', 'update' => 'NO_ACTION'])
21 
-            ->addForeignKey('admin_user_uuid', 'admin_users', 'admin_user_uuid', ['delete' => 'NO_ACTION', 'update' => 'NO_ACTION'])
22 
-            ->addIndex('type', ['name' => 'type_INDEX'])
23 
-            ->addIndex('published_at', ['name' => 'published_at_INDEX'])
17 
+            ->addColumn('admin_user_uuid', 'binary', [ 'limit' => 16 ])
18 
+            ->addColumn('is_wysiwyg_editor', 'boolean', [ 'default' => false ])
19 
+            ->addColumn('category_uuid', 'binary', [ 'limit' => 16 ])
20 
+            ->addForeignKey('category_uuid', 'category', 'category_uuid', [ 'delete' => 'NO_ACTION', 'update' => 'NO_ACTION' ])
21 
+            ->addForeignKey('admin_user_uuid', 'admin_users', 'admin_user_uuid', [ 'delete' => 'NO_ACTION', 'update' => 'NO_ACTION' ])
22 
+            ->addIndex('type', [ 'name' => 'type_INDEX' ])
23 
+            ->addIndex('published_at', [ 'name' => 'published_at_INDEX' ])
24 24 
             ->create();
25 25 
     }
26 26
Please login to merge, or discard this patch.
data/phinx/migrations/20161229132328_article_posts.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch 
@@ -10,16 +10,16 @@  discard block
 
 block discarded – undo
10 10 
 {
11 11 
     public function up()
12 12 
     {
13 
-        $this->table('article_posts', ['id' => false])
14 
-            ->addColumn('article_uuid', 'binary', ['limit' => 16])
13 
+        $this->table('article_posts', [ 'id' => false ])
14 
+            ->addColumn('article_uuid', 'binary', [ 'limit' => 16 ])
15 15 
             ->addColumn('title', 'text')
16 16 
             ->addColumn('body', 'text')
17 17 
             ->addColumn('lead', 'text')
18 
-            ->addColumn('featured_img', 'text', ['null' => true])
19 
-            ->addColumn('main_img', 'text', ['null' => true])
20 
-            ->addColumn('has_layout', 'boolean', ['default' => true])
21 
-            ->addColumn('is_homepage', 'boolean', ['default' => false])
22 
-            ->addForeignKey('article_uuid', 'articles', 'article_uuid', ['delete' => 'NO_ACTION', 'update' => 'NO_ACTION'])
18 
+            ->addColumn('featured_img', 'text', [ 'null' => true ])
19 
+            ->addColumn('main_img', 'text', [ 'null' => true ])
20 
+            ->addColumn('has_layout', 'boolean', [ 'default' => true ])
21 
+            ->addColumn('is_homepage', 'boolean', [ 'default' => false ])
22 
+            ->addForeignKey('article_uuid', 'articles', 'article_uuid', [ 'delete' => 'NO_ACTION', 'update' => 'NO_ACTION' ])
23 23 
             ->create();
24 24
25 25 
 //        $this->insertDummyData();
 
@@ -32,10 +32,10 @@  discard block
 
 block discarded – undo
32 32
33 33 
     private function insertDummyData()
34 34 
     {
35 
-        $ids  = [];
35 
+        $ids  = [ ];
36 36 
         $rows = $this->fetchAll('select admin_user_uuid from admin_users;');
37 
-        foreach($rows as $r) {
38 
-            $ids[] = $r['admin_user_uuid'];
37 
+        foreach ($rows as $r) {
38 
+            $ids[ ] = $r[ 'admin_user_uuid' ];
39 39 
         }
40 40
41 41 
         $faker  = Faker\Factory::create();
 
@@ -43,19 +43,19 @@  discard block
 
 block discarded – undo
43 43 
         $count  = rand(25, 300);
44 44
45 45 
         // Download N images and set it randomly to posts
46 
-        for($i = 0; $i < 5; $i++) {
46 
+        for ($i = 0; $i < 5; $i++) {
47 47 
             $image       = $faker->image();
48 48 
             $destination = $upload->getPath(basename($image));
49 49 
             rename($image, $destination);
50 
-            $mainImg[] = substr($destination, strlen('/var/www/unfinished/public'));
50 
+            $mainImg[ ] = substr($destination, strlen('/var/www/unfinished/public'));
51 51
52 52 
             $image       = $faker->image();
53 53 
             $destination = $upload->getPath(basename($image));
54 54 
             rename($image, $destination);
55 
-            $featuredImg[] = substr($destination, strlen('/var/www/unfinished/public'));
55 
+            $featuredImg[ ] = substr($destination, strlen('/var/www/unfinished/public'));
56 56 
         }
57 57
58 
-        for($i = 0; $i < $count; $i++) {
58 
+        for ($i = 0; $i < $count; $i++) {
59 59 
             $id        = $faker->uuid;
60 60 
             $mysqluuid = (new Uuid($id))->toFormat(new Binary());
61 61 
             $title     = $faker->sentence(7, 20);
 
@@ -65,7 +65,7 @@  discard block
 
 block discarded – undo
65 65 
                 'article_id'      => $id,
66 66 
                 'slug'            => strtolower(trim(preg_replace('~[^\pL\d]+~u', '-', $title), '-')),
67 67 
                 'status'          => 1,
68 
-                'admin_user_uuid' => $ids[array_rand($ids)],
68 
+                'admin_user_uuid' => $ids[ array_rand($ids) ],
69 69 
                 'type'            => ArticleType::POST
70 70 
             ];
71 71 
 
@@ -74,8 +74,8 @@  discard block
 
 block discarded – undo
74 74 
                 'title'        => $title,
75 75 
                 'body'         => $faker->paragraph(15),
76 76 
                 'lead'         => $faker->paragraph(5),
77 
-                'main_img'     => $mainImg[array_rand($mainImg)],
78 
-                'featured_img' => $featuredImg[array_rand($featuredImg)]
77 
+                'main_img'     => $mainImg[ array_rand($mainImg) ],
78 
+                'featured_img' => $featuredImg[ array_rand($featuredImg) ]
79 79 
             ];
80 80
81 81 
             $this->insert('articles', $article);
Please login to merge, or discard this patch.
data/phinx/migrations/20161229132336_article_videos.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch 
@@ -10,16 +10,16 @@  discard block
 
 block discarded – undo
10 10 
 {
11 11 
     public function up()
12 12 
     {
13 
-        $this->table('article_videos', ['id' => false])
14 
-            ->addColumn('article_uuid', 'binary', ['limit' => 16])
13 
+        $this->table('article_videos', [ 'id' => false ])
14 
+            ->addColumn('article_uuid', 'binary', [ 'limit' => 16 ])
15 15 
             ->addColumn('title', 'text')
16 
-            ->addColumn('sub_title', 'text', ['null' => true])
16 
+            ->addColumn('sub_title', 'text', [ 'null' => true ])
17 17 
             ->addColumn('body', 'text')
18 18 
             ->addColumn('lead', 'text')
19 19 
             ->addColumn('video_url', 'text')
20 
-            ->addColumn('featured_img', 'text', ['null' => true])
21 
-            ->addColumn('main_img', 'text', ['null' => true])
22 
-            ->addForeignKey('article_uuid', 'articles', 'article_uuid', ['delete' => 'NO_ACTION', 'update' => 'NO_ACTION'])
20 
+            ->addColumn('featured_img', 'text', [ 'null' => true ])
21 
+            ->addColumn('main_img', 'text', [ 'null' => true ])
22 
+            ->addForeignKey('article_uuid', 'articles', 'article_uuid', [ 'delete' => 'NO_ACTION', 'update' => 'NO_ACTION' ])
23 23 
             ->create();
24 24
25 25 
 //        $this->insertDummyData();
 
@@ -32,10 +32,10 @@  discard block
 
 block discarded – undo
32 32
33 33 
     private function insertDummyData()
34 34 
     {
35 
-        $ids  = [];
35 
+        $ids  = [ ];
36 36 
         $rows = $this->fetchAll('select admin_user_uuid from admin_users;');
37 
-        foreach($rows as $r) {
38 
-            $ids[] = $r['admin_user_uuid'];
37 
+        foreach ($rows as $r) {
38 
+            $ids[ ] = $r[ 'admin_user_uuid' ];
39 39 
         }
40 40
41 41 
         $faker      = Faker\Factory::create();
 
@@ -48,19 +48,19 @@  discard block
 
 block discarded – undo
48 48 
         ];
49 49
50 50 
         // Download N images and set it randomly to posts
51 
-        for($i = 0; $i < 5; $i++) {
51 
+        for ($i = 0; $i < 5; $i++) {
52 52 
             $image       = $faker->image();
53 53 
             $destination = $upload->getPath(basename($image));
54 54 
             rename($image, $destination);
55 
-            $mainImg[] = substr($destination, strlen('/var/www/unfinished/public'));
55 
+            $mainImg[ ] = substr($destination, strlen('/var/www/unfinished/public'));
56 56
57 57 
             $image       = $faker->image();
58 58 
             $destination = $upload->getPath(basename($image));
59 59 
             rename($image, $destination);
60 
-            $featuredImg[] = substr($destination, strlen('/var/www/unfinished/public'));
60 
+            $featuredImg[ ] = substr($destination, strlen('/var/www/unfinished/public'));
61 61 
         }
62 62
63 
-        for($i = 0; $i < $count; $i++) {
63 
+        for ($i = 0; $i < $count; $i++) {
64 64 
             $id        = $faker->uuid;
65 65 
             $mysqluuid = (new Uuid($id))->toFormat(new Binary());
66 66 
             $title     = $faker->sentence(7, 20);
 
@@ -70,7 +70,7 @@  discard block
 
 block discarded – undo
70 70 
                 'article_id'      => $id,
71 71 
                 'slug'            => strtolower(trim(preg_replace('~[^\pL\d]+~u', '-', $title), '-')),
72 72 
                 'status'          => 1,
73 
-                'admin_user_uuid' => $ids[array_rand($ids)],
73 
+                'admin_user_uuid' => $ids[ array_rand($ids) ],
74 74 
                 'type'            => ArticleType::POST
75 75 
             ];
76 76 
 
@@ -79,9 +79,9 @@  discard block
 
 block discarded – undo
79 79 
                 'title'        => $title,
80 80 
                 'body'         => $faker->paragraph(15),
81 81 
                 'lead'         => $faker->paragraph(5),
82 
-                'main_img'     => $mainImg[array_rand($mainImg)],
83 
-                'featured_img' => $featuredImg[array_rand($featuredImg)],
84 
-                'video_url'    => $embedCodes[rand(0, 2)]
82 
+                'main_img'     => $mainImg[ array_rand($mainImg) ],
83 
+                'featured_img' => $featuredImg[ array_rand($featuredImg) ],
84 
+                'video_url'    => $embedCodes[ rand(0, 2) ]
85 85 
             ];
86 86
87 87 
             $this->insert('articles', $article);
Please login to merge, or discard this patch.
src/Article/src/Mapper/ArticlePostsMapper.php 1 patch
Spacing   +23 added lines, -23 removed lines patch added patch discarded remove patch 
@@ -1,5 +1,5 @@  discard block
 
 block discarded – undo
1 1 
 <?php
2 
-declare(strict_types=1);
2 
+declare(strict_types = 1);
3 3
4 4 
 namespace Article\Mapper;
5 5 
 
@@ -34,21 +34,21 @@  discard block
 
 block discarded – undo
34 34 
     public function getPaginationSelect()
35 35 
     {
36 36 
         return $this->getSql()->select()
37 
-            ->columns(['title', 'body', 'lead', 'featured_img', 'main_img', 'is_homepage'])
37 
+            ->columns([ 'title', 'body', 'lead', 'featured_img', 'main_img', 'is_homepage' ])
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', 'is_homepage'])
47 
+            ->columns([ 'title', 'body', 'lead', 'featured_img', 'main_img', 'has_layout', 'is_homepage' ])
48 48 
             ->join('articles', 'article_posts.article_uuid = articles.article_uuid')
49 49 
             ->join('category', 'category.category_uuid = articles.category_uuid',
50 
-                ['category_slug' => 'slug', 'category_name' => 'name', 'category_id'], 'left')
51 
-            ->where(['articles.article_id' => $id]);
50 
+                [ 'category_slug' => 'slug', 'category_name' => 'name', 'category_id' ], 'left')
51 
+            ->where([ 'articles.article_id' => $id ]);
52 52
53 53 
         return $this->selectWith($select)->current();
54 54 
     }
 
@@ -57,15 +57,15 @@  discard block
 
 block discarded – undo
57 57 
     {
58 58 
         $select = $this->getSql()->select()
59 59 
             ->join('articles', 'article_posts.article_uuid = articles.article_uuid')
60 
-            ->join('category', 'category.category_uuid = articles.category_uuid', ['category_slug' => 'slug'])
60 
+            ->join('category', 'category.category_uuid = articles.category_uuid', [ 'category_slug' => 'slug' ])
61 61 
             ->limit(1);
62 62
63 
-        if($direction > 0) {
63 
+        if ($direction > 0) {
64 64 
             $select->where->greaterThan('published_at', $publishedAt);
65 
-            $select->order(['published_at' => 'asc']);
66 
-        } elseif($direction < 0) {
65 
+            $select->order([ 'published_at' => 'asc' ]);
66 
+        } elseif ($direction < 0) {
67 67 
             $select->where->lessThan('published_at', $publishedAt);
68 
-            $select->order(['published_at' => 'desc']);
68 
+            $select->order([ 'published_at' => 'desc' ]);
69 69 
         }
70 70
71 71 
         return $this->selectWith($select)->current();
 
@@ -75,7 +75,7 @@  discard block
 
 block discarded – undo
75 75 
     {
76 76 
         $select = $this->getSql()->select()
77 77 
             ->join('articles', 'article_posts.article_uuid = articles.article_uuid')
78 
-            ->where(['article_posts.is_homepage' => true, 'articles.status' => 1]);
78 
+            ->where([ 'article_posts.is_homepage' => true, 'articles.status' => 1 ]);
79 79
80 80 
         return $this->selectWith($select)->current();
81 81 
     }
 
@@ -83,11 +83,11 @@  discard block
 
 block discarded – undo
83 83 
     public function getBySlug($slug)
84 84 
     {
85 85 
         $select = $this->getSql()->select()
86 
-            ->columns(['title', 'body', 'lead', 'featured_img', 'main_img'])
86 
+            ->columns([ 'title', 'body', 'lead', 'featured_img', 'main_img' ])
87 87 
             ->join('articles', 'article_posts.article_uuid = articles.article_uuid')
88 
-            ->join('category', 'category.category_uuid = articles.category_uuid', ['category_name' => 'name', 'category_slug' => 'slug'])
89 
-            ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['first_name', 'last_name'])
90 
-            ->where(['articles.slug' => $slug, 'articles.status' => 1]);
88 
+            ->join('category', 'category.category_uuid = articles.category_uuid', [ 'category_name' => 'name', 'category_slug' => 'slug' ])
89 
+            ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'first_name', 'last_name' ])
90 
+            ->where([ 'articles.slug' => $slug, 'articles.status' => 1 ]);
91 91
92 92 
         return $this->selectWith($select)->current();
93 93 
     }
 
@@ -95,7 +95,7 @@  discard block
 
 block discarded – undo
95 95 
     public function getAll()
96 96 
     {
97 97 
         $select = $this->getSql()->select()
98 
-            ->join('articles', 'article_posts.article_uuid = articles.article_uuid', ['article_id', 'slug']);
98 
+            ->join('articles', 'article_posts.article_uuid = articles.article_uuid', [ 'article_id', 'slug' ]);
99 99
100 100 
         return $this->selectWith($select);
101 101 
     }
 
@@ -104,11 +104,11 @@  discard block
 
 block discarded – undo
104 104 
     {
105 105 
         $select = $this->getSql()->select()
106 106 
             ->join('articles', 'article_posts.article_uuid = articles.article_uuid')
107 
-            ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', ['first_name', 'last_name'])
107 
+            ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', [ 'first_name', 'last_name' ])
108 108 
             ->join('category', 'category.category_uuid = articles.category_uuid',
109 
-                ['category_name' => 'name', 'category_id', 'category_slug' => 'slug'])
110 
-            ->where(['articles.status' => 1])
111 
-            ->order(['articles.published_at' => 'desc'])
109 
+                [ 'category_name' => 'name', 'category_id', 'category_slug' => 'slug' ])
110 
+            ->where([ 'articles.status' => 1 ])
111 
+            ->order([ 'articles.published_at' => 'desc' ])
112 112 
             ->limit($limit);
113 113
114 114 
         return $this->selectWith($select);
Please login to merge, or discard this patch.