PHP gen_liste函数代码示例

 function show_form($param = '')
 {
     global $msg, $pmb_lecteurs_localises;
     //paramètres pré-enregistré
     $lst_opt = array();
     if ($param['chk_reader']) {
         foreach ($param['chk_reader'] as $elem) {
             $lst_opt[$elem] = $elem;
         }
     }
     $loc_selected = $param["empr_location_id"] ? $param["empr_location_id"] : "";
     $statut_selected = $param["empr_statut_edit"] ? $param["empr_statut_edit"] : "";
     //Choix de l'action à réaliser
     $form_task .= "\n\t\t<div class='row'>\n\t\t\t<div class='colonne3'>\n\t\t\t\t<label for='loan'>" . $this->msg["planificateur_reader_abon"] . "</label>\n\t\t\t</div>\n\t\t\t<div class='colonne_suite'>\n\t\t\t<input type='checkbox' name='chk_reader[]' value='reader_abon_fin_proche' " . ($lst_opt["reader_abon_fin_proche"] == "reader_abon_fin_proche" ? "checked" : "") . "/>" . $this->msg["planificateur_reader_abon_fin_proche"] . "\n\t\t\t\t<br /><input type='checkbox' name='chk_reader[]' value='reader_abon_depasse' " . ($lst_opt["reader_abon_depasse"] == "reader_abon_depasse" ? "checked" : "") . "/>" . $this->msg["planificateur_reader_abon_depasse"] . "";
     //				<input type='checkbox' name='chk_reader[]' value='reader_abon_fin_proche_mail' ".(($lst_opt["reader_abon_fin_proche_mail"] == "reader_abon_fin_proche_mail")  ? "checked" : "")."/>".$this->msg["planificateur_reader_abon_fin_proche_mail"]."
     //				<br /><input type='checkbox' name='chk_reader[]' value='reader_abon_fin_proche_pdf' ".(($lst_opt["reader_abon_fin_proche_pdf"] == "reader_abon_fin_proche_pdf")  ? "checked" : "")."/>".$this->msg["planificateur_reader_abon_fin_proche_pdf"]."
     //				<br /><input type='checkbox' name='chk_reader[]' value='reader_abon_depasse_mail' ".(($lst_opt["reader_abon_depasse_mail"] == "reader_abon_depasse_mail")  ? "checked" : "")."/>".$this->msg["planificateur_reader_abon_depasse_mail"]."
     //				<br /><input type='checkbox' name='chk_reader[]' value='reader_abon_depasse_pdf' ".(($lst_opt["reader_abon_depasse_pdf"] == "reader_abon_depasse_pdf")  ? "checked" : "")."/>".$this->msg["planificateur_reader_abon_depasse_pdf"]."
     $form_task .= "</div>\n\t\t</div>\n\t\t<div class='row'>&nbsp;</div>";
     //Choix de la localisation
     if ($pmb_lecteurs_localises) {
         $form_task .= "\n\t\t\t<div class='row'>\n\t\t\t\t<div class='colonne3'>\n\t\t\t\t\t<label for='loan'>" . $this->msg["planificateur_reader_loc"] . "</label>\n\t\t\t\t</div>\n\t\t\t\t<div class='colonne_suite'>" . docs_location::gen_combo_box_empr($loc_selected) . "\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t<div class='row'>&nbsp;</div>";
     }
     //Choix du statut
     $form_task .= "\n\t\t<div class='row'>\n\t\t\t<div class='colonne3'>\n\t\t\t\t<label for='loan'>" . $this->msg["planificateur_reader_statut"] . "</label>\n\t\t\t</div>\n\t\t\t<div class='colonne_suite'>" . gen_liste("select idstatut, statut_libelle from empr_statut", "idstatut", "statut_libelle", "empr_statut_edit", "", $statut_selected, "", "", 0, $msg["all_statuts_empr"]) . "\n\t\t\t</div>\n\t\t</div>";
     return $form_task;
 }

 public function get_form()
 {
     global $nomenclature_instrument_form_tpl, $msg, $charset;
     global $msg;
     $tpl = $nomenclature_instrument_form_tpl;
     if ($this->id) {
         $tpl = str_replace('!!msg_title!!', $msg['admin_nomenclature_instrument_form_edit'], $tpl);
         $tpl = str_replace('!!delete!!', "<input type='button' class='bouton' value='" . $msg['admin_nomenclature_instrument_form_del'] . "'  onclick=\"document.getElementById('action').value='delete';this.form.submit();\"  />", $tpl);
         $name = $this->info['name'];
         $code = $this->info['code'];
         if ($this->info['standard']) {
             $checked = "checked";
         } else {
             $checked = "";
         }
     } else {
         $tpl = str_replace('!!msg_title!!', $msg['admin_nomenclature_instrument_form_add'], $tpl);
         $tpl_objet = "";
         $tpl = str_replace('!!delete!!', "", $tpl);
         $name = "";
         $code = "";
         $checked = "";
     }
     $tpl = str_replace('!!name!!', htmlentities($name, ENT_QUOTES, $charset), $tpl);
     $tpl = str_replace('!!code!!', htmlentities($code, ENT_QUOTES, $charset), $tpl);
     $tpl = str_replace('!!checked!!', $checked, $tpl);
     $req = "select id_musicstand, concat(musicstand_name,' ( ',family_name,' )')as label from nomenclature_musicstands,nomenclature_families where musicstand_famille_num=id_family order by musicstand_name";
     $musicstand = gen_liste($req, "id_musicstand", "label", "id_musicstand", "", $this->info['musicstand']['id'], 0, $msg["admin_nomenclature_instrument_form_musicstand_no"], 0, $msg["admin_nomenclature_instrument_form_musicstand_no_sel"]);
     $tpl = str_replace('!!musicstand!!', $musicstand, $tpl);
     $tpl = str_replace('!!id!!', $this->id, $tpl);
     return $tpl;
 }

 function get_form()
 {
     global $authperso_form_tpl, $msg, $charset;
     $tpl = $authperso_form_tpl;
     if ($this->id) {
         $tpl = str_replace('!!msg_title!!', $msg['admin_authperso_form_edit'], $tpl);
         $tpl = str_replace('!!delete!!', "<input type='button' class='bouton' value='" . $msg['admin_authperso_delete'] . "'  onclick=\"document.getElementById('auth_action').value='delete';this.form.submit();\"  />", $tpl);
         $name = $this->info['name'];
         $isbd_script = $this->info['isbd_script'];
         $view_script = $this->info['view_script'];
         $comment = $this->info['comment'];
     } else {
         $tpl = str_replace('!!msg_title!!', $msg['admin_authperso_form_add'], $tpl);
         $tpl_objet = "";
         $tpl = str_replace('!!delete!!', "", $tpl);
         $name = "";
         $isbd_script = "";
         $view_script = "";
         $comment = "";
     }
     $notice_onglet_list = gen_liste("SELECT * FROM notice_onglet", "id_onglet", "onglet_name", "notice_onglet", "", $this->info['onglet_num'], 0, $msg["admin_authperso_notice_onglet_no"], 0, $msg["admin_authperso_notice_onglet_sel"]);
     $multi_search_checked = "";
     if ($this->info['opac_multi_search']) {
         $search_multi_checked = " checked='checked' ";
     }
     $search_simple_checked[$this->info['opac_search'] + 0] = " checked='checked' ";
     $search_tpl = "\n\t\t\t<input type='radio' {$search_simple_checked['0']} name='search_simple' value='0' >" . $msg["admin_authperso_opac_search_no"] . "\n\t\t\t<input type='radio' {$search_simple_checked['1']} name='search_simple' value='1' >" . $msg["admin_authperso_opac_search_yes"] . "\n\t\t\t<input type='radio' {$search_simple_checked['2']} name='search_simple' value='2' >" . $msg["admin_authperso_opac_search_yes_active"] . "\n\t\t";
     if ($this->info['gestion_multi_search']) {
         $search_multi_checked_gestion = " checked='checked' ";
     }
     $search_simple_checked_gestion[$this->info['gestion_search'] + 0] = " checked='checked' ";
     $search_tpl_gestion = "\n\t\t\t<input type='radio' {$search_simple_checked_gestion['0']} name='gestion_search_simple' value='0' >" . $msg["admin_authperso_gestion_search_no"] . "\n\t\t\t<input type='radio' {$search_simple_checked_gestion['1']} name='gestion_search_simple' value='1' >" . $msg["admin_authperso_gestion_search_yes"] . "\n\t\t\t<input type='radio' {$search_simple_checked_gestion['2']} name='gestion_search_simple' value='2' >" . $msg["admin_authperso_gestion_search_yes_active"] . "\n\t\t";
     $fields_options = "<select id='fields_options' name='fields_options'>";
     $fields_options .= $this->get_fields_options();
     $fields_options .= "</select>";
     $fields_options_view = "<select id='fields_options_view' name='fields'>";
     $fields_options_view .= $this->get_fields_options();
     $fields_options_view .= "</select>";
     if ($this->info['oeuvre_event']) {
         $tpl = str_replace('!!oeuvre_event!!', " checked='checked' ", $tpl);
     } else {
         $tpl = str_replace('!!oeuvre_event!!', "", $tpl);
     }
     $tpl = str_replace('!!name!!', htmlentities($name, ENT_QUOTES, $charset), $tpl);
     $tpl = str_replace('!!notice_onglet_list!!', $notice_onglet_list, $tpl);
     $tpl = str_replace('!!fields_options!!', $fields_options, $tpl);
     $tpl = str_replace('!!isbd_script!!', htmlentities($isbd_script, ENT_QUOTES, $charset), $tpl);
     $tpl = str_replace('!!fields_options_view!!', $fields_options_view, $tpl);
     $tpl = str_replace('!!view_script!!', htmlentities($view_script, ENT_QUOTES, $charset), $tpl);
     $tpl = str_replace('!!search_simple!!', $search_tpl, $tpl);
     $tpl = str_replace('!!search_multi!!', $search_multi_checked, $tpl);
     $tpl = str_replace('!!search_simple_gestion!!', $search_tpl_gestion, $tpl);
     $tpl = str_replace('!!search_multi_gestion!!', $search_multi_checked_gestion, $tpl);
     $tpl = str_replace('!!comment!!', htmlentities($comment, ENT_QUOTES, $charset), $tpl);
     $tpl = str_replace('!!id_authperso!!', $this->id, $tpl);
     return $tpl;
 }

