package gw.rating.rtm.excel

uses gw.api.locale.DisplayKey
uses org.apache.poi.ss.usermodel.ClientAnchor
uses org.apache.poi.ss.usermodel.Comment
uses org.apache.poi.ss.usermodel.Drawing
uses org.apache.poi.ss.usermodel.RichTextString
uses org.apache.poi.ss.usermodel.Sheet
uses org.apache.poi.xssf.usermodel.XSSFClientAnchor
uses org.apache.poi.xssf.usermodel.XSSFDrawing
uses org.apache.poi.xssf.usermodel.XSSFRichTextString
uses gw.lang.Deprecated

class ExcelHeader {
  public static final var RATE_ROUTINE_CODE_ROW: int = 2
  public static final var RATE_ROUTINE_PC_VERSION_ROW: int = 12
  public static final var RATE_ROUTINE_LOCALE_ROW: int = 13

  public static final var RATE_TABLE_CODE_ROW: int = 5
  public static final var RATE_TABLE_PC_VERSION_ROW: int = 8
  public static final var RATE_TABLE_LOCALE_ROW: int = 9

  public static final var RATE_BOOK_RBD_SECTION_HEADER_ROW: int = 2
  public static final var RATE_BOOK_PC_VERSION_ROW: int = 12
  public static final var RATE_BOOK_LOCALE_ROW: int = 13

  public static final var RATE_TABLE_HEADER_START_ROW: int = 0
  public static final var RATE_TABLE_HEADER_END_ROW: int = 11

  @Deprecated(:value="This class does not need to be accessed as a singleton. All members can be simply accessed in a static way.", :version="PC 9.0.0")
  static var _excelHeader : ExcelHeader

  @Deprecated(:value="This class does not need to be accessed as a singleton. All members can be simply accessed in a static way.", :version="PC 9.0.0")
  static function getInstance() : ExcelHeader {
    if(_excelHeader == null){
      _excelHeader = new ExcelHeader()
    }
    return _excelHeader
  }

  @Deprecated(:value="This method does not need to be accessed from a singleton header file. They've been moved to the classes using them", :version="PC 9.0.0")
  function composeDisplayName(codeDisplayName : String) : String {
    return codeDisplayName.concat(DisplayKey.get("Web.Rating.Export.DisplayName"))
  }

  @Deprecated(:value="This method does not need to be accessed from a singleton header file. They've been moved to the classes using them", :version="PC 9.0.0")
  function composeCodeName(code : String) : String {
    return code.concat(DisplayKey.get("Web.Rating.Export.Code"))
  }

  @Deprecated(:value="This method does not need to be accessed from a singleton header file. They've been moved to the classes using them", :version="PC 9.0.0")
  function createDisplayComment(sheet : Sheet) : Comment {
    var drawing = sheet.createDrawingPatriarch()
    return createCellComment(drawing, DisplayKey.get("Web.Rating.Export.DisplayOnly"))
  }

  @Deprecated(:value="This method does not need to be accessed from a singleton header file. They've been moved to the classes using them", :version="PC 9.0.0")
  function createReadOnlyComment(sheet : Sheet) : Comment {
    var drawing = sheet.createDrawingPatriarch()
    return createCellComment(drawing, DisplayKey.get("Web.Rating.Export.DoNotModify"))
  }

  @Deprecated(:value="This method does not need to be accessed from a singleton header file. They've been moved to the classes using them", :version="PC 9.0.0")
  private function createCellComment(drawing : Drawing, comment : String) : Comment {
    var cmt : Comment
    var txt : RichTextString
    if(drawing typeis XSSFDrawing){
      var anchor = new XSSFClientAnchor(0, 0, 0, 0, 0, 0, 3, 3)
      anchor.setAnchorType(ClientAnchor.AnchorType.MOVE_AND_RESIZE)
      cmt = drawing.createCellComment(anchor)
      txt = new XSSFRichTextString(comment)
    }
    cmt.setString(txt)
    return cmt
  }
}