@php
    use App\Models\Produk;
@endphp

<div>
    <!-- Page -->
    <div class="page">
        <div class="page-header">
            <h1 class="page-title">Data Upgrade Paket</h1>
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="">Dashboard</a></li>
                <li class="breadcrumb-item"><a href="javascript:void(0)">Payroll</a></li>
                <li class="breadcrumb-item active">Data Upgrade Paket</li>
            </ol>

            <div class="page-header-actions">

                <button type="button" class="btn btn-sm btn-icon btn-primary btn-round" data-toggle="tooltip"
                    data-original-title="Refresh">
                    <i class="icon md-refresh-alt" aria-hidden="true"></i>
                </button>
            </div>

        </div>

        <div class="page-content container-fluid">
            <div class="row">
                <div class="col-xl-12">
                    <!-- Panel Kitchen Sink -->
                    <div class="panel">
                        <header class="panel-heading">
                            <h3 class="panel-title">
                                Data Upgrade Paket
                                @if (session()->has('pesan'))
                                    <span class="panel-desc" style="color: green;">{{ session('pesan') }}</span>
                                @endif
                                <span class="panel-desc">
                                    {{ env('CORP_BRAND') }}
                                </span>
                            </h3>
                        </header>

                        <div class="panel-body">
                            {{-- <div class="row">
                                <div class="col-xl-6 col-md-6">
                                    <!-- Widget Linearea Two -->
                                    <div class="card card-block p-30 bg-amber-900">
                                        <div class="card-watermark darker font-size-80 m-15"><i class="icon md-ticket-star"
                                                aria-hidden="true"></i></div>
                                        <div class="counter counter-md counter-inverse text-left">
                                            <div class="counter-number-group">
                                                <span class="counter-number"><b>{{ rupiah($counttotal_komisi_10) }}</b> </span>
                                                <span class="counter-number-related text-capitalize"> | Komisi</span>
                                            </div>
                                            <div class="counter-label text-capitalize">Total Komisi 10%</div>
                                        </div>
                                    </div>
                                    <!-- End Widget Linearea Two -->
                                </div>
                                <div class="col-xl-6 col-md-6">
                                    <!-- Widget Linearea Two -->
                                    <div class="card card-block p-30 bg-blue-700">
                                        <div class="card-watermark darker font-size-80 m-15"><i class="icon md-ticket-star"
                                                aria-hidden="true"></i></div>
                                        <div class="counter counter-md counter-inverse text-left">
                                            <div class="counter-number-group">
                                                <span class="counter-number"><b>{{ rupiah($counttotal_komisi_15) }}</b> </span>
                                                <span class="counter-number-related text-capitalize"> | Komisi</span>
                                            </div>
                                            <div class="counter-label text-capitalize">Total Komisi 15%</div>
                                        </div>
                                    </div>
                                    <!-- End Widget Linearea Two -->
                                </div>
                            </div> --}}

                            <div class="row">
                                @if(Auth::user()->level == 'Super Admin' || Auth::user()->id_jc_jabtan == '3')
                                    <div class="form-group form-material col-md-4 col-lg-4">                               
                                        <label class="form-control-label">Marketing</label>
                                        <select wire:model.live="cek_id_marketing" class="form-control" required>
                                            <option value="">Pilih Marketing </option>
                                                                                    </select>
                                    </div>
                                @endif
                                <div class="form-group form-material col-md-10 {{ Auth::user()->level == 'Super Admin' || Auth::user()->id_jc_jabtan == '3' ? 'col-lg-4' : 'col-lg-6' }}">
                                    <label class="form-control-label">Dari Tanggal</label>
                                    <input 
                                        type="date" 
                                        wire:model.live="cek_dari_tgl" 
                                        class="form-control" 
                                        required
                                        @if(Auth::user()->level != 'Super Admin') readonly @endif
                                    >
                                </div>
                                
                                <div class="form-group form-material col-md-10 {{ Auth::user()->level == 'Super Admin' || Auth::user()->id_jc_jabtan == '3' ? 'col-lg-4' : 'col-lg-6' }}">
                                    <label class="form-control-label">Sampai Tanggal</label>
                                    <input 
                                        type="date" 
                                        wire:model.live="cek_sampai_tgl" 
                                        class="form-control" 
                                        required
                                        @if(Auth::user()->level != 'Super Admin') readonly @endif
                                    >
                                </div>
                                
                            </div>

                            <div class="row">                                                                

                                <div class="form-group form-material col-md-2 col-lg-2">
                                    <label class="form-control-label">Data</label>
                                    <select class="form-control" wire:model.live="cek_limit" required>
                                        <option>10</option>
                                        <option>50</option>
                                        <option>100</option>
                                        <option>250</option>
                                        <option>500</option>
                                    </select>
                                </div>

                                <div class="form-group form-material col-md-2 col-lg-2">
                                    <label class="form-control-label">Order</label>
                                    <select class="form-control" wire:model.live="cek_urutan" required>
                                        <option value="DESC">Z-A</option>
                                        <option value="ASC">A-Z</option>
                                    </select>
                                </div>
                                <div class="form-group form-material col-md-2 col-lg-2">
                                    <label class="form-control-label">By</label>
                                    <select class="form-control" wire:model.live="cek_order_by" required>
                                        <option value="instalasi.tgl_pasang">Tgl Instalasi</option>
                                        <option value="instalasi.tgl_pembayaran_instalasi">Tgl Pembayaran</option>
                                        <option value="produk.harga_produk">Harga Produk</option>
                                    </select>
                                </div>

                                <div class="form-group form-material col-md-10 col-lg-6">
                                    <label class="form-control-label">Kata Kunci</label>
                                    <input type="text" wire:model.live="cek_keyword"
                                        placeholder="Ketik Kata Kunci Pencarian..." class="form-control" required>
                                </div>
                            </div>

                            <hr>

                            <table class="table table-hover table-striped w-full">
                                <thead>
                                    <tr>
                                        <th>No</th>
                                        <th>Nama</th>       
                                        <th>Marketing</th>                                 
                                        <th>Tgl. Acc. Upgrade </th>
                                        <th>Paket Lama</th>
                                        <th>Paket Baru</th>
                                        <th>Selisih Harga</th>
                                        <th>Selisih Sewa</th>                                                                      
                                        <th>Netto Komisi</th>
                                        <th>Keterangan</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($data as $row)
                                    @php
                                        $paket_lama = Produk::where('id_produk', $row->id_paket_lama)->first();
                                        $paket_baru = Produk::where('id_produk', $row->id_paket_baru)->first();

                                        $mbps = $paket_baru->kapasitas - $paket_lama->kapasitas;

                                        // biaya selisih metro_e 
                                        $selisih_biaya_metro_e = 24000 * $mbps;
                                    @endphp
                                        <tr wire:key="{{ $row->id_instalasi }}">
                                            <td>{{ $loop->index + 1 }}</td>
                                            <td>
                                                @if ($row->jenis_customer == 'Mr.' || $row->jenis_customer == 'Mrs.')
                                                    <span class="badge badge-info">{{ $row->jenis_customer }}</span>
                                                @else
                                                <span class="badge badge-success">{{ $row->jenis_customer }}</span>
                                                @endif
                                                {{ $row->nama_customer }}
                                            </td>
                                            <td>{{ $row->nama_marketing }}</td>
                                            <td>@if(empty($row->tgl_upgrade_disetujui))
                                                <span class="badge badge-warning">{{ $row->status_upgrade}}</span>
                                                @else
                                                {{ tgl_indo($row->tgl_upgrade_disetujui) }}
                                                @endif
                                            </td>
                                            <td>{{ $paket_lama->nama_produk }} <br>
                                                {{ rupiah($paket_lama->harga_produk) }}
                                            </td>
                                            <td>{{ $paket_baru->nama_produk }} <br>
                                                {{ rupiah($paket_baru->harga_produk) }}
                                            </td>
                                            <td>{{ rupiah($row->selisih_harga) }}</td>  
                                            <td>{{ rupiah($selisih_biaya_metro_e) }}</td>                
                                            <td>{{ rupiah(($selisih_biaya_metro_e * 15) / 100) }}</td>                                              
                                            <td>{{ $row->notes_upgrade }}</td>
                                        </tr>
                                    @endforeach

                                </tbody>
                            </table>
                            <hr>
                            {{ $data->links() }}
                            <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>
                    </div>
                    <!-- End Panel Kitchen Sink -->
                </div>
            </div>
        </div>
    </div>
    <!-- End Page -->

</div>