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