@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | } |
90 | 90 | |
91 | 91 | return $this->query |
92 | - ->whereExp($this->foreignKey, '=' . $this->parent->getTable() . '.' . $this->localKey) |
|
92 | + ->whereExp($this->foreignKey, '='.$this->parent->getTable().'.'.$this->localKey) |
|
93 | 93 | ->fetchSql() |
94 | 94 | ->$aggregate($field); |
95 | 95 | } |
@@ -144,12 +144,12 @@ discard block |
||
144 | 144 | |
145 | 145 | return $this->parent->db() |
146 | 146 | ->alias($model) |
147 | - ->whereExists(function ($query) use ($table, $model, $relation, $localKey, $foreignKey, $softDelete) { |
|
147 | + ->whereExists(function($query) use ($table, $model, $relation, $localKey, $foreignKey, $softDelete) { |
|
148 | 148 | $query->table([$table => $relation]) |
149 | - ->field($relation . '.' . $foreignKey) |
|
150 | - ->whereExp($model . '.' . $localKey, '=' . $relation . '.' . $foreignKey) |
|
151 | - ->when($softDelete, function ($query) use ($softDelete, $relation) { |
|
152 | - $query->where($relation . strstr($softDelete[0], '.'), '=' == $softDelete[1][0] ? $softDelete[1][1] : null); |
|
149 | + ->field($relation.'.'.$foreignKey) |
|
150 | + ->whereExp($model.'.'.$localKey, '='.$relation.'.'.$foreignKey) |
|
151 | + ->when($softDelete, function($query) use ($softDelete, $relation) { |
|
152 | + $query->where($relation.strstr($softDelete[0], '.'), '=' == $softDelete[1][0] ? $softDelete[1][1] : null); |
|
153 | 153 | }); |
154 | 154 | }); |
155 | 155 | } |
@@ -177,9 +177,9 @@ discard block |
||
177 | 177 | return $this->parent->db() |
178 | 178 | ->alias($model) |
179 | 179 | ->field($fields) |
180 | - ->join([$table => $relation], $model . '.' . $this->localKey . '=' . $relation . '.' . $this->foreignKey, $this->joinType) |
|
181 | - ->when($softDelete, function ($query) use ($softDelete, $relation) { |
|
182 | - $query->where($relation . strstr($softDelete[0], '.'), '=' == $softDelete[1][0] ? $softDelete[1][1] : null); |
|
180 | + ->join([$table => $relation], $model.'.'.$this->localKey.'='.$relation.'.'.$this->foreignKey, $this->joinType) |
|
181 | + ->when($softDelete, function($query) use ($softDelete, $relation) { |
|
182 | + $query->where($relation.strstr($softDelete[0], '.'), '=' == $softDelete[1][0] ? $softDelete[1][1] : null); |
|
183 | 183 | }) |
184 | 184 | ->where($where); |
185 | 185 | } |