| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850 |
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head><META http-equiv="Content-Type" content="text/html; charset=UTF-8"><meta content="initial-scale=1.0" name="viewport">
- <meta content="IE=edge" http-equiv="X-UA-Compatible">
- <script type="text/javascript">__LANGUAGE = "kr";__chromeFrame = false;__useBinding=false;__SoonsuViewer=true; htmlwindow=null; htmldocument=null;</script><script src="../../../com/commonweb/js/common.js.soonsu" type="text/javascript"></script><script src="../../../com/commonweb/js/SPZUR00100.js.soonsu" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/Browser.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/Language.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/Define.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/XmlLib.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/HtmlLib.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/HttpClient.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/Graphics.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/Format.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/XpathProcessor.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/ActionEvent.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/Library/jquery-1.7.min.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/XFormsElement.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/global/XFormsStyleSheet.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/global/XFormsWindow.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/global/XFormsDocument.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/global/XFormsModel.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/global/XFormsInstance.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/global/XFormsSubmission.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/global/XFormsBind.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsControl.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsBindableControl.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsCaption.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsGroup.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsCell.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/global/XHtml.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsCalendar.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsButton.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsTextArea.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsInput.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsSecret.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsOutput.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsSelect.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsSelect1.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsLine.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsObject.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsSelectItem.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsImg.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsBool.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsBrowser.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsDataGrid.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsSwitch.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsCase.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsGridCell.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsGridCol.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsIViewer.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsTreeView.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsTreeViewItem.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsTable.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsFile.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsShape.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsImport.js" type="text/javascript"></script>
- <script src="/Soonsu/kr/comsquare/js/control/XFormsContextMenu.js" type="text/javascript"></script>
-
- <title>보고서미리보기</title>
-
-
-
-
- <script event="EndLoadReport()" for="HE_objRexpert" language="javascript">
-
- // 해당 출력물의 전체 페이지 갯수 저장
- var pageCount = objRexpert.GetPageCount();
- opener.javascript.setParameter("reportPageCount", pageCount);
-
- //바로 파일 저장 설정
- //SaveAs([타입명], [저장 경로], [시작페이지], [끝페이지], [옵션리스트])
- var reportSaveFileType = gvMainReportInfos.get("rex_filetype");
- var reportSaveFileName = gvMainReportInfos.get("rex_filename");
- var reportSaveFileDialog = gvMainReportInfos.get("rex_filedialog");
- if (! isNull(reportSaveFileType)) {
- if(! checkSaveAsFileType(reportSaveFileType)) messageBox("지원하지 않는 파일타입", "E008");
- if( isNull(reportSaveFileName) ) reportSaveFileName = gvReportName;
- if( isNull(reportSaveFileDialog) ) reportSaveFileDialog = 0;
- objRexpert.SaveAs(reportSaveFileType, "c:\\report\\" + reportSaveFileName + "." + reportSaveFileType, 1, -1, "ShowFileDialog=" + reportSaveFileDialog);
- }
-
- //objRexpert.SaveAsFilter = "doc";
-
- //바로 출력 설정
- //PrintEx2([인쇄창보임여부], [시작페이지] [끝페이지], [출력매수], [출력프린터]);
-
- //<< 옵션으로 사용할수 있는 문자열>>
- //* enablezoom : 확대/축소인쇄가능 (예) - > 0/1
- //* zoomnumber : 모아찍기 (예) - > 0/1/2/3/4/5/6
- //* zoomdirection : 출력순서 (예) - > 0/1
- //* enablefittingpaper : 용지크기에 자동 맞춤 (예) - > 0/1
- //* printpaper : 출력용지 (예) - > 0/1/2/3/4/5/6
- //* printdirection : 용지방향 (예) - > 0/1
- //* papersetting : 용지설정 (예) - > 0/1
- //* offsetx : 인쇄위치(가로) (예) - > 100
- //* offsety : 인쇄위치(세로) (예) - > 100
- //* duplex : 양면인쇄 (예) - > 0/1/2/3
- //예)
- //objRexpert.PrintOption = "enablezoom=1;enablefittingpaper=0;printdirection=1;" (사용자정의)
- var reportPrint = gvMainReportInfos.get("rex_print");
- var reportPrintDialog = gvMainReportInfos.get("rex_printdialog");
- var reportPrintPaperBin = gvMainReportInfos.get("rex_printpaperbin");
- var reportPrintCount = gvMainReportInfos.get("rex_printcount");
- var reportPrintOption = gvMainReportInfos.get("rex_printoption");
- var reportPrinterName = "";
-
- // 바로 출력
- if (! (isNull(reportPrint) || reportPrint == "false") ){
- if(reportPrint == "true") {
- reportPrinterName = "";
- }else{
- reportPrinterName = reportPrint;
- }
-
- if( isNull(reportPrintDialog) ) reportPrintDialog = "false";
- if(! isNull(reportPrintPaperBin) ) objRexpert.PrinterPaperBin = reportPrintPaperBin;
- if( isNull(reportPrintCount) ) reportPrintCount = "1";
- if(! isNull(reportPrintOption) ) objRexpert.PrintOption = reportPrintOption;
- objRexpert.PrintEx2(reportPrintDialog, 1, -1, reportPrintCount, "printername="+reportPrinterName);
- }else{
- //이벤트가 끝나고 나서 "objRexpert.PrintEx2" 에서 FinishPrint 마무리 이벤트를 호출합니다.
- //위에 if문상 출력을 false하면 마무리 이벤트를 호출 안하니 else로 강제 호출하도록 추가합니다.
- //20101228 cys
- opener.model.dispatch("onPrintFinished");
- opener.javascript.setParameter("reportprintyn","Y");
- var reportCloseYn = gvMainReportInfos.get("rex_close");
- if(reportCloseYn == "true"){
- if(window.type == "iviewer"){
- opener.window.close();
- }else{
- window.close();
- }
- }
- }
-
- // 해당 출력물의 로딩(출력/저장포함)이 끝났을 경우 이벤트 발생(설정한 전체 페이지갯수를 전달할 포인트)
- opener.model.dispatch("onEndLoadReport");
-
- </script><script event="FinishPrint()" for="HE_objRexpert" language="javascript">
-
-
- // 사용자가 출력버튼 클릭 후, 인쇄작업이 끝났을 때 dispatch
- // 출력이 정상적으로 종료되었는지 아닌지는 알 수 없다.
- opener.model.dispatch("onPrintFinished");
- //messageBox("출력이", "I002");
- opener.javascript.setParameter("reportprintyn","Y");
- //미리보기창 닫기
- var reportCloseYn = gvMainReportInfos.get("rex_close");
- if(reportCloseYn == "true"){
- if(window.type == "iviewer"){
- opener.window.close();
- }else{
- window.close();
- }
- }
-
- </script><script event="FinishSaveAs(FileName)" for="HE_objRexpert" language="javascript">
-
- // 사용자가 저장버튼 클릭 후, 저장작업이 끝났을 때 dispatch
- opener.model.dispatch("onSaveFinished");
- //messageBox("파일저장이", "I002", FileName);
- opener.javascript.setParameter("reportsaveyn","Y");
- //미리보기창 닫기
- var reportCloseYn = gvMainReportInfos.get("rex_close");
- if(reportCloseYn == "true"){
- if(window.type == "iviewer"){
- opener.window.close();
- }else{
- window.close();
- }
- }
-
- </script>
- <script type="text/javascript">
- //<![CDATA[
- /* Do not delete or edit the following XForms Scripts.
- if you delete or edit it, it may not be normal behavior. */
- var model; var html;var head; var model1; var instance1; var body; var objRexpert;
- function __getAppName ()
- {
- return "/Soonsu";
- }
- function __createElements ()
- {
- html = new XHtmlHtml(null, "html", "xhtml:html");
- head = new XHtmlHead("html", "head", "xhtml:head");
- model1 = new XFormsModel("head", false, "model1", "xforms:model");
- model = model1;
- instance1 = new XFormsInstance("model1", "instance1", false, "xforms:instance", "", "", "\<root\>\<properties\>\<report\/\>\<\/properties\>\<\/root\>");
- body = new XHtmlBody("html", "", "", "", "", true, "", false, "body", -1, "scroll", "", "", "", "", "auto", "margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ", "xhtml:body", "visible");
- objRexpert = new XFormsObject("body", "", "", "", "", "", "{9e1f4a27-7eb0-4210-98d8-1ccf6671f483}", false, "objRexpert", -1, "left:1%; top:1%; width:98%; height:98%; ", "xforms:object", "visible","");
- }
- function __addEventListener ()
- {
- model.addEventListener("xforms-ready", "xforms_ready_model", "", "");
- model.addEventListener("xforms-close", "xforms_close_model", "", "");
- }
- //]]>
- </script>
- <script type="text/javascript">
- //<![CDATA[
- function xforms_close_model (event)
- {
-
- fCloseReport();
- }
- function xforms_ready_model (event)
- {
- if(checkOpener()){
- if(opener.getParameter("onready")){
- fInitRexpert();
- }
- }
- }
- function fInitRexpert() {
- fCloseReport();
-
- gvMainReportInfos = null;
- gvSubReportInfos = null;
- gvReportName = null;
- gvReportDataType = null;
- gvReportUserService = null;
- gvReportDataXPath = null;
- gvReportXPath = null;
- gvReportData = null;
- gvReportSubmitId = null;
- var iSubRptCnt = 0;
- var nodeList = opener.root.properties.report.childNodes ;
- for (i = 0; i < nodeList.length; i++) {
- node = nodeList.nextNode();
-
- if (node.nodeName == "mainreport") {
- gvMainReportInfos = initRexpertDictionay();
-
-
- nodeList_props = node.props.childNodes ;
- for (j = 0; j < nodeList_props.length; j++) {
- node_prop = nodeList_props.nextNode();
-
- gvMainReportInfos.add(node_prop.nodeName, node_prop.nodevalue);
- }
- gvReportName = gvMainReportInfos.get("rex_rptname");
- gvReportDataType = gvMainReportInfos.get("rex_datatype");
- gvReportSubmitId = gvMainReportInfos.get("rex_submitid");
- gvReportUserService = gvMainReportInfos.get("rex_userservice");
- gvReportDataXPath = gvMainReportInfos.get("rex_data_xpath");
- gvReportXPath = gvMainReportInfos.get("rex_xpath");
-
- nodeList_params = node.params.childNodes ;
- for (j = 0; j < nodeList_params.length; j++) {
- node_param = nodeList_params.nextNode();
- gvMainReportInfos.add(node_param.nodeName, node_param.nodevalue);
- }
-
- nodeList_options = node.options.childNodes ;
- for (j = 0; j < nodeList_options.length; j++) {
- node_option = nodeList_options.nextNode();
- gvMainReportInfos.add(node_option.nodeName, node_option.nodevalue);
- }
-
- if (gvReportDataType == "XMLSTR") {
- var sDataXpath = gvReportDataXPath;
-
-
- if (opener.getReportData != undefined) {
- gvMainReportInfos.add("rex_data", opener.fGetReportData());
- }
-
- if (isNull(sDataXpath)) {
- gvMainReportInfos.add("rex_data", opener.instance1.xml );
- } else {
- gvMainReportInfos.add("rex_data", opener.instance1.selectSingleNode(sDataXpath).xml );
- }
-
- gvReportData = gvMainReportInfos.get("rex_data");
- }
-
- }
- }
- fReportPreView();
- }
- function fReportPreView() {
- var oReport;
- var oSubReport;
- var oConnection;
- var oDataSet;
- var oSQL;
-
-
-
-
-
- var zoomRate = gvMainReportInfos.get("rex_zoomrate");
- if(!isNull(zoomRate)){
- objRexpert.zoom(zoomRate);
- }
-
-
-
-
-
-
-
-
-
-
-
-
- var reportPrint = gvMainReportInfos.get("rex_print");
- if (! (isNull(reportPrint) || reportPrint == "false") ){
- objRexpert.ShowProcessDialog = false;
- }
-
-
- var showToolbarButton = gvMainReportInfos.get("rex_showbutton");
- if(showToolbarButton == "hidden"){
- objRexpert.ShowToolBarButton(0, false);
- objRexpert.ShowToolBarButton(1, false);
- objRexpert.ShowToolBarButton(2, false);
- objRexpert.ShowToolBarButton(3, false);
- objRexpert.ShowToolBarButton(4, false);
- objRexpert.ShowToolBarButton(15, false);
- }
-
- objRexpert.ShowParameterDialog = false;
- if (isNull(gvMainReportInfos) || isNull(gvReportName)) return;
-
-
- if (gvMainReportInfos.Init != null) {
- gvMainReportInfos.Init(objRexpert);
- }
-
- try{
- oReport = objRexpert.OpenReport(getReportURL(gvReportName));
- }catch(e){
- messageBox(e.message, "I");
- return "error";
- }
-
- if(oReport == null) {
- messageBox("리포트를 열 수", "I004");
- return;
- }
-
- var obj = gvMainReportInfos.keys();
- for(var key in obj) {
- oReport.SetParameterFieldValue(key, obj[key]);
- }
-
-
- oConnection = fCreateConnection(gvReportDataType);
-
-
- fGetData(oReport, oConnection, gvReportDataType, gvReportUserService, gvReportData);
-
- if (fGetSubReportData() == "each") {
- if (gvReportDataType == "XMLFILE" || gvReportDataType == "XMLSTR") {
-
- var sXpath = gvReportXPath;
- if (isNull(sXpath)) {
- oDataSet = fCreateDataSet(oReport, oConnection, gvReportDataType, oDataSet, "", 0);
- } else {
- oDataSet = fCreateDataSet(oReport, oConnection, gvReportDataType, oDataSet, sXpath, 0);
- }
- } else {
- oDataSet = fCreateDataSet(oReport, oConnection, gvReportDataType, oDataSet, "root/main/rpt1/rexdataset/rexrow", 0);
- }
-
- if( oDataSet == null ) return ;
- if (gvMainReportInfos.CallBack != null) {
- gvMainReportInfos.CallBack(oReport, oDataSet);
- }
- }
-
- if (gvReportParamShare == "share") {
- if (fGetSubReportData() == "each") {
- if (gvSubReportInfos.length > 0) {
- var sDataType = "";
- var sUserService = "";
- var sData = "";
-
- for (i = 1; i <= gvSubReportInfos.length; i++) {
- oRptSubParam = gvSubReportInfos.get("" + i);
-
- if (oRptSubParam.get("rex_rptname") != "") {
- oSubReport = oReport.OpenReport(oRptSubParam.get("rex_rptname"));
- } else {
- messageBox("서브 리포트 파일이", "I004");
- return;
- }
-
- if (oSubReport == null) {
- messageBox("서브 리포트를 열 수", "I004");
- return;
- }
-
- var obj = gvMainReportInfos.keys();
- for(var key in obj) {
- oSubReport.SetParameterFieldValue(key, obj[key]);
- }
-
- if (oRptSubParam.get("rex_datatype") == null) {
- sDataType = gvMainReportInfos.get("rex_datatype");
- } else {
- sDataType = oRptSubParam.get("rex_datatype");
- }
-
- if (oRptSubParam.get("rex_userservice") == null || oRptSubParam.get("rex_userservice") == "") {
- sUserService = gvReportUserService;
- } else {
- sUserService = oRptSubParam.get("rex_userservice");
- }
-
- if (oRptSubParam.get("rex_data") == null) {
- sData = gvReportData;
- } else {
- sData = oRptSubParam.get("rex_data");
- }
- oConnection = fCreateConnection(sDataType);
- fGetData(oSubReport, oConnection, sDataType, sUserService, sData);
- if (sDataType == "XMLFILE" || sDataType == "XMLSTR") {
- var sXpath = gvReportXPath;
-
- if (isNull(sXpath)) {
- oDataSet = fCreateDataSet(oSubReport, oConnection, sDataType, oDataSet, "", 0);
- } else {
- oDataSet = fCreateDataSet(oSubReport, oConnection, sDataType, oDataSet, sXpath, 0);
- }
- } else {
- oDataSet = fCreateDataSet(oSubReport, oConnection, sDataType, oDataSet, "root/main/rpt1/rexdataset/rexrow", 0);
- }
- if( oDataSet==null ) return ;
- if (oRptSubParam.CallBack != null) {
- oRptSubParam.CallBack(oSubReport, oDataSet);
- }
-
- }
- }
- } else {
- for (i = 1; i <= oReport.GetReportCount(); i++) {
- oSubReport = oReport.OpenReport(i - 1);
-
- if (oSubReport == null) {
- messageBox("서브 리포트를 열 수", "I004");
- return;
- }
-
- var obj = gvMainReportInfos.keys();
-
- for(var key in obj) {
- oSubReport.SetParameterFieldValue(key, obj[key]);
- }
-
- fGetData(oSubReport, oConnection, gvReportDataType, gvReportUserService, gvReportData);
-
- }
- }
- } else {
- if (gvSubReportInfos.length > 0) {
- var sDataType = "";
- var sUserService = "";
- var sData = "";
-
- for (i = 1; i <= gvSubReportInfos.length; i++) {
- oRptSubParam = gvSubReportInfos.get("" + i);
-
- if (oRptSubParam.get("rex_rptname") != "") {
- oSubReport = oReport.OpenReport(oRptSubParam.get("rex_rptname"));
- } else {
- messageBox("서브 리포트 파일이", "I004");
- return;
- }
-
- if (oSubReport == null) {
- messageBox("서브 리포트를 열 수", "I004");
- return;
- }
-
- var obj = oRptSubParam.keys();
- for(var key in obj) {
- oSubReport.SetParameterFieldValue(key, obj[key]);
- }
-
- if (oRptSubParam.get("rex_datatype") == null) {
- sDataType = gvMainReportInfos.get("rex_datatype");
- } else {
- sDataType = oRptSubParam.get("rex_datatype");
- }
-
- if (oRptSubParam.get("rex_userservice") == null || oRptSubParam.get("rex_userservice") == "") {
- sUserService = gvReportUserService;
- } else {
- sUserService = oRptSubParam.get("rex_userservice");
- }
-
- if (oRptSubParam.get("rex_data") == null) {
- sData = gvReportData;
- } else {
- sData = oRptSubParam.get("rex_data");
- }
-
- oConnection = fCreateConnection(sDataType);
- fGetData(oSubReport, oConnection, sDataType, sUserService, sData);
-
- if (fGetSubReportData() == "each") {
- if (sDataType == "XMLFILE" || sDataType == "XMLSTR") {
- var sXpath = oRptSubParam.get("rex_xpath");
-
- if (isNull(sXpath)) {
- oDataSet = fCreateDataSet(oSubReport, oConnection, sDataType, oDataSet, "", 0);
- } else {
- oDataSet = fCreateDataSet(oSubReport, oConnection, sDataType, oDataSet, sXpath, 0);
- }
- } else {
- oDataSet = fCreateDataSet(oSubReport, oConnection, sDataType, oDataSet, "root/main/rpt1/rexdataset/rexrow", 0);
- }
- if( oDataSet == null ) return ;
-
- if (oRptSubParam.CallBack != null) {
- oRptSubParam.CallBack(oSubReport, oDataSet);
- }
- }
-
- }
- }
- }
-
- if (fGetSubReportData() == "once") {
- if (gvReportDataType != "XMLSTR" && gvReportDataType != "CSVSTR") {
- try{
- oConnection.Send();
- }catch(e){
- alert(e.message);
- alert(oConnection.Response());
- }
- }
- if (gvReportDataType == "XMLFILE" || gvReportDataType == "XMLSTR") {
- var sXpath = gvReportXPath;
- if (isNull(sXpath)) {
- oDataSet = fCreateDataSet(oReport, oConnection, gvReportDataType, oDataSet, "", 0);
- } else {
- oDataSet = fCreateDataSet(oReport, oConnection, gvReportDataType, oDataSet, sXpath, 0);
- }
- } else {
- oDataSet = fCreateDataSet(oReport, oConnection, gvReportDataType, oDataSet, "root/main/rpt1/rexdataset/rexrow", 0);
- }
-
- if( oDataSet == null ) return ;
- if (gvMainReportInfos.CallBack != null) {
- gvMainReportInfos.CallBack(oReport, oDataSet);
- }
-
- for (i = 1; i <= oReport.GetReportCount(); i++) {
- oSubReport = oReport.OpenReport(i - 1);
- if (gvReportDataType == "XMLFILE" || gvReportDataType == "XMLSTR") {
- var sXpath = gvMainReportInfos.get("rex_xpath" + i);
-
- if (isNull(sXpath)) {
- oDataSet = fCreateDataSet(oSubReport, oConnection, gvReportDataType, oDataSet, "", i);
- } else {
- oDataSet = fCreateDataSet(oSubReport, oConnection, gvReportDataType, oDataSet, sXpath, i);
- }
- } else {
- oDataSet = fCreateDataSet(oSubReport, oConnection, gvReportDataType, oDataSet, "root/main/rpt" + (i + 1) + "/rexdataset/rexrow", i);
- }
- if( oDataSet == null ) return ;
- }
- }
-
-
- objRexpert.RunAsBlocking();
-
- }
-
-
- function fCreateConnection(sDataType)
- {
- var oConnection;
-
- if (sDataType == "XMLFILE")
- {
- oConnection = objRexpert.CreateConnection("http.get");
- }
- else if (sDataType == "CSVFILE")
- {
- oConnection = objRexpert.CreateConnection("http.csv");
- }
- else if (sDataType == "XML" || sDataType == "CSV" || sDataType == "" )
- {
- oConnection = objRexpert.CreateConnection("http.post");
- }
- else if (sDataType=="XMLSTR" || sDataType=="CSVSTR" )
- {
- oConnection = objRexpert.CreateConnection("connectionstring");
- }
-
- return oConnection;
- }
-
-
- function fGetData(oReport, oConnection, sDataType, sUserService, sData)
- {
- var oSQL;
- var oServerConnection;
- var oUserService;
- if (sDataType=="XML" || sDataType=="CSV")
- {
- oConnection.AddParameter("datatype", sDataType);
-
- oSQL = oReport.GetSQLControl();
- oServerConnection = oReport.GetServerConnection();
- oConnection.AddParameter("sql", oSQL.GetSQL());
-
- if ( isNull(sUserService) ) {
- oUserService = oServerConnection.GetParameterValue("service");
- if ( isNull(oUserService) ) {
- oUserService = "jdbc.comdb";
- }
- }else{
- oUserService = "jdbc."+sUserService+"db";
- }
-
- oConnection.AddParameter("userservice", oUserService);
-
- oConnection.Path = gvRexpertServiceURL + gvReportName;
-
- if (fGetSubReportData() == "each") {
- oConnection.Send();
- }
- }
-
- if (sDataType=="XMLFILE" || sDataType=="CSVFILE")
- {
-
- oConnection.Path = getActionURL(gvReportSubmitId) + addReportParameter();
- if (fGetSubReportData() == "each") {
- oConnection.Send();
- }
- }
-
- if (sDataType=="XMLSTR" || sDataType=="CSVSTR")
- {
- oConnection.AddValue("load", sData);
- }
-
-
- }
-
- function fCreateDataSet(oReport, oConnection, sDataType, oDataSet, sXpath, idx)
- {
- if (sDataType=="XMLFILE" || sDataType == "CSVFILE"){
- if(fGetUserErrorMsg(oConnection, sDataType) == "error") return null;
- }
-
- if (sDataType=="XML" || sDataType == "CSV"){
- if(fGetErrorMsg(oConnection, sDataType) == "error") return null;
- }
- if (sDataType == "CSV" || sDataType == "CSVFILE" || sDataType == "CSVSTR")
- {
- oDataSet = oReport.CreateDataSetCSV(oConnection, idx, rex_gsCsvSeparatorDataset, rex_gsCsvSeparatorRow, rex_gsCsvSeparatorColumn, "");
- }else{
-
-
-
- oDataSet = oReport.CreateDataSetXML(oConnection, sXpath, 0);
- }
-
- return oDataSet;
- }
-
- function fGetSubReportData()
- {
- var subreportData = gvMainReportInfos.get("rex_getsubreportdata");
-
- if ( isNull(subreportData) ) {
- return gvSubreportData;
- } else {
- return subreportData;
- }
- }
-
- function fGetErrorMsg(oConnection, sDataType)
- {
- try {
- if(sDataType == "CSV"){
- var sData = oConnection.Response();
-
- if (sData.length > 5) {
- if (sData.substr(0, 5) == "<?xml") {
- var idxStart = sData.indexOf("<error>");
- var idxEnd = sData.indexOf("</error>");
-
- if (idxStart == -1 || idxEnd == -1) return "";
-
- var sErrMsg = sData.substring(idxStart + 7 + 9, idxEnd - 3);
- messageBox(sErrMsg, "C");
- return "error";
- }
- }
- return "";
- }else{
- var oXMLDOM = oConnection.GetXMLDOM();
-
- if(oXMLDOM != null) {
- oXMLDOM.setProperty("SelectionLanguage", "XPath");
- var oNodes = oXMLDOM.selectSingleNode("rexpert/error");
-
- if(oNodes == null) {
- if (oXMLDOM.parseError.errorCode != 0) {
- var oError = oXMLDOM.parseError;
- messageBox(oError.reason,"C");
- return "error";
- }
- } else {
- messageBox(oNodes.text, "C");
- return "error";
- }
- }
- return "";
- }
- } catch(e) {
- messageBox(e.message, "C");
- return "error";
- }
- }
-
- function fGetUserErrorMsg(oConnection, sDataType)
- {
- var oXMLDOM = oConnection.GetXMLDOM();
-
- if(oXMLDOM != null) {
- try {
- oXMLDOM.setProperty("SelectionLanguage", "XPath");
- var oNode = oXMLDOM.selectSingleNode("//resultKM");
- var sErrMsg = oNode.getAttributeNode("description").text;
- handleSystemMessage(sErrMsg);
- showSystemMessage(false);
- } catch(e) {
- messageBox(e.message, "C");
- return "error";
- }
- }
- }
-
- function fCloseReport(){
- objRexpert.CloseReport();
- }
-
-
- //]]>
- </script>
- <script src="../../../com/commonweb/css/common.css.soonsu" type="text/javascript"></script></head>
- <body id="HE_body" onload="XFormsModel.onload();" onunload="XFormsModel.onunload();" style="position:absolute; margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; width:100%; height:100%; visibility:hidden; ">
- <object CLASSID="clsid:{9e1f4a27-7eb0-4210-98d8-1ccf6671f483}" id="HE_objRexpert" style="position:absolute; left:1%; top:1%; width:98%; height:98%; "></object>
-
- <form action="/Soonsu/FileUpload.tfs" enctype="multipart/form-data" id="HE___TF_UploadForm" method="post" style="display:none; " target="HE___TF_UploadFrame_8190"></form>
- <iframe id="HE___TF_UploadFrame" name="HE___TF_UploadFrame_8190" style="display:none; position:absolute; "></iframe>
- <iframe id="HE___TF_ImageUploadFrame" name="HE___TF_ImageUploadFrame" style="display:none; position:absolute; "></iframe>
-
- <iframe id="HE___TF_LoadExcel" name="HE___TF_LoadExcel" style="display:none; position:absolute; "></iframe>
-
- <form action="/Soonsu/ExcelSave.tfs" enctype="multipart/form-data" id="HE___TF_ExcelDownload" method="post" style="display:none; " target="HE___TF_UploadFrame_8190"><input id="HE___TF_ExcelDownload_Name" name="Name" type="hidden"><input id="HE___TF_ExcelDownload_Data" name="Data" type="hidden"></form></body>
- </html>
|