/** * 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('booking_refunds'); $crud->set_subject('Booking Refund'); $crud->unset_add(); $crud->unset_delete(); // $crud->unset_columns('booking_ref_no'); $crud->unset_fields('booking_ref_no'); $crud->field_type('refund_status', 'dropdown', array('1' => 'Requested', '0' => 'Rejected', '2' => 'Refunded')); // $crud->field_type('refund_status', 'dropdown', array('1'=>'Requested', '0'=>'Rejected', '2' => 'Refunded')); // $crud->callback_column('refund_status', function($value, $primary_key){ // $status = array('1'=>'Requested', '0'=>'Rejected', '2' => 'Refunded'); // return $status[$value]; // }); $crud->field_type('item_type', 'readonly'); $crud->callback_column('item_type', function ($value, $primary_key) { return ucfirst($value); }); $crud->callback_edit_field('item_type', function ($value, $primary_key) { return ucfirst($value); }); // $crud->callback_before_update(array($this, 'modified_date_callback')); $crud->callback_column('booking_ref_no', array($this, '_show_invoice')); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Booking Refund', 'pagedesc' => 'Booking Refund', 'contenttitle' => 'Booking Refund List Records'); $this->load->view('gc_admin_wrapper', $data); }
function list_all() { $crud = new grocery_CRUD(); $crud->set_table('student'); $crud->set_subject('Student'); $crud->unset_fields('cc_id', 'stu_group'); $crud->columns('stu_name', 'stu_mykad', 'stu_matric_no', 'callback_course', 'stu_gender', 'stu_race', 'stu_religion'); $crud->callback_column('callback_course', array($this, 'fcallback_course')); $crud->display_as('callback_course', 'Course'); $output = $crud->render(); $this->_main_output($output, null); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('banner')->set_subject('Banners')->columns('imagen'); $crud->required_fields('imagen'); $crud->set_field_upload('imagen', 'assets/uploads/files'); $crud->unset_fields('fecha'); $crud->unset_print(); $output = $crud->render(); $this->_example_output($output); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('categoria')->set_subject('categoria')->columns('nombre'); $crud->required_fields('nombre'); $crud->unique_fields('nombre'); $crud->unset_texteditor('descripcion', 'full_text'); $crud->unset_fields('fecharegistro'); $crud->unset_print(); $output = $crud->render(); $this->_example_output($output); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('clientes')->set_subject('Clientes')->columns('nombre'); $crud->required_fields('nombre'); $crud->unique_fields('nombre'); $crud->unset_fields('fecharegistro'); $crud->unset_print(); $crud->set_field_upload('imagen', 'assets/uploads/files'); $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() { $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('clients'); $crud->set_subject('Clients'); $crud->unset_fields('client_id'); $crud->unset_columns('client_id'); // $crud->unset_columns('package_thingsToConsider'); // $crud->unset_columns('package_weatherCondition'); // $crud->unset_columns('package_itinerary'); // $crud->display_as('client_postcode', 'Post Code'); $crud->display_as('client_phoneNumber', 'Phone Number'); $crud->display_as('client_emailId', 'Email ID'); $crud->display_as('client_firstName', 'First Name'); $crud->display_as('client_lastName', 'Last Name'); // $crud->set_field_upload('package_image', $this->upload_path); // $crud->unique_fields('package_slug'); // // $crud->set_relation('package_agent', 'agents', '{agent_companyName}'); // // $crud->callback_column('package_image', array($this, 'set_image')); // $crud->callback_column('package_cost', array($this, 'set_price')); // // $crud->callback_add_field('package_cost', array($this, 'add_price1')); // $crud->callback_edit_field('package_cost', array($this, 'edit_price1')); // $crud->callback_column('package_status', array($this, 'set_change_status')); // $crud->unset_columns('package_status'); // $crud->add_action('change Status', '', '/change_status'); // $crud->add_action('Change Status', './assets/grocery_crud/themes/flexigrid/css/images/add.png', 'packages/change_status'); // $crud->add_action('package_status', '', '','ui-icon-image',array($this,'just_a_test')); // $crud->add_action('package_status', '', '','ui-icon-image',array($this,'just_a_test')); // $crud->set_lang_string('insert_success_message', // 'Your data has been successfully stored into the database.<br/>Please wait while you are redirecting to the list page. // <script type="text/javascript"> // window.location = "'.site_url(strtolower(__CLASS__).'/'.strtolower(__FUNCTION__)).'"; // </script> // <div style="display:none"> // ' // ); $crud->unset_add(); $crud->unset_delete(); $output = $crud->render(); $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Clients', 'pagedesc' => 'Clients', 'contenttitle' => 'Clients List Records'); // redirect(base_url()); $this->load->view('gc_admin_wrapper', $data); }
public function index() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('pedidos')->set_subject('Pedidos')->columns('fecharegistro', 'idcliente', 'formadepago', 'montototal'); //$crud -> required_fields('titulo', 'fechainicio', 'habilitado'); //$crud -> unique_fields('nombre','categoria'); //$crud -> set_field_upload('imagen', 'assets/uploads/files'); $crud->unset_texteditor('descripcion', 'full_text'); $crud->set_relation_n_n('productos', 'items', 'producto', 'idpedido', 'idproducto', 'nombre', 'priority'); $crud->display_as('montototal', 'Monto'); $crud->display_as('nombrecliente', 'Nombre cliente'); $crud->display_as('apellido', 'Apellido cliente'); $crud->display_as('formadepago', 'Forma de pago'); $crud->display_as('idcliente', 'Cliente'); $crud->unset_fields('fecharegistro'); $crud->unset_print(); $output = $crud->render(); $this->_example_output($output); }
function enable_crud($table = '') { // get config file $this->config->load('crud'); $params = $this->config->item('grocery_crud'); // create CRUD object $this->load->library('grocery_CRUD'); $crud = new grocery_CRUD(); // basic settings if (!empty($table)) { $crud->set_table($table); $crud->set_subject(humanize(singular($table))); } // general settings $crud->unset_jquery(); $crud->unset_print(); $crud->unset_export(); // hide fields from CRUD form $crud->unset_fields($params['unset_fields']); // other custom logic to be done in child controllers return $crud; }
public function demarche_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_demarche', $id); $crud->set_table('sos_demarche'); $crud->set_subject('Démarche'); //relations // $crud->set_relation('first', 'sos_gen_demarche_first', 'name_demarche_first'); $crud->set_relation('second', 'sos_gen_demarche_second', 'name_demarche_second'); $crud->set_relation('third', 'sos_gen_demarche_third', 'name_demarche_third'); $crud->set_relation_n_n('ordonnance_de_protection', 'sos_relation_ordonnance_de_protection', 'sos_gen_ordonnance_de_protection', 'id_from_demarche', 'id_from_ordonnance_de_protection', 'name_ordonnance_de_protection'); $crud->set_relation_n_n('suites_de_plainte', 'sos_relation_suites_de_plainte', 'sos_gen_suites_de_plainte', 'id_from_demarche', 'id_from_suites_de_plainte', 'name_suites_de_plainte', 'priority'); //Master/child relations // $fields_demarche = array('first' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second' => array('table_name' => 'sos_gen_demarche_second', 'title' => 'name_demarche_second', 'id_field' => 'id_demarche_second', 'relate' => 'id_from_demarche_first', 'data-placeholder' => 'Préciser'), 'third' => array('table_name' => 'sos_gen_demarche_third', 'title' => 'name_demarche_third', 'id_field' => 'id_demarche_third', 'relate' => 'id_from_demarche_second', 'data-placeholder' => 'Préciser')); // 'url' => base_url() . 'index.php/demarche/window_demarche/'. $this->id_femme.'/', $config_demarche = array('main_table' => 'sos_demarche', 'main_table_primary' => 'id_demarche', 'url' => base_url() . 'index.php/demarche/demarche_window/'); $categories_demarche = new gc_dependent_select($crud, $fields_demarche, $config_demarche); $js_demarche = $categories_demarche->get_js(); //Visual $crud->columns('date_entry', 'date_evenement', 'demarche', 'commentaire', 'upload', 'file_url', 'ordonnance_de_protection', 'suites_de_plainte'); $crud->display_as('upload', 'Type du Document'); $crud->display_as('file_url', 'Document'); $crud->display_as('date_evenement', 'Date évenement'); $crud->display_as('first', 'Type de démarche'); $crud->display_as('second', 'Type d\'intervention'); $crud->display_as('third', 'Suites'); $crud->display_as('date_entry', 'Date de saisie'); //unsets $crud->unset_fields('file_url', 'date_entry'); if (!$this->session->userdata('status')) { $crud->unset_export(); $crud->unset_print(); } //Requireds $crud->required_fields('first'); //Callbacks $crud->callback_before_update(array($this, 'before_update')); $crud->callback_after_update(array($this, 'insert_after_update')); $crud->callback_after_insert(array($this, 'insert_after_insert')); $crud->callback_column('demarche', array($this, 'demarche')); $crud->callback_column('commentaire', array($this, 'commentaire')); $crud->callback_column('ordonnance_de_protection', array($this, 'ordonnance_de_protection')); $crud->callback_column('suites_de_plainte', array($this, 'suites_de_plainte')); $crud->callback_column('date_entry', array($this, 'date_entry')); //field Types $crud->field_type('id_from_femme_demarche', 'hidden', $this->id_femme); $crud->field_type('id_user', 'hidden', $this->session->userdata('userid')); if (!is_dir($path = 'assets/uploads/files/image_' . $this->id_femme)) { mkdir($path = 'assets/uploads/files/image_' . $this->id_femme); } $crud->set_field_upload('file_url', 'assets/uploads/files/image_' . $this->id_femme); $this->db->where('id_from_femme', $this->id_femme); $results = $this->db->get('sos_upload')->result(); $upload_multiselect = array(); foreach ($results as $result) { $text_to_show = ""; $this->db->where('id_type_uploads_parrent', $result->type_uploads); $query_type_uploads = $this->db->get('sos_gen_type_uploads_parrent'); if ($query_type_uploads->num_rows == 1) { $row_type_uploads = $query_type_uploads->row(); $text_to_show .= $row_type_uploads->name_type_uploads_parrent; } $this->db->where('id_type_uploads_child', $result->detailles); $query_type_uploads_child = $this->db->get('sos_gen_type_uploads_child'); if ($query_type_uploads_child->num_rows == 1) { $row_type_uploads_child = $query_type_uploads_child->row(); $text_to_show .= '->' . $row_type_uploads_child->name_type_uploads_child; } $text_to_show .= ' le ' . $result->date_entry; $upload_multiselect[$result->id_upload] = $text_to_show; } if (count($upload_multiselect)) { $crud->field_type('upload', 'dropdown', $upload_multiselect); } else { $crud->field_type('upload', 'hidden', ''); } // Actions // Renders $output = $crud->render(); $output->output .= $js_demarche; $menu = new stdClass(); $menu->n1 = true; $menu->status = false; $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 demande_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', $id); $crud->set_table('sos_demande'); $crud->set_subject('Intervention'); $crud->display_as('date_entry', 'Date de saisie'); $crud->display_as('accueil_dem', 'Accueil'); $crud->display_as('accompagnement_specialise', 'Accompagnement spécialisé'); //relations $crud->set_relation('femme', 'sos_gen_demande_femme', 'name_demande_femme'); $crud->set_relation('accueil_dem', 'sos_gen_demande_accueil', 'name_demande_accueil'); $crud->set_relation_n_n('lieu_ressource', 'sos_relation_demande_lieu_ressource', 'sos_gen_demande_lieu_ressource', 'id_from_demande', 'id_from_lieu_ressource', 'name_demande_lieu_ressource'); $crud->set_relation_n_n('accompagnement_specialise', 'sos_relation_demande_accompagnement_specialise', 'sos_gen_demande_accompagnement_specialise', 'id_from_demande', 'id_from_accompagnement_specialise', 'name_demande_accompagnement_specialise'); $crud->set_relation('hbgt', 'sos_gen_demande_hbgt', 'name_demande_hbgt'); $crud->set_relation('service', 'sos_gen_service', 'nom_service', null, 'nom_service DESC'); //Master/child relations //Visual $crud->columns('date_entry', 'visite', 'accompagnement_specialise', 'lieu_ressource', 'commentaire'); //unsets $crud->unset_fields('id_demande', 'date_entry', 'dump'); if (!$this->session->userdata('status')) { $crud->unset_export(); $crud->unset_print(); } //Requireds $crud->required_fields('visite', 'accueil_dem', 'femme', 'service'); //Callbacks $crud->callback_column('date_entry', array($this, 'date_entry')); $crud->callback_column('visite', array($this, 'visite')); $crud->callback_column('commentaire', array($this, 'commentaire')); $crud->callback_column('commentaire_psy', array($this, 'commentaire_psy')); $crud->callback_column('lieu_ressource', array($this, 'lieu_ressource')); $crud->callback_column('accompagnement_specialise', array($this, 'accompagnement_specialise')); $crud->callback_after_update(array($this, 'insert_after')); $crud->callback_after_insert(array($this, 'insert_after_insert')); //field Types $crud->field_type('id_from_femme', 'hidden', $this->id_femme); $crud->field_type('id_user', 'hidden', $this->session->userdata('userid')); // Actions $crud->add_action('Enfants', '', 'enfants/enfants_window', 'ui-icon-person'); //$crud->add_action('Enfants', base_url('img/pictos/enfants.png'), 'kids/kids_window', 'ui-icon-person'); // $crud->add_action('Enfants', base_url('img/pictos/enfants.png'), 'enfants/enfants_window', 'ui-icon-person'); // 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 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 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); }
function branch_management() { $merchant_id = $this->ion_auth->user()->row()->id; //for supervisor view the branch of merchant if (check_correct_login_type($this->group_id_supervisor)) { $merchant_id = $this->ion_auth->user()->row()->su_merchant_id; } $this->load->library('grocery_CRUD'); try { $crud = new grocery_CRUD(); $this->load->library('user_agent'); if ($this->agent->is_mobile() && $this->agent->is_tablet() === FALSE) { $crud->set_theme('bootstrap'); $crud->unset_search(); } else { $crud->set_theme('datatables'); //datatables, flexigrid, bootstrap //$crud->add_action('Add Supervisor', '', 'merchant/supervisor/add','ui-icon-pencil'); //No use this because cannot open new tab } //($this->agent->is_tablet() === TRUE) ? $is_tablet = "Yes" : $is_tablet = "No"; echo "Using tablet: $is_tablet"; $crud->set_table('merchant_branch'); $crud->set_subject('Branch'); $crud->columns('name', 'address', 'phone', 'state_id', 'supervisor'); $crud->required_fields('name', 'address', 'state_id'); $crud->fields('name', 'address', 'phone', 'state_id', 'google_map_url'); $crud->display_as('state_id', 'State'); $crud->display_as('google_map_url', 'Google Map Coordinate'); $crud->unset_fields('merchant_id'); $crud->unset_texteditor('address', 'google_map_url'); $crud->field_type('state_id', 'dropdown', $this->ion_auth->get_static_option_list('state')); $crud->callback_insert(array($this, 'branch_insert_callback')); $crud->callback_add_field('phone', array($this, 'add_field_for_phone')); $crud->callback_column('name', array($this, '_branch_map')); $crud->callback_column('address', array($this, '_full_text')); $crud->callback_column('supervisor', array($this, '_branch_supervisor')); $controller = 'merchant'; $function = 'profile'; $crud->set_lang_string('insert_success_message', 'Your data has been successfully stored into the database. <script type="text/javascript"> var originallocation = window.location.pathname; if(originallocation.indexOf("/branch/add") > -1) { window.location = "' . site_url($controller . '/' . $function) . '"; } </script> <div style="display:none"> '); $crud->set_lang_string('update_success_message', 'Your data has been successfully stored into the database. <script type="text/javascript"> var originallocation = window.location.pathname; if(originallocation.indexOf("/branch/edit") > -1) { window.location = "' . site_url($controller . '/' . $function) . '"; } </script> <div style="display:none"> '); $crud->set_lang_string('form_save_and_go_back', 'Save and View Branch'); $crud->set_lang_string('form_update_and_go_back', 'Update and View Branch'); $crud->unset_export(); $crud->unset_print(); $state = $crud->getState(); //Temporary use this to skip the bootstrap top right search not working bug after got $crud->where() function // if ($state == 'ajax_list') { // if (!empty($crud->getStateInfo())) { // $state_info = $crud->getStateInfo(); // if (!empty($state_info->search->text)) { // // } else { // $crud->where('merchant_id', $id); // } // } // } else { $crud->where('merchant_id', $merchant_id); // } if ($state == 'read') { $crud->set_relation('state_id', 'static_option', '{option_text}'); } $output = $crud->render(); return $output; } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function suivie_window($id) { $this->id_psy = $id; $this->db->select('sos_psy.id_from_femme'); $this->db->where('id_psy', $this->id_psy); $query = $this->db->get('sos_psy'); $row_psy = $query->row(); $this->id_femme = $row_psy->id_from_femme; try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->where('id_from_femme', $this->id_femme); $crud->where('rdv', 4); $crud->set_table('sos_demande'); $crud->set_subject('Demande'); //relations //Master/child relations //Visual $crud->columns('date_entry', 'visite', 'commentaire_psy'); //unsets $crud->unset_fields('id_demande', 'date_entry', 'dump', 'visite', 'accueil', 'informations', 'conseil', 'orientation', 'rdv', 'hebergement', 'logement', 'aide_materielle', 'adresse_postale', 'accompagnement_exterieur', 'commentaire'); $crud->unset_delete(); $crud->unset_add(); if (!$this->session->userdata('status')) { $crud->unset_export(); $crud->unset_print(); } //Requireds //$crud->required_fields('visite'); //Callbacks $crud->callback_column('date_entry', array($this, 'date_entry')); $crud->callback_column('commentaire_psy', array($this, 'commentaire_psy')); $crud->callback_after_update(array($this, 'insert_after')); $crud->callback_after_insert(array($this, 'insert_after_insert')); //field Types $crud->field_type('id_from_femme', 'hidden', $this->id_femme); $crud->field_type('id_user', 'hidden', $this->session->userdata('userid')); // Actions // Renders $output = $crud->render(); $menu = new stdClass(); $menu->id = $this->id_femme; if ($this->session->userdata('status') != '0') { $menu->lien1 = true; $menu->lien1_2 = true; $menu->lien2 = true; $menu->lien2_1 = true; $menu->lien3 = true; $menu->lien3_1 = true; $menu->lien3_1_1 = true; $menu->lien3_1_2 = true; $menu->lien3_1_3 = true; $menu->lien3_1_4 = true; $menu->lien3_1_5 = true; $menu->lien3_2 = true; $menu->lien3_2_1 = true; $menu->lien3_2_2 = true; $menu->lien3_2_3 = true; } else { $menu->lien1 = true; $menu->lien1_2 = true; $menu->lien2 = true; $menu->lien2_1 = true; } $header = $this->navigation->home_f($menu); $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
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 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 upload_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', $id); $crud->set_table('sos_upload'); $crud->set_subject('Document'); $crud->field_type('id_from_femme', 'hidden', $this->id_femme); //relations $crud->set_relation('type_uploads', 'sos_gen_type_uploads_parrent', 'name_type_uploads_parrent'); $crud->set_relation('detailles', 'sos_gen_type_uploads_child', 'name_type_uploads_child'); //Master/child relations //Visual $crud->columns('type_uploads', 'detailles', 'file_url', 'date_entry'); //unsets $crud->unset_fields('date_entry'); $crud->unset_export(); $crud->unset_print(); //Requireds $crud->required_fields('type_uploads', 'file_url'); //Visual $crud->display_as('type_uploads', 'Type de document')->display_as('detailles', 'Détail')->display_as('date_entry', 'Date d\'envoi')->display_as('file_url', 'Document'); //Callbacks $crud->callback_after_update(array($this, 'after_update')); $crud->callback_before_upload(array($this, 'before_upload')); $crud->callback_before_delete(array($this, 'before_delete')); $crud->callback_after_insert(array($this, 'insert_after')); $crud->callback_before_update(array($this, 'before_update')); //field Types if (!is_dir($path = 'assets/uploads/files/image_' . $this->id_femme)) { mkdir($path = 'assets/uploads/files/image_' . $this->id_femme); } $crud->set_field_upload('file_url', 'assets/uploads/files/image_' . $this->id_femme); $fields_type_uploads = array('type_uploads' => array('table_name' => 'sos_gen_type_uploads_parrent', 'title' => 'name_type_uploads_parrent', 'relate' => null), 'detailles' => array('table_name' => 'sos_gen_type_uploads_child', 'title' => 'name_type_uploads_child', 'id_field' => 'id_type_uploads_child', 'relate' => 'id_parrent_from_type_uploads_parrent', 'data-placeholder' => 'Precisé')); $config_type_uploads = array('main_table' => 'sos_upload', 'main_table_primary' => 'id_upload', "url" => base_url() . 'index.php/upload/upload_window/', 'segment_name' => "type_uploads"); $categories_type_uploads = new gc_dependent_select($crud, $fields_type_uploads, $config_type_uploads); $js_type_uploads = $categories_type_uploads->get_js(); // Actions $this->db->where('id_femme', $this->id_femme); $query = $this->db->get('sos_femme'); if ($query->num_rows == 1) { $row_femme = $query->row(); } // Renders $output = $crud->render(); $output->output .= $js_type_uploads; $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()); } }
function logger() { $crud = new grocery_CRUD(); $crud->order_by('dateofdeleteion', 'DESC'); $crud->where('status<>', '0'); $crud->where('dateofdeleteion<=', date('Y-m-d')); if ($this->session->userdata('role') > 1) { $crud->where('alert_name', $this->session->userdata('user_name')); } $crud->set_table('query', 0, 50); $crud->columns('subject', 'dts', 'alg_ref', 'date_creation', 'alert_assign_to', 'status', 'dateofdeleteion'); $crud->unset_fields('status', 'dateofdeleteion'); $crud->display_as('subject', 'Subject Line')->display_as('alg_ref', 'ALG Ref No.')->display_as('dts', 'Practice Account')->display_as('date_creation', 'Date creation')->display_as('dateofdeleteion', 'Date Deletion')->display_as('alert_assign_to', 'Name'); $crud->set_subject('Query'); $crud->set_relation('dts', 'DTS', 'name'); $crud->callback_column('status', array($this, '_column_status')); $crud->callback_column($this->unique_field_name('alert_assign_to'), array($this, '_column_edit_manager1')); $crud->set_relation('alert_assign_to', 'membership', 'user_name'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $output = $crud->render(); $this->_example_output($output); }
public function courseaward_management() { try { $crud = new grocery_CRUD(); $crud->set_table('tj_jyk_jiaoxuejlj'); $crud->set_subject('教学奖励金'); /*$crud->required_fields('jsdm');*/ $crud->columns('jsdm', 'jsmc', 'yxdm', 'xnd', 'xmmc', 'jb', 'dj'); $crud->display_as('jsdm', '姓名')->display_as('yxdm', '所属学院(系)')->display_as('xnd', '年度')->display_as('jsmc', '教师名称')->display_as('xmmc', '项目名称')->display_as('jb', '级别')->display_as('dj', '等级'); $crud->unset_fields('get_seq'); $output = $crud->render(); $this->_main_output($output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function sub_menu($id_header_menu, $level_one) { $crud = new grocery_CRUD(); $crud->set_table('menu'); $crud->set_subject('Sub Menu'); $crud->where('level_one', $level_one); $crud->where('level_two', '0'); $crud->change_field_type('id_header_menu', 'invisible'); $crud->change_field_type('level_one', '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->unset_fields('level_two'); $crud->add_action('Sub menu 2', 'fa fa-plus-circle', '', '', array($this, 'link_sub_menu_2')); $crud->callback_before_insert(array($this, 'call_sub_menu')); $crud->callback_after_delete(array($this, 'sub_menu_after_delete')); $output = $crud->render(); $data['script'] = "\$('#menu-menu').addClass('active');"; $data['script_grocery'] = "\$('a[href=\"#hidden\"]').replaceWith('<span style=\"color:#777\"><i class=\"fa fa-circle\"></i> Sub menu 2</span>')"; $output->data = $data; $data['judul'] = "Sub menu"; $data['crumb'] = array('Header menu' => 'crud/header_menu', 'Menu' => 'crud/menu/' . $id_header_menu, 'Sub menu' => ''); $template = 'admin_template'; $view = 'grocery'; $this->outputview->output_admin($view, $template, $data, $output); }
public function index() { $crud = new grocery_CRUD(); $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_cost_price', 'Cost Price'); $crud->display_as('package_basic_price', 'Selling Price'); $crud->display_as('package_market_price', 'Market Price'); $crud->display_as('package_service_charge', 'Service Charge'); $crud->display_as('package_vat', 'VAT'); $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'); $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('package_agent', 'dropdown', $agents); $crud->required_fields('package_agent'); /* * For related packages * on add list all the packages * on edit, list all except own name */ if ($crud->getState() == 'edit') { $hrf = $this->generic_model->get_by('packages', array('package_status' => 1, 'package_id !=' => $crud->getStateInfo()->primary_key), 'package_id'); } else { $hrf = $this->generic_model->get_by('packages', array('package_status' => 1), 'package_id'); } $hrf = $this->generic_model->array_from_db($hrf, 'package_id, package_title'); $crud->field_type('package_related', 'multiselect', $hrf); // $crud->set_relation('package_agent', 'agents', '{agent_companyName}'); //$agents = $this->ion_auth->get_all_agents(); // $crud->field_type('package_agent', 'dropdown', $agents); // $crud->field_type('package_agent', 'hidden', $this->ion_auth->user()->row()->id); $crud->field_type('package_difficulty', 'dropdown', array('1' => 'Easy', '2' => 'Basic', '3' => 'Beginner', '4' => 'Intermediate', '5' => 'Advanced')); $crud->set_relation('package_category', 'packages_types_settings', 'sett_name', 'sett_type = "ttypes"', 'sett_id'); $crud->callback_column('package_image', array($this, 'set_image')); $crud->callback_column('package_basic_price', array($this, 'set_price')); $crud->callback_column('package_basic_discount', array($this, 'set_price')); $crud->callback_read_field('package_basic_price', array($this, 'set_price')); $crud->callback_read_field('package_basic_discount', array($this, 'set_price')); $crud->callback_add_field('package_cost_price', function ($value, $primary_key) { return "USD <input id='field-package_cost_price' class='form-control' name='package_cost_price' type='text' value='' maxlength='20'>"; }); /*$crud->callback_add_field('package_difficulty', function ($value, $primary_key) { return '<select id="field-package_difficulty" class="form-control" name="package_difficulty"> <option value="1" data-html="Easy">Easy</option> <option value="2" data-html="Basic">Basic</option> <option value="3" data-html="Beginner">Beginner</option> <option value="3" data-html="Intermediate">Intermediate</option> <option value="3" data-html="Advanced">Advanced</option> </select>'; });*/ $crud->callback_add_field('package_market_price', function ($value, $primary_key) { return "USD <input id='field-package_market_price' class='form-control' name='package_market_price' type='text' value='' maxlength='20'>"; }); $crud->callback_edit_field('package_cost_price', function ($value, $primary_key) { return "USD <input id='field-package_cost_price' class='form-control' name='package_cost_price' type='text' value='{$value}' maxlength='20'>"; }); $crud->callback_edit_field('package_market_price', function ($value, $primary_key) { return "USD <input id='field-package_market_price' class='form-control' name='package_market_price' type='text' value='{$value}' maxlength='20'>"; }); $crud->callback_add_field('package_basic_price', function () { return "USD <input id='field-package_basic_price' class='form-control' name='package_basic_price' type='text' value='' maxlength='20'>"; }); $crud->callback_add_field('package_basic_discount', function () { return "USD <input id='field-package_basic_discount' class='form-control' name='package_basic_discount' type='text' 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->unique_fields('package_slug'); $crud->add_action('Photo Gallery', '', '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'); $this->load->view('gc_admin_wrapper', $data); }
public function first($id) { try { // General $crud = new grocery_CRUD(); $crud->set_language("french"); $crud->set_theme('bootstrap'); $crud->set_table('sos_femme_premier'); if (!$this->session->userdata('status')) { $crud->where('archiver', FALSE); } $crud->set_subject('Femme'); $crud->where('id_femme', $id); $crud->unset_add(); //relations $crud->set_relation('situation_familiale', 'sos_gen_situation_familiale_parrent', 'name_situation_familiale_parrent'); $crud->set_relation('detailles', 'sos_gen_situation_familiale_child', 'name_situation_familiale_child'); $crud->set_relation('emplois', 'sos_gen_emplois_parrent', 'name_emplois'); $crud->set_relation('emplois_detailles', 'sos_gen_emplois_child', 'name_emplois_detaille'); $crud->set_relation('emplois_more_detailles', 'sos_gen_emplois_child_child', 'name_emplois_child_child'); $crud->set_relation('logement', 'sos_gen_logement_parent', 'name_logement'); $crud->set_relation('logement_detailles', 'sos_gen_logement_child', 'name_logement_child'); $crud->set_relation('ressources', 'sos_gen_ressources', 'name_ressources'); $crud->set_relation('provenance', 'sos_gen_provenance', 'name_provenance'); $crud->set_relation('allocations_familiales', 'sos_gen_allocations_familiales', 'name_allocations_familiales'); $crud->set_relation('percues_par', 'sos_gen_percues_par', 'name_percues_par'); $crud->set_relation('depuis', 'sos_gen_depuis', 'name_depuis'); $crud->set_relation('situation_actuelle_depuis', 'sos_gen_situation_actuelle_depuis', 'name_situation_actuelle_depuis', null, 'id_situation_actuelle_depuis ASC'); $crud->set_relation('situation_actuelle', 'sos_gen_situation_actuelle', 'name_situation_actuelle'); $crud->set_relation('situation_actuelle_detailles', 'sos_gen_situation_actuelle_detailles', 'name_situation_actuelle_detailles'); $crud->set_relation('departs_anterieurs', 'sos_gen_departs_anterieurs', 'name_departs_anterieurs'); //Master/child relations $fields_situation_familialle = array('situation_familiale' => array('table_name' => 'sos_gen_situation_familiale_parrent', 'title' => 'name_situation_familiale_parrent', 'relate' => null), 'detailles' => array('table_name' => 'sos_gen_situation_familiale_child', 'title' => 'name_situation_familiale_child', 'id_field' => 'id_situation_familiale_child', 'relate' => 'id_parrent_from_situation_familiale_parrent', 'data-placeholder' => 'Préciser')); $config_situation_familialle = array('main_table' => 'sos_femme_premier', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "situation_familialle"); $categories_situation_familialle = new gc_dependent_select($crud, $fields_situation_familialle, $config_situation_familialle); $js_situation_familialle = $categories_situation_familialle->get_js(); $fields_situation_actuelle = array('situation_actuelle' => array('table_name' => 'sos_gen_situation_actuelle', 'title' => 'name_situation_actuelle', 'relate' => null), 'situation_actuelle_detailles' => array('table_name' => 'sos_gen_situation_actuelle_detailles', 'title' => 'name_situation_actuelle_detailles', 'id_field' => 'id_situation_actuelle_detailles', 'relate' => 'id_from_situation_actuelle', 'data-placeholder' => 'Préciser')); $config_situation_actuelle = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "situation_actuelle"); $categories_situation_actuelle = new gc_dependent_select($crud, $fields_situation_actuelle, $config_situation_actuelle); $js_situation_actuelle = $categories_situation_actuelle->get_js(); $fields_emplois = array('emplois' => array('table_name' => 'sos_gen_emplois_parrent', 'title' => 'name_emplois', 'relate' => null), 'emplois_detailles' => array('table_name' => 'sos_gen_emplois_child', 'title' => 'name_emplois_detaille', 'id_field' => 'id_emplois_detailles', 'relate' => 'id_from_emplois', 'data-placeholder' => 'Préciser'), 'emplois_more_detailles' => array('table_name' => 'sos_gen_emplois_child_child', 'title' => 'name_emplois_child_child', 'id_field' => 'id_emplois_child_child', 'relate' => 'id_emplois_from_child', 'data-placeholder' => 'Préciser')); $config_emplois = array('main_table' => 'sos_femme_premier', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "emplois"); $categories_emplois = new gc_dependent_select($crud, $fields_emplois, $config_emplois); $js_emplois = $categories_emplois->get_js(); $fields_ressources = array('ressources' => array('table_name' => 'sos_gen_ressources', 'title' => 'name_ressources', 'relate' => null), 'provenance' => array('table_name' => 'sos_gen_provenance', 'title' => 'name_provenance', 'id_field' => 'id_provenance', 'relate' => 'id_from_ressources', 'data-placeholder' => 'Préciser')); $config_ressources = array('main_table' => 'sos_femme_premier', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "ressources"); $categories_ressources = new gc_dependent_select($crud, $fields_ressources, $config_ressources); $js_ressources = $categories_ressources->get_js(); $fields_allocations_familiales = array('allocations_familiales' => array('table_name' => 'sos_gen_allocations_familiales', 'title' => 'name_allocations_familiales', 'relate' => null), 'percues_par' => array('table_name' => 'sos_gen_percues_par', 'title' => 'name_percues_par', 'id_field' => 'id_percues_par', 'relate' => 'id_from_allocations_familiales', 'data-placeholder' => 'Préciser')); $config_allocations_familiales = array('main_table' => 'sos_femme_premier', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "allocations_familiales"); $categories_allocations_familiales = new gc_dependent_select($crud, $fields_allocations_familiales, $config_allocations_familiales); $js_allocations_familiales = $categories_allocations_familiales->get_js(); $fields_logement = array('logement' => array('table_name' => 'sos_gen_logement_parent', 'title' => 'name_logement', 'relate' => null), 'logement_detailles' => array('table_name' => 'sos_gen_logement_child', 'title' => 'name_logement_child', 'id_field' => 'id_logement_child', 'relate' => 'id_from_logement_parent', 'data-placeholder' => 'Préciser')); $config_logement = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "logement"); $categories_logement = new gc_dependent_select($crud, $fields_logement, $config_logement); $js_logement = $categories_logement->get_js(); //Visual $crud->columns('Premier Acceuil', 'enceinte', 'profession', 'Situation Actuelle - Emlpoi', 'Appartenance - Logement', 'Situation Actuelle - Logement', 'departs_anterieurs', 'ressources', 'provenance', 'Allocations familiales', 'dettes'); $crud->display_as('pays', 'Originaire de')->display_as('archiver', 'Archivage')->display_as('prenom', 'Prénom')->display_as('telephone', 'Téléphone')->display_as('nationalite', 'Nationalité')->display_as('rue', 'Adresse')->display_as('oriente_par_SMS', 'Orientée par SMS')->display_as('departs_anterieurs', 'Départs antérieurs')->display_as('nationalite_detailles', 'Situation administrative')->display_as('detailles', 'Situation familiale en détail')->display_as('duree_de_la_relation', 'Durée de la relation')->display_as('emplois_detailles', 'Détails de l\'emploi')->display_as('emplois_more_detailles', 'Plus de détails de l\'emploi')->display_as('ouvertures', 'Dernière modification')->display_as('hebergement', 'Demande d\'hébergement')->display_as('aide_materielle', 'Demande d\'aide matérielle')->display_as('accompagnement_exterieur', 'Demande d\'accompagnement extérieur')->display_as('adresse_postale', 'Demande d\'adresse postale')->display_as('accueil', 'Demande d\'accueil')->display_as('informations', 'Demande d\'informations')->display_as('conseil', 'Demande de conseil')->display_as('orientation', 'Demande d\'orientation')->display_as('rdv', 'Demande de rdv')->display_as('hebergement', 'Demande d\'hébergement')->display_as('logement_dem', 'Demande de logement')->display_as('logement_detailles', 'Logement détaillé')->display_as('situation_actuelle_detailles', 'Situation actuelle détaillée')->display_as('emplois', 'Situation professionnelle')->display_as('emplois_detailles', 'Situation professionnelle détaillée')->display_as('emplois_more_detailles', 'Autres infos emploi')->display_as('percues_par', 'Perçues par')->display_as('commentaire', 'Commentaires')->display_as('partenaire', 'Orienteur'); $crud->order_by('prenom', 'desc'); //unsets if (!$this->session->userdata('status')) { $crud->unset_delete(); $crud->unset_export(); $crud->unset_print(); } //Requireds //$crud->required_fields('service', 'premier_contact', 'prenom'); //Callbacks $crud->callback_column('Premier Acceuil', array($this, 'premier_acceuil')); $crud->callback_column('Situation Actuelle - Emlpoi', array($this, 'situation_actuelle')); $crud->callback_column('Appartenance - Logement', array($this, 'appartenance')); $crud->callback_column('Situation Actuelle - Logement', array($this, 'situation_actuelle_logement')); $crud->callback_column('Allocations familiales', array($this, 'allocations_familiales')); //$crud->callback_column('premier_contact', array($this, 'premier_contact')); //$crud->callback_column('nombre_d\'enfants', array($this, 'enfants')); //$crud->callback_after_update(array($this, 'insert_after_update')); //$crud->callback_after_insert(array($this, 'insert_after_insert')); //$crud->callback_after_delete(array($this, 'after_delete')); //$crud->callback_column('archiver', array($this, 'archiver')); $crud->callback_before_update(array($this, 'before_update')); //field Types $crud->field_type('enceinte', 'dropdown', array('1' => '1 mois', '2' => '2 mois', '3' => '3 mois', '4' => '4 mois', '5' => '5 mois', '6' => '6 mois', '7' => '7 mois', '8' => '8 mois', '9' => '9 mois')); $crud->field_type('dettes', 'enum', array('OUI', 'NON')); // Actions // Renders $crud->unset_fields('id_femme', 'prenom', 'nom', 'age', 'telephone', 'nom_marital', 'rue', 'premier_contact', 'par', 'service', 'oriente_par_SMS', 'partenaire', 'ville', 'pays', 'nationalite', 'nationalite_detailles', 'accueil', 'informations', 'conseil', 'orientation', 'rdv', 'hebergement', 'logement_dem', 'aide_materielle', 'adresse_postale', 'accompagnement_exterieur', 'commentaire', 'archiver', 'duree_de_la_relation'); $output = $crud->render(); $output->output .= $js_situation_familialle . $js_emplois . $js_ressources . $js_allocations_familiales . $js_logement . $js_situation_actuelle; $menu = new stdClass(); $menu->n1 = true; $menu->status = $this->session->userdata('status'); $header = $this->navigation->home_f($menu); $data = array('output' => $output, 'header' => $header); $this->_example_output($data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }