diff options
Diffstat (limited to 'main/app/sprinkles/extend-user/src/Database/Scopes/MemberAuxScope.php')
-rw-r--r-- | main/app/sprinkles/extend-user/src/Database/Scopes/MemberAuxScope.php | 35 |
1 files changed, 0 insertions, 35 deletions
diff --git a/main/app/sprinkles/extend-user/src/Database/Scopes/MemberAuxScope.php b/main/app/sprinkles/extend-user/src/Database/Scopes/MemberAuxScope.php deleted file mode 100644 index 624c4f6..0000000 --- a/main/app/sprinkles/extend-user/src/Database/Scopes/MemberAuxScope.php +++ /dev/null @@ -1,35 +0,0 @@ -<?php - -namespace UserFrosting\Sprinkle\ExtendUser\Database\Scopes; - -use Illuminate\Database\Eloquent\Scope; -use Illuminate\Database\Eloquent\Model; -use Illuminate\Database\Eloquent\Builder; - -class MemberAuxScope implements Scope -{ - /** - * Apply the scope to a given Eloquent query builder. - * - * @param \Illuminate\Database\Eloquent\Builder $builder - * @param \Illuminate\Database\Eloquent\Model $model - * @return void - */ - public function apply(Builder $builder, Model $model) { - $baseTable = $model->getTable(); - // Hardcode the table name here, or you can access it using the classMapper and `getTable` - $auxTable = 'members'; - - // Specify columns to load from base table and aux table - $builder->addSelect( - "$baseTable.*", - "$auxTable.city as city", - "$auxTable.country as country" - ); - - // Join on matching `member` records - $builder->leftJoin($auxTable, function ($join) use ($baseTable, $auxTable) { - $join->on("$auxTable.id", '=', "$baseTable.id"); - }); - } -} |