YNU_JEUS/app_home/himed/webapps/mis/humtrafactmngtweb/xrw/SMRPB01800_교원업적조건검색.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
	<xhtml:head>
		<xhtml:title>교원업적조건검색</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<list>
							<tablecode>
								<tablecodelist/>
							</tablecode>
							<tablewhere>
								<tablewherelist/>
							</tablewhere>
							<tableselect>
								<tableselectlist/>
							</tableselect>
							<fixitem>
								<fixitemlist/>
								<emplnodeptlist/>
							</fixitem>
							<fixdocu>
								<fixdoculist/>
							</fixdocu>
							<query>
								<querylist/>
							</query>
						</list>
					</main>
					<send>
						<itemqry>
							<itemcls/>
							<emplno/>
							<workflag>02</workflag>
						</itemqry>
						<fixdocu>
							<fixtypenm/>
							<nursedeptflag/>
							<instcd/>
							<workflag>02</workflag>
						</fixdocu>
						<save>
							<fixdoculist/>
						</save>
						<func>
							<funcflag>01</funcflag>
						</func>
					</send>
					<init>
						<operator>
							<code>=</code>
							<cdnm>=</cdnm>
						</operator>
						<conector>
							<code>AND</code>
							<cdnm>AND</cdnm>
							<code>OR</code>
							<cdnm>OR</cdnm>
						</conector>
						<selectqry/>
						<fromqry/>
						<whereqry/>
						<sqlquery/>
						<fixdoucnm/>
						<mplemplno/>
						<queryflag/>
						<queryflag>
							<code>1</code>
							<cdnm>간호부</cdnm>
							<code>2</code>
							<cdnm>간호전체</cdnm>
						</queryflag>
					</init>
					<temp>
						<s/>
					</temp>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				
					model.removeNodeset(grd_tblcode.nodeset);
					model.removeNodeset(grd_where.nodeset);
					model.removeNodeset(grd_select.nodeset);
					model.removeNodeset(grd_fixitem.nodeset);
					model.refresh();
					
					grd_select.colsort(grd_select.colRef("sortkey")) = "asc";
					
					misfMsterDetailSet(grd_tblcode,null, "TRRPB01702" ,"N"); 
					misfMsterDetailSet(grd_where,null, "TRRPB01703" ,"N"); 
					misfMsterDetailSet(grd_select,null, "TRRPB01703" ,"N"); 
					misfMsterDetailSet(grd_fixitem,null, "TRRPB01705" ,"N"); 
					
					rpbfComboItemClsList(cmb_itemcls,"02");
					
					
					
					grd_tblcode.selectionMode = "listbox";

					addGridComboItemAll("grd_where.operator","<>","<>","above");
					addGridComboItemAll("grd_where.operator",">",">","above");
					addGridComboItemAll("grd_where.operator",">=",">=","above");
					addGridComboItemAll("grd_where.operator","<","<","above");
					addGridComboItemAll("grd_where.operator","<=","<=","above");
					addGridComboItemAll("grd_where.operator","BETWEEN","BETWEEN","above");
					addGridComboItemAll("grd_where.operator","IN","IN","above");
					addGridComboItemAll("grd_where.operator","NOT IN","NOT IN","above");
					
					model.setValue("/root/send/itemqry/emplno", getUserInfo("userid"));
					submit("TRRPB01705");
					
					misfComboComCdListMulti("R0392,R0392","cmb_funcflag,grd_select.funcflag");
					
					addComboItem( "cmb_queryflag", "[-- 전체 --]", "", "above");
					cmb_funcflag.value = "01";
					model.setValue(cmb_queryflag.attribute("ref"), "");
						
				]]>
			</script>
			<submission id="TRRPB01702" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/itemqry" resultref="/root/main/list/tablecode"/>
			<submission id="TRRPB01703" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/itemqry" resultref="/root/main/list/tablecode"/>
			<submission id="TRRPB01704" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/fixdocu" resultref="/root/main/list/fixdocu"/>
			<submission id="TRRPB01705" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/itemqry" resultref="/root/main/list/fixitem"/>
			<submission id="TXRPB01701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" resultref="/root/hiddeen/temp"/>
			<submission id="TXRPB01702" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/fixdocu" resultref="/root/hiddeen/temp"/>
			<submission id="TXRPB01703" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/" resultref="/root/hiddeen/temp"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
		<script type="javascript">
			<![CDATA[
			
				function fAddWhereColumn()
				{
					if((grd_tblcode.rows - grd_tblcode.fixedRows) == 0 || grd_tblcode.row == -1)return;

					if(grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("itemflag")) == "C"){
						messageBox("선택한 항목은 조건 항목으로 선택할 수 없기 때문에 추가","E001");
						return false;
					}		

					misfGridIUD(grd_where, "A","N");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/itemcls", grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("itemcls")));
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/itemnm", grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("itemnm")));
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/itemkind", grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("itemkind")));
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/tblschema", grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("tblschema")));
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/tablenm", grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("tablenm")));
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/colnm", grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("colnm")));
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/cdtblschema", grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("cdtblschema")));
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/cdtblnm", grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("cdtblnm")));
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/codeflag", grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("codeflag")));
					
					grd_where.refresh();
					
					return true;
				}
				function fAddSelectColumn(){


					
						for(var s=0; s < grd_tblcode.selectedRows; s++ )
						{
                                   var cur_row = grd_tblcode.selectedrow(s);
							var finddata = grd_tblcode.valueMatrix(grd_tblcode.selectedrow(s), grd_tblcode.colRef("itemnm"));
							if(grd_select.findRow(finddata,grd_select.fixedRows,  grd_select.colRef("itemnm"),true,true) != -1){
								messageBox("동일 항목이 이미 존재하므로 추가","E001");
								return;
							}
              
						misfGridIUD(grd_select, "A","N");
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/itemcls", grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("itemcls")));
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/itemclsnm", cmb_itemcls.label);
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/itemnm", grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("itemnm")));
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/itemkind", grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("itemkind")));
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/tblschema", grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("tblschema")));
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/tablenm", grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("tablenm")));
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/colnm", grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("colnm")));
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/cdtblschema", grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("cdtblschema")));
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/cdtblnm", grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("cdtblnm")));
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/codeflag", grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("codeflag")));
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/funcyn", grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("funcyn")));
						model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/sumyn", "N");
						
						if (grd_tblcode.valueMatrix(cur_row, grd_tblcode.colRef("funcyn")) == "Y") {
							model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/funcflag", cmb_funcflag.value);
						}
						else {
							model.setValue(grd_select.attribute("nodeset") + "["+(grd_select.row - grd_select.fixedRows + 1)+"]/funcflag", "01");
						}
						
					
					}
					grd_select.refresh();

				}
				function fSettingQuery(){
					//인사 조건 검색을 사전 작업을 진행한다
					submit("TXRPB01703");
					if (model.getValue(gvErrorMsgPath + "/type") != "error")
					{
						//조건항목과 검색항목의 존재여부를 체크한다
						if(grd_where.rows - grd_where.fixedRows == 0){
							messageBox("조건항목이 입력되지 않았습니다. 실행","E001");
							return;
						}
						if(grd_select.rows - grd_select.fixedRows == 0){
							messageBox("검색항목이 입력되지 않았습니다. 실행","E001");
							return;
						}
						 
						if(!checkKeyColumn("grd_where","grd_select")) return;	
						
						//조건을 위해 사용자가 반드시 입력해야 하는 조건들을 체크한다
						model.setValue(txt_fromqry.attribute("ref"),fGetFromQuery());//From절 Query 를 생성한다
						model.setValue(txt_whereqry.attribute("ref"), fGetWhereQuery()); //Where절 Query를 생성한다
						model.setValue(txt_selectqry.attribute("ref"), fGetSelectQuery());//Select절 Query를 생성한다
						model.refresh();	

						var strquery = model.getValue(txt_selectqry.attribute("ref")) + "\n" + model.getValue(txt_fromqry.attribute("ref"))  + "\n" + model.getValue(txt_whereqry.attribute("ref"));
						
						misfGridInit(grd_query);
						misfGridIUD(grd_query,"A","N");
						model.setValue(grd_query.attribute("nodeset")+"["+(grd_query.row - grd_query.fixedRows + 1)+"]/strqry", strquery);
						model.setValue(grd_query.attribute("nodeset")+"["+(grd_query.row - grd_query.fixedRows + 1)+"]/title", fGetTitle());

						model.setValue(grd_query.attribute("nodeset")+"["+(grd_query.row - grd_query.fixedRows + 1)+"]/titlecnt",(grd_select.rows- grd_select.fixedRows));
						
						//Grid화면에 보여줄 Column의 이름을 읽어온다
						model.setValue(grd_query.attribute("nodeset")+"["+(grd_query.row - grd_query.fixedRows + 1)+"]/titlenm",fGetColNm());
						//Grid Column의 Column Type를 지정한다
						model.setValue(grd_query.attribute("nodeset")+"["+(grd_query.row - grd_query.fixedRows + 1)+"]/coltype",fGetColType());
						//소계칼럼을 지정 한다.
						model.setValue(grd_query.attribute("nodeset")+"["+(grd_query.row - grd_query.fixedRows + 1)+"]/sumyn",fGetSubTotal());
						//소계계산할칼럼을 지정 한다.
						model.setValue(grd_query.attribute("nodeset")+"["+(grd_query.row - grd_query.fixedRows + 1)+"]/funcyn",fGetFuncYn());
						
								
						rpbfOpenPopUpList("SMRPB01703",grd_query,"strqry,title,titlecnt,titlenm,coltype,sumyn,funcyn","strqry,title,titlecnt,titlenm,coltype,sumyn,funcyn");
					}
				}
				
				function fGetColType(){

					var itemtype = "";
					for(row = grd_select.fixedRows; row < grd_select.rows ; row++){
						//항목절에 급여항목이 존재한다면, 급여항목비용도 자동으로 보여주기로 하였으므로
						//급여항목내용에 관한 Format인 Text와 급여항목비용에 해당하는 Format은 Money를 추가해주기로 한다
						itemtype = itemtype + grd_select.valueMatrix(row , grd_select.colRef("itemkind"))+ ",";
					}
					
					if(itemtype.length > 0){
						itemtype = itemtype.substr(0, (itemtype.length - 1))
					}
					return itemtype;
				}
				
				function fGetSubTotal() {
					var subtotal = "";
					for(row = grd_select.fixedRows; row < grd_select.rows ; row++){
						subtotal = subtotal + grd_select.valueMatrix(row , grd_select.colRef("sumyn"))+ ",";
					}
					
					if(subtotal.length > 0){
						subtotal = subtotal.substr(0, (subtotal.length - 1))
					}
					return subtotal;
				}
				
				function fGetFuncYn() {
					var funcyn = "";
					for(row = grd_select.fixedRows; row < grd_select.rows ; row++){
						funcyn = funcyn + grd_select.valueMatrix(row , grd_select.colRef("funcyn"))+ ",";
					}
					
					if(funcyn.length > 0){
						funcyn = funcyn.substr(0, (funcyn.length - 1))
					}
					return funcyn;
				}

				function fGetColNm(){

					var colnm = "";
					for(row = grd_select.fixedRows; row < grd_select.rows ; row++){
						colnm = colnm + grd_select.valueMatrix(row , grd_select.colRef("colnm"))+ ",";
					}
					
					if(colnm.length > 0){
						colnm = colnm.substr(0, (colnm.length - 1))
					}
					return colnm;
				}

				function fGetTitle(){

					var title = "";
					for(row = grd_select.fixedRows; row < grd_select.rows ; row++){
						title = title + grd_select.valueMatrix(row , grd_select.colRef("itemnm")) + "^";
					}
					
					if(title.length > 0){
						title = title.substr(0, (title.length - 1))
					}
					return title;
				}

				function fGetFromQuery(){
					//규칙1 : 기본적으로 From에 해당하는 테이블에 대한 Alias는 테이블명으로 동시처리한다
					//규칙2 : 급여항목에 관계된 내용이 있을경우 내부적으로 급여비용에 테이블과 동시 Join조건으로 추가해준다
					//규칙3 : 급여항목이 존재할 경우 급여항목명 테이블도 동시 Join조건으로 추가해준다
					var strfrom = "";
					for(var row = grd_where.fixedRows ; row < grd_where.rows ; row++){

						var tgtschema = grd_where.valueMatrix(row , grd_where.colRef("tblschema")); //테이블스키마
						var tgttable = grd_where.valueMatrix(row , grd_where.colRef("tablenm")); //테이블명

						var colnm = grd_where.valueMatrix(row , grd_where.colRef("colnm")); //컬럼이름
						var operator = grd_where.valueMatrix(row , grd_where.colRef("operator")); //연산자
						var conector = grd_where.valueMatrix(row , grd_where.colRef("conector")); // 연결자
						var condvalu1 = grd_where.valueMatrix(row , grd_where.colRef("condvalu1")); //조건값1
						var condvalu2 = grd_where.valueMatrix(row , grd_where.colRef("condvalu2")); //조건값2

						var tgttblalias = tgtschema + "." + tgttable;

						var tgtstrfrom = grd_where.valueMatrix(row , grd_where.colRef("tblschema"))  +"." + grd_where.valueMatrix(row , grd_where.colRef("tablenm"));
						
						var chkfind = false;
						var findrow = -1;
						
						//현재 From절에 추가될 테이블이 이전 Row에 존재했었는지 체크
						for(var tblrow = grd_where.fixedRows ; tblrow < row ; tblrow++){
							if(grd_where.valueMatrix(tblrow , grd_where.colRef("tablenm")) == tgttable){
								chkfind = true;
								findrow = tblrow;
								break;
							}
						}
						
						if(!chkfind){
							//이전 Row에서도 추가된적이 없는 Table이라면 새로운 TableAlias를 입력한다
							model.setValue(grd_where.attribute("nodeset")+"["+(row - grd_where.fixedRows + 1)+"]/tblalias", tgttable + (row));
						}
						else{
							//현재 From절에 추가될 대상 테이블이 이전Row에서 이미 처리했었다면
							//현재 Row에 동일 테이블 alias를 setting해준다
							var tmpalias = grd_where.valueMatrix(findrow , grd_where.colRef("tblalias"));
							model.setValue(grd_where.attribute("nodeset")+"["+(row - grd_where.fixedRows + 1)+"]/tblalias", tmpalias);
						}	
						
						if(strfrom.length == 0){
							strfrom = " FROM " + tgtstrfrom + " MAINTBL \n";
							model.setValue(grd_where.attribute("nodeset")+"["+(row - grd_where.fixedRows + 1)+"]/tblalias", "MAINTBL");
							
						}
						else{
							if(!chkfind){
								//이전에 급여항목에 관계된 테이블이 존재하지 않았다면
								var curalias = (tgttable + (row));
								//급여에 관계된 항목이 아니라면 테이블간 emplno로 join처리한다
								strfrom = strfrom + "INNER JOIN " + tgtstrfrom + " " + (tgttable + (row)) + " ON " +  curalias + ".emplno = MAINTBL.emplno  \n";
								model.setValue(grd_where.attribute("nodeset")+"["+(row - grd_where.fixedRows + 1)+"]/tblalias", tgttable + (row));
							}
						}
					}
					
					//목적:인사 마스터 테이블이 존재할 경우 해당 row의 alias를 읽어와 부서정보의 기관정보를 join할때 같이 처리해 주도록 한다
					//인사마스터 테이블이 존재한다면 인사마스터에 해당하는 테이블 alias를 별도 element에 setting한다
					var memplrow = grd_where.findRow("RPBVEMPC", grd_where.fixedRows , grd_where.colRef("tablenm"),false,false);
					if(memplrow != -1){
						var memplalias = grd_where.valueMatrix(memplrow, grd_where.colRef("tblalias"));
						model.setValue(ipt_mplemplno.attribute("ref"), memplalias);
					}
					else {
						var memplrow = grd_where.findRow("RPBGVMVV", grd_where.fixedRows , grd_where.colRef("tablenm"),false,false);
						
						if(memplrow != -1){
							var memplalias = grd_where.valueMatrix(memplrow, grd_where.colRef("tblalias"));
							model.setValue(ipt_mplemplno.attribute("ref"), memplalias);

						}
						else {
							strfrom = strfrom + "INNER JOIN " + "MIS.RPBVEMPC  EMPC  ON "  +  "MAINTBL.emplno = EMPC.emplno " + " \n" ;

						}
					}
					
					return strfrom;
				}
				
				function fGetWhereQuery(){
					var strwhere = "";
					var maxalias = 9999;
					var addfromqry = "";
					var oldtablenm = "";
					var oldtblalias = "";
					var maintblalias = grd_where.valueMatrix(grd_where.fixedRows , grd_where.colRef("tblalias"));
					
					for(var row = grd_where.fixedRows; row < grd_where.rows ; row++){
						var itemnm = grd_where.valueMatrix(row , grd_where.colRef("itemnm"));
						var colnm = grd_where.valueMatrix(row , grd_where.colRef("colnm"));
						var operator = grd_where.valueMatrix(row , grd_where.colRef("operator"));
						var conector = grd_where.valueMatrix(row , grd_where.colRef("conector"));
						var condvalu1 = grd_where.valueMatrix(row , grd_where.colRef("condvalu1"));
						var condvalu2 = grd_where.valueMatrix(row , grd_where.colRef("condvalu2"));
						var tblalias = grd_where.valueMatrix(row , grd_where.colRef("tblalias"));
						
						var tgttable = grd_where.valueMatrix(row , grd_where.colRef("tablenm")); //테이블명
						
						var condsql = "";
						
						if (oldtablenm == "RPBGVMVV" && tgttable != "RPBGVMVV") {
							condsql = " AND " + "NVL(" + oldtblalias + "." + "DELYN,'N') != 'Y'" + "\n";
						}
						
						if(conector == "AND"){
							if(operator == "BETWEEN"){
								condsql =  "(" +  tblalias + "." + colnm  + " " + operator + " " + condvalu1 +  " AND " + condvalu2 + ")" + "\n";
							}
							else if(operator == "IN" || operator == "NOT IN"){
								condsql =   tblalias + "." + colnm + " " + operator + " (" + condvalu1 + ")\n";
							}
							else{
//								if( (itemnm == "소속부서" || itemnm == "근무부서" || itemnm == "겸직부서" ) && (operator == "=") ){
//									maxalias = maxalias -1;
//									var tmpsubalias = "ZSDDDEPT" + (maxalias);
//									
//									//상위,하위부서를 읽기 위한 테이블을 추가한다
//									var memplrow = grd_where.findRow("RPBVEMPC" , grd_where.fixedRows, grd_where.colRef("tablenm"), true, true);
//									var memplalias = "";
//									
//									
//									if(memplrow != -1){
//										//인사마스터와 관계된 조건이 존재한다면 인사마스터에 해당하는 alias로 기관정보를 읽어온다
//										memplalias = grd_where.valueMatrix(memplrow, grd_where.colRef("tblalias"));
//									}
//									else{
//										//인사마스터와 관계된 조건이 존재하지 않는다면
//										//인사마스터를 join조건으로 자동으로 추가한후 추가한 인사마스터와 하위부서를 읽기위한 테이블을 join 처리한다
//										maxalias = maxalias -1;
//										memplalias = "RPBVEMPC" + (maxalias);
//										model.setValue(ipt_mplemplno.attribute("ref"), tmpsubempalias);
//									}
//
//									if (itemnm == "소속부서") {
//										addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".INSTCD" +
//															" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".UNITCD \n";
//									}
//									else if (itemnm == "겸직부서") {
//										addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".DUPINSTCD" +
//															" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DUPUNITCD \n";	
//									}
//									else {
//										addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".DUTPLCEINST" +
//															" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DUTUNITCD \n";
//									}
//									
//									addfromqry = addfromqry + " AND TO_CHAR( sysdate, 'yyyymmdd') BETWEEN " + tmpsubalias + ".VALIFROMDD AND "  + tmpsubalias + ".VALITODD \n";
//									condsql = "";
//								}  
//								else{
									condsql =   tblalias + "." + colnm + " " + operator + " " + condvalu1 + "\n";
//								}
							}
							
							if(strwhere.length == 0){
								condsql =  " WHERE " + condsql;
							}
							else{
								condsql =  " AND " + condsql;
							}
							
						}
						else {
							var chkor = false;
							var findrow = -1;
							
							for(var subrow = grd_where.rows ; subrow > row  ; subrow--){
								
								if(grd_where.valueMatrix(subrow , grd_where.colRef("conector")) == "OR"){
									chkor = true;
									findrow = subrow;
									break;
								}
							}
							
							if(!chkor){
								var tmpcondsql1 ;
								if(operator == "BETWEEN"){
									tmpcondsql1 =  "(" +  tblalias + "." + colnm  + " " + operator + " " + condvalu1 + " AND " + condvalu1 + ")";
								}
								else if(operator == "IN" || operator == "NOT IN"){
									tmpcondsql1 =   tblalias + "." + colnm + " " + operator + " (" + condvalu1 + ") ";
								}
								else{
																	//소속부서와 근무부서가 조건절로 들어갈 경우 다른 부서조건과는 다르게 상위부서를 읽어온다
//									if( (itemnm == "소속부서" || itemnm == "근무부서" || itemnm == "겸직부서") && (operator == "=") ){
//										maxalias = maxalias -1;
//										var tmpsubalias = "ZSDDDEPT" + (maxalias);
//										
//										//상위,하위부서를 읽기 위한 테이블을 추가한다
//										var memplrow = grd_where.findRow("RPBVEMPC" , grd_where.fixedRows, grd_where.colRef("tablenm"), true, true);
//										var memplalias = "";
//										
//										if(memplrow != -1){
//											//인사마스터와 관계된 조건이 존재한다면 인사마스터에 해당하는 alias로 기관정보를 읽어온다
//											memplalias = grd_where.valueMatrix(memplrow, grd_where.colRef("tblalias"));
//										}
//										else{
//											//인사마스터와 관계된 조건이 존재하지 않는다면
//											//인사마스터를 join조건으로 자동으로 추가한후 추가한 인사마스터와 하위부서를 읽기위한 테이블을 join 처리한다
//											maxalias = maxalias -1;
//											memplalias = "RPBVEMPC" + (maxalias);
//											model.setValue(ipt_mplemplno.attribute("ref"), tmpsubempalias);
//										}
//	
//										if (itemnm == "소속부서") {
//											addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".INSTCD" +
//																" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".UNITCD \n";
//										}
//										else if (itemnm == "겸직부서") {
//											addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".DUPINSTCD" +
//																" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DUPUNITCD \n";
//										}
//										else {
//											addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".DUTPLCEINST" +
//																" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DUTUNITCD \n";
//										}
//										
//										addfromqry = addfromqry + " AND TO_CHAR( sysdate, 'yyyymmdd') BETWEEN " + tmpsubalias + ".VALIFROMDD AND "  + tmpsubalias + ".VALITODD \n"; 
//										addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".INSTCD" +
//										                    " AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DEPTCD \n";
//										                    
//										tmpcondsql1 = "";					
//	
//									}
//									else{
										tmpcondsql1 =   tblalias + "." + colnm + " " + operator + " " + condvalu1 ;
//									}
								}
							
								row= row +1;
								var tmpcolnm = grd_where.valueMatrix(row , grd_where.colRef("colnm"));
								var tmptblalias = grd_where.valueMatrix(row, grd_where.colRef("tblalias"));
								var tmpoperator = grd_where.valueMatrix(row, grd_where.colRef("operator"));
								var tmpcondvalu1 = grd_where.valueMatrix(row, grd_where.colRef("condvalu1"));
								var tmpcondvalu2 = grd_where.valueMatrix(row, grd_where.colRef("condvalu2"));
								var tmpitemnm = grd_where.valueMatrix(row, grd_where.colRef("itemnm"));
		
								var tmpcondsql2 ;
								if(operator == "BETWEEN"){
									tmpcondsql2 =  "(" +  tmptblalias + "." + tmpcolnm  + " " + tmpoperator + " " + tmpcondvalu1 + " AND " + tmpcondvalu2 + ")" ;
								}
								else if(operator == "IN" || operator == "NOT IN"){
									tmpcondsql2 =   tmptblalias + "." + tmpcolnm + " " + tmpoperator + " (" + tmpcondvalu1 + ") ";
								}
								else{
									//소속부서와 근무부서가 조건절로 들어갈 경우 다른 부서조건과는 다르게 상위부서를 읽어온다
//									if( (itemnm == "소속부서" || itemnm == "근무부서" || itemnm == "겸직부서" ) && (operator == "=") ){
//										maxalias = maxalias -1;
//										var tmpsubalias = "ZSDDDEPT" + (maxalias);
//										
//										//상위,하위부서를 읽기 위한 테이블을 추가한다
//										var memplrow = grd_where.findRow("RPBVEMPC" , grd_where.fixedRows, grd_where.colRef("tablenm"), true, true);
//										var memplalias = "";
//										
//										if(memplrow != -1){
//											//인사마스터와 관계된 조건이 존재한다면 인사마스터에 해당하는 alias로 기관정보를 읽어온다
//											memplalias = grd_where.valueMatrix(memplrow, grd_where.colRef("tblalias"));
//										}
//										else{
//											//인사마스터와 관계된 조건이 존재하지 않는다면
//											//인사마스터를 join조건으로 자동으로 추가한후 추가한 인사마스터와 하위부서를 읽기위한 테이블을 join 처리한다
//											maxalias = maxalias -1;
//											memplalias = "RPBVEMPC" + (maxalias);
//											model.setValue(ipt_mplemplno.attribute("ref"), tmpsubempalias);
//										}
//										
//										if (itemnm == "소속부서") {
//											addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".INSTCD" +
//																" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".UNITCD \n";
//										}
//										else if (itemnm == "겸직부서") {
//											addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".DUPINSTCD" +
//																" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DUPUNITCD \n";
//										}
//										else {
//											addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".DUTPLCEINST" +
//																" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DUTUNITCD \n";
//										}
//
//										addfromqry = addfromqry + " AND TO_CHAR( sysdate, 'yyyymmdd') BETWEEN " + tmpsubalias + ".VALIFROMDD AND "  + tmpsubalias + ".VALITODD \n"; 
//										
//										tmpcondsql2 = "";
//	
//									}									
//									else{
										tmpcondsql2 =   tmptblalias + "." + tmpcolnm + " " + tmpoperator + " " + tmpcondvalu1 ;
//									}
								
								}
								
								condsql = "(" + tmpcondsql1 + " " + conector + "  " + tmpcondsql2 + ")";
								
							}
							else{
								
								for(var mtlrow = row ; mtlrow < findrow + 1 ; mtlrow++)
								{
									var tmpcondsql;
									var tmpcolnm = grd_where.valueMatrix(mtlrow , grd_where.colRef("colnm"));
									var tmptblalias = grd_where.valueMatrix(mtlrow, grd_where.colRef("tblalias"));
									var tmpoperator = grd_where.valueMatrix(mtlrow, grd_where.colRef("operator"));
									var tmpcondvalu1 = grd_where.valueMatrix(mtlrow, grd_where.colRef("condvalu1"));
									var tmpcondvalu2 = grd_where.valueMatrix(mtlrow, grd_where.colRef("condvalu2"));
									var tmpitemnm = grd_where.valueMatrix(mtlrow, grd_where.colRef("itemnm"));
										
									if(tmpoperator == "BETWEEN"){
										tmpcondsql =  "(" +  tmptblalias + "." + tmpcolnm  + " " + tmpoperator + " " + tmpcondvalu1 + " AND " + tmpcondvalu2 + ")" ;
									}
									else if(tmpoperator == "IN" || tmpoperator == "NOT IN"){
										tmpcondsql =   tmptblalias + "." + tmpcolnm + " " + tmpoperator + " (" + tmpcondvalu1 + ") ";
									}
									else{
																			//소속부서와 근무부서가 조건절로 들어갈 경우 다른 부서조건과는 다르게 상위부서를 읽어온다
//										if( (itemnm == "소속부서" || itemnm == "근무부서" || itemnm == "겸직부서") && (operator == "=") ){
//											maxalias = maxalias -1;
//											var tmpsubalias = "ZSDDDEPT" + (maxalias);
//											
//											//상위,하위부서를 읽기 위한 테이블을 추가한다
//											var memplrow = grd_where.findRow("RPBVEMPC" , grd_where.fixedRows, grd_where.colRef("tablenm"), true, true);
//											var memplalias = "";
//											
//											if(memplrow != -1){
//												//인사마스터와 관계된 조건이 존재한다면 인사마스터에 해당하는 alias로 기관정보를 읽어온다
//												memplalias = grd_where.valueMatrix(memplrow, grd_where.colRef("tblalias"));
//											}
//											else{
//												//인사마스터와 관계된 조건이 존재하지 않는다면
//												//인사마스터를 join조건으로 자동으로 추가한후 추가한 인사마스터와 하위부서를 읽기위한 테이블을 join 처리한다
//												maxalias = maxalias -1;
//												memplalias = "RPBVEMPC" + (maxalias);
//												model.setValue(ipt_mplemplno.attribute("ref"), tmpsubempalias);
//											}
//												
//											if (itemnm == "소속부서") {
//												addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".INSTCD" +
//																	" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".UNITCD \n";
//											}
//											else if (itemnm == "겸직부서") {
//												addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".DUPINSTCD" +
//																	" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DUPUNITCD \n";
//											}
//											else {
//												addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".DUTPLCEINST" +
//																	" AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DUTUNITCD \n";
//											}
//											addfromqry = addfromqry + " AND TO_CHAR( sysdate, 'yyyymmdd') BETWEEN " + tmpsubalias + ".VALIFROMDD AND "  + tmpsubalias + ".VALITODD \n"; 
//											
//											tmpcondsql = "";
//										}
//										else{
											tmpcondsql =   tmptblalias + "." + tmpcolnm + " " + tmpoperator + " " + tmpcondvalu1 ;
//										}
									}	
									
									if(condsql.length == 0){
										condsql = "( " + tmpcondsql + " " + conector + " ";
									}
									else{
										if(mtlrow != findrow){
											condsql = condsql + " " +  tmpcondsql + " " + conector + " ";
										}
										else{
											condsql = condsql + " " +  tmpcondsql + " )";
										}
									}
								}
								row = findrow;


							}
							if(strwhere.length == 0){
								condsql =  " WHERE " + condsql;
							}
							else{
								condsql =  " AND " + condsql;
							}
							
						}
						strwhere = strwhere + condsql;
						
						oldtablenm = tgttable;
						oldtblalias = tblalias;
					}
					
					//alert(oldtablenm);
					if (oldtablenm == "RPBGVMVV" ) {
							strwhere = strwhere + " AND " + "NVL(" + oldtblalias + "." + "DELYN,'N') != 'Y'" + "\n";
					}
					
					//급여항목에 관계된 테이블이 존재하면서 급여항목명을 읽어와야 하는 항목이 존재한다면
					//where절에 급여항목명 조회를 위해 아래와 같은 문자을 자동추가한다
					if(addfromqry.length > 0){
						var fromqry = model.getValue(txt_fromqry.attribute("ref"));
						
						model.setValue(txt_fromqry.attribute("ref"), fromqry + "\n" + addfromqry);
					}
					
					return strwhere;
				}
				
				function fGetSelectQuery(){
					var maxalias = 999;
					
					var selectqry = "";
					var addfromqry = "";
					var chkyn = "N";
					var maintblalias = grd_where.valueMatrix(grd_where.fixedRows , grd_where.colRef("tblalias"));
					var emplalias = model.getValue(ipt_mplemplno.attribute("ref"));
					
					var arralias = new Array();
					var arrtable = new Array();
					var arrcnt = 0;
					var groupby = "";
					var groupchk = "N";
					var orderby = "";
					var orderchk = "N";

					for(var row = grd_select.fixedRows ; row < grd_select.rows ; row++){
						var colnm = grd_select.valueMatrix(row , grd_select.colRef("colnm")); //칼럼이름
						var tblschema = grd_select.valueMatrix(row , grd_select.colRef("tblschema")); //테이블스키마
						var tablenm = grd_select.valueMatrix(row , grd_select.colRef("tablenm")); //테이블명
						var cdtblschema = grd_select.valueMatrix(row , grd_select.colRef("cdtblschema")); //코드테이블스키마
						var cdtblnm = grd_select.valueMatrix(row , grd_select.colRef("cdtblnm")); //코드테이블명
						var codeflag = grd_select.valueMatrix(row , grd_select.colRef("codeflag")); //코드구분ID(CDSID)
						var itemnm = grd_select.valueMatrix(row , grd_select.colRef("itemnm")); //칼럼명칭
						var funcflag = grd_select.valueMatrix(row , grd_select.colRef("funcflag")); //함수구분
						var func = "";
						var lastfunc = "";
						var tmpgroupby = "";
						var sumyn = grd_select.valueMatrix(row , grd_select.colRef("sumyn")); //소계여부
						
						if (funcflag == "01") { //미적용
							func = "";
							lastfunc = ""
						}
						else if (funcflag == "02") { //합계
							func = "trunc(sum(";
							lastfunc = "),2)"
							groupchk = "Y";
						}
						else if (funcflag == "03") { //평균
							func = "trunc(avg(";
							lastfunc = "),2)"
							groupchk = "Y";
						}
						else {
							func = "";
							lastfunc = ""
						}
						
						//findrow = -1;
						var findrow = grd_where.findRow(tablenm ,grd_where.fixedRows, grd_where.colRef("tablenm")); //테이블명칭
						
//						alert(tablenm);
//						alert(itemnm);
//						alert(cdtblnm);
//						alert(findrow);
						
						chkyn = "N";

//						if (findrow == -1 && cdtblnm != "ZBCMCODE" && cdtblnm != "ZSDDDEPT" && cdtblnm != "RWCMPYTL") { 
						if (findrow == -1 ) { 
//							alert(row);
							for (var k = row - 1 ; k >= grd_select.fixedRows; k--) {
								
//								alert(k);
//								alert(tablenm);
//								alert(grd_select.valueMatrix(k, grd_select.colRef("tablenm")));
								
								if (tablenm == grd_select.valueMatrix(k, grd_select.colRef("tablenm"))) {
									chkyn = "Y";
									findrow = row;
								}
							}
						}
						
						
						var tblalias = "";
						
						var tmpquery = "";
						
						if(findrow == -1){
							//항목에는 추가되었으나 조건절에 해당 테이블에 관계되는  조건이 존재하지 않는다면
							//항목을 보여주기 위해 from 절에 join조건을 자동추가한다
							
							if (tablenm == "RPBVEMPC") {
								var tmpalias = "EMPC";
							}
							else {
								maxalias = maxalias -1;
								var tmpalias = tablenm + (maxalias);
							}
								
							
							
							//항목절에 급여에 관계된 항목이 존재할경우 From절 생성 로직에서 급여테이블을 join걸어주었으므로
							//여기서는 추가해줄 필요가없으며,
							//그 이전에 항목에 급여에 관계된 항목이 존재하면 반드시 조건절에 급여지급월을 입력하도록 하였으므로
							//급여관계 테이블이 from절에 join되지 않고 넘어오는 경우는 존재하지 않는다
							arralias[arrcnt] = tmpalias;
							arrtable[arrcnt] = tablenm;
							
							tblalias = tmpalias;
							
							
						}
						else{
							if (chkyn == "Y") {
								for (var z = 0; z < arrtable.length; z++) {
									if (arrtable[z] == tablenm) {
										tblalias = arralias[z];
									}
								}
							}
							else {
								tblalias = grd_where.valueMatrix(findrow , grd_where.colRef("tblalias"));
							}
						}
						
						if(cdtblnm.length > 0){
							
							if(cdtblnm == "ZBCMCODE"){
								//공통코드와 연계된 항목이라면
								maxalias = maxalias -1;
								var tmpalias = tablenm + (maxalias);
								addfromqry = addfromqry + " LEFT OUTER JOIN " + cdtblschema + "." + cdtblnm + " " + 	tmpalias + " ON " +  	tmpalias + ".cdsid = '" + codeflag + "'||" + tblalias + "." +  colnm + " \n";

								tmpquery = " " + func + tmpalias + ".cdnm " + lastfunc + " as " + colnm + "\n";
								tmpgroupby = " " + func + tmpalias + ".cdnm " + lastfunc + "\n";
							}
							else if (cdtblnm == "ZSDDDEPT" && tablenm == "RPBGVMVV" ){
								if (colnm == "DEPTCD" || colnm == "TEAMCD" || colnm == "UNITCD") {
							 		tmpquery = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".INSTCD, " + tblalias + "." + colnm + ", " + tblalias + ".gvnoffcorddd )"  + " as " + colnm + "\n";
									tmpgroupby = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".INSTCD, " + tblalias + "." + colnm + ", " + tblalias + ".gvnoffcorddd )"  +  "\n";
									
								}
								else if (colnm == "DUTDEPTCD" || colnm == "DUTTEAMCD" || colnm == "DUTUNITCD" || colnm == "DUTPLCEDEPTCD") {
									tmpquery = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".DUTPLCEINST, " + tblalias + "." + colnm + ", " + tblalias + ".gvnoffcorddd )"  + " as " + colnm + "\n";
									tmpgroupby = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".DUTPLCEINST, " + tblalias + "." + colnm + ", " + tblalias + ".gvnoffcorddd )"  +  "\n";
								}else if (colnm == "DUPDEPTCD" || colnm == "DUPTEAMCD" || colnm == "DUPUNITCD") {
									tmpquery = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".DUPINSTCD, " + tblalias + "." + colnm + ", " + tblalias + ".gvnoffcorddd )" + " as " + colnm + "\n";
									tmpgroupby = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".DUPINSTCD, " + tblalias + "." + colnm + ", " + tblalias + ".gvnoffcorddd )" +  "\n";
								}else if (colnm == "ORGDEPTCD" ) {
									tmpquery = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".ORGINSTCD, " + tblalias + "." + colnm + ", " + tblalias + ".gvnoffcorddd )"  + " as " + colnm + "\n";
									tmpgroupby = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".ORGINSTCD, " + tblalias + "." + colnm + ", " + tblalias + ".gvnoffcorddd )"  +  "\n";
								}
							}	
							else if (cdtblnm == "ZSDDDEPT" && (tablenm == "RPBDACHV"  || tablenm == "RPBDACIT") ){
								if (colnm == "DEPTCD" ) {
							 		tmpquery = " COM.FN_ZS_GETDEPTNM('103', " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  + " as " + colnm + "\n";
									tmpgroupby = " COM.FN_ZS_GETDEPTNM('103', " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  +  "\n";
								}
								else if (colnm == "UNITCD" ) {
									tmpquery = " COM.FN_ZS_GETDEPTNM(" + tblalias + ".INSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  + " as " + colnm + "\n";
									tmpgroupby = " COM.FN_ZS_GETDEPTNM(" + tblalias + ".INSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  +  "\n";
								}
							}
							else if (cdtblnm == "ZSDDDEPT" && tablenm != "RPBGVMVV" ){
								if (colnm == "DEPTCD" || colnm == "TEAMCD" || colnm == "UNITCD") {
							 		tmpquery = " COM.FN_ZS_GETDEPTNM(" + tblalias + ".INSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  + " as " + colnm + "\n";
									tmpgroupby = " COM.FN_ZS_GETDEPTNM(" + tblalias + ".INSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  +  "\n";
								}
								else if (colnm == "DUTDEPTCD" || colnm == "DUTTEAMCD" || colnm == "DUTUNITCD" || colnm == "DUTPLCEDEPTCD") {
									tmpquery = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".DUTPLCEINST, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  + " as " + colnm + "\n";
									tmpgroupby = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".DUTPLCEINST, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  +  "\n";
								}else if (colnm == "DUPDEPTCD" || colnm == "DUPTEAMCD" || colnm == "DUPUNITCD") {
									tmpquery = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".DUPINSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )" + " as " + colnm + "\n";
									tmpgroupby = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".DUPINSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )" + "\n";
								}else if (colnm == "ORGDEPTCD" ) {
									tmpquery = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".ORGINSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  + " as " + colnm + "\n";
									tmpgroupby = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".ORGINSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  +  "\n";
								}
							}	
						}
						else{
							
							tmpquery = func + tblalias + "." + colnm + lastfunc + " as " + colnm + "\n";
							tmpgroupby = func + tblalias + "." + colnm + lastfunc + "\n";
						}
						
						
						if (funcflag == "01" ) {
							if (groupby.length ==  0) {
								groupby = "group by " + tmpgroupby;
							}
							else {
								groupby = groupby + "," + tmpgroupby;
							}
						}
						
						if (sumyn == "Y") {
							orderchk = "Y";
							if (orderby.length == 0) {
								orderby = "order by " + tmpgroupby;
							}
							else {
								orderby = orderby + "," + tmpgroupby;
							}
						}
						
						
						if(selectqry.length == 0){
							selectqry = "SELECT " + tmpquery;
						}						
						else{
							selectqry = selectqry + ", " + tmpquery;
						}
					}
					
					//select절을 추가하기위해서 필요한  from절의 join조건들은 fromquery에 추가 setting한다
					if(addfromqry.length > 0){
						var fromqry = model.getValue(txt_fromqry.attribute("ref"));
						model.setValue(txt_fromqry.attribute("ref"), fromqry + "\n" + addfromqry);
					}
					
					if(groupchk == "Y"){
						var whereqry = model.getValue(txt_whereqry.attribute("ref"));
						model.setValue(txt_whereqry.attribute("ref"), whereqry + "\n" + groupby);
					}
					
					if(orderchk == "Y"){
						var whereqry = model.getValue(txt_whereqry.attribute("ref"));
						model.setValue(txt_whereqry.attribute("ref"), whereqry + "\n" + orderby);
					}
					
					return selectqry;
				}
				
				function fSelectSortKey(pflag){

					var cnt = 1;	
					var focusrow = -1;
					for(var row = grd_select.fixedRows ; row < grd_select.rows; row++){
						var data = grd_select.valueMatrix(row , grd_select.colRef("itemnm"));
						
						 var findnode = instance1.selectNodes("/root/main/list/tableselect" + "/*");	
						 for(var index = 0; index <= findnode.length ; index++){
						 	var curdata = model.getValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/itemnm");
						 	if(curdata == data){
						 		model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/sortkey", cnt);
						 		break;
						 	}
						 }			
						cnt++;
					}
				
					if(pflag == "U"){
						if (grd_select.row == grd_select.fixedRows) {
							model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + (grd_select.row - grd_select.fixedRows + 1) + "]/sortkey", 
													grd_select.rows - grd_select.fixedRows + 1);
													
							var findnode = instance1.selectNodes("/root/main/list/tableselect" + "/*");	
							for (var index = 1; index <= findnode.length ; index++){
								model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/sortkey", 
									parseInt(model.getValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/sortkey")) - 1 );
							}
							
							focusrow = grd_select.rows - grd_select.fixedRows;
						}
						else {
							model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + (grd_select.row - grd_select.fixedRows + 1) + "]/sortkey", 
													model.getValue("/root/main/list/tableselect/tableselectlist" + "[" + (grd_select.row - grd_select.fixedRows) + "]/sortkey") );
													
							model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + (grd_select.row - grd_select.fixedRows ) + "]/sortkey", 
													parseInt(model.getValue("/root/main/list/tableselect/tableselectlist" + "[" + (grd_select.row - grd_select.fixedRows) + "]/sortkey")) + 1 );
													
							focusrow = grd_select.row - grd_select.fixedRows;						
						}
						
//						for(var row = grd_select.fixedRows ; row < grd_select.rows; row++){
//							var seqno = grd_select.valueMatrix(row , grd_select.colRef("sortkey"));
//							if(seqno ==  1)seqno = (grd_select.rows - grd_select.fixedRows);
//							else seqno = seqno - 1;
//							var data = grd_select.valueMatrix(row , grd_select.colRef("itemnm"));
//	
//							 var findnode = instance1.selectNodes("/root/main/list/tableselect" + "/*");	
//							 for(var index = 0; index <= findnode.length ; index++){
//							 	var curdata = model.getValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/itemnm");
//							 	if(curdata == data){
//							 		model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/sortkey", seqno);
//							 		break;
//							 	}
//							 }								
//						}
					}
					else{
						if (grd_select.row == grd_select.rows-grd_select.fixedRows) {
							model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + (grd_select.row - grd_select.fixedRows + 1) + "]/sortkey", 
													grd_select.fixedRows);
													
							var findnode = instance1.selectNodes("/root/main/list/tableselect" + "/*");	
							for (var index = 1; index <= findnode.length - 1; index++){
								model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/sortkey", 
									parseInt(model.getValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/sortkey")) + 1 );
							}
							
							focusrow = grd_select.fixedRows;
						}
						else {
							model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + (grd_select.row - grd_select.fixedRows + 1) + "]/sortkey", 
													model.getValue("/root/main/list/tableselect/tableselectlist" + "[" + (grd_select.row - grd_select.fixedRows + 2) + "]/sortkey") );
													
							model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + (grd_select.row - grd_select.fixedRows + 2) + "]/sortkey", 
													parseInt(model.getValue("/root/main/list/tableselect/tableselectlist" + "[" + (grd_select.row - grd_select.fixedRows + 2) + "]/sortkey")) - 1 );
													
							focusrow = grd_select.row - grd_select.fixedRows + 2;						
						}						
