function fetch_serial_data()
{
global $dbh;
global $fonction_auteur;
$myQuery = pmb_mysql_query("SELECT * FROM notices WHERE notice_id='" . $this->serial_id . "' LIMIT 1", $dbh);
$myPerio = pmb_mysql_fetch_object($myQuery);
// type du document
$this->typdoc = $myPerio->typdoc;
// statut de la notice
$this->statut = $myPerio->statut;
$this->commentaire_gestion = $myPerio->commentaire_gestion;
$this->thumbnail_url = $myPerio->thumbnail_url;
// code-barre
$this->code = $myPerio->code;
// mentions de titre
$this->tit1 = $myPerio->tit1;
$this->tit3 = $myPerio->tit3;
$this->tit4 = $myPerio->tit4;
// libelle des auteurs
$this->responsabilites = get_notice_authors($this->serial_id);
// libelle des éditeurs
if ($myPerio->ed1_id) {
$this->ed1_id = $myPerio->ed1_id;
$editeur = new editeur($this->ed1_id);
$this->ed1 = $editeur->display;
}
if ($myPerio->ed2_id) {
$this->ed2_id = $myPerio->ed2_id;
$editeur = new editeur($this->ed2_id);
$this->ed2 = $editeur->display;
}
// année d'édition
$this->year = $myPerio->year;
$this->date_parution_perio = serial::get_date_parution($this->year);
// zone des notes
$this->n_gen = $myPerio->n_gen;
$this->n_contenu = $myPerio->n_contenu;
$this->n_resume = $myPerio->n_resume;
// mise à jour des catégories
$this->categories = get_notice_categories($this->serial_id);
// indexation interne
if ($myPerio->indexint) {
$this->indexint = $myPerio->indexint;
$indexint = new indexint($this->indexint);
if ($indexint->comment) {
$this->indexint_lib = $indexint->name . " - " . $indexint->comment;
} else {
$this->indexint_lib = $indexint->name;
}
}
// indexation libre
$this->index_l = $myPerio->index_l;
// libelle des langues
$this->langues = get_notice_langues($this->serial_id, 0);
// langues de la publication
$this->languesorg = get_notice_langues($this->serial_id, 1);
// langues originales
// lien vers une ressource électronique
$this->lien = $myPerio->lien;
$this->eformat = $myPerio->eformat;
$this->signature = $myPerio->signature;
// Montrer ou pas le bulletinage en opac
$this->opac_visible_bulletinage = $myPerio->opac_visible_bulletinage;
// Autoriser la demande d'abonnement à l'OPAC
$this->opac_serialcirc_demande = $myPerio->opac_serialcirc_demande;
$this->indexation_lang = $myPerio->indexation_lang;
$this->is_new = $myPerio->notice_is_new;
$this->date_is_new = $myPerio->notice_date_is_new;
$this->notice_link = array();
//liens vers autres notices
$requete = "\n\t\tSELECT notices_relations.* FROM notices_relations\n\t\tLEFT OUTER JOIN bulletins ON bulletins.num_notice=notices_relations.num_notice AND bulletins.bulletin_notice=notices_relations.linked_notice\n\t\tWHERE (notices_relations.num_notice=" . $this->serial_id . " OR notices_relations.linked_notice=" . $this->serial_id . ")\n\t\tAND (bulletin_notice IS NULL OR bulletins.bulletin_notice!=" . $this->serial_id . ")\n\t\tORDER BY rank";
$result_rel = pmb_mysql_query($requete) or die(pmb_mysql_error());
if (pmb_mysql_num_rows($result_rel)) {
$i = 0;
while ($r_rel = pmb_mysql_fetch_object($result_rel)) {
if ($r_rel->linked_notice == $this->serial_id) {
//notice en cours est notice fille
$this->notice_link['down'][$i]['relation_direction'] = 'down';
$this->notice_link['down'][$i]['id_notice'] = $r_rel->num_notice;
$this->notice_link['down'][$i]['title_notice'] = $this->get_notice_title($r_rel->num_notice);
$this->notice_link['down'][$i]['rank'] = $r_rel->rank;
$this->notice_link['down'][$i]['relation_type'] = $r_rel->relation_type;
} elseif ($r_rel->num_notice == $this->serial_id) {
//notice en cours est notice mere
$this->notice_link['up'][$i]['relation_direction'] = 'up';
$this->notice_link['up'][$i]['id_notice'] = $r_rel->linked_notice;
$this->notice_link['up'][$i]['title_notice'] = $this->get_notice_title($r_rel->linked_notice);
$this->notice_link['up'][$i]['rank'] = $r_rel->rank;
$this->notice_link['up'][$i]['relation_type'] = $r_rel->relation_type;
}
$i++;
}
}
$this->create_date = $myPerio->create_date;
$this->update_date = $myPerio->update_date;
return $myQuery->nbr_rows;
}
$var_autfonc = "f_f1_code{$i}";
$f_aut[] = array('id' => ${$var_autid}, 'fonction' => ${$var_autfonc}, 'type' => '1', 'ordre' => $i);
}
// auteurs secondaires
for ($i = 0; $i < $max_aut2; $i++) {
$var_autid = "f_aut2_id{$i}";
$var_autfonc = "f_f2_code{$i}";
$f_aut[] = array('id' => ${$var_autid}, 'fonction' => ${$var_autfonc}, 'type' => '2', 'ordre' => $i);
}
$table['ed1_id'] = $f_ed1_id;
$table['ed2_id'] = $f_ed2_id;
$table['year'] = $f_year;
$table['n_gen'] = $f_n_gen;
$table['n_contenu'] = $f_n_contenu;
$table['n_resume'] = $f_n_resume;
$date_parution = serial::get_date_parution($f_year);
$table['date_parution'] = $date_parution;
// categories
if ($tab_categ_order) {
$categ_order = explode(",", $tab_categ_order);
$order = 0;
foreach ($categ_order as $old_order) {
$var_categid = "f_categ_id{$old_order}";
if ($var_categid) {
$f_categ[] = array('id' => ${$var_categid}, 'ordre' => $order);
$order++;
}
}
} else {
for ($i = 0; $i < $max_categ; $i++) {
$var_categid = "f_categ_id{$i}";
