chamilo / chamilo-lms

     * Get the number of users connected in chat

     * @return mixed

     */

    public function countUsersOnline()

    {

        $date = new DateTime(api_get_utc_datetime(), new DateTimeZone('UTC'));

        $date->modify('-5 seconds');

        $extraCondition = null;

        if ($this->groupId) {

            $extraCondition = 'AND ccc.toGroupId = '.intval($this->groupId);

        } else {

            $extraCondition = 'AND ccc.sessionId = '.intval($this->sessionId);

        }

        $number = Database::getManager()

            ->createQuery("

                SELECT COUNT(ccc.userId) FROM ChamiloCourseBundle:CChatConnected ccc

                WHERE ccc.lastConnection > :date AND ccc.cId = :course $extraCondition

            ")

            ->setParameters([

                'date' => $date,

                'course' => $this->courseId

            ])

            ->getSingleScalarResult();

        return intval($number);

    }

    /**

     * Check if a user is connected in course chat

     * @param int $userId

     * @return int

     */

    private function userIsConnected($userId)

    {

        $date = new DateTime(api_get_utc_datetime(), new DateTimeZone('UTC'));

        $date->modify('-5 seconds');

        $extraCondition = null;

        if ($this->groupId) {

            $extraCondition = 'AND ccc.toGroupId = '.intval($this->groupId);

        } else {

            $extraCondition = 'AND ccc.sessionId = '.intval($this->sessionId);

        }

        $number = Database::getManager()

            ->createQuery("

                SELECT COUNT(ccc.userId) FROM ChamiloCourseBundle:CChatConnected ccc

                WHERE ccc.lastConnection > :date AND ccc.cId = :course AND ccc.userId = :user $extraCondition

            ")

            ->setParameters([

                'date' => $date,

                'course' => $this->courseId,

                'user' => $userId

            ])

            ->getSingleScalarResult();

        return intval($number);

    }

    /**

     * Get the users online data