/** * Show the application dashboard to the user. * * @return Response */ public function index() { $articles = Article::with('author')->orderBy('position', 'DESC')->orderBy('created_at', 'DESC')->limit(4)->get(); // TODO: abstract to model $sliders = Photo::join('photo_albums', 'photo_albums.id', '=', 'photos.photo_album_id')->where('photos.slider', 1)->orderBy('photos.position', 'DESC')->orderBy('photos.created_at', 'DESC')->select('photos.filename', 'photos.name', 'photos.description', 'photo_albums.folder_id')->get(); $photoAlbums = PhotoAlbum::select(array('photo_albums.id', 'photo_albums.name', 'photo_albums.description', 'photo_albums.folder_id', DB::raw('(select filename from ' . DB::getTablePrefix() . 'photos WHERE album_cover=TRUE and ' . DB::getTablePrefix() . 'photos.photo_album_id=' . DB::getTablePrefix() . 'photo_albums.id LIMIT 1) AS album_image'), DB::raw('(select filename from ' . DB::getTablePrefix() . 'photos WHERE ' . DB::getTablePrefix() . 'photos.photo_album_id=' . DB::getTablePrefix() . 'photo_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); $videoAlbums = VideoAlbum::select(array('video_albums.id', 'video_albums.name', 'video_albums.description', 'video_albums.folder_id', DB::raw('(select youtube from ' . DB::getTablePrefix() . 'videos WHERE album_cover=TRUE and ' . DB::getTablePrefix() . 'videos.video_album_id=' . DB::getTablePrefix() . 'video_albums.id LIMIT 1) AS album_image'), DB::raw('(select youtube from ' . DB::getTablePrefix() . 'videos WHERE ' . DB::getTablePrefix() . 'videos.video_album_id=' . DB::getTablePrefix() . 'video_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); $categoriesArray = Object::where('type', 'category')->get(); $categories = array(); foreach ($categoriesArray as $category) { $categories[] = array($category->title); } $categories = Object::where('type', 'category')->get(); global $types; $types = Object::getTypes()->select(array('id', DB::raw("REPLACE(name, '_object_type_', '') as name"), DB::raw("REPLACE(title, 'Object Type: ', '') as title"), 'created_at'))->get(); return view('pages.home', compact('articles', 'sliders', 'videoAlbums', 'photoAlbums', 'categories', 'types')); //return view('pages.welcome'); }
/** * Show the application dashboard to the user. * * @return Response */ public function index() { $articles = Article::with('author')->orderBy('position', 'DESC')->orderBy('created_at', 'DESC')->limit(4)->get(); $photoAlbums = PhotoAlbum::select(array('photo_albums.id', 'photo_albums.name', 'photo_albums.description', 'photo_albums.folder_id', DB::raw('(select filename from photos WHERE album_cover=TRUE and photos.photo_album_id=photo_albums.id LIMIT 1) AS album_image'), DB::raw('(select filename from photos WHERE photos.photo_album_id=photo_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); $videoAlbums = VideoAlbum::select(array('video_albums.id', 'video_albums.name', 'video_albums.description', 'video_albums.folder_id', DB::raw('(select youtube from videos WHERE album_cover=TRUE and videos.video_album_id=video_albums.id LIMIT 1) AS album_image'), DB::raw('(select youtube from videos WHERE videos.video_album_id=video_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); return view('pages.home', compact('articles', 'videoAlbums', 'photoAlbums')); }
public function getArticolo($slug) { // dettaglio di un singolo articolo //$categories = \App\Category::all(); $article = \App\Article::with('categories', 'user')->where('slug', '=', $slug)->first(); return view('blog.article', compact('article')); }
/** * Get the query object to be processed by datatables. * * @return \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder */ public function query() { $articles = Article::with('category')->whereHas('category', function ($q) { $q->where('language_id', session('current_lang')->id); }); return $this->applyScopes($articles); }
public function index(Request $request) { $orderby = $request->orderby ? $request->orderby : 'created_at'; $articles = Article::with('user')->Orderby($orderby, 'DESC')->simplePaginate(10); // $articles = $this->articles->allWithNotActived(); return view('admin.articles.index', compact('articles', 'orderby')); }
public function index(Request $request) { $orderby = $request->orderby ? $request->orderby : 'created_at'; $title = $request->title ? $request->title : ''; $articles = Article::with('user')->whereTitle($title)->Orderby($orderby, 'DESC')->simplePaginate(10); return view('admin.articles.index', compact('articles', 'orderby', 'title')); }
public function get($id) { $article = Article::with('tags')->find($id); if (!$article) { return response()->json(null, 404); } return response()->json($article); }
protected function recent() { view()->composer('widgets.recent', function ($view) { $view->with('articles', Cache::remember('widgets_recent', 10, function () { return Article::with('tags', 'category')->public()->orderby('published_at', 'desc')->take(5)->get(); })); }); }
/** * Display a listing of the articles. * * @return Response */ public function index() { $page_size = env('num_per_page'); //take: set the limit of the query //get: Execute the query as a "select" statement. $articles = \App\Article::with('tags', 'category')->published()->orderBy('updated_at', 'desc')->take($page_size)->get(); return view('blog.index', compact('articles')); }
public function articleSearcher() { $modelsList = BrandModel::lists('name', 'id')->prepend('(all)', ''); $brandsList = Brand::lists('name', 'id')->prepend('(all)', ''); $partsList = PartType::lists('name', 'id')->prepend('(all)', ''); $articles = Article::with('articleType', 'brand', 'model', 'partType')->orderBy('name', 'asc')->get(); return view('backoffice.articles.ArticleSearcher')->with(compact('modelsList'))->with(compact('brandsList'))->with(compact('partsList'))->with(compact('articles')); }
/** * Returns a view of all articles in the system * * @return \Illuminate\View\View */ public function index() { $articles = array(); foreach (Article::with('user')->with('template')->get() as $article) { array_push($articles, $article); } //return $articles; return view('admin.articles.index', compact('articles')); }
/** * Display the specified resource. * * @param int $id * * @return Response */ public function show($slug) { //$articles = Tag::findBySlug($slug)->articles()->latest('articles.created_at')->paginate(8); $page_size = setting('page_size'); $tag = Tag::findBySlug($slug); $articles = \App\Article::with('tags', 'category')->whereHas('tags', function ($query) use($slug) { $query->whereSlug($slug); })->latest()->paginate($page_size); return view('home.tags.show', compact('articles', 'tag')); }
/** * Show the application dashboard to the user. * * @return Response */ public function index() { $articles = Article::with('author')->orderBy('position', 'DESC')->orderBy('created_at', 'DESC')->limit(4)->get(); // TODO: abstract to model $sliders = Photo::join('photo_albums', 'photo_albums.id', '=', 'photos.photo_album_id')->where('photos.slider', 1)->orderBy('photos.position', 'DESC')->orderBy('photos.created_at', 'DESC')->select('photos.filename', 'photos.name', 'photos.description', 'photo_albums.folder_id')->get(); $photoAlbums = PhotoAlbum::select(array('photo_albums.id', 'photo_albums.name', 'photo_albums.description', 'photo_albums.folder_id', DB::raw('(select filename from ' . DB::getTablePrefix() . 'photos WHERE album_cover=TRUE and ' . DB::getTablePrefix() . 'photos.photo_album_id=' . DB::getTablePrefix() . 'photo_albums.id LIMIT 1) AS album_image'), DB::raw('(select filename from ' . DB::getTablePrefix() . 'photos WHERE ' . DB::getTablePrefix() . 'photos.photo_album_id=' . DB::getTablePrefix() . 'photo_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); $videoAlbums = VideoAlbum::select(array('video_albums.id', 'video_albums.name', 'video_albums.description', 'video_albums.folder_id', DB::raw('(select youtube from ' . DB::getTablePrefix() . 'videos WHERE album_cover=TRUE and ' . DB::getTablePrefix() . 'videos.video_album_id=' . DB::getTablePrefix() . 'video_albums.id LIMIT 1) AS album_image'), DB::raw('(select youtube from ' . DB::getTablePrefix() . 'videos WHERE ' . DB::getTablePrefix() . 'videos.video_album_id=' . DB::getTablePrefix() . 'video_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); return view('pages.home', compact('articles', 'sliders', 'videoAlbums', 'photoAlbums')); //return view('pages.welcome'); }
public function index() { $article = Article::with('users')->limit(2)->orderBy('updated_at', 'desc')->get(); $app = Application::with('users')->paginate(6); $ArticleCategory = ArticleCategory::all(); $AppCategory = AppCategory::all(); $test = AppCategory::with('applications')->where('name', '=', 'communication')->get(); dd($test); return view('homepage.welcome', compact('article', 'app', 'ArticleCategory', 'AppCategory')); }
/** * Display a listing of the resource. * * @return Response */ public function share_index($page = '') { if (Input::get('class')) { $lifes = Article::with('cla')->orderBy('created_at', 'DESC')->where('classify', (int) Input::get('class'))->paginate(10)->setPath('share'); } else { $classify = Classify::where('pid', '=', '2')->lists('id'); $lifes = Article::with('cla')->orderBy('created_at', 'DESC')->whereIn('classify', $classify)->paginate(10)->setPath('share'); } return view('home.life')->withLifes($lifes); }
/** * Execute the console command. * * @return mixed */ public function handle() { // ------------------------------------------------------------------------------------------------------------ // GET HEADLINE // ------------------------------------------------------------------------------------------------------------ $headlines = \App\Headline::with('travel_agent')->activeOn(\Carbon\Carbon::now())->orderBy('priority')->get(); $headlines = $headlines->sortByDesc(function ($data) { return $data->travel_agent->active_packages[0]->priority; }); // ------------------------------------------------------------------------------------------------------------ // GET HOMEGRID // ------------------------------------------------------------------------------------------------------------ $homegrids = \App\HomegridSetting::orderby('name')->get(); // get upcoming package schedules $homegrid_destination_ids = new Collection(); foreach ($homegrids as $k => $v) { if (str_is('destination', $v->type)) { $homegrid_destination_ids->push($v->destination); } } if ($homegrid_destination_ids->count()) { $homegrid_destinations = \App\Destination::with('tours', 'tours.schedules')->whereIn('id', $homegrid_destination_ids)->get(); foreach ($homegrids as $k => $v) { $homegrids[$k]->destination_detail = $homegrid_destinations->find($v->destination); } } // ------------------------------------------------------------------------------------------------------------ // QUERY PAKET PROMO TERBARU // ------------------------------------------------------------------------------------------------------------ $tours = \App\Tour::with('destinations', 'schedules', 'destinations.images', 'places', 'places.images', 'travel_agent', 'travel_agent.images', 'images')->has('schedules')->select('tours.*')->join('travel_agencies', 'travel_agencies.id', '=', 'travel_agent_id')->published()->latest('tours.created_at')->limit(8)->groupBy('travel_agent_id')->get(); // ------------------------------------------------------------------------------------------------------------ // GET BLOG TERBARU // ------------------------------------------------------------------------------------------------------------ $articles = Article::with('images')->published()->latest('published_at')->take(6)->get(); // ------------------------------------------------------------------------------------------------------------ // GET USER // ------------------------------------------------------------------------------------------------------------ $total_subscriber = \App\Subscriber::active()->count(); $this->info(' ---------------------------------------------------------------------------------------------- '); $this->info(' BLAST NEWSLETTER '); $this->info(' ---------------------------------------------------------------------------------------------- '); $this->info(' * Sending Newsletter to ' . $total_subscriber . ' subscribers'); \App\Subscriber::with('user')->active()->orderby('id')->chunk(100, function ($subscribers) { foreach ($subscribers as $subscriber) { Mail::queue('web.v4.emails.newsletters.weekly', ['headlines' => $headlines, 'homegrids' => $homegrids, 'tours' => $tours, 'articles' => $articles, 'subscriber' => $subscriber], function ($m) use($subscriber) { $m->to($subscriber->email, $subscriber->user ? $subscriber->user->name : $subscriber->email)->subject('CAPCUS.id - Newsletter Edisi ' . \Carbon\Carbon::now()->year . '.' . \Carbon\Carbon::now()->format('W')); }); $this->info(' * Newsletter sent to ' . $subscriber->email . ' *'); } }); $this->info(' ---------------------------------------------------------------------------------------------- '); $this->info(' BLAST NEWSLETTER COMPLETED'); $this->info(' ---------------------------------------------------------------------------------------------- '); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($slug) { $page_size = env('num_per_page'); // $articles = Tag::findBySlug($slug)->articles()->latest()->paginate($page_size); $articles = \App\Article::with('tags', 'category')->published()->whereHas('tags', function ($query) use($slug) { $query->whereSlug($slug); })->latest()->paginate($page_size); $Tag = Tag::whereSlug($slug)->firstOrFail(); $Tagname = $Tag->name; return view('blog.tags.show', compact('articles', 'Tagname')); }
public function index() { $modele = Modeles::with('category', 'brand')->get(); $supp = Supplier::all(); $articles_modeles = Article::with('theModels.brand', 'theModels.category', 'supplier')->get(); $leftmenu['model'] = 'active'; $leftmenu['model_article'] = 'active'; if (isset($_GET['sel_modele'])) { $response = ['leftmenu' => $leftmenu, 'modeles' => $modele, 'article_modele' => $articles_modeles, 'suppliers' => $supp, 'selection' => $_GET['sel_modele']]; } else { $response = ['leftmenu' => $leftmenu, 'modeles' => $modele, 'article_modele' => $articles_modeles, 'suppliers' => $supp]; } return view('/articles/index', $response); }
public function show($slug) { $article = Article::with('tags')->where('slug', $slug)->first(); if (!$article) { abort(404); } else { if (\Request::method() == 'GET') { return view('front.post', ['article' => $article, 'tags' => $this->tags, 'setting' => $this->setting, 'links' => $this->links]); } else { //判断密码 $validator = \Validator::make(\Request::all(), ['password' => 'required|max:255'], [], ['password' => '密码']); //为错误信息添加id,防止前台多个密码区域显示错误 $validator->after(function ($validator) use($article) { if ($validator->errors()->has('password')) { $validator->errors()->add('id', $article->id); } }); if ($validator->fails()) { return redirect()->back()->withErrors($validator->errors()); } $password = \Request::get('password'); if (strstr($article->password, ',' . $password . ',') > -1) { $ip = \Request::getClientIp(); $passed = new Passed(); $passed->ip = $ip; $passed->article_id = $article->id; $passed->save(); \Session::set('passed_' . $article->id, true); return redirect()->action('IndexController@show', $article->slug); } else { $validator->errors()->add('password', '密码不匹配!'); $validator->errors()->add('id', $article->id); return redirect()->back()->withErrors($validator->errors()); } } } }
/** * Display the specified resource. * * @param string $slug * @return Response */ public function show($slug) { return view('articles.show', ['article' => Article::with('tags', 'category')->where('slug', $slug)->firstOrFail()]); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $articles = Article::with('tags')->latest()->paginate(10); return view('goenitz.article.index', ['articles' => $articles]); }
/** * Remove the specified resource from storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response * @throws \Exception */ public function destroy(Request $request, $id) { $article = Article::with('attachments', 'comments')->findOrFail($id); foreach ($article->attachments as $attachment) { \File::delete(attachment_path($attachment->name)); } $article->attachments()->delete(); $article->comments->each(function ($comment) { app(\App\Http\Controllers\CommentsController::class)->recursiveDestroy($comment); }); $article->delete(); event(new ModelChanged('articles')); if ($request->ajax()) { return response()->json('', 204); } flash()->success(trans('forum.deleted')); return redirect(route('articles.index')); }
public function forUser($user_id) { return Article::with('user')->where('user_id', $user_id)->latest()->simplePaginate(10); }
/** * @param $categoryId * @param int $limit * @return mixed */ public function articlesForCategory($categoryId, $limit = 3) { $query = Article::with('images', 'categories')->category($categoryId)->latestPublished()->{$this->scope}(); return $query->paginate($limit); }
public function showArticle($articleid) { $article = Article::with('pictures')->findOrFail($articleid); return view('online_shop.Article.item')->with(compact('article')); }
public function getDownloadPDF() { $limit = \Input::get('limit') ?: 7; $articles = Article::with('user')->paginate($limit); $pdf = PDF::loadView('articles', compact('articles')); //$pdf = PDF::loadHTML('<h1>Test</h1>'); //dd($pdf); return $pdf->download('download.pdf'); }
public function show($year, $month, $slug) { // ------------------------------------------------------------------------------------------------------------ // QUERY ARTICLE DETAIL // ------------------------------------------------------------------------------------------------------------ $article = Cache::remember('blog_with_slug_' . $slug, 30, function () use($slug) { return Article::with('images', 'destinations')->slugIs($slug)->published()->first(); }); if (!$article || $article->published_at->year != $year * 1 || $article->published_at->month != $month * 1) { return App::abort(404); } // ------------------------------------------------------------------------------------------------------------ // QUERY RELATED ARTICLES // ------------------------------------------------------------------------------------------------------------ $destinations = $article->destinations; $related_articles = Cache::remember('related_article_by_slug' . $slug, 30, function () use($article, $destinations) { $related_articles = Article::InDestinationByIds($destinations->lists('id')->toArray())->where('id', '!=', $article->id)->published()->latest('published_at')->limit(6)->get(); if (!$related_articles->count()) { $related_articles = Article::latest('published_at')->where('id', '!=', $article->id)->limit(6)->get(); } return $related_articles; }); // ------------------------------------------------------------------------------------------------------------ // QUERY RELATED TOUR // ------------------------------------------------------------------------------------------------------------ // $tours = Tour::scheduledBetween(\Carbon\Carbon::now(), \Carbon\Carbon::now()->addYear(1)) // ->latest('published_at') // ->take(5) // ->get(); // ------------------------------------------------------------------------------------------------------------ // SHOW DISPLAY // ------------------------------------------------------------------------------------------------------------ $this->layout->page = view($this->page_base_dir . 'blog_detail'); $this->layout->page->article = $article; $this->layout->page->related_articles = $related_articles; $this->layout->page->latest_tours = $this->get_latest_tours(); $this->layout->page->top_destinations = $this->get_top_destinations(); $this->layout->title = $article->title . ' - Capcus.id'; $this->layout->og['title'] = $this->layout->title; $this->layout->og['type'] = 'article'; $this->layout->og['image'] = $article->images->where('name', 'LargeImage')->first()->path; $this->layout->og['image:type'] = pathinfo('images/' . $this->layout->og['image'], PATHINFO_EXTENSION); $this->layout->og['image:width'] = 600; $this->layout->og['image:height'] = 400; $this->layout->og['article:published_at'] = $article->published_at->format('Y-m-d H:i:s'); return $this->layout; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $articles = Article::with(['user', 'category', 'comments', 'views', 'stars']); $sort = Request::get('sort'); if ($sort == 'most-commented') { $articles = $articles->mostCommented(); } elseif ($sort == 'most-viewed') { $articles = $articles->mostViewed(); } elseif ($sort == 'most-starred') { $articles = $articles->mostStarred(); } else { $sort = ''; $articles = $articles->recent(); } if ($category_id = Request::get('cat')) { $articles->filterBy(['category_id' => $category_id]); } $articles = $articles->paginate(Config::get('frontend.articles_per_page')); return view('articles.index', compact('articles')); }
public function index($slug) { $category = Category::where('slug', $slug)->firstOrFail(); $articles = Article::with('tags', 'category')->where('category_id', $category->id)->public()->latest('published_at')->simplePaginate(setting_value('paginate_size')); return view('categories', ['category' => $category, 'articles' => $articles]); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($slug) { $page_size = env('num_per_page'); // //method I. num of queries: 17. // $articles = Category::findBySlug($slug)->articles()->latest()->paginate($page_size); //method II: eager loading. num of queries 5 //http://php.net/manual/en/functions.anonymous.php "use" to inherit variables from its parent scope //whereSlug($slug) equals to where('slug', '=', $slug). $articles = \App\Article::with('tags', 'category')->published()->whereHas('category', function ($query) use($slug) { $query->whereSlug($slug); })->latest()->paginate($page_size); $Catname = Category::whereSlug($slug)->firstOrFail()->name; return view('blog.cats.show', compact('articles', 'Catname')); }