laravel, how can I add extra attribute to model?

Question

I have a product table and a sub_product table.

In product table there are many global field like name and cat_id . In sub_product table there are product_id, color and Price

Now I want add a filed only to product laravel model(collection) that give me minimum price for each product fromsub_product. how can I do that?

I think you have to declare a variable in product, say $minPrice and in controllorer you have to calculate value of this variable by checking price of each subproduct . — Diabolus
– Diabolus, Commented Jul 13, 2017 at 5:55
Also, if you have some code you tried, please share it with us. — Diabolus
– Diabolus, Commented Jul 13, 2017 at 5:56
@Diabolus no I dont want calculate in controller. only just like a filed in table that there is every where and every relation. — Hamid Naghipour
– Hamid Naghipour, Commented Jul 13, 2017 at 6:07

Geoffrey · Accepted Answer · 2017-07-13 06:18:23Z

1

In Product class, define relationship:

public function subproducts()
{
    return $this->hasMany(SubProduct::class);
}

Define an accessor method:

public function getMinimumPriceAttribute()
{
    return $this->subproducts()->min('price');
}

Retrieve value as field:

$price = $product->minimum_price;

answered Jul 13, 2017 at 6:18

Geoffrey

5,42910 gold badges49 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Hamid Naghipour Over a year ago

protected $appends = array('min_price'); add this in model. when use ->toArray() can see this filed. do you know how can I show this filed in collection view inside of attributes? thank you.

Geoffrey Over a year ago

@HamidNaghipour, how do you want to use it with in collection? For example, what would the code look like?

Geoffrey Over a year ago

@HamidNaghipour, depending on the collection method, you could use a closure, and access $product->minimum_price inside that.

Zulfiqar Tariq · Accepted Answer · 2017-07-13 05:56:59Z

0

i think you should define a relationship in product model with sub_product model and then you can query the product based on this relationship. THe relationship will be one to many.

 public function hasSubPRoducts(){
    return $this->hasMany('\App\SubProduct','product_id','id');
    }

then query the model

 \App\Products::where('products_id',$id)-
>with(['hasSubPRoducts',function($query){
$query->orderBy('price', 'DESC');
}
])->get()->first();

answered Jul 13, 2017 at 5:56

Zulfiqar Tariq

3943 silver badges14 bronze badges

5 Comments

Hamid Naghipour Over a year ago

thank you. what about when I want get like this : \App\category->with("Products") ?

Zulfiqar Tariq Over a year ago

then you would user nested relationship using Dot operator \App\category->with("Products.hasSubPRoducts")

Hamid Naghipour Over a year ago

you mean like this?! \App\category::- >with(['Products.hasSubPRoducts',function($query){ $query->orderBy('price', 'DESC'); } ])->get()->first(); I think this is wrong!

Zulfiqar Tariq Over a year ago

\App\category::find($category_id)->with(['Products.hasSubPRoducts',function($query){ $query->orderBy('price', 'DESC'); } ])->get()->first();

Zulfiqar Tariq Over a year ago

\App\category::where('cat_id',2)->with(['Products.hasSubPRo‌ducts',function($que‌ry){ $query->orderBy('price', 'DESC'); } ])->get()->first(); where cat_id will be name of category id column in your table this will work like charm.

Collectives™ on Stack Overflow

laravel, how can I add extra attribute to model?

2 Answers 2

3 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related