Dashboard Reseller

@php $grandtotal_invoice = 0; $grandtotal_invoice_pending = 0; $grandtotal_invoice_lunas = 0; $grandtotal_invoice_omzet = 0; $grandtotal_invoice_dibayar = 0; $grandtotal_pembayaran_piutang = 0; $grandtotal_biaya_reseller = 0; $grandtotal_biaya_ppn11 = 0; $grandtotal_biaya_bhpuso = 0; $grandtotal_biaya_payment_gateway = 0; $grandtotal_biaya_adm_system = 0; $grandtotal_biaya_wa_blast = 0; $grandtotal_biaya_ter = 0; $grandtotal_payout_fee = 0; $grandtotal_ditarik = 0; $grandtotal_saldo_awal = 0; $grandtotal_debit = 0; $grandtotal_kredit = 0; $grandtotal_saldo_akhir = 0; $grandtotal_bisa_withdraw = 0; @endphp @foreach ($unit_instalasi as $row) @php $total_invoice = Invoice::where( 'invoice.id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_invoice', '>=', $dari_tgl) ->whereDate('tgl_invoice', '<=', $sampai_tgl) ->count('id_invoice'); $total_invoice_no_settlement = Invoice::where( 'invoice.id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_invoice', '>=', $dari_tgl) ->whereDate('tgl_invoice', '<=', $sampai_tgl) ->where('status_invoice', '!=', 'settlement') ->count('id_invoice'); $total_invoice_settlement = Invoice::where( 'invoice.id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_invoice', '>=', $dari_tgl) ->whereDate('tgl_invoice', '<=', $sampai_tgl) ->where('status_invoice', 'settlement') ->count('id_invoice'); $omset_full = Invoice::where('id_unit_instalasi', $row->id_unit_instalasi) ->whereDate('tgl_invoice', '>=', $dari_tgl) ->whereDate('tgl_invoice', '<=', $sampai_tgl) ->sum('gross_amount'); $omset_dibayar = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'Invoice Penjualan') ->sum('nominal_ui_transaksi'); $pembayaran_piutang = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'Pembayaran Piutang') ->sum('nominal_ui_transaksi'); $biaya_reseller = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'Biaya Reseller') ->sum('nominal_ui_transaksi'); $ppn11 = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'Biaya PPn') ->sum('nominal_ui_transaksi'); $bhp_uso = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'Biaya BHP+USO') ->sum('nominal_ui_transaksi'); $payment_gateway = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'Payment Gateway') ->sum('nominal_ui_transaksi'); $adm_system = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'Biaya Adm. System') ->sum('nominal_ui_transaksi'); $wa_blast = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'WA Blast') ->sum('nominal_ui_transaksi'); $biaya_pajak_ter = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'Biaya Pajak TER') ->sum('nominal_ui_transaksi'); $payout_fee = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'Payout Fee') ->sum('nominal_ui_transaksi'); $penarikan_dana = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->whereDate('tgl_transaksi', '>=', $dari_tgl) ->whereDate('tgl_transaksi', '<=', $sampai_tgl) ->where('menu_ui_transaksi', 'Penarikan Dana') ->sum('nominal_ui_transaksi'); $total_debit_periode_sebelumnya = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->where('jenis_ui_transaksi', 'Debit') ->where('tgl_transaksi', '<', $dari_tgl) ->where('id_unit_instalasi', '!=', 1) ->sum('nominal_ui_transaksi'); $total_kredit_periode_sebelumnya = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->where('jenis_ui_transaksi', 'Kredit') ->where('tgl_transaksi', '<', $dari_tgl) ->where('id_unit_instalasi', '!=', 1) ->sum('nominal_ui_transaksi'); $saldo_periode_sebelumnya = $total_debit_periode_sebelumnya - $total_kredit_periode_sebelumnya; $total_debit = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->where('jenis_ui_transaksi', 'Debit') ->where('tgl_transaksi', '<=', $sampai_tgl) ->sum('nominal_ui_transaksi'); $total_kredit = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->where('jenis_ui_transaksi', 'Kredit') ->where('tgl_transaksi', '<=', $sampai_tgl) ->sum('nominal_ui_transaksi'); $saldo_reseller = $total_debit - $total_kredit; $total_debit_periode = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->where('jenis_ui_transaksi', 'Debit') ->whereDate('ui_transaksi_reseller.tgl_transaksi', '>=', $dari_tgl) ->whereDate('ui_transaksi_reseller.tgl_transaksi', '<=', $sampai_tgl) ->sum('nominal_ui_transaksi'); $total_kredit_periode = UITransaksiReseller::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->where('jenis_ui_transaksi', 'Kredit') ->whereDate('ui_transaksi_reseller.tgl_transaksi', '>=', $dari_tgl) ->whereDate('ui_transaksi_reseller.tgl_transaksi', '<=', $sampai_tgl) ->sum('nominal_ui_transaksi'); @endphp @php $grandtotal_invoice += $total_invoice; $grandtotal_invoice_pending += $total_invoice_no_settlement; $grandtotal_invoice_lunas += $total_invoice_settlement; $grandtotal_invoice_omzet += $omset_dibayar; $grandtotal_invoice_dibayar += $pembayaran_piutang; $grandtotal_pembayaran_piutang += $biaya_reseller; $grandtotal_biaya_reseller += $biaya_reseller; $grandtotal_biaya_ppn11 += $ppn11; $grandtotal_biaya_bhpuso += $bhp_uso; $grandtotal_biaya_payment_gateway += $payment_gateway; $grandtotal_biaya_adm_system += $adm_system; $grandtotal_biaya_wa_blast += $wa_blast; $grandtotal_biaya_ter += $biaya_pajak_ter; $grandtotal_payout_fee += $payout_fee; $grandtotal_ditarik += $penarikan_dana; $grandtotal_saldo_awal += $saldo_periode_sebelumnya; $grandtotal_debit += $total_debit_periode; $grandtotal_kredit += $total_kredit_periode; $grandtotal_saldo_akhir += $saldo_reseller; if($saldo_reseller > 0){ $grandtotal_bisa_withdraw += $saldo_reseller; } @endphp @endforeach

