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['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_disposition');
$crud->set_subject('Disposition');
$crud->required_fields('NAME');
$crud->columns('NAME', 'DISABLE');
$crud->fields('NAME');
// $crud->unset_add();
// $crud->unset_edit();
$crud->unset_delete();
$crud->set_lang_string('insert_success_message', 'Your data has been successfully stored into the database.<br/>Please wait while you are redirecting to the list page.
<script type="text/javascript">
window.location = "' . site_url('admin/disposition') . '";
</script>
<div style="display:none">
');
$crud->callback_after_insert(array($this, 'disposition_generation'));
$output = $crud->render();
// $this->grocery_crud->set_table('ips_login');
// $output = $this->grocery_crud->render();
$this->_example_output($output);
}
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 manage_posts()
{
if (!$this->session->is_admin || !$this->session->is_admin_loggedin) {
redirect('admin');
}
$crud = new grocery_CRUD();
$crud->set_theme('datatables')->set_table('post')->set_subject('Post')->columns('title', 'post', 'date_posted');
// the columns from the table to be displayed in particular
/* display_as('field_name', 'Label') function is use if you want to customize your field names on the table */
$crud->display_as('title', 'Post Title')->display_as('post', 'User\'s Post')->display_as('date_posted', 'Date');
/*
add_fields() function is very useful when you want to add a new record to a table
but only with the specific fields. Say, you don't need to set an `id` field
because id is already set to auto_increment. So, here in Grocery CRUD, when you want to
add a new record, you can customize what particular fields you want to be displayed.
edit_fields() function is use when you want to edit a record from a table
but you only want specific fields to be updated because there are fields
that is not neccessary to be updated. In this case, we only want the fields:
'id','user_id', 'title', 'post', 'slug' to be editable from a table and date_posted is not neccessary.
required_fields() function simply a rule when you add or update a record from a table
which fields must not be null or in other words, in the add/edit form which fields are required.
*/
$crud->add_fields('user_id', 'title', 'post', 'slug');
$crud->edit_fields('id', 'user_id', 'title', 'post', 'slug');
$crud->required_fields('id', 'user_id', 'title', 'post', 'slug');
$output = $crud->render();
$this->load->view('admin/admin_header_view', $output);
$this->load->view('admin/admin_nav_view');
$this->load->view('admin/admin_panel_view', $output);
$this->load->view('admin/admin_footer_view');
}
public function 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 especifico()
{
if (!$this->tank_auth->is_logged_in()) {
redirect('/auth/login/');
} else {
$crud = new grocery_CRUD();
//$crud->set_theme('datatables'); // Al comentar esta linea, le pones otro estilo a la tabla.
$crud->set_table('esp_especifico');
$crud->set_subject('Especificos');
$columnas = array('esp_nombre', 'esp_concepto', 'esp_presupuesto_votado', 'esp_modificaciones', 'esp_devengado', 'esp_congelado', 'esp_saldo', 'esp_estado');
$requeridos = array('esp_nombre', 'esp_concepto', 'esp_concepto', 'esp_presupuesto_votado', 'esp_saldo');
$alias = array('esp_nombre' => 'Nombre', 'esp_concepto' => 'Concepto', 'esp_presupuesto_votado' => 'Presupuesto Votado', 'esp_modificaciones' => 'Modificaciones', 'esp_devengado' => 'Devengado', 'esp_presupuesto_mod' => 'Presupuesto Modificado', 'esp_porcentaje_ejecucion' => 'Porcentaje de ejecución', 'esp_observaciones' => 'Observaciones', 'esp_congelado' => 'Congelado', 'esp_saldo' => 'Saldo', 'esp_estado' => 'Estado');
$crud->required_fields($requeridos);
$crud->columns($columnas);
$crud->display_as($alias);
$crud->field_type('esp_usu_mod', 'hidden', $this->tank_auth->get_user_id());
$crud->field_type('esp_fecha_mod', 'hidden', date('Y-m-d H:i:s'));
$crud->field_type('esp_estado', 'dropdown', array('1' => 'Activo', '0' => 'Inactivo'));
// Datos generales de la pagina
$data['menu_sistema'] = true;
$data['vista_name'] = 'inventario/index';
$data['titulo'] = "Subcatalogos";
$data['logo'] = $this->Regional_model->get_parametro("logo");
$info['info_padre'] = $this->sistema_model->get_registro('sio_sistema_opcion', array('sio_id' => 1));
$info['menu_principal'] = $this->sistema_model->get_menu('sic_sistema_catalogo', 1);
$data['menus'] = $this->load->view('menu/opciones_menu', $info, true);
// Estas tres lineas son principales cuando se desea imprimir un Grocery Crud en el sistema
$crud->unset_jquery();
// No llama al jQuery del Grocery Crud
$output = $crud->render();
//$this->load->view('sistema/pais',$output);
$data['texto'] = $this->load->view('inventario/especificos/especifico', $output, true);
$this->__cargarVista($data);
}
}
function clientes()
{
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('clientes');
/* Le asignamos un nombre */
$crud->set_subject('Clientes');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('id', 'nombre', 'domicilio', 'telefono');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('nombre', 'domicilio', 'telefono');
$crud->unset_export();
/* 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');
}
}
function admin_usuario()
{
$this->load->view('headers/header');
$this->load->view('headers/Navegacion');
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('usuarios');
/* Le asignamos un nombre */
$crud->set_subject('Usuarios');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('login', 'rut', 'nombre', 'apellido_paterno', 'apellido_materno', 'telefono_usuario', 'celular_usuario', 'direccion', 'email', 'fecha_creacion', 'fecha_modificacion', 'privilegios', 'sucursal_id');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('login', 'rut', 'nombre', 'apellido_paterno', 'apellido_materno', 'telefono_usuario', 'celular_usuario', 'direccion', 'email');
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en
/applications/views/productos/administracion.php */
$this->load->view('usuarios/admin_usuario', $output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function consultar()
{
if ($this->session->userdata('is_logged_in')) {
$crud = new grocery_CRUD();
$crud->set_table('dolar_hoy');
//->
$crud->set_theme('datatables');
$crud->set_language('spanish');
$crud->set_subject('Dolar Hoy');
// Display As
##
//-> Columnas
$crud->columns('cambio', 'fecha', 'registrado_por', 'registrado_fecha', 'registrado_hora');
// Relaciones
##
// Validacion
$crud->field_type('cambio', 'integer');
$crud->required_fields('cambio', 'id_clasificacion', 'precio');
//-> Renderizar
$output = $crud->render();
$data['titulo'] = "DOLAR HOY";
$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 administration()
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('news');
$crud->set_subject('Noticias');
$crud->set_language('spanish');
$crud->unset_export();
$crud->columns('title', 'author', 'summary', 'date_time', 'active');
$crud->required_fields('title', 'author', 'fk_source', 'date_time', 'priority', 'category', 'tags');
// $crud->add_fields('title', 'author', 'image', 'footer_text', 'date_time', 'url', 'summary', 'text', 'fk_source', 'priority', 'active', 'category', 'tags', 'img');
$crud->set_relation('fk_source', 'sources', 'name');
$crud->set_relation_n_n('category', 'news_categories', 'categories', 'fk_news', 'fk_category', 'category');
$crud->set_relation_n_n('tags', 'news_tags', 'tags', 'fk_news', 'fk_tag', 'tag');
$crud->set_field_upload('image', 'assets/uploads/news/');
$crud->display_as('title', 'Título')->display_as('summary', 'Sumario')->display_as('text', 'Texto')->display_as('author', 'Autor')->display_as('date_time', 'Fecha')->display_as('active', 'Estado')->display_as('comment_url', 'URL')->display_as('comment_count', 'Comentarios')->display_as('category', 'Categoría')->display_as('tags', 'Palabras Claves')->display_as('image', 'Imagen principal')->display_as('priority', 'Prioridad')->display_as('fk_source', 'Fuente')->display_as('img', 'Imágenes Adicionales')->display_as('footer_text', 'Texto de imagen');
$crud->set_relation_n_n('img', 'news_image', 'images', 'fk_news', 'fk_image', 'image');
// $crud->set_field_upload('img', 'assets/uploads/news/');
// $crud->set_field_upload('img', 'uploads/news/');
// $crud->callback_add_field('img', array($this, 'add_field_image_callback'));
// $crud->callback_edit_field('img', array($this, 'edit_field_image_callback'));
/* Generamos la tabla */
// $crud->callback_after_insert(array($this, 'after_insert'));
// $crud->callback_before_delete(array($this, 'before_delete_log'));
// $crud->callback_after_update(array($this, 'after_update_log'));
//
$output = $crud->render();
$this->load->view('includes/template', $output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function administracion()
{
try {
/* Creamos el objeto */
$crud = new grocery_CRUD();
/* Seleccionamos el tema */
$crud->set_theme('bootstrap');
/* Seleccionmos el nombre de la tabla de nuestra base de datos*/
$crud->set_table('productos');
/* Le asignamos un nombre */
$crud->set_subject('Productos');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('id', 'nombre', 'descripcion', 'precio_venta', 'existencia');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('id', 'proveedor', 'nombre', 'descripcion', 'precio_compra', 'precio_venta', 'existencia');
/*Le cambiamos en nombre al la columna id */
$crud->display_as('id', 'Referencia');
//$crud->unset_jquery();
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en
/applications/views/productos/administracion.php */
$this->load->view('header');
$this->load->view('productos/administracion', $output);
$this->load->view('footer');
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function index()
{
try {
// General
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->set_table('sos_gen_frequence');
$crud->set_subject('Fréquence');
//relations
//Master/child relations
//Visual
$crud->columns('name_frequence');
$crud->display_as('name_frequence', 'Fréquence');
$crud->order_by('name_frequence', 'desc');
//unsets
//Requireds
$crud->required_fields('name_frequence');
//Callbacks
//field Types
// Actions
// Renders
$output = $crud->render();
$menu = new stdClass();
$menu->n1 = true;
$menu->lien3_3_1 = 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 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()
{
$this->pagina_saida((object) array('output' => '', 'js_files' => array(), 'css_files' => array()));
$this->load->view('template/navbar.php');
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('cliente_produto');
$crud->set_subject('codorc');
$crud->required_fields('codorc', 'codpro');
$crud->display_as('codorc', 'Cód. Orçamento');
$crud->display_as('tiporc', 'Tipo');
$crud->display_as('numcpf', 'CPF');
$crud->display_as('plavei', 'Placa');
$crud->display_as('datent', 'Data Início');
$crud->display_as('datsai', 'Data Saída');
// $crud->columns('NomeCliente');
$crud->add_action('Smileys', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', 'demo/action_smiley');
$output = $crud->render();
$this->pagina_saida($output);
$this->load->view('template/footer');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function index()
{
$this->pagina_saida((object) array('output' => '', 'js_files' => array(), 'css_files' => array()));
$this->load->view('template/navbar.php');
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('cliente');
$crud->set_subject('nomcli');
$crud->required_fields('numcpf', 'nomcli', 'numtel');
$crud->display_as('nomcli', 'Nome do Cliente');
$crud->display_as('numcpf', 'CPF');
$crud->display_as('nombai', 'Bairro');
$crud->display_as('nomcid', 'Cidade');
$crud->display_as('endcli', 'Endereço');
$crud->display_as('numtel', 'Telefone');
$crud->display_as('sigest', 'Estado');
// $crud->columns('NomeCliente');
$output = $crud->render();
$this->pagina_saida($output);
$this->load->view('template/footer');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function index()
{
//Inisialisasi
$crud = new grocery_CRUD();
$crud->set_subject('Pasien');
$crud->set_table('tbl_pasien');
//Label Fields
$crud->display_as('idPasien', 'ID Pasien');
$crud->display_as('namaPasien', 'Nama');
$crud->display_as('umur', 'Umur');
$crud->display_as('tanggalLahir', 'Tanggal Lahir');
$crud->display_as('jenisKelamin', 'Jenis Kelamin');
$crud->display_as('status', 'Status');
$crud->display_as('alamat', 'Alamat');
$crud->display_as('pekerjaan', 'Pekerjaan');
$crud->display_as('no_telp', 'Nomor Telepon');
//Kolom Input dan Callbacks
$crud->fields('idPasien', 'namaPasien', 'umur', 'tanggalLahir', 'jenisKelamin', 'status', 'alamat', 'pekerjaan', 'no_telp');
$crud->field_type('idPasien', 'invisible');
$crud->callback_field('jenisKelamin', array($this, 'jenisKelamin_callback'));
$crud->field_type('status', 'dropdown', array('Menikah' => 'Menikah', 'Belum Menikah' => 'Belum Menikah'));
$crud->field_type('pekerjaan', 'dropdown', array('Pegawai Negeri' => 'Pegawai Negeri', 'Wiraswasta' => 'Wiraswasta', 'Karyawan Swasta' => 'Karyawan Swasta', 'Mahasiswa' => 'Mahasiswa', 'Ibu Rumah Tangga' => 'Ibu Rumah Tangga', 'Pensiunan' => 'Pensiunan', 'Lainnya' => 'Lainnya'));
//Aturan Pengisian Form
$crud->required_fields('namaPasien', 'umur', 'tanggalLahir', 'jenisKelamin', 'status', 'alamat', 'pekerjaan');
$crud->set_rules('umur', 'Umur', array('required', 'max_length[2]', 'numeric'));
$crud->set_rules('no_telp', 'Nomor Telepon', 'numeric');
$crud->set_language("indonesian");
//Cetak Tabel
$output = $crud->render();
$this->_example_output($output);
}
public function index($categoryid = 0)
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$data['cat_id'] = $categoryid;
// $form_subject = ($categoryid==0 ? "Category" : "Sub Category");
if ($categoryid == 0) {
$form_subject = "Category";
$data['cat_title'] = "Categories";
} else {
$this->category->getTitle($categoryid);
$data['cat_title'] = $this->category->getTitle($categoryid) . " - Sub Categories";
$form_subject = "Sub Category";
}
$crud = new grocery_CRUD();
$crud->set_table('dbx_categories');
$crud->where('pid', $categoryid);
$crud->set_subject($form_subject);
$crud->required_fields('title');
$crud->columns('title');
$crud->callback_column('title', array($this, 'link_title'));
$crud->set_rules('title', 'Title', 'trim|required|xss_clean|is_unique[dbx_categories.title]');
$crud->add_action('Sub Categories', '', '', 'cat-icon', array($this, 'goto_sub'));
$crud->fields('title', 'desc', 'published', 'type', 'pid', 'ownerid', 'created_date');
$crud->field_type('pid', 'hidden', $categoryid);
$crud->field_type('published', 'dropdown', array('0' => 'No', '1' => 'Yes'));
$crud->field_type('type', 'dropdown', array('C' => 'Celebrity', 'M' => 'Movie', 'P' => 'Parent'));
$crud->change_field_type('ownerid', 'invisible');
$crud->change_field_type('created_date', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert'));
$output = $crud->render($data);
$this->load->view('header_view', $data);
$this->load->view('categories_view', $output);
$this->load->view('footer_view', $data);
}
function administracion()
{
if (!$this->tank_auth->is_logged_in()) {
redirect('/auth/login/');
}
try {
/* Creamos el objeto */
$crud = new grocery_CRUD();
/* Seleccionamos el tema */
$crud->set_theme('flexigrid');
/* Seleccionmos el nombre de la tabla de nuestra base de datos*/
$crud->set_table('method');
/* Le asignamos un nombre */
$crud->set_subject('Metodo');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('MethodID', 'Description');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('MethodID', 'Description');
$crud->display_as('MethodID', 'ID');
$crud->display_as('Description', 'Descripción');
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en */
$this->load->view('Method/administracion', $output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function administracion()
{
$this->load->view('headers/header');
$this->load->view('headers/Navegacion');
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('productos');
/* Le asignamos un nombre */
$crud->set_subject('Productos');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('nombre_producto', 'marca', 'descripcion', 'fecha_ingreso', 'precio', 'cantidad', 'valor_total');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('nombre_producto', 'marca', 'descripcion', 'fecha_ingreso', 'precio', 'cantidad', 'valor_total');
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en
/applications/views/productos/administracion.php */
$this->load->view('productos/administracion', $output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function index($stat = '')
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
switch ($stat) {
case '':
default:
$crud->set_table('nus_staff');
$crud->set_relation('nst_id', 'nus_staff_type', 'nst_desc');
$crud->set_relation('nw_id', 'nus_ward', 'nw_name');
$crud->display_as('ns_fullname', 'Full Name')->display_as('ns_username', 'Username')->display_as('ns_password', 'Password')->display_as('nst_id', 'User Type')->display_as('nw_id', 'Ward Name');
$crud->required_fields('ns_fullname', 'ns_username', 'ns_password', 'nst_id');
break;
case 'manageWadStatus':
$crud->set_table('nus_bed_status');
$crud->display_as('nbs_desc', 'Description')->display_as('nbs_code', 'Code')->display_as('nc_id', 'Color');
$crud->required_fields('nbs_code', 'nbs_desc', 'nc_id');
$crud->set_relation('nc_id', 'nus_color', 'nc_desc');
break;
case 'manageWard':
$crud->set_table('nus_ward');
$crud->display_as('nw_name', 'Ward Name');
$crud->required_fields('nw_name');
break;
case 'manageBed':
$crud->set_table('nus_bed');
$crud->set_relation('nw_id', 'nus_ward', 'nw_name');
$crud->display_as('nb_bed_no', 'Bed No.')->display_as('nw_id', 'Ward Name')->display_as('np_pmi_id', 'Patient Name')->display_as('nbs_id', 'Bed Status')->display_as('nb_datetime', 'Registered Date/Time')->display_as('ns_id', 'Nurse Incharge');
$crud->required_fields('nb_bed_no', 'nw_id');
$crud->set_relation('np_pmi_id', 'nus_patient', 'np_fullname');
$crud->set_relation('nbs_id', 'nus_bed_status', 'nbs_desc');
$crud->set_relation('ns_id', 'nus_staff', 'ns_fullname');
break;
case 'manageGender':
$crud->set_table('nus_patient_gender');
$crud->display_as('npg_desc', 'Description')->display_as('npg_code', 'Code')->display_as('nc_id', 'Color');
$crud->set_relation('nc_id', 'nus_color', 'nc_desc');
break;
}
$output = $crud->render();
$this->viewpage('v_mainpage', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('hotels');
$crud->set_subject('Hotels');
$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);
//var_dump($agents);
// $crud->set_relation('hotel_agent_id', 'io_users', '{first_name} {last_name}', array('active' => 1));
$crud->display_as('hotel_agent_id', 'Agent Name');
$crud->display_as('hotel_name', 'Hotel Name');
$crud->display_as('hotel_rooms', 'Rooms');
$crud->display_as('hotel_tariffs', 'Tariffs');
$crud->display_as('hotel_country', 'Country');
$crud->display_as('hotel_city', 'City');
$crud->display_as('hotel_street', 'Street');
$crud->display_as('hotel_state', 'State');
$crud->display_as('hotel_postCode', 'PostCode');
$crud->display_as('hotel_phoneNumber', 'Phone Number');
$crud->display_as('hotel_emailId', 'Email ID');
$crud->display_as('hotel_website', 'Website');
$crud->display_as('hotel_facebook', 'Facebook');
$crud->display_as('hotel_googleMap', 'Google Map');
$crud->display_as('hotel_related', 'Related Hotels');
$crud->display_as('hotel_status', 'Status');
$crud->columns('hotel_name', 'hotel_agent_id', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook', 'hotel_googleMap', 'hotel_status');
$crud->required_fields('hotel_agent_id');
$crud->field_type('hotel_stars', 'dropdown', range(0, 5));
/*
* For related hotels
* on add list all the hotels
* on edit, list all except own name
*/
$hrf = array();
if ($crud->getState() == 'edit') {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_id !=' => $crud->getStateInfo()->primary_key), 'hotel_id');
} else {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1), 'hotel_id');
}
$hrf = $this->generic_model->array_from_db($hrf, 'hotel_id, hotel_name');
$crud->field_type('hotel_related', 'multiselect', $hrf);
$crud->callback_column('hotel_image', array($this, 'set_image'));
$crud->set_field_upload('hotel_image', $this->upload_path);
$hf = $this->generic_model->get_by('hotel_facilities', array('hf_status' => 1), 'hf_id');
$hf = $this->generic_model->array_from_db($hf, 'hf_id, hf_facility');
$crud->field_type('hotel_facilities', 'multiselect', $hf);
$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('hotel_room_facilities', 'multiselect', $hrf);
$crud->unique_fields('hotel_slug');
$crud->add_action('Photo Gallery', '', 'hotels/gallery', 'ui-icon ui-icon-image');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotels', 'pagedesc' => 'Hotels', 'contenttitle' => 'Hotels List Records');
$this->load->view('gc_admin_wrapper', $data);
}
public function index($stat = '')
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
switch ($stat) {
case '':
default:
$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 productos()
{
$crud = new grocery_CRUD();
$crud->set_table('productos');
$crud->set_relation('cat_id', 'categorias', 'nombre');
$crud->required_fields('precio', 'item_name', 'cat_id');
$output = $crud->render();
$this->load->view('main/productos', $output);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('bootstrap');
$crud->set_table('user');
$crud->set_subject('Gebruiker');
// hide fields
$crud->columns('is_super_user', 'is_active', 'screen_name', 'email', 'gebruikersgroepen');
// new_password and new_password repeat are needed to make formvalidation work
// id is needed to make the email unique check work
$crud->fields('id', 'is_active', 'screen_name', 'email', 'gebruikersgroepen', 'password', 'new_password', 'new_password_repeat');
$crud->required_fields('email', 'screen_name', 'is_active');
$crud->set_relation_n_n('gebruikersgroepen', 'user_x_user_group', 'user_group', 'user_id', 'user_group_id', 'name');
$crud->field_type('id', 'hidden');
$crud->field_type('new_password_repeat', 'hidden');
$crud->field_type('password', 'hidden');
$crud->display_as('is_active', 'Actief');
$crud->display_as('screen_name', 'Schermnaam');
$crud->display_as('is_super_user', '');
$crud->display_as('new_password', 'Wachtwoord');
if ($crud->getState() == 'read') {
$crud->field_type('new_password', 'hidden');
} else {
$crud->callback_field('new_password', array($this, 'edit_field_callback_new_password'));
}
$crud->field_type('is_active', 'dropdown', array('yes' => 'ja', 'no' => 'nee'));
$crud->callback_column('is_active', array($this, 'callback_list_is_active'));
$crud->callback_column('is_super_user', array($this, 'callback_list_is_super_user'));
$crud->callback_before_insert(array($this, 'before_insert_update_callback'));
$crud->callback_before_update(array($this, 'before_insert_update_callback'));
$crud->callback_after_insert(array($this, 'after_insert_callback'));
$crud->callback_after_update(array($this, 'after_update_callback'));
if ($crud->getState() === 'update_validation' or $crud->getState() === 'insert_validation') {
$crud->set_rules('email', 'E-mail', 'required|valid_email|callback_email_unique_check');
$crud->set_rules('screen_name', 'Schermnaam', 'required');
if ($this->input->post('new_password') != '' or !$this->input->post('id')) {
$crud->set_rules('new_password', 'Nieuw wachtwoord', 'required|min_length[10]|matches[new_password_repeat]');
$crud->set_rules('new_password_repeat', 'Herhaal nieuw wachtwoord', '');
}
$this->form_validation->set_message('matches', 'De wachtwoorden zijn niet aan elkaar gelijk.');
}
// render the crud HTML
$crud_output = $crud->render();
//get the needed css and javascript files
$this->javascript_files = $crud->get_js_files();
$this->css_files = $crud->get_css_files();
// put the crud content in the right position
$this->views['content'] = $crud_output->output;
$this->css[] = $this->load->view('admin/user/css/index.css', array(), true);
// add javascript and css to make the password generate and change function possible
if ($crud->getState() === 'add' or $crud->getState() === 'edit') {
$this->css[] = $this->load->view('admin/user/css/edit_user.css', array(), true);
$this->javascript[] = $this->load->view('admin/user/js/edit_user.js', array(), true);
}
// create the layout-HTML and show it to the user
$this->_layout();
}
public function data_user()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('tbl_user');
$crud->set_subject('User');
$crud->required_fields('username', 'password');
$output = $crud->render();
$this->_example_output($output);
}
public function slider()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('slider');
$crud->set_subject('Image');
$crud->required_fields('title', 'image');
$crud->set_field_upload('image', 'assets/uploads');
$output = $crud->render();
$this->_admin_output($output);
}
public function publication()
{
$this->data['page_title'] = 'Publication';
$crud = new grocery_CRUD();
$crud->set_table('publication');
$crud->set_subject('Publications ');
$crud->required_fields('PublicationTitle', 'PublicationDate' . 'PublicationLink');
$crud->field_type('LastUpdate', 'hidden');
$this->data['output'] = $crud->render();
$this->render('admin/crud_view');
}
function designation_management()
{
$crud = new grocery_CRUD();
$crud->set_table('designation_master');
$crud->set_subject('Designation');
$crud->columns('designation', 'status');
$crud->fields('designation', 'status');
$crud->required_fields('designation');
$output = $crud->render(array('name' => 'Designation Management'));
$this->_example_output($output);
}
public function index()
{
$arr['page'] = 'admmarcas';
$crud = new grocery_CRUD();
$crud->set_table('marcas');
$crud->required_fields('marca', 'mostrar', 'imagen', 'link');
$crud->set_field_upload('imagen', 'assets/uploads/images');
$output = $crud->render();
$arr['output'] = $output;
$this->load->view('admin/vwManageCMS', $arr);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('banner')->set_subject('Banners')->columns('imagen');
$crud->required_fields('imagen');
$crud->set_field_upload('imagen', 'assets/uploads/files');
$crud->unset_fields('fecha');
$crud->unset_print();
$output = $crud->render();
$this->_example_output($output);
}
