使用 Eloquent 实现 group_by 并在 Laravel 中拥有
我在实现 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();
相关文章