Level 53
@dixitchopra I don't think you want Eloquent for things like reports. Apart from that, it is pretty basic query, so what do you have problem with here?
Apr 6, 2015
3
Level 3
Find monthly Sale in Eloquent
How can I write the following in Eloquent or is there any other way to find monthly sales group by Date? Can I also use limit here like 20 records in results?
SELECT DATE(created_at) AS date, SUM(final_amount) AS total_sales
FROM bills
GROUP BY date
Level 3
I thought alias and group by can be written using Eloquent and without DB:Raw. I have written the code now with DB:Raw.
Level 53
@dixitchopra You're talking about Query\Builder. Eloquent is the ORM part, that uses query builder.
Anyway, you can alias select('column as alias') and group by without raw, but sql functions cannot be called without it:
DB::table('bills')->selectRaw('date(created_at) as date, sum(final_amount) as total_sales')
->groupBy('date')
->get();
1 like
Please or to participate in this conversation.