Level 46
The select method on an Eloquent model accepts a list of fields not SQL statements.
You'd be better off using the query builder for this.
Jul 25, 2018
3
Level 1
How to write general query in laravel format
Hi, How to write following sql query in laravel
select bins.organization, sum(products.price) as price, sum(products.vat) as vat from products inner join bins on products.binid = bins.binid group by products.binid
When i write this as
$product = Product::select('bins.organization', 'sum(products.price) AS price', 'sum(products.vat) AS vat')->join('bins','products.binid', '=', 'bins.binid')->groupBy('products.binid')->get();
Error comes as like: Column not found: 1054 Unknown column 'sum(products.price)' in 'field list'
Level 30
for aggregators like sum you can use sum method or DB::raw statements
Level 1
same problem. it takes whole sum(products.price) as column name. how solve??
Please or to participate in this conversation.