@@ -38,7 +38,7 @@ |
||
| 38 | 38 | } |
| 39 | 39 | |
| 40 | 40 | /** |
| 41 | - * @return \Illuminate\Database\Eloquent\Relations\HasMany |
|
| 41 | + * @return \Illuminate\Database\Eloquent\Relations\HasOne |
|
| 42 | 42 | */ |
| 43 | 43 | public function coach() |
| 44 | 44 | {
|
@@ -8,132 +8,132 @@ |
||
| 8 | 8 | */ |
| 9 | 9 | class Team extends DsManagerOrm |
| 10 | 10 | {
|
| 11 | - /** |
|
| 12 | - * |
|
| 13 | - */ |
|
| 14 | - const PLAYED_LIMIT = 5; |
|
| 15 | - /** |
|
| 16 | - * |
|
| 17 | - */ |
|
| 18 | - const FUTURE_LIMIT = 3; |
|
| 19 | - /** |
|
| 20 | - * @var string |
|
| 21 | - */ |
|
| 22 | - protected $table = 'teams'; |
|
| 11 | + /** |
|
| 12 | + * |
|
| 13 | + */ |
|
| 14 | + const PLAYED_LIMIT = 5; |
|
| 15 | + /** |
|
| 16 | + * |
|
| 17 | + */ |
|
| 18 | + const FUTURE_LIMIT = 3; |
|
| 19 | + /** |
|
| 20 | + * @var string |
|
| 21 | + */ |
|
| 22 | + protected $table = 'teams'; |
|
| 23 | 23 | |
| 24 | - /** |
|
| 25 | - * @var array |
|
| 26 | - */ |
|
| 27 | - protected $fillable = [ |
|
| 28 | - 'name', |
|
| 29 | - 'nationality' |
|
| 30 | - ]; |
|
| 24 | + /** |
|
| 25 | + * @var array |
|
| 26 | + */ |
|
| 27 | + protected $fillable = [ |
|
| 28 | + 'name', |
|
| 29 | + 'nationality' |
|
| 30 | + ]; |
|
| 31 | 31 | |
| 32 | - /** |
|
| 33 | - * @return \Illuminate\Database\Eloquent\Relations\HasMany |
|
| 34 | - */ |
|
| 35 | - public function roster() |
|
| 36 | - {
|
|
| 37 | - return $this->hasMany(Player::class); |
|
| 38 | - } |
|
| 32 | + /** |
|
| 33 | + * @return \Illuminate\Database\Eloquent\Relations\HasMany |
|
| 34 | + */ |
|
| 35 | + public function roster() |
|
| 36 | + {
|
|
| 37 | + return $this->hasMany(Player::class); |
|
| 38 | + } |
|
| 39 | 39 | |
| 40 | - /** |
|
| 41 | - * @return \Illuminate\Database\Eloquent\Relations\HasMany |
|
| 42 | - */ |
|
| 43 | - public function coach() |
|
| 44 | - {
|
|
| 45 | - return $this->hasOne(Coach::class); |
|
| 46 | - } |
|
| 40 | + /** |
|
| 41 | + * @return \Illuminate\Database\Eloquent\Relations\HasMany |
|
| 42 | + */ |
|
| 43 | + public function coach() |
|
| 44 | + {
|
|
| 45 | + return $this->hasOne(Coach::class); |
|
| 46 | + } |
|
| 47 | 47 | |
| 48 | - /** |
|
| 49 | - * @return mixed |
|
| 50 | - */ |
|
| 51 | - public function playedMatchesHome() |
|
| 52 | - {
|
|
| 53 | - return $this->hasMany( |
|
| 54 | - MatchResult::class, |
|
| 55 | - 'home_team_id' |
|
| 56 | - )->where('simulated', true)
|
|
| 57 | - ->orderBy('updated_at', 'DESC')
|
|
| 58 | - ->limit(self::PLAYED_LIMIT); |
|
| 59 | - } |
|
| 48 | + /** |
|
| 49 | + * @return mixed |
|
| 50 | + */ |
|
| 51 | + public function playedMatchesHome() |
|
| 52 | + {
|
|
| 53 | + return $this->hasMany( |
|
| 54 | + MatchResult::class, |
|
| 55 | + 'home_team_id' |
|
| 56 | + )->where('simulated', true)
|
|
| 57 | + ->orderBy('updated_at', 'DESC')
|
|
| 58 | + ->limit(self::PLAYED_LIMIT); |
|
| 59 | + } |
|
| 60 | 60 | |
| 61 | - /** |
|
| 62 | - * @return mixed |
|
| 63 | - */ |
|
| 64 | - public function futureMatchesHome() |
|
| 65 | - {
|
|
| 66 | - return $this->hasMany( |
|
| 67 | - MatchResult::class, |
|
| 68 | - 'home_team_id' |
|
| 69 | - )->where('simulated', false)
|
|
| 70 | - ->orderBy('updated_at', 'DESC')
|
|
| 71 | - ->limit(self::FUTURE_LIMIT); |
|
| 72 | - } |
|
| 61 | + /** |
|
| 62 | + * @return mixed |
|
| 63 | + */ |
|
| 64 | + public function futureMatchesHome() |
|
| 65 | + {
|
|
| 66 | + return $this->hasMany( |
|
| 67 | + MatchResult::class, |
|
| 68 | + 'home_team_id' |
|
| 69 | + )->where('simulated', false)
|
|
| 70 | + ->orderBy('updated_at', 'DESC')
|
|
| 71 | + ->limit(self::FUTURE_LIMIT); |
|
| 72 | + } |
|
| 73 | 73 | |
| 74 | - /** |
|
| 75 | - * @return mixed |
|
| 76 | - */ |
|
| 77 | - public function playedMatchesAway() |
|
| 78 | - {
|
|
| 79 | - return $this->hasMany( |
|
| 80 | - MatchResult::class, |
|
| 81 | - 'away_team_id' |
|
| 82 | - )->where('simulated', true)
|
|
| 83 | - ->orderBy('updated_at', 'DESC')
|
|
| 84 | - ->limit(self::PLAYED_LIMIT); |
|
| 85 | - } |
|
| 74 | + /** |
|
| 75 | + * @return mixed |
|
| 76 | + */ |
|
| 77 | + public function playedMatchesAway() |
|
| 78 | + {
|
|
| 79 | + return $this->hasMany( |
|
| 80 | + MatchResult::class, |
|
| 81 | + 'away_team_id' |
|
| 82 | + )->where('simulated', true)
|
|
| 83 | + ->orderBy('updated_at', 'DESC')
|
|
| 84 | + ->limit(self::PLAYED_LIMIT); |
|
| 85 | + } |
|
| 86 | 86 | |
| 87 | - /** |
|
| 88 | - * @return mixed |
|
| 89 | - */ |
|
| 90 | - public function futureMatchesAway() |
|
| 91 | - {
|
|
| 92 | - return $this->hasMany( |
|
| 93 | - MatchResult::class, |
|
| 94 | - 'away_team_id' |
|
| 95 | - )->where('simulated', false)
|
|
| 96 | - ->orderBy('updated_at', 'DESC')
|
|
| 97 | - ->limit(self::FUTURE_LIMIT); |
|
| 98 | - } |
|
| 87 | + /** |
|
| 88 | + * @return mixed |
|
| 89 | + */ |
|
| 90 | + public function futureMatchesAway() |
|
| 91 | + {
|
|
| 92 | + return $this->hasMany( |
|
| 93 | + MatchResult::class, |
|
| 94 | + 'away_team_id' |
|
| 95 | + )->where('simulated', false)
|
|
| 96 | + ->orderBy('updated_at', 'DESC')
|
|
| 97 | + ->limit(self::FUTURE_LIMIT); |
|
| 98 | + } |
|
| 99 | 99 | |
| 100 | 100 | |
| 101 | - /** |
|
| 102 | - * @param $query |
|
| 103 | - * @return mixed |
|
| 104 | - */ |
|
| 105 | - public function scopeComplete($query) |
|
| 106 | - {
|
|
| 107 | - return $query->with( |
|
| 108 | - 'roster', |
|
| 109 | - 'coach', |
|
| 110 | - 'playedMatchesHome', |
|
| 111 | - 'playedMatchesHome.awayTeam', |
|
| 112 | - 'futureMatchesHome', |
|
| 113 | - 'futureMatchesHome.awayTeam', |
|
| 114 | - 'playedMatchesAway', |
|
| 115 | - 'playedMatchesAway.homeTeam', |
|
| 116 | - 'futureMatchesAway', |
|
| 117 | - 'futureMatchesAway.homeTeam' |
|
| 118 | - ); |
|
| 119 | - } |
|
| 101 | + /** |
|
| 102 | + * @param $query |
|
| 103 | + * @return mixed |
|
| 104 | + */ |
|
| 105 | + public function scopeComplete($query) |
|
| 106 | + {
|
|
| 107 | + return $query->with( |
|
| 108 | + 'roster', |
|
| 109 | + 'coach', |
|
| 110 | + 'playedMatchesHome', |
|
| 111 | + 'playedMatchesHome.awayTeam', |
|
| 112 | + 'futureMatchesHome', |
|
| 113 | + 'futureMatchesHome.awayTeam', |
|
| 114 | + 'playedMatchesAway', |
|
| 115 | + 'playedMatchesAway.homeTeam', |
|
| 116 | + 'futureMatchesAway', |
|
| 117 | + 'futureMatchesAway.homeTeam' |
|
| 118 | + ); |
|
| 119 | + } |
|
| 120 | 120 | |
| 121 | - /** |
|
| 122 | - * @return array |
|
| 123 | - */ |
|
| 124 | - public static function getBest() |
|
| 125 | - {
|
|
| 126 | - $result = Match::selectRaw('winner_id as id, COUNT(*) as won')
|
|
| 127 | - ->whereNotNull('winner_id')->where('winner_id', '!=', 0)
|
|
| 128 | - ->orderByRaw('COUNT(*) DESC')->groupBy('winner_id')
|
|
| 129 | - ->take(20)->get()->keyBy('id')->toArray();
|
|
| 130 | - $teams = Team::whereIn('id', array_keys($result))->get()->toArray();
|
|
| 131 | - $result = array_map(function ($team) use ($result) {
|
|
| 132 | - $team['stats'] = $result[$team['id']]; |
|
| 133 | - return $team; |
|
| 134 | - }, $teams); |
|
| 121 | + /** |
|
| 122 | + * @return array |
|
| 123 | + */ |
|
| 124 | + public static function getBest() |
|
| 125 | + {
|
|
| 126 | + $result = Match::selectRaw('winner_id as id, COUNT(*) as won')
|
|
| 127 | + ->whereNotNull('winner_id')->where('winner_id', '!=', 0)
|
|
| 128 | + ->orderByRaw('COUNT(*) DESC')->groupBy('winner_id')
|
|
| 129 | + ->take(20)->get()->keyBy('id')->toArray();
|
|
| 130 | + $teams = Team::whereIn('id', array_keys($result))->get()->toArray();
|
|
| 131 | + $result = array_map(function ($team) use ($result) {
|
|
| 132 | + $team['stats'] = $result[$team['id']]; |
|
| 133 | + return $team; |
|
| 134 | + }, $teams); |
|
| 135 | 135 | |
| 136 | - return $result; |
|
| 137 | - } |
|
| 136 | + return $result; |
|
| 137 | + } |
|
| 138 | 138 | |
| 139 | 139 | } |
| 140 | 140 | \ No newline at end of file |
@@ -128,7 +128,7 @@ |
||
| 128 | 128 | ->orderByRaw('COUNT(*) DESC')->groupBy('winner_id')
|
| 129 | 129 | ->take(20)->get()->keyBy('id')->toArray();
|
| 130 | 130 | $teams = Team::whereIn('id', array_keys($result))->get()->toArray();
|
| 131 | - $result = array_map(function ($team) use ($result) {
|
|
| 131 | + $result = array_map(function($team) use ($result) {
|
|
| 132 | 132 | $team['stats'] = $result[$team['id']]; |
| 133 | 133 | return $team; |
| 134 | 134 | }, $teams); |
@@ -9,48 +9,48 @@ |
||
| 9 | 9 | */ |
| 10 | 10 | class Responder |
| 11 | 11 | {
|
| 12 | - /** |
|
| 13 | - * @param $content |
|
| 14 | - * @param $response |
|
| 15 | - * @param array $headers |
|
| 16 | - * @return mixed |
|
| 17 | - */ |
|
| 18 | - public static function getJsonResponse($content, $response, $headers = []) |
|
| 19 | - {
|
|
| 20 | - $headers['Content-Type'] = 'application/json'; |
|
| 21 | - return self::getResponse( |
|
| 22 | - $headers, |
|
| 23 | - $content, |
|
| 24 | - $response |
|
| 25 | - ); |
|
| 26 | - } |
|
| 12 | + /** |
|
| 13 | + * @param $content |
|
| 14 | + * @param $response |
|
| 15 | + * @param array $headers |
|
| 16 | + * @return mixed |
|
| 17 | + */ |
|
| 18 | + public static function getJsonResponse($content, $response, $headers = []) |
|
| 19 | + {
|
|
| 20 | + $headers['Content-Type'] = 'application/json'; |
|
| 21 | + return self::getResponse( |
|
| 22 | + $headers, |
|
| 23 | + $content, |
|
| 24 | + $response |
|
| 25 | + ); |
|
| 26 | + } |
|
| 27 | 27 | |
| 28 | - /** |
|
| 29 | - * @param array $headers |
|
| 30 | - * @param $content |
|
| 31 | - * @param $response |
|
| 32 | - * @return mixed |
|
| 33 | - */ |
|
| 34 | - public static function getResponse($headers = [], $content, $response) |
|
| 35 | - {
|
|
| 36 | - $body = $response->getBody(); |
|
| 37 | - $body->write($content); |
|
| 38 | - $i = 0; |
|
| 39 | - foreach ($headers as $header => $value) {
|
|
| 40 | - if ($i === 0) {
|
|
| 41 | - $response = $response->withHeader( |
|
| 42 | - $header, |
|
| 43 | - $value |
|
| 44 | - ); |
|
| 45 | - } else {
|
|
| 46 | - $response = $response->withAddedHeader( |
|
| 47 | - $header, |
|
| 48 | - $value |
|
| 49 | - ); |
|
| 50 | - } |
|
| 51 | - $i++; |
|
| 52 | - } |
|
| 53 | - return $response->withBody($body); |
|
| 54 | - } |
|
| 28 | + /** |
|
| 29 | + * @param array $headers |
|
| 30 | + * @param $content |
|
| 31 | + * @param $response |
|
| 32 | + * @return mixed |
|
| 33 | + */ |
|
| 34 | + public static function getResponse($headers = [], $content, $response) |
|
| 35 | + {
|
|
| 36 | + $body = $response->getBody(); |
|
| 37 | + $body->write($content); |
|
| 38 | + $i = 0; |
|
| 39 | + foreach ($headers as $header => $value) {
|
|
| 40 | + if ($i === 0) {
|
|
| 41 | + $response = $response->withHeader( |
|
| 42 | + $header, |
|
| 43 | + $value |
|
| 44 | + ); |
|
| 45 | + } else {
|
|
| 46 | + $response = $response->withAddedHeader( |
|
| 47 | + $header, |
|
| 48 | + $value |
|
| 49 | + ); |
|
| 50 | + } |
|
| 51 | + $i++; |
|
| 52 | + } |
|
| 53 | + return $response->withBody($body); |
|
| 54 | + } |
|
| 55 | 55 | |
| 56 | 56 | } |
| 57 | 57 | \ No newline at end of file |
@@ -9,104 +9,104 @@ |
||
| 9 | 9 | class Player extends DsManagerOrm |
| 10 | 10 | {
|
| 11 | 11 | |
| 12 | - /** |
|
| 13 | - * @var string |
|
| 14 | - */ |
|
| 15 | - protected $table = 'players'; |
|
| 12 | + /** |
|
| 13 | + * @var string |
|
| 14 | + */ |
|
| 15 | + protected $table = 'players'; |
|
| 16 | 16 | |
| 17 | - /** |
|
| 18 | - * @var array |
|
| 19 | - */ |
|
| 20 | - protected $fillable = [ |
|
| 21 | - 'name', |
|
| 22 | - 'surname', |
|
| 23 | - 'age', |
|
| 24 | - 'nationality', |
|
| 25 | - 'skillAvg', |
|
| 26 | - 'wageReq', |
|
| 27 | - 'val', |
|
| 28 | - 'role', |
|
| 29 | - 'team_id' |
|
| 30 | - ]; |
|
| 17 | + /** |
|
| 18 | + * @var array |
|
| 19 | + */ |
|
| 20 | + protected $fillable = [ |
|
| 21 | + 'name', |
|
| 22 | + 'surname', |
|
| 23 | + 'age', |
|
| 24 | + 'nationality', |
|
| 25 | + 'skillAvg', |
|
| 26 | + 'wageReq', |
|
| 27 | + 'val', |
|
| 28 | + 'role', |
|
| 29 | + 'team_id' |
|
| 30 | + ]; |
|
| 31 | 31 | |
| 32 | - /** |
|
| 33 | - * @return \Illuminate\Database\Eloquent\Relations\BelongsTo |
|
| 34 | - */ |
|
| 35 | - public function team() |
|
| 36 | - {
|
|
| 37 | - return $this->belongsTo(Team::class); |
|
| 38 | - } |
|
| 32 | + /** |
|
| 33 | + * @return \Illuminate\Database\Eloquent\Relations\BelongsTo |
|
| 34 | + */ |
|
| 35 | + public function team() |
|
| 36 | + {
|
|
| 37 | + return $this->belongsTo(Team::class); |
|
| 38 | + } |
|
| 39 | 39 | |
| 40 | - /** |
|
| 41 | - * @return mixed |
|
| 42 | - */ |
|
| 43 | - public function lastMatches() |
|
| 44 | - {
|
|
| 45 | - return $this->hasMany(MatchPlayer::class) |
|
| 46 | - ->orderBy('updated_at', 'DESC')
|
|
| 47 | - ->limit(5); |
|
| 48 | - } |
|
| 40 | + /** |
|
| 41 | + * @return mixed |
|
| 42 | + */ |
|
| 43 | + public function lastMatches() |
|
| 44 | + {
|
|
| 45 | + return $this->hasMany(MatchPlayer::class) |
|
| 46 | + ->orderBy('updated_at', 'DESC')
|
|
| 47 | + ->limit(5); |
|
| 48 | + } |
|
| 49 | 49 | |
| 50 | - /** |
|
| 51 | - * @return mixed |
|
| 52 | - */ |
|
| 53 | - public function goals() |
|
| 54 | - {
|
|
| 55 | - return $this->hasOne(MatchPlayer::class) |
|
| 56 | - ->selectRaw('player_id, sum(goals) as count')
|
|
| 57 | - ->groupBy('player_id');
|
|
| 58 | - } |
|
| 50 | + /** |
|
| 51 | + * @return mixed |
|
| 52 | + */ |
|
| 53 | + public function goals() |
|
| 54 | + {
|
|
| 55 | + return $this->hasOne(MatchPlayer::class) |
|
| 56 | + ->selectRaw('player_id, sum(goals) as count')
|
|
| 57 | + ->groupBy('player_id');
|
|
| 58 | + } |
|
| 59 | 59 | |
| 60 | - /** |
|
| 61 | - * @return mixed |
|
| 62 | - */ |
|
| 63 | - public function appearances() |
|
| 64 | - {
|
|
| 65 | - return $this->hasOne(MatchPlayer::class) |
|
| 66 | - ->selectRaw('player_id, count(match_id) as count')
|
|
| 67 | - ->groupBy('player_id');
|
|
| 68 | - } |
|
| 60 | + /** |
|
| 61 | + * @return mixed |
|
| 62 | + */ |
|
| 63 | + public function appearances() |
|
| 64 | + {
|
|
| 65 | + return $this->hasOne(MatchPlayer::class) |
|
| 66 | + ->selectRaw('player_id, count(match_id) as count')
|
|
| 67 | + ->groupBy('player_id');
|
|
| 68 | + } |
|
| 69 | 69 | |
| 70 | - /** |
|
| 71 | - * @return mixed |
|
| 72 | - */ |
|
| 73 | - public function avg() |
|
| 74 | - {
|
|
| 75 | - return $this->hasOne(MatchPlayer::class) |
|
| 76 | - ->selectRaw('player_id, round(avg(vote),2) as avg')
|
|
| 77 | - ->groupBy('player_id');
|
|
| 78 | - } |
|
| 70 | + /** |
|
| 71 | + * @return mixed |
|
| 72 | + */ |
|
| 73 | + public function avg() |
|
| 74 | + {
|
|
| 75 | + return $this->hasOne(MatchPlayer::class) |
|
| 76 | + ->selectRaw('player_id, round(avg(vote),2) as avg')
|
|
| 77 | + ->groupBy('player_id');
|
|
| 78 | + } |
|
| 79 | 79 | |
| 80 | - /** |
|
| 81 | - * @param $query |
|
| 82 | - * @return mixed |
|
| 83 | - */ |
|
| 84 | - public function scopeStatistics($query) |
|
| 85 | - {
|
|
| 86 | - return $query->with( |
|
| 87 | - 'goals', |
|
| 88 | - 'appearances', |
|
| 89 | - 'avg', |
|
| 90 | - 'lastMatches', |
|
| 91 | - 'team' |
|
| 92 | - ); |
|
| 93 | - } |
|
| 80 | + /** |
|
| 81 | + * @param $query |
|
| 82 | + * @return mixed |
|
| 83 | + */ |
|
| 84 | + public function scopeStatistics($query) |
|
| 85 | + {
|
|
| 86 | + return $query->with( |
|
| 87 | + 'goals', |
|
| 88 | + 'appearances', |
|
| 89 | + 'avg', |
|
| 90 | + 'lastMatches', |
|
| 91 | + 'team' |
|
| 92 | + ); |
|
| 93 | + } |
|
| 94 | 94 | |
| 95 | - /** |
|
| 96 | - * @return array |
|
| 97 | - */ |
|
| 98 | - public static function getBest() |
|
| 99 | - {
|
|
| 100 | - $result = MatchPlayer::selectRaw( |
|
| 101 | - 'player_id, COUNT(*) as appearances ,AVG(vote) avg, SUM(goals) goals' |
|
| 102 | - )->where('goals', '>', 0)
|
|
| 103 | - ->orderByRaw('SUM(goals) DESC,COUNT(*) DESC')
|
|
| 104 | - ->groupBy('player_id')->take(20)->get()->keyBy('player_id')->toArray();
|
|
| 105 | - $players = Player::whereIn('id', array_keys($result))->get()->toArray();
|
|
| 106 | - $result = array_map(function ($player) use ($result) {
|
|
| 107 | - $player['stats'] = $result[$player['id']]; |
|
| 108 | - return $player; |
|
| 109 | - }, $players); |
|
| 110 | - return $result; |
|
| 111 | - } |
|
| 95 | + /** |
|
| 96 | + * @return array |
|
| 97 | + */ |
|
| 98 | + public static function getBest() |
|
| 99 | + {
|
|
| 100 | + $result = MatchPlayer::selectRaw( |
|
| 101 | + 'player_id, COUNT(*) as appearances ,AVG(vote) avg, SUM(goals) goals' |
|
| 102 | + )->where('goals', '>', 0)
|
|
| 103 | + ->orderByRaw('SUM(goals) DESC,COUNT(*) DESC')
|
|
| 104 | + ->groupBy('player_id')->take(20)->get()->keyBy('player_id')->toArray();
|
|
| 105 | + $players = Player::whereIn('id', array_keys($result))->get()->toArray();
|
|
| 106 | + $result = array_map(function ($player) use ($result) {
|
|
| 107 | + $player['stats'] = $result[$player['id']]; |
|
| 108 | + return $player; |
|
| 109 | + }, $players); |
|
| 110 | + return $result; |
|
| 111 | + } |
|
| 112 | 112 | } |
| 113 | 113 | \ No newline at end of file |
@@ -103,7 +103,7 @@ |
||
| 103 | 103 | ->orderByRaw('SUM(goals) DESC,COUNT(*) DESC')
|
| 104 | 104 | ->groupBy('player_id')->take(20)->get()->keyBy('player_id')->toArray();
|
| 105 | 105 | $players = Player::whereIn('id', array_keys($result))->get()->toArray();
|
| 106 | - $result = array_map(function ($player) use ($result) {
|
|
| 106 | + $result = array_map(function($player) use ($result) {
|
|
| 107 | 107 | $player['stats'] = $result[$player['id']]; |
| 108 | 108 | return $player; |
| 109 | 109 | }, $players); |