PHP app\models Player::leftJoinの例

コード例 #1

ファイル: PlayerController.php プロジェクト: murribu/trumedia

 function getPlayers()
 {
     $players = Player::leftJoin('player_positions', 'players.id', '=', 'player_positions.player_id')->leftJoin('positions', 'positions.id', '=', 'player_positions.position_id')->selectRaw('players.id, players.mlb_id, players.name, players.batter_hand, players.pitcher_hand, group_concat(ifnull(positions.abbr, \'P\') order by positions.id) positions')->groupBy('players.id')->get();
     return $players;
 }