@php
    use App\Models\PointSales;
    use App\Models\PointSalesDetail;
    use App\Models\Invoice;
    use App\Models\InvoiceDetail;
    use App\Models\Produk;

@endphp

<tr>
    <td colspan="12" class="header">{{env('CORP_NAME')}}</td>
</tr>
<tr>
    <td colspan="12" class="header">{{env('CORP_ADDRESS')}}</td>
</tr>
<tr>
    <td colspan="12" class="header">Phone: <span style="color: #0f1fad">{{env('CORP_PHONE')}}</span> | Whatsapp: <span
            style="color: #0f1fad">{{env('CORP_WA_FINANCE')}}</span> | Email: <span style="color: #0f1fad">{{env('CORP_EMAIL_CS')}}</span></td>
</tr>

<tr></tr>
<tr>
    <td colspan="12">Periode : {{ tgl_lengkap($point_sales->pos_dari_tgl) }} s/d
        {{ tgl_lengkap($point_sales->pos_sampai_tgl) }}</td>
</tr>
{{-- pelanggan baru --}}
<table width="100%" border="1" cellspacing="0" cellpadding="0" style="margin: 3px 3px 3px 3px;">
    <tr>
        <td colspan="12" style="font-size: 13px; font-weight: bold">Pelanggan Baru</td>
    </tr>
    <thead>
        <tr style="background:#0f79ad; color:white;">
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">No </th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Marketing</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Tgl. Instalasi</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Pelanggan</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Biaya instalasi</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Paket</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Harga</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Potongan</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Bruto</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Kelebihan Kabel</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Tgl. Pembayaran</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Keterangan</th>

        </tr>
    </thead>
    <tbody>
        @php
            $total_biaya_instalasi = 0;
            $total_omzet_kotor = 0;
            $total_omset_netto = 0;
            $total_omset_biaya_kabel = 0;
            $total_potongan = 0;
        @endphp
        @foreach ($new_customer as $row)
            @php
                if ($row->status_point == 'Rejected') {
                    $netto = 0;
                } else {
                    $netto = $row->harga_produk - $row->potongan_biaya;
                }

            @endphp

            <tr>
                <td style="padding:3px 3px 3px 3px;">{{ $loop->index + 1 }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->nama_marketing }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ tgl_indo($row->tgl_pasang) }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->jenis_customer }} {{ $row->nama_customer }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">{{ $row->biaya_instalasi }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->nama_produk }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">{{ $row->harga_produk }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">{{ $row->potongan_biaya }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">{{ $netto }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">{{ $row->biaya_kelebihan_kabel }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ tgl_indo($row->tgl_pembayaran) }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->keterangan_point_detail }}</td>

            </tr>
            @php
                $total_biaya_instalasi += $row->biaya_instalasi;
                $total_omzet_kotor += $row->harga_produk;
                $total_omset_netto += $netto;
                $total_omset_biaya_kabel += $row->biaya_kelebihan_kabel;
                $total_potongan += $row->potongan_biaya;
            @endphp
        @endforeach
        <tr>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;" align="right">{{ $total_biaya_instalasi }}</td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;" align="right">{{ $total_omzet_kotor }}</td>
            <td style="padding: 3px 3px 3px 3px;" align="right">{{ $total_potongan }}</td>
            <td style="padding: 3px 3px 3px 3px;" align="right">{{ $total_omset_netto }}</td>
            <td style="padding: 3px 3px 3px 3px;" align="right">{{ $total_omset_biaya_kabel }}</td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>

        </tr>

    </tbody>

</table>
{{-- akhir pelanggan baru --}}

{{-- Upgrade --}}
<tr>
    <td colspan="12" rowspan="2" style="font-size: 13px;"></td>
</tr>
<tr></tr>
<table width="100%" border="1" cellspacing="0" cellpadding="0" style="margin: 3px 3px 3px 3px;">
    <tr>
        <td colspan="12" style="font-size: 13px; font-weight: bold">Upgrade</td>
    </tr>
    <thead>
        <tr style="background:#0f79ad; color:white;">
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">No </th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Marketing</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Tgl. Acc. Upgrade</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Pelanggan</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Paket Lama</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Paket Baru</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Harga</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Potongan</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Netto</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Tgl Pembayaran</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Keterangan</th>

        </tr>
    </thead>
    <tbody>
        @php
            $total_omzet_kotor_upgrade = 0;
            $total_potongan_upgrade = 0;
            $total_omset_netto_upgrade = 0;
        @endphp
        @foreach ($upgrade_paket as $row)
            @php
                $produk_lama = Produk::where('id_produk', $row->id_paket_lama)->first();
                $produk_baru = Produk::where('id_produk', $row->id_paket_baru)->first();
            @endphp
            <tr>
                <td style="padding:3px 3px 3px 3px;">{{ $loop->index + 1 }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->nama_marketing }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ tgl_indo($row->tgl_upgrade_disetujui) }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->jenis_customer }} {{ $row->nama_customer }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $produk_lama->nama_produk }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $produk_baru->nama_produk }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">{{ ($row->harga_produk) }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">{{ ($row->potongan_biaya) }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">
                    {{ ($netto_upgrade = $row->harga_produk - $row->potongan_biaya) }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ tgl_indo($row->tgl_pembayaran) }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->keterangan_point_detail }}</td>

            </tr>
            @php
                $total_omzet_kotor_upgrade += $row->harga_produk;
                $total_potongan_upgrade += $row->potongan_biaya;
                $total_omset_netto_upgrade += $netto_upgrade;

            @endphp
        @endforeach
        <tr>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;" align="right">{{ ($total_omzet_kotor_upgrade) }}</td>
            <td style="padding: 3px 3px 3px 3px;" align="right">{{ ($total_potongan_upgrade) }}</td>
            <td style="padding: 3px 3px 3px 3px;" align="right">{{ ($total_omset_netto_upgrade) }}</td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>

        </tr>

    </tbody>

