public function index() { //$data['main_content'] = 'login_form'; //$this->load->view('includes/template',$data); //$this->load->view('admin/configuration'); //$this->load->view('admin/homepage'); $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('ips_disposition'); $crud->set_subject('Disposition'); $crud->required_fields('NAME'); $crud->columns('NAME', 'DISABLE'); $crud->fields('NAME'); // $crud->unset_add(); // $crud->unset_edit(); $crud->unset_delete(); $crud->set_lang_string('insert_success_message', 'Your data has been successfully stored into the database.<br/>Please wait while you are redirecting to the list page. <script type="text/javascript"> window.location = "' . site_url('admin/disposition') . '"; </script> <div style="display:none"> '); $crud->callback_after_insert(array($this, 'disposition_generation')); $output = $crud->render(); // $this->grocery_crud->set_table('ips_login'); // $output = $this->grocery_crud->render(); $this->_example_output($output); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('bootstrap'); $crud->set_table('user'); $crud->set_subject('Gebruiker'); // hide fields $crud->columns('is_super_user', 'is_active', 'screen_name', 'email', 'gebruikersgroepen'); // new_password and new_password repeat are needed to make formvalidation work // id is needed to make the email unique check work $crud->fields('id', 'is_active', 'screen_name', 'email', 'gebruikersgroepen', 'password', 'new_password', 'new_password_repeat'); $crud->required_fields('email', 'screen_name', 'is_active'); $crud->set_relation_n_n('gebruikersgroepen', 'user_x_user_group', 'user_group', 'user_id', 'user_group_id', 'name'); $crud->field_type('id', 'hidden'); $crud->field_type('new_password_repeat', 'hidden'); $crud->field_type('password', 'hidden'); $crud->display_as('is_active', 'Actief'); $crud->display_as('screen_name', 'Schermnaam'); $crud->display_as('is_super_user', ''); $crud->display_as('new_password', 'Wachtwoord'); if ($crud->getState() == 'read') { $crud->field_type('new_password', 'hidden'); } else { $crud->callback_field('new_password', array($this, 'edit_field_callback_new_password')); } $crud->field_type('is_active', 'dropdown', array('yes' => 'ja', 'no' => 'nee')); $crud->callback_column('is_active', array($this, 'callback_list_is_active')); $crud->callback_column('is_super_user', array($this, 'callback_list_is_super_user')); $crud->callback_before_insert(array($this, 'before_insert_update_callback')); $crud->callback_before_update(array($this, 'before_insert_update_callback')); $crud->callback_after_insert(array($this, 'after_insert_callback')); $crud->callback_after_update(array($this, 'after_update_callback')); if ($crud->getState() === 'update_validation' or $crud->getState() === 'insert_validation') { $crud->set_rules('email', 'E-mail', 'required|valid_email|callback_email_unique_check'); $crud->set_rules('screen_name', 'Schermnaam', 'required'); if ($this->input->post('new_password') != '' or !$this->input->post('id')) { $crud->set_rules('new_password', 'Nieuw wachtwoord', 'required|min_length[10]|matches[new_password_repeat]'); $crud->set_rules('new_password_repeat', 'Herhaal nieuw wachtwoord', ''); } $this->form_validation->set_message('matches', 'De wachtwoorden zijn niet aan elkaar gelijk.'); } // 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(); // put the crud content in the right position $this->views['content'] = $crud_output->output; $this->css[] = $this->load->view('admin/user/css/index.css', array(), true); // add javascript and css to make the password generate and change function possible if ($crud->getState() === 'add' or $crud->getState() === 'edit') { $this->css[] = $this->load->view('admin/user/css/edit_user.css', array(), true); $this->javascript[] = $this->load->view('admin/user/js/edit_user.js', array(), true); } // create the layout-HTML and show it to the user $this->_layout(); }
public function index($categoryid = 0) { $session_data = $this->session->userdata('logged_in'); $data['username'] = $session_data['username']; $data['lo'] = 2; //value used to identify section movie or celebrity $data['categoryid'] = $categoryid; //value used to identify section movie or celebrity if ($categoryid != 0) { $data['cat_id'] = $categoryid; $cat_title = $this->category->getTitle($categoryid); $data['cat_title'] = $cat_title . " - Movies"; $form_subject = $cat_title; $crud = new grocery_CRUD(); $crud->set_table('dbx_movies'); $crud->where('catid', $categoryid); $crud->set_subject('Movie'); $crud->required_fields('title', 'year'); $crud->columns('title'); // $crud->callback_column('name',array($this,'link_title')); // $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]'); $crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl')); $crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl')); $crud->fields('catid', 'title', 'year', 'release_date', 'cast', 'director', 'producer', 'music', 'writer', 'lyrics', 'synopsis', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date'); // $crud->field_type('catid', 'hidden', $categoryid); $crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'M'), null, $categoryid); $crud->display_as('catid', 'Category'); // $crud->callback_add_field('cast', array($this, 'add_field_cast')); $crud->callback_add_field('synopsis', array($this, 'add_field_synopsis')); $crud->callback_edit_field('cast', array($this, 'edit_field_cast')); $crud->callback_edit_field('synopsis', array($this, 'edit_field_synopsis')); $crud->change_field_type('ownerid', 'invisible'); $crud->change_field_type('created_date', 'invisible'); $crud->change_field_type('seo_url', 'invisible'); $crud->change_field_type('lastupdate_date', 'invisible'); $crud->callback_before_insert(array($this, 'before_insert')); $crud->callback_before_update(array($this, 'before_update')); $crud->callback_after_insert(array($this, 'after_insert')); $crud->unset_jquery(); $state = $crud->getState(); // echo($state); $data['state'] = $state; $output = $crud->render($data); $this->load->view('header_view', $data); $this->load->view('movies_view', $output); $this->load->view('footer_view', $data); } }
public function index() { $crud = new grocery_CRUD(); $crud->set_table('gallery'); $crud->columns('subject', 'publish', 'creator', 'last_update'); $crud->required_fields('subject', 'publish'); $crud->callback_after_insert(array($this, 'log_user')); $crud->callback_after_update(array($this, 'log_user')); $crud->set_subject('Gallery Album'); $crud->fields('subject', 'deskripsi', 'publish'); $crud->add_action('Smileys', base_url() . 'assets/uploads/pictures.png', 'adminpanel/gallery/uploadPicture'); $output = $crud->render(); $data['subject'] = 'Gallery Album'; $data['content'] = $this->load->view('crud.php', $output, true); $this->load->view('base_theme', $data); }
function administration() { try { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('tags'); $crud->set_subject('Palabras Claves de Sitios'); $crud->set_language('spanish'); $crud->unset_export(); $crud->display_as('tag', 'Palabra Clave'); $crud->callback_after_insert(array($this, 'after_insert_log')); $crud->callback_before_delete(array($this, 'before_delete_log')); $crud->callback_after_update(array($this, 'after_update_log')); $output = $crud->render(); $this->load->view('includes/template', $output); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function kids_window($id) { $this->id_femme = $id; try { $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->where('id_femme', $id); $crud->set_table('sos_kids'); $crud->set_subject('Enfant(s)'); $crud->unset_edit_fields('id_kid'); $crud->unset_add_fields('id_kid'); $crud->field_type('id_femme', 'hidden', $this->id_femme); $crud->columns('prenom', 'nom', 'age', 'sex', 'commentaire'); $crud->display_as('prenom', 'Prénom'); $crud->display_as('sex', 'Sexe'); $crud->display_as('commentaire', 'Commentaires'); $crud->set_relation('age', 'sos_gen_kids_age', 'name_kids_age'); if (!$this->session->userdata('status')) { $crud->unset_export(); $crud->unset_print(); } $crud->callback_after_update(array($this, 'after_update')); $crud->callback_after_insert(array($this, 'insert_after')); $crud->field_type('sex', 'enum', array('Fille', 'Garçon')); $output = $crud->render(); $menu = new stdClass(); $menu->n1 = true; $menu->status = $this->session->userdata('status'); $this->db->where('id_femme', $this->id_femme); $query = $this->db->get('sos_femme'); if ($query->num_rows == 1) { $row_femme = $query->row(); } $header = $this->navigation->home_f($menu) . ' ' . '<p><pre>' . $row_femme->prenom . ' ' . $row_femme->nom . ' ' . $row_femme->nom_marital . '</pre></p>'; $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
function administration() { try { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('owners'); $crud->set_subject('Propietarios de Sitios'); $crud->set_language('spanish'); $crud->unset_export(); $crud->display_as('name', 'Nombre')->display_as('description', 'Descripción')->display_as('email', 'Correo')->display_as('phone', 'Teléfono'); $crud->add_fields('name', 'email', 'phone', 'description'); $crud->callback_after_insert(array($this, 'after_insert_log')); $crud->callback_before_delete(array($this, 'before_delete_log')); $crud->callback_after_update(array($this, 'after_update_log')); $output = $crud->render(); $this->load->view('includes/template', $output); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function index() { //$data['main_content'] = 'login_form'; //$this->load->view('includes/template',$data); //$this->load->view('admin/configuration'); //$this->load->view('admin/homepage'); $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('ips_brand'); $crud->set_subject('Brand'); $crud->required_fields('NAME'); $crud->columns('NAME', 'DISABLE'); $crud->fields('NAME', 'DISABLE'); // $crud->unset_add(); // $crud->unset_edit(); $crud->unset_delete(); $crud->callback_after_insert(array($this, 'brand_generation')); $output = $crud->render(); // $this->grocery_crud->set_table('ips_login'); // $output = $this->grocery_crud->render(); $this->_example_output($output); }
function administration() { try { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('sites'); $crud->set_subject('Directorio de Sitios'); $crud->set_language('spanish'); $crud->unset_export(); $crud->columns('name', 'url', 'owner', 'active', 'fk_language'); // $crud->required_fields('name', 'url', 'description', 'fk_type', 'fk_owner'); $crud->set_relation('fk_type', 'types_site', 'type'); $crud->set_relation('fk_language', 'languages', 'language'); $crud->set_relation_n_n('parent', 'parents_site', 'sites', 'child_site', 'parent_site', 'name'); $crud->set_relation_n_n('owner', 'site_owner', 'owners', 'fk_site', 'fk_owner', 'name'); $crud->set_relation_n_n('icon', 'site_icon', 'icons', 'fk_site', 'fk_icon', 'icon'); $crud->set_relation_n_n('text', 'site_text', 'text', 'fk_site', 'fk_text', 'text'); $crud->set_relation_n_n('category', 'sites_categories', 'categories', 'fk_site', 'fk_category', 'category'); $crud->set_relation_n_n('tags', 'sites_tags', 'tags', 'fk_site', 'fk_tag', 'tag'); $crud->change_field_type('description', 'text'); // $crud->callback_add_field('text', array($this, 'field_add_text_callback')); // $crud->callback_add_field('icon', array($this, 'field_icon_callback')); $crud->display_as('name', 'Nombre')->display_as('url', 'URL')->display_as('description', 'Descripción')->display_as('active', 'Estado')->display_as('date_publication', 'Inicio de Publicidad')->display_as('published_to_date', 'Fin de Publicidad')->display_as('priority', 'Prioridad')->display_as('category', 'Categoría')->display_as('owner', 'Propietario')->display_as('parent', 'Sitios Padre')->display_as('tags', 'Palabras Claves')->display_as('icon', 'Icono')->display_as('text', 'Texto Adicional')->display_as('fk_language', 'Idioma')->display_as('fk_type', 'Tipo de sitio'); //$crud->change_field_type('name','file'); /** * Insertando campos en las tablas "icons_site" y "add_text" */ $crud->callback_after_insert(array($this, 'after_insert')); $crud->callback_before_delete(array($this, 'before_delete_log')); $crud->callback_after_update(array($this, 'after_update_log')); $output = $crud->render(); $this->load->view('includes/template', $output); } catch (Exception $e) { /* Si algo sale mal mostramos error */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
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 upload_window($id) { $this->id_femme = $id; try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->where('id_from_femme', $id); $crud->set_table('sos_upload'); $crud->set_subject('Document'); $crud->field_type('id_from_femme', 'hidden', $this->id_femme); //relations $crud->set_relation('type_uploads', 'sos_gen_type_uploads_parrent', 'name_type_uploads_parrent'); $crud->set_relation('detailles', 'sos_gen_type_uploads_child', 'name_type_uploads_child'); //Master/child relations //Visual $crud->columns('type_uploads', 'detailles', 'file_url', 'date_entry'); //unsets $crud->unset_fields('date_entry'); $crud->unset_export(); $crud->unset_print(); //Requireds $crud->required_fields('type_uploads', 'file_url'); //Visual $crud->display_as('type_uploads', 'Type de document')->display_as('detailles', 'Détail')->display_as('date_entry', 'Date d\'envoi')->display_as('file_url', 'Document'); //Callbacks $crud->callback_after_update(array($this, 'after_update')); $crud->callback_before_upload(array($this, 'before_upload')); $crud->callback_before_delete(array($this, 'before_delete')); $crud->callback_after_insert(array($this, 'insert_after')); $crud->callback_before_update(array($this, 'before_update')); //field Types if (!is_dir($path = 'assets/uploads/files/image_' . $this->id_femme)) { mkdir($path = 'assets/uploads/files/image_' . $this->id_femme); } $crud->set_field_upload('file_url', 'assets/uploads/files/image_' . $this->id_femme); $fields_type_uploads = array('type_uploads' => array('table_name' => 'sos_gen_type_uploads_parrent', 'title' => 'name_type_uploads_parrent', 'relate' => null), 'detailles' => array('table_name' => 'sos_gen_type_uploads_child', 'title' => 'name_type_uploads_child', 'id_field' => 'id_type_uploads_child', 'relate' => 'id_parrent_from_type_uploads_parrent', 'data-placeholder' => 'Precisé')); $config_type_uploads = array('main_table' => 'sos_upload', 'main_table_primary' => 'id_upload', "url" => base_url() . 'index.php/upload/upload_window/', 'segment_name' => "type_uploads"); $categories_type_uploads = new gc_dependent_select($crud, $fields_type_uploads, $config_type_uploads); $js_type_uploads = $categories_type_uploads->get_js(); // Actions $this->db->where('id_femme', $this->id_femme); $query = $this->db->get('sos_femme'); if ($query->num_rows == 1) { $row_femme = $query->row(); } // Renders $output = $crud->render(); $output->output .= $js_type_uploads; $menu = new stdClass(); $menu->n1 = true; $menu->status = $this->session->userdata('status'); $this->db->where('id_femme', $this->id_femme); $query = $this->db->get('sos_femme'); if ($query->num_rows == 1) { $row_femme = $query->row(); } $header = $this->navigation->home_f($menu) . ' ' . '<p><pre>' . $row_femme->prenom . ' ' . $row_femme->nom . ' ' . $row_femme->nom_marital . '</pre></p>'; $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function paragraph() { if (!is_super_user()) { redirect(site_url('admin/help')); } $this->load->config('grocery_crud'); $this->config->set_item('grocery_crud_text_editor_type', 'minimal'); $crud = new grocery_CRUD(); $crud->set_theme('bootstrap'); $crud->set_table('help_paragraph'); $crud->set_subject("Documentatie alinea's"); $crud->unset_add_fields('date_modified'); $crud->unset_edit_fields('page_id', 'date_modified'); $crud->field_type('date_created', 'invisible'); $crud->field_type('user_id', 'invisible'); $crud->field_type('order', 'hidden'); $crud->callback_add_field('page_id', array($this, 'paragraph_callback_add_field_page_id')); $crud->callback_before_insert(array($this, 'paragraph_callback_before_insert')); $crud->callback_before_update(array($this, 'paragraph_callback_before_update')); $crud->callback_after_insert(array($this, 'save_to_sql')); $crud->callback_after_update(array($this, 'save_to_sql')); $crud->callback_after_delete(array($this, 'save_to_sql')); $crud->required_fields('key', 'title', 'content', 'is_visible'); // render the crud HTML $crud_output = $crud->render(); if ($crud->getState() == 'list') { redirect(site_url('admin/help')); } else { if ($crud->getState() == 'success') { $this->session->set_flashdata('form_submit', 'success'); $this->session->set_flashdata('form_message', 'Alinea met succes opgeslagen.'); $state = $crud->getStateInfo(); $this->load->model('admin/help_model'); $paragraph = $this->help_model->get_paragraph($state->primary_key, 'off'); redirect(site_url('admin/help/index/' . $paragraph['page_id'] . '#' . $paragraph['key'])); } } $this->javascript_files = $crud->get_js_files(); $this->css_files = $crud->get_css_files(); $this->views['content'] = $crud_output->output; $this->_layout(); }
public function demande_window($id) { $this->id_femme = $id; try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->where('id_from_femme', $id); $crud->set_table('sos_demande'); $crud->set_subject('Intervention'); $crud->display_as('date_entry', 'Date de saisie'); $crud->display_as('accueil_dem', 'Accueil'); $crud->display_as('accompagnement_specialise', 'Accompagnement spécialisé'); //relations $crud->set_relation('femme', 'sos_gen_demande_femme', 'name_demande_femme'); $crud->set_relation('accueil_dem', 'sos_gen_demande_accueil', 'name_demande_accueil'); $crud->set_relation_n_n('lieu_ressource', 'sos_relation_demande_lieu_ressource', 'sos_gen_demande_lieu_ressource', 'id_from_demande', 'id_from_lieu_ressource', 'name_demande_lieu_ressource'); $crud->set_relation_n_n('accompagnement_specialise', 'sos_relation_demande_accompagnement_specialise', 'sos_gen_demande_accompagnement_specialise', 'id_from_demande', 'id_from_accompagnement_specialise', 'name_demande_accompagnement_specialise'); $crud->set_relation('hbgt', 'sos_gen_demande_hbgt', 'name_demande_hbgt'); $crud->set_relation('service', 'sos_gen_service', 'nom_service', null, 'nom_service DESC'); //Master/child relations //Visual $crud->columns('date_entry', 'visite', 'accompagnement_specialise', 'lieu_ressource', 'commentaire'); //unsets $crud->unset_fields('id_demande', 'date_entry', 'dump'); if (!$this->session->userdata('status')) { $crud->unset_export(); $crud->unset_print(); } //Requireds $crud->required_fields('visite', 'accueil_dem', 'femme', 'service'); //Callbacks $crud->callback_column('date_entry', array($this, 'date_entry')); $crud->callback_column('visite', array($this, 'visite')); $crud->callback_column('commentaire', array($this, 'commentaire')); $crud->callback_column('commentaire_psy', array($this, 'commentaire_psy')); $crud->callback_column('lieu_ressource', array($this, 'lieu_ressource')); $crud->callback_column('accompagnement_specialise', array($this, 'accompagnement_specialise')); $crud->callback_after_update(array($this, 'insert_after')); $crud->callback_after_insert(array($this, 'insert_after_insert')); //field Types $crud->field_type('id_from_femme', 'hidden', $this->id_femme); $crud->field_type('id_user', 'hidden', $this->session->userdata('userid')); // Actions $crud->add_action('Enfants', '', 'enfants/enfants_window', 'ui-icon-person'); //$crud->add_action('Enfants', base_url('img/pictos/enfants.png'), 'kids/kids_window', 'ui-icon-person'); // $crud->add_action('Enfants', base_url('img/pictos/enfants.png'), 'enfants/enfants_window', 'ui-icon-person'); // Renders $output = $crud->render(); $menu = new stdClass(); $menu->n1 = true; $menu->status = $this->session->userdata('status'); $this->db->where('id_femme', $this->id_femme); $query = $this->db->get('sos_femme'); if ($query->num_rows == 1) { $row_femme = $query->row(); } $header = $this->navigation->home_f($menu) . ' ' . '<p><pre>' . $row_femme->prenom . ' ' . $row_femme->nom . ' ' . $row_femme->nom_marital . '</pre></p>'; $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
function followup() { $crud = new grocery_CRUD(); //verifica daca get este setata sa previn eroarea "undefine index variable" si verifica daca are valoare if (isset($_GET["p_id"]) != NULL) { // setez o variabila sesiune $this->session->set_userdata('patient_id', $_GET['p_id']); $pid = $this->session->userdata('patient_id'); //print_r("ID_pacient: ".$pid); //echo $_GET['pacient_id'].' sesiune settata'; } else { $pid = $this->session->userdata('patient_id'); //echo "hau".$pid."nu are"; //print_r("ID_pacient: ".$pid); } //aici fac filtrarea pentru pacient a spitalizarilor dupa variabila sesiune $crud->where('patient_id', $pid); // Configurez modelul pentru afisare $crud->set_theme('datatables'); $crud->set_table('follow_up'); $crud->set_subject('PCI Follow-Up'); //Configurare coloane $crud->columns('date', 'survival_status', 'date_of_death', 'status', 'signature'); $crud->required_fields('signature', 'status'); // Formatare cod $crud->field_type('patient_id', 'hidden', $pid); // $crud->field_type('user_id', 'hidden'); // $crud->field_type('edit_user', 'hidden'); // $crud->field_type('edit_time', 'hidden'); $crud->set_relation('signature', 'user', 'user_name'); // User Level Unset $drp = $this->session->userdata('user_type'); //print_r($drp); if ($drp == "user") { $crud->unset_delete(); $crud->unset_export(); $crud->unset_print(); } // log- user activities $crud->callback_after_insert(array($this, 'log_user_after_insert_followup')); $crud->callback_after_update(array($this, 'log_user_after_update_followup')); $crud->callback_after_delete(array($this, 'log_user_after_delete_followup')); // Afisare nume formular follow-up //-- 1. Follow Up (30 days and 12 months) $crud->display_as('date', 'Date of follow up'); $crud->field_tip('date', 'Indicate the date of last follow up alive. This may be the date of follow up or the date the patient is last seen alive by verifiable sources'); $crud->display_as('survival_status', 'Survival status at folow up'); $crud->field_tip('survival_status', 'Indicate vital status at follow up'); $crud->display_as('death_cause', 'Primary cause of death'); $crud->field_tip('death_cause', 'If the patient died indicate the cause of death'); $crud->display_as('anginal_status', 'Anginal status'); $crud->field_tip('anginal_status', 'Indicate the patients anginal status at the time of follow-up'); $crud->display_as('date_readmission', 'Date of first hospital readmission since discharge'); $crud->field_tip('date_readmission', 'If the patient is readmitted to hospital for a cardiovascular cause, indicate the date'); $crud->field_tip('dyspnoea', 'Grade breathing status according to the New York Heart Association (NYHA) functional classification.'); $crud->display_as('mi', 'Myocardial infarction [MI]'); $crud->field_tip('mi', 'Indicate if the patient was diagnosed as having an MI since discharge'); $crud->display_as('mi_date', 'Myocardial infarction date [MI]'); $crud->field_tip('mi_date', 'Indicate the date the patient had the myocardial infarction'); $crud->display_as('stroke', 'Stroke'); $crud->field_tip('stroke', 'Indicate if the patient was diagnosed as having a stroke since discharge, as evidenced by persistent loss of neurological function caused by an ischaemic event.'); $crud->field_tip('stroke_date', 'Indicate the date of stroke'); $crud->display_as('pci', 'Percutaneous coronary intervention date [PCI]'); $crud->field_tip('pci', 'Indicate if the patient had a percutaneous coronary intervention since the date of discharge'); $crud->display_as('pci_date', 'Percutaneous coronary intervention date [PCI] date'); $crud->field_tip('pci_date', 'Indicate the date of PCI'); $crud->display_as('coronary_bypass', 'Coronary artery bypass graft [CABG]'); $crud->field_tip('coronary_bypass', 'Indicate if the patient had a coronary artery bypass graft [CABG] since the date of discharge'); $crud->display_as('coronary_bypass_date', 'Coronary artery bypass graft [CABG] date'); $crud->field_tip('coronary_bypass_date', 'Indicate the date of CABG'); $crud->display_as('cardiac_rehabilitation', 'Cardiac rehabilitation program'); $crud->field_tip('cardiac_rehabilitation', 'Indicate if the patient attended or is attending a cardiac rehabilitation programme since discharge'); //-- 1. Follow Up (30 days and 12 months) $crud->field_tip('aspirin', 'On follow-up indicate if the patient is taking aspirin regularly'); $crud->field_tip('other_antiplatelet', 'On follow-up indicate if the patient is taking antiplatelet medication (other than aspirin) regularly '); $crud->field_tip('anticoagulants', 'On follow-up indicate if the patient is taking anticoagulant medication regularly'); $crud->field_tip('beta_blockers', 'On follow-up indicate if the patient is taking Beta-blockers regularly'); $crud->field_tip('ace_inhibitors', 'On follow-up indicate if the patient is taking ACE inhibitors regularly'); $crud->display_as('angiotensin', 'Angiotensin II receptor blockers'); $crud->field_tip('angiotensin', 'On follow-up indicate if the patient is taking angiotensin II receptor blockers regularly'); $crud->field_tip('diabetic_control', 'On follow-up indicate the main method of diabetic control the patient is regularly receiving'); $crud->field_tip('statins', 'On follow-up indicate if the patient is taking statins regularly'); $crud->display_as('non_statin', 'Non statin lipid lowering agents'); $crud->field_tip('non_statin', 'On follow-up indicate if the patient is non-statin lipid lowering agents regularly'); $crud->field_tip('status', 'Indicate status of intervention insert data process'); $crud->field_tip('notes', 'Indicate notes of intervention insert data process'); // Dropdown menu // -- 1. Follow Up (30 days and 12 months) $crud->field_type('survival_status', 'dropdown', array('Alive' => 'Alive', 'Dead' => 'Dead', 'Unknown' => 'Unknown')); $crud->field_type('death_cause', 'dropdown', array('Cardiovascular' => 'Cardiovascular', 'Non-Cardiovascular' => 'Non-Cardiovascular', 'Unknown' => 'Unknown')); $crud->field_type('anginal_status', 'dropdown', array('CCS 0' => 'CCS 0', 'CCS I' => 'CCS I', 'CCS II' => 'CCS II', 'CCS III' => 'CCS III', 'CCS IV' => 'CCS IV', 'Unknown' => 'Unknown')); $crud->field_type('dyspnoea', 'dropdown', array('NYHA I' => 'NYHA I', 'NYHA II' => 'NYHA II', 'NYHA III' => 'NYHA III', 'NYHA IV' => 'NYHA IV', 'Unknown' => 'Unknown')); $crud->field_type('mi', 'dropdown', array('No' => 'No', 'Yes' => 'Yes', 'Unknown' => 'Unknown')); $crud->field_type('stroke', 'dropdown', array('No' => 'No', 'Yes' => 'Yes', 'Unknown' => 'Unknown')); $crud->field_type('pci', 'dropdown', array('No' => 'No', 'Yes' => 'Yes', 'Unknown' => 'Unknown')); $crud->field_type('coronary_bypass', 'dropdown', array('No' => 'No', 'Yes' => 'Yes', 'Unknown' => 'Unknown')); $crud->field_type('cardiac_rehabilitation', 'dropdown', array('No' => 'No', 'Yes' => 'Yes', 'Unknown' => 'Unknown')); // -- 2. Medication at follow Up (30 days and 12 months) $crud->field_type('aspirin', 'dropdown', array('No' => 'No', 'Yes' => 'Yes', 'Unknown' => 'Unknown')); $crud->field_type('other_antiplatelet', 'dropdown', array('No' => 'No', 'Clopidogrel' => 'Clopidogrel', 'Ticagrelor' => 'Ticagrelor', 'Prasugrel' => 'Prasugrel', 'Other antiplatelet agent' => 'Other antiplatelet agent', 'Unknown' => 'Unknown')); $crud->field_type('anticoagulants', 'dropdown', array('No' => 'No', 'Vit. K antagonists' => 'Vit. K antagonists', 'Oral throbin inhibitors' => 'Oral throbin inhibitors', 'Oral factor Xa inhibitors' => 'Oral factor Xa inhibitors', 'Other anticoagulants agents' => 'Other anticoagulant agent', 'Unknown' => 'Unknown')); $crud->field_type('beta_blockers', 'dropdown', array('No' => 'No', 'Yes' => 'Yes', 'Unknown' => 'Unknown ')); $crud->field_type('ace_inhibitors', 'dropdown', array('No' => 'No', 'Yes' => 'Yes', 'Unknown' => 'Unknown ')); $crud->field_type('angiotensin', 'dropdown', array('No' => 'No', 'Yes' => 'Yes', 'Unknown' => 'Unknown ')); $crud->field_type('statins', 'dropdown', array('No' => 'No', 'Yes' => 'Yes', 'Unknown' => 'Unknown ')); $crud->field_type('diabetic_control', 'dropdown', array('None' => 'None', 'Insulin and oral agent' => 'Insulin and oral agent', 'Insulin' => 'Insulin', 'Oral agent' => 'Oral Agent', 'Diet only' => 'Diet only', 'Unknown' => 'Unknown')); $crud->field_type('non_statin', 'dropdown', array('None' => 'None', 'Ezetimibe' => 'Ezetimibe', 'Fibrates' => 'Fibrates', 'Unknown' => 'Unknown ')); $crud->field_type('status', 'dropdown', array('In progress' => 'In progress', 'Finished' => 'Finished', 'Delete' => 'Delete')); $output = $crud->render(); $nume = ""; $prenume = ""; // aduc din baza de date prin model tabela pacient if (!empty($_GET["p_id"])) { $result = $this->patient_model->get(['id' => $pid]); $nume = $result[0]['first_name']; $prenume = $result[0]['last_name']; } // extrag din array nume si prenume // trimit prin variabila extra din obiect in view $output->extra = $nume . " " . $prenume; $this->_admin_output($output); }
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 suivie_window($id) { $this->id_psy = $id; $this->db->select('sos_psy.id_from_femme'); $this->db->where('id_psy', $this->id_psy); $query = $this->db->get('sos_psy'); $row_psy = $query->row(); $this->id_femme = $row_psy->id_from_femme; try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->where('id_from_femme', $this->id_femme); $crud->where('rdv', 4); $crud->set_table('sos_demande'); $crud->set_subject('Demande'); //relations //Master/child relations //Visual $crud->columns('date_entry', 'visite', 'commentaire_psy'); //unsets $crud->unset_fields('id_demande', 'date_entry', 'dump', 'visite', 'accueil', 'informations', 'conseil', 'orientation', 'rdv', 'hebergement', 'logement', 'aide_materielle', 'adresse_postale', 'accompagnement_exterieur', 'commentaire'); $crud->unset_delete(); $crud->unset_add(); if (!$this->session->userdata('status')) { $crud->unset_export(); $crud->unset_print(); } //Requireds //$crud->required_fields('visite'); //Callbacks $crud->callback_column('date_entry', array($this, 'date_entry')); $crud->callback_column('commentaire_psy', array($this, 'commentaire_psy')); $crud->callback_after_update(array($this, 'insert_after')); $crud->callback_after_insert(array($this, 'insert_after_insert')); //field Types $crud->field_type('id_from_femme', 'hidden', $this->id_femme); $crud->field_type('id_user', 'hidden', $this->session->userdata('userid')); // Actions // Renders $output = $crud->render(); $menu = new stdClass(); $menu->id = $this->id_femme; if ($this->session->userdata('status') != '0') { $menu->lien1 = true; $menu->lien1_2 = true; $menu->lien2 = true; $menu->lien2_1 = true; $menu->lien3 = true; $menu->lien3_1 = true; $menu->lien3_1_1 = true; $menu->lien3_1_2 = true; $menu->lien3_1_3 = true; $menu->lien3_1_4 = true; $menu->lien3_1_5 = true; $menu->lien3_2 = true; $menu->lien3_2_1 = true; $menu->lien3_2_2 = true; $menu->lien3_2_3 = true; } else { $menu->lien1 = true; $menu->lien1_2 = true; $menu->lien2 = true; $menu->lien2_1 = 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()); } }
function scholarship_payments($scholarship_id) { //select the next payment number $result = $this->max_payment_number(); if ($result != NULL) { foreach ($result as $row) { $number = $row->number; $number++; //go to the next number if ($number == 1) { $number = "SPN0001"; } $payment_number = $number; } } else { //start generating payment numbers $payment_number = "SPN0001"; } $crud = new grocery_CRUD(); $crud->where("scholarship_id", $scholarship_id); $crud->set_subject('Payment'); $crud->set_table('payment'); $crud->columns('payment_date', 'payment_number', 'payment_type_id', 'bankslip_number', 'payment_amount', 'payment_units'); $crud->add_action('Print', base_url() . 'img/icons/icon-48-print.png', 'front_office/scholarship_print'); //$crud->set_relation('scholarship_id', 'scholarship', 'scholarship_name'); $crud->set_relation('payment_type_id', 'payment_type', 'payment_type_name'); $crud->fields('payment_number', 'scholarship_id', 'payment_type_id', 'bankslip_number', 'payment_amount', 'payment_units'); $crud->field_type('payment_number', 'hidden', $payment_number); $crud->field_type('scholarship_id', 'hidden', $scholarship_id); $crud->display_as('payment_date', 'Date'); $crud->display_as('payment_number', 'Receipt Number'); $crud->display_as('payment_amount', 'Amount'); $crud->display_as('payment_units', 'Quantity'); $crud->display_as('scholarship_id', 'Sponsor'); $crud->display_as('payment_type_id', 'Payment Type'); $crud->required_fields('payment_amount', 'payment_units'); $_SESSION['table'] = "payment"; $_SESSION['scholarship_id'] = $scholarship_id; $crud->callback_delete(array($this, 'delete_log')); $crud->callback_after_insert(array($this, 'update_sponsored_residents')); $output = $crud->render(); $this->_example_output3($output); }
function administracion($ID = NULL, $parent_table = NULL, $fieldID = NULL, $field_show = NULL) { if (!$this->tank_auth->is_logged_in()) { redirect('/auth/login/'); } try { /* Creamos el objeto */ $crud = new grocery_CRUD(); /* Seleccionamos el tema */ //$crud->set_theme('flexigrid'); $crud->set_theme('datatables'); /* Seleccionamos el nombre de la tabla de nuestra base de datos*/ $crud->set_table('product'); /* Le asignamos un nombre */ $crud->set_subject('Producto'); /* Asignamos el idioma español */ $crud->set_language('spanish'); /* ALA - 10/11/2015 : Condiciona invocación maestro detalle */ $state = $crud->getState(); //echo " ID = " . $ID . ", state = " . $state . ", parent_table = " . $parent_table . "FieldID = " . $fieldID; switch ($state) { case 'success': if (is_numeric($ID)) { //echo "success ID = " . $ID . ", state = " . $state; $crud->where($fieldID, $ID); } $crud->set_relation('PrClientID', 'client', 'Ident'); $crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}'); break; case 'list': if (is_numeric($ID)) { //echo "list ID = " . $ID . ", state = " . $state; $crud->where($fieldID, $ID); } $crud->set_relation('PrClientID', 'client', 'Ident'); $crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}'); break; case 'add': if ($parent_table == NULL) { $crud->set_relation('PrClientID', 'client', 'Ident'); $crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}'); } elseif ($parent_table == 'client') { $crud->field_type('PrClientID', 'hidden', $ID); $crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}'); } elseif ($parent_table == 'vendor') { $crud->field_type('PrVendorID', 'hidden', $ID); $crud->set_relation('PrClientID', 'client', 'Ident'); } //echo "add ID = " . $ID . ", state = " . $state; break; case "read": $crud->set_relation('PrClientID', 'client', 'Ident'); $crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}'); } $crud->set_relation('PrProductCatalogID', 'productcatalog', 'Description'); /* Aqui le decimos a grocery que estos campos son obligatorios */ $crud->required_fields('ProductID', 'PrProductCatalogID', 'Contract', 'PrClientID', 'PrVendorID', 'StartDate', 'EndDate', 'Balance'); /* Aqui le indicamos que campos deseamos mostrar */ $crud->columns('ProductID', 'PrProductCatalogID', 'Contract', 'PrClientID', 'PrVendorID', 'StartDate', 'EndDate', 'Balance'); $crud->display_as('ProductID', 'ID'); $crud->display_as('PrProductCatalogID', 'Producto'); $crud->display_as('Contract', 'Contrato'); $crud->display_as('PrClientID', 'Cliente'); $crud->display_as('PrVendorID', 'Vendedor'); $crud->display_as('StartDate', 'Fecha Inicio Vigencia'); $crud->display_as('EndDate', 'Fecha Fin Vigencia'); $crud->display_as('Balance', 'Saldo'); $crud->set_rules('EndDate', 'Fecha Vigencia', 'callback_ValidProd'); //http://www.grocerycrud.com/documentation/options_functions/set_rules $crud->unset_add_fields('Balance'); $crud->unset_edit_fields('Balance'); $crud->add_action('Beneficiarios', base_url() . 'assets/uploads/detalle.png', 'Beneficiary/administracion'); $crud->add_action('Movimientos', base_url() . 'assets/uploads/money.png', 'Charge/administracion'); // Procesos posteriores a la venta $crud->callback_after_insert(array($this, 'Process_Sale')); /* Generamos la tabla */ $output = $crud->render(); /* La cargamos en la vista situada en /applications/views/product/administracion.php */ $this->load->view('Product/administracion', $output); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ //log_message($e->getMessage().' --- '.$e->getTraceAsString()); 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()); } }
function administracion($ID = NULL) { if (!$this->tank_auth->is_logged_in()) { redirect('/auth/login/'); } try { /* Creamos el objeto */ $crud = new grocery_CRUD(); /* Seleccionamos el tema */ $crud->set_theme('flexigrid'); //$crud->set_theme('datatables'); /* Seleccionmos el nombre de la tabla de nuestra base de datos*/ $crud->set_table('charge'); /* Le asignamos un nombre */ $crud->set_subject('Movimientos'); /* Asignamos el idioma español */ $crud->set_language('spanish'); $state = $crud->getState(); switch ($state) { case 'success': if ($ID != NULL && $ID != 'success') { //echo "success ID = " . $ID . ", state = " . $state; $crud->where('ProductID', $ID); } break; case 'list': if ($ID != NULL) { //echo "list ID = " . $ID . ", state = " . $state; $crud->where('ProductID', $ID); } break; case 'add': if ($ID != "add") { $crud->field_type('ProductID', 'hidden', $ID); } else { $crud->set_relation('ProductID', 'product', 'ProductID'); } //echo "add ID = " . $ID . ", state = " . $state; break; default: //echo "default ID = " . $ID . ", state = " . $state; $crud->set_relation('ProductID', 'product', 'ProductID'); } $crud->set_relation('MethodID', 'method', 'Description'); $crud->set_relation('ChConceptID', 'concept', 'Description'); /* Aqui le decimos a grocery que estos campos son obligatorios */ $crud->required_fields('ChargeID', 'ProductID', 'Reference', 'ChargeDate', 'ChargeType', 'ChConceptID', 'Value', 'MethodID', 'Entity'); /* Aqui le indicamos que campos deseamos mostrar */ $crud->columns('ChargeID', 'ProductID', 'Reference', 'ChargeDate', 'ChargeType', 'ChConceptID', 'Value', 'MethodID', 'Entity', 'Comment'); $crud->display_as('ChargeID', 'ID'); $crud->display_as('ProductID', 'Producto'); $crud->display_as('Reference', 'Referencia'); $crud->display_as('ChargeDate', 'Fecha Movimiento'); $crud->display_as('ChargeType', 'Tipo Movimiento'); $crud->display_as('ChConceptID', 'Concepto'); $crud->display_as('Value', 'Valor'); $crud->display_as('MethodID', 'Metodo'); $crud->display_as('Entity', 'Entidad'); $crud->display_as('Comment', 'Comentario'); $crud->set_rules('Value', 'Valor', 'numeric|greater_than[0]|callback_ValidBalance'); //http://www.grocerycrud.com/documentation/options_functions/set_rules $crud->set_rules('ChargeType', 'Tipo Movimiento', 'in_list[Credito]'); // Log User_ID $crud->callback_before_insert(array($this, 'Set_User_ID')); // Procesos posteriores al registro del movimiento $crud->callback_after_insert(array($this, 'ProcessCharge')); // No permite borrado, actualizacion de movimientos $crud->change_field_type('user_id', 'invisible'); $crud->unset_delete(); $crud->unset_edit(); //$crud->set_rules('Value', 'Valor', 'callback_ValidBalance'); /* Generamos la tabla */ $output = $crud->render(); /* La cargamos en la vista situada en */ $this->load->view('Charge/administracion', $output); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
function cars() { if ($this->session->userdata('perfil') == 'worker' || $this->session->userdata('perfil') == 'admin' || $this->session->userdata('perfil') == 'owner') { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('autos'); $crud->set_subject('Autos'); $crud->columns('id_taller', 'id_sucursales', 'id_usuarios', 'auto_marca', 'auto_placa', 'auto_km'); $crud->fields('id_taller', 'id_sucursales', 'id_usuarios', 'auto_marca', 'auto_placa', 'auto_km', 'auto_logindate'); $crud->required_fields('id_sucursales', 'id_usuario', 'auto_marca', 'auto_placa', 'auto_km'); $crud->display_as('id_usuarios', 'Dueño'); $crud->display_as('auto_marca', 'Marca'); $crud->display_as('auto_placa', 'Placa'); $crud->display_as('auto_km', 'Kilometraje'); $crud->display_as('id_sucursales', 'Sucursal'); $crud->change_field_type('auto_logindate', 'hidden'); if ($this->session->userdata('perfil') == 'admin') { $crud->set_relation('id_taller', 'talleres', 'taller_nombre'); $crud->set_relation('id_sucursales', 'sucursales', 'sucursal_nombre'); $crud->set_relation('id_usuarios', 'usuarios', 'usuario_nombres', 'usuario_perfil IN ("car_owner")'); } else { $crud->set_relation('id_taller', 'talleres', 'taller_nombre', 'id_taller IN ("' . $this->session->userdata('id_taller') . '")'); $crud->set_relation('id_sucursales', 'sucursales', 'sucursal_nombre', 'id_taller IN ("' . $this->session->userdata('id_taller') . '")'); $crud->set_relation('id_usuarios', 'usuarios', 'usuario_nombres', 'id_taller IN ("' . $this->session->userdata('id_taller') . '") and usuario_perfil IN ("car_owner")'); } //$crud->callback_add_field('auto_logindate',array($this,'set_password_input_to_empty')); $crud->callback_after_insert(array($this, 'log_car_after_insert')); $crud->where('usuario_perfil =', 'car_owner'); $crud->order_by('id_taller,usuario_nombres'); if ($this->session->userdata('perfil') != 'admin') { $crud->where('taller_nombre =', $this->session->userdata('nombre_taller')); } $output = $crud->render(); //$output -> op = 'user_management'; $this->_example_output($output); } else { $this->close(); } }
public function bitacora() { if ($this->session->userdata('nivel') < 5) { $this->session->set_flashdata('error', 'Su nivel no le permite realizar este proceso'); redirect(site_url("index/principal"), 301); } $anio = array(); for ($i = date('Y'); $i >= date("Y") - 1; $i--) { $anio[$i] = $i; } $semana = array(); for ($i = 1; $i <= 53; $i++) { $semana[$i] = $i; } $where = array('diresa' => $this->session->userdata('diresa')); $crud = new grocery_CRUD(); $crud->set_table('bitacora'); $crud->columns('ano', 'semana', 'diresa', 'individual', 'edas', 'iras', 'brotes', 'inmuno', 'cobertura', 'usuario', 'fechaReg'); $crud->where($where); $crud->display_as('ano', 'Año')->display_as('inmuno', 'Inmunoprevenibles')->display_as('fechaReg', 'Registro'); $crud->set_subject('Anexo'); $crud->set_relation('diresa', 'diresas', 'nombre', array('codigo' => $this->session->userdata('diresa'))); $crud->field_type('ano', 'dropdown', $anio); $crud->field_type('semana', 'dropdown', $semana); $crud->set_rules('diresa', 'DIRESA', 'required|xss'); $crud->set_rules('ano', 'Año', 'required|numeric|xss'); $crud->set_rules('semana', 'Semana', 'required|numeric|xss'); $crud->set_rules('individual', 'Individual', 'required|xss'); $crud->set_rules('edas', 'EDAs', 'required|xss'); $crud->set_rules('iras', 'IRAs', 'required|xss'); $crud->set_rules('brotes', 'Sección Brotes', 'required|xss'); $crud->set_rules('inmuno', 'Sección Inmunoprevenibles', 'required|xss'); $crud->set_rules('cobertura', 'Cobertura', 'required|xss'); $crud->callback_add_field('individual', array($this, 'insertarIndividual')); $crud->callback_add_field('edas', array($this, 'insertarEdas')); $crud->callback_add_field('iras', array($this, 'insertarIras')); $crud->callback_add_field('cobertura', array($this, 'insertarCobertura')); $crud->callback_add_field('usuario', array($this, 'insertarUsuario')); $crud->callback_add_field('fechaReg', array($this, 'insertarFecha')); $crud->callback_after_insert(array($this, 'ingresaBitacora')); $output = $crud->render(); $this->_example_output4($output); }
function detail_kelompok_management() { $session = isset($_SESSION['username_belajar']) ? $_SESSION['username_belajar'] : ''; if ($session != "") { $pecah = explode("|", $session); $data["NIM"] = $pecah[0]; $data["NAMA"] = $pecah[1]; $data["STATUS"] = $pecah[3]; if ($data["STATUS"] == "Admin") { $crud = new grocery_CRUD(); $crud->set_language("indonesian"); $crud->set_theme('datatables'); $crud->set_table('KKN_DETAIL_KELOMPOK'); $crud->set_relation('ID_KELOMPOK', 'KKN_KELOMPOK', 'NAMA_KELOMPOK'); $crud->display_as('ID_KELOMPOK', 'Nama Kelompok'); $crud->unset_edit(); $crud->add_fields('ID_KELOMPOK', 'NO'); $crud->edit_fields('ID_KELOMPOK', 'NO'); $crud->set_relation('NO', 'KKN_MHS', '{NIM} , {JK}, {FAK}', array('SUDAH' => '2')); // $crud->set_relation('user_id','users','username',array('status' => 'active')); $crud->display_as('NO', 'Mahasiswa | Jenis Kelamin | Fakultas'); $crud->columns('ID_KELOMPOK', 'NO'); $crud->required_fields('ID_KELOMPOK', 'NO'); //$crud->fields('ID_KELOMPOK', 'FAKULTAS'); $crud->callback_after_insert(array($this, 'set_sudah_jadi_tiga')); $crud->callback_after_delete(array($this, 'set_sudah_jadi_dua')); $output = $crud->render(); $this->_manage_output($output); } else { ?> <script type="text/javascript" language="javascript"> alert("Anda tidak berhak masuk ke Control Panel Admin...!!!"); </script> <?php echo "<meta http-equiv='refresh' content='0; url=" . base_url() . "kkn'>"; } } else { ?> <script type="text/javascript" language="javascript"> alert("Anda belum Log In...!!!\nAnda harus Log In untuk mengakses halaman ini...!!!"); </script> <?php echo "<meta http-equiv='refresh' content='0; url=" . base_url() . "kkn'>"; } }
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 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()); } }
function main() { $user_login = $this->ion_auth->user()->row(); $colid = $user_login->col_id; $userId = $user_login->user_id; $state_id = $user_login->state_id; $user_groups = $this->ion_auth->get_users_groups($userId)->row(); $ul_type = $user_groups->ul_type; $user_id = $this->session->userdata('user_id'); $crud = new grocery_CRUD(); $crud->set_table('announcement'); $crud->set_subject('pengumuman'); $crud->unset_delete(); $crud->callback_delete(array($this, 'delete_ann')); $crud->unset_columns('ann_status_push'); if ($ul_type == 'KV') { $crud->set_primary_key('ann_id', 'announcement_college'); $crud->set_relation('user_id', 'user', 'user_name'); $crud->set_relation('ann_id', 'announcement_college', 'col_id'); $crud->set_relation_n_n('Kolej', 'announcement_college', 'college', 'ann_id', 'col_id', 'col_name'); // $crud->callback_add_field('Kolej',array($this,'add_field_kolej')); $crud->callback_after_insert(array($this, 'insert_announcement_college')); $crud->field_type('ann_open_date', 'date'); $crud->field_type('ann_close_date', 'date'); $crud->field_type('user_id', 'hidden', $userId); $crud->field_type('ann_status_push', 'hidden', 1); $crud->field_type('ann_status', 'dropdown', array('1' => 'Aktif', '0' => 'Tak Aktif')); $crud->display_as('ann_title', 'Perkara')->display_as('ann_id', 'Id')->display_as('ann_content', 'Pengumuman')->display_as('ann_open_date', 'Tarikh Mula')->display_as('ann_close_date', 'Tarikh Akhir')->display_as('ann_status', 'Status Pengumuman')->display_as('user_id', 'Pengguna')->display_as('college', 'Kolej Vokasional'); // $crud->callback_field('ann_title',array($this,'fc_ann_tite')); - FDP // $crud->callback_field('ann_content',array($this,'fc_ann_content')); - FDP // $crud->callback_field('ann_open_date',array($this,'fc_ann_open_date')); - FDP // $crud->callback_field('ann_close_date',array($this,'fc_ann_close_date')); - FDP // $crud->callback_field('ann_status',array($this,'fc_ann_status')); - FDP // $crud->callback_field('college',array($this,'fc_college')); - FDP $crud->where('j7f822d59.col_id', $colid); $crud->unset_fields('Kolej'); $crud->required_fields('ann_title', 'ann_content', 'ann_open_date', 'ann_close_date', 'ann_status'); } elseif ($ul_type == 'LP') { $crud->set_relation('user_id', 'user', 'user_name'); $crud->set_relation_n_n('Kolej', 'announcement_college', 'college', 'ann_id', 'col_id', 'col_name'); $crud->callback_after_insert(array($this, 'insert_announcement_college')); $crud->field_type('ann_open_date', 'date'); $crud->field_type('ann_close_date', 'date'); $crud->field_type('user_id', 'hidden', $user_id); $crud->field_type('ann_status_push', 'hidden', 1); $crud->field_type('ann_status', 'dropdown', array('1' => 'Aktif', '0' => 'Tak Aktif')); $crud->display_as('ann_title', 'Perkara')->display_as('ann_content', 'Pengumuman')->display_as('ann_open_date', 'Tarikh Mula')->display_as('ann_close_date', 'Tarikh Akhir')->display_as('ann_status', 'Status Pengumuman')->display_as('user_id', 'Pengguna')->display_as('college', 'Kolej Vokasional'); // $crud->callback_field('ann_title',array($this,'fc_ann_tite')); - FDP // $crud->callback_field('ann_content',array($this,'fc_ann_content')); - FDP // $crud->callback_field('ann_open_date',array($this,'fc_ann_open_date')); - FDP // $crud->callback_field('ann_close_date',array($this,'fc_ann_close_date')); - FDP // $crud->callback_field('ann_status',array($this,'fc_ann_status')); - FDP // $crud->callback_field('college',array($this,'fc_college')); - FDP $crud->required_fields('ann_title', 'ann_content', 'ann_open_date', 'ann_close_date', 'ann_status'); } $output = $crud->render(); $js = '<script>$(document).ready(function() { $("#addStudent").validationEngine(); });</script>'; $header = $js . "<legend><h3>Penyenggaraan Pengumuman</h3></legend>"; $this->_main_output($output, $header); }
public function callback_after_insert($callback = null,$override_all=0){ if(!$override_all){ $this->callback_after_insert_ext[] = $callback; if($this->callback_after_insert == null){ $this->callback_after_insert = array($this,'extended_callback_after_insert'); } }else{ parent::callback_after_insert($callback); } return $this; }
public function demarche_window($id) { $this->id_femme = $id; try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->where('id_from_femme_demarche', $id); $crud->set_table('sos_demarche'); $crud->set_subject('Démarche'); //relations // $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_n_n('ordonnance_de_protection', 'sos_relation_ordonnance_de_protection', 'sos_gen_ordonnance_de_protection', 'id_from_demarche', 'id_from_ordonnance_de_protection', 'name_ordonnance_de_protection'); $crud->set_relation_n_n('suites_de_plainte', 'sos_relation_suites_de_plainte', 'sos_gen_suites_de_plainte', 'id_from_demarche', 'id_from_suites_de_plainte', 'name_suites_de_plainte', 'priority'); //Master/child relations // $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_demarche', 'main_table_primary' => 'id_demarche', 'url' => base_url() . 'index.php/demarche/demarche_window/'); $categories_demarche = new gc_dependent_select($crud, $fields_demarche, $config_demarche); $js_demarche = $categories_demarche->get_js(); //Visual $crud->columns('date_entry', 'date_evenement', 'demarche', 'commentaire', 'upload', 'file_url', 'ordonnance_de_protection', 'suites_de_plainte'); $crud->display_as('upload', 'Type du Document'); $crud->display_as('file_url', 'Document'); $crud->display_as('date_evenement', 'Date évenement'); $crud->display_as('first', 'Type de démarche'); $crud->display_as('second', 'Type d\'intervention'); $crud->display_as('third', 'Suites'); $crud->display_as('date_entry', 'Date de saisie'); //unsets $crud->unset_fields('file_url', 'date_entry'); if (!$this->session->userdata('status')) { $crud->unset_export(); $crud->unset_print(); } //Requireds $crud->required_fields('first'); //Callbacks $crud->callback_before_update(array($this, 'before_update')); $crud->callback_after_update(array($this, 'insert_after_update')); $crud->callback_after_insert(array($this, 'insert_after_insert')); $crud->callback_column('demarche', array($this, 'demarche')); $crud->callback_column('commentaire', array($this, 'commentaire')); $crud->callback_column('ordonnance_de_protection', array($this, 'ordonnance_de_protection')); $crud->callback_column('suites_de_plainte', array($this, 'suites_de_plainte')); $crud->callback_column('date_entry', array($this, 'date_entry')); //field Types $crud->field_type('id_from_femme_demarche', 'hidden', $this->id_femme); $crud->field_type('id_user', 'hidden', $this->session->userdata('userid')); if (!is_dir($path = 'assets/uploads/files/image_' . $this->id_femme)) { mkdir($path = 'assets/uploads/files/image_' . $this->id_femme); } $crud->set_field_upload('file_url', 'assets/uploads/files/image_' . $this->id_femme); $this->db->where('id_from_femme', $this->id_femme); $results = $this->db->get('sos_upload')->result(); $upload_multiselect = array(); foreach ($results as $result) { $text_to_show = ""; $this->db->where('id_type_uploads_parrent', $result->type_uploads); $query_type_uploads = $this->db->get('sos_gen_type_uploads_parrent'); if ($query_type_uploads->num_rows == 1) { $row_type_uploads = $query_type_uploads->row(); $text_to_show .= $row_type_uploads->name_type_uploads_parrent; } $this->db->where('id_type_uploads_child', $result->detailles); $query_type_uploads_child = $this->db->get('sos_gen_type_uploads_child'); if ($query_type_uploads_child->num_rows == 1) { $row_type_uploads_child = $query_type_uploads_child->row(); $text_to_show .= '->' . $row_type_uploads_child->name_type_uploads_child; } $text_to_show .= ' le ' . $result->date_entry; $upload_multiselect[$result->id_upload] = $text_to_show; } if (count($upload_multiselect)) { $crud->field_type('upload', 'dropdown', $upload_multiselect); } else { $crud->field_type('upload', 'hidden', ''); } // Actions // Renders $output = $crud->render(); $output->output .= $js_demarche; $menu = new stdClass(); $menu->n1 = true; $menu->status = false; $menu->status = $this->session->userdata('status'); $this->db->where('id_femme', $this->id_femme); $query = $this->db->get('sos_femme'); if ($query->num_rows == 1) { $row_femme = $query->row(); } $header = $this->navigation->home_f($menu) . ' ' . '<p><pre>' . $row_femme->prenom . ' ' . $row_femme->nom . ' ' . $row_femme->nom_marital . '</pre></p>'; $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }