private void setComplexUniqueKeyMatrix(
HSSFWorkbook workbook,
HSSFSheet sheet,
ERTable table,
CellLocation cellLocation,
MatrixCellStyle matrixCellStyle,
boolean isLogical) {
int rowNum = cellLocation.r;
int columnNum = cellLocation.c;
HSSFRow headerTemplateRow = sheet.getRow(rowNum);
HSSFCell headerTemplateCell = headerTemplateRow.getCell(columnNum);
int num = table.getComplexUniqueKeyList().size();
if (num == 0) {
headerTemplateRow.removeCell(headerTemplateCell);
HSSFRow row = sheet.getRow(rowNum - 1);
if (row != null) {
HSSFCell cell = row.getCell(columnNum);
if (cell != null) {
cell.getCellStyle().setBorderBottom(headerTemplateCell.getCellStyle().getBorderBottom());
}
}
return;
}
HSSFRow headerRow = sheet.createRow(rowNum++);
for (int i = 0; i < num + 1; i++) {
HSSFCell cell = headerRow.createCell(columnNum + i);
if (i == 0) {
cell.setCellStyle(matrixCellStyle.style11);
} else {
ComplexUniqueKey complexUniqueKey = table.getComplexUniqueKeyList().get(i - 1);
HSSFRichTextString text =
new HSSFRichTextString(Format.null2blank(complexUniqueKey.getUniqueKeyName()));
cell.setCellValue(text);
if (i != num) {
cell.setCellStyle(matrixCellStyle.style12);
} else {
cell.setCellStyle(matrixCellStyle.style13);
}
}
}
int columnSize = table.getExpandedColumns().size();
for (int j = 0; j < columnSize; j++) {
NormalColumn normalColumn = table.getExpandedColumns().get(j);
HSSFRow row = POIUtils.insertRow(sheet, rowNum++);
for (int i = 0; i < num + 1; i++) {
HSSFCell cell = row.createCell(columnNum + i);
if (i == 0) {
String columnName = null;
if (isLogical) {
columnName = normalColumn.getLogicalName();
} else {
columnName = normalColumn.getPhysicalName();
}
HSSFRichTextString text = new HSSFRichTextString(columnName);
cell.setCellValue(text);
cell.setCellStyle(headerTemplateCell.getCellStyle());
if (j != columnSize - 1) {
cell.setCellStyle(matrixCellStyle.style21);
} else {
cell.setCellStyle(matrixCellStyle.style31);
}
} else {
ComplexUniqueKey complexUniqueKey = table.getComplexUniqueKeyList().get(i - 1);
List<NormalColumn> targetColumnList = complexUniqueKey.getColumnList();
int indexNo = targetColumnList.indexOf(normalColumn);
if (indexNo != -1) {
cell.setCellValue(indexNo + 1);
}
if (i != num) {
if (j != columnSize - 1) {
cell.setCellStyle(matrixCellStyle.style22);
} else {
cell.setCellStyle(matrixCellStyle.style32);
}
} else {
if (j != columnSize - 1) {
cell.setCellStyle(matrixCellStyle.style23);
} else {
cell.setCellStyle(matrixCellStyle.style33);
}
}
}
}
}
}
public void setTableData(HSSFWorkbook workbook, HSSFSheet sheet, ERTable table) {
POIUtils.replace(
sheet,
KEYWORD_LOGICAL_TABLE_NAME,
this.getValue(this.keywordsValueMap, KEYWORD_LOGICAL_TABLE_NAME, table.getLogicalName()));
POIUtils.replace(
sheet,
KEYWORD_PHYSICAL_TABLE_NAME,
this.getValue(this.keywordsValueMap, KEYWORD_PHYSICAL_TABLE_NAME, table.getPhysicalName()));
POIUtils.replace(
sheet,
KEYWORD_TABLE_DESCRIPTION,
this.getValue(this.keywordsValueMap, KEYWORD_TABLE_DESCRIPTION, table.getDescription()));
POIUtils.replace(
sheet,
KEYWORD_TABLE_CONSTRAINT,
this.getValue(this.keywordsValueMap, KEYWORD_TABLE_CONSTRAINT, table.getConstraint()));
CellLocation cellLocation = POIUtils.findCell(sheet, FIND_KEYWORDS_OF_COLUMN);
if (cellLocation != null) {
int rowNum = cellLocation.r;
HSSFRow templateRow = sheet.getRow(rowNum);
if (this.columnTemplate == null) {
this.columnTemplate = this.loadColumnTemplate(workbook, sheet, cellLocation);
}
int order = 1;
for (NormalColumn normalColumn : table.getExpandedColumns()) {
HSSFRow row = POIUtils.insertRow(sheet, rowNum++);
this.setColumnData(this.keywordsValueMap, columnTemplate, row, normalColumn, table, order);
order++;
}
this.setCellStyle(
columnTemplate,
sheet,
cellLocation.r,
rowNum - cellLocation.r,
templateRow.getFirstCellNum());
}
CellLocation fkCellLocation = POIUtils.findCell(sheet, FIND_KEYWORDS_OF_FK_COLUMN);
if (fkCellLocation != null) {
int rowNum = fkCellLocation.r;
HSSFRow templateRow = sheet.getRow(rowNum);
if (this.fkColumnTemplate == null) {
this.fkColumnTemplate = this.loadColumnTemplate(workbook, sheet, fkCellLocation);
}
int order = 1;
for (NormalColumn normalColumn : table.getExpandedColumns()) {
if (normalColumn.isForeignKey()) {
HSSFRow row = POIUtils.insertRow(sheet, rowNum++);
this.setColumnData(
this.keywordsValueMap, this.fkColumnTemplate, row, normalColumn, table, order);
order++;
}
}
this.setCellStyle(
this.fkColumnTemplate,
sheet,
fkCellLocation.r,
rowNum - fkCellLocation.r,
templateRow.getFirstCellNum());
}
this.setIndexMatrix(workbook, sheet, table);
this.setComplexUniqueKeyMatrix(workbook, sheet, table);
}