示例#1
0
 public function index($userId = null)
 {
     $auth = auth();
     if (!$userId) {
         $userId = $auth->id();
         $isAuthUser = true;
     } else {
         $isAuthUser = $userId == $auth->id();
     }
     if ($isAuthUser) {
         $user = $auth->user();
     } else {
         $user = User::findOrFail($userId);
     }
     $count['create'] = Project::where('user_id', $userId)->count();
     $count['join'] = Project::join('project_members', function ($join) use($userId) {
         $join->on('projects.id', '=', 'project_members.project_id')->where('project_members.user_id', '=', $userId);
     })->where('projects.user_id', '<>', $userId)->count();
     $count['comment'] = 0;
     $count['collect'] = ProjectFavorite::where('user_id', $userId)->count();
     $showList = 'create';
     foreach ($count as $key => $value) {
         if ($value > 0) {
             $showList = $key;
             break;
         }
     }
     return view('user.home.index', ['userData' => $user, 'isAuthUser' => $isAuthUser, 'projectCount' => $count, 'showList' => $showList]);
 }
示例#2
0
 protected function getUserProjectCount($userId)
 {
     $count = [];
     $count['create'] = Project::where('user_id', $userId)->count();
     $count['join'] = Project::join('project_members', function ($join) use($userId) {
         $join->on('projects.id', '=', 'project_members.project_id')->where('project_members.user_id', '=', $userId);
     })->where('projects.user_id', '<>', $userId)->count();
     $count['comment'] = 0;
     $count['collect'] = 0;
     return $count;
 }
示例#3
0
 protected function getCollect($startId, $userId)
 {
     $this->startIdKey = 'favorite_id';
     $startId = intval($startId);
     $builder = Project::join('project_favorites', function ($join) use($startId, $userId) {
         $join->on('projects.id', '=', 'project_favorites.project_id')->where('project_favorites.user_id', '=', $userId);
         if ($startId > 0) {
             $join->where('id', '<', $startId);
         }
     })->where('projects.user_id', '<>', $userId);
     return $builder->orderBy('project_favorites.id', 'desc')->take($this->listTake)->get(['projects.*', 'project_favorites.id as favorite_id']);
 }