<?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);
    }
}