</table>
{{-- akhir upgrade --}}

{{-- akhir Potongan Uninstal & Block > 2 Bulan  --}}
<tr>
    <td colspan="12" rowspan="2" style="font-size: 13px;"></td>
</tr>
<tr></tr>
<table width="100%" border="1" cellspacing="0" cellpadding="0" style="margin: 3px 3px 3px 3px;">
    <tr>
        <td colspan="12" style="font-size: 13px; font-weight: bold">Potongan Uninstal dan Block Lebih Dari 2 Bulan</td>
    </tr>
    <thead>
        <tr style="background:#0f79ad; color:white;">
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">No </th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Marketing</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Tgl. Instalasi</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Pelanggan</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Paket</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Status</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Harga</th>

        </tr>
    </thead>
    <tbody>
        @php
            $omzet_reduction = 0;
            $grandtotal_reduction = 0;
        @endphp
        @foreach ($reduction_customer as $row)
            @php
                if ($row->status_point == 'Rejected') {
                    $netto = 0;
                } else {
                    $netto = $row->harga_produk - $row->potongan_biaya;
                }
                $reduction = 15 / 100;
            @endphp


            <tr>
                <td style="padding:3px 3px 3px 3px;">{{ $loop->index + 1 }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->nama_marketing }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ tgl_indo($row->tgl_pasang) }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->jenis_customer }} {{ $row->nama_customer }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->nama_produk }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->status_instalasi }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">{{ ($row->harga_produk) }}</td>

            </tr>
            @php
            $omzet_reduction += $row->harga_produk;
            @endphp
        @endforeach

        <tr>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;" align="right">{{ ($omzet_reduction) }}</td>

        </tr>

    </tbody>

</table>
{{-- akhir Potongan Uninstal & Block > 2 Bulan --}}

{{-- TOTAL --}}
<tr>
    <td colspan="12" rowspan="2" style="font-size: 13px;"></td>
