@@ -91,9 +91,9 @@ discard block |
||
91 | 91 | $query->via($joinAlias); |
92 | 92 | |
93 | 93 | if ($this instanceof BelongsTo) { |
94 | - $joinOn = $name . '.' . $this->foreignKey . '=' . $joinAlias . '.' . $this->localKey; |
|
94 | + $joinOn = $name.'.'.$this->foreignKey.'='.$joinAlias.'.'.$this->localKey; |
|
95 | 95 | } else { |
96 | - $joinOn = $name . '.' . $this->localKey . '=' . $joinAlias . '.' . $this->foreignKey; |
|
96 | + $joinOn = $name.'.'.$this->localKey.'='.$joinAlias.'.'.$this->foreignKey; |
|
97 | 97 | } |
98 | 98 | |
99 | 99 | if ($closure) { |
@@ -106,7 +106,7 @@ discard block |
||
106 | 106 | } |
107 | 107 | |
108 | 108 | $query->join([$joinTable => $joinAlias], $joinOn, $joinType) |
109 | - ->tableField($field, $joinTable, $joinAlias, $relation . '__'); |
|
109 | + ->tableField($field, $joinTable, $joinAlias, $relation.'__'); |
|
110 | 110 | } |
111 | 111 | |
112 | 112 | /** |
@@ -275,7 +275,7 @@ discard block |
||
275 | 275 | $value = $result->getOrigin($key); |
276 | 276 | |
277 | 277 | if (!is_null($value)) { |
278 | - throw new Exception('bind attr has exists:' . $key); |
|
278 | + throw new Exception('bind attr has exists:'.$key); |
|
279 | 279 | } |
280 | 280 | |
281 | 281 | $result->setAttr($key, $model ? $model->$attr : null); |
@@ -159,7 +159,7 @@ discard block |
||
159 | 159 | // 关联查询 |
160 | 160 | $pk = $this->parent->getPk(); |
161 | 161 | |
162 | - $condition = ['pivot.' . $localKey, '=', $this->parent->$pk]; |
|
162 | + $condition = ['pivot.'.$localKey, '=', $this->parent->$pk]; |
|
163 | 163 | |
164 | 164 | return $this->belongsToManyQuery($foreignKey, $localKey, [$condition]); |
165 | 165 | } |
@@ -294,7 +294,7 @@ discard block |
||
294 | 294 | */ |
295 | 295 | public function wherePivot($field, $op = null, $condition = null) |
296 | 296 | { |
297 | - $this->query->where('pivot.' . $field, $op, $condition); |
|
297 | + $this->query->where('pivot.'.$field, $op, $condition); |
|
298 | 298 | return $this; |
299 | 299 | } |
300 | 300 | |
@@ -323,7 +323,7 @@ discard block |
||
323 | 323 | if (!empty($range)) { |
324 | 324 | // 查询关联数据 |
325 | 325 | $data = $this->eagerlyManyToMany([ |
326 | - ['pivot.' . $localKey, 'in', $range], |
|
326 | + ['pivot.'.$localKey, 'in', $range], |
|
327 | 327 | ], $relation, $subRelation, $closure); |
328 | 328 | |
329 | 329 | // 关联属性名 |
@@ -357,7 +357,7 @@ discard block |
||
357 | 357 | $pk = $result->$pk; |
358 | 358 | // 查询管理数据 |
359 | 359 | $data = $this->eagerlyManyToMany([ |
360 | - ['pivot.' . $this->localKey, '=', $pk], |
|
360 | + ['pivot.'.$this->localKey, '=', $pk], |
|
361 | 361 | ], $relation, $subRelation, $closure); |
362 | 362 | |
363 | 363 | // 关联数据封装 |
@@ -394,7 +394,7 @@ discard block |
||
394 | 394 | } |
395 | 395 | |
396 | 396 | return $this->belongsToManyQuery($this->foreignKey, $this->localKey, [ |
397 | - ['pivot.' . $this->localKey, '=', $pk], |
|
397 | + ['pivot.'.$this->localKey, '=', $pk], |
|
398 | 398 | ])->$aggregate($field); |
399 | 399 | } |
400 | 400 | |
@@ -415,7 +415,7 @@ discard block |
||
415 | 415 | |
416 | 416 | return $this->belongsToManyQuery($this->foreignKey, $this->localKey, [ |
417 | 417 | [ |
418 | - 'pivot.' . $this->localKey, 'exp', new Raw('=' . $this->parent->db(false)->getTable() . '.' . $this->parent->getPk()), |
|
418 | + 'pivot.'.$this->localKey, 'exp', new Raw('='.$this->parent->db(false)->getTable().'.'.$this->parent->getPk()), |
|
419 | 419 | ], |
420 | 420 | ])->fetchSql()->$aggregate($field); |
421 | 421 | } |
@@ -493,7 +493,7 @@ discard block |
||
493 | 493 | |
494 | 494 | if (empty($this->baseQuery)) { |
495 | 495 | $relationFk = $this->query->getPk(); |
496 | - $query->join([$table => 'pivot'], 'pivot.' . $foreignKey . '=' . $tableName . '.' . $relationFk) |
|
496 | + $query->join([$table => 'pivot'], 'pivot.'.$foreignKey.'='.$tableName.'.'.$relationFk) |
|
497 | 497 | ->where($condition); |
498 | 498 | } |
499 | 499 | |
@@ -715,8 +715,8 @@ discard block |
||
715 | 715 | $table = $this->pivot->getTable(); |
716 | 716 | |
717 | 717 | $this->query |
718 | - ->join([$table => 'pivot'], 'pivot.' . $this->foreignKey . '=' . $this->query->getTable() . '.' . $this->query->getPk()) |
|
719 | - ->where('pivot.' . $this->localKey, $this->parent->$pk); |
|
718 | + ->join([$table => 'pivot'], 'pivot.'.$this->foreignKey.'='.$this->query->getTable().'.'.$this->query->getPk()) |
|
719 | + ->where('pivot.'.$this->localKey, $this->parent->$pk); |
|
720 | 720 | $this->baseQuery = true; |
721 | 721 | } |
722 | 722 | } |
@@ -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\model\relation; |
14 | 14 | |
@@ -88,7 +88,7 @@ discard block |
||
88 | 88 | } |
89 | 89 | |
90 | 90 | return $this->query |
91 | - ->whereExp($this->foreignKey, '=' . $this->parent->getTable() . '.' . $this->localKey) |
|
91 | + ->whereExp($this->foreignKey, '='.$this->parent->getTable().'.'.$this->localKey) |
|
92 | 92 | ->fetchSql() |
93 | 93 | ->$aggregate($field); |
94 | 94 | } |
@@ -139,10 +139,10 @@ discard block |
||
139 | 139 | |
140 | 140 | return $this->parent->db() |
141 | 141 | ->alias($model) |
142 | - ->whereExists(function ($query) use ($table, $model, $relation, $localKey, $foreignKey) { |
|
142 | + ->whereExists(function($query) use ($table, $model, $relation, $localKey, $foreignKey) { |
|
143 | 143 | $query->table([$table => $relation]) |
144 | - ->field($relation . '.' . $foreignKey) |
|
145 | - ->whereExp($model . '.' . $localKey, '=' . $relation . '.' . $foreignKey); |
|
144 | + ->field($relation.'.'.$foreignKey) |
|
145 | + ->whereExp($model.'.'.$localKey, '='.$relation.'.'.$foreignKey); |
|
146 | 146 | }); |
147 | 147 | } |
148 | 148 | |
@@ -171,7 +171,7 @@ discard block |
||
171 | 171 | return $this->parent->db() |
172 | 172 | ->alias($model) |
173 | 173 | ->field($fields) |
174 | - ->join([$table => $relation], $model . '.' . $this->localKey . '=' . $relation . '.' . $this->foreignKey, $joinType ?: $this->joinType) |
|
174 | + ->join([$table => $relation], $model.'.'.$this->localKey.'='.$relation.'.'.$this->foreignKey, $joinType ?: $this->joinType) |
|
175 | 175 | ->where($where); |
176 | 176 | } |
177 | 177 |
@@ -231,7 +231,7 @@ |
||
231 | 231 | } |
232 | 232 | |
233 | 233 | return $this->query |
234 | - ->whereExp($this->morphKey, '=' . $this->parent->getTable() . '.' . $this->parent->getPk()) |
|
234 | + ->whereExp($this->morphKey, '='.$this->parent->getTable().'.'.$this->parent->getPk()) |
|
235 | 235 | ->where($this->morphType, '=', $this->type) |
236 | 236 | ->fetchSql() |
237 | 237 | ->$aggregate($field); |
@@ -221,7 +221,7 @@ |
||
221 | 221 | // 关联模型 |
222 | 222 | if (!isset($data[$result->$morphKey])) { |
223 | 223 | $relationModel = null; |
224 | - throw new Exception('relation data not exists :' . $this->model); |
|
224 | + throw new Exception('relation data not exists :'.$this->model); |
|
225 | 225 | } else { |
226 | 226 | $relationModel = $data[$result->$morphKey]; |
227 | 227 | $relationModel->setParent(clone $result); |
@@ -107,16 +107,16 @@ discard block |
||
107 | 107 | $relationTable = $relation->getTable(); |
108 | 108 | |
109 | 109 | if ('*' != $id) { |
110 | - $id = $relationTable . '.' . $relation->getPk(); |
|
110 | + $id = $relationTable.'.'.$relation->getPk(); |
|
111 | 111 | } |
112 | 112 | |
113 | 113 | return $this->parent->db() |
114 | 114 | ->alias($model) |
115 | - ->field($model . '.*') |
|
116 | - ->join($throughTable, $throughTable . '.' . $this->foreignKey . '=' . $model . '.' . $this->localKey) |
|
117 | - ->join($relationTable, $relationTable . '.' . $throughKey . '=' . $throughTable . '.' . $this->throughPk) |
|
118 | - ->group($relationTable . '.' . $this->throughKey) |
|
119 | - ->having('count(' . $id . ')' . $operator . $count); |
|
115 | + ->field($model.'.*') |
|
116 | + ->join($throughTable, $throughTable.'.'.$this->foreignKey.'='.$model.'.'.$this->localKey) |
|
117 | + ->join($relationTable, $relationTable.'.'.$throughKey.'='.$throughTable.'.'.$this->throughPk) |
|
118 | + ->group($relationTable.'.'.$this->throughKey) |
|
119 | + ->having('count('.$id.')'.$operator.$count); |
|
120 | 120 | } |
121 | 121 | |
122 | 122 | /** |
@@ -145,9 +145,9 @@ discard block |
||
145 | 145 | |
146 | 146 | return $this->parent->db() |
147 | 147 | ->alias($model) |
148 | - ->join($throughTable, $throughTable . '.' . $this->foreignKey . '=' . $model . '.' . $this->localKey) |
|
149 | - ->join($modelTable, $modelTable . '.' . $throughKey . '=' . $throughTable . '.' . $this->throughPk) |
|
150 | - ->group($modelTable . '.' . $this->throughKey) |
|
148 | + ->join($throughTable, $throughTable.'.'.$this->foreignKey.'='.$model.'.'.$this->localKey) |
|
149 | + ->join($modelTable, $modelTable.'.'.$throughKey.'='.$throughTable.'.'.$this->throughPk) |
|
150 | + ->group($modelTable.'.'.$this->throughKey) |
|
151 | 151 | ->where($where) |
152 | 152 | ->field($fields); |
153 | 153 | } |
@@ -294,14 +294,14 @@ discard block |
||
294 | 294 | $modelTable = $this->parent->getTable(); |
295 | 295 | |
296 | 296 | if (false === strpos($field, '.')) { |
297 | - $field = $alias . '.' . $field; |
|
297 | + $field = $alias.'.'.$field; |
|
298 | 298 | } |
299 | 299 | |
300 | 300 | return $this->query |
301 | 301 | ->alias($alias) |
302 | - ->join($throughTable, $throughTable . '.' . $pk . '=' . $alias . '.' . $throughKey) |
|
303 | - ->join($modelTable, $modelTable . '.' . $this->localKey . '=' . $throughTable . '.' . $this->foreignKey) |
|
304 | - ->where($throughTable . '.' . $this->foreignKey, $result->$localKey) |
|
302 | + ->join($throughTable, $throughTable.'.'.$pk.'='.$alias.'.'.$throughKey) |
|
303 | + ->join($modelTable, $modelTable.'.'.$this->localKey.'='.$throughTable.'.'.$this->foreignKey) |
|
304 | + ->where($throughTable.'.'.$this->foreignKey, $result->$localKey) |
|
305 | 305 | ->$aggregate($field); |
306 | 306 | } |
307 | 307 | |
@@ -327,14 +327,14 @@ discard block |
||
327 | 327 | $modelTable = $this->parent->getTable(); |
328 | 328 | |
329 | 329 | if (false === strpos($field, '.')) { |
330 | - $field = $alias . '.' . $field; |
|
330 | + $field = $alias.'.'.$field; |
|
331 | 331 | } |
332 | 332 | |
333 | 333 | return $this->query |
334 | 334 | ->alias($alias) |
335 | - ->join($throughTable, $throughTable . '.' . $pk . '=' . $alias . '.' . $throughKey) |
|
336 | - ->join($modelTable, $modelTable . '.' . $this->localKey . '=' . $throughTable . '.' . $this->foreignKey) |
|
337 | - ->whereExp($throughTable . '.' . $this->foreignKey, '=' . $this->parent->getTable() . '.' . $this->localKey) |
|
335 | + ->join($throughTable, $throughTable.'.'.$pk.'='.$alias.'.'.$throughKey) |
|
336 | + ->join($modelTable, $modelTable.'.'.$this->localKey.'='.$throughTable.'.'.$this->foreignKey) |
|
337 | + ->whereExp($throughTable.'.'.$this->foreignKey, '='.$this->parent->getTable().'.'.$this->localKey) |
|
338 | 338 | ->fetchSql() |
339 | 339 | ->$aggregate($field); |
340 | 340 | } |
@@ -357,9 +357,9 @@ discard block |
||
357 | 357 | $this->query |
358 | 358 | ->field($fields) |
359 | 359 | ->alias($alias) |
360 | - ->join($throughTable, $throughTable . '.' . $pk . '=' . $alias . '.' . $throughKey) |
|
361 | - ->join($modelTable, $modelTable . '.' . $this->localKey . '=' . $throughTable . '.' . $this->foreignKey) |
|
362 | - ->where($throughTable . '.' . $this->foreignKey, $this->parent->{$this->localKey}); |
|
360 | + ->join($throughTable, $throughTable.'.'.$pk.'='.$alias.'.'.$throughKey) |
|
361 | + ->join($modelTable, $modelTable.'.'.$this->localKey.'='.$throughTable.'.'.$this->foreignKey) |
|
362 | + ->where($throughTable.'.'.$this->foreignKey, $this->parent->{$this->localKey}); |
|
363 | 363 | |
364 | 364 | $this->baseQuery = true; |
365 | 365 | } |
@@ -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\model\relation; |
14 | 14 | |
@@ -180,8 +180,8 @@ discard block |
||
180 | 180 | $closure($this, $name); |
181 | 181 | } |
182 | 182 | |
183 | - return $this->query->alias($aggregate . '_table') |
|
184 | - ->whereExp($aggregate . '_table.' . $this->foreignKey, '=' . $this->parent->getTable() . '.' . $this->localKey) |
|
183 | + return $this->query->alias($aggregate.'_table') |
|
184 | + ->whereExp($aggregate.'_table.'.$this->foreignKey, '='.$this->parent->getTable().'.'.$this->localKey) |
|
185 | 185 | ->fetchSql() |
186 | 186 | ->$aggregate($field); |
187 | 187 | } |
@@ -290,15 +290,15 @@ discard block |
||
290 | 290 | $relation = App::classBaseName($this->model); |
291 | 291 | |
292 | 292 | if ('*' != $id) { |
293 | - $id = $relation . '.' . (new $this->model)->getPk(); |
|
293 | + $id = $relation.'.'.(new $this->model)->getPk(); |
|
294 | 294 | } |
295 | 295 | |
296 | 296 | return $this->parent->db() |
297 | 297 | ->alias($model) |
298 | - ->field($model . '.*') |
|
299 | - ->join([$table => $relation], $model . '.' . $this->localKey . '=' . $relation . '.' . $this->foreignKey, $joinType) |
|
300 | - ->group($relation . '.' . $this->foreignKey) |
|
301 | - ->having('count(' . $id . ')' . $operator . $count); |
|
298 | + ->field($model.'.*') |
|
299 | + ->join([$table => $relation], $model.'.'.$this->localKey.'='.$relation.'.'.$this->foreignKey, $joinType) |
|
300 | + ->group($relation.'.'.$this->foreignKey) |
|
301 | + ->having('count('.$id.')'.$operator.$count); |
|
302 | 302 | } |
303 | 303 | |
304 | 304 | /** |
@@ -325,9 +325,9 @@ discard block |
||
325 | 325 | |
326 | 326 | return $this->parent->db() |
327 | 327 | ->alias($model) |
328 | - ->group($model . '.' . $this->localKey) |
|
328 | + ->group($model.'.'.$this->localKey) |
|
329 | 329 | ->field($fields) |
330 | - ->join([$table => $relation], $model . '.' . $this->localKey . '=' . $relation . '.' . $this->foreignKey) |
|
330 | + ->join([$table => $relation], $model.'.'.$this->localKey.'='.$relation.'.'.$this->foreignKey) |
|
331 | 331 | ->where($where); |
332 | 332 | } |
333 | 333 |
@@ -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\model\relation; |
14 | 14 | |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | } |
90 | 90 | |
91 | 91 | return $this->query |
92 | - ->whereExp($this->localKey, '=' . $this->parent->getTable() . '.' . $this->foreignKey) |
|
92 | + ->whereExp($this->localKey, '='.$this->parent->getTable().'.'.$this->foreignKey) |
|
93 | 93 | ->fetchSql() |
94 | 94 | ->$aggregate($field); |
95 | 95 | } |
@@ -140,10 +140,10 @@ discard block |
||
140 | 140 | |
141 | 141 | return $this->parent->db() |
142 | 142 | ->alias($model) |
143 | - ->whereExists(function ($query) use ($table, $model, $relation, $localKey, $foreignKey) { |
|
143 | + ->whereExists(function($query) use ($table, $model, $relation, $localKey, $foreignKey) { |
|
144 | 144 | $query->table([$table => $relation]) |
145 | - ->field($relation . '.' . $localKey) |
|
146 | - ->whereExp($model . '.' . $foreignKey, '=' . $relation . '.' . $localKey); |
|
145 | + ->field($relation.'.'.$localKey) |
|
146 | + ->whereExp($model.'.'.$foreignKey, '='.$relation.'.'.$localKey); |
|
147 | 147 | }); |
148 | 148 | } |
149 | 149 | |
@@ -172,7 +172,7 @@ discard block |
||
172 | 172 | return $this->parent->db() |
173 | 173 | ->alias($model) |
174 | 174 | ->field($fields) |
175 | - ->join([$table => $relation], $model . '.' . $this->foreignKey . '=' . $relation . '.' . $this->localKey, $joinType ?: $this->joinType) |
|
175 | + ->join([$table => $relation], $model.'.'.$this->foreignKey.'='.$relation.'.'.$this->localKey, $joinType ?: $this->joinType) |
|
176 | 176 | ->where($where); |
177 | 177 | } |
178 | 178 |
@@ -8,7 +8,7 @@ discard block |
||
8 | 8 | // +---------------------------------------------------------------------- |
9 | 9 | // | Author: zhangyajun <[email protected]> |
10 | 10 | // +---------------------------------------------------------------------- |
11 | -declare (strict_types = 1); |
|
11 | +declare(strict_types=1); |
|
12 | 12 | |
13 | 13 | namespace think; |
14 | 14 | |
@@ -184,10 +184,10 @@ discard block |
||
184 | 184 | |
185 | 185 | $url = $path; |
186 | 186 | if (!empty($parameters)) { |
187 | - $url .= '?' . http_build_query($parameters, '', '&'); |
|
187 | + $url .= '?'.http_build_query($parameters, '', '&'); |
|
188 | 188 | } |
189 | 189 | |
190 | - return $url . $this->buildFragment(); |
|
190 | + return $url.$this->buildFragment(); |
|
191 | 191 | } |
192 | 192 | |
193 | 193 | /** |
@@ -336,7 +336,7 @@ discard block |
||
336 | 336 | */ |
337 | 337 | protected function buildFragment(): string |
338 | 338 | { |
339 | - return $this->options['fragment'] ? '#' . $this->options['fragment'] : ''; |
|
339 | + return $this->options['fragment'] ? '#'.$this->options['fragment'] : ''; |
|
340 | 340 | } |
341 | 341 | |
342 | 342 | /** |