농부지기 :: Nexacro - Grid관련 Javascript

Nexacro - Grid관련 Javascript

Nexacro-컴포넌트/JavaScript 2017. 1. 19. 14:31

[ Nexacro - Grid관련 Javascript ]

/***************************************************************************************
 * System Name		:	SKU/common
 * Job Name 		:	Common
 * File Name 		:	xGrid.xfdl
 * Make Date 		:	2013.07.17
 *
 * Description  	:	공통 Grid 사용 함수 모음
 *---------------------------------------------------------------------------------------
 * Modify Date     	Modifier  	Modify Description 
 *---------------------------------------------------------------------------------------
 * 
 *---------------------------------------------------------------------------------------
 ****************************************************************************************/
 
// var CONST_ASC_MARK = "▲";
// var CONST_DESC_MARK = "▼";
// var CONST_FILTER = "√";
var CONST_ASC_MARK 	= "<fs v=' 8'>"+ "▲"+"</fs>";
var CONST_DESC_MARK = "<fs v=' 8'>"+ "▼"+"</fs>";
var CONST_FILTER 	= "<fs v='11'>"+ "√"+"</fs>";
/**
 * 그리드 Cell 번호로 바인딩 컬럼ID 리턴
 * @param nIdx  : Cell index 번호
 * @param sBand : Cell의 영역('Head'/'Body'/'Summ'('Summary'))
 */
function gfn_getCellBind(obj:Grid, nIdx, sBand)
{
	if(nIdx < 0) return;
	if(sBand == null) sBand = "Body";
		
    var sCol = obj.getCellProperty(sBand, nIdx, "text");
    if(gfn_isNull(sCol)) return "";

return sCol.replace(/^bind:/, "");
}

/**
 * 그리드에서 바인드된 컬럼명으로 컬럼 index를 리턴
 * @param sCol  : 바인드된 컬럼명
 * @param sBand : Cell의 영역('Head'/'Body'/'Summ'('Summary'))
 * @return : 해당 컬럼명이 없는 경우 -1 리턴 
 */
function gfn_getColumnIdx(obj:Grid, sCol, sBand)
{
	if(gfn_isNull(sCol)) return;
	if(gfn_isNull(sBand)) sBand = "Body";
	
	var nCnt = obj.getCellCount(sBand);
	var sCellCol;

for(var i = 0; i < nCnt; i++){
		if (sCol == gfn_getCellBind(obj, i, sBand)){
			return i ;
		}
	}
	return -1;
}

/**
 * 그리드 체크박스 전체 체크처리 
 * @param nCell   : 체크박스가 위치한 Cell번호
 * @param chkCol  : 체크박스 사용하는 데이터셋 COLUMN
 */
function gfn_gridChkAll(obj:Grid, nCell, sColId)
{
	var sChk;
	var sVal;
	var objDS  = eval(obj.binddataset);
	
	// Head setting
	sVal = obj.getCellProperty("head", nCell, "text");
	try{
		sVal = sVal.replace("expr:","");
	}catch(e){};
	
	if (sVal == "0" || gfn_isNull(sVal)) {
		obj.setCellProperty("head", nCell, "text", '1');
		sChk="1";
	} else {
		obj.setCellProperty("head", nCell, "text", '0');
		sChk="0";
	}
	
	if(gfn_isNull(sColId)){
		sColId = gfn_getCellBind(obj,nCell);
	}
	
	objDS.enableevent = false;
	for(var i=0; i<objDS.rowcount; i++){
		objDS.setColumn(i,sColId,sChk);
	}
	objDS.enableevent = true;
}

/**
 * 
 * 함  수  명	: 	gfn_setGridCheckAll
 * 입      력	: 	1. obj Grid Object
 *                  2. e   GridClickEventInfo
 * 기      능	: 	Grid Head 클릭시 해당칼럼 체크박스 전체체크/체크해제 처리 함수
 *                  그리드 헤드 예) <Cell displaytype="checkbox" edittype="checkbox" text="0"/> 로 해야함.
 *                  스크립트 예)  gfn_setGridCheckAll(obj,e);
 **/
function gfn_setGridCheckAll(obj:Grid, e:GridClickEventInfo)
{
	var strType;
	var vl_chk;
	var strVal;
	var strChkVal;
	var objDS;
	var nCell  = e.cell;
	var nSubCnt = obj.getSubCellCount("head",nCell);

objDS  = eval(obj.binddataset);
	strChkVal = gfn_nullVal(obj.getCellProperty("body", nCell, "text"));
	
	strChkVal = strChkVal.replace("bind:", "");

if (nSubCnt > 0) {	// Merge한 셀이 있는 경우
		var nChkIdx = -1;
		for ( var i = 0; i < nSubCnt; i++)
		{
			strType = obj.getSubCellProperty("head",e.cell,i,"displaytype");

if(strType == "checkbox") {
				nChkIdx =  i;
				break;
			}
		}
		if (nChkIdx == -1)
			return;

// Head셋팅
		strVal = obj.getSubCellProperty("head", nCell, nChkIdx, "text");
	
		if (strVal == "0" || gfn_isNull(strVal)) {
			obj.setSubCellProperty("head",nCell,nChkIdx,"text", '1');
			vl_chk="1";
		} else {
			obj.setSubCellProperty("head",nCell,nChkIdx,"text", '0');
			vl_chk="0";
		}

} else { // Merge한 셀이 없는 경우
		strType = obj.getCellProperty("head", e.cell, "displaytype");

if(strType != "checkbox") {
			return;
		}

// Head셋팅
		strVal = obj.getCellProperty("head", nCell, "text");
		if (strVal == "0" || gfn_isNull(strVal)) {
			obj.setCellProperty("head", nCell, "text", '1');
			vl_chk="1";
		} else {
			obj.setCellProperty("head", nCell, "text", '0');
			vl_chk="0";
		}
	}

// Body셋팅
	for(var i=0 ; i< objDS.rowcount ; i++){
		objDS.setColumn(i, strChkVal, vl_chk);
	}
}

/**
 * Exporting Progressbar
 * @param obj	ExportObject
 * @return 		none
 */
function _gfn_onExport(obj:ExportObject, e:ExportEventInfo)
{
	var nTotal = 0;
	if(e.itemindex == 0){
		nTotal = obj.totalData; //Data 총건수
	}else{
		nTotal = obj.totalCondData; //조회조건 총건수
	}

obj.exportmessageprocess = "Exporting " + e.recordindex + " / " + nTotal;
}

/**
 * 그리드 내용 엑셀 출력 
 * @param obj  : Grid
 * @param objCondDs  : 조회조건값들을 담고 있는 Datasset
 */
