/** * Execute the job. * * @return void */ public function handle() { $posts = Posts::active()->get(); $fh = fopen(public_path(Conf::get('sitemap.filename', 'sitemap.xml', false)), 'w'); fwrite($fh, view('files.sitemap', compact('posts'))->render()); fclose($fh); }
public function index() { view()->share('menu_item_active', 'index'); Title::prepend('Dashboard'); $data = ['title' => Title::renderr(' : ', true), 'posts_total' => Posts::count(), 'posts_active' => Posts::where('status', 'active')->count(), 'posts_draft' => Posts::where('status', 'draft')->count(), 'posts_moderation' => Posts::where('status', 'moderation')->count(), 'users_total' => Users::count(), 'users_active' => Users::where('active', '1')->count(), 'users_inactive' => Users::where('active', '0')->count(), 'latest_posts' => Posts::active()->orderBy('published_at', 'desc')->limit(5)->get(), 'popular_posts' => Posts::active()->orderBy('views', 'desc')->limit(5)->get()]; return view('root.dashboard.index', $data); }
public function compose(View $view) { $categories = \App\Models\Categories::i()->withPostsCount(); $posts_count = \App\Models\Posts::active()->count(); $view->with('categories', $categories); $view->with('posts_count', $posts_count); }