IndexAjax::applyQ() - Code Metrics - Inspection of "Merge pull request #1115 from imanghafoori1/refact..." - crocodic-studio/crudbooster - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 1cde08...5efba4 )

by Iman

created 2018-03-30 20:16 UTC

IndexAjax::applyQ() A

↳ Parent: IndexAjax

Complexity

Conditions	4
Paths	2

Size

Total Lines	11
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	4
eloc	8
nc	2
nop	2
dl	0
loc	11
rs	9.2
c	0
b	0
f	0

<?php

namespace crocodicstudio\crudbooster\controllers\CBController;

use crocodicstudio\crudbooster\CBCoreModule\Search;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\DB;

trait IndexAjax
{
    public function getDataTable()
    {
        $table = request('table');
        $label = request('label');
        $datatableWhere = urldecode(request('datatable_where'));
        $datatableWhere = urldecode(/** @scrutinizer ignore-type */ request('datatable_where'));
        $foreignKeyName = request('fk_name');
        $foreignKeyValue = request('fk_value');
        if (! $table || ! $label || ! $foreignKeyName || ! $foreignKeyValue) {
            return response()->json([]);
            return response()->/** @scrutinizer ignore-call */ json([]);
        }
        $query = DB::table($table);
        $query = DB::table(/** @scrutinizer ignore-type */ $table);
        if ($datatableWhere) {
            $query->whereRaw($datatableWhere);
        }
        $query->select('id as select_value', $label.' as select_label');
        $query->select('id as select_value', /** @scrutinizer ignore-type */ $label.' as select_label');
        $query->where($foreignKeyName, $foreignKeyValue);
        $query->orderby($label, 'asc');
        $query->orderby(/** @scrutinizer ignore-type */ $label, 'asc');

        return response()->json($query->get());
    }

    public function getDataModalDatatable()
    {
        $data = base64_decode(json_decode(request('data'), true));
        $data = base64_decode(json_decode(/** @scrutinizer ignore-type */ request('data'), true));

        $columns = explode(',', $data['columns']);

        $result = DB::table($data['table']);
        $this->applyQ($result, $columns);

        if ($data['sql_where']) {
            $result->whereraw($data['sql_where']);
        }

        $this->applyOrderBy($data, $result);
        $limit = ($data['limit']) ?: 6;

        return view('crudbooster::form.type_components.datamodal.browser', ['result' => $result->paginate($limit), 'data' => $data]);
    }

    public function getDataQuery()
    {
        $key = request('query');
        if (! Cache::has($key)) {
            return response()->json(['items' => []]);
        }
        $query = Cache::get($key);
        $query = Cache::get(/** @scrutinizer ignore-type */ $key);

        $fk_name = request('fk_name');
        $fk_value = request('fk_value');

        $condition = ' where ';
        if (strpos(strtolower($query), 'where') !== false) {
        if (strpos(strtolower(/** @scrutinizer ignore-type */ $query), 'where') !== false) {
            $condition = ' and ';
        }

        if (strpos(strtolower($query), 'order by')) {
            $query = str_replace('ORDER BY', 'order by', $query);
            $qraw = explode('order by', $query);
            $query = $qraw[0].$condition.$fk_name." = '$fk_value' $qraw[1]";
            $query = $qraw[0].$condition./** @scrutinizer ignore-type */ $fk_name." = '$fk_value' $qraw[1]";
        } else {
            $query .= $condition.$fk_name." = '$fk_value'";
        }

        $query = DB::select(DB::raw($query));

        return response()->json(['items' => $query]);
    }

    public function postFindData()
    {
        $items = app(Search::class)->searchData(request('data'), request('q'), request('id'));

        return response()->json(['items' => $items]);
    }

    /**
     * @param $result
     * @param $columns
     */
    private function applyQ($result, $columns)
    {
        if (request('q')) {
            return;
        }
        $result->where(function ($where) use ($columns) {
            foreach ($columns as $c => $col) {
                if ($c == 0) {
                    $where->where($col, 'like', '%'.request('q').'%');
                    $where->where($col, 'like', '%'./** @scrutinizer ignore-type */ request('q').'%');
                } else {
                    $where->orWhere($col, 'like', '%'.request('q').'%');
                }
            }
        });
    }

    /**
     * @param $data
     * @param $result
     */
    private function applyOrderBy($data, $result)
    {
        if ($data['sql_orderby']) {
            $result->orderByRaw($data['sql_orderby']);
        } else {
            $result->orderBy($data['column_value'], 'desc');
        }
    }
}

crocodic-studio / crudbooster

Push — master ( 1cde08...5efba4 )

IndexAjax::applyQ() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like