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