select('user_id', 'prizes.activity_id', 'prize_id', 'recipients.created_at') ->where('prizes.activity_id', $request->activityId) ->orderBy('recipients.created_at', 'DESC') ->get(); } /** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { // } /** * Store a newly created resource in storage. * * @param \App\Http\Requests\StoreRecipientsRequest $request * @return \Illuminate\Http\Response */ public function store(StoreRecipientsRequest $request) { Recipients::insert([ 'prize_id' => $request->prizeId, 'user_id' => $request->userId, 'is_claimed' => false, 'created_at' => now(), 'updated_at' => now(), ]); return 'success'; } public function store_patch(StoreRecipientsRequest $request) { $data = []; foreach ($request->userIdList as $userId) { array_push($data, [ 'prize_id' => $request->prizeId, 'user_id' => $userId, 'is_claimed' => false, 'created_at' => now(), 'updated_at' => now(), ]); } Recipients::insert($data); return 'success'; } /** * Display the specified resource. * * @param \App\Models\Recipients $recipients * @return \Illuminate\Http\Response */ public function show(Recipients $recipients) { // } /** * Show the form for editing the specified resource. * * @param \App\Models\Recipients $recipients * @return \Illuminate\Http\Response */ public function edit(Recipients $recipients) { // } /** * Update the specified resource in storage. * * @param \App\Http\Requests\UpdateRecipientsRequest $request * @param \App\Models\Recipients $recipients * @return \Illuminate\Http\Response */ public function update(UpdateRecipientsRequest $request, Recipients $recipients) { Recipients::where('user_id', $request->userId)->update(['prize_id' => $request->prizeId]); return 'success'; } /** * Remove the specified resource from storage. * * @param \App\Models\Recipients $recipients * @return \Illuminate\Http\Response */ public function destroy(Recipients $recipients) { // } public function isClaimed(UpdateRecipientsRequest $request) { $recipient = Recipients::where('prize_id', '=', $request->prize_id) ->where('user_id', '=', $request->user_id)->get()[0]; $recipient->is_claimed = true; $recipient->save(); return $recipient; } }