36 lines
971 B
PHP
36 lines
971 B
PHP
<?php
|
|
|
|
namespace App\Leagues;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
|
|
use App\User;
|
|
|
|
class LeagueMember extends Model
|
|
{
|
|
protected $table ='leagues_members';
|
|
protected $fillable = [
|
|
'id','user_id','league_id'
|
|
];
|
|
//
|
|
|
|
public static function getMembers($league_id) {
|
|
$members =LeagueMember::where('league_id','=',$league_id)->orderBy('id')->get();
|
|
$userList=array();
|
|
foreach($members as $member) {
|
|
array_push($userList,$member->user_id);
|
|
}
|
|
return $userList;
|
|
}
|
|
|
|
public static function playsInRound($userId, $roundId, $leagueId) {
|
|
$matches1 = Match::where('user1_id','=',$userId)->where('round_id','=',$roundId)->where('league_id','=',$leagueId)->get();
|
|
if (sizeof($matches1)>0) return true;
|
|
|
|
|
|
$matches2 = Match::where('user2_id','=',$userId)->where('round_id','=',$roundId)->where('league_id','=',$leagueId)->get();
|
|
return sizeof($matches2)>0;
|
|
|
|
}
|
|
|
|
}
|