ResourceController::show() - Code Metrics - rygos/rmarchiv - Measure and Improve Code Quality continuously with Scrutinizer

ResourceController::show() B
last analyzed 2018-05-01 08:16 UTC

↳ Parent: ResourceController
Complexity

Conditions	1
Paths	1
Size

Total Lines	42
Code Lines	35
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
c	0
b	0
f	0
dl	0
loc	42
rs	8.8571
cc	1
eloc	35
nc	1
nop	3
<?php

/*
 * rmarchiv.tk
 * (c) 2016-2017 by Marcel 'ryg' Hering
 */

namespace App\Http\Controllers;

use App\Models\Resource;
use Carbon\Carbon;
use App\Events\Obyx;
use Illuminate\Http\Request;
use App\Helpers\DatabaseHelper;

class ResourceController extends Controller
{
    public function index()
    {
        $res = \DB::table('resources')
            ->leftJoin('users', 'users.id', '=', 'resources.user_id')
            ->leftJoin('comments', function ($join) {
                $join->on('comments.content_id', '=', 'resources.id');
                $join->on('comments.content_type', '=', \DB::raw("'resource'"));
            })
            ->select([
                'resources.id as resid',
                'resources.type as restype',
                'resources.cat as rescat',
                'resources.user_id as userid',
                'users.name as username',
                'resources.title as restitle',
                'resources.created_at as rescreatedat',
                'resources.content_type as contenttype',
            ])
            ->selectRaw('COUNT(comments.id) AS commentcount')
            ->selectRaw('SUM(comments.vote_up) AS voteup')
            ->selectRaw('SUM(comments.vote_down) AS votedown')
            ->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
            ->groupBy('resources.id')
            ->orderBy('resources.created_at', 'desc')
            ->limit(20)
            ->get();

        return view('resources.index', [
            'resources'   => $res,
            'commentsmax' => DatabaseHelper::getCommentsMax('resource'),
        ]);
    }

    public function index_gfx()

    {
        $res = \DB::table('resources')
            ->leftJoin('users', 'users.id', '=', 'resources.user_id')
            ->leftJoin('comments', function ($join) {
                $join->on('comments.content_id', '=', 'resources.id');
                $join->on('comments.content_type', '=', \DB::raw("'resource'"));
            })
            ->select([
                'resources.id as resid',
                'resources.type as restype',
                'resources.cat as rescat',
                'resources.user_id as userid',
                'users.name as username',
                'resources.title as restitle',
                'resources.created_at as rescreatedat',
                'resources.content_type as contenttype',
            ])
            ->selectRaw('COUNT(comments.id) AS commentcount')
            ->selectRaw('SUM(comments.vote_up) AS voteup')
            ->selectRaw('SUM(comments.vote_down) AS votedown')
            ->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
            ->where('resources.type', '=', 'gfx')
            ->groupBy('resources.id')
            ->orderBy('resources.created_at', 'desc')
            ->limit(20)
            ->get();

        return view('resources.gfx.index', [
            'resources'   => $res,
            'commentsmax' => DatabaseHelper::getCommentsMax('resource'),
        ]);
    }

    public function index_sfx()

    {
        $res = \DB::table('resources')
            ->leftJoin('users', 'users.id', '=', 'resources.user_id')
            ->leftJoin('comments', function ($join) {
                $join->on('comments.content_id', '=', 'resources.id');
                $join->on('comments.content_type', '=', \DB::raw("'resource'"));
            })
            ->select([
                'resources.id as resid',
                'resources.type as restype',
                'resources.cat as rescat',
                'resources.user_id as userid',
                'users.name as username',
                'resources.title as restitle',
                'resources.created_at as rescreatedat',
                'resources.content_type as contenttype',
            ])
            ->selectRaw('COUNT(comments.id) AS commentcount')
            ->selectRaw('SUM(comments.vote_up) AS voteup')
            ->selectRaw('SUM(comments.vote_down) AS votedown')
            ->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
            ->where('resources.type', '=', 'sfx')
            ->groupBy('resources.id')
            ->orderBy('resources.created_at', 'desc')
            ->limit(20)
            ->get();

        return view('resources.sfx.index', [
            'resources'   => $res,
            'commentsmax' => DatabaseHelper::getCommentsMax('resource'),
        ]);
    }

