php - How To Eager load a Method in model

Question

I have a product model that has a method that returns the price of a product

public function ProductSeller()
{
    return $this->hasMany('AppProductSeller','product_id')->get();
}

public function price()
{
    $productSellers = $this->ProductSeller();
    foreach ($productSellers as $productSeller){
        $productPrice[]=$productSeller->price;
    }

    if (empty($productPrice) == true || min($productPrice) == '0'){
        $Rprice = 'call for price';
    } else {
        $Rprice = number_format(min($productPrice));
    }

    return $Rprice;
}

The problem is I want to Eager load it and get the price like $product->price but I get AppProduct::price must return a relationship instance.

Anybody can help me with it?

question from:https://stackoverflow.com/questions/65869175/how-to-eager-load-a-method-in-model

Answer 1

What you are trying to achieve can be done via accessor and gladly, you have already gone through half of the steps. Just change the name of your method in model as per Laravel's accessor naming convention like this:

public function ProductSeller()
{
    return $this->hasMany('AppProductSeller','product_id');
}



public function GetPriceAttribute()
{
    $productSellers = $this->ProductSeller;
    foreach ($productSellers as $productSeller){
        $productPrice[]=$productSeller->price;
    }

    if (empty($productPrice) == true || min($productPrice) == '0'){
        $Rprice = 'call for price';
    } else {
    $Rprice = number_format(min($productPrice));
    }

    return $Rprice;
}

Now, you can easily access the method like:

$product->price;

Note: In the model, get() function is removed from the end of the relationship and also, the relationship method is called without adding parenthesis in the GetPriceAttribute() method. This approach worked for me.