| Line 449... |
Line 449... |
| 449 |
private function formaterDeterminations($propositions) {
|
449 |
private function formaterDeterminations($propositions) {
|
| 450 |
$propositions_format = array();
|
450 |
$propositions_format = array();
|
| 451 |
if ($propositions != array()) {
|
451 |
if ($propositions != array()) {
|
| 452 |
foreach ($propositions as $id => $proposition) {
|
452 |
foreach ($propositions as $id => $proposition) {
|
| 453 |
$propositions_format[$proposition['id_commentaire']] = $proposition;
|
453 |
$propositions_format[$proposition['id_commentaire']] = $proposition;
|
| - |
|
454 |
$propositions_format[$proposition['id_commentaire']]['nb_commentaires'] = "0";
|
| 454 |
$ids_proposition[] = $proposition['id_commentaire'];
|
455 |
$ids_proposition[] = $proposition['id_commentaire'];
|
| 455 |
}
|
456 |
}
|
| 456 |
$propositions_format = $this->chargerVotes($ids_proposition, $propositions_format);
|
457 |
$propositions_format = $this->chargerVotes($ids_proposition, $propositions_format);
|
| 457 |
$propositions_format = $this->chargerNombreCommentaire($ids_proposition, $propositions_format);
|
458 |
$propositions_format = $this->chargerNombreCommentaire($ids_proposition, $propositions_format);
|
| 458 |
}
|
459 |
}
|
| Line 477... |
Line 478... |
| 477 |
/**
|
478 |
/**
|
| 478 |
* Charger le nombre de commentaires (sans détermination) associé à l'observation
|
479 |
* Charger le nombre de commentaires (sans détermination) associé à l'observation
|
| 479 |
* @param Array $observations le tableau des observatins à mettre à jour
|
480 |
* @param Array $observations le tableau des observatins à mettre à jour
|
| 480 |
* */
|
481 |
* */
|
| 481 |
private function chargerNombreCommentaire($ids_proposition, $propositions) {
|
482 |
private function chargerNombreCommentaire($ids_proposition, $propositions) {
|
| 482 |
$requeteNbCommentaires = 'SELECT ce_proposition, COUNT('.$this->proteger('id_commentaire').') as nb '.
|
483 |
$requeteNbCommentaires = 'SELECT ce_proposition, COUNT(id_commentaire) as nb '.
|
| 483 |
'FROM '.$this->gestionBdd->formaterTable('del_commentaire').
|
484 |
'FROM del_commentaire '.
|
| 484 |
'WHERE ce_proposition IN ('.implode(', ', $ids_proposition).')';
|
485 |
'WHERE ce_proposition IN ('.implode(', ', $ids_proposition).')';
|
| - |
|
486 |
|
| 485 |
$nbCommentaires = $this->bdd->recuperer($requeteNbCommentaires);
|
487 |
$nbCommentaires = $this->bdd->recuperer($requeteNbCommentaires);
|
| 486 |
foreach ($nbCommentaires as $nbCommentaire) {
|
488 |
foreach ($nbCommentaires as $nbCommentaire) {
|
| - |
|
489 |
// ce test sert à exclure les proposition de 1er niveau qui sont elles aussi des commentaires
|
| - |
|
490 |
if($nbCommentaire['ce_proposition'] != null && $nbCommentaire['ce_proposition'] != 0) {
|
| 487 |
$propositions[$nbCommentaire['ce_proposition']]['nb_commentaires']= $nbCommentaire;
|
491 |
$propositions[$nbCommentaire['ce_proposition']]['nb_commentaires']= $nbCommentaire;
|
| - |
|
492 |
}
|
| 488 |
}
|
493 |
}
|
| 489 |
return $propositions;
|
494 |
return $propositions;
|
| 490 |
}
|
495 |
}
|
| Line 491... |
Line 496... |
| 491 |
|
496 |
|