@php use App\Models\Instalasi; $bulan_akhir = 12; @endphp

Perbandingan Progress

View Month
Januari
Februari
Maret
April
Mei
Juni
Juli
Agustus
September
Oktober
Oktober
November
Desember
@if ($statistik_instalasi == 1)

Perbandingan Progress Instalasi

@foreach ($status_instalasi as $st) @endforeach @foreach ($status_instalasi as $st) @endforeach @if ($view_bulan == 1) @foreach ($bulan as $x) @foreach ($status_instalasi as $st) @if ($st == 'Install') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Active') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where('status_instalasi', 'Done') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where('status_instalasi', 'Done') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Block') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where('status_instalasi', 'Blokir') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where('status_instalasi', 'Blokir') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Pending') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_order', $x) ->whereYear('tgl_order', $cek_tahun1) ->where('status_instalasi', 'Pending') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_order', $x) ->whereYear('tgl_order', $cek_tahun2) ->where('status_instalasi', 'Pending') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Survey') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_order', $x) ->whereYear('tgl_order', $cek_tahun1) ->where('status_instalasi', 'Survey') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_order', $x) ->whereYear('tgl_order', $cek_tahun2) ->where('status_instalasi', 'Survey') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Failed') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_order', $x) ->whereYear('tgl_order', $cek_tahun1) ->where('status_instalasi', 'Failed') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_order', $x) ->whereYear('tgl_order', $cek_tahun2) ->where('status_instalasi', 'Failed') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Uninstall') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_uninstal', $x) ->whereYear('tgl_uninstal', $cek_tahun1) ->where('status_instalasi', 'Uninstall') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_uninstal', $x) ->whereYear('tgl_uninstal', $cek_tahun2) ->where('status_instalasi', 'Uninstall') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Blacklist') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_uninstal', $x) ->whereYear('tgl_uninstal', $cek_tahun1) ->where('status_instalasi', 'Blacklist') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_uninstal', $x) ->whereYear('tgl_uninstal', $cek_tahun2) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->where('status_instalasi', 'Blacklist') ->count('id_instalasi'); @endphp @endif @endforeach @endforeach @endif @foreach ($status_instalasi as $st) @if ($st == 'Install') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Active') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('status_instalasi', 'Done') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('status_instalasi', 'Done') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Block') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('status_instalasi', 'Blokir') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('status_instalasi', 'Blokir') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Pending') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun1) ->where('status_instalasi', 'Pending') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun2) ->where('status_instalasi', 'Pending') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Survey') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun1) ->where('status_instalasi', 'Survey') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun2) ->where('status_instalasi', 'Survey') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Failed') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun1) ->where('status_instalasi', 'Failed') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun2) ->where('status_instalasi', 'Failed') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Uninstall') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn( DB::raw('MONTH(tgl_uninstal)'), $bulan, ) ->whereYear('tgl_uninstal', $cek_tahun1) ->where('status_instalasi', 'Uninstall') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn( DB::raw('MONTH(tgl_uninstal)'), $bulan, ) ->whereYear('tgl_uninstal', $cek_tahun2) ->where('status_instalasi', 'Uninstall') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Blacklist') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('status_instalasi', 'Blacklist') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('status_instalasi', 'Blacklist') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @endforeach @foreach ($status_instalasi as $st) @if ($st == 'Install') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Active') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('status_instalasi', 'Done') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereYear('tgl_pasang', $cek_tahun2) ->where('status_instalasi', 'Done') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Block') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('status_instalasi', 'Blokir') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereYear('tgl_pasang', $cek_tahun2) ->where('status_instalasi', 'Blokir') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Pending') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun1) ->where('status_instalasi', 'Pending') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun2) ->where('status_instalasi', 'Pending') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Survey') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun1) ->where('status_instalasi', 'Survey') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun2) ->where('status_instalasi', 'Survey') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Failed') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun1) ->where('status_instalasi', 'Failed') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_order)'), $bulan) ->whereYear('tgl_order', $cek_tahun2) ->where('status_instalasi', 'Failed') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Uninstall') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn( DB::raw('MONTH(tgl_uninstal)'), $bulan, ) ->whereYear('tgl_uninstal', $cek_tahun1) ->where('status_instalasi', 'Uninstall') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn( DB::raw('MONTH(tgl_uninstal)'), $bulan, ) ->whereYear('tgl_uninstal', $cek_tahun2) ->where('status_instalasi', 'Uninstall') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Blacklist') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('status_instalasi', 'Blacklist') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('status_instalasi', 'Blacklist') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); if ($data2 != 0 || $data2 != 0) { $progress = (($data2 - $data1) / $data1) * 100; } else { $progress = 0; } @endphp @endif @endforeach
Bulan{{ $st }}
{{ $cek_tahun1 }} {{ $cek_tahun2 }}
{{ bulan_indo($x) }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}
Total{{ $data1 }} {{ $data2 }} {{ $data1 }} {{ $data2 }} {{ $data1 }} {{ $data2 }} {{ $data1 }} {{ $data2 }} {{ $data1 }} {{ $data2 }} {{ $data1 }} {{ $data2 }} {{ $data1 }} {{ $data2 }} {{ $data1 }} {{ $data2 }}
Progress @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif
@endif @if ($statistik_jenis_customer == 1)

Perbandingan Jenis Customer

@foreach ($jenis_customer as $st) @endforeach @foreach ($jenis_customer as $st) @endforeach @if ($view_bulan == 1) @foreach ($bulan as $x) @foreach ($jenis_customer as $st) @if ($st == 'Home') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Corp.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.jenis_customer', 'Corp.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.jenis_customer', 'Corp.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Educ.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.jenis_customer', 'Educ.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.jenis_customer', 'Educ.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Dinas.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.jenis_customer', 'Dinas.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.jenis_customer', 'Dinas.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Reseller') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.jenis_customer', 'Mitra.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.jenis_customer', 'Mitra.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @endforeach @endforeach @endif @foreach ($jenis_customer as $st) @if ($st == 'Home') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereYear('tgl_pasang', $cek_tahun2) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Corp.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Corp.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Corp.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Educ.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Educ.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Educ.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Dinas.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Dinas.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Dinas.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @if ($st == 'Reseller') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Mitra.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Mitra.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); @endphp @endif @endforeach @foreach ($jenis_customer as $st) @if ($st == 'Home') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Corp.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Corp.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Corp.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Educ.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Educ.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Educ.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Dinas.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Dinas.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Dinas.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Reseller') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Mitra.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Mitra.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('id_instalasi'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @endforeach
Bulan{{ $st }}
{{ $cek_tahun1 }} {{ $cek_tahun2 }}
{{ bulan_indo($x) }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}
Total{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}{{ $data1 }} {{ $data2 }}
Progress @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif
@endif @if ($statistik_pertambahan_pendapatan == 1)

Perbandingan Pendapatan Berdasarkan Harga Produk

@foreach ($jenis_customer as $st) @endforeach @foreach ($jenis_customer as $st) @endforeach @if ($view_bulan == 1) @foreach ($bulan as $x) @foreach ($jenis_customer as $st) @if ($st == 'Home') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); @endphp @endif @if ($st == 'Corp.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.jenis_customer', 'Corp.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.jenis_customer', 'Corp.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); @endphp @endif @if ($st == 'Educ.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.jenis_customer', 'Educ.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.jenis_customer', 'Educ.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); @endphp @endif @if ($st == 'Dinas.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.jenis_customer', 'Dinas.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.jenis_customer', 'Dinas.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); @endphp @endif @if ($st == 'Reseller') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun1) ->where( 'customer.jenis_customer', 'Mitra.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereMonth('tgl_pasang', $x) ->whereYear('tgl_pasang', $cek_tahun2) ->where( 'customer.jenis_customer', 'Mitra.', ) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); @endphp @endif @endforeach @endforeach @endif @foreach ($jenis_customer as $st) @if ($st == 'Home') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereYear('tgl_pasang', $cek_tahun2) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); @endphp @endif @if ($st == 'Corp.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Corp.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Corp.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); @endphp @endif @if ($st == 'Educ.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Educ.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Educ.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); @endphp @endif @if ($st == 'Dinas.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Dinas.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Dinas.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); @endphp @endif @if ($st == 'Reseller') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Mitra.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Mitra.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); @endphp @endif @endforeach @foreach ($jenis_customer as $st) @if ($st == 'Home') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->whereIn('customer.jenis_customer', [ 'Mr.', 'Mrs.', ]) ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Corp.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Corp.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Corp.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Educ.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Educ.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Educ.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Dinas.') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Dinas.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Dinas.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @if ($st == 'Reseller') @php $data1 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun1) ->where('customer.jenis_customer', 'Mitra.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->sum('harga_produk'); $data2 = Instalasi::join( 'customer', 'customer.id_customer', 'instalasi.id_customer', ) ->join( 'produk', 'produk.id_produk', 'instalasi.id_produk', ) ->whereIn(DB::raw('MONTH(tgl_pasang)'), $bulan) ->whereYear('tgl_pasang', $cek_tahun2) ->where('customer.jenis_customer', 'Mitra.') ->where( 'customer.id_unit_instalasi', Auth::user()->id_unit_instalasi, ) ->count('harga_produk'); $progress = (($data2 - $data1) / $data1) * 100; @endphp @endif @endforeach
Bulan{{ $st }}
{{ $cek_tahun1 }} {{ $cek_tahun2 }}
{{ bulan_indo($x) }}{{ number($data1) }} {{ number($data2) }}{{ number($data1) }} {{ number($data2) }}{{ number($data1) }} {{ number($data2) }}{{ number($data1) }} {{ number($data2) }}{{ number($data1) }} {{ number($data2) }}
Total{{ number($data1) }} {{ number($data2) }}{{ number($data1) }} {{ number($data2) }}{{ number($data1) }} {{ number($data2) }}{{ number($data1) }} {{ number($data2) }}{{ number($data1) }} {{ number($data2) }}
Progress @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif @if ($progress < 0) {{ number_format($progress, 2) }} % @else {{ number_format($progress, 2) }} % @endif
@endif