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

GameController::index() A
last analyzed 2018-05-01 08:16 UTC

↳ Parent: GameController

Complexity

Conditions	3
Paths	4

Size

Total Lines	19
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	19
rs	9.4285
c	0
b	0
f	0
cc	3
eloc	13
nc	4
nop	2

<?php

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

namespace App\Http\Controllers;

use Carbon\Carbon;
use App\Events\Obyx;
use App\Models\Game;
use App\Models\Comment;
use App\Models\License;
use App\Events\GameView;
use App\Models\Language;
use App\Models\GamesFile;
use App\Models\Screenshot;
use App\Models\TagRelation;
use Illuminate\Http\Request;
use App\Models\GamesDeveloper;
use App\Helpers\DatabaseHelper;
use Illuminate\Support\Facades\Input;

class GameController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response

     */
    public function index($orderby = 'title', $direction = 'asc')
    {
        $rows = (\Auth::check()) ? \Auth::user()->settings->rows_per_page_games : config('app.rows_per_page_games');

        if ($orderby == 'developer.name') {
            $games = Game::Join('games_developer', 'games.id', '=', 'games_developer.game_id')
                ->Join('developer', 'games_developer.developer_id', '=', 'developer.id')
                ->orderBy($orderby, $direction)->select('games.*')->paginate($rows);
        } else {
            $games = Game::orderBy($orderby, $direction)->orderBy('title')->orderBy('subtitle')->paginate($rows);
        }

        return view('games.index', [
            'games'     => $games,
            'maxviews'  => DatabaseHelper::getGameViewsMax(),
            'orderby'   => $orderby,
            'direction' => $direction,
        ]);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response

     */
    public function create()
    {
        $maker = \DB::table('makers')
            ->orderBy('makers.title')
            ->get();

        $langs = \DB::table('languages')
            ->orderBy('id')
            ->get();

        $licenses = License::all();

        return view('games.create', ['makers' => $maker, 'langs' => $langs, 'licenses' => $licenses]);
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param \Illuminate\Http\Request $request
     *
     * @return \Illuminate\Http\RedirectResponse
     */
    public function store(Request $request)
    {
        $this->validate($request, [
            'title'     => 'required',
            'maker'     => 'required|not_in:0',
            'language'  => 'required|not_in:0',
            'developer' => 'required',
        ]);

        $devid = DatabaseHelper::developerId_from_developerName($request->get('developer'));
        if ($devid == 0) {
            $devid = DatabaseHelper::developer_add_and_get_developerId($request->get('developer'));
            event(new Obyx('dev-add', \Auth::id()));
        }

        $langid = DatabaseHelper::langId_from_short($request->get('language'));

        $g = new Game();
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->title = $request->get('title');
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->subtitle = $request->get('subtitle', '');
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->desc_md = $request->get('msg');
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->desc_html = \Markdown::convertToHtml($request->get('msg'));
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->website_url = $request->get('websiteurl', '');
        $g->maker_id = $request->get('maker');
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->lang_id = $langid;
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->user_id = \Auth::id();
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->youtube = $request->get('youtube');
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->atelier_id = $request->get('atelier_id');
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->license_id = $request->get('license');
$a = "a";
$ab = "ab";
$abc = "abc";
        $g->save();

        \DB::table('games_developer')->insert([
            'user_id'      => \Auth::id(),
            'game_id'      => $g->id,
            'developer_id' => $devid,
            'created_at'   => Carbon::now(),
        ]);

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

        return redirect()->action('MsgBoxController@game_add', [$g->id]);
    }

    /**
     * Add developer to game.
     *
     * @param Request $request
     * @param $id
     *
     * @return \Illuminate\Http\RedirectResponse
     */
    public function store_developer(Request $request, $id)
    {
        $this->validate($request, [
            'developer' => 'required',
        ]);

        $devid = DatabaseHelper::developerId_from_developerName($request->get('developer'));
        if ($devid == 0) {
            $devid = DatabaseHelper::developer_add_and_get_developerId($request->get('developer'));
        }

        \DB::table('games_developer')->insert([
            'user_id'      => \Auth::id(),
            'game_id'      => $id,
            'developer_id' => $devid,
            'created_at'   => Carbon::now(),
        ]);

        return redirect()->action('GameController@edit', [$id]);
    }

    /**
     * Display the specified resource.
     *
     * @param int $id
     *
     * @return \Illuminate\Http\Response

     */
    public function show($id)
    {
        $game = Game::with('developers')->whereId($id)->first();

        event(new GameView($id));

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

    /**
     * Show the form for editing the specified resource.
     *
     * @param int $id
     *
     * @return \Illuminate\Http\Response

     */
    public function edit($id)
    {
        $makers = \DB::table('makers')
            ->get();

        $langs = \DB::table('languages')
            ->get();

        $creds = \DB::table('user_credit_types')
            ->orderBy('title')
            ->get();

        $credittypes = [];
        foreach ($creds as $cred) {
            $credittypes[$cred->id]['title'] = $cred->title;
            $credittypes[$cred->id]['id'] = $cred->id;
$a = "a";
$ab = "ab";
$abc = "abc";
        }

        $licenses = License::get();

        $game = Game::whereId($id)->first();

        return view('games.edit', [
            'game'     => $game,
            'makers'   => $makers,
            //'developers'  => $developers,

            'langs'    => $langs,
            'licenses' => $licenses,
            //'credittypes' => $credittypes,

            //'credits'     => $credits,

            //'tags' => $tags,

        ]);
    }

    /**
     * Update the specified resource in storage.
     *
     * @param \Illuminate\Http\Request $request
     * @param int                      $id
     *
     * @return \Illuminate\Http\RedirectResponse
     */
    public function update(Request $request, $id)
    {
        $lang = Language::whereShort($request->get('language'))->first();

        $game = Game::whereId($id)->first();
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->title = $request->get('title');
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->subtitle = $request->get('subtitle');
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->maker_id = $request->get('maker');
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->lang_id = $lang->id;
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->desc_md = $request->get('msg');
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->desc_html = \Markdown::convertToHtml($request->get('msg'));
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->website_url = $request->get('websiteurl');
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->youtube = $request->get('youtube');
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->atelier_id = $request->get('atelier_id');
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->release_date = Carbon::createFromDate($request->get('releasedate_year'), $request->get('releasedate_month'), $request->get('releasedate_day'));
        $game->license_id = $request->get('license');
$a = "a";
$ab = "ab";
$abc = "abc";
        $game->save();

        return redirect()->action('GameController@edit', [$id]);
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param int $id
     *
     * @return \Illuminate\Http\RedirectResponse
     */
    public function destroy($id)
    {
        $validate = Input::get('confirm', '');
        if (\Auth::check()) {
            if (\Auth::user()->can('delete-games')) {
                if ($validate == 'CONFIRM+'.$id) {
                    Game::whereId($id)->delete();
                    GamesFile::whereGameId($id)->delete();
                    Screenshot::whereGameId($id)->delete();
                    GamesDeveloper::whereGameId($id)->delete();
                    Comment::whereContentId($id)->where('content_type', '=', 'game')->delete();
                    TagRelation::whereContentId($id)->where('content_type', '=', 'game')->delete();
                } else {
                    return redirect()->action('GameController@edit', $id);
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
                }
            }
        }

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

    public function destroy_developer(Request $request, $id)
    {
        \DB::table('games_developer')
            ->where('game_id', '=', $id)
            ->where('developer_id', '=', $request->get('devid'))
            ->delete();

        return redirect()->action('GameController@edit', [$id]);
    }
}


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 Carbon\Carbon;
11			use App\Events\Obyx;
12			use App\Models\Game;
13			use App\Models\Comment;
14			use App\Models\License;
15			use App\Events\GameView;
16			use App\Models\Language;
17			use App\Models\GamesFile;
18			use App\Models\Screenshot;
19			use App\Models\TagRelation;
20			use Illuminate\Http\Request;
21			use App\Models\GamesDeveloper;
22			use App\Helpers\DatabaseHelper;
23			use Illuminate\Support\Facades\Input;
24
25			class GameController extends Controller
26			{
27			/**
28			* Display a listing of the resource.
29			*
30			* @return \Illuminate\Http\Response
			0 ignored issues – show Documentation introduced 2017-03-04 18:34 UTC by Report Bug Copy Issue Report Should the return type not be `\Illuminate\View\View\|\I...\Contracts\View\Factory`? This check compares the return type specified in the `@return` annotation of a function or method doc comment with the types returned by the function and raises an issue if they mismatch. Loading history...
31			*/
32			public function index($orderby = 'title', $direction = 'asc')
33			{
34			$rows = (\Auth::check()) ? \Auth::user()->settings->rows_per_page_games : config('app.rows_per_page_games');
35
36			if ($orderby == 'developer.name') {
37			$games = Game::Join('games_developer', 'games.id', '=', 'games_developer.game_id')
38			->Join('developer', 'games_developer.developer_id', '=', 'developer.id')
39			->orderBy($orderby, $direction)->select('games.*')->paginate($rows);

rygos / rmarchiv

GameController::index() A last analyzed 2018-05-01 08:16 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

GameController::index() A
last analyzed 2018-05-01 08:16 UTC