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; } }
function getBlockpost() { $startDate = date("Y-m-d H:i:s"); $endDate = date("Y-m-d H:i:s", strtotime('-24 hours')); $unsafeDetails = Unsafe::where('notified', '1')->where('status', '1')->where('updated_at', '>=', $endDate)->get(); //dd($unsafeDetails); for ($i = 0; $i < count($unsafeDetails); $i++) { $id = $unsafeDetails[$i]['id']; $type = $unsafeDetails[$i]['type']; $post_id = $unsafeDetails[$i]['post_id']; $user_id = $unsafeDetails[$i]['user_id']; if ($type == "comments") { $blockComment = ProjectComment::where('id', '=', $post_id)->where('user_id', $user_id)->update(array('status' => '2')); } if ($type == "updates") { $blockUpdate = ProjectUpdates::where('id', '=', $post_id)->where('user_id', $user_id)->update(array('status' => '2')); } $update = Unsafe::where('id', '=', $id)->update(array('notified' => '4')); } }