Proyectos de Subversion LeadersLinked - Services

    public function fetchAllByCapsuleId($capsule_id)

    {

        $prototype = new MicrolearningSlide();

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

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

        $select->order(['order', 'name']);

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

    }

    }

    /**

     * Get total count of slides by company ID and topic ID

     * @param int $companyId

     * @param int $topicId

     * @return int

     */

    public function fetchTotalCountByCompanyIdAndTopicId($companyId, $topicId)

    {

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

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

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

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

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

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

        return (int)$record['total'];