ProductManager add more order by fieldsv3.7.3

2 files changed, 23 insertions, 16 deletions

diff --git a/generalresearch/managers/thl/product.py b/generalresearch/managers/thl/product.py
index 791ce55..ea4c3bc 100644
--- a/generalresearch/managers/thl/product.py
+++ b/generalresearch/managers/thl/product.py
@@ -40,21 +40,25 @@ logger = logging.getLogger()
 
 
 class ProductManager(PostgresManager):
-    CACHED_FIELDS: frozenset[str] = frozenset({
-        "balance",
-        "user_wallet_balance",
-        "payouts",
-        "pop_financial",
-        "users_active_7d",
-        "task_completes_7d",
-        "balance_net_7d",
-    })
-    CACHED_FIELDS_JSON: frozenset[str] = frozenset({
-        "balance",
-        "user_wallet_balance",
-        "payouts",
-        "pop_financial",
-    })
+    CACHED_FIELDS: frozenset[str] = frozenset(
+        {
+            "balance",
+            "user_wallet_balance",
+            "payouts",
+            "pop_financial",
+            "users_active_7d",
+            "task_completes_7d",
+            "balance_net_7d",
+        }
+    )
+    CACHED_FIELDS_JSON: frozenset[str] = frozenset(
+        {
+            "balance",
+            "user_wallet_balance",
+            "payouts",
+            "pop_financial",
+        }
+    )
 
     def __init__(
         self,
@@ -281,6 +285,9 @@ class ProductManager(PostgresManager):
             "balance": "(bp.balance ->> 'balance')::bigint",
             "available_balance": "(bp.balance ->> 'available_balance')::bigint",
             "adjustment_percent": "(bp.balance ->> 'adjustment_percent')::bigint",
+            "users_active_7d": "bp.users_active_7d",
+            "task_completes_7d": "bp.task_completes_7d",
+            "balance_net_7d": "bp.balance_net_7d",
         }
         order_by_sql = (
             f"{order_fields[order_field]} "
diff --git a/pyproject.toml b/pyproject.toml
index 1d5f903..957c120 100644
--- a/pyproject.toml
+++ b/pyproject.toml
@@ -4,7 +4,7 @@ build-backend = "setuptools.build_meta"
 
 [project]
 name = "generalresearch"
-version = "3.7.2"
+version = "3.7.3"
 description = "Python Utilities for General Research"
 readme = "README.md"
 requires-python = ">=3.14"