public function mostrar_busqueda()
{
$grocery = new grocery_CRUD();
$grocery->set_theme('bootstrap');
$grocery->set_table('denuncias');
$grocery->set_language('spanish');
$grocery->set_relation('idEstatus', 'estatus', 'descripcion');
$grocery->set_relation('idRecepcion', 'recepcion', 'descripcion');
$grocery->set_relation('idDependencia', 'dependencias', 'dependencia');
$grocery->set_relation('idCiudadano', 'ciudadanos', '{nombre} \\n{apellidoPa} \\n{apellidoMa}');
$grocery->set_relation('idDireccion', 'direcciones', 'colonia');
$grocery->set_relation('idAsunto', 'asuntos', 'descripcion');
$grocery->set_relation('idMedios', 'medios', 'descripcion');
$grocery->display_as('idDependencia', 'Dependencia');
$grocery->display_as('idCiudadano', 'Ciudadano');
$grocery->display_as('idDireccion', 'Dirección');
$grocery->display_as('idRecepcion', 'Recepción');
$grocery->display_as('idEstatus', 'Estatus');
$grocery->display_as('idAsunto', 'Asunto');
$grocery->display_as('idMedios', 'Medios');
$grocery->unset_add();
$grocery->unset_export();
//$grocery->unset_edit();
$grocery->edit_fields('fecha', 'idDependencia', 'idEstatus', 'idRecepcion', 'idMedios');
$grocery->add_action('Editar ciudadano', '', 'ciudadanos/editar_ciudadano');
$grocery->add_action('Editar Direccion', '', 'direcciones/editar_direccion');
$grocery->add_action('Editar Asunto', '', 'asuntos/editar_asunto');
$grocery->columns('fecha', 'idDependencia', 'idCiudadano', 'idEstatus', 'idRecepcion', 'idDireccion', 'idAsunto');
$output = $grocery->render();
$this->_example_output($output);
}
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);
}
function database()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('patients');
$crud->set_subject('Patient');
//$crud->display_as('compartiment_name','Compartiment');
$crud->columns('cnp', 'first_name', 'last_name', 'date_of_birth', 'sex', 'city', 'height', 'weight');
$crud->field_type('sex', 'dropdown', array('Male' => 'Male', 'Female' => 'Female'));
$crud->add_action('Interventions', '', '', 'ui-icon-heart', array($this, 'go_intervention'));
$crud->add_action('Follow-Up', '', '', 'ui-icon-calculator', array($this, 'go_followup'));
$output = $crud->render();
$this->_admin_output($output);
}
function database()
{
$drp = $this->session->userdata('user_type');
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('patients');
$crud->set_subject('Patient');
$crud->display_as('fo_nr', 'Medical Record number');
$crud->field_tip('fo_nr', 'eg: 1234/2016');
$crud->display_as('city', 'City or Locality');
$crud->display_as('gp_phone', 'GP Phone');
$crud->display_as('GP_info', 'Notes');
// User Level Unset
if ($drp == "user") {
$crud->unset_delete();
$crud->unset_export();
$crud->unset_print();
// afisare fara statistici // data 24.01.2017
$crud->columns('id', 'fo_nr', 'cnp', 'last_name', 'first_name', 'follow_up_date', 'status', 'signature');
}
// afisare in admin coloane cu statistici // data 24.01.2017
$crud->columns('id', 'cnp', 'last_name', 'first_name', 'No_of_PCIs', 'Completed_FU_events', 'follow_up_date', 'status', 'signature', 'admin');
$crud->field_tip('cnp', 'Personal ID No.');
$crud->field_tip('gender', 'The gender of the patient');
$crud->field_tip('height', 'Height in cm');
$crud->field_tip('weight', 'Weight in kg');
$crud->required_fields('cnp', 'first_name', 'last_name', 'admin', 'status');
$crud->field_type('gender', 'dropdown', array('Male' => 'Male', 'Female' => 'Female'));
$crud->field_type('country', 'dropdown', array('Romania' => 'Romania', 'Other' => 'Other', 'Unknown' => 'Unknown'));
$crud->set_relation('county', 'county', 'county');
$crud->set_relation('signature', 'user', 'user_name');
$crud->set_relation('admin', 'user', 'user_name');
$crud->add_action('Interventions', '', '', 'ui-icon-heart', array($this, 'go_intervention'));
$crud->add_action('Follow-Up', '', '', 'ui-icon-calculator', array($this, 'go_followup'));
$crud->callback_column('follow_up_date', array($this, '_followup'));
$crud->callback_column('Completed_FU_events', array($this, '_nofollowup'));
$crud->callback_column('No_of_PCIs', array($this, '_nointerv'));
// log- user activities
$crud->callback_after_insert(array($this, 'log_user_after_insert_patient'));
$crud->callback_after_update(array($this, 'log_user_after_update_patient'));
$crud->callback_after_delete(array($this, 'log_user_after_delete_patient'));
$crud->unique_fields('cnp');
$crud->field_type('status', 'dropdown', array('New' => 'New', 'In progress' => 'In progress', 'Finished' => 'Finished', 'Dead' => 'Dead', 'Delete' => 'Delete'));
//$extra = "info";
//$output = $crud->render($extra);
$output = $crud->render();
// $output->extra = '<h3>Pacient</h3>'; Adauga valori extra pentru view
$this->_admin_output($output);
}
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($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);
}
public function index()
{
$this->pagina_saida((object) array('output' => '', 'js_files' => array(), 'css_files' => array()));
$this->load->view('template/navbar.php');
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('cliente_produto');
$crud->set_subject('codorc');
$crud->required_fields('codorc', 'codpro');
$crud->display_as('codorc', 'Cód. Orçamento');
$crud->display_as('tiporc', 'Tipo');
$crud->display_as('numcpf', 'CPF');
$crud->display_as('plavei', 'Placa');
$crud->display_as('datent', 'Data Início');
$crud->display_as('datsai', 'Data Saída');
// $crud->columns('NomeCliente');
$crud->add_action('Smileys', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', 'demo/action_smiley');
$output = $crud->render();
$this->pagina_saida($output);
$this->load->view('template/footer');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('hotels');
$crud->set_subject('Hotels');
$agents = $this->ion_auth->get_all_agents();
$user = $this->ion_auth->user()->row();
$agents += array($user->id => $user->first_name . " " . $user->last_name);
$crud->field_type('hotel_agent_id', 'dropdown', $agents);
//var_dump($agents);
// $crud->set_relation('hotel_agent_id', 'io_users', '{first_name} {last_name}', array('active' => 1));
$crud->display_as('hotel_agent_id', 'Agent Name');
$crud->display_as('hotel_name', 'Hotel Name');
$crud->display_as('hotel_rooms', 'Rooms');
$crud->display_as('hotel_tariffs', 'Tariffs');
$crud->display_as('hotel_country', 'Country');
$crud->display_as('hotel_city', 'City');
$crud->display_as('hotel_street', 'Street');
$crud->display_as('hotel_state', 'State');
$crud->display_as('hotel_postCode', 'PostCode');
$crud->display_as('hotel_phoneNumber', 'Phone Number');
$crud->display_as('hotel_emailId', 'Email ID');
$crud->display_as('hotel_website', 'Website');
$crud->display_as('hotel_facebook', 'Facebook');
$crud->display_as('hotel_googleMap', 'Google Map');
$crud->display_as('hotel_related', 'Related Hotels');
$crud->display_as('hotel_status', 'Status');
$crud->columns('hotel_name', 'hotel_agent_id', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook', 'hotel_googleMap', 'hotel_status');
$crud->required_fields('hotel_agent_id');
$crud->field_type('hotel_stars', 'dropdown', range(0, 5));
/*
* For related hotels
* on add list all the hotels
* on edit, list all except own name
*/
$hrf = array();
if ($crud->getState() == 'edit') {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_id !=' => $crud->getStateInfo()->primary_key), 'hotel_id');
} else {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1), 'hotel_id');
}
$hrf = $this->generic_model->array_from_db($hrf, 'hotel_id, hotel_name');
$crud->field_type('hotel_related', 'multiselect', $hrf);
$crud->callback_column('hotel_image', array($this, 'set_image'));
$crud->set_field_upload('hotel_image', $this->upload_path);
$hf = $this->generic_model->get_by('hotel_facilities', array('hf_status' => 1), 'hf_id');
$hf = $this->generic_model->array_from_db($hf, 'hf_id, hf_facility');
$crud->field_type('hotel_facilities', 'multiselect', $hf);
$hrf = $this->generic_model->get_by('hotel_room_facilities', array('hrf_status' => 1), 'hrf_id');
$hrf = $this->generic_model->array_from_db($hrf, 'hrf_id, hrf_facility');
$crud->field_type('hotel_room_facilities', 'multiselect', $hrf);
$crud->unique_fields('hotel_slug');
$crud->add_action('Photo Gallery', '', 'hotels/gallery', 'ui-icon ui-icon-image');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotels', 'pagedesc' => 'Hotels', 'contenttitle' => 'Hotels List Records');
$this->load->view('gc_admin_wrapper', $data);
}
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 index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('hotels');
$crud->set_subject('Hotels');
// $crud->set_relation('hotel_agent_id', 'io_users', '{first_name} {last_name}');
$agent_id = $this->ion_auth->user()->row()->id;
$crud->where('hotel_agent_id', $agent_id);
$crud->field_type('hotel_agent_id', 'hidden', $agent_id);
// $crud->display_as('hotel_agent_id', 'Agent Name');
$crud->display_as('hotel_name', 'Hotel Name');
$crud->display_as('hotel_rooms', 'rooms');
$crud->display_as('hotel_tariffs', 'tariffs');
$crud->display_as('hotel_country', 'Country');
$crud->display_as('hotel_city', 'City');
$crud->display_as('hotel_street', 'Street');
$crud->display_as('hotel_state', 'State');
$crud->display_as('hotel_postCode', 'PostCode');
$crud->display_as('hotel_phoneNumber', 'Phone Number');
$crud->display_as('hotel_emailId', 'Email ID');
$crud->display_as('hotel_website', 'Website');
$crud->display_as('hotel_facebook', 'Facebook');
$crud->display_as('hotel_googleMap', 'GoogleMap');
$crud->display_as('hotel_status', 'Status');
$crud->columns('hotel_name', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook', 'hotel_googleMap', 'hotel_status');
$crud->callback_column('hotel_image', array($this, 'set_image'));
$crud->set_field_upload('hotel_image', $this->upload_path);
/*
* For related hotels
* on add list all the hotels
* on edit, list all except own name
*/
if ($crud->getState() == 'edit') {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_agent_id' => $this->ion_auth->get_user_id(), 'hotel_id !=' => $crud->getStateInfo()->primary_key), 'hotel_id');
} else {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_agent_id' => $this->ion_auth->get_user_id()), 'hotel_id');
}
// empty data for multiselect field generates error
if (empty($hrf)) {
$hrf = array('');
} else {
$hrf = $this->generic_model->array_from_db($hrf, 'hotel_id, hotel_name');
}
$crud->field_type('hotel_related', 'multiselect', $hrf);
$hf = $this->generic_model->get_by('hotel_facilities', array('hf_status' => 1), 'hf_id');
$hf = $this->generic_model->array_from_db($hf, 'hf_id, hf_facility');
$crud->field_type('hotel_facilities', 'multiselect', $hf);
$hrf = $this->generic_model->get_by('hotel_room_facilities', array('hrf_status' => 1), 'hrf_id');
$hrf = $this->generic_model->array_from_db($hrf, 'hrf_id, hrf_facility');
$crud->field_type('hotel_room_facilities', 'multiselect', $hrf);
$crud->add_action('Photo Gallery', '', 'agents/hotels/gallery', 'ui-icon ui-icon-image');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotels', 'pagedesc' => 'Hotels', 'contenttitle' => 'Hotels List Records', 'left_menu' => 'agents_menu');
$this->load->view('gc_admin_wrapper', $data);
}
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 article()
{
$crud = new grocery_CRUD();
$crud->set_table('blog_article');
$crud->columns('article_title', 'content', 'Categories', 'author_user_id', 'date', 'allow_comment');
$crud->edit_fields('article_title', 'article_url', 'content', 'Categories', 'date', 'author_user_id', 'allow_comment');
$crud->add_fields('article_title', 'article_url', 'content', 'Categories', 'date', 'author_user_id', 'allow_comment');
$crud->display_as('article_title', 'Title')->display_as('article_url', 'URL')->display_as('content', 'Content')->display_as('date', 'Date Created')->display_as('author_user_id', 'Author');
$crud->set_subject('Article');
$crud->callback_before_insert(array($this, 'before_insert_article'));
$crud->callback_before_update(array($this, 'before_insert_article'));
$crud->set_relation_n_n('Categories', 'blog_category_article', 'blog_category', 'article_id', 'category_id', 'category_name');
$crud->set_relation('author_user_id', 'cms_user', 'real_name');
$crud->change_field_type('author_user_id', 'hidden');
$crud->change_field_type('date', 'hidden');
$crud->change_field_type('article_url', 'hidden');
$crud->change_field_type('allow_comment', 'true_false');
$crud->add_action('Photos', base_url() . 'modules/blog/assets/images/photo.png', 'blog/photo');
$crud->add_action('Comments', base_url() . 'modules/blog/assets/images/comment.png', 'blog/comment');
$output = $crud->render();
$this->view('grocery_CRUD', $output, 'blog_article');
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('bookings');
$crud->set_subject('Bookings');
// $agents = $this->ion_auth->get_all_agents();
// $user = $this->ion_auth->user()->row();
// $agents += array($user->id => $user->first_name . " " . $user->last_name);
// $crud->field_type('hotel_agent_id', 'dropdown', $agents);
$crud->set_relation('booking_agent', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1));
$crud->set_relation('agent_id', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1));
$crud->set_relation('booking_to', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1));
$crud->display_as('agent_id', 'Agent of Hotel/Package');
$crud->display_as('booking_company_commission', 'Company Commission');
$crud->display_as('booking_status', 'Status (Change Status)');
$crud->display_as('booking_agent', 'Booked By');
// $crud->display_as('hotel_name', 'Hotel Name');
// $crud->display_as('hotel_rooms', 'Rooms');
// $crud->display_as('hotel_tariffs', 'Tariffs');
$crud->field_type('booking_ref_no', 'readonly');
$crud->field_type('paypal_transaction_id', 'readonly');
$crud->field_type('booking_agent_commission', 'readonly');
$crud->field_type('booking_company_commission', 'readonly');
$crud->field_type('booking_type', 'readonly');
$crud->field_type('booking_item_title', 'readonly');
$crud->field_type('booking_date', 'readonly');
$crud->field_type('booking_payment_type', 'readonly');
$crud->field_type('booking_total', 'readonly');
$crud->field_type('booking_agent', 'readonly');
$crud->field_type('agent_id', 'readonly');
$crud->field_type('booking_to', 'readonly');
$crud->unset_columns('booking_item', 'booking_subitem', 'booking_paymethod_tax', 'ip_address', 'booking_nights');
$crud->unset_fields('booking_item', 'booking_subitem', 'booking_paymethod_tax', 'ip_address', 'booking_nights');
$crud->where('agent_id', $this->ion_auth->get_user_id());
// $crud->columns('hotel_name', 'hotel_agent_id', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook' ,'hotel_googleMap', 'hotel_status');
// $state = $crud->getState();
//
// if($state =='list' || $state =='ajax_list')
// {
$crud->set_js("assets/frontend/js/custom_functions_sam.js");
// }
$crud->add_action('Conversation', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', '', 'ui-icon-image', array($this, '_booking_conversation'));
$crud->callback_column('booking_ref_no', array($this, '_show_invoice'));
$crud->callback_edit_field('booking_status', array($this, '_edit_field_callback'));
$crud->callback_column('booking_status', array($this, '_booking_status'));
$crud->unset_add();
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Bookings', 'pagedesc' => 'Bookings', 'contenttitle' => 'Booking List Records', 'left_menu' => 'agents_menu');
$this->load->view('gc_admin_wrapper', $data);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_table('gallery');
$crud->columns('subject', 'publish', 'creator', 'last_update');
$crud->required_fields('subject', 'publish');
$crud->callback_after_insert(array($this, 'log_user'));
$crud->callback_after_update(array($this, 'log_user'));
$crud->set_subject('Gallery Album');
$crud->fields('subject', 'deskripsi', 'publish');
$crud->add_action('Smileys', base_url() . 'assets/uploads/pictures.png', 'adminpanel/gallery/uploadPicture');
$output = $crud->render();
$data['subject'] = 'Gallery Album';
$data['content'] = $this->load->view('crud.php', $output, true);
$this->load->view('base_theme', $data);
}
public function mostrar_ciudadanos2()
{
$grocery = new grocery_CRUD();
// Asunto dependencia y direcciones del ciudada
$grocery->set_theme('bootstrap');
$grocery->set_language('spanish');
$grocery->set_table('ciudadanos');
$grocery->display_as('apellidoPa', 'Apellido Paterno');
$grocery->display_as('apellidoMa', 'Apellido Materno');
$grocery->display_as('tel1', 'Teléfono 1');
$grocery->display_as('tel2', 'Teléfono 2');
$grocery->add_action('Denuncias', '', 'ciudadanos/denuncias_por_ciudadano', 'fa fa-university');
$grocery->field_type('tel2', 'integer');
$grocery->field_type('tel1', 'integer');
$output = $grocery->render();
$this->_example_output($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);
}
function administracion()
{
if (!$this->tank_auth->is_logged_in()) {
redirect('/auth/login/');
}
try {
/* Creamos el objeto */
$crud = new grocery_CRUD();
/* Seleccionamos el tema */
// $crud->set_theme('datatables');
$crud->set_theme('flexigrid');
/* Seleccionmos el nombre de la tabla de nuestra base de datos*/
$crud->set_table('client');
/* Le asignamos un nombre */
$crud->set_subject('cliente');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('ClientID', 'Name', 'Lastname', 'IdentType', 'Ident', 'BirthDate', 'Address', 'City');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('ClientID', 'Name', 'Lastname', 'IdentType', 'Ident', 'BirthDate', 'Address', 'City', 'Phone1', 'Phone2', 'Phone3', 'Mail', 'Facebook', 'Twitter', 'Facebook', 'Skype', 'Company');
$crud->add_action('Productos', base_url() . 'assets/uploads/detalle.png', 'Product/admin_by_client');
$crud->display_as('ClientID', 'ID');
$crud->display_as('Name', 'Nombre');
$crud->display_as('Lastname', 'Apellido');
$crud->display_as('IdentType', 'Tipo Identificación');
$crud->display_as('Ident', 'Identificación');
$crud->display_as('BirthDate', 'Fecha Nacimiento');
$crud->display_as('Address', 'Dirección');
$crud->display_as('City', 'Ciudad');
$crud->display_as('Phone1', 'Teléfono 1');
$crud->display_as('Phone2', 'Teléfono 2');
$crud->display_as('Phone3', 'Teléfono 3');
$crud->display_as('Company', 'Empresa');
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en */
$this->load->view('Client/administracion', $output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
/**
* Función para contruir el Grocecy CRUD de la tabla Usuarios
*/
function abm_usuarios()
{
//Defino submenu
$this->menu['submenuSeleccionado'] = 'Usuarios';
//Creo el objeto crud
$crud = new grocery_CRUD();
//Defino Template como datatables.
//$crud->set_theme('datatables');
//Defino tabla sobre la que trabajo y tipo de 'Objeto'
$crud->set_table('Usuarios');
$crud->set_subject('Usuario');
//Agrego acción para cambiar contraseña.
$crud->add_action('Cambiar Contraseña', base_url() . 'assets/grocery_crud/themes/flexigrid/css/images/key.png', 'administracion/usuarios/cambiar_contrasena');
//Un usuario puede tener un idPersonal asociado.
$crud->set_relation('idPersonal', 'Personal', 'nombreApellido');
//Relación con los roles.
$crud->set_relation_n_n('roles', 'RolesPorUsuario', 'Roles', 'idUsuario', 'idRol', 'descripcion');
//Seteo Reglas para campos
$crud->set_rules('contrasena', 'Contraseña', 'required|matches[repetirContrasena]');
$crud->add_fields('nombreUsuario', 'contrasena', 'repetirContrasena', 'roles', 'idPersonal');
$crud->edit_fields('roles', 'idPersonal');
$crud->field_type('contrasena', 'password');
$crud->field_type('repetirContrasena', 'password');
//Seteo campos requeridos
$crud->required_fields('nombreUsuario', 'contrasena', 'repetirContrasena', 'roles');
//Defino Columnas a Mostrar
$crud->columns('nombreUsuario', 'roles');
//Defino nombres para cada campo.
$crud->display_as('nombreUsuario', 'Nombre de Usuario');
$crud->display_as('contrasena', 'Contraseña');
$crud->display_as('repetirContrasena', 'Repetir Contraseña');
$crud->display_as('roles', 'Roles');
$crud->display_as('idPersonal', 'Persona Asociada');
//Hago 'callbacks' para transformar datos antes de inserción/actualización.
$crud->callback_before_insert(array($this, '_transformar_datos'));
$crud->callback_before_update(array($this, '_transformar_datos_update'));
//Genero el ABM
$output = $crud->render();
//Llamo a la función encargada de mostrar el ABM.
mostrar_crud($output, '', $this->menu, 'administracion/usuarios/abm_usuarios', '', 'administracion/usuarios/abm_usuarios_final');
}
function abm()
{
//Creo el objeto crud
$crud = new grocery_CRUD();
//Defino tabla sobre la que trabajo y tipo de 'Objeto'
$crud->set_table('Personal');
$crud->set_subject('Empleado');
//Agrego acción para editar horarios del Personal.
$crud->add_action('Editar Horarios', base_url() . 'assets/grocery_crud/themes/flexigrid/css/images/clock.png', 'reportes-entrada-salida/personal/editar_horario');
//Quito el agregar.
$crud->unset_add();
//Quito el botones borrar.
$crud->unset_delete();
$crud->fields('nombreApellido');
//Seteo campos requeridos
$crud->required_fields('nombreApellido');
//Defino nombres para cada campo.
$crud->display_as('nombreApellido', 'Nombre y Apellido');
//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 cadastro()
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('pessoa');
$crud->set_subject('Cadastro de Cidadão');
$crud->required_fields('nome');
$crud->columns('foto_frente', 'nome', 'artigos', 'id', 'naturalidade', 'telefone_1', 'obs');
$crud->set_relation_n_n('artigos', 'artigo_has_pessoa', 'artigo', 'pessoa_id', 'artigo_id', 'artigo_penal');
$crud->set_field_upload('foto_frente', 'assets/uploads/files');
$crud->set_field_upload('foto_lado_esquerdo', 'assets/uploads/files');
$crud->set_field_upload('foto_lado_direito', 'assets/uploads/files');
$crud->set_field_upload('foto_costas', 'assets/uploads/files');
$crud->set_relation('cor_pele_id', 'cor_pele', '{nome_cor}');
$crud->unset_texteditor('tatuagens');
$crud->unset_edit_fields('cadastrado_em');
$crud->add_action('Fotos Extras', '', '', 'ui-icon-image', array($this, 'pessoa_fotos_call'));
$output = $crud->render();
$this->_example_output($output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
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);
}
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 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());
}
}
function administracion($ID = NULL, $parent_table = NULL, $fieldID = NULL, $field_show = NULL)
{
if (!$this->tank_auth->is_logged_in()) {
redirect('/auth/login/');
}
try {
/* Creamos el objeto */
$crud = new grocery_CRUD();
/* Seleccionamos el tema */
//$crud->set_theme('flexigrid');
$crud->set_theme('datatables');
/* Seleccionamos el nombre de la tabla de nuestra base de datos*/
$crud->set_table('product');
/* Le asignamos un nombre */
$crud->set_subject('Producto');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* ALA - 10/11/2015 : Condiciona invocación maestro detalle */
$state = $crud->getState();
//echo " ID = " . $ID . ", state = " . $state . ", parent_table = " . $parent_table . "FieldID = " . $fieldID;
switch ($state) {
case 'success':
if (is_numeric($ID)) {
//echo "success ID = " . $ID . ", state = " . $state;
$crud->where($fieldID, $ID);
}
$crud->set_relation('PrClientID', 'client', 'Ident');
$crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}');
break;
case 'list':
if (is_numeric($ID)) {
//echo "list ID = " . $ID . ", state = " . $state;
$crud->where($fieldID, $ID);
}
$crud->set_relation('PrClientID', 'client', 'Ident');
$crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}');
break;
case 'add':
if ($parent_table == NULL) {
$crud->set_relation('PrClientID', 'client', 'Ident');
$crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}');
} elseif ($parent_table == 'client') {
$crud->field_type('PrClientID', 'hidden', $ID);
$crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}');
} elseif ($parent_table == 'vendor') {
$crud->field_type('PrVendorID', 'hidden', $ID);
$crud->set_relation('PrClientID', 'client', 'Ident');
}
//echo "add ID = " . $ID . ", state = " . $state;
break;
case "read":
$crud->set_relation('PrClientID', 'client', 'Ident');
$crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}');
}
$crud->set_relation('PrProductCatalogID', 'productcatalog', 'Description');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('ProductID', 'PrProductCatalogID', 'Contract', 'PrClientID', 'PrVendorID', 'StartDate', 'EndDate', 'Balance');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('ProductID', 'PrProductCatalogID', 'Contract', 'PrClientID', 'PrVendorID', 'StartDate', 'EndDate', 'Balance');
$crud->display_as('ProductID', 'ID');
$crud->display_as('PrProductCatalogID', 'Producto');
$crud->display_as('Contract', 'Contrato');
$crud->display_as('PrClientID', 'Cliente');
$crud->display_as('PrVendorID', 'Vendedor');
$crud->display_as('StartDate', 'Fecha Inicio Vigencia');
$crud->display_as('EndDate', 'Fecha Fin Vigencia');
$crud->display_as('Balance', 'Saldo');
$crud->set_rules('EndDate', 'Fecha Vigencia', 'callback_ValidProd');
//http://www.grocerycrud.com/documentation/options_functions/set_rules
$crud->unset_add_fields('Balance');
$crud->unset_edit_fields('Balance');
$crud->add_action('Beneficiarios', base_url() . 'assets/uploads/detalle.png', 'Beneficiary/administracion');
$crud->add_action('Movimientos', base_url() . 'assets/uploads/money.png', 'Charge/administracion');
// Procesos posteriores a la venta
$crud->callback_after_insert(array($this, 'Process_Sale'));
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en
/applications/views/product/administracion.php */
$this->load->view('Product/administracion', $output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
//log_message($e->getMessage().' --- '.$e->getTraceAsString());
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function index()
{
try {
// General
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->set_table('sos_femme');
if (!$this->session->userdata('status')) {
$crud->where('archiver', FALSE);
}
$crud->set_subject('Femme');
//relations
$crud->set_relation('situation_familiale', 'sos_gen_situation_familiale_parrent', 'name_situation_familiale_parrent');
$crud->set_relation('detailles', 'sos_gen_situation_familiale_child', 'name_situation_familiale_child');
$crud->set_relation('emplois', 'sos_gen_emplois_parrent', 'name_emplois');
$crud->set_relation('emplois_detailles', 'sos_gen_emplois_child', 'name_emplois_detaille');
$crud->set_relation('emplois_more_detailles', 'sos_gen_emplois_child_child', 'name_emplois_child_child');
$crud->set_relation('age', 'sos_gen_femme_age', 'name_femme_age');
$crud->set_relation('duree_de_la_relation', 'sos_gen_duree_de_la_relation', 'name_duree_de_la_relation', null, 'id_duree_de_la_relation ASC');
$crud->set_relation('service', 'sos_gen_service', 'nom_service', null, 'nom_service DESC');
$crud->set_relation('ville', 'sos_gen_villes', '{nom_ville}, {code_postal}', null, 'nom_ville ASC');
$crud->set_relation('pays', 'sos_gen_pays', '{nom_pays} - {continent}', null, 'nom_pays ASC');
$crud->set_relation('nationalite', 'sos_gen_nationalite', 'name_nationalite');
$crud->set_relation('nationalite_detailles', 'sos_gen_nationalite_detailles', 'name_nationalite_detailles');
$crud->set_relation('ressources', 'sos_gen_ressources', 'name_ressources');
$crud->set_relation('provenance', 'sos_gen_provenance', 'name_provenance');
$crud->set_relation('allocations_familiales', 'sos_gen_allocations_familiales', 'name_allocations_familiales');
$crud->set_relation('percues_par', 'sos_gen_percues_par', 'name_percues_par');
$crud->set_relation('logement', 'sos_gen_logement_parent', 'name_logement');
$crud->set_relation('logement_detailles', 'sos_gen_logement_child', 'name_logement_child');
$crud->set_relation('situation_actuelle_depuis', 'sos_gen_situation_actuelle_depuis', 'name_situation_actuelle_depuis', null, 'id_situation_actuelle_depuis ASC');
$crud->set_relation('situation_actuelle', 'sos_gen_situation_actuelle', 'name_situation_actuelle');
$crud->set_relation('situation_actuelle_detailles', 'sos_gen_situation_actuelle_detailles', 'name_situation_actuelle_detailles');
$crud->set_relation('partenaire', 'sos_gen_partenaire', 'name_partenaire');
$crud->set_relation('informations', 'sos_gen_informations', 'name_informations');
$crud->set_relation('rdv', 'sos_gen_rdv', 'name_rdv');
$crud->set_relation('hebergement', 'sos_gen_hebergement', 'name_hebergement');
$crud->set_relation('departs_anterieurs', 'sos_gen_departs_anterieurs', 'name_departs_anterieurs');
$crud->set_relation('depuis', 'sos_gen_depuis', 'name_depuis');
//Master/child relations
$fields_situation_familialle = array('situation_familiale' => array('table_name' => 'sos_gen_situation_familiale_parrent', 'title' => 'name_situation_familiale_parrent', 'relate' => null), 'detailles' => array('table_name' => 'sos_gen_situation_familiale_child', 'title' => 'name_situation_familiale_child', 'id_field' => 'id_situation_familiale_child', 'relate' => 'id_parrent_from_situation_familiale_parrent', 'data-placeholder' => 'Préciser'));
$config_situation_familialle = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "situation_familialle");
$categories_situation_familialle = new gc_dependent_select($crud, $fields_situation_familialle, $config_situation_familialle);
$js_situation_familialle = $categories_situation_familialle->get_js();
$fields_nationalite = array('nationalite' => array('table_name' => 'sos_gen_nationalite', 'title' => 'name_nationalite', 'relate' => null), 'nationalite_detailles' => array('table_name' => 'sos_gen_nationalite_detailles', 'title' => 'name_nationalite_detailles', 'id_field' => 'id_nationalite_detailles', 'relate' => 'id_from_nationalite', 'data-placeholder' => 'Préciser'));
$config_nationalite = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "nationalite");
$categories_nationalite = new gc_dependent_select($crud, $fields_nationalite, $config_nationalite);
$js_nationalite = $categories_nationalite->get_js();
$fields_emplois = array('emplois' => array('table_name' => 'sos_gen_emplois_parrent', 'title' => 'name_emplois', 'relate' => null), 'emplois_detailles' => array('table_name' => 'sos_gen_emplois_child', 'title' => 'name_emplois_detaille', 'id_field' => 'id_emplois_detailles', 'relate' => 'id_from_emplois', 'data-placeholder' => 'Préciser'), 'emplois_more_detailles' => array('table_name' => 'sos_gen_emplois_child_child', 'title' => 'name_emplois_child_child', 'id_field' => 'id_emplois_child_child', 'relate' => 'id_emplois_from_child', 'data-placeholder' => 'Préciser'));
$config_emplois = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "emplois");
$categories_emplois = new gc_dependent_select($crud, $fields_emplois, $config_emplois);
$js_emplois = $categories_emplois->get_js();
$fields_ressources = array('ressources' => array('table_name' => 'sos_gen_ressources', 'title' => 'name_ressources', 'relate' => null), 'provenance' => array('table_name' => 'sos_gen_provenance', 'title' => 'name_provenance', 'id_field' => 'id_provenance', 'relate' => 'id_from_ressources', 'data-placeholder' => 'Préciser'));
$config_ressources = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "ressources");
$categories_ressources = new gc_dependent_select($crud, $fields_ressources, $config_ressources);
$js_ressources = $categories_ressources->get_js();
$fields_allocations_familiales = array('allocations_familiales' => array('table_name' => 'sos_gen_allocations_familiales', 'title' => 'name_allocations_familiales', 'relate' => null), 'percues_par' => array('table_name' => 'sos_gen_percues_par', 'title' => 'name_percues_par', 'id_field' => 'id_percues_par', 'relate' => 'id_from_allocations_familiales', 'data-placeholder' => 'Préciser'));
$config_allocations_familiales = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "allocations_familiales");
$categories_allocations_familiales = new gc_dependent_select($crud, $fields_allocations_familiales, $config_allocations_familiales);
$js_allocations_familiales = $categories_allocations_familiales->get_js();
$fields_logement = array('logement' => array('table_name' => 'sos_gen_logement_parent', 'title' => 'name_logement', 'relate' => null), 'logement_detailles' => array('table_name' => 'sos_gen_logement_child', 'title' => 'name_logement_child', 'id_field' => 'id_logement_child', 'relate' => 'id_from_logement_parent', 'data-placeholder' => 'Préciser'));
$config_logement = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "logement");
$categories_logement = new gc_dependent_select($crud, $fields_logement, $config_logement);
$js_logement = $categories_logement->get_js();
$fields_situation_actuelle = array('situation_actuelle' => array('table_name' => 'sos_gen_situation_actuelle', 'title' => 'name_situation_actuelle', 'relate' => null), 'situation_actuelle_detailles' => array('table_name' => 'sos_gen_situation_actuelle_detailles', 'title' => 'name_situation_actuelle_detailles', 'id_field' => 'id_situation_actuelle_detailles', 'relate' => 'id_from_situation_actuelle', 'data-placeholder' => 'Préciser'));
$config_situation_actuelle = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "situation_actuelle");
$categories_situation_actuelle = new gc_dependent_select($crud, $fields_situation_actuelle, $config_situation_actuelle);
$js_situation_actuelle = $categories_situation_actuelle->get_js();
//Visual
if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') {
$crud->columns('prenom', 'nom', 'nom_marital', 'age', 'date_naissance', 'telephone', 'ville', 'nombre_denfants', 'ouvertures', 'premier_contact', 'nombre_passages');
} else {
$crud->columns('archiver', 'prenom', 'nom', 'nom_marital', 'age', 'date_naissance', 'telephone', 'ville', 'nombre_denfants', 'ouvertures', 'premier_contact', 'nombre_passages');
}
$crud->display_as('pays', 'Originaire de')->display_as('archiver', 'Archivage')->display_as('prenom', 'Prénom')->display_as('telephone', 'Téléphone')->display_as('nationalite', 'Nationalité')->display_as('rue', 'Adresse')->display_as('oriente_par_SMS', 'Orientée par SMS')->display_as('departs_anterieurs', 'Départs antérieurs')->display_as('nationalite_detailles', 'Situation administrative')->display_as('detailles', 'Situation familiale en détail')->display_as('duree_de_la_relation', 'Durée de la relation')->display_as('emplois_detailles', 'Détails de l\'emploi')->display_as('emplois_more_detailles', 'Plus de détails de l\'emploi')->display_as('ouvertures', 'Dernière modification')->display_as('hebergement', 'Demande d\'hébergement')->display_as('aide_materielle', 'Demande d\'aide matérielle')->display_as('accompagnement_exterieur', 'Demande d\'accompagnement extérieur')->display_as('adresse_postale', 'Demande d\'adresse postale')->display_as('accueil', 'Demande d\'accueil')->display_as('informations', 'Demande d\'informations')->display_as('conseil', 'Demande de conseil')->display_as('orientation', 'Demande d\'orientation')->display_as('rdv', 'Demande de rdv')->display_as('hebergement', 'Demande d\'hébergement')->display_as('logement_dem', 'Demande de logement')->display_as('logement_detailles', 'Logement détaillé')->display_as('situation_actuelle_detailles', 'Situation actuelle détaillée')->display_as('emplois', 'Situation professionnelle')->display_as('emplois_detailles', 'Situation professionnelle détaillée')->display_as('emplois_more_detailles', 'Autres infos emploi')->display_as('percues_par', 'Perçues par')->display_as('commentaire', 'Commentaires')->display_as('partenaire', 'Orienteur')->display_as('nombre_passages', 'Nombre passages')->display_as('arrivee_en_france', 'Arrivée en France')->display_as('parle_pas_francais', 'Parle pas français')->display_as('ism', 'Utilisation ISM');
$crud->order_by('prenom', 'asc');
//unsets
if ($this->session->userdata('status') == '1' or $this->session->userdata('status') == '2' or $this->session->userdata('status') == '3') {
$crud->unset_edit_fields('service', 'par', 'archiver');
} else {
$crud->unset_edit_fields('service', 'premier_contact', 'par');
}
$crud->unset_add_fields('par', 'archiver');
if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') {
$crud->unset_delete();
$crud->unset_export();
$crud->unset_print();
}
//Requireds
$crud->required_fields('service', 'premier_contact', 'prenom');
//Callbacks
$crud->callback_column('ouvertures', array($this, 'ouvertures'));
$crud->callback_column('premier_contact', array($this, 'premier_contact'));
$crud->callback_column('nombre_denfants', array($this, 'enfants'));
$crud->callback_after_update(array($this, 'insert_after_update'));
$crud->callback_after_insert(array($this, 'insert_after_insert'));
$crud->callback_after_delete(array($this, 'after_delete'));
$crud->callback_column('archiver', array($this, 'archiver'));
$crud->callback_column('nombre_passages', array($this, 'nombre_passages'));
$crud->callback_before_update(array($this, 'before_update'));
//field Types
$crud->field_type('enceinte', 'dropdown', array('1' => '1 mois', '2' => '2 mois', '3' => '3 mois', '4' => '4 mois', '5' => '5 mois', '6' => '6 mois', '7' => '7 mois', '8' => '8 mois', '9' => '9 mois'));
$crud->field_type('dettes', 'enum', array('OUI', 'NON'));
$crud->field_type('arrivee_en_france', 'dropdown', range(date("Y"), date("Y") - 50));
$crud->field_type('parle_pas_francais', 'enum', array('OUI', 'NON'));
$crud->field_type('ism', 'multiselect', array("1" => "Ponctuel", "2" => "Systématique", "3" => "Venu physiquement"));
// Actions
$crud->add_action('Enfants', '', 'kids/kids_window', 'ui-icon-person');
$crud->add_action('Intervention', '', 'demande/demande_window', 'ui-icon-home');
$crud->add_action('Profil', '', 'show/show_window', 'ui-icon-print');
$crud->add_action('Violences', '', 'violence/violence_window', 'ui-icon-alert');
$crud->add_action('Démarches', '', 'demarche/demarche_window', 'ui-icon-gear');
if ($this->session->userdata('status') != '0') {
$crud->add_action('Psy', '', 'psy/psy_window', 'ui-icon-comment');
}
$crud->add_action('Documents', '', 'upload/upload_window', 'ui-icon-document');
// Renders
$output = $crud->render();
$output->output .= $js_situation_familialle . $js_emplois . $js_nationalite . $js_ressources . $js_allocations_familiales . $js_logement . $js_situation_actuelle;
$menu = new stdClass();
$menu->n0 = true;
$menu->status = $this->session->userdata('status');
$header = $this->navigation->home_f($menu);
$data = array('output' => $output, 'header' => $header);
$this->_example_output($data);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
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 transfer_order()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('transfer_order');
$crud->columns('pickup_location', 'pickup_destination', 'price', 'order_status');
$crud->add_action('Complete', '', 'manage/complete_order', 'ui-icon-check');
$crud->set_relation('car_type', 'car_type', 'type_name');
$crud->set_relation('car_model', 'our_fleet', 'car_name');
$crud->set_relation('user', 'users', 'Username :- {username} <br>Email Address :- {email}');
$crud->unset_add();
$crud->unset_edit();
$output = $crud->render();
$this->_example_output($output);
}
public function category($action = null, $id_product_category = null)
{
$this->session->set_userdata('selected_table', 'product_category');
$crud = new grocery_CRUD();
if (!empty($id_product_category) && is_numeric($id_product_category) && $action == 'parent') {
$crud->where('parent', $id_product_category)->unset_add()->unset_edit()->unset_delete();
} else {
$crud->add_action('Lihat Sub Produk Kategori', '', '', 'read-icon', array($this, 'addSubCategoryAction'));
}
$crud->set_table('product_category')->columns('category', 'parent', 'note')->fields('category', 'parent', 'note')->required_fields('category')->display_as('category', 'Nama Kategori')->display_as('parent', 'Parent Kategori')->display_as('note', 'Keterangan')->callback_field('note', array($this, 'setTextarea'))->callback_field('parent', array($this, 'categoryParentField'))->callback_column('parent', array($this, 'categoryParentName'))->unset_read()->unset_delete();
$output = $crud->render();
$this->parser->parse('category.tpl', $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);
}
