package com.vci.ubcs.starter.bo;

import java.util.List;

public class WriteExcelData {
	private int row;
	private int col;
	private Object obj;
	private String objCode;
	private boolean merged = false;
	private int rowTo;
	private int colTo;
	private boolean copyStyle = false;
	private int copyStyleRow;
	private int copyStyleCol;
	private boolean center;
	private boolean formula = false;
	private boolean nameRefer = false;
	private boolean validation = false;
	private List<String> validationDataList;
	private String validationErrorMsg;
	private String fontColor;
	private String align;
	private String dateFormat;
	private boolean readOnly;
	private Integer width;

	public String getObjCode() {
		return objCode;
	}

	public void setObjCode(String objCode) {
		this.objCode = objCode;
	}

	public String getFontColor() {
		return this.fontColor;
	}

	public void setFontColor(String fontColor) {
		this.fontColor = fontColor;
	}

	public String getAlign() {
		return this.align;
	}

	public void setAlign(String align) {
		this.align = align;
	}

	public List<String> getValidationDataList() {
		return this.validationDataList;
	}

	public void setValidationDataList(List<String> validationDataList) {
		this.validationDataList = validationDataList;
	}

	public WriteExcelData() {
	}

	public WriteExcelData(int row, int col, Object obj) {
		this.row = row;
		this.col = col;
		this.obj = obj;
	}

	public WriteExcelData(int row, int col, Object obj,String objCode) {
		this.row = row;
		this.col = col;
		this.obj = obj;
		this.objCode = objCode;
	}

	public WriteExcelData(int row, int col, Object obj,String objCode,boolean copyStyle) {
		this.row = row;
		this.col = col;
		this.obj = obj;
		this.objCode = objCode;
		this.copyStyle = copyStyle;
	}

	public void writeFormula(int row, int col, String foumula) {
		this.row = row;
		this.col = col;
		this.obj = foumula;
		this.formula = true;
	}

	public void writeNameRefer(int row, int col, int rowTo, int colTo, String name) {
		this.row = row;
		this.col = col;
		this.obj = name;
		this.nameRefer = true;
		this.rowTo = rowTo;
		this.colTo = colTo;
	}

	public void writeComboBox(List<String> comboBoxData, int row, int col, int rowTo, int colTo) {
		this.writeComboBox(comboBoxData, (String)null, row, col, rowTo, colTo);
	}

	public void writeComboBox(List<String> comboBoxData, String errorMsg, int row, int col, int rowTo, int colTo) {
		this.validationDataList = comboBoxData;
		this.validation = true;
		this.validationErrorMsg = errorMsg;
		this.row = row;
		this.col = col;
		this.rowTo = rowTo;
		this.colTo = colTo;
	}

	public void writeUseRefer(String referFormula, int row, int col, int rowTo, int colTo) {
		this.writeUseRefer(referFormula, (String)null, row, col, rowTo, colTo);
	}

	public void writeUseRefer(String referFormula, String errorMsg, int row, int col, int rowTo, int colTo) {
		this.validation = true;
		this.obj = referFormula;
		this.validationErrorMsg = errorMsg;
		this.row = row;
		this.col = col;
		this.rowTo = rowTo;
		this.colTo = colTo;
	}

	public boolean isReadOnly() {
		return this.readOnly;
	}

	public void setReadOnly(boolean readOnly) {
		this.readOnly = readOnly;
	}

	public int getRow() {
		return this.row;
	}

	public void setRow(int row) {
		this.row = row;
	}

	public int getCol() {
		return this.col;
	}

	public void setCol(int col) {
		this.col = col;
	}

	public Object getObj() {
		return this.obj;
	}

	public void setObj(Object obj) {
		this.obj = obj;
	}

	public boolean isMerged() {
		return this.merged;
	}

	public void setMerged(boolean merged) {
		this.merged = merged;
	}

	public int getRowTo() {
		return this.rowTo;
	}

	public void setRowTo(int rowTo) {
		this.rowTo = rowTo;
	}

	public int getColTo() {
		return this.colTo;
	}

	public void setColTo(int colTo) {
		this.colTo = colTo;
	}

	public boolean isCopyStyle() {
		return this.copyStyle;
	}

	public void setCopyStyle(boolean copyStyle) {
		this.copyStyle = copyStyle;
	}

	public int getCopyStyleRow() {
		return this.copyStyleRow;
	}

	public void setCopyStyleRow(int copyStyleRow) {
		this.copyStyleRow = copyStyleRow;
	}

	public int getCopyStyleCol() {
		return this.copyStyleCol;
	}

	public void setCopyStyleCol(int copyStyleCol) {
		this.copyStyleCol = copyStyleCol;
	}

	public boolean isCenter() {
		return this.center;
	}

	public void setCenter(boolean center) {
		this.center = center;
	}

	public boolean isFormula() {
		return this.formula;
	}

	public void setFormula(boolean formula) {
		this.formula = formula;
	}

	public boolean isNameRefer() {
		return this.nameRefer;
	}

	public void setNameRefer(boolean nameRefer) {
		this.nameRefer = nameRefer;
	}

	public boolean isValidation() {
		return this.validation;
	}

	public void setValidation(boolean validation) {
		this.validation = validation;
	}

	public String getValidationErrorMsg() {
		return this.validationErrorMsg;
	}

	public void setValidationErrorMsg(String validationErrorMsg) {
		this.validationErrorMsg = validationErrorMsg;
	}

	public String getDateFormat() {
		return this.dateFormat;
	}

	public void setDateFormat(String dateFormat) {
		this.dateFormat = dateFormat;
	}

	public Integer getWidth() {
		return this.width;
	}

	public void setWidth(Integer width) {
		this.width = width;
	}

	public String toString() {
		return "WriteExcelData{row=" + this.row + ", col=" + this.col + ", obj=" + this.obj + ", merged=" + this.merged + ", rowTo=" + this.rowTo + ", colTo=" + this.colTo + ", copyStyle=" + this.copyStyle + ", copyStyleRow=" + this.copyStyleRow + ", copyStyleCol=" + this.copyStyleCol + ", center=" + this.center + ", formula=" + this.formula + ", nameRefer=" + this.nameRefer + ", validation=" + this.validation + ", validationDataList=" + this.validationDataList + ", validationErrorMsg='" + this.validationErrorMsg + '\'' + ", fontColor='" + this.fontColor + '\'' + ", align='" + this.align + '\'' + ", dateFormat='" + this.dateFormat + '\'' + ", readOnly=" + this.readOnly + '}';
	}
}