<?php
/**
 * 2007-2024 PrestaShop
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Academic Free License (AFL 3.0)
 * that is bundled with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * http://opensource.org/licenses/afl-3.0.php
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to http://www.prestashop.com for more information.
 *
 *  @author    PrestaShop SA <contact@prestashop.com>
 *  @copyright 2007-2024 PrestaShop SA
 *  @license   http://opensource.org/licenses/afl-3.0.php  Academic Free License (AFL 3.0)
 *  International Registered Trademark & Property of PrestaShop SA
 */
namespace PrestaShop\Module\Chatgptcontentgenerator\Entity;

if (!defined('_PS_VERSION_')) {
    exit;
}

class GptContentPost extends \ObjectModel
{
    public $id_product;
    public $id_gptcontent_post_category;
    public $title;
    public $meta_title;
    public $meta_description;
    public $meta_keywords;
    public $short_content;
    public $content;
    public $link_rewrite;
    public $active = 1;
    public $date_add;
    public $date_upd;
    public $is_featured = 0;
    public $cover;
    public $featured;
    public $author;
    public $likes = 0;
    public $views = 0;
    public $allow_comments = 3;
    public $video_code;

    public static $definition = [
        'table' => 'gptcontent_post',
        'primary' => 'id_gptcontent_post',
        'multilang' => true,
        'fields' => [
            'id_gptcontent_post_category' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'],
            'active' => ['type' => self::TYPE_BOOL],
            'is_featured' => ['type' => self::TYPE_BOOL],
            'author' => ['type' => self::TYPE_STRING],
            'likes' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'],
            'views' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'],
            'allow_comments' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'],
            'cover' => ['type' => self::TYPE_STRING],
            'featured' => ['type' => self::TYPE_STRING],
            'id_product' => ['type' => self::TYPE_INT],
            'date_add' => ['type' => self::TYPE_DATE, 'validate' => 'isDate'],
            'date_upd' => ['type' => self::TYPE_DATE, 'validate' => 'isDate'],

            'title' => ['type' => self::TYPE_STRING, 'lang' => true, 'validate' => 'isGenericName', 'required' => true, 'size' => 255],
            'meta_title' => ['type' => self::TYPE_STRING, 'lang' => true, 'validate' => 'isGenericName', 'size' => 255],
            'meta_description' => ['type' => self::TYPE_STRING, 'lang' => true, 'validate' => 'isGenericName', 'size' => 255],
            'meta_keywords' => ['type' => self::TYPE_STRING, 'lang' => true, 'validate' => 'isGenericName', 'size' => 255],
            'link_rewrite' => ['type' => self::TYPE_STRING, 'lang' => true, 'validate' => 'isLinkRewrite', 'required' => true, 'size' => 128],
            'short_content' => ['type' => self::TYPE_HTML, 'lang' => true, 'validate' => 'isCleanHtml'],
            'content' => ['type' => self::TYPE_HTML, 'lang' => true, 'validate' => 'isCleanHtml'],
            'video_code' => ['type' => self::TYPE_HTML, 'lang' => true, 'validate' => 'isCleanHtml'],
        ],
    ];

    public function getCoversDir()
    {
        return 'chatgptcontentgenerator/covers/';
    }

    public function getCoversFullDir()
    {
        return _PS_IMG_DIR_ . $this->getCoversDir();
    }

    public function getCoverPath()
    {
        return _PS_IMG_DIR_ . $this->cover;
    }

    public function getCoverThumbPath()
    {
        if (!empty($this->cover)) {
            return $this->getCoversFullDir() . $this->id . '/' . $this->id . '-thumb.jpg';
        }

        return false;
    }

