달력에서 연속 15일간의 데이터만 뽑아서 보여주는 API를 만들어보자 (Ver. 2)

public async findDailyTrend({
    date,
}: FindDailyTrendRequestDto): Promise<SvcResponse> {
  const requestDate = new Date(
    `${date.split('.')[0]}/${Number(date.split('.')[1])}/${Number(
      date.split('.')[2]
    )}`
  );

  const today = dayjs(requestDate).format();
  let after15days;

  await this.db 
    .collection(`[COLLECTION NAME]`)
    .aggregate([])
    .toArray()
    .then((allDailyDatasArr: any) => {
      allDailyDatasArr.forEach((dailyDatas: any) => {
        const date = new Date(dailyDatas.datas.timestamp).toLocaleString();
        if (date === requestDate.toLocaleString()) {
          after15days = dayjs(requestDate).add(15, 'day').format();
        }
      });
    });

  let resultArr = [];
  await this.db 
    .collection(`[COLLECTION NAME]`)
    .find() // 💡
    .toArray()
    .then((allDatas) => {
      allDatas.forEach((data: any) => {
        if (
          today <= dayjs(new Date(data.datas.timestamp)).format() &&
          after15days > dayjs(new Date(data.datas.timestamp)).format()
        ) {
          resultArr.push(data.datas);
        }
      });
    });
  return {
    data: JSON.stringify(resultArr),
    statusCode: HttpStatus.OK,
  };
}

private async find15daysData(
  date: string,
  subtractedDate: string,
  collectionName: string
) {
  const data = await this.db
    .collection(collectionName)
    .find({
      $expr: {
        $and: [
          {
            $gt: [
              {
                $dateFromString: {
                  dateString: '$datas.timestamp',
                },
              },
              new Date(subtractedDate),
            ],
          },
          {
            $lt: [
              {
                $dateFromString: {
                  dateString: '$datas.timestamp',
                },
              },
              new Date(date),
            ],
          },
        ],
      },
    })
    .toArray();

  data.sort((a: any, b: any) => {
    if (new Date(a.datas.timestamp) > new Date(b.datas.timestamp)) {
      return 1;
    } else {
      return -1;
    }
  });

  return data;
}

private convertStartDate(startDate: string): string {
  let sMonth =
    startDate.slice(4, 5) === '0' ? startDate.slice(5, 6) : startDate.slice(4, 6);
  let sDate =
    startDate.slice(6, 7) === '0' ? startDate.slice(7, 8) : startDate.slice(6, 8);
  let sYear = startDate.slice(0, 4);

  const date: string = `${sMonth}/${Number(sDate) + 1}/${sYear}`;

  return date;
}

public async findEC2DailyTrend({
    date,
  }: FindDailyTrendRequestDto): Promise<SvcResponse> {
    const pickedDate = this.convertStartDate(date);
    const before15daysDate = dayjs(pickedDate).subtract(15, 'day').format();
    console.log(pickedDate, before15daysDate);

    const data = await this.find15daysData(
      pickedDate,
      before15daysDate,
      `[collection name]`
    );

    if (data.length < 15) {
      return {
        data: JSON.stringify(data),
        message: 'under 15',
        statusCode: HttpStatus.OK,
      };
    }

    return {
      data: JSON.stringify(data),
      statusCode: HttpStatus.OK,
    };
  }