@extends('layouts.admin')

@section('title', 'Neraca Saldo')

@section('content')
    <div class="content-wrapper">
        <!-- Header -->
        <div class="mb-6">
            <div class="flex items-center justify-between">
                <div>
                    <h1 class="text-2xl font-bold text-gray-800 dark:text-white">Neraca Saldo</h1>
                    <p class="text-sm text-gray-500 dark:text-gray-400 mt-0.5">
                        Laporan neraca saldo per akun pada periode tertentu
                    </p>
                </div>
                <div class="flex items-center gap-2">
                    <a href="{{ route('admin.reports.trial-balance.export', request()->all()) }}" class="inline-flex items-center justify-center px-3 py-2 bg-green-600 hover:bg-green-700 text-white font-medium rounded-lg transition-colors duration-200 text-sm">
                        <i class="fas fa-file-excel mr-2 text-xs"></i>
                        Export Excel
                    </a>
                </div>
            </div>
        </div>

        <!-- Filter Form -->
        <div class="bg-white dark:bg-gray-800 rounded-lg border border-gray-200 dark:border-gray-700 p-6 mb-6">
            <form method="GET" action="{{ route('admin.reports.trial-balance') }}" class="grid grid-cols-1 md:grid-cols-3 gap-4">
                <div>
                    <label class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">Tanggal Akhir</label>
                    <input type="date" name="end_date" value="{{ $endDate ?? date('Y-m-d') }}" class="w-full px-3 py-2 border border-gray-300 dark:border-gray-600 dark:bg-gray-700 dark:text-white rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                <div class="flex items-end">
                    <label class="flex items-center">
                        <input type="checkbox" name="show_balance_only" value="1" {{ isset($showOnlyWithBalance) && $showOnlyWithBalance ? 'checked' : '' }} class="w-4 h-4 text-blue-600 bg-gray-100 border-gray-300 rounded focus:ring-blue-500 dark:focus:ring-blue-600 dark:ring-offset-gray-800 focus:ring-2 dark:bg-gray-700 dark:border-gray-600">
                        <span class="ml-2 text-sm text-gray-700 dark:text-gray-300">Tampil yang Bersaldo</span>
                    </label>
                </div>
                <div class="flex items-end">
                    <button type="submit" class="w-full px-4 py-2 bg-blue-600 hover:bg-blue-700 text-white font-medium rounded-lg transition-colors duration-200">
                        <i class="fas fa-search mr-2"></i>Filter
                    </button>
                </div>
            </form>
        </div>

        <!-- Error Message -->
        @if(isset($error))
            <div class="bg-red-50 dark:bg-red-900/20 border border-red-200 dark:border-red-800 rounded-lg p-4 mb-6">
                <div class="flex items-start">
                    <i class="fas fa-exclamation-circle text-red-600 dark:text-red-400 text-xl mr-3 mt-0.5"></i>
                    <div class="flex-1">
                        <h4 class="text-red-800 dark:text-red-200 font-semibold mb-2">Error</h4>
                        <p class="text-sm text-red-700 dark:text-red-300">{{ $error }}</p>
                    </div>
                </div>
            </div>
        @endif

        <!-- Report Content -->
        @if(isset($accounts) && $accounts !== null)
            <div class="bg-white dark:bg-gray-800 rounded-lg border border-gray-200 dark:border-gray-700 overflow-hidden">
                <!-- Header Info -->
                <div class="px-6 py-4 border-b border-gray-200 dark:border-gray-600">
                    <div class="text-center mb-4">
                        <h2 class="text-xl font-bold text-gray-800 dark:text-white">POLJAMTECH</h2>
                        <p class="text-sm text-gray-600 dark:text-gray-400">Jl. Lkr. Barat 3 No.1, Bagan Pete, Kec. Kota Baru, Kota Jambi, Jambi 36361</p>
                    </div>
                    <div class="text-center">
                        <h3 class="text-lg font-semibold text-gray-800 dark:text-white">NERACA SALDO</h3>
                        <p class="text-sm text-gray-600 dark:text-gray-400 mt-1">
                            Per {{ isset($endDate) ? \Carbon\Carbon::parse($endDate)->format('d-M-y') : date('d-M-y') }}
                        </p>
                    </div>
                </div>

                <div class="p-6">
                    <div class="overflow-x-auto">
                        <table class="w-full border border-gray-300 dark:border-gray-600">
                            <thead class="bg-gray-50 dark:bg-gray-700">
                                <tr>
                                    <th class="px-4 py-3 text-center text-xs font-semibold uppercase border-b border-r border-gray-300 dark:border-gray-600">KODE AKUN</th>
                                    <th class="px-4 py-3 text-center text-xs font-semibold uppercase border-b border-r border-gray-300 dark:border-gray-600">NAMA AKUN</th>
                                    <th class="px-4 py-3 text-center text-xs font-semibold uppercase border-b border-r border-gray-300 dark:border-gray-600">JUMLAH</th>
                                    <th class="px-4 py-3 text-center text-xs font-semibold uppercase border-b border-gray-300 dark:border-gray-600">TOTAL</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $currentCategory = null;
                                    $categoryTotal = 0;
                                @endphp
                                
                                @if($accounts && $accounts->count() > 0)
                                    @foreach($accounts->sortBy('kd_perk')->values() as $account)
                                        @if($currentCategory !== $account['category'] && $currentCategory !== null)
                                            <!-- Subtotal per kategori -->
                                            @if($categoryTotal != 0)
                                                <tr class="bg-gray-50 dark:bg-gray-700">
                                                    <td class="px-4 py-3 text-sm border-r border-gray-300 dark:border-gray-600"></td>
                                                    <td class="px-4 py-3 text-sm font-semibold border-r border-gray-300 dark:border-gray-600">
                                                        Jumlah {{ $currentCategory }}
                                                    </td>
                                                    <td class="px-4 py-3 text-sm border-r border-gray-300 dark:border-gray-600"></td>
                                                    <td class="px-4 py-3 text-right text-sm font-bold border-gray-300 dark:border-gray-600">
                                                        {{ number_format($categoryTotal, 0, ',', '.') }}
                                                    </td>
                                                </tr>
                                            @endif
                                            @php $categoryTotal = 0; @endphp
                                        @endif
                                        
                                        @if($currentCategory !== $account['category'])
                                            @php $currentCategory = $account['category']; @endphp
                                        @endif
                                        
                                        @if(abs($account['balance']) > 0.01)
                                            <tr class="border-b border-gray-200 dark:border-gray-600">
                                                <td class="px-4 py-3 text-center text-sm border-r border-gray-300 dark:border-gray-600">{{ $account['kd_perk'] }}</td>
                                                <td class="px-4 py-3 text-sm border-r border-gray-300 dark:border-gray-600">{{ $account['nama_perkiraan'] }}</td>
                                                <td class="px-4 py-3 text-right text-sm border-r border-gray-300 dark:border-gray-600">
                                                    {{ number_format($account['balance'], 0, ',', '.') }}
                                                </td>
                                                <td class="px-4 py-3 text-sm border-gray-300 dark:border-gray-600"></td>
                                            </tr>
                                            @php $categoryTotal += $account['balance']; @endphp
                                        @endif
                                    @endforeach
                                    
                                    @if($currentCategory !== null && $categoryTotal != 0)
                                        <!-- Subtotal kategori terakhir -->
                                        <tr class="bg-gray-50 dark:bg-gray-700">
                                            <td class="px-4 py-3 text-sm border-r border-gray-300 dark:border-gray-600"></td>
                                            <td class="px-4 py-3 text-sm font-semibold border-r border-gray-300 dark:border-gray-600">
                                                Jumlah {{ $currentCategory }}
                                            </td>
                                            <td class="px-4 py-3 text-sm border-r border-gray-300 dark:border-gray-600"></td>
                                            <td class="px-4 py-3 text-right text-sm font-bold border-gray-300 dark:border-gray-600">
                                                {{ number_format($categoryTotal, 0, ',', '.') }}
                                            </td>
                                        </tr>
                                    @endif
                                    
                                    <!-- Total Aktiva -->
                                    <tr class="bg-blue-50 dark:bg-blue-900/20">
                                        <td class="px-4 py-3 text-sm border-r border-gray-300 dark:border-gray-600"></td>
                                        <td class="px-4 py-3 text-sm font-bold border-r border-gray-300 dark:border-gray-600">
                                            TOTAL AKTIVA
                                        </td>
                                        <td class="px-4 py-3 text-sm border-r border-gray-300 dark:border-gray-600"></td>
                                        <td class="px-4 py-3 text-right text-sm font-bold border-gray-300 dark:border-gray-600">
                                            {{ number_format(abs($totalAktiva ?? 0), 0, ',', '.') }}
                                        </td>
                                    </tr>
                                    
                                    <!-- Total Kewajiban dan Ekuitas -->
                                    <tr class="bg-blue-50 dark:bg-blue-900/20">
                                        <td class="px-4 py-3 text-sm border-r border-gray-300 dark:border-gray-600"></td>
                                        <td class="px-4 py-3 text-sm font-bold border-r border-gray-300 dark:border-gray-600">
                                            TOTAL KEWAJIBAN DAN EKUITAS
                                        </td>
                                        <td class="px-4 py-3 text-sm border-r border-gray-300 dark:border-gray-600"></td>
                                        <td class="px-4 py-3 text-right text-sm font-bold border-gray-300 dark:border-gray-600">
                                            {{ number_format(abs(($totalKewajiban ?? 0) + ($totalEkuitas ?? 0)), 0, ',', '.') }}
                                        </td>
                                    </tr>
                                @else
                                    <tr>
                                        <td colspan="4" class="px-4 py-8 text-center text-sm text-gray-500 dark:text-gray-400">
                                            Tidak ada data untuk periode yang dipilih
                                        </td>
                                    </tr>
                                @endif
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        @else
            <div class="bg-white dark:bg-gray-800 rounded-lg border border-gray-200 dark:border-gray-700 p-12 text-center">
                <div class="w-16 h-16 bg-gray-100 dark:bg-gray-700 rounded-full flex items-center justify-center mb-3 mx-auto">
                    <i class="fas fa-balance-scale text-3xl text-gray-400 dark:text-gray-500"></i>
                </div>
                <p class="text-gray-500 dark:text-gray-400 font-medium mb-1">Tidak Ada Data</p>
                <p class="text-gray-400 dark:text-gray-500 text-sm">Tidak ada data neraca saldo untuk periode yang dipilih</p>
            </div>
        @endif
    </div>
@endsection