Hola tengo la siguiente consulta en SQL quisiera llevarla a Laravel pero no tengo ni la menor idea al respecto, mi consulta en SQL es la siguiente:
SELECT SUBQUERY.*,SUM(SUBQUERY.TOTAL) AS IMPORTE,(SUBQUERY.amount+SUBQUERY.tip) AS IMPORT_PROPINA
FROM (
SELECT notas.*, posee.qty, productos.shopping_price,(productos.shopping_price * posee.qty) AS TOTAL
FROM posee
JOIN productos ON productos.id = posee.id_producto
JOIN notas ON notas.id = posee.id_nota
)
AS SUBQUERY
GROUP BY SUBQUERY.id
>Solution :
$result = DB::select("SELECT SUBQUERY.*,SUM(SUBQUERY.TOTAL) AS IMPORTE,(SUBQUERY.amount+SUBQUERY.tip) AS IMPORT_PROPINA FROM ( SELECT notas.*, posee.qty, productos.shopping_price, productos.shopping_price * posee.qty) AS TOTAL FROM posee
JOIN productos ON productos.id = posee.id_producto JOIN notas ON notas.id = posee.id_nota)
AS SUBQUERY
GROUP BY")
You only need to wrap your queries with DB::select().