public function retrieve() { $twitterPosts = SocialPost::join('user_social_post', 'social_post.id', '=', 'user_social_post.social_post_id')->where('user_social_post.user_id', '=', $this->userId)->where('social_post.type', '=', 'twitter')->select('social_post.*')->get(); $maxId = 0; foreach ($twitterPosts as $post) { $postJSON = json_decode($post->post); $maxId = $postJSON->id > $maxId ? $postJSON->id : $maxId; } return $maxId; }
private function checkPostInDB($postId, $userId) { $instagramPostsFromUser = SocialPost::join('user_social_post', 'social_post.id', '=', 'user_social_post.social_post_id')->where('user_social_post.user_id', '=', $userId)->where('social_post.type', '=', 'instagram')->get(); foreach ($instagramPostsFromUser as $instagramPost) { $post = json_decode($instagramPost->post); if ($post->id === $postId) { return true; } } return false; }
public function assign() { DB::transaction(function () { $postCreatedTimestamp = strtotime($this->post['created_time']); $postCreatedTime = Carbon::createFromTimestamp($postCreatedTimestamp); //Save the post $socialPost = new SocialPost(); $socialPost->type = 'facebook'; $socialPost->post = json_encode($this->post); $socialPost->created_at = $postCreatedTime; $socialPost->save(); //Assign social post to the user $userSocialPost = new UserSocialPost(); $userSocialPost->user_id = $this->userId; $userSocialPost->social_post_id = $socialPost->id; $userSocialPost->created_at = $postCreatedTime; $userSocialPost->save(); }); return true; }
public function retrieve() { return 0; $instagramPosts = SocialPost::join('user_social_post', 'user_social_post.social_post_id', '=', 'social_post.id')->where('social_post.type', '=', 'instagram')->where('user_social_post.user_id', '=', $this->userId)->get(); }