    public function index_scripts()

    {
        $res = \DB::table('resources')
            ->leftJoin('users', 'users.id', '=', 'resources.user_id')
            ->leftJoin('comments', function ($join) {
                $join->on('comments.content_id', '=', 'resources.id');
                $join->on('comments.content_type', '=', \DB::raw("'resource'"));
            })
            ->select([
                'resources.id as resid',
                'resources.type as restype',
                'resources.cat as rescat',
                'resources.user_id as userid',
                'users.name as username',
                'resources.title as restitle',
                'resources.created_at as rescreatedat',
                'resources.content_type as contenttype',
            ])
            ->selectRaw('COUNT(comments.id) AS commentcount')
            ->selectRaw('SUM(comments.vote_up) AS voteup')
            ->selectRaw('SUM(comments.vote_down) AS votedown')
            ->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
            ->where('resources.type', '=', 'scripts')
            ->groupBy('resources.id')
            ->orderBy('resources.created_at', 'desc')
            ->limit(20)
            ->get();

        return view('resources.scripts.index', [
            'resources'   => $res,
            'commentsmax' => DatabaseHelper::getCommentsMax('resource'),
        ]);
    }

    public function index_tools()

    {
        $res = \DB::table('resources')
            ->leftJoin('users', 'users.id', '=', 'resources.user_id')
            ->leftJoin('comments', function ($join) {
                $join->on('comments.content_id', '=', 'resources.id');
                $join->on('comments.content_type', '=', \DB::raw("'resource'"));
            })
            ->select([
                'resources.id as resid',
                'resources.type as restype',
                'resources.cat as rescat',
                'resources.user_id as userid',
                'users.name as username',
                'resources.title as restitle',
                'resources.created_at as rescreatedat',
                'resources.content_type as contenttype',
            ])
            ->selectRaw('COUNT(comments.id) AS commentcount')
            ->selectRaw('SUM(comments.vote_up) AS voteup')
            ->selectRaw('SUM(comments.vote_down) AS votedown')
            ->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
            ->where('resources.type', '=', 'tools')
            ->groupBy('resources.id')
            ->orderBy('resources.created_at', 'desc')
            ->limit(20)
            ->get();

        return view('resources.tools.index', [
            'resources'   => $res,
            'commentsmax' => DatabaseHelper::getCommentsMax('resource'),
        ]);
    }

    public function index_gfx_cat($cat)

    {
        $res = \DB::table('resources')
            ->leftJoin('users', 'users.id', '=', 'resources.user_id')
            ->leftJoin('comments', function ($join) {
                $join->on('comments.content_id', '=', 'resources.id');
                $join->on('comments.content_type', '=', \DB::raw("'resource'"));
            })
            ->select([
                'resources.id as resid',
                'resources.type as restype',
                'resources.cat as rescat',
                'resources.user_id as userid',
                'users.name as username',
                'resources.title as restitle',
                'resources.created_at as rescreatedat',
                'resources.content_type as contenttype',
            ])
            ->selectRaw('COUNT(comments.id) AS commentcount')
            ->selectRaw('SUM(comments.vote_up) AS voteup')
            ->selectRaw('SUM(comments.vote_down) AS votedown')
            ->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
            ->where('resources.type', '=', 'gfx')
            ->where('resources.cat', '=', $cat)
            ->groupBy('resources.id')
            ->orderBy('resources.created_at', 'desc')
            ->get();

        return view('resources.gfx.index_cat', [
            'resources'   => $res,
            'commentsmax' => DatabaseHelper::getCommentsMax('resource'),
        ]);
    }

    public function index_sfx_cat($cat)

