/** * @throws \Exception * @return CommandResponse */ public function execute() { $typeId = $this->_resourceType . '_id'; $existing = Favourite::where($typeId, '=', $this->_resourceId)->whereUserId(Auth::user()->id)->first(); $isFavourited = false; if ($existing) { $existing->delete(); } else { $fav = new Favourite(); $fav->{$typeId} = $this->_resourceId; $fav->user_id = Auth::user()->id; $fav->created_at = time(); $fav->save(); $isFavourited = true; } $resourceUser = ResourceUser::get(Auth::user()->id, $this->_resourceType, $this->_resourceId); $resourceUser->is_favourited = $isFavourited; $resourceUser->save(); $resourceTable = $this->_resourceType . 's'; // We do this to prevent a race condition. Sure I could simply increment the count columns and re-save back to the db // but that would require an additional SELECT and the operation would be non-atomic. If two log items are created // for the same resource at the same time, the cached values will still be correct with this method. DB::table($resourceTable)->whereId($this->_resourceId)->update(['favourite_count' => DB::raw('( SELECT COUNT(id) FROM favourites WHERE ' . $typeId . ' = ' . $this->_resourceId . ')')]); return CommandResponse::succeed(['is_favourited' => $isFavourited]); }
public static function logItem($resourceType, $resourceId, $logType, $formatId = null) { $resourceIdColumn = $resourceType . '_id'; $logItem = new ResourceLogItem(); $logItem->{$resourceIdColumn} = $resourceId; $logItem->created_at = Carbon::now(); $logItem->log_type = $logType; $logItem->track_format_id = $formatId; $logItem->ip_address = Request::getClientIp(); if (Auth::check()) { $logItem->user_id = Auth::user()->id; } $logItem->save(); $resourceTable = $resourceType . 's'; $countColumn = ''; if ($logType == self::VIEW) { $countColumn = 'view_count'; } else { if ($logType == self::DOWNLOAD) { $countColumn = 'download_count'; } else { if ($logType == self::PLAY) { $countColumn = 'play_count'; } } } // We do this to prevent a race condition. Sure I could simply increment the count columns and re-save back to the db // but that would require an additional SELECT and the operation would be non-atomic. If two log items are created // for the same resource at the same time, the cached values will still be correct with this method. DB::table($resourceTable)->whereId($resourceId)->update([$countColumn => DB::raw('(SELECT COUNT(id) FROM resource_log_items WHERE ' . $resourceIdColumn . ' = ' . $resourceId . ' AND log_type = ' . $logType . ')')]); if (Auth::check()) { $resourceUserId = ResourceUser::getId(Auth::user()->id, $resourceType, $resourceId); DB::table('resource_users')->whereId($resourceUserId)->update([$countColumn => DB::raw('(SELECT COUNT(id) FROM resource_log_items WHERE user_id = ' . Auth::user()->id . ' AND ' . $resourceIdColumn . ' = ' . $resourceId . ' AND log_type = ' . $logType . ')')]); } }
/** * @throws \Exception * @return CommandResponse */ public function execute() { $typeId = $this->_resourceType . '_id'; $existing = Follower::where($typeId, '=', $this->_resourceId)->whereUserId(Auth::user()->id)->first(); $isFollowed = false; if ($existing) { $existing->delete(); } else { $follow = new Follower(); $follow->{$typeId} = $this->_resourceId; $follow->user_id = Auth::user()->id; $follow->created_at = time(); $follow->save(); $isFollowed = true; } $resourceUser = ResourceUser::get(Auth::user()->id, $this->_resourceType, $this->_resourceId); $resourceUser->is_followed = $isFollowed; $resourceUser->save(); return CommandResponse::succeed(['is_followed' => $isFollowed]); }
/** * Execute the console command. * * @return mixed */ public function handle() { // Get list of affected users $usernames = DB::table('users')->select(['username', DB::raw('COUNT(*) as count')])->whereNull('disabled_at')->whereNotNull('username')->groupBy(DB::raw('LOWER(username)'))->having('count', '>=', 2)->lists('username'); foreach ($usernames as $username) { // Find the relevant accounts // ========================== /** @var Collection $accounts */ $accounts = User::where('username', $username)->orderBy('created_at', 'ASC')->get(); $firstAccount = $accounts[0]; $accounts->forget(0); $accountIds = $accounts->pluck('id'); // Reassign content // ================ // This is done with the less-efficient-than-raw-SQL Eloquent // methods to generate appropriate revision logs. $this->info('Merging duplicates for: ' . $firstAccount->username); DB::transaction(function () use($accounts, $accountIds, $firstAccount) { foreach (Album::whereIn('user_id', $accountIds)->get() as $album) { $album->user_id = $firstAccount->id; $album->save(); } foreach (Comment::whereIn('user_id', $accountIds)->get() as $comment) { $comment->user_id = $firstAccount->id; $comment->save(); } foreach (Favourite::whereIn('user_id', $accountIds)->get() as $favourite) { $favourite->user_id = $firstAccount->id; $favourite->save(); } foreach (Follower::whereIn('artist_id', $accountIds)->get() as $follow) { $follow->artist_id = $firstAccount->id; $follow->save(); } foreach (Image::whereIn('uploaded_by', $accountIds)->get() as $image) { $image->uploaded_by = $firstAccount->id; $image->save(); } foreach (Image::whereIn('uploaded_by', $accountIds)->get() as $image) { $image->uploaded_by = $firstAccount->id; $image->save(); } DB::table('oauth2_tokens')->whereIn('user_id', $accountIds)->update(['user_id' => $firstAccount->id]); foreach (PinnedPlaylist::whereIn('user_id', $accountIds)->get() as $playlist) { $playlist->user_id = $firstAccount->id; $playlist->save(); } foreach (Playlist::whereIn('user_id', $accountIds)->get() as $playlist) { $playlist->user_id = $firstAccount->id; $playlist->save(); } foreach (ResourceLogItem::whereIn('user_id', $accountIds)->get() as $item) { $item->user_id = $firstAccount->id; $item->save(); } foreach (ResourceUser::whereIn('user_id', $accountIds)->get() as $item) { $item->user_id = $firstAccount->id; $item->save(); } foreach (Track::whereIn('user_id', $accountIds)->get() as $track) { $track->user_id = $firstAccount->id; $track->save(); } foreach ($accounts as $account) { $account->disabled_at = Carbon::now(); $account->save(); } }); } }