davide-casiraghi/ci-global-calendar

<?php

namespace App\Http\Controllers;

use App\Post;
use DavideCasiraghi\LaravelEventsCalendar\Models\Event;
use DavideCasiraghi\LaravelEventsCalendar\Models\Teacher;
use DavideCasiraghi\LaravelQuickMenus\Models\MenuItem;
use Illuminate\Support\Facades\DB;

/**
 *    Created using this tutorial: https://laravel-news.com/laravel-sitemap.
 **/
class SitemapController extends Controller
{
    /***************************************************************************/

    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        /*$post = Post::orderBy('updated_at', 'desc')->first();
        $event = Event::orderBy('updated_at', 'desc')->first();
        $teacher = Teacher::orderBy('updated_at', 'desc')->first();*/

        $menuItems = MenuItem::where('access', 1)->get();

        return response()->view('sitemap.index', [
            'menuItems' => $menuItems,
        ])->header('Content-Type', 'text/xml');
    }

    /***************************************************************************/

    /**
     * Generate the posts XML sitemap.
     *
     * @return \Illuminate\Http\Response
     */
    public function posts()
    {
        //$posts = Post::where('category_id', 6)->get();

        $posts = DB::table('posts')
                       ->join('post_translations', 'posts.id', '=', 'post_translations.post_id')
                       ->select('posts.*', 'post_translations.locale', 'post_translations.slug')->get();

        //dd($posts);
        return response()->view('sitemap.posts', [
            'posts' => $posts,
        ])->header('Content-Type', 'text/xml');
    }

    /***************************************************************************/

    /**
     * Generate the events XML sitemap
     * every event show the link to the closest repetition related to today.
     *
     * @return \Illuminate\Http\Response
     */
    public function events()
    {
        // Retrieve all the active events
        $filters = [];
        $filters['keywords'] = $filters['category'] = $filters['country'] = $filters['region'] = $filters['city'] = $filters['continent'] = $filters['teacher'] = $filters['venue'] = $filters['startDate'] = $filters['endDate'] = null;
        $activeEvents = Event::getEvents($filters, 10000);

        return response()->view('sitemap.events', [
            'events' => $activeEvents,
        ])->header('Content-Type', 'text/xml');
    }

    /***************************************************************************/

    /**
     * Generate the teachers XML sitemap.
     *
     * @return \Illuminate\Http\Response
     */
    public function teachers()
    {
        $teachers = Teacher::orderBy('updated_at', 'desc')->get();

        return response()->view('sitemap.teachers', [
            'teachers' => $teachers,
        ])->header('Content-Type', 'text/xml');
    }

    /***************************************************************************/

    /**
     * Display the specified resource.
     *
     * @return \Illuminate\View\View
     */
    public function show()
    {
        $sitemap = $this->generateSitemapXML();

        return view('sitemap.show', ['sitemap' => $sitemap]);
    }

    /***************************************************************************/
}