$f_rel_rank = ${$f_rel_rank};
$f_rel_id = ${$f_rel_id};
if ($f_rel_id) {
if ($f_rel_direction == 'up') {
$requete = 'INSERT INTO notices_relations VALUES("' . $id . '","' . $f_rel_id . '","' . $f_rel_type . '","' . $f_rel_rank . '")';
@pmb_mysql_query($requete);
} elseif ($f_rel_direction == 'down') {
$requete = 'INSERT INTO notices_relations VALUES("' . $f_rel_id . '","' . $id . '","' . $f_rel_type . '","' . $f_rel_rank . '")';
@pmb_mysql_query($requete);
}
}
}
// nomenclature
global $pmb_nomenclature_activate;
if ($pmb_nomenclature_activate) {
$nomenclature = new nomenclature_record_ui($id);
$nomenclature->save_form();
}
// traitement des auteurs
$rqt_del = "delete from responsability where responsability_notice='{$id}' ";
$res_del = pmb_mysql_query($rqt_del);
$rqt_ins = "INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES ";
$i = 0;
while ($i <= count($f_aut) - 1) {
$id_aut = $f_aut[$i]['id'];
if ($id_aut) {
$fonc_aut = $f_aut[$i]['fonction'];
$type_aut = $f_aut[$i]['type'];
$ordre_aut = $f_aut[$i]['ordre'];
$rqt = $rqt_ins . " ('{$id_aut}','{$id}','{$fonc_aut}','{$type_aut}', {$ordre_aut}) ";
$res_ins = @pmb_mysql_query($rqt);
function do_isbd()
{
global $dbh, $base_path;
global $langue_doc;
global $msg;
global $tdoc;
global $fonction_auteur;
global $charset;
global $thesaurus_mode_pmb, $thesaurus_categories_categ_in_line, $pmb_keyword_sep, $thesaurus_categories_affichage_ordre;
global $load_tablist_js;
global $lang;
global $categories_memo, $libelle_thesaurus_memo;
global $categories_top, $use_opac_url_base, $opac_url_base, $thesaurus_categories_show_only_last;
global $categ;
global $id_empr;
global $pmb_show_notice_id, $pmb_opac_url, $pmb_show_permalink;
global $sort_children;
global $pmb_resa_planning;
global $thesaurus_concepts_active;
global $pmb_map_activate;
global $pmb_nomenclature_activate;
// constitution de la mention de titre
if ($this->tit_serie) {
if ($this->print_mode) {
$this->isbd = $this->tit_serie;
} else {
$this->isbd = $this->tit_serie_lien_gestion;
}
if ($this->notice->tnvol) {
$this->isbd .= ', ' . $this->notice->tnvol;
}
}
$this->isbd ? $this->isbd .= '. ' . $this->notice->tit1 : ($this->isbd = $this->notice->tit1);
$tit2 = $this->notice->tit2;
$tit3 = $this->notice->tit3;
$tit4 = $this->notice->tit4;
if ($tit3) {
$this->isbd .= " = {$tit3}";
}
if ($tit4) {
$this->isbd .= " : {$tit4}";
}
if ($tit2) {
$this->isbd .= " ; {$tit2}";
}
$this->isbd .= ' [' . $tdoc->table[$this->notice->typdoc] . ']';
$mention_resp = array();
// constitution de la mention de responsabilité
//$this->responsabilites
$as = array_search("0", $this->responsabilites["responsabilites"]);
if ($as !== FALSE && $as !== NULL) {
$auteur_0 = $this->responsabilites["auteurs"][$as];
$auteur = new auteur($auteur_0["id"]);
if ($this->print_mode) {
$mention_resp_lib = $auteur->isbd_entry;
} else {
$mention_resp_lib = $auteur->isbd_entry_lien_gestion;
}
if (!$this->print_mode) {
$mention_resp_lib .= $auteur->author_web_link;
}
if ($auteur_0["fonction"]) {
$mention_resp_lib .= ", " . $fonction_auteur[$auteur_0["fonction"]];
}
$mention_resp[] = $mention_resp_lib;
}
$as = array_keys($this->responsabilites["responsabilites"], "1");
for ($i = 0; $i < count($as); $i++) {
$indice = $as[$i];
$auteur_1 = $this->responsabilites["auteurs"][$indice];
$auteur = new auteur($auteur_1["id"]);
if ($this->print_mode) {
$mention_resp_lib = $auteur->isbd_entry;
} else {
$mention_resp_lib = $auteur->isbd_entry_lien_gestion;
}
if (!$this->print_mode) {
$mention_resp_lib .= $auteur->author_web_link;
}
if ($auteur_1["fonction"]) {
$mention_resp_lib .= ", " . $fonction_auteur[$auteur_1["fonction"]];
}
$mention_resp[] = $mention_resp_lib;
}
$as = array_keys($this->responsabilites["responsabilites"], "2");
for ($i = 0; $i < count($as); $i++) {
$indice = $as[$i];
$auteur_2 = $this->responsabilites["auteurs"][$indice];
$auteur = new auteur($auteur_2["id"]);
if ($this->print_mode) {
$mention_resp_lib = $auteur->isbd_entry;
} else {
$mention_resp_lib = $auteur->isbd_entry_lien_gestion;
}
if (!$this->print_mode) {
$mention_resp_lib .= $auteur->author_web_link;
}
if ($auteur_2["fonction"]) {
$mention_resp_lib .= ", " . $fonction_auteur[$auteur_2["fonction"]];
}
$mention_resp[] = $mention_resp_lib;
}
$libelle_mention_resp = implode("; ", $mention_resp);
if ($libelle_mention_resp) {
$this->isbd .= " / {$libelle_mention_resp}";
}
// mention d'édition
if ($this->notice->mention_edition) {
$this->isbd .= ". - " . $this->notice->mention_edition;
}
if ($pmb_map_activate) {
if ($mapisbd = $this->map_info->get_isbd()) {
$this->isbd .= $mapisbd;
}
}
// zone de l'adresse
// on récupère la collection au passage, si besoin est
if ($this->notice->subcoll_id) {
$collection = new subcollection($this->notice->subcoll_id);
$ed_obj = new editeur($collection->editeur);
if ($this->print_mode) {
$editeurs .= $ed_obj->isbd_entry;
$collections = $collection->isbd_entry;
} else {
$editeurs .= $ed_obj->isbd_entry_lien_gestion;
$collections = $collection->isbd_entry_lien_gestion;
}
} elseif ($this->notice->coll_id) {
$collection = new collection($this->notice->coll_id);
$ed_obj = new editeur($collection->parent);
if ($this->print_mode) {
$editeurs .= $ed_obj->isbd_entry;
$collections = $collection->isbd_entry;
} else {
$editeurs .= $ed_obj->isbd_entry_lien_gestion;
$collections = $collection->isbd_entry_lien_gestion;
}
} elseif ($this->notice->ed1_id) {
$editeur = new editeur($this->notice->ed1_id);
if ($this->print_mode) {
$editeurs .= $editeur->isbd_entry;
} else {
$editeurs .= $editeur->isbd_entry_lien_gestion;
}
}
if ($this->notice->ed2_id) {
$editeur = new editeur($this->notice->ed2_id);
if ($this->print_mode) {
$ed_isbd = $editeur->isbd_entry;
} else {
$ed_isbd = $editeur->isbd_entry_lien_gestion;
}
$editeurs ? $editeurs .= ' ; ' . $ed_isbd : ($editeurs = $ed_isbd);
}
if ($this->notice->year) {
$editeurs ? $editeurs .= ', ' . $this->notice->year : ($editeurs = $this->notice->year);
} elseif ($this->notice->niveau_biblio != 'b') {
$editeurs ? $editeurs .= ', [s.d.]' : ($editeurs = "[s.d.]");
}
if ($editeurs) {
$this->isbd .= ". - {$editeurs}";
}
// zone de la collation (ne concerne que a2)
if ($this->notice->npages) {
$collation = $this->notice->npages;
}
if ($this->notice->ill) {
$collation .= ': ' . $this->notice->ill;
}
if ($this->notice->size) {
$collation .= '; ' . $this->notice->size;
}
if ($this->notice->accomp) {
$collation .= '+ ' . $this->notice->accomp;
}
if ($collation) {
$this->isbd .= ". - {$collation}";
}
if ($collections) {
if ($this->notice->nocoll) {
$collections .= '; ' . $this->notice->nocoll;
}
$this->isbd .= ". - ({$collections})" . ' ';
}
if (substr(trim($this->isbd), -1) != ".") {
$this->isbd .= '.';
}
// note générale
if ($this->notice->n_gen) {
$zoneNote = nl2br(htmlentities($this->notice->n_gen, ENT_QUOTES, $charset)) . ' ';
}
// ISBN ou NO. commercial
if ($this->notice->code) {
if (isISBN($this->notice->code)) {
if ($zoneNote) {
$zoneNote .= '. - ISBN ';
} else {
$zoneNote = 'ISBN ';
}
} else {
if ($zoneNote) {
$zoneNote .= '. - ';
}
}
$zoneNote .= $this->notice->code;
}
if ($this->notice->prix) {
if ($this->notice->code) {
$zoneNote .= ' : ' . $this->notice->prix;
} else {
if ($zoneNote) {
$zoneNote .= ' ' . $this->notice->prix;
} else {
$zoneNote = $this->notice->prix;
}
}
}
if ($zoneNote) {
$this->isbd .= "<br /><br />{$zoneNote}.";
}
//In
//Recherche des notices parentes
if (!$this->no_link) {
$requete = "select linked_notice, relation_type, rank, l.niveau_biblio as lnb, l.niveau_hierar as lnh from notices_relations, notices as l where num_notice=" . $this->notice_id . " and linked_notice=l.notice_id order by relation_type,rank";
$result_linked = pmb_mysql_query($requete) or die(pmb_mysql_error());
//Si il y en a, on prépare l'affichage
if (pmb_mysql_num_rows($result_linked)) {
global $relation_listup;
if (!$relation_listup) {
$relation_listup = new marc_list("relationtypeup");
}
}
$r_type = array();
$ul_opened = false;
$r_type_local = "";
//Pour toutes les notices liées
while ($r_rel = pmb_mysql_fetch_object($result_linked)) {
//Pour avoir le lien par défaut
if (!$this->print_mode && SESSrights & CATALOGAGE_AUTH) {
$link_parent = $base_path . '/catalog.php?categ=isbd&id=!!id!!';
} else {
$link_parent = "";
}
if ($r_rel->lnb == 's' && $r_rel->lnh == '1') {
// c'est une notice chapeau
global $link_serial, $link_analysis, $link_bulletin, $link_explnum_serial;
$link_serial_sub = $base_path . "/catalog.php?categ=serials&sub=view&serial_id=" . $r_rel->linked_notice;
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($r_rel->linked_notice, 0, $link_serial_sub, $link_analysis, $link_bulletin, "", "", 0, $this->print_mode, $this->show_explnum, $this->show_statut, $this->show_opac_hidden_fields, 1, true);
$aff = $serial->header;
} else {
if ($r_rel->lnb == 'a' && $r_rel->lnh == '2') {
// c'est un dépouillement de bulletin
global $link_serial, $link_analysis, $link_bulletin, $link_explnum_serial;
if (!$link_analysis) {
$link_analysis = $base_path . "/catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=!!bul_id!!&art_to_show=!!id!!";
}
$serial = new serial_display($r_rel->linked_notice, 0, $link_serial, $link_analysis, $link_bulletin, "", "", 0, $this->print_mode, $this->show_explnum, $this->show_statut, $this->show_opac_hidden_fields, 1, true);
$aff = $serial->result;
} else {
if ($link_parent && $r_rel->lnb == 'b' && $r_rel->lnh == '2') {
$requete = "SELECT bulletin_id FROM bulletins WHERE num_notice='" . $r_rel->linked_notice . "'";
$res = pmb_mysql_query($requete);
if (pmb_mysql_num_rows($res)) {
$link_parent = $base_path . "/catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=" . pmb_mysql_result($res, 0, 0);
}
}
// dans les autres cas
$parent_notice = new mono_display($r_rel->linked_notice, 0, $link_parent, 1, '', "", '', 0, $this->print_mode, $this->show_explnum, $this->show_statut, '', 1, true, $this->show_opac_hidden_fields, 0);
$aff = $parent_notice->header;
$this->nb_expl += $parent_notice->nb_expl;
}
}
//$parent_notice=new mono_display($r_rel->linked_notice,0,$link_parent);
//Présentation différente si il y en a un ou plusieurs
if (pmb_mysql_num_rows($result_linked) == 1) {
$this->isbd .= "<br /><b>" . $relation_listup->table[$r_rel->relation_type] . "</b> " . $aff . "<br />";
} else {
if ($r_rel->relation_type != $r_type_local) {
$r_type_local = $r_rel->relation_type;
if ($ul_opened) {
$this->isbd .= "</ul>";
$this->isbd .= "\n<b>" . $relation_listup->table[$r_rel->relation_type] . "</b>";
$this->isbd .= "\n<ul class='notice_rel'>\n";
$ul_opened = true;
} else {
$this->isbd .= "\n<br />";
$this->isbd .= "\n<b>" . $relation_listup->table[$r_rel->relation_type] . "</b>";
$this->isbd .= "\n<ul class='notice_rel'>\n";
$ul_opened = true;
}
}
$this->isbd .= "\n<li>" . $aff . "</li>\n";
}
}
if ($ul_opened) {
$this->isbd .= "\n</ul>\n";
}
}
if ($pmb_show_notice_id || $pmb_show_permalink) {
$this->isbd .= "<br />";
}
if ($pmb_show_notice_id) {
$prefixe = explode(",", $pmb_show_notice_id);
$this->isbd .= "<b>" . $msg['notice_id_libelle'] . " </b>" . ($prefixe[1] ? $prefixe[1] : '') . $this->notice_id . "<br />";
}
// Permalink OPAC
if ($pmb_show_permalink) {
$this->isbd .= "<b>" . $msg["notice_permalink_opac"] . " </b><a href='" . $pmb_opac_url . "index.php?lvl=notice_display&id=" . $this->notice_id . "' target=\"__LINK__\">" . $pmb_opac_url . "index.php?lvl=notice_display&id=" . $this->notice_id . "</a><br />";
}
// niveau 1
if ($this->level == 1) {
if (!$this->print_mode) {
$this->isbd .= "<!-- !!bouton_modif!! -->";
}
if ($this->expl) {
$this->isbd .= "<br /><b>{$msg[285]}</b> (" . $this->nb_expl . ")";
$this->isbd .= $this->show_expl_per_notice($this->notice->notice_id, $this->link_expl);
}
if ($this->show_explnum) {
$explnum_assoc = show_explnum_per_notice($this->notice->notice_id, 0, $this->link_explnum);
if ($explnum_assoc) {
$this->isbd .= "<b>{$msg['explnum_docs_associes']}</b>" . $explnum_assoc;
}
}
if ($this->show_resa) {
$aff_resa = resa_list($this->notice_id, 0, 0);
if ($aff_resa) {
$this->isbd .= "<b>{$msg['resas']}</b>" . $aff_resa;
}
}
if ($this->show_planning && $pmb_resa_planning) {
$aff_resa_planning = planning_list($this->notice_id, 0, 0);
if ($aff_resa_planning) {
$this->isbd .= "<b>{$msg['resas_planning']}</b>" . $aff_resa_planning;
}
}
$this->simple_isbd = $this->isbd;
$this->do_image($this->isbd);
return;
}
// map
if ($pmb_map_activate && $this->show_map) {
$this->isbd .= $this->map->get_map();
}
if ($pmb_nomenclature_activate) {
$nomenclature = new nomenclature_record_ui($this->notice_id);
$this->isbd .= $nomenclature->get_isbd();
}
// résumé
if ($this->notice->n_resume) {
// $this->isbd .= "<br /><b>${msg[267]}</b> : ".nl2br(htmlentities($this->notice->n_resume,ENT_QUOTES, $charset));
$this->isbd .= "<br /><b>{$msg[267]}</b> : " . nl2br($this->notice->n_resume);
}
// note de contenu
if ($this->notice->n_contenu) {
// $this->isbd .= "<br /><b>${msg[266]}</b> : ".nl2br(htmlentities($this->notice->n_contenu,ENT_QUOTES, $charset));
$this->isbd .= "<br /><b>{$msg[266]}</b> : " . nl2br($this->notice->n_contenu);
}
// catégories
$categ_repetables = array();
if (!count($categories_top)) {
$q = "select num_thesaurus,id_noeud from noeuds where num_parent in(select id_noeud from noeuds where autorite='TOP') ";
$r = pmb_mysql_query($q, $dbh);
while ($res = pmb_mysql_fetch_object($r)) {
$categories_top[] = $res->id_noeud;
}
}
$requete = "select * from (\n\t\tselect libelle_thesaurus, if (catlg.num_noeud is null, catdef.libelle_categorie, catlg.libelle_categorie ) as categ_libelle, noeuds.id_noeud , noeuds.num_parent, langue_defaut,id_thesaurus, if(catdef.langue = '" . $lang . "',2, if(catdef.langue= thesaurus.langue_defaut ,1,0)) as p, ordre_vedette, ordre_categorie\n\t\tFROM ((noeuds\n\t\tjoin thesaurus ON thesaurus.id_thesaurus = noeuds.num_thesaurus\n\t\tleft join categories as catdef on noeuds.id_noeud=catdef.num_noeud and catdef.langue = thesaurus.langue_defaut\n\t\tleft join categories as catlg on catdef.num_noeud = catlg.num_noeud and catlg.langue = '" . $lang . "'))\n\t\t,notices_categories\n\t\twhere notices_categories.num_noeud=noeuds.id_noeud and\n\t\tnotices_categories.notcateg_notice=" . $this->notice_id . "\torder by id_thesaurus, noeuds.id_noeud, p desc\n\t\t) as list_categ group by id_noeud";
if ($thesaurus_categories_affichage_ordre == 1) {
$requete .= " order by ordre_vedette, ordre_categorie";
}
$result_categ = @pmb_mysql_query($requete);
if (pmb_mysql_num_rows($result_categ)) {
while ($res_categ = pmb_mysql_fetch_object($result_categ)) {
$libelle_thesaurus = $res_categ->libelle_thesaurus;
$categ_id = $res_categ->id_noeud;
$libelle_categ = $res_categ->categ_libelle;
$num_parent = $res_categ->num_parent;
$langue_defaut = $res_categ->langue_defaut;
$categ_head = 0;
if (in_array($categ_id, $categories_top)) {
$categ_head = 1;
}
if ($thesaurus_categories_show_only_last || $categ_head) {
if ($use_opac_url_base) {
$url_base_lien_aut = $opac_url_base . "index.php?&lvl=categ_see&id=";
} else {
$url_base_lien_aut = $base_path . "/autorites.php?categ=categories&sub=categ_form&id=";
}
if ((SESSrights & AUTORITES_AUTH || $use_opac_url_base) && !$this->print_mode) {
$libelle_aff_complet = "<a href='" . $url_base_lien_aut . $categ_id . "' class='lien_gestion'>" . $libelle_categ . "</a>";
} else {
$libelle_aff_complet = $libelle_categ;
}
if ($thesaurus_mode_pmb) {
$categ_repetables[$libelle_thesaurus][] = $libelle_aff_complet;
} else {
$categ_repetables['MONOTHESAURUS'][] = $libelle_aff_complet;
}
} else {
if (!$categories_memo[$categ_id]) {
$anti_recurse[$categ_id] = 1;
$path_table = '';
$requete = "select id_noeud as categ_id, num_noeud, num_parent as categ_parent, libelle_categorie as categ_libelle, num_renvoi_voir as categ_see, note_application as categ_comment, if(langue = '" . $lang . "',2, if(langue= '" . $langue_defaut . "' ,1,0)) as p\n\t\t\t\t\t\tFROM noeuds, categories where id_noeud ='" . $num_parent . "'\n\t\t\t\t\t\tAND noeuds.id_noeud = categories.num_noeud\n\t\t\t\t\t\torder by p desc limit 1";
$result = @pmb_mysql_query($requete);
if (pmb_mysql_num_rows($result)) {
$parent = pmb_mysql_fetch_object($result);
$anti_recurse[$parent->categ_id] = 1;
$path_table[] = array('id' => $parent->categ_id, 'libelle' => $parent->categ_libelle);
// on remonte les ascendants
while ($parent->categ_parent && !$anti_recurse[$parent->categ_parent]) {
$requete = "select id_noeud as categ_id, num_noeud, num_parent as categ_parent, libelle_categorie as categ_libelle,\tnum_renvoi_voir as categ_see, note_application as categ_comment, if(langue = '" . $lang . "',2, if(langue= '" . $langue_defaut . "' ,1,0)) as p\n\t\t\t\t\t\t\t\tFROM noeuds, categories where id_noeud ='" . $parent->categ_parent . "'\n\t\t\t\t\t\t\t\tAND noeuds.id_noeud = categories.num_noeud\n\t\t\t\t\t\t\t\torder by p desc limit 1";
$result = @pmb_mysql_query($requete);
if (pmb_mysql_num_rows($result)) {
$parent = pmb_mysql_fetch_object($result);
$anti_recurse[$parent->categ_id] = 1;
$path_table[] = array('id' => $parent->categ_id, 'libelle' => $parent->categ_libelle);
} else {
break;
}
}
$anti_recurse = array();
} else {
$path_table = array();
}
// ceci remet le tableau dans l'ordre général->particulier
$path_table = array_reverse($path_table);
if (sizeof($path_table)) {
$temp_table = '';
while (list($xi, $l) = each($path_table)) {
$temp_table[] = $l['libelle'];
}
$parent_libelle = join(':', $temp_table);
$catalog_form = $parent_libelle . ':' . $libelle_categ;
} else {
$catalog_form = $libelle_categ;
}
if ($use_opac_url_base) {
$url_base_lien_aut = $opac_url_base . "index.php?&lvl=categ_see&id=";
} else {
$url_base_lien_aut = $base_path . "/autorites.php?categ=categories&sub=categ_form&id=";
}
if ((SESSrights & AUTORITES_AUTH || $use_opac_url_base) && !$this->print_mode) {
$libelle_aff_complet = "<a href='" . $url_base_lien_aut . $categ_id . "' class='lien_gestion'>" . $catalog_form . "</a>";
} else {
$libelle_aff_complet = $catalog_form;
}
if ($thesaurus_mode_pmb) {
$categ_repetables[$libelle_thesaurus][] = $libelle_aff_complet;
} else {
$categ_repetables['MONOTHESAURUS'][] = $libelle_aff_complet;
}
$categories_memo[$categ_id] = $libelle_aff_complet;
$libelle_thesaurus_memo[$categ_id] = $libelle_thesaurus;
} else {
if ($thesaurus_mode_pmb) {
$categ_repetables[$libelle_thesaurus_memo[$categ_id]][] = $categories_memo[$categ_id];
} else {
$categ_repetables['MONOTHESAURUS'][] = $categories_memo[$categ_id];
}
}
}
}
}
while (list($nom_tesaurus, $val_lib) = each($categ_repetables)) {
//c'est un tri par libellé qui est demandé
if ($thesaurus_categories_affichage_ordre == 0) {
$tmp = array();
foreach ($val_lib as $key => $value) {
$tmp[$key] = strip_tags($value);
}
$tmp = array_map("convert_diacrit", $tmp);
//On enlève les accents
$tmp = array_map("strtoupper", $tmp);
//On met en majuscule
asort($tmp);
//Tri sur les valeurs en majuscule sans accent
foreach ($tmp as $key => $value) {
$tmp[$key] = $val_lib[$key];
//On reprend les bons couples clé / libellé
}
$val_lib = $tmp;
}
if ($thesaurus_mode_pmb) {
if (!$thesaurus_categories_categ_in_line) {
$categ_repetables_aff = "[" . $nom_tesaurus . "]" . implode("<br />[" . $nom_tesaurus . "]", $val_lib);
} else {
$categ_repetables_aff = "<b>" . $nom_tesaurus . "</b><br />" . implode(" {$pmb_keyword_sep} ", $val_lib);
}
} else {
if (!$thesaurus_categories_categ_in_line) {
$categ_repetables_aff = implode("<br />", $val_lib);
} else {
$categ_repetables_aff = implode(" {$pmb_keyword_sep} ", $val_lib);
}
}
if ($categ_repetables_aff) {
$tmpcateg_aff .= "<br />{$categ_repetables_aff}";
}
}
if ($tmpcateg_aff) {
$this->isbd .= "<br />{$tmpcateg_aff}";
}
// Concepts
if ($thesaurus_concepts_active == 1) {
$index_concept = new index_concept($this->notice_id, TYPE_NOTICE);
$this->isbd .= $index_concept->get_isbd_display();
}
// langues
if (count($this->langues)) {
$langues = "<b>{$msg[537]}</b> : " . construit_liste_langues($this->langues);
}
if (count($this->languesorg)) {
$langues .= " <b>{$msg[711]}</b> : " . construit_liste_langues($this->languesorg);
}
if ($langues) {
$this->isbd .= "<br />{$langues}";
}
// indexation libre
if ($this->notice->index_l) {
$this->isbd .= "<br /><b>{$msg[324]}</b> : " . nl2br($this->notice->index_l);
}
// indexation interne
if ($this->notice->indexint) {
$indexint = new indexint($this->notice->indexint);
if ($this->print_mode) {
$indexint_isbd = $indexint->display;
} else {
$indexint_isbd = $indexint->isbd_entry_lien_gestion;
}
$this->isbd .= "<br /><b>{$msg[indexint_catal_title]}</b> : " . $indexint_isbd;
}
$tu = new tu_notice($this->notice_id);
if ($tu_liste = $tu->get_print_type(1)) {
$this->isbd .= "<br />" . $tu_liste;
}
$authperso = new authperso_notice($this->notice_id);
$this->isbd .= $authperso->get_notice_display();
//Champs personalisés
$perso_aff = "";
if (!$this->p_perso->no_special_fields) {
$perso_ = $this->p_perso->show_fields($this->notice_id);
for ($i = 0; $i < count($perso_["FIELDS"]); $i++) {
$p = $perso_["FIELDS"][$i];
// ajout de && ($p['OPAC_SHOW']||$this->show_opac_hidden_fields) afin de masquer les champs masqués de l'OPAC en diff de bannette.
if ($p["AFF"] && ($p['OPAC_SHOW'] || $this->show_opac_hidden_fields)) {
$perso_aff .= "<br />" . $p["TITRE"] . " " . nl2br($p["AFF"]);
}
}
}
if ($perso_aff) {
$this->isbd .= $perso_aff;
}
//Notices liées
if (count($this->childs) && !$this->print_mode && !$this->no_link) {
$link = $base_path . '/catalog.php?categ=isbd&id=!!id!!';
$link_expl = $base_path . '/catalog.php?categ=edit_expl&id=!!notice_id!!&cb=!!expl_cb!!&expl_id=!!expl_id!!';
$link_explnum = $base_path . '/catalog.php?categ=edit_explnum&id=!!notice_id!!&explnum_id=!!explnum_id!!';
global $relation_typedown;
if (!$relation_typedown) {
$relation_typedown = new marc_list("relationtypedown");
}
reset($this->childs);
if (!$load_tablist_js) {
$aff_childs = "<script type='text/javascript' src='" . $base_path . "/javascript/tablist.js'></script>\n";
}
$aff_childs .= "<br />";
$load_tablist_js = 1;
$anti_loop = $this->anti_loop;
$anti_loop[] = $this->notice_id;
$n_childs = 0;
while ((list($rel_type, $child_notices) = each($this->childs)) && $n_childs < 100) {
$aff_childs .= "<b>" . $relation_typedown->table[$rel_type] . "</b>";
$aff_childs .= "<blockquote>";
if ($pmb_notice_fille_format) {
$aff_childs .= "<ul class='notice_rel'>";
}
for ($i = 0; $i < count($child_notices); $i++) {
$as = array_search($child_notices[$i], $anti_loop);
if ($as === false) {
global $pmb_notice_fille_format;
if ($pmb_notice_fille_format) {
$level_fille = 0;
} else {
$level_fille = 6;
}
// il faut aller chercher le niveau biblio et niveau hierar de la notice liée
$requete_nbnh = "select l.niveau_biblio as lnb, l.niveau_hierar as lnh, rank from notices as l join notices_relations on num_notice=notice_id where notice_id='" . $child_notices[$i] . "' ";
$r_rel = pmb_mysql_fetch_object(pmb_mysql_query($requete_nbnh));
if ($r_rel->rank != $i) {
$req = "update notices_relations set rank='{$i}' where num_notice='" . $child_notices[$i] . "' and relation_type='" . $rel_type . "' and linked_notice='" . $anti_loop[count($serial->anti_loop) - 1] . "'";
pmb_mysql_query($req, $dbh);
}
if ($r_rel->lnb == 's' && $r_rel->lnh == '1') {
// c'est une notice de pério
global $link_serial, $link_analysis, $link_bulletin, $link_explnum_serial;
$link_serial_sub = $base_path . "/catalog.php?categ=serials&sub=view&serial_id=" . $child_notices[$i];
$serial = new serial_display($child_notices[$i], $level_fille, $link_serial_sub, $link_analysis, $link_bulletin, "", $link_explnum_serial, 0, $this->print_mode, 1, 1, 1, 0, 0, $anti_loop);
if (count($serial->anti_loop) == 1 && $sort_children) {
//Drag pour tri des notices filles
$id_elt = $serial->notice_id . ($serial->anti_loop ? "_p" . implode("_", $serial->anti_loop) : "");
$drag_fille = "<div id=\"drag_" . $id_elt . "\" handler=\"handle_" . $id_elt . "\" dragtype='daughter' draggable='yes' recepttype='daughter' recept='yes'\n\t\t\t\t\t\t\t\t\tdragicon=\"" . $base_path . "/images/icone_drag_notice.png\" dragtext=\"" . htmlentities($serial->tit1, ENT_QUOTES, $charset) . "\" callback_before=\"is_expandable\"\n\t\t\t\t\t\t\t\t\tcallback_after=\"\" downlight=\"noti_downlight\" highlight=\"noti_highlight\" fille='{$child_notices[$i]}' pere='" . $anti_loop[count($serial->anti_loop) - 1] . "' order='{$i}' type_rel=\"{$rel_type}\" >";
$drag_fille .= "<span id=\"handle_" . $id_elt . "\" style=\"float:left; padding-right : 7px\"><img src=\"" . $base_path . "/images/sort.png\" style='width:12px; vertical-align:middle' /></span>";
$affichage_result = $serial->result;
} else {
$drag_fille = "";
$affichage_result = $pmb_notice_fille_format ? "<li>" . $serial->result . "</li>" : $serial->result;
}
$aff = $drag_fille . $affichage_result;
if ($drag_fille) {
$aff .= "</div>";
}
} else {
if ($r_rel->lnb == 'a' && $r_rel->lnh == '2') {
// c'est un dépouillement de bulletin
global $link_serial, $link_analysis, $link_bulletin, $link_explnum_analysis;
$serial = new serial_display($child_notices[$i], $level_fille, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_analysis, 0, 0, 1, 1, 1, 0, 0, $anti_loop);
if (count($serial->anti_loop) == 1 && $sort_children) {
//Drag pour tri des notices filles
$id_elt = $serial->notice_id . ($serial->anti_loop ? "_p" . implode("_", $serial->anti_loop) : "");
$drag_fille = "<div id=\"drag_" . $id_elt . "\" handler=\"handle_" . $id_elt . "\" dragtype='daughter' draggable='yes' recepttype='daughter' recept='yes'\n\t\t\t\t\t\t\t\t\tdragicon=\"" . $base_path . "/images/icone_drag_notice.png\" dragtext=\"" . htmlentities($serial->tit1, ENT_QUOTES, $charset) . "\" callback_before=\"is_expandable\"\n\t\t\t\t\t\t\t\t\tcallback_after=\"\" downlight=\"noti_downlight\" highlight=\"noti_highlight\" fille='{$child_notices[$i]}' pere='" . $anti_loop[count($serial->anti_loop) - 1] . "' order='{$i}' type_rel=\"{$rel_type}\">";
$drag_fille .= "<span id=\"handle_" . $id_elt . "\" style=\"float:left; padding-right : 7px\"><img src=\"" . $base_path . "/images/sort.png\" style='width:12px; vertical-align:middle' /></span>";
$affichage_result = $serial->result;
} else {
$drag_fille = "";
$affichage_result = $pmb_notice_fille_format ? "<li>" . $serial->result . "</li>" : $serial->result;
}
$aff = $drag_fille . $affichage_result;
if ($drag_fille) {
$aff .= "</div>";
}
} else {
$display = new mono_display($child_notices[$i], $level_fille, $link, 1, $link_expl, '', $link_explnum, 1, 0, 1, 1, $anti_loop, $this->drag, false, true, 0, 1, 0);
if (count($display->anti_loop) == 1 && $sort_children) {
//Drag pour tri des notices filles
$id_elt = $display->notice_id . ($display->anti_loop ? "_p" . implode("_", $display->anti_loop) : "");
$drag_fille = "<div id=\"drag_" . $id_elt . "\" handler=\"handle_" . $id_elt . "\" dragtype='daughter' draggable='yes' recepttype='daughter' recept='yes'\n\t\t\t\t\t\t\t\t\tdragicon=\"" . $base_path . "/images/icone_drag_notice.png\" dragtext=\"" . htmlentities($display->tit1, ENT_QUOTES, $charset) . "\" callback_before=\"is_expandable\"\n\t\t\t\t\t\t\t\t\tcallback_after=\"\" downlight=\"noti_downlight\" highlight=\"noti_highlight\" fille='{$child_notices[$i]}' pere='" . $anti_loop[count($display->anti_loop) - 1] . "' order='{$i}' type_rel=\"{$rel_type}\">";
$drag_fille .= "<span id=\"handle_" . $id_elt . "\" style=\"float:left; padding-right : 7px\"><img src=\"" . $base_path . "/images/sort.png\" style='width:12px; vertical-align:middle' /></span>";
$affichage_result = $display->result;
} else {
$drag_fille = "";
$affichage_result = $pmb_notice_fille_format ? "<li>" . $display->result . "</li>" : $display->result;
}
$display->result = str_replace("<!-- !!bouton_modif!! -->", " ", $display->result);
$aff = $drag_fille . $affichage_result;
$this->nb_expl += $display->nb_expl;
if ($drag_fille) {
$aff .= "</div>";
}
}
}
$aff_childs .= $aff;
}
$n_childs++;
}
$aff_childs .= ($pmb_notice_fille_format ? "</ul>" : "") . "</blockquote>";
}
$this->isbd .= $aff_childs;
}
if (!$this->print_mode && !$this->anti_loop) {
$this->isbd .= "<!-- !!bouton_modif!! -->";
}
$this->do_image($this->isbd);
if (!$this->anti_loop) {
$this->isbd .= "<!-- !!avis_notice!! -->";
}
if ($this->expl) {
if ($this->notice->niveau_biblio == 'b' && $this->notice->niveau_hierar == 2) {
// on est face à une notice de bulletin
$requete = "select bulletin_id from bulletins where num_notice=" . $this->notice->notice_id;
$result = @pmb_mysql_query($requete);
if (pmb_mysql_num_rows($result)) {
$bull = pmb_mysql_fetch_object($result);
$expl_aff = $this->show_expl_per_notice($this->notice->notice_id, $this->link_expl, $bull->bulletin_id);
}
} else {
$expl_aff = $this->show_expl_per_notice($this->notice->notice_id, $this->link_expl);
}
if ($expl_aff) {
$this->isbd .= "<br /><b>{$msg[285]} </b>(" . $this->nb_expl . ")";
$this->isbd .= $expl_aff;
}
}
if ($this->show_explnum) {
$explnum_assoc = show_explnum_per_notice($this->notice->notice_id, 0, $this->link_explnum);
if ($explnum_assoc) {
$this->isbd .= "<b>{$msg['explnum_docs_associes']}</b> (" . show_explnum_per_notice($this->notice->notice_id, 0, $this->link_explnum, array(), true) . ")" . $explnum_assoc;
}
}
//documents numériques en relation...
$explnum_in_relation = show_explnum_in_relation($this->notice->notice_id, $this->link_explnum);
if ($explnum_in_relation) {
$this->isbd .= "<b>" . $msg["explnum_docs_in_relation"] . "</b>" . $explnum_in_relation;
}
//reservations et previsions
if ($this->show_resa || $this->show_planning && $pmb_resa_planning) {
$rqt_nt = "select count(*) from exemplaires, notices, docs_statut where exemplaires.expl_statut=docs_statut.idstatut and notices.notice_id=exemplaires.expl_notice and statut_allow_resa=1 and notices.notice_id=" . $this->notice_id;
$result = pmb_mysql_query($rqt_nt, $dbh) or die($rqt_nt . " " . pmb_mysql_error());
$nb_expl_reservables = pmb_mysql_result($result, 0, 0);
if ($this->show_resa) {
$aff_resa = resa_list($this->notice_id, 0, 0);
$ouvrir_reserv = "onclick=\"parent.location.href='" . $base_path . "/circ.php?categ=resa_from_catal&id_notice=" . $this->notice_id . "'; return(false) \"";
if ($aff_resa) {
$this->isbd .= "<b>" . $msg['resas'] . "</b><br />";
if ($nb_expl_reservables && !($categ == "resa") && !$id_empr) {
$this->isbd .= "<input type='button' class='bouton' value='" . $msg['351'] . "' {$ouvrir_reserv}><br /><br />";
}
$this->isbd .= $aff_resa . "<br />";
} else {
if ($nb_expl_reservables && !($categ == "resa") && !$id_empr) {
$this->isbd .= "<b>" . $msg['resas'] . "</b><br /><input type='button' class='bouton' value='" . $msg['351'] . "' {$ouvrir_reserv}><br /><br />";
}
}
}
if ($this->show_planning && $pmb_resa_planning) {
$aff_resa_planning = planning_list($this->notice_id, 0, 0);
$ouvrir_reserv = "onclick=\"parent.location.href='" . $base_path . "/circ.php?categ=resa_planning_from_catal&id_notice=" . $this->notice_id . "'; return(false) \"";
if ($aff_resa_planning) {
$this->isbd .= "<b>" . $msg['resas_planning'] . "</b><br />";
if ($nb_expl_reservables && !($categ == "resa_planning") && !$id_empr) {
$this->isbd .= "<input type='button' class='bouton' value='" . $msg['resa_planning_add'] . "' {$ouvrir_reserv}><br /><br />";
}
$this->isbd .= $aff_resa_planning . "<br />";
} else {
if ($nb_expl_reservables && !($categ == "resa_planning") && !$id_empr) {
$this->isbd .= "<b>" . $msg['resas_planning'] . "</b><br /><input type='button' class='bouton' value='" . $msg['resa_planning_add'] . "' {$ouvrir_reserv}><br /><br />";
}
}
}
}
return;
}
static function majNoticesGlobalIndex($notice, $NoIndex = 1)
{
global $dbh;
pmb_mysql_query("delete from notices_global_index where num_notice = " . $notice . " AND no_index = " . $NoIndex, $dbh);
$titres = pmb_mysql_query("select index_serie, tnvol, index_wew, index_sew, index_l, index_matieres, n_gen, n_contenu, n_resume, index_n_gen, index_n_contenu, index_n_resume, eformat, niveau_biblio from notices where notice_id = " . $notice, $dbh);
$mesNotices = pmb_mysql_fetch_assoc($titres);
$tit = $mesNotices['index_wew'];
$indTit = $mesNotices['index_sew'];
$indMat = $mesNotices['index_matieres'];
$indL = $mesNotices['index_l'];
$indResume = $mesNotices['index_n_resume'];
$indGen = $mesNotices['index_n_gen'];
$indContenu = $mesNotices['index_n_contenu'];
$resume = $mesNotices['n_resume'];
$gen = $mesNotices['n_gen'];
$contenu = $mesNotices['n_contenu'];
$indSerie = $mesNotices['index_serie'];
$tvol = $mesNotices['tnvol'];
$eformatlien = $mesNotices['eformat'];
$infos_global = ' ' . $tvol . ' ' . $tit . ' ' . $resume . ' ' . $gen . ' ' . $contenu . ' ' . $indL . ' ';
$infos_global_index = ' ' . $indSerie . ' ' . $indTit . ' ' . $indResume . ' ' . $indGen . ' ' . $indContenu . ' ' . $indMat . ' ';
// Authors :
$auteurs = pmb_mysql_query("select author_id, author_type, author_name, author_rejete, author_date, author_lieu,author_ville,author_pays,author_numero,author_subdivision, index_author from authors, responsability WHERE responsability_author = author_id AND responsability_notice = {$notice}", $dbh);
$numA = pmb_mysql_num_rows($auteurs);
$aut_pperso = new aut_pperso("author");
for ($j = 0; $j < $numA; $j++) {
$mesAuteurs = pmb_mysql_fetch_assoc($auteurs);
$infos_global .= $mesAuteurs['author_name'] . ' ' . $mesAuteurs['author_rejete'] . ' ' . $mesAuteurs['author_lieu'] . ' ' . $mesAuteurs['author_ville'] . ' ' . $mesAuteurs['author_pays'] . ' ' . $mesAuteurs['author_numero'] . ' ' . $mesAuteurs['author_subdivision'] . ' ';
if ($mesAuteurs['author_type'] == "72") {
$infos_global .= ' ' . $mesAuteurs['author_date'] . ' ';
}
$infos_global_index .= strip_empty_chars($mesAuteurs['author_name'] . ' ' . $mesAuteurs['author_rejete'] . ' ' . $mesAuteurs['author_lieu'] . ' ' . $mesAuteurs['author_ville'] . ' ' . $mesAuteurs['author_pays'] . ' ' . $mesAuteurs['author_numero'] . ' ' . $mesAuteurs['author_subdivision']) . ' ';
if ($mesAuteurs['author_type'] == "72") {
$infos_global_index .= strip_empty_chars($mesAuteurs['author_date'] . " ");
}
$mots_perso = $aut_pperso->get_fields_recherche($mesAuteurs['author_id']);
if ($mots_perso) {
$infos_global .= $mots_perso . ' ';
$infos_global_index .= strip_empty_words($mots_perso) . ' ';
}
}
pmb_mysql_free_result($auteurs);
// Nom du periodique
//cas d'un article
if ($mesNotices['niveau_biblio'] == 'a') {
$temp = pmb_mysql_query("select bulletin_notice, bulletin_titre, index_titre, index_wew, index_sew from analysis, bulletins, notices WHERE analysis_notice=" . $notice . " and analysis_bulletin = bulletin_id and bulletin_notice=notice_id", $dbh);
$numP = pmb_mysql_num_rows($temp);
if ($numP) {
// La notice appartient a un periodique, on selectionne le titre de periodique :
$mesTemp = pmb_mysql_fetch_assoc($temp);
$infos_global .= $mesTemp['index_wew'] . ' ' . $mesTemp['bulletin_titre'] . ' ' . $mesTemp['index_titre'] . ' ';
$infos_global_index .= strip_empty_words($mesTemp['index_wew'] . ' ' . $mesTemp['bulletin_titre'] . ' ' . $mesTemp['index_titre']) . ' ';
}
pmb_mysql_free_result($temp);
//cas d'un bulletin
} else {
if ($mesNotices['niveau_biblio'] == 'b') {
$temp = pmb_mysql_query("select serial.index_wew from notices join bulletins on bulletins.num_notice = notices.notice_id join notices as serial on serial.notice_id = bulletins.bulletin_notice where notices.notice_id = " . $notice);
$numP = pmb_mysql_num_rows($temp);
if ($numP) {
// La notice appartient a un periodique, on selectionne le titre de periodique :
$mesTemp = pmb_mysql_fetch_assoc($temp);
$infos_global .= $mesTemp['index_wew'] . ' ';
$infos_global_index .= strip_empty_words($mesTemp['index_wew']);
}
pmb_mysql_free_result($temp);
}
}
// Categories :
$aut_pperso = new aut_pperso("categ");
$noeud = pmb_mysql_query("select notices_categories.num_noeud as categ_id, libelle_categorie from notices_categories,categories where notcateg_notice = " . $notice . " and notices_categories.num_noeud=categories.num_noeud order by ordre_categorie", $dbh);
$numNoeuds = pmb_mysql_num_rows($noeud);
// Pour chaque noeud trouve on cherche les noeuds parents et les noeuds fils :
for ($j = 0; $j < $numNoeuds; $j++) {
// On met a jour la table notices_global_index avec le noeud trouve:
$mesNoeuds = pmb_mysql_fetch_assoc($noeud);
$infos_global .= $mesNoeuds['libelle_categorie'] . ' ';
$infos_global_index .= strip_empty_words($mesNoeuds['libelle_categorie']) . ' ';
$mots_perso = $aut_pperso->get_fields_recherche($mesNoeuds['categ_id']);
if ($mots_perso) {
$infos_global .= $mots_perso . ' ';
$infos_global_index .= strip_empty_words($mots_perso) . ' ';
}
}
// Sous-collection :
$aut_pperso = new aut_pperso("subcollection");
$subColls = pmb_mysql_query("select subcoll_id, sub_coll_name, index_sub_coll from notices, sub_collections WHERE subcoll_id = sub_coll_id AND notice_id = " . $notice, $dbh);
$numSC = pmb_mysql_num_rows($subColls);
for ($j = 0; $j < $numSC; $j++) {
$mesSubColl = pmb_mysql_fetch_assoc($subColls);
$infos_global .= $mesSubColl['index_sub_coll'] . ' ' . $mesSubColl['sub_coll_name'] . ' ';
$infos_global_index .= strip_empty_words($mesSubColl['index_sub_coll'] . ' ' . $mesSubColl['sub_coll_name']) . ' ';
$mots_perso = $aut_pperso->get_fields_recherche($mesSubColl['subcoll_id']);
if ($mots_perso) {
$infos_global .= $mots_perso . ' ';
$infos_global_index .= strip_empty_words($mots_perso) . ' ';
}
}
pmb_mysql_free_result($subColls);
// Indexation numerique :
$aut_pperso = new aut_pperso("indexint");
$indexNums = pmb_mysql_query("select indexint_id, indexint_name, indexint_comment from notices, indexint WHERE indexint = indexint_id AND notice_id = " . $notice, $dbh);
$numIN = pmb_mysql_num_rows($indexNums);
for ($j = 0; $j < $numIN; $j++) {
$mesindexNums = pmb_mysql_fetch_assoc($indexNums);
$infos_global .= $mesindexNums['indexint_name'] . ' ' . $mesindexNums['indexint_comment'] . ' ';
$infos_global_index .= strip_empty_words($mesindexNums['indexint_name'] . ' ' . $mesindexNums['indexint_comment']) . ' ';
$mots_perso = $aut_pperso->get_fields_recherche($mesindexNums['indexint_id']);
if ($mots_perso) {
$infos_global .= $mots_perso . ' ';
$infos_global_index .= strip_empty_words($mots_perso) . ' ';
}
}
pmb_mysql_free_result($indexNums);
// Collection :
$aut_pperso = new aut_pperso("collection");
$Colls = pmb_mysql_query("select coll_id, collection_name ,collection_issn from notices, collections WHERE coll_id = collection_id AND notice_id = " . $notice, $dbh);
$numCo = pmb_mysql_num_rows($Colls);
for ($j = 0; $j < $numCo; $j++) {
$mesColl = pmb_mysql_fetch_assoc($Colls);
$infos_global .= $mesColl['collection_name'] . ' ' . $mesColl['collection_issn'] . ' ';
$infos_global_index .= strip_empty_words($mesColl['collection_name']) . ' ' . strip_empty_words($mesColl['collection_issn']) . ' ';
$mots_perso = $aut_pperso->get_fields_recherche($mesColl['coll_id']);
if ($mots_perso) {
$infos_global .= $mots_perso . ' ';
$infos_global_index .= strip_empty_words($mots_perso) . ' ';
}
}
pmb_mysql_free_result($Colls);
// Editeurs :
$aut_pperso = new aut_pperso("publisher");
$editeurs = pmb_mysql_query("select ed_id, ed_name from notices, publishers WHERE (ed1_id = ed_id OR ed2_id = ed_id) AND notice_id = " . $notice, $dbh);
$numE = pmb_mysql_num_rows($editeurs);
for ($j = 0; $j < $numE; $j++) {
$mesEditeurs = pmb_mysql_fetch_assoc($editeurs);
$infos_global .= $mesEditeurs['ed_name'] . ' ';
$infos_global_index .= strip_empty_chars($mesEditeurs['ed_name']) . ' ';
$mots_perso = $aut_pperso->get_fields_recherche($mesEditeurs['ed_id']);
if ($mots_perso) {
$infos_global .= $mots_perso . ' ';
$infos_global_index .= strip_empty_words($mots_perso) . ' ';
}
}
pmb_mysql_free_result($editeurs);
pmb_mysql_free_result($titres);
// Titres Uniformes :
$aut_pperso = new aut_pperso("tu");
$tu = pmb_mysql_query("select tu_id, ntu_titre, tu_name, tu_tonalite, tu_sujet, tu_lieu, tu_contexte from notices_titres_uniformes,titres_uniformes WHERE tu_id=ntu_num_tu and ntu_num_notice=" . $notice, $dbh);
if (pmb_mysql_error() == "" && pmb_mysql_num_rows($tu)) {
$numtu = pmb_mysql_num_rows($tu);
for ($j = 0; $j < $numtu; $j++) {
$mesTu = pmb_mysql_fetch_assoc($tu);
$infos_global .= $mesTu['ntu_titre'] . ' ' . $mesTu['tu_name'] . ' ' . $mesTu['tu_tonalite'] . ' ' . $mesTu['tu_sujet'] . ' ' . $mesTu['tu_lieu'] . ' ' . $mesTu['tu_contexte'] . ' ';
$infos_global_index .= strip_empty_words($mesTu['ntu_titre'] . ' ' . $mesTu['tu_name'] . ' ' . $mesTu['tu_tonalite'] . ' ' . $mesTu['tu_sujet'] . ' ' . $mesTu['tu_lieu'] . ' ' . $mesTu['tu_contexte']) . ' ';
$mots_perso = $aut_pperso->get_fields_recherche($mesTu['tu_id']);
if ($mots_perso) {
$infos_global .= $mots_perso . ' ';
$infos_global_index .= strip_empty_words($mots_perso) . ' ';
}
}
pmb_mysql_free_result($tu);
}
// indexer les cotes des etat des collections :
$p_perso = new parametres_perso("collstate");
$coll = pmb_mysql_query("select collstate_id, collstate_cote from collections_state WHERE id_serial=" . $notice, $dbh);
$numcoll = pmb_mysql_num_rows($coll);
for ($j = 0; $j < $numcoll; $j++) {
$mescoll = pmb_mysql_fetch_assoc($coll);
$infos_global .= $mescoll['collstate_cote'] . ' ';
$infos_global_index .= strip_empty_words($mescoll['collstate_cote']) . ' ';
// champ perso cherchable
$mots_perso = $p_perso->get_fields_recherche($mescoll['collstate_id']);
if ($mots_perso) {
$infos_global .= $mots_perso . ' ';
$infos_global_index .= strip_empty_words($mots_perso) . ' ';
}
}
pmb_mysql_free_result($coll);
// Nomenclature
global $pmb_nomenclature_activate;
if ($pmb_nomenclature_activate) {
$mots = nomenclature_record_ui::get_index($notice);
$infos_global .= $mots . ' ';
$infos_global_index .= strip_empty_words($mots) . ' ';
}
// champ perso cherchable
$p_perso = new parametres_perso("notices");
$mots_perso = $p_perso->get_fields_recherche($notice);
if ($mots_perso) {
$infos_global .= $mots_perso . ' ';
$infos_global_index .= strip_empty_words($mots_perso) . ' ';
}
// champs des authperso
$auth_perso = new authperso_notice($notice);
$mots_authperso = $auth_perso->get_fields_search();
if ($mots_authperso) {
$infos_global .= $mots_authperso . ' ';
$infos_global_index .= strip_empty_words($mots_authperso) . ' ';
}
// flux RSS éventuellement
$eformat = array();
$eformat = explode(' ', $eformatlien);
if ($eformat[0] == 'RSS' && $eformat[3] == '1') {
$flux = strip_tags(affiche_rss($notice));
$infos_global_index .= strip_empty_words($flux) . ' ';
}
pmb_mysql_query("insert into notices_global_index SET num_notice=" . $notice . ",no_index =" . $NoIndex . ", infos_global='" . addslashes($infos_global) . "', index_infos_global='" . addslashes($infos_global_index) . "'", $dbh);
}
