000

<?php

namespace App\Imports;

use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class MemberCodeImport implements ToCollection,WithHeadingRow
{
    /**
    * @param Collection $collection
    */
    
    private $membershipNotFoundArr = array();
    private $membershipFoundArr = array();
    
    public function memberShipNotFoundId()
    {
        return $this->membershipNotFoundArr;
    }
    public function memberShipFoundId()
    {
        return $this->membershipFoundArr;
    }
    
    
    public function collection(Collection $collection)
    {
    
        foreach ($collection as $key=>$sheet) {
          
            if(count($sheet) > 0){
               
              $MembershipDetail = \App\MembershipDetail::where('form_no',$sheet['formnumber'])->first();
               $MemberCode = \App\MembershipDetail::where('member_code',$sheet['membercode'])->first();
               
              if(!is_null($MembershipDetail) && is_null($MemberCode)){
                $MembershipDetail->member_code = $sheet['membercode'];
                $MembershipDetail->board_meeting_reference_number = $sheet['board_meeting_reference_number'];
                $MembershipDetail->meeting_date = $sheet['meeting_date'];
                $MembershipDetail->save();
                array_push($this->membershipFoundArr, $sheet['formnumber']);
              }else{
                array_push($this->membershipNotFoundArr, $sheet['formnumber']);      
              }
            }
        }
        
    }
}