Agrupando a venda por data com a restrição MySQL only_full_group_by

[Frank K Hosaka]

PHP

$query=$mysqli->query("select date(horavenda) as vendido , sum(total) as total 
	from tbpedido where horavenda is not null 
	group by date(horavenda)
	order by date(horavenda) desc");
$groups=json_decode(json_encode($query->fetch_all(MYSQLI_ASSOC)));

Laravel

$groups=tbpedido::whereNotNull('horavenda')
	->select(DB::raw('date(horavenda) as vendido, sum(total) as total'))
	->groupBy(DB::raw('date(horavenda)'))
	->orderBy(DB::raw('date(horavenda)'),'desc')->get();

Editado Fevereiro 12 por Frank K Hosaka