private function get_crud()
{
$this->data['message'] = $this->session->flashdata('message');
$crud = new grocery_CRUD();
$crud->set_theme(GROCERY_CRUD_THEME);
$crud->set_table('usuario');
$crud->set_subject('Usuário');
$crud->unset_columns('id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3', 'ultima_troca', 'cadastro');
$crud->fields('id', 'nome', 'login', 'email', 'grupos', 'tipo_usuario_id', 'situacao_usuario_id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3');
$crud->unset_texteditor('id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3', 'ultima_troca', 'cadastro');
$crud->change_field_type('id', 'invisible');
$crud->change_field_type('senha', 'invisible');
$crud->change_field_type('senha_anterior1', 'invisible');
$crud->change_field_type('senha_anterior2', 'invisible');
$crud->change_field_type('senha_anterior3', 'invisible');
$crud->set_relation('situacao_usuario_id', 'situacao_usuario', 'descricao');
$crud->display_as('situacao_usuario_id', 'Situacao');
$crud->set_relation('tipo_usuario_id', 'tipo_usuario', 'descricao');
$crud->display_as('tipo_usuario_id', 'Tipo de Usuário');
$crud->set_relation_n_n('grupos', 'grupo_usuario_x_usuario', 'grupo_usuario', 'usuario_id', 'grupo_usuario_id', 'descricao');
/* regras e campos obrigatórios */
$crud->required_fields('login', 'grupos', 'tipo_usuario_id', 'situacao_usuario_id');
$crud->set_rules('login', 'Login', 'required|min_length[2]');
$crud->set_rules('grupos', 'Grupos', 'required');
$crud->set_rules('tipo_usuario_id', 'Tipo de Usuário', 'required');
$crud->set_rules('situacao_usuario_id', 'Situação do Usuário', 'required');
$crud->callback_before_insert(array($this, 'checking_new_user'));
return $crud->render();
}
public function enfants_window($id)
{
$this->id_demande = $id;
try {
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->where('id_from_demande', $this->id_demande);
$crud->set_table('sos_enfants');
$crud->set_subject('Enfant');
$crud->unset_add();
$crud->unset_delete();
$crud->field_type('id_from_demande', 'hidden', $this->id_demande);
$crud->unset_edit_fields('id_from_kids');
$crud->set_relation('id_from_kids', 'sos_kids', "id_kid");
$crud->set_relation('recu', 'sos_gen_recu', "name_recu", null, 'name_recu ASC');
$crud->set_relation_n_n('accompagniement', 'sos_relation_accompagniement_kid', 'sos_gen_accompagniement_kid', 'id_from_enfants', 'id_from_accompagniement_kid', 'name_accompagniement_kid');
$crud->set_relation_n_n('activite', 'sos_relation_activite_kid', 'sos_gen_activite_kid', 'id_from_enfants', 'id_from_activite_kid', 'name_activite_kid');
$crud->columns('enfant', 'recu', 'activite', 'accompagniement', 'commentaire_enfant');
//$crud->display_as('id_from_kids', 'Enfants');
$crud->display_as('accompagniement', 'Accompagnement');
$crud->display_as('activite', 'Activité');
$crud->display_as('recu', 'Reçu');
$crud->display_as('id_from_kids', 'Enfant(s)');
$crud->display_as('commentaire_enfant', 'Commentaire enfant');
$crud->callback_column('accompagniement', array($this, 'accompagniement'));
$crud->callback_column('activite', array($this, 'activite'));
$crud->callback_column('enfant', array($this, 'enfant'));
$crud->required_fields('recu');
$output = $crud->render();
$this->db->where('id_demande', $this->id_demande);
$query = $this->db->get('sos_demande');
if ($query->num_rows == 1) {
$row_demande = $query->row();
}
// $my_demande = $row_demande->id_from_demande;
$menu = new stdClass();
$menu->n3 = true;
//$menu->id_1 = $my_demande;
$menu->id = $row_demande->id_from_femme;
$menu->status = $this->session->userdata('status');
$this->db->where('id_femme', $menu->id);
$query = $this->db->get('sos_femme');
if ($query->num_rows == 1) {
$row_femme = $query->row();
}
$header = $this->navigation->home_f($menu) . ' ' . '<p><pre>' . $row_femme->prenom . ' ' . $row_femme->nom . ' ' . $row_femme->nom_marital . '</pre></p>';
$data = array('output' => $output, 'header' => $header);
$this->_example_output($data);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function consultar()
{
if ($this->session->userdata('is_logged_in')) {
$crud = new grocery_CRUD();
//-> Identifico el ID del Cliente
$crud->set_table('facturas');
//->
$crud->set_theme('datatables');
$crud->set_language('spanish');
$crud->set_subject('Factura');
// Display As
$crud->unset_add();
$crud->display_as('id_moneda_pago', 'Moneda Pago');
$crud->display_as('id_cliente', 'Cliente');
$crud->display_as('id_estatus', 'Estatus');
//-> Columnas
$crud->columns('folio', 'id_cliente', 'total', 'fecha_creacion', 'id_estatus');
// Relaciones
$crud->set_relation('id_moneda_pago', 'tipos_moneda', 'descripcion');
$crud->set_relation('registrado_por', 'usuarios', 'nombre');
$crud->set_relation('id_estatus', 'formas_pago', 'descripcion');
$crud->set_relation('id_cliente', 'clientes', 'nombre');
//-> Renderizar
$output = $crud->render();
$data['titulo'] = "CONSULTAR FACTURAS";
$this->load->view('include/head', $output);
$this->load->view('include/header', $data);
$this->load->view('admin/output');
$this->load->view('admin/librerias');
$this->load->view('include/footer', $data);
} else {
$this->load->view('admin/login');
}
}
function index()
{
if ($this->session->userdata('is_logged_in')) {
$crud = new grocery_CRUD();
$crud->set_table('productos');
//->
$crud->set_theme('datatables');
$crud->set_language('spanish');
$crud->set_subject('Producto');
// Display As
$crud->display_as('id_clasificacion', 'Clasificación');
$crud->display_as('id_estatus', 'Estatus');
//-> Columnas
$crud->columns('descripcion', 'id_clasificacion', 'precio');
// Relaciones
$crud->set_relation('id_clasificacion', 'productos_clasificaciones', 'descripcion');
$crud->set_relation('id_estatus', 'disponible_nodisponible', 'descripcion');
// Upload
##
// Validacion
$crud->field_type('precio', 'integer');
$crud->required_fields('descripcion', 'id_clasificacion', 'precio');
//-> Renderizar
$output = $crud->render();
$data['titulo'] = "PRODUCTOS";
$this->load->view('include/head', $output);
$this->load->view('include/header', $data);
$this->load->view('admin/output');
$this->load->view('admin/librerias');
$this->load->view('include/footer', $data);
} else {
$this->load->view('admin/login');
}
}
public function index()
{
$crud = new grocery_CRUD();
//Jangan lupa load library ini
$this->load->library('gc_dependent_select');
$crud->set_crud_url_path(site_url('examples/index'));
$crud->set_table('data_diri');
$crud->columns('nama', 'fk_id_prov', 'fk_id_kota', 'fk_id_kec', 'fk_id_kel');
$crud->display_as('fk_id_prov', 'Provinsi')->display_as('fk_id_kota', 'Kota')->display_as('fk_id_kec', 'Kecamatan')->display_as('fk_id_kel', 'Kelurahan');
$crud->set_subject('Data Diri');
$crud->set_relation('fk_id_prov', 'provinsi', 'nama');
$crud->set_relation('fk_id_kota', 'kabupaten', 'nama');
$crud->set_relation('fk_id_kec', 'kecamatan', 'nama');
$crud->set_relation('fk_id_kel', 'kelurahan', 'nama');
$fields = array('fk_id_prov' => array('table_name' => 'provinsi', 'title' => 'nama', 'relate' => null, 'data-placeholder' => 'Pilih Provinsi'), 'fk_id_kota' => array('table_name' => 'kabupaten', 'title' => 'nama', 'id_field' => 'id_kab', 'relate' => 'id_prov', 'data-placeholder' => 'Pilih Kota'), 'fk_id_kec' => array('table_name' => 'kecamatan', 'title' => 'ID: {id_kec} / Kota : {nama}', 'id_field' => 'id_kec', 'relate' => 'id_kab', 'data-placeholder' => 'Pilih Kecamatan'), 'fk_id_kel' => array('table_name' => 'kelurahan', 'title' => 'nama', 'id_field' => 'id_kel', 'relate' => 'id_kec', 'data-placeholder' => 'Pilih Kelurahan'));
$config = array('main_table' => 'data_diri', 'main_table_primary' => 'id', "url" => site_url() . '/examples/index/', 'ajax_loader' => base_url() . 'assets/ajax-loader.gif');
$categories = new gc_dependent_select($crud, $fields, $config);
// first method:
//$output = $categories->render();
// the second method:
$js = $categories->get_js();
$output = $crud->render();
$output->output .= $js;
$this->_example_output($output);
}
public function index()
{
$bol_del_before_date = $this->m_conndb->dateBeforeDelete();
try {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('tempahan');
$crud->set_subject('Booking Room');
$crud->set_relation('m_id', 'masa', 'm_desc');
$crud->set_relation('bm_id', 'bilik_meeting', 'bm_desc');
$crud->display_as('t_datereg', 'Date Reg.')->display_as('t_date', 'Book Date')->display_as('t_day', 'Book Day')->display_as('m_id', 'Time')->display_as('t_perkara', 'Club / Item')->display_as('bm_id', 'Meeting Room')->display_as('t_status', 'Status');
$crud->columns('t_date', 't_day', 'm_id', 't_perkara', 'bm_id');
$crud->fields('t_date', 'm_id', 't_perkara', 'bm_id', 't_datereg', 't_day');
$crud->field_type('t_datereg', 'hidden');
$crud->field_type('t_day', 'hidden');
$crud->required_fields('t_date', 'm_id', 't_perkara', 'bm_id');
$umaq = $this->uri->segment(3);
if (!($this->uri->segment(3) && $umaq == 'umaqkacak')) {
$crud->unset_delete();
$crud->unset_edit();
}
$crud->callback_before_insert(array($this, 'setAutoTempahan'));
$output = $crud->render();
$this->viewpage('v_bookroom', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function get_crud_propuesta()
{
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_dialog_forms', true);
$crud = new grocery_CRUD();
$crud->set_theme('datatables2');
$crud->set_relation('id_periodo', 'gp_periodo', 'siglas');
$crud->set_relation('id_departamento', 'gp_departamentos', 'nombre_depart', array('estado_dep' => '1'));
$crud->set_relation('id_persona', 'gp_persona', '{nombres} {apellidos}');
$crud->display_as('id_periodo', 'Periodo')->display_as('id_departamento', 'Departamento')->display_as('id_persona', 'Usuario');
// $crud->set_relation('id_persona', 'gp_tipopersona', 'typo_persona');
//$crud->set_relation('id_estado', 'gp_estados', 'valor');
$crud->callback_column('estado', array($this, 'color_estado'));
$crud->callback_column('tipo_persona', array($this, 'tipo_persona'));
$crud->callback_column('asignacion_tutor', array($this, 'asigna_tutor'));
$crud->callback_column('tutor', array($this, 'view_tutor'));
$crud->callback_column('historial', array($this, 'get_historial'));
$cols = array('titulo', 'contenido', 'id_periodo', 'id_departamento', 'id_persona', 'tipo_persona', 'fecha_post', 'estado', 'tutor', 'asignacion_tutor', 'historial');
$crud->columns2($cols);
$crud->set_table('gp_propuesta');
$crud->set_subject('Tesis');
$crud->unset_add()->unset_delete()->unset_edit();
$output = $crud->render();
$this->load->view('crud/crud_view_datatable', $output);
}
public function items()
{
$crud = new grocery_CRUD();
$crud->set_table('item');
$crud->display_as('category_id', 'Categoria')->display_as('tag_id', 'Etiqueta');
$crud->set_relation('category_id', 'category', 'name');
$crud->set_relation('tag_id', 'tag', 'name');
$crud->set_field_upload('photo', 'assets/uploads/files');
$output = $crud->render();
$this->_example_output($output);
}
function ventas()
{
$crud = new grocery_CRUD();
$crud->set_table('ventas');
$crud->set_relation('producto', 'productos', 'item_name');
$crud->set_relation('unitario', 'productos', 'precio');
$crud->display_as('valor', 'Total');
$crud->unset_add();
$crud->unset_delete();
$crud->unset_edit();
$output = $crud->render();
$this->load->view('main/ventas', $output);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('bookings');
$crud->set_subject('Bookings');
// $agents = $this->ion_auth->get_all_agents();
// $user = $this->ion_auth->user()->row();
// $agents += array($user->id => $user->first_name . " " . $user->last_name);
// $crud->field_type('hotel_agent_id', 'dropdown', $agents);
$crud->set_relation('booking_agent', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1));
$crud->set_relation('agent_id', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1));
$crud->set_relation('booking_to', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1));
$crud->display_as('agent_id', 'Agent of Hotel/Package');
$crud->display_as('booking_company_commission', 'Company Commission');
$crud->display_as('booking_status', 'Status (Change Status)');
$crud->display_as('booking_agent', 'Booked By');
// $crud->display_as('hotel_name', 'Hotel Name');
// $crud->display_as('hotel_rooms', 'Rooms');
// $crud->display_as('hotel_tariffs', 'Tariffs');
$crud->field_type('booking_ref_no', 'readonly');
$crud->field_type('paypal_transaction_id', 'readonly');
$crud->field_type('booking_agent_commission', 'readonly');
$crud->field_type('booking_company_commission', 'readonly');
$crud->field_type('booking_type', 'readonly');
$crud->field_type('booking_item_title', 'readonly');
$crud->field_type('booking_date', 'readonly');
$crud->field_type('booking_payment_type', 'readonly');
$crud->field_type('booking_total', 'readonly');
$crud->field_type('booking_agent', 'readonly');
$crud->field_type('agent_id', 'readonly');
$crud->field_type('booking_to', 'readonly');
$crud->unset_columns('booking_item', 'booking_subitem', 'booking_paymethod_tax', 'ip_address', 'booking_nights');
$crud->unset_fields('booking_item', 'booking_subitem', 'booking_paymethod_tax', 'ip_address', 'booking_nights');
$crud->where('agent_id', $this->ion_auth->get_user_id());
// $crud->columns('hotel_name', 'hotel_agent_id', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook' ,'hotel_googleMap', 'hotel_status');
// $state = $crud->getState();
//
// if($state =='list' || $state =='ajax_list')
// {
$crud->set_js("assets/frontend/js/custom_functions_sam.js");
// }
$crud->add_action('Conversation', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', '', 'ui-icon-image', array($this, '_booking_conversation'));
$crud->callback_column('booking_ref_no', array($this, '_show_invoice'));
$crud->callback_edit_field('booking_status', array($this, '_edit_field_callback'));
$crud->callback_column('booking_status', array($this, '_booking_status'));
$crud->unset_add();
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Bookings', 'pagedesc' => 'Bookings', 'contenttitle' => 'Booking List Records', 'left_menu' => 'agents_menu');
$this->load->view('gc_admin_wrapper', $data);
}
public function get_crud_expe()
{
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_dialog_forms', true);
$crud = new grocery_CRUD();
$crud->set_theme('datatables2');
$crud->set_relation('id_persona', 'gp_persona', '{nombres} {apellidos}');
$crud->set_relation('id_periodo', 'gp_periodo', 'siglas', array('estado_periodo' => '1'));
$crud->set_table('gp_expediente');
$crud->set_subject('Expediente');
// $crud->unset_add();
$output = $crud->render();
$this->load->view('crud/crud_view_datatable', $output);
}
public function review_doctor()
{
if ($this->session->userdata('is_admin_logged_in')) {
$crud = new grocery_CRUD();
$crud->set_table('review_doctor');
//$crud->columns('name','address','lat','lng','phone', 'description', 'review', 'birthRateLess35', 'birthRate35To40', 'birthRateMore40', 'services');
$crud->set_subject('review_doctor');
$crud->set_relation('fk_doctor', 'doctors', 'full_name');
$crud->set_relation('fk_patient', 'patients', 'name');
$output = $crud->render();
$this->_example_output($output);
} else {
redirect('Admin/admin_restricted');
}
}
public function index()
{
try {
// General
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->set_table('sos_gen_nationalite_detailles');
$crud->set_subject('Situation administrative');
//relations
$crud->set_relation('id_from_nationalite', 'sos_gen_nationalite', 'name_nationalite');
//Master/child relations
//Visual
$crud->columns('name_nationalite_detailles', 'id_from_nationalite');
$crud->display_as('name_nationalite_detailles', 'Situation administrative');
$crud->display_as('id_from_nationalite', 'Nationalité');
//unsets
//Requireds
$crud->required_fields('name_nationalite_detailles', 'id_from_nationalite');
//Callbacks
//field Types
// Actions
// Renders
$output = $crud->render();
$menu = new stdClass();
$menu->n1 = true;
$menu->lien3_1_1_4 = false;
$menu->status = $this->session->userdata('status');
$header = $this->navigation->home_f($menu);
$data = array('output' => $output, 'header' => $header);
$this->_example_output($data);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function administration()
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('news');
$crud->set_subject('Noticias');
$crud->set_language('spanish');
$crud->unset_export();
$crud->columns('title', 'author', 'summary', 'date_time', 'active');
$crud->required_fields('title', 'author', 'fk_source', 'date_time', 'priority', 'category', 'tags');
// $crud->add_fields('title', 'author', 'image', 'footer_text', 'date_time', 'url', 'summary', 'text', 'fk_source', 'priority', 'active', 'category', 'tags', 'img');
$crud->set_relation('fk_source', 'sources', 'name');
$crud->set_relation_n_n('category', 'news_categories', 'categories', 'fk_news', 'fk_category', 'category');
$crud->set_relation_n_n('tags', 'news_tags', 'tags', 'fk_news', 'fk_tag', 'tag');
$crud->set_field_upload('image', 'assets/uploads/news/');
$crud->display_as('title', 'Título')->display_as('summary', 'Sumario')->display_as('text', 'Texto')->display_as('author', 'Autor')->display_as('date_time', 'Fecha')->display_as('active', 'Estado')->display_as('comment_url', 'URL')->display_as('comment_count', 'Comentarios')->display_as('category', 'Categoría')->display_as('tags', 'Palabras Claves')->display_as('image', 'Imagen principal')->display_as('priority', 'Prioridad')->display_as('fk_source', 'Fuente')->display_as('img', 'Imágenes Adicionales')->display_as('footer_text', 'Texto de imagen');
$crud->set_relation_n_n('img', 'news_image', 'images', 'fk_news', 'fk_image', 'image');
// $crud->set_field_upload('img', 'assets/uploads/news/');
// $crud->set_field_upload('img', 'uploads/news/');
// $crud->callback_add_field('img', array($this, 'add_field_image_callback'));
// $crud->callback_edit_field('img', array($this, 'edit_field_image_callback'));
/* Generamos la tabla */
// $crud->callback_after_insert(array($this, 'after_insert'));
// $crud->callback_before_delete(array($this, 'before_delete_log'));
// $crud->callback_after_update(array($this, 'after_update_log'));
//
$output = $crud->render();
$this->load->view('includes/template', $output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function user()
{
$crud = new grocery_CRUD();
$crud->set_table('user');
$crud->set_relation('idUnit', 'unit', 'namaGroup');
$output = $crud->render();
$this->_outputs($output);
}
function index()
{
$crud = new grocery_CRUD();
// list table
$crud->set_table('user')->set_subject('User')->columns('userid', 'ic', 'Name', 'lastname', 'Email', 'User_Group', 'define_1', 'LastUpdate', 'user_last_login')->display_as('userid', 'User ID')->display_as('ic', 'Employee ID')->display_as('Name', 'First Name')->display_as('lastname', 'Last Name')->display_as('Email', 'Email')->display_as('User_Group', 'Dept')->display_as('define_1', 'Employee Level')->display_as('LastUpdate', 'Last Update')->display_as('user_last_login', 'Last Login');
$crud->set_relation('User_Group', 'user_group', 'gName');
$crud->set_relation('define_1', 'emp_level', 'desc');
$data['title'] = $this->m_setting->getSetting();
$data['head'] = "lyt_main/head";
$data['header'] = "lyt_main/header";
$data['sidebar'] = "lyt_main/sidebar";
$data['pagetitle'] = "Manage User";
$data['content'] = "master/v_crud";
$data['footer'] = "lyt_main/footer";
$data['crud_output'] = $crud->render();
$this->load->view('tpl_main', $data);
}
public function mostrar_busqueda()
{
$grocery = new grocery_CRUD();
$grocery->set_theme('bootstrap');
$grocery->set_table('denuncias');
$grocery->set_language('spanish');
$grocery->set_relation('idEstatus', 'estatus', 'descripcion');
$grocery->set_relation('idRecepcion', 'recepcion', 'descripcion');
$grocery->set_relation('idDependencia', 'dependencias', 'dependencia');
$grocery->set_relation('idCiudadano', 'ciudadanos', '{nombre} \\n{apellidoPa} \\n{apellidoMa}');
$grocery->set_relation('idDireccion', 'direcciones', 'colonia');
$grocery->set_relation('idAsunto', 'asuntos', 'descripcion');
$grocery->set_relation('idMedios', 'medios', 'descripcion');
$grocery->display_as('idDependencia', 'Dependencia');
$grocery->display_as('idCiudadano', 'Ciudadano');
$grocery->display_as('idDireccion', 'Dirección');
$grocery->display_as('idRecepcion', 'Recepción');
$grocery->display_as('idEstatus', 'Estatus');
$grocery->display_as('idAsunto', 'Asunto');
$grocery->display_as('idMedios', 'Medios');
$grocery->unset_add();
$grocery->unset_export();
//$grocery->unset_edit();
$grocery->edit_fields('fecha', 'idDependencia', 'idEstatus', 'idRecepcion', 'idMedios');
$grocery->add_action('Editar ciudadano', '', 'ciudadanos/editar_ciudadano');
$grocery->add_action('Editar Direccion', '', 'direcciones/editar_direccion');
$grocery->add_action('Editar Asunto', '', 'asuntos/editar_asunto');
$grocery->columns('fecha', 'idDependencia', 'idCiudadano', 'idEstatus', 'idRecepcion', 'idDireccion', 'idAsunto');
$output = $grocery->render();
$this->_example_output($output);
}
public function index($stat = '')
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
switch ($stat) {
case '':
default:
$user_ward_id = $this->session->userdata('nw_id');
$crud->set_table('nus_bed');
$crud->where('nus_bed.nw_id', $user_ward_id);
$crud->columns('nb_bed_no', 'np_pmi_id', 'nbs_id', 'nb_datetime', 'ns_id');
$crud->display_as('nb_bed_no', 'Bed No.')->display_as('np_pmi_id', 'Patient Name')->display_as('nbs_id', 'Remarks')->display_as('nb_datetime', 'Date/Time Registered')->display_as('ns_id', 'Nurse');
$crud->set_relation('nbs_id', 'nus_bed_status', 'nbs_desc');
$crud->set_relation('ns_id', 'nus_staff', 'ns_fullname');
$crud->set_relation('np_pmi_id', 'nus_patient', 'np_fullname');
// $crud->unset_add();
// $crud->unset_delete();
$crud->edit_fields('np_pmi_id', 'nbs_id', 'nb_datetime', 'ns_id');
$crud->add_fields('nb_bed_no', 'nw_id', 'nbs_id');
$crud->field_type('nw_id', 'hidden');
// $crud->field_type('nbs_id', 'hidden');
$crud->required_fields('nb_bed_no');
$crud->unset_read();
// $crud->change_field_type('nb_bed_no', 'readonly');
$crud->change_field_type('ns_id', 'readonly');
$crud->callback_before_update(array($this, 'autoRegisterBed'));
$crud->callback_before_insert(array($this, 'addBed'));
break;
case 'patient':
$crud->set_table('nus_patient');
$crud->set_relation('np_gender', 'nus_patient_gender', 'npg_desc');
$crud->required_fields('np_pmi_no', 'np_fullname', 'np_ic', 'np_passport', 'np_gender');
$crud->fields('np_pmi_id', 'np_fullname', 'np_ic', 'np_passport', 'np_gender');
$crud->field_type('np_pmi_id', 'hidden');
$crud->display_as('np_pmi_id', 'PMI No.')->display_as('np_fullname', 'Full Name')->display_as('np_ic', 'IC No.')->display_as('np_passport', 'Passport No.')->display_as('np_gender', 'Gender');
$crud->callback_before_insert(array($this, 'autoInsertPriKeyPatient'));
break;
}
$output = $crud->render();
$this->viewpage('v_mainpage', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function salidas()
{
if ($this->session->userdata('id')) {
try {
/* Creamos el objeto */
$crud = new grocery_CRUD();
/* Seleccionamos el tema */
$crud->set_theme('flexigrid');
/* Seleccionmos el nombre de la tabla de nuestra base de datos*/
$crud->set_table('salida');
/* Le asignamos un nombre */
$crud->set_subject('Salidas de productos');
$crud->set_relation('producto', 'productos', 'nombre');
$crud->set_relation('cliente', 'clientes', 'nombre');
//$crud->display_as('proveedor','Proveedor');
//$crud->set_subject('productos');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('producto', 'cantidad', 'cliente', 'folio', 'comentarios', 'precio', 'total');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('id', 'producto', 'cantidad', 'cliente', 'folio', 'comentarios', 'precio', 'total');
$crud->callback_column('precio', array($this, 'valuePeso'));
$crud->callback_column('total', array($this, 'valuePeso'));
$crud->callback_before_insert(array($this, 'checking_post_cantidad'));
$crud->unset_delete();
$crud->unset_edit();
$crud->unset_export();
//$crud->add_action('Smileys', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', 'demo/action_smiley');
//$crud->callback_edit_field('cantidad',array($this,'edit_field_callback_1'));
//$crud->callback_add_field('cantidad',array($this,'edit_field_callback_2'));
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en
/applications/views/productos/administracion.php */
$this->_example_output($output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
} else {
redirect('Login');
}
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('hotel_rooms');
$crud->set_subject('Hotel Rooms');
// $crud->unset_fields('ht_id');
$crud->display_as('room_hotel', 'Hotel Name');
$crud->display_as('hotel_title', 'Room Name');
$crud->display_as('room_desc', 'Room Description');
$crud->display_as('room_basic_price', 'Selling Price');
$crud->display_as('room_cost_price', 'Cost Price');
$crud->display_as('room_market_price', 'Market Price');
$crud->display_as('room_service_charge', 'Service Charge');
$crud->display_as('room_vat', 'VAT');
$crud->columns(array('room_hotel', 'room_title', 'room_vat', 'room_service_charge', 'room_cost_price', 'room_basic_price', 'room_basic_discount', 'room_order', 'room_quantity', 'room_added_on', 'room_status'));
$crud->callback_column('room_basic_price', array($this, 'set_price'));
//
$crud->callback_read_field('room_basic_price', array($this, 'set_price'));
// crud library modified SAM for read_field
$crud->callback_column('room_basic_discount', array($this, 'set_price'));
//
$crud->callback_read_field('room_basic_discount', array($this, 'set_price'));
// crud library modified SAM for read_field
$crud->callback_add_field('room_cost_price', function ($value, $primary_key) {
return "USD <input id='field-room_cost_price' class='form-control' name='room_cost_price' type='text' value='' maxlength='20'>";
});
$crud->callback_add_field('room_market_price', function ($value, $primary_key) {
return "USD <input id='field-room_market_price' class='form-control' name='room_market_price' type='text' value='' maxlength='20'>";
});
$crud->callback_edit_field('room_cost_price', function ($value, $primary_key) {
return "USD <input id='field-room_cost_price' class='form-control' name='room_cost_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_edit_field('room_market_price', function ($value, $primary_key) {
return "USD <input id='field-room_market_price' class='form-control' name='room_market_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_add_field('room_basic_price', function ($value, $primary_key) {
return "USD <input id='field-room_basic_price' class='form-control' name='room_basic_price' type='text' value='' maxlength='20'>";
});
$crud->callback_edit_field('room_basic_price', function ($value, $primary_key) {
return "USD <input id='field-room_basic_price' class='form-control' name='room_basic_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_add_field('room_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-room_basic_discount' class='form-control' name='room_basic_discount' type='text' value='' maxlength='20'>";
});
$crud->callback_edit_field('room_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-room_basic_discount' class='form-control' name='room_basic_discount' type='text' value='{$value}' maxlength='20'>";
});
$crud->set_relation('room_hotel', 'hotels', '{hotel_name}');
$hrf = $this->generic_model->get_by('hotel_room_facilities', array('hrf_status' => 1), 'hrf_id');
$hrf = $this->generic_model->array_from_db($hrf, 'hrf_id, hrf_facility');
$crud->field_type('room_facilities', 'multiselect', $hrf);
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotel Tariffs', 'pagedesc' => 'Hotel Tariffs', 'contenttitle' => 'Hotel Tariffs List Records');
$this->load->view('gc_admin_wrapper', $data);
}
public function get_crud_add_mod_usuarios()
{
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_dialog_forms', true);
$crud = new grocery_CRUD();
$crud->set_theme('datatables2');
$crud->set_relation('id_tipopersona', 'gp_tipopersona', 'typo_persona');
$crud->set_relation('id_departamento', 'gp_departamentos', 'nombre_depart', array('estado_dep' => '1'));
$crud->set_relation_n_n('modulos', 'gp_mod_persona', 'gp_modulos', 'id_persona', 'id_modulo', 'modulos');
$crud->set_table('gp_persona');
// $crud->callback_column('modulos', array($this, 'view_modulos'));
$crud->callback_column('add_modulos', array($this, 'add_modulos'));
$columns = array('cedula', 'nombres', 'apellidos', 'id_tipopersona', 'id_departamento', 'modulos', 'add_modulos');
$crud->columns2($columns);
$crud->set_subject('Estudiante');
$crud->unset_add()->unset_delete()->unset_edit();
$output = $crud->render();
$this->load->view('crud/crud_view_datatable', $output);
}
public function join()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('estudiante');
$crud->set_subject('estudiante');
$crud->set_relation('id_carrera', 'carrera', 'nom_carr');
//$crud->columns('cod_est','nom_est','nom_carr');
$output = $crud->render();
$this->_example_output($output);
}
public function autogenerated_tree()
{
$this->data['page_title'] = 'Autogenerated Tree';
$crud = new grocery_CRUD();
$crud->set_table('autogeneratetree');
$crud->set_subject('attributes');
$crud->set_relation('parent_id', 'autogeneratetree', 'nodename');
$crud->unset_edit()->unset_delete()->unset_read();
$this->data['output'] = $crud->render();
$this->render('admin/crud_view');
}
function orders_management()
{
$crud = new grocery_CRUD();
$crud->set_relation('customerNumber', 'customers', '{contactLastName} {contactFirstName}');
$crud->display_as('customerNumber', 'Customer');
$crud->set_table('orders');
$crud->set_subject('Order');
$crud->unset_add();
$crud->unset_delete();
$output = $crud->render();
$this->_example_output($output);
}
public function crud()
{
$crud = new grocery_CRUD();
$crud->set_theme(THEMA_CRUD);
$crud->set_table('quadra');
$crud->set_subject('Quadra');
//@todo$crud->where('situacao_id', 2); //apenas ativos
$crud->required_fields('descricao', 'tipo_quadra_id', '');
$crud->columns('id', 'descricao', 'tipo_quadra_id', 'situacao_quadra_id');
$crud->edit_fields('descricao', 'tipo_quadra_id', 'situacao_quadra_id');
$crud->add_fields('descricao', 'tipo_quadra_id', 'situacao_quadra_id');
//relacionamentos
$crud->set_relation('situacao_quadra_id', 'situacao_quadra', 'descricao');
$crud->set_relation('tipo_quadra_id', 'tipo_quadra', 'descricao');
$crud->callback_insert(array($this, 'create'));
$crud->callback_delete(array($this, 'delete'));
$contents = $crud->render();
$this->template->set('titulo', 'Manter Quadra');
$this->template->set('subtitle', 'Quadra');
$this->template->load('template_teste', 'crudpage', $contents);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_table('nav_menu');
$crud->columns('title', 'parent', 'type', 'link_url');
$crud->callback_column('link_url', array($this, 'link_callback'));
$crud->callback_column('maps', array($this, 'maps_callback'));
// $crud->callback_before_insert(array($this,'encrypt_password_callback'));
// $crud->callback_before_update(array($this,'encrypt_password_callback'));
$crud->set_subject('Main Menu');
$crud->fields('title', 'parent', 'type', 'link_url', 'static_pages');
$crud->set_relation('parent', 'nav_menu', 'title');
$crud->set_relation('static_pages', 'pages', 'title');
$crud->required_fields('title', 'type');
//$crud->set_relation_n_n('access_control', 'usrmgr_access', 'modul', 'id_users', 'id_modul', 'nama_modul','priority');
//$crud->set_relation('salesRepEmployeeNumber','employees','lastName');
$output = $crud->render();
$data['subject'] = 'Menu Navigation';
$data['content'] = $this->load->view('crud.php', $output, true);
$this->load->view('base_theme', $data);
}
public function usuarios()
{
$crud = new grocery_CRUD();
$crud->set_table("usuarios");
$crud->required_fields('email', 'clave', 'nombre');
$crud->field_type('clave', 'password');
$crud->set_relation('idrol', 'roles', 'descripcion');
$crud->display_as('idrol', 'Rol');
$crud->callback_before_insert(array($this->User_Model, 'encrypt_password_callback'));
$output = $crud->render();
$this->cargarVista($output);
}
public function denuncias_por_ciudadano($idCiudadano)
{
$crud = new grocery_CRUD();
$crud->set_theme('bootstrap');
$crud->set_language('spanish');
$crud->where('denuncias.idCiudadano', $idCiudadano);
$crud->set_table('denuncias');
$crud->set_subject('Denuncias Por Ciudadano');
$crud->set_relation('idCiudadano', 'ciudadanos', '{nombre}\\n{apellidoPa}\\n{apellidoMa}');
$crud->set_relation('idRecepcion', 'recepcion', 'descripcion');
$crud->set_relation('idDependencia', 'dependencias', 'dependencia');
$crud->set_relation('idEstatus', 'estatus', 'descripcion');
$crud->set_relation('idDireccion', 'direcciones', 'Calle:{calle} \\n #:{noExt} # Int:{noInt} Col:{colonia}, \\n{localidad}, CP:{cp} ');
$crud->set_relation('idAsunto', 'asuntos', 'descripcion');
$crud->display_as('idCiudadano', 'Ciudadano');
$crud->display_as('idDireccion', 'Dirección');
$crud->display_as('idRecepcion', 'Recepción');
$crud->display_as('idEstatus', 'Estatus');
$crud->display_as('idDependencia', 'Dependencia');
$crud->display_as('idAsunto', 'Asunto');
$crud->unset_add();
$crud->columns('idCiudadano', 'idAsunto', 'idDependencia', 'idEstatus', 'idDireccion', 'idRecepcion');
$output = $crud->render();
$this->_example_output($output);
}
public function employees_management()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('employees');
$crud->set_relation('officeCode', 'offices', 'city');
$crud->display_as('officeCode', 'Office City');
$crud->set_subject('Employee');
$crud->required_fields('lastName');
$crud->set_field_upload('file_url', 'assets/uploads/files');
$output = $crud->render();
$this->_example_output($output);
}
function timeslots_management()
{
$crud = new grocery_CRUD();
$crud->set_table('bloques_tipo');
$crud->set_theme('datatables');
$crud->set_subject('Bloques');
$crud->columns('id_bloque_categoria', 'nombre');
$crud->display_as('id_bloque_categoria', 'Categorias');
$crud->set_relation('id_bloque_categoria', 'bloques_categorias', 'nombre');
$crud->unset_delete();
$output = $crud->render();
$this->_output_crud($output, 'Bloques');
}
