php - Performing update slots for timeslots table using mysql database

Below is the sample code of making an appointment, which has been implemented successfully.

    public function store(Request $request){
        date_default_timezone_set('Asia/Kuala_Lumpur');

        $request->validate(['time'=>'required']);
        $check = $this->checkBookingTimeInterval();

        }

        Reservation::create([
            'user_id'=>auth()->user()->id,
            'dentist_id'=>$request->dentistId,
            'time'=> $request->time,
            'date'=> $request->date,
            'status'=>0
        ]);

        Timeslot::where('appointment_id', $request->appointmentId)
            ->where('time', $request->time)
            ->update(['status'=>1]);
Copy code

I want add cancel booking, however, I do not know how to update the timeslots status to become zero from timeslots database (0 means the timeslots is available for booking again). The reservation database has been deleted when I want to perform cancel booking, just as what I want.

  public function destroy($id,Request $request){
      //delete reservation in records
      $reservation = Reservation::find($id);
      $reservationDelete = $reservation->delete();      

      //how to update the timeslots status to become 0 from timeslots database?
      return redirect()->route('my.appointment')->with('message', 'Appointment has been cancelled successfully');

  }
Copy code