How to call Laravel Model function with parameter into Vuejs template?

Question

I have a product table and stock table. In stock table data about product sale and purchase are stored. I need to show the stock of every product base on purchase and sale. So I need to call a model function with product Id in vuejs template to calculate the stock quantity of the product. How to do this, or is there any alternative way? please help me out.

My product controller function is-

public function stock() {
    return Product::with(['category', 'stock'])->get();
}

My product model function is-

public function stock($id){
    $purchase_quantity = Stock::where([['product_id', $id], ['stock_type', 'purchase']])->sum('quantity');
    $sale_quantity = Stock::where([['product_id', $id], ['stock_type', 'sale']])->sum('quantity');
    return $purchase_quantity - $sale_quantity;
}

My vuejs template code where in every v-for iteration I want to call the model function-

   <tr v-for="product in products.data" :key="product.id">
      <td>{{ product.id }}</td>
      <td>{{ product.category.name }}</td>
      <td>{{ product.name }}</td>
      <td>{{ product.unit }}</td>
      <td>{{ product.stock(product.id) }}</td>
   </tr>

Here product.stock(product.id) is not working. It shows the error- Too few arguments to function App\Models\Product::stock(), 0 passed

Remove the id parameter from your method definition stock($id), then use $this->id instead of $id in your method. ['product_id', $id] => ['product_id', $this->id] — bassxzero
– bassxzero, Commented Mar 24, 2021 at 2:48

Kamlesh Paul · Accepted Answer · 2021-03-24 03:54:46Z

2

you need to use accessor in this case so

in Product.php


protected $appends = ['stocks'];

/**
 * Get the Product's stock
 *
 * @return int
 */
public function getStocksAttribute()
{
    $purchase_quantity = Stock::where([['product_id', $this->id], ['stock_type', 'purchase']])->sum('quantity');
    $sale_quantity = Stock::where([['product_id', $this->id], ['stock_type', 'sale']])->sum('quantity');
    return $purchase_quantity - $sale_quantity;
}

then in side javascript you can you can get stock in each product row like product.stocks

your vuejs code will be like this

<tr v-for="product in products.data" :key="product.id">
    <td>{{ product.id }}</td>
    <td>{{ product.category.name }}</td>
    <td>{{ product.name }}</td>
    <td>{{ product.unit }}</td>
    <td>{{ product.stocks }}</td>
</tr>

ref link https://laravel.com/docs/8.x/eloquent-mutators#defining-an-accessor

answered Mar 24, 2021 at 3:54

Kamlesh Paul

12.5k2 gold badges23 silver badges36 bronze badges

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

1 Comment

Abdullahil Kafi Over a year ago

I follow your instruction and In controller function I changed Product::with(['category', 'stock'])->get() => Product::with('category')->get(). It's working. Thank you very much.

Collectives™ on Stack Overflow

How to call Laravel Model function with parameter into Vuejs template?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related