<?php

namespace App\Http\Controllers\Admin;

use App\Models\DeviceName;
use App\Models\InnerDevice;
use App\Models\Notification;
use App\Models\Order;
use App\Models\OrderDevice;
use App\Models\Project;
use App\Models\ProjectRole;
use App\Models\ProjectUser;
use App\Models\User;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;


class TestController extends Controller
{
    public function index(Request $request)
    {
        dd(Order::where('type', 1)->groupBy('project_id')->selectRaw('sum(money) as sum, project_id')->pluck('sum', 'project_id'));
//    	return view('admin.test.index');
    }
}