import {
  CoreCommand,
  CoreCommandTypes,
  DEFAULT_LOCALE,
  isRangeDependant,
  isTargetDependent,
  isZoneDependent,
  Locale,
  SpreadsheetPivotTable,
  TableStyle,
} from "../../src";
import { DEFAULT_BORDER_DESC } from "../../src/constants";
import { DEFAULT_TABLE_CONFIG } from "../../src/helpers/table_presets";
import { toZone } from "../../src/helpers/zones";
import { PivotCoreDefinition } from "../../src/types/pivot";
import { toChartDataSource } from "./chart_helpers";
import { target, toRangesData } from "./helpers";

export const TEST_CHART_DATA = {
  basicChart: {
    type: "bar" as const,
    ...toChartDataSource({
      dataSets: [
        {
          dataRange: "B1:B4",
          yAxisId: "y",
        },
      ],
      labelRange: "A2:A4",
      dataSetsHaveTitle: true,
    }),
    title: { text: "hello" },
    background: "#FFFFFF",
    stacked: false,
    legendPosition: "top" as const,
    humanize: true,
  },
  combo: {
    type: "combo" as const,
    ...toChartDataSource({
      dataSets: [
        {
          dataRange: "B1:B4",
          yAxisId: "y",
        },
      ],
      labelRange: "A2:A4",
      dataSetsHaveTitle: true,
    }),
    title: { text: "hello" },
    background: "#FFFFFF",
    legendPosition: "top" as const,
    humanize: true,
  },
  scorecard: {
    type: "scorecard" as const,
    keyValue: "=B1:B4",
    baseline: "=A2:A4",
    title: { text: "hello" },
    baselineDescr: { text: "description" },
    baselineMode: "difference" as const,
    humanize: true,
  },
  funnel: {
    type: "funnel" as const,
    keyValue: "=B1:B4",
    baseline: "A2:A4",
    title: { text: "hello" },
    baselineDescr: { text: "description" },
    baselineMode: "difference" as const,
  },
  gauge: {
    type: "gauge" as const,
    dataRange: "B1:B4",
    title: { text: "hello" },
    humanize: true,
    sectionRule: {
      rangeMin: "0",
      rangeMax: "100",
      colors: {
        lowerColor: "#6aa84f",
        middleColor: "#f1c232",
        upperColor: "#cc0000",
      },
      lowerInflectionPoint: {
        type: "number" as const,
        value: "33",
        operator: "<=" as const,
      },
      upperInflectionPoint: {
        type: "number" as const,
        value: "66",
        operator: "<=" as const,
      },
    },
  },
  calendar: {
    type: "calendar" as const,
    ...toChartDataSource({
      dataSets: [{ dataRange: "B1" }],
      labelRange: "A1",
    }),
    title: { text: "hello" },
    background: "#FFFFFF",
  },
  bubble: {
    type: "bubble" as const,
    xRange: "A2:A5",
    yRanges: ["B2:B5"],
    labelRange: "C2:C5",
    sizeRange: "D2:D5",
    title: { text: "Bubble Chart" },
  },
};

const PIVOT: PivotCoreDefinition = {
  dataSet: {
    zone: toZone("A1:B1"),
    sheetId: "Sheet1",
  },
  columns: [],
  rows: [],
  measures: [
    {
      id: "computed",
      aggregator: "sum",
      computedBy: { formula: "=0", sheetId: "Sheet1" },
      fieldName: "computed",
    },
  ],
  filters: [],
  name: "pivot",
  type: "SPREADSHEET",
};

type CommandMapping = {
  [key in CoreCommandTypes]: Extract<CoreCommand, { type: key }>;
};

