Laravel Eloquent query that finds the avarage price of comodities

how do i write this query in Laravel eloquent query, the intention is to get the average price of a commodity when its gotten from the database and

SELECT a.* 
            FROM StockDetails a
            JOIN 
             ( SELECT x.*
                    , SUM(y.quantity) qtt
                 FROM StockDetails x 
                 JOIN StockDetails y 
                   ON y.partNumb = x.partNumb AND y.id <= x.id 
                WHERE x.partNumb = '$part_number' AND x.costCenter = '$user_center'
                GROUP 
                   BY x.id
               HAVING '$total_order' > SUM(y.quantity)-x.quantity AND '$total_order' <= SUM(y.quantity)
             ) b
            ON b.partNumb = a.partNumb 
            AND b.id >= a.id AND a.costCenter = '$user_center' AND b.costCenter = '$user_center'

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2xg2Bvt
via IFTTT