@extends('backend.layouts.app')
@section('backend_title', 'Admin Brand Create')

@section('backend_content')

    <div class="my-4 row">
        <div class="col-lg-12 col-md-12 col-sm-12">
            <div class="card">
                <!-- Card header -->
                <div class="pb-0 card-header">
                    <div class="d-lg-flex justify-content-between">
                        <div>
                            <h5 class="mb-0">Bank Ledger</h5>
                        </div>
                    </div>
                </div>
                <div class="px-0 pb-0 card-body">
                    <form action="{{ route('bank_ladger') }}" method="GET">
                        <div class="row g-3">
                            <div class="col-11 col-md-3 col-lg-2 ms-4">
                                <label>Bank Name</label>
                                <select name="bank_id" class="form-control">
                                    <option value="null">Select any one</option>
                                    @foreach ($bankName as $item)
                                        <option value="{{ $item->id }}"
                                            {{ $item->id == request()->bank_id ? 'selected' : '' }}>{{ $item->bank_name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-11 col-md-3 col-lg-2 ms-4">
                                <label for="date_from">Filter From Date</label>
                                <input type="date" name="date_from" class="form-control"
                                    value="{{ old('date_from', request()->date_from) }}">
                            </div>
                            <div class="col-11 col-md-3 col-lg-2 ms-4">
                                <label for="date_to">Filter To Date</label>
                                <input type="date" name="date_to" class="form-control"
                                    value="{{ old('date_to', request()->date_to) }}">
                            </div>
                            <div class="col-6 col-md-3 col-lg-2 d-flex align-items-end ms-4">
                                <button type="submit" class="btn btn-primary mb-0">Filter</button>
                            </div>
                        </div>
                    </form>

                    <!-- Table responsive wrapper -->
                    <div class="table-responsive mt-4">
                        <table class="table table-hover" id="products-list">
                            <thead>
                                <tr>
                                    <th class="fs-6">Sl No.</th>
                                    <th class="fs-6">Tr. Date</th>
                                    <th class="fs-6">Tr. Number</th>
                                    <th class="fs-6">Bank Name</th>
                                    <th class="fs-6">Tr. Head</th>
                                    <th class="fs-6">Tr. Description</th>
                                    <th class="fs-6">Amount In</th>
                                    <th class="fs-6">Amount Out</th>
                                    <th class="fs-6">Balance</th>
                                </tr>
                            </thead>
                            <tbody>
                                <tr>
                                    <th>Opening Balance</th>
                                    <th colspan="7"></th>
                                    <th class="text-center">{{ number_format($openingBalance, 2, '.', ',') }}</th>
                                </tr>
                                @isset($bankTrList)
                                    @forelse ($bankTrList as $index => $item)
                                        <tr>
                                            <td>{{ $index + 1 }}</td>
                                            <td>{{ $item->tr_date }}</td>
                                            <td>{{ $item->tr_number }}</td>
                                            <td>{{ $item->bank_accounts?->bank_name }}</td>
                                            <td>
                                                {{ $item->expenses && $item->expenses?->id == $item->expense_id
                                                    ? $item->expenses?->head_of_expense
                                                    : ($item->incomes && $item->incomes?->id == $item->income_id
                                                        ? $item->incomes?->head_of_income
                                                        : '') }}
                                            </td>
                                            <td style="width: 30%">
                                                <textarea disabled cols="40" rows="1">{{ $item->note }}</textarea>
                                            </td>
                                            <td class="text-center">{{ number_format($item->amount_in, 2, '.', ',') }}</td>
                                            <td class="text-center">{{ number_format($item->amount_out, 2, '.', ',') }}</td>
                                            <td class="text-center">{{ number_format($item->balance, 2, '.', ',') }}</td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="9" class="text-left">Data Not Found!!</td>
                                        </tr>
                                    @endforelse
                                @endisset

                                <tr>
                                    <th colspan="5"></th>
                                    <th class="text-end">Total : </th>
                                    <th class="text-center">{{ number_format($totalIn, 2, '.', ',') }}</th>
                                    <th class="text-center">{{ number_format($totalOut, 2, '.', ',') }}</th>
                                    <th class="text-center">
                                        @if ($mainOpeningBalance)
                                            {{ number_format($mainOpeningBalance, 2, '.', ',') }}
                                        @else
                                            0.00
                                        @endif
                                    </th>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection

@section('beackend_scripts')

@endsection