RecordController::index() - Code Metrics - Inspection of "Created RecordRelationship Trait to separate relat..." - Codexshaper/laravel-database-manager - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( acc6c6...cef23c )

by CodexShaper

created 2020-01-03 16:41 UTC

RecordController::index() A

↳ Parent: RecordController

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	1
c	1
b	0
f	0
nc	1
nop	0
dl	0
loc	3
ccs	0
cts	3
cp	0
crap	2
rs	10

<?php

namespace CodexShaper\DBM\Http\Controllers;

use CodexShaper\DBM\Database\Schema\Table;
use CodexShaper\DBM\Facades\Driver;
use CodexShaper\DBM\Traits\RecordHelper;
use CodexShaper\DBM\Traits\RecordRelationship;
use DBM;
filter:
    dependency_paths: ["lib/*"]
use Illuminate\Http\Request;

class RecordController extends Controller
{
    use RecordHelper, RecordRelationship;


    public function index()
    {
        return view('dbm::app');
    }

    public function store(Request $request)
    {
        if ($request->ajax()) {

            if (($response = DBM::authorize('record.create')) !== true) {
                return $response;
            }

            $tableName       = $request->table;
            $originalColumns = Table::getColumnsName($tableName);
            $columns         = json_decode($request->columns);
            $fields          = json_decode($request->fields);

            $errors = $this->validation($fields, $columns);

            if (count($errors) > 0) {
                return $this->generateError($errors);
            }

            $object = DBM::Object()->where('name', $tableName)->first();
            $model  = $object->model;

            if (!class_exists($model)) {
                return $this->generateError(["Model not found. Please create model first"]);
            }

            try {

                $table = DBM::model($model, $tableName);

                foreach ($columns as $column => $value) {
                    if (in_array($column, $originalColumns)) {

                        if ($request->hasFile($column)) {
                            $value = $this->saveFiles($request, $column, $tableName);
                        }

                        if (!Driver::isMongoDB()) {
                            if ($functionName = $this->hasFunction($fields, $column)) {
                                $value = $this->executeFunction($functionName, $value);
                            }
                        }

                        $table->{$column} = $this->prepareStoreField($value, $tableName, $column);
                    }
                }

                if ($table->save()) {
                    $this->storeRelationshipData($fields, $columns, $object, $table);
                    return response()->json(['success' => true, 'object' => $object, 'table' => $table]);
                }

            } catch (\Exception $e) {
                return $this->generateError([$e->getMessage()]);
            }
        }

        return response()->json(['success' => false]);
    }

    public function update(Request $request)
    {
        if ($request->ajax()) {

            if (($response = DBM::authorize('record.update')) !== true) {
                return $response;
            }

            $tableName       = $request->table;
            $originalColumns = Table::getColumnsName($tableName);
            $columns         = json_decode($request->columns);
            $fields          = json_decode($request->fields);

            $errors = $this->validation($fields, $columns, 'update');

            if (count($errors) > 0) {
                return $this->generateError($errors);
            }

            $object  = DBM::Object()->where('name', $tableName)->first();
            $model   = $object->model;
            $details = $object->details;
            $key     = $details['findColumn'];

            if (!class_exists($model)) {
                return $this->generateError(["Model not found. Please create model first"]);
            }

            try {

                $table = DBM::model($model, $tableName)->where($key, $columns->{$key})->first();

                foreach ($columns as $column => $value) {

                    if (in_array($column, $originalColumns)) {

                        if ($request->hasFile($column)) {
                            $value = $this->saveFiles($request, $column, $tableName);
                        }

                        if ($value !== null && $value !== "") {

                            if (!Driver::isMongoDB()) {
                                if ($functionName = $this->hasFunction($fields, $column)) {
                                    $value = $this->executeFunction($functionName, $value);
                                }
                            }

                            $table->{$column} = $this->prepareStoreField($value, $tableName, $column);
                        }
                    }
                }

                if ($table->update()) {
                    $this->updateRelationshipData($fields, $columns, $object, $table);
                    return response()->json(['success' => true]);
                }

            } catch (\Exception $e) {
                return $this->generateError([$e->getMessage()]);
            }
        }

        return response()->json(['success' => false]);
    }

