Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 1929 | Rev 1980 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 1929 Rev 1930
Línea 141... Línea 141...
141 
    }
 141 
    }
142 
    public function fetchFiveForoJoinTopic($group_id,$topic_type)
 142 
    public function fetchFiveForoJoinTopic($group_id,$topic_type)
143 
    {
 143 
    {
144 
        $prototype = new Feed();
 144 
        $prototype = new Feed();
145 
        $select = $this->sql->select();
 145 
        $select = $this->sql->select();
146 
        $select->from(['t' => TopicMapper::_TABLE]);
 146 
        $select->from(['f' => self::_TABLE]);
147 
        $select->join(['f' => self::_TABLE], 't.id = f.topic_id ', []);
 147 
        $select->join(['t' => TopicMapper::_TABLE], 't.id = f.topic_id ', []);
148 
        $select->where->equalTo('f.high_performance_group_id', $group_id);
 148 
        $select->where->equalTo('f.high_performance_group_id', $group_id);
149 
        $select->where->equalTo('f.status', Feed::STATUS_PUBLISHED);
 149 
        $select->where->equalTo('f.status', Feed::STATUS_PUBLISHED);
150 
        $select->where->equalTo('f.type', Feed::TYPE_HPTG);
 150 
        $select->where->equalTo('f.type', Feed::TYPE_HPTG);
151 
        $select->where->equalTo('t.type', $topic_type);
 151 
        $select->where->equalTo('t.type', $topic_type);
152 
        $select->where->equalTo('t.status', Topic::STATUS_ACTIVE);
 152 
        $select->where->equalTo('t.status', Topic::STATUS_ACTIVE);