Selamun Aleyküm, sebebini anliyamadigim bir sekilde, tablodaki sütünlari toplatinca sacma bir sonuc cikiyor.
Tablo Yapisi ve icerigi
qty int(1...
price | decimal(10,2)
total | decimal(10,2)
created_.....
tablo örnek kayit
id user_id order_id product_id qty price total created_at updated_at
47 1 13 1 1 5.71 5.71 2016-06-30 10:40:20 2016-06-30 10:40:20
48 1 13 2 1 6.11 6.11 2016-06-30 10:40:20 2016-06-30 10:40
49 1 13 3 1 14.53 14.53 2016-06-30 10:40:20 2016-06-30 10:40:20
metodum
/**
* Return Total Price from specified Order
*
* @param int $order_id
* @return float $totalprice
*/
public function totalPriceOrderProducts($order_id){
$totalprice = OrderProduct::where('order_id', $order_id)->sum('total');
return $totalprice;
}
sonuc
₺8.78