private function get_crud()
{
$this->data['message'] = $this->session->flashdata('message');
$crud = new grocery_CRUD();
$crud->set_theme(GROCERY_CRUD_THEME);
$crud->set_table('usuario');
$crud->set_subject('Usuário');
$crud->unset_columns('id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3', 'ultima_troca', 'cadastro');
$crud->fields('id', 'nome', 'login', 'email', 'grupos', 'tipo_usuario_id', 'situacao_usuario_id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3');
$crud->unset_texteditor('id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3', 'ultima_troca', 'cadastro');
$crud->change_field_type('id', 'invisible');
$crud->change_field_type('senha', 'invisible');
$crud->change_field_type('senha_anterior1', 'invisible');
$crud->change_field_type('senha_anterior2', 'invisible');
$crud->change_field_type('senha_anterior3', 'invisible');
$crud->set_relation('situacao_usuario_id', 'situacao_usuario', 'descricao');
$crud->display_as('situacao_usuario_id', 'Situacao');
$crud->set_relation('tipo_usuario_id', 'tipo_usuario', 'descricao');
$crud->display_as('tipo_usuario_id', 'Tipo de Usuário');
$crud->set_relation_n_n('grupos', 'grupo_usuario_x_usuario', 'grupo_usuario', 'usuario_id', 'grupo_usuario_id', 'descricao');
/* regras e campos obrigatórios */
$crud->required_fields('login', 'grupos', 'tipo_usuario_id', 'situacao_usuario_id');
$crud->set_rules('login', 'Login', 'required|min_length[2]');
$crud->set_rules('grupos', 'Grupos', 'required');
$crud->set_rules('tipo_usuario_id', 'Tipo de Usuário', 'required');
$crud->set_rules('situacao_usuario_id', 'Situação do Usuário', 'required');
$crud->callback_before_insert(array($this, 'checking_new_user'));
return $crud->render();
}
public function index($categoryid = 0)
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$data['cat_id'] = $categoryid;
// $form_subject = ($categoryid==0 ? "Category" : "Sub Category");
if ($categoryid == 0) {
$form_subject = "Category";
$data['cat_title'] = "Categories";
} else {
$this->category->getTitle($categoryid);
$data['cat_title'] = $this->category->getTitle($categoryid) . " - Sub Categories";
$form_subject = "Sub Category";
}
$crud = new grocery_CRUD();
$crud->set_table('dbx_categories');
$crud->where('pid', $categoryid);
$crud->set_subject($form_subject);
$crud->required_fields('title');
$crud->columns('title');
$crud->callback_column('title', array($this, 'link_title'));
$crud->set_rules('title', 'Title', 'trim|required|xss_clean|is_unique[dbx_categories.title]');
$crud->add_action('Sub Categories', '', '', 'cat-icon', array($this, 'goto_sub'));
$crud->fields('title', 'desc', 'published', 'type', 'pid', 'ownerid', 'created_date');
$crud->field_type('pid', 'hidden', $categoryid);
$crud->field_type('published', 'dropdown', array('0' => 'No', '1' => 'Yes'));
$crud->field_type('type', 'dropdown', array('C' => 'Celebrity', 'M' => 'Movie', 'P' => 'Parent'));
$crud->change_field_type('ownerid', 'invisible');
$crud->change_field_type('created_date', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert'));
$output = $crud->render($data);
$this->load->view('header_view', $data);
$this->load->view('categories_view', $output);
$this->load->view('footer_view', $data);
}
/**
* function ni digunakan untuk kv urus maklumat pengguna pada crud
* input: -
* author: Mior Mohd Hanif
* Date: 28 Jun 2013
* Modification Log:
*/
function user_management()
{
$user_login = $this->ion_auth->user()->row();
$col_id = $user_login->col_id;
$crud = new grocery_CRUD();
$crud->where('user.col_id', $col_id);
$crud->set_theme('flexigrid');
$crud->set_subject('Pengguna');
$crud->set_table('user');
$crud->display_as('user_name', 'Nama Pengguna')->display_as('user_username', 'Katanama')->display_as('user_password', 'Katalaluan')->display_as('user_email', 'Email')->display_as('col_id', 'Kolej')->display_as('created_on', 'Tarikh Daftar')->display_as('last_login', 'Tarikh Log Masuk')->display_as('active', 'Status')->display_as('phone', 'No. Telefon');
$crud->set_relation('col_id', 'college', 'col_name');
$crud->required_fields('user_name', 'user_username', 'user_password', 'user_email', 'active', 'phone');
$crud->set_rules('user_username', 'Katanama', 'trim|required');
$crud->set_rules('phone', 'No. Telefon', 'trim|required|numeric');
$crud->set_rules('user_email', 'Email', 'trim|required|valid_email');
$crud->unset_columns('ip_address', 'user_password', 'salt', 'activation_code', 'forgotten_password_code', 'forgotten_password_time', 'remember_code');
$crud->unset_fields('ip_address', 'activation_code', 'forgotten_password_code', 'forgotten_password_time', 'remember_code', 'last_login');
$crud->change_field_type('user_password', 'password');
$crud->change_field_type('created_on', 'invisible');
$crud->change_field_type('salt', 'invisible');
$crud->change_field_type('col_id', 'invisible');
$crud->callback_before_insert(array($this, 'callback_for_time_and_encrypt_password'));
$crud->callback_column('created_on', array($this, 'strtotime_convert_to_date'));
$crud->callback_column('last_login', array($this, 'strtotime_convert_to_date'));
$output = $crud->render();
$header = "<legend><h4>Penyelenggaraan Pengguna</h4></legend>";
$this->_main_output($output, $header);
}
public function index($categoryid = 0)
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$data['lo'] = 2;
//value used to identify section movie or celebrity
$data['categoryid'] = $categoryid;
//value used to identify section movie or celebrity
if ($categoryid != 0) {
$data['cat_id'] = $categoryid;
$cat_title = $this->category->getTitle($categoryid);
$data['cat_title'] = $cat_title . " - Movies";
$form_subject = $cat_title;
$crud = new grocery_CRUD();
$crud->set_table('dbx_movies');
$crud->where('catid', $categoryid);
$crud->set_subject('Movie');
$crud->required_fields('title', 'year');
$crud->columns('title');
// $crud->callback_column('name',array($this,'link_title'));
// $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]');
$crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl'));
$crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl'));
$crud->fields('catid', 'title', 'year', 'release_date', 'cast', 'director', 'producer', 'music', 'writer', 'lyrics', 'synopsis', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date');
// $crud->field_type('catid', 'hidden', $categoryid);
$crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'M'), null, $categoryid);
$crud->display_as('catid', 'Category');
//
$crud->callback_add_field('cast', array($this, 'add_field_cast'));
$crud->callback_add_field('synopsis', array($this, 'add_field_synopsis'));
$crud->callback_edit_field('cast', array($this, 'edit_field_cast'));
$crud->callback_edit_field('synopsis', array($this, 'edit_field_synopsis'));
$crud->change_field_type('ownerid', 'invisible');
$crud->change_field_type('created_date', 'invisible');
$crud->change_field_type('seo_url', 'invisible');
$crud->change_field_type('lastupdate_date', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->callback_after_insert(array($this, 'after_insert'));
$crud->unset_jquery();
$state = $crud->getState();
// echo($state);
$data['state'] = $state;
$output = $crud->render($data);
$this->load->view('header_view', $data);
$this->load->view('movies_view', $output);
$this->load->view('footer_view', $data);
}
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_table('pengumuman');
$crud->columns('isi', 'created_at', 'updated_at', 'status');
$crud->unset_export();
$crud->unset_print();
$crud->unset_texteditor('isi');
$crud->change_field_type('created_at', 'invisible');
$crud->change_field_type('updated_at', 'invisible');
$crud->callback_before_insert(array($this, "_timestamp"));
$output = $crud->render();
$output->title = 'Kelola Pengumuman';
$this->template->load('template/template_main', 'admin/pengumuman', $output);
}
private function master()
{
$crud = new grocery_CRUD();
$crud->set_table('contents');
$crud->unset_columns('jenis', 'slug', 'isi');
$crud->callback_before_insert(array($this, "_timestamp"));
$crud->callback_before_update(array($this, "_timestamp"));
$crud->unset_export();
$crud->unset_print();
$crud->unset_read();
$crud->change_field_type('jenis', 'invisible');
$crud->change_field_type('slug', 'invisible');
$crud->change_field_type('created_at', 'invisible');
$crud->change_field_type('updated_at', 'invisible');
return $crud;
}
public function index()
{
$this->authlibrary->hasPrivilege("announcement");
$crud = new grocery_CRUD();
$crud->set_table('announcement');
$crud->columns('isi', 'created_at', 'updated_at', 'status');
$crud->unset_export();
$crud->unset_print();
$crud->unset_texteditor('isi');
$crud->change_field_type('created_at', 'invisible');
$crud->change_field_type('updated_at', 'invisible');
$crud->callback_before_insert(array($this, "_timestamp"));
$output = $crud->render();
$output->menu = "announcement";
$output->title = 'Announcement';
$this->template->load('backend/template', 'backend/grocery_crud_view', $output);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_table('admin');
$crud->columns('nama', 'username', 'email', 'last_login', 'role');
$crud->unset_export();
$crud->unset_print();
$crud->unset_read();
$crud->unset_edit_fields('password');
$crud->callback_before_insert(array($this, "_timestamp"));
$crud->change_field_type('created_at', 'invisible');
$crud->change_field_type('updated_at', 'invisible');
$crud->change_field_type('last_login', 'invisible');
$output = $crud->render();
$output->title = 'Kelola Admin';
$this->template->load('template/template_main', 'admin/contents', $output);
}
public function index($categoryid = 0)
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$data['lo'] = 1;
//value used to identify section movie or celebrity
if ($categoryid != 0) {
$data['cat_id'] = $categoryid;
$cat_title = $this->category->getTitle($categoryid);
$data['cat_title'] = $cat_title . " ";
$form_subject = $cat_title;
$crud = new grocery_CRUD();
$crud->set_table('dbx_celebrities');
$crud->where('catid', $categoryid);
$crud->set_subject($form_subject);
$crud->required_fields('name');
$crud->columns('name');
// $crud->callback_column('name',array($this,'link_title'));
// $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]');
$crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl'));
$crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl'));
$crud->fields('catid', 'name', 'alt_name1', 'alt_name2', 'alt_name3', 'alt_name4', 'title', 'desc', 'sign', 'birth_date', 'birth_place', 'first_film', 'awards', 'height', 'weight', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date');
// $crud->field_type('catid', 'hidden', $categoryid);
$crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'C'), null, $categoryid);
$crud->display_as('catid', 'Category');
$crud->callback_add_field('desc', array($this, 'add_field_desc'));
$crud->callback_add_field('awards', array($this, 'add_field_awards'));
$crud->callback_edit_field('desc', array($this, 'edit_field_desc'));
$crud->callback_edit_field('awards', array($this, 'edit_field_awards'));
$crud->field_type('sign', 'dropdown', array('Aries' => 'Aries', 'Taurus' => 'Taurus', 'Gemini1' => 'Gemini', 'Cancer' => 'Cancer', 'Leo' => 'Leo', 'Virgo' => 'Virgo', 'Libra' => 'Libra', 'Scorpio' => 'Scorpio', 'Sagittarius' => 'Sagittarius', 'Capricorn' => 'Capricorn', 'Aquarius' => 'Aquarius', 'Pisces' => 'Pisces'));
$crud->change_field_type('ownerid', 'invisible');
$crud->change_field_type('created_date', 'invisible');
$crud->change_field_type('seo_url', 'invisible');
$crud->change_field_type('lastupdate_date', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->unset_jquery();
$output = $crud->render($data);
$this->load->view('header_view', $data);
$this->load->view('celebrities_view', $output);
$this->load->view('footer_view', $data);
}
}
public function index1()
{
$crud = new grocery_CRUD();
$crud->set_theme('twitter-bootstrap');
// $crud->set_theme('datatables');
// $crud->set_theme('flexigrid');
$crud->set_table('users');
$crud->change_field_type('email', 'text');
$output = $crud->render();
$this->_example_output($output);
}
function users_management()
{
$crud = new grocery_CRUD();
$crud->set_table('operarios');
$crud->set_subject('Usuario');
$crud->set_theme('datatables');
$crud->columns('id', 'nombre');
$crud->edit_fields('nombre', 'clave', 'eliminado');
$crud->add_fields('id', 'nombre', 'clave');
$crud->required_fields('id', 'nombre', 'clave');
$crud->change_field_type('clave', 'password');
$crud->callback_before_insert(array($this, '_encrypt_password_callback'));
$crud->callback_before_update(array($this, '_encrypt_password_callback'));
$crud->unset_delete();
$output = $crud->render();
$this->_output_crud($output, 'Usuarios');
}
public function index($stat = '')
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
switch ($stat) {
case '':
default:
$user_ward_id = $this->session->userdata('nw_id');
$crud->set_table('nus_bed');
$crud->where('nus_bed.nw_id', $user_ward_id);
$crud->columns('nb_bed_no', 'np_pmi_id', 'nbs_id', 'nb_datetime', 'ns_id');
$crud->display_as('nb_bed_no', 'Bed No.')->display_as('np_pmi_id', 'Patient Name')->display_as('nbs_id', 'Remarks')->display_as('nb_datetime', 'Date/Time Registered')->display_as('ns_id', 'Nurse');
$crud->set_relation('nbs_id', 'nus_bed_status', 'nbs_desc');
$crud->set_relation('ns_id', 'nus_staff', 'ns_fullname');
$crud->set_relation('np_pmi_id', 'nus_patient', 'np_fullname');
// $crud->unset_add();
// $crud->unset_delete();
$crud->edit_fields('np_pmi_id', 'nbs_id', 'nb_datetime', 'ns_id');
$crud->add_fields('nb_bed_no', 'nw_id', 'nbs_id');
$crud->field_type('nw_id', 'hidden');
// $crud->field_type('nbs_id', 'hidden');
$crud->required_fields('nb_bed_no');
$crud->unset_read();
// $crud->change_field_type('nb_bed_no', 'readonly');
$crud->change_field_type('ns_id', 'readonly');
$crud->callback_before_update(array($this, 'autoRegisterBed'));
$crud->callback_before_insert(array($this, 'addBed'));
break;
case 'patient':
$crud->set_table('nus_patient');
$crud->set_relation('np_gender', 'nus_patient_gender', 'npg_desc');
$crud->required_fields('np_pmi_no', 'np_fullname', 'np_ic', 'np_passport', 'np_gender');
$crud->fields('np_pmi_id', 'np_fullname', 'np_ic', 'np_passport', 'np_gender');
$crud->field_type('np_pmi_id', 'hidden');
$crud->display_as('np_pmi_id', 'PMI No.')->display_as('np_fullname', 'Full Name')->display_as('np_ic', 'IC No.')->display_as('np_passport', 'Passport No.')->display_as('np_gender', 'Gender');
$crud->callback_before_insert(array($this, 'autoInsertPriKeyPatient'));
break;
}
$output = $crud->render();
$this->viewpage('v_mainpage', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function generarCobertura()
{
if ($this->session->userdata('institucion') != 'A') {
$this->session->set_flashdata('error', 'Su nivel de usuario no le permite realizar este proceso');
redirect(site_url("index/principal"), 301);
}
$tipo = array('0' => 'No Notificó', '1' => 'Notificó', '2' => 'Not. Negativa');
$crud = new grocery_CRUD();
$crud->columns('ano', 'semana', 'ndiresa', 'nred', 'nmicrored', 'nestablec', 'notificacion', 'fecha', 'hora');
$crud->set_table('cobertura');
$crud->set_subject('Proceso');
switch ($this->session->userdata('nivel')) {
case 5:
$where = array('diresa' => $this->session->userdata('diresa'));
break;
case 6:
$where = array('diresa' => $this->session->userdata('diresa'), 'red' => $this->session->userdata('red'));
break;
case 7:
$where = array('diresa' => $this->session->userdata('diresa'), 'red' => $this->session->userdata('red'), 'microred' => $this->session->userdata('microred'));
break;
default:
$this->session->set_flashdata('error', 'Este proceso no está permitido para su nivel de usuario');
redirect(site_url("index/principal"), 301);
break;
}
$crud->field_type('notificacion', 'dropdown', $tipo);
$crud->display_as('establec', 'Establecimiento');
$crud->display_as('notificacion', 'Notificación');
$crud->display_as('ndiresa', 'Diresa');
$crud->display_as('nred', 'Red');
$crud->display_as('nmicrored', 'Microred');
$crud->display_as('nestablec', 'Establecimiento');
$crud->where($where);
$crud->change_field_type('ano', 'readonly');
$crud->change_field_type('semana', 'readonly');
$crud->change_field_type('diresa', 'readonly');
$crud->change_field_type('red', 'readonly');
$crud->change_field_type('microred', 'readonly');
$crud->change_field_type('establec', 'readonly');
//$crud->unset_read();
//$crud->unset_edit();
$crud->unset_delete();
$crud->unset_print();
$crud->unset_add();
///////////////////////////////////////////////////////////////////////////////
$crud->add_action_peru('Añadir Proceso', '', 'proceso', 'add-icon');
///////////////////////////////////////////////////////////////////////////////
$output = $crud->render();
$this->_example_output1($output);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_table('usrmgr');
$crud->change_field_type('password', 'password');
$crud->callback_edit_field('password', array($this, 'decrypt_password_callback'));
$crud->columns('username', 'nama_lengkap', 'email', 'level', 'blokir');
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->set_subject('Users');
$crud->fields('nama_lengkap', 'username', 'password', 'email', 'level', 'access_control', 'blokir');
$crud->required_fields('nama_lengkap', 'username', 'level', 'blokir');
$crud->set_relation_n_n('access_control', 'usrmgr_access', 'modul', 'id_users', 'id_modul', 'nama_modul', 'priority');
//$crud->set_relation('salesRepEmployeeNumber','employees','lastName');
$output = $crud->render();
$data['subject'] = 'Pengaturan Pengguna';
$data['content'] = $this->load->view('crud.php', $output, true);
$this->load->view('base_theme', $data);
}
public function data_topic()
{
$crud = new grocery_CRUD();
// table name
$crud->set_table("help_topic");
// displayed columns on list
$crud->columns('title', 'group_id', 'content');
// displayed columns on edit operation
$crud->edit_fields('title', 'group_id', 'content');
// displayed columns on add operation
$crud->add_fields('title', 'url', 'group_id', 'content');
// caption of each columns
$crud->display_as('group_id', 'Group')->display_as('title', 'Title')->display_as('content', 'Content');
$crud->change_field_type('url', 'hidden');
$crud->set_relation('group_id', 'help_group', 'name');
$crud->callback_before_insert(array($this, 'before_insert_topic'));
// render
$output = $crud->render();
$this->view("grocery_CRUD", $output, "help_topic");
}
function editar_horario($idPersonal)
{
//Creo el objeto crud
$crud = new grocery_CRUD();
//Defino tabla sobre la que trabajo y tipo de 'Objeto'
$crud->set_table('HorariosPersonal');
$crud->set_subject('Día');
$crud->set_relation('diaSemana', 'diasSemana', 'descripcion');
$crud->change_field_type('idPersonal', 'hidden', $idPersonal);
//Seteo campos requeridos
$crud->required_fields('diaSemana, horaEntrada, horaSalida');
//Defino nombres para cada campo.
$crud->display_as('diaSemana', 'Día de la Semana');
$crud->display_as('horaEntrada', 'Hora de Entrada');
$crud->display_as('horaSalida', 'Hora de Salida');
//Genero el ABM
$output = $crud->render();
//Llamo a la función encargada de mostrar el ABM.
mostrar_crud($output, '', $this->menu, 'reportes-entrada-salida/personal/abm', '', 'reportes-entrada-salida/personal/abm_final');
}
public function index()
{
$crud = new grocery_CRUD();
// crud settings
$crud->set_theme('bootstrap');
$crud->set_table('user_group');
$crud->set_subject('Gebruikersgroepen');
$crud->columns('name', 'key');
$crud->display_as('name', 'Naam');
$crud->required_fields('name');
$crud->callback_before_insert(array($this, 'before_insert'));
$crud->change_field_type('key', 'invisible');
$crud->set_relation_n_n('gebruikers', 'user_x_user_group', 'user', 'user_group_id', 'user_id', 'email');
// render the crud HTML
$crud_output = $crud->render();
$this->javascript_files = $crud->get_js_files();
$this->css_files = $crud->get_css_files();
$this->views['content'] = $crud_output->output;
$this->_layout();
}
function administracion()
{
try {
/* Creamos el objeto */
$crud = new grocery_CRUD();
/* Seleccionamos el tema */
$crud->set_theme('bootstrap');
/* Seleccionmos el nombre de la tabla de nuestra base de datos*/
$crud->set_table('categorias');
/* Le asignamos un nombre */
$crud->set_subject('Categorias');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* Aqui le decimos con que campos vamos a trabajar-util para el callback */
$crud->fields('id', 'descripcion', 'creado_en');
/* Aqui le decimos que el campo del timestamp no sea visible */
$crud->change_field_type('creado_en', 'invisible');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('descripcion');
/* Aqui definimos que campos seran visibles en el formulario de ingresos d ecategoria nueva */
$crud->add_fields('descripcion');
/* Aqui le indicamos que campos deseamos mostrar al listar */
$crud->columns('id', 'descripcion', 'creado_en');
/*Le cambiamos en nombre al la columna id */
$crud->display_as('id', 'Referencia');
/* llamamos al call_back antes del insert (pone la fecha) */
$crud->callback_before_insert(array($this, 'guardar_fecha'));
//$crud->unset_jquery();
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en
/applications/views/productos/administracion.php */
$this->load->view('header');
$this->load->view('categorias/administracion', $output);
$this->load->view('footer');
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function listarUsuariosAdministradores()
{
$adm = $this->usuarios_model->buscarAdministrador($this->session->userdata('usuario'));
$administrador = array();
foreach ($adm as $dato) {
$administrador[$dato->usuario] = $dato->nombres;
}
$crud = new grocery_CRUD();
$crud->set_table('usuarios_backend');
$crud->columns('usuario', 'nombres', 'dni', 'correo', 'nivel', 'estado', 'codigo', 'autoriza', 'caduca', 'registro');
$crud->display_as('registroId', 'from usuarios_backend')->display_as('usuario', 'Usuario')->display_as('contrasena', 'Contraseña');
$crud->change_field_type('clave', 'password');
$crud->set_subject('Usuario');
$crud->field_type('nivel', 'dropdown', array('1' => 'Administrador', '2' => 'Operador'));
$crud->field_type('estado', 'dropdown', array('1' => 'Activo', '2' => 'Inactivo'));
$crud->field_type('autoriza', 'dropdown', $administrador);
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->unset_read();
$output = $crud->render();
$this->_example_output($output);
}
public function salacontrol()
{
try {
$crud = new grocery_CRUD();
//$crud->set_theme('datatables');
$crud->set_table('salas');
$crud->set_subject('Sala');
$crud->required_fields('campus', 'numero', 'tipo', 'capacidade');
$crud->display_as('campus', 'Campus');
$crud->display_as('numero', 'Número da Sala');
$crud->display_as('cidadeID', 'Campus');
$crud->unset_columns('disponibilidade');
$crud->unset_add_fields('disponibilidade');
$crud->set_relation('campus', 'cidades', 'nome');
$crud->set_relation('tipo', 'tipos', 'nome');
//$crud->set_rules('numero', 'Número da Sala', 'Integer');
$crud->change_field_type('disponibilidade', 'true_false');
$output = $crud->render();
$this->_sala_output($output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function administration()
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('sites');
$crud->set_subject('Directorio de Sitios');
$crud->set_language('spanish');
$crud->unset_export();
$crud->columns('name', 'url', 'owner', 'active', 'fk_language');
// $crud->required_fields('name', 'url', 'description', 'fk_type', 'fk_owner');
$crud->set_relation('fk_type', 'types_site', 'type');
$crud->set_relation('fk_language', 'languages', 'language');
$crud->set_relation_n_n('parent', 'parents_site', 'sites', 'child_site', 'parent_site', 'name');
$crud->set_relation_n_n('owner', 'site_owner', 'owners', 'fk_site', 'fk_owner', 'name');
$crud->set_relation_n_n('icon', 'site_icon', 'icons', 'fk_site', 'fk_icon', 'icon');
$crud->set_relation_n_n('text', 'site_text', 'text', 'fk_site', 'fk_text', 'text');
$crud->set_relation_n_n('category', 'sites_categories', 'categories', 'fk_site', 'fk_category', 'category');
$crud->set_relation_n_n('tags', 'sites_tags', 'tags', 'fk_site', 'fk_tag', 'tag');
$crud->change_field_type('description', 'text');
// $crud->callback_add_field('text', array($this, 'field_add_text_callback'));
// $crud->callback_add_field('icon', array($this, 'field_icon_callback'));
$crud->display_as('name', 'Nombre')->display_as('url', 'URL')->display_as('description', 'Descripción')->display_as('active', 'Estado')->display_as('date_publication', 'Inicio de Publicidad')->display_as('published_to_date', 'Fin de Publicidad')->display_as('priority', 'Prioridad')->display_as('category', 'Categoría')->display_as('owner', 'Propietario')->display_as('parent', 'Sitios Padre')->display_as('tags', 'Palabras Claves')->display_as('icon', 'Icono')->display_as('text', 'Texto Adicional')->display_as('fk_language', 'Idioma')->display_as('fk_type', 'Tipo de sitio');
//$crud->change_field_type('name','file');
/**
* Insertando campos en las tablas "icons_site" y "add_text"
*/
$crud->callback_after_insert(array($this, 'after_insert'));
$crud->callback_before_delete(array($this, 'before_delete_log'));
$crud->callback_after_update(array($this, 'after_update_log'));
$output = $crud->render();
$this->load->view('includes/template', $output);
} catch (Exception $e) {
/* Si algo sale mal mostramos error */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
private function get_crud()
{
$this->data['message'] = $this->session->flashdata('message');
$crud = new grocery_CRUD();
$crud->set_theme(GROCERY_CRUD_THEME);
$crud->set_table('fornecedor');
$crud->set_subject('Fornecedor');
$crud->unset_columns('id');
$crud->fields('id', 'codigo', 'nome', 'cnpj', 'inscricao_estadual', 'tipo_fornecedor_id');
$crud->unset_texteditor('id');
$crud->change_field_type('id', 'invisible');
/* relacionamentos */
$crud->set_relation('tipo_fornecedor_id', 'tipo_fornecedor', 'descricao');
/* descrição dos campos de relacionamento */
$crud->display_as('tipo_fornecedor_id', 'Tipo de Fornecedor');
/* regras e campos obrigatórios */
$crud->required_fields('nome');
$crud->required_fields('codigo');
$crud->required_fields('tipo_fornecedor_id');
$crud->set_rules('nome', 'Nome', 'required|min_length[3]');
$crud->set_rules('codigo', 'Código', 'required|min_length[3]');
$crud->set_rules('tipo_fornecedor_id', 'Tipo de Fornecedor', 'required');
return $crud->render();
}
function users()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('user');
$crud->display_as('login', 'Username');
$crud->display_as('user_name', 'Name');
$crud->set_subject('User');
$crud->columns('login', 'user_type', 'user_name', 'email', 'mobile');
$crud->required_fields('login', 'user_type', 'user_name', 'email', 'mobile');
$crud->set_rules('email', 'Email', 'trim|required|valid_email');
$crud->change_field_type('password', 'password');
// Cripatare password
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_edit_field('password', array($this, 'set_password_input_to_empty'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
//$crud->callback_edit_field('password',array($this,'decrypt_password_callback'));
// Realatii baza de date
//$crud->set_relation('grup','grup','grup_name');
//$crud->set_field_upload('imagine_monitor','assets/uploads/files');
$crud->field_type('user_type', 'dropdown', array('admin' => 'admin', 'user' => 'user'));
$output = $crud->render();
$this->_admin_output($output);
}
private function get_crud()
{
$this->data['message'] = $this->session->flashdata('message');
$crud = new grocery_CRUD();
$crud->set_theme(GROCERY_CRUD_THEME);
$crud->set_table('insumo');
$crud->set_subject('Insumo');
$crud->unset_columns('id');
$crud->fields('id', 'codigo', 'descricao', 'tipo_insumo_id', 'tipo_unidade_id', 'origem_insumo_id');
$crud->display_as('codigo', 'Código');
$crud->display_as('descricao', 'Descrição');
$crud->display_as('tipo_insumo_id', 'Tipo');
$crud->display_as('tipo_unidade_id', 'Unidade');
$crud->display_as('origem_insumo_id', 'Origem');
$crud->change_field_type('id', 'invisible');
/* relacionamentos */
$crud->set_relation('tipo_insumo_id', 'tipo_insumo', 'descricao');
$crud->set_relation('tipo_unidade_id', 'tipo_unidade', 'sigla');
$crud->set_relation('origem_insumo_id', 'origem_insumo', 'descricao');
/* regras e campos obrigatórios */
$crud->required_fields('descricao');
$crud->set_rules('descricao', 'Descrição', 'required|min_length[3]');
return $crud->render();
}
public function persutujuan_daftar_kegiatan()
{
try {
$this->load->model("user_m");
$crud = new grocery_CRUD();
$state = $crud->getState();
$id_user = $this->uri->segment(3);
$status = $this->uri->segment(4);
//echo $status; exit;
/*$data = $this->user_m->detail($id_user);
$row = $data[0];
$nama_depan = isset($row->nama_depan)?$row->nama_depan:"";
$nama_belakang = isset($row->nama_belakang)?$row->nama_belakang:"";*/
if (!empty($id_user)) {
$crud->where('tbl_kegiatan_transaksi.id_user', $id_user);
}
if (!empty($status)) {
$crud->where('tbl_kegiatan_transaksi.status', $status);
}
$crud->set_table('tbl_kegiatan_transaksi');
$crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}');
$crud->set_subject('Daftar Kegiatan');
$crud->fields('id_user', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'status', 'status_deskripsi', 'angka_kredit');
$crud->columns('id_user', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'keterangan', 'status', 'angka_kredit');
$crud->add_action('Daftar Berkas', '', 'penilai/persutujuan_daftar_kegiatan_berkas', 'fa fa-upload');
$crud->display_as("tanggal_kegiatan", "Tanggal Mulai")->display_as("tanggal_kegiatan_selesai", "Tanggal Selesai")->display_as("id_user", "Pegawai");
$crud->order_by('id_kegiatan_transaksi', 'desc');
$crud->change_field_type('id_user', 'readonly');
$crud->change_field_type('tanggal_kegiatan', 'readonly');
$crud->change_field_type('tanggal_kegiatan_selesai', 'readonly');
$crud->change_field_type('jumlah_hari_libur', 'readonly');
$crud->change_field_type('lembur', 'readonly');
$crud->change_field_type('keterangan', 'readonly');
$crud->change_field_type('angka_kredit', 'readonly');
$crud->unset_add();
$crud->unset_save();
$crud->unset_read();
$crud->unset_delete();
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_pegawai', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function transfer_clculation()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('transfer_clculation');
$crud->set_relation('car_type', 'car_type', 'type_name');
$crud->set_subject('Transfer');
$crud->change_field_type('fixed', 'true_false');
$crud->required_fields('car_type', 'kilometer', 'fixed');
$output = $crud->render();
$this->_example_output($output);
}
public function widget()
{
$crud = new grocery_CRUD();
$crud->set_table('cms_widget');
$crud->set_subject('Widget');
$crud->columns('widget_name', 'title', 'active', 'is_static', 'description', 'authorization_id', 'slug', 'groups');
$crud->edit_fields('widget_name', 'title', 'active', 'description', 'index', 'is_static', 'static_content', 'url', 'slug', 'authorization_id', 'groups');
$crud->add_fields('widget_name', 'title', 'active', 'description', 'index', 'is_static', 'static_content', 'url', 'slug', 'authorization_id', 'groups');
$crud->change_field_type('active', 'true_false');
$crud->change_field_type('is_static', 'true_false');
$crud->change_field_type('index', 'integer');
$crud->display_as('widget_name', 'Widget Code')->display_as('title', 'Title (What visitor see)')->display_as('active', 'Active')->display_as('description', 'Description')->display_as('url', 'URL (Where is it point to)')->display_as('index', 'Order')->display_as('is_static', 'Static')->display_as('static_content', 'Static Content')->display_as('slug', 'Slug')->display_as('authorization_id', 'Authorization')->display_as('groups', 'Groups');
$crud->unset_texteditor('static_content');
$crud->unset_texteditor('description');
$crud->set_relation('authorization_id', 'cms_authorization', 'authorization_name');
$crud->set_relation_n_n('groups', 'cms_group_widget', 'cms_group', 'widget_id', 'group_id', 'group_name');
$crud->callback_before_insert(array($this, 'before_insert_widget'));
$crud->callback_column('active', array($this, 'column_widget_active'));
$output = $crud->render();
$this->view('main/widget', $output, 'main_widget_management');
}
public function kegiatan_lama()
{
$status = $this->input->get("status");
$crud = new grocery_CRUD();
$crud->where("tbl_kegiatan_transaksi.status", "Lama");
$crud->set_table('tbl_kegiatan_transaksi');
$crud->set_subject('Kegiatan Lama');
$crud->set_relation('change_by', 'tbl_user', 'email');
$crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}');
$crud->set_relation('id_kegiatan_butir', 'view_kegiatan_butir', '{unsur} - {subunsur} - {butir}');
$crud->set_primary_key('id_kegiatan_butir', 'view_kegiatan_butir');
$crud->required_fields('tanggal_kegiatan', 'tanggal_kegiatan_selesai');
$crud->fields('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'status', 'change_by', 'change_date');
$crud->columns('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'status');
$crud->display_as("id_kegiatan_butir", "Butir Kegiatan")->display_as("tanggal_kegiatan", "Tanggal Mulai")->display_as("tanggal_kegiatan_selesai", "Tanggal Selesai")->display_as("id_user", "Oleh")->display_as("change_date", "Tanggal")->display_as("id_periode", "Periode")->display_as("id_kegiatan_jabatan", "Bertindak Sebagai");
$crud->callback_add_field('id_user', array($this, '_form_get_user_callback'));
$crud->callback_edit_field('id_user', array($this, '_form_get_user_callback'));
$crud->callback_add_field('status', array($this, '_kegiatan_lama_get_status_callback'));
$crud->callback_edit_field('status', array($this, '_kegiatan_lama_get_status_callback'));
$crud->callback_before_update(array($this, 'get_change_by_callback'));
$crud->callback_before_insert(array($this, 'get_change_by_callback'));
$crud->callback_field('change_date', array($this, 'format_date_callback'));
$crud->change_field_type('id_user', 'readonly');
$crud->change_field_type('change_by', 'readonly');
$crud->change_field_type('change_date', 'readonly');
$crud->add_action('Unggah Bukti', '', 'pegawai/daftar_kegiatan_berkas', 'fa fa-upload');
$crud->unset_read();
$crud->order_by('id_kegiatan_transaksi', 'desc');
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_pegawai', $output);
}
public function comment($article_id = NULL)
{
$crud = new grocery_CRUD();
$crud->set_table('blog_comment');
if (isset($article_id) && intval($article_id) > 0) {
$crud->where('blog_comment.article_id', $article_id);
$crud->change_field_type('article_id', 'hidden');
}
$crud->columns('article_id', 'content');
$crud->unset_add();
$crud->unset_edit();
$crud->display_as('article_id', 'title');
$crud->set_relation('article_id', 'blog_article', 'article_title');
$crud->callback_before_insert(array($this, 'before_insert_comment'));
$output = $crud->render();
$this->view('grocery_CRUD', $output, 'blog_comment');
}
function user_managervehicle()
{
if ($this->userconfig->perfil == 'ADMIN' or $this->userconfig->perfil == 'CALL') {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('usuarios');
$crud->set_subject('Rutas');
//$crud->columns('nombre','idsucursal','codigo','pais','departamento','ciudad','direccion','telefono','perfil');
$crud->columns('idsucursal', 'nombre');
$crud->fields('idsucursal', 'nombre', 'codigo', 'pais', 'departamento', 'ciudad', 'perfil');
$crud->required_fields('idsucursal', 'nombre', 'perfil');
$crud->display_as('nombre', 'Ruta');
$crud->change_field_type('perfil', 'hidden');
$crud->change_field_type('codigo', 'hidden');
$crud->change_field_type('pais', 'hidden');
$crud->change_field_type('departamento', 'hidden');
$crud->change_field_type('ciudad', 'hidden');
if ($this->userconfig->perfil == 'ADMIN') {
$crud->set_relation('idsucursal', 'sucursales', 'nombre');
} else {
$crud->set_relation('idsucursal', 'sucursales', 'nombre', 'id IN ("' . $this->userconfig->idsucursal . '")');
}
$crud->display_as('idsucursal', 'Sucursal');
$crud->callback_edit_field('perfil', array($this, 'set_user_cust'));
$crud->callback_add_field('perfil', array($this, 'set_user_cust'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_after_insert(array($this, 'set_code_rutas'));
$crud->where('perfil =', 'CUST');
$crud->order_by('idsucursal,nombre');
if ($this->userconfig->perfil != 'ADMIN') {
$crud->where('idsucursal =', $this->userconfig->idsucursal);
}
$output = $crud->render();
$output->op = 'user_management';
$this->_admin_output($output);
} else {
$this->close();
}
}
