Level 51
You can use the with / withPivot methods. On mobile atm, if I get chance today, I'll update the example.
1 like
Aug 1, 2020
3
Level 10
Laravel Excel Export Model with Relationship
This code only returns the Job Model only.
public function collection()
{
$jobs = Job::with("work")->get();
return $jobs;
}
I need each model rows with their corresponding child rows to appear inside it , just like nested table.
Level 10
Thanks @haz_ if you understand me , I want to export master detail
public function map($jobs): array
{
return [
[
$jobs->id,
$jobs->position,
$jobs->full_name,
$jobs->mother_name
],
[
$jobs->work // how to loop work
],
[
$jobs->education
]
];
This works but work and education become one json excel column when I export it.
Level 51
Ah I misunderstood. What happens if you put them inside the first array with mother_name and the rest?
return [
[
$jobs->I'd
$jobs->position
// etc
$jobs->work,
$jobs->education
]
]:
Please or to participate in this conversation.