Detail Anggaran Desa (APBDes)

4 - PENDAPATAN

@php $query_pendapatan = \App\Models\AnggaranDesa::where('no_akun', 'LIKE', '4%'); if ($did != 'Semua') { $query_pendapatan->where('desa_id', $did); } if ($mid != 'Semua') { $query_pendapatan->where('bulan', $mid); } if ($year != 'Semua') { $query_pendapatan->where('tahun', $year); } $total_pendapatan = $query_pendapatan->sum('jumlah'); echo format_number_id($total_pendapatan); @endphp

@foreach (\App\Models\SubCoa::where('type_id', 4)->orderBy('type_id')->get() as $sub_coa) @foreach (\App\Models\SubSubCoa::where('type_id', $sub_coa->type_id)->where('sub_id', $sub_coa->id)->orderBy('sub_id')->get() as $sub_sub_coa) @endforeach @endforeach

#	Nomor Akun				Nama Akun	Jumlah
	{{ $sub_coa->type_id }}	{{ $sub_coa->id }}			{{ $sub_coa->sub_name }}	id . '%'); if ($did != 'Semua') { $query_pendapatan_sub->where('desa_id', $did); } if ($mid != 'Semua') { $query_pendapatan_sub->where('bulan', $mid); } if ($year != 'Semua') { $query_pendapatan_sub->where('tahun', $year); } $total_pendapatan_sub = $query_pendapatan_sub->sum('jumlah'); echo format_number_id($total_pendapatan_sub); ?>
	{{ 4 }}	{{ $sub_sub_coa->sub_id }}	{{ $sub_sub_coa->id }}		{{ $sub_sub_coa->sub_sub_name }}	id . $sub_sub_coa->id . '%'); if ($did != 'Semua') { $query_pendapatan_sub_sub->where('desa_id', $did); } if ($mid != 'Semua') { $query_pendapatan_sub_sub->where('bulan', $mid); } if ($year != 'Semua') { $query_pendapatan_sub_sub->where('tahun', $year); } $total_pendapatan_sub_sub = $query_pendapatan_sub_sub->sum('jumlah'); echo format_number_id($total_pendapatan_sub_sub); ?>

5 - BELANJA

@php $query_belanja = \App\Models\AnggaranDesa::where('no_akun', 'LIKE', '5%'); if ($did != 'Semua') { $query_belanja->where('desa_id', $did); } if ($mid != 'Semua') { $query_belanja->where('bulan', $mid); } if ($year != 'Semua') { $query_belanja->where('tahun', $year); } $total_belanja = $query_belanja->sum('jumlah'); echo format_number_id($total_belanja); @endphp

@foreach (\App\Models\SubCoa::where('type_id', 5)->orderBy('id')->get() as $sub_coa) @foreach (\App\Models\SubSubCoa::where('type_id', $sub_coa->type_id)->where('sub_id', $sub_coa->id)->orderBy('sub_id')->get() as $sub_sub_coa) @endforeach @endforeach

#	Nomor Akun				Nama Akun	Jumlah
	{{ $sub_coa->type_id }}	{{ $sub_coa->id }}			{{ $sub_coa->sub_name }}	id . '%'); if ($did != 'Semua') { $query_belanja_sub->where('desa_id', $did); } if ($mid != 'Semua') { $query_belanja_sub->where('bulan', $mid); } if ($year != 'Semua') { $query_belanja_sub->where('tahun', $year); } $total_belanja_sub = $query_belanja_sub->sum('jumlah'); echo format_number_id($total_belanja_sub); ?>
	{{ $sub_coa->type_id }}	{{ $sub_sub_coa->sub_id }}	{{ $sub_sub_coa->id }}		{{ $sub_sub_coa->sub_sub_name }}	id . $sub_sub_coa->id . '%'); if ($did != 'Semua') { $query_belanja_sub_sub->where('desa_id', $did); } if ($mid != 'Semua') { $query_belanja_sub_sub->where('bulan', $mid); } if ($year != 'Semua') { $query_belanja_sub_sub->where('tahun', $year); } $total_belanja_sub_sub = $query_belanja_sub_sub->sum('jumlah'); echo format_number_id($total_belanja_sub_sub); ?>

6 - PEMBIAYAAN

@php $query_biaya = \App\Models\AnggaranDesa::where('no_akun', 'LIKE', '6%'); if ($did != 'Semua') { $query_biaya->where('desa_id', $did); } if ($mid != 'Semua') { $query_biaya->where('bulan', $mid); } if ($year != 'Semua') { $query_biaya->where('tahun', $year); } $total_biaya = $query_biaya->sum('jumlah'); echo format_number_id($total_biaya); @endphp

@foreach (\App\Models\SubCoa::where('type_id', 6)->orderBy('id')->get() as $sub_coa) @foreach (\App\Models\SubSubCoa::where('type_id', $sub_coa->type_id)->where('sub_id', $sub_coa->id)->orderBy('sub_id')->get() as $sub_sub_coa) @endforeach @endforeach

#	Nomor Akun				Nama Akun	Jumlah
	{{ $sub_coa->type_id }}	{{ $sub_coa->id }}			{{ $sub_coa->sub_name }}	id . '%'); if ($did != 'Semua') { $query_biaya_sub->where('desa_id', $did); } if ($mid != 'Semua') { $query_biaya_sub->where('bulan', $mid); } if ($year != 'Semua') { $query_biaya_sub->where('tahun', $year); } $total_biaya_sub = $query_biaya_sub->sum('jumlah'); echo format_number_id($total_biaya_sub); ?>
	{{ $sub_coa->type_id }}	{{ $sub_sub_coa->sub_id }}	{{ $sub_sub_coa->id }}		{{ $sub_sub_coa->sub_sub_name }}	id . $sub_sub_coa->id . '%'); if ($did != 'Semua') { $query_biaya_sub_sub->where('desa_id', $did); } if ($mid != 'Semua') { $query_biaya_sub_sub->where('bulan', $mid); } if ($year != 'Semua') { $query_biaya_sub_sub->where('tahun', $year); } $total_biaya_sub_sub = $query_biaya_sub_sub->sum('jumlah'); echo format_number_id($total_biaya_sub_sub); ?>