@@ -63,13 +63,13 @@ discard block |
||
| 63 | 63 | |
| 64 | 64 | if (is_array($value) && is_object($value[0])) {//check whether it's a array and it's firs element is a object |
| 65 | 65 | |
| 66 | - $table_data = $this->getTable($prefix . $table_name, $value);//get table sql |
|
| 66 | + $table_data = $this->getTable($prefix.$table_name, $value); //get table sql |
|
| 67 | 67 | $this->table[$table_data['name']] = $table_data['column']; |
| 68 | 68 | |
| 69 | - $this->toMysqlTables($this->getHighestColumnArray($value), $prefix . $table_name . '_');//get it inside tables |
|
| 69 | + $this->toMysqlTables($this->getHighestColumnArray($value), $prefix.$table_name.'_'); //get it inside tables |
|
| 70 | 70 | } elseif (is_array($value) || is_object($value)) {//if it's a array and firs element is not a object |
| 71 | 71 | |
| 72 | - $table_data = $this->getTable($prefix . $table_name, $value); |
|
| 72 | + $table_data = $this->getTable($prefix.$table_name, $value); |
|
| 73 | 73 | $this->table[$table_data['name']] = $table_data['column']; |
| 74 | 74 | } |
| 75 | 75 | |
@@ -90,13 +90,13 @@ discard block |
||
| 90 | 90 | } |
| 91 | 91 | foreach ($data as $table_name => $value) { |
| 92 | 92 | if ($this->snake_case_table) { |
| 93 | - $table_name = $this->snakeCase($prefix . $table_name); |
|
| 93 | + $table_name = $this->snakeCase($prefix.$table_name); |
|
| 94 | 94 | } |
| 95 | 95 | if (is_array($value) && is_object($value[0])) {//if it's a array and firs element is not a object |
| 96 | - $this->toMysqlData($value, $table_name . '_'); |
|
| 96 | + $this->toMysqlData($value, $table_name.'_'); |
|
| 97 | 97 | |
| 98 | 98 | } elseif (is_object($value) || is_array($value)) { |
| 99 | - $this->toMysqlData($value, $table_name . '_'); |
|
| 99 | + $this->toMysqlData($value, $table_name.'_'); |
|
| 100 | 100 | $this->getTableData($table_name, $value); |
| 101 | 101 | |
| 102 | 102 | } |
@@ -135,7 +135,7 @@ discard block |
||
| 135 | 135 | foreach ($value as $item_value) |
| 136 | 136 | $DataItem[] = ['value' => $item_value]; |
| 137 | 137 | |
| 138 | - $this->data[$table_name] = array_merge(($this->data[$table_name]??[]),$DataItem); |
|
| 138 | + $this->data[$table_name] = array_merge(($this->data[$table_name]??[]), $DataItem); |
|
| 139 | 139 | |
| 140 | 140 | } |
| 141 | 141 | |
@@ -170,7 +170,7 @@ discard block |
||
| 170 | 170 | if ($this->snake_case_column) |
| 171 | 171 | return [ |
| 172 | 172 | 'name' => $table, |
| 173 | - 'column' => array_map(function ($item) { |
|
| 173 | + 'column' => array_map(function($item) { |
|
| 174 | 174 | return [ |
| 175 | 175 | 'name' => $this->snakeCase($item['name']), |
| 176 | 176 | 'type' => $item['type'] |
@@ -340,13 +340,13 @@ discard block |
||
| 340 | 340 | } elseif (is_numeric($item)) { |
| 341 | 341 | $value[] = $item; |
| 342 | 342 | } else { |
| 343 | - $value[] = '"' . addcslashes($item, "W") . '"'; |
|
| 343 | + $value[] = '"'.addcslashes($item, "W").'"'; |
|
| 344 | 344 | } |
| 345 | 345 | } |
| 346 | - $String[] = '(' . implode(",", $value) . ')'; |
|
| 346 | + $String[] = '('.implode(",", $value).')'; |
|
| 347 | 347 | } |
| 348 | 348 | |
| 349 | - return "values" . implode(", ", $String); |
|
| 349 | + return "values".implode(", ", $String); |
|
| 350 | 350 | } |
| 351 | 351 | |
| 352 | 352 | /** |
@@ -357,7 +357,7 @@ discard block |
||
| 357 | 357 | { |
| 358 | 358 | $String = []; |
| 359 | 359 | foreach ($array as $column) { |
| 360 | - $String[] = "`" . JsonExtractor::snakeCase($column['name']) . "`"; |
|
| 360 | + $String[] = "`".JsonExtractor::snakeCase($column['name'])."`"; |
|
| 361 | 361 | } |
| 362 | 362 | |
| 363 | 363 | return implode(",", $String); |
@@ -377,7 +377,7 @@ discard block |
||
| 377 | 377 | } elseif (empty($Data)) { |
| 378 | 378 | return $empty_val; |
| 379 | 379 | } else { |
| 380 | - return (string)$Data; |
|
| 380 | + return (string) $Data; |
|
| 381 | 381 | } |
| 382 | 382 | } |
| 383 | 383 | } |
@@ -132,8 +132,9 @@ discard block |
||
| 132 | 132 | $this->data[$table_name][] = $DataItem; |
| 133 | 133 | |
| 134 | 134 | } elseif (is_array($value)) {//reference table |
| 135 | - foreach ($value as $item_value) |
|
| 136 | - $DataItem[] = ['value' => $item_value]; |
|
| 135 | + foreach ($value as $item_value) { |
|
| 136 | + $DataItem[] = ['value' => $item_value]; |
|
| 137 | + } |
|
| 137 | 138 | |
| 138 | 139 | $this->data[$table_name] = array_merge(($this->data[$table_name]??[]),$DataItem); |
| 139 | 140 | |
@@ -167,23 +168,25 @@ discard block |
||
| 167 | 168 | ]; |
| 168 | 169 | } |
| 169 | 170 | |
| 170 | - if ($this->snake_case_column) |
|
| 171 | - return [ |
|
| 171 | + if ($this->snake_case_column) { |
|
| 172 | + return [ |
|
| 172 | 173 | 'name' => $table, |
| 173 | 174 | 'column' => array_map(function ($item) { |
| 174 | 175 | return [ |
| 175 | 176 | 'name' => $this->snakeCase($item['name']), |
| 176 | 177 | 'type' => $item['type'] |
| 177 | 178 | ]; |
| 179 | + } |
|
| 178 | 180 | |
| 179 | 181 | }, $last_columns) |
| 180 | 182 | ]; |
| 181 | 183 | |
| 182 | - else |
|
| 183 | - return [ |
|
| 184 | + else { |
|
| 185 | + return [ |
|
| 184 | 186 | 'name' => $table, |
| 185 | 187 | 'column' => $last_columns |
| 186 | 188 | ]; |
| 189 | + } |
|
| 187 | 190 | } |
| 188 | 191 | |
| 189 | 192 | /** |