000

<?php

namespace App\Imports;

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

class FolioNumberImport 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('member_code',$sheet['membercode'])->where('form_no',$sheet['formnumber'])->first();
               
              if(!is_null($MembershipDetail)){
                $MembershipDetail->folio_number = $sheet['folionumber'];
                $MembershipDetail->save();
                array_push($this->membershipFoundArr, $sheet['formnumber']);
              }else{
                array_push($this->membershipNotFoundArr, $sheet['membercode']);      
              }
            }
        }
        
        // foreach ($collection as $key=>$sheet) {
        // //   dd($sheet);
        //       if(count($sheet) > 0){
        //           $MembershipDetail = \App\MembershipDetail::where('form_no',$sheet['form_no'])->first();
        //             // dd($MembershipDetail);
        //           if($MembershipDetail!=''){
        //              $MembershipDetail->fee_receipt_no = $sheet['fee_receipt_no'];
        //              $MembershipDetail->fee_receipt_date = $sheet['fee_receipt_date'];
        //              $MembershipDetail->save();
        //               array_push($this->membershipFoundArr, $sheet['form_no']);
        //           }else{
        //              array_push($this->membershipNotFoundArr, $sheet['form_no']);
        //           }
        //         }
        //     }
        
    }
    // public function collection(Collection $collection)
    // {
    //   foreach ($collection as $key=>$sheet) {
    //     //   dd($sheet);
    //           if(count($sheet) > 0){
    //               $MembershipDetail = \App\MembershipDetail::where('member_code',$sheet['membercode'])->where('form_no',$sheet['formnumber'])->first();
    //                 // dd($MembershipDetail);
    //               if($MembershipDetail!=''){
    //                  $MembershipDetail->folio_number = $sheet['folionumber'];
    //                  $MembershipDetail->save();
    //               }else{
                     
    //               }
    //             }else{
                   
    //             }
    //         }
    // }
}