Columns::setBelongsToRelations() - Code Metrics - coolsam726/jetstream-inertia-generator - Measure and Improve Code Quality continuously with Scrutinizer

Columns::setBelongsToRelations() B
last analyzed 2021-05-18 05:13 UTC

↳ Parent: Columns

Complexity

Conditions	7
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	36
rs	8.4106
c	0
b	0
f	0
cc	7
nc	1
nop	0

<?php namespace Savannabits\JetstreamInertiaGenerator\Generators\Traits;

use Doctrine\DBAL\DriverManager;
use Doctrine\DBAL\Schema\ForeignKeyConstraint;
use Illuminate\Database\Capsule\Manager;
use Illuminate\Database\DatabaseManager;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Str;
trait Columns {

    /**
     * @param $tableName
     * @return Collection
     */
    protected function readColumnsFromTable($tableName): Collection
    {

        // TODO how to process jsonb & json translatable columns? need to figure it out

        $indexes = collect(Schema::getConnection()->getDoctrineSchemaManager()->listTableIndexes($tableName));

        return collect(Schema::getColumnListing($tableName))->map(function($columnName) use ($tableName, $indexes) {

            //Checked unique index
            $columnUniqueIndexes = $indexes->filter(function($index) use ($columnName) {
                return in_array($columnName, $index->getColumns()) && ($index->isUnique() && !$index->isPrimary());
            });
            $columnPrimaryIndex = $indexes->filter(function($index) use ($columnName) {
                return in_array($columnName,$index->getColumns()) && $index->isPrimary();
            });
            $columnUniqueDeleteAtCondition = $columnUniqueIndexes->filter(function($index) {
                return $index->hasOption('where') && $index->getOption('where') == '(deleted_at IS NULL)';
            });

            // TODO add foreign key

            return [
                'name' => $columnName,
                'primary' => $columnPrimaryIndex->count() > 0,
                'label' => Str::title(str_replace("-"," ",Str::slug($columnName))),
                'type' => Schema::getColumnType($tableName, $columnName),
                'required' => boolval(Schema::getConnection()->getDoctrineColumn($tableName, $columnName)->getNotnull()),

                'unique' => $columnUniqueIndexes->count() > 0,
                'unique_indexes' => $columnUniqueIndexes,
                'unique_deleted_at_condition' => $columnUniqueDeleteAtCondition->count() > 0,
            ];
        })
            /*->sortByDesc(function ($item) {return $item['type']==='json';})
            ->sortByDesc(function ($item) {return $item['type']==='longText';})
            ->sortByDesc(function ($item) {return $item['type']==='time';})
            ->sortByDesc(function ($item) {return $item['type']==='tinyinteger';})
            ->sortByDesc(function ($item) {return $item['type']==='bigInteger';})
            ->sortByDesc(function ($item) {return $item['type']==='mediumInteger';})
            ->sortByDesc(function ($item) {return $item['type']==='integer';})
            ->sortByDesc(function ($item) {return $item['type']==='float';})
            ->sortByDesc(function ($item) {return $item['type']==='double';})
            ->sortByDesc(function ($item) {return $item['type']==='text';})
            ->sortByDesc(function ($item) {return $item['name']==='amount';})*/
            ->sortByDesc(function ($item) {return $item['type']==='boolean';})
            ->sortByDesc(function ($item) {return $item['type']==='datetime'&& !in_array($item['name'],['created_at','updated_at']);})
            ->sortByDesc(function ($item) {return $item['type']==='date';})
            ->sortByDesc(function ($item) {return $item['type']==='float';})
//            ->sortByDesc(function ($item) {return $item['type']==='double';})
            ->sortByDesc(function ($item) {return $item['type']==='text' && !in_array($item['name'],["description",'details','content','body','text']);})

            ->sortByDesc(function ($item) {return $item['type']==='string' && !in_array($item['name'],["description",'details','content','body','text','middle_name','other_names','first_name','last_name','surname','title','headline','name','display_name','slug']);})
            ->sortByDesc(function ($item) {return in_array($item['name'],["description",'details','content','body','text']);})

            ->sortByDesc(function ($item) {return in_array($item['name'],['middle_name','other_names']);})
            ->sortByDesc(function ($item) {return in_array($item['name'],['first_name','last_name','surname']);})
            ->sortByDesc(function ($item) {return in_array($item['name'],['headline']);})
            ->sortByDesc(function ($item) {return in_array($item['name'],['display_name']);})
            ->sortByDesc(function ($item) {return in_array($item['name'],['title']);})
            ->sortByDesc(function ($item) {return in_array($item['name'],['name']);})
            ->sortByDesc(function ($item) {return in_array($item['name'],['slug']);})
            ->sortByDesc(function ($item) {return in_array($item['name'],['id']);})
            ->values()
            ;
    }

