function get_info_expl_old($cb_expl)
{
    global $dbh, $msg;
    if ($cb_expl) {
        $query = "select * from exemplaires  left join docs_type on exemplaires.expl_typdoc=docs_type.idtyp_doc where expl_cb='{$cb_expl}' ";
        $result = pmb_mysql_query($query, $dbh);
        if ($r = pmb_mysql_fetch_array($result)) {
            $info_expl->error_message = "";
            // empr ok
            $info_expl->id_expl = $r['expl_id'];
            $info_expl->cb_expl = $r['expl_cb'];
            $info_expl->tdoc_libelle = $r['tdoc_libelle'];
            $info_expl->expl_notice = $r['expl_notice'];
            if ($info_expl->expl_notice) {
                $notice = new mono_display($info_expl->expl_notice, 0);
                $info_expl->libelle = $notice->header;
            } else {
                $bulletin = new bulletinage_display($r['expl_bulletin']);
                $info_expl->libelle = $bulletin->display;
                $info_expl->expl_notice = $r['expl_bulletin'];
            }
            $pos = strpos($info_expl->libelle, '<a');
            if ($pos) {
                $info_expl->libelle = substr($info_expl->libelle, 0, strpos($info_expl->libelle, '<a'));
            }
        } else {
            $info_expl->error_message = $msg[367];
        }
    } else {
        $info_expl->error_message = $msg[367];
    }
    return $info_expl;
}

function _get_footer_($output_params)
{
    $export = new synchro_rdf(session_id());
    $contenuRdf = $export->exportStoreXml();
    //Suppression des tables temporaires
    $res = pmb_mysql_query("SHOW TABLES LIKE '" . session_id() . "%'");
    while ($row = pmb_mysql_fetch_array($res)) {
        pmb_mysql_query("DROP TABLE " . $row[0]);
    }
    return $contenuRdf;
}

 function get_values($id)
 {
     //Récupération des valeurs stockées
     if (!$this->no_special_fields && $id) {
         $this->values = array();
         $requete = "select " . $this->prefix . "_custom_champ," . $this->prefix . "_custom_origine," . $this->prefix . "_custom_small_text, " . $this->prefix . "_custom_text, " . $this->prefix . "_custom_integer, " . $this->prefix . "_custom_date, " . $this->prefix . "_custom_float from " . $this->prefix . "_custom_values where " . $this->prefix . "_custom_origine=" . $id;
         $resultat = pmb_mysql_query($requete);
         while ($r = pmb_mysql_fetch_array($resultat)) {
             $this->values[$r[$this->prefix . "_custom_champ"]][] = $r[$this->prefix . "_custom_" . $this->t_fields[$r[$this->prefix . "_custom_champ"]]["DATATYPE"]];
         }
     } else {
         $this->values = array();
     }
 }

 function addTaskCron($id)
 {
     global $dbh;
     $requete = "select id_planificateur, num_type_tache, libelle_tache, desc_tache, calc_next_date_deb, calc_next_heure_deb \n\t\t\tfrom planificateur \n\t\t\twhere statut='1' \n\t\t\tand id_planificateur= '" . $id . "'";
     $res = pmb_mysql_query($requete, $dbh);
     while ($row = pmb_mysql_fetch_array($res)) {
         $oldCrontab = array();
         /* récupère les informations de l'ancien crontab */
         $newCrontab = array();
         /* ajoute le nouveau crontab */
         exec('crontab -l', $oldCrontab);
         /* on récupère l'ancienne crontab dans $oldCrontab */
         $calc_next_date_deb = explode("-", $row["calc_next_date_deb"]);
         $calc_next_heure_deb = explode(":", $row["calc_next_heure_deb"]);
         $ident = "pmb_" . $row["id_planificateur"] . "." . $row["num_type_tache"];
         if ($row["desc_tache"] != '') {
             $comment = $row["desc_tache"];
         } else {
             $comment = ' Aucun commentaire';
         }
         $chpCommande = "/rep/le fichier php";
         $trouve = false;
         //on vérifie si cette tâche est déjà dans le cron
         foreach ($oldCrontab as $index => $ligne) {
             if (preg_match("/^# " . $ident . "/", $oldCrontab[$index], $matches, PREG_OFFSET_CAPTURE) == "1") {
                 $oldCrontab[$index] = "# " . $ident . " : " . $comment;
                 $oldCrontab[$index + 1] = $calc_next_heure_deb[0] . ' ' . $calc_next_heure_deb[1] . ' ' . $calc_next_date_deb[2] . ' ' . $calc_next_date_deb[1] . ' * ' . $chpCommande;
                 $trouve = true;
             }
             $newCrontab[] = $oldCrontab[$index];
         }
         //si la tâche n'est pas trouvée, on l'ajoute
         if (!$trouve) {
             $newCrontab[] = "# " . $ident . " : " . $comment;
             $newCrontab[] = $calc_next_heure_deb[0] . ' ' . $calc_next_heure_deb[1] . ' ' . $calc_next_date_deb[2] . ' ' . $calc_next_date_deb[1] . ' * ' . $chpCommande;
         }
         $f = fopen('/var/spool/cron/apache', 'w');
         /* on crée le fichier s'il n'existe pas */
         fwrite($f, implode(chr(10), $newCrontab));
         fclose($f);
         exec('crontab /var/spool/cron/apache');
         /* on le soumet comme crontab */
     }
 }

