import { prisma } from '@app/lib/prisma';
import { Mood } from '@prisma/client';

import { CreateMoodInput } from '@app/schemas';

export const createMood = async (userId: number, input: CreateMoodInput): Promise<Mood> => {
  const { moodComponents, ...moodData } = input;

  return prisma.mood.create({
    data: {
      ...moodData,
      userId,
      moodComponents: {
        create: moodComponents
      }
    },
    include: { moodComponents: true }
  });
};

export const getMoodsByUserId = async (
  userId: number,
  params?: {
    limit?: number;
    page?: number;
    from?: string;
    to?: string;
  }
): Promise<{ entries: Mood[]; total: number; page: number; nextPage: number | null }> => {
  const page  = params?.page  ?? 1;
  const limit = params?.limit ?? 20;
  const skip  = (page - 1) * limit;

  const where = {
    userId,
    ...(params?.from || params?.to ? {
      moment: {
        ...(params.from && { gte: new Date(params.from) }),
        ...(params.to   && { lte: new Date(params.to)   }),
      }
    } : {}),
  };

  const [entries, total] = await Promise.all([
    prisma.mood.findMany({
      where,
      include: { moodComponents: true },
      orderBy: { moment: 'desc' },
      take: limit,
      skip,
    }),
    prisma.mood.count({ where }),
  ]);

  const totalPages = Math.ceil(total / limit);

  return {
    entries,
    total,
    page,
    nextPage: page < totalPages ? page + 1 : null,
  };
};

export const getMoodById = async (id: number): Promise<Mood | null> => {
  return await prisma.mood.findUnique({
    where: {
      id
    },
    include: { moodComponents: true }
  });
}

export const destroyMoodById = async (userId: number, id: number): Promise<Mood> => {
  return await prisma.mood.delete({
    where: {
      id,
      userId
    }
  })
}