PdoAllCouponSheets::__construct() - Code Metrics - GermaniaKG/Coupons - Measure and Improve Code Quality continuously with Scrutinizer

PdoAllCouponSheets::__construct() A
last analyzed 2019-02-19 08:42 UTC

↳ Parent: PdoAllCouponSheets

Complexity

Conditions	3
Paths	2

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	12

Importance

Changes

Metric	Value
dl	0
loc	26
ccs	0
cts	9
cp	0
rs	9.504
c	0
b	0
f	0
cc	3
nc	2
nop	4
crap	12

<?php
namespace Germania\Coupons;

class PdoAllCouponSheets implements \Countable, \IteratorAggregate
{

    public $coupon_sheets = array();

    /**
     * @param \PDO   $pdo
     * @param string $sheets_table
     * @param string $coupons_table
     * @param string $php_class
     */
    public function __construct( \PDO $pdo, $sheets_table, $coupons_table, $php_class = null)
    {
        $sql = "SELECT
        Sheets.id,
        Sheets.slug,
        Sheets.name,
        Sheets.quantity,
        Sheets.valid_from,
        Sheets.valid_until,
        GROUP_CONCAT(Coupons.code) AS coupons

        FROM `{$sheets_table}` Sheets

        RIGHT JOIN `{$coupons_table}` Coupons
        ON Coupons.coupon_sheet_id = Sheets.id

        GROUP BY Sheets.id";

        $stmt = $pdo->prepare( $sql );

        if (!$stmt->execute()) {
            throw new \RuntimeException("Could not execute PDOStatement.");
        }

        $this->coupon_sheets = $stmt->fetchAll(\PDO::FETCH_CLASS, $php_class ?: CouponSheet::class);
    }


    public function count()
    {
        return count($this->coupon_sheets);
    }


    /**
     * @return ArrayIterator
     */
    public function getIterator()
    {
        return new \ArrayIterator( $this->coupon_sheets);
    }
}



1			<?php
2			namespace Germania\Coupons;
3
4			class PdoAllCouponSheets implements \Countable, \IteratorAggregate
5			{
6
7			public $coupon_sheets = array();
8
9			/**
10			* @param \PDO $pdo
11			* @param string $sheets_table
12			* @param string $coupons_table
13			* @param string $php_class
14			*/
15			public function __construct( \PDO $pdo, $sheets_table, $coupons_table, $php_class = null)
16			{
17			$sql = "SELECT
18			Sheets.id,
19			Sheets.slug,
20			Sheets.name,
21			Sheets.quantity,
22			Sheets.valid_from,
23			Sheets.valid_until,
24			GROUP_CONCAT(Coupons.code) AS coupons
25
26			FROM `{$sheets_table}` Sheets
27
28			RIGHT JOIN `{$coupons_table}` Coupons
29			ON Coupons.coupon_sheet_id = Sheets.id
30
31			GROUP BY Sheets.id";
32
33			$stmt = $pdo->prepare( $sql );
34
35			if (!$stmt->execute()) {
36			throw new \RuntimeException("Could not execute PDOStatement.");
37			}
38
39			$this->coupon_sheets = $stmt->fetchAll(\PDO::FETCH_CLASS, $php_class ?: CouponSheet::class);
40			}
41
42
43			public function count()
44			{
45			return count($this->coupon_sheets);
46			}
47
48
49			/**
50			* @return ArrayIterator
51			*/
52			public function getIterator()
53			{
54			return new \ArrayIterator( $this->coupon_sheets);
55			}
56			}
57
58

GermaniaKG / Coupons

PdoAllCouponSheets::__construct() A last analyzed 2019-02-19 08:42 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

PdoAllCouponSheets::__construct() A
last analyzed 2019-02-19 08:42 UTC