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; } }
public function getProjectBacked($id = Null) { $fundedProjectLists = array(); if ($id == Null) { \App::abort(404, 'Invalid User Id'); } else { $user_id = $id; } $user = \App\User::where('id', $user_id)->first(); $lists = ProjectFund::where('U_ID', $user_id)->whereIn('status', ['Pledged', 'Funded'])->orderBy('created_at', 'desc')->get(); if (count($lists) > 0) { foreach ($lists as $val) { $fundedProjectLists[] = $val->P_ID; } } $result = array_unique($fundedProjectLists); $myFundedProjectLists = Project::where('active', '1')->whereIn('id', $result)->orderBy('created_at', 'desc')->get(); $getResults = $this->project_repo->prepareListObj($myFundedProjectLists); return view('user.project-backed', ['_menus' => $this->menuItems, 'login_url' => $this->login_url, 'user' => $user, 'dashBoardDetailsByAuthUser' => $this->userrepo->generalOverViewByAuthUser($user_id), 'my_funded_projects' => $getResults]); }
public function getUimodal($modalFor, $user_id) { if (isset($modalFor) && $modalFor == 'project-count') { $projectLists = \App\Models\Project::where('user_id', $user_id)->get(); echo view('admin.user.uimodal', ['modalFor' => $modalFor, 'user_id' => $user_id, 'projectLists' => $projectLists]); } elseif (isset($modalFor) && $modalFor == 'user-login-count') { $logHistory = \App\Models\LogActivity::where('user_id', $user_id)->where('action', 'user-login')->orderBy('timestamp')->get(); echo view('admin.user.uimodal', ['modalFor' => $modalFor, 'user_id' => $user_id, 'logHistory' => $logHistory]); } elseif (isset($modalFor) && $modalFor == 'project_funded_count') { $fundedDetails = \App\Models\ProjectFund::where('U_ID', $user_id)->where('status', 'Pledged')->orderBy('created_at')->get(); echo view('admin.user.uimodal', ['modalFor' => $modalFor, 'user_id' => $user_id, 'fundedDetails' => $fundedDetails]); } }
public function getWidget($id) { $updateRank = $this->project_repo->updateprojectrank($id); $featuredProjects = Project::where('id', $id)->get(); $total_backers = ProjectFund::where('P_ID', $id)->count(); $total_fund = ProjectFund::where('P_ID', $id)->sum('paid_amount'); $funded = number_format($total_fund / $featuredProjects[0]['funding_goal'] * 100) . "%"; return view('project.embed', ['_featuredProducts' => $featuredProjects, '_totalBackers' => $total_backers, '_totalFunds' => $total_fund, '_funded' => $funded]); }
public function getExportbackedproject(Request $request) { //dd("VV"); $excelnm = "project_backed_" . date("d-m-Y"); Excel::create($excelnm, function ($excel) { $excel->sheet('Project', function ($sheet) { $fundedProjectLists = array(); $authId = Auth::user()->id; $lists = ProjectFund::where('U_ID', $authId)->whereIn('status', ['Pledged', 'Funded'])->orderBy('created_at', 'desc')->get(); if (count($lists) > 0) { foreach ($lists as $val) { $fundedProjectLists[] = $val->P_ID; } } $result = array_unique($fundedProjectLists); $myFundedProjectLists = Project::where('active', '1')->whereIn('id', $result)->orderBy('created_at', 'desc')->get(); $getResults = $this->project_repo->prepareListArr($myFundedProjectLists); //echo "<pre>"; //print_r($getResults); //echo "</pre>"; //dd("B"); $dataArr = array(); if (is_array($getResults) && count($getResults) > 0) { $counter = 0; foreach ($getResults as $kyy => $dataval) { $dataArr[$counter]['Sl'] = $counter + 1; $dataArr[$counter]['Name'] = $dataval['name']; $dataArr[$counter]['Goal Amount'] = $dataval['funding_goal']; $dataArr[$counter]['Funded Amount'] = $dataval['_total_pledge_amount']; $dataArr[$counter]['Paid Amount'] = $dataval['_total_pledge_amount_of_auth_user']; $dataArr[$counter]['Duration(Days)'] = $dataval['project_duration']; $dataArr[$counter]['End date'] = gmdate("Y-m-d", $dataval['project_end_date']); $counter++; } } /* setting column names for data - you can of course set it manually */ $sheet->appendRow(array_keys($dataArr[0])); /* column names */ /* getting last row number (the one we already filled and setting it to bold */ $sheet->row($sheet->getHighestRow(), function ($row) { $row->setFontWeight('bold'); }); /* putting users data as next rows */ foreach ($dataArr as $user) { $sheet->appendRow($user); } }); })->export('xls'); }