PHP Tag::select方法代码示例

 public function show($tag)
 {
     $rs = Tag::where('tag', $tag)->get();
     $arr = array();
     foreach ($rs as $v) {
         array_push($arr, $v->article_id);
     }
     $articles = Article::whereIn('id', $arr)->get();
     $tags = Tag::select('tag')->distinct()->get();
     return view('member.tags.show', compact('tag', 'tags', 'articles'));
 }

 public function index(Request $request)
 {
     $page = $request->get('page') ?: 1;
     $tags = Tag::select('tag')->distinct()->get();
     $articles = Article::latest()->where('published_at', '<=', Carbon::now())->skip(($page - 1) * self::PAGE_SIZE)->limit(10)->get();
     $total = Article::latest()->where('published_at', '<=', Carbon::now())->get()->count();
     $cates = Cate::all();
     $teams = Team::where('user_id', \Auth::user()->id)->get();
     $action = 'articles';
     $pageData['totalPage'] = ceil($total / self::PAGE_SIZE);
     $pageData['currentPage'] = $page;
     return view('member.articles.index', compact('articles', 'tags', 'cates', 'teams', 'articles', 'pageData'));
 }

 /**
  * Display the home page.
  */
 public function index()
 {
     $carousel_news = Article::select('id', 'title', 'page_image')->where('is_checked', true)->where('is_carousel', true)->published()->get();
     $latest_news = Article::select('id', 'title', 'intro', 'page_image')->where('is_checked', true)->published()->orderBy('published_at', 'desc')->take(4)->get();
     $ads = Ad::select('url', 'name', 'image_path')->orderBy('created_at', 'desc')->take(2)->get();
     // get the index article
     $tags = Tag::select('id', 'name')->where('show_index', true)->get();
     $index_articles = array();
     foreach ($tags as $tag) {
         $tag['articles'] = $tag->articles()->select('article_id', 'title', 'intro', 'page_image')->where('is_checked', true)->published()->orderBy('published_at', 'desc')->take(3)->get();
         $index_articles[] = $tag;
     }
     return view('front.index')->with('carousel_news', $carousel_news)->with('latest_news', $latest_news)->with('ads', $ads)->with('index_articles', $index_articles);
 }

 public function show($id)
 {
     $user = User::findOrFail($id);
     $tags = Tag::select('tag')->distinct()->where('user_id', $id)->get();
     $articles = Article::where('user_id', $id)->orderby('published_at', 'desc')->get();
     //博主访客加1
     if (\Auth::user()->id != $id) {
         $r = FlowTrace::where(['user_id' => $id, 'time' => substr(Carbon::now(), 0, 10)])->first();
         if ($r) {
             $r->increment('daycount');
         } else {
             FlowTrace::create(array('user_id' => $id, 'time' => substr(Carbon::now(), 0, 10), 'daycount' => 1));
         }
         User::where('id', $id)->increment('score');
     }
     return view("member.users.show", compact('user', 'tags', 'articles'));
 }

 public function getAllwithPosts()
 {
     return Tag::select('id', 'title')->with(['posts' => function ($q) {
         $q->select('id', 'title')->active();
     }])->get();
 }

 /**
  * Bootstrap any application services.
  *
  * @return void
  */
 public function boot()
 {
     view()->composer('front.nav', function ($view) {
         view()->share('tags', Tag::select('id', 'name')->orderBy('id', 'asc')->get());
     });
 }

 /**
  * 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()]);
 }

 /**
  * 获取不同筛选条件中的值
  * @method getCondations
  * @return [type]        [description]
  */
 public function getCondations()
 {
     $data['instrument'] = Instrument::select('id', 'name')->get();
     $data['press'] = \App\Press::select('id', 'name')->get();
     $data['tag'] = \App\Tag::select('id', 'name')->get();
     // $data['operator'] = \App\User::select('id', 'name')->with('musics')->whereHas('musics', function ($query) {
     //                                                         $query->groupby('operator');
     //                                                     })->groupby('id')->get();
     $data['operator'] = \App\User::select('id', 'name')->whereHas('musics', function ($query) {
         $query->groupby('operator');
     })->groupby('id')->get();
     $data['organizer'] = \App\Organizer::select('id', 'name')->get();
     return $data;
     // $data['status'] = 'sdfsdfsdfsdfsdfsdfsdfdsf';
     // return $data;
 }

 /**
  * Show the form for editing the specified resource.
  *
  * @param  int $id
  * @return Response
  */
 public function edit($id)
 {
     $product = $this->productRepository->findById($id);
     if (auth()->user()->id != $product->user_id) {
         return redirect()->home();
     }
     $categories_list = $this->categoryRepository->getParentsAndChildrenList(true);
     //Category::lists('name', 'id')->all();
     $tags_list = Tag::select('name', 'price', 'id')->get();
     $options_list = Option::select('name', 'description', 'price', 'id')->get();
     $selected_categories = $product->categories()->select('categories.id AS id')->lists('id')->all();
     $selected_tags = $product->tags()->select('tags.id AS id')->lists('id')->all();
     return view('products.edit')->with(compact('product', 'categories_list', 'tags_list', 'options_list', 'selected_categories', 'selected_tags'));
 }