protected function generate_crud($table, $subject = '')
{
// create CRUD object
$this->load->library('Grocery_CRUD');
$crud = new grocery_CRUD();
$crud->set_table($table);
// auto-generate subject
if (empty($subject)) {
$crud->set_subject(humanize(singular($table)));
}
// load settings from: application/config/grocery_crud.php
$this->load->config('grocery_crud');
$this->mCrudUnsetFields = $this->config->item('grocery_crud_unset_fields');
if ($this->config->item('grocery_crud_unset_jquery')) {
$crud->unset_jquery();
}
if ($this->config->item('grocery_crud_unset_jquery_ui')) {
$crud->unset_jquery_ui();
}
if ($this->config->item('grocery_crud_unset_print')) {
$crud->unset_print();
}
if ($this->config->item('grocery_crud_unset_export')) {
$crud->unset_export();
}
if ($this->config->item('grocery_crud_unset_read')) {
$crud->unset_read();
}
foreach ($this->config->item('grocery_crud_display_as') as $key => $value) {
$crud->display_as($key, $value);
}
// other custom logic to be done outside
$this->mCrud = $crud;
return $crud;
}
public function index()
{
// $data = array(
// 'main_content' => 'clients_wishlist',
// 'output' => $this->db->get_where('clients_wishlist', array('wish_user' => $this->ion_auth->get_user_id()))->result(),
// 'pagetitle' => 'Wishlist',
// 'pagedesc' => 'Wishlist',
// 'contenttitle' => 'Wishlist Records',
// 'left_menu' => 'clients_menu'
// );
// $this->load->view('gc_client_wrapper', $data);
$this->load->library('grocery_CRUD');
// $this->upload_path = '../assets/uploads/' . 'packages';
// $this->wrapper = 'gc_admin_wrapper';
$this->load->model('generic_model');
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('clients_wishlist');
$crud->set_subject('Client Wishlist');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->where('wish_user', $this->ion_auth->get_user_id());
$crud->display_as('wish_title', 'Wish Title');
$crud->display_as('wish_date', 'Wish Date');
$crud->callback_column('wish_title', array($this, 'set_change_status'));
$crud->unset_columns('wish_url', 'wish_user');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Client Wishlist', 'pagedesc' => 'Client Wishlist', 'contenttitle' => 'Wishlist Records', 'left_menu' => 'clients_menu');
$this->load->view('gc_admin_wrapper', $data);
}
public function listarNeumonias()
{
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$est = $this->frontend_model->listaEstablec();
$estab = array();
foreach ($est as $dato) {
$estab[$dato->cod_est] = $dato->raz_soc;
}
$crud = new grocery_CRUD();
$crud->set_table('neumonias');
$crud->columns('diresa', 'e_salud', 'apepat', 'apemat', 'nombres', 'sexo', 'fecha_reg', 'fecha_def', 'usuario');
$crud->set_subject('Ficha');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('e_salud' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
$where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
$crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino'));
$crud->field_type('diresa', 'dropdown', $subr);
$crud->field_type('e_salud', 'dropdown', $estab);
$crud->display_as("apepat", "Apellido Paterno");
$crud->display_as("apemat", "Apellido Materno");
$crud->display_as("fecha_reg", "Registro");
$crud->display_as("fecha_def", "Defunción");
$crud->display_as("e_salud", "Establecimiento");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_export();
//$crud->unset_print();
$crud->callback_after_delete(array($this, 'log_usuario_before_delete'));
$crud->add_action_peru('', '', 'RegfichaNeum', 'add-icon');
$crud->add_action('Modificar Ficha', '', 'modulos3/ModfichaNeum', 'edit-icon');
$crud->add_action('Ver Ficha', '', 'modulos3/VerfichaNeum', 'read-icon');
$output = $crud->render();
$this->_example_output($output);
}
public function listar_transito()
{
/*$establecimiento = $this->mantenimiento_transito->listarEstablecimiento();
foreach($establecimiento as $dato){
$est[$dato->cod_est] = $dato->raz_soc;
} */
$crud = new grocery_CRUD();
//$crud->set_theme('bootstrap');
$crud->set_table('trans_lesacctra');
$crud->columns('id', 'ano', 'ap_nm1', 'ap_nm2', 'nom_les', 'edad', 'tipo_edad', 'diresa', 'eess');
$crud->set_subject('Ficha Transito');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('cod_eess' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
//$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red' and microred = '$microred')";
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
//$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red')";
$where = array('red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
//$crud->field_type('establec', 'dropdown', $est);
$crud->display_as("id", "ID")->display_as("ano", "AÑO")->display_as("ap_nm1", "APELLIDO PATERNO")->display_as("ap_nm2", "APELLIDO MATERNO")->display_as("nom_les", "NOMBRES")->display_as("edad", "EDAD")->display_as("tipo_edad", "TIPO")->display_as("diresa", "DIRESA")->display_as("eess", "ESTABLECIENTO DE SALUD");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_print();
$crud->unset_export();
$crud->unset_delete();
$crud->order_by('id', 'desc');
$crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulotransito/borrarFichatransito', 'borrar-icon');
$crud->add_action('Vista previa', '', 'modulotransito/ver_ficha_transito', 'read-icon');
$crud->add_action('Editar Ficha Transito', '', 'modulotransito/modificacion_transito', 'edit-icon');
$output = $crud->render();
$usuario = $this->session->userdata("usuario");
$accion = 'Listar Casos Accidentes de Transito';
$this->login_model->auditoriaOperador($usuario, $accion);
$this->layout->view('listar_transito', $output);
}
public function pengaturan()
{
$crud = new grocery_CRUD();
$crud->set_table('pengaturan');
$crud->unset_add();
$crud->unset_delete();
$crud->unset_read();
$output = $crud->render();
//Config Halaman
$output->judul_besar = 'Pengaturan';
$output->judul_kecil = 'Manage Pengaturan';
$output->m_pengaturan = TRUE;
// echo $this->Absensi_model->get_status_mesin();
//$this->Absensi_model->get_data_absen();
$this->_example_output($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()
{
$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($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 mostrar_usuarios()
{
$grocery = new grocery_CRUD();
$grocery->set_theme('bootstrap');
$grocery->set_table('users');
$grocery->set_language('spanish');
$grocery->display_as('username', 'Usuario');
$grocery->display_as('email', 'E-mail');
$grocery->fields('username', 'email');
$grocery->unset_read();
$grocery->columns('username', 'password', 'email');
$grocery->field_type('password', 'password');
$grocery->unset_add();
$grocery->unset_export();
$grocery->unset_print();
$output = $grocery->render();
$this->_example_output($output);
}
public function listarMnp()
{
$crud = new grocery_CRUD();
$crud->set_table('mnp');
$crud->columns('registroId', 'ape_nom', 'sexo', 'fecha_nac', 'fecha_mte', 'fecha_reg', 'usuario');
$crud->set_subject('Ficha');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('e_salud' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
$where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
$crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino', 'I' => 'Indeterminado'));
$crud->display_as("registroId", "Ficha");
$crud->display_as("ape_nom", "Apellidos y Nombres");
$crud->display_as("fecha_nac", "Fecha de Nacimiento");
$crud->display_as("fecha_mte", "Defunción");
$crud->display_as("fecha_reg", "Fecha de Registro");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_export();
$crud->unset_delete();
//$crud->unset_print();
$crud->add_action_peru('', '', 'RegfichaMnp', 'add-icon');
$crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulosmnp/delFichaMnp', 'borrar-icon');
$crud->add_action('Modificar Ficha', '', 'modulosmnp/ModfichaMnp', 'edit-icon');
$crud->add_action('Ver Ficha', '', 'modulosmnp/VerfichaMnp', 'read-icon');
$output = $crud->render();
$this->_example_output($output);
}
public function tabelnya()
{
$crud = new grocery_CRUD();
$crud->set_table('pengaduan');
$crud->set_subject('Daftar Pengaduan');
$crud->columns('nama', 'pengaduan', 'tglpengaduan');
$crud->display_as('nama', 'Nama Pengadu');
$crud->display_as('pengaduan', 'Isi');
$crud->display_as('tglpengaduan', 'Tanggal Masuk');
$crud->unset_print();
$crud->unset_export();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_read();
$output = $crud->render();
$this->load->view('home.php');
$this->load->view('vinfotambahpengaduan.php', $output);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_crud_url_path(site_url('Barcode/index'));
$crud->set_table('data');
//Nama Tabel
$crud->set_subject('Barcode');
$crud->unset_read();
$crud->unset_export();
$crud->unset_print();
$crud->add_action('Generate Barcode', '', '', 'barcode-icon', array($this, 'ca_barcode'));
//Custom Action
$output = $crud->render();
//Config Halaman
$output->judul_besar = 'Barcode';
$output->judul_kecil = 'Generate Barcode';
$output->m_barcode = TRUE;
$this->_example_output($output);
}
public function tabelnya()
{
$crud = new grocery_CRUD();
$crud->set_table('busaha');
$crud->set_subject('Bidang Usaha');
//$crud->columns('judul');
//$crud->unset_print();
//$crud->unset_export();
//$crud->unset_add();
//$crud->unset_edit();
//$crud->unset_delete();
$crud->unset_read();
$output = $crud->render();
$js_files = $output->js_files;
$css_files = $output->css_files;
$data['output'] = $output;
$data['label'] = "Master Bidang Usaha";
$this->load->view('home.php');
$this->load->view('vtabel_master.php', array('js_files' => $js_files, 'css_files' => $css_files, 'output' => $data));
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_model('My_Custom_model');
$crud->set_table('ips_ordertracking', 'ips_productitems');
$crud->set_subject('Sales Tracking');
$crud->required_fields('NAME');
// void set_relation_n_n( string $field_name, string $relation_table, string $selection_table, string $primary_key_alias_to_this_table, string $primary_key_alias_to_selection_table , string $title_field_selection_table [ , string $priority_field_relation ] )
$crud->set_relation_n_n('orderdetails', 'ips_ordertracking', 'ips_productitems', 'ips_ordertracking', 'ordertrackingid', 'description', 'category');
// $crud->set_relation('ordertrackingid','ips_productitems','description');
// $crud->columns('ordertrackingid','fullfillment','orderdate','orderid','returnid','itemrece','caseid','product','status','Action');
// $crud->display_as('orderdate','Order Date')->display_as('orderid','Order ID')->display_as('returnid','Sales Return ID')->display_as('itemrece','Item Received')->display_as('caseid','Case ID')->display_as('product','Product Condition')->display_as('ordertrackingid','ID');
$crud->columns('ordertrackingid', 'orderid', 'description', 'category', 'product', 'itemrece', 'cost', 'mrp', 'Action');
$crud->display_as('orderid', 'Order ID')->display_as('itemrece', 'Item Received')->display_as('product', 'Product Condition')->display_as('ordertrackingid', 'ID')->display_as('description', 'Product Name')->display_as('category', 'Category')->display_as('cost', 'Recovery Min')->display_as('mrp', 'Recovery Max');
$crud->callback_column('ordertrackingid', array($this, '_callback_webpage_url'));
$crud->callback_column('orderdate', array($this, '_callback_dateformat'));
$crud->callback_column('fullfillment', array($this, '_callback_fullfillment'));
// $crud->callback_column('product',array($this,'_callback_product'));
$crud->callback_column('status', array($this, '_callback_status'));
$crud->callback_column('itemrece', array($this, '_callback_itemrece'));
$crud->callback_column('cost', array($this, '_callback_recovery_min'));
$crud->callback_column('mrp', array($this, '_callback_recovery_max'));
$crud->callback_column('Action', array($this, '_callback_viewpage_url'));
$crud->unset_edit();
$crud->unset_read();
$crud->unset_delete();
// $crud->callback_after_insert(array($this, 'fullfillmentid_generation'));
$output = $crud->render();
$state = $crud->getState();
if ($state == 'add') {
redirect('store/addtracking');
}
if ($state == 'view') {
redirect('store/viewtracking');
}
// $this->grocery_crud->set_table('ips_login');
// $output = $this->grocery_crud->render();
$this->_example_output($output);
}
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 tabelnya()
{
$crud = new grocery_CRUD();
$crud->set_table('ijin');
$crud->set_subject('Ijin');
$crud->columns('nama', 'waktu', 'retribusi');
$crud->display_as('nama', 'Jenis Perijinan');
$crud->display_as('waktu', 'Waktu (hari kerja)');
$crud->display_as('retribusi', 'Retribusi');
//$crud->unset_print();
//$crud->unset_export();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_read();
$output = $crud->render();
$js_files = $output->js_files;
$css_files = $output->css_files;
$data['output'] = $output;
$data['label'] = "Info Perijinan";
$this->load->view('home.php');
$this->load->view('vinformasi.php', array('js_files' => $js_files, 'css_files' => $css_files, 'output' => $data));
}
public function irasCampos()
{
if (empty($this->session_id)) {
redirect(site_url("index/login"), 301);
}
$reporta = array('ano' => date('Y'), 'semana' => date('W') - 2);
$this->reportes_model->registraCalidad($reporta);
$this->calidad_model->edasCampos();
$crud = new grocery_CRUD();
$crud->set_table('irasDefunciones');
$crud->columns('ano', 'semana', 'sub_reg_nt', 'red', 'microred', 'e_salud', 'ubigeo', 'ira_m2', 'ira_2_11', 'ira_1_4a', 'neu_2_11', 'neu_1_4a', 'ngr_m2', 'ngr_2_11', 'ngr_1_4a');
$crud->display_as('ano', 'Año');
switch ($this->session->userdata('nivel')) {
case 4:
$accesar = $this->session->userdata('equipo');
break;
case 5:
$accesar = $this->session->userdata('diresa');
$crud->or_where(array('sub_reg_nt' => $accesar));
break;
case 6:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1));
break;
case 7:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$accesar2 = $this->session->userdata('microred');
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
break;
case 8:
$accesar = $this->session->userdata('establecimiento');
$crud->where(array('e_salud' => $accesar));
break;
}
$crud->order_by('semana');
$crud->unset_add();
$crud->unset_read();
$crud->unset_edit();
//$crud->unset_delete();
//$crud->unset_export();
$crud->unset_print();
$crud->add_action('Editar', '', 'calidad/modIras', 'edit-icon');
$crud->callback_after_delete(array($this, 'log_iras_registro_after_delete'));
$output = $crud->render();
$this->layout->view('irasCampos.php', $output);
}
public function listadoIndividual()
{
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$dist = $this->frontend_model->listarDistritos();
$ubigeo = array();
foreach ($dist as $dato) {
$ubigeo[$dato->ubigeo] = $dato->nombre;
}
$enf = $this->frontend_model->mostrarDiagnostico();
$enfermedad = array();
foreach ($enf as $dato) {
$enfermedad[$dato->cie_10] = $dato->diagno;
}
$tdx = $this->frontend_model->mostrarTipo();
$tipoDx = array();
foreach ($tdx as $dato) {
$tipoDx[$dato->codigo] = $dato->denominacion;
}
$filtro = array();
$this->input->post('diresa') ? $filtro['sub_reg_nt'] = $this->input->post('diresa') : '';
$this->input->post('redes') ? $filtro['red'] = $this->input->post('redes') : '';
$this->input->post('microred') ? $filtro['microred'] = $this->input->post('microred') : '';
$this->input->post('establec') ? $filtro['e_salud'] = $this->input->post('establec') : '';
$this->input->post('departamento') ? $filtro['substr(ubigeo,1,2)'] = $this->input->post('departamento') : '';
$this->input->post('provincia') ? $filtro['substr(ubigeo,1,4)'] = $this->input->post('provincia') : '';
$this->input->post('distrito') ? $filtro['ubigeo'] = $this->input->post('distrito') : '';
$this->input->post('diagno') ? $filtro['diagnostic'] = $this->input->post('diagno') : '';
$this->input->post('tipoDx') ? $filtro['tipo_dx'] = $this->input->post('tipoDx') : '';
$this->input->post('ano_ini') ? $filtro['ano'] = $this->input->post('ano_ini') : '';
$this->input->post('semana_ini') ? $filtro['semana'] = $this->input->post('semana_ini') : '';
$this->input->post('apepat') ? $filtro['apepat'] = $this->input->post('apepat') : '';
$crud = new grocery_CRUD();
$crud->set_theme("datatables");
$crud->set_table('individual');
$crud->columns('ano', 'semana', 'diagnostic', 'tipo_dx', 'subregion', 'sub_reg_nt', 'ubigeo', 'sexo', 'apepat', 'apemat', 'nombres');
$crud->display_as('ano', 'Año')->display_as('diagnostic', 'Diagnóstico')->display_as('subregion', 'Diresa')->display_as('sub_reg_nt', 'Notificante')->display_as('ubigeo', 'Distrito')->display_as('tipo_dx', 'Tipo')->display_as('apepat', 'Ap. Paterno')->display_as('apemat', 'Ap. Materno');
$crud->field_type('subregion', 'dropdown', $subr);
$crud->field_type('sub_reg_nt', 'dropdown', $subr);
$crud->field_type('ubigeo', 'dropdown', $ubigeo);
$crud->field_type('diagnostic', 'dropdown', $enfermedad);
$crud->field_type('tipo_dx', 'dropdown', $tipoDx);
$crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino'));
if ($this->input->post()) {
if ($this->session->userdata('institucion') == 'A') {
$crud->where($filtro);
} else {
$crud->where($filtro);
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
} else {
$crud->where(array('ano' => date('Y')));
switch ($this->session->userdata('nivel')) {
case 4:
$accesar = $this->session->userdata('equipo');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
break;
case 5:
$accesar = $this->session->userdata('diresa');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'subregion' => $accesar));
} else {
$crud->where(array('subregion' => $accesar));
$crud->or_where(array('sub_reg_nt' => $accesar));
}
break;
case 6:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1));
}
break;
case 7:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$accesar2 = $this->session->userdata('microred');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
}
break;
case 8:
$accesar = $this->session->userdata('establecimiento');
$crud->where(array('e_salud' => $accesar));
break;
}
}
$crud->limit(1000);
$crud->order_by('semana', 'DESC');
$crud->set_subject('Individual');
$crud->unset_add();
$crud->unset_read();
$crud->unset_edit();
$crud->unset_export();
$crud->unset_print();
$crud->callback_after_delete(array($this, 'log_usuario_before_delete'));
$crud->add_action('Editar', '', 'individual/modIndividual', 'ui-icon-pencil');
///////////////////////////////////////////////////////////////////////////////
//$crud->add_action_peru('Añadir Individual', '', 'regIndividual','add-icon');
///////////////////////////////////////////////////////////////////////////////
$output = $crud->render();
$this->_example_output1($output);
}
public function KLUI($jenis)
{
$crud = new grocery_CRUD();
$crud->set_table('klui');
$crud->columns('kbli', 'kegiatan_pokok');
$crud->display_as('kbli', 'KBLI');
$crud->display_as('kegiatan_pokok', 'Kegiatan Pokok');
$crud->add_action('Pilih', '', 'klui', 'sk-icon');
$crud->unset_export();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_print();
$crud->unset_read();
$crud->set_crud_url_path(site_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), site_url(strtolower(__CLASS__ . "/" . $jenis)));
$output = $crud->render();
return $output;
}
public function listarCasos()
{
$nivelUsuario = $this->session->userdata("nivel");
$enfermedad = array('diagnostic' => 'A92.0');
$enfermedad1 = array('diagnostic' => 'A92.5');
$tipo = array('C' => 'Confirmado', 'P' => 'Probable', 'D' => 'Descartado', 'S' => 'Sospechoso');
$est = $this->frontend_model->listaEstablec();
$estab = array();
foreach ($est as $dato) {
$estab[$dato->cod_est] = $dato->raz_soc;
}
$crud = new grocery_CRUD();
$crud->set_table('individual');
//$crud->set_theme('datatables');
$crud->columns('semana', 'diagnostic', 'tipo_dx', 'e_salud', 'ubigeo', 'apepat', 'apemat', 'nombres', 'dni', 'fecha_inv');
$crud->set_subject('Ficha');
switch ($nivelUsuario) {
case '8':
$where = array('e_salud' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'sub_reg_nt' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
$where = array('red' => $this->session->userdata("red"), 'sub_reg_nt' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('sub_reg_nt' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
$crud->where($enfermedad);
$crud->or_where($enfermedad1);
$crud->display_as("apepat", "Ap. Paterno");
$crud->display_as("apemat", "Ap. Materno");
$crud->display_as("ubigeo", "Distrito");
$crud->display_as("diagnostic", "Enfermedad");
$crud->display_as("e_salud", "Establecimiento");
$crud->display_as("fecha_inv", "Investigación");
$crud->set_relation('ubigeo', 'distrito', 'nombre');
$crud->set_relation('diagnostic', 'diagno', 'diagno');
$crud->field_type('e_salud', 'dropdown', $estab);
$crud->field_type('tipo_dx', 'dropdown', $tipo);
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_export();
$crud->unset_delete();
$crud->unset_print();
$crud->add_action('Registrar Ficha', base_url() . 'assets/images/more.png', 'modulos/RegfichaChik', '');
$output1 = $crud->render();
$this->_notificados_output($output1);
}
function supervisor_management()
{
$id = $this->ion_auth->user()->row()->id;
$this->load->library('grocery_CRUD');
try {
$crud = new grocery_CRUD();
$this->load->library('user_agent');
if ($this->agent->is_mobile() && $this->agent->is_tablet() === FALSE) {
$crud->set_theme('bootstrap');
$crud->unset_search();
} else {
$crud->set_theme('datatables');
//datatables, flexigrid, bootstrap
}
$crud->set_table('users');
$crud->set_subject('Supervisor');
$crud->columns('username', 'password_visible', 'su_branch_id', 'su_can_uploadhotdeal');
$crud->required_fields('username', 'password_visible', 'su_branch_id');
$crud->fields('username', 'password_visible', 'su_branch_id', 'su_can_uploadhotdeal');
$crud->display_as('password_visible', 'Password');
$crud->display_as('su_branch_id', 'Branch');
$crud->display_as('su_can_uploadhotdeal', 'Able to upload food & beverage');
$crud->callback_add_field('su_branch_id', array($this, '_selected_branch_callback'));
//For add page set pre-selected value if got pass in brach id
$crud->field_type('su_branch_id', 'dropdown', $this->ion_auth->get_merchant_branch_list($id));
//For view show the branch list text
$crud->callback_insert(array($this, 'supervisor_insert_callback'));
$crud->callback_update(array($this, 'supervisor_update_callback'));
$crud->set_rules('username', 'Username', 'trim|required|callback_supervisor_username_check');
$crud->field_type('su_can_uploadhotdeal', 'true_false');
$controller = 'merchant';
$function = 'profile';
$crud->set_lang_string('insert_success_message', 'Your data has been successfully stored into the database.
<script type="text/javascript">
var originallocation = window.location.pathname;
if(originallocation.indexOf("/supervisor/add") > -1)
{
window.location = "' . site_url($controller . '/' . $function) . '";
}
</script>
<div style="display:none">
');
$crud->set_lang_string('update_success_message', 'Your data has been successfully stored into the database.
<script type="text/javascript">
var originallocation = window.location.pathname;
if(originallocation.indexOf("/supervisor/edit") > -1)
{
window.location = "' . site_url($controller . '/' . $function) . '";
}
</script>
<div style="display:none">
');
$crud->set_lang_string('form_save_and_go_back', 'Save and View Supervisor');
$crud->set_lang_string('form_update_and_go_back', 'Update and View Supervisor');
$crud->unset_export();
$crud->unset_print();
$crud->unset_read();
$state = $crud->getState();
//filter that this is supervisor type user and it is under this merchant
$crud->where('su_merchant_id', $id);
$crud->where('main_group_id', $this->group_id_supervisor);
$output = $crud->render();
return $output;
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function notificacionAutoriza()
{
$anio = array();
for ($i = 2010; $i <= date("Y"); $i++) {
$anio[$i] = $i;
}
$semana = array();
for ($i = 1; $i <= 53; $i++) {
$semana[$i] = $i;
}
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$tipo = array('1' => 'Autorizado', '2' => 'No autorizado');
$crud = new grocery_CRUD();
$crud->columns('ano', 'semana', 'diresa', 'estado', 'fecha', 'hora', 'usuario');
$crud->set_table('autoriza');
$crud->set_subject('Autorización');
$crud->fields('ano', 'semana', 'diresa', 'estado');
$crud->display_as('ano', 'Año');
$crud->field_type('ano', 'dropdown', $anio);
$crud->field_type('semana', 'dropdown', $semana);
$crud->field_type('diresa', 'dropdown', $subr);
$crud->field_type('estado', 'dropdown', $tipo);
$crud->required_fields('diresa', 'ano', 'semana', 'estado');
$crud->order_by('ano, semana', 'DESC');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
//$crud->unset_export();
$crud->unset_DELETE();
$crud->unset_print();
$output = $crud->render();
$this->_example_output1($output);
}
public function vperusahaan($jenis)
{
$crud = new grocery_CRUD();
$crud->set_table('vperusahaan');
$crud->columns('npwp', 'nama', 'alamat');
$crud->set_primary_key('id', 'vperusahaan');
$crud->display_as('npwp', 'NPWP Perusahaan');
$crud->display_as('nama', 'Nama Perusahaan');
$crud->add_action('Pilih', '', 'perus', 'sk-icon');
$crud->unset_export();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_print();
$crud->unset_read();
$crud->set_crud_url_path(site_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), site_url(strtolower(__CLASS__ . "/" . $jenis)));
$output = $crud->render();
return $output;
}
public function listarEstado()
{
$estado = array('0' => '<b>En Mantenimiento</b>', '1' => '<b>En línea</b>');
$crud = new grocery_CRUD();
$crud->set_table('mantenimiento');
$crud->field_type('estado', 'dropdown', $estado);
$crud->unset_add();
$crud->unset_read();
//$crud->unset_edit();
$crud->unset_delete();
$crud->unset_print();
$output = $crud->render();
$this->_example_output18($output);
}
function good_copy()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('good_copy');
$crud->set_relation('test_id', 'mains_tests', '{test_id}-{test_name}', null, 'test_id desc');
$crud->set_field_upload('path', 'assets/uploads/files/good_copy');
$crud->add_action('Download', '', 'admin/download_good_copy', 'ui-icon-plus');
$crud->unset_print();
$crud->unset_export();
//$crud->unset_add();
// $crud->unset_edit();
$crud->unset_delete();
$crud->unset_read();
$output = $crud->render();
$this->_example_output($output);
}
public function persutujuan_daftar_kegiatan_berkas()
{
try {
$crud = new grocery_CRUD();
$state = $crud->getState();
$id_kegiatan_transaksi = $this->uri->segment(3);
$crud->where('id_kegiatan_transaksi', $id_kegiatan_transaksi);
$crud->set_table('tbl_kegiatan_transaksi_berkas');
$crud->set_subject('Daftar Berkas Pegawai');
$crud->set_field_upload('berkas', 'assets/uploads/berkas');
$crud->fields('no', 'judul', 'berkas', 'keterangan');
$crud->columns('no', 'judul', 'berkas', 'keterangan');
$crud->order_by('id_kegiatan_transaksi_berkas', 'desc');
//$crud->change_field_type('nama_depan', 'readonly');
$crud->unset_save();
$crud->unset_add();
$crud->unset_edit();
$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 listarCasos()
{
$establecimiento = $this->mantenimiento_model->listarEstablecimiento();
foreach ($establecimiento as $dato) {
$est[$dato->cod_est] = $dato->raz_soc;
}
$diagnostico = $this->mantenimiento_model->listarDiagnostico();
foreach ($diagnostico as $dato) {
$diagno[$dato->cie_10] = $dato->diagno;
}
$crud = new grocery_CRUD();
//$crud->set_theme("datatables");
$crud->set_table('individual');
$crud->columns('diagnostic', 'e_salud', 'apepat', 'apemat', 'nombres', 'dni');
$crud->set_subject('Ficha');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('diagnostic' => 'O98.1', 'e_salud' => $this->session->userdata("establecimiento"));
$or_where = array('diagnostic' => 'A50');
$crud->where($where);
$crud->or_where($or_where);
break;
case '7':
$where = array('diagnostic' => 'O98.1', 'microred' => $this->session->userdata("microred"), 'redes' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$or_where = array('diagnostic' => 'A50');
$crud->where($where);
$crud->or_where($or_where);
break;
case '6':
$where = array('diagnostic' => 'O98.1', 'redes' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$or_where = array('diagnostic' => 'A50');
$crud->where($where);
$crud->or_where($or_where);
break;
case '5':
$where = array('diagnostic' => 'O98.1', 'sub_reg_nt' => $this->session->userdata("diresa"));
$or_where = array('diagnostic' => 'A50');
$crud->where($where);
$crud->or_where($or_where);
break;
default:
$where = array('diagnostic' => 'O98.1');
$or_where = array('diagnostic' => 'A50');
$crud->where('diagnostic', 'O98.1');
$crud->or_where($or_where);
break;
}
$crud->field_type('e_salud', 'dropdown', $est);
$crud->display_as("e_salud", "Establecimiento");
$crud->field_type('diagnostic', 'dropdown', $diagno);
$crud->display_as("diagnostic", "Enfermedad");
$crud->display_as("apepat", "Paterno");
$crud->display_as("apemat", "Materno");
$crud->display_as("fecha_not", "Notificación");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_read();
$crud->unset_print();
$crud->unset_export();
$crud->add_action('Registrar Ficha', '', 'modulos2/RegfichaSif', 'edit-icon');
$output = $crud->render();
$this->layout->view('listarCasos', $output);
}
public function listadoEdas()
{
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$dist = $this->frontend_model->listarDistritos();
$ubigeo = array();
foreach ($dist as $dato) {
$ubigeo[$dato->ubigeo] = $dato->nombre;
}
$est = $this->frontend_model->listaEstablec();
$establec = array();
foreach ($est as $dato) {
$establec[$dato->cod_est] = $dato->raz_soc;
}
$filtro = array();
$this->input->post('diresa') ? $filtro['sub_reg_nt'] = $this->input->post('diresa') : '';
$this->input->post('redes') ? $filtro['red'] = $this->input->post('redes') : '';
$this->input->post('microred') ? $filtro['microred'] = $this->input->post('microred') : '';
$this->input->post('establec') ? $filtro['e_salud'] = $this->input->post('establec') : '';
$this->input->post('departamento') ? $filtro['substr(ubigeo,1,2)'] = $this->input->post('departamento') : '';
$this->input->post('provincia') ? $filtro['substr(ubigeo,1,4)'] = $this->input->post('provincia') : '';
$this->input->post('distrito') ? $filtro['ubigeo'] = $this->input->post('distrito') : '';
$this->input->post('ano') ? $filtro['ano'] = $this->input->post('ano') : '';
$this->input->post('semana') ? $filtro['semana'] = $this->input->post('semana') : '';
$crud = new grocery_CRUD();
$crud->set_theme("datatables");
$crud->set_table('edas');
$crud->columns('ano', 'semana', 'sub_reg_nt', 'e_salud', 'ubigeo', 'daa_c1', 'daa_c1_4', 'daa_c5', 'dis_c1', 'dis_c1_4', 'dis_c5');
$crud->display_as('ano', 'Año')->display_as('e_salud', 'Establecimiento')->display_as('sub_reg_nt', 'Diresa');
$crud->field_type('sub_reg_nt', 'dropdown', $subr);
$crud->field_type('e_salud', 'dropdown', $establec);
$crud->field_type('ubigeo', 'dropdown', $ubigeo);
if ($this->input->post()) {
if ($this->session->userdata('institucion') == 'A') {
$crud->where($filtro);
} else {
$crud->where($filtro);
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
} else {
$crud->where(array('ano' => date('Y')));
switch ($this->session->userdata('nivel')) {
case 4:
$accesar = $this->session->userdata('equipo');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
break;
case 5:
$accesar = $this->session->userdata('diresa');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar));
} else {
$crud->where(array('sub_reg_nt' => $accesar));
}
break;
case 6:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1));
}
break;
case 7:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$accesar2 = $this->session->userdata('microred');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
}
break;
case 8:
$accesar = $this->session->userdata('establecimiento');
$crud->where(array('e_salud' => $accesar));
break;
}
}
$crud->limit(1000);
$crud->order_by('semana', 'DESC');
$crud->set_subject('Atenciones');
$crud->unset_add();
$crud->unset_read();
$crud->unset_edit();
$crud->unset_export();
$crud->unset_print();
$crud->callback_after_delete(array($this, 'log_usuario_before_delete'));
$crud->add_action('Editar', '', 'edas/modEdas', 'ui-icon-pencil');
///////////////////////////////////////////////////////////////////////////////
//$crud->add_action_peru('Añadir EDAS', '', 'regEdas','add-icon');
///////////////////////////////////////////////////////////////////////////////
$output = $crud->render();
$this->_example_output1($output);
}
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 listarBrotes()
{
$eess = $this->fichas_model->mostrarEstablecimiento();
foreach ($eess as $dato) {
$establec[$dato->cod_est] = $dato->raz_soc;
}
$crud = new grocery_CRUD();
$crud->set_table('bplaguicidas');
$crud->columns('e_salud', 'ubigeo', 'codigo', 'fecha_loc', 'fecha_est', 'fecha_inv', 'fecha_dir', 'fecha_not', 'fecha_rep');
$crud->set_subject('Ficha');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('e_salud' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
$where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
$crud->field_type('e_salud', 'dropdown', $establec);
$crud->set_relation('ubigeo', 'distrito', 'nombre');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_export();
$crud->unset_delete();
$crud->add_action_peru('', '', 'registrarBrote', 'add-icon');
$crud->add_action('Registrar Intoxicados', '', 'modulos4/listarGrillaBrotes', 'more-icon');
$crud->add_action('Registrar Ficha', '', 'modulos4/modificarBrote', 'edit-icon');
$output = $crud->render();
$this->_example_output2($output);
}
