<?php

declare(strict_types=1);

namespace App\Model;

use Mosaico\Model\BaseModel;

class ConfigModel extends BaseModel
{

    public function getConfigByType(int $id_type): bool|object
    {
        $query = $this->connect()->query("
            SELECT 
            id_config,
            name,
            value
            FROM config_data
            WHERE id_type = " . $id_type . "
        ");
        return $query;
    }

    public function getData(string $name): bool|object
    {
        $query = $this->connect()->query("
            SELECT
            id_config,
            name,
            value
            FROM config_data
            WHERE name = '" . $name . "'
        ");
        return $query;
    }

    public function getValue(string $name): string
    {
        $query = $this->connect()->query("
			SELECT value
			FROM config_data
			WHERE name = '" . $name . "'
		");
        return is_object($query) ? (string) $query->row['value'] : '';
    }

    public function updateValueByName($name, string $value): void
    {
        $query = $this->connect()->query("
			UPDATE config_data
			SET value = '" . $value . "'
			WHERE name = '" . $name . "'
		");
    }

    public function updateValueById($id, string $value): void
    {
        $query = $this->connect()->query("
            UPDATE config_data
            SET value = '" . $value . "'
            WHERE id_config = " . $id . "
        ");
    }
}