";
function select($ref, $id) {
global $id_empr;
global $groupID;
// retourne le code javascript changeant l'adresse de la page pour affichage des notices
// $ref -> type de donnée (editeur, collection)
// $id -> id de l'objet recherché
return "window.parent.document.location='../../../circ.php?categ=resa&mode=2&etat=aut_search&aut_type=$ref&aut_id=$id&id_empr=$id_empr&groupID=$groupID'; return(false);";
}
if($coll_parent) {
// affichage des enfants de la collection $coll_parent
$requete = "SELECT * FROM publishers, collections, sub_collections";
$requete .= " WHERE publishers.ed_id=collections.collection_parent";
$requete .= " AND collections.collection_id=sub_collections.sub_coll_parent";
$requete .= " AND sub_collections.sub_coll_parent=$coll_parent";
$requete .= " ORDER BY sub_collections.sub_coll_name";
$result = pmb_mysql_query($requete, $dbh);
$item = pmb_mysql_fetch_object($result);
print "
$up_folder...
";
print pmb_bidi($open_folder."
ed_id)."\">".$item->ed_name."");
print pmb_bidi("
");
print "
");
while($item=pmb_mysql_fetch_object($result)) {
print "
");
}
} else {
if($ed_parent) {
// affichage des enfants de l'éditeur $ed_parent
print "
".$up_folder.'...
';
// c'est Eric qui m'a dit ça. Merci Eric ;-) (de toute façon, j'ai jamais aimé les dimanches).
$requete = "SELECT * FROM publishers, collections";
$requete .= " LEFT JOIN sub_collections ON collections.collection_id=sub_collections.sub_coll_parent";
$requete .= " WHERE publishers.ed_id=collections.collection_parent";
$requete .= " AND publishers.ed_id=$ed_parent";
$requete .= " ORDER BY collections.collection_name";
$result = pmb_mysql_query($requete, $dbh);
$item = pmb_mysql_fetch_object($result);
print pmb_bidi($open_folder."
ed_id)."\">".$item->ed_name.'');
if($item->sub_coll_id && $item->sub_coll_parent==$item->collection_id)
$image = "
$closed_folder";
else
$image = $document;
print pmb_bidi("
');
while($item=pmb_mysql_fetch_object($result)) {
if($item->sub_coll_id && $item->sub_coll_parent==$item->collection_id)
$image = "
$closed_folder";
else
$image = $document;
print pmb_bidi("
');
}
} else {
if (!isset($limite_affichage) || $limite_affichage=="") {
$restriction = " limit 0,30 ";
} else {
$restriction = "";
}
print "
$msg[tout_afficher]";
// affichage de la liste des éditeurs (1er niveau)
$requete = "SELECT * FROM publishers LEFT JOIN collections";
$requete .= " ON publishers.ed_id=collections.collection_parent";
$requete .= " GROUP BY ed_name ORDER BY ed_name $restriction ";
$result = pmb_mysql_query($requete, $dbh);
while($editeur=pmb_mysql_fetch_object($result)) {
if($editeur->collection_id)
$image = "
$closed_folder";
else $image = $document;
print pmb_bidi($image."
ed_id)."\">".$editeur->ed_name."\n");
}
if(isset($ancre) && $ancre)
print pmb_bidi($j_offset);
} // fin clause ed_parent
} // fin clause coll_parent
pmb_mysql_close($dbh);
// affichage du footer
print "