public function registrasi()
{
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_file_upload_allow_file_types', 'pdf');
$this->config->set_item('grocery_crud_file_upload_max_file_size', '200KB');
$c = new grocery_crud();
$c->set_table('registrasi');
// $c->unset_back_to_list();
$c->unset_edit();
//$c->unset_delete();
$c->unset_read();
$c->unset_list();
if ($this->uri->segment(2) == 'registrasi' && $this->uri->segment(3) == NULL) {
redirect($this->router->fetch_class() . '/' . $this->router->fetch_method() . '/add');
}
$c->set_rules('email', 'Email', 'required|valid_email');
// unset field
// $c->unset_fields('tanggal_member', 'pengajuan', '');
$c->unset_fields('tanggal_member', 'pengajuan', 'file_surat_pernyataan');
$c->field_type('deskripsi_perusahaan', 'text');
$c->field_type('alamat', 'text');
$c->callback_add_field('syarat_ketentuan', function () {
return '<input type="radio" maxlength="50" value="1" name="syarat_ketentuan"> Dengan mencetang tanda ini berarti Anda telah menyetujui syarat & ketentuan yang berlaku';
});
$c->display_as('surat_ket_domisili', 'Nomor Surat Keterangan Domisili');
$c->display_as('siup', 'Nomor SIUP/Perizinan Lainnya');
$c->display_as('npwp', 'Nomor NPWP');
$c->display_as('file_siup', 'SIUP/Perizinan Lainnya');
$c->display_as('file_surat_ket_domisili', 'Surat Keterangan Domisili');
$c->unset_texteditor('deskripsi_perusahaan', 'full_text');
$c->unset_texteditor('alamat', 'full_text');
$this->load->config('grocery_crud');
$this->config->set_item('grocery_crud_file_upload_allow_file_types', 'pdf');
$c->set_field_upload('file_surat_ket_domisili', 'assets/uploads/file_register');
$c->set_field_upload('file_siup', 'assets/uploads/file_register');
$c->required_fields('syarat_ketentuan', 'nama_perusahaan', 'direktur_utama', 'contact_person', 'email', 'alamat', 'provinsi', 'kota', 'npwp', 'akte_perusahaan', 'siup', 'file_akte', 'file_siup');
$c->set_relation('kota', 'ref_kota', 'kota');
$c->set_relation('provinsi', 'ref_provinsi', 'provinsi');
$c->callback_field('email', function ($value, $row) {
return '<input type="text" value="' . $value . '" name="email" id="field-email"> <span style="color:red; font-size:10px">*) Pastikan alamat email yang Anda masukkan valid</span>';
});
//$c->callback_insert(array($this, 'after_registrasi'));
if ($this->uri->segment(3) == 'success') {
redirect('umum/after_registrasi');
}
$output = $c->render();
$state = $c->getState();
$state_info = $c->getStateInfo();
$this->logs();
$this->load->view('umum/registrasi', $output);
}
public function tenaga_kerja()
{
$c = new grocery_crud();
$c->set_table('tenaga_kerja');
// 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 (!$sl_permohonan) {
$c->unset_delete();
$c->unset_edit();
}
$c->columns('nama_lengkap', 'status', 'jabatan', 'jenjang_pendidikan', 'jurusan_pendidikan', 'file_ijazah', 'status_pemakaian');
$c->callback_column('status_pemakaian', function ($value, $row) {
$ada = NULL;
$cek_if_has_data_permohonan = select('status_pemakaian', 'tenaga_kerja', array('id_perusahaan' => $this->session->userdata('id_perusahaan'), 'id_tenaga_kerja' => $row->id_tenaga_kerja));
$temp = explode(',', $cek_if_has_data_permohonan->status_pemakaian);
if ($cek_if_has_data_permohonan != NULL) {
foreach ($temp as $key => $status_pemakaian) {
if ($status_pemakaian == $this->session->userdata('id_permohonan')) {
$ada = 'ada';
}
}
}
if ($ada != NULL) {
return 'Dipilih';
} else {
return '';
}
});
$c->add_action('Pilih', base_url('assets/grocery_crud/themes/flexigrid/css/images/success.png'), 'perusahaan/pilih/data_tenaga_kerja/tenaga_kerja', 'ui-icon-plus', function ($primary_key, $row) {
$ada = NULL;
$cek_if_has_data_permohonan = select('status_pemakaian', 'tenaga_kerja', array('id_perusahaan' => $this->session->userdata('id_perusahaan'), 'id_tenaga_kerja' => $primary_key));
$temp = explode(',', $cek_if_has_data_permohonan->status_pemakaian);
if ($cek_if_has_data_permohonan != NULL) {
foreach ($temp as $key => $status_pemakaian) {
if ($status_pemakaian == $this->session->userdata('id_permohonan')) {
$ada = 'ada';
}
}
}
if ($ada != NULL) {
return base_url('perusahaan/ganti') . '/data_tenaga_kerja/tenaga_kerja/' . $primary_key;
} else {
return base_url('perusahaan/pilih') . '/data_tenaga_kerja/tenaga_kerja/' . $primary_key;
}
});
// }
$c->where('tenaga_kerja.id_perusahaan', $this->session->userdata('id_perusahaan'));
$this->load->config('grocery_crud');
$this->config->set_item('grocery_crud_file_upload_allow_file_types', 'pdf');
//$c->unset_delete();
$c->required_fields('nama_lengkap', 'status', 'jabatan', 'jenjang_pendidikan', 'jurusan_pendidikan', 'file_ijazah');
$c->fields('nama_lengkap', 'id_perusahaan', 'status', 'jabatan', 'jenjang_pendidikan', 'jurusan_pendidikan', 'file_ijazah', 'no_imta', 'file_imta', 'sertifikasi');
$c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/data_tenaga_kerja")));
//field type
$c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan'));
$c->field_type('status', 'enum', array('Permanen', 'Non Permanen'));
$c->set_field_upload('file_ijazah', 'assets/uploads/file_ijazah_tenaga_ahli');
$c->set_field_upload('file_imta', 'assets/uploads/file_imta');
$c->field_type('id_permohonan', 'hidden', $this->session->userdata('id_permohonan'));
// unset field
$c->unset_fields('id_sub_bidang', 'catatan_petugas', 'status_pemakaian');
// unset columns
//$c->unset_columns('id_perusahaan', 'catatan_petugas', 'id_permohonan', 'status_pemakaian', 'sertifikasi');
// set relation
$c->set_relation('jenjang_pendidikan', 'ref_jenjang_pendidikan', 'jenjang_pendidikan', null, 'id_jenjang_pendidikan');
$c->callback_field('sertifikasi', array($this, 'callback_sertifikasi'));
// display as
$c->display_as('jenjang_pendidikan', 'Pendidikan Terakhir');
$c->display_as('jurusan_pendidikan', 'Jurusan');
$c->display_as('jabatan', 'Jabatan/Keahlian');
$c->display_as('status', 'Status Kepegawaian');
$c->display_as('status_pemakaian', 'Status');
$c->display_as('no_imta', 'No IMTA *)');
$c->callback_field('no_imta', array($this, 'callback_no_imta'));
$c->display_as('file_imta', 'File IMTA');
$c->callback_after_insert(array($this, 'callback_before_insert_or_update'));
if ($c->getState() == 'read') {
$c->fields('sertifikasi');
$c->callback_field('sertifikasi', array($this, 'callback_read_sertifikasi'));
}
$output = $c->render();
$this->logs();
if ($c->getState() != 'list') {
$this->data_tenaga_kerja($output);
} else {
return $output;
}
}
public function csr()
{
$this->config->load('grocery_crud');
$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('csr');
$sl_permohonan = select('*', 'permohonan', array('id_permohonan' => $this->session->userdata('id_permohonan'), 'selesai' => 2));
$c->columns('kegiatan', 'waktu', 'lokasi', 'action');
if (!$this->session->userdata('laporan_berkala') == 'aktif') {
$c->unset_delete();
// $c->unset_edit();
$c->unset_read();
}
$c->callback_column('action', function ($value, $row) {
$ada = NULL;
$cek_if_has_data_permohonan = select('status_pemakaian', 'csr', array('id_perusahaan' => $this->session->userdata('id_perusahaan'), 'id_csr' => $row->id_csr));
$temp = explode(',', $cek_if_has_data_permohonan->status_pemakaian);
if ($cek_if_has_data_permohonan != NULL) {
foreach ($temp as $key => $status_pemakaian) {
if ($status_pemakaian == $this->session->userdata('id_permohonan')) {
$ada = 'ada';
}
}
}
if ($ada != NULL) {
return '<a class="link-pilih" href="' . base_url() . 'perusahaan/ganti/csr/csr/' . $row->id_csr . '" title="Klik untuk merubah"><img class="btn-pilih">Dipilih</a>';
} else {
return '<a class="link-pilih" href="' . base_url() . 'perusahaan/pilih/csr/csr/' . $row->id_csr . '" title="Klik untuk merubah"><img class="btn-ganti">Tidak Dipilih</a>';
}
});
$c->where('id_perusahaan', $this->session->userdata('id_perusahaan'));
$c->required_fields('kegiatan', 'waktu', 'lokasi');
$c->fields('id_perusahaan', 'kegiatan', 'waktu', 'lokasi', 'skrip_waktu');
// $c->set_relation('lokasi', 'ref_kota', 'kota', null, 'id_kota');
$c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan'));
$c->set_field_upload('file_csr', 'assets/uploads/file_csr');
//$c->unset_fields('catatan_petugas', 'status_pemakaian');
$c->callback_field('lokasi', array($this, 'callback_daftar_lokasi'));
$c->field_type('skrip', 'hidden');
$c->callback_field('skrip_waktu', function ($value, $row) {
$output = '<script>
$("#skrip_waktu_display_as_box").remove();
$(".ui-dialog-content").dialog( "option", "height", 350 );
$("#skrip_waktu_field_box").remove();$( "#field-waktu" ).datepicker({
yearRange: "' . (date('Y') - 110) . ':' . date('Y') . '",
changeMonth: true,
changeYear: true
});</script>';
return $output;
});
//$c->unset_columns('id_perusahaan', 'catatan_petugas', 'status_pemakaian');
$c->display_as('file_csr', 'File CSR');
//$c->unset_delete();
$output = $c->render();
$this->logs();
$level = $this->session->userdata('level');
if ($level != NULL) {
if ($level == 1) {
if ($c->getState() == 'add') {
redirect('perusahaan/csr');
} else {
$this->load->view('level1/skt_tabel', $output);
}
} else {
redirect('all_users/dashboard');
}
} elseif ($level == NULL) {
redirect('umum/logout');
}
}
public function lihat_catatan_evaluator()
{
$this->config->load('grocery_crud');
$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('pelaporan_periodik');
$c->columns('catatan_evaluator', 'id_evaluator');
$c->set_relation('id_evaluator', 'users', 'nama_lengkap');
$c->fields('id_evaluator', 'catatan_evaluator');
$c->display_as('id_evaluator', 'Nama Evaluator');
//$c->field_type('id_evaluator', 'hidden');
$c->callback_field('catatan_evaluator', function ($value, $row) {
$isi = '<script>
$("#catatan_evaluator_display_as_box").remove();
$("div.crud-form div.mDiv div.ftitle").remove();
$("#cancel-button").remove();
$(".pDiv").css("border", "none");
$(".form-div").css("border", "none");
$("#id_evaluator_display_as_box").css({"width":"auto","margin-right":"7px"});
$(".ui-dialog-content").dialog( "option", "height", 430 );
$(".ui-dialog-content").dialog( "option", "width", 650 );';
if ($value != NULL) {
$isi .= 'CKEDITOR.replace( "content_template",
{
removePlugins: "toolbar",
height : 200,
width : 550,
tabSpaces : 4,
readOnly : true
});</script><hr style="margin-top:0px!important"/>
<textarea id="content_template" class="ckeditor">' . $value . '</textarea>';
} else {
$isi .= '</script><hr style="margin-top:0px!important"/><span><b>Tidak ada catatan</b></span>';
}
return $isi;
});
$c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/laporan_berkala_evaluator")));
$output = $c->render();
if ($c->getState() != 'read') {
redirect('all_admin/laporan_berkala_kasie');
} else {
$this->laporan_berkala_kasie($output);
}
}
public function tenaga_kerja()
{
$c = new grocery_crud();
$c->set_table('tenaga_kerja');
$c->where('tenaga_kerja.id_perusahaan', $this->session->userdata('id_perusahaan'));
$this->load->config('grocery_crud');
$this->config->set_item('grocery_crud_file_upload_allow_file_types', 'pdf');
//$c->unset_delete();
//$c->required_fields('nama_lengkap', 'status', 'jabatan', 'jenjang_pendidikan', 'jurusan_pendidikan', 'file_ijazah');
$c->fields('nama_lengkap', 'id_perusahaan', 'status', 'jabatan', 'jenjang_pendidikan', 'jurusan_pendidikan', 'file_ijazah', 'sertifikasi');
$c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/data_tenaga_kerja")));
//field type
$c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan'));
$c->field_type('status', 'enum', array('Permanen', 'Non Permanen'));
$c->set_field_upload('file_ijazah', 'assets/uploads/file_ijazah_tenaga_ahli');
$c->field_type('id_permohonan', 'hidden', $this->session->userdata('id_permohonan'));
// unset field
$c->unset_fields('id_sub_bidang', 'catatan_petugas', 'status_pemakaian');
// unset columns
$c->unset_columns('id_perusahaan', 'catatan_petugas', 'id_permohonan', 'status_pemakaian', 'sertifikasi');
// set relation
$c->set_relation('jenjang_pendidikan', 'ref_jenjang_pendidikan', 'jenjang_pendidikan', null, 'id_jenjang_pendidikan');
$c->callback_field('sertifikasi', array($this, 'callback_sertifikasi'));
// display as
$c->display_as('jenjang_pendidikan', 'Pendidikan Terakhir');
$c->display_as('jurusan_pendidikan', 'Jurusan');
$c->display_as('jabatan', 'Keahlian');
$c->display_as('status', 'Status Kepegawaian');
$c->callback_after_insert(array($this, 'callback_before_insert_or_update'));
$output = $c->render();
$this->logs();
if ($c->getState() != 'list') {
$this->data_tenaga_kerja($output);
} else {
return $output;
}
}
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');
}
}