function gfn_exportExcel(obj:Grid, objCondDs:Dataset,sYn, sheetName)
{
	var aa = 0;
	try{
//		eval(obj.binddataset).enableevent = false;
		if(eval(obj.binddataset).rowposition == -1)
		{
			aa = 1;
		}
	}catch(e){}
		
	try{
		_objExcelGrid1.destroy();
	}catch(e){}
		
	if(!this.isValidObject("_objExcelGrid1")){
		var _objExcelGrid = new Grid();
			_objExcelGrid.init("_objExcelGrid1",0,0,100,100);
			_objExcelGrid.visible =false;
		this.addChild("_objExcelGrid1", _objExcelGrid);
		_objExcelGrid.show();
	}		
	
	_objExcelGrid1.formats = "";
	 var  sFormats = '<Formats>\n' + obj.getCurFormatString() + '\n </Formats>\n';

_objExcelGrid1.formats = sFormats;
	_objExcelGrid1.cellsizebandtype = obj.cellsizebandtype; 
	
	_objExcelGrid1.binddataset  = obj.binddataset;
	_objExcelGrid1.redraw();

/**
 * 그리드 내용 엑셀 출력 
 * @param obj  : Grid
 * @param objCondDs  : 조회조건값들을 담고 있는 Datasset
 */
function gfn_exportExcelTwo(obj:Grid, objCondDs:Dataset,objCondDs1:Dataset,sYn, sheetName)
{
	var aa = 0;
	try{
//		eval(obj.binddataset).enableevent = false;
		if(eval(obj.binddataset).rowposition == -1)
		{
			aa = 1;
		}
	}catch(e){}
		
	try{
		_objExcelGrid1.destroy();
	}catch(e){}
		
	if(!this.isValidObject("_objExcelGrid1")){
		var _objExcelGrid = new Grid();
			_objExcelGrid.init("_objExcelGrid1",0,0,100,100);
			_objExcelGrid.visible =false;
		this.addChild("_objExcelGrid1", _objExcelGrid);
		_objExcelGrid.show();
	}		
	
	_objExcelGrid1.formats = "";
	 var  sFormats = '<Formats>\n' + obj.getCurFormatString() + '\n </Formats>\n';

_objExcelGrid1.formats = sFormats;
	_objExcelGrid1.cellsizebandtype = obj.cellsizebandtype; 
	
	_objExcelGrid1.binddataset  = obj.binddataset;
	_objExcelGrid1.redraw();

function fn_Excel_log(svalue)
{
	this.fv_logBtnId = svalue;
	var sArg = "soutDs=gds_excel";
	
	var sSvcId 		 = "retrieveExcelInfo"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveExcelInfo.devx"; 
	var sInDs  		 = "";
	var sOutDs 		 = "gds_excel=gds_excel"; 
	var sCallbackFnc = "";
		
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);	
	this.fv_logBtnId = "";
}

/**
 * 그리드 내용 CSV형식 파일로 저장 
 * @param obj  : Grid
 */
 function gfn_exportCSV(obj:Grid, sYn, sEx)
{
	var aa = 0;
//	eval(obj.binddataset).enableevent = false;
	if(eval(obj.binddataset).rowposition == -1)
	{
		aa = 1;
	}
	
	try{
		_objExcelGrid1.destroy();
	}catch(e){}
	
	if(!this.isValidObject("_objExcelGrid1")){
		var _objExcelGrid = new Grid();
			_objExcelGrid.init("_objExcelGrid1",0,0,100,100);
			_objExcelGrid.visible = false;
		this.addChild("_objExcelGrid1", _objExcelGrid);
		_objExcelGrid.show();
	}		
	
	_objExcelGrid1.formats = "";
	 var  sFormats = '<Formats>\n' + obj.getCurFormatString() + '\n </Formats>\n';
	_objExcelGrid1.formats = sFormats;
	
	_objExcelGrid1.binddataset  = obj.binddataset;
	
	_objExcelGrid1.redraw();
	
	if(gfn_isNull(sEx) == true)
	{
		sEx = 'Y';
	}
	
	if(sEx == 'N')
	{
		_objExcelGrid1.treeinitstatus = "expand,all";
	}
	
	var hColCount = _objExcelGrid1.getCellCount("Head");
	var bColCount = _objExcelGrid1.getCellCount("Body");
	
	for(var i=_objExcelGrid1.getFormatColCount()-1; i>=0; i--){ //초기화 
		_objExcelGrid1.setFormatColProperty(i, "band", "body");
		if((_objExcelGrid1.getCellProperty("Body", i, "edittype") == 'masknumber' || _objExcelGrid1.getCellProperty("Body", i, "edittype") == 'mask')
			&& gfn_isNull(_objExcelGrid1.getCellProperty("Body", i, "mask")) == false)
		{
			var cmask = _objExcelGrid1.getCellProperty("Body", i, "mask");
			cmask = cmask.replace('!','');
			cmask = cmask.replace('9','#');
			_objExcelGrid1.setCellProperty("Body", i, "mask", cmask);
		}		
	}
		
	for(var i=hColCount-1; i >= 0; i--)
	{
		var sText = obj.getCellProperty("head", i, "text");
		if(gfn_isNull(sText) == false)
		{		
			sText = sText.replace(CONST_ASC_MARK,'');
			sText = sText.replace(CONST_DESC_MARK,'');
			sText = sText.replace(CONST_FILTER,'');
			_objExcelGrid1.setCellProperty("head", i, "text",  sText);
		}	
		else
		{
			_objExcelGrid1.setCellProperty("head", i, "text",  "");
		}
		_objExcelGrid1.setCellProperty("head", i, "background",  obj.getCellProperty("head", i, "background"));
	}
		
	if(sYn == 'N')
	{
		for(var i=bColCount-1; i >= 0; i--)
		{
			if(obj.getRealColSize(i) <= 0)
			{
				_objExcelGrid1.deleteContentsCol(i);
			}
		}
	}
	
	var vFile = gfn_fileDialog("SAVE","(*.csv)|*.csv");
	if(gfn_isNull(vFile))
	{
		if(aa == 1)
		{
			eval(obj.binddataset).rowposition = -1;
		}
		eval(obj.binddataset).enableevent = true;	
		return;
	}
	var bSuccess = vFile.open(vFile.fullpath, VirtualFile.openWrite | VirtualFile.openText );
	if(bSuccess)
	{
	
		fn_Excel_log('btn_excelCSV');
		var sCsvData = _objExcelGrid1.getCsvData(); //Grid 표시내용을 CSV형식으로 받아낸다.
		var change = sCsvData.replace("\\\"","\"\"" );
		
        var nCount = _objExcelGrid.getCellCount("Head");
        var sBuf = new Buffer;
        var nPreCol = -1;
        for(var i=0;i<nCount;i++)
        {
             var vCol  = toNumber(_objExcelGrid.getCellProperty( "Head", i, "col" ));

vFile.write(sText + "\n" + change); //Head Text를 붙여서 파일로 저장

vFile.close();
		vFile = null;
	}
	if(aa == 1)
	{
		eval(obj.binddataset).rowposition = -1;
	}
//	eval(obj.binddataset).enableevent = true;	
}

/*
	//2003과 2007 엑셀 확장자 나누기
	
	var FileDialog_excel 				= new FileDialog;
	FileDialog_excel.defaultextention 	= true;	
	
	var bColCount = obj.getCellCount("Body");
			
	if(bColCount > 256) {
		FileDialog_excel.filter 			= "Excel 통합문서 (*.xlsx)|*.xlsx";
	}
	else{
		FileDialog_excel.filter 			= "Excel 97 - 2003 통합문서 (*.xls)|*.xls|Excel 통합문서 (*.xlsx)|*.xlsx";
	}
		
	var vFile 							= FileDialog_excel.open("file download",FileDialog.SAVE,"%Document%");
	*/
		
	//기존 2003기준 엑셀 다운로드 확장자 셋팅
	var vFile = gfn_fileDialog("SAVE","excel files (*.xls)|*.xls");
	
	if( gfn_isNull(vFile) ) {
		if( aa == 1 ) {
			eval(obj.binddataset).rowposition = -1;
		}
		return;
	}

//조회조건 출력용 Grid 생성
	if( !this.isValidObject("_objExcelCondGrid1") ) {
		var _objExcelCondGrid = new Grid();
		_objExcelCondGrid.init("_objExcelCondGrid1",0,0,100,100);
		_objExcelCondGrid.visible = false;
		this.addChild("_objExcelCondGrid1", _objExcelCondGrid);
		_objExcelCondGrid.show();
	}		
			
	var sFormat = "";	
	sFormat += '<Formats>\n';
	sFormat += '  <Format id="default">\n';
	sFormat += '	<Columns>\n';
	sFormat += '	  <Column size="200"/>\n';
	sFormat += '	  <Column size="800"/>\n';
	sFormat += '	</Columns>\n';
	sFormat += '	<Rows>\n';
	sFormat += '	  <Row size="30" band="head"/>\n';
	sFormat += '	  <Row size="24"/>\n';
	sFormat += '	</Rows>\n';
	sFormat += '	<Band id="head">\n';
	sFormat += '	  <Cell text="Label"/>\n';
	sFormat += '	  <Cell col="1" text="Value"/>\n';
	sFormat += '	</Band>\n';
	sFormat += '	<Band id="body">\n';
	sFormat += '	  <Cell text="bind:label" style="align:left;background:white;background2:white;"/>\n';
	sFormat += '	  <Cell col="1" text="bind:value" style="align:left;background:white;background2:white;" autosizecol="limitmin" autosizerow="limitmax"/>\n';
	sFormat += '	</Band>\n';
	sFormat += '  </Format>\n';
	sFormat += '</Formats>\n';
			
	_objExcelCondGrid1.formats = sFormat;
	
	var bCond = true; //조회조건 표시여부 
	
	try{ //조회조건 Dataset 바인딩
		_objExcelCondGrid1.binddataset = objCondDs;
	}catch(e){
		bCond = false;
	}
	if(objCondDs == null) bCond = false;

var objExport1 = new LibExcel;
	objExport1.exportuitype = "exportprogress";
	objExport1.oncomplete.addHandler(LibExcel_oncomplete);
	objExport1.onprocessing.addHandler(LibExcel_onprocessing);

objExport1.clearExportItems();
	
	var sFileName = vFile.fullpath;	
	var bSucc 	  = VirtualFile.isExist(sFileName);

if( bSucc == true ) {
		var objExtCommon = new ExtCommon();
		var ret = objExtCommon.DeleteFile(sFileName);

if( ret[0] == false ) {
			gfn_alert(ret[2]);
			return;
		}
	}	
	
	fn_Excel_log('btn_excel(html)');	
	
	//메인 Data
	var objDs = eval(obj.binddataset);	
	var bb 	  = objDs.keystring.toString();
	
	//default 값 셋팅 - false : 닫기
	var treeExpandFlag = sEx;
	if( gfn_isNull(treeExpandFlag) ) {
		treeExpandFlag = false;
	}
	
	//Groupping 되었을 경우
	if( bb.substr(0,1) == 'G' ) {
		var objg = '_objExcelGrid';
		
		if(!this.isValidObject(objg)){
			var _objExcelGrid = new Grid();			
			_objExcelGrid.init(objg,0,0,100,100);
			_objExcelGrid.visible = false;
			this.addChild(objg, _objExcelGrid);
			_objExcelGrid.show();
		}
		
		var objGrd 			= eval(objg);
		objGrd.selecttype 	= "row";
		objGrd.formats 		= "";
		 var  sFormats 		= '<Formats>\n' + obj.getCurFormatString() + '\n </Formats>\n';
		objGrd.formats 		= sFormats;

//열기일 경우
		if( treeExpandFlag ) {
			objGrd.treeinitstatus = "expand,all";
		}else{
			objGrd.treeinitstatus = "collapse,all";
		}
		
		var hColCount = objGrd.getCellCount("Head");
		var bColCount = objGrd.getCellCount("Body");
		
		//초기화 
		for( var ix=objGrd.getFormatColCount()-1; ix>=0; ix-- ){ 
			if( ( objGrd.getCellProperty("Body", ix, "edittype") == 'masknumber' || objGrd.getCellProperty("Body", ix, "edittype") == 'mask' )
			   && !gfn_isNull(objGrd.getCellProperty("Body", ix, "mask")) ) 
			{
				var cmask 	= objGrd.getCellProperty("Body", ix, "mask");
				cmask 		= cmask.replace('!','');
				cmask 		= cmask.replace('9','#');
				objGrd.setCellProperty("Body", ix, "mask", cmask);
			}
			
			objGrd.setFormatColProperty(ix, "band", "body");
			objGrd.setCellProperty("Body", ix, "class", "");
			objGrd.setCellProperty("Body", ix, "background", "");
			objGrd.setCellProperty("Body", ix, "background2", "");
		}
				
		for( var ih=hColCount-1; ih>=0; ih-- ) {
			objGrd.setCellProperty("head", ih, "background", obj.getCellProperty("head", ih, "background"));
			var sText = objGrd.getCellProperty("head", ih, "text");
			if( !gfn_isNull(sText) ) {			
				sText = sText.replace(CONST_ASC_MARK,'');
				sText = sText.replace(CONST_DESC_MARK,'');
				sText = sText.replace(CONST_FILTER,'');
				objGrd.setCellProperty("head", ih, "text",  sText);
			} else {
				objGrd.setCellProperty("head", ih, "text",  " ");
			}
		}
		
		//Col Size = 0 인 값에 대해서 보여주지 않게 셋팅 sYn = 'N'
		if( sYn == 'N' ) {
			for( var ic=bColCount-1; ic >= 0; ic-- ) {
				if( obj.getRealColSize(ic) <= 0 ) {
					objGrd.deleteContentsCol(ic);
				}
			}
		}
		
		var objd = '_ds_excel';
		if( !isValidObject(objd) ) {
			var strDsName=objd;
			//Dataset 생성
			var objDataset 	= new Dataset;
			objDataset.name	= strDsName; 
			this.addChild(strDsName, objDataset);

objDataset.clear();
		}

objGrd.binddataset 	= objd;		
		var _objDs 			= eval(objd);
		_objDs.copyData(objDs);

//sheet Name 설정 : default : "Data"
		if( gfn_isNull(sheetName) ) {
			objExport1.addExportItem(objGrd, "Data", 0, 0, false);
		} else {
			objExport1.addExportItem(objGrd, sheetName, 0, 0, false);
		}
	}
	//Groupping 되지 않는 그 외 것
	else {
		//Sheet를 65000건 기준으로 나누기(2003 기준)
		var aa = Math.ceil(obj.rowcount/65000);

for( var i=0; i<aa; i++ ) {
			var objg = '_objExcelGrid'+i;
			
			if( !this.isValidObject(objg) ) {
				var _objExcelGrid = new Grid();				
				_objExcelGrid.init(objg,0,0,100,100);
				_objExcelGrid.visible = false;
				this.addChild(objg, _objExcelGrid);
				_objExcelGrid.show();
			}
			
			var objGrd 			= eval(objg);
			objGrd.selecttype 	= "row";
			objGrd.formats 		= "";
			 var  sFormats 		= '<Formats>\n' + obj.getCurFormatString() + '\n </Formats>\n';
			objGrd.formats 		= sFormats;

//열기일 경우
			if( treeExpandFlag ) {
				objGrd.treeinitstatus = "expand,all";
			}else{
				objGrd.treeinitstatus = "collapse,all";
			}
			
			var hColCount = objGrd.getCellCount("Head");
			var bColCount = objGrd.getCellCount("Body");
			
			//초기화 
			for( var ix=objGrd.getFormatColCount()-1; ix>=0; ix-- ) { 
				if(( objGrd.getCellProperty("Body", ix, "edittype") == 'masknumber' || objGrd.getCellProperty("Body", ix, "edittype") == 'mask' )
				   && !gfn_isNull(objGrd.getCellProperty("Body", ix, "mask")) )
				{
					var cmask 	= objGrd.getCellProperty("Body", ix, "mask");
					cmask 		= cmask.replace('!','');
					cmask 		= cmask.replace('9','#');
					objGrd.setCellProperty("Body", ix, "mask", cmask);
				}
				
				objGrd.setFormatColProperty(ix, "band", "body");
				objGrd.setCellProperty("Body", ix, "class", "");
				objGrd.setCellProperty("Body", ix, "background", "");
				objGrd.setCellProperty("Body", ix, "background2", "");
			}
			
			for( var ih=hColCount-1; ih>=0; ih-- ) {
				objGrd.setCellProperty("head", ih, "background", obj.getCellProperty("head", ih, "background"));
				var sText = objGrd.getCellProperty("head", ih, "text");
				
				if( !gfn_isNull(sText) ) {			
					sText = sText.replace(CONST_ASC_MARK,'');
					sText = sText.replace(CONST_DESC_MARK,'');
					sText = sText.replace(CONST_FILTER,'');
					objGrd.setCellProperty("head", ih, "text",  sText);
				} else {
					objGrd.setCellProperty("head", ih, "text",  " ");
				}
			}
			
			//Col Size = 0 인 값에 대해서 보여주지 않게 셋팅 sYn = 'N'
			if( sYn == 'N' ) {
				for( var ic=bColCount-1; ic>=0; ic-- ) {

if( obj.getRealColSize(ic) <= 0 ) {
						objGrd.deleteContentsCol(ic);
					}
				}
			}
			
			var objd = '_ds_excel'+i;
			if( !isValidObject(objd) ) {
				var strDsName=objd;
				//Dataset 생성
				var objDataset 	= new Dataset;
				objDataset.name	= strDsName; 
				this.addChild(strDsName, objDataset);

objDataset.clear();
			}

objGrd.binddataset = objd;
			
			var _objDs = eval(objd);
			_objDs.copyData(objDs,true);

objExport1.exportmessageprocess = "%d/"+(aa+1)+" Exporting %d/%d";
	
	/*
	//확장자에 따라 함수 사용
	var sFileNameArr = sFileName.split('.');
	
	if(sFileNameArr[1] == "xls"){		
		objExport1.export(sFileName, true, 1);  // ESC 중단을 위한 추가 사항
	}
	else{		
		objExport1.exportEx(sFileName, true, 1);  // ESC 중단을 위한 추가 사항
	}
	*/
	
	//컬럼 값에 따라 엑셀 2003, 2007 여부 확장자 정하기
	var bColCount = objGrd.getCellCount("Body");
	if( bColCount > 256 ) {
		objExport1.exportEx(sFileName+'x', true, 1);  // ESC 중단을 위한 추가 사항
	} else {
		objExport1.export(sFileName, true, 1);  // ESC 중단을 위한 추가 사항
	}
	
	//Groupping
	if(bb.substr(0,1) == 'G') {	
		for( var i=0; i<aa; i++ ) {
			var objg   = '_objExcelGrid'+i;
			var objd   = '_ds_excel'+i;
			objGrd     = eval(objg);
			objDataset = eval(objd);
			
			try{
				objGrd.destroy();
				objDataset.clear();
			}catch(e){
			}
		}
	}
	
	if( aa == 1 ) {
		eval(obj.binddataset).rowposition = -1;
	}
}

/**
 * 그리드 내용 Html형식 엑셀파일로 저장 
 * @param obj  : Grid
 */
function gfn_exportExcelEx(obj:Grid, objCondDs:Dataset, sYn, sheetName, sTreeFlag)
{

var aa = 0;
	eval(obj.binddataset).enableevent = false;
	if(eval(obj.binddataset).rowposition == -1)
	{
		aa = 1;
	}

//	var vFile = gfn_fileDialog("SAVE","excel files (*.xls)|*.xls");
	
	var FileDialog_excel 				= new FileDialog;
	FileDialog_excel.defaultextention 	= true;	
	
	var bColCount = obj.getCellCount("Body");
			
	if(bColCount > 256) {
		FileDialog_excel.filter 			= "xlsx files (*.xlsx)|*.xlsx";
	}
	else{
		FileDialog_excel.filter 			= "xls files(*.xls)|*.xls|xlsx files (*.xlsx)|*.xlsx";
	}
		
	var vFile 							= FileDialog_excel.open("file download",FileDialog.SAVE,"%Document%");

//trace(vFile.fullpath);
	var CWS = vFile.fullpath.split(".");
	//trace(CWS[CWS.length -1]);

if(gfn_isNull(vFile))
	{
		if(aa == 1)
		{
			eval(obj.binddataset).rowposition = -1;
		}
		return;
	}

//조회조건 출력용 Grid 생성
	if(!this.isValidObject("_objExcelCondGrid1")){
		var _objExcelCondGrid = new Grid();
			_objExcelCondGrid.init("_objExcelCondGrid1",0,0,100,100);
			_objExcelCondGrid.visible = false;
		this.addChild("_objExcelCondGrid1", _objExcelCondGrid);
		_objExcelCondGrid.show();
	}		
			
	var sFormat = "";	
	sFormat += '<Formats>\n';
	sFormat += '  <Format id="default">\n';
	sFormat += '	<Columns>\n';
	sFormat += '	  <Column size="200"/>\n';
	sFormat += '	  <Column size="800"/>\n';
	sFormat += '	</Columns>\n';
	sFormat += '	<Rows>\n';
	sFormat += '	  <Row size="30" band="head"/>\n';
	sFormat += '	  <Row size="24"/>\n';
	sFormat += '	</Rows>\n';
	sFormat += '	<Band id="head">\n';
	sFormat += '	  <Cell text="Label"/>\n';
	sFormat += '	  <Cell col="1" text="Value"/>\n';
	sFormat += '	</Band>\n';
	sFormat += '	<Band id="body">\n';
	sFormat += '	  <Cell text="bind:label" style="align:left;background:white;background2:white;"/>\n';
	sFormat += '	  <Cell col="1" text="bind:value" style="align:left;background:white;background2:white;" autosizecol="limitmin" autosizerow="limitmax"/>\n';
	sFormat += '	</Band>\n';
	sFormat += '  </Format>\n';
	sFormat += '</Formats>\n';
			
	_objExcelCondGrid1.formats = sFormat;
	
	var bCond = true; //조회조건 표시여부 
	
	try{ //조회조건 Dataset 바인딩
		_objExcelCondGrid1.binddataset = objCondDs;
	}catch(e){
		bCond = false;
	}
	if(objCondDs == null) bCond = false;

var objExport1 = new LibExcel;
	objExport1.exportuitype = "exportprogress";
	objExport1.oncomplete.addHandler(LibExcel_oncomplete);
	objExport1.onprocessing.addHandler(LibExcel_onprocessing);

objExport1.clearExportItems();
	
	var sFileName = vFile.fullpath;
	
	var bSucc = VirtualFile.isExist(sFileName);

if(bSucc == true)
	{
		var objExtCommon = new ExtCommon();
		var ret = objExtCommon.DeleteFile(sFileName);

if(ret[0] == false)
		{
			gfn_alert(ret[2]);
			return;
		}
	}	
	
	fn_Excel_log('btn_excel(html)');	
	
	//메인 Data
	var objDs = eval(obj.binddataset);
	
	var bb = objDs.keystring.toString();

var aa;
	if(CWS[CWS.length -1] == "xlsx")
	{
		aa = Math.ceil(obj.rowcount/1000000);
	}
	else
	{
		aa = Math.ceil(obj.rowcount/65000);
	}

if(bb.substr(0,1) == 'G')
	{
		for(var i=0; i< aa; i++){
		
			//20140811 최원식
			var objg = '_objExcelGrid'+ i;		
			
			if(!this.isValidObject(objg)){
				var _objExcelGrid = new Grid();
				
					_objExcelGrid.init(objg,0,0,100,100);
					_objExcelGrid.visible = false;
				this.addChild(objg, _objExcelGrid);
				_objExcelGrid.show();
			}
			var objGrd = eval(objg);
			objGrd.selecttype = "row";
			objGrd.formats = "";
			 var  sFormats = '<Formats>\n' + obj.getCurFormatString() + '\n </Formats>\n';
			objGrd.formats = sFormats;

if(obj.getRealColSize(ic) <= 0)
					{
						objGrd.deleteContentsCol(ic);
					}
				}
			}
			
			var objd = '_ds_excel'+i;
			if(isValidObject(objd)==false)
			{
				var strDsName=objd;
				//Dataset 생성
				var objDataset 	= new Dataset;
				objDataset.name	= strDsName; 
				this.addChild(strDsName, objDataset);

objDataset.clear();
			}

objGrd.binddataset = objd;
			
			var _objDs = eval(objd);
			_objDs.copyData(objDs);

if(gfn_isNull(sheetName) == true)
			{
				objExport1.addExportItem(objGrd, "Data", 0, 0, false);
			}
			else
			{
				objExport1.addExportItem(objGrd, sheetName, 0, 0, false);
			}
		}
	}
	else
	{
		for(var i=0; i< aa; i++)
		{
			var objg = '_objExcelGrid'+i;
			
			if(!this.isValidObject(objg)){
				var _objExcelGrid = new Grid();
				
					_objExcelGrid.init(objg,0,0,100,100);
					_objExcelGrid.visible = false;
				this.addChild(objg, _objExcelGrid);
				_objExcelGrid.show();
			}
			var objGrd = eval(objg);
			objGrd.selecttype = "row";
			objGrd.formats = "";
			 var  sFormats = '<Formats>\n' + obj.getCurFormatString() + '\n </Formats>\n';
			objGrd.formats = sFormats;
			
			var hColCount = objGrd.getCellCount("Head");
			var bColCount = objGrd.getCellCount("Body");
			
			for(var ix=objGrd.getFormatColCount()-1; ix>=0; ix--){ //초기화 
				if((objGrd.getCellProperty("Body", ix, "edittype") == 'masknumber' || objGrd.getCellProperty("Body", ix, "edittype") == 'mask')
				   && gfn_isNull(objGrd.getCellProperty("Body", ix, "mask")) == false)
				{
					var cmask = objGrd.getCellProperty("Body", ix, "mask");
					cmask = cmask.replace('!','');
					cmask = cmask.replace('9','#');
					objGrd.setCellProperty("Body", ix, "mask", cmask);
				}
				objGrd.setFormatColProperty(ix, "band", "body");
				objGrd.setCellProperty("Body", ix, "class", "");
				objGrd.setCellProperty("Body", ix, "background", "");
				objGrd.setCellProperty("Body", ix, "background2", "");
			}
			
			for(var ih=hColCount-1; ih >= 0; ih--)
			{
				objGrd.setCellProperty("head", ih, "background", obj.getCellProperty("head", ih, "background"));
				var sText = objGrd.getCellProperty("head", ih, "text");
				if(gfn_isNull(sText) == false)
				{			
					sText = sText.replace(CONST_ASC_MARK,'');
					sText = sText.replace(CONST_DESC_MARK,'');
					sText = sText.replace(CONST_FILTER,'');
					objGrd.setCellProperty("head", ih, "text",  sText);
				}
				else
				{
					objGrd.setCellProperty("head", ih, "text",  " ");
				}
			}
				
			if(sYn == 'N')
			{
				for(var ic=bColCount-1; ic >= 0; ic--)
				{

objDataset.clear();
			}

objGrd.binddataset = objd;
			
			var _objDs = eval(objd);
			_objDs.copyData(objDs,true);

var k;
			var j;

if(CWS[CWS.length -1] == "xlsx")
			{
				k = (i * 1000000);			
				j = (i * 1000000) + 1000000;
			}
			else
			{
				k = (i * 65000);			
				j = (i * 65000) + 65000;
			}
					
			if(i == (aa - 1))
			{
				j = obj.rowcount;
			}
			var k1 = obj.getDatasetRow(k);
			
			var j1 = obj.getDatasetRow(j-1);
			
			_objDs.filter("rowidx >= " + k1 +" && "+"rowidx <= "+ j1);	
			
			if(sTreeFlag){
				objGrd.setCellProperty("body", objGrd.getBindCellIndex("body","catName"),"treestate", "bind:treeValue");
			}

if(CWS[CWS.length -1] == "xlsx"){
				if(obj.rowcount >= 1000000)
				{
					if(gfn_isNull(sheetName) == true)
					{
						objExport1.addExportItem(objGrd, "Data"+(i+1), 0, 0, false);
					}
					else
					{
						objExport1.addExportItem(objGrd, sheetName+(i+1), 0, 0, false);
					}
				}
				else
				{
					if(gfn_isNull(sheetName) == true)
					{
						objExport1.addExportItem(objGrd, "Data", 0, 0, false);
					}
					else
					{
						objExport1.addExportItem(objGrd, sheetName, 0, 0, false);
					}
				}
			}
			else{
				if(obj.rowcount >= 65000)
				{
					if(gfn_isNull(sheetName) == true)
					{
						objExport1.addExportItem(objGrd, "Data"+(i+1), 0, 0, false);
					}
					else
					{
						objExport1.addExportItem(objGrd, sheetName+(i+1), 0, 0, false);
					}
				}
				else
				{
					if(gfn_isNull(sheetName) == true)
					{
						objExport1.addExportItem(objGrd, "Data", 0, 0, false);
					}
					else
					{
						objExport1.addExportItem(objGrd, sheetName, 0, 0, false);
					}
				}
			}
		}
	}	
	
	if(bCond == true)
	{
		objExport1.addExportItem(_objExcelCondGrid1, "Search Condition", 0, 0, false);
	}

objExport1.exportmessageprocess = "%d/"+(aa+1)+" Exporting %d/%d";
	
	var sFileNameArr = sFileName.split('.');
	
	if(sFileNameArr[1] == "xls"){		
		objExport1.export(sFileName, true, 1);  // ESC 중단을 위한 추가 사항
	}
	else{		
		objExport1.exportEx(sFileName, true, 1);  // ESC 중단을 위한 추가 사항
	}
	/*
	var bColCount = objGrd.getCellCount("Body");
	if(bColCount > 256)
	{
		objExport1.exportEx(sFileName+'x', true, 1);  // ESC 중단을 위한 추가 사항
	}
	else
	{
		objExport1.export(sFileName, true, 1);  // ESC 중단을 위한 추가 사항
	}
	*/

if(bb.substr(0,1) == 'G')
	{	
		for(var i=0; i< aa; i++)
		{
			var objg = '_objExcelGrid'+i;
			var objd = '_ds_excel'+i;
			objGrd   = eval(objg);
			objDataset = eval(objd);
			try{
				objGrd.destroy();
				objDataset.clear();
			}catch(e){}
		}
	}
	
	if(aa == 1)
	{
		eval(obj.binddataset).rowposition = -1;
	}
}

function LibExcel_oncomplete(obj:LibExcel, e:CompleteEventXLS)
{
	if( e.result == true )
	{
		var extCommon = new ExtCommon;
		extCommon.executeProcess(e.filename, null, "C:\\");
	}	
}

// 엑셀 다운로드시 ESC 중단할때
function LibExcel_onprocessing(obj:LibExcel, e:ProcessEventXLS)
{
	if(application.getKeyState(0x1B))
	{
		obj.exportStop();
    }
}

/**
 * Import Excel to DataSet
 * @param objDs  : 엑셀내용을 담을 DataSet object
 * @param nStartRow  : Import을 시작할 엑셀의 시작 Row번호
 * @param bKeepColInfo  : DataSet의 컬럼정보 유지 여부 (1:데이타셋의 컬럼정보 사용, 0:컬럼정보 무시)
 */
function gfn_importExcelToDs(objDs, nStartRow, bKeepColInfo)
{
	if (objDs == null || objDs == undefined) return false;
	if (nStartRow == null || nStartRow == 0) nStartRow = 1;
	if (bKeepColInfo == null || bKeepColInfo == undefined) bKeepColInfo = 1;
	
	var fdl_imp = new FileDialog();
	fdl_imp.defaultextention = true;
	fdl_imp.filter = "excel files (*.xls;*.xlsx)|*.xls;*.xlsx";
	var file = fdl_imp.open("Excel Upload", FileDialog.LOAD,"%MYDOCUMENT%");
	if(file != undefined){
		file.open(VirtualFile.openRead | VirtualFile.openBinary);
		file.close();
	}else{
		return false;
	}
	
	objDs.clearData();

var objExt = new ExtCommon();
	var v_Ret;
	var v_Ret = objExt.excelImportByIndex(file.fullpath, 0, objDs, bKeepColInfo, 1, 0, nStartRow);	
	
	return v_Ret;
}

/**
 * 그리드 선택정렬 정보를 DB로 부터 가져온다.
 * @param nProgramId : 화면 프로그램번호
 */
function gfn_getGridSortInfo(nProgramId)
{
	var sSvcId = "retrieveGridSortInfo"; 
	var sUrl = "comm/formsettingNavi/retrieveGridSortInfo.devx"; 
	var sInDs = "";
	var sOutDs = "ds_gridSortInfo=dsGridSortInfo"
	var sArg = "programId="+nProgramId;
	var sCallbackFnc = "fn_callback"; 
	
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc);
}

/**
 * 틀고정,정렬 및 기타 기능 설정을 위한 그리드 초기화
 * @param obj  : Grid
 * @param sOption  :  sort,fix,copy,sum,filter,format ('1':사용,'0':미사용) 예) '110000' 
 */
function gfn_gridFuncInit(objGrd, sOption)
{
	//option값에 따라 기능 사용 유무 설정 
	var bSort = false, bSort2 = false, bFix = false, bCopy = false, bSum = false, bFilter = false, bFormat = false; bKeyMoving = true;
	if(!gfn_isNull(sOption)){
		sOption = sOption.trim();
		for(var i=0; i < sOption.length; i++){
			var sOptVal = sOption.substr(i,1);
			if(i==0 && sOptVal=='1') bSort 		= true;  	//기본정렬
			if(i==0 && sOptVal=='2') bSort2 	= true; 	//선택정렬
			if(i==1 && sOptVal=='1') bFix 		= true;
			if(i==2 && sOptVal=='1') bCopy 		= true;
			if(i==3 && sOptVal=='1') bSum 		= true;
			if(i==4 && sOptVal=='1') bFilter 	= true;
			if(i==5 && sOptVal=='1') bFormat 	= true; 	//	formats 초기화 
			if(i==6 && sOptVal=='0') bKeyMoving = false;
		}
	}
	//option값이 모두 꺼져있을경우
	//if(bSort == false && bFix == false && bCopy == false && bSum == false && bFilter == false) return;
	
	objGrd.bSort = bSort;
	objGrd.bSort2 = bSort2;
	objGrd.bFix = bFix;
	objGrd.bCopy = bCopy;
	objGrd.bSum = bSum;
	objGrd.bFilter = bFilter;
	objGrd.bFormat = bFormat;
	
	var objPopMenu = gfn_createGridPopMenu(objGrd);
	objGrd.popmenu = objPopMenu;
	objGrd.gridOrgFormat = objGrd.formats;
	objGrd.onrbuttondown.addHandler(_gfn_grid_onrbuttondown); //마우스 오른쪽버튼 이벤트 연결
	
	if(bSort){ //기본정렬
		objGrd.onheadclick.addHandler(gfn_gridSort); //Sort를 위한 헤드클릭이벤트 연결
	}
	if(bSort2){ //선택정렬
		objGrd.onheadclick.addHandler(gfn_gridSort2); //Sort를 위한 헤드클릭이벤트 연결
	}
	if(bFix){
		objGrd.cellsizebandtype = "allband"; 
	}
	if(bCopy || bSum){
		objGrd.selecttype = "area"; //그리드 선택모드 변경 (합계공통기능)
	}
	if(bFilter){
		objGrd._sFilter = null;        //Filter String 저장용  
		objGrd._ds_filterCond = null;  //Filter Dataset 저장용
	}
	
	objGrd.org_cellmovingtype = objGrd.cellmovingtype; //org값 저장
	objGrd.arrFixColSize = []; //틀고정기준 왼쪽 컬럼사이즈값 임시 저장용 
	objGrd.org_formatString = objGrd.getFormatString(); //그리드의 초기 포맷을 저장해둔다.

//---------------------틀고정---------------------------
	objGrd.cellFixFlag = false; //현재 틀고정상태 
	objGrd.fxCellFix = function(nCell){
		if(nCell < 0) return;
	
		
		var nCol = getCellProperty("Head", nCell, "col");
		var nColSpan = getCellProperty("Head", nCell, "colspan");
		var nMaxCol = 0;
		if(nMaxCol < (nCol+nColSpan)){	nMaxCol = nCol+nColSpan; }
		
		if(nColSpan > 1 || nCell > nCol){
			gfn_alert("sku.warning.0005");
			return;
		}
		
		arrFixColSize = []; //배열초기화
			
		var aa = getFormatColCount()-1;

//		for(var i=0; i< nMaxCol; i++){ //왼쪽 컬럼사이즈값 배열에 임시 저장
		for(var i=0; i< aa; i++){ 		//	2013. 11. 20 변경 (조광석)
			arrFixColSize.push(getRealColSize(i));
		}
		enableevent = false;
				
		for(var i=getFormatColCount()-1; i>=0; i--){ //초기화 
			setFormatColProperty(i, "band", "body");
			setCellProperty("Head", i, "line", "1px solid #c5c5c5ff,1px solid #c5c5c5ff");
			setCellProperty("Body", i, "line", "1px solid #e7e7e7ff,1px solid #e7e7e7ff");
		}

fix_pos = hscrollbar.pos;
		
		for(var i=0; i< nMaxCol; i++){ //Cell고정처리 
			setFormatColProperty(i, "band", "left");
			if(i == nMaxCol-1){
				var hi = i - (nCol - nCell);
				setCellProperty("Head", hi, "line", "1px solid #c5c5c5ff,2px solid #a5aab1");
				setCellProperty("Body", i, "line", "1px solid #e7e7e7ff,2px solid #a5aab1");
			}
		}
		
		for(var i=0; i< arrFixColSize.length; i++){  //배열에 있는 왼쪽 컬럼사이즈값 그리드에 복구 
			setFormatColProperty(i,"size",arrFixColSize[i]);
		}
		if(fix_pos > 0){ //스크롤이 이동된 상태일 경우 이동된 col수 만큼 임시로 접어준다.
			for(var i=0; i< fix_pos; i++){
				setFormatColProperty(i,"size",0);
			}
			hscrollbar.pos = fix_pos;
		}

cellFixFlag = true;
		cellmovingtype = 'none'; //틀고정시에는 이동 못하게 막음.
		
		enableevent = true;
		
	};
	//-------------------------------------------------------
	//---------------------틀고정 취소---------------------------
	objGrd.fxCellFixRemove = function(){
		if(cellFixFlag == false){			
			hscrollbar.pos = 0; //스크롤 움직인채로 틀고정해제 후 틀고정 다시 할 경우 칼럼 잘리는 현상이 있어 스크롤 위치 강제 고정함
			return;
		}
		var arrColSize = []; //틀고정기준 왼쪽 컬럼사이즈값 임시 저장
		for(var i=0; i<getFormatColCount(); i++){ //현재 컬럼사이즈값 배열에 저장 
			if(fix_pos > 0 && fix_pos > i){ //H스크롤값이 1이상인 경우 현재사이즈는 0 이므로 틀고정이전  사이즈로 복구시킨다. 
				arrColSize.push(arrFixColSize[i]);
			}else{
				arrColSize.push(getRealColSize(i));
			}
		}				
		for(var i=getFormatColCount()-1; i>=0; i--){ //초기화 
			setFormatColProperty(i, "band", "body");
			setCellProperty("Head", i, "line", "1px solid #c5c5c5ff,1px solid #c5c5c5ff");
			setCellProperty("Body", i, "line", "1px solid #e7e7e7ff,1px solid #e7e7e7ff");
		}
		for(var i=0; i< arrColSize.length; i++){  //배열에 있는 컬럼사이즈값 그리드에 복구 
			setFormatColProperty(i,"size",arrColSize[i]);
		}
		cellFixFlag = false;
		cellmovingtype = org_cellmovingtype; //원래값 복구
		
		hscrollbar.pos = 0; //스크롤 움직인채로 틀고정해제 후 틀고정 다시 할 경우 칼럼 잘리는 현상이 있어 스크롤 위치 강제 고정함
	};
	//-------------------------------------------------------
	//------------------onkeydown event----------------------
	objGrd.fxOnkeydown = function(objGrd, e:KeyEventInfo){
		if(e.ctrlKey && e.keycode == 86) { // Ctrl + V
			gfn_clipboardPaste(objGrd);
		}else if(e.ctrlKey && e.keycode == 67) { // Ctrl + C
			gfn_copyToClipboard(objGrd);
		}		
	};
	//-------------------------------------------------------
	
	if(bCopy){
		objGrd.onkeydown.addHandler(objGrd.fxOnkeydown);  //onkeydown event 연결
	}
	
	// 키보드 화살표로 커서 안 움직이게 하기  2014-01-16
	if(bKeyMoving == true)
	{
		var _bindDs = eval(objGrd.binddataset);
		_bindDs.bobjGrd = objGrd;
		_bindDs.canrowposchange.addHandler(_gfn_bindDs_canrowposchange);
	}
}

/**
 * 그리드에서 키보드 커서로 처음이나 끝 셀에서 안 움직이게 처리 2014-01-16
 * @param obj  : Grid
 */
function _gfn_bindDs_canrowposchange(obj:Dataset, e:DSRowPosChangeEventInfo)
{
	var bLKey = application.getKeyState(0x25);
	var bRKey = application.getKeyState(0x27);

if(bLKey || bRKey)
	{
		var objGrd = obj.bobjGrd;
		if(bRKey)
		{
			if(objGrd.getCellPos() == 0)
			{
				return false;
			}
			else
			{
				var colSize = 0;
				var nendCol = objGrd.getCellCount("body") -1;
				
				for(var nPos = 0; nPos < objGrd.getCellPos(); nPos++)
				{
					
					var iPos = toNumber(objGrd.getCellProperty("body", nPos, "col"));
					if(objGrd.getRealColSize(iPos) > 0)
					{
						colSize += objGrd.getRealColSize(iPos);
					}
					if(colSize > 0)
					{
						break;
					}
				}
				
				if(colSize <= 0)
				{
					return false;
				}
			}
		}
		else if(bLKey)
		{
			if(objGrd.getCellPos() == (objGrd.getCellCount("body") -1))
			{
				return false;
			}
			else
			{
				var colSize = 0;
				for(var nPos = objGrd.getCellPos()+1; nPos < objGrd.getCellCount("body") -1; nPos++)
				{
					var iPos = toNumber(objGrd.getCellProperty("body", nPos, "col"));
					
					if(objGrd.getRealColSize(iPos) <= 0)
					{
						colSize += 0;
					}
					else
					{
						colSize += objGrd.getRealColSize(iPos);
					}
					if(colSize > 0)
					{
						break;
					}
				}
				
				if(colSize <= 0)
				{
					return false;			
				}
			}
		}
	}
}

/**
 * 그리드에서 오른쪽 마우스버튼 클릭시 팝업메뉴 생성
 * @param obj  : Grid
 */
function gfn_createGridPopMenu(objGrd)
{
	var ds_popMenu = new Dataset();
	//ds_popMenu.copyData(gds_gridPopMenu);
	ds_popMenu.addColumn("id","STRING");
	ds_popMenu.addColumn("level","STRING");
	ds_popMenu.addColumn("title","STRING");
	ds_popMenu.addColumn("gb","STRING");
	ds_popMenu.addColumn("url","STRING");
	ds_popMenu.addColumn("userdata","STRING");
	
	var iRow;
	
	if(objGrd.bSort == true || objGrd.bSort2 == true){
		if(ds_popMenu.rowcount > 0){
			ds_popMenu.setColumn(ds_popMenu.addRow(),"title",'-');
		}
		iRow = ds_popMenu.addRow();
		ds_popMenu.setColumn(iRow,"id",'10');
		ds_popMenu.setColumn(iRow,"level",'0');
		ds_popMenu.setColumn(iRow,"title",'Clear Sort');	
	}				
	if(objGrd.bSort == true){  //기본정렬
		iRow = ds_popMenu.addRow();
		ds_popMenu.setColumn(iRow,"id",'11');
		ds_popMenu.setColumn(iRow,"level",'0');
		ds_popMenu.setColumn(iRow,"title",'Multi Sort');
	}
	if(objGrd.bSort2 == true){  //선택정렬
		iRow = ds_popMenu.addRow();
		ds_popMenu.setColumn(iRow,"id",'12');
		ds_popMenu.setColumn(iRow,"level",'0');
		ds_popMenu.setColumn(iRow,"title",'Multi Sort');
	}
	
	if(objGrd.bFix == true){  //틀고정
		if(ds_popMenu.rowcount > 0){
			iRow = ds_popMenu.addRow();
			ds_popMenu.setColumn(iRow,"title",'-');
			ds_popMenu.setColumn(iRow,"gb",'Fix');
		}
		iRow = ds_popMenu.addRow();
		ds_popMenu.setColumn(iRow,"id",'20');
		ds_popMenu.setColumn(iRow,"level",'0');
		ds_popMenu.setColumn(iRow,"title",'Fixed Column');
		ds_popMenu.setColumn(iRow,"gb",'fix');
		iRow = ds_popMenu.addRow();
		ds_popMenu.setColumn(iRow,"id",'21');
		ds_popMenu.setColumn(iRow,"level",'0');
		ds_popMenu.setColumn(iRow,"title",'Undo Fixed Column');
		ds_popMenu.setColumn(iRow,"gb",'fix');
	}
	
	if(objGrd.bSum == true){ //선택합계
		if(ds_popMenu.rowcount > 0){
			ds_popMenu.setColumn(ds_popMenu.addRow(),"title",'-');
		}
		iRow = ds_popMenu.addRow();
		ds_popMenu.setColumn(iRow,"id",'30');
		ds_popMenu.setColumn(iRow,"level",'0');
		ds_popMenu.setColumn(iRow,"title",'Selection Sum');
	}
	
	if(objGrd.bFilter == true){ //필터
		if(ds_popMenu.rowcount > 0){
			ds_popMenu.setColumn(ds_popMenu.addRow(),"title",'-');
		}
		iRow = ds_popMenu.addRow();
		ds_popMenu.setColumn(iRow,"id",'40');
		ds_popMenu.setColumn(iRow,"level",'0');
		ds_popMenu.setColumn(iRow,"title",'Filter');
		iRow = ds_popMenu.addRow();
		ds_popMenu.setColumn(iRow,"id",'41');
		ds_popMenu.setColumn(iRow,"level",'0');
		ds_popMenu.setColumn(iRow,"title",'Clear Filter');
	}
	
	if(objGrd.bFormat == true){ //포맷 초기화
		if(ds_popMenu.rowcount > 0){
			ds_popMenu.setColumn(ds_popMenu.addRow(),"title",'-');
		}
		iRow = ds_popMenu.addRow();
		ds_popMenu.setColumn(iRow,"id",'50');
		ds_popMenu.setColumn(iRow,"level",'0');
		ds_popMenu.setColumn(iRow,"title",'Reset Column Format');
	}
	
	//다른 화면을 열기 위한 링크 정보 
	
	if(gfn_isNull(objGrd.arrLinkPopInfo) == false){
		if(objGrd.arrLinkPopInfo.length == 0) return;
		if(ds_popMenu.rowcount > 0){
			ds_popMenu.setColumn(ds_popMenu.addRow(),"title",'-');
		}
		for(var i=0; i<objGrd.arrLinkPopInfo.length; i++){
			var arrData = objGrd.arrLinkPopInfo[i].split("|");
			var iRow = ds_popMenu.addRow();
			
			if(arrData.length > 2)
			{
                if(arrData[1] == "P")
                {
                    ds_popMenu.setColumn(iRow,"id","popup_"+arrData[0]);
                    ds_popMenu.setColumn(iRow,"level",'0');
                    ds_popMenu.setColumn(iRow,"title",arrData[0]);
                    
                    if(!gfn_isNull(arrData[2])) 
                    { 
                        ds_popMenu.setColumn(iRow,"userdata",arrData[2]);
                    }                         
                }
			}
			else
			{
                ds_popMenu.setColumn(iRow,"id",'linkextpop_'+arrData[1]);
                ds_popMenu.setColumn(iRow,"level",'0');
                ds_popMenu.setColumn(iRow,"title",arrData[0]);
                ds_popMenu.setColumn(iRow,"url",arrData[1]);
			}
		}
	}
		
	var objPopMenu = new PopupMenu("popMenu_"+objGrd.name, 0, 0, 150, 100);
	objPopMenu.innerdataset = ds_popMenu;
	objPopMenu.gridObject = objGrd;
	objPopMenu.captioncolumn = "title";
	//objPopMenu.hotkey = "hotkey";
	objPopMenu.idcolumn = "id";
	objPopMenu.levelcolumn = "level";
	objPopMenu.userdatacolumn  = "userdata";
	this.addChild(objPopMenu.name, objPopMenu);
	objPopMenu.show();
	objPopMenu.onmenuclick.addHandler(_gfn_grid_onmenuclick);

objPopMenu.onmouseleave.addHandler(_gfn_popMenu_onmouseleave);
	return objPopMenu;
}

obj.popmenu.trackPopup(e.screenX, e.screenY);
	
}

