润乾API操作实例.docx

package nbpt.ts.report.test.helper;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import com.runqian.report4.model.ReportDefine;
import com.runqian.report4.usermodel.DataSetConfig;
import com.runqian.report4.usermodel.DataSetMetaData;
import com.runqian.report4.usermodel.IByteMap;
import com.runqian.report4.usermodel.IColCell;
import com.runqian.report4.usermodel.INormalCell;
import com.runqian.report4.usermodel.IReport;
import com.runqian.report4.usermodel.IRowCell;
import com.runqian.report4.usermodel.MacroMetaData;
import com.runqian.report4.usermodel.Param;
import com.runqian.report4.usermodel.ParamMetaData;
import com.runqian.report4.usermodel.ProcDataSetConfig;
import com.runqian.report4.usermodel.SQLDataSetConfig;
import com.runqian.report4.usermodel.Types;
import com.runqian.report4.util.ReportUtils;

public class RunQianHelper {
private String raqFilesPath = "WebContent/report/zh/";
List<String> reportRaqFileNames = new ArrayList<String>();

public RunQianHelper(){
//File dir = new File(raqFilesPath);
//loadFiles(dir);
}

public List<String> loadFilesa(File dir)
{
File[] files = dir.listFiles();
for (int i = 0; i < files.length; i++) {
if (files[i].isFile()) {
if (files[i].getAbsolutePath().endsWith(".raq")) {
reportRaqFileNames.add(files[i].getAbsolutePath());
}
} else {
loadFiles(files[i]);
}
}
return reportRaqFileNames;
}

/**
* 统一把行高设置成8
*/
@SuppressWarnings("unused")
public void setRowHeight(List<String> arrList)
{
int flag=0;
int index=0;
for(String item : arrList)
{
String fileName = item;
if(!fileName.contains("error"))
{
continue;
}
try {
ReportDefine rd = (ReportDefine)ReportUtils.read(fileName);
int colCount = rd.getColCount();
int rowCount = rd.getRowCount();
for(int i=1; i<=3; i++)
{
IRowCell iRowCell = rd.getRowCell(i);
iRowCell.setRowHeight(8);
for(int j=1; j<=colCount; j++)
{
INormalCell cell = rd.getCell(i, (short)j);
cell.setFontSize((short)12);
}
}
ReportUtils.write(fileName, rd);
} catch (Exception e) {
System.out.println(fileName + "-" + e.toString());
}
System.out.println(fileName + "-" + "已经处理!");
}
System.out.println("处理完成！");
}

/**
* 处理报表javascript链接在新窗口弹出
*/
@SuppressWarnings("unused")
public void adjustJavaScriptWindows(List<String> arrList)
{
int flag=0;
int index=0;
for(String item : arrList)
{
String fileName = item;
try {
ReportDefine rd = (ReportDefine)ReportUtils.read(fileName);
for(short i=1; i<=rd.getColCount(); i++)
{
IColCell colCell = rd.getColCell((short)i);
INormalCell cell = rd.getCell(1, (short)i);
if(cell.getValue() == null)
{
continue;
}
INormalCell cell2 = rd.getCell(2, (short)i);
if(cell2 != null)
{
IByteMap iByteMap = cell2.getExpMap();
if(iByteMap != null && iByteMap.get(INormalCell.LINK) != null)
{
cell2.setHyperlinkWindow("_blank");
System.out.println(fileName + "-" + "已经处理!");
}
}
}
ReportUtils.write(fileName, rd);
} catch (Exception e) {
System.out.println(fileName + "-" + e.toString());
}
}
System.out.println("处理完成！");
}

/**
* 隔行换色的处理
*/
@SuppressWarnings("unused")
public void setRowColor(List<String> arrList)
{
int flag=0;
int index=0;
for(String item : arrList)
{
String fileName = item;
try {
ReportDefine rd = (ReportDefine)ReportUtils.read(fileName);
int colCount = rd.getColCount();
int rowCount = rd.getRowCount();
for(int i=1; i<=rowCount; i++)
{
IRowCell iRowCell = rd.getRowCell(i);
if(IRowCell.TYPE_NORMAL == iRowCell.getRowType())
{
for(int j=1; j<=colCount; j++)
{
INormalCell cell = rd.getCell(i, (short)j);
IByteMap iByteMap = cell.getExpMap();
iByteMap.put(INormalCell.BCOLOR, "if(row()%2==0,-3342337,-1)");
cell.setExpMap(iByteMap);
}
System.out.println(fileName + "-" + "已经处理!");
}
}
ReportUtils.write(fileName, rd);
} catch (Exception e) {
System.out.println(fileName + "-" + e.toString());
}
}
System.out.println("处理完成！");
}

/**
* 处理报表的javascript函数，改成超链接
*/
@SuppressWarnings("unused")
public void adjustJavaScriptColumn(List<String> arrList)
{
int flag=0;
int index=0;
for(String item : arrList)
{
String fileName = item;
try {
ReportDefine rd = (ReportDefine)ReportUtils.read(fileName);
for(short i=1; i<=rd.getColCount(); i++)
{
IColCell colCell = rd.getColCell((short)i);
INormalCell cell = rd.getCell(1, (short)i);
if(cell.getValue() == null)
{
continue;
}
INormalCell cell2 = rd.getCell(2, (short)i);

if(cell2 != null)
{
IByteMap iByteMap = cell2.getExpMap();
if(iByteMap != null && iByteMap.get(INormalCell.LINK) != null)
{
String url= iByteMap.get(INormalCell.LINK).toString();
url = url.replace(";", "");
if(url.contains("javascript:"))
{
int pos1 = url.indexOf("javascript:");
int pos2 = url.lastIndexOf(")\"");
String value = url.substring(pos1+11, pos2+2);
iByteMap.put(INormalCell.LINK, "@webpath+\"pages/report/excel/hyperlinkDisplay.jsp?fun="+value);
cell2.setExpMap(iByteMap);
System.out.println(fileName + "-" + "已经处理!");
}
}
}
}
ReportUtils.write(fileName, rd);
} catch (Exception e) {
System.out.println(fileName + "-" + e.toString());
}
}
System.out.println("处理完成！");
}

/**
* 特殊处理加拨报表，tasktype变成了数值型
*/
@SuppressWarnings("unused")
public void adjustAddTestColumn(List<String> arrList)
{
int index=0;
for(String item : arrList)
{
String fileName = item;
try {
ReportDefine rd = (ReportDefine)ReportUtils.read(fileName);
for(short i=1; i<=rd.getColCount(); i++)
{
IColCell colCell = rd.getColCell((short)i);
INormalCell cell = rd.getCell(1, (short)i);
if(cell.getValue() == null)
{
continue;
}
if(cell.getValue().toString().contains("BSC名称"))
{
if(colCell.getColVisibleExp() != null)
{
colCell.setColVisibleExp("if(str(ds1.tasktype)==\"16\",true,false)");
//System.out.print(colCell.getColVisibleExp());
}
}
if(cell.getValue().toString().contains("加拨任务"))
{
if(colCell.getColVisibleExp() != null)
{
colCell.setColVisibleExp("if(str(ds1.tasktype)==\"14\"||str(ds1.tasktype)==\"19\"||str(ds1.tasktype)==\"\"||ds1.tasktype==null,false, true)");
//System.out.println("--"+colCell.getColVisibleExp());
}
}
}
ReportUtils.write(fileName, rd);
} catch (Exception e) {
System.out.println(fileName + "-" + e.toString());
}
}
System.out.println("处理完成！");
}

/**
* 特殊处理错误类的报表
* @param arrList
*/
@SuppressWarnings("unused")
public void errorReport(List<String> arrList)
{
int index = 1;
for(String item : arrList)
{
String fileName = item; //"E://report//source//zh//078//078-00-1.raq";
try {
String name = fileName.substring(fileName.lastIndexOf("\\")+1, fileName.length());
int pos1 = name.indexOf("-");
int pos2 = name.lastIndexOf("-");
String serviceCode = name.substring(pos1-3, pos1);
String subServiceCode = name.substring(pos1+1, pos2);
String procName = "call p_testrecord"+ serviceCode +subServiceCode+"(?,?,?,?)";

String flag = "";
if (fileName.indexOf("error")<0)
{
continue;
}

ReportDefine rd = (ReportDefine)ReportUtils.read(fileName);
//获取参数元数据
ParamMetaData pmd= rd.getParamMetaData();
if(pmd != null)
{
pmd.clear();
}
//添加需要的参数
//1.webpath
Param param = new Param(); //构造参数定义
param.setParamName("webpath"); //设置参数名
param.setDataType(Types.DT_STRING); //设置参数数据类型
param.setParamType(Param.PARAM_NORMAL); //设置参数类型(普通参数或动态参数)
param.setValue(""); //设参数缺省值
pmd.addParam(param); //把参数定义添加到参数元数据中
//2.flag
param = new Param();
param.setParamName("flag");
param.setDataType(Types.DT_STRING);
param.setParamType(Param.PARAM_NORMAL);
param.setValue("9");
pmd.addParam(param);
//3.fileds
param = new Param();
param.setParamName("fileds");
param.setDataType(Types.DT_STRING);
param.setParamType(Param.PARAM_NORMAL);
param.setValue("");
pmd.addParam(param);
//4.tasktype
param = new Param();
param.setParamName("taskType");
param.setDataType(Types.DT_STRING);
param.setParamType(Param.PARAM_NORMAL);
param.setValue("");
pmd.addParam(param);
//5.WHERE
param = new Param();
param.setParamName("WHERE");
param.setDataType(Types.DT_STRING);
param.setParamType(Param.PARAM_NORMAL);
param.setValue("");
pmd.addParam(param);
//把参数元数据赋给ReportDefine
rd.setParamMetaData(pmd);

//获取宏元数据
MacroMetaData macroMetaData= rd.getMacroMetaData();
if(macroMetaData!=null)
{
macroMetaData.clear();
}

//获取数据集元数据
DataSetMetaData dataSetMetaData = rd.getDataSetMetaData();
if(dataSetMetaData != null)
{
dataSetMetaData.clear();
}
ProcDataSetConfig procDataSetConfig = new ProcDataSetConfig();
procDataSetConfig.setName("ds1");
procDataSetConfig.setSQL(procName);
//添加参数
procDataSetConfig.addParam();
procDataSetConfig.addParam();
procDataSetConfig.addParam();
procDataSetConfig.addParam();
//设置参数
procDataSetConfig.setParamExp(0,"flag");
procDataSetConfig.setParamExp(1,"fileds");
procDataSetConfig.setParamExp(2,"taskType");
procDataSetConfig.setParamExp(3,"WHERE");
//把数据集定义添加到数据集元数据
dataSetMetaData.addDataSetConfig(procDataSetConfig);

SQLDataSetConfig sqlDataSetConfig = new SQLDataSetConfig();
sqlDataSetConfig.setName("ds2");
sqlDataSetConfig.setSQL("select * from resultcode");
dataSetMetaData.addDataSetConfig(sqlDataSetConfig);

//把数据集元数据赋给ReportDefine
rd.setDataSetMetaData(dataSetMetaData);

ReportUtils.write(fileName, rd);
System.out.println(index+++":"+fileName+"***已处理.");
} catch (Exception e) {
System.out.println(fileName + "-" + e.toString());
}
}
}

/**
* 特殊处理错误类的报表
* @param arrList
*/
@SuppressWarnings("unused")
public void tempCall(List<String> arrList)
{
int index = 1;
for(String item : arrList)
{
String fileName = item;
try {
String name = fileName.substring(fileName.lastIndexOf("\\")+1, fileName.length());
int pos1 = name.indexOf("-");
int pos2 = name.lastIndexOf("-");
String serviceCode = name.substring(pos1-3, pos1);
String subServiceCode = name.substring(pos1+1, pos2);
String procName = "call p_4000002Img(?,?,?)";

ReportDefine rd = (ReportDefine)ReportUtils.read(fileName);
//获取参数元数据
ParamMetaData pmd= rd.getParamMetaData();
if(pmd != null)
{
//pmd.clear();
}
//添加需要的参数
//1.YYYYMMS
Param param = new Param(); //构造参数定义
param.setParamName("YYYYMMS"); //设置参数名
param.setDataType(Types.DT_STRING); //设置参数数据类型
param.setParamType(Param.PARAM_NORMAL); //设置参数类型(普通参数或动态参数)
param.setValue(""); //设参数缺省值
pmd.addParam(param); //把参数定义添加到参数元数据中
//2.WHERE
param = new Param();
param.setParamName("WHERE");
param.setDataType(Types.DT_STRING);
param.setParamType(Param.PARAM_NORMAL);
param.setValue("");
pmd.addParam(param);
//把参数元数据赋给ReportDefine
rd.setParamMetaData(pmd);

//获取数据集元数据
DataSetMetaData dataSetMetaData = rd.getDataSetMetaData();
if(dataSetMetaData != null)
{
dataSetMetaData.clear();
}
ProcDataSetConfig procDataSetConfig = new ProcDataSetConfig();
procDataSetConfig.setName("ds1");
procDataSetConfig.setSQL(procName);
//添加参数
procDataSetConfig.addParam();
procDataSetConfig.addParam();
procDataSetConfig.addParam();
//设置参数
procDataSetConfig.setParamExp(0,"1");
procDataSetConfig.setParamExp(1,"YYYYMMS");
procDataSetConfig.setParamExp(2,"WHERE");
//把数据集定义添加到数据集元数据
dataSetMetaData.addDataSetConfig(procDataSetConfig);

procDataSetConfig = new ProcDataSetConfig();
procDataSetConfig.setName("ds2");
procDataSetConfig.setSQL(procName);
//添加参数
procDataSetConfig.addParam();
procDataSetConfig.addParam();
procDataSetConfig.addParam();
//设置参数
procDataSetConfig.setParamExp(0,"2");
procDataSetConfig.setParamExp(1,"YYYYMMS");
procDataSetConfig.setParamExp(2,"WHERE");
//把数据集定义添加到数据集元数据
dataSetMetaData.addDataSetConfig(procDataSetConfig);

//把数据集元数据赋给ReportDefine
rd.setDataSetMetaData(dataSetMetaData);

ReportUtils.write(fileName, rd);
System.out.println(index+++":"+fileName+"***已处理.");
} catch (Exception e) {
System.out.println(fileName + "-" + e.toString());
}
}
}

/**
* 调整列宽
*/
@SuppressWarnings("unused")
public void adjustSetDateColumnWidth(List<String> arrList)
{
int index=0;
for(String item : arrList)
{
String fileName = item;
try {
ReportDefine rd = (ReportDefine)ReportUtils.read(fileName);
for(short i=1; i<=rd.getColCount(); i++)
{
IColCell colCell = rd.getColCell((short)i);
INormalCell cell = rd.getCell(1, (short)i);
if(cell.getValue() == null)
{
continue;
}
if(cell.getValue().toString().contains("时间"))
{
colCell.setColWidth((float)60);
}
if(cell.getValue().toString().contains("终端"))
{
colCell.setColWidth((float)43);
}
if(cell.getValue().toString().contains("编号"))
{
colCell.setColWidth((float)14);
}
if(cell.getValue().toString().contains("业务类型"))
{
colCell.setColWidth((float)42);
}
if(cell.getValue().toString().contains("传输方式"))
{
colCell.setColWidth((float)24);
}
if(cell.getValue().toString().contains("测试结果"))
{
colCell.setColWidth((float)40);
}
if(cell.getValue().toString().cont