UserResolver::findUserSessions() - Code Metrics - Inspection of "Add user avatar using the IllustrationRepository." - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( fc1588...7621d0 )

by Julito

created 2019-12-02 15:17 UTC

UserResolver::findUserSessions() F

↳ Parent: UserResolver

Complexity

Conditions	24
Paths	1080

Size

Total Lines	131
Code Lines	70

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	24
eloc	70
nc	1080
nop	1
dl	0
loc	131
rs	0
c	0
b	0
f	0

How to fix Long Method Complexity

<?php
/* For licensing terms, see /license.txt */

namespace Chamilo\GraphQlBundle\Resolver;

use Chamilo\CoreBundle\Entity\Course;
use Chamilo\GraphQlBundle\Traits\GraphQLTrait;
use Chamilo\UserBundle\Entity\User;
use Doctrine\Common\Collections\ArrayCollection;
use Overblog\GraphQLBundle\Definition\Argument;
use Symfony\Component\DependencyInjection\ContainerAwareInterface;

/**
 * Class UserResolver.
 *
 * @package Chamilo\GraphQlBundle\Resolver
 */
class UserResolver implements ContainerAwareInterface
{
    use GraphQLTrait;

    /**
     * @return string
     */
    public function getEmail(User $user)
    {
        $this->protectCurrentUserData($user);

        $showEmail = $this->settingsManager->getSetting('display.show_email_addresses') === 'true';

        if (!$showEmail) {
            return '';
        }

        return $user->getEmail();
    }

    /**
     * @return ArrayCollection
     */
    public function getMessages(User $user, Argument $args)
    {
        $this->protectCurrentUserData($user);

        return $user->getUnreadReceivedMessages($args['lastId']);
    }

    /**
     * @return array
     */
    public function getMessageContacts(User $user, Argument $args)
    {
        $this->protectCurrentUserData($user);

        if (strlen($args['filter']) < 3) {
            return [];
        }

        $usersRepo = $this->em->getRepository('ChamiloUserBundle:User');
        $users = $usersRepo->findUsersToSendMessage($user->getId(), $args['filter']);

        return $users;
    }

    /**
     * @return array
     */
    public function getCourses(User $user, Argument $args, \ArrayObject $context)
    {
        $context->offsetSet('session', null);

        $this->protectCurrentUserData($user);

        $coursesInfo = \CourseManager::get_courses_list_by_user_id($user->getId());
        $coursesRepo = $this->em->getRepository('ChamiloCoreBundle:Course');
        $courses = [];

        foreach ($coursesInfo as $courseInfo) {
            /** @var Course $course */
            $course = $coursesRepo->find($courseInfo['real_id']);

            if ($course) {
                $courses[] = $course;
            }
        }

        return $courses;
    }

    /**
     * @return array
     */
    public function getSessions(User $user)
    {
        $this->protectCurrentUserData($user);

        $sessionsId = $this->findUserSessions($user);

        if (empty($sessionsId)) {
            return [];
        }

        $qb = $this->em->createQueryBuilder();
        $result = $qb
            ->select('s')
            ->from('ChamiloCoreBundle:Session', 's')
            ->where(
                $qb->expr()->in('s.id', $sessionsId)
            )
            ->getQuery()
            ->getResult();

        return $result;
    }