/**
 * 그리드 팝업메뉴 클릭 
 * @param obj : PopupMenu
 * @param e   : MenuClickEventInfo
 */
function _gfn_grid_onmenuclick(obj:PopupMenu, e:MenuClickEventInfo)
{
    obj.closePopup();
	if(e.id == "10"){ //정렬 제거
		gfn_clearSortMark(obj.gridObject);
	}else if(e.id == "11"){ //다건기본정렬
		gfn_gridMultiSort(obj.gridObject);	
	}else if(e.id == "12"){ //다건선택정렬
		gfn_gridMultiSort2(obj.gridObject);		
	}else if(e.id == "20"){ //틀고정클릭
		obj.gridObject.fxCellFix(obj._nCell);
	}else if(e.id == "21"){ //틀고정취소
		obj.gridObject.fxCellFixRemove();
	}else if(e.id == "30"){ //선택영역 합계
		gfn_selectAreaSum(obj.gridObject);
	}else if(e.id == "40"){ //필터
		gfn_gridFilter(obj.gridObject);
	}else if(e.id == "41"){ //필터 제거 
		gfn_gridRemoveFilter(obj.gridObject);
	}else if(e.id == "50"){ //포맷 초기화
		gfn_resetGridFormats(obj.gridObject);
	}else if(e.id.indexOf("linkextpop_") > -1){ //Ext팝업화면오픈
		gfn_extWorkSpacePopupOpen(e.id.substr(11));  // linkextpop_ 문자열을 제거한 URL을 인자로 넘긴다.
	}
	else if(e.id.indexOf("popup") > -1){ //일반팝업화면오픈

var arrParam = e.userdata.split(",");
        if(arrParam.length > 5)
        {

var dsName = eval(arrParam[3]).binddataset;
            var iRow = obj._nRow; //마우스가 위치한 row의 값을 사용
            var nParam = parseInt(arrParam[4]);
            var arg = "";
            
            if( dsName.rowcount == 0 ){
				return false;
            }

if(iRow >= 0 && nParam > 0)
            {
                for(var i=1; i <= nParam; i++)
                {
                    eval("var "+arrParam[4+i]+" = "+dsName+".getColumn(iRow, '"+arrParam[4+i]+"');");
                    
                    if(i == nParam)
                    {
                        arg = arg + "arg"+i+":"+arrParam[4+i];
                    }
                    else
                    {
                        arg = arg + "arg"+i+":"+arrParam[4+i]+",";
                    }
                }
                eval("var argParam = {"+arg+"};");
                
                gfn_openPopup(e.id, arrParam[0], argParam, parseInt(arrParam[1]), parseInt(arrParam[2]), null, null, true);
            }
        }
	}
}

