@@ -27,17 +27,17 @@ |
||
27 | 27 | * @var array |
28 | 28 | **/ |
29 | 29 | protected $selects = [ |
30 | - 'column_name as Field', |
|
31 | - 'column_type as Type', |
|
32 | - 'is_nullable as Nullable', |
|
33 | - 'column_key as Key', |
|
34 | - 'column_default as Default', |
|
35 | - 'extra as Extra', |
|
36 | - 'data_type as Data_Type', |
|
37 | - 'CHARACTER_MAXIMUM_LENGTH as Length', |
|
38 | - 'NUMERIC_PRECISION as Precision', |
|
39 | - 'NUMERIC_SCALE as Scale', |
|
40 | - ]; |
|
30 | + 'column_name as Field', |
|
31 | + 'column_type as Type', |
|
32 | + 'is_nullable as Nullable', |
|
33 | + 'column_key as Key', |
|
34 | + 'column_default as Default', |
|
35 | + 'extra as Extra', |
|
36 | + 'data_type as Data_Type', |
|
37 | + 'CHARACTER_MAXIMUM_LENGTH as Length', |
|
38 | + 'NUMERIC_PRECISION as Precision', |
|
39 | + 'NUMERIC_SCALE as Scale', |
|
40 | + ]; |
|
41 | 41 | /** |
42 | 42 | * Select fields from constraints. |
43 | 43 | * |
@@ -7,42 +7,42 @@ |
||
7 | 7 | |
8 | 8 | public function saveData($table, $item) |
9 | 9 | { |
10 | - // If have primary id |
|
11 | - if(isset($item['id'])) |
|
12 | - { |
|
13 | - if(\DB::table($table)->where('id', $item['id'])->count() > 0) |
|
14 | - { |
|
15 | - \DB::table($table)->where('id', $item['id'])->update($item); |
|
16 | - } |
|
17 | - else |
|
18 | - { |
|
19 | - \DB::table($table)->insert($item); |
|
20 | - } |
|
10 | + // If have primary id |
|
11 | + if(isset($item['id'])) |
|
12 | + { |
|
13 | + if(\DB::table($table)->where('id', $item['id'])->count() > 0) |
|
14 | + { |
|
15 | + \DB::table($table)->where('id', $item['id'])->update($item); |
|
16 | + } |
|
17 | + else |
|
18 | + { |
|
19 | + \DB::table($table)->insert($item); |
|
20 | + } |
|
21 | 21 | } |
22 | 22 | else |
23 | 23 | { |
24 | - $ids = collect($item)->filter(function($item, $key) { |
|
25 | - return str_contains($key, '_id'); |
|
26 | - })->keys()->values(); |
|
24 | + $ids = collect($item)->filter(function($item, $key) { |
|
25 | + return str_contains($key, '_id'); |
|
26 | + })->keys()->values(); |
|
27 | 27 | |
28 | - // If there isnt any column with _id, so check that every column matches |
|
29 | - if($ids->count() <= 0) { |
|
30 | - $ids = collect($item)->keys()->values(); |
|
31 | - } |
|
32 | - $object = \DB::table($table); |
|
33 | - foreach ($ids as $id) { |
|
34 | - $object = $object->where($id, $item[$id]); |
|
35 | - } |
|
28 | + // If there isnt any column with _id, so check that every column matches |
|
29 | + if($ids->count() <= 0) { |
|
30 | + $ids = collect($item)->keys()->values(); |
|
31 | + } |
|
32 | + $object = \DB::table($table); |
|
33 | + foreach ($ids as $id) { |
|
34 | + $object = $object->where($id, $item[$id]); |
|
35 | + } |
|
36 | 36 | |
37 | - // save or update |
|
38 | - if($object->count() > 0) |
|
39 | - { |
|
40 | - $object->update($item); |
|
41 | - } |
|
42 | - else |
|
43 | - { |
|
44 | - $object->insert($item); |
|
45 | - } |
|
37 | + // save or update |
|
38 | + if($object->count() > 0) |
|
39 | + { |
|
40 | + $object->update($item); |
|
41 | + } |
|
42 | + else |
|
43 | + { |
|
44 | + $object->insert($item); |
|
45 | + } |
|
46 | 46 | |
47 | 47 | } |
48 | 48 | } |