public function pList($categorySlug) { $pag = config('courier.pagination'); $pages = Page::where('active', 1)->orderBy('id', 'desc')->with(['category' => function ($query) use($categorySlug) { $query->where('slug', $categorySlug); }])->paginate($pag); return view('pblog::blog.list', ['posts' => $pages]); }
/** * Run the database seeds. * * @return void */ public function run() { $building = Page::where('url', 'building')->first(); if (!$building) { $building = new Page(); $building->url = 'building'; $building->view = 'building'; } $building->is_open = 1; $building->save(); }
public function show($id) { $id = htmlspecialchars($id); $page = Page::where('url', $id)->isOpen()->first(); if ($page) { ++$page->views; $page->save(); if ($page->openurl != '') { return Redirect::to(strip_tags($page->openurl)); } else { return view('page.' . $page->view, array('page' => $page)); } } else { return Redirect::to('/'); } }
public function index(Request $request) { $slug = $request->route('slug'); $isCategory = PageModel::where('pag_slug', $slug)->pluck('pag_cat_id'); $datas = ""; $page = ""; if ($isCategory > 0) { $datas = DB::table('CATEGORY as cat')->join('POST as pos', function ($join) { $join->on('pos.cat_id', '=', 'cat.cat_id'); })->where('cat.cat_id', '=', $isCategory)->select('pos.pos_id', 'pos.pos_name', 'pos_image', 'pos_sum')->get(); } else { $page = PageModel::where('pag_slug', $slug)->first(['pag_desc']); } $menus = $this->getMenu(); return view('front.page', compact('datas', 'menus', 'page')); }
public function index() { $pages = PageModel::where("pag_status_cd", "ACT")->get(); return view('pages.index', compact('pages')); }
public function getMenu() { return Page::where("pag_status_cd", "ACT")->orderBy('pag_order', 'asc')->get(['pag_name', 'pag_slug']); }