lundi 17 décembre 2018

Laravel 5.6: is it possible to generate following query by Query Builder or Eloquent?

I have following raw query, is it possible to create this using Laravel Query Builder or Eloquent?

SELECT 
SUM(records.per_hub)+SUM(records.additionl_qty) AS qty,
records.cost_price,
(records.cost_price)*(SUM(records.per_hub)+SUM(records.additionl_qty)) AS 
total
FROM
(SELECT 
COUNT(*) AS per_hub,
CEIL(COUNT(*) * 50 / 100) AS additionl_qty,
m.cost_price
FROM
orders o 
LEFT JOIN meals m
ON m.id = o.meal_id
WHERE o.shift_id = 1 
AND o.meal_id = 2 
AND o.city_id = 283 
AND o.restaurant_id = 5 
GROUP BY hub_id) records;



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire