<?php

namespace App\Exports;

use App\Models\Product;
use Maatwebsite\Excel\Concerns\FromCollection;

class ProductsExport implements FromCollection
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        // return Product::all();
        return Product::select('name', 'supplier_id', 'shelf_id', 'store_id', 'category_id', 'code', 'purchase_date', 'expiry_date', 'purchase_price', 'selling_price', 'currency_id', 'status', 'created_at')->get(); // fields to be exported
    }
}