public function mostrar_busqueda() { $grocery = new grocery_CRUD(); $grocery->set_theme('bootstrap'); $grocery->set_table('denuncias'); $grocery->set_language('spanish'); $grocery->set_relation('idEstatus', 'estatus', 'descripcion'); $grocery->set_relation('idRecepcion', 'recepcion', 'descripcion'); $grocery->set_relation('idDependencia', 'dependencias', 'dependencia'); $grocery->set_relation('idCiudadano', 'ciudadanos', '{nombre} \\n{apellidoPa} \\n{apellidoMa}'); $grocery->set_relation('idDireccion', 'direcciones', 'colonia'); $grocery->set_relation('idAsunto', 'asuntos', 'descripcion'); $grocery->set_relation('idMedios', 'medios', 'descripcion'); $grocery->display_as('idDependencia', 'Dependencia'); $grocery->display_as('idCiudadano', 'Ciudadano'); $grocery->display_as('idDireccion', 'Dirección'); $grocery->display_as('idRecepcion', 'Recepción'); $grocery->display_as('idEstatus', 'Estatus'); $grocery->display_as('idAsunto', 'Asunto'); $grocery->display_as('idMedios', 'Medios'); $grocery->unset_add(); $grocery->unset_export(); //$grocery->unset_edit(); $grocery->edit_fields('fecha', 'idDependencia', 'idEstatus', 'idRecepcion', 'idMedios'); $grocery->add_action('Editar ciudadano', '', 'ciudadanos/editar_ciudadano'); $grocery->add_action('Editar Direccion', '', 'direcciones/editar_direccion'); $grocery->add_action('Editar Asunto', '', 'asuntos/editar_asunto'); $grocery->columns('fecha', 'idDependencia', 'idCiudadano', 'idEstatus', 'idRecepcion', 'idDireccion', 'idAsunto'); $output = $grocery->render(); $this->_example_output($output); }
public function listarNeumonias() { $sub = $this->frontend_model->buscarDiresas(); $subr = array(); foreach ($sub as $dato) { $subr[$dato->codigo] = $dato->nombre; } $est = $this->frontend_model->listaEstablec(); $estab = array(); foreach ($est as $dato) { $estab[$dato->cod_est] = $dato->raz_soc; } $crud = new grocery_CRUD(); $crud->set_table('neumonias'); $crud->columns('diresa', 'e_salud', 'apepat', 'apemat', 'nombres', 'sexo', 'fecha_reg', 'fecha_def', 'usuario'); $crud->set_subject('Ficha'); $nivelUsuario = $this->session->userdata("nivel"); switch ($nivelUsuario) { case '8': $where = array('e_salud' => $this->session->userdata("establecimiento")); $crud->where($where); break; case '7': $where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa")); $crud->where($where); break; case '6': $where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa")); $crud->where($where); break; case '5': $where = array('diresa' => $this->session->userdata("diresa")); $crud->where($where); break; } $crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino')); $crud->field_type('diresa', 'dropdown', $subr); $crud->field_type('e_salud', 'dropdown', $estab); $crud->display_as("apepat", "Apellido Paterno"); $crud->display_as("apemat", "Apellido Materno"); $crud->display_as("fecha_reg", "Registro"); $crud->display_as("fecha_def", "Defunción"); $crud->display_as("e_salud", "Establecimiento"); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); $crud->unset_export(); //$crud->unset_print(); $crud->callback_after_delete(array($this, 'log_usuario_before_delete')); $crud->add_action_peru('', '', 'RegfichaNeum', 'add-icon'); $crud->add_action('Modificar Ficha', '', 'modulos3/ModfichaNeum', 'edit-icon'); $crud->add_action('Ver Ficha', '', 'modulos3/VerfichaNeum', 'read-icon'); $output = $crud->render(); $this->_example_output($output); }
public function listar_transito() { /*$establecimiento = $this->mantenimiento_transito->listarEstablecimiento(); foreach($establecimiento as $dato){ $est[$dato->cod_est] = $dato->raz_soc; } */ $crud = new grocery_CRUD(); //$crud->set_theme('bootstrap'); $crud->set_table('trans_lesacctra'); $crud->columns('id', 'ano', 'ap_nm1', 'ap_nm2', 'nom_les', 'edad', 'tipo_edad', 'diresa', 'eess'); $crud->set_subject('Ficha Transito'); $nivelUsuario = $this->session->userdata("nivel"); switch ($nivelUsuario) { case '8': $where = array('cod_eess' => $this->session->userdata("establecimiento")); $crud->where($where); break; case '7': //$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red' and microred = '$microred')"; $where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa")); $crud->where($where); break; case '6': //$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red')"; $where = array('red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa")); $crud->where($where); break; case '5': $where = array('cod_dir' => $this->session->userdata("diresa")); $crud->where($where); break; } //$crud->field_type('establec', 'dropdown', $est); $crud->display_as("id", "ID")->display_as("ano", "AÑO")->display_as("ap_nm1", "APELLIDO PATERNO")->display_as("ap_nm2", "APELLIDO MATERNO")->display_as("nom_les", "NOMBRES")->display_as("edad", "EDAD")->display_as("tipo_edad", "TIPO")->display_as("diresa", "DIRESA")->display_as("eess", "ESTABLECIENTO DE SALUD"); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); $crud->unset_print(); $crud->unset_export(); $crud->unset_delete(); $crud->order_by('id', 'desc'); $crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulotransito/borrarFichatransito', 'borrar-icon'); $crud->add_action('Vista previa', '', 'modulotransito/ver_ficha_transito', 'read-icon'); $crud->add_action('Editar Ficha Transito', '', 'modulotransito/modificacion_transito', 'edit-icon'); $output = $crud->render(); $usuario = $this->session->userdata("usuario"); $accion = 'Listar Casos Accidentes de Transito'; $this->login_model->auditoriaOperador($usuario, $accion); $this->layout->view('listar_transito', $output); }
function database() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('patients'); $crud->set_subject('Patient'); //$crud->display_as('compartiment_name','Compartiment'); $crud->columns('cnp', 'first_name', 'last_name', 'date_of_birth', 'sex', 'city', 'height', 'weight'); $crud->field_type('sex', 'dropdown', array('Male' => 'Male', 'Female' => 'Female')); $crud->add_action('Interventions', '', '', 'ui-icon-heart', array($this, 'go_intervention')); $crud->add_action('Follow-Up', '', '', 'ui-icon-calculator', array($this, 'go_followup')); $output = $crud->render(); $this->_admin_output($output); }
function database() { $drp = $this->session->userdata('user_type'); $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('patients'); $crud->set_subject('Patient'); $crud->display_as('fo_nr', 'Medical Record number'); $crud->field_tip('fo_nr', 'eg: 1234/2016'); $crud->display_as('city', 'City or Locality'); $crud->display_as('gp_phone', 'GP Phone'); $crud->display_as('GP_info', 'Notes'); // User Level Unset if ($drp == "user") { $crud->unset_delete(); $crud->unset_export(); $crud->unset_print(); // afisare fara statistici // data 24.01.2017 $crud->columns('id', 'fo_nr', 'cnp', 'last_name', 'first_name', 'follow_up_date', 'status', 'signature'); } // afisare in admin coloane cu statistici // data 24.01.2017 $crud->columns('id', 'cnp', 'last_name', 'first_name', 'No_of_PCIs', 'Completed_FU_events', 'follow_up_date', 'status', 'signature', 'admin'); $crud->field_tip('cnp', 'Personal ID No.'); $crud->field_tip('gender', 'The gender of the patient'); $crud->field_tip('height', 'Height in cm'); $crud->field_tip('weight', 'Weight in kg'); $crud->required_fields('cnp', 'first_name', 'last_name', 'admin', 'status'); $crud->field_type('gender', 'dropdown', array('Male' => 'Male', 'Female' => 'Female')); $crud->field_type('country', 'dropdown', array('Romania' => 'Romania', 'Other' => 'Other', 'Unknown' => 'Unknown')); $crud->set_relation('county', 'county', 'county'); $crud->set_relation('signature', 'user', 'user_name'); $crud->set_relation('admin', 'user', 'user_name'); $crud->add_action('Interventions', '', '', 'ui-icon-heart', array($this, 'go_intervention')); $crud->add_action('Follow-Up', '', '', 'ui-icon-calculator', array($this, 'go_followup')); $crud->callback_column('follow_up_date', array($this, '_followup')); $crud->callback_column('Completed_FU_events', array($this, '_nofollowup')); $crud->callback_column('No_of_PCIs', array($this, '_nointerv')); // log- user activities $crud->callback_after_insert(array($this, 'log_user_after_insert_patient')); $crud->callback_after_update(array($this, 'log_user_after_update_patient')); $crud->callback_after_delete(array($this, 'log_user_after_delete_patient')); $crud->unique_fields('cnp'); $crud->field_type('status', 'dropdown', array('New' => 'New', 'In progress' => 'In progress', 'Finished' => 'Finished', 'Dead' => 'Dead', 'Delete' => 'Delete')); //$extra = "info"; //$output = $crud->render($extra); $output = $crud->render(); // $output->extra = '<h3>Pacient</h3>'; Adauga valori extra pentru view $this->_admin_output($output); }
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($categoryid = 0) { $session_data = $this->session->userdata('logged_in'); $data['username'] = $session_data['username']; $data['cat_id'] = $categoryid; // $form_subject = ($categoryid==0 ? "Category" : "Sub Category"); if ($categoryid == 0) { $form_subject = "Category"; $data['cat_title'] = "Categories"; } else { $this->category->getTitle($categoryid); $data['cat_title'] = $this->category->getTitle($categoryid) . " - Sub Categories"; $form_subject = "Sub Category"; } $crud = new grocery_CRUD(); $crud->set_table('dbx_categories'); $crud->where('pid', $categoryid); $crud->set_subject($form_subject); $crud->required_fields('title'); $crud->columns('title'); $crud->callback_column('title', array($this, 'link_title')); $crud->set_rules('title', 'Title', 'trim|required|xss_clean|is_unique[dbx_categories.title]'); $crud->add_action('Sub Categories', '', '', 'cat-icon', array($this, 'goto_sub')); $crud->fields('title', 'desc', 'published', 'type', 'pid', 'ownerid', 'created_date'); $crud->field_type('pid', 'hidden', $categoryid); $crud->field_type('published', 'dropdown', array('0' => 'No', '1' => 'Yes')); $crud->field_type('type', 'dropdown', array('C' => 'Celebrity', 'M' => 'Movie', 'P' => 'Parent')); $crud->change_field_type('ownerid', 'invisible'); $crud->change_field_type('created_date', 'invisible'); $crud->callback_before_insert(array($this, 'before_insert')); $output = $crud->render($data); $this->load->view('header_view', $data); $this->load->view('categories_view', $output); $this->load->view('footer_view', $data); }
public function index() { $this->pagina_saida((object) array('output' => '', 'js_files' => array(), 'css_files' => array())); $this->load->view('template/navbar.php'); try { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('cliente_produto'); $crud->set_subject('codorc'); $crud->required_fields('codorc', 'codpro'); $crud->display_as('codorc', 'Cód. Orçamento'); $crud->display_as('tiporc', 'Tipo'); $crud->display_as('numcpf', 'CPF'); $crud->display_as('plavei', 'Placa'); $crud->display_as('datent', 'Data Início'); $crud->display_as('datsai', 'Data Saída'); // $crud->columns('NomeCliente'); $crud->add_action('Smileys', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', 'demo/action_smiley'); $output = $crud->render(); $this->pagina_saida($output); $this->load->view('template/footer'); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('hotels'); $crud->set_subject('Hotels'); $agents = $this->ion_auth->get_all_agents(); $user = $this->ion_auth->user()->row(); $agents += array($user->id => $user->first_name . " " . $user->last_name); $crud->field_type('hotel_agent_id', 'dropdown', $agents); //var_dump($agents); // $crud->set_relation('hotel_agent_id', 'io_users', '{first_name} {last_name}', array('active' => 1)); $crud->display_as('hotel_agent_id', 'Agent Name'); $crud->display_as('hotel_name', 'Hotel Name'); $crud->display_as('hotel_rooms', 'Rooms'); $crud->display_as('hotel_tariffs', 'Tariffs'); $crud->display_as('hotel_country', 'Country'); $crud->display_as('hotel_city', 'City'); $crud->display_as('hotel_street', 'Street'); $crud->display_as('hotel_state', 'State'); $crud->display_as('hotel_postCode', 'PostCode'); $crud->display_as('hotel_phoneNumber', 'Phone Number'); $crud->display_as('hotel_emailId', 'Email ID'); $crud->display_as('hotel_website', 'Website'); $crud->display_as('hotel_facebook', 'Facebook'); $crud->display_as('hotel_googleMap', 'Google Map'); $crud->display_as('hotel_related', 'Related Hotels'); $crud->display_as('hotel_status', 'Status'); $crud->columns('hotel_name', 'hotel_agent_id', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook', 'hotel_googleMap', 'hotel_status'); $crud->required_fields('hotel_agent_id'); $crud->field_type('hotel_stars', 'dropdown', range(0, 5)); /* * For related hotels * on add list all the hotels * on edit, list all except own name */ $hrf = array(); if ($crud->getState() == 'edit') { $hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_id !=' => $crud->getStateInfo()->primary_key), 'hotel_id'); } else { $hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1), 'hotel_id'); } $hrf = $this->generic_model->array_from_db($hrf, 'hotel_id, hotel_name'); $crud->field_type('hotel_related', 'multiselect', $hrf); $crud->callback_column('hotel_image', array($this, 'set_image')); $crud->set_field_upload('hotel_image', $this->upload_path); $hf = $this->generic_model->get_by('hotel_facilities', array('hf_status' => 1), 'hf_id'); $hf = $this->generic_model->array_from_db($hf, 'hf_id, hf_facility'); $crud->field_type('hotel_facilities', 'multiselect', $hf); $hrf = $this->generic_model->get_by('hotel_room_facilities', array('hrf_status' => 1), 'hrf_id'); $hrf = $this->generic_model->array_from_db($hrf, 'hrf_id, hrf_facility'); $crud->field_type('hotel_room_facilities', 'multiselect', $hrf); $crud->unique_fields('hotel_slug'); $crud->add_action('Photo Gallery', '', 'hotels/gallery', 'ui-icon ui-icon-image'); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotels', 'pagedesc' => 'Hotels', 'contenttitle' => 'Hotels List Records'); $this->load->view('gc_admin_wrapper', $data); }
public function listarMnp() { $crud = new grocery_CRUD(); $crud->set_table('mnp'); $crud->columns('registroId', 'ape_nom', 'sexo', 'fecha_nac', 'fecha_mte', 'fecha_reg', 'usuario'); $crud->set_subject('Ficha'); $nivelUsuario = $this->session->userdata("nivel"); switch ($nivelUsuario) { case '8': $where = array('e_salud' => $this->session->userdata("establecimiento")); $crud->where($where); break; case '7': $where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa")); $crud->where($where); break; case '6': $where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa")); $crud->where($where); break; case '5': $where = array('diresa' => $this->session->userdata("diresa")); $crud->where($where); break; } $crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino', 'I' => 'Indeterminado')); $crud->display_as("registroId", "Ficha"); $crud->display_as("ape_nom", "Apellidos y Nombres"); $crud->display_as("fecha_nac", "Fecha de Nacimiento"); $crud->display_as("fecha_mte", "Defunción"); $crud->display_as("fecha_reg", "Fecha de Registro"); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); $crud->unset_export(); $crud->unset_delete(); //$crud->unset_print(); $crud->add_action_peru('', '', 'RegfichaMnp', 'add-icon'); $crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulosmnp/delFichaMnp', 'borrar-icon'); $crud->add_action('Modificar Ficha', '', 'modulosmnp/ModfichaMnp', 'edit-icon'); $crud->add_action('Ver Ficha', '', 'modulosmnp/VerfichaMnp', 'read-icon'); $output = $crud->render(); $this->_example_output($output); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('hotels'); $crud->set_subject('Hotels'); // $crud->set_relation('hotel_agent_id', 'io_users', '{first_name} {last_name}'); $agent_id = $this->ion_auth->user()->row()->id; $crud->where('hotel_agent_id', $agent_id); $crud->field_type('hotel_agent_id', 'hidden', $agent_id); // $crud->display_as('hotel_agent_id', 'Agent Name'); $crud->display_as('hotel_name', 'Hotel Name'); $crud->display_as('hotel_rooms', 'rooms'); $crud->display_as('hotel_tariffs', 'tariffs'); $crud->display_as('hotel_country', 'Country'); $crud->display_as('hotel_city', 'City'); $crud->display_as('hotel_street', 'Street'); $crud->display_as('hotel_state', 'State'); $crud->display_as('hotel_postCode', 'PostCode'); $crud->display_as('hotel_phoneNumber', 'Phone Number'); $crud->display_as('hotel_emailId', 'Email ID'); $crud->display_as('hotel_website', 'Website'); $crud->display_as('hotel_facebook', 'Facebook'); $crud->display_as('hotel_googleMap', 'GoogleMap'); $crud->display_as('hotel_status', 'Status'); $crud->columns('hotel_name', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook', 'hotel_googleMap', 'hotel_status'); $crud->callback_column('hotel_image', array($this, 'set_image')); $crud->set_field_upload('hotel_image', $this->upload_path); /* * For related hotels * on add list all the hotels * on edit, list all except own name */ if ($crud->getState() == 'edit') { $hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_agent_id' => $this->ion_auth->get_user_id(), 'hotel_id !=' => $crud->getStateInfo()->primary_key), 'hotel_id'); } else { $hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_agent_id' => $this->ion_auth->get_user_id()), 'hotel_id'); } // empty data for multiselect field generates error if (empty($hrf)) { $hrf = array(''); } else { $hrf = $this->generic_model->array_from_db($hrf, 'hotel_id, hotel_name'); } $crud->field_type('hotel_related', 'multiselect', $hrf); $hf = $this->generic_model->get_by('hotel_facilities', array('hf_status' => 1), 'hf_id'); $hf = $this->generic_model->array_from_db($hf, 'hf_id, hf_facility'); $crud->field_type('hotel_facilities', 'multiselect', $hf); $hrf = $this->generic_model->get_by('hotel_room_facilities', array('hrf_status' => 1), 'hrf_id'); $hrf = $this->generic_model->array_from_db($hrf, 'hrf_id, hrf_facility'); $crud->field_type('hotel_room_facilities', 'multiselect', $hrf); $crud->add_action('Photo Gallery', '', 'agents/hotels/gallery', 'ui-icon ui-icon-image'); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotels', 'pagedesc' => 'Hotels', 'contenttitle' => 'Hotels List Records', 'left_menu' => 'agents_menu'); $this->load->view('gc_admin_wrapper', $data); }
public function index($categoryid = 0) { $session_data = $this->session->userdata('logged_in'); $data['username'] = $session_data['username']; $data['lo'] = 1; //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 . " "; $form_subject = $cat_title; $crud = new grocery_CRUD(); $crud->set_table('dbx_celebrities'); $crud->where('catid', $categoryid); $crud->set_subject($form_subject); $crud->required_fields('name'); $crud->columns('name'); // $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', 'name', 'alt_name1', 'alt_name2', 'alt_name3', 'alt_name4', 'title', 'desc', 'sign', 'birth_date', 'birth_place', 'first_film', 'awards', 'height', 'weight', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date'); // $crud->field_type('catid', 'hidden', $categoryid); $crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'C'), null, $categoryid); $crud->display_as('catid', 'Category'); $crud->callback_add_field('desc', array($this, 'add_field_desc')); $crud->callback_add_field('awards', array($this, 'add_field_awards')); $crud->callback_edit_field('desc', array($this, 'edit_field_desc')); $crud->callback_edit_field('awards', array($this, 'edit_field_awards')); $crud->field_type('sign', 'dropdown', array('Aries' => 'Aries', 'Taurus' => 'Taurus', 'Gemini1' => 'Gemini', 'Cancer' => 'Cancer', 'Leo' => 'Leo', 'Virgo' => 'Virgo', 'Libra' => 'Libra', 'Scorpio' => 'Scorpio', 'Sagittarius' => 'Sagittarius', 'Capricorn' => 'Capricorn', 'Aquarius' => 'Aquarius', 'Pisces' => 'Pisces')); $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->unset_jquery(); $output = $crud->render($data); $this->load->view('header_view', $data); $this->load->view('celebrities_view', $output); $this->load->view('footer_view', $data); } }
public function article() { $crud = new grocery_CRUD(); $crud->set_table('blog_article'); $crud->columns('article_title', 'content', 'Categories', 'author_user_id', 'date', 'allow_comment'); $crud->edit_fields('article_title', 'article_url', 'content', 'Categories', 'date', 'author_user_id', 'allow_comment'); $crud->add_fields('article_title', 'article_url', 'content', 'Categories', 'date', 'author_user_id', 'allow_comment'); $crud->display_as('article_title', 'Title')->display_as('article_url', 'URL')->display_as('content', 'Content')->display_as('date', 'Date Created')->display_as('author_user_id', 'Author'); $crud->set_subject('Article'); $crud->callback_before_insert(array($this, 'before_insert_article')); $crud->callback_before_update(array($this, 'before_insert_article')); $crud->set_relation_n_n('Categories', 'blog_category_article', 'blog_category', 'article_id', 'category_id', 'category_name'); $crud->set_relation('author_user_id', 'cms_user', 'real_name'); $crud->change_field_type('author_user_id', 'hidden'); $crud->change_field_type('date', 'hidden'); $crud->change_field_type('article_url', 'hidden'); $crud->change_field_type('allow_comment', 'true_false'); $crud->add_action('Photos', base_url() . 'modules/blog/assets/images/photo.png', 'blog/photo'); $crud->add_action('Comments', base_url() . 'modules/blog/assets/images/comment.png', 'blog/comment'); $output = $crud->render(); $this->view('grocery_CRUD', $output, 'blog_article'); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('bookings'); $crud->set_subject('Bookings'); // $agents = $this->ion_auth->get_all_agents(); // $user = $this->ion_auth->user()->row(); // $agents += array($user->id => $user->first_name . " " . $user->last_name); // $crud->field_type('hotel_agent_id', 'dropdown', $agents); $crud->set_relation('booking_agent', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1)); $crud->set_relation('agent_id', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1)); $crud->set_relation('booking_to', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1)); $crud->display_as('agent_id', 'Agent of Hotel/Package'); $crud->display_as('booking_company_commission', 'Company Commission'); $crud->display_as('booking_status', 'Status (Change Status)'); $crud->display_as('booking_agent', 'Booked By'); // $crud->display_as('hotel_name', 'Hotel Name'); // $crud->display_as('hotel_rooms', 'Rooms'); // $crud->display_as('hotel_tariffs', 'Tariffs'); $crud->field_type('booking_ref_no', 'readonly'); $crud->field_type('paypal_transaction_id', 'readonly'); $crud->field_type('booking_agent_commission', 'readonly'); $crud->field_type('booking_company_commission', 'readonly'); $crud->field_type('booking_type', 'readonly'); $crud->field_type('booking_item_title', 'readonly'); $crud->field_type('booking_date', 'readonly'); $crud->field_type('booking_payment_type', 'readonly'); $crud->field_type('booking_total', 'readonly'); $crud->field_type('booking_agent', 'readonly'); $crud->field_type('agent_id', 'readonly'); $crud->field_type('booking_to', 'readonly'); $crud->unset_columns('booking_item', 'booking_subitem', 'booking_paymethod_tax', 'ip_address', 'booking_nights'); $crud->unset_fields('booking_item', 'booking_subitem', 'booking_paymethod_tax', 'ip_address', 'booking_nights'); $crud->where('agent_id', $this->ion_auth->get_user_id()); // $crud->columns('hotel_name', 'hotel_agent_id', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook' ,'hotel_googleMap', 'hotel_status'); // $state = $crud->getState(); // // if($state =='list' || $state =='ajax_list') // { $crud->set_js("assets/frontend/js/custom_functions_sam.js"); // } $crud->add_action('Conversation', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', '', 'ui-icon-image', array($this, '_booking_conversation')); $crud->callback_column('booking_ref_no', array($this, '_show_invoice')); $crud->callback_edit_field('booking_status', array($this, '_edit_field_callback')); $crud->callback_column('booking_status', array($this, '_booking_status')); $crud->unset_add(); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Bookings', 'pagedesc' => 'Bookings', 'contenttitle' => 'Booking List Records', 'left_menu' => 'agents_menu'); $this->load->view('gc_admin_wrapper', $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); }
public function mostrar_ciudadanos2() { $grocery = new grocery_CRUD(); // Asunto dependencia y direcciones del ciudada $grocery->set_theme('bootstrap'); $grocery->set_language('spanish'); $grocery->set_table('ciudadanos'); $grocery->display_as('apellidoPa', 'Apellido Paterno'); $grocery->display_as('apellidoMa', 'Apellido Materno'); $grocery->display_as('tel1', 'Teléfono 1'); $grocery->display_as('tel2', 'Teléfono 2'); $grocery->add_action('Denuncias', '', 'ciudadanos/denuncias_por_ciudadano', 'fa fa-university'); $grocery->field_type('tel2', 'integer'); $grocery->field_type('tel1', 'integer'); $output = $grocery->render(); $this->_example_output($output); }
public function index() { $crud = new grocery_CRUD(); $crud->set_crud_url_path(site_url('Barcode/index')); $crud->set_table('data'); //Nama Tabel $crud->set_subject('Barcode'); $crud->unset_read(); $crud->unset_export(); $crud->unset_print(); $crud->add_action('Generate Barcode', '', '', 'barcode-icon', array($this, 'ca_barcode')); //Custom Action $output = $crud->render(); //Config Halaman $output->judul_besar = 'Barcode'; $output->judul_kecil = 'Generate Barcode'; $output->m_barcode = TRUE; $this->_example_output($output); }
function administracion() { if (!$this->tank_auth->is_logged_in()) { redirect('/auth/login/'); } try { /* Creamos el objeto */ $crud = new grocery_CRUD(); /* Seleccionamos el tema */ // $crud->set_theme('datatables'); $crud->set_theme('flexigrid'); /* Seleccionmos el nombre de la tabla de nuestra base de datos*/ $crud->set_table('client'); /* Le asignamos un nombre */ $crud->set_subject('cliente'); /* Asignamos el idioma español */ $crud->set_language('spanish'); /* Aqui le decimos a grocery que estos campos son obligatorios */ $crud->required_fields('ClientID', 'Name', 'Lastname', 'IdentType', 'Ident', 'BirthDate', 'Address', 'City'); /* Aqui le indicamos que campos deseamos mostrar */ $crud->columns('ClientID', 'Name', 'Lastname', 'IdentType', 'Ident', 'BirthDate', 'Address', 'City', 'Phone1', 'Phone2', 'Phone3', 'Mail', 'Facebook', 'Twitter', 'Facebook', 'Skype', 'Company'); $crud->add_action('Productos', base_url() . 'assets/uploads/detalle.png', 'Product/admin_by_client'); $crud->display_as('ClientID', 'ID'); $crud->display_as('Name', 'Nombre'); $crud->display_as('Lastname', 'Apellido'); $crud->display_as('IdentType', 'Tipo Identificación'); $crud->display_as('Ident', 'Identificación'); $crud->display_as('BirthDate', 'Fecha Nacimiento'); $crud->display_as('Address', 'Dirección'); $crud->display_as('City', 'Ciudad'); $crud->display_as('Phone1', 'Teléfono 1'); $crud->display_as('Phone2', 'Teléfono 2'); $crud->display_as('Phone3', 'Teléfono 3'); $crud->display_as('Company', 'Empresa'); /* Generamos la tabla */ $output = $crud->render(); /* La cargamos en la vista situada en */ $this->load->view('Client/administracion', $output); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
/** * 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'); }
function abm() { //Creo el objeto crud $crud = new grocery_CRUD(); //Defino tabla sobre la que trabajo y tipo de 'Objeto' $crud->set_table('Personal'); $crud->set_subject('Empleado'); //Agrego acción para editar horarios del Personal. $crud->add_action('Editar Horarios', base_url() . 'assets/grocery_crud/themes/flexigrid/css/images/clock.png', 'reportes-entrada-salida/personal/editar_horario'); //Quito el agregar. $crud->unset_add(); //Quito el botones borrar. $crud->unset_delete(); $crud->fields('nombreApellido'); //Seteo campos requeridos $crud->required_fields('nombreApellido'); //Defino nombres para cada campo. $crud->display_as('nombreApellido', 'Nombre y Apellido'); //Genero el ABM $output = $crud->render(); //Llamo a la función encargada de mostrar el ABM. mostrar_crud($output, '', $this->menu, 'reportes-entrada-salida/personal/abm', '', 'reportes-entrada-salida/personal/abm_final'); }
public function cadastro() { try { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('pessoa'); $crud->set_subject('Cadastro de Cidadão'); $crud->required_fields('nome'); $crud->columns('foto_frente', 'nome', 'artigos', 'id', 'naturalidade', 'telefone_1', 'obs'); $crud->set_relation_n_n('artigos', 'artigo_has_pessoa', 'artigo', 'pessoa_id', 'artigo_id', 'artigo_penal'); $crud->set_field_upload('foto_frente', 'assets/uploads/files'); $crud->set_field_upload('foto_lado_esquerdo', 'assets/uploads/files'); $crud->set_field_upload('foto_lado_direito', 'assets/uploads/files'); $crud->set_field_upload('foto_costas', 'assets/uploads/files'); $crud->set_relation('cor_pele_id', 'cor_pele', '{nome_cor}'); $crud->unset_texteditor('tatuagens'); $crud->unset_edit_fields('cadastrado_em'); $crud->add_action('Fotos Extras', '', '', 'ui-icon-image', array($this, 'pessoa_fotos_call')); $output = $crud->render(); $this->_example_output($output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function listarCasos() { $nivelUsuario = $this->session->userdata("nivel"); $enfermedad = array('diagnostic' => 'A92.0'); $enfermedad1 = array('diagnostic' => 'A92.5'); $tipo = array('C' => 'Confirmado', 'P' => 'Probable', 'D' => 'Descartado', 'S' => 'Sospechoso'); $est = $this->frontend_model->listaEstablec(); $estab = array(); foreach ($est as $dato) { $estab[$dato->cod_est] = $dato->raz_soc; } $crud = new grocery_CRUD(); $crud->set_table('individual'); //$crud->set_theme('datatables'); $crud->columns('semana', 'diagnostic', 'tipo_dx', 'e_salud', 'ubigeo', 'apepat', 'apemat', 'nombres', 'dni', 'fecha_inv'); $crud->set_subject('Ficha'); switch ($nivelUsuario) { case '8': $where = array('e_salud' => $this->session->userdata("establecimiento")); $crud->where($where); break; case '7': $where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'sub_reg_nt' => $this->session->userdata("diresa")); $crud->where($where); break; case '6': $where = array('red' => $this->session->userdata("red"), 'sub_reg_nt' => $this->session->userdata("diresa")); $crud->where($where); break; case '5': $where = array('sub_reg_nt' => $this->session->userdata("diresa")); $crud->where($where); break; } $crud->where($enfermedad); $crud->or_where($enfermedad1); $crud->display_as("apepat", "Ap. Paterno"); $crud->display_as("apemat", "Ap. Materno"); $crud->display_as("ubigeo", "Distrito"); $crud->display_as("diagnostic", "Enfermedad"); $crud->display_as("e_salud", "Establecimiento"); $crud->display_as("fecha_inv", "Investigación"); $crud->set_relation('ubigeo', 'distrito', 'nombre'); $crud->set_relation('diagnostic', 'diagno', 'diagno'); $crud->field_type('e_salud', 'dropdown', $estab); $crud->field_type('tipo_dx', 'dropdown', $tipo); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); $crud->unset_export(); $crud->unset_delete(); $crud->unset_print(); $crud->add_action('Registrar Ficha', base_url() . 'assets/images/more.png', 'modulos/RegfichaChik', ''); $output1 = $crud->render(); $this->_notificados_output($output1); }
public function listarCasos() { $establecimiento = $this->mantenimiento_model->listarEstablecimiento(); foreach ($establecimiento as $dato) { $est[$dato->cod_est] = $dato->raz_soc; } $diagnostico = $this->mantenimiento_model->listarDiagnostico(); foreach ($diagnostico as $dato) { $diagno[$dato->cie_10] = $dato->diagno; } $crud = new grocery_CRUD(); //$crud->set_theme("datatables"); $crud->set_table('individual'); $crud->columns('diagnostic', 'e_salud', 'apepat', 'apemat', 'nombres', 'dni'); $crud->set_subject('Ficha'); $nivelUsuario = $this->session->userdata("nivel"); switch ($nivelUsuario) { case '8': $where = array('diagnostic' => 'O98.1', 'e_salud' => $this->session->userdata("establecimiento")); $or_where = array('diagnostic' => 'A50'); $crud->where($where); $crud->or_where($or_where); break; case '7': $where = array('diagnostic' => 'O98.1', 'microred' => $this->session->userdata("microred"), 'redes' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa")); $or_where = array('diagnostic' => 'A50'); $crud->where($where); $crud->or_where($or_where); break; case '6': $where = array('diagnostic' => 'O98.1', 'redes' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa")); $or_where = array('diagnostic' => 'A50'); $crud->where($where); $crud->or_where($or_where); break; case '5': $where = array('diagnostic' => 'O98.1', 'sub_reg_nt' => $this->session->userdata("diresa")); $or_where = array('diagnostic' => 'A50'); $crud->where($where); $crud->or_where($or_where); break; default: $where = array('diagnostic' => 'O98.1'); $or_where = array('diagnostic' => 'A50'); $crud->where('diagnostic', 'O98.1'); $crud->or_where($or_where); break; } $crud->field_type('e_salud', 'dropdown', $est); $crud->display_as("e_salud", "Establecimiento"); $crud->field_type('diagnostic', 'dropdown', $diagno); $crud->display_as("diagnostic", "Enfermedad"); $crud->display_as("apepat", "Paterno"); $crud->display_as("apemat", "Materno"); $crud->display_as("fecha_not", "Notificación"); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $crud->unset_read(); $crud->unset_print(); $crud->unset_export(); $crud->add_action('Registrar Ficha', '', 'modulos2/RegfichaSif', 'edit-icon'); $output = $crud->render(); $this->layout->view('listarCasos', $output); }
public function persutujuan_daftar_kegiatan() { try { $this->load->model("user_m"); $crud = new grocery_CRUD(); $state = $crud->getState(); $id_user = $this->uri->segment(3); $status = $this->uri->segment(4); //echo $status; exit; /*$data = $this->user_m->detail($id_user); $row = $data[0]; $nama_depan = isset($row->nama_depan)?$row->nama_depan:""; $nama_belakang = isset($row->nama_belakang)?$row->nama_belakang:"";*/ if (!empty($id_user)) { $crud->where('tbl_kegiatan_transaksi.id_user', $id_user); } if (!empty($status)) { $crud->where('tbl_kegiatan_transaksi.status', $status); } $crud->set_table('tbl_kegiatan_transaksi'); $crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}'); $crud->set_subject('Daftar Kegiatan'); $crud->fields('id_user', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'status', 'status_deskripsi', 'angka_kredit'); $crud->columns('id_user', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'keterangan', 'status', 'angka_kredit'); $crud->add_action('Daftar Berkas', '', 'penilai/persutujuan_daftar_kegiatan_berkas', 'fa fa-upload'); $crud->display_as("tanggal_kegiatan", "Tanggal Mulai")->display_as("tanggal_kegiatan_selesai", "Tanggal Selesai")->display_as("id_user", "Pegawai"); $crud->order_by('id_kegiatan_transaksi', 'desc'); $crud->change_field_type('id_user', 'readonly'); $crud->change_field_type('tanggal_kegiatan', 'readonly'); $crud->change_field_type('tanggal_kegiatan_selesai', 'readonly'); $crud->change_field_type('jumlah_hari_libur', 'readonly'); $crud->change_field_type('lembur', 'readonly'); $crud->change_field_type('keterangan', 'readonly'); $crud->change_field_type('angka_kredit', 'readonly'); $crud->unset_add(); $crud->unset_save(); $crud->unset_read(); $crud->unset_delete(); $sitemap = $this->get_sitemap(); $output = $crud->render($sitemap); $this->load->view('theme/theme_pegawai', $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
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_femme'); if (!$this->session->userdata('status')) { $crud->where('archiver', FALSE); } $crud->set_subject('Femme'); //relations $crud->set_relation('situation_familiale', 'sos_gen_situation_familiale_parrent', 'name_situation_familiale_parrent'); $crud->set_relation('detailles', 'sos_gen_situation_familiale_child', 'name_situation_familiale_child'); $crud->set_relation('emplois', 'sos_gen_emplois_parrent', 'name_emplois'); $crud->set_relation('emplois_detailles', 'sos_gen_emplois_child', 'name_emplois_detaille'); $crud->set_relation('emplois_more_detailles', 'sos_gen_emplois_child_child', 'name_emplois_child_child'); $crud->set_relation('age', 'sos_gen_femme_age', 'name_femme_age'); $crud->set_relation('duree_de_la_relation', 'sos_gen_duree_de_la_relation', 'name_duree_de_la_relation', null, 'id_duree_de_la_relation ASC'); $crud->set_relation('service', 'sos_gen_service', 'nom_service', null, 'nom_service DESC'); $crud->set_relation('ville', 'sos_gen_villes', '{nom_ville}, {code_postal}', null, 'nom_ville ASC'); $crud->set_relation('pays', 'sos_gen_pays', '{nom_pays} - {continent}', null, 'nom_pays ASC'); $crud->set_relation('nationalite', 'sos_gen_nationalite', 'name_nationalite'); $crud->set_relation('nationalite_detailles', 'sos_gen_nationalite_detailles', 'name_nationalite_detailles'); $crud->set_relation('ressources', 'sos_gen_ressources', 'name_ressources'); $crud->set_relation('provenance', 'sos_gen_provenance', 'name_provenance'); $crud->set_relation('allocations_familiales', 'sos_gen_allocations_familiales', 'name_allocations_familiales'); $crud->set_relation('percues_par', 'sos_gen_percues_par', 'name_percues_par'); $crud->set_relation('logement', 'sos_gen_logement_parent', 'name_logement'); $crud->set_relation('logement_detailles', 'sos_gen_logement_child', 'name_logement_child'); $crud->set_relation('situation_actuelle_depuis', 'sos_gen_situation_actuelle_depuis', 'name_situation_actuelle_depuis', null, 'id_situation_actuelle_depuis ASC'); $crud->set_relation('situation_actuelle', 'sos_gen_situation_actuelle', 'name_situation_actuelle'); $crud->set_relation('situation_actuelle_detailles', 'sos_gen_situation_actuelle_detailles', 'name_situation_actuelle_detailles'); $crud->set_relation('partenaire', 'sos_gen_partenaire', 'name_partenaire'); $crud->set_relation('informations', 'sos_gen_informations', 'name_informations'); $crud->set_relation('rdv', 'sos_gen_rdv', 'name_rdv'); $crud->set_relation('hebergement', 'sos_gen_hebergement', 'name_hebergement'); $crud->set_relation('departs_anterieurs', 'sos_gen_departs_anterieurs', 'name_departs_anterieurs'); $crud->set_relation('depuis', 'sos_gen_depuis', 'name_depuis'); //Master/child relations $fields_situation_familialle = array('situation_familiale' => array('table_name' => 'sos_gen_situation_familiale_parrent', 'title' => 'name_situation_familiale_parrent', 'relate' => null), 'detailles' => array('table_name' => 'sos_gen_situation_familiale_child', 'title' => 'name_situation_familiale_child', 'id_field' => 'id_situation_familiale_child', 'relate' => 'id_parrent_from_situation_familiale_parrent', 'data-placeholder' => 'Préciser')); $config_situation_familialle = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "situation_familialle"); $categories_situation_familialle = new gc_dependent_select($crud, $fields_situation_familialle, $config_situation_familialle); $js_situation_familialle = $categories_situation_familialle->get_js(); $fields_nationalite = array('nationalite' => array('table_name' => 'sos_gen_nationalite', 'title' => 'name_nationalite', 'relate' => null), 'nationalite_detailles' => array('table_name' => 'sos_gen_nationalite_detailles', 'title' => 'name_nationalite_detailles', 'id_field' => 'id_nationalite_detailles', 'relate' => 'id_from_nationalite', 'data-placeholder' => 'Préciser')); $config_nationalite = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "nationalite"); $categories_nationalite = new gc_dependent_select($crud, $fields_nationalite, $config_nationalite); $js_nationalite = $categories_nationalite->get_js(); $fields_emplois = array('emplois' => array('table_name' => 'sos_gen_emplois_parrent', 'title' => 'name_emplois', 'relate' => null), 'emplois_detailles' => array('table_name' => 'sos_gen_emplois_child', 'title' => 'name_emplois_detaille', 'id_field' => 'id_emplois_detailles', 'relate' => 'id_from_emplois', 'data-placeholder' => 'Préciser'), 'emplois_more_detailles' => array('table_name' => 'sos_gen_emplois_child_child', 'title' => 'name_emplois_child_child', 'id_field' => 'id_emplois_child_child', 'relate' => 'id_emplois_from_child', 'data-placeholder' => 'Préciser')); $config_emplois = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "emplois"); $categories_emplois = new gc_dependent_select($crud, $fields_emplois, $config_emplois); $js_emplois = $categories_emplois->get_js(); $fields_ressources = array('ressources' => array('table_name' => 'sos_gen_ressources', 'title' => 'name_ressources', 'relate' => null), 'provenance' => array('table_name' => 'sos_gen_provenance', 'title' => 'name_provenance', 'id_field' => 'id_provenance', 'relate' => 'id_from_ressources', 'data-placeholder' => 'Préciser')); $config_ressources = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "ressources"); $categories_ressources = new gc_dependent_select($crud, $fields_ressources, $config_ressources); $js_ressources = $categories_ressources->get_js(); $fields_allocations_familiales = array('allocations_familiales' => array('table_name' => 'sos_gen_allocations_familiales', 'title' => 'name_allocations_familiales', 'relate' => null), 'percues_par' => array('table_name' => 'sos_gen_percues_par', 'title' => 'name_percues_par', 'id_field' => 'id_percues_par', 'relate' => 'id_from_allocations_familiales', 'data-placeholder' => 'Préciser')); $config_allocations_familiales = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "allocations_familiales"); $categories_allocations_familiales = new gc_dependent_select($crud, $fields_allocations_familiales, $config_allocations_familiales); $js_allocations_familiales = $categories_allocations_familiales->get_js(); $fields_logement = array('logement' => array('table_name' => 'sos_gen_logement_parent', 'title' => 'name_logement', 'relate' => null), 'logement_detailles' => array('table_name' => 'sos_gen_logement_child', 'title' => 'name_logement_child', 'id_field' => 'id_logement_child', 'relate' => 'id_from_logement_parent', 'data-placeholder' => 'Préciser')); $config_logement = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "logement"); $categories_logement = new gc_dependent_select($crud, $fields_logement, $config_logement); $js_logement = $categories_logement->get_js(); $fields_situation_actuelle = array('situation_actuelle' => array('table_name' => 'sos_gen_situation_actuelle', 'title' => 'name_situation_actuelle', 'relate' => null), 'situation_actuelle_detailles' => array('table_name' => 'sos_gen_situation_actuelle_detailles', 'title' => 'name_situation_actuelle_detailles', 'id_field' => 'id_situation_actuelle_detailles', 'relate' => 'id_from_situation_actuelle', 'data-placeholder' => 'Préciser')); $config_situation_actuelle = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "situation_actuelle"); $categories_situation_actuelle = new gc_dependent_select($crud, $fields_situation_actuelle, $config_situation_actuelle); $js_situation_actuelle = $categories_situation_actuelle->get_js(); //Visual if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') { $crud->columns('prenom', 'nom', 'nom_marital', 'age', 'date_naissance', 'telephone', 'ville', 'nombre_denfants', 'ouvertures', 'premier_contact', 'nombre_passages'); } else { $crud->columns('archiver', 'prenom', 'nom', 'nom_marital', 'age', 'date_naissance', 'telephone', 'ville', 'nombre_denfants', 'ouvertures', 'premier_contact', 'nombre_passages'); } $crud->display_as('pays', 'Originaire de')->display_as('archiver', 'Archivage')->display_as('prenom', 'Prénom')->display_as('telephone', 'Téléphone')->display_as('nationalite', 'Nationalité')->display_as('rue', 'Adresse')->display_as('oriente_par_SMS', 'Orientée par SMS')->display_as('departs_anterieurs', 'Départs antérieurs')->display_as('nationalite_detailles', 'Situation administrative')->display_as('detailles', 'Situation familiale en détail')->display_as('duree_de_la_relation', 'Durée de la relation')->display_as('emplois_detailles', 'Détails de l\'emploi')->display_as('emplois_more_detailles', 'Plus de détails de l\'emploi')->display_as('ouvertures', 'Dernière modification')->display_as('hebergement', 'Demande d\'hébergement')->display_as('aide_materielle', 'Demande d\'aide matérielle')->display_as('accompagnement_exterieur', 'Demande d\'accompagnement extérieur')->display_as('adresse_postale', 'Demande d\'adresse postale')->display_as('accueil', 'Demande d\'accueil')->display_as('informations', 'Demande d\'informations')->display_as('conseil', 'Demande de conseil')->display_as('orientation', 'Demande d\'orientation')->display_as('rdv', 'Demande de rdv')->display_as('hebergement', 'Demande d\'hébergement')->display_as('logement_dem', 'Demande de logement')->display_as('logement_detailles', 'Logement détaillé')->display_as('situation_actuelle_detailles', 'Situation actuelle détaillée')->display_as('emplois', 'Situation professionnelle')->display_as('emplois_detailles', 'Situation professionnelle détaillée')->display_as('emplois_more_detailles', 'Autres infos emploi')->display_as('percues_par', 'Perçues par')->display_as('commentaire', 'Commentaires')->display_as('partenaire', 'Orienteur')->display_as('nombre_passages', 'Nombre passages')->display_as('arrivee_en_france', 'Arrivée en France')->display_as('parle_pas_francais', 'Parle pas français')->display_as('ism', 'Utilisation ISM'); $crud->order_by('prenom', 'asc'); //unsets if ($this->session->userdata('status') == '1' or $this->session->userdata('status') == '2' or $this->session->userdata('status') == '3') { $crud->unset_edit_fields('service', 'par', 'archiver'); } else { $crud->unset_edit_fields('service', 'premier_contact', 'par'); } $crud->unset_add_fields('par', 'archiver'); if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') { $crud->unset_delete(); $crud->unset_export(); $crud->unset_print(); } //Requireds $crud->required_fields('service', 'premier_contact', 'prenom'); //Callbacks $crud->callback_column('ouvertures', array($this, 'ouvertures')); $crud->callback_column('premier_contact', array($this, 'premier_contact')); $crud->callback_column('nombre_denfants', array($this, 'enfants')); $crud->callback_after_update(array($this, 'insert_after_update')); $crud->callback_after_insert(array($this, 'insert_after_insert')); $crud->callback_after_delete(array($this, 'after_delete')); $crud->callback_column('archiver', array($this, 'archiver')); $crud->callback_column('nombre_passages', array($this, 'nombre_passages')); $crud->callback_before_update(array($this, 'before_update')); //field Types $crud->field_type('enceinte', 'dropdown', array('1' => '1 mois', '2' => '2 mois', '3' => '3 mois', '4' => '4 mois', '5' => '5 mois', '6' => '6 mois', '7' => '7 mois', '8' => '8 mois', '9' => '9 mois')); $crud->field_type('dettes', 'enum', array('OUI', 'NON')); $crud->field_type('arrivee_en_france', 'dropdown', range(date("Y"), date("Y") - 50)); $crud->field_type('parle_pas_francais', 'enum', array('OUI', 'NON')); $crud->field_type('ism', 'multiselect', array("1" => "Ponctuel", "2" => "Systématique", "3" => "Venu physiquement")); // Actions $crud->add_action('Enfants', '', 'kids/kids_window', 'ui-icon-person'); $crud->add_action('Intervention', '', 'demande/demande_window', 'ui-icon-home'); $crud->add_action('Profil', '', 'show/show_window', 'ui-icon-print'); $crud->add_action('Violences', '', 'violence/violence_window', 'ui-icon-alert'); $crud->add_action('Démarches', '', 'demarche/demarche_window', 'ui-icon-gear'); if ($this->session->userdata('status') != '0') { $crud->add_action('Psy', '', 'psy/psy_window', 'ui-icon-comment'); } $crud->add_action('Documents', '', 'upload/upload_window', 'ui-icon-document'); // Renders $output = $crud->render(); $output->output .= $js_situation_familialle . $js_emplois . $js_nationalite . $js_ressources . $js_allocations_familiales . $js_logement . $js_situation_actuelle; $menu = new stdClass(); $menu->n0 = true; $menu->status = $this->session->userdata('status'); $header = $this->navigation->home_f($menu); $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function irasCampos() { if (empty($this->session_id)) { redirect(site_url("index/login"), 301); } $reporta = array('ano' => date('Y'), 'semana' => date('W') - 2); $this->reportes_model->registraCalidad($reporta); $this->calidad_model->edasCampos(); $crud = new grocery_CRUD(); $crud->set_table('irasDefunciones'); $crud->columns('ano', 'semana', 'sub_reg_nt', 'red', 'microred', 'e_salud', 'ubigeo', 'ira_m2', 'ira_2_11', 'ira_1_4a', 'neu_2_11', 'neu_1_4a', 'ngr_m2', 'ngr_2_11', 'ngr_1_4a'); $crud->display_as('ano', 'Año'); switch ($this->session->userdata('nivel')) { case 4: $accesar = $this->session->userdata('equipo'); break; case 5: $accesar = $this->session->userdata('diresa'); $crud->or_where(array('sub_reg_nt' => $accesar)); break; case 6: $accesar = $this->session->userdata('diresa'); $accesar1 = $this->session->userdata('red'); $crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1)); break; case 7: $accesar = $this->session->userdata('diresa'); $accesar1 = $this->session->userdata('red'); $accesar2 = $this->session->userdata('microred'); $crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2)); break; case 8: $accesar = $this->session->userdata('establecimiento'); $crud->where(array('e_salud' => $accesar)); break; } $crud->order_by('semana'); $crud->unset_add(); $crud->unset_read(); $crud->unset_edit(); //$crud->unset_delete(); //$crud->unset_export(); $crud->unset_print(); $crud->add_action('Editar', '', 'calidad/modIras', 'edit-icon'); $crud->callback_after_delete(array($this, 'log_iras_registro_after_delete')); $output = $crud->render(); $this->layout->view('irasCampos.php', $output); }
public function transfer_order() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('transfer_order'); $crud->columns('pickup_location', 'pickup_destination', 'price', 'order_status'); $crud->add_action('Complete', '', 'manage/complete_order', 'ui-icon-check'); $crud->set_relation('car_type', 'car_type', 'type_name'); $crud->set_relation('car_model', 'our_fleet', 'car_name'); $crud->set_relation('user', 'users', 'Username :- {username} <br>Email Address :- {email}'); $crud->unset_add(); $crud->unset_edit(); $output = $crud->render(); $this->_example_output($output); }
public function category($action = null, $id_product_category = null) { $this->session->set_userdata('selected_table', 'product_category'); $crud = new grocery_CRUD(); if (!empty($id_product_category) && is_numeric($id_product_category) && $action == 'parent') { $crud->where('parent', $id_product_category)->unset_add()->unset_edit()->unset_delete(); } else { $crud->add_action('Lihat Sub Produk Kategori', '', '', 'read-icon', array($this, 'addSubCategoryAction')); } $crud->set_table('product_category')->columns('category', 'parent', 'note')->fields('category', 'parent', 'note')->required_fields('category')->display_as('category', 'Nama Kategori')->display_as('parent', 'Parent Kategori')->display_as('note', 'Keterangan')->callback_field('note', array($this, 'setTextarea'))->callback_field('parent', array($this, 'categoryParentField'))->callback_column('parent', array($this, 'categoryParentName'))->unset_read()->unset_delete(); $output = $crud->render(); $this->parser->parse('category.tpl', $output); }
public function listadoIndividual() { $sub = $this->frontend_model->buscarDiresas(); $subr = array(); foreach ($sub as $dato) { $subr[$dato->codigo] = $dato->nombre; } $dist = $this->frontend_model->listarDistritos(); $ubigeo = array(); foreach ($dist as $dato) { $ubigeo[$dato->ubigeo] = $dato->nombre; } $enf = $this->frontend_model->mostrarDiagnostico(); $enfermedad = array(); foreach ($enf as $dato) { $enfermedad[$dato->cie_10] = $dato->diagno; } $tdx = $this->frontend_model->mostrarTipo(); $tipoDx = array(); foreach ($tdx as $dato) { $tipoDx[$dato->codigo] = $dato->denominacion; } $filtro = array(); $this->input->post('diresa') ? $filtro['sub_reg_nt'] = $this->input->post('diresa') : ''; $this->input->post('redes') ? $filtro['red'] = $this->input->post('redes') : ''; $this->input->post('microred') ? $filtro['microred'] = $this->input->post('microred') : ''; $this->input->post('establec') ? $filtro['e_salud'] = $this->input->post('establec') : ''; $this->input->post('departamento') ? $filtro['substr(ubigeo,1,2)'] = $this->input->post('departamento') : ''; $this->input->post('provincia') ? $filtro['substr(ubigeo,1,4)'] = $this->input->post('provincia') : ''; $this->input->post('distrito') ? $filtro['ubigeo'] = $this->input->post('distrito') : ''; $this->input->post('diagno') ? $filtro['diagnostic'] = $this->input->post('diagno') : ''; $this->input->post('tipoDx') ? $filtro['tipo_dx'] = $this->input->post('tipoDx') : ''; $this->input->post('ano_ini') ? $filtro['ano'] = $this->input->post('ano_ini') : ''; $this->input->post('semana_ini') ? $filtro['semana'] = $this->input->post('semana_ini') : ''; $this->input->post('apepat') ? $filtro['apepat'] = $this->input->post('apepat') : ''; $crud = new grocery_CRUD(); $crud->set_theme("datatables"); $crud->set_table('individual'); $crud->columns('ano', 'semana', 'diagnostic', 'tipo_dx', 'subregion', 'sub_reg_nt', 'ubigeo', 'sexo', 'apepat', 'apemat', 'nombres'); $crud->display_as('ano', 'Año')->display_as('diagnostic', 'Diagnóstico')->display_as('subregion', 'Diresa')->display_as('sub_reg_nt', 'Notificante')->display_as('ubigeo', 'Distrito')->display_as('tipo_dx', 'Tipo')->display_as('apepat', 'Ap. Paterno')->display_as('apemat', 'Ap. Materno'); $crud->field_type('subregion', 'dropdown', $subr); $crud->field_type('sub_reg_nt', 'dropdown', $subr); $crud->field_type('ubigeo', 'dropdown', $ubigeo); $crud->field_type('diagnostic', 'dropdown', $enfermedad); $crud->field_type('tipo_dx', 'dropdown', $tipoDx); $crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino')); if ($this->input->post()) { if ($this->session->userdata('institucion') == 'A') { $crud->where($filtro); } else { $crud->where($filtro); $crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'))); } } else { $crud->where(array('ano' => date('Y'))); switch ($this->session->userdata('nivel')) { case 4: $accesar = $this->session->userdata('equipo'); if ($this->session->userdata('institucion') != 'A') { $crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'))); } break; case 5: $accesar = $this->session->userdata('diresa'); if ($this->session->userdata('institucion') != 'A') { $crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'subregion' => $accesar)); } else { $crud->where(array('subregion' => $accesar)); $crud->or_where(array('sub_reg_nt' => $accesar)); } break; case 6: $accesar = $this->session->userdata('diresa'); $accesar1 = $this->session->userdata('red'); if ($this->session->userdata('institucion') != 'A') { $crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1)); } else { $crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1)); } break; case 7: $accesar = $this->session->userdata('diresa'); $accesar1 = $this->session->userdata('red'); $accesar2 = $this->session->userdata('microred'); if ($this->session->userdata('institucion') != 'A') { $crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2)); } else { $crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2)); } break; case 8: $accesar = $this->session->userdata('establecimiento'); $crud->where(array('e_salud' => $accesar)); break; } } $crud->limit(1000); $crud->order_by('semana', 'DESC'); $crud->set_subject('Individual'); $crud->unset_add(); $crud->unset_read(); $crud->unset_edit(); $crud->unset_export(); $crud->unset_print(); $crud->callback_after_delete(array($this, 'log_usuario_before_delete')); $crud->add_action('Editar', '', 'individual/modIndividual', 'ui-icon-pencil'); /////////////////////////////////////////////////////////////////////////////// //$crud->add_action_peru('Añadir Individual', '', 'regIndividual','add-icon'); /////////////////////////////////////////////////////////////////////////////// $output = $crud->render(); $this->_example_output1($output); }