@extends('temp.admin') @php use NN\Module\DB; @endphp @section("content")

Pinjaman Anggota NON Gaji

Total
Rp

Pinjaman Reguler

Total
Rp

Pinjaman Anggota NON Gaji

Total
Rp {!! DB::query_result_object("select ifnull((SELECT sum(jumlah) tot FROM mpinjam WHERE kodesp = 'non'),0) total")[0]->total !!}

Pinjaman Reguler

Total
Rp {!! DB::query_result_object("select ifnull((SELECT sum(jumlah) tot FROM mpinjam WHERE kodesp = 'REG'),0) total")[0]->total !!}

Pinjaman Reguler USP

Total
Rp {!! DB::query_result_object("select ifnull((SELECT sum(jumlah) tot FROM mpinjam WHERE kodesp = 'USP'),0) total")[0]->total !!}

@endsection @section('script') @endsection