Closed lasseklovstad closed 2 months ago
fix denne spørringen
export const getUsersThatHasNotPaidContingent = async (context: AppLoadContext, year: number) => { const usersContingent = await context.db .select({ id: user.id, name: externalUser.name, email: externalUser.email, isPaid: contingent.isPaid }) .from(user) .leftJoin(contingent, and(eq(contingent.userId, user.id), eq(contingent.year, year))) .leftJoin(externalUser, and(eq(externalUser.userId, user.id), eq(externalUser.primaryUser, true))); return usersContingent.filter((user) => !user.isPaid); };
fix denne spørringen
export const getUsersThatHasNotPaidContingent = async (context: AppLoadContext, year: number) => { const usersContingent = await context.db .select({ id: user.id, name: externalUser.name, email: externalUser.email, isPaid: contingent.isPaid }) .from(user) .leftJoin(contingent, and(eq(contingent.userId, user.id), eq(contingent.year, year))) .leftJoin(externalUser, and(eq(externalUser.userId, user.id), eq(externalUser.primaryUser, true))); return usersContingent.filter((user) => !user.isPaid); };