laravel multiple table query issue

@vandan

Show the migrations and the relationships between the table User and Postjob?

Also, share the controller?

@frankielee

//user model
public function postjobs()
{
   		return $this->hasMany(Postjob::class);
}

// postjob model
public function user()
{
   	 return $this->belongsTo(User::class,'user_id','id');
}

//controller
public function userJobList($id)
{
    $job = Postjob::where('user_id',$id)->first();
    if (is_null($job)) {
        return $this->sendError("Job not found.");
    }
    $data = Postjob::where('user_id',$id)->get(); 
 	$spName = User::whereIn('id',$spIds)->get();      
    return $this->sendResponse($data, 'user job list');
}

@vandan

$spIds

Where is the value come from?

@frankielee

 	public function userJobList($id)
	{
    	$job = Postjob::where('user_id',$id)->first();
    	if (is_null($job)) {
        	return $this->sendError("Job not found.");
    	}
    	$data = Postjob::where('user_id',$id)->get()->toArray();
   		$spIds = array_map('intval', explode(',', $job->service_provider_ids));          
        $spName = User::whereIn('id',$spIds)->get()->toArray();
		$data['sp_details'] = $spName;
        return $this->sendResponse($data, 'user job list');
	}

@vandan

$job->service_provider_ids

You might want to refractor your database schema.

Ref: Credit to tray2

https://tray2.se/posts/database-design https://tray2.se/posts/database-design-part-2

@vandan

So every jobs have to get their own sp_details?

Then you might need to use the collection method.

Example

$data = Postjob::where('user_id',$id)->get()->map(function($job){
// do your stuff and structure your data here
});

https://laravel.com/docs/9.x/collections#method-map

@MichalOravec okay i will change the key name but how to do using query

@aliabdm not working bro

@vandan what is response with it or what went wrong ?

@aliabdm

{
	"success": true,
	"message": "user job list",
	"data": [
		{
			"id": 2,
			"job_name": "electrian",
			"user_id": 1,
 			"service_provider_ids": "28, 29",
			"created_at": "2022-07-12T09:27:12.000000Z",
			"updated_at": "2022-07-12T09:27:12.000000Z",
			"service_provider_ids: {					
		},
		{
				"id": 28,
				"name": "vandan",
		},
		{
			"id": 29,
			"name": "demo",
		}
	}
]

}

@vandan ok ? thats what you asked for , what , showed as a response for the code I wrote ?