@php use App\Models\UiKomisiReseller; @endphp Report Penjualan
...

{{ env('CORP_NAME')}}

Data Penjualan
@php function bulan_indo1($bulan) { $arr_bulan = [ '01' => 'Januari', '02' => 'Februari', '03' => 'Maret', '04' => 'April', '05' => 'Mei', '06' => 'Juni', '07' => 'Juli', '08' => 'Agustus', '09' => 'September', '10' => 'Oktober', '11' => 'November', '12' => 'Desember', ]; return $arr_bulan[$bulan]; } @endphp Periode: {{ bulan_indo1($_GET['bulan']) }} {{ $_GET['tahun'] }}


Invoice Lunas

@php $total_dpp = 0; $total_ppn11 = 0; $total_net = 0; $sub_total_bhp_uso = 0; @endphp @php $total_dpp_2 = 0; $total_ppn11_2 = 0; $total_net_2 = 0; $sub_total_bhp_uso_2 = 0; @endphp @foreach ($invoice_1 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; } $adm_system = 4000; @endphp @php $total_dpp += $row->item_details_price; $total_ppn11 += $row->tax; $total_net += $row->gross_amount; $sub_total_bhp_uso += $bhp_uso; @endphp @endforeach @foreach ($invoice_2 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; } $adm_system = 4000; @endphp @php $total_dpp_2 += $row->item_details_price; $total_ppn11_2 += $row->tax; $total_net_2 += $row->gross_amount; $sub_total_bhp_uso_2 += $bhp_uso; @endphp @endforeach
No Unit Instalasi Nama Marketing Teknisi Paket Invoice Faktur Pajak Tgl. Create Tgl. Bayar Harga Biaya
DPP PPn 11% Netto BHP + USO 1,75% Metode Bayar
{{ $loop->index + 1 }} {{ $row->nama_ui }} {{ $row->jenis_customer }} {{ $row->nama }} {{ $row->nama_marketing }} {{ $row->nama_teknisi }} {{ $row->item_details_name }} {{ $row->no_invoice }} {{ tgl_indo($row->tgl_invoice) }} {{ tgl_indo($row->tgl_pembayaran) }} {{ number($row->item_details_price) }} {{ number($row->tax) }} {{ number($row->gross_amount) }} {{ number($bhp_uso = ($row->item_details_price * 1.75) / 100) }} @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
Total {{ number($total_dpp) }} {{ number($total_ppn11) }} {{ number($total_net) }} {{ number($sub_total_bhp_uso) }}
{{ $loop->index + 1 }} {{ $row->nama_ui }} {{ $row->jenis_customer }} {{ $row->nama }} {{ $row->nama_marketing }} {{ $row->nama_teknisi }} {{ $row->item_details_name }} {{ $row->no_invoice }} non pkp {{ tgl_indo($row->tgl_invoice) }} {{ tgl_indo($row->tgl_pembayaran) }} {{ number($row->item_details_price) }} {{ number($row->tax) }} {{ number($row->gross_amount) }} {{ number($bhp_uso = ($row->item_details_price * 1.75) / 100) }} @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
Total {{ number($total_dpp_2) }} {{ number($total_ppn11_2) }} {{ number($total_net_2) }} {{ number($sub_total_bhp_uso_2) }}

Sub Total {{ number($total_dpp_2 + $total_dpp) }} {{ number($total_ppn11_2 + $total_ppn11) }} {{ number($total_net_2 + $total_net) }} {{ number($sub_total_bhp_uso_2 + $sub_total_bhp_uso) }}




NETTO
: {{ number($total_net_2 + $total_net) }}
Faktur pajak (DPP) : {{ number($total_dpp) }}
Non PKP(DPP) : {{ number($total_dpp_2) }}
Total : {{ number($total_dpp_2 + $total_dpp) }}
Pendapatan kotor : {{ number($total_net) }}
Tarif BHP + USO : 1,75%
Tagihan : {{ number($sub_total_bhp_uso) }}
Pendapatan kotor : {{ number($total_net_2) }}
Tarif BHP + USO : 1,75%
Tagihan : {{ number($sub_total_bhp_uso_2) }}
Total Tagihan BHP + USO {{ bulan_indo1($_GET['bulan']) }} {{ $_GET['tahun'] }}
: {{ number($sub_total_bhp_uso + $sub_total_bhp_uso_2) }}