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());
}
}
public function listarNeumonias()
{
$sub = $this->frontend_model->buscarDiresas();
$subr = array();
foreach ($sub as $dato) {
$subr[$dato->codigo] = $dato->nombre;
}
$est = $this->frontend_model->listaEstablec();
$estab = array();
foreach ($est as $dato) {
$estab[$dato->cod_est] = $dato->raz_soc;
}
$crud = new grocery_CRUD();
$crud->set_table('neumonias');
$crud->columns('diresa', 'e_salud', 'apepat', 'apemat', 'nombres', 'sexo', 'fecha_reg', 'fecha_def', 'usuario');
$crud->set_subject('Ficha');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('e_salud' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
$where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
$crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino'));
$crud->field_type('diresa', 'dropdown', $subr);
$crud->field_type('e_salud', 'dropdown', $estab);
$crud->display_as("apepat", "Apellido Paterno");
$crud->display_as("apemat", "Apellido Materno");
$crud->display_as("fecha_reg", "Registro");
$crud->display_as("fecha_def", "Defunción");
$crud->display_as("e_salud", "Establecimiento");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_export();
//$crud->unset_print();
$crud->callback_after_delete(array($this, 'log_usuario_before_delete'));
$crud->add_action_peru('', '', 'RegfichaNeum', 'add-icon');
$crud->add_action('Modificar Ficha', '', 'modulos3/ModfichaNeum', 'edit-icon');
$crud->add_action('Ver Ficha', '', 'modulos3/VerfichaNeum', 'read-icon');
$output = $crud->render();
$this->_example_output($output);
}
public function listar_transito()
{
/*$establecimiento = $this->mantenimiento_transito->listarEstablecimiento();
foreach($establecimiento as $dato){
$est[$dato->cod_est] = $dato->raz_soc;
} */
$crud = new grocery_CRUD();
//$crud->set_theme('bootstrap');
$crud->set_table('trans_lesacctra');
$crud->columns('id', 'ano', 'ap_nm1', 'ap_nm2', 'nom_les', 'edad', 'tipo_edad', 'diresa', 'eess');
$crud->set_subject('Ficha Transito');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('cod_eess' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
//$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red' and microred = '$microred')";
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
//$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red')";
$where = array('red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('cod_dir' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
//$crud->field_type('establec', 'dropdown', $est);
$crud->display_as("id", "ID")->display_as("ano", "AÑO")->display_as("ap_nm1", "APELLIDO PATERNO")->display_as("ap_nm2", "APELLIDO MATERNO")->display_as("nom_les", "NOMBRES")->display_as("edad", "EDAD")->display_as("tipo_edad", "TIPO")->display_as("diresa", "DIRESA")->display_as("eess", "ESTABLECIENTO DE SALUD");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_print();
$crud->unset_export();
$crud->unset_delete();
$crud->order_by('id', 'desc');
$crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulotransito/borrarFichatransito', 'borrar-icon');
$crud->add_action('Vista previa', '', 'modulotransito/ver_ficha_transito', 'read-icon');
$crud->add_action('Editar Ficha Transito', '', 'modulotransito/modificacion_transito', 'edit-icon');
$output = $crud->render();
$usuario = $this->session->userdata("usuario");
$accion = 'Listar Casos Accidentes de Transito';
$this->login_model->auditoriaOperador($usuario, $accion);
$this->layout->view('listar_transito', $output);
}
public function daftar()
{
$crud = new grocery_CRUD();
//$crud->set_table('permohonan');
$crud->set_table('vtdp');
$crud->set_subject('Data Permohonan Izin TDP');
$crud->columns('no_agenda', 'nosk', 'perusahaan', 'tglpermohonan', 'status', 'catatan_bo', 'lama_proses');
$crud->set_primary_key('id', 'vtdp');
//$crud->set_relation_n_n('perusahaan', 'tdp','perusahaan','permohonan_id','perusahaan_id','nama');
//$crud->set_relation('spermohonan_id', 'spermohonan','status');
$crud->display_as('no_agenda', 'No.Agenda');
$crud->display_as('nosk', 'No.SK');
$crud->display_as('perusahaan', 'Nama Perusahaan');
$crud->display_as('lama_proses', 'Lama Proses');
$crud->add_action('Hapus Data', '', site_url() . '/tdp/simpen_hapus', 'delete-icon');
$crud->add_action('Edit Data', '', site_url() . '/tdp/ubah', 'edit-icon');
$crud->add_action('Ubah Status Pemrosessan Data', '', 'tdp', 'proses-icon');
$crud->add_action('Cetak Tanda Bukti', '', 'tdp/cetak_sk', 'tbukti-icon', '', 'penerimaan', 'bap', 'bukti');
$crud->add_action('Cetak SK', '', 'tdp/cetak_sk', 'sk-icon', '', 'sk', 'skatas');
$crud->where('ijin_id', '6');
$crud->order_by('tglpermohonan desc,id desc,perusahaan', 'desc');
$crud->unset_export();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_read();
$crud->set_crud_url_path(site_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), site_url(strtolower(__CLASS__)));
$output = $crud->render();
$this->load->view('home.php');
$this->load->view('vtdp_daftar.php', $output);
}
public function denuncias_por_ciudadano($idCiudadano)
{
$crud = new grocery_CRUD();
$crud->set_theme('bootstrap');
$crud->set_language('spanish');
$crud->where('denuncias.idCiudadano', $idCiudadano);
$crud->set_table('denuncias');
$crud->set_subject('Denuncias Por Ciudadano');
$crud->set_relation('idCiudadano', 'ciudadanos', '{nombre}\\n{apellidoPa}\\n{apellidoMa}');
$crud->set_relation('idRecepcion', 'recepcion', 'descripcion');
$crud->set_relation('idDependencia', 'dependencias', 'dependencia');
$crud->set_relation('idEstatus', 'estatus', 'descripcion');
$crud->set_relation('idDireccion', 'direcciones', 'Calle:{calle} \\n #:{noExt} # Int:{noInt} Col:{colonia}, \\n{localidad}, CP:{cp} ');
$crud->set_relation('idAsunto', 'asuntos', 'descripcion');
$crud->display_as('idCiudadano', 'Ciudadano');
$crud->display_as('idDireccion', 'Dirección');
$crud->display_as('idRecepcion', 'Recepción');
$crud->display_as('idEstatus', 'Estatus');
$crud->display_as('idDependencia', 'Dependencia');
$crud->display_as('idAsunto', 'Asunto');
$crud->unset_add();
$crud->columns('idCiudadano', 'idAsunto', 'idDependencia', 'idEstatus', 'idDireccion', 'idRecepcion');
$output = $crud->render();
$this->_example_output($output);
}
public function 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);
}
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 debitAlert()
{
$crud = new grocery_CRUD();
$where = "((SELECT DATEDIFF(sales_order.`due_date`, '{$this->curDate}') AS days) < 14) AND (sales_order.`due_date` > '{$this->curDate}') AND (sales_order.`status_paid` = 0)";
$crud->where($where)->order_by('due_date', 'asc')->set_table('sales_order')->columns('id_sales_order', 'id_customer', 'date', 'due_date', 'grand_total', 'paid', 'debit')->display_as('id_sales_order', 'No Faktur')->display_as('name', 'Nama Pelanggan')->display_as('date', 'Tanggal Transaksi')->display_as('due_date', 'Jatuh Tempo')->display_as('grand_total', 'Tagihan')->display_as('paid', 'Terbayar')->display_as('debit', 'Piutang')->callback_column('debit', array($this, 'getBalance'))->callback_column('grand_total', array($this, 'currencyFormat'))->callback_column('paid', array($this, 'currencyFormat'))->set_relation('id_customer', 'customer', 'name')->unset_operations();
$extra = 'Informasi Tagihan Piutang';
$output = $crud->render($extra);
$this->render($output);
}
public function listarMnp()
{
$crud = new grocery_CRUD();
$crud->set_table('mnp');
$crud->columns('registroId', 'ape_nom', 'sexo', 'fecha_nac', 'fecha_mte', 'fecha_reg', 'usuario');
$crud->set_subject('Ficha');
$nivelUsuario = $this->session->userdata("nivel");
switch ($nivelUsuario) {
case '8':
$where = array('e_salud' => $this->session->userdata("establecimiento"));
$crud->where($where);
break;
case '7':
$where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '6':
$where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
case '5':
$where = array('diresa' => $this->session->userdata("diresa"));
$crud->where($where);
break;
}
$crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino', 'I' => 'Indeterminado'));
$crud->display_as("registroId", "Ficha");
$crud->display_as("ape_nom", "Apellidos y Nombres");
$crud->display_as("fecha_nac", "Fecha de Nacimiento");
$crud->display_as("fecha_mte", "Defunción");
$crud->display_as("fecha_reg", "Fecha de Registro");
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_export();
$crud->unset_delete();
//$crud->unset_print();
$crud->add_action_peru('', '', 'RegfichaMnp', 'add-icon');
$crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulosmnp/delFichaMnp', 'borrar-icon');
$crud->add_action('Modificar Ficha', '', 'modulosmnp/ModfichaMnp', 'edit-icon');
$crud->add_action('Ver Ficha', '', 'modulosmnp/VerfichaMnp', 'read-icon');
$output = $crud->render();
$this->_example_output($output);
}
function peserta_kkn_management()
{
$session = isset($_SESSION['username_belajar']) ? $_SESSION['username_belajar'] : '';
if ($session != "") {
$pecah = explode("|", $session);
$data["NIM"] = $pecah[0];
$data["NAMA"] = $pecah[1];
$data["STATUS"] = $pecah[3];
if ($data["STATUS"] == "Admin") {
try {
/* This is only for the autocompletion */
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->where('SUDAH', '2');
$crud->set_table('KKN_MHS');
$crud->set_language("indonesian");
$crud->display_as('NIM', 'Data Pribadi');
$crud->set_relation('NIM', 'D_MAHASISWA', 'Nim :{NIM}, Angkatan :{ANGKATAN},Nama :{NAMA},Jk: {J_KELAMIN},Asal: {ALAMAT_MHS}, Golongan Darah: {GOL_DARAH},HP Mhs: {HP_MHS},Telp Keluarga: {TELP_MHS}');
$crud->display_as('FAK', 'Fakultas')->display_as('NO', 'No Pendaftaran')->display_as('ALAMAT_JOGJA', 'Alamat di Jogja')->display_as('NM_KEC_JOGJA', 'Kec di Jogja')->display_as('NM_KAB_JOGJA', 'Kab di Jogja')->display_as('PRESTASI', 'Keahlian')->display_as('RT_JOGJA', 'RT di Jogja')->display_as('DESA_JOGJA', 'Desa di Jogja')->display_as('KODE_POS_JOGJA', 'Kod Pos di Jogja')->display_as('TRANSPORTASI', 'Transportasi')->display_as('PATH_SK_DOKTER', 'Upload SK Dokter')->display_as('PATH_SK_GOLONGAN_DARAH', 'Upload SK Gol Darah')->display_as('PATH_SK_CUTI', 'Upload SK Cuti Kerja')->display_as('PATH_SK_TIDAK_HAMIL', 'Upload SK Tidak Hamil');
$crud->unset_edit_fields('SUDAH');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_add_fields('NO', 'SUDAH');
$crud->set_subject('Peserta KKN');
$crud->required_fields('ALAMAT_JOGJA');
$crud->columns('NIM', 'FAK', 'ALAMAT_JOGJA', 'PRESTASI', 'NM_KEC_JOGJA', 'NM_KAB_JOGJA');
$crud->set_field_upload('PATH_SK_DOKTER', 'assets/kesehatan');
$crud->set_field_upload('PATH_SK_GOLONGAN_DARAH', 'assets/goldarah');
$crud->set_field_upload('PATH_SK_CUTI', 'assets/cutikerja');
$crud->set_field_upload('PATH_SK_TIDAK_HAMIL', 'assets/tidakhamil');
//$crud->edit_fields('NIM','KD_FAK','ALAMAT_JOGJA','PRESTASI','KD_KEC','KD_KAB');
$crud->callback_edit_field('NIM', array($this, 'edit_field_callback_nim'));
$crud->callback_edit_field('NO', array($this, 'edit_field_callback_no'));
$output = $crud->render();
$this->_manage_output($output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
} else {
?>
<script type="text/javascript" language="javascript">
alert("Anda tidak berhak masuk ke Control Panel Admin...!!!");
</script>
<?php
echo "<meta http-equiv='refresh' content='0; url=" . base_url() . "kkn'>";
}
} else {
?>
<script type="text/javascript" language="javascript">
alert("Anda belum Log In...!!!\nAnda harus Log In untuk mengakses halaman ini...!!!");
</script>
<?php
echo "<meta http-equiv='refresh' content='0; url=" . base_url() . "kkn'>";
}
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('hotels');
$crud->set_subject('Hotels');
// $crud->set_relation('hotel_agent_id', 'io_users', '{first_name} {last_name}');
$agent_id = $this->ion_auth->user()->row()->id;
$crud->where('hotel_agent_id', $agent_id);
$crud->field_type('hotel_agent_id', 'hidden', $agent_id);
// $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', 'GoogleMap');
$crud->display_as('hotel_status', 'Status');
$crud->columns('hotel_name', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook', 'hotel_googleMap', 'hotel_status');
$crud->callback_column('hotel_image', array($this, 'set_image'));
$crud->set_field_upload('hotel_image', $this->upload_path);
/*
* For related hotels
* on add list all the hotels
* on edit, list all except own name
*/
if ($crud->getState() == 'edit') {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_agent_id' => $this->ion_auth->get_user_id(), 'hotel_id !=' => $crud->getStateInfo()->primary_key), 'hotel_id');
} else {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_agent_id' => $this->ion_auth->get_user_id()), 'hotel_id');
}
// empty data for multiselect field generates error
if (empty($hrf)) {
$hrf = array('');
} else {
$hrf = $this->generic_model->array_from_db($hrf, 'hotel_id, hotel_name');
}
$crud->field_type('hotel_related', 'multiselect', $hrf);
$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->add_action('Photo Gallery', '', 'agents/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', 'left_menu' => 'agents_menu');
$this->load->view('gc_admin_wrapper', $data);
}
function faiz()
{
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('thalilist');
if ($_SESSION['email'] == '*****@*****.**') {
$crud->unset_edit();
$crud->unset_delete();
$crud->where('Transporter', 'Mustafa Bhai') && $crud->where('Active', '1');
$crud->columns('Thali', 'NAME', 'CONTACT', 'Active', 'Transporter', 'Full_Address');
}
$output = $crud->render();
$this->_example_output($output);
}
public function admins()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('users');
$crud->where('group_id', '1');
$crud->columns('username', 'email', 'user_skype', 'user_contact', 'user_lastname');
$output = $crud->render();
$this->_example_output($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($categoryid = 0)
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$data['lo'] = 2;
//value used to identify section movie or celebrity
$data['categoryid'] = $categoryid;
//value used to identify section movie or celebrity
if ($categoryid != 0) {
$data['cat_id'] = $categoryid;
$cat_title = $this->category->getTitle($categoryid);
$data['cat_title'] = $cat_title . " - Movies";
$form_subject = $cat_title;
$crud = new grocery_CRUD();
$crud->set_table('dbx_movies');
$crud->where('catid', $categoryid);
$crud->set_subject('Movie');
$crud->required_fields('title', 'year');
$crud->columns('title');
// $crud->callback_column('name',array($this,'link_title'));
// $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]');
$crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl'));
$crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl'));
$crud->fields('catid', 'title', 'year', 'release_date', 'cast', 'director', 'producer', 'music', 'writer', 'lyrics', 'synopsis', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date');
// $crud->field_type('catid', 'hidden', $categoryid);
$crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'M'), null, $categoryid);
$crud->display_as('catid', 'Category');
//
$crud->callback_add_field('cast', array($this, 'add_field_cast'));
$crud->callback_add_field('synopsis', array($this, 'add_field_synopsis'));
$crud->callback_edit_field('cast', array($this, 'edit_field_cast'));
$crud->callback_edit_field('synopsis', array($this, 'edit_field_synopsis'));
$crud->change_field_type('ownerid', 'invisible');
$crud->change_field_type('created_date', 'invisible');
$crud->change_field_type('seo_url', 'invisible');
$crud->change_field_type('lastupdate_date', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->callback_after_insert(array($this, 'after_insert'));
$crud->unset_jquery();
$state = $crud->getState();
// echo($state);
$data['state'] = $state;
$output = $crud->render($data);
$this->load->view('header_view', $data);
$this->load->view('movies_view', $output);
$this->load->view('footer_view', $data);
}
}
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 generarCobertura()
{
$tipo = array('0' => 'No Notificó', '1' => 'Notificó', '2' => 'Not. Negativa');
$crud = new grocery_CRUD();
$crud->columns('ano', 'semana', 'ndiresa', 'nred', 'nmicrored', 'nestablec', 'notificacion', 'fecha', 'hora');
$crud->set_table('cobertura');
$crud->set_subject('Proceso');
switch ($this->session->userdata('nivel')) {
case 5:
$where = array('diresa' => $this->session->userdata('diresa'));
break;
case 6:
$where = array('diresa' => $this->session->userdata('diresa'), 'red' => $this->session->userdata('red'));
break;
case 7:
$where = array('diresa' => $this->session->userdata('diresa'), 'red' => $this->session->userdata('red'), 'microred' => $this->session->userdata('microred'));
break;
default:
$this->session->set_flashdata('error', 'Este proceso no está permitido para su nivel de usuario');
redirect(site_url("backend/index/principal"), 301);
break;
}
$crud->field_type('notificacion', 'dropdown', $tipo);
$crud->display_as('establec', 'Establecimiento');
$crud->display_as('notificacion', 'Notificación');
$crud->display_as('ndiresa', 'Diresa');
$crud->display_as('nred', 'Red');
$crud->display_as('nmicrored', 'Microred');
$crud->display_as('nestablec', 'Establecimiento');
$crud->where($where);
$crud->change_field_type('ano', 'readonly');
$crud->change_field_type('semana', 'readonly');
$crud->change_field_type('diresa', 'readonly');
$crud->change_field_type('red', 'readonly');
$crud->change_field_type('microred', 'readonly');
$crud->change_field_type('establec', 'readonly');
//$crud->unset_read();
//$crud->unset_edit();
$crud->unset_delete();
$crud->unset_print();
$crud->unset_add();
///////////////////////////////////////////////////////////////////////////////
$crud->add_action_peru('Añadir Proceso', '', 'proceso', 'add-icon');
///////////////////////////////////////////////////////////////////////////////
$output = $crud->render();
$this->_example_output1($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 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 principal($id)
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_banners_campa');
$crud->set_subject('banners_campa');
$crud->set_language('spanish');
$crud->fields('campa', 'banner');
$crud->required_fields('campa', 'banner');
$crud->set_subject('banner');
$crud->display_as('campa', 'Campaña');
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$crud->where('campa', $id);
$crud->set_relation('campa', 'tp_campa', 'nombre');
$crud->set_field_upload('banner', 'archivos/banners');
$crud->callback_after_upload(array($this, 'obtener_imagen_upload'));
$output = $crud->render();
$data['opcion'] = 'campa';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$data['opcion_campa'] = 'banners_campa';
$nombre_campa = "";
$campas = $this->modelo->obtener_nombre_campa($id);
foreach ($campas->result() as $fila) {
$nombre_campa = $fila->nombre;
}
$data['nombre_campa'] = $nombre_campa;
$this->load->view('opciones_campa', $data);
$data['nuevo_banner'] = '';
$data['id'] = $id;
$this->load->view('opciones_banner_imagen_otros', $data);
$this->load->view('campa', $output);
$this->load->view('regresar');
$this->load->view('pie');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
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 index($categoryid = 0)
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$data['lo'] = 1;
//value used to identify section movie or celebrity
if ($categoryid != 0) {
$data['cat_id'] = $categoryid;
$cat_title = $this->category->getTitle($categoryid);
$data['cat_title'] = $cat_title . " ";
$form_subject = $cat_title;
$crud = new grocery_CRUD();
$crud->set_table('dbx_celebrities');
$crud->where('catid', $categoryid);
$crud->set_subject($form_subject);
$crud->required_fields('name');
$crud->columns('name');
// $crud->callback_column('name',array($this,'link_title'));
// $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]');
$crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl'));
$crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl'));
$crud->fields('catid', 'name', 'alt_name1', 'alt_name2', 'alt_name3', 'alt_name4', 'title', 'desc', 'sign', 'birth_date', 'birth_place', 'first_film', 'awards', 'height', 'weight', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date');
// $crud->field_type('catid', 'hidden', $categoryid);
$crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'C'), null, $categoryid);
$crud->display_as('catid', 'Category');
$crud->callback_add_field('desc', array($this, 'add_field_desc'));
$crud->callback_add_field('awards', array($this, 'add_field_awards'));
$crud->callback_edit_field('desc', array($this, 'edit_field_desc'));
$crud->callback_edit_field('awards', array($this, 'edit_field_awards'));
$crud->field_type('sign', 'dropdown', array('Aries' => 'Aries', 'Taurus' => 'Taurus', 'Gemini1' => 'Gemini', 'Cancer' => 'Cancer', 'Leo' => 'Leo', 'Virgo' => 'Virgo', 'Libra' => 'Libra', 'Scorpio' => 'Scorpio', 'Sagittarius' => 'Sagittarius', 'Capricorn' => 'Capricorn', 'Aquarius' => 'Aquarius', 'Pisces' => 'Pisces'));
$crud->change_field_type('ownerid', 'invisible');
$crud->change_field_type('created_date', 'invisible');
$crud->change_field_type('seo_url', 'invisible');
$crud->change_field_type('lastupdate_date', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->unset_jquery();
$output = $crud->render($data);
$this->load->view('header_view', $data);
$this->load->view('celebrities_view', $output);
$this->load->view('footer_view', $data);
}
}
function principal()
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_logos');
$crud->set_subject('logo');
$crud->set_language('spanish');
$crud->fields('logo_gobierno', 'vinculacion_logo_gobierno', 'logo_opcional', 'vinculacion_logo_opcional');
$crud->display_as('logo_gobierno', 'Logotipo principal');
$crud->display_as('vinculacion_logo_gobierno', 'Vínculo del logotipo principal');
$crud->display_as('logo_opcional', 'Logotipo secundario (opcional)');
$crud->display_as('vinculacion_logo_opcional', 'Vínculo del logotipo secundario');
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$crud->unset_delete();
$crud->unset_list();
$crud->where('id_logo', 1);
$crud->set_field_upload('logo_gobierno', 'archivos/logos');
$crud->set_field_upload('logo_opcional', 'archivos/logos');
$crud->callback_after_upload(array($this, 'obtener_imagen_upload'));
$crud->callback_after_update(array($this, 'redireccionar'));
$output = $crud->render();
$data['opcion'] = '';
$data['cambiar_logos'] = '';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$this->load->view('nuevos_logos', $output);
$this->load->view('pie');
} catch (Exception $e) {
if ($e->getCode() == 14) {
redirect('medios/principal');
} else {
show_error($e->getMessage());
}
}
}
function principal($id)
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_desglose_presupuesto');
$crud->set_subject('Desglose');
$crud->set_language('spanish');
$crud->fields('id_desglose_presupuesto', 'presupuesto', 'id_concepto', 'concepto', 'cantidad', 'porcentaje');
$crud->columns('id_concepto', 'concepto', 'cantidad', 'porcentaje');
$crud->display_as('id_concepto', 'Clave del concepto');
$crud->required_fields('id_concepto', 'concepto', 'cantidad');
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$crud->edit_fields('id_concepto', 'concepto', 'cantidad');
$crud->where('presupuesto', $id);
$crud->callback_after_update(array($this, 'actualizar_porcentaje'));
$crud->callback_column('cantidad', array($this, 'formato_dinero'));
$output = $crud->render();
$data['opcion'] = 'presupuesto';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$data['opcion_presupuesto'] = 'desglose';
$this->load->view('opciones_presupuesto', $data);
$data['nuevo_desglose'] = '';
$data['id'] = $id;
$this->load->view('opciones_banner_imagen_otros', $data);
//$data['output'] = $output;
//$data['opcion_medios'] = 'ver_todos';
$this->load->view('presupuesto', $output);
$this->load->view('regresar');
$this->load->view('pie');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function kids_window($id)
{
$this->id_femme = $id;
try {
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->where('id_femme', $id);
$crud->set_table('sos_kids');
$crud->set_subject('Enfant(s)');
$crud->unset_edit_fields('id_kid');
$crud->unset_add_fields('id_kid');
$crud->field_type('id_femme', 'hidden', $this->id_femme);
$crud->columns('prenom', 'nom', 'age', 'sex', 'commentaire');
$crud->display_as('prenom', 'Prénom');
$crud->display_as('sex', 'Sexe');
$crud->display_as('commentaire', 'Commentaires');
$crud->set_relation('age', 'sos_gen_kids_age', 'name_kids_age');
if (!$this->session->userdata('status')) {
$crud->unset_export();
$crud->unset_print();
}
$crud->callback_after_update(array($this, 'after_update'));
$crud->callback_after_insert(array($this, 'insert_after'));
$crud->field_type('sex', 'enum', array('Fille', 'Garçon'));
$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 crud()
{
$crud = new grocery_CRUD();
$crud->set_theme(THEMA_CRUD);
$crud->set_table('cliente');
$crud->set_subject('Cliente');
$crud->where('situacao_id', 2);
//apenas ativos
$crud->required_fields('nome', 'documento', 'nascimento', 'situacao_id');
$crud->columns('nome', 'documento', 'nascimento');
$crud->edit_fields('nome', 'documento', 'nascimento', 'situacao_id');
$crud->add_fields('nome', 'documento', 'nascimento');
//relacionamentos
$crud->set_relation('situacao_id', 'situacao', 'descricao');
$crud->callback_insert(array($this, 'create'));
$crud->callback_delete(array($this, 'delete'));
$contents = $crud->render();
$this->template->set('titulo', 'Manter Cliente');
$this->template->set('subtitle', 'Cliente');
$this->template->load('template_teste', 'crudpage', $contents);
}
/**
* function ni digunakan untuk kv urus maklumat kursus kolej pada crud
* input: -
* author: Mior Mohd Hanif
* Date: 28 Jun 2013
* Modification Log: 4 Julai 2013 by Mior - fixed bug insert
* 18 Julai 2013 by Mior - fixed bug before insert and update
*/
function college_course_management()
{
$user_login = $this->ion_auth->user()->row();
$col_id = $user_login->col_id;
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_subject('Kursus Kolej');
$crud->set_table('college_course');
$crud->set_relation('cou_id', 'course', '{cou_course_code} - {cou_name}');
$crud->columns('cou_course_code', 'cou_name', 'cou_cluster');
$crud->callback_column('cou_course_code', array($this, '_callback_cou_course_code'));
$crud->callback_column('cou_name', array($this, '_callback_cou_name'));
$crud->callback_column('cou_cluster', array($this, '_callback_cou_cluster'));
$crud->display_as('cou_id', 'Kursus')->display_as('cou_course_code', 'Kod Kursus')->display_as('cou_name', 'Nama Kursus')->display_as('cou_cluster', 'Kluster');
$crud->required_fields('cou_id');
$crud->field_type('col_id', 'invisible');
$crud->callback_before_insert(array($this, 'callback_col_id'));
$crud->callback_before_update(array($this, 'callback_col_id'));
$crud->where('col_id', $col_id);
$output = $crud->render();
$header = "<legend><h4>Penyelenggaraan Kursus Kolej</h4></legend>";
$this->_main_output($output, $header);
}
public function crud()
{
$crud = new grocery_CRUD();
$crud->set_theme(THEMA_CRUD);
$crud->set_table('usuario');
$crud->set_subject('Usuarios');
$crud->required_fields('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id');
$crud->columns('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id');
$crud->edit_fields('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id');
$crud->add_fields('nome', 'login', 'email', 'tipo_usuario_id');
$crud->set_relation('tipo_usuario_id', 'tipo_usuario', 'descricao');
$crud->set_relation('situacao_id', 'situacao', 'descricao');
$crud->callback_insert(array($this, 'create'));
$crud->callback_delete(array($this, 'delete'));
$crud->callback_update(array($this, 'update'));
$crud->where('situacao_id', 1);
$crud->or_where('situacao_id', 2);
$contents = $crud->render();
// $this->load->view('template_crud', $contents);
$this->template->set('titulo', 'Manter Usuário');
$this->template->set('subtitle', 'Usuário');
// nome do template , nome da view
$this->template->load('template_teste', 'crudpage', $contents);
}
public function category($action = null, $id_product_category = null)
{
$this->session->set_userdata('selected_table', 'product_category');
$crud = new grocery_CRUD();
if (!empty($id_product_category) && is_numeric($id_product_category) && $action == 'parent') {
$crud->where('parent', $id_product_category)->unset_add()->unset_edit()->unset_delete();
} else {
$crud->add_action('Lihat Sub Produk Kategori', '', '', 'read-icon', array($this, 'addSubCategoryAction'));
}
$crud->set_table('product_category')->columns('category', 'parent', 'note')->fields('category', 'parent', 'note')->required_fields('category')->display_as('category', 'Nama Kategori')->display_as('parent', 'Parent Kategori')->display_as('note', 'Keterangan')->callback_field('note', array($this, 'setTextarea'))->callback_field('parent', array($this, 'categoryParentField'))->callback_column('parent', array($this, 'categoryParentName'))->unset_read()->unset_delete();
$output = $crud->render();
$this->parser->parse('category.tpl', $output);
}
