@@ -8,7 +8,7 @@ |
||
| 8 | 8 | // +---------------------------------------------------------------------- |
| 9 | 9 | // | Author: liu21st <[email protected]> |
| 10 | 10 | // +---------------------------------------------------------------------- |
| 11 | -declare (strict_types = 1); |
|
| 11 | +declare(strict_types=1); |
|
| 12 | 12 | |
| 13 | 13 | namespace think\db; |
| 14 | 14 | |
@@ -8,7 +8,7 @@ discard block |
||
| 8 | 8 | // +---------------------------------------------------------------------- |
| 9 | 9 | // | Author: liu21st <[email protected]> |
| 10 | 10 | // +---------------------------------------------------------------------- |
| 11 | -declare (strict_types = 1); |
|
| 11 | +declare(strict_types=1); |
|
| 12 | 12 | |
| 13 | 13 | namespace think\db\builder; |
| 14 | 14 | |
@@ -122,7 +122,7 @@ discard block |
||
| 122 | 122 | |
| 123 | 123 | $set = []; |
| 124 | 124 | foreach ($data as $key => $val) { |
| 125 | - $set[] = $key . ' = ' . $val; |
|
| 125 | + $set[] = $key.' = '.$val; |
|
| 126 | 126 | } |
| 127 | 127 | |
| 128 | 128 | return str_replace( |
@@ -167,7 +167,7 @@ discard block |
||
| 167 | 167 | foreach ($dataSet as $data) { |
| 168 | 168 | $data = $this->parseData($query, $data, $allowFields, $bind); |
| 169 | 169 | |
| 170 | - $values[] = '( ' . implode(',', array_values($data)) . ' )'; |
|
| 170 | + $values[] = '( '.implode(',', array_values($data)).' )'; |
|
| 171 | 171 | |
| 172 | 172 | if (!isset($insertFields)) { |
| 173 | 173 | $insertFields = array_keys($data); |
@@ -210,7 +210,7 @@ discard block |
||
| 210 | 210 | } |
| 211 | 211 | $set = []; |
| 212 | 212 | foreach ($data as $key => $val) { |
| 213 | - $set[] = $key . ' = ' . $val; |
|
| 213 | + $set[] = $key.' = '.$val; |
|
| 214 | 214 | } |
| 215 | 215 | |
| 216 | 216 | return str_replace( |
@@ -246,7 +246,7 @@ discard block |
||
| 246 | 246 | $this->parseTable($query, $options['table']), |
| 247 | 247 | $this->parsePartition($query, $options['partition']), |
| 248 | 248 | $this->parseExtra($query, $options['extra']), |
| 249 | - !empty($options['using']) ? ' USING ' . $this->parseTable($query, $options['using']) . ' ' : '', |
|
| 249 | + !empty($options['using']) ? ' USING '.$this->parseTable($query, $options['using']).' ' : '', |
|
| 250 | 250 | $this->parseJoin($query, $options['join']), |
| 251 | 251 | $this->parseWhere($query, $options['where']), |
| 252 | 252 | $this->parseOrder($query, $options['order']), |
@@ -273,7 +273,7 @@ discard block |
||
| 273 | 273 | $value = $value->getValue(); |
| 274 | 274 | } |
| 275 | 275 | |
| 276 | - return $key . ' ' . $exp . ' ' . $value; |
|
| 276 | + return $key.' '.$exp.' '.$value; |
|
| 277 | 277 | } |
| 278 | 278 | |
| 279 | 279 | /** |
@@ -292,7 +292,7 @@ discard block |
||
| 292 | 292 | $value = $value->getValue(); |
| 293 | 293 | } |
| 294 | 294 | |
| 295 | - return 'FIND_IN_SET(' . $value . ', ' . $key . ')'; |
|
| 295 | + return 'FIND_IN_SET('.$value.', '.$key.')'; |
|
| 296 | 296 | } |
| 297 | 297 | |
| 298 | 298 | /** |
@@ -316,7 +316,7 @@ discard block |
||
| 316 | 316 | if (strpos($key, '->') && false === strpos($key, '(')) { |
| 317 | 317 | // JSON字段支持 |
| 318 | 318 | list($field, $name) = explode('->', $key, 2); |
| 319 | - return 'json_extract(' . $this->parseKey($query, $field) . ', \'$' . (strpos($name, '[') === 0 ? '' : '.') . str_replace('->', '.', $name) . '\')'; |
|
| 319 | + return 'json_extract('.$this->parseKey($query, $field).', \'$'.(strpos($name, '[') === 0 ? '' : '.').str_replace('->', '.', $name).'\')'; |
|
| 320 | 320 | } elseif (strpos($key, '.') && !preg_match('/[,\'\"\(\)`\s]/', $key)) { |
| 321 | 321 | list($table, $key) = explode('.', $key, 2); |
| 322 | 322 | |
@@ -333,11 +333,11 @@ discard block |
||
| 333 | 333 | } |
| 334 | 334 | |
| 335 | 335 | if ($strict && !preg_match('/^[\w\.\*]+$/', $key)) { |
| 336 | - throw new Exception('not support data:' . $key); |
|
| 336 | + throw new Exception('not support data:'.$key); |
|
| 337 | 337 | } |
| 338 | 338 | |
| 339 | 339 | if ('*' != $key && !preg_match('/[,\'\"\*\(\)`.\s]/', $key)) { |
| 340 | - $key = '`' . $key . '`'; |
|
| 340 | + $key = '`'.$key.'`'; |
|
| 341 | 341 | } |
| 342 | 342 | |
| 343 | 343 | if (isset($table)) { |
@@ -345,7 +345,7 @@ discard block |
||
| 345 | 345 | $table = str_replace('.', '`.`', $table); |
| 346 | 346 | } |
| 347 | 347 | |
| 348 | - $key = '`' . $table . '`.' . $key; |
|
| 348 | + $key = '`'.$table.'`.'.$key; |
|
| 349 | 349 | } |
| 350 | 350 | |
| 351 | 351 | return $key; |
@@ -379,7 +379,7 @@ discard block |
||
| 379 | 379 | $partition = explode(',', $partition); |
| 380 | 380 | } |
| 381 | 381 | |
| 382 | - return ' PARTITION (' . implode(' , ', $partition) . ') '; |
|
| 382 | + return ' PARTITION ('.implode(' , ', $partition).') '; |
|
| 383 | 383 | } |
| 384 | 384 | |
| 385 | 385 | /** |
@@ -396,7 +396,7 @@ discard block |
||
| 396 | 396 | } |
| 397 | 397 | |
| 398 | 398 | if ($duplicate instanceof Raw) { |
| 399 | - return ' ON DUPLICATE KEY UPDATE ' . $duplicate->getValue() . ' '; |
|
| 399 | + return ' ON DUPLICATE KEY UPDATE '.$duplicate->getValue().' '; |
|
| 400 | 400 | } |
| 401 | 401 | |
| 402 | 402 | if (is_string($duplicate)) { |
@@ -407,15 +407,15 @@ discard block |
||
| 407 | 407 | foreach ($duplicate as $key => $val) { |
| 408 | 408 | if (is_numeric($key)) { |
| 409 | 409 | $val = $this->parseKey($query, $val); |
| 410 | - $updates[] = $val . ' = VALUES(' . $val . ')'; |
|
| 410 | + $updates[] = $val.' = VALUES('.$val.')'; |
|
| 411 | 411 | } elseif ($val instanceof Raw) { |
| 412 | - $updates[] = $this->parseKey($query, $key) . " = " . $val->getValue(); |
|
| 412 | + $updates[] = $this->parseKey($query, $key)." = ".$val->getValue(); |
|
| 413 | 413 | } else { |
| 414 | 414 | $name = $query->bindValue($val, $query->getConnection()->getFieldBindType($key)); |
| 415 | - $updates[] = $this->parseKey($query, $key) . " = :" . $name; |
|
| 415 | + $updates[] = $this->parseKey($query, $key)." = :".$name; |
|
| 416 | 416 | } |
| 417 | 417 | } |
| 418 | 418 | |
| 419 | - return ' ON DUPLICATE KEY UPDATE ' . implode(' , ', $updates) . ' '; |
|
| 419 | + return ' ON DUPLICATE KEY UPDATE '.implode(' , ', $updates).' '; |
|
| 420 | 420 | } |
| 421 | 421 | } |
@@ -8,7 +8,7 @@ discard block |
||
| 8 | 8 | // +---------------------------------------------------------------------- |
| 9 | 9 | // | Author: liu21st <[email protected]> |
| 10 | 10 | // +---------------------------------------------------------------------- |
| 11 | -declare (strict_types = 1); |
|
| 11 | +declare(strict_types=1); |
|
| 12 | 12 | |
| 13 | 13 | namespace think\db; |
| 14 | 14 | |
@@ -129,15 +129,15 @@ discard block |
||
| 129 | 129 | $name = App::parseName(substr($method, 5)); |
| 130 | 130 | array_unshift($args, $name); |
| 131 | 131 | return call_user_func_array([$this, 'where'], $args); |
| 132 | - } elseif ($this->model && method_exists($this->model, 'scope' . $method)) { |
|
| 132 | + } elseif ($this->model && method_exists($this->model, 'scope'.$method)) { |
|
| 133 | 133 | // 动态调用命名范围 |
| 134 | - $method = 'scope' . $method; |
|
| 134 | + $method = 'scope'.$method; |
|
| 135 | 135 | array_unshift($args, $this); |
| 136 | 136 | |
| 137 | 137 | call_user_func_array([$this->model, $method], $args); |
| 138 | 138 | return $this; |
| 139 | 139 | } else { |
| 140 | - throw new Exception('method not exist:' . static::class . '->' . $method); |
|
| 140 | + throw new Exception('method not exist:'.static::class.'->'.$method); |
|
| 141 | 141 | } |
| 142 | 142 | } |
| 143 | 143 | |
@@ -211,7 +211,7 @@ discard block |
||
| 211 | 211 | |
| 212 | 212 | $name = $name ?: $this->name; |
| 213 | 213 | |
| 214 | - return $this->prefix . App::parseName($name); |
|
| 214 | + return $this->prefix.App::parseName($name); |
|
| 215 | 215 | } |
| 216 | 216 | |
| 217 | 217 | /** |
@@ -436,10 +436,10 @@ discard block |
||
| 436 | 436 | $prefix = $prefix ?: $tableName; |
| 437 | 437 | foreach ($field as $key => &$val) { |
| 438 | 438 | if (is_numeric($key) && $alias) { |
| 439 | - $field[$prefix . '.' . $val] = $alias . $val; |
|
| 439 | + $field[$prefix.'.'.$val] = $alias.$val; |
|
| 440 | 440 | unset($field[$key]); |
| 441 | 441 | } elseif (is_numeric($key)) { |
| 442 | - $val = $prefix . '.' . $val; |
|
| 442 | + $val = $prefix.'.'.$val; |
|
| 443 | 443 | } |
| 444 | 444 | } |
| 445 | 445 | |
@@ -493,7 +493,7 @@ discard block |
||
| 493 | 493 | // 延迟写入 |
| 494 | 494 | $condition = $this->options['where'] ?? []; |
| 495 | 495 | |
| 496 | - $guid = md5($this->getTable() . '_' . $field . '_' . serialize($condition)); |
|
| 496 | + $guid = md5($this->getTable().'_'.$field.'_'.serialize($condition)); |
|
| 497 | 497 | $step = $this->connection->lazyWrite($op, $guid, $step, $lazyTime); |
| 498 | 498 | |
| 499 | 499 | if (false === $step) { |
@@ -561,7 +561,7 @@ discard block |
||
| 561 | 561 | */ |
| 562 | 562 | public function limit(int $offset, int $length = null) |
| 563 | 563 | { |
| 564 | - $this->options['limit'] = $offset . ($length ? ',' . $length : ''); |
|
| 564 | + $this->options['limit'] = $offset.($length ? ','.$length : ''); |
|
| 565 | 565 | |
| 566 | 566 | return $this; |
| 567 | 567 | } |
@@ -745,7 +745,7 @@ discard block |
||
| 745 | 745 | |
| 746 | 746 | if (is_string($field)) { |
| 747 | 747 | if (!empty($this->options['via'])) { |
| 748 | - $field = $this->options['via'] . '.' . $field; |
|
| 748 | + $field = $this->options['via'].'.'.$field; |
|
| 749 | 749 | } |
| 750 | 750 | if (strpos($field, ',')) { |
| 751 | 751 | $field = array_map('trim', explode(',', $field)); |
@@ -755,9 +755,9 @@ discard block |
||
| 755 | 755 | } elseif (!empty($this->options['via'])) { |
| 756 | 756 | foreach ($field as $key => $val) { |
| 757 | 757 | if (is_numeric($key)) { |
| 758 | - $field[$key] = $this->options['via'] . '.' . $val; |
|
| 758 | + $field[$key] = $this->options['via'].'.'.$val; |
|
| 759 | 759 | } else { |
| 760 | - $field[$this->options['via'] . '.' . $key] = $val; |
|
| 760 | + $field[$this->options['via'].'.'.$key] = $val; |
|
| 761 | 761 | unset($field[$key]); |
| 762 | 762 | } |
| 763 | 763 | } |
@@ -1427,7 +1427,7 @@ discard block |
||
| 1427 | 1427 | */ |
| 1428 | 1428 | public function buildSql(bool $sub = true): string |
| 1429 | 1429 | { |
| 1430 | - return $sub ? '( ' . $this->fetchSql()->select() . ' )' : $this->fetchSql()->select(); |
|
| 1430 | + return $sub ? '( '.$this->fetchSql()->select().' )' : $this->fetchSql()->select(); |
|
| 1431 | 1431 | } |
| 1432 | 1432 | |
| 1433 | 1433 | /** |
@@ -1483,7 +1483,7 @@ discard block |
||
| 1483 | 1483 | $page = $page > 0 ? $page : 1; |
| 1484 | 1484 | $listRows = $listRows ?: (is_numeric($options['limit']) ? $options['limit'] : 20); |
| 1485 | 1485 | $offset = $listRows * ($page - 1); |
| 1486 | - $options['limit'] = $offset . ',' . $listRows; |
|
| 1486 | + $options['limit'] = $offset.','.$listRows; |
|
| 1487 | 1487 | } |
| 1488 | 1488 | |
| 1489 | 1489 | $this->options = $options; |
@@ -8,7 +8,7 @@ discard block |
||
| 8 | 8 | // +---------------------------------------------------------------------- |
| 9 | 9 | // | Author: liu21st <[email protected]> |
| 10 | 10 | // +---------------------------------------------------------------------- |
| 11 | -declare (strict_types = 1); |
|
| 11 | +declare(strict_types=1); |
|
| 12 | 12 | |
| 13 | 13 | namespace think\db\concern; |
| 14 | 14 | |
@@ -201,7 +201,7 @@ discard block |
||
| 201 | 201 | $table = $this->getJoinTable($join, $alias); |
| 202 | 202 | |
| 203 | 203 | if (true === $field) { |
| 204 | - $fields = $alias . '.*'; |
|
| 204 | + $fields = $alias.'.*'; |
|
| 205 | 205 | } else { |
| 206 | 206 | if (is_string($field)) { |
| 207 | 207 | $field = explode(',', $field); |
@@ -209,17 +209,17 @@ discard block |
||
| 209 | 209 | |
| 210 | 210 | foreach ($field as $key => $val) { |
| 211 | 211 | if (is_numeric($key)) { |
| 212 | - $fields[] = $alias . '.' . $val; |
|
| 212 | + $fields[] = $alias.'.'.$val; |
|
| 213 | 213 | |
| 214 | - $this->options['map'][$val] = $alias . '.' . $val; |
|
| 214 | + $this->options['map'][$val] = $alias.'.'.$val; |
|
| 215 | 215 | } else { |
| 216 | 216 | if (preg_match('/[,=\.\'\"\(\s]/', $key)) { |
| 217 | 217 | $name = $key; |
| 218 | 218 | } else { |
| 219 | - $name = $alias . '.' . $key; |
|
| 219 | + $name = $alias.'.'.$key; |
|
| 220 | 220 | } |
| 221 | 221 | |
| 222 | - $fields[] = $name . ' AS ' . $val; |
|
| 222 | + $fields[] = $name.' AS '.$val; |
|
| 223 | 223 | |
| 224 | 224 | $this->options['map'][$val] = $name; |
| 225 | 225 | } |
@@ -8,7 +8,7 @@ |
||
| 8 | 8 | // +---------------------------------------------------------------------- |
| 9 | 9 | // | Author: liu21st <[email protected]> |
| 10 | 10 | // +---------------------------------------------------------------------- |
| 11 | -declare (strict_types = 1); |
|
| 11 | +declare(strict_types=1); |
|
| 12 | 12 | |
| 13 | 13 | namespace think\db\concern; |
| 14 | 14 | |
@@ -8,7 +8,7 @@ |
||
| 8 | 8 | // +---------------------------------------------------------------------- |
| 9 | 9 | // | Author: liu21st <[email protected]> |
| 10 | 10 | // +---------------------------------------------------------------------- |
| 11 | -declare (strict_types = 1); |
|
| 11 | +declare(strict_types=1); |
|
| 12 | 12 | |
| 13 | 13 | namespace think\db\concern; |
| 14 | 14 | |
@@ -8,7 +8,7 @@ discard block |
||
| 8 | 8 | // +---------------------------------------------------------------------- |
| 9 | 9 | // | Author: liu21st <[email protected]> |
| 10 | 10 | // +---------------------------------------------------------------------- |
| 11 | -declare (strict_types = 1); |
|
| 11 | +declare(strict_types=1); |
|
| 12 | 12 | |
| 13 | 13 | namespace think\db\concern; |
| 14 | 14 | |
@@ -210,11 +210,11 @@ discard block |
||
| 210 | 210 | { |
| 211 | 211 | if (!empty($this->model)) { |
| 212 | 212 | $class = get_class($this->model); |
| 213 | - throw new ModelNotFoundException('model data Not Found:' . $class, $class, $this->options); |
|
| 213 | + throw new ModelNotFoundException('model data Not Found:'.$class, $class, $this->options); |
|
| 214 | 214 | } |
| 215 | 215 | |
| 216 | 216 | $table = $this->getTable(); |
| 217 | - throw new DataNotFoundException('table data not Found:' . $table, $table, $this->options); |
|
| 217 | + throw new DataNotFoundException('table data not Found:'.$table, $table, $this->options); |
|
| 218 | 218 | } |
| 219 | 219 | |
| 220 | 220 | /** |
@@ -8,7 +8,7 @@ discard block |
||
| 8 | 8 | // +---------------------------------------------------------------------- |
| 9 | 9 | // | Author: liu21st <[email protected]> |
| 10 | 10 | // +---------------------------------------------------------------------- |
| 11 | -declare (strict_types = 1); |
|
| 11 | +declare(strict_types=1); |
|
| 12 | 12 | |
| 13 | 13 | namespace think\db\concern; |
| 14 | 14 | |
@@ -72,7 +72,7 @@ discard block |
||
| 72 | 72 | $alias = $this->options['alias'][$table]; |
| 73 | 73 | } |
| 74 | 74 | |
| 75 | - $key = isset($alias) ? $alias . '.' . $pk : $pk; |
|
| 75 | + $key = isset($alias) ? $alias.'.'.$pk : $pk; |
|
| 76 | 76 | // 根据主键查询 |
| 77 | 77 | if (is_array($data)) { |
| 78 | 78 | $this->where($key, 'in', $data); |
@@ -8,7 +8,7 @@ discard block |
||
| 8 | 8 | // +---------------------------------------------------------------------- |
| 9 | 9 | // | Author: liu21st <[email protected]> |
| 10 | 10 | // +---------------------------------------------------------------------- |
| 11 | -declare (strict_types = 1); |
|
| 11 | +declare(strict_types=1); |
|
| 12 | 12 | |
| 13 | 13 | namespace think\db\concern; |
| 14 | 14 | |
@@ -112,7 +112,7 @@ discard block |
||
| 112 | 112 | if ($this->model) { |
| 113 | 113 | // 检查模型类的查询范围方法 |
| 114 | 114 | foreach ($scope as $name) { |
| 115 | - $method = 'scope' . trim($name); |
|
| 115 | + $method = 'scope'.trim($name); |
|
| 116 | 116 | |
| 117 | 117 | if (method_exists($this->model, $method)) { |
| 118 | 118 | call_user_func_array([$this->model, $method], $args); |
@@ -154,7 +154,7 @@ discard block |
||
| 154 | 154 | } elseif ($this->model) { |
| 155 | 155 | // 检测搜索器 |
| 156 | 156 | $fieldName = is_numeric($key) ? $field : $key; |
| 157 | - $method = 'search' . App::parseName($fieldName, 1) . 'Attr'; |
|
| 157 | + $method = 'search'.App::parseName($fieldName, 1).'Attr'; |
|
| 158 | 158 | |
| 159 | 159 | if (method_exists($this->model, $method)) { |
| 160 | 160 | $this->model->$method($this, $data[$field] ?? null, $data, $prefix); |
@@ -234,10 +234,10 @@ discard block |
||
| 234 | 234 | ->getRelationCountQuery($closure, $aggregate, $field, $aggregateField); |
| 235 | 235 | |
| 236 | 236 | if (empty($aggregateField)) { |
| 237 | - $aggregateField = App::parseName($relation) . '_' . $aggregate; |
|
| 237 | + $aggregateField = App::parseName($relation).'_'.$aggregate; |
|
| 238 | 238 | } |
| 239 | 239 | |
| 240 | - $this->field(['(' . $count . ')' => $aggregateField]); |
|
| 240 | + $this->field(['('.$count.')' => $aggregateField]); |
|
| 241 | 241 | } |
| 242 | 242 | } |
| 243 | 243 | |