Function buildQueryToFetchPaginatedDocs

utils/progresses.js:132–159

(queryParams)

 */

const buildQueryToFetchPaginatedDocs = async (queryParams) => {
  const { type, userId, taskId, orderBy, size = PROGRESSES_SIZE, page = PROGRESSES_PAGE_SIZE } = queryParams;
  const orderByField = PROGRESS_VALID_SORT_FIELDS[0];
  const isAscOrDsc = orderBy && PROGRESS_VALID_SORT_FIELDS[0] === orderBy ? "asc" : "desc";
  const limit = parseInt(size, 10);
  const offset = parseInt(page, 10) * limit;

  let baseQuery;
  if (type) {
    baseQuery = progressesCollection.where("type", "==", type).orderBy(orderByField, isAscOrDsc);
  } else if (userId) {
    baseQuery = progressesCollection
      .where("type", "==", "user")
      .where("userId", "==", userId)
      .orderBy(orderByField, isAscOrDsc);
  } else {
    baseQuery = progressesCollection
      .where("type", "==", "task")
      .where("taskId", "==", taskId)
      .orderBy(orderByField, isAscOrDsc);
  }

  const totalProgress = await baseQuery.get();
  const totalProgressCount = totalProgress.size;

  baseQuery = baseQuery.limit(limit).offset(offset);
  return { baseQuery, totalProgressCount };
};

/**
 * Retrieves progress documents from Firestore based on the given query.