public function daftar()
{
$crud = new grocery_CRUD();
//$crud->set_table('permohonan');
$crud->set_table('vtdp');
$crud->set_subject('Data Permohonan Izin TDP');
$crud->columns('no_agenda', 'nosk', 'perusahaan', 'tglpermohonan', 'status', 'catatan_bo', 'lama_proses');
$crud->set_primary_key('id', 'vtdp');
//$crud->set_relation_n_n('perusahaan', 'tdp','perusahaan','permohonan_id','perusahaan_id','nama');
//$crud->set_relation('spermohonan_id', 'spermohonan','status');
$crud->display_as('no_agenda', 'No.Agenda');
$crud->display_as('nosk', 'No.SK');
$crud->display_as('perusahaan', 'Nama Perusahaan');
$crud->display_as('lama_proses', 'Lama Proses');
$crud->add_action('Hapus Data', '', site_url() . '/tdp/simpen_hapus', 'delete-icon');
$crud->add_action('Edit Data', '', site_url() . '/tdp/ubah', 'edit-icon');
$crud->add_action('Ubah Status Pemrosessan Data', '', 'tdp', 'proses-icon');
$crud->add_action('Cetak Tanda Bukti', '', 'tdp/cetak_sk', 'tbukti-icon', '', 'penerimaan', 'bap', 'bukti');
$crud->add_action('Cetak SK', '', 'tdp/cetak_sk', 'sk-icon', '', 'sk', 'skatas');
$crud->where('ijin_id', '6');
$crud->order_by('tglpermohonan desc,id desc,perusahaan', 'desc');
$crud->unset_export();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_read();
$crud->set_crud_url_path(site_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), site_url(strtolower(__CLASS__)));
$output = $crud->render();
$this->load->view('home.php');
$this->load->view('vtdp_daftar.php', $output);
}
public function index()
{
try {
// General
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->set_table('sos_gen_frequence');
$crud->set_subject('Fréquence');
//relations
//Master/child relations
//Visual
$crud->columns('name_frequence');
$crud->display_as('name_frequence', 'Fréquence');
$crud->order_by('name_frequence', 'desc');
//unsets
//Requireds
$crud->required_fields('name_frequence');
//Callbacks
//field Types
// Actions
// Renders
$output = $crud->render();
$menu = new stdClass();
$menu->n1 = true;
$menu->lien3_3_1 = false;
$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 alamat()
{
$crud = new grocery_CRUD();
$crud->set_theme('twitter-bootstrap');
$crud->set_table('alamat');
$crud->order_by('id', 'desc');
$output = $crud->render();
$this->_example_output($output);
}
public function listar_transito()
{
/*$establecimiento = $this->mantenimiento_transito->listarEstablecimiento();
foreach($establecimiento as $dato){
$est[$dato->cod_est] = $dato->raz_soc;
} */
$crud = new grocery_CRUD();
//$crud->set_theme('bootstrap');
$crud->set_table('trans_lesacctra');
$crud->columns('id', 'ano', 'ap_nm1', 'ap_nm2', 'nom_les', 'edad', 'tipo_edad', 'diresa', 'eess');
$crud->set_subject('Ficha Transito');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('cod_eess' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
//$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red' and microred = '$microred')";
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
//$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red')";
$where = array('red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
//$crud->field_type('establec', 'dropdown', $est);
$crud->display_as("id", "ID")->display_as("ano", "AÑO")->display_as("ap_nm1", "APELLIDO PATERNO")->display_as("ap_nm2", "APELLIDO MATERNO")->display_as("nom_les", "NOMBRES")->display_as("edad", "EDAD")->display_as("tipo_edad", "TIPO")->display_as("diresa", "DIRESA")->display_as("eess", "ESTABLECIENTO DE SALUD");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_print();
$crud->unset_export();
$crud->unset_delete();
$crud->order_by('id', 'desc');
$crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulotransito/borrarFichatransito', 'borrar-icon');
$crud->add_action('Vista previa', '', 'modulotransito/ver_ficha_transito', 'read-icon');
$crud->add_action('Editar Ficha Transito', '', 'modulotransito/modificacion_transito', 'edit-icon');
$output = $crud->render();
$usuario = $this->session->userdata("usuario");
$accion = 'Listar Casos Accidentes de Transito';
$this->login_model->auditoriaOperador($usuario, $accion);
$this->layout->view('listar_transito', $output);
}
public function index()
{
$anio = array();
for ($i = 2000; $i <= 2020; $i++) {
$anio[$i] = $i;
}
$crud = new grocery_CRUD();
$crud->set_table('student');
$crud->columns('registroId', 'ano', 'datos', 't');
$crud->order_by('ano', 'asc');
$crud->display_as('registroId', 'Item')->display_as('ano', 'Año')->display_as('registroId', 'Item');
$crud->set_subject('Datos');
$crud->field_type('ano', 'dropdown', $anio);
$output = $crud->render();
$this->_example_output($output);
}
public function index($log_type = NULL)
{
$this->load->model('shared/log_model');
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_character_limiter', 0);
$crud = new grocery_CRUD();
if ($crud->getState() == 'list') {
// get all known log types
$log_types = $this->log_model->get_log_types();
$this->views['content'] = $this->load->view('admin/log/action_selector', array('log_types' => $log_types, 'selected_log_type' => $log_type), TRUE);
$this->javascript[] = $this->load->view('admin/log/js/action_selector.js', NULL, TRUE);
}
if (!is_null($log_type) && $log_type != 'ajax_list' && $log_type != 'export' && $log_type != 'print' && $log_type != 'ajax_list_info') {
$crud->where(array('action' => $log_type));
$crud->unset_columns('action');
}
$crud->set_theme('bootstrap');
$crud->set_table('log');
$crud->set_subject('Logs');
// Op twee velden orderen. Grocerycrud houd zich niet aan de Codeigniter active record
// maar dit werkt.
$crud->order_by('date_created desc, id', 'desc');
$crud->columns('date_created', 'action', 'message', 'user_id');
$crud->set_relation('user_id', 'user', 'screen_name');
$crud->display_as('user_id', 'Gebruiker');
$crud->display_as('date_created', 'Tijd');
$crud->display_as('action', 'Actie');
$crud->display_as('message', 'Bericht');
$crud->display_as('ip_hash', 'IP-hash');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
// render the crud HTML
$crud_output = $crud->render();
//get the needed css and javascript files
$this->javascript_files = $crud->get_js_files();
$this->css_files = $crud->get_css_files();
if (isset($this->views['content'])) {
$this->views['content'] .= $crud_output->output;
} else {
$this->views['content'] = $crud_output->output;
}
$this->_layout();
}
public function index()
{
$array = $this->mapas_model->obtenerIndividual();
$k = 0;
foreach ($array as $valor) {
$datos[$valor->cie_10] = $valor->diagno;
$k++;
}
$crud = new grocery_CRUD();
$crud->set_table('estratos');
$crud->columns('id', 'enfermedad', 'semana', 'estrato_1', 'estrato_2', 'estrato_3', 'estrato_4', 'estrato_5', 'tipo', 'habitantes');
$crud->order_by('id,enfermedad', 'asc');
$crud->display_as('id', 'from estratos')->display_as('id', 'Item');
$crud->set_subject('Estrato');
$crud->field_type('enfermedad', 'dropdown', $datos);
$crud->field_type('tipo', 'dropdown', array('1' => 'Casos', '2' => 'Incidencia', '3' => 'Estrat. Casos'));
$output = $crud->render();
$this->_example_output($output);
}
public function index()
{
try {
// General
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->set_table('sos_utilisateur');
$crud->set_subject('Utilisateurs');
//relations
//Master/child relations
//Visual
$crud->columns('nom_utilisateur', 'prenom_utilisateur', 'identifiant_utilisateur', 'motdepass_utilisateur', 'status', 'titre');
$crud->display_as('nom_utilisateur', 'Nom')->display_as('prenom_utilisateur', 'Prénom')->display_as('identifiant_utilisateur', 'Id')->display_as('motdepass_utilisateur', 'Mot de pass');
$crud->order_by('prenom_utilisateur', 'desc');
//unsets
//Requireds
$crud->required_fields('identifiant_utilisateur', 'motdepass_utilisateur', 'status');
//Callbacks
//field Types
$crud->field_type('status', 'dropdown', array('0' => 'Utilisateur', '1' => 'Super Administrateur', '2' => 'Administrateur', '3' => 'Web Master', '4' => 'Psychologue', '5' => 'Ecoute téléphonique'));
// Actions
if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '2' or $this->session->userdata('status') == '4' or $this->session->userdata('status') == '5') {
$crud->unset_delete();
}
// Renders
$output = $crud->render();
$menu = new stdClass();
$menu->n1 = true;
$menu->lien3_7 = false;
$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 index()
{
try {
// General
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->set_table('sos_editor');
$crud->set_subject('Ecrit');
//relations
//Master/child relations
//Visual
$crud->columns('abrev', 'file_url', 'type');
$crud->display_as('file_url', 'Ecrits');
$crud->field_type('type', 'dropdown', array('1' => 'Attestation', '2' => 'Rapport'));
$crud->display_as('abrev', 'Description');
$crud->order_by('abrev', 'desc');
$crud->set_field_upload('file_url', 'assets/uploads/models');
//unsets
//Requireds
$crud->required_fields('abrev', 'file_url', 'type');
//Callbacks
//field Types
// Actions
// Renders
$output = $crud->render();
$menu = new stdClass();
$menu->n1 = true;
$menu->lien3_1_8 = false;
$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 quicklink()
{
$crud = new grocery_CRUD();
$crud->set_table('cms_quicklink');
$crud->set_subject('Quick Link');
$crud->columns('navigation_id');
$crud->edit_fields('navigation_id');
$crud->add_fields('navigation_id');
$crud->display_as('navigation_id', 'Navigation Name');
$crud->order_by('index', 'asc');
$crud->set_relation('navigation_id', 'cms_navigation', 'navigation_name');
$crud->callback_before_insert(array($this, 'before_insert_quicklink'));
$output = $crud->render();
$this->view('grocery_CRUD', $output, 'main_quicklink_management');
}
public function kegiatan_lama()
{
$status = $this->input->get("status");
$crud = new grocery_CRUD();
$crud->where("tbl_kegiatan_transaksi.status", "Lama");
$crud->set_table('tbl_kegiatan_transaksi');
$crud->set_subject('Kegiatan Lama');
$crud->set_relation('change_by', 'tbl_user', 'email');
$crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}');
$crud->set_relation('id_kegiatan_butir', 'view_kegiatan_butir', '{unsur} - {subunsur} - {butir}');
$crud->set_primary_key('id_kegiatan_butir', 'view_kegiatan_butir');
$crud->required_fields('tanggal_kegiatan', 'tanggal_kegiatan_selesai');
$crud->fields('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'status', 'change_by', 'change_date');
$crud->columns('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'status');
$crud->display_as("id_kegiatan_butir", "Butir Kegiatan")->display_as("tanggal_kegiatan", "Tanggal Mulai")->display_as("tanggal_kegiatan_selesai", "Tanggal Selesai")->display_as("id_user", "Oleh")->display_as("change_date", "Tanggal")->display_as("id_periode", "Periode")->display_as("id_kegiatan_jabatan", "Bertindak Sebagai");
$crud->callback_add_field('id_user', array($this, '_form_get_user_callback'));
$crud->callback_edit_field('id_user', array($this, '_form_get_user_callback'));
$crud->callback_add_field('status', array($this, '_kegiatan_lama_get_status_callback'));
$crud->callback_edit_field('status', array($this, '_kegiatan_lama_get_status_callback'));
$crud->callback_before_update(array($this, 'get_change_by_callback'));
$crud->callback_before_insert(array($this, 'get_change_by_callback'));
$crud->callback_field('change_date', array($this, 'format_date_callback'));
$crud->change_field_type('id_user', 'readonly');
$crud->change_field_type('change_by', 'readonly');
$crud->change_field_type('change_date', 'readonly');
$crud->add_action('Unggah Bukti', '', 'pegawai/daftar_kegiatan_berkas', 'fa fa-upload');
$crud->unset_read();
$crud->order_by('id_kegiatan_transaksi', 'desc');
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_pegawai', $output);
}
public function listadoNotificacion()
{
if ($this->session->userdata('nivel') != 5 or $this->session->userdata('institucion') != 'A') {
$this->session->set_flashdata('error', 'Su nivel de usuario no le permite realizar este proceso');
redirect(site_url("index/principal"), 301);
}
$anio = array();
for ($i = date("Y") - 1; $i <= date("Y"); $i++) {
$anio[$i] = $i;
}
$semanas = array();
for ($i = 1; $i <= 53; $i++) {
$semanas[$i] = $i;
}
$usuario = $this->session->userdata('usuario');
$carpeta = getcwd() . "/uploads/" . $usuario . "/";
if (!file_exists($carpeta)) {
mkdir(getcwd() . "/uploads/" . $usuario, 0777);
}
$subr = $this->frontend_model->mostrarDiresa($this->session->userdata('diresa'));
$subregion = array();
foreach ($subr as $dato) {
$subregion[$dato->codigo] = $dato->nombre;
}
$rd = $this->frontend_model->buscarRedes($this->session->userdata('diresa'));
$red = array();
foreach ($rd as $dato) {
$red[$dato->codigo] = $dato->nombre;
}
$mrd = $this->frontend_model->buscaMicroredes($this->session->userdata('diresa'));
$microred = array();
foreach ($mrd as $dato) {
$microred[$dato->codigo] = $dato->nombre;
}
$crud = new grocery_CRUD();
$crud->set_table('telematica');
$crud->columns('ano', 'semana', 'diresa', 'red', 'microred', 'establecimiento', 'archivo', 'usuario', 'fecha', 'enviado');
$crud->fields('ano', 'semana', 'diresa', 'red', 'microred', 'establecimiento', 'archivo');
$crud->display_as('ano', 'Año');
$crud->display_as('enviado', 'Estado');
$crud->field_type('ano', 'dropdown', $anio);
$crud->field_type('semana', 'dropdown', $semanas);
$crud->field_type('diresa', 'dropdown', $subregion);
$crud->field_type('red', 'dropdown', $red);
//$crud->field_type('microred','dropdown',$microred);
$crud->field_type('enviado', 'dropdown', array('1' => 'Notificado', '2' => 'Pendiente'));
//$crud->where(array('ano'=>date('Y')));
$crud->where(array('diresa' => $this->session->userdata('diresa')));
$crud->order_by('ano', 'DESC');
$crud->set_subject('Notificación');
$crud->set_field_upload('archivo', 'uploads/' . $usuario);
$crud->unset_add();
$crud->unset_read();
//$crud->unset_delete();
$crud->unset_edit();
$crud->unset_export();
$crud->callback_after_insert(array($this, 'log_usuario_after_insert'));
///////////////////////////////////////////////////////////////////////////////
$crud->add_action_peru('Añadir Notificación', '', 'pntRegistro', 'add-icon');
///////////////////////////////////////////////////////////////////////////////
//$crud->add_action('Añadir información', base_url().'public/images/telematica.gif', 'pnt/adicionar','');
$crud->add_action('Efectuar notificación', base_url() . 'public/images/contact.png', 'pnt/envio', '');
$output = $crud->render();
$this->_example_output1($output);
}
public function persutujuan_daftar_kegiatan_berkas()
{
try {
$crud = new grocery_CRUD();
$state = $crud->getState();
$id_kegiatan_transaksi = $this->uri->segment(3);
$crud->where('id_kegiatan_transaksi', $id_kegiatan_transaksi);
$crud->set_table('tbl_kegiatan_transaksi_berkas');
$crud->set_subject('Daftar Berkas Pegawai');
$crud->set_field_upload('berkas', 'assets/uploads/berkas');
$crud->fields('no', 'judul', 'berkas', 'keterangan');
$crud->columns('no', 'judul', 'berkas', 'keterangan');
$crud->order_by('id_kegiatan_transaksi_berkas', 'desc');
//$crud->change_field_type('nama_depan', 'readonly');
$crud->unset_save();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_delete();
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_pegawai', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function irasCampos()
{
if (empty($this->session_id)) {
redirect(site_url("index/login"), 301);
}
$reporta = array('ano' => date('Y'), 'semana' => date('W') - 2);
$this->reportes_model->registraCalidad($reporta);
$this->calidad_model->edasCampos();
$crud = new grocery_CRUD();
$crud->set_table('irasDefunciones');
$crud->columns('ano', 'semana', 'sub_reg_nt', 'red', 'microred', 'e_salud', 'ubigeo', 'ira_m2', 'ira_2_11', 'ira_1_4a', 'neu_2_11', 'neu_1_4a', 'ngr_m2', 'ngr_2_11', 'ngr_1_4a');
$crud->display_as('ano', 'Año');
switch ($this->session->userdata('nivel')) {
case 4:
$accesar = $this->session->userdata('equipo');
break;
case 5:
$accesar = $this->session->userdata('diresa');
$crud->or_where(array('sub_reg_nt' => $accesar));
break;
case 6:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1));
break;
case 7:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$accesar2 = $this->session->userdata('microred');
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
break;
case 8:
$accesar = $this->session->userdata('establecimiento');
$crud->where(array('e_salud' => $accesar));
break;
}
$crud->order_by('semana');
$crud->unset_add();
$crud->unset_read();
$crud->unset_edit();
//$crud->unset_delete();
//$crud->unset_export();
$crud->unset_print();
$crud->add_action('Editar', '', 'calidad/modIras', 'edit-icon');
$crud->callback_after_delete(array($this, 'log_iras_registro_after_delete'));
$output = $crud->render();
$this->layout->view('irasCampos.php', $output);
}
public function listadoIndividual()
{
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$dist = $this->frontend_model->listarDistritos();
$ubigeo = array();
foreach ($dist as $dato) {
$ubigeo[$dato->ubigeo] = $dato->nombre;
}
$enf = $this->frontend_model->mostrarDiagnostico();
$enfermedad = array();
foreach ($enf as $dato) {
$enfermedad[$dato->cie_10] = $dato->diagno;
}
$tdx = $this->frontend_model->mostrarTipo();
$tipoDx = array();
foreach ($tdx as $dato) {
$tipoDx[$dato->codigo] = $dato->denominacion;
}
$filtro = array();
$this->input->post('diresa') ? $filtro['sub_reg_nt'] = $this->input->post('diresa') : '';
$this->input->post('redes') ? $filtro['red'] = $this->input->post('redes') : '';
$this->input->post('microred') ? $filtro['microred'] = $this->input->post('microred') : '';
$this->input->post('establec') ? $filtro['e_salud'] = $this->input->post('establec') : '';
$this->input->post('departamento') ? $filtro['substr(ubigeo,1,2)'] = $this->input->post('departamento') : '';
$this->input->post('provincia') ? $filtro['substr(ubigeo,1,4)'] = $this->input->post('provincia') : '';
$this->input->post('distrito') ? $filtro['ubigeo'] = $this->input->post('distrito') : '';
$this->input->post('diagno') ? $filtro['diagnostic'] = $this->input->post('diagno') : '';
$this->input->post('tipoDx') ? $filtro['tipo_dx'] = $this->input->post('tipoDx') : '';
$this->input->post('ano_ini') ? $filtro['ano'] = $this->input->post('ano_ini') : '';
$this->input->post('semana_ini') ? $filtro['semana'] = $this->input->post('semana_ini') : '';
$this->input->post('apepat') ? $filtro['apepat'] = $this->input->post('apepat') : '';
$crud = new grocery_CRUD();
$crud->set_theme("datatables");
$crud->set_table('individual');
$crud->columns('ano', 'semana', 'diagnostic', 'tipo_dx', 'subregion', 'sub_reg_nt', 'ubigeo', 'sexo', 'apepat', 'apemat', 'nombres');
$crud->display_as('ano', 'Año')->display_as('diagnostic', 'Diagnóstico')->display_as('subregion', 'Diresa')->display_as('sub_reg_nt', 'Notificante')->display_as('ubigeo', 'Distrito')->display_as('tipo_dx', 'Tipo')->display_as('apepat', 'Ap. Paterno')->display_as('apemat', 'Ap. Materno');
$crud->field_type('subregion', 'dropdown', $subr);
$crud->field_type('sub_reg_nt', 'dropdown', $subr);
$crud->field_type('ubigeo', 'dropdown', $ubigeo);
$crud->field_type('diagnostic', 'dropdown', $enfermedad);
$crud->field_type('tipo_dx', 'dropdown', $tipoDx);
$crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino'));
if ($this->input->post()) {
if ($this->session->userdata('institucion') == 'A') {
$crud->where($filtro);
} else {
$crud->where($filtro);
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
} else {
$crud->where(array('ano' => date('Y')));
switch ($this->session->userdata('nivel')) {
case 4:
$accesar = $this->session->userdata('equipo');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
break;
case 5:
$accesar = $this->session->userdata('diresa');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'subregion' => $accesar));
} else {
$crud->where(array('subregion' => $accesar));
$crud->or_where(array('sub_reg_nt' => $accesar));
}
break;
case 6:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1));
}
break;
case 7:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$accesar2 = $this->session->userdata('microred');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
}
break;
case 8:
$accesar = $this->session->userdata('establecimiento');
$crud->where(array('e_salud' => $accesar));
break;
}
}
$crud->limit(1000);
$crud->order_by('semana', 'DESC');
$crud->set_subject('Individual');
$crud->unset_add();
$crud->unset_read();
$crud->unset_edit();
$crud->unset_export();
$crud->unset_print();
$crud->callback_after_delete(array($this, 'log_usuario_before_delete'));
$crud->add_action('Editar', '', 'individual/modIndividual', 'ui-icon-pencil');
///////////////////////////////////////////////////////////////////////////////
//$crud->add_action_peru('Añadir Individual', '', 'regIndividual','add-icon');
///////////////////////////////////////////////////////////////////////////////
$output = $crud->render();
$this->_example_output1($output);
}
public function pesan()
{
try {
$status = $this->input->get("status");
$crud = new grocery_CRUD();
if (isset($status) and !empty($status)) {
$crud->where('tbl_pertanyaan_user.status', $status);
}
$crud->set_table('tbl_pertanyaan_user');
$crud->set_subject('Pesan');
$crud->set_relation('change_by', 'tbl_user', 'email');
$crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}');
$crud->required_fields('jawaban');
$crud->fields('id_user', 'judul', 'pertanyaan', 'jawaban', 'status', 'change_by', 'change_date');
$crud->columns('id_user', 'judul', 'pertanyaan', 'status');
$crud->display_as("id_user", "Penanya");
$crud->callback_before_update(array($this, 'get_change_by_callback'));
$crud->callback_before_insert(array($this, 'get_change_by_callback'));
$crud->callback_field('change_date', array($this, 'format_date_callback'));
$crud->change_field_type('id_user', 'readonly');
$crud->change_field_type('judul', 'readonly');
$crud->change_field_type('pertanyaan', 'readonly');
$crud->change_field_type('change_by', 'readonly');
$crud->change_field_type('change_date', 'readonly');
$crud->unset_export();
$crud->unset_print();
$crud->unset_save();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->order_by('id_pertanyaan_user', 'desc');
$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 personal_schedule($schedule_id = 5000, $memberid = '0', $test_id = '0', $chk = '0', $unchk = '0')
{
$crud = new grocery_CRUD();
$crud->set_table('personal_schedule');
//$crud->set_theme('datatables');
//$crud->set_relation('member_id', 'members', '{member_id}- {firstname} {lastname}');
//$crud->set_relation('test_id', 'mains_tests', '{test_id}-{test_name}');
$crud->set_relation('expert_id', 'users', '{username}', null, 'username');
$crud->set_relation('reviewer', 'users', '{username}', null, 'username');
$crud->callback_after_insert(array($this, 'add_test_for_user'));
$crud->set_field_upload('answer_script_unchecked', 'assets/uploads/files/answer_script/unchecked');
$crud->set_field_upload('answer_script_checked', 'assets/uploads/files/answer_script/checked');
$crud->set_field_upload('answer_script_rechecked1', 'assets/uploads/files/answer_script/checked');
$crud->set_field_upload('answer_script_rechecked2', 'assets/uploads/files/answer_script/checked');
// $crud->columns('schedule_id', 'test_id', 'member_id','time','answer_script_unchecked','answer_script_checked','marks_obtained','expert_id','receiving_date','receiving_track_no','go_to_expert', 'receiving_from_expert','dispatch_date','dispatch_track_no' );
$crud->columns('schedule_id', 'test_id', 'status', 'receiving_date', 'receiving_from_expert', 'member_id', 'answer_script_unchecked', 'answer_script_checked', 'marks_obtained');
$crud->add_action('Cover', '', '', '', array($this, 'print_cover_cb'));
$crud->add_action('add score', '../../images/add2.jpg', '', '', array($this, 'marks_callback'));
$crud->callback_before_update(array($this, 'send_mail_to_expert'));
$crud->add_action('add answer script to dispatch', '../../images/answer.jpg', '', '', array($this, 'answer_callback'));
$crud->add_action('add test to dispatch', '../../images/test.jpg', '', '', array($this, 'test_callback'));
$crud->unset_delete();
if ($schedule_id != 0) {
$crud->where('personal_schedule.schedule_id >=', $schedule_id);
}
if ($memberid != 0) {
$crud->where('personal_schedule.member_id', $memberid);
}
if ($test_id != 0) {
$crud->where('personal_schedule.test_id', $test_id);
}
if ($chk != 0) {
$crud->where('personal_schedule.answer_script_checked !=', '');
}
//if($unchk!=0)
$crud->where('personal_schedule.answer_script_unchecked !=', '');
$crud->order_by('time, personal_schedule.member_id ', 'asc');
if (isset($_REQUEST['at'])) {
$crud->fields('member_id', 'test_id', 'appeared_on', 'appeared_at', 'receiving_from_expert');
$crud->field_type('member_id', 'readonly');
$crud->field_type('test_id', 'readonly');
}
//$crud->order_by('member_id','asc');
$crud->unset_print();
$crud->unset_export();
//$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$output = $crud->render();
$this->_example_output($output);
}
public function listarCierreModulos()
{
$anio = array();
for ($i = date("Y"); $i >= 2000; $i--) {
$anio[$i] = $i;
}
$crud = new grocery_CRUD();
$crud->columns('aplicativo', 'anio', 'estado');
$crud->set_table('cierreapli');
$crud->display_as('anio', 'Año');
$crud->order_by('anio', 'DESC');
$crud->set_subject('Cierre');
$crud->field_type('estado', 'dropdown', array('1' => 'Activado', '2' => 'Desactivado'));
$crud->field_type('anio', 'dropdown', $anio);
$crud->set_relation('aplicativo', 'aplicaciones', 'nombre');
$output = $crud->render();
$this->_example_output19($output);
}
public function sub_menu_2($id_header_menu, $level_one, $level_two)
{
$crud = new grocery_CRUD();
$crud->set_table('menu');
$crud->set_subject('Sub Menu 2');
$crud->where('level_one', $level_one);
$crud->where('level_two', $level_two);
$crud->change_field_type('id_header_menu', 'invisible');
$crud->change_field_type('level_one', 'invisible');
$crud->change_field_type('level_two', 'invisible');
$crud->order_by('sort', 'ASC');
$crud->set_relation_n_n('Akses', 'groups_menu', 'groups', 'id_menu', 'id_groups', 'name');
$crud->unset_columns('level_one', 'level_two', 'icon', 'menu_id', 'id_header_menu');
$crud->unset_read();
$crud->callback_before_insert(array($this, 'call_sub_menu_2'));
$output = $crud->render();
$data['script'] = "\$('#menu-menu').addClass('active');";
$output->data = $data;
$data['judul'] = "Sub menu 2";
$data['crumb'] = array('Header menu' => 'crud/header_menu', 'Menu' => 'crud/menu/' . $id_header_menu, 'Sub menu' => 'crud/sub_menu/' . $id_header_menu . '/' . $level_one, 'Sub menu 2' => '');
$template = 'admin_template';
$view = 'grocery';
$this->outputview->output_admin($view, $template, $data, $output);
}
function user_managervehicle()
{
if ($this->userconfig->perfil == 'ADMIN' or $this->userconfig->perfil == 'CALL') {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('usuarios');
$crud->set_subject('Rutas');
//$crud->columns('nombre','idsucursal','codigo','pais','departamento','ciudad','direccion','telefono','perfil');
$crud->columns('idsucursal', 'nombre');
$crud->fields('idsucursal', 'nombre', 'codigo', 'pais', 'departamento', 'ciudad', 'perfil');
$crud->required_fields('idsucursal', 'nombre', 'perfil');
$crud->display_as('nombre', 'Ruta');
$crud->change_field_type('perfil', 'hidden');
$crud->change_field_type('codigo', 'hidden');
$crud->change_field_type('pais', 'hidden');
$crud->change_field_type('departamento', 'hidden');
$crud->change_field_type('ciudad', 'hidden');
if ($this->userconfig->perfil == 'ADMIN') {
$crud->set_relation('idsucursal', 'sucursales', 'nombre');
} else {
$crud->set_relation('idsucursal', 'sucursales', 'nombre', 'id IN ("' . $this->userconfig->idsucursal . '")');
}
$crud->display_as('idsucursal', 'Sucursal');
$crud->callback_edit_field('perfil', array($this, 'set_user_cust'));
$crud->callback_add_field('perfil', array($this, 'set_user_cust'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_after_insert(array($this, 'set_code_rutas'));
$crud->where('perfil =', 'CUST');
$crud->order_by('idsucursal,nombre');
if ($this->userconfig->perfil != 'ADMIN') {
$crud->where('idsucursal =', $this->userconfig->idsucursal);
}
$output = $crud->render();
$output->op = 'user_management';
$this->_admin_output($output);
} else {
$this->close();
}
}
public function establishment()
{
$crud = new grocery_CRUD('default');
$crud->set_table('establishment');
$crud->set_subject('establishment');
$crud->columns('id', 'establishment', 'address', 'url', 'pincode', 'status', 'class', 'location', 'specific_location_exists', 'category', 'offer_subcategory', 'latitude', 'longtitude', 'establishment_logo', 'ultimate_card', 'best_card', 'created_date');
$crud->order_by('establishment', 'asc');
$crud->set_field_upload('establishment_logo', 'assets/uploads');
//$crud->unset_columns('created_date');
$crud->unset_add_fields('created_date');
$crud->unset_edit_fields('created_date');
$data = $crud->render();
$this->load->view('admin/crud_view', $data);
}
public function notificacionAutoriza()
{
if ($this->session->userdata('nivel') != 5 or $this->session->userdata('institucion') != 'A') {
$this->session->set_flashdata('error', 'Su nivel de usuario no le permite realizar este proceso');
redirect(site_url("index/principal"), 301);
}
switch ($this->session->userdata('nivel')) {
case 5:
$anio = array();
for ($i = 2010; $i <= date("Y"); $i++) {
$anio[$i] = $i;
}
$semana = array();
for ($i = 1; $i <= 53; $i++) {
$semana[$i] = $i;
}
$sub = $this->frontend_model->mostrarDiresa($this->session->userdata('diresa'));
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$tipo = array('1' => 'Autorizado', '2' => 'No autorizado');
$crud = new grocery_CRUD();
$crud->columns('ano', 'semana', 'diresa', 'estado', 'fecha', 'hora', 'usuario');
$crud->set_table('autoriza');
$crud->set_subject('Autorización');
$where = array('diresa' => $this->session->userdata('diresa'));
$crud->fields('ano', 'semana', 'diresa', 'estado');
$crud->display_as('ano', 'Año');
$crud->field_type('ano', 'dropdown', $anio);
$crud->field_type('semana', 'dropdown', $semana);
$crud->field_type('diresa', 'dropdown', $subr);
$crud->field_type('estado', 'dropdown', $tipo);
$crud->required_fields('diresa', 'ano', 'semana', 'estado');
$crud->where($where);
$crud->order_by('ano, semana', 'DESC');
$crud->callback_insert(array($this, 'autorizar'));
$output = $crud->render();
$this->_example_output3($output);
break;
default:
$this->session->set_flashdata('error', 'Este proceso no está permitido para su nivel de usuario');
redirect(site_url("index/principal"), 301);
break;
}
}
function administracion()
{
try {
/* Creamos el objeto */
$crud = new grocery_CRUD();
/* Seleccionamos el tema */
$crud->set_theme('bootstrap');
/* Seleccionmos el nombre de la tabla de nuestra base de datos*/
$crud->set_table('gastos');
/* Le asignamos un nombre */
$crud->set_subject('Gastos');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/*
* deshabilitamos las llamdas a jquery y a bootstrap
* (ya lo hacemos en el template)
*/
$crud->unset_bootstrap();
//$crud->unset_jquery();
/*
* cambiamos la definicion d efecha a date
*/
$crud->field_type('fecha', 'date');
$crud->field_type('creado_en', 'date');
/* Aqui le decimos que el campo del timestamp no sea visible */
$crud->field_type('creado_en', 'invisible');
/* Aqui le decimos con que campos vamos a trabajar-util para el callback */
$crud->fields('id', 'fecha', 'descripcion', 'creado_en', 'cantidad', 'precio_producto', 'categoria', 'comercio');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('descripcion', 'cantidad', 'fecha', 'precio_producto');
/* Aqui definimos que campos seran visibles en el formulario de ingresos de categoria nueva */
$crud->add_fields('descripcion', 'precio_producto', 'fecha', 'cantidad', 'categoria', 'comercio');
/* Aqui le indicamos que campos deseamos mostrar al listar */
$crud->columns('descripcion', 'fecha', 'cantidad', 'precio_producto', 'categoria', 'comercio');
//las reglas que deben respetar los campos
$crud->set_rules('precio_producto', 'Precio', 'numeric');
$crud->set_rules('cantidad', 'Cantidad', 'is_natural');
/*Le cambiamos en nombre al la columna id */
$crud->display_as('id', 'Referencia');
/*Hacemos lo propio con precio del producto*/
$crud->display_as('precio_producto', 'Precio');
/* llamamos al call_back antes del insert (pone la fecha) */
//$crud->callback_before_insert(array($this,'guardar_fecha'));
// generamos la relacion categorias
$crud->set_relation('categoria', 'categorias', 'descripcion');
// generamos la relacion comercios
$crud->set_relation('comercio', 'comercios', 'descripcion');
/* seteamos el orden de muestra en el grid
* por id , descendiente (el ultimo primero)
*/
$crud->order_by('id', 'desc');
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en
/applications/views/productos/administracion.php */
$this->load->view('header');
$this->load->view('categorias/administracion', $output);
$this->load->view('footer');
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function establishment()
{
$crud = new grocery_CRUD('default');
$crud->set_table('establishment');
$crud->set_subject('establishment');
$crud->columns('id', 'establishment', 'url', 'establishment_logo', 'status');
$crud->order_by('establishment', 'asc');
$crud->set_field_upload('establishment_logo', 'assets/uploads');
$crud->unset_columns('created_date');
$crud->unset_add_fields('created_date');
$crud->unset_edit_fields('created_date');
$data = $crud->render();
$this->load->view('admin/crud_view', $data);
}
function logger()
{
$crud = new grocery_CRUD();
$crud->order_by('dateofdeleteion', 'DESC');
$crud->where('status<>', '0');
$crud->where('dateofdeleteion<=', date('Y-m-d'));
if ($this->session->userdata('role') > 1) {
$crud->where('alert_name', $this->session->userdata('user_name'));
}
$crud->set_table('query', 0, 50);
$crud->columns('subject', 'dts', 'alg_ref', 'date_creation', 'alert_assign_to', 'status', 'dateofdeleteion');
$crud->unset_fields('status', 'dateofdeleteion');
$crud->display_as('subject', 'Subject Line')->display_as('alg_ref', 'ALG Ref No.')->display_as('dts', 'Practice Account')->display_as('date_creation', 'Date creation')->display_as('dateofdeleteion', 'Date Deletion')->display_as('alert_assign_to', 'Name');
$crud->set_subject('Query');
$crud->set_relation('dts', 'DTS', 'name');
$crud->callback_column('status', array($this, '_column_status'));
$crud->callback_column($this->unique_field_name('alert_assign_to'), array($this, '_column_edit_manager1'));
$crud->set_relation('alert_assign_to', 'membership', 'user_name');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$output = $crud->render();
$this->_example_output($output);
}
public function listadoEdas()
{
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$dist = $this->frontend_model->listarDistritos();
$ubigeo = array();
foreach ($dist as $dato) {
$ubigeo[$dato->ubigeo] = $dato->nombre;
}
$est = $this->frontend_model->listaEstablec();
$establec = array();
foreach ($est as $dato) {
$establec[$dato->cod_est] = $dato->raz_soc;
}
$filtro = array();
$this->input->post('diresa') ? $filtro['sub_reg_nt'] = $this->input->post('diresa') : '';
$this->input->post('redes') ? $filtro['red'] = $this->input->post('redes') : '';
$this->input->post('microred') ? $filtro['microred'] = $this->input->post('microred') : '';
$this->input->post('establec') ? $filtro['e_salud'] = $this->input->post('establec') : '';
$this->input->post('departamento') ? $filtro['substr(ubigeo,1,2)'] = $this->input->post('departamento') : '';
$this->input->post('provincia') ? $filtro['substr(ubigeo,1,4)'] = $this->input->post('provincia') : '';
$this->input->post('distrito') ? $filtro['ubigeo'] = $this->input->post('distrito') : '';
$this->input->post('ano') ? $filtro['ano'] = $this->input->post('ano') : '';
$this->input->post('semana') ? $filtro['semana'] = $this->input->post('semana') : '';
$crud = new grocery_CRUD();
$crud->set_theme("datatables");
$crud->set_table('edas');
$crud->columns('ano', 'semana', 'sub_reg_nt', 'e_salud', 'ubigeo', 'daa_c1', 'daa_c1_4', 'daa_c5', 'dis_c1', 'dis_c1_4', 'dis_c5');
$crud->display_as('ano', 'Año')->display_as('e_salud', 'Establecimiento')->display_as('sub_reg_nt', 'Diresa');
$crud->field_type('sub_reg_nt', 'dropdown', $subr);
$crud->field_type('e_salud', 'dropdown', $establec);
$crud->field_type('ubigeo', 'dropdown', $ubigeo);
if ($this->input->post()) {
if ($this->session->userdata('institucion') == 'A') {
$crud->where($filtro);
} else {
$crud->where($filtro);
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
} else {
$crud->where(array('ano' => date('Y')));
switch ($this->session->userdata('nivel')) {
case 4:
$accesar = $this->session->userdata('equipo');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
break;
case 5:
$accesar = $this->session->userdata('diresa');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar));
} else {
$crud->where(array('sub_reg_nt' => $accesar));
}
break;
case 6:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1));
}
break;
case 7:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$accesar2 = $this->session->userdata('microred');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
}
break;
case 8:
$accesar = $this->session->userdata('establecimiento');
$crud->where(array('e_salud' => $accesar));
break;
}
}
$crud->limit(1000);
$crud->order_by('semana', 'DESC');
$crud->set_subject('Atenciones');
$crud->unset_add();
$crud->unset_read();
$crud->unset_edit();
$crud->unset_export();
$crud->unset_print();
$crud->callback_after_delete(array($this, 'log_usuario_before_delete'));
$crud->add_action('Editar', '', 'edas/modEdas', 'ui-icon-pencil');
///////////////////////////////////////////////////////////////////////////////
//$crud->add_action_peru('Añadir EDAS', '', 'regEdas','add-icon');
///////////////////////////////////////////////////////////////////////////////
$output = $crud->render();
$this->_example_output1($output);
}
public function 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 index()
{
try {
// General
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->set_table('sos_ecoute');
$crud->order_by('premier_contact', 'desc');
$crud->set_subject('Ecoute téléphonique');
//relations
$crud->set_relation('situation_familiale', 'sos_gen_situation_familiale_parrent', 'name_situation_familiale_parrent');
$crud->set_relation('emplois', 'sos_gen_emplois_parrent', 'name_emplois');
$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('ville', 'sos_gen_villes', '{nom_ville}, {code_postal}', null, 'nom_ville ASC');
$crud->set_relation('nationalite', 'sos_gen_nationalite', 'name_nationalite');
$crud->set_relation('ressources', 'sos_gen_ressources', 'name_ressources');
$crud->set_relation('allocations_familiales', 'sos_gen_allocations_familiales', 'name_allocations_familiales');
$crud->set_relation('logement', 'sos_gen_logement_parent', 'name_logement');
$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('depuis', 'sos_gen_depuis', 'name_depuis');
$crud->set_relation('temps_ecoute', 'sos_gen_temps_ecoute', 'name_temps_ecoute', null, 'id_temps_ecoute ASC');
$crud->set_relation('interlocuteur', 'sos_gen_interlocuteur', 'name_interlocuteur', null, 'id_interlocuteur ASC');
$crud->set_relation('appel', 'sos_gen_appel', 'name_appel', null, 'id_appel ASC');
$crud->set_relation('frequence', 'sos_gen_frequence', 'name_frequence');
$crud->set_relation('commencement', 'sos_gen_commencement', 'name_commencement');
$crud->set_relation_n_n('violences_physiques', 'sos_relation_violences_physiques_ecoute', 'sos_gen_violences_physiques', 'id_from_violences', 'id_from_violences_physiques', 'name_violences_physiques', 'priority');
$crud->set_relation_n_n('violences_psychologiques', 'sos_relation_violences_psychologiques_ecoute', 'sos_gen_violences_psychologiques', 'id_from_violences', 'id_from_violences_psychologiques', 'name_violences_psychologiques', 'priority');
$crud->set_relation_n_n('violences_sexuelles', 'sos_relation_violences_sexuelles_ecoute', 'sos_gen_violences_sexuelles', 'id_from_violences', 'id_from_violences_sexuelles', 'name_violences_sexuelles', 'priority');
$crud->set_relation_n_n('violences_economiques', 'sos_relation_violences_economiques_ecoute', 'sos_gen_violences_economiques', 'id_from_violences', 'id_from_violences_economiques', 'name_violences_economiques', 'priority');
$crud->set_relation_n_n('violences_administratives', 'sos_relation_violences_administratives_ecoute', 'sos_gen_violences_administratives', 'id_from_violences', 'id_from_violences_administratives', 'name_violences_administratives', 'priority');
$crud->set_relation_n_n('violences_sociales', 'sos_relation_violences_sociales_ecoute', 'sos_gen_violences_sociales', 'id_from_violences', 'id_from_violences_sociales', 'name_violences_sociales', 'priority');
$crud->set_relation_n_n('violences_privations', 'sos_relation_violences_privations_ecoute', 'sos_gen_violences_privations', 'id_from_violences', 'id_from_violences_privations', 'name_violences_privations', 'priority');
$crud->set_relation_n_n('violences_juridiques', 'sos_relation_violences_juridiques_ecoute', 'sos_gen_violences_juridiques', 'id_from_violences', 'id_from_violences_juridiques', 'name_violences_juridiques', 'priority');
$crud->set_relation_n_n('de_la_part', 'sos_relation_de_la_part_ecoute', 'sos_gen_de_la_part', 'id_from_violences', 'id_from_de_la_part', 'name_de_la_part');
$crud->set_relation_n_n('raisons', 'sos_relation_raisons_ecoute', 'sos_gen_raisons', 'id_from_violences', 'id_from_raisons', 'name_raisons');
$crud->set_relation_n_n('violences_enfants_directes', 'sos_relation_violences_enfants_directes_ecoute', 'sos_gen_violences_enfants_directes', 'id_from_violences', 'id_from_violences_enfants_directes', 'name_violences_enfants_directes', 'priority');
$crud->set_relation_n_n('violences_enfants_indirectes', 'sos_relation_violences_enfants_indirectes_ecoute', 'sos_gen_violences_enfants_indirectes', 'id_from_violences', 'id_from_violences_enfants_indirectes', 'name_violences_enfants_indirectes', 'priority');
$crud->set_relation_n_n('de_la_part_enfants', 'sos_relation_de_la_part_enfants_ecoute', 'sos_gen_de_la_part_enfants', 'id_from_violences', 'id_from_de_la_part_enfants', 'name_de_la_part_enfants');
$crud->set_relation_n_n('consequences_physiques', 'sos_relation_consequences_physiques_ecoute', 'sos_gen_consequences_physiques', 'id_from_violences', 'id_from_consequences_physiques', 'name_consequences_physiques', 'priority');
$crud->set_relation_n_n('consequences_psychologiques', 'sos_relation_consequences_psychologiques_ecoute', 'sos_gen_consequences_psychologiques', 'id_from_violences', 'id_from_consequences_psychologiques', 'name_consequences_psychologiques', 'priority');
$crud->set_relation_n_n('consequences_administratives', 'sos_relation_consequences_administratives_ecoute', 'sos_gen_consequences_administratives', 'id_from_violences', 'id_from_consequences_administratives', 'name_consequences_administratives', 'priority');
//Master/child relations
$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_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', '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();
$fields_demarche = array('first' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser'));
// 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/',
$config_demarche = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first');
$categories_demarche = new gc_dependent_select($crud, $fields_demarche, $config_demarche);
$js_demarche = $categories_demarche->get_js();
$fields_demarche1 = array('first1' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second1' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third1' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser'));
// 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/',
$config_demarche1 = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first1');
$categories_demarche1 = new gc_dependent_select($crud, $fields_demarche1, $config_demarche1);
$js_demarche1 = $categories_demarche1->get_js();
$fields_demarche2 = array('first2' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second2' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third2' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser'));
// 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/',
$config_demarche2 = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first2');
$categories_demarche2 = new gc_dependent_select($crud, $fields_demarche2, $config_demarche2);
$js_demarche2 = $categories_demarche2->get_js();
$crud->set_relation('first', 'sos_gen_demarche_first', 'name_demarche_first');
$crud->set_relation('second', 'sos_gen_demarche_second', 'name_demarche_second');
$crud->set_relation('third', 'sos_gen_demarche_third', 'name_demarche_third');
$crud->set_relation('first1', 'sos_gen_demarche_first', 'name_demarche_first');
$crud->set_relation('second1', 'sos_gen_demarche_second', 'name_demarche_second');
$crud->set_relation('third1', 'sos_gen_demarche_third', 'name_demarche_third');
$crud->set_relation('first2', 'sos_gen_demarche_first', 'name_demarche_first');
$crud->set_relation('second2', 'sos_gen_demarche_second', 'name_demarche_second');
$crud->set_relation('third2', 'sos_gen_demarche_third', 'name_demarche_third');
//Visual
$crud->display_as('nationalite', 'Nationalité')->display_as('premier_contact', 'Date')->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('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('situation_actuelle_detailles', 'Situation actuelle détaillée')->display_as('emplois', 'Situation professionnelle')->display_as('commentaire', 'Commentaires')->display_as('partenaire', 'Orienteur')->display_as('rep_accueil', 'Réponse')->display_as('rep_informations', 'Réponse')->display_as('rep_conseil', 'Réponse')->display_as('rep_orientation', 'Réponse')->display_as('rep_rdv', 'Réponse')->display_as('rep_hebergement', 'Réponse')->display_as('rep_soutien', 'Réponse')->display_as('rep_aide_materielle', 'Réponse')->display_as('rep_ecoute', 'Réponse')->display_as('consequences', 'Conséquences')->display_as('consequences_administratives', 'Conséquences administratives et économiques')->display_as('violences_economiques', 'Violences économiques')->display_as('consequences_physiques', 'Conséquences physiques')->display_as('consequences_psychologiques', 'Conséquences psychologiques')->display_as('consequences_administratives', 'Conséquences administratives')->display_as('de_la_part_enfants', 'Violences sur enfants par')->display_as('temps_ecoute', "Temps d'écoute")->display_as('age', 'Age de la femme')->display_as('logement_dem', 'Demande de logement')->display_as('rep_logement_dem', 'Réponse')->display_as('violences_enfants_directes', 'ENFANTS - Violences directes')->display_as('violences_enfants_indirectes', 'ENFANTS - Violences indirectes')->display_as('frequence', 'Fréquence')->display_as('demandes', 'Demandes/Réponses');
$crud->display_as('first', 'Type de démarche 1');
$crud->display_as('second', 'Type d\'intervention 1');
$crud->display_as('third', 'Suites 1');
$crud->display_as('first1', 'Type de démarche 2');
$crud->display_as('second1', 'Type d\'intervention 2');
$crud->display_as('third1', 'Suites 2');
$crud->display_as('first2', 'Type de démarche 3');
$crud->display_as('second2', 'Type d\'intervention 3');
$crud->display_as('third2', 'Suites 3');
$crud->display_as('demarche', 'Démarches');
//unsets
if ($this->session->userdata('status') == '1' or $this->session->userdata('status') == '2' or $this->session->userdata('status') == '3') {
$crud->fields('premier_contact', 'interlocuteur', 'appel', 'partenaire', 'temps_ecoute', 'age', 'enfants', 'enceinte', 'ville', 'nationalite', 'situation_familiale', 'depuis', 'duree_de_la_relation', 'emplois', 'logement', 'situation_actuelle', 'situation_actuelle_detailles', 'situation_actuelle_depuis', 'ressources', 'allocations_familiales', 'dettes', 'soutien', 'rep_soutien', 'ecoute', 'rep_ecoute', 'accueil', 'rep_accueil', 'informations', 'rep_informations', 'conseil', 'rep_conseil', 'orientation', 'rep_orientation', 'rdv', 'rep_rdv', 'hebergement', 'rep_hebergement', 'logement_dem', 'rep_logement_dem', 'aide_materielle', 'rep_aide_materielle', 'violences_physiques', 'violences_psychologiques', 'violences_sexuelles', 'violences_economiques', 'violences_administratives', 'violences_sociales', 'violences_privations', 'violences_juridiques', 'de_la_part', 'raisons', 'violences_enfants_directes', 'violences_enfants_indirectes', 'de_la_part_enfants', 'consequences_physiques', 'consequences_psychologiques', 'consequences_administratives', 'frequence', 'commencement', 'first', 'second', 'third', 'first1', 'second1', 'third1', 'first2', 'second2', 'third2', 'commentaire');
} else {
$crud->fields('interlocuteur', 'appel', 'partenaire', 'temps_ecoute', 'age', 'enfants', 'enceinte', 'ville', 'nationalite', 'situation_familiale', 'depuis', 'duree_de_la_relation', 'emplois', 'logement', 'situation_actuelle', 'situation_actuelle_detailles', 'situation_actuelle_depuis', 'ressources', 'allocations_familiales', 'dettes', 'soutien', 'rep_soutien', 'ecoute', 'rep_ecoute', 'accueil', 'rep_accueil', 'informations', 'rep_informations', 'conseil', 'rep_conseil', 'orientation', 'rep_orientation', 'rdv', 'rep_rdv', 'hebergement', 'rep_hebergement', 'logement_dem', 'rep_logement_dem', 'aide_materielle', 'rep_aide_materielle', 'violences_physiques', 'violences_psychologiques', 'violences_sexuelles', 'violences_economiques', 'violences_administratives', 'violences_sociales', 'violences_privations', 'violences_juridiques', 'de_la_part', 'raisons', 'violences_enfants_directes', 'violences_enfants_indirectes', 'de_la_part_enfants', 'consequences_physiques', 'consequences_psychologiques', 'consequences_administratives', 'frequence', 'commencement', 'first', 'second', 'third', 'first1', 'second1', 'third1', 'first2', 'second2', 'third2', 'commentaire');
}
$crud->unset_add_fields('par');
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('premier_contact', 'appel', 'temps_ecoute', 'interlocuteur');
$crud->columns('premier_contact', 'infos', 'situation', 'demandes', 'violences', 'de_la_part', 'commencement', 'consequences', 'demarche');
//Callbacks
$crud->callback_column('ouvertures', array($this, 'ouvertures'));
$crud->callback_column('premier_contact', array($this, 'premier_contact'));
$crud->callback_column('infos', array($this, 'infos'));
$crud->callback_column('situation', array($this, 'situation'));
$crud->callback_column('demandes', array($this, 'demandes'));
$crud->callback_column('commentaire', array($this, 'commentaire'));
$crud->callback_column('demarche', array($this, 'demarche'));
$crud->callback_after_update(array($this, 'insert_after_update'));
$crud->callback_after_insert(array($this, 'insert_after_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->callback_column('de_la_part', array($this, 'de_la_part'));
$crud->callback_column('raisons', array($this, 'raisons'));
$crud->callback_column('violences', array($this, 'violences'));
$crud->callback_column('consequences', array($this, 'consequences'));
//field Types
//$crud->callback_edit_field('accueil', array($this, 'edit_field_callback_1'));
//$crud->callback_add_field('accueil', array($this, 'add_field_callback_1'));
//field Types
$crud->field_type('dettes', 'enum', array('OUI', 'NON'));
$crud->field_type('enceinte', 'enum', array('OUI', 'NON'));
// $crud->field_type('appel', 'dropdown', array('0' => '', '1' => '1er appel', '2' => 'Appel suivi', '3' => 'Autres appels'));
$crud->field_type('enfants', 'enum', array('Aucun', '1 enfant', '2 enfants', '3 enfants', '4 enfants', '5 et +'));
// $crud->field_type('interlocuteur', 'dropdown', array('0' => '', '1' => 'Elle-même', '2' => 'Professionnel', '3' => 'Entourage'));
// Actions
// Renders
$output = $crud->render();
$output->output .= $js_situation_actuelle . $js_demarche . $js_demarche1 . $js_demarche2;
$menu = new stdClass();
$menu->status = $this->session->userdata('status');
if ($menu->status != 5) {
$menu->n1 = true;
} else {
$menu->n0 = true;
}
$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 notificacionAutoriza()
{
$anio = array();
for ($i = 2010; $i <= date("Y"); $i++) {
$anio[$i] = $i;
}
$semana = array();
for ($i = 1; $i <= 53; $i++) {
$semana[$i] = $i;
}
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$tipo = array('1' => 'Autorizado', '2' => 'No autorizado');
$crud = new grocery_CRUD();
$crud->columns('ano', 'semana', 'diresa', 'estado', 'fecha', 'hora', 'usuario');
$crud->set_table('autoriza');
$crud->set_subject('Autorización');
$crud->fields('ano', 'semana', 'diresa', 'estado');
$crud->display_as('ano', 'Año');
$crud->field_type('ano', 'dropdown', $anio);
$crud->field_type('semana', 'dropdown', $semana);
$crud->field_type('diresa', 'dropdown', $subr);
$crud->field_type('estado', 'dropdown', $tipo);
$crud->required_fields('diresa', 'ano', 'semana', 'estado');
$crud->order_by('ano, semana', 'DESC');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
//$crud->unset_export();
$crud->unset_DELETE();
$crud->unset_print();
$output = $crud->render();
$this->_example_output1($output);
}
function estados()
{
if ($this->session->userdata('perfil') == 'admin') {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('estados');
$crud->set_subject('Estados para tareas');
$crud->columns('estado', 'comentarios');
$crud->fields('estado', 'comentarios');
$crud->required_fields('estado');
$crud->unset_read();
$output = $crud->render();
$crud->order_by('id_estados');
$this->_example_output($output);
//$data['titulo'] = 'Bienvenido Administrador';
//$this->load->view('admin_view',$data);
} else {
redirect(base_url() . 'login');
}
}
