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'));
}
}
public function postPdelete($id)
{
$project_update = ProjectUpdates::find($id);
if ($project_update->forceDelete()) {
echo $id;
}
}
