<?php

namespace Domains\Debt\Exports;

use Domains\Core\Enums\AdminRole;
use Domains\Core\Enums\DebtStatus;
use Domains\Debt\Models\Debt;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\WithStyles;
use Maatwebsite\Excel\Concerns\WithColumnWidths;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Fill;

class DebtExport implements FromCollection, WithHeadings, WithMapping, WithStyles, WithColumnWidths
{
    protected $query;

    public function __construct($query = null)
    {
        $this->query = $query;
    }

    public function collection()
    {
        if ($this->query) {
            return $this->query->get();
        }

        $query = Debt::with(['sale', 'saleLeader', 'customer', 'details', 'payments']);
        
        $currentAdmin = get_auth_admin();
        if ($currentAdmin && !$currentAdmin->checkIsSuperAdmin()) {
            if ($currentAdmin->role === AdminRole::SALE) {
                $query->where('sale_id', $currentAdmin->id);
            } elseif ($currentAdmin->role === AdminRole::LEADER_SALE) {
                $teamMemberIds = $currentAdmin->getTeamMemberIds();
                $query->whereIn('sale_id', $teamMemberIds);
            }
        }
        
        return $query->get();
    }

    public function headings(): array
    {
        return [
            'Số hóa đơn',
            'Ngày xuất HĐ',
            'Ngày công nợ',
            'Sale',
            'Sale Leader',
            'Khách hàng',
            'Tổng giá PO',
            'Tổng thanh toán',
            'Còn lại',
            'Trạng thái',
        ];
    }

    public function map($debt): array
    {
        $invoiceDate = $debt->invoice_date 
            ? $debt->invoice_date->format('d/m/Y') 
            : '-';
        
        $debtAgingDate = $debt->debt_aging_date 
            ? $debt->debt_aging_date->format('d/m/Y') 
            : '-';
        
        $saleName = $debt->sale 
            ? ($debt->sale->code ?? '') . ($debt->sale->code ? ' - ' : '') . $debt->sale->fullname 
            : '-';
        
        $saleLeaderName = $debt->saleLeader 
            ? ($debt->saleLeader->code ?? '') . ($debt->saleLeader->code ? ' - ' : '') . $debt->saleLeader->fullname 
            : '-';
        
        $customerName = $debt->customer ? $debt->customer->name : '-';
        
        $totalPoPrice = number_format($debt->total_po_price, 0, ',', '.');
        
        $totalPaymentAmount = number_format($debt->total_payment_amount, 0, ',', '.');
        
        $remainingAmount = number_format($debt->remaining_amount, 0, ',', '.');
        
        $status = $debt->status instanceof DebtStatus 
            ? $debt->status 
            : DebtStatus::from($debt->status ?? 1);
        $statusText = $status->description();

        return [
            $debt->invoice_number,
            $invoiceDate,
            $debtAgingDate,
            $saleName,
            $saleLeaderName,
            $customerName,
            $totalPoPrice,
            $totalPaymentAmount,
            $remainingAmount,
            $statusText,
        ];
    }

    public function styles(Worksheet $sheet)
    {
        return [
            1 => [
                'font' => ['bold' => true, 'size' => 12],
                'fill' => [
                    'fillType' => Fill::FILL_SOLID,
                    'startColor' => ['rgb' => 'E2E8F0']
                ],
                'alignment' => [
                    'horizontal' => Alignment::HORIZONTAL_CENTER,
                    'vertical' => Alignment::VERTICAL_CENTER,
                ],
            ],
        ];
    }

    public function columnWidths(): array
    {
        return [
            'A' => 20, // Số hóa đơn
            'B' => 15, // Ngày xuất HĐ
            'C' => 15, // Ngày công nợ
            'D' => 25, // Sale
            'E' => 25, // Sale Leader
            'F' => 30, // Khách hàng
            'G' => 20, // Tổng giá PO
            'H' => 20, // Tổng thanh toán
            'I' => 20, // Còn lại
            'J' => 20, // Trạng thái
        ];
    }
}