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(); }
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()); } }
function consultar() { if ($this->session->userdata('is_logged_in')) { $crud = new grocery_CRUD(); //-> Identifico el ID del Cliente $crud->set_table('facturas'); //-> $crud->set_theme('datatables'); $crud->set_language('spanish'); $crud->set_subject('Factura'); // Display As $crud->unset_add(); $crud->display_as('id_moneda_pago', 'Moneda Pago'); $crud->display_as('id_cliente', 'Cliente'); $crud->display_as('id_estatus', 'Estatus'); //-> Columnas $crud->columns('folio', 'id_cliente', 'total', 'fecha_creacion', 'id_estatus'); // Relaciones $crud->set_relation('id_moneda_pago', 'tipos_moneda', 'descripcion'); $crud->set_relation('registrado_por', 'usuarios', 'nombre'); $crud->set_relation('id_estatus', 'formas_pago', 'descripcion'); $crud->set_relation('id_cliente', 'clientes', 'nombre'); //-> Renderizar $output = $crud->render(); $data['titulo'] = "CONSULTAR FACTURAS"; $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'); } }
function index() { if ($this->session->userdata('is_logged_in')) { $crud = new grocery_CRUD(); $crud->set_table('productos'); //-> $crud->set_theme('datatables'); $crud->set_language('spanish'); $crud->set_subject('Producto'); // Display As $crud->display_as('id_clasificacion', 'Clasificación'); $crud->display_as('id_estatus', 'Estatus'); //-> Columnas $crud->columns('descripcion', 'id_clasificacion', 'precio'); // Relaciones $crud->set_relation('id_clasificacion', 'productos_clasificaciones', 'descripcion'); $crud->set_relation('id_estatus', 'disponible_nodisponible', 'descripcion'); // Upload ## // Validacion $crud->field_type('precio', 'integer'); $crud->required_fields('descripcion', 'id_clasificacion', 'precio'); //-> Renderizar $output = $crud->render(); $data['titulo'] = "PRODUCTOS"; $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'); } }
public function index() { $crud = new grocery_CRUD(); //Jangan lupa load library ini $this->load->library('gc_dependent_select'); $crud->set_crud_url_path(site_url('examples/index')); $crud->set_table('data_diri'); $crud->columns('nama', 'fk_id_prov', 'fk_id_kota', 'fk_id_kec', 'fk_id_kel'); $crud->display_as('fk_id_prov', 'Provinsi')->display_as('fk_id_kota', 'Kota')->display_as('fk_id_kec', 'Kecamatan')->display_as('fk_id_kel', 'Kelurahan'); $crud->set_subject('Data Diri'); $crud->set_relation('fk_id_prov', 'provinsi', 'nama'); $crud->set_relation('fk_id_kota', 'kabupaten', 'nama'); $crud->set_relation('fk_id_kec', 'kecamatan', 'nama'); $crud->set_relation('fk_id_kel', 'kelurahan', 'nama'); $fields = array('fk_id_prov' => array('table_name' => 'provinsi', 'title' => 'nama', 'relate' => null, 'data-placeholder' => 'Pilih Provinsi'), 'fk_id_kota' => array('table_name' => 'kabupaten', 'title' => 'nama', 'id_field' => 'id_kab', 'relate' => 'id_prov', 'data-placeholder' => 'Pilih Kota'), 'fk_id_kec' => array('table_name' => 'kecamatan', 'title' => 'ID: {id_kec} / Kota : {nama}', 'id_field' => 'id_kec', 'relate' => 'id_kab', 'data-placeholder' => 'Pilih Kecamatan'), 'fk_id_kel' => array('table_name' => 'kelurahan', 'title' => 'nama', 'id_field' => 'id_kel', 'relate' => 'id_kec', 'data-placeholder' => 'Pilih Kelurahan')); $config = array('main_table' => 'data_diri', 'main_table_primary' => 'id', "url" => site_url() . '/examples/index/', 'ajax_loader' => base_url() . 'assets/ajax-loader.gif'); $categories = new gc_dependent_select($crud, $fields, $config); // first method: //$output = $categories->render(); // the second method: $js = $categories->get_js(); $output = $crud->render(); $output->output .= $js; $this->_example_output($output); }
public function index() { $bol_del_before_date = $this->m_conndb->dateBeforeDelete(); try { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('tempahan'); $crud->set_subject('Booking Room'); $crud->set_relation('m_id', 'masa', 'm_desc'); $crud->set_relation('bm_id', 'bilik_meeting', 'bm_desc'); $crud->display_as('t_datereg', 'Date Reg.')->display_as('t_date', 'Book Date')->display_as('t_day', 'Book Day')->display_as('m_id', 'Time')->display_as('t_perkara', 'Club / Item')->display_as('bm_id', 'Meeting Room')->display_as('t_status', 'Status'); $crud->columns('t_date', 't_day', 'm_id', 't_perkara', 'bm_id'); $crud->fields('t_date', 'm_id', 't_perkara', 'bm_id', 't_datereg', 't_day'); $crud->field_type('t_datereg', 'hidden'); $crud->field_type('t_day', 'hidden'); $crud->required_fields('t_date', 'm_id', 't_perkara', 'bm_id'); $umaq = $this->uri->segment(3); if (!($this->uri->segment(3) && $umaq == 'umaqkacak')) { $crud->unset_delete(); $crud->unset_edit(); } $crud->callback_before_insert(array($this, 'setAutoTempahan')); $output = $crud->render(); $this->viewpage('v_bookroom', $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function get_crud_propuesta() { $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_periodo', 'gp_periodo', 'siglas'); $crud->set_relation('id_departamento', 'gp_departamentos', 'nombre_depart', array('estado_dep' => '1')); $crud->set_relation('id_persona', 'gp_persona', '{nombres} {apellidos}'); $crud->display_as('id_periodo', 'Periodo')->display_as('id_departamento', 'Departamento')->display_as('id_persona', 'Usuario'); // $crud->set_relation('id_persona', 'gp_tipopersona', 'typo_persona'); //$crud->set_relation('id_estado', 'gp_estados', 'valor'); $crud->callback_column('estado', array($this, 'color_estado')); $crud->callback_column('tipo_persona', array($this, 'tipo_persona')); $crud->callback_column('asignacion_tutor', array($this, 'asigna_tutor')); $crud->callback_column('tutor', array($this, 'view_tutor')); $crud->callback_column('historial', array($this, 'get_historial')); $cols = array('titulo', 'contenido', 'id_periodo', 'id_departamento', 'id_persona', 'tipo_persona', 'fecha_post', 'estado', 'tutor', 'asignacion_tutor', 'historial'); $crud->columns2($cols); $crud->set_table('gp_propuesta'); $crud->set_subject('Tesis'); $crud->unset_add()->unset_delete()->unset_edit(); $output = $crud->render(); $this->load->view('crud/crud_view_datatable', $output); }
public function items() { $crud = new grocery_CRUD(); $crud->set_table('item'); $crud->display_as('category_id', 'Categoria')->display_as('tag_id', 'Etiqueta'); $crud->set_relation('category_id', 'category', 'name'); $crud->set_relation('tag_id', 'tag', 'name'); $crud->set_field_upload('photo', 'assets/uploads/files'); $output = $crud->render(); $this->_example_output($output); }
function ventas() { $crud = new grocery_CRUD(); $crud->set_table('ventas'); $crud->set_relation('producto', 'productos', 'item_name'); $crud->set_relation('unitario', 'productos', 'precio'); $crud->display_as('valor', 'Total'); $crud->unset_add(); $crud->unset_delete(); $crud->unset_edit(); $output = $crud->render(); $this->load->view('main/ventas', $output); }
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 get_crud_expe() { $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_persona', 'gp_persona', '{nombres} {apellidos}'); $crud->set_relation('id_periodo', 'gp_periodo', 'siglas', array('estado_periodo' => '1')); $crud->set_table('gp_expediente'); $crud->set_subject('Expediente'); // $crud->unset_add(); $output = $crud->render(); $this->load->view('crud/crud_view_datatable', $output); }
public function review_doctor() { if ($this->session->userdata('is_admin_logged_in')) { $crud = new grocery_CRUD(); $crud->set_table('review_doctor'); //$crud->columns('name','address','lat','lng','phone', 'description', 'review', 'birthRateLess35', 'birthRate35To40', 'birthRateMore40', 'services'); $crud->set_subject('review_doctor'); $crud->set_relation('fk_doctor', 'doctors', 'full_name'); $crud->set_relation('fk_patient', 'patients', 'name'); $output = $crud->render(); $this->_example_output($output); } else { redirect('Admin/admin_restricted'); } }
public function index() { try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->set_table('sos_gen_nationalite_detailles'); $crud->set_subject('Situation administrative'); //relations $crud->set_relation('id_from_nationalite', 'sos_gen_nationalite', 'name_nationalite'); //Master/child relations //Visual $crud->columns('name_nationalite_detailles', 'id_from_nationalite'); $crud->display_as('name_nationalite_detailles', 'Situation administrative'); $crud->display_as('id_from_nationalite', 'Nationalité'); //unsets //Requireds $crud->required_fields('name_nationalite_detailles', 'id_from_nationalite'); //Callbacks //field Types // Actions // Renders $output = $crud->render(); $menu = new stdClass(); $menu->n1 = true; $menu->lien3_1_1_4 = false; $menu->status = $this->session->userdata('status'); $header = $this->navigation->home_f($menu); $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
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 user() { $crud = new grocery_CRUD(); $crud->set_table('user'); $crud->set_relation('idUnit', 'unit', 'namaGroup'); $output = $crud->render(); $this->_outputs($output); }
function index() { $crud = new grocery_CRUD(); // list table $crud->set_table('user')->set_subject('User')->columns('userid', 'ic', 'Name', 'lastname', 'Email', 'User_Group', 'define_1', 'LastUpdate', 'user_last_login')->display_as('userid', 'User ID')->display_as('ic', 'Employee ID')->display_as('Name', 'First Name')->display_as('lastname', 'Last Name')->display_as('Email', 'Email')->display_as('User_Group', 'Dept')->display_as('define_1', 'Employee Level')->display_as('LastUpdate', 'Last Update')->display_as('user_last_login', 'Last Login'); $crud->set_relation('User_Group', 'user_group', 'gName'); $crud->set_relation('define_1', 'emp_level', 'desc'); $data['title'] = $this->m_setting->getSetting(); $data['head'] = "lyt_main/head"; $data['header'] = "lyt_main/header"; $data['sidebar'] = "lyt_main/sidebar"; $data['pagetitle'] = "Manage User"; $data['content'] = "master/v_crud"; $data['footer'] = "lyt_main/footer"; $data['crud_output'] = $crud->render(); $this->load->view('tpl_main', $data); }
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 index($stat = '') { try { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); switch ($stat) { case '': default: $user_ward_id = $this->session->userdata('nw_id'); $crud->set_table('nus_bed'); $crud->where('nus_bed.nw_id', $user_ward_id); $crud->columns('nb_bed_no', 'np_pmi_id', 'nbs_id', 'nb_datetime', 'ns_id'); $crud->display_as('nb_bed_no', 'Bed No.')->display_as('np_pmi_id', 'Patient Name')->display_as('nbs_id', 'Remarks')->display_as('nb_datetime', 'Date/Time Registered')->display_as('ns_id', 'Nurse'); $crud->set_relation('nbs_id', 'nus_bed_status', 'nbs_desc'); $crud->set_relation('ns_id', 'nus_staff', 'ns_fullname'); $crud->set_relation('np_pmi_id', 'nus_patient', 'np_fullname'); // $crud->unset_add(); // $crud->unset_delete(); $crud->edit_fields('np_pmi_id', 'nbs_id', 'nb_datetime', 'ns_id'); $crud->add_fields('nb_bed_no', 'nw_id', 'nbs_id'); $crud->field_type('nw_id', 'hidden'); // $crud->field_type('nbs_id', 'hidden'); $crud->required_fields('nb_bed_no'); $crud->unset_read(); // $crud->change_field_type('nb_bed_no', 'readonly'); $crud->change_field_type('ns_id', 'readonly'); $crud->callback_before_update(array($this, 'autoRegisterBed')); $crud->callback_before_insert(array($this, 'addBed')); break; case 'patient': $crud->set_table('nus_patient'); $crud->set_relation('np_gender', 'nus_patient_gender', 'npg_desc'); $crud->required_fields('np_pmi_no', 'np_fullname', 'np_ic', 'np_passport', 'np_gender'); $crud->fields('np_pmi_id', 'np_fullname', 'np_ic', 'np_passport', 'np_gender'); $crud->field_type('np_pmi_id', 'hidden'); $crud->display_as('np_pmi_id', 'PMI No.')->display_as('np_fullname', 'Full Name')->display_as('np_ic', 'IC No.')->display_as('np_passport', 'Passport No.')->display_as('np_gender', 'Gender'); $crud->callback_before_insert(array($this, 'autoInsertPriKeyPatient')); break; } $output = $crud->render(); $this->viewpage('v_mainpage', $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
function salidas() { if ($this->session->userdata('id')) { try { /* Creamos el objeto */ $crud = new grocery_CRUD(); /* Seleccionamos el tema */ $crud->set_theme('flexigrid'); /* Seleccionmos el nombre de la tabla de nuestra base de datos*/ $crud->set_table('salida'); /* Le asignamos un nombre */ $crud->set_subject('Salidas de productos'); $crud->set_relation('producto', 'productos', 'nombre'); $crud->set_relation('cliente', 'clientes', 'nombre'); //$crud->display_as('proveedor','Proveedor'); //$crud->set_subject('productos'); /* Asignamos el idioma español */ $crud->set_language('spanish'); /* Aqui le decimos a grocery que estos campos son obligatorios */ $crud->required_fields('producto', 'cantidad', 'cliente', 'folio', 'comentarios', 'precio', 'total'); /* Aqui le indicamos que campos deseamos mostrar */ $crud->columns('id', 'producto', 'cantidad', 'cliente', 'folio', 'comentarios', 'precio', 'total'); $crud->callback_column('precio', array($this, 'valuePeso')); $crud->callback_column('total', array($this, 'valuePeso')); $crud->callback_before_insert(array($this, 'checking_post_cantidad')); $crud->unset_delete(); $crud->unset_edit(); $crud->unset_export(); //$crud->add_action('Smileys', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', 'demo/action_smiley'); //$crud->callback_edit_field('cantidad',array($this,'edit_field_callback_1')); //$crud->callback_add_field('cantidad',array($this,'edit_field_callback_2')); /* Generamos la tabla */ $output = $crud->render(); /* La cargamos en la vista situada en /applications/views/productos/administracion.php */ $this->_example_output($output); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } } else { redirect('Login'); } }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('hotel_rooms'); $crud->set_subject('Hotel Rooms'); // $crud->unset_fields('ht_id'); $crud->display_as('room_hotel', 'Hotel Name'); $crud->display_as('hotel_title', 'Room Name'); $crud->display_as('room_desc', 'Room Description'); $crud->display_as('room_basic_price', 'Selling Price'); $crud->display_as('room_cost_price', 'Cost Price'); $crud->display_as('room_market_price', 'Market Price'); $crud->display_as('room_service_charge', 'Service Charge'); $crud->display_as('room_vat', 'VAT'); $crud->columns(array('room_hotel', 'room_title', 'room_vat', 'room_service_charge', 'room_cost_price', 'room_basic_price', 'room_basic_discount', 'room_order', 'room_quantity', 'room_added_on', 'room_status')); $crud->callback_column('room_basic_price', array($this, 'set_price')); // $crud->callback_read_field('room_basic_price', array($this, 'set_price')); // crud library modified SAM for read_field $crud->callback_column('room_basic_discount', array($this, 'set_price')); // $crud->callback_read_field('room_basic_discount', array($this, 'set_price')); // crud library modified SAM for read_field $crud->callback_add_field('room_cost_price', function ($value, $primary_key) { return "USD <input id='field-room_cost_price' class='form-control' name='room_cost_price' type='text' value='' maxlength='20'>"; }); $crud->callback_add_field('room_market_price', function ($value, $primary_key) { return "USD <input id='field-room_market_price' class='form-control' name='room_market_price' type='text' value='' maxlength='20'>"; }); $crud->callback_edit_field('room_cost_price', function ($value, $primary_key) { return "USD <input id='field-room_cost_price' class='form-control' name='room_cost_price' type='text' value='{$value}' maxlength='20'>"; }); $crud->callback_edit_field('room_market_price', function ($value, $primary_key) { return "USD <input id='field-room_market_price' class='form-control' name='room_market_price' type='text' value='{$value}' maxlength='20'>"; }); $crud->callback_add_field('room_basic_price', function ($value, $primary_key) { return "USD <input id='field-room_basic_price' class='form-control' name='room_basic_price' type='text' value='' maxlength='20'>"; }); $crud->callback_edit_field('room_basic_price', function ($value, $primary_key) { return "USD <input id='field-room_basic_price' class='form-control' name='room_basic_price' type='text' value='{$value}' maxlength='20'>"; }); $crud->callback_add_field('room_basic_discount', function ($value, $primary_key) { return "USD <input id='field-room_basic_discount' class='form-control' name='room_basic_discount' type='text' value='' maxlength='20'>"; }); $crud->callback_edit_field('room_basic_discount', function ($value, $primary_key) { return "USD <input id='field-room_basic_discount' class='form-control' name='room_basic_discount' type='text' value='{$value}' maxlength='20'>"; }); $crud->set_relation('room_hotel', 'hotels', '{hotel_name}'); $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('room_facilities', 'multiselect', $hrf); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotel Tariffs', 'pagedesc' => 'Hotel Tariffs', 'contenttitle' => 'Hotel Tariffs List Records'); $this->load->view('gc_admin_wrapper', $data); }
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 join() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('estudiante'); $crud->set_subject('estudiante'); $crud->set_relation('id_carrera', 'carrera', 'nom_carr'); //$crud->columns('cod_est','nom_est','nom_carr'); $output = $crud->render(); $this->_example_output($output); }
public function autogenerated_tree() { $this->data['page_title'] = 'Autogenerated Tree'; $crud = new grocery_CRUD(); $crud->set_table('autogeneratetree'); $crud->set_subject('attributes'); $crud->set_relation('parent_id', 'autogeneratetree', 'nodename'); $crud->unset_edit()->unset_delete()->unset_read(); $this->data['output'] = $crud->render(); $this->render('admin/crud_view'); }
function orders_management() { $crud = new grocery_CRUD(); $crud->set_relation('customerNumber', 'customers', '{contactLastName} {contactFirstName}'); $crud->display_as('customerNumber', 'Customer'); $crud->set_table('orders'); $crud->set_subject('Order'); $crud->unset_add(); $crud->unset_delete(); $output = $crud->render(); $this->_example_output($output); }
public function crud() { $crud = new grocery_CRUD(); $crud->set_theme(THEMA_CRUD); $crud->set_table('quadra'); $crud->set_subject('Quadra'); //@todo$crud->where('situacao_id', 2); //apenas ativos $crud->required_fields('descricao', 'tipo_quadra_id', ''); $crud->columns('id', 'descricao', 'tipo_quadra_id', 'situacao_quadra_id'); $crud->edit_fields('descricao', 'tipo_quadra_id', 'situacao_quadra_id'); $crud->add_fields('descricao', 'tipo_quadra_id', 'situacao_quadra_id'); //relacionamentos $crud->set_relation('situacao_quadra_id', 'situacao_quadra', 'descricao'); $crud->set_relation('tipo_quadra_id', 'tipo_quadra', 'descricao'); $crud->callback_insert(array($this, 'create')); $crud->callback_delete(array($this, 'delete')); $contents = $crud->render(); $this->template->set('titulo', 'Manter Quadra'); $this->template->set('subtitle', 'Quadra'); $this->template->load('template_teste', 'crudpage', $contents); }
public function index() { $crud = new grocery_CRUD(); $crud->set_table('nav_menu'); $crud->columns('title', 'parent', 'type', 'link_url'); $crud->callback_column('link_url', array($this, 'link_callback')); $crud->callback_column('maps', array($this, 'maps_callback')); // $crud->callback_before_insert(array($this,'encrypt_password_callback')); // $crud->callback_before_update(array($this,'encrypt_password_callback')); $crud->set_subject('Main Menu'); $crud->fields('title', 'parent', 'type', 'link_url', 'static_pages'); $crud->set_relation('parent', 'nav_menu', 'title'); $crud->set_relation('static_pages', 'pages', 'title'); $crud->required_fields('title', 'type'); //$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'] = 'Menu Navigation'; $data['content'] = $this->load->view('crud.php', $output, true); $this->load->view('base_theme', $data); }
public function usuarios() { $crud = new grocery_CRUD(); $crud->set_table("usuarios"); $crud->required_fields('email', 'clave', 'nombre'); $crud->field_type('clave', 'password'); $crud->set_relation('idrol', 'roles', 'descripcion'); $crud->display_as('idrol', 'Rol'); $crud->callback_before_insert(array($this->User_Model, 'encrypt_password_callback')); $output = $crud->render(); $this->cargarVista($output); }
public function denuncias_por_ciudadano($idCiudadano) { $crud = new grocery_CRUD(); $crud->set_theme('bootstrap'); $crud->set_language('spanish'); $crud->where('denuncias.idCiudadano', $idCiudadano); $crud->set_table('denuncias'); $crud->set_subject('Denuncias Por Ciudadano'); $crud->set_relation('idCiudadano', 'ciudadanos', '{nombre}\\n{apellidoPa}\\n{apellidoMa}'); $crud->set_relation('idRecepcion', 'recepcion', 'descripcion'); $crud->set_relation('idDependencia', 'dependencias', 'dependencia'); $crud->set_relation('idEstatus', 'estatus', 'descripcion'); $crud->set_relation('idDireccion', 'direcciones', 'Calle:{calle} \\n #:{noExt} # Int:{noInt} Col:{colonia}, \\n{localidad}, CP:{cp} '); $crud->set_relation('idAsunto', 'asuntos', 'descripcion'); $crud->display_as('idCiudadano', 'Ciudadano'); $crud->display_as('idDireccion', 'Dirección'); $crud->display_as('idRecepcion', 'Recepción'); $crud->display_as('idEstatus', 'Estatus'); $crud->display_as('idDependencia', 'Dependencia'); $crud->display_as('idAsunto', 'Asunto'); $crud->unset_add(); $crud->columns('idCiudadano', 'idAsunto', 'idDependencia', 'idEstatus', 'idDireccion', 'idRecepcion'); $output = $crud->render(); $this->_example_output($output); }
public function employees_management() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('employees'); $crud->set_relation('officeCode', 'offices', 'city'); $crud->display_as('officeCode', 'Office City'); $crud->set_subject('Employee'); $crud->required_fields('lastName'); $crud->set_field_upload('file_url', 'assets/uploads/files'); $output = $crud->render(); $this->_example_output($output); }
function timeslots_management() { $crud = new grocery_CRUD(); $crud->set_table('bloques_tipo'); $crud->set_theme('datatables'); $crud->set_subject('Bloques'); $crud->columns('id_bloque_categoria', 'nombre'); $crud->display_as('id_bloque_categoria', 'Categorias'); $crud->set_relation('id_bloque_categoria', 'bloques_categorias', 'nombre'); $crud->unset_delete(); $output = $crud->render(); $this->_output_crud($output, 'Bloques'); }