/**
  * Update stats in DB (like count & retweet count)
  *
  * @return void
  */
 public function updateTwitterStats()
 {
     $tweets = $this->twitterContent->fetchTwitterStats();
     foreach ($tweets as $key => $tweet) {
         if ($this->publishment->where('tweet_id', $tweet['id_str'])->exists()) {
             $publishment = $this->publishment->where('tweet_id', $tweet['id_str'])->first();
             $publishment->twitter_likes = $tweet['favorite_count'];
             $publishment->twitter_retweets = $tweet['retweet_count'];
             $publishment->save();
         }
     }
     $this->log->updateLog('publishments');
 }
 /**
  * Fetch comments on post form Facebook
  * @param  \Datetime $newest
  * @return return collection
  */
 private function fetchComments($newest)
 {
     $messages = $this->getPosts();
     foreach ($messages as $key => $message) {
         if ($message->fb_post_id != 0) {
             $comments = $this->facebookContent->fetchComments($newest, $message);
             if (!empty($comments->data)) {
                 foreach ($comments->data as $key => $comment) {
                     if ($comment->from->id != config('crm-launcher.facebook_credentials.facebook_page_id') && (!$newest || new Datetime(changeFbDateFormat($comment->created_time)) > new Datetime($newest))) {
                         if ($this->contact->FindByFbId($comment->from->id)->exists()) {
                             $contact = $this->contact->where('facebook_id', $comment->from->id)->first();
                         } else {
                             $contact = $this->contact->createContact('facebook', $comment);
                         }
                         if ($this->publishment->where('fb_post_id', $message->fb_post_id)->exists()) {
                             $id = $this->publishment->where('fb_post_id', $message->fb_post_id)->first()->id;
                             $reaction = $this->reaction->insertReaction('facebook', $comment, $id);
                             $this->media->handleMedia($reaction->id, $comment, 'facebook_reactionInner');
                         } else {
                             $msg = new Message();
                             $msg->fb_reply_id = $message->fb_post_id;
                             $msg->post_date = changeFbDateFormat($comment->created_time);
                             $msg->contact_id = $contact->id;
                             $msg->fb_post_id = $comment->id;
                             $msg->case_id = $message->case_id;
                             $msg->message = $comment->message;
                             $msg->save();
                             $this->media->handleMedia($msg->id, $comment, 'facebook_comment');
                             $this->updateCase($message->case_id, 'facebook', $comment->id);
                         }
                     }
                 }
             }
         }
     }
 }