$msg[z3950_integr_catal]";
} else {
print "$msg[notice_z3950_remplace_catal]
";
}
$resultat=mysql_query("select znotices_id, znotices_bib_id, isbd, isbn, titre, auteur, z_marc from z_notices where znotices_id='$znotices_id' AND znotices_query_id='$last_query_id'");
$integration_OK="";
$integrationexpl_OK="";
while (($ligne=mysql_fetch_array($resultat))) {
//$id_notice=$ligne["znotices_id"];
$znotices_id=$ligne["znotices_id"];
/* récupération du format des notices retournées par la bib */
$znotices_bib_id=$ligne["znotices_bib_id"];
$rqt_bib_id=mysql_query("select format from z_bib where bib_id='$znotices_bib_id'");
while (($ligne_format=mysql_fetch_array($rqt_bib_id))) {
$format=$ligne_format["format"];
}
$resultat_titre=$ligne["titre"];
$resultat_auteur=$ligne["auteur"];
$resultat_isbd=$ligne["isbd"];
$test_resultat++;
$lien = $resultat_titre." / ".$resultat_auteur;
print pmb_bidi(zshow_isbd($resultat_isbd, $lien));
if ($action != "integrerexpl") {
if ($source == 'form') {
$notice = new z3950_notice ('form');
} else {
// avant affichage du formulaire : détecter si notice déjà présente pour proposer MAJ
$isbn_verif = traite_code_isbn($ligne['isbn']) ;
$suite_rqt="";
if (isISBN($isbn_verif)) {
if (strlen($isbn_verif)==13)
$suite_rqt=" or code='".formatISBN($isbn_verif,13)."' ";
else $suite_rqt="or code='".formatISBN($isbn_verif,10)."' ";
}
if ($isbn_verif) {
$requete = "SELECT notice_id FROM notices WHERE code='$isbn_verif' ".$suite_rqt;
$myQuery = mysql_query($requete, $dbh);
$temp_nb_notice = mysql_num_rows($myQuery) ;
if ($temp_nb_notice) $not_id = mysql_result($myQuery, 0 ,0) ;
else $not_id=0 ;
}
// if ($not_id) METTRE ICI TRAITEMENT DU CHOIX DU DOUBLON echo "" ;
$notice = new z3950_notice ($format, $ligne['z_marc']);
}
}
$integration_OK="PASFAIT";
$integrationexpl_OK="PASFAIT";
switch ($action) {
case "integrer" :
if (!$id_notice) {
$res_integration = $notice->insert_in_database();
} else {
$res_integration = $notice->update_in_database($id_notice);
}
$new_notice=$res_integration[0];
$num_notice=$res_integration[1];
if (($new_notice==0) && ($num_notice==0)) $integration_OK="ECHEC";
if (($new_notice==0) && ($num_notice!=0)) $integration_OK="EXISTAIT";
if (($new_notice==1) && ($num_notice!=0)) $integration_OK="OK";
if (($new_notice==2) && ($num_notice!=0)) $integration_OK="UPDATE_OK";
if (($new_notice==1) && ($num_notice==0)) $integration_OK="NEWRATEE";
break;
case "integrerexpl" :
if ($notice_nbr == 0) {
$integration_OK = "ECHEC";
} else {
$integration_OK = "OK";
$num_notice = $notice_nbr;
$formlocid="f_ex_section".$f_ex_location ;
$f_ex_section=$$formlocid;
$res_integrationexpl = create_expl($f_ex_cb, $num_notice, $f_ex_typdoc, $f_ex_cote, $f_ex_section, $f_ex_statut, $f_ex_location, $f_ex_cstat, $f_ex_note, $f_ex_prix, $f_ex_owner, $f_ex_comment );
$new_expl=$res_integrationexpl[0];
$num_expl=$res_integrationexpl[1];
if (($new_expl==0) && ($num_expl==0)) $integrationexpl_OK="ECHEC";
if (($new_expl==0) && ($num_expl!=0)) $integrationexpl_OK="EXISTAIT";
if (($new_expl==1) && ($num_expl!=0)) $integrationexpl_OK="OK";
if (($new_expl==1) && ($num_expl==0)) $integrationexpl_OK="NEWRATEE";
}
break;
}
/* ----------------------------------- */
$msg[z3950_integr_expl_ok] = str_replace ("!!f_ex_cb!!", $f_ex_cb, $msg[z3950_integr_expl_ok] );
$msg[z3950_integr_expl_existait] = str_replace ("!!f_ex_cb!!", $f_ex_cb, $msg[z3950_integr_expl_existait]);
$msg[z3950_integr_expl_newrate] = str_replace ("!!f_ex_cb!!", $f_ex_cb, $msg[z3950_integr_expl_newrate] );
$msg[z3950_integr_expl_echec] = str_replace ("!!f_ex_cb!!", $f_ex_cb, $msg[z3950_integr_expl_echec] );
switch ($integrationexpl_OK) {
case "OK" :
print "
$msg[z3950_integr_expl_ok] $msg[z3950_integr_expl_levoir]";
print "" ;
break;
case "EXISTAIT" :
print "
$msg[z3950_integr_expl_existait] $msg[z3950_integr_expl_levoir]";
print "" ;
break;
case "NEWRATE" :
print "
$msg[z3950_integr_expl_newrate]";
break;
case "ECHEC" :
print "
$msg[z3950_integr_expl_echec]";
break;
}
switch ($integration_OK) {
case "OK" :
switch($notice->bibliographic_level.$notice->hierarchic_level){
case "a2" :
$url_view = "./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=$notice->bull_id&art_to_show=$num_notice";
break;
case "s1" :
$url_view = "./catalog.php?categ=serials&sub=view&serial_id=".$num_notice;
break;
default :
$url_view = "./catalog.php?categ=isbd&id=".$num_notice;
break;
}
print "
".$msg[z3950_integr_not_ok]."
$msg[z3950_integr_not_lavoir]";
print "" ;
break;
case "UPDATE_OK" :
print "
".$msg[z3950_update_not_ok]."
$msg[z3950_integr_not_lavoir]";
print "" ;
break;
case "EXISTAIT" :
if ($action=="integrer") {
print "
".$msg[z3950_integr_not_existait]."
$msg[z3950_integr_not_lavoir]";
print "" ;
}
break;
case "NEWRATE" :
if ($action=="integrer") print "
".$msg[z3950_integr_not_newrate]."";
break;
case "ECHEC" :
if ($action=="integrer") print "
".$msg[z3950_integr_not_echec]."";
break;
}
if ($integration_OK == "PASFAIT") {
echo $notice->get_form ("./catalog.php?categ=z3950&".
"znotices_id=$znotices_id&last_query_id=$last_query_id&action=integrer&source=form&".
"tri1=$tri1&tri2=$tri2", $id_notice, 'link');
}
if (($integration_OK == "OK") | ($integration_OK == "EXISTAIT") | ($integration_OK == "UPDATE_OK")) {
print "
".$msg[z3950_retour_a_resultats]."";
print "" ;
//$nex = new exemplaire('', 0, $num_notice);
//$nex->zexpl_form ('./catalog.php?categ=z3950&znotices_id='.$znotices_id.'&last_query_id='.$last_query_id.'&action=integrerexpl¬ice_nbr='.$num_notice.'&tri1='.$tri1.'&tri2='.$tri2);
}
} /* fin while */