function show_import_choix_fichier($dbh)
{
    global $msg, $deflt2docs_location;
    global $current_module, $PMBuserid;
    print "\n\t<script type='text/javascript'>\n\nfunction display_part(type)\n{\n\tvar type_import = document.getElementById('div_ensae');\n\tif(type == 'ensae')\n\t{\n\t\tvar div_ensae = document.getElementById('div_ensae');\n\t\tdiv_ensae.style.display = 'table-cell';\n\t\tvar div_ensai = document.getElementById('div_ensai');\n\t\tdiv_ensai.style.display = 'none';\t\n\t\ttype_import.value='maj_complete';\n\t\t\n\t} else {\n\t\tvar div_ensae = document.getElementById('div_ensae');\n\t\tdiv_ensae.style.display = 'none';\n\t\tvar div_ensai = document.getElementById('div_ensai');\n\t\tdiv_ensai.style.display = 'table-cell';\n\t\ttype_import.value='insert_or_update';\n\t}\n\t\n} \n</script>\n\t\n\t<form class='form-{$current_module}' name='form1' ENCTYPE=\"multipart/form-data\" method='post' action=\"./admin.php?categ=empr&sub=implec&action=1\">\n\t<h3>Choix du fichier d'import des élèves GENES</h3>\n\t<div class='form-contenu'>\n\t\t<div class='row'>\n\t\t\t<label class='etiquette' for='import_lec'>" . $msg["import_lec_fichier"] . "</label>\n\t        <input name='import_lec' id='import_lec' accept='text/plain' type='file' class='saisie-80em' size='80'>\n\t\t\t</div>\n\t\t<div class='row'>\n\t        <label class='etiquette' for='Sep_Champs'>" . $msg["import_lec_separateur"] . "</label>\n\t        <select name='Sep_Champs' id='Sep_Champs'>\n\t            <option value=';' selected>;</option>\n\t            <option value='.'>.</option>\n\t        </select>\n\t    </div>\n\t    <div class='row'>\n\t        <label class='etiquette' for='file_format'>Format du fichier</label>\n\t        <select name='file_format' id='file_format' onchange='display_part(this.value);'>\n\t            <option value='ensae' selected>ENSAE</option>\n\t            <option value='ensai'>ENSAI</option>\n\t        </select>\n\t    </div>\n\t    <br />\n\t    <div style='display:table'>\n\t    \t<div style='display:table-row'>\n\t\t    \t<div id=div_ensae style='display:table-cell;width:50%'>\n\t\t    \t\t<div class='row'>\n\t\t\t\t\t\t<p>L'ordre des colonnes dans votre fichier doit être :<br />\n\t\t\t\t\t\t<font size='1'>Identifiant de l'étudiant ; Code-barres ; Voie ; Nom ; Prénom ; Mail ; Mail perso ; Numéro de casier ; Civilité ; Année de date de naissance ; Téléphone 1 ; Téléphone 2 ; Identifiant OPAC</font>\n\t\t\t\t\t\t</p>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class='row'>\n\t\t\t\t        <input type=hidden name='type_import' id='type_import' value='maj_complete' />\n\t\t\t\t        <label class='etiquette' for='type_import'>Mise à jour complète</label>\n\t\t\t\t        Marquer les lecteurs appartenant aux groupes ci-dessous et ayant pour catégorie et localisation les choix ci-dessous\n\t\t\t\t        <blockquote>" . "\n\t\t\t\t        Et les placer dans le panier suivant: ";
    $requete = "SELECT idemprcaddie, name FROM empr_caddie where (autorisations='{$PMBuserid}' or autorisations like '{$PMBuserid} %' or autorisations like '% {$PMBuserid} %' or autorisations like '% {$PMBuserid}') order by name ";
    print gen_liste($requete, "idemprcaddie", "name", "idemprcaddie", "", "", "", "", "", "", 0);
    print "</blockquote>\n\t\t\t\t    </div>\n\t\t\t\t    <div class='row'>\n\t\t\t\t\t    <blockquote>\n\t\t\t\t\t    \t<div class='colonne3'>";
    $requete = "SELECT id_groupe, libelle_groupe FROM groupe left join empr_groupe on id_groupe=groupe_id  group by id_groupe, libelle_groupe ORDER BY libelle_groupe ";
    $groupe_form_aff = gen_liste_multiple($requete, "id_groupe", "libelle_groupe", "id_groupe", "id_grp[]", "", $id, 0, $msg[empr_form_aucungroupe], 0, "", 60);
    print "<div class='row'>\n\t\t\t\t\t\t\t\t\t<label for='form_ajoutgroupe' class='etiquette'>Groupes :</label>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class='row'>" . $groupe_form_aff . "</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t<div class='colonne3'>";
    $requete = "SELECT id_categ_empr, libelle FROM empr_categ ORDER BY libelle ";
    $categ_form_aff = gen_liste($requete, "id_categ_empr", "libelle", "id_categ_empr", "", 36, "", "", "", "", 0);
    print "<div class='row'>\n\t\t\t\t\t\t\t\t\t<label for='form_categ_empr' class='etiquette'>Catégorie de lecteurs :</label>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class='row'>" . $categ_form_aff . "</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t<div class='colonne_suite'>";
    print "<div class='row'>\n\t\t\t\t\t\t\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t\t\t\t\t\t\t<label for='form_empr_location' class='etiquette'>{$msg['empr_location']}:</label>\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t\t\t\t\t\t\t" . docs_location::gen_combo_box_empr($deflt2docs_location, 0) . "\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</blockquote>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div id=div_ensai style='display:table-cell;width:50%;display:none'>\n\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t<p>L'ordre des colonnes dans votre fichier doit être :<br />\n\t\t\t\t\t\t<font size='1'>Nom ; Prénom ; Mail ; Mail perso ; Catégorie ; Groupe 1 ; Groupe 2 ; Groupe 3 ;  Libellé du statut ; Libellé de la localisation ; Pays ; Date d'adhésion du lecteur ; Date d'expiration du lecteur ; Code-barres ; Identifiant OPAC ; Téléphone 1 ; Téléphone 2</font>\n\t\t\t\t\t\t</p>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class='row'>\n\t\t\t\t        \n\t\t\t\t        <label class='etiquette' for='type_import_1'>Insertion uniquement</label>\n\t\t\t\t    </div>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t\t<div class='row'>&nbsp;</div>\n\t</div>\n\t<div class='row'>\n\t\t<input name='imp_elv' type='submit' class='bouton' value='Import des élèves'/>\n\t</div>\n\t</form>";
}