export const TEST_COMMANDS: CommandMapping = {
  UPDATE_CELL: {
    type: "UPDATE_CELL",
    col: 0,
    row: 0,
    content: "hello",
    sheetId: "Sheet1",
  },
  UPDATE_CELL_POSITION: {
    type: "UPDATE_CELL_POSITION",
    cellId: -1, // Makes this command always rejected in monkey party
    sheetId: "Sheet1",
    row: 0,
    col: 0,
  },
  CLEAR_CELL: {
    type: "CLEAR_CELL",
    col: 0,
    row: 0,
    sheetId: "Sheet1",
  },
  CLEAR_CELLS: {
    type: "CLEAR_CELLS",
    target: target("A1"),
    sheetId: "Sheet1",
  },
  DELETE_CONTENT: {
    type: "DELETE_CONTENT",
    target: target("A1"),
    sheetId: "Sheet1",
  },
  ADD_MERGE: {
    type: "ADD_MERGE",
    target: target("A1:A2"),
    sheetId: "Sheet1",
  },
  REMOVE_MERGE: {
    type: "REMOVE_MERGE",
    target: target("A1:A2"),
    sheetId: "Sheet1",
  },
  SET_FORMATTING: {
    type: "SET_FORMATTING",
    target: target("A1"),
    style: { bold: true },
    sheetId: "Sheet1",
  },
  CLEAR_FORMATTING: {
    type: "CLEAR_FORMATTING",
    target: target("A1"),
    sheetId: "Sheet1",
  },
  SET_BORDER: {
    type: "SET_BORDER",
    col: 0,
    row: 0,
    border: { top: DEFAULT_BORDER_DESC },
    sheetId: "Sheet1",
  },
  SET_BORDERS_ON_TARGET: {
    type: "SET_BORDERS_ON_TARGET",
    target: target("A1"),
    border: { top: DEFAULT_BORDER_DESC },
    sheetId: "Sheet1",
  },
  CREATE_TABLE: {
    type: "CREATE_TABLE",
    ranges: toRangesData("sheetId", "A1"),
    sheetId: "Sheet1",
    tableType: "static",
    config: DEFAULT_TABLE_CONFIG,
  },
  REMOVE_TABLE: {
    type: "REMOVE_TABLE",
    target: target("A1"),
    sheetId: "Sheet1",
  },
  UPDATE_TABLE: {
    type: "UPDATE_TABLE",
    sheetId: "Sheet1",
    zone: { top: 0, left: 0, bottom: 1, right: 1 },
  },
  CREATE_TABLE_STYLE: {
    type: "CREATE_TABLE_STYLE",
    tableStyleId: "MyStyle",
    tableStyleName: "MyStyle",
    templateName: "lightWithHeader",
    primaryColor: "#0f0",
  },
  REMOVE_TABLE_STYLE: {
    type: "REMOVE_TABLE_STYLE",
    tableStyleId: "MyStyle",
  },
  HIDE_SHEET: {
    type: "HIDE_SHEET",
    sheetId: "Sheet1",
  },
  CREATE_SHEET: {
    type: "CREATE_SHEET",
    sheetId: "newSheetId",
    name: "newSheetName",
    position: 0,
  },
  DUPLICATE_SHEET: {
    type: "DUPLICATE_SHEET",
    sheetId: "Sheet1",
    sheetIdTo: "duplicateSheetId",
    sheetNameTo: "Copy of Sheet1",
  },
  MOVE_SHEET: {
    type: "MOVE_SHEET",
    sheetId: "Sheet1",
    delta: -1,
  },
  DELETE_SHEET: {
    type: "DELETE_SHEET",
    sheetId: "Sheet1",
    sheetName: "newSheetName",
  },
  RENAME_SHEET: {
    type: "RENAME_SHEET",
    sheetId: "Sheet1",
    newName: "newName",
    oldName: "newSheetName",
  },
  COLOR_SHEET: {
    type: "COLOR_SHEET",
    sheetId: "Sheet1",
  },
  SET_SHEET_BACKGROUND_COLOR: {
    type: "SET_SHEET_BACKGROUND_COLOR",
    sheetId: "Sheet1",
  },
  SHOW_SHEET: {
    type: "SHOW_SHEET",
    sheetId: "Sheet1",
  },
  ADD_CONDITIONAL_FORMAT: {
    type: "ADD_CONDITIONAL_FORMAT",
    ranges: toRangesData("sheetId", "A1"),
    cf: {
      id: "cfId",
      rule: {
        values: ["1"],
        operator: "isEqual",
        type: "CellIsRule",
        style: { fillColor: "#FF0000" },
      },
    },
    sheetId: "Sheet1",
  },
  REMOVE_CONDITIONAL_FORMAT: {
    type: "REMOVE_CONDITIONAL_FORMAT",
    id: "cfId",
    sheetId: "Sheet1",
  },
  CHANGE_CONDITIONAL_FORMAT_PRIORITY: {
    type: "CHANGE_CONDITIONAL_FORMAT_PRIORITY",
    sheetId: "Sheet1",
    cfId: "cfId",
    delta: 1,
  },
  CREATE_FIGURE: {
    type: "CREATE_FIGURE",
    figureId: "figureId",
    tag: "tag",
    offset: {
      x: 0,
      y: 0,
    },
    col: 0,
    row: 0,
    size: {
      width: 100,
      height: 100,
    },
    sheetId: "Sheet1",
  },
  DELETE_FIGURE: {
    type: "DELETE_FIGURE",
    figureId: "figureId",
    sheetId: "Sheet1",
  },
  UPDATE_FIGURE: {
    type: "UPDATE_FIGURE",
    figureId: "figureId",
    sheetId: "Sheet1",
    col: 0,
    row: 0,
  },
  CREATE_CHART: {
    type: "CREATE_CHART",
    definition: TEST_CHART_DATA.basicChart,
    col: 0,
    row: 0,
    offset: { x: 0, y: 0 },
    size: { width: 200, height: 200 },
    figureId: "figureId",
    chartId: "chartId",
    sheetId: "Sheet1",
  },
  UPDATE_CHART: {
    type: "UPDATE_CHART",
    definition: TEST_CHART_DATA.basicChart,
    figureId: "figureId",
    chartId: "chartId",
    sheetId: "Sheet1",
  },
  CREATE_IMAGE: {
    type: "CREATE_IMAGE",
    offset: { x: 0, y: 0 },
    col: 0,
    row: 0,
    size: { width: 200, height: 200 },
    definition: { path: "/image/1", size: { width: 200, height: 200 } },
    sheetId: "Sheet1",
    figureId: "figureId",
  },
  RESIZE_COLUMNS_ROWS: {
    type: "RESIZE_COLUMNS_ROWS",
    dimension: "ROW",
    elements: [0],
    size: 100,
    sheetId: "Sheet1",
  },
  ADD_COLUMNS_ROWS: {
    type: "ADD_COLUMNS_ROWS",
    position: "after",
    dimension: "ROW",
    base: 0,
    quantity: 1,
    sheetId: "Sheet1",
    sheetName: "newSheetName",
  },
  REMOVE_COLUMNS_ROWS: {
    type: "REMOVE_COLUMNS_ROWS",
    dimension: "ROW",
    elements: [0],
    sheetId: "Sheet1",
    sheetName: "newSheetName",
  },
  FREEZE_COLUMNS: {
    type: "FREEZE_COLUMNS",
    sheetId: "Sheet1",
    quantity: 1,
  },
  FREEZE_ROWS: {
    type: "FREEZE_ROWS",
    sheetId: "Sheet1",
    quantity: 1,
  },
  UNFREEZE_COLUMNS: {
    type: "UNFREEZE_COLUMNS",
    sheetId: "Sheet1",
  },
  UNFREEZE_ROWS: {
    type: "UNFREEZE_ROWS",
    sheetId: "Sheet1",
  },
  UNFREEZE_COLUMNS_ROWS: {
    type: "UNFREEZE_COLUMNS_ROWS",
    sheetId: "Sheet1",
  },
  HIDE_COLUMNS_ROWS: {
    type: "HIDE_COLUMNS_ROWS",
    dimension: "ROW",
    elements: [0],
    sheetId: "Sheet1",
  },
  UNHIDE_COLUMNS_ROWS: {
    type: "UNHIDE_COLUMNS_ROWS",
    dimension: "ROW",
    elements: [0],
    sheetId: "Sheet1",
  },
  SET_GRID_LINES_VISIBILITY: {
    type: "SET_GRID_LINES_VISIBILITY",
    sheetId: "Sheet1",
    areGridLinesVisible: true,
  },
  MOVE_RANGES: {
    type: "MOVE_RANGES",
    target: target("A1"),
    sheetId: "Sheet1",
    targetSheetId: "Sheet1",
    sheetName: "Sheet1",
    col: 0,
    row: 0,
  },
  SET_ZONE_BORDERS: {
    type: "SET_ZONE_BORDERS",
    sheetId: "Sheet1",
    target: target("A1"),
    border: { position: "top", style: "thin", color: "#000000" },
  },
  UPDATE_LOCALE: {
    type: "UPDATE_LOCALE",
    locale: DEFAULT_LOCALE,
  },
  GROUP_HEADERS: {
    type: "GROUP_HEADERS",
    sheetId: "Sheet1",
    dimension: "ROW",
    start: 0,
    end: 1,
  },
  UNGROUP_HEADERS: {
    type: "UNGROUP_HEADERS",
    sheetId: "Sheet1",
    dimension: "ROW",
    start: 0,
    end: 1,
  },
  UNFOLD_HEADER_GROUP: {
    type: "UNFOLD_HEADER_GROUP",
    sheetId: "Sheet1",
    dimension: "ROW",
    start: 0,
    end: 1,
  },
  FOLD_HEADER_GROUP: {
    type: "FOLD_HEADER_GROUP",
    sheetId: "Sheet1",
    dimension: "ROW",
    start: 0,
    end: 1,
  },
  UNFOLD_ALL_HEADER_GROUPS: {
    type: "UNFOLD_ALL_HEADER_GROUPS",
    sheetId: "Sheet1",
    dimension: "ROW",
  },
  FOLD_ALL_HEADER_GROUPS: {
    type: "FOLD_ALL_HEADER_GROUPS",
    sheetId: "Sheet1",
    dimension: "ROW",
  },
  UNFOLD_HEADER_GROUPS_IN_ZONE: {
    type: "UNFOLD_HEADER_GROUPS_IN_ZONE",
    sheetId: "Sheet1",
    dimension: "ROW",
    zone: { top: 0, left: 0, bottom: 1, right: 1 },
  },
  FOLD_HEADER_GROUPS_IN_ZONE: {
    type: "FOLD_HEADER_GROUPS_IN_ZONE",
    sheetId: "Sheet1",
    dimension: "ROW",
    zone: { top: 0, left: 0, bottom: 1, right: 1 },
  },
  ADD_DATA_VALIDATION_RULE: {
    type: "ADD_DATA_VALIDATION_RULE",
    sheetId: "Sheet1",
    ranges: toRangesData("sheetId", "A1"),
    rule: {
      id: "dvId",
      criterion: {
        type: "containsText",
        values: ["1"],
      },
    },
  },
  REMOVE_DATA_VALIDATION_RULE: {
    type: "REMOVE_DATA_VALIDATION_RULE",
    sheetId: "Sheet1",
    id: "dvId",
  },
  ADD_PIVOT: {
    type: "ADD_PIVOT",
    pivotId: "1",
    pivot: PIVOT,
  },
  INSERT_PIVOT: {
    type: "INSERT_PIVOT",
    pivotId: "1",
    sheetId: "Sheet1",
    col: 0,
    row: 0,
    table: new SpreadsheetPivotTable([[]], [], [], {}).export(),
  },
  UPDATE_PIVOT: {
    type: "UPDATE_PIVOT",
    pivotId: "1",
    pivot: { ...PIVOT, name: "Pivot2" },
  },
  DUPLICATE_PIVOT: {
    type: "DUPLICATE_PIVOT",
    pivotId: "1",
    newPivotId: "2",
    duplicatedPivotName: "newName",
  },
  RENAME_PIVOT: {
    type: "RENAME_PIVOT",
    pivotId: "1",
    name: "newName",
  },
  REMOVE_PIVOT: {
    type: "REMOVE_PIVOT",
    pivotId: "1",
  },
  CREATE_CAROUSEL: {
    type: "CREATE_CAROUSEL",
    sheetId: "Sheet1",
    figureId: "figureId",
    offset: { x: 0, y: 0 },
    col: 0,
    row: 0,
    size: { width: 200, height: 200 },
    definition: {
      items: [{ type: "chart", chartId: "chartId" }],
    },
  },
  UPDATE_CAROUSEL: {
    type: "UPDATE_CAROUSEL",
    sheetId: "Sheet1",
    figureId: "figureId",
    definition: {
      items: [{ type: "chart", chartId: "chartId" }],
    },
  },
  DELETE_CHART: {
    type: "DELETE_CHART",
    sheetId: "Sheet1",
    chartId: "chartId",
  },
  LOCK_SHEET: {
    type: "LOCK_SHEET",
    sheetId: "Sheet1",
  },
  UNLOCK_SHEET: {
    type: "UNLOCK_SHEET",
    sheetId: "Sheet1",
  },
  CREATE_NAMED_RANGE: {
    type: "CREATE_NAMED_RANGE",
    name: "MyNamedRange",
    ranges: toRangesData("sheetId", "A1"),
  },
  UPDATE_NAMED_RANGE: {
    type: "UPDATE_NAMED_RANGE",
    oldRangeName: "MyNamedRange",
    newRangeName: "MyNewNamedRange",
    ranges: toRangesData("sheetId", "A1"),
  },
  DELETE_NAMED_RANGE: {
    type: "DELETE_NAMED_RANGE",
    name: "MyNamedRange",
  },
};

