SpiceManagementSystem/app/Models/Product.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Product extends Model
{
    protected $fillable = ['title', 'lot_prefix', 'description', 'images', 'package_content', 'recipes_id', 'shopify_product_id'];

    protected $casts = [
        'images' => 'array',
    ];


    public function recipe()
    {
        return $this->belongsTo(Recipe::class, 'recipes_id');
    }

    public function recipeVersions()
    {
        return $this->hasMany(Recipe::class)->orderByDesc('version');
    }

    public function sizes()
    {
        return $this->belongsToMany(Packing::class, 'products_sizes')
                    ->withPivot('price', 'description', 'sku', 'gtin')
                    ->withTimestamps();
    }

    public function inventories()
    {
        return $this->hasMany(ProductInventory::class);
    }

    public function batches()
    {
        return $this->hasMany(Batch::class);
    }
}