@extends('layouts.admin')
<title>{{trans('home.clients').' | '.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>
                <h2 class="main-content-title tx-24 mg-b-5">اشخاص مسجلين</h2>
            </div>

            <div class="row btn btn-list gap-3 mx-3">
                <a href="{{url('admin/crm/add-client/single')}}"><button class="btn ripple btn-primary"><i class="fas fa-plus-circle"></i> {{trans('home.add_client')}}</button> </a>
                @can('crm-delete-leed')
                    <a id="btn_delete_crm" ><button class="btn ripple btn-danger"><i class="fas fa-trash"></i> {{trans('home.delete')}}</button></a>
                @endif
            </div>
        </div>
        <!-- End Page Header -->
        <!-- Row-->
        <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">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th><input type="checkbox" id="checkAll"/></th>
                                    <th>{{trans('home.id')}}</th>
                                    <th class="wd-15p">{{ __('home.code') }}</th>
                                    <th class="wd-25p">{{trans('home.email')}}</th>
                                    <th class="wd-20p">{{trans('home.name')}}</th>
                                    <th class="wd-25p">{{trans('home.ssn')}}</th>
                                    <th class="wd-25p">{{trans('home.phone')}}</th>
                                    <th>{{ trans('home.invoice_number') }}</th>
                                    <th>{{ trans('home.invoice_amount') }}</th>
                                    <th>{{ trans('home.invoice_discount') }}</th>
                                    <th>{{ trans('home.invoice_paid') }}</th>
                                    <th class="wd-15p">{{trans('home.responsible_employee')}}</th>
                                    <th class="wd-15p">البرنامج</th>
                                    <th class="wd-15p">{{trans('home.come_from')}}</th>
                                    <th class="wd-15p">{{trans('home.company')}}</th>
                                    <th class="wd-25p">{{trans('home.qualification')}}</th>
                                    <th class="wd-20p">{{trans('home.created_at')}}</th>
                                    <th class="wd-15p">القيم المسدده</th>
                                    <th class="wd-15p">{{trans('home.payment_status')}}</th>
                                    <th class="wd-25p">{{trans('home.nationality')}}</th>
                                    <th class="wd-15p">تاريخ اخر عملية سداد</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->training?->training?->code}}</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->name}}</a> </td>
                                        <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->ssn}}</a> </td>
                                        <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->phone}}</a> </td>
                                        <td>{{ implode(' , ',$client->invoices()->pluck('invoice_number')->toArray()) }}</td>
                                        <td>{{ $client->invoices()->sum('invoice_value') }}</td>
                                        <td>{{ $client->invoices()->sum('discount') }}</td>
                                        <td>{{ $client->invoices()->sum('invoice_value') - $client->invoices()->sum('discount') }}</td>
                                        <td>{{ $client?->responsible_employee?->user ? ($client?->responsible_employee?->user?->f_name . ' ' . $client?->responsible_employee?->user?->l_name) : '-' }}</td>

                                        <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> 
                                                    {!! optional($client->companyTraining)->map(function($training) use($lang) {
                                                    return "<span class='badge badge-primary m-1'>" . optional($training->training)->{'name_' . $lang}??'--'.' - '.$training->training?->code . "</span>";
                                                })->implode(' ')??'' !!}
                                            </a> 
                                        </td>
                                        <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->source?->{'name_'.$lang} }} </a> </td>
                                        <td><a href="{{url('admin/crm/client/'.$client->id)}}"> {{$client->company?$client->company->name: __('home.no_company') }}</a> </td>
                                        <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->qualification}}</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)}}"> 
                                                    {!! optional($client->companyTraining)->map(function($crm_company_training) use($client) {
                                                        $invoice_items = $client->invoices->where('crm_company_tranining_id',$crm_company_training->id)->first()?->items;
                                                        foreach($invoice_items??[] as $invoice_item){
                                                            return "<span class='badge badge-primary m-1'>".$invoice_item->amount.' '.__('home.SAR'). "</span>";
                                                        }
                                                })->implode(' ')??'' !!}
                                            </a> 
                                        </td>
                                        <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> 
                                         {!! optional($client->companyTraining)->map(function($crm_company_training) use($client) {
                                                $invoices = $client->invoices;
                                                    foreach($invoices??[] as $invoice){
                                                        return "<span class='badge " . ($invoice->invoice_status == "collected" ? "badge-success" : "badge-warning") . " m-1'>" . __('home.' . $invoice->invoice_status) . "</span>";

                                                    }
                                            })->implode(' ').'' !!}
                                            
                                            
                                        </a> </td>
                                        <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->responsible_employee?->user?->name() }}</a> </td>
                                        <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->nationality}}</a> </td>
                                        <td><a href="{{url('admin/crm/clients/'.$client->id)}}"> {{$client->invoices->first()?->items->last()?->created_at?->format('d-m-Y')}} </a> </td>
                                        
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
					</div>
                    </div>
                </div>
            </div>
        </div>
        <!-- End Row -->
    </div>
@endsection
@section('script')
<script>
     $(document).ready(function(){
            $('#btn_delete_crm').click(function(){
                var id = [];