PHP Category::whereSlug方法代碼示例

 /**
  * Display a listing of categories and the category members (parent-children) and their social media.
  *
  * @return Response
  */
 public function index($slug)
 {
     // get links in footer
     $linksArr = \App\Links::orderBy('rank', 'ASC')->lists('link', 'name');
     if ($slug != 'all') {
         $catObj = Category::whereSlug($slug)->first();
         if (is_null($catObj)) {
             \Session::flash('message', 'Invalid category');
             return redirect('/socialmedia/all');
         }
         $catPathArr = $catObj->getCategoryPath($slug);
         $catArr = $catObj->getChildren($catObj->id);
     } else {
         $catPathArr = array();
         $catObj = new Category();
         $catArr = $catObj->getParents();
     }
     $getChildren = $this->getChildrenBool($catPathArr, $slug, $catObj);
     // eg. get the teammates on the Lakers, don't get teams in the Pacific Coast division
     if ($getChildren) {
         $memberArr = $this->memberObj->getMembersWithinSingleCategory($catObj->id);
         list($memberArr, $contentArr) = $this->memberSocialObj->getSocialMediaWithMemberIds($memberArr);
         return view('socialmedia.child', compact('memberArr', 'contentArr', 'catPathArr', 'linksArr'));
     } else {
         $parentArr['contentArr'] = [];
         foreach ($catArr as $catId => $catName) {
             $memberArr = $this->memberObj->getMembersWithinSingleCategory($catId);
             $tmpMemberArr = array($memberArr[0]);
             list(, $contentArr) = $this->memberSocialObj->getSocialMediaWithMemberIds($tmpMemberArr);
             $parentArr['memberArr'][$catId] = $memberArr;
             $parentArr['contentArr'] = $parentArr['contentArr'] + $contentArr;
         }
         return view('socialmedia.parent', compact('parentArr', 'catArr', 'catPathArr', 'linksArr'));
     }
 }

 /**
  * Find all tricks for the category that matches the given slug.
  *
  * @param string $slug
  * @param int    $perPage
  *
  * @return array
  */
 public function findByCategory($slug, $perPage = self::PAGE_SIZE)
 {
     $category = $this->category->whereSlug($slug)->first();
     if (is_null($category)) {
         throw new CategoryNotFoundException('The category "' . $slug . '" does not exist!');
     }
     $tricks = $category->tricks()->orderBy('created_at', 'DESC')->paginate($perPage);
     return [$category, $tricks];
 }

 public static function fetch_status_history($category_slug)
 {
     $json = [];
     $category = Category::whereSlug($category_slug)->first();
     $device_statuses = DeviceStatus::all();
     foreach ($device_statuses as $device_status) {
         if ($device_status->device->category_id == $category->id) {
             $json[] = ['device_slug' => $device_status->device->slug, 'device_name' => $device_status->device->name, 'user_slug' => $device_status->user->id, 'user_name' => $device_status->user->name, 'status_label' => $device_status->status->status, 'status_descrip' => $device_status->status->description, 'created_at' => date('m/d/Y h:i A', strtotime($device_status->created_at))];
         }
     }
     return json_encode($json);
 }

 /**
  * Define your route model bindings, pattern filters, etc.
  *
  * @param  \Illuminate\Routing\Router  $router
  * @return void
  */
 public function boot(Router $router)
 {
     // Route Bindings
     $router->bind('categories', function ($value) {
         return Category::whereSlug($value)->first();
     });
     $router->bind('posts', function ($value) {
         return Post::whereSlug($value)->first();
     });
     $router->bind('author', function ($value) {
         return User::whereName($value)->first();
     });
     parent::boot($router);
 }

 /**
  * Define your route model bindings, pattern filters, etc.
  *
  * @param  \Illuminate\Routing\Router  $router
  * @return void
  */
 public function boot(Router $router)
 {
     $this->bind('package', function ($slug) {
         return Package::with('photos')->whereSlug($slug)->firstOrFail();
     });
     $this->bind('category', function ($slug) {
         return Category::whereSlug($slug)->firstOrFail();
     });
     $this->bind('packages', function ($id) {
         return Package::findOrFail($id);
     });
     $this->bind('categories', function ($id) {
         return Category::findOrFail($id);
     });
     parent::boot($router);
 }

 /**
  * Define your route model bindings, pattern filters, etc.
  *
  * @param \Illuminate\Routing\Router $router
  *
  * @return void
  */
 public function boot(Router $router)
 {
     $router->bind('user', function ($value) {
         return \App\User::whereSlug($value)->firstOrFail();
     });
     $router->bind('category', function ($value) {
         return \App\Category::whereSlug($value)->firstOrFail();
     });
     $router->bind('event', function ($value) {
         return \App\Event::whereSlug($value)->firstOrFail();
     });
     $router->bind('city', function ($value) {
         return \App\City::where('iata', $value)->firstOrFail();
     });
     $router->bind('subscriber', function ($value) {
         return \App\Subscriber::where('token', $value)->firstOrFail();
     });
     parent::boot($router);
 }

 /**
  * 創建分類 
  *
  * @param string $value 
  *
  * @return Response
  */
 public function postCreate()
 {
     $rules = array('name' => 'required', 'slug' => 'regex:/^[a-zA-Z 0-9_-]+$/', 'parent_id' => 'integer');
     $validator = Validator::make(Input::all(), $rules);
     if ($validator->fails()) {
         return Redirect::back()->withErrors($validator)->withInput();
     }
     // 檢測分類名
     if (Category::whereName(Input::get('name'))->count()) {
         return Redirect::back()->withMessage("分類 '" . Input::get('name') . "' 已經存在！")->withColor('danger')->withInput(Input::all());
     }
     //檢測別名
     if (Input::get('slug') && Category::whereSlug(Input::get('slug'))->count()) {
         return Redirect::back()->withMessage("分類別名 '" . Input::get('slug') . "' 已經存在！")->withColor('danger')->withInput(Input::all());
     }
     // 創建分類
     $category = new Category();
     $category->name = Input::get('name');
     $category->slug = str_replace(' ', '', snake_case(Input::get('slug')));
     $category->parent = Input::get('parent_id');
     $category->description = Input::get('description');
     $category->save();
     return Redirect::back()->withMessage("分類 '{$category->name}' 添加成功！");
 }

 public static function retrieveAvailableDevices($category_slug, $request)
 {
     $count = 0;
     $category = Category::whereSlug($category_slug)->first();
     $devices = Device::with(['category', 'information'])->where('category_id', $category->id)->where('owner_id', 0);
     $devices = $devices->where('name', 'LIKE', '%' . $request->get('filter') . '%')->paginate(25);
     $devices->setPath('available_devices');
     return view('devices.available_devices', compact('category', 'devices', 'count'));
 }

 public function getCategory($slug)
 {
     $category = Category::whereSlug($slug)->firstOrFail();
     $products = $category->product()->paginate(12);
     return view('front.home', compact('products'));
 }

Route::get('/article/detail/{id}', array('uses' => 'ArticleController@showPublic'));
Route::get('/index', function () {
    $coupons = Coupon::all();
    return View::make('index')->with('coupons', $coupons);
});
Route::get('/admin', 'UserController@getAdminLogin');
Route::post('/admin', 'UserController@postAdminLogin');
Route::get('/logout', 'UserController@getLogout');
Route::get('/admin/dashboard', function () {
    return view('admin.content');
});
Route::model('articles', 'Article');
Route::model('merchants', 'Merchant');
Route::model('coupons', 'Coupon');
Route::model('categories', 'Category');
Route::bind('articles', function ($value, $route) {
    return App\Article::whereSlug($value)->first();
});
Route::bind('merchants', function ($value, $route) {
    return App\Merchant::whereSlug($value)->first();
});
Route::bind('coupons', function ($value, $route) {
    return App\Coupon::whereSlug($value)->first();
});
Route::bind('categories', function ($value, $route) {
    return App\Category::whereSlug($value)->first();
});
Route::resource('admin/article', 'ArticleController');
Route::resource('admin/merchant', 'MerchantController');
Route::resource('admin/coupon', 'CouponController');
Route::resource('admin/category', 'CategoryController');

 public function viewCategoryStatusesHistory($category_slug)
 {
     $category = Category::whereSlug($category_slug)->first();
     return view('category.device_statuses', compact('category'));
 }

 public static function setCategories($post, $category_ids = null, $new_category = null)
 {
     $post->categories()->detach();
     if (isset($new_category) && !empty($new_category)) {
         $current_category = Category::whereSlug(str_slug($new_category))->first();
         if (!$current_category) {
             $new_category = Category::create(['name' => $new_category, 'slug' => str_slug($new_category)]);
             $add_cat_id = $new_category->id;
         } else {
             $add_cat_id = $current_category->id;
         }
         if (is_null($category_ids)) {
             $category_ids = [];
         }
         array_push($category_ids, $add_cat_id);
     }
     if (isset($category_ids)) {
         $post->categories()->attach($category_ids);
     }
 }

 /**
  * All files by slug of category
  */
 public function scopeOfCategory($query, $categorySlug)
 {
     $category = Category::whereSlug($categorySlug)->firstOrFail();
     return $query->whereCategoryId($category->id);
 }

 public function showDefectDev($category_slug)
 {
     $category = Category::whereSlug($category_slug)->first();
     return view('devices.defective_devices', compact('category'));
 }

 /**
  * Display the specified resource.
  *
  * @param  int $id
  * @return Response
  */
 public function show($slug)
 {
     $page_size = env('num_per_page');
     //        //method I.               num of queries:  17.
     //        $articles = Category::findBySlug($slug)->articles()->latest()->paginate($page_size);
     //method II: eager loading. num of queries 5
     //http://php.net/manual/en/functions.anonymous.php   "use" to inherit variables from its parent scope
     //whereSlug($slug) equals to where('slug', '=', $slug).
     $articles = \App\Article::with('tags', 'category')->published()->whereHas('category', function ($query) use($slug) {
         $query->whereSlug($slug);
     })->latest()->paginate($page_size);
     $Catname = Category::whereSlug($slug)->firstOrFail()->name;
     return view('blog.cats.show', compact('articles', 'Catname'));
 }