@php use App\Models\AccTransaksi; use App\Models\UITransaksiReseller; use App\Models\Users; @endphp Laporan Transaksi Reseler Per Marketing
{{ 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') }}

Data Pembayaran Invoice Pelanggan Per Marketing

Unit Instalasi {{ $unit_instalasi->nama_ui }}

Periode {{ tgl_indo($_GET['dari_tgl'])}} s/d {{ tgl_indo($_GET['sampai_tgl']) }}

@php $GroupInvoice = $transaksi_reseller->groupBy('nama_marketing'); $rekap_total_netto = []; @endphp @foreach ($GroupInvoice as $marketing => $transaksi_reseller_detail)

Nama Marketing : {{$marketing}}


@php $total_dpp = 0; $total_ppn11 = 0; $total_net = 0; $sub_total_bhp_uso = 0; $total_adm_midtrans = 0; $total_adm_system = 0; $total_netto = 0; @endphp @foreach ($transaksi_reseller_detail as $row) @php if ($row->payment_type == 'bank_transfer') { $adm_midtrans = 4440; } elseif ($row->payment_type == 'cstore') { $adm_midtrans = 5000; } elseif ($row->payment_type == 'echannel') { $adm_midtrans = 4440; } elseif ($row->payment_type == 'gopay') { $adm_midtrans = ($row->gross_amount * 2) / 100; } elseif ($row->payment_type == 'qris') { $adm_midtrans = ($row->gross_amount * 0.7) / 100; } else { $adm_midtrans = 0; } $bhp_uso = UITransaksiReseller::where('id_menu_ui_transaksi', $row->id_menu_ui_transaksi) ->where('menu_ui_transaksi', 'Biaya BHP+USO') ->first(); $biaya_adm_midtrans = UITransaksiReseller::where('id_menu_ui_transaksi', $row->id_menu_ui_transaksi) ->where('menu_ui_transaksi', 'Payment Gateway') ->first(); $biaya_adm_system = UITransaksiReseller::where('id_menu_ui_transaksi', $row->id_menu_ui_transaksi) ->where('menu_ui_transaksi', 'Biaya Adm. System') ->first(); @endphp @php $total_dpp += $row->gross_amount; $total_ppn11 += $row->tax; $total_net += $row->gross_amount; $sub_total_bhp_uso += $bhp_uso->nominal_ui_transaksi ?? 0; $total_adm_midtrans += $biaya_adm_midtrans->nominal_ui_transaksi; $total_adm_system += $biaya_adm_system->nominal_ui_transaksi; $total_netto += $netto; @endphp @endforeach
No Nama Marketing Teknisi Paket Invoice Tgl. Create Tgl. Bayar Harga Biaya Netto
Nilai Dibayar PPn {{ env('PPN') }}% BHP + USO Metode Bayar Adm Pembayaran Adm System
{{ $loop->index + 1 }} {{ $row->nama }} {{ $row->nama_marketing }} {{ $row->nama_teknisi }} {{ $row->nama_produk }} {{ $row->no_invoice }} {{ tgl_indo($row->tgl_invoice) }} {{ tgl_indo($row->tgl_pembayaran) }} {{ number($row->gross_amount) }} {{ number($row->tax) }} {{ number($bhp_uso->nominal_ui_transaksi ?? 0) }} @if ($row->payment_type == 'gopay') Gopay @elseif ($row->payment_type == 'bank_transfer') Bank Transfer @elseif ($row->payment_type == 'cstore') Alfamart @elseif ($row->payment_type == 'echannel') Bank Mandiri @elseif ($row->payment_type == 'VA') VA Mandiri @else {{ $row->payment_type }} @endif {{ number($biaya_adm_midtrans->nominal_ui_transaksi) }} {{ number($biaya_adm_system->nominal_ui_transaksi) }} {{ number($netto = $row->nilai_dibayar - $biaya_adm_midtrans->nominal_ui_transaksi - $biaya_adm_system->nominal_ui_transaksi - $bhp_uso->nominal_ui_transaksi - $row->tax) }}
Total {{ number($total_dpp) }} {{ number($total_ppn11) }} {{ number($sub_total_bhp_uso) }} {{ number($total_adm_midtrans) }} {{ number($total_adm_system) }} {{ number($total_netto) }}
@php $rekap_total_netto[$marketing] = $total_netto; @endphp @endforeach

Biaya Oprasional Lainnya

@php $total_biaya_pokok = 0; @endphp @foreach ($riwayat_biaya_reseller as $row) @php $total_biaya_pokok += $row->nominal_ui_transaksi; @endphp @endforeach
No Tanggal Keterangan Biaya
Biaya Pokok & Angsuran Hutang
{{ $loop->index + 1 }} {{ tgl_lengkap($row->tgl_transaksi) }} {!! $row->keterangan_ui_transaksi !!} {{ number($row->nominal_ui_transaksi) }}
Total {{ number($total_biaya_pokok) }}