RecordController::update() - Code Metrics - Inspection of "Update RecordController store" - Codexshaper/laravel-database-manager - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 0ef3ba...a0d273 )

by CodexShaper

created 2020-01-05 17:42 UTC

RecordController::update() A

↳ Parent: RecordController

Complexity

Conditions	6
Paths	7

Size

Total Lines	33
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	42

Importance

Changes	3
Bugs	0	Features	0

Metric	Value
cc	6
eloc	18
nc	7
nop	1
dl	0
loc	33
ccs	0
cts	25
cp	0
crap	42
rs	9.0444
c	3
b	0
f	0

<?php

namespace CodexShaper\DBM\Http\Controllers;

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

class RecordController extends Controller
{
    use RecordTrait;

    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;
            $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();

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

            try {

                $table = $this->processStoreData($request, $object);

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

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

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

    public function processStoreData($request, $object)
    {
        $originalColumns = Table::getColumnsName($request->table);
        $columns         = json_decode($request->columns);
        $table           = DBM::model($object->model, $request->table);

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

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

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

                        $value = $this->executeFunction($functionName, $value);
                    }
                }

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

        return $table;
    }

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

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

            $tableName = $request->table;
            $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();

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

            try {
                $this->sync($request, $object);
                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\RecordTrait;
8			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...
9			use Illuminate\Http\Request;
10
11			class RecordController extends Controller
12			{
13			use RecordTrait;
14
15			public function index()
16			{
17			return view('dbm::app');
18			}
19
20			public function store(Request $request)
21			{
22			if ($request->ajax()) {
23
24			if (($response = DBM::authorize('record.create')) !== true) {
25			return $response;
26			}
27
28			$tableName = $request->table;
29			$columns = json_decode($request->columns);
30			$fields = json_decode($request->fields);
31
32			$errors = $this->validation($fields, $columns);
33
34			if (count($errors) > 0) {
35			return $this->generateError($errors);
36			}
37
38			$object = DBM::Object()->where('name', $tableName)->first();
39
40			if (!class_exists($object->model)) {
41			return $this->generateError(["Model not found. Please create model first"]);
42			}
43
44			try {
45
46			$table = $this->processStoreData($request, $object);
47
48			if ($table->save()) {
49			$this->storeRelationshipData($fields, $columns, $object, $table);
50			return response()->json(['success' => true]);
51			}
52
53			} catch (\Exception $e) {
54			return $this->generateError([$e->getMessage()]);
55			}
56			}
57
58			return response()->json(['success' => false]);
59			}
60
61			public function processStoreData($request, $object)
62			{
63			$originalColumns = Table::getColumnsName($request->table);
64			$columns = json_decode($request->columns);
65			$table = DBM::model($object->model, $request->table);
66
67			foreach ($columns as $column => $value) {
68			if (in_array($column, $originalColumns)) {
69
70			if ($request->hasFile($column)) {
71			$value = $this->saveFiles($request, $column, $request->table);
72			}
73
74			if (!Driver::isMongoDB()) {
75			if ($functionName = $this->hasFunction($fields, $column)) {
			0 ignored issues – show Comprehensibility Best Practice introduced 2020-01-05 17:47 UTC by Report Bug Copy Issue Report The variable `$fields` seems to be never defined. Loading history...
76			$value = $this->executeFunction($functionName, $value);
77			}
78			}
79
80			$table->{$column} = $this->prepareStoreField($value, $request->table, $column);
81			}
82			}
83
84			return $table;
85			}
86
87			public function update(Request $request)
88			{
89			if ($request->ajax()) {
90
91			if (($response = DBM::authorize('record.update')) !== true) {
92			return $response;
93			}
94
95			$tableName = $request->table;
96			$columns = json_decode($request->columns);
97			$fields = json_decode($request->fields);
98
99			$errors = $this->validation($fields, $columns, 'update');
100
101			if (count($errors) > 0) {
102			return $this->generateError($errors);
103			}
104
105			$object = DBM::Object()->where('name', $tableName)->first();
106
107			if (!class_exists($object->model)) {
108			return $this->generateError(["Model not found. Please create model first"]);
109			}
110
111			try {
112			$this->sync($request, $object);
113			return response()->json(['success' => true]);
114			} catch (\Exception $e) {
115			return $this->generateError([$e->getMessage()]);
116			}
117			}
118
119			return response()->json(['success' => false]);
120			}
121
122			public function delete(Request $request)
123			{
124			if ($request->ajax()) {
125
126			if (($response = DBM::authorize('record.delete')) !== true) {
127			return $response;
128			}
129
130			$tableName = $request->table;
131			// $originalColumns = Table::getColumnsName($tableName);
132			$columns = json_decode($request->columns);
133			$fields = $request->fields;
134			$object = DBM::Object()->where('name', $tableName)->first();
135			$model = $object->model;
136			$details = $object->details;
137			$key = $details['findColumn'];
138
139			if (!class_exists($model)) {
140			return $this->generateError(["Model not found. Please create model first"]);
141			}
142
143			try {
144			$table = DBM::model($model, $tableName)->where($key, $columns->{$key})->first();
145			if ($table) {
146			// Remove Relationship data
147			foreach ($fields as $field) {
148			$field = json_decode($field);
149			$this->removeRelationshipData($field, $object, $table);
150			}
151			// Check Table deleted successfully
152			if ($table->delete()) {
153			return response()->json(['success' => true]);
154			}
155			}
156
157			} catch (\Exception $e) {
158			return $this->generateError([$e->getMessage()]);
159			}
160			}
161
162			return response()->json(['success' => false]);
163			}
164
165			public function getTableDetails(Request $request)
166			{
167			if ($request->ajax()) {
168
169			if (($response = DBM::authorize('record.browse')) !== true) {
170			return $response;
171			}
172
173			$tableName = $request->table;
174			$object = DBM::Object()->where('name', $tableName)->first();
175
176			if (!$object) {
177			return response()->json([
178			'success' => false,
179			'errors' => ["There is no Object details"],
180			], 400);
181			}
182
183			$createFields = $object->createFields();
184			$browseFields = $object->readFields();
185			$editFields = $object->editFields();
186			$deleteFields = $object->deleteFields();
187			$fields = $object->allFields();
188			$foreignTableData = [];
189
190			$createFields = $this->prepareRecordFields($createFields);
191			$editFields = $this->prepareRecordFields($editFields);
192
193			$model = $object->model;
194
195			if (!class_exists($model)) {
196			return $this->generateError(["Model not found. Please create model first"]);
197			}
198
199			$perPage = (int) $request->perPage;
200			$query = $request->q;
201			$searchColumn = $object->details['searchColumn'];
202			$records = DBM::model($model, $tableName)->paginate($perPage);
203
204			if (!empty($query) && !empty($searchColumn)) {
205			$records = DBM::model($model, $tableName)
206			->where($searchColumn, 'LIKE', '%' . $query . '%')
207			->paginate($perPage);
208			}
209
210			$records = $this->prepareRelationshipData($records, $browseFields, $object);
211			$recordsDetail = $this->prepareJsonFieldData($records, $fields, $object, $request->findValue);
212
213			$objectDetails = $object->details;
214			$objectDetails['perPage'] = $perPage;
215
216			return response()->json([
217			'success' => true,
218			'object' => $object,
219			'objectDetails' => $objectDetails,
220			'createFields' => $createFields,
221			'browseFields' => $browseFields,
222			'editFields' => $editFields,
223			'deleteFields' => $deleteFields,
224			'records' => $recordsDetail['records'],
225			'record' => $recordsDetail['record'],
226			'foreignTableData' => $foreignTableData,
227			'userPermissions' => DBM::userPermissions(),
228			'pagination' => $records,
229			]);
230			}
231
232			return response()->json(['success' => false]);
233			}
234			}
235

Codexshaper / laravel-database-manager

Push — master ( 0ef3ba...a0d273 )

RecordController::update() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like