<?php

/**
 * @package     Dotclear
 *
 * @copyright   Olivier Meunier & Association Dotclear
 * @copyright   AGPL-3.0
 */
declare(strict_types=1);

namespace Dotclear\Plugin\blogroll;

use Exception;
use Dotclear\App;
use Dotclear\Database\Cursor;
use Dotclear\Database\MetaRecord;
use Dotclear\Database\Statement\DeleteStatement;
use Dotclear\Database\Statement\SelectStatement;
use Dotclear\Database\Statement\UpdateStatement;
use Dotclear\Exception\BadRequestException;
use Dotclear\Exception\UnauthorizedException;
use Dotclear\Interface\Core\BlogInterface;
use Dotclear\Plugin\blogroll\Status\Link;

/**
 * @brief   The module blogroll handler.
 * @ingroup blogroll
 */
class Blogroll
{
    /**
     * Blogroll permission
     *
     * @var        string   PERMISSION_BLOGROLL
     */
    public const PERMISSION_BLOGROLL = 'blogroll';

    /**
     * Links table name
     *
     * @var        string   LINK_TABLE_NAME
     */
    public const LINK_TABLE_NAME = 'link';

    /**
     * Table name.
     */
    private readonly string $table;

    /**
     * Constructs a new instance.
     *
     * @param   BlogInterface   $blog   Current blog
     */
    public function __construct(
        private readonly BlogInterface $blog
    ) {
        $this->table = App::db()->con()->prefix() . self::LINK_TABLE_NAME;
    }

    /**
     * Gets the links.
     *
     * @param   array<string, mixed>   $params     The parameters
     *
     * @return  MetaRecord  The links.
     */
    public function getLinks(array $params = []): MetaRecord
    {
        $sql = new SelectStatement();
        $sql
            ->columns([
                'link_id',
                'link_title',
                'link_desc',
                'link_href',
                'link_lang',
                'link_xfn',
                'link_position',
                'link_status',
            ])
            ->from($this->table)
            ->where('blog_id = ' . $sql->quote($this->blog->id()))
            ->order('link_position');

        if (isset($params['link_id']) && is_numeric($params['link_id'])) {
            $sql->and('link_id = ' . (int) $params['link_id'] . ' ');
        }

        if (isset($params['link_status']) && is_numeric($params['link_status'])) {
            $sql->and('link_status = ' . (int) $params['link_status'] . ' ');
        }

        if (isset($params['sql']) && (is_string($params['sql']) || is_array($params['sql']))) {
            /**
             * @var string|array<array-key, string> $extra
             */
            $extra = $params['sql'];
            $sql->sql($extra);
        }

        $rs = $sql->select();
        if ($rs instanceof MetaRecord) {
            $rs = $rs->toStatic();

            $this->setLinksData($rs);
        }

        return $rs ?? MetaRecord::newFromArray([]);
    }

    /**
     * Gets the links.
     *
     * @param   array<string, mixed>   $params     The parameters
     *
     * @return  MetaRecord  The links.
     */
    public function getLangs(array $params = []): MetaRecord
    {
        $order = 'desc';
        if (!empty($params['order']) && is_string($params['order']) && preg_match('/^(desc|asc)$/i', $params['order'])) {
            $order = $params['order'];
        }

        // Use post_lang as an alias of link_lang to be able to use the backend App::backend()->combos()->getLangsCombo() function
        $sql = new SelectStatement();
        $sql
            ->columns([
                $sql->as($sql->count('link_id'), 'nb_link'),
                $sql->as('link_lang', 'post_lang'),
            ])
            ->from($this->table)
            ->where('blog_id = ' . $sql->quote($this->blog->id()))
            ->and("link_lang <> '' ")
            ->and('link_lang IS NOT NULL ')
            ->group('link_lang')
            ->order('link_lang ' . $order);

        if (isset($params['lang']) && is_string($params['lang'])) {
            $sql->and('link_lang = ' . $sql->quote($params['lang']));
        }

        return $sql->select() ?? MetaRecord::newFromArray([]);
    }

    /**
     * Gets a link.
     *
     * @param   string  $id     The identifier
     *
     * @return  MetaRecord  The link.
     */
    public function getLink(string $id): MetaRecord
    {
        return $this->getLinks(['link_id' => $id]);
    }

