private function get_crud()
{
$this->data['message'] = $this->session->flashdata('message');
$crud = new grocery_CRUD();
$crud->set_theme(GROCERY_CRUD_THEME);
$crud->set_table('usuario');
$crud->set_subject('Usuário');
$crud->unset_columns('id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3', 'ultima_troca', 'cadastro');
$crud->fields('id', 'nome', 'login', 'email', 'grupos', 'tipo_usuario_id', 'situacao_usuario_id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3');
$crud->unset_texteditor('id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3', 'ultima_troca', 'cadastro');
$crud->change_field_type('id', 'invisible');
$crud->change_field_type('senha', 'invisible');
$crud->change_field_type('senha_anterior1', 'invisible');
$crud->change_field_type('senha_anterior2', 'invisible');
$crud->change_field_type('senha_anterior3', 'invisible');
$crud->set_relation('situacao_usuario_id', 'situacao_usuario', 'descricao');
$crud->display_as('situacao_usuario_id', 'Situacao');
$crud->set_relation('tipo_usuario_id', 'tipo_usuario', 'descricao');
$crud->display_as('tipo_usuario_id', 'Tipo de Usuário');
$crud->set_relation_n_n('grupos', 'grupo_usuario_x_usuario', 'grupo_usuario', 'usuario_id', 'grupo_usuario_id', 'descricao');
/* regras e campos obrigatórios */
$crud->required_fields('login', 'grupos', 'tipo_usuario_id', 'situacao_usuario_id');
$crud->set_rules('login', 'Login', 'required|min_length[2]');
$crud->set_rules('grupos', 'Grupos', 'required');
$crud->set_rules('tipo_usuario_id', 'Tipo de Usuário', 'required');
$crud->set_rules('situacao_usuario_id', 'Situação do Usuário', 'required');
$crud->callback_before_insert(array($this, 'checking_new_user'));
return $crud->render();
}
public function 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);
}
/**
* function ni digunakan untuk kv urus maklumat pengguna pada crud
* input: -
* author: Mior Mohd Hanif
* Date: 28 Jun 2013
* Modification Log:
*/
function user_management()
{
$user_login = $this->ion_auth->user()->row();
$col_id = $user_login->col_id;
$crud = new grocery_CRUD();
$crud->where('user.col_id', $col_id);
$crud->set_theme('flexigrid');
$crud->set_subject('Pengguna');
$crud->set_table('user');
$crud->display_as('user_name', 'Nama Pengguna')->display_as('user_username', 'Katanama')->display_as('user_password', 'Katalaluan')->display_as('user_email', 'Email')->display_as('col_id', 'Kolej')->display_as('created_on', 'Tarikh Daftar')->display_as('last_login', 'Tarikh Log Masuk')->display_as('active', 'Status')->display_as('phone', 'No. Telefon');
$crud->set_relation('col_id', 'college', 'col_name');
$crud->required_fields('user_name', 'user_username', 'user_password', 'user_email', 'active', 'phone');
$crud->set_rules('user_username', 'Katanama', 'trim|required');
$crud->set_rules('phone', 'No. Telefon', 'trim|required|numeric');
$crud->set_rules('user_email', 'Email', 'trim|required|valid_email');
$crud->unset_columns('ip_address', 'user_password', 'salt', 'activation_code', 'forgotten_password_code', 'forgotten_password_time', 'remember_code');
$crud->unset_fields('ip_address', 'activation_code', 'forgotten_password_code', 'forgotten_password_time', 'remember_code', 'last_login');
$crud->change_field_type('user_password', 'password');
$crud->change_field_type('created_on', 'invisible');
$crud->change_field_type('salt', 'invisible');
$crud->change_field_type('col_id', 'invisible');
$crud->callback_before_insert(array($this, 'callback_for_time_and_encrypt_password'));
$crud->callback_column('created_on', array($this, 'strtotime_convert_to_date'));
$crud->callback_column('last_login', array($this, 'strtotime_convert_to_date'));
$output = $crud->render();
$header = "<legend><h4>Penyelenggaraan Pengguna</h4></legend>";
$this->_main_output($output, $header);
}
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('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);
}
private function master()
{
$crud = new grocery_CRUD();
$crud->set_table('contents');
$crud->unset_columns('jenis', 'slug', 'isi');
$crud->callback_before_insert(array($this, "_timestamp"));
$crud->callback_before_update(array($this, "_timestamp"));
$crud->unset_export();
$crud->unset_print();
$crud->unset_read();
$crud->change_field_type('jenis', 'invisible');
$crud->change_field_type('slug', 'invisible');
$crud->change_field_type('created_at', 'invisible');
$crud->change_field_type('updated_at', 'invisible');
return $crud;
}
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 salacontrol()
{
try {
$crud = new grocery_CRUD();
//$crud->set_theme('datatables');
$crud->set_table('salas');
$crud->set_subject('Sala');
$crud->required_fields('campus', 'numero', 'tipo', 'capacidade');
$crud->display_as('campus', 'Campus');
$crud->display_as('numero', 'Número da Sala');
$crud->display_as('cidadeID', 'Campus');
$crud->unset_columns('disponibilidade');
$crud->unset_add_fields('disponibilidade');
$crud->set_relation('campus', 'cidades', 'nome');
$crud->set_relation('tipo', 'tipos', 'nome');
//$crud->set_rules('numero', 'Número da Sala', 'Integer');
$crud->change_field_type('disponibilidade', 'true_false');
$output = $crud->render();
$this->_sala_output($output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
private function get_crud()
{
$this->data['message'] = $this->session->flashdata('message');
$crud = new grocery_CRUD();
$crud->set_theme(GROCERY_CRUD_THEME);
$crud->set_table('insumo');
$crud->set_subject('Insumo');
$crud->unset_columns('id');
$crud->fields('id', 'codigo', 'descricao', 'tipo_insumo_id', 'tipo_unidade_id', 'origem_insumo_id');
$crud->display_as('codigo', 'Código');
$crud->display_as('descricao', 'Descrição');
$crud->display_as('tipo_insumo_id', 'Tipo');
$crud->display_as('tipo_unidade_id', 'Unidade');
$crud->display_as('origem_insumo_id', 'Origem');
$crud->change_field_type('id', 'invisible');
/* relacionamentos */
$crud->set_relation('tipo_insumo_id', 'tipo_insumo', 'descricao');
$crud->set_relation('tipo_unidade_id', 'tipo_unidade', 'sigla');
$crud->set_relation('origem_insumo_id', 'origem_insumo', 'descricao');
/* regras e campos obrigatórios */
$crud->required_fields('descricao');
$crud->set_rules('descricao', 'Descrição', 'required|min_length[3]');
return $crud->render();
}
private function get_crud()
{
$this->data['message'] = $this->session->flashdata('message');
$crud = new grocery_CRUD();
$crud->set_theme(GROCERY_CRUD_THEME);
$crud->set_table('fornecedor');
$crud->set_subject('Fornecedor');
$crud->unset_columns('id');
$crud->fields('id', 'codigo', 'nome', 'cnpj', 'inscricao_estadual', 'tipo_fornecedor_id');
$crud->unset_texteditor('id');
$crud->change_field_type('id', 'invisible');
/* relacionamentos */
$crud->set_relation('tipo_fornecedor_id', 'tipo_fornecedor', 'descricao');
/* descrição dos campos de relacionamento */
$crud->display_as('tipo_fornecedor_id', 'Tipo de Fornecedor');
/* regras e campos obrigatórios */
$crud->required_fields('nome');
$crud->required_fields('codigo');
$crud->required_fields('tipo_fornecedor_id');
$crud->set_rules('nome', 'Nome', 'required|min_length[3]');
$crud->set_rules('codigo', 'Código', 'required|min_length[3]');
$crud->set_rules('tipo_fornecedor_id', 'Tipo de Fornecedor', 'required');
return $crud->render();
}
public function Perfil()
{
$crud = new grocery_CRUD();
$crud->set_table('tblusuario');
$crud->set_subject('Perfiles');
$crud->unset_columns('usuario', 'pass', 'correo');
//$crud->callback_column('buyPrice',array($this,'valueToEuro'));
$output = $crud->render();
$this->_Servicios_view($output);
}
function film_management()
{
$crud = new grocery_CRUD();
$crud->set_table('film');
$crud->set_relation_n_n('actors', 'film_actor', 'actor', 'film_id', 'actor_id', 'fullname', 'priority');
$crud->set_relation_n_n('category', 'film_category', 'category', 'film_id', 'category_id', 'name');
$crud->unset_columns('special_features', 'description');
$crud->fields('title', 'description', 'actors', 'category', 'release_year', 'rental_duration', 'rental_rate', 'length', 'replacement_cost', 'rating', 'special_features');
$output = $crud->render();
$this->_example_output($output);
}
public function ops($page = 'crud_view')
{
$data['title'] = "AA Planetica";
$data['activepage'] = "Clients Page";
if (!$this->ion_auth->logged_in()) {
// redirect them to the login page
$this->session->set_userdata('last_page', current_url());
redirect('users/admin/login', 'refresh');
//echo "Redirect to Login";
} elseif ($this->ion_auth->is_admin()) {
$this->data['message'] = validation_errors() ? validation_errors() : $this->session->flashdata('message');
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('siteinfo');
$crud->set_subject('Site Info');
//$crud->columns('lastName','firstName','email','jobTitle');
$crud->unset_columns('id');
$crud->unset_fields('id', 'userid', 'date');
$crud->field_type('description', 'text');
$crud->field_type('name', 'string');
$crud->display_as('userid', 'User ID');
$crud->unset_delete();
$crud->field_type('status', 'dropdown', array('1' => 'New', '2' => 'Current', '3' => 'Done'));
//$crud->callback_column('buyPrice',array($this,'valueToEuro'));
$this->data['output'] = $crud->render();
$this->load->view('aries_admin/apps/crud_view', $this->data);
//var_dump($this->data['test']);
//$this->load->view('aries_admin/apps/'.$page, $this->data);
} else {
$this->data['message'] = validation_errors() ? validation_errors() : $this->session->flashdata('message');
//echo "Rest of the work as an Admin";
$data = $this->yapps_model->client_passport_check('AB12345684');
if ($data == 'true') {
var_dump($this->sms);
return show_error('Duplicate Accounts, Search in the Clients Section');
}
if (isset($this->sms)) {
echo $this->sms['msg'] . '</br>' . $this->sms['error'];
}
}
}
function toppers_ans_booklets()
{
$expertid = $this->tank_auth->get_user_id();
$TAB_HOME = "visionias_data/assets/home/resources/toppers_ans_booklets";
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('toppers_ans_booklets');
$crud->columns('name', 'rank', 'notification_year', 'res_loc', 'subject_id', 'test_id');
$crud->display_as('res_loc', 'Choose File');
$crud->display_as('subject_id', 'Subject');
$crud->display_as('notification_year', 'CSE Year');
$crud->unset_columns('created_by', 'time_of_creation');
$crud->set_subject("Toppers' Answer Booklets");
$crud->set_relation('subject_id', 'subjects', '{subject_id}-{subject_name}');
$crud->field_type('created_by', 'hidden', $expertid);
$crud->field_type('view_count', 'hidden');
$crud->field_type('time_of_creation', 'hidden', date('Y-m-d H:i:s'));
$crud->set_field_upload('res_loc', "{$TAB_HOME}");
$crud->callback_before_insert(array($this, 'move_resource_file'));
$output = $crud->render();
$this->_example_output($output);
}
public function film_management()
{
$crud = new grocery_CRUD();
$crud->set_table('film');
$crud->set_relation_n_n('actors', 'film_actor', 'actor', 'film_id', 'actor_id', 'fullname', 'priority');
$crud->set_relation_n_n('category', 'film_category', 'category', 'film_id', 'category_id', 'name');
$crud->unset_columns('special_features', 'description', 'actors', 'release_year', 'rental_duration', 'rental_rate', 'replacement_cost');
$crud->fields('title', 'description', 'actors', 'category', 'release_year', 'rental_duration', 'rental_rate', 'length', 'replacement_cost', 'rating', 'special_features');
$crud->set_theme('flexigrid');
$output = $crud->render();
$data['judul'] = 'Films';
$data['crumb'] = array('Films' => '');
$template = 'admin_template';
$view = 'grocery';
$this->outputview->output_admin($view, $template, $data, $output);
}
public function priority2()
{
$data['metad'] = "";
$data['metak'] = "";
$data['title'] = 'Priority2';
$this->load->library('Grocery_CRUD');
$crud = new grocery_CRUD();
$crud->set_table('precedence2');
$crud->set_subject('precedence2_table');
$crud->set_relation('question_id', 'questions', '{question_id}-{question_name}');
$crud->unset_columns('questionnaire_id');
$crud->display_as('pj1', 'Column 1 precedence(Pipj1)');
$crud->display_as('pj2', 'Column 2 precedence(Pipj2)');
$crud->display_as('pj3', 'Column 3 precedence(Pipj3)');
$crud->display_as('pj4', 'Column 4 precedence(Pipj4)');
$crud->display_as('pj5', 'Column 5 precedence(Pipj5)');
$crud->unset_add()->unset_edit()->unset_delete()->unset_read();
$data['output'] = $crud->render();
$data['view'] = 'front/priorities';
$this->load->view('front/index', $data);
}
function main()
{
$user_login = $this->ion_auth->user()->row();
$colid = $user_login->col_id;
$userId = $user_login->user_id;
$state_id = $user_login->state_id;
$user_groups = $this->ion_auth->get_users_groups($userId)->row();
$ul_type = $user_groups->ul_type;
$user_id = $this->session->userdata('user_id');
$crud = new grocery_CRUD();
$crud->set_table('announcement');
$crud->set_subject('pengumuman');
$crud->unset_delete();
$crud->callback_delete(array($this, 'delete_ann'));
$crud->unset_columns('ann_status_push');
if ($ul_type == 'KV') {
$crud->set_primary_key('ann_id', 'announcement_college');
$crud->set_relation('user_id', 'user', 'user_name');
$crud->set_relation('ann_id', 'announcement_college', 'col_id');
$crud->set_relation_n_n('Kolej', 'announcement_college', 'college', 'ann_id', 'col_id', 'col_name');
// $crud->callback_add_field('Kolej',array($this,'add_field_kolej'));
$crud->callback_after_insert(array($this, 'insert_announcement_college'));
$crud->field_type('ann_open_date', 'date');
$crud->field_type('ann_close_date', 'date');
$crud->field_type('user_id', 'hidden', $userId);
$crud->field_type('ann_status_push', 'hidden', 1);
$crud->field_type('ann_status', 'dropdown', array('1' => 'Aktif', '0' => 'Tak Aktif'));
$crud->display_as('ann_title', 'Perkara')->display_as('ann_id', 'Id')->display_as('ann_content', 'Pengumuman')->display_as('ann_open_date', 'Tarikh Mula')->display_as('ann_close_date', 'Tarikh Akhir')->display_as('ann_status', 'Status Pengumuman')->display_as('user_id', 'Pengguna')->display_as('college', 'Kolej Vokasional');
// $crud->callback_field('ann_title',array($this,'fc_ann_tite')); - FDP
// $crud->callback_field('ann_content',array($this,'fc_ann_content')); - FDP
// $crud->callback_field('ann_open_date',array($this,'fc_ann_open_date')); - FDP
// $crud->callback_field('ann_close_date',array($this,'fc_ann_close_date')); - FDP
// $crud->callback_field('ann_status',array($this,'fc_ann_status')); - FDP
// $crud->callback_field('college',array($this,'fc_college')); - FDP
$crud->where('j7f822d59.col_id', $colid);
$crud->unset_fields('Kolej');
$crud->required_fields('ann_title', 'ann_content', 'ann_open_date', 'ann_close_date', 'ann_status');
} elseif ($ul_type == 'LP') {
$crud->set_relation('user_id', 'user', 'user_name');
$crud->set_relation_n_n('Kolej', 'announcement_college', 'college', 'ann_id', 'col_id', 'col_name');
$crud->callback_after_insert(array($this, 'insert_announcement_college'));
$crud->field_type('ann_open_date', 'date');
$crud->field_type('ann_close_date', 'date');
$crud->field_type('user_id', 'hidden', $user_id);
$crud->field_type('ann_status_push', 'hidden', 1);
$crud->field_type('ann_status', 'dropdown', array('1' => 'Aktif', '0' => 'Tak Aktif'));
$crud->display_as('ann_title', 'Perkara')->display_as('ann_content', 'Pengumuman')->display_as('ann_open_date', 'Tarikh Mula')->display_as('ann_close_date', 'Tarikh Akhir')->display_as('ann_status', 'Status Pengumuman')->display_as('user_id', 'Pengguna')->display_as('college', 'Kolej Vokasional');
// $crud->callback_field('ann_title',array($this,'fc_ann_tite')); - FDP
// $crud->callback_field('ann_content',array($this,'fc_ann_content')); - FDP
// $crud->callback_field('ann_open_date',array($this,'fc_ann_open_date')); - FDP
// $crud->callback_field('ann_close_date',array($this,'fc_ann_close_date')); - FDP
// $crud->callback_field('ann_status',array($this,'fc_ann_status')); - FDP
// $crud->callback_field('college',array($this,'fc_college')); - FDP
$crud->required_fields('ann_title', 'ann_content', 'ann_open_date', 'ann_close_date', 'ann_status');
}
$output = $crud->render();
$js = '<script>$(document).ready(function()
{
$("#addStudent").validationEngine();
});</script>';
$header = $js . "<legend><h3>Penyenggaraan Pengumuman</h3></legend>";
$this->_main_output($output, $header);
}
public function room_residents($primary_key)
{
$crud = new grocery_CRUD();
$crud->where('room_resident.room_id', $primary_key);
$crud->set_subject('Resident');
$crud->set_table('room_resident');
$crud->set_relation('room_id', 'room', '{room_name}');
$crud->set_relation('resident_id', 'resident', '{resident_othernames} {resident_surname}');
$crud->required_fields('resident_id');
$crud->unset_columns('room_resident_priority');
$crud->unset_fields('room_resident_date', 'room_resident_priority', 'room_resident_status', 'room_resident_date_released');
$crud->display_as('room_resident_date', 'Date Added');
$crud->display_as('room_resident_date_released', 'Date Released');
$crud->display_as('resident_id', 'Resident');
$crud->display_as('room_id', 'Room');
$crud->display_as('room_resident_status', 'Status');
$crud->callback_column('room_resident_status', array($this, 'callback_status'));
//$crud->add_action('Residents', base_url().'img/icons/icon-48-groups-add.png', 'front_office/room_details/'.$_SESSION['navigation_id'].'/'.$_SESSION['sub_navigation_id']);
$crud->callback_insert(array($this, 'check_room_capacity'));
$crud->field_type('room_id', 'hidden', $primary_key);
$crud->unset_edit();
$output = $crud->render();
$this->_example_output3($output);
}
public function crud_test($page = 'crud_view')
{
$data['title'] = "AA Planetica";
$data['activepage'] = "Clients Page";
if (!$this->ion_auth->logged_in()) {
// redirect them to the login page
$this->session->set_userdata('last_page', current_url());
redirect('users/admin/login', 'refresh');
//echo "Redirect to Login";
} elseif ($this->ion_auth->is_admin()) {
$this->data['message'] = validation_errors() ? validation_errors() : $this->session->flashdata('message');
$crud = new grocery_CRUD();
$crud->set_table('payments');
$crud->set_subject('Payment');
$crud->unset_columns('payname');
//$crud->callback_column('buyPrice',array($this,'valueToEuro'));
$this->data['output'] = $crud->render();
$this->load->view('aries_admin/apps/crud_view', $this->data);
//var_dump($this->data['test']);
//$this->load->view('aries_admin/apps/'.$page, $this->data);
} else {
$this->data['message'] = validation_errors() ? validation_errors() : $this->session->flashdata('message');
//echo "Rest of the work as an Admin";
$data = $this->yapps_model->client_passport_check('AB12345684');
if ($data == 'true') {
var_dump($this->sms);
return show_error('Duplicate Accounts, Search in the Clients Section');
}
if (isset($this->sms)) {
echo $this->sms['msg'] . '</br>' . $this->sms['error'];
}
}
}
public function sub_Category()
{
$crud = new grocery_CRUD('default');
$crud->set_table('subcategories_master');
$crud->set_subject('SubCategory');
$crud->display_as('category', 'SubCategory')->display_as('category_id', 'Select Category');
$crud->unset_add_fields('flag', 'created_date');
$crud->unset_edit_fields('flag', 'created_date');
$crud->callback_before_insert(array($this, 'callback_getmax_app_cat_id'));
$crud->unset_columns('applicable_category_id', 'flag', 'created_date');
$crud->set_relation('category_id', 'categories_master', 'category');
$crud->field_type('applicable_category_id', 'invisible');
//$crud->unset_add();
//$crud->unset_edit();
//$crud->unset_delete();
$data = $crud->render();
$this->load->view('admin/crud_view', $data);
}
/**
* Description of vzool_nested_crud
*
// Made to handle nested structure of tables
// something like for Country -> City -> Municipality -> Neighborhood -> Place
// USAGE:
$args = func_get_args() [Static]
$map = [
"TABEL_NAME" => [
"ref" => "FK_FIELD",
"link_column" => "COLUMN_NAME_LINK_ASSOCIATIVE",
"set_subject" => "SUBJECT_NAME",
"next_depth" => "SUB_TABLE_NAME",
],
];
$base_table => Start point similar to `Country`
$function_name = strtolower(__CLASS__ .'/'. __FUNCTION__) [Static]
*
*/
public function vzool_nested_crud($args, $map, $base_table, $class_ref_name, $class_function_ref_name)
{
/*##########################################################*/
/*##################### DEEP LOGIC #########################*/
/*##########################################################*/
$function_name = strtolower("{$class_ref_name}/{$class_function_ref_name}");
$is_debug = false;
$debug_stack = [];
$debug_stack['trace'] = [];
$current_table = $base_table;
$base_url = current_url();
$html_links = '';
$is_ajax = false;
$functions = ['add', 'delete', 'read', 'print', 'export', 'insert_validation', 'insert', 'delete', 'update', 'ajax_list_info', 'ajax_list'];
$ignore = ["created_date", "modified_date"];
$parent_id = null;
$last_parent_id = null;
$args_count = sizeof($args);
if (strpos($base_url, 'ajax_list')) {
$is_ajax = true;
}
if ($args) {
$ignore = array_merge($args, $ignore);
$last_section = $args[$args_count - 1];
if (in_array($last_section, $functions)) {
if ($args_count > 1) {
$last_section = $args[$args_count - 2];
} else {
$last_section = $base_table;
}
if ($is_debug) {
echo "<h3>IF #1</h3>";
}
} elseif (strpos($base_url, 'delete_file')) {
$tmp = explode("/delete_file", $base_url);
$tmp = explode("/", $tmp[0]);
$last_section = end($tmp);
if ($is_debug) {
echo "<h3>IF #4</h3>";
}
} elseif (strpos($base_url, 'edit') || strpos($base_url, 'update_validation') || strpos($base_url, 'update') || strpos($base_url, 'delete')) {
if ($args_count > 2) {
$last_section = $args[$args_count - 3];
} else {
$last_section = $base_table;
}
if ($is_debug) {
echo "<h3>IF #2</h3>";
}
} elseif (strpos($base_url, 'upload_file')) {
$tmp = explode("/upload_file", $base_url);
$tmp = explode("/", $tmp[0]);
$last_section = end($tmp);
if ($is_debug) {
echo "<h3>IF #3</h3>";
}
}
$current_table = $last_section;
}
$uri_segments = explode("/", $base_url);
if (is_numeric($current_table)) {
array_pop($uri_segments);
array_pop($uri_segments);
$new_url = join("/", $uri_segments);
redirect($new_url);
}
$url_base_rule = '/index/' . $base_table;
if (!in_array($base_table, $uri_segments)) {
if (end($uri_segments) === strtolower($class_ref_name)) {
$base_url .= $url_base_rule;
} else {
$base_url .= '/' . $base_table;
}
redirect($base_url);
} else {
if (end($uri_segments) === strtolower($class_ref_name) && !strpos($base_url, $url_base_rule)) {
$base_url .= $url_base_rule;
redirect($base_url);
}
}
/* ------------------------ BUILD LINKS ------------------------ */
$links_table = array();
$links_ref_id = array();
foreach ($args as $k => $v) {
if ($k % 2 == 0) {
$links_table[] = $v;
} else {
$links_ref_id[] = $v;
}
}
if ($links_table) {
unset($links_table[sizeof($links_table) - 1]);
}
$links_ref_map = [];
if ($links_table && $links_ref_id) {
$long_url = '';
$ci =& get_instance();
foreach ($links_table as $k => $v) {
$query = $ci->db->get_where($links_table[$k], array('id' => $links_ref_id[$k]), 1);
foreach ($query->result() as $f) {
if (!$long_url) {
$long_url .= '/' . $links_table[$k];
} else {
$long_url .= '/' . $last_parent_id . '/' . $links_table[$k];
}
$links_ref_map[$links_table[$k]] = ['id' => $links_ref_id[$k], 'url' => base_url($function_name . $long_url)];
if (isset($map[$links_table[$k]]['link_column'])) {
$link = $map[$links_table[$k]]['link_column'];
if (isset($f->{$link})) {
$links_ref_map[$links_table[$k]]['name'] = $f->{$link};
}
}
}
$last_parent_id = $links_ref_id[$k];
}
}
if ($links_ref_map) {
$html_links .= "<ul class='links'>";
foreach ($links_ref_map as $link) {
$html_links .= "<li><a href='{$link['url']}'>{$link['name']}</a></li>";
}
$html_links .= "</ul>";
}
/* ------------------------ BUILD LINKS ------------------------ */
/* ------------------------ DEBUG SPOT ------------------------ */
if ($is_debug) {
$debug_stack['info'] = ['URL' => $base_url, 'BASE_TABLE' => $base_table, 'CURRENT_TABLE' => $current_table, 'AJAX' => $is_ajax ? 'YES' : 'NO', 'parent' => ['id' => $parent_id, 'last_id' => $last_parent_id], 'args' => $args, 'LINKS' => [$links_table, $links_ref_id, $links_ref_map, $html_links]];
if (isset($map[$current_table])) {
$debug_stack['info']['SUBJECT'] = $map[$current_table]['set_subject'];
}
}
/* ------------------------ DEBUG SPOT ------------------------ */
$crud = new grocery_CRUD();
$crud->set_table($current_table);
if (in_array($current_table, array_keys($map))) {
if ($map[$current_table]['ref']) {
$parent_id = $args[sizeof($args) - 3];
$col = $map[$current_table]['ref'];
$ref_id = $args[sizeof($args) - 2];
if ($is_ajax) {
$ref_id = $args[sizeof($args) - 3];
}
$debug_stack['trace']['parent_id'] = $parent_id;
$debug_stack['trace']['where'] = [$col, $ref_id];
$crud->where($col, $ref_id);
$ignore[] = $map[$current_table]['ref'];
}
// Column CallBack
if ($map[$current_table]['link_column']) {
$crud->callback_column($map[$current_table]['link_column'], function () use($base_url, $map, $current_table) {
$x = func_get_args();
if ($map[$current_table]['next_depth']) {
$url = $base_url . '/' . $x[1]->id . '/' . $map[$current_table]['next_depth'];
$url = str_replace('ajax_list/', '', $url);
return "<a href='{$url}'>{$x[0]}</a>";
} else {
return $x[0];
}
});
}
// Before Insert CallBack
$crud->callback_before_insert(function ($data) use($base_url, $map, $current_table, $crud, $parent_id) {
if ($map[$current_table]['ref']) {
$data[$map[$current_table]['ref']] = $parent_id;
}
return $data;
});
}
if (isset($map[$current_table]['set_subject'])) {
$crud->set_subject($map[$current_table]['set_subject']);
}
$crud->unset_columns($ignore);
foreach ($ignore as $f) {
$crud->change_field_type($f, 'invisible');
}
$crud->current_table = $current_table;
$crud->links = $html_links;
/* ------------------------ DEBUG SPOT ------------------------ */
if ($is_debug) {
echo "<pre>";
print_r($debug_stack);
echo "</pre>";
}
/* ------------------------ DEBUG SPOT ------------------------ */
/*##########################################################*/
/*##################### DEEP LOGIC #########################*/
/*##########################################################*/
return $crud;
}
public function exclusions()
{
$crud = new grocery_CRUD();
$crud->set_table('packages_types_settings');
$crud->unset_columns('sett_type');
$crud->display_as('sett_selected', 'Set Selected ?');
$crud->display_as('sett_status', 'Status');
$crud->field_type('sett_type', 'hidden', 'texclusions');
$crud->where('sett_type', 'tamenities');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Exclusions', 'pagedesc' => 'Exclusions', 'contenttitle' => 'Tour Packages Exclusions List Records');
$this->load->view('gc_admin_wrapper', $data);
}
public function priority2()
{
$this->data['page_title'] = 'Relevant Questions with precedence';
$this->load->library('Grocery_CRUD');
$crud = new grocery_CRUD();
$crud->set_table('precedence2');
$crud->set_subject('precedence2_table');
$crud->set_relation('question_id', 'questions', '{question_id}-{question_name}');
$crud->unset_columns('questionnaire_id');
$crud->display_as('pj1', 'Column 1 precedence');
$crud->display_as('pj2', 'Column 2 precedence');
$crud->display_as('pj3', 'Column 3 precedence');
$crud->display_as('pj4', 'Column 4 precedence');
$crud->display_as('pj5', 'Column 5 precedence');
$crud->unset_add()->unset_edit()->unset_delete()->unset_read();
$this->data['output'] = $crud->render();
$this->render('admin/crud_view');
}
public function cards()
{
$crud = new grocery_CRUD('default');
$crud->set_table('card');
$crud->set_subject('Card');
$crud->set_field_upload('iss_org_logo', 'assets/uploads');
$crud->unset_columns('created_date');
$crud->unset_add_fields('created_date');
$crud->unset_edit_fields('created_date');
$data = $crud->render();
$this->load->view('admin/crud_view', $data);
}
public function index()
{
$crud = new grocery_CRUD();
$user_id = $this->ion_auth->user()->row()->id;
$crud->set_table('packages');
$crud->set_subject('Packages');
$crud->unset_fields('package_id');
$crud->unset_columns('package_id');
$crud->unset_columns('package_thingsToConsider');
$crud->unset_columns('package_weatherCondition');
$crud->unset_columns('package_itinerary');
$crud->display_as('package_weatherCondition', 'Weather Condition');
$crud->display_as('package_thingsToConsider', 'Things to consider');
$crud->display_as('package_adventureRegion', 'Adventure Region');
$crud->display_as('package_basic_price', 'Price');
$crud->display_as('package_basic_before_discount', 'Before Discount Price');
$crud->display_as('package_related', 'Related Packages');
$crud->set_field_upload('package_image', $this->upload_path);
$crud->unique_fields('package_slug');
$crud->where('package_agent', $user_id);
$crud->set_relation('package_category', 'packages_types_settings', 'sett_name', 'sett_type = "ttypes"', 'sett_id');
$crud->field_type('package_agent', 'hidden', $user_id);
$this->load->model('agents_m');
/*
* For related packages
* on add list all the packages created by the agent
* on edit, list all except own name
*/
if ($crud->getState() == 'edit') {
$hrf = $this->db->select('package_id, package_title')->get_where('packages', array('package_status' => 1, 'package_agent' => $user_id, 'package_id !=' => $crud->getStateInfo()->primary_key))->result();
} else {
$hrf = $this->db->select('package_id, package_title')->get_where('packages', array('package_status' => 1, 'package_agent' => $user_id))->result();
}
$hrf = $this->agents_m->array_from_db($hrf, 'package_id, package_title');
// 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('package_related', 'multiselect', $hrf);
$crud->callback_column('package_image', array($this, 'set_image'));
$crud->callback_read_field('package_basic_price', array($this, 'set_price'));
$crud->callback_read_field('package_basic_discount', array($this, 'set_price'));
$crud->callback_column('package_basic_price', array($this, 'set_price'));
$crud->callback_column('package_basic_discount', array($this, 'set_price'));
$crud->callback_add_field('package_basic_price', function ($value, $primary_key) {
return "USD <input id='field-package_basic_price' class='form-control' name='package_basic_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_add_field('package_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-package_basic_discount' class='form-control' name='package_basic_discount' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_edit_field('package_basic_price', function ($value, $primary_key) {
return "USD <input id='field-package_basic_price' class='form-control' name='package_basic_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_edit_field('package_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-package_basic_discount' class='form-control' name='package_basic_discount' type='text' value='{$value}' maxlength='20'>";
});
$crud->add_action('Photo Gallery', '', 'agents/packages/gallery', 'ui-icon ui-icon-image');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Packages', 'pagedesc' => 'Packages', 'contenttitle' => 'Packages List Records', 'left_menu' => 'agents_menu');
$this->load->view('gc_admin_wrapper', $data);
}
public function film_management_twitter_bootstrap()
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('twitter-bootstrap');
$crud->set_table('film');
$crud->set_relation_n_n('actors', 'film_actor', 'actor', 'film_id', 'actor_id', 'fullname', 'priority');
$crud->set_relation_n_n('category', 'film_category', 'category', 'film_id', 'category_id', 'name');
$crud->unset_columns('special_features', 'description', 'actors');
$crud->fields('title', 'description', 'actors', 'category', 'release_year', 'rental_duration', 'rental_rate', 'length', 'replacement_cost', 'rating', 'special_features');
$output = $crud->render();
$this->_example_output($output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function sub_menu_2($id_header_menu, $level_one, $level_two)
{
$crud = new grocery_CRUD();
$crud->set_table('menu');
$crud->set_subject('Sub Menu 2');
$crud->where('level_one', $level_one);
$crud->where('level_two', $level_two);
$crud->change_field_type('id_header_menu', 'invisible');
$crud->change_field_type('level_one', 'invisible');
$crud->change_field_type('level_two', 'invisible');
$crud->order_by('sort', 'ASC');
$crud->set_relation_n_n('Akses', 'groups_menu', 'groups', 'id_menu', 'id_groups', 'name');
$crud->unset_columns('level_one', 'level_two', 'icon', 'menu_id', 'id_header_menu');
$crud->unset_read();
$crud->callback_before_insert(array($this, 'call_sub_menu_2'));
$output = $crud->render();
$data['script'] = "\$('#menu-menu').addClass('active');";
$output->data = $data;
$data['judul'] = "Sub menu 2";
$data['crumb'] = array('Header menu' => 'crud/header_menu', 'Menu' => 'crud/menu/' . $id_header_menu, 'Sub menu' => 'crud/sub_menu/' . $id_header_menu . '/' . $level_one, 'Sub menu 2' => '');
$template = 'admin_template';
$view = 'grocery';
$this->outputview->output_admin($view, $template, $data, $output);
}
