127,17 → 127,6 |
} |
// 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; |
} |
|
232,17 → 221,6 |
"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; |
} |
|