    public function createCover($img)
    {
        if (!file_exists($img)) {
            throw new \Exception('Image not exist');
        }

        $mime = \ImageManager::getMimeType($img);

        $imageTypes = [
            'image/jpeg' => 'jpg',
            'image/png' => 'png',
        ];

        if (array_key_exists($mime, $imageTypes)) {
            $extension = $imageTypes[$mime];
        } else {
            throw new \Exception('Image type not allowed');
        }

        $this->cover = $this->getCoversDir() . $this->id . '/' . $this->id . '.' . $extension;

        if (!file_exists($this->getCoversFullDir() . $this->id . '/')) {
            mkdir($this->getCoversFullDir() . $this->id . '/', 0777, true);
        }

        move_uploaded_file($img, $this->getCoverPath());

        $thumb = $this->getCoversFullDir() . $this->id . '/' . $this->id . '-thumb.jpg';

        $module = \Module::getInstanceByName('chatgptcontentgenerator');

        $thumb_x = $module->getConfig('CHATGPTCONTENTGENERATOR_BLOG_THUMB_X', null, null, null, 600);
        $thumb_y = $module->getConfig('CHATGPTCONTENTGENERATOR_BLOG_THUMB_Y', null, null, null, 300);

        $statusThumb = \ImageManager::resize($this->getCoverPath(), $thumb, $thumb_x, $thumb_y, 'jpg');

        if ($statusThumb) {
            return $this->save();
        } else {
            throw new \Exception('Thumbnails not created');
        }

        return false;
    }

    public function deleteCover()
    {
        if (file_exists($this->getCoverPath())) {
            @unlink($this->getCoverPath());
        }

        if (file_exists($this->getCoverThumbPath())) {
            @unlink($this->getCoverThumbPath());
        }

        $this->cover = null;
        return $this->update();
    }

    public function add($auto_date = true, $null_values = false)
    {
        if ($res = parent::add($auto_date, $null_values)) {
            $this->chechDefaultCategory();
        }

        return $res;
    }

    public function update($null_values = false)
    {
        if ($res = parent::update($null_values)) {
            $this->chechDefaultCategory();
        }

        return $res;
    }

    public function delete()
    {
        $this->deleteCover();
        $this->deleteCategories();

        return parent::delete();
    }

    public function getCoverThumbnailLink()
    {
        $context = \Context::getContext();

        if (!empty($this->cover)) {
            $link = $context->link->getMediaLink('/img/' . $this->getCoversDir() . $this->id . '/' . $this->id . '-thumb.jpg');
            return $link;
        }

        return $context->link->getMediaLink(\Module::getInstanceByName('chatgptcontentgenerator')->getPathUri() . 'views/img/no.jpeg');
    }

    public function getCoverLink()
    {
        $context = \Context::getContext();

        if (!empty($this->cover)) {
            $link = $context->link->getMediaLink('/img/' . $this->cover);
            return $link;
        }

        return $context->link->getMediaLink(\Module::getInstanceByName('chatgptcontentgenerator')->getPathUri() . 'views/img/no.jpeg');
    }

    public function getLink()
    {
        $context = \Context::getContext();
        return $context->link->getModuleLink('chatgptcontentgenerator', 'blogpost', ['rewrite' => $this->link_rewrite]);
    }

