objects_type = str_replace('list_', '', get_class($this));
if($filters['proprio_bannette']) {
$this->objects_type .= "_priv";
} else {
$this->objects_type .= "_pub";
}
parent::__construct($filters, $pager, $applied_sort);
}
protected function get_empr_categ() {
$query = "select empr_categ from empr join empr_categ on empr.empr_categ = empr_categ.id_categ_empr where id_empr =".static::$id_empr;
$result = pmb_mysql_query($query);
return pmb_mysql_result($result, 0, 'empr_categ');
}
protected function get_empr_cat_l() {
$query = "select libelle from empr join empr_categ on empr.empr_categ = empr_categ.id_categ_empr where id_empr =".static::$id_empr;
$result = pmb_mysql_query($query);
return pmb_mysql_result($result, 0, 'libelle');
}
protected function get_access_liste_id() {
$access_liste_id = array();
$query = "SELECT empr_categ_num_bannette FROM bannette_empr_categs WHERE empr_categ_num_categ=".$this->get_empr_categ();
$result = pmb_mysql_query($query);
while ($row = pmb_mysql_fetch_object($result)) {
$access_liste_id[] = $row->empr_categ_num_bannette;
}
$query = "select groupe_id from empr_groupe where empr_id=".static::$id_empr." AND groupe_id != 0";//En création de lecteur une entrée avec groupe_id = 0 est créée ...
$result = pmb_mysql_query($query);
$groups = array();
while ($row=pmb_mysql_fetch_object($result)) {
$groups[] = $row->groupe_id;
}
if (count($groups)) {
$query = "SELECT empr_groupe_num_bannette FROM bannette_empr_groupes WHERE empr_groupe_num_groupe IN (".implode(",",$groups).")";
$result = pmb_mysql_query($query);
while ($row = pmb_mysql_fetch_object($result)) {
$access_liste_id[] = $row->empr_groupe_num_bannette;
}
}
if (count($access_liste_id)) {
$access_liste_id = array_unique($access_liste_id);
} else {
$access_liste_id[] = 0;
}
return $access_liste_id;
}
protected function _get_query() {
$query = $this->_get_query_base();
if(!$this->filters['proprio_bannette']) {
$query .= " join bannette_abon on num_bannette=id_bannette ";
}
$query .= $this->_get_query_filters();
if(!$this->filters['proprio_bannette']) {
$query .= " union ".$this->_get_query_base()." where ((id_bannette IN (".implode(',',$this->get_access_liste_id()).")) or (bannette_opac_accueil = 1)) and proprio_bannette=0 ";
}
$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 get_title() {
global $msg;
$title = "";
if($this->filters['proprio_bannette']) {
$title .= $msg['dsi_bannette_gerer_priv'];
} else {
$title .= $msg['dsi_bannette_gerer_pub'];
}
$title .= "
\n";
return $title;
}
protected function get_form_title() {
return '';
}
protected function add_event_on_selection_action($action=array()) {
global $msg;
if(empty($this->filters['proprio_bannette']) && $action['name'] == 'save') {
$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);
});
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 {
$display = parent::add_event_on_selection_action($action);
}
return $display;
}
protected function get_selection_actions() {
global $msg;
if(!isset($this->selection_actions)) {
if($this->filters['proprio_bannette']) {
$delete_link = array(
'onClick' => "delete_bannette_abon"
);
$this->selection_actions = array(
$this->get_selection_action('delete', $msg['63'], 'cross.png', $delete_link)
);
} else {
$save_link = array(
'onClick' => "save_bannette_abon"
);
$this->selection_actions = array(
$this->get_selection_action('save', $msg['77'], 'sauv.gif', $save_link)
);
}
}
return $this->selection_actions;
}
protected function init_default_columns() {
$this->add_column('subscribed', 'dsi_bannette_gerer_abonn');
$this->add_column('name', 'dsi_bannette_gerer_nom_liste');
$this->add_column('aff_date_last_envoi', 'dsi_bannette_gerer_date');
$this->add_column('nb_notices', 'dsi_bannette_gerer_nb_notices');
$this->add_column('periodicite', 'dsi_bannette_gerer_periodicite');
}
protected function init_default_settings() {
parent::init_default_settings();
$this->set_setting_display('search_form', 'visible', false);
$this->set_setting_display('query', 'human', false);
$this->set_setting_column('name', 'align', 'left');
}
protected function init_default_pager() {
parent::init_default_pager();
$this->pager['nb_per_page'] = pmb_mysql_result(pmb_mysql_query("SELECT count(*) FROM bannettes"), 0, 0); //Illimité;
$this->set_pager_in_session();
}
/**
* Construction dynamique des cellules du header
* @param string $name
*/
protected function _get_cell_header($name, $label = '') {
global $msg, $charset;
switch ($name) {
case 'name':
return "".$this->_get_label_cell_header($label)." | ";
case 'subscribed':
return "
| ";
default:
return "".$this->_get_label_cell_header($label)." | ";
}
}
protected function get_link_to_bannette($id_bannette, $proprio_bannette) {
if($proprio_bannette) {
return "./dsi.php?categ=bannettes&sub=abo&id_bannette=".$id_bannette."&suite=modif&id_empr=".$proprio_bannette;
} else {
return "./dsi.php?categ=bannettes&sub=pro&id_bannette=".$id_bannette."&suite=acces";
}
}
protected function get_cell_content($object, $property) {
global $charset;
$content = '';
switch($property) {
case 'subscribed':
$content .= "filters['proprio_bannette'] && $object->is_subscribed(static::$id_empr) ? "checked='checked'" : ""). " />";
break;
case 'name':
// Construction de l'affichage de l'info bulle de la requette
$java_comment = '';
$zoom_comment = '';
$requete = "select * from bannette_equation, equations where num_equation = id_equation and num_bannette = ".$object->id_bannette;
$resultat = pmb_mysql_query($requete);
if (($r = pmb_mysql_fetch_object($resultat))) {
$recherche = $r->requete;
$equ = new equation ($r->num_equation);
if (!isset($this->search) || !is_object($this->search)) $this->search = new search();
$this->search->unserialize_search($equ->requete);
$recherche = $this->search->make_human_query();
$zoom_comment = "";
$java_comment = " onmouseover=\"z=document.getElementById('zoom_comment" . $object->id_bannette . "'); z.style.display=''; \" onmouseout=\"z=document.getElementById('zoom_comment" . $object->id_bannette . "'); z.style.display='none'; \"";
}
$content .= "id_bannette, $this->get_link_to_bannette($object->id_bannette, $object->proprio_bannette)) . "\" $java_comment >";
if($object->comment_public) {
$content .= htmlentities($object->comment_public, ENT_QUOTES, $charset);
} else {
$content .= htmlentities($object->nom_bannette, ENT_QUOTES, $charset);
}
$content .= "";
$content .= $zoom_comment;
if (in_array($this->get_empr_categ(), $object->categorie_lecteurs)) {
$content.= " / ".$this->get_empr_cat_l();
}
$bannette_abon = new bannette_abon($object->id_bannette, static::$id_empr);
foreach($bannette_abon->get_groups() as $groupe_id=>$group_label) {
if (in_array($groupe_id, $object->groupe_lecteurs)) {
$content.= " / ".$group_label;
}
}
break;
default :
$content .= parent::get_cell_content($object, $property);
break;
}
return $content;
}
protected function get_display_cell($object, $property) {
$content = $this->get_cell_content($object, $property);
$display = $this->get_display_format_cell($content, $property);
return $display;
}
public static function set_id_empr($id_empr) {
static::$id_empr = $id_empr+0;
}
public static function set_empr_cb($empr_cb) {
static::$empr_cb = $empr_cb;
}
public static function get_controller_url_base() {
global $base_path, $categ, $form_cb;
return $base_path.'/circ.php?categ='.$categ.'&form_cb='.$form_cb;
}
}