/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $objImgPoster = array(); $gamePoster = GamePoster::where('user_id', $id)->select('poster_id')->get(); if ($gamePoster->count() > 0) { foreach ($gamePoster as $value) { $find = Poster::where('poster_id', $value->poster_id)->select('image_default', 'poster_id')->get(); array_push($objImgPoster, $find[0]); } return response()->json($objImgPoster); } else { return "empty"; } }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function random($id) { $objInPoster = array(); $find = 0; $gamePoster = GamePoster::where('user_id', $id)->select('poster_id')->get(); if ($gamePoster->count() > 0) { foreach ($gamePoster as $key => $value) { array_push($objInPoster, $value->poster_id); } $find = 12 - $gamePoster->count(); if ($find > 3) { $poster = DB::table('poster')->whereNotIn('poster_id', $objInPoster)->orderByRaw('RAND()')->take(3)->get(); } else { if ($find > 0) { $poster = DB::table('poster')->whereNotIn('poster_id', $objInPoster)->orderByRaw('RAND()')->take($find)->get(); } else { $poster = []; } } } else { $poster = DB::table('poster')->orderByRaw('RAND()')->take(3)->get(); } return response()->json($poster); }