'Nexacro-컴포넌트/JavaScript' 카테고리의 글 목록

'Nexacro-컴포넌트/JavaScript'에 해당되는 글 6건

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

Nexacro - 공통 (Common) 관련 Javascript

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

[ Nexacro - 공통 (Common) 관련 Javascript ]

/***************************************************************************************
 * System Name		:	SKU/common
 * Job Name 		:	Common
 * File Name 		:	xCommon.xfdl
 * Make Date 		:	2013.07.17
 *
 * Description  	:	공통 데이터 조회 사용 함수 모음
 *---------------------------------------------------------------------------------------
 * Modify Date     	Modifier  	Modify Description 
 *---------------------------------------------------------------------------------------
 * 
 *---------------------------------------------------------------------------------------
 ****************************************************************************************/

//=======================================================================================
// Common Lib Include
//--------------------------------------------------------------------------------------- 
include "lib::xTran.xjs";

/*****************************************************************************************
 * 함  수  명	: 	gfn_getDivision
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getDivision(objDs, sDefault)
{
	objDs.enableevent = false;
	objDs.clearData();

objDs.copyData(gds_division);
	if(objDs.getRowCount() == 1)
	{
		objDs.enableevent = true;
		objDs.setColumn(0, "chk","1");
	}
	else
	{
		if(sDefault == "A") 
		{
			var nRow = objDs.insertRow(0);
			objDs.setColumn(nRow, "code", 		"");
			objDs.setColumn(nRow, "cdname", 	"All");
			objDs.setColumn(nRow, "fname", 		"All");
		}
		else if(sDefault == "S") 
		{
			var nRow = objDs.insertRow(0);
			objDs.setColumn(nRow, "code", 		"");
			objDs.setColumn(nRow, "cdname", 	"Select");
			objDs.setColumn(nRow, "fname", 		"Select");
		}
		else if(sDefault == "N")
		{
			var nRow = objDs.insertRow(0);
			objDs.setColumn(nRow, "cdname", 	"");
			objDs.setColumn(nRow, "fname", 		"");
		}
		
		var sRow = objDs.findRow("code", gds_admUserInfo.getColumn(0, "divisionId"));
		
		if(sRow != -1)
		{
			objDs.setColumn(sRow, "chk", "1");
		}

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

/*****************************************************************************************
 * 함  수  명	: 	gfn_getDivision_server
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수( 로그인시 처음만 조회하고 화면에서는 복사하여 사용하게 처리
 *****************************************************************************************/
function gfn_getDivision_server(objDs, sDefault)
{
	objDs.enableevent = false;
	objDs.clearData();

var sArg = "soutDs="+objDs.name;
	
	var sSvcId 		 = "retrieveDivision"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveDivision.devx"; 
	var sInDs  		 = "";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
	    sArg 		 = sArg + " userGubun="+wrapQuote(gds_roleCom.getColumn(0, "division"));
	var sCallbackFnc = "";
		
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);

if(sDefault == "A") 
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "code", 		"");
		objDs.setColumn(nRow, "cdname", 	"All");
		objDs.setColumn(nRow, "fname", 		"All");
	}
	else if(sDefault == "S") 
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "code", 		"");
		objDs.setColumn(nRow, "cdname", 	"Select");
		objDs.setColumn(nRow, "fname", 		"Select");
	}
	else if(sDefault == "N")
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "cdname", 	"");
		objDs.setColumn(nRow, "fname", 		"");
	}
	objDs.enableevent = true;
	objDs.rowposition = -1;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getCompany
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	: 
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getCompany(objDs, sDefault)
{
	objDs.enableevent = false;

objDs.clearData();

var sArg = "soutDs="+objDs.name;
	
	var sSvcId 		 = "retrieveCompany"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveCompany.devx"; 
	var sInDs  		 = "";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
	    sArg 		 = sArg + " userGubun="+wrapQuote(gds_roleCom.getColumn(0, "division"));
	var sCallbackFnc = "";
		
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);

if(objDs.getRowCount() == 1)
	{
		objDs.enableevent = true;
		objDs.setColumn(0, "chk","1");
	}
	else
	{
		if(sDefault == "A") 
		{
			var nRow = objDs.insertRow(0);
			objDs.setColumn(nRow, "code", 		"");
			objDs.setColumn(nRow, "cdname", 	"All");
		}
		else if(sDefault == "S") 
		{
			var nRow = objDs.insertRow(0);
			objDs.setColumn(nRow, "code", 		"");
			objDs.setColumn(nRow, "cdname", 	"Select");
		}	
		else if(sDefault == "N")
		{
			var nRow = objDs.insertRow(0);
			objDs.setColumn(nRow, "cdname", 	"");
		}
	}	
	objDs.applyChange();
	objDs.enableevent = true;
	objDs.rowposition = -1;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getThisWeek
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getThisWeek(objDs)
{
	objDs.enableevent = false;

objDs.clearData();

var sArg = "soutDs="+objDs.name;
	
	var sSvcId 		 = "retrieveThisWeek"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveThisWeek.devx"; 
	var sInDs  		 = "";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
	    sArg 		 = sArg + " userGubun="+wrapQuote(gds_roleCom.getColumn(0, "division"));
	var sCallbackFnc = "";
		
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);

objDs.enableevent = true;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getLookupValues
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. sPCode 		: lookType 코드
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
					4. 
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getLookupValues(objDs, sPCode, sDefault)
{
	if(sPCode == null) 	sPCode 	= "ZXC";
	
	objDs.enableevent = false;

objDs.clearData();

var sArg = "soutDs="+objDs.name+ " lookType=" + sPCode;

var sSvcId 		 = "retrieveLookupValues"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveLookupValues.devx"; 
	var sInDs  		 = "";
	var sOutDs 		 = objDs.name+"="+objDs.name;

sArg 		 = sArg  + " userGubun="+wrapQuote(gds_roleCom.getColumn(0, "division"));

if(sPCode.trim().substr(0,10) != 'SUBSIDIARY')
	{
		sArg 		 = sArg + " ssGubun="+wrapQuote('Y');
	}
	else
	{
		sArg 		 = sArg  + " ssGubun="+wrapQuote(gds_roleCom.getColumn(0, "subsudiary"));
	}
	var sCallbackFnc = "";
			
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);

/*****************************************************************************************
 * 함  수  명	: 	gfn_getLookupList
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. sPCode 		: lookType 코드
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
					4. 
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getLookupList(objDs, sPCode, sDefault)
{
	if(sPCode == null) 	sPCode 	= "ZXC";
	
	if(isValidObject("cds_code")==false)
	{
		var strDsName="cds_code";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="gubun";
		var chkColum  ="chk";

if(isValidObject("dscopy")==false)
	{
		var strDsName="dscopy";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);
	}
	dscopy.clear();
	
	var clen = sPCode.length;
	
	var objArrds 	= new Array();
	var objArrcode 	= new Array();
	var objGubun 	= new Array();

objArrcode 	= sPCode.split(",");
	objArrds 	= objDs.split(",");
	if(gfn_isNull(sDefault) == false)
	{
		objGubun 	= sDefault.split(",");
	}
	
	var clen = objArrcode.length;
	
	for(var i=0; i < clen; i++)
	{
		var nRow = cds_code.addRow();
		cds_code.setColumn(nRow,	"code",		objArrcode[i]);
		cds_code.setColumn(nRow,	"dsname",	objArrds[i]);
		cds_code.setColumn(nRow,	"gubun",	objGubun[i]);
		cds_code.setColumn(nRow,	"chk",		"1");
	}
	
	gds_lookup.clearData();

var sArg = "";
	
	var sSvcId 		 = "retrieveLookupList"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveLookupList.devx";
	var sInDs  		 = "cds_code=cds_code";
	var sOutDs 		 = "gds_lookup=gds_lookup";

sArg 		 = sArg  + " userGubun="+wrapQuote(gds_roleCom.getColumn(0, "division"));
		sArg 		 = sArg  + " ssGubun="+wrapQuote(gds_roleCom.getColumn(0, "subsudiary"));
	
	var sCallbackFnc = "";
			
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);
	
	if(gds_lookup.getRowCount() != 0)
	{
		var cRow = cds_code.getRowCount();
		for(var i=0; i < cRow; i++)
		{
			var dsname = cds_code.getColumn(j,"dsname");
			eval(dsname).enableevent = false;
			eval(dsname).copyData(gds_lookup);
			dscopy.copyData(gds_lookup);
			eval(dsname).clearData();
			eval(dsname).enableevent = true;
		}
					
		var lRow = gds_lookup.getRowCount();
		var cRow = cds_code.getRowCount();
		for(var j=0; j < cRow; j++)
		{
			dscopy.clearData();
			for(var i=0; i < lRow; i++)
			{
				var dsName = cds_code.getColumn(j, "dsname");
				if(gds_lookup.getColumn(i,"lookupType") == cds_code.getColumn(j,"code"))
				{
					
					var nRow = dscopy.addRow();
					dscopy.copyRow(nRow,gds_lookup,i);
				}
			}
			eval(dsName).enableevent = false;
			eval(dsName).copyData(dscopy);
			eval(dsName).enableevent = true;
		}
	}
	
	var cRow = cds_code.getRowCount();
	for(var i=0; i < cRow; i++)
	{
		var sGubun = cds_code.getColumn(i,"gubun");
		var dsName = cds_code.getColumn(i,"dsname");
		eval(dsName).enableevent = false;
		if(sGubun == "A") 
		{
			var nRow = eval(dsName).insertRow(0);
			eval(dsName).setColumn(0, "code", 		"");
			eval(dsName).setColumn(0, "cdname", 	"ALL");
			eval(dsName).setColumn(0, "fname", 		"ALL");
		}
		else if(sGubun == "S") 
		{
			var nRow = eval(dsName).insertRow(0);
			eval(dsName).setColumn(0, "code", 		"");
			eval(dsName).setColumn(0, "cdname", 	"Select");
			eval(dsName).setColumn(0, "fname", 		"Select");
		}
		else if(sGubun == "N")
		{
			eval(dsName).insertRow(0);
			eval(dsName).setColumn(0, "cdname", 	"");
			eval(dsName).setColumn(0, "fname", 		"");
		}
		eval(dsName).applyChange();
		eval(dsName).enableevent = true;
		eval(dsName).rowposition = -1;
	}
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getAffiliateBranch
 * 입      력	: 	
					1. sParam		: 조회 조건들 ( XCM_AFFILIATE_BRANCH 의 테이블 칼럼.. _는 빼고 _뒤 첫글자는 대문자로 전송)
					2. objDs		: 데이터 받을 데이타셋
 * 반      환	:   
 * 기      능	: 	XCM_AFFILIATE_BRANCH 처리 내부함수
 *****************************************************************************************/
