Proyectos de Subversion LeadersLinked - Antes de SPA

    }

    /**

     *

     * @param int $my_coach_answer_id

     * @return int

     */

    public function fetchCountByMyCoachAnswerId($my_coach_answer_id)

    {

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

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

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

        $select->where->equalTo('relational', Comment::RELATIONAL_MY_COACH);

        $select->where->equalTo('status', Feed::STATUS_PUBLISHED);

        $record = $this->executeFetchOneArray($select);

        return $record['total'];

    }

    /**

     *

     * @param int my_coach_question_id

     * @return int

     */

    public function fetchCountByMyCoachQuestionId($my_coach_question_id)

    {

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

        $selectIn->columns(['id']);

        $selectIn->where->equalTo('question_id', $my_coach_question_id);

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

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

        $select->where->in('my_coach_answer_id', $selectIn);

        $select->where->equalTo('relational', Comment::RELATIONAL_MY_COACH);

        $select->where->equalTo('status', Feed::STATUS_PUBLISHED);

        $record = $this->executeFetchOneArray($select);

        return $record['total'];

    }

    /**

     *

     * @param int $my_coach_answer_id

     * @return Comment[]

     */

    public function fetchAllPublishedByMyCoachAnswerId($my_coach_answer_id)

    {

        $prototype = new Comment();

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

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

        $select->where->equalTo('status', Feed::STATUS_PUBLISHED);

        $select->where->equalTo('relational', Comment::RELATIONAL_MY_COACH);

        $select->where->IsNull('parent_id');

        $select->order('added_on DESC');

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

    }