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);
}