function gfn_getAffiliateBranch(objDs, sParam, sDefault)
{
	objDs.enableevent = false;

objDs.clearData();

/*****************************************************************************************
 * 함  수  명	: 	gfn_getCountry
 * 입      력	: 	
					1. sParam		: 조회 조건들 ( XCM_COUNTRY 의 테이블 칼럼.. _는 빼고 _뒤 첫글자는 대문자로 전송)
					2. objDs		: 데이터 받을 데이타셋
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	COUNTRY 처리 내부함수
 *****************************************************************************************/
function gfn_getCountry(objDs, sParam, sDefault)
{
	objDs.enableevent = false;

objDs.clearData();

/*****************************************************************************************
 * 함  수  명	: 	gfn_getCurrency
 * 입      력	: 	
					1. sParam		: 조회 조건들 ( XCM_CURRENCY 의 테이블 칼럼.. _는 빼고 _뒤 첫글자는 대문자로 전송)
					2. objDs		: 데이터 받을 데이타셋
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	CURRENCY 처리 내부함수
 *****************************************************************************************/
function gfn_getCurrency(objDs, sParam, sDefault)
{
	objDs.enableevent = false;

objDs.clearData();

/*****************************************************************************************
 * 함  수  명	: 	gfn_getFromToSiteTree
 * 입      력	: 	
					1. sParam		: [from, to] 로 보낸다
					2. objDs		: 데이터 받을 데이타셋
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	From, To Site 처리 내부함수
 *****************************************************************************************/
function gfn_getFromToSiteTree(objDs, sDefault, sParam)
{
	objDs.enableevent = false;
	
	objDs.clearData();

/*****************************************************************************************
 * 함  수  명	: 	gfn_getFromToSite
 * 입      력	: 	
					1. sParam		: [from, to] 로 보낸다
					2. objDs		: 데이터 받을 데이타셋
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	From, To Site 처리 내부함수
 *****************************************************************************************/
function gfn_getFromToSite(objDs, sDefault, sParam, inDivision)
{
	objDs.enableevent = false;
	
	if(isValidObject("mds_divisionmms")==false)
	{
		var strDsName="mds_divisionmms";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

objDataset.clear();
		objDataset.addColumn(chkColum,"STRING","255");
		objDataset.addColumn(codeColum,"STRING","255");
		objDataset.addColumn(dataColum,"STRING","255");
	}

mds_divisionmms.clearData();
	if(gfn_isNull(inDivision) == false)
	{
		mds_divisionmms.copyData(inDivision);
	}

objDs.clearData();

/*****************************************************************************************
 * 함  수  명	: 	gfn_getProductTree
 * 입      력	: 	
					1. sParam		: 
					2. objDs		: 데이터 받을 데이타셋
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	From, To Site 처리 내부함수
 *****************************************************************************************/
function gfn_getProductTree(objDs, sDefault, sParam)
{
	objDs.enableevent = false;

objDs.clearData();

/*****************************************************************************************
 * 함  수  명	: 	gfn_getModeling
 * 입      력	: 	
					1. sParam		: 
					2. objDs		: 데이터 받을 데이타셋
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	
 *****************************************************************************************/
function gfn_getModeling(objDs, sDefault, sParam)
{
	objDs.enableevent = false;

objDs.clearData();

/*****************************************************************************************
 * 함  수  명	: 	gfn_pl_addHandler
 * 입      력	: 	
					1. objedt		: edit 박스
					2. objList		: List 박스
					3. objbtn		: button
					4. objdspl      : pl 용 dataset
 * 반      환	:   filterstr ( 필터함수)
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
 var fn_objplList;
 var fn_objpledt;
 var fn_objplbtn;
 var fn_objplds;
function gfn_pl_addHandler(objpledt, objplList, objplbtn, objplds)
{
	fn_objplList 		= objplList;
	fn_objpledt 		= objpledt;
	fn_objplbtn			= objplbtn;
	fn_objplds			= objplds;

fn_objplList.position.left 	= div_cond.position.left + fn_objpledt.position.left;
	fn_objplList.position.top  	= div_cond.position.top  + fn_objpledt.position.top + 20;
	fn_objplList.position.width = fn_objpledt.position.width + 20;
	
	objpledt.inputtype = "normal";
	
	objplList.visible = false;
	objpledt.onkillfocus.addHandler(obj_pledt_onkillfocus);
	
	objpledt.onkeydown.addHandler(obj_pledt_onkeydown);
	
	objpledt.ontextchanged.addHandler(obj_pledt_ontextchanged);
	
	objplList.onkillfocus.addHandler(obj_pllst_onkillfocus);
	
	objplList.onitemclick.addHandler(obj_pllst_onitemclick);
	
	objplList.onkeydown.addHandler(obj_pllst_onkeydown);
	
	objplbtn.onclick.addHandler(obj_plbtn_onclick);
	
	objplbtn.onkeydown.addHandler(obj_plbtn_onkeydown);
	
	objplbtn.onkillfocus.addHandler(obj_plbtn_onkillfocus);
}

function obj_plbtn_onkeydown(obj:Button, e:KeyEventInfo)
{
	if(e.keycode == 27)
	{
		fn_objplList.visible = false;
	}	
}

function obj_pledt_onkillfocus(obj:Edit, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objplList.name)
	{
		fn_objplList.visible = false;
	}
}

function obj_plbtn_onkillfocus(obj:Button, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objplList.name && e.newcomponent.name != fn_objpledt.name)
	{
		fn_objplList.visible = false;
	}
}

function obj_pllst_onkillfocus(obj:ListBox, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objpledt.name)
	{
		fn_objplList.visible = false;
	}	
}

function obj_pllst_onitemclick(obj:ListBox, e:ListBoxClickEventInfo)
{
	fn_objpledt.value = e.itemtext;
	obj.visible = false;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getProductlevel
 * 입      력	: 	
					1. objDs		: 데이터 받을 데이타셋
					2. indivision   : division multi dataset
					3. sParam		: 
					4. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	
 *****************************************************************************************/
function gfn_getProductlevel(objDs, inDivision, sParam, sDefault)
{
	objDs.enableevent = false;

objDs.clearData();

if(isValidObject("mds_division")==false)
	{
		var strDsName="mds_division";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

objDataset.clear();
		objDataset.addColumn(chkColum,"STRING","255");
		objDataset.addColumn(codeColum,"STRING","255");
		objDataset.addColumn(dataColum,"STRING","255");
	}
	
	mds_division.clearData();
	if(gfn_isNull(inDivision) == false)
	{
		mds_division.copyData(inDivision);
	}
	
	var sArg = "soutDs="+objDs.name+ ' ' + sParam;
	
	var sSvcId 		 = "retrieveProductlevel"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveProductlevel.devx"; 
	var sInDs  		 = "mds_division=mds_division";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
	    sArg 		 = sArg;
	    sArg 		 = sArg + " divisionAll="	+wrapQuote(gds_roleCom.getColumn(0, "division"))
	                        + " subsidiaryAll="	+wrapQuote(gds_roleCom.getColumn(0, "subsudiary"));	    
	var sCallbackFnc = "";
	
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);
	
	if(sDefault == "A") 
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "chk", 		"0");
		objDs.setColumn(nRow, "code", 		"");		
		objDs.setColumn(nRow, "cdname", 	"All");
		objDs.setColumn(nRow, "fname", 		"All");
	}
	else if(sDefault == "S") 
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "chk", 		"0");
		objDs.setColumn(nRow, "code", 		"");
		objDs.setColumn(nRow, "cdname", 	"Select");
		objDs.setColumn(nRow, "fname", 		"Select");
	}
	else if(sDefault == "N")
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "chk", 		"0");
		objDs.setColumn(nRow, "cdname", 	"");
		objDs.setColumn(nRow, "fname", 		"");
	}
	objDs.applyChange();	
	objDs.enableevent = true;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getProdGroup
 * 입      력	: 	
					1. objDs		: 데이터 받을 데이타셋
					2. indivision   : division multi dataset
					3. sParam		: 
					4. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	
 *****************************************************************************************/
function gfn_getProdGroup(objDs, inDivision, sParam, sDefault)
{
	objDs.enableevent = false;

objDs.clearData();

if(isValidObject("mds_division")==false)
	{
		var strDsName="mds_division";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

objDataset.clear();
		objDataset.addColumn(chkColum,"STRING","255");
		objDataset.addColumn(codeColum,"STRING","255");
		objDataset.addColumn(dataColum,"STRING","255");
	}
	
	mds_division.clearData();
	if(gfn_isNull(inDivision) == false)
	{
		mds_division.copyData(inDivision);
	}
	
	var sArg = "soutDs="+objDs.name+ ' pgGroup=' + sParam;
	
	var sSvcId 		 = "retrieveProductGroup"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveProductGroup.devx"; 
	var sInDs  		 = "mds_division=mds_division";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
	    sArg 		 = sArg;
	    sArg 		 = sArg + " divisionAll="	+wrapQuote(gds_roleCom.getColumn(0, "division"))
	                        + " subsidiaryAll="	+wrapQuote(gds_roleCom.getColumn(0, "subsudiary"));	    
	var sCallbackFnc = "";
	
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);
	
	if(sDefault == "A") 
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "chk", 		"0");
		objDs.setColumn(nRow, "code", 		"");		
		objDs.setColumn(nRow, "cdname", 	"All");
	}
	else if(sDefault == "S") 
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "chk", 		"0");
		objDs.setColumn(nRow, "code", 		"");
		objDs.setColumn(nRow, "cdname", 	"Select");
	}
	else if(sDefault == "N")
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "chk", 		"0");
		objDs.setColumn(nRow, "cdname", 	"");
	}
	objDs.applyChange();	
	objDs.enableevent = true;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getDivisionSite
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
					3. sParam       : 조회조건
					4. indivision   : division multi dataset
					5. inSitegroup  : site group multi dataset
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getDivisionSite(objDs, sDefault, sParam, inDivision, inSitegroup)
{
	objDs.enableevent = false;
	objDs.clearData();
	if(isValidObject("mds_division")==false)
	{
		var strDsName="mds_division";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

if(isValidObject("mds_sitegroup")==false)
	{
		var strDsName="mds_sitegroup";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

if(sDefault == "A")
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "code", 		"");
		objDs.setColumn(nRow, "cdname", 	"All");
	}
	else if(sDefault == "S") 
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "code", 		"");
		objDs.setColumn(nRow, "cdname", 	"Select");
	}
	else if(sDefault == "N")
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "cdname", 	"");
	}
	objDs.applyChange();
	objDs.enableevent = true;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getMms  (Mapping Model Suffix)
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. indivision   : division multi dataset
					3. inSitegroup  : Sitegroup multi dataset
					4. sParam       : 조회조건
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getMms(objedt, objDs, objList, inDivision, inSitegroup,  sParam)
{
	objDs.enableevent = false;

//objDs.clearData();
	//if(isValidObject("mds_divisionmms")==false)
	if(isValidObject("ds_cboDivision")==false)
	{
		//var strDsName="mds_divisionmms";
		var strDsName="ds_cboDivision";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		//var dataColum ="name";
		var dataColum ="cdname";
		//var chkColum  ="chk";

//if(isValidObject("mds_sitegroupmms")==false)
	if(isValidObject("ds_cboSubsidiary")==false)
	{
		//var strDsName="mds_sitegroupmms";
		var strDsName="ds_cboSubsidiary";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		//var dataColum ="name";
		var dataColum ="cdname";
		//var chkColum  ="chk";

//objDataset.clear();
		//objDataset.addColumn(chkColum,"STRING","255");
		objDataset.addColumn(codeColum,"STRING","255");
		objDataset.addColumn(dataColum,"STRING","255");
	}
	
	//mds_sitegroupmms.clearData();
	//ds_cboSubsidiary.clearData();
	
	if(gfn_isNull(inSitegroup) == false)
	{
		//mds_sitegroupmms.copyData(inSitegroup);
		ds_cboSubsidiary.copyData(inSitegroup);
	}
	
	var sArg = "soutDs=" + objDs.name + " " + sParam;
	
	/*
	var sSvcId 		 = "retrieveDivisionMms"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveDivisionMms.devx"; 
	var sInDs  		 = "mds_divisionmms=mds_divisionmms mds_sitegroupmms=mds_sitegroupmms";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
	    sArg 		 = sArg + " divisionAll="	+wrapQuote(gds_roleCom.getColumn(0, "division"))
	                        + " subsidiaryAll="	+wrapQuote(gds_roleCom.getColumn(0, "subsudiary"));
	*/
	
	// EOL Date Mgmt 화면에서 Mapping Model Suffix 조회를 위해 공통 함수 사용 
	var sSvcId 		 = "retrieveCboModel"; 
	var sUrl   		 = "appr/appr070fNavi/retrieveCboModel.devx"; 		
	var sInDs  		 = "ds_cboDivision=ds_cboDivision ds_cboSubsidiary=ds_cboSubsidiary";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
	    sArg 		 = sArg + " divisionCode="	+wrapQuote(gfn_nullVal(div_cond.cbo_division.value,	""))
	                        + " subsidiaryName="	+wrapQuote(gfn_nullVal(div_cond.cbo_subsidiary.value,	""));
	                        
	trace(sArg);
	
	var sCallbackFnc = "";
		
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);
	
	if(objDs.rowcount < toNumber(gds_ini.getColumn(0, "cboRowCount")))
	{
		objList.position2.height = (objDs.rowcount) * 18 + 5;
	}
	else
	{
		objList.position2.height = gds_ini.getColumn(0,"cboRowCount") * 18 + 7;
	}
	
	if(objDs.rowcount == 0)
	{
		objList.visible = false;
	}
	else
	{
		objList.visible = true;
	}
	
	objDs.enableevent = true;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_mms_addHandler
 * 입      력	: 	
					1. objedt		: edit 박스
					2. objList		: List 박스
					3. objbtn		: button
					4. objdivision  : 조회용 division
					5. objdsmms     : mms 용 dataset
 * 반      환	:   filterstr ( 필터함수)
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
 var fn_objList;
 var fn_objedt;
 var fn_objbtn;
 var fn_objdivision;
 var fn_objdsmms;
 var fn_wfchk;
function gfn_mms_addHandler(objedt, objList, objbtn, objdivision, objdsmms)
{
	fn_objList 		= objList;
	fn_objedt 		= objedt;
	fn_objbtn		= objbtn;
	fn_objdivision 	= objdivision;
	fn_objdsmms		= objdsmms;
	
	fn_objList.position.left 	= div_cond.position.left + objedt.position.left;
	fn_objList.position.top  	= div_cond.position.top  + objedt.position.top + 20;
	fn_objList.position.width  	= objedt.position.width + 20;
//	fn_objList.position.width  	= objedt.position.width;
	
	objedt.inputmode = "upper";
	objedt.inputtype = "numberandenglish,dot,sign,symbol,space";
	objList.visible = false;
	
	objedt.onkeydown.addHandler(obj_edt_onkeydown);
	
	objedt.onkillfocus.addHandler(obj_edt_onkillfocus);
	
	objedt.ontextchanged.addHandler(obj_edt_ontextchanged);
	
	objList.onkillfocus.addHandler(obj_lst_onkillfocus);
	
	objList.onitemclick.addHandler(obj_lst_onitemclick);
	
	objList.onkeydown.addHandler(obj_lst_onkeydown);
	
	objbtn.onclick.addHandler(obj_btn_onclick);
	
	objbtn.onkeydown.addHandler(obj_btn_onkeydown);
	
	objbtn.onkillfocus.addHandler(obj_btn_onkillfocus);
}

function obj_btn_onkeydown(obj:Button, e:KeyEventInfo)
{
	if(e.keycode == 27)
	{
		fn_objList.visible = false;
	}	
}

function obj_btn_onclick(obj:Button,  e:ClickEventInfo)
{
	fn_objList.position.left 	= div_cond.position.left + fn_objedt.position.left;
	fn_objList.position.top  	= div_cond.position.top  + fn_objedt.position.top + 20;
	fn_objList.position.width  	= fn_objedt.position.width  + 20;
		
	if(gfn_isNull(fn_objedt.value) == true) 
	{
		fn_objList.visible = false;
		gfn_alert("requisite.minlength","Input", "2");
		return;
	}
	if(fn_objedt.value.length >= 2)
	{

fn_objdsmms.filter("");
		
		//gfn_getMms(fn_objedt, fn_objdsmms, fn_objList, fn_objdivision, "", "itemName="+wrapQuote(fn_objedt.value.toUpperCase().substr(0,4)));
		gfn_getMms(fn_objedt, fn_objdsmms, fn_objList, "", "", "mappingModelSuffix="+wrapQuote(fn_objedt.value.toUpperCase().substr(0,4)));
		
		if(fn_objdsmms.rowcount > 0)
		{
			fn_objList.visible = false;
			var sfilterStr = "";
			
			if(gfn_isNull(fn_objedt.value) == false)
			{
				sfilterStr = "cdname.toString().toUpperCase().indexOf('"+fn_objedt.value.trim().toUpperCase() + "') >= 0";
			}
			fn_objdsmms.filter(sfilterStr);
			
			if(fn_objdsmms.getRowCount() < toNumber(gds_ini.getColumn(0, "cboRowCount")))
			{
				fn_objList.position2.height = (fn_objdsmms.getRowCount()) * 18 + 5;
			}
			else
			{
				fn_objList.position2.height = gds_ini.getColumn(0,"cboRowCount") * 18 + 7;
			}
			
			if(fn_objdsmms.getRowCount() > 0)
			{
				fn_objList.visible = true;
			}
		}
	}
	else
	{
		fn_objList.visible = false;
		gfn_alert("requisite.minlength", "Input", "2");
	}	
}

function obj_edt_onkillfocus(obj:Edit, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objList.name)
	{
		fn_objList.visible = false;
	}
}

