| 383,6 → 383,7 |
|---|
| $requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' '; |
| $requeteLiaisons .= $this->gestionBdd->getLimitSql(); |
| |
| |
| return $this->bdd->recupererTous($requeteLiaisons); |
| } |
| |
| 447,6 → 448,7 |
|---|
| } |
| |
| private function formaterDeterminations($propositions) { |
| |
| $propositions_format = array(); |
| if ($propositions != array()) { |
| foreach ($propositions as $id => $proposition) { |
| 454,8 → 456,10 |
|---|
| $propositions_format[$proposition['id_commentaire']]['nb_commentaires'] = "0"; |
| $ids_proposition[] = $proposition['id_commentaire']; |
| } |
| |
| $propositions_format = $this->chargerVotes($ids_proposition, $propositions_format); |
| $propositions_format = $this->chargerNombreCommentaire($ids_proposition, $propositions_format); |
| |
| } |
| return $propositions_format; |
| } |
| 483,14 → 487,14 |
|---|
| $requeteNbCommentaires = 'SELECT ce_proposition, COUNT(id_commentaire) as nb '. |
| 'FROM del_commentaire '. |
| 'WHERE ce_proposition IN ('.implode(', ', $ids_proposition).')'; |
| |
| $nbCommentaires = $this->bdd->recuperer($requeteNbCommentaires); |
| foreach ($nbCommentaires as $nbCommentaire) { |
| // ce test sert à exclure les proposition de 1er niveau qui sont elles aussi des commentaires |
| if($nbCommentaire['ce_proposition'] != null && $nbCommentaire['ce_proposition'] != 0) { |
| $propositions[$nbCommentaire['ce_proposition']]['nb_commentaires']= $nbCommentaire; |
| $propositions[$nbCommentaires['ce_proposition']]['nb_commentaires']= $nbCommentaire; |
| } |
| } |
| |
| return $propositions; |
| } |
| |