Reseller Management

@if ($jenis_data == 'Periode')

Loading.....

@else

@endif

@if ($jenis_data == 'Periode' && $statistik_debit_kredit == 1)

Statistik Debit & Kredit Tahun {{ $cek_tahun }}

@foreach ($reseller as $row) @php $var_ui = UnitInstalasi::where( 'id_unit_instalasi', $row->id_unit_instalasi, ) ->select( DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='Invoice Penjualan' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as debit_omzet_dibayar", ), DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='Pembayaran Piutang' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as debit_pembayaran_piutang", ), DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='Biaya Reseller' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as kredit_biaya_reseller", ), DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='Biaya PPn' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as kredit_ppn", ), DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='Biaya BHP+USO' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as kredit_bhp_uso", ), DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='Payment Gateway' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as kredit_payment_gateway", ), DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='Biaya Adm. System' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as kredit_adm_system", ), DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='WA Blast' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as kredit_wa_blast", ), DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='Biaya Pajak TER' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as kredit_pajak_ter", ), DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='Payout Fee' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as kredit_payout_fee", ), DB::raw( "(SELECT SUM(nominal_ui_transaksi) FROM ui_transaksi_reseller WHERE ui_transaksi_reseller.id_unit_instalasi=unit_instalasi.id_unit_instalasi AND menu_ui_transaksi='Penarikan Dana' AND tgl_transaksi>='$dari_tgl' AND tgl_transaksi<='$sampai_tgl' AND deleted_at IS NULL) as kredit_withdraw", ), ) ->first(); $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_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'); $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; @endphp @endforeach

No.	Reseller	Debit		Kredit									Total
No.	Reseller	Dibayar	Piutang	Biaya Reseller	PPn 11%	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 }}	{{ number($var_ui->debit_omzet_dibayar) }}	{{ number($var_ui->debit_pembayaran_piutang) }}	{{ number($var_ui->kredit_biaya_reseller) }}	{{ number($var_ui->kredit_ppn) }}	{{ number($var_ui->kredit_bhp_uso) }}	{{ number($var_ui->kredit_payment_gateway) }}	{{ number($var_ui->kredit_adm_system) }}	{{ number($var_ui->kredit_wa_blast) }}	{{ number($var_ui->kredit_pajak_ter) }}	{{ number($var_ui->kredit_payout_fee) }}	{{ number($var_ui->kredit_withdraw) }}	{{ number($saldo_periode_sebelumnya) }}	{{ number($total_debit_periode) }}	{{ number($total_kredit_periode) }}	@if ($saldo_reseller <= 0) {{ number($saldo_reseller) }} @else {{ number($saldo_reseller) }} @endif

@endif @if ($jenis_data == 'Periode' && $statistik_customer_invoice == 1)

Statistik Customer & Invoice {{ $cek_tahun }}

