@@ -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 | } |