@extends('layouts.app')
@section('content')
<div class="max-w-7xl mx-auto p-6">
    <h1 class="text-xl font-semibold mb-4">Trial Balance</h1>
    <form method="GET" class="bg-white rounded shadow p-4 grid grid-cols-4 gap-4 mb-4">
        <div>
            <label class="block text-sm font-medium mb-1">From</label>
            <input type="date" name="from" value="{{ $from }}" class="w-full border rounded p-2">
        </div>
        <div>
            <label class="block text-sm font-medium mb-1">To</label>
            <input type="date" name="to" value="{{ $to }}" class="w-full border rounded p-2">
        </div>
        <div class="flex items-end">
            <button class="px-4 py-2 bg-gray-800 text-white rounded">Filter</button>
        </div>
        <div class="flex items-end gap-2">
            <form method="POST" action="{{ route('reports.export.pdf', 'trial-balance') }}">
                @csrf
                <input type="hidden" name="from" value="{{ $from }}">
                <input type="hidden" name="to" value="{{ $to }}">
                <button class="px-3 py-2 bg-red-600 text-white rounded">PDF</button>
            </form>
            <form method="POST" action="{{ route('reports.export.excel', 'trial-balance') }}">
                @csrf
                <input type="hidden" name="from" value="{{ $from }}">
                <input type="hidden" name="to" value="{{ $to }}">
                <button class="px-3 py-2 bg-green-600 text-white rounded">Excel</button>
            </form>
        </div>
    </form>
    <div class="bg-white rounded shadow overflow-hidden">
        <table class="min-w-full">
            <thead class="bg-gray-50">
                <tr>
                    <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Account Code</th>
                    <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Account Name</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Debit Total</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Credit Total</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Balance</th>
                </tr>
            </thead>
            <tbody class="divide-y divide-gray-100">
                @foreach($rows as $r)
                <tr>
                    <td class="px-4 py-2">{{ $r['code'] }}</td>
                    <td class="px-4 py-2">{{ $r['name'] }}</td>
                    <td class="px-4 py-2 text-right">{{ number_format($r['debit'], 2) }}</td>
                    <td class="px-4 py-2 text-right">{{ number_format($r['credit'], 2) }}</td>
                    <td class="px-4 py-2 text-right">{{ number_format($r['balance'], 2) }}</td>
                </tr>
                @endforeach
            </tbody>
            <tfoot class="bg-gray-50">
                <tr>
                    <td class="px-4 py-2 font-semibold" colspan="2">Grand Totals</td>
                    <td class="px-4 py-2 text-right font-semibold">{{ number_format($totals['debit'], 2) }}</td>
                    <td class="px-4 py-2 text-right font-semibold">{{ number_format($totals['credit'], 2) }}</td>
                    <td></td>
                </tr>
            </tfoot>
        </table>
    </div>
    @if(!$balanced)
    <div class="mt-3 px-4 py-2 bg-red-100 text-red-800 rounded">Warning: Debits and Credits do not match.</div>
    @endif
</div>
@endsection