@extends('layouts.app')

@section('content')
    <div class="row">
        <div class="card">
            <div class="card-header">
                <div class="d-flex justify-content-between align-items-center">
                    <div class="">
                        <h4>Report: General Ledger</h4>
                        <p class="f-m-light mt-1">Page for General Ledger</p>
                    </div>
                    <div class="">
                        <form action="{{ route('accounting.report.general-ledger-all.export') }}" method="POST">
                            @csrf
                            <input type="hidden" name="start_date" value="{{ request('start_date') }}">
                            <input type="hidden" name="end_date" value="{{ request('end_date') }}">
                            <button type="submit" class="btn btn-success">
                                <i class="bi bi-excel"></i>
                                Export to Excel
                            </button>
                        </form>
                    </div>
                </div>
            </div>
            <div class="card-body">
                <div class="">
                    <form action="{{ route('accounting.report.general-ledger-all.index') }}" method="GET">
                        <div class="row g-3">
                            <div class="col-md-3">
                                <label for="start_date" class="form-label">Start Date</label>
                                <input class="form-control" type="date" name="start_date" id="start_date"
                                    value="{{ request('start_date', date('Y-m-01')) }}" required>
                            </div>
                            <div class="col-md-3">
                                <label for="end_date" class="form-label">End Date</label>
                                <input class="form-control" type="date" name="end_date" id="end_date"
                                    value="{{ request('end_date', date('Y-m-t')) }}" required>
                            </div>
                            <div class="col-md-3 align-self-end">
                                <button type="submit" class="btn btn-primary">Filter</button>
                                <a href="{{ route('accounting.report.general-ledger-all.index') }}"
                                    class="btn btn-secondary">Reset</a>
                            </div>
                        </div>
                    </form>
                </div>
                <div class="table-responsive theme-scrollbar mt-3">
                    <table class="table table-hover table-bordered table-striped" id="basic-1">
                        <thead>
                            <tr class="bg-light-primary text-dark">
                                <th class="d-none"></th>
                                <th>Journal No</th>
                                <th>Date</th>
                                <th>Account Code</th>
                                <th>Account Name</th>
                                <th>Description</th>
                                <th>Debit</th>
                                <th>Credit</th>
                                <th>Ending</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($journalEntryDetails as $data)
                                @foreach ($data as $entry)
                                    <tr>
                                        <td class="d-none">{{ $entry['id'] }}</td>
                                        <td>{{ $entry['journal_no'] }}</td>
                                        <td>{{ $entry['date'] }}</td>
                                        <td>{{ $entry['account_code'] }}</td>
                                        <td>{{ $entry['account_name'] }}</td>
                                        <td>{{ $entry['description'] }}</td>
                                        <td>{{ number_format($entry['debit'], 2, ',', '.') }}</td>
                                        <td>{{ number_format($entry['credit'], 2, ',', '.') }}</td>
                                        <td>{{ number_format($entry['ending'], 2, ',', '.') }}</td>
                                    </tr>
                                @endforeach
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('js')
    <script>
        $(document).ready(function() {
            $('#basic-1').DataTable({
                // show all data without limit
                "lengthMenu": [
                    [-1],
                    ["All"]
                ],
                "order": [
                    [3, "asc"],
                    [1, "asc"],
                    [2, "asc"]
                ],
            });
        });
    </script>
@endsection