YNU_JEUS/app_home/himed/webapps/mis/accountinfoweb/xrw/SMRAI00200_실적 Migration.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>실적 Migration</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<migrationlist>
							<migrationsheet/>
						</migrationlist>
						<mappinglist>
							<mappingsheet/>
						</mappinglist>
					</main>
					<send>
						<instcd/>
						<acntcd/>
						<acntnm/>
						<ym/>
						<ymdd/>
						<acntyy/>
					</send>
					<init>
					</init>
					<temp/>
					<hidden>
						<condition>
							<acntflag>0</acntflag>
						</condition>
						<migrationlist>
							<migrationsheet/>
						</migrationlist>
						<mappinglist>
							<mappingsheet/>
						</mappinglist>
					</hidden>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RAM001.js"/>
			<script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();					
				]]>
			</script>
			<script type="javascript">
				<![CDATA[
				
				function fInitialize() 
				{					
					misfComboComCdList("Z0007", cmb_instcd,   "N");
					model.setValue("/root/send/instcd",   getUserInfo("dutplceinstcd"));					
					cmb_instcd.refresh();						
					grd_mappingsheet.focusColor = "#ccffff";
					grd_mappingsheet.selectionmode = "free";
					model.removenode(grd_mappingsheet.nodeset);
					grd_mappingsheet.refresh();
					btn_65.selected = true;
					btn_search.dispatch("DOMActivate");
					
					
					
					if(getUserId() == 'MIS')
					{
						btn_delete.disabled = false;
						btn_exet.disabled = false;						
					}
					else
					{
						btn_delete.disabled = true;
						btn_exet.disabled = true;		
						model.setValue(ipt_acntyy.attribute("ref"), "2008");
						model.setValue(ipt_ym.attribute("ref"), "200809");
						model.setValue(ipt_ymdd.attribute("ref"), "20080930");
						ipt_acntyy.refresh();
						ipt_ym.refresh();
						ipt_ymdd.refresh();
					}
					
				}
				
				function fValidationCheck(vgbn, recvlist, pcdgrupid, pNextIndex, pValueControl, pNodeName, pRetrKind)
				{
					if(event.keyCode == 13 || event.name == "xforms-value-changed")
					{
						document.controls(event.currentTarget).value = document.controls(event.currentTarget).currentText;
						misfValidationCheck(vgbn, pcdgrupid, recvlist, pValueControl, pNodeName, pRetrKind);
						model.refresh();
						
						if (pNextIndex != "") {
							model.setFocus(pNextIndex);
						}
					}
				}
				
				function fNotNullCheck(pGrid) 
				{
					var vAcntyy = model.getValue(ipt_acntyy.attribute("ref"));
					if(grd_mappingsheet.rows == 1 && vAcntyy.length != 4) {  messageBox("회계년도를 입력하세요" ,"I000"); return false; }					
					var vYMDD = model.getValue(ipt_ymdd.attribute("ref"));
					if(grd_mappingsheet.rows == 1 && vYMDD.length != 8) {  messageBox("일계기준일을 입력하세요" ,"I000"); return false; }
					return true;
				}
				
				function fInputExcel(pGrid) 
				{
					var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
					
					if(fileName != "") 
					{
						pGrid.loadExcel(fileName, 1, true);
						
						pGrid.deleteRow(1);
						pGrid.rebuild();
					}
					
					for(var i = grd_mappingsheet.fixedRows ; i < grd_mappingsheet.rows ; i++)
					{
						grd_mappingsheet.rowStatus(i) = 1;				
					}
				}
					
							
			]]>
			</script>
			<submission id="TRRAI00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/mappinglist"/>
			<submission id="TRRAI00202" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/migrationlist"/>
			<submission id="TXRAI00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/hidden/mappinglist" resultref="/root/temp"/>
			<submission id="TXRAI00202" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
			<submission id="TXRAI00203" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
		</model>
	</xhtml:head>
	<xhtml:body guideline="1,1194;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="grp_1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="cap_title" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">실적 Migration</caption>
			<caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
		</group>
		<group id="grp_3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
			<group id="grp_sea" style="left:0px; top:10px; width:1195; height:35px; vertical-align:top; ">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="btn_search" class="btn1_letter2" navindex="4" style="left:1100px; top:8px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							
							if(swt_1.selectedIndex == 0)
							{
								submit("TRRAI00202");
							}
							else
							{						
								submit("TRRAI00201");
								if(grd_mappingsheet.rows > 1)
								{
									model.setValue(ipt_acntyy.attribute("ref"), model.getValue(grd_mappingsheet.nodeset + "[1]/acntyy"));
									model.setValue(ipt_ymdd.attribute("ref"), model.getValue(grd_mappingsheet.nodeset + "[1]/ymdd"));
									model.setValue(ipt_ym.attribute("ref"), model.getValue(grd_mappingsheet.nodeset + "[1]/ymdd").substr(0, 6));
									ipt_acntyy.refresh();
									ipt_ymdd.refresh();
									ipt_ym.refresh();
								}
							}
						]]>
					</script>
				</button>
				<caption id="caption7" class="search_name" style="left:6px; top:9px; width:86px; height:17px; ">기  관 :</caption>
				<select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:80px; top:9px; width:215px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<button id="btn_fracnthelp" class="icon_search" style="left:867px; top:10px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						misfOpenPopUpList("05", ipt_acntcd, "", "acntcd,acntnm");		
						model.refresh();
						]]>
					</script>
				</button>
				<caption id="caption23" class="search_name" style="left:677px; top:10px; width:103px; height:17px; ">계 정 과 목 :</caption>
				<input id="ipt_acntnm" ref="/root/send/acntnm" class="input_s_essential" navindex="7" style="left:885px; top:10px; width:166px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[

									if(event.keyCode == 13)
									{										
										model.setFocus("btn_search");
									}

								]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

									fValidationCheck("05", "acntcd,acntnm", "", "", "", "");

								]]>
					</script>
				</input>
				<input id="ipt_acntcd" ref="/root/send/acntcd" class="input_s_essential" navindex="6" style="left:788px; top:10px; width:75px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[

									if(event.keyCode == 13)
									{										
										model.setFocus("btn_search");
									}

								]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

									fValidationCheck("05", "acntcd,acntnm", "", "", "", "");

								]]>
					</script>
				</input>
				<line id="line1" class="line_4" style="x1:1058px; y1:8px; x2:1058px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption3" class="search_name" style="left:340px; top:10px; width:110px; height:17px; ">회 계 년 도 :</caption>
				<input id="ipt_acntyy" ref="/root/send/acntyy" class="input_s_essential" editable="false" format="9999" appearance="input" style="left:445px; top:9px; width:100px; height:19px; "/>
			</group>
			<case id="case2" selected="true">
				<caption id="caption2" style="left:130px; top:95px; width:100px; height:20px; vertical-align:middle; ">caption2</caption>
			</case>
			<switch id="swt_1" class="sw_box" style="left:0px; top:70px; width:1195px; height:669px; border-style:solid; ">
				<case id="case1" selected="true" style="left:0px; top:0px; width:1193px; height:667px; ">
					<caption id="caption21" class="tit_2" style="left:5px; top:10px; width:135px; height:13px; ">nU 계정 기준 조회</caption>
					<line id="lin_3" class="line_1" style="x1:0px; y1:25px; x2:1193px; y2:25px; "/>
					<datagrid id="grd_migrationsheet" nodeset="/root/main/migrationlist/migrationsheet" backcoloralternate="#ffffff" caption="계정코드^계정분류구분^계정명^상위계정명^회계년도^MIGRATION일시^구계정코드^구계정명^상대처구분^상대처코드^기재사항1^기재사항2^기재사항3^기재사항4^기재사항5^기재사항6^옵션1^옵션2^상위계정코드1^상위계정코드2^상위계정코드3^상위계정코드4^차변금액^대변금액^비고^계정구분^잔액구분^기표여부^사용여부" colsep="^" colwidth="0, 0, 219, 0, 80, 90, 80, 80, 80, 90, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 100, 80, 0, 0, 0, 50" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:0px; top:30px; width:1193px; height:632px; font-size:10pt; ">
						<col ref="acntcd"/>
						<col ref="acntclsflag"/>
						<col ref="acntnm"/>
						<col ref="supacntnm"/>
						<col ref="acntyy"/>
						<col ref="ymdd"/>
						<col ref="oldacntcd"/>
						<col ref="oldacntnm"/>
						<col ref="custflag" type="combo">
							<choices>
								<item>
									<label>거래처</label>
									<value>1</value>
								</item>
								<item>
									<label>부서</label>
									<value>3</value>
								</item>
								<item>
									<label>교직원</label>
									<value>4</value>
								</item>
								<item>
									<label>개인</label>
									<value>5</value>
								</item>
								<item>
									<label>기타</label>
									<value>9</value>
								</item>
							</choices>
						</col>
						<col ref="custcd"/>
						<col ref="notecd1"/>
						<col ref="notecd2"/>
						<col ref="notecd3"/>
						<col ref="notecd4"/>
						<col ref="notecd5"/>
						<col ref="notecd6"/>
						<col ref="option1"/>
						<col ref="option2"/>
						<col ref="supacntcd1"/>
						<col ref="supacntcd2"/>
						<col ref="supacntcd3"/>
						<col ref="supacntcd4"/>
						<col ref="dramt" format="(-)#,###"/>
						<col ref="cramt" format="(-)#,###"/>
						<col ref="cmt"/>
						<col ref="acntflag"/>
						<col ref="balflag"/>
						<col ref="slipyn"/>
						<col ref="acntuseyn"/>
					</datagrid>
					<button id="button4" class="btn2_letter4" style="left:1124px; top:4px; width:64px; height:19px; text-align:left; ">
						<caption>엑셀출력</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
							radfSaveExcel(grd_migrationsheet);
							]]>
						</script>
					</button>
				</case>
				<case id="case2">
					<caption id="caption5" class="tit_2" style="left:5px; top:10px; width:165px; height:13px; ">계정 Mapping List</caption>
					<line id="lin_1" class="line_1" style="x1:0px; y1:25px; x2:1193px; y2:25px; "/>
					<datagrid id="grd_mappingsheet" nodeset="/root/main/mappinglist/mappingsheet" backcoloralternate="#ffffff" caption="기관코드^회계년도^Migration날짜^계정코드^상대처구분^상대처코드^기재사항1^기재사항2^기재사항3^기재사항4^기재사항5^기재사항6^옵션1^옵션2^계정명^상위계정코드1^상위계정코드2^상위계정코드3^상위계정코드4^nU계정코드(대분류)^nU대분류^nU계정코드(관)^nU관^nU계정코드(항)^nU항^nU계정코드(목)^nU목^nU계정코드^nU세목^차변금액^대변금액^비고" colsep="^" colwidth="0, 65, 85, 100, 80, 65, 80, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 90, 100, 100, 80, 80, 100" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" style="left:0px; top:30px; width:1193px; height:632px; ">
						<col ref="instcd"/>
						<col ref="acntyy"/>
						<col ref="ymdd" type="inputdate"/>
						<col ref="acntcd" type="input"/>
						<col ref="custflag" type="combo">
							<choices>
								<item>
									<label>거래처</label>
									<value>1</value>
								</item>
								<item>
									<label>부서</label>
									<value>3</value>
								</item>
								<item>
									<label>교직원</label>
									<value>4</value>
								</item>
								<item>
									<label>개인</label>
									<value>5</value>
								</item>
								<item>
									<label>기타</label>
									<value>9</value>
								</item>
							</choices>
						</col>
						<col ref="custcd" type="input"/>
						<col ref="notecd1" type="input"/>
						<col ref="notecd2" type="input"/>
						<col ref="notecd3" type="input"/>
						<col ref="notecd4" type="input"/>
						<col ref="notecd5" type="input"/>
						<col ref="notecd6" type="input"/>
						<col ref="option1" type="input"/>
						<col ref="option2" type="input"/>
						<col ref="acntnm" type="input"/>
						<col ref="supacntcd1"/>
						<col ref="supacntcd2"/>
						<col ref="supacntcd3"/>
						<col ref="supacntcd4"/>
						<col ref="nusupacntcd1"/>
						<col ref="nusupacntnm1"/>
						<col ref="nusupacntcd2"/>
						<col ref="nusupacntnm2"/>
						<col ref="nusupacntcd3"/>
						<col ref="nusupacntnm3"/>
						<col ref="nusupacntcd4"/>
						<col ref="nusupacntnm4"/>
						<col ref="nuacntcd" type="inputbutton"/>
						<col ref="nuacntnm"/>
						<col ref="dramt" type="input" format="(-)#,###"/>
						<col ref="cramt" type="input" format="(-)#,###"/>
						<col ref="cmt" type="input"/>
						<script type="javascript" ev:event="onbuttonclick">
							<![CDATA[
								if(grd_mappingsheet.col == grd_mappingsheet.colRef("nuacntcd"))
								{
									vAcntclsflag = cmb_acntclsflag.value;
									vInstcd = cmb_instcd.value;
									
									vParam = vInstcd + "," + vAcntclsflag;
									
									misfOpenPopUpList("05", grd_mappingsheet, "", "nuacntcd,nuacntnm", vParam, "instcd,acntclsflag");									
								}
							]]>
						</script>
					</datagrid>
					<button id="btn_2" class="btn2_letter4" style="left:927px; top:4px; width:64px; height:19px; text-align:left; ">
						<caption>엑셀출력</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
							radfSaveExcel(grd_mappingsheet);
							]]>
						</script>
					</button>
					<button id="btn_grddel" class="btn2_letter3" style="left:1064px; top:4px; width:53px; height:19px; ">
						<caption>행삭제</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[					
								misfGridIUD(grd_mappingsheet, "D");
							]]>
						</script>
					</button>
					<button id="btn_grdadd" class="btn2_letter3" style="left:1009px; top:4px; width:53px; height:19px; ">
						<caption>행추가</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
								if(!fNotNullCheck()) return false;
								misfGridIUD(grd_mappingsheet, "A");								
								
								model.setValue(grd_mappingsheet.nodeset + "[" + grd_mappingsheet.row + "]/instcd", 	model.getValue(cmb_instcd.attribute("ref")));	
								model.setValue(grd_mappingsheet.nodeset + "[" + grd_mappingsheet.row + "]/custflag", 	"9");								
								
								if(grd_mappingsheet.rows == 2)
								{
									model.setValue(grd_mappingsheet.nodeset + "[" + grd_mappingsheet.row + "]/ymdd", 	model.getValue(ipt_ymdd.attribute("ref")));
									model.setValue(grd_mappingsheet.nodeset + "[" + grd_mappingsheet.row + "]/acntyy", 	model.getValue(ipt_acntyy.attribute("ref")));
								}
								else
								{
									model.setValue(grd_mappingsheet.nodeset + "[" + grd_mappingsheet.row + "]/ymdd", 	model.getValue(grd_mappingsheet.nodeset + "[1]/ymdd"));
									model.setValue(grd_mappingsheet.nodeset + "[" + grd_mappingsheet.row + "]/acntyy", 	model.getValue(grd_mappingsheet.nodeset + "[1]/acntyy"));
								}
								grd_mappingsheet.colDisabled(grd_mappingsheet.colRef("ymdd")) = true;
								grd_mappingsheet.refresh();
								
							]]>
						</script>
					</button>
					<button id="button1" class="btn2_letter4" style="left:860px; top:4px; width:64px; height:19px; text-align:left; ">
						<caption>엑셀입력</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[				
								model.removeNodeset(grd_mappingsheet.nodeset);			
								grd_mappingsheet.refresh();
							 	fInputExcel(grd_mappingsheet)
							]]>
						</script>
					</button>
					<input id="ipt_ymdd" ref="/root/send/ymdd" class="input_s_essential" editable="false" format="9999-99-99" appearance="input" style="left:513px; top:4px; width:100px; height:19px; "/>
					<button id="btn_delete" class="btn4_letter2" disabled="true" style="left:630px; top:2px; width:56px; height:22px; ">
						<caption>삭제</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
						DelCheck = messageBox("실적 데이터가 삭제됩니다. 삭제하시겠습니까?","Q999");
						if (DelCheck == "6")
						{
							if(model.getValue(ipt_acntyy.attribute("ref")) == "") return false;
							if(model.getValue(ipt_ym.attribute("ref")).length != 6)
							{
								messageBox("월계기준일을 입력하세요" ,"I000");
							}
							if(model.getValue(ipt_ymdd.attribute("ref")).length != 8)
							{
								messageBox("일계기준일을 입력하세요" ,"I000");
							}
      						 	submit("TXRAI00203");
					     	}
						
						
					]]>
						</script>
					</button>
					<line id="lin_5" class="line_4" style="x1:690px; y1:4px; x2:690px; y2:26px; border-color:#ffe4bb; border-left-style:solid; "/>
					<caption id="caption1" class="search_name" style="left:197px; top:5px; width:110px; height:17px; ">월계기준일 :</caption>
					<caption id="caption2" class="search_name" style="left:413px; top:5px; width:130px; height:17px; ">일계기준일 :</caption>
					<input id="ipt_ym" ref="/root/send/ym" class="input_s_essential" editable="false" format="9999-99" appearance="input" style="left:298px; top:4px; width:100px; height:19px; "/>
					<button id="btn_exet" class="btn4_letter2" disabled="true" style="left:700px; top:2px; width:56px; height:22px; ">
						<caption>실행</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
						btn_search.dispatch("DOMActivate");
						if(model.getValue(ipt_acntyy.attribute("ref")) == "") return false;
						if(model.getValue(ipt_ym.attribute("ref")).length != 6)
						{
							messageBox("월계기준일을 입력하세요" ,"I000");
						}
						if(model.getValue(ipt_ymdd.attribute("ref")).length != 8)
						{
							messageBox("일계기준일을 입력하세요" ,"I000");
						}
						submit("TXRAI00202");
						
					]]>
						</script>
					</button>
					<button id="button2" class="btn4_letter2" style="left:1134px; top:3px; width:56px; height:22px; ">
						<caption>저장</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[

						if(grd_mappingsheet.getUpdateData() != "")
						{
//							var vInstcd = model.getValue(cmb_instcd.attribute("ref"));
//							
//							alert(vInstcd);
//							for(var i = grd_mappingsheet.fixedRows ; i > grd_mappingsheet.rows ; i++)
//							{
//								model.setValue(grd_mappingsheet.nodeset + "[" + i + "]/instcd", vInstcd);								
//							}							
							
							model.setValue("/root/hidden/mappinglist/mappingsheet", grd_mappingsheet.getUpdateData());
							submit("TXRAI00201");
							btn_search.dispatch("DOMActivate");
						}

					]]>
						</script>
					</button>
				</case>
			</switch>
			<button id="btn_65" class="btn_sw" group="tab" selected="true" style="left:0px; top:50px; width:68px; height:22px; ">
				<caption>조  회</caption>
				<toggle case="case1" ev:event="onclick"/>
			</button>
			<button id="btn_1" class="btn_sw" group="tab" selected="true" style="left:68px; top:50px; width:68px; height:22px; ">
				<caption>입  력</caption>
				<toggle case="case2" ev:event="onclick"/>
			</button>
			<select1 id="cmb_acntclsflag" ref="/root/hidden/condition/acntflag" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:140px; top:50px; width:27px; height:19px; text-align:center; vertical-align:middle; ">
				<choices>
					<item>
						<label>대분류</label>
						<value>4</value>
					</item>
					<item>
						<label>관</label>
						<value>3</value>
					</item>
					<item>
						<label>항</label>
						<value>2</value>
					</item>
					<item>
						<label>목</label>
						<value>1</value>
					</item>
					<item>
						<label>세목</label>
						<value>0</value>
					</item>
				</choices>
			</select1>
		</group>
		<group id="grp_4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
			<line id="lin_2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
			<button id="button5" style="left:110px; top:5px; width:100px; height:20px; ">
				<caption>button5</caption>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						alert(getUserId());				
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>