@php
    use App\Models\InvoiceDetail;
    use App\Models\Users;
@endphp

<div>
    <!-- Page -->
    <div class="page">
        <div class="page-header">
            <h1 class="page-title">Data Komisi Marketing Freelance</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 Komisi Marketing Freelance</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 Komisi Marketing Freelance
                                @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">
                                @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>Marketing</th>
                                        <th>Customer</th>
                                        <th>Invoice</th>
                                        <th>Produk</th>
                                        <th>Harga</th>
                                        <th>Biaya Sewa</th>
                                        <th>Fee Freelance</th>
                                        <th>Netto Omzet</th>
                                        <th>Komisi PIC</th>
                                        <th>Tgl. Pembayaran</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($data as $ftr)
                                    @php
                                        $invoice_detail_freelance = InvoiceDetail::where('id_invoice', $ftr->id_invoice)->where('id_produk', $ftr->id_produk)->first();

                                        // marketing freelancee
                                        $marketing = users::where('id_users', $ftr->id_marketing)->first();
                                
                                        if(!empty($invoice_detail_freelance)){
                                            $qty_detail_freelance = $invoice_detail_freelance->qty_detail;
                                        } else {
                                            $qty_detail_freelance = 0;
                                        }

                                        $total_harga = $ftr->harga_produk * $qty_detail_freelance;
                                    @endphp
                                
                                    <tr>
                                        <td>{{ $loop->index + 1 }}</td>
                                        <td>
                                            {{ $marketing->nama }} <br>
                                            PIC : {{ $ftr->nama_marketing}}
                                        </td>
                                        <td>{{ $ftr->nama_customer }}</td>
                                        <td>
                                            <a href="/invoice/{{ $ftr->id_invoice }}" target="_blank">
                                                <button type="button"
                                                    class="btn btn-sm btn-icon btn-primary btn-round"
                                                    data-toggle="tooltip" data-original-title="Edit">
                                                    <i class="icon md-print" aria-hidden="true"></i>
                                                    {{ $ftr->no_invoice }}
                                                </button></a>
                                        </td>
                                        <td>{{ $ftr->nama_produk }}</td>
                                        <td>{{ rupiah($total_harga) }}</td>
                                        <td>{{ rupiah($potongan_produk = $ftr->sewa_lainnya - $ftr->biaya_metroe) }}</td>
                                        <td>{{ rupiah($potongan_freelance = ($total_harga - $potongan_produk) * $ftr->persentase_fee / 100) }} ({{ $ftr->persentase_fee }}%)</td>
                                        <td>{{ rupiah($netto_freelance = $total_harga - $potongan_freelance - $potongan_produk) }}</td>
                                        <td>{{ rupiah( ($netto_freelance * 15 ) / 100 ) }}  (15%)</td>
                                        <td>{{ tgl_indo($ftr->tgl_transaksi)." ".time_explode($ftr->tgl_transaksi) }}</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>