<?php

class Products
{
    const COUNT_OF_PRODUCTS = 6;

    public static function getRecommended()
    {
        $db = DataBase::connectDB();

        $result = $db->query("SELECT * FROM products WHERE `is_recommended` = 1");
        //$result->setFetchMode(PDO::FETCH_ASSOC);

        $res = array();
        while($row = $result->fetch(PDO::FETCH_ASSOC))
            $res[] = $row;

        return $res;
    }

    public static function getCurrentProduct($id)
    {
        $db = DataBase::connectDB();

        $result = $db->query("SELECT * FROM products WHERE `id` = $id");

        $res = $result->fetch(PDO::FETCH_ASSOC);

        return $res;
    }

    public static function setCurrentProduct($id)
    {
        $db = DataBase::connectDB();

        $name = $_POST['name'];
        $price = strval($_POST['price']);
        $description = $_POST['description'];
        $is_recommended = $_POST['is_recommended'];
        $prod_status = $_POST['prod_status'];
        $is_availible = $_POST['is_availible'];
        $res = $db->prepare("UPDATE `products`
        SET `name` = :name,
        `price` = :price,
        `description` = :description,
        `is_recommended` =  :is_recommended,
        `status` = :prod_status,
        `is_availivle` = :is_availible
        WHERE `id` = :id");

        $res->bindParam(':name', $name);
        $res->bindParam(':price', $price);
        $res->bindParam(':description', $description);
        $res->bindParam(':is_recommended', $is_recommended);
        $res->bindParam(':prod_status', $prod_status);
        $res->bindParam(':is_availible', $is_availible);
        $res->bindParam(':id', $id);

        return $res->execute();
    }

    public static function getProducts($category = 0,$page = 1, $count = self::COUNT_OF_PRODUCTS)
    {
        $db = DataBase::connectDB();

        $result = ($category != 0)?$db->query("SELECT * FROM products WHERE `status` = 1 AND `category` = $category ORDER BY `id` DESC LIMIT $count OFFSET ".$count*($page-1)):
                    $db->query("SELECT * FROM products WHERE `status` = 1 ORDER BY `id` DESC LIMIT $count OFFSET ".$count*($page-1));

        $res = array();
        if($result)
            while($row = $result->fetch(PDO::FETCH_ASSOC))
                $res[] = $row;

        return $res;
    }

    public static function getTotalProductsInCategory($categoryId = 0)
    {
        // Соединение с БД
        $db = DataBase::connectDB();
        // Текст запроса к БД
        $sql = ($categoryId)?'SELECT count(id) AS count FROM products WHERE status="1" AND category = :category_id':'SELECT count(id) AS count FROM products WHERE status="1"';
        // Используется подготовленный запрос
        $result = $db->prepare($sql);
        $result->bindParam(':category_id', $categoryId, PDO::PARAM_INT);
        // Выполнение коменды
        $result->execute();
        // Возвращаем значение count - количество
        $row = $result->fetch();
        return $row['count'];
    }

}