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); }