@extends('layouts.app')
@section('content')

@include('layouts.top-header', [
'title' => __($businessLabelTitleCase . ' Monthly Revenue Report'),
'class' => 'col-lg-7'
])



<div class="container-fluid mt--6 mb-5">
    <div class="row">
        <div class="col">
            <div class="card">
                <div class="card-header border-0">
                    <span class="h3">{{__($businessLabelTitleCase . ' Monthly Revenue Report')}}</span>
                </div>

                <form action="{{url('/admin/report/business/revenue')}}" method="post" class="ml-4" id="filter_revene_form">
                    @csrf
                    <div class="row rtl-date-filter-row">
                        <div class="form-group col-3">
                            <input type="text" id="filter_date" value="{{$pass}}" name="filter_date" class="form-control" placeholder="{{__('-- Select Date --')}}">

                            @if($errors->any())
                            <h4 class="text-center text-red mt-2">{{$errors->first()}}</h4>
                            @endif
                        </div>
                        <div class="form-group col-3">
                            <button type="submit" id="filter_btn" class="btn btn-primary rtl-date-filter-btn">{{ __('Apply') }}</button>
                        </div>
                    </div>
                </form>

                <div class="table-responsive">
                    <table class="table align-items-center table-flush" id="dataTable" class="dataTable">
                        <thead class="thead-light">
                            <tr>
                                <th>#</th>
                                <th scope="col" class="sort">{{__('Image')}}</th>
                                <th scope="col" class="sort">{{__($businessLabelTitleCase . ' Name')}}</th>
                                <th scope="col" class="sort">{{__('Owner Name')}}</th>
                                <th scope="col" class="sort">{{__('Earnings')}}</th>
                                <th scope="col" class="sort">{{__('Commission')}}</th>
                                <th scope="col" class="sort">{{__('Revenue Month')}}</th>
                                <th></th>
                            </tr>
                        </thead>
                        <tbody class="list">
                            @php
                            $tot_income = 0;
                            $tot_commission = 0;
                            @endphp
                            @foreach ($businesses as $business)
                            @php
                            $income = 0;
                            $commission = 0;
                            @endphp
                            <tr>
                                <td>{{$loop->iteration}}</td>
                                <td>
                                    <img class="tableimage rounded" src="{{asset('storage/images/business logos/'.$business->image)}}">
                                </td>
                                <td>{{$business->name}}</td>
                                <td>{{$business->ownerName}}</td>
                                @foreach ($booking as $book)
                                @if ($book->business_id == $business->business_id)
                                @php
                                $income = $income + $book->business_income;
                                $commission = $commission + $book->commission;
                                @endphp
                                @endif
                                @endforeach
                                @php

                                $tot_income = $tot_income + $income;
                                $tot_commission = $tot_commission + $commission;
                                @endphp
                                <td>{{$setting->currency_symbol}}{{$income}}</td>
                                <td>{{$setting->currency_symbol}}{{$commission}}</td>
                                <td>{{\Carbon\Carbon::parse($business->created_at)->format('Y-m-d')}}</td>
                                <td class="table-actions">
                                    <a href="{{url('admin/businesses/'.$business->business_id)}}" class="table-action text-warning" data-toggle="tooltip" data-original-title="{{__('View ' . $businessLabelTitleCase)}}">
                                        <i class="fas fa-eye"></i>
                                    </a>
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection