Comments::bestCommenter() - Code Metrics - Inspection of "add changes" - Symfomany/laravelcinema - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 383e32...dd0ca4 )

by Julien

created 2015-12-14 07:48 UTC

Comments::bestCommenter() A

↳ Parent: Comments

Complexity

Conditions	1
Paths	1

Size

Total Lines	14
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
c	1
b	0
f	1
dl	0
loc	14
rs	9.4286
cc	1
eloc	3
nc	1
nop	0

<?php

namespace App\Http\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;


/**
 * Classe qui va stocker mes requetes autoirs
 * de ma table movies
 * Hérite de ma super classe Model
 */
class Comments extends Model{

    /**
     * Décrit le nom de la table
     * que classe fait référence
     */
    protected $table = 'comments';



    public function bestCommenter()
    {


        $bestCommenter = DB::select('
            SELECT user.username, COUNT( user_id ) AS nb_comments
            FROM  `comments`
            LEFT JOIN user ON user.id = comments.user_id
            GROUP BY user_id
            ORDER BY COUNT( user_id ) DESC
            LIMIT 1');

        return $bestCommenter;
    }

    /* RELATIONS */

    public function movie()
    {
        return $this->belongsTo('\App\Http\Models\Movies', 'movies_id');
    }

    public function user()
    {
        return $this->belongsTo('\App\Http\Models\Users');
    }


}





1			<?php
2
3			namespace App\Http\Models;
4
5			use Illuminate\Database\Eloquent\Model;
6			use Illuminate\Support\Facades\DB;
7
8
9			/**
10			* Classe qui va stocker mes requetes autoirs
11			* de ma table movies
12			* Hérite de ma super classe Model
13			*/
14			class Comments extends Model{
15
16			/**
17			* Décrit le nom de la table
18			* que classe fait référence
19			*/
20			protected $table = 'comments';
21
22
23
24			public function bestCommenter()
25			{
26
27
28			$bestCommenter = DB::select('
29			SELECT user.username, COUNT( user_id ) AS nb_comments
30			FROM `comments`
31			LEFT JOIN user ON user.id = comments.user_id
32			GROUP BY user_id
33			ORDER BY COUNT( user_id ) DESC
34			LIMIT 1');
35
36			return $bestCommenter;
37			}
38
39			/* RELATIONS */
40
41			public function movie()
42			{
43			return $this->belongsTo('\App\Http\Models\Movies', 'movies_id');
44			}
45
46			public function user()
47			{
48			return $this->belongsTo('\App\Http\Models\Users');
49			}
50
51
52			}
53
54
55
56

Symfomany / laravelcinema

Push — master ( 383e32...dd0ca4 )

Comments::bestCommenter() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like