function obj_btn_onkillfocus(obj:Button, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objList.name && e.newcomponent.name != fn_objedt.name)
	{
		fn_objList.visible = false;
	}
}

function obj_lst_onkillfocus(obj:ListBox, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objedt.name)
	{
		fn_objList.visible = false;
	}
}

function obj_lst_onitemclick(obj:ListBox, e:ListBoxClickEventInfo)
{
	fn_objedt.value = e.itemtext;
	obj.visible = false;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getPms  (Prod Model Suffix)
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. indivision   : division multi dataset
					3. insubsidiary : subsidiary multi dataset
					4. sParam       : 조회조건
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getPms(objedt, objDs, objList, inDivision, insubsidiary,  sParam)
{
	objDs.enableevent = false;

objDs.clearData();
	if(isValidObject("mds_divisionpms")==false)
	{
		var strDsName="mds_divisionpms";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

if(isValidObject("mds_subsidiarypms")==false)
	{
		var strDsName="mds_subsidiarypms";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

objDataset.clear();
		objDataset.addColumn(chkColum,"STRING","255");
		objDataset.addColumn(codeColum,"STRING","255");
		objDataset.addColumn(dataColum,"STRING","255");
	}
	
	mds_subsidiarypms.clearData();
	if(gfn_isNull(insubsidiary) == false)
	{
		mds_subsidiarypms.copyData(insubsidiary);
	}
	
	var sArg = "soutDs=" + objDs.name + " " + sParam;
	
	var sSvcId 		 = "retrieveDivisionPms"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveDivisionPms.devx"; 
	var sInDs  		 = "mds_divisionpms=mds_divisionpms mds_subsidiarypms=mds_subsidiarypms";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
	    sArg 		 = sArg + " divisionAll="	+wrapQuote(gds_roleCom.getColumn(0, "division"))
	                        + " subsidiaryAll="	+wrapQuote(gds_roleCom.getColumn(0, "subsudiary"));
	var sCallbackFnc = "";
		
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);
	
	if(objDs.rowcount < toNumber(gds_ini.getColumn(0, "cboRowCount")))
	{
		objList.position2.height = (objDs.rowcount) * 18 + 5;
	}
	else
	{
		objList.position2.height = gds_ini.getColumn(0,"cboRowCount") * 18 + 7;
	}
	
	if(objDs.rowcount == 0)
	{
		objList.visible = false;
	}
	else
	{
		objList.visible = true;
	}
	
	objDs.enableevent = true;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_pms_addHandler
 * 입      력	: 	
					1. objedt		: edit 박스
					2. objList		: List 박스
					3. objbtn		: button
					4. objdivision  : 조회용 division
					5. objsubsidiary  : 조회용 division
					6. objdsmms     : pms 용 dataset
 * 반      환	:   filterstr ( 필터함수)
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
 var fn_objListpms;
 var fn_objedtpms;
 var fn_objbtnpms;
 var fn_objdivisionpms;
 var fn_objsubsidiarypms;
 var fn_objdspms;
function gfn_pms_addHandler(objedt, objList, objbtn, objdivision, objsubsidiary, objdspms)
{
	fn_objListpms 		= objList;
	fn_objedtpms 		= objedt;
	fn_objbtnpms		= objbtn;
	fn_objdivisionpms 	= objdivision;
	fn_objdspms			= objdspms;
	fn_objsubsidiarypms = objsubsidiary;
	
	objedt.inputmode = "upper";
	objedt.inputtype = "numberandenglish,symbol,space";
		
	fn_objListpms.position.left 	= div_cond.position.left + fn_objedtpms.position.left;
	fn_objListpms.position.top  	= div_cond.position.top  + fn_objedtpms.position.top + 20;
	fn_objListpms.position.width  	= fn_objedtpms.position.width + 20;
		
	objList.visible = false;
	objedt.onkillfocus.addHandler(obj_edtpms_onkillfocus);
	
	objedt.onkeydown.addHandler(obj_edtpms_onkeydown);
	
	objedt.ontextchanged.addHandler(obj_edtpms_ontextchanged);
	
	objList.onkillfocus.addHandler(obj_lstpms_onkillfocus);
	
	objList.onitemclick.addHandler(obj_lstpms_onitemclick);
	
	objList.onkeydown.addHandler(obj_lstpms_onkeydown);
	
	objbtn.onclick.addHandler(obj_btnpms_onclick);
	
	objbtn.onkeydown.addHandler(obj_btnpms_onkeydown);
	
	objbtn.onkillfocus.addHandler(obj_btnpms_onkillfocus);
}

function obj_btnpms_onkeydown(obj:Button, e:KeyEventInfo)
{
	if(e.keycode == 27)
	{
		fn_objListpms.visible = false;
	}	
}

function obj_btnpms_onclick(obj:Button,  e:ClickEventInfo)
{
	fn_objListpms.position.left 	= div_cond.position.left + fn_objedtpms.position.left;
	fn_objListpms.position.top  	= div_cond.position.top  + fn_objedtpms.position.top + 20;
	fn_objListpms.position.width  	= fn_objedtpms.position.width + 20;

if(gfn_isNull(fn_objedtpms.value) == true)
	{
		fn_objListpms.visible = false;
		gfn_alert("requisite.minlength", "Input", "2");
		return;
	}
	if(fn_objedtpms.value.length >= 2)
	{
		fn_objdspms.filter("");
		
		gfn_getPms(fn_objedtpms, fn_objdspms, fn_objListpms, fn_objdivisionpms, fn_objsubsidiarypms, "salsemodelcode="+wrapQuote(fn_objedtpms.value.toUpperCase().substr(0,4)));
		
		if(fn_objdspms.rowcount > 0)
		{
			fn_objListpms.visible = false;
			var sfilterStr = "";
			
			if(gfn_isNull(fn_objedtpms.value) == false)
			{
				sfilterStr = "cdname.toString().toUpperCase().indexOf('"+fn_objedtpms.value.trim().toUpperCase() + "') >= 0";
			}
			fn_objdspms.filter(sfilterStr);
			
			if(fn_objdspms.getRowCount() < toNumber(gds_ini.getColumn(0, "cboRowCount")))
			{
				fn_objListpms.position2.height = (fn_objdspms.getRowCount()) * 18 + 5;
			}
			else
			{
				fn_objListpms.position2.height = gds_ini.getColumn(0,"cboRowCount") * 18 + 7;
			}
			
			if(fn_objdspms.getRowCount() > 0)
			{
				fn_objListpms.visible = true;
			}			
		}
	}
	else
	{
		fn_objListpms.visible = false;
		gfn_alert("requisite.minlength", "Input", "2");
	}	
}

function obj_edtpms_onkillfocus(obj:Edit, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objListpms.name)
	{
		fn_objListpms.visible = false;
	}
}

function obj_btnpms_onkillfocus(obj:Button, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objListpms.name && e.newcomponent.name != fn_objedtpms.name)
	{
		fn_objListpms.visible = false;
	}
}

function obj_lstpms_onkillfocus(obj:ListBox, e:KillFocusEventInfo)
{
//	obj.visible = false;
	if(e.newcomponent.name != fn_objedtpms.name)
	{
		fn_objListpms.visible = false;
	}	
}

