@extends('layouts/contentLayoutMaster')

@section('title', 'التقارير')

@section('vendor-style')
    <!-- vendor css files -->
    <link rel="stylesheet" href="{{ asset('vendors/css/forms/select/select2.min.css') }}">
@endsection

@section('content')
<section id="contextual-colors" class="card">
        <div class="card-content">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title" style="color:#ffb800"> تقرير الأداء الشهري </h4>
                </div>
                <br/><br/>
                <form class="form" action="{{route('reports.performance_report')}}" method="get">
                    <div class="col-md-12" style="display:flex;">
                        <div class="col-md-2">
                            {{__('lang.choose_zone')}}
                            <select class="form-control" id="zone_id" name="zone_id" >
                                <option value="">{{ __('lang.choose_zone')}}</option>
                                @foreach($zones as $zone)
                                    <option value="{{$zone->id}}" @if( $filter['zone_id'] == $zone->id) selected="selected" @endif >{{$zone->name}}</option>
                                @endforeach
                            </select>            
                        </div>
                        <div class="col-md-2">
                            {{__('lang.created_at_from')}}
                                <input type="month" class="form-control" name="start_month" id="start_month" value="{{ request('start_month', \Carbon\Carbon::now()->subMonths(6)->translatedFormat('Y-m')) }}">
                            </div>
                            <div class="col-md-2">
                            {{__('lang.created_at_to')}}
                                <input type="month" class="form-control" name="end_month" id="end_month" value="{{ request('end_month', \Carbon\Carbon::now()->translatedFormat('Y-m')) }}">
                            </div>
                    </div>
                    <div class="col-md-12" style="display:flex;">
                        <div class="col-md-2">
                            <button type="submit" class="btn btn-primary" style="margin-top:17px">عرض التقرير</button>
                        </div>
                    </div>
                </form>
                <div class="card-content">
                    <div class="card-body">
                            <div class="form-body">
                                <div class="row">
                                    <div class="col-md-12">
                                        <table class="table table-bordered">
                                                <thead class="thead-color">
                                                    <tr>
                                                    <th scope="col"> الشهر </th>
                                                    <th scope="col"> المتسخدمين الجدد </th>
                                                    <th scope="col"> الطلبات</th>
                                                    <th scope="col"> أجمالي المدخول </th>
                                                    <th scope="col"> مدخول الخدمات</th>
                                                    <th scope="col"> مدخول المنتجات</th>
                                                    <th scope="col"> مدخول الاشتراكات  </th>
                                                    <th scope="col"> مدخول الإهداءات </th>
                                                    <th scope="col">  السعة </th>
                                                    <th scope="col">  الإشغال </th>
                                                    <th scope="col">  تقييم الخدمة</th>
                                                    <th scope="col">  تقييم الفني</th>
                                                    <th scope="col">  الالتزام بالوقت </th>
                                                    <th scope="col">  احتمال التوصية </th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @foreach($reportData as $monthKey => $monthDetails )
                                                        <tr>
                                                            <td><b>{{$monthKey}} </b></td>
                                                            <td>{{$monthDetails['new_users']}}</td>
                                                            <td>{{ $monthDetails['total_orders'] }}</td>
                                                            <td>{{number_format($monthDetails['total'], 2, '.', ',') }} ر.س</td>
                                                            <td>{{number_format($monthDetails['total_revenue'], 2, '.', ',') }} ر.س</td>
                                                            <td>{{number_format($monthDetails['total_products'], 2, '.', ',') }} ر.س</td>
                                                            <td>{{number_format($monthDetails['subscriptions'], 2, '.', ',') }} ر.س</td>
                                                            <td>{{ number_format($monthDetails['total_gifts'], 2, '.', ',')}} ر.س</td>
                                                            <td>{{$monthDetails['total_capicity']}}</td>
                                                            <td>{{($monthDetails['total_capicity'] != 0) ? (int) (($monthDetails['total_orders'] / $monthDetails['total_capicity'] ) * 100)  : "-" }} %</td>
                                                            <td>{{($monthDetails['total_rate'] != 0) ? number_format( ($monthDetails['provider_rate'] / $monthDetails['total_rate'] )  , 2) : "-" }} </td>
                                                            <td>{{($monthDetails['total_rate'] != 0) ? number_format( ($monthDetails['service_rate'] / $monthDetails['total_rate'] ) , 2) : "-" }} </td>
                                                            <td>{{($monthDetails['total_rate'] != 0) ? number_format( ($monthDetails['time_commitment'] / $monthDetails['total_rate'] ) , 2) : "-" }}  </td>
                                                            <td>10 / {{($monthDetails['total_rate'] != 0) ? number_format( ($monthDetails['order_again'] / $monthDetails['total_rate'] ) , 2) : "-" }} </td>
                                                        </tr>
                                                    @endforeach
                                                </tbody>
                                        </table>
                                    </div>
                                    
                                </div>
                            </div>
                    </div>
                </div>
            </div>
        </div>
</section>
  {{-- Data list view end --}}
@endsection