    /**
     * Adds a link.
     *
     * @param   string  $title  The title
     * @param   string  $href   The href
     * @param   string  $desc   The description
     * @param   string  $lang   The language
     * @param   string  $xfn    The xfn
     * @param   int     $status The status
     *
     * @throws  Exception
     */
    public function addLink(string $title, string $href, string $desc = '', string $lang = '', string $xfn = '', int $status = Link::ONLINE): void
    {
        $cur = App::db()->con()->openCursor($this->table);

        $cur->setStrField('blog_id', $this->blog->id());
        $cur->setStrField('link_title', $title);
        $cur->setStrField('link_href', $href);
        $cur->setStrField('link_desc', $desc);
        $cur->setStrField('link_lang', $lang);
        $cur->setStrField('link_xfn', $xfn);
        $cur->setIntField('link_status', $status);

        if ($cur->strField('link_title') === '') {
            throw new Exception(__('You must provide a link title.'));
        }

        if ($cur->strField('link_href') === '') {
            throw new Exception(__('You must provide a link URL.'));
        }

        $sql = new SelectStatement();
        $run = $sql
            ->column($sql->max('link_id'))
            ->from($this->table)
            ->select();
        $max = $run instanceof MetaRecord ? $run->cardinal() : 0;

        $cur->setIntField('link_id', $max + 1);

        $cur->insert();

        $this->blog->triggerBlog();
    }

    /**
     * Update a link.
     *
     * @param   string  $id     The identifier
     * @param   string  $title  The title
     * @param   string  $href   The href
     * @param   string  $desc   The description
     * @param   string  $lang   The language
     * @param   string  $xfn    The xfn
     *
     * @throws  Exception
     */
    public function updateLink(string $id, string $title, string $href, string $desc = '', string $lang = '', string $xfn = '', int $status = Link::ONLINE): void
    {
        $cur = App::db()->con()->openCursor($this->table);

        $cur->setStrField('link_title', $title);
        $cur->setStrField('link_href', $href);
        $cur->setStrField('link_desc', $desc);
        $cur->setStrField('link_lang', $lang);
        $cur->setStrField('link_xfn', $xfn);
        $cur->setIntField('link_status', $status);

        if ($cur->strField('link_title') === '') {
            throw new Exception(__('You must provide a link title.'));
        }

        if ($cur->strField('link_href') === '') {
            throw new Exception(__('You must provide a link URL.'));
        }

        $this->updateCursor($cur, $id);
    }

    /**
     * Update a category.
     *
     * @param   string  $id     The identifier
     * @param   string  $desc   The description
     * @param   int     $status The status
     *
     * @throws  Exception
     */
    public function updateCategory(string $id, string $desc, int $status = Link::ONLINE): void
    {
        $cur = App::db()->con()->openCursor($this->table);

        $cur->setStrField('link_desc', $desc);
        $cur->setIntField('link_status', $status);

        if ($cur->strField('link_desc') === '') {
            throw new Exception(__('You must provide a category title.'));
        }

        $this->updateCursor($cur, $id);
    }

    /**
     * Adds a category.
     *
     * @param   string  $title  The title
     * @param   int     $status The status
     *
     * @throws  Exception
     *
     * @return  int     The category ID
     */
    public function addCategory(string $title, int $status = Link::ONLINE): int
    {
        $cur = App::db()->con()->openCursor($this->table);

        $cur->setStrField('blog_id', $this->blog->id());
        $cur->setStrField('link_desc', $title);
        $cur->setStrField('link_href', '');
        $cur->setStrField('link_title', '');
        $cur->setIntField('link_status', $status);

        if ($cur->strField('link_desc') === '') {
            throw new Exception(__('You must provide a category title.'));
        }

        $sql = new SelectStatement();
        $run = $sql
            ->column($sql->max('link_id'))
            ->from($this->table)
            ->select();
        $max = $run instanceof MetaRecord ? $run->cardinal() : 0;

        $cur->setIntField('link_id', $max + 1);

        $cur->insert();

        $this->blog->triggerBlog();

        return $cur->intField('link_id');
    }

    /**
     * Delete a link.
     *
     * @param   string  $id     The identifier
     */
    public function delItem(string $id): void
    {
        $id = (int) $id;

        $sql = new DeleteStatement();
        $sql
            ->from($this->table)
            ->where('blog_id = ' . $sql->quote($this->blog->id()))
            ->and('link_id = ' . $id)
            ->delete();

        $this->blog->triggerBlog();
    }