function obj_lstpms_onitemclick(obj:ListBox, e:ListBoxClickEventInfo)
{
	fn_objedtpms.value = e.itemtext;
	obj.visible = false;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getDivisionPlanWeek
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. inDivision   : division multi dataset
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getDivisionPlanWeek(objDs, inDivision, sDefault, sSeq)
{
	objDs.enableevent = false;
	objDs.clearData();
	if(isValidObject("mds_division")==false)
	{
		var strDsName="mds_division";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

var sArg = "soutDs=" + objDs.name;
	
	if(gfn_isNull(sSeq) != false)
	{
		var sSvcId 		 = "retrieveDivisionPlanWeek"; 
		var sUrl   		 = "comm/libcommonNavi/retrieveDivisionPlanWeek.devx"; 
	}
	else
	{
		var sSvcId 		 = "retrievePlanWeekNoseq"; 
		var sUrl   		 = "comm/libcommonNavi/retrievePlanWeekNoseq.devx"; 
	}
		
	var sInDs  		 = "mds_division=mds_division";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
		sArg 		 = sArg + " divisionAll="	+wrapQuote(gds_roleCom.getColumn(0, "division"))
							+ " subsidiaryAll="	+wrapQuote(gds_roleCom.getColumn(0, "subsudiary"));
	var sCallbackFnc = "";
	
	
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);

/*****************************************************************************************
 * 함  수  명	: 	gfn_getDivisionPlanWeekSeq
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. inDivision   : division multi dataset
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getDivisionPlanWeekSeq(objDs, inDivision, sParam, sDefault)
{
	objDs.enableevent = false;
	objDs.clearData();
	if(isValidObject("mds_division")==false)
	{
		var strDsName="mds_division";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

var sSvcId 		 = "retrieveDivisionPlanWeekSeq"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveDivisionPlanWeekSeq.devx";
	if(mds_division.getCaseCount("chk == '1'") != 1)
	{
//		gfn_getLookupValues(objDs, 	"PLAN_TYPE");
//		var arow = objDs.findRow("code","IN");
//		objDs.deleteRow(arow);
		sSvcId 		 = "retrieveDivisionPlanWeekSeqmulti"; 
		sUrl   		 = "comm/libcommonNavi/retrieveDivisionPlanWeekSeqmulti.devx"; 
	}
	else
	{
		sSvcId 		 = "retrieveDivisionPlanWeekSeq";
		 sUrl   	 = "comm/libcommonNavi/retrieveDivisionPlanWeekSeq.devx";
	}
		
	var sArg = "soutDs=" + objDs.name+ " " + sParam;
	
//	var sSvcId 		 = "retrieveDivisionPlanWeekSeq"; 
	
	var sInDs  		 = "mds_division=mds_division";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
		sArg 		 = sArg + " divisionAll="	+wrapQuote(gds_roleCom.getColumn(0, "division"))
							+ " subsidiaryAll="	+wrapQuote(gds_roleCom.getColumn(0, "subsudiary"));
	var sCallbackFnc = "";
		
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);

/*****************************************************************************************
 * 함  수  명	: 	gfn_getWeekly
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. sGubun
					3. sDate
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getWeekly(objDs, sGubun, sDate, sDefault)
{
	objDs.enableevent = false;
	objDs.clearData();
	
	var sArg = "soutDs=" + objDs.name;
	var ss   = '';
	if(sGubun == 'W')
	{
		ss = 'WEEKLY';
	}
	else if(sGubun == 'P')
	{
		ss = 'PARTIAL';
	}
	
	var sSvcId 		 = "retrieveWeeklyInfo"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveWeeklyInfo.devx"; 
	var sInDs  		 = "";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
		sArg 		 = sArg + " weekGubun="		+wrapQuote(ss)
							+ " searchdate="	+wrapQuote(sDate);
	var sCallbackFnc = "";
		
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);
	
	if(sDefault == "A")
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "code", 		"");
		objDs.setColumn(nRow, "cdname", 	"All");
		objDs.setColumn(nRow, "fname", 		"All");
	}
	else if(sDefault == "S") 
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "code", 		"");
		objDs.setColumn(nRow, "cdname", 	"Select");
		objDs.setColumn(nRow, "fname", 		"Select");
	}
	else if(sDefault == "N")
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "cdname", 	"");
	}
	objDs.applyChange();
	objDs.enableevent = true;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getFromWeekly
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. sGubun
					3. sDate
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getFromWeekly(objDs, sGubun, sDate, sCnt, sDefault)
{
	objDs.enableevent = false;
	objDs.clearData();
	
	var sArg = "soutDs=" + objDs.name;
	var ss   = '';
	if(sGubun == 'W')
	{
		ss = 'WEEKLY';
	}
	else if(sGubun == 'P')
	{
		ss = 'PARTIAL';
	}
	
	var sSvcId 		 = "retrieveFromWeeklyInfo"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveFromWeeklyInfo.devx"; 
	var sInDs  		 = "";
	var sOutDs 		 = objDs.name+"="+objDs.name; 
		sArg 		 = sArg + " weekGubun="		+wrapQuote(ss)
							+ " searchdate="	+wrapQuote(sDate)
							+ " fromWeekCnt="	+wrapQuote(sCnt);
	var sCallbackFnc = "";
		
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);
	
	if(sDefault == "A")
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "code", 		"");
		objDs.setColumn(nRow, "cdname", 	"All");
		objDs.setColumn(nRow, "fname", 		"All");
	}
	else if(sDefault == "S") 
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "code", 		"");
		objDs.setColumn(nRow, "cdname", 	"Select");
		objDs.setColumn(nRow, "fname", 		"Select");
	}
	else if(sDefault == "N")
	{
		var nRow = objDs.insertRow(0);
		objDs.setColumn(nRow, "cdname", 	"");
	}
	objDs.applyChange();
	objDs.enableevent = true;
}

/*****************************************************************************************
 * 함  수  명	: 	gfm_companyfilter
 * 입      력	: 	
					1. objDs		: 필터링할 대상 데이타셋
 * 반      환	:   filterstr ( 필터함수)
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_companyfilter(objds)
{
	var nRow = objds.getRowCount();
	var filterstr = "";
	var countchk  = 0;
	for(var i=0; i < nRow; i++)
	{
		if(objds.getColumn(i, "chk") == "1")
		{
			countchk++;
			if(countchk == 1)
			{
				filterstr +=  "companyCode == " + wrapQuote(objds.getColumn(i, "code"));
			}
			else
			{
				filterstr +=  " || companyCode == " + wrapQuote(objds.getColumn(i, "code"));
			}
		}
	}
	return filterstr;
}

/*****************************************************************************************
 * 함  수  명	: 	gfm_companyfilter
 * 입      력	: 	
					1. objDs		: 필터링할 대상 데이타셋
 * 반      환	:   filterstr ( 필터함수)
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_sitefilter(objds, objedt,objlst)
{
	fn_objlistsite.position.left 	= div_cond.position.left + fn_objedtsite.position.left;
	fn_objlistsite.position.top  	= div_cond.position.top  + fn_objedtsite.position.top + 20;
	fn_objlistsite.position.width  	= fn_objedtsite.position.width + 20;
	
	if(gfn_isNull(fn_filteryn) == true)
	{
		var filterstr = '';	
		if(gfn_isNull(objedt.value) == false)
		{
			filterstr = "cdname.toString().toUpperCase().indexOf('"+objedt.value.trim() + "') >= 0";
		}

objds.filter(filterstr);
	}	
	if(objds.rowcount < toNumber(gds_ini.getColumn(0, "cboRowCount")))
	{
		objlst.position2.height = (objds.rowcount) * 18 + 5;
	}
	else
	{
		objlst.position2.height = gds_ini.getColumn(0,"cboRowCount") * 18 + 7;
	}
	objlst.visible	= true;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_site_addHandler
 * 입      력	: 	
					1. objedt		: edit 박스
					2. objList		: List 박스
					3. objbtn		: button
					4. objds        : site dataset
 * 반      환	:   filterstr ( 필터함수)
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
 var fn_objlistsite;
 var fn_objedtsite;
 var fn_objbtnsite;
 var fn_objdssite;
 var fn_divisite;
 var fn_grsite;
 var fn_filteryn;
function gfn_site_addHandler(objedt, objList, objbtn, objds, objdivision, objsitegroup, filteryn)
{
	fn_objlistsite 		= objList;
	fn_objedtsite 		= objedt;
	fn_objbtnsite		= objbtn;
	fn_objdssite		= objds;
	fn_divisite			= objdivision;
	fn_grsite			= objsitegroup;
	fn_filteryn			= filteryn;
	objList.visible 	= false;
	
	fn_objlistsite.position.left 	= div_cond.position.left + fn_objedtsite.position.left;
	fn_objlistsite.position.top  	= div_cond.position.top  + fn_objedtsite.position.top + 20;
	fn_objlistsite.position.width  	= fn_objedtsite.position.width + 20;
	
	objedt.onkeydown.addHandler(obj_edtsite_onkeydown);
	
	objList.onkillfocus.addHandler(obj_lstsite_onkillfocus);
	
	objList.onitemclick.addHandler(obj_lstsite_onitemclick);
	
	objbtn.onclick.addHandler(obj_btnsite_onclick);
	
	objbtn.onkeydown.addHandler(obj_btnsite_onkeydown);
	
	objbtn.onkillfocus.addHandler(obj_btnsite_onkillfocus);
}

function obj_btnsite_onkeydown(obj:Button, e:KeyEventInfo)
{
	if(e.keycode == 27)
	{
		fn_objlistsite.visible = false;
	}	
}

function obj_edtsite_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 27)
	{
		fn_objlistsite.visible = false;
	}
}

function obj_btnsite_onclick(obj:Button,  e:ClickEventInfo)
{
	gfn_sitefilter(fn_objdssite, fn_objedtsite,fn_objlistsite);
}

function obj_edtsite_onkillfocus(obj:Edit, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objlistsite.name)
	{
		fn_objlistsite.visible = false;
	}
}

function obj_btnsite_onkillfocus(obj:Button, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objlistsite.name && e.newcomponent.name != fn_objedtsite.name)
	{
		fn_objlistsite.visible = false;
	}
}

function obj_lstsite_onkillfocus(obj:ListBox, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objedtsite.name)
	{
		fn_objlistsite.visible = false;
	}
}

function obj_lstsite_onitemclick(obj:ListBox, e:ListBoxClickEventInfo)
{
	fn_objedtsite.value = e.itemtext;
	obj.visible = false;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_site_addHandler_1
 * 입      력	: 	
					1. objedt		: edit 박스
					2. objList		: List 박스
					3. objbtn		: button
					4. objds        : site dataset
 * 반      환	:   filterstr ( 필터함수)
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
 var fn_objlistsite1;
 var fn_objedtsite1;
 var fn_objbtnsite1;
 var fn_objdssite1;
function gfn_site_addHandler_1(objedt, objList, objbtn, objds)
{
	fn_objlistsite1 	= objList;
	fn_objedtsite1 		= objedt;
	fn_objbtnsite1		= objbtn;
	fn_objdssite1		= objds;
	
	fn_objlistsite1.position.left 	= div_cond.position.left + fn_objedtsite1.position.left;
	fn_objlistsite1.position.top  	= div_cond.position.top  + fn_objedtsite1.position.top + 20;
	fn_objlistsite1.position.width 	= fn_objedtsite1.position.width + 20;
		
	objList.visible = false;
	objedt.onkeydown.addHandler(obj_edtsite1_onkeydown);
	
	objList.onkillfocus.addHandler(obj_lstsite1_onkillfocus);
	
	objList.onitemclick.addHandler(obj_lstsite1_onitemclick);
	
	objbtn.onclick.addHandler(obj_btnsite1_onclick);
	
	objbtn.onkeydown.addHandler(obj_btnsite1_onkeydown);
	
	objbtn.onkillfocus.addHandler(obj_btnsite1_onkillfocus);
}

function obj_btnsite1_onkeydown(obj:Button, e:KeyEventInfo)
{
	if(e.keycode == 27)
	{
		fn_objlistsite1.visible = false;
	}	
}

function obj_edtsite1_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 27)
	{
		fn_objlistsite1.visible = false;
	}
}

function obj_btnsite1_onclick(obj:Button,  e:ClickEventInfo)
{
	gfn_sitefilter(fn_objdssite1, fn_objedtsite1,fn_objlistsite1);
}

function obj_edtsite1_onkillfocus(obj:Edit, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objlistsite1.name)
	{
		fn_objlistsite1.visible = false;
	}
}

function obj_btnsite1_onkillfocus(obj:Button, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objlistsite1.name && e.newcomponent.name != fn_objedtsite1.name)
	{
		fn_objlistsite1.visible = false;
	}
}

function obj_lstsite1_onkillfocus(obj:ListBox, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_objedtsite1.name)
	{
		fn_objlistsite1.visible = false;
	}
}

function obj_lstsite1_onitemclick(obj:ListBox, e:ListBoxClickEventInfo)
{
	fn_objedtsite1.value = e.itemtext;
	obj.visible = false;
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getPart  (Part No)
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. indivision   : division multi dataset
					3. sParam       : 조회조건
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getPart(objedt, objDs, objList, inDivision, sParam)
{
    objDs.enableevent = false;

objDs.clearData();
	if(isValidObject("mds_divisionmms")==false)
	{
		var strDsName="mds_divisionmms";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

/*****************************************************************************************
 * 함  수  명	: 	gfn_part_addHandler
 * 입      력	: 	
					1. objedt		: edit 박스
					2. objList		: List 박스
					3. objbtn		: button
					4. objdivision  : 조회용 division
					5. objdsmms     : mms 용 dataset
 * 반      환	:   filterstr ( 필터함수)
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
 var fn_partobjList;
 var fn_partobjedt;
 var fn_partobjbtn;
 var fn_partobjdivision;
 var fn_partobjds;
 function gfn_part_addHandler(objedt, objList, objbtn, objdivision, objds)
{
	fn_partobjList 		= objList;
	fn_partobjedt 		= objedt;
	fn_partobjbtn		= objbtn;
	fn_partobjdivision 	= objdivision;
	fn_partobjds		= objds;
	
	fn_partobjList.position.left 	= div_cond.position.left + fn_partobjedt.position.left;
	fn_partobjList.position.top  	= div_cond.position.top  + fn_partobjedt.position.top + 20;
	fn_partobjList.position.width   = fn_partobjedt.position.width + 20;
		
	objedt.inputmode = "upper";
	objedt.inputtype = "numberandenglish,symbol,space";
	objList.visible = false;
	
	objedt.onkeydown.addHandler(obj_partedt_onkeydown);
	
	objedt.onkillfocus.addHandler(obj_partedt_onkillfocus);
	
	objedt.ontextchanged.addHandler(obj_partedt_ontextchanged);
	
	objList.onkillfocus.addHandler(obj_partlst_onkillfocus);
	
	objList.onitemclick.addHandler(obj_partlst_onitemclick);
	
	objList.onkeydown.addHandler(obj_partlst_onkeydown);
	
	objbtn.onclick.addHandler(obj_partbtn_onclick);
	
	objbtn.onkeydown.addHandler(obj_partbtn_onkeydown);
	
	objbtn.onkillfocus.addHandler(obj_partbtn_onkillfocus);
}

function obj_partbtn_onkeydown(obj:Button, e:KeyEventInfo)
{
	if(e.keycode == 27)
	{
		fn_partobjList.visible = false;
	}	
}

function obj_partedt_onkillfocus(obj:Edit, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_partobjList.name)
	{
		fn_partobjList.visible = false;
	}
}

function obj_partbtn_onkillfocus(obj:Button, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_partobjList.name && e.newcomponent.name != fn_partobjedt.name)
	{
		fn_partobjList.visible = false;
	}
}

function obj_partlst_onkillfocus(obj:ListBox, e:KillFocusEventInfo)
{
	if(e.newcomponent.name != fn_partobjedt.name)
	{
		fn_partobjList.visible = false;
	}
}

function obj_partlst_onitemclick(obj:ListBox, e:ListBoxClickEventInfo)
{
	fn_partobjedt.value = e.itemtext;
	obj.visible = false;
}

function gfn_Timecheck(nStart, sEndTime)
{
	if(gfn_isNull(sEndTime) == false)
	{
		var sTranId = "retrieveStartendtime"; 
		var sUrl   	= "comm/libcommonNavi/retrieveStartendtime.devx";

var sArg = "sTime="+wrapQuote(nStart)+" eTime="+wrapQuote(sEndTime);

gfn_transaction(sTranId, sUrl, "", "gds_params=gds_param", sArg, "", false, false);
		
		var st = nStart.substr(8,2)+':'+nStart.substr(10,2)+':'+nStart.substr(12,2);
		var et = sEndTime.substr(8,2)+':'+sEndTime.substr(10,2)+':'+sEndTime.substr(12,2);
		ap_BottomFrame.form.stc_TimeInfo.text = '[ Start - '+st +' ~ End - ' + et + " ("+gds_params.getColumn(0, "stime")+") ]";
		ap_BottomFrame.form.stc_TimeGubun.text = '';
	}
	else
	{
		var st = nStart.substr(8,2)+':'+nStart.substr(10,2)+':'+nStart.substr(12,2);
		ap_BottomFrame.form.stc_TimeInfo.text = '[ Start - '+st +' ~  processing .. ]';
		ap_BottomFrame.form.stc_TimeGubun.text = 'T';
	}
}

//2014.05.20 신현철 From, To Site Bod Valid Y 인 Site List
/*****************************************************************************************
 * 함  수  명	: 	gfn_getDivisionFromToSite
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
function gfn_getDivisionFromToSite(objDs, sDefault, sParam, inDivision, inSitegroup) {
	objDs.enableevent = false;
	objDs.clearData();
	if(isValidObject("mds_division")==false)
	{
		var strDsName="mds_division";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="name";
		var chkColum  ="chk";

/* 
 * @desc  : 주차 구해서 헤더에 셋팅
 * @param : bucketListName  -> PARTIAL, WEEKLY(default), DAILY  => default WEEKLY는 쿼리에서 처리함. 
            bucketStartDate -> 기준이 되는 날짜 ex)(20130923) => default sysdate가 속한 주의 월요일(쿼리에서 처리함.)            
 */
function gfn_getBucketDetailList(bucketListName, bucketStartDate)
{
	var sUrl, sInDs, sOutDs, sArgs, sCallbackFnc;  
	
	sSvcId		 = "retrieveBucketDetailList";
	sUrl 	     = "comm/libcommonNavi/retrieveBucketDetailList.devx";	
	sCallbackFnc = "fn_callback"
	sOutDs 		 = "ds_bucketDetailList=dsOut"; 
	sInDs 		 = "";			
	sArgs  		 = "bucketListName=" 	+ wrapQuote(gfn_nullVal(bucketListName,	"WEEKLY"));	
	sArgs   	+= " bucketStartDate="  + wrapQuote(gfn_nullVal(bucketStartDate,""));	
	
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArgs, sCallbackFnc, true, false);
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getXjmLookupList
 * 입      력	: 	
					1. objDs		: Binding 대상 데이타셋
					2. sPCode 		: lookType 코드
					3. sDefault		: 첫번째 Row 추가여부(A:전체, S:선택)
					4. 
 * 반      환	:   
 * 기      능	: 	공통코드 처리 내부함수(XJM)
 *****************************************************************************************/
function gfn_getXjmLookupList(objDs, sPCode, sDefault)
{
	if(sPCode == null) 	sPCode 	= "ZXC";
	
	if(isValidObject("cds_code")==false)
	{
		var strDsName="cds_code";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);

var codeColum ="code";
		var dataColum ="gubun";
		var chkColum  ="chk";

var sArg = "";
	
	var sSvcId 		 = "retrieveLookupList"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveXjmLookupList.devx";
	var sInDs  		 = "cds_code=cds_code";
	var sOutDs 		 = "gds_lookup=gds_lookup";

sArg 		 = sArg  + " userGubun="+wrapQuote(gds_roleCom.getColumn(0, "division"));
		sArg 		 = sArg  + " ssGubun="+wrapQuote(gds_roleCom.getColumn(0, "subsudiary"));
	
	var sCallbackFnc = "";
			
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);
	
	if(gds_lookup.getRowCount() != 0)
	{
		var cRow = cds_code.getRowCount();
		for(var i=0; i < cRow; i++)
		{
			var dsname = cds_code.getColumn(j,"dsname");
			eval(dsname).enableevent = false;
			eval(dsname).copyData(gds_lookup);
			dscopy.copyData(gds_lookup);
			eval(dsname).clearData();
			eval(dsname).enableevent = true;
		}
					
		var lRow = gds_lookup.getRowCount();
		var cRow = cds_code.getRowCount();
		for(var j=0; j < cRow; j++)
		{
			dscopy.clearData();
			for(var i=0; i < lRow; i++)
			{
				var dsName = cds_code.getColumn(j, "dsname");
				if(gds_lookup.getColumn(i,"lookupType") == cds_code.getColumn(j,"code"))
				{
					
					var nRow = dscopy.addRow();
					dscopy.copyRow(nRow,gds_lookup,i);
				}
			}
			eval(dsName).enableevent = false;
			eval(dsName).copyData(dscopy);
			eval(dsName).enableevent = true;
		}
	}
	
	var cRow = cds_code.getRowCount();
	for(var i=0; i < cRow; i++)
	{
		var sGubun = cds_code.getColumn(i,"gubun");
		var dsName = cds_code.getColumn(i,"dsname");
		eval(dsName).enableevent = false;
		if(sGubun == "A") 
		{
			var nRow = eval(dsName).insertRow(0);
			eval(dsName).setColumn(0, "code", 		"");
			eval(dsName).setColumn(0, "cdname", 	"All");
			eval(dsName).setColumn(0, "fname", 		"All");
		}
		else if(sGubun == "S") 
		{
			var nRow = eval(dsName).insertRow(0);
			eval(dsName).setColumn(0, "code", 		"");
			eval(dsName).setColumn(0, "cdname", 	"Select");
			eval(dsName).setColumn(0, "fname", 		"Select");
		}
		else if(sGubun == "N")
		{
			eval(dsName).insertRow(0);
			eval(dsName).setColumn(0, "cdname", 	"");
			eval(dsName).setColumn(0, "fname", 		"");
		}
		eval(dsName).applyChange();
		eval(dsName).enableevent = true;
		eval(dsName).rowposition = -1;
	}
}

/*****************************************************************************************
 * 함  수  명	: 	gfn_getMenuId
 * 입      력	: 	
					1. formUrl		: Form URL
					
 * 반      환	:   Menu ID
 * 기      능	: 	공통코드 처리 내부함수
 *****************************************************************************************/
 function gfn_getMenuId(formUrl) {
	var menuId = 0;
	
	if(isValidObject("dsMenuId")==false)
	{
		var strDsName="dsMenuId";
		//Dataset 생성
		var objDataset 	= new Dataset;
		objDataset.name	= strDsName; 
		this.addChild(strDsName, objDataset);
	}
	dsMenuId.clear();
	
	var sSvcId 		 = "retrieveMenuId"; 
	var sUrl   		 = "comm/libcommonNavi/retrieveMenuId.devx";
	var sInDs  		 = "";
	var sOutDs 		 = "dsMenuId=gds_menuId";
    var sArg         = "formUrl="+wrapQuote(formUrl);
	
	var sCallbackFnc = "";
			
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);
	
	if(dsMenuId.getRowCount() > 0 ) {
		menuId = dsMenuId.getColumn(0, "menuId");
	}
	
	return menuId;
 }
 
 /*****************************************************************************************
 * 함  수  명	: 	gfn_getUrgentUserYn
 * 입      력	: 	dataset
 * 반      환	:   UrgentUserYn dataset
 * 기      능	: 	사용자에 대한 urgent yn 조회
 *****************************************************************************************/
 function gfn_getUrgentUserYn(outDs, callback){
	var sSvcId 		 = "getUrgentUserYn"; 
	var sUrl   		 = "comm/libcommonNavi/getUrgentUserYn.devx";
	var sInDs  		 = "";
	var sOutDs 		 = outDs + "=outDs";
    var sArg         = "outDs=outDs"
                    += " ssoUserId=" + wrapQuote(gfn_nullVal(gv_ssoId));
	
	var sCallbackFnc = callback;
			
	gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArg, sCallbackFnc, false, false);
 }

