function configuracion()
{
$crud = new grocery_CRUD();
$crud->set_table('usuarios');
$crud->set_theme('datatables');
$crud->set_language('spanish');
$crud->set_subject('Usuario');
$state = $crud->getState();
$state_info = $crud->getStateInfo();
if ($state == 'list' || $state == 'success') {
redirect('user/dashboard');
} else {
$crud->unset_add();
$crud->unset_delete();
$crud->field_type('usuario', 'readonly');
$crud->field_type('clave', 'password');
$crud->field_type('id_cliente', 'hidden');
$crud->field_type('id_nivel', 'hidden');
$crud->field_type('row_id', 'hidden');
$crud->field_type('id_estatus', 'hidden');
$crud->set_field_upload('foto', 'assets/uploads/users/');
$output = $crud->render();
$data['titulo'] = "CONFIGURACION DE USUARIO";
$this->load->view('include/head', $output);
$this->load->view('include/header', $data);
$this->load->view('admin/output');
$this->load->view('include/footer', $data);
$this->load->view('admin/librerias');
}
}
function perfil()
{
$crud = new grocery_CRUD();
$crud->where('row_id', $this->session->userdata('user_id'));
$crud->set_table('usuarios');
$crud->set_theme('datatables');
$crud->set_language('spanish');
$crud->set_subject('Usuario');
$state = $crud->getState();
if ($state == 'list' || $state == 'success') {
redirect('user/dashboard');
} else {
$crud->unset_add();
$crud->unset_delete();
$crud->field_type('usuario', 'readonly');
$crud->field_type('clave', 'password');
$crud->field_type('id_nivel', 'hidden');
$crud->field_type('row_id', 'hidden');
$crud->field_type('id_estatus', 'hidden');
$crud->set_field_upload('foto', 'assets/uploads/users/');
$output = $crud->render();
$data['titulo'] = "Configuración de Usuario";
$this->load->view('include/head');
$this->load->view('include/header');
$this->load->view('include/sidebar');
$this->load->view('admin/main', $data);
$this->load->view('admin/grocery_crud', $output);
$this->load->view('include/footer');
}
}
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 historial()
{
if ($this->session->userdata('is_logged_in')) {
$crud = new grocery_CRUD();
//-> Identifico el ID del Cliente
$crud->set_table('dolar_hoy');
//->
$crud->set_theme('datatables');
$crud->set_language('spanish');
// Display As
$crud->unset_add();
//-> Columnas
$crud->columns('cambio', 'fecha', 'registrado_por', 'registrado_fecha', 'registrado_hora');
// Relaciones
##
//-> Renderizar
$output = $crud->render();
$data['titulo'] = "DOLAR HISTORIAL";
$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 capturar()
{
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');
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$output = $crud->render();
$data['titulo'] = "CREAR FACTURAS";
$clientes = $this->Clientes_model->GetClients();
$producto = $this->Products_model->get_all_products();
$sucursales = $this->Sucursales_model->get_all_sucursales();
$moneda = $this->datos_model->get_datos("tipos_moneda", "row_id, descripcion", "row_id", "ASC");
$datos = array('clientes' => $clientes, 'productos' => $producto, 'sucursales' => $sucursales, "moneda" => $moneda);
$this->load->view('include/head', $output);
$this->load->view('include/header', $data);
$this->load->view('admin/addFactura', $datos);
$this->load->view('admin/librerias');
$this->load->view('include/footer', $data);
} else {
$this->load->view('admin/login');
}
}
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()
{
// $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 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 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);
}
function index()
{
if ($this->session->userdata('is_logged_in')) {
$crud = new grocery_CRUD();
//-> Identifico el ID del Cliente
$crud->set_table('notificaciones');
//->
$crud->set_theme('datatables');
$crud->set_language('spanish');
// Display As
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
//-> Columnas
$crud->columns('titulo', 'contenido', 'fecha');
// Relaciones
##
//-> Renderizar
$output = $crud->render();
$data['titulo'] = "NOTIFICACIONES";
$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();
$crud->set_theme('flexigrid');
$crud->set_table('booking_refunds');
$crud->set_subject('Booking Refund');
$crud->unset_add();
$crud->unset_delete();
// $crud->unset_columns('booking_ref_no');
$crud->unset_fields('booking_ref_no');
$crud->field_type('refund_status', 'dropdown', array('1' => 'Requested', '0' => 'Rejected', '2' => 'Refunded'));
// $crud->field_type('refund_status', 'dropdown', array('1'=>'Requested', '0'=>'Rejected', '2' => 'Refunded'));
// $crud->callback_column('refund_status', function($value, $primary_key){
// $status = array('1'=>'Requested', '0'=>'Rejected', '2' => 'Refunded');
// return $status[$value];
// });
$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');
$this->load->view('gc_admin_wrapper', $data);
}
public function listarAccesos()
{
$aplica = $this->fichas_model->buscarAplicaciones();
$aplicacion = array();
foreach ($aplica as $dato) {
$aplicacion[$dato->aplicacion] = $dato->nombre;
}
$usuarios = $this->fichas_model->buscarUsuarios();
$usu = array();
foreach ($usuarios as $dato) {
$usu[$dato->usuario] = $dato->usuario . " - " . $dato->nombres;
}
$crud = new grocery_CRUD();
$crud->set_table('tablaccesos');
$crud->columns('aplicacion', 'usuario', 'estado');
$crud->set_subject('Acceso');
$crud->field_type('aplicacion', 'dropdown', $aplicacion);
$crud->field_type('usuario', 'dropdown', $usu);
$crud->field_type('estado', 'dropdown', array('1' => 'Activo', '2' => 'Inactivo', '3' => 'Suspendido'));
$crud->unset_print();
$crud->unset_export();
$crud->unset_add();
$output = $crud->render();
$this->_example_output1($output);
}
public function punjabdata()
{
$this->data['page_title'] = 'punjabupdate.com';
$crud = new grocery_CRUD();
$crud->set_table('newpunjab2');
$crud->set_subject('punjabdata');
$crud->unset_add()->unset_edit()->unset_delete()->unset_read();
$this->data['output'] = $crud->render();
$this->render('admin/crud_view');
}
public function ijorcsdata()
{
$this->data['page_title'] = 'ijorcs.org';
$crud = new grocery_CRUD();
$crud->set_table('newijorcs2');
$crud->set_subject('Ijorcsdata');
$crud->unset_add()->unset_edit()->unset_delete()->unset_read();
$this->data['output'] = $crud->render();
$this->render('admin/crud_view');
}
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 ijorcsdata()
{
$this->data['page_title'] = 'ijorcs.org';
$crud = new grocery_CRUD();
$crud->set_table('newijorcs');
$crud->set_subject('Ijorcsdata');
$crud->callback_column('landingPagePath', array($this, 'full_text'));
//$crud->set_relation('parent_id','autogeneratetree','nodename');
$crud->unset_add()->unset_edit()->unset_delete()->unset_read();
$this->data['output'] = $crud->render();
$this->render('admin/crud_view');
}
public 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);
}
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('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 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 index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('clients');
$crud->set_subject('Clients');
$crud->unset_fields('client_id');
$crud->unset_columns('client_id');
// $crud->unset_columns('package_thingsToConsider');
// $crud->unset_columns('package_weatherCondition');
// $crud->unset_columns('package_itinerary');
//
$crud->display_as('client_postcode', 'Post Code');
$crud->display_as('client_phoneNumber', 'Phone Number');
$crud->display_as('client_emailId', 'Email ID');
$crud->display_as('client_firstName', 'First Name');
$crud->display_as('client_lastName', 'Last Name');
// $crud->set_field_upload('package_image', $this->upload_path);
// $crud->unique_fields('package_slug');
//
// $crud->set_relation('package_agent', 'agents', '{agent_companyName}');
//
// $crud->callback_column('package_image', array($this, 'set_image'));
// $crud->callback_column('package_cost', array($this, 'set_price'));
//
// $crud->callback_add_field('package_cost', array($this, 'add_price1'));
// $crud->callback_edit_field('package_cost', array($this, 'edit_price1'));
// $crud->callback_column('package_status', array($this, 'set_change_status'));
// $crud->unset_columns('package_status');
// $crud->add_action('change Status', '', '/change_status');
// $crud->add_action('Change Status', './assets/grocery_crud/themes/flexigrid/css/images/add.png', 'packages/change_status');
// $crud->add_action('package_status', '', '','ui-icon-image',array($this,'just_a_test'));
// $crud->add_action('package_status', '', '','ui-icon-image',array($this,'just_a_test'));
// $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(strtolower(__CLASS__).'/'.strtolower(__FUNCTION__)).'";
// </script>
// <div style="display:none">
// '
// );
$crud->unset_add();
$crud->unset_delete();
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Clients', 'pagedesc' => 'Clients', 'contenttitle' => 'Clients List Records');
// redirect(base_url());
$this->load->view('gc_admin_wrapper', $data);
}
public 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();
//Config Halaman
$output->judul_besar = 'Order';
$output->judul_kecil = 'Manage Order';
$output->m_orders_management = TRUE;
$this->_example_output($output);
}
public function pengaturan()
{
$crud = new grocery_CRUD();
$crud->set_table('pengaturan');
$crud->unset_add();
$crud->unset_delete();
$crud->unset_read();
$output = $crud->render();
//Config Halaman
$output->judul_besar = 'Pengaturan';
$output->judul_kecil = 'Manage Pengaturan';
$output->m_pengaturan = TRUE;
// echo $this->Absensi_model->get_status_mesin();
//$this->Absensi_model->get_data_absen();
$this->_example_output($output);
}
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 psy_window($id)
{
$this->id_femme = $id;
try {
// General
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->where('id_from_femme', $this->id_femme);
$crud->set_table('sos_psy');
$crud->set_subject('Accompagnement Psychologique');
//relations
$crud->set_relation_n_n('troubles_physiologiques', 'sos_relation_troubles_physiologiques', 'sos_gen_troubles_physiologiques', 'id_from_psy', 'id_from_troubles_physiologiques', 'name_troubles_physiologiques', 'priority');
$crud->set_relation_n_n('troubles_cognitifs', 'sos_relation_troubles_cognitifs', 'sos_gen_troubles_cognitifs', 'id_from_psy', 'id_from_troubles_cognitifs', 'name_troubles_cognitifs', 'priority');
$crud->set_relation_n_n('troubles_emotionnels', 'sos_relation_troubles_emotionnels', 'sos_gen_troubles_emotionnels', 'id_from_psy', 'id_from_troubles_emotionnels', 'name_troubles_emotionnels', 'priority');
//Visual
$crud->columns('troubles_physiologiques', 'troubles_cognitifs', 'troubles_emotionnels');
$crud->display_as('troubles_emotionnels', 'Troubles émotionnels');
//unsets
$crud->unset_delete();
$crud->unset_add();
//Requireds
//Callbacks
$crud->callback_column('troubles_physiologiques', array($this, 'troubles_physiologiques'));
$crud->callback_column('troubles_cognitifs', array($this, 'troubles_cognitifs'));
$crud->callback_column('troubles_emotionnels', array($this, 'troubles_emotionnels'));
//field Types
$crud->field_type('id_from_femme', 'hidden', $this->id_femme);
// Actions
// Renders
$output = $crud->render();
$menu = new stdClass();
$menu->n1 = true;
$menu->status = $this->session->userdata('status');
$this->db->where('id_femme', $this->id_femme);
$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());
}
}
public 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();
$crud->unset_columns('comments');
$output = $crud->render();
$data['judul'] = 'Orders';
$data['crumb'] = array('Orders' => '');
$template = 'admin_template';
$view = 'grocery';
$this->outputview->output_admin($view, $template, $data, $output);
}
public function teacher_management()
{
try {
$crud = new grocery_CRUD();
$crud->set_table('tj_jyk_teacher');
$crud->set_subject('教师');
/*$crud->required_fields('jsdm');*/
$crud->columns('jsxm', 'yxdm', 'xnd', 'xmjc', 'jb', 'xmmc');
$crud->display_as('jsxm', '姓名')->display_as('jsdm', '工号')->display_as('yxdm', '所属学院（系）')->display_as('xnd', '年度')->display_as('xmjc', '届次')->display_as('jb', '级别')->display_as('xmmc', '项目名称');
/* $crud->set_rules('jsdm','integer');*/
$crud->unset_add();
$output = $crud->render();
$this->_main_output($output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}