    /**
     * @todo Based on UserManager::get_sessions_by_category. Review to integrate Symfony
     *
     * @return array
     */
    private function findUserSessions(User $user)
    {
        $allowOrder = api_get_configuration_value('session_list_order');
        $showAllSessions = api_get_configuration_value('show_all_sessions_on_my_course_page') === true;
        $orderBySettings = api_get_configuration_value('my_courses_session_order');

        $position = '';

        if ($allowOrder) {
            $position = ', s.position AS position ';
        }

        $now = api_get_utc_datetime(null, false, true);

        $dql = "SELECT DISTINCT
                    s.id,
                    s.accessEndDate AS access_end_date,
                    s.duration,
                    CASE WHEN s.accessEndDate IS NULL THEN 1 ELSE 0 END HIDDEN _isFieldNull
                    $position
                FROM ChamiloCoreBundle:Session AS s
                LEFT JOIN ChamiloCoreBundle:SessionRelCourseRelUser AS scu WITH scu.session = s
                INNER JOIN ChamiloCoreBundle:AccessUrlRelSession AS url WITH url.session = s.id
                LEFT JOIN ChamiloCoreBundle:SessionCategory AS sc WITH s.category = sc
                WHERE (scu.user = :user OR s.generalCoach = :user) AND url.url = :url";

        $order = "ORDER BY sc.name, s.name";

        if ($showAllSessions) {
            $order = "ORDER BY s.accessStartDate";
        }

        if ($allowOrder) {
            $order = "ORDER BY s.position";
        }

        if (!empty($orderBySettings) && isset($orderBySettings['field']) && isset($orderBySettings['order'])) {
            $field = $orderBySettings['field'];
            $orderSetting = $orderBySettings['order'];

            switch ($field) {
                case 'start_date':
                    $order = "ORDER BY s.accessStartDate $orderSetting";
                    break;
                case 'end_date':
                    $order = " ORDER BY s.accessEndDate $orderSetting ";
                    if ($orderSetting == 'asc') {
                        // Put null values at the end
                        // https://stackoverflow.com/questions/12652034/how-can-i-order-by-null-in-dql
                        $order = "ORDER BY _isFieldNull asc, s.accessEndDate asc";
                    }
                    break;
            }
        }

        $results = [];
        $rows = $this->em
            ->createQuery("$dql $order")
            ->setParameters(
                [
                    'user' => $user->getId(),
                    'url' => api_get_current_access_url_id(),
                ]
            )
            ->getResult();

        foreach ($rows as $row) {
            $coachList = \SessionManager::getCoachesBySession($row['id']);
            $courseList = \UserManager::get_courses_list_by_session(
                $user->getId(),
                $row['id']
            );
            $daysLeft = \SessionManager::getDayLeftInSession(
                ['id' => $row['id'], 'duration' => $row['duration']],
                $user->getId()
            );
            $isGeneralCoach = \SessionManager::user_is_general_coach($user->getId(), $row['id']);
            $isCoachOfCourse = in_array($user->getId(), $coachList);

            if (!$isGeneralCoach && !$isCoachOfCourse) {
                // Teachers can access the session depending in the access_coach date
                if ($row['duration']) {
                    if ($daysLeft <= 0) {
                        continue;
                    }
                } else {
                    if (isset($row['access_end_date']) && !empty($row['access_end_date'])) {
                        if ($row['access_end_date'] <= $now) {
                            continue;
                        }
                    }
                }
            }

            $visibility = api_get_session_visibility($row['id'], null, false);

            if ($visibility != SESSION_VISIBLE) {
                // Course Coach session visibility.
                $blockedCourseCount = 0;
                $closedVisibilityList = [COURSE_VISIBILITY_CLOSED, COURSE_VISIBILITY_HIDDEN];
                $sessionCourseVisibility = SESSION_INVISIBLE;

                foreach ($courseList as $course) {
                    // Checking session visibility
                    $sessionCourseVisibility = api_get_session_visibility(
                        $row['id'],
                        $course['real_id'],
                        false
                    );

                    $courseIsVisible = !in_array($course['visibility'], $closedVisibilityList);

                    if ($courseIsVisible === false || $sessionCourseVisibility == SESSION_INVISIBLE) {
                        $blockedCourseCount++;
                    }
                }

                // If all courses are blocked then no show in the list.
                if ($blockedCourseCount !== count($courseList)) {
                    $visibility = $sessionCourseVisibility;
                }
            }

            if ($visibility == SESSION_INVISIBLE) {
                continue;
            }

            $results[] = $row['id'];
        }

        return $results;
    }
}


