농부지기 :: 농부지기

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 - Dateset 관련 Javascript

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

[ Nexacro - Dateset 관련 Javascript]

/* DataSet의 값이 변경되었는지 체크
@param objDs : DataSet @return : 변경되었을 경우 true 리턴
*/
function gfn_isDsUpdate(objDs)
{
	if(objDs.getDeletedRowCount() > 0) return true;
	
	for(var i=0; i<objDs.getRowCount(); i++){
	    if(objDs.getRowType(i) != 1){
	        return true;
	    }
	}
	return false;
}

/* DataSet 필수입력값 체크
Grid 객체를 인자로 넘길 경우 해당 Cell에 focus됨. @param objComp Dataset or Grid
@param sColid Column ID 예) "Column_ID1=SAMPLE_NM1,Column_ID2=SAMPLE_NM2" @param bNormalType : RowType값이 normal(1) 인 상태도 체크할지 유무 ( default : false )
@return boolean 예)
var sCheckCol = "divisionCode=division code,siteGroup=site group"; if(!gfn_valueCheck(ds_siteMaster, sCheckCol)) return false;
*/
function gfn_valueCheck(objComp, sColid, bNormalType)
{
	var objDs, objGrid;
	
	if(bNormalType == null) bNormalType = false; // ROWTYPE_NORMAL 체크유무 
	
	if(objComp instanceof Grid){
	    objGrid = objComp;
	    objDs = this.all[objGrid.binddataset];
	}else{
	    objDs = objComp;
	}
	
	for(var i=0; i<objDs.getColCount(); i++){
	    var objArr1; // Array
	    objArr1 = sColid.split(",");
	
	    for(var j=0; j<objArr1.length; j++){
	        var objArr2; // Array
	        objArr2 = objArr1[j].split("=");
	        if(objDs.getColID(i) == objArr2[0]){
	            var nIdx = -1;
	            for(var k = 0;k<objDs.getRowCount();k++){
	                if(gfn_isNull(objDs.getColumn(k,i))){
	                    var nRowType = objDs.getRowType(k); //RowType 체크 
	                    if(bNormalType == false && nRowType == 1) continue;
	                    if(nRowType == 2 || nRowType == 4 || nRowType == 1){
	                        nIdx = k;
	                        break;
	                    }
	                }
	            }
	            if(nIdx > -1){
	            alert('ok>> ');
	            alert('ok>> ' + objArr2[1]);
	                gfn_alert("requisite.required","[" + objArr2[1] + "]");
	                objDs.rowposition = nIdx;
	
	                if(objGrid != null){
	                    var nCol = gfn_getColumnIdx(objGrid,objArr2[0]);
	                    if(nCol > -1){
	                        var sGridSelType = objGrid.selecttype;
	                        objGrid.selecttype = "currow";
	                        objGrid.setCellPos(nCol);
	                        objGrid.showEditor();
	                        objGrid.selecttype = sGridSelType;
	                    }
	                }
	                return false;
	            }
	        }
	    }//for
	}
	
	return true;
}

/**
desc : 필수입력 체크
param : dsObj - 해당 dataset
coildList(List) - 필수 입력 컬럼(List 형태)
grdObj - 해당 그리드

ex) if(!gfn_requiredVaildCheck(ds_aggregateShipment, ["siteId","type","qty","validYn"], div_data.grd_detailGrid,[1,2,3])){        
        return false;
    }
*/
function gfn_requiredVaildCheck(dsObj,colIdList,grdObj)
{
	var msg, colIndex;
	
	msg ="";
	
	if( dsObj.getRowCount() > 0 ){
	    for( var i=0,cnt=dsObj.getRowCount(); i<cnt; i++ ){
	        if( dsObj.getRowType(i)!=1 && dsObj.getColumn(i,"chk")=="1" ){
	            for( var j=0; j<colIdList.length;j++){
	                if(gfn_isNull(dsObj.getColumn(i,colIdList[j]))){                        
	                    msg = grdObj.getCellProperty("head",grdObj.getBindCellIndex("body",colIdList[j]),"text");                            
	
	                    colIndex = grdObj.getBindCellIndex("body",colIdList[j]);
	                    gfn_alert("dev.warn.com.input", "["+msg+"]");                    
	                    dsObj.rowposition = i;                    
	                    grdObj.setCellPos(colIndex);                        
	                    grdObj.showEditor(true);
	                    return false;
	                }
	            }            
	        }            
	    }
	    return true;
	}
}

/**
desc : 필수입력 체크
param : dsObj - 해당 dataset
coildList(List) - 필수 입력 컬럼(List 형태)
grdObj - 해당 그리드

ex) if(!gfn_requiredVaildCheck(ds_aggregateShipment, ["siteId","type","qty","validYn"], div_data.grd_detailGrid,[1,2,3])){        
        return false;
    }
*/
function gfn_requiredVaild(dsObj,colIdList,grdObj)
{
	var msg, colIndex;
	
	msg ="";
	
	if( dsObj.getRowCount() > 0 ){
	    for( var i=0,cnt=dsObj.getRowCount(); i<cnt; i++ ){
	        if( dsObj.getRowType(i)!=1 ){
	            for( var j=0; j<colIdList.length;j++){
	                if(gfn_isNull(dsObj.getColumn(i,colIdList[j]))){                        
	                    msg = grdObj.getCellProperty("head",grdObj.getBindCellIndex("body",colIdList[j]),"text");                            
	
	                    colIndex = grdObj.getBindCellIndex("body",colIdList[j]);
	                    gfn_alert("dev.warn.com.input", "["+msg+"]");                    
	                    dsObj.rowposition = i;                    
	                    grdObj.setCellPos(colIndex);                        
	                    grdObj.showEditor(true);
	                    return false;
	                }
	            }            
	        }            
	    }
	    return true;
	}
}

/* DataSet에 Sort용 rowno 컬럼추가
@param objComp Dataset /
function gfn_addRowno(objDs)
{
	objDs.enableevent = false;
	objDs.addColumn("rowno","BIGDECIMAL");
	for(var i=0; i<objDs.rowcount; i++){
		objDs.setColumn(i,"rowno",i+1);
	}
	objDs.enableevent = true;
	objDs.applyChange();
}

/* 좌측 DataSet에 선택안했을시 전체 선택용 처리
@param objComp Dataset /
function gfn_datasetchk(toDataset, fromDataset)
{

if(isValidObject("cds_Site")==false)
	{
	    var strDsName="cds_Site";
	    //Dataset 생성
	    var objDataset     = new Dataset;
	    objDataset.name    = strDsName; 
	    this.addChild(strDsName, objDataset);
	}
	
	if(fromDataset.getCaseCount("chk == '1'") == 0)
	{
	    cds_Site.copyData(fromDataset,true);
	    cds_Site.filter("lvl == 4");
	    toDataset.clearData();
	    toDataset.copyData(cds_Site,true);
	    // Body셋팅
	    for(var i=0 ; i< toDataset.rowcount ; i++)
	    {
	        toDataset.setColumn(i, "chk", "1");
	    }
	}
	else
	{
	    cds_Site.copyData(fromDataset,true);
	    cds_Site.filter("lvl == 4 && chk == '1'");
	    toDataset.clearData();
	    toDataset.copyData(cds_Site,true);
	}
}

/* 좌측 DataSet에 To_Site에 선택된 Exception Site From 연계
@param objComp Dataset /
function gfn_exceptionBod(Todataset, Fromdataset)
{
	// 2014.02.24 일 변경
	if(ds_leftToSite.getCaseCount("chk == '1'") != 0)
	{
		var dsCount = gds_exceptionBod.getRowCount();
		for(var i=0 ; i< dsCount ; i++)
		{
			// To Site 체크된 항목만 들어간 데이터 셋
			var codeval = gds_exceptionBod.getColumn(i, "attribute3");
			var siteRow = Todataset.findRow("code", codeval);
			if(siteRow != -1)
			{
				var tocodeval = gds_exceptionBod.getColumn(i, "attribute4");
				var tositeRow = Todataset.findRow("code", tocodeval);
				if(tositeRow != -1)
				{
					var dsaddRow = Fromdataset.addRow();
					Fromdataset.copyRow(dsaddRow, Todataset, tositeRow);
				}
				else
				{
					var dsaddRow = Fromdataset.addRow();
					Fromdataset.copyRow(dsaddRow, Todataset, siteRow);
					Fromdataset.setColumn(dsaddRow, "code", tocodeval);
					Fromdataset.setColumn(dsaddRow, "cdname", gds_exceptionBod.getColumn(i, "attribute2"));
				}
			}
		}
	}
}

/* gfn_setDsFirstRow : 해당 dataset을 카피하면서 첫로우 셋팅해 주는 메소드 - dataset 첫 row setting
@param dsSetObj : 셋팅 대상 데이터셋 @param dsGetObj : 복사해 올 데이터셋
@param strValue : All, Select, Null 등 셋팅 값 /
function gfn_setDsFirstRow(dsSetObj, dsGetObj, strValue){
	dsSetObj.clearData();
	dsSetObj.copyData(dsGetObj);
	dsSetObj.insertRow(0);
	dsSetObj.setColumn(0, "cdname", strValue);
}

/*
@desc : 엑셀 다운로드시 조회조건을 넘기는 것에 대해 셋팅
@param : dsObj - 조회조건 셋팅 dataSet
colName - 조건명
colValue - 조건값 /
function gfn_setExcelDownSearch(dsObj, colName, colValue) {
	var aRow = dsObj.addRow();
	dsObj.setColumn(aRow,"label", colName);
	dsObj.setColumn(aRow,"value", colValue);
}

/*
@desc : 원하는 값을 찾아서 Return
@param : objDs - dataSet
sFindStr - 조건절 (A==B)
sGetColId - 찾을 컬럼명 /
function gfn_getFindValue(objDs, sFindStr, sGetColId){
	var nRow;
	
	nRow = objDs.findRowExpr(sFindStr);
	if (nRow < 0) return '';
	
	return objDs.getColumn(nRow, sGetColId);
}

/*
@desc : 조회된 Dataset에 첫번째 Row에 기본값 Set
@param : objDs - dataSet
sColList - 컬럼목록
sValueList - 값 목록
objCombo - comboname
nSelRow - 선택할 콤보 index /
function gfn_setComboDsFirstRow(objDs, sColList, sValueList, objCombo, nSelRow)
{
	var iRow = objDs.insertRow(0);
	
	var aColList   = sColList.split(',');
	var aValueList = sValueList.split(',');
	for(var i=0; i<aColList.length; i++){
	    objDs.setColumn(iRow, aColList[i] , aValueList[i]);
	}
	
	if (gfn_isExist(objCombo)) objCombo.index = nSelRow;
}

저작자표시

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

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

Posted by 농부지기

Nexacro - 날짜관련 Javascript

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

[ Nexacro - 날짜관련 Javascript ]

/***
System Name : SKU/lib Job Name : Common
File Name : xDate.xjs Make Date :
Description : 공통 Date 사용 함수 모음

Modify Date Modifier Modify Description
****/

/**
현재 날짜 (YYYYMMDD)
*/
function gfn_getToday() {
	var objDate = new Date();
	var s = objDate.getFullYear()
	   + ((objDate.getMonth() + 1) + "").padLeft(2, '0')
	   + (objDate.getDate() + "").padLeft(2, '0');
	return (s);
}
/* 현재 날짜시간값 14자리
*/
function gfn_getDateTime()
{
	var objDate = new Date();
	var sDateTime = gfn_getToday()+
								(objDate.getHours() + "").padLeft(2, '0')+
								(objDate.getMinutes() + "").padLeft(2, '0')+
								(objDate.getSeconds() + "").padLeft(2, '0');
	return sDateTime;
}

/* 현재 시간값(시분초) 6자리
*/
function gfn_getTime()
{
	var objDate = new Date();
	var sTime = (objDate.getHours() + "").padLeft(2, '0')+
							(objDate.getMinutes() + "").padLeft(2, '0')+
							(objDate.getSeconds() + "").padLeft(2, '0');
	return sTime;
}

/* 해당일의 요일값을 리턴
@param sDate 'yyyyMMdd' @return 0 = 일요일 ~ 6 = 토요일
*/
function gfn_getDay(sDate)
{
	var objDate = new Date();
	objDate.setFullYear(parseInt(sDate.substr(0,4)), parseInt(sDate.substr(4,2))-1, parseInt(sDate.substr(6,2)));
	objDate.setHours(0, 0, 0);
	objDate.setMilliseconds(0);
	return objDate.getDay();
}

/* Add Month
@param sMonth 'yyyyMM' @param nOffSet 증감 단위 숫자
@return 'yyyyMM' /
function gfn_addMonth(sMonth, nOffSet)
{
	var date = new Date();
	
	date.setYear(String(sMonth).substr(0, 4));
	date.setMonth(String(sMonth).substr(4, 2)-1-(nOffSet*-1));
	
	return gfn_getDateToStr(date).substr(0, 6);
}

/* Add Date
@param sDate 'yyyyMMdd' @param nOffSet 증감 단위 숫자
@return 'yyyyMMdd' /
function gfn_addDate(sDate, nOffSet)
{
	var date = new Date();
	sDate = (String)(sDate);
	date.setFullYear(parseInt(sDate.substr(0,4)), parseInt(sDate.substr(4,2))-1, parseInt(sDate.substr(6,2)-(nOffSet*-1)));
	return gfn_getDateToStr(date);
}

/* 해당월의 마지막날을 리턴
@param sMonth 'yyyyMM' @return Number
*/
function gfn_getMonthLastDay(sMonth)
{
	var iLastDay;
	var iYear = parseInt(String(sMonth).substr(0, 4),10) ;
	var iMonth = parseInt(String(sMonth).substr(4, 2),10);
	switch(iMonth)
	{
	case 2 :
		if( ((iYear%4)==0) && ((iYear%100)!=0) || ((iYear%400)==0) )
			iLastDay = 29;
		else
			iLastDay = 28;
		break;
	case 4 :
	case 6 :
	case 9 :
	case 11 :
		iLastDay = 30;
		break;
	default: iLastDay = 31;
		break;
	}
	
	return iLastDay;
}

/* 해당일이 속한 주의 월요일 날짜를 리턴
@param sDate yyyyMMdd @return yyyyMMdd
*/
function gfn_getMondayDate(sDate)
{
	var objDate = new Date();
	objDate.setFullYear(parseInt(sDate.substr(0,4)), parseInt(sDate.substr(4,2))-1, parseInt(sDate.substr(6,2)));
	var i = objDate.getDay();
	var iDayCnt = (i == 0)?-6:1-i;
	var dateMon = new Date(objDate.getYear(), objDate.getMonth(), objDate.getDate() + iDayCnt);
	return gfn_getDateToStr(dateMon);
}

/* Date 형을 String 형으로 변환
@param date Date Type @return yyyyMMdd
*/
function gfn_getDateToStr(date)
{
	if (gfn_isNull(date)) return;
	
	var sYear = date.getYear().toString();
	var sMonth = (date.getMonth()+1).toString();
	var sDate = date.getDate().toString();
	
	if(sYear.length==2)
	    sYear = '19'+sYear;
	else if(sYear.length==1)
	    sYear = '190'+sYear;
	
	if(sMonth.length==1)
	    sMonth = '0'+sMonth;
	if(sDate.length==1)
	    sDate = '0'+sDate;
	
	return sYear+sMonth+sDate;
}

/* 날짜 검증
@param sDate yyyyMM or yyyyMMdd, ex) "201308" or "20130801" @return boolean
*/
function gfn_isDate(sDate){
	var retVal;
	
	switch(sDate.length)
	{
	    case 6://yyyyMM
	        retVal =  gfn_isYM(sDate);
	        break;
	    case 8://yyyyMMdd
	        retVal =  gfn_isYMD(sDate);
	        break;
	    default:
	        retVal = false; 
	        break;
	}
	return retVal;
}

/* 년월 날짜 검증
@param sDate yyyymm, ex) "201308" @return boolean
*/
function gfn_isYM(sDate){
	if (sDate.length != 6 || !isNumeric(sDate)) {
		return false;
	}
	
	var nYear  = toNumber(String(sDate).substr(0,4));
	var nMonth = toNumber(String(sDate).substr(4,2));
	
	if((nMonth < 1) || (nMonth > 12)) {
	    return false;
	}
	return true;
}

/* 년월일 날짜 검증
@type void @param sDate yyyyMMdd, ex) "20130801"
@return boolean /
function gfn_isYMD(sDate)
{
	if( gfn_isNull(sDate) ){
		return false;
	}
	
	if (sDate.length != 8 || !isNumeric(sDate)) {
	    return false;
	}
	
	var sYM = String(sDate).substr(0,6);    // yyyymm
	if (!gfn_isYM(sYM)) {
	    return false;
	}
	var nDay   = toNumber(String(sDate).substr(6,2));    // dd
	var nLastDay = gfn_getMonthLastDay(sYM);
	if (nDay < 1 || nDay > nLastDay) {
	    return false;
	}
	return true;
}

/* 해당일의 년주차 리턴
@param sDate yyyyMMdd, ex) "20130801" @return number
*/
function gfn_getWeekNo(sDate){

if(gfn_isYMD(sDate) == false) return -1;
	
	var objDate = new Date();
	//objDate.setYear(String(sDate).substr(0, 4));
	//objDate.setMonth(String(sDate).substr(4, 2) - 1);
	//objDate.setDate(String(sDate).substr(6, 2));
	objDate.setFullYear(parseInt(sDate.substr(0,4)), parseInt(sDate.substr(4,2))-1, parseInt(sDate.substr(6,2)));
	objDate.setHours(0, 0, 0);
	objDate.setMilliseconds(0);
	
	return objDate.getWeekNo();
}

/* 두 날짜 크기 비교
@param sFormDate yyyyMMdd ex) "20130801" @param sToDate yyyyMMdd ex) "20130830"
@return 1. The date is equal to two : return 0
2. sFormDate < sToDate : return -1 3. sFormDate > sToDate : return 1
4. Unless the date format : return null /
function gfn_compareDate(sFormDate, sToDate)
{
	var retVal = null;
	if (gfn_isDate(sFormDate) && gfn_isDate(sToDate)) {
		if (sFormDate == sToDate) {
			retVal = 0;
		} else if (sFormDate < sToDate) {
			retVal = -1;
		} else if (sFormDate > sToDate) {
			retVal = 1;
		}
	}
	return retVal;
}

/* 주어진 날짜의 Mask Format 처리된 문자열 리턴
@param sDate 'yyyyMMdd' @return String
*/
function gfn_dateFormatString(sDate, sFormat)
{
	if(typeof sDate === 'object'){
		sDate = sDate.toString();
	}
	var objDate = new Date();
	objDate.setFullYear(parseInt(sDate.substr(0,4)), parseInt(sDate.substr(4,2))-1, parseInt(sDate.substr(6,2)));
	objDate.setHours(0, 0, 0);
	objDate.setMilliseconds(0);
	return objDate.getFormatString(sFormat);
}

/* Grid Calendar open (주차표시 달력)
@param objGrid Grid object @param e Event Object
*/
function gfn_gridWkCalendar(obj:Grid, e)
{
	if(!isValidObject("_pdvWkCal")){
		var objPopupDiv = new PopupDiv("PopupDiv", 0, 0, 237, 195);
		this.addChild("_pdvWkCal", objPopupDiv);
	
	  objPopupDiv.url = "common::PdvWkCalendar.xfdl";
	  objPopupDiv.show();
	}
	
	_pdvWkCal.fn_crCal(); 
	
	try{
	    var _retVal = _pdvWkCal.trackPopup(toNumber(system.cursorx), toNumber(system.cursory));
	    var arrRet = _retVal.toString().split(",");
	
	    this.removeChild("_pdvWkCal"); 
	    return arrRet[0];
	}catch(e){return "";}
}

/* 주단의 선택 달력
*/
function gfn_weekSelectCalendar()
{
	if(!isValidObject("_pdvWeekSelectCal")){
			var objPopupDiv = new PopupDiv("PopupDiv", 0, 0, 237, 195);
			this.addChild("_pdvWeekSelectCal", objPopupDiv);
	
	    objPopupDiv.url = "common::PdvWeekSelectCalendar.xfdl";
	    objPopupDiv.show();
	}
	
	_pdvWeekSelectCal.fn_crCal(); 
	
	try{
	    var _retVal = _pdvWeekSelectCal.trackPopup(toNumber(system.cursorx), toNumber(system.cursory));
	    var arrRet = _retVal.toString().split(",");
	
	    this.removeChild("_pdvWeekSelectCal"); 
	    return arrRet[0];
	}catch(e){return "";}
}

//-----------------------------------------------------------------------------------------//

/* 주차계산함수 추가
*/
Date.prototype.getWeekNo = function(){
	// Create a copy of this date object
	var target = new Date(this.valueOf());
	// ISO week date weeks start on monday
	// so correct the day number
	var dayNr = (this.getDay() + 6) % 7;
	// ISO 8601 states that week 1 is the week
	// with the first thursday of that year.
	// Set the target date to the thursday in the target week
	target.setDate(target.getDate() - dayNr + 3);
	// Store the millisecond value of the target date
	var firstThursday = target.valueOf();
	// Set the target to the first thursday of the year
	// First set the target to january first
	target.setMonth(0, 1);
	// Not a thursday? Correct the date to the next thursday
	if(target.getDay() != 4) {
	target.setMonth(0, 1 + ((4 - target.getDay()) + 7) % 7);
	}
	// The weeknumber is the number of weeks between the
	// first thursday of the year and the thursday in the target week
	return 1 + Math.ceil((firstThursday - target) / 604800000);
}

/* 축약 월명칭 정의
*/
Date.prototype.monthShortName = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"];

/* Date format 함수
	*/
	Date.prototype.getFormatString = function(sFormat){
	if(!this.valueOf()) return "";
	var dt = this;
	
	var arrMask = dt.parseDateFormat(sFormat), arrDt = [], mask, h;
	
	for(var i = 0, len = arrMask.length; i < len; i++){
	    mask = arrMask[i];
	    if(mask > -1){
	        arrDt[arrDt.length] = sFormat.charAt(mask);
	    }else{
	        switch(mask){
	            case "yyyy": arrDt[arrDt.length] = dt.getFullYear(); break;
	            case "yy":      arrDt[arrDt.length] = new String(dt.getFullYear() % 1000).padLeft(2,'0'); break;
	            case "MM":      arrDt[arrDt.length] = new String(dt.getMonth() + 1).padLeft(2,'0'); break;
	            case "MMM":  arrDt[arrDt.length] = dt.monthShortName[dt.getMonth()]; break;
	            case "dd":      arrDt[arrDt.length] = new String(dt.getDate()).padLeft(2,'0'); break;
	            case "HH":      arrDt[arrDt.length] = new String(dt.getHours()).padLeft(2,'0'); break;
	            case "hh":      arrDt[arrDt.length] = new String(((h = dt.getHours() % 12) ? h : 12)).padLeft(2,'0'); break;
	            case "mm":      arrDt[arrDt.length] = new String(dt.getMinutes()).padLeft(2,'0'); break;
	            case "ss":      arrDt[arrDt.length] = new String(dt.getSeconds()).padLeft(2,'0'); break;
	            case "sss":  arrDt[arrDt.length] = new String(dt.getMilliseconds()).padLeft(3,'0'); break;
	            case "tt":      arrDt[arrDt.length] = dt.getHours() < 12 ? pThis.ttName[0] : pThis.ttName[1]; break;
	            case "M":      arrDt[arrDt.length] = new String(dt.getMonth() + 1); break;
	            case "d":      arrDt[arrDt.length] = new String(dt.getDate()); break;
	            case "H":      arrDt[arrDt.length] = new String(dt.getHours()); break;
	            case "h":      arrDt[arrDt.length] = new String(((h = dt.getHours() % 12) ? h : 12)); break;
	            case "m":      arrDt[arrDt.length] = new String(dt.getMinutes()); break;
	            case "s":      arrDt[arrDt.length] = new String(dt.getSeconds()); break;
	            case "W":    arrDt[arrDt.length] = new String(dt.getWeekNo()); break;
	        }
	    }
	}//for
	return arrDt.join("");
}

/* Date format Cache
*/
Date.prototype._dateMaskCache = {};

/* Date format 파싱
*/
Date.prototype.parseDateFormat = function(sMask){
	var dt = this;
	var res = dt._dateMaskCache[sMask];
	if(res) return res;
	
	var arrMask = [], tokenStr, seq = 0,
	    bEscape = false, bQuote = false,
	    maskArr = sMask.split(""),
	    sTmp;
	
	for(var i = 0, len = maskArr.length; i < len; ){
	    tokenStr = maskArr[i];
	
	    if(bEscape == false && tokenStr == "'"){ // Mask가 Quotation이 시작될 경우.
	        if(bQuote == false)
	            bQuote = true;
	        else
	            bQuote = false;
	        i++;
	        continue;
	    }
	    if(bEscape == false && tokenStr == "\\" && !bQuote){ // Mask에서 Escape에 진입할 경우.
	        bEscape = true;
	        i++;
	        continue;
	
	    }else if(bEscape){ // Mask에서 Escape를 사용할 경우.
	        arrMask[seq] = i;
	        seq++;
	        bEscape = false;
	
	    }else if(bQuote == false){// Mask에서 Quotation 밖의 글자에 대해.
	        sTmp = sMask.substr(i, 4);
	        if(sTmp == "yyyy" || sTmp == "MMMM" || sTmp == "dddd"){ //yyyy, MMMM, dddd
	            arrMask[seq] = sTmp;
	            i += 4;
	            seq++;
	            continue;
	        }
	        sTmp = sMask.substr(i, 3);
	        if(sTmp == "MMM" || sTmp == "ddd" || sTmp == "sss"){ //MMM, ddd, sss
	            arrMask[seq] = sTmp;
	            i += 3;
	            seq++;
	            continue;
	        }
	        sTmp = sMask.substr(i, 2);
	        if(sTmp == "yy" || sTmp == "MM" || sTmp == "dd" ||
	           sTmp == "HH" || sTmp == "mm" || sTmp == "ss" ||
	           sTmp == "hh" || sTmp == "tt" || sTmp == "tt" ) // yy, MM, dd, HH, mm , ss, tt, WW
	        {
	            arrMask[seq] = sTmp;
	            i += 2;
	            seq++;
	            continue;
	        }
	
	        if(tokenStr == "M" || tokenStr == "d" || tokenStr == "H" ||
	           tokenStr == "h" || tokenStr == "m" || tokenStr == "s" || tokenStr == "W" ) // M, d, H, h, m, s, W
	        {
	            arrMask[seq] = tokenStr;
	            seq++;
	        }else{
	            arrMask[seq] = i;
	            seq++;
	        }
	    }
	    i++;
	} //for
	
	dt._dateMaskCache[sMask] = arrMask;
	return arrMask;
}

/* Grid From Date, To Date 동시 선택 달력
*/
function gfn_gridFromToCalendar(pFromDate, pToDate)
{
	if(!isValidObject("_pdvWkCal")){
			var objPopupDiv = new PopupDiv("PopupDiv", 0, 0, 485, 235);
			this.addChild("_pdvWkCal", objPopupDiv);
	
	    objPopupDiv.url = "common::PdvPeriodCalendar.xfdl";
	    objPopupDiv.show();
	
	    if(!gfn_isNull(pFromDate)){
	        objPopupDiv.fv_msStDate = pFromDate;
	    }
	    if(!gfn_isNull(pToDate)){
	        objPopupDiv.fv_msEdDate = pToDate;
	    }
	}
	
	_pdvWkCal.fn_crCal(); 
	
	try{
	    var _retVal = _pdvWkCal.trackPopup(toNumber(system.cursorx), toNumber(system.cursory));
	    var arrRet = _retVal.toString().split(",");
	    //var arrRet = _retVal.toString();
	
	    this.removeChild("_pdvWkCal"); 
	    return arrRet;
	}catch(e){return "";}
}

저작자표시

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

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

Posted by 농부지기

이전 1 ··· 264 265 266 267 268 269 270 ··· 315 다음

농부지기

Nexacro - Grid관련 Javascript

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

Nexacro - Dateset 관련 Javascript

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

Nexacro - 날짜관련 Javascript

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

카테고리

태그목록

최근에 올라온 글

최근에 달린 댓글

최근에 받은 트랙백

글 보관함

달력

링크

티스토리툴바