/** * List all blog. * * @return Response */ public function index(Request $request) { // pagination $session_type = 'blog'; if (!$request->session()->has('order_by')) { $request->session()->put($session_type . '.order_by', 'created_at'); } if (!$request->session()->has('order_dir')) { $request->session()->put($session_type . '.order_dir', 'desc'); } if ($request->order_by) { $request->session()->put($session_type . '.order_by', $request->order_by); } if ($request->order_dir) { $request->session()->put($session_type . '.order_dir', $request->order_dir); } $limit = $request->session()->get('limit'); $orderby = $request->session()->get($session_type . '.order_by') == 'created_at' ? $request->session()->get($session_type . '.order_by') : $request->session()->get('language') . '.' . $request->session()->get($session_type . '.order_by'); $blog = Blog::where('shop_id', '=', $request->session()->get('shop'))->where(function ($query) use($request) { if ($request->search) { return $query->where('en.name', 'LIKE', '%' . $request->search . '%'); } })->orderBy($orderby, $request->session()->get($session_type . '.order_dir'))->paginate($limit); $blog->search = $request->search; return view('admin/blog/index', ['blog' => $blog]); }
/** * Show article. * * @return Response */ public function show($slug) { $blog = Blog::where('slug', $slug)->first(); if (!$blog) { \App::abort(404); } return view('themes/kudos/blog/show', ['blog' => $blog]); }
/** * Show the application dashboard. * * @return Response */ public function show(Request $request) { $stats['categories'] = Category::where('shop_id', '=', $request->session()->get('shop'))->count(); $stats['products'] = Product::where('shop_id', '=', $request->session()->get('shop'))->count(); $stats['customers'] = User::where('shop_id', '=', $request->session()->get('shop'))->count(); $stats['pages'] = Page::where('shop_id', '=', $request->session()->get('shop'))->count(); $stats['blogs'] = Blog::where('shop_id', '=', $request->session()->get('shop'))->count(); $stats['orders'] = Order::where('shop_id', '=', $request->session()->get('shop'))->count(); $stats['revenue'] = Order::where('shop_id', '=', $request->session()->get('shop'))->sum('total'); return view('admin/dashboard', ['stats' => $stats]); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function getDataBlog() { $blog = Blog::where('user_id', Auth::user()->getId())->get(); $images = Auth::user()->getPhoto(); return view('backend.blog.index', ['images' => $images])->with('blog', $blog); }
public function getCategory() { $blog = Blog::where('category_id', Category::category()->getId())->get(); return view('beranda.category')->with('blog', $blog); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($society, $slug) { $data['soc'] = $society; $data['individual'] = Individual::where('slug', '=', $slug)->first(); if ($data['individual'] and $data['individual']->social) { $socials = explode(',', $data['individual']->social); foreach ($socials as $social) { if (strpos($social, 'twitter')) { $data['socials']['twitter'] = $social; } elseif (strpos($social, 'facebook')) { $data['socials']['facebook'] = $social; } elseif (strpos($social, 'instagram')) { $data['socials']['instagram'] = $social; } elseif (strpos($social, 'youtube')) { $data['socials']['youtube'] = $social; } } } if ($data['individual']) { $id = $data['individual']->id; if (count(Preacher::where('individual_id', '=', $id)->get()) > 0) { $data['preacher'] = Preacher::with(array('sermons' => function ($query) { $query->orderBy('created_at', 'DESC'); }))->where('individual_id', '=', $id)->first(); } elseif (count(Minister::with('sermons')->where('individual_id', '=', $id)->get()) > 0) { $data['preacher'] = Minister::where('individual_id', '=', $id)->first(); } $data['pagetitle'] = $data['individual']->firstname . " " . $data['individual']->surname; } else { $data['preacher'] = Guest::where('slug', '=', $slug)->first(); $data['pagetitle'] = $data['preacher']->firstname . " " . $data['preacher']->surname; $id = 0; } if (isset($data['preacher'])) { $sermons = $data['preacher']->sermons->lists('id')->all(); $data['sermons'] = Sermon::wherein('id', $sermons)->orderBy('servicedate', 'DESC')->paginate(5); } $data['blogs'] = Blog::where('individual_id', '=', $id)->orderBy('created_at', 'DESC')->limit(9)->get(); return View::make('individuals.show', $data); }
public function feed($society) { $feed = App::make("feed"); // cache the feed for 60 minutes (second parameter is optional) $feed->setCache(0, 'LowerTugelaCircuitFeed'); // check if there is cached feed and build new only if is not if (!$feed->isCached()) { $society = Society::where('society', '=', $society)->first(); // creating rss feed with our most recent 20 posts $blogs = Blog::where('created_at', '>', '2016-02-13')->orderBy('created_at', 'desc')->take(20)->get(); $sermons = Sermon::where('servicedate', '>', '2016-02-13')->orderBy('servicedate', 'desc')->orderBy('created_at', 'desc')->take(20)->get(); // set your feed's title, description, link, pubdate and language $feed->title = $society->society . ' Methodist Church'; $feed->description = 'Together, a transforming discipleship movement'; $feed->logo = 'http://church.net.za/public/images/logo.jpg'; $feed->link = url('feed'); $feed->setDateFormat('datetime'); // 'datetime', 'timestamp' or 'carbon' $feed->pubdate = date('d-m-Y'); $feed->lang = 'en'; $feed->setShortening(true); // true or false $feed->setTextLimit(120); // maximum length of description text $feeddata = array(); foreach ($blogs as $blog) { // set item's title, author, url, pubdate, description and content if ($blog->blogimage != "") { $imgurl = url($blog->blogimage); } elseif ($blog->individual->photo) { $imgurl = url($blog->individual->photo); } elseif ($society->logo) { $imgurl = url($society->logo); } else { $imgurl = "http://church.net.za/public/images/logo.jpg"; } $fulldescrip = strip_tags($blog->post); $dum['title'] = $blog->title; $dum['author'] = $imgurl; $dum['link'] = url('/blog#' . $blog->id); $dum['pubdate'] = $blog->created_at; $dum['summary'] = "A new blog post has been published on our site."; $dum['content'] = $fulldescrip; $feeddata[] = $dum; } foreach ($sermons as $sermon) { // set item's title, author, url, pubdate, description and content $seriesimage = url($sermon->series->seriesimage); if ($sermon->preachable_type == "App\\Models\\Guest") { $preacher = $sermon->preachable->firstname . " " . $sermon->preachable->surname; } else { $preacher = $sermon->preachable->individual->firstname . " " . ($preacher = $sermon->preachable->individual->surname); } $fulldescrip = "Recording of a sermon preached by " . $preacher . " at " . $society->society . ' Methodist Church on ' . date("l j F Y", strtotime($sermon->servicedate)) . '. Bible readings: ' . $sermon->readings; $dum['title'] = $sermon->sermon; $dum['author'] = $seriesimage; $dum['link'] = url('/sermons/' . $sermon->series->slug . '/' . $sermon->slug); $dum['pubdate'] = $sermon->servicedate . " 12:00:00"; $dum['summary'] = "A new sermon has been uploaded to our site."; $dum['content'] = $fulldescrip; $feeddata[] = $dum; } usort($feeddata, function ($a, $b) { return strcmp($b["pubdate"], $a["pubdate"]); }); } foreach ($feeddata as $fd) { $feed->add($fd['title'], $fd['author'], $fd['link'], $fd['pubdate'], $fd['summary'], $fd['content']); } return $feed->render('atom'); }