test

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

ini_set('max_execution_time', 300); // 5 minutes

class Approval extends CI_Controller {

    function __construct() {
        parent ::__construct();
        if (!$this->is_logged_in()) {
            $logout = $this->ion_auth->logout();
            $this->session->set_flashdata('message', $this->ion_auth->messages());
            redirect('', 'refresh');
        }
        $this->config->load('pdln', true);
    }

    public function is_logged_in() {
        $user = $this->session->userdata('user_id');
        return isset($user);
    }

    public function index() {
        $this->task();
    }

    public function task() {
        $data['theme'] = 'pdln';
        $data['page'] = 'v_task';
        $data['title'] = 'Item Pekerjaan';
        $data['title_page'] = 'Item Pekerjaan';
        $data['breadcrumb'] = 'Item Pekerjaan';
        page_render($data);
    }

    public function plh_task_status_pdln($jenis_plh) {
        $pdln_status = 0;
        if ($jenis_plh == LEVEL_ANALIS) {
            $pdln_status = 3;
        } else if ($jenis_plh == LEVEL_KASUBAG) {
            $pdln_status = 4;
        } else if ($jenis_plh == LEVEL_KABAG) {
            $pdln_status = 5;
        } else if ($jenis_plh == LEVEL_KARO) {
            $pdln_status = 6;
        } else if ($jenis_plh == LEVEL_SESMEN) {
            $pdln_status = 7;
        } else if ($jenis_plh == LEVEL_TUSESMEN) {
            $pdln_status = 8;
        } else if ($jenis_plh == LEVEL_MENSESNEG) {
            $pdln_status = 9;
        } else if ($jenis_plh == LEVEL_TUMENSESNEG) {
            $pdln_status = 10;
        }
        return $pdln_status;
    }

