public function index()
{
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// initialize groceryCRUD
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud = $this->new_crud();
// this is just for code completion
if (FALSE) {
$crud = new Extended_Grocery_CRUD();
}
// check state & get primary_key
$state = $crud->getState();
$state = $crud->getState();
$state_info = $crud->getStateInfo();
$primary_key = isset($state_info->primary_key) ? $state_info->primary_key : NULL;
switch ($state) {
case 'unknown':
break;
case 'list':
break;
case 'add':
break;
case 'edit':
break;
case 'delete':
break;
case 'insert':
break;
case 'update':
break;
case 'ajax_list':
break;
case 'ajax_list_info':
break;
case 'insert_validation':
break;
case 'update_validation':
break;
case 'upload_file':
break;
case 'delete_file':
break;
case 'ajax_relation':
break;
case 'ajax_relation_n_n':
break;
case 'success':
break;
case 'export':
break;
case 'print':
break;
}
// unset things
$crud->unset_jquery();
$crud->unset_read();
$crud->unset_texteditor('alasan_cuti');
// $crud->unset_add();
// $crud->unset_edit();
// $crud->unset_list();
// $crud->unset_back_to_list();
// $crud->unset_print();
// $crud->unset_export();
$username = $this->cms_user_name();
$group = $this->db->select('group_name')->join('main_group_user', 'main_group.group_id = main_group_user.group_id')->where('user_id', $this->cms_user_id())->get('main_group')->result();
foreach ($group as $q) {
$gn = $q->group_name;
}
if (isset($gn) && $gn == 'Mahasiswa') {
$crud->where('npm', $username);
}
// set model
// $crud->set_model($this->cms_module_path().'/grocerycrud_permohonan_cuti_model');
// adjust groceryCRUD's language to No-CMS's language
$crud->set_language($this->cms_language());
// table name
$crud->set_table($this->cms_complete_table_name('permohonan_cuti'));
// set subject
$crud->set_subject('Permohonan Cuti');
// displayed columns on list
$crud->columns('nama_mahasiswa', 'npm', 'jurusan');
// displayed columns on edit operation
$crud->edit_fields('nama_mahasiswa', 'npm', 'jurusan', 'alamat', 'no_telp', 'alasan_cuti', 'tahun_ajaran', 'dosen_pa');
// displayed columns on add operation
$crud->add_fields('nama_mahasiswa', 'npm', 'jurusan', 'alamat', 'no_telp', 'alasan_cuti', 'tahun_ajaran', 'dosen_pa');
// caption of each columns
$crud->display_as('nama_mahasiswa', 'Nama Mahasiswa');
$crud->display_as('npm', 'NPM');
$crud->display_as('jurusan', 'Jurusan');
$crud->display_as('alamat', 'Alamat');
$crud->display_as('no_telp', 'No. Telp/Hp');
$crud->display_as('alasan_cuti', 'Alasan Cuti');
$crud->display_as('tahun_ajaran', 'Tahun Ajaran');
$crud->display_as('dosen_pa', 'Dosen PA');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put required field validation codes here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/required_fields)
// eg:
// $crud->required_fields( $field1, $field2, $field3, ... );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put required field validation codes here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/unique_fields)
// eg:
// $crud->unique_fields( $field1, $field2, $field3, ... );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put field validation codes here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/set_rules)
// eg:
// $crud->set_rules( $field_name , $caption, $filter );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud->set_rules('npm', 'NPM', 'numeric');
$crud->set_rules('no_telp', 'No. Telp/Hp', 'numeric');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put set relation (lookup) codes here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/set_relation)
// eg:
// $crud->set_relation( $field_name , $related_table, $related_title_field , $where , $order_by );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud->set_relation('jurusan', $this->cms_complete_table_name('mas_jurusan'), 'nama_jurusan');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put set relation_n_n (detail many to many) codes here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/set_relation_n_n)
// eg:
// $crud->set_relation_n_n( $field_name, $relation_table, $selection_table, $primary_key_alias_to_this_table,
// $primary_key_alias_to_selection_table , $title_field_selection_table, $priority_field_relation );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put custom field type here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/field_type)
// eg:
// $crud->field_type( $field_name , $field_type, $value );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put callback here
// (documentation: httm://www.grocerycrud.com/documentation/options_functions)
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud->callback_before_insert(array($this, 'before_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->callback_before_delete(array($this, 'before_delete'));
$crud->callback_after_insert(array($this, 'after_insert'));
$crud->callback_after_update(array($this, 'after_update'));
$crud->callback_after_delete(array($this, 'after_delete'));
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put custom error message here
// (documentation: httm://www.grocerycrud.com/documentation/set_lang_string)
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// $crud->set_lang_string('delete_error_message', 'Cannot delete the record');
// $crud->set_lang_string('update_error', 'Cannot edit the record' );
// $crud->set_lang_string('insert_error', 'Cannot add the record' );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// render
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$output = $crud->render();
$this->view($this->cms_module_path() . '/manage_permohonan_cuti_view', $output, $this->cms_complete_navigation_name('manage_permohonan_cuti'));
}
public function index()
{
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// initialize groceryCRUD
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud = $this->new_crud();
// this is just for code completion
if (FALSE) {
$crud = new Extended_Grocery_CRUD();
}
// check state & get primary_key
$state = $crud->getState();
$state = $crud->getState();
$state_info = $crud->getStateInfo();
$primary_key = isset($state_info->primary_key) ? $state_info->primary_key : NULL;
switch ($state) {
case 'unknown':
break;
case 'list':
break;
case 'add':
break;
case 'edit':
break;
case 'delete':
break;
case 'insert':
break;
case 'update':
break;
case 'ajax_list':
break;
case 'ajax_list_info':
break;
case 'insert_validation':
break;
case 'update_validation':
break;
case 'upload_file':
break;
case 'delete_file':
break;
case 'ajax_relation':
break;
case 'ajax_relation_n_n':
break;
case 'success':
break;
case 'export':
break;
case 'print':
break;
}
// unset things
$crud->unset_jquery();
$crud->unset_read();
// $crud->unset_add();
// $crud->unset_edit();
// $crud->unset_list();
// $crud->unset_back_to_list();
// $crud->unset_print();
// $crud->unset_export();
// set model
// $crud->set_model($this->cms_module_path().'/grocerycrud_main_language_model');
// adjust groceryCRUD's language to No-CMS's language
$crud->set_language($this->cms_language());
// table name
$crud->set_table(cms_table_name('main_language'));
// set subject
$crud->set_subject('Language');
// displayed columns on list
$crud->columns('name', 'code', 'iso_code', 'translations');
// displayed columns on edit operation
$crud->edit_fields('name', 'code', 'iso_code', 'translations');
// displayed columns on add operation
$crud->add_fields('name', 'code', 'iso_code', 'translations');
// caption of each columns
$crud->display_as('name', 'Name');
$crud->display_as('iso_code', 'ISO Code');
$crud->display_as('translations', 'Translations');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put required field validation codes here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/required_fields)
// eg:
// $crud->required_fields( $field1, $field2, $field3, ... );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud->required_fields('name', 'code');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put required field validation codes here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/unique_fields)
// eg:
// $crud->unique_fields( $field1, $field2, $field3, ... );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud->unique_fields('name', 'code', 'iso_code');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put field validation codes here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/set_rules)
// eg:
// $crud->set_rules( $field_name , $caption, $filter );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put set relation (lookup) codes here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/set_relation)
// eg:
// $crud->set_relation( $field_name , $related_table, $related_title_field , $where , $order_by );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put set relation_n_n (detail many to many) codes here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/set_relation_n_n)
// eg:
// $crud->set_relation_n_n( $field_name, $relation_table, $selection_table, $primary_key_alias_to_this_table,
// $primary_key_alias_to_selection_table , $title_field_selection_table, $priority_field_relation );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put custom field type here
// (documentation: http://www.grocerycrud.com/documentation/options_functions/field_type)
// eg:
// $crud->field_type( $field_name , $field_type, $value );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud->unset_texteditor('code');
$crud->unset_texteditor('iso_code');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put callback here
// (documentation: httm://www.grocerycrud.com/documentation/options_functions)
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud->callback_before_insert(array($this, '_before_insert'));
$crud->callback_before_update(array($this, '_before_update'));
$crud->callback_before_delete(array($this, '_before_delete'));
$crud->callback_after_insert(array($this, '_after_insert'));
$crud->callback_after_update(array($this, '_after_update'));
$crud->callback_after_delete(array($this, '_after_delete'));
$crud->callback_column('translations', array($this, '_callback_column_translations'));
$crud->callback_field('translations', array($this, '_callback_field_translations'));
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put custom error message here
// (documentation: httm://www.grocerycrud.com/documentation/set_lang_string)
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// $crud->set_lang_string('delete_error_message', 'Cannot delete the record');
// $crud->set_lang_string('update_error', 'Cannot edit the record' );
// $crud->set_lang_string('insert_error', 'Cannot add the record' );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// render
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$output = $crud->render();
// prepare css & js, add them to config
$config = array();
$asset = new Cms_asset();
foreach ($output->css_files as $file) {
$asset->add_css($file);
}
$config['css'] = $asset->compile_css();
foreach ($output->js_files as $file) {
$asset->add_js($file);
}
$config['js'] = $asset->compile_js();
// show the view
$this->view($this->cms_module_path() . '/language/manage_main_language_view', $output, $this->n('main_language_management'), $config);
}
public function index()
{
$this->load->helper('date');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// initialize groceryCRUD
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud = $this->new_crud();
//$crud->set_theme('datatables');
// this is just for code completion
if (FALSE) {
$crud = new Extended_Grocery_CRUD();
}
// check state & get primary_key
$state = $crud->getState();
$state = $crud->getState();
$state_info = $crud->getStateInfo();
$primary_key = isset($state_info->primary_key) ? $state_info->primary_key : NULL;
switch ($state) {
case 'unknown':
break;
case 'list':
break;
case 'add':
break;
case 'edit':
break;
case 'delete':
break;
case 'insert':
break;
case 'update':
break;
case 'ajax_list':
break;
case 'ajax_list_info':
break;
case 'insert_validation':
break;
case 'update_validation':
break;
case 'upload_file':
break;
case 'delete_file':
break;
case 'ajax_relation':
break;
case 'ajax_relation_n_n':
break;
case 'success':
break;
case 'export':
break;
case 'print':
break;
}
// unset things
$crud->unset_jquery();
$crud->unset_read();
$crud->unset_print();
$crud->unset_export();
$crud->unset_texteditor('tujuan');
$username = $this->cms_user_name();
$group = $this->db->select('group_name')->join('main_group_user', 'main_group.group_id = main_group_user.group_id')->where('user_id', $this->cms_user_id())->get('main_group')->result();
foreach ($group as $q) {
$gn = $q->group_name;
}
if (isset($gn) && $gn == 'Mahasiswa') {
$crud->where('npm', $username);
}
$crud->set_language($this->cms_language());
// table name
$crud->set_table($this->cms_complete_table_name('surat_tugas'));
// set subject
$crud->set_subject('Surat Tugas');
// displayed columns on list
$crud->columns('nomor_surat', 'nama_pegawai', 'nik');
$crud->order_by('id_surat_tugas', 'DESC');
// displayed columns on edit operation
$crud->edit_fields('nomor_surat', 'nama_pegawai', 'nik', 'pangkat_golongan', 'jabatan', 'tujuan', 'bulan', 'tahun');
// displayed columns on add operation
$crud->add_fields('nomor_surat', 'nama_pegawai', 'nik', 'pangkat_golongan', 'jabatan', 'tujuan', 'bulan', 'tahun');
//Add Action
//$crud->add_action('Download', '', base_url().'sim_penyuratan/manage_surat_tugas/generate/','ui-icon-arrowthickstop-1-s','');
$crud->add_action('Download', base_url() . '/assets/icon/word.png', base_url() . 'sim_penyuratan/manage_surat_tugas/generate/');
// caption of each columns
$crud->display_as('nomor_surat', 'Nomor Surat');
$crud->display_as('nama_pegawai', 'Nama Pegawai');
$crud->display_as('nik', 'NIDN / NIK');
$crud->display_as('pangkat_golongan', 'Pangkat / Golongan');
$crud->display_as('jabatan', 'Jabatan');
$crud->display_as('tujuan', 'Tujuan');
$crud->required_fields('nama_pegawai', 'nik', 'pangkat_golongan', 'jabatan', 'tujuan');
$crud->field_type('bulan', 'hidden', date('m'));
$crud->field_type('tahun', 'hidden', date('Y'));
$crud->field_type('nomor_surat', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert_update'));
$crud->callback_before_update(array($this, 'before_insert_update'));
$crud->callback_before_delete(array($this, 'before_delete'));
$crud->callback_after_insert(array($this, 'after_insert_update'));
$crud->callback_after_update(array($this, 'after_insert_update'));
$crud->callback_after_delete(array($this, 'after_delete'));
$output = $crud->render();
$this->view($this->cms_module_path() . '/manage_aktif_kuliah_view', $output, $this->cms_complete_navigation_name('manage_surat_tugas'));
}
