Proyectos de Subversion LeadersLinked - Antes de SPA

    }

    /**

     *

     * @param int $company_id

     * @param int $topic_id

     * @param int $capsule_id

     * return int

     */

    public function fetchCountByCompanyIdAndTopicIdAndCapsuleId($company_id, $topic_id, $capsule_id)

    {

        $select = $this->sql->select();

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

        $select->from(self::_TABLE);

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

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

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

        //echo $select->getSqlString($this->adapter->platform); exit;

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

        return $record['total'];