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; }
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 listarNeumonias() { $sub = $this->frontend_model->buscarDiresas(); $subr = array(); foreach ($sub as $dato) { $subr[$dato->codigo] = $dato->nombre; } $est = $this->frontend_model->listaEstablec(); $estab = array(); foreach ($est as $dato) { $estab[$dato->cod_est] = $dato->raz_soc; } $crud = new grocery_CRUD(); $crud->set_table('neumonias'); $crud->columns('diresa', 'e_salud', 'apepat', 'apemat', 'nombres', 'sexo', 'fecha_reg', 'fecha_def', 'usuario'); $crud->set_subject('Ficha'); $nivelUsuario = $this->session->userdata("nivel"); switch ($nivelUsuario) { case '8': $where = array('e_salud' => $this->session->userdata("establecimiento")); $crud->where($where); break; case '7': $where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa")); $crud->where($where); break; case '6': $where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa")); $crud->where($where); break; case '5': $where = array('diresa' => $this->session->userdata("diresa")); $crud->where($where); break; } $crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino')); $crud->field_type('diresa', 'dropdown', $subr); $crud->field_type('e_salud', 'dropdown', $estab); $crud->display_as("apepat", "Apellido Paterno"); $crud->display_as("apemat", "Apellido Materno"); $crud->display_as("fecha_reg", "Registro"); $crud->display_as("fecha_def", "Defunción"); $crud->display_as("e_salud", "Establecimiento"); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); $crud->unset_export(); //$crud->unset_print(); $crud->callback_after_delete(array($this, 'log_usuario_before_delete')); $crud->add_action_peru('', '', 'RegfichaNeum', 'add-icon'); $crud->add_action('Modificar Ficha', '', 'modulos3/ModfichaNeum', 'edit-icon'); $crud->add_action('Ver Ficha', '', 'modulos3/VerfichaNeum', 'read-icon'); $output = $crud->render(); $this->_example_output($output); }
public function listar_transito() { /*$establecimiento = $this->mantenimiento_transito->listarEstablecimiento(); foreach($establecimiento as $dato){ $est[$dato->cod_est] = $dato->raz_soc; } */ $crud = new grocery_CRUD(); //$crud->set_theme('bootstrap'); $crud->set_table('trans_lesacctra'); $crud->columns('id', 'ano', 'ap_nm1', 'ap_nm2', 'nom_les', 'edad', 'tipo_edad', 'diresa', 'eess'); $crud->set_subject('Ficha Transito'); $nivelUsuario = $this->session->userdata("nivel"); switch ($nivelUsuario) { case '8': $where = array('cod_eess' => $this->session->userdata("establecimiento")); $crud->where($where); break; case '7': //$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red' and microred = '$microred')"; $where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa")); $crud->where($where); break; case '6': //$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red')"; $where = array('red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa")); $crud->where($where); break; case '5': $where = array('cod_dir' => $this->session->userdata("diresa")); $crud->where($where); break; } //$crud->field_type('establec', 'dropdown', $est); $crud->display_as("id", "ID")->display_as("ano", "AÑO")->display_as("ap_nm1", "APELLIDO PATERNO")->display_as("ap_nm2", "APELLIDO MATERNO")->display_as("nom_les", "NOMBRES")->display_as("edad", "EDAD")->display_as("tipo_edad", "TIPO")->display_as("diresa", "DIRESA")->display_as("eess", "ESTABLECIENTO DE SALUD"); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); $crud->unset_print(); $crud->unset_export(); $crud->unset_delete(); $crud->order_by('id', 'desc'); $crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulotransito/borrarFichatransito', 'borrar-icon'); $crud->add_action('Vista previa', '', 'modulotransito/ver_ficha_transito', 'read-icon'); $crud->add_action('Editar Ficha Transito', '', 'modulotransito/modificacion_transito', 'edit-icon'); $output = $crud->render(); $usuario = $this->session->userdata("usuario"); $accion = 'Listar Casos Accidentes de Transito'; $this->login_model->auditoriaOperador($usuario, $accion); $this->layout->view('listar_transito', $output); }
public function pengaturan() { $crud = new grocery_CRUD(); $crud->set_table('pengaturan'); $crud->unset_add(); $crud->unset_delete(); $crud->unset_read(); $output = $crud->render(); //Config Halaman $output->judul_besar = 'Pengaturan'; $output->judul_kecil = 'Manage Pengaturan'; $output->m_pengaturan = TRUE; // echo $this->Absensi_model->get_status_mesin(); //$this->Absensi_model->get_data_absen(); $this->_example_output($output); }
private function master() { $crud = new grocery_CRUD(); $crud->set_table('contents'); $crud->unset_columns('jenis', 'slug', 'isi'); $crud->callback_before_insert(array($this, "_timestamp")); $crud->callback_before_update(array($this, "_timestamp")); $crud->unset_export(); $crud->unset_print(); $crud->unset_read(); $crud->change_field_type('jenis', 'invisible'); $crud->change_field_type('slug', 'invisible'); $crud->change_field_type('created_at', 'invisible'); $crud->change_field_type('updated_at', 'invisible'); return $crud; }
public function index() { $crud = new grocery_CRUD(); $crud->set_table('admin'); $crud->columns('nama', 'username', 'email', 'last_login', 'role'); $crud->unset_export(); $crud->unset_print(); $crud->unset_read(); $crud->unset_edit_fields('password'); $crud->callback_before_insert(array($this, "_timestamp")); $crud->change_field_type('created_at', 'invisible'); $crud->change_field_type('updated_at', 'invisible'); $crud->change_field_type('last_login', 'invisible'); $output = $crud->render(); $output->title = 'Kelola Admin'; $this->template->load('template/template_main', 'admin/contents', $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()); } }
public function mostrar_usuarios() { $grocery = new grocery_CRUD(); $grocery->set_theme('bootstrap'); $grocery->set_table('users'); $grocery->set_language('spanish'); $grocery->display_as('username', 'Usuario'); $grocery->display_as('email', 'E-mail'); $grocery->fields('username', 'email'); $grocery->unset_read(); $grocery->columns('username', 'password', 'email'); $grocery->field_type('password', 'password'); $grocery->unset_add(); $grocery->unset_export(); $grocery->unset_print(); $output = $grocery->render(); $this->_example_output($output); }
public function listarMnp() { $crud = new grocery_CRUD(); $crud->set_table('mnp'); $crud->columns('registroId', 'ape_nom', 'sexo', 'fecha_nac', 'fecha_mte', 'fecha_reg', 'usuario'); $crud->set_subject('Ficha'); $nivelUsuario = $this->session->userdata("nivel"); switch ($nivelUsuario) { case '8': $where = array('e_salud' => $this->session->userdata("establecimiento")); $crud->where($where); break; case '7': $where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa")); $crud->where($where); break; case '6': $where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa")); $crud->where($where); break; case '5': $where = array('diresa' => $this->session->userdata("diresa")); $crud->where($where); break; } $crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino', 'I' => 'Indeterminado')); $crud->display_as("registroId", "Ficha"); $crud->display_as("ape_nom", "Apellidos y Nombres"); $crud->display_as("fecha_nac", "Fecha de Nacimiento"); $crud->display_as("fecha_mte", "Defunción"); $crud->display_as("fecha_reg", "Fecha de Registro"); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); $crud->unset_export(); $crud->unset_delete(); //$crud->unset_print(); $crud->add_action_peru('', '', 'RegfichaMnp', 'add-icon'); $crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulosmnp/delFichaMnp', 'borrar-icon'); $crud->add_action('Modificar Ficha', '', 'modulosmnp/ModfichaMnp', 'edit-icon'); $crud->add_action('Ver Ficha', '', 'modulosmnp/VerfichaMnp', 'read-icon'); $output = $crud->render(); $this->_example_output($output); }
public function 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_crud_url_path(site_url('Barcode/index')); $crud->set_table('data'); //Nama Tabel $crud->set_subject('Barcode'); $crud->unset_read(); $crud->unset_export(); $crud->unset_print(); $crud->add_action('Generate Barcode', '', '', 'barcode-icon', array($this, 'ca_barcode')); //Custom Action $output = $crud->render(); //Config Halaman $output->judul_besar = 'Barcode'; $output->judul_kecil = 'Generate Barcode'; $output->m_barcode = TRUE; $this->_example_output($output); }
public function tabelnya() { $crud = new grocery_CRUD(); $crud->set_table('busaha'); $crud->set_subject('Bidang Usaha'); //$crud->columns('judul'); //$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'] = "Master Bidang Usaha"; $this->load->view('home.php'); $this->load->view('vtabel_master.php', array('js_files' => $js_files, 'css_files' => $css_files, 'output' => $data)); }
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 listarUsuariosAdministradores() { $adm = $this->usuarios_model->buscarAdministrador($this->session->userdata('usuario')); $administrador = array(); foreach ($adm as $dato) { $administrador[$dato->usuario] = $dato->nombres; } $crud = new grocery_CRUD(); $crud->set_table('usuarios_backend'); $crud->columns('usuario', 'nombres', 'dni', 'correo', 'nivel', 'estado', 'codigo', 'autoriza', 'caduca', 'registro'); $crud->display_as('registroId', 'from usuarios_backend')->display_as('usuario', 'Usuario')->display_as('contrasena', 'Contraseña'); $crud->change_field_type('clave', 'password'); $crud->set_subject('Usuario'); $crud->field_type('nivel', 'dropdown', array('1' => 'Administrador', '2' => 'Operador')); $crud->field_type('estado', 'dropdown', array('1' => 'Activo', '2' => 'Inactivo')); $crud->field_type('autoriza', 'dropdown', $administrador); $crud->callback_before_insert(array($this, 'encrypt_password_callback')); $crud->callback_before_update(array($this, 'encrypt_password_callback')); $crud->unset_read(); $output = $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 irasCampos() { if (empty($this->session_id)) { redirect(site_url("index/login"), 301); } $reporta = array('ano' => date('Y'), 'semana' => date('W') - 2); $this->reportes_model->registraCalidad($reporta); $this->calidad_model->edasCampos(); $crud = new grocery_CRUD(); $crud->set_table('irasDefunciones'); $crud->columns('ano', 'semana', 'sub_reg_nt', 'red', 'microred', 'e_salud', 'ubigeo', 'ira_m2', 'ira_2_11', 'ira_1_4a', 'neu_2_11', 'neu_1_4a', 'ngr_m2', 'ngr_2_11', 'ngr_1_4a'); $crud->display_as('ano', 'Año'); switch ($this->session->userdata('nivel')) { case 4: $accesar = $this->session->userdata('equipo'); break; case 5: $accesar = $this->session->userdata('diresa'); $crud->or_where(array('sub_reg_nt' => $accesar)); break; case 6: $accesar = $this->session->userdata('diresa'); $accesar1 = $this->session->userdata('red'); $crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1)); break; case 7: $accesar = $this->session->userdata('diresa'); $accesar1 = $this->session->userdata('red'); $accesar2 = $this->session->userdata('microred'); $crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2)); break; case 8: $accesar = $this->session->userdata('establecimiento'); $crud->where(array('e_salud' => $accesar)); break; } $crud->order_by('semana'); $crud->unset_add(); $crud->unset_read(); $crud->unset_edit(); //$crud->unset_delete(); //$crud->unset_export(); $crud->unset_print(); $crud->add_action('Editar', '', 'calidad/modIras', 'edit-icon'); $crud->callback_after_delete(array($this, 'log_iras_registro_after_delete')); $output = $crud->render(); $this->layout->view('irasCampos.php', $output); }
public function 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); }
public function KLUI($jenis) { $crud = new grocery_CRUD(); $crud->set_table('klui'); $crud->columns('kbli', 'kegiatan_pokok'); $crud->display_as('kbli', 'KBLI'); $crud->display_as('kegiatan_pokok', 'Kegiatan Pokok'); $crud->add_action('Pilih', '', 'klui', 'sk-icon'); $crud->unset_export(); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $crud->unset_print(); $crud->unset_read(); $crud->set_crud_url_path(site_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), site_url(strtolower(__CLASS__ . "/" . $jenis))); $output = $crud->render(); return $output; }
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); }
function supervisor_management() { $id = $this->ion_auth->user()->row()->id; $this->load->library('grocery_CRUD'); try { $crud = new grocery_CRUD(); $this->load->library('user_agent'); if ($this->agent->is_mobile() && $this->agent->is_tablet() === FALSE) { $crud->set_theme('bootstrap'); $crud->unset_search(); } else { $crud->set_theme('datatables'); //datatables, flexigrid, bootstrap } $crud->set_table('users'); $crud->set_subject('Supervisor'); $crud->columns('username', 'password_visible', 'su_branch_id', 'su_can_uploadhotdeal'); $crud->required_fields('username', 'password_visible', 'su_branch_id'); $crud->fields('username', 'password_visible', 'su_branch_id', 'su_can_uploadhotdeal'); $crud->display_as('password_visible', 'Password'); $crud->display_as('su_branch_id', 'Branch'); $crud->display_as('su_can_uploadhotdeal', 'Able to upload food & beverage'); $crud->callback_add_field('su_branch_id', array($this, '_selected_branch_callback')); //For add page set pre-selected value if got pass in brach id $crud->field_type('su_branch_id', 'dropdown', $this->ion_auth->get_merchant_branch_list($id)); //For view show the branch list text $crud->callback_insert(array($this, 'supervisor_insert_callback')); $crud->callback_update(array($this, 'supervisor_update_callback')); $crud->set_rules('username', 'Username', 'trim|required|callback_supervisor_username_check'); $crud->field_type('su_can_uploadhotdeal', 'true_false'); $controller = 'merchant'; $function = 'profile'; $crud->set_lang_string('insert_success_message', 'Your data has been successfully stored into the database. <script type="text/javascript"> var originallocation = window.location.pathname; if(originallocation.indexOf("/supervisor/add") > -1) { window.location = "' . site_url($controller . '/' . $function) . '"; } </script> <div style="display:none"> '); $crud->set_lang_string('update_success_message', 'Your data has been successfully stored into the database. <script type="text/javascript"> var originallocation = window.location.pathname; if(originallocation.indexOf("/supervisor/edit") > -1) { window.location = "' . site_url($controller . '/' . $function) . '"; } </script> <div style="display:none"> '); $crud->set_lang_string('form_save_and_go_back', 'Save and View Supervisor'); $crud->set_lang_string('form_update_and_go_back', 'Update and View Supervisor'); $crud->unset_export(); $crud->unset_print(); $crud->unset_read(); $state = $crud->getState(); //filter that this is supervisor type user and it is under this merchant $crud->where('su_merchant_id', $id); $crud->where('main_group_id', $this->group_id_supervisor); $output = $crud->render(); return $output; } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function notificacionAutoriza() { $anio = array(); for ($i = 2010; $i <= date("Y"); $i++) { $anio[$i] = $i; } $semana = array(); for ($i = 1; $i <= 53; $i++) { $semana[$i] = $i; } $sub = $this->frontend_model->buscarDiresas(); $subr = array(); foreach ($sub as $dato) { $subr[$dato->codigo] = $dato->nombre; } $tipo = array('1' => 'Autorizado', '2' => 'No autorizado'); $crud = new grocery_CRUD(); $crud->columns('ano', 'semana', 'diresa', 'estado', 'fecha', 'hora', 'usuario'); $crud->set_table('autoriza'); $crud->set_subject('Autorización'); $crud->fields('ano', 'semana', 'diresa', 'estado'); $crud->display_as('ano', 'Año'); $crud->field_type('ano', 'dropdown', $anio); $crud->field_type('semana', 'dropdown', $semana); $crud->field_type('diresa', 'dropdown', $subr); $crud->field_type('estado', 'dropdown', $tipo); $crud->required_fields('diresa', 'ano', 'semana', 'estado'); $crud->order_by('ano, semana', 'DESC'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); //$crud->unset_export(); $crud->unset_DELETE(); $crud->unset_print(); $output = $crud->render(); $this->_example_output1($output); }
public function vperusahaan($jenis) { $crud = new grocery_CRUD(); $crud->set_table('vperusahaan'); $crud->columns('npwp', 'nama', 'alamat'); $crud->set_primary_key('id', 'vperusahaan'); $crud->display_as('npwp', 'NPWP Perusahaan'); $crud->display_as('nama', 'Nama Perusahaan'); $crud->add_action('Pilih', '', 'perus', 'sk-icon'); $crud->unset_export(); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $crud->unset_print(); $crud->unset_read(); $crud->set_crud_url_path(site_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), site_url(strtolower(__CLASS__ . "/" . $jenis))); $output = $crud->render(); return $output; }
public function listarEstado() { $estado = array('0' => '<b>En Mantenimiento</b>', '1' => '<b>En línea</b>'); $crud = new grocery_CRUD(); $crud->set_table('mantenimiento'); $crud->field_type('estado', 'dropdown', $estado); $crud->unset_add(); $crud->unset_read(); //$crud->unset_edit(); $crud->unset_delete(); $crud->unset_print(); $output = $crud->render(); $this->_example_output18($output); }
function good_copy() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('good_copy'); $crud->set_relation('test_id', 'mains_tests', '{test_id}-{test_name}', null, 'test_id desc'); $crud->set_field_upload('path', 'assets/uploads/files/good_copy'); $crud->add_action('Download', '', 'admin/download_good_copy', 'ui-icon-plus'); $crud->unset_print(); $crud->unset_export(); //$crud->unset_add(); // $crud->unset_edit(); $crud->unset_delete(); $crud->unset_read(); $output = $crud->render(); $this->_example_output($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 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 listadoEdas() { $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; } $est = $this->frontend_model->listaEstablec(); $establec = array(); foreach ($est as $dato) { $establec[$dato->cod_est] = $dato->raz_soc; } $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('ano') ? $filtro['ano'] = $this->input->post('ano') : ''; $this->input->post('semana') ? $filtro['semana'] = $this->input->post('semana') : ''; $crud = new grocery_CRUD(); $crud->set_theme("datatables"); $crud->set_table('edas'); $crud->columns('ano', 'semana', 'sub_reg_nt', 'e_salud', 'ubigeo', 'daa_c1', 'daa_c1_4', 'daa_c5', 'dis_c1', 'dis_c1_4', 'dis_c5'); $crud->display_as('ano', 'Año')->display_as('e_salud', 'Establecimiento')->display_as('sub_reg_nt', 'Diresa'); $crud->field_type('sub_reg_nt', 'dropdown', $subr); $crud->field_type('e_salud', 'dropdown', $establec); $crud->field_type('ubigeo', 'dropdown', $ubigeo); 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'), 'sub_reg_nt' => $accesar)); } else { $crud->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('Atenciones'); $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', '', 'edas/modEdas', 'ui-icon-pencil'); /////////////////////////////////////////////////////////////////////////////// //$crud->add_action_peru('Añadir EDAS', '', 'regEdas','add-icon'); /////////////////////////////////////////////////////////////////////////////// $output = $crud->render(); $this->_example_output1($output); }
public function kegiatan_lama() { $status = $this->input->get("status"); $crud = new grocery_CRUD(); $crud->where("tbl_kegiatan_transaksi.status", "Lama"); $crud->set_table('tbl_kegiatan_transaksi'); $crud->set_subject('Kegiatan Lama'); $crud->set_relation('change_by', 'tbl_user', 'email'); $crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}'); $crud->set_relation('id_kegiatan_butir', 'view_kegiatan_butir', '{unsur} - {subunsur} - {butir}'); $crud->set_primary_key('id_kegiatan_butir', 'view_kegiatan_butir'); $crud->required_fields('tanggal_kegiatan', 'tanggal_kegiatan_selesai'); $crud->fields('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'status', 'change_by', 'change_date'); $crud->columns('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'status'); $crud->display_as("id_kegiatan_butir", "Butir Kegiatan")->display_as("tanggal_kegiatan", "Tanggal Mulai")->display_as("tanggal_kegiatan_selesai", "Tanggal Selesai")->display_as("id_user", "Oleh")->display_as("change_date", "Tanggal")->display_as("id_periode", "Periode")->display_as("id_kegiatan_jabatan", "Bertindak Sebagai"); $crud->callback_add_field('id_user', array($this, '_form_get_user_callback')); $crud->callback_edit_field('id_user', array($this, '_form_get_user_callback')); $crud->callback_add_field('status', array($this, '_kegiatan_lama_get_status_callback')); $crud->callback_edit_field('status', array($this, '_kegiatan_lama_get_status_callback')); $crud->callback_before_update(array($this, 'get_change_by_callback')); $crud->callback_before_insert(array($this, 'get_change_by_callback')); $crud->callback_field('change_date', array($this, 'format_date_callback')); $crud->change_field_type('id_user', 'readonly'); $crud->change_field_type('change_by', 'readonly'); $crud->change_field_type('change_date', 'readonly'); $crud->add_action('Unggah Bukti', '', 'pegawai/daftar_kegiatan_berkas', 'fa fa-upload'); $crud->unset_read(); $crud->order_by('id_kegiatan_transaksi', 'desc'); $sitemap = $this->get_sitemap(); $output = $crud->render($sitemap); $this->load->view('theme/theme_pegawai', $output); }
public function listarBrotes() { $eess = $this->fichas_model->mostrarEstablecimiento(); foreach ($eess as $dato) { $establec[$dato->cod_est] = $dato->raz_soc; } $crud = new grocery_CRUD(); $crud->set_table('bplaguicidas'); $crud->columns('e_salud', 'ubigeo', 'codigo', 'fecha_loc', 'fecha_est', 'fecha_inv', 'fecha_dir', 'fecha_not', 'fecha_rep'); $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('e_salud', 'dropdown', $establec); $crud->set_relation('ubigeo', 'distrito', 'nombre'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); $crud->unset_export(); $crud->unset_delete(); $crud->add_action_peru('', '', 'registrarBrote', 'add-icon'); $crud->add_action('Registrar Intoxicados', '', 'modulos4/listarGrillaBrotes', 'more-icon'); $crud->add_action('Registrar Ficha', '', 'modulos4/modificarBrote', 'edit-icon'); $output = $crud->render(); $this->_example_output2($output); }