<?php

declare(strict_types=1);

namespace App\Model;

use Mosaico\Model\BaseModel;

class ProductModel extends BaseModel
{
    public function getProduct($url)
    {
        $query = $this->connect()->query(
            "SELECT * 
            FROM products 
            WHERE url = '" . $url . "'
            ");
        return $query;
    }

    public function getProductImages($id)
    {
        $query = $this->connect()->query(
            "SELECT * 
            FROM product_images 
            WHERE id_product = " . $id . "
            ");
        return $query;
    }

    public function getProducts()
    {
        $query = $this->connect()->query(
            "SELECT 
            id_product,
            sku,
            url,
            name,
            image,
            price
            FROM products
            WHERE is_enable = 1
            ORDER BY relevance ASC
            ");
        return $query;
    }

}