Prisma Query

  async searchConsumer(
    prisma: Prisma.TransactionClient,
    query: SearchAccountQuery,
    page: number,
    pageSize: number,
  ) {
    try {
      console.log('Rewarding Transactions Where:', {
        AND: [
          query.fromAmount !== undefined
            ? { amount: { gte: query.fromAmount } }
            : {},
          query.toAmount !== undefined
            ? { amount: { lte: query.toAmount } }
            : {},
          query.fromPoints !== undefined
            ? { points: { gte: query.fromPoints } }
            : {},
          query.toPoints !== undefined
            ? { points: { lte: query.toPoints } }
            : {},
        ],
      });

      const consumers = await prisma.account.findMany({
        where: {
          AND: { account_type: 'consumer' },
          OR: [
            { name: { contains: query.name, mode: 'insensitive' } },
            { email: { contains: query.email, mode: 'insensitive' } },
            { phone_number: { contains: query.phone_number } },
            { id: { equals: query.id } },
          ],
        },
        include: {
          rewarding_transactions: {
            where: {
              AND: [
                query.fromAmount !== undefined
                  ? { amount: { gte: query.fromAmount } }
                  : {},
                query.toAmount !== undefined
                  ? { amount: { lte: query.toAmount } }
                  : {},
                query.fromPoints !== undefined
                  ? { points: { gte: query.fromPoints } }
                  : {},
                query.toPoints !== undefined
                  ? { points: { lte: query.toPoints } }
                  : {},
              ],
            },
            select: {
              amount: true,
              points: true,
            },
          },
        },
        ...(page && {
          ...(pageSize && {
            skip: Number(pageSize) * Number(page - 1),
            take: Number(pageSize),
          }),
        }),
      });
      return {
        totalCount: consumers.length,
        data: consumers,
      };
    } catch (error) {
      this.logger.error(error);
      throw new BadRequestException(error);
    }
  }