YNU_JEUS/app_home/himed/webapps/mis/pubwelfmngtweb/xrw/SMRPA02100_학자금지급현황.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>
						<gvnoffcorddetl>
							<gvnoffcorddetllist/>
						</gvnoffcorddetl>
						<gvnoffcorddetldata>
							<gvnoffcorddetllist/>
						</gvnoffcorddetldata>
						<masterscholexp>
							<scholexplist>
								<emplno/>
								<emplnm/>
								<dutdeptnm/>
								<chldrnnm/>
								<payappmm/>
								<qurtyy/>
								<scholflagnm/>
								<schoolnm/>
								<schoolyy/>
								<scholexppayamt/>
							</scholexplist>
						</masterscholexp>
						<send>
							<payappmm/>
							<chldrnnm/>
							<emplno/>
							<dutplceinst/>
							<selectinstnm/>
							<reqgbn/>
							<paymmto/>
							<emplnm/>
						</send>
						<temp/>
					</main>
					<init>
						<combo1>
							<label>신청</label>
							<value>01</value>
							<label>승인</label>
							<value>02</value>
							<label>지급</label>
							<value>03</value>
						</combo1>
					</init>
					<target/>
				</root>
			</instance>
			<script type="javascript">
				<![CDATA[
					var GVN_TARGET_NODE = "/root/main/gvnoffcorddetldata";
					var GVN_SOURCE_NODE = "/root/main/gvnoffcorddetl";
				]]>
			</script>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
 					fInitialize();
					misfGridInit(grd_scholexplist);
					misfComboComCdList('Z0007', cmb_instcd_s,"Y");
					
					if(instance1.selectNodes("/root/target/*").length > 0)
					{
						cmb_instcd_s.value="";
						
						ipt_emplno.disabled = true;
						btn_emplsearch.disabled = true;
						ipt_emplnm.disabled = true;
						button2.visible = false;
						
						ipt_payappmm.value = model.getValue("/root/target/deduyy") + "01";
						ipt_paymmto.value = model.getValue("/root/target/deduyy") + "12";
						ipt_emplno.value = model.getValue("/root/target/emplno") ;
						ipt_emplnm.value = model.getValue("/root/target/emplnm") ;
						ipt_chldrnnm.value = model.getValue("/root/target/chldrnnm") ;
						cmb_reqgbn.value = "03";
						
						
						btn_search.dispatch("DOMActivate");
						grd_scholexplist.colHidden(grd_scholexplist.colRef("yyendappamt")) = false;
					}
					else {
						var dutplceinstcd = getUserInfo("dutplceinstcd");
						cmb_instcd_s.value=dutplceinstcd;
						if( dutplceinstcd != "001" ) {
							cmb_instcd_s.disabled = true;
						}
						cmb_reqgbn.value='03';
						
						grd_scholexplist.colHidden(grd_scholexplist.colRef("yyendappamt")) = true;
					}
					
					
				]]>
			</script>
			<submission id="TRRPA02101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/send" resultref="/root/main/masterscholexp"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/pubwelfmngtweb/js/RPS001.js"/>
		<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
		<script type="javascript">
			<![CDATA[
				// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
				function fInitialize() {
					model.removeNodeset("/root/main/masterscholexp/scholexplist");
					model.removeNodeset("/root/main/gvnoffcorddetl/gvnoffcorddetllist");
					model.resetInstanceNode("/root/main/send");
					model.resetInstanceNode("/root/main/gvnoffcorddetldata/gvnoffcorddetllist");
					model.refresh();
				}
				
				function fDeleteSelectedRows(grd,markonly) {
					var rowIdx;
					if (grd.selectedRows > 0) {
						var selectedRows = Array(grd.selectedRows);
						for( i=0; i<grd.selectedRows; i++ ) {
							selectedRows[i] = grd.selectedRow(i);
						}
						if (markonly != null && markonly == true) { // mark delete
							for(i=selectedRows.length-1; i>=0; i--) {
								rowIdx = selectedRows[i];
								if(grd.rowstatus(rowIdx) == 1 ) { // just inserted row
									grd.deleterow(rowIdx,false);
								} else {
									grd.addStatus(rowIdx,"delete");
								}
							}
						} else {
							for(i=selectedRows.length-1; i>=0; i--) {
								rowIdx = selectedRows[i];
								grd.deleterow(rowIdx,false);
							}
						}
					}
				}
				
				function fPrint() {
					model.makeNode("/root/main/send/selectinstnm");
					var selectInstnm="";
					if(cmb_instcd_s.value==""){
						selectInstnm="전체";
					}else{
						selectInstnm=cmb_instcd_s.label;
					}
					model.setValue("/root/main/send/selectinstnm", selectInstnm);
					exeReportPreview("RPRPA02100", "XMLSTR", "/root/main/send");
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1350;1,1349;" style="margin-left:8; margin-right:8; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">학자금지급현황</caption>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<line id="line13" class="line_4" style="x1:1109px; y1:16px; x2:1109px; y2:38px; "/>
			<button id="button19" class="btn2_letter4" style="left:1130px; top:48px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
						if (fileName != "")	{
							grd_scholexplist.saveExcel(fileName, "SheetName", true, true, "", "");
						}		
					]]>
				</script>
			</button>
			<caption id="caption16" class="search_name" style="left:491px; top:19px; width:86px; height:17px; ">사원번호 :</caption>
			<caption id="caption3" class="search_name" style="left:772px; top:19px; width:83px; height:17px; ">자 녀 명 :</caption>
			<input id="ipt_chldrnnm" ref="/root/main/send/chldrnnm" class="input_default" style="left:856px; top:18px; width:80px; height:19px; ">
				<script type="javascript" ev:event="onkeydown">
					<![CDATA[
						if(event.keyCode == 13)		{
							ipt_chldrnnm.value = ipt_chldrnnm.currentText;
							btn_search.dispatch("DOMActivate");
						}	
					]]>
				</script>
			</input>
			<caption id="caption14" class="tit_2" style="left:5px; top:54px; width:191px; height:13px; ">학자금지급현황</caption>
			<line id="line4" class="line_1" style="x1:0px; y1:69px; x2:1195px; y2:69px; "/>
			<datagrid id="grd_scholexplist" nodeset="/root/main/masterscholexp/scholexplist" caption="지급년월^부서^근무유닛^사원번호^사원명^자녀명^학력구분^학년^분기^학교명^입학금^수업료^기성회비^학생회비^지급금액^연말정산적용금액" colsep="^" colwidth="82, 100, 100, 70, 76, 66, 69, 41, 38, 130, 70, 80, 80, 70, 92, 105" dataheight="25" ellipsis="true" rowheader="update" rowheight="25" rowsep="|" tooltip="true" style="left:0px; top:74px; width:1195px; height:660px; text-align:center; ">
				<col ref="payappmm" type="output" visibility="hidden" format="yyyy-mm" style="text-align:center; "/>
				<col ref="deptnm" style="text-align:center; "/>
				<col ref="dutdeptnm" style="text-align:center; "/>
				<col ref="emplno" style="text-align:center; "/>
				<col ref="emplnm" style="text-align:center; "/>
				<col ref="chldrnnm" style="text-align:center; "/>
				<col ref="scholflagnm"/>
				<col ref="schoolyy" style="text-align:center; "/>
				<col ref="qurtyy"/>
				<col ref="schoolnm"/>
				<col ref="payadmischoolamt" format="#,###" style="text-align:right; "/>
				<col ref="payscho" format="#,###" style="text-align:right; "/>
				<col ref="payasctfeereliztpln" format="#,###" style="text-align:right; "/>
				<col ref="paystdasctfee" format="#,###" style="text-align:right; "/>
				<col ref="payamt" format="#,###" style="text-align:right; "/>
				<col ref="yyendappamt" visibility="hidden" format="#,###" style="text-align:right; "/>
			</datagrid>
			<button id="btn_search" class="btn1_letter2" navindex="8" style="left:1124px; top:17px; width:56px; height:22px; text-align:left; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					    var payappmm=ipt_payappmm.value;
					    if(payappmm ==""){
					     	messageBox("지급년월은","I003");
					     	return;
					    }
						submit("TRRPA02101");
						
						var cur_row=grd_scholexplist.rows;
						if(cur_row >1){
							grd_scholexplist.subtotalPosition = "below";//하단에 추가 above->상단에추가
							grd_scholexplist.subtotal("sum", 1, 11, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ccffff; font-weight:bold;", 2, "총계", true); 
							grd_scholexplist.subtotal("sum", 1, 12, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ccffff; font-weight:bold;", 2, "총계", true); 
							grd_scholexplist.subtotal("sum", 1, 13, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ccffff; font-weight:bold;", 2, "총계", true); 
							grd_scholexplist.subtotal("sum", 1, 14, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ccffff; font-weight:bold;", 2, "총계", true); 
							grd_scholexplist.subtotal("sum", 1, 15, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ccffff; font-weight:bold;", 2, "총계", true); 
							grd_scholexplist.subtotal("sum", 1, 16, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ccffff; font-weight:bold;", 2, "총계", true); 
						}
						
						grd_scholexplist.mergeCells = "bycol";
						grd_scholexplist.mergeCol(1) = false;
						grd_scholexplist.mergeCol(2) = true;
						grd_scholexplist.mergeCol(3) = true;
						grd_scholexplist.mergeCol(4) = true;
						grd_scholexplist.mergeCol(5) = true;
						grd_scholexplist.mergeCol(6) = false;
						grd_scholexplist.mergeCol(7) = false;
						grd_scholexplist.mergeCol(8) = false;
						grd_scholexplist.mergeCol(9) = false;
						grd_scholexplist.mergeCol(10) = false;
						grd_scholexplist.mergeCol(11) = false;
						grd_scholexplist.mergeCol(12) = false;
						grd_scholexplist.mergeCol(13) = false;
						grd_scholexplist.mergeCol(14) = false;
						grd_scholexplist.mergeCol(15) = false;
						grd_scholexplist.mergeCol(16) = false;
						grd_scholexplist.merge();
					]]>
				</script>
			</button>
			<datagrid id="grd_gvnoffcorddetllist" nodeset="/root/main/gvnoffcorddetl/gvnoffcorddetllist" visibility="hidden" caption="사번^성명^기관^부서^직책명^입사일^교직구분" colsep="^" colwidth="68, 89, 88, 68, 68,90,90" dataheight="25" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:25px; top:140px; width:185px; height:81px; ">
				<col ref="emplno" type="output"/>
				<col ref="emplnm" type="output"/>
			</datagrid>
			<input id="ipt_emplnm" ref="/root/main/send/emplnm" class="input_essential" disabled="true" navindex="21" style="left:671px; top:18px; width:90px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var emplnm = ipt_emplnm.value;
						if (grd_gvnoffcorddetllist.rowStatus(grd_gvnoffcorddetllist.row) != "1") {
							misfGridIUD(grd_gvnoffcorddetllist, "A");
							model.copyNode(GVN_TARGET_NODE + "/gvnoffcorddetllist" ,GVN_SOURCE_NODE + "/gvnoffcorddetllist[" + (grd_gvnoffcorddetllist.row - grd_gvnoffcorddetllist.fixedRows + 1) + "]" );
							//rpbfGvnoffcordEditYNSet(grd_gvnoffcordcdlist.nodeset, GVN_TARGET_NODE + "/gvnoffcorddetllist");
						}
						model.setValue(GVN_TARGET_NODE + "/gvnoffcorddetllist/emplnm", emplnm);
						
						/* 인사정보 Validation Check
							misfValidationCheck(Validation 종류(부서코드, 공통코드, 우편번호...), 공통코드군, 자료를 받을 Instance Node(콤마로 분류해서 넘기면됨)) */
						var recv_list = "emplno,emplnm";
						rpbfValidationCheck("EMPLNM", recv_list);
						
						model.refresh();
					]]>
				</script>
			</input>
			<input id="ipt_emplno" ref="/root/main/send/emplno" class="input_essential" navindex="20" style="left:576px; top:18px; width:69px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						/* 인사정보 Validation Check
							misfValidationCheck(Validation 종류(부서코드, 공통코드, 우편번호...), 공통코드군, 자료를 받을 Instance Node(콤마로 분류해서 넘기면됨)) */
						var emplno = ipt_emplno.value;
						if (grd_gvnoffcorddetllist.rowStatus(grd_gvnoffcorddetllist.row) != "1") {
							misfGridIUD(grd_gvnoffcorddetllist, "A");
							model.copyNode(GVN_TARGET_NODE + "/gvnoffcorddetllist" ,GVN_SOURCE_NODE + "/gvnoffcorddetllist[" + (grd_gvnoffcorddetllist.row - grd_gvnoffcorddetllist.fixedRows + 1) + "]" );
							// rpbfGvnoffcordEditYNSet(grd_gvnoffcordcdlist.nodeset, GVN_TARGET_NODE + "/gvnoffcorddetllist");
						}
						model.setValue(GVN_TARGET_NODE + "/gvnoffcorddetllist/emplno", emplno);
						
						var recv_list = "emplno,emplnm";
						rpbfValidationCheck("EMPLNO", recv_list);
						model.refresh();
						//fInitialize()
						ipt_emplno_s.value=ipt_emplno.value;
						btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</input>
			<button id="btn_emplsearch" class="icon_search" style="left:651px; top:20px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						/* 사원번호 Help 화면 Open 
							misfOpenPopUpList(화면종류Code, OPEN하는 Control, 공통코드, 리턴받을 Instance명) */
						if (grd_gvnoffcorddetllist.rowStatus(grd_gvnoffcorddetllist.row) != "1") {
							misfGridIUD(grd_gvnoffcorddetllist, "A");
							model.copyNode(GVN_TARGET_NODE + "/gvnoffcorddetllist" ,GVN_SOURCE_NODE + "/gvnoffcorddetllist[" + (grd_gvnoffcorddetllist.row - grd_gvnoffcorddetllist.fixedRows + 1) + "]" );
							// rpbfGvnoffcordEditYNSet(grd_gvnoffcordcdlist.nodeset, GVN_TARGET_NODE + "/gvnoffcorddetllist");
						}
						
						var recv_list = "emplno,emplnm";
							rpbfOpenPopUpList("SPRPA03000", ipt_emplno, recv_list,"","N");
							model.refresh();
						 //   fInitialize()
						ipt_emplno_s.value=ipt_emplno.value;
					]]>
				</script>
			</button>
			<input id="ipt_emplno_s" ref="/root/main/send/emplno" class="input_default" navindex="20" visibility="hidden" style="left:775px; top:40px; width:69px; height:19px; "/>
			<input id="ipt_payappmm" ref="/root/main/send/payappmm" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:305px; top:18px; width:75px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var instcd = cmb_instcd_s.value;
						if( getStringLength(ipt_payappmm.value) == "6" ) {
							misfComboInstCdListMulti("cmb_instcd_s",ipt_payappmm.value,"","Y");
							cmb_instcd_s.value = instcd;
							model.refresh();
							model.setFocus("ipt_paymmto");
						}						
					]]>
				</script>
			</input>
			<caption id="caption1" class="search_name" style="left:220px; top:19px; width:86px; height:17px; ">지급기간 :</caption>
			<select1 id="cmb_instcd_s" ref="/root/main/send/dutplceinst" class="combo_default" appearance="minimal" style="left:64px; top:18px; width:146px; height:19px; ">
				<choices>
					<itemset nodeset="/root/main/init">
						<label ref="cnstnm"/>
						<value ref="cnstcd"/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption2" class="search_name" style="left:5px; top:19px; width:65px; height:17px; ">기관 :</caption>
			<caption id="caption4" class="search_name" style="left:945px; top:18px; width:86px; height:17px; ">조회기준 :</caption>
			<select1 id="cmb_reqgbn" ref="/root/main/send/reqgbn" class="combo_default" appearance="minimal" style="left:1035px; top:18px; width:70px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/combo1">
						<label ref="label"/>
						<value ref="value"/>
					</itemset>
				</choices>
			</select1>
			<input id="ipt_paymmto" ref="/root/main/send/paymmto" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:400px; top:18px; width:75px; height:19px; "/>
			<caption id="caption5" style="left:385px; top:20px; width:10px; height:20px; ">-</caption>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
			<button id="button9" class="btn3_letter4" visibility="hidden" style="left:0px; top:3px; width:80px; height:22px; ">
				<caption>화면이동</caption>
			</button>
			<line id="line11" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="button10" class="btn4_letter3" style="left:1127px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var updtdata = getGridUpdateData(grd_scholexplist);
						if (updtdata != "" ) {
							var ret = messageBox("그리드에 작업 중인 내용이 있습니다. 초기화 작업을","Q003");
							if (ret != 6) { // not OK
								return;
							}
						}
						fInitialize();	
					]]>
				</script>
			</button>
			<button id="button2" class="btn4_letter5" style="left:1033px; top:3px; width:92px; height:22px; ">
				<caption>내역서출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fPrint();	
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>