filters['bulletin_id']) { $query .= "JOIN collstate_bulletins ON collstate_bulletins_num_collstate = collstate_id "; } $query .= "LEFT JOIN docs_location ON location_id=idlocation "; if ($pmb_sur_location_activate) { $query .= "LEFT JOIN sur_location on docs_location.surloc_num=sur_location.surloc_id "; } $query .= " LEFT JOIN arch_emplacement ON collstate_emplacement=archempla_id "; return $query; } protected function get_object_instance($row) { return new collstate($row->collstate_id); } /** * Initialisation des filtres de recherche */ public function init_filters($filters=array()) { $this->filters = array( 'location' => 0, 'serial_id' => 0, 'bulletin_id' => 0 ); parent::init_filters($filters); } /** * Initialisation des colonnes disponibles */ protected function init_available_columns() { global $pmb_sur_location_activate; global $pmb_collstate_advanced; $this->available_columns = array('main_fields' => array( 'location' => 'collstate_form_localisation', 'emplacement' => 'collstate_form_emplacement', 'cote' => 'collstate_form_cote', 'support' => 'collstate_form_support', 'statut' => 'collstate_form_statut', 'origine' => 'collstate_form_origine', 'collections' => 'collstate_form_collections', 'archive' => 'collstate_form_archive', 'lacune' => 'collstate_form_lacune' ) ); if ($pmb_sur_location_activate) { $this->available_columns['main_fields']['surloc'] = 'collstate_surloc'; } if($pmb_collstate_advanced) { $this->available_columns['main_fields']['linked_bulletins'] = 'collstate_linked_bulletins_list'; } $this->available_columns['custom_fields'] = array(); $this->add_custom_fields_available_columns('collstate', 'id'); } protected function init_default_columns() { global $msg; global $pmb_collstate_data; global $pmb_sur_location_activate; global $pmb_etat_collections_localise; global $pmb_collstate_advanced; if($pmb_collstate_data) { if (strstr($pmb_collstate_data, "#")) { $cp=new parametres_perso("collstate"); } $colonnesarray=explode(",",$pmb_collstate_data); for ($i=0; $ino_special_fields) { $this->add_column($cp->t_fields[substr($colonnesarray[$i],1)]['NAME'], $cp->t_fields[$id]["TITRE"]); // $collstate_list_header_deb.="".htmlentities($cp->t_fields[$id]["TITRE"],ENT_QUOTES, $charset).""; } }else{ eval ("\$colencours=\$msg['collstate_header_".$colonnesarray[$i]."'];"); $this->add_column($colonnesarray[$i], $colencours); // $collstate_list_header_deb.="".htmlentities($colencours,ENT_QUOTES, $charset).""; } } } else { if ($pmb_sur_location_activate) { $this->add_column('surloc'); } if($pmb_etat_collections_localise && $this->filters['location']==0) { $this->add_column('location'); } $this->add_column('emplacement'); $this->add_column('cote'); $this->add_column('support'); $this->add_column('statut'); $this->add_column('origine'); $this->add_column('collections'); $this->add_column('archive'); $this->add_column('lacune'); } if($pmb_collstate_advanced) { $this->add_column('linked_bulletins'); } } protected function init_default_settings() { parent::init_default_settings(); $this->set_setting_display('search_form', 'export_icons', false); } protected function init_default_applied_sort() { global $pmb_sur_location_activate, $pmb_etat_collections_localise; if ($pmb_sur_location_activate) { $this->add_applied_sort('surloc'); } if($pmb_etat_collections_localise) { $this->add_applied_sort('location'); } $this->add_applied_sort('emplacement'); } /** * Tri SQL */ protected function _get_query_order() { global $pmb_sur_location_activate; global $pmb_etat_collections_localise; if(!empty($this->applied_sort[0]['by'])) { $order = ''; $sort_by = $this->applied_sort[0]['by']; switch($sort_by) { case 'statut' : case 'cote' : case 'origine' : case 'archive' : case 'lacune' : $order = 'collstate_' . $sort_by; break; default : $order .= parent::_get_query_order(); break; } if($order) { return $this->_get_query_order_sql_build($order); } else { //Tri SQL par défaut $this->applied_sort_type = 'SQL'; $query = " ORDER BY "; if ($pmb_sur_location_activate) { $query .= "surloc_libelle, "; } if($pmb_etat_collections_localise) { $query .= "location_libelle, "; } $query .= "archempla_libelle, collstate_cote "; return $query; } } } /** * Initialisation de la pagination par défaut */ protected function init_default_pager() { global $nb_per_page_a_search; parent::init_default_pager(); $this->pager['nb_per_page'] = $nb_per_page_a_search; } protected function get_form_title() { return ''; } /** * Affichage des filtres du formulaire de recherche */ public function get_search_filters_form() { global $list_collstate_ui_search_filters_form_tpl; $search_filters_form = $list_collstate_ui_search_filters_form_tpl; $search_filters_form = str_replace('!!objects_type!!', $this->objects_type, $search_filters_form); return $search_filters_form; } /** * Affichage du formulaire de recherche */ public function get_search_form() { $search_form = parent::get_search_form(); $search_form = str_replace('!!action!!', static::get_controller_url_base()."&sub=view&serial_id=".$this->filters['serial_id']."&view=collstate", $search_form); return $search_form; } /** * Filtres provenant du formulaire */ public function set_filters_from_form() { $location = $this->objects_type.'_location'; global ${$location}; if(isset(${$location}) && ${$location} != '') { $this->filters['location'] = ${$location}; } parent::set_filters_from_form(); } /** * Filtre SQL */ protected function _get_query_filters() { global $pmb_droits_explr_localises; global $explr_invisible; $filter_query = ''; $this->set_filters_from_form(); $filters = array(); if (($pmb_droits_explr_localises)&&($explr_invisible)) { $filters[] = "location_id not in (".$explr_invisible.")"; } if($this->filters['location']) { $filters[] = 'location_id = "'.$this->filters['location'].'"'; } if($this->filters['bulletin_id']) { $filters[] = "collstate_bulletins_num_bulletin='".$this->filters['bulletin_id']."'"; } else { $filters[] = "id_serial='".$this->filters['serial_id']."'"; } if(count($filters)) { $filter_query .= ' where '.implode(' and ', $filters); } return $filter_query; } /** * 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!!', 'collections_state', $display); $display = str_replace('!!sub!!', '', $display); $display = str_replace('!!action!!', 'list', $display); return $display; } protected function get_cell_content($object, $property) { global $msg; $content = ''; switch($property) { case 'surloc': case 'location': case 'emplacement': $content .= $object->{$property."_libelle"}; break; case 'support': $content .= $object->type_libelle; break; case 'statut': $content .= "

".$object->statut_gestion_libelle; break; case 'collections': $content .= $object->state_collections; break; case 'linked_bulletins': $content .= "id."&serial_id=".$this->filters['serial_id']."&bulletin_id=".$this->filters['bulletin_id']."'\">"; break; default : $content .= parent::get_cell_content($object, $property); break; } return $content; } protected function get_display_cell($object, $property) { $attributes = array( 'class' => $property ); if($object->explr_acces_autorise=="MODIF" && $property != 'linked_bulletins') { $attributes['onclick'] = "window.location=\"".static::get_controller_url_base()."&sub=collstate_form&id=".$object->id."&serial_id=".$this->filters['serial_id']."&bulletin_id=".$this->filters['bulletin_id']."\""; } $content = $this->get_cell_content($object, $property); $display = $this->get_display_format_cell($content, $property, $attributes); return $display; } /** * Affiche la recherche + la liste */ public function get_display_list() { global $msg, $charset; global $base_path; // Affichage du formulaire de recherche // Conservé dans le DOM pour le tri Ajax $display = ""; $display .= $this->get_display_search_form(); //Récupération du script JS de tris $display .= $this->get_js_sort_script_sort(); $display .= ""; return $display; } protected function get_display_no_results() { global $msg; return $msg["collstate_no_collstate"]; } public function get_collstate_pagination() { return $this->pager(); } public static function get_controller_url_base() { global $base_path; return $base_path.'/catalog.php?categ=serials'; } }