@php use App\Models\warehouse; @endphp
@extends('admin.layouts.app')
@section('title',get_setting('site_name').' Expense')
@section('content')
    <div class="aiz-titlebar text-left mt-2 mb-3">
        <div class="row align-items-center">
            <div class="col-md-12">
                <h1 class="h3">{{__('All Expenses')}}</h1>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-8">
            <div class="card">

                <div class="card-body">
                    <table class="table aiz-table mb-0">

                        <thead>
                        <tr class="text-right">
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th class="text-right"></th>
                            @php
                                if (auth()->user()->user_type=='admin'){
                                     $ex=\App\Models\Expense::sum('amount');
                                }else{
                                      $ex=\App\Models\Expense::where('warehouse_id',auth()->user()->warehouse_id)->sum('amount');

                                    }
                            @endphp
                            <th>Total Expense : {{$ex}}</th>

                        </tr>
                        <tr>
                            <th data-breakpoints="lg">#</th>
                            <th>Date</th>
                            <th>{{__('Description')}}</th>
                            <th>Warehouse/Branch</th>
                            <th>{{__('Cost')}}</th>
                            <th>{{__('Payment Method')}}</th>
                            <th data-breakpoints="lg" class="text-right">{{__('Options')}}</th>
                        </tr>
                        </thead>
                        <tbody>
                        @php $cities=\App\Models\Expense::paginate(15);  @endphp
                        @foreach($cities as $key => $city)
                            @if(auth()->user()->user_type=='admin')
                                <tr>
                                    <td>{{ ($key+1) + ($cities->currentPage() - 1)*$cities->perPage() }}</td>
                                    <td>
                                        <i class="fas fa-calendar-check fs-18"
                                           style="color: #1a7c00"></i>&nbsp;{{date('d F Y',strtotime($city->created_at))}}

                                    </td>
                                    <td>{{ $city->description }}</td>
                                    <td>{{warehouse::where('id',$city->warehouse_id)->value('name')}}</td>
                                    <td>{{ $city->amount}}</td>
                                    <td>{{ $city->payment_method}}</td>

                                    <td class="text-right">

                                        <a href="#"
                                           class="btn btn-danger  btn-sm confirm-delete"
                                           data-href="{{route('expensedelete', $city->id)}}" title="{{ __('Delete') }}">
                                            <i class="fas fa-trash"></i>
                                        </a>
                                    </td>
                                </tr>
                            @else
                                @if($city->warehouse_id==auth()->user()->warehouse_id)
                                    <tr>
                                        <td>{{ ($key+1) + ($cities->currentPage() - 1)*$cities->perPage() }}</td>
                                        <td>
                                            <i class="fas fa-calendar-check fs-18"
                                               style="color: #1a7c00"></i>&nbsp;{{date('d F Y',strtotime($city->created_at))}}

                                        </td>
                                        <td>{{ $city->description }}</td>
                                        <td>{{warehouse::where('id',$city->warehouse_id)->value('name')}}</td>
                                        <td>{{ $city->amount }}</td>
                                        <td>{{ $city->payment_method}}</td>

                                        <td class="text-right">

                                            <a href="#"
                                               class="btn btn-danger btn-icon btn-circle btn-sm confirm-delete"
                                               data-href="{{route('expensedelete', $city->id)}}"
                                               title="{{ __('Delete') }}">
                                                <i class="fas fa-trash"></i>
                                            </a>
                                        </td>
                                    </tr>
                                @endif
                            @endif
                        @endforeach
                        </tbody>
                    </table>
                    <div class="aiz-pagination">
                        {{ $cities->appends(request()->input())->links() }}
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card">
                <div class="card-header">
                    <h5 class="mb-0 h6">{{ __('Add New Expense') }}</h5>
                </div>
                <div class="card-body">
                    <form action="{{ route('expense') }}" method="POST">
                        @csrf

                        <div class="form-group mb-3">
                            <label for="name">{{__('Warehouse/Branch')}}</label>
                            <select name="warehouse_id" id="" class="form-control">
                                @foreach(warehouse::where('status',1)->get() as $warehouse )
                                    @if(auth()->user()->user_type=='admin')
                                        <option value="{{$warehouse->id}}"
                                                @if($warehouse->id==auth()->user()->warehouse_id) selected @endif>{{$warehouse->name}}</option>
                                    @else
                                        @if($warehouse->id==auth()->user()->warehouse_id)
                                            <option value="{{$warehouse->id}}"
                                                    @if($warehouse->id==auth()->user()->warehouse_id) selected @endif>{{$warehouse->name}}</option>
                                        @endif
                                    @endif
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group mb-3">
                            <label for="name">{{__('Description')}}</label>
                            <input type="text" placeholder="{{__('Description')}}" name="description"
                                   class="form-control" required>
                        </div>


                        <div class="form-group mb-3">
                            <label for="name">{{__('Cost')}}</label>
                            <input type="number" min="0" step="0.01" placeholder="{{__('Cost')}}" name="amount"
                                   class="form-control" required>
                        </div>
                        <div class="form-group mb-3">
                            <label for="name">{{__('Payment Method')}}</label>
                            <select name="payment" id="payement"
                                    class="form-control" required onchange="gateway_info()">
                                <option value="">Please Select Payment Method</option>
                                <option value="Bank">Bank</option>
                                {{--                                <option value="Cash">Cash</option>--}}
                            </select>
                        </div>

                        <div class="form-group mb-3" id="Bank_show">
                            <label for="name">{{__('Bank Details')}}</label>
                            <select name="payment_details"
                                    class="form-control">
                                <option value="">Please Select Bank</option>
                                @foreach(\App\Models\BankAccount::where('status',1)->get() as $bank)
                                    <option value="{{$bank->id}}">{{$bank->account_no}}
                                        &nbsp;({{$bank->account_type}})
                                    </option>

                                @endforeach
                            </select>
                        </div>

                        <div class="form-group mb-3 text-right">
                            <button type="submit" class="btn btn-primary">{{__('Save')}}</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('modal')
    @include('modals.delete_modal')
@endsection

@section('script')
    <script !src="">
        $('#Bank_show').hide();

        function gateway_info() {
            var bank = $('#payement').val();
            if (bank == 'Bank') {
                $('#Bank_show').show();
            } else {
                $('#Bank_show').hide();
            }
        }
    </script>
@endsection