/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $mynodes = \App\Task::where('user_id', \Auth::user()->id)->count(); $myonlinenodes = \App\Node::join('tasks', 'tasks.node_id', '=', 'nodes.id')->where('tasks.user_id', \Auth::user()->id)->join('nodestats', 'nodestats.node_id', '=', 'nodes.id')->where('nodestats.isonline', 0)->count(); $procent = $mynodes > 0 ? $myonlinenodes / $mynodes * 100 : 0; $myclients = \App\Nodestat::join('tasks', 'tasks.node_id', '=', 'nodestats.id')->where('tasks.user_id', \Auth::user()->id)->where('clientcount', '>', 0)->get(); $myclients = $myclients->sum(function ($node) { return $node->clientcount; }); return view('home/index')->with('mynodes', $mynodes)->with('onlineprocent', $procent)->with('myclients', $myclients); }