1 | <?php declare(strict_types=1); |
||
8 | class ScopeAsSelect |
||
9 | { |
||
10 | /** |
||
11 | * Helper method for code completion. |
||
12 | * |
||
13 | * @param mixed $value |
||
14 | * @return \Illuminate\Database\Eloquent\Builder |
||
15 | */ |
||
16 | public static function builder($value): Builder |
||
17 | { |
||
18 | return $value; |
||
19 | } |
||
20 | |||
21 | public static function addMacro(string $name = 'addScopeAsSelect') |
||
22 | { |
||
23 | Builder::macro($name, function (string $name, callable $callable): Builder { |
||
24 | $query = ScopeAsSelect::builder($this); |
||
25 | |||
26 | $originalTable = $query->getModel()->getTable(); |
||
27 | |||
28 | $aliasedTable = "{$name}_{$originalTable}"; |
||
29 | $aliasedModel = $query->newModelInstance()->setTable($aliasedTable); |
||
30 | |||
31 | $subSelect = $aliasedModel::query()->setModel($aliasedModel); |
||
32 | $subSelect->getQuery()->from("{$originalTable} as {$aliasedTable}"); |
||
33 | |||
34 | $subSelect |
||
35 | ->select(DB::raw(1)) |
||
36 | ->whereColumn($aliasedModel->getQualifiedKeyName(), $query->getModel()->getQualifiedKeyName()) |
||
37 | ->limit(1) |
||
38 | ->tap(fn ($query) => $callable($query)); |
||
|
|||
39 | |||
40 | return $query |
||
41 | ->addSelect([$name => $subSelect]) |
||
42 | ->withCasts([$name => NullableBooleanCaster::class]); |
||
43 | }); |
||
44 | } |
||
45 | } |
||
46 |