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 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('flexigrid'); /* Seleccionmos el nombre de la tabla de nuestra base de datos*/ $crud->set_table('method'); /* Le asignamos un nombre */ $crud->set_subject('Metodo'); /* Asignamos el idioma español */ $crud->set_language('spanish'); /* Aqui le decimos a grocery que estos campos son obligatorios */ $crud->required_fields('MethodID', 'Description'); /* Aqui le indicamos que campos deseamos mostrar */ $crud->columns('MethodID', 'Description'); $crud->display_as('MethodID', 'ID'); $crud->display_as('Description', 'Descripción'); /* Generamos la tabla */ $output = $crud->render(); /* La cargamos en la vista situada en */ $this->load->view('Method/administracion', $output); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ 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_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 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() { // $data = array( // 'main_content' => 'clients_wishlist', // 'output' => $this->db->get_where('clients_wishlist', array('wish_user' => $this->ion_auth->get_user_id()))->result(), // 'pagetitle' => 'Wishlist', // 'pagedesc' => 'Wishlist', // 'contenttitle' => 'Wishlist Records', // 'left_menu' => 'clients_menu' // ); // $this->load->view('gc_client_wrapper', $data); $this->load->library('grocery_CRUD'); // $this->upload_path = '../assets/uploads/' . 'packages'; // $this->wrapper = 'gc_admin_wrapper'; $this->load->model('generic_model'); $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('clients_wishlist'); $crud->set_subject('Client Wishlist'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); $crud->where('wish_user', $this->ion_auth->get_user_id()); $crud->display_as('wish_title', 'Wish Title'); $crud->display_as('wish_date', 'Wish Date'); $crud->callback_column('wish_title', array($this, 'set_change_status')); $crud->unset_columns('wish_url', 'wish_user'); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Client Wishlist', 'pagedesc' => 'Client Wishlist', 'contenttitle' => 'Wishlist Records', 'left_menu' => 'clients_menu'); $this->load->view('gc_admin_wrapper', $data); }
function transaksi() { $crud = new grocery_CRUD(); $crud->set_table('tb_transaksi'); $crud->set_subject('Transaksi'); $crud->set_theme('datatables'); $crud->display_as('tglTransaksi', 'Tgl'); $crud->display_as('namaPembeli', 'Pembeli'); $crud->display_as('namaPenerima', 'Penerima'); $crud->display_as('no_hp', 'HP'); $crud->display_as('jenisTransaksi', 'Transaksi'); $crud->display_as('namaBarang', 'Barang'); $crud->display_as('jumlahBarang', 'Jumlah'); //$crud->columns('perihal','tanggal_surat_masuk'); //$crud->display_as('id_persoalan','persoalan'); //$crud->add_action('Setting', base_url().'assets/img/tick.png', 'perencanaan/setting','ui-icon-image'); $output = $crud->render(); $stat = $this->session->userdata('lvl'); if ($stat == 1) { //admin $this->_example_output($output); } else { //user $this->load->view('dashboard_user', $data); } }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('bootstrap'); $crud->set_table('user'); $crud->set_subject('Gebruiker'); // hide fields $crud->columns('is_super_user', 'is_active', 'screen_name', 'email', 'gebruikersgroepen'); // new_password and new_password repeat are needed to make formvalidation work // id is needed to make the email unique check work $crud->fields('id', 'is_active', 'screen_name', 'email', 'gebruikersgroepen', 'password', 'new_password', 'new_password_repeat'); $crud->required_fields('email', 'screen_name', 'is_active'); $crud->set_relation_n_n('gebruikersgroepen', 'user_x_user_group', 'user_group', 'user_id', 'user_group_id', 'name'); $crud->field_type('id', 'hidden'); $crud->field_type('new_password_repeat', 'hidden'); $crud->field_type('password', 'hidden'); $crud->display_as('is_active', 'Actief'); $crud->display_as('screen_name', 'Schermnaam'); $crud->display_as('is_super_user', ''); $crud->display_as('new_password', 'Wachtwoord'); if ($crud->getState() == 'read') { $crud->field_type('new_password', 'hidden'); } else { $crud->callback_field('new_password', array($this, 'edit_field_callback_new_password')); } $crud->field_type('is_active', 'dropdown', array('yes' => 'ja', 'no' => 'nee')); $crud->callback_column('is_active', array($this, 'callback_list_is_active')); $crud->callback_column('is_super_user', array($this, 'callback_list_is_super_user')); $crud->callback_before_insert(array($this, 'before_insert_update_callback')); $crud->callback_before_update(array($this, 'before_insert_update_callback')); $crud->callback_after_insert(array($this, 'after_insert_callback')); $crud->callback_after_update(array($this, 'after_update_callback')); if ($crud->getState() === 'update_validation' or $crud->getState() === 'insert_validation') { $crud->set_rules('email', 'E-mail', 'required|valid_email|callback_email_unique_check'); $crud->set_rules('screen_name', 'Schermnaam', 'required'); if ($this->input->post('new_password') != '' or !$this->input->post('id')) { $crud->set_rules('new_password', 'Nieuw wachtwoord', 'required|min_length[10]|matches[new_password_repeat]'); $crud->set_rules('new_password_repeat', 'Herhaal nieuw wachtwoord', ''); } $this->form_validation->set_message('matches', 'De wachtwoorden zijn niet aan elkaar gelijk.'); } // render the crud HTML $crud_output = $crud->render(); //get the needed css and javascript files $this->javascript_files = $crud->get_js_files(); $this->css_files = $crud->get_css_files(); // put the crud content in the right position $this->views['content'] = $crud_output->output; $this->css[] = $this->load->view('admin/user/css/index.css', array(), true); // add javascript and css to make the password generate and change function possible if ($crud->getState() === 'add' or $crud->getState() === 'edit') { $this->css[] = $this->load->view('admin/user/css/edit_user.css', array(), true); $this->javascript[] = $this->load->view('admin/user/js/edit_user.js', array(), true); } // create the layout-HTML and show it to the user $this->_layout(); }
public function 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 index() { //Inisialisasi $crud = new grocery_CRUD(); $crud->set_subject('Pasien'); $crud->set_table('tbl_pasien'); //Label Fields $crud->display_as('idPasien', 'ID Pasien'); $crud->display_as('namaPasien', 'Nama'); $crud->display_as('umur', 'Umur'); $crud->display_as('tanggalLahir', 'Tanggal Lahir'); $crud->display_as('jenisKelamin', 'Jenis Kelamin'); $crud->display_as('status', 'Status'); $crud->display_as('alamat', 'Alamat'); $crud->display_as('pekerjaan', 'Pekerjaan'); $crud->display_as('no_telp', 'Nomor Telepon'); //Kolom Input dan Callbacks $crud->fields('idPasien', 'namaPasien', 'umur', 'tanggalLahir', 'jenisKelamin', 'status', 'alamat', 'pekerjaan', 'no_telp'); $crud->field_type('idPasien', 'invisible'); $crud->callback_field('jenisKelamin', array($this, 'jenisKelamin_callback')); $crud->field_type('status', 'dropdown', array('Menikah' => 'Menikah', 'Belum Menikah' => 'Belum Menikah')); $crud->field_type('pekerjaan', 'dropdown', array('Pegawai Negeri' => 'Pegawai Negeri', 'Wiraswasta' => 'Wiraswasta', 'Karyawan Swasta' => 'Karyawan Swasta', 'Mahasiswa' => 'Mahasiswa', 'Ibu Rumah Tangga' => 'Ibu Rumah Tangga', 'Pensiunan' => 'Pensiunan', 'Lainnya' => 'Lainnya')); //Aturan Pengisian Form $crud->required_fields('namaPasien', 'umur', 'tanggalLahir', 'jenisKelamin', 'status', 'alamat', 'pekerjaan'); $crud->set_rules('umur', 'Umur', array('required', 'max_length[2]', 'numeric')); $crud->set_rules('no_telp', 'Nomor Telepon', 'numeric'); $crud->set_language("indonesian"); //Cetak Tabel $output = $crud->render(); $this->_example_output($output); }
function shift_management() { $crud = new grocery_CRUD(); $crud->set_table('turnos_tipos'); $crud->set_subject('Trunos'); $crud->columns('nombre', 'desde', 'hasta'); $crud->display_as('desde', 'Desde 24 Hrs'); $crud->display_as('hasta', 'Hasta 24 Hrs'); $crud->required_fields('nombre', 'desde', 'hasta'); $crud->unset_delete(); $output = $crud->render(); $this->_output_crud($output, 'Turnos'); }
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 histori() { $crud = new grocery_CRUD(); $crud->set_table('voucher'); $crud->where('voucher.status', '1'); $crud->columns('nomor', 'id_member', 'created_at', "used_at"); $crud->set_relation('id_member', 'members', 'username'); $crud->display_as('nomor', 'Kode Voucher'); $crud->display_as('id_member', 'Member'); $crud->unset_operations(); $output = $crud->render(); $output->title = 'Data Voucher'; $this->template->load('template/template_main', 'admin/voucher', $output); }
public function afficheProduit() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('produit'); $crud->set_subject('Produits'); $crud->required_fields('id_Type_Produit', 'prix', 'libelle', 'poids_piece', 'disponibilite'); $crud->display_as('id_Type_Produit', 'Type du produit'); $crud->display_as('poids_piece', 'Poids ou Piece'); $crud->field_type('id_Type_Produit', 'dropdown', array('1' => 'Legumes', '2' => 'Fruits', '3' => 'Epices', '4' => 'Herbes')); $crud->field_type('poids_piece', 'set', array('poids', 'piece')); $crud->set_field_upload('file_url', 'assets/uploads/files'); $output = $crud->render(); $this->_example_output($output); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('clients'); $crud->set_subject('Clients'); $crud->unset_fields('client_id'); $crud->unset_columns('client_id'); // $crud->unset_columns('package_thingsToConsider'); // $crud->unset_columns('package_weatherCondition'); // $crud->unset_columns('package_itinerary'); // $crud->display_as('client_postcode', 'Post Code'); $crud->display_as('client_phoneNumber', 'Phone Number'); $crud->display_as('client_emailId', 'Email ID'); $crud->display_as('client_firstName', 'First Name'); $crud->display_as('client_lastName', 'Last Name'); // $crud->set_field_upload('package_image', $this->upload_path); // $crud->unique_fields('package_slug'); // // $crud->set_relation('package_agent', 'agents', '{agent_companyName}'); // // $crud->callback_column('package_image', array($this, 'set_image')); // $crud->callback_column('package_cost', array($this, 'set_price')); // // $crud->callback_add_field('package_cost', array($this, 'add_price1')); // $crud->callback_edit_field('package_cost', array($this, 'edit_price1')); // $crud->callback_column('package_status', array($this, 'set_change_status')); // $crud->unset_columns('package_status'); // $crud->add_action('change Status', '', '/change_status'); // $crud->add_action('Change Status', './assets/grocery_crud/themes/flexigrid/css/images/add.png', 'packages/change_status'); // $crud->add_action('package_status', '', '','ui-icon-image',array($this,'just_a_test')); // $crud->add_action('package_status', '', '','ui-icon-image',array($this,'just_a_test')); // $crud->set_lang_string('insert_success_message', // 'Your data has been successfully stored into the database.<br/>Please wait while you are redirecting to the list page. // <script type="text/javascript"> // window.location = "'.site_url(strtolower(__CLASS__).'/'.strtolower(__FUNCTION__)).'"; // </script> // <div style="display:none"> // ' // ); $crud->unset_add(); $crud->unset_delete(); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Clients', 'pagedesc' => 'Clients', 'contenttitle' => 'Clients List Records'); // redirect(base_url()); $this->load->view('gc_admin_wrapper', $data); }
public function index() { try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->set_table('sos_gen_duree_de_la_relation'); $crud->set_subject('Durée de la relation'); $crud->columns('name_duree_de_la_relation'); $crud->display_as('name_duree_de_la_relation', 'Durée de la relation'); $crud->order_by('name_duree_de_la_relation', 'desc'); //unsets //Requireds $crud->required_fields('name_duree_de_la_relation'); //Callbacks //field Types // Actions // Renders $output = $crud->render(); $menu = new stdClass(); $menu->n1 = true; $menu->lien3_1_13 = 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()); } }
protected function generate_crud($table, $subject = '') { // create CRUD object $this->load->library('Grocery_CRUD'); $crud = new grocery_CRUD(); $crud->set_table($table); // auto-generate subject if (empty($subject)) { $crud->set_subject(humanize(singular($table))); } // load settings from: application/config/grocery_crud.php $this->load->config('grocery_crud'); $this->mCrudUnsetFields = $this->config->item('grocery_crud_unset_fields'); if ($this->config->item('grocery_crud_unset_jquery')) { $crud->unset_jquery(); } if ($this->config->item('grocery_crud_unset_jquery_ui')) { $crud->unset_jquery_ui(); } if ($this->config->item('grocery_crud_unset_print')) { $crud->unset_print(); } if ($this->config->item('grocery_crud_unset_export')) { $crud->unset_export(); } if ($this->config->item('grocery_crud_unset_read')) { $crud->unset_read(); } foreach ($this->config->item('grocery_crud_display_as') as $key => $value) { $crud->display_as($key, $value); } // other custom logic to be done outside $this->mCrud = $crud; return $crud; }
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()); } }
function especifico() { if (!$this->tank_auth->is_logged_in()) { redirect('/auth/login/'); } else { $crud = new grocery_CRUD(); //$crud->set_theme('datatables'); // Al comentar esta linea, le pones otro estilo a la tabla. $crud->set_table('esp_especifico'); $crud->set_subject('Especificos'); $columnas = array('esp_nombre', 'esp_concepto', 'esp_presupuesto_votado', 'esp_modificaciones', 'esp_devengado', 'esp_congelado', 'esp_saldo', 'esp_estado'); $requeridos = array('esp_nombre', 'esp_concepto', 'esp_concepto', 'esp_presupuesto_votado', 'esp_saldo'); $alias = array('esp_nombre' => 'Nombre', 'esp_concepto' => 'Concepto', 'esp_presupuesto_votado' => 'Presupuesto Votado', 'esp_modificaciones' => 'Modificaciones', 'esp_devengado' => 'Devengado', 'esp_presupuesto_mod' => 'Presupuesto Modificado', 'esp_porcentaje_ejecucion' => 'Porcentaje de ejecución', 'esp_observaciones' => 'Observaciones', 'esp_congelado' => 'Congelado', 'esp_saldo' => 'Saldo', 'esp_estado' => 'Estado'); $crud->required_fields($requeridos); $crud->columns($columnas); $crud->display_as($alias); $crud->field_type('esp_usu_mod', 'hidden', $this->tank_auth->get_user_id()); $crud->field_type('esp_fecha_mod', 'hidden', date('Y-m-d H:i:s')); $crud->field_type('esp_estado', 'dropdown', array('1' => 'Activo', '0' => 'Inactivo')); // Datos generales de la pagina $data['menu_sistema'] = true; $data['vista_name'] = 'inventario/index'; $data['titulo'] = "Subcatalogos"; $data['logo'] = $this->Regional_model->get_parametro("logo"); $info['info_padre'] = $this->sistema_model->get_registro('sio_sistema_opcion', array('sio_id' => 1)); $info['menu_principal'] = $this->sistema_model->get_menu('sic_sistema_catalogo', 1); $data['menus'] = $this->load->view('menu/opciones_menu', $info, true); // Estas tres lineas son principales cuando se desea imprimir un Grocery Crud en el sistema $crud->unset_jquery(); // No llama al jQuery del Grocery Crud $output = $crud->render(); //$this->load->view('sistema/pais',$output); $data['texto'] = $this->load->view('inventario/especificos/especifico', $output, true); $this->__cargarVista($data); } }
public function manage_posts() { if (!$this->session->is_admin || !$this->session->is_admin_loggedin) { redirect('admin'); } $crud = new grocery_CRUD(); $crud->set_theme('datatables')->set_table('post')->set_subject('Post')->columns('title', 'post', 'date_posted'); // the columns from the table to be displayed in particular /* display_as('field_name', 'Label') function is use if you want to customize your field names on the table */ $crud->display_as('title', 'Post Title')->display_as('post', 'User\'s Post')->display_as('date_posted', 'Date'); /* add_fields() function is very useful when you want to add a new record to a table but only with the specific fields. Say, you don't need to set an `id` field because id is already set to auto_increment. So, here in Grocery CRUD, when you want to add a new record, you can customize what particular fields you want to be displayed. edit_fields() function is use when you want to edit a record from a table but you only want specific fields to be updated because there are fields that is not neccessary to be updated. In this case, we only want the fields: 'id','user_id', 'title', 'post', 'slug' to be editable from a table and date_posted is not neccessary. required_fields() function simply a rule when you add or update a record from a table which fields must not be null or in other words, in the add/edit form which fields are required. */ $crud->add_fields('user_id', 'title', 'post', 'slug'); $crud->edit_fields('id', 'user_id', 'title', 'post', 'slug'); $crud->required_fields('id', 'user_id', 'title', 'post', 'slug'); $output = $crud->render(); $this->load->view('admin/admin_header_view', $output); $this->load->view('admin/admin_nav_view'); $this->load->view('admin/admin_panel_view', $output); $this->load->view('admin/admin_footer_view'); }
public function afficheUtilisateur() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('user'); $crud->set_subject('Utilisateurs'); $crud->required_fields('nom', 'prenom', 'num_Tel', 'adresse', 'mail', 'mdp', 'droit'); $crud->display_as('num_Tel', 'Telephone'); $crud->display_as('mdp', 'Mot de passe'); // A MODIFIER ----------------------------- $crud->field_type('status', 'true_false', array('administrateur', 'client')); // ------------------------------------------- $crud->set_field_upload('file_url', 'assets/uploads/files'); $output = $crud->render(); $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()); } }
function administracion() { try { /* Creamos el objeto */ $crud = new grocery_CRUD(); /* Seleccionamos el tema */ $crud->set_theme('bootstrap'); /* Seleccionmos el nombre de la tabla de nuestra base de datos*/ $crud->set_table('productos'); /* Le asignamos un nombre */ $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('id', 'nombre', 'descripcion', 'precio_venta', 'existencia'); /* Aqui le indicamos que campos deseamos mostrar */ $crud->columns('id', 'proveedor', 'nombre', 'descripcion', 'precio_compra', 'precio_venta', 'existencia'); /*Le cambiamos en nombre al la columna id */ $crud->display_as('id', 'Referencia'); //$crud->unset_jquery(); /* Generamos la tabla */ $output = $crud->render(); /* La cargamos en la vista situada en /applications/views/productos/administracion.php */ $this->load->view('header'); $this->load->view('productos/administracion', $output); $this->load->view('footer'); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function 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 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 index() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('slider'); $crud->set_subject('Slider'); $crud->display_as('slider_title', 'Title'); $crud->display_as('slider_place', 'Place'); $crud->display_as('slider_price', 'Price'); $crud->display_as('slider_image', 'Image'); $crud->display_as('slider_status', 'Status'); $crud->callback_column('slider_image', array($this, 'set_image')); $crud->set_field_upload('slider_image', $this->upload_path); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Slider', 'pagedesc' => 'Slider', 'contenttitle' => 'Slider List Records'); $this->load->view('gc_admin_wrapper', $data); }
function search_course($cou_id = '') { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_subject('Course'); $crud->set_rules('cou_name', 'Code code', 'trim|required|exact_length[1]|alpha'); $crud->set_rules('cou_code', 'Course Code', 'trim|required|exact_length[3]|alpha|is_unique[course.cou_code]'); $crud->set_rules('cou_type', 'Course Type', 'trim|required|is_unique[course.cou_type]'); $crud->set_rules('cou_cluster', 'Course Cluster', 'trim|required'); $crud->display_as('cou_name', 'Code code'); $crud->display_as('cou_code', 'Course Code'); $crud->display_as('cou_type', 'Course Type'); $crud->display_as('cou_cluster', 'Course Clustear'); $crud->set_table('course'); $output = $crud->render(); $this->_main_output($output, null); }
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 index($stat = '') { try { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); switch ($stat) { case '': default: $crud->set_table('nus_staff'); $crud->set_relation('nst_id', 'nus_staff_type', 'nst_desc'); $crud->set_relation('nw_id', 'nus_ward', 'nw_name'); $crud->display_as('ns_fullname', 'Full Name')->display_as('ns_username', 'Username')->display_as('ns_password', 'Password')->display_as('nst_id', 'User Type')->display_as('nw_id', 'Ward Name'); $crud->required_fields('ns_fullname', 'ns_username', 'ns_password', 'nst_id'); break; case 'manageWadStatus': $crud->set_table('nus_bed_status'); $crud->display_as('nbs_desc', 'Description')->display_as('nbs_code', 'Code')->display_as('nc_id', 'Color'); $crud->required_fields('nbs_code', 'nbs_desc', 'nc_id'); $crud->set_relation('nc_id', 'nus_color', 'nc_desc'); break; case 'manageWard': $crud->set_table('nus_ward'); $crud->display_as('nw_name', 'Ward Name'); $crud->required_fields('nw_name'); break; case 'manageBed': $crud->set_table('nus_bed'); $crud->set_relation('nw_id', 'nus_ward', 'nw_name'); $crud->display_as('nb_bed_no', 'Bed No.')->display_as('nw_id', 'Ward Name')->display_as('np_pmi_id', 'Patient Name')->display_as('nbs_id', 'Bed Status')->display_as('nb_datetime', 'Registered Date/Time')->display_as('ns_id', 'Nurse Incharge'); $crud->required_fields('nb_bed_no', 'nw_id'); $crud->set_relation('np_pmi_id', 'nus_patient', 'np_fullname'); $crud->set_relation('nbs_id', 'nus_bed_status', 'nbs_desc'); $crud->set_relation('ns_id', 'nus_staff', 'ns_fullname'); break; case 'manageGender': $crud->set_table('nus_patient_gender'); $crud->display_as('npg_desc', 'Description')->display_as('npg_code', 'Code')->display_as('nc_id', 'Color'); $crud->set_relation('nc_id', 'nus_color', 'nc_desc'); break; } $output = $crud->render(); $this->viewpage('v_mainpage', $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }