@php use App\Models\PointSales; use App\Models\PointSalesDetail; use App\Models\Invoice; use App\Models\InvoiceDetail; use App\Models\Produk; @endphp Point Of Sales
...
{{env('CORP_NAME')}}
{{{env('CORP_ADDRESS')}}}
Phone: {{ substr(env('CORP_PHONE'), 0, 4) . '-' . substr(env('CORP_PHONE'), 4, 4) . '-' . substr(env('CORP_PHONE'), 8) }} | Whatsapp: {{ substr(env('CORP_WA_FINANCE'), 0, 4) . '-' . substr(env('CORP_WA_FINANCE'), 4, 4) . '-' . substr(env('CORP_WA_FINANCE'), 8) }} | Email: {{env('CORP_EMAIL_CS')}}

Laporan Komisi Marketing Periode : {{ tgl_lengkap($point_sales->pos_dari_tgl) }} s/d {{ tgl_lengkap($point_sales->pos_sampai_tgl) }}

Pelanggan Baru

@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 @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
No Marketing Tgl. Instalasi Pelanggan Biaya instalasi Paket Harga Potongan Bruto Kelebihan Kabel Invoice Tgl. Pembayaran Keterangan
{{ $loop->index + 1 }} {{ $row->nama_marketing }} {{ tgl_indo($row->tgl_pasang) }} {{ $row->jenis_customer }} {{ $row->nama_customer }} {{ number($row->biaya_instalasi) }} {{ $row->nama_produk }} {{ number($row->harga_produk) }} {{ number($row->potongan_biaya) }} {{ number($netto) }} {{ number($row->biaya_kelebihan_kabel) }} {{ $row->no_invoice }} {{ tgl_indo($row->tgl_pembayaran) }} {{ $row->keterangan_point_detail }}
{{ number($total_biaya_instalasi) }} {{ number($total_omzet_kotor) }} {{ number($total_potongan) }} {{ number($total_omset_netto) }} {{ number($total_omset_biaya_kabel) }}

Business Solution

@php $total_omzet_kotor_business_solution = 0; $total_potongan_business_solution = 0; $total_omset_netto_business_solution = 0; @endphp @foreach ($business_solution as $row) @php $total_omzet_kotor_business_solution += $row->harga_produk; $total_potongan_business_solution += $row->potongan_biaya; $total_omset_netto_business_solution += $netto_business_solution; @endphp @endforeach
No Marketing Pelanggan Harga Potongan Netto Invoice Tgl Pembayaran Keterangan
{{ $loop->index + 1 }} {{ $row->nama_marketing }} {{ $row->jenis_customer }} {{ $row->nama_customer }} {{ number($row->harga_produk) }} {{ number($row->potongan_biaya) }} {{ number($netto_business_solution = $row->harga_produk - $row->potongan_biaya) }} {{ $row->no_invoice }} {{ tgl_indo($row->tgl_pembayaran) }} {{ $row->keterangan_point_detail }}
{{ number($total_omzet_kotor_business_solution) }} {{ number($total_potongan_business_solution) }} {{ number($total_omset_netto_business_solution) }}

Upgrade

@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 @php $total_omzet_kotor_upgrade += $row->harga_produk; $total_potongan_upgrade += $row->potongan_biaya; $total_omset_netto_upgrade += $netto_upgrade; @endphp @endforeach
No Marketing Tgl. Acc. Upgrade Pelanggan Paket Lama Paket Baru Harga Potongan Netto Tgl Pembayaran Keterangan
{{ $loop->index + 1 }} {{ $row->nama_marketing }} {{ tgl_indo($row->tgl_upgrade_disetujui) }} {{ $row->jenis_customer }} {{ $row->nama_customer }} {{ $produk_lama->nama_produk }} {{ $produk_baru->nama_produk }} {{ number($row->harga_produk) }} {{ number($row->potongan_biaya) }} {{ number($netto_upgrade = $row->harga_produk - $row->potongan_biaya) }} {{ tgl_indo($row->tgl_pembayaran) }} {{ $row->keterangan_point_detail }}
{{ number($total_omzet_kotor_upgrade) }} {{ number($total_potongan_upgrade) }} {{ number($total_omset_netto_upgrade) }}

