if(!nexacro.ExcelImportObject){nexacro.ExcelImportEventInfo=function(_a,_b,_c,_d){this.id=this.eventid=_b||"onsuccess";this.fromobject=_a;this.fromreferenceobject=_d;this.url=_c;};var _pExcelImportEventInfo=nexacro._createPrototype(nexacro.Event,nexacro.ExcelImportEventInfo,nexacro.ExcelImportEventInfo);nexacro.ExcelImportEventInfo.prototype=_pExcelImportEventInfo;_pExcelImportEventInfo._type_name="ExcelImportEventInfo";delete _pExcelImportEventInfo;nexacro.ExcelImportErrorEventInfo=function(_a,_b,_c,_d,_e,_f){this.id=this.eventid=_b||"onerror";this.fromobject=_a;this.fromreferenceobject=_e;this.errortype=_c;this.errormsg=_d;this.statuscode=_f;};var _pExcelImportErrorEventInfo=nexacro._createPrototype(nexacro.ErrorEventInfo,nexacro.ExcelImportErrorEventInfo);nexacro.ExcelImportErrorEventInfo.prototype=_pExcelImportErrorEventInfo;_pExcelImportErrorEventInfo._type_name="ExcelImportErrorEventInfo";delete _pExcelImportErrorEventInfo;nexacro.ExcelImportObject=function(_a,_b){this.id=this.name=_a;if(!_b){_b=application.getActiveForm();if(!_b){_b=application.mainframe.childframe.form;}}this.parent=_b;this._handle=null;this.importfilemode="local";this._importfilemode=0;this.commcompress="none";this._commcompress=false;this.importtype=nexacro.ImportTypes.EXCEL;this.importurl="";this._importurl="";this._uploadurl="";this._uploadservlet="";this._fileurl="";this._range="";this._applyAllsheet=false;this._responseData="";this._responseRVal=null;this._responseLVal=null;this.userawdatevalue=false;this._userawdatevalue=false;this._file_password=null;this.usedatevalue=null;this._importSheet="";this._importStartCell=null;this._importEndCell=null;this._tran_item=null;this._file_url_ds=null;var _c=this._unique_id=this.parent._unique_id+"_"+this.id;if(!nexacro._get_hidden_frame(_c,this._handle)){var _d=new Date().valueOf().toString();nexacro._create_hidden_frame(_c,_d,this._uploadComplete,this);nexacro._append_hidden_item(_c,"upfile",this._checkUploadFile,this,this._handle);nexacro._append_hidden_textitem(_c,"ds_command");}this.onerror=new nexacro.EventListener("onerror");this.onsuccess=new nexacro.EventListener("onsuccess");this._event_list={"onerror":1,"onsuccess":1};};var _pExcelImport=nexacro.ExcelImportObject.prototype=nexacro._createPrototype(nexacro.EventSinkObject,nexacro.ExcelImportObject);_pExcelImport._type_name="ExcelImportObject";_pExcelImport.on_created=nexacro._emptyFn;_pExcelImport.set_name=function(_a){this.id=this.name=_a;};_pExcelImport.set_importtype=function(_a){switch((_a+"").toUpperCase()){case "EXCEL":_a=0x0100;break;case "EXCEL97":_a=0x0110;break;case "EXCEL2007":_a=0x0120;break;case "HANCELL2010":_a=0x0400;break;case "HANCELL2014":_a=0x0410;break;case "CSV":_a=0x0500;break;}if(_a!=this.importtype){this.importtype=_a;}return _a;};_pExcelImport.set_importurl=function(_a){if(_a!=this.importurl){this.importurl=_a;if(_a==null){this._importurl="";}else{var _b=this._uploadservlet=application._getServiceLocation(_a,this.parent._getFormBaseUrl());var _c=_b.substring(0,_b.lastIndexOf("/")+1);this._importurl=_c+"XExportImport";}}return _a;};_pExcelImport.set_commcompress=function(_a){if(_a!=this.commcompress){this.commcompress=_a;switch(_a.toString().toUpperCase()){case "COMPRESS":this._commcompress=true;break;default:this._commcompress=false;break;}}return _a;};_pExcelImport.set_importfilemode=function(_a){if(this.importfilemode!=_a){this.importfilemode=_a;this._importfilemode=_a=="server"?1:0;}return _a;};_pExcelImport.set_userawdatevalue=function(_a){if(this.userawdatevalue!=_a){this.userawdatevalue=_a;this._userawdatevalue=nexacro._toBoolean(_a);}return _a;};_pExcelImport._setImportRange=function(_a){var _b={};if(_a){if(_a.indexOf("!")>0){var _c=_a.split("!");_b["sheet"]=_c[0];var _d=_c[1];var _e;if(_d.indexOf(":")>0){_d=_d.split(":");_e=this._getExcelRowCol(_d[0]);_b["startRow"]=_e[1]?_e[1]:"";_b["startCol"]=_e[0]?_e[0]:"";_e=this._getExcelRowCol(_d[1]);_b["endRow"]=_e[1]?_e[1]:"";_b["endCol"]=_e[0]?_e[0]:"";}else{_e=this._getExcelRowCol(_d);_b["startRow"]=_e[1]?_e[1]:"";_b["startCol"]=_e[0]?_e[0]:"";_b["endRow"]="";_b["endCol"]="";}}}else{_b["sheet"]="";_b["startRow"]="";_b["startCol"]="";_b["endRow"]="";_b["endCol"]="";}this._range.push(_b);};_pExcelImport.importData=function(_a,_b,_c,_d){this._file_password=null;this._fileurl="";if(arguments.length<3){return false;}if(!this.importurl){return false;}var _e=this.importfilemode.toLowerCase();if(_e!="server"||!_a){this._importfilemode=0;}else{this._importfilemode=1;}if(_b){this._range=_b;}else{this._range="";}if(_c){this._responseLVal=[];this._responseRVal=[];var _f="";var _g=nexacro.replaceAll(_c," ","").split(",");for(var _h=0,_i=_g.length;_h<_i;_h++ ){var _j=_g[_h].match(/[_A-Za-z0-9]+/g);this._responseLVal.push(_j[0]);if(_j[1]==null){_j[1]="output"+(_h+1);}this._responseRVal.push(_j[1]);_f+=" "+_j[0]+"="+_j[1];}this._responseData=_f;}if(_d){var _k=nexacro.replaceAll(_d," ","").split(",");for(var _h=0,_l=_k.length;_h<_l;_h++ ){var _m=_k[_h].split("=");if(_m[0]=="filepassword"){this._file_password=_m[1];var _n=_h;}}_k.splice(_n,1);_d=_k.join(",");}this._user_data=_d;if(!this._importfilemode){nexacro._findclick(this._unique_id,"upfile",this,this._handle);}else{if(this._checkFileName(_a)){this._fileurl=_a;this._requestImport(_a);}else{var _o="the file extension is wrong";var _p=new nexacro.ExcelImportErrorEventInfo(this,"onerror","ObjectError",_o,this, -1);this.on_fire_onerror(this,_p);return false;}}return true;};_pExcelImport.destroy=function(){var _a=this._unique_id;this.parent.removeChild(this.id);nexacro._remove_hidden_item(_a,"upfile",this._handle);nexacro._remove_hidden_item(_a,"ds_command",this._handle);nexacro._destroy_hidden_frame(_a,this,this._handle);this._handle=null;this.parent=null;return true;};_pExcelImport.on_fire_onerror=function(_a,_b){var _c=this.onerror;if(_c&&_c._has_handlers){_c._fireEvent(this,_b);}};_pExcelImport.on_fire_onsuccess=function(_a,_b){var _c=this.onsuccess;if(_c&&_c._has_handlers){_c._fireEvent(this,_b);}};_pExcelImport._getExcelRowCol=function(_a){var _b=_a.length;var _c=[];for(var _d=0;_d<_b;_d++ ){if(!isNaN(_a[_d])){_c.push(_a.substring(0,_d));_c.push(_a.substring(_d));break;}}return _c;};_pExcelImport._transaction=function(_a,_b,_c,_d,_e,_f,_g,_h,_i){this._load_manager=new nexacro.LoadManager(this);var _j=application._getServiceObject(_b,true);this._load_manager.loadDataModule(_b,_a,_c,_d,_e,_f,_g,_h,_i,_j);};_pExcelImport._getDataset=function(_a){var _b=this.parent;if(!_b){_b=this._getForm();}var _c=this._responseRVal;var _d=_c.length;for(var _e=0;_e<_d;_e++ ){if(_c[_e]==_a){return _b[this._responseLVal[_e]];}}return null;};_pExcelImport._waitCursor=nexacro._emptyFn;_pExcelImport._setParamter=nexacro._emptyFn;_pExcelImport._getDatasetObject=function(_a){var _b=this[_a];if(_b==null&&this.parent&&this.parent!=application){_b=this.parent._getDatasetObject(_a);}if(_b==null){_b=application[_a];}return _b;};_pExcelImport._getForm=function(){var _a=application.getActiveForm();if(!_a){_a=application.mainframe.childframe.form;}return _a;};_pExcelImport._isPopupFrame=function(){return false;};_pExcelImport._makeImportFormat=function(){var _a="<Import>";_a+="<Sheets>";var _b=this._range.split("]");var _c=_b.length-1;_c=_c==0?1:_c;var _d="";for(var _e=0;_e<_c;_e++ ){_a+="<Sheet ";_d=_b[_e].match(/[_A-Za-z0-9]+=[\(\)_!:A-Za-z0-9가-힣 ]+/g);if(_d==null){var _f=_b[_e];if(_f.indexOf("!")>0){var _g=_f.split("!");if(_g[1].indexOf(":")>0){var _h=_g[0];var _f=_g[1].split(":");var _i=_f[0].match(/[0-9]+/);var _j=_f[0].match(/[A-Z]+/);var _k= +_i+1;var _l=_f[1].match(/[0-9]+/);var _m=_f[1].match(/[A-Z]+/);_a+='command=\"getsheetdata\" output=\"'+this._responseRVal+'\" head=\"'+_h+'!'+_j+_i+':'+_m+_i+'\" body=\"'+_h+'!'+_j+( +_i+1)+':'+_m+_l+'\" />';}else{_a+='command=\"getsheetdata\" output=\"'+this._responseRVal+'\" Body=\"'+_b[_e]+'\" />';}}else{_a+='command=\"getsheetdata\" output=\"'+this._responseRVal+'\" Body=\"'+_b[_e]+'\" />';}}else{var _n=1;var _o=false;var _p="";for(var _q=0,_r=_d.length;_q<_r;_q++ ){_p=_d[_q].match(/[\(\)_!:A-Za-z0-9가-힣 ]+/g);var _s=_p[0].toLowerCase();if(_s!="command"){if(_q==0){_a+='command=\"getsheetdata\" ';}if(_s=="output"){_o=true;}}_a+=_s+"=\""+_p[1]+"\" ";}if(!_o){_a+='output=\"output'+_n+'\" ';_n++ ;}_a+="/>";}}_a+="</Sheets>";_a+="</Import>";return _a;};_pExcelImport._requestImport=function(_a){var _b=new Dataset("COMMAND");this._ds_command=_b;_b.addColumn("command","String",32);_b.addColumn("type","int",32);_b.addColumn("url","String",256);_b.addColumn("format","String",256);_b.addColumn("filemode","String",256);_b.addColumn("password","String",256);_b.addColumn("rawdatevalue","String",256);_b.addRow();_b.setColumn(0,"command","import");_b.setColumn(0,"type",this._importType);_b.setColumn(0,"url",_a);_b.setColumn(0,"format",this._makeImportFormat());_b.setColumn(0,"filemode",this._importfilemode?"server":"local");_b.setColumn(0,"password",this._file_password);_b.setColumn(0,"rawdatevalue",this._userawdatevalue);if(this._ds_response){delete this._ds_response;}var _c=this._responseLVal;for(var _f=0,_g=_c.length;_f<_g;_f++ ){var _h=this.parent[_c[_f]];if(_h){}else{var _i="Dataset is null";var _j=new nexacro.ExcelImportErrorEventInfo(this,"onerror","ObjectError",_i,this, -2011);this.on_fire_onerror(this,_j);return;}}this._file_url_ds=new Dataset("_file_url_ds",this);var _d=this._tran_item=new nexacro.TransactionItem(this._importurl,this,this.id,"COMMAND=_ds_command",this._responseData+", _file_url_ds=IMPORTFILES",this._user_data,0,true);var _e=_d._sendData;nexacro._setImportCommand(this._unique_id,"ds_command",this,this._handle,_e);nexacro._submit(this._unique_id,this._uploadservlet,this._handle,_e,_a);};_pExcelImport._uploadComplete=function(_a,_b,_c,_d,_e,_f){var _g=nexacro._getXMLDocument(this._unique_id,_b,_c);try{_c=_g.URL?_g.URL:_g.url;if(_c=="about:blank"){return;}var _i=null;if(_b){_i=this._tran_item._deserializeData(_b);}else{_i=this._tran_item._deserializeData(nexacro._getDataFromDOM(_g));}this._tran_item=null;var _j= -1;var _k="";var _l=_i[0];if(_l){_j=_l[0];_k=_l[1];}if(_j<0||_a<0){var _m=new nexacro.ExcelImportErrorEventInfo(this,"onerror","ObjectError",_k,this,_j);this.on_fire_onerror(this,_m);}else{var _n=this._fileurl=this._file_url_ds?this._file_url_ds.getColumn(0,3):null;this._file_url_ds=null;var _m=new nexacro.ExcelImportEventInfo(this,"onsuccess",_n,this);this.on_fire_onsuccess(this,_m);}}catch(e){var _m=new nexacro.ExcelImportErrorEventInfo(this,"onerror","ObjectError","failed to get",this,9901);this.on_fire_onerror(this,_m);}var _h=this._unique_id;nexacro._remove_hidden_item(_h,"upfile",this._handle);nexacro._append_hidden_item(_h,"upfile",this._checkUploadFile,this,this._handle);};_pExcelImport._checkFileName=function(_a){if(_a==null){return false;}var _b=false;var _c="";var _d=_a.lastIndexOf("\\");var _e=_a.substring(_d+1);var _f=_e.split(".");var _g=_f.length;if(_g>1){_c=_f[_g-1];switch(_c){case "xls":_b=true;this._importType=nexacro.ImportTypes.EXCEL97;break;case "xlsx":_b=true;this._importType=nexacro.ImportTypes.EXCEL2007;break;case "cell":_b=true;this._importType=nexacro.ImportTypes.HANCELL;break;case "csv":_b=true;this._importType=nexacro.ImportTypes.CSV;break;default:if(this._importfilemode){_b=true;this._importType=this.importtype;}break;}}else{if(this._importfilemode){_b=true;this._importType=this.importtype;}}return _b;};_pExcelImport._checkUploadFile=function(_a){if(this._checkFileName(_a)){this._requestImport(_a);}else{var _b="the file extension is wrong";var _c=new nexacro.ExcelImportErrorEventInfo(this,"onerror","ObjectError",_b,this, -1);this.on_fire_onerror(this,_c);}};_pExcelImport._getWindow=function(){var _a=this.parent;if(_a._is_form){return _a._getWindow();}return null;};_pExcelImport._getWindowHandle=function(){var _a=this.parent;if(_a._is_form){return _a._getWindowHandle();}return null;};_pExcelImport._changeFiles=nexacro._emptyFn;delete _pExcelImport;}