App\Lib\DsManager\Models\Orm\Player

Complexity

Total Complexity

6

Size/Duplication

Total Lines	70
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes	7
Bugs	0	Features	3

6 Methods

Rating	Name	Duplication	Size	Complexity
A	team()	0	4	1
A	goals()	0	6	1
A	lastMatches()	0	6	1
A	appearances()	0	6	1
A	avg()	0	6	1
A	scopeStatistics()	0	10	1

<?php


namespace App\Lib\DsManager\Models\Orm;


/**

 * Class Player

 * @package App\Lib\DsManager\Models

 */

class Player extends DsManagerOrm

{


    /**

     * @var string

     */

    protected $table = 'players';


    /**

     * @var array

     */

    protected $fillable = [

        'name',

        'surname',

        'age',

        'nationality',

        'skillAvg',

        'wageReq',

        'val',

        'role',

        'team_id'

    ];


    /**

     * @return \Illuminate\Database\Eloquent\Relations\BelongsTo

     */

    public function team()

    {

        return $this->belongsTo(Team::class);

    }


    public function lastMatches()

    {

        return $this->hasMany(MatchPlayer::class)

            ->orderBy('updated_at', 'DESC')

            ->limit(5);

    }


    public function goals()

    {

        return $this->hasOne(MatchPlayer::class)

            ->selectRaw('player_id, sum(goals) as count')

            ->groupBy('player_id');

    }


    public function appearances()

    {

        return $this->hasOne(MatchPlayer::class)

            ->selectRaw('player_id, count(match_id) as count')

            ->groupBy('player_id');

    }


    public function avg()

    {

        return $this->hasOne(MatchPlayer::class)

            ->selectRaw('player_id, round(avg(vote),2) as avg')

            ->groupBy('player_id');

    }


    public function scopeStatistics($query)

    {

        return $query->with(

            'goals',

            'appearances',

            'avg',

            'lastMatches',

            'team'

        );

    }

}