@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: Trial Balance</h4>
                        <p class="f-m-light mt-1">Page for Trial Balance</p>
                    </div>
                    <div class="">
                        <form action="{{ route('accounting.report.trial-balance.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.trial-balance.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.trial-balance.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>Account Code</th>
                                <th>Account Name</th>
                                <th>Opening Balance</th>
                                <th>Total Debit</th>
                                <th>Total Credit</th>
                                <th>Ending Balance</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($data as $item)
                                <tr>
                                    <td class="d-none"></td>
                                    <td>{{ $item['account_code'] }}</td>
                                    <td>{{ $item['account_name'] }}</td>
                                    <td>{{ number_format($item['opening_balance'], 2) }}</td>
                                    <td>{{ number_format($item['debit'], 2) }}</td>
                                    <td>{{ number_format($item['credit'], 2) }}</td>
                                    <td>{{ number_format($item['ending_balance'], 2) }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <div class="row">
        <div class="card">
            <div class="card-body">
                <div class="d-flex justify-content-end">
                    <div class="me-5">
                        <h5>Total Debit: {{ number_format($totalDebit, 2) }}</h5>
                    </div>
                    <div>
                        <h5>Total Credit: {{ number_format($totalCredit, 2) }}</h5>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

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