    {
        $res = \DB::table('resources')
            ->leftJoin('users', 'users.id', '=', 'resources.user_id')
            ->leftJoin('comments', function ($join) {
                $join->on('comments.content_id', '=', 'resources.id');
                $join->on('comments.content_type', '=', \DB::raw("'resource'"));
            })
            ->select([
                'resources.id as resid',
                'resources.type as restype',
                'resources.cat as rescat',
                'resources.user_id as userid',
                'users.name as username',
                'resources.title as restitle',
                'resources.created_at as rescreatedat',
                'resources.content_type as contenttype',
            ])
            ->selectRaw('COUNT(comments.id) AS commentcount')
            ->selectRaw('SUM(comments.vote_up) AS voteup')
            ->selectRaw('SUM(comments.vote_down) AS votedown')
            ->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
            ->where('resources.type', '=', 'sfx')
            ->where('resources.cat', '=', $cat)
            ->groupBy('resources.id')
            ->orderBy('resources.created_at', 'desc')
            ->get();

        return view('resources.sfx.index_cat', [
            'resources'   => $res,
            'commentsmax' => DatabaseHelper::getCommentsMax('resource'),
        ]);
    }

    public function index_scripts_cat($cat)

    {
        $res = \DB::table('resources')
            ->leftJoin('users', 'users.id', '=', 'resources.user_id')
            ->leftJoin('comments', function ($join) {
                $join->on('comments.content_id', '=', 'resources.id');
                $join->on('comments.content_type', '=', \DB::raw("'resource'"));
            })
            ->select([
                'resources.id as resid',
                'resources.type as restype',
                'resources.cat as rescat',
                'resources.user_id as userid',
                'users.name as username',
                'resources.title as restitle',
                'resources.created_at as rescreatedat',
                'resources.content_type as contenttype',
            ])
            ->selectRaw('COUNT(comments.id) AS commentcount')
            ->selectRaw('SUM(comments.vote_up) AS voteup')
            ->selectRaw('SUM(comments.vote_down) AS votedown')
            ->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
            ->where('resources.type', '=', 'scripts')
            ->where('resources.cat', '=', $cat)
            ->groupBy('resources.id')
            ->orderBy('resources.created_at', 'desc')
            ->get();

        return view('resources.scripts.index_cat', [
            'resources'   => $res,
            'commentsmax' => DatabaseHelper::getCommentsMax('resource'),
        ]);
    }

    public function index_tools_cat($cat)

    {
        $res = \DB::table('resources')
            ->leftJoin('users', 'users.id', '=', 'resources.user_id')
            ->leftJoin('comments', function ($join) {
                $join->on('comments.content_id', '=', 'resources.id');
                $join->on('comments.content_type', '=', \DB::raw("'resource'"));
            })
            ->select([
                'resources.id as resid',
                'resources.type as restype',
                'resources.cat as rescat',
                'resources.user_id as userid',
                'users.name as username',
                'resources.title as restitle',
                'resources.created_at as rescreatedat',
                'resources.content_type as contenttype',
            ])
            ->selectRaw('COUNT(comments.id) AS commentcount')
            ->selectRaw('SUM(comments.vote_up) AS voteup')
            ->selectRaw('SUM(comments.vote_down) AS votedown')
            ->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
            ->where('resources.type', '=', 'tools')
            ->where('resources.cat', '=', $cat)
            ->groupBy('resources.id')
            ->orderBy('resources.created_at', 'desc')
            ->get();

        return view('resources.tools.index_cat', [
            'resources'   => $res,
            'commentsmax' => DatabaseHelper::getCommentsMax('resource'),
        ]);
    }

    public function show($type, $cat, $id)
    {
        $resource = \DB::table('resources')
            ->leftJoin('users', 'resources.user_id', '=', 'users.id')
            ->leftJoin('comments', function ($join) {
                $join->on('comments.content_id', '=', 'resources.id');
                $join->on('comments.content_type', '=', \DB::raw("'resource'"));
            })
            ->select([
                'resources.id as id',
                'resources.type as type',
                'resources.cat as cat',
                'resources.title as title',
                'resources.desc_html as desc_html',
                'resources.created_at as created_at',
                'resources.content_type as content_type',
                'resources.content_path as content_path',
                'users.name as username',
                'users.id as userid',
            ])
            ->selectRaw('COUNT(comments.id) AS commentcount')
            ->selectRaw('SUM(comments.vote_up) AS voteup')
            ->selectRaw('SUM(comments.vote_down) AS votedown')
            ->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
            ->where('resources.id', '=', $id)
            ->where('resources.cat', '=', $cat)
            ->where('resources.type', '=', $type)
            ->first();

        $comments = \DB::table('comments')
            ->leftJoin('users', 'comments.user_id', '=', 'users.id')
            ->select(['comments.id', 'comments.user_id', 'comments.comment_html', 'comments.created_at', 'users.name',
                'comments.vote_up', 'comments.vote_down', ])
            ->where('content_type', '=', \DB::raw("'resource'"))
            ->where('content_id', '=', $id)
            ->orderBy('created_at', 'asc')->get();

        return view('resources.show', [
            'resource' => $resource,
            'comments' => $comments,
        ]);
    }

