000

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;

class ExportAssignedMpp implements FromCollection,WithHeadings
{
    
    public $data;
    
	function __construct($data = null)
	{
		$this->data = $data;
	}
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        $assigned_user = \App\AssignUser::where('is_active', 1)->where('user_id', $this->data)->get();
        
        $finalArr = array();
        if(!$assigned_user->isEmpty()) {
            $n=0;
            
            foreach($assigned_user as $key=>$val){
                $mppArr = explode(',', $val->mpp_code);
                $mcc = $val->mcc_code;
                foreach($mppArr as $key1=>$mpp) {
                    $finalArr[$n]['mcc'] = $mcc;
                    $finalArr[$n]['mpp'] = $mpp;
                    $n++;
                }
            }   
        }
        
        return collect($finalArr);
    }
    
    public function headings(): array
     { 
        return [
            'mcc',
            'mpp',
        ];
}
        
}