</tr>
<tr></tr>
<table border="1">
    <tr>
        <td colspan="3">Omzet Bandwidth</td>
        <td colspan="9">: <u>{{ ($total_omzet_kotor) }}</u></td>
    </tr>
    <tr>
        <td colspan="3">Omzet Instalasi</td>
        <td colspan="9">: {{ ($total_biaya_instalasi) }}</td>
    </tr>

    <tr>
        <td colspan="3">Grandtotal Omzet</td>
        <td colspan="9">:
            <b><u>{{ ($grandtotal_omzet_kotor = $total_omzet_kotor + $total_biaya_instalasi + $total_omset_biaya_kabel) }}</u></b>
        </td>
    </tr>

    @php
        if ($grandtotal_omzet_kotor >= 100000000) {
            $persentase = 15;
        } elseif ($grandtotal_omzet_kotor >= 50000000 && $grandtotal_omzet_kotor < 100000000) {
            $persentase = 10;
        } elseif ($grandtotal_omzet_kotor < 50000000) {
            $persentase = 2.5;
        } else {
            $persentase = 0;
        }
    @endphp
    <tr>
        <td colspan="3">Persentase Bonus</td>
        <td colspan="9">: {{ $persentase }}%</td>
    </tr>


    <tr>
        <td colspan="3">Total Potongan New Customer</td>
        <td colspan="9">: {{ ($total_potongan) }}</td>
    </tr>

    <tr>
        <td colspan="3">Total Potongan Blokir/Uninstall</td>
        <td colspan="9">: {{ ($omzet_reduction) }}</td>
    </tr>


    <tr>
        <td colspan="3">Total NETTO New Customer</td>
        <td colspan="9">: {{ ($total_omzet_komisi = $grandtotal_omzet_kotor - ($total_potongan + $omzet_reduction)) }}</td>
    </tr>


    <tr>
        <td colspan="3">Komisi New Customer</td>
        <td colspan="9">: {{ ($total_omzet_komisi) }} x {{ $persentase }}% = <b
                style="color:red;">{{ ($komisi_marketing = ($total_omzet_komisi * $persentase) / 100) }}</b>
        </td>
    </tr>

    <tr>
        <td colspan="12"><hr></td>
    </tr>

    <tr>
        <td colspan="3">Omzet Penambahan Kabel</td>
        <td colspan="9">: {{ ($total_omset_biaya_kabel) }}</td>
    </tr>

    <tr>
        <td colspan="3">Omzet Uprgrade</td>
        <td colspan="9">: {{ ($total_omzet_kotor_upgrade) }}<</td>
    </tr>
    <tr>
        <td colspan="3">Total Potongan Upgrade</td>
        <td colspan="9">: {{ ($total_potongan_upgrade) }}</td>
    </tr>

    <tr>
        <td colspan="3">Total NETTO Penambahan Kabel + Upgrade</td>
        <td colspan="9">: {{ ($netto_upgrade_kabel = $total_omset_netto_upgrade + $total_omset_biaya_kabel) }}</td>
    </tr>

    <tr>
        <td colspan="3">Komisi Penambahan Kabel + Upgrade </td>
        <td colspan="9">: {{ ($netto_upgrade_kabel) }} x {{ $persentase }}% = <b
                style="color:red;">{{ ($komisi_marketing_upgrade = ($netto_upgrade_kabel * $persentase) / 100) }}</b>
        </td>
    </tr>

    <tr>
        <td colspan="12"><hr></td>
    </tr>

    <tr>
        <td colspan="3">Total Komisi</td>
        <td colspan="9">: <b
                style="color:green;">{{ ($total_komisi = $komisi_marketing + $komisi_marketing_upgrade); }}</b>
        </td>
    </tr>

</table>
{{-- akhir total--}}

{{-- Omzet Pending --}}
<tr>
    <td colspan="12" rowspan="2" style="font-size: 13px;"></td>
</tr>
<tr></tr>

<table width="100%" border="1" cellspacing="0" cellpadding="0" style="margin: 3px 3px 3px 3px;">
    <tr>
        <td colspan="12" style="font-size: 13px; font-weight: bold">Omzet Pending</td>
    </tr>
    <thead>
        <tr style="background:#0f79ad; color:white;">
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">No </th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Marketing</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Tgl. Instalasi</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Pelanggan</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Produk</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Harga</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Biaya Instalasi</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Invoice</th>
            <th style="padding: 3px 3px 3px 3px; font-weight: bold">Status</th>

        </tr>
    </thead>
    <tbody>
        @php
            $total_harga_produk_pending = 0;
            $total_biaya_instalasi_pending = 0;
        @endphp

        @foreach ($pos_pending as $row)
            @php
                $invoice = Invoice::where('invoice.id_instalasi', $row->id_instalasi)
                    ->orderBy('created_at', 'ASC')
                    ->first();
            @endphp

            <tr>
                <td style="padding:3px 3px 3px 3px;">{{ $loop->index + 1 }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->nama_marketing }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ tgl_indo($row->tgl_pasang) }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->jenis_customer }} {{ $row->nama_customer }}</td>
                <td style="padding:3px 3px 3px 3px;">{{ $row->nama_produk }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">{{ ($row->harga_produk) }}</td>
                <td style="padding:3px 3px 3px 3px;" align="right">{{ ($row->biaya_instalasi) }}</td>
                <td style="padding:3px 3px 3px 3px;">
                    @if (!empty($invoice->no_invoice))
                        {{ $invoice->no_invoice }}
                    @endif
                </td>
                <td style="padding:3px 3px 3px 3px;">
                    @if (!empty($invoice->no_invoice))
                        {{ $invoice->status_invoice }}
                    @endif
                </td>

            </tr>
            @php
                $total_harga_produk_pending += $row->harga_produk;
                $total_biaya_instalasi_pending += $row->biaya_instalasi;
            @endphp
        @endforeach
        <tr>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px; " align="right">{{ ($total_harga_produk_pending) }}</td>
            <td style="padding: 3px 3px 3px 3px;" align="right">{{ ($total_biaya_instalasi_pending) }}
            </td>
            <td style="padding: 3px 3px 3px 3px;"></td>
            <td style="padding: 3px 3px 3px 3px;"></td>


        </tr>

    </tbody>

</table>