function codstat_form($libelle = "", $statisdoc_codage_import = "", $statisdoc_owner = 0, $id = 0)
{
    global $msg;
    global $charset;
    global $admin_codstat_form;
    $admin_codstat_form = str_replace('!!id!!', $id, $admin_codstat_form);
    if (!$id) {
        $admin_codstat_form = str_replace('!!form_title!!', $msg[101], $admin_codstat_form);
    } else {
        $admin_codstat_form = str_replace('!!form_title!!', $msg[102], $admin_codstat_form);
    }
    $admin_codstat_form = str_replace('!!libelle!!', htmlentities($libelle, ENT_QUOTES, $charset), $admin_codstat_form);
    $admin_codstat_form = str_replace('!!libelle_suppr!!', addslashes($libelle), $admin_codstat_form);
    $admin_codstat_form = str_replace('!!statisdoc_codage_import!!', $statisdoc_codage_import, $admin_codstat_form);
    $combo_lender = gen_liste("select idlender, lender_libelle from lenders order by lender_libelle ", "idlender", "lender_libelle", "form_statisdoc_owner", "", $statisdoc_owner, 0, $msg[556], 0, $msg["proprio_generique_biblio"]);
    $admin_codstat_form = str_replace('!!lender!!', $combo_lender, $admin_codstat_form);
    print confirmation_delete("./admin.php?categ=docs&sub=codstat&action=del&id=");
    print $admin_codstat_form;
}

