package com.nexacro.util;

 

import java.io.ByteArrayOutputStream;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.OutputStream;

 

import javax.servlet.http.HttpServletResponse;

 

import com.nexacro.java.xapi.data.DataSet;

import com.nexacro.java.xapi.data.PlatformData;

import com.nexacro.java.xapi.data.VariableList;

import com.nexacro.java.xapi.tx.HttpPlatformResponse;

import com.nexacro.java.xapi.tx.PlatformType;

import com.nexacro.java.xeni.extend.XeniExcelDataStorageBase;

import com.nexacro.java.xeni.util.CommUtil;

 

/*

 

제니 엑셀 다운로드 호풀 관련

   - HTTPS 통신 하나, 제니에서는 HTTP 로 호출 

 

답변

1. 개발 환경에서 proxy나 web server를 통할 경우 xeni를 호출할때 http로 호출되는 것이 아닌지 확인이 필요해 보입니다.

2. 아래와 같이 'export-url' 설정을 통해 url를 고정 시킬 수 있습니다.

 

web.xml 설정 

export-url : "https://dev.tobesoft.com/xeni/ExportImport.do"

 

<context-param>

    <param-name>export-url</param-name>

    <param-value>https://dev.tobesoft.com/xeni/ExportImport.do</param-value>

    </context-param>

 

export 파일 경로 지정시

<context-param>

    <param-name>export-path</param-name>

    <param-value>file:///temp/export</param-value>

    </context-param>

 

 */

 

public class XeniExtend implements XeniExcelDataStorageBase {

 

/**

* read excel file 

*/

public InputStream loadTargetStream(String filepath) throws Exception {

 

File file = new File(filepath);

return new FileInputStream(file);

}

 

 

/*   

  확장 클래스를 이용해 다운로드 URL을 사용자가 지정하는 방법을 사용합니다

  1. nexacro 화면에서 호출하는 도메인 정보를 variable list에 담아 전달.

  ex) exportObj.exportData("requesturl=" + url);

*/

 

public String saveImportStream(VariableList varlist, 

InputStream in, 

String filepath) throws Exception {

 

int nIdx = filepath.lastIndexOf("/");

String sPath = filepath.substring(0, nIdx);

 

File file = new File(sPath);

if (file.exists() == false) {

file.mkdirs();

}

 

// write input stream to file

//

OutputStream out = new FileOutputStream(filepath);

 

byte[] buf = new byte[1024];

int length = 0;

while ((length = in.read(buf)) > 0) {

out.write(buf, 0, length);

}

 

out.flush(); 

out.close(); 

in.close();

 

return null;

}

 

 

public int saveExportStream(VariableList varlist, 

DataSet dscmd,

ByteArrayOutputStream out, 

String filepath, String fileurl,

HttpServletResponse response)  throws Exception {

 

String strUrl = varlist.getString("ExtUrl");

 

 

System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>> strUrl : " + strUrl);

 

fileurl = fileurl.split("://")[1];

int idx = fileurl.indexOf("/");    

fileurl = "https://" 

          + strUrl

          + fileurl.substring(idx);

System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>> fileurl : " + fileurl);

 

 

int nIdx = filepath.lastIndexOf("/");

String sPath = filepath.substring(0, nIdx);

 

File file = new File(sPath);

if (file.exists() == false) {

file.mkdirs();

}

 

FileOutputStream fout = new FileOutputStream(filepath);

fout.write(out.toByteArray());

 

fout.close();

out.close();

 

DataSet dsRes = CommUtil.getDatasetExportResponse(dscmd);

 

 

PlatformData resData = new PlatformData();

VariableList varList = resData.getVariableList();

 

varList.add("ErrorCode", 0); 

varList.add("ErrorMsg", "SUCCESS");

 

dsRes.set(0, "url", fileurl);

resData.addDataSet(dsRes);

 

HttpPlatformResponse platformRes = new HttpPlatformResponse(

response, PlatformType.CONTENT_TYPE_SSV, "UTF-8");

platformRes.setData(resData);

platformRes.sendData();

 

return 0;

}

 

 

@Override

public DataSet saveExportStream(com.nexacro.java.xapi.data.VariableList arg0,

com.nexacro.java.xapi.data.DataSet arg1, ByteArrayOutputStream arg2, String arg3, String arg4)

throws Exception {

// TODO Auto-generated method stub

return null;

}

 

 

}