@extends('layouts.finance')

@section('title', 'Factory Expense Detail')
@section('subtitle', 'Factory expenses from expense records and factory payments')

@section('content')
@php
    $displayCurrency = 'PKR';
    $fmt = fn($usd) => $metrics->moneyIn($usd, 'USD', $displayCurrency);
    $rowCount = $rows->count();
    $latestDate = $rows->max(fn($row) => $row['date']?->toDateString());
    $sourceTotals = $rows
        ->groupBy('source')
        ->map(fn($items) => $items->sum('amount_usd'))
        ->sortDesc();
@endphp

<div class="mb-4">
    <a href="{{ route('dashboard', array_filter(['from' => $filters['from'] ?? null, 'to' => $filters['to'] ?? null])) }}" class="btn btn-ghost" style="font-size:13px">
        <svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><polyline points="15 18 9 12 15 6"/></svg>
        Back to Dashboard
    </a>
</div>

<section class="card mb-6">
    <div class="section-head">
        <h2>Filters</h2>
        <span class="pill">{{ $filters['mode'] === 'date' ? 'Date wise' : 'Monthly' }}</span>
    </div>
    <div class="card-pad">
        <form method="GET" action="{{ route('dashboard.cards.factory-expense') }}" class="grid gap-3" style="grid-template-columns:0.8fr 1fr 1fr 1fr auto auto;align-items:end">
            <div>
                <label class="label">View</label>
                <select class="field" name="mode">
                    <option value="month" @selected($filters['mode'] === 'month')>Monthly</option>
                    <option value="date" @selected($filters['mode'] === 'date')>Date wise</option>
                </select>
            </div>
            <div>
                <label class="label">Month</label>
                <input class="field" type="month" name="month" value="{{ $filters['month'] }}">
            </div>
            <div>
                <label class="label">From</label>
                <input class="field" type="date" name="from" value="{{ $filters['from'] }}">
            </div>
            <div>
                <label class="label">To</label>
                <input class="field" type="date" name="to" value="{{ $filters['to'] }}">
            </div>
            <button class="btn btn-primary">Apply</button>
            <a href="{{ route('dashboard.cards.factory-expense') }}" class="btn">Reset</a>
        </form>
    </div>
</section>

<section class="grid kpi-grid gap-3 mb-6">
    <div class="card kpi-card" style="background:#fff7ed;border-color:#fed7aa">
        <div class="kpi-icon ico-bg-amber"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><polyline points="23 18 13.5 8.5 8.5 13.5 1 6"/><polyline points="17 18 23 18 23 12"/></svg></div>
        <div class="kpi-label">Factory Expense</div>
        <div class="kpi-value" style="color:#ea580c">{{ $fmt($totalUsd) }}</div>
        <div class="kpi-sub">{{ \Illuminate\Support\Carbon::parse($filters['from'])->format('M d, Y') }} - {{ \Illuminate\Support\Carbon::parse($filters['to'])->format('M d, Y') }}</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-icon ico-bg-indigo"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M3 3h18v18H3z"/><path d="M7 8h10M7 13h10M7 18h6"/></svg></div>
        <div class="kpi-label">Expense Rows</div>
        <div class="kpi-value">{{ number_format($rowCount) }}</div>
        <div class="kpi-sub">Records found</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-icon ico-bg-red"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><circle cx="12" cy="12" r="10"/><path d="M12 6v6l4 2"/></svg></div>
        <div class="kpi-label">Average Expense</div>
        <div class="kpi-value">{{ $fmt($rowCount > 0 ? $totalUsd / $rowCount : 0) }}</div>
        <div class="kpi-sub">Per factory row</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-icon ico-bg-purple"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><rect x="3" y="4" width="18" height="18" rx="2"/><path d="M16 2v4M8 2v4M3 10h18"/></svg></div>
        <div class="kpi-label">Latest Expense</div>
        <div class="kpi-value" style="font-size:18px">{{ $latestDate ? \Illuminate\Support\Carbon::parse($latestDate)->format('M d, Y') : '-' }}</div>
        <div class="kpi-sub">Most recent row</div>
    </div>
</section>

@if($sourceTotals->isNotEmpty())
    <section class="grid gap-3 mb-6" style="grid-template-columns:repeat(auto-fit,minmax(180px,1fr))">
        @foreach($sourceTotals as $source => $sourceTotal)
            <div class="card kpi-card">
                <div class="kpi-label">{{ $source }}</div>
                <div class="kpi-value" style="font-size:20px;color:#ea580c">{{ $fmt($sourceTotal) }}</div>
                <div class="kpi-sub">{{ number_format($rows->where('source', $source)->count()) }} row(s)</div>
            </div>
        @endforeach
    </section>
@endif

<section class="card mb-6">
    <div class="section-head">
        <h2>Expense Details</h2>
        <span class="pill pill-amber">{{ $displayCurrency }}</span>
    </div>
    <div style="overflow-x:auto">
        <table>
            <thead>
                <tr>
                    <th>Date</th>
                    <th>Source</th>
                    <th>Account</th>
                    <th>Paid To</th>
                    <th>Description</th>
                    <th>Reference</th>
                    <th class="right">Amount</th>
                    <th class="right">PKR Equivalent</th>
                    <th class="right">View</th>
                </tr>
            </thead>
            <tbody>
                @forelse($rows as $row)
                    <tr class="row-hover">
                        <td>{{ $row['date']?->format('d M Y') ?: '-' }}</td>
                        <td><span class="pill">{{ $row['source'] }}</span></td>
                        <td>{{ $row['account'] ?: '-' }}</td>
                        <td>{{ $row['counterparty'] ?: '-' }}</td>
                        <td>{{ $row['description'] ?: '-' }}</td>
                        <td>{{ $row['reference'] ?: '-' }}</td>
                        <td class="right" style="color:#ea580c;font-weight:700">{{ $metrics->money($row['amount'], $row['currency']) }}</td>
                        <td class="right">{{ $fmt($row['amount_usd']) }}</td>
                        <td class="right">
                            @if($row['transaction'])
                                <a class="btn" style="padding:5px 9px;font-size:12px" href="{{ route('finance.transactions.show', $row['transaction']) }}">Open</a>
                            @else
                                -
                            @endif
                        </td>
                    </tr>
                @empty
                    <tr><td colspan="9" class="muted">No factory expense rows found for this period.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
</section>
@endsection