function create_expl($f_ex_cb, $id, $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 = '')
{
    global $dbh;
    $new_expl = 0;
    $expl_retour = 0;
    $requete = "SELECT expl_id FROM exemplaires WHERE expl_cb='{$f_ex_cb}' ";
    $res = pmb_mysql_query($requete, $dbh);
    $nbr_lignes = @pmb_mysql_num_rows($res);
    if ($nbr_lignes) {
        $valid_requete = 0;
        $lu = pmb_mysql_fetch_array($res);
        $expl_retour = $lu['expl_id'];
    } else {
        $valid_requete = 1;
    }
    if ($valid_requete) {
        $requete = 'INSERT INTO exemplaires SET create_date=sysdate(), ';
        $requete .= "expl_cb='{$f_ex_cb}'";
        $requete .= ", expl_notice={$id}";
        $requete .= ", expl_typdoc={$f_ex_typdoc}";
        $requete .= ", expl_cote='{$f_ex_cote}'";
        $requete .= ", expl_section={$f_ex_section}";
        $requete .= ", expl_statut={$f_ex_statut}";
        $requete .= ", expl_location={$f_ex_location}";
        $requete .= ", expl_codestat={$f_ex_cstat}";
        $requete .= ", expl_note='" . ${f_ex_note} . "'";
        $requete .= ", expl_comment='" . ${f_ex_comment} . "'";
        $requete .= ", expl_prix='{$f_ex_prix}'";
        $requete .= ", expl_owner='{$f_ex_owner}'";
        $result = pmb_mysql_query($requete, $dbh);
        $expl_retour = pmb_mysql_insert_id();
        audit::insert_creation(AUDIT_EXPL, $expl_retour);
        $new_expl = 1;
    }
    $retour = array($new_expl, $expl_retour);
    return $retour;
}

/**
 * Récupère les infos du document numérique
 */
function recup_explnum_infos($id_explnum)
{
    global $infos_explnum, $dbh;
    $rqt_explnum = "SELECT explnum_id, explnum_notice, explnum_bulletin, IF(location_libelle IS null, '', location_libelle) AS location_libelle, explnum_nom, explnum_mimetype, explnum_url, explnum_extfichier, IF(explnum_nomfichier IS null, '', explnum_nomfichier) AS nomfichier, explnum_path, IF(rep.repertoire_nom IS null, '', rep.repertoire_nom) AS nomrepertoire\n\t\tfrom explnum ex_n\n\t\tLEFT JOIN explnum_location ex_l ON ex_n.explnum_id= ex_l.num_explnum\n\t\tLEFT JOIN docs_location dl ON ex_l.num_location= dl.idlocation\n\t\tLEFT JOIN upload_repertoire rep ON ex_n.explnum_repertoire= rep.repertoire_id\n\t\twhere explnum_id='" . $id_explnum . "'";
    $res_explnum = pmb_mysql_query($rqt_explnum, $dbh);
    while ($explnum = pmb_mysql_fetch_array($res_explnum, MYSQL_ASSOC)) {
        $infos_explnum[] = $explnum;
    }
}

