@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 Tagihann | 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