    protected function getVisibleColumns($tableName, $modelVariableName): Collection
    {
        $relationships = $this->setBelongsToRelations();
        $columns = $this->readColumnsFromTable($tableName);
        $hasSoftDelete = ($columns->filter(function($column) {
                return $column['name'] == "deleted_at";
            })->count() > 0);
        $filtered = $columns->filter(function($column) {
            return !($column['name'] == "id" || $column['name'] == "created_at" || $column['name'] == "updated_at" || $column['name'] == "deleted_at" || $column['name'] == "remember_token");
        });
        return $filtered->map(function($column) use ($tableName, $hasSoftDelete, $modelVariableName,$filtered,$relationships){
            $serverStoreRules = collect([]);
            $serverUpdateRules = collect([]);
            $frontendRules = collect([]);
            if ($column['required']) {
                $serverStoreRules->push('\'required\'');
                $serverUpdateRules->push('\'sometimes\'');
                if($column['type'] != 'boolean' && $column['name'] != 'password') {
                    $frontendRules->push('required');
                }
            } else {
                $serverStoreRules->push('\'nullable\'');
                $serverUpdateRules->push('\'nullable\'');
            }

            if ($column['name'] == 'email') {
                $serverStoreRules->push('\'email\'');
                $serverUpdateRules->push('\'email\'');
                $frontendRules->push('email');
            }

            if ($column['name'] == 'password') {
                $serverStoreRules->push('\'confirmed\'');
                $serverUpdateRules->push('\'confirmed\'');
                $frontendRules->push('confirmed:password');

                $serverStoreRules->push('\'min:7\'');
                $serverUpdateRules->push('\'min:7\'');
                $frontendRules->push('min:7');

                $serverStoreRules->push('\'regex:/^.*(?=.{3,})(?=.*[a-zA-Z])(?=.*[0-9]).*$/\'');
                $serverUpdateRules->push('\'regex:/^.*(?=.{3,})(?=.*[a-zA-Z])(?=.*[0-9]).*$/\'');
                //TODO not working, need fixing
//                $frontendRules->push(''regex:/^.*(?=.{3,})(?=.*[a-zA-Z])(?=.*[0-9])(?=.*[!$#%]).*$/g'');
            }

            if($column['unique'] || $column['name'] == 'slug') {
                if($column['type'] == 'json') {
                    if (count($column['unique_indexes']) == 1) {
                        $storeRule = 'Rule::unique(\''.$tableName.'\', \''.$column['name'].'->\'.$locale)';
                        $updateRule = 'Rule::unique(\''.$tableName.'\', \''.$column['name'].'->\'.$locale)->ignore($this->'.$modelVariableName.'->getKey(), $this->'.$modelVariableName.'->getKeyName())';
                        if($hasSoftDelete && $column['unique_deleted_at_condition']) {
                            $storeRule .= '->whereNull(\'deleted_at\')';
                            $updateRule .= '->whereNull(\'deleted_at\')';
                        }
                        $cols = $column['unique_indexes'][0]->getColumns();
                        if (count($cols) > 1) {
                            $otherCols = collect($cols)->reject(function ($col) use ($column) { return $col ===$column['name'];});
                            foreach ($otherCols as $otherCol) {
                                $storeRule .= '->where('.$otherCol.',$this->'.$otherCol.')';
                                $updateRule .= '->where('.$otherCol.',$this->'.$otherCol.')';
                            }
                        }
                        $serverStoreRules->push($storeRule);
                        $serverUpdateRules->push($updateRule);
                    }
                } else {
                    if (count($column['unique_indexes']) == 1) {
                        $storeRule = 'Rule::unique(\''.$tableName.'\', \''.$column['name'].'\')';
                        $updateRule = 'Rule::unique(\''.$tableName.'\', \''.$column['name'].'\')';
                        if($hasSoftDelete && $column['unique_deleted_at_condition']) {
                            $storeRule .= '->whereNull(\'deleted_at\')';
                            $updateRule .= '->whereNull(\'deleted_at\')';
                        }
                        $cols = $column['unique_indexes']->first()->getColumns();
                        if (count($cols) > 1) {
                            $otherCols = collect($cols)->reject(function ($col) use ($column) { return $col ===$column['name'];});
                            foreach ($otherCols as $otherCol) {
                                if ($filtered->keyBy("name")->has($otherCol)) {
                                    $otherRel = $otherCol;
                                    $otherKey = '';
                                } elseif ($relationships->keyBy("name")->has($otherCol)) {
                                    $otherRel = $relationships->get($otherCol)['relationship_variable'];
                                    $ownerKey = $relationships->get($otherCol)["owner_key"];
                                    $otherKey = $ownerKey;
                                } else {
                                    $otherRel = null;
                                    $otherKey = null;
                                }
                                if ($otherRel) {
                                    if ($otherKey) {
                                        $where = 'collect($this->'.$otherRel.')->get(\''.$otherKey.'\')';
                                    } else {
                                        $where = $otherRel;
                                    }
                                    $storeRule .= '->where("'.$otherCol.'", $this->'.$where.')';
                                    $updateRule .= '->where("'.$otherCol.'",$this->'.$where.')';

                                }
                            }
                        }
                        $updateRule .= '->ignore($this->'.$modelVariableName.'->getKey(), $this->'.$modelVariableName.'->getKeyName())';
                        $serverStoreRules->push($storeRule);
                        $serverUpdateRules->push($updateRule);
                    }
                }
            }

            switch ($column['type']) {
                case 'datetime':
                    $serverStoreRules->push('\'date\'');
                    $serverUpdateRules->push('\'date\'');
                    $frontendRules->push('date_format:yyyy-MM-dd HH:mm:ss');
                    break;
                case 'date':
                    $serverStoreRules->push('\'date\'');
                    $serverUpdateRules->push('\'date\'');
                    $frontendRules->push('date_format:yyyy-MM-dd');
                    break;
                case 'time':
                    $serverStoreRules->push('\'date_format:H:i:s\'');
                    $serverUpdateRules->push('\'date_format:H:i:s\'');
                    $frontendRules->push('date_format:HH:mm:ss');
                    break;

                case 'tinyInteger':
                case 'smallInteger':
                case 'mediumInteger':
                case 'bigInteger':
                case 'bigint':
                case 'unsignedInteger':
                case 'unsignedTinyInteger':
                case 'unsignedSmallInteger':
                case 'unsignedMediumInteger':
                case 'unsignedBigInteger':
                case 'integer':
                    $serverStoreRules->push('\'integer\'');
                    $serverUpdateRules->push('\'integer\'');
                    $frontendRules->push('integer');
                    break;

                case 'boolean':
                    $serverStoreRules->push('\'boolean\'');
                    $serverUpdateRules->push('\'boolean\'');
                    $frontendRules->push('');
                    break;
                case 'float':
                    $serverStoreRules->push('\'numeric\'');
                    $serverUpdateRules->push('\'numeric\'');
                    $frontendRules->push('decimal');
                    break;
                case 'decimal':
                    $serverStoreRules->push('\'numeric\'');
                    $serverUpdateRules->push('\'numeric\'');
                    $frontendRules->push('decimal'); // FIXME?? I'm not sure about this one
                    break;
                case 'text':
                case 'string':
                    $serverStoreRules->push('\'string\'');
                    $serverUpdateRules->push('\'string\'');
                    break;
                default:
                    $serverStoreRules->push('\'string\'');
                    $serverUpdateRules->push('\'string\'');
            }

            return [
                'name' => $column['name'],
                'type' => $column['type'],
                'label' => Str::title(str_replace("-"," ",Str::slug($column["name"]))),
                'serverStoreRules' => $serverStoreRules->toArray(),
                'serverUpdateRules' => $serverUpdateRules->toArray(),
                'frontendRules' => $frontendRules->toArray(),
            ];
        });
    }

