@php
    if ($cek_tahun == date('Y')) {
        $bulan_akhir = date('m');
    } else {
        $bulan_akhir = 12;
    }
@endphp
<div>
    <!-- Page -->
    <div class="page">
        <div class="page-content container-fluid">
            <div class="row" data-plugin="matchHeight" data-by-row="true">

                <div class="col-xl-12 col-md-12">
                    <div class="panel">
                        <div class="panel-heading">
                            <h3 class="panel-title">Technical Management </h3>
                        </div>
                        <div class="panel-body container-fluid">
                            <div class="row row-lg">
                                <div class="col-md-4 col-lg-4">

                                    @if ($jenis_data == 'Periode')
                                        <div class="form-group">
                                            <div class="input-group">
                                                <span class="input-group-prepend">
                                                    <button type="button" class="btn btn-primary">
                                                        <i class="icon md-time" aria-hidden="true"></i> Statistik
                                                        Periode </button>
                                                </span>

                                                <input type="date" wire:model.live="dari_tgl" class="form-control"
                                                    required>
                                                <input type="date" wire:model.live="sampai_tgl" class="form-control"
                                                    required>
                                            </div>
                                            <span wire:loading.delay.shortest class="panel-desc" style="color: red;"><i
                                                    class="icon md-spinner" aria-hidden="true"></i>
                                                <b>Loading.....</b></span>
                                        </div>
                                    @else
                                        <div class="form-group">
                                            <div class="input-group">
                                                <span class="input-group-prepend">
                                                    <button type="button" class="btn btn-primary">
                                                        <i class="icon md-time" aria-hidden="true"></i> Statistik
                                                        Tahun</button>
                                                </span>

                                                <select class="form-control" wire:model.live="cek_tahun">
                                                    <option>2019</option>
                                                    <option>2020</option>
                                                    <option>2021</option>
                                                    <option>2022</option>
                                                    <option>2023</option>
                                                    <option>2024</option>
                                                    <option>2025</option>
                                                    <option>2026</option>
                                                    <option>2027</option>
                                                    <option>2028</option>
                                                    <option>2029</option>
                                                    <option>2030</option>
                                                </select>
                                            </div>

                                        </div>
                                    @endif


                                </div>
                                <div class="col-md-4 col-lg-4"></div>
                                <div class="col-md-4 col-lg-4" align="right">
                                    <div class="form-group">
                                        <div class="input-group">
                                            <span class="input-group-prepend">
                                                <button type="button" class="btn btn-primary">
                                                    <i class="icon md-time" aria-hidden="true"></i> Jenis
                                                    Statistik</button>
                                            </span>

                                            <div class="dropdown">
                                                <button class="btn btn-primary dropdown-toggle" type="button"
                                                    id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true"
                                                    aria-expanded="false">
                                                    Select Jenis
                                                </button>
                                                <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                                    <div class="dropdown-item">
                                                        <input type="checkbox" wire:model.live="statistik_instalasi"
                                                            value="1">
                                                        Installation
                                                    </div>
                                                    <div class="dropdown-item">
                                                        <input type="checkbox" wire:model.live="statistik_point_teknisi"
                                                            value="1" checked>
                                                        Point Of Technician
                                                    </div>

                                                </div>
                                            </div>

                                            <select class="form-control" wire:model.live="jenis_data">
                                                <option>Tahunan</option>
                                                <option>Periode</option>
                                            </select>
                                        </div>
                                    </div>

                                </div>
                            </div>
                        </div>
                    </div>
                </div>


                @if ($jenis_data == 'Tahunan' && $statistik_instalasi == 1)
                    <div class="col-xxl-12 col-lg-12">
                        <!-- Panel Projects Status -->
                        <div class="panel" id="projects-status">
                            <div class="panel-heading">
                                <h3 class="panel-title">
                                    Statistik Instalasi Tahun {{ $cek_tahun }}
                                </h3>
                            </div>
                            <div class="panel-body">
                                <div class="container-fluid">

                                    <div class="row">

                                        <div class="form-group">
                                            <div class="input-group">

                                                <div class="dropdown">
                                                    <button class="btn btn-primary dropdown-toggle" type="button"
                                                        id="dropdownMenuButton" data-toggle="dropdown"
                                                        aria-haspopup="true" aria-expanded="false">
                                                        Select Technician
                                                    </button>
                                                    <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">

                                                        @foreach ($technician_all as $mar)
                                                            <div class="dropdown-item">
                                                                <input type="checkbox" wire:model.live="id_technician"
                                                                    value="{{ $mar->id_users }}">
                                                                {{ $mar->nama }}
                                                            </div>
                                                        @endforeach
                                                    </div>
                                                </div>

                                                <select class="form-control" wire:model.live="status_instalasi">
                                                    <option value="All">All</option>
                                                    <option value="Done">Done</option>
                                                    <option value="Uninstall">Uninstall</option>
                                                    <option value="Blokir">Blokir</option>
                                                    <option value="Pending">Pending</option>
                                                    <option value="Blacklist">Blacklist</option>
                                                </select>
                                            </div>
                                        </div>

                                        <div class="col-xl-12 col-md-12">
                                            <div class="page-invoice-table table-responsive">
                                                <table class="table table-hover">
                                                    <tr>
                                                        <th>Bulan</th>
                                                        @foreach ($technician_check as $row)
                                                            <th>{{ $row->nama }}</th>
                                                        @endforeach
                                                        <th> All Technician </th>
                                                    </tr>
                                                    @php
                                                        $grandtotal_all_cust = 0;
                                                    @endphp
                                                    @for ($x = 1; $x <= $bulan_akhir; $x++)
                                                        <tr>
                                                            <td> {{ bulan_indo($x) }}</td>
                                                            @php
                                                                $total_all_cust = 0;
                                                            @endphp
                                                            @foreach ($technician_check as $row)
                                                                @php
                                                                    $total_all_new = \App\Models\Instalasi::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'instalasi.id_customer',
                                                                    )
                                                                        ->where('instalasi.instalatur', $row->id_users)
                                                                        ->whereMonth('tgl_order', $x)
                                                                        ->whereYear('tgl_order', $cek_tahun)
                                                                        ->count('instalasi.id_instalasi');
                                                                    $total_done = \App\Models\Instalasi::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'instalasi.id_customer',
                                                                    )
                                                                        ->where('instalasi.instalatur', $row->id_users)
                                                                        ->whereMonth('tgl_pasang', $x)
                                                                        ->whereYear('tgl_pasang', $cek_tahun)
                                                                        ->count('instalasi.id_instalasi');
                                                                    $total_blokir = \App\Models\Instalasi::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'instalasi.id_customer',
                                                                    )
                                                                        ->where('instalasi.instalatur', $row->id_users)
                                                                        ->where('status_instalasi', 'Blokir')
                                                                        ->whereMonth('tgl_pasang', $x)
                                                                        ->whereYear('tgl_pasang', $cek_tahun)
                                                                        ->count('instalasi.id_instalasi');
                                                                    $total_blacklist = \App\Models\Instalasi::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'instalasi.id_customer',
                                                                    )
                                                                        ->where('instalasi.instalatur', $row->id_users)
                                                                        ->where('status_instalasi', 'Blacklist')
                                                                        ->whereMonth('tgl_pasang', $x)
                                                                        ->whereYear('tgl_pasang', $cek_tahun)
                                                                        ->count('instalasi.id_instalasi');
                                                                    $total_pending = \App\Models\Instalasi::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'instalasi.id_customer',
                                                                    )
                                                                        ->where('instalasi.instalatur', $row->id_users)
                                                                        ->where('tgl_order', 'Pending')
                                                                        ->whereMonth('tgl_order', $x)
                                                                        ->whereYear('tgl_order', $cek_tahun)
                                                                        ->count('instalasi.id_instalasi');
                                                                    $total_failed = \App\Models\Instalasi::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'instalasi.id_customer',
                                                                    )
                                                                        ->where('instalasi.instalatur', $row->id_users)
                                                                        ->where('status_instalasi', 'Failed')
                                                                        ->whereMonth('tgl_order', $x)
                                                                        ->whereYear('tgl_order', $cek_tahun)
                                                                        ->count('instalasi.id_instalasi');
                                                                    $total_uninstall = \App\Models\Instalasi::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'instalasi.id_customer',
                                                                    )
                                                                        ->where('instalasi.instalatur', $row->id_users)
                                                                        ->where('status_instalasi', 'Uninstall')
                                                                        ->whereMonth('tgl_uninstal', $x)
                                                                        ->whereYear('tgl_uninstal', $cek_tahun)
                                                                        ->count('instalasi.id_instalasi');

                                                                    if ($status_instalasi == 'All') {
                                                                        $total_cust = $total_all_new;
                                                                    } elseif ($status_instalasi == 'Done') {
                                                                        $total_cust = $total_done;
                                                                    } elseif ($status_instalasi == 'Pending') {
                                                                        $total_cust = $total_pending;
                                                                    } elseif ($status_instalasi == 'Failed') {
                                                                        $total_cust = $total_failed;
                                                                    } elseif ($status_instalasi == 'Uninstall') {
                                                                        $total_cust = $total_uninstall;
                                                                    } elseif ($status_instalasi == 'Blokir') {
                                                                        $total_cust = $total_blokir;
                                                                    } elseif ($status_instalasi == 'Blacklist') {
                                                                        $total_cust = $total_blokir;
                                                                    } elseif ($status_instalasi == 'Blacklist') {
                                                                        $total_cust = $total_blacklist;
                                                                    }
                                                                @endphp
                                                                @if ($total_cust > 0)
                                                                    <td style="color: green; font-weight:bold;">
                                                                        {{ number($total_cust) }}</td>
                                                                @else
                                                                    <td>0</td>
                                                                @endif
                                                                @php
                                                                    $total_all_cust += $total_cust;
                                                                @endphp
                                                            @endforeach
                                                            <td>{{ number($total_all_cust) }}</td>
                                                        </tr>
                                                        @php
                                                            $grandtotal_all_cust += $total_all_cust;
                                                        @endphp
                                                    @endfor
                                                    <tr>
                                                        <td style="font-weight: bold;">Total</td>
                                                        @foreach ($technician_check as $row)
                                                            @if ($status_instalasi == 'All')
                                                                @php

                                                                    $sub_total_customer = \App\Models\Instalasi::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'instalasi.id_customer',
                                                                    )
                                                                        ->where('instalasi.instalatur', $row->id_users)
                                                                        ->whereYear('tgl_order', $cek_tahun)
                                                                        ->count('instalasi.id_instalasi');
                                                                @endphp
                                                            @else
                                                                @php
                                                                    $sub_total_customer = \App\Models\Instalasi::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'instalasi.id_customer',
                                                                    )
                                                                        ->where('instalasi.instalatur', $row->id_users)
                                                                        ->where('status_instalasi', $status_instalasi)
                                                                        ->whereYear('tgl_order', $cek_tahun)
                                                                        ->count('instalasi.id_instalasi');
                                                                @endphp
                                                            @endif

                                                            <td style="font-weight:bold;">{{ $sub_total_customer }}
                                                            </td>
                                                        @endforeach
                                                        <td style="font-weight:bold; color:green;">
                                                            {{ $grandtotal_all_cust }} </td>
                                                    </tr>
                                                </table>
                                            </div>
                                        </div>

                                    </div>
                                </div>
                            </div>

                        </div>
                    </div>
                @endif

                @if ($jenis_data == 'Tahunan' && $statistik_tiket_teknisi == 1)
                    <div class="col-xxl-12 col-lg-12">
                        <div class="panel" id="projects-status">
                            <div class="panel-heading">
                                <h3 class="panel-title">
                                    Statistik Tiket <span style="font-weight: bold;"> "{{ $select_tipe_tiket }}" </span> Tahun {{ $cek_tahun }}
                                </h3>
                            </div>
                            <div class="panel-body">
                                <div class="container-fluid">

                                    <div class="row">

                                        <div class="form-group">
                                            <div class="input-group">

                                                <div class="dropdown">
                                                    <button class="btn btn-primary dropdown-toggle" type="button"
                                                        id="dropdownMenuButton" data-toggle="dropdown"
                                                        aria-haspopup="true" aria-expanded="false">
                                                        Select Technician
                                                    </button>
                                                    <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">

                                                        @foreach ($technician_all as $mar)
                                                            <div class="dropdown-item">
                                                                <input type="checkbox" wire:model.live="id_technician"
                                                                    value="{{ $mar->id_users }}">
                                                                {{ $mar->nama }}
                                                            </div>
                                                        @endforeach
                                                    </div>
                                                </div>
                                                <select class="form-control" wire:model.live="cek_tahun">
                                                    <option value="Instalasi">Instalasi</option>
                                                    <option value="Survey">Survey</option>
                                                    <option value="Support">Support</option>
                                                    <option value="Uninstall">Uninstall</option>
                                                    <option value="Action POP">Action POP</option>
                                                    <option value="Change Paket">Change Paket</option>
                                                    <option value="Internet DC">Internet DC</option>
                                                    <option value="Reinstall">Reinstall</option>
                                                </select>

                                                <div class="dropdown">
                                                    <button class="btn btn-primary dropdown-toggle" type="button"
                                                        id="dropdownMenuButton" data-toggle="dropdown"
                                                        aria-haspopup="true" aria-expanded="false">
                                                        Select Status Tiket
                                                    </button>
                                                    <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">

                                                            <div class="dropdown-item">
                                                                <input type="checkbox" wire:model.live="status_tiket"
                                                                    value="Close" checked>
                                                                Close
                                                            </div>
                                                            <div class="dropdown-item">
                                                                <input type="checkbox" wire:model.live="status_tiket"
                                                                    value="On Progress" checked>
                                                                On Progress
                                                            </div>
                                                            <div class="dropdown-item">
                                                                <input type="checkbox" wire:model.live="status_tiket"
                                                                    value="Open" checked>
                                                                Open
                                                            </div>

                                                        </div>
                                                </div>
                                            </div>
                                        </div>

                                        <div class="col-xl-12 col-md-12">
                                            <div class="page-invoice-table table-responsive">
                                                <table class="table table-hover">
                                                    <tr>
                                                        <th>Bulan</th>
                                                        <th>Status</th>
                                                        @foreach ($technician_check as $row)
                                                            <th><b>{{ explode(' ', $row->nama)[0] }}</b></th>
                                                        @endforeach
                                                    </tr>
                                                    @for ($x = 1; $x <= $bulan_akhir; $x++)
                                                        @foreach ($status_tiket as $mar)

                                                        <tr>

                                                            <td>{{ bulan_indo($x) }}</td>


                                                            <td>{{ $mar }}</td>
                                                            @foreach ($technician_check as $row)
                                                                @php
                                                                    $tiket_close_teknisi = \App\Models\Tiket::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'tiket.id_customer',
                                                                    )
                                                                        ->join(
                                                                            'pekerjaan',
                                                                            'pekerjaan.id_tiket',
                                                                            'tiket.id_tiket',
                                                                        )
                                                                        ->whereMonth('tiket.created_at', $x)
                                                                        ->whereYear('tiket.created_at', $cek_tahun)
                                                                        ->where('tiket.status_tiket', $mar)
                                                                        ->where('tiket.tipe_tiket', $select_tipe_tiket)
                                                                        ->where('pekerjaan.id_users', $row->id_users)
                                                                        ->count('id_pekerjaan');
                                                                @endphp

                                                                @if ($tiket_close_teknisi == 0)
                                                                    <td>
                                                                        {{ $tiket_close_teknisi }}</td>
                                                                @else
                                                                    <td style="font-weight: bold;  color:red;">
                                                                        {{ $tiket_close_teknisi }}</td>
                                                                @endif
                                                            @endforeach
                                                        </tr>
                                                        @endforeach

                                                    @endfor


                                                </table>
                                            </div>
                                        </div>

                                    </div>
                                </div>
                            </div>

                        </div>
                    </div>

                    <div class="col-xxl-12 col-lg-12">
                        <div class="panel" id="projects-status">
                            <div class="panel-heading">
                                <h3 class="panel-title">
                                    Statistik Tiket Teknisi Tahun {{ $cek_tahun }}
                                </h3>
                            </div>
                            <div class="panel-body">
                                <div class="container-fluid">

                                    <div class="row">

                                        <div class="form-group">
                                            <div class="input-group">

                                                <div class="dropdown">
                                                    <button class="btn btn-primary dropdown-toggle" type="button"
                                                        id="dropdownMenuButton" data-toggle="dropdown"
                                                        aria-haspopup="true" aria-expanded="false">
                                                        Select Technician
                                                    </button>
                                                    <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">

                                                        @foreach ($technician_all as $mar)
                                                            <div class="dropdown-item">
                                                                <input type="checkbox" wire:model.live="id_technician"
                                                                    value="{{ $mar->id_users }}">
                                                                {{ $mar->nama }}
                                                            </div>
                                                        @endforeach
                                                    </div>
                                                </div>

                                                <div class="dropdown">
                                                    <button class="btn btn-primary dropdown-toggle" type="button"
                                                        id="dropdownMenuButton" data-toggle="dropdown"
                                                        aria-haspopup="true" aria-expanded="false">
                                                        Select Tipe Tiket
                                                    </button>
                                                    <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Instalasi">
                                                            Instalasi
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Survey" checked>
                                                            Survey
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Uninstall">
                                                            Uninstall
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Maintenance">
                                                            Maintenance
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Support">
                                                            Support
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Change Paket">
                                                            Change Paket
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Event BOD">
                                                            Event BOD
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Instal Gagal">
                                                            Instal Gagal
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Internet DC">
                                                            Internet DC
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Internet Lambat">
                                                            Internet Lambat
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Lembur">
                                                            Lembur
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="New Business Solution">
                                                            New Business Solution
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="OpenQuota">
                                                            OpenQuota
                                                        </div>
                                                        <div class="dropdown-item">
                                                            <input type="checkbox" wire:model.live="var_tipe_tiket"
                                                                value="Pengaduan">
                                                            Pengaduan
                                                        </div>

                                                    </div>
                                                </div>
                                            </div>
                                        </div>

                                        <div class="col-xl-12 col-md-12">
                                            <div class="page-invoice-table table-responsive">
                                                <table class="table table-hover">
                                                    <tr>
                                                        <th>Tipe</th>
                                                        <th>Status</th>
                                                        @foreach ($technician_check as $row)
                                                            <th><b>{{ explode(' ', $row->nama)[0] }}</b></th>
                                                        @endforeach
                                                    </tr>
                                                    @foreach ($tipe_tiket as $tipe)
                                                        <tr>
                                                            <td rowspan="3">{{ $tipe->tipe_tiket }}</td>
                                                            <td>Close </td>
                                                            @foreach ($technician_check as $row)
                                                                @php
                                                                    $tiket_close_teknisi = \App\Models\Tiket::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'tiket.id_customer',
                                                                    )
                                                                        ->join(
                                                                            'pekerjaan',
                                                                            'pekerjaan.id_tiket',
                                                                            'tiket.id_tiket',
                                                                        )
                                                                        ->whereYear('tiket.created_at', $cek_tahun)
                                                                        ->where('tiket.status_tiket', 'Close')
                                                                        ->where('tiket.tipe_tiket', $tipe->tipe_tiket)
                                                                        ->where('pekerjaan.id_users', $row->id_users)
                                                                        ->count('id_pekerjaan');
                                                                @endphp

                                                                @if ($tiket_close_teknisi == 0)
                                                                    <td>
                                                                        {{ $tiket_close_teknisi }}</td>
                                                                @else
                                                                    <td style="font-weight: bold;  color:red;">
                                                                        {{ $tiket_close_teknisi }}</td>
                                                                @endif
                                                            @endforeach
                                                        </tr>
                                                        <tr>
                                                            <td>On Progress</td>
                                                            @foreach ($technician_check as $row)
                                                                @php
                                                                    $tiket_progress_teknisi = \App\Models\Tiket::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'tiket.id_customer',
                                                                    )
                                                                        ->join(
                                                                            'pekerjaan',
                                                                            'pekerjaan.id_tiket',
                                                                            'tiket.id_tiket',
                                                                        )
                                                                        ->whereYear('tiket.created_at', $cek_tahun)
                                                                        ->where('tiket.status_tiket', 'On Progress')
                                                                        ->where('tiket.tipe_tiket', $tipe->tipe_tiket)
                                                                        ->where('pekerjaan.id_users', $row->id_users)
                                                                        ->count('id_pekerjaan');
                                                                @endphp
                                                                @if ($tiket_progress_teknisi == 0)
                                                                    <td>
                                                                        {{ $tiket_progress_teknisi }}</td>
                                                                @else
                                                                    <td style="font-weight: bold;  color:orange;">
                                                                        {{ $tiket_progress_teknisi }}</td>
                                                                @endif
                                                            @endforeach
                                                        </tr>
                                                        <tr>
                                                            <td>Open</td>
                                                            @foreach ($technician_check as $row)
                                                                @php
                                                                    $tiket_open_teknisi = \App\Models\Tiket::join(
                                                                        'customer',
                                                                        'customer.id_customer',
                                                                        'tiket.id_customer',
                                                                    )
                                                                        ->join(
                                                                            'pekerjaan',
                                                                            'pekerjaan.id_tiket',
                                                                            'tiket.id_tiket',
                                                                        )
                                                                        ->whereYear('tiket.created_at', $cek_tahun)
                                                                        ->where('tiket.status_tiket', 'Open')
                                                                        ->where('tiket.tipe_tiket', $tipe->tipe_tiket)
                                                                        ->where('pekerjaan.id_users', $row->id_users)
                                                                        ->count('id_pekerjaan');
                                                                @endphp
                                                                @if ($tiket_open_teknisi == 0)
                                                                    <td>
                                                                        {{ $tiket_open_teknisi }}</td>
                                                                @else
                                                                    <td style="font-weight: bold;  color:green;">
                                                                        {{ $tiket_open_teknisi }}</td>
                                                                @endif
                                                            @endforeach
                                                        </tr>
                                                    @endforeach


                                                </table>
                                            </div>
                                        </div>

                                    </div>
                                </div>
                            </div>

                        </div>
                    </div>
                @endif

                @if ($jenis_data == 'Tahunan' && $statistik_point_teknisi == 1)
                    <div class="col-xxl-12 col-lg-12">
                        <!-- Panel Projects Status -->
                        <div class="panel" id="projects-status">
                            <div class="panel-heading">
                                <h3 class="panel-title">
                                    Statistik Point Teknisi Tahun {{ $cek_tahun }}
                                </h3>
                            </div>
                            <div class="panel-body">
                                <div class="container-fluid">

                                    <div class="row">

                                        <div class="form-group">
                                            <div class="input-group">

                                                <div class="dropdown">
                                                    <button class="btn btn-primary dropdown-toggle" type="button"
                                                        id="dropdownMenuButton" data-toggle="dropdown"
                                                        aria-haspopup="true" aria-expanded="false">
                                                        Select Technician
                                                    </button>
                                                    <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">

                                                        @foreach ($technician_all as $mar)
                                                            <div class="dropdown-item">
                                                                <input type="checkbox" wire:model.live="id_technician"
                                                                    value="{{ $mar->id_users }}">
                                                                {{ $mar->nama }}
                                                            </div>
                                                        @endforeach
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

                                        <div class="col-xl-12 col-md-12">
                                            <div class="page-invoice-table table-responsive">
                                                <table class="table table-hover">
                                                    <tr>
                                                        <th>Bulan</th>
                                                        @foreach ($technician_check as $row)
                                                            <th>{{ $row->nama }}</th>
                                                        @endforeach
                                                    </tr>
                                                    @php
                                                        $grandtotal_all_cust = 0;
                                                    @endphp
                                                    @for ($x = 1; $x <= $bulan_akhir; $x++)
                                                        <tr>
                                                            <td> {{ bulan_indo($x) }}</td>
                                                            @foreach ($technician_check as $row)
                                                                @php
                                                                    $total_point = \App\Models\PointTeknisi::join(
                                                                        'tiket',
                                                                        'tiket.id_tiket',
                                                                        'jc_point_teknisi.id_tiket',
                                                                    )
                                                                        ->join(
                                                                            'pekerjaan',
                                                                            'pekerjaan.id_tiket',
                                                                            'jc_point_teknisi.id_tiket',
                                                                        )
                                                                        ->join(
                                                                            'users',
                                                                            'users.id_users',
                                                                            'pekerjaan.id_users',
                                                                        )
                                                                        ->whereNull('pekerjaan.deleted_at')
                                                                        ->whereMonth('pekerjaan.tgl_selesai', $x)
                                                                        ->whereYear('pekerjaan.tgl_selesai', $cek_tahun)
                                                                        ->where('users.id_users', $row->id_users)
                                                                        ->sum('jc_point_teknisi.point_teknisi');
                                                                @endphp
                                                                <td>{{ $total_point }}</td>
                                                            @endforeach
                                                        </tr>
                                                    @endfor
                                                    <tr>
                                                        <td>Total</td>
                                                        @foreach ($technician_check as $row)
                                                            @php
                                                                $sub_total_point = \App\Models\PointTeknisi::join(
                                                                    'tiket',
                                                                    'tiket.id_tiket',
                                                                    'jc_point_teknisi.id_tiket',
                                                                )
                                                                    ->join(
                                                                        'pekerjaan',
                                                                        'pekerjaan.id_tiket',
                                                                        'jc_point_teknisi.id_tiket',
                                                                    )
                                                                    ->join(
                                                                        'users',
                                                                        'users.id_users',
                                                                        'pekerjaan.id_users',
                                                                    )
                                                                    ->whereNull('pekerjaan.deleted_at')
                                                                    ->where('users.id_users', $row->id_users)
                                                                    ->sum('jc_point_teknisi.point_teknisi');
                                                            @endphp
                                                            <td style="font-weight: bold;">{{ $sub_total_point }}</td>
                                                        @endforeach
                                                    </tr>

                                                </table>
                                            </div>
                                        </div>

                                    </div>
                                </div>
                            </div>

                        </div>
                    </div>
                @endif


            </div>
        </div>
    </div>
    <!-- End Page -->



</div>