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