@foreach ($reseller as $row) @php $bandwith = UnitInstalasi::join( 'customer', 'customer.id_customer', 'unit_instalasi.id_customer_ui', ) ->join( 'instalasi', 'instalasi.id_customer', 'customer.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->where( 'unit_instalasi.id_unit_instalasi', $row->id_unit_instalasi, ) ->first(); $customer = Customer::select( DB::raw( "(SELECT COUNT(customer.id_customer) FROM customer JOIN instalasi ON instalasi.id_customer=customer.id_customer WHERE customer.id_unit_instalasi='$row->id_unit_instalasi' AND tgl_pasang>='$dari_tgl' AND tgl_pasang<='$sampai_tgl' AND instalasi.status_instalasi='Done' AND customer.deleted_at IS NULL) as customer_new", ), DB::raw( "(SELECT COUNT(customer.id_customer) FROM customer JOIN instalasi ON instalasi.id_customer=customer.id_customer WHERE customer.id_unit_instalasi='$row->id_unit_instalasi' AND instalasi.status_instalasi='Done' AND customer.deleted_at IS NULL) as customer_active", ), DB::raw( "(SELECT COUNT(customer.id_customer) FROM customer JOIN instalasi ON instalasi.id_customer=customer.id_customer WHERE customer.id_unit_instalasi='$row->id_unit_instalasi' AND instalasi.status_instalasi='Blokir' AND customer.deleted_at IS NULL) as customer_blokir", ), DB::raw( "(SELECT COUNT(customer.id_customer) FROM customer JOIN instalasi ON instalasi.id_customer=customer.id_customer WHERE customer.id_unit_instalasi='$row->id_unit_instalasi' AND instalasi.status_instalasi='Uninstall' AND customer.deleted_at IS NULL) as customer_uninstall", ), DB::raw( "(SELECT COUNT(customer.id_customer) FROM customer JOIN instalasi ON instalasi.id_customer=customer.id_customer WHERE customer.id_unit_instalasi='$row->id_unit_instalasi' AND instalasi.status_instalasi='Pending' AND customer.deleted_at IS NULL) as customer_pending", ), ) ->where('id_unit_instalasi', $row->id_unit_instalasi) ->first(); $invoice = UnitInstalasi::select( DB::raw( "(SELECT COUNT(id_invoice) FROM invoice WHERE invoice.id_unit_instalasi='$row->id_unit_instalasi' AND tgl_invoice>='$dari_tgl' AND tgl_invoice<='$sampai_tgl' AND deleted_at IS NULL) as invoice_all", ), DB::raw( "(SELECT COUNT(id_invoice) FROM invoice WHERE invoice.id_unit_instalasi='$row->id_unit_instalasi' AND status_invoice='settlement' AND tgl_invoice>='$dari_tgl' AND tgl_invoice<='$sampai_tgl' AND deleted_at IS NULL) as invoice_settlement", ), DB::raw( "(SELECT COUNT(id_invoice) FROM invoice WHERE invoice.id_unit_instalasi='$row->id_unit_instalasi' AND status_invoice IN('Ditagih','pending') AND tgl_invoice>='$dari_tgl' AND tgl_invoice<='$sampai_tgl' AND deleted_at IS NULL) as invoice_ditagih", ), DB::raw( "(SELECT COUNT(id_invoice) FROM invoice WHERE invoice.id_unit_instalasi='$row->id_unit_instalasi' AND status_invoice='Belum Dibayar' AND tgl_invoice>='$dari_tgl' AND tgl_invoice<='$sampai_tgl' AND deleted_at IS NULL) as invoice_pending", ), ) ->where('id_unit_instalasi', $row->id_unit_instalasi) ->first(); @endphp @endforeach

No.	Reseller	Aktivasi	Bandwith	Biaya	Customer					Invoice
No.	Reseller	Aktivasi	Bandwith	Biaya	New	Active	Block	Uninstall	Pending	All	Lunas	Ditagih	Pending
{{ $loop->index + 1 }}	{{ $row->nama_ui }}	{{ tgl_indo($row->activated_at) }}	@if (!empty($bandwith->kapasitas)) @if ($bandwith->kapasitas >= 1000) {{ $bandwith->kapasitas / 1000 }} Gbps @else {{ $bandwith->kapasitas }} Mbps @endif @else 0 Mbps @endif	@if (!empty($bandwith->kapasitas)) {{ rupiah($bandwith->harga_produk) }}/Month @else 0/Month @endif	{{ number($customer->customer_new ?? 0) }}	{{ number($customer->customer_active ?? 0) }}	{{ number($customer->customer_blokir ?? 0) }}	{{ number($customer->customer_uninstall ?? 0) }}	{{ number($customer->customer_pending ?? 0) }}	{{ number($invoice->invoice_all ?? 0) }}	{{ number($invoice->invoice_settlement ?? 0) }}	{{ number($invoice->invoice_ditagih ?? 0) }}	{{ number($invoice->invoice_pending ?? 0) }}

@endif