com.scudata.ide.spl.control.CellSetParser Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of esproc Show documentation
Show all versions of esproc Show documentation
SPL(Structured Process Language) A programming language specially for structured data computing.
The newest version!
package com.scudata.ide.spl.control;
import java.awt.Color;
import java.awt.Font;
import com.scudata.cellset.datamodel.CellSet;
import com.scudata.cellset.datamodel.ColCell;
import com.scudata.cellset.datamodel.NormalCell;
import com.scudata.cellset.datamodel.PgmCellSet;
import com.scudata.cellset.datamodel.PgmNormalCell;
import com.scudata.cellset.datamodel.RowCell;
import com.scudata.common.StringUtils;
import com.scudata.ide.common.ConfigOptions;
import com.scudata.ide.common.GC;
import com.scudata.ide.common.GM;
/**
* ?????????
*
*/
public class CellSetParser {
/**
* ?ո???
*/
private static NormalCell blankCell;
/**
* ???????
*/
private CellSet cellSet;
/**
* ????????????
*
* @param cellSet
* ???????
*/
public CellSetParser(CellSet cellSet) {
this.cellSet = cellSet;
blankCell = new PgmNormalCell();
}
/**
* ȡ???????
*
* @return
*/
public CellSet getCellSet() {
return cellSet;
}
/**
* ȡ??Ԫ?????
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public NormalCell getCell(int row, int col) {
return getCell(row, col, false);
}
/**
* ȡ??Ԫ?????
*
* @param row
* ?к?
* @param col
* ?к?
* @param create
* ָ????Ԫ??Ϊnullʱ?Ƿ?????
* @return
*/
public NormalCell getCell(int row, int col, boolean create) {
NormalCell cell = (NormalCell) cellSet.getCell(row, col);
if (cell == null) {
if (create) {
return new PgmNormalCell();
} else {
return blankCell;
}
}
return cell;
}
/**
* ȡ??Ԫ??ļ??
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public int getCellIndent(int row, int col) {
return ConfigOptions.iIndent.intValue();
}
/** ע????߿? */
public static final byte TYPE_NOTE = 1;
/** ?????ִ?и???߿? */
public static final byte TYPE_CALC = 2;
/** ?????? */
public static final byte TYPE_CONST = 3;
/** ??ֵ?????? */
public static final byte TYPE_CONST_NULL = 4;
/** ????ʽ */
public static final byte TYPE_EXP = 5;
/** ??ֵ????ʽ */
public static final byte TYPE_EXP_NULL = 6;
/**
* ȡ??Ԫ??????
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public byte getCellDispType(int row, int col) {
NormalCell cell = getCell(row, col);
int type = cell.getType();
byte dispType = TYPE_EXP_NULL;
switch (type) {
case NormalCell.TYPE_NOTE_CELL:
case NormalCell.TYPE_NOTE_BLOCK:
return TYPE_NOTE;
case NormalCell.TYPE_CALCULABLE_CELL:
case NormalCell.TYPE_CALCULABLE_BLOCK:
case NormalCell.TYPE_EXECUTABLE_CELL:
case NormalCell.TYPE_EXECUTABLE_BLOCK:
dispType = TYPE_CALC;
break;
}
// ?ӵ?һ?п?ʼ???ϲ??ң??Ҳ??????Ҳ???һֱ??col-1??
int topRow = 1;
NormalCell temp;
for (int c = 1; c < col; c++) {
for (int r = row; r >= topRow; r--) {
temp = getCell(r, c);
switch (temp.getType()) {
case NormalCell.TYPE_NOTE_BLOCK:
return TYPE_NOTE;
case NormalCell.TYPE_CALCULABLE_BLOCK:
case NormalCell.TYPE_EXECUTABLE_BLOCK:
dispType = TYPE_CALC;
topRow = r;
break;
default:
if (StringUtils.isValidString(temp.getExpString())) {
topRow = r;
break;
}
}
}
}
if (cell.getType() == NormalCell.TYPE_CONST_CELL) { // ??????
if (isSubCell(row, col)) {
return TYPE_CONST_NULL;
}
if (dispType != TYPE_CALC) { // ?????ִ?и??ڼ????ִ?п???,??????ʽ????ʾ ???Ҳ???????
return TYPE_CONST;
}
}
if (cell.getValue() != null) { // ??ֵ????ʽ
return TYPE_EXP;
} else { // ??ֵ????ʽ
return TYPE_EXP_NULL;
}
}
/**
* ȡ???????е?Ԫ?????ʾ????
* @param cellSet
* @return
*/
public static byte[][] getCellDispTypes(PgmCellSet cellSet) {
CellSetParser parser = new CellSetParser(cellSet);
int rc = cellSet.getRowCount();
int cc = cellSet.getColCount();
byte[][] dispTypes = new byte[rc][cc];
for (int r = 1; r <= rc; r++) {
dispTypes[r - 1] = new byte[cc];
for (int c = 1; c <= cc; c++) {
dispTypes[r - 1][c - 1] = parser.getCellDispType(r, c);
}
}
return dispTypes;
}
/**
* ?Ƿ??Ӹ?
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
private boolean isSubCell(int row, int col) {
int colCount = cellSet.getColCount();
NormalCell nc;
String expStr;
for (int r = row; r >= 1; r--) {
for (int c = colCount; c >= 1; c--) {
if (r == row && c > col) {
c = col;
continue;
}
nc = getCell(r, c);
expStr = nc.getExpString();
if (!StringUtils.isValidString(expStr)) {
continue;
}
if (!isSubString(expStr)) {
return false;
}
switch (nc.getType()) {
case NormalCell.TYPE_CALCULABLE_CELL:
case NormalCell.TYPE_CALCULABLE_BLOCK:
case NormalCell.TYPE_EXECUTABLE_CELL:
case NormalCell.TYPE_EXECUTABLE_BLOCK:
return true;
case NormalCell.TYPE_CONST_CELL:
continue;
default:
return false;
}
}
}
return false;
}
/**
* ????ʽ?Ƿ??Ӹ?
*
* @param expStr
* @return
*/
private boolean isSubString(String expStr) {
char lastChar = expStr.charAt(expStr.length() - 1);
if (lastChar != ',' && lastChar != ';' && lastChar != '(') {
return false;
}
return true;
}
/**
* ȡ??Ԫ??ɫ
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public Color getBackColor(int row, int col) {
return getCellTypeColor(row, col, false);
}
/**
* ȡ??Ԫ??ǰ??ɫ
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public Color getForeColor(int row, int col) {
return getCellTypeColor(row, col, true);
}
/**
* ȡ??Ԫ?????Ͷ?Ӧ????ɫ
*
* @param row
* ?к?
* @param col
* ?к?
* @param isGetForeground
* ?Ƿ?ȡǰ??ɫ??trueǰ??ɫ??false????ɫ
* @return
*/
protected Color getCellTypeColor(int row, int col, boolean isGetForeground) {
byte type = getCellDispType(row, col);
if (type == TYPE_NOTE) { // ע???????ע?Ϳ???
return isGetForeground ? ConfigOptions.iNoteFColor
: ConfigOptions.iNoteBColor;
}
if (type == TYPE_CONST_NULL) {
return isGetForeground ? ConfigOptions.iNValueFColor
: ConfigOptions.iNValueBColor;
}
if (type == TYPE_CONST) { // ?????ִ?и??ڼ????ִ?п???,??????ʽ????ʾ ???Ҳ???????
return isGetForeground ? ConfigOptions.iConstFColor
: ConfigOptions.iConstBColor;
}
if (type == TYPE_EXP) { // ??ֵ????ʽ
return isGetForeground ? ConfigOptions.iValueFColor
: ConfigOptions.iValueBColor;
} else { // ??ֵ????ʽ
return isGetForeground ? ConfigOptions.iNValueFColor
: ConfigOptions.iNValueBColor;
}
}
/**
* ȡ??Ԫ????ʾ?ı?
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public String getDispText(int row, int col) {
NormalCell nc = getCell(row, col);
String text;
text = nc.getExpString();
return text;
}
/**
* ȡ??Ԫ??????
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public Font getFont(int row, int col, float scale) {
return GM.getScaleFont(scale);
}
/**
* ȡ??Ԫ??????????
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public String getFontName(int row, int col) {
return GC.font.getFontName();
}
/**
* ȡ??Ԫ???????С
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public int getFontSize(int row, int col) {
return GC.font.getSize();
}
/**
* ȡ??Ԫ????ʾ??ʽ
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public String getFormat(int row, int col) {
return null;
}
/**
* ȡ??Ԫ??ˮƽ????
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public byte getHAlign(int row, int col) {
return ConfigOptions.iHAlign.byteValue();
}
/**
* ȡ??ֱ????
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public byte getVAlign(int row, int col) {
return ConfigOptions.iVAlign.byteValue();
}
/**
* ??Ԫ???Ƿ?Ӵ?
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public boolean isBold(int row, int col) {
return ConfigOptions.bBold.booleanValue();
}
/**
* ??Ԫ???Ƿ?б??
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public boolean isItalic(int row, int col) {
return ConfigOptions.bItalic.booleanValue();
}
/**
* ??Ԫ???Ƿ??»???
*
* @param row
* ?к?
* @param col
* ?к?
* @return
*/
public boolean isUnderline(int row, int col) {
return ConfigOptions.bUnderline.booleanValue();
}
/**
* ȡ????
*
* @return
*/
public int getRowCount() {
return cellSet.getRowCount();
}
/**
* ȡ?иߣ????????з???0
*
* @param row
* @return
*/
public int getRowHeight(int row, float scale) {
RowCell cell = (RowCell) cellSet.getRowCell(row);
float height = cell.getHeight();
int h = (int) Math.ceil(height * scale);
if (scale != 1.0) {
h += 1;
}
return h;
}
/**
* ?????????
*
* @return ??????
*/
public int getColCount() {
return cellSet.getColCount();
}
/**
* ȡ?п?
*
* @param col
* ?к?
* @param scale
* ??ʾ????
* @return
*/
public int getColWidth(int col, float scale) {
ColCell cell = (ColCell) cellSet.getColCell(col);
float width = cell.getWidth();
int w = (int) Math.ceil(width * scale);
if (scale != 1.0) {
w += 1;
}
return w;
}
/**
* ???Ƿ????
*
* @param row
* ?к?
* @return
*/
public boolean isRowVisible(int row) {
RowCell rc = (RowCell) cellSet.getRowCell(row);
return rc.getVisible() != RowCell.VISIBLE_ALWAYSNOT;
}
/**
* ???Ƿ????
*
* @param col
* ?к?
* @return
*/
public boolean isColVisible(int col) {
ColCell cc = (ColCell) cellSet.getColCell(col);
return cc.getVisible() != ColCell.VISIBLE_ALWAYSNOT;
}
/**
* ȡ???п???
*
* @param control
* ????ؼ?
* @param startCol
* ??ʼ??
* @param count
* ????
* @return
*/
public int getColsWidth(SplControl control, int startCol, int count,
float scale) {
int width = 0;
for (int i = 0, col = startCol; i < count; i++, col++) {
if (!isColVisible(col)) {
continue;
}
width += getColWidth(col, scale);
}
return width;
}
/**
* ȡ???и߶?
*
* @param control
* ????ؼ?
* @param startRow
* ??ʼ??
* @param count
* ????
* @return
*/
public int getRowsHeight(SplControl control, int startRow, int count,
float scale) {
int height = 0;
for (int i = 0, row = startRow; i < count; i++, row++) {
if (!isRowVisible(row)) {
continue;
}
height += getRowHeight(row, scale);
}
return height;
}
/**
* ȡ???еĽ?????
*
* @param row
* @return
*/
public int getSubEnd(int row) {
PgmNormalCell cell;
int subEnd = -1;
for (int c = 1, cc = cellSet.getColCount(); c <= cc; c++) {
cell = (PgmNormalCell) cellSet.getCell(row, c);
switch (cell.getType()) {
case PgmNormalCell.TYPE_CALCULABLE_BLOCK:
case PgmNormalCell.TYPE_EXECUTABLE_BLOCK:
case PgmNormalCell.TYPE_NOTE_BLOCK:
case PgmNormalCell.TYPE_COMMAND_CELL:
subEnd = ((PgmCellSet) cellSet).getCodeBlockEndRow(row, c);
if (subEnd > row) {
return subEnd;
}
break;
}
}
return subEnd;
}
/**
* ?????Ƿ????
*
* @param row
* ?к?
* @param subEnd
* ????ĩ??
* @return
*/
public boolean isSubExpand(int row, int subEnd) {
if (subEnd <= row)
return false;
RowCell rc = (RowCell) cellSet.getRowCell(row + 1);
return rc.getVisible() != RowCell.VISIBLE_ALWAYSNOT;
}
}