$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";
}
