Proyectos de Subversion LeadersLinked - Services

use LeadersLinked\Mapper\MicrolearningSlideMapper;

use LeadersLinked\Mapper\MicrolearningTopicCapsuleMapper;

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

    }

    /**

     * Fetch all progress data by user id and slide id

     * @param int $userId

     * @param int $slideId

     * @return MicrolearningUserProgress[]

     */

    public function fetchAllProgressDataByUserIdAndSlideId($userId, $slideId)

    {

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

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

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

    public function markSlideViewed($user_id, $topic_id, $capsule_id, $slide_id)

    {

        $data = [

            'user_id'    => $user_id,

            'topic_id'   => $topic_id,

            'slide_id'   => $slide_id,

            'viewed_at'  => date('Y-m-d H:i:s'),

        ];

        // Verifica si ya existe el registro

        $exists = $this->fetchOneByUserIdAndSlideId($user_id, $slide_id);

        if ($exists) {

            return; // ya registrado

        }

        return $this->insert($data);

    }

    public function markCapsuleCompleted($user_id, $topic_id, $capsule_id)

    {

        $data = [

            'user_id'       => $user_id,

            'topic_id'      => $topic_id,

            'capsule_id'    => $capsule_id,

            'completed_at'  => date('Y-m-d H:i:s'),

        ];

        // Verifica si ya existe algún progreso de cápsula

        $exists = $this->fetchOneByUserIdAndCapsuleId($user_id, $capsule_id);

        if ($exists) {

            return; // ya registrado

        }

        return $this->insert($data);

    }

    public function markTopicCompleted($user_id, $topic_id)

    {

        $data = [

            'user_id'      => $user_id,

            'topic_id'     => $topic_id,

            'topic_closed' => 1,

            'closed_at'    => date('Y-m-d H:i:s'),

        ];

        // Verifica si ya existe algún progreso de topic

        $exists = $this->fetchOneByUserIdAndTopicId($user_id, $topic_id);

        if ($exists) {

            return; // ya registrado

        }

        return $this->insert($data);

    }

    public function hasViewedAllSlidesInCapsule($user_id, $capsule_id)

    {

        $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);

        $allSlides = $slideMapper->fetchAllByCapsuleId($capsule_id);

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

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

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

        $select->where->equalTo('type', MicrolearningUserProgress::TYPE_SLIDE);

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

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

        return count($record) >= count($allSlides);

    }

    public function hasCompletedAllCapsulesInTopic($user_id, $topic_id)

    {

        $capsuleMapper = MicrolearningTopicCapsuleMapper::getInstance($this->adapter);

        $allCapsules = $capsuleMapper->fetchAllByTopicId($topic_id);

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

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

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

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