File: /home/jubaroyal/public_html/app/Imports/ProductsImport.php
<?php
namespace App\Imports;
use App\Models\Product;
use Maatwebsite\Excel\Concerns\ToModel;
class ProductsImport implements ToModel
{
/**
* @param array $row
*
* @return \Illuminate\Database\Eloquent\Model|null
*/
public function model(array $row)
{
return new Product([
'name' => $row[0],
'supplier_id' => $row[1],
'shelf_id' => $row[2],
'store_id' => $row[3],
'category_id' => $row[4],
'code' => $row[5],
'purchase_date' => $row[6],
'expiry_date' => $row[7],
'purchase_price' => $row[8],
'selling_price' => $row[9],
'currency_id' => $row[10],
'status' => $row[11],
'created_at' => $row[12],
]);
}
}