Ekapp/skolehjem/app/Http/Controllers/NewsController.php

<?php

namespace App\Http\Controllers;

use App\Event;
use App\Helpers;
use App\News;
use App\User;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Http\RedirectResponse;
use Illuminate\Http\Request;
use Illuminate\Http\Response;

date_default_timezone_set('Europe/Copenhagen');

class NewsController extends Controller
{
    public function __construct()
    {
        $this->middleware([ "auth" ]);
        $this->middleware([ "lang" ]);

        $this->middleware([ "check.auth:news.show" ])->only("show", "index");
        $this->middleware([ "check.auth:news.create" ])->only("create", "store");
        $this->middleware([ "check.auth:news.edit" ])->only("edit", "update");
        $this->middleware([ "check.auth:news.delete" ])->only("delete");
    }

    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        //joining news and news_types
        $news = News::query()
            ->join("news_types", "news.type_id", "=", "news_types.id")
            ->orderBy('id', 'desc')
            ->select('news.*', 'news_types.type')
            ->get();
        return Response::detect("news.index", [ "news" => $news ]);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return Response::detect("news.create");
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return RedirectResponse
     */
    public function store(Request $request)
    {
        $data = $request->validate([
            "subname" => "required",
            "content" => "required",
            "news_expiration_date" => ""
        ]);

        $news = new News($data);
        $news->name = "";
        $news->type_id = '1';
        $news->save();

        Helpers::sendNewsNotification($news, User::query()->where("wants_emails", "=", true)->get());
        PushNotificationController::push();
        return redirect()->route("news.index");
    }

    /**
     * Store a newly created resource in storage.
     *
     * @return News
     */
    public static function storeAndGet(News $news)
    {
        $OldNews = News::query()->where('arrangement_id', "=", $news->arrangement_id)->where('type_id', '=', $news->type_id);

        $OldNews->delete();

        $news->save();

        Helpers::sendNewsNotification($news, User::query()->where("wants_emails", "=", true)->get());
        PushNotificationController::push();
        return $news;
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\News  $news
     * @return \Illuminate\Http\Response
     */
    public function show(News $news)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\News  $news
     * @return \Illuminate\Http\Response
     */
    public function edit(News $news)
    {
        return Response::detect("news.edit", [ "news" => $news ]);
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\News  $news
     * @return RedirectResponse
     */
    public function update(Request $request, News $news)
    {
        $data = $request->validate([
            "subname" => "required",
            "content" => "required",
            "news_expiration_date" => ""
        ]);

        $news->update($data);

        Helpers::sendNewsNotification($news, User::query()->where("wants_emails", "=", true)->get());

        return redirect()->route("news.index");
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\News  $news
     * @return RedirectResponse
     */
    public static function updateAndGet(News $news)
    {
        $news->update();

        Helpers::sendNewsNotification($news, User::query()->where("wants_emails", "=", true)->get());

        return $news;
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param \App\News $news
     * @return RedirectResponse
     * @throws \Exception
     */
    public function destroy(News $news)
    {
        $news->delete();
        return redirect()->route("news.index");
    }

    public function nameCheck(Request $request){
        $news = News::query()->where('subname', 'LIKE',$request->nameCheck)->get();
        if(count($news) > 0 && $request->nameCheck !== NULL){
            return 1;
        }
    }

    public function nameCheckUpdate(Request $request){
        $news = News::query()->where('subname', 'LIKE',$request->nameCheck)->where('id', '!=', $request->id)->get();
        if(count($news) > 0 && $request->nameCheck !== NULL){
            return 1;
        }
    }


    public function previewPages(Request $request){
        $event = News::find($request->preview);
        $convertToJsonArray = json_encode($event);
        return $convertToJsonArray;
    }

}