In my database, I have two tables named Users and ratings. The Users can give ratings to consultants, and the Ratings table structure is as follows:
User_id | consultant_id | rating
---------------------------------
1 1 2
---------------------------------
2 1 3
---------------------------------
3 1 1
---------------------------------
4 1 1
This is how the table looks like.
Here is a snippet of my controller code:
public function searchConsultants(Request $request)
{
$location = $request->get('location');
$data = Consultant::where('location','LIKE','%'.$location.'%')->with('ratings')->get();
return response()->json($data);
}
The response I receive from the `searchConsultants` method contains data about the consultants along with their ratings.
[{"id":1,"cunsultant_name":"Manjunath Mj",
"contact_number":"9035206471",
"location":"Delhi",
"department_id":1,09:00:51",
"ratings":[{
"id":1,"customer_id":1,"consultant_id":1,"rating":4,
"id":2,"customer_id":2,"consultant_id":1,"rating":2,
"id":3,"customer_id":3,"consultant_id":1,"rating":1,
"id":4,"customer_id":4,"consultant_id":1,"rating":5,
}]
}]
To display this data using Ajax GET method, below is a snippet from my JavaScript file:
$.each(data, function(index) {
str +="<tr><td>"+data[index].id+"</td>
<td>"+data[index].cunsultant_name+"</td>
<td>"+data[index].contact_number+"</td>
<td>"+data[index].ratings[index].rating_for_manager+"</td><td>"+data[index].location+"</td></tr>";
});
Upon clicking the search consultant button, I expect to retrieve details of the consultants along with their average ratings.