How to calculate the amount of materials?

Question

Laravel

There are 3 tables
materials
material_orders
- material_id
- quantity
- order_type
- order_id
store_orders
- staff_id
- total
Like in a loop

foreach($materials as $material){

}

Can I find the number of materials? taking into account the fact that the staff_id of store_order is set by me (you can scope), but I don’t understand how to apply it.
You can do it in a simple way and find the sum of quantity material_order where store_order has staff_id = given

Answer 1

If I understand correctly, you need to count the number of records in the table. Look here.