public function getCommunesStatistics(Request $request)
{
$commune = $request->get('commune') ? $request->get('commune') : 1;
$products = ShoppingInterest::select('product_id', 'products.name', \DB::raw('SUM(amount) as total'))->join('users', 'users.id', '=', 'user_id')->join('products', 'products.id', '=', 'product_id')->whereUnit('kg')->whereCommune($commune)->orderBy('product_id', 'asc')->groupBy('product_id')->get();
$stat = ['content' => [['label' => 'Compra de Producto en KG', 'data' => []]], 'names' => []];
$count = 0;
foreach ($products as $product) {
array_push($stat['content'][0]['data'], [$count, $product->total]);
array_push($stat['names'], [$count + 0.5, $product->name . ' (' . $product->total . ') ']);
$count += 1.5;
}
return $stat;
}
