djid_siput/app/Exports/MetadataProgramExport.php

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithCustomStartCell;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;
use App\Model\TahunProgramDetail;
use App\Model\MetadataProgram;
use Maatwebsite\Excel\Concerns\WithTitle;
use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\WithMultipleSheets;
use Maatwebsite\Excel\Concerns\Exportable;
use Illuminate\Http\Request;

class MetadataProgramExport implements WithMultipleSheets
{
    use Exportable;
    
    public function __construct(Request $request)
    {
        $this->request = $request;
    }

    /**
     * @return array
     */
    public function sheets(): array
    {
        $raw = TahunProgramDetail::find($this->request->id);
        $tahunProgramDetail = TahunProgramDetail::where('id_template_program',$raw->id_template_program)->where('id_tahun_program',$raw->id_tahun_program)->get();
        foreach($tahunProgramDetail as $row){
            $sheets[] = new MetadataProgramDetailExport($this->request, $row);
        }
        
        return $sheets;
    }
}