public function enfants_window($id) { $this->id_demande = $id; try { $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->where('id_from_demande', $this->id_demande); $crud->set_table('sos_enfants'); $crud->set_subject('Enfant'); $crud->unset_add(); $crud->unset_delete(); $crud->field_type('id_from_demande', 'hidden', $this->id_demande); $crud->unset_edit_fields('id_from_kids'); $crud->set_relation('id_from_kids', 'sos_kids', "id_kid"); $crud->set_relation('recu', 'sos_gen_recu', "name_recu", null, 'name_recu ASC'); $crud->set_relation_n_n('accompagniement', 'sos_relation_accompagniement_kid', 'sos_gen_accompagniement_kid', 'id_from_enfants', 'id_from_accompagniement_kid', 'name_accompagniement_kid'); $crud->set_relation_n_n('activite', 'sos_relation_activite_kid', 'sos_gen_activite_kid', 'id_from_enfants', 'id_from_activite_kid', 'name_activite_kid'); $crud->columns('enfant', 'recu', 'activite', 'accompagniement', 'commentaire_enfant'); //$crud->display_as('id_from_kids', 'Enfants'); $crud->display_as('accompagniement', 'Accompagnement'); $crud->display_as('activite', 'Activité'); $crud->display_as('recu', 'Reçu'); $crud->display_as('id_from_kids', 'Enfant(s)'); $crud->display_as('commentaire_enfant', 'Commentaire enfant'); $crud->callback_column('accompagniement', array($this, 'accompagniement')); $crud->callback_column('activite', array($this, 'activite')); $crud->callback_column('enfant', array($this, 'enfant')); $crud->required_fields('recu'); $output = $crud->render(); $this->db->where('id_demande', $this->id_demande); $query = $this->db->get('sos_demande'); if ($query->num_rows == 1) { $row_demande = $query->row(); } // $my_demande = $row_demande->id_from_demande; $menu = new stdClass(); $menu->n3 = true; //$menu->id_1 = $my_demande; $menu->id = $row_demande->id_from_femme; $menu->status = $this->session->userdata('status'); $this->db->where('id_femme', $menu->id); $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()); } }
private function get_crud() { $this->data['message'] = $this->session->flashdata('message'); $crud = new grocery_CRUD(); $crud->set_theme(GROCERY_CRUD_THEME); $crud->set_table('usuario'); $crud->set_subject('Usuário'); $crud->unset_columns('id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3', 'ultima_troca', 'cadastro'); $crud->fields('id', 'nome', 'login', 'email', 'grupos', 'tipo_usuario_id', 'situacao_usuario_id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3'); $crud->unset_texteditor('id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3', 'ultima_troca', 'cadastro'); $crud->change_field_type('id', 'invisible'); $crud->change_field_type('senha', 'invisible'); $crud->change_field_type('senha_anterior1', 'invisible'); $crud->change_field_type('senha_anterior2', 'invisible'); $crud->change_field_type('senha_anterior3', 'invisible'); $crud->set_relation('situacao_usuario_id', 'situacao_usuario', 'descricao'); $crud->display_as('situacao_usuario_id', 'Situacao'); $crud->set_relation('tipo_usuario_id', 'tipo_usuario', 'descricao'); $crud->display_as('tipo_usuario_id', 'Tipo de Usuário'); $crud->set_relation_n_n('grupos', 'grupo_usuario_x_usuario', 'grupo_usuario', 'usuario_id', 'grupo_usuario_id', 'descricao'); /* regras e campos obrigatórios */ $crud->required_fields('login', 'grupos', 'tipo_usuario_id', 'situacao_usuario_id'); $crud->set_rules('login', 'Login', 'required|min_length[2]'); $crud->set_rules('grupos', 'Grupos', 'required'); $crud->set_rules('tipo_usuario_id', 'Tipo de Usuário', 'required'); $crud->set_rules('situacao_usuario_id', 'Situação do Usuário', 'required'); $crud->callback_before_insert(array($this, 'checking_new_user')); return $crud->render(); }
function administration() { try { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('news'); $crud->set_subject('Noticias'); $crud->set_language('spanish'); $crud->unset_export(); $crud->columns('title', 'author', 'summary', 'date_time', 'active'); $crud->required_fields('title', 'author', 'fk_source', 'date_time', 'priority', 'category', 'tags'); // $crud->add_fields('title', 'author', 'image', 'footer_text', 'date_time', 'url', 'summary', 'text', 'fk_source', 'priority', 'active', 'category', 'tags', 'img'); $crud->set_relation('fk_source', 'sources', 'name'); $crud->set_relation_n_n('category', 'news_categories', 'categories', 'fk_news', 'fk_category', 'category'); $crud->set_relation_n_n('tags', 'news_tags', 'tags', 'fk_news', 'fk_tag', 'tag'); $crud->set_field_upload('image', 'assets/uploads/news/'); $crud->display_as('title', 'Título')->display_as('summary', 'Sumario')->display_as('text', 'Texto')->display_as('author', 'Autor')->display_as('date_time', 'Fecha')->display_as('active', 'Estado')->display_as('comment_url', 'URL')->display_as('comment_count', 'Comentarios')->display_as('category', 'Categoría')->display_as('tags', 'Palabras Claves')->display_as('image', 'Imagen principal')->display_as('priority', 'Prioridad')->display_as('fk_source', 'Fuente')->display_as('img', 'Imágenes Adicionales')->display_as('footer_text', 'Texto de imagen'); $crud->set_relation_n_n('img', 'news_image', 'images', 'fk_news', 'fk_image', 'image'); // $crud->set_field_upload('img', 'assets/uploads/news/'); // $crud->set_field_upload('img', 'uploads/news/'); // $crud->callback_add_field('img', array($this, 'add_field_image_callback')); // $crud->callback_edit_field('img', array($this, 'edit_field_image_callback')); /* Generamos la tabla */ // $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 cachamos el error y lo mostramos */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function psy_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', $this->id_femme); $crud->set_table('sos_psy'); $crud->set_subject('Accompagnement Psychologique'); //relations $crud->set_relation_n_n('troubles_physiologiques', 'sos_relation_troubles_physiologiques', 'sos_gen_troubles_physiologiques', 'id_from_psy', 'id_from_troubles_physiologiques', 'name_troubles_physiologiques', 'priority'); $crud->set_relation_n_n('troubles_cognitifs', 'sos_relation_troubles_cognitifs', 'sos_gen_troubles_cognitifs', 'id_from_psy', 'id_from_troubles_cognitifs', 'name_troubles_cognitifs', 'priority'); $crud->set_relation_n_n('troubles_emotionnels', 'sos_relation_troubles_emotionnels', 'sos_gen_troubles_emotionnels', 'id_from_psy', 'id_from_troubles_emotionnels', 'name_troubles_emotionnels', 'priority'); //Visual $crud->columns('troubles_physiologiques', 'troubles_cognitifs', 'troubles_emotionnels'); $crud->display_as('troubles_emotionnels', 'Troubles émotionnels'); //unsets $crud->unset_delete(); $crud->unset_add(); //Requireds //Callbacks $crud->callback_column('troubles_physiologiques', array($this, 'troubles_physiologiques')); $crud->callback_column('troubles_cognitifs', array($this, 'troubles_cognitifs')); $crud->callback_column('troubles_emotionnels', array($this, 'troubles_emotionnels')); //field Types $crud->field_type('id_from_femme', 'hidden', $this->id_femme); // Actions // 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()); } }
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 category() { $crud = new grocery_CRUD(); $crud->set_table('blog_category'); $crud->columns('category_name', 'description'); $crud->edit_fields('category_name', 'description'); $crud->add_fields('category_name', 'description'); $crud->display_as('category_name', 'Category')->display_as('description', 'Description'); $crud->set_subject('Category'); $crud->set_relation_n_n('Articles', 'blog_category_article', 'blog_article', 'category_id', 'article_id', 'article_title'); $output = $crud->render(); $this->view('grocery_CRUD', $output, 'blog_category'); }
function machines_management() { $crud = new grocery_CRUD(); $crud->set_table('maquinas'); $crud->set_theme('datatables'); $crud->columns('nombre', 'procesos'); $crud->edit_fields('nombre', 'procesos'); $crud->add_fields('nombre', 'procesos'); $crud->set_subject('Maquina'); $crud->set_relation_n_n('procesos', 'maquinas_procesos', 'procesos', 'id_maquina', 'id_proceso', 'nombre'); $crud->unset_delete(); $output = $crud->render(); $this->_output_crud($output, 'Maquinas'); }
public function get_crud_add_mod_usuarios() { $this->config->load('grocery_crud'); $this->config->set_item('grocery_crud_dialog_forms', true); $crud = new grocery_CRUD(); $crud->set_theme('datatables2'); $crud->set_relation('id_tipopersona', 'gp_tipopersona', 'typo_persona'); $crud->set_relation('id_departamento', 'gp_departamentos', 'nombre_depart', array('estado_dep' => '1')); $crud->set_relation_n_n('modulos', 'gp_mod_persona', 'gp_modulos', 'id_persona', 'id_modulo', 'modulos'); $crud->set_table('gp_persona'); // $crud->callback_column('modulos', array($this, 'view_modulos')); $crud->callback_column('add_modulos', array($this, 'add_modulos')); $columns = array('cedula', 'nombres', 'apellidos', 'id_tipopersona', 'id_departamento', 'modulos', 'add_modulos'); $crud->columns2($columns); $crud->set_subject('Estudiante'); $crud->unset_add()->unset_delete()->unset_edit(); $output = $crud->render(); $this->load->view('crud/crud_view_datatable', $output); }
public function index() { $crud = new grocery_CRUD(); $crud->set_table('usrmgr'); $crud->change_field_type('password', 'password'); $crud->callback_edit_field('password', array($this, 'decrypt_password_callback')); $crud->columns('username', 'nama_lengkap', 'email', 'level', 'blokir'); $crud->callback_before_insert(array($this, 'encrypt_password_callback')); $crud->callback_before_update(array($this, 'encrypt_password_callback')); $crud->set_subject('Users'); $crud->fields('nama_lengkap', 'username', 'password', 'email', 'level', 'access_control', 'blokir'); $crud->required_fields('nama_lengkap', 'username', 'level', 'blokir'); $crud->set_relation_n_n('access_control', 'usrmgr_access', 'modul', 'id_users', 'id_modul', 'nama_modul', 'priority'); //$crud->set_relation('salesRepEmployeeNumber','employees','lastName'); $output = $crud->render(); $data['subject'] = 'Pengaturan Pengguna'; $data['content'] = $this->load->view('crud.php', $output, true); $this->load->view('base_theme', $data); }
public function listSurat() { $crud = new grocery_CRUD(); $crud->set_table('surat'); //nama table yg akan di list $crud->set_subject('Surat'); //deskripsi tombol $crud->columns('nomorSurat', 'perihal', 'tanggal', 'idInstansi', 'idSifatSurat', 'fileAttach', 'Distribusi'); //kolom yg akan ditampilkan $crud->set_relation('idInstansi', 'instansi', 'namaInstansi'); //relasi tabel : contoh $crud->set_relation('idSifatSurat', 'sifatSurat', 'SifatSurat'); //relasi tabel dengan tabel type surat $crud->set_field_upload('fileAttach', 'assets/'); //ubah field fileAttach menjadi mode upload $crud->set_relation_n_n('Distribusi', 'distribusi', 'unit', 'id_surat', 'id_unit', 'namaGroup'); $output = $crud->render(); $this->_outputs($output); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('pedidos')->set_subject('Pedidos')->columns('fecharegistro', 'idcliente', 'formadepago', 'montototal'); //$crud -> required_fields('titulo', 'fechainicio', 'habilitado'); //$crud -> unique_fields('nombre','categoria'); //$crud -> set_field_upload('imagen', 'assets/uploads/files'); $crud->unset_texteditor('descripcion', 'full_text'); $crud->set_relation_n_n('productos', 'items', 'producto', 'idpedido', 'idproducto', 'nombre', 'priority'); $crud->display_as('montototal', 'Monto'); $crud->display_as('nombrecliente', 'Nombre cliente'); $crud->display_as('apellido', 'Apellido cliente'); $crud->display_as('formadepago', 'Forma de pago'); $crud->display_as('idcliente', 'Cliente'); $crud->unset_fields('fecharegistro'); $crud->unset_print(); $output = $crud->render(); $this->_example_output($output); }
public function index() { $crud = new grocery_CRUD(); // crud settings $crud->set_theme('bootstrap'); $crud->set_table('user_group'); $crud->set_subject('Gebruikersgroepen'); $crud->columns('name', 'key'); $crud->display_as('name', 'Naam'); $crud->required_fields('name'); $crud->callback_before_insert(array($this, 'before_insert')); $crud->change_field_type('key', 'invisible'); $crud->set_relation_n_n('gebruikers', 'user_x_user_group', 'user', 'user_group_id', 'user_id', 'email'); // render the crud HTML $crud_output = $crud->render(); $this->javascript_files = $crud->get_js_files(); $this->css_files = $crud->get_css_files(); $this->views['content'] = $crud_output->output; $this->_layout(); }
/** * Función para contruir el Grocecy CRUD de la tabla Usuarios */ function abm_usuarios() { //Defino submenu $this->menu['submenuSeleccionado'] = 'Usuarios'; //Creo el objeto crud $crud = new grocery_CRUD(); //Defino Template como datatables. //$crud->set_theme('datatables'); //Defino tabla sobre la que trabajo y tipo de 'Objeto' $crud->set_table('Usuarios'); $crud->set_subject('Usuario'); //Agrego acción para cambiar contraseña. $crud->add_action('Cambiar Contraseña', base_url() . 'assets/grocery_crud/themes/flexigrid/css/images/key.png', 'administracion/usuarios/cambiar_contrasena'); //Un usuario puede tener un idPersonal asociado. $crud->set_relation('idPersonal', 'Personal', 'nombreApellido'); //Relación con los roles. $crud->set_relation_n_n('roles', 'RolesPorUsuario', 'Roles', 'idUsuario', 'idRol', 'descripcion'); //Seteo Reglas para campos $crud->set_rules('contrasena', 'Contraseña', 'required|matches[repetirContrasena]'); $crud->add_fields('nombreUsuario', 'contrasena', 'repetirContrasena', 'roles', 'idPersonal'); $crud->edit_fields('roles', 'idPersonal'); $crud->field_type('contrasena', 'password'); $crud->field_type('repetirContrasena', 'password'); //Seteo campos requeridos $crud->required_fields('nombreUsuario', 'contrasena', 'repetirContrasena', 'roles'); //Defino Columnas a Mostrar $crud->columns('nombreUsuario', 'roles'); //Defino nombres para cada campo. $crud->display_as('nombreUsuario', 'Nombre de Usuario'); $crud->display_as('contrasena', 'Contraseña'); $crud->display_as('repetirContrasena', 'Repetir Contraseña'); $crud->display_as('roles', 'Roles'); $crud->display_as('idPersonal', 'Persona Asociada'); //Hago 'callbacks' para transformar datos antes de inserción/actualización. $crud->callback_before_insert(array($this, '_transformar_datos')); $crud->callback_before_update(array($this, '_transformar_datos_update')); //Genero el ABM $output = $crud->render(); //Llamo a la función encargada de mostrar el ABM. mostrar_crud($output, '', $this->menu, 'administracion/usuarios/abm_usuarios', '', 'administracion/usuarios/abm_usuarios_final'); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_model('My_Custom_model'); $crud->set_table('ips_ordertracking', 'ips_productitems'); $crud->set_subject('Sales Tracking'); $crud->required_fields('NAME'); // void set_relation_n_n( string $field_name, string $relation_table, string $selection_table, string $primary_key_alias_to_this_table, string $primary_key_alias_to_selection_table , string $title_field_selection_table [ , string $priority_field_relation ] ) $crud->set_relation_n_n('orderdetails', 'ips_ordertracking', 'ips_productitems', 'ips_ordertracking', 'ordertrackingid', 'description', 'category'); // $crud->set_relation('ordertrackingid','ips_productitems','description'); // $crud->columns('ordertrackingid','fullfillment','orderdate','orderid','returnid','itemrece','caseid','product','status','Action'); // $crud->display_as('orderdate','Order Date')->display_as('orderid','Order ID')->display_as('returnid','Sales Return ID')->display_as('itemrece','Item Received')->display_as('caseid','Case ID')->display_as('product','Product Condition')->display_as('ordertrackingid','ID'); $crud->columns('ordertrackingid', 'orderid', 'description', 'category', 'product', 'itemrece', 'cost', 'mrp', 'Action'); $crud->display_as('orderid', 'Order ID')->display_as('itemrece', 'Item Received')->display_as('product', 'Product Condition')->display_as('ordertrackingid', 'ID')->display_as('description', 'Product Name')->display_as('category', 'Category')->display_as('cost', 'Recovery Min')->display_as('mrp', 'Recovery Max'); $crud->callback_column('ordertrackingid', array($this, '_callback_webpage_url')); $crud->callback_column('orderdate', array($this, '_callback_dateformat')); $crud->callback_column('fullfillment', array($this, '_callback_fullfillment')); // $crud->callback_column('product',array($this,'_callback_product')); $crud->callback_column('status', array($this, '_callback_status')); $crud->callback_column('itemrece', array($this, '_callback_itemrece')); $crud->callback_column('cost', array($this, '_callback_recovery_min')); $crud->callback_column('mrp', array($this, '_callback_recovery_max')); $crud->callback_column('Action', array($this, '_callback_viewpage_url')); $crud->unset_edit(); $crud->unset_read(); $crud->unset_delete(); // $crud->callback_after_insert(array($this, 'fullfillmentid_generation')); $output = $crud->render(); $state = $crud->getState(); if ($state == 'add') { redirect('store/addtracking'); } if ($state == 'view') { redirect('store/viewtracking'); } // $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 widget() { $crud = new grocery_CRUD(); $crud->set_table('cms_widget'); $crud->set_subject('Widget'); $crud->columns('widget_name', 'title', 'active', 'is_static', 'description', 'authorization_id', 'slug', 'groups'); $crud->edit_fields('widget_name', 'title', 'active', 'description', 'index', 'is_static', 'static_content', 'url', 'slug', 'authorization_id', 'groups'); $crud->add_fields('widget_name', 'title', 'active', 'description', 'index', 'is_static', 'static_content', 'url', 'slug', 'authorization_id', 'groups'); $crud->change_field_type('active', 'true_false'); $crud->change_field_type('is_static', 'true_false'); $crud->change_field_type('index', 'integer'); $crud->display_as('widget_name', 'Widget Code')->display_as('title', 'Title (What visitor see)')->display_as('active', 'Active')->display_as('description', 'Description')->display_as('url', 'URL (Where is it point to)')->display_as('index', 'Order')->display_as('is_static', 'Static')->display_as('static_content', 'Static Content')->display_as('slug', 'Slug')->display_as('authorization_id', 'Authorization')->display_as('groups', 'Groups'); $crud->unset_texteditor('static_content'); $crud->unset_texteditor('description'); $crud->set_relation('authorization_id', 'cms_authorization', 'authorization_name'); $crud->set_relation_n_n('groups', 'cms_group_widget', 'cms_group', 'widget_id', 'group_id', 'group_name'); $crud->callback_before_insert(array($this, 'before_insert_widget')); $crud->callback_column('active', array($this, 'column_widget_active')); $output = $crud->render(); $this->view('main/widget', $output, 'main_widget_management'); }
public function index() { try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->set_table('sos_ecoute'); $crud->order_by('premier_contact', 'desc'); $crud->set_subject('Ecoute téléphonique'); //relations $crud->set_relation('situation_familiale', 'sos_gen_situation_familiale_parrent', 'name_situation_familiale_parrent'); $crud->set_relation('emplois', 'sos_gen_emplois_parrent', 'name_emplois'); $crud->set_relation('age', 'sos_gen_femme_age', 'name_femme_age'); $crud->set_relation('duree_de_la_relation', 'sos_gen_duree_de_la_relation', 'name_duree_de_la_relation', null, 'id_duree_de_la_relation ASC'); $crud->set_relation('ville', 'sos_gen_villes', '{nom_ville}, {code_postal}', null, 'nom_ville ASC'); $crud->set_relation('nationalite', 'sos_gen_nationalite', 'name_nationalite'); $crud->set_relation('ressources', 'sos_gen_ressources', 'name_ressources'); $crud->set_relation('allocations_familiales', 'sos_gen_allocations_familiales', 'name_allocations_familiales'); $crud->set_relation('logement', 'sos_gen_logement_parent', 'name_logement'); $crud->set_relation('situation_actuelle_depuis', 'sos_gen_situation_actuelle_depuis', 'name_situation_actuelle_depuis', null, 'id_situation_actuelle_depuis ASC'); $crud->set_relation('situation_actuelle', 'sos_gen_situation_actuelle', 'name_situation_actuelle'); $crud->set_relation('situation_actuelle_detailles', 'sos_gen_situation_actuelle_detailles', 'name_situation_actuelle_detailles'); $crud->set_relation('partenaire', 'sos_gen_partenaire', 'name_partenaire'); $crud->set_relation('informations', 'sos_gen_informations', 'name_informations'); $crud->set_relation('rdv', 'sos_gen_rdv', 'name_rdv'); $crud->set_relation('hebergement', 'sos_gen_hebergement', 'name_hebergement'); $crud->set_relation('depuis', 'sos_gen_depuis', 'name_depuis'); $crud->set_relation('temps_ecoute', 'sos_gen_temps_ecoute', 'name_temps_ecoute', null, 'id_temps_ecoute ASC'); $crud->set_relation('interlocuteur', 'sos_gen_interlocuteur', 'name_interlocuteur', null, 'id_interlocuteur ASC'); $crud->set_relation('appel', 'sos_gen_appel', 'name_appel', null, 'id_appel ASC'); $crud->set_relation('frequence', 'sos_gen_frequence', 'name_frequence'); $crud->set_relation('commencement', 'sos_gen_commencement', 'name_commencement'); $crud->set_relation_n_n('violences_physiques', 'sos_relation_violences_physiques_ecoute', 'sos_gen_violences_physiques', 'id_from_violences', 'id_from_violences_physiques', 'name_violences_physiques', 'priority'); $crud->set_relation_n_n('violences_psychologiques', 'sos_relation_violences_psychologiques_ecoute', 'sos_gen_violences_psychologiques', 'id_from_violences', 'id_from_violences_psychologiques', 'name_violences_psychologiques', 'priority'); $crud->set_relation_n_n('violences_sexuelles', 'sos_relation_violences_sexuelles_ecoute', 'sos_gen_violences_sexuelles', 'id_from_violences', 'id_from_violences_sexuelles', 'name_violences_sexuelles', 'priority'); $crud->set_relation_n_n('violences_economiques', 'sos_relation_violences_economiques_ecoute', 'sos_gen_violences_economiques', 'id_from_violences', 'id_from_violences_economiques', 'name_violences_economiques', 'priority'); $crud->set_relation_n_n('violences_administratives', 'sos_relation_violences_administratives_ecoute', 'sos_gen_violences_administratives', 'id_from_violences', 'id_from_violences_administratives', 'name_violences_administratives', 'priority'); $crud->set_relation_n_n('violences_sociales', 'sos_relation_violences_sociales_ecoute', 'sos_gen_violences_sociales', 'id_from_violences', 'id_from_violences_sociales', 'name_violences_sociales', 'priority'); $crud->set_relation_n_n('violences_privations', 'sos_relation_violences_privations_ecoute', 'sos_gen_violences_privations', 'id_from_violences', 'id_from_violences_privations', 'name_violences_privations', 'priority'); $crud->set_relation_n_n('violences_juridiques', 'sos_relation_violences_juridiques_ecoute', 'sos_gen_violences_juridiques', 'id_from_violences', 'id_from_violences_juridiques', 'name_violences_juridiques', 'priority'); $crud->set_relation_n_n('de_la_part', 'sos_relation_de_la_part_ecoute', 'sos_gen_de_la_part', 'id_from_violences', 'id_from_de_la_part', 'name_de_la_part'); $crud->set_relation_n_n('raisons', 'sos_relation_raisons_ecoute', 'sos_gen_raisons', 'id_from_violences', 'id_from_raisons', 'name_raisons'); $crud->set_relation_n_n('violences_enfants_directes', 'sos_relation_violences_enfants_directes_ecoute', 'sos_gen_violences_enfants_directes', 'id_from_violences', 'id_from_violences_enfants_directes', 'name_violences_enfants_directes', 'priority'); $crud->set_relation_n_n('violences_enfants_indirectes', 'sos_relation_violences_enfants_indirectes_ecoute', 'sos_gen_violences_enfants_indirectes', 'id_from_violences', 'id_from_violences_enfants_indirectes', 'name_violences_enfants_indirectes', 'priority'); $crud->set_relation_n_n('de_la_part_enfants', 'sos_relation_de_la_part_enfants_ecoute', 'sos_gen_de_la_part_enfants', 'id_from_violences', 'id_from_de_la_part_enfants', 'name_de_la_part_enfants'); $crud->set_relation_n_n('consequences_physiques', 'sos_relation_consequences_physiques_ecoute', 'sos_gen_consequences_physiques', 'id_from_violences', 'id_from_consequences_physiques', 'name_consequences_physiques', 'priority'); $crud->set_relation_n_n('consequences_psychologiques', 'sos_relation_consequences_psychologiques_ecoute', 'sos_gen_consequences_psychologiques', 'id_from_violences', 'id_from_consequences_psychologiques', 'name_consequences_psychologiques', 'priority'); $crud->set_relation_n_n('consequences_administratives', 'sos_relation_consequences_administratives_ecoute', 'sos_gen_consequences_administratives', 'id_from_violences', 'id_from_consequences_administratives', 'name_consequences_administratives', 'priority'); //Master/child relations $fields_situation_actuelle = array('situation_actuelle' => array('table_name' => 'sos_gen_situation_actuelle', 'title' => 'name_situation_actuelle', 'relate' => null), 'situation_actuelle_detailles' => array('table_name' => 'sos_gen_situation_actuelle_detailles', 'title' => 'name_situation_actuelle_detailles', 'id_field' => 'id_situation_actuelle_detailles', 'relate' => 'id_from_situation_actuelle', 'data-placeholder' => 'Préciser')); $config_situation_actuelle = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'situation_actuelle'); $categories_situation_actuelle = new gc_dependent_select($crud, $fields_situation_actuelle, $config_situation_actuelle); $js_situation_actuelle = $categories_situation_actuelle->get_js(); $fields_demarche = array('first' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser')); // 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/', $config_demarche = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first'); $categories_demarche = new gc_dependent_select($crud, $fields_demarche, $config_demarche); $js_demarche = $categories_demarche->get_js(); $fields_demarche1 = array('first1' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second1' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third1' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser')); // 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/', $config_demarche1 = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first1'); $categories_demarche1 = new gc_dependent_select($crud, $fields_demarche1, $config_demarche1); $js_demarche1 = $categories_demarche1->get_js(); $fields_demarche2 = array('first2' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second2' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third2' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser')); // 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/', $config_demarche2 = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first2'); $categories_demarche2 = new gc_dependent_select($crud, $fields_demarche2, $config_demarche2); $js_demarche2 = $categories_demarche2->get_js(); $crud->set_relation('first', 'sos_gen_demarche_first', 'name_demarche_first'); $crud->set_relation('second', 'sos_gen_demarche_second', 'name_demarche_second'); $crud->set_relation('third', 'sos_gen_demarche_third', 'name_demarche_third'); $crud->set_relation('first1', 'sos_gen_demarche_first', 'name_demarche_first'); $crud->set_relation('second1', 'sos_gen_demarche_second', 'name_demarche_second'); $crud->set_relation('third1', 'sos_gen_demarche_third', 'name_demarche_third'); $crud->set_relation('first2', 'sos_gen_demarche_first', 'name_demarche_first'); $crud->set_relation('second2', 'sos_gen_demarche_second', 'name_demarche_second'); $crud->set_relation('third2', 'sos_gen_demarche_third', 'name_demarche_third'); //Visual $crud->display_as('nationalite', 'Nationalité')->display_as('premier_contact', 'Date')->display_as('duree_de_la_relation', 'Durée de la relation')->display_as('emplois_detailles', 'Détails de l\'emploi')->display_as('emplois_more_detailles', 'Plus de détails de l\'emploi')->display_as('ouvertures', 'Dernière modification')->display_as('hebergement', 'Demande d\'hébergement')->display_as('aide_materielle', 'Demande d\'aide matérielle')->display_as('accueil', 'Demande d\'accueil')->display_as('informations', 'Demande d\'informations')->display_as('conseil', 'Demande de conseil')->display_as('orientation', 'Demande d\'orientation')->display_as('rdv', 'Demande de rdv')->display_as('hebergement', 'Demande d\'hébergement')->display_as('situation_actuelle_detailles', 'Situation actuelle détaillée')->display_as('emplois', 'Situation professionnelle')->display_as('commentaire', 'Commentaires')->display_as('partenaire', 'Orienteur')->display_as('rep_accueil', 'Réponse')->display_as('rep_informations', 'Réponse')->display_as('rep_conseil', 'Réponse')->display_as('rep_orientation', 'Réponse')->display_as('rep_rdv', 'Réponse')->display_as('rep_hebergement', 'Réponse')->display_as('rep_soutien', 'Réponse')->display_as('rep_aide_materielle', 'Réponse')->display_as('rep_ecoute', 'Réponse')->display_as('consequences', 'Conséquences')->display_as('consequences_administratives', 'Conséquences administratives et économiques')->display_as('violences_economiques', 'Violences économiques')->display_as('consequences_physiques', 'Conséquences physiques')->display_as('consequences_psychologiques', 'Conséquences psychologiques')->display_as('consequences_administratives', 'Conséquences administratives')->display_as('de_la_part_enfants', 'Violences sur enfants par')->display_as('temps_ecoute', "Temps d'écoute")->display_as('age', 'Age de la femme')->display_as('logement_dem', 'Demande de logement')->display_as('rep_logement_dem', 'Réponse')->display_as('violences_enfants_directes', 'ENFANTS - Violences directes')->display_as('violences_enfants_indirectes', 'ENFANTS - Violences indirectes')->display_as('frequence', 'Fréquence')->display_as('demandes', 'Demandes/Réponses'); $crud->display_as('first', 'Type de démarche 1'); $crud->display_as('second', 'Type d\'intervention 1'); $crud->display_as('third', 'Suites 1'); $crud->display_as('first1', 'Type de démarche 2'); $crud->display_as('second1', 'Type d\'intervention 2'); $crud->display_as('third1', 'Suites 2'); $crud->display_as('first2', 'Type de démarche 3'); $crud->display_as('second2', 'Type d\'intervention 3'); $crud->display_as('third2', 'Suites 3'); $crud->display_as('demarche', 'Démarches'); //unsets if ($this->session->userdata('status') == '1' or $this->session->userdata('status') == '2' or $this->session->userdata('status') == '3') { $crud->fields('premier_contact', 'interlocuteur', 'appel', 'partenaire', 'temps_ecoute', 'age', 'enfants', 'enceinte', 'ville', 'nationalite', 'situation_familiale', 'depuis', 'duree_de_la_relation', 'emplois', 'logement', 'situation_actuelle', 'situation_actuelle_detailles', 'situation_actuelle_depuis', 'ressources', 'allocations_familiales', 'dettes', 'soutien', 'rep_soutien', 'ecoute', 'rep_ecoute', 'accueil', 'rep_accueil', 'informations', 'rep_informations', 'conseil', 'rep_conseil', 'orientation', 'rep_orientation', 'rdv', 'rep_rdv', 'hebergement', 'rep_hebergement', 'logement_dem', 'rep_logement_dem', 'aide_materielle', 'rep_aide_materielle', 'violences_physiques', 'violences_psychologiques', 'violences_sexuelles', 'violences_economiques', 'violences_administratives', 'violences_sociales', 'violences_privations', 'violences_juridiques', 'de_la_part', 'raisons', 'violences_enfants_directes', 'violences_enfants_indirectes', 'de_la_part_enfants', 'consequences_physiques', 'consequences_psychologiques', 'consequences_administratives', 'frequence', 'commencement', 'first', 'second', 'third', 'first1', 'second1', 'third1', 'first2', 'second2', 'third2', 'commentaire'); } else { $crud->fields('interlocuteur', 'appel', 'partenaire', 'temps_ecoute', 'age', 'enfants', 'enceinte', 'ville', 'nationalite', 'situation_familiale', 'depuis', 'duree_de_la_relation', 'emplois', 'logement', 'situation_actuelle', 'situation_actuelle_detailles', 'situation_actuelle_depuis', 'ressources', 'allocations_familiales', 'dettes', 'soutien', 'rep_soutien', 'ecoute', 'rep_ecoute', 'accueil', 'rep_accueil', 'informations', 'rep_informations', 'conseil', 'rep_conseil', 'orientation', 'rep_orientation', 'rdv', 'rep_rdv', 'hebergement', 'rep_hebergement', 'logement_dem', 'rep_logement_dem', 'aide_materielle', 'rep_aide_materielle', 'violences_physiques', 'violences_psychologiques', 'violences_sexuelles', 'violences_economiques', 'violences_administratives', 'violences_sociales', 'violences_privations', 'violences_juridiques', 'de_la_part', 'raisons', 'violences_enfants_directes', 'violences_enfants_indirectes', 'de_la_part_enfants', 'consequences_physiques', 'consequences_psychologiques', 'consequences_administratives', 'frequence', 'commencement', 'first', 'second', 'third', 'first1', 'second1', 'third1', 'first2', 'second2', 'third2', 'commentaire'); } $crud->unset_add_fields('par'); if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') { $crud->unset_delete(); $crud->unset_export(); $crud->unset_print(); } //Requireds $crud->required_fields('premier_contact', 'appel', 'temps_ecoute', 'interlocuteur'); $crud->columns('premier_contact', 'infos', 'situation', 'demandes', 'violences', 'de_la_part', 'commencement', 'consequences', 'demarche'); //Callbacks $crud->callback_column('ouvertures', array($this, 'ouvertures')); $crud->callback_column('premier_contact', array($this, 'premier_contact')); $crud->callback_column('infos', array($this, 'infos')); $crud->callback_column('situation', array($this, 'situation')); $crud->callback_column('demandes', array($this, 'demandes')); $crud->callback_column('commentaire', array($this, 'commentaire')); $crud->callback_column('demarche', array($this, 'demarche')); $crud->callback_after_update(array($this, 'insert_after_update')); $crud->callback_after_insert(array($this, 'insert_after_insert')); $crud->callback_before_update(array($this, 'before_update')); $crud->callback_column('de_la_part', array($this, 'de_la_part')); $crud->callback_column('raisons', array($this, 'raisons')); $crud->callback_column('violences', array($this, 'violences')); $crud->callback_column('consequences', array($this, 'consequences')); //field Types //$crud->callback_edit_field('accueil', array($this, 'edit_field_callback_1')); //$crud->callback_add_field('accueil', array($this, 'add_field_callback_1')); //field Types $crud->field_type('dettes', 'enum', array('OUI', 'NON')); $crud->field_type('enceinte', 'enum', array('OUI', 'NON')); // $crud->field_type('appel', 'dropdown', array('0' => '', '1' => '1er appel', '2' => 'Appel suivi', '3' => 'Autres appels')); $crud->field_type('enfants', 'enum', array('Aucun', '1 enfant', '2 enfants', '3 enfants', '4 enfants', '5 et +')); // $crud->field_type('interlocuteur', 'dropdown', array('0' => '', '1' => 'Elle-même', '2' => 'Professionnel', '3' => 'Entourage')); // Actions // Renders $output = $crud->render(); $output->output .= $js_situation_actuelle . $js_demarche . $js_demarche1 . $js_demarche2; $menu = new stdClass(); $menu->status = $this->session->userdata('status'); if ($menu->status != 5) { $menu->n1 = true; } else { $menu->n0 = true; } $header = $this->navigation->home_f($menu); $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function violence_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', $this->id_femme); $crud->set_table('sos_violences'); $crud->set_subject('Violence'); //relations $crud->set_relation_n_n('violences_physiques', 'sos_relation_violences_physiques', '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', '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', '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', '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', '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', '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', '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', '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', 'sos_gen_de_la_part', 'id_from_violences', 'id_from_de_la_part', 'name_de_la_part'); $crud->set_relation('frequence', 'sos_gen_frequence', 'name_frequence'); $crud->set_relation('commencement', 'sos_gen_commencement', 'name_commencement'); $crud->set_relation_n_n('raisons', 'sos_relation_raisons', 'sos_gen_raisons', 'id_from_violences', 'id_from_raisons', 'name_raisons'); $crud->set_relation_n_n('violences_enfants_directes', 'sos_relation_violences_enfants_directes', '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', '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', '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', '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', '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', 'sos_gen_consequences_administratives', 'id_from_violences', 'id_from_consequences_administratives', 'name_consequences_administratives', 'priority'); //Visual $crud->columns('violences', 'de_la_part', 'frequence', 'commencement', 'raisons', 'consequences'); $crud->display_as('frequence', 'Fréquence')->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'); //unsets $crud->unset_delete(); $crud->unset_add(); //Requireds //Callbacks $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->field_type('id_from_femme', 'hidden', $this->id_femme); // Actions // 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()); } }
public function search_student1() { $user_login = $this->ion_auth->user()->row(); $colid = $user_login->col_id; $cc_id = $this->m_student_management->get_cc_id_by_col_id($colid); $array_cc_id = ""; foreach ($cc_id as $key) { $array_cc_id .= $key->cc_id . ","; } $array_cc_id = substr($array_cc_id, 0, -1); $nama = $this->input->get('name'); $angka_giliran = $this->input->get('angka_giliran'); $mykad = $this->input->get('mykad'); $course = $this->input->get('kursus'); $result = $this->m_student_management->search_student1($nama, $angka_giliran, $mykad, $course); $crud = new grocery_CRUD(); $crud->set_table('student'); $crud->set_primary_key('cc_id', 'student'); $crud->set_relation_n_n('Course', 'college_course', 'course', 'cc_id', 'cou_id', 'cou_name'); $crud->set_relation_n_n('College', 'college_course', 'college', 'cc_id', "col_ida={$colid}", 'col_name'); // $crud->where('college.col_id',$colid); $crud->columns('stu_mykad', 'stu_name', 'stu_matric_no', 'College', 'Course', 'stu_current_sem'); if ($nama != '') { $crud->or_like('stu_name', $nama, 'both'); } elseif ($angka_giliran != '') { $crud->or_like('stu_matric_no', $angka_giliran, 'both'); } elseif ($mykad != '') { $crud->or_like('stu_mykad', $mykad, 'both'); } elseif ($course != '') { $crud->or_like('cou_name', $course, 'both'); } //Modification Log : 27092013 by Mior - comment 2 line code below because searching not function //$query_where= "temp_cc_id IN ($array_cc_id)"; //$crud -> where($query_where); $crud->callback_column('stu_mykad', array($this, '_callback_webpage_url')); $crud->callback_column('stu_name', array($this, '_callback_webpage_url')); $crud->callback_column('stu_matric_no', array($this, '_callback_webpage_url')); $crud->display_as('stu_mykad', 'MyKad')->display_as('stu_name', 'Nama')->display_as('stu_matric_no', 'Angka Giliran')->display_as('Course', 'Kursus')->display_as('College', 'KV')->display_as('stu_current_sem', 'Semester Sekarang'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $output = $crud->render(); echo $this->_empty_output($output); }
public function film_management() { $crud = new grocery_CRUD(); $crud->set_table('film'); $crud->set_relation_n_n('actors', 'film_actor', 'actor', 'film_id', 'actor_id', 'fullname', 'priority'); $crud->set_relation_n_n('category', 'film_category', 'category', 'film_id', 'category_id', 'name'); $crud->unset_columns('special_features', 'description', 'actors', 'release_year', 'rental_duration', 'rental_rate', 'replacement_cost'); $crud->fields('title', 'description', 'actors', 'category', 'release_year', 'rental_duration', 'rental_rate', 'length', 'replacement_cost', 'rating', 'special_features'); $crud->set_theme('flexigrid'); $output = $crud->render(); $data['judul'] = 'Films'; $data['crumb'] = array('Films' => ''); $template = 'admin_template'; $view = 'grocery'; $this->outputview->output_admin($view, $template, $data, $output); }
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); }
function assign_driver() { try { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('users'); $crud->where('ut_id', 2); $crud->set_relation_n_n('bu_plat', 'driver', 'bus', 'u_id', 'bu_id', 'bu_plat', 'dr_id'); // $crud->set_relation_n_n('lo_name', 'driver', 'location', 'u_id', 'lo_id', 'lo_name', 'dr_id'); $crud->columns('u_fullname', 'bu_plat'); $crud->fields('u_fullname', 'bu_plat'); $crud->display_as('u_fullname', 'Driver Fullname')->display_as('bu_plat', 'Bus Plat'); // ->display_as('lo_name', 'Destination'); $crud->unset_add(); $output = $crud->render(); $this->_example_output('v_mainpage', $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function sub_menu_2($id_header_menu, $level_one, $level_two) { $crud = new grocery_CRUD(); $crud->set_table('menu'); $crud->set_subject('Sub Menu 2'); $crud->where('level_one', $level_one); $crud->where('level_two', $level_two); $crud->change_field_type('id_header_menu', 'invisible'); $crud->change_field_type('level_one', 'invisible'); $crud->change_field_type('level_two', 'invisible'); $crud->order_by('sort', 'ASC'); $crud->set_relation_n_n('Akses', 'groups_menu', 'groups', 'id_menu', 'id_groups', 'name'); $crud->unset_columns('level_one', 'level_two', 'icon', 'menu_id', 'id_header_menu'); $crud->unset_read(); $crud->callback_before_insert(array($this, 'call_sub_menu_2')); $output = $crud->render(); $data['script'] = "\$('#menu-menu').addClass('active');"; $output->data = $data; $data['judul'] = "Sub menu 2"; $data['crumb'] = array('Header menu' => 'crud/header_menu', 'Menu' => 'crud/menu/' . $id_header_menu, 'Sub menu' => 'crud/sub_menu/' . $id_header_menu . '/' . $level_one, 'Sub menu 2' => ''); $template = 'admin_template'; $view = 'grocery'; $this->outputview->output_admin($view, $template, $data, $output); }
function film_management() { $crud = new grocery_CRUD(); $crud->set_table('film'); $crud->set_relation_n_n('actors', 'film_actor', 'actor', 'film_id', 'actor_id', 'fullname', 'priority'); $crud->set_relation_n_n('category', 'film_category', 'category', 'film_id', 'category_id', 'name'); $crud->unset_columns('special_features', 'description'); $crud->fields('title', 'description', 'actors', 'category', 'release_year', 'rental_duration', 'rental_rate', 'length', 'replacement_cost', 'rating', 'special_features'); $output = $crud->render(); $this->_example_output($output); }
public function privilege() { $crud = new grocery_CRUD(); $crud->set_table('cms_privilege'); $crud->set_relation('authorization_id', 'cms_authorization', 'authorization_name', 'groups'); $crud->set_relation_n_n('groups', 'cms_group_privilege', 'cms_group', 'privilege_id', 'group_id', 'group_name'); $output = $crud->render(); $this->view('grocery_CRUD', $output, 'main_privilege_management'); }
function calificaciones() { if (!$this->tank_auth->is_logged_in()) { redirect('/auth/login/'); } else { $crud = new grocery_CRUD(); //$crud->set_theme('datatables'); // Al comentar esta linea, le pones otro estilo a la tabla. $crud->set_table('cct_calificacion_contratista'); $crud->set_subject('Calificaciones por pedido'); // Relacion de 1 a muchos. $crud->set_relation_n_n('contratista', 'con_contratista', 'prv_proveedor', 'con_id', 'con_prv_id', 'prv_nombre'); //$crud->unset_columns('cct_con_id'); $requeridos = array('contratista', 'cct_sol_id', 'cct_nota', 'cct_fecha'); $alias = array('cct_sol_id' => 'Solicitud', 'cct_nota' => 'Nota', 'cct_descripcion' => 'Descripción', 'cct_fecha' => 'Fecha'); $crud->add_fields('contratista', 'cct_sol_id', 'cct_nota', 'cct_descripcion', 'cct_fecha'); $crud->edit_fields('cct_sol_id', 'cct_nota', 'cct_descripcion', 'cct_fecha'); $crud->required_fields($requeridos); //$crud->columns($columnas); $crud->display_as($alias); // Reglas para los Formularios $crud->set_rules('cct_nota', 'nota', 'numeric'); // Datos generales de la pagina $data['menu_sistema'] = true; $data['vista_name'] = 'inventario/index'; // Cuando se necesite usar javascript, venir aca. $data['titulo'] = "Calificaciones"; $data['logo'] = $this->Regional_model->get_parametro("logo"); $info['info_padre'] = $this->sistema_model->get_registro('sio_sistema_opcion', array('sio_id' => 1, 'sio_estado' => 1)); $info['menu_principal'] = $this->sistema_model->get_menu('sic_sistema_catalogo', 1); $data['menus'] = $this->load->view('menu/opciones_menu', $info, true); // Estas tres lineas son principales cuando se desea imprimir un Grocery Crud en el sistema $crud->unset_jquery(); // No llama al jQuery del Grocery Crud $output = $crud->render(); //$this->load->view('sistema/pais',$output); $data['texto'] = $this->load->view('inventario/suministros/calificaciones', $output, true); $this->__cargarVista($data); } }
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 update_courses() { //$this->db->get_where('mains_tests', array('test_id' => $test_id)); $crud = new grocery_CRUD(); $crud->set_table('members'); $crud->columns('member_id', 'mains_test', 'pt_test', 'material', 'interview'); $crud->edit_fields('member_id', 'mains_test', 'pt_test', 'material', 'interview', 'status'); $crud->field_type('member_id', 'readonly'); //$crud->field_type('status','readonly'); $crud->set_relation_n_n('mains_test', 'packages_students', 'mains_tests_packages', 'member_id', 'package_id', 'package_name'); $crud->set_relation_n_n('material', 'material_package_student', 'material_package', 'member_id', 'package_id', 'package_name'); $crud->set_relation_n_n('pt_test', 'pt_packages_students', 'pt_tests_packages', 'member_id', 'package_id', 'package_name'); $crud->set_relation_n_n('interview', 'interview_student', 'interview_packages', 'member_id', 'package_id', 'package_name'); // $crud->callback_after_update(array($this, 'email_to_admin_and_user')); $crud->unset_print(); $crud->unset_export(); //$crud->unset_add(); // $crud->unset_edit(); $crud->unset_delete(); $output = $crud->render(); $this->_example_output($output); }
public function film_management_twitter_bootstrap() { try { $crud = new grocery_CRUD(); $crud->set_theme('twitter-bootstrap'); $crud->set_table('film'); $crud->set_relation_n_n('actors', 'film_actor', 'actor', 'film_id', 'actor_id', 'fullname', 'priority'); $crud->set_relation_n_n('category', 'film_category', 'category', 'film_id', 'category_id', 'name'); $crud->unset_columns('special_features', 'description', 'actors'); $crud->fields('title', 'description', 'actors', 'category', 'release_year', 'rental_duration', 'rental_rate', 'length', 'replacement_cost', 'rating', 'special_features'); $output = $crud->render(); $this->_example_output($output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
function tipos_pago() { if ($this->session->userdata('is_logged_in')) { $crud = new grocery_CRUD(); $crud->set_table('tipos_pago'); //-> $crud->set_theme('datatables'); $crud->set_language('spanish'); $crud->set_subject('Tipo de Pago'); // Display As $crud->display_as('id_estatus', 'Estatus'); $crud->display_as('id_formas_pago', 'Forma de Pago'); //-> Columnas $crud->columns('descripcion', 'id_estatus'); // Relaciones $crud->set_relation('id_estatus', 'disponible_nodisponible', 'descripcion'); $crud->set_relation_n_n('id_formas_pago', 'tipo_forma_pago', 'formas_pago', 'tipo_id', 'forma_id', 'descripcion', null, array('formas_pago.id_estatus' => '1')); // Upload // Validacion $crud->required_fields('descripcion', 'id_estatus'); //-> Renderizar $output = $crud->render(); $data['titulo'] = "TIPOS DE PAGO"; $this->load->view('include/head', $output); $this->load->view('include/header', $data); $this->load->view('admin/output'); $this->load->view('admin/librerias'); $this->load->view('include/footer', $data); } else { $this->load->view('admin/login'); } }