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