<?php
/***********************************************************************************
 * The contents of this file are subject to the Extension License Agreement
 * ("Agreement") which can be viewed at
 * https://www.espocrm.com/extension-license-agreement/.
 * By copying, installing downloading, or using this file, You have unconditionally
 * agreed to the terms and conditions of the Agreement, and You may not use this
 * file except in compliance with the Agreement. Under the terms of the Agreement,
 * You shall not license, sublicense, sell, resell, rent, lease, lend, distribute,
 * redistribute, market, publish, commercialize, or otherwise transfer rights or
 * usage to the software or any modified version or derivative work of the software
 * created by or for you.
 *
 * Copyright (C) 2024-2025 Letrium Ltd.
 *
 * License ID: f27e70ce6801a13265271f5669c8bc5c
 ************************************************************************************/

namespace Espo\Modules\Project\Select\ProjectTask\Order;

use Espo\Core\Select\Order\Item;
use Espo\Core\Select\Order\Orderer;
use Espo\Core\Utils\Metadata;
use Espo\ORM\Query\Part\Expression;
use Espo\ORM\Query\Part\Order;
use Espo\ORM\Query\SelectBuilder;

/**
 * @noinspection PhpUnused
 */
class Column implements Orderer
{
    public function __construct(
        private Metadata $metadata,
    ) {}

    public function apply(SelectBuilder $queryBuilder, Item $item): void
    {
        /** @var string[] $statuses */
        $statuses = $this->metadata->get("entityDefs.ProjectTask.fields.status.options") ?? [];

        if ($item->getOrder() === Order::DESC) {
            $statuses = array_reverse($statuses);
        }

        $queryBuilder
            ->leftJoin('column', 'columnOrder')
            ->order(
                Order::createByPositionInList(
                    Expression::column('status'),
                    $statuses
                )
            )
            ->order('columnOrder.order', $item->getOrder());
    }
}
