GermaniaKG / Coupons

     * @param string $coupons_table

     * @param string $php_class

     */

    public function __construct( \PDO $pdo, $coupons_table, $php_class = null)

    {

        $this->php_class = $php_class ?: Coupon::class;

        if (!is_subclass_of($this->php_class, CouponInterface::class ))

            throw new \InvalidArgumentException("Class name or instance of CouponInterface expected.");

        $sql = "SELECT

        -- id field twice here due to FETCH_UNIQUE

        id,

        id,

        code,

        coupon_sheet_id

        FROM `{$coupons_table}`

        WHERE coupon_sheet_id = :sheet_id";

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

        $this->stmt->setFetchMode( \PDO::FETCH_CLASS, $this->php_class );

    }

    /**

     * @param  int|CouponSheetInterface $sheet_id

     * @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;

        if (!is_subclass_of($this->php_class, CouponSheetInterface::class ))

            throw new \InvalidArgumentException("Class name or instance of CouponSheetInterface expected.");

        $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 Sheets.id   = :id

        OR    Sheets.slug = :id

        LIMIT 1";

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

        $this->stmt->setFetchMode( \PDO::FETCH_CLASS, $this->php_class );

    }

    /**

     * @param  string|int $id