Germania\Coupons\PdoAllCouponSheets

Complexity

Total Complexity

5

Size/Duplication

Total Lines	53
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	0

Test Coverage

Coverage

0%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	26	3
A	count()	0	4	1
A	getIterator()	0	4	1

<?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);
    }
}