public function existed($pointable_type, $pointable_id, $issue_id) { $countMe = Point::where('pointable_type', '=', $pointable_type)->where('pointable_id', '=', $pointable_id)->where('issue_id', '=', $issue_id)->count(); if ($countMe > 0) { return true; } else { return false; } }
private function add_daily_comment_points() { $user_id = Auth::user()->id; $LastCommentPoints = Point::where('user_id', '=', $user_id)->where('description', '=', Lang::get('lang.daily_comment'))->orderBy('created_at', 'desc')->take(5)->get(); $total_daily_comments = 0; foreach ($LastCommentPoints as $CommentPoint) { if (date('Ymd') == date('Ymd', strtotime($CommentPoint->created_at))) { $total_daily_comments += 1; } } if ($total_daily_comments < 5) { $point = new Point(); $point->user_id = $user_id; $point->description = Lang::get('lang.daily_comment'); $point->points = 1; $point->save(); return true; } else { return false; } }
public function points($username) { $user = User::where('username', '=', $username)->first(); if (!Auth::guest() && Auth::user()->id == $user->id) { $is_user_profile = true; } $user_points = DB::table('points')->where('user_id', '=', $user->id)->sum('points'); $data = array('user' => $user, 'points' => Point::where('user_id', '=', $user->id)->get(), 'settings' => Setting::first(), 'is_user_profile' => $is_user_profile, 'user_points' => $user_points); return View::make('Theme::user', $data); }
public function recharge() { $v = Validator::make(Input::all(), ["code" => "required|size:22"], ["required" => "<span class='glyphicon glyphicon-exclamation-sign'></span> Please typr the code.", "size" => "<span class='glyphicon glyphicon-exclamation-sign'></span> Invalid code"]); if ($v->fails()) { return Redirect::back()->withErrors($v)->withInput(); } $find = Product::where("code", Input::get("code")); if ($find->count() > 0) { // Give the point associated with the code $point = $find->get()->first()->point; $p = new Point(); $p->user_id = Auth::user()->id; $p->point = $point; $p->product_id = $find->get()->first()->id; $p->save(); // Set user's designation $active_member = User::find(Auth::user()->id); $active_member->designation = "Active member"; $active_member->save(); // Remove the code from product. So that any user can't use the same code twice. $find->update(["code" => ""]); // If the user has 1000 points then add amount 500 $how_many_points = Point::where('user_id', Auth::user()->id)->sum('point'); if ($how_many_points >= 1000) { // Set the user's designation to Model member $model_member = User::find(Auth::user()->id); $model_member->designation = "Model member"; $model_member->save(); // Check the user's referal is an admin or not $my_referal = User::find(Auth::user()->referal_id); if ($my_referal->type == 'admin') { $distributed_amount = 600; } else { $distributed_amount = 300; } Amount::create(['user_id' => Auth::user()->id, 'amount' => 500, 'status' => 1]); Amount::create(['user_id' => Auth::user()->referal_id, 'amount' => $distributed_amount]); Point::where('user_id', Auth::user()->id)->delete(); } return Redirect::back()->with("event", "<p class='alert alert-success'><span class='glyphicon glyphicon-ok'></span> Congratulation! You got " . $point . " points.</p>"); } return Redirect::back()->with("event", "<p class='alert alert-danger'><span class='glyphicon glyphicon-exclamation-sign'></span> Invalid code.</p>"); }
public function points($username) { $user = User::where('username', '=', $username)->first(); $data = array('user' => $user, 'points' => Point::where('user_id', '=', $user->id)->get()); return View::make('user.points', $data); }
private function getHighest($event) { $highest = Point::where('pointable_type', '=', 'Activity')->where('pointable_id', '=', $event)->max('point'); return $highest; }