Potongan Uninstal & Block > 2 Bulan

@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 @php $omzet_reduction += $row->harga_produk; @endphp @endforeach
No Marketing Tgl. Instalasi Pelanggan Paket Status Harga
{{ $loop->index + 1 }} {{ $row->nama_marketing }} {{ tgl_indo($row->tgl_pasang) }} {{ $row->jenis_customer }} {{ $row->nama_customer }} {{ $row->nama_produk }} {{ $row->status_instalasi }} {{ number($row->harga_produk) }}
{{ number($omzet_reduction) }}



@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
Omzet Bandwidth : {{ number($total_omzet_kotor) }}
Omzet Instalasi : {{ number($total_biaya_instalasi) }}
Omzet Business Solution : {{ number($total_omzet_kotor_business_solution) }}
Omzet Penambahan Kabel : {{ number($total_omset_biaya_kabel) }}
Grandtotal Omzet : {{ number($grandtotal_omzet_kotor = $total_omzet_kotor + $total_biaya_instalasi + $total_omset_biaya_kabel + $total_omzet_kotor_business_solution) }}
Persentase Bonus : {{ $persentase }}%
Total Potongan New Customer : {{ number($total_potongan) }}
Total Potongan Business Solution : {{ number($total_potongan_business_solution) }}
Total Potongan Blokir/Uninstall : {{ number($omzet_reduction) }}
Total NETTO New Customer & Business Solution : {{ number($total_omzet_komisi = $grandtotal_omzet_kotor - ($total_potongan + $omzet_reduction + $total_potongan_business_solution)) }}
Komisi New Customer & Business Solution : {{ number($total_omzet_komisi) }} x {{ $persentase }}% = {{ number($komisi_marketing = ($total_omzet_komisi * $persentase) / 100) }}
Omzet Uprgrade : {{ number($total_omzet_kotor_upgrade) }}<
Total Potongan Upgrade : {{ number($total_potongan_upgrade) }}
Total NETTO Upgrade : {{ number($netto_upgrade_kabel = $total_omset_netto_upgrade) }}
Komisi Upgrade : {{ number($netto_upgrade_kabel) }} x {{ $persentase }}% = {{ number($komisi_marketing_upgrade = ($netto_upgrade_kabel * $persentase) / 100) }}
Total Komisi : {{ number($total_komisi = $komisi_marketing + $komisi_marketing_upgrade); }}
@php $update = PointSales::findOrFail($point_sales->id_jc_point_sales)->update([ 'omzet_bandwith' => $total_omzet_kotor, 'omzet_instalasi' => $total_biaya_instalasi, 'omzet_penambahan_kabel' => $total_omset_biaya_kabel, 'omzet_upgrade' => $total_omzet_kotor_upgrade, 'omzet_kotor' => $grandtotal_omzet_kotor, 'presentase_bonus' => $persentase, 'potongan_new_customer' => $total_potongan, 'potongan_upgrade' => $total_potongan_upgrade, 'netto_new_customer' => $total_omset_netto, 'netto_upgrade' => $total_omset_netto_upgrade, 'grandtotal_netto' => $total_omzet_komisi, 'komisi_marketing' => $total_komisi, ]); @endphp

Omzet Pending

@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 @php $total_harga_produk_pending += $row->harga_produk; $total_biaya_instalasi_pending += $row->biaya_instalasi; @endphp @endforeach
No Marketing Tgl. Instalasi Pelanggan Produk Harga Biaya Instalasi Invoice Status
{{ $loop->index + 1 }} {{ $row->nama_marketing }} {{ tgl_indo($row->tgl_pasang) }} {{ $row->jenis_customer }} {{ $row->nama_customer }} {{ $row->nama_produk }} {{ number($row->harga_produk) }} {{ number($row->biaya_instalasi) }} @if (!empty($invoice->no_invoice)) {{ $invoice->no_invoice }} @endif @if (!empty($invoice->no_invoice)) {{ $invoice->status_invoice }} @endif
{{ number($total_harga_produk_pending) }} {{ number($total_biaya_instalasi_pending) }}