Proyectos de Subversion LeadersLinked - Services

     * @param int $user_id

     * @param int[] $capsule_ids

     * @return CompanyMicrolearningUserProgress

     */

    public function fetchOneLastCapsuleInProgressByUserIdAndCapsuleIds($user_id, $capsule_ids)

    {

        $capsule_ids = empty($capsule_ids) ? [0] : $capsule_ids;

        $prototype = new CompanyMicrolearningUserProgress();

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

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

        $select->where->in('capsule_id', $capsule_ids);

        $select->where->greaterThan('progress', 0);

        $select->where->lessThan('progress', 100);

        $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);

        $select->order('updated_on');

        $select->limit(1);

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

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

    }

    /**

     *

    /**

     *

     * @param int $user_id

     * @param int $topic_id

     * @return int

     */

    public function  fetchCountCapsulesStartedByIdAndTopicId($user_id, $topic_id)

    {

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

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

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

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

        $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);

        $select->where->greaterThan('progress', 0);

        $select->where->lessThan('progress', 100);

        $select->where->equalTo('completed', 0);

        $select->limit(1);

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

        return $record['total'];

    }

    /**

     *

     * @param int $user_id

     * @param int $topic_id

     * @return int

     */

    public function  fetchCountCapsulesCompletedByIdAndTopicId($user_id, $topic_id)

    {

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

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

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

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

        $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);

        $select->where->equalTo('completed', 1);

        $select->limit(1);

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

        return $record['total'];

    }

    /**

     *

     * @param int $user_id

     * @param int $topic_id

     * @return int

     */

    public function fetchCountCapsulesCompletedWithReturningByIdAndTopicId($user_id, $topic_id)

    {

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

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

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

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

        $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);

        $select->where->equalTo('completed', 1);

        $select->where->notEqualTo('returning_after_completed', 0);

        $select->limit(1);

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

        return $record['total'];

    }

    /**

     *

     * @param int $user_id

     * @param int $topic_id

     * @return int

     */

    public function fetchCountCapsulesCompletedWithoutReturningByIdAndTopicId($user_id, $topic_id)

    {

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

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

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

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

        $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);

        $select->where->equalTo('completed', 1);

        $select->where->equalTo('returning_after_completed', 0);

        $select->limit(1);

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

        return $record['total'];

    }