000

<?php

namespace App\Exports;

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

class ExportFNF implements FromCollection,WithHeadings
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
    if(\Auth::user()->role_id=='1'){
        $response= \App\MembershipDetail::where('is_active', 1)->where('folio_number', '=', null)->where('final_approval_status', '=', 'Approved')->get();
    }else{
        $response= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->where('folio_number', '=', null)->where('final_approval_status', '=', 'Approved')->get();
    }
        $n=0;
        $array=[];
       foreach($response as $key=>$val){
        $array[$n]['sr_no']=$key+1;
        $array[$n]['form_no']=$val->form_no;
        $array[$n]['member_code']=$val->member_code;
        $array[$n]['folio_number']=$val->folio_number;
        $n++;
    }
    //   return $array; 
    
      //return $data;
        return collect($array);
    }
    
    public function headings(): array
     { 
        return [
            'Sr. No.',
            'FormNumber',
            'MemberCode',
            'FolioNumber',
        ];
}
        
}