YNU_JEUS/app_home/himed/webapps/mis/tishumtrafactmngtweb/xrw/SMRTH01100_인사조건검색.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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/>
						</itemqry>
						<fixdocu>
							<fixtypenm/>
							<nursedeptflag/>
						</fixdocu>
						<save>
							<fixdoculist/>
						</save>
					</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/>
					</init>
					<temp>
						<s/>
					</temp>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					misfGridInit(grd_tblcode);
					misfGridInit(grd_where);
					misfGridInit(grd_select);
					misfGridInit(grd_fixitem);

					grd_select.colsort(grd_select.colRef("sortkey")) = "asc";
					
					misfMsterDetailSet(grd_tblcode,null, "TRRTH01101" ,"N"); 
					misfMsterDetailSet(grd_where,null, "TRRTH01102" ,"N"); 
					misfMsterDetailSet(grd_select,null, "TRRTH01102" ,"N"); 

					misfMsterDetailSet(grd_fixitem,null, "TRRTH01103" ,"N"); 

					rpbfComboItemClsList(cmb_itemcls);

					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("TRRTH01103");

					if(model.getValue("/root/main/list/fixitem/emplnodeptlist/deptcd") == "3040200000") { //로긴한 사용자가 간호부이면
						nursedeptflag = "Y";
						fAddWhereColumnNurse();
					}
					
				]]>
			</script>
			<submission id="TRRTH01102" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/itemqry" resultref="/root/main/list/tablecode"/>
			<submission id="TRRTH01104" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/fixdocu" resultref="/root/main/list/fixdocu"/>
			<submission id="TRRTH01103" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/itemqry" resultref="/root/main/list/fixitem"/>
			<submission id="TXRTH01101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" resultref="/root/hiddeen/temp"/>
			<submission id="TXRTH01102" 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"/>
			<submission id="TRRTH01101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/itemqry" resultref="/root/main/list/tablecode"/>
		</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[
			
				var nursedeptflag = "N";
				
				//콤보에 조건검색 항목코드분류
				function rpbfComboItemClsList(pcontrol_name,pitemcls) {
				    var control_id = pcontrol_name.attribute("id");
    
				    var itemcls_node = "/root/send/itemcls";
				    var itemcls_rsltnode = "/root/init/itemcls";
				    var itemcls_itemset = "/root/init/" + control_id;
    
				    if(pitemcls == null || pitemcls.length == 0)pitemcls = "";
    
				    model.removeNodeset(itemcls_node);
				    model.removeNodeset(itemcls_itemset);
    
				    model.makeNode(itemcls_node);
				    model.makeNode(itemcls_node + "/itemcls");
    
				    model.makeNode(itemcls_rsltnode);
				    model.makeNode(itemcls_itemset);
    
				    pcontrol_name.choices.itemset.attribute("nodeset") = itemcls_itemset+"/itemclslist";
				    pcontrol_name.choices.itemset.label.attribute("ref") = "itemclsnm";
				    pcontrol_name.choices.itemset.value.attribute("ref") = "itemcls";
				    pcontrol_name.refresh();
    
				    model.setValue(itemcls_node + "/itemcls", pitemcls);
	
					model.removeChild("TRRTH01105");
					model.createChild("xforms:submission", "id:TRRTH01105;mediatype:application/x-www-form-urlencoded; method:post; ref:" + itemcls_node + "; resultref:" + itemcls_rsltnode + "; ");
					submit("TRRTH01105");
	
				    model.copyNode(itemcls_itemset,itemcls_rsltnode);
    
				    model.refresh();
				}
				
				
				function fAddWhereColumnNurse()
				{
					misfGridIUD(grd_where, "A","N");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/itemcls", "01");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/itemnm", "소속부(실)");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/itemkind", "CODE");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/tblschema", "MIS");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/tablenm", "RPBVEMPC");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/colnm", "DEPTCD");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/cdtblschema", "COM");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/cdtblnm", "ZSDDDEPT");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/codeflag", "");
					
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/operator", "=");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu1nm", "'간호부'");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu2nm", "");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu1", model.getValue("/root/main/list/fixitem/emplnodeptlist/deptcd"));
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu2", "");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/itemseq", "9");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/itemflag", "A");
					model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/conector", "AND");
					
					
					grd_where.cellAttribute("disabled",grd_where.row, grd_where.colRef("itemnm")) = "true";
					grd_where.cellAttribute("disabled",grd_where.row, grd_where.colRef("operator")) = "true";
					grd_where.cellAttribute("disabled",grd_where.row, grd_where.colRef("conector")) = "true";
					
					grd_where.cellStyle("color", grd_where.row, grd_where.colRef("itemnm")) = "#ff0000";
					grd_where.cellStyle("color", grd_where.row, grd_where.colRef("operator")) = "#ff0000";
					grd_where.cellStyle("color", grd_where.row, grd_where.colRef("condvalu1nm")) = "#ff0000";
					grd_where.cellStyle("color", grd_where.row, grd_where.colRef("condvalu2nm")) = "#ff0000";
					grd_where.cellStyle("color", grd_where.row, grd_where.colRef("conector")) = "#ff0000";
					
					grd_where.refresh();
					
					return true;
				}
				
				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;
					}		


					if(grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("itemnm")) == "소속부서" ||
					   grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("itemnm")) == "근무부서"){

						messageBox("「" + grd_tblcode.valueMatrix(grd_tblcode.row, grd_tblcode.colRef("itemnm")) + "」조건 지정시 유의사항 \n" +
						                   "  1.연산자 '='  : 하위부서 포함 조회. \n" +
						                   "  2.연산자 'IN' : 하위부서 미포함 조회 \n" +
						                   "                       지정된 「부서」코드 해당값만 조회됩니다","I");
					}
					
					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")));
					
					}
					grd_select.refresh();

				}
				function fSettingQuery(){
					//인사 조건 검색을 사전 작업을 진행한다

//					submit("TXRTH01103");

					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;	
						
						//조건을 위해 사용자가 반드시 입력해야 하는 조건들을 체크한다
						if(!fChkQueryCond())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());

						//급여항목이 경우 급여항목에 해당하는 급여비용을 화면에 보여줘야 하므로 Col + 1로 Column의 갯수를 재조정한다						
						if(grd_select.findRow("PAYITEMCD" , grd_select.fixedRows, grd_select.colRef("colnm"), true,true) > -1){
							model.setValue(grd_query.attribute("nodeset")+"["+(grd_query.row - grd_query.fixedRows + 1)+"]/titlecnt",(grd_select.rows- grd_select.fixedRows) + 1);
						}
						else{
							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());
						

						rpbfOpenPopUpList("SMRTH01110",grd_query,"strqry,title,titlecnt,titlenm,coltype","strqry,title,titlecnt,titlenm,coltype");

					}
				}
				
				function fChkQueryCond(){

					var chkpay = false;
					var chkpaycond = false;
					
					//급여에 관계된 테이블을 사용자가 항목절에 추가했는지 체크
					for(var row = grd_select.fixedRows; row < grd_select.rows; row++){
						if(grd_select.valueMatrix(row, grd_select.colRef("tablenm")) == "RWPDYMPY" ||
						  grd_select.valueMatrix(row, grd_select.colRef("tablenm")) == "RWPDPYIT" ){
							chkpay = true;
							break;
						}
					}
					if(chkpay){
						//급여에 관계된 테이블이 항목절에 추가되었다면,
						//조건절에 급여지급월이 존재하는지 체크
						for(var row = grd_where.fixedRows ; row < grd_where.rows; row++){
							if(grd_where.valueMatrix(row , grd_where.colRef("colnm")) == "PAYYM"){
								chkpaycond = true;
								break;
							}
						}
					}
					
					//급여에 관계된 테이블이 존재하면서 급여 지급월이 존재하지 않을 경우 쿼리를 실행하지 않도록 사용자에게 MessageBox출력후 Return false처리한다
					if((chkpay == true)&& (chkpaycond == false)){
						messageBox("급여 항목조회시 지급년월은 조회조건에" ,"I003");
						return false; 
					}
					return true;					
				}
				
				function fGetColType(){

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

				function fGetColNm(){

					var colnm = "";
					for(row = grd_select.fixedRows; row < grd_select.rows ; row++){
						//급여항목이 항목절에 추가 되었다면 급여 항목비용도 자동으로 화면에 보여주어야 하며
						//급여항목비용이 아닌 급여항목명이 화면에 보여줘야하므로
						//급여항목비용에 해당하는 Prntnm과 PayitemAmt를 추가한다
						if(grd_select.valueMatrix(row , grd_select.colRef("colnm")) == "PAYITEMCD")
						{
							colnm = colnm + "PRNTNM,PAYITEMAMT,"
						}
						else{
							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(grd_select.valueMatrix(row , grd_select.colRef("colnm")) == "PAYITEMCD")title = title + "급여금액^"
					}
					
					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));
								if(tgttable == "RWPDPYIT" || tgttable == "RWPDYMPY"){
									var chkduppay = false;
									for(var tmprow = grd_where.fixedRows ; tmprow < row; tmprow++){
										if(grd_where.valueMatrix(tmprow,grd_where.colRef("tablenm")) == "RWPDPYIT" ||
										   grd_where.valueMatrix(tmprow,grd_where.colRef("tablenm")) == "RWPDYMPY"){
										   	chkduppay = true;
										   	break;
										   } 
									}
									
									//급여에 관계된 테이블에 관계해서 한번더 alias작업을 하지 않았다면 join조건으로 아래 내역을 자동추가한다
									//기타 다른 테이블은 기본키를 Emplno로 맞추었기 때문에 자동으로 하드코딩없이 생성할수 있지만
									//급여는 기본키가 다르게 적용되므로 하나라도 급여에 관계된 테이블이 존재할 경우 
									//join조건에 급여항목을 가져오기 위해 필요한 모든 테이블을 join건다			
									if(!chkduppay){
										strfrom = strfrom + "INNER JOIN MIS.RWPDYMPY RWPDYMPY ON RWPDYMPY.EMPLNO = MAINTBL.EMPLNO \n" +
										                           "INNER JOIN MIS.RWPDPYIT RWPDPYIT ON RWPDPYIT.EMPLNO = RWPDYMPY.EMPLNO AND RWPDPYIT.PAYYM =  RWPDYMPY.PAYYM AND RWPDPYIT.SALDFRAYFLAG = RWPDYMPY.SALDFRAYFLAG  \n" + 
										                           "INNER JOIN MIS.RWCMPYTL RWCMPYTL ON RWCMPYTL.INSTCD = RWPDYMPY.PAYINST AND RWCMPYTL.SALDFRAYFLAG = RWPDYMPY.SALDFRAYFLAG  AND RWCMPYTL.PAYITEMCD =  RWPDPYIT.PAYITEMCD \n";
									}
									//테입블 alias는 후에 select절이나 where 절을 만들때 따로 alias를 읽어오지 않아도 되게끔 테이블명으로 동일하게 처리한다
									model.setValue(grd_where.attribute("nodeset")+"["+(row - grd_where.fixedRows + 1)+"]/tblalias", tgttable);
								}
								else{
									//급여에 관계된 항목이 아니라면 테이블간 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);
						}
					}				

					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 == "근무부서") && (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);
									}

									addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".INSTCD" +
									                    " AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DEPTCD \n";
									                    
									condsql =   tmpsubalias + "." + "DEPTCD IN ( \n" + 
									                                                          " SELECT DEPTCD \n" + 
									                                                          "    FROM COM.ZSDDDEPT Z \n" + 
									                                                          "  WHERE Z.PSNWORKSUPDEPTCD = " + condvalu1 + "\n" + 
									                                                          "      AND  TO_CHAR( sysdate, 'yyyymmdd') BETWEEN Z.valifromdd AND Z.valitodd \n " +
									                                                          "  UNION ALL \n " +
									                                                          "  SELECT  " + condvalu1 + "\n" + 
									                                                          "      FROM dual ) \n";

								}
								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 == "근무부서") && (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);
										}
	
										addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".INSTCD" +
										                    " AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DEPTCD \n";
										                    
										tmpcondsql1 =   tmpsubalias + "." + "DEPTCD IN ( \n" + 
										                                                          " SELECT DEPTCD \n" + 
										                                                          "    FROM COM.ZSDDDEPT Z \n" + 
										                                                          "  WHERE Z.PSNWORKSUPDEPTCD = " + condvalu1 + "\n" + 
										                                                          "      AND TO_CHAR( sysdate, 'yyyymmdd') BETWEEN Z.valifromdd AND Z.valitodd \n " +
										                                                          "  UNION ALL \n " +
										                                                          "  SELECT  " + condvalu1 + "\n" + 
										                                                          "      FROM sysibm.sysdummy1 ) \n";
	
									}
									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( (tmpitemnm == "소속부서" || tmpitemnm == "근무부서") && (tmpoperator == "=")){
										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);
										}
	
										addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".INSTCD" +
										                    " AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DEPTCD \n";
										                    
										tmpcondsql2 =   tmpsubalias + "." + "DEPTCD IN ( \n" + 
										                                                          " SELECT DEPTCD \n" + 
										                                                          "    FROM COM.ZSDDDEPT Z \n" + 
										                                                          "  WHERE Z.PSNWORKSUPDEPTCD = " + tmpcondvalu1 + "\n" + 
										                                                          "      AND TO_CHAR( sysdate, 'yyyymmdd' ) BETWEEN Z.valifromdd AND Z.valitodd \n " +
										                                                          "  UNION ALL \n " +
										                                                          "  SELECT  " + tmpcondvalu1 + "\n" + 
										                                                          "      FROM sysibm.sysdummy1 ) \n";
	
									}									
									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( (tmpitemnm == "소속부서" || tmpitemnm == "근무부서") && (tmpoperator == "=")){
											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);
											}
		
											addfromqry = addfromqry + " LEFT OUTER JOIN COM.ZSDDDEPT " + tmpsubalias + " ON " + tmpsubalias + ".INSTCD = " + memplalias + ".INSTCD" +
											                    " AND " + tmpsubalias + ".DEPTCD  = " + memplalias + ".DEPTCD \n";
											                    
											tmpcondsql =   tmpsubalias + "." + "DEPTCD IN ( \n" + 
											                                                          " SELECT DEPTCD \n" + 
											                                                          "    FROM COM.ZSDDDEPT Z \n" + 
											                                                          "  WHERE Z.PSNWORKSUPDEPTCD = " + tmpcondvalu1 + "\n" + 
											                                                          "      AND TO_CHAR( sysdate, 'yyyymmdd' ) BETWEEN Z.valifromdd AND Z.valitodd \n " +
											                                                          "  UNION ALL \n " +
											                                                          "  SELECT  " + tmpcondvalu1 + "\n" + 
											                                                          "      FROM sysibm.sysdummy1 ) \n";
										}
										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((grd_where.findRow("RWPDYMPY",grd_where.fixedRows , grd_where.colRef("tablenm"),true,true) > -1) &&
					   (grd_select.findRow("PAYITEMCD",grd_select.fixedRows , grd_select.colRef("colnm"),true,true) > -1)){
						strwhere = strwhere + "\n";
						strwhere = strwhere + "AND    RWCMPYTL.APPDD = (SELECT MAX(z.APPDD) \n";
						strwhere = strwhere + "                                               FROM   MIS.RWCMPYTL z\n";
						strwhere = strwhere + "						WHERE   z.INSTCD = RWPDYMPY.PAYINST\n";
						strwhere = strwhere + "						    AND   z.SALDFRAYFLAG = RWPDYMPY.SALDFRAYFLAG \n";
						strwhere = strwhere + "						    AND   z.PAYITEMCD = RWPDPYIT.PAYITEMCD\n";
						strwhere = strwhere + "						    AND   z.APPDD <= RWPDPYIT.PAYDD)\n";
					}


					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;

					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")); //칼럼명칭
						
						//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조건을 자동추가한다
							maxalias = maxalias -1;
							var tmpalias = tablenm + (maxalias);
							
							//급여에 관계된 항목이 아니라면 메인테이블과 emplno로 join 조건을 걸어준다
							//단 조건에 존재하지 않는 항목이므로 left outer join으로 한다
							if(tablenm != "RWPDPYIT" && tablenm !=  "RWPDYMPY"){
								addfromqry = addfromqry + " LEFT OUTER JOIN " + tblschema + "." + tablenm + " " + 	tmpalias + " ON " +  	tmpalias + ".emplno = " + maintblalias + ".emplno \n";
							}
							//항목절에 급여에 관계된 항목이 존재할경우 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 = " " + tmpalias + ".cdnm as " + colnm + "\n";
							}
							else if (cdtblnm == "ZSDDDEPT"){
								if (colnm == "DEPTCD" || colnm == "TEAMCD" || colnm == "UNITCD") {
							 		tmpquery = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".INSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  + " as " + colnm + "\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";
								}else if (colnm == "DUPDEPTCD" || colnm == "DUPTEAMCD" || colnm == "DUPUNITCD ") {
									tmpquery = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".DUPINSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )" + " as " + colnm + "\n";
								}else if (colnm == "ORGDEPTCD" ) {
									tmpquery = " COM.FN_ZS_GETDEPTNM(" + emplalias + ".ORGINSTCD, " + tblalias + "." + colnm + ", TO_CHAR( sysdate, 'yyyymmdd' ) )"  + " as " + colnm + "\n";
								}
							}	
							else if(cdtblnm == "RWCMPYTL"){	
								//급여항목명을 읽어오는 경우 급여항목타이틀에 있는 컬럼을 읽어온다
								//단, 급여에 관계된 테이블을 from에서 명칭으로 자동생성하였으므로 여기서는 테이블명의 칼럼명을 읽어오면 된다
								tmpquery = " RWCMPYTL.PRNTNM as PRNTNM  \n";
								
								if(colnm == "PAYITEMCD"){
									//급여항목을 선택한 경우 급여항목비용도 같이 화면에 조회한다
									tmpquery = tmpquery + "\n ,RWPDPYIT.PAYITEMAMT as PAYITEMAMT \n"
								}
							}					
						}
						else{
							
							tmpquery = tblalias + "." + colnm + "\n";
						}
						
						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);
					}
					
					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 nursedeptflag = "N";
