| 127,6 → 127,17 |
|---|
| } |
| // ATTENTION : idVote doit être récupéré avant toute nouvelle requete ! |
| $idVote = $this->bdd->recupererIdDernierAjout(); |
| |
| $requete = "UPDATE tb_new_cel.`occurrence` join |
| (SELECT ce_observation, id_commentaire, nom_sel_nn, `proposition_retenue` FROM `del_commentaire` WHERE id_commentaire = ".$idPropositionP.") c |
| on id = ce_observation AND user_sci_name_id= `nom_sel_nn` |
| SET `identiplante_score`= case |
| when ".$this->parametres['valeur']." = 0 and ".$idUtilisateurP." REGEXP '^-?[0-9]+$' then ifnull(identiplante_score, 0) -3 |
| when ".$this->parametres['valeur']." = 0 then ifnull(identiplante_score, 0) -1 |
| when ".$this->parametres['valeur']." = 1 and ".$idUtilisateurP." REGEXP '^-?[0-9]+$' then ifnull(identiplante_score, 0) + 3 |
| when ".$this->parametres['valeur']." = 1 then ifnull(identiplante_score, 0) + 1 END;"; |
| |
| $resultat = $this->bdd->executer($requete); |
| return $idVote; |
| } |
| |
| 221,6 → 232,17 |
|---|
| "idObs -> $idObsP, idProposition -> $idPropositionP et id_utilisateur -> $idUtilisateurP."; |
| throw new Exception($msg, RestServeur::HTTP_CODE_RESSOURCE_INTROUVABLE); |
| } |
| $requete = "UPDATE tb_new_cel.`occurrence` join |
| (SELECT ce_observation, id_commentaire, nom_sel_nn, `proposition_retenue` FROM `del_commentaire` WHERE id_commentaire = ".$idPropositionP.") c |
| on id = ce_observation AND user_sci_name_id= `nom_sel_nn` |
| SET `identiplante_score`= case |
| when ".$this->parametres['valeur']." = 0 and ".$idUtilisateurP." REGEXP '^-?[0-9]+$' then ifnull(identiplante_score, 0) -6 |
| when ".$this->parametres['valeur']." = 0 then ifnull(identiplante_score, 0) -2 |
| when ".$this->parametres['valeur']." = 1 and ".$idUtilisateurP." REGEXP '^-?[0-9]+$' then ifnull(identiplante_score, 0) + 6 |
| when ".$this->parametres['valeur']." = 1 then ifnull(identiplante_score, 0) + 2 END;"; |
| |
| $resultat = $this->bdd->executer($requete); |
| |
| return $resultat; |
| } |
| |