页面历史

 public interface ISDKGridDataFilter {
	void doFilter(ISDKGridData gridData);
   	int doFilterSetPageRows(int rows);
   	int doFilterGetAllRows(int rows);
    public boolean accept(String dataSourceId,String bizViewId,String reportId,String reportName);
}

package bof.ext.sample9_8;
 
import java.util.ArrayList;
import java.util.List;
import comsmartbi.freequery.extension.ISDKGridData;
import comsmartbi.freequery.extension.ISDKGridDataFilter;
import comsmartbi.freequery.querydata.CellData;
import smartbi.freequery.report.SimpleReportBO;
/**
 * 假设有一张报表，name = "小计合计";<BR>
 * 包含有4列，分别是：产品目录名称、产品名称、数量、运费；<BR>
 * 在报表中，通过设置表格属性，使得靠左边的两列自动合并单元格；
 * 要求：加入合计和小计的功能。数量和运费都是求和。
 */
public class GridDataFilterDemoA implements ISDKGridDataFilter {
    	class NamePair {
       		int index;
       		List<CellData> row;
    	}
 
@SuppressWarnings("unchecked")
	public void doFilter(ISDKGridData gridData) {
    		List<List<CellData>> rows = gridData.getData();
    		String lastCat = null;
    		String lastProduct = null;
    		List<NamePair> newRows = new ArrayList<NamePair>();
     		for (int i = 0;i<rows i < rows.size(); i++) {
          			List<CellData> row =  rows.get(i);
          			String cat = row.get(0).getDisplayValue();
          			String product = row.get(1).getDisplayValue();
          			if (lastCat == null)
              				lastCat = cat;
          			if (lastProduct == null)
              				lastProduct = product;
			if ("小计".equals(cat)) {
				lastCat = null;
				continue;
   			}
			if (!lastCat.equals(cat)) {
				//加入小计行               每类小计
				NamePair pair = new NamePair();
              				pair.index = i;
              				pair.row = new ArrayList<CellData>();
              				newRows.add(pair);
				lastCat = cat;
				System.out.println("产品类别发生改变，变为" + lastCat);
			}
			if (i == rows.size() - 1)  lastCat = cat;
           }
     }
     NamePair lastPair = new NamePair();
     lastPair.index = rows.size();
     lastPair.row = new ArrayList<CellData>();
     newRows.add(lastPair);
     {
				// 每页小计
				NamePair lastPair = new NamePair();
				lastPair.index = rows.size();
				lastPair.row = new ArrayList<CellData>();
				newRows.add(lastPair);
			}
			System.out.println("第" + (i + 1) + "行的产品类别为：" + cat + "产品名称为："
					+ product);
		}
		System.out.println("总行数为" + rows.size());
		System.out.println("小计行集合newRows的长度为" + newRows.size());
		// System.out.println("lastPair在第" +
		// rows.size()+"行，index = "+lastPair.index+" row = "+lastPair.row);
		for (int i = newRows.size() - 1;i> i >= 0; i--) {
			System.out.println("设置第" + (newRows.size() - i) +    "条小计行前两列的数据");
			NamePair pair = newRows.get(i);
         			int endRowIndex = pair.index - 1;
         			int startRowIndex = 0;
         			if (i>0){i > 0)           {
				startRowIndex = ((NamePair) newRows.get(i - 1)).index ;
         }
         for			}
			for (int k = 0;k< k <= 1; k++) { // 设置前面两列
            				CellData cell = new CellData();
              				pair.row.add(cell);
              				cell.setStringValue("小计");
              				cell.setDisplayValue("小计");
         }
         for			}
			for (int col = 2;col<gridData col < gridData.getColumnsCount(); col++) {
             				double total = 0;
             				CellData tmpData = new CellData();
             				pair.row.add(tmpData);
             				for (int m = startRowIndex;m< m <= endRowIndex; ;m++){
                  {
					CellData tmpCell =  gridData.get(m, col);
                 					if (tmpCell.getType().name().equals("INTEGER")){
                     {
						total += tmpCell.getIntValue();
                    						if (m == endRowIndex){
                         {
							tmpData.setIntValue((int) total);
                        							tmpData.setDisplayValue(String.valueOf((int) total));
                    }
                }
               						}
					} else if (tmpCell.getType().name().equals("DOUBLE")){
                    {
						total += tmpCell.getDoubleValue();
						total = (double) Math.round(total * 100) /              100;
						if (m == endRowIndex){
                          {
							tmpData.setDoubleValue(total);
                         							tmpData.setDisplayValue(String
									.valueOf((double) total));
                    }
                }
              }
           }
           						}
					}
				}
			}
			rows.add(pair.index, pair.row);
       }
    }
 
			System.out.println(rows);
		}
	}
	/* 该过滤器只针对小计合计这张报表 */
	public boolean accept(String dataSourceId, String bizViewId,
       			String reportId, String reportName) {
       if (reportName.equalsIgnoreCase("小计合计"))
           return true;
       else
           return false;
 	}
  		System.out.println("dataSourceId:" + dataSourceId + "  bizViewId:"
				+ bizViewId + "   reportId:" + reportId + "  reportName:"
				+ reportName);
		if ("报表数据过滤器分析".equalsIgnoreCase(reportName))
			return true;
		else
			return false;
	}
	public int doFilterGetAllRows(int rows) {
		return rows;
 	}
	//public TODO Auto-generated method stub
        int doFilterSetPageRows(int rows) {
		return rows;
	}
	@Override

	public intvoid doFilterSetPageRowsdoFilterClientId(intString rowsarg0) {
    		// TODO Auto-generated method stub
	}
	@Override
	public void doFilterSetBo(SimpleReportBO arg0) {
	return rows;
	// TODO Auto-generated method stub
	}
}

<gridData-filter-chain>
    <filter>bof.ext.sample9_8.GridDataFilterDemoA</filter>
</gridData-filter-chain>