function bul_do_form($obj)
{
// $obj = objet contenant les propriétés de l'exemplaire associé
global $bul_expl_form1, $expl_bulletinage_tpl;
global $msg;
// pour texte du bouton supprimer
global $dbh, $charset;
global $pmb_type_audit, $select_categ_prop, $pmb_antivol;
global $id_bull, $bul_id, $serial_id, $numero, $pmb_rfid_activate, $pmb_rfid_serveur_url;
global $deflt_explnum_statut;
if (!$obj->abt_numeric) {
$bul_expl_form1 = str_replace('!!expl_bulletinage_tpl!!', $expl_bulletinage_tpl, $bul_expl_form1);
} else {
$bul_expl_form1 = str_replace('!!expl_bulletinage_tpl!!', "", $bul_expl_form1);
}
$action = "./pointage_exemplarise.php?act=update&id_bull={$id_bull}&bul_id={$bul_id}";
// statut
$select_statut = gen_liste_multiple("select id_explnum_statut, gestion_libelle from explnum_statut order by 2", "id_explnum_statut", "gestion_libelle", "id_explnum_statut", "f_explnum_statut", "", $deflt_explnum_statut, "", "", "", "", 0);
$bul_expl_form1 = str_replace('!!statut_list!!', $select_statut, $bul_expl_form1);
// mise à jour des champs de gestion
$bul_expl_form1 = str_replace('!!bul_id!!', $obj->expl_bulletin, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!id_form!!', md5(microtime()), $bul_expl_form1);
$bul_expl_form1 = str_replace('!!org_cb!!', $obj->expl_cb, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!expl_id!!', $obj->expl_id, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!action!!', $action, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!id!!', $obj->expl_notice, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!cb!!', $obj->expl_cb, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!note!!', $obj->expl_note, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!comment!!', $obj->expl_comment, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!cote!!', htmlentities($obj->expl_cote, ENT_QUOTES, $charset), $bul_expl_form1);
$bul_expl_form1 = str_replace('!!prix!!', $obj->expl_prix, $bul_expl_form1);
if (!$obj->abt_numeric) {
$bul_expl_form1 = str_replace('!!focus!!', $obj->focus, $bul_expl_form1);
} else {
$bul_expl_form1 = str_replace('!!focus!!', "", $bul_expl_form1);
}
// select "type document"
$bul_expl_form1 = str_replace('!!type_doc!!', do_selector('docs_type', 'expl_typdoc', $obj->expl_typdoc), $bul_expl_form1);
// select "section"
$bul_expl_form1 = str_replace('!!section!!', do_selector_bul_section($obj->expl_section, $obj->expl_location), $bul_expl_form1);
// select "statut"
$bul_expl_form1 = str_replace('!!statut!!', do_selector('docs_statut', 'expl_statut', $obj->expl_statut), $bul_expl_form1);
// select "localisation"
$bul_expl_form1 = str_replace('!!localisation!!', gen_liste("select distinct idlocation, location_libelle from docs_location, docsloc_section where num_location=idlocation order by 2", "idlocation", "location_libelle", 'expl_location', "calcule_section(this);", $obj->expl_location, "", "", "", "", 0), $bul_expl_form1);
// select "code statistique"
$bul_expl_form1 = str_replace('!!codestat!!', do_selector('docs_codestat', 'expl_codestat', $obj->expl_codestat), $bul_expl_form1);
// select "owner"
$bul_expl_form1 = str_replace('!!owner!!', do_selector('lenders', 'expl_owner', $obj->expl_owner), $bul_expl_form1);
$selector = "";
if ($pmb_antivol > 0) {
// select "type_antivol"
$selector = "\n\t\t<div class='colonne3'>\n\t\t<!-- code stat -->\n\t\t<label class='etiquette' for='type_antivol'>{$msg['type_antivol']}</label>\n\t\t<div class='row'>\n\t\t<select name='type_antivol' id='type_antivol'>";
$selector .= "<option value='0'";
if ($obj->type_antivol == 0) {
$selector .= ' SELECTED';
}
$selector .= '>';
$selector .= $msg["type_antivol_aucun"] . '</option>';
$selector .= "<option value='1'";
if ($obj->type_antivol == 1) {
$selector .= ' SELECTED';
}
$selector .= '>';
$selector .= $msg["type_antivol_magnetique"] . '</option>';
$selector .= "<option value='2'";
if ($obj->type_antivol == 2) {
$selector .= ' SELECTED';
}
$selector .= '>';
$selector .= $msg["type_antivol_autre"] . '</option>';
$selector .= '</select></div></div>';
}
$bul_expl_form1 = str_replace('!!type_antivol!!', $selector, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!bul_id!!', $bul_id, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!expl_id!!', $obj->expl_id, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!bul_no!!', htmlentities($obj->bul_no, ENT_QUOTES, $charset), $bul_expl_form1);
$date_date_formatee = formatdate_input($obj->date_date);
$date_clic = "onClick=\"openPopUp('./../../../select.php?what=calendrier&caller=expl&date_caller=" . str_replace('-', '', $obj->date_date) . "¶m1=date_date¶m2=date_date_lib&auto_submit=NO&date_anterieure=YES', 'date_date', 250, 300, -2, -2, 'toolbar=no, dependent=yes, resizable=yes')\" ";
$date_date = "<input type='hidden' name='date_date' value='" . str_replace('-', '', $obj->date_date) . "' />\n\t\t<input class='saisie-10em' type='text' name='date_date_lib' value='" . $date_date_formatee . "' placeholder='" . $msg["format_date_input_placeholder"] . "'/>\n\t\t<input class='bouton_small' type='button' name='date_date_lib_bouton' value='" . $msg["bouton_calendrier"] . "' " . $date_clic . " />";
$bul_expl_form1 = str_replace('!!date_date!!', $date_date, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!bul_date!!', htmlentities($obj->bul_date, ENT_QUOTES, $charset), $bul_expl_form1);
$bul_expl_form1 = str_replace('!!bul_titre!!', htmlentities($obj->bul_titre, ENT_QUOTES, $charset), $bul_expl_form1);
$bul_expl_form1 = str_replace('!!serial_id!!', $serial_id, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!numero!!', $obj->bul_titre, $bul_expl_form1);
$bul_expl_form1 = str_replace('!!destinataire!!', $obj->destinataire, $bul_expl_form1);
$p_perso = new parametres_perso("expl");
if (!$p_perso->no_special_fields) {
$c = 0;
$perso = "";
$perso_ = $p_perso->show_editable_fields($obj->expl_id);
for ($i = 0; $i < count($perso_["FIELDS"]); $i++) {
$p = $perso_["FIELDS"][$i];
if ($c == 0) {
$perso .= "<div class='row'>\n";
}
$perso .= "<div class='colonne3'><label for='" . $p["NAME"] . "' class='etiquette'>" . $p["TITRE"] . " </label>" . $p["COMMENT_DISPLAY"] . "<div class='row'>" . $p["AFF"] . "</div></div>\n";
$c++;
if ($c == 3) {
$perso .= "</div>\n";
$c = 0;
}
}
if ($c == 1) {
$perso .= "<div class='colonne2'> </div>\n</div>\n";
}
$perso = $perso_["CHECK_SCRIPTS"] . "\n" . $perso;
} else {
$perso = "\n<script>function check_form() { return true; }</script>\n";
}
$bul_expl_form1 = str_replace("!!champs_perso!!", $perso, $bul_expl_form1);
if ($pmb_rfid_activate == 1 && $pmb_rfid_serveur_url && !$obj->abt_numeric) {
$script_rfid_encode = "if(script_rfid_encode()==false) return false;";
$bul_expl_form1 = str_replace('!!questionrfid!!', $script_rfid_encode, $bul_expl_form1);
} else {
$bul_expl_form1 = str_replace('!!questionrfid!!', '', $bul_expl_form1);
}
$bul_expl_form1 = str_replace('!!create_notice_bul!!', '<input type="checkbox" value="1" id="create_notice_bul" name="create_notice_bul"> ' . $msg['bulletinage_create_notice'], $bul_expl_form1);
return $bul_expl_form1;
}
function bul_do_form($obj, $bul_id = 0)
{
// $obj = objet contenant les propriétés de l'exemplaire associé
global $bul_expl_form;
global $msg;
// pour texte du bouton supprimer
global $dbh;
global $pmb_type_audit, $select_categ_prop;
global $pmb_antivol;
global $option_num_auto;
global $pmb_rfid_activate, $pmb_rfid_serveur_url, $charset;
global $pmb_expl_show_dates, $pmb_expl_show_lastempr;
global $thesaurus_concepts_active;
if (isset($option_num_auto)) {
$requete = "DELETE from exemplaires_temp where sess not in (select SESSID from sessions)";
$res = pmb_mysql_query($requete, $dbh);
//Appel à la fonction de génération automatique de cb
$code_exemplaire = init_gen_code_exemplaire(0, $obj->expl_bulletin);
do {
$code_exemplaire = gen_code_exemplaire(0, $obj->expl_bulletin, $code_exemplaire);
$requete = "select expl_cb from exemplaires WHERE expl_cb='{$code_exemplaire}'";
$res0 = pmb_mysql_query($requete, $dbh);
$requete = "select cb from exemplaires_temp WHERE cb='{$code_exemplaire}' AND sess <>'" . SESSid . "'";
$res1 = pmb_mysql_query($requete, $dbh);
} while (pmb_mysql_num_rows($res0) || pmb_mysql_num_rows($res1));
//Memorise dans temps le cb et la session pour le cas de multi utilisateur session
$obj->expl_cb = $code_exemplaire;
$requete = "INSERT INTO exemplaires_temp (cb ,sess) VALUES ('{$obj->expl_cb}','" . SESSid . "')";
$res = pmb_mysql_query($requete, $dbh);
}
//on compte le nombre de prets pour cet exemplaire
$req = "select count(arc_expl_id) as nb_prets from pret_archive where arc_expl_id = " . $obj->expl_id;
$res = pmb_mysql_query($req);
if (pmb_mysql_num_rows($res)) {
$arch_pret = pmb_mysql_fetch_object($res);
$nb_prets = $arch_pret->nb_prets;
} else {
$nb_prets = 0;
}
if ($nb_prets) {
//dernière date de pret pour cet exemplaire
$req = "select date_format(last_loan_date, '" . $msg["format_date"] . "') as date_last from exemplaires where expl_id = " . $obj->expl_id;
$res = pmb_mysql_query($req);
if (pmb_mysql_num_rows($res)) {
$expl_pret = pmb_mysql_fetch_object($res);
$date_last = $expl_pret->date_last;
$info_nb_prets = str_replace("!!nb_prets!!", $nb_prets, $msg['expl_nbprets']);
$query = "select count(pret_idexpl) ";
$query .= "from pret, empr where pret_idexpl='" . $obj->expl_id . "' and pret_idempr=id_empr ";
$result = pmb_mysql_query($query, $dbh);
if ($result && pmb_mysql_result($result, 0, 0)) {
$info_date_last = str_replace("!!date_last!!", $date_last, $msg['expl_lastpret_encours']);
} else {
$info_date_last = str_replace("!!date_last!!", $date_last, $msg['expl_lastpret_retour']);
}
print $info_nb_prets . " " . $info_date_last;
}
}
// l'annulation du form renvoit à :
$annuler = "./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=" . $obj->expl_bulletin;
$action = "./catalog.php?categ=serials&sub=bulletinage&action=expl_update";
$expl_nbparts = $obj->expl_cb;
if (!$obj->expl_nbparts) {
$expl_nbparts = 1;
} else {
$expl_nbparts = $obj->expl_nbparts;
}
// mise à jour des champs de gestion
$bul_expl_form = str_replace('!!bul_id!!', $obj->expl_bulletin, $bul_expl_form);
$bul_expl_form = str_replace('!!id_form!!', md5(microtime()), $bul_expl_form);
$bul_expl_form = str_replace('!!org_cb!!', htmlentities($obj->expl_cb, ENT_QUOTES, $charset), $bul_expl_form);
$bul_expl_form = str_replace('!!expl_id!!', $obj->expl_id, $bul_expl_form);
$bul_expl_form = str_replace('!!action!!', $action, $bul_expl_form);
$bul_expl_form = str_replace('!!id!!', $obj->expl_notice, $bul_expl_form);
$bul_expl_form = str_replace('!!cb!!', htmlentities($obj->expl_cb, ENT_QUOTES, $charset), $bul_expl_form);
$bul_expl_form = str_replace('!!nbparts!!', htmlentities($expl_nbparts, ENT_QUOTES, $charset), $bul_expl_form);
$bul_expl_form = str_replace('!!note!!', $obj->expl_note, $bul_expl_form);
$bul_expl_form = str_replace('!!comment!!', $obj->expl_comment, $bul_expl_form);
$bul_expl_form = str_replace('!!cote!!', $obj->expl_cote, $bul_expl_form);
$bul_expl_form = str_replace('!!prix!!', $obj->expl_prix, $bul_expl_form);
// select "type document"
$bul_expl_form = str_replace('!!type_doc!!', do_selector('docs_type', 'expl_typdoc', $obj->expl_typdoc), $bul_expl_form);
// select "section"
$bul_expl_form = str_replace('!!section!!', do_selector_bul_section($obj->expl_section, $obj->expl_location), $bul_expl_form);
// select "statut"
$bul_expl_form = str_replace('!!statut!!', do_selector('docs_statut', 'expl_statut', $obj->expl_statut), $bul_expl_form);
// select "localisation"
//visibilité des exemplaires
global $explr_visible_mod, $pmb_droits_explr_localises;
if ($pmb_droits_explr_localises) {
$where_clause_explr = "idlocation in (" . $explr_visible_mod . ") and";
} else {
$where_clause_explr = "";
}
$bul_expl_form = str_replace('!!localisation!!', gen_liste("select distinct idlocation, location_libelle from docs_location, docsloc_section where {$where_clause_explr} num_location=idlocation order by 2", "idlocation", "location_libelle", 'expl_location', "calcule_section(this);", $obj->expl_location, "", "", "", "", 0), $bul_expl_form);
// select "code statistique"
$bul_expl_form = str_replace('!!codestat!!', do_selector('docs_codestat', 'expl_codestat', $obj->expl_codestat), $bul_expl_form);
// select "owner"
$bul_expl_form = str_replace('!!owner!!', do_selector('lenders', 'expl_owner', $obj->expl_owner), $bul_expl_form);
//dates creation / modification
if ($obj->expl_id && ($pmb_expl_show_dates == '1' || $pmb_expl_show_dates == '3')) {
$bul_expl_form = str_replace('<!-- msg_exp_cre_date -->', "<label class='etiquette' >" . htmlentities($msg['exp_cre_date'], ENT_QUOTES, $charset) . "</label>", $bul_expl_form);
$bul_expl_form = str_replace('<!-- exp_cre_date -->', format_date($obj->create_date), $bul_expl_form);
$bul_expl_form = str_replace('<!-- msg_exp_upd_date -->', "<label class='etiquette' >" . htmlentities($msg['exp_upd_date'], ENT_QUOTES, $charset) . "</label>", $bul_expl_form);
$bul_expl_form = str_replace('<!-- exp_upd_date -->', format_date($obj->update_date), $bul_expl_form);
}
//dates dépôt / retour
if ($obj->expl_id && ($pmb_expl_show_dates == '2' || $pmb_expl_show_dates == '3')) {
$bul_expl_form = str_replace('<!-- msg_exp_filing_date -->', "<label class='etiquette' >" . htmlentities($msg['filing_date'], ENT_QUOTES, $charset) . "</label>", $bul_expl_form);
$bul_expl_form = str_replace('<!-- exp_filing_date -->', format_date($obj->expl_date_depot), $bul_expl_form);
$bul_expl_form = str_replace('<!-- msg_exp_return_date -->', "<label class='etiquette' >" . htmlentities($msg['return_date'], ENT_QUOTES, $charset) . "</label>", $bul_expl_form);
$bul_expl_form = str_replace('<!-- exp_return_date -->', format_date($obj->expl_date_retour), $bul_expl_form);
}
// Indexation concept
if ($thesaurus_concepts_active == 1) {
$index_concept = new index_concept($obj->expl_id, TYPE_EXPL);
$bul_expl_form = str_replace('<!-- index_concept_form -->', $index_concept->get_form("expl"), $bul_expl_form);
}
// select "type_antivol"
$selector = "";
if ($pmb_antivol > 0) {
global $value_deflt_antivol;
if ($obj->type_antivol == "") {
$obj->type_antivol = $value_deflt_antivol;
}
// select "type_antivol"
$selector = "\n\t\t<div class='colonne3'>\n\t\t<!-- code stat -->\n\t\t<label class='etiquette' for='type_antivol'>{$msg['type_antivol']}</label>\n\t\t<div class='row'>\n\t\t<select name='type_antivol' id='type_antivol'>";
$selector .= "<option value='0'";
if ($obj->type_antivol == 0) {
$selector .= ' SELECTED';
}
$selector .= '>';
$selector .= $msg["type_antivol_aucun"] . '</option>';
$selector .= "<option value='1'";
if ($obj->type_antivol == 1) {
$selector .= ' SELECTED';
}
$selector .= '>';
$selector .= $msg["type_antivol_magnetique"] . '</option>';
$selector .= "<option value='2'";
if ($obj->type_antivol == 2) {
$selector .= ' SELECTED';
}
$selector .= '>';
$selector .= $msg["type_antivol_autre"] . '</option>';
$selector .= '</select></div></div>';
}
$bul_expl_form = str_replace('!!type_antivol!!', $selector, $bul_expl_form);
$p_perso = new parametres_perso("expl");
if (!$p_perso->no_special_fields) {
$c = 0;
$perso = "<hr />";
global $expl_id_from;
if ($expl_id_from && !$obj->expl_id) {
$perso_id_expl = $expl_id_from;
} elseif ($obj->expl_id) {
$perso_id_expl = $obj->expl_id;
} else {
$perso_id_expl = 0;
}
$perso_ = $p_perso->show_editable_fields($perso_id_expl);
for ($i = 0; $i < count($perso_["FIELDS"]); $i++) {
$p = $perso_["FIELDS"][$i];
if ($c == 0) {
$perso .= "<div class='row'>\n";
}
$perso .= "<div class='colonne2'><label for='" . $p["NAME"] . "' class='etiquette'>" . $p["TITRE"] . " </label>" . $p["COMMENT_DISPLAY"] . "<div class='row'>" . $p["AFF"] . "</div></div>\n";
$c++;
if ($c == 2) {
$perso .= "</div>\n";
$c = 0;
}
}
if ($c == 1) {
$perso .= "<div class='colonne2'> </div>\n</div>\n";
}
$perso = $perso_["CHECK_SCRIPTS"] . "\n" . $perso;
$perso = "<div class='row'>" . $perso . "</div>";
} else {
$perso = "";
}
$bul_expl_form = str_replace("!!champs_perso!!", $perso, $bul_expl_form);
// circulation des périodique
$perio_circ_tpl = "";
$in_circ = 0;
if ($obj->expl_id) {
$req = "select * from serialcirc_expl where num_serialcirc_expl_id=" . $obj->expl_id;
$res_in_circ = pmb_mysql_query($req);
if (pmb_mysql_num_rows($res_in_circ)) {
$in_circ = 1;
$perio_circ_tpl = "<label class='etiquette'>" . $msg['serialcirc_expl_in_circ'] . "</label>";
}
}
if (!$in_circ) {
$req = "select * from abts_abts, bulletins, serialcirc where abts_abts.num_notice =bulletin_notice and bulletin_id=" . $obj->expl_bulletin . " and num_serialcirc_abt=abt_id\n\t\torder by abt_name";
$res_circ = pmb_mysql_query($req);
if ($nb = pmb_mysql_num_rows($res_circ)) {
$perio_circ_tpl = "<input type='checkbox' name='serial_circ_add' value='1'> " . $msg['serialcirc_add_expl'];
if ($nb > 1) {
$perio_circ_tpl .= "<select name='abt_id'>";
}
while ($circ = pmb_mysql_fetch_object($res_circ)) {
if ($nb == 1) {
$perio_circ_tpl .= "<input type='hidden' name='abt_id' value='" . $circ->abt_id . "' >";
break;
}
$perio_circ_tpl .= "<option value='" . $circ->abt_id . "'> " . htmlentities($circ->abt_name, ENT_QUOTES, $charset) . "</option>";
}
if ($nb > 1) {
$perio_circ_tpl .= "</select>";
}
}
}
$bul_expl_form = str_replace("!!perio_circ_tpl!!", $perio_circ_tpl, $bul_expl_form);
// bouton supprimer si modification
if ($obj->expl_id) {
$del_button = "<input type='button' class='bouton' value=' {$msg['63']} ' onClick=\"confirm_expl_delete();\">";
$bt_dupliquer = "<input type='button' class='bouton' value=\"" . $msg['dupl_expl_bt'] . "\" name='dupl_ex' id='dupl_ex' onClick=\"unload_off();document.location='./catalog.php?categ=serials&sub=bulletinage&action=dupl_expl&bul_id=" . $obj->expl_bulletin . "&expl_id=" . $obj->expl_id . "' ; \" />";
if ($pmb_type_audit) {
$link_audit = "<input class='bouton' type='button' onClick=\"openPopUp('./audit.php?type_obj=2&object_id={$obj->expl_id}', 'audit_popup', 700, 500, -2, -2, '{$select_categ_prop}')\" title='{$msg['audit_button']}' value='{$msg['audit_button']}' />";
} else {
$link_audit = "";
}
} else {
$del_button = "";
$link_audit = "";
$bt_dupliquer = "";
}
//boutons selon droits
$nex = new exemplaire($obj->cb, $obj->expl_id, $obj->notice, $obj->bulletin);
if ($nex->explr_acces_autorise == "MODIF") {
$bt_modifier = "<input type='submit' class='bouton' value=' {$msg['77']} ' onClick=\"return test_form(this.form)\" />";
} else {
$bt_modifier = "";
$del_button = "";
$bt_dupliquer = "";
}
if ($pmb_rfid_activate == 1 && $pmb_rfid_serveur_url) {
$script_rfid_encode = "if(script_rfid_encode()==false) return false;";
$bul_expl_form = str_replace('!!questionrfid!!', $script_rfid_encode, $bul_expl_form);
} else {
$bul_expl_form = str_replace('!!questionrfid!!', '', $bul_expl_form);
}
$bul_expl_form = str_replace('!!del!!', $del_button, $bul_expl_form);
$bul_expl_form = str_replace('!!link_audit!!', $link_audit, $bul_expl_form);
$bul_expl_form = str_replace('!!bt_dupliquer!!', $bt_dupliquer, $bul_expl_form);
$bul_expl_form = str_replace('!!bt_modifier!!', $bt_modifier, $bul_expl_form);
$bul_expl_form = str_replace('!!bul_id!!', $bul_id, $bul_expl_form);
$bul_expl_form = str_replace('!!expl_id!!', $obj->expl_id, $bul_expl_form);
// action du bouton annuler
$bul_expl_form = str_replace('!!annuler_action!!', $annuler, $bul_expl_form);
// rafraichissement de la liste des sections par rapport à la localisation sélectionnée
// $bul_expl_form .= "<script> calcule_section(document.forms['expl'].expl_location.options[document.forms['expl'].expl_location.selectedIndex].value); </script>";
// zone du dernier emrunteur
$last_pret = "";
if ($pmb_expl_show_lastempr && $obj->expl_lastempr) {
$lastempr = new emprunteur($obj->expl_lastempr, '', FALSE, 0);
$last_pret = "<hr /><div class='row'><b>{$msg['expl_lastempr']} </b>";
$link = "<a href='./circ.php?categ=pret&form_cb=" . rawurlencode($lastempr->cb) . "'>";
$last_pret .= $link . $lastempr->prenom . ' ' . $lastempr->nom . ' (' . $lastempr->cb . ')</a>';
$last_pret .= "</div>";
}
// zone de l'emprunteur
$query = "select empr_cb, empr_nom, empr_prenom, ";
$query .= " date_format(pret_date, '" . $msg["format_date"] . "') as aff_pret_date, ";
$query .= " date_format(pret_retour, '" . $msg["format_date"] . "') as aff_pret_retour, ";
$query .= " IF(pret_retour>sysdate(),0,1) as retard ";
$query .= " from pret, empr where pret_idexpl='" . $obj->expl_id . "' and pret_idempr=id_empr ";
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result)) {
$pret = pmb_mysql_fetch_object($result);
$last_pret .= "<hr /><div class='row'><b>{$msg['380']}</b> ";
$link = "<a href='./circ.php?categ=pret&form_cb=" . rawurlencode($pret->empr_cb) . "'>";
$last_pret .= $link . $pret->empr_prenom . ' ' . $pret->empr_nom . ' (' . $pret->empr_cb . ')</a>';
$last_pret .= " {$msg[381]} " . $pret->aff_pret_date;
$last_pret .= ". {$msg[358]} " . $pret->aff_pret_retour . ".";
$last_pret .= "</div>";
}
return $bul_expl_form . $last_pret;
}
