<?php
use NN\Module\View;
use NN\Module\DB;

$route->add('/admin/anggota',  'module/http/app@anggota')
->use('vendor/autoload.php')
->use('module/db.php')
->use('module/perusahaan.php')
->middleware('cekloginadmin');

$route->add('/admin/anggota/kta',  function(){
    $anggota = DB::query_result_object("SELECT * FROM anggota");
    View::render('admin/anggota/kta',["data" => $anggota]);
})
->use('vendor/autoload.php')
->use('module/db.php')
->use('module/perusahaan.php')
->middleware('cekloginadmin');

$route->add('/admin/bbbulanan',  function(){
    $tahun = isset($_GET['tahun']) ? $_GET['tahun'] : date('Y');
    $app = isset($_GET['app']) ? $_GET['app'] : 'usp';
    if(!isset($_GET['bln'])) {
        for ($i=0; $i < 12; $i++) {
            $y = $i+1;
            $bln = str_pad($y, 2, '0', STR_PAD_LEFT);   
            DB::query("call in_bbbulanan('$tahun','$bln','$app')"); 
        }
    }else{
        $bln = $_GET['bln'];
        DB::query("call in_bbbulanan('$tahun','$bln','$app')");
    }
    echo json_encode(['status' => 'ok']);
})
->use('vendor/autoload.php')
->use('module/db.php')
->use('module/perusahaan.php')
->middleware('cekloginadmin');

$route->add('/app/info',  function(){
    phpinfo();
})
->use('vendor/autoload.php')
->use('module/db.php')
->use('module/perusahaan.php');