id_faq_question);
}
protected function get_form_title() {
global $msg;
return $msg['faq_filter_form_title'];
}
/**
* Initialisation des filtres disponibles
*/
protected function init_available_filters() {
$this->available_filters =
array('main_fields' =>
array(
'theme' => 'faq_question_theme_label',
'type' => 'faq_question_type_label',
'status' => 'faq_question_statut_label'
)
);
$this->available_filters['custom_fields'] = array();
}
/**
* Initialisation des filtres de recherche
*/
public function init_filters($filters=array()) {
$this->filters = array(
'theme' => 0,
'type' => 0,
'status' => 0,
);
parent::init_filters($filters);
}
protected function init_default_selected_filters() {
$this->add_selected_filter('theme');
$this->add_selected_filter('type');
$this->add_selected_filter('status');
}
protected function init_default_applied_sort() {
$this->add_applied_sort('faq_question_question_date', 'desc');
}
/**
* Initialisation des colonnes disponibles
*/
protected function init_available_columns() {
$this->available_columns =
array('main_fields' =>
array(
'theme' => 'faq_question_theme_label',
'type' => 'faq_question_type_label',
'status' => 'faq_question_statut',
'question' => 'faq_question_question',
'answer' => 'faq_question_answer',
)
);
$this->available_columns['custom_fields'] = array();
}
protected function init_default_columns() {
$this->add_column('theme');
$this->add_column('type');
$this->add_column('status');
$this->add_column('question');
$this->add_column('answer');
}
protected function init_default_settings() {
parent::init_default_settings();
$this->set_setting_display('search_form', 'export_icons', false);
}
/**
* Filtres provenant du formulaire
*/
public function set_filters_from_form() {
global $id_type, $id_theme, $id_statut;
if(isset($id_type)) {
$this->filters['type'] = intval($id_type);
}
if(isset($id_theme)) {
$this->filters['theme'] = intval($id_theme);
}
if(isset($id_statut)) {
$this->filters['status'] = intval($id_statut);
}
parent::set_filters_from_form();
}
protected function get_search_filter_theme() {
return $this->get_themes()->getListSelector($this->filters['theme'],'',true);
}
protected function get_search_filter_type() {
return $this->get_types()->getListSelector($this->filters['type'],'',true);
}
protected function get_search_filter_status() {
global $msg;
return "
";
}
/**
* Affichage du formulaire de recherche
*/
public function get_display_search_form() {
$this->is_displayed_add_filters_block = false;
$display_search_form = parent::get_display_search_form();
return $display_search_form;
}
/**
* Filtre SQL
*/
protected function _get_query_filters() {
$filter_query = '';
$this->set_filters_from_form();
$filters = array();
if($this->filters['theme']) {
$filters [] = 'faq_question_num_theme = "'.$this->filters['theme'].'"';
}
if($this->filters['type']) {
$filters [] = 'faq_question_num_type = "'.$this->filters['type'].'"';
}
if($this->filters['status']) {
$filters [] = 'faq_question_statut = "'.$this->filters['status'].'"';
}
if(count($filters)) {
$filter_query .= ' where '.implode(' and ', $filters);
}
return $filter_query;
}
/**
* Fonction de callback
* @param object $a
* @param object $b
*/
protected function _compare_objects($a, $b) {
global $msg;
if($this->applied_sort[0]['by']) {
$sort_by = $this->applied_sort[0]['by'];
switch($sort_by) {
case 'theme':
return strcmp($this->get_themes()->getLabel($a->num_theme), $this->get_themes()->getLabel($b->num_theme));
break;
case 'type':
return strcmp($this->get_types()->getLabel($a->num_type), $this->get_types()->getLabel($b->num_type));
break;
case 'status':
return strcmp($msg['faq_question_statut_visible_'.$a->statut], $msg['faq_question_statut_visible_'.$b->statut]);
break;
default :
return parent::_compare_objects($a, $b);
break;
}
}
}
/**
* 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!!', 'dmde', $display);
$display = str_replace('!!sub!!', 'faq_questions', $display);
$display = str_replace('!!action!!', 'list', $display);
return $display;
}
protected function get_cell_content($object, $property) {
global $msg;
$content = '';
switch($property) {
case 'theme':
$content .= $this->get_themes()->getLabel($object->num_theme);
break;
case 'type':
$content .= $this->get_types()->getLabel($object->num_type);
break;
case 'status':
$content .= $msg['faq_question_statut_visible_'.$object->statut];
break;
case 'question':
$question = strip_tags($object->question);
if(strlen($question) > 200){
$question = substr($question,0,200)."[...]";
}
$content .= $question;
break;
case 'answer':
$answer = strip_tags($object->answer);
if(strlen($answer) > 200){
$answer = substr($answer,0,200)."[...]";
}
$content .= $answer;
break;
default :
$content .= parent::get_cell_content($object, $property);
break;
}
return $content;
}
protected function get_display_cell($object, $property) {
$attributes = array();
$attributes['onclick'] = "window.location=\"".static::get_controller_url_base()."&action=edit&id=".$object->id."\"";
switch($property) {
case 'question':
$question = strip_tags($object->question);
if(strlen($question) > 200){
$attributes['title'] = $question;
}
break;
case 'answer':
$answer = strip_tags($object->answer);
if(strlen($answer) > 200){
$attributes['title'] = $answer;
}
break;
default:
break;
}
$content = $this->get_cell_content($object, $property);
$display = $this->get_display_format_cell($content, $property, $attributes);
return $display;
}
public function get_error_message_empty_list() {
global $msg, $charset;
return htmlentities($msg['faq_no_question'],ENT_QUOTES,$charset);
}
public function get_themes() {
if(!isset($this->themes)) {
$this->themes = new faq_themes("faq_themes","id_theme","libelle_theme");
}
return $this->themes;
}
public function get_types() {
if(!isset($this->types)) {
$this->types = new faq_types("faq_types", "id_type", "libelle_type");
}
return $this->types;
}
protected function get_button_add() {
global $msg, $charset;
return "";
}
protected function get_display_others_actions() {
global $pmb_opac_url, $msg;
return "
";
}
}