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');
}