1			<?php
2			/* For licensing terms, see /license.txt */
3
4			namespace Chamilo\GraphQlBundle\Resolver;
5
6			use Chamilo\CoreBundle\Entity\Course;
7			use Chamilo\GraphQlBundle\Traits\GraphQLTrait;
8			use Chamilo\UserBundle\Entity\User;
9			use Doctrine\Common\Collections\ArrayCollection;
10			use Overblog\GraphQLBundle\Definition\Argument;
11			use Symfony\Component\DependencyInjection\ContainerAwareInterface;
12
13			/**
14			* Class UserResolver.
15			*
16			* @package Chamilo\GraphQlBundle\Resolver
17			*/
18			class UserResolver implements ContainerAwareInterface
19			{
20			use GraphQLTrait;
21
22			/**
23			* @return string
24			*/
25			public function getEmail(User $user)
26			{
27			$this->protectCurrentUserData($user);
28
29			$showEmail = $this->settingsManager->getSetting('display.show_email_addresses') === 'true';
30
31			if (!$showEmail) {
32			return '';
33			}
34
35			return $user->getEmail();
36			}
37
38			/**
39			* @return ArrayCollection
40			*/
41			public function getMessages(User $user, Argument $args)
42			{
43			$this->protectCurrentUserData($user);
44
45			return $user->getUnreadReceivedMessages($args['lastId']);
46			}
47
48			/**
49			* @return array
50			*/
51			public function getMessageContacts(User $user, Argument $args)
52			{
53			$this->protectCurrentUserData($user);
54
55			if (strlen($args['filter']) < 3) {
56			return [];
57			}
58
59			$usersRepo = $this->em->getRepository('ChamiloUserBundle:User');
60			$users = $usersRepo->findUsersToSendMessage($user->getId(), $args['filter']);
61
62			return $users;
63			}
64
65			/**
66			* @return array
67			*/
68			public function getCourses(User $user, Argument $args, \ArrayObject $context)
69			{
70			$context->offsetSet('session', null);
71
72			$this->protectCurrentUserData($user);
73
74			$coursesInfo = \CourseManager::get_courses_list_by_user_id($user->getId());
75			$coursesRepo = $this->em->getRepository('ChamiloCoreBundle:Course');
76			$courses = [];
77
78			foreach ($coursesInfo as $courseInfo) {
79			/** @var Course $course */
80			$course = $coursesRepo->find($courseInfo['real_id']);
81
82			if ($course) {
83			$courses[] = $course;
84			}
85			}
86
87			return $courses;
88			}
89
90			/**
91			* @return array
92			*/
93			public function getSessions(User $user)
94			{
95			$this->protectCurrentUserData($user);
96
97			$sessionsId = $this->findUserSessions($user);
98
99			if (empty($sessionsId)) {
100			return [];
101			}
102
103			$qb = $this->em->createQueryBuilder();
104			$result = $qb
105			->select('s')
106			->from('ChamiloCoreBundle:Session', 's')
107			->where(
108			$qb->expr()->in('s.id', $sessionsId)
109			)
110			->getQuery()
111			->getResult();
112
113			return $result;
114			}
115
116			/**
117			* @todo Based on UserManager::get_sessions_by_category. Review to integrate Symfony
118			*
119			* @return array
120			*/
121			private function findUserSessions(User $user)
122			{
123			$allowOrder = api_get_configuration_value('session_list_order');
124			$showAllSessions = api_get_configuration_value('show_all_sessions_on_my_course_page') === true;
125			$orderBySettings = api_get_configuration_value('my_courses_session_order');
126
127			$position = '';
128
129			if ($allowOrder) {
130			$position = ', s.position AS position ';
131			}
132
133			$now = api_get_utc_datetime(null, false, true);
134
135			$dql = "SELECT DISTINCT
136			s.id,
137			s.accessEndDate AS access_end_date,
138			s.duration,
139			CASE WHEN s.accessEndDate IS NULL THEN 1 ELSE 0 END HIDDEN _isFieldNull
140			$position
141			FROM ChamiloCoreBundle:Session AS s
142			LEFT JOIN ChamiloCoreBundle:SessionRelCourseRelUser AS scu WITH scu.session = s
143			INNER JOIN ChamiloCoreBundle:AccessUrlRelSession AS url WITH url.session = s.id
144			LEFT JOIN ChamiloCoreBundle:SessionCategory AS sc WITH s.category = sc
145			WHERE (scu.user = :user OR s.generalCoach = :user) AND url.url = :url";
146
147			$order = "ORDER BY sc.name, s.name";
148
149			if ($showAllSessions) {
150			$order = "ORDER BY s.accessStartDate";
151			}
152
153			if ($allowOrder) {
154			$order = "ORDER BY s.position";
155			}
156
157			if (!empty($orderBySettings) && isset($orderBySettings['field']) && isset($orderBySettings['order'])) {
158			$field = $orderBySettings['field'];
159			$orderSetting = $orderBySettings['order'];
160
161			switch ($field) {
162			case 'start_date':
163			$order = "ORDER BY s.accessStartDate $orderSetting";
164			break;
165			case 'end_date':
166			$order = " ORDER BY s.accessEndDate $orderSetting ";
167			if ($orderSetting == 'asc') {
168			// Put null values at the end
169			// https://stackoverflow.com/questions/12652034/how-can-i-order-by-null-in-dql
170			$order = "ORDER BY _isFieldNull asc, s.accessEndDate asc";
171			}
172			break;
173			}
174			}
175
176			$results = [];
177			$rows = $this->em
178			->createQuery("$dql $order")
179			->setParameters(
180			[
181			'user' => $user->getId(),
182			'url' => api_get_current_access_url_id(),
183			]
184			)
185			->getResult();
186
187			foreach ($rows as $row) {
188			$coachList = \SessionManager::getCoachesBySession($row['id']);
189			$courseList = \UserManager::get_courses_list_by_session(
190			$user->getId(),
191			$row['id']
192			);
193			$daysLeft = \SessionManager::getDayLeftInSession(
194			['id' => $row['id'], 'duration' => $row['duration']],
195			$user->getId()
196			);
197			$isGeneralCoach = \SessionManager::user_is_general_coach($user->getId(), $row['id']);
198			$isCoachOfCourse = in_array($user->getId(), $coachList);
199
200			if (!$isGeneralCoach && !$isCoachOfCourse) {
201			// Teachers can access the session depending in the access_coach date
202			if ($row['duration']) {
203			if ($daysLeft <= 0) {
204			continue;
205			}
206			} else {
207			if (isset($row['access_end_date']) && !empty($row['access_end_date'])) {
208			if ($row['access_end_date'] <= $now) {
209			continue;
210			}
211			}
212			}
213			}
214
215			$visibility = api_get_session_visibility($row['id'], null, false);
216
217			if ($visibility != SESSION_VISIBLE) {
218			// Course Coach session visibility.
219			$blockedCourseCount = 0;
220			$closedVisibilityList = [COURSE_VISIBILITY_CLOSED, COURSE_VISIBILITY_HIDDEN];
221			$sessionCourseVisibility = SESSION_INVISIBLE;
222
223			foreach ($courseList as $course) {
224			// Checking session visibility
225			$sessionCourseVisibility = api_get_session_visibility(
226			$row['id'],
227			$course['real_id'],
228			false
229			);
230
231			$courseIsVisible = !in_array($course['visibility'], $closedVisibilityList);
232
233			if ($courseIsVisible === false \|\| $sessionCourseVisibility == SESSION_INVISIBLE) {
234			$blockedCourseCount++;
235			}
236			}
237
238			// If all courses are blocked then no show in the list.
239			if ($blockedCourseCount !== count($courseList)) {
240			$visibility = $sessionCourseVisibility;
241			}
242			}
243
244			if ($visibility == SESSION_INVISIBLE) {
245			continue;
246			}
247
248			$results[] = $row['id'];
249			}
250
251			return $results;
252			}
253			}
254

chamilo / chamilo-lms

Push — master ( fc1588...7621d0 )

UserResolver::findUserSessions() F

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like