//						for(var row = grd_select.fixedRows ; row < grd_select.rows; row++){
//							var seqno = grd_select.valueMatrix(row , grd_select.colRef("sortkey"));
//							if(seqno ==   (grd_select.rows - grd_select.fixedRows))seqno = 1;
//							else seqno = seqno + 1;
//							var data = grd_select.valueMatrix(row , grd_select.colRef("itemnm"));
//	
//							 var findnode = instance1.selectNodes("/root/main/list/tableselect" + "/*");	
//							 for(var index = 0; index <= findnode.length ; index++){
//							 	var curdata = model.getValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/itemnm");
//							 	if(curdata == data){
//							 		model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/sortkey", seqno);
//							 		break;
//							 	}
//							 }								
//						}

					}
					
					grd_select.sort(grd_select.fixedRows, grd_select.colRef("sortkey"),  (grd_select.rows - grd_select.fixedRows) ,grd_select.colRef("sortkey"))= "asc";
					grd_select.gridToInstance();
					
					//alert(focusrow);
					model.setFocus("grd_select");
					grd_select.select(focusrow, grd_select.colRef("itemclsnm")) = true;
					grd_select.row = focusrow;
					model.refresh();
				}
				
				function fCreateFixDocu(pfixdoucnm){
					if(pfixdoucnm == null || pfixdoucnm.length == 0){
						messageBox("서식명칭은","I003");
						model.setFocus("ipt_fixdoucnm");
						return;
					}

					if(grd_where.rows - grd_where.fixedRows == 0){
						messageBox("조건항목이 입력되지 않았습니다. 실행","E001");
						return;
					}
					if(grd_select.rows - grd_select.fixedRows == 0){
						messageBox("검색항목이 입력되지 않았습니다. 실행","E001");
						return;
					}
					
					if(!checkKeyColumn("grd_where","grd_select")) return;	
					
					model.removenode("/root/send/save");
					model.makeNode("/root/send/save/fixdoculist");
					
					misfGridInit(grd_docufix);

					var cnt = 1;
					for(var row = grd_select.fixedRows ; row < grd_select.rows; row++){
						var data = grd_select.valueMatrix(row , grd_select.colRef("itemnm"));
						 var findnode = instance1.selectNodes("/root/main/list/tableselect" + "/*");	
						 for(var index = 0; index <= findnode.length ; index++){
						 	var curdata = model.getValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/itemnm");
						 	if(curdata == data){
						 		model.setValue("/root/main/list/tableselect/tableselectlist" + "[" + index + "]/sortkey", cnt);
						 		break;
						 	}
						 }			
						cnt++;
					}
					
					model.refresh();
							
					var addRow;
					
					var findnode = instance1.selectNodes("/root/main/list/tableselect" + "/*");	
					var instcd = model.getValue("/root/main/list/fixitem/emplnodeptlist/instcd");
					 for(var index = 0; index <= findnode.length ; index++){
	
						var data = index + 1;
						var row = grd_select.findRow(data, grd_select.fixedRows, grd_select.colRef("sortkey"), true,true);

						if(row != -1){
							misfGridIUD(grd_docufix, "A","N");
							addRow = grd_docufix.rows - grd_docufix.fixedRows;
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_select.valueMatrix(row , grd_select.colRef("itemcls")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/fixtypenm", pfixdoucnm);
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/conditemflag", "1");
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_select.valueMatrix(row , grd_select.colRef("itemcls")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/itemnm", grd_select.valueMatrix(row , grd_select.colRef("itemnm")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/itemkind", grd_select.valueMatrix(row , grd_select.colRef("itemkind")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/tblschema", grd_select.valueMatrix(row , grd_select.colRef("tblschema")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/tablenm", grd_select.valueMatrix(row , grd_select.colRef("tablenm")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/colnm", grd_select.valueMatrix(row , grd_select.colRef("colnm")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/cdtblschema", grd_select.valueMatrix(row , grd_select.colRef("cdtblschema")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/cdtblnm", grd_select.valueMatrix(row , grd_select.colRef("cdtblnm")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/codeflag", grd_select.valueMatrix(row , grd_select.colRef("codeflag")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/workflag", "02");
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/instcd", instcd);
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/funcflag", grd_select.valueMatrix(row , grd_select.colRef("funcflag")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/funcyn", grd_select.valueMatrix(row , grd_select.colRef("funcyn")));
							model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/sumyn", grd_select.valueMatrix(row , grd_select.colRef("sumyn")));
						}
					}
					
					for(var row = grd_where.fixedRows; row < grd_where.rows; row++){
						misfGridIUD(grd_docufix, "A","N");
						addRow = grd_docufix.rows - grd_docufix.fixedRows;
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_where.valueMatrix(row , grd_where.colRef("itemcls")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/fixtypenm",pfixdoucnm);
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/conditemflag", "2");
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_where.valueMatrix(row , grd_where.colRef("itemcls")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/itemnm", grd_where.valueMatrix(row , grd_where.colRef("itemnm")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/itemkind", grd_where.valueMatrix(row , grd_where.colRef("itemkind")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/tblschema", grd_where.valueMatrix(row , grd_where.colRef("tblschema")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/tablenm", grd_where.valueMatrix(row , grd_where.colRef("tablenm")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/colnm", grd_where.valueMatrix(row , grd_where.colRef("colnm")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/cdtblschema", grd_where.valueMatrix(row , grd_where.colRef("cdtblschema")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/cdtblnm", grd_where.valueMatrix(row , grd_where.colRef("cdtblnm")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/codeflag", grd_where.valueMatrix(row , grd_where.colRef("codeflag")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/operator", grd_where.valueMatrix(row , grd_where.colRef("operator")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/conector", grd_where.valueMatrix(row , grd_where.colRef("conector")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/condvalu1", grd_where.valueMatrix(row , grd_where.colRef("condvalu1")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/condvalu2", grd_where.valueMatrix(row , grd_where.colRef("condvalu2")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/condvalu1nm", grd_where.valueMatrix(row , grd_where.colRef("condvalu1nm")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/condvalu2nm", grd_where.valueMatrix(row , grd_where.colRef("condvalu2nm")));
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/workflag", "02");
						model.setValue(grd_docufix.attribute("nodeset")+"["+(addRow)+"]/instcd", instcd);
					}
					model.setValue("/root/send/save/fixdoculist",grd_docufix.getUpdateData());


					submit("TXRPB01701");
					if (model.getValue(gvErrorMsgPath + "/type") != "error")
					{
						submit("TRRPB01705");
					}
				}
				
				function fFuncflagDisable() {
					for (var i = grd_select.fixedRows; i < grd_select.rows; i++) {
						if (grd_select.valueMatrix(i, grd_select.colRef("funcyn")) == "Y" ) {
							grd_select.cellAttribute("disabled",i, grd_select.colRef("funcflag")) = "false";
							grd_select.cellAttribute("disabled",i, grd_select.colRef("sumyn")) = "true";
						}
						else {
							grd_select.cellAttribute("disabled",i, grd_select.colRef("funcflag")) = "true";
							grd_select.cellAttribute("disabled",i, grd_select.colRef("sumyn")) = "false";
						}
						
						
					}
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1194;1,1061;1,1061;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1190px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:189px; height:14px; ">교원업적조건검색</caption>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:13px; width:1190px; height:27px; ">
			<line id="line12" class="line_6" style="x1:0px; y1:25; x2:1190px; y2:25; "/>
			<button id="btn_init" class="btn4_letter3" style="left:1120px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridInit(grd_where);
						misfGridInit(grd_select);
						model.setValue(ipt_fixdoucnm.attribute("ref"),"");
						model.setValue(ipt_mplemplno.attribute("ref"),"");
						model.refresh();
					]]>
				</script>
			</button>
			<button id="btn_execute" class="btn4_letter2" style="left:1063px; top:3px; width:56px; height:22px; ">
				<caption>
					<![CDATA[실행]]>
				</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fSettingQuery();
					]]>
				</script>
			</button>
			<select1 id="cmb_queryflag" ref="/root/init/queryflag" visibility="hidden" appearance="minimal" style="left:84px; top:5px; width:270px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/queryflag">
						<label ref="cdnm"/>
						<value ref="code"/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption3" class="search_name" visibility="hidden" style="left:4px; top:5px; width:85px; height:17px; vertical-align:middle; ">검색구분:</caption>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
			<group id="group3" style="left:2px; top:2px; width:355px; height:737px; ">
				<select1 id="cmb_itemcls" ref="/root/send/itemqry/itemcls" appearance="minimal" style="left:82px; top:3px; width:269px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							submit("TRRPB01702");
							//misfMsterDetailRetrieve(); 				
						]]>
					</script>
				</select1>
				<caption id="caption1" class="search_name" style="left:1px; top:4px; width:100px; height:17px; vertical-align:middle; ">항목구분:</caption>
				<line id="line1" class="line_1" style="x1:0px; y1:24px; x2:353px; y2:24px; "/>
				<datagrid id="grd_tblcode" nodeset="/root/main/list/tablecode/tablecodelist" caption="항목^구분" colsep="^" colwidth="236, 95, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" selectionmode="byrow" style="left:0px; top:29px; width:353px; height:704px; ">
					<col ref="itemnm"/>
					<col ref="itemflagnm"/>
					<col ref="itemcls" visibility="hidden"/>
					<col ref="itemseq" visibility="hidden"/>
					<col ref="itemflag" visibility="hidden"/>
					<col ref="itemkind" visibility="hidden"/>
					<col ref="tblschema" visibility="hidden"/>
					<col ref="tablenm" visibility="hidden"/>
					<col ref="colnm" visibility="hidden"/>
					<col ref="cdtblschema" visibility="hidden"/>
					<col ref="cdtblnm" visibility="hidden"/>
					<col ref="codeflag" visibility="hidden"/>
					<col ref="funcyn" visibility="hidden"/>
					<script type="javascript" ev:event="onaftersort">
						<![CDATA[
							grd_tblcode.gridToInstance();
						]]>
					</script>
				</datagrid>
				<textarea id="txt_selectqry" ref="/root/init/selectqry" visibility="hidden" style="left:25px; top:440px; width:105px; height:130px; "/>
				<textarea id="txt_fromqry" ref="/root/init/fromqry" visibility="hidden" style="left:132px; top:440px; width:110px; height:130px; "/>
				<textarea id="txt_whereqry" ref="/root/init/whereqry" visibility="hidden" style="left:244px; top:440px; width:95px; height:130px; "/>
			</group>
			<group id="group2" style="left:355px; top:0px; width:835px; height:300px; ">
				<datagrid id="grd_where" nodeset="/root/main/list/tablewhere/tablewherelist" caption="항목^연산자^조건값^조건값2^연결" colsep="^" colwidth="193, 83, 338, 141, 54, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:2px; top:31px; width:831px; height:250px; ">
					<col ref="itemnm" type="inputbutton" _key="true"/>
					<col ref="operator" type="combo" _key="true">
						<choices>
							<itemset nodeset="/root/init/operator">
								<label ref="code"/>
								<value ref="cdnm"/>
							</itemset>
						</choices>
					</col>
					<col ref="condvalu1nm" _key="true"/>
					<col ref="condvalu2nm"/>
					<col ref="conector" type="combo" _key="true">
						<choices>
							<itemset nodeset="/root/init/conector">
								<label ref="cdnm"/>
								<value ref="code"/>
							</itemset>
						</choices>
					</col>
					<col ref="condvalu1" visibility="hidden"/>
					<col ref="condvalu2" visibility="hidden"/>
					<col ref="itemcls" visibility="hidden"/>
					<col ref="itemseq" visibility="hidden"/>
					<col ref="itemflag" visibility="hidden"/>
					<col ref="itemkind" visibility="hidden"/>
					<col ref="tblschema" visibility="hidden"/>
					<col ref="tablenm" visibility="hidden"/>
					<col ref="colnm" visibility="hidden"/>
					<col ref="cdtblschema" visibility="hidden"/>
					<col ref="cdtblnm" visibility="hidden"/>
					<col ref="codeflag" visibility="hidden"/>
					<col ref="tblalias" visibility="hidden"/>
					<col ref="fixtypenm" visibility="hidden"/>
					<col ref="conditemflag" visibility="hidden"/>
					<script type="javascript" ev:event="onbuttonclick">
						<![CDATA[
							if(grd_where.col == grd_where.colRef("itemnm")){
								var itemkind = grd_where.valueMatrix(grd_where.row, grd_where.colRef("itemkind"));
								
								model.removenode("/root/copynode");
								model.makeNode("/root/copynode");

								var CSV;    
								if(itemkind == "CODE" || itemkind == "YN"){
									model.removenode(gvParamPath +"/SMRPB01702_/SMRPB01702_value");
									rpbfOpenPopUpList("SMRPB01702",grd_where,"operator,conector,condvalu1,condvalu1nm,condvalu2,condvalu2nm,itemnm,itemkind,cdtblnm,codeflag,colnm","operator,conector,condvalu1,condvalu1nm,condvalu2,condvalu2nm,itemnm,itemkind,cdtblnm,codeflag,colnm");
									CSV = model.getValue(gvParamPath +"/SMRPB01702_/SMRPB01702_value");
								}
								else{
									model.removenode(gvParamPath +"/SMRPB01701_/SMRPB01701_value");
									rpbfOpenPopUpList("SMRPB01701",grd_where,"operator,conector,condvalu1,condvalu2,itemnm,itemkind","operator,conector,condvalu1,condvalu2,itemnm,itemkind");
									CSV = model.getValue(gvParamPath +"/SMRPB01701_/SMRPB01701_value");
								}
								setCSVToNode("/root/copynode", CSV, "itemlist");
								
								var codynode = instance1.selectNodes("/root/copynode" + "/*");				
				 				if(codynode.length == 0)return;
				 				
								var operator = model.getValue("/root/copynode/itemlist/operator");
								var conector = model.getValue("/root/copynode/itemlist/conector");
								var condvalu1 = model.getValue("/root/copynode/itemlist/condvalu1");
								var condvalu2 = model.getValue("/root/copynode/itemlist/condvalu2");
								
								var condvalu1nm = "";
								var condvalu2nm = "";
								
								if(itemkind == "CODE" || itemkind == "YN"){
									condvalu1nm = model.getValue("/root/copynode/itemlist/condvalu1nm");
									condvalu2nm = model.getValue("/root/copynode/itemlist/condvalu2nm");
								}
								else{
									condvalu1nm = condvalu1;
									condvalu2nm = condvalu2;
								}

								model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/operator", operator);
								model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/conector", conector);
								
								model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu1", condvalu1);
								model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu2", condvalu2);
								model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu1nm", condvalu1nm);
								model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu2nm", condvalu2nm);
								
							}
						]]>
					</script>
				</datagrid>
				<button id="btn_wheredelete" class="btn2_letter4" style="left:67px; top:5px; width:64px; height:19px; ">
					<caption>조건삭제</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							misfGridIUD(grd_where, "D");							
						]]>
					</script>
				</button>
				<button id="btn_whereinsert" class="btn2_letter4" style="left:2px; top:5px; width:64px; height:19px; ">
					<caption>조건추가</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							if(grd_tblcode.rows-grd_tblcode.fixedRows == 0) return;
							
							if(!fAddWhereColumn())return;
							grd_where.col = grd_where.colRef("itemnm");
							grd_where.dispatch("onbuttonclick");
							grd_where.row= grd_where.rows- grd_where.fixedRows;
						]]>
					</script>
				</button>
				<line id="line2" class="line_1" style="x1:2px; y1:26px; x2:833px; y2:26px; "/>
				<caption id="caption7" class="tit_2" style="left:764px; top:10px; width:70px; height:13px; vertical-align:middle; ">조건항목</caption>
				<datagrid id="grd_query" nodeset="/root/main/list/query/querylist" visibility="hidden" caption="caption1" colsep="^" colwidth="100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:215px; top:115px; width:225px; height:95px; ">
					<col ref="strqry"/>
					<col ref="title"/>
					<col ref="titlecnt"/>
					<col ref="titlenm"/>
					<col ref="coltype"/>
					<col ref="sumyn"/>
					<col ref="funcyn"/>
				</datagrid>
				<datagrid id="grd_docufix" nodeset="/root/main/list/fixdocu/fixdoculist" visibility="hidden" caption="caption1^caption2^caption3" colsep="^" mergecellsfixedrows="bycolrec" rowsep="|" style="left:510px; top:115px; width:225px; height:95px; ">
					<col ref="itemcls"/>
					<col ref="itemclsnm"/>
					<col ref="fixtypenm"/>
					<col ref="conditemflag"/>
					<col ref="itemseq"/>
					<col ref="itemnm"/>
					<col ref="itemkind"/>
					<col ref="tblschema"/>
					<col ref="tablenm"/>
					<col ref="colnm"/>
					<col ref="cdtblschema"/>
					<col ref="cdtblnm"/>
					<col ref="codeflag"/>
					<col ref="operator"/>
					<col ref="conector"/>
					<col ref="condvalu1"/>
					<col ref="condvalu2"/>
					<col ref="condvalu1nm"/>
					<col ref="condvalu2nm"/>
					<col ref="nursedeptflag"/>
					<col ref="instcd"/>
					<col ref="workflag"/>
					<col ref="funcflag"/>
					<col ref="funcyn"/>
					<col ref="sumyn"/>
				</datagrid>
				<input id="ipt_mplemplno" ref="/root/init/mplemplno" visibility="hidden" style="left:215px; top:5px; width:100px; height:19px; "/>
			</group>
			<group id="group6" style="left:355px; top:298px; width:606px; height:440px; ">
				<line id="line3" class="line_1" style="x1:2px; y1:24px; x2:605px; y2:24px; "/>
				<caption id="caption2" class="tit_2" style="left:528px; top:8px; width:75px; height:13px; vertical-align:middle; ">검색항목</caption>
				<datagrid id="grd_select" nodeset="/root/main/list/tableselect/tableselectlist" caption="항목구분^항목명^구분^소계구분" colsep="^" colwidth="196, 236, 89, 63, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:2px; top:30px; width:603px; height:400px; ">
					<col ref="itemclsnm" _key="true"/>
					<col ref="itemnm" _key="true"/>
					<col ref="funcflag" type="combo">
						<choices>
							<itemset>
								<label/>
								<value/>
							</itemset>
						</choices>
					</col>
					<col checkvalue="Y,N" ref="sumyn" type="checkbox"/>
					<col ref="itemcls" visibility="hidden"/>
					<col ref="itemseq" visibility="hidden"/>
					<col ref="itemflag" visibility="hidden"/>
					<col ref="itemkind" visibility="hidden"/>
					<col ref="tblschema" visibility="hidden"/>
					<col ref="tablenm" visibility="hidden"/>
					<col ref="colnm" visibility="hidden"/>
					<col ref="cdtblschema" visibility="hidden"/>
					<col ref="cdtblnm" visibility="hidden"/>
					<col ref="codeflag" visibility="hidden"/>
					<col ref="sortkey" visibility="hidden"/>
					<col ref="fixtypenm" visibility="hidden"/>
					<col ref="conditemflag" visibility="hidden"/>
					<col ref="funcyn" visibility="hidden"/>
				</datagrid>
				<button id="btnselectdown" class="icon_bottom" style="left:160px; top:4px; width:26px; height:19px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						fSelectSortKey("D");							
					]]>
					</script>
				</button>
				<button id="btnselectup" class="icon_top" style="left:133px; top:4px; width:26px; height:19px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fSelectSortKey("U");			
						]]>
					</script>
				</button>
				<button id="grd_selectdelete" class="btn2_letter4" style="left:68px; top:4px; width:64px; height:19px; ">
					<caption>항목삭제</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							misfGridIUD(grd_select, "D");
							
							fFuncflagDisable();
					]]>
					</script>
				</button>
				<button id="grd_selectinsert" class="btn2_letter4" style="left:3px; top:4px; width:64px; height:19px; ">
					<caption>항목추가</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						
						grd_tblcode.refresh();
						if(grd_tblcode.rows-grd_tblcode.fixedRows == 0)return;
						fAddSelectColumn();
						fFuncflagDisable();
					]]>
					</script>
				</button>
				<caption id="caption4" class="search_name" style="left:211px; top:4px; width:59px; height:17px; vertical-align:middle; ">구분:</caption>
				<select1 id="cmb_funcflag" ref="/root/send/func/funcflag" appearance="minimal" style="left:266px; top:4px; width:165px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							for (var i = grd_select.fixedRows; i < grd_select.rows; i++) {
								if (grd_select.valueMatrix(i, grd_select.colRef("funcyn")) == "Y") {
									grd_select.valueMatrix(i, grd_select.colRef("funcflag")) = cmb_funcflag.value;
								}
								else {
									grd_select.valueMatrix(i, grd_select.colRef("funcflag")) = "01";
								}
							}
						]]>
					</script>
				</select1>
			</group>
			<group id="group7" style="left:961px; top:298px; width:229px; height:440px; ">
				<line id="line4" class="line_1" style="x1:1px; y1:24px; x2:227px; y2:24px; "/>
				<datagrid id="grd_fixitem" nodeset="/root/main/list/fixitem/fixitemlist" caption="서식명^간호부여부^기관" colsep="^" colwidth="207, 100, 100" explorerbar="sort" mergecellsfixedrows="bycolrec" rowsep="|" style="left:1px; top:30px; width:226px; height:375px; ">
					<col ref="fixtypenm"/>
					<col ref="nursedeptflag" visibility="hidden"/>
					<col ref="instcd" visibility="hidden"/>
				</datagrid>
				<input id="ipt_fixdoucnm" ref="/root/init/fixdoucnm" style="left:1px; top:411px; width:146px; height:19px; "/>
				<button id="btn_docusave" class="btn4_letter4" style="left:148px; top:410px; width:80px; height:22px; ">
					<caption>서식생성</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						var fixdocu = ipt_fixdoucnm.value;
						
						for (var i = grd_fixitem.fixedRows; i < grd_fixitem.rows; i++) {
							if (fixdocu == grd_fixitem.valueMatrix(i, grd_fixitem.colRef("fixtypenm")) ) {
								messageBox("이미 존재 하는 서식명 입니다.","I003");
								return;
							}
						}
						fCreateFixDocu(model.getValue(ipt_fixdoucnm.attribute("ref")));
					]]>
					</script>
				</button>
				<button id="btn_docudelete" class="btn4_letter2" style="left:170px; top:1px; width:56px; height:22px; ">
					<caption>삭제</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							var fixtypenm = grd_fixitem.valueMatrix(grd_fixitem.row, grd_fixitem.colRef("fixtypenm"));
							var instcd = grd_fixitem.valueMatrix(grd_fixitem.row, grd_fixitem.colRef("instcd"));
							
							if(fixtypenm.length == 0){
								messageBox("서식명칭을","C002");
								return;
							}
							
					               var save_val = messageBox(fixtypenm +" 서식내역을", "Q001");
					               if (save_val != "6")return;
											
							model.setValue("/root/send/fixdocu/fixtypenm", fixtypenm);
							model.setValue("/root/send/fixdocu/instcd", instcd);
							model.setValue("/root/send/fixdocu/workflag", "02");
							submit("TXRPB01702");
							if (model.getValue(gvErrorMsgPath + "/type") != "error")
							{
								submit("TRRPB01705");
							}
					]]>
					</script>
				</button>
				<button id="btn_docuselect" class="btn4_letter4" style="left:34px; top:1px; width:80px; height:22px; ">
					<caption>가져오기</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							
							
							var fixtypenm = grd_fixitem.valueMatrix(grd_fixitem.row, grd_fixitem.colRef("fixtypenm"));
							var instcd = grd_fixitem.valueMatrix(grd_fixitem.row, grd_fixitem.colRef("instcd"));
							
							if(fixtypenm.length == 0){
								messageBox("서식명칭을","C002");
								return;
							}
							model.setValue("/root/send/fixdocu/fixtypenm", fixtypenm);
							model.setValue("/root/send/fixdocu/instcd", instcd);
							model.setValue("/root/send/fixdocu/workflag", "02");
							submit("TRRPB01704");


							if(grd_docufix.rows - grd_docufix.fixedRows == 0){
								messageBox("저장된 서식내역이","I004");
								return;
							}
							
							misfGridInit(grd_select);
							misfGridInit(grd_where);

							var addRow;
							for(var row = grd_docufix.fixedRows; row < grd_docufix.rows; row++){
								if(grd_docufix.valueMatrix(row , grd_docufix.colRef("conditemflag")) == "1"){
									misfGridIUD(grd_select, "A","N");
									addRow = grd_select.rows - grd_select.fixedRows;
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemcls")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/itemclsnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemclsnm")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/fixtypenm", model.getValue(ipt_fixdoucnm.attribute("ref")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/conditemflag", "1");
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemcls")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/itemnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemnm")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/itemkind", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemkind")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/tblschema", grd_docufix.valueMatrix(row , grd_docufix.colRef("tblschema")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/tablenm", grd_docufix.valueMatrix(row , grd_docufix.colRef("tablenm")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/colnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("colnm")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/cdtblschema", grd_docufix.valueMatrix(row , grd_docufix.colRef("cdtblschema")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/cdtblnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("cdtblnm")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/codeflag", grd_docufix.valueMatrix(row , grd_docufix.colRef("codeflag")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/funcflag", grd_docufix.valueMatrix(row , grd_docufix.colRef("funcflag")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/funcyn", grd_docufix.valueMatrix(row , grd_docufix.colRef("funcyn")));
									model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/sumyn", grd_docufix.valueMatrix(row , grd_docufix.colRef("sumyn")));
								}
							}
							for(var row = grd_docufix.fixedRows; row < grd_docufix.rows; row++){
								if(grd_docufix.valueMatrix(row , grd_docufix.colRef("conditemflag")) == "2"){
									misfGridIUD(grd_where, "A","N");
									addRow = grd_where.rows - grd_where.fixedRows;
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemcls")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/fixtypenm",model.getValue(ipt_fixdoucnm.attribute("ref")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/conditemflag", "2");
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemcls")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/itemnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemnm")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/itemkind", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemkind")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/tblschema", grd_docufix.valueMatrix(row , grd_docufix.colRef("tblschema")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/tablenm", grd_docufix.valueMatrix(row , grd_docufix.colRef("tablenm")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/colnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("colnm")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/cdtblschema", grd_docufix.valueMatrix(row , grd_docufix.colRef("cdtblschema")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/cdtblnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("cdtblnm")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/codeflag", grd_docufix.valueMatrix(row , grd_docufix.colRef("codeflag")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/operator", grd_docufix.valueMatrix(row , grd_docufix.colRef("operator")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/conector", grd_docufix.valueMatrix(row , grd_docufix.colRef("conector")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/condvalu1", grd_docufix.valueMatrix(row , grd_docufix.colRef("condvalu1")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/condvalu2", grd_docufix.valueMatrix(row , grd_docufix.colRef("condvalu2")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/condvalu1nm", grd_docufix.valueMatrix(row , grd_docufix.colRef("condvalu1nm")));
									model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/condvalu2nm", grd_docufix.valueMatrix(row , grd_docufix.colRef("condvalu2nm")));
								
									
								}
							}
							
							fFuncflagDisable();

					]]>
					</script>
				</button>
				<button id="button1" class="btn4_letter2" style="left:114px; top:1px; width:56px; height:22px; ">
					<caption>수정</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							var fixtypenm = grd_fixitem.valueMatrix(grd_fixitem.row, grd_fixitem.colRef("fixtypenm"));
							var instcd = grd_fixitem.valueMatrix(grd_fixitem.row, grd_fixitem.colRef("instcd"));
							if(fixtypenm.length == 0){
								messageBox("서식명칭을","C002");
								return;
							}

							if(grd_where.rows - grd_where.fixedRows == 0){
								messageBox("조건항목이 입력되지 않았습니다. 수정","E001");
								return;
							}
							if(grd_select.rows - grd_select.fixedRows == 0){
								messageBox("검색항목이 입력되지 않았습니다. 수정","E001");
								return;
							}
							
							model.setValue("/root/send/fixdocu/fixtypenm", fixtypenm);
							model.setValue("/root/send/fixdocu/instcd", instcd);
							model.setValue("/root/send/fixdocu/workflag", "02");
							submit("TXRPB01702");

							fCreateFixDocu(fixtypenm);
						]]>
					</script>
				</button>
			</group>
		</group>
	</xhtml:body>
</xhtml:html>