@extends('layouts.master')

@section('page_title', 'General Ledger Report')

@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1>General Ledger Report</h1>
        <div>
            <a href="#" onclick="window.print()" class="btn btn-secondary">
                <i class="fas fa-print"></i> Print
            </a>
            <a href="{{ route('reports.general-ledger', array_merge(request()->all(), ['format' => 'pdf'])) }}" class="btn btn-danger">
                <i class="fas fa-file-pdf"></i> PDF
            </a>
        </div>
    </div>

    <!-- Date Filter Form -->
    <div class="card mb-4 no-print">
        <div class="card-body">
            <form method="GET" action="{{ route('reports.general-ledger') }}" class="row g-3">
                <div class="col-md-3">
                    <label for="start_date" class="form-label">Start Date</label>
                    <input type="date" class="form-control" id="start_date" name="start_date" 
                           value="{{ request('start_date', date('Y-01-01')) }}">
                </div>
                <div class="col-md-3">
                    <label for="end_date" class="form-label">End Date</label>
                    <input type="date" class="form-control" id="end_date" name="end_date" 
                           value="{{ request('end_date', date('Y-m-d')) }}">
                </div>
                <div class="col-md-3">
                    <label for="account_id" class="form-label">Account (Optional)</label>
                    <select class="form-select" id="account_id" name="account_id">
                        <option value="">All Accounts</option>
                        @if(isset($accounts))
                            @foreach($accounts as $account)
                                <option value="{{ $account->id }}" {{ request('account_id') == $account->id ? 'selected' : '' }}>
                                    {{ $account->name }} ({{ $account->account_code }})
                                </option>
                            @endforeach
                        @endif
                    </select>
                </div>
                <div class="col-md-3 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary">Generate Report</button>
                </div>
            </form>
        </div>
    </div>

    <!-- Report Content -->
    <div class="card">
        <div class="card-header">
            <h5 class="mb-0">
                General Ledger Report<br>
                <small class="text-muted">
                    Period: {{ \Carbon\Carbon::parse($startDate ?? date('Y-01-01'))->format('M j, Y') }} 
                    to {{ \Carbon\Carbon::parse($endDate ?? date('Y-m-d'))->format('M j, Y') }}
                    @if(request('account_id'))
                        | Account: {{ $selectedAccount->name ?? 'Selected Account' }}
                    @endif
                </small>
            </h5>
        </div>
        <div class="card-body">
            @if(isset($ledgerData) && $ledgerData->count() > 0)
                @foreach($ledgerData as $account)
                    <div class="account-section mb-5">
                        <!-- Account Header -->
                        <div class="d-flex justify-content-between align-items-center bg-light p-3 rounded">
                            <div>
                                <h5 class="mb-0">{{ $account->name }}</h5>
                                <small class="text-muted">
                                    Account Code: {{ $account->account_code }} | 
                                    Type: {{ $account->accountType->name ?? 'N/A' }}
                                </small>
                            </div>
                            <div class="text-end">
                                <div class="text-muted small">Opening Balance</div>
                                <h6 class="mb-0">{{ number_format($account->opening_balance ?? 0, 2) }}</h6>
                            </div>
                        </div>

                        <!-- Transaction Details -->
                        @if(isset($account->transactions) && $account->transactions->count() > 0)
                            <div class="table-responsive mt-3">
                                <table class="table table-sm table-hover">
                                    <thead class="table-secondary">
                                        <tr>
                                            <th>Date</th>
                                            <th>Journal Entry</th>
                                            <th>Description</th>
                                            <th class="text-end">Debit</th>
                                            <th class="text-end">Credit</th>
                                            <th class="text-end">Balance</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $runningBalance = $account->opening_balance ?? 0;
                                        @endphp
                                        
                                        @foreach($account->transactions as $transaction)
                                            @php
                                                $debitAmount = $transaction->debit_amount ?? 0;
                                                $creditAmount = $transaction->credit_amount ?? 0;
                                                
                                                // Calculate running balance based on account type
                                                $normalBalance = $account->accountType->normal_balance ?? 'debit';
                                                if ($normalBalance === 'debit') {
                                                    $runningBalance += $debitAmount - $creditAmount;
                                                } else {
                                                    $runningBalance += $creditAmount - $debitAmount;
                                                }
                                            @endphp
                                            
                                            <tr>
                                                <td>{{ \Carbon\Carbon::parse($transaction->entry_date)->format('M j, Y') }}</td>
                                                <td>
                                                    <span class="badge bg-primary">
                                                        JE-{{ $transaction->journal_entry_id }}
                                                    </span>
                                                </td>
                                                <td>
                                                    <div>{{ $transaction->journal_entry_description ?? 'N/A' }}</div>
                                                    @if($transaction->description)
                                                        <small class="text-muted">{{ $transaction->description }}</small>
                                                    @endif
                                                </td>
                                                <td class="text-end">
                                                    @if($debitAmount > 0)
                                                        {{ number_format($debitAmount, 2) }}
                                                    @else
                                                        -
                                                    @endif
                                                </td>
                                                <td class="text-end">
                                                    @if($creditAmount > 0)
                                                        {{ number_format($creditAmount, 2) }}
                                                    @else
                                                        -
                                                    @endif
                                                </td>
                                                <td class="text-end">
                                                    <span class="{{ $runningBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                                        {{ number_format($runningBalance, 2) }}
                                                    </span>
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot class="table-light">
                                        <tr>
                                            <th colspan="3">Totals for {{ $account->name }}</th>
                                            <th class="text-end">{{ number_format($account->total_debits ?? 0, 2) }}</th>
                                            <th class="text-end">{{ number_format($account->total_credits ?? 0, 2) }}</th>
                                            <th class="text-end">
                                                <span class="{{ $runningBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                                    {{ number_format($runningBalance, 2) }}
                                                </span>
                                            </th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        @else
                            <div class="alert alert-info mt-3">
                                <i class="fas fa-info-circle"></i> No transactions found for this account in the selected period.
                            </div>
                        @endif
                    </div>
                @endforeach
                
                <!-- Summary Section -->
                <div class="row mt-4">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header">
                                <h6 class="mb-0">Report Summary</h6>
                            </div>
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-md-3">
                                        <div class="text-center">
                                            <h4 class="text-primary">{{ $ledgerData->count() }}</h4>
                                            <p class="mb-0">Accounts with Activity</p>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="text-center">
                                            <h4 class="text-success">{{ number_format($ledgerData->sum('total_debits') ?? 0, 2) }}</h4>
                                            <p class="mb-0">Total Debits</p>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="text-center">
                                            <h4 class="text-danger">{{ number_format($ledgerData->sum('total_credits') ?? 0, 2) }}</h4>
                                            <p class="mb-0">Total Credits</p>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="text-center">
                                            @php
                                                $totalTransactions = $ledgerData->sum(function($account) {
                                                    return $account->transactions->count() ?? 0;
                                                });
                                            @endphp
                                            <h4 class="text-info">{{ $totalTransactions }}</h4>
                                            <p class="mb-0">Total Transactions</p>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            @else
                <div class="alert alert-warning">
                    <i class="fas fa-exclamation-triangle"></i> 
                    <strong>No Data Found</strong><br>
                    No transactions were found for the selected criteria. Try adjusting the date range or account filter.
                </div>
            @endif
        </div>
    </div>
</div>

<style>
@media print {
    .btn, .no-print {
        display: none !important;
    }
    
    .card {
        border: none !important;
        box-shadow: none !important;
    }
    
    .card-header {
        background: none !important;
        border: none !important;
    }
    
    .account-section {
        page-break-inside: avoid;
    }
    
    body {
        -webkit-print-color-adjust: exact;
    }
}

.account-section:not(:last-child) {
    border-bottom: 2px solid #dee2e6;
    padding-bottom: 2rem;
}
</style>
@endsection