@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-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">Cash Ledger</h5>
                        </div>
                    </div>
                </div>
                <div class="px-0 pb-0 card-body">
                    <form action="{{ route('cash_ladger') }}" method="GET">
                        <div class="row">
                            <div class="col-lg-2 col-md-4 col-11 mb-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-lg-2 col-md-4 col-11 mb-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-lg-1 col-md-2 col-11 d-flex align-items-end mb-2 ms-4">
                                <button type="submit" class="btn btn-primary mb-0">Filter</button>
                            </div>
                        </div>
                    </form>
                    <div class="table-responsive">
                        <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">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="6"></th>
                                    <th class="text-center">{{ number_format($openingBalance, 2, '.', ',') }}</th>
                                </tr>
                                @isset($transactions)
                                    @forelse ($transactions as $index=> $item)
                                        <tr>
                                            <td>{{ $index + 1 }}</td>
                                            <td>{{ $item->tr_date }}</td>
                                            <td>{{ $item->tr_number }}</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="55" 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 class="text-left">Data Not Found!!</td>
                                        </tr>
                                    @endforelse
                                @endisset

                                <tr>
                                    <th colspan="4"></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 ($running_balance)
                                            {{ number_format($running_balance, 2, '.', ',') }}
                                        @else
                                            0.00
                                        @endif
                                    </th>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection