Page MenuHomePhorge
Files F117890630

D4316.1775363461.diff
No OneTemporary
Actions

Authored By
Unknown
Size
4 KB
Referenced Files
None
Subscribers
None

D4316.1775363461.diff
View Options

diff --git a/src/app/Console/Commands/UsersCommand.php b/src/app/Console/Commands/UsersCommand.php
--- a/src/app/Console/Commands/UsersCommand.php
+++ b/src/app/Console/Commands/UsersCommand.php
@@ -9,4 +9,35 @@
protected $objectClass = \App\User::class;
protected $objectName = 'user';
protected $objectTitle = 'email';
+
+ /**
+ * Apply pre-configured filter or raw WHERE clause to the main query.
+ *
+ * @param object $query Query builder
+ * @param string $filter Pre-defined filter identifier or raw SQL WHERE clause
+ *
+ * @return object Query builder
+ */
+ public function applyFilter($query, string $filter)
+ {
+ // Get users with or without a successful payment, e.g. --filter=WITH-PAYMENT
+ if (preg_match('/^(with|without)-payment/i', $filter, $matches)) {
+ $method = strtolower($matches[1]) == 'with' ? 'whereIn' : 'whereNotIn';
+
+ return $query->whereIn('id', function ($query) use ($method) {
+ // all user IDs from the entitlements
+ $query->select('entitleable_id')->distinct()
+ ->from('entitlements')
+ ->where('entitleable_type', \App\User::class)
+ ->{$method}('wallet_id', function ($query) {
+ // wallets with a PAID payment
+ $query->select('wallet_id')->distinct()
+ ->from('payments')
+ ->where('status', \App\Payment::STATUS_PAID);
+ });
+ });
+ }
+
+ return parent::applyFilter($query, $filter);
+ }
}
diff --git a/src/app/Console/ObjectListCommand.php b/src/app/Console/ObjectListCommand.php
--- a/src/app/Console/ObjectListCommand.php
+++ b/src/app/Console/ObjectListCommand.php
@@ -28,7 +28,8 @@
$this->signature .= " {--with-deleted : Include deleted {$this->objectName}s}";
}
- $this->signature .= " {--attr=* : Attributes other than the primary unique key to include}";
+ $this->signature .= " {--attr=* : Attributes other than the primary unique key to include}"
+ . "{--filter=* : Additional filter(s) or a raw SQL WHERE clause}";
parent::__construct();
}
@@ -49,14 +50,65 @@
$objects = new $this->objectClass();
}
- $objects->each(
- function ($object) {
- if ($object->deleted_at) {
- $this->info("{$this->toString($object)} (deleted at {$object->deleted_at}");
- } else {
- $this->info("{$this->toString($object)}");
- }
+ foreach ($this->option('filter') as $filter) {
+ $objects = $this->applyFilter($objects, $filter);
+ }
+
+ foreach ($objects->cursor() as $object) {
+ if ($object->deleted_at) {
+ $this->info("{$this->toString($object)} (deleted at {$object->deleted_at}");
+ } else {
+ $this->info("{$this->toString($object)}");
+ }
+ }
+ }
+
+ /**
+ * Apply pre-configured filter or raw WHERE clause to the main query.
+ *
+ * @param object $query Query builder
+ * @param string $filter Pre-defined filter identifier or raw SQL WHERE clause
+ *
+ * @return object Query builder
+ */
+ public function applyFilter($query, string $filter)
+ {
+ // Get objects marked as deleted, i.e. --filter=TRASHED
+ // Note: For use with --with-deleted option
+ if (strtolower($filter) === 'trashed') {
+ return $query->whereNotNull('deleted_at');
+ }
+
+ // Get objects with specified status, e.g. --filter=STATUS:SUSPENDED
+ if (preg_match('/^status:([a-z]+)$/i', $filter, $matches)) {
+ $status = strtoupper($matches[1]);
+ $const = "{$this->objectClass}::STATUS_{$status}";
+
+ if (defined($const)) {
+ return $query->where('status', '&', constant($const));
}
- );
+
+ throw new \Exception("Unknown status in --filter={$filter}");
+ }
+
+ // Get objects older/younger than specified time, e.g. --filter=MIN-AGE:1Y
+ if (preg_match('/^(min|max)-age:([0-9]+)([mdy])$/i', $filter, $matches)) {
+ $operator = strtolower($matches[2]) == 'min' ? '<=' : '>=';
+ $count = $matches[2];
+ $period = strtolower($matches[3]);
+ $date = \Carbon\Carbon::now();
+
+ if ($period == 'y') {
+ $date->subYearsWithoutOverflow($count);
+ } elseif ($period == 'm') {
+ $date->subMonthsWithoutOverflow($count);
+ } else {
+ $date->subDays($count);
+ }
+
+ return $query->where('created_at', $operator, $date);
+ }
+
+ return $query->whereRaw($filter);
}
}

File Metadata

Mime Type
text/plain
Expires
Sun, Apr 5, 4:31 AM (23 h, 43 m ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
18832152
Default Alt Text
D4316.1775363461.diff (4 KB)

Event Timeline