    public function increaseViews()
    {
        $this->views = $this->views + 1;
        \Db::getInstance()->execute('UPDATE ' . _DB_PREFIX_ . 'gptcontent_post SET views = views + 1
            WHERE id_gptcontent_post = ' . $this->id . ' LIMIT 1');
    }

    public static function getPageLink($page_nb)
    {
        $context = \Context::getContext();
        return $context->link->getModuleLink('chatgptcontentgenerator', 'bloghome', ['p' => $page_nb]);
    }

    public static function getPosts(
        $id_lang,
        $limit = 10,
        $search = null,
        $page = null,
        $active = true,
        $orderby = false,
        $orderway = false,
        $exclude = null,
        $featured = false,
        $id_shop = null,
        $filter = false,
        $selected = [],
        $or = false,
        $idGgptContentBlogCategory = 0
    ) {
        $context = \Context::getContext();
        $sql = new \DbQuery();
        $sql->select('SQL_CALC_FOUND_ROWS *');
        $sql->from('gptcontent_post', 'sbp');

        if ($id_lang) {
            $sql->innerJoin('gptcontent_post_lang', 'l', 'sbp.id_gptcontent_post = l.id_gptcontent_post AND l.id_lang = ' . (int) $id_lang);
        }

        if (!$id_shop) {
            $id_shop = $context->language->id_lang;
        }

        if (!is_null($search) && $id_lang) {
            $sql->where("l.content LIKE '%" . pSQL($search) . "%' OR l.title LIKE '%" . pSQL($search) . "%'");
        }

        if ($active) {
            $sql->where('sbp.active = 1');
        }

        if ($exclude) {
            $sql->where('sbp.id_gptcontent_post != ' . (int) $exclude);
        }

        if ($filter) {
            if ($or) {
                $sql->where('sbp.' . $filter . ' (' . join(',', $selected) . ') OR sbp.' . $or);
            } else {
                $sql->where('sbp.' . $filter . ' (' . join(',', $selected) . ')');
            }
        }

        if ($idGgptContentBlogCategory) {
            $sql->innerJoin(
                'gptcontent_blog_category_post',
                'gbcp', 'sbp.id_gptcontent_post = gbcp.id_gptcontent_post AND gbcp.id_gptcontent_blog_category = ' . (int) $idGgptContentBlogCategory
            );
        }

        $sql->where('sbp.date_add <= \'' . date('Y-m-d H:i:s') . '\'');

        if (!$orderby) {
            $orderby = 'sbp.date_add';
        }

        if (!$orderway) {
            $orderway = 'DESC';
        }

        $sql->orderBy($orderby . ' ' . $orderway);

        if ($limit) {
            $start = $limit * ($page == 0 ? 0 : $page - 1);
            $sql->limit($limit, $start);
        }

        $result = \Db::getInstance()->executeS($sql);
        $result = \ObjectModel::hydrateCollection(self::class, $result, $id_lang);
        $count = \Db::getInstance()->getValue('SELECT FOUND_ROWS()');

        return ['posts' => $result, 'count' => $count];
    }

    public static function getInstanceByRewrite($rewrite, $id_lang = false)
    {
        if ($id_lang === false) {
            $id_lang = \Context::getContext()->language->id_lang;
        }

        if (!$rewrite) {
            return new GptContentPost();
        }

        $sql = new \DbQuery();
        $sql->select('l.id_gptcontent_post ');
        $sql->from('gptcontent_post_lang', 'l');

        $sql->where('l.link_rewrite = \'' . pSQL($rewrite) . '\' AND l.id_lang = ' . (int) $id_lang);

        if ($id = \Db::getInstance()->getValue($sql)) {
            $post = new GptContentPost((int) $id, $id_lang);
            return $post;
        }

        return new GptContentPost();
    }

    public function chechDefaultCategory($idGgptContentBlogCategory = 0)
    {
        if (!$this->getIdCategoryDefault(false)) {
            if (!$idGgptContentBlogCategory) {
                $idGgptContentBlogCategory = GptContentBlogCategory::getIdRootCategory();
            }

            $this->sedDefaultCategory($idGgptContentBlogCategory);
        }
    }

    public function sedDefaultCategory($idGgptContentBlogCategory)
    {
        if (!$this->id) {
            return false;
        }

        \Db::getInstance()->update(
            'gptcontent_blog_category_post',
            [
                'is_default' => 0,
            ],
            '`id_gptcontent_post` = ' . (int) $this->id
        );

        $this->addToCategories($idGgptContentBlogCategory);

        \Db::getInstance()->update(
            'gptcontent_blog_category_post',
            [
                'is_default' => 1,
            ],
            '`id_gptcontent_post` = ' . (int) $this->id . '
                AND `id_gptcontent_blog_category` = ' . (int) $idGgptContentBlogCategory
        );

        \Cache::clean('GptContentPost::idCategoryDefault');
    }

    public function addToCategories($categories = [])
    {
        if (
            !$this->id
            || empty($categories)
        ) {
            return false;
        }

        if (!is_array($categories)) {
            $categories = [$categories];
        }

        $categories = array_map('intval', $categories);

        $currentCategories = $this->getCategories();
        $postCategories = [];

        foreach ($categories as $idGgptContentBlogCategory) {
            if (!in_array($idGgptContentBlogCategory, $currentCategories)) {
                $postCategories[] = [
                    'id_gptcontent_blog_category' => $idGgptContentBlogCategory,
                    'id_gptcontent_post' => (int) $this->id,
                ];
            }
        }

        \Db::getInstance()->insert('gptcontent_blog_category_post', $postCategories);
        \Cache::clean('GptContentPost::getPostCategories_' . (int) $this->id);

        return true;
    }

    public function deleteCategory($idGgptContentBlogCategory)
    {
        $return = \Db::getInstance()->delete('gptcontent_blog_category_post',
            'id_gptcontent_blog_category = ' . (int) $idGgptContentBlogCategory . '
                AND id_gptcontent_post = ' . (int) $this->id
        );

        \Cache::clean('GptContentPost::getPostCategories_' . (int) $this->id);

        return $return;
    }

    public function deleteCategories()
    {
        $return = \Db::getInstance()->delete(
            'gptcontent_blog_category_post',
            'id_gptcontent_post = ' . (int) $this->id
        );

        \Cache::clean('GptContentPost::getPostCategories_' . (int) $this->id);

        return $return;
    }

    public function getIdCategoryDefault($use_cache = true)
    {
        $cacheId = 'GptContentPost::idCategoryDefault';

        if ($use_cache && !\Cache::isStored($cacheId)) {
            $sql = new \DbQuery();
            $sql->select('id_gptcontent_blog_category')
                ->from('gptcontent_blog_category_post')
                ->where('id_gptcontent_post = ' . (int) $this->id)
                ->where('is_default = 1')
            ;

            if (!$idCategory = \Db::getInstance()->getValue($sql)) {
                $idCategory = GptContentBlogCategory::getIdRootCategory();
            }

            \Cache::store($cacheId, (int) $idCategory);

            return $idCategory;
        }

        return \Cache::retrieve($cacheId);
    }

    public function getCategories()
    {
        if (!$this->id) {
            return [];
        }

        return self::getPostCategories($this->id);
    }

    public static function getPostCategories($id_gptcontent_post = '')
    {
        $cache_id = 'GptContentPost::getPostCategories_' . (int) $id_gptcontent_post;

        if (!\Cache::isStored($cache_id)) {
            $res = [];
            $row = \Db::getInstance()->executeS('SELECT `id_gptcontent_blog_category`
                FROM `' . _DB_PREFIX_ . 'gptcontent_blog_category_post`
                    WHERE `id_gptcontent_post` = ' . (int) $id_gptcontent_post
            );

            if ($row) {
                foreach ($row as $val) {
                    $res[] = (int) $val['id_gptcontent_blog_category'];
                }
            }

            \Cache::store($cache_id, $res);

            return $res;
        }

        return \Cache::retrieve($cache_id);
    }

    public static function isExistsByRewrite($rewrite, $id_lang = false, $exludeId = 0)
    {
        if ($id_lang === false) {
            $id_lang = \Context::getContext()->language->id_lang;
        }

        $sql = new \DbQuery();
        $sql->select('l.id_gptcontent_post ');
        $sql->from('gptcontent_post_lang', 'l');

        $sql->where('l.link_rewrite = \'' . pSQL($rewrite) . '\' AND l.id_lang = ' . (int) $id_lang);

        if ($exludeId) {
            $sql->where('l.id_gptcontent_post <> ' . (int) $exludeId);
        }

        return (int) \Db::getInstance()->getValue($sql);
    }
}