function explnum_test_rights_per_id($id_explnum)
{
    global $gestion_acces_active, $gestion_acces_empr_docnum;
    //droits d'acces emprunteur/document numérique
    if ($gestion_acces_active == 1 && $gestion_acces_empr_docnum == 1) {
        $ac = new acces();
        $dom_3 = $ac->setDomain(3);
        $rights = $dom_3->getRights($_SESSION['id_empr_session'], $id_explnum);
    }
    //Accessibilité du document numérique aux abonnés en opac
    $req_restriction_abo = "SELECT explnum_visible_opac, explnum_visible_opac_abon FROM explnum,explnum_statut WHERE explnum_id='" . $id_explnum . "' AND explnum_docnum_statut=id_explnum_statut ";
    $result = pmb_mysql_query($req_restriction_abo);
    if ($result && pmb_mysql_num_rows($result)) {
        $expl_num = pmb_mysql_fetch_array($result, MYSQL_ASSOC);
        if ($rights & 16 || is_null($dom_3) && $expl_num["explnum_visible_opac"] && (!$expl_num["explnum_visible_opac_abon"] || $expl_num["explnum_visible_opac_abon"] && $_SESSION["user_code"])) {
            return true;
        }
    }
    return false;
}

 function show_consultation_form()
 {
     global $form_consult_action, $form_see_docnum, $msg, $charset, $pmb_gestion_devise, $dbh, $pmb_type_audit;
     $form_consult_action = str_replace('!!form_title!!', htmlentities($this->sujet_action, ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!idstatut!!', htmlentities($this->statut_action, ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!type_action!!', htmlentities($this->workflow->getTypeCommentById($this->type_action), ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!statut_action!!', htmlentities($this->workflow->getStateCommentById($this->statut_action), ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!detail_action!!', htmlentities($this->detail_action, ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!date_action!!', htmlentities(formatdate($this->date_action), ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!date_butoir_action!!', htmlentities(formatdate($this->deadline_action), ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!time_action!!', htmlentities($this->time_elapsed . $msg['demandes_action_time_unit'], ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!cout_action!!', htmlentities($this->cout, ENT_QUOTES, $charset) . $pmb_gestion_devise, $form_consult_action);
     $form_consult_action = str_replace('!!progression_action!!', htmlentities($this->progression_action, ENT_QUOTES, $charset) . '%', $form_consult_action);
     $form_consult_action = str_replace('!!idaction!!', htmlentities($this->id_action, ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!iddemande!!', htmlentities($this->num_demande, ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!createur!!', htmlentities($this->getCreateur($this->actions_num_user, $this->actions_type_user), ENT_QUOTES, $charset), $form_consult_action);
     $form_consult_action = str_replace('!!prive_action!!', htmlentities($this->prive_action ? $msg[40] : $msg[39], ENT_QUOTES, $charset), $form_consult_action);
     $path = "<a href=./demandes.php?categ=gestion&act=see_dmde&iddemande={$this->num_demande}>" . htmlentities($this->libelle_demande, ENT_QUOTES, $charset) . "</a>";
     $form_consult_action = str_replace('!!path!!', $path, $form_consult_action);
     $act_cancel = "document.location='./demandes.php?categ=gestion&act=see_dmde&iddemande={$this->num_demande}'";
     $form_consult_action = str_replace('!!cancel_action!!', $act_cancel, $form_consult_action);
     $states_btn = $this->getDisplayStateBtn($this->workflow->getStateList($this->statut_action));
     $form_consult_action = str_replace('!!btn_etat!!', $states_btn, $form_consult_action);
     // bouton audit
     if ($pmb_type_audit) {
         $btn_audit = "&nbsp;<input class='bouton' type='button' onClick=\"openPopUp('./audit.php?type_obj=15&object_id={$this->id_action}', 'audit_popup', 700, 500, -2, -2, 'scrollbars=yes, toolbar=no, dependent=yes, resizable=yes')\" title=\"" . $msg['audit_button'] . "\" value=\"" . $msg['audit_button'] . "\" />&nbsp;";
     } else {
         $btn_audit = "";
     }
     $form_consult_action = str_replace('!!btn_audit!!', $btn_audit, $form_consult_action);
     print $form_consult_action;
     //Notes
     print demandes_notes::show_dialog($this->notes, $this->id_action, $this->num_demande);
     //Documents Numériques
     $req = "select * from explnum_doc join explnum_doc_actions on num_explnum_doc=id_explnum_doc \n\t\twhere num_action='" . $this->id_action . "'";
     $res = pmb_mysql_query($req, $dbh);
     if (pmb_mysql_num_rows($res)) {
         $tab_docnum = array();
         while ($docnums = pmb_mysql_fetch_array($res)) {
             $tab_docnum[] = $docnums;
         }
         $explnum_doc = new explnum_doc();
         $liste_docnum = $explnum_doc->show_docnum_table($tab_docnum, './demandes.php?categ=action&act=modif_docnum&idaction=' . $this->id_action);
         $form_see_docnum = str_replace('!!list_docnum!!', $liste_docnum, $form_see_docnum);
     } else {
         $form_see_docnum = str_replace('!!list_docnum!!', htmlentities($msg['demandes_action_no_docnum'], ENT_QUOTES, $charset), $form_see_docnum);
     }
     $form_see_docnum = str_replace('!!idaction!!', $this->id_action, $form_see_docnum);
     print $form_see_docnum;
     // Annulation de l'alerte sur l'action en cours après lecture des nouvelles notes si c'est la personne à laquelle est affectée l'action qui la lit
     $this->actions_read_gestion = demandes_actions::action_read($this->id_action, true, "_gestion");
     // Mise à jour de la demande dont est issue l'action
     demandes_actions::action_majParentEnfant($this->id_action, $this->num_demande, "_gestion");
 }

<?php

// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net [email protected] et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: log.inc.php,v 1.1.2.1 2015-08-13 07:30:45 jpermanne Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
    die("no access");
}
global $log, $infos_notice, $infos_expl;
$rqt = " select empr_prof,empr_cp, empr_ville as ville, empr_year, empr_sexe, empr_login,  empr_date_adhesion, empr_date_expiration, count(pret_idexpl) as nbprets, count(resa.id_resa) as nbresa, code.libelle as codestat, es.statut_libelle as statut, categ.libelle as categ, gr.libelle_groupe as groupe,dl.location_libelle as location\n\t\t\tfrom empr e\n\t\t\tleft join empr_codestat code on code.idcode=e.empr_codestat\n\t\t\tleft join empr_statut es on e.empr_statut=es.idstatut\n\t\t\tleft join empr_categ categ on categ.id_categ_empr=e.empr_categ\n\t\t\tleft join empr_groupe eg on eg.empr_id=e.id_empr\n\t\t\tleft join groupe gr on eg.groupe_id=gr.id_groupe\n\t\t\tleft join docs_location dl on e.empr_location=dl.idlocation\n\t\t\tleft join resa on e.id_empr=resa_idempr\n\t\t\tleft join pret on e.id_empr=pret_idempr\n\t\t\twhere e.empr_login='" . addslashes($login) . "'\n\t\t\tgroup by resa_idempr, pret_idempr";
$res = pmb_mysql_query($rqt);
if ($res) {
    $empr_carac = pmb_mysql_fetch_array($res);
    $log->add_log('empr', $empr_carac);
}
$log->add_log('num_session', session_id());
$log->save();

function resa_ranger_list()
{
    global $base_path, $dbh;
    global $msg;
    global $current_module;
    global $begin_result_liste;
    global $end_result_liste;
    global $deflt_docs_location;
    global $pmb_lecteurs_localises;
    global $f_loc;
    $aff_final = "";
    if ($pmb_lecteurs_localises) {
        if ($f_loc == "") {
            $f_loc = $deflt_docs_location;
        }
        if ($f_loc) {
            $sql_expl_loc = " where expl_location='" . $f_loc . "' ";
        }
    }
    if ($pmb_lecteurs_localises) {
        //la liste de sélection de la localisation
        $aff_final .= "<form class='form-{$current_module}' name='check_docranger' action='" . $base_path . "/circ.php?categ=listeresa&sub=docranger' method='post'>";
        $aff_final .= "<br />" . $msg["transferts_circ_resa_lib_localisation"];
        $aff_final .= "<select name='f_loc' onchange='document.check_docranger.submit();'>";
        $res = pmb_mysql_query("SELECT idlocation, location_libelle FROM docs_location order by location_libelle");
        $aff_final .= "<option value='0'>" . $msg["all_location"] . "</option>";
        //on parcours la liste des options
        while ($value = pmb_mysql_fetch_array($res)) {
            //debut de l'option
            $aff_final .= "<option value='" . $value[0] . "'";
            if ($value[0] == $f_loc) {
                $aff_final .= " selected";
            }
            //c'est l'option par défaut
            $aff_final .= ">" . $value[1] . "</option>";
        }
        $aff_final .= "</select></form>";
    }
    $sql = "SELECT resa_cb, expl_id from resa_ranger left join exemplaires on resa_cb=expl_cb " . $sql_expl_loc;
    $res = pmb_mysql_query($sql, $dbh);
    while ($ranger = pmb_mysql_fetch_object($res)) {
        if ($ranger->expl_id) {
            if ($stuff = get_expl_info($ranger->expl_id)) {
                $stuff = check_pret($stuff);
                $aff_final .= print_info($stuff, 0, 0, 0);
            } else {
                $aff_final .= "<strong>" . $ranger->resa_cb . "&nbsp;: {$msg[395]}</strong><br>";
            }
        } else {
            $aff_final .= "<strong>" . $ranger->resa_cb . "&nbsp;: {$msg[395]}</strong><br>";
        }
    }
    if ($aff_final) {
        return $begin_result_liste . $aff_final . $end_result_liste;
    } else {
        return $msg['resa_liste_docranger_nodoc'];
    }
}

            break;
        default:
            break;
    }
    $i++;
}
//visibilité des exemplaires
if ($pmb_droits_explr_localises) {
    $explr_tab_invis = explode(",", $explr_invisible);
    $explr_tab_unmod = explode(",", $explr_visible_unmod);
    $explr_tab_modif = explode(",", $explr_visible_mod);
    $visibilite_expl_user = "\n\t\t<div class='row'><hr /></div>\n\t\t<div class='row'>\n\t\t\t<div class='colonne3'>" . $msg["expl_visibilite"] . "&nbsp;:&nbsp;</div>\n\t\t\t<div class='colonne_suite'>&nbsp;</div>\n\t\t</div>\n";
    $requete_droits_expl = "select idlocation, location_libelle from docs_location order by location_libelle";
    $resultat_droits_expl = pmb_mysql_query($requete_droits_expl);
    $temp = "";
    while ($j = pmb_mysql_fetch_array($resultat_droits_expl)) {
        $temp .= $j["idlocation"] . ",";
        $visibilite_expl_user .= "\n\t\t\t<div class='row'>\n\t\t\t\t<div class='colonne3' align='right'>" . $j["location_libelle"] . " : </div>\n\t\t\t\t<div class='colonne_suite'>&nbsp;<select name=\"form_expl_visibilite_" . $j["idlocation"] . "\">\n\t\t\t";
        $as_invis = array_search($j["idlocation"], $explr_tab_invis);
        $as_unmod = array_search($j["idlocation"], $explr_tab_unmod);
        $as_mod = array_search($j["idlocation"], $explr_tab_modif);
        $visibilite_expl_user .= "\n<option value='explr_invisible' " . ($as_invis !== FALSE && $as_invis !== NULL ? "selected='selected' " : "") . ">" . $msg["explr_invisible"] . "</option>";
        if ($as_mod !== FALSE && $as_mod !== NULL || $as_unmod !== FALSE && $as_unmod !== NULL || $as_invis !== FALSE && $as_invis !== NULL) {
            $visibilite_expl_user .= "\n<option value='explr_visible_unmod' " . ($as_unmod !== FALSE && $as_unmod !== NULL ? "selected='selected' " : "") . ">" . $msg["explr_visible_unmod"] . "</option>";
        } else {
            $visibilite_expl_user .= "\n<option value='explr_visible_unmod' selected='selected' >" . $msg["explr_visible_unmod"] . "</option>";
        }
        $visibilite_expl_user .= "\n<option value='explr_visible_mod' " . ($as_mod !== FALSE && $as_mod !== NULL ? "selected='selected' " : "") . ">" . $msg["explr_visible_mod"] . "</option>";
        $visibilite_expl_user .= "</select></div></div>\n";
    }
    pmb_mysql_free_result($resultat_droits_expl);

//.........这里部分代码省略.........
             //la table pour les recherche exacte
             $req_del = "delete from cms_editorial_fields_global_index where num_obj='" . $this->id . "' and type = '" . $this->type . "'";
             pmb_mysql_query($req_del, $dbh);
         } else {
             foreach ($tab_code_champ as $subfields) {
                 foreach ($subfields as $subfield) {
                     $req_del = "delete from cms_editorial_words_global_index where num_obj='" . $this->id . "' and type = '" . $this->type . "' and code_champ='" . $subfield['champ'] . "'";
                     pmb_mysql_query($req_del, $dbh);
                     //la table pour les recherche exacte
                     $req_del = "delete from cms_editorial_fields_global_index where num_obj='" . $this->id . "' and type = '" . $this->type . "' and code_champ='" . $subfield['champ'] . "'";
                     pmb_mysql_query($req_del, $dbh);
                     break;
                 }
             }
             //Les champs perso
             if (count($tab_pp)) {
                 foreach ($tab_pp as $id) {
                     $req_del = "delete from cms_editorial_words_global_index where num_obj='" . $this->id . "' and type = '" . $this->type . "' and code_champ='" . $id . "' ";
                     pmb_mysql_query($req_del, $dbh);
                     //la table pour les recherche exacte
                     $req_del = "delete from cms_editorial_fields_global_index where num_obj='" . $this->id . "' and type = '" . $this->type . "' and code_champ='" . $id . "' ";
                     pmb_mysql_query($req_del, $dbh);
                 }
             }
         }
         //qu'est-ce qu'on met a jour ?
         $tab_insert = array();
         $tab_field_insert = array();
         foreach ($tab_req as $k => $v) {
             $r = pmb_mysql_query($v["rqt"], $dbh);
             $tab_mots = array();
             $tab_fields = array();
             if (pmb_mysql_num_rows($r)) {
                 while ($tab_row = pmb_mysql_fetch_array($r, MYSQL_ASSOC)) {
                     if (isset($tab_row[$tab_languages[$k]])) {
                         $lang = $tab_row[$tab_languages[$k]];
                         unset($tab_row[$tab_languages[$k]]);
                     } else {
                         $lang = "";
                     }
                     foreach ($tab_row as $nom_champ => $liste_mots) {
                         if ($tab_code_champ[$k][$nom_champ]['marctype']) {
                             $marclist = new marc_list($tab_code_champ[$k][$nom_champ]['marctype']);
                             $liste_mots = $marclist->table[$liste_mots];
                         }
                         if ($liste_mots != '') {
                             $liste_mots = strip_tags($liste_mots);
                             $tab_tmp = array();
                             if (!in_array($k, $tab_keep_empty)) {
                                 $tab_tmp = explode(' ', strip_empty_words($liste_mots));
                             } else {
                                 $tab_tmp = explode(' ', strip_empty_chars(clean_string($liste_mots)));
                             }
                             //	if($lang!="") $tab_tmp[]=$lang;
                             //la table pour les recherche exacte
                             if (!$tab_fields[$nom_champ]) {
                                 $tab_fields[$nom_champ] = array();
                             }
                             $tab_fields[$nom_champ][] = array('value' => trim($liste_mots), 'lang' => $lang);
                             if (!$tab_code_champ[$k][$nom_champ]['no_words']) {
                                 foreach ($tab_tmp as $mot) {
                                     if (trim($mot)) {
                                         $tab_mots[$nom_champ][$mot] = $lang;
                                     }
                                 }
                             }

/**
 * Récupère les infos de la notice
 */
function recup_notice_infos($id_notice)
{
    global $infos_notice, $infos_expl;
    $rqt = "select notice_id, typdoc, niveau_biblio, index_l, libelle_categorie, name_pclass, indexint_name \n\t\tfrom notices n \n\t\tleft join notices_categories nc on nc.notcateg_notice=n.notice_id \n\t\tleft join categories c on nc.num_noeud=c.num_noeud \n\t\tleft join indexint i on n.indexint=i.indexint_id \n\t\tleft join pclassement pc on i.num_pclass=pc.id_pclass\n\t\twhere notice_id='" . $id_notice . "'";
    $res_noti = pmb_mysql_query($rqt);
    while ($noti = pmb_mysql_fetch_array($res_noti)) {
        $infos_notice = $noti;
        $rqt_expl = " select section_libelle, location_libelle, statut_libelle, codestat_libelle, expl_date_depot, expl_date_retour, tdoc_libelle \n\t\t\t\t\tfrom exemplaires e\n\t\t\t\t\tleft join docs_codestat co on e.expl_codestat = co.idcode\n\t\t\t\t\tleft join docs_location dl on e.expl_location=dl.idlocation\n\t\t\t\t\tleft join docs_section ds on ds.idsection=e.expl_section\n\t\t\t\t\tleft join docs_statut dst on e.expl_statut=dst.idstatut \n\t\t\t\t\tleft join docs_type dt on dt.idtyp_doc=e.expl_typdoc\n\t\t\t\t\twhere expl_notice='" . $id_notice . "'";
        $res_expl = pmb_mysql_query($rqt_expl);
        while ($expl = pmb_mysql_fetch_array($res_expl)) {
            $infos_expl[] = $expl;
        }
    }
}

function import_profs($separateur, $dbh, $type_import)
{
    //La structure du fichier texte doit être la suivante :
    //nom, prénom (le cb est généré automatiquement)
    $prof = array("Numéro auto", "Nom", "Prénom");
    $date_auj = date("Y-m-d", time());
    $date_an_proch = date("Y-m-d", time() + 3600 * 24 * 30.42 * 12);
    //Upload du fichier
    if (!$_FILES['import_lec']['tmp_name']) {
        print "Cliquez sur Précédent et choisissez un fichier";
    } elseif (!move_uploaded_file($_FILES['import_lec']['tmp_name'], "./temp/" . basename($_FILES['import_lec']['tmp_name']))) {
        print "Le fichier n'a pas pu être téléchargé. Voici plus d'informations :<br />";
        print_r($_FILES) . "<p>";
    }
    $fichier = @fopen("./temp/" . basename($_FILES['import_lec']['tmp_name']), "r");
    if ($fichier) {
        if ($type_import == 'maj_complete') {
            //Vide la table empr_groupe
            pmb_mysql_query("DELETE FROM empr_groupe", $dbh);
            echo $type_import;
            //Supprime les profs qui n'ont pas de prêts en cours
            $req_select_verif_pret = "SELECT id_empr FROM empr left join pret on id_empr=pret_idempr WHERE pret_idempr is null and empr_cb NOT LIKE 'P%'";
            $select_verif_pret = pmb_mysql_query($req_select_verif_pret, $dbh);
            while ($verif_pret = pmb_mysql_fetch_array($select_verif_pret)) {
                //pour tous les emprunteurs qui n'ont pas de pret en cours
                emprunteur::del_empr($verif_pret["id_empr"]);
            }
        }
        //Récupération dans la table 'empr' du 'empr_cb' maximum
        $req = pmb_mysql_query("SELECT MAX(empr_cb) AS cbmax FROM empr WHERE empr_categ=2 and empr_codestat=1", $dbh);
        $cb = pmb_mysql_result($req, 0, "cbmax");
        if (!$cb) {
            $numeroP = "000";
        } else {
            $numeroP = substr($cb, 1, 3);
        }
        while (!feof($fichier)) {
            $buffer = fgets($fichier, 4096);
            $buffer = pmb_mysql_escape_string($buffer);
            $tab = explode($separateur, $buffer);
            $buf_prenom = explode("\\", $tab[1]);
            $prenom = $buf_prenom[0];
            // Traitement du prof
            $select = pmb_mysql_query("SELECT id_empr FROM empr WHERE empr_nom = '" . $tab[0] . "' AND empr_prenom = '" . $prenom . "'", $dbh);
            $nb_enreg = pmb_mysql_num_rows($select);
            if (!$tab[0] || $tab[0] == "") {
                print "<b> Professeur non pris en compte car \"Nom\" non renseigné : </b><br />";
                for ($i = 1; $i < 3; $i++) {
                    print $prof[$i] . " : " . $tab[$i - 1] . ", ";
                }
                print "<br />";
                $nb_enreg = 2;
            }
            //Gestion du sexe
            switch ($tab[8][0]) {
                case M:
                    $sexe = 1;
                    break;
                case F:
                    $sexe = 2;
                    break;
                default:
                    $sexe = 0;
                    break;
            }
            //Génération du code-barre
            $numeroP = $numeroP + 1;
            if ($numeroP < 10) {
                $prof_cb = "P00" . $numeroP;
            } elseif ($numeroP < 100) {
                $prof_cb = "P0" . $numeroP;
            } elseif ($numeroP < 1000) {
                $prof_cb = "P" . $numeroP;
            }
            //Génération du login
            $login = cre_login($tab[0], $prenom, $dbh);
            //Pour l'instant login = mdp car lors de l'import des profs, aucune date de naissance n'est fournie
            switch ($nb_enreg) {
                case 0:
                    //Ce prof n'est pas enregistré
                    $req_insert = "INSERT INTO empr(empr_cb, empr_nom, empr_prenom, empr_adr1, empr_adr2, empr_cp, empr_ville, ";
                    $req_insert .= "empr_mail, empr_tel1, empr_year, empr_categ, empr_codestat, empr_creation, empr_sexe,  ";
                    $req_insert .= "empr_login, empr_password, empr_date_adhesion, empr_date_expiration) ";
                    $req_insert .= "VALUES ('{$prof_cb}','{$tab['0']}','{$prenom}', '{$tab['2']}', '{$tab['3']}', '{$tab['4']}', '{$tab['5']}', '{$tab['9']}', '{$tab['6']}', '{$tab['7']}', ";
                    $req_insert .= "2, 1, '{$date_auj}', {$sexe}, '{$login}', replace(replace('" . $tab[7] . "','\n',''),'\r',''), '{$date_auj}', '{$date_an_proch}' )";
                    $insert = pmb_mysql_query($req_insert, $dbh);
                    if (!$insert) {
                        print "<b>Echec de la création du professeur suivant (Erreur : " . pmb_mysql_error() . ") : </b><br />";
                        for ($i = 1; $i < 3; $i++) {
                            print $prof[$i] . " : " . $tab[$i - 1] . ", ";
                        }
                        print "<br />";
                    } else {
                        emprunteur::update_digest($login, str_replace(array("\n", "\r"), "", $tab[7]));
                        emprunteur::hash_password($login, str_replace(array("\n", "\r"), "", $tab[7]));
                        $cpt_insert++;
                    }
                    $j++;
                    break;
                case 1:
//.........这里部分代码省略.........

 static function getRelancesBySupplier($id_fou = 0)
 {
     global $dbh, $msg;
     $tab = array();
     if ($id_fou) {
         $q = "select id_acte, type_acte, date_format(date_acte, '" . $msg["format_date"] . "') as date_acte, numero as numero, ";
         $q .= "num_ligne, date_format(date_relance, '" . $msg["format_date"] . "') as date_rel , type_ligne, num_acquisition, num_rubrique, num_produit, num_type, ";
         $q .= "libelle, code, prix, tva, nb, lignes_actes_relances.statut as statut, remise, debit_tva, commentaires_gestion, commentaires_opac ";
         $q .= "from actes join lignes_actes_relances on num_acte=id_acte where num_fournisseur ='" . $id_fou . "' ";
         $q .= "order by date_relance desc, num_acte ";
         $r = pmb_mysql_query($q, $dbh);
         if (pmb_mysql_num_rows($r)) {
             while ($row = pmb_mysql_fetch_array($r, MYSQL_ASSOC)) {
                 $tab[] = $row;
             }
         }
     }
     return $tab;
 }

function aff_pret_groupes()
{
    global $msg, $id_empr, $lvl, $dbh;
    global $opac_pret_prolongation, $opac_pret_duree_prolongation, $allow_prol;
    global $dest, $worksheet, $line;
    global $heading_blue, $heading_10, $heading_12;
    $req_groupes = "SELECT * from groupe where resp_groupe={$id_empr} order by libelle_groupe";
    $res = pmb_mysql_query($req_groupes);
    while ($r_goupe = pmb_mysql_fetch_object($res)) {
        if ($lvl == "late") {
            $titre_goup = sprintf($msg['empr_group_late'], $r_goupe->libelle_groupe);
            $class_aff_expl = "class='liste-expl-empr-late'";
            $critere_requete = " AND pret_retour < '" . date('Y-m-d') . "' ORDER BY location_libelle, empr_nom, empr_prenom, pret_retour";
        } else {
            $titre_goup = sprintf($msg['empr_group_loans'], $r_goupe->libelle_groupe);
            $class_aff_expl = "class='liste-expl-empr-all'";
            $critere_requete = " ORDER BY location_libelle, empr_nom, empr_prenom, pret_retour";
        }
        $sql = "SELECT notices_m.notice_id as num_notice_mono, bulletin_id, IF(pret_retour>sysdate(),0,1) as retard, expl_id, empr.id_empr as emprunteur, ";
        $sql .= "date_format(pret_retour, '" . $msg["format_date_sql"] . "') as aff_pret_retour, pret_retour, ";
        $sql .= "date_format(pret_date, '" . $msg["format_date_sql"] . "') as aff_pret_date, ";
        $sql .= "trim(concat(ifnull(notices_m.tit1,''),ifnull(notices_s.tit1,''),' ',ifnull(bulletin_numero,''), if(mention_date, concat(' (',mention_date,')') ,if (date_date, concat(' (',date_format(date_date, '" . $msg["format_date_sql"] . "'),')') ,'')))) as tit, if(notices_m.notice_id, notices_m.notice_id, notices_s.notice_id) as not_id, tdoc_libelle, location_libelle ";
        $sql .= "FROM (((exemplaires LEFT JOIN notices AS notices_m ON expl_notice = notices_m.notice_id ) ";
        $sql .= "        LEFT JOIN bulletins ON expl_bulletin = bulletins.bulletin_id) ";
        $sql .= "        LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id), ";
        $sql .= "        docs_type, docs_location , pret, empr,empr_groupe  ";
        $sql .= "WHERE expl_typdoc = idtyp_doc and pret_idexpl = expl_id  and empr.id_empr = pret.pret_idempr and empr_groupe.empr_id = empr.id_empr and expl_location = idlocation and groupe_id=" . $r_goupe->id_groupe;
        $sql .= $critere_requete;
        $req = pmb_mysql_query($sql) or die("Erreur SQL !<br />" . $sql . "<br />" . pmb_mysql_error());
        $nb_elements = pmb_mysql_num_rows($req);
        if ($nb_elements) {
            if (!$dest) {
                echo "<br>";
                echo "<h3><span>" . $titre_goup . "</span></h3>";
                echo "<table {$class_aff_expl} width='100%'>";
                echo "<tr>";
                if ($lvl != "late") {
                    echo "<th><center>" . $msg["empr_late"] . "</center></th>";
                }
                echo " <th>" . $msg["extexpl_emprunteur"] . "</th>\n\t\t\t\t\t  <th>" . $msg["title"] . "</th>\t\t\t\t\t\n\t\t\t\t\t  <th>" . $msg["typdoc_support"] . "</th>\t\t\t\t\t \n\t\t\t\t\t  <th><center>" . $msg["date_loan"] . "</center></th>\n\t\t\t\t\t  <th><center>" . $msg["date_back"] . "</center></th>";
                echo "</tr>";
                $odd_even = 1;
                $loc_cours = "";
                while ($data = pmb_mysql_fetch_array($req)) {
                    if ($loc_cours != $data['location_libelle']) {
                        $loc_cours = $data['location_libelle'];
                        echo "<tr class='tb_pret_location_row'>\n\t\t\t\t\t\t\t\t<td colspan='" . ($lvl != "late" ? "6" : "5") . "'>" . $msg["expl_header_location_libelle"] . " : " . $loc_cours . "</td>\n\t\t\t\t\t\t\t</tr>";
                    }
                    $id_expl = $data['expl_cb'];
                    // on affiche les résultats
                    if ($odd_even == 0) {
                        $pair_impair = "odd";
                        $odd_even = 1;
                    } else {
                        if ($odd_even == 1) {
                            $pair_impair = "even";
                            $odd_even = 0;
                        }
                    }
                    if ($data['num_notice_mono']) {
                        $tr_javascript = " class='{$pair_impair}' onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./index.php?lvl=notice_display&id=" . $data['num_notice_mono'] . "&seule=1';\" style='cursor: pointer' ";
                    } else {
                        $tr_javascript = " class='{$pair_impair}' onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./index.php?lvl=bulletin_display&id=" . $data['bulletin_id'] . "';\" style='cursor: pointer' ";
                    }
                    $deb_ligne = "<tr {$tr_javascript}>";
                    echo $deb_ligne;
                    /* test de date de retour dépassée */
                    if ($lvl != "late") {
                        if ($data['retard']) {
                            echo "<td class='expl-empr-retard'><center><b>&times;</b></center></td>";
                        } else {
                            echo "<td>&nbsp;</td>";
                        }
                    }
                    $empr = get_info_empr($data['emprunteur']);
                    echo "<td>" . $empr['nom'] . " " . $empr['prenom'] . "</td>";
                    echo "<td>" . $data['tit'] . "</td>";
                    echo "<td>" . $data["tdoc_libelle"] . "</td>";
                    echo "<td><center>" . $data['aff_pret_date'] . "</center></td>";
                    if ($data['retard']) {
                        echo "<td class='expl-empr-retard'><center>" . $data['aff_pret_retour'] . "</center></td>";
                    } else {
                        echo "<td><center>" . $data['aff_pret_retour'] . "</center></td>";
                    }
                    echo "</tr>\n";
                }
                // fin du while
                echo "</table>";
            } else {
                $line += 2;
                $x