public function index()
{
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// 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_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_peng_data_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_peng_data'));
// set subject
$crud->set_subject('Surat Permohonan Pengambilan Data');
// displayed columns on list
$crud->columns('nomor_surat', 'nama_mahasiswa', 'npm', 'fk_id_jurusan');
$crud->order_by('id_permohonan_peng_data', 'DESC');
// displayed columns on edit operation
$crud->edit_fields('nomor_surat', 'lampiran', 'kepada', 'di', 'nama_mahasiswa', 'npm', 'fk_id_jurusan', 'bulan', 'tahun');
// displayed columns on add operation
$crud->add_fields('nomor_surat', 'lampiran', 'kepada', 'di', 'nama_mahasiswa', 'npm', 'fk_id_jurusan', 'bulan', 'tahun');
//Add Action
$crud->add_action('Download', base_url() . '/assets/icon/word.png', base_url() . 'sim_penyuratan/Manage_Permohonan_Peng_Data/generate/');
// caption of each columns
$crud->display_as('nomor_surat', 'Nomor Surat');
$crud->display_as('lampiran', 'Lampiran');
$crud->display_as('kepada', 'Kepada');
$crud->display_as('di', 'Di');
$crud->display_as('nama_mahasiswa', 'Nama Mahasiswa');
$crud->display_as('npm', 'NPM');
$crud->display_as('fk_id_jurusan', 'Jurusan');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// 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('kepada', 'di', 'nama_mahasiswa', 'npm', 'fk_id_jurusan');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// 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 );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// 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('fk_id_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 );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$crud->field_type('bulan', 'hidden', date('m'));
$crud->field_type('tahun', 'hidden', date('Y'));
$crud->field_type('nomor_surat', 'invisible');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// HINT: Put callback here
// (documentation: httm://www.grocerycrud.com/documentation/options_functions)
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$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'));
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// 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_peng_data_view', $output, $this->cms_complete_navigation_name('manage_permohonan_peng_data'));
}
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_message_model');
// adjust groceryCRUD's language to No-CMS's language
$crud->set_language($this->cms_language());
// table name
$crud->set_table($this->t('message'));
// set subject
$crud->set_subject('Message');
// displayed columns on list
$crud->columns('name', 'email', 'content');
// displayed columns on edit operation
$crud->edit_fields('name', 'email', 'content');
// displayed columns on add operation
$crud->add_fields('name', 'email', 'content');
// caption of each columns
$crud->display_as('name', 'Name');
$crud->display_as('content', 'Content');
$crud->display_as('email', 'Email');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// 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', 'content', 'email');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// 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('email', 'Email', 'valid_email');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// 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 );
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// 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_message_view', $output, $this->n('manage_message'));
}
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'));
}
