import type { QueryCriteriaOperators } from "./index";

type SalesAnalyticsReportFilterKeys =
  | "is_void"
  | "client_id"
  | "rep"
  | "admin"
  | "creator._id"
  | "status"
  | "time"
  | "issue_date"
  | "due_date"
  | "createdAt"
  | "updatedAt"
  | "client.chain"
  | "client.channel"
  | "client.city"
  | "client.state"
  | "client.country"
  | "client.tags"
  | "client.CLIENT_TAGS"
  | "client.AREA_TAGS"
  | "product.brand"
  | "product.category"
  | "product.sub_category"
  | "product.product_groups"
  | "promotions._id"
  | "items.measureunit._id"
  | "items.return_reason"
  | "items.variant.variant_id"
  | "items.variant.product_id"
  | "items.promotion_type"
  | "items.class"
  | "items.discounted_price"
  | "items.tax._id"
  | "items.tax.name"
  | "items.tax.type"
  | "return_items.tax.name"
  | "return_items.tax.type"
  | "return_items.measureunit._id"
  | "return_items.return_reason"
  | "return_items.variant.variant_id"
  | "return_items.variant.product_id"
  | "return_items.promotion_type"
  | "return_items.class"
  | "return_items.discounted_price"
  | "return_items.tax._id"
  | "teams"
  | "route"
  | "custom_status";

interface SalesAnalyticsReportFilter extends Record<
  SalesAnalyticsReportFilterKeys,
  QueryCriteriaOperators[]
> {
  is_void: ["in"];
  client_id: ["in", "nin"];
  rep: ["in", "nin"];
  admin: ["in", "nin"];
  "creator._id": ["in", "nin"];
  status: ["in", "nin"];
  time: [
    "between",
    "last_seven_days",
    "last_thirty_days",
    "last_month",
    "last_three_months",
    "last_six_months",
    "last_twelve_months",
    "yesterday",
    "today",
    "gte",
    "lte",
    "lt",
    "gt",
  ];
  issue_date: [
    "between",
    "last_seven_days",
    "last_thirty_days",
    "last_month",
    "last_three_months",
    "last_six_months",
    "last_twelve_months",
    "yesterday",
    "today",
    "gte",
    "lte",
    "lt",
    "gt",
  ];
  due_date: [
    "between",
    "last_seven_days",
    "last_thirty_days",
    "last_month",
    "last_three_months",
    "last_six_months",
    "last_twelve_months",
    "yesterday",
    "today",
    "gte",
    "lte",
    "lt",
    "gt",
  ];
  createdAt: [
    "between",
    "last_seven_days",
    "last_thirty_days",
    "last_month",
    "last_three_months",
    "last_six_months",
    "last_twelve_months",
    "yesterday",
    "today",
    "gte",
    "lte",
    "lt",
    "gt",
  ];
  updatedAt: [
    "between",
    "last_seven_days",
    "last_thirty_days",
    "last_month",
    "last_three_months",
    "last_six_months",
    "last_twelve_months",
    "yesterday",
    "today",
    "gte",
    "lte",
    "lt",
    "gt",
  ];
  "client.chain": ["in", "nin"];
  "client.channel": ["in", "nin"];
  "client.city": ["in", "nin"];
  "client.state": ["in", "nin"];
  "client.country": ["in", "nin"];
  "client.tags": ["in", "nin"];
  "client.CLIENT_TAGS": ["in", "nin"];
  "client.AREA_TAGS": ["in", "nin"];
  "product.brand": ["in", "nin"];
  "product.category": ["in", "nin"];
  "product.sub_category": ["in", "nin"];
  "product.product_groups": ["in", "nin"];
  "promotions._id": ["in", "nin"];
  "items.promos": ["in", "nin"];
  "items.measureunit._id": ["in", "nin"];
  "items.return_reason": ["in", "nin"];
  "items.variant.variant_id": ["in", "nin"];
  "items.variant.product_id": ["in", "nin"];
  "items.promotion_type": ["in", "nin"];
  "items.class": ["in", "nin"];
  "items.discounted_price": ["between"];
  "items.tax._id": ["in", "nin"];
  "items.tax.name": ["in", "nin"];
  "items.tax.type": ["in", "nin"];
  "return_items.tax.name": ["in", "nin"];
  "return_items.tax.type": ["in", "nin"];
  "return_items.measureunit._id": ["in", "nin"];
  "return_items.return_reason": ["in", "nin"];
  "return_items.variant.variant_id": ["in", "nin"];
  "return_items.variant.product_id": ["in", "nin"];
  "return_items.promotion_type": ["in", "nin"];
  "return_items.class": ["in", "nin"];
  "return_items.discounted_price": ["between"];
  "return_items.tax._id": ["in", "nin"];
  teams: ["in", "nin"];
  route: ["in", "nin"];
  custom_status: ["in", "nin"];
}

