MAINHACK

Viewing / Editing File: NoteController.php

<?php

namespace App\Http\Controllers;

use App\Models\Note;
use App\Models\User;
use App\Models\Utility;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;

class NoteController extends Controller
{

public function index($slug)
    {
        $currentWorkspace = Utility::getWorkspaceBySlug($slug);
        $personal_notes = Note::where('type', '=', 'personal')->where('workspace', '=', $currentWorkspace->id)->where('created_by', '=', Auth::user()->id)->get();
        $shared_notes = Note::where('type', '=', 'shared')->where('workspace', '=', $currentWorkspace->id)
            ->whereRaw("find_in_set('" . Auth::user()->id . "',notes.assign_to)")
            ->get();

return view('notes.index', compact('currentWorkspace', 'personal_notes', 'shared_notes'));
    }

public function create($slug)
    {
        $currentWorkspace = Utility::getWorkspaceBySlug($slug);
        if ($currentWorkspace) {
            $users = User::select('users.*', 'user_workspaces.permission', 'user_workspaces.is_active')
                ->join('user_workspaces', 'user_workspaces.user_id', '=', 'users.id')
                ->where('user_workspaces.workspace_id', '=', $currentWorkspace->id)
                ->where('users.id', '!=', Auth::user()->id)
                ->get();
        } else {
            $users = User::where('type', '!=', 'admin')->get();
        }

return view('notes.create', compact('currentWorkspace', 'users'));
    }

/**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store($slug, Request $request)
    {
        $request->validate([
            'title' => 'required',
            'text' => 'required',
            'color' => 'required',
        ]);
        $currentWorkspace = Utility::getWorkspaceBySlug($slug);
        $objUser = Auth::user();
        $post = $request->all();
        $post['type'] = $request->type;

$assign_to = $request->assign_to;
        $assign_to[] = Auth::user()->id;
        $post['assign_to'] = implode(',', $assign_to);
        $post['workspace'] = $currentWorkspace->id;
        $post['created_by'] = $objUser->id;
        Note::create($post);
        return redirect()->route('notes.index', $currentWorkspace->slug)->with('success', __('Note Created Successfully!'));
    }

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

/**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Note  $note
     * @return \Illuminate\Http\Response
     */
    public function edit($slug, $noteID)
    {
        $currentWorkspace = Utility::getWorkspaceBySlug($slug);
        $note = Note::where('workspace', '=', $currentWorkspace->id)->where('created_by', '=', Auth::user()->id)->where('id', '=', $noteID)->first();

if ($note) {

$note->assign_to = explode(',', $note->assign_to);

if ($currentWorkspace) {
                $users = User::select('users.*', 'user_workspaces.permission', 'user_workspaces.is_active')
                    ->join('user_workspaces', 'user_workspaces.user_id', '=', 'users.id')
                    ->where('user_workspaces.workspace_id', '=', $currentWorkspace->id)
                    ->where('users.id', '!=', Auth::user()->id)
                    ->get();
            } else {
                $users = User::where('type', '!=', 'admin')->get();
            }

return view('notes.edit', compact('currentWorkspace', 'note', 'users'));

} else {

return redirect()->back()->with('error', __('Note Not Found.'));

}

/**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Note  $note
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $slug, $noteID)
    {
        $request->validate([
            'title' => 'required',
            'text' => 'required',
            'color' => 'required',
        ]);
        $objUser = Auth::user();
        $currentWorkspace = Utility::getWorkspaceBySlug($slug);
        $notes = Note::where('workspace', '=', $currentWorkspace->id)->where('created_by', '=', Auth::user()->id)->where('id', '=', $noteID)->first();

$post = $request->all();
        $post['type'] = $request->type;

$assign_to = $request->assign_to;
        $assign_to[] = Auth::user()->id;
        $post['assign_to'] = implode(',', $assign_to);

$notes->update($post);
        return redirect()->route('notes.index', $slug)->with('success', __('Note Updated Successfully!'));
    }

/**
     * Remove the specified resource from storage.
     *
     * @param  \App\Note  $note
     * @return \Illuminate\Http\Response
     */
    public function destroy($slug, $noteID)
    {
        $objUser = Auth::user();
        $note = Note::find($noteID);
        if ($note->created_by == $objUser->id) {
            $note->delete();
            return redirect()->route('notes.index', $slug)->with('success', __('Note Deleted Successfully!'));
        } else {
            return redirect()->route('notes.index', $slug)->with('error', __("You can't delete Note!"));
        }
    }
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: NoteController.php

Server Info

System Features

User Info