public function nilai_investasi_terkini()
{
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_dialog_forms', true);
$this->config->set_item('grocery_crud_default_per_page', 10);
$c = new grocery_crud();
$c->set_table('nilai_investasi');
$c->where('id_perusahaan', $this->session->userdata('id_perusahaan'));
$c->where('jenis_investasi', 'terkini');
// if($this->glo_jenis_permo != ''){
// $c->unset_delete();
// $c->unset_read();
// $c->unset_edit();
$sl_permohonan = select('*', 'permohonan', array('id_permohonan' => $this->session->userdata('id_permohonan'), 'selesai' => 2));
if (!$this->session->userdata('laporan_berkala') == 'aktif') {
$c->unset_delete();
$c->unset_read();
//$c->unset_edit();
}
//$c->add_action('Pilih', 'sd', 'perusahaan/pilih/peralatan','ui-icon-plus');
// }
// unset field
$c->fields('id_perusahaan', 'nama_investor', 'negara_asal', 'mata_uang', 'nominal_investasi', 'persentase', 'jenis_investasi');
$c->columns('nama_investor', 'negara_asal', 'mata_uang', 'nominal_investasi', 'persentase');
$c->field_type('jenis_investasi', 'hidden', 'terkini');
$c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan'));
$c->required_fields('nama_investor', 'negara_asal', 'nominal_investasi', 'persentase', 'mata_uang');
$c->callback_before_upload(array($this, 'callback_before_upload_file_data'));
$c->callback_field('mata_uang', array($this, 'callback_mata_uang'));
$c->callback_column('nominal_investasi', function ($value, $row) {
return $this->formatUang($value, $row->mata_uang);
});
$c->callback_field('persentase', function ($value, $row) {
return '<input type="text" value="' . $value . '" name="persentase" style="width: 30%"><br/><span style="color:red; font-size:10px">*) Gunakan tanda titik (.) untuk menuliskan nilai desimal<br/>*) Angka maksimal adalah 100</span>';
});
$c->display_as('persentase', 'Persentase %');
$c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/nilai_investasi")));
//$c->unset_delete();
$output = $c->render();
$level = $this->session->userdata('level');
if ($level != NULL) {
if ($level == 1) {
if ($c->getState() != 'list') {
$this->nilai_investasi($output);
} else {
return $output;
}
} else {
redirect('all_users/dashboard');
}
} elseif ($level == NULL) {
redirect('umum/logout');
}
}
public function nilai_investasi()
{
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_file_upload_allow_file_types', 'pdf');
$this->config->set_item('grocery_crud_dialog_forms', true);
$this->config->set_item('grocery_crud_default_per_page', 10);
$this->load->config('grocery_crud');
$c = new grocery_crud();
$c->set_table('nilai_investasi');
$c->where('id_perusahaan', $this->session->userdata('id_perusahaan'));
// if($this->glo_jenis_permo != ''){
// $c->unset_delete();
// $c->unset_read();
// $c->unset_edit();
$sl_permohonan = select('*', 'permohonan', array('id_permohonan' => $this->session->userdata('id_permohonan'), 'selesai' => 2));
if (!$this->session->userdata('laporan_berkala') == 'aktif') {
$c->unset_delete();
$c->unset_read();
//$c->unset_edit();
}
//$c->add_action('Pilih', 'sd', 'perusahaan/pilih/peralatan','ui-icon-plus');
// }
// unset field
$c->unset_fields('catatan_petugas', 'status_kepemilikan', 'file_nilai_investasi', 'status_pemakaian');
// unset columtn
$c->unset_columns('id_perusahaan', 'catatan_petugas', 'status_pemakaian', 'file_nilai_investasi');
$c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan'));
$c->required_fields('nama_investor', 'negara_asal', 'nominal_investasi', 'persentase', 'mata_uang');
//$c->set_field_upload('file_nilai_investasi', 'assets/uploads/file_nilai_investasi');
$c->callback_before_upload(array($this, 'callback_before_upload_file_data'));
$c->callback_field('mata_uang', array($this, 'callback_mata_uang'));
$c->callback_column('nominal_investasi', function ($value, $row) {
if ($row->mata_uang == 'Rupiah') {
return 'Rp. ' . number_format($value, 2, ',', '.');
} else {
return 'USD $' . number_format($value, 2, ',', '.');
}
});
$c->callback_field('persentase', function ($value, $row) {
return '<input type="text" value="' . $value . '" name="persentase" style="width: 30%"><br/><span style="color:red; font-size:10px">*) Gunakan tanda titik (.) untuk menuliskan nilai desimal<br/>*) Angka maksimal adalah 100</span>';
});
$c->display_as('persentase', 'Persentase %');
//$c->unset_delete();
$output = $c->render();
$level = $this->session->userdata('level');
if ($level != NULL) {
if ($level == 1) {
$this->load->view('level1/skt_tabel', $output);
} else {
redirect('all_users/dashboard');
}
} elseif ($level == NULL) {
redirect('umum/logout');
}
}
