QueryTrait - Code Metrics - Inspection of "Misc: update sessions db table" - satrun77/tinyissue - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( d1af83...ae4f91 )

by Mohamed

created 2016-01-12 03:13 UTC

QueryTrait A

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	70
Duplicated Lines	10 %

Coupling/Cohesion

Components	2
Dependencies	0

Test Coverage

Coverage

100%

Importance

Changes	4
Bugs	0	Features	0

Metric	Value
wmc	6
c	4
b	0
f	0
lcom	2
cbo	0
dl	7
loc	70
ccs	22
cts	22
cp	1
rs	10

4 Methods

Rating	Name	Duplication	Size	Complexity
A	projectsWidthActivities()	0	10	1
A	projectsWidthIssues()	7	16	2
A	loadPermissions()	0	8	2
A	activeUsers()	0	6	1

How to fix Duplicated Code

<?php

/*
 * This file is part of the Tinyissue package.
 *
 * (c) Mohamed Alsharaf <[email protected]>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Tinyissue\Model\Traits\User;

use Illuminate\Database\Eloquent;
use Illuminate\Database\Eloquent\Relations;
use Tinyissue\Model\Project;

/**
 * QueryTrait is trait class containing the database queries methods for the User model
 *
 * @author Mohamed Alsharaf <[email protected]>
 *
 * @property int                 $id
 * @property Eloquent\Collection $permission
 *
 * @method   Relations\HasMany projects($status = Project::STATUS_OPEN)
 * @method   Relations\HasMany permissions()
 */
trait QueryTrait
{
    /**
     * Returns public users
     *
     * @return Eloquent\Collection
     */
    public function activeUsers()
    {
        return $this->with('role')
trait Idable {
    public function equalIds(Idable $other) {
        return $this->getId() === $other->getId();
    }
}
            ->where('private', '=', false)
            ->orderBy('firstname', 'ASC')->get();
    }

    /**
     * Returns user projects with activities details eager loaded
     *
     * @param int $status
     *
     * @return Relations\HasMany
     */
    public function projectsWidthActivities($status = Project::STATUS_OPEN)
    {
        return $this->projects($status)
            ->with([
                'activities' => function (Relations\Relation $query) {
                    $query->with('activity', 'issue', 'user', 'assignTo', 'comment', 'note');
                    $query->orderBy('created_at', 'DESC');
                },
            ]);
    }

    /**
     * Returns projects with issues details eager loaded
     *
     * @param int $status
     *
     * @return Relations\HasMany
     */
    public function projectsWidthIssues($status = Project::STATUS_OPEN)
    {
        return $this
            ->projects($status)
            ->with([
                'issues' => function (Relations\Relation $query) use ($status) {

                    $query->with('updatedBy');
                    $query->where('assigned_to', '=', $this->id);
                    if ($status === Project::STATUS_OPEN) {
                        $query->where('status', '=', Project\Issue::STATUS_OPEN);
                    }
                },
                'issues.user'          => function () {},
                'issues.countComments' => function () {},
            ]);
    }

    /**
     * Load user permissions
     *
     * @return Eloquent\Collection
     */
    protected function loadPermissions()
    {
        if (null === $this->permission) {
            $this->permission = $this->permissions()->with('permission')->get();
        }

        return $this->permission;
    }
}


1			<?php
2
3			/*
4			* This file is part of the Tinyissue package.
5			*
6			* (c) Mohamed Alsharaf <[email protected]>
7			*
8			* For the full copyright and license information, please view the LICENSE
9			* file that was distributed with this source code.
10			*/
11
12			namespace Tinyissue\Model\Traits\User;
13
14			use Illuminate\Database\Eloquent;
15			use Illuminate\Database\Eloquent\Relations;
16			use Tinyissue\Model\Project;
17
18			/**
19			* QueryTrait is trait class containing the database queries methods for the User model
20			*
21			* @author Mohamed Alsharaf <[email protected]>
22			*
23			* @property int $id
24			* @property Eloquent\Collection $permission
25			*
26			* @method Relations\HasMany projects($status = Project::STATUS_OPEN)
27			* @method Relations\HasMany permissions()
28			*/
29			trait QueryTrait
30			{
31			/**
32			* Returns public users
33			*
34			* @return Eloquent\Collection
35			*/
36	4		public function activeUsers()
37			{
38	4		return $this->with('role')
			0 ignored issues – show Bug introduced 2016-01-10 07:09 UTC by Report Bug Copy Issue Report It seems like `with()` must be provided by classes using this trait. How about adding it as abstract method to this trait? This check looks for methods that are used by a trait but not required by it. To illustrate, let’s look at the following code example trait Idable { public function equalIds(Idable $other) { return $this->getId() === $other->getId(); } } The trait `Idable` provides a method `equalsId` that in turn relies on the method `getId()`. If this method does not exist on a class mixing in this trait, the method will fail. Adding the `getId()` as an abstract method to the trait will make sure it is available. Loading history...
39	4		->where('private', '=', false)
40	4		->orderBy('firstname', 'ASC')->get();
41			}
42
43			/**
44			* Returns user projects with activities details eager loaded
45			*
46			* @param int $status
47			*
48			* @return Relations\HasMany
49			*/
50	10		public function projectsWidthActivities($status = Project::STATUS_OPEN)
51			{
52	10		return $this->projects($status)
53	10		->with([
54			'activities' => function (Relations\Relation $query) {
55	2		$query->with('activity', 'issue', 'user', 'assignTo', 'comment', 'note');
56	2		$query->orderBy('created_at', 'DESC');
57	10		},
58			]);
59			}
60
61			/**
62			* Returns projects with issues details eager loaded
63			*
64			* @param int $status
65			*
66			* @return Relations\HasMany
67			*/
68	1		public function projectsWidthIssues($status = Project::STATUS_OPEN)
69			{
70			return $this
71	1		->projects($status)
72	1		->with([
73		View Code Duplication	'issues' => function (Relations\Relation $query) use ($status) {
			0 ignored issues – show Duplication introduced 2016-01-10 07:09 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
74	1		$query->with('updatedBy');
75	1		$query->where('assigned_to', '=', $this->id);
76	1		if ($status === Project::STATUS_OPEN) {
77	1		$query->where('status', '=', Project\Issue::STATUS_OPEN);
78			}
79	1		},
80			'issues.user' => function () {},
81			'issues.countComments' => function () {},
82			]);
83			}
84
85			/**
86			* Load user permissions
87			*
88			* @return Eloquent\Collection
89			*/
90	54		protected function loadPermissions()
91			{
92	54		if (null === $this->permission) {
93	54		$this->permission = $this->permissions()->with('permission')->get();
94			}
95
96	54		return $this->permission;
97			}
98			}
99

satrun77 / tinyissue

Push — develop ( d1af83...ae4f91 )

QueryTrait A

Complexity

Size/Duplication

Coupling/Cohesion

Test Coverage

Importance

4 Methods

How to fix Duplicated Code

Duplicated Code

Duplication Side-by-Side

Filter issues like