Germania\Coupons\PdoValidAtDateTimeCouponSheetsFactory

Complexity

Total Complexity

5

Size/Duplication

Total Lines	66
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Test Coverage

Coverage

0%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	25	2
A	__invoke()	0	13	3

<?php
namespace Germania\Coupons;

class PdoValidAtDateTimeCouponSheetsFactory
{

    /**
     * @var PDOStatement
     */
    public $stmt;


    /**
     * @var string
     */
    public $php_class;


    /**
     * @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)
    {
        $this->php_class = $php_class ?: CouponSheet::class;

        $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

        WHERE (valid_until IS NULL OR valid_until >= :datetime_string)
        AND   (valid_from  <= :datetime_string)

        GROUP BY Sheets.id";

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

It seems like $pdo->prepare($sql) of type object<PDOStatement> is incompatible with the declared type object<Germania\Coupons\PDOStatement> of property $stmt.

    }


    /**
     * @return ArrayIterator
     */
    public function __invoke( \DateTimeInterface $when, $php_class = null )
    {
        if (!$this->stmt->execute([
            'datetime_string' => $when->format("Y-m-d H:i:s")
        ])) {
            throw new \RuntimeException("Could not execute PDOStatement.");
        }


        $sheets = $this->stmt->fetchAll(\PDO::FETCH_CLASS, $php_class ?: $this->php_class);

        return new \ArrayIterator( $sheets );
    }

}