000

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithColumnFormatting;
use Illuminate\support\Facades\DB;

class ExportFormList implements FromCollection,WithHeadings, WithColumnFormatting
{
    protected $from_date;
    protected $to_date;
    protected $mc_fn;
    
     function __construct($from_date,$to_date,$mc_fn) {
            $this->mc_fn = $mc_fn;
            $this->from_date = $from_date;
            $this->to_date = $to_date;
     }
    
    public function columnFormats(): array
    {
        return [
            'R' => '0',
            'AH' => '0',
            'BX' => '0',
            'CE' => '0',
            'BM' => 'd-m-y'
        ];
    }
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
    // if(\Auth::user()->role_id=='1'){
    //     $response= \App\MembershipDetail::select('membership_details.*', 'users.name as field_agent_name', 'master.state_code', 'master.hamlet_code', 'master.hamlet_name')->join('users', 'users.id', 'membership_details.created_by_id')->join('master', function($join){
    //         $join->on('master.village_code', 'membership_details.revanue_vill_code');
    //         $join->on('master.mpp_code', 'membership_details.mpp_code');
    //         $join->on('master.mcc_code', 'membership_details.mcc_code');
    //     })->where('membership_details.is_active', 1)->where('final_approval_status','Approved')->get();
    // }else{
    //     $response= \App\MembershipDetail::select('membership_details.*', 'users.name as field_agent_name', 'master.state_code', 'master.hamlet_code', 'master.hamlet_name')->join('users', 'users.id', 'membership_details.created_by_id')->join('master', function($join){
    //         $join->on('master.village_code', 'membership_details.revanue_vill_code');
    //         $join->on('master.mpp_code', 'membership_details.mpp_code');
    //         $join->on('master.mcc_code', 'membership_details.mcc_code');
    //     })->where('membership_details.created_by_id', \Auth::user()->id)->where('membership_details.is_active', 1)->where('final_approval_status','Approved')->get();
    // }
    if(\Auth::user()->role_id=='1'){
        // if(!empty($this->from_date) && !empty($this->to_date)){
        // $response= \App\MembershipDetail::select('membership_details.*', 'users.name as field_agent_name')->join('users', 'users.id', 'membership_details.created_by_id')->where('membership_details.is_active', 1)->where('final_approval_status','Approved')->whereBetween(DB::raw('date(membership_details.updated_at)'),[$this->from_date,$this->to_date])->get();
        // }elseif(!empty($this->from_date) && empty($this->to_date)){
        //     $response= \App\MembershipDetail::select('membership_details.*', 'users.name as field_agent_name', 'master.state_code', 'master.hamlet_code', 'master.hamlet_name')->join('users', 'users.id', 'membership_details.created_by_id')->join('master', function($join){
        //         $join->on('master.village_code', 'membership_details.revanue_vill_code');
        //         $join->on('master.mpp_code', 'membership_details.mpp_code');
        //         $join->on('master.mcc_code', 'membership_details.mcc_code');
        //     })->where('membership_details.is_active', 1)->where('final_approval_status','Approved')->whereBetween(DB::raw('date(membership_details.updated_at)'),[$this->from_date,date('Y-m-d')])->get();
        // }else{
        //     $response= \App\MembershipDetail::select('membership_details.*', 'users.name as field_agent_name', 'master.state_code', 'master.hamlet_code', 'master.hamlet_name')->join('users', 'users.id', 'membership_details.created_by_id')->join('master', function($join){
        //     $join->on('master.village_code', 'membership_details.revanue_vill_code');
        //     $join->on('master.mpp_code', 'membership_details.mpp_code');
        //     $join->on('master.mcc_code', 'membership_details.mcc_code');
        //   })->where('membership_details.is_active', 1)->where('final_approval_status','Approved')->get();
        // }
            $query = \App\MembershipDetail::query();
            if(!empty($this->from_date) && !empty($this->to_date)){
            	$query->whereBetween(DB::raw('date(membership_details.updated_at)'),[$this->from_date,$this->to_date]);
            }
            if(!empty($this->from_date) && empty($to)){
            	$query->whereBetween(DB::raw('date(membership_details.updated_at)'),[$this->from_date,date('Y-m-d')]);
            }
            if($this->mc_fn){
            if($this->mc_fn=='MemberCode'){
            	$query->where('membership_details.member_code','!=',null);
            }
            if($this->mc_fn=='NonMemberCode'){
            	$query->where('membership_details.member_code',null);
            }
            if($this->mc_fn=='FolioNumber'){
            	$query->where('membership_details.folio_number','!=',null);
            }
            if($this->mc_fn=='NonFolioNumber'){
            	$query->where('membership_details.folio_number',null);
            }
            }
            $response = $query->select('membership_details.*', 'users.name as field_agent_name', 'master.state_code', 'master.hamlet_code', 'master.hamlet_name','master.mcc_name as mccname','master.mcc_code as mcccode','master.mpp_name as mppname','master.mpp_code as mppcode','master.village_code','master.village_name')->join('users', 'users.id', 'membership_details.created_by_id')->join('master', function($join){
                $join->on('master.mpp_code', 'membership_details.mpp_code');
                $join->on('master.mcc_code', 'membership_details.mcc_code');
            })->where('membership_details.is_active', 1)->where('master.is_active', 1)->where('membership_details.final_approval_status','Approved')->get();
    }else{
        $response= \App\MembershipDetail::select('membership_details.*', 'users.name as field_agent_name', 'master.state_code', 'master.hamlet_code', 'master.hamlet_name')->join('users', 'users.id', 'membership_details.created_by_id')->join('master', function($join){
            $join->on('master.mpp_code', 'membership_details.mpp_code');
            $join->on('master.mcc_code', 'membership_details.mcc_code');
        })->where('membership_details.created_by_id', \Auth::user()->id)->where('membership_details.is_active', 1)->where('master.is_active', 1)->where('membership_details.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]['applicant_name']=$val->applicant_name;
        $array[$n]['husband_or_father']=$val->husband_or_father;
        // $array[$n]['husband_or_father_name']=$val->husband_or_father_name;
        $array[$n]['husband_or_father_name']=preg_replace('/[^a-zA-Z0-9_ -]/s','',substr($val->husband_or_father_name, strpos($val->husband_or_father_name, ":")));
        $array[$n]['gender']=$val->gender;
        $array[$n]['applicant_age']=$val->applicant_age;
        $array[$n]['cast']=$val->cast;
        $array[$n]['education']=$val->education;
        $array[$n]['house_no']=$val->house_no;
        $array[$n]['helmet']=$val->hamlet_name;
        $array[$n]['village']=$val->village;
        $array[$n]['post_office']=$val->post_office;
        $array[$n]['tehsil']=$val->tehsil;
        $array[$n]['district']=$val->district;
        $array[$n]['state']=$val->state;
        $array[$n]['pincode']=$val->pincode;
        $array[$n]['mobile_no']= (string) $val->mobile_no;
        $array[$n]['landline']=$val->landline;
        $array[$n]['milk_product_date']=$val->milk_product_date;
        
        $my_array1 = explode(",", $val->desiCow);
        
        $array[$n]['desiCow1']=(!isset($my_array1[0]) ||  $my_array1[0] == "")?"0":$my_array1[0];
        $array[$n]['desiCow2']=(!isset($my_array1[1]) ||  $my_array1[1] == "")?"0":$my_array1[1];
        $array[$n]['desiCow3']=(!isset($my_array1[2]) ||  $my_array1[2] == "")?"0":$my_array1[2];
        
        $my_array2 = explode(",", $val->crossBred);
        
        $array[$n]['crossBred1']=(!isset($my_array2[0]) ||  $my_array2[0] == "")?"0":$my_array2[0];
        $array[$n]['crossBred2']=(!isset($my_array2[1]) ||  $my_array2[1] == "")?"0":$my_array2[1];
        $array[$n]['crossBred3']=(!isset($my_array2[2]) ||  $my_array2[2] == "")?"0":$my_array2[2];
        
        $my_array3 = explode(",", $val->buffalo);
        
        $array[$n]['buffalo1']=(!isset($my_array3[0]) ||  $my_array3[0] == "")?"0":$my_array3[0];
        $array[$n]['buffalo2']=(!isset($my_array3[1]) ||  $my_array3[1] == "")?"0":$my_array3[1];
        $array[$n]['buffalo3']=(!isset($my_array3[2]) ||  $my_array3[2] == "")?"0":$my_array3[2];
        
    //   $my_array4 = explode(",", $val->total);
        $array[$n]['MilkProduction']=$val->MilkProduction;
        $array[$n]['HouseHoldConsumption']= (int)$val->HouseHoldConsumption;
        $array[$n]['MarketableSurplus']=$val->MarketableSurplus;
        $array[$n]['account_holder_name']=$val->account_holder_name;
        $array[$n]['s_account_number']=$val->s_account_number;
        $array[$n]['bank_name']=$val->bank_name;
        $array[$n]['branch_name']=$val->branch_name;
        
        $array1 = explode(",", $val->relation1);
     
        $array[$n]['Partcu_Nm1']=$array1[0];
        $array[$n]['Partcu_Nm1_Gen']=$array1[1];
        $array[$n]['Partcu_Nm1_Age']= (!isset($array1[2]) ||  $array1[2] == '')?"0":$array1[2];
        $array[$n]['Partcu_Nm1_Rel']=$array1[3];
        
        $array2 = explode(",", $val->relation2);
        
        $array[$n]['Partcu_Nm2']=$array2[0];
        $array[$n]['Partcu_Nm2_Gen']=$array2[1];
        $array[$n]['Partcu_Nm2_Age']=(!isset($array2[2]) ||  $array2[2] == "")?"0":$array2[2];
        $array[$n]['Partcu_Nm2_Rel']=$array2[3];
        
        $array3 = explode(",", $val->relation3);
       
        $array[$n]['Partcu_Nm3']=$array3[0];
        $array[$n]['Partcu_Nm3_Gen']=$array3[1];
        $array[$n]['Partcu_Nm3_Age']=(!isset($array3[2]) ||  $array3[2] == '')?"0":$array3[2];
        $array[$n]['Partcu_Nm3_Rel']=$array3[3];
        
        $array4 = explode(",", $val->relation4);
        
        $array[$n]['Partcu_Nm4']=$array4[0];
        $array[$n]['Partcu_Nm4_Gen']=$array4[1];
        $array[$n]['Partcu_Nm4_Age']=(!isset($array4[2]) ||  $array4[2] == '')?"0":$array4[2];
        $array[$n]['Partcu_Nm4_Rel']=$array4[3];
        
        $array5 = explode(",", $val->relation5);
        
        $array[$n]['Partcu_Nm5']=$array5[0];
        $array[$n]['Partcu_Nm5_Gen']=$array5[1];
        $array[$n]['Partcu_Nm5_Age']=(!isset($array5[2]) ||  $array5[2] == '')?"0":$array5[2];
        $array[$n]['Partcu_Nm5_Rel']=$array5[3];
        $array6 = explode(",", $val->relation6);
        $array[$n]['Partcu_Nm6']=$array6[0];
        $array[$n]['Partcu_Nm6_Gen']=$array6[1];
        $array[$n]['Partcu_Nm6_Age']=(!isset($array6[2]) ||  $array6[2] == '')?"0":$array6[2];
        $array[$n]['Partcu_Nm6_Rel']=$array6[3];
        $array[$n]['nominee_name']=$val->nominee_name;
        $array[$n]['relation_with_application']=$val->relation_with_application;
        $array[$n]['address']=$val->address;
        $array[$n]['guardian_name']=$val->guardian_name;
        
        // $date = explode('', $val->dob);
        
        $array[$n]['dob']=correctDateFormate($val->dob);
        $array[$n]['mcc_name']=$val->mccname;
        $array[$n]['mcc_code']=$val->mcccode;
        $array[$n]['mpp_name']=$val->mppname;
        $array[$n]['mpp_code']=$val->mppcode;
        $array[$n]['revanue_vill_name']=$val->village_name;
        $array[$n]['revanue_vill_code']=$val->village_code;
        $array[$n]['tehsil_name']=$val->tehsil_name;
        $array[$n]['district_name']=$val->district_name;
        $array[$n]['pooling_point_code']=$val->hamlet_code;
        $array[$n]['hamlet']=$val->mcc_name;
        $array[$n]['aadhar_card']= (string) $val->aadhar_card;
        $array[$n]['admission_fee']=$val->admission_fee;
        $array[$n]['share_quantity']=$val->share_quantity;
        $array[$n]['received_amount']=$val->received_amount;
        $array[$n]['cash_dd']=$val->cash_dd;
        $array[$n]['fee_bank_name']=$val->fee_bank_name;
        $array[$n]['fee_branch_name']=$val->fee_branch_name;
        $array[$n]['fee_receipt_no']=$val->fee_receipt_no;
        $array[$n]['fee_receipt_date']=$val->fee_receipt_date;
        $array[$n]['amount']=$val->received_amount;
        $array[$n]['id']=$val->field_agent_name;
        $array[$n]['ifsc_code']=$val->ifsc_code;
        $array[$n]['hamlet_code']= $val->hamlet_code;
        $array[$n]['state_code']= $val->state_code;
        $array[$n]['shg_member']= $val->shg_member;
        $n++;
    }
    //   return $array; 
      //return $data;
        return collect($array);
    }
    
