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