echo "<font size=5 color=#008C8E >" . $lang[$lang_select]['add_fiche'] . "</font>"; echo "</div>"; echo "<div style=\"float:right;\">"; echo "<button id=\"enregistrer1-add-button\">" . $lang[$lang_select]['enregistrer'] . "</button> "; echo "<button id=\"retour1-button\">" . $lang[$lang_select]['liste_taxons'] . "</button> "; echo "</div><br><br>"; echo "<br><br>"; echo "<div id=\"radio2\">"; echo "<input type=\"hidden\" name=\"etape\" id=\"etape2\" value=\"2\">"; /*------------------------------------------------------------------------------ AJOUT Fiche */ $rang = array('' => '', 'ES' => 'ES', 'SSES' => 'SSES', 'VAR' => 'VAR', 'SVAR' => 'SVAR', 'FO' => 'FO', 'SSFO' => 'SSFO', 'CAR' => 'CAR'); echo "<fieldset><LEGEND>Taxonomie</LEGEND>"; metaform_text("Code NOM.", "", "", "style=width:10em;", "cd_nom", ""); metaform_text("Famille", "", "", "style=width:30em;", "famille", ""); metaform_text("Nom scientifique", "", "", "style=width:30em;", "nom_complet", ""); metaform_text("Nom(s) vernaculaire(s)", "", "", "style=width:51em;", "nom_vern", ""); metaform_sel("Rang", "", "", $rang, "rang", ""); metaform_bout("Taxon hybride?", "", "hybride", ""); echo "</fieldset>"; echo "<fieldset><LEGEND>Rubrique</LEGEND>"; metaform_bool("Rub. CATNAT", "", "catnat", "f"); metaform_bool("Rub. Liste rouge", "", "liste_rouge", "f"); metaform_bool("Rub Liste EEE", "", "eee", "f"); echo "</fieldset>"; /*------------------------------------------------------------------------------ SAVE */ echo "<div style=\"float:right;\"><br>"; echo "<button id=\"enregistrer2-add-button\">" . $lang[$lang_select]['enregistrer'] . "</button> "; echo "<button id=\"retour2-button\">" . $lang[$lang_select]['liste_taxons'] . "</button> "; echo "</div>"; echo "</form>"; echo "</div>";
metaform_sel_multi ("Présence région agricole","",5,"width: 240px;","OnDblClick='javascript: deplacer( this.form.region_agricole, this.form.region_agricole_select);'",$ref['liste_region_agricole'],"region_agricole","",pg_fetch_result(pg_query ($db,$query_description."'idTerritoire'".";"),0,"description" )); metaform_sel_multi ("Région agricole sélectionné(s)","",5,"width: 240px;","OnDblClick='javascript: deplacer( this.form.region_agricole_select, this.form.region_agricole);'","","region_agricole_select",""); } */ echo "</fieldset>"; /*------------------------------------------------------------------------------ EDIT fieldset6*/ //---------6eme encadré de la page echo "<fieldset><LEGEND>Phénologie, physionomie, écologie</LEGEND>"; /*écologie générale*/ metaform_text_area("Description écologie", "", 57, 50, "", "descriptionEcologie", sql_format_quote(pg_result($result_syntaxon, 0, "\"descriptionEcologie\""), 'undo'), pg_fetch_result(pg_query($db, $query_description . "'descriptionEcologie'" . ";"), 0, "description")); echo "<table><tr><td width=33%>"; metaform_sel("Type physionomique)", "", 30, $ref[$champ_ref['typePhysionomique']], "typePhysionomique", pg_result($result_syntaxon, 0, "\"typePhysionomique\""), pg_fetch_result(pg_query($db, $query_description . "'typePhysionomique'" . ";"), 0, "description")); echo "</td><td width=33%>"; metaform_text("Type biologique dominant", "", 30, "width=100%", "typeBiologiqueDom", sql_format_quote(pg_result($result_syntaxon, 0, "\"typeBiologiqueDom\""), 'undo'), pg_fetch_result(pg_query($db, $query_description . "'typeBiologiqueDom'" . ";"), 0, "description")); echo "</td><td width=33%>"; metaform_text("Aire minimale d'expression (m2)", "", 30, "width=100%", "aireMinimale", sql_format_quote(pg_result($result_syntaxon, 0, "\"aireMinimale\""), 'undo'), pg_fetch_result(pg_query($db, $query_description . "'aireMinimale'" . ";"), 0, "description")); echo "</td></tr></table>"; echo "<br>"; echo "<table><tr><td width=33%>"; metaform_text_area("Remarque phénologie", "", 57, 50, "", "rqPhenologie", sql_format_quote(pg_result($result_syntaxon, 0, "\"rqPhenologie\""), 'undo'), pg_fetch_result(pg_query($db, $query_description . "'rqPhenologie'" . ";"), 0, "description")); echo "</td><td width=33%>"; metaform_sel("Début de période optimale", "", 30, $ref[$champ_ref['periodeDebObsOptimale']], "periodeDebObsOptimale", pg_result($result_syntaxon, 0, "\"periodeDebObsOptimale\""), pg_fetch_result(pg_query($db, $query_description . "'periodeDebObsOptimale'" . ";"), 0, "description")); echo "</td><td width=33%>"; metaform_sel("Fin de période optimale", "", 30, $ref[$champ_ref['periodeFinObsOptimale']], "periodeFinObsOptimale", pg_result($result_syntaxon, 0, "\"periodeFinObsOptimale\""), pg_fetch_result(pg_query($db, $query_description . "'periodeFinObsOptimale'" . ";"), 0, "description")); echo "</td></tr></table>"; echo "<br>"; echo "<table><tr><td width=50%>"; metaform_sel("Humidité principale", "", 30, $ref[$champ_ref['humiditePrincipale']], "humiditePrincipale", pg_result($result_syntaxon, 0, "\"humiditePrincipale\""), pg_fetch_result(pg_query($db, $query_description . "'humiditePrincipale'" . ";"), 0, "description")); echo "</td><td width=50%>"; metaform_sel("Humidité secondaire", "", 30, $ref[$champ_ref['humiditeSecondaire']], "humiditeSecondaire", pg_result($result_syntaxon, 0, "\"humiditeSecondaire\""), pg_fetch_result(pg_query($db, $query_description . "'humiditeSecondaire'" . ";"), 0, "description")); echo "</td></tr></table>";
echo "<br>"; echo "<table id=table_1><tr><td>"; //metaform_bool_appared ("Importer un seul fichier ",null,$onchange,null,"lonely_file","f"); metaform_sel("Catalogue", "", 30, $ref[$champ_ref["idCatalogue"]], "idCatalogue", "", pg_fetch_result(pg_query($db, $query_description . "'idCatalogue'" . ";"), 0, "description")); echo "</td></tr></table>"; metaform_sel("CBN (auteur principal)*", "", 30, $array_cbn, "idTerritoireObligatoire", "", pg_fetch_result(pg_query($db, $query_description . "'idTerritoire'" . ";"), 0, "description")); metaform_sel("Présence sur le territoire d'agrément du CBN", "", 30, $ref[$champ_ref["statutChorologie"]], "statutChorologie", "", pg_fetch_result(pg_query($db, $query_description . "'statutChorologie'" . ";"), 0, "description")); //metaform_sel ("Catalogue","",30,$ref[$champ_ref["idCatalogue"]],"idCatalogue",'', pg_fetch_result(pg_query ($db,$query_description."'idCatalogue'".";"),0,"description" )); echo "</fieldset>"; echo "<fieldset><LEGEND>Syntaxonomie</LEGEND>"; // metaform_text ("<b>Code de l'enregistrement*</b>"," ",30,"width:30em;","codeEnregistrementSyntax",sql_format_quote(pg_result($result,0,"\"codeEnregistrementSyntax\"" ),'undo_text'), pg_fetch_result(pg_query ($db,$query_description."'codeEnregistrementSyntax'".";"),0,"description" )); echo "<br>"; metaform_text("Identifiant du syntaxon", " ", 30, "width:30em;", "idSyntaxon", '', pg_fetch_result(pg_query($db, $query_description . "'idSyntaxon'" . ";"), 0, "description")); metaform_text("Nom scientifique", "", 30, "width:30em;", "nomSyntaxon", '', pg_fetch_result(pg_query($db, $query_description . "'nomSyntaxon'" . ";"), 0, "description"), '', "off"); metaform_text("Auteur", "", 30, "width:30em;", "auteurSyntaxon", '', pg_fetch_result(pg_query($db, $query_description . "'auteurSyntaxon'" . ";"), 0, "description"), '', "off"); metaform_text("Nom complet", " bloque", 30, "width:30em;", "nomCompletSyntaxon", '', pg_fetch_result(pg_query($db, $query_description . "'nomCompletSyntaxon'" . ";"), 0, "description")); metaform_sel("Rang syntaxon", "", "", $ref[$champ_ref["rangSyntaxon"]], "rangSyntaxon", '', pg_fetch_result(pg_query($db, $query_description . "'rangSyntaxon'" . ";"), 0, "description")); echo "</fieldset>"; /*------------------------------------------------------------------------------ SAVE */ echo "<div style=\"float:right;\"><br>"; echo "<button id=\"enregistrer2-add-button\">" . $lang[$lang_select]['enregistrer'] . "</button> "; echo "<button id=\"retour2-button\">" . $lang[$lang_select]['liste_taxons'] . "</button> "; echo "</div>"; echo "</form>"; echo "</div>"; echo "<div id=\"exit-confirm\" title=\"Retour\">"; echo "<p><span class=\"ui-icon ui-icon-alert\" style=\"float:left; margin:0 7px 20px 0;\"></span>" . $lang[$lang_select]['retour_dialog'] . "</p>"; echo "</div>"; echo "<div id=\"enregistrer-dialog\">"; echo "<center><img src=\"../../_GRAPH/check.png\" /><br>" . $lang[$lang_select]['enregistrer_dialog'] . "</center>"; echo "</div>";
pg_free_result($result3); if (pg_num_rows($result1)) { echo "<br>"; //------------------------------------------------------------------------------ echo "<fieldset><LEGEND>" . $lang[$lang_select]['groupe_lsi_1'] . "</LEGEND>"; metaform_text("Titre", null, 70, null, "title", sql_format_quote(pg_result($result1, 0, "title"), 'undo_text')); metaform_text("Date", null, 20, null, "date", sql_format_quote(pg_result($result1, 0, "date"), 'undo_text')); metaform_sel("Sujet", "", "", $subject, "id_subject", pg_result($result1, 0, "sub")); echo "<br>"; echo "<label class=\"preField\">Extrait</label><textarea name=\"abstract\" id=\"abstract\" cols=\"150\" rows=\"2\" />" . sql_format_quote(pg_result($result1, 0, "abstract"), 'undo') . "</textarea> "; echo "<br><br>"; metaform_sel_multi("TAG", "", 5, "width: 120px;", "OnDblClick='javascript: deplacer( this.form.tag, this.form.tag_select);' ", $tag, "tag", ""); metaform_sel_multi("TAG Selectionné(s)", "", 5, "width: 120px;", "OnDblClick='javascript: deplacer( this.form.tag_select, this.form.tag);'", $tag_select, "tag_select", ""); echo "<br><br>"; metaform_text("Lien hypertexte", null, 150, null, "link", sql_format_quote(pg_result($result1, 0, "link"), 'undo_text')); metaform_text("Lien hypertexte 2", null, 150, null, "link_2", sql_format_quote(pg_result($result1, 0, "link_2"), 'undo_text')); echo "</fieldset>"; //------------------------------------------------------------------------------ echo "<br>"; echo "<div style=\"float:right;\">"; if ($mode == "edit") { echo "<button id=\"enregistrer2-edit-button\";>" . $lang[$lang_select]['enregistrer'] . "</button> "; echo "<button id=\"retour2-button\">" . $lang[$lang_select]['lsi'] . "</button> "; } else { echo "<button id=\"retour4-button\">" . $lang[$lang_select]['retour'] . "</button> "; } echo "</div>"; echo "</form>"; echo "<div id=\"fiche\" >"; echo "<fieldset><LEGEND>Ajouter un tag</LEGEND>"; echo "<form method=\"POST\" id=\"form_add\" class=\"form_add\" name=\"edit\" action=\"\">";
metaform_text("Question A4", " bloque", "15", "", "indct_a4", $eval["ag4"]); metaform_text("Sous-total A", " bloque", "15", "", "ss_tot_a", $eval["ag"]); echo "<br>"; metaform_text("Question B5", " bloque", "15", "", "indct_b5", $eval["bg5"]); metaform_text("Question B6", " bloque", "15", "", "indct_b6", $eval["bg6"]); metaform_text("Question B7", " bloque", "15", "", "indct_b7", $eval["bg7"]); metaform_text("Question B8", " bloque", "15", "", "indct_b8", $eval["bg8"]); metaform_text("Sous-total B", " bloque", "15", "", "ss_tot_b", $eval["bg"]); echo "<br>"; metaform_text("Question C9", " bloque", "15", "", "indct_c9", $eval["cg9"]); metaform_text("Question C10", " bloque", "15", "", "indct_c10", $eval["cg10"]); metaform_text("Question C11", " bloque", "15", "", "indct_c11", $eval["cg11"]); metaform_text("Question C12", " bloque", "15", "", "indct_c12", $eval["cg12"]); metaform_text("Sous-total C", " bloque", "15", "", "ss_tot_c", $eval["cg"]); echo "<br>"; metaform_text("Total", " bloque", "15", "", "tot_indct", $eval["ag"] + $eval["bg"] + $eval["cg"]); echo "</td><td width = \"150\" align=\"center\">"; echo "<h3 style=\"margin-left:25px;margin-right:25px;\">Risques</h3>"; if ($eval["ag"] <= 5) { $eval_a = 'FAIBLE'; } else { $eval_a = 'FORT'; } metaform_text_area("", " no_lab bloque", "10", "50", "height:133;width:100;resize:none;", "eval_a", $eval_a); echo "<br>"; if ($eval["ag"] <= 7) { $eval_b = 'FAIBLE'; } else { $eval_b = 'FORT'; } metaform_text_area("", " no_lab bloque", "10", "50", "height:133;width:100;resize:none;", "eval_b", $eval_b);
echo "<td style=\"width: 350px;\">"; metaform_text("Code de l'enregistrement", " ", 20, "", "codeEnregistrementSyntax", sql_format_quote(pg_result($result, 0, "\"{$colname1}\""), 'undo_text'), pg_fetch_result(pg_query($db, $query_description . "'{$colname1}'" . ";"), 0, "description")); echo "</td><td>"; metaform_text("Identifiant du syntaxon", " bloque", 20, "", "idSyntaxon", pg_result($result, 0, "\"{$colname3}\""), pg_fetch_result(pg_query($db, $query_description . "'{$colname3}'" . ";"), 0, "description")); echo "</td><td>"; metaform_text("Identifiant du syntaxon retenu", " bloque", 20, "", "idSyntaxonRetenu", pg_result($result, 0, "\"{$colname10}\""), pg_fetch_result(pg_query($db, $query_description . "'{$colname10}'" . ";"), 0, "description")); echo "</td></tr></table>"; echo "<table border=0 width=\"100%\"><tr valign=top >"; echo "<td style=\"width: 800px;\">"; //metaform_text ("Code de l'enregistrement"," ",20,"","codeEnregistrementSyntax",sql_format_quote(pg_result($result,0,"\"$colname1\"" ),'undo_text')); metaform_text("Nom du syntaxon", "", 100, "", "nomSyntaxon", pg_result($result, 0, "\"{$colname2}\""), pg_fetch_result(pg_query($db, $query_description . "'{$colname2}'" . ";"), 0, "description")); metaform_text("Auteur du syntaxon", "", 100, "", "auteurSyntaxon", sql_format_quote(pg_result($result, 0, "\"{$colname4}\""), 'undo_text'), pg_fetch_result(pg_query($db, $query_description . "'{$colname4}'" . ";"), 0, "description")); metaform_text("Nom complet du syntaxon", " bloque", 100, "", "nomCompletSyntaxon", pg_result($result, 0, "\"{$colname5}\""), pg_fetch_result(pg_query($db, $query_description . "'{$colname5}'" . ";"), 0, "description")); metaform_text("Nom raccourcit", " bloque", 100, "", "nomSyntaxonRaccourci", pg_result($result, 0, "\"{$colname6}\""), pg_fetch_result(pg_query($db, $query_description . "'{$colname6}'" . ";"), 0, "description")); metaform_sel("Type de synonymie", "", 100, $ref[$champ_ref['typeSynonymie']], "typeSynonymie", pg_result($result, 0, "\"{$colname8}\""), pg_fetch_result(pg_query($db, $query_description . "'{$colname8}'" . ";"), 0, "description")); metaform_text("Nom syntaxon retenu", " bloque", 100, "", "nomSyntaxonRetenu", pg_result($result, 0, "\"{$colname9}\""), pg_fetch_result(pg_query($db, $query_description . "'{$colname9}'" . ";"), 0, "description")); echo "</td></tr></table>"; $tooltip = pg_fetch_result(pg_query($db, $query_description . "'{$colname7}'" . ";"), 0, "description"); echo "<br><label title= \"{$tooltip}\" class=\"preField\">Remarque nomenclaturale</label><textarea name=\"rqNomenclaturale\" style=\"width:70em;\" rows=\"2\" >" . sql_format_quote(pg_result($result, 0, "\"{$colname7}\""), 'undo_hmtl') . "</textarea><br><br>"; echo "<table border=0 width=\"100%\"><tr valign=top >"; echo "</td><td style=\"width:300px;\">"; //metaform_text ("Code REF."," bloque",8,"","cd_ref",pg_result($result,0,"cd_ref")); metaform_sel("Rang syntaxon", "", "", $ref[$champ_ref[$colname11]], "rangSyntaxon", pg_result($result, 0, "\"{$colname11}\""), pg_fetch_result(pg_query($db, $query_description . "'{$colname11}'" . ";"), 0, "description")); /* //bout de code a utiliser si on veut aller vers une fiche taxon dans refnat echo ("</td><td>"); if ($niveau >= 128) echo ("<a href = \"../refnat/index.php?m=edit&id=$id\" class=edit id=\"modif_taxon\" ><img src=\"../../_GRAPH/psuiv.gif\" title=\"Accès rapide Refnat\" ></a>"); */ echo "</td></tr></table>"; echo "</fieldset>"; /*------------------------------------------------------------------------------ EDIT fieldset2*/
echo "<div id=\"radio1\">"; echo "<fieldset style=\"width: 50%;\"><LEGEND>Connexion au serveur de base de données</LEGEND>"; echo "<table border=0 width=\"100%\"><tr valign=top >"; echo "<td style=\"width: 800px;\">"; metaform_text("Hôte", "", 50, "", "host", "localhost"); metaform_text("Port", "", 25, "", "port", 5432); metaform_text("Utilisateur admin", "", 50, "", "user", "postgres"); metaform_pw("Mot de passe admin", "", 50, "", "mdp", null); echo "</td></tr></table>"; echo "</fieldset>"; //------------------------------------------------------------------------------ EDIT LR GRP2 echo "<fieldset style=\"width: 50%;\"><LEGEND> Création de la base de données </LEGEND>"; echo "<table border=0 width=\"100%\"><tr valign=top >"; echo "<td style=\"width: 800px;\">"; metaform_text("Nom de la base", "", 50, "", "dbname", "codex"); metaform_text("Utilisateur codex", "", 50, "", "user_codex", null); metaform_pw("Mot de passe codex", "", 20, "", "mdp_codex", null); echo "</td></tr></table>"; echo "</fieldset>"; } //------------------------------------------------------------------------------ EDIT LR GRP3 echo "<fieldset style=\"width: 50%;\"><LEGEND> Choix des rubriques à installer </LEGEND>"; echo "<table border=0 width=\"100%\"><tr valign=top >"; echo "<td style=\"width: 800px;\">"; $rub_ok["refnat"] = 't'; foreach ($rub as $key => $val) { // if (file_exists("../../_SQL/bdd_codex_archi_".$key.".sql") == FALSE) $desc[$key] = " bloque"; metaform_bool($val, $desc[$key], $key, $rub_ok[$key]); // metaform_bool ($val,$desc[$key],$key."_data",$rub_ok[$key]); if ($key == 'refnat') { echo " * <i>L'installation de cette rubrique est <b>>à 2 minutes</b>, soyez patients</i>";
$result = pg_query($db, $query) or fatal_error("Erreur pgSQL : " . pg_result_error($result), false); $arr = pg_fetch_array($result, NULL, PGSQL_ASSOC); list($a, $m, $j) = explode("-", $arr["date_bug"]); $date_bug = $j . "/" . $m . "/" . $a; if (pg_num_rows($result)) { echo "<fieldset><LEGEND> Bug ou remarque </LEGEND>"; echo "<label class=\"preField_calc\">Type</label>"; echo "<select id=\"cat\" name=\"cat\" readonly disabled>"; for ($i = 0; $i < sizeof($cat_txt); $i++) { echo "<option value=\"{$i}\" " . ($i == pg_result($result, 0, "cat") ? "SELECTED" : "") . ">" . $cat_txt[$i] . "</option>"; } echo "</select><br>"; // echo ("<label class=\"preField\">Date</label><input type=\"text\" size=\"10\" maxlength=\"10\" value=\"".$date_bug."\" readonly /><br>"); metaform_text("Date", $desc, 10, null, "date", $arr["date_bug"]); // echo ("<label class=\"preField\">Auteur</label><input type=\"text\" size=\"40\" value=\"".$arr["nom"]." ".$arr["prenom"]."\" readonly /><br>"); metaform_text("Auteur", $desc, 40, "", "auteur", $arr["nom"] . " " . $arr["prenom"]); echo "<label class=\"preField_calc\">Rubrique</label><select id=\"id_rubrique\" name=\"id_rubrique\" readonly disabled>"; for ($i = 0; $i < sizeof($rubriques_txt); $i++) { echo "<option value=\"{$i}\" " . ($i == pg_result($result, 0, "id_rubrique") ? "SELECTED" : "") . ">" . $rubriques_txt[$i] . "</option>"; } echo "</select><br>"; echo "<label class=\"preField\">Description</label><textarea name=\"descr\" id=\"descr\" style=\"width:30em;\" rows=\"2\">" . sql_format_quote(pg_result($result, 0, "descr"), 'undo_hmtl') . "</textarea><br>"; echo "</fieldset>"; echo "<fieldset><LEGEND> Gestion (ADMIN.)</LEGEND>"; echo "<label class=\"preField\">Statut</label><select id=\"statut\" name=\"statut\" >"; for ($i = 0; $i < sizeof($statut_txt); $i++) { echo "<option value=\"{$i}\" " . ($i == pg_result($result, 0, "statut") ? "SELECTED" : "") . ">" . $statut_txt[$i] . "</option>"; } echo "</select><br>"; echo "<label class=\"preField\">Commentaire</label><textarea name=\"statut_descr\" id=\"statut_descr\" style=\"width:30em;\" rows=\"2\" >" . sql_format_quote(pg_result($result, 0, "statut_descr"), 'undo_hmtl') . "</textarea><br>"; echo "</fieldset>";
echo "<div id=\"radio2\">"; echo "<fieldset><LEGEND>Champ du FSD</LEGEND>"; metaform_text("uid", " bloque", 40, "", "uid", sql_format_quote($row["uid"], "undo")); // echo "<BR>"; metaform_text("Jeu de données", " bloque", 40, "", "typ_jdd", sql_format_quote($row["typ_jdd"], "undo")); // echo "<BR>"; metaform_text("Identifiant du champ", " bloque", 40, "", "cd_ddd", sql_format_quote($row["cd_ddd"], "undo")); echo "<BR>"; metaform_text("Ordre de la table", $desc, 10, "", "ordre_table", sql_format_quote($row["ordre_table"], "undo")); metaform_text("Code de la table", $desc, 40, "", "cd_table", sql_format_quote($row["cd_table"], "undo")); echo "<BR>"; metaform_text("Ordre du champ", $desc, 10, "", "ordre_champ", sql_format_quote($row["ordre_champ"], "undo")); metaform_text("Code du champ", $desc, 40, "", "cd_champ", sql_format_quote($row["cd_champ"], "undo")); echo "<BR>"; metaform_text("Obligation", $desc, 10, "", "obligation", sql_format_quote($row["obligation"], "undo")); metaform_text("Unicité", $desc, 10, "", "unicite", sql_format_quote($row["unicite"], "undo")); echo "<BR>"; echo "<label class=\"preField\">Règles de renseignement</label>"; echo "<textarea name=\"regle\" {$disa} style=\"width:80%;{$gris}\" rows=\"3\" >" . sql_format_quote($row["regle"], "undo") . "</textarea><br><br>"; // metaform_text ("Bonne pratique",$desc,60,"","regle",sql_format_quote($row["regle"],"undo")); echo "<BR>"; echo "</fieldset>"; echo "</div>"; } /* ------------------------------------------------------------------------------ EDIT catnat SAVE*/ echo "<div style=\"float:right;\"><br>"; if ($mode == "fsd") { echo "<button id=\"enregistrer2-edit-button\">" . $lang[$lang_select]['enregistrer'] . "</button> "; echo "<button id=\"retour2-button\">" . $lang[$lang_select]['liste_champ'] . "</button> "; } else { echo "<button id=\"retour4-button\">" . $lang[$lang_select]['retour'] . "</button> ";
metaform_text("Critère(s) EU", " bloque", 10, "", "just_euro", pg_result($result, 0, "just_euro")); echo "</td><td width=100>"; echo "<br>"; metaform_text("Cat synthèse régionale", " bloque", 10, "", "cat_synt_reg", $ref['categorie_final'][pg_result($result, 0, "cat_synt_reg")]); // metaform_text_calc ("Crit synthèse régionale","",10,"","just_synt_reg",$ref['categorie_final'][pg_result($result,0,"just_synt_reg")]); echo "<label class=\"preField_calc\">Crit synthèse régionale</label><textarea name=\"just_synt_reg\" size=10 readonly disabled cols=\"50\" rows=\"1\" style=\"height: 27px;background-color:#EFEFEF\">" . pg_result($result, 0, "just_synt_reg") . "</textarea><br><br>"; echo "</td><td width=100>"; echo "<br>"; metaform_text("Nb région(s) taxon présent", " bloque", 10, "", "nb_reg_presence", pg_result($result, 0, "nb_reg_presence")); metaform_text("Nb région(s) taxon évalué", " bloque", 10, "", "nb_reg_evalue", pg_result($result, 0, "nb_reg_evalue")); echo "</td></tr><tr valign=top ><td width=250>"; metaform_sel("<b>Catégorie initiale</b>", $desc2, null, $ref[$champ_ref['cat_ini']], "cat_ini", pg_result($result, 0, "cat_ini")); metaform_text("Critère(s) initiale", $desc2, 10, null, "just_ini", pg_result($result, 0, "just_ini")); echo "</td><td width=250>"; metaform_sel("<b>Catégorie fin</b>", $desc2, null, $ref[$champ_ref['cat_fin']], "cat_fin", pg_result($result, 0, "cat_fin")); metaform_text("Critère(s) fin", $desc2, 10, null, "just_fin", pg_result($result, 0, "just_fin")); echo "</td><td width=250>"; if ($niveau <= 64) { echo "<label class=\"preField_calc\">Explication eval</label>"; } else { echo "<label class=\"preField\">Explication eval</label>"; } if ($niveau <= 64) { echo "<textarea name=\"notes\" {$disa} style=\"width:30em;background-color: #EFEFEF;\" rows=\"2\" >" . sql_format_quote(pg_result($result, 0, "notes"), 'undo') . "</textarea><br><br>"; } else { echo "<textarea name=\"notes\" {$disa} style=\"width:30em;\" rows=\"2\" >" . sql_format_quote(pg_result($result, 0, "notes"), 'undo') . "</textarea><br><br>"; } echo "</td></tr></table><br>"; echo "<table border=0 width=\"100%\"><tr valign=top ><td width=250>"; metaform_sel("Ajustement", $desc2, null, $ref[$champ_ref['cd_ajustmt']], "cd_ajustmt", pg_result($result, 0, "cd_ajustmt")); echo "</td><td width=250>";
function les_boutons($array_bouton, $niveau, $lang, $schema, $test_cbn) { $db2 = sql_connect_hub(SQL_base_hub); echo "<div style=\"float:left;\" >"; foreach ($array_bouton as $val) { echo "<table border=0 width=\"100%\" id=\"action_bdd\">"; if ($niveau >= 255 or $niveau >= $val["niveau"] and ($val["cbn"] == FALSE or $val["cbn"] == TRUE and $test_cbn)) { /*Récupération de la date de dernière réalisation*/ $query = "SELECT max(date_log) FROM public.zz_log WHERE typ_log = 'hub_" . $val["id"] . "' AND lib_schema = '{$schema}';"; $result = pg_query($db2, $query) or fatal_error("Erreur pgSQL : " . pg_result_error($result), false); $row = pg_fetch_row($result); /*Button*/ echo "<tr valign=top ><td style=\"width: 150px;\">"; echo "<button id=\"" . $val["id"] . "_button\" value=\"" . $val["id"] . "\" name=\"" . $schema . "\">" . $lang['fr'][$val["id"]] . "</button> "; echo "</td><td>"; metaform_text($val["text"], " bloque", 15, "", $val["id"], substr($row[0], 0, -4)); /*dernière réalisation*/ echo "</td></tr>"; } echo "</table>"; } echo "</div>"; }
echo "<div id=\"radio1\">"; echo "<fieldset style=\"width: 50%;\"><LEGEND>Connexion au serveur de base de données</LEGEND>"; echo "<table border=0 width=\"100%\"><tr valign=top >"; echo "<td style=\"width: 800px;\">"; metaform_text("Hôte", "", 50, "", "host", $host); metaform_text("Port", "", 25, "", "port", $port); metaform_text("Utilisateur admin", "", 50, "", "user", $user); metaform_pw("Mot de passe admin", "", 50, "", "dbpass", $dbpass); echo "</td></tr></table>"; echo "</fieldset>"; //------------------------------------------------------------------------------ EDIT LR GRP2 echo "<fieldset style=\"width: 50%;\"><LEGEND> Création de la base de données </LEGEND>"; echo "<table border=0 width=\"100%\"><tr valign=top >"; echo "<td style=\"width: 800px;\">"; metaform_text("Nom de la base", "", 50, "", "bdd", $bdd); metaform_text("Utilisateur Appli", "", 50, "", "user_appli", $user_appli); metaform_pw("Mot de passe Appli", "", 20, "", "pass_appli", $pass_appli); echo "</td></tr></table>"; echo "</fieldset>"; } echo "</div>"; echo "</div></center>"; echo "<center><button id=\"install-button\">Lancer l'installation</button></center>"; echo "</form>"; break; /*-------------------------------------------------------------------------------------*/ /*Réalisation de l'installation--------------------------------------------------------*/ /*-------------------------------------------------------------------------------------*/ /*Réalisation de l'installation--------------------------------------------------------*/ case "install-set": echo "<div id=\"fiche\" >";
echo "</tr>"; /*reste du tableau*/ while ($row = pg_fetch_assoc($result)) { // var_dump($row); echo "<tr valign=top style=\"border-bottom:1pt solid #D0C5AA;\">"; foreach ($row as $field => $val) { $diff = ($row[$field] == $row_plus[$field] or $field == 'version') ? "" : "background-color:orange"; /*Gestion du changement*/ echo "<td style=\"text-align: center; {$diff}\">"; if ($row["version"] == "vRéseauCBN") { $field_inteface = $field; echo "<input type=\"hidden\" id=\"version\" value=\"vRéseauCBN\" />"; if ($field_inteface == 'version') { echo $row[$field]; } else { metaform_text($field, " no_lab {$desc}", "", "width:" . $length . "em;{$diff} ", $field_inteface, sql_format_quote($row[$field], 'undo_text')); } } else { $field_inteface = $field . "_taxref"; echo $row[$field]; } echo "</td>"; } echo "</tr>"; $row_plus = $row; } } else { $flag = 1; } echo "</table><br>"; }
foreach ($ref['statut'] as $type_stt => $lib_stt) { echo "<tr valign=top>"; echo "<td style=\" text-align: center;\tvertical-align: center;\">{$lib_stt}</td>"; foreach ($ref['region'] as $id_reg => $region) { if (empty($res_stt[$type_stt][$id_reg])) { echo "<td>"; if ($type_stt == 'RAR') { metaform_text("Rar", " no_lab bloque", "", "width:5.5em;", "rar", ""); } else { metaform_sel("", " no_lab bloque", "width:5em;", $liste_statut[$type_stt], $type_stt . "_" . $id_reg, ""); } echo "</td>"; } else { echo "<td>"; if ($type_stt == 'RAR') { metaform_text("Rar", " no_lab bloque", "", "width:5.5em;", "rar", sql_format_quote($res_stt[$type_stt][$id_reg], 'undo_text')); } else { metaform_sel("", " no_lab bloque", "width:5em;", $liste_statut[$type_stt], $type_stt . "_" . $id_reg, $res_stt[$type_stt][$id_reg]); } echo "</td>"; } } echo "</tr>"; } echo "</table><br>"; echo "</fieldset>"; echo "</div>"; /*------------------------------------------------------------------------------ EDIT catnat GRP3*/ echo "<div id=\"radio2\">"; echo "<fieldset><LEGEND> " . $lang[$lang_select]['groupe_catnat_3'] . "</LEGEND>"; $path = "../../_GRAPH/carte/";