/**
 * 그리드정렬
 * @param obj  : Grid
 */
function gfn_gridSort(obj:Grid, e:GridClickEventInfo)
{
	var bindDs = eval(obj.binddataset);
	if(bindDs.rowcount == 0) return false;
	
	var nColSpan = obj.getCellProperty("head", e.cell, "colspan");
	if(nColSpan > 1) return;
	
	var sType = obj.getCellProperty("head",e.cell,"displaytype");
	if(sType == "checkbox") return;
	
	if(bindDs.keystring.toString().indexOf("G:") > -1){
		gfn_alert("This grid has been the grouping. Does not support sorting.");
		return;
	}
	
	var CONST_SORT_MARK = "";
	var BodyColId = (obj.getCellProperty("body", e.col,"text")).toString().split(":");	// e.col : 바인드된 컬럼.

if (BodyColId[0] != "bind") {
		return false;
	}
	
	bindDs.enableevent = false;
	for (var i = 0; i < obj.getCellCount("head"); i++) {
		if(obj.getCellText(-1, i)=="undefined")
			continue;
		
		var glen = CONST_ASC_MARK.length;
		
		var strHeadText = obj.getCellText(-1, i);

if(i==e.cell){
			obj.setCellProperty( "head", i, "displaytype", 'decoratetext');
			if (strHeadText.substr(strHeadText.length-glen) == CONST_ASC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - glen)+CONST_DESC_MARK);
				bindDs.keystring = "S:-"+BodyColId[1]+"+rowno";
			} else if (strHeadText.substr(strHeadText.length-glen) == CONST_DESC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - glen));
				bindDs.keystring = "";
			}
			
			else if (strHeadText.substr(strHeadText.length-(2*glen),glen) == CONST_ASC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - (2*glen))+CONST_DESC_MARK+strHeadText.substr(strHeadText.length - glen,glen));
				bindDs.keystring = "S:-"+BodyColId[1]+"+rowno";
			} else if (strHeadText.substr(strHeadText.length-(2*glen),glen) == CONST_DESC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - (2*glen))+strHeadText.substr(strHeadText.length - glen,glen));
				bindDs.keystring = "";
			} else {
				obj.setCellProperty( "head", i, "text", strHeadText+CONST_ASC_MARK);
				bindDs.keystring = "S:+"+BodyColId[1]+"+rowno";
			}			
		} else {
			if (strHeadText.substr(strHeadText.length-glen) == CONST_ASC_MARK || strHeadText.substr(strHeadText.length-glen) == CONST_DESC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - glen));
			}
			else if (strHeadText.substr(strHeadText.length-(2*glen),glen) == CONST_ASC_MARK || strHeadText.substr(strHeadText.length-(2*glen),glen) == CONST_DESC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - (2*glen)) + strHeadText.substr(strHeadText.length - glen,glen));
			}
		}
	}
	bindDs.enableevent = true;
}

/**
 * 선택적 그리드정렬 (각 그리드의 정렬정보를 DB로 관리) 
 * 각 화면에 "ds_gridSortInfo" 가 있어야 한다. 
 * @param obj  : Grid
 */
function gfn_gridSort2(obj, e:GridClickEventInfo)
{
	var bindDs = eval(obj.binddataset);
	if(bindDs.rowcount == 0) return false;
	
	var nColSpan = obj.getCellProperty("head", e.cell, "colspan");
	if(nColSpan > 1) return;
	
	var sType = obj.getCellProperty("head",e.cell,"displaytype");
	if(sType == "checkbox") return;
	
	if(bindDs.keystring.toString().indexOf("G:") > -1){
		gfn_alert("This grid has been the grouping. Does not support sorting.");
		return;
	}
			
	var CONST_SORT_MARK = "";
	var BodyColId = (obj.getCellProperty("body", e.col,"text")).toString().split(":");	// e.col : 바인드된 컬럼.

if (BodyColId[0] != "bind") {
		return false;
	}
	
	//해당컬럼이 소트대상인지 체크
	var gridId = obj.name;
	var sColId = BodyColId[1];
	var fRow = ds_gridSortInfo.findRowExpr("gridId == '"+gridId+"' && columnId == '"+sColId+"'");
	if(fRow == -1)  return; //그리드소트정보가 없으면 
	
	//설정된 Sort대상컬럼ID 확인 (Combo 및 기타 경우) 
	var sSortColId = ds_gridSortInfo.getColumn(fRow,"sortColumnId");
	if(gfn_isNull(sSortColId) == false){
		sColId = sSortColId;
	} 
	
	bindDs.enableevent = false;
	for (var i = 0; i < obj.getCellCount("head"); i++) {
		if(obj.getCellText(-1, i)=="undefined")
			continue;

var glen = CONST_ASC_MARK.length;
		
		var strHeadText = obj.getCellText(-1, i);

if(i==e.cell){
			obj.setCellProperty( "head", i, "displaytype", 'decoratetext');
			if (strHeadText.substr(strHeadText.length-glen) == CONST_ASC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - glen)+CONST_DESC_MARK);
				bindDs.keystring = "S:-"+sColId+"+rowno";
			} else if (strHeadText.substr(strHeadText.length-glen) == CONST_DESC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - glen));
				bindDs.keystring = "";
			}
			
			else if (strHeadText.substr(strHeadText.length-(2*glen),glen) == CONST_ASC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - (2*glen))+CONST_DESC_MARK+strHeadText.substr(strHeadText.length - glen,glen));
				bindDs.keystring = "S:-"+sColId+"+rowno";
			} else if (strHeadText.substr(strHeadText.length-(2*glen),glen) == CONST_DESC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - (2*glen))+strHeadText.substr(strHeadText.length - glen,glen));
				bindDs.keystring = "";
			} else {
				obj.setCellProperty( "head", i, "text", strHeadText+CONST_ASC_MARK);
				bindDs.keystring = "S:+"+sColId+"+rowno";
			}			
		} else {
			if (strHeadText.substr(strHeadText.length-glen) == CONST_ASC_MARK || strHeadText.substr(strHeadText.length-glen) == CONST_DESC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - glen));
			}
			else if (strHeadText.substr(strHeadText.length-(2*glen),glen) == CONST_ASC_MARK || strHeadText.substr(strHeadText.length-(2*glen),glen) == CONST_DESC_MARK) {
				obj.setCellProperty( "head", i, "text", strHeadText.substr(0, strHeadText.length - (2*glen)) + strHeadText.substr(strHeadText.length - glen,glen));
			}
		}
	}
	bindDs.enableevent = true;
}

/**
 * Sort Mark 제거
 * @param obj	Grid Object
 */
function gfn_clearSortMark(obj:Grid)
{
	var bindDs = eval(obj.binddataset);
	bindDs.enableevent = false;
	bindDs.keystring = "";

for (var i = 0; i < obj.getCellCount("head"); i++) {
		if(obj.getCellText(-1, i)=="undefined")
			continue;

var strHeadText = obj.getCellText(-1, i);
			strHeadText = strHeadText.replace(CONST_ASC_MARK,"");
			strHeadText = strHeadText.replace(CONST_DESC_MARK,"");
			obj.setCellProperty("head", i, "text", strHeadText);
	}
	bindDs.enableevent = true;	
}

/**
 * 그리드 멀티 정렬
 * @param obj  : Grid
 */
function gfn_gridMultiSort(obj:Grid, e:GridClickEventInfo)
{
	if(!isValidObject("_ds_temp")){
		var objDs = new Dataset();
		this.addChild("_ds_temp", objDs);
		
		_ds_temp.addColumn("text","string");
		_ds_temp.addColumn("text1","string");
		_ds_temp.addColumn("colId","string");
		_ds_temp.addColumn("colIndex","string");
		_ds_temp.addColumn("colSort","string");
		_ds_temp.addColumn("colSeq","string");
	}
	_ds_temp.clearData();
	
	if(!isValidObject("_ds_temp_1")){
		var objDs = new Dataset();
		this.addChild("_ds_temp_1", objDs);	
	}
	_ds_temp_1.copyData(_ds_temp);
	
	var arrColId = new Array();
	var iRowCnt = obj.getCellCount("head");
	
	for(var i=0; i<iRowCnt; i++){
		var nCol 		= obj.getCellProperty("head",i,"col");
		var nColspan	= obj.getCellProperty("Head",i,"colspan");
		var sText 		= obj.getCellProperty("head",i,"text");
		var sType 		= obj.getCellProperty("head",i,"displaytype");
		var sText1		= '';	
		
		if(sType == "checkbox") continue;
		if(gfn_isNull(sText)) continue;
		
		
		sText = sText.replace(CONST_ASC_MARK,'');
		sText = sText.replace(CONST_DESC_MARK,'');
		sText1 = sText;
		sText = sText.replace(CONST_FILTER,'');
					
		var arrColId = -1;
		var sColId = "";
		
		try{
			arrColId	= obj.getCellProperty("body",nCol,"text").split(":");
			sColId		= arrColId[1];
		}catch(e){}
		
		var nFidx1 = -1;
		var nFidx2 = -1;
		
		try{
			nFidx1 = sText.indexOf("expr");
			if(nFidx1 == -1){
				nFidx1 = sText.indexOf("undefined");
			}
		}catch(e){
			nFidx1 = -1;
		}
		
		try{
			nFidx2 = obj.getCellProperty("body",nCol,"text").indexOf("expr");
			if(nFidx2 == -1){
				nFidx2 = obj.getCellProperty("body",nCol,"text").indexOf("undefined");
			}
		}catch(e){
			nFidx2 = -1;
		}
	
		if(obj.getFormatColSize(nCol) > 0 && nColspan == 1 && sText != undefined && sText != "0" && nFidx1 == -1 && nFidx2 == -1){
			var iRow = _ds_temp.addRow();
			_ds_temp.setColumn(iRow,"text", sText);
			_ds_temp.setColumn(iRow,"text1", sText1);
			_ds_temp.setColumn(iRow,"colIndex",i);
			_ds_temp.setColumn(iRow,"colSort",0);
			_ds_temp.setColumn(iRow,"colSeq","");
			_ds_temp.setColumn(iRow,"colId",sColId);
		}
	}

if(iColIdx == undefined) break;
					
			obj.setCellProperty( "head", iColIdx, "displaytype", 'decoratetext');
			
			if(sSort == "+"){
				obj.setCellProperty("head",iColIdx,"text",sText + CONST_ASC_MARK);
			}else{
				obj.setCellProperty("head",iColIdx,"text",sText + CONST_DESC_MARK);
			}
		}
		
		var bindDs = eval(obj.binddataset);
		bindDs.enableevent = false;
		bindDs.keystring.current = retVal.replace("^","") +"+rowno";
		bindDs.enableevent = true;
	}
}

/**
 * 선택적 그리드 멀티 정렬 (각 그리드의 정렬정보를 DB로 관리) 
 * 각 화면에 "ds_gridSortInfo" 가 있어야 한다.
 * @param obj  : Grid
 */
function gfn_gridMultiSort2(obj:Grid, e:GridClickEventInfo)
{
	if(!isValidObject("_ds_temp")){
		var objDs = new Dataset();
		this.addChild("_ds_temp", objDs);
		
		_ds_temp.addColumn("text","string");
		_ds_temp.addColumn("text1","string");
		_ds_temp.addColumn("colId","string");
		_ds_temp.addColumn("colId1","string");
		_ds_temp.addColumn("colIndex","string");
		_ds_temp.addColumn("colSort","string");
		_ds_temp.addColumn("colSeq","string");
	}
	_ds_temp.clearData();
	
	/* 2013.12.18 Add */
	if(!isValidObject("_ds_temp_1")){
		var objDs = new Dataset();
		this.addChild("_ds_temp_1", objDs);	
	}
	_ds_temp_1.copyData(_ds_temp);
		
	var arrColId = new Array();
	var iRowCnt = obj.getCellCount("head");
	
	
	for(var i=0; i<iRowCnt; i++){
		var nCol 		= obj.getCellProperty("head",i,"col");
		var nColspan	= obj.getCellProperty("Head",i,"colspan");
		var sText 		= obj.getCellProperty("head",i,"text");
		var sType 		= obj.getCellProperty("head",i,"displaytype");
			
		if(sType == "checkbox") continue;
		if(gfn_isNull(sText)) continue;
		
		sText = sText.replace(CONST_ASC_MARK,'');
		sText = sText.replace(CONST_DESC_MARK,'');
		sText1 = sText;
		sText = sText.replace(CONST_FILTER,'');
							
		var arrColId = -1;
		var sColId = "";
		
		try{
			arrColId	= obj.getCellProperty("body",nCol,"text").split(":");
			sColId		= arrColId[1];
		}catch(e){}
		
		var nFidx1 = -1;
		var nFidx2 = -1;
		
		try{
			nFidx1 = sText.indexOf("expr");
			if(nFidx1 == -1){
				nFidx1 = sText.indexOf("undefined");
			}
		}catch(e){
			nFidx1 = -1;
		}
		
		try{
			nFidx2 = obj.getCellProperty("body",nCol,"text").indexOf("expr");
			if(nFidx2 == -1){
				nFidx2 = obj.getCellProperty("body",nCol,"text").indexOf("undefined");
			}
		}catch(e){
			nFidx2 = -1;
		}
		
		//해당컬럼이 소트대상인지 체크
		var gridId = obj.name;
		
		var fRow = ds_gridSortInfo.findRowExpr("gridId == '"+gridId+"' && columnId == '"+sColId+"'");
		if(fRow == -1)  continue; //그리드소트정보가 없으면 
		
		
		var sColId1 = sColId;
		//설정된 Sort대상컬럼ID 확인 (Combo 및 기타 경우) 
		var sSortColId = ds_gridSortInfo.getColumn(fRow,"sortColumnId");
		if(gfn_isNull(sSortColId) == false){
			sColId = sSortColId;
		} 
		
		if(obj.getFormatColSize(nCol) > 0 && nColspan == 1 && sText != 'undefined' && sText != "0" && nFidx1 == -1 && nFidx2 == -1){
		
			var iRow = _ds_temp.addRow();
			_ds_temp.setColumn(iRow,"text", sText);
			_ds_temp.setColumn(iRow,"text1", sText1);
			_ds_temp.setColumn(iRow,"colIndex",i);
			_ds_temp.setColumn(iRow,"colSort",0);
			_ds_temp.setColumn(iRow,"colSeq","");
			_ds_temp.setColumn(iRow,"colId",sColId);
			_ds_temp.setColumn(iRow,"colId1",sColId1);
		}
	}

/* 2013.12.18 Add */
	var iRowCnt = obj.getCellCount("Body");
	var colCount = _ds_temp.getRowCount();
	for(var i=0; i<iRowCnt; i++){
		arrColId	= obj.getCellProperty("body",i,"text").split(":");
		sColId		= arrColId[1];
		for(var j=0; j<colCount; j++)
		{
			if(sColId == _ds_temp.getColumn(j,"colId1"))
			{
				var aRow = _ds_temp_1.addRow();
				_ds_temp_1.copyRow(aRow,_ds_temp,j);
			}
		}
	}
	
	_ds_temp.copyData(_ds_temp_1);

var bindDs = eval(obj.binddataset);
		bindDs.enableevent = false;
		bindDs.keystring.current = retVal.replace("^","") +"+rowno";
		bindDs.enableevent = true;		
	}
}

/**
 * 그리드 Body영역의 Row Count 리턴 
 * @param obj	Grid Object
 */
function gfn_getBodyRowCount(obj:Grid)
{
	var nCount=0;
	for(var i=0;i<obj.getFormatRowCount();i++){
		if(obj.getFormatRowProperty(i,"band")=="body"){
			nCount++;
		}
	}
	return nCount;
}

/**
 * 그리드 Body영역의 Cell번호 리턴 
 * @param obj	Grid Object
 * @param nRow	Body의 Row번호 (멀티Row인 경우 1 이상의 값이다)
 * @param nCol	Col번호
 */
function gfn_getBodyCellno(obj:Grid, nBodyRow, nCol)
{
	for(var i=0;i<obj.getCellCount("Body");i++){
		var row = obj.getCellProperty("Body",i,"row");
		var col = obj.getCellProperty("Body",i,"col");
		if(row == nBodyRow && col == nCol) break;
	}
	return i;
}

/**
 * clipboard 내용을 그리드에 붙여넣기 
 * @param obj	Grid Object
 */
function gfn_clipboardPaste(obj:Grid)
{
	var sSeparator = "	";
	var objDs = eval(obj.binddataset);
	
	var nSearchRow = 0;
	var nSearchCol = 0;
	var sColID;
	var sValue;
	var sClipData = system.getClipboard("CF_TEXT");
	sClipData = sClipData.replace(",",""); //숫자에서 comma 제거
	
	var sClipRow = sClipData.split("\n");
	var sClipCol;

var nAreaStartRow, nAreaEndRow;
	var nStartsubrow, nEndsubrow;  //멀티ROW로 구성된 Grid 체크용 
	var nAreaStartCol;
	var nAreaEndCol;

if(obj.selecttype == "area") {
		nAreaStartRow = toNumber(obj.selectstartrow);
		nAreaEndRow   = toNumber(obj.selectendrow);
		nAreaStartCol = toNumber(obj.selectstartcol);
		nAreaEndCol   = toNumber(obj.selectendcol);
		nStartsubrow  = toNumber(obj.selectstartsubrow);
		nEndsubrow    = toNumber(obj.selectendsubrow);
	}else{
		nAreaStartRow = obj.currentrow ;
		nAreaEndRow   = obj.currentrow ;
		nAreaStartCol = obj.currentcell;
		nAreaEndCol   = obj.currentcell;
	}
	
	var nColCount = obj.getCellCount("Head");
	var nSetCell; //실제 붙여넣을 대상 Cell번호
	
	var nBodyCellCount = obj.getCellCount("Body"); //Body Cell Count
	var nMultiRowCount = gfn_getBodyRowCount(obj); //멀티Row수 확인

if(nMultiRowCount == 1){

obj.enableredraw = false;
		for(var nRow = nAreaStartRow; nRow < (nAreaStartRow + sClipRow.length); nRow++) {
			sClipCol = sClipRow[nSearchRow].split(sSeparator);	
			nSearchCol = 0;
			var nAreaCell = nAreaStartCol + sClipCol.length;
		
			objDs.rowposition = nRow;

for(var nCell = nAreaStartCol; nCell < nAreaCell && nCell < nColCount; nCell++) { 
				sValue = sClipCol[nSearchCol];	
				if(sValue != "undefined"){
					if(sValue != null ){
//						sValue = sValue.replace(/\s/g,'');  //개행문자 제거Y

sColID = obj.getCellProperty("body",nCell,"text").substr(5);
						
						obj.setCellPos(nCell);
						
						if(obj.getCurEditType(nCell) == "none" || obj.getCellProperty("Body",nCell,"edittype") == 'none' || obj.readonly == true || obj.enable == false
						|| gfn_isNull(obj.getCellProperty("Body",nCell,"edittype")) == true )
						{ 
							continue;
						}
						else
						{
							if(obj.getCellProperty("Body",nCell,"editlimit") == '-1' || gfn_isNull(obj.getCellProperty("Body",nCell,"editlimit")) == true)
							{
								if(gfn_isNull(objDs.getColumnInfo("rowedit")) == false)
								{
									if(objDs.getColumn(nRow, "rowedit") != 'Y')
									{
										continue;
									}
									else
									{
										objDs.setColumn(nRow,sColID,sValue);
									}
								}								
								else
								{
									objDs.setColumn(nRow,sColID,sValue);
								}
							}
							else
							{
								if(gfn_isNull(objDs.getColumnInfo("rowedit")) == false)
								{
									if(objDs.getColumn(nRow, "rowedit") != 'Y')
									{
										continue;
									}
									else
									{
										var aa = toNumber(obj.getCellProperty("Body",nCell,"editlimit"));
										sValue.substr(0,aa);
										objDs.setColumn(nRow,sColID,sValue);
									}
								}
							}
						}	
					}
					nSearchCol++;
				}
				nAreaCell++;
			}
			nSearchRow++;
		}//for
		
		objDs.rowposition = nAreaStartRow;
		obj.setCellPos(nAreaStartCol);
		obj.enableredraw = true;
	
	}else if(nMultiRowCount > 1){ //멀티Row인 경우 
		obj.enableredraw = false;
		var nMultiRowCount = gfn_getBodyRowCount(obj); //멀티Row수 확인
		var nDsRow = nAreaStartRow;
		var sMRow = nStartsubrow;
		for(var nRow = 0; nRow < sClipRow.length; nRow++){
			sClipCol = sClipRow[nSearchRow].split(sSeparator);
			var nCol = nAreaStartCol;
			
			objDs.rowposition = nRow;
			
			for(var nClipCol = 0; nClipCol < sClipCol.length; nClipCol++){
				sValue = sClipCol[nClipCol];
				if(sValue != "undefined"){
					if(sValue != null ){
//						sValue = sValue.replace(/\s/g,'');  //개행문자 제거Y
						var nCell = gfn_getBodyCellno(obj,sMRow,nCol);
						
						sColID = obj.getCellProperty("body",nCell,"text").substr(5);
						
						obj.setCellPos(nCell);
						
						if(obj.getCurEditType(nCell) == "none" || obj.getCellProperty("Body",nCell,"edittype") == 'none' || obj.readonly == true || obj.enable == false
						|| gfn_isNull(obj.getCellProperty("Body",nCell,"edittype")) == true)
						{
							continue;
						}
						else
						{
							if(obj.getCellProperty("Body",nCell,"editlimit") == '-1' || gfn_isNull(obj.getCellProperty("Body",nCell,"editlimit")) == true)
							{
								if(gfn_isNull(objDs.getColumnInfo("rowedit")) == false)
								{
									if(objDs.getColumn(nRow, "rowedit") != 'Y')
									{
										continue;
									}
									else
									{
										objDs.setColumn(nRow,sColID,sValue);
									}
								}
								else
								{
									objDs.setColumn(nRow,sColID,sValue);
								}								
							}
							else
							{
								if(gfn_isNull(objDs.getColumnInfo("rowedit")) == false)
								{
									if(objDs.getColumn(nRow, "rowedit") != 'Y')
									{
										continue;
									}
									else
									{
										var aa = toNumber(obj.getCellProperty("Body",nCell,"editlimit"));
										sValue.substr(0,aa);
										objDs.setColumn(nRow,sColID,sValue);
									}
								}
							}
						}						
					}
					nCol++;
				}
			}
			nSearchRow++;
			sMRow++;
			if(sMRow == nMultiRowCount)
			{
				sMRow = 0;
				nDsRow++;
			}
		}
		obj.enableredraw = true;
	}
}

/**
 * Grid의 내용을 clipboard로 Copy 
 * @param obj	Grid Object
 */
function gfn_copyToClipboard(obj:Grid)
{
	var sSeparator = "	";
	var objDs = eval(obj.binddataset);
	
	var nSearchRow = 0;
	var nSearchCol = 0;
	var sColID;
	var sValue;
	var sClipData = "";

var nAreaStartRow, nAreaEndRow;
	var nStartsubrow, nEndsubrow;  //멀티ROW로 구성된 Grid 체크용 
	var nAreaStartCol;
	var nAreaEndCol;

if(obj.selecttype == "area") 
	{
		nAreaStartRow = toNumber(obj.selectstartrow);
		nAreaEndRow   = toNumber(obj.selectendrow);
		nAreaStartCol = toNumber(obj.selectstartcol);
		nAreaEndCol   = toNumber(obj.selectendcol);
		nStartsubrow  = toNumber(obj.selectstartsubrow);
		nEndsubrow    = toNumber(obj.selectendsubrow);
	}
	else
	{
		nAreaStartRow = toNumber(obj.currentrow);
		nAreaEndRow   = toNumber(obj.currentrow);
		nAreaStartCol = toNumber(obj.currentcell);
		nAreaEndCol   = toNumber(obj.currentcell);
		nStartsubrow  = toNumber(obj.selectstartsubrow);
		nEndsubrow    = toNumber(obj.selectendsubrow);
	}

system.setClipboard("CF_TEXT",buf.getUTF8(0));
}

/**
 * 그리드 선택영역 합계 계산 
 * @param obj Grid Object
 */
function gfn_selectAreaSum(obj:Grid){
	var objDs = eval(obj.binddataset);

var sColID;
	var sValue;

var nAreaStartRow = 0;
	var nAreaEndRow = 0;
	var nAreaStartCol = 0;
	var nAreaEndCol = 0;
	var nStartsubrow, nEndsubrow;  //멀티ROW로 구성된 Grid 체크용 
	
	if(obj.selecttype == "area") {
		nAreaStartRow = obj.selectstartrow;
		nAreaEndRow   = obj.selectendrow;
		nAreaStartCol = obj.selectstartcol;
		nAreaEndCol   = obj.selectendcol;
		nStartsubrow  = toNumber(obj.selectstartsubrow);
		nEndsubrow    = toNumber(obj.selectendsubrow);
	}else{
		nAreaStartRow = obj.currentrow ;
		nAreaEndRow   = obj.currentrow ;
		nAreaStartCol = obj.currentcell;
		nAreaEndCol   = obj.currentcell;
		nStartsubrow  = toNumber(obj.selectstartsubrow);
		nEndsubrow    = toNumber(obj.selectendsubrow);		
	}

if(nAreaStartRow == nAreaEndRow && nAreaStartCol == nAreaEndCol){
		gfn_alert("dev.inf.com.noselect");
		return;
	}
		
	var nCount = 0, nSum = 0, nAvg = 0;
	var nX = 0;
	var nY = 0;
	
	if(nStartsubrow == 0 && nEndsubrow == 0)
	{	
		for(var nRow = toNumber(nAreaStartRow); nRow <= toNumber(nAreaEndRow); nRow++) {
			for(var nCell = toNumber(nAreaStartCol); nCell <= toNumber(nAreaEndCol); nCell++) {
				/* 2014.01.10 일 추가 */
				var arrCellRect = obj.getCellRect(nRow,nCell);
				if(arrCellRect.right != 0)
				{
					nX = arrCellRect.right;
				}
				if(arrCellRect.bottom != 0)
				{
					nY = arrCellRect.bottom;
				}

nVal = obj.getCellText(nRow, nCell);
				nVal = nVal.replace(",",""); //숫자에서 comma 제거
				
				if(gfn_isNull(nVal)) continue;
				
				if(typeof nVal === 'decimal'){
					nCount += 1;
					nSum += nVal;
				}else if(typeof nVal === 'string'){
		
					 if(gfn_isNumber(nVal)){ //숫자인 경우만
						nCount += 1;
						nSum += toNumber(nVal);
					 }
				}
			}
		}	
	}
	else
	{
		var nBodyCellCount = obj.getCellCount("Body"); //Body Cell Count
		var nMultiRowCount = gfn_getBodyRowCount(obj); //멀티Row수 확인
		
		for(var nRow = toNumber(nAreaStartRow); nRow <= toNumber(nAreaEndRow); nRow++) 
		{
			var sMRow, eMRow;
			//멀티Row 번호 지정 
			if(nRow == toNumber(nAreaStartRow)) sMRow = toNumber(nStartsubrow);
			else sMRow = 0;
			if(nRow == toNumber(nAreaEndRow)) eMRow = toNumber(nEndsubrow);
			else eMRow = nMultiRowCount - 1;
			
			for(var j = sMRow; j <= eMRow; j++) 
			{
				for(var nCol = toNumber(nAreaStartCol); nCol <= toNumber(nAreaEndCol); nCol++) 
				{
				
					/* 2014.01.10 일 추가 */
					var nCell = gfn_getBodyCellno(obj,j,nCol);
					var arrCellRect = obj.getCellRect(nRow,nCell);
					if(arrCellRect.right != 0)
					{
						nX = arrCellRect.right;
					}
					if(arrCellRect.bottom != 0)
					{
						nY = arrCellRect.bottom;
					}		
					
					nVal = obj.getCellText(nRow, nCell);
					nVal = nVal.replace(",",""); //숫자에서 comma 제거
					
					if(gfn_isNull(nVal)) continue;
					
					if(typeof nVal === 'decimal')
					{
						nCount += 1;
						nSum += nVal;
					}
					else if(typeof nVal === 'string')
					{
			
						 if(gfn_isNumber(nVal))
						 { //숫자인 경우만
							nCount += 1;
							nSum += toNumber(nVal);
						 }
					}					
				}
			}
		}			
	}
	
	//PopupDiv open
	var sPdvName = "pdvSum_"+obj.name;
	var objPopupDiv = new PopupDiv(sPdvName, 0, 0, 150, 60);
	this.addChild(objPopupDiv.name, objPopupDiv);
	objPopupDiv.url = "common::CommGridSelectSum.xfdl";
	objPopupDiv.show();
	
	objPopupDiv.div_sum.stc_count.text = nCount;
	objPopupDiv.div_sum.stc_sum.text = nSum;
	objPopupDiv.div_sum.stc_avg.text = Math.round(nSum / nCount,2);
	
	var nX1 = system.clientToScreenX(obj,nX);
	var nY1 = system.clientToScreenY(obj,nY);

objPopupDiv.trackPopup(nX1,nY1);
	this.removeChild(sPdvName);
	objPopupDiv.destroy();

}

/**
 * Grid Dataset의 RowType => 4(수정)인 경우 background 색상 변경을 위한 세팅 (css color01)
 * @param obj Grid
 */
function gfn_cellBgRowType4(obj:Grid)
{
	var sExpr = "EXPR(getRowType(currow)==4?'#fff2f2ff':'#ffffffff')";
	var sExprColor02 = "EXPR(getRowType(currow)==4?'#fff2f2ff':'#f0f7ffff')";
	
	for(var i = 0; i < obj.getCellCount("body"); i++){
		if(obj.getCellProperty("body",i,"class") == 'color02'){
			obj.setCellProperty("body",i,"background",sExprColor02);
			obj.setCellProperty("body",i,"background2",sExprColor02);
		}else{
			obj.setCellProperty("body",i,"background",sExpr);
			obj.setCellProperty("body",i,"background2",sExpr);
		}
	}
}

/**
 * Grid 필터처리
 * @param obj Grid
 */
function gfn_gridFilter(obj:Grid)
{
	var objDs = eval(obj.binddataset);
	var sArgs = "";

var newChild = xCenterChildFrame("CommGrdFilter",400,310,"common::CommGridFilter.xfdl");
	newChild.layered = false;
	newChild.style.border.width = "1";
	newChild.style.border.color = "#717b86";
	newChild.style.border.style = "solid";
	newChild.showstatusbar = false;
	newChild.showtitlebar = false;
	newChild._grid = obj;
	var objParentFrame = this.getOwnerFrame();
	
	var rtn = newChild.showModal(objParentFrame, sArgs);
	
	objDs.enableevent = false;
	if(rtn){
		objDs.filter(obj._sFilter);
	}

objDs.rowposition = -1;
	
	objDs.enableevent = true;
}

/**
 * Grid 필터적용 제거 
 * @param obj Grid
 */
function gfn_gridRemoveFilter(obj:Grid)
{
	var objDs = eval(obj.binddataset);
	objDs.enableevent = false;
	obj._sFilter = "";
	obj._ds_filterCond = null;
	
	objDs.filter(obj._sFilter);

for (var j = 0; j < obj.getCellCount("head"); j++) 
	{
		if(obj.getCellText(-1, j)=="undefined")
		continue;

var strHeadText = obj.getCellText(-1, j);		
				
		strHeadText = strHeadText.replace(CONST_FILTER,"");
		obj.setCellProperty("head", j, "text", strHeadText);
	}
	objDs.enableevent = true;
}

/**
 * Grid Head의 rect 정보
 * @param obj Grid
 */
