/**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     $access_token = generate_access_token();
     $email = 'a1t1-' . generate_email() . '@telegramlogin.com';
     $user = new User();
     $user->name = 'david pichsenmeister';
     $user->username = 'pichsenmeister';
     $user->email = $email;
     $user->telegram_id = 41478911;
     $user->access_token = $access_token;
     $user->save();
     $app = new App();
     $app->user_id = $user->id;
     $app->name = 'Telegram Login';
     $app->client_id = 314159265;
     $app->client_secret = generate_client_secret();
     $app->website = env('URL');
     $app->redirect_url = env('URL') . '/login';
     $app->save();
     $tg = new TelegramUser();
     $tg->telegram_id = 41478911;
     $tg->name = 'david pichsenmeister';
     $tg->username = 'pichsenmeister';
     $tg->save();
     $auth = new Auth();
     $auth->app_id = $app->id;
     $auth->telegram_user_id = $tg->id;
     $auth->email = $email;
     $auth->access_token = $access_token;
     $auth->save();
 }

 public static function uploadBeerImg_callback($request, $fileimage)
 {
     $image_unique_id = date('Ymdhis') . rand(0, 9999);
     $beer_meta = new BeerImg();
     $beer_meta->beer_id = $request['beer_id'];
     $beer_meta->description = !empty($request['img_description']) ? $request['img_description'] : null;
     $beer_name = !empty($request['img_description']) ? $request['img_description'] : null;
     $imageName = "beerhit.com_" . strtolower($beer_name) . $request['beer_id'] . $image_unique_id . '.' . $fileimage->getClientOriginalExtension();
     $path = public_path('/images/catalog/' . $imageName);
     $img = ImageManagerStatic::make($fileimage);
     // resize the image to a width of 960
     // and constrain aspect ratio (auto width)
     $img->resize(960, null, function ($constraint) {
         $constraint->aspectRatio();
         $constraint->upsize();
     });
     $img->save($path);
     //Save image information to database
     $beer_meta->img_id = $image_unique_id;
     $beer_meta->filename = $imageName;
     $beer_meta->path = '/images/catalog/' . $imageName;
     $beer_meta->user_id = \Auth::user()->id;
     $beer_meta->place_id = $request['fb_place_id'];
     $beer_meta->save();
     \UserBeerHelper::userLog(\Auth::user()->id, $request['beer_id'], 200, $request['fb_place_id'], $image_unique_id);
 }

 public function getNotReadMessagesById($id)
 {
     $count = $this->where('id_receive', \Auth::user()->id)->where('read', NULL)->where('dialog_id', $id)->count();
     if ($count) {
         return '(' . $count . ')';
     }
 }

 public static function totalMonthlyCoverage()
 {
     $visitClass = Customer::select('class')->where('mr_id', \Auth::user()->id)->get()->toArray();
     $totalVisitsCount = VisitClass::whereIn('name', $visitClass)->sum('visits_count');
     $actualVisitsCount = Report::where('mr_id', \Auth::user()->id)->where('month', date('M') . '-' . date('Y'))->count();
     return number_format($actualVisitsCount / $totalVisitsCount * 100, 2);
 }

 public function scopeClient($query, $request)
 {
     //$query->join('projects','claim.project_id','=','projects.id');
     if (!empty($request['created_at_from']) && !empty($request['created_at_to'])) {
         $dtFrom = new \DateTime($request['created_at_from']);
         $dtTo = new \DateTime($request['created_at_to']);
         $query->whereBetween('claims.created_at', [$dtFrom->format('Y-m-d 00:00:00'), $dtTo->format('Y-m-d 23:59:59')]);
     } elseif (!empty($request['created_at_from']) && empty($request['created_at_to'])) {
         $dtFrom = new \DateTime($request['created_at_from']);
         $dtTo = new \DateTime();
         $query->whereBetween('claims.created_at', [$dtFrom->format('Y-m-d 00:00:00'), $dtTo->format('Y-m-d 23:59:59')]);
     } elseif (empty($request['created_at_from']) && !empty($request['created_at_to'])) {
         $dtFrom = new \DateTime($request['created_at_to']);
         $dtTo = new \DateTime('created_at_to');
         $query->whereBetween('claims.created_at', [$dtFrom->format('Y-m-d 00:00:00'), $dtTo->format('Y-m-d 23:59:59')]);
     }
     if (!empty($request['status'])) {
         $query->where('claims.status', $request['status']);
     }
     if (!empty($request['id'])) {
         $query->where('claims.id', (int) $request['id']);
     }
     if (!empty($request['name'])) {
         $query->where('claims.name', 'like', "%" . $request['name'] . "%");
     }
     if (!empty($request['phone'])) {
         $query->where('claims.phone', 'like', "%" . $request['phone'] . "%");
     }
     $query->join('projects', function ($join) {
         $join->on('claims.project_id', '=', 'projects.id')->where('projects.client_id', '=', \Auth::user()->id);
     });
     $query->orderBy('claims.id', 'desc')->get(["claims.*"]);
 }

 public function post()
 {
     $file = array('users' => Request::all());
     // setting up rules
     $rules = array('users' => 'required', 'mimes' => 'jpeg,jpg,png', 'max' => '200px');
     //mimes:jpeg,bmp,png and for max size max:10000
     // doing the validation, passing post data, rules and the messages
     $validator = Validator::make($file, $rules);
     if ($validator->fails()) {
         // send back to the page with the input data and errors
         return redirect('settings')->withInput()->withErrors($validator);
     } else {
         // checking file is valid.
         if (Input::file('user_image')->isValid()) {
             $extension = Input::file('user_image')->getClientOriginalExtension();
             // getting image extension
             $fileName = rand(11111, 99999) . '.' . $extension;
             // renaming image
             Input::file('user_image')->move('uploads/', $fileName);
             // uploading file to given path
             $file->user_image = $fileName;
             \Auth::user()->post->save();
             // sending back with message
             \Session::flash('flash_message', 'You have successfully updated your codename!');
             return redirect('settings');
         } else {
             // sending back with error message.
             \Session::flash('error', 'uploaded file is not valid');
             return redirect('home');
         }
     }
 }

 /**
  * Saving and Database Recording Users Default Picture
  * @param UploadedFile $file Library for Uploading Files Locally or Cloud
  * @param User         $user Users Model
  */
 public function UserProfilePicture(UploadedFile $file, User $user)
 {
     $Image = $file->getClientOriginalName();
     $Imagename = 'DP_' . $Image;
     $file->move(\Auth::User()->username . '/profile_images/', $Imagename);
     $user->userData()->update(['profile_picture' => '/' . \Auth::User()->username . '/profile_images/' . $Imagename, 'picture_name' => $Imagename]);
 }

 public static function getNiveauPrice($niveau)
 {
     if (\Auth::user()->pricebills()->where('niveau', $niveau)->first()) {
         $price = \Auth::user()->pricebills()->where('niveau', $niveau)->first();
         return $price->prix;
     }
 }

 public static function customCreate(CreateConversationRequest $request)
 {
     $conv = new Conversation();
     $conv->Title = $request->Title;
     // if nothing specified in the request
     if (!$request->has('user_id')) {
         // if we are not even logged ( happen while seeding base)
         if (!\Auth::check()) {
             $conv->user_id = User::first()->id;
         } else {
             $conv->user_id = \Auth::id();
         }
     }
     // if Pending status is specified we take it, if not default value will be applied (false)
     if (!$request->has('Pending')) {
         $conv->Pending = $request->Pending;
     }
     $conv->created_at = Carbon::now();
     $conv->save();
     // When conversation is settled the Thread can be created
     $thread = new Thread();
     $thread->user_id = $conv->user_id;
     $thread->Content = $request->Content;
     $thread->conversation_id = $conv->id;
     $thread->created_at = Carbon::now();
     $thread->Pending = $conv->Pending;
     $thread->save();
     return true;
 }

 public function send(Request $request)
 {
     $accessToken = $request->input('access_token');
     try {
         $auth = \App\Auth::findByAccessToken($accessToken);
         $auth->telegram_user = $auth->telegramUser()->first();
         $app = $auth->app()->first();
         $text = 'Send on behalf of: [' . $app->client_id . '] ' . $app->name . PHP_EOL . PHP_EOL;
         $text .= 'Message: ' . PHP_EOL;
         $text .= $request->input('text') . PHP_EOL . PHP_EOL;
         $text .= 'Note: If you don\'t want to receive further updates from [' . $app->client_id . '] ' . $app->name;
         $text .= ', you can revoke access via the /revoke command';
         $params = array('chat_id' => $auth->telegram_user->telegram_id, 'text' => $text);
         $ch = curl_init();
         curl_setopt($ch, CURLOPT_URL, 'https://api.telegram.org/bot' . env('BOT_TOKEN') . '/sendMessage');
         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
         curl_setopt($ch, CURLOPT_POSTFIELDS, $params);
         $json = curl_exec($ch);
         $result = json_decode($json, true);
         if ($result['ok']) {
             return response()->json(array('ok' => true));
         } else {
             return response()->json($result);
         }
     } catch (ModelNotFoundException $e) {
         return response()->json(['error' => 'No active user found.'], 404);
     }
 }

 public function put($data)
 {
     $this->fill($data);
     $this->user_id = \Auth::user()->id;
     $this->save();
     return $this;
 }

 public function isAdmin()
 {
     $user = \Auth::user();
     $role_id = $user->roles->pluck('id');
     if (in_array(1, $role_id->toArray())) {
         return TRUE;
     }
 }

 public function userReadDiscussion()
 {
     if (\Auth::check()) {
         return $this->hasMany('App\\UserReadDiscussion')->where('user_id', '=', \Auth::user()->id);
     } else {
         abort(500, 'Need to be logged in to access this userReadDiscussion relation');
     }
 }

 public function isBingoPlayer()
 {
     if (\Auth::user()->role->role == 'bp') {
         return true;
     } else {
         return false;
     }
 }

 public function myWatchlist()
 {
     if (Auth::check() && Watchlist::where('user_id', Auth::user()->id)->where('art_id', $this->id)->exists()) {
         return true;
     } else {
         return false;
     }
 }

 public function isAdmin()
 {
     $user = \Auth::user()->toArray();
     if ($user['isAdmin'] == 1) {
         return true;
     }
     return false;
 }

 /**
  * @return boolean returns <b>true</b> if this User model is the user we logged in as.
  */
 public function isLoggedUser()
 {
     $authUser = \Auth::user();
     if (!empty($authUser) && $authUser->id == $this->id) {
         return true;
     }
     return false;
 }

 public function is($role)
 {
     if ($role == Auth::user()->role) {
         return true;
     } else {
         return false;
     }
 }

 public function isMe()
 {
     if ($this->id == \Auth::user()->id) {
         return true;
     } else {
         return false;
     }
 }

 public function isSkrbnik()
 {
     if (\Auth::user()->type == 4) {
         return true;
     } else {
         return false;
     }
 }