Completed
Push — master ( b09171...d7fe62 )
by Jacob
04:50
created
src/Domain/Blog/MysqlTagRepository.php 1 patch
Indentation   +55 added lines, -55 removed lines patch added patch discarded remove patch
@@ -7,85 +7,85 @@
 block discarded – undo
7 7
 class MysqlTagRepository implements TagRepository
8 8
 {
9 9
 
10
-    /** @var  Aura\Sql\ConnectionLocator */
11
-    protected $connections;
10
+	/** @var  Aura\Sql\ConnectionLocator */
11
+	protected $connections;
12 12
 
13
-    /**
14
-     * @param Aura\Sql\ConnectionLocator
15
-     */
16
-    public function __construct(ConnectionLocator $connections)
17
-    {
18
-        $this->connections = $connections;
19
-    }
13
+	/**
14
+	 * @param Aura\Sql\ConnectionLocator
15
+	 */
16
+	public function __construct(ConnectionLocator $connections)
17
+	{
18
+		$this->connections = $connections;
19
+	}
20 20
 
21
-    /**
22
-     * @param string $title
23
-     *
24
-     * @return array|false
25
-     */
26
-    public function findTagByTitle($title)
27
-    {
28
-        $query = "
21
+	/**
22
+	 * @param string $title
23
+	 *
24
+	 * @return array|false
25
+	 */
26
+	public function findTagByTitle($title)
27
+	{
28
+		$query = "
29 29
             SELECT *
30 30
             FROM `jpemeric_blog`.`tag`
31 31
             WHERE `tag` = :title
32 32
             LIMIT 1";
33
-        $bindings = [
34
-            'title' => $title,
35
-        ];
33
+		$bindings = [
34
+			'title' => $title,
35
+		];
36 36
 
37
-        return $this
38
-            ->connections
39
-            ->getRead()
40
-            ->fetchOne($query, $bindings);
41
-    }
37
+		return $this
38
+			->connections
39
+			->getRead()
40
+			->fetchOne($query, $bindings);
41
+	}
42 42
 
43
-    public function getAllTags()
44
-    {
45
-        $query = "
43
+	public function getAllTags()
44
+	{
45
+		$query = "
46 46
             SELECT *
47 47
             FROM `jpemeric_blog`.`tag`
48 48
             ORDER BY `tag`";
49 49
 
50
-        return $this
51
-            ->connections
52
-            ->getRead()
53
-            ->fetchAll($query);
54
-    }
50
+		return $this
51
+			->connections
52
+			->getRead()
53
+			->fetchAll($query);
54
+	}
55 55
 
56
-    public function getTagCloud()
57
-    {
58
-        $query = "
56
+	public function getTagCloud()
57
+	{
58
+		$query = "
59 59
             SELECT COUNT(1) AS `count`, `tag`
60 60
             FROM `jpemeric_blog`.`tag`
61 61
             INNER JOIN `jpemeric_blog`.`ptlink` ON `ptlink`.`tag_id` = `tag`.`id`
62 62
             INNER JOIN `jpemeric_blog`.`post` ON `post`.`id` = `ptlink`.`post_id` AND
63 63
                                                  `post`.`display` = :is_active
64 64
             GROUP BY `tag`";
65
-        $bindings = [
66
-            'is_active' => 1,
67
-        ];
65
+		$bindings = [
66
+			'is_active' => 1,
67
+		];
68 68
 
69
-        return $this
70
-            ->connections
71
-            ->getRead()
72
-            ->fetchAll($query, $bindings);
73
-    }
69
+		return $this
70
+			->connections
71
+			->getRead()
72
+			->fetchAll($query, $bindings);
73
+	}
74 74
 
75
-    public function getTagsForPost($post)
76
-    {
77
-        $query = "
75
+	public function getTagsForPost($post)
76
+	{
77
+		$query = "
78 78
             SELECT `tag`.*
79 79
             FROM `jpemeric_blog`.`tag`
80 80
             INNER JOIN `jpemeric_blog`.`ptlink` ON `ptlink`.`tag_id` AND `post_id` = :post
81 81
             ORDER BY `tag`";
82
-        $bindings = [
83
-            'post' => $post,
84
-        ];
82
+		$bindings = [
83
+			'post' => $post,
84
+		];
85 85
 
86
-        return $this
87
-            ->connections
88
-            ->getRead()
89
-            ->fetchAll($query, $bindings);
90
-    }
86
+		return $this
87
+			->connections
88
+			->getRead()
89
+			->fetchAll($query, $bindings);
90
+	}
91 91
 }
