id_bannette);
}
protected function _get_query_order() {
if ($this->applied_sort[0]['by']) {
$order = '';
$sort_by = $this->applied_sort[0]['by'];
switch($sort_by) {
case 'name':
$order .= 'nom_bannette, comment_public';
break;
case 'comment_public':
$order .= 'comment_public';
break;
default :
$order .= parent::_get_query_order();
break;
}
if($order) {
return $this->_get_query_order_sql_build($order);
} else {
return "";
}
}
}
/**
* Initialisation du tri par défaut appliqué
*/
protected function init_default_applied_sort() {
$this->add_applied_sort('name');
}
/**
* Initialisation des colonnes disponibles
*/
protected function init_available_columns() {
$this->available_columns =
array('main_fields' =>
array(
'name' => 'dsi_ban_form_nom',
'equations' => 'dsi_ban_list_equ',
'number_records' => 'dsi_ban_nb_notices',
'number_subscribed' => 'dsi_ban_nb_abonnes',
'send_last_date' => 'dsi_ban_date_last_envoi',
)
);
$this->available_columns['custom_fields'] = array();
}
protected function init_default_columns() {
$this->add_column('name');
$this->add_column('equations');
$this->add_column('number_records');
$this->add_column('number_subscribed');
$this->add_column('send_last_date');
}
protected function init_default_settings() {
parent::init_default_settings();
$this->set_setting_display('search_form', 'export_icons', false);
}
/**
* Initialisation des filtres disponibles
*/
protected function init_available_filters() {
$this->available_filters =
array('main_fields' =>
array(
'name' => 'dsi_ban_search_nom',
'id_classement' => 'dsi_classement',
)
);
$this->available_filters['custom_fields'] = array();
}
/**
* Initialisation des filtres de recherche
*/
public function init_filters($filters=array()) {
$this->filters = array(
'auto' => '',
'id_classement' => '',
'name' => '',
'proprio_bannette' => '',
'type' => '',
'num_empr' => ''
);
parent::init_filters($filters);
}
protected function init_default_selected_filters() {
$this->add_selected_filter('name');
$this->add_selected_filter('id_classement');
}
/**
* Filtres provenant du formulaire
*/
public function set_filters_from_form() {
global $id_classement;
$this->set_filter_from_form('name');
if(isset($id_classement)) {
$this->filters['id_classement'] = $id_classement;
}
$this->set_filter_from_form('type', 'integer');
parent::set_filters_from_form();
}
protected function get_search_filter_name() {
global $msg;
return "filters['name']."\" title='$msg[3000]' />";
}
protected function get_search_filter_id_classement() {
return gen_liste_classement("BAN", $this->filters['id_classement'], "this.form.submit();");
}
protected function get_search_filter_type() {
global $msg, $charset;
return "";
}
protected function get_button_add() {
global $msg;
return "";
}
/**
* Filtre SQL
*/
protected function _get_query_filters() {
global $sub;
$filter_query = '';
$this->set_filters_from_form();
$filters = array();
if($sub == 'lancer') {
$filters [] = '(DATE_ADD(date_last_envoi, INTERVAL periodicite DAY) <= sysdate())';
}
if($this->filters['auto'] !== '') {
$filters [] = 'bannette_auto = "'.$this->filters['auto'].'"';
}
if($this->filters['id_classement']) {
$filters [] = 'num_classement = "'.$this->filters['id_classement'].'"';
} elseif($this->filters['id_classement'] === 0) {
$filters [] = 'num_classement = "0"';
}
if($this->filters['name']) {
$filters [] = 'nom_bannette like "%'.str_replace("*", "%", addslashes($this->filters['name'])).'%"';
}
if($this->filters['num_empr'] != '') {
$filters [] = 'num_empr = "'.$this->filters['num_empr'].'"';
}
if($this->filters['proprio_bannette'] !== '') {
$filters [] = 'proprio_bannette = "'.$this->filters['proprio_bannette'].'"';
}
if($this->filters['type']) {
switch ($this->filters['type']) {
case 1:
$filters [] = 'proprio_bannette = 0';
break;
case 2:
$filters [] = 'proprio_bannette != 0';
break;
}
}
if(count($filters)) {
$filter_query .= ' where '.implode(' and ', $filters);
}
return $filter_query;
}
protected function _get_label_cell_header($name) {
global $msg, $charset;
switch ($name) {
case 'dsi_ban_form_nom':
return
"".htmlentities($msg['dsi_ban_form_nom'],ENT_QUOTES, $charset)."
(".htmlentities($msg['dsi_classement'],ENT_QUOTES, $charset).")
".htmlentities($msg['dsi_ban_form_com_gestion'],ENT_QUOTES, $charset)."
";
case 'dsi_ban_date_last_envoi':
return "".htmlentities($msg['dsi_ban_date_last_envoi'],ENT_QUOTES, $charset)."
(".htmlentities($msg['dsi_ban_date_last_remp'],ENT_QUOTES, $charset).")";
default:
return "".parent::_get_label_cell_header($name)."";
}
}
protected static function get_equations($id_bannette, $proprio_bannette=0) {
global $msg;
$requete = "select id_equation, num_classement, nom_equation, comment_equation, proprio_equation, num_bannette from equations, bannette_equation where num_equation=id_equation and proprio_equation='".$proprio_bannette."' and num_bannette='".$id_bannette."' order by nom_equation " ;
$resequ = pmb_mysql_query($requete);
$equ_trouvees = pmb_mysql_num_rows($resequ) ;
$equations = "" ;
while ($equa=pmb_mysql_fetch_object($resequ)) {
$eq_form= new equation($equa->id_equation) ;
$equations .= "".$equa->nom_equation.($proprio_bannette ? $eq_form->make_hidden_search_form("","PRI", $proprio_bannette) : '')."";
}
if($equ_trouvees == 0) {
$equations .= $msg['dsi_ban_no_equ'];
} else {
$equations = "";
}
return $equations;
}
/**
* Fonction de callback
* @param object $a
* @param object $b
*/
protected function _compare_objects($a, $b) {
if($this->applied_sort[0]['by']) {
$sort_by = $this->applied_sort[0]['by'];
switch($sort_by) {
case 'equations' :
return strcmp(strip_tags(static::get_equations($a->id_bannette)), strip_tags(static::get_equations($b->id_bannette)));
break;
case 'number_records':
return $this->intcmp($a->nb_notices, $b->nb_notices);
break;
case 'number_subscribed':
return $this->intcmp($a->nb_abonnes, $b->nb_abonnes);
break;
case 'send_last_date':
return strcmp($a->aff_date_last_envoi, $b->aff_date_last_envoi);
break;
default :
return parent::_compare_objects($a, $b);
break;
}
}
}
/**
* Construction dynamique de la fonction JS de tri
*/
protected function get_js_sort_script_sort() {
global $sub;
$display = parent::get_js_sort_script_sort();
$display = str_replace('!!categ!!', 'bannettes', $display);
$display = str_replace('!!sub!!', $sub, $display);
$display = str_replace('!!action!!', 'list', $display);
return $display;
}
protected function get_cell_content($object, $property) {
global $charset;
$content = '';
switch($property) {
case 'name':
$content .= "
".htmlentities($object->nom_bannette,ENT_QUOTES, $charset)."
(".htmlentities($object->nom_classement,ENT_QUOTES, $charset).")
".htmlentities($object->comment_gestion,ENT_QUOTES, $charset)."
";
break;
case 'equations':
$content .= static::get_equations($object->id_bannette);
break;
case 'number_records':
$content .= $object->nb_notices;
break;
case 'number_subscribed':
$content .= $object->nb_abonnes;
if ($object->num_panier) {
$content .= " ![](".get_url_icon()
";
}
break;
case 'send_last_date':
$content .= "".htmlentities($object->aff_date_last_envoi,ENT_QUOTES, $charset)."";
if ($object->alert_diff) {
$content .= "
(".htmlentities($object->aff_date_last_remplissage,ENT_QUOTES, $charset).")";
} else {
$content .= "
(".htmlentities($object->aff_date_last_remplissage,ENT_QUOTES, $charset).")" ;
}
break;
default :
$content .= parent::get_cell_content($object, $property);
break;
}
return $content;
}
protected function get_display_cell($object, $property) {
$onclick="";
switch($property) {
case 'name':
$onclick = "document.location=\"".static::get_controller_url_base()."&id_bannette=".$object->id_bannette."&suite=acces\";";
break;
case 'equations':
$onclick = "document.location=\"".static::get_controller_url_base()."&id_bannette=".$object->id_bannette."&suite=affect_equation\";";
break;
case 'number_subscribed':
$onclick = "document.location=\"".static::get_controller_url_base()."&id_bannette=".$object->id_bannette."&suite=affect_lecteurs\";";
break;
case 'send_last_date':
$onclick = " document.location=\"./dsi.php?categ=diffuser&sub=auto&id_bannette=".$object->id_bannette."\";";
break;
}
$attributes = array(
'style' => 'vertical-align:top;',
'onclick' => $onclick,
);
$content = $this->get_cell_content($object, $property);
$display = $this->get_display_format_cell($content, $property, $attributes);
return $display;
}
protected function _get_query_property_filter($property) {
switch ($property) {
case 'id_classement':
return "select nom_classement from classements where id_classement=".$this->filters[$property];
}
return '';
}
protected function _get_query_human() {
global $msg;
$humans = $this->_get_query_human_main_fields();
if($this->filters['type']) {
$type_label = '';
switch ($this->filters['type']) {
case 1:
$type_label = $msg['dsi_menu_ban_pro'];
break;
case 2:
$type_label = $msg['dsi_menu_ban_abo'];
break;
}
$humans['type'] = $this->_get_label_query_human($msg['dsi_bannette_type'], $type_label);
}
return $this->get_display_query_human($humans);
}
public function set_pager_in_session() {
$_SESSION['list_'.$this->objects_type.'_pager']['page'] = $this->pager['page'];
parent::set_pager_in_session();
}
}