<?php
use NN\Module\View;
use NN\Module\DB;
$route->add('/admin/formulir/pinjaman/{kode}',  function($kode){
    $prima = base64_decode($kode,true);
    $data = DB::query_result_object_row("SELECT m.*, format(m.jumlah,0, \"id_ID\") pinjam  FROM mpinjam m WHERE m.faktur = '$prima'");
    $anggota = DB::query_result_object_row("SELECT a.*, DATE_FORMAT(a.tgllahir, \"%d-%m-%Y\") tgllahir FROM anggota a WHERE a.kode = '$data->kode'");
    $dept = DB::query_result_object_row("SELECT * FROM dept WHERE kode = '$anggota->dept'");
    View::render('formulir/paper', [
        "content"=> "pinjaman"
        , "kode"=> base64_decode($kode,true)
        , "pinjaman"=>$data
        , "anggota"=>$anggota
        , "dept"=>$dept
    ]);
})
->use('vendor/autoload.php')
->use('module/db.php')
->use('module/perusahaan.php')
->middleware('cekloginadmin');