@extends('layouts.app')
@section('content')
<section class="content">
    <div class="container-fluid">

        <div class="px-sm-4">
            <header>
                <div class="row mt-2 mt-sm-3">
                    <div class="col-md-7 col-10">
                        <div class="top-head">
                            <h1>Dairy Development Executive (DDE)</h1>
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="/home">Settings</a></li>
                                    <li class="breadcrumb-item active" aria-current="page">DDE</li>
                                </ol>
                            </nav>
                        </div>
                    </div>
                    <div class="col-md-5 col-2 text-right">
                        <div class="d-flex justify-content-end">

                            <div class="top-search-bar d-sm-block d-none mr-3">
                                {{-- <form class="search-form" role="search">
                                    <div class="form-group pull-right" id="searchnew">
                                        <input type="text" class="form-control" placeholder="Search by...">
                                        <button type="submit"
                                            class="form-control form-control-submit">Submit</button>
                                        <span class="search-label"><img src="{{ asset('assets/img/search.svg') }}" alt="/"></span>
                                    </div>
                                </form> --}}
                                <form>
                                    <input type="text" name="search" placeholder="Search by ..." id="search"
                                        class="form-control" value="{{ $search }}">
                                </form>
                            </div>

                            <a href="{{ url('/dairy-executives/create') }}"><button type="button" class="plus-btn"><img src="{{ asset('assets/img/plus-white.svg') }}"
                                alt=""></button></a>
                        </div>
                    </div>
                </div>
            </header>

        <form method="get">
            <div class="box-select bg-white">
                <div class="row">
                    <div class="col-md-3 border-sm-right">
                        <div class="select-innerpadding">
                            <label class="select-label mb-0">Location</label>
                            <select class="form-control select-content" name="state_id" onchange="this.form.submit()">
                                <option value="">Select</option>
                                    @foreach ($states as $state)
                                            <option value="{{ $state->id }}" @if ($state->id == $state_selected || old('state_id') == $state->id) selected @endif>
                                                {{ $state->name }}
                                        </option>
                                    @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3 border-sm-right">
                        <div class="select-innerpadding">
                            <label class="select-label mb-0">MCC</label>
                            <select class="form-control select-content" name="mcc_id" onchange="this.form.submit()">
                                <option value="">Select</option>
                                    @foreach ($milkCollectionCenters as $milkCollectionCenter)
                                            <option value="{{ $milkCollectionCenter->id }}" @if ($milkCollectionCenter->id == $mcc_selected || old('mcc_id') == $milkCollectionCenter->id) selected @endif>
                                                {{ $milkCollectionCenter->name }}
                                        </option>
                                    @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3 border-sm-right">
                        <div class="select-innerpadding">
                            <label class="select-label mb-0">Target</label>
                            <select class="form-control select-content" name="target" onchange="this.form.submit()">
                                <option value="">Select</option>
                                <option value="Achieved" @if(request()->input('target') == "Achieved" ) selected @endif>Achieved</option>
                                <option value="Not Achieved" @if(request()->input('target') == "Not Achieved" ) selected @endif>Not Achieved</option>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="select-innerpadding">
                            <label class="select-label mb-0">Status</label>
                            <select class="form-control select-content" name="status" id="status" onchange="this.form.submit()">
                                <option value="">Select</option>
                                <option value="active" @if(request()->input('status') == "active" ) selected
                                    @endif>Active</option>
                                <option value="inactive" @if(request()->input('status') == "inactive" ) selected
                                    @endif>Inactive</option>
                            </select>
                        </div>
                    </div>
                </div>
            </div>
        </form>
        <div class="row float-right mt-2">
            <div class="col-md-12 text-right d-flex float-right">
                <div class="clear">
                    <a class="clear-filter" href="/dairy-executives">Clear Filters</a>
                </div>
            </div>
        </div>
        <div class="row mt-4" style="margin-top:3.5rem!important;">
            <div class="col-md-12">
                <div class="card table-card p-2">
                    <div class="table-responsive">
                        <table class="table dairy-table mb-0">
                            <thead>
                                <tr>
                                    <th colspan="4" style="text-align: center;">NAME</th>
                                    <th>CONTACT</th>
                                    <th>MCC</th>
                                    <th>TARGET</th>
                                    <th>ONGOING PROJECTS</th>
                                    <th>SERVICE LOCATION</th>
                                    <th></th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($ddes as $item)
                                    
                                    @php
                                        $activeProjects = App\Models\FarmerProject::where('dde_id', $item->id)
                                                                        ->whereIn('project_status', App\Helpers\ConstantHelper::ACTIVE_PROJECT)
                                                                        ->count();  
                                    @endphp
                                    <tr>
                                        {{-- <td>
                                            @if($item->status == 'active')
                                            <p class="active-notgreen"></p>
                                            @else
                                            <p class="active-notgreen  active-dotgray"></p>
                                            @endif
                                        </td> --}}
                                        <td>
                                            @if ($item->status == 'active')
                                                <span class="badge badge-success">
                                                    {{ ucfirst($item->status) }}
                                                </span>
                                            @else
                                                <span class="badge badge-warning">
                                                    {{ ucfirst($item->status) }}
                                                </span>
                                            @endif
                                        </td>
                                        <td>
                                            <h6 class="table-username">
                                                <img src="{{ isset($item->user->profile_pic) ?$item->user->profile_pic : '' }}"
                                                onerror="this.src='/assets/img/user-default.jpg'"
                                                alt="{{ isset($item->user->profile_pic) ? $item->user->profile_pic : '' }}" width="40px" height="40px">
                                            </h6>
                                        </td>

                                        <td width="170px">{{ @$item->name }} <br>
                                            @php
                                                $rating = App\Helpers\CommonHelper::getUserRating('dde',@$item->id); 
                                            @endphp 
                                            @if($rating->count > 0)
                                                @if($rating->average > 0 && $rating->average < 1)
                                                    <img class="gold-star" src="{{asset('assets/img/half-yellowstar.svg')}}" alt="">
                                                @endif

                                                @if($rating->average >= 1)
                                                    <img class="gold-star" src="{{asset('assets/img/full-yellowstar.svg')}}"  alt="">
                                                @endif

                                                @if($rating->average > 1 && $rating->average < 2)
                                                    <img class="gold-star" src="{{asset('assets/img/half-yellowstar.svg')}}" alt="">
                                                @endif

                                                @if($rating->average >= 2)
                                                    <img class="gold-star" src="{{asset('assets/img/full-yellowstar.svg')}}"  alt="">
                                                @endif

                                                @if($rating->average > 2 && $rating->average < 3)
                                                    <img class="gold-star" src="{{asset('assets/img/half-yellowstar.svg')}}" alt="">
                                                @endif

                                                @if($rating->average >= 3)
                                                    <img class="gold-star" src="{{asset('assets/img/full-yellowstar.svg')}}"  alt="">
                                                @endif

                                                @if($rating->average > 3 && $rating->average < 4)
                                                    <img class="gold-star" src="{{asset('assets/img/half-yellowstar.svg')}}" alt="">
                                                @endif

                                                @if($rating->average >= 4)
                                                    <img class="gold-star" src="{{asset('assets/img/full-yellowstar.svg')}}"  alt="">
                                                @endif

                                                @if($rating->average > 4 && $rating->average < 5)
                                                    <img class="gold-star" src="{{asset('assets/img/half-yellowstar.svg')}}" alt="">
                                                @endif

                                                @if($rating->average >= 5)
                                                    <img class="gold-star" src="{{asset('assets/img/full-yellowstar.svg')}}"  alt="">
                                                @endif
                                                ({{$rating->count}})
                                            @endif  
                                        </td>

                                        <td>
                                            @if(@$item->badge == 'silver')
                                                <img src="{{ asset('assets/img/silver-badge.svg') }}" alt="">
                                            @endif
                                            @if(@$item->badge == 'gold')
                                            <img src="{{ asset('assets/img/medal (2).svg') }}" alt="">
                                            @endif
                                            @if(@$item->badge == 'diamond')
                                            <img src="{{ asset('assets/img/platinum-badge.svg') }}" alt="">
                                            @endif
                                            @if(@$item->badge == 'platinum')
                                            <img src="{{ asset('assets/img/diamond-badge.svg') }}" alt="">
                                            @endif
                                        </td>

                                        <td width="210px" class="contact-table">
                                            +256 {{ @$item->phone }} <br>
                                            <span>{{ @$item->email }}</span>
                                        </td>
                                        <td>{{ @$item->mcc->name }}</td>
                                        @if(@$item->target == 'Not Achieved')
                                        <td class="achieved-text-red">{{@$item->target}}</td>
                                        @else
                                        <td class="achieved-text">{{@$item->target}}</td>
                                        @endif
                                        <td style="text-align:right; width: 50px;">{{$activeProjects}}</td>
                                        <td>{{ @$item->user->address->address}}</td>
                                        <td width="90px">
                                            <a href="dairy-executives/view/{{ base64_encode($item->id) }}"><span class="badge eye-box mr-1"><img src="{{ asset('assets/img/eye.svg') }}"
                                                    alt=""></span></a>
                                            <a href="dairy-executives/edit/{{ base64_encode($item->id) }}"><span class="badge edit-box"><img src="{{ asset('assets/img/edit.svg') }}"
                                                    alt=""></span></a>
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                        @if (count($ddes) == 0)
                            <div>
                                <center>No record(s) found!</center>
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>
        
        {{ $ddes->appends(request()->input())->links('partials.pagination') }}

        </div>

    </div>
</section>
@endsection

@section('scripts')
    <script>
         $("#search").change(function() {
            this.form.submit();
        });

    </script>
@endsection