@extends('layouts.admin')
<title>{{ trans('home.reports') . ' | ' . trans('home.crm') }}</title>
@section('content')
    <div class="container-fluid">

        <!-- Page Header -->
        <div class="page-header">
            <div>
                <h2 class="main-content-title tx-24 mg-b-5">{{ trans('home.crm') }}</h2>
                <span class="main-content-title tx-24 mg-b-5">{{ trans('home.reports') }}</span>
            </div>
        </div>
        <!-- End Page Header -->
        <!-- Row-->
        <div class="row justify-content-center">
            <div class="card custom-card">
                <form method="GET" action="{{ route('get_report_options') }}">
                    <div class="row card-body row ml-2 mt-4 border-start border-primary">
                        @csrf
                        @if (auth()->user()->type == 'admin')
                            <div class="form-group mb-3 col-3">
                                <label for="parent">{{ trans('home.responsible_employee') }}</label>
                                <select class="form-control select2" name="responsible_employee">
                                    <option value="" selected disabled>{{ trans('home.responsible_employee') }}
                                    </option>
                                    <option value="" {{ request('responsible_employee') == null ? 'selected' : '' }}>
                                        الجميع</option>
                                    @foreach ($crm_employees as $crm_employee_filter)
                                        <option value="{{ $crm_employee_filter->id }}"
                                            {{ request('responsible_employee') == $crm_employee_filter->id ? 'selected' : '' }}>
                                            {{ $crm_employee_filter->name() }}</option>
                                    @endforeach
                                </select>
                            </div>
                        @else
                            <input type="hidden" class="form-control" name="responsible_employee"
                                value="{{ auth()->user()->id }}" >
                        @endif
                            <div class="form-group mb-3 col-3">
                                <label for="date">{{ trans('home.from') }}</label>
                                <input type="date" class="form-control" name="date_from"
                                    value="{{ request('date_from') }}">
                            </div>

                            <div class="form-group mb-3 col-3">
                                <label for="date">{{ trans('home.to') }}</label>
                                <input type="date" class="form-control" name="date_to" value="{{ request('date_to') }}">
                            </div>
                            <div class="form-group mb-3 col-3">
                                <label for="parent">فلتر بواسطة</label>
                                <select class="form-control select2" id="client_type" name="type" required>
                                    <option value="" selected disabled>{{ trans('home.type') }}</option>
                                    <option value="company" {{ request('type') == 'company' ? 'selected' : '' }}>
                                        {{ __('home.companies') }}</option>
                                    <option value="client" {{ request('type') == 'client' ? 'selected' : '' }}>
                                        {{ __('home.clients') }}</option>
                                    <option value="all"
                                        {{ request('type') == 'all' || request('type') == null ? 'selected' : '' }}>
                                        الجميع</option>
                                </select>
                            </div>
                            <div class="col-3 form-group mb-3 @if (!request('category') || request('type') != 'company') d-none @endif "
                                id="client_category">
                                <label for="parent">مسار البيع</label>
                                <select class="form-control select2" name="category">
                                    <option value="maharat"
                                        @if (request('category')) {{ request('category') == 'maharat' ? 'selected' : '' }} @endif>
                                        @lang('home.maharat')</option>
                                    <option value="special"
                                        @if (request('category')) {{ request('category') == 'special' ? 'selected' : '' }} @endif>
                                        @lang('home.special')</option>
                                    <option value="special-maharat"
                                        @if (request('category')) {{ request('category') == 'special-maharat' ? 'selected' : '' }} @endif>
                                        @lang('home.special-maharat') </option>
                                    <option value="all"
                                        @if (request('category')) {{ request('category') == 'all' ? 'selected' : '' }} @endif>
                                        الجميع </option>
                                </select>
                            </div>
                            <div class="row justify-content-center text-center align-items-center">
                                <button class="btn btn-primary col-4">@lang('home.filter')</button>
                                @if (count(request()->all()) > 0)
                                    <a href="{{ route('get_report_options') }}"
                                        class="btn btn-info mr-3 col-3">@lang('home.clear_filter')</a>
                                @endif
                            </div>
                    </div>

                    <div class="row justify-content-center text-center align-items-center m-2">
                        @if (request('responsible_employee'))
                            <table class="table table-bordered">
                                <!-- First Row: User Name -->
                                <thead>
                                    <tr>
                                        <th colspan="6" class="text-center bg-primary text-white">
                                            <h3>
                                                {{ $crm_employee->name() . ' ( ' . $target_numbers['target']?->target_data?->name . ' ) ' }}
                                            </h3>
                                        </th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <!-- Subsequent Rows: Key-Value Pairs -->
                                    <tr>
                                        <td><strong>@lang('home.n_calls')</strong></td>
                                        <td>{{ $target_numbers['n_calls'] }}</td>
                                        @if(request('type')!="client")
                                            <td><strong>@lang('home.n_sms')</strong></td>
                                            <td>{{ $target_numbers['n_sms'] }}</td>
                                            <td><strong>@lang('home.n_meeting')</strong></td>
                                            <td>{{ $target_numbers['n_meeting'] }}</td>
                                        </tr>
                                        <tr>
                                            <td><strong>@lang('home.n_whatsapp')</strong></td>
                                            <td>{{ $target_numbers['n_whatsapp'] }}</td>
                                            <td><strong>@lang('home.n_mails')</strong></td>
                                            <td colspan="3">{{ $target_numbers['n_mails'] }}</td>
                                        @endif    
                                    </tr>
                                    <tr>
                                        <td><strong> التارجت المطلوب شهريا \ حتى نهاية السنه</strong></td>
                                        <td>{{ $target_numbers['required_budget_monthly'].' \ '. $target_numbers['required_budget_yearly']}}</td>
                                        <td><strong>المحقق</strong></td>
                                        <td colspan="3">
                                            {{ $target_numbers['collected_all'] }} 
                                            <h6> B2B : {{ $target_numbers['achieved_companies'] }}
                                                | B2C : {{ $target_numbers['achieved_clients'] }}
                                                | Maharat :
                                                 {{ $target_numbers['achieved_maharat'] }}
                                            </h6>

                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                            <table class="table table-bordered">
                                <!-- First Row: User Name -->
                                <thead>
                                    <tr>
                                        <th class="text-center bg-primary text-white">#</th>
                                        <th class="text-center bg-primary text-white">تاريخ البدء</th>
                                        <th class="text-center bg-primary text-white">تاريخ الانتتهاء / حتى الان</th>
                                        <th class="text-center bg-primary text-white">المسمى الوظيفى</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($crm_employee->target as $history_target_index=>$history_target )
                                        <tr>
                                            <td>{{ $history_target_index+1 }}</td>
                                            <td>{{ $history_target->created_at->format('d - m - Y') }}</td>
                                            <td>{{ $history_target->updated_at->format('d - m - Y') }}</td>
                                            <td>{{ $history_target->target_data?->name }}</td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>

                            <div class="row justify-content-center text-center align-items-center mt-3">
                                <h4>المطلوب تحقيقه </h4>
                                <!-- Calls-->
                                <div class="col-sm-6 col-md-4 col-xl-auto">
                                    <a>
                                        <div class="card custom-card">
                                            <div class="card-body text-center border border-primary">
                                                <p class="headCardHome">المكالمات الشهرى</p>
                                                <h3 class="headCardNum">
                                                    {{ $target_numbers['target']?->target_data?->call_monthly }}</h3>
                                            </div>
                                        </div>
                                    </a>
                                </div>

                                <!-- meetings-->

                                <div class="col-sm-6 col-md-4 col-xl-auto">
                                    <a>
                                        <div class="card custom-card">
                                            <div class="card-body text-center border border-primary">
                                                <p class="headCardHome">الاجتماعات الشهرى</p>
                                                <h3 class="headCardNum">
                                                    {{ $target_numbers['target']?->target_data->meeting_monthly }}</h3>
                                            </div>
                                        </div>
                                    </a>
                                </div>

                                <div class="col-sm-6 col-md-4 col-xl-auto">
                                    <a>
                                        <div class="card custom-card">
                                            <div class="card-body text-center border border-primary">
                                                <p class="headCardHome"> @lang('home.budget_monthly')</p>
                                                <h3 class="headCardNum">
                                                    {{ $target_numbers['target']?->target_data->budget_monthly }}</h3>
                                            </div>
                                        </div>
                                    </a>
                                </div>

                                <div class="col-sm-6 col-md-4 col-xl-auto">
                                    <a>
                                        <div class="card custom-card">
                                            <div class="card-body text-center border border-primary">
                                                <p class="headCardHome"> التارجت السنوى المتوقع</p>
                                                <h3 class="headCardNum">
                                                    {{ $target_numbers['required_budget_yearly'] }}</h3>
                                            </div>
                                        </div>
                                    </a>
                                </div>
                            </div>
                            <div class="row">
                                <div class="col-sm-12 col-xl-12 col-lg-12">
                                    <div class="card custom-card overflow-hidden">
                                        <div class="card-body">
                                            <div class="table-responsive">
                                                <table class="table" id="exportexample_witout_source">
                                                    <thead>
                                                        <tr>
                                                            <th class="wd-20p">تاريخ </th>
                                                            <th class="wd-20p">عدد المكالمات الشهرى </th>
                                                            <th class="wd-20p">عدد الاجتماعات الشهرى </th>
                                                            <th class="wd-20p">التارجت المحقق </th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        @foreach ($monthlyStatistics as $year => $months)
                                                            @foreach ($months as $month => $statistics)
                                                                <tr>
                                                                    <td>{{ \Carbon\Carbon::createFromFormat('m', $month)->format('m') . '/' . $year }}
                                                                    </td>
                                                                    <td>{{ $statistics['total_calls'] }}</td>
                                                                    <td>{{ $statistics['total_meetings'] }}</td>
                                                                    <td>{{ number_format($statistics['total_invoice_value'], 2) }}</td>
                                                                </tr>
                                                            @endforeach
                    
                                                            <!-- Calculate yearly totals -->
                                                            <tr style="background: #ff7620 !important; color:white !important;">
                                                                <th>Total for {{ $year }}</th>
                                                                <th>{{ collect($months)->sum('total_calls') }}</th>
                                                                <th>{{ collect($months)->sum('total_meetings') }}</th>
                                                                <th>{{ number_format(collect($months)->sum('total_invoice_value'), 2) }}</th>
                                                            </tr>
                                                        @endforeach
                    
                                                    </tbody>
                                                </table>
                                            </div>
                                        </div>
                                        <!-------->
                                        <div class="card-body">
                                            <h3 class="m-2">الشركات او الافراد الخاصين ب {{$crm_employee->name()}}</h3>
                                            <div class="table-responsive">
                                                <table class="table" id="exportexample">
                                                    <thead>
                                                        <tr>
                                                            <th>#</th>
                                                            <th><input type="checkbox" id="checkAll"/></th>
                                                            <th>{{trans('home.id')}}</th>
                                                            <th class="wd-20p">{{trans('home.created_at')}}</th>
                                                            <th class="wd-20p">{{trans('home.name')}}</th>
                                                            <th class="wd-25p">{{trans('home.email')}}</th>
                                                            <th class="wd-15p">{{trans('home.come_from')}}</th>
                                                            <th class="wd-15p">تاريخ اخر عملية سداد</th>
                                                            <th class="wd-15p">{{trans('home.company')}}</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        @foreach($clients as $index=>$client)
                                                            <tr id="{{$client->id}}">
                                                                <td> {{$index+1}} </td>
                                                                <td> <input type="checkbox" name="checkbox"  class="tableChecked" value="{{$client->id}}" /> </td>
                                                                <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->id}}</a> </td>
                                                                <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->created_at->format('d/m/Y')}}</a> </td>
                                                                <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{($client->type=="company"?__('home.'.$client->type):'').' '.$client->name}}</a> </td>
                                                                <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->email}}</a> </td>
                                                                <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->source?->{'name_'.$lang} }} </a> </td>
                                                                <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->invoices->first()?->items->last()?->created_at?->format('d-m-Y')}} </a> </td>
                                                                <td><a href="{{url('admin/crm/client/'.$client->id)}}"> {{$client->company?$client->company->name: __('home.no_company') }}</a> </td>
                                                            </tr>
                                                        @endforeach
                                                    </tbody>
                                                </table>
					                        </div>
                                        </div>
                                        
                                        <!---------->
                                    </div>
                                </div>
                            </div>
                                <!-- End Row -->
                        @else
                            @foreach ($crm_employees as $crm_employee)
                                @if (auth()->user()->type == 'admin')
                                    <table class="col-12 table table-bordered m-2">
                                        <!-- First Row: User Name -->
                                        <thead>
                                            <tr>
                                                <th colspan="6" class="text-center bg-primary text-white">
                                                    <h3>
                                                        {{ $crm_employee->name() . ' ( ' . $crm_employee->target->first()?->target_data->name . ' ) ' }}
                                                    </h3>
                                                </th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <!-- Subsequent Rows: Key-Value Pairs -->
                                            <tr>
                                                <td><strong>@lang('home.n_calls')</strong></td>
                                                <td>{{ $target_numbers[$crm_employee->id]['n_calls'] }}</td>
                                                @if(request('type')!="client")
                                                    <td><strong>@lang('home.n_sms')</strong></td>
                                                    <td>{{ $target_numbers[$crm_employee->id]['n_sms'] }}</td>
                                                <td><strong>@lang('home.n_meeting')</strong></td>
                                                <td>{{ $target_numbers[$crm_employee->id]['n_meeting'] }}</td>
                                            </tr>
                                            <tr>
                                                <td><strong>@lang('home.n_whatsapp')</strong></td>
                                                <td>{{ $target_numbers[$crm_employee->id]['n_whatsapp'] }}</td>
                                                <td><strong>@lang('home.n_mails')</strong></td>
                                                <td colspan="3">{{ $target_numbers[$crm_employee->id]['n_mails'] }}</td>
                                                @endif
                                            </tr>
                                            <tr>
                                                <td><strong>مجموع التارجت السنوى المطلوب تحقيقه</strong></td>
                                                <td >{{ $target_numbers[$crm_employee->id]['required_budget_monthly'].' \ '. $target_numbers[$crm_employee->id]['required_budget_yearly']}}</td>
                                                <td><strong>المحقق</strong></td>
                                                <td colspan="3">
                                                    {{ $target_numbers[$crm_employee->id]['collected_all'] }}
                                                    <h6> B2B : {{ $target_numbers[$crm_employee->id]['achieved_companies'] }}
                                                        | B2C : {{ $target_numbers[$crm_employee->id]['achieved_clients'] }}
                                                        | Maharat :
                                                        {{ $target_numbers[$crm_employee->id]['achieved_maharat'] }}
                                                    </h6>

                                                </td>
                                            </tr>
                                            <tr>
                                            </tr>
                                        </tbody>
                                    </table>
                                @elseif($crm_employee->id == auth()->user()->id)
                                    <table class="col-12 table table-bordered m-2">
                                        <!-- First Row: User Name -->
                                        <thead>
                                            <tr>
                                                <th colspan="6" class="text-center bg-primary text-white">
                                                    <h3>
                                                        {{ $crm_employee->name() . ' ( ' . $crm_employee->target->first()?->target_data->name . ' ) ' }}
                                                    </h3>
                                                </th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <!-- Subsequent Rows: Key-Value Pairs -->
                                            <tr>
                                                <td><strong>@lang('home.n_calls')</strong></td>
                                                <td>{{ $target_numbers[$crm_employee->id]['n_calls'] }}</td>
                                                <td><strong>@lang('home.n_sms')</strong></td>
                                                <td>{{ $target_numbers[$crm_employee->id]['n_sms'] }}</td>
                                                <td><strong>@lang('home.n_meeting')</strong></td>
                                                <td>{{ $target_numbers[$crm_employee->id]['n_meeting'] }}</td>
                                            </tr>
                                            <tr>
                                                <td><strong>@lang('home.n_whatsapp')</strong></td>
                                                <td>{{ $target_numbers[$crm_employee->id]['n_whatsapp'] }}</td>
                                                <td><strong>@lang('home.n_mails')</strong></td>
                                                <td colspan="3">{{ $target_numbers[$crm_employee->id]['n_mails'] }}</td>
                                            </tr>
                                            <tr>
                                                <td><strong>مجموع التارجت الشهرى حتى الان المطلوب تحقيقه</strong></td>
                                                <td>{{ $target_numbers[$crm_employee->id]['required_budget_yearly'] }}</td>
                                                <td><strong>المحقق</strong></td>
                                                <td colspan="3">
                                                    {{ $target_numbers[$crm_employee->id]['collected_all'] }}</td>
                                            </tr>
                                            <tr>
                                                <td><strong>@lang('home.budget_monthly')
                                                        @if (!request('date_from'))
                                                            : للشهر االحالى
                                                        @endif
                                                    </strong></td>
                                                <td>{{ $target_numbers[$crm_employee->id]['required_budget_monthly'] }}
                                                </td>
                                                <td><strong>المحقق</strong></td>
                                                <td colspan="3">
                                                    {{ $target_numbers[$crm_employee->id]['collected_all'] }}
                                                    <h6> B2B : {{ $target_numbers[$crm_employee->id]['achieved_companies'] }}
                                                        | B2C : {{ $target_numbers[$crm_employee->id]['achieved_clients'] }}
                                                        | Maharat :
                                                        {{ $target_numbers[$crm_employee->id]['achieved_maharat'] }}
                                                    </h6>

                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                @endif
                            @endforeach
                        @endif
                    </div>
                </form>
            </div>
        </div>
        <!-- End Row -->
    </div>
@endsection
@section('script')
    <script>
        $('#client_type').change(function() {
            var type_value = $(this).val();
            if (type_value == "company") {
                $('#client_category').removeClass('d-none')
            } else {
                $('#client_category').addClass('d-none')
            }
            console.log(type_value);
        });
    </script>
@endsection