000

<?php

namespace App\Exports;

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

class ExportMasterData implements FromCollection,WithHeadings
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        $response= \DB::table('master')->where('is_active', 1)->get();
        $n=0;
        $array=[];
       foreach($response as $key=>$val){
        $array[$n]['sr_no']=$key+1;
        $array[$n]['district_name']=$val->district_name;
        $array[$n]['district_code']=$val->district_code;
        $array[$n]['village_name']=$val->village_name;
        $array[$n]['village_code']=$val->village_code;
        $array[$n]['hamlet_name']=$val->hamlet_name;
        $array[$n]['hamlet_code']=$val->hamlet_code;
        $array[$n]['mcc_name']=$val->mcc_name;
        $array[$n]['mcc_code']=$val->mcc_code;
        $array[$n]['mpp_name']=$val->mpp_name;
        $array[$n]['mpp_code']=$val->mpp_code;
        $array[$n]['state_name']=$val->state_name;
        $array[$n]['state_code']=$val->state_code;
        $array[$n]['tehsil_name']=$val->tehsil_name;
        $array[$n]['tehsil_code']=$val->tehsil_code;
        $n++;
    }
    //   return $array; 
      //return $data;
        return collect($array);
    }
    
    public function headings(): array
     { 
        return [
            'Sr. No.',
            'district_name',
            'district_code',
            'village_name',
            'village_code',
            'hamlet_name',
            'hamlet_code',
            'mcc_name',
            'mcc_code',
            'mpp_name',
            'mpp_code',
            'state_name',
            'state_code',
            'tehsil_name',
            'tehsil_code',
        ];
}
        
}