public function crud() { $crud = new grocery_CRUD(); $crud->set_theme(THEMA_CRUD); $crud->set_table('usuario'); $crud->set_subject('Usuarios'); $crud->required_fields('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id'); $crud->columns('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id'); $crud->edit_fields('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id'); $crud->add_fields('nome', 'login', 'email', 'tipo_usuario_id'); $crud->set_relation('tipo_usuario_id', 'tipo_usuario', 'descricao'); $crud->set_relation('situacao_id', 'situacao', 'descricao'); $crud->callback_insert(array($this, 'create')); $crud->callback_delete(array($this, 'delete')); $crud->callback_update(array($this, 'update')); $crud->where('situacao_id', 1); $crud->or_where('situacao_id', 2); $contents = $crud->render(); // $this->load->view('template_crud', $contents); $this->template->set('titulo', 'Manter Usuário'); $this->template->set('subtitle', 'Usuário'); // nome do template , nome da view $this->template->load('template_teste', 'crudpage', $contents); }
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 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); }
function patients() { $drp = $this->session->userdata('user_type'); //primesc data din calendar $day_get = $_GET["day"]; // setez data din calendar variabila sesiune // $this->session->set_userdata('data_cal',$_GET['data']); $ids_ui_ses = $this->session->userdata('ids_ui'); $date_cal = array(96, 95, 89); // var_dump($date_cal); // echo "<br>"; // var_dump($ids_ui_ses); // print_r($day_get); //die(); $crud = new grocery_CRUD(); $crud->set_theme('datatables'); //nu merge cu asta //$crud->or_where('productName','Car'); //$id = 95; $crud->set_table('patients'); $crud->set_subject('Patient'); foreach ($ids_ui_ses as $key => $id) { $pat_fup = $this->date_followup($id); $zi_fup = $this->day($pat_fup); // extrag luna si anul din data follow-up-lui pentru cumparare $luna_fup = $this->month($pat_fup); // formatez ziua pentru afisare in calendar $zi_fup = $this->good_day($zi_fup); if ($zi_fup == $day_get) { $crud->or_where('patients.id', $id); } } //$crud->or_where('patients.id', $id); // aici pun filtrele pt admin //$crud->where('admin',1); $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', 'Delete' => 'Delete')); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); //$extra = "info"; //$output = $crud->render($extra); $output = $crud->render(); // $output->extra = '<h3>Pacient</h3>'; Adauga valori extra pentru view $this->_admin_output($output); }