<?php

namespace App\Exports;

use App\Enums\Order\OrderStatus;
use App\Exports\Concerns\FormatsBillingCells;
use App\Models\Order;
use Illuminate\Database\Eloquent\Builder;

final class OrdersExport implements BrandedReport
{
    use FormatsBillingCells;

    public function __construct(private readonly Builder $query) {}

    public function title(): string
    {
        return 'Danh sách đơn hàng';
    }

    public function query(): Builder
    {
        return $this->query->latest('id');
    }

    public function moneyColumns(): array
    {
        return ['F', 'G', 'H'];
    }

    public function headings(): array
    {
        return [
            'Mã đơn hàng', 'Ngày đặt', 'Khách hàng', 'Email', 'Dịch vụ', 'Tạm tính', 'Giảm giá',
            'Tổng tiền', 'Trạng thái', 'Phương thức thanh toán', 'Hoá đơn', 'Ghi chú', 'Ngày tạo',
        ];
    }

    /**
     * @param Order $order
     */
    public function map($order): array
    {
        return [
            $order->order_num,
            $this->formatDate($order->date),
            $order->customer?->fullname,
            $order->customer?->email,
            $this->describeServices($order),
            (int) $order->sub_total,
            (int) $order->discount_amount,
            (int) $order->total,
            OrderStatus::tryFrom((int) $order->status)?->label() ?? $order->status,
            $order->payment?->name ?? $this->paymentMethodLabel($order->payment_method),
            $order->invoices->pluck('invoice_number')->implode(', '),
            $order->note,
            $this->formatDate($order->created_at, 'd/m/Y H:i'),
        ];
    }
}