@extends('layouts.app') @section('content')
{{ $biodata[0]->siswa_address }}
{{ $biodata[0]->siswa_birth_place }}, {{ date('d-m-Y', strtotime($biodata[0]->siswa_birth_date)) }}
{{ $biodata[0]->siswa_nik }}
{{ $biodata[0]->siswa_nohp }}
| Item Tagihan | Biaya | Sisa | Status | |
|---|---|---|---|---|
| {{-- Rp {{number_format($tagihan[0]->jumlah)}} --}} {{ $bl->biaya_lain_name }} | @php $tagihans = \DB::table('m_tagihan') ->select( \DB::raw("siswa_id, biaya_lain_id, sum(CAST(tagihan_jumlah as int )) as jumlah, sum(CAST(tagihan_masuk as int )) as masuk, sum(CAST(tagihan_sisa as int )) as sisa"), ) ->where([ ['siswa_id', $bl->siswa_id], ['biaya_lain_id', $bl->biaya_lain_id], ]) ->whereNotNull('biaya_lain_id') ->groupBy('siswa_id', 'biaya_lain_id') ->get(); @endphp @foreach ($tagihans as $key => $tag)Rp {{ number_format($tag->jumlah) }} | Rp {{ number_format($tag->sisa) }} |
@if ($tag->sisa > 0)
Belum Lunas@elseLunas@endif |
@endforeach