@php use App\Models\MarketingTarget; use App\Models\ReportKomisiSales; $marketingTarget = MarketingTarget::join('users', 'users.id_users', 'marketing_target.id_users')->orderBy('users.nama', 'DESC')->get(); @endphp Laporan Komisi Marketing {{-- Kop Surat --}}

Telp: {{ env('CORP_PHONE') }} | Email: {{ env('CORP_EMAIL_CS') }}

@foreach ($marketingTarget as $row)

Nama Marketing : {{ $row->nama }}

@php $reportKomisi = ReportKomisiSales::where('id_marketing', $row->id_users) ->orderBy('tgl_periode_start')->get(); @endphp @foreach ($reportKomisi as $row) @endforeach

Periode	Target	Omzet					BRUTO	Kom. %	Potongan			NETTO	Komisi	Penc. %	Komisi Upgrade				> 1 Th		Diterima
Periode	Target	Instalasi	BW	Business	Kabel	Freelance	BRUTO	Kom. %	New	Business	Blokir	NETTO	Komisi	Penc. %	Omzet	Potong	NETTO	Komisi	Omzet	Komisi	Diterima
{{ acc_date($row->tgl_periode_start) }} - {{ acc_date($row->tgl_periode_end) }}	{{ number($row->target_omzet) }}	{{ number($row->omzet_instalasi) }}	{{ number($row->omzet_bandwith) }}	{{ number($row->omzet_business_solution) }}	{{ number($row->omzet_penambahan_kabel) }}	{{ number($row->omzet_marketing_freelance) }}	{{ number($row->grandtotal_omzet_kotor) }}	{{ number($row->persentase_bonus) }}%	{{ number($row->potongan_new_customer) }}	{{ number($row->potongan_business_solution) }}	{{ number($row->potongan_blokir_uninstall) }}	{{ number($row->netto_omzet) }}	{{ number($row->total_komisi_penjualan) }}	{{ number($row->persentase_pencapaian_target) }}%	{{ number($row->omzet_upgrade) }}	{{ number($row->potongan_upgrade) }}	{{ number($row->netto_upgrade) }}	{{ number($row->total_komisi_upgrade) }}	{{ number($row->omzet_berlangganan_more1years) }}	{{ number($row->komisi_berlangganan_more1years) }}	{{ number($row->grandtotal_komsi_sales) }}

@endforeach

{{ env('CORP_NAME') }}

Nama Marketing : {{ $row->nama }}