저작자표시

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

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
Nexacro - 공통 JavaScript (0)	2017.01.19

Posted by 농부지기

Nexacro - Form관련 Javascript

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

[ Nexacro - Form관련 Javascript ]

/*==============================================================================
 * System Name   : SKU
 * Program ID    : xForm.xjs
 * Program Name  : X-platform 라이브러리
 * Author        : 최원식
 * Created On    : 2015.09.09
 * Description   : X-platform 라이브러리
 *------------------------------------------------------------------------------
 * Modify Date      Modifier    Modify Description
 *------------------------------------------------------------------------------
 * 
 *------------------------------------------------------------------------------
==============================================================================*/

/**
 * 화면로드시 공통기능 처리
 */
function gfn_frmInit(){
	try{
		this.onkeydown.setHandler(gfn_commonKeyDown);
	}catch(e){}
	
	//좌측조회조건 Div 세팅
	if(this.isValidObject("div_leftCond")){
		div_leftCond.fn_displayLeftCond();
	}
	
/*	
	if(this.isValidObject("spt_leftCond")){
		spt_leftCond.redraw();
		spt_leftCond.addItem("item100", "div_leftCond", "resize", 0, "leftortop");
		
                <SplitterItem id="item01" bindtype="move" position="rightorbottom" offset="2" componentid="stc_title"/>
                <SplitterItem id="item02" bindtype="resize" position="rightorbottom" offset="2" componentid="div_cond"/>
                <SplitterItem id="item03" bindtype="resize" position="rightorbottom" offset="2" componentid="div_data"/>		
	}	
*/

try{
		btn_condHide.position2.left = '50%';
		btn_condHide.positiontype   = 'position2';
	}catch(e){}
	try{
		btn_leftCondHide.position2.top  = '45%';
		btn_leftCondHide.positiontype   = 'position2';
	}catch(e){}
	
	try
	{
		gfn_param_chk();
	}	
	catch(e){}
	
	try{
		stc_title00.text = ARG_MENU_NAME;
	}catch(e){}
}

