@extends('admin.layouts.app')
@section('title',get_setting('site_name').' Bank Statement')
@section('content')

    <div class="aiz-titlebar text-left mt-2 mb-3">
        <div class=" align-items-center">
            <h1 class="h3">{{__('Bank Statement')}}</h1>
        </div>
    </div>

    <div class="row">
        <div class="col-md-12 col-lg-12 col-xl-10 mx-auto">
            <div class="card">
                <form action="{{ route('bank.statements') }}" method="GET">
                    <div class="card-header">
                        <div class="row">


                            <div class="col text-center text-md-left">
                                <h5 class="mb-md-0 h6">{{ __('All Transaction') }}</h5>
                            </div>

                            <div class="col-md-3 ml-auto">
                                <select id="demo-ease"
                                        class="form-control form-control-sm aiz-selectpicker mb-2 mb-md-0"
                                        name="bank_id">
                                    <option value="">{{ __('Choose Bank Account') }}</option>
                                    @foreach (\App\Models\BankAccount::all() as $bank_info)
                                        <option value="{{ $bank_info->id }}">
                                            {{ $bank_info->account_no }} {{__('-')}}{{$bank_info->account_type}}
                                        </option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="col-md-2 ml-auto">
                                <select id="demo-ease"
                                        class="form-control form-control-sm aiz-selectpicker mb-2 mb-md-0"
                                        name="warehouse_id">
                                    <option value="">{{ __('Choose Warehouse') }}</option>
                                    @foreach (\App\Models\warehouse::where('status',1)->get() as $warehouse)
                                        <option value="{{ $warehouse->id }}">
                                            {{ $warehouse->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group mb-0">
                                    <input type="text" class="form-control form-control-sm aiz-date-range" id="search"
                                           name="date_range" @isset($date_range) value="{{ $date_range }}"
                                           @endisset placeholder="{{ __('Daterange') }}">
                                </div>
                            </div>
                            <div class="col-md-2">
                                <button class="btn btn-md btn-primary" type="submit"><i class="fas fa-filter"></i>
                                    {{ __('Filter') }}
                                </button>
                            </div>
                        </div>
                    </div>
                </form>
                <div class="card-body">

                    <table class="table aiz-table mb-0">
                        <thead>
                        <tr>


                            <th>{{__('Date & Time')}}</th>
                            <th data-breakpoints="xs-m">{{__('Description')}}</th>
                            <th data-breakpoints="sm">{{__('DR')}}</th>
                            <th data-breakpoints="sm">{{__('CR')}}</th>
                            <th>{{__('Balance')}}</th>
                        </tr>
                        </thead>
                        <tbody>
                        <tr>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td>{{$balance}}</td>
                        </tr>
                        @foreach($bank_statment as $key => $bank)
                            @if ($bank != null)
                                <tr>
                                    <td>
                                        {{date('F d, Y , h:i:s A',strtotime($bank->created_at))}}
                                    </td>
                                    <td>{{$bank->description}}</td>

                                    <td>
                                        @if($bank->dr!=0)
                                            {{$bank->dr}}
                                        @endif
                                    </td>
                                    <td>  @if($bank->cr!=0)
                                            {{$bank->cr}}
                                        @endif</td>
                                    <td>{{$bank->balance}}</td>
                                </tr>
                            @endif
                        @endforeach
                        </tbody>
                    </table>
                    <div class="aiz-pagination mt-4">
                        {{ $bank_statment->links() }}
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection