使用 Eloquent 实现 group_by 并在 Laravel 中拥有 [英] Implementing group_by and having in Laravel using Eloquent

问题描述

我在实现 group_by 和在 Laravel 中使用 Eloquent 进行查询时遇到问题.

I am having trouble implementing the group_by and having queries using Eloquent in Laravel.

场景如下:

orders
 - id
 - qty

deliveries
 - id
 - qty
 - order_id

我想使用连接来显示未完成交货的订单以及相应的余额:

I want to use a join to display the orders with incomplete deliveries as well as the corresponging balance:

Order::left_join('deliveries', 'orders.id', '=', 'deliveries.order_id')
     ->select(array('orders.*'), DB::raw('orders.qty - IFNULL(sum(deliveries.qty),0) AS balance')))
     ->group_by('order_id')
     ->having('balance', '>', 0)
     ->get();

'balance' 值在没有 'have' 子句的情况下也能正常工作.然而，在添加 'have' 子句时，结果表不显示任何行.有人有什么想法吗?

The 'balance' value works fine without the 'having' clause. On adding the 'having' clause however, the resulting table doesn't display any rows. Does anyone have any ideas?

提前致谢！

推荐答案

最终切换到 Laravel 4 并执行似乎有效的 ff.

Ended up switching to Laravel 4 and doing the ff which seemed to work.

Order::leftJoin('deliveries', 'orders.id', '=', 'deliveries.order_id')
 ->select(array('orders.*'), DB::raw('orders.qty - IFNULL(sum(deliveries.qty),0) AS balance')))
 ->groupBy('order_id')
 ->havingRaw('balance > 0')
 ->get();

这篇关于使用 Eloquent 实现 group_by 并在 Laravel 中拥有的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！