<?php

declare(strict_types=1);

namespace App\Model;

use Mosaico\Model\BaseModel;

class ErrorsModel extends BaseModel
{
    public function getResponseErrors(): bool|object
    {
        $query = $this->connect()->query(
            "
            SELECT 
            r.id_response,
            r.id_resource,
            r.request_method,
            r.status_code,
            r.title,
            r.created,
            et.title
            FROM error_reponses r
            LEFT JOIN error_titles et
            ON r.id_error = et.id_error
			"
        );
        return $query;
    }

    public function addResponseError($error): void
    {
        $query = $this->connect()->query(
            "
            INSERT INTO error_responses SET
            id_api          = " . $error['id_api'] . ",
            id_resource     = " . $error['id_resource'] . ",
            request_method  = '" . $error['request_method'] . "',
            status_code     = '" . $error['status_code'] . "',
            title           = '" . $error['title'] . "',
            detail          = '" . $error['detail'] . "'
        "
        );
    }

    public function getApiId(string $code): int
    {
        (object) $query = $this->connect()->query(
            "
            SELECT id_api FROM bigcommerce_apis
            WHERE code like '%" . $code . "%'
        "
        );

        is_bool($query) ?
        $response = 0 :
        $response = $query->row['id_api'];

        return (int) $response;
    }
}