/**
 * 기본조회조건 숨김 처리 
 * @param obj :	Botton
 * @param e 	
 */
function gfn_condHide(obj, e){
	try{
		var objCond = div_work.div_cond;
		var objData = div_work.div_data;
	
		if(objCond.position.height == 5){
			objCond.position.height = fv_bCondDetailShow ? fv_iDivCondExtH : fv_iDivCondBaseH; //상세조건이 펼쳐졌는지에 따라 
			obj.class = "btn_WFSA_AreaClose";
		}else{
			objCond.position.height = 5;
			obj.class = "btn_WFSA_AreaOpen";
		}
		gfn_btnCondHideMove(obj, objCond, objData);
		
	}catch(e){}
}

/**
 * btn_condHide, div_cond, div_data move 처리 
 * @param objBtnCondHide :	btn_condHide
 * @param objDivCond :	div_cond
 * @param objDivData :	div_data
 * @param e 	
 */
function gfn_btnCondHideMove(objBtnCondHide, objDivCond, objDivData){
	var bSptVerticalTopFlag = false;
	try{ //spt_vertical 위치유지를 위해
		var nT = objDivData.spt_vertical.position2.top;
		var nH = objDivData.position.height;
		if(toNumber(nT)+5 == toNumber(nH))
		{
			bSptVerticalTopFlag = true;
		}
	}catch(e){}
	
	objBtnCondHide.move(680, objDivCond.position.bottom-1);
	try{ //spt_vertical 위치유지를 위해	
		objDivData.position.top = objDivCond.position.bottom + 7;
	}catch(e){}

try{  //spt_vertical 가 있는 2단화면일때 spt_vertical 위치보정
		var nDivDataHeight = toNumber(objDivData.position.height);
		if(objDivData.spt_vertical.position2.top > nDivDataHeight + 5){
			objDivData.spt_vertical.position2.top = nDivDataHeight - 5;
		}else if(bSptVerticalTopFlag){
			objDivData.spt_vertical.position2.top = nDivDataHeight - 5; //위치유지
		}
	}catch(e){}
}

/**
 * 상세조회조건 보기 처리 
 * @param obj :	Botton
 * @param e 	
 */
function gfn_condDetailShow(bFlag){
	
	if(bFlag && fv_bCondDetailShow) return; //열려있는경우 패스하기 위해
	
	if(div_cond.position.height == div_cond.stc_spLine.position.top){
		div_cond.position.height = fv_iDivCondExtH;
		fv_bCondDetailShow = true;
		div_cond.btn_condDetailShow.class = "btn_WFSA_Close";
	}else{
		div_cond.position.height = div_cond.stc_spLine.position.top;
		fv_bCondDetailShow = false;
		div_cond.btn_condDetailShow.class = "btn_WFSA_Open";
	}
	gfn_btnCondHideMove(btn_condHide, div_cond, div_data);
}

/**
 * 상세조회조건 open
 * @param obj :	Botton
 * @param e 	
 */
function gfn_condDetailShowInit(iFlag){	
	
	if(iFlag == "open"){
		div_cond.position.height 			= fv_iDivCondExtH;		
		fv_bCondDetailShow 					= true;
		div_cond.btn_condDetailShow.class 	= "btn_WFSA_Close";
	}else{
		div_cond.position.height 			= div_cond.stc_spLine.position.top;
		fv_bCondDetailShow 					= false;
		div_cond.btn_condDetailShow.class 	= "btn_WFSA_Open";
	}
	gfn_btnCondHideMove(btn_condHide, div_cond, div_data);
}

/**
 * 좌측조회조건 숨김 처리 
 * @param obj :	Botton
 * @param e 	
 */
function gfn_leftCondHide(obj, e)
{
	if(_leftCondLock) return false; //고정핀이 적용된 경우 
	
	var objCond = div_work.div_cond;
	var objLeftCond = div_work.div_leftCond;
	var objData = div_work.div_data;

if(objLeftCond.position.width == 5){
		//show
		objLeftCond.position.width = 160;
		div_work.stc_title.position.left = 170;
		objCond.position.left = 170;
		objData.position.left = 170;
		obj.move(160, 288);
		obj.class = "btn_LF_close";
		objLeftCond.stc_leftCondBg.class = "sta_LF_bgO";
		objLeftCond.stc_leftCondBg.sendToBack(); 
	}else{
		//hide
		objLeftCond.position.width = 5;
		div_work.stc_title.position.left = 15;
		objCond.position.left = 15;
		objData.position.left = 15;
		obj.move(5, 288);
		obj.class = "btn_LF_open";
		objLeftCond.stc_leftCondBg.class = "sta_LF_bgC";
		objLeftCond.stc_leftCondBg.bringToFront();
	}
	
	try{ //spt_leftCond 위치조정
		var objSpt = div_work.spt_leftCond;
		if(obj.class == "btn_LF_close"){
			objSpt.position2 = "absolute l:160 w:8 t:5 b:3";
			objSpt.visible  = true;
		}else{
			objSpt.position2 = "absolute l:5 w:8 t:5 b:3";
			objSpt.visible  = false;
		}
	}catch(e){}
}

/**
 * 좌측조회조건 Splitter 이벤트
 * @param obj :	Botton
 * @param e 	
 */
function gfn_sptLeftCond_onbeginmove(obj, e)
{
	obj.addItem("item100", "div_leftCond", "resize", 0, "leftortop");
	obj.addItem("item101", "btn_leftCondHide", "move", -8, "leftortop");
}

/**
 * 좌측조회조건 Splitter 이벤트
 * @param obj :	Botton
 * @param e 	
 */
function gfn_sptLeftCond_endmove(obj, e)
{
	obj.deleteItem("item100");
	obj.deleteItem("item101");
}

/**
 * Total decorate
 * @param nTotal 표시할 Count 수 
 * @return 문자열
 */
function gfn_setTotalText(nTotal)
{
	var sTotal = '0';
	if(nTotal != null){
		sTotal = gfn_appendComma(nTotal, 0);
	}
	return "Total <b v='true'><fc v='#b10042'>"+sTotal+"</fc></b>";
}

/**
 * LinkTo 버튼 클릭
 * @param obj :	Form
 * @param e 	
 */
 function gfn_linkToPdvOpen(obj:Button, arrLinkTo, nWidth)
{
	var iH = arrLinkTo.length;
	if(iH == 0) return;
	if(gfn_isNull(nWidth)) nWidth = 130;
	
	//PopupDiv open
	var sPdvName = "pdv_linkTo";
	var objPopupDiv = new PopupDiv(sPdvName, 0, 0, nWidth, iH*18+3);
	objPopupDiv.style = "background:#ffffffff;border:1 solid #898e94ff;bordertype:round 2 2";
	objPopupDiv.url = "common::PdvLinkTo.xfdl";

this.addChild(objPopupDiv.name, objPopupDiv);
	objPopupDiv.show();
    objPopupDiv.fn_setLinkToData(arrLinkTo);
	objPopupDiv.trackPopup(system.clientToScreenX(obj,-1),system.clientToScreenY(obj,20));
	this.removeChild(sPdvName);
	objPopupDiv.destroy();
}

/**
 * Form KeyDown 
 * @param obj :	Form
 * @param e 	
 */
function gfn_commonKeyDown(obj:Form, e:KeyEventInfo)
{
	if(e.ctrlKey == true && e.shiftKey == true && e.keycode == 123){
		gfn_openPopup('debugPop', 'common::DebugForm.xfdl', '', 1000, 600);
	}
}

/**
 * 상하2단 splitter로 분할되어 있고 Folding버튼이 각각 있는 경우 처리  
 * @param sType : 상단버튼클릭시 upper, 하단버튼클릭시 lower 
 * @param objUpperBtn :	상단버튼객체
 * @param objUpperGrid : 상단 Grid 객체
 * @param objLowerBtn :	하단버튼객체
 * @param objSpt : 상하단 분할 Splitter
 * @param e 	
 */
function gfn_gridFolding2(sType, objUpperBtn, objUpperGrid, objLowerBtn, objSpt)
{
	if(gfn_isNull(div_data._foldingUpper) && gfn_isNull(div_data._foldingLower)){
		div_data._foldingBaseSptT = objSpt.position.top; //기본분할값 
	}

if(gfn_isNull(div_data._foldingUpper)) div_data._foldingUpper = "-";
	if(gfn_isNull(div_data._foldingLower)) div_data._foldingLower = "-";
	
	if(sType == "upper"){
		if(objUpperBtn.class == "btn_WF_Gridclose"){
			div_data._foldingUpper = "+";
			objUpperBtn.class = "btn_WF_Gridopen"; //(+)
			div_data._foldingGridB = objUpperGrid.position.bottom;
			objSpt.move(objSpt.position.left, objUpperGrid.position.top+3);
						
			if(div_data._foldingLower == "+" && objLowerBtn.class == "btn_WF_Gridopen"){
				objLowerBtn.class = "btn_WF_Gridclose";
			}	
		}else{
			objSpt.move(objSpt.position.left, div_data._foldingGridB);
			div_data._foldingUpper = "-";	
			objUpperBtn.class = "btn_WF_Gridclose"; //(-)
			
			if(div_data._foldingLower == "+" && objLowerBtn.class == "btn_WF_Gridclose"){
				objLowerBtn.class = "btn_WF_Gridopen";
			}else if(div_data._foldingLower == "-" && objLowerBtn.class == "btn_WF_Gridclose"){
				objSpt.move(objSpt.position.left, div_data._foldingBaseSptT); //Splitter 기본분할값
			}
		}
	}
	else
	{
		if(objLowerBtn.class == "btn_WF_Gridclose"){ //(-)
			div_data._foldingSptT = objSpt.position.top;
			objSpt.move(objSpt.position.left, div_data.position.height-37);
			div_data._foldingLower = "+";
			objLowerBtn.class = "btn_WF_Gridopen";  //(+)
			
			if(div_data._foldingUpper == "+" && objUpperBtn.class == "btn_WF_Gridopen"){
				objUpperBtn.class = "btn_WF_Gridclose"; //(-)
			}	
			
		}else{
			objSpt.move(objSpt.position.left, div_data._foldingSptT);
			div_data._foldingLower = "-";
			objLowerBtn.class = "btn_WF_Gridclose";  //(-)
			
			if(div_data._foldingUpper == "+" && objUpperBtn.class == "btn_WF_Gridclose"){
				objUpperBtn.class = "btn_WF_Gridopen"; //(+)
			}else if(div_data._foldingUpper == "-" && objUpperBtn.class == "btn_WF_Gridclose"){
				objSpt.move(objSpt.position.left, div_data._foldingBaseSptT); //Splitter 기본분할값
			}
		}
	}
}

/**
 * User Setting 날짜 형식에 따른 포맷된 값 리턴  
 * @param sDate : string 형 날짜
 */
function gfn_uSetDateFormat(sDate)
{
	var sFormat = gds_admUserInfo.getColumn(0,"dateFormat");
	if(gfn_isNull(sFormat) == true){
		sFormat = "yyyy-MM-dd";
	}
	return gfn_dateFormatString(sDate, sFormat);
}

/**
 * User Setting 숫자 형식에 따른 locale 값 리턴  
 * @return locale 
 */
function gfn_uSetNumberFormat()
{
	var locale = "en_US";
	var sFormat = gds_admUserInfo.getColumn(0,"numberFormat");
	if(gfn_isNull(sFormat) == true){
		sFormat = "10,000.00";
	}
	if(sFormat == "10.000,00"){
		locale = "de_DE";
	}
	return locale;
}

/**
 * 권한에 따른 버튼 및 그리드 컨트럴
 * @return  
 */