    protected function setBelongsToRelations(): Collection
    {
        $relationships = collect(app('db')->connection()->getDoctrineSchemaManager()->listTableForeignKeys($this->tableName))->map(function($fk) {
class MyClass { }

$x = new MyClass();
$x->foo = true;
            /**@var ForeignKeyConstraint $fk*/
            $columns = $this->readColumnsFromTable($fk->getForeignTableName())->filter(function($column) {
                return in_array($column["name"],["name", "display_name","title"]) || in_array($column["type"],["string"]);
            })->pluck("name");
            $labelColumn = $columns->filter(function($column){return in_array($column, [
                    'name','display_name', 'title'
                ]);
            })->first();
            if (!$labelColumn) $labelColumn = $columns->filter(function($column){return $column==='title';})->first();
            if (!$labelColumn) $labelColumn = $columns->filter(function($column){return $column==='name';})->first();
            if (!$labelColumn) $labelColumn = $columns->first();
            if (!$labelColumn) $labelColumn = "id";
            $functionName = collect($fk->getColumns())->first();
            if (str_contains($functionName,"_id")) {$functionName = Str::singular(str_replace("_id","",$functionName));} else {
                $functionName =Str::singular($functionName)."_model";
            }
            $functionName = Str::camel($functionName);
            $relatedTitle = Str::title(str_replace("_"," ",Str::snake(Str::studly($functionName))));
            return [
                "function_name" => $functionName,
                "related_table" => $fk->getForeignTableName(),
                "related_route_name" => Str::slug(Str::pluralStudly($fk->getForeignTableName())),
                "related_model" => "\\$this->modelNamespace\\". Str::studly(Str::singular($fk->getForeignTableName())).'::class',
class MyClass { }

$x = new MyClass();
$x->foo = true;
                "related_model_title" => $relatedTitle,
                "label_column" => $labelColumn,
                "relationship_variable" => Str::snake($functionName),
                "foreign_key" => collect($fk->getColumns())->first(),
                "owner_key" => collect($fk->getForeignColumns())->first(),
            ];
        })->keyBy('foreign_key');
        $this->relations["belongsTo"] = $relationships;
class MyClass { }

$x = new MyClass();
$x->foo = true;
        return $relationships;
    }

}


