@extends('admin.layouts.app')
@section('title',get_setting('site_name').' Expense Report')
@section('content')
    <div class="row">
        <div class="col-md-12 col-lg-12 col-xl-10 mx-auto">
            <div class="card">
                <form action="" method="GET">
                    <div class="card-header">
                        <div class="row ">


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

                            <div class="col-md-3 ml-auto no-print">
                                <select class="form-control" name="warehouse_id" id="">
                                    <option value="">{{__('Select Branch')}}</option>
                                    @foreach($branches as $branch)
                                        <option value="{{$branch->id}}">{{$branch->name}}</option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="col-md-3 no-print">
                                <div class="form-group mb-0">

                                    <div>
                                        <div class="input-daterange input-group" id="date-range">
                                            <input type="date" class="form-control" name="start"
                                                   placeholder="Start Date"/>
                                            <input type="date" class="form-control" name="end" placeholder="End Date"/>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-2 no-print">
                                <button class="btn btn-md btn-primary" type="submit"><i class="fas fa-search"></i>
                                    {{ __('Search') }}
                                </button>
                            </div>
                        </div>
                    </div>
                </form>
                <div class="card-body">
                    @if($expenses!=null)
                        <table class="table aiz-table mb-0">
                            <h5 class="text-center mb-2">Expense Report On {{$start}} to {{$end}}</h5>
                            <thead>
                            <tr>


                                <th>{{__('Date & Time')}}</th>
                                <th data-breakpoints="xs-m">{{__('Description')}}</th>
                                <th data-breakpoints="sm">{{__('Branch')}}</th>
                                <th data-breakpoints="sm">{{__('Payment By')}}</th>
                                <th data-breakpoints="sm">{{__('Bank Account')}}</th>
                                <th>{{__('Amount')}}</th>
                            </tr>
                            </thead>
                            <tbody>
                            @php $total=0; @endphp
                            @foreach($expenses as $key => $bank)
                                @php $total+=$bank->amount @endphp
                                <tr>
                                    <td>
                                        {{date('F d, Y , h:i:s A',strtotime($bank->created_at))}}
                                    </td>
                                    <td>{{$bank->description}}</td>

                                    <td>
                                        @if($bank->warehouse!=null)
                                            {{$bank->warehouse->name}}
                                        @endif
                                    </td>
                                    <td>
                                        {{$bank->payment_method}}
                                    </td>
                                    <td>
                                        @if($bank->bank!=null)
                                            {{$bank->bank->name}}{{'('.$bank->bank->account_no.')'}}
                                        @endif

                                    </td>
                                    <td>
                                        {{$bank->amount}}
                                    </td>
                                </tr>

                            @endforeach
                            <tr>
                                <td class="text-right" colspan="5">Total</td>
                                <td>{{$total}}</td>
                            </tr>

                            <tr>

                                <td colspan="6">{{__('In words: ')}}{{Inwords($total)}}{{__(' Taka Only')}}</td>
                            </tr>
                            </tbody>
                        </table>
                        <button class="btn btn-primary float-right no-print" onclick="window.print()"><i
                                class="fas fa-print"></i>
                        </button>
                    @endif
                </div>

            </div>

        </div>
    </div>

@endsection