    /**
     * Update a link order.
     *
     * @param   string  $id         The identifier
     * @param   string  $position   The position
     */
    public function updateOrder(string $id, string $position): void
    {
        $cur = App::db()->con()->openCursor($this->table);
        $cur->setIntField('link_position', (int) $position);

        $this->updateCursor($cur, $id);
    }

    /**
     * Update cursor.
     *
     * @param   Cursor  $cur    The cursor
     * @param   string  $id     The link ID
     */
    private function updateCursor(Cursor $cur, string $id): void
    {
        $sql = new UpdateStatement();
        $sql
            ->where('blog_id = ' . $sql->quote($this->blog->id()))
            ->and('link_id = ' . (int) $id)
            ->update($cur);

        $this->blog->triggerBlog();
    }

    /**
     * Sets the links data.
     *
     * @param   MetaRecord  $rs     The links
     */
    private function setLinksData(MetaRecord $rs): void
    {
        $cat_title = null;
        while ($rs->fetch()) {
            $rs->set('is_cat', $rs->strField('link_title') === '' && $rs->strField('link_href') === '');

            if ($rs->boolField('is_cat')) {
                $cat_title = $rs->strField('link_desc');
                $rs->set('cat_title', null);
            } else {
                $rs->set('cat_title', $cat_title);
            }
        }

        $rs->moveStart();
    }

    /**
     * Gets the links hierarchy.
     *
     * @param   MetaRecord  $rs     The links
     *
     * @return  array<string, array<array-key, array<array-key, mixed>>>   The links hierarchy.
     */
    public function getLinksHierarchy(MetaRecord $rs): array
    {
        /**
         * @var array<string, array<array-key, array<array-key, mixed>>>
         */
        $res = [];

        foreach ($rs->rows() as $v) {
            if (!$v['is_cat']) {
                $cat_title         = is_string($v['cat_title']) ? $v['cat_title'] : '';
                $res[$cat_title][] = $v;
            }
        }

        return $res;
    }

    /**
     * @param      array<string>  $ids    The identifiers
     *
     * @return     array<int>
     */
    public function cleanIds(array $ids): array
    {
        $clean_ids = [];

        foreach ($ids as $id) {
            if (is_numeric($id) && $id) {
                $clean_ids[] = abs((int) $id);
            }
        }

        return $clean_ids;
    }

    /**
     * @param      array<string>    $ids        The identifiers
     */
    public function updLinksStatus(array $ids, int $status): void
    {
        if (!App::auth()->check(App::auth()->makePermissions([
            Blogroll::PERMISSION_BLOGROLL,
            App::auth()::PERMISSION_ADMIN,
            App::auth()::PERMISSION_CONTENT_ADMIN,
        ]), App::blog()->id())) {
            throw new UnauthorizedException(__('You are not allowed to change link status.'));
        }

        $sql = new UpdateStatement();

        $posts_ids = $sql->sanitizeIn($ids, 'int', false);
        if ($posts_ids === []) {
            throw new BadRequestException(__('No such entry ID.'));
        }

        $sql
            ->where('blog_id = ' . $sql->quote($this->blog->id()))
            ->and('link_id' . $sql->in($posts_ids));

        $cur = App::db()->con()->openCursor($this->table);

        $cur->setIntField('link_status', $status);

        $sql->update($cur);

        $this->blog->triggerBlog();
    }

    /**
     * @param      array<string>    $ids        The identifiers
     */
    public function delLinks(array $ids): void
    {
        if (!App::auth()->check(App::auth()->makePermissions([
            Blogroll::PERMISSION_BLOGROLL,
            App::auth()::PERMISSION_ADMIN,
            App::auth()::PERMISSION_CONTENT_ADMIN,
        ]), App::blog()->id())) {
            throw new UnauthorizedException(__('You are not allowed to delete links.'));
        }

        $sql = new DeleteStatement();

        $posts_ids = $sql->sanitizeIn($ids, 'int', false);
        if ($posts_ids === []) {
            throw new BadRequestException(__('No such entry ID.'));
        }

        $sql
            ->from($this->table)
            ->where('blog_id = ' . $sql->quote($this->blog->id()))
            ->and('link_id' . $sql->in($posts_ids));

        $sql->delete();

        $this->blog->triggerBlog();
    }
}
