| 14,10 → 14,10 |
|---|
| * @see http://www.tela-botanica.org/wikini/eflore/wakka.php?wiki=ApiIdentiplante01Images |
| */ |
| |
| class VoteObservation { |
| private $conteneur; |
| private $gestionBdd; |
| private $bdd; |
| class VoteObservation extends RestService { |
| protected $conteneur; |
| protected $gestionBdd; |
| protected $bdd; |
| |
| public function __construct(Conteneur $conteneur = null) { |
| $this->conteneur = $conteneur == null ? new Conteneur() : $conteneur; |
| 38,10 → 38,10 |
|---|
| } |
| |
| public function ajouter($ressources, $parametres) { |
| $insertion = 'INSERT INTO `del`.`del_commentaire_vote` '. |
| '(`ce_proposition` , `ce_utilisateur` , `valeur` , `date`) '. |
| 'VALUES ('.$ressources[1].','.$parametres['utilisateur'].','. |
| $parametres['valeur'].', NOW());'; |
| $insertion = 'INSERT INTO del_commentaire_vote '. |
| '(ce_proposition , ce_utilisateur , valeur , date) '. |
| 'VALUES ('.$this->proteger($ressources[1]).','.$this->proteger($parametres['utilisateur']).','. |
| $this->proteger($parametres['valeur']).', NOW());'; |
| $resultatsVotes = $this->bdd->requeter($insertion); |
| if ($resultatsVotes == false) { |
| RestServeur::envoyerEnteteStatutHttp(RestServeur::HTTP_CODE_MAUVAISE_REQUETE); |
| 49,5 → 49,28 |
|---|
| RestServeur::envoyerEnteteStatutHttp(RestServeur::HTTP_CODE_CREATION_OK); |
| } |
| } |
| |
| public function modifier($ressources, $parametres) { |
| $modification = 'UPDATE del_commentaire_vote '. |
| 'SET valeur ='.$this->proteger($parametres['valeur']).', '. |
| 'date = NOW() '. |
| 'WHERE '. |
| 'ce_proposition = '.$this->proteger($ressources[1]).' AND '. |
| 'ce_utilisateur = '.$this->proteger($parametres['utilisateur']); |
| $resultatsVotes = $this->bdd->requeter($modification); |
| if ($resultatsVotes == false) { |
| RestServeur::envoyerEnteteStatutHttp(RestServeur::HTTP_CODE_MAUVAISE_REQUETE); |
| } else { |
| RestServeur::envoyerEnteteStatutHttp(RestServeur::HTTP_CODE_OK); |
| } |
| } |
| |
| protected function proteger($valeur) { |
| if (is_array($valeur)) { |
| return $this->bdd->protegerTableau($valeur); |
| } else { |
| return $this->bdd->proteger($valeur); |
| } |
| } |
| } |
| ?> |