function gfn_authority_type(programId, objgrid, objbtn)
{
	var objArrbtn 	= new Array();
	var objArrgrid 	= new Array();

objArrbtn 	= objbtn.split(",");
	objArrgrid 	= objgrid.split(",");

var cbtn 	= objArrbtn.length;
	var cgrid 	= objArrgrid.length;

/**
 * 권한에 확인
 * @return 2,1,...  
 */
function gfn_authority_search(programId)
{
	var fRow = gds_program.findRow("programId",programId);
	var userRole = '0';
	if(gds_roleCom.getColumn(0, "roleId") == '1')
	{
		userRole = gds_program.getColumn(fRow,"role1");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '2')
	{
		userRole = gds_program.getColumn(fRow,"role2");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '3')
	{
		userRole = gds_program.getColumn(fRow,"role3");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '4')
	{
		userRole = gds_program.getColumn(fRow,"role4");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '5')
	{
		userRole = gds_program.getColumn(fRow,"role5");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '6')
	{
		userRole = gds_program.getColumn(fRow,"role6");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '7')
	{
		userRole = gds_program.getColumn(fRow,"role7");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '8')
	{
		userRole = gds_program.getColumn(fRow,"role8");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '9')
	{
		userRole = gds_program.getColumn(fRow,"role9");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '10')
	{
		userRole = gds_program.getColumn(fRow,"role10");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '11')
	{
		userRole = gds_program.getColumn(fRow,"role11");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '12')
	{
		userRole = gds_program.getColumn(fRow,"role12");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '13')
	{
		userRole = gds_program.getColumn(fRow,"role13");
	}
	else if(gds_roleCom.getColumn(0, "roleId") == '99')
	{
		userRole = gds_program.getColumn(fRow,"role99");
	}
	return userRole;
}

/**
 * Clear All Add Condition Object
 */
function gfn_clearAddCondObj() {
	for( var i=0; i<=30; i++ ) {
		div_cond.removeChild("dyna_uploadItemAttribute"+i);
		div_cond.removeChild("dyna_stc_uploadItemAttribute"+i);
	}
	
	for( var i=0; i<=30; i++ ) {
		div_cond.removeChild("dyna_logicItemAttribute"+i);
		div_cond.removeChild("dyna_stc_logicItemAttribute"+i);
	}
}

/**
 * 오브젝트를 타입별(Combo/Edit/Static)로 생성해준다.
 */
function gfn_createObject( parentObj:Object, objType:String  , objName:String
                         , iBot			   , iLeft		     , iRight		  	, iTop
                         , dsName:String   , cdColName:String, dtColName:String
                         , haveValue) {
    var object = null;
    
    if( objType == "Combo" ) {   
        object = new Combo(objName, iLeft, iTop, iRight, iBot);
        parentObj.addChild(objName, object);
        object.innerdataset 		= dsName;
        object.codecolumn 			= cdColName;
        object.datacolumn 			= dtColName;
        object.combodisplayrowcount = 15;
        if( !gfn_isNull(haveValue) ){						
			object.value			= haveValue;			
        }else{
			object.value 			= "";
        }
        object.index = 0;
    }
    else if(objType == "Edit") {
        object = new Edit(objName, iLeft, iTop, iRight, iBot);
        parentObj.addChild(objName, object);   
        object.inputmode = "upper";
        if( !gfn_isNull(haveValue) ){			
			object.value				= haveValue;			
        }else{
			object.value 			= "";
        }
    }
    else if(objType == "Static") {
        object = new Static(objName, iLeft, iTop, iRight, iBot);
        parentObj.addChild(objName, object);  
        object.class 	= "sta_WFSA_label";
        object.text 	= dsName;
    }
     
    object.show();     
}

/**
 * Add Condition Objects를 화면에 동적으로 그려준다.
 * @param stcId1, stcId2, stcId3, stcId4 	 : 조회조건의 가장 윗열 기준이 되는 조회조건 이름 ID
 * @param itemId1, itemId2, itemId3, itemId4 : 조회조건의 가장 윗열 기준이 되는 조회조건 컴포넌트 왼쪽 싸이즈 ID
 * @param itemId1, itemId2, itemId3, itemId4 : 조회조건의 가장 윗열 기준이 되는 조회조건 컴포넌트 오른쪽 싸이즈 ID
 */
function gfn_renderingAddCondition( stcId1, stcId2, stcId3, stcId4
								 , itemId1, itemId2, itemId3, itemId4
								 , itemId5, itemId6, itemId7, itemId8
								 ){
	var chkVal, codVal, textVal, stcVal, valueSetName, dispType;    
    var idynaIdx 	= 0;
    var dsName 		= "";

var verticalGap = 5;
    var itemHieght 	= 20;
	
	var verticalGap = 5;
    var itemHieght 	= 20;
    
    var stc1Left 	= stcId1.position.left;
    var stc2Left 	= stcId2.position.left;
    var stc3Left 	= stcId3.position.left;
    var stc4Left 	= stcId4.position.left;
    var stc1Right	= stcId1.position.right;
    var stc2Right 	= stcId2.position.right;
    var stc3Right 	= stcId3.position.right;
    var stc4Right 	= stcId4.position.right;
    var stc1Bottom 	= stcId1.position.bottom+25;
    
    var item1Left 	= itemId1.position.left;
    var item2Left 	= itemId2.position.left;
    var item3Left 	= itemId3.position.left;
    var item4Left 	= itemId4.position.left;
    var item1Right 	= itemId5.position.right;
    var item2Right 	= itemId6.position.right;
    var item3Right 	= itemId7.position.right;
    var item4Right 	= itemId8.position.right;    
    var item1Bottom = itemId1.position.bottom+25;
        
    var arrItemBottom 	= [];
    var arritemLeft 	= [];
    var arrItemRight 	= [];
    var arrItemTop 		= [];
    
    var arrStcBottom 	= [];
    var arrStcLeft 		= [];
    var arrStcRight 	= [];
    var arrStcTop 		= [];

if(chkVal == "1") {
            if(codVal != "" && codVal != undefined) {
                gfn_createObject(div_cond, "Static", "dyna_stc_"+codVal
                              , arrStcBottom[idynaIdx], arrStcLeft[idynaIdx], arrStcRight[idynaIdx], arrStcTop[idynaIdx]
                              , textVal ,"", "");
                if(dispType == "Combo") {
                    gfn_createObject(div_cond, "Combo", "dyna_"+codVal
                                  , arrItemBottom[idynaIdx], arritemLeft[idynaIdx], arrItemRight[idynaIdx], arrItemTop[idynaIdx]
                                  , "ds_"+codVal ,"code", "cdname", haveValue);
                } else {
                    gfn_createObject(div_cond, "Edit", "dyna_"+codVal
                                  , arrItemBottom[idynaIdx], arritemLeft[idynaIdx], arrItemRight[idynaIdx], arrItemTop[idynaIdx]
                                  , "" ,"", "", haveValue);                     
                }
                               
                for( j=0; j<ds_addCondition.rowcount; j++ ) {
                    if( ds_addCondition.getColumn(j, "haveLabel") == "dyna_"+codVal ) {
                        eval("div_cond.dyna_"+codVal).value = ds_addCondition.getColumn(j, "haveValue");
                    }
                }                               
            }
			idynaIdx++;
		}
	}
}

/**
 * Add Condition 초기화
 * @param ofv_tableId 	: Item Attribute 설정에 사용되는 DFF TABLE ID
 * @param ods_division  : 호출한 화면의 DivisionList
 */
function gfn_initAddCondition(ofv_tableId, ods_division) {

var sUrl, sInDs, sOutDs, sArgs, sCallbackFnc;  
	
	sInDs 		 = "";
	sCallbackFnc = ""; 	
	sArgs  		 = "";
	sOutDs		 = "";
	
	//Add Condition 정보조회
	if( ods_division.getCaseCount("chk=='1'") == 1 ){
		//Add Condition 설정자료 조회 - Division 단건
		sSvcId  = "retrieveCommAddCondList";
		sUrl 	= "comm/itemAttrNavi/retrieveCommAddCondList.devx";
		sOutDs 	= "ds_addCondition=dsOut"; 	
		sArgs  	= "tableId=" 		+ wrapQuote(ofv_tableId);
		sArgs  += " divisionId="	+ wrapQuote(gfn_nullVal(ods_division.getColumn(ods_division.findRow("chk","1"),"divisionId"),""));		
		
		gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArgs, sCallbackFnc, false, false);	
    } else {
		//Add Condition 설정자료 조회 - Division 다건
		sSvcId  = "retrieveCommItemAttr";
		sUrl 	= "comm/itemAttrNavi/retrieveCommItemAttr.devx";
		sOutDs 	= "ds_addCondition=dsOut"; 	
		sArgs  	= "tableId=" 		+ wrapQuote(ofv_tableId);		
		
		gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArgs, sCallbackFnc, false, false);	
    }
    
    // Division 이 단건일 경우 XCM_DFF에서 item attribute 조회조건에 들어갈 콤보박스 자료 조회
    if ( sSvcId == "retrieveCommAddCondList" ) {
		sSvcId == "retrieveCommCondDffValue";
        sUrl 	= "comm/itemAttrNavi/retrieveCommCondDffValue.devx";
		sOutDs 	= "ds_dffVals=dsOut"; 	
		sArgs  	= "tableId=" 		+ wrapQuote(ofv_tableId);
		sArgs += " divisionId="		+ wrapQuote(gfn_nullVal(ods_division.getColumn(ods_division.findRow("chk","1"),"divisionId"),""));		
		
		gfn_transaction(sSvcId, sUrl, sInDs, sOutDs, sArgs, sCallbackFnc, false, false);	
		
	}
	
	//item attribute 조회조건 콤보박스 Dataset 생성
    gfn_creatItemAttrDataset();
}

/**
 * Add Condition Objects를 화면에 동적으로 그려준다.
 * @param stcId1, stcId2, stcId3, stcId4, stcId5	 : 조회조건의 가장 윗열 기준이 되는 조회조건 이름 ID
 * @param itemId1, itemId2, itemId3, itemId4, itemId5 : 조회조건의 가장 윗열 기준이 되는 조회조건 컴포넌트 왼쪽 싸이즈 ID
 * @param itemId6, itemId7, itemId8, itemId9, itemId10 : 조회조건의 가장 윗열 기준이 되는 조회조건 컴포넌트 오른쪽 싸이즈 ID
 */