    public function task_list() {
        $id_user = $this->session->user_id;
        $data_user = $this->db->get_where('m_user', array('UserID' => $id_user))->row();
        $level = $data_user->level;
        $is_plh = $data_user->is_plh;
        $task_plh = '';
        $jenis_plh = '';
        $is_active_plh = 0;
        if ($is_plh > 0) {
            $sekarang = date("Y-m-d");
            $this->db->select('*');
            $this->db->where('id_user_plh', $id_user);
            $this->db->limit(1);
            $this->db->order_by('id_plh', 'desc');
            $jenis = $this->db->get('t_log_plh')->row();
            if ($jenis) {
                $str_date = strtotime($jenis->start_date);
                $end_date = strtotime($jenis->end_date);
                $now_date = strtotime($sekarang);
                if (isset($jenis->jenis_plh) && ($now_date >= $str_date) && ($now_date <= $end_date)) {
                    $task_plh = $this->plh_task_status_pdln($jenis->jenis_plh);
                    $is_active_plh = 1;
                }
            }
        }

        $where = "";
        $handle_negara = $this->get_handle_negara($id_user);

        $this->crud_ajax->init('m_pdln', 'id_pdln', array('m_pdln.tgl_register' => 'asc'));
        $where = array('m_pdln.id_level_pejabat >' => '3');

        if ($level == LEVEL_ANALIS) {
            $this->db->where_in('negara', $handle_negara);
            if ($is_plh) {
                $this->db->where("(m_pdln.status='3' OR m_pdln.status='$task_plh')", NULL, FALSE);
            } else {
                $where = array('m_pdln.status' => '3', 'm_pdln.id_level_pejabat >' => '2');
            }
        } else if ($level == LEVEL_KASUBAG) {
            $this->db->where_in('negara', $handle_negara);
            if ($is_plh && $is_active_plh > 0) {
                $this->db->where("(m_pdln.status='4' OR m_pdln.status='$task_plh')", NULL, FALSE);
            } else {
                $where = array('m_pdln.status' => '4', 'm_pdln.id_level_pejabat >' => '2');
            }
        } else if ($level == LEVEL_KABAG) {
            if ($is_plh && $is_active_plh > 0) {
                $this->db->where("(m_pdln.status='5' OR m_pdln.status='$task_plh')", NULL, FALSE);
            } else {
                $where = array('m_pdln.status' => '5', 'm_pdln.id_level_pejabat >' => '2');
            }
        } else if ($level == LEVEL_KARO) {
            if ($is_plh && $is_active_plh > 0) {
                $this->db->where("(m_pdln.status='6' OR m_pdln.status='$task_plh')", NULL, FALSE);
            } else {
                $where = array('m_pdln.status' => '6', 'm_pdln.id_level_pejabat >' => '2');
            }
        } else if ($level == LEVEL_SESMEN) {
            if ($is_plh && $is_active_plh > 0) {
                $this->db->where("(m_pdln.status='7' OR m_pdln.status='$task_plh')", NULL, FALSE);
            } else {
                $where = array('m_pdln.status' => '7', 'm_pdln.id_level_pejabat >' => '2');
            }
        } else if ($level == LEVEL_TUSESMEN) {
            $where = array('m_pdln.status' => '9', 'm_pdln.id_level_pejabat >' => '2');
        } else if ($level == LEVEL_MENSESNEG) {
            $where = array('m_pdln.status' => '8', 'm_pdln.id_level_pejabat >' => '2');
        } else if ($level == LEVEL_TUMENSESNEG) {
            $where = array('m_pdln.status' => '10', 'm_pdln.id_level_pejabat >' => '2');
        } else {

            if ($is_plh) {
                $this->db->where("(m_pdln.status='$task_plh')", NULL, FALSE);
            } else {
                // $this->db->where_not_in('m_pdln.status', array('0','1','2','3','4','5','6','7','8','9','10','11','12'));
            }
        }

        $this->crud_ajax->setExtraWhere($where);
        $this->crud_ajax->set_select_field('
                    m_pdln.id_pdln,m_pdln.no_register,m_pdln.tgl_register,m_pdln.status,
                    m_pdln.no_surat_usulan_fp,m_pdln.create_date,m_kegiatan.NamaKegiatan,
                    unit_kerja.Name as unit_pemohon,unit_kerja2.Name as unit_fp,m_pdln.jenis_permohonan
        ');
        $join = array(
            'm_user as user1' => array('user1.UserID = m_pdln.unit_pemohon', 'left'),
            'm_unit_kerja_institusi as unit_kerja' => array('unit_kerja.ID = user1.unitkerja', 'left'),
            'm_kegiatan' => array('m_kegiatan.ID = m_pdln.id_kegiatan', 'left'),
            'm_user as user2' => array('user2.UserID = m_pdln.unit_fp', 'left'),
            'm_unit_kerja_institusi as unit_kerja2' => array('unit_kerja2.ID = user2.unitkerja', 'left')
        );
        $this->crud_ajax->setJoinField($join);
        $list = $this->crud_ajax->get_datatables();

        $data = array();
        $no = (isset($_POST['start'])) ? $_POST['start'] : 0;
        foreach ($list as $pdln) {
            $no++;
            $row = array();
            $row[] = $pdln->id_pdln;
            $row[] = str_pad($pdln->no_register, 8, '0', STR_PAD_LEFT);
            $row[] = date("d/m/Y", ($pdln->tgl_register));
            $row[] = '<a href="' . base_url() . 'kotak_surat/approval/edit_task/' . $pdln->id_pdln . '"><button class="btn btn-sm green btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> View</button></a>';
            $row[] = '<a href="' . base_url() . 'kotak_surat/approval/view_arsip/' . $pdln->id_pdln . '"><button class="btn btn-sm red btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> Arsip</button></a>';
            $row[] = $pdln->no_surat_usulan_fp;
            $row[] = $pdln->unit_pemohon;
            $row[] = $pdln->unit_fp;
            $row[] = '<span class="label label-' . setLabel($pdln->jenis_permohonan) . '">' . setJenisPermohonan($pdln->jenis_permohonan) . '</span>';
            $row[] = $pdln->NamaKegiatan;
            $row[] = '<span class="label label-danger">' . setStatus($pdln->status) . '</span>';

            $row[] = $pdln->tgl_register;
            $data[] = $row;
        }
        $output = array(
            "draw" => (isset($_POST['draw']) ? $_POST['draw'] : null),
            "recordsTotal" => $this->crud_ajax->count_all(),
            "recordsFiltered" => $this->crud_ajax->count_filtered(),
            "data" => $data,
        );
        echo json_encode($output);
    }

    public function task_list_express() {
        $id_user = $this->session->user_id;
        $data_user = $this->db->get_where('m_user', array('UserID' => $id_user))->row();
        $level = $data_user->level;
        $is_plh = $data_user->is_plh;
        $task_plh = '';
        $jenis_plh = '';
        $is_active_plh = 0;
        if ($is_plh > 0) {
            $sekarang = date("Y-m-d");
            $this->db->select('*');
            $this->db->where('id_user_plh', $id_user);
            $this->db->limit(1);
            $this->db->order_by('id_plh', 'desc');
            $jenis = $this->db->get('t_log_plh')->row();
            if ($jenis) {
                $str_date = strtotime($jenis->start_date);
                $end_date = strtotime($jenis->end_date);
                $now_date = strtotime($sekarang);
                if (isset($jenis->jenis_plh) && ($now_date >= $str_date) && ($now_date <= $end_date)) {
                    $task_plh = $this->plh_task_status_pdln($jenis->jenis_plh);
                    $is_active_plh = 1;
                }
            }
        }

        $where = "";
        $handle_negara = $this->get_handle_negara($id_user);

        $this->crud_ajax->init('m_pdln', 'id_pdln', array('m_pdln.tgl_register' => 'asc'));

        if ($level == LEVEL_ANALIS) {
            $this->db->where_in('negara', $handle_negara);
            if ($is_plh && $is_active_plh > 0) {
                // $this->db->where("(m_pdln.status='3' OR m_pdln.status='$task_plh')", NULL, FALSE);
                $where = array("m_pdln.status='3' OR m_pdln.status='$task_plh'", 'm_pdln.id_level_pejabat < ' => '3');
            } else {
                $where = array('m_pdln.status' => '3', 'm_pdln.id_level_pejabat < ' => '3');
            }
        } else if ($level == LEVEL_KASUBAG) {
            $this->db->where_in('negara', $handle_negara);
            if ($is_plh && $is_active_plh > 0) {
                // $this->db->where("(m_pdln.status='4' OR m_pdln.status='$task_plh')", NULL, FALSE);
                $where = array("(m_pdln.status='4' OR m_pdln.status='$task_plh')", 'm_pdln.id_level_pejabat < ' => '3');
            } else {
                $where = array('m_pdln.status' => '4', 'm_pdln.id_level_pejabat < ' => '3');
            }
        } else if ($level == LEVEL_KABAG) {
            if ($is_plh && $is_active_plh > 0) {
                $where = array("(m_pdln.status='5' OR m_pdln.status='$task_plh')", 'm_pdln.id_level_pejabat < ' => '3');
                // $this->db->where("(m_pdln.status='5' OR m_pdln.status='$task_plh')", NULL, FALSE);
            } else {
                $where = array('m_pdln.status' => '5', 'm_pdln.id_level_pejabat < ' => '3');
            }
        } else if ($level == LEVEL_KARO) {
            if ($is_plh && $is_active_plh > 0) {
                // $this->db->where("(m_pdln.status='6' OR m_pdln.status='$task_plh')", NULL, FALSE);
                $where = array("(m_pdln.status='6' OR m_pdln.status='$task_plh')", 'm_pdln.id_level_pejabat < ' => '3');
            } else {
                $where = array('m_pdln.status' => '6', 'm_pdln.id_level_pejabat < ' => '3');
            }
        } else if ($level == LEVEL_SESMEN) {
            if ($is_plh && $is_active_plh > 0) {
                $this->db->where("(m_pdln.status='7' OR m_pdln.status='$task_plh')", NULL, FALSE);
                // $where = array("(m_pdln.status='7' OR m_pdln.status='$task_plh')",'m_pdln.id_level_pejabat < '=>'3');
            } else {
                $where = array('m_pdln.status' => '7', 'm_pdln.id_level_pejabat < ' => '3');
            }
        } else if ($level == LEVEL_TUSESMEN) {
            $where = array('m_pdln.status' => '9', 'm_pdln.id_level_pejabat < ' => '3');
        } else if ($level == LEVEL_MENSESNEG) {
            $where = array('m_pdln.status' => '8', 'm_pdln.id_level_pejabat < ' => '3');
        } else if ($level == LEVEL_TUMENSESNEG) {
            $where = array('m_pdln.status' => '10', 'm_pdln.id_level_pejabat < ' => '3');
        } else {

            if ($is_plh) {
                $this->db->where("(m_pdln.status='$task_plh')", NULL, FALSE);
            } else {
                // $this->db->where_not_in('m_pdln.status', array('0','1','2','3','4','5','6','7','8','9','10','11','12'));
            }
        }
        // $where = array();

        $this->crud_ajax->setExtraWhere($where);
        $this->crud_ajax->set_select_field('
                    m_pdln.id_pdln,m_pdln.no_register,m_pdln.tgl_register,m_pdln.status,
                    m_pdln.no_surat_usulan_fp,m_pdln.create_date,m_kegiatan.NamaKegiatan,
                    unit_kerja.Name as unit_pemohon,unit_kerja2.Name as unit_fp,m_pdln.jenis_permohonan
        ');
        $join = array(
            'm_user as user1' => array('user1.UserID = m_pdln.unit_pemohon', 'left'),
            'm_unit_kerja_institusi as unit_kerja' => array('unit_kerja.ID = user1.unitkerja', 'left'),
            'm_kegiatan' => array('m_kegiatan.ID = m_pdln.id_kegiatan', 'left'),
            'm_user as user2' => array('user2.UserID = m_pdln.unit_fp', 'left'),
            'm_unit_kerja_institusi as unit_kerja2' => array('unit_kerja2.ID = user2.unitkerja', 'left')
        );

        $this->crud_ajax->setJoinField($join);
        $list = $this->crud_ajax->get_datatables();
        // var_dump($this->crud_ajax->last_query());

        $data = array();
        $no = (isset($_POST['start'])) ? $_POST['start'] : 0;
        foreach ($list as $pdln) {
            $no++;
            $row = array();
            $row[] = $pdln->id_pdln;
            $row[] = str_pad($pdln->no_register, 8, '0', STR_PAD_LEFT);
            $row[] = date("d/m/Y", ($pdln->tgl_register));
            $row[] = '<a href="' . base_url() . 'kotak_surat/approval/edit_task/' . $pdln->id_pdln . '"><button class="btn btn-sm green btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> View</button></a>';
            $row[] = '<a href="' . base_url() . 'kotak_surat/approval/view_arsip/' . $pdln->id_pdln . '"><button class="btn btn-sm red btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> Arsip</button></a>';
            $row[] = $pdln->no_surat_usulan_fp;
            $row[] = $pdln->unit_pemohon;
            $row[] = $pdln->unit_fp;
            $row[] = '<span class="label label-' . setLabel($pdln->jenis_permohonan) . '">' . setJenisPermohonan($pdln->jenis_permohonan) . '</span>';
            $row[] = $pdln->NamaKegiatan;
            $row[] = '<span class="label label-danger">' . setStatus($pdln->status) . '</span>';

            $row[] = $pdln->tgl_register;
            $data[] = $row;
        }
        $output = array(
            "draw" => (isset($_POST['draw']) ? $_POST['draw'] : null),
            "recordsTotal" => $this->crud_ajax->count_all(),
            "recordsFiltered" => $this->crud_ajax->count_filtered(),
            "data" => $data,
        );
        echo json_encode($output);
    }

    public function express() {
        $data['theme'] = 'pdln';
        $data['page'] = 'v_express';
        $data['title'] = 'Item Pekerjaan';
        $data['title_page'] = 'Item Pekerjaan';
        $data['breadcrumb'] = 'Item Pekerjaan';
        page_render($data);
    }

    public function edit_task($id_pdln) {
        $where = array('Status' => '1');
        /* $this->crud_ajax->init('r_level_pejabat','id',null);
          $this->crud_ajax->setExtraWhere($where);
          $data['level_pejabat'] = $this->crud_ajax->get_data();
          $this->crud_ajax->init('r_jenis_kegiatan','ID',null);
          $this->crud_ajax->setExtraWhere($where);
          $data['jenis_kegiatan']		= $this->crud_ajax->get_data();
          $this->crud_ajax->init('r_negara','id',null);
          $this->crud_ajax->setExtraWhere($where);
          $data['negara']		= $this->crud_ajax->get_data();
          $this->crud_ajax->init('r_jenis_pembiayaan','ID',null);
          $this->crud_ajax->setExtraWhere($where);
          $data['jenis_pembiayaan'] = $this->crud_ajax->get_data();
          $this->crud_ajax->init('r_institution','ID',null);
          $this->crud_ajax->setExtraWhere($where);
          $data['list_instansi'] = $this->crud_ajax->get_data();
         */
        //$this->crud_ajax->init('r_template_tembusan', 'ID', null);
        //$this->crud_ajax->setExtraWhere($where);
        //$data['list_temp_tembusan'] = $this->crud_ajax->get_data();
        $this->crud_ajax->init('r_template_tembusan', 'ID', null);
        $this->crud_ajax->set_select_field('ID,Nama');
        $this->crud_ajax->setExtraWhere($where);
        $tembusan = $this->crud_ajax->get_data();
        $list_tembusan = array('0' => 'Pilih Format Tembusan');
        foreach ($tembusan as $t)
            $list_tembusan[$t->ID] = $t->Nama;
        $data['list_tembusan'] = $list_tembusan;
        $data['id_pdln'] = $id_pdln;
        $this->crud_ajax->init('t_approval_pdln', 'id', null);
        $where_pdln = array('id_pdln' => $id_pdln, 'is_done' => 1);
        $this->crud_ajax->setExtraWhere($where_pdln);
        $data['list_approval'] = $this->crud_ajax->get_data(); //get history approval
        $this->db->select('p.id_pdln_lama,p.id_signed,p.id_pdln,p.id_kegiatan,p.no_surat_usulan_pemohon,p.tgl_surat_usulan_pemohon,
                            lp.nama as level_pejabat,p.no_surat_usulan_fp,p.tgl_surat_usulan_fp,
                            p.pejabat_sign_sp,p.id_level_pejabat,p.format_tembusan,p.jenis_permohonan,
                            p.status,p.id_level_pejabat,p.author');
        $this->db->where('p.id_pdln', $id_pdln);
        $this->db->from('m_pdln p');
        $this->db->join("r_level_pejabat lp", "lp.id = p.id_level_pejabat");
        $data['data_pdln'] = $this->db->get()->row();
        $level = $this->db->get_where('r_level_pejabat', array('id' => $data['data_pdln']->id_level_pejabat))->row();
        $matrik = $level->id_lama;
        $data['matriks_level'] = $matrik;
        $data['data_pdln_lama'] = $this->db->get_where('m_pdln', array('id_pdln' => $data['data_pdln']->id_pdln_lama))->row();

        //-----------------------------------------------------------------------------------------------------
        // Memastikan bahwa level pejabat tertentu atau pengguna tertentu yang dapat melakukan perubahan data
        //-----------------------------------------------------------------------------------------------------
        $id_user = $this->session->user_id;
        $data_user = $this->db->get_where('m_user', array('UserID' => $id_user))->row();
        $level = $data_user->level;
        $data_integrity = $this->config->item('data_integrity', 'pdln');
        $id_level_pejabat = $data['data_pdln']->id_level_pejabat;
        if (!empty($data['data_pdln']) && $data['data_pdln']->author != $id_user && (array_key_exists($id_level_pejabat, $data_integrity) == false || $data_integrity[$id_level_pejabat] != $level)
        //&& in_array($data['data_pdln']->status, $pdln_status) == false
        ) {
            //show_error("Anda tidak memiliki akses terhadap halaman atau data di halaman ini. ", 403, "Forbidden");
        }
        //-----------------------------------------------------------------------------------------------------
        $this->db->select('m_kegiatan.ID,NamaKegiatan,StartDate,EndDate,r_negara.nmnegara,r_kota.nmkota,r_jenis_kegiatan.Nama as JenisKegiatan');
        $this->db->where('m_kegiatan.ID', $data['data_pdln']->id_kegiatan);
        $this->db->from('m_kegiatan');
        $this->db->join('r_negara', 'r_negara.id = m_kegiatan.negara');
        $this->db->join('r_kota', 'r_kota.id = m_kegiatan.tujuan');
        $this->db->join('r_jenis_kegiatan', 'r_jenis_kegiatan.ID = m_kegiatan.JenisKegiatan');
        $data['detail_kegiatan'] = $this->db->get()->row();
        $data['theme'] = 'pdln';
        $data['page'] = 'v_edit_task';
        $data['title'] = 'Form Persetujuan';
        $data['title_page'] = 'Form Persetujuan';
        $data['breadcrumb'] = 'Form Persetujuan';
        $data['id_user'] = $this->session->user_id;

        // Setting PLH
        // $data_user = $this->db->get_where('m_user', array('UserID' => $id_user))->row();
        // $is_plh = $data_user->is_plh;
        // $level_approval = '';
        // if ($is_plh) {
        //     $sekarang = date("Y-m-d");
        //     $this->db->select('jenis_plh,start_date,end_date');
        //     $this->db->where('id_user_plh', $id_user);
        //     $this->db->limit(1);
        //     $this->db->order_by('id_plh', 'desc');
        //     $jenis = $this->db->get('t_log_plh')->row();
        //     $str_date = strtotime($jenis->start_date);
        //     $end_date = strtotime($jenis->end_date);
        //     $now_date = strtotime($sekarang);
        //     if (isset($jenis->jenis_plh)&&($now_date >= $str_date) && ($now_date <= $end_date) ) {
        //         $level_approval = $jenis->jenis_plh;
        //     }else{
        //         $level_approval = $data_user->level;
        //     }
        // }
        $data['level'] = $data_user->level;
        page_render($data);
    }

    public function get_file_path() {
        $id_pdln = $this->input->post('id_pdln');
        $this->db->where('id_pdln', $id_pdln);
        $row = $this->db->get('m_pdln')->row();
        $date_created = date("Y-m-d", $row->create_date);
        // 25_698_file_surat_usulan_pemohon.pdf
        $file_pemohon = $row->path_file_sp_pemohon;
        $file_fp = $row->path_file_sp_fp;
        $response['status'] = TRUE;
        $path_pemohon = get_file_pdln("pdln", $date_created, $id_pdln, $file_pemohon);
        $path_fp = get_file_pdln("pdln", $date_created, $id_pdln, $file_fp);
        if (!empty($file_pemohon)) {
            $response['path_pemohon'] = $path_pemohon;
            $response['status_file_pemohon'] = TRUE;
            $response['msg'] = "Simpan data berhasil";
        } else
            $response['status_file_pemohon'] = FALSE;
        if (!empty($file_fp)) {
            $response['path_focal_point'] = $path_fp;
            $response['status_file_fp'] = TRUE;
        } else
            $response['status_file_fp'] = FALSE;
        echo json_encode($response);
    }

    public function get_file_kegiatan() {
        $id_jenis = $this->db->get_where('m_kegiatan', array('ID' => $this->input->post('id_jenis')))->row()->JenisKegiatan;
        $id_pdln = $this->input->post('id_pdln');
        $created_date = date("Y-m-d", ($this->db->get_where('m_pdln', array('id_pdln' => $id_pdln))->row()->create_date));
        $this->db->from('view_doc_kegiatan');
        $this->db->where('id_jenis_kegiatan', $id_jenis);
        $result = $this->db->get();
        $response = array();
        if ($result->num_rows() > 0) {
            $data['status'] = TRUE;
            foreach ($result->result() as $row) {
                $data = array();
                $data['id_jenis_doc'] = $row->id_jenis_doc;
                $data['nama_doc'] = $row->nama_doc;
                $data['nama_full_doc'] = ucwords($row->nama_full_doc);
                $data['is_require'] = ($row->is_require == '1' ? TRUE : FALSE );
                $data['id_jenis_kegiatan'] = $row->id_jenis_kegiatan;
                $id_jenis_doc = $row->id_jenis_doc;
                $where = array(
                    'id_jenis_doc' => $id_jenis_doc,
                    'id_pdln' => $id_pdln
                );
                $is_exist = $this->db->get_where('m_dok_pdln', $where);
                if ($is_exist->num_rows() > 0) {
                    $nama_file_doc = $is_exist->row()->dir_path;
                    $path_file = get_file_pdln("kegiatan", $created_date, $id_pdln, $nama_file_doc);
                    $data['path_file'] = $path_file;
                    $data['is_exist'] = TRUE;
                } else {
                    $data['is_exist'] = FALSE;
                }
                array_push($response, $data);
            }
        }
        echo json_encode($response, JSON_PRETTY_PRINT);
    }

    public function lanjutkan() {
        $this->_lanjutkan_validate();
        $response['status'] = TRUE;
        echo json_encode($response);
    }

    /**
     * @method private _validate handle validation data users
     * @return json output status on form or modal
     */
    private function _lanjutkan_validate() {
        $data = array();
        $data['error_string'] = array();
        $data['inputerror'] = array();
        $data['status'] = TRUE;
        $id_pdln = $this->input->post('id_pdln');
        $status = $this->input->post('status');
        $note = $this->input->post('note');
        $level = $this->input->post('level');
        $nextlevel = $this->input->post('nextlevel');
        $template_tembusan = $this->input->post('template_tembusan');
        $level_user = $this->db->get_where('m_user', array('UserID' => $this->session->user_id))->row()->level;
        if ($note === "") {
            $data['status'] = FALSE;
            $data['message'] = "Silahkan berikan catatan terlebih dahulu sebelum memberikan persetujuan";
            echo json_encode($data);
            exit;
        } else if ($template_tembusan === "0" || !isset($template_tembusan)) {
            if (($level_user == LEVEL_ANALIS) || ($level_user == LEVEL_KASUBAG) || ($level_user == LEVEL_KABAG)) {
                $data['status'] = FALSE;
                $data['message'] = "Silahkan pilih format tembusan terlebih dahulu";
                echo json_encode($data);
                exit;
            }
        }
        if ($data['status'] === TRUE) {
            /* Insert New Row To Next Approval */
            $this->crud_ajax->init('t_approval_pdln', 'id', null);
            $data_approval = array(
                'id_pdln' => $id_pdln,
                'assign_date' => date('Y-m-d H:i:s'),
                'level' => $nextlevel
            );
            $insert_id_u = $this->crud_ajax->save($data_approval);
            /* Update Current Data Approval */
            $this->crud_ajax->init('t_approval_pdln', 'id', null);
            $user_id = $this->session->user_id;
            $data_update_approval = array(
                'user_id' => $user_id,
                'note' => $note,
                'submit_date' => date('Y-m-d H:i:s'),
                'aksi' => 'setuju',
                'is_done' => 1,
            );
            $where_approval = array('level' => $level, 'id_pdln' => $id_pdln, 'is_done' => 0);
            $affected_row_u = $this->crud_ajax->update($where_approval, $data_update_approval);
            /* Update status in pdln table */
            $this->crud_ajax->init('m_pdln', 'id', null);
            if (($level_user == LEVEL_ANALIS) || ($level_user == LEVEL_KASUBAG) || ($level_user == LEVEL_KABAG)) {
                $data_pdln = array(
                    'status' => intval($status) + 1,
                    'format_tembusan' => $template_tembusan
                );
            } else {
                $data_pdln = array(
                    'status' => intval($status) + 1,
                );
            }
            $where_pdln = array('id_pdln' => $id_pdln);
            $affected_row_u = $this->crud_ajax->update($where_pdln, $data_pdln);

            if ($affected_row_u > 0) {
                $data_email = array(
                    'to' => $this->session->email,
                    'subject' => '[SIMPLE] ',
                    'body' => ''
                );
                //$this->send_email($data_email);
            }
        }
    }

    public function lanjutketu() {
        $response['id_pdln'] = $this->_lanjutketu_validate();
        $response['status'] = TRUE;
        echo json_encode($response);
    }

    /**
     * @method private _validate handle validation data users
     * @return json output status on form or modal
     */
    private function _lanjutketu_validate() {
        $data = array();
        $data['error_string'] = array();
        $data['inputerror'] = array();
        $data['status'] = TRUE;
        $id_pdln = $this->input->post('id_pdln');
        $status = $this->input->post('status');
        $level = $this->input->post('level');
        $nextlevel = $this->input->post('nextlevel');
        $note = $this->input->post('note');
        /* Insert New Row To Next Approval */
        $this->crud_ajax->init('t_approval_pdln', 'id', null);
        $data_approval = array(
            'id_pdln' => $id_pdln,
            'assign_date' => date('Y-m-d H:i:s'),
            'level' => $nextlevel
        );

        $insert_id_u = $this->crud_ajax->save($data_approval);
        /* Update Current Data Approval */
        $data_update_approval = array(
            'user_id' => $this->session->user_id,
            'submit_date' => date('Y-m-d H:i:s'),
            'note' => $note,
            'aksi' => 'setuju',
            'is_done' => 1,
        );
        $where_approval = array('level' => $level, 'id_pdln' => $id_pdln, 'is_done' => 0);
        $affected_row_u = $this->crud_ajax->update($where_approval, $data_update_approval);
        $level_user = $this->db->get_where('m_user', array('UserID' => $this->session->user_id))->row()->level;
        $curr_status = $this->db->get_where('m_pdln', array('id_pdln' => $id_pdln))->row()->status;
        if ($level_user == LEVEL_SESMEN && $curr_status == 7) {
            /* Update status in pdln table */
            $this->crud_ajax->init('m_pdln', 'id', null);
            $data_pdln = array(
                'status' => 9,
                'penandatangan_persetujuan' => $this->session->user_id
            );
            $where_pdln = array('id_pdln' => $id_pdln);
            $affected_row_u = $this->crud_ajax->update($where_pdln, $data_pdln);
        } else {
            /* Update status in pdln table */
            $this->crud_ajax->init('m_pdln', 'id', null);
            $data_pdln = array(
                'status' => 10,
                'penandatangan_persetujuan' => $this->session->user_id
            );
            $where_pdln = array('id_pdln' => $id_pdln);
            $affected_row_u = $this->crud_ajax->update($where_pdln, $data_pdln);
        }
        return $id_pdln;
    }

    //Kepala biro setuju
    public function setuju() {
        $this->_setuju_validate();
        $response['status'] = TRUE;
        echo json_encode($response);
    }

    /**
     * @method private _validate handle validation data users
     * @return json output status on form or modal
     */
    private function _setuju_validate() {
        $data = array();
        $data['error_string'] = array();
        $data['inputerror'] = array();
        $data['status'] = TRUE;
        $id_pdln = $this->input->post('id_pdln');
        $status = $this->input->post('status');
        $level = $this->input->post('level');
        $level_user = $this->db->get_where('m_user', array('UserID' => $this->session->user_id))->row()->level;
        $note = $this->input->post('note');
        if ($data['status'] === TRUE) {
            /* Update Current Data Approval */
            $data_update_approval = array(
                'user_id' => $this->session->user_id,
                'submit_date' => date('Y-m-d H:i:s'),
                'note' => $note,
                'aksi' => 'setuju',
                'is_done' => 1,
            );
            $this->crud_ajax->init('t_approval_pdln', 'id', null);
            $where_approval = array('level' => $level, 'id_pdln' => $id_pdln, 'is_done' => 0);
            $affected_row_u = $this->crud_ajax->update($where_approval, $data_update_approval);
            $this->db->select('m_pdln.id_pdln,m_pdln.id_kegiatan,m_pdln.no_sp,m_pdln.tgl_sp,m_pdln.tgl_surat_usulan_fp,
                               m_pdln.no_surat_usulan_fp,m_pdln.pejabat_sign_sp,m_pdln.format_tembusan, m_pdln.id_pdln_lama,
                               m_pdln.jenis_permohonan, m_pdln.path_sp, m_pdln.create_date, m_pdln.update_date');
            $this->db->where('m_pdln.id_pdln', $id_pdln);
            $data_pdln = $this->db->get('m_pdln')->row();
            // Get data for Update Perpanjang/Ralat/Pembatalan
            $id_pdln_lama = $data_pdln->id_pdln_lama;
            $jenis_permohonan = $data_pdln->jenis_permohonan;
            $jenis_kegiatan = $this->db->get_where('m_kegiatan', array('ID' => $data_pdln->id_kegiatan))->row()->JenisKegiatan;
            /* Update status in pdln table */
            $this->crud_ajax->init('m_pdln', 'id', null);
            $data_pdln_update = array(
                'no_sp' => $this->generate_number($jenis_kegiatan),
                'penandatangan_persetujuan' => $this->session->user_id,
                'tgl_sp' => strtotime(date('Y-m-d H:i:s')),
                'status' => 11,
                'barcode' => mt_rand(100000, 999999),
            );
            $where_pdln = array('id_pdln' => $id_pdln);
            $affected_row_u = $this->crud_ajax->update($where_pdln, $data_pdln_update);
            if ($data_pdln->jenis_permohonan == '20') {
                $sp_file = $this->print_perpanjangan_final($id_pdln, '');
            } elseif ($data_pdln->jenis_permohonan == '30') {
                $sp_file = $this->print_ralat_final($id_pdln, '');
            } elseif ($data_pdln->jenis_permohonan == '40') {
                $sp_file = $this->print_pembatalan_final($id_pdln, '');
            } else {
                $sp_file = $this->cetak_permohonan_final($id_pdln, '');
            }
            //update sp file
            $this->crud_ajax->init('m_pdln', 'id', null);
            $data_pdln_update = array(
                'path_sp' => $sp_file,
            );
            $data_pdln->path_sp = $sp_file;
            $where_pdln = array('id_pdln' => $id_pdln);
            $affected_row_u = $this->crud_ajax->update($where_pdln, $data_pdln_update);
            if (isset($sp_file) && $sp_file != null) {
                $esign_ok = $this->_callEsign($level_user, $data_pdln);
                if ($esign_ok) {
                    $url_playstore = $this->config->item('url_playstore', 'pdln');
                    $url_appstore = $this->config->item('url_appstore', 'pdln');
                    $this->db->select('
                                    b.nama AS nama_pemohon,
                                    b.email AS email,
                                    a.negara_tujuan AS nama_negara,
                                    c.NamaKegiatan AS nama_kegiatan,
                                    a.start_date_keg AS tgl_mulai,
                                    a.end_date_keg AS tgl_selesai,
                                    d.no_register AS no_reg');
                    $this->db->from('view_log_peserta a');
                    $this->db->join('m_pemohon b', 'a.id_pemohon=b.id_pemohon');
                    $this->db->join('m_kegiatan c', 'c.id=a.id_kegiatan');
                    $this->db->join('m_pdln d', 'd.id_pdln=a.id_pdln');
                    $this->db->where('a.id_pdln', $id_pdln);
                    $query = $this->db->get();
                    foreach ($query->result() as $d) {
                        $body_setuju = "
                            <!DOCTYPE html>
                            <html>
                            <head>
                            <title>Persetujuan Izin Perjalanan Dinas Luar Negeri (PDLN)</title>
                            </head>
                            <body>
                            <p>Yth. Bapak/Ibu {$d->nama_pemohon}</p>
                            <p>Dengan hormat kami sampaikan bahwa permohonan PDLN Bapak/Ibu untuk
                            melakukan perjalanan dinas ke n{$d->nama_negara} dalam rangka {$d->nama_kegiatan}
                            mulai tanggal ".date('d-m-Y',$d->tgl_mulai)." s.d. ".date('d-m-Y',$d->tgl_selesai)." dengan nomor register {$d->no_reg},
                            telah mendapat persetujuan dari Kementerian Sekretariat Negara.</p>
                            <p>
                            Bapak/Ibu dapat mengunduh Surat Persetujuan dan menyampaikan laporan hasil penugasan PDLN tersebut
                            melalui aplikasi SIMPEL berbasis Android/iOS yang dapat didownload melalui link:
                            <ul>
                            <li>Aplikasi Android	: 	<a href='{$url_playstore}' style='color:#33f;text-decoration:underline;'>{$url_playstore}</a></li>
                            <li>Aplikasi iOS	: 	<a href='{$url_appstore}' style='color:#33f;text-decoration:underline;'>{$url_appstore}</a><li>
                            </ul>
                            </p>
                            <p>Informasi lebih lanjut dapat menghubungi administrator SIMPEL melalui email simple@setneg.go.id</p>
                            <p>&nbsp;</p>
                            <p>Hormat kami,<br>
                            Administrator SIMPEL<br>
                            Biro KTLN, Kementerian Sekretariat Negara</p>
                            </body>
                            </html>
                            ";
                        $data_email = array(
                            'to' => $d->email,
                            'subject' => 'Persetujuan Izin Perjalanan Dinas Luar Negeri (PDLN)',
                            'body' => $body_setuju
                        );
                        $is_send = $this->send_email($data_email);
                    }
                }
            }
            // Update Status SP LAMA menjadi diperpanjang/diralat/dibatalkan
            switch ($jenis_permohonan) {
                case "20":  // Perpanjangan
                    $status_baru = '14';    // Perpanjangan
                    $this->crud_ajax->init('m_pdln', 'id', null);
                    $data_pdln_lama = array(
                        'status' => $status_baru,
                    );
                    $where_pdln_lama = array('id_pdln' => $id_pdln_lama);
                    $affected_row_u = $this->crud_ajax->update($where_pdln_lama, $data_pdln_lama);
                    break;
                case "30":  // Ralat
                    $status_baru = '13';     // Ralat
                    $this->crud_ajax->init('m_pdln', 'id', null);
                    $data_pdln_lama = array(
                        'status' => $status_baru,
                    );
                    $where_pdln_lama = array('id_pdln' => $id_pdln_lama);
                    $affected_row_u = $this->crud_ajax->update($where_pdln_lama, $data_pdln_lama);
                    break;
                case "40":  // Pembatalan
                    $status_baru = '15';     // Pembatalan
                    $this->crud_ajax->init('m_pdln', 'id', null);
                    $data_pdln_lama = array(
                        'status' => $status_baru,
                    );
                    $where_pdln_lama = array('id_pdln' => $id_pdln_lama);
                    $affected_row_u = $this->crud_ajax->update($where_pdln_lama, $data_pdln_lama);
                    break;
            }
        }
    }

    private function _callEsign($level, $data_pdln) {

        // ESIGN INTEGRATION
        $id_pdln = $data_pdln->id_pdln;
        $esignProcess = FALSE;
        $pathFile = '';
        $authResponse = NULL;
        $signResponse = NULL;
        $result = false;
        if ($level == LEVEL_KARO || allow_task_to_plh(LEVEL_KARO) || $level == LEVEL_SESMEN || allow_task_to_plh(LEVEL_SESMEN) || $level == LEVEL_TUSESMEN || $level == LEVEL_MENSESNEG || allow_task_to_plh(LEVEL_MENSESNEG) || $level == LEVEL_TUMENSESNEG) {
            // $matriks_level == LEVEL_ESELON_II
            // get id level pejabat
            // check with matrix level / klaster r_level_pejabat
            $esignProcess = TRUE;
            $filename = $data_pdln->path_sp;
            $this->config->load('pdln', TRUE);
            $base_path = $this->config->item('pdln_upload_path', 'pdln');
            $update_date = $data_pdln->update_date;
            $create_date = $data_pdln->create_date;
            $month = month(date('n', $create_date));
            $year = date('Y', $create_date);
            $additional_path = $year . '/' . $month . '/pdln/' . $id_pdln . "/";
            $targetPath = $base_path . $additional_path;
            $pathFile = "{$targetPath}{$filename}";
        }

        if ($esignProcess && file_exists($pathFile)) {
            $this->config->load('esign', TRUE);
//            print_r($this->config->item('esign'));
            $this->load->library('Esign', $this->config->item('esign'));
            $clientId = $this->config->item('clientId', 'esign');
            $clientSecret = $this->config->item('clientSecret', 'esign');
            $username = $this->config->item('userIdMenteri', 'esign');
            $password = $this->config->item('passwordMenteri', 'esign');
            $pin = $this->config->item('pinMenteri', 'esign');
            $authEntity = new AuthRequestEntity();
            $authEntity->client_id = $clientId;
            $authEntity->client_secret = $clientSecret;
            $authEntity->grant_type = Esign::GRANT_TYPE_PASSWORD;
            $authEntity->username = $username;
            $authEntity->password = $password;
            $authResponse = json_decode($this->esign->GetUserAccessToken($authEntity), TRUE);
//            print_r($authEntity);
//            print_r($authResponse);
        }
        if (array_key_exists('access_token', $authResponse)) {
            $accessToken = $authResponse['access_token'];
            $signEntity = new SignRequestEntity();
            $signEntity->passphrase = $pin;
            $signEntity->properties = 'default';
            $signEntity->link = 'https://kemensetneg.go.id';
            $boundary = uniqid();
            $delimiter = '-------------' . $boundary;
            $files['file'] = file_get_contents($pathFile);
            $postData = CurlHelper::BuildDataFiles($boundary, array(), $files);
            $signEntity->file = $postData;
            $signResponse = json_decode($this->esign->SignDocument($signEntity, $accessToken, $delimiter), TRUE);
        }
        // if signed document success, put the id_signed on the table
        if (is_array($signResponse) && array_key_exists('id_signed', $signResponse)) {
            $this->db->set('id_signed', $signResponse['id_signed']);
            $this->db->where('id_pdln', $id_pdln);
            $this->db->update("m_pdln");
            $result = true;
        }
        return $result;
    }

    public function tu_setuju() {
        $this->_tu_setuju_validate();
        $response['status'] = TRUE;

        echo json_encode($response);
    }

    /**
     * @method private _validate handle validation data users
     * @return json output status on form or modal
     */
    private function _tu_setuju_validate() {
        $data = array();
        $data['error_string'] = array();
        $data['inputerror'] = array();
        $data['status'] = TRUE;
        $id_pdln = $this->input->post('id_pdln');
        $no_sp = $this->input->post('no_sp');
        $tanggal_surat = $this->input->post('tanggal_surat');
        $level = $this->input->post('level');
        $note = $this->input->post('note');
        $level_user = $this->db->get_where('m_user', array('UserID' => $this->session->user_id))->row()->level;
        // if ($no_sp === "") {
        //     $data['status'] = FALSE;
        //     $data['message'] = "Nomor Surat Harus Di isi";
        //     echo json_encode($data);
        //     exit;
        // }
        // if ($tanggal_surat === "") {
        //     $data['status'] = FALSE;
        //     $data['message'] = "Tanggal Surat Harus Di isi";
        //     echo json_encode($data);
        //     exit;
        // }
        if ($data['status'] === TRUE) {
            $number_format_sp = '';
            $pdln_surat = $this->db->get_where('m_pdln', array('id_pdln' => $id_pdln))->row();
            if ($pdln_surat->jenis_permohonan == 10) {
                $str_hal = 'Persetujuan Perjalanan Dinas Luar Negeri';
            } else if ($pdln_surat->jenis_permohonan == 20) {
                $str_hal = 'Persetujuan Perpanjangan Perjalanan Dinas Luar Negeri';
            } else if ($pdln_surat->jenis_permohonan == 30) {
                $str_hal = 'Persetujuan Ralat Perjalanan Dinas Luar Negeri';
            } else if ($pdln_surat->jenis_permohonan == 40) {
                $str_hal = 'Persetujuan Pembatalan Perjalanan Dinas Luar Negeri';
            }
            $this->load->library('spde2');
            $this->_ci = & get_instance();
            $this->_ci->load->config('pdln', TRUE);
            $spde2_config = $this->_ci->config->item('spde2', 'pdln');

            $token['client_id'] = 'spdesimpel_id';
            $token['client_secret'] = 'spdesimpel_secret';
            $token['redirect_uri'] = 'http://localhost/spde2api';
            $token['grant_type'] = 'client_credentials';

            $respon_token = json_decode($this->spde2->postRequest($spde2_config['url_spde_token'], $token, $refer = "", $timeout = 3000, $header = []));
            if (!empty($respon_token->access_token) && $respon_token->access_token != 'undefined') {
                $header_lastnum = array(
                    'Content-type: application/x-www-form-urlencoded',
                    'Authorization: ' . $respon_token->token_type . ' ' . $respon_token->access_token,
                );

                $data = '';
                $repon_last_number = json_decode($this->spde2->postRequest($spde2_config['url_spde_last_number'], $data, $refer = "", $timeout = 3000, $header_lastnum));
                if (!empty($repon_last_number->data)) {
                    $letter_date = date("Y-m-d");
                    $letter_input_date = date("Y-m-d H:i:s");
                    $letter_to = $pdln_surat->pejabat_sign_sp;
                    $letter_perihal = $pdln_surat->jenis_permohonan;
                    $letter_lampiran = 1;
                    $data_nmr_surat = 'letter_penyampaian=' . rawurlencode('1')
                            . '&letter_date=' . rawurlencode($letter_date)
                            . '&letter_input_date=' . rawurlencode($letter_input_date)
                            . '&letter_number=' . rawurlencode($repon_last_number->data)
                            . '&letter_to=' . rawurlencode($pdln_surat->pejabat_sign_sp)
                            . '&letter_perihal=' . rawurlencode($str_hal)
                            . '&letter_lampiran=' . rawurlencode(1)
                            . '&letter_pengamanan=' . rawurlencode(1);
                    $checkout_last_number = json_decode($this->spde2->postRequest($spde2_config['url_spde_finish'], $data_nmr_surat, $refer = "", $timeout = 3000, $header_lastnum));
                    if ($checkout_last_number->status > 0) {
                        $number_format_sp = $checkout_last_number->data->letter_number;
                    }
                } else {
                    $data['status'] = FALSE;
                    $data['message'] = "Gagal menyimpan Nomor Surat ...";
                    echo json_encode($data);
                    exit();
                }
            } else {
                $data['status'] = FALSE;
                $data['message'] = "Gagal mendapatkan Nomor Surat SPDE2 ...";

                echo json_encode($data);
                exit;
            }
            // ====================SPDE2==========================
            if (!empty($number_format_sp)) {

                if ($pdln_surat->jenis_permohonan == '20') {
                    $sp_file = $this->print_perpanjangan_final($id_pdln, '');
                } elseif ($pdln_surat->jenis_permohonan == '30') {
                    $sp_file = $this->print_ralat_final($id_pdln, '');
                } elseif ($pdln_surat->jenis_permohonan == '40') {
                    $sp_file = $this->print_pembatalan_final($id_pdln, '');
                } else {
                    $sp_file = $this->cetak_permohonan_final($id_pdln, '');
                }
                /* Update Current Data Approval  */
                $data_update_approval = array(
                    'user_id' => $this->session->user_id,
                    'note' => $note,
                    'submit_date' => date('Y-m-d H:i:s'),
                    'aksi' => 'setuju',
                    'is_done' => 1,
                );
                $this->crud_ajax->init('t_approval_pdln', 'id', null);
                $where_approval = array('level' => $level, 'id_pdln' => $id_pdln, 'is_done' => 0);
                $affected_row_u = $this->crud_ajax->update($where_approval, $data_update_approval);
                /* Update status in pdln table */
                $this->crud_ajax->init('m_pdln', 'id', null);
                $data_pdln = array(
                    'no_sp' => $number_format_sp,
                    'tgl_sp' => strtotime(date('Y-m-d')),
                    'status' => 11,
                    'path_sp' => $sp_file
                );
                $where_pdln = array('id_pdln' => $id_pdln);
                $affected_row_u = $this->crud_ajax->update($where_pdln, $data_pdln);
                if (isset($sp_file) && $sp_file != null) {
                    $this->db->select(' m_pdln.id_pdln,m_pdln.id_kegiatan,m_pdln.no_sp,m_pdln.tgl_sp,
                                        m_pdln.tgl_surat_usulan_fp,m_pdln.no_surat_usulan_fp,m_pdln.pejabat_sign_sp,
                                        m_pdln.format_tembusan, m_pdln.id_pdln_lama, m_pdln.jenis_permohonan,
                                        m_pdln.path_sp, m_pdln.create_date, m_pdln.update_date');
                    $this->db->where('m_pdln.id_pdln', $id_pdln);
                    $data_pdln = $this->db->get('m_pdln')->row();

                    $esign_ok = $this->_callEsign($level_user, $data_pdln);
                    if ($esign_ok) {
                        $url_playstore = $this->config->item('url_playstore', 'pdln');
                        $url_appstore = $this->config->item('url_appstore', 'pdln');
                        $this->db->select('
                                        b.nama AS nama_pemohon,
                                        b.email AS email,
                                        a.negara_tujuan AS nama_negara,
                                        c.NamaKegiatan AS nama_kegiatan,
                                        a.start_date_keg AS tgl_mulai,
                                        a.end_date_keg AS tgl_selesai,
                                        d.no_register AS no_reg');
                        $this->db->from('view_log_peserta a');
                        $this->db->join('m_pemohon b', 'a.id_pemohon=b.id_pemohon');
                        $this->db->join('m_kegiatan c', 'c.id=a.id_kegiatan');
                        $this->db->join('m_pdln d', 'd.id_pdln=a.id_pdln');
                        $this->db->where('a.id_pdln', $id_pdln);
                        $query = $this->db->get();
                        foreach ($query->result() as $d) {
                            $body_setuju = "
                                <!DOCTYPE html>
                                <html>
                                <head>
                                <title>Persetujuan Izin Perjalanan Dinas Luar Negeri (PDLN)</title>
                                </head>
                                <body>
                                <p>Yth. Bapak/Ibu {$d->nama_pemohon}</p>
                                <p>Dengan hormat kami sampaikan bahwa permohonan PDLN Bapak/Ibu untuk
                                melakukan perjalanan dinas ke n{$d->nama_negara} dalam rangka {$d->nama_kegiatan}
                                mulai tanggal ".date('d-m-Y',$d->tgl_mulai)." s.d. ".date('d-m-Y',$d->tgl_selesai)." dengan nomor register {$d->no_reg},
                                telah mendapat persetujuan dari Kementerian Sekretariat Negara.</p>
                                <p>
                                Bapak/Ibu dapat mengunduh Surat Persetujuan dan menyampaikan laporan hasil penugasan PDLN tersebut
                                melalui aplikasi SIMPEL berbasis Android/iOS yang dapat didownload melalui link:
                                <ul>
                                <li>Aplikasi Android	: 	<a href='{$url_playstore}' style='color:#33f;text-decoration:underline;'>{$url_playstore}</a></li>
                                <li>Aplikasi iOS	: 	<a href='{$url_appstore}' style='color:#33f;text-decoration:underline;'>{$url_appstore}</a><li>
                                </ul>
                                </p>
                                <p>Informasi lebih lanjut dapat menghubungi administrator SIMPEL melalui email simple@setneg.go.id</p>
                                <p>&nbsp;</p>
                                <p>Hormat kami,<br>
                                Administrator SIMPEL<br>
                                Biro KTLN, Kementerian Sekretariat Negara</p>
                                </body>
                                </html>
                                ";
                            $data_email = array(
                                'to' => $d->email,
                                'subject' => 'Persetujuan Izin Perjalanan Dinas Luar Negeri (PDLN)',
                                'body' => $body_setuju
                            );
                            $is_send = $this->send_email($data_email);
                        }
                    }
                }
            } // if number spde ready
        }
    }

    public function tolak() {
        $this->_tolak_validate();
        $response['status'] = TRUE;
        echo json_encode($response);
    }

    /**
     * @method private _validate handle validation data users
     * @return json output status on form or modal
     */
    private function _tolak_validate() {
        $data = array();
        $data['error_string'] = array();
        $data['inputerror'] = array();
        $data['status'] = TRUE;
        $id_pdln = $this->input->post('id_pdln');
        $status = $this->input->post('status');
        $level = $this->input->post('level');
        $note = $this->input->post('note');
        $level_user = $this->db->get_where('m_user', array('UserID' => $this->session->user_id))->row()->level;
        if ($note === "") {
            $data['status'] = FALSE;
            $data['message'] = "Silahkan berikan catatan terlebih dahulu sebelum memberikan penolakan";
            echo json_encode($data);
            exit;
        }
        if ($data['status'] === TRUE) {
            /* Insert New Row To Next Approval */
            $this->crud_ajax->init('t_approval_pdln', 'id', null);
            $data_approval = array(
                'id_pdln' => $id_pdln,
                'assign_date' => date('Y-m-d H:i:s'),
                'level' => 'Focalpoint'
            );
            $insert_id_u = $this->crud_ajax->save($data_approval);
            /* Update Current Data Approval */
            $data_update_approval = array(
                'user_id' => $this->session->user_id,
                'note' => $note,
                'submit_date' => date('Y-m-d H:i:s'),
                'aksi' => 'tolak',
                'is_done' => 1
            );
            $where_approval = array('level' => $level, 'id_pdln' => $id_pdln, 'is_done' => 0);
            $affected_row_u = $this->crud_ajax->update($where_approval, $data_update_approval);
            /* Update status in pdln table */
            $this->crud_ajax->init('m_pdln', 'id', null);
            $data_pdln = array(
                'status' => 12,
            );
            $where_pdln = array('id_pdln' => $id_pdln);
            $affected_row_u = $this->crud_ajax->update($where_pdln, $data_pdln);
            if ($affected_row_u > 0) {
                $this->db->select('
                                b.nama AS nama_pemohon,
                                b.email AS email,
                                a.negara_tujuan AS nama_negara,
                                c.NamaKegiatan AS nama_kegiatan,
                                a.start_date_keg AS tgl_mulai,
                                a.end_date_keg AS tgl_selesai,
                                d.no_register AS no_reg');
                $this->db->from('view_log_peserta a');
                $this->db->join('m_pemohon b', 'a.id_pemohon=b.id_pemohon');
                $this->db->join('m_kegiatan c', 'c.id=a.id_kegiatan');
                $this->db->join('m_pdln d', 'd.id_pdln=a.id_pdln');
                $this->db->where('a.id_pdln', $id_pdln);
                $query = $this->db->get();
                foreach ($query->result() as $d) {
                    $body_tolak = "
                        <!DOCTYPE html>
                        <html>
                        <head>
                        <title>Pengembalian Berkas Permohonan Izin Perjalanan Dinas Luar Negeri (PDLN)</title>
                        </head>
                        <body>
                        <p>Yth. Bapak/Ibu {$d->nama_pemohon}</p>
                        <p>Dengan hormat kami sampaikan bahwa permohonan izin PDLN Bapak/Ibu untuk
                        melakukan perjalanan dinas ke {$d->nama_negara} dalam rangka {$d->nama_kegiatan}
                        mulai tanggal ".date('d-m-Y',$d->tgl_mulai)." sampai dengan ".date('d-m-Y',$d->tgl_selesai)." dengan nomor register {$d->no_reg},
                        telah dikembalikan kepada instansi pemohon dengan pertimbangan \"{$note}\".</p>
                        <p>Tindak lanjut atas berkas permohonan PDLN yang dikembalikan tersebut dapat dilakukan dengan
                        menghubungi Operator Focal Point SIMPEL pada masing-masing kementerian/lembaga.</p>
                        <p>Informasi lebih lanjut dapat menghubungi administrator SIMPEL melalui email simple@setneg.go.id</p>
                        <p>&nbsp;</p>
                        <p>Hormat kami,<br>
                        Administrator SIMPEL<br>
                        Biro KTLN, Kementerian Sekretariat Negara</p>
                        </body>
                        </html>
                        ";
                    $data_email = array(
                        'to' => $d->email,
                        'subject' => 'Pengembalian Berkas Permohonan Izin Perjalanan Dinas Luar Negeri (PDLN)',
                        'body' => $body_tolak
                    );
                    $is_send = $this->send_email($data_email);
                }
            }
        }
    }

    public function generate_number($JenisKegiatan) {
        $penomoran = $this->db->get_where('t_suratkeluar_increment', array('Status' => 1))->row();
        $jns_kegiatan = $this->db->get_where('r_jenis_kegiatan', array('ID' => $JenisKegiatan))->row();
        $years_update = date("Y", strtotime($penomoran->lastdate));
        $years_now = date('Y');
        if ($years_update < $years_now) {
            $number = intval(1);
        } else {
            $number = intval($penomoran->Nomor) + 1;
        }
        $number_str = (string) $number;
        // for format length nomor surat is 8 digit,make the zero number show in fix_number var
        for ($x = strlen($number_str); $x < 8; $x++) {
            $number_str = '0' . $number_str;
        }
        $fix_number = $penomoran->InitialCode . "-" . $number_str . "/" . $penomoran->Formatting . "/" . $jns_kegiatan->Kodifikasi . "/" . date('m') . "/" . date('Y');
        $data = array('Nomor' => $number);
        $this->db->where('Status', 1);
        $this->db->update('t_suratkeluar_increment', $data);
        return $fix_number;
    }

    public function get_parent_id() {
        $this->db->where('UserID', $this->session->userdata('user_id'));
        $parent = $this->db->get('m_user')->row()->unitkerja;
        return $parent; //unitkerja user fp sbg parent
    }

    public function get_list_pemohon() {
        $this->db->where('m_unit.Parent', $this->get_parent_id());
        $this->db->where('m_unit.Status', '1');
        $this->db->where_in('m_unit.Group', array(1, 2));
        $this->db->from('m_unit_kerja_institusi as m_unit');
        $this->db->join('m_user as mu', 'm_unit.ID = mu.unitkerja', 'left');
        $query = $this->db->get();
        if ($query->num_rows() > 0)
            return $query->result();
        return FALSE;
    }

    public function get_kegiatan() {
        $id_jenis = $this->input->post('id_jenis');
        $where = array(
            'JenisKegiatan' => $id_jenis,
            'Status' => '1'
        );
        $this->crud_ajax->init('m_kegiatan', 'ID', null);
        $this->crud_ajax->setExtraWhere($where);
        $query = $this->crud_ajax->get_data();
        if (count($query) > 0) {
            foreach ($query as $row) {
                echo '<option value="">--Pilih--</option>';
                echo '<option value="' . $row->ID . '">' . trim($row->NamaKegiatan) . '</option>';
            }
        } else
            echo '<option value="">--Kegiatan Tidak Tersedia--</option>';
    }

    public function get_detail_keg() {
        $id_kegiatan = $this->input->post('id_keg');
        $data = array();
        $this->db->from('view_kegiatan');
        $this->db->where('id_kegiatan', $id_kegiatan);
        $result = $this->db->get();
        if ($result->num_rows() > 0) {
            $data['status'] = TRUE;
            foreach ($result->result() as $row) {
                $data['penyelenggara'] = $row->penyelenggara;
                $data['negara'] = $row->nmnegara;
                $data['kota'] = $row->nmkota;
                $data['tgl_mulai_kegiatan'] = day($row->tgl_mulai_kegiatan);
                $data['tgl_akhir_kegiatan'] = day($row->tgl_akhir_kegiatan);
            }
            $data['status'] = TRUE;
        } else
            $data['status'] = FALSE;
        echo json_encode($data, JSON_PRETTY_PRINT);
    }

    public function progress() {
        $data['theme'] = 'pdln';
        $data['page'] = 'v_progress';
        $data['title'] = 'Permohonan Dalam Proses';
        $data['title_page'] = 'Permohonan Dalam Proses';
        $data['breadcrumb'] = 'Permohonan Dalam Proses';
        page_render($data);
    }

    public function progress_list() {
        $id_user = $this->session->user_id;
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $where = "";
        $handle_negara = $this->get_handle_negara($id_user);
        $this->crud_ajax->init('m_pdln', 'id_pdln', array('m_pdln.tgl_register' => 'asc'));
        if ($level == LEVEL_ANALIS) {
            $where = '3';
            // $this->db->where('m_pdln.status !=', "3");
            $this->db->where_in('negara', $handle_negara);
        } else
        if ($level == LEVEL_KASUBAG) {
            $where = '4';
            // $this->db->where('m_pdln.status !=', "4");
            $this->db->where_in('negara', $handle_negara);
        } else
        if ($level == LEVEL_KABAG) {
            $where = '5';
            // $this->db->where('m_pdln.status !=', "5");
        } else
        if ($level == LEVEL_KARO) {
            $where = '6';
            // $this->db->where('m_pdln.status !=', "6");
        } else
        if ($level == LEVEL_SESMEN) {
            $where = '7';
            // $this->db->where('m_pdln.status !=', "7");
        } else
        if ($level == LEVEL_TUSESMEN) {
            $where = '8';
            // $this->db->where('m_pdln.status !=', "8");
        } else
        if ($level == LEVEL_MENSESNEG) {
            $where = '9';
            // $this->db->where('m_pdln.status !=', "9");
        } else
        if ($level == LEVEL_TUMENSESNEG) {
            $where = '10';
            // $this->db->where('m_pdln.status !=', "10");
        } else {
            $this->db->where_not_in('m_pdln.status', array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12'));
        }
        $where_tambahan = array('m_pdln.status !=' => $where);

        $this->crud_ajax->set_select_field('m_pdln.id_pdln,m_pdln.no_register,m_pdln.tgl_register,m_pdln.status,
                                            m_pdln.no_surat_usulan_fp,m_pdln.create_date,m_kegiatan.NamaKegiatan,
                                            unit_kerja.Name as unit_pemohon,unit_kerja2.Name as unit_fp,m_pdln.jenis_permohonan');
        $join = array(
            'm_user as user1' => array('user1.UserID = m_pdln.unit_pemohon', 'left'),
            'm_unit_kerja_institusi as unit_kerja' => array('unit_kerja.ID = user1.unitkerja', 'left'),
            'm_kegiatan' => array('m_kegiatan.ID = m_pdln.id_kegiatan', 'left'),
            'm_user as user2' => array('user2.UserID = m_pdln.unit_fp', 'left'),
            'm_unit_kerja_institusi as unit_kerja2' => array('unit_kerja2.ID = user2.unitkerja', 'left')
        );

        $this->crud_ajax->setExtraWhere($where_tambahan);

        $this->crud_ajax->setJoinField($join);
        $list = $this->crud_ajax->get_datatables();
        $data = array();
        if (isset($_POST['start'])) {
            $no = $_POST['start'];
        } else {
            $no = 0;
        }
        foreach ($list as $pdln) {
            $no++;
            $row = array();
            $row[] = $pdln->id_pdln;
            $row[] = str_pad($pdln->no_register, 8, '0', STR_PAD_LEFT);
            $row[] = date("d/m/Y", ($pdln->tgl_register));
            $row[] = '<a href="' . base_url() . 'kotak_surat/approval/edit_task/' . $pdln->id_pdln . '"><button class="btn btn-sm green btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> View</button></a>';
            $row[] = $pdln->no_surat_usulan_fp;
            $row[] = $pdln->unit_pemohon;
            $row[] = $pdln->unit_fp;
            $row[] = '<span class="label label-' . setLabel($pdln->jenis_permohonan) . '">' . setJenisPermohonan($pdln->jenis_permohonan) . '</span>';
            $row[] = $pdln->NamaKegiatan;
            $row[] = '<span class="label label-danger">' . setStatus($pdln->status) . '</span>';

            $row[] = $pdln->tgl_register;
            $data[] = $row;
        }
        $output = array(
            "draw" => (isset($_POST['draw']) ? $_POST['draw'] : null),
            "recordsTotal" => $this->crud_ajax->count_all(),
            "recordsFiltered" => $this->crud_ajax->count_filtered(),
            "data" => $data,
        );
        echo json_encode($output);
    }

    public function retur() {
        $data['theme'] = 'pdln';
        $data['page'] = 'v_retur';
        $data['title'] = 'Permohonan Dikembalikan';
        $data['title_page'] = 'Permohonan Dikembalikan';
        $data['breadcrumb'] = 'Permohonan Dikembalikan';
        page_render($data);
    }

    public function retur_list() {
        $id_user = $this->session->user_id;
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $where = "";
        $handle_negara = $this->get_handle_negara($id_user);
        $this->crud_ajax->init('m_pdln', 'id_pdln', array('m_pdln.tgl_register' => 'asc'));
        if ($level == LEVEL_ANALIS || $level == LEVEL_KASUBAG) {
            $this->db->where_in('negara', $handle_negara);
            $where = array('m_pdln.status' => '12');
        } else if ($level == LEVEL_KABAG || $level == LEVEL_KARO || $level == LEVEL_SESMEN || $level == LEVEL_TUSESMEN || $level == LEVEL_MENSESNEG || $level == LEVEL_TUMENSESNEG) {
            $where = array('m_pdln.status' => '12');
        } else {
            $where = array('m_pdln.status' => 'not defined');
        }
        $this->crud_ajax->setExtraWhere($where);
        $this->crud_ajax->set_select_field('m_pdln.id_pdln,m_pdln.no_register,m_pdln.tgl_register,m_pdln.status,
                                            m_pdln.no_surat_usulan_fp,m_pdln.create_date,m_kegiatan.NamaKegiatan,
                                            unit_kerja.Name as unit_pemohon,unit_kerja2.Name as unit_fp,m_pdln.jenis_permohonan');
        $join = array(
            'm_user as user1' => array('user1.UserID = m_pdln.unit_pemohon', 'left'),
            'm_unit_kerja_institusi as unit_kerja' => array('unit_kerja.ID = user1.unitkerja', 'left'),
            'm_kegiatan' => array('m_kegiatan.ID = m_pdln.id_kegiatan', 'left'),
            'm_user as user2' => array('user2.UserID = m_pdln.unit_fp', 'left'),
            'm_unit_kerja_institusi as unit_kerja2' => array('unit_kerja2.ID = user2.unitkerja', 'left')
        );
        $this->crud_ajax->setJoinField($join);
        $list = $this->crud_ajax->get_datatables();
        $data = array();
        $no = (isset($_POST['start'])) ? $_POST['start'] : 0;
        foreach ($list as $pdln) {
            $no++;
            $row = array();
            $row[] = $pdln->id_pdln;
            $row[] = str_pad($pdln->no_register, 8, '0', STR_PAD_LEFT);
            $row[] = date("d/m/Y", ($pdln->tgl_register));
            $row[] = '<a href="' . base_url() . 'kotak_surat/approval/edit_task/' . $pdln->id_pdln . '"><button class="btn btn-sm green btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> View</button></a>';
            $row[] = $pdln->no_surat_usulan_fp;
            $row[] = $pdln->unit_pemohon;
            $row[] = $pdln->unit_fp;
            $row[] = '<span class="label label-' . setLabel($pdln->jenis_permohonan) . '">' . setJenisPermohonan($pdln->jenis_permohonan) . '</span>';
            $row[] = $pdln->NamaKegiatan;
            $row[] = '<span class="label label-info">' . setStatus($pdln->status) . '</span>';
            $row[] = $pdln->tgl_register;
            $data[] = $row;
        }
        $output = array(
            "draw" => (isset($_POST['draw']) ? $_POST['draw'] : null),
            "recordsTotal" => $this->crud_ajax->count_all(),
            "recordsFiltered" => $this->crud_ajax->count_filtered(),
            "data" => $data
        );
        echo json_encode($output);
    }

    public function done() {
        $data['theme'] = 'pdln';
        $data['page'] = 'v_done';
        $data['title'] = 'Permohonan Sudah Disetujui';
        $data['title_page'] = 'Permohonan Sudah Disetujui';
        $data['breadcrumb'] = 'Permohonan Sudah Disetujui';
        page_render($data);
    }

    public function done_list() {
        $id_user = $this->session->user_id;
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $where = "";
        $handle_negara = $this->get_handle_negara($id_user);
        $this->crud_ajax->init('m_pdln', 'id_pdln', array('m_pdln.tgl_register' => 'asc'));
        if ($level == LEVEL_ANALIS || $level == LEVEL_KASUBAG) {
            $this->db->where_in('negara', $handle_negara);
            $where = array('m_pdln.status' => '11');
        } else if ($level == LEVEL_KABAG || $level == LEVEL_KARO || $level == LEVEL_SESMEN || $level == LEVEL_TUSESMEN || $level == LEVEL_MENSESNEG || $level == LEVEL_TUMENSESNEG) {
            $where = array('m_pdln.status' => '11');
        } else {
            $where = array('m_pdln.status' => 'not defined');
        }
        $this->crud_ajax->setExtraWhere($where);
        $this->crud_ajax->set_select_field('m_pdln.id_signed,m_pdln.id_pdln,m_pdln.no_register,m_pdln.tgl_register,m_pdln.status,m_pdln.no_surat_usulan_fp,
                                            m_pdln.create_date,m_kegiatan.NamaKegiatan,unit_kerja.Name as unit_pemohon,
                                            unit_kerja2.Name as unit_fp,m_pdln.jenis_permohonan');
        $join = array(
            'm_user as user1' => array('user1.UserID = m_pdln.unit_pemohon', 'left'),
            'm_unit_kerja_institusi as unit_kerja' => array('unit_kerja.ID = user1.unitkerja', 'left'),
            'm_kegiatan' => array('m_kegiatan.ID = m_pdln.id_kegiatan', 'left'),
            'm_user as user2' => array('user2.UserID = m_pdln.unit_fp', 'left'),
            'm_unit_kerja_institusi as unit_kerja2' => array('unit_kerja2.ID = user2.unitkerja', 'left')
        );
        $this->crud_ajax->setJoinField($join);
        $list = $this->crud_ajax->get_datatables();
        $data = array();
        $no = (isset($_POST['start'])) ? $_POST['start'] : 0;
        foreach ($list as $pdln) {
            $no++;
            $row = array();
            $row[] = $pdln->id_pdln;
            $row[] = str_pad($pdln->no_register, 8, '0', STR_PAD_LEFT);
            $row[] = date("d/m/Y", ($pdln->tgl_register));
            $row[] = '<span class="label label-info">' . setStatus($pdln->status) . '</span>';
            $row[] = '<a href="' . base_url() . 'kotak_surat/approval/edit_task/' . $pdln->id_pdln . '"><button class="btn btn-sm green btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> View</button></a>';
            if ($pdln->id_signed) {
                $row[] = '<a href="' . base_url() . 'kotak_surat/approval/download/' . $pdln->id_pdln . '" target="_blank"><button class="btn btn-sm green btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> Download</button></a>';
            } else {
                $row[] = '<button id="download_sp" class="btn btn-sm green btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> Download</button>';
            }


            $row[] = $pdln->no_surat_usulan_fp;
            $row[] = $pdln->unit_pemohon;
            $row[] = $pdln->unit_fp;
            $row[] = '<span class="label label-' . setLabel($pdln->jenis_permohonan) . '">' . setJenisPermohonan($pdln->jenis_permohonan) . '</span>';
            $row[] = $pdln->NamaKegiatan;
            $row[] = $pdln->tgl_register;
            $data[] = $row;
        }
        $output = array(
            "draw" => (isset($_POST['draw']) ? $_POST['draw'] : null),
            "recordsTotal" => $this->crud_ajax->count_all(),
            "recordsFiltered" => $this->crud_ajax->count_filtered(),
            "data" => $data
        );
        echo json_encode($output);
    }

    public function archive() {
        $data['theme'] = 'pdln';
        $data['page'] = 'v_archive';
        $data['title'] = 'Permohonan Sudah DiArsip';
        $data['title_page'] = 'Permohonan Sudah DiArsip';
        $data['breadcrumb'] = 'Permohonan Sudah DiArsip';
        page_render($data);
    }

    public function archive_list() {
        $id_user = $this->session->user_id;
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $where = "";
        $handle_negara = $this->get_handle_negara($id_user);
        $this->crud_ajax->init('m_pdln', 'id_pdln', array('m_pdln.tgl_register' => 'asc'));
        if ($level == LEVEL_ANALIS || $level == LEVEL_KASUBAG) {
            $this->db->where_in('negara', $handle_negara);
            $where = array('m_pdln.status' => '200');
        } else if ($level == LEVEL_KABAG || $level == LEVEL_KARO || $level == LEVEL_SESMEN || $level == LEVEL_TUSESMEN || $level == LEVEL_MENSESNEG || $level == LEVEL_TUMENSESNEG) {
            $where = array('m_pdln.status' => '200');
        } else {
            $where = array('m_pdln.status' => 'not defined');
        }
        $this->crud_ajax->setExtraWhere($where);
        $this->crud_ajax->set_select_field('m_pdln.id_pdln,m_pdln.no_register,m_pdln.tgl_register,m_pdln.status,m_pdln.no_surat_usulan_fp,m_pdln.create_date,m_kegiatan.NamaKegiatan,
                                            unit_kerja.Name as unit_pemohon,unit_kerja2.Name as unit_fp,m_pdln.jenis_permohonan');
        $join = array(
            'm_user as user1' => array('user1.UserID = m_pdln.unit_pemohon', 'left'),
            'm_unit_kerja_institusi as unit_kerja' => array('unit_kerja.ID = user1.unitkerja', 'left'),
            'm_kegiatan' => array('m_kegiatan.ID = m_pdln.id_kegiatan', 'left'),
            'm_user as user2' => array('user2.UserID = m_pdln.unit_fp', 'left'),
            'm_unit_kerja_institusi as unit_kerja2' => array('unit_kerja2.ID = user2.unitkerja', 'left')
        );
        $this->crud_ajax->setJoinField($join);
        $list = $this->crud_ajax->get_datatables();
        $data = array();
        $no = (isset($_POST['start'])) ? $_POST['start'] : 0;
        foreach ($list as $pdln) {
            $no++;
            $row = array();
            $row[] = $pdln->id_pdln;
            $row[] = str_pad($pdln->no_register, 8, '0', STR_PAD_LEFT);
            $row[] = date("d/m/Y", ($pdln->tgl_register));
            $row[] = '<a href="' . base_url() . 'kotak_surat/approval/view_arsip/' . $pdln->id_pdln . '"><button class="btn btn-sm green btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> View</button></a>';
            $row[] = $pdln->no_surat_usulan_fp;
            $row[] = $pdln->unit_pemohon;
            $row[] = $pdln->unit_fp;
            $row[] = '<span class="label label-' . setLabel($pdln->jenis_permohonan) . '">' . setJenisPermohonan($pdln->jenis_permohonan) . '</span>';
            $row[] = $pdln->NamaKegiatan;
            $row[] = '<span class="label label-info">' . setStatus($pdln->status) . '</span>';
            $row[] = $pdln->tgl_register;
            $data[] = $row;
        }
        $output = array(
            "draw" => (isset($_POST['draw']) ? $_POST['draw'] : null),
            "recordsTotal" => $this->crud_ajax->count_all(),
            "recordsFiltered" => $this->crud_ajax->count_filtered(),
            "data" => $data
        );
        echo json_encode($output);
    }

    public function view_arsip($id_pdln) {
        $where = array('Status' => '1');
        $this->crud_ajax->init('r_template_tembusan', 'ID', null);
        $this->crud_ajax->setExtraWhere($where);
        $data['list_temp_tembusan'] = $this->crud_ajax->get_data();
        $data['id_pdln'] = $id_pdln;
        $this->crud_ajax->init('t_approval_pdln', 'id', null);
        $where_pdln = array('id_pdln' => $id_pdln, 'is_done' => 1);
        $this->crud_ajax->setExtraWhere($where_pdln);
        $data['list_approval'] = $this->crud_ajax->get_data(); //get history approval
        $this->db->select('p.id_pdln,p.id_kegiatan,p.no_surat_usulan_pemohon,p.tgl_surat_usulan_pemohon,p.no_surat_usulan_fp,
                           p.tgl_surat_usulan_fp,p.pejabat_sign_sp,p.id_level_pejabat,p.format_tembusan,p.jenis_permohonan,
                           p.status,p.id_level_pejabat,p.author');
        $this->db->where('p.id_pdln', $id_pdln);
        $this->db->from('m_pdln p');
        // $this->db->join("r_level_pejabat lp", "lp.id = p.id_level_pejabat");
        $data['data_pdln'] = $this->db->get()->row();
        //-----------------------------------------------------------------------------------------------------
        // Memastikan bahwa level pejabat tertentu atau pengguna tertentu yang dapat melakukan perubahan data
        //-----------------------------------------------------------------------------------------------------
        $id_user = $this->session->user_id;
        $data_user = $this->db->get_where('m_user', array('UserID' => $id_user))->row();
        $level = $data_user->level;
        $this->config->load('pdln', TRUE);
        $data_integrity = $this->config->item('data_integrity', 'pdln');
        $id_level_pejabat = $data['data_pdln']->id_level_pejabat;
        if (!empty($data['data_pdln']) && $data['data_pdln']->author != $id_user && (array_key_exists($id_level_pejabat, $data_integrity) == false || $data_integrity[$id_level_pejabat] != $level)
        //&& in_array($data['data_pdln']->status, $pdln_status) == false
        ) {
            //show_error("Anda tidak memiliki akses terhadap halaman atau data di halaman ini. ", 403, "Forbidden");
        }
        //-----------------------------------------------------------------------------------------------------
        $this->db->select('m_kegiatan.ID,NamaKegiatan,StartDate,EndDate,r_negara.nmnegara,r_kota.nmkota,r_jenis_kegiatan.Nama as JenisKegiatan');
        $this->db->where('m_kegiatan.ID', $data['data_pdln']->id_kegiatan);
        $this->db->from('m_kegiatan');
        $this->db->join('r_negara', 'r_negara.id = m_kegiatan.negara');
        $this->db->join('r_kota', 'r_kota.id = m_kegiatan.tujuan');
        $this->db->join('r_jenis_kegiatan', 'r_jenis_kegiatan.ID = m_kegiatan.JenisKegiatan');
        $data['detail_kegiatan'] = $this->db->get()->row();
        $data['theme'] = 'pdln';
        $data['page'] = 'v_view_arsip';
        $data['title'] = 'Form Arsip';
        $data['title_page'] = 'Form Arsip';
        $data['breadcrumb'] = 'Form Arsip';
        page_render($data);
    }

    public function do_archiv($id_pdln) {
        $response['status'] = false;
        $note = $this->input->post('note');
        if ($note === "") {
            $data['status'] = FALSE;
            $data['message'] = "Silahkan berikan catatan terlebih dahulu sebelum menjadikan !!!";
            echo json_encode($data);
            exit;
        }
        if (!empty($id_pdln)) {
            $data = array(
                'status' => 200
            );
            $this->db->where('id_pdln', $id_pdln);
            $affected_rows = $this->db->update('m_pdln', $data);
            $level_user = $this->db->get_where('m_user', array('UserID' => $this->session->user_id))->row()->level;
            $level_name = $this->db->get_where('m_level', array('LevelID' => $level_user))->row()->NamaLevel;
            $data_approval = array(
                'id_pdln' => $id_pdln,
                'user_id' => $this->session->user_id,
                'note' => $this->input->post('note'),
                'submit_date' => date("Y-m-d H:i:s"),
                'assign_date' => '',
                'level' => $level_name,
                'aksi' => 'Arsip',
                'is_done' => 1
            );
            $insert_id_approval = $this->db->insert('t_approval_pdln', $data_approval);
            $response['status'] = TRUE;
            $response['msg'] = "Dokumen berhasil di Arsipkan";
        }
        echo json_encode($response);
    }

    public function get_handle_negara($id_user) {
        $this->db->select('RoleID');
        $this->db->from('t_user_role');
        $this->db->where('UserID', $id_user);
        $query = $this->db->get();
        $list_role = $query->result();
        $list_negara = array();
        foreach ($list_role as $role) {
            $id = $this->input->post('RoleID');
            $this->db->select('*');
            $this->db->from('t_role_negara');
            $this->db->where('RoleID', $role->RoleID);
            $query = $this->db->get();
            foreach ($query->result() as $row) {
                $list_negara[] = $row->NegaraID;
            }
        }
        return $list_negara;
    }

    public function get_data_pdln() {
        $response = array();
        $id_pdln = $this->input->post('id_pdln');
        $this->db->select('p.id_kegiatan,p.no_surat_usulan_pemohon,
                           p.tgl_surat_usulan_pemohon,p.id_level_pejabat,
                           p.no_surat_usulan_fp,p.pejabat_sign_sp');
        $this->db->from('m_pdln as p');
        $this->db->where('id_pdln', $id_pdln);
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            $row = $query->row();
            $response = array(
                'id_kegiatan' => $row->id_kegiatan,
                'no_surat_usulan_pemohon' => $row->no_surat_usulan_pemohon,
                'tgl_surat_usulan_pemohon' => $row->tgl_surat_usulan_pemohon,
                'id_level_pejabat' => $row->id_level_pejabat,
                'no_surat_usulan_fp' => $row->no_surat_usulan_fp,
                'pejabat_sign_sp' => $row->pejabat_sign_sp,
                'status' => TRUE
            );
        } else {
            $response['status'] = FALSE;
        }
        echo json_encode($response);
    }

    public function cetak_permohonan_final($id_surat) {
        $id_user = $this->session->user_id;
        setlocale(LC_ALL, 'id_ID');
        $this->db->select('m_pdln.id_pdln,m_pdln.id_kegiatan,m_pdln.id_level_pejabat,m_pdln.no_sp,m_pdln.tgl_sp,
                           m_pdln.tgl_surat_usulan_fp,m_pdln.no_surat_usulan_fp,m_pdln.pejabat_sign_sp,
                           m_pdln.format_tembusan,m_pdln.penandatangan_persetujuan,m_pdln.barcode,r_kota.nmkota,
                           m_pdln.update_date,m_pdln.create_date,m_pdln.path_sp');
        $this->db->join('m_user', 'm_user.UserID = m_pdln.unit_fp');
        $this->db->join('r_institution', 'r_institution.ID = m_user.instansi');
        $this->db->join('r_kota', 'r_kota.id = r_institution.Kota');
        $this->db->where('m_pdln.id_pdln', $id_surat);
        $result_data = $this->db->get('m_pdln')->row();
        // ----------------------------------------------------------------------
        // checking existing file
        // ----------------------------------------------------------------------
        $this->config->load('pdln', TRUE);
        $base_path = $this->config->item('pdln_upload_path', 'pdln');
        $update_date = $result_data->update_date;
        $create_date = $result_data->create_date;
        $month = month(date('n', $create_date));
        $year = date('Y', $create_date);
        $additional_path = $year . '/' . $month . '/pdln/' . $id_surat . "/";
        $targetPath = $base_path . $additional_path;
        if (!is_dir($targetPath)) {
            mkdir($targetPath, 0777, TRUE);
        }
        $filename = $result_data->path_sp;
        $filename = is_null($filename) ? "sp_pdln_{$id_surat}_{$update_date}.pdf" : $filename;
        $fullpath = "{$targetPath}{$filename}";
        // READY FOR METADATA
        if (file_exists($fullpath)) {
            send_file_to_browser($fullpath); // this function will exec die() and exit
        }
        $this->db->select('r_unit_tembusan.Nama');
        $this->db->join('r_unit_tembusan', 'r_unit_tembusan.ID = t_template_unit_tembusan.UnitID');
        $this->db->where('TemplateID', $result_data->format_tembusan);
        $unit_tembusan = $this->db->get('t_template_unit_tembusan')->result();
        $this->db->select('t_log_peserta.id_log_peserta,t_log_peserta.start_date,t_log_peserta.end_date,m_pemohon.nama,
                           m_pemohon.jabatan,m_pemohon.nip_nrp,r_institution.Nama as instansi,m_pemohon.instansi_lainnya,
                           m_pemohon.id_instansi,t_log_peserta.id_kategori_biaya,t_log_peserta.id_biaya');
        $this->db->join('m_pemohon', 'm_pemohon.id_pemohon = t_log_peserta.id_pemohon');
        $this->db->join('r_institution', 'r_institution.ID = m_pemohon.id_instansi', 'left');
        $this->db->where('id_pdln', $id_surat);
        $temp_pemohon = $this->db->get('t_log_peserta');
        $list_pemohon = array();
        foreach ($temp_pemohon->result() as $pemohon) {
            $list_pemohon[$pemohon->id_log_peserta] = $pemohon;
            $list_pemohon[$pemohon->id_log_peserta]->pembiayaan = $this->_get_detail_pembiayaan($pemohon->id_kategori_biaya, $pemohon->id_biaya); // Get the categories sub categories
        }
        $pejabat_persetujuan_surat = $result_data->penandatangan_persetujuan;
        $id_user_plh = $this->session->user_id;
        $data_user_plh = $this->db->get_where('m_user', array('UserID' => $id_user_plh))->row()->is_plh;
        $jenis_plh = '';
        if ($data_user_plh) {
            $pejabat_persetujuan_surat = $id_user_plh;
        }
        $this->db->select('m_kegiatan.NamaKegiatan, m_kegiatan.StartDate, m_kegiatan.EndDate, r_negara.nmnegara as Negara');
        $this->db->join('r_negara', 'r_negara.ID = m_kegiatan.negara', 'left');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('*');
        $this->db->where('m_user.UserID', $pejabat_persetujuan_surat);
        $penandatangan_persetujuan = $this->db->get('m_user')->row();
        $label_penandatangan = $this->get_label_penandatangan($pejabat_persetujuan_surat, $result_data->id_level_pejabat);
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $data = array(
            'title' => "Surat Persetujuan",
            'unit_tembusan' => $unit_tembusan,
            'level' => $level,
            'data_sp' => $result_data,
            'kegiatan' => $kegiatan,
            'penandatangan' => $penandatangan_persetujuan,
            'label_penandatangan' => $label_penandatangan,
            'm_pdf' => $this->load->library('M_pdf'));
        $html = $this->load->view('kotak_surat/v_print_permohonan', $data, TRUE);
        $data = array(
            'title' => "Lampiran SP",
            'data_lampiran' => $result_data,
            'level' => $level,
            'kegiatan' => $kegiatan,
            'list_pemohon' => $list_pemohon,
            'penandatangan' => $penandatangan_persetujuan,
            'label_penandatangan' => $label_penandatangan,
            'm_pdf' => $this->load->library('M_pdf'));
        $html_lampiran = $this->load->view('kotak_surat/v_print_lampiran_permohonan', $data, TRUE);
        $this->load->library('M_pdf');
        $this->m_pdf->pdf->AddPage('P', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $qr_link = base_url() . $this->config->item('url_esign', 'pdln') . $id_surat;
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html);
        $this->m_pdf->pdf->AddPage('L', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html_lampiran);
        setlocale(LC_ALL, 'id_ID');
        $this->m_pdf->debug = true;
        $this->m_pdf->pdf->Output($fullpath, 'F');
        //send_file_to_browser($fullpath);
        //$this->m_pdf->pdf->Output($filename,'I');
        return $filename;
    }

    private function _get_detail_pembiayaan($id_karegori_biaya, $id_biaya) {
        if ($id_karegori_biaya == "0") {
            $this->db->select('t_ref_pembiayaan_tunggal.id_log_dana_tunggal,r_institution.Nama');
            $this->db->where('id_log_dana_tunggal', $id_biaya);
            $this->db->join('r_institution', "r_institution.ID = t_ref_pembiayaan_tunggal.id_instansi", "left");
            return $this->db->get('t_ref_pembiayaan_tunggal')->row()->Nama;
        } else if ($id_karegori_biaya == "1") {
            $this->db->select('t_pemb.id_dana_campuran,ref_camp.by,r_jenis_pembiayaan.Description AS jenis_biaya,
                                (CASE WHEN ref_camp.by=1 THEN t_pemb.instansi_gov WHEN ref_camp.by=2 THEN t_pemb.instansi_donor
                                ELSE 0 END) AS id_instansi_pembiayaan', false);
            $this->db->where('t_pemb.id_dana_campuran', $id_biaya);
            $this->db->from('t_pembiayaan_campuran t_pemb');
            $this->db->join('t_ref_pembiayaan_campuran as ref_camp', "t_pemb.id_dana_campuran = ref_camp.id_dana_campuran");
            $this->db->join('r_jenis_pembiayaan', "r_jenis_pembiayaan.ID = ref_camp.id_jenis_biaya");
            $pembiayaan = "";
            foreach ($this->db->get()->result() as $pembiaya) {
                $id_instansi = $pembiaya->id_instansi_pembiayaan;
                if ($id_instansi == 0) {
                    $pembiayaan = $pembiayaan . "- " . $pembiaya->jenis_biaya . " : Perseorangan";
                } else {
                    $pembiayaan = $pembiayaan . "- " . $pembiaya->jenis_biaya . " : " . $this->db->select('*')->where("ID = $id_instansi")->get('r_institution')->row()->Nama . '<br/><br/>';
                }
            }
            return $pembiayaan;
        }
    }

    public function print_permohonan($id_surat, $template_tembusan = '') {
        $id_user = $this->session->user_id;
        setlocale(LC_ALL, 'id_ID');
        $this->db->select('m_pdln.id_signed,m_pdln.id_pdln,m_pdln.id_kegiatan,m_pdln.id_level_pejabat,m_pdln.no_sp,m_pdln.tgl_sp,m_pdln.tgl_surat_usulan_fp,m_pdln.no_surat_usulan_fp,m_pdln.pejabat_sign_sp,
                            m_pdln.path_sp,m_pdln.format_tembusan,m_pdln.penandatangan_persetujuan,m_pdln.barcode,r_kota.nmkota,m_pdln.update_date,m_pdln.create_date');
        $this->db->join('m_user', 'm_user.UserID = m_pdln.unit_fp');
        $this->db->join('r_institution', 'r_institution.ID = m_user.instansi');
        $this->db->join('r_kota', 'r_kota.id = r_institution.Kota');
        $this->db->where('m_pdln.id_pdln', $id_surat);
        $result_data = $this->db->get('m_pdln')->row();
        // ----------------------------------------------------------------------
        // checking existing file
        // ----------------------------------------------------------------------
        $this->config->load('pdln', TRUE);
        $base_path = $this->config->item('pdln_upload_path', 'pdln');
        $update_date = $result_data->update_date;
        $create_date = $result_data->create_date;
        $month = month(date('n', $create_date));
        $year = date('Y', $create_date);
        $additional_path = $year . '/' . $month . '/pdln/' . $id_surat . "/";
        $targetPath = $base_path . $additional_path;
        // READY FOR METADATA
        if (!is_dir($targetPath)) {
            mkdir($targetPath, 0777, TRUE);
        }
        $filename = $result_data->path_sp;
        $filename = is_null($filename) ? "sp_pdln_{$id_surat}_{$update_date}.pdf" : $filename;
        $fullpath = "{$targetPath}{$filename}";
        // READY FOR METADATA
        if (file_exists($fullpath)) {
            send_file_to_browser($fullpath); // this function will exec die() and exit
        }
        // ----------------------------------------------------------------------
        if ($template_tembusan > 0) {
            $id_tembusan = $template_tembusan;
        } else {
            $id_tembusan = $result_data->format_tembusan;
        }
        $this->db->select('r_unit_tembusan.Nama');
        $this->db->join('r_unit_tembusan', 'r_unit_tembusan.ID = t_template_unit_tembusan.UnitID');
        $this->db->where('TemplateID', $id_tembusan);
        $unit_tembusan = $this->db->get('t_template_unit_tembusan')->result();
        $this->db->select('t_log_peserta.id_log_peserta,t_log_peserta.start_date,t_log_peserta.end_date,m_pemohon.nama,m_pemohon.jabatan,m_pemohon.nip_nrp,
                            r_institution.Nama as instansi,m_pemohon.instansi_lainnya,m_pemohon.id_instansi,t_log_peserta.id_kategori_biaya,t_log_peserta.id_biaya');
        $this->db->join('m_pemohon', 'm_pemohon.id_pemohon = t_log_peserta.id_pemohon');
        $this->db->join('r_institution', 'r_institution.ID = m_pemohon.id_instansi');
        $this->db->where('id_pdln', $id_surat);
        $temp_pemohon = $this->db->get('t_log_peserta');
        $list_pemohon = array();
        foreach ($temp_pemohon->result() as $pemohon) {
            $list_pemohon[$pemohon->id_log_peserta] = $pemohon;
            $list_pemohon[$pemohon->id_log_peserta]->pembiayaan = $this->_get_detail_pembiayaan($pemohon->id_kategori_biaya, $pemohon->id_biaya); // Get the categories sub categories
        }

        $pejabat_persetujuan_surat = $result_data->penandatangan_persetujuan;
        $id_user_plh = $this->session->user_id;
        $data_user_plh = $this->db->get_where('m_user', array('UserID' => $id_user_plh))->row()->is_plh;
        $jenis_plh = '';
        if ($data_user_plh) {
            $pejabat_persetujuan_surat = $id_user_plh;
        }

        $this->db->select('m_kegiatan.NamaKegiatan,m_kegiatan.StartDate,m_kegiatan.EndDate,r_negara.nmnegara as Negara');
        $this->db->join('r_negara', 'r_negara.ID = m_kegiatan.negara', 'left');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('*');
        $this->db->where('m_user.UserID', $pejabat_persetujuan_surat);
        $penandatangan_persetujuan = $this->db->get('m_user')->row();
        $label_penandatangan = $this->get_label_penandatangan($pejabat_persetujuan_surat, $result_data->id_level_pejabat);
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $data = array(
            'level' => $level,
            'title' => "Surat Persetujuan",
            'unit_tembusan' => $unit_tembusan,
            'data_sp' => $result_data,
            'kegiatan' => $kegiatan,
            'penandatangan' => $penandatangan_persetujuan,
            'label_penandatangan' => $label_penandatangan,
            'm_pdf' => $this->load->library('M_pdf'));
        $html = $this->load->view('kotak_surat/v_print_permohonan', $data, TRUE);
        $data = array(
            'level' => $level,
            'title' => "Lampiran SP",
            'data_lampiran' => $result_data,
            'kegiatan' => $kegiatan,
            'list_pemohon' => $list_pemohon,
            'label_penandatangan' => $label_penandatangan,
            'm_pdf' => $this->load->library('M_pdf'));
        $html_lampiran = $this->load->view('kotak_surat/v_print_lampiran_permohonan', $data, TRUE);
        //$filename = 'sp_pdln' . $id_surat . '_' . date('d_m_Y');
        $this->load->library('M_pdf');
        $this->m_pdf->pdf->AddPage('P', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $qr_link = base_url() . $this->config->item('url_esign', 'pdln') . $id_surat;
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $html = mb_convert_encoding($html, 'UTF-8', 'UTF-8');
        $this->m_pdf->pdf->WriteHTML($html);
        $this->m_pdf->pdf->AddPage('L', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $html_lampiran = mb_convert_encoding($html_lampiran, 'UTF-8', 'UTF-8');
        $this->m_pdf->pdf->WriteHTML($html_lampiran);
        $this->m_pdf->pdf->Output($filename . '.pdf', 'I');
        // $this->m_pdf->pdf->Output($fullpath, 'F');
        // update sp_path on table m_pdln
        $this->db->reset_query();
        $this->db->set('path_sp', $filename);
        $this->db->where('id_pdln', $id_surat);
        if (!$this->db->update('m_pdln')) {
            die('Gagal mengupdate data path_sp, silahkan hubungi Administrator.');
        }
        send_file_to_browser($fullpath);
    }

    public function print_perpanjangan($id_surat, $template_tembusan = '') {

        $id_user = $this->session->user_id;
        setlocale(LC_ALL, 'id_ID');
        $this->db->select('m_pdln.id_level_pejabat,m_pdln.penandatangan_persetujuan, m_pdln.id_pdln, m_pdln.id_kegiatan, m_pdln.no_sp, m_pdln.tgl_sp, m_pdln.tgl_surat_usulan_fp,
                            m_pdln.no_surat_usulan_fp, m_pdln.pejabat_sign_sp, m_pdln.format_tembusan, m_pdln.id_pdln_lama,
                            m_pdln.create_date,m_pdln.update_date');

        $this->db->where('m_pdln.id_pdln', $id_surat);
        $result_data = $this->db->get('m_pdln')->row();
        // ----------------------------------------------------------------------
        // checking existing file
        // ----------------------------------------------------------------------
        $this->config->load('pdln', TRUE);
        $base_path = $this->config->item('pdln_upload_path', 'pdln');
        $update_date = $result_data->update_date;
        $create_date = $result_data->create_date;
        $month = month(date('n', $create_date));
        $year = date('Y', $create_date);
        $additional_path = $year . '/' . $month . '/pdln/' . $id_surat . "/";
        $targetPath = $base_path . $additional_path;
        if (!is_dir($targetPath)) {
            mkdir($targetPath, 0777, TRUE);
        }
        $filename = $result_data->path_sp;
        $filename = is_null($filename) ? "sp_pdln_{$id_surat}_{$update_date}.pdf" : $filename;
        $fullpath = "{$targetPath}{$filename}";
        // READY FOR METADATA
        if (file_exists($fullpath)) {
            send_file_to_browser($fullpath); // this function will exec die() and exit
        }
        // ----------------------------------------------------------------------
        if ($template_tembusan > 0) {
            $id_tembusan = $template_tembusan;
        } else {
            $id_tembusan = $result_data->format_tembusan;
        }
        $this->db->select('r_unit_tembusan.Nama');
        $this->db->join('r_unit_tembusan', 'r_unit_tembusan.ID = t_template_unit_tembusan.UnitID');
        $this->db->where('TemplateID', $id_tembusan);
        $unit_tembusan = $this->db->get('t_template_unit_tembusan')->result();
        $this->db->select('t_log_peserta.id_log_peserta,m_pemohon.nama,m_pemohon.jabatan');
        $this->db->join('m_pemohon', 'm_pemohon.id_pemohon = t_log_peserta.id_pemohon');
        $this->db->where('id_pdln', $id_surat);
        $list_pemohon = $this->db->get('t_log_peserta')->result();
        $this->db->select('m_kegiatan.NamaKegiatan');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('m_pdln.no_sp, m_pdln.tgl_sp');
        $this->db->where('m_pdln.id_pdln', $result_data->id_pdln_lama);
        $pdln_lama = $this->db->get('m_pdln')->row();
        // =====penandatangan=====
        $pejabat_persetujuan_surat = $result_data->penandatangan_persetujuan;
        $id_user_plh = $this->session->user_id;
        $data_user_plh = $this->db->get_where('m_user', array('UserID' => $id_user_plh))->row()->is_plh;
        $jenis_plh = '';
        if ($data_user_plh) {
            $pejabat_persetujuan_surat = $id_user_plh;
        }

        $this->db->select('m_kegiatan.NamaKegiatan,m_kegiatan.StartDate,m_kegiatan.EndDate,r_negara.nmnegara as Negara');
        $this->db->join('r_negara', 'r_negara.ID = m_kegiatan.negara', 'left');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('*');
        $this->db->where('m_user.UserID', $pejabat_persetujuan_surat);
        $penandatangan_persetujuan = $this->db->get('m_user')->row();
        $label_penandatangan = $this->get_label_penandatangan($pejabat_persetujuan_surat, $result_data->id_level_pejabat);
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        // =======penandatangan======
        $data = array(
            'title' => "Surat Persetujuan",
            'level' => $level,
            'label_penandatangan' => $label_penandatangan,
            'penandatangan' => $penandatangan_persetujuan,
            'unit_tembusan' => $unit_tembusan,
            'data_sp' => $result_data,
            'kegiatan' => $kegiatan,
            'data_sp_lama' => $pdln_lama,
            'm_pdf' => $this->load->library('M_pdf'));
        $html = $this->load->view('kotak_surat/v_print_perpanjangan', $data, TRUE);
        $data = array(
            'title' => "Lampiran SP",
            'data_lampiran' => $result_data,
            'label_penandatangan' => $label_penandatangan,
            'penandatangan' => $penandatangan_persetujuan,
            'list_pemohon' => $list_pemohon,
            'm_pdf' => $this->load->library('M_pdf'));
        $html_lampiran = $this->load->view('kotak_surat/v_print_lampiran_perpanjangan', $data, TRUE);
        $this->load->library('M_pdf');
        $this->m_pdf->pdf->AddPage('P', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $qr_link = base_url() . $this->config->item('url_esign', 'pdln') . $id_surat;
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html);
        $this->m_pdf->pdf->AddPage('L', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html_lampiran);
        $this->m_pdf->pdf->Output($filename . '.pdf', 'I');
        //send_file_to_browser($fullpath); // this function will exec die() and exit
    }

    public function print_ralat($id_surat, $template_tembusan = '') {
        $id_user = $this->session->user_id;
        setlocale(LC_ALL, 'id_ID');
        $this->db->select('m_pdln.id_level_pejabat,m_pdln.penandatangan_persetujuan,m_pdln.id_pdln, m_pdln.id_kegiatan, m_pdln.no_sp, m_pdln.tgl_sp, m_pdln.tgl_surat_usulan_fp,
                           m_pdln.no_surat_usulan_fp, m_pdln.pejabat_sign_sp, m_pdln.format_tembusan, m_pdln.id_pdln_lama,
                           m_pdln.update_date,m_pdln.create_date');
        $this->db->where('m_pdln.id_pdln', $id_surat);
        $result_data = $this->db->get('m_pdln')->row();
        // ----------------------------------------------------------------------
        // checking existing file
        // ----------------------------------------------------------------------
        $this->config->load('pdln', TRUE);
        $base_path = $this->config->item('pdln_upload_path', 'pdln');
        $update_date = $result_data->update_date;
        $create_date = $result_data->create_date;
        $month = date('m', $create_date);
        $year = date('Y', $create_date);
        $additional_path = $year . '/' . $month . '/pdln/' . $id_surat . "/";
        $targetPath = $base_path . $additional_path;
        if (!is_dir($targetPath)) {
            mkdir($targetPath, 0777, TRUE);
        }
        $filename = $result_data->path_sp;
        $filename = is_null($filename) ? "sp_pdln_{$id_surat}_{$update_date}.pdf" : $filename;
        $fullpath = "{$targetPath}{$filename}";
        // READY FOR METADATA
        if (file_exists($fullpath)) {
            send_file_to_browser($fullpath); // this function will exec die() and exit
        }
        // ----------------------------------------------------------------------
        if ($template_tembusan > 0) {
            $id_tembusan = $template_tembusan;
        } else {
            $id_tembusan = $result_data->format_tembusan;
        }
        $this->db->select('r_unit_tembusan.Nama');
        $this->db->join('r_unit_tembusan', 'r_unit_tembusan.ID = t_template_unit_tembusan.UnitID');
        $this->db->where('TemplateID', $id_tembusan);
        $unit_tembusan = $this->db->get('t_template_unit_tembusan')->result();
        $this->db->select('t_log_peserta.id_log_peserta,m_pemohon.nama,m_pemohon.jabatan');
        $this->db->join('m_pemohon', 'm_pemohon.id_pemohon = t_log_peserta.id_pemohon');
        $this->db->where('id_pdln', $id_surat);
        $list_pemohon = $this->db->get('t_log_peserta')->result();
        $this->db->select('m_kegiatan.NamaKegiatan');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('m_pdln.no_sp, m_pdln.tgl_sp');
        $this->db->where('m_pdln.id_pdln', $result_data->id_pdln_lama);
        $pdln_lama = $this->db->get('m_pdln')->row();

        $pejabat_persetujuan_surat = $result_data->penandatangan_persetujuan;
        $id_user_plh = $this->session->user_id;
        $data_user_plh = $this->db->get_where('m_user', array('UserID' => $id_user_plh))->row()->is_plh;
        $jenis_plh = '';
        if ($data_user_plh) {
            $pejabat_persetujuan_surat = $id_user_plh;
        }

        $this->db->select('m_kegiatan.NamaKegiatan,m_kegiatan.StartDate,m_kegiatan.EndDate,r_negara.nmnegara as Negara');
        $this->db->join('r_negara', 'r_negara.ID = m_kegiatan.negara', 'left');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('*');
        $this->db->where('m_user.UserID', $pejabat_persetujuan_surat);
        $penandatangan_persetujuan = $this->db->get('m_user')->row();
        $label_penandatangan = $this->get_label_penandatangan($pejabat_persetujuan_surat, $result_data->id_level_pejabat);
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $data = array(
            'title' => "Surat Persetujuan",
            'level' => $level,
            'label_penandatangan' => $label_penandatangan,
            'penandatangan' => $penandatangan_persetujuan,
            'unit_tembusan' => $unit_tembusan,
            'data_sp' => $result_data,
            'kegiatan' => $kegiatan,
            'data_sp_lama' => $pdln_lama,
            'm_pdf' => $this->load->library('M_pdf'));
        $html = $this->load->view('kotak_surat/v_print_ralat', $data, TRUE);
        $data = array(
            'title' => "Lampiran SP",
            'label_penandatangan' => $label_penandatangan,
            'penandatangan' => $penandatangan_persetujuan,
            'data_lampiran' => $result_data,
            'list_pemohon' => $list_pemohon,
            'm_pdf' => $this->load->library('M_pdf'));
        $html_lampiran = $this->load->view('kotak_surat/v_print_lampiran_ralat', $data, TRUE);
        $this->load->library('M_pdf');
        $this->m_pdf->pdf->AddPage('P', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $qr_link = base_url() . $this->config->item('url_esign', 'pdln') . $id_surat;
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html);
        $this->m_pdf->pdf->AddPage('L', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html_lampiran);
        $this->m_pdf->pdf->Output($filename . '.pdf', 'I');
        //send_file_to_browser($fullpath);
    }

    public function print_pembatalan($id_surat, $template_tembusan = '') {
        $id_user = $this->session->user_id;
        setlocale(LC_ALL, 'id_ID');
        $this->db->select('m_pdln.penandatangan_persetujuan,m_pdln.id_level_pejabat,m_pdln.id_level_pejabat,m_pdln.penandatangan_persetujuan,m_pdln.id_pdln, m_pdln.id_kegiatan, m_pdln.no_sp, m_pdln.tgl_sp, m_pdln.tgl_surat_usulan_fp,
                           m_pdln.no_surat_usulan_fp, m_pdln.pejabat_sign_sp, m_pdln.format_tembusan, m_pdln.id_pdln_lama,
                           m_pdln.create_date, m_pdln.update_date');
        $this->db->where('m_pdln.id_pdln', $id_surat);
        $result_data = $this->db->get('m_pdln')->row();
        // ----------------------------------------------------------------------
        // checking existing file
        // ----------------------------------------------------------------------
        $this->config->load('pdln', TRUE);
        $base_path = $this->config->item('pdln_upload_path', 'pdln');
        $update_date = $result_data->update_date;
        $create_date = $result_data->create_date;
        $month = month(date('n', $create_date));
        $year = date('Y', $create_date);
        $additional_path = $year . '/' . $month . '/pdln/' . $id_surat . "/";
        $targetPath = $base_path . $additional_path;
        if (!is_dir($targetPath)) {
            mkdir($targetPath, 0777, TRUE);
        }
        $filename = $result_data->path_sp;
        $filename = is_null($filename) ? "sp_pdln_{$id_surat}_{$update_date}.pdf" : $filename;
        $fullpath = "{$targetPath}{$filename}";
        // READY FOR METADATA
        if (file_exists($fullpath)) {
            send_file_to_browser($fullpath); // this function will exec die() and exit
        }
        // ----------------------------------------------------------------------
        if ($template_tembusan > 0) {
            $id_tembusan = $template_tembusan;
        } else {
            $id_tembusan = $result_data->format_tembusan;
        }
        $this->db->select('r_unit_tembusan.Nama');
        $this->db->join('r_unit_tembusan', 'r_unit_tembusan.ID = t_template_unit_tembusan.UnitID');
        $this->db->where('TemplateID', $id_tembusan);
        $unit_tembusan = $this->db->get('t_template_unit_tembusan')->result();
        $this->db->select('t_log_peserta.id_log_peserta,m_pemohon.nama,m_pemohon.jabatan');
        $this->db->join('m_pemohon', 'm_pemohon.id_pemohon = t_log_peserta.id_pemohon');
        $this->db->where('id_pdln', $id_surat);
        $list_pemohon = $this->db->get('t_log_peserta')->result();
        $this->db->select('m_kegiatan.NamaKegiatan');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('m_pdln.no_sp, m_pdln.tgl_sp');
        $this->db->where('m_pdln.id_pdln', $result_data->id_pdln_lama);
        $pdln_lama = $this->db->get('m_pdln')->row();
        $pejabat_persetujuan_surat = $result_data->penandatangan_persetujuan;
        $id_user_plh = $this->session->user_id;
        $data_user_plh = $this->db->get_where('m_user', array('UserID' => $id_user_plh))->row()->is_plh;
        $jenis_plh = '';
        if ($data_user_plh) {
            $pejabat_persetujuan_surat = $id_user_plh;
        }

        $this->db->select('m_kegiatan.NamaKegiatan,m_kegiatan.StartDate,m_kegiatan.EndDate,r_negara.nmnegara as Negara');
        $this->db->join('r_negara', 'r_negara.ID = m_kegiatan.negara', 'left');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('*');
        $this->db->where('m_user.UserID', $pejabat_persetujuan_surat);
        $penandatangan_persetujuan = $this->db->get('m_user')->row();
        $label_penandatangan = $this->get_label_penandatangan($pejabat_persetujuan_surat, $result_data->id_level_pejabat);
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $data = array(
            'title' => "Surat Persetujuan",
            'level' => $level,
            'label_penandatangan' => $label_penandatangan,
            'penandatangan' => $penandatangan_persetujuan,
            'unit_tembusan' => $unit_tembusan,
            'data_sp' => $result_data,
            'kegiatan' => $kegiatan,
            'data_sp_lama' => $pdln_lama,
            'm_pdf' => $this->load->library('M_pdf'));
        $html = $this->load->view('kotak_surat/v_print_pembatalan', $data, TRUE);
        /*
          $data = array(
          'title' => "Lampiran SP",
          'data_lampiran' => $result_data,
          'list_pemohon' => $list_pemohon,
          'm_pdf' => $this->load->library('M_pdf'));
          $html_lampiran = $this->load->view('kotak_surat/v_print_lampiran_pembatalan', $data, TRUE);
         */
        $this->load->library('M_pdf');
        $this->m_pdf->pdf->AddPage('P', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $qr_link = base_url() . $this->config->item('url_esign', 'pdln') . $id_surat;
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html);
        $this->m_pdf->pdf->Output($filename . '.pdf', 'I');
        //send_file_to_browser($fullpath); // this function will exec die() and exit
    }

    public function get_list_peserta() {
        $id_pdln = $this->uri->segment(4);
        $this->crud_ajax->init('t_log_peserta', 'id_log_peserta', NULL);
        $join = array(
            'm_pemohon' => array('m_pemohon.id_pemohon = t_log_peserta.id_pemohon', 'left'),
            'r_institution' => array('m_pemohon.id_instansi = r_institution.ID', 'left'),
        );
        $this->crud_ajax->setJoinField($join);
        $this->crud_ajax->set_select_field('id_log_peserta,m_pemohon.id_pemohon,id_kategori_biaya,id_biaya,m_pemohon.paspor,nik,nip_nrp,m_pemohon.nama nama_peserta,jabatan,start_date,end_date,r_institution.Nama,m_pemohon.id_instansi,instansi_lainnya');
        $where_data = array(
            'id_pdln' => $id_pdln
        );
        $this->crud_ajax->setExtraWhere($where_data);
        $list = $this->crud_ajax->get_datatables();
        $data = array();
        $no = (isset($_POST['start'])) ? $_POST['start'] : 0;
        foreach ($list as $peserta) {
            $row = array();
            $row[] = $peserta->id_log_peserta;
            $row[] = ++$no . '.';
            $row[] = $peserta->nip_nrp;
            $row[] = $peserta->nik;
            $row[] = $peserta->nama_peserta;
            $row[] = ucwords($peserta->jabatan);
            $row[] = (empty($peserta->start_date) || empty($peserta->end_date)) ? '' : day(date("Y-m-d", $peserta->start_date)) . ' s.d ' . day(date("Y-m-d", $peserta->end_date));
            $row[] = ($peserta->id_kategori_biaya == 1) ? "Campuran" : "Tunggal";
            $row[] = ((empty($peserta->id_instansi)) OR ( $peserta->id_instansi) == 0 ) ? $peserta->instansi_lainnya : $peserta->Nama;
            $id_peserta = $peserta->id_log_peserta;
            $result = $this->db->get_where('view_biaya_log_peserta', array("id_log_peserta" => $id_peserta));
            if ($result->num_rows() > 0) {
                $biaya;
                foreach ($result->result() as $value) {
                    $biaya = $value->biaya;
                }
                $row[] = (empty($biaya)) ? '' : 'Rp. ' . number_format(intval($biaya));
            } else {
                $row[] = '';
            }
            $row[] = '<a onClick="view_peserta(' . $id_peserta . ')" id="v' . $no . '" title="View" class="btn btn-xs view_peserta"><i class="fa fa-search"></i>&nbsp; View </button>';
            $data[] = $row;
        }
        $output = array(
            "draw" => (isset($_POST['draw']) ? $_POST['draw'] : NULL),
            "recordsTotal" => $this->crud_ajax->count_filtered(),
            "recordsFiltered" => $this->crud_ajax->count_filtered(),
            "data" => $data,
            "query" => $this->db->last_query()
        );
        echo json_encode($output);
    }

    public function get_label_penandatangan($id_user, $level_pejabat) {
        $data_user_plh = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->is_plh;
        $jenis_plh = '';
        if ($data_user_plh) {

            $sekarang = date("Y-m-d");
            $this->db->select('jenis_plh,start_date,end_date');
            $this->db->where('id_user_plh', $id_user);
            $this->db->limit(1);
            $this->db->order_by('id_plh', 'desc');
            $jenis = $this->db->get('t_log_plh')->row();
            $str_date = strtotime($jenis->start_date);
            $end_date = strtotime($jenis->end_date);
            $now_date = strtotime($sekarang);
            if (isset($jenis->jenis_plh) && ($now_date >= $str_date) && ($now_date <= $end_date)) {
                $jenis_plh = $jenis->jenis_plh;
            }
        }
        $label = "";
        if ($level_pejabat == 4) {
            if ($jenis_plh == LEVEL_SESMEN) {
                $label = "Plh. Sekretaris Kementerian Sekretariat Negara";
            } else {
                $label = "   Sekretaris Kementerian Sekretariat Negara";
            }
        } else if ($level_pejabat == 5) {

            if ($jenis_plh == LEVEL_KARO) {
                $label = "a.n. Sekretaris Kementerian Sekretariat Negara <br/>
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Plh. Kepala Biro Kerja Sama Teknik Luar Negeri";
            } else {
                $label = "a.n.  Sekretaris Kementerian Sekretariat Negara <br/>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Kepala Biro Kerja Sama Teknik Luar Negeri";
            }
        } else {
            if ($jenis_plh == LEVEL_SESMEN) {
                $label = "a.n. Menteri Sekretaris Negara <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Plh. Sekretaris Kementerian Sekretariat Negara";
            } else {
                $label = "a.n. Menteri Sekretaris Negara <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sekretaris Kementerian Sekretariat Negara";
            }
        }

        return $label;
    }

    public function get_detail_tembusan() {
        $template_tembusan = $this->input->post('template_tembusan');
        if ($template_tembusan === "0" || !isset($template_tembusan)) {
            $data['status'] = FALSE;
            $data['message'] = "Silahkan pilih salah satu format tembusan terlebih dahulu";
            echo json_encode($data);
            exit;
        } else {
            $data['status'] = TRUE;
            $data['nama_format'] = $this->db->where('ID', $template_tembusan)->get('r_template_tembusan')->row()->Nama;
            $data['message'] = "";
            $this->db->select('*');
            $this->db->from('t_template_unit_tembusan');
            $this->db->where('TemplateID', $template_tembusan);
            $query = $this->db->get();
            $no = 1;
            foreach ($query->result() as $row) {
                $data['message'] = $data['message'] . "<br/>" . $no . ". " . $this->db->where('ID', $row->UnitID)->get('r_unit_tembusan')->row()->Nama;
                $no++;
            }
            $data['message'] = $data['message'] . "<br/>" . $no . ". Yang Bersangkutan";
            echo json_encode($data);
        }
    }

    public function all_list() {
        $id_user = $this->session->user_id;
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $where = "";
        $handle_negara = $this->get_handle_negara($id_user);
        $this->crud_ajax->init('m_pdln', 'id_pdln', array('m_pdln.id_level_pejabat' => 'asc', 'm_pdln.tgl_register' => 'asc'));
        /*
          if ($level == LEVEL_ANALIS || $level == LEVEL_KASUBAG) {
          $this->db->where_in('negara', $handle_negara);
          $where = array('m_pdln.status' => '11');
          } else if ($level == LEVEL_KABAG || $level == LEVEL_KARO || $level == LEVEL_SESMEN || $level == LEVEL_TUSESMEN || $level == LEVEL_MENSESNEG || $level == LEVEL_TUMENSESNEG) {
          $where = array('m_pdln.status' => '11');
          } else {
          $where = array('m_pdln.status' => 'not defined');
          }
          $this->crud_ajax->setExtraWhere($where);
         */
        $this->crud_ajax->set_select_field('
			m_pdln.id_pdln,m_pdln.no_register,m_pdln.tgl_register,m_pdln.status,
			m_pdln.no_surat_usulan_fp,m_pdln.create_date,m_kegiatan.NamaKegiatan,m_pdln.id_level_pejabat,
            unit_kerja.Name as unit_pemohon,unit_kerja2.Name as unit_fp,m_pdln.jenis_permohonan
		');
        $join = array(
            'm_user as user1' => array('user1.UserID = m_pdln.unit_pemohon', 'left'),
            'm_unit_kerja_institusi as unit_kerja' => array('unit_kerja.ID = user1.unitkerja', 'left'),
            'm_kegiatan' => array('m_kegiatan.ID = m_pdln.id_kegiatan', 'left'),
            'm_user as user2' => array('user2.UserID = m_pdln.unit_fp', 'left'),
            'm_unit_kerja_institusi as unit_kerja2' => array('unit_kerja2.ID = user2.unitkerja', 'left')
        );
        $this->crud_ajax->setJoinField($join);
        //$this->db->order_by('m_pdln.id_pdln', 'DESC');
        $list = $this->crud_ajax->get_datatables();
        $data = array();
        $no = (isset($_POST['start'])) ? $_POST['start'] : 0;
        foreach ($list as $pdln) {
            $no++;
            $row = array();
            $unit_pemohon = '';
            $unit_fp = '';
            $no_surat_usulan_fp = '';
            if ($pdln->no_surat_usulan_fp != 'undefined') {
                $no_surat_usulan_fp = $pdln->no_surat_usulan_fp;
            }
            if ($pdln->unit_pemohon != 'undefined') {
                $unit_pemohon = $pdln->unit_pemohon;
            }
            if ($pdln->unit_fp != 'undefined') {
                $unit_fp = $pdln->unit_fp;
            }
            $klaster = (in_array($pdln->id_level_pejabat, array(1, 2)) ? "<i class='fa fa-circle red'></i>" : (in_array($pdln->id_level_pejabat, array(3, 4)) ? "<i class='fa fa-heart blue'></i>" : ""));
            $row[] = $pdln->id_pdln;
            $row[] = $klaster;
            $row[] = str_pad($pdln->no_register, 8, '0', STR_PAD_LEFT);
            $row[] = date("d/m/Y", ($pdln->tgl_register));
            $row[] = '<a href="' . base_url() . 'kotak_surat/approval/edit_task/' . $pdln->id_pdln . '"><button class="btn btn-sm green btn-outline filter-submit margin-bottom"><i class="fa fa-search"></i> View</button></a>';
            $row[] = '<button type="button" id="download_sp" title="Unduh" class="btn btn-xs btn-info"><i class="fa fa-download"></i> </button>';
            $row[] = $no_surat_usulan_fp;
            $row[] = $unit_pemohon;
            $row[] = $unit_fp;
            $row[] = '<span class="label label-' . setLabel($pdln->jenis_permohonan) . '">' . setJenisPermohonan($pdln->jenis_permohonan) . '</span>';
            $row[] = $pdln->NamaKegiatan;
            $row[] = '<span class="label ' . ($pdln->status == '8' ? 'label-danger' : ($pdln->status == '7' ? 'label-warning' : 'label-info')) . '">' . setStatus($pdln->status) . '</span>';

            $row[] = $pdln->tgl_register;
            $data[] = $row;
        }
        $output = array(
            "draw" => (isset($_POST['draw']) ? $_POST['draw'] : null),
            "recordsTotal" => $this->crud_ajax->count_all(),
            "recordsFiltered" => $this->crud_ajax->count_filtered(),
            "data" => $data
        );
        echo json_encode($output);
    }

    public function print_perpanjangan_final($id_surat, $template_tembusan = '') {
        $id_user = $this->session->user_id;
        setlocale(LC_ALL, 'id_ID');
        $this->db->select('m_pdln.penandatangan_persetujuan,m_pdln.id_level_pejabat,m_pdln.id_pdln, m_pdln.id_kegiatan, m_pdln.no_sp, m_pdln.tgl_sp, m_pdln.tgl_surat_usulan_fp,
                            m_pdln.no_surat_usulan_fp, m_pdln.pejabat_sign_sp, m_pdln.format_tembusan, m_pdln.id_pdln_lama,
                            m_pdln.create_date,m_pdln.update_date ,m_pdln.path_sp');
        $this->db->where('m_pdln.id_pdln', $id_surat);
        $result_data = $this->db->get('m_pdln')->row();
        // ----------------------------------------------------------------------
        // checking existing file
        // ----------------------------------------------------------------------
        $this->config->load('pdln', TRUE);
        $base_path = $this->config->item('pdln_upload_path', 'pdln');
        $update_date = $result_data->update_date;
        $create_date = $result_data->create_date;
        $month = month(date('n', $create_date));
        $year = date('Y', $create_date);
        $additional_path = $year . '/' . $month . '/pdln/' . $id_surat . "/";
        $targetPath = $base_path . $additional_path;
        if (!is_dir($targetPath)) {
            mkdir($targetPath, 0777, TRUE);
        }
        $filename = $result_data->path_sp;
        $filename = is_null($filename) ? "sp_pdln_{$id_surat}_{$update_date}.pdf" : $filename;
        $fullpath = "{$targetPath}{$filename}";
        // READY FOR METADATA
        if (file_exists($fullpath)) {
            send_file_to_browser($fullpath); // this function will exec die() and exit
        }
        // ----------------------------------------------------------------------
        if ($template_tembusan > 0) {
            $id_tembusan = $template_tembusan;
        } else {
            $id_tembusan = $result_data->format_tembusan;
        }
        $this->db->select('r_unit_tembusan.Nama');
        $this->db->join('r_unit_tembusan', 'r_unit_tembusan.ID = t_template_unit_tembusan.UnitID');
        $this->db->where('TemplateID', $id_tembusan);
        $unit_tembusan = $this->db->get('t_template_unit_tembusan')->result();
        $this->db->select('t_log_peserta.id_log_peserta,m_pemohon.nama,m_pemohon.jabatan');
        $this->db->join('m_pemohon', 'm_pemohon.id_pemohon = t_log_peserta.id_pemohon');
        $this->db->where('id_pdln', $id_surat);
        $list_pemohon = $this->db->get('t_log_peserta')->result();
        $this->db->select('m_kegiatan.NamaKegiatan');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('m_pdln.no_sp, m_pdln.tgl_sp');
        $this->db->where('m_pdln.id_pdln', $result_data->id_pdln_lama);
        $pdln_lama = $this->db->get('m_pdln')->row();
        $pejabat_persetujuan_surat = $result_data->penandatangan_persetujuan;
        $id_user_plh = $this->session->user_id;
        $data_user_plh = $this->db->get_where('m_user', array('UserID' => $id_user_plh))->row()->is_plh;
        $jenis_plh = '';
        if ($data_user_plh) {
            $pejabat_persetujuan_surat = $id_user_plh;
        }

        $this->db->select('m_kegiatan.NamaKegiatan,m_kegiatan.StartDate,m_kegiatan.EndDate,r_negara.nmnegara as Negara');
        $this->db->join('r_negara', 'r_negara.ID = m_kegiatan.negara', 'left');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('*');
        $this->db->where('m_user.UserID', $pejabat_persetujuan_surat);
        $penandatangan_persetujuan = $this->db->get('m_user')->row();
        $label_penandatangan = $this->get_label_penandatangan($pejabat_persetujuan_surat, $result_data->id_level_pejabat);
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $data = array(
            'title' => "Surat Persetujuan",
            'level' => $level,
            'label_penandatangan' => $label_penandatangan,
            'penandatangan' => $penandatangan_persetujuan,
            'unit_tembusan' => $unit_tembusan,
            'data_sp' => $result_data,
            'kegiatan' => $kegiatan,
            'data_sp_lama' => $pdln_lama,
            'm_pdf' => $this->load->library('M_pdf'));
        $html = $this->load->view('kotak_surat/v_print_perpanjangan', $data, TRUE);
        $data = array(
            'title' => "Lampiran SP",
            'level' => $level,
            'label_penandatangan' => $label_penandatangan,
            'penandatangan' => $penandatangan_persetujuan,
            'data_lampiran' => $result_data,
            'list_pemohon' => $list_pemohon,
            'm_pdf' => $this->load->library('M_pdf'));
        $html_lampiran = $this->load->view('kotak_surat/v_print_lampiran_perpanjangan', $data, TRUE);
        $this->load->library('M_pdf');
        $this->m_pdf->pdf->AddPage('P', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $qr_link = base_url() . $this->config->item('url_esign', 'pdln') . $id_surat;
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html);
        $this->m_pdf->pdf->AddPage('L', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html_lampiran);
        $this->m_pdf->pdf->Output($fullpath, 'F');
        //send_file_to_browser($fullpath); // this function will exec die() and exit
    }

    public function print_ralat_final($id_surat, $template_tembusan = '') {
        $id_user = $this->session->user_id;
        setlocale(LC_ALL, 'id_ID');
        $this->db->select('m_pdln.penandatangan_persetujuan,m_pdln.id_level_pejabat,m_pdln.id_pdln, m_pdln.id_kegiatan, m_pdln.no_sp, m_pdln.tgl_sp, m_pdln.tgl_surat_usulan_fp,
                            m_pdln.no_surat_usulan_fp, m_pdln.pejabat_sign_sp, m_pdln.format_tembusan, m_pdln.id_pdln_lama,
                            m_pdln.update_date,m_pdln.create_date, m_pdln.path_sp');
        $this->db->where('m_pdln.id_pdln', $id_surat);
        $result_data = $this->db->get('m_pdln')->row();
        // ----------------------------------------------------------------------
        // checking existing file
        // ----------------------------------------------------------------------
        $this->config->load('pdln', TRUE);
        $base_path = $this->config->item('pdln_upload_path', 'pdln');
        $update_date = $result_data->update_date;
        $create_date = $result_data->create_date;
        $month = date('m', $create_date);
        $year = date('Y', $create_date);
        $additional_path = $year . '/' . $month . '/pdln/' . $id_surat . "/";
        $targetPath = $base_path . $additional_path;
        if (!is_dir($targetPath)) {
            mkdir($targetPath, 0777, TRUE);
        }
        $filename = $result_data->path_sp;
        $filename = is_null($filename) ? "sp_pdln_{$id_surat}_{$update_date}.pdf" : $filename;
        $fullpath = "{$targetPath}{$filename}";
        // READY FOR METADATA
        if (file_exists($fullpath)) {
            send_file_to_browser($fullpath); // this function will exec die() and exit
        }
        // ----------------------------------------------------------------------
        if ($template_tembusan > 0) {
            $id_tembusan = $template_tembusan;
        } else {
            $id_tembusan = $result_data->format_tembusan;
        }
        $this->db->select('r_unit_tembusan.Nama');
        $this->db->join('r_unit_tembusan', 'r_unit_tembusan.ID = t_template_unit_tembusan.UnitID');
        $this->db->where('TemplateID', $id_tembusan);
        $unit_tembusan = $this->db->get('t_template_unit_tembusan')->result();
        $this->db->select('t_log_peserta.id_log_peserta,m_pemohon.nama,m_pemohon.jabatan');
        $this->db->join('m_pemohon', 'm_pemohon.id_pemohon = t_log_peserta.id_pemohon');
        $this->db->where('id_pdln', $id_surat);
        $list_pemohon = $this->db->get('t_log_peserta')->result();
        $this->db->select('m_kegiatan.NamaKegiatan');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('m_pdln.no_sp, m_pdln.tgl_sp');
        $this->db->where('m_pdln.id_pdln', $result_data->id_pdln_lama);
        $pdln_lama = $this->db->get('m_pdln')->row();

        $pejabat_persetujuan_surat = $result_data->penandatangan_persetujuan;
        $id_user_plh = $this->session->user_id;
        $data_user_plh = $this->db->get_where('m_user', array('UserID' => $id_user_plh))->row()->is_plh;
        $jenis_plh = '';
        if ($data_user_plh) {
            $pejabat_persetujuan_surat = $id_user_plh;
        }

        $this->db->select('m_kegiatan.NamaKegiatan,m_kegiatan.StartDate,m_kegiatan.EndDate,r_negara.nmnegara as Negara');
        $this->db->join('r_negara', 'r_negara.ID = m_kegiatan.negara', 'left');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('*');
        $this->db->where('m_user.UserID', $pejabat_persetujuan_surat);
        $penandatangan_persetujuan = $this->db->get('m_user')->row();
        $label_penandatangan = $this->get_label_penandatangan($pejabat_persetujuan_surat, $result_data->id_level_pejabat);
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $data = array(
            'title' => "Surat Persetujuan",
            'level' => $level,
            'label_penandatangan' => $label_penandatangan,
            'penandatangan' => $penandatangan_persetujuan,
            'unit_tembusan' => $unit_tembusan,
            'data_sp' => $result_data,
            'kegiatan' => $kegiatan,
            'data_sp_lama' => $pdln_lama,
            'm_pdf' => $this->load->library('M_pdf'));
        $html = $this->load->view('kotak_surat/v_print_ralat', $data, TRUE);
        $data = array(
            'title' => "Lampiran SP",
            'level' => $level,
            'label_penandatangan' => $label_penandatangan,
            'penandatangan' => $penandatangan_persetujuan,
            'data_lampiran' => $result_data,
            'list_pemohon' => $list_pemohon,
            'm_pdf' => $this->load->library('M_pdf'));
        $html_lampiran = $this->load->view('kotak_surat/v_print_lampiran_ralat', $data, TRUE);
        $this->load->library('M_pdf');
        $this->m_pdf->pdf->AddPage('P', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $qr_link = base_url() . $this->config->item('url_esign', 'pdln') . $id_surat;
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html);
        $this->m_pdf->pdf->AddPage('L', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html_lampiran);
        $this->m_pdf->pdf->Output($fullpath, 'F');
        //send_file_to_browser($fullpath);
        // $this->m_pdf->pdf->Output($fullpath, 'F');
    }

    public function print_pembatalan_final($id_surat, $template_tembusan = '') {
        $id_user = $this->session->user_id;
        setlocale(LC_ALL, 'id_ID');
        $this->db->select('m_pdln.penandatangan_persetujuan,m_pdln.id_level_pejabat,m_pdln.id_pdln, m_pdln.id_kegiatan, m_pdln.no_sp, m_pdln.tgl_sp, m_pdln.tgl_surat_usulan_fp,
                            m_pdln.no_surat_usulan_fp, m_pdln.pejabat_sign_sp, m_pdln.format_tembusan, m_pdln.id_pdln_lama,
                            m_pdln.create_date, m_pdln.update_date, m_pdln.path_sp');
        $this->db->where('m_pdln.id_pdln', $id_surat);
        $result_data = $this->db->get('m_pdln')->row();
        // ----------------------------------------------------------------------
        // checking existing file
        // ----------------------------------------------------------------------
        $this->config->load('pdln', TRUE);
        $base_path = $this->config->item('pdln_upload_path', 'pdln');
        $update_date = $result_data->update_date;
        $create_date = $result_data->create_date;
        $month = month(date('n', $create_date));
        $year = date('Y', $create_date);
        $additional_path = $year . '/' . $month . '/pdln/' . $id_surat . "/";
        $targetPath = $base_path . $additional_path;
        if (!is_dir($targetPath)) {
            mkdir($targetPath, 0777, TRUE);
        }
        $filename = $result_data->path_sp;
        $filename = is_null($filename) ? "sp_pdln_{$id_surat}_{$update_date}.pdf" : $filename;
        $fullpath = "{$targetPath}{$filename}";
        // READY FOR METADATA
        if (file_exists($fullpath)) {
            send_file_to_browser($fullpath); // this function will exec die() and exit
        }
        // ----------------------------------------------------------------------
        if ($template_tembusan > 0) {
            $id_tembusan = $template_tembusan;
        } else {
            $id_tembusan = $result_data->format_tembusan;
        }
        $this->db->select('r_unit_tembusan.Nama');
        $this->db->join('r_unit_tembusan', 'r_unit_tembusan.ID = t_template_unit_tembusan.UnitID');
        $this->db->where('TemplateID', $template_tembusan);
        $unit_tembusan = $this->db->get('t_template_unit_tembusan')->result();
        $this->db->select('t_log_peserta.id_log_peserta,m_pemohon.nama,m_pemohon.jabatan');
        $this->db->join('m_pemohon', 'm_pemohon.id_pemohon = t_log_peserta.id_pemohon');
        $this->db->where('id_pdln', $id_surat);
        $list_pemohon = $this->db->get('t_log_peserta')->result();
        $this->db->select('m_kegiatan.NamaKegiatan');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('m_pdln.no_sp, m_pdln.tgl_sp');
        $this->db->where('m_pdln.id_pdln', $result_data->id_pdln_lama);
        $pdln_lama = $this->db->get('m_pdln')->row();

        $pejabat_persetujuan_surat = $result_data->penandatangan_persetujuan;
        $id_user_plh = $this->session->user_id;
        $data_user_plh = $this->db->get_where('m_user', array('UserID' => $id_user_plh))->row()->is_plh;
        $jenis_plh = '';
        if ($data_user_plh) {
            $pejabat_persetujuan_surat = $id_user_plh;
        }

        $this->db->select('m_kegiatan.NamaKegiatan,m_kegiatan.StartDate,m_kegiatan.EndDate,r_negara.nmnegara as Negara');
        $this->db->join('r_negara', 'r_negara.ID = m_kegiatan.negara', 'left');
        $this->db->where('m_kegiatan.ID', $result_data->id_kegiatan);
        $kegiatan = $this->db->get('m_kegiatan')->row();
        $this->db->select('*');
        $this->db->where('m_user.UserID', $pejabat_persetujuan_surat);
        $penandatangan_persetujuan = $this->db->get('m_user')->row();
        $label_penandatangan = $this->get_label_penandatangan($pejabat_persetujuan_surat, $result_data->id_level_pejabat);
        $level = $this->db->get_where('m_user', array('UserID' => $id_user))->row()->level;
        $data = array(
            'title' => "Surat Persetujuan",
            'level' => $level,
            'label_penandatangan' => $label_penandatangan,
            'penandatangan' => $penandatangan_persetujuan,
            'unit_tembusan' => $unit_tembusan,
            'data_sp' => $result_data,
            'kegiatan' => $kegiatan,
            'data_sp_lama' => $pdln_lama,
            'm_pdf' => $this->load->library('M_pdf'));
        $html = $this->load->view('kotak_surat/v_print_pembatalan', $data, TRUE);
        $this->load->library('M_pdf');
        $this->m_pdf->pdf->AddPage('P', // L - landscape, P - portrait
                '', '', '', '', 15, // margin_left
                15, // margin right
                15, // margin top
                10, // margin bottom
                18, // margin header
                5); // margin footer
        $qr_link = base_url() . $this->config->item('url_esign', 'pdln') . $id_surat;
        $this->m_pdf->pdf->SetHTMLFooter('<barcode code="' . $qr_link . '" type="QR" size="0.8" height="1.5" alt="' . $qr_link . '"/>');
        $this->m_pdf->pdf->WriteHTML($html);
        $this->m_pdf->pdf->Output($fullpath, 'F');
        //send_file_to_browser($fullpath); // this function will exec die() and exit
    }

    public function send_email($data) {
	$this->config->load('email', TRUE);
        $from = isset($data['from']) ? $data['from'] : $this->config->item('email_from', 'email');
        $reply = isset($data['reply']) ? $data['reply'] : $this->config->item('email_reply', 'email');
        $to = isset($data['to']) ? $data['to'] : '';
        $subject = isset($data['subject']) ? $data['subject'] : '';
        $body = isset($data['body']) ? $data['body'] : '';
        $this->load->library('email');
        $result = $this->email
                ->from($from)
                ->reply_to($reply)    // Optional, an account where a human being reads.
                ->to($to)
                ->subject($subject)
                ->message($body)
		->send();
        return $result;
    }

    public function test_send_email($to) {
	$this->config->load('email', TRUE);
        $from = $this->config->item('email_from', 'email');
        $reply = $this->config->item('email_reply', 'email');
        $subject = 'percobaan';
        $body = 'percobaan kirim email';
        $this->load->library('email');
        $result = $this->email
                ->from($from)
                ->reply_to($reply)
                ->to(urldecode($to))
                ->subject($subject)
                ->message($body);
        if(!$this->email->send(false)){
		$s=$this->email->print_debugger();
		echo 'gagal<br>'.$s;
                return false;
	}else{
        	return true;
	}
    }

    public function download($id_pdln) {
        $data_pdln = $this->db->get_where('m_pdln', array('id_pdln' => $id_pdln))->row();
        $idSigned = $data_pdln->id_signed;
        $this->config->load('esign', TRUE);
        $this->load->library('Esign', $this->config->item('esign'));
        $clientId = $this->config->item('clientId', 'esign');
        $clientSecret = $this->config->item('clientSecret', 'esign');
        $username = $this->config->item('userIdMenteri', 'esign');
        $password = $this->config->item('passwordMenteri', 'esign');
        $authEntity = new AuthRequestEntity();
        $authEntity->client_id = $clientId;
        $authEntity->client_secret = $clientSecret;
        $authEntity->grant_type = Esign::GRANT_TYPE_PASSWORD;
        $authEntity->username = $username;
        $authEntity->password = $password;
        $authResponse = json_decode($this->esign->GetUserAccessToken($authEntity), true);
        if (array_key_exists('access_token', $authResponse)) {
            $accessToken = $authResponse['access_token'];
            $response = $this->esign->DownloadSignedDoc($idSigned, $accessToken);
            $this->output
                    ->set_status_header(200)
                    ->set_content_type("application/pdf")
                    //->set_header("Content-Disposition:attachment;filename='SP_{$idSigned}.pdf'")
                    ->set_output($response);
            return;
        }
        $this->output->set_status_header(204);
    }

    public function get_data_peserta() {
        $id_log_peserta = $this->input->post('id_log_peserta');
        $this->db->select("
                            a.id_log_peserta,
                            b.id_pemohon,
                            a.id_kategori_biaya,
                            a.id_biaya,
                            b.nik,
                            b.paspor,
                            b.nip_nrp,
                            b.nama AS nama_peserta,
                            b.jabatan,
                            CONCAT(DATE_FORMAT(FROM_UNIXTIME(a.start_date),'%d-%m-%Y'),' s.d. ',DATE_FORMAT(FROM_UNIXTIME(a.end_date),'%d-%m-%Y')) AS tgl,
                            c.Nama,
                            b.id_instansi,
                            b.instansi_lainnya
                         ")
                ->from('t_log_peserta a')
                ->join('m_pemohon b', 'b.id_pemohon = a.id_pemohon', 'left')
                ->join('r_institution c', 'b.id_instansi = c.ID', 'left')
                ->where(array('a.id_log_peserta' => $id_log_peserta));
        $result = $this->db->get()->row();
        $data['peserta'] = $result;
        if ($data['peserta']->id_kategori_biaya == "0") {
            $this->crud_ajax->init('t_ref_pembiayaan_tunggal', 'id_log_dana_tunggal', NULL);
            $this->crud_ajax->setExtraWhere(array('id_log_dana_tunggal' => $data['peserta']->id_biaya));
            $biaya = $this->crud_ajax->get_data();
            $data['biaya'] = number_format($biaya[0]->biaya, 2, '.', ',');
        } else if ($data['peserta']->id_kategori_biaya == "1") {
            $this->crud_ajax->init('t_pembiayaan_campuran', 'id_dana_campuran', NULL);
            $this->crud_ajax->setExtraWhere(array('id_dana_campuran' => $data['peserta']->id_biaya));
            $biaya = $this->crud_ajax->get_data();
            $data['biaya'] = number_format($biaya[0]->biaya_apbn, 2, '.', ',');
        }
        echo json_encode($data);
    }

}