Kuperwood\Eav\Model\AttributeGroupModel

Complexity

Total Complexity

4

Size/Duplication

Total Lines	49
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	checkGroupInAttributeSet()	0	17	1
A	create()	0	7	1
A	__construct()	0	4	1
A	findBySetKey()	0	13	1

<?php
/**
 * This file is part of the eav package.
 * @author    Alex Kuperwood <alexkuperwood@gmail.com>
 * @copyright 2025 Alex Kuperwood
 * @license   https://opensource.org/license/mit  The MIT License
 */
declare(strict_types=1);

namespace Kuperwood\Eav\Model;

use Kuperwood\Eav\Database\Connection;
use Kuperwood\Eav\Enum\_GROUP;
use PDO;

class AttributeGroupModel extends Model
{
    public function __construct()
    {
        $this->setTable(_GROUP::table());
        $this->setPrimaryKey(_GROUP::ID);
    }

    public function create(array $data) : int
    {
        $conn = Connection::get();
        $sql = sprintf("INSERT INTO %s (%s, %s) values(:sid, :name)", _GROUP::table(), _GROUP::SET_ID, _GROUP::NAME);
        $stmt = $conn->prepare($sql);
        $stmt->execute(['sid' => $data[_GROUP::SET_ID], 'name' => $data[_GROUP::NAME]]);
        return (int) $conn->lastInsertId();
    }

    public function checkGroupInAttributeSet(int $setKey, int $groupKey) : bool
    {
        $conn = $this->db();
        $sql = sprintf(
            "SELECT %s FROM %s WHERE %s = :set_id AND %s = :group_id",
            $this->getPrimaryKey(),
            $this->getTable(),
            _GROUP::SET_ID,
            _GROUP::ID
        );
        $stmt = $conn->prepare($sql);
        $stmt->bindParam(':set_id', $setKey, PDO::PARAM_INT);
        $stmt->bindParam(':group_id', $groupKey, PDO::PARAM_INT);
        $stmt->execute();

        $result = $stmt->fetch(PDO::FETCH_ASSOC);
        return $result !== false;
    }

    public function findBySetKey($setKey)
    {
        $conn = $this->db();
        $sql = sprintf(
            "SELECT * FROM %s WHERE %s = :set_id ",
            $this->getTable(),
            _GROUP::SET_ID,
        );
        $stmt = $conn->prepare($sql);
        $stmt->bindParam(':set_id', $setKey, PDO::PARAM_INT);
        $stmt->execute();

        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
}