function prefill_cote($id_notice = 0, $cote = "")
{
global $dbh;
global $deflt_docs_location;
global $value_prefix_cote;
$res_dewey = '';
$res_author = '';
$res_title = '';
$res_nvol = '';
$res_cote = '';
if (!$cote) {
// fetch the dewey code
$requete = "SELECT indexint_name FROM indexint, notices where notice_id='{$id_notice}' and indexint=indexint_id ";
$result = @pmb_mysql_query($requete, $dbh);
$nbr_lignes = pmb_mysql_num_rows($result);
if ($nbr_lignes) {
$res = pmb_mysql_fetch_object($result);
$res_dewey = $res->indexint_name;
}
// fetch the title and the volume number
$requete = "SELECT index_sew, tnvol FROM notices WHERE notice_id= '{$id_notice}' ";
$result = @pmb_mysql_query($requete, $dbh);
$res = pmb_mysql_fetch_object($result);
$res_title = pmb_strtoupper(pmb_str_replace(" ", "", $res->index_sew));
$res_nvol = $res->tnvol;
// récupération du libellé de la localisation par défaut du catalogueur
// si la localisation a dans son libellé ou son codage d'import ENSAI, on récupèrera 4 lettres pour l'auteur, dans les autres cas, on récupèrera 3 lettres
$requete = "SELECT location_libelle, locdoc_codage_import FROM docs_location WHERE idlocation= '" . $deflt_docs_location . "' ";
$result = @pmb_mysql_query($requete, $dbh);
$res = pmb_mysql_fetch_object($result);
if (preg_match("#ENSAI#", $res->location_libelle) || preg_match("#ENSAI#", $res->locdoc_codage_import)) {
$nb_car_auteur_cote = 4;
} else {
$nb_car_auteur_cote = 3;
}
// fetch the first author, but only if his responsability_type is 0
$requete = "SELECT index_author, responsability_type FROM authors, responsability WHERE author_id=responsability_author and responsability_notice = '{$id_notice}' ORDER BY responsability_type, responsability_ordre LIMIT 1";
$result = @pmb_mysql_query($requete, $dbh);
$nbr_lignes = pmb_mysql_num_rows($result);
// build the code using also the author name
if ($nbr_lignes) {
$res = pmb_mysql_fetch_object($result);
$res_author = pmb_strtoupper(pmb_substr(pmb_str_replace(" ", "", $res->index_author), 0, $nb_car_auteur_cote));
$res_cote = $res_dewey . " " . $res_author;
} else {
// no author at responsability_type 0 so build the code using only the title
$res_title = pmb_substr($res_title, 0, $nb_car_auteur_cote);
$res_cote = $res_dewey . " " . $res_title . " " . $res_nvol;
}
return $value_prefix_cote . $res_cote;
} else {
return $cote;
}
}
function prefill_cote($id_notice = 0, $cote = "")
{
global $dbh;
global $value_prefix_cote;
$res_dewey = '';
$res_author = '';
$res_title = '';
$res_nvol = '';
$res_cote = '';
if (!$cote) {
// fetch the dewey code
$requete = "SELECT indexint_name FROM indexint, notices where notice_id='{$id_notice}' and indexint=indexint_id ";
$result = @mysql_query($requete, $dbh);
$nbr_lignes = mysql_num_rows($result);
if ($nbr_lignes) {
$res = mysql_fetch_object($result);
$res_dewey = $res->indexint_name;
}
// fetch the title and the volume number
$requete = "SELECT index_sew, tnvol FROM notices WHERE notice_id= '{$id_notice}' ";
$result = @mysql_query($requete, $dbh);
$res = mysql_fetch_object($result);
$res_title = pmb_strtoupper(pmb_str_replace(" ", "", $res->index_sew));
$res_nvol = $res->tnvol;
// fetch the editor
$requete = "SELECT ed_name, index_publisher FROM publishers, notices WHERE ed1_id=ed_id and notice_id = '{$id_notice}'";
$result = @mysql_query($requete, $dbh);
$nbr_lignes = mysql_num_rows($result);
// build the code using also the author name
if ($nbr_lignes) {
$res = mysql_fetch_object($result);
if (strpos($res->ed_name, '(') > 0) {
$res_editor = substr(stristr($res->ed_name, '('), 1, 4);
} else {
$res_editor = strtoupper(substr($res->ed_name, 0, 4));
}
$res_title = pmb_substr($res_title, 0, 3);
$res_cote = $res_dewey . " " . $res_editor;
} else {
// no author at responsability_type 0 so build the code using only the title
$res_title = pmb_substr($res_title, 0, 4);
$res_cote = $res_dewey . " " . $res_title . " " . $res_nvol;
}
return $value_prefix_cote . $res_cote;
} else {
return $cote;
}
}
function prefill_cote($id_notice = 0, $cote = "")
{
global $dbh;
global $value_prefix_cote;
$res_dewey = '';
$res_author = '';
$res_title = '';
$res_nvol = '';
$res_cote = '';
if (!$cote) {
// fetch the dewey code
$requete = "SELECT indexint_name FROM indexint, notices where notice_id='{$id_notice}' and indexint=indexint_id ";
$result = @mysql_query($requete, $dbh);
$nbr_lignes = mysql_num_rows($result);
if ($nbr_lignes) {
$res = mysql_fetch_object($result);
$res_dewey = $res->indexint_name;
}
// fetch the title and the volume number
$requete = "SELECT index_sew, tnvol FROM notices WHERE notice_id= '{$id_notice}' ";
$result = @mysql_query($requete, $dbh);
$res = mysql_fetch_object($result);
$res_title = pmb_strtoupper(pmb_str_replace(" ", "", $res->index_sew));
$res_nvol = $res->tnvol;
// fetch the first author, but only if his responsability_type is 0
$requete = "SELECT index_author, responsability_type FROM authors, responsability WHERE author_id=responsability_author and responsability_notice = '{$id_notice}' and responsability_type = '0' LIMIT 1";
$result = @mysql_query($requete, $dbh);
$nbr_lignes = mysql_num_rows($result);
// build the code using also the author name
if ($nbr_lignes) {
$res = mysql_fetch_object($result);
$res_author = pmb_strtoupper(pmb_substr(pmb_str_replace(" ", "", $res->index_author), 0, 3));
$res_title = pmb_substr($res_title, 0, 3);
$res_cote = $res_dewey . " " . $res_author . "-" . $res_title . " " . $res_nvol;
} else {
// no author at responsability_type 0 so build the code using only the title
$res_title = pmb_substr($res_title, 0, 7);
$res_cote = $res_dewey . " " . $res_title . " " . $res_nvol;
}
return $value_prefix_cote . $res_cote;
} else {
return $cote;
}
}
