/**
* 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());
}
}
