init_section_param();
parent::__construct($filters, $pager, $applied_sort);
}
protected function init_section_param() {
global $include_path, $lang, $allow_section;
if (file_exists($include_path . "/section_param/$lang.xml")) {
_parser_($include_path . "/section_param/$lang.xml", array(
"SECTION" => "_section_"
), "PMBSECTIONS");
$allow_section = 1;
}
}
public function get_form_title() {
return '';
}
protected function get_html_title() {
return '';
}
protected function _get_query_base() {
return "select * from parametres";
}
/**
* Initialisation des filtres disponibles
*/
protected function init_available_filters() {
$this->available_filters =
array('main_fields' =>
array(
'types_param' => '1602',
)
);
$this->available_filters['custom_fields'] = array();
}
/**
* Initialisation des filtres de recherche
*/
public function init_filters($filters=array()) {
$this->filters = array(
'gestion' => 0,
'types_param' => array()
);
parent::init_filters($filters);
}
public function init_applied_group($applied_group=array()) {
global $allow_section;
if($allow_section) {
$this->applied_group = array(0 => 'type_param', 1 => 'section_param');
} else {
$this->applied_group = array(0 => 'type_param');
}
}
/**
* Initialisation des colonnes disponibles
*/
protected function init_available_columns() {
$this->available_columns = array(
'main_fields' => array(
'type_param' => '1602',
'sstype_param' => '1603',
'valeur_param' => '1604',
'comment_param' => 'param_explication',
'section_param' => '295',
),
);
}
protected function init_default_columns() {
$this->add_column('sstype_param');
$this->add_column('valeur_param');
$this->add_column('comment_param');
}
protected function init_default_settings() {
parent::init_default_settings();
$this->set_setting_display('search_form', 'export_icons', false);
$this->set_setting_column('default', 'align', 'left');
$this->settings['objects']['default']['display_mode'] = 'expandable_table';
$this->settings['grouped_objects']['default']['sort'] = 0;
$this->settings['grouped_objects']['level_1']['display_mode'] = 'expandable_table';
}
protected function init_no_sortable_columns() {
$this->no_sortable_columns = array(
'sstype_param', 'valeur_param', 'comment_param'
);
}
protected function init_default_pager() {
parent::init_default_pager();
$this->pager['nb_per_page'] = pmb_mysql_result(pmb_mysql_query("SELECT count(*) FROM parametres where gestion=0"), 0, 0); //Illimité;
$this->set_pager_in_session();
}
/**
* Initialisation du tri par défaut appliqué
*/
protected function init_default_applied_sort() {
$this->add_applied_sort('type_param');
$this->add_applied_sort('section_param');
$this->add_applied_sort('sstype_param');
}
/**
* Tri SQL
*/
protected function _get_query_order() {
if($this->applied_sort[0]['by']) {
$order = '';
$sort_by = $this->applied_sort[0]['by'];
switch($sort_by) {
case 'type_param':
$order .= $sort_by.", section_param, sstype_param";
break;
default :
$order .= $sort_by;
break;
}
if($order) {
return $this->_get_query_order_sql_build($order);
} else {
return "";
}
}
}
/**
* Filtres provenant du formulaire
*/
public function set_filters_from_form() {
$this->set_filter_from_form('types_param');
parent::set_filters_from_form();
}
/**
* Filtre SQL
*/
protected function _get_query_filters() {
$filter_query = '';
$this->set_filters_from_form();
$filters = array();
$filters [] = "gestion = ".$this->filters['gestion'];
if(is_array($this->filters['types_param']) && count($this->filters['types_param'])) {
$filters [] = 'type_param IN ("'.implode('","', addslashes_array($this->filters['types_param'])).'")';
}
if (count($filters)) {
$filter_query .= ' where '.implode(' and ', $filters);
}
return $filter_query;
}
protected function _get_query_human_types_param() {
global $msg;
$types_labels = array();
foreach ($this->filters['types_param'] as $type_param) {
if(isset($msg["param_".$type_param])) {
$types_labels[] = $msg["param_".$type_param];
} else {
$types_labels[] = $type_param;
}
}
return $types_labels;
}
protected function get_grouped_label($object, $property) {
global $msg;
global $section_table;
$grouped_label = '';
switch($property) {
case 'type_param':
$lab_param = $msg["param_" . $object->type_param] ?? "";
if ($lab_param == "")
$lab_param = $object->type_param;
$grouped_label = $lab_param;
break;
case 'section_param':
$grouped_label = $section_table[$object->section_param]["LIB"] ?? "";
break;
default:
$grouped_label = parent::get_grouped_label($object, $property);
break;
}
return $grouped_label;
}
/**
* Construction dynamique de la fonction JS de tri
*/
protected function get_js_sort_script_sort() {
$display = parent::get_js_sort_script_sort();
$display = str_replace('!!categ!!', 'parameters', $display);
$display = str_replace('!!sub!!', '', $display);
$display = str_replace('!!action!!', 'list', $display);
return $display;
}
protected function get_cell_content($object, $property) {
global $msg, $charset, $form_type_param, $form_sstype_param;
$content = '';
switch($property) {
case 'type_param':
if(isset($msg["param_".$object->type_param])) {
$content .= $msg["param_".$object->type_param];
} else {
$content .= $object->type_param;
}
break;
case 'sstype_param':
//Ancre en provenance d'une autre page
if ($object->type_param == $form_type_param && $object->sstype_param == $form_sstype_param) {
$content .= "";
$this->start_open_label = $msg["param_" . $object->type_param];
}
$content .= $object->sstype_param;
break;
case 'valeur_param':
if (preg_match("/<.+>/", $object->valeur_param)) {
$content .= "".htmlentities($object->valeur_param, ENT_QUOTES, $charset)."
";
} else {
$content .= $object->valeur_param;
}
break;
default :
$content .= parent::get_cell_content($object, $property);
break;
}
return $content;
}
protected function get_display_cell($object, $property) {
$class = '';
$style = '';
switch($property) {
case 'sstype_param':
$style .= 'vertical-align:top;';
break;
case 'valeur_param':
$class .= "ligne_data";
break;
case 'comment_param':
$style .= 'vertical-align:top;';
break;
}
$attributes = array(
'class' => $class,
'style' => $style,
);
$content = $this->get_cell_content($object, $property);
$display = $this->get_display_format_cell($content, $property, $attributes);
return $display;
}
protected function get_display_content_object_list($object, $indice) {
global $form_type_param, $form_sstype_param;
$className = ($indice % 2 ? 'odd' : 'even');
$surbrillance = "surbrillance";
if ($object->type_param == $form_type_param && $object->sstype_param == $form_sstype_param) {
$className .= " justmodified";
$surbrillance .= " justmodified";
}
$display = " $object->type_param . ' ' . $object->sstype_param . ' ' . $object->comment_param . ' ' . $object->valeur_param
))) . "' style='cursor: pointer;'>";
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) {
if(empty($group_label)) {
return '';
}
$display = "
|
".$this->get_cell_group_label($group_label, ($level-1))."
|
";
return $display;
}
protected function gen_plus($id, $titre, $contenu, $maximise=0) {
global $msg;
return "
![](\"" "\\"\"")
" . $titre . "
\n
start_open_label) && $this->start_open_label == $titre ? " startOpen='Yes' " : "").">
".$contenu."
";
}
public function get_display_list() {
//Récupération du script JS de tris
$display = $this->get_js_sort_script_sort();
//Affichage de la liste des objets
$display .= $this->get_display_objects_list();
if(count($this->get_selection_actions())) {
$display .= $this->get_display_selection_actions();
}
$display .= "
";
return $display;
}
protected function get_selection_actions() {
if(!isset($this->selection_actions)) {
$this->selection_actions = array();
}
return $this->selection_actions;
}
}