No | @foreach ($kodebank as $data){{ $data->nama_kodebank }} | @endforeach
---|---|
{{ $no++ }} | @foreach ($kodebank as $item) @php $bukuharian = DB::table('bukuharians')->select(DB::raw('sum(debet) as sum_debet,sum(kredit) as sum_kredit'))->where('kode', $item->kode) ->where('tgl_setor', 'like', '%'.(!empty($tanggal) ? $tanggal : null) )->first(); @endphpRp. {{ number_format($bukuharian->sum_debet+$bukuharian->sum_kredit, 0, ',', '.') }} | @endforeach