Please login to merge, or discard this patch.
src/Domain/Blog/MysqlIntroductionRepository.php 1 patch
Indentation   +27 added lines, -27 removed lines patch added patch discarded remove patch
@@ -7,38 +7,38 @@
 block discarded – undo
7 7
 class MysqlIntroductionRepository implements IntroductionRepository
8 8
 {
9 9
 
10
-    /** @var  Aura\Sql\ConnectionLocator */
11
-    protected $connections;
10
+	/** @var  Aura\Sql\ConnectionLocator */
11
+	protected $connections;
12 12
 
13
-    /**
14
-     * @param Aura\Sql\ConnectionLocator
15
-     */
16
-    public function __construct(ConnectionLocator $connections)
17
-    {
18
-        $this->connections = $connections;
19
-    }
13
+	/**
14
+	 * @param Aura\Sql\ConnectionLocator
15
+	 */
16
+	public function __construct(ConnectionLocator $connections)
17
+	{
18
+		$this->connections = $connections;
19
+	}
20 20
 
21
-    /**
22
-     * @param string $type
23
-     * @param string $value
24
-     *
25
-     * @return array|false
26
-     */
27
-    public function findByType($type, $value = '')
28
-    {
29
-        $query = "
21
+	/**
22
+	 * @param string $type
23
+	 * @param string $value
24
+	 *
25
+	 * @return array|false
26
+	 */
27
+	public function findByType($type, $value = '')
28
+	{
29
+		$query = "
30 30
             SELECT `title`, `content`, `image`
31 31
             FROM `jpemeric_blog`.`introduction`
32 32
             WHERE `type` = :type AND `value` = :value
33 33
             LIMIT 1";
34
-        $bindings = [
35
-            'type'  => $type,
36
-            'value' => $value,
37
-        ];
34
+		$bindings = [
35
+			'type'  => $type,
36
+			'value' => $value,
37
+		];
38 38
 
39
-        return $this
40
-            ->connections
41
-            ->getRead()
42
-            ->fetchOne($query, $bindings);
43
-    }
39
+		return $this
40
+			->connections
41
+			->getRead()
42
+			->fetchOne($query, $bindings);
43
+	}
44 44
 }
Please login to merge, or discard this patch.
src/Domain/Blog/MysqlSeriesRepository.php 1 patch
Indentation   +26 added lines, -26 removed lines patch added patch discarded remove patch
@@ -7,25 +7,25 @@  discard block
 block discarded – undo
7 7
 class MysqlSeriesRepository implements SeriesRepository
8 8
 {
9 9
 
10
-    /** @var  Aura\Sql\ConnectionLocator */
11
-    protected $connections;
10
+	/** @var  Aura\Sql\ConnectionLocator */
11
+	protected $connections;
12 12
 
13
-    /**
14
-     * @param Aura\Sql\ConnectionLocator
15
-     */
16
-    public function __construct(ConnectionLocator $connections)
17
-    {
18
-        $this->connections = $connections;
19
-    }
13
+	/**
14
+	 * @param Aura\Sql\ConnectionLocator
15
+	 */
16
+	public function __construct(ConnectionLocator $connections)
17
+	{
18
+		$this->connections = $connections;
19
+	}
20 20
 
21
-    /**
22
-     * @param integer $post
23
-     *
24
-     * @return array|false
25
-     */
26
-    public function getSeriesForPost($post)
27
-    {
28
-        $query = "
21
+	/**
22
+	 * @param integer $post
23
+	 *
24
+	 * @return array|false
25
+	 */
26
+	public function getSeriesForPost($post)
27
+	{
28
+		$query = "
29 29
             SELECT `series`.`title` AS `series_title`, `series`.`description` AS `series_descriptions`,
30 30
                    `post.id` AS `post`, `post`.`title`, `post`.`category`, `post`.`path`
31 31
             FROM `jpemeric_blog`.`series`
@@ -38,14 +38,14 @@  discard block
 block discarded – undo
38 38
                 WHERE `post` = :lookup_post
39 39
                 LIMIT 1)
40 40
             ORDER BY `series_post`.`order`";
41
-        $bindings = [
42
-            'is_active'   => 1,
43
-            'lookup_post' => $post,
44
-        ];
41
+		$bindings = [
42
+			'is_active'   => 1,
43
+			'lookup_post' => $post,
44
+		];
45 45
 
46
-        return $this
47
-            ->connections
48
-            ->getRead()
49
-            ->fetchAll($query, $bindings);
50
-    }
46
+		return $this
47
+			->connections
48
+			->getRead()
49
+			->fetchAll($query, $bindings);
50
+	}
51 51
 }
Please login to merge, or discard this patch.