objects_type)) {
$this->objects_type = str_replace('list_', '', get_class($this));
}
$this->init_session_values();
$this->init_available_filters();
$this->init_selected_filters();
$this->init_filters($filters);
$this->init_settings();
$this->init_applied_group();
$this->init_available_columns();
$this->init_selected_columns();
$this->init_no_sortable_columns();
$this->init_pager($pager);
$this->init_applied_sort($applied_sort);
$this->init_global_values();
$this->init_data();
if(empty($this->dataset_id)) {
$this->init_columns();
}
}
public function set_dataset_id($dataset_id) {
$this->dataset_id = intval($dataset_id);
}
protected function set_property_class_from_json_data($property, $json_data, $merge=false) {
if(!empty($json_data)) {
if($merge) {
//$data = encoding_normalize::json_decode($json_data, true);
//$this->{$property} = array_merge($this->{$property}, $data);
$this->{$property} = encoding_normalize::json_decode($json_data, true);
} else {
$this->{$property} = encoding_normalize::json_decode($json_data, true);
}
}
}
protected function set_data_from_database($property='all') {
$this->get_datasets();
if(!$this->dataset_id) {
$this->dataset_id = $this->get_dataset_default_selected();
}
if($this->dataset_id) {
if(in_array($this->dataset_id, $this->datasets['my']) || in_array($this->dataset_id, $this->datasets['shared'])) {
$query = "select * from lists where id_list = ".$this->dataset_id;
$result = pmb_mysql_query($query);
if(pmb_mysql_num_rows($result)) {
$row = pmb_mysql_fetch_object($result);
switch($property) {
case 'selected_columns':
$this->set_property_class_from_json_data($property, $row->list_selected_columns);
if(!empty($row->list_selected_columns)) {
$this->columns = array();
$this->init_columns();
}
break;
case 'filters':
$this->set_property_class_from_json_data($property, $row->list_filters, true);
break;
case 'applied_group':
$this->set_property_class_from_json_data($property, $row->list_applied_group);
break;
case 'applied_sort':
$this->set_property_class_from_json_data($property, $row->list_applied_sort);
break;
case 'pager':
$this->set_property_class_from_json_data($property, $row->list_pager, true);
break;
case 'selected_filters':
$this->set_property_class_from_json_data($property, $row->list_selected_filters);
break;
case 'settings':
$this->set_property_class_from_json_data($property, $row->list_settings, true);
if(!empty($row->list_settings)) {
$this->set_data_from_database_settings();
//Mise en session - paramétrage uniquement personnalisable dans une liste
$this->set_settings_in_session();
}
break;
default:
$this->set_property_class_from_json_data($property, $row->list_selected_columns);
if(!empty($row->list_selected_columns)) {
$this->columns = array();
$this->init_columns();
}
$this->set_property_class_from_json_data($property, $row->list_filters, true);
$this->set_property_class_from_json_data($property, $row->list_applied_group);
$this->set_property_class_from_json_data($property, $row->list_applied_sort);
$this->set_property_class_from_json_data($property, $row->list_pager, true);
$this->set_property_class_from_json_data($property, $row->list_selected_filters);
$this->set_property_class_from_json_data($property, $row->list_settings, true);
if(!empty($row->list_settings)) {
$this->set_data_from_database_settings();
//Mise en session - paramétrage uniquement personnalisable dans une liste
$this->set_settings_in_session();
}
break;
}
}
}
}
}
protected function set_data_from_database_settings() {
if(!empty($this->settings['columns'])) {
foreach ($this->settings['columns'] as $property=>$settings_column) {
if($settings_column['visible'] == 0) {
foreach ($this->columns as $indice=>$column) {
if($column['property'] == $property) {
unset($this->columns[$indice]);
break;
}
}
foreach ($this->available_columns as $group_name=>$group_columns) {
foreach ($group_columns as $indice=>$label) {
if($indice == $property) {
unset($this->available_columns[$group_name][$indice]);
break;
}
}
}
unset($this->selected_columns[$property]);
}
}
}
if(!empty($this->settings['filters'])) {
foreach ($this->settings['filters'] as $property=>$filter) {
if($filter['visible'] == 0) {
unset($this->filters[$property]);
foreach ($this->available_filters as $group_name=>$group_filters) {
foreach ($group_filters as $indice=>$label) {
if($indice == $property) {
unset($this->available_filters[$group_name][$indice]);
break;
}
}
}
unset($this->selected_filters[$property]);
}
}
}
}
protected function _get_query_base() {
return '';
}
protected function get_object_instance($row) {
return null;
}
protected function add_object($row) {
if($this->is_deffered_load()) {
//Objet non utilisé dans ce contexte
$this->objects[] = new stdClass();
} else {
$object_instance = $this->get_object_instance($row);
if(!empty($object_instance)) {
$this->objects[] = $object_instance;
} else {
$this->objects[] = $row;
}
}
}
protected function _get_query() {
$query = $this->_get_query_base();
$query .= $this->_get_query_filters();
$query .= $this->_get_query_order();
if($this->applied_sort_type == "SQL"){
$this->pager['nb_results'] = pmb_mysql_num_rows(pmb_mysql_query($query));
$query .= $this->_get_query_pager();
}
return $query;
}
protected function fetch_data() {
$this->objects = array();
$query = $this->_get_query();
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
while($row = pmb_mysql_fetch_object($result)) {
$this->add_object($row);
}
if($this->applied_sort_type != "SQL"){
$this->pager['nb_results'] = pmb_mysql_num_rows($result);
}
}
$this->messages = "";
}
protected function init_data() {
if(empty(static::$without_data) || static::$without_data !== true) {
$this->fetch_data();
$this->_sort();
$this->_limit();
}
}
/**
* Initialisation de la session si demandé
*/
public function init_session_values() {
$initialization = $this->objects_type.'_initialization';
global ${$initialization};
if(isset(${$initialization}) && ${$initialization} == 'reset') {
$this->unset_session_values('filter');
$this->unset_session_values('applied_group');
$this->unset_session_values('selected_columns');
$this->unset_session_values('applied_sort');
$this->unset_session_values('pager');
$this->unset_session_values('selected_filters');
}
}
/**
* Initialisation des filtres disponibles
*/
protected function init_available_filters() {
$this->available_filters = array();
}
/**
* Initialisation des filtres appliqués par défaut
*/
protected function init_default_selected_filters() {
$this->selected_filters = array();
}
/**
* Initialisation des filtres sélectionnées
*/
protected function init_selected_filters() {
$this->init_default_selected_filters();
$this->set_data_from_database('selected_filters');
$this->sign_selected_filters = $this->get_sign($this->selected_filters);
if(isset($_SESSION['list_'.$this->objects_type.'_selected_filters']) && is_array($_SESSION['list_'.$this->objects_type.'_selected_filters'])) {
$this->selected_filters = array();
foreach($_SESSION['list_'.$this->objects_type.'_selected_filters'] as $property=>$label) {
$this->add_selected_filter($property);
}
}
$this->set_selected_filters_from_form();
}
/**
* Initialisation des filtres de recherche
*/
public function init_filters($filters=array()) {
$this->set_data_from_database('filters');
if(empty($this->filters)) {
$this->filters = array();
}
$this->sign_filters = $this->get_sign(array_merge_recursive($this->filters, $filters));
foreach ($this->filters as $key => $val){
if(isset($_SESSION['list_'.$this->objects_type.'_filter'][$key])) {
$this->filters[$key] = $_SESSION['list_'.$this->objects_type.'_filter'][$key];
}
}
if(count($filters)){
foreach ($filters as $key => $val){
$this->filters[$key]=$val;
}
}
}
/**
* Initialisation des settings par défaut
*/
protected function init_default_settings() {
$this->settings = array(
'display' => array(
'search_form' => array(
'visible' => true,
'filters' => true,
'unfolded_filters' => false,
'add_filters' => false,
'sorts' => true,
'options' => false,
'unfolded_options' => false,
'datasets' => false,
'export_icons' => true
),
'query' => array(
'human' => true,
),
'objects_list' => array(
'deffered_load' => false,
'visible' => true
)
),
'selector_size' => 5,
'columns' => array(
'default' => array(
'align' => 'center',
'text' => '',
'level' => 0,
'visible' => 1,
'display_mode' => 'normal',
'edition_type' => 'text'
)
),
'filters' => array(
'default' => array(
'visible' => 1
)
),
'objects' => array(
'default' => array(
'visible' => 1,
'display_mode' => 'table',
'expanded_display' => 1
)
),
'grouped_objects' => array(
'default' => array(
'sort' => 1,
'display_mode' => 'table',
'expanded_display' => 1
)
)
);
}
/**
* Initialisation des paramétrages
*/
public function init_settings($settings=array()) {
$this->init_default_settings();
$this->set_data_from_database('settings');
$this->sign_settings = $this->get_sign(array_merge_recursive($this->settings, $settings));
if(isset($_SESSION['list_'.$this->objects_type.'_settings'])) {
foreach ($_SESSION['list_'.$this->objects_type.'_settings'] as $key => $val){
$this->settings[$key] = $val;
}
}
if(count($settings)){
foreach ($settings as $key => $val){
$this->settings[$key]=$val;
}
}
$initialization = $this->objects_type.'_initialization';
global ${$initialization};
if(empty(${$initialization}) || ${$initialization} != 'reset') {
$this->set_settings_from_form();
}
}
/**
* Initialisation du groupement appliqué à la recherche
*/
public function init_applied_group($applied_group=array()) {
if(!isset($this->applied_group)) {
$this->applied_group = array(0 => '');
}
$this->set_data_from_database('applied_group');
$this->sign_applied_group = $this->get_sign(array_merge_recursive($this->applied_group, $applied_group));
if(isset($_SESSION['list_'.$this->objects_type.'_applied_group'])) {
foreach ($_SESSION['list_'.$this->objects_type.'_applied_group'] as $key => $val){
$this->applied_group[$key] = $val;
}
}
if(count($applied_group)){
foreach ($applied_group as $key => $val){
$this->applied_group[$key]=$val;
}
}
$initialization = $this->objects_type.'_initialization';
global ${$initialization};
if(empty(${$initialization}) || ${$initialization} != 'reset') {
$this->set_applied_group_from_form();
}
}
/**
* Initialisation des colonnes disponibles
*/
protected function init_available_columns() {
$this->available_columns = array();
}
/**
* Initialisation des colonnes sélectionnées
*/
protected function init_selected_columns() {
$this->selected_columns = array();
$this->set_data_from_database('selected_columns');
$this->sign_selected_columns = $this->get_sign($this->selected_columns);
if(isset($_SESSION['list_'.$this->objects_type.'_selected_columns']) && is_array($_SESSION['list_'.$this->objects_type.'_selected_columns'])) {
$this->selected_columns = array();
foreach($_SESSION['list_'.$this->objects_type.'_selected_columns'] as $property=>$label) {
$this->add_selected_column($property);
}
}
$this->set_selected_columns_from_form();
}
/**
* Initialisation des colonnes non triables
*/
protected function init_no_sortable_columns() {
$this->no_sortable_columns = array();
}
/**
* Initialisation de la pagination par défaut
*/
protected function init_default_pager() {
$this->pager = array(
'page' => 1,
'nb_per_page' => 20,
'nb_per_page_on_group' => false,
'nb_results' => 0,
'nb_page' => 1,
'allow_force_all_on_page' => false
);
}
/**
* Initialisation de la pagination
*/
public function init_pager($pager=array()) {
$this->init_default_pager();
$this->set_data_from_database('pager');
$this->sign_pager = $this->get_sign($this->pager['nb_per_page']);
if(isset($_SESSION['list_'.$this->objects_type.'_pager']['nb_per_page'])) {
$this->pager['nb_per_page'] = $_SESSION['list_'.$this->objects_type.'_pager']['nb_per_page'];
}
if(isset($_SESSION['list_'.$this->objects_type.'_pager']['nb_per_page_on_group'])) {
$this->pager['nb_per_page_on_group'] = $_SESSION['list_'.$this->objects_type.'_pager']['nb_per_page_on_group'];
}
if(isset($_SESSION['list_'.$this->objects_type.'_pager']['page'])) {
$this->pager['page'] = $_SESSION['list_'.$this->objects_type.'_pager']['page'];
}
if(count($pager)){
foreach ($pager as $key => $val){
$this->pager[$key]=$val;
}
}
}
/**
* Ajout d'un tri
*/
protected function add_applied_sort($by, $asc_desc='asc') {
if(empty($this->applied_sort)) {
$this->applied_sort = array();
}
array_push($this->applied_sort, array('by' => $by, 'asc_desc' => $asc_desc));
}
/**
* Initialisation du tri par défaut appliqué
*/
protected function init_default_applied_sort() {
$this->applied_sort = array(
'by' => 'id',
'asc_desc' => 'desc'
);
}
/**
* Initialisation du tri appliqué
*/
public function init_applied_sort($applied_sort=array()) {
$this->init_default_applied_sort();
$this->set_data_from_database('applied_sort');
$this->sign_applied_sort = $this->get_sign(array_merge_recursive($this->applied_sort, $applied_sort));
if(isset($_SESSION['list_'.$this->objects_type.'_applied_sort'][0]['by'])) {
$this->applied_sort[0]['by'] = $_SESSION['list_'.$this->objects_type.'_applied_sort'][0]['by'];
if(isset($_SESSION['list_'.$this->objects_type.'_applied_sort'][0]['asc_desc'])) {
$this->applied_sort[0]['asc_desc'] = $_SESSION['list_'.$this->objects_type.'_applied_sort'][0]['asc_desc'];
} else {
$this->applied_sort[0]['asc_desc'] = 'asc';
}
}
if(count($applied_sort)){
foreach ($applied_sort as $key => $val){
if(is_array($val)) {
$this->applied_sort[$key] = $val;
} else {
$this->applied_sort[0][$key]=$val;
}
}
}
$initialization = $this->objects_type.'_initialization';
global ${$initialization};
if(empty(${$initialization}) || ${$initialization} != 'reset') {
$this->set_applied_sort_from_form();
}
}
/**
* Initialisation demandée - Destruction des variables globales
*/
public function init_global_values() {
$initialization = $this->objects_type.'_initialization';
global ${$initialization};
if(isset(${$initialization}) && ${$initialization} == 'reset') {
$this->unset_global_values('filters');
$this->unset_global_values('applied_group');
$this->unset_global_values('applied_sort');
$this->unset_global_values('pager');
}
}
protected function get_label_available_filter($property, $group_label='main_fields') {
if(isset($this->available_filters[$group_label][$property])) {
return $this->available_filters[$group_label][$property];
}
return '';
}
public function add_selected_filter($property, $label='') {
if(!empty($this->available_filters['custom_fields'][$property])) {
$this->selected_filters[$property] = ($label ? $label : $this->get_label_available_filter($property, 'custom_fields'));
} else {
$this->selected_filters[$property] = ($label ? $label : $this->get_label_available_filter($property));
}
}
protected function add_empty_selected_filter() {
global $empty_selected_filter;
//Pas propre mais ça fait le job
if($empty_selected_filter) {
$empty_selected_filter++;
} else {
$empty_selected_filter = 1;
}
$this->selected_filters['empty_'.$empty_selected_filter] = '';
}
/**
* Filtres provenant du formulaire
*/
public function set_selected_filters_from_form() {
$initialization = $this->objects_type.'_initialization';
global ${$initialization};
if(empty(${$initialization})) {
$selected_filters = $this->objects_type.'_selected_filters';
global ${$selected_filters};
if(isset(${$selected_filters})) {
$this->selected_filters = encoding_normalize::json_decode(stripslashes(${$selected_filters}), true);
// foreach (${$selected_filters} as $property=>$label) {
// $this->add_selected_filter(stripslashes($property), stripslashes($label));
// }
}
}
//A-t-on demandé l'ajout d'un filtre ?
$add_filter = $this->objects_type.'_add_filter';
global ${$add_filter};
if(!empty(${$add_filter})) {
$this->add_selected_filter(${$add_filter});
}
//Sauvegarde des filtres en session
$this->set_selected_filters_in_session();
}
/**
* Filtre provenant du formulaire
*/
public function set_filter_from_form($name, $type='string') {
$field_value = $this->objects_type.'_'.$name;
global ${$field_value};
if(isset(${$field_value})) {
switch ($type) {
case 'integer':
if(is_array(${$field_value})) {
$this->filters[$name] = array();
if(${$field_value}[0]) {
$this->filters[$name] = ${$field_value};
}
} else {
$this->filters[$name] = intval(${$field_value});
}
break;
default:
if(is_array(${$field_value})) {
$this->filters[$name] = array();
if(${$field_value}[0]) {
$this->filters[$name] = stripslashes_array(${$field_value});
}
} else {
$this->filters[$name] = stripslashes(${$field_value});
}
break;
}
}
}
/**
* Filtres de champs personnalisés provenant du formulaire
*/
public function set_filters_custom_fields_from_form() {
//Traitement des champs personnalisés
if(!empty($this->custom_fields_available_filters)) {
foreach ($this->custom_fields_available_filters as $property=>$data) {
$type = $data['type'];
$parametres_perso = $this->get_custom_parameters_instance($type);
$property_id = $parametres_perso->get_field_id_from_name($property);
$valeurs_post=$property;
$v=array();
global ${$valeurs_post};
if (${$valeurs_post}) $v=${$valeurs_post};
$t=array();
if(!empty($parametres_perso->t_fields[substr($property_id,2)]['OPTIONS'][0]['UNSELECT_ITEM'][0]['VALUE'])) {
$t[0]=$parametres_perso->t_fields[substr($property_id,2)]['OPTIONS'][0]['UNSELECT_ITEM'][0]['VALUE'];
}
$w=array_diff($v,$t);
$this->filters["#custom_field#".$property] = array();
if(count($w) > 1 || (is_array($w) && isset($w[0]) && $w[0] != "-1" && $w[0] != "")){
$this->filters["#custom_field#".$property] = stripslashes_array($w);
}
}
}
}
/**
* Filtres provenant du formulaire
*/
public function set_filters_from_form() {
$this->set_filters_custom_fields_from_form();
//Sauvegarde des filtres en session
$this->set_filter_in_session();
}
/**
* Paramétrages provenant du formulaire
*/
public function set_settings_from_form() {
$settings = $this->objects_type.'_settings';
global ${$settings};
if(isset(${$settings})) {
foreach (${$settings} as $group_settings_name=>$group_settings) {
if($group_settings_name && !empty($group_settings)) {
$this->settings[$group_settings_name] = stripslashes_array($group_settings);
}
}
}
//Sauvegarde des settings en session
//Pas de mise en session - paramétrage uniquement personnalisable dans une liste
// $this->set_settings_in_session();
}
/**
* Groupement provenant du formulaire
*/
public function set_applied_group_from_form() {
$applied_group = $this->objects_type.'_applied_group';
global ${$applied_group};
if(isset(${$applied_group})) {
$this->applied_group = array();
foreach (${$applied_group} as $name) {
if($name) {
$this->applied_group[] = $name;
}
}
}
//Sauvegarde du groupement en session
$this->set_applied_group_in_session();
}
/**
* Tri provenant du formulaire
*/
public function set_applied_sort_from_form() {
$applied_sort = $this->objects_type.'_applied_sort';
global ${$applied_sort};
if(isset(${$applied_sort})) {
$this->applied_sort = ${$applied_sort};
}
//Sauvegarde du tri en session
$this->set_applied_sort_in_session();
}
/**
* Pagination provenant du formulaire
*/
public function set_pager_from_form() {
$page = $this->objects_type.'_page';
global ${$page};
$nb_per_page = $this->objects_type.'_nb_per_page';
global ${$nb_per_page};
if(${$page}*1) {
$this->pager['page'] = ${$page}*1;
}
if(${$nb_per_page}*1) {
$this->pager['nb_per_page'] = ${$nb_per_page}*1;
}
//Sauvegarde de la pagination en session
$this->set_pager_in_session();
}
protected function get_title() {
return '';
}
protected function get_form_title() {
global $msg, $charset;
if(isset($msg[$this->objects_type.'_form_title'])) {
return htmlentities($msg[$this->objects_type.'_form_title'], ENT_QUOTES, $charset);
}
return '';
}
protected function get_form_name() {
return $this->objects_type."_search_form";
}
/**
* Retourne l'instance de parametres_perso
* @param string $type
*/
protected function get_custom_parameters_instance($type) {
if(!isset($this->custom_parameters_instance[$type])) {
switch($type) {
case 'pret':
$this->custom_parameters_instance[$type] = new pret_parametres_perso($type);
break;
default:
$this->custom_parameters_instance[$type] = new parametres_perso($type);
break;
}
}
return $this->custom_parameters_instance[$type];
}
/**
* Liste des filtres disponibles sur les champs personnalisés
* @param string $type
*/
protected function add_custom_fields_available_filters($type, $property_id) {
$t_fields = $this->get_custom_parameters_instance($type)->t_fields;
foreach ($t_fields as $field) {
if(!empty($field["FILTERS"]) || !empty($field["SEARCH"])) {
$this->available_filters['custom_fields'][$field['NAME']] = $field['TITRE'];
$this->custom_fields_available_filters[$field['NAME']] = array(
'type' => $type,
'property_id' => $property_id
);
}
}
}
/**
* Liste des colonnes disponibles sur les champs personnalisés
* @param string $type
*/
protected function add_custom_fields_available_columns($type, $property_id) {
foreach ($this->get_custom_parameters_instance($type)->t_fields as $field) {
$this->available_columns['custom_fields'][$field['NAME']] = $field['TITRE'];
$this->custom_fields_available_columns[$field['NAME']] = array(
'type' => $type,
'property_id' => $property_id
);
}
}
protected function get_available_columns_selector() {
$size = $this->settings['selector_size'];
$selector = "";
foreach ($this->get_sorted_available_columns() as $property=>$label) {
if(empty($this->selected_columns[$property])) {
$selector .= "".$this->_get_label_cell_header($label)." ";
}
}
$selector .= " ";
return $selector;
}
protected function get_selected_columns_selector() {
$size = $this->settings['selector_size'];
$selector = "";
foreach ($this->selected_columns as $property=>$label) {
$selector .= "".$this->_get_label_cell_header($label)." ";
}
$selector .= " ";
return $selector;
}
protected function set_setting_display($property, $css_property, $value) {
$this->set_setting('display', $property, $css_property, $value);
}
protected function get_selected_setting_column($property, $css_property) {
return $this->get_setting('columns', $property, $css_property);
}
protected function set_setting_column($property, $css_property, $value) {
$this->set_setting('columns', $property, $css_property, $value);
}
protected function get_selected_setting_filter($property, $css_property) {
return $this->get_setting('filters', $property, $css_property);
}
protected function set_setting_filter($property, $css_property, $value) {
$this->set_setting('filters', $property, $css_property, $value);
}
protected function get_settings_property_input_form($name, $property, $css_property, $settings, $type) {
global $msg, $charset;
switch ($name) {
case 'columns':
$selected_setting = $this->get_selected_setting_column($property, $css_property);
break;
case 'filters':
$selected_setting = $this->get_selected_setting_filter($property, $css_property);
break;
}
$content_form = "";
switch ($type) {
case 'checkbox':
foreach($settings as $setting) {
$content_form .= "
".htmlentities($msg['list_ui_settings_display_'.$group_name], ENT_QUOTES, $charset)."
";
foreach ($settings as $name=>$value) {
$settings_display .= "
";
}
}
$content_form = str_replace('!!settings_display!!', $settings_display, $content_form);
$content_form = str_replace('!!objects_type!!', $this->objects_type, $content_form);
return $content_form;
}
protected function get_settings_column_content_form($property, $label) {
$content_form = "
".$this->_get_label_cell_header($label)."
".$this->get_settings_property_input_form('columns', $property, 'align', array('left', 'center', 'right'), 'radio')."
".$this->get_settings_property_input_form('columns', $property, 'text', array('bold', 'italic', 'underline'), 'checkbox')."
".$this->get_settings_property_input_form('columns', $property, 'visible', array('0', '1'), 'radio')."
";
return $content_form;
}
protected function get_settings_columns_content_form() {
global $list_ui_settings_columns_content_form_tpl;
$content_form = $list_ui_settings_columns_content_form_tpl;
$settings_columns = '';
foreach ($this->get_sorted_available_columns() as $property=>$label) {
$settings_columns .= $this->get_settings_column_content_form($property, $label);
}
$content_form = str_replace('!!settings_columns!!', $settings_columns, $content_form);
$content_form = str_replace('!!objects_type!!', $this->objects_type, $content_form);
return $content_form;
}
protected function get_settings_filter_content_form($property, $label) {
$content_form = "
".$this->_get_label_cell_header($label)."
".$this->get_settings_property_input_form('filters', $property, 'visible', array('0', '1'), 'radio')."
";
return $content_form;
}
protected function get_settings_filters_content_form() {
global $list_ui_settings_filters_content_form_tpl;
$content_form = $list_ui_settings_filters_content_form_tpl;
$settings_filters = '';
foreach ($this->get_sorted_available_filters() as $property=>$label) {
$settings_filters .= $this->get_settings_filter_content_form($property, $label);
}
$content_form = str_replace('!!settings_filters!!', $settings_filters, $content_form);
$content_form = str_replace('!!objects_type!!', $this->objects_type, $content_form);
return $content_form;
}
protected function get_applied_group_selector($indice, $applied_group='') {
$selector = "";
$selector .= "".$this->_get_label_cell_header($label)." ";
}
$selector .= " ";
return $selector;
}
protected function get_applied_group_selectors() {
global $msg, $charset;
$selectors = '';
if(empty($this->applied_group)) {
$this->applied_group = array(0 => '');
}
foreach ($this->applied_group as $indice=>$applied_group) {
if($indice) {
$selectors .= $this->get_display_add_applied_group($indice, $applied_group);
} else {
$selectors .= $this->get_applied_group_selector($indice, $applied_group);
$selectors .= "
";
return $selectors;
}
public function get_display_add_applied_group($indice, $applied_group='') {
global $msg, $charset;
$display = "
".htmlentities($msg['list_ui_options_group_by_then'], ENT_QUOTES, $charset)."
";
$display .= $this->get_applied_group_selector($indice, $applied_group);
$display .= "
";
return $display;
}
/**
* Affichage du formulaire d'options
*/
public function get_options_content_form() {
global $list_ui_options_content_form_tpl;
$options_content_form = $list_ui_options_content_form_tpl;
$options_content_form = str_replace('!!objects_type!!', $this->objects_type, $options_content_form);
$options_content_form = str_replace('!!available_columns!!', $this->get_available_columns_selector(), $options_content_form);
$options_content_form = str_replace('!!selected_columns!!', $this->get_selected_columns_selector(), $options_content_form);
$options_content_form = str_replace('!!applied_group_selectors!!', $this->get_applied_group_selectors(), $options_content_form);
return $options_content_form;
}
/**
* Affichage du formulaire de paramétrages avancés
*/
public function get_settings_content_form() {
global $list_ui_settings_content_form_tpl;
$settings_content_form = $list_ui_settings_content_form_tpl;
$settings_content_form = str_replace('!!objects_type!!', $this->objects_type, $settings_content_form);
$settings_content_form = str_replace('!!list_settings_display_content_form_tpl!!', $this->get_settings_display_content_form(), $settings_content_form);
$settings_content_form = str_replace('!!list_settings_columns_content_form_tpl!!', $this->get_settings_columns_content_form(), $settings_content_form);
$settings_content_form = str_replace('!!list_settings_filters_content_form_tpl!!', $this->get_settings_filters_content_form(), $settings_content_form);
return $settings_content_form;
}
protected function get_dataset_action_content_form($name, $id=0, $icon='', $label='') {
global $charset;
return "
";
}
/**
* Affichage du formulaire de rapports personnalisés (my or shared)
*/
public function get_datasets_content_form($which='my') {
global $msg, $charset;
global $list_ui_datasets_content_form_tpl;
$datasets_content_form = $list_ui_datasets_content_form_tpl;
$datasets_content_form = str_replace('!!datasets_label!!', htmlentities($msg['list_ui_datasets_'.$which], ENT_QUOTES, $charset), $datasets_content_form);
$datasets_content = '';
foreach ($this->get_datasets()[$which] as $dataset) {
$list_model = new list_model($dataset);
$datasets_content .= "
".$list_model->get_label()."
".$this->get_dataset_action_content_form('apply', $dataset, 'tick.gif', $msg['apply'])."
".$this->get_dataset_action_content_form('edit', $dataset, 'b_edit.png', $msg['62'])."
".$this->get_dataset_action_content_form('delete', $dataset, 'interdit.gif', $msg['63'])."
";
}
$datasets_content_form = str_replace('!!datasets_content!!', $datasets_content, $datasets_content_form);
$datasets_content_form = str_replace('!!objects_type!!', $this->objects_type, $datasets_content_form);
$datasets_content_form = str_replace('!!which!!', $which, $datasets_content_form);
$datasets_content_form = str_replace('!!controller_url_base!!', static::get_controller_url_base(), $datasets_content_form);
return $datasets_content_form;
}
protected function get_simple_selector($query, $name='', $message_all='') {
global $msg, $charset;
$selector = "";
$result = pmb_mysql_query($query);
$selector .= "filters[$name]) ? "selected='selected'" : "").">".htmlentities($message_all, ENT_QUOTES, $charset)." ";
while ($row = pmb_mysql_fetch_object($result)) {
$selector .= "id == $this->filters[$name] ? "selected='selected'" : "").">";
$selector .= $row->label." ";
}
$selector .= " ";
return $selector;
}
protected function get_multiple_selector($query, $name='', $message_all='') {
global $charset;
$selector = "";
$result = pmb_mysql_query($query);
$selector .= "filters[$name]) ? "selected='selected'" : "").">".htmlentities($message_all, ENT_QUOTES, $charset)." ";
while ($row = pmb_mysql_fetch_object($result)) {
$selector .= "id, $this->filters[$name]) ? "selected='selected'" : "").">";
$selector .= $row->label." ";
}
$selector .= " ";
return $selector;
}
protected function get_search_filter_interval_date($name) {
return "selected_filters));
$search_filter_form = "
";
if(!empty($this->is_displayed_add_filters_block) || $delete_is_allow) {
if($label && substr($label, 0, 6) != 'empty_') {
$search_filter_form .= "".htmlentities($label, ENT_QUOTES, $charset)."
".$this->get_search_filter_custom_field($property)."
";
return $search_filter_form;
}
/**
* Affichage d'un filtre du formulaire de recherche
*/
public function get_search_filter_form($property, $label, $delete_is_allow=false) {
global $msg, $charset;
$method_name = "get_search_filter_".$property;
$position = array_search($property, array_keys($this->selected_filters));
$search_filter_form = "
";
if(!empty($this->is_displayed_add_filters_block) || $delete_is_allow) {
if($label && substr($label, 0, 6) != 'empty_') {
$search_filter_form .= "".($label && substr($label, 0, 6) != 'empty_' ? htmlentities($msg[$label], ENT_QUOTES, $charset) : '')."
".(method_exists($this, $method_name) ? call_user_func(array($this, $method_name)) : '')."
";
return $search_filter_form;
}
/**
* Affichage des filtres du formulaire de recherche
*/
public function get_search_filters_form() {
if(!isset($this->is_displayed_add_filters_block) || $this->is_displayed_add_filters_block !== false) {
$nb_selected_filters = 0;
if(count($this->selected_filters)) {
foreach ($this->selected_filters as $property=>$filter) {
if($property && substr($property, 0, 6) != 'empty_') {
$nb_selected_filters++;
}
}
}
$nb_available_filters = count($this->available_filters['main_fields'])+count($this->available_filters['custom_fields']);
if($nb_selected_filters < $nb_available_filters) {
$this->is_displayed_add_filters_block = true;
}
}
$search_filters_form = "";
$col = 1;
foreach ($this->selected_filters as $property=>$label) {
if($col === 0) {
$search_filters_form .= "
";
$col++;
}
if($this->is_custom_field_filter($property)) {
$search_filters_form .= $this->get_search_filter_custom_field_form($property, $label);
} else {
$search_filters_form .= $this->get_search_filter_form($property, $label);
}
if($col === 3) {
$col = 0;
} else {
$col++;
}
}
$search_filters_form .= "
";
return $search_filters_form;
}
protected function get_search_add_filter_options() {
$options = "selected_filters) ? "disabled='disabled' style='display:none;'" : "")." data-property-code='".$this->available_filters[$group][$property]."'>".$this->_get_label_cell_header($label)." ";
}
}
}
return $options;
}
/**
* Affichage du sélecteur de filtres du formulaire de recherche
*/
protected function get_search_add_filter_form() {
global $list_ui_search_add_filter_form_tpl;
$search_add_filter_form = $list_ui_search_add_filter_form_tpl;
$search_add_filter_form = str_replace('!!add_filter_options!!', $this->get_search_add_filter_options(), $search_add_filter_form);
$search_add_filter_form = str_replace('!!selected_filters_number!!', count($this->get_selected_filters()), $search_add_filter_form);
$search_add_filter_form = str_replace('!!objects_type!!', $this->objects_type, $search_add_filter_form);
return $search_add_filter_form;
}
protected function get_search_order_options($indice=0) {
$options = '';
foreach ($this->get_sorted_available_columns() as $property=>$label) {
if($this->_cell_is_sortable($property)) {
$options .= "applied_sort[$indice]['by'] ? "selected='selected'" : "").">".$this->_get_label_cell_header($label)." ";
}
}
return $options;
}
protected function get_search_order_selector($indice=0) {
global $msg;
$selector = "";
$selector .= $this->get_search_order_options($indice);
$selector .= " ";
$selector .= "";
$selector .= "".$msg["list_applied_sort_asc"]." ";
$selector .= "".$msg["list_applied_sort_desc"]." ";
$selector .= " ";
return $selector;
}
/**
* Affichage du tri du formulaire de recherche
*/
public function get_search_order_form() {
global $list_ui_search_order_form_tpl;
$search_order_form = $list_ui_search_order_form_tpl;
$selectors = '';
if(empty($this->applied_sort)) {
$this->applied_sort = array(0 => array('by' => '', 'asc_desc' => ''));
}
foreach ($this->applied_sort as $indice=>$applied_sort) {
if($indice) {
$selectors .= $this->get_search_order_add_applied_sort($indice, $applied_sort);
} else {
$selectors .= $this->get_search_order_selector($indice);
//DG 22/11/2019 - A activer plus tard
//$selectors .= "
";
$search_order_form = str_replace('!!applied_sort_selectors!!', $selectors, $search_order_form);
return $search_order_form;
}
public function get_search_order_add_applied_sort($indice, $applied_sort = array()) {
global $msg, $charset;
$display = "
".htmlentities($msg['list_ui_sort_by_then'], ENT_QUOTES, $charset)."
";
if(empty($this->applied_sort[$indice])) {
if(!empty($applied_sort)) {
$this->add_applied_sort($applied_sort['by'], $applied_sort['asc_desc']);
} else {
$this->add_applied_sort('');
}
}
$display .= $this->get_search_order_selector($indice);
$display .= "
";
return $display;
}
/**
* Boutons supplémentaires
*/
protected function get_search_buttons_extension() {
return "";
}
/**
* Affichage des filtres/tri du formulaire de recherche
*/
protected function get_search_content_form() {
$search_content_form = "";
$search_content_form .= $this->get_search_filters_form();
$search_content_form .= "
";
$search_content_form .= "
";
if(!empty($this->is_displayed_add_filters_block)) {
if(!empty($this->available_filters['main_fields']) || !empty($this->available_filters['custom_fields'])) {
$search_content_form .= "";
$search_content_form .= $this->get_search_add_filter_form();
$search_content_form .= "
";
$search_content_form .= "
";
}
}
$search_content_form .= "";
$search_content_form .= $this->get_search_order_form();
$search_content_form .= "
";
return $search_content_form;
}
/**
* Affichage du formulaire de recherche
*/
public function get_search_form() {
global $msg;
global $list_ui_search_form_tpl;
global $action;
$search_form = $list_ui_search_form_tpl;
$search_form = str_replace('!!form_title!!', $this->get_form_title(), $search_form);
$search_form = str_replace('!!form_name!!', $this->get_form_name(), $search_form);
$search_form = str_replace('!!json_filters!!', json_encode($this->filters), $search_form);
$search_form = str_replace('!!json_selected_columns!!', json_encode($this->selected_columns), $search_form);
$search_form = str_replace('!!json_settings!!', json_encode($this->settings), $search_form);
$search_form = str_replace('!!json_applied_group!!', json_encode($this->applied_group), $search_form);
$search_form = str_replace('!!json_applied_sort!!', json_encode($this->applied_sort), $search_form);
$search_form = str_replace('!!page!!', $this->pager['page'], $search_form);
$search_form = str_replace('!!nb_per_page!!', $this->pager['nb_per_page'], $search_form);
$search_form = str_replace('!!pager!!', json_encode($this->pager), $search_form);
$search_form = str_replace('!!selected_filters!!', json_encode($this->selected_filters), $search_form);
$search_form = str_replace('!!ancre!!', (!empty($this->ancre) ? $this->ancre : ''), $search_form);
$search_form = str_replace('!!messages!!', $this->get_messages(), $search_form);
$search_form = str_replace('!!objects_type!!', $this->objects_type, $search_form);
$search_form = str_replace('!!export_icons!!', $this->get_export_icons(), $search_form);
$search_form = str_replace('!!list_button_add!!', $this->get_button_add(), $search_form);
$search_form = str_replace('!!list_search_content_form_tpl!!', $this->get_search_content_form(), $search_form);
if($this->get_setting('display', 'search_form', 'unfolded_filters')) {
$search_form = str_replace('!!expandable_icon!!', get_url_icon('minus.gif'), $search_form);
$search_form = str_replace('!!unfolded_filters!!', 'block', $search_form);
} else {
$search_form = str_replace('!!expandable_icon!!', get_url_icon('plus.gif'), $search_form);
$search_form = str_replace('!!unfolded_filters!!', 'none', $search_form);
}
if((!empty($this->is_displayed_options_block) || $this->get_setting('display', 'search_form', 'options')) && isset($this->available_columns)) {
$search_form = str_replace('!!list_options_content_form_tpl!!', $this->get_options_content_form(), $search_form);
if((!empty($this->is_displayed_datasets_block) || $this->get_setting('display', 'search_form', 'datasets')) && $action != 'dataset_apply' && $action != 'dataset_save') {
$search_form = str_replace('!!list_button_save!!', "
";
}
protected function add_column_selection() {
global $msg, $charset;
$this->columns[] = array(
'property' => '',
// 'label' => "
",
'label' => "
",
'html' => $this->get_display_html_content_selection(),
'exportable' => false
);
}
/**
* Initialisation des colonnes par défaut
*/
protected function init_default_columns() {
$this->columns = array();
}
protected function init_columns($columns=array()) {
if(count($this->selected_columns)) {
if(count($this->get_selection_actions())) {
$this->add_column_selection();
}
foreach ($this->selected_columns as $property=>$label) {
$this->add_column($property, $label);
}
} else {
$this->init_default_columns();
}
}
/**
* Colonnes provenant du formulaire
*/
public function set_selected_columns_from_form() {
$selected_columns = $this->objects_type.'_selected_columns';
global ${$selected_columns};
if(isset(${$selected_columns})) {
$this->selected_columns = array();
foreach (${$selected_columns} as $column) {
$this->add_selected_column($column);
}
}
//Sauvegarde des colonnes en session
$this->set_selected_columns_in_session();
}
/**
* Construction dynamique de la fonction JS de tri
*/
protected function get_js_sort_script_sort() {
global $list_ui_js_sort_script_sort;
$display = $list_ui_js_sort_script_sort;
$display = str_replace('!!objects_type!!', $this->objects_type, $display);
return $display;
}
/**
* Construction de la fonction JS pour l'expand/collapse
*/
protected function get_js_sort_expandable_list() {
$display = "
".(!empty($this->expandable_title) ? $this->expandable_title : '')."
";
return $display;
}
protected function _get_label_cell_header($name) {
global $msg, $charset;
global $current_module;
if(isset($msg[$current_module.'_'.$this->objects_type.'_'.$name])) {
return htmlentities($msg[$current_module.'_'.$this->objects_type.'_'.$name],ENT_QUOTES,$charset);
} elseif(isset($msg[$name])) {
return htmlentities($msg[$name],ENT_QUOTES,$charset);
} else {
return $name;
}
}
protected function _cell_is_sortable($name) {
if(!empty($this->no_sortable_columns) && in_array($name, $this->no_sortable_columns)) {
return false;
}
return true;
}
/**
* Construction dynamique des cellules du header
* @param string $name
*/
protected function _get_cell_header($name, $label = '') {
global $msg, $charset;
$data_sorted = (!empty($this->applied_sort[0]['asc_desc']) ? $this->applied_sort[0]['asc_desc'] : 'asc');
$icon_sorted = ($data_sorted == 'asc' ? 'objects_type."_sort_by('".$name."', this.getAttribute('data-sorted'));\" data-sorted='".($this->applied_sort[0]['by'] == $name ? $data_sorted : '')."' style='cursor:pointer;' title='".htmlentities($msg['sort_by'], ENT_QUOTES, $charset).' '.$this->_get_label_cell_header($label)."' class='list_ui_list_cell_header ".$this->objects_type."_list_cell_header_".$name."'>
".$this->_get_label_cell_header($label)."
".($this->applied_sort[0]['by'] == $name ? $icon_sorted : ' ";
} else {
return "";
}
}
/**
* Header de la liste
*/
public function get_display_header_list() {
$display = '';
foreach ($this->columns as $column) {
$display .= $this->_get_cell_header($column['property'], $column['label']);
}
$display .= ' ';
return $display;
}
protected function _sort_grouped_objects($a, $b) {
global $msg;
if($a == $msg['list_ui_objects_not_grouped']) {
return -1;
} elseif($b == $msg['list_ui_objects_not_grouped']) {
return 1;
} else {
return strcmp(strtolower(convert_diacrit($a)), strtolower(convert_diacrit($b)));
}
}
protected function get_grouped_label($object, $property) {
global $msg;
$grouped_label = '';
if (is_object($object) && !empty($object->{$property})) {
$grouped_label = $object->{$property};
} elseif(method_exists($object, 'get_'.$property)) {
$grouped_label = call_user_func_array(array($object, "get_".$property), array());
} elseif(isset($this->custom_fields_available_columns[$property])) {
$custom_instance = $this->get_custom_parameters_instance($this->custom_fields_available_columns[$property]['type']);
$custom_instance->get_values($object->{$this->custom_fields_available_columns[$property]['property_id']});
$field_id = $custom_instance->get_field_id_from_name($property);
if(isset($custom_instance->values[$field_id]) && count($custom_instance->values[$field_id])) {
$grouped_label = $custom_instance->get_formatted_output($custom_instance->values[$field_id], $field_id);
} else {
$grouped_label = $msg['list_ui_objects_not_grouped'];
}
} else {
$grouped_label = $msg['list_ui_objects_not_grouped'];
}
return $grouped_label;
}
protected function add_group_labels($label) {
if(array_search($label, $this->applied_group_labels) === false) {
$this->applied_group_labels[] = $label;
}
}
protected function get_grouped_objects() {
if(!isset($this->grouped_objects)) {
$grouped_objects = array();
$this->applied_group_labels = array();
$property = $this->applied_group[0];
$not_found = false;
foreach ($this->objects as $object) {
switch(count($this->applied_group)) {
case 3:
$grouped_label_1 = $this->get_grouped_label($object, $this->applied_group[1]);
$grouped_label_2 = $this->get_grouped_label($object, $this->applied_group[2]);
$grouped_objects[$this->get_grouped_label($object, $property)][$grouped_label_1][$grouped_label_2][] = $object;
break;
case 2:
$grouped_label = $this->get_grouped_label($object, $this->applied_group[1]);
$grouped_objects[$this->get_grouped_label($object, $property)][$grouped_label][] = $object;
break;
case 1:
default:
$grouped_label = $this->get_grouped_label($object, $property);
if(is_array($grouped_label)) {
// $grouped_objects[implode(' / ', $grouped_label)][] = $object;
foreach ($grouped_label as $label) {
$grouped_objects[$label][] = $object;
$this->add_group_labels($label);
}
} else {
$grouped_objects[$grouped_label][] = $object;
$this->add_group_labels($grouped_label);
}
break;
}
}
$has_sort_grouped_objects = $this->get_setting('grouped_objects', 'default', 'sort');
if($has_sort_grouped_objects) {
uksort($grouped_objects, array($this, "_sort_grouped_objects"));
if(count($this->applied_group) > 1) {
foreach ($grouped_objects as $group_name=>$second_grouped_objects) {
uksort($second_grouped_objects, array($this, "_sort_grouped_objects"));
$grouped_objects[$group_name] = $second_grouped_objects;
}
}
if(!empty($this->applied_group_labels)) {
usort($this->applied_group_labels, array($this, '_compare_diacrit'));
}
}
$this->grouped_objects = $grouped_objects;
}
return $this->grouped_objects;
}
/**
* Contenu d'une colonne utilisée pour le groupement
* @param string $property
* @param string $value
*/
protected function get_cell_group_label($group_label, $indice=0) {
$content = '';
switch($this->applied_group[$indice]) {
default :
$content .= $group_label;
break;
}
return $content;
}
/**
* Contenu d'une colonne
* @param object $object
* @param string $property
*/
protected function get_cell_content($object, $property) {
$content = '';
switch($property) {
default :
if (is_object($object) && isset($object->{$property})) {
$content .= $object->{$property};
} elseif(method_exists($object, 'get_'.$property)) {
$content .= call_user_func_array(array($object, "get_".$property), array());
} elseif(isset($this->custom_fields_available_columns[$property])) {
$custom_instance = $this->get_custom_parameters_instance($this->custom_fields_available_columns[$property]['type']);
$property_id = $this->custom_fields_available_columns[$property]['property_id'];
if(method_exists($object, 'get_'.$property_id)) {
$custom_instance->get_values(call_user_func_array(array($object, "get_".$property_id), array()));
} else {
$custom_instance->get_values($object->{$property_id});
}
$field_id = $custom_instance->get_field_id_from_name($property);
if(isset($custom_instance->values[$field_id]) && count($custom_instance->values[$field_id])) {
$content .= $custom_instance->get_formatted_output($custom_instance->values[$field_id], $field_id);
}
}
break;
}
return $content;
}
protected function get_name_cell_edition($object, $property) {
if(method_exists($object, 'get_id')) {
return $this->objects_type."_".$property."_".$object->get_id();
} else {
return $this->objects_type."_".$property."_".$object->id;
}
}
protected function get_value_from_cell_form($object, $property) {
$cell_name = $this->get_name_cell_edition($object, $property);
global ${$cell_name};
return stripslashes(${$cell_name});
}
protected function get_options_cell_edition($object, $property) {
return array();
}
protected function get_cell_edition_content_number($object, $property) {
global $charset;
$size = 2;
$maxlength = 3;
return "";
foreach($options as $option) {
if (!isset($option["value"])) $option["value"] = '';
if ($option["value"]!="") {
$selector .= "{$property} == $option["value"])
$selector .= " selected";
$selector .= ">".$option["label"]." ";
} else {
$res = pmb_mysql_query($option["query"]);
while($val = pmb_mysql_fetch_array($res)) {
$selector .= "{$property} == $val[0])
$selector .= " selected";
$selector .= ">".$val[1]." ";
}
}
}
$selector .= " ";
return $selector;
}
protected function get_cell_edition_content_radio($object, $property) {
$radio = '';
$options = $this->get_options_cell_edition($object, $property);
foreach($options as $option) {
$radio .= "".$content." ";
return $display;
}
/**
* Affichage d'une colonne avec du HTML non calculé
* @param string $value
*/
protected function get_display_cell_html_value($object, $value) {
if(method_exists($object, 'get_id')) {
$value = str_replace('!!id!!', $object->get_id(), $value);
} else {
$value = str_replace('!!id!!', $object->id, $value);
}
$display = $this->get_display_format_cell($value);
return $display;
}
/**
* Affichage d'une colonne
* @param object $object
* @param string $property
*/
protected function get_display_cell($object, $property) {
$display_mode = $this->get_setting('columns', $property, 'display_mode');
if($display_mode == 'edition') {
$content = $this->get_cell_edition_content($object, $property);
} else {
$content = $this->get_cell_content($object, $property);
}
$display = $this->get_display_format_cell($content, $property);
return $display;
}
/**
* Objet de la liste
*/
protected function get_display_content_object_list($object, $indice) {
$ancre = "";
if(!empty($this->ancre) && method_exists($object, 'get_id') && $this->ancre==$object->get_id()) {
$ancre = " id='".$this->objects_type."_object_list_ancre' ";
}
$onclick = "";
if(!empty($this->is_editable_object_list) && method_exists($this, 'get_edition_link')) {
$onclick = "onclick=\"document.location='".$this->get_edition_link($object)."';\" style='cursor: pointer'";
}
$display = "
";
foreach ($this->columns as $column) {
if($column['html']) {
$display .= $this->get_display_cell_html_value($object, $column['html']);
} else {
$display .= $this->get_display_cell($object, $column['property']);
}
}
$display .= " ";
return $display;
}
protected function get_display_group_header_list($group_label, $level=1) {
$display = "
".$this->get_cell_group_label($group_label, ($level-1))."
";
return $display;
}
protected function get_uid_group($uid, $group_label) {
if($group_label) {
return $uid."_".pmb_alphabetic('^a-z0-9', '',pmb_strtolower($group_label));
} else {
return $uid;
}
}
protected function gen_plus($id, $titre, $contenu, $maximise=0) {
return gen_plus($id, $titre, $contenu, $maximise);
}
/**
* Liste des objets par groupe
*/
protected function get_display_group_content_list($grouped_objects, $level=1, $uid='') {
$display = '';
$display_mode = $this->get_setting('grouped_objects', 'level_'.$level, 'display_mode');
if(empty($uid)) {
$uid = $this->objects_type."_list";
}
switch ($display_mode) {
case 'expandable_table':
foreach($grouped_objects as $group_label=>$objects) {
$display_expandable_content = "";
$expanded_display = $this->get_setting('grouped_objects', 'level_'.$level, 'expanded_display');
$uid_group = $this->get_uid_group($uid, $group_label);
if(empty($objects[0])) {
$display_expandable_content .= $this->get_display_group_content_list($objects, ($level+1), $uid_group);
$display .= $this->gen_plus($uid_group,$group_label,$display_expandable_content,$expanded_display);
} else {
$display_expandable_content .= "";
$display_expandable_content .= $this->get_display_header_list();
$indice = 0;
foreach ($objects as $object) {
$display_expandable_content .= $this->get_display_content_object_list($object, $indice);
$indice++;
}
$display_expandable_content .= "
";
$display .= $this->gen_plus($uid_group,$group_label,$display_expandable_content,$expanded_display);
}
}
break;
case 'table':
default:
$group_number = 0;
$group_last_number = count($grouped_objects)-1;
foreach($grouped_objects as $group_label=>$objects) {
$uid_group = $this->get_uid_group($uid, $group_label);
if($group_number==0 && $level > 1) {
$display_previous_mode = $this->get_setting('grouped_objects', 'level_'.($level-1), 'display_mode');
if($display_previous_mode == 'expandable_table') {
$display .= "";
$display .= $this->get_display_header_list();
}
}
$display .= $this->get_display_group_header_list($group_label, $level);
if(empty($objects[0])) {
$display .= $this->get_display_group_content_list($objects, ($level+1), $uid_group);
} else {
$indice = 0;
foreach ($objects as $object) {
$display .= $this->get_display_content_object_list($object, $indice);
$indice++;
}
}
if($group_number==$group_last_number && $level > 1) {
$display_previous_mode = $this->get_setting('grouped_objects', 'level_'.($level-1), 'display_mode');
if($display_previous_mode == 'expandable_table') {
$display .= "
";
}
}
$group_number++;
}
break;
}
return $display;
}
/**
* Liste des objets
*/
public function get_display_content_list() {
$display = '';
if(isset($this->applied_group[0]) && $this->applied_group[0]) {
$grouped_objects = $this->get_grouped_objects();
$display .= $this->get_display_group_content_list($grouped_objects);
} else {
foreach ($this->objects as $i=>$object) {
$display .= $this->get_display_content_object_list($object, $i);
}
}
return $display;
}
protected function get_display_content_list_switch() {
$display = "
";
return $display;
}
public function get_error_message_empty_list() {
return '';
}
/**
* Message indiquant que la liste est vide
*/
public function get_display_empty_content_list() {
$display = "";
$error_message = $this->get_error_message_empty_list();
if($error_message) {
$display .= "
".$error_message."
";
}
return $display;
}
/**
* Affichage de la liste des objets
* @return string
*/
public function get_display_objects_list() {
global $current_module, $msg, $action;
$display = '';
$display_mode = $this->get_setting('objects', 'default', 'display_mode');
switch ($display_mode) {
case 'expandable_table':
if(count($this->objects)) {
$display .= $this->get_js_sort_expandable_list();
$display .= $this->get_display_content_list();
} else {
$display .= $this->get_display_empty_content_list();
}
break;
case 'form_table':
$display .= "";
break;
case 'table':
default:
$display .= "";
if($this->get_setting('display', 'objects_list', 'deffered_load')) {
$display .= "
";
break;
}
return $display;
}
/**
* Affiche la recherche + la liste
*/
public function get_display_list() {
$display = $this->get_title();
// Affichage du formulaire de recherche
$display .= $this->get_display_search_form();
// Affichage de la human_query
if($this->settings['display']['query']['human']) {
$display .= $this->_get_query_human();
}
//Récupération du script JS de tris
$display .= $this->get_js_sort_script_sort();
if(!empty($this->is_displayed_go_directly_to_block) && !empty($this->applied_group[0])) {
if(count($this->objects) > 20) {
$display .= $this->get_display_go_directly_to_action('top');
}
}
//Affichage de la liste des objets
$display .= $this->get_display_objects_list();
if(!empty($this->is_displayed_go_directly_to_block) && !empty($this->applied_group[0])) {
$display .= $this->get_display_go_directly_to_action('bottom');
}
if(count($this->get_selection_actions())) {
$display .= $this->get_display_selection_actions();
}
$display .= $this->get_display_others_actions();
$display .= $this->pager();
$display .= "
";
return $display;
}
protected function get_display_go_directly_to_action($zone='bottom') {
global $msg, $charset;
$display = '';
if(!empty($this->applied_group_labels)) {
$display .= "
".htmlentities($msg['edit_go_directly_to'], ENT_QUOTES, $charset)." :
objects_type."_search_form.".$this->objects_type."_page.value=this.selectedOptions[0].getAttribute('data-page');document.forms['".$this->objects_type."_search_form'].submit();\">
".htmlentities($label, ENT_QUOTES, $charset)." ";
}
$display .= "
";
}
return $display;
}
protected static function set_selected_objects_from_form() {
$objects_type = str_replace('list_', '', static::class);
$selected_objects = $objects_type."_selected_objects";
global ${$selected_objects};
if(is_array(${$selected_objects}) && count(${$selected_objects})) {
$_SESSION['list_'.$objects_type.'_selected_objects'] = ${$selected_objects};
}
}
protected static function get_selected_objects() {
static::set_selected_objects_from_form();
$selected_objects = array();
$objects_type = str_replace('list_', '', static::class);
if(isset($_SESSION['list_'.$objects_type.'_selected_objects']) && is_array($_SESSION['list_'.$objects_type.'_selected_objects'])) {
$selected_objects = $_SESSION['list_'.$objects_type.'_selected_objects'];
//Destruction de la variable de session pour ne pas exécuter l'action plusieurs fois
unset($_SESSION['list_'.$objects_type.'_selected_objects']);
}
return $selected_objects;
}
protected function get_selection_action($name, $label, $icon, $link = array()) {
return array(
'name' => $name,
'label' => $label,
'icon' => $icon,
'link' => $link
);
}
protected function get_selection_actions() {
if(!isset($this->selection_actions)) {
$this->selection_actions = array();
}
return $this->selection_actions;
}
protected function get_selection_mode() {
return 'icon';
}
protected function get_display_selection_action_attributes($attributes) {
$display = '';
foreach ($attributes as $key=>$attribute) {
$display .= " data-attribute-".$key."='".$attribute."'";
}
return $display;
}
protected function get_display_selection_action($action) {
global $charset;
$display = "
objects_type."_selection_action_".$action['name']."'>";
switch ($this->get_selection_mode()) {
case 'button':
$display .= "
";
break;
case 'icon-dialog':
$display .= "
get_display_selection_action_attributes($action['attributes']) : '')." style='cursor:pointer;'>
";
break;
}
$display .= "
";
return $display;
}
protected function get_name_selected_objects() {
return $this->objects_type."_selected_objects";
}
protected function get_error_message_empty_selection($action=array()) {
global $msg;
return $msg['list_ui_no_selected'];
}
protected function add_event_on_selection_action($action=array()) {
$display = "
on(dom.byId('".$this->objects_type."_selection_action_".$action['name']."_link'), 'click', function() {
var selection = new Array();
query('.".$this->objects_type."_selection:checked').forEach(function(node) {
selection.push(node.value);
});
if(selection.length) {
var confirm_msg = '".(isset($action['link']['confirm']) ? addslashes($action['link']['confirm']) : '')."';
if(!confirm_msg || confirm(confirm_msg)) {
".(isset($action['link']['href']) && $action['link']['href'] ? "
var selected_objects_form = domConstruct.create('form', {
action : '".$action['link']['href']."',
name : '".$this->objects_type."_selected_objects_form',
id : '".$this->objects_type."_selected_objects_form',
method : 'POST'
});
selection.forEach(function(selected_option) {
var selected_objects_hidden = domConstruct.create('input', {
type : 'hidden',
name : '".$this->get_name_selected_objects()."[]',
value : selected_option
});
domConstruct.place(selected_objects_hidden, selected_objects_form);
});
domConstruct.place(selected_objects_form, dom.byId('list_ui_selection_actions'));
dom.byId('".$this->objects_type."_selected_objects_form').submit();
"
: "")."
".(isset($action['link']['openPopUp']) && $action['link']['openPopUp'] ? "openPopUp('".$action['link']['openPopUp']."&selected_objects='+selection.join(','), '".$action['link']['openPopUpTitle']."'); return false;" : "")."
".(isset($action['link']['onClick']) && $action['link']['onClick'] ? $action['link']['onClick']."(selection); return false;" : "")."
}
} else {
alert('".addslashes($this->get_error_message_empty_selection($action))."');
}
});
";
return $display;
}
protected function add_events_on_selection_actions() {
$display = "";
return $display;
}
protected function get_display_selection_actions() {
global $msg, $charset;
$display = "
".htmlentities($msg['list_ui_selection'], ENT_QUOTES, $charset)." :
";
$this->get_event_list_ui_selection_action();
foreach($this->get_selection_actions() as $action) {
$display .= $this->get_display_selection_action($action);
}
$display .= "
";
$display .= $this->add_events_on_selection_actions();
$display .= "
";
return $display;
}
protected function get_display_others_actions() {
return "";
}
protected function add_event_on_global_action($action=array()) {
global $msg;
$display = "
";
return $display;
}
protected function pager_custom() {
global $msg;
global $pmb_items_pagination_custom;
$nav_bar = "";
if($pmb_items_pagination_custom) {
$pagination_custom = explode(',', $pmb_items_pagination_custom);
if(count($pagination_custom)) {
$max_nb_elements = 0;
$nb_first_custom_element = $pagination_custom[0];
foreach ($pagination_custom as $nb_elements) {
$nb_elements = trim($nb_elements)+0;
if($nb_first_custom_element <= $this->pager['nb_results']) {
if($nb_elements == $this->pager['nb_per_page']) $nav_bar .= "";
$nav_bar .= "get_form_name().".".$this->objects_type."_page.value=1;document.".$this->get_form_name().".".$this->objects_type."_nb_per_page.value=".$nb_elements."; document.".$this->get_form_name().".submit(); return false;\"> ".$nb_elements." ";
if($nb_elements == $this->pager['nb_per_page']) $nav_bar .= " ";
}
if($nb_elements > $max_nb_elements) {
$max_nb_elements = $nb_elements;
}
}
if((($max_nb_elements > $this->pager['nb_results']) && ($this->pager['nb_per_page'] < $this->pager['nb_results'])) || ($this->pager['allow_force_all_on_page'] && ($this->pager['nb_per_page'] < $this->pager['nb_results']))) {
$nav_bar .= "get_form_name().".".$this->objects_type."_page.value=1;document.".$this->get_form_name().".".$this->objects_type."_nb_per_page.value=".$this->pager['nb_results']."; document.".$this->get_form_name().".submit(); return false;\"> ".$msg['tout_afficher']." ";
}
}
} else {
$nav_bar .= "get_form_name().".".$this->objects_type."_page.value=1;document.".$this->get_form_name().".".$this->objects_type."_nb_per_page.value=25; document.".$this->get_form_name().".submit(); return false;\"> 25 ";
$nav_bar .= "get_form_name().".".$this->objects_type."_page.value=1;document.".$this->get_form_name().".".$this->objects_type."_nb_per_page.value=50; document.".$this->get_form_name().".submit(); return false;\"> 50 ";
$nav_bar .= "get_form_name().".".$this->objects_type."_page.value=1;document.".$this->get_form_name().".".$this->objects_type."_nb_per_page.value=100; document.".$this->get_form_name().".submit(); return false;\"> 100 ";
}
if($nav_bar) {
return " ".$msg['per_page']." ".$nav_bar." ";
}
return "";
}
protected function pager() {
global $msg;
if (!$this->pager['nb_results'] || !$this->pager['nb_per_page']) return;
$this->pager['nb_page']=ceil($this->pager['nb_results']/$this->pager['nb_per_page']);
$suivante = $this->pager['page']+1;
$precedente = $this->pager['page']-1;
$nav_bar = '';
// affichage du lien précédent si nécéssaire
if($precedente > 0) {
$nav_bar .= "get_form_name().".".$this->objects_type."_page.value=".$precedente."; document.".$this->get_form_name().".submit(); return false;\"> ";
}
$deb = $this->pager['page'] - 10 ;
if ($deb<1) $deb=1;
for($i = $deb; ($i <= $this->pager['nb_page']) && ($i <= $this->pager['page']+10); $i++) {
if($i==$this->pager['page']) $nav_bar .= "".$i." ";
else $nav_bar .= "get_form_name().".".$this->objects_type."_page.value=".$i."; document.".$this->get_form_name().".submit(); return false;\">".$i." ";
if($i<$this->pager['nb_page']) $nav_bar .= " ";
}
if($suivante <= $this->pager['nb_page']) {
$nav_bar .= "get_form_name().".".$this->objects_type."_page.value=".$suivante."; document.".$this->get_form_name().".submit(); return false;\"> ";
}
$start_in_page = ((($this->pager['page']-1)*$this->pager['nb_per_page'])+1);
if(($start_in_page + $this->pager['nb_per_page']) > $this->pager['nb_results']) {
$end_in_page = $this->pager['nb_results'];
} else {
$end_in_page = ((($this->pager['page']-1)*$this->pager['nb_per_page'])+$this->pager['nb_per_page']);
}
$nav_bar .= " (".$start_in_page." - ".$end_in_page." / ".$this->pager['nb_results'].")";
if($this->pager['nb_page'] && ($this->pager['nb_results'] >= $this->pager['nb_per_page'])) {
$nav_bar .= $this->pager_custom();
}
// affichage de la barre de navigation
return "
";
}
protected function _get_label_query_human($label, $value) {
global $msg, $charset;
if(is_array($value)) {
if(!empty($value['date_start']) || !empty($value['date_end'])) {
if(!empty($value['date_start']) && !empty($value['date_end'])) {
return "".htmlentities($label, ENT_QUOTES, $charset)." (".$value['date_start']." - ".$value['date_end']." )";
} elseif(!empty($value['date_start'])) {
return "".htmlentities($label." - ".$msg['list_ui_filter_date_start'], ENT_QUOTES, $charset)." ".$value['date_start']." ";
} else {
return "".htmlentities($label." - ".$msg['list_ui_filter_date_end'], ENT_QUOTES, $charset)." ".$value['date_end']." ";
}
} else {
return "".htmlentities($label, ENT_QUOTES, $charset)." ".implode(', ', $value)." ";
}
} else {
return "".htmlentities($label, ENT_QUOTES, $charset)." ".$value." ";
}
}
protected function _get_label_query_human_from_query($label, $query) {
$result = pmb_mysql_query($query);
$elements = array();
while ($row = pmb_mysql_fetch_array($result)) {
$elements[] = $row[0];
}
return $this->_get_label_query_human($label, $elements);
}
protected function get_display_human_remove_filter($filter_name, $human) {
global $msg, $charset;
//DG - Allons-y au fur et à mesure
//Cela n'est pas encore uniformisé partout..
$authorized_lists = array(
'equations_ui'
);
$display = $human;
if(in_array($this->objects_type, $authorized_lists) && array_key_exists($filter_name, $this->selected_filters)) {
$display .= "
";
}
return $display;
}
protected function get_display_query_human($humans) {
global $msg, $charset;
if(!count($humans)) {
$humans['no_filter'] = "".htmlentities($msg['list_ui_no_filter'], ENT_QUOTES, $charset)." ";
} else {
foreach ($humans as $filter_name=>$human) {
$humans[$filter_name] = $this->get_display_human_remove_filter($filter_name, $human);
}
}
return "
";
}
protected function _get_query_property_filter($property) {
return '';
}
protected function _get_query_human_interval_date($property) {
$interval_date = array();
if($this->filters[$property.'_start']) {
$interval_date['date_start'] = formatdate($this->filters[$property.'_start']);
}
if($this->filters[$property.'_end']) {
$interval_date['date_end'] = formatdate($this->filters[$property.'_end']);
}
return $interval_date;
}
protected function _get_query_human() {
$humans = $this->_get_query_human_main_fields();
return $this->get_display_query_human($humans);
}
protected function _get_query_human_main_field($property, $label) {
$method_name = "_get_query_human_".$property;
if(method_exists($this, $method_name)) {
$values = call_user_func(array($this, $method_name));
if(!empty($values)) {
return $this->_get_label_query_human($label, $values);
}
} else {
if(!empty($this->filters[$property])) {
$query = $this->_get_query_property_filter($property);
if($query) {
return $this->_get_label_query_human_from_query($label, $query);
} else {
return $this->_get_label_query_human($label, $this->filters[$property]);
}
}
}
return false;
}
protected function _get_query_human_main_fields() {
global $msg;
$humans = array();
if(!empty($this->available_filters['main_fields'])) {
foreach ($this->available_filters['main_fields'] as $property=>$label_code) {
$label = (isset($msg[$label_code]) ? $msg[$label_code] : $label_code);
$human = $this->_get_query_human_main_field($property, $label);
if($human) {
$humans[$property] = $human;
}
}
}
return $humans;
}
protected function _get_query_human_custom_fields() {
global $msg;
$humans = array();
if(!empty($this->custom_fields_available_filters)) {
foreach ($this->custom_fields_available_filters as $property=>$data) {
if(!empty($this->filters["#custom_field#".$property])) {
$prefix = $data['type'];
$cp = $this->get_custom_parameters_instance($prefix);
if(count($this->filters["#custom_field#".$property]) > 1 || (is_array($this->filters["#custom_field#".$property]) && isset($this->filters["#custom_field#".$property][0]) && $this->filters["#custom_field#".$property][0] != "-1" && $this->filters["#custom_field#".$property][0] != "")){
$id = $cp->get_field_id_from_name($property);
if (($cp->t_fields[$id]['TYPE']!="list")&&($cp->t_fields[$id]['TYPE']!="query_list")) {
$cp->t_fields[$id]['OPTIONS'][0]['UNSELECT_ITEM'][0]['VALUE']="-1";
$cp->t_fields[$id]['OPTIONS'][0]['UNSELECT_ITEM'][0]['value']=$msg["empr_perso_all_values"];
}
$temp=array();
foreach($this->filters["#custom_field#".$property] as $dummykey) {
if ($dummykey!=$cp->t_fields[$id]['OPTIONS'][0]['UNSELECT_ITEM'][0]['VALUE']) {
if (($cp->t_fields[$id]['DATATYPE']=="text")||($cp->t_fields[$id]['DATATYPE']=="comment")) $temp[]=$dummykey;
else $temp[]=$cp->get_formatted_output(array($dummykey),$id);
}
}
if (count($temp)) {
$humans[$cp->t_fields[$id]["NAME"]] = $this->_get_label_query_human($cp->t_fields[$id]["TITRE"], implode(",",$temp));
}
}
}
}
}
return $humans;
}
public function get_export_icons() {
global $msg;
if($this->get_setting('display', 'search_form', 'export_icons')) {
return "
';
foreach ($this->columns as $column) {
if(!empty($column['exportable'])) {
$display .= "".$this->_get_label_cell_header($column['label'])." ";
}
}
$display .= ' ';
return $display;
}
protected function get_display_html_cell($object, $property) {
$display = "".strip_tags($this->get_cell_content($object, $property))." ";
return $display;
}
/**
* Objet de la liste du tableau HTML
*/
protected function get_display_html_content_object_list($object, $indice) {
$display = "
";
foreach ($this->columns as $column) {
if(!empty($column['exportable'])) {
if($column['html']) {
$display .= " ";
return $display;
}
/**
* Liste des objets du tableau HTML
*/
public function get_display_html_content_list() {
$display = '';
if(isset($this->applied_group[0]) && $this->applied_group[0]) {
$grouped_objects = $this->get_grouped_objects();
foreach($grouped_objects as $group_label=>$objects) {
$display .= "
".$group_label."
";
foreach ($objects as $i=>$object) {
$display .= $this->get_display_html_content_object_list($object, $i);
}
}
} else {
foreach ($this->objects as $i=>$object) {
$display .= $this->get_display_html_content_object_list($object, $i);
}
}
return $display;
}
public function get_display_html_list() {
global $msg, $charset;
global $base_path;
$display = $this->get_html_title();
// Affichage de la human_query
$display .= $this->_get_query_human();
//Affichage de la liste des objets
$display .= "";
$display .= $this->get_display_html_header_list();
if(count($this->objects)) {
$display .= $this->get_display_html_content_list();
}
$display .= "
";
return $display;
}
/**
* Sauvegarde des filtres sélectionnées en session
*/
public function set_selected_filters_in_session() {
$_SESSION['list_'.$this->objects_type.'_selected_filters'] = array();
foreach ($this->selected_filters as $property=>$label) {
$_SESSION['list_'.$this->objects_type.'_selected_filters'][$property] = $label;
}
}
/**
* Sauvegarde des filtres en session
*/
public function set_filter_in_session() {
foreach ($this->filters as $name=>$filter) {
$_SESSION['list_'.$this->objects_type.'_filter'][$name] = $filter;
}
}
/**
* Sauvegarde des paramétrages en session
*/
public function set_settings_in_session() {
$_SESSION['list_'.$this->objects_type.'_settings'] = array();
foreach ($this->settings as $group_settings_name=>$group_settings) {
$_SESSION['list_'.$this->objects_type.'_settings'][$group_settings_name] = $group_settings;
}
}
/**
* Sauvegarde du groupement en session
*/
public function set_applied_group_in_session() {
$_SESSION['list_'.$this->objects_type.'_applied_group'] = array();
foreach ($this->applied_group as $name=>$applied_group) {
$_SESSION['list_'.$this->objects_type.'_applied_group'][$name] = $applied_group;
}
}
/**
* Sauvegarde de la pagination en session
*/
public function set_pager_in_session() {
$_SESSION['list_'.$this->objects_type.'_pager']['nb_per_page'] = $this->pager['nb_per_page'];
}
/**
* Sauvegarde du tri appliqué en session
*/
public function set_applied_sort_in_session() {
$_SESSION['list_'.$this->objects_type.'_applied_sort'] = array();
foreach ($this->applied_sort as $applied_sort) {
$_SESSION['list_'.$this->objects_type.'_applied_sort'][] = $applied_sort;
}
}
/**
* Sauvegarde des colonnes en session
*/
public function set_selected_columns_in_session() {
$_SESSION['list_'.$this->objects_type.'_selected_columns'] = array();
foreach ($this->selected_columns as $property=>$label) {
$_SESSION['list_'.$this->objects_type.'_selected_columns'][$property] = $label;
}
}
public function get_objects_type() {
return $this->objects_type;
}
public function get_objects() {
return $this->objects;
}
public function get_applied_sort() {
return $this->applied_sort;
}
public function get_filters() {
return $this->filters;
}
public function get_settings() {
return $this->settings;
}
public function get_setting($name, $property, $sub_property) {
if(isset($this->settings[$name][$property][$sub_property])) {
return $this->settings[$name][$property][$sub_property];
} else {
return $this->settings[$name]['default'][$sub_property] ?? "";
}
}
public function get_applied_group() {
return $this->applied_group;
}
public function get_selected_columns() {
return $this->selected_columns;
}
public function get_pager() {
return $this->pager;
}
public function get_selected_filters() {
return $this->selected_filters;
}
public function get_messages() {
return $this->messages;
}
public function set_objects_type($objects_type) {
$this->objects_type = $objects_type;
}
public function set_objects($objects) {
$this->objects = $objects;
}
public function set_applied_sort($applied_sort) {
$this->applied_sort = $applied_sort;
}
public function set_filters($filters) {
$this->filters = $filters;
}
public function set_settings($settings) {
$this->settings = $settings;
}
public function set_setting($name, $property, $sub_property, $value) {
$this->settings[$name][$property][$sub_property] = $value;
}
public function set_applied_group($applied_group) {
$this->applied_group = $applied_group;
}
public function set_messages($messages) {
$this->messages = $messages;
}
public function set_expandable_title($expandable_title) {
$this->expandable_title = $expandable_title;
}
public function set_ancre($ancre) {
$this->ancre = intval($ancre);
}
protected function is_session_values(){
if((isset($_SESSION['list_'.$this->objects_type.'_filter']) && $this->get_sign($_SESSION['list_'.$this->objects_type.'_filter']) != $this->sign_filters)
|| (isset($_SESSION['list_'.$this->objects_type.'_applied_group']) && $this->get_sign($_SESSION['list_'.$this->objects_type.'_applied_group']) != $this->sign_applied_group)
|| (isset($_SESSION['list_'.$this->objects_type.'_selected_columns']) && $this->get_sign($_SESSION['list_'.$this->objects_type.'_selected_columns']) != $this->sign_selected_columns)
|| (isset($_SESSION['list_'.$this->objects_type.'_applied_sort']) && $this->get_sign($_SESSION['list_'.$this->objects_type.'_applied_sort']) != $this->sign_applied_sort)
|| (isset($_SESSION['list_'.$this->objects_type.'_pager']) && $this->get_sign($_SESSION['list_'.$this->objects_type.'_pager']['nb_per_page']) != $this->sign_pager)
|| (isset($_SESSION['list_'.$this->objects_type.'_selected_filters']) && $this->get_sign($_SESSION['list_'.$this->objects_type.'_selected_filters']) != $this->sign_selected_filters)
) {
return true;
}
return false;
}
protected function unset_session_values($what){
if(isset($_SESSION['list_'.$this->objects_type.'_'.$what])) {
unset($_SESSION['list_'.$this->objects_type.'_'.$what]);
}
}
protected function unset_global_values($property){
if(is_array($this->{$property})) {
switch ($property) {
case 'applied_group':
case 'applied_sort':
$from_form = $this->objects_type.'_'.$property;
global ${$from_form};
if(isset(${$from_form})) {
unset(${$from_form});
unset($GLOBALS[$from_form]);
}
break;
default:
foreach ($this->{$property} as $key=>$value) {
$from_form = $this->objects_type.'_'.$key;
global ${$from_form};
if(isset(${$from_form})) {
unset($GLOBALS[$from_form]);
}
//Pour gérer les autres cas
$from_form = $key;
global ${$from_form};
if(isset(${$from_form})) {
unset($GLOBALS[$from_form]);
}
}
break;
}
}
}
public static function unset_property_values_in_session($objects_type, $what, $property){
if(isset($_SESSION['list_'.$objects_type.'_'.$what][$property])) {
unset($_SESSION['list_'.$objects_type.'_'.$what][$property]);
}
}
protected function _compare_diacrit($a, $b) {
if ($a == $b) {
return 0;
}
return (strtolower(convert_diacrit($a)) < strtolower(convert_diacrit($b))) ? -1 : 1;
}
protected function get_sorted_available_columns() {
if(!isset($this->sorted_available_columns)) {
$this->sorted_available_columns = array();
if(count($this->available_columns)) {
foreach ($this->available_columns as $group_columns) {
foreach ($group_columns as $property=>$label) {
$this->sorted_available_columns[$property] = $this->_get_label_cell_header($label);
}
}
uasort($this->sorted_available_columns, array($this, '_compare_diacrit'));
}
}
return $this->sorted_available_columns;
}
protected function get_sorted_available_filters() {
if(!isset($this->sorted_available_filters)) {
$this->sorted_available_filters = array();
if(count($this->available_filters)) {
foreach ($this->available_filters as $group_filters) {
foreach ($group_filters as $property=>$label) {
$this->sorted_available_filters[$property] = $this->_get_label_cell_header($label);
}
}
uasort($this->sorted_available_filters, array($this, '_compare_diacrit'));
}
}
return $this->sorted_available_filters;
}
public function save() {
foreach ($this->selected_columns as $property=>$label) {
if ($this->get_setting('columns', $property, 'display_mode') == 'edition') {
foreach ($this->objects as $object) {
$this->save_object_property($object, $property);
}
}
}
}
protected function is_deffered_load() {
global $current_module;
if($this->get_setting('display', 'objects_list', 'deffered_load') && $current_module != 'ajax') {
return true;
} else {
return false;
}
}
public function get_datasets() {
global $PMBuserid;
if(!isset($this->datasets)) {
$this->datasets = array();
$this->datasets['my'] = array();
$this->datasets['shared'] = array();
$this->datasets['default_selected'] = 0;
$query = "SELECT id_list, list_num_user, list_default_selected, list_autorisations FROM lists WHERE list_objects_type = '".$this->objects_type."'";
$result = pmb_mysql_query($query);
if(pmb_mysql_num_rows($result)) {
while($row = pmb_mysql_fetch_object($result)) {
if($row->list_num_user == $PMBuserid) {
$this->datasets['my'][] = $row->id_list;
if($row->list_default_selected) {
$this->datasets['default_selected'] = $row->id_list;
}
} elseif(in_array($PMBuserid, explode(' ', $row->list_autorisations))) {
$this->datasets['shared'][] = $row->id_list;
}
}
}
}
return $this->datasets;
}
public function get_dataset_default_selected() {
return $this->datasets['default_selected'];
}
public function get_dataset_form($id=0) {
global $msg, $charset;
global $list_dataset_form_tpl;
$id = intval($id);
$list_model = new list_model($id);
if($id) {
$this->selected_columns = $list_model->get_selected_columns();
$this->filters = $list_model->get_filters();
$this->applied_group = $list_model->get_applied_group();
$this->applied_sort = $list_model->get_applied_sort();
$this->pager = $list_model->get_pager();
if(count($list_model->get_selected_filters())) {
$this->selected_filters = $list_model->get_selected_filters();
}
if(count($list_model->get_settings())) {
$this->settings = $list_model->get_settings();
//$this->settings = array_merge($this->settings, $list_model->get_settings());
}
} else {
$list_model->set_objects_type($this->objects_type);
$selected_columns = $this->objects_type.'_json_selected_columns';
global ${$selected_columns};
$this->selected_columns = encoding_normalize::json_decode(stripslashes(${$selected_columns}), true);
$filters = $this->objects_type.'_json_filters';
global ${$filters};
$this->filters = encoding_normalize::json_decode(stripslashes(${$filters}), true);
$applied_group = $this->objects_type.'_json_applied_group';
global ${$applied_group};
$this->applied_group = encoding_normalize::json_decode(stripslashes(${$applied_group}), true);
$applied_sort = $this->objects_type.'_json_applied_sort';
global ${$applied_sort};
$this->applied_sort = encoding_normalize::json_decode(stripslashes(${$applied_sort}), true);
$pager = $this->objects_type.'_pager';
global ${$pager};
$this->pager = encoding_normalize::json_decode(stripslashes(${$pager}), true);
$selected_filters = $this->objects_type.'_selected_filters';
global ${$selected_filters};
$this->selected_filters = encoding_normalize::json_decode(stripslashes(${$selected_filters}), true);
}
$form = $list_dataset_form_tpl;
$form = str_replace('!!action!!', static::get_controller_url_base().'&action=dataset_save&id='.$id, $form);
$form = str_replace('!!cancel_action!!', static::get_controller_url_base(), $form);
$form = str_replace('!!title!!', htmlentities($msg['list_edit'], ENT_QUOTES, $charset), $form);
if($id) {
$form = str_replace('!!delete!!', "
".$this->get_search_add_filter_form()."
"
, $form);
}
} else {
$form = str_replace('!!list_search_add_filter_form_tpl!!', '', $form);
}
$form = str_replace('!!list_options_content_form_tpl!!', $this->get_options_content_form(), $form);
$form = str_replace('!!list_search_order_form_tpl!!', $this->get_search_order_form(), $form);
$form = str_replace('!!list_settings_content_form_tpl!!', $this->get_settings_content_form(), $form);
$form = str_replace('!!nb_per_page!!', $this->pager['nb_per_page'], $form);
$form = str_replace('!!autorisations_users!!', users::get_form_autorisations(implode(' ', $list_model->get_autorisations()),1), $form);
$form = str_replace('!!default_selected!!', ($list_model->get_default_selected() ? "checked='checked'" : ""), $form);
$form = str_replace('!!selected_filters!!', json_encode($this->selected_filters), $form);
$form = str_replace('!!objects_type!!', $list_model->get_objects_type(), $form);
return $form;
}
public function get_default_dataset_form($id=0) {
global $msg, $charset, $base_path;
global $list_default_dataset_form_tpl;
global $object_type;
$id = intval($id);
$list_model = new list_model($id);
if($id) {
$this->selected_columns = $list_model->get_selected_columns();
$this->filters = $list_model->get_filters();
$this->applied_group = $list_model->get_applied_group();
$this->applied_sort = $list_model->get_applied_sort();
$this->pager = $list_model->get_pager();
if(count($list_model->get_selected_filters())) {
$this->selected_filters = $list_model->get_selected_filters();
}
if(count($list_model->get_settings())) {
$this->settings = $list_model->get_settings();
}
} else {
$list_model->set_objects_type($this->objects_type);
}
$form = $list_default_dataset_form_tpl;
$controller_url_base = $base_path."/account.php?categ=lists";
$form = str_replace('!!action!!', $controller_url_base."&action=save&object_type=".$object_type."&id=".$id, $form);
$form = str_replace('!!cancel_action!!', $controller_url_base, $form);
$form = str_replace('!!title!!', strip_tags($this->get_form_title()), $form);
if($id) {
$form = str_replace('!!delete!!', "
".$this->get_search_add_filter_form()."
"
, $form);
} else {
$form = str_replace('!!list_search_add_filter_form_tpl!!', '', $form);
}
$form = str_replace('!!list_options_content_form_tpl!!', $this->get_options_content_form(), $form);
$form = str_replace('!!list_search_order_form_tpl!!', $this->get_search_order_form(), $form);
$form = str_replace('!!list_settings_content_form_tpl!!', $this->get_settings_content_form(), $form);
$form = str_replace('!!nb_per_page!!', $this->pager['nb_per_page'], $form);
$form = str_replace('!!selected_filters!!', json_encode($this->selected_filters), $form);
$form = str_replace('!!objects_type!!', $list_model->get_objects_type(), $form);
return $form;
}
public function add_dataset($id=0) {
if(!isset($this->datasets['my'])) {
$this->datasets['my'] = array();
}
$this->datasets['my'][] = intval($id);
}
public function apply_dataset($id=0) {
$id = intval($id);
$this->set_dataset_id($id);
$this->set_data_from_database();
}
protected function get_sign($to_hash) {
return md5(encoding_normalize::json_encode($to_hash));
}
public static function get_controller_url_base() {
global $base_path, $current_module, $categ, $sub;
return $base_path.'/'.(!empty($_GET['module']) ? $_GET['module'] : $current_module).'.php?categ='.$categ.($sub ? '&sub='.$sub : '');
}
public static function get_instance($filters=array(), $pager=array(), $applied_sort=array()) {
$called_class = static::class;
return new $called_class($filters, $pager, $applied_sort);
}
protected function get_event_list_ui_selection_action() {
$evth = events_handler::get_instance();
$event_type = get_class($this);
$evt = new event_list_ui($event_type, "selection_action");
$evt->set_url_base(static::get_controller_url_base());
$evth->send($evt);
$evt_result = $evt->get_selection_action();
if(!empty($evt_result)){
$this->selection_actions[] = $evt_result;
}
}
public static function set_without_data($without_data) {
static::$without_data = $without_data;
}
}