@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: Journal Inquiry</h4>
                        <p class="f-m-light mt-1">Page for Journal Inquiry</p>
                    </div>
                    <div class="">
                        <form action="{{ route('accounting.report.journal-inquiry.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.journal-inquiry.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.journal-inquiry.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>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($journalEntries as $journalEntry)
                                @foreach ($journalEntry->details as $detail)
                                    <tr>
                                        <td class="d-none">{{ $detail->id }}</td>
                                        <td>{{ $journalEntry->no }}</td>
                                        <td>{{ $journalEntry->date }}</td>
                                        <td>{{ $detail->coa->code }}</td>
                                        <td>{{ $detail->coa->name }}</td>
                                        <td>{{ $detail->description }}</td>
                                        <td>{{ number_format($detail->debit, 2, ',', '.') }}</td>
                                        <td>{{ number_format($detail->credit, 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"]
                ]
            });
        });
    </script>
@endsection