public function listadoEdas()
{
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$dist = $this->frontend_model->listarDistritos();
$ubigeo = array();
foreach ($dist as $dato) {
$ubigeo[$dato->ubigeo] = $dato->nombre;
}
$est = $this->frontend_model->listaEstablec();
$establec = array();
foreach ($est as $dato) {
$establec[$dato->cod_est] = $dato->raz_soc;
}
$filtro = array();
$this->input->post('diresa') ? $filtro['sub_reg_nt'] = $this->input->post('diresa') : '';
$this->input->post('redes') ? $filtro['red'] = $this->input->post('redes') : '';
$this->input->post('microred') ? $filtro['microred'] = $this->input->post('microred') : '';
$this->input->post('establec') ? $filtro['e_salud'] = $this->input->post('establec') : '';
$this->input->post('departamento') ? $filtro['substr(ubigeo,1,2)'] = $this->input->post('departamento') : '';
$this->input->post('provincia') ? $filtro['substr(ubigeo,1,4)'] = $this->input->post('provincia') : '';
$this->input->post('distrito') ? $filtro['ubigeo'] = $this->input->post('distrito') : '';
$this->input->post('ano') ? $filtro['ano'] = $this->input->post('ano') : '';
$this->input->post('semana') ? $filtro['semana'] = $this->input->post('semana') : '';
$crud = new grocery_CRUD();
$crud->set_theme("datatables");
$crud->set_table('edas');
$crud->columns('ano', 'semana', 'sub_reg_nt', 'e_salud', 'ubigeo', 'daa_c1', 'daa_c1_4', 'daa_c5', 'dis_c1', 'dis_c1_4', 'dis_c5');
$crud->display_as('ano', 'Año')->display_as('e_salud', 'Establecimiento')->display_as('sub_reg_nt', 'Diresa');
$crud->field_type('sub_reg_nt', 'dropdown', $subr);
$crud->field_type('e_salud', 'dropdown', $establec);
$crud->field_type('ubigeo', 'dropdown', $ubigeo);
if ($this->input->post()) {
if ($this->session->userdata('institucion') == 'A') {
$crud->where($filtro);
} else {
$crud->where($filtro);
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
} else {
$crud->where(array('ano' => date('Y')));
switch ($this->session->userdata('nivel')) {
case 4:
$accesar = $this->session->userdata('equipo');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
break;
case 5:
$accesar = $this->session->userdata('diresa');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar));
} else {
$crud->where(array('sub_reg_nt' => $accesar));
}
break;
case 6:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1));
}
break;
case 7:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$accesar2 = $this->session->userdata('microred');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
}
break;
case 8:
$accesar = $this->session->userdata('establecimiento');
$crud->where(array('e_salud' => $accesar));
break;
}
}
$crud->limit(1000);
$crud->order_by('semana', 'DESC');
$crud->set_subject('Atenciones');
$crud->unset_add();
$crud->unset_read();
$crud->unset_edit();
$crud->unset_export();
$crud->unset_print();
$crud->callback_after_delete(array($this, 'log_usuario_before_delete'));
$crud->add_action('Editar', '', 'edas/modEdas', 'ui-icon-pencil');
///////////////////////////////////////////////////////////////////////////////
//$crud->add_action_peru('Añadir EDAS', '', 'regEdas','add-icon');
///////////////////////////////////////////////////////////////////////////////
$output = $crud->render();
$this->_example_output1($output);
}
public function 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 members($start = 0, $end = 500)
{
$this->check_permission('admin');
$crud = new grocery_CRUD();
$crud->set_table('members');
$crud->set_theme('datatables');
$crud->columns('member_id', 'firstname', 'lastname', 'pt_test', 'mains_test', 'material', 'interview');
$crud->set_relation('optional_1', 'subjects', '{subject_id}-{subject_name}', null, 'subject_id');
$crud->set_relation('optional_2', 'subjects', '{subject_id}-{subject_name}', null, 'subject_id');
$crud->set_relation_n_n('mains_test', 'packages_students', 'mains_tests_packages', 'member_id', 'package_id', 'package_name');
$crud->set_relation_n_n('material', 'material_package_student', 'material_package', 'member_id', 'package_id', 'package_name');
$crud->set_relation_n_n('interview', 'interview_student', 'interview_packages', 'member_id', 'package_id', 'package_name');
$crud->set_relation_n_n('pt_test', 'pt_packages_students', 'pt_tests_packages', 'member_id', 'package_id', 'package_name');
$crud->set_relation('status', 'membership_status', '{status_id}-{status_name}');
$crud->set_relation('country_pr', 'country', '{name}', null, 'name asc');
$crud->set_relation('state_pr', 'state', '{name}', null, 'name asc');
//$crud->set_relation('city_pr', 'city','{name}-{state}',null,'name asc');
$crud->set_relation('country_pm', 'country', '{name}', null, 'name asc');
$crud->set_relation('state_pm', 'state', '{name}', null, 'name asc');
// $crud->set_relation('city_pm', 'city','{name}-{state}',null,'name asc');
$crud->set_relation('last_university', 'university', '{name}', null, 'name asc');
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_after_insert(array($this, 'new_registration_email'));
//$crud->callback_before_update(array($this,'encrypt_password_callback'));
//$crud->add_fields('firstname');
$crud->fields('member_id', 'firstname', 'lastname');
$crud->add_fields('firstname', 'lastname', 'login', 'passwd', 'mains_test', 'material', 'interview', 'pt_test', 'dob', 'sex', 'qualification', 'last_university', 'about', 'designation', 'fathers_name', 'fathers_occupation', 'country_pr', 'state_pr', 'city_pr', 'pincode_pr', 'street_pr', 'country_pm', 'state_pm', 'city_pm', 'pincode_pm', 'street_pm', 'telephone_local', 'telephone_permanent', 'previous_attempts_count', 'previous_attempts_details', 'optional_1', 'optional_2', 'medium', 'status', 'time', 'mode', 'centre', 'payment_details', 'photo', 'fee_balance', 'fee_date', 'fee_comment', 'idproof');
$crud->edit_fields('member_id', 'firstname', 'lastname', 'priority', 'login', 'mains_test', 'material', 'interview', 'pt_test', 'dob', 'sex', 'qualification', 'last_university', 'about', 'designation', 'fathers_name', 'fathers_occupation', 'country_pr', 'state_pr', 'city_pr', 'pincode_pr', 'street_pr', 'country_pm', 'state_pm', 'city_pm', 'pincode_pm', 'street_pm', 'telephone_local', 'telephone_permanent', 'previous_attempts_count', 'previous_attempts_details', 'optional_1', 'optional_2', 'medium', 'status', 'time', 'mode', 'centre', 'payment_details', 'photo', 'fee_balance', 'fee_date', 'fee_comment', 'instruction', 'idproof');
$crud->set_field_upload('photo', 'assets/uploads/files/registration');
$crud->set_field_upload('idproof', 'assets/uploads/files/registration');
//$crud->set_field_upload('payment_slip','assets/uploads/files/registration');
$crud->add_action('schedule', '../../images/clock.jpg', 'admin/personal_schedule');
$crud->add_action('Change Password', '../../images/rp.jpg', 'admin/pwd_reset/edit');
//$crud->where('member_id >= ',$start);
//$crud->where('member_id <= ',$end);
if (isset($_POST['search'])) {
$crud->like('firstname', $_POST['search']);
$crud->or_like('lastname', $_POST['search']);
$crud->or_like('login', $_POST['search']);
$crud->or_like('member_id', $_POST['search']);
}
$crud->limit(100, 0);
$crud->unset_print();
$crud->unset_export();
//$crud->unset_add();
// $crud->unset_edit();
$crud->unset_delete();
$output = $crud->render();
$this->_example_output($output);
}
