public function index() { //$data['main_content'] = 'login_form'; //$this->load->view('includes/template',$data); //$this->load->view('admin/configuration'); //$this->load->view('admin/homepage'); $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('ips_ordertracking'); $crud->set_subject('Sales Tracking'); $crud->required_fields('NAME'); $crud->columns('ordertrackingid', 'orderid', 'name', 'orderdate'); // $crud->columns('fullfillment','orderdate','orderid','returnid','itemrece','caseid','product','status'); //$crud->fields('ordertrackingid','orderid','name','orderdate'); $crud->callback_column('ordertrackingid', array($this, '_callback_webpage_url')); $crud->callback_column('orderdate', array($this, '_callback_dateformat')); // $crud->fields('NAME'); // $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); // $crud->callback_after_insert(array($this, 'fullfillmentid_generation')); $output = $crud->render(); $state = $crud->getState(); if ($state == 'add') { redirect('store/addtracking'); } // $this->grocery_crud->set_table('ips_login'); // $output = $this->grocery_crud->render(); $this->_example_output($output); }
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); }
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 stages_management() { $crud = new grocery_CRUD(); $crud->set_table('procesos'); $crud->set_subject('Proceso'); $crud->unset_delete(); $crud->unset_edit(); $output = $crud->render(); $this->_output_crud($output, 'Procesos'); }
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 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 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 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); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('ratings'); $crud->set_subject('Ratings'); $crud->display_as('rating_id', 'Package / Hotel Name'); $crud->callback_column('rating_id', array($this, 'set_package_or_hotel')); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Ratings', 'pagedesc' => 'Ratings'); $this->load->view('gc_admin_wrapper', $data); }
public function history() { $crud = new grocery_CRUD(); $crud->set_table('pengiriman'); // $crud->columns('nama','username','email'); $crud->set_relation('id_member', 'members', 'username'); $crud->display_as('id_member', 'Username'); $crud->unset_export(); $crud->unset_print(); $crud->unset_add(); $crud->unset_delete(); $crud->unset_edit(); $output = $crud->render(); $output->title = 'History Pengiriman'; $this->template->load('template/template_main', 'admin/history_pengiriman', $output); }
public function suratperunit() { $crud = new grocery_CRUD(); $crud->set_table('distribusi'); $crud->where('id_unit', $this->uri->segment(3)); $crud->set_primary_key('id_unit', 'distribusi'); $crud->set_relation('id_unit', 'unit', 'namaGroup'); $crud->set_relation('id_surat', 'surat', 'nomorSurat'); $crud->columns('id_surat'); $crud->display_as('id_surat', 'nomor surat'); $crud->unset_add(); $crud->unset_edit(); //$crud->columns('nomorSurat','perihal','tanggal'); $output = $crud->render(); $this->_outputs($output); }
public function createtable($db) { $this->db = $this->load->database($db, true); $crud = new grocery_CRUD(); $crud->set_table('alert_logger'); $crud->set_primary_key('id'); $crud->columns('alert', 'all_alg_data', 'all_alg_file_data', 'toa', 'alert_name', 'status', 'del'); $crud->display_as('alert', 'Alert')->display_as('all_alg_file_data', 'ALG File.')->display_as('all_alg_data', 'ALG Ref.')->display_as('toa', 'Date')->display_as('alert_name', 'Name')->display_as('del', 'Deletion date'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $crud->callback_column('status', array($this, '_column_status')); $output = $crud->render(); $this->db->close(); $this->_example_output($output); }
public function questions() { $this->data['page_title'] = 'Questions'; $crud = new grocery_CRUD(); $crud->set_table('questions'); $crud->set_subject('Questions'); $crud->fields('question_name', 'metadescription', 'created_at', 'updated_at', 'scale_id', 'group', 'questionnaire_id'); $crud->set_relation('scale_id', 'scales', 'name'); $crud->set_relation('questionnaire_id', 'questionnaireone', 'questionnaire_name'); //for foreign key $crud->unset_edit()->unset_delete()->unset_read(); $crud->field_type('created_at', 'hidden'); $crud->field_type('updated_at', 'hidden'); $crud->unset_texteditor('question_name', 'full_text'); $crud->unset_texteditor('metadescription', 'full_text'); $this->data['output'] = $crud->render(); $this->render('admin/crud_view'); }
function receipts() { session_start(); if (!is_null($_SESSION['fromLogin']) && in_array($_SESSION['email'], array('*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**'))) { } else { header("Location: http://www.faizstudents.com/users/login.php"); } $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('receipts'); if ($_SESSION['email'] == '*****@*****.**') { $crud->unset_edit(); $crud->unset_delete(); } $crud->columns('Receipt_No', 'Thali_No', 'Amount', 'Date'); $output = $crud->render(); $this->_example_output($output); }
function users($page) { try { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('users'); $crud->set_relation('ut_id', 'user_type', 'ut_desc'); $crud->set_relation('u_status', 'stats', 's_desc'); $crud->display_as('u_fullname', 'Full Name')->display_as('u_username', 'Username')->display_as('u_password', 'Password')->display_as('ut_id', 'User Type')->display_as('u_status', 'Status'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $output = $crud->render(); $this->_example_output($page, $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
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); }
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($log_type = NULL) { $this->load->model('shared/log_model'); $this->config->load('grocery_crud'); $this->config->set_item('grocery_crud_character_limiter', 0); $crud = new grocery_CRUD(); if ($crud->getState() == 'list') { // get all known log types $log_types = $this->log_model->get_log_types(); $this->views['content'] = $this->load->view('admin/log/action_selector', array('log_types' => $log_types, 'selected_log_type' => $log_type), TRUE); $this->javascript[] = $this->load->view('admin/log/js/action_selector.js', NULL, TRUE); } if (!is_null($log_type) && $log_type != 'ajax_list' && $log_type != 'export' && $log_type != 'print' && $log_type != 'ajax_list_info') { $crud->where(array('action' => $log_type)); $crud->unset_columns('action'); } $crud->set_theme('bootstrap'); $crud->set_table('log'); $crud->set_subject('Logs'); // Op twee velden orderen. Grocerycrud houd zich niet aan de Codeigniter active record // maar dit werkt. $crud->order_by('date_created desc, id', 'desc'); $crud->columns('date_created', 'action', 'message', 'user_id'); $crud->set_relation('user_id', 'user', 'screen_name'); $crud->display_as('user_id', 'Gebruiker'); $crud->display_as('date_created', 'Tijd'); $crud->display_as('action', 'Actie'); $crud->display_as('message', 'Bericht'); $crud->display_as('ip_hash', 'IP-hash'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); // 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(); if (isset($this->views['content'])) { $this->views['content'] .= $crud_output->output; } else { $this->views['content'] = $crud_output->output; } $this->_layout(); }
public function tabelnya() { $crud = new grocery_CRUD(); $crud->set_table('pengaduan'); $crud->set_subject('Daftar Pengaduan'); $crud->columns('nama', 'pengaduan', 'tglpengaduan'); $crud->display_as('nama', 'Nama Pengadu'); $crud->display_as('pengaduan', 'Isi'); $crud->display_as('tglpengaduan', 'Tanggal Masuk'); $crud->unset_print(); $crud->unset_export(); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $crud->unset_read(); $output = $crud->render(); $this->load->view('home.php'); $this->load->view('vinfotambahpengaduan.php', $output); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_model('My_Custom_model'); $crud->set_table('ips_ordertracking', 'ips_productitems'); $crud->set_subject('Sales Tracking'); $crud->required_fields('NAME'); // void set_relation_n_n( string $field_name, string $relation_table, string $selection_table, string $primary_key_alias_to_this_table, string $primary_key_alias_to_selection_table , string $title_field_selection_table [ , string $priority_field_relation ] ) $crud->set_relation_n_n('orderdetails', 'ips_ordertracking', 'ips_productitems', 'ips_ordertracking', 'ordertrackingid', 'description', 'category'); // $crud->set_relation('ordertrackingid','ips_productitems','description'); // $crud->columns('ordertrackingid','fullfillment','orderdate','orderid','returnid','itemrece','caseid','product','status','Action'); // $crud->display_as('orderdate','Order Date')->display_as('orderid','Order ID')->display_as('returnid','Sales Return ID')->display_as('itemrece','Item Received')->display_as('caseid','Case ID')->display_as('product','Product Condition')->display_as('ordertrackingid','ID'); $crud->columns('ordertrackingid', 'orderid', 'description', 'category', 'product', 'itemrece', 'cost', 'mrp', 'Action'); $crud->display_as('orderid', 'Order ID')->display_as('itemrece', 'Item Received')->display_as('product', 'Product Condition')->display_as('ordertrackingid', 'ID')->display_as('description', 'Product Name')->display_as('category', 'Category')->display_as('cost', 'Recovery Min')->display_as('mrp', 'Recovery Max'); $crud->callback_column('ordertrackingid', array($this, '_callback_webpage_url')); $crud->callback_column('orderdate', array($this, '_callback_dateformat')); $crud->callback_column('fullfillment', array($this, '_callback_fullfillment')); // $crud->callback_column('product',array($this,'_callback_product')); $crud->callback_column('status', array($this, '_callback_status')); $crud->callback_column('itemrece', array($this, '_callback_itemrece')); $crud->callback_column('cost', array($this, '_callback_recovery_min')); $crud->callback_column('mrp', array($this, '_callback_recovery_max')); $crud->callback_column('Action', array($this, '_callback_viewpage_url')); $crud->unset_edit(); $crud->unset_read(); $crud->unset_delete(); // $crud->callback_after_insert(array($this, 'fullfillmentid_generation')); $output = $crud->render(); $state = $crud->getState(); if ($state == 'add') { redirect('store/addtracking'); } if ($state == 'view') { redirect('store/viewtracking'); } // $this->grocery_crud->set_table('ips_login'); // $output = $this->grocery_crud->render(); $this->_example_output($output); }
public function tabelnya() { $crud = new grocery_CRUD(); $crud->set_table('ijin'); $crud->set_subject('Ijin'); $crud->columns('nama', 'waktu', 'retribusi'); $crud->display_as('nama', 'Jenis Perijinan'); $crud->display_as('waktu', 'Waktu (hari kerja)'); $crud->display_as('retribusi', 'Retribusi'); //$crud->unset_print(); //$crud->unset_export(); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $crud->unset_read(); $output = $crud->render(); $js_files = $output->js_files; $css_files = $output->css_files; $data['output'] = $output; $data['label'] = "Info Perijinan"; $this->load->view('home.php'); $this->load->view('vinformasi.php', array('js_files' => $js_files, 'css_files' => $css_files, 'output' => $data)); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('booking_refunds'); $crud->set_subject('Booking Refund'); $crud->unset_add(); $crud->unset_delete(); $crud->unset_edit(); $crud->unset_fields('booking_ref_no'); $crud->field_type('refund_status', 'dropdown', array('1' => 'Requested', '0' => 'Rejected', '2' => 'Refunded')); $crud->field_type('item_type', 'readonly'); $crud->callback_column('item_type', function ($value, $primary_key) { return ucfirst($value); }); $crud->callback_edit_field('item_type', function ($value, $primary_key) { return ucfirst($value); }); // $crud->callback_before_update(array($this, 'modified_date_callback')); $crud->callback_column('booking_ref_no', array($this, '_show_invoice')); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Booking Refund', 'pagedesc' => 'Booking Refund', 'contenttitle' => 'Booking Refund List Records', 'left_menu' => 'agents_menu'); $this->load->view('gc_admin_wrapper', $data); }
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_berkas() { try { $crud = new grocery_CRUD(); $state = $crud->getState(); $id_kegiatan_transaksi = $this->uri->segment(3); $crud->where('id_kegiatan_transaksi', $id_kegiatan_transaksi); $crud->set_table('tbl_kegiatan_transaksi_berkas'); $crud->set_subject('Daftar Berkas Pegawai'); $crud->set_field_upload('berkas', 'assets/uploads/berkas'); $crud->fields('no', 'judul', 'berkas', 'keterangan'); $crud->columns('no', 'judul', 'berkas', 'keterangan'); $crud->order_by('id_kegiatan_transaksi_berkas', 'desc'); //$crud->change_field_type('nama_depan', 'readonly'); $crud->unset_save(); $crud->unset_add(); $crud->unset_edit(); $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()); } }
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); }
function crud_historico_incidencias() { //creamos objeto crud $crud = new grocery_CRUD(); //selecionamos la tabla incidencias $crud->set_table('incidencias'); //para quitar las opcinesd e editar $crud->unset_edit(); //quitar las opciones de añadir $crud->unset_add(); //quitar las opciones de borrar $crud->unset_delete(); $crud->like("estado", "CERRADA"); $output = $crud->render(); //a la vista-backoffice le pasamos el output(array) $this->load->view('home', $output); }
public function expired_offers() { $crud = new grocery_CRUD(); //$crud->set_theme('datatables'); $dt = new DateTime(); $now = $dt->format('Y-m-d'); $crud->where('valid_till <', $now); $crud->set_table('offers'); $crud->set_subject('Users Data'); $crud->columns('id', 'card_name', 'offer', 'offer_category', 'offer_subcategory', 'establishment_id', 'offer_type', 'amount', 'valid_till', 'offer_url', 'tnc', 'imp_tnc', 'latitude', 'longtitude', 'specific_location_exists', 'applicable_across_category', 'week_days', 'city'); // $crud->columns('id', 'card_name', 'offer'); // $crud->set_relation('card_name', 'card', 'card_name'); $crud->set_field_upload('offer_logo', 'assets/uploads/offers_logo'); $crud->set_relation('offer_category', 'categories_master', 'category'); $crud->set_relation('offer_subcategory', 'subcategories_master', 'category'); $crud->set_relation('establishment_id', 'establishment', 'establishment'); $crud->unset_columns('created_date'); $crud->unset_add_fields('created_date'); $crud->unset_edit_fields('created_date'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $data = $crud->render(); $this->load->view('admin/crud_view', $data); }
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 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); }