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