public function getDashboard() { $sessval = ''; Session::put('step', $sessval); Session::put('editfstep', $sessval); Session::set('editfs_id', $sessval); Session::set('last_insert_id', $sessval); $authId = Auth::user()->id; $activityProjects = array(); $myCreatedProjects = Project::where('user_id', $authId)->where('active', '1')->where('live', '1')->orderBy('created_at', 'desc')->get(); foreach ($myCreatedProjects as $val) { $activityProjects[] = $val->id; } $followingProjectLists = array(); $lists = \App\Models\ProjectFollowers::where('user_id', $authId)->orderBy('created_at', 'desc')->get(); if (count($lists) > 0) { foreach ($lists as $val) { $activityProjects[] = $val->project_id; } } $lists = ProjectFund::where('U_ID', $authId)->whereIn('status', ['Pledged', 'Funded'])->orderBy('created_at', 'desc')->get(); if (count($lists) > 0) { foreach ($lists as $val) { $activityProjects[] = $val->P_ID; } } $activityUniqueProjectLists = array_unique($activityProjects); $activityLogs = \App\Models\LogActivity::whereIn('project_id', $activityUniqueProjectLists)->orderBy('created_at', 'desc')->get(); //$activityLogs = \App\Models\LogActivity::where('project_id' , '!=' , 0 )->orderBy('created_at', 'desc')->get(); return view('home.dashboard', ['_menus' => $this->menuItems, '_errorNotification' => $this->errorNotification, 'login_url' => $this->login_url, 'dashBoardDetailsByAuthUser' => $this->userrepo->generalOverViewByAuthUser($authId), 'activityLogs' => $activityLogs]); }
public function getFollowingProjects($id = Null) { if ($id == Null) { \App::abort(404, 'Invalid User Id'); } else { $user_id = $id; } $followingProjectLists = array(); $lists = \App\Models\ProjectFollowers::where('user_id', $user_id)->orderBy('created_at', 'desc')->get(); if (count($lists) > 0) { foreach ($lists as $val) { $followingProjectLists[] = $val->project_id; } } $result = array_unique($followingProjectLists); $myFollowingProjectLists = Project::where('active', '1')->whereIn('id', $result)->orderBy('created_at', 'desc')->get(); return view('user.following-projects', ['_menus' => $this->menuItems, 'login_url' => $this->login_url, 'user' => \App\User::where('id', $user_id)->first(), 'dashBoardDetailsByAuthUser' => $this->userrepo->generalOverViewByAuthUser($user_id), 'my_following_projects' => $this->project_repo->prepareListObj($myFollowingProjectLists)]); }
public function sortByCriteria($criteria = null, $authId = Null) { switch ($criteria) { case 'active': $users = $this->model->where('type', 'general')->where('status', '1')->count(); return $users; break; case 'inactive': $users = $this->model->where('type', 'general')->where('status', '0')->count(); return $users; break; case 'facebook': $users = $this->model->where('type', 'general')->where('register_type', 'facebook')->count(); return $users; break; case 'googleplus': $users = $this->model->where('type', 'general')->where('register_type', 'googleplus')->count(); return $users; break; case 'twitter': $users = $this->model->where('type', 'general')->where('register_type', 'twitter')->count(); return $users; break; case 'all': $users = $this->model->where('type', 'general')->count(); return $users; break; case 'my_posted_projects': $myPostedProjectLists = \App\Models\Project::where('active', '1')->where('user_id', $authId)->count(); return $myPostedProjectLists; break; case 'my_posted_projects': $myPostedProjectLists = \App\Models\ProjectUpdates::where('active', '1')->where('user_id', $authId)->count(); return $myPostedProjectLists; break; case 'my_backed_projects': $MyFundedProjectLists = array(); $lists = \App\Models\ProjectFund::where('U_ID', $authId)->whereIn('status', ['Pledged', 'Funded'])->orderBy('created_at', 'desc')->get(); if (count($lists) > 0) { foreach ($lists as $val) { $MyFundedProjectLists[] = $val->P_ID; } } $result = array_unique($MyFundedProjectLists); return count($result); break; case 'my_likes_projects': $myLikeProjects = \App\Models\ProjectFollowers::where('user_id', $authId)->count(); return $myLikeProjects; break; case 'my_following_projects': $myFllowingProjects = \App\Models\ProjectFollowers::where('user_id', $authId)->count(); return $myFllowingProjects; break; } }