$result = pg_query($db, $update) or die("Erreur pgSQL : " . pg_result_error($result)); } // $query="UPDATE applications.liste_taxon SET nom_scien= ".frt("nom_sci",$_POST["nom_sci"]).", cd_ref= '".frt("cd_ref",$_POST["cd_ref"])."' WHERE uid = ".$id." AND rubrique_taxon = 'lr';"; // if (DEBUG) echo "<br>".$query; // $result=pg_query ($db,$query) or die ("Erreur pgSQL : ".pg_result_error ($result)); add_log("log", 5, $id_user, getenv("REMOTE_ADDR"), "Saisie edit fiche", $id, "lr"); } if ($niveau >= 64) { if (isset($_POST['commentaire_eval'])) { if (!empty($_POST['commentaire_eval'])) { $result = pg_query($db, $query_user . " AND id_user = '******'") or die("Erreur pgSQL : " . pg_result_error($result)); $user = pg_fetch_array($result, NULL, PGSQL_ASSOC); $insert = "INSERT INTO lr.discussion (uid,id_user,nom,prenom,id_cbn,commentaire_eval,datetime) \n\t\t\t\t\tVALUES ({$id},'{$user['id_user']}','{$user['nom']}','{$user['prenom']}',{$user['id_cbn']}," . sql_format_quote($_POST[commentaire_eval], 'do') . ",NOW())"; echo $insert; $result = pg_query($db, $insert) or die("Erreur pgSQL : " . pg_result_error($result)); add_suivi2($etape, $id_user, $id, "discussion", "commentaire_eval", "", sql_format_quote($_POST[commentaire_eval], 'do'), $id_page, 'manuel', "ajout"); } } } } else { /*Nothing ==> go Refnat*/ } /*Avancement*/ $query = "UPDATE lr.evaluation SET avancement = 2 WHERE uid = {$id};"; $result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result)); break; case "validation": $id = $_GET['id']; $class_valid = $_GET['class_valid']; $val_com = sql_format_quote($_GET['val_com'], 'do'); $id_user = $_SESSION['id_user'];
$values .= sql_format_num($_POST[$val['champ_interface']]) . ","; } } } $insert = "INSERT INTO fsd.ddd (" . rtrim($liste_champs, ',') . ") VALUES (" . rtrim($values, ',') . ") RETURNING uid"; /*INSERT*/ if (DEBUG) { echo "<br>" . $insert; } $result = pg_query($db, $insert) or die("Erreur pgSQL : " . pg_result_error($result)); $uid = pg_fetch_row($result); if (!empty($_POST['id_from'])) { $idfrominsert = null; foreach ($_POST['id_from'] as $id_from) { $idfrominsert .= "INSERT INTO fsd.lien_champs VALUES (" . $uid[0] . ",{$id_from})"; } if ($idfrominsert != null) { $result = pg_query($db, $idfrominsert) or die("Erreur pgSQL : " . pg_result_error($idfrominsert)); } } add_suivi2($etape, $id_user, $uid[0], "fsd.ddd", $field, '', '', $id_page, 'manuel', 'add'); /*Log*/ add_log("log", 5, $id_user, getenv("REMOTE_ADDR"), "Saisie edit fiche", $id, "fsd"); pg_free_result($result); } pg_close($db); return true; //------------------------------------------------------------------------------ SI PAS ACCES } else { require "../commun/access_denied.php"; }
if ($result == false) { hub_log($id, $fction); } /*erreur*/ unset($query); break; } } else { // ADD //------------------------------------------------------------------------------ Valeurs numériques if ($_POST['etape'] == "") { $_POST['etape'] = 2; } //------------------------------------------------------------------------------ /*Paramètre à ajouter*/ add_suivi2($_POST["etape"], $id_user, $uid, "taxons", "nom", null, sql_format_num($_POST["nom_sci"]), 'applications', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, $uid, "taxons", "uid", null, $uid, 'applications', 'manuel', 'ajout'); } /* if (!DEBUG) { echo ("<script language=\"javascript\" type=\"text/javascript\">"); echo ("window.location.replace ( \"index.php\")"); echo ("</script>"); } */ pg_close($db); return true; //------------------------------------------------------------------------------ SI PAS ACCES } else { require "../commun/access_denied.php"; }
$id_user = $_SESSION['id_user']; $id = $_POST['id']; //------------------------------------------------------------------------------ CONNEXION SERVEUR PostgreSQL $db = sql_connect(SQL_base); if (!$db) { fatal_error("Impossible de se connecter au serveur PostgreSQL.", false); } //------------------------------------------------------------------------------ MAIN if (!empty($id)) { $query = "UPDATE refnat.taxons\tSET {$id_page} = false"; $result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result)); add_suivi2(1, $id_user, $id, "taxons", 'uid', $id, null, $id_page, 'manuel', 'suppr'); add_log("log", 5, $id_user, getenv("REMOTE_ADDR"), "Suppression fiche", $id, "taxons,chorologie,evaluation"); } elseif (strlen($_POST['select']) > 0) { $pairs = explode("&", $_POST['select']); foreach ($pairs as $key => $value) { $id = ltrim($value, "id="); $where .= "uid=" . $id . " OR "; add_suivi2(1, $id_user, $id, "taxons", 'uid', $id, null, $id_page, 'manuel', 'suppr'); } $where = rtrim($where, "OR "); $query = "UPDATE refnat.taxons\tSET {$id_page} = false WHERE " . $where . ";"; $result = pg_query($db, $query) or die("Erreur pgSQL : " . $query); add_log("log", 5, $id_user, getenv("REMOTE_ADDR"), "Suppression multi fiches", $where, "taxons,chorologie,evaluation"); } pg_close($db); return true; //------------------------------------------------------------------------------ SI PAS ACCES } else { require "../commun/access_denied.php"; }
$id = $_POST['id']; //------------------------------------------------------------------------------ CONNEXION SERVEUR PostgreSQL $db = sql_connect(SQL_base); if (!$db) { fatal_error("Impossible de se connecter au serveur PostgreSQL.", false); } //------------------------------------------------------------------------------ MAIN if (!empty($id)) { $query = "UPDATE applications.taxons SET {$id_page} = false"; $result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result)); add_suivi2(1, $id_user, $id, "taxons", 'uid', $id, null, $id_page, 'manuel', 'suppr'); add_log("log", 5, $id_user, getenv("REMOTE_ADDR"), "Suppression fiche", $id, "taxons,chorologie,evaluation"); } elseif (strlen($_POST['select']) > 0) { $pairs = explode("&", $_POST['select']); foreach ($pairs as $key => $value) { $id = ltrim($value, "id="); $where .= "uid=" . $id . " OR "; add_suivi2(1, $id_user, $id, 'taxons_nat', 'uid', $id, null, 'catnat', 'manuel', 'suppr'); } $where = rtrim($where, "OR "); $query = "UPDATE applications.taxons\tSET {$id_page} = false WHERE " . $where . ";"; $result = pg_query($db, $query) or die("Erreur pgSQL : " . $query); add_suivi2(1, $id_user, $where, "taxons", "uid", $id, null, $id_page, 'manuel', 'suppr'); add_log("log", 5, $id_user, getenv("REMOTE_ADDR"), "Suppression multi fiches", $where, "taxons,chorologie,evaluation"); } pg_close($db); return true; //------------------------------------------------------------------------------ SI PAS ACCES } else { require "../commun/access_denied.php"; }
echo "<br> plusieurs cases cochées"; } $pairs = explode("&", str_replace('%5B%5D', '[]', $_POST['select'])); foreach ($pairs as $key => $value) { $id = ltrim($value, "id[]="); $where .= "\"codeEnregistrementSyntax\"='" . $id . "' OR "; $where2 .= "\"codeEnregistrement\"='" . $id . "' OR "; $where3 .= "\"codeEnregistrementSyntaxon\"='" . $id . "' OR "; add_suivi2(1, $id_user, sql_format_quote($id, 'do'), 'st_syntaxon', 'codeEnregistrementSyntax', $id, null, $id_page, 'manuel', 'suppr'); add_suivi2(1, $id_user, sql_format_quote($id, 'do'), 'st_chorologie', 'codeEnregistrement', $id, null, $id_page, 'manuel', 'suppr'); add_suivi2(1, $id_user, sql_format_quote($id, 'do'), "st_biblio", "codeEnregistrement", $id, null, $id_page, 'manuel', 'suppr'); add_suivi2(1, $id_user, sql_format_quote($id, 'do'), "st_correspondance_pvf", "codeEnregistrementSyntaxon", $id, null, $id_page, 'manuel', 'suppr'); add_suivi2(1, $id_user, sql_format_quote($id, 'do'), "st_correspondance_eunis", "codeEnregistrement", $id, null, $id_page, 'manuel', 'suppr'); add_suivi2(1, $id_user, sql_format_quote($id, 'do'), "st_correspondance_hic", "codeEnregistrement", $id, null, $id_page, 'manuel', 'suppr'); add_suivi2(1, $id_user, sql_format_quote($id, 'do'), "st_etage_veg", "codeEnregistrement", $id, null, $id_page, 'manuel', 'suppr'); add_suivi2(1, $id_user, sql_format_quote($id, 'do'), "st_etage_bioclim", "codeEnregistrement", $id, null, $id_page, 'manuel', 'suppr'); } $where = rtrim($where, "OR "); $where2 = rtrim($where2, "OR "); $where3 = rtrim($where3, "OR "); $query = "\n\tDELETE FROM syntaxa.st_syntaxon WHERE {$where};\n\tDELETE FROM syntaxa.st_chorologie WHERE {$where2};\n\tDELETE FROM syntaxa.st_biblio WHERE {$where2};\n\tDELETE FROM syntaxa.st_correspondance_pvf WHERE {$where3};\n\tDELETE FROM syntaxa.st_correspondance_eunis WHERE {$where2};\n\tDELETE FROM syntaxa.st_correspondance_hic WHERE {$where2};\n\tDELETE FROM syntaxa.st_etage_veg WHERE {$where2};\n\tDELETE FROM syntaxa.st_etage_bioclim WHERE {$where2};\n\t"; if (DEBUG) { echo "<br> effacé de st_syntaxon=" . $where; } if (DEBUG) { echo "<br> effacé de st_chorologie et biblio=" . $where2; } if (DEBUG) { echo "<br> effacé de st_correspondance_pvf where3=" . $where3; } echo $query;
//------------------------------------------------------------------------------ PARMS. $id = $_POST['id']; //------------------------------------------------------------------------------ CONNEXION SERVEUR PostgreSQL $db = sql_connect(SQL_base); if (!$db) { fatal_error("Impossible de se connecter au serveur PostgreSQL.", false); } //------------------------------------------------------------------------------ MAIN if (!empty($id)) { $query = "UPDATE refnat.taxons SET {$id_page} = false"; $result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result)); add_suivi2(1, $id_user, $id, "taxons_nat", 'uid', $id, null, $id_page, 'manuel', 'suppr'); add_log("log", 5, $id_user, getenv("REMOTE_ADDR"), "Suppression fiche", $id, "taxons,chorologie,evaluation"); } elseif (strlen($_POST['select']) > 0) { $pairs = explode("&", $_POST['select']); foreach ($pairs as $key => $value) { $id = ltrim($value, "id="); $where .= "uid=" . $id . " OR "; add_suivi2(1, $id_user, $id, 'taxons_nat', 'uid', $id, null, 'catnat', 'manuel', 'suppr'); } $where = rtrim($where, "OR "); $query = "UPDATE refnat.taxons SET {$id_page} = false WHERE " . $where . ";"; $result = pg_query($db, $query) or die("Erreur pgSQL : " . $query); add_log("log", 5, $id_user, getenv("REMOTE_ADDR"), "Suppression multi fiches", $where, "taxons,chorologie,evaluation"); } pg_close($db); return true; //------------------------------------------------------------------------------ SI PAS ACCES } else { require "../commun/access_denied.php"; }
if (!empty($_POST['idCatalogue2'])) { add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_catalogue_description", "identifiantCatalogue", null, $_POST["idCatalogue2"], 'syntaxa', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_catalogue_description", "libelleCatalogue", null, $_POST["libelleCatalogue2"], 'syntaxa', 'manuel', 'ajout'); } } else { echo "</br> pas d'insertion de nouveau catalogue dans st_catalogue_description"; } add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_syntaxon", "idCatalogue", null, $_POST["idCatalogue"], 'syntaxa', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_chorologie", "idTerritoire", null, $_POST["idTerritoireObligatoire"], 'syntaxa', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_chorologie", "idChorologie", null, $id_chrologie, 'syntaxa', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_chorologie", "statutChorologie", null, $_POST["statutChorologie"], 'syntaxa', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_syntaxon", "codeEnregistrementSyntax", null, $uid, 'syntaxa', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_syntaxon", "idSyntaxon", null, $_POST["idSyntaxon"], 'syntaxa', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_syntaxon", "nomSyntaxon", null, $_POST["nomSyntaxon"], 'syntaxa', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_syntaxon", "auteurSyntaxon", null, $_POST["auteurSyntaxon"], 'syntaxa', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_syntaxon", "nomCompletSyntaxon", null, $_POST['nomSyntaxon'] . " " . $_POST['auteurSyntaxon'], 'syntaxa', 'manuel', 'ajout'); add_suivi2($_POST["etape"], $id_user, sql_format_quote($uid, 'do'), "st_syntaxon", "rangSyntaxon", null, $_POST["rangSyntaxon"], 'syntaxa', 'manuel', 'ajout'); /* if (!DEBUG) { echo ("<script language=\"javascript\" type=\"text/javascript\">"); echo ("window.location.replace ( \"index.php\")"); echo ("</script>"); } */ } pg_close($db); return true; //------------------------------------------------------------------------------ SI PAS ACCES } else { require "../commun/access_denied.php"; }