Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
WIKIPEDIA
/
imalipartnersapi
/
app
/
Http
/
Controllers
:
StatistiController.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?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); } }