@extends('layouts.master')
@section('title', 'Trial Balance Report')
@section('content')

<div class="container-fluid py-3">
    <div class="d-flex justify-content-end mb-3">
        <a href="{{ route('modules.reports') }}" class="text-decoration-none">
            <i class="fas fa-arrow-left me-2"></i> Back to Reports
        </a>
    </div>

    <div class="card shadow-sm">
        <div class="card-header bg-primary text-white py-3">
            <h5 class="mb-0"><i class="fas fa-balance-scale me-2"></i> Trial Balance Report</h5>
        </div>

        <div class="card-body">
            @if(session('success'))
                <div class="alert alert-success">{{ session('success') }}</div>
            @endif

            @if($errors->any())
                <div class="alert alert-danger">
                    <ul class="mb-0">
                        @foreach($errors->all() as $error)
                            <li>{{ $error }}</li>
                        @endforeach
                    </ul>
                </div>
            @endif

            <form action="{{ route('modules.reports.trial-balance.generate') }}" method="POST">
                @csrf
                <div class="row mb-3">
                    <div class="col-md-3">
                        <label class="form-label"><strong>From Period</strong></label>
                        <input type="date" class="form-control" name="pfrom" value="{{ old('pfrom', date('Y-m-d')) }}" required>
                    </div>
                    <div class="col-md-3">
                        <label class="form-label"><strong>To Period</strong></label>
                        <input type="date" class="form-control" name="pto" value="{{ old('pto', date('Y-m-d')) }}" required>
                    </div>
                    <div class="col-md-3">
                        <label class="form-label"><strong>Account Type</strong></label>
                        <select class="form-control" name="account_type">
                            <option value="" {{ empty($accountTypeId ?? '') ? 'selected' : '' }}>All Types</option>
                            @foreach($accountTypes as $type)
                                <option value="{{ $type->account_type_id }}" {{ (string)($accountTypeId ?? '') === (string)$type->account_type_id ? 'selected' : '' }}>
                                    {{ $type->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-3">
                        <label class="form-label"><strong>Select Currency</strong></label>
                        <select class="form-control" name="curr" required>
                            <option value="" disabled {{ old('curr', $currencyId ?? null) ? '' : 'selected' }}>Select Currency</option>
                            @foreach($currencies as $currency)
                                <option value="{{ $currency->currency_id }}" {{ old('curr', $currencyId ?? null) == $currency->currency_id ? 'selected' : '' }}>
                                    {{ $currency->currency_name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>

                <div class="d-flex justify-content-end">
                    <button type="submit" class="btn btn-primary me-2">View Report</button>
                    <button type="reset" class="btn btn-secondary">Refresh</button>
                </div>
            </form>

            <hr>

            @php
                $tbRows = $trial['rows'] ?? ($trialBalanceData ?? []);
                $totalDebit = $trial['totalDebit'] ?? ($totalDebit ?? 0);
                $totalCredit = $trial['totalCredit'] ?? ($totalCredit ?? 0);
                $variance = $trial['variance'] ?? (($totalDebit ?? 0) - ($totalCredit ?? 0));
                $balanced = $trial['isBalanced'] ?? (abs($variance) < 0.01);
                $source = $trial['source'] ?? null;
            @endphp

            @if(isset($tbRows))
                <div class="d-flex justify-content-end mb-3 gap-2">
                    <button type="button" class="btn btn-primary" onclick="window.print()">
                        <i class="fas fa-print me-2"></i> Print Report
                    </button>
                    <form action="{{ route('modules.reports.trial-balance.download-pdf') }}" method="POST">
                        @csrf
                        <input type="hidden" name="pfrom" value="{{ old('pfrom', $pfrom ?? date('Y-m-d')) }}">
                        <input type="hidden" name="pto" value="{{ old('pto', $pto ?? date('Y-m-d')) }}">
                        <input type="hidden" name="currencyId" value="{{ old('curr', $currencyId ?? '') }}">
                        <input type="hidden" name="accountTypeId" value="{{ $accountTypeId ?? '' }}">
                        <button type="submit" class="btn btn-success">
                            <i class="fas fa-download me-2"></i> Download PDF
                        </button>
                    </form>
                </div>

                <div class="report-container">
                    <div class="report-header mb-4">
                        <div class="d-flex align-items-center mb-3">
                            <img src="{{ asset('img/logo.png') }}" alt="Logo" style="height: 60px;" class="me-3">
                            <h4 class="mb-0">Trial Balance Statement</h4>
                        </div>
                        <div class="row">
                            <div class="col-md-6">
                                <p class="mb-1"><strong>Date:</strong> {{ date('F j, Y') }}</p>
                            </div>
                            <div class="col-md-6 text-md-end">
                                <p class="mb-1"><strong>From:</strong> {{ $pfrom ?? date('Y-m-d') }} <strong>To:</strong> {{ $pto ?? date('Y-m-d') }}</p>
                            </div>
                        </div>
                        <div class="mt-2 text-muted small">
                            @if($source)
                                Source: {{ $source === 'journal_lines' ? 'Journal Lines (double-entry)' : 'General Journals' }}
                            @endif
                        </div>
                    </div>

                    <div class="row g-3 mb-4">
                        <div class="col-md-4">
                            <div class="card border-left-primary shadow h-100 py-2">
                                <div class="card-body">
                                    <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Total Debit</div>
                                    <div class="h5 mb-0 font-weight-bold text-gray-800">${{ number_format($totalDebit, 2) }}</div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="card border-left-success shadow h-100 py-2">
                                <div class="card-body">
                                    <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Total Credit</div>
                                    <div class="h5 mb-0 font-weight-bold text-gray-800">${{ number_format($totalCredit, 2) }}</div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="card border-left-warning shadow h-100 py-2">
                                <div class="card-body">
                                    <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">Balance Check</div>
                                    <div class="h5 mb-0 font-weight-bold text-gray-800">
                                        {{ $balanced ? 'Balanced' : ('Variance ' . number_format(abs($variance), 2)) }}
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="table-responsive mb-4">
                        <table class="table table-bordered">
                            <thead class="table-light">
                                <tr>
                                    <th>Account Code</th>
                                    <th>Account Name</th>
                                    <th>Debit</th>
                                    <th>Credit</th>
                                    <th>Balance</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($tbRows as $account)
                                    <tr>
                                        <td>{{ $account['code'] }}</td>
                                        <td>{{ $account['name'] }}</td>
                                        <td>{{ number_format($account['debit'], 2) }}</td>
                                        <td>{{ number_format($account['credit'], 2) }}</td>
                                        <td>{{ number_format($account['balance'], 2) }}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="5" class="text-center">No accounts found</td>
                                    </tr>
                                @endforelse
                            </tbody>
                            <tfoot class="table-secondary">
                                <tr>
                                    <td colspan="2" class="text-end"><strong>Total</strong></td>
                                    <td><strong>{{ number_format($totalDebit, 2) }}</strong></td>
                                    <td><strong>{{ number_format($totalCredit, 2) }}</strong></td>
                                    <td><strong>{{ number_format($totalDebit - $totalCredit, 2) }}</strong></td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            @endif
        </div>
    </div>
</div>

@endsection

@section('styles')
<style>
.btn-back {
    text-decoration: none;
    color: #1AB9D9;
    font-weight: 500;
    display: inline-flex;
    align-items: center;
    padding: 5px 15px;
    border-radius: 4px;
    transition: all 0.3s;
}
.btn-back:hover {
    background-color: rgba(26, 185, 217, 0.1);
    text-decoration: none;
}
.card {
    border-radius: 8px;
    overflow: hidden;
    border: none;
    box-shadow: 0 0.5rem 1rem rgba(0, 0, 0, 0.1);
}
.card-header {
    border-bottom: 1px solid rgba(0,0,0,0.1);
    padding: 12px 20px;
}
.table th {
    background-color: #f8f9fa;
}
.report-header {
    border-bottom: 2px solid #dee2e6;
    padding-bottom: 20px;
}
</style>
@endsection