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