[{"_1":2,"_175":-5,"_176":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","f51a00d1aedfb0f6c517a3d665913da6776cbefb","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_172":173,"_174":-5},"handle","rohitr21","name","untitled-4063","path","backend/database/models.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","c0cebf96-3ee9-11f0-8953-76b3cceeab13","createdAt",["D",1748783413154],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","b022d420-3ee9-11f0-ad5b-814c56c8abb0","pinnedFileId","95790580-3eea-11f0-bdac-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","46791913-9054-4ab5-8a4e-f882e074951c","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4dU1DNlRJUkY3a3IxSDVjOXlCYXg3ekhSNSJ9","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",45,"c0cf0514-3ee9-11f0-8953-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":153,"_154":155,"_156":157,"_158":140,"_159":160,"_161":116,"_104":162,"_138":32,"_163":164,"_165":166,"_167":20,"_168":-5,"_98":169},"4940e25a-3eea-11f0-9677-76b3cceeab13","models.ts","fileId","4940e322-3eea-11f0-9677-76b3cceeab13","parentId","a11be733-00e1-4bf6-9f78-26fc0f1c585c","branchId","branchVersion",6,"latest",["D",1748783642061],"fileType","script","content","// Database models and data access layer for the GYM Management System\n\nimport { \n collection, \n doc, \n getDoc, \n getDocs, \n addDoc, \n updateDoc, \n deleteDoc, \n query, \n where, \n orderBy, \n limit, \n startAfter,\n type QueryConstraint,\n type DocumentSnapshot,\n type QuerySnapshot\n} from \"https://esm.sh/firebase@10.7.1/firestore\";\nimport { db, handleFirebaseError, serverTimestamp } from \"./firebase.ts\";\nimport { logger } from \"../utils/logger.ts\";\nimport { FIREBASE_COLLECTIONS } from \"../../shared/constants.ts\";\nimport type {\n User,\n Member,\n Bill,\n FeePackage,\n Notification,\n Supplement,\n DietPlan,\n Report,\n PaginatedResponse,\n MemberFilters,\n BillFilters\n} from \"../../shared/types.ts\";\n\n// Base model class with common CRUD operations\nabstract class BaseModel {\n constructor(protected collectionName: string) {}\n\n protected getCollection() {\n return collection(db, this.collectionName);\n }\n\n protected getDocRef(id: string) {\n return doc(db, this.collectionName, id);\n }\n\n protected transformDoc(docSnap: DocumentSnapshot): T | null {\n if (!docSnap.exists()) return null;\n \n const data = docSnap.data();\n return {\n id: docSnap.id,\n ...data,\n createdAt: data.createdAt?.toDate?.() || data.createdAt,\n updatedAt: data.updatedAt?.toDate?.() || data.updatedAt\n } as T;\n }\n\n protected transformDocs(querySnap: QuerySnapshot): T[] {\n return querySnap.docs.map(doc => this.transformDoc(doc)).filter(Boolean) as T[];\n }\n\n async findById(id: string): Promise {\n try {\n const docSnap = await getDoc(this.getDocRef(id));\n return this.transformDoc(docSnap);\n } catch (error) {\n logger.error(`Failed to find ${this.collectionName} by ID ${id}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async findAll(constraints: QueryConstraint[] = []): Promise {\n try {\n const q = query(this.getCollection(), ...constraints);\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error(`Failed to find all ${this.collectionName}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async create(data: Omit): Promise {\n try {\n const now = serverTimestamp();\n const docData = {\n ...data,\n createdAt: now,\n updatedAt: now\n };\n \n const docRef = await addDoc(this.getCollection(), docData);\n logger.info(`Created ${this.collectionName} with ID: ${docRef.id}`);\n return docRef.id;\n } catch (error) {\n logger.error(`Failed to create ${this.collectionName}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async update(id: string, data: Partial>): Promise {\n try {\n const updateData = {\n ...data,\n updatedAt: serverTimestamp()\n };\n \n await updateDoc(this.getDocRef(id), updateData);\n logger.info(`Updated ${this.collectionName} with ID: ${id}`);\n } catch (error) {\n logger.error(`Failed to update ${this.collectionName} with ID ${id}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async delete(id: string): Promise {\n try {\n await deleteDoc(this.getDocRef(id));\n logger.info(`Deleted ${this.collectionName} with ID: ${id}`);\n } catch (error) {\n logger.error(`Failed to delete ${this.collectionName} with ID ${id}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async paginate(\n page: number = 1,\n pageLimit: number = 10,\n constraints: QueryConstraint[] = []\n ): Promise> {\n try {\n const offset = (page - 1) * pageLimit;\n \n // Get total count (this is expensive in Firestore, consider caching)\n const countQuery = query(this.getCollection(), ...constraints.filter(c => c.type !== 'orderBy'));\n const countSnap = await getDocs(countQuery);\n const total = countSnap.size;\n \n // Get paginated results\n const paginatedQuery = query(\n this.getCollection(),\n ...constraints,\n limit(pageLimit)\n );\n \n const querySnap = await getDocs(paginatedQuery);\n const data = this.transformDocs(querySnap);\n \n return {\n success: true,\n data,\n pagination: {\n page,\n limit: pageLimit,\n total,\n totalPages: Math.ceil(total / pageLimit)\n }\n };\n } catch (error) {\n logger.error(`Failed to paginate ${this.collectionName}:`, error);\n throw handleFirebaseError(error);\n }\n }\n}\n\n// User model\nexport class UserModel extends BaseModel {\n constructor() {\n super(FIREBASE_COLLECTIONS.USERS);\n }\n\n async findByEmail(email: string): Promise {\n try {\n const q = query(this.getCollection(), where('email', '==', email));\n const querySnap = await getDocs(q);\n \n if (querySnap.empty) return null;\n \n return this.transformDoc(querySnap.docs[0]);\n } catch (error) {\n logger.error(`Failed to find user by email ${email}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async findByRole(role: string): Promise {\n try {\n const q = query(this.getCollection(), where('role', '==', role));\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error(`Failed to find users by role ${role}:`, error);\n throw handleFirebaseError(error);\n }\n }\n}\n\n// Member model\nexport class MemberModel extends BaseModel {\n constructor() {\n super(FIREBASE_COLLECTIONS.MEMBERS);\n }\n\n async findByEmail(email: string): Promise {\n try {\n const q = query(this.getCollection(), where('email', '==', email));\n const querySnap = await getDocs(q);\n \n if (querySnap.empty) return null;\n \n return this.transformDoc(querySnap.docs[0]);\n } catch (error) {\n logger.error(`Failed to find member by email ${email}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async findByMembershipType(membershipType: string): Promise {\n try {\n const q = query(\n this.getCollection(), \n where('membershipType', '==', membershipType),\n orderBy('joinDate', 'desc')\n );\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error(`Failed to find members by membership type ${membershipType}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async findActive(): Promise {\n try {\n const q = query(\n this.getCollection(), \n where('isActive', '==', true),\n orderBy('joinDate', 'desc')\n );\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error('Failed to find active members:', error);\n throw handleFirebaseError(error);\n }\n }\n\n async search(filters: MemberFilters): Promise {\n try {\n const constraints: QueryConstraint[] = [];\n \n if (filters.membershipType) {\n constraints.push(where('membershipType', '==', filters.membershipType));\n }\n \n if (filters.isActive !== undefined) {\n constraints.push(where('isActive', '==', filters.isActive));\n }\n \n // Add ordering\n const sortBy = filters.sortBy || 'joinDate';\n const sortOrder = filters.sortOrder || 'desc';\n constraints.push(orderBy(sortBy, sortOrder));\n \n const members = await this.findAll(constraints);\n \n // Client-side filtering for search term (Firestore doesn't support full-text search)\n if (filters.search) {\n const searchTerm = filters.search.toLowerCase();\n return members.filter(member => \n member.firstName.toLowerCase().includes(searchTerm) ||\n member.lastName.toLowerCase().includes(searchTerm) ||\n member.email.toLowerCase().includes(searchTerm) ||\n member.phone.includes(searchTerm)\n );\n }\n \n return members;\n } catch (error) {\n logger.error('Failed to search members:', error);\n throw handleFirebaseError(error);\n }\n }\n}\n\n// Bill model\nexport class BillModel extends BaseModel {\n constructor() {\n super(FIREBASE_COLLECTIONS.BILLS);\n }\n\n async findByMemberId(memberId: string): Promise {\n try {\n const q = query(\n this.getCollection(), \n where('memberId', '==', memberId),\n orderBy('createdAt', 'desc')\n );\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error(`Failed to find bills for member ${memberId}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async findByStatus(status: string): Promise {\n try {\n const q = query(\n this.getCollection(), \n where('status', '==', status),\n orderBy('dueDate', 'asc')\n );\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error(`Failed to find bills by status ${status}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async findOverdue(): Promise {\n try {\n const today = new Date();\n const q = query(\n this.getCollection(),\n where('status', '==', 'pending'),\n where('dueDate', '<', today),\n orderBy('dueDate', 'asc')\n );\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error('Failed to find overdue bills:', error);\n throw handleFirebaseError(error);\n }\n }\n\n async search(filters: BillFilters): Promise {\n try {\n const constraints: QueryConstraint[] = [];\n \n if (filters.status) {\n constraints.push(where('status', '==', filters.status));\n }\n \n if (filters.memberId) {\n constraints.push(where('memberId', '==', filters.memberId));\n }\n \n // Add ordering\n const sortBy = filters.sortBy || 'createdAt';\n const sortOrder = filters.sortOrder || 'desc';\n constraints.push(orderBy(sortBy, sortOrder));\n \n const bills = await this.findAll(constraints);\n \n // Client-side filtering for date range and search\n let filteredBills = bills;\n \n if (filters.dateRange) {\n const startDate = new Date(filters.dateRange.start);\n const endDate = new Date(filters.dateRange.end);\n filteredBills = filteredBills.filter(bill => {\n const billDate = new Date(bill.createdAt);\n return billDate >= startDate && billDate <= endDate;\n });\n }\n \n if (filters.search) {\n const searchTerm = filters.search.toLowerCase();\n filteredBills = filteredBills.filter(bill =>\n bill.memberName.toLowerCase().includes(searchTerm) ||\n bill.feePackageName.toLowerCase().includes(searchTerm) ||\n bill.transactionId?.toLowerCase().includes(searchTerm)\n );\n }\n \n return filteredBills;\n } catch (error) {\n logger.error('Failed to search bills:', error);\n throw handleFirebaseError(error);\n }\n }\n}\n\n// Fee Package model\nexport class FeePackageModel extends BaseModel {\n constructor() {\n super(FIREBASE_COLLECTIONS.FEE_PACKAGES);\n }\n\n async findActive(): Promise {\n try {\n const q = query(\n this.getCollection(), \n where('isActive', '==', true),\n orderBy('amount', 'asc')\n );\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error('Failed to find active fee packages:', error);\n throw handleFirebaseError(error);\n }\n }\n\n async findByMembershipType(membershipType: string): Promise {\n try {\n const q = query(\n this.getCollection(), \n where('membershipType', '==', membershipType),\n where('isActive', '==', true),\n orderBy('amount', 'asc')\n );\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error(`Failed to find fee packages by membership type ${membershipType}:`, error);\n throw handleFirebaseError(error);\n }\n }\n}\n\n// Notification model\nexport class NotificationModel extends BaseModel {\n constructor() {\n super(FIREBASE_COLLECTIONS.NOTIFICATIONS);\n }\n\n async findByRecipient(recipientId: string, unreadOnly: boolean = false): Promise {\n try {\n const constraints: QueryConstraint[] = [\n where('recipientId', '==', recipientId),\n orderBy('createdAt', 'desc')\n ];\n \n if (unreadOnly) {\n constraints.push(where('isRead', '==', false));\n }\n \n const q = query(this.getCollection(), ...constraints);\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error(`Failed to find notifications for recipient ${recipientId}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async markAsRead(id: string): Promise {\n try {\n await this.update(id, { isRead: true });\n } catch (error) {\n logger.error(`Failed to mark notification ${id} as read:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async markAllAsRead(recipientId: string): Promise {\n try {\n const notifications = await this.findByRecipient(recipientId, true);\n const batch = db.batch();\n \n notifications.forEach(notification => {\n const docRef = this.getDocRef(notification.id);\n batch.update(docRef, { isRead: true, updatedAt: serverTimestamp() });\n });\n \n await batch.commit();\n logger.info(`Marked all notifications as read for recipient ${recipientId}`);\n } catch (error) {\n logger.error(`Failed to mark all notifications as read for recipient ${recipientId}:`, error);\n throw handleFirebaseError(error);\n }\n }\n}\n\n// Supplement model\nexport class SupplementModel extends BaseModel {\n constructor() {\n super(FIREBASE_COLLECTIONS.SUPPLEMENTS);\n }\n\n async findByCategory(category: string): Promise {\n try {\n const q = query(\n this.getCollection(), \n where('category', '==', category),\n where('isActive', '==', true),\n orderBy('name', 'asc')\n );\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error(`Failed to find supplements by category ${category}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async findLowStock(): Promise {\n try {\n const supplements = await this.findAll([\n where('isActive', '==', true),\n orderBy('stock', 'asc')\n ]);\n \n return supplements.filter(supplement => supplement.stock <= supplement.minStock);\n } catch (error) {\n logger.error('Failed to find low stock supplements:', error);\n throw handleFirebaseError(error);\n }\n }\n}\n\n// Diet Plan model\nexport class DietPlanModel extends BaseModel {\n constructor() {\n super(FIREBASE_COLLECTIONS.DIET_PLANS);\n }\n\n async findByMemberId(memberId: string): Promise {\n try {\n const q = query(\n this.getCollection(), \n where('memberId', '==', memberId),\n orderBy('createdAt', 'desc')\n );\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error(`Failed to find diet plans for member ${memberId}:`, error);\n throw handleFirebaseError(error);\n }\n }\n\n async findActivePlan(memberId: string): Promise {\n try {\n const q = query(\n this.getCollection(), \n where('memberId', '==', memberId),\n where('isActive', '==', true),\n orderBy('createdAt', 'desc'),\n limit(1)\n );\n const querySnap = await getDocs(q);\n \n if (querySnap.empty) return null;\n \n return this.transformDoc(querySnap.docs[0]);\n } catch (error) {\n logger.error(`Failed to find active diet plan for member ${memberId}:`, error);\n throw handleFirebaseError(error);\n }\n }\n}\n\n// Report model\nexport class ReportModel extends BaseModel {\n constructor() {\n super(FIREBASE_COLLECTIONS.REPORTS);\n }\n\n async findByType(type: string): Promise {\n try {\n const q = query(\n this.getCollection(), \n where('type', '==', type),\n orderBy('createdAt', 'desc')\n );\n const querySnap = await getDocs(q);\n return this.transformDocs(querySnap);\n } catch (error) {\n logger.error(`Failed to find reports by type ${type}:`, error);\n throw handleFirebaseError(error);\n }\n }\n}\n\n// Export model instances\nexport const userModel = new UserModel();\nexport const memberModel = new MemberModel();\nexport const billModel = new BillModel();\nexport const feePackageModel = new FeePackageModel();\nexport const notificationModel = new NotificationModel();\nexport const supplementModel = new SupplementModel();\nexport const dietPlanModel = new DietPlanModel();\nexport const reportModel = new ReportModel();","deleted","label",[170,171,153],"backend","database","permalink","https://www.val.town/x/rohitr21/untitled-4063/code/backend/database/models.ts","extension","actionData","errors"]