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']);
}