    public function headings(): array
     { 
        return [
            'Sr. No.',
            'FormNumber',
            'ApplicantNm_Sec1',
            'FatherHusband_type_Sec1',
            'FatherHusbandNm_Sec1',	
            'Gender_Sec1',	
            'Age_Sec1',	
            'Cast_Sec1',	
            'Education_Sec1',	
            'House_Number_Sec1',	
            'Hamlet_Sec1',	
            'Village_Sec1',	
            'Post_Office_Sec1',	
            'Tehsil_Sec1',	
            'District_Sec1',	
            'State_Sec1',	
            'Pincode_Sec1',	
            'MobileNumber_Sec1',	
            'Landlineno_Sec1',	
            'Consumption_Date',
            'DesiCow_Heiferno_Sec1',	
            'DesiCow_DryNo_Sec1',	
            'DesiCow_InMilkNo_Sec1',	
            'Crossbred_Heiferno_Sec1',	
            'Crossbred_Dryno_Sec1',	
            'Crossbred_InMilkno_Sec1',	
            'Buffalo_Heiferno_Sec1',	
            'Buffalo_Dryno_Sec1',	
            'Buffalo_InMilkno_Sec1',	
            'LPD',	
            'Household_Consumption_Sec1',	
            'Markatable_surplus_Sec1',	
            'Nm_Saving_Ac',	
            'Saving_Ac_No',	
            'Bank_Name_Sec2',	
            'Branch_Name_Sec2',	
            'Partcu_Nm1',	
            'Partcu_Nm1_Gen',	
            'Partcu_Nm1_Age',	
            'Partcu_Nm1_Rel',	
            'Partcu_Nm2',	
            'Partcu_Nm2_Gen',	
            'Partcu_Nm2_Age',	
            'Partcu_Nm2_Rel',	
            'Partcu_Nm3',	
            'Partcu_Nm3_Gen',	
            'Partcu_Nm3_Age',	
            'Partcu_Nm3_Rel',	
            'Partcu_Nm4',	
            'Partcu_Nm4_Gen',	
            'Partcu_Nm4_Age',	
            'Partcu_Nm4_Rel',	
            'Partcu_Nm5',	
            'Partcu_Nm5_Gen',	
            'Partcu_Nm5_Age',	
            'Partcu_Nm5_Rel',	
            'Partcu_Nm6',	
            'Partcu_Nm6_Gen',		
            'Partcu_Nm6_Age',
            'Partcu_Nm6_Rel',	
            'Nominee_Nm_Sec2',	
            'Relationwith_Nominee_Sec2',	
            'Nominee_Address',	
            'Nominee_GuardianNm_Sec2',	
            'Nominee_DOB_Sec2',	
            'MCC_Name_Sec2',	
            'MCC_CODE_Sec2',	
            'Mpp_Nm_Sec2',	
            'Mpp_Code_Sec2',	
            'Rev_Vill_Nm_Sec2',	
            'Rev_Vill_Code_Sec2',	
            'Tehsil_Nm_Sec2',	
            'Distirict_Nm_Sec2',	
            'PoolingPoint_Code_Sec2',
            'Hamlet_Name_Sec2',	
            'Aadhar_Card_No_Sec2',	
            'Addmission_Fee_Sec3',	
            'Share_Qty_Sec3',	
            'Received_Amt_Sec3',	
            'CashDD_Sec3',	
            'Bank_Name_Sec3',	
            'Branch_Name_Sec3',	
            'DDNumber_Sec3',	
            'DDDate_Sec3',	
            'Amount_Sec3',	
            'UserId',	
            'IFSCODE',	
            'Hamlet_Code',
            'state_code',
            'shg_member'
        ];
}
        
}