function gfn_calcHeadCellRect(obj:Grid)
{
	var cellCnt = obj.getCellCount("head");
	var rects = [];
	var rect;
	for(var i=0; i<cellCnt; i++){
		rects.push(obj.getCellRect(-1, i));
	}
	obj._headCellRects = rects; 
}

/**
 * Grid Head에 마우스오버시 동적버튼 생성을 위한 초기화 
 * @param objGrid : Grid
 * @param nBtnW : 생성할 버튼 Width
 * @param nBtnH : 생성할 버튼 Height
 * @param sBtnText : 생성할 버튼에 표시할 문자
 * @param sBtnClickEvent : 버튼클릭시 처리할 함수 
 */
function gfn_initGridHeadOverBtn(objGrid, nBtnW, nBtnH, sBtnText, btnClickEvent)
{
	gfn_calcHeadCellRect(objGrid);

objGrid.onformatchanged.addHandler(gfn_calcHeadCellRect);
	objGrid.oncolresized.addHandler(gfn_calcHeadCellRect);
	objGrid.onhscroll.addHandler(gfn_calcHeadCellRect);	
	
	var objBtn = new Button();
	
	objBtn.init("btn_headOverButton", 0, 0, nBtnW, nBtnH);
	objBtn.style.border = "0px none #ffffffff";
	objBtn.visible = false;
	objBtn.text = sBtnText;
	objBtn.onclick.addHandler(btnClickEvent);

objGrid.parent.addChild(objBtn.name, objBtn);
	objBtn.show();
	
	objBtn._grid = objGrid;
	objGrid._headOverButton = objBtn;
	objGrid._headOverBtnFlag = sBtnText;
}

/**
 * Grid Head에 마우스오버시 동적버튼 생성을 위한 초기화 
 */
function gfn_initGridHeadOverBtn1(objGrid, nBtnW, nBtnH, sBtnText, btnClickEvent)
{
	var objBtn1 = new Button();
	
	objBtn1.init("btn_headOverButton1", 0, 0, nBtnW, nBtnH);
	objBtn1.style.border = "0px none #ffffffff";
	objBtn1.visible = false;
	objBtn1.text = sBtnText;
	objBtn1.onclick.addHandler(btnClickEvent);
	objGrid.parent.addChild(objBtn1.name, objBtn1);
	objBtn1.show();
	
	objBtn1._grid = objGrid;
	objGrid._headOverButton1  = objBtn1;
	objGrid._headOverBtnFlag1 = sBtnText;
}

/**
 * Grid Head에 마우스오버시 동적버튼 생성을 위한 초기화 
 */
function gfn_initGridHeadOverBtn2(objGrid, nBtnW, nBtnH, sBtnText, btnClickEvent)
{
	var objBtn2 = new Button();
	
	objBtn2.init("btn_headOverButton2", 0, 0, nBtnW, nBtnH);
	objBtn2.style.border = "0px none #ffffffff";
	objBtn2.visible = false;
	objBtn2.text = sBtnText;
	objBtn2.onclick.addHandler(btnClickEvent);
	objGrid.parent.addChild(objBtn2.name, objBtn2);
	objBtn2.show();
	
	objBtn2._grid = objGrid;
	objGrid._headOverButton2  = objBtn2;
	objGrid._headOverBtnFlag2 = sBtnText;
}

/**
 * Grid Head에 마우스오버시 동적버튼 생성을 위한 초기화 
 */
function gfn_initGridHeadOverBtn3(objGrid, nBtnW, nBtnH, sBtnText, btnClickEvent)
{
	var objBtn3 = new Button();
	
	objBtn3.init("btn_headOverButton3", 0, 0, nBtnW, nBtnH);
	objBtn3.style.border = "0px none #ffffffff";
	objBtn3.visible = false;
	objBtn3.text = sBtnText;
	objBtn3.onclick.addHandler(btnClickEvent);
	objGrid.parent.addChild(objBtn3.name, objBtn3);
	objBtn3.show();
	
	objBtn3._grid = objGrid;
	objGrid._headOverButton3  = objBtn3;
	objGrid._headOverBtnFlag3 = sBtnText;
}

/**
 * Grid Head에 마우스오버시 동적버튼 생성을 위한 초기화 
 */
function gfn_initGridHeadOverBtn4(objGrid, nBtnW, nBtnH, sBtnText, btnClickEvent)
{
	var objBtn4 = new Button();
	
	objBtn4.init("btn_headOverButton4", 0, 0, nBtnW, nBtnH);
	objBtn4.style.border = "0px none #ffffffff";
	objBtn4.visible = false;
	objBtn4.text = sBtnText;
	objBtn4.onclick.addHandler(btnClickEvent);
	objGrid.parent.addChild(objBtn4.name, objBtn4);
	objBtn4.show();
	
	objBtn4._grid = objGrid;
	objGrid._headOverButton4  = objBtn4;
	objGrid._headOverBtnFlag4 = sBtnText;
}

/**
 * Grid Head에 마우스오버시 동적버튼 생성을 위한 초기화 
 */
function gfn_initGridHeadOverBtn5(objGrid, nBtnW, nBtnH, sBtnText, btnClickEvent)
{
	var objBtn5 = new Button();
	
	objBtn5.init("btn_headOverButton5", 0, 0, nBtnW, nBtnH);
	objBtn5.style.border = "0px none #ffffffff";
	objBtn5.visible = false;
	objBtn5.text = sBtnText;
	objBtn5.onclick.addHandler(btnClickEvent);
	objGrid.parent.addChild(objBtn5.name, objBtn5);
	objBtn5.show();
	
	objBtn5._grid = objGrid;
	objGrid._headOverButton5  = objBtn5;
	objGrid._headOverBtnFlag5 = sBtnText;
}

/**
 * Grid Head에 마우스오버시 동적버튼 생성을 위한 초기화 
 */
function gfn_initGridHeadOverBtn6(objGrid, nBtnW, nBtnH, sBtnText, btnClickEvent)
{
	var objBtn6 = new Button();
	
	objBtn6.init("btn_headOverButton6", 0, 0, nBtnW, nBtnH);
	objBtn6.style.border = "0px none #ffffffff";
	objBtn6.visible = false;
	objBtn6.text = sBtnText;
	objBtn6.onclick.addHandler(btnClickEvent);
	objGrid.parent.addChild(objBtn6.name, objBtn6);
	objBtn6.show();
	
	objBtn6._grid = objGrid;
	objGrid._headOverButton6  = objBtn6;
	objGrid._headOverBtnFlag6 = sBtnText;
}

/**
 * Grid Head에 마우스오버시 동적버튼 생성을 위한 초기화 
 */
function gfn_initGridHeadOverBtn7(objGrid, nBtnW, nBtnH, sBtnText, btnClickEvent)
{
	var objBtn7 = new Button();
	
	objBtn7.init("btn_headOverButton7", 0, 0, nBtnW, nBtnH);
	objBtn7.style.border = "0px none #ffffffff";
	objBtn7.visible = false;
	objBtn7.text = sBtnText;
	objBtn7.onclick.addHandler(btnClickEvent);
	objGrid.parent.addChild(objBtn7.name, objBtn7);
	objBtn7.show();
	
	objBtn7._grid = objGrid;
	objGrid._headOverButton7  = objBtn7;
	objGrid._headOverBtnFlag7 = sBtnText;
}

/**
 * Grid Head에 마우스오버시 동적버튼 생성을 위한 초기화 
 */
function gfn_initGridHeadOverBtn8(objGrid, nBtnW, nBtnH, sBtnText, btnClickEvent)
{
	var objBtn8 = new Button();
	
	objBtn8.init("btn_headOverButton8", 0, 0, nBtnW, nBtnH);
	objBtn8.style.border = "0px none #ffffffff";
	objBtn8.visible = false;
	objBtn8.text = sBtnText;
	objBtn8.onclick.addHandler(btnClickEvent);
	objGrid.parent.addChild(objBtn8.name, objBtn8);
	objBtn8.show();
	
	objBtn8._grid = objGrid;
	objGrid._headOverButton8  = objBtn8;
	objGrid._headOverBtnFlag8 = sBtnText;
}

/**
 * Grid Head에 마우스오버시 동적버튼 생성을 위한 초기화 
 */
function gfn_initGridHeadOverBtn9(objGrid, nBtnW, nBtnH, sBtnText, btnClickEvent)
{
	var objBtn9 = new Button();
	
	objBtn9.init("btn_headOverButton9", 0, 0, nBtnW, nBtnH);
	objBtn9.style.border = "0px none #ffffffff";
	objBtn9.visible = false;
	objBtn9.text = sBtnText;
	objBtn9.onclick.addHandler(btnClickEvent);
	objGrid.parent.addChild(objBtn9.name, objBtn9);
	objBtn9.show();
	
	objBtn9._grid = objGrid;
	objGrid._headOverButton9  = objBtn9;
	objGrid._headOverBtnFlag9 = sBtnText;
}

/**
 * gfn_gridFuncInit 함수 호출시 미리 저장해둔 그리드 초기 format 으로 되돌리는 함수 
 * @param objGrid : Grid
 */
 function gfn_gridonformatchanged(obj:Grid, e:GridFormatChangedEventInfo)
 {
	obj.org_formatString = '<Formats>\n' + obj.getCurFormatString() + '\n </Formats>\n';
 }
 
function gfn_resetGridFormats(objGrid)
{
	if(gfn_isNull(objGrid.org_formatString) == false)
	{
		
		objGrid.formats = objGrid.org_formatString;
		objGrid.cellFixFlag = false;
		objGrid.bFix == false;

try
		{ 
			fn_gridTitleShow(objGrid);
		}
		catch(e){}
	}
}

/**
 * gfn_Gridclear 소트 및 필터 Clear 처리
 * @param objGrid : Grid
 */
function gfn_Gridclear(objGrid)
{
	gfn_gridRemoveFilter(objGrid);
	gfn_clearSortMark(objGrid);
}

/**
 * gfn_positionDivOpen Grid에서 Division 위치 처리
 * @param divObj 		: 해당 Division
 * @param grdObj 		: 해당 gridObj
 * @param nCell  		: 해당 Grid Cell
 * @param nRow   		: 해당 Grid Row
 * @param divDataFlag   : div_data 존재여부
 */
function gfn_positionDivOpen(divObj, grdObj, nCell, nRow, divDataFlag, sForcePosition)
{
	var arrCellRect, arrBeforeCellRect, arrLeft, arrBotom; 
	var nDivX, nDivY, maxX, maxY, nDivUpY; 
	var divWidth, divHeight;
	var divDataLeft, divDataTop;
	var grdLeft, grdTop, grdRight;	
	
	
	if(grdObj.getFormatColProperty(nCell,"band") == "left"){				
		var maxFixIdx = nCell;	
		for( var i=nCell, cnt=grdObj.getCellCount("body"); i<cnt; i++){
			if(grdObj.getFormatColProperty(i,"band") == "left"){
				maxFixIdx = i;
			}
		}
		
		grdObj.arrFixColSize = []; 
		
		//배열 초기화
		arrFixColSize = []; 	
		
		//원본 그리드 사이즈 임시 저장
		for(var i=0,cnt=grdObj.getFormatColCount()-1; i<cnt; i++){
			arrFixColSize.push(grdObj.getRealColSize(i));
		}
		
		grdObj.enableevent = false;
		//초기화
		for(var i=grdObj.getFormatColCount()-1; i>=0; i--){
			grdObj.setFormatColProperty(i, "band", "body");
			grdObj.setFormatColProperty("Head", i, "line", "1px solid #c5c5c5ff,1px solid #c5c5c5ff");
			grdObj.setFormatColProperty("Body", i, "line", "1px solid #e7e7e7ff,1px solid #e7e7e7ff");
		}
		
		//배열에 있는 컬럼사이즈값 그리드에 복구 
		for(var i=0,len=arrFixColSize.length; i<len; i++){  
			grdObj.setFormatColProperty(i,"size",arrFixColSize[i]);
		}
		
		grdObj.hscrollbar_pos = grdObj.hscrollbar.pos; //현스크롤위치 저장		
		grdObj.hscrollbar.pos = 0;	
		
		//------- 실제 위치 찾기, getCellRect() -> 이 함수의 버그 때문에 이렇게 했음. -------//
		arrCellRect = grdObj.getCellRect(nRow, nCell);		
		if(toNumber(nCell)-1 > -1){
			arrBeforeCellRect	= grdObj.getCellRect(nRow, toNumber(nCell)-1);	
		}			
		//------- 실제 위치 찾기, getCellRect() -> 이 함수의 버그 때문에 이렇게 했음. -------//
		
		//Cell 고정처리
		for(var i=0; i<=maxFixIdx; i++){
			grdObj.setFormatColProperty(i,"band","left");			
		}
		
		//배열에 있는 왼쪽 컬럼사이즈값 그리드에 복구 
		for(var i=0, size=arrFixColSize.length; i<size; i++){  
			grdObj.setFormatColProperty(i,"size", arrFixColSize[i]);				
		}		
		
		//현스크롤위치 복귀
		grdObj.hscrollbar.pos = grdObj.hscrollbar_pos; 
		
		grdObj.enableevent = true;		
	}else{				
		//------- 실제 위치 찾기, getCellRect() -> 이 함수의 버그 때문에 이렇게 했음. -------//
		arrCellRect 		= grdObj.getCellRect(nRow, nCell);		
		if(toNumber(nCell)-1 > -1){
			arrBeforeCellRect	= grdObj.getCellRect(nRow, toNumber(nCell)-1);				
		}		
		//------- 실제 위치 찾기, getCellRect() -> 이 함수의 버그 때문에 이렇게 했음. -------//
	}	
	
		
	divWidth  	= divObj.position.width;
	divHeight 	= divObj.position.height;
	
	divDataLeft = 0;
	divDataTop	= 0;
	
	//default 셋팅
	if( gfn_isNull(divDataFlag) ){
		divDataFlag = true;
	}	
		
	if(divDataFlag){
		divDataLeft = div_data.position.left;
		divDataTop	= div_data.position.top;
	}	
	
	grdLeft 	= grdObj.position2.left;
	
	grdTop  	= grdObj.position2.top;
	grdRight 	= grdObj.position2.right;
		
	maxY		= toNumber(this.position.height)-toNumber(divHeight);
	maxX 		= toNumber(this.position.width)-toNumber(divWidth);
	
	if(!gfn_isNull(arrBeforeCellRect)){
		if( arrCellRect.left == 0 && arrBeforeCellRect.left == 0 ){
			arrLeft 	= 0;
			arrBotom 	= arrCellRect.bottom;	
		}else if(arrCellRect.left == 0 && arrBeforeCellRect.left != 0 ){
			arrLeft  = maxX;
			arrBotom = arrBeforeCellRect.bottom;			
		}else{
			arrLeft  = arrCellRect.left;
			arrBotom = arrCellRect.bottom;			
		}
	}else{
		arrLeft  = arrCellRect.left;
		arrBotom = arrCellRect.bottom;		
	}	
	nDivX  		= toNumber(divDataLeft) + toNumber(grdLeft) + toNumber(arrLeft);
	nDivY		= toNumber(divDataTop)  + toNumber(grdTop)  + toNumber(arrBotom) + toNumber(3);
	
	nDivUpY		= toNumber(divDataTop)  + toNumber(grdTop)  + toNumber(arrCellRect.top) - toNumber(3);

divObj.position.left = nDivX;				
	divObj.position.right = toNumber(nDivX) + toNumber(divWidth);
	
	if(nDivX < maxX){
		divObj.position.left = nDivX;				
		divObj.position.right = toNumber(nDivX) + toNumber(divWidth);						
	}else{				
		divObj.position.left = maxX;
		divObj.position.right = toNumber(maxX) + toNumber(divWidth);
	}
	
	if(nDivY < maxY){			
		divObj.position.top  = nDivY;
		divObj.position.bottom = toNumber(nDivY) + toNumber(divHeight);
	}else{			
		divObj.position.top  = toNumber(nDivUpY) - toNumber(divHeight);
		divObj.position.bottom = nDivUpY;
	}		
	
	//x, y, width, hegith 강제 처리
	if (gfn_isExist(sForcePosition)){
		var aPos = sForcePosition.split(',');
		
		if (gfn_isExist(aPos[0]) && aPos[0] > 0) divObj.position.x = aPos[0];
		if (gfn_isExist(aPos[1]) && aPos[1] > 0) divObj.position.y = aPos[1];
		if (gfn_isExist(aPos[2]) && aPos[2] > 0) divObj.position.width  = aPos[2];
		if (gfn_isExist(aPos[3]) && aPos[3] > 0) divObj.position.height = aPos[3];
	}
}

