Skip to content

The complete open source platform to run your entire marketplace. Storefront, vendor panel, admin console, and integrations in one enterprise-grade platform you own.

2.1 KB
Raw Blame
import { InjectManager, MedusaService } from "@medusajs/framework/utils"
import { Context } from "@medusajs/framework/types"
import { EntityManager } from "@medusajs/framework/mikro-orm/knex"

import { Review } from "./models"

class ReviewModuleService extends MedusaService({
  Review,
}) {
  @InjectManager()
  async getAvgRating(
    type: "seller" | "product",
    id: string,
    sharedContext?: Context<EntityManager>
  ): Promise<string | null> {
    const knex = sharedContext!.manager!.getKnex()

    const joinField = type === "product" ? "product_id" : "seller_id"
    const joinTable =
      type === "product"
        ? "product_product_review_review"
        : "seller_seller_review_review"

    const [result] = await knex("review")
      .avg("review.rating")
      .leftJoin(joinTable, `${joinTable}.review_id`, "review.id")
      .where(`${joinTable}.${joinField}`, id)

    return result?.avg ?? null
  }

  @InjectManager()
  async getSellersWithRating(
    fields: string[],
    sharedContext?: Context<EntityManager>
  ) {
    const knex = sharedContext!.manager!.getKnex()

    const result = await knex
      .select(...fields.map((f) => `seller.${f}`))
      .avg("review.rating as rating")
      .from("seller")
      .leftJoin(
        "seller_seller_review_review",
        "seller.id",
        "seller_seller_review_review.seller_id"
      )
      .leftJoin("review", "review.id", "seller_seller_review_review.review_id")
      .groupBy("seller.id")

    return result
  }

  @InjectManager()
  async getProductsWithRating(
    fields: string[],
    sharedContext?: Context<EntityManager>
  ) {
    const knex = sharedContext!.manager!.getKnex()

    const result = await knex
      .select(...fields.map((f) => `product.${f}`))
      .avg("review.rating as rating")
      .from("product")
      .leftJoin(
        "product_product_review_review",
        "product.id",
        "product_product_review_review.product_id"
      )
      .leftJoin("review", "review.id", "product_product_review_review.review_id")
      .groupBy("product.id")

    return result
  }
}

export default ReviewModuleService