PHP Category::select方法代码示例

 public function getEdit($id)
 {
     $category = Category::select('id', 'name', 'prarent_id')->get()->toArray();
     $product = Product::findOrFail($id);
     $product_img = Product::findOrFail($id)->pimages()->get()->toArray();
     return view('backend.product.edit', compact('category', 'product', 'product_img'));
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     //
     $users = User::select('id')->get();
     $products = Product::select('id')->get();
     $categories = Category::select('id')->get();
     $areas = Area::select('id')->get();
     $orders = Order::select('id')->get();
     return view('admin.dashboard', compact('users', 'products', 'categories', 'areas', 'orders'));
 }

    public function getViewCat($category_id)
    {
       // $posts = DB::table('posts')
       //     ->where('category_id', '=', $category_id)
        //    ->get();

        return view('category')
        ->with('title', 'Blog | Category')
        ->with('catdescription',Category::select('description')->where('id', $category_id)->first())
        ->with('posts', Post::where('category_id', '=', $category_id)->paginate(10))
        ->with('category', Category::all());
    }

 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function create()
 {
     $user = Auth::user();
     $user_type = $user->user_type;
     if ($user_type == 'COMPANY') {
         $id_company = $user->id_company;
     } else {
         $id_company = Session::get('id_company');
     }
     $categories = Category::select('category_name', 'id_category')->where('id_company', '=', $id_company)->get();
     $products = Product::where('id_company', '=', $id_company)->get();
     return view("pedidos.novo", compact('products', 'categories'));
 }

 /**
  * Отображаем пагинацией все новости в конкретной категории
  *
  * @param $id
  * @return \Illuminate\View\View
  */
 public function categoryId($id)
 {
     try {
         $data = \DB::table('news')->where('category_id', $id)->where('publish', '1')->orderBy('id', 'desc')->paginate(10);
         $categoryTitle = Category::select('title')->where('id', $id)->where('publish', 1)->get()[0]->title;
     } catch (\ErrorException $e) {
         abort(404);
     }
     // обрезаем 200 символов текста новости
     $this->get200Text($data);
     $this->title .= ': ' . $categoryTitle . $this->getTitlePagination();
     return view('news.list', ['title' => $this->title, 'data' => $data, 'categoryTitle' => $categoryTitle]);
 }

 /**
  * Отображаем пагинацией все статьи в конкретной категории
  *
  * @param $id
  * @return \Illuminate\View\View
  */
 public function categoryId($id)
 {
     // почему-то не работает upd:заработало. спасибо stackoverflow!
     //$data = Category::find($id)->articles()->where('publish', '1')->paginate(5);
     try {
         $data = \DB::table('info')->where('category_id', $id)->where('publish', '1')->where('published_at', '<=', Carbon::now())->orderBy('id', 'desc')->select('title', 'url')->paginate(10);
         $categoryTitle = Category::select('title')->where('id', $id)->where('publish', 1)->get()[0]->title;
     } catch (\ErrorException $e) {
         abort(404);
     }
     $this->title .= $categoryTitle . $this->getTitlePagination();
     return view('articles.list', ['title' => $this->title, 'data' => $data, 'categoryTitle' => $categoryTitle]);
 }

 /**
  * Bootstrap any application services.
  *
  * @return void
  */
 public function boot()
 {
     $table = "company";
     if (\Schema::hasTable($table)) {
         $main_company = Company::find(1)->toArray();
         $categories_menu = \Cache::remember('categories_mothers', 25, function () {
             return Category::select('id', 'name')->childsOf('mothers')->actives()->get()->toArray();
         });
         $menu = [];
         foreach ($categories_menu as $value) {
             $menu[$value['id']] = $value;
         }
         \View::share('main_company', $main_company);
         \View::share('categories_menu', $menu);
     }
 }

 public function getall()
 {
     $categories = Category::select('id', 'cat_name', 'img_url', 'cat_position')->get();
     return Response::json($categories);
 }

 /**
  * @param Category $except
  *
  * @return CategoriesController
  */
 protected function getCategoryOptions($except = null)
 {
     /** @var \Kalnoy\Nestedset\QueryBuilder $query */
     $query = Category::select('id', 'name')->withDepth();
     if ($except) {
         $query->whereNotDescendantOf($except)->where('id', '<>', $except->id);
     }
     return $this->makeOptions($query->get());
 }

 public static function getRandId()
 {
     $category = Category::select(['id'])->orderByRaw('RAND()')->take(1)->first();
     return $category->id;
 }

 /**
  * @param Category $except
  *
  * @return CategoriesController
  */
 protected function getCategoryOptions($except = null)
 {
     $query = Category::select('id', 'name')->withDepth();
     if ($except) {
         $query->whereNotDescendantOf($except)->where('id', '<>', $except->id);
     }
     return $this->makeOptions($query->get());
 }

 public function propertyCategories()
 {
     $search = \Input::get('q');
     if ($search) {
         $categories = \App\Category::select('Categories.*')->join('CategoryLanguages', 'CategoryLanguages.property_id', '=', 'Categories.id')->where('CategoryLanguages.locale', $this->lang)->where('CategoryLanguages.title', 'like', $search . '%')->orderBy('Categories.created_at', 'desc')->paginate($this->limit);
     } else {
         $categories = \App\Category::orderBy('order', 'asc')->paginate($this->limit);
     }
     return view('admin.pages.categories', compact('categories'));
 }

 /**
  * Show the form for editing the specified resource.
  *
  * @param  int $id
  * @return Response
  */
 public function edit($slug)
 {
     return view('admin.articles.edit', ['article' => Article::with('tags', 'category')->where('slug', $slug)->firstOrFail(), 'categories' => Category::select('id', 'name')->get(), 'tags' => Tag::select('id', 'name')->get()]);
 }

 public function getEdit($id)
 {
     $data = Category::findOrFail($id)->toArray();
     $parent = Category::select('id', 'name', 'prarent_id')->get()->toArray();
     return view('backend.category.edit', compact('parent', 'data'));
 }

 /**
  * parentsTree
  * Retrieve all the categories parents of one passed through parameter,
  * checking data from bottom to top
  * @param [int] $id is the id category evaluated
  * @param [array] $array is the array to be used out of the model
  * @param [array] $fields is the array that contais the table field we want to retrieve
  */
 public static function parentsTree($id, &$array, $fields = ['id', 'category_id', 'name'])
 {
     $categories = Category::select($fields)->where('id', $id)->get()->toArray();
     if (is_null($categories)) {
         return;
     }
     foreach ($categories as $value) {
         $array[] = $value;
         Category::parentsTree($value['category_id'], $array, $fields);
     }
     return;
 }