GET ALL children API

.ts

async findAll(
    i18n: I18nContext,
    dto: FilterChildDto,
    user: User,
  ): Promise<Pagination<Child>> {
    const { relation, take, skip, search, sharedCarerId } = dto;
    const query = this.childRepo.createQueryBuilder('child');
    switch (relation) {
      case UserType.PARENT:
        if (sharedCarerId) {
          query
            .innerJoin('child.carerChildren', 'carerChild')
            .andWhere('carerChild.carerId= :carerId', {
              carerId: sharedCarerId,
            });
        }
        query.andWhere('userId = :id ', { id: user.id });
        break;
      case UserType.CARER:
        if (sharedCarerId)
          throw new UnauthorizedException(new AppError(ERR_UNAUTHORIZED));
        query
          .innerJoin('child.carerChildren', 'carerChild')
          .andWhere('carerChild.carerId= :carerId', { carerId: user.id });
        break;
    }

    // for attachment
    query
      .leftJoinAndSelect(
        'child.profileImageAttachment',
        'profileImageAttachment',
      )
      .leftJoinAndSelect('child.videoIntroAttachment', 'videoIntroAttachment');

    // for children who cared by a carer with id UUID
    if (search) {
      query.andWhere('(LOWER(child.fullName) LIKE LOWER(:search))', {
        search: `%${search}%`,
      });
    }
    query.take(take ?? Constant.TAKE);
    query.skip(skip ?? Constant.SKIP);
    const [data, total] = await query.getManyAndCount();
    return new Pagination<Child>(data, total);
  }