1		<?php namespace Savannabits\JetstreamInertiaGenerator\Generators\Traits;
2
3		use Doctrine\DBAL\DriverManager;
4		use Doctrine\DBAL\Schema\ForeignKeyConstraint;
5		use Illuminate\Database\Capsule\Manager;
6		use Illuminate\Database\DatabaseManager;
7		use Illuminate\Support\Collection;
8		use Illuminate\Support\Facades\Schema;
9		use Illuminate\Support\Str;
10		trait Columns {
11
12		/**
13		* @param $tableName
14		* @return Collection
15		*/
16		protected function readColumnsFromTable($tableName): Collection
17		{
18
19		// TODO how to process jsonb & json translatable columns? need to figure it out
20
21		$indexes = collect(Schema::getConnection()->getDoctrineSchemaManager()->listTableIndexes($tableName));
		0 ignored issues – show Bug introduced 2021-05-01 12:43 UTC by Report Bug Copy Issue Report The method `getConnection()` does not exist on `Illuminate\Support\Facades\Schema`. Did you maybe mean `connection()`? This check marks calls to methods that do not seem to exist on an object. This is most likely the result of a method being renamed without all references to it being renamed likewise. Loading history...
22		return collect(Schema::getColumnListing($tableName))->map(function($columnName) use ($tableName, $indexes) {
23
24		//Checked unique index
25		$columnUniqueIndexes = $indexes->filter(function($index) use ($columnName) {
26		return in_array($columnName, $index->getColumns()) && ($index->isUnique() && !$index->isPrimary());
27		});
28		$columnPrimaryIndex = $indexes->filter(function($index) use ($columnName) {
29		return in_array($columnName,$index->getColumns()) && $index->isPrimary();
30		});
31		$columnUniqueDeleteAtCondition = $columnUniqueIndexes->filter(function($index) {
32		return $index->hasOption('where') && $index->getOption('where') == '(deleted_at IS NULL)';
33		});
34
35		// TODO add foreign key
36
37		return [
38		'name' => $columnName,
39		'primary' => $columnPrimaryIndex->count() > 0,
40		'label' => Str::title(str_replace("-"," ",Str::slug($columnName))),
41		'type' => Schema::getColumnType($tableName, $columnName),
42		'required' => boolval(Schema::getConnection()->getDoctrineColumn($tableName, $columnName)->getNotnull()),
		0 ignored issues – show Bug introduced 2021-05-01 12:43 UTC by Report Bug Copy Issue Report The method `getConnection()` does not exist on `Illuminate\Support\Facades\Schema`. Did you maybe mean `connection()`? This check marks calls to methods that do not seem to exist on an object. This is most likely the result of a method being renamed without all references to it being renamed likewise. Loading history...
43		'unique' => $columnUniqueIndexes->count() > 0,
44		'unique_indexes' => $columnUniqueIndexes,
45		'unique_deleted_at_condition' => $columnUniqueDeleteAtCondition->count() > 0,
46		];
47		})
48		/*->sortByDesc(function ($item) {return $item['type']==='json';})
49		->sortByDesc(function ($item) {return $item['type']==='longText';})
50		->sortByDesc(function ($item) {return $item['type']==='time';})
51		->sortByDesc(function ($item) {return $item['type']==='tinyinteger';})
52		->sortByDesc(function ($item) {return $item['type']==='bigInteger';})
53		->sortByDesc(function ($item) {return $item['type']==='mediumInteger';})
54		->sortByDesc(function ($item) {return $item['type']==='integer';})
55		->sortByDesc(function ($item) {return $item['type']==='float';})
56		->sortByDesc(function ($item) {return $item['type']==='double';})
57		->sortByDesc(function ($item) {return $item['type']==='text';})
58		->sortByDesc(function ($item) {return $item['name']==='amount';})*/
59		->sortByDesc(function ($item) {return $item['type']==='boolean';})
60		->sortByDesc(function ($item) {return $item['type']==='datetime'&& !in_array($item['name'],['created_at','updated_at']);})
61		->sortByDesc(function ($item) {return $item['type']==='date';})
62		->sortByDesc(function ($item) {return $item['type']==='float';})
63		// ->sortByDesc(function ($item) {return $item['type']==='double';})
64	View Code Duplication	->sortByDesc(function ($item) {return $item['type']==='text' && !in_array($item['name'],["description",'details','content','body','text']);})
		0 ignored issues – show Duplication introduced 2021-04-26 07:39 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
65		->sortByDesc(function ($item) {return $item['type']==='string' && !in_array($item['name'],["description",'details','content','body','text','middle_name','other_names','first_name','last_name','surname','title','headline','name','display_name','slug']);})
66	View Code Duplication	->sortByDesc(function ($item) {return in_array($item['name'],["description",'details','content','body','text']);})
		0 ignored issues – show Duplication introduced 2021-04-26 07:39 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
67		->sortByDesc(function ($item) {return in_array($item['name'],['middle_name','other_names']);})
68		->sortByDesc(function ($item) {return in_array($item['name'],['first_name','last_name','surname']);})
69		->sortByDesc(function ($item) {return in_array($item['name'],['headline']);})
70		->sortByDesc(function ($item) {return in_array($item['name'],['display_name']);})
71		->sortByDesc(function ($item) {return in_array($item['name'],['title']);})
72		->sortByDesc(function ($item) {return in_array($item['name'],['name']);})
73		->sortByDesc(function ($item) {return in_array($item['name'],['slug']);})
74		->sortByDesc(function ($item) {return in_array($item['name'],['id']);})
75		->values()
76		;
77		}
78
79		protected function getVisibleColumns($tableName, $modelVariableName): Collection
80		{
81		$relationships = $this->setBelongsToRelations();
82		$columns = $this->readColumnsFromTable($tableName);
83		$hasSoftDelete = ($columns->filter(function($column) {
84		return $column['name'] == "deleted_at";
85		})->count() > 0);
86		$filtered = $columns->filter(function($column) {
87		return !($column['name'] == "id" \|\| $column['name'] == "created_at" \|\| $column['name'] == "updated_at" \|\| $column['name'] == "deleted_at" \|\| $column['name'] == "remember_token");
88		});
89		return $filtered->map(function($column) use ($tableName, $hasSoftDelete, $modelVariableName,$filtered,$relationships){
90		$serverStoreRules = collect([]);
91		$serverUpdateRules = collect([]);
92		$frontendRules = collect([]);
93		if ($column['required']) {
94		$serverStoreRules->push('\'required\'');
95		$serverUpdateRules->push('\'sometimes\'');
96		if($column['type'] != 'boolean' && $column['name'] != 'password') {
97		$frontendRules->push('required');
98		}
99		} else {
100		$serverStoreRules->push('\'nullable\'');
101		$serverUpdateRules->push('\'nullable\'');
102		}
103
104		if ($column['name'] == 'email') {
105		$serverStoreRules->push('\'email\'');
106		$serverUpdateRules->push('\'email\'');
107		$frontendRules->push('email');
108		}
109
110		if ($column['name'] == 'password') {
111		$serverStoreRules->push('\'confirmed\'');
112		$serverUpdateRules->push('\'confirmed\'');
113		$frontendRules->push('confirmed:password');
114
115		$serverStoreRules->push('\'min:7\'');
116		$serverUpdateRules->push('\'min:7\'');
117		$frontendRules->push('min:7');
118
119		$serverStoreRules->push('\'regex:/^.(?=.{3,})(?=.[a-zA-Z])(?=.[0-9]).$/\'');
120		$serverUpdateRules->push('\'regex:/^.(?=.{3,})(?=.[a-zA-Z])(?=.[0-9]).$/\'');
121		//TODO not working, need fixing
122		// $frontendRules->push(''regex:/^.(?=.{3,})(?=.[a-zA-Z])(?=.[0-9])(?=.[!$#%]).*$/g'');
123		}
124
125		if($column['unique'] \|\| $column['name'] == 'slug') {
126		if($column['type'] == 'json') {
127		if (count($column['unique_indexes']) == 1) {
128		$storeRule = 'Rule::unique(\''.$tableName.'\', \''.$column['name'].'->\'.$locale)';
129		$updateRule = 'Rule::unique(\''.$tableName.'\', \''.$column['name'].'->\'.$locale)->ignore($this->'.$modelVariableName.'->getKey(), $this->'.$modelVariableName.'->getKeyName())';
130		if($hasSoftDelete && $column['unique_deleted_at_condition']) {
131		$storeRule .= '->whereNull(\'deleted_at\')';
132		$updateRule .= '->whereNull(\'deleted_at\')';
133		}
134		$cols = $column['unique_indexes'][0]->getColumns();
135		if (count($cols) > 1) {
136		$otherCols = collect($cols)->reject(function ($col) use ($column) { return $col ===$column['name'];});
137		foreach ($otherCols as $otherCol) {
138		$storeRule .= '->where('.$otherCol.',$this->'.$otherCol.')';
139		$updateRule .= '->where('.$otherCol.',$this->'.$otherCol.')';
140		}
141		}
142		$serverStoreRules->push($storeRule);
143		$serverUpdateRules->push($updateRule);
144		}
145		} else {
146		if (count($column['unique_indexes']) == 1) {
147		$storeRule = 'Rule::unique(\''.$tableName.'\', \''.$column['name'].'\')';
148		$updateRule = 'Rule::unique(\''.$tableName.'\', \''.$column['name'].'\')';
149		if($hasSoftDelete && $column['unique_deleted_at_condition']) {
150		$storeRule .= '->whereNull(\'deleted_at\')';
151		$updateRule .= '->whereNull(\'deleted_at\')';
152		}
153		$cols = $column['unique_indexes']->first()->getColumns();
154		if (count($cols) > 1) {
155		$otherCols = collect($cols)->reject(function ($col) use ($column) { return $col ===$column['name'];});
156		foreach ($otherCols as $otherCol) {
157		if ($filtered->keyBy("name")->has($otherCol)) {
158		$otherRel = $otherCol;
159		$otherKey = '';
160		} elseif ($relationships->keyBy("name")->has($otherCol)) {
161		$otherRel = $relationships->get($otherCol)['relationship_variable'];
162		$ownerKey = $relationships->get($otherCol)["owner_key"];
163		$otherKey = $ownerKey;
164		} else {
165		$otherRel = null;
166		$otherKey = null;
167		}
168		if ($otherRel) {
169		if ($otherKey) {
170		$where = 'collect($this->'.$otherRel.')->get(\''.$otherKey.'\')';
171		} else {
172		$where = $otherRel;
173		}
174		$storeRule .= '->where("'.$otherCol.'", $this->'.$where.')';
175		$updateRule .= '->where("'.$otherCol.'",$this->'.$where.')';
176
177		}
178		}
179		}
180		$updateRule .= '->ignore($this->'.$modelVariableName.'->getKey(), $this->'.$modelVariableName.'->getKeyName())';
181		$serverStoreRules->push($storeRule);
182		$serverUpdateRules->push($updateRule);
183		}
184		}
185		}
186
187		switch ($column['type']) {
188		case 'datetime':
189		$serverStoreRules->push('\'date\'');
190		$serverUpdateRules->push('\'date\'');
191		$frontendRules->push('date_format:yyyy-MM-dd HH:mm:ss');
192		break;
193		case 'date':
194		$serverStoreRules->push('\'date\'');
195		$serverUpdateRules->push('\'date\'');
196		$frontendRules->push('date_format:yyyy-MM-dd');
197		break;
198		case 'time':
199		$serverStoreRules->push('\'date_format:H:i:s\'');
200		$serverUpdateRules->push('\'date_format:H:i:s\'');
201		$frontendRules->push('date_format:HH:mm:ss');
202		break;
203
204		case 'tinyInteger':
205		case 'smallInteger':
206		case 'mediumInteger':
207		case 'bigInteger':
208		case 'bigint':
209		case 'unsignedInteger':
210		case 'unsignedTinyInteger':
211		case 'unsignedSmallInteger':
212		case 'unsignedMediumInteger':
213		case 'unsignedBigInteger':
214		case 'integer':
215		$serverStoreRules->push('\'integer\'');
216		$serverUpdateRules->push('\'integer\'');
217		$frontendRules->push('integer');
218		break;
219
220		case 'boolean':
221		$serverStoreRules->push('\'boolean\'');
222		$serverUpdateRules->push('\'boolean\'');
223		$frontendRules->push('');
224		break;
225		case 'float':
226		$serverStoreRules->push('\'numeric\'');
227		$serverUpdateRules->push('\'numeric\'');
228		$frontendRules->push('decimal');
229		break;
230		case 'decimal':
231		$serverStoreRules->push('\'numeric\'');
232		$serverUpdateRules->push('\'numeric\'');
233		$frontendRules->push('decimal'); // FIXME?? I'm not sure about this one
234		break;
235		case 'text':
236		case 'string':
237		$serverStoreRules->push('\'string\'');
238		$serverUpdateRules->push('\'string\'');
239		break;
240		default:
241		$serverStoreRules->push('\'string\'');
242		$serverUpdateRules->push('\'string\'');
243		}
244
245		return [
246		'name' => $column['name'],
247		'type' => $column['type'],
248		'label' => Str::title(str_replace("-"," ",Str::slug($column["name"]))),
249		'serverStoreRules' => $serverStoreRules->toArray(),
250		'serverUpdateRules' => $serverUpdateRules->toArray(),
251		'frontendRules' => $frontendRules->toArray(),
252		];
253		});
254		}
255
256		protected function setBelongsToRelations(): Collection
257		{
258		$relationships = collect(app('db')->connection()->getDoctrineSchemaManager()->listTableForeignKeys($this->tableName))->map(function($fk) {
		0 ignored issues – show Bug introduced 2021-04-26 07:39 UTC by Report Bug Copy Issue Report The property `tableName` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
259		/*@var ForeignKeyConstraint $fk/
260		$columns = $this->readColumnsFromTable($fk->getForeignTableName())->filter(function($column) {
261		return in_array($column["name"],["name", "display_name","title"]) \|\| in_array($column["type"],["string"]);
262		})->pluck("name");
263		$labelColumn = $columns->filter(function($column){return in_array($column, [
264		'name','display_name', 'title'
265		]);
266		})->first();
267		if (!$labelColumn) $labelColumn = $columns->filter(function($column){return $column==='title';})->first();
268		if (!$labelColumn) $labelColumn = $columns->filter(function($column){return $column==='name';})->first();
269		if (!$labelColumn) $labelColumn = $columns->first();
270		if (!$labelColumn) $labelColumn = "id";
271		$functionName = collect($fk->getColumns())->first();
272		if (str_contains($functionName,"_id")) {$functionName = Str::singular(str_replace("_id","",$functionName));} else {
273		$functionName =Str::singular($functionName)."_model";
274		}
275		$functionName = Str::camel($functionName);
276		$relatedTitle = Str::title(str_replace("_"," ",Str::snake(Str::studly($functionName))));
277		return [
278		"function_name" => $functionName,
279		"related_table" => $fk->getForeignTableName(),
280		"related_route_name" => Str::slug(Str::pluralStudly($fk->getForeignTableName())),
281		"related_model" => "\\$this->modelNamespace\\". Str::studly(Str::singular($fk->getForeignTableName())).'::class',
		0 ignored issues – show Bug introduced 2021-04-26 07:39 UTC by Report Bug Copy Issue Report The property `modelNamespace` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
282		"related_model_title" => $relatedTitle,
283		"label_column" => $labelColumn,
284		"relationship_variable" => Str::snake($functionName),
285		"foreign_key" => collect($fk->getColumns())->first(),
286		"owner_key" => collect($fk->getForeignColumns())->first(),
287		];
288		})->keyBy('foreign_key');
289		$this->relations["belongsTo"] = $relationships;
		0 ignored issues – show Bug introduced 2021-04-26 07:39 UTC by Report Bug Copy Issue Report The property `relations` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
290		return $relationships;
291		}
292
293		}
294

coolsam726 / jetstream-inertia-generator

Columns::setBelongsToRelations() B last analyzed 2021-05-18 05:13 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Columns::setBelongsToRelations() B
last analyzed 2021-05-18 05:13 UTC