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 getProjectFollowers()
{
$project_views = \App\Models\ProjectFollowers::all();
return view('admin.activities.project-followers', ['project_views' => $project_views]);
}
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]);
}
/**
* Gets the activities associated with this project.
* @return array
*/
public function getFollowers()
{
return $this->hasOne(ProjectFollowers::className(), ['projectID' => 'projectID']);
}
/**
* Creates a new Project model.
* If creation is successful, the browser will be redirected to the 'index' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Project();
$uploadModel = new UploadForm();
if ($this->handleForm($model, $uploadModel)) {
$followers = new ProjectFollowers();
$followers->projectID = $model->projectID;
$followers->save();
Yii::info('Project created.', __METHOD__);
return $this->redirect(['index', 'id' => $model->projectID]);
} else {
return $this->render('create', ['model' => $model, 'upload' => $uploadModel]);
}
}
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;
}
}