No.	Reseller	Invoice				Debit		Kredit									Total
		All	Pending	Lunas	Omzet	Dibayar	Piutang	Biaya Reseller	PPn {{ env('PPN' )}}	BHP+USO 1.75%	Pay. Gateway	Adm. System	WA Blast	TER	Payout Fee	Withdraw	Saldo Awal	Debit	Kredit	Saldo Akhir	Print
{{ $loop->index + 1 }}	{{ $row->nama_ui }}	{{ $total_invoice }}	{{ $total_invoice_no_settlement }}	{{ $total_invoice_settlement }}	{{ number($omset_full) }}	{{ number($omset_dibayar) }}	{{ number($pembayaran_piutang) }}	{{ number($biaya_reseller) }}	{{ number($ppn11) }}	{{ number($bhp_uso) }}	{{ number($payment_gateway) }}	{{ number($adm_system) }}	{{ number($wa_blast) }}	{{ number($biaya_pajak_ter) }}	{{ number($payout_fee) }}	{{ number($penarikan_dana) }}	{{ number($saldo_periode_sebelumnya) }}	{{ number($total_debit_periode) }}	{{ number($total_kredit_periode) }}	@if ($saldo_reseller <= 0) {{ number($saldo_reseller) }} @else {{ number($saldo_reseller) }} @endif
		{{ number($grandtotal_invoice) }}	{{ number($grandtotal_invoice_pending) }}	{{ number($grandtotal_invoice_lunas) }}	{{ number($grandtotal_invoice_omzet) }}	{{ number($grandtotal_invoice_dibayar) }}	{{ number($grandtotal_pembayaran_piutang) }}	{{ number($grandtotal_biaya_reseller) }}	{{ number($grandtotal_biaya_ppn11) }}	{{ number($grandtotal_biaya_bhpuso) }}	{{ number($grandtotal_biaya_payment_gateway) }}	{{ number($grandtotal_biaya_adm_system) }}	{{ number($grandtotal_biaya_wa_blast) }}	{{ number($grandtotal_biaya_ter) }}	{{ number($grandtotal_payout_fee) }}	{{ number($grandtotal_ditarik) }}	{{ number($grandtotal_saldo_awal) }}	{{ number($grandtotal_debit) }}	{{ number($grandtotal_kredit) }}	{{ number($grandtotal_bisa_withdraw) }}