function gfn_renderingAddCondition2( stcId1, stcId2, stcId3, stcId4, stcId5
								 , itemId1, itemId2, itemId3, itemId4, itemId5
								 , itemId6, itemId7, itemId8, itemId9, itemId10
								 , bottomPosion
								 ){
	var chkVal, codVal, textVal, stcVal, valueSetName, dispType;    
    var idynaIdx 	= 0;
    var dsName 		= "";

var verticalGap = 5;
    var itemHieght 	= 20;
	
	var verticalGap = 5;
    var itemHieght 	= 20;
    
    var bp = 25 * (bottomPosion-1);
    
    var stc1Left 	= stcId1.position.left;
    var stc2Left 	= stcId2.position.left;
    var stc3Left 	= stcId3.position.left;
    var stc4Left 	= stcId4.position.left;
    var stc5Left 	= stcId5.position.left;
    
    var stc1Right	= stcId1.position.right;
    var stc2Right 	= stcId2.position.right;
    var stc3Right 	= stcId3.position.right;
    var stc4Right 	= stcId4.position.right;
    var stc5Right 	= stcId5.position.right;
    var stc1Bottom 	= stcId1.position.bottom + bp;
    
    var item1Left 	= itemId1.position.left;
    var item2Left 	= itemId2.position.left;
    var item3Left 	= itemId3.position.left;
    var item4Left 	= itemId4.position.left;
    var item5Left 	= itemId5.position.left;
    
    var item1Right 	= itemId6.position.right;
    var item2Right 	= itemId7.position.right;
    var item3Right 	= itemId8.position.right;
    var item4Right 	= itemId9.position.right;    
    var item5Right 	= itemId10.position.right;    
    var item1Bottom = itemId1.position.bottom +  bp;
    
    var arrStcLeft = [];
    var arrStcRight = [];
    var arrItemLeft = [];
    var arrItemRight = [];
            
    var arrItemBottom 	= [];
    var arritemLeft 	= [];
    var arrItemRight 	= [];
    var arrItemTop 		= [];
    
    var arrStcBottom 	= [];
    var arrStcLeft 		= [];
    var arrStcRight 	= [];
    var arrStcTop 		= [];

저작자표시

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

Nexacro - 공통 (Common) 관련 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
Nexacro - 공통 JavaScript (0)	2017.01.19

Posted by 농부지기

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 농부지기

Nexacro - 공통 JavaScript

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

[ Nexacro - 공통 JavaScript ]

/* Null 체크
*/
function gfn_isNull(sValue)
{
	if (new String(sValue).valueOf() == "undefined") return true;
	if (sValue == null) return true;
	
	var v_ChkStr = new String(sValue);
	
	if (v_ChkStr == null) return true;
	if (v_ChkStr.toString().length == 0 ) return true;
	return false;
}
function gfn_isExist(sValue){
	if (gfn_isNull(sValue))
		return false;
	else
		return true;
}

/* Null 인경우 emptyVal 리턴
*/
function gfn_nullVal(inVal, emptyVal)
{
	if(gfn_isNull(inVal)) {
		if (gfn_isNull(emptyVal)) emptyVal = '';
		inVal = emptyVal;
	}
	return gfn_trim(inVal);
}

/* 정규식을 이용한 trim 구현 - 문자열 양 옆의 공백 제거
*/
function gfn_trim(strText)
{
	if (strText == null) return "";
	if (new String(strText).valueOf() == "undefined") return "";
	if (new String(strText) == null) return "";
	
	var retVal = (new String(strText)).replace(/^\s+|\s+$/g, '');
	
	return retVal;
}

/* 특정 문자를 제거한다.
@param sValue : 문자열, @param sRemove : 제거할 문자
@return : 특정문자가 제거된 문자열 /
function gfn_removeStr(sValue, sRemove)
{
	var result = "";
	for (var i=0; i< gfn_trim(sValue).length; i++) {
		if (sValue.charAt(i) == sRemove) {
			result = sValue.substring(0, i);
			sValue = result + sValue.substring(i+1, sValue.length);
		}
	}
	return sValue;
}

/* 특수문자가 있는지 체크한다.
@param sValue Input value @return boolean
*/
function gfn_isSpecialChar(sValue)
{
	var retVal = false;
	if(sValue.search(/\W|\s/g) > -1) retVal = true;
	return retVal;
}

/* 문자열 길이계산.
@param {string} str 대상 문자열. @param {string=} unit 문자열의 길이를 검사하는 단위 .
"utf16" - 한문자당 1의 값으로 합산함(default).
"utf8" - 한 문자당 영문1, 다국어 2~5의 값으로 합산함.
"ascii" - 한문자당 영문 1, 한글 2의 값으로 합산함.
@return {number} 문자열 길이. /
function gfn_getLengthByte(sValue, unit)
{
	if(sValue === undefined) return 0;
	
	if(unit == "utf8"){
	    var ch, high, low, count = 0;
	    for(var i=0, n = sValue.length; i< n; i++){
	        ch = sValue.charCodeAt(i);
	
	        if(_gfn_isHighSurrogate(ch)){
	            high = ch;
	            low = sValue.charCodeAt(++i);
	            count += _gfn_utf8Len(_gfn_toCodepoint(high, low));
	        }else{
	            count += _gfn_utf8Len(ch);
	        }
	    }
	    return count;
	}else if(unit == "ascii"){
	    var i, j=0, val; 
	    for(i=0, n = sValue.length; i< n; i++){ 
	        val = sValue.charCodeAt(i);
	        if( val > 255 ) j++;
	        j++; 
	    }
	    return j;
	}else{
	    return sValue.length;
	}
}

/
함 수 명 : gfn_getLength 입 력 : 1. sValue - String
반 환 : return int 기 능 : 입력된 문자열 길이 반환하는 함수 /
function gfn_getLength(sValue)
{
	if (new String(sValue).valueOf() == "undefined") return 0;
	if (sValue == null) return 0;
	
	var v_ChkStr = new String(gfn_trim(sValue));
	
	if (v_ChkStr == null) return 0;
	if (v_ChkStr.toString().length == 0 ) return 0;
	
	return v_ChkStr.toString().length;
}

/* 입력받은 Number에 commas 추가
@param nNumber Input value @param nDetail 출력시 소숫점 이하의 자릿수.(반올림함)
@return 문자형 /
function gfn_appendComma(nNumber,nDetail)
{
	if(nNumber == null) return "";
	if(nDetail == null) nDetail = 0;
	
	nNumber    = parseFloat(nNumber);
	nNumber    = Math.round(nNumber, nDetail);
	
	var sNumber     = new String(nNumber);
	var arrNumber     = sNumber.split(".");
	var sFormatNum = "";
	var j = 0;
	
	for(i = arrNumber[0].length - 1; i >= 0; i--){
	    if(i != sNumber.length && j == 3){
	        sFormatNum = arrNumber[0].charAt(i) + "," + sFormatNum;
	        j = 0;
	    }else{
	        sFormatNum = arrNumber[0].charAt(i) + sFormatNum;
	    }
	    j++;
	}
	
	if(arrNumber.length > 1) sFormatNum = sFormatNum + "." + arrNumber[1];
	
	return sFormatNum;
}

/* decoce(비교값, CASE1, 결과값1 [, CASE2, 결과값2, ... ], 디폴트 값);
*/
function gfn_decode()
{
	var i;
	var count = arguments.length;
	for(i = 1; i<count; i+=2){
		if(arguments[0] === arguments[i]){
			return arguments[i+1];
		}
	}
	return arguments[i-2];
}

/* 숫자인지 판단
@param s 문자열 또는 숫자 @return 숫자형식이면 true 아니면 false
/
function gfn_isNumber(s)
{
	s += ''; // 문자열로 변환
	s = s.replace(/^\s|\s*$/g, ''); // 좌우 공백 제거
	if (s == '' || isNaN(s)) return false;
	return true;
}

/* 배열에 해당값이 있는지 체크
@param arrVal Array @param varVal Input value
@return boolean /
function gfn_isExistInArray(arrVal, varVal) {

var retVal = false;
	var nCnt = arrVal.length;
	for(var i=0; i<nCnt; i++) {
	    if (arrVal[i] == varVal) {
	        retVal = true;
	        break;
	    }
	}
	return retVal;
}

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

/* 유니코드 보충언어판(Supplementary Plane)의
상위 대행코드(High Surrogate) 여부. @param {string} codeUnit 대상 문자열.
@return {number} 문자열 길이. /
function _gfn_isHighSurrogate(codeUnit)
{
	return codeUnit >= 0xD800 && codeUnit <= 0xDBFF;
}

/* 유니코드 보충언어판(Supplementary Plane)의
하위 대행코드(High Surrogate) 여부. @param {string} codeUnit 대상 문자열.
@return {number} 문자열 길이. /
function _gfn_isLowSurrogate(codeUnit)
{
	return codeUnit >= 0xDC00 && codeUnit <= 0xDFFF;
}

/* uft8 문자열 길이계산.
@param {string} codePoint 문자셋 수치보정값. @return {number} 문자열 길이.
*/
function _gfn_utf8Len(codePoint){
	if(codePoint >= 0xD800 && codePoint <= 0xDFFF){
		gfn_alert("Illegal argument: "+codePoint);
	}
	if(codePoint < 0){
		gfn_alert("Illegal argument: "+codePoint);
	}
	if(codePoint <= 0x7F) return 1;
	if(codePoint <= 0x7FF) return 2;
	if(codePoint <= 0xFFFF) return 3;
	if(codePoint <= 0x1FFFFF) return 4;
	if(codePoint <= 0x3FFFFFF) return 5;
	if(codePoint <= 0x7FFFFFFF) return 6;
	
	gfn_alert("Illegal argument: "+codePoint);
}

/* 문자셋의 수치보정값 처리
@param {number} highCodeUnit 상위 대행코드. @param {number} lowCodeUnit 하위 대행코드.
@return {number} 문자열 길이. /
function _gfn_toCodepoint(highCodeUnit, lowCodeUnit)
{
	if(!_gfn_isHighSurrogate(highCodeUnit)){
		gfn_alert("Illegal argument: "+highCodeUnit);
	}
	if(!_gfn_isLowSurrogate(lowCodeUnit)){
		gfn_alert("Illegal argument: "+lowCodeUnit);
	}
	highCodeUnit = (0x3FF & highCodeUnit) << 10;
	var u = highCodeUnit | (0x3FF & lowCodeUnit);
	return u + 0x10000;
}

/*
@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);
}

//item attribute 조회조건 콤보박스 Dataset 생성
function gfn_creatItemAttrDataset(){
	if(ds_addCondition.getRowCount() > 0){
		var valueSetName = "";
		var dsName = "";
		for( var i=0,cnt=ds_addCondition.getRowCount(); i<cnt; i++ ){
			ds_dffVals.filter("");
			valueSetName = ds_addCondition.getColumn(i, "valueSetName");
			dsName = ds_addCondition.getColumn(i, "code");
		
	    var rtnObj = removeChild("ds_"+dsName); 
	    delete rtnObj;
	    var objDs     = new Dataset;
	    objDs.name    = "ds_"+dsName;
	    this.addChild("ds_"+dsName, objDs);
	
	    eval("ds_"+dsName).clearData();
	
	    if(valueSetName != "" && valueSetName != null){
	        ds_dffVals.filter("valueSetName == '"+valueSetName+"'");
	        eval("ds_"+dsName).copyData(ds_dffVals, true);
	        eval("ds_"+dsName).insertRow(0);
	        eval("ds_"+dsName).setColumn(0, "code", "");
	        eval("ds_"+dsName).setColumn(0, "cdname", "All");
	        eval("ds_"+dsName).setColumn(0, "listname", "");
	
	        var rtnObj = removeChild("ds_"+dsName+"_grd"); 
	        delete rtnObj;
	        var objDs     = new Dataset;
	        objDs.name    = "ds_"+dsName+"_grd";
	        this.addChild("ds_"+dsName+"_grd", objDs);
	
	        eval("ds_"+dsName+"_grd").copyData(ds_dffVals, true);
	    }
	  }
	}
}

//틀고정시 getCellRect()함수 에러 때문에 다음 메소드를 만듬.
function gfn_getCellRect(obj, e){
	var arrCellRect;
	if(obj.getFormatColProperty(e.cell,"band") == "left"){
		var maxFixIdx = e.cell;
		for( var i=e.cell, cnt=obj.getCellCount("body"); i<cnt; i++){
			if(obj.getFormatColProperty(i,"band") == "left"){
				maxFixIdx = i;
			}
		}

obj.arrFixColSize = [];

//배열 초기화
    arrFixColSize = [];

//원본 그리드 사이즈 임시 저장
    for(var i=0,cnt=obj.getFormatColCount()-1; i<cnt; i++){
        arrFixColSize.push(obj.getRealColSize(i));
    }

obj.enableevent = false;
    //초기화
    for(var i=obj.getFormatColCount()-1; i>=0; i--){
        obj.setFormatColProperty(i, "band", "body");
        obj.setFormatColProperty("Head", i, "line", "1px solid #c5c5c5ff,1px solid #c5c5c5ff");
        obj.setFormatColProperty("Body", i, "line", "1px solid #e7e7e7ff,1px solid #e7e7e7ff");
    }

//배열에 있는 컬럼사이즈값 그리드에 복구 
    for(var i=0,len=arrFixColSize.length; i<len; i++){  
        obj.setFormatColProperty(i,"size",arrFixColSize[i]);
    }

obj.hscrollbar_pos = obj.hscrollbar.pos; //현스크롤위치 저장        
    obj.hscrollbar.pos = 0;

arrCellRect = obj.getCellRect(e.row, e.cell);

//Cell 고정처리
    for(var i=0; i<=maxFixIdx; i++){
        obj.setFormatColProperty(i,"band","left");            
    }

//배열에 있는 왼쪽 컬럼사이즈값 그리드에 복구 
    for(var i=0, size=arrFixColSize.length; i<size; i++){  
        obj.setFormatColProperty(i,"size", arrFixColSize[i]);                
    }

//현스크롤위치 복귀
    obj.hscrollbar.pos = obj.hscrollbar_pos;

obj.enableevent = true;        
	}else{                        
	    arrCellRect         = obj.getCellRect(e.row, e.cell);                
	}
	return arrCellRect;
}

저작자표시

'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 다음

농부지기

'Nexacro-컴포넌트/JavaScript'에 해당되는 글 6건

Nexacro - 공통 (Common) 관련 Javascript

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

Nexacro - Form관련 Javascript

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

Nexacro - Grid관련 Javascript

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

Nexacro - Dateset 관련 Javascript

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

Nexacro - 날짜관련 Javascript

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

Nexacro - 공통 JavaScript

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

카테고리

태그목록

최근에 올라온 글

최근에 달린 댓글

최근에 받은 트랙백

글 보관함

달력

링크

티스토리툴바