Proyectos de Subversion LeadersLinked - Antes de SPA

    }

    /**

     *

     * @param int $knowledge_area_id

     * @return array

     */

    public function fetchCountContentReactionsByKnowledgeAreaId($knowledge_area_id)

    {

        $select = $this->sql->select(self::_TABLE);

        $select->columns(['total' => new Expression('COUNT(*)'), 'reaction']);

        $select->where->equalTo('knowledge_area_id', $knowledge_area_id);

        $select->group('reaction');

        return $this->executeFetchAllArray($select);

    /**

     *

     * @param int $knowledge_area_id

     * @param int $user_id

     * @return ContentReaction

     */

    public function fetchOneByKnowledgeAreaIdAndUserId($knowledge_area_id, $user_id)

    {

        $select = $this->sql->select(self::_TABLE);

        $select->where->equalTo('knowledge_area_id', $knowledge_area_id);

        $select->where->equalTo('user_id', $user_id);

        $select->where->equalTo('relational', ContentReaction::RELATIONAL_KNOWLEDGE_AREA);

        $prototype = new ContentReaction();

        return $this->executeFetchOneObject($select, $prototype);

    }

    }

    /**

     *

     * @param int $knowledge_area_id

     * @param int $user_id

     * @return boolean

     */

    public function deleteByKnowledgeAreaIdAndUserId($knowledge_area_id, $user_id)

    {

        $delete = $this->sql->delete(self::_TABLE);

        $delete->where->equalTo('knowledge_area_id', $knowledge_area_id);

        $delete->where->equalTo('user_id', $user_id);

        $delete->where->equalTo('relational', ContentReaction::RELATIONAL_KNOWLEDGE_AREA);

        return $this->executeDelete($delete);