public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('bootstrap');
$crud->set_table('user');
$crud->set_subject('Gebruiker');
// hide fields
$crud->columns('is_super_user', 'is_active', 'screen_name', 'email', 'gebruikersgroepen');
// new_password and new_password repeat are needed to make formvalidation work
// id is needed to make the email unique check work
$crud->fields('id', 'is_active', 'screen_name', 'email', 'gebruikersgroepen', 'password', 'new_password', 'new_password_repeat');
$crud->required_fields('email', 'screen_name', 'is_active');
$crud->set_relation_n_n('gebruikersgroepen', 'user_x_user_group', 'user_group', 'user_id', 'user_group_id', 'name');
$crud->field_type('id', 'hidden');
$crud->field_type('new_password_repeat', 'hidden');
$crud->field_type('password', 'hidden');
$crud->display_as('is_active', 'Actief');
$crud->display_as('screen_name', 'Schermnaam');
$crud->display_as('is_super_user', '');
$crud->display_as('new_password', 'Wachtwoord');
if ($crud->getState() == 'read') {
$crud->field_type('new_password', 'hidden');
} else {
$crud->callback_field('new_password', array($this, 'edit_field_callback_new_password'));
}
$crud->field_type('is_active', 'dropdown', array('yes' => 'ja', 'no' => 'nee'));
$crud->callback_column('is_active', array($this, 'callback_list_is_active'));
$crud->callback_column('is_super_user', array($this, 'callback_list_is_super_user'));
$crud->callback_before_insert(array($this, 'before_insert_update_callback'));
$crud->callback_before_update(array($this, 'before_insert_update_callback'));
$crud->callback_after_insert(array($this, 'after_insert_callback'));
$crud->callback_after_update(array($this, 'after_update_callback'));
if ($crud->getState() === 'update_validation' or $crud->getState() === 'insert_validation') {
$crud->set_rules('email', 'E-mail', 'required|valid_email|callback_email_unique_check');
$crud->set_rules('screen_name', 'Schermnaam', 'required');
if ($this->input->post('new_password') != '' or !$this->input->post('id')) {
$crud->set_rules('new_password', 'Nieuw wachtwoord', 'required|min_length[10]|matches[new_password_repeat]');
$crud->set_rules('new_password_repeat', 'Herhaal nieuw wachtwoord', '');
}
$this->form_validation->set_message('matches', 'De wachtwoorden zijn niet aan elkaar gelijk.');
}
// render the crud HTML
$crud_output = $crud->render();
//get the needed css and javascript files
$this->javascript_files = $crud->get_js_files();
$this->css_files = $crud->get_css_files();
// put the crud content in the right position
$this->views['content'] = $crud_output->output;
$this->css[] = $this->load->view('admin/user/css/index.css', array(), true);
// add javascript and css to make the password generate and change function possible
if ($crud->getState() === 'add' or $crud->getState() === 'edit') {
$this->css[] = $this->load->view('admin/user/css/edit_user.css', array(), true);
$this->javascript[] = $this->load->view('admin/user/js/edit_user.js', array(), true);
}
// create the layout-HTML and show it to the user
$this->_layout();
}
public function index($categoryid = 0)
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$data['lo'] = 2;
//value used to identify section movie or celebrity
$data['categoryid'] = $categoryid;
//value used to identify section movie or celebrity
if ($categoryid != 0) {
$data['cat_id'] = $categoryid;
$cat_title = $this->category->getTitle($categoryid);
$data['cat_title'] = $cat_title . " - Movies";
$form_subject = $cat_title;
$crud = new grocery_CRUD();
$crud->set_table('dbx_movies');
$crud->where('catid', $categoryid);
$crud->set_subject('Movie');
$crud->required_fields('title', 'year');
$crud->columns('title');
// $crud->callback_column('name',array($this,'link_title'));
// $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]');
$crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl'));
$crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl'));
$crud->fields('catid', 'title', 'year', 'release_date', 'cast', 'director', 'producer', 'music', 'writer', 'lyrics', 'synopsis', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date');
// $crud->field_type('catid', 'hidden', $categoryid);
$crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'M'), null, $categoryid);
$crud->display_as('catid', 'Category');
//
$crud->callback_add_field('cast', array($this, 'add_field_cast'));
$crud->callback_add_field('synopsis', array($this, 'add_field_synopsis'));
$crud->callback_edit_field('cast', array($this, 'edit_field_cast'));
$crud->callback_edit_field('synopsis', array($this, 'edit_field_synopsis'));
$crud->change_field_type('ownerid', 'invisible');
$crud->change_field_type('created_date', 'invisible');
$crud->change_field_type('seo_url', 'invisible');
$crud->change_field_type('lastupdate_date', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->callback_after_insert(array($this, 'after_insert'));
$crud->unset_jquery();
$state = $crud->getState();
// echo($state);
$data['state'] = $state;
$output = $crud->render($data);
$this->load->view('header_view', $data);
$this->load->view('movies_view', $output);
$this->load->view('footer_view', $data);
}
}
public function incidencias()
{
$crud = new grocery_CRUD();
$crud->set_table('incidencias');
$crud->set_subject('Incidents');
$crud->set_relation('idtipo', 'tipos_incidencias', 'descripcion_incidencia');
$crud->field_type('idusuario', 'hidden');
$crud->field_type('fecha_alta', 'hidden');
$crud->field_type('fecha_fin', 'hidden');
$crud->field_type('numero', 'hidden');
$crud->edit_fields("descripcion", "estado", "numero", "fecha_fin");
$crud->callback_before_insert(array($this, "new_incident_callback"));
$crud->callback_before_update(array($this, "edit_incident_callback"));
return $crud->render();
}
private function master()
{
$crud = new grocery_CRUD();
$crud->set_table('contents');
$crud->unset_columns('jenis', 'slug', 'isi');
$crud->callback_before_insert(array($this, "_timestamp"));
$crud->callback_before_update(array($this, "_timestamp"));
$crud->unset_export();
$crud->unset_print();
$crud->unset_read();
$crud->change_field_type('jenis', 'invisible');
$crud->change_field_type('slug', 'invisible');
$crud->change_field_type('created_at', 'invisible');
$crud->change_field_type('updated_at', 'invisible');
return $crud;
}
function users_management()
{
$crud = new grocery_CRUD();
$crud->set_table('operarios');
$crud->set_subject('Usuario');
$crud->set_theme('datatables');
$crud->columns('id', 'nombre');
$crud->edit_fields('nombre', 'clave', 'eliminado');
$crud->add_fields('id', 'nombre', 'clave');
$crud->required_fields('id', 'nombre', 'clave');
$crud->change_field_type('clave', 'password');
$crud->callback_before_insert(array($this, '_encrypt_password_callback'));
$crud->callback_before_update(array($this, '_encrypt_password_callback'));
$crud->unset_delete();
$output = $crud->render();
$this->_output_crud($output, 'Usuarios');
}
public function index($stat = '')
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
switch ($stat) {
case '':
default:
$user_ward_id = $this->session->userdata('nw_id');
$crud->set_table('nus_bed');
$crud->where('nus_bed.nw_id', $user_ward_id);
$crud->columns('nb_bed_no', 'np_pmi_id', 'nbs_id', 'nb_datetime', 'ns_id');
$crud->display_as('nb_bed_no', 'Bed No.')->display_as('np_pmi_id', 'Patient Name')->display_as('nbs_id', 'Remarks')->display_as('nb_datetime', 'Date/Time Registered')->display_as('ns_id', 'Nurse');
$crud->set_relation('nbs_id', 'nus_bed_status', 'nbs_desc');
$crud->set_relation('ns_id', 'nus_staff', 'ns_fullname');
$crud->set_relation('np_pmi_id', 'nus_patient', 'np_fullname');
// $crud->unset_add();
// $crud->unset_delete();
$crud->edit_fields('np_pmi_id', 'nbs_id', 'nb_datetime', 'ns_id');
$crud->add_fields('nb_bed_no', 'nw_id', 'nbs_id');
$crud->field_type('nw_id', 'hidden');
// $crud->field_type('nbs_id', 'hidden');
$crud->required_fields('nb_bed_no');
$crud->unset_read();
// $crud->change_field_type('nb_bed_no', 'readonly');
$crud->change_field_type('ns_id', 'readonly');
$crud->callback_before_update(array($this, 'autoRegisterBed'));
$crud->callback_before_insert(array($this, 'addBed'));
break;
case 'patient':
$crud->set_table('nus_patient');
$crud->set_relation('np_gender', 'nus_patient_gender', 'npg_desc');
$crud->required_fields('np_pmi_no', 'np_fullname', 'np_ic', 'np_passport', 'np_gender');
$crud->fields('np_pmi_id', 'np_fullname', 'np_ic', 'np_passport', 'np_gender');
$crud->field_type('np_pmi_id', 'hidden');
$crud->display_as('np_pmi_id', 'PMI No.')->display_as('np_fullname', 'Full Name')->display_as('np_ic', 'IC No.')->display_as('np_passport', 'Passport No.')->display_as('np_gender', 'Gender');
$crud->callback_before_insert(array($this, 'autoInsertPriKeyPatient'));
break;
}
$output = $crud->render();
$this->viewpage('v_mainpage', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function index($categoryid = 0)
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$data['lo'] = 1;
//value used to identify section movie or celebrity
if ($categoryid != 0) {
$data['cat_id'] = $categoryid;
$cat_title = $this->category->getTitle($categoryid);
$data['cat_title'] = $cat_title . " ";
$form_subject = $cat_title;
$crud = new grocery_CRUD();
$crud->set_table('dbx_celebrities');
$crud->where('catid', $categoryid);
$crud->set_subject($form_subject);
$crud->required_fields('name');
$crud->columns('name');
// $crud->callback_column('name',array($this,'link_title'));
// $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]');
$crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl'));
$crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl'));
$crud->fields('catid', 'name', 'alt_name1', 'alt_name2', 'alt_name3', 'alt_name4', 'title', 'desc', 'sign', 'birth_date', 'birth_place', 'first_film', 'awards', 'height', 'weight', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date');
// $crud->field_type('catid', 'hidden', $categoryid);
$crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'C'), null, $categoryid);
$crud->display_as('catid', 'Category');
$crud->callback_add_field('desc', array($this, 'add_field_desc'));
$crud->callback_add_field('awards', array($this, 'add_field_awards'));
$crud->callback_edit_field('desc', array($this, 'edit_field_desc'));
$crud->callback_edit_field('awards', array($this, 'edit_field_awards'));
$crud->field_type('sign', 'dropdown', array('Aries' => 'Aries', 'Taurus' => 'Taurus', 'Gemini1' => 'Gemini', 'Cancer' => 'Cancer', 'Leo' => 'Leo', 'Virgo' => 'Virgo', 'Libra' => 'Libra', 'Scorpio' => 'Scorpio', 'Sagittarius' => 'Sagittarius', 'Capricorn' => 'Capricorn', 'Aquarius' => 'Aquarius', 'Pisces' => 'Pisces'));
$crud->change_field_type('ownerid', 'invisible');
$crud->change_field_type('created_date', 'invisible');
$crud->change_field_type('seo_url', 'invisible');
$crud->change_field_type('lastupdate_date', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->unset_jquery();
$output = $crud->render($data);
$this->load->view('header_view', $data);
$this->load->view('celebrities_view', $output);
$this->load->view('footer_view', $data);
}
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_table('usrmgr');
$crud->change_field_type('password', 'password');
$crud->callback_edit_field('password', array($this, 'decrypt_password_callback'));
$crud->columns('username', 'nama_lengkap', 'email', 'level', 'blokir');
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->set_subject('Users');
$crud->fields('nama_lengkap', 'username', 'password', 'email', 'level', 'access_control', 'blokir');
$crud->required_fields('nama_lengkap', 'username', 'level', 'blokir');
$crud->set_relation_n_n('access_control', 'usrmgr_access', 'modul', 'id_users', 'id_modul', 'nama_modul', 'priority');
//$crud->set_relation('salesRepEmployeeNumber','employees','lastName');
$output = $crud->render();
$data['subject'] = 'Pengaturan Pengguna';
$data['content'] = $this->load->view('crud.php', $output, true);
$this->load->view('base_theme', $data);
}
/**
* Index Page for CRUD sample controller.
*/
public function index()
{
if (!$this->ion_auth->logged_in()) {
redirect('auth/login', 'refresh');
}
$data['page_title'] = 'Crud sample';
$this->load->library('grocery_CRUD');
$crud = new grocery_CRUD();
$crud->set_table('items');
$crud->fields('name', 'updated', 'description', 'published');
$crud->required_fields('name');
$crud->field_type('updated', 'invisible');
$crud->unset_jquery();
$crud->set_theme('flexigrid-bootstrap3');
$crud->callback_before_update(array($this, '_crud_index_before_insert_or_update'));
$crud->callback_before_insert(array($this, '_crud_index_before_insert_or_update'));
$data = array_merge($data, (array) $crud->render());
$this->_make_layout('crud', $data);
}
/**
* Función para contruir el Grocecy CRUD de la tabla Usuarios
*/
function abm_usuarios()
{
//Defino submenu
$this->menu['submenuSeleccionado'] = 'Usuarios';
//Creo el objeto crud
$crud = new grocery_CRUD();
//Defino Template como datatables.
//$crud->set_theme('datatables');
//Defino tabla sobre la que trabajo y tipo de 'Objeto'
$crud->set_table('Usuarios');
$crud->set_subject('Usuario');
//Agrego acción para cambiar contraseña.
$crud->add_action('Cambiar Contraseña', base_url() . 'assets/grocery_crud/themes/flexigrid/css/images/key.png', 'administracion/usuarios/cambiar_contrasena');
//Un usuario puede tener un idPersonal asociado.
$crud->set_relation('idPersonal', 'Personal', 'nombreApellido');
//Relación con los roles.
$crud->set_relation_n_n('roles', 'RolesPorUsuario', 'Roles', 'idUsuario', 'idRol', 'descripcion');
//Seteo Reglas para campos
$crud->set_rules('contrasena', 'Contraseña', 'required|matches[repetirContrasena]');
$crud->add_fields('nombreUsuario', 'contrasena', 'repetirContrasena', 'roles', 'idPersonal');
$crud->edit_fields('roles', 'idPersonal');
$crud->field_type('contrasena', 'password');
$crud->field_type('repetirContrasena', 'password');
//Seteo campos requeridos
$crud->required_fields('nombreUsuario', 'contrasena', 'repetirContrasena', 'roles');
//Defino Columnas a Mostrar
$crud->columns('nombreUsuario', 'roles');
//Defino nombres para cada campo.
$crud->display_as('nombreUsuario', 'Nombre de Usuario');
$crud->display_as('contrasena', 'Contraseña');
$crud->display_as('repetirContrasena', 'Repetir Contraseña');
$crud->display_as('roles', 'Roles');
$crud->display_as('idPersonal', 'Persona Asociada');
//Hago 'callbacks' para transformar datos antes de inserción/actualización.
$crud->callback_before_insert(array($this, '_transformar_datos'));
$crud->callback_before_update(array($this, '_transformar_datos_update'));
//Genero el ABM
$output = $crud->render();
//Llamo a la función encargada de mostrar el ABM.
mostrar_crud($output, '', $this->menu, 'administracion/usuarios/abm_usuarios', '', 'administracion/usuarios/abm_usuarios_final');
}
public function listarUsuariosAdministradores()
{
$adm = $this->usuarios_model->buscarAdministrador($this->session->userdata('usuario'));
$administrador = array();
foreach ($adm as $dato) {
$administrador[$dato->usuario] = $dato->nombres;
}
$crud = new grocery_CRUD();
$crud->set_table('usuarios_backend');
$crud->columns('usuario', 'nombres', 'dni', 'correo', 'nivel', 'estado', 'codigo', 'autoriza', 'caduca', 'registro');
$crud->display_as('registroId', 'from usuarios_backend')->display_as('usuario', 'Usuario')->display_as('contrasena', 'Contraseña');
$crud->change_field_type('clave', 'password');
$crud->set_subject('Usuario');
$crud->field_type('nivel', 'dropdown', array('1' => 'Administrador', '2' => 'Operador'));
$crud->field_type('estado', 'dropdown', array('1' => 'Activo', '2' => 'Inactivo'));
$crud->field_type('autoriza', 'dropdown', $administrador);
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->unset_read();
$output = $crud->render();
$this->_example_output($output);
}
public function article()
{
$crud = new grocery_CRUD();
$crud->set_table('blog_article');
$crud->columns('article_title', 'content', 'Categories', 'author_user_id', 'date', 'allow_comment');
$crud->edit_fields('article_title', 'article_url', 'content', 'Categories', 'date', 'author_user_id', 'allow_comment');
$crud->add_fields('article_title', 'article_url', 'content', 'Categories', 'date', 'author_user_id', 'allow_comment');
$crud->display_as('article_title', 'Title')->display_as('article_url', 'URL')->display_as('content', 'Content')->display_as('date', 'Date Created')->display_as('author_user_id', 'Author');
$crud->set_subject('Article');
$crud->callback_before_insert(array($this, 'before_insert_article'));
$crud->callback_before_update(array($this, 'before_insert_article'));
$crud->set_relation_n_n('Categories', 'blog_category_article', 'blog_category', 'article_id', 'category_id', 'category_name');
$crud->set_relation('author_user_id', 'cms_user', 'real_name');
$crud->change_field_type('author_user_id', 'hidden');
$crud->change_field_type('date', 'hidden');
$crud->change_field_type('article_url', 'hidden');
$crud->change_field_type('allow_comment', 'true_false');
$crud->add_action('Photos', base_url() . 'modules/blog/assets/images/photo.png', 'blog/photo');
$crud->add_action('Comments', base_url() . 'modules/blog/assets/images/comment.png', 'blog/comment');
$output = $crud->render();
$this->view('grocery_CRUD', $output, 'blog_article');
}
/**
* function ni digunakan untuk kv urus maklumat kursus kolej pada crud
* input: -
* author: Mior Mohd Hanif
* Date: 28 Jun 2013
* Modification Log: 4 Julai 2013 by Mior - fixed bug insert
* 18 Julai 2013 by Mior - fixed bug before insert and update
*/
function college_course_management()
{
$user_login = $this->ion_auth->user()->row();
$col_id = $user_login->col_id;
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_subject('Kursus Kolej');
$crud->set_table('college_course');
$crud->set_relation('cou_id', 'course', '{cou_course_code} - {cou_name}');
$crud->columns('cou_course_code', 'cou_name', 'cou_cluster');
$crud->callback_column('cou_course_code', array($this, '_callback_cou_course_code'));
$crud->callback_column('cou_name', array($this, '_callback_cou_name'));
$crud->callback_column('cou_cluster', array($this, '_callback_cou_cluster'));
$crud->display_as('cou_id', 'Kursus')->display_as('cou_course_code', 'Kod Kursus')->display_as('cou_name', 'Nama Kursus')->display_as('cou_cluster', 'Kluster');
$crud->required_fields('cou_id');
$crud->field_type('col_id', 'invisible');
$crud->callback_before_insert(array($this, 'callback_col_id'));
$crud->callback_before_update(array($this, 'callback_col_id'));
$crud->where('col_id', $col_id);
$output = $crud->render();
$header = "<legend><h4>Penyelenggaraan Kursus Kolej</h4></legend>";
$this->_main_output($output, $header);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables')->set_table('user')->set_subject('User');
/*
* This is a sample callback function in groceryCRUD.
* What it does is, if a user updates a record in `user` table.
* Before it updates a particular record in the table,
* it first run a function and then do the update query.
**/
$crud->callback_before_update(function ($post_array) {
$post_array['password'] = $this->encryption->encrypt($post_array['password']);
return $post_array;
// You need to return it, so that it will receive the edited $post_array value
});
$output = $crud->render();
$this->load->view('admin/admin_header_view', $output);
$this->load->view('admin/admin_main_view');
if ($this->session->is_admin && $this->session->is_admin_loggedin) {
$this->load->view('admin/admin_profile_view', $output);
}
$this->load->view('admin/admin_footer_view');
}
public function user()
{
$this->load->model('login_model');
if ($this->__check_auth()) {
if ($this->login_model->get_access_level() >= 10) {
try {
// new object
$crud = new grocery_CRUD();
// sets table to use
$crud->set_table('user');
$crud->set_subject('Utilisateur');
// callbacks for password editing
$crud->callback_edit_field('password_hash', array($this, '__clean_field'));
$crud->callback_before_insert(array($this, '__password_user_before_insert'));
$crud->callback_before_update(array($this, '__password_user_before_update'));
// links foreign keys
$crud->set_relation('user_type_id', 'user_type', 'name');
$crud->set_relation('user_state_id', 'user_state', 'name');
$crud->set_relation('department_id', 'department', 'name');
// renders the table in output
$output = $crud->render();
// sets some text to determine which table is edited
$output->current = 'Utilisateur';
// display all
$this->_view_output($output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
} else {
show_error('L\'utilisateur n\'a pas les privilèges nécessaires.');
die;
}
} else {
// if not authentified send back to login
redirect('login');
}
}
function users()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('user');
$crud->display_as('login', 'Username');
$crud->display_as('user_name', 'Name');
$crud->set_subject('User');
$crud->columns('login', 'user_type', 'user_name', 'email', 'mobile');
$crud->required_fields('login', 'user_type', 'user_name', 'email', 'mobile');
$crud->set_rules('email', 'Email', 'trim|required|valid_email');
$crud->change_field_type('password', 'password');
// Cripatare password
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_edit_field('password', array($this, 'set_password_input_to_empty'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
//$crud->callback_edit_field('password',array($this,'decrypt_password_callback'));
// Realatii baza de date
//$crud->set_relation('grup','grup','grup_name');
//$crud->set_field_upload('imagine_monitor','assets/uploads/files');
$crud->field_type('user_type', 'dropdown', array('admin' => 'admin', 'user' => 'user'));
$output = $crud->render();
$this->_admin_output($output);
}
function campa_dependencia($id)
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_campa');
$crud->set_subject('campa');
$crud->set_language('spanish');
$crud->fields('nombre', 'anio', 'tema', 'tipo', 'clasificacion_campa', 'etiquetas', 'objetivo', 'periodicidad_inicio', 'periodicidad_fin', 'depen', 'costo_total', 'status');
$crud->columns('nombre', 'anio', 'periodicidad_inicio', 'periodicidad_fin', 'dependencia_aux', 'costo_total', 'monto_gastado');
$crud->edit_fields('nombre', 'anio', 'tema', 'tipo', 'clasificacion_campa', 'etiquetas', 'objetivo', 'periodicidad_inicio', 'periodicidad_fin', 'depen', 'costo_total', 'status');
$crud->display_as('anio', 'Año')->display_as('periodicidad_inicio', 'Inicio')->display_as('periodicidad_fin', 'Fin')->display_as('dependencia_aux', 'Dependencia')->display_as('status', 'Estatus')->display_as('depen', 'Dependencia')->display_as('costo_total', 'Costo estimado (variable no pública)')->display_as('clasificacion_campa', 'Categoría de la campaña')->display_as('etiquetas', 'Etiquetas (separado por comas)');
$crud->callback_column('dependencia_aux', array($this, 'hacer_vinculo_dependencia_campa'));
$crud->callback_column('monto_gastado', array($this, 'obtener_monto_gastado'));
$crud->callback_column('costo_total', array($this, 'formato_dinero_costo_total'));
$crud->required_fields('nombre', 'anio', 'tema', 'depen', 'tipo', 'clasificacion_campa', 'objetivo', 'periodicidad_inicio', 'periodicidad_fin', 'costo_total', 'status');
$crud->callback_edit_field('depen', array($this, 'editar_dependencia_solicitante'));
$crud->callback_edit_field('anio', array($this, 'editar_anio_campa'));
$crud->callback_edit_field('etiquetas', array($this, 'editar_etiquetas'));
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$crud->set_rules('costo_total', 'Costo de la campaña', 'integer');
$crud->where('depen', $id);
$crud->set_relation('tipo', 'tp_tipo_campa', 'tipo');
$crud->set_relation('clasificacion_campa', 'tp_clasificacion_campa', 'descripcion_clasificacion', null, 'id_clasificacion_campa');
$crud->set_relation('depen', 'tp_dependencia', 'dependencia');
$crud->set_relation('status', 'tp_status_campa', 'status');
$crud->add_action('Banners de la campaña', base_url() . 'imagenes/banners.png', '', '', array($this, 'modificar_url_banners'));
$crud->add_action('Facturas de la campaña', base_url() . 'imagenes/facturas.png', '', '', array($this, 'modificar_url_facturas'));
$crud->add_action('Videos de la campaña', base_url() . 'imagenes/videos.png', '', '', array($this, 'modificar_url_videos'));
$crud->add_action('Audios de la campaña', base_url() . 'imagenes/audios.png', '', '', array($this, 'modificar_url_audios'));
$crud->add_action('ver todos los datos', base_url() . 'imagenes/lupa.gif', '', '', array($this, 'modificar_url_detalle_registro'));
$crud->callback_before_delete(array($this, 'eliminar_campa'));
$crud->callback_before_update(array($this, 'actualizar_etiquetas'));
$output = $crud->render();
$data['opcion'] = 'campa';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$dependencia = $this->modelo->obtener_nombre_dependencia($id);
$data['opcion_campa'] = 'campas_dependencia';
$data['dependencia'] = $dependencia;
$this->load->view('opciones_campa', $data);
$this->load->view('campa', $output);
$data['campa_dependencia'] = '';
$data['id'] = $id;
$this->load->view('opciones_banner_imagen_otros', $data);
$this->load->view('regresar');
$this->load->view('pie');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function _set_common_report_crud($columns)
{
$crud = new grocery_CRUD();
// default columns excludes: token address_id simply because FMS/FMS-endpoint doesn't use them
$default_columns = array('report_id', 'status', 'requested_datetime', 'priority', 'category_id', 'external_id', 'media_url', 'status_notes', 'description', 'agency_responsible', 'service_notice', 'updated_datetime', 'expected_datetime', 'address', 'postal_code', 'lat', 'long', 'email', 'device_id', 'source_client', 'account_id', 'first_name', 'last_name', 'phone', 'engineer');
$columns = $columns ? $columns : $default_columns;
foreach ($columns as &$colname) {
if ($colname == 'report_id') {
$colname = 'xxx_report_id';
}
}
$crud->columns($columns);
$crud->edit_fields($default_columns);
$crud->set_theme('flexigrid');
$crud->set_table('reports');
$crud->set_subject('Problem report');
$crud->set_relation('category_id', 'categories', 'category_name', null, 'category_name ASC');
$crud->set_relation('priority', 'priorities', '<span class="fmse-prio fmse-prio{prio_value}">{prio_name}</span>', null, 'prio_value ASC');
$crud->set_relation('status', 'statuses', '<span class="fmse-status-{is_closed}">{status_name}</span>', null, 'status_name ASC');
$crud->set_relation('source_client', 'open311_clients', '<a href="/admin/open311_clients/{id}">{name}</a>', null, 'name ASC');
$crud->display_as('client_id', 'Client');
$crud->callback_column('media_url', array($this, '_linkify'));
$crud->callback_column('external_id', array($this, '_get_external_url'));
$crud->callback_edit_field('media_url', array($this, '_text_media_url_field'));
$crud->display_as('requested_datetime', 'Received')->display_as('updated_datetime', 'Updated')->display_as('expected_datetime', 'Expected')->display_as('category_id', 'Category')->display_as('media_url', 'Media URL');
$external_id_col_name = config_item('external_id_col_name');
$crud->display_as('external_id', empty($external_id_col_name) ? 'External ID' : $external_id_col_name);
$crud->unset_texteditor('address', 'status_notes', 'service_notice');
$crud->add_action('View', '/assets/fms-endpoint/images/report.png', 'admin/report');
$crud->callback_column('xxx_report_id', array($this, '_report_id_link_field'));
$crud->display_as('xxx_report_id', 'ID');
$crud->callback_edit_field('xxx_report_id', array($this, '_read_only_report_id_field'));
$crud->callback_before_update(array($this, '_fix_zero_prio_callback'));
$crud->callback_after_update(array($this, '_check_for_status_update_after'));
return $crud;
}
function myaccount()
{
$crud = new grocery_CRUD();
$crud->set_table('tbl_admin');
$crud->where('matrix_id', $this->session->userdata('matrix_id'));
$crud->set_subject('Password');
$crud->unset_delete();
$crud->unset_add();
$crud->required_fields('matrix_id');
$crud->columns('matrix_id', 'role');
$crud->fields('password');
$crud->callback_field('password', array($this, 'password_field_callback'));
$crud->callback_before_update(array($this, 'encode_password_callback'));
$crud->display_as('password', 'New Password');
$data['title'] = "Change Password";
$data['crud'] = $crud->render();
$this->template->load('admin/theme', 'admin/manage_crud', $data);
}
public function pesan()
{
try {
$status = $this->input->get("status");
$crud = new grocery_CRUD();
if (isset($status) and !empty($status)) {
$crud->where('tbl_pertanyaan_user.status', $status);
}
$crud->set_table('tbl_pertanyaan_user');
$crud->set_subject('Pesan');
$crud->set_relation('change_by', 'tbl_user', 'email');
$crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}');
$crud->required_fields('jawaban');
$crud->fields('id_user', 'judul', 'pertanyaan', 'jawaban', 'status', 'change_by', 'change_date');
$crud->columns('id_user', 'judul', 'pertanyaan', 'status');
$crud->display_as("id_user", "Penanya");
$crud->callback_before_update(array($this, 'get_change_by_callback'));
$crud->callback_before_insert(array($this, 'get_change_by_callback'));
$crud->callback_field('change_date', array($this, 'format_date_callback'));
$crud->change_field_type('id_user', 'readonly');
$crud->change_field_type('judul', 'readonly');
$crud->change_field_type('pertanyaan', 'readonly');
$crud->change_field_type('change_by', 'readonly');
$crud->change_field_type('change_date', 'readonly');
$crud->unset_export();
$crud->unset_print();
$crud->unset_save();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
$crud->order_by('id_pertanyaan_user', 'desc');
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_pegawai', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('agents');
$crud->set_subject('Agents');
$crud->unset_fields('agent_id');
$crud->unset_columns('agent_id');
// $crud->unset_columns('package_thingsToConsider');
// $crud->unset_columns('package_weatherCondition');
// $crud->unset_columns('package_itinerary');
//
$crud->display_as('agent_companyName', 'Company Name');
$crud->display_as('agent_companyRegNo', 'Reg. No.');
$crud->display_as('agent_country', 'Country');
$crud->display_as('agent_state', 'State');
$crud->display_as('agent_city', 'City');
$crud->display_as('agent_street', 'Street');
$crud->display_as('agent_suburb', 'Suburb');
$crud->display_as('agent_postCode', 'Post Code');
$crud->display_as('agent_phoneNumber', 'Phone Number');
$crud->display_as('agent_emailId', 'Email ID');
$crud->display_as('agent_website', 'Website');
$crud->display_as('agent_facebook', 'Facebook');
$crud->display_as('agent_firstName', 'First Name');
$crud->display_as('agent_lastName', 'Last Name');
$crud->display_as('agent_position', 'Position');
$crud->display_as('agent_mobile', 'Mobile');
$crud->display_as('agent_type', 'Agent Type');
$crud->display_as('agent_status', 'Status');
$crud->unset_texteditor('agent_notes', 'full_text');
$crud->change_field_type('agent_notes', 'text');
// $crud->set_field_upload('package_image', $this->upload_path);
// $crud->unique_fields('package_slug');
//
// $crud->set_relation('hotel_agent_id', '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('agent_status', array($this, 'set_change_status'));
// $crud->unset_columns('agent_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->callback_before_update(array($this, "_change_status_after_update"));
$crud->unset_add();
$crud->unset_delete();
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Agents', 'pagedesc' => 'Agents', 'contenttitle' => 'Agents List Records');
// redirect(base_url());
$this->load->view('gc_admin_wrapper', $data);
}
public function index()
{
try {
// General
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->set_table('sos_femme');
if (!$this->session->userdata('status')) {
$crud->where('archiver', FALSE);
}
$crud->set_subject('Femme');
//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('age', 'sos_gen_femme_age', 'name_femme_age');
$crud->set_relation('duree_de_la_relation', 'sos_gen_duree_de_la_relation', 'name_duree_de_la_relation', null, 'id_duree_de_la_relation ASC');
$crud->set_relation('service', 'sos_gen_service', 'nom_service', null, 'nom_service DESC');
$crud->set_relation('ville', 'sos_gen_villes', '{nom_ville}, {code_postal}', null, 'nom_ville ASC');
$crud->set_relation('pays', 'sos_gen_pays', '{nom_pays} - {continent}', null, 'nom_pays ASC');
$crud->set_relation('nationalite', 'sos_gen_nationalite', 'name_nationalite');
$crud->set_relation('nationalite_detailles', 'sos_gen_nationalite_detailles', 'name_nationalite_detailles');
$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('logement', 'sos_gen_logement_parent', 'name_logement');
$crud->set_relation('logement_detailles', 'sos_gen_logement_child', 'name_logement_child');
$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('partenaire', 'sos_gen_partenaire', 'name_partenaire');
$crud->set_relation('informations', 'sos_gen_informations', 'name_informations');
$crud->set_relation('rdv', 'sos_gen_rdv', 'name_rdv');
$crud->set_relation('hebergement', 'sos_gen_hebergement', 'name_hebergement');
$crud->set_relation('departs_anterieurs', 'sos_gen_departs_anterieurs', 'name_departs_anterieurs');
$crud->set_relation('depuis', 'sos_gen_depuis', 'name_depuis');
//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', '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_nationalite = array('nationalite' => array('table_name' => 'sos_gen_nationalite', 'title' => 'name_nationalite', 'relate' => null), 'nationalite_detailles' => array('table_name' => 'sos_gen_nationalite_detailles', 'title' => 'name_nationalite_detailles', 'id_field' => 'id_nationalite_detailles', 'relate' => 'id_from_nationalite', 'data-placeholder' => 'Préciser'));
$config_nationalite = array('main_table' => 'sos_femme', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'segment_name' => "nationalite");
$categories_nationalite = new gc_dependent_select($crud, $fields_nationalite, $config_nationalite);
$js_nationalite = $categories_nationalite->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', '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', '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', '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();
$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();
//Visual
if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') {
$crud->columns('prenom', 'nom', 'nom_marital', 'age', 'date_naissance', 'telephone', 'ville', 'nombre_denfants', 'ouvertures', 'premier_contact', 'nombre_passages');
} else {
$crud->columns('archiver', 'prenom', 'nom', 'nom_marital', 'age', 'date_naissance', 'telephone', 'ville', 'nombre_denfants', 'ouvertures', 'premier_contact', 'nombre_passages');
}
$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')->display_as('nombre_passages', 'Nombre passages')->display_as('arrivee_en_france', 'Arrivée en France')->display_as('parle_pas_francais', 'Parle pas français')->display_as('ism', 'Utilisation ISM');
$crud->order_by('prenom', 'asc');
//unsets
if ($this->session->userdata('status') == '1' or $this->session->userdata('status') == '2' or $this->session->userdata('status') == '3') {
$crud->unset_edit_fields('service', 'par', 'archiver');
} else {
$crud->unset_edit_fields('service', 'premier_contact', 'par');
}
$crud->unset_add_fields('par', 'archiver');
if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') {
$crud->unset_delete();
$crud->unset_export();
$crud->unset_print();
}
//Requireds
$crud->required_fields('service', 'premier_contact', 'prenom');
//Callbacks
$crud->callback_column('ouvertures', array($this, 'ouvertures'));
$crud->callback_column('premier_contact', array($this, 'premier_contact'));
$crud->callback_column('nombre_denfants', 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_column('nombre_passages', array($this, 'nombre_passages'));
$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'));
$crud->field_type('arrivee_en_france', 'dropdown', range(date("Y"), date("Y") - 50));
$crud->field_type('parle_pas_francais', 'enum', array('OUI', 'NON'));
$crud->field_type('ism', 'multiselect', array("1" => "Ponctuel", "2" => "Systématique", "3" => "Venu physiquement"));
// Actions
$crud->add_action('Enfants', '', 'kids/kids_window', 'ui-icon-person');
$crud->add_action('Intervention', '', 'demande/demande_window', 'ui-icon-home');
$crud->add_action('Profil', '', 'show/show_window', 'ui-icon-print');
$crud->add_action('Violences', '', 'violence/violence_window', 'ui-icon-alert');
$crud->add_action('Démarches', '', 'demarche/demarche_window', 'ui-icon-gear');
if ($this->session->userdata('status') != '0') {
$crud->add_action('Psy', '', 'psy/psy_window', 'ui-icon-comment');
}
$crud->add_action('Documents', '', 'upload/upload_window', 'ui-icon-document');
// Renders
$output = $crud->render();
$output->output .= $js_situation_familialle . $js_emplois . $js_nationalite . $js_ressources . $js_allocations_familiales . $js_logement . $js_situation_actuelle;
$menu = new stdClass();
$menu->n0 = 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());
}
}
function user_owner()
{
if ($this->session->userdata('perfil') == 'admin') {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('usuarios');
$crud->set_subject('Dueños de talleres');
$crud->columns('id_taller', 'usuario_nombres', 'usuario_mail', 'usuario_telf');
//$crud->fields('usuario_nombres', 'usuario_usuario', 'usuario_password','usuario_mail', 'usuario_telf');
//$crud->change_field_type('id_taller', 'hidden', );
$crud->change_field_type('usuario_perfil', 'hidden', 'owner');
$crud->change_field_type('id_sucursales', 'hidden', '0');
$crud->required_fields('usuario_nombres', 'id_taller', 'usuario_usuario', 'usuario_mail', 'usuario_telf');
$crud->display_as('usuario_nombres', 'Nombres dueño');
$crud->display_as('usuario_usuario', 'Login');
$crud->display_as('usuario_mail', 'Mail');
$crud->display_as('usuario_telf', 'Telf.');
$crud->display_as('usuario_password', 'Password');
$crud->display_as('id_taller', 'Nombre Taller');
$crud->change_field_type('usuario_password', 'password');
$crud->unset_read();
$crud->callback_edit_field('usuario_password', array($this, 'set_password_input_to_empty'));
$crud->callback_add_field('usuario_password', array($this, 'set_password_input_to_empty'));
$crud->set_relation('id_taller', 'talleres', 'taller_nombre');
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_edit_field('usuario_perfil', array($this, 'set_user_owner'));
$crud->callback_add_field('usuario_perfil', array($this, 'set_user_owner'));
//$crud->callback_edit_field('id_taller',array($this,'set_admin_taller'));
//$crud->callback_add_field('id_taller',array($this,'set_admin_taller'));
$crud->where('usuario_perfil =', 'owner');
$output = $crud->render();
$output->op = 'user_management';
$this->_example_output($output);
//$data['titulo'] = 'Bienvenido Administrador';
//$this->load->view('admin_view',$data);
} else {
$this->close();
}
}
function user_managervehicle()
{
if ($this->userconfig->perfil == 'ADMIN' or $this->userconfig->perfil == 'CALL') {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('usuarios');
$crud->set_subject('Rutas');
//$crud->columns('nombre','idsucursal','codigo','pais','departamento','ciudad','direccion','telefono','perfil');
$crud->columns('idsucursal', 'nombre');
$crud->fields('idsucursal', 'nombre', 'codigo', 'pais', 'departamento', 'ciudad', 'perfil');
$crud->required_fields('idsucursal', 'nombre', 'perfil');
$crud->display_as('nombre', 'Ruta');
$crud->change_field_type('perfil', 'hidden');
$crud->change_field_type('codigo', 'hidden');
$crud->change_field_type('pais', 'hidden');
$crud->change_field_type('departamento', 'hidden');
$crud->change_field_type('ciudad', 'hidden');
if ($this->userconfig->perfil == 'ADMIN') {
$crud->set_relation('idsucursal', 'sucursales', 'nombre');
} else {
$crud->set_relation('idsucursal', 'sucursales', 'nombre', 'id IN ("' . $this->userconfig->idsucursal . '")');
}
$crud->display_as('idsucursal', 'Sucursal');
$crud->callback_edit_field('perfil', array($this, 'set_user_cust'));
$crud->callback_add_field('perfil', array($this, 'set_user_cust'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_after_insert(array($this, 'set_code_rutas'));
$crud->where('perfil =', 'CUST');
$crud->order_by('idsucursal,nombre');
if ($this->userconfig->perfil != 'ADMIN') {
$crud->where('idsucursal =', $this->userconfig->idsucursal);
}
$output = $crud->render();
$output->op = 'user_management';
$this->_admin_output($output);
} else {
$this->close();
}
}
public function index()
{
try {
// General
$crud = new grocery_CRUD();
$crud->set_language("french");
$crud->set_theme('bootstrap');
$crud->set_table('sos_ecoute');
$crud->order_by('premier_contact', 'desc');
$crud->set_subject('Ecoute téléphonique');
//relations
$crud->set_relation('situation_familiale', 'sos_gen_situation_familiale_parrent', 'name_situation_familiale_parrent');
$crud->set_relation('emplois', 'sos_gen_emplois_parrent', 'name_emplois');
$crud->set_relation('age', 'sos_gen_femme_age', 'name_femme_age');
$crud->set_relation('duree_de_la_relation', 'sos_gen_duree_de_la_relation', 'name_duree_de_la_relation', null, 'id_duree_de_la_relation ASC');
$crud->set_relation('ville', 'sos_gen_villes', '{nom_ville}, {code_postal}', null, 'nom_ville ASC');
$crud->set_relation('nationalite', 'sos_gen_nationalite', 'name_nationalite');
$crud->set_relation('ressources', 'sos_gen_ressources', 'name_ressources');
$crud->set_relation('allocations_familiales', 'sos_gen_allocations_familiales', 'name_allocations_familiales');
$crud->set_relation('logement', 'sos_gen_logement_parent', 'name_logement');
$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('partenaire', 'sos_gen_partenaire', 'name_partenaire');
$crud->set_relation('informations', 'sos_gen_informations', 'name_informations');
$crud->set_relation('rdv', 'sos_gen_rdv', 'name_rdv');
$crud->set_relation('hebergement', 'sos_gen_hebergement', 'name_hebergement');
$crud->set_relation('depuis', 'sos_gen_depuis', 'name_depuis');
$crud->set_relation('temps_ecoute', 'sos_gen_temps_ecoute', 'name_temps_ecoute', null, 'id_temps_ecoute ASC');
$crud->set_relation('interlocuteur', 'sos_gen_interlocuteur', 'name_interlocuteur', null, 'id_interlocuteur ASC');
$crud->set_relation('appel', 'sos_gen_appel', 'name_appel', null, 'id_appel ASC');
$crud->set_relation('frequence', 'sos_gen_frequence', 'name_frequence');
$crud->set_relation('commencement', 'sos_gen_commencement', 'name_commencement');
$crud->set_relation_n_n('violences_physiques', 'sos_relation_violences_physiques_ecoute', 'sos_gen_violences_physiques', 'id_from_violences', 'id_from_violences_physiques', 'name_violences_physiques', 'priority');
$crud->set_relation_n_n('violences_psychologiques', 'sos_relation_violences_psychologiques_ecoute', 'sos_gen_violences_psychologiques', 'id_from_violences', 'id_from_violences_psychologiques', 'name_violences_psychologiques', 'priority');
$crud->set_relation_n_n('violences_sexuelles', 'sos_relation_violences_sexuelles_ecoute', 'sos_gen_violences_sexuelles', 'id_from_violences', 'id_from_violences_sexuelles', 'name_violences_sexuelles', 'priority');
$crud->set_relation_n_n('violences_economiques', 'sos_relation_violences_economiques_ecoute', 'sos_gen_violences_economiques', 'id_from_violences', 'id_from_violences_economiques', 'name_violences_economiques', 'priority');
$crud->set_relation_n_n('violences_administratives', 'sos_relation_violences_administratives_ecoute', 'sos_gen_violences_administratives', 'id_from_violences', 'id_from_violences_administratives', 'name_violences_administratives', 'priority');
$crud->set_relation_n_n('violences_sociales', 'sos_relation_violences_sociales_ecoute', 'sos_gen_violences_sociales', 'id_from_violences', 'id_from_violences_sociales', 'name_violences_sociales', 'priority');
$crud->set_relation_n_n('violences_privations', 'sos_relation_violences_privations_ecoute', 'sos_gen_violences_privations', 'id_from_violences', 'id_from_violences_privations', 'name_violences_privations', 'priority');
$crud->set_relation_n_n('violences_juridiques', 'sos_relation_violences_juridiques_ecoute', 'sos_gen_violences_juridiques', 'id_from_violences', 'id_from_violences_juridiques', 'name_violences_juridiques', 'priority');
$crud->set_relation_n_n('de_la_part', 'sos_relation_de_la_part_ecoute', 'sos_gen_de_la_part', 'id_from_violences', 'id_from_de_la_part', 'name_de_la_part');
$crud->set_relation_n_n('raisons', 'sos_relation_raisons_ecoute', 'sos_gen_raisons', 'id_from_violences', 'id_from_raisons', 'name_raisons');
$crud->set_relation_n_n('violences_enfants_directes', 'sos_relation_violences_enfants_directes_ecoute', 'sos_gen_violences_enfants_directes', 'id_from_violences', 'id_from_violences_enfants_directes', 'name_violences_enfants_directes', 'priority');
$crud->set_relation_n_n('violences_enfants_indirectes', 'sos_relation_violences_enfants_indirectes_ecoute', 'sos_gen_violences_enfants_indirectes', 'id_from_violences', 'id_from_violences_enfants_indirectes', 'name_violences_enfants_indirectes', 'priority');
$crud->set_relation_n_n('de_la_part_enfants', 'sos_relation_de_la_part_enfants_ecoute', 'sos_gen_de_la_part_enfants', 'id_from_violences', 'id_from_de_la_part_enfants', 'name_de_la_part_enfants');
$crud->set_relation_n_n('consequences_physiques', 'sos_relation_consequences_physiques_ecoute', 'sos_gen_consequences_physiques', 'id_from_violences', 'id_from_consequences_physiques', 'name_consequences_physiques', 'priority');
$crud->set_relation_n_n('consequences_psychologiques', 'sos_relation_consequences_psychologiques_ecoute', 'sos_gen_consequences_psychologiques', 'id_from_violences', 'id_from_consequences_psychologiques', 'name_consequences_psychologiques', 'priority');
$crud->set_relation_n_n('consequences_administratives', 'sos_relation_consequences_administratives_ecoute', 'sos_gen_consequences_administratives', 'id_from_violences', 'id_from_consequences_administratives', 'name_consequences_administratives', 'priority');
//Master/child relations
$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_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/home/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', '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_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_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first');
$categories_demarche = new gc_dependent_select($crud, $fields_demarche, $config_demarche);
$js_demarche = $categories_demarche->get_js();
$fields_demarche1 = array('first1' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second1' => 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'), 'third1' => 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_demarche1 = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first1');
$categories_demarche1 = new gc_dependent_select($crud, $fields_demarche1, $config_demarche1);
$js_demarche1 = $categories_demarche1->get_js();
$fields_demarche2 = array('first2' => array('table_name' => 'sos_gen_demarche_first', 'title' => 'name_demarche_first', 'relate' => null), 'second2' => 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'), 'third2' => 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_demarche2 = array('main_table' => 'sos_ecoute', 'main_table_primary' => 'id_femme', "url" => base_url() . 'index.php/ecoute/index/', 'ajax_loader' => base_url() . 'img/ajax-loader.gif', 'segment_name' => 'first2');
$categories_demarche2 = new gc_dependent_select($crud, $fields_demarche2, $config_demarche2);
$js_demarche2 = $categories_demarche2->get_js();
$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('first1', 'sos_gen_demarche_first', 'name_demarche_first');
$crud->set_relation('second1', 'sos_gen_demarche_second', 'name_demarche_second');
$crud->set_relation('third1', 'sos_gen_demarche_third', 'name_demarche_third');
$crud->set_relation('first2', 'sos_gen_demarche_first', 'name_demarche_first');
$crud->set_relation('second2', 'sos_gen_demarche_second', 'name_demarche_second');
$crud->set_relation('third2', 'sos_gen_demarche_third', 'name_demarche_third');
//Visual
$crud->display_as('nationalite', 'Nationalité')->display_as('premier_contact', 'Date')->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('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('situation_actuelle_detailles', 'Situation actuelle détaillée')->display_as('emplois', 'Situation professionnelle')->display_as('commentaire', 'Commentaires')->display_as('partenaire', 'Orienteur')->display_as('rep_accueil', 'Réponse')->display_as('rep_informations', 'Réponse')->display_as('rep_conseil', 'Réponse')->display_as('rep_orientation', 'Réponse')->display_as('rep_rdv', 'Réponse')->display_as('rep_hebergement', 'Réponse')->display_as('rep_soutien', 'Réponse')->display_as('rep_aide_materielle', 'Réponse')->display_as('rep_ecoute', 'Réponse')->display_as('consequences', 'Conséquences')->display_as('consequences_administratives', 'Conséquences administratives et économiques')->display_as('violences_economiques', 'Violences économiques')->display_as('consequences_physiques', 'Conséquences physiques')->display_as('consequences_psychologiques', 'Conséquences psychologiques')->display_as('consequences_administratives', 'Conséquences administratives')->display_as('de_la_part_enfants', 'Violences sur enfants par')->display_as('temps_ecoute', "Temps d'écoute")->display_as('age', 'Age de la femme')->display_as('logement_dem', 'Demande de logement')->display_as('rep_logement_dem', 'Réponse')->display_as('violences_enfants_directes', 'ENFANTS - Violences directes')->display_as('violences_enfants_indirectes', 'ENFANTS - Violences indirectes')->display_as('frequence', 'Fréquence')->display_as('demandes', 'Demandes/Réponses');
$crud->display_as('first', 'Type de démarche 1');
$crud->display_as('second', 'Type d\'intervention 1');
$crud->display_as('third', 'Suites 1');
$crud->display_as('first1', 'Type de démarche 2');
$crud->display_as('second1', 'Type d\'intervention 2');
$crud->display_as('third1', 'Suites 2');
$crud->display_as('first2', 'Type de démarche 3');
$crud->display_as('second2', 'Type d\'intervention 3');
$crud->display_as('third2', 'Suites 3');
$crud->display_as('demarche', 'Démarches');
//unsets
if ($this->session->userdata('status') == '1' or $this->session->userdata('status') == '2' or $this->session->userdata('status') == '3') {
$crud->fields('premier_contact', 'interlocuteur', 'appel', 'partenaire', 'temps_ecoute', 'age', 'enfants', 'enceinte', 'ville', 'nationalite', 'situation_familiale', 'depuis', 'duree_de_la_relation', 'emplois', 'logement', 'situation_actuelle', 'situation_actuelle_detailles', 'situation_actuelle_depuis', 'ressources', 'allocations_familiales', 'dettes', 'soutien', 'rep_soutien', 'ecoute', 'rep_ecoute', 'accueil', 'rep_accueil', 'informations', 'rep_informations', 'conseil', 'rep_conseil', 'orientation', 'rep_orientation', 'rdv', 'rep_rdv', 'hebergement', 'rep_hebergement', 'logement_dem', 'rep_logement_dem', 'aide_materielle', 'rep_aide_materielle', 'violences_physiques', 'violences_psychologiques', 'violences_sexuelles', 'violences_economiques', 'violences_administratives', 'violences_sociales', 'violences_privations', 'violences_juridiques', 'de_la_part', 'raisons', 'violences_enfants_directes', 'violences_enfants_indirectes', 'de_la_part_enfants', 'consequences_physiques', 'consequences_psychologiques', 'consequences_administratives', 'frequence', 'commencement', 'first', 'second', 'third', 'first1', 'second1', 'third1', 'first2', 'second2', 'third2', 'commentaire');
} else {
$crud->fields('interlocuteur', 'appel', 'partenaire', 'temps_ecoute', 'age', 'enfants', 'enceinte', 'ville', 'nationalite', 'situation_familiale', 'depuis', 'duree_de_la_relation', 'emplois', 'logement', 'situation_actuelle', 'situation_actuelle_detailles', 'situation_actuelle_depuis', 'ressources', 'allocations_familiales', 'dettes', 'soutien', 'rep_soutien', 'ecoute', 'rep_ecoute', 'accueil', 'rep_accueil', 'informations', 'rep_informations', 'conseil', 'rep_conseil', 'orientation', 'rep_orientation', 'rdv', 'rep_rdv', 'hebergement', 'rep_hebergement', 'logement_dem', 'rep_logement_dem', 'aide_materielle', 'rep_aide_materielle', 'violences_physiques', 'violences_psychologiques', 'violences_sexuelles', 'violences_economiques', 'violences_administratives', 'violences_sociales', 'violences_privations', 'violences_juridiques', 'de_la_part', 'raisons', 'violences_enfants_directes', 'violences_enfants_indirectes', 'de_la_part_enfants', 'consequences_physiques', 'consequences_psychologiques', 'consequences_administratives', 'frequence', 'commencement', 'first', 'second', 'third', 'first1', 'second1', 'third1', 'first2', 'second2', 'third2', 'commentaire');
}
$crud->unset_add_fields('par');
if ($this->session->userdata('status') == '0' or $this->session->userdata('status') == '4') {
$crud->unset_delete();
$crud->unset_export();
$crud->unset_print();
}
//Requireds
$crud->required_fields('premier_contact', 'appel', 'temps_ecoute', 'interlocuteur');
$crud->columns('premier_contact', 'infos', 'situation', 'demandes', 'violences', 'de_la_part', 'commencement', 'consequences', 'demarche');
//Callbacks
$crud->callback_column('ouvertures', array($this, 'ouvertures'));
$crud->callback_column('premier_contact', array($this, 'premier_contact'));
$crud->callback_column('infos', array($this, 'infos'));
$crud->callback_column('situation', array($this, 'situation'));
$crud->callback_column('demandes', array($this, 'demandes'));
$crud->callback_column('commentaire', array($this, 'commentaire'));
$crud->callback_column('demarche', array($this, 'demarche'));
$crud->callback_after_update(array($this, 'insert_after_update'));
$crud->callback_after_insert(array($this, 'insert_after_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->callback_column('de_la_part', array($this, 'de_la_part'));
$crud->callback_column('raisons', array($this, 'raisons'));
$crud->callback_column('violences', array($this, 'violences'));
$crud->callback_column('consequences', array($this, 'consequences'));
//field Types
//$crud->callback_edit_field('accueil', array($this, 'edit_field_callback_1'));
//$crud->callback_add_field('accueil', array($this, 'add_field_callback_1'));
//field Types
$crud->field_type('dettes', 'enum', array('OUI', 'NON'));
$crud->field_type('enceinte', 'enum', array('OUI', 'NON'));
// $crud->field_type('appel', 'dropdown', array('0' => '', '1' => '1er appel', '2' => 'Appel suivi', '3' => 'Autres appels'));
$crud->field_type('enfants', 'enum', array('Aucun', '1 enfant', '2 enfants', '3 enfants', '4 enfants', '5 et +'));
// $crud->field_type('interlocuteur', 'dropdown', array('0' => '', '1' => 'Elle-même', '2' => 'Professionnel', '3' => 'Entourage'));
// Actions
// Renders
$output = $crud->render();
$output->output .= $js_situation_actuelle . $js_demarche . $js_demarche1 . $js_demarche2;
$menu = new stdClass();
$menu->status = $this->session->userdata('status');
if ($menu->status != 5) {
$menu->n1 = true;
} else {
$menu->n0 = 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 callback_before_update($callback = null,$override_all=0){
if(!$override_all){
$this->callback_before_update_ext[] = $callback;
if($this->callback_before_update == null){
$this->callback_before_update = array($this,'extended_callback_before_update');
}
}else{
parent::callback_before_update($callback);
}
return $this;
}
public function kegiatan_lama()
{
$status = $this->input->get("status");
$crud = new grocery_CRUD();
$crud->where("tbl_kegiatan_transaksi.status", "Lama");
$crud->set_table('tbl_kegiatan_transaksi');
$crud->set_subject('Kegiatan Lama');
$crud->set_relation('change_by', 'tbl_user', 'email');
$crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}');
$crud->set_relation('id_kegiatan_butir', 'view_kegiatan_butir', '{unsur} - {subunsur} - {butir}');
$crud->set_primary_key('id_kegiatan_butir', 'view_kegiatan_butir');
$crud->required_fields('tanggal_kegiatan', 'tanggal_kegiatan_selesai');
$crud->fields('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'status', 'change_by', 'change_date');
$crud->columns('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'status');
$crud->display_as("id_kegiatan_butir", "Butir Kegiatan")->display_as("tanggal_kegiatan", "Tanggal Mulai")->display_as("tanggal_kegiatan_selesai", "Tanggal Selesai")->display_as("id_user", "Oleh")->display_as("change_date", "Tanggal")->display_as("id_periode", "Periode")->display_as("id_kegiatan_jabatan", "Bertindak Sebagai");
$crud->callback_add_field('id_user', array($this, '_form_get_user_callback'));
$crud->callback_edit_field('id_user', array($this, '_form_get_user_callback'));
$crud->callback_add_field('status', array($this, '_kegiatan_lama_get_status_callback'));
$crud->callback_edit_field('status', array($this, '_kegiatan_lama_get_status_callback'));
$crud->callback_before_update(array($this, 'get_change_by_callback'));
$crud->callback_before_insert(array($this, 'get_change_by_callback'));
$crud->callback_field('change_date', array($this, 'format_date_callback'));
$crud->change_field_type('id_user', 'readonly');
$crud->change_field_type('change_by', 'readonly');
$crud->change_field_type('change_date', 'readonly');
$crud->add_action('Unggah Bukti', '', 'pegawai/daftar_kegiatan_berkas', 'fa fa-upload');
$crud->unset_read();
$crud->order_by('id_kegiatan_transaksi', 'desc');
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_pegawai', $output);
}
function _set_common_report_crud($columns)
{
$crud = new grocery_CRUD();
// default columns excludes: token address_id simply because FMS/FMS-endpoint doesn't use them
$default_columns = array('report_id', 'status', 'requested_datetime', 'updated_datetime', 'expected_datetime', 'priority', 'category_id', 'media_url', 'status_notes', 'description', 'agency_responsible', 'service_notice', 'address', 'postal_code', 'lat', 'long', 'device_id', 'source_client', 'account_id', 'first_name', 'last_name', 'email', 'phone', 'engineer');
$columns = $columns ? $columns : $default_columns;
foreach ($columns as &$colname) {
if ($colname == 'report_id') {
$colname = 'xxx_report_id';
}
}
$crud->columns($columns);
$crud->order_by('requested_datetime', 'desc');
$crud->edit_fields($default_columns);
$crud->set_theme('twitter-bootstrap');
$crud->set_table('reports');
$crud->set_subject('Report');
$crud->set_relation('category_id', 'categories', 'category_name', null, 'category_name ASC');
$crud->set_relation('priority', 'priorities', 'prio_name', null, 'prio_value ASC');
$crud->set_relation('status', 'statuses', 'status_name', null, 'status_name ASC');
$crud->set_primary_key('url_slug', 'agencies');
$crud->set_relation('agency_responsible', 'agencies', 'name', null, 'name ASC');
$crud->set_relation('source_client', 'open311_clients', '<a href="admin/open311_clients/{id}">{name}</a>', null, 'name ASC');
$crud->display_as('client_id', 'Client');
$crud->callback_column('media_url', array($this, '_linkify'));
$crud->callback_column('external_id', array($this, '_get_external_url'));
$crud->callback_edit_field('media_url', array($this, '_text_media_url_field'));
$crud->display_as('requested_datetime', 'Received')->display_as('updated_datetime', 'Last Updated')->display_as('expected_datetime', 'Expected')->display_as('category_id', 'Category')->display_as('media_url', 'Media URL');
$external_id_col_name = config_item('external_id_col_name');
$crud->display_as('external_id', empty($external_id_col_name) ? 'External ID' : $external_id_col_name);
$crud->unset_texteditor('description', 'address', 'status_notes', 'service_notice');
$crud->add_action('View', site_url('assets/fms-endpoint/images/report.png'), 'admin/report');
$crud->callback_column('xxx_report_id', array($this, '_report_id_link_field'));
$crud->callback_column('requested_datetime', array($this, '_report_datetime_field'));
$crud->callback_column('updated_datetime', array($this, '_report_datetime_field'));
$crud->callback_column('description', array($this, '_report_description_field'));
$crud->callback_column($this->unique_field_name('status'), array($this, '_report_status_button'));
$crud->callback_column($this->unique_field_name('category_id'), array($this, '_report_category_button'));
$crud->display_as('xxx_report_id', 'ID');
$crud->callback_edit_field('xxx_report_id', array($this, '_read_only_report_id_field'));
//$crud->fields($default_columns);
//$crud->field_type('updated_datetime','invisible');
//$crud->callback_before_update(function($post_array){
// $post_array['updated_datetime'] = date('Y-m-d H:i:s');
// return $post_array;
//});
$crud->callback_field('updated_datetime', array($this, '_set_update_time'));
$crud->callback_field('requested_datetime', array($this, '_set_requested_datetime'));
$crud->field_type('report_id', 'readonly');
$crud->callback_before_update(array($this, '_fix_zero_prio_callback'));
$crud->callback_after_update(array($this, '_check_for_status_update_after'));
if (!$this->ion_auth->is_admin()) {
$crud->unset_delete();
}
// If we're not an admin restrict list to reports we have permissions for
if (!$this->ion_auth->is_admin()) {
return $this->filter_query_permissions($crud);
} else {
return $crud;
}
}
public function listarCierre()
{
$anio = array();
for ($i = date("Y"); $i >= 2000; $i--) {
$anio[$i] = $i;
}
$crud = new grocery_CRUD();
$crud->columns('registroId', 'anio', 'estado');
$crud->set_table('cierre');
$crud->display_as('registroId', 'Item');
$crud->display_as('anio', 'Año');
$crud->order_by('anio', 'DESC');
$crud->set_subject('Cierre');
$crud->field_type('estado', 'dropdown', array('1' => 'Activado', '2' => 'Desactivado'));
$crud->field_type('anio', 'dropdown', $anio);
$crud->callback_before_insert(array($this, 'cierre_before_insert'));
$crud->callback_before_update(array($this, 'cierre_before_update'));
$output = $crud->render();
$this->_example_output16($output);
}
function study_material_student()
{
$expertid = $this->tank_auth->get_user_id();
$crud = new grocery_CRUD();
$crud->set_table('study_material_student');
$crud->set_theme('datatables');
$crud->set_relation('material_id', 'study_material', '{material_id}- {material_name} ', null, 'material_id desc');
$crud->set_relation('member_id', 'members', '{member_id}- {firstname} {lastname}', null, 'member_id');
$crud->field_type('material_id', 'readonly');
$crud->field_type('member_id', 'readonly');
$crud->field_type('created_by', 'hidden', $expertid);
$crud->field_type('time', 'hidden', date('Y-m-d H:i:s'));
$crud->callback_before_update(array($this, 'backup_study_material_student'));
//$crud->unset_edit();
$crud->unset_print();
$crud->unset_export();
//$crud->unset_add();
// $crud->unset_edit();
$crud->unset_delete();
$output = $crud->render();
$this->_example_output($output);
}
