Function buildQueryToFetchDocs

utils/progresses.js:105–123

(queryParams)

 * @returns {Query} A Firestore query object that filters progress documents based on the given parameters.
 */
const buildQueryToFetchDocs = (queryParams) => {
  const { type, userId, taskId, orderBy } = queryParams;
  const orderByField = PROGRESS_VALID_SORT_FIELDS[0];
  const isAscOrDsc = orderBy && PROGRESS_VALID_SORT_FIELDS[0] === orderBy ? "asc" : "desc";

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

/**
 * Builds a Firestore query to retrieve a paginated list of progress documents within a date range,