//					if (model.getValue("/root/main/list/fixitem/emplnodeptlist/deptcd") == "3040200000") {
//						nursedeptflag = "Y";
//					}
//					else {
//						nursedeptflag = "N";
//					}
					
					var findnode = instance1.selectNodes("/root/main/list/tableselect" + "/*");	
					 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)+"]/nursedeptflag", nursedeptflag);
						}
					}
					
					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)+"]/nursedeptflag", nursedeptflag);
					}
					model.setValue("/root/send/save/fixdoculist",grd_docufix.getUpdateData());

					submit("TXRTH01101");
					if (model.getValue(gvErrorMsgPath + "/type") != "error")
					{
						submit("TRRTH01103");
					}
				}
			]]>
		</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>
		</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:79px; top:3px; width:274px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							submit("TRRTH01101");
							//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"/>
					<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);

								if(grd_where.valueMatrix(grd_where.row, grd_where.colRef("tablenm")) == "RWPDYMPY" &&
								   grd_where.valueMatrix(grd_where.row, grd_where.colRef("colnm")) == "PAYYM" ){
									model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/conector", "AND");
								}
								else{
									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>
					<script type="javascript" ev:event="onentercell">
						<![CDATA[
							if(grd_where.col == grd_where.colRef("conector"))
							{ 
								if(grd_where.valueMatrix(grd_where.row, grd_where.colRef("tablenm")) == "RWPDYMPY" &&
								   grd_where.valueMatrix(grd_where.row, grd_where.colRef("colnm")) == "PAYYM" ){
								   	messageBox("급여년월은 AND만 가능합니다.변경","E001");
								   	return;
								  }		
							}
						]]>
					</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[
						if (model.getValue("/root/main/list/fixitem/emplnodeptlist/deptcd") == "3040200000" &&
						    grd_where.valueMatrix(grd_where.row, grd_where.colRef("tblschema")) == "MIS" &&
							grd_where.valueMatrix(grd_where.row, grd_where.colRef("tablenm")) == "RPBVEMPC" &&
							grd_where.valueMatrix(grd_where.row, grd_where.colRef("colnm")) == "DEPTCD" &&
							grd_where.valueMatrix(grd_where.row, grd_where.colRef("condvalu1")) == model.getValue("/root/main/list/fixitem/emplnodeptlist/deptcd")) {
							messageBox("삭제 할수 없는 조건 입니다.","");
							return;
						}
						    
						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"/>
				</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"/>
				</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="239, 345, 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="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"/>
				</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");
					]]>
					</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();
					]]>
					</script>
				</button>
			</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" mergecellsfixedrows="bycolrec" rowsep="|" style="left:1px; top:30px; width:226px; height:375px; ">
					<col ref="fixtypenm"/>
					<col ref="nursedeptflag" 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"));
							
							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/nursedeptflag", nursedeptflag);
							submit("TXRTH01102");
							if (model.getValue(gvErrorMsgPath + "/type") != "error")
							{
								submit("TRRTH01103");
							}
					]]>
					</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"));
							
							if(fixtypenm.length == 0){
								messageBox("서식명칭을","C002");
								return;
							}

							model.setValue("/root/send/fixdocu/fixtypenm", fixtypenm);
							model.setValue("/root/send/fixdocu/nursedeptflag", nursedeptflag);
							submit("TRRTH01104");

							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")));
								}
							}

							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")));
								
									
								}
							}

							for (var z = grd_where.fixedRows; z < grd_where.rows; z++) {
								if (nursedeptflag == "Y" &&
									grd_where.valueMatrix(z, grd_where.colRef("tblschema")) == "MIS" &&
									grd_where.valueMatrix(z, grd_where.colRef("tablenm")) == "RPBVEMPC" &&
									grd_where.valueMatrix(z, grd_where.colRef("colnm")) == "DEPTCD" &&
									grd_where.valueMatrix(z, grd_where.colRef("condvalu1")) == model.getValue("/root/main/list/fixitem/emplnodeptlist/deptcd")) {
									
									grd_where.cellAttribute("disabled",z, grd_where.colRef("itemnm")) = "true";
									grd_where.cellAttribute("disabled",z, grd_where.colRef("operator")) = "true";
									grd_where.cellAttribute("disabled",z, grd_where.colRef("conector")) = "true";
									
									grd_where.cellStyle("color", z, grd_where.colRef("itemnm")) = "#ff0000";
									grd_where.cellStyle("color", z, grd_where.colRef("operator")) = "#ff0000";
									grd_where.cellStyle("color", z, grd_where.colRef("condvalu1nm")) = "#ff0000";
									grd_where.cellStyle("color", z, grd_where.colRef("condvalu2nm")) = "#ff0000";
									grd_where.cellStyle("color", z, grd_where.colRef("conector")) = "#ff0000";
								}
								else {
									grd_where.cellAttribute("disabled",z, grd_where.colRef("itemnm")) = "false";
									grd_where.cellAttribute("disabled",z, grd_where.colRef("operator")) = "false";
									grd_where.cellAttribute("disabled",z, grd_where.colRef("conector")) = "false";
									
									grd_where.cellStyle("color", z, grd_where.colRef("itemnm")) = "";
									grd_where.cellStyle("color", z, grd_where.colRef("operator")) = "";
									grd_where.cellStyle("color", z, grd_where.colRef("condvalu1nm")) = "";
									grd_where.cellStyle("color", z, grd_where.colRef("condvalu2nm")) = "";
									grd_where.cellStyle("color", z, grd_where.colRef("conector")) = "";
								}
							}

					]]>
					</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"));
							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/nursedeptflag", nursedeptflag);
							submit("TXRTH01102");

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