    public function delete(Request $request)
    {
        if ($request->ajax()) {

            if (($response = DBM::authorize('record.delete')) !== true) {
                return $response;
            }

            $tableName = $request->table;
            // $originalColumns = Table::getColumnsName($tableName);
            $columns = json_decode($request->columns);
            $fields  = $request->fields;
            $object  = DBM::Object()->where('name', $tableName)->first();
            $model   = $object->model;
            $details = $object->details;
            $key     = $details['findColumn'];

            if (!class_exists($model)) {
                return $this->generateError(["Model not found. Please create model first"]);
            }

            try {
                $table = DBM::model($model, $tableName)->where($key, $columns->{$key})->first();
                if ($table) {
                    // Remove Relationship data
                    foreach ($fields as $field) {
                        $field = json_decode($field);
                        $this->removeRelationshipData($field, $object, $table);
                    }
                    // Check Table deleted successfully
                    if ($table->delete()) {
                        return response()->json(['success' => true]);
                    }
                }

            } catch (\Exception $e) {
                return $this->generateError([$e->getMessage()]);
            }
        }

        return response()->json(['success' => false]);
    }

    public function getTableDetails(Request $request)
    {
        if ($request->ajax()) {

            if (($response = DBM::authorize('record.browse')) !== true) {
                return $response;
            }

            $tableName = $request->table;
            $object    = DBM::Object()->where('name', $tableName)->first();

            if (!$object) {
                return response()->json([
                    'success' => false,
                    'errors'  => ["There is no Object details"],
                ], 400);
            }

            $createFields     = $object->createFields();
            $browseFields     = $object->readFields();
            $editFields       = $object->editFields();
            $deleteFields     = $object->deleteFields();
            $fields           = $object->allFields();
            $foreignTableData = [];

            $createFields = $this->prepareRecordFields($createFields);
            $editFields   = $this->prepareRecordFields($editFields);

            $model = $object->model;

            if (!class_exists($model)) {
                return $this->generateError(["Model not found. Please create model first"]);
            }

            $perPage      = (int) $request->perPage;
            $query        = $request->q;
            $searchColumn = $object->details['searchColumn'];
            $records      = DBM::model($model, $tableName)->paginate($perPage);

            if (!empty($query) && !empty($searchColumn)) {
                $records = DBM::model($model, $tableName)
                    ->where($searchColumn, 'LIKE', '%' . $query . '%')
                    ->paginate($perPage);
            }

            $records       = $this->prepareRelationshipData($records, $browseFields, $object);
            $recordsDetail = $this->prepareJsonFieldData($records, $fields, $object, $request->findValue);

            $objectDetails            = $object->details;
            $objectDetails['perPage'] = $perPage;

            return response()->json([
                'success'          => true,
                'object'           => $object,
                'objectDetails'    => $objectDetails,
                'createFields'     => $createFields,
                'browseFields'     => $browseFields,
                'editFields'       => $editFields,
                'deleteFields'     => $deleteFields,
                'records'          => $recordsDetail['records'],
                'record'           => $recordsDetail['record'],
                'foreignTableData' => $foreignTableData,
                'userPermissions'  => DBM::userPermissions(),
                'pagination'       => $records,
            ]);
        }

        return response()->json(['success' => false]);
    }
}


1			<?php
2
3			namespace CodexShaper\DBM\Http\Controllers;
4
5			use CodexShaper\DBM\Database\Schema\Table;
6			use CodexShaper\DBM\Facades\Driver;
7			use CodexShaper\DBM\Traits\RecordHelper;
8			use CodexShaper\DBM\Traits\RecordRelationship;
9			use DBM;
			0 ignored issues – show Bug introduced 2020-01-02 11:31 UTC by Report Bug Copy Issue Report The type `DBM` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
