<?php

namespace App\Models;

use App\Libraries\Database;
use PDO;

class ProductMarkup
{
    private PDO $db;

    public function __construct()
    {
        $this->db = Database::getInstance()->pdo();
    }

    public function getMarkup(
        int $productId,
        int $levelId
    ): ?array {

        $stmt = $this->db->prepare("
            SELECT *
            FROM product_markups
            WHERE product_id = ?
            AND level_id = ?
            LIMIT 1
        ");

        $stmt->execute([
            $productId,
            $levelId
        ]);

        return $stmt->fetch() ?: null;
    }
}