Changeset 1157 for cpc/trunk/project/plugins

Timestamp:

Apr 13, 2010, 12:21:16 AM (11 years ago)

Author:

teymour

Message:

Debut de Solr

Location:

cpc/trunk/project/plugins

Files:

• sfDoctrineActAsTaggablePlugin-0.0.7.tgz (deleted)
• sfDoctrineActAsTaggablePlugin/lib/TaggableTemplate.class.php (modified) (1 diff)
• sfDoctrineActAsTaggablePlugin/sfDoctrineActAsTaggablePlugin-0.0.7.tgz (deleted)

cpc/trunk/project/plugins/sfDoctrineActAsTaggablePlugin/lib/TaggableTemplate.class.php

@@ -303 +303 @@
             else
             {
-                $q = Doctrine_Query::create()
-                  ->select('t.name')
-                  ->from('Tag t INDEXBY t.name, t.Tagging tg')
-                  ->where('tg.taggable_id = ?', $this->getInvoker()->id)
+                $q1 = Doctrine::getTable('Tagging')->createQuery('tg')
+                  ->select('tg.tag_id')
+                  ->where('tg.taggable_id = ?', $this->getInvoker()->id)
                   ->addWhere('tg.taggable_model = ?', get_class($this->getInvoker()))
                 ;
-
+                $ids = array();
+                foreach($q1->execute(array(), Doctrine::HYDRATE_ARRAY) as $i ){
+                        $ids[] = $i['id'];
+                }
+                $q = Doctrine::getTable('Tag')->createQuery('t')
+                  ->select('t.name')
+                  ->whereIn('t.id', $ids); 
                 $saved_tags = $q->execute(array(), Doctrine::HYDRATE_ARRAY);
                 $tags = array();