@php use App\Models\Expense; @endphp
@php @endphp
@extends('admin.layouts.app')
@section('title',get_setting('site_name').' Accounts Summary')
@section('content')
    @php
        if (request('date')==null){



            $expense = Expense::sum('amount') ;
            $income = \App\Models\Income::sum('amount') ;
            $net_profit=$income-$expense;

        }else{


            $expense = Expense::whereDate('created_at', '>=', date('Y-m-d', strtotime(explode(" to ", request('date'))[0])))->whereDate('created_at', '<=', date('Y-m-d', strtotime(explode(" to ", request('date'))[1])))->sum('amount') ;
            $income = \App\Models\Income::whereDate('created_at', '>=', date('Y-m-d', strtotime(explode(" to ", request('date'))[0])))->whereDate('created_at', '<=', date('Y-m-d', strtotime(explode(" to ", request('date'))[1])))->sum('amount') ;
             $net_profit=$income-$expense;
        }
    @endphp
    <div class="aiz-titlebar text-left mt-2 mb-3">
        <div class="row align-items-center">
            <div class="col-md-12">
                <h1 class="h3">{{__('Accounts Summary')}} </h1>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-12 col-lg-12 col-xl-10 mx-auto">
            <div class="card">
                <form action="">
                    <div class="card-header row">


                        <div class="col ">
                            <h5 class="mb-md-0 h6">{{ __('Accounts Summary ') }} @if(request('date')!=null)
                                    {{__('On ')}}{{request('date')}}
                                @endif</h5>
                        </div>

                        <div class="col-lg-2 no-print">
                            <div class="form-group mb-0">
                                <input type="text" class="aiz-date-range form-control" value="" name="date"
                                       placeholder="{{ __('Filter by date') }}" data-format="DD-MM-Y"
                                       data-separator=" to "
                                       data-advanced-range="true" autocomplete="off">
                            </div>
                        </div>
                        <div class="col-auto no-print">
                            <div class="form-group mb-0">
                                <button type="submit" class="btn btn-primary">{{ __('Filter') }}</button>
                            </div>
                        </div>

                    </div>
                </form>

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

                        <thead>

                        <tr>
                            <th>{{__('Description')}}</th>
                            <th>{{__('Cost Amount')}}</th>
                        </tr>
                        </thead>
                        <tbody>


                        <tr>
                            <td>{{__('Total Expense')}}:</td>
                            <td>{{ $expense}}</td>
                        </tr>

                        <tr>
                            <td>{{__('Total Income')}}:</td>
                            <td>{{ $income}}</td>
                        </tr>

                        <tr>
                            <th>{{__('Net Profit')}}</th>
                            <th>{{$net_profit}}</th>
                        </tr>


                        <tr>
                            <th>{{__('Business Status')}}</th>
                            <th>
                                @if($income > $expense)
                                    <p class="text-success">Profit</p>

                                @elseif($income ==$expense)
                                    <p class="text-info">None</p>
                                @else
                                    <p class="text-danger">Lose</p>
                                @endif


                            </th>
                        </tr>


                        </tbody>
                    </table>

                    <button class="btn btn-primary float-right mt-3 mb-3 print-button" onclick="window.print()"><i
                            class="fas fa-print"></i></button>

                </div>
            </div>
        </div>

    </div>

@endsection