function show_req_add_form($step = 0)
{
    global $dbh, $msg, $charset;
    global $rqt;
    global $req_add_form;
    global $bt_enr_form;
    $form_title = $msg['req_form_tit_add'];
    switch ($step) {
        default:
        case '0':
            $req_add_form = str_replace('!!form_title!!', $form_title, $req_add_form);
            $num_classement = 0;
            $combo_clas = gen_liste("SELECT idproc_classement,libproc_classement FROM procs_classements ORDER BY libproc_classement ", "idproc_classement", "libproc_classement", "form_classement", "", $num_classement, 0, $msg['proc_clas_aucun'], 0, $msg['proc_clas_aucun']);
            $req_add_form = str_replace('!!classement!!', $combo_clas, $req_add_form);
            $req_add_form = str_replace('!!req_name!!', '', $req_add_form);
            $req_add_form = str_replace('!!req_type!!', $rqt->getTypeSelector('1', 'req_typeChg();'), $req_add_form);
            $req_add_form = str_replace('!!req_univ!!', $rqt->getUnivSelector('1', 'req_univChg();'), $req_add_form);
            $req_add_form = str_replace('!!req_comm!!', '', $req_add_form);
            $req_add_form = str_replace('!!req_code!!', '', $req_add_form);
            $req_add_form = str_replace('!!req_auth!!', request::getAutorisationsForm(), $req_add_form);
            break;
    }
    print $req_add_form;
}

 function gen_liste_field($select_name = "p_perso_liste", $selected_id = 0, $msg_no_select)
 {
     global $msg;
     $onchange = "";
     $requete = "select idchamp, name, titre, type, datatype, multiple, obligatoire, ordre ,search, export,exclusion_obligatoire, opac_sort from " . $this->prefix . "_custom order by ordre";
     return gen_liste($requete, "idchamp", "titre", $select_name, $onchange, $selected_id, 0, $msg["parperso_no_field"], 0, $msg_no_select, 0);
 }

 static function gen_tpl_select($select_name = "notice_tpl", $selected_id = 0, $onchange = "", $no_affempty = 0, $no_aff_defaut = 0)
 {
     global $msg, $dbh;
     //
     $requete = "SELECT notpl_id, if(notpl_comment!='',concat(notpl_name,'. ',notpl_comment),notpl_name) as nom FROM notice_tpl where notpl_show_opac=1 ORDER BY notpl_name ";
     $result = pmb_mysql_query($requete, $dbh);
     if (!pmb_mysql_num_rows($result) && !$no_affempty) {
         return '';
     }
     if (!$no_aff_defaut) {
         return gen_liste($requete, "notpl_id", "nom", $select_name, $onchange, $selected_id, 0, $msg["notice_tpl_list_default"], 0, $msg["notice_tpl_list_default"], 0);
     } else {
         return gen_liste($requete, "notpl_id", "nom", $select_name, $onchange, $selected_id, 0, '', 0, '', 0);
     }
 }

 function show_form()
 {
     global $msg;
     global $dbh;
     global $charset, $lang;
     global $search_form_map;
     global $all_query, $typdoc_query, $statut_query, $docnum_query, $pmb_indexation_docnum_allfields, $pmb_indexation_docnum;
     global $categ_query, $thesaurus_auto_postage_search, $auto_postage_query;
     global $thesaurus_concepts_active, $concept_query;
     global $map_echelle_query, $map_projection_query, $map_ref_query, $map_equinoxe_query;
     global $pmb_map_size_search_edition;
     global $pmb_map_base_layer_type;
     global $pmb_map_base_layer_params;
     global $map_emprises_query;
     // on commence par créer le champ de sélection de document
     // récupération des types de documents utilisés.
     $query = "SELECT count(typdoc), typdoc ";
     $query .= "FROM notices where typdoc!='' GROUP BY typdoc";
     $result = @pmb_mysql_query($query, $dbh);
     $toprint_typdocfield .= "  <option value=''>{$msg['tous_types_docs']}</option>\n";
     $doctype = new marc_list('doctype');
     while ($rt = pmb_mysql_fetch_row($result)) {
         $obj[$rt[1]] = 1;
         $qte[$rt[1]] = $rt[0];
     }
     foreach ($doctype->table as $key => $libelle) {
         if ($obj[$key] == 1) {
             $toprint_typdocfield .= "  <option ";
             $toprint_typdocfield .= " value='{$key}'";
             if ($typdoc == $key) {
                 $toprint_typdocfield .= " selected='selected' ";
             }
             $toprint_typdocfield .= ">" . htmlentities($libelle . " (" . $qte[$key] . ")", ENT_QUOTES, $charset) . "</option>\n";
         }
     }
     // récupération des statuts de documents utilisés.
     $query = "SELECT count(statut), id_notice_statut, gestion_libelle ";
     $query .= "FROM notices, notice_statut where id_notice_statut=statut GROUP BY id_notice_statut order by gestion_libelle";
     $result = pmb_mysql_query($query, $dbh);
     $toprint_statutfield .= "  <option value=''>{$msg['tous_statuts_notice']}</option>\n";
     while ($obj = @pmb_mysql_fetch_row($result)) {
         $toprint_statutfield .= "  <option value='{$obj['1']}'";
         if ($statut_query == $obj[1]) {
             $toprint_statutfield .= " selected";
         }
         $toprint_statutfield .= ">" . htmlentities($obj[2] . "  (" . $obj[0] . ")", ENT_QUOTES, $charset) . "</OPTION>\n";
     }
     $search_form_map = str_replace("!!typdocfield!!", $toprint_typdocfield, $search_form_map);
     $search_form_map = str_replace("!!statutfield!!", $toprint_statutfield, $search_form_map);
     $search_form_map = str_replace("!!all_query!!", htmlentities(stripslashes($all_query), ENT_QUOTES, $charset), $search_form_map);
     $search_form_map = str_replace("!!categ_query!!", htmlentities(stripslashes($categ_query), ENT_QUOTES, $charset), $search_form_map);
     if ($thesaurus_concepts_active) {
         $search_form_map = str_replace("!!concept_query!!", htmlentities(stripslashes($concept_query), ENT_QUOTES, $charset), $search_form_map);
     }
     // map
     $layer_params = json_decode($pmb_map_base_layer_params, true);
     $baselayer = "baseLayerType: dojox.geo.openlayers.BaseLayerType." . $pmb_map_base_layer_type;
     if (count($layer_params)) {
         if ($layer_params['name']) {
             $baselayer .= ",baseLayerName:\"" . $layer_params['name'] . "\"";
         }
         if ($layer_params['url']) {
             $baselayer .= ",baseLayerUrl:\"" . $layer_params['url'] . "\"";
         }
         if ($layer_params['options']) {
             $baselayer .= ",baseLayerOptions:" . json_encode($layer_params['options']);
         }
     }
     $size = explode("*", $pmb_map_size_search_edition);
     if (count($size) != 2) {
         $map_size = "width:800px; height:480px;";
     }
     $map_size = "width:" . $size[0] . "px; height:" . $size[1] . "px;";
     if (!$map_emprises_query) {
         $map_emprises_query = array();
     }
     $map_holds = array();
     foreach ($map_emprises_query as $map_hold) {
         $map_holds[] = array("wkt" => $map_hold, "type" => "search", "color" => null, "objects" => array());
     }
     $r = "<div id='map_search' data-dojo-type='apps/map/map_controler' style='{$map_size}' data-dojo-props='" . $baselayer . ",mode:\"search_criteria\",hiddenField:\"map_emprises_query\",searchHolds:" . json_encode($map_holds, true) . "'></div>";
     $search_form_map = str_replace("!!map!!", $r, $search_form_map);
     //champs maps
     $requete = "SELECT map_echelle_id, map_echelle_name FROM map_echelles ORDER BY map_echelle_name ";
     $projections = gen_liste($requete, "map_echelle_id", "map_echelle_name", "map_echelle_query", "", $map_echelle_query, 0, "", 0, $msg['map_echelle_vide']);
     $search_form_map = str_replace("!!map_echelle_list!!", $projections, $search_form_map);
     $requete = "SELECT map_projection_id, map_projection_name FROM map_projections ORDER BY map_projection_name ";
     $projections = gen_liste($requete, "map_projection_id", "map_projection_name", "map_projection_query", "", $map_projection_query, 0, "", 0, $msg['map_projection_vide']);
     $search_form_map = str_replace("!!map_projection_list!!", $projections, $search_form_map);
     $requete = "SELECT map_ref_id, map_ref_name FROM map_refs ORDER BY map_ref_name ";
     $refs = gen_liste($requete, "map_ref_id", "map_ref_name", "map_ref_query", "", $map_ref_query, 0, "", 0, $msg['map_ref_vide']);
     $search_form_map = str_replace("!!map_ref_list!!", $refs, $search_form_map);
     $search_form_map = str_replace("!!map_equinoxe_value!!", $map_equinoxe_query, $search_form_map);
     $checkbox = "";
     if ($thesaurus_auto_postage_search) {
         $checkbox = "\n\t\t\t<div class='colonne'>\n\t\t\t\t<div class='row'>\n\t\t\t\t\t<input type='checkbox' !!auto_postage_checked!! id='auto_postage_query' name='auto_postage_query'/><label for='auto_postage_query'>" . $msg["search_autopostage_check"] . "</label>\n\t\t\t\t</div>\n\t\t\t</div>";
         $checkbox = str_replace("!!auto_postage_checked!!", $auto_postage_query ? 'checked' : '', $checkbox);
     }
     $search_form_map = str_replace("!!auto_postage!!", $checkbox, $search_form_map);
     if ($pmb_indexation_docnum) {
//.........这里部分代码省略.........

 if ($field == "deflt_styles") {
     $deflt_user_style = "\n\t\t\t\t\t\t<div class='colonne60'><div class='row'>" . $msg[$field] . "&nbsp;:&nbsp;</div></div>\n\n\t\t\t\t\t\t<div class='colonne_suite'><div_class='row'>" . make_user_style_combo($field_values[$i]) . "</div></div>\n";
 } elseif ($field == "deflt_docs_location") {
     //visibilité des exemplaires
     if ($pmb_droits_explr_localises && $explr_visible_mod) {
         $where_clause_explr = "idlocation in (" . $explr_visible_mod . ") and";
     } else {
         $where_clause_explr = "";
     }
     $selector = 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", 'form_' . $field, "account_calcule_section(this);", $field_values[$i], "", "", "", "", 0);
     $deflt_user .= "\n\t\t\t\t\t\t<div class='row'><div class='colonne60'>" . $msg[$field] . "&nbsp;:&nbsp;</div>\n\n\t\t\t\t\t\t<div class='colonne_suite'>" . $selector . "</div></div>\n";
 } elseif ($field == "deflt_collstate_location") {
     $selector = gen_liste("select distinct idlocation, location_libelle from docs_location order by 2 ", "idlocation", "location_libelle", 'form_' . $field, "", $field_values[$i], "", "", "0", $msg["all_location"], 0);
     $deflt_user .= "\n\t\t\t\t\t\t<div class='row'><div class='colonne60'>" . $msg[$field] . "&nbsp;:&nbsp;</div>\n\n\t\t\t\t\t\t<div class='colonne_suite'>" . $selector . "</div></div>\n";
 } elseif ($field == "deflt_resas_location") {
     $selector = gen_liste("select distinct idlocation, location_libelle from docs_location order by 2 ", "idlocation", "location_libelle", 'form_' . $field, "", $field_values[$i], "", "", "0", $msg["all_location"], 0);
     $deflt_user .= "\n\t\t\t\t\t\t<div class='row'><div class='colonne60'>" . $msg[$field] . "&nbsp;:&nbsp;</div>\n\n\t\t\t\t\t\t<div class='colonne_suite'>" . $selector . "</div></div>\n";
 } elseif ($field == "deflt_docs_section") {
     // calcul des sections
     $selector = "";
     if ($pmb_droits_explr_localises && $explr_visible_mod) {
         $where_clause_explr = "where idlocation in (" . $explr_visible_mod . ")";
     } else {
         $where_clause_explr = "";
     }
     $rqtloc = "SELECT idlocation FROM docs_location {$where_clause_explr} order by location_libelle";
     $resloc = mysql_query($rqtloc, $dbh);
     while ($loc = mysql_fetch_object($resloc)) {
         $requete = "SELECT idsection, section_libelle FROM docs_section, docsloc_section where idsection=num_section and num_location='{$loc->idlocation}' order by section_libelle";
         $result = mysql_query($requete, $dbh);
         $nbr_lignes = mysql_num_rows($result);

 public function get_form()
 {
     global $dbh, $msg;
     global $map_edition_tpl;
     global $map_edition_all_tpl;
     $form_map = "";
     $map_edition_tpl = "\n\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t<label class='etiquette' for='f_map_echelle'>" . $msg["map_echelle"] . "</label>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t!!map_echelle_list!!\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t<label class='etiquette' for='f_map_projection'>" . $msg["map_projection"] . "</label>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t!!map_projection_list!!\n\t\t\t\t\t</div>\t\t\n\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t<label class='etiquette' for='f_map_ref'>" . $msg["map_ref"] . "</label>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t!!map_ref_list!!\n\t\t\t\t\t</div>\t\t\t\t\n\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t<label class='etiquette' for='f_map_equinoxe'>" . $msg["map_equinoxe"] . "</label>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t<input id='f_map_equinoxe' class='saisie-80em' type='text' value='!!map_equinoxe_value!!' name='f_map_equinoxe'>\n\t\t\t\t\t</div>\n\t\t\t\t";
     $form_map = $map_edition_tpl;
     $requete = "SELECT map_echelle_id, map_echelle_name FROM map_echelles ORDER BY map_echelle_name ";
     $projections = gen_liste($requete, "map_echelle_id", "map_echelle_name", "f_map_echelle", "", $this->map['echelle_num'], 0, "", 0, $msg['map_echelle_vide']);
     $form_map = str_replace("!!map_echelle_list!!", $projections, $form_map);
     $requete = "SELECT map_projection_id, map_projection_name FROM map_projections ORDER BY map_projection_name ";
     $projections = gen_liste($requete, "map_projection_id", "map_projection_name", "f_map_projection", "", $this->map['projection_num'], 0, "", 0, $msg['map_projection_vide']);
     $form_map = str_replace("!!map_projection_list!!", $projections, $form_map);
     $requete = "SELECT map_ref_id, map_ref_name FROM map_refs ORDER BY map_ref_name ";
     $refs = gen_liste($requete, "map_ref_id", "map_ref_name", "f_map_ref", "", $this->map['ref_num'], 0, "", 0, $msg['map_ref_vide']);
     $form_map = str_replace("!!map_ref_list!!", $refs, $form_map);
     $form_map = str_replace("!!map_equinoxe_value!!", $this->map['equinoxe'], $form_map);
     $form_map = str_replace("!!id!!", $this->id, $form_map);
     return $form_map;
 }

function gen_liste_classement($type_classement = "BAN", $id_classement = 0, $onchange = "")
{
    global $msg;
    return gen_liste("select id_classement, nom_classement from classements where id_classement=1 UNION select id_classement, nom_classement from classements where type_classement='{$type_classement}' order by nom_classement", "id_classement", "nom_classement", "id_classement", $onchange, $id_classement, "", "", 0, $msg['dsi_all_classements'], 0);
}

 static function gen_tpl_select($select_name = "notice_tpl", $selected_id = 0)
 {
     global $msg;
     $requete = "SELECT notpl_id, concat(notpl_name,'. ',notpl_comment) as nom  FROM notice_tpl ORDER BY notpl_name ";
     $onchange = "";
     return gen_liste($requete, "notpl_id", "nom", $select_name, $onchange, $selected_id, 0, $msg["notice_tpl_list_default"], 0, $msg["notice_tpl_list_default"], 0);
 }

function location_form($libelle = "", $locdoc_codage_import = "", $locdoc_owner = 0, $id = 0, $location_pic = "", $location_visible_opac = 1, $name = "", $adr1 = "", $adr2 = "", $cp = "", $town = "", $state = "", $country = "", $phone = "", $email = "", $website = "", $logo = "", $commentaire = "", $num_infopage = 0, $css_style = "", $surloc_used = 0)
{
    global $msg;
    global $admin_location_form;
    global $charset, $sur_loc_selector;
    $admin_location_form = str_replace('!!id!!', $id, $admin_location_form);
    if (!$id) {
        $admin_location_form = str_replace('!!form_title!!', $msg[106], $admin_location_form);
    } else {
        $admin_location_form = str_replace('!!form_title!!', $msg[107], $admin_location_form);
    }
    $admin_location_form = str_replace('!!libelle!!', htmlentities($libelle, ENT_QUOTES, $charset), $admin_location_form);
    $admin_location_form = str_replace('!!libelle_suppr!!', htmlentities(addslashes($libelle), ENT_QUOTES, $charset), $admin_location_form);
    $admin_location_form = str_replace('!!location_pic!!', htmlentities($location_pic, ENT_QUOTES, $charset), $admin_location_form);
    if ($location_visible_opac) {
        $checkbox = "checked";
    } else {
        $checkbox = "";
    }
    $admin_location_form = str_replace('!!checkbox!!', $checkbox, $admin_location_form);
    $admin_location_form = str_replace('!!locdoc_codage_import!!', $locdoc_codage_import, $admin_location_form);
    $combo_lender = gen_liste("select idlender, lender_libelle from lenders order by lender_libelle ", "idlender", "lender_libelle", "form_locdoc_owner", "", $locdoc_owner, 0, $msg[556], 0, $msg["proprio_generique_biblio"]);
    $admin_location_form = str_replace('!!lender!!', $combo_lender, $admin_location_form);
    $admin_location_form = str_replace('!!sur_loc_selector!!', $sur_loc_selector, $admin_location_form);
    if ($surloc_used) {
        $checkbox = "checked";
    } else {
        $checkbox = "";
    }
    $admin_location_form = str_replace('!!checkbox_use_surloc!!', $checkbox, $admin_location_form);
    $admin_location_form = str_replace('!!loc_name!!', htmlentities($name, ENT_QUOTES, $charset), $admin_location_form);
    $admin_location_form = str_replace('!!loc_adr1!!', htmlentities($adr1, ENT_QUOTES, $charset), $admin_location_form);
    $admin_location_form = str_replace('!!loc_adr2!!', htmlentities($adr2, ENT_QUOTES, $charset), $admin_location_form);
    $admin_location_form = str_replace('!!loc_cp!!', $cp, $admin_location_form);
    $admin_location_form = str_replace('!!loc_town!!', htmlentities($town, ENT_QUOTES, $charset), $admin_location_form);
    $admin_location_form = str_replace('!!loc_state!!', htmlentities($state, ENT_QUOTES, $charset), $admin_location_form);
    $admin_location_form = str_replace('!!loc_country!!', htmlentities($country, ENT_QUOTES, $charset), $admin_location_form);
    $admin_location_form = str_replace('!!loc_phone!!', $phone, $admin_location_form);
    $admin_location_form = str_replace('!!loc_email!!', $email, $admin_location_form);
    $admin_location_form = str_replace('!!loc_website!!', $website, $admin_location_form);
    $admin_location_form = str_replace('!!loc_logo!!', $logo, $admin_location_form);
    $admin_location_form = str_replace('!!loc_commentaire!!', htmlentities($commentaire, ENT_QUOTES, $charset), $admin_location_form);
    $requete = "SELECT id_infopage, title_infopage FROM infopages where valid_infopage=1 ORDER BY title_infopage ";
    $infopages = gen_liste($requete, "id_infopage", "title_infopage", "form_num_infopage", "", $num_infopage, 0, $msg["location_no_infopage"], 0, $msg["location_no_infopage"], 0);
    $admin_location_form = str_replace('!!loc_infopage!!', $infopages, $admin_location_form);
    $admin_location_form = str_replace('!!css_style!!', $css_style, $admin_location_form);
    print confirmation_delete("./admin.php?categ=docs&sub=location&action=del&id=");
    print $admin_location_form;
}

 public function get_form()
 {
     global $msg, $charset;
     global $editions_state_form;
     $form = str_replace('!!id!!', $this->id, $editions_state_form);
     //positionnement auto sur le dernier onglet, ca marche tout seul, pas besoin de s'en soucier !
     global $editionsstate_active_tab;
     $form = str_replace('!!active_tab!!', htmlentities($editionsstate_active_tab, ENT_QUOTES, $charset), $form);
     //Titre du formulaire
     if (!$this->id) {
         $form = str_replace('!!form_title!!', $msg[704], $form);
     } else {
         $form = str_replace('!!form_title!!', $msg["procs_modification"], $form);
     }
     //nom
     $form = str_replace('!!name!!', htmlentities($this->name, ENT_QUOTES, $charset), $form);
     //commentaire
     $form = str_replace('!!comment!!', htmlentities($this->comment, ENT_QUOTES, $charset), $form);
     //classement
     $combo_clas = gen_liste("SELECT idproc_classement,libproc_classement FROM procs_classements ORDER BY libproc_classement ", "idproc_classement", "libproc_classement", "editions_state_classement", "", $this->classement, 0, $msg[proc_clas_aucun], 0, $msg[proc_clas_aucun]);
     $form = str_replace('!!classement!!', $combo_clas, $form);
     //source de données
     $datasource_options = "\n\t\t\t<option value='0'>" . $msg['editions_state_datasource_choice'] . "</options>";
     $datasources_list = $this->datasource->get_datasources_list();
     foreach ($datasources_list as $data_key => $label) {
         $datasource_options .= "\n\t\t\t<option value='" . htmlentities($data_key, ENT_QUOTES, $charset) . "' " . ($this->used_datasource == $data_key ? "selected='selected'" : "") . ">" . htmlentities($label, ENT_QUOTES, $charset) . "</option>";
     }
     //
     //		$datasource_options.="
     //			<option value='editions_datasource_loans' ".($this->used_datasource == "editions_datasource_loans" ? "selected='selected'":"").">Prêts</option>";
     $form = str_replace('!!datasource_options!!', $datasource_options, $form);
     if (count($this->state_fields_list['filters']['content']) || count($this->state_fields_list['fields']['content'])) {
         //J'ai commencé à créer un état je ne peux donc pas changer de source
         $form = str_replace('!!datasource_readonly!!', "disabled='disabled'", $form);
         $form = str_replace('<!--editions_state_datasource-->', "<input type='hidden' name='editions_state_datasource' id='editions_state_datasource' value='" . $this->used_datasource . "'/>", $form);
     } else {
         $form = str_replace('!!datasource_readonly!!', "", $form);
     }
     if (!$this->used_datasource) {
         $form = str_replace("!!tabs!!", "", $form);
     } else {
         $form = str_replace("!!tabs!!", $this->get_tabs_form(), $form);
     }
     $del_button = "";
     if ($this->id) {
         $del_button = "<input type='button' class='bouton' value=' {$msg['supprimer']} ' onClick='confirm_delete(" . $this->id . ")' />\n\t\t\t<script type='text/javascript'>\n\t\t\t\tfunction confirm_delete(id){\n\t\t\t\t\tif(confirm('" . addslashes($msg['editions_state_confirm_delete']) . "')){\n\t\t\t\t\t\tdocument.location='./edit.php?categ=state&action=delete&id='+id;\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t</script>\n\t\t\t";
     }
     $form = str_replace("!!del_button!!", $del_button, $form);
     return $form;
 }