public static function board_generate($game_id)
{
$game_board_letters = \App\Models\Game_User::join('game_board_user', 'game_user.id', '=', 'game_board_user.game_user_id')->where('game_user.game_id', '=', $game_id)->select('game_board_user.x', 'game_board_user.y', 'game_board_user.letter_id');
$board = [];
$cont = 1;
for ($i = 1; $i < 16; $i++) {
for ($j = 1; $j < 16; $j++) {
$type = self::types($cont);
$board[$i][$j] = ['letter' => null, 'type' => $type->type, 'multiplier' => $type->multiplier];
$cont++;
}
}
$game_users = \App\Models\Game_User::where('game_id', '=', $game_id)->get();
$game_board = collect();
foreach ($game_users as $game_user) {
$game_board->push(\App\Models\Game_Board_User::where('game_user_id', '=', $game_user->id)->get());
}
foreach ($game_board as $letters) {
foreach ($letters as $cell) {
$complete_letter = \App\Models\Letter::find($cell->letter_id);
$board[$cell->x][$cell->y]['letter'] = $complete_letter;
}
}
return $board;
}
