Laravel 按日期分组

Laravel Group By Date(Laravel 按日期分组)

本文介绍了Laravel 按日期分组的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试对以下 sql 进行 elqouent 查询,

I am trying to make an elqouent query for a following sql,

select sum(w.total_item_count) as Day_count, w.created_at as created_at from `sales_flat_orders` as `w` group by DATE(`w`.`created_at`) order by `w`.`created_at` asc

我已经试过了

$orderbydate = DB::table('sales_flat_orders as w')
                ->select(array(DB::Raw('sum(w.total_item_count) as Day_count'),DB::Raw('DATE(w.created_at) as created_at')))
                ->groupBy('w.created_at')
                ->orderBy('w.created_at')
                ->get();

我在 sql 查询中得到了正确的输出,但在 eloquent 查询中却没有得到正确的输出,请帮忙,谢谢.

I am getting correct output in sql query but not in eloquent query, Please help, Thanks.

推荐答案

伙计们,我已经得到了答案,感谢您阅读我的问题.

So guys, i have got the answer for this, Thank you for reading my question.

$orderbydate = DB::table('sales_flat_orders as w')
                ->select(array(DB::Raw('sum(w.total_item_count) as Day_count'),DB::Raw('DATE(w.created_at) day')))
                ->groupBy('day')
                ->orderBy('w.created_at')
                ->get();

我的查询中的原始查询对于 created_at 字段是错误的.现在它很好.希望你也能从中得到一些意见.

The Raw query in my query was wrong for the created_at field. Now its good. Hope you will also get some input from this.

这篇关于Laravel 按日期分组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:Laravel 按日期分组

基础教程推荐