<?php
namespace App\Imports;


use App\CoronaHotspot;
use Carbon\Carbon;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\ToArray;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class Corona implements ToCollection, WithHeadingRow   {


    use Importable;

    /**
     * @param Collection $collection
     */

    public function  collection(Collection $collection)
    {

        $response = [];
        $date = Carbon::now()->toDateTimeString();
        foreach ($collection as $item=>$value){
                if ((isset($value['city']) && !empty($value['city`']))||(isset($value['pin'])&&!empty($value['pin']))) {
                    $isExist = CoronaHotspot::Where('pincode', $value['pin'])->first(['id']);

                    if(!isset($isExist->id) && strlen($value['pin']) == 6) {
                        $response[] = [
                            'city_name' => $value['city'],
                            'pincode' => $value['pin'],
                            'created_at' => $date
                        ];
                    }
                }

        }


        if($response) {
            CoronaHotspot::insert($response);
        }
    }

    /**
     * @param array $array
     */
    public function array(array $array)
    {
        // TODO: Implement array() method.
    }
}