Beispiel #1
0
         // 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) {
Beispiel #2
0
                 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 {