import { DateCriterionValue } from "./generic_criterion";
import { Style, UID } from "./misc";
import { Range } from "./range";

// -----------------------------------------------------------------------------
// Conditional Formatting
// -----------------------------------------------------------------------------

/**
 * https://docs.microsoft.com/en-us/openspecs/office_standards/ms-xlsx/025ea6e4-ad42-43ea-a016-16f4e4688ac8
 */

export interface ConditionalFormat {
  id: UID;
  rule: ConditionalFormatRule; // the rules to apply, in order;
  stopIfTrue?: boolean; // the next rules must not be evaluated/applied if this rule is true
  ranges: string[]; // the cells/ranges on which to apply this conditional formatting
}

export interface ConditionalFormatInternal extends Omit<ConditionalFormat, "ranges" | "rule"> {
  ranges: Range[];
  rule: ConditionalFormatRuleInternal;
}

export type ConditionalFormatRule = SingleColorRules | ColorScaleRule | IconSetRule | DataBarRule;
export type ConditionalFormatRuleInternal =
  | SingleColorRules
  | ColorScaleRule
  | IconSetRule
  | DataBarRuleInternal;
export type SingleColorRules = CellIsRule;
// not implemented
// | ExpressionRule
// | ContainsTextRule
// | NotContainsTextRule
// | BeginsWithRule
// | EndsWithRule
// | containsBlanksRule
// | notContainsBlanksRule
// | containsErrorsRule
// | notContainsErrorsRule
// | TimePeriodRule
// | AboveAverageRule
// | Top10Rule;

export interface SingleColorRule {
  style: Style;
}

export interface TextRule extends SingleColorRule {
  text: string;
}
export interface CellIsRule extends SingleColorRule {
  type: "CellIsRule";
  operator: ConditionalFormattingOperatorValues;
  // can be one value for all operator except between, then it is 2 values
  values: string[];
  dateValue?: DateCriterionValue;
  isPercent?: boolean;
  isBottom?: boolean;
}
export interface ExpressionRule extends SingleColorRule {
  type: "ExpressionRule";
}

export type ThresholdType = "value" | "number" | "percentage" | "percentile" | "formula";

export type ColorScaleThreshold = {
  color: number;
  type: ThresholdType;
  value?: string;
};

export type ColorScaleMidPointThreshold = {
  color: number;
  type: Exclude<ThresholdType, "value">;
  value: string;
};

export type IconThreshold = {
  type: Exclude<ThresholdType, "value">;
  operator: "gt" | "ge";
  value: string;
};

export interface ColorScaleRule {
  type: "ColorScaleRule";
  minimum: ColorScaleThreshold;
  maximum: ColorScaleThreshold;
  midpoint?: ColorScaleMidPointThreshold;
}

export interface DataBarRule {
  type: "DataBarRule";
  color: number;
  rangeValues?: string;
}

export interface DataBarRuleInternal extends Omit<DataBarRule, "rangeValues"> {
  rangeValues?: Range;
}

export interface IconSet {
  upper: string;
  middle: string;
  lower: string;
}
export interface IconSetRule {
  type: "IconSetRule";
  icons: IconSet;
  upperInflectionPoint: IconThreshold;
  lowerInflectionPoint: IconThreshold;
}
export interface ContainsTextRule extends TextRule {
  type: "ContainsTextRule";
}
export interface NotContainsTextRule extends TextRule {
  type: "NotContainsTextRule";
}
export interface BeginsWithRule extends TextRule {
  type: "BeginsWithRule";
}
export interface EndsWithRule extends TextRule {
  type: "EndsWithRule";
}
export interface containsBlanksRule extends TextRule {
  type: "containsBlanksRule";
}
export interface notContainsBlanksRule extends TextRule {
  type: "notContainsBlanksRule";
}
export interface containsErrorsRule extends SingleColorRule {
  type: "containsErrorsRule";
}
export interface notContainsErrorsRule extends SingleColorRule {
  type: "notContainsErrorsRule";
}
export interface TimePeriodRule extends SingleColorRule {
  type: "TimePeriodRule";
  timePeriod: string;
}
export interface AboveAverageRule extends SingleColorRule {
  type: "AboveAverageRule";
  /*"true" The conditional formatting rule is applied to cells with values above the average value of all cells in the range.
    "false" The conditional formatting rule is applied to cells with values below the average value of all cells in the range.*/
  aboveAverage: boolean;
  equalAverage: boolean;
}

//https://docs.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.conditionalformattingoperatorvalues?view=openxml-2.8.1
// Note: IsEmpty and IsNotEmpty does not exist on the specification

const cfOperators = [
  "containsText",
  "notContainsText",
  "isGreaterThan",
  "isGreaterOrEqualTo",
  "isLessThan",
  "isLessOrEqualTo",
  "isBetween",
  "isNotBetween",
  "beginsWithText",
  "endsWithText",
  "isNotEmpty",
  "isEmpty",
  "isNotEqual",
  "isEqual",
  "customFormula",
  "dateIs",
  "dateIsBefore",
  "dateIsAfter",
  "dateIsOnOrBefore",
  "dateIsOnOrAfter",
  "top10",
  "uniqueValues",
  "duplicateValues",
] as const;

export type ConditionalFormattingOperatorValues = (typeof cfOperators)[number];

export const availableConditionalFormatOperators: Set<ConditionalFormattingOperatorValues> =
  new Set(cfOperators);