1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / cdcdhaka.org / app / Imports /
Filename : ProductImport.php
back
<?php

namespace App\Imports;

use App\Domains\Products\Models\Brand;
use App\Domains\Products\Models\Product;
use App\Domains\Products\Models\Unit;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\WithUpserts;

class ProductImport implements ToCollection, WithUpserts
{


    public function collection(Collection $rows)
    {
        $units = Unit::all();
        $brands = Brand::all();
        foreach ($rows as $key => $row) {
            if ($key > 0) {
                $p_unit = $row[6];
                $p_unit = $units->where('name', $p_unit)->first()->id ?? '1';
                $s_unit = $row[7];
                $s_unit = $units->where('name', $s_unit)->first()->id ?? '1';
                $brand = $row[8];
                $brand = $brands->where('name', $brand)->first()->id ?? '1';
                $sku = $row[2];
                $product = Product::where('sku', $sku)->first();
                $product = $product ? $product : new Product();

                $product->name = $row[1];
                $product->sku = $row[2];
                $product->sale_price = $row[3];
                $product->purchase_price = $row[4];
                $product->opening_stock = $row[5];
                $product->purchase_unit = $p_unit;
                $product->sale_unit = $s_unit;
                $product->brand_id = $brand;
                $product->conversion_rate = $row[9];
                $product->alert_qty = $row[10];
                $product->available = $row[11];
                $product->order_limit = $row[12];
                $product->description = $row[13];
                $product->thumbnail_img = $row[14];
                $product->save();
            }
        }
    }

    /**
     * @return string|array
     */
    public function uniqueBy()
    {
        return 'sku';
    }
}