public function editActivity(Request $request) { $session = $request->get('session'); $id = $request->get('id'); $staffId = $request->get('activitystaffId'); $cusId = $request->get('cusId'); $date = $request->get("activitydate"); $type = $request->get("activitytype"); $outcome = $request->get("activityoutcome"); $activity = Activities::find($id); $activity->cusId = $cusId; $activity->staffId = $staffId; $activity->date = $date; $activity->type = $type; $activity->outcome = $outcome; $activity->save(); return json_encode(DB::table('activities as a')->select('a.id as activityId', 'a.cusId', 'a.date', 'a.outcome', 'a.staffId', 'a.type', 'u.id as staffId', 'u.fullname as staffName')->leftJoin('user as u', 'a.staffId', '=', 'u.id')->get()); }