Styjun

I try the detail to explain the code. The seller receives more offer for his car. When he accepts a certain offer for a particular car, I want to forbid him to accept other offers again for same car.
Example. The seller accepted the offer id. 2, price 3000, car_id 4.
Seller can no longer accept offer id.3 or 4 or 5, price 4000, car_id 4.
Look my code and database

 public function accept($id)
 $userId = Auth::user();
 $offerId = Offer::with('user')->find($id);
 if(!$offerId)
 return response()->json([
 'message' => 'Oooops this offer does not exist or is currently unavailable'
 ]);
 
 if($offerId->accepted === 1)
 return response()->json([
 'message' => 'Oooops this offer is already accepted'
 ]);
 

 $res = DB::table('offers')
 ->where('id', $id)
 ->update(['accepted' => 1]);
 if(!$res)
 return response()->json([
 'message' => 'Ooooops the offer is already accepted'
 ]);
 
 Mail::to($offerId->user->email)->send(new AcceptOffer());
 return response()->json([
 'message' => 'Successfully accepted offer',
 'offer' => $id
 ]);

 

My table Offer with manipulate with offer:

https://imgur.com/ccs4abV

Relation between Offer and Car and User:

Car:

public function user() 
 return $this->belongsTo('AppUser');

public function offer() 
 return $this->hasMany('AppOffer');

Offer:

public function car() 
 return $this->belongsTo('AppCar');

public function user() 
 return $this->belongsTo('AppUser');

User:

public function cars()
 return $this->hasMany('AppCar');

public function offers()
 return $this->hasMany('AppOffer');

Just simple check, if there is some offer for that specific car allready accepted.

$acceptedCount = Offer::where('car_id', $offerId->car_id)->where('accepted', 1)->count(); 
if($acceptedCount > 0)
 return response()->json([
 'message' => 'Another offer for this car was already accepted'
 ]);