10			use Illuminate\Http\Request;
11
12			class RecordController extends Controller
13			{
14			use RecordHelper, RecordRelationship;
			0 ignored issues – show introduced 2020-01-03 16:45 UTC by Report Bug Copy Issue Report The trait `CodexShaper\DBM\Traits\RecordRelationship` requires some properties which are not provided by `CodexShaper\DBM\Http\Controllers\RecordController`: `$has_many`, `$belongs_to_many`, `$belongs_to` Loading history...
15
16			public function index()
17			{
18			return view('dbm::app');
19			}
20
21			public function store(Request $request)
22			{
23			if ($request->ajax()) {
24
25			if (($response = DBM::authorize('record.create')) !== true) {
26			return $response;
27			}
28
29			$tableName = $request->table;
30			$originalColumns = Table::getColumnsName($tableName);
31			$columns = json_decode($request->columns);
32			$fields = json_decode($request->fields);
33
34			$errors = $this->validation($fields, $columns);
35
36			if (count($errors) > 0) {
37			return $this->generateError($errors);
38			}
39
40			$object = DBM::Object()->where('name', $tableName)->first();
41			$model = $object->model;
42
43			if (!class_exists($model)) {
44			return $this->generateError(["Model not found. Please create model first"]);
45			}
46
47			try {
48
49			$table = DBM::model($model, $tableName);
50
51			foreach ($columns as $column => $value) {
52			if (in_array($column, $originalColumns)) {
53
54			if ($request->hasFile($column)) {
55			$value = $this->saveFiles($request, $column, $tableName);
56			}
57
58			if (!Driver::isMongoDB()) {
59			if ($functionName = $this->hasFunction($fields, $column)) {
60			$value = $this->executeFunction($functionName, $value);
61			}
62			}
63
64			$table->{$column} = $this->prepareStoreField($value, $tableName, $column);
65			}
66			}
67
68			if ($table->save()) {
69			$this->storeRelationshipData($fields, $columns, $object, $table);
70			return response()->json(['success' => true, 'object' => $object, 'table' => $table]);
71			}
72
73			} catch (\Exception $e) {
74			return $this->generateError([$e->getMessage()]);
75			}
76			}
77
78			return response()->json(['success' => false]);
79			}
80
81			public function update(Request $request)
82			{
83			if ($request->ajax()) {
84
85			if (($response = DBM::authorize('record.update')) !== true) {
86			return $response;
87			}
88
89			$tableName = $request->table;
90			$originalColumns = Table::getColumnsName($tableName);
91			$columns = json_decode($request->columns);
92			$fields = json_decode($request->fields);
93
94			$errors = $this->validation($fields, $columns, 'update');
95
96			if (count($errors) > 0) {
97			return $this->generateError($errors);
98			}
99
100			$object = DBM::Object()->where('name', $tableName)->first();
101			$model = $object->model;
102			$details = $object->details;
103			$key = $details['findColumn'];
104
105			if (!class_exists($model)) {
106			return $this->generateError(["Model not found. Please create model first"]);
107			}
108
109			try {
110
111			$table = DBM::model($model, $tableName)->where($key, $columns->{$key})->first();
112
113			foreach ($columns as $column => $value) {
114
115			if (in_array($column, $originalColumns)) {
116
117			if ($request->hasFile($column)) {
118			$value = $this->saveFiles($request, $column, $tableName);
119			}
120
121			if ($value !== null && $value !== "") {
122
123			if (!Driver::isMongoDB()) {
124			if ($functionName = $this->hasFunction($fields, $column)) {
125			$value = $this->executeFunction($functionName, $value);
126			}
127			}
128
129			$table->{$column} = $this->prepareStoreField($value, $tableName, $column);
130			}
131			}
132			}
133
134			if ($table->update()) {
135			$this->updateRelationshipData($fields, $columns, $object, $table);
136			return response()->json(['success' => true]);
137			}
138
139			} catch (\Exception $e) {
140			return $this->generateError([$e->getMessage()]);
141			}
142			}
143
144			return response()->json(['success' => false]);
145			}
146
147			public function delete(Request $request)
148			{
149			if ($request->ajax()) {
150
151			if (($response = DBM::authorize('record.delete')) !== true) {
152			return $response;
153			}
154
155			$tableName = $request->table;
156			// $originalColumns = Table::getColumnsName($tableName);
157			$columns = json_decode($request->columns);
158			$fields = $request->fields;
159			$object = DBM::Object()->where('name', $tableName)->first();
160			$model = $object->model;
161			$details = $object->details;
162			$key = $details['findColumn'];
163
164			if (!class_exists($model)) {
165			return $this->generateError(["Model not found. Please create model first"]);
166			}
167
168			try {
169			$table = DBM::model($model, $tableName)->where($key, $columns->{$key})->first();
170			if ($table) {
171			// Remove Relationship data
172			foreach ($fields as $field) {
173			$field = json_decode($field);
174			$this->removeRelationshipData($field, $object, $table);
175			}
176			// Check Table deleted successfully
177			if ($table->delete()) {
178			return response()->json(['success' => true]);
179			}
180			}
181
182			} catch (\Exception $e) {
183			return $this->generateError([$e->getMessage()]);
184			}
185			}
186
187			return response()->json(['success' => false]);
188			}
189
190			public function getTableDetails(Request $request)
191			{
192			if ($request->ajax()) {
193
194			if (($response = DBM::authorize('record.browse')) !== true) {
195			return $response;
196			}
197
198			$tableName = $request->table;
199			$object = DBM::Object()->where('name', $tableName)->first();
200
201			if (!$object) {
202			return response()->json([
203			'success' => false,
204			'errors' => ["There is no Object details"],
205			], 400);
206			}
207
208			$createFields = $object->createFields();
209			$browseFields = $object->readFields();
210			$editFields = $object->editFields();
211			$deleteFields = $object->deleteFields();
212			$fields = $object->allFields();
213			$foreignTableData = [];
214
215			$createFields = $this->prepareRecordFields($createFields);
216			$editFields = $this->prepareRecordFields($editFields);
217
218			$model = $object->model;
219
220			if (!class_exists($model)) {
221			return $this->generateError(["Model not found. Please create model first"]);
222			}
223
224			$perPage = (int) $request->perPage;
225			$query = $request->q;
226			$searchColumn = $object->details['searchColumn'];
227			$records = DBM::model($model, $tableName)->paginate($perPage);
228
229			if (!empty($query) && !empty($searchColumn)) {
230			$records = DBM::model($model, $tableName)
231			->where($searchColumn, 'LIKE', '%' . $query . '%')
232			->paginate($perPage);
233			}
234
235			$records = $this->prepareRelationshipData($records, $browseFields, $object);
236			$recordsDetail = $this->prepareJsonFieldData($records, $fields, $object, $request->findValue);
237
238			$objectDetails = $object->details;
239			$objectDetails['perPage'] = $perPage;
240
241			return response()->json([
242			'success' => true,
243			'object' => $object,
244			'objectDetails' => $objectDetails,
245			'createFields' => $createFields,
246			'browseFields' => $browseFields,
247			'editFields' => $editFields,
248			'deleteFields' => $deleteFields,
249			'records' => $recordsDetail['records'],
250			'record' => $recordsDetail['record'],
251			'foreignTableData' => $foreignTableData,
252			'userPermissions' => DBM::userPermissions(),
253			'pagination' => $records,
254			]);
255			}
256
257			return response()->json(['success' => false]);
258			}
259			}
260

Codexshaper / laravel-database-manager

Push — master ( acc6c6...cef23c )

RecordController::index() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like