type SalesAnalyticsReportProjectionKey =
  | "issue_date"
  | "due_date"
  | "serial_number"
  | "advanced_serial_number"
  | "external_serial_number"
  | "return_serial_number"
  | "client"
  | "client_code"
  | "creator"
  | "rep_username"
  | "teams"
  | "route"
  | "custom_status"
  | "workorder_serial_number"
  | "line_number"
  | "lines"
  | "status"
  | "product"
  | "product_local_name"
  | "product_sku"
  | "product_barcode"
  | "variant"
  | "variant_local_name"
  | "variant_sku"
  | "variant_barcode"
  | "category"
  | "sub_category"
  | "brand"
  | "product_groups"
  | "promotion"
  | "promotion_ref"
  | "promotion_type"
  | "class"
  | "class"
  | "return_reason"
  | "chain"
  | "channel"
  | "country"
  | "state"
  | "city"
  | "area_tags"
  | "client_tags"
  | "original_price"
  | "tax"
  | "visit_uuid"
  | "base_unit_qty"
  | "qty"
  | "measureunit"
  | "price"
  | "tax"
  | "line_total"
  | "lineTotalAfterDeduction"
  | "deduction"
  | "total_before_tax"
  | "discount_amount"
  | "tax_total"
  | "tax_total_after_deduction"
  | "pre_total"
  | "return_total"
  | "total"
  | "balance"
  | "tax_total_after_deduction"
  | `client_customFields.${string}`
  | `rep_customFields.${string}`;

type SalesAnalyticsReportSortedKey =
  | "issue_date"
  | "due_date"
  | "createdAt"
  | "updatedAt"
  | "time"
  | "line_total"
  | "pre_total"
  | "return_total"
  | "total"
  | "balance"
  | "items.tax_total_after_deduction"
  | "items.lineTotalAfterDeduction"
  | "items.price"
  | "discount_amount"
  | "tax_total"
  | "items.base_unit_qty"
  | "items.qty"
  | "items.deduction";

type SalesAnalyticsGroupByIDs = {
  client:
    | "client_name"
    | "client_id"
    | "client_code"
    | "client_local_name"
    | "chain"
    | "channel"
    | "client_customFields"
    | "tags"
    | "country"
    | "state"
    | "city";
  user:
    | "creator_id"
    | "creator_type"
    | "creator_name"
    | "creator_customFields"
    | "creator_username";
  issue_date: "issue_date";
  due_date: "due_date";
  serial_number:
    "serial_number" | "external_serial_number" | "return_serial_number";
  product:
    | "product_name"
    | "product_local_name"
    | "product"
    | "price"
    | "measureunit"
    | "base_unit_qty"
    | "qty"
    | "discount_amount"
    | "tax"
    | "return_reason"
    | "line_total"
    | "tax_total"
    | "total_before_tax"
    | "lineTotalAfterDeduction"
    | "deduction"
    | "tax_total_after_deduction"
    | "original_price"
    | "product_sku"
    | "product_barcode"
    | "sub_category"
    | "product_groups"
    | "category"
    | "brand";
  variant:
    | "variant_name"
    | "variant_local_name"
    | "variant_sku"
    | "variant_barcode"
    | "price"
    | "measureunit"
    | "base_unit_qty"
    | "qty"
    | "discount_amount"
    | "tax"
    | "return_reason"
    | "line_total"
    | "tax_total"
    | "total_before_tax"
    | "lineTotalAfterDeduction"
    | "deduction"
    | "tax_total_after_deduction"
    | "original_price";
  brand:
    | "brand"
    | "price"
    | "measureunit"
    | "base_unit_qty"
    | "qty"
    | "discount_amount"
    | "tax"
    | "return_reason"
    | "line_total"
    | "tax_total"
    | "total_before_tax"
    | "lineTotalAfterDeduction"
    | "deduction"
    | "tax_total_after_deduction"
    | "original_price";
  category:
    | "category"
    | "price"
    | "measureunit"
    | "base_unit_qty"
    | "qty"
    | "discount_amount"
    | "tax"
    | "return_reason"
    | "line_total"
    | "tax_total"
    | "total_before_tax"
    | "lineTotalAfterDeduction"
    | "deduction"
    | "tax_total_after_deduction"
    | "original_price";
  status: "status";
  promotion_type:
    | "promotion_type"
    | "price"
    | "measureunit"
    | "base_unit_qty"
    | "qty"
    | "discount_amount"
    | "tax"
    | "return_reason"
    | "line_total"
    | "tax_total"
    | "total_before_tax"
    | "lineTotalAfterDeduction"
    | "deduction"
    | "tax_total_after_deduction"
    | "original_price";
  class:
    | "class"
    | "price"
    | "measureunit"
    | "base_unit_qty"
    | "qty"
    | "discount_amount"
    | "tax"
    | "return_reason"
    | "line_total"
    | "tax_total"
    | "total_before_tax"
    | "lineTotalAfterDeduction"
    | "deduction"
    | "tax_total_after_deduction"
    | "original_price";
  measureunit:
    | "measureunit"
    | "price"
    | "base_unit_qty"
    | "qty"
    | "discount_amount"
    | "tax"
    | "return_reason"
    | "line_total"
    | "tax_total"
    | "total_before_tax"
    | "lineTotalAfterDeduction"
    | "deduction"
    | "tax_total_after_deduction"
    | "original_price";
  promotion:
    | "promotions"
    | "promotion_ref"
    | "promotion_type"
    | "price"
    | "measureunit"
    | "base_unit_qty"
    | "qty"
    | "discount_amount"
    | "tax"
    | "return_reason"
    | "line_total"
    | "tax_total"
    | "total_before_tax"
    | "lineTotalAfterDeduction"
    | "deduction"
    | "tax_total_after_deduction"
    | "original_price";
  chain: "client_name" | "chain";
  channel: "client_name" | "channel";
  city: "client_name" | "city";
  state: "client_name" | "state";
  country: "client_name" | "country";
  route: "route";
  custom_status: "custom_status";
  teams: "teams";
};

