public function index()
{
//$data['main_content'] = 'login_form';
//$this->load->view('includes/template',$data);
//$this->load->view('admin/configuration');
//$this->load->view('admin/homepage');
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('ips_ordertracking');
$crud->set_subject('Sales Tracking');
$crud->required_fields('NAME');
$crud->columns('ordertrackingid', 'orderid', 'name', 'orderdate');
// $crud->columns('fullfillment','orderdate','orderid','returnid','itemrece','caseid','product','status');
//$crud->fields('ordertrackingid','orderid','name','orderdate');
$crud->callback_column('ordertrackingid', array($this, '_callback_webpage_url'));
$crud->callback_column('orderdate', array($this, '_callback_dateformat'));
// $crud->fields('NAME');
// $crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
// $crud->callback_after_insert(array($this, 'fullfillmentid_generation'));
$output = $crud->render();
$state = $crud->getState();
if ($state == 'add') {
redirect('store/addtracking');
}
// $this->grocery_crud->set_table('ips_login');
// $output = $this->grocery_crud->render();
$this->_example_output($output);
}
public function index()
{
// $data = array(
// 'main_content' => 'clients_wishlist',
// 'output' => $this->db->get_where('clients_wishlist', array('wish_user' => $this->ion_auth->get_user_id()))->result(),
// 'pagetitle' => 'Wishlist',
// 'pagedesc' => 'Wishlist',
// 'contenttitle' => 'Wishlist Records',
// 'left_menu' => 'clients_menu'
// );
// $this->load->view('gc_client_wrapper', $data);
$this->load->library('grocery_CRUD');
// $this->upload_path = '../assets/uploads/' . 'packages';
// $this->wrapper = 'gc_admin_wrapper';
$this->load->model('generic_model');
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('clients_wishlist');
$crud->set_subject('Client Wishlist');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->where('wish_user', $this->ion_auth->get_user_id());
$crud->display_as('wish_title', 'Wish Title');
$crud->display_as('wish_date', 'Wish Date');
$crud->callback_column('wish_title', array($this, 'set_change_status'));
$crud->unset_columns('wish_url', 'wish_user');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Client Wishlist', 'pagedesc' => 'Client Wishlist', 'contenttitle' => 'Wishlist Records', 'left_menu' => 'clients_menu');
$this->load->view('gc_admin_wrapper', $data);
}
public function index()
{
$bol_del_before_date = $this->m_conndb->dateBeforeDelete();
try {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('tempahan');
$crud->set_subject('Booking Room');
$crud->set_relation('m_id', 'masa', 'm_desc');
$crud->set_relation('bm_id', 'bilik_meeting', 'bm_desc');
$crud->display_as('t_datereg', 'Date Reg.')->display_as('t_date', 'Book Date')->display_as('t_day', 'Book Day')->display_as('m_id', 'Time')->display_as('t_perkara', 'Club / Item')->display_as('bm_id', 'Meeting Room')->display_as('t_status', 'Status');
$crud->columns('t_date', 't_day', 'm_id', 't_perkara', 'bm_id');
$crud->fields('t_date', 'm_id', 't_perkara', 'bm_id', 't_datereg', 't_day');
$crud->field_type('t_datereg', 'hidden');
$crud->field_type('t_day', 'hidden');
$crud->required_fields('t_date', 'm_id', 't_perkara', 'bm_id');
$umaq = $this->uri->segment(3);
if (!($this->uri->segment(3) && $umaq == 'umaqkacak')) {
$crud->unset_delete();
$crud->unset_edit();
}
$crud->callback_before_insert(array($this, 'setAutoTempahan'));
$output = $crud->render();
$this->viewpage('v_bookroom', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function stages_management()
{
$crud = new grocery_CRUD();
$crud->set_table('procesos');
$crud->set_subject('Proceso');
$crud->unset_delete();
$crud->unset_edit();
$output = $crud->render();
$this->_output_crud($output, 'Procesos');
}
public function listarNeumonias()
{
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$est = $this->frontend_model->listaEstablec();
$estab = array();
foreach ($est as $dato) {
$estab[$dato->cod_est] = $dato->raz_soc;
}
$crud = new grocery_CRUD();
$crud->set_table('neumonias');
$crud->columns('diresa', 'e_salud', 'apepat', 'apemat', 'nombres', 'sexo', 'fecha_reg', 'fecha_def', 'usuario');
$crud->set_subject('Ficha');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('e_salud' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
$where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
$crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino'));
$crud->field_type('diresa', 'dropdown', $subr);
$crud->field_type('e_salud', 'dropdown', $estab);
$crud->display_as("apepat", "Apellido Paterno");
$crud->display_as("apemat", "Apellido Materno");
$crud->display_as("fecha_reg", "Registro");
$crud->display_as("fecha_def", "Defunción");
$crud->display_as("e_salud", "Establecimiento");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_export();
//$crud->unset_print();
$crud->callback_after_delete(array($this, 'log_usuario_before_delete'));
$crud->add_action_peru('', '', 'RegfichaNeum', 'add-icon');
$crud->add_action('Modificar Ficha', '', 'modulos3/ModfichaNeum', 'edit-icon');
$crud->add_action('Ver Ficha', '', 'modulos3/VerfichaNeum', 'read-icon');
$output = $crud->render();
$this->_example_output($output);
}
public function autogenerated_tree()
{
$this->data['page_title'] = 'Autogenerated Tree';
$crud = new grocery_CRUD();
$crud->set_table('autogeneratetree');
$crud->set_subject('attributes');
$crud->set_relation('parent_id', 'autogeneratetree', 'nodename');
$crud->unset_edit()->unset_delete()->unset_read();
$this->data['output'] = $crud->render();
$this->render('admin/crud_view');
}
function ventas()
{
$crud = new grocery_CRUD();
$crud->set_table('ventas');
$crud->set_relation('producto', 'productos', 'item_name');
$crud->set_relation('unitario', 'productos', 'precio');
$crud->display_as('valor', 'Total');
$crud->unset_add();
$crud->unset_delete();
$crud->unset_edit();
$output = $crud->render();
$this->load->view('main/ventas', $output);
}
public function listar_transito()
{
/*$establecimiento = $this->mantenimiento_transito->listarEstablecimiento();
foreach($establecimiento as $dato){
$est[$dato->cod_est] = $dato->raz_soc;
} */
$crud = new grocery_CRUD();
//$crud->set_theme('bootstrap');
$crud->set_table('trans_lesacctra');
$crud->columns('id', 'ano', 'ap_nm1', 'ap_nm2', 'nom_les', 'edad', 'tipo_edad', 'diresa', 'eess');
$crud->set_subject('Ficha Transito');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('cod_eess' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
//$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red' and microred = '$microred')";
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
//$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red')";
$where = array('red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
//$crud->field_type('establec', 'dropdown', $est);
$crud->display_as("id", "ID")->display_as("ano", "AÑO")->display_as("ap_nm1", "APELLIDO PATERNO")->display_as("ap_nm2", "APELLIDO MATERNO")->display_as("nom_les", "NOMBRES")->display_as("edad", "EDAD")->display_as("tipo_edad", "TIPO")->display_as("diresa", "DIRESA")->display_as("eess", "ESTABLECIENTO DE SALUD");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_print();
$crud->unset_export();
$crud->unset_delete();
$crud->order_by('id', 'desc');
$crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulotransito/borrarFichatransito', 'borrar-icon');
$crud->add_action('Vista previa', '', 'modulotransito/ver_ficha_transito', 'read-icon');
$crud->add_action('Editar Ficha Transito', '', 'modulotransito/modificacion_transito', 'edit-icon');
$output = $crud->render();
$usuario = $this->session->userdata("usuario");
$accion = 'Listar Casos Accidentes de Transito';
$this->login_model->auditoriaOperador($usuario, $accion);
$this->layout->view('listar_transito', $output);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('ratings');
$crud->set_subject('Ratings');
$crud->display_as('rating_id', 'Package / Hotel Name');
$crud->callback_column('rating_id', array($this, 'set_package_or_hotel'));
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Ratings', 'pagedesc' => 'Ratings');
$this->load->view('gc_admin_wrapper', $data);
}
public function history()
{
$crud = new grocery_CRUD();
$crud->set_table('pengiriman');
// $crud->columns('nama','username','email');
$crud->set_relation('id_member', 'members', 'username');
$crud->display_as('id_member', 'Username');
$crud->unset_export();
$crud->unset_print();
$crud->unset_add();
$crud->unset_delete();
$crud->unset_edit();
$output = $crud->render();
$output->title = 'History Pengiriman';
$this->template->load('template/template_main', 'admin/history_pengiriman', $output);
}
public function suratperunit()
{
$crud = new grocery_CRUD();
$crud->set_table('distribusi');
$crud->where('id_unit', $this->uri->segment(3));
$crud->set_primary_key('id_unit', 'distribusi');
$crud->set_relation('id_unit', 'unit', 'namaGroup');
$crud->set_relation('id_surat', 'surat', 'nomorSurat');
$crud->columns('id_surat');
$crud->display_as('id_surat', 'nomor surat');
$crud->unset_add();
$crud->unset_edit();
//$crud->columns('nomorSurat','perihal','tanggal');
$output = $crud->render();
$this->_outputs($output);
}
public function createtable($db)
{
$this->db = $this->load->database($db, true);
$crud = new grocery_CRUD();
$crud->set_table('alert_logger');
$crud->set_primary_key('id');
$crud->columns('alert', 'all_alg_data', 'all_alg_file_data', 'toa', 'alert_name', 'status', 'del');
$crud->display_as('alert', 'Alert')->display_as('all_alg_file_data', 'ALG File.')->display_as('all_alg_data', 'ALG Ref.')->display_as('toa', 'Date')->display_as('alert_name', 'Name')->display_as('del', 'Deletion date');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->callback_column('status', array($this, '_column_status'));
$output = $crud->render();
$this->db->close();
$this->_example_output($output);
}
public function questions()
{
$this->data['page_title'] = 'Questions';
$crud = new grocery_CRUD();
$crud->set_table('questions');
$crud->set_subject('Questions');
$crud->fields('question_name', 'metadescription', 'created_at', 'updated_at', 'scale_id', 'group', 'questionnaire_id');
$crud->set_relation('scale_id', 'scales', 'name');
$crud->set_relation('questionnaire_id', 'questionnaireone', 'questionnaire_name');
//for foreign key
$crud->unset_edit()->unset_delete()->unset_read();
$crud->field_type('created_at', 'hidden');
$crud->field_type('updated_at', 'hidden');
$crud->unset_texteditor('question_name', 'full_text');
$crud->unset_texteditor('metadescription', 'full_text');
$this->data['output'] = $crud->render();
$this->render('admin/crud_view');
}
function receipts()
{
session_start();
if (!is_null($_SESSION['fromLogin']) && in_array($_SESSION['email'], array('*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**'))) {
} else {
header("Location: http://www.faizstudents.com/users/login.php");
}
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('receipts');
if ($_SESSION['email'] == '*****@*****.**') {
$crud->unset_edit();
$crud->unset_delete();
}
$crud->columns('Receipt_No', 'Thali_No', 'Amount', 'Date');
$output = $crud->render();
$this->_example_output($output);
}
function users($page)
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('users');
$crud->set_relation('ut_id', 'user_type', 'ut_desc');
$crud->set_relation('u_status', 'stats', 's_desc');
$crud->display_as('u_fullname', 'Full Name')->display_as('u_username', 'Username')->display_as('u_password', 'Password')->display_as('ut_id', 'User Type')->display_as('u_status', 'Status');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$output = $crud->render();
$this->_example_output($page, $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function listarMnp()
{
$crud = new grocery_CRUD();
$crud->set_table('mnp');
$crud->columns('registroId', 'ape_nom', 'sexo', 'fecha_nac', 'fecha_mte', 'fecha_reg', 'usuario');
$crud->set_subject('Ficha');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('e_salud' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
$where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
$crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino', 'I' => 'Indeterminado'));
$crud->display_as("registroId", "Ficha");
$crud->display_as("ape_nom", "Apellidos y Nombres");
$crud->display_as("fecha_nac", "Fecha de Nacimiento");
$crud->display_as("fecha_mte", "Defunción");
$crud->display_as("fecha_reg", "Fecha de Registro");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_export();
$crud->unset_delete();
//$crud->unset_print();
$crud->add_action_peru('', '', 'RegfichaMnp', 'add-icon');
$crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulosmnp/delFichaMnp', 'borrar-icon');
$crud->add_action('Modificar Ficha', '', 'modulosmnp/ModfichaMnp', 'edit-icon');
$crud->add_action('Ver Ficha', '', 'modulosmnp/VerfichaMnp', 'read-icon');
$output = $crud->render();
$this->_example_output($output);
}
function salidas()
{
if ($this->session->userdata('id')) {
try {
/* Creamos el objeto */
$crud = new grocery_CRUD();
/* Seleccionamos el tema */
$crud->set_theme('flexigrid');
/* Seleccionmos el nombre de la tabla de nuestra base de datos*/
$crud->set_table('salida');
/* Le asignamos un nombre */
$crud->set_subject('Salidas de productos');
$crud->set_relation('producto', 'productos', 'nombre');
$crud->set_relation('cliente', 'clientes', 'nombre');
//$crud->display_as('proveedor','Proveedor');
//$crud->set_subject('productos');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('producto', 'cantidad', 'cliente', 'folio', 'comentarios', 'precio', 'total');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('id', 'producto', 'cantidad', 'cliente', 'folio', 'comentarios', 'precio', 'total');
$crud->callback_column('precio', array($this, 'valuePeso'));
$crud->callback_column('total', array($this, 'valuePeso'));
$crud->callback_before_insert(array($this, 'checking_post_cantidad'));
$crud->unset_delete();
$crud->unset_edit();
$crud->unset_export();
//$crud->add_action('Smileys', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', 'demo/action_smiley');
//$crud->callback_edit_field('cantidad',array($this,'edit_field_callback_1'));
//$crud->callback_add_field('cantidad',array($this,'edit_field_callback_2'));
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en
/applications/views/productos/administracion.php */
$this->_example_output($output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
} else {
redirect('Login');
}
}
public function index($log_type = NULL)
{
$this->load->model('shared/log_model');
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_character_limiter', 0);
$crud = new grocery_CRUD();
if ($crud->getState() == 'list') {
// get all known log types
$log_types = $this->log_model->get_log_types();
$this->views['content'] = $this->load->view('admin/log/action_selector', array('log_types' => $log_types, 'selected_log_type' => $log_type), TRUE);
$this->javascript[] = $this->load->view('admin/log/js/action_selector.js', NULL, TRUE);
}
if (!is_null($log_type) && $log_type != 'ajax_list' && $log_type != 'export' && $log_type != 'print' && $log_type != 'ajax_list_info') {
$crud->where(array('action' => $log_type));
$crud->unset_columns('action');
}
$crud->set_theme('bootstrap');
$crud->set_table('log');
$crud->set_subject('Logs');
// Op twee velden orderen. Grocerycrud houd zich niet aan de Codeigniter active record
// maar dit werkt.
$crud->order_by('date_created desc, id', 'desc');
$crud->columns('date_created', 'action', 'message', 'user_id');
$crud->set_relation('user_id', 'user', 'screen_name');
$crud->display_as('user_id', 'Gebruiker');
$crud->display_as('date_created', 'Tijd');
$crud->display_as('action', 'Actie');
$crud->display_as('message', 'Bericht');
$crud->display_as('ip_hash', 'IP-hash');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
// render the crud HTML
$crud_output = $crud->render();
//get the needed css and javascript files
$this->javascript_files = $crud->get_js_files();
$this->css_files = $crud->get_css_files();
if (isset($this->views['content'])) {
$this->views['content'] .= $crud_output->output;
} else {
$this->views['content'] = $crud_output->output;
}
$this->_layout();
}
public function tabelnya()
{
$crud = new grocery_CRUD();
$crud->set_table('pengaduan');
$crud->set_subject('Daftar Pengaduan');
$crud->columns('nama', 'pengaduan', 'tglpengaduan');
$crud->display_as('nama', 'Nama Pengadu');
$crud->display_as('pengaduan', 'Isi');
$crud->display_as('tglpengaduan', 'Tanggal Masuk');
$crud->unset_print();
$crud->unset_export();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_read();
$output = $crud->render();
$this->load->view('home.php');
$this->load->view('vinfotambahpengaduan.php', $output);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_model('My_Custom_model');
$crud->set_table('ips_ordertracking', 'ips_productitems');
$crud->set_subject('Sales Tracking');
$crud->required_fields('NAME');
// void set_relation_n_n( string $field_name, string $relation_table, string $selection_table, string $primary_key_alias_to_this_table, string $primary_key_alias_to_selection_table , string $title_field_selection_table [ , string $priority_field_relation ] )
$crud->set_relation_n_n('orderdetails', 'ips_ordertracking', 'ips_productitems', 'ips_ordertracking', 'ordertrackingid', 'description', 'category');
// $crud->set_relation('ordertrackingid','ips_productitems','description');
// $crud->columns('ordertrackingid','fullfillment','orderdate','orderid','returnid','itemrece','caseid','product','status','Action');
// $crud->display_as('orderdate','Order Date')->display_as('orderid','Order ID')->display_as('returnid','Sales Return ID')->display_as('itemrece','Item Received')->display_as('caseid','Case ID')->display_as('product','Product Condition')->display_as('ordertrackingid','ID');
$crud->columns('ordertrackingid', 'orderid', 'description', 'category', 'product', 'itemrece', 'cost', 'mrp', 'Action');
$crud->display_as('orderid', 'Order ID')->display_as('itemrece', 'Item Received')->display_as('product', 'Product Condition')->display_as('ordertrackingid', 'ID')->display_as('description', 'Product Name')->display_as('category', 'Category')->display_as('cost', 'Recovery Min')->display_as('mrp', 'Recovery Max');
$crud->callback_column('ordertrackingid', array($this, '_callback_webpage_url'));
$crud->callback_column('orderdate', array($this, '_callback_dateformat'));
$crud->callback_column('fullfillment', array($this, '_callback_fullfillment'));
// $crud->callback_column('product',array($this,'_callback_product'));
$crud->callback_column('status', array($this, '_callback_status'));
$crud->callback_column('itemrece', array($this, '_callback_itemrece'));
$crud->callback_column('cost', array($this, '_callback_recovery_min'));
$crud->callback_column('mrp', array($this, '_callback_recovery_max'));
$crud->callback_column('Action', array($this, '_callback_viewpage_url'));
$crud->unset_edit();
$crud->unset_read();
$crud->unset_delete();
// $crud->callback_after_insert(array($this, 'fullfillmentid_generation'));
$output = $crud->render();
$state = $crud->getState();
if ($state == 'add') {
redirect('store/addtracking');
}
if ($state == 'view') {
redirect('store/viewtracking');
}
// $this->grocery_crud->set_table('ips_login');
// $output = $this->grocery_crud->render();
$this->_example_output($output);
}
public function tabelnya()
{
$crud = new grocery_CRUD();
$crud->set_table('ijin');
$crud->set_subject('Ijin');
$crud->columns('nama', 'waktu', 'retribusi');
$crud->display_as('nama', 'Jenis Perijinan');
$crud->display_as('waktu', 'Waktu (hari kerja)');
$crud->display_as('retribusi', 'Retribusi');
//$crud->unset_print();
//$crud->unset_export();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_read();
$output = $crud->render();
$js_files = $output->js_files;
$css_files = $output->css_files;
$data['output'] = $output;
$data['label'] = "Info Perijinan";
$this->load->view('home.php');
$this->load->view('vinformasi.php', array('js_files' => $js_files, 'css_files' => $css_files, 'output' => $data));
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('booking_refunds');
$crud->set_subject('Booking Refund');
$crud->unset_add();
$crud->unset_delete();
$crud->unset_edit();
$crud->unset_fields('booking_ref_no');
$crud->field_type('refund_status', 'dropdown', array('1' => 'Requested', '0' => 'Rejected', '2' => 'Refunded'));
$crud->field_type('item_type', 'readonly');
$crud->callback_column('item_type', function ($value, $primary_key) {
return ucfirst($value);
});
$crud->callback_edit_field('item_type', function ($value, $primary_key) {
return ucfirst($value);
});
// $crud->callback_before_update(array($this, 'modified_date_callback'));
$crud->callback_column('booking_ref_no', array($this, '_show_invoice'));
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Booking Refund', 'pagedesc' => 'Booking Refund', 'contenttitle' => 'Booking Refund List Records', 'left_menu' => 'agents_menu');
$this->load->view('gc_admin_wrapper', $data);
}
public function listarCasos()
{
$nivelUsuario = $this->session->userdata("nivel");
$enfermedad = array('diagnostic' => 'A92.0');
$enfermedad1 = array('diagnostic' => 'A92.5');
$tipo = array('C' => 'Confirmado', 'P' => 'Probable', 'D' => 'Descartado', 'S' => 'Sospechoso');
$est = $this->frontend_model->listaEstablec();
$estab = array();
foreach ($est as $dato) {
$estab[$dato->cod_est] = $dato->raz_soc;
}
$crud = new grocery_CRUD();
$crud->set_table('individual');
//$crud->set_theme('datatables');
$crud->columns('semana', 'diagnostic', 'tipo_dx', 'e_salud', 'ubigeo', 'apepat', 'apemat', 'nombres', 'dni', 'fecha_inv');
$crud->set_subject('Ficha');
switch ($nivelUsuario) {
case '8':
$where = array('e_salud' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'sub_reg_nt' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
$where = array('red' => $this->session->userdata("red"), 'sub_reg_nt' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('sub_reg_nt' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
$crud->where($enfermedad);
$crud->or_where($enfermedad1);
$crud->display_as("apepat", "Ap. Paterno");
$crud->display_as("apemat", "Ap. Materno");
$crud->display_as("ubigeo", "Distrito");
$crud->display_as("diagnostic", "Enfermedad");
$crud->display_as("e_salud", "Establecimiento");
$crud->display_as("fecha_inv", "Investigación");
$crud->set_relation('ubigeo', 'distrito', 'nombre');
$crud->set_relation('diagnostic', 'diagno', 'diagno');
$crud->field_type('e_salud', 'dropdown', $estab);
$crud->field_type('tipo_dx', 'dropdown', $tipo);
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_export();
$crud->unset_delete();
$crud->unset_print();
$crud->add_action('Registrar Ficha', base_url() . 'assets/images/more.png', 'modulos/RegfichaChik', '');
$output1 = $crud->render();
$this->_notificados_output($output1);
}
public function listarCasos()
{
$establecimiento = $this->mantenimiento_model->listarEstablecimiento();
foreach ($establecimiento as $dato) {
$est[$dato->cod_est] = $dato->raz_soc;
}
$diagnostico = $this->mantenimiento_model->listarDiagnostico();
foreach ($diagnostico as $dato) {
$diagno[$dato->cie_10] = $dato->diagno;
}
$crud = new grocery_CRUD();
//$crud->set_theme("datatables");
$crud->set_table('individual');
$crud->columns('diagnostic', 'e_salud', 'apepat', 'apemat', 'nombres', 'dni');
$crud->set_subject('Ficha');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('diagnostic' => 'O98.1', 'e_salud' => $this->session->userdata("establecimiento"));
$or_where = array('diagnostic' => 'A50');
$crud->where($where);
$crud->or_where($or_where);
break;
case '7':
$where = array('diagnostic' => 'O98.1', 'microred' => $this->session->userdata("microred"), 'redes' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$or_where = array('diagnostic' => 'A50');
$crud->where($where);
$crud->or_where($or_where);
break;
case '6':
$where = array('diagnostic' => 'O98.1', 'redes' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$or_where = array('diagnostic' => 'A50');
$crud->where($where);
$crud->or_where($or_where);
break;
case '5':
$where = array('diagnostic' => 'O98.1', 'sub_reg_nt' => $this->session->userdata("diresa"));
$or_where = array('diagnostic' => 'A50');
$crud->where($where);
$crud->or_where($or_where);
break;
default:
$where = array('diagnostic' => 'O98.1');
$or_where = array('diagnostic' => 'A50');
$crud->where('diagnostic', 'O98.1');
$crud->or_where($or_where);
break;
}
$crud->field_type('e_salud', 'dropdown', $est);
$crud->display_as("e_salud", "Establecimiento");
$crud->field_type('diagnostic', 'dropdown', $diagno);
$crud->display_as("diagnostic", "Enfermedad");
$crud->display_as("apepat", "Paterno");
$crud->display_as("apemat", "Materno");
$crud->display_as("fecha_not", "Notificación");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_read();
$crud->unset_print();
$crud->unset_export();
$crud->add_action('Registrar Ficha', '', 'modulos2/RegfichaSif', 'edit-icon');
$output = $crud->render();
$this->layout->view('listarCasos', $output);
}
public function persutujuan_daftar_kegiatan_berkas()
{
try {
$crud = new grocery_CRUD();
$state = $crud->getState();
$id_kegiatan_transaksi = $this->uri->segment(3);
$crud->where('id_kegiatan_transaksi', $id_kegiatan_transaksi);
$crud->set_table('tbl_kegiatan_transaksi_berkas');
$crud->set_subject('Daftar Berkas Pegawai');
$crud->set_field_upload('berkas', 'assets/uploads/berkas');
$crud->fields('no', 'judul', 'berkas', 'keterangan');
$crud->columns('no', 'judul', 'berkas', 'keterangan');
$crud->order_by('id_kegiatan_transaksi_berkas', 'desc');
//$crud->change_field_type('nama_depan', 'readonly');
$crud->unset_save();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_delete();
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_pegawai', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function irasCampos()
{
if (empty($this->session_id)) {
redirect(site_url("index/login"), 301);
}
$reporta = array('ano' => date('Y'), 'semana' => date('W') - 2);
$this->reportes_model->registraCalidad($reporta);
$this->calidad_model->edasCampos();
$crud = new grocery_CRUD();
$crud->set_table('irasDefunciones');
$crud->columns('ano', 'semana', 'sub_reg_nt', 'red', 'microred', 'e_salud', 'ubigeo', 'ira_m2', 'ira_2_11', 'ira_1_4a', 'neu_2_11', 'neu_1_4a', 'ngr_m2', 'ngr_2_11', 'ngr_1_4a');
$crud->display_as('ano', 'Año');
switch ($this->session->userdata('nivel')) {
case 4:
$accesar = $this->session->userdata('equipo');
break;
case 5:
$accesar = $this->session->userdata('diresa');
$crud->or_where(array('sub_reg_nt' => $accesar));
break;
case 6:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1));
break;
case 7:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$accesar2 = $this->session->userdata('microred');
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
break;
case 8:
$accesar = $this->session->userdata('establecimiento');
$crud->where(array('e_salud' => $accesar));
break;
}
$crud->order_by('semana');
$crud->unset_add();
$crud->unset_read();
$crud->unset_edit();
//$crud->unset_delete();
//$crud->unset_export();
$crud->unset_print();
$crud->add_action('Editar', '', 'calidad/modIras', 'edit-icon');
$crud->callback_after_delete(array($this, 'log_iras_registro_after_delete'));
$output = $crud->render();
$this->layout->view('irasCampos.php', $output);
}
function crud_historico_incidencias()
{
//creamos objeto crud
$crud = new grocery_CRUD();
//selecionamos la tabla incidencias
$crud->set_table('incidencias');
//para quitar las opcinesd e editar
$crud->unset_edit();
//quitar las opciones de añadir
$crud->unset_add();
//quitar las opciones de borrar
$crud->unset_delete();
$crud->like("estado", "CERRADA");
$output = $crud->render();
//a la vista-backoffice le pasamos el output(array)
$this->load->view('home', $output);
}
public function expired_offers()
{
$crud = new grocery_CRUD();
//$crud->set_theme('datatables');
$dt = new DateTime();
$now = $dt->format('Y-m-d');
$crud->where('valid_till <', $now);
$crud->set_table('offers');
$crud->set_subject('Users Data');
$crud->columns('id', 'card_name', 'offer', 'offer_category', 'offer_subcategory', 'establishment_id', 'offer_type', 'amount', 'valid_till', 'offer_url', 'tnc', 'imp_tnc', 'latitude', 'longtitude', 'specific_location_exists', 'applicable_across_category', 'week_days', 'city');
// $crud->columns('id', 'card_name', 'offer');
// $crud->set_relation('card_name', 'card', 'card_name');
$crud->set_field_upload('offer_logo', 'assets/uploads/offers_logo');
$crud->set_relation('offer_category', 'categories_master', 'category');
$crud->set_relation('offer_subcategory', 'subcategories_master', 'category');
$crud->set_relation('establishment_id', 'establishment', 'establishment');
$crud->unset_columns('created_date');
$crud->unset_add_fields('created_date');
$crud->unset_edit_fields('created_date');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$data = $crud->render();
$this->load->view('admin/crud_view', $data);
}
public function transfer_order()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('transfer_order');
$crud->columns('pickup_location', 'pickup_destination', 'price', 'order_status');
$crud->add_action('Complete', '', 'manage/complete_order', 'ui-icon-check');
$crud->set_relation('car_type', 'car_type', 'type_name');
$crud->set_relation('car_model', 'our_fleet', 'car_name');
$crud->set_relation('user', 'users', 'Username :- {username} <br>Email Address :- {email}');
$crud->unset_add();
$crud->unset_edit();
$output = $crud->render();
$this->_example_output($output);
}
public function listadoIndividual()
{
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$dist = $this->frontend_model->listarDistritos();
$ubigeo = array();
foreach ($dist as $dato) {
$ubigeo[$dato->ubigeo] = $dato->nombre;
}
$enf = $this->frontend_model->mostrarDiagnostico();
$enfermedad = array();
foreach ($enf as $dato) {
$enfermedad[$dato->cie_10] = $dato->diagno;
}
$tdx = $this->frontend_model->mostrarTipo();
$tipoDx = array();
foreach ($tdx as $dato) {
$tipoDx[$dato->codigo] = $dato->denominacion;
}
$filtro = array();
$this->input->post('diresa') ? $filtro['sub_reg_nt'] = $this->input->post('diresa') : '';
$this->input->post('redes') ? $filtro['red'] = $this->input->post('redes') : '';
$this->input->post('microred') ? $filtro['microred'] = $this->input->post('microred') : '';
$this->input->post('establec') ? $filtro['e_salud'] = $this->input->post('establec') : '';
$this->input->post('departamento') ? $filtro['substr(ubigeo,1,2)'] = $this->input->post('departamento') : '';
$this->input->post('provincia') ? $filtro['substr(ubigeo,1,4)'] = $this->input->post('provincia') : '';
$this->input->post('distrito') ? $filtro['ubigeo'] = $this->input->post('distrito') : '';
$this->input->post('diagno') ? $filtro['diagnostic'] = $this->input->post('diagno') : '';
$this->input->post('tipoDx') ? $filtro['tipo_dx'] = $this->input->post('tipoDx') : '';
$this->input->post('ano_ini') ? $filtro['ano'] = $this->input->post('ano_ini') : '';
$this->input->post('semana_ini') ? $filtro['semana'] = $this->input->post('semana_ini') : '';
$this->input->post('apepat') ? $filtro['apepat'] = $this->input->post('apepat') : '';
$crud = new grocery_CRUD();
$crud->set_theme("datatables");
$crud->set_table('individual');
$crud->columns('ano', 'semana', 'diagnostic', 'tipo_dx', 'subregion', 'sub_reg_nt', 'ubigeo', 'sexo', 'apepat', 'apemat', 'nombres');
$crud->display_as('ano', 'Año')->display_as('diagnostic', 'Diagnóstico')->display_as('subregion', 'Diresa')->display_as('sub_reg_nt', 'Notificante')->display_as('ubigeo', 'Distrito')->display_as('tipo_dx', 'Tipo')->display_as('apepat', 'Ap. Paterno')->display_as('apemat', 'Ap. Materno');
$crud->field_type('subregion', 'dropdown', $subr);
$crud->field_type('sub_reg_nt', 'dropdown', $subr);
$crud->field_type('ubigeo', 'dropdown', $ubigeo);
$crud->field_type('diagnostic', 'dropdown', $enfermedad);
$crud->field_type('tipo_dx', 'dropdown', $tipoDx);
$crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino'));
if ($this->input->post()) {
if ($this->session->userdata('institucion') == 'A') {
$crud->where($filtro);
} else {
$crud->where($filtro);
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
} else {
$crud->where(array('ano' => date('Y')));
switch ($this->session->userdata('nivel')) {
case 4:
$accesar = $this->session->userdata('equipo');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion')));
}
break;
case 5:
$accesar = $this->session->userdata('diresa');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'subregion' => $accesar));
} else {
$crud->where(array('subregion' => $accesar));
$crud->or_where(array('sub_reg_nt' => $accesar));
}
break;
case 6:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1));
}
break;
case 7:
$accesar = $this->session->userdata('diresa');
$accesar1 = $this->session->userdata('red');
$accesar2 = $this->session->userdata('microred');
if ($this->session->userdata('institucion') != 'A') {
$crud->where(array('substr(e_salud,7,1)' => $this->session->userdata('institucion'), 'sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
} else {
$crud->where(array('sub_reg_nt' => $accesar, 'red' => $accesar1, 'microred' => $accesar2));
}
break;
case 8:
$accesar = $this->session->userdata('establecimiento');
$crud->where(array('e_salud' => $accesar));
break;
}
}
$crud->limit(1000);
$crud->order_by('semana', 'DESC');
$crud->set_subject('Individual');
$crud->unset_add();
$crud->unset_read();
$crud->unset_edit();
$crud->unset_export();
$crud->unset_print();
$crud->callback_after_delete(array($this, 'log_usuario_before_delete'));
$crud->add_action('Editar', '', 'individual/modIndividual', 'ui-icon-pencil');
///////////////////////////////////////////////////////////////////////////////
//$crud->add_action_peru('Añadir Individual', '', 'regIndividual','add-icon');
///////////////////////////////////////////////////////////////////////////////
$output = $crud->render();
$this->_example_output1($output);
}
