public function getView() { $smsBalances = SmsBalance::all(); if ($smsBalances->count() == 0) { App::abort(404, 'SMS not found for site'); } if ($smsBalances->count() > 1) { App::abort(500, 'invalid state'); } $smsBalance = $smsBalances->first(); $totalBalance = $smsBalance->balance; $items = SmsTransactionLog::orderBy('created_at', 'DESC')->paginate(100); $pendingItems = NotificationRequest::with(['toUser', 'fromUser'])->where('sent', false)->paginate(100); $lastTransactionLog = SmsTransactionLog::where('delta', '>', 0)->orderBy('created_at', 'DESC')->first(); $last_reload_time = null; $last_reload_amount = null; if ($lastTransactionLog) { $last_reload_time = $lastTransactionLog->created_at; $last_reload_amount = $lastTransactionLog->delta; } return view('sms-manager::view-sms')->with('total_balance', $totalBalance)->with('list', $items)->with('last_reload_time', $last_reload_time)->with('last_reload_amount', $last_reload_amount)->with('pendingItems', $pendingItems); }