000

<?php

namespace App\Exports;

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

class ExportOtherFormList implements FromCollection,WithHeadings, WithColumnFormatting
{
    
    public function columnWidths(): array
    {
        return [
            'M' => 30,
            'N' => 30,
        ];
    }
    
    /**
    * @return \Illuminate\Support\Collection
    */
    protected $from_date;
    protected $to_date;
    protected $mc_fn;
    
     function __construct($from_date,$to_date,$mc_fn) {
          
            $this->from_date = $from_date;
            $this->to_date = $to_date;
            $this->mc_fn = $mc_fn;
     }
     
    public function collection()
    {
  
    if(\Auth::user()->role_id=='1'){
        // if(!empty($this->from_date) && !empty($this->to_date)){
        //     $response= \App\MembershipDetail::where('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::where('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::where('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.*','master.mpp_name as mppname','master.mpp_code as mppcode','master.village_code','master.hamlet_code')->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.*','master.mpp_name as mppname','master.mpp_code as mppcode','master.village_code','master.hamlet_code')->where('membership_details.created_by_id', \Auth::user()->id)->where('membership_details.is_active', 1)->where('master.is_active', 1)->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.final_approval_status','Approved')->get();
    }
        $n=0;
        $array=[];
       foreach($response as $key=>$val){
        // $array[$n]['sr_no']=$key+1;
        $array[$n]['mpp_code']=$val->mppcode;
        $array[$n]['form_no']=$val->form_no;
        $array[$n]['applicant_name']=$val->applicant_name;
        $array[$n]['gender']=$val->gender;
        $array[$n]['husband_or_father']=$val->husband_or_father;
        $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]['husband_or_father_name']=trim($val->husband_or_father_name, ":");
        $array[$n]['revanue_vill_code']=$val->village_code;
        $array[$n]['hamlet_code']=substr($val->hamlet_code, -2);
        $array[$n]['pincode']=$val->pincode;
        $array[$n]['post_office']=$val->post_office;
        $array[$n]['mobile_no']=$val->mobile_no;
        $array[$n]['ifsc_code']=$val->ifsc_code;
        $array[$n]['s_account_number']=$val->s_account_number;
        $array[$n]['aadhar_card']= $val->aadhar_card;
        // $array[$n]['member_type']=$val->shg_member;
        if($val->shg_member=='Yes'){
            $array[$n]['member_type']='SHG';
        }elseif($val->shg_member=='No'){
            $array[$n]['member_type']='NONE';
        }
        $array[$n]['created_at']=$val->created_at->format('d.m.Y');
        // $array[$n]['amount']=$val->received_amount;
        $array[$n]['amount']='500';
        if($val->fee_receipt_date){
             $array[$n]['transaction_date']=date("d.m.Y", strtotime($val->fee_receipt_date));
        }else{
             $array[$n]['transaction_date']="Null";
        }
        $array[$n]['birth_date']=date("d.m.Y", strtotime($val->dob));
        $array[$n]['utr_no']= $val->fee_receipt_no;
        $n++;
    }
    // dd($array);
    //   return $array; 
      //return $data;
        return collect($array);
    }
    
    
    public function columnFormats(): array
    {
        return [
            'K' => '0',
            'M' => '0',
            'N' => '0',
        ];
    }
    
    public function headings(): array
     { 
        return [
            // 'Sr. No.',
            'mpp_code',
            'application_no',
            'applicant_name',
            'gender',
            'relation',	
            'relationship_name',	
            'village_code',
            'hamlet_code',	
            'pincode',	
            'post_office',	
            'mobile_no',	
            'ifsc',	
            'account_no',	
            'aadhar_no',	
            'member_type',	
            'registration_date',	
            'amount_deposited',
            'transaction_date',
            'birth_date',
            'utr_no',
        ];
}
        
}