PHP Point::where方法代码示例

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