    public function create()
    {
        return view('resources.create');
    }

    public function create_steps(Request $request)
    {
        return view('resources.create', [
            'request' => $request,
        ]);
    }

    public function store(Request $request)
    {
        $this->validate($request, [
            'step'         => 'required',
            'type'         => 'required|not_in:0',
            'cat'          => 'required|not_in:0',
            'title'        => 'required',
            'desc'         => 'required',
            'content_type' => 'required',
        ]);

        if ($request->get('content_type') == 'url') {
            if (filter_var($request->get('url'), FILTER_VALIDATE_URL)) {
                $content_path = $request->get('url');
            } else {
                return back()->withInput();
            }
        } else {
            $storagetemp = 'temp/'.$request->get('uuid').'/file';
            $storagedest = 'resources/'.$request->get('uuid').'.'.$request->get('ext');

            $exists = \Storage::disk('local')->exists($storagetemp);
            if ($exists === true) {
                \Storage::move($storagetemp, $storagedest);
            } else {
                return back()->withInput();
            }

            $content_path = $storagedest;
        }

        $res = new Resource();
$a = "a";
$ab = "ab";
$abc = "abc";
        $res->type = $request->get('type');
$a = "a";
$ab = "ab";
$abc = "abc";
        $res->cat = $request->get('cat');
$a = "a";
$ab = "ab";
$abc = "abc";
        $res->user_id = \Auth::id();
$a = "a";
$ab = "ab";
$abc = "abc";
        $res->title = $request->get('title');
$a = "a";
$ab = "ab";
$abc = "abc";
        $res->desc_md = $request->get('msg');
$a = "a";
$ab = "ab";
$abc = "abc";
        $res->desc_html = \Markdown::convertToHtml($request->get('msg'));
$a = "a";
$ab = "ab";
$abc = "abc";
        $res->content_path = $content_path;
        $res->content_type = $request->get('content_type');
        $res->save();

        event(new Obyx('resource-add', \Auth::id()));

        return redirect()->route('resources');
    }
}

1			<?php
2
3			/*
4			* rmarchiv.tk
5			* (c) 2016-2017 by Marcel 'ryg' Hering
6			*/
7
8			namespace App\Http\Controllers;
9
10			use App\Models\Resource;
11			use Carbon\Carbon;
12			use App\Events\Obyx;
13			use Illuminate\Http\Request;
14			use App\Helpers\DatabaseHelper;
15
16			class ResourceController extends Controller
17			{
18			public function index()
19			{
20			$res = \DB::table('resources')
21			->leftJoin('users', 'users.id', '=', 'resources.user_id')
22			->leftJoin('comments', function ($join) {
23			$join->on('comments.content_id', '=', 'resources.id');
24			$join->on('comments.content_type', '=', \DB::raw("'resource'"));
25			})
26			->select([
27			'resources.id as resid',
28			'resources.type as restype',
29			'resources.cat as rescat',
30			'resources.user_id as userid',
31			'users.name as username',
32			'resources.title as restitle',
33			'resources.created_at as rescreatedat',
34			'resources.content_type as contenttype',
35			])
36			->selectRaw('COUNT(comments.id) AS commentcount')
37			->selectRaw('SUM(comments.vote_up) AS voteup')
38			->selectRaw('SUM(comments.vote_down) AS votedown')
39			->selectRaw('(SUM(comments.vote_up) - SUM(comments.vote_down) / (SUM(comments.vote_up) + SUM(comments.vote_down))) AS voteavg ')
40			->groupBy('resources.id')
rygos / rmarchiv

ResourceController::show() B last analyzed 2018-05-01 08:16 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

ResourceController::show() B
last analyzed 2018-05-01 08:16 UTC
