Changeset 1429

Timestamp:

Sep 26, 2010, 4:02:16 PM (10 years ago)

Author:

teymour

Message:

Ajout des parlementaires dans les tags des commentaires

Location:

cpc/trunk/project

Files:

• config/doctrine/schema.yml (modified) (1 diff)
• lib/model/doctrine/Commentaire.class.php (modified) (1 diff)
• lib/model/doctrine/CommentaireObject.class.php (modified) (1 diff)
• lib/model/doctrine/CommentaireObjectTable.class.php (modified) (1 diff)

cpc/trunk/project/config/doctrine/schema.yml

@@ -402 +402 @@
     Solrable:
       description: [Citoyen, commentaire]
-      moretags: [Citoyen, object_type, object_id]
+      moretags: [Citoyen, object_type, object_id, Parlementaires]
       date: created_at
       index_if: is_public

cpc/trunk/project/lib/model/doctrine/Commentaire.class.php

@@ -81 +81 @@
   }
 
+  public function getParlementaires() {
+    return Doctrine::getTable('CommentaireObject')->getParlementaires($this->id);
+  }
+
   public function updateNbCommentaires($inc = 0) {
     if ($this->object_type) {

cpc/trunk/project/lib/model/doctrine/CommentaireObject.class.php

@@ -6 +6 @@
 class CommentaireObject extends BaseCommentaireObject
 {
-
 }

cpc/trunk/project/lib/model/doctrine/CommentaireObjectTable.class.php

@@ -24 +24 @@
   }
 
+  public function getParlementaires($commentaire_id) {
+    $pids = $this->createQuery('c')->select('object_id')->where('object_type = "Parlementaire"')->andWhere('commentaire_id = ?', $commentaire_id)->fetchArray();
+    $ids = array();
+    foreach ($pids as $id) {
+      array_push($ids, $id['object_id']);
+    }
+    print_r($ids);
+    return Doctrine::getTable('Parlementaire')->createQuery('p')->whereIn('p.id', $ids)->execute();
+  }
 }