// if (DEBUG) echo ("<BR> $field -> $val_1 | $val_2");
if ($modif != 'vide' and $modif != 'identiques') {
add_suivi2($etape, $id_user, $id, "fsd." . $table, $field, $val_1, $val_2, $id_page, 'manuel', $modif);
}
}
/*UPDATE*/
$update = rtrim($update, ',') . " WHERE uid = " . $id . ";";
if (DEBUG) {
echo "<br>" . $update;
}
$result = pg_query($db, $update) or die("Erreur pgSQL : " . pg_result_error($result));
}
if ($type == 'ddd' and $niveau >= 128) {
/*les champs rattachées anciens*/
$query = "SELECT id_from FROM fsd.lien_champs WHERE uid={$id};";
$ligne = sql_assoc($query, true);
// var_dump($_POST['id_from_0']);
// var_dump($ligne['id_from']);
$supp = array_diff($ligne['id_from'], $_POST['id_from_0']);
$add = array_diff($_POST['id_from_0'], $ligne['id_from']);
// $modif = check_modif($ligne['id_from'],$_POST["id_from"],"id_from");
// if ($modif != 'vide' AND $modif != 'identiques') add_suivi2(null,$id_user,$id,"id_from","id_from",$ligne['id_from'],$_POST["id_from"],'fsd','manuel',$modif);
if (!empty($supp)) {
foreach ($supp as $field => $val) {
$query = $query . "DELETE FROM fsd.lien_champs WHERE (uid,id_from) = ({$id},{$val}); ";
}
// echo "<br>".$query;
$result = pg_query($db, $query) or die("Erreur pgSQL : " . $query);
}
if (!empty($add)) {
foreach ($add as $field => $val) {
add_suivi2($_POST["etape"], $id_user, $id, "evaluation", $field, $val_1_eval[$field], $val_2[$field], 'eee', 'manuel', $modif);
}
}
unset($val_1_eval);
unset($val_2);
}
if ($niveau >= 64) {
/*Commentaire sur le taxon*/
$ligne = sql_assoc("SELECT commentaire FROM eee.taxons WHERE uid= {$id};", true);
foreach ($ligne as $field => $val_1) {
$val_2 = $_POST[$field];
$modif = check_modif($val_1, $val_2, $field);
if ($modif != 'vide' and $modif != 'identiques') {
add_suivi2($_POST["etape"], $id_user, $id, "taxons", $field, $val_1, $val_2, 'eee', 'manuel', $modif);
/*Suivi*/
sql_assoc("UPDATE eee.taxons SET {$field} = " . frt($field, $val_2) . " WHERE uid={$id};", false);
}
}
/*Commentaire sur la fiche*/
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 eee.discussion (uid,id_user,nom,prenom,id_cbn,commentaire_eval,datetime) \n\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 {