export const OT_TESTS_SINGLE_CELL_COMMANDS = [
  TEST_COMMANDS.UPDATE_CELL,
  TEST_COMMANDS.UPDATE_CELL_POSITION,
  TEST_COMMANDS.CLEAR_CELL,
  TEST_COMMANDS.SET_BORDER,
];

export const TEST_COMMANDS_TARGET_DEPENDENT = Object.values(TEST_COMMANDS).filter((cmd) =>
  isTargetDependent(cmd)
);

export const TEST_COMMANDS_ZONE_DEPENDENT = Object.values(TEST_COMMANDS).filter((cmd) =>
  isZoneDependent(cmd)
);

export const TEST_COMMANDS_RANGE_DEPENDENT = Object.values(TEST_COMMANDS).filter((cmd) =>
  isRangeDependant(cmd)
);

export const OT_TESTS_HEADER_GROUP_COMMANDS = [
  TEST_COMMANDS.GROUP_HEADERS,
  TEST_COMMANDS.UNGROUP_HEADERS,
  TEST_COMMANDS.FOLD_HEADER_GROUP,
  TEST_COMMANDS.UNFOLD_HEADER_GROUP,
];

export const EN_LOCALE = DEFAULT_LOCALE;

export const FR_LOCALE: Locale = {
  name: "French",
  code: "fr_FR",
  thousandsSeparator: " ",
  decimalSeparator: ",",
  weekStart: 1,
  dateFormat: "dd/mm/yyyy",
  timeFormat: "hh:mm:ss",
  formulaArgSeparator: ";",
};

export const CUSTOM_LOCALE: Locale = {
  name: "Custom locale",
  code: "cus_TOM",
  thousandsSeparator: " ",
  decimalSeparator: ",",
  weekStart: 6,
  dateFormat: "dd/mm/yyyy",
  timeFormat: "hh:mm:ss a",
  formulaArgSeparator: ";",
};

export const TABLE_STYLE_ALL_RED: TableStyle = {
  category: "dark",
  displayName: "AllRed",
  wholeTable: { style: { fillColor: "#FF0000" }, border: { top: DEFAULT_BORDER_DESC } },
  firstColumn: { style: { bold: true } },
  lastColumn: { style: { bold: true } },
  headerRow: { style: { bold: true } },
  totalRow: { style: { bold: true } },
  templateName: "dark",
  primaryColor: "#FF0000",
};