| 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 : |
<?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));
}
}