PHP Page::where方法代码示例

 /**
  * Update the specified resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function update(\App\Http\Requests\StorePageRequest $request, $id)
 {
     $page = \App\Page::where(['id' => $id])->first();
     $page->fill($request->all());
     $page->save();
     return redirect(url('admin'));
 }

 public function welcome(Service $serviceModel)
 {
     $sliders = Slider::all();
     $services = $serviceModel->getService();
     $page = Page::where('name', '=', 'home')->firstOrFail();
     return view('welcome')->with('sliders', $sliders)->with('services', $services)->with('page', $page);
 }

 public function show()
 {
     $page = Page::where('slug', 'netklubbur')->first();
     $data['page'] = $page;
     $data['banner'] = $page->banner;
     return view('frontend.netklubbur')->with($data);
 }

 public function home()
 {
     $data['forsidumyndir'] = \App\Page::where('slug', '_forsidumyndir')->first()->getSubs();
     $cats = \App\Category::where('status', 1)->get();
     $prods = \App\Product::where('status', 1)->get();
     $items = [$cats, $prods];
     $kubbar = [];
     foreach ($items as $item) {
         foreach ($item as $v) {
             $frontpaged = trim($v->extras()->get('frontpaged')) ?: 0;
             $size = trim($v->extras()->get('size'));
             $titill = trim($v->extras()->get('titill')) ?: $v->title;
             if ($frontpaged && $frontpaged != 0) {
                 $kubbar[] = ['title' => $titill, 'size' => $size ? $size : 1, 'frontpaged' => $frontpaged, 'fillimage' => $v->fillimage ? true : false, 'path' => $v->fullPath(), 'image' => $v->img()->first(), 'slug' => $v->slug];
             }
         }
     }
     usort($kubbar, function ($a, $b) {
         if ($a['frontpaged'] == $b['frontpaged']) {
             return 0;
         }
         return $a['frontpaged'] < $b['frontpaged'] ? -1 : 1;
     });
     $data['kubbar'] = $kubbar;
     return view('frontend.layout')->with($data);
 }

 public function search()
 {
     $keywords = Input::get('keyword');
     $RecentPage = Page::where('id', '>=', 1)->orderBy('created_at', 'desc')->take(5)->get();
     $result = Page::where('title', 'like', '%' . $keywords . '%')->paginate(3);
     return view('index.home', ['time' => date('Y-m-d H:i:s')])->withPages($result)->withRecentpages($RecentPage);
 }

 /**
  * Update the specified resource in storage.
  *
  * @param PageRequest|Request $request
  * @param Project $project
  * @param Module $module
  * @param Page $page
  * @return \Illuminate\Http\Response
  */
 public function update(PageRequest $request, Project $project, Module $module, Page $page)
 {
     if (isset($_POST['module_id'])) {
         $module_id = $_POST['module_id'];
         $pages = Page::where('module_id', '=', $module_id)->get();
         foreach ($pages as $page) {
             $page->update($request->all());
             $page->save();
         }
         return redirect()->route('project.module.show', [$project, $module]);
     }
     if (isset($_POST['module_name'])) {
         $pages = $_POST;
         $module = Module::where('project_id', '=', $project->id)->where('name', '=', $_POST['module_name'])->first();
         foreach ($pages as $val) {
             if (is_numeric($val)) {
                 $p = Page::where('id', '=', $val)->first();
                 $p->module_id = $module->id;
                 $p->save();
             }
         }
     }
     $page->update($request->all());
     $page->save();
     return redirect()->route('project.module.show', [$project, $module]);
 }

 public function show(Request $request, $url_name)
 {
     if ($url_name == 'contact') {
         //$data = array('name','mail','note');
         /*
         foreach($this->in as $val) {
             //$pageObjs[$key] = $val;
             $pageObjs[$val] = $request->session()->pull($val, '');
         }
         */
         //session()->forget(['name','mail','note']);
         //            $obj = $this->page -> where('url_name', $request->path()) -> first();
         //            $headTitle = $obj -> title;
         //            $intro_ct = $obj -> intro_content;
         $headTitle = 'お問い合わせ';
         return view('pages.contact', ['headTitle' => $headTitle]);
     } else {
         if ($pageObj = Page::where('url_name', $url_name)->first()) {
             if ($pageObj->closed == '非公開' && (!Auth::user() || Auth::user()->admin != 99)) {
                 abort(404);
             } else {
                 return view('pages.page')->with(compact('pageObj'));
             }
         } else {
             abort(404);
         }
     }
 }

 public function edit(Post $post)
 {
     $data['tags'] = Tag::lists('name', 'id');
     $data['pages'] = Page::where('status', 1)->lists('title', 'id');
     $data['post'] = $post;
     return view('post.update', $data);
 }

 public function show($slug)
 {
     $page = Page::where('slug', $slug)->first();
     $courses = Course::published()->hasCategory()->orderBy('created_at', 'desc')->take(4)->get();
     $articles = Article::published()->orderBy('published_at', 'desc')->take(2)->get();
     return view('pages.show', ['page' => $page, 'latest_courses' => $courses, 'latest_articles' => $articles]);
 }

 public function index(Request $request)
 {
     $page_slug = trim($request->page_slug);
     $pageData = Cache::rememberForever('pageData_' . $page_slug, function () use($page_slug) {
         return Page::where('page_slug', $page_slug)->firstOrFail();
     });
     return view('page.page', ['pageData' => $pageData]);
 }

 public function getItem($cat, $item)
 {
     $category = Category::where('sef', '=', $cat)->first();
     $item = Page::where('sef', $item)->first();
     $previous = Page::where('id', '<', $item->id)->orderBy('id', 'desc')->first();
     $next = Page::where('id', '>', $item->id)->orderBy('id', 'asc')->first();
     $category = Category::where('id', $item->category_id)->first();
     return view('steklo.item')->withCategory($category)->withItem($item)->withPrevious($previous)->withNext($next);
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     //
     $pages = Page::where('module_id', '=', $_GET)->get();
     $existing_pages_count = Page::where('module_id', '=', $_GET)->count();
     $projected_pages = Module::where('id', '=', $_GET)->pluck('projected_total_pages');
     $pages_count = $projected_pages - $existing_pages_count;
     return view('pages.index', compact('pages', 'pages_count'));
 }

 function index()
 {
     $first = 'Kenneth';
     $last = 'Sinder';
     $courses = ['Foundations of Sequential Programs', 'Digital Computers', 'Data Abstraction and Implementation', 'Logic and Computation'];
     // TODO: add to DB
     $text = Page::where('location', 'about')->first()->text;
     return view('about.index')->with(compact('first', 'last', 'courses', 'text'));
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index(Request $request)
 {
     $q = new RecordQueryBuilder($request, 'dommer', DommerRecord::class);
     $q->make();
     $data = ['prefix' => 'dommer', 'query' => $request->all(), 'columns' => $q->getColumns(), 'sortColumn' => $q->sortColumn, 'sortOrder' => $q->sortOrder, 'intro' => Page::where('name', '=', 'dommer.intro')->first()->body];
     $data['records'] = $q->query->join('dommer_kilder', 'dommer.kilde_id', '=', 'dommer_kilder.id')->select('dommer.*', 'dommer_kilder.navn AS kilde_navn')->paginate(50);
     $data['kilder'] = $this->getKilder();
     return response()->view('dommer.index', $data);
 }

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function getIndex(Request $request)
 {
     if (!$request->jenis) {
         return redirect(route('menu', ['jenis' => 'Header']));
     } else {
         $Menus = Menu::where('lokasi', $request->jenis)->where('parent_id', 0)->orderBy('urutan', 'asc')->get();
         $Kategori = Kategori::orderBy('nama_kategori', 'asc')->get();
         $Pages = Page::where('draft', 0)->where('arsip', 0)->orderBy('id', 'desc')->get();
         return view('admin.menu.index', ['Menus' => $Menus, 'Kategori' => $Kategori, 'Pages' => $Pages, 'Jenis' => $request->jenis]);
     }
 }