type SalesAnalyticsFieldAccumulators = {
  client_name: "first" | "last";
  client_id: "first" | "last";
  client_code: "first" | "last";
  client_local_name: "first" | "last";
  chain: "first" | "last";
  channel: "first" | "last";
  client_customFields: "first" | "last";
  tags: "first" | "last";
  country: "first" | "last";
  state: "first" | "last";
  city: "first" | "last";
  creator_id: "first" | "last";
  creator_type: "first" | "last";
  creator_name: "first" | "last";
  creator_customFields: "first" | "last";
  creator_username: "first" | "last";
  issue_date: "first" | "last";
  due_date: "first" | "last";
  serial_number: "first" | "last";
  external_serial_number: "first" | "last";
  return_serial_number: "first" | "last";
  price: "sum" | "avg" | "max" | "min";
  base_unit_qty: "sum" | "avg" | "max" | "min";
  qty: "sum" | "avg" | "max" | "min";
  discount_amount: "sum" | "avg" | "max" | "min";
  line_total: "sum" | "avg" | "max" | "min";
  tax_total: "sum" | "avg" | "max" | "min";
  total_before_tax: "sum" | "avg" | "ma" | "min";
  lineTotalAfterDeduction: "sum" | "avg" | "max" | "min";
  deduction: "sum" | "avg" | "max" | "min";
  tax_total_after_deduction: "sum" | "avg" | "max" | "min";
  original_price: "avg" | "max" | "min" | "sum";
  measureunit: "addToSet" | "first" | "last";
  tax: "addToSet" | "first" | "last";
  return_reason: "addToSet" | "first" | "last";
  promotion_type: "addToSet" | "first" | "last";
  product_name: "first" | "last";
  product_local_name: "first" | "last";
  product: "first" | "last";
  product_sku: "first" | "last";
  product_barcode: "first" | "last";
  sub_category: "first" | "last";
  product_groups: "first" | "last";
  category: "first" | "last";
  brand: "first" | "last";
  variant_name: "first" | "last";
  variant_local_name: "first" | "last";
  variant_sku: "first" | "last";
  variant_barcode: "first" | "last";
  status: "first" | "last";
  class: "first" | "last";
  promotions: "first" | "last";
  promotion_ref: "first" | "last";
  route: "first" | "last";
  custom_status: "first" | "last";
  teams: "first" | "last";
};

export {
  SalesAnalyticsReportSortedKey,
  SalesAnalyticsGroupByIDs,
  SalesAnalyticsFieldAccumulators,
  SalesAnalyticsReportFilter,
  SalesAnalyticsReportProjectionKey,
};