@extends('layouts.master')
@section('title', 'Account Ledger Report')

@push('css')
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
@endpush

@section('content')
@include('partials.header')
@include('partials.sidebar')

<main class="app-content">
    <div class="app-title">
        <div>
            <h1><i class="fa fa-book"></i> Ledger Report</h1>
        </div>
        <ul class="app-breadcrumb breadcrumb">
            <li class="breadcrumb-item"><i class="fa fa-home fa-lg"></i></li>
            <li class="breadcrumb-item">Accounts</li>
            <li class="breadcrumb-item active">Ledger</li>
        </ul>
    </div>

    <div class="row">
        <div class="col-md-12">
            <div class="tile">
                <h3 class="tile-title">Ledger Filter</h3>
                <div class="tile-body">
                    <form method="POST" action="{{ route('account.report.filter') }}">
                        @csrf
                        <div class="row">
                            <div class="form-group col-md-3">
                                <label>From Date</label>

<input type="date" name="fromDate" class="form-control" value="{{ request('fromDate', date('Y-m-01')) }}" required>
                            </div>
                            <div class="form-group col-md-3">
                                <label>To Date</label>
<input type="date" name="toDate" class="form-control" value="{{ request('toDate', date('Y-m-d')) }}" required>
                            </div>
                            <div class="form-group col-md-4">
                                <label>Account</label>
                                <select name="account_id" class="form-control select2 border" required>
                                    <option value="">-- Select Account --</option>
                                    @foreach($accounts as $acc)
                                        <option value="{{ $acc->Account_ID }}" {{ request('account_id') == $acc->Account_ID ? 'selected' : '' }}>
                                            {{ strtoupper($acc->Account_Title) }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="form-group col-md-2">
                                <label>&nbsp;</label>
                                <button type="submit" class="btn btn-primary form-control">Generate</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            @isset($data)
                <div class="mb-3 text-end">
                    <a href="{{ route('account.index') }}" class="btn btn-secondary">Back</a>
                    <button onclick="window.print()" class="btn btn-dark">Print</button>

                    <a href="{{ route('account.report.export.pdf', [
                        'fromDate'   => request('fromDate'),
                        'toDate'     => request('toDate'),
                        'account_id' => request('account_id')
                    ]) }}" class="btn btn-danger">Export PDF</a>

                    <a href="{{ route('account.report.export.excel', [
                        'fromDate'   => request('fromDate'),
                        'toDate'     => request('toDate'),
                        'account_id' => request('account_id')
                    ]) }}" class="btn btn-success">Export To Excel</a>

                    <a href="#" class="btn btn-info">Crystal Report</a>
                </div>

                <div class="tile printableArea">
                    @if(count($data) > 0)
                        <div class="text-center mb-4">
                            <h5 class="mb-1">{{ $data[0]->Account_Title }}</h5>
                            <strong>{{ $data[0]->DatePeriod }}</strong>
                        </div>
                    @endif

                    <div class="table-responsive">
                        <table class="table table-bordered table-striped table-sm">
                            <thead class="thead-dark">
                                <tr>
                                    <th>Voucher</th>
                                    <th>Date</th>
                                    <th>Remarks</th>
                                    <th>Site</th>
                                    <th>Other Account</th>
                                    <th class="align-right">Debit</th>
                                    <th class="align-right">Credit</th>
                                    <th class="align-right">Cl. Balance</th>
                                </tr>
                            </thead>
                         <tbody>
    @php
        $balance = floatval($data[0]->OpeningBalance ?? 0);
        $totalDebit = 0;
        $totalCredit = 0;
    @endphp

    {{-- ✅ New: Opening Balance row --}}
    <tr class="fw-bold text-primary">
        <td colspan="7">Opening Balance</td>
        <td class="align-right">
            {{ $balance < 0 ? '(' . number_format(abs($balance), 0) . ')' : number_format($balance, 0) }}
        </td>
    </tr>

    {{-- ✅ Existing detail rows --}}
    @foreach($data as $row)
        @php
            $amount = floatval($row->Amount);
            $balance += $amount;
            if ($amount > 0) $totalDebit += $amount;
            if ($amount < 0) $totalCredit += abs($amount);
        @endphp
        <tr>
            <td>{{ $row->Voucher ?? '' }}</td>
            <td>{{ \Carbon\Carbon::parse($row->Voucher_Date)->format('d-m-Y') }}</td>
            <td>{{ $row->Remarks }}</td>
            <td>{{ $row->Cheque_No }}</td>
            <td>{{ $row->Other_Account ?? 'N/A' }}</td>
            <td class="align-right">{{ $amount > 0 ? number_format($amount, 0) : '' }}</td>
            <td class="align-right">{{ $amount < 0 ? number_format(abs($amount), 0) : '' }}</td>
            <td class="align-right">
                {{ $balance < 0 ? '(' . number_format(abs($balance), 0) . ')' : number_format($balance, 0) }}
            </td>
        </tr>
    @endforeach

    {{-- ✅ Totals row remains unchanged --}}
    <tr class="fw-bold">
        <td colspan="5" class="align-right">Totals</td>
        <td class="align-right">{{ number_format($totalDebit, 0) }}</td>
        <td class="align-right">{{ number_format($totalCredit, 0) }}</td>
        <td class="align-right">
            {{ $balance < 0 ? '(' . number_format(abs($balance), 0) . ')' : number_format($balance, 0) }}
        </td>
    </tr>
</tbody>
                        </table>
                    </div>
                </div>
            @endisset
        </div>
    </div>
</main>

@push('js')
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script>
    $(document).ready(function () {
        $('.select2').select2({ width: '100%' });
    });
</script>
@endpush

<style>
    .table, .table th, .table td {
        font-size: 9pt !important;
    }

    .align-right {
        text-align: right !important;
    }

    @media print {
        body * {
            visibility: hidden;
        }
        .printableArea, .printableArea * {
            visibility: visible;
        }
        .printableArea {
            position: absolute;
            left: 0;
            top: 0;
            width: 100%;
        }
    }
</style>
@endsection