Admin_evaluasi.php

<?php

require_once __DIR__ . '/../helpers/Helper.php';

class Admin_evaluasi extends Controller
{

    private $api;
    private $_renja;
    private $_opd;
    private $_rkpd;

    public function __construct()
    {
        $this->_renja = $this->model('Renja_model');
        $this->_opd = $this->model('Opd_model');
        $this->_rkpd = $this->model('Rkpd_model');

        $this->api = new ApiReference;
        $this->access('admin');
    }

    public function renja($case = null, ...$params)
    {
        switch ($case) {
            case "data":
                $response = $this->_renja->faktorList($params[0], $params[1]);
                echo $response;
                break;
            default:
                $data['title'] = "Evaluasi renja";
                $this->view('admin/evaluasi/renja', $data);
                break;
        }
    }

    public function renja_download($tahun, $idOpd)
    {
        $opd = json_decode($this->_opd->getSingle($idOpd), true);

        $response = $this->api->GET("renja/faktor/list/$tahun/$idOpd/excel");

        header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=utf-8");
        header("Content-Disposition: attachment; filename=Laporan {$opd['data']['namaOpd']} Tahun {$tahun}.xlsx");  //File name extension was wrong
        header("Expires: 0");
        header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
        header("Cache-Control: private", false);

        echo $response;
    }

    public function rkpd($case = null, ...$params)
    {
        switch ($case) {
            case 'data':
                $response = $this->_rkpd->dataEvaluasi($params[0]);

                // set content type to json
                header('Content-Type: application/json');
                echo $response;
                break;
            case 'download':
                $opdId = isset($params[0]) ? $params[0] : null;

                if ($opdId == null) {
                    $this->rkpd();
                }

                $opd = json_decode($this->_opd->getSingle($opdId), true);
                $response = $this->api->GET('rkpd/evaluasi/' . $opdId . '/excel');

                header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=utf-8");
                header("Content-Disposition: attachment; filename=Laporan RKPD {$opd['data']['namaOpd']}.xlsx");  //File name extension was wrong
                header("Expires: 0");
                header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
                header("Cache-Control: private", false);

                echo $response;
                break;
            case 'evaluasi':
                $opdId = isset($params[0]) ? $params[0] : null;

                if ($opdId == null) {
                    $this->rkpd();
                }

                $data['semuaOpd'] = json_decode($this->_opd->getAllOpd(), true)['data'];
                $data['opdId'] = $opdId;
                $data['opd'] = json_decode($this->_opd->getSingle($opdId), true)['data'];
                $data['title'] = "Evaluasi RKPD - " . $data['opd']['namaOpd'];
                $data['data'] = json_decode($this->_rkpd->dataEvaluasi($opdId), true)['data'];

                $this->view('admin/evaluasi/evaluasi-rkpd', $data);
                break;
            default:
                $data['title'] = "Evaluasi RKPD";
                $data['semuaOpd'] = json_decode($this->_opd->getAllOpd(), true)['data'];

                $this->view('admin/evaluasi/rkpd', $data);
                break;
        }
    }
}