package com.vci.client.portal.platformPortal;
|
|
import java.io.BufferedWriter;
|
import java.io.File;
|
import java.io.FileNotFoundException;
|
import java.io.FileOutputStream;
|
import java.io.IOException;
|
import java.io.OutputStreamWriter;
|
import java.util.List;
|
|
import javax.swing.JFileChooser;
|
import javax.swing.filechooser.FileFilter;
|
|
import org.apache.poi.hssf.usermodel.HSSFCell;
|
import org.apache.poi.hssf.usermodel.HSSFRow;
|
import org.apache.poi.hssf.usermodel.HSSFSheet;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
|
import com.vci.client.LogonApplication;
|
import com.vci.client.common.providers.ServiceProvider;
|
import com.vci.client.omd.provider.ApProvider;
|
import com.vci.client.omd.provider.BtmProvider;
|
import com.vci.client.omd.provider.LinkTypeProvider;
|
import com.vci.client.oq.QTClient;
|
import com.vci.client.oq.QTDClient;
|
import com.vci.client.portal.utility.PRM;
|
import com.vci.client.portal.utility.PRMItem;
|
import com.vci.client.portal.utility.UITools;
|
import com.vci.common.utility.ObjectUtility;
|
import com.vci.corba.common.VCIError;
|
import com.vci.corba.omd.atm.AttribItem;
|
import com.vci.corba.omd.ltm.LinkType;
|
import com.vci.corba.omd.qtm.QTD;
|
import com.vci.corba.omd.qtm.QTInfo;
|
import com.vci.corba.portal.data.PortalVI;
|
|
public class ExportExcel {
|
List<PortalVI> objList ;
|
|
public ExportExcel(List<PortalVI> objList){
|
this.objList = objList;
|
}
|
|
public boolean export(){
|
JFileChooser jf = new JFileChooser();
|
jf.setDialogTitle("打开");
|
jf.removeChoosableFileFilter(jf.getFileFilter());
|
jf.setFileFilter(new FileFilter() {
|
|
@Override
|
public String getDescription() {
|
return "xls";
|
}
|
|
@Override
|
public boolean accept(File f) {
|
if(f.isDirectory()||f.getName().endsWith(".xls")){
|
return true;
|
}else{
|
return false;
|
}
|
}
|
});
|
int showOpenDialog = jf.showOpenDialog(LogonApplication.frame);
|
String xfileName = "";
|
String prmFileName = "";
|
if (showOpenDialog == JFileChooser.APPROVE_OPTION) {
|
File file = jf.getSelectedFile();
|
xfileName = file.getAbsolutePath();
|
if(!xfileName.endsWith(".xls")){
|
xfileName = xfileName+".xls";
|
}
|
}
|
HSSFWorkbook workbook = new HSSFWorkbook();
|
HSSFSheet sheet = workbook.createSheet();
|
workbook.setSheetName(0, "portalvi");
|
|
HSSFSheet qtdSheet = workbook.createSheet();
|
workbook.setSheetName(1, "QTD");
|
|
for(int i=0;i<objList.size();i++){
|
HSSFRow row = sheet.createRow(i);
|
PortalVI portalVI = objList.get(i);
|
// HSSFCell cell = row.createCell(0);
|
// cell.setCellValue(portalVI.id);
|
HSSFCell cell = row.createCell(0);
|
cell.setCellValue(portalVI.typeName);
|
cell = row.createCell(1);
|
cell.setCellValue(portalVI.viName);
|
cell = row.createCell(2);
|
cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
|
cell.setCellValue(portalVI.viType);
|
cell = row.createCell(3);
|
cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
|
cell.setCellValue(portalVI.typeFlag);
|
cell = row.createCell(4);
|
String prmStr = portalVI.prm;
|
String qtName = "";
|
if(portalVI.viType ==0){
|
PRM prmObj = UITools.getPRM(prmStr);
|
List<PRMItem> prmItemList = prmObj.getPrmItemList();
|
qtName = prmObj.getFormQtName();
|
for(int j=0;j<prmItemList.size();j++){
|
PRMItem pit = prmItemList.get(j);
|
PortalVI[] portalViInfos = new PortalVI[0];
|
try {
|
portalViInfos = UITools.getService().getPortalVIArrayByTypeName(portalVI.typeName);
|
for(PortalVI pv : portalViInfos){
|
if(pit.getItemInObj().equals(pv.id)){
|
pit.setItemInObj(portalVI.typeName+":"+pv.viName);
|
}
|
}
|
} catch (VCIError e) {
|
e.printStackTrace();
|
}
|
}
|
try {
|
prmStr = UITools.getPRMText(prmObj);
|
} catch (Throwable e1) {
|
e1.printStackTrace();
|
}
|
}else if(portalVI.viType ==1){
|
PRM prmObj = UITools.getPRM(prmStr);
|
// List<PRMItem> prmItemList = prmObj.getPrmItemList();
|
// for(int j=0;j<prmItemList.size();j++){
|
// PRMItem pit = prmItemList.get(j);
|
qtName = prmObj.getFormQtName();
|
// }
|
}
|
prmFileName = ObjectUtility.getNewObjectID36() + ".txt";
|
String prmFileAllName = xfileName + "." + prmFileName;
|
BufferedWriter clobBW = null;
|
try {
|
File prmFile = new File(prmFileAllName);
|
if(!prmFile.exists()){
|
prmFile.createNewFile();
|
}
|
clobBW = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(prmFile), "Utf-8"));
|
clobBW.write(prmStr);
|
clobBW.flush();
|
// byte[] connentBytes = prmStr.getBytes(s);
|
// fop.write(connentBytes);
|
// fop.flush();
|
// fop.close();
|
cell.setCellValue(prmFileName);
|
} catch (IOException e) {
|
e.printStackTrace();
|
return false;
|
}finally{
|
if(clobBW != null){
|
try {
|
// fop.close();
|
// osw.close();
|
clobBW.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
// cell.setCellValue(prmStr);
|
String btmname = "";
|
String linkname = "";
|
AttribItem[] btAbItems=null;
|
if(portalVI.typeFlag==0){
|
btmname = portalVI.typeName;
|
btAbItems = BtmProvider.getInstance().getBtAbItems(btmname);
|
}else if(portalVI.typeFlag==1){
|
try {
|
LinkType linkType = LinkTypeProvider.getInstance().getLinkTypeByName(portalVI.typeName);
|
btmname = linkType.name;
|
linkname = linkType.name;
|
btAbItems = ApProvider.getInstance().getAttribItemsByNames(LinkTypeProvider.getInstance().getAbNames(linkType));
|
} catch (Exception e) {
|
e.printStackTrace();
|
} catch (Throwable e) {
|
e.printStackTrace();
|
}
|
}
|
|
String attr = "";
|
for(AttribItem ait : btAbItems){
|
attr += ait.name +",";
|
}
|
//类型属性：以字符串形式存在
|
cell = row.createCell(5);
|
if(attr==null||"".equals(attr)){
|
cell.setCellValue("");
|
}else{
|
cell.setCellValue(attr.substring(0,attr.length()-1));
|
}
|
BufferedWriter qtbw = null;
|
try {
|
QTInfo qt = ServiceProvider.getOMDService().getQTDService().getQT(qtName);
|
if(qt != null){
|
//查询模板名称
|
cell = row.createCell(6);
|
cell.setCellValue(qtName);
|
//查询模板名称
|
cell = row.createCell(7);
|
String qtFileName = ObjectUtility.getNewObjectID36() + ".txt";
|
String qtFileNameAllName = xfileName + "." + qtFileName;
|
File prmFile = new File(qtFileNameAllName);
|
if(!prmFile.exists()){
|
prmFile.createNewFile();
|
}
|
qtbw = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(prmFile), "utf-8"));
|
qtbw.write(qt.qtText);
|
qtbw.flush();
|
// byte[] connentBytes = qt.qtText.getBytes();
|
// qtfop.write(connentBytes);
|
// qtfop.flush();
|
// qtfop.close();
|
cell.setCellValue(qtFileName);
|
//查询模板的业务对象名称
|
cell = row.createCell(8);
|
cell.setCellValue(qt.btmName);
|
}
|
QTD[] qtdsByBtmName = ServiceProvider.getOMDService().getQTDService().getBizTypeQTDs(btmname);
|
for(int qtdIndex =0;qtdIndex<qtdsByBtmName.length;qtdIndex++){
|
HSSFRow qtdRow = qtdSheet.createRow(qtdIndex);
|
QTD qtd = qtdsByBtmName[qtdIndex];
|
HSSFCell qtdCell = qtdRow.createCell(0);
|
qtdCell.setCellValue(qtd.btmName);
|
qtdCell = qtdRow.createCell(1);
|
qtdCell.setCellValue(qtd.linkTypeName);
|
qtdCell = qtdRow.createCell(2);
|
qtdCell.setCellValue(qtd.name);
|
qtdCell = qtdRow.createCell(3);
|
String qtdattr = "";
|
for(String str : qtd.abNames){
|
qtdattr += str+",";
|
}
|
if(qtdattr==null||"".equals(qtdattr)){
|
qtdCell.setCellValue("");
|
}else{
|
qtdCell.setCellValue(qtdattr.substring(0,qtdattr.length()-1));
|
}
|
}
|
QTD[] qtdsByLinkTypeName = ServiceProvider.getOMDService().getQTDService().getLinkTypeQTDs(linkname);
|
for(int qtdLinkIndex =0;qtdLinkIndex<qtdsByLinkTypeName.length;qtdLinkIndex++){
|
HSSFRow qtdRow = qtdSheet.createRow(qtdLinkIndex);
|
QTD qtd = qtdsByLinkTypeName[qtdLinkIndex];
|
HSSFCell qtdCell = qtdRow.createCell(0);
|
qtdCell.setCellValue(qtd.btmName);
|
qtdCell = qtdRow.createCell(1);
|
qtdCell.setCellValue(qtd.linkTypeName);
|
qtdCell = qtdRow.createCell(2);
|
qtdCell.setCellValue(qtd.name);
|
qtdCell = qtdRow.createCell(3);
|
String qtdattr = "";
|
for(String str : qtd.abNames){
|
qtdattr += str+",";
|
}
|
if(qtdattr==null||"".equals(qtdattr)){
|
qtdCell.setCellValue("");
|
}else{
|
qtdCell.setCellValue(qtdattr.substring(0,qtdattr.length()-1));
|
}
|
}
|
} catch (VCIError e) {
|
e.printStackTrace();
|
} catch (FileNotFoundException e) {
|
e.printStackTrace();
|
} catch (IOException e) {
|
e.printStackTrace();
|
} finally{
|
try {
|
if(qtbw != null){
|
qtbw.close();
|
}
|
} catch (IOException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
}
|
}
|
|
try {
|
FileOutputStream fout = new FileOutputStream(xfileName);
|
workbook.write(fout);
|
fout.flush();
|
fout.close();
|
System.out.println("文件生成.....");
|
return true;
|
} catch (FileNotFoundException e) {
|
e.printStackTrace();
|
return false;
|
} catch (IOException e) {
|
e.printStackTrace();
|
return false;
|
}
|
}
|
}
|
