aboutsummaryrefslogtreecommitdiffhomepage
path: root/main/app/sprinkles/extend-user/src/Database/Scopes/MemberAuxScope.php
diff options
context:
space:
mode:
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.php35
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");
- });
- }
-}