YNU_JEUS/app_home/himed/webapps/mis/yyendtaxadstweb/xrw/SMRWY02200_항목별정산내역조회.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>
						<yyendcalcrslt>
							<yyendcalcrsltlist/>
							<yyendcalflaglist/>
						</yyendcalcrslt>
						<excelyyendcalcrslt>
							<excelyyendcalcrsltlist/>
						</excelyyendcalcrslt>
					</main>
					<send>
						<yyendcalcbase>
							<calcyy/>
							<calcinst/>
							<retireyn>N</retireyn>
							<deptnm/>
							<emplnm/>
							<deptcd/>
							<emplno/>
							<workym/>
							<sortflag>A</sortflag>
						</yyendcalcbase>
					</send>
					<init>
						<temp/>
					</init>
					<hidden>
						<temp/>
					</hidden>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[					
					misfComboInstCdListMulti("cmb_calcinst",getCurrentDate(),"","N");
					model.setValue(cmb_calcinst.attribute("ref"), getUserInfo("dutplceinstcd"));
					
					var nowdate = getCurrentDate();
					var yy = nowdate.substring(0,4);
					var mm = nowdate.substring(4,6);
					var yyyymm = nowdate.substring(0,6);

					if (mm == "01" || mm == "02") {
						yy = parseInt(yy) - 1;
						yyyymm = yy + "12";
					}
					
					//model.setValue(ipt_calcyy.attribute("ref") ,  cvtdate.getAddDate(0,"M").getDateFormat("YYYY"));
					model.setValue(ipt_calcyy.attribute("ref") ,  yy);
					model.setValue(ipt_workym.attribute("ref") ,  yyyymm);

					misfGetUserAuth();
					
					if (DUTY_PAY_YN == "Y" ) {
						cmb_calcinst.disabled = false;
					}
					else {
						cmb_calcinst.disabled = true;
					}
					
					model.refresh();
				]]>
			</script>
			<submission id="TRRWY02201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/yyendcalcbase" resultref="/root/main/yyendcalcrslt"/>
			<submission id="TRRWY02202" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/yyendcalcbase" resultref="/root/main/excelyyendcalcrslt"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
	</xhtml:head>
	<xhtml:body>
		<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:38; 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; "/>
			<caption id="caption3" class="search_name" style="left:8px; top:19px; width:57px; height:17px; ">년도:</caption>
			<input id="ipt_calcyy" ref="/root/send/yyendcalcbase/calcyy" class="input_s_essential" maxlength="4" style="left:64px; top:18px; width:56px; height:19px; "/>
			<button id="btn_search" class="btn1_letter2" style="left:1124px; top:16px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if (grd_yyendcalcrsltlist.nodeset.length> 0) {
							
							model.removeNodeset("/root/main/yyendcalcrslt/yyendcalcrsltlist");
							grd_yyendcalcrsltlist.nodeset = "/root/init/temp";
							
							//for (var i = grd_payamtlist.cols; i >= grd_payamtlist.fixedCols ; i--) {
							for (var i = grd_yyendcalcrsltlist.cols - 1; i >= 1 ; i--) {
								grd_yyendcalcrsltlist.removeColumn(false);
								
							}
							grd_yyendcalcrsltlist.caption = "";
							
							model.refresh();
							grd_yyendcalcrsltlist.rebuild();
							
						}
						
						
						submit("TRRWY02201");
						
						var node = instance1.selectNodes("/root/main/yyendcalcrslt/yyendcalcrsltlist[1]/*");
						
						var calcflagcnt = model.getValue("/root/main/yyendcalcrslt/yyendcalflaglist/calcflagcnt") ;
						
						//calcflagcnt += 2;
						
						
						for(i=0;i<calcflagcnt;i++) {
							if (i < 9 ) {
								if( i == 2) {
									grd_yyendcalcrsltlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "yyyy-mm;"  + " style:" + "text-align:center; ", false);
								}
								else if (i == 7 || i == 8) {
									grd_yyendcalcrsltlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "yyyy-mm-dd;"  + " style:" + "text-align:center; ", false);
								}
								else {
									grd_yyendcalcrsltlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " style:" + "text-align:center; ", false);
								}
							}
							else {
								
								grd_yyendcalcrsltlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "(-)#,###;" + " style:" + "text-align:right; ", false);
							}
						}
						
						grd_yyendcalcrsltlist.frozenCols = 4;
						grd_yyendcalcrsltlist.colWidth(3) = 60;
						grd_yyendcalcrsltlist.caption = model.getValue("/root/main/yyendcalcrslt/yyendcalflaglist/calcflag") + "|" + model.getValue("/root/main/yyendcalcrslt/yyendcalflaglist/calcflag");
						grd_yyendcalcrsltlist.nodeset = "/root/main/yyendcalcrslt/yyendcalcrsltlist";
					    	grd_yyendcalcrsltlist.rebuild();			
							
							grd_yyendcalcrsltlist.subtotalPosition = "below";
							
							for(i=0;i<calcflagcnt;i++) {
								if (i > 8 ) {
									grd_yyendcalcrsltlist.subtotal("sum",-1 , grd_yyendcalcrsltlist.colRef(node.item(i).nodeName), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");	
								}
							}
					   ]]>
				</script>
			</button>
			<caption id="caption1" class="tit_2" style="left:5px; top:55px; width:115px; height:14px; ">연말정산내역</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:70px; x2:1190px; y2:70px; "/>
			<datagrid id="grd_yyendcalcrsltlist" colsep="^" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:75px; width:1190px; height:665px; ">
				<script type="javascript" ev:event="onbeforesort">
					<![CDATA[
						grd_yyendcalcrsltlist.subtotal("clear", 0, 0);
					]]>
				</script>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						var node = instance1.selectNodes("/root/main/yyendcalcrslt/yyendcalcrsltlist[1]/*");
						var calcflagcnt = model.getValue("/root/main/yyendcalcrslt/yyendcalflaglist/calcflagcnt") ;
						
						grd_yyendcalcrsltlist.subtotalPosition = "below";
						
						for(i=0;i<calcflagcnt;i++) {
							if (i > 2 ) {
								grd_yyendcalcrsltlist.subtotal("sum",-1 , grd_yyendcalcrsltlist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");	
							}
						}
					]]>
				</script>
			</datagrid>
			<select1 id="cmb_calcinst" ref="/root/send/yyendcalcbase/calcinst" class="combo_s_essential" appearance="minimal" style="left:375px; top:18px; width:155px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption8" class="search_name" style="left:316px; top:19px; width:61px; height:17px; ">기관:</caption>
			<caption id="caption13" class="search_name" style="left:545px; top:19px; width:60px; height:17px; ">부서:</caption>
			<output id="opt_deptnm" ref="/root/send/yyendcalcbase/deptnm" class="output_fix" style="left:700px; top:18px; width:90px; height:19px; "/>
			<button id="btn_deptcd" class="icon_search" disabled="false" style="left:682px; top:18px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var recv_list = "deptcd,deptnm";
						rpbfOpenDeptCdHelp(ipt_deptcd,recv_list);
						model.refresh();
						
					]]>
				</script>
			</button>
			<input id="ipt_deptcd" ref="/root/send/yyendcalcbase/deptcd" class="input_default" disabled="false" navindex="5" style="left:602px; top:18px; width:77px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						 /* 부서코드,명 입력시 Validation Check
					       	   misfValidationCheck(Validation 종류(부서코드, 공통코드, 우편번호...), 공통코드군, 자료를 받을 Instance Node(콤마로 분류해서 넘기면됨)) */
						misfValidationCheck("02", "", "deptcd,deptnm" );
						model.refresh();
					]]>
				</script>
			</input>
			<output id="opt_emplnm" ref="/root/send/yyendcalcbase/emplnm" class="output_fix" style="left:965px; top:18px; width:80px; height:19px; "/>
			<input id="ipt_emplno" ref="/root/send/yyendcalcbase/emplno" class="input_default" disabled="false" navindex="5" style="left:867px; top:18px; width:77px; height:19px; ">
				<script type="javascript" ev:event="onkeyup">
					<![CDATA[
						if (ipt_emplno.currentText != null && ipt_emplno.currentText != "" ) {
							inputEnterKey("ipt_emplno", "xforms-value-changed");	
							inputEnterKey("btn_search", "DOMActivate");
						}
					]]>
				</script>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						 var recv_list = "emplno,emplnm" ;
						 rpbfValidationCheck("EMPLNO", recv_list);
						 model.refresh();
					]]>
				</script>
			</input>
			<button id="btn_emplno" class="icon_search" disabled="false" style="left:947px; top:18px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var recv_list = "emplno,emplnm" ;
					        rpbfOpenPopUpList("SPRPB00101", ipt_emplno, recv_list,"","N");
						model.refresh();
						
						if (model.getValue(ipt_emplno.attribute("ref")).length > 0) {
							btn_search.dispatch("DOMActivate");
						}
						
					]]>
				</script>
			</button>
			<caption id="caption2" class="search_name" style="left:805px; top:19px; width:60px; height:17px; ">사번:</caption>
			<select1 id="rdo_retireyn" ref="/root/send/yyendcalcbase/retireyn" class="radio_search" disabled="false" navindex="54" visibility="hidden" overflow="visible" appearance="full" cols="2" itemheight="18" itemwidth="53" style="left:1055px; top:15px; width:55px; height:19px; text-align:center; border-style:solid; ">
				<choices>
					<item>
						<label>중도퇴직</label>
						<value>Y</value>
					</item>
					<item>
						<label>연말</label>
						<value>N</value>
					</item>
				</choices>
			</select1>
			<button id="btn_saveexcel" class="btn2_letter4" style="left:1125px; top:48px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");


						if (fileName != "")
						{
							//grd_payamtlist.saveExcel(fileName, "sheetname:sheet1");
						  var param  =  "&calcyy=" + model.getValue("/root/send/yyendcalcbase/calcyy");   
								param += "&deptcd=" + model.getValue("/root/send/yyendcalcbase/deptcd");  
								param += "&emplno=" + model.getValue("/root/send/yyendcalcbase/emplno");     
								param += "&calcinst=" + model.getValue("/root/send/yyendcalcbase/calcinst");  
								param += "&retireyn=" + model.getValue("/root/send/yyendcalcbase/retireyn");      
								param += "&workym=" + model.getValue("/root/send/yyendcalcbase/workym");          
								param += "&sortflag=" + model.getValue("/root/send/yyendcalcbase/sortflag");  

							
							model.download(getActionURL("TRRWY02202") + param, fileName, true);
							
							window.exec(fileName);
							
						}		
					]]>
				</script>
			</button>
			<input id="ipt_workym" ref="/root/send/yyendcalcbase/workym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:220px; top:18px; width:80px; height:19px; "/>
			<caption id="caption4" class="search_name" style="left:135px; top:19px; width:86px; height:17px; ">정산년월 :</caption>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12; width:1195px; height:27px; ">
			<line id="line9" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="btn_clear" class="btn4_letter3" style="left:1124px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>