@extends('admin.layouts.admin')
@section('style')
<link href="{{ asset('assets/admin/plugins/datatables/dataTables.bootstrap4.min.css') }}" rel="stylesheet" type="text/css" />
@endsection
@section('content')
<!-- Page Content-->
    <div class="page-content-tab">
        <div class="container-fluid">
            <!-- Page-Title -->
            <div class="row">
                <div class="col-sm-12">
                    <div class="page-title-box">
                        <div class="float-right">
                            <ol class="breadcrumb">
                                <li class="breadcrumb-item">
                                    <a href="javascript:void(0);">Performance</a>
                                </li>
                                <li class="breadcrumb-item active">Report</li>
                            </ol>
                        </div>
                        <h4 class="page-title">Report</h4>

                    </div>
                    <!--end page-title-box-->
                </div>
                <!--end col-->
            </div>
            <!--end row-->
            <!-- end page title end breadcrumb -->
            <div class="row">
                <div class="col-sm-12">
                    @if(session('alert-green'))
                            <div id="mydiv" class="alert alert-success mt-3 text-center">
                                {{ session('alert-green') }}
                            </div>
                        @endif

                        @if(session('alert-danger'))
                            <div id="mydiv" class="alert alert-danger mt-3 text-center">
                                {{ session('alert-danger') }}
                            </div>
                        @endif
                        @if($errors->any())
                            <div id="mydiv" class="row">
                                <div class="col-md-12 mb-5">
                                    @foreach ($errors->all() as $error)
                                        <div class="text-danger small mb-1">* {{$error}}</div>
                                    @endforeach
                                </div>
                            </div>
                        @endif
                        {{ session('status') }}

                    <div class="card">
                        <div class="card-body">
                            <h4 class="mt-0 mb-0 header-title">Filter</h4>
                            <form method="GET" class="form-horizontal "
                                action="{{ route('admin.performance.index') }}">
                                @csrf
                                <div class="row">
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="emp_id">Employee ID</label>
                                            <input type="text" name="emp_id" value="{{request('emp_id')}}" class="form-control" id="emp_id">
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="name">Employee Name</label>
                                            <input type="text" name="name" value="{{request('name')}}" class="form-control" id="name">
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="department">Department</label>
                                            <select name="department" value="{{request('department')}}" class="form-control" id="department">
                                                <option value="">Select Department</option>
                                                @foreach ($departments as $department)
                                                <option value="{{ $department->id }}">{{ $department->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="name">Date</label>
                                            <input type="text" name="date" value="{{request('date')}}" class="form-control " id="date">
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="designation">Designation</label>
                                            <select name="designation"  class="form-control" id="designation">
                                                <option value="">Select Designation</option>
                                                <option {{ (request('designation') == "RH") ? "selected" : '' }} value="RH">Regional Head</option>
                                                <option {{ (request('designation') == "ZM") ? "selected" : '' }} value="ZM">Zonal Manager</option>
                                                <option {{ (request('designation') == "TL") ? "selected" : '' }} value="TL">Team Leader</option>
                                                <option {{ (request('designation') == "RM") ? "selected" : '' }} value="RM">MAS</option>                                                
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="zone">Zone</label>
                                            <select name="zone"  class="form-control" id="zone">
                                                <option value="">Select Zone</option>
                                                @foreach($zones as $zone)
                                                <option {{request('zone') == $zone->name ? 'selected' : ''}} value="{{ $zone->name }}">{{ $zone->name }}</option>
                                                @endforeach                                              
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <br />
                                <div class="row">
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="kpis">KPI</label>                                             
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase w-100" for="kpis">Achievement Percentage</label>                                        
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase w-100" for="kpis">Score</label>
                                        </div>                                        
                                    </div> 
                                </div> 
                                @foreach($kpi_lists as $kpi)                                
                                <div class="row">
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <div class="form-check">
                                                
                                                <input class="form-check-input" {{ (request('kpi_id')) && (in_array($kpi->slug, request('kpi_id'))) ? 'checked' : '' }} type="checkbox" value="{{ $kpi->slug }}" name="kpi_id[]" id="{{ $kpi->slug }}">
                                                <label class="form-check-label" for="{{ $kpi->slug }}">
                                                {{ $kpi->name }} 
                                                </label>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="kpiData col-md-8">
                                        <div class="row">
                                        <div class="col-md-6">
                                            <div class="form-group">
                                                <input value="{{request($kpi->slug.'_ach_min')}}" type="text" class="w-25" name="{{ $kpi->slug }}_ach_min""> To
                                                <input value="{{request($kpi->slug.'_ach_max')}}" type="text" class="w-25" name="{{ $kpi->slug }}_ach_max"">
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="form-group">
                                                <input value="{{request($kpi->slug.'_score_min')}}" type="text" class="w-25" name="{{ $kpi->slug }}_score_min"> To
                                                <input value="{{request($kpi->slug.'_score_max')}}" type="text" class="w-25" name="{{ $kpi->slug }}_score_max">
                                            </div>                                        
                                        </div>
                                        </div> 
                                    </div>
                                </div> 
                                @endforeach                                    
                                <div class="row">
                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <a href="{{ url('admin/performance/performance-report') }}"
                                                class="btn btn-danger waves-effect waves-light mt-4 mr-2">
                                                <i class="ti-reload mr-2"></i>Clear
                                            </a>
                                            <button type="submit" class="btn btn-primary waves-effect waves-light mt-4">
                                                <i class="ti-search mr-2"></i>Filter Now
                                            </button>
                                            <button type="submit" name="download" value="1"
                                                class="btn btn-success waves-effect waves-light mt-4"><i
                                                    class="fas fa-download"></i> Download as Excel
                                            </button>
                                            
                                        </div>
                                    </div>
                                </div>
                            </form>
                            <!--end form-->
                        </div>
                        <!--end card-body-->
                    </div>
                    <!--end card-->
                </div>
                <!--end col-->
            </div>
            <div class="row">
                <div class="col-sm-12">
                    <div class="card">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-lg-6 col-sm-6">
                                    <h4 class="mt-0 mb-0 header-title">Lists </h4>
                                </div>
                                <div class="col-lg-6 col-sm-6 text-right">
                                    
                                </div>
                                <!-- end row -->
                            </div>
                            <!-- end row -->  
                          
                            <div class="table-responsive">
                            @if($performances)
                                <table id="example" class="table table-bordered dt-responsive nowrap w-100">
                                    <thead>
                                        <tr>
                                            <th colspan="7" class="text-center">Weightage</th>
                                            @php
                                            
                                            if($kpi_info != null){   
                                                foreach($kpi_info as $kpi_slug){
                                                    if($kpi_slug == "temporary_approved"){  
                                                        if((!empty($weightage)) && (array_key_exists('temporary_approved',$weightage))){  
                                                                                                                
                                                        echo "<th style='text-align: center;' colspan='5'>".$weightage['temporary_approved'] ."</th>";                                                                                                              
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='5'>0</th>";
                                                        }
                                                    }

                                                    if($kpi_slug == "secondery_reject"){  
                                                        if((!empty($weightage)) && (array_key_exists('secondery_reject',$weightage))){                                                      
                                                        echo "<th style='text-align: center;' colspan='4'>".$weightage['secondery_reject'] ."</th>";                                                                                                              
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='4'>0</th>";
                                                        }
                                                    }

                                                    if($kpi_slug == "qr_deployment"){
                                                        if((!empty($weightage)) && (array_key_exists('qr_deployment',$weightage))){
                                                            echo "<th style='text-align: center;' colspan='5'>".$weightage['qr_deployment']."</th>";
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='5'>0</th>";
                                                        }
                                                         
                                                    }

                                                    if($kpi_slug == "finally_approved"){
                                                        if((!empty($weightage)) && (array_key_exists('finally_approved',$weightage))){
                                                            echo "<th style='text-align: center;' colspan='5'>".$weightage['finally_approved']."</th>";
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='5'>0</th>";
                                                        }
                                                    }

                                                    if($kpi_slug == "unique_merchant_transaction_count"){
                                                        if((!empty($weightage)) && (array_key_exists('unique_merchant_transaction_count',$weightage))){
                                                            echo "<th style='text-align: center;' colspan='5'>".$weightage['unique_merchant_transaction_count']."</th>";
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='5'>0</th>";
                                                        } 
                                                    } 

                                                    if($kpi_slug == "high_volume_merchant_count"){
                                                        if((!empty($weightage)) && (array_key_exists('high_volume_merchant_count',$weightage))){
                                                            echo "<th style='text-align: center;' colspan='5'>".$weightage['high_volume_merchant_count']."</th>";
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='5'>0</th>";
                                                        }
                                                    } 

                                                    if($kpi_slug == "new_merchant_transaction_count"){
                                                        if((!empty($weightage)) && (array_key_exists('new_merchant_transaction_count',$weightage))){
                                                            echo "<th style='text-align: center;' colspan='5'>".$weightage['new_merchant_transaction_count']."</th>";
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='5'>0</th>";
                                                        }
                                                    } 

                                                    if($kpi_slug == "total_transaction_amount"){
                                                        if((!empty($weightage)) && (array_key_exists('total_transaction_amount',$weightage))){
                                                            echo "<th style='text-align: center;' colspan='5'>".$weightage['total_transaction_amount']."</th>";
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='5'>0</th>";
                                                        }
                                                    } 

                                                    if($kpi_slug == "non_qr_total_transaction_amount"){
                                                        if((!empty($weightage)) && (array_key_exists('non_qr_total_transaction_amount',$weightage))){
                                                            echo "<th style='text-align: center;' colspan='5'>".$weightage['non_qr_total_transaction_amount'] ?? '0'."</th>";
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='5'>0</th>";
                                                        }
                                                    } 

                                                    if($kpi_slug == "subscription_pack_sales_count"){
                                                        if((!empty($weightage)) && (array_key_exists('subscription_pack_sales_count',$weightage))){
                                                            echo "<th style='text-align: center;' colspan='9'>".$weightage['subscription_pack_sales_count'] ?? '0'."</th>";
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='9'>0</th>";
                                                        }
                                                    }

                                                    if($kpi_slug == "total_subscription_pack_sales_amount"){
                                                        if((!empty($weightage)) && (array_key_exists('total_subscription_pack_sales_amount',$weightage))){
                                                            echo "<th style='text-align: center;' colspan='5'>".$weightage['total_subscription_pack_sales_amount'] ?? '0'."</th>";
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='5'>0</th>";
                                                        }
                                                    }

                                                    if($kpi_slug == "npsb_qr_redeployment_count"){
                                                        if((!empty($weightage)) && (array_key_exists('npsb_qr_redeployment_count',$weightage))){
                                                            echo "<th style='text-align: center;' colspan='5'>".$weightage['npsb_qr_redeployment_count'] ?? '0'."</th>";
                                                        }else{
                                                            echo "<th style='text-align: center;' colspan='5'>0</th>";
                                                        }
                                                    }
                                                                            
                                                } 
                                                
                                            }
                                        @endphp 
                                            <th></th>
                                        </tr>
                                        <tr>                                  
                                            <th>SL No.</th>
                                            <th>MAS Team Lead</th>                                            
                                            <th>MAS Team Lead ID</th>                                        
                                            <th>MAS ID</th>                                        
                                            <th>MAS Name</th>                                        
                                            <th>Zone</th>                                        
                                            <th>Area</th> 
                                            @php
                                            if($kpi_info != null){   
                                                foreach($kpi_info as $kpi_slug){
                                                    if($kpi_slug == "temporary_approved"){
                                                        echo "<th bgcolor='#40E0D0'>Temporary Approved Target</th>";
                                                        echo "<th bgcolor='#40E0D0'>Achievement</th>";
                                                        echo "<th bgcolor='#40E0D0'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#40E0D0'>Min</th>";
                                                        echo "<th bgcolor='#40E0D0'>Score</th>";                                                       
                                                    }
                                                    
                                                    if($kpi_slug == "secondery_reject"){
                                                        echo "<th bgcolor='#40E0D0'>Documents submitted</th>";
                                                        echo "<th bgcolor='#40E0D0'>Secondery reject</th>";
                                                        echo "<th bgcolor='#40E0D0'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#40E0D0'>Score</th>";                                                       
                                                    }

                                                    if($kpi_slug == "qr_deployment"){
                                                        echo "<th bgcolor='#9FE2BF'>QR Deployment Target</th>";
                                                        echo "<th bgcolor='#9FE2BF'>Achievement</th>";
                                                        echo "<th bgcolor='#9FE2BF'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#9FE2BF'>Min</th>";
                                                        echo "<th bgcolor='#9FE2BF'>Score</th>"; 
                                                    }

                                                    if($kpi_slug == "finally_approved"){
                                                        echo "<th bgcolor='#6495ED'>Finally Approved Target</th>";
                                                        echo "<th bgcolor='#6495ED'>Achievement</th>";
                                                        echo "<th bgcolor='#6495ED'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#6495ED'>Min</th>";
                                                        echo "<th bgcolor='#6495ED'>Score</th>"; 
                                                    }

                                                    if($kpi_slug == "unique_merchant_transaction_count"){
                                                        echo "<th bgcolor='#008080'>Unique Merchant Target</th>";
                                                        echo "<th bgcolor='#008080'>Achievement</th>";
                                                        echo "<th bgcolor='#008080'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#008080'>Min</th>";
                                                        echo "<th bgcolor='#008080'>Score</th>";
                                                         
                                                    } 

                                                    if($kpi_slug == "high_volume_merchant_count"){
                                                        echo "<th bgcolor='#0000FF'>High Volume Merchant Target</th>";
                                                        echo "<th bgcolor='#0000FF'>Achievement</th>";
                                                        echo "<th bgcolor='#0000FF'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#0000FF'>Min</th>";
                                                        echo "<th bgcolor='#0000FF'>Score</th>";
                                                    } 

                                                    if($kpi_slug == "new_merchant_transaction_count"){
                                                        echo "<th bgcolor='#FF00FF'>New Merchant Transaction Target</th>";
                                                        echo "<th bgcolor='#FF00FF'>Achievement</th>";
                                                        echo "<th bgcolor='#FF00FF'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#FF00FF'>Min</th>";
                                                        echo "<th bgcolor='#FF00FF'>Score</th>";
                                                    } 

                                                    if($kpi_slug == "total_transaction_amount"){
                                                        echo "<th bgcolor='#FFA07A'>Total Transaction Target</th>";
                                                        echo "<th bgcolor='#FFA07A'>Achievement</th>";
                                                        echo "<th bgcolor='#FFA07A'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#FFA07A'>Min</th>";
                                                        echo "<th bgcolor='#FFA07A'>Score</th>";
                                                    } 

                                                    if($kpi_slug == "non_qr_total_transaction_amount"){
                                                        echo "<th bgcolor='#EDBB99'>Non QR Transaction Target</th>";
                                                        echo "<th bgcolor='#EDBB99'>Achievement</th>";
                                                        echo "<th bgcolor='#EDBB99'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#EDBB99'>Min</th>";
                                                        echo "<th bgcolor='#EDBB99'>Score</th>";
                                                    } 

                                                    if($kpi_slug == "subscription_pack_sales_count"){
                                                        echo "<th bgcolor='#FA8072'>Subscription Pack Target</th>";
                                                        echo "<th bgcolor='#FA8072'>Achievement</th>";
                                                        echo "<th bgcolor='#FA8072'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#FA8072'>Min</th>";
                                                        echo "<th bgcolor='#FA8072'>Score</th>";
                                                        echo "<th bgcolor='#fa9370'>Bronze</th>";
                                                        echo "<th bgcolor='#fa9370'>Silver</th>";
                                                        echo "<th bgcolor='#fa9370'>Gold</th>";
                                                        echo "<th bgcolor='#fa9370'>Platinum</th>";
                                                    }

                                                    if($kpi_slug == "total_subscription_pack_sales_amount"){
                                                        echo "<th bgcolor='#D2691E'>Subscription Pack Sale Amount</th>";
                                                        echo "<th bgcolor='#D2691E'>Achievement</th>";
                                                        echo "<th bgcolor='#D2691E'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#D2691E'>Min</th>";
                                                        echo "<th bgcolor='#D2691E'>Score</th>";
                                                    }

                                                    if($kpi_slug == "npsb_qr_redeployment_count"){
                                                        echo "<th bgcolor='#40E0D0'>NPSB QR Redeployment Target</th>";
                                                        echo "<th bgcolor='#40E0D0'>Achievement</th>";
                                                        echo "<th bgcolor='#40E0D0'>Achievement Percentage</th>";
                                                        echo "<th bgcolor='#40E0D0'>Min</th>";
                                                        echo "<th bgcolor='#40E0D0'>Score</th>";
                                                    }
                                                                            
                                                } 
                                                
                                            }
                                        @endphp                                   
                                              <th>Score</th>                                       
                                        </tr>
                                    </thead>
                                    <tbody>                                       
                                        @foreach($performances as $performance)
                                        <tr>
                                            <td>{{ $loop->iteration }}</td>
                                            <td>{{ $performance->employee_info->reportingTo->employee->emp_id ?? '' }}</td>
                                            <td>{{ $performance->employee_info->reportingTo->name ?? '' }}</td>
                                            <td>{{ $performance->emp_id ?? ''}}</td>
                                            <td>{{ $performance->emp_name ?? ''}}</td>
                                            <td>{{ $performance->zone ?? ''}}</td>
                                            <td>{{ $performance->area ?? ''}}</td>
                                            @php
                                            
                                            if($kpi_info != null){ 
                                                $total_score = 0; 
                                                foreach($kpi_info as $kpi_slug){
                                                    if($kpi_slug == "temporary_approved"){
                                                        echo "<td>".$performance->ta_target ?? ''."</td>";
                                                        echo "<td>".$performance->temporary_approved ?? ''."</td>";
                                                        echo "<td>".$performance->ta_ach_percentage."%" ?? ''." </td>";
                                                        echo "<td>".$performance->ta_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->ta_score." % " ?? ''."</td>";
                                                        $total_score += $performance->ta_score;
                                                    }

                                                    if($kpi_slug == "secondery_reject"){
                                                        echo "<td>".$performance->sr_target ?? ''."</td>";
                                                        echo "<td>".$performance->secondery_reject ?? ''."</td>";
                                                        echo "<td>".$performance->sr_ach_percentage."%" ?? ''." </td>";
                                                        echo "<td>".$performance->sr_score." % " ?? ''."</td>";
                                                        $total_score += $performance->sr_score;
                                                    }

                                                    if($kpi_slug == "qr_deployment"){
                                                        echo "<td>".$performance->qrd_target ?? ''."</td>";
                                                        echo "<td>".$performance->qr_deployment ?? ''."</td>";
                                                        echo "<td>".$performance->qrd_ach_percentage."%" ?? ''."</td>";
                                                        echo "<td>".$performance->qrd_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->qrd_score." % " ?? ''."</td>";
                                                        //$total_score += $performance->qrd_score;
                                                    }

                                                    if($kpi_slug == "finally_approved"){
                                                        echo "<td>".$performance->fa_target ?? ''."</td>";
                                                        echo "<td>".$performance->finally_approved ?? ''."</td>";
                                                        echo "<td>".$performance->fa_ach_percentage."%" ?? ''."</td>";
                                                        echo "<td>".$performance->fa_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->fa_score." % " ?? ''."</td>";
                                                        $total_score += $performance->fa_score;
                                                    }

                                                    if($kpi_slug == "unique_merchant_transaction_count"){
                                                        echo "<td>".$performance->umtc_target ?? ''."</td>";
                                                        echo "<td>".$performance->unique_merchant_transaction_count ?? ''."</td>";
                                                        echo "<td>".$performance->umtc_ach_percentage."%" ?? ''."</td>";
                                                        echo "<td>".$performance->umtc_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->umtc_score." % " ?? ''."</td>";
                                                        $total_score += $performance->umtc_score;
                                                    } 

                                                    if($kpi_slug == "high_volume_merchant_count"){
                                                        echo "<td>".$performance->hvmc_target ?? ''."</td>";
                                                        echo "<td>".$performance->high_volume_merchant_count ?? ''."</td>";
                                                        echo "<td>".$performance->hvmc_ach_percentage."%" ?? ''."</td>";
                                                        echo "<td>".$performance->hvmc_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->hvmc_score." % " ?? ''."</td>";
                                                        $total_score += $performance->hvmc_score;
                                                    } 

                                                    if($kpi_slug == "new_merchant_transaction_count"){
                                                        echo "<td>".$performance->nmtc_target ?? ''."</td>";
                                                        echo "<td>".$performance->new_merchant_transaction_count ?? ''."</td>";
                                                        echo "<td>".$performance->nmtc_ach_percentage."%" ?? ''."</td>";
                                                        echo "<td>".$performance->nmtc_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->nmtc_score." % " ?? ''."</td>";
                                                        $total_score += $performance->nmtc_score;
                                                    } 

                                                    if($kpi_slug == "total_transaction_amount"){
                                                        echo "<td>".$performance->tta_target ?? ''."</td>";
                                                        echo "<td>".$performance->total_transaction_amount ?? ''."</td>";
                                                        echo "<td>".$performance->tta_ach_percentage."%" ?? ''."</td>";
                                                        echo "<td>".$performance->tta_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->tta_score." % " ?? ''."</td>";
                                                        $total_score += $performance->tta_score;
                                                    } 

                                                    if($kpi_slug == "non_qr_total_transaction_amount"){
                                                        echo "<td>".$performance->nqrtta_target ?? ''."</td>";
                                                        echo "<td>".$performance->non_qr_total_transaction_amount ?? ''."</td>";
                                                        echo "<td>".$performance->nqrtta_ach_percentage."%" ?? ''."</td>";
                                                        echo "<td>".$performance->nqrtta_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->nqrtta_score." % " ?? ''."</td>";
                                                        $total_score += $performance->nqrtta_score;
                                                    } 

                                                    if($kpi_slug == "subscription_pack_sales_count"){
                                                        echo "<td>".$performance->spsc_target ?? ''."</td>";
                                                        echo "<td>".$performance->subscription_pack_sales_count ?? ''."</td>";
                                                        echo "<td>".$performance->spsc_ach_percentage."%" ?? ''."</td>";
                                                        echo "<td>".$performance->spsc_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->spsc_score." % " ?? ''."</td>";
                                                        echo "<td>".$performance->bronze_count ?? ''."</td>";
                                                        echo "<td>".$performance->silver_count ?? ''."</td>";
                                                        echo "<td>".$performance->gold_count ?? ''."</td>";
                                                        echo "<td>".$performance->platinum_count ?? ''."</td>";
                                                        $total_score += $performance->spsc_score;
                                                    }

                                                    if($kpi_slug == "total_subscription_pack_sales_amount"){
                                                        echo "<td>".$performance->tspsca_target ?? ''."</td>";
                                                        echo "<td>".$performance->total_subscription_pack_sales_amount ?? ''."</td>";
                                                        echo "<td>".$performance->tspsca_ach_percentage."%" ?? ''."</td>";
                                                        echo "<td>".$performance->tspsca_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->tspsca_score." % " ?? ''."</td>";
                                                        $total_score += $performance->tspsca_score;
                                                    }

                                                    if($kpi_slug == "npsb_qr_redeployment_count"){
                                                        echo "<td>".$performance->npsb_qr_target ?? ''."</td>";
                                                        echo "<td>".$performance->npsb_qr_redeployment_count ?? ''."</td>";
                                                        echo "<td>".$performance->npsb_qr_ach_percentage."%" ?? ''."</td>";
                                                        echo "<td>".$performance->npsb_qr_min." % " ?? ''."</td>";
                                                        echo "<td>".$performance->npsb_qr_score." % " ?? ''."</td>";
                                                        $total_score += $performance->npsb_qr_score;
                                                    }                       
                                                    //echo "<td>". $total_score."%" ?? ''."</td>";
                                                }
                                            }
                                            @endphp
                                            <td>{{$total_score ?? ''}} %</td>
                                        </tr>  
                                        @endforeach
                                       
                                    
                                    </tbody>
                                </table>
                                 @endif
                            </div>
                        </div><!--end card-body-->
                    </div><!--end card-->
                </div><!--end col-->
            </div><!--end row-->
        </div>
        <!-- footer -->
    @include('admin.sections.footer')
    <!--end footer-->
    </div>
<!-- end page content -->
@endsection
@section('script')
<script src="{{ asset('assets/admin/plugins/datatables/jquery.dataTables.min.js') }}"></script>
<script src="{{ asset('assets/admin/plugins/datatables/dataTables.bootstrap4.min.js') }}"></script>

<script type="text/javascript">
  $( document ).ready(function() {
    
    $("#example").DataTable({
        "lengthMenu": [[10, 50, 100, 150, -1], [10, 50, 100, 150, "All"]]      
    });

    setTimeout(function() {
        $('#mydiv').fadeOut('fast');
    }, 3000);

    $('input[name="date"]').datepicker({
        format: 'yyyy-mm-dd'
    });

    // $('input[type=checkbox]').change(function() {
    //     if ($(this).is(':checked')) {
    //         $(this).closest('.row').find('.kpiData').show();
    //     } else {
    //         alert("Checkbox is not checked..")
    //     }
    // });
  });
  </script>
@endsection