000

<?php

namespace App\Exports;

use Illuminate\Http\Request;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use DB;
use Maatwebsite\Excel\Concerns\WithColumnFormatting;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;
use Maatwebsite\Excel\Concerns\WithColumnWidths;

// class UserFormExport implements FromCollection,WithHeadings
class MemberFormExport extends \PhpOffice\PhpSpreadsheet\Cell\StringValueBinder implements FromCollection,WithHeadings
,WithColumnFormatting, WithColumnWidths
{
     public function columnWidths(): array
    {
        return [
            'BO' => 30,
        ];
    }
    
    public function __construct(Request $request)
    {
        $this->request = $request;
    }
    public function collection()
    {
        $request = $this->request;
        
        $mcc_name = $request->mcc_name_export;
        $mpp_name = $request->mpp_name_export;
        $from = $request->from_date_export;
        $to = $request->status_export;
        $status = $request->status_export;
        // dd($status);
        $currentDate= date('Y-m-d');
         
        if(!empty($mcc_name) && empty($mpp_name) && empty($from) && empty($to)){
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mcc_code',$mcc_name)->where('membership_details.final_approval_status','Approved')->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Rejected'){
                 $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mcc_code',$mcc_name)->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                 $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mcc_code',$mcc_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
           }elseif($status=='Resubmitted'){
                 $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mcc_code',$mcc_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mcc_code',$mcc_name)->orderBy('membership_details.id','desc')->get();
            }
        }elseif(!empty($mcc_name) && !empty($mpp_name) && empty($from) && empty($to)){
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Approved')->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Rejected'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Resubmitted'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->orderBy('membership_details.id','desc')->get();
           }
        }elseif(!empty($mcc_name) && !empty($mpp_name) && !empty($from) && empty($to)){
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDate])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Approved')->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Rejected'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDate])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDate])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Resubmitted'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDate])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDate])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->orderBy('membership_details.id','desc')->get();
           }
        }elseif(!empty($mcc_name) && !empty($mpp_name) && !empty($from) && !empty($to)){
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Approved')->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Rejected'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Resubmitted'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.mpp_code',$mpp_name)->orderBy('membership_details.id','desc')->get();
           }
        }elseif(!empty($mcc_name) && empty($mpp_name) && !empty($from) && !empty($to)){
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.final_approval_status','Approved')->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Rejected'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Resubmitted'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mcc_code',$mcc_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mcc_code',$mcc_name)->orderBy('membership_details.id','desc')->get();
           }
        }elseif(empty($mcc_name) && !empty($mpp_name) && empty($from) && empty($to)){
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Approved')->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Rejected'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Resubmitted'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.mpp_code',$mpp_name)->orderBy('membership_details.id','desc')->get();
           }
        }elseif(empty($mcc_name) && !empty($mpp_name) && !empty($from) && empty($to)){
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDateo])->where('membership_details.mpp_code',$mpp_name)->orderBy('membership_details.id','desc')->where('membership_details.final_approval_status','Approved')->get();
            }elseif($status=='Rejected'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDateo])->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDateo])->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Resubmitted'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDateo])->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDateo])->where('membership_details.mpp_code',$mpp_name)->orderBy('membership_details.id','desc')->get();
           }
        }elseif(empty($mcc_name) && !empty($mpp_name) && !empty($from) && !empty($to)){
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Approved')->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Rejected'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Resubmitted'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mpp_code',$mpp_name)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.mpp_code',$mpp_name)->orderBy('membership_details.id','desc')->get();
           }
        }elseif(empty($mcc_name) && empty($mpp_name) && !empty($from) && empty($to)){
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDate])->where('membership_details.final_approval_status','Approved')->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Rejected'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDate])->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDate])->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Resubmitted'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDate])->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$currentDate])->orderBy('membership_details.id','desc')->get();
           }
        }elseif(empty($mcc_name) && empty($mpp_name) && !empty($from) && !empty($to)){
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.final_approval_status','Approved')->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Rejected'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Resubmitted'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->whereBetween(DB::raw('date(membership_details.created_at)'),[$from,$to])->orderBy('membership_details.id','desc')->get();
           }
        }else{
            if($status=='Approved'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.final_approval_status','Approved')->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Rejected'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.final_approval_status','Rejected')->orderBy('membership_details.id','desc')->get();
            }elseif($status==''){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', null)->orderBy('membership_details.id','desc')->get();
            }elseif($status=='Resubmitted'){
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->where('membership_details.final_approval_status',null)->where('membership_details.resubmit_status', 2)->orderBy('membership_details.id','desc')->get();
            }else{
                $form_data = \DB::table('membership_details')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('membership_details.is_active', 1)->orderBy('membership_details.id','desc')->get();
            }
        }

$finalArr = array();
        $n = 0 ;
        foreach($form_data as $key=>$member_data) {
            $finalArr[$n]['form_number'] = $member_data->form_no;
            $finalArr[$n]['member_name'] = strtoupper($member_data->applicant_name);
            $finalArr[$n]['father_name'] = $member_data->husband_or_father_name;
            $finalArr[$n]['member_relation'] = $member_data->husband_or_father;
            $finalArr[$n]['gender'] = $member_data->gender;
            $finalArr[$n]['age'] = $member_data->applicant_age;
            $finalArr[$n]['caste_category'] = $member_data->cast;
            $finalArr[$n]['qualification'] = $member_data->education;
            $finalArr[$n]['house_no'] = $member_data->house_no;
            $finalArr[$n]['member_hamlet_code'] = $member_data->hamlet_code;
            $finalArr[$n]['member_hamlet_name'] = $member_data->hamlet_name;
            $finalArr[$n]['member_village_code'] = $member_data->village_code;
            $finalArr[$n]['member_village_name'] = $member_data->village_name;
            $finalArr[$n]['post_office'] = $member_data->post_office;
            $finalArr[$n]['member_tehshil_code'] = $member_data->tehsil_code;
            $finalArr[$n]['member_tehshil_name'] = $member_data->tehsil_name;
            $finalArr[$n]['member_district_code'] = $member_data->district_code;
            $finalArr[$n]['member_district_name'] = $member_data->district_name;
            $finalArr[$n]['state_name'] = $member_data->state_name;
            $finalArr[$n]['pincode'] = $member_data->pincode;
            $finalArr[$n]['mobile_no'] = $member_data->mobile_no;
            $finalArr[$n]['phone_no'] = $member_data->landline;
            $finalArr[$n]['shg_member'] = $member_data->shg_member;
            $desiCow = explode(',', $member_data->desiCow);
            $buffalo = explode(',', $member_data->buffalo);
            $crossBred = explode(',', $member_data->crossBred);
            
            $finalArr[$n]['cow_herifer_no'] = isset($member_data->desiCow[0])?$member_data->desiCow[0]:0;
            $finalArr[$n]['buffalo_herifer_no'] = isset($member_data->buffalo[0])?$member_data->buffalo[0]:0;
            $finalArr[$n]['mix_herifer_no'] = isset($member_data->crossBred[0])?$member_data->crossBred[0]:0;
            
            $finalArr[$n]['cow_dry_no'] = isset($member_data->desiCow[1])?$member_data->desiCow[1]:0;
            $finalArr[$n]['buffalo_dry_no'] = isset($member_data->buffalo[1])?$member_data->buffalo[1]:0;
            $finalArr[$n]['mix_dry_no'] = isset($member_data->crossBred[1])?$member_data->crossBred[1]:0;
            
            $finalArr[$n]['cow_animal_nos'] = isset($member_data->desiCow[2])?$member_data->desiCow[2]:0;
            $finalArr[$n]['buffalo_animal_nos'] = isset($member_data->buffalo[2])?$member_data->buffalo[2]:0;
            $finalArr[$n]['mix_animal_nos'] = isset($member_data->crossBred[2])?$member_data->crossBred[2]:0;
            
            $finalArr[$n]['lpd_no'] = '';
            $finalArr[$n]['household_consumption'] = $member_data->HouseHoldConsumption;
            $finalArr[$n]['market_consumption'] = $member_data->MarketableSurplus;
            $finalArr[$n]['accountant_name'] = $member_data->account_holder_name;
            $finalArr[$n]['bank_account_no'] = $member_data->s_account_number;
            $finalArr[$n]['member_bank_name'] = $member_data->bank_name;
            $finalArr[$n]['member_branch_name'] = $member_data->branch_name;
            $finalArr[$n]['ifsc'] = $member_data->ifsc_code;
            $finalArr[$n]['particluar1_name'] = '';
            $finalArr[$n]['particluar1_name_gender'] = '';
            $finalArr[$n]['particluar1_name_age'] = '';
            $finalArr[$n]['particluar1_relation_name'] = '';
            $finalArr[$n]['nominee_name'] = $member_data->nominee_name;
            $finalArr[$n]['relation'] = $member_data->relation_with_application;
            $finalArr[$n]['nominee_address'] = $member_data->address;
            $finalArr[$n]['guardian_name'] = $member_data->guardian_name;
            $finalArr[$n]['member_family_age'] = $member_data->age;
            $finalArr[$n]['mcc_tr_code'] = '';
            $finalArr[$n]['mcc_name'] = '';
            $finalArr[$n]['mpp_tr_code'] = '';
            $finalArr[$n]['mpp_name'] = '';
            $finalArr[$n]['mpp_village_code'] = $member_data->village_code;
            $finalArr[$n]['mpp_village_name'] = $member_data->village_name;
            $finalArr[$n]['mpp_tehshil_code'] = $member_data->tehsil_code;
            $finalArr[$n]['mpp_tehshil_name'] = $member_data->tehsil_name;
            $finalArr[$n]['mpp_district_code'] = $member_data->district_code;
            $finalArr[$n]['mpp_district_name'] = $member_data->district_name;;
            $finalArr[$n]['mpp_hamlet_code'] = $member_data->hamlet_code;
            $finalArr[$n]['mpp_hamlet_name'] = $member_data->hamlet_name;
            $finalArr[$n]['aadhar_no'] = $member_data->aadhar_card;
            $finalArr[$n]['admission_fee'] = $member_data->admission_fee;
            $finalArr[$n]['share_qty'] = $member_data->share_quantity;
            $finalArr[$n]['paid_amount'] = $member_data->received_amount;
            $finalArr[$n]['depositor_bank_name'] = $member_data->fee_bank_name;
            $finalArr[$n]['depositor_branch_name'] = $member_data->fee_branch_name;
            $finalArr[$n]['DD_no'] = $member_data->fee_receipt_no;
            $finalArr[$n]['transaction_date'] = $member_data->fee_receipt_date;
            $finalArr[$n]['payment_mode'] = $member_data->cash_dd;
            $finalArr[$n]['wef_date'] = '';
            $finalArr[$n]['member_tr_code'] = '';
            $finalArr[$n]['member_type'] = '';
            $finalArr[$n]['user_id'] = '';
            $finalArr[$n]['approval_status'] = '';  
            $finalArr[$n]['accepted_by'] = '';
            $finalArr[$n]['approval_date'] = '';
            // $finalArr[$n]['member_status'] = ($member_data->is_active == 1)?"Active":"InActive";
            $finalArr[$n]['ao_approval_status']=$member_data->ao_approval_status;
         //   $finalArr[$n]['lo_approval_status']=$member_data->lo_approval_status;
            $finalArr[$n]['fo_approval_status']=$member_data->fo_approval_status;
             $finalArr[$n]['member_status']=$member_data->final_approval_status;
             $finalArr[$n]['remark']=$member_data->remark;
             $finalArr[$n]['created_by'] = getModelById('User',$member_data->created_by_id)->name;
             $finalArr[$n]['member_code'] = $member_data->member_code;
             $finalArr[$n]['folio_number'] = $member_data->folio_number;
             $finalArr[$n]['birth_date']=date("d.m.Y", strtotime($member_data->dob));
            // if(!empty($member_data->final_approval_status)){
            //     $finalArr[$n]['member_status']=$member_data->final_approval_status;
            // }else{
            //     $finalArr[$n]['member_status']="Pending";
            // }
            $n++;
        }
        
        return collect($finalArr);

}
    
    public function columnFormats(): array
    {
        return [
            'U' => '0',
            'BO' => '0',
            'AJ' => '0',
            'BI' => '0',
            'CE' => '0',
            'CF' => '0',
        ];
    }
   
    public function headings(): array
     { 
        return [
            'form_number',
            'member_name',
            'father_name',
            'member_relation',
            'gender',
            'age',
            'caste_category',
            'qualification',
            'house_no',
            'member_hamlet_code',
            'member_hamlet_name',
            'member_village_code',
            'member_village_name',
            'post_office',
            'member_tehshil_code',
            'member_tehshil_name',
            'member_district_code',
            'member_district_name',
            'state_name',
            'pincode',
            'mobile_no',
            'phone_no',
            'cow_herifer_no',
            'buffalo_herifer_no',
            'mix_herifer_no',
            'cow_dry_no',
            'buffalo_dry_no',
            'mix_dry_no',
            'cow_animal_nos',
            'buffalo_animal_nos',
            'mix_animal_nos',
            'lpd_no',
            'household_consumption',
            'market_consumption',
            'accountant_name',
            'bank_account_no',
            'member_bank_name',
            'member_branch_name',
            'ifsc',
            'particluar1_name',
            'particluar1_name_gender',
            'particluar1_name_age',
            'particluar1_relation_name',
            'nominee_name',
            'relation',
            'nominee_address',
            'guardian_name',
            'member_family_age',
            'mcc_tr_code',
            'mcc_name',
            'mpp_tr_code',
            'mpp_name',
            'mpp_village_code',
            'mpp_village_name',
            'mpp_tehshil_code',
            'mpp_tehshil_name',
            'mpp_district_code',
            'mpp_district_name',
            'mpp_hamlet_code',
            'mpp_hamlet_name',
            'aadhar_no',
            'admission_fee',
            'share_qty',
            'paid_amount',
            'depositor_bank_name',
            'depositor_branch_name',
            'transaction_number',
            'transaction_date',
            'payment_mode',
            'wef_date',
            'member_tr_code',
            'member_type',
            'user_id',
            'approval_status',
            'accepted_by',
            'approval_date',
            'pib_officer_status',
         //   'legal_officer_status',
            'finance_officer_status',
            'final_approval_status',
            'remark',
            'facilitator',
            'member_code',
            'folio_number',
            'birth_date'
        ];
    }
 
}