<?php
namespace App\Http\Controllers;
use App\Bank\Payment;
use Illuminate\Http\Request;
use DB;
class StatistiController extends Controller
{
public function getWeekReport() {
// $data = Payment::query()
// ->groupBy('created_at')
// ->get()
// ->sortBy(function ($article) {
// # assuming $article->day return "Monday", "Tuesday" and etc
// return constant('\Carbon\Carbon::' . strtoupper($article->day));
// })->toBase();
// $data = Payment::query()
//// ->groupByRaw('created_at')
// ->get();
// $periodDate = date_create($request->open_period);
$data = DB::table('payments')
->select(DB::raw('sum(amount) as totalAmount'))
->groupBy('store_id')
->get();
return response()->json($data);
}
}