/** 
 * gfn_gridSetCellPosition 	: grid Cell 찾기
 * @param grdObj 			: 해당 cell 찾을 Grid
 * @param dsObj 			: 해당 row 찾을 dataset
 * @param nRow 				: 해당 row 위치
 * @param colName 			: 해당 cell Name
 */
function gfn_gridSetCellPosition(grdObj, dsObj, nRow, colName){
	grdObj.setFocus();	
	dsObj.rowposition = nRow;
	grdObj.setCellPos(grdObj.getBindCellIndex("body",colName));
	grdObj.showEditor(true);							
}

/** 
 * gfn_gridListHeadSizing 	: 칼럼 폴딩 공통 함수
 * @param objGrid 			: 해당 Grid
 * @param headColCond 		: 접는 컬럼 위치
 * @param startCol 			: 접는 컬럼 시작
 * @param endCol 			: 접는 컬럼 끝
 * @param iSize 			: 컬럼 사이즈
 * @param colMaxName		: REPT080F 특이 로직(MAX 값을 가지는 칼럼은 숨겨져야 함) 
 */
function gfn_gridListHeadSizing(objGrid, headColCond, startCol, endCol, iSize, colMaxName)
{
	var arrColSize 	= [];
	var nColCount 	= objGrid.getCellCount("Body");
	var hColCount   = objGrid.getCellCount("Head");
	var headCol     = 0;	// 접기 버튼 있는 헤드 컬럼
	
	var headOverBtn, headOverBtnFlag;		
	if( headColCond == "hb02" ){
		headOverBtnFlag = objGrid._headOverBtnFlag1;
		headOverBtn = objGrid._headOverButton1;		
	}else{
		headOverBtnFlag = objGrid._headOverBtnFlag;
		headOverBtn = objGrid._headOverButton;
	}
	
	startCol += 1;
	
	//Head가 Merge된 2줄 이므로 해당 접기 버튼 칼럼 위치를 다시 구함 
	for( var i=0; i<hColCount; i++ ) {
		//Merge 된 Head  찾기위해 subsumtext와 비교(+,- 표시해주기 위함)
		if( objGrid.getCellProperty("Head", i, "subsumtext") == headColCond ){
			headCol = i;
		}
	}
	
	//Cell move 후에도 접고 펼치기를 할 수 있도록 버튼 클릭 시 배열에 넣음
	objCol_list1    = [];
	
	for( var i=0; i<nColCount; i++ ){
		arrColSize.push(objGrid.getRealColSize(i));
		objCol_list1.push(objGrid.getCellProperty("Body", i, "text"));
	}

headOverBtn.visible = false;
	var kCol = endCol + 1;
	
	if( headOverBtnFlag == null || headOverBtnFlag == "[-]" ) { 		
		iSize = 0
		headOverBtnFlag = "[+]";
	} else if(headOverBtnFlag == null || headOverBtnFlag == "[+]") {		
		headOverBtnFlag = "[-]";
	}

//REPT080F 특이 로직(MAX 값을 가지는 칼럼은 숨겨져야 함)----------------------
	var maxCol = null;
	if( !gfn_isNull(colMaxName) ){
		maxCol = gfn_getColumnIdx(objGrid, colMaxName, "Body");
	}
	
	for( var i=0; i<nColCount; i++ ) {	
		//접히고 펼쳐질 칼럼 사이즈 변경
		for( var j=startCol; j<kCol; j++ ){		
			if( objGrid.getCellProperty("Body", i, "text") == objCol_list1[j] ){
				objGrid.setFormatColProperty(i, "size", iSize);				
			}
			//REPT080F 특이 로직(MAX 값을 가지는 칼럼은 숨겨져야 함)----------------------
			if( !gfn_isNull(maxCol) ) {
				if( j > maxCol && objGrid.getCellProperty("Body", i, "text") == objCol_list1[j] ){
					objGrid.setFormatColProperty(i, "size", 0);				
				}
			}
		}

// 펼쳐지거나 접히지 않는 칼럼들 원상복구하기 위한 처리
		if( i < startCol || i > endCol ){
			objGrid.setFormatColProperty(i,"size", arrColSize[i]);
		}
	}
	
	objGrid.setCellProperty("Head", headCol, "expandchar", headOverBtnFlag);
	
	if( headColCond == "hb02" ){
		objGrid._headOverBtnFlag1 = headOverBtnFlag;
		objGrid._headOverButton1.text = headOverBtnFlag;		
	}else{		
		objGrid._headOverBtnFlag = headOverBtnFlag;
		objGrid._headOverButton.text = headOverBtnFlag;		
	}
	
	objGrid.setFocus();
}

/** 
 * gfn_setTreeValue 		: Tree Down을 위한 dataset 로직 적용
 * @param dsObj 			: Main Dataset
 * @param strTreeValue 		: 1 - 열기(상태값), 0 - 닫기(상태값)
 */
function gfn_setTreeValue(dsObj, strTreeValue){																	
	//메인 dataset의 데이터 만큼 for문을 돌린다.
	for(var i=0, cnt=dsObj.getRowCount(); i<cnt; i++){
		//카테고리 레빌이 0인 건수만 걸러낸다.
		if( dsObj.getColumn(i,"catLvl") == 0 ) {
			if(i < cnt && dsObj.getColumn(i,"catLvl") < dsObj.getColumn((i+1),"catLvl")) {
				dsObj.setColumn(i, "treeValue", strTreeValue);
			}
		}		
	}		
}

/** 
 * gfn_setGridSubTreeStatus : 부분 펼치기 Select 버튼 클릭
 * @param grdObj 			: 대상 Main Grid
 * @param dsObj 			: 대상 Main Dataset
 * @param dsSubChkObj 		: 체크된 Dataset(펼칠 그리드)
 */
function gfn_setGridSubTreeStatus(grdObj, dsObj, dsSubChkObj, categoryName){
	if( gfn_isNull(categoryName)){
		categoryName = "catName";
	}
	grdObj.enableredraw = false;
	grdObj.enableevent 	= false;
	
	grdObj.setCellProperty("body", grdObj.getBindCellIndex("body",categoryName),"treestate", "");
	
	//우선 다 닫는다.	
	grdObj.treeinitstatus = "collapse,all";
	
	//펼칠 대상이 되는 데이터 중 체크된 데이터만 filter 처리한다.
	dsSubChkObj.filter("chk=='1'");	
	
	var fRow = -1;	
	var dRow = -1;
	
	//메인 dataset의 데이터 만큼 for문을 돌린다.
	for(var i=0, cnt=dsObj.getRowCount(); i<cnt; i++){			
		//카테고리 레빌이 0인 건수만 걸러낸다.
		if( dsObj.getColumn(i,"catLvl") == 0 ) {						
			
			//펼칠 대상 데이터인지 여부 확인
			fRow = dsSubChkObj.findRow("categoryCode", dsObj.getColumn(i,"categoryCode"));			
			
			//펼칠 대상 데이터일 경우
			if( fRow != -1 ) {		
				if(i < cnt && dsObj.getColumn(i,"catLvl") < dsObj.getColumn((i+1),"catLvl")) {
					dsObj.setColumn(i, "treeValue", 1);
				}
			}
			else{
				if(i < cnt && dsObj.getColumn(i,"catLvl") < dsObj.getColumn((i+1),"catLvl")) {
					dsObj.setColumn(i, "treeValue", 0);
				}
			}
		}		
	}

dsSubChkObj.filter("");
	grdObj.enableevent 		= true;	
	grdObj.enableredraw 	= true;
	grdObj.treeinitstatus 	= "";
	grdObj.setCellProperty("body", grdObj.getBindCellIndex("body",categoryName),"treestate", "bind:treeValue");	
}

/**
 * 그리드 내용 Html형식 엑셀파일로 저장 
 * @param obj  		: Grid
 * @param objCondDs : Dataset
 * @param sYn 		: Size가 0인 컬럼을 보여줄지 여부를 확인
 * @param sheetName : SheetName 값 설정
 * @param sEx 		: Expand(열기) - true, Collapse(닫기)여부 - false
 */
function gfn_exportExcelEx3(obj:Grid, sYn, sheetName, sEx) {		
		
	//기존 2003기준 엑셀 다운로드 확장자 셋팅
	var vFile = gfn_fileDialog("SAVE","excel files (*.xls)|*.xls");
	
	if( gfn_isNull(vFile) ) {
		if( aa == 1 ) {
			eval(obj.binddataset).rowposition = -1;
		}
		return;
	}

var objExport 					= new ExportObjectEx();				// ExportObject => ExportObjectEx
	objExport.exporttype 			= ExportTypesEx.EXCEL;
	objExport.activepagename 		= "Sample01";	
	objExport.exportuseclipboard 	= "NO";								// clipboard 사용여부
	
	objExport.exportuitype 			= "exportprogress"; 				// "statusbar";
	objExport.exportUseStyle 		= false; 							// Style 출력 여부 (성능개선 위함)
	objExport.exportUseCellUnicode 	= true;								// 특수문자 변환여부
	
	
	var sFileName  = vFile.fullpath;
	var sFileName2 = vFile.filename;
	sFileName2 = sFileName2.split(".");	
	var bSucc 	  = VirtualFile.isExist(sFileName);

if( bSucc == true ) {
		var objExtCommon = new ExtCommon();
		var ret = objExtCommon.DeleteFile(sFileName);

objDataset.clear();
		}

objGrd.binddataset 	= objd;		
		var _objDs 			= eval(objd);
		_objDs.copyData(objDs);

//sheet Name 설정 : default : "Data"		
		if( gfn_isNull(sheetName) ) {
			sheetName = "Data";			
		} 			
		objExport.addExportItem(ExportItemTypes.GRID, objGrd, sFileName2[0]+"!A1");		
	}
	//Groupping 되지 않는 그 외 것
	else {		
		var objg = '_objExcelGrid';
		
		if( !this.isValidObject(objg) ) {
			var _objExcelGrid = new Grid();				
			_objExcelGrid.init(objg,0,0,100,100);
			_objExcelGrid.visible = false;
			this.addChild(objg, _objExcelGrid);
			_objExcelGrid.show();
		}
		
		var objGrd 			= eval(objg);
		objGrd.selecttype 	= "row";
		objGrd.formats 		= "";
		 var  sFormats 		= '<Formats>\n' + obj.getCurFormatString() + '\n </Formats>\n';
		objGrd.formats 		= sFormats;

//열기일 경우
		if( treeExpandFlag ) {
			objGrd.treeinitstatus = "expand,all";
		}else{
			objGrd.treeinitstatus = "collapse,all";
		}
		
		var hColCount = objGrd.getCellCount("Head");
		var bColCount = objGrd.getCellCount("Body");
		
		//초기화 
		for( var ix=objGrd.getFormatColCount()-1; ix>=0; ix-- ) { 
			if(( objGrd.getCellProperty("Body", ix, "edittype") == 'masknumber' || objGrd.getCellProperty("Body", ix, "edittype") == 'mask' )
			   && !gfn_isNull(objGrd.getCellProperty("Body", ix, "mask")) )
			{
				var cmask 	= objGrd.getCellProperty("Body", ix, "mask");
				cmask 		= cmask.replace('!','');
				cmask 		= cmask.replace('9','#');
				objGrd.setCellProperty("Body", ix, "mask", cmask);
			}
			
			objGrd.setFormatColProperty(ix, "band", "body");
			objGrd.setCellProperty("Body", ix, "class", "");
			objGrd.setCellProperty("Body", ix, "background", "");
			objGrd.setCellProperty("Body", ix, "background2", "");
		}
		
		for( var ih=hColCount-1; ih>=0; ih-- ) {
			objGrd.setCellProperty("head", ih, "background", obj.getCellProperty("head", ih, "background"));
			var sText = objGrd.getCellProperty("head", ih, "text");
			
			if( !gfn_isNull(sText) ) {			
				sText = sText.replace(CONST_ASC_MARK,'');
				sText = sText.replace(CONST_DESC_MARK,'');
				sText = sText.replace(CONST_FILTER,'');
				objGrd.setCellProperty("head", ih, "text",  sText);
			} else {
				objGrd.setCellProperty("head", ih, "text",  " ");
			}
		}
		
		//Col Size = 0 인 값에 대해서 보여주지 않게 셋팅 sYn = 'N'
		if( sYn == 'N' ) {
			for( var ic=bColCount-1; ic>=0; ic-- ) {

if( obj.getRealColSize(ic) <= 0 ) {
					objGrd.deleteContentsCol(ic);
				}
			}
		}
		
		var objd = '_ds_excel';
		if( !isValidObject(objd) ) {
			var strDsName=objd;
			//Dataset 생성
			var objDataset 	= new Dataset;
			objDataset.name	= strDsName; 
			this.addChild(strDsName, objDataset);

objDataset.clear();
		}

objGrd.binddataset = objd;
		
		var _objDs = eval(objd);
		_objDs.copyData(objDs,true);

저작자표시

'Nexacro-컴포넌트 > JavaScript' 카테고리의 다른 글

Nexacro - 공통 (Common) 관련 Javascript (0)	2017.01.19
Nexacro - Form관련 Javascript (0)	2017.01.19
Nexacro - Dateset 관련 Javascript (0)	2017.01.19
Nexacro - 날짜관련 Javascript (0)	2017.01.19
Nexacro - 공통 JavaScript (0)	2017.01.19

Posted by 농부지기

농부지기

Nexacro - Grid관련 Javascript

'Nexacro-컴포넌트 > JavaScript' 카테고리의 다른 글

카테고리

태그목록

최근에 올라온 글

최근에 달린 댓글

최근에 받은 트랙백

글 보관함

달력

링크

티스토리툴바