Exemple #1
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 {
Exemple #2
0
             $val_1 = "non";
         }
         $modif = check_modif($val_1, $val_2, $field);
         if (DEBUG) {
             echo $field . " -> " . $val_1 . "  | " . $val_2 . "<br>";
         }
         if ($modif != 'vide' and $modif != 'identiques') {
             add_suivi2($etape, $id_user, $id, "statut_nat", $field, $val_1, $val_2, 'catnat', 'manuel', $modif);
         }
     }
     pg_free_result($result);
     unset($val_1);
     unset($val_2);
     // if (isset($ref[$champ_ref["statut_".$type_stt]])) {$res_new = ;} else {$res_new = $new_val;}
     $indi = frt('indi', $ref[$champ_ref['indi']][$_POST['INDI']]);
     $query = "UPDATE catnat.statut_nat SET indi=" . $indi . ", lr=" . frt('lr', $_POST['LR']) . ", rarete=" . frt('rarete', $_POST['RAR']) . ", endemisme=" . frt('endemisme', $_POST['END']) . ", presence=" . frt('presence', $_POST['PRES']) . " WHERE uid = {$id};";
     if (DEBUG) {
         echo "<BR>{$query}";
     }
     $result = pg_query($db, $query) or die("Erreur pgSQL : " . $query);
 }
 if ($niveau >= 64) {
     /*Commentaires Taxon*/
     $query = "SELECT commentaire FROM catnat.taxons_nat WHERE uid=" . $id . ";";
     if (DEBUG) {
         echo "<br>" . $query;
     }
     $result = pg_query($db, $query) or die("Erreur pgSQL : " . $query);
     $backup = pg_fetch_array($result, NULL, PGSQL_ASSOC);
     foreach ($backup as $field => $val_1) {
         $val_2 = $_POST[$field];