set_setting_display('search_form', 'visible', false);
$this->set_setting_display('search_form', 'export_icons', false);
$this->set_setting_display('query', 'human', false);
$this->set_setting_column('default', 'align', 'left');
}
protected function init_no_sortable_columns() {
parent::init_no_sortable_columns();
$this->no_sortable_columns[] = 'delmember';
}
protected function add_column_delmember() {
$this->columns[] = array(
'property' => 'delmember',
'label' => "",
'html' => "
filters['group']."&memberID=!!id!!\">
![](".get_url_icon( "\\"${msg[928]}\\"")
",
'exportable' => false
);
}
/**
* Affichage d'une colonne
* @param object $object
* @param string $property
*/
protected function get_display_cell($object, $property) {
switch ($property) {
case 'aff_date_prolong':
$attributes = array();
break;
default:
$attributes = array(
'onclick' => "document.location=\"".$this->get_edition_link($object)."\";"
);
break;
}
$content = $this->get_cell_content($object, $property);
$display = $this->get_display_format_cell($content, $property, $attributes);
return $display;
}
protected function get_cell_content($object, $property) {
global $empr_prolong_calc_date_adhes_depassee;
$content = '';
switch($property) {
case 'empr_name':
$content .= "";
$content .= $object->nom;
if($object->prenom) {
$content .= ", ".$object->prenom;
}
$content .= "";
break;
case 'aff_date_prolong':
if ($object->adhesion_renouv_proche() || $object->adhesion_depassee()) {
$rqt="select duree_adhesion from empr_categ where id_categ_empr='".$object->categ."'";
$res_dur_adhesion = pmb_mysql_query($rqt);
$row = pmb_mysql_fetch_row($res_dur_adhesion);
$nb_jour_adhesion_categ = $row[0];
if ($empr_prolong_calc_date_adhes_depassee && $object->adhesion_depassee()) {
$rqt_date = "select date_add(curdate(),INTERVAL 1 DAY) as nouv_date_debut,
date_add(curdate(),INTERVAL $nb_jour_adhesion_categ DAY) as nouv_date_fin ";
} else {
$rqt_date = "select date_add('".$object->date_expiration."',INTERVAL 1 DAY) as nouv_date_debut,
date_add('".$object->date_expiration."',INTERVAL $nb_jour_adhesion_categ DAY) as nouv_date_fin ";
}
$resultatdate=pmb_mysql_query($rqt_date) or die ("
$rqt_date ".pmb_mysql_error());
$resdate=pmb_mysql_fetch_object($resultatdate);
$content .= "";
}
break;
default:
$content .= parent::get_cell_content($object, $property);
break;
}
return $content;
}
protected function init_default_columns() {
global $empr_allow_prolong_members_group;
$this->add_column('empr_name');
$this->add_column('cb');
$this->add_column('nb_loans');
$this->add_column('nb_resas_and_validated');
if ($empr_allow_prolong_members_group) {
$this->add_column('aff_date_adhesion', 'group_empr_date_adhesion');
$this->add_column('aff_date_expiration', 'group_empr_date_expiration');
$this->add_column('aff_date_prolong', 'group_empr_date_prolong');
}
$this->add_column_delmember();
}
protected function get_selection_actions() {
if(!isset($this->selection_actions)) {
$this->selection_actions = array();
}
return $this->selection_actions;
}
protected function get_edition_link($object) {
global $base_path;
return $base_path.'/circ.php?categ=pret&form_cb='.rawurlencode($object->cb)."&groupID=".$this->filters['group'];
}
public static function get_controller_url_base() {
global $base_path;
global $categ, $sub, $groupID;
return $base_path.'/circ.php?categ='.$categ.'&sub='.$sub.'&groupID='.$groupID;
}
/*---------INI 07/11/2022 LLIUREX FIXED BUG WITH PAGER-------*/
protected function init_default_pager(){
parent::init_default_pager();
$this->pager['nb_per_page'] = 10000;
}
/*----------FIN 07/11/2022 LLIUREX--------------------------*/
}