PHP Group::where方法代碼示例

 public static function users_from_group($group_name)
 {
     $groups = array_map(function ($group) {
         return $group->id;
     }, Group::where('name', 'LIKE', '%' . $group_name . '%')->get());
     return static::with('group')->where_in('group_id', $groups)->order_by('username', 'asc')->get();
 }

 public function postVerify()
 {
     $this->beforeFilter('admin');
     $request = Input::get('request');
     $status = Input::get('status');
     if (!Group::isValidStatus($status)) {
         throw new \Exception("Invalid value for verify request");
     }
     $group = Group::where('id', '=', $request['id'])->first();
     if (!$group) {
         throw new \Exception("Invalid Group");
     }
     $group->status = $status;
     DB::transaction(function () use($group) {
         $group->save();
         switch ($group->status) {
             case Group::STATUS_ACTIVE:
                 $group->createRbacRules();
                 break;
             case Group::STATUS_PENDING:
                 $group->destroyRbacRules();
                 break;
         }
     });
     return Response::json($group);
 }

 public function getIndex()
 {
     Allow::permission($this->module['group'], 'users');
     ## Фильтр юзеров по группе
     $group = false;
     $group_id = Input::get('group_id');
     $group_name = Input::get('group');
     $users = new User();
     ## Обрабатываем условия фильтра
     if ($group_id != '' && !is_null($group = Group::where('id', $group_id)->first())) {
         $users = $users->where('group_id', $group->id);
     } elseif ($group_name != '' && !is_null($group = Group::where('name', $group_name)->first())) {
         $users = $users->where('group_id', $group->id);
     }
     #else
     #    $users = User::all();
     if (!Allow::superuser()) {
         $users = $users->where('group_id', '!=', 1);
     }
     $users = $users->get();
     #Helper::tad($users);
     if (@(!is_object($group))) {
         $group = Group::firstOrNew(array('id' => 0));
     }
     $groups = Group::all();
     $groups_ids = array();
     foreach ($groups as $grp) {
         $groups_ids[] = $grp->id;
     }
     return View::make($this->module['tpl'] . 'index', compact('group', 'users', 'groups', 'groups_ids'));
 }

 public function createFile()
 {
     $dbFile = new DBFile();
     $dbFile->name = Input::get('filename');
     $dbFile->path = "";
     $dbFile->uploader = Auth::user()->id;
     $dbFile->size = "Unknown";
     $dbFile->content = "";
     $dbFile->filetype = Input::get('filetype');
     $uploaded = $dbFile->save();
     $allowEditing = Input::get('allowediting');
     $post = new Post();
     $grp = Group::where('uid', '=', Input::get('uid'))->first();
     $filelist = unserialize($grp->files);
     array_push($filelist, $dbFile->id);
     $grp->files = serialize($filelist);
     $grp->save();
     $post->parent = $grp->id;
     $post->title = Auth::user()->firstname . ' ' . Auth::user()->lastname . ' has created a new file.';
     if ($allowEditing) {
         $post->content = 'A new file named \'' . $dbFile->name . '\' has been created. Click <a href="' . URL::to('g/' . $grp->uid . '/edit/' . $dbFile->id) . '">here</a> to edit it.';
     } else {
         $post->content = 'A new file named \'' . $dbFile->name . '\' has been created. Click <a href="' . URL::to('g/' . $grp->uid . '/view/' . $dbFile->id) . '">here</a> to view it.';
     }
     $post->creator = Auth::user()->id;
     $post->save();
     if ($uploaded) {
         return Redirect::to('g/' . Input::get('uid') . '/edit/' . $dbFile->id);
     } else {
         return Response::jscon('error', 400);
     }
 }

 /**
  * Get the guest's group, containing only the 'guests' group model.
  *
  * @return Group
  */
 public function getGroupsAttribute()
 {
     if (!isset($this->attributes['groups'])) {
         $this->attributes['groups'] = $this->relations['groups'] = Group::where('id', Group::GUEST_ID)->get();
     }
     return $this->attributes['groups'];
 }

 public static function parseQuestionStore($file, $schoolID, $returnFile = false)
 {
     $file = explode("\n", $file);
     $fileLength = count($file);
     $origMarks = array();
     for ($lineI = 0; $lineI < $fileLength; ++$lineI) {
         $file[$lineI] = explode("|", $file[$lineI]);
         $lineLength = count($file[$lineI]);
         for ($i = 0; $i < $lineLength; ++$i) {
             $valueLength = $valueIndex = strlen($file[$lineI][$i]);
             if ($valueLength) {
                 while ($file[$lineI][$i][--$valueIndex] == '\\') {
                 }
                 if (($valueLength - $valueIndex + 1) % 2) {
                     $file[$lineI][$i] = substr($file[$lineI][$i], 0, $valueLength - 1) . "|" . $file[$lineI][$i + 1];
                     //Move all of the remaining values back.
                     for ($innerI = $i + 1; $innerI < $lineLength - 1; ++$innerI) {
                         $file[$lineI][$innerI] = $file[$lineI][$innerI + 1];
                     }
                     array_pop($file[$lineI]);
                     --$i;
                     --$lineLength;
                 }
             }
         }
         //Line has been completed.
         //Does it have 4 entries only?
         if ($lineLength != 4) {
             return array(false, "Question {$lineI} must have 4 values.");
         }
         //First is Q?
         if ($file[$lineI][0] != "Q") {
             return array(false, "The first value of question {$lineI} must be 'Q'.");
         }
         //All in second value are valid group names for the given schoolID.
         $file[$lineI][1] = explode(',', $file[$lineI][1]);
         $groupsLength = count($file[$lineI][1]);
         $groupRecords = array();
         for ($i = 0; $i < $groupsLength; ++$i) {
             if (is_null(Group::where('school_id', '=', $schoolID)->where('name', '=', $file[$lineI][1][$i])->first())) {
                 return array(false, "Question {$lineI} contains invalid group {$file[$lineI][1][$i]}.");
             }
             foreach ($groupRecords as $groupRecord) {
                 if ($groupRecord == $file[$lineI][1][$i]) {
                     return array(false, "In question {$lineI}, the group {$groupRecord} cannot be repeated.");
                 }
             }
             $groupRecords[] = $file[$lineI][1][$i];
         }
         if (in_array($file[$lineI][2], $origMarks)) {
             return array(false, "In question {$lineI}, the original mark {$file[$lineI][2]} already exists.");
         }
         $origMarks[] = $file[$lineI][2];
     }
     if ($returnFile) {
         return array(true, $file);
     }
     return array(true);
 }

 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     //get the nerd
     $nerd = Nerd::find($id);
     $group_options = Group::where('active', '=', 1)->lists('group_name', 'id');
     //show the edit view and pass the nerd to it
     return View::make('nerds.edit')->with('nerd', $nerd)->with('group_options', $group_options);
 }

 public function viewGroup($name, $mode = 'default')
 {
     $group = Group::where('group_name', $name)->firstOrFail();
     $subscription = Gsub::where('user_fp', self::userFp())->where('group_name', $name)->first();
     $subscribers = Gsub::where('group_name', $name)->count();
     $subscribers = DB::table('gsubs')->where('gsubs.group_name', $name)->join('users', 'users.user_fp', '=', 'gsubs.user_fp')->select('gsubs.id', 'users.*')->get();
     return View::make('board.group', ['mode' => $mode, 'posts' => Post::group($name, $mode, self::getBL()), 'subscription' => $subscription, 'subscribers' => $subscribers, 'group' => $group]);
 }

 public function show($id)
 {
     if (Auth::user()->is_admin) {
         $grupo = Group::where('id', $id)->first();
         return View::make('grupos.show')->with('grupo', $grupo);
     }
     return Redirect::to('/inicio');
 }

 public function showFellowSelect($city_id)
 {
     $fellowName = "Propel Fellow";
     $home = new HomeController();
     $year = $home->get_year();
     $fellows = Group::where('name', '=', $fellowName)->first()->fellow()->distinct()->where('city_id', '=', $city_id)->where('year', '=', $year)->where('status', '=', '1')->where('user_type', '=', 'volunteer')->get();
     //return $fellows;
     return View::make('city.select-fellow')->with('fellows', $fellows);
 }

 public function findGroupByID($group_id)
 {
     $group = \Group::where('id', '=', $group_id)->first();
     if ($group) {
         return $group;
     } else {
         return false;
     }
 }

 private static function statGroups()
 {
     $groups = DB::table('posts')->where('parent_id', '=', 0)->where('timestamp', '>', Carbon\Carbon::now()->subMonth())->whereIn('group_name', Group::where('is_featured', 1)->lists('group_name'))->lists('group_name');
     $result = [];
     foreach ($groups as $g) {
         $result[$g] = Post::where('group_name', '=', $g)->count();
     }
     arsort($result);
     return array_slice($result, 0, 30);
 }

 public function getGroupverifications()
 {
     $user = Auth::user();
     if (!$user->can('admin_verify_users')) {
         return Redirect::to('/dashboard')->with('message', "You do not have permission");
     }
     $groups = Group::where('status', '!=', Group::STATUS_ACTIVE)->get();
     $data = array('page_id' => 'verify_groups', 'page_title' => 'Verify Groups', 'requests' => $groups);
     return View::make('dashboard.verify-group', $data);
 }

 public function subscriberCounterStat()
 {
     $count = 0;
     $subscriber = Group::where('name', 'LIKE', '%ubscrib%')->first();
     if ($subscriber) {
         $related = Groups::getRelationProvider()->createModel()->where('group_id', '=', $subscriber->id);
         $count = count($related->get());
     }
     $this->widgetData = array('count' => $count);
     $this->setupWidgetLayout(__METHOD__);
 }

 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('user_group')->delete();
     $lukas = User::where('username', '=', 'Lukas Bindreiter')->firstOrFail();
     $philipp = User::where('username', '=', 'Philipp Hofer')->firstOrFail();
     $megacities = Group::where('name', '=', 'Megacities')->firstOrFail()->id;
     $house = Group::where('name', '=', 'House, mouse ...')->firstOrFail()->id;
     $ly = Group::where('name', '=', 'Last year')->firstOrFail()->id;
     $lukas->groups()->sync(array($megacities, $house));
     $philipp->groups()->sync(array($megacities, $ly));
 }