YNU_JEUS/app_home/himed/webapps/mis/pubwelfmngtweb/xrw/SMRPA07800_동호회비공제내역.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>
						<deducord>
							<clubclublist>
								<cmninstcd/>
								<instnm/>
								<cmntcd/>
								<cmntnm/>
								<reglmbrcnt/>
								<asctmbrcnt/>
								<reglmbrannconvnt/>
								<asctmbrannconvnt/>
								<totmmconvnt/>
								<basedd/>
								<holdmembcnt/>
								<workgbn/>
							</clubclublist>
						</deducord>
						<deducorddetail>
							<clubdedulist>
								<cmntnm/>
								<emplno/>
								<emplnm/>
								<posinstnm/>
								<posinstcd/>
								<deptcd/>
								<deptnm/>
								<reglmbrgrdenm/>
								<reglmbrgrde/>
								<clubcost/>
								<paydeducretyn/>
								<payappyn/>
								<cmninstcd/>
								<payappmm/>
								<cmntcd/>
								<paydeducretendyn/>
								<paydedutrgtmanyn/>
							</clubdedulist>
						</deducorddetail>
						<deducordreport>
							<clubdedulist/>
						</deducordreport>
					</main>
					<send>
						<getcond>
							<basedd/>
							<cmninstcd/>
							<cmntcd/>
							<workgbn/>
						</getcond>
						<clubdedusave>
							<workgbn/>
							<basepayappmm/>
							<clubdedulist/>
							<cmninstcd/>
							<cmntcd/>
						</clubdedusave>
						<deducord>
							<cmntcd/>
							<cmninstcd/>
							<basedd/>
							<workgbn/>
							<selyn>Y</selyn>
						</deducord>
						<basedd_s/>
						<repotsend>
							<basedd/>
							<cmninstcd/>
							<cmntcd/>
						</repotsend>
						<clubclublist/>
					</send>
					<init>
						<regclubcodelist/>
					</init>
					<hidden>
						<temp/>
					</hidden>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					submit("TRRPA00405");
					
					misfGetUserAuth();
					
					cmb_cmninstcd.disabled = true;
					cmb_cmntcd.disabled = true;
					
					if(DUTY_PAY_YN == 'Y'){
						cmb_cmninstcd.disabled = false;
						cmb_cmntcd.disabled = false;
						misfComboClubCdList(getUserInfo("dutplceinstcd"),cmb_cmntcd,"Y");
					}else{
						if(getUserInfo("dutplcecd") == '4030100000'){ // 재무팀 (?)
							cmb_cmntcd.disabled = false;
							misfComboClubCdList(getUserInfo("dutplceinstcd"),cmb_cmntcd,"Y");
						}else{
							if(model.getValue("/root/init/regclubcodelist/cmntcd") == ''){ // 회장/총무인클럽이 없는경우
								messageBox('권한이 없습니다.','');
								misfComboClubCdList(getUserInfo("dutplceinstcd"),cmb_cmntcd,"Y");
								button5.disabled = true;
								btn_search.disabled = true;
							}else{
								misfComboClubCdList(getUserInfo("dutplceinstcd"),cmb_cmntcd,"",getUserInfo("userid")); // 회장/총무인것만 콤보박스에
								cmb_cmntcd.disabled = false;
							}
						}
					}
					
					misfGridInit(grd_clubclublist);
					misfGridInit(grd_clubdedulist);
					misfMsterDetailSet(grd_clubclublist, null, "TRRPA02601" ,"N"); 
					misfMsterDetailSet(grd_clubdedulist, grd_clubclublist, "TRRPA02603" ,"Y"); 
					grd_clubclublist.fixedcellcheckbox(0, 1) = true;
					
					misfComboComCdList('Z0007', cmb_cmninstcd,'Y');
					var cmninstcd = getUserInfo("dutplceinstcd");
					cmb_cmninstcd.value=cmninstcd;
					var curdate = getCurrentDate();
					var cvtdate = curdate.toDate("YYYYMM");
					ipt_basedd_s.value=cvtdate.getAddDate(0,"M").getDateFormat("YYYYMM");
					ipt_basedd.value=cvtdate.getAddDate(0,"M").getDateFormat("YYYYMM");
				
					/*
					misfGridInit(grd_clubclublist);
					misfGridInit(grd_clubdedulist);
					
					grd_clubclublist.fixedcellcheckbox(0, 1) = true;
					
					misfComboComCdList('Z0007', cmb_cmninstcd,'Y');
					misfComboClubCdList(getUserInfo("dutplceinstcd"),cmb_cmntcd,"Y");
					
					misfMsterDetailSet(grd_clubclublist, null, "TRRPA02601" ,"N"); 
					misfMsterDetailSet(grd_clubdedulist, grd_clubclublist, "TRRPA02603" ,"Y"); 

					 var cmninstcd = getUserInfo("dutplceinstcd");
					 cmb_cmninstcd.value=cmninstcd;
					 var curdate = getCurrentDate();
					var cvtdate = curdate.toDate("YYYYMM");
                         ipt_basedd_s.value=cvtdate.getAddDate(0,"M").getDateFormat("YYYYMM");
                         ipt_basedd.value=cvtdate.getAddDate(0,"M").getDateFormat("YYYYMM");*/										
				]]>
			</script>
			<submission id="TRRPA02601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/getcond" resultref="/root/main/deducord"/>
			<submission id="TRRPA02603" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/deducord" resultref="/root/main/deducorddetail"/>
			<submission id="TRRPA02605" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/clubclublist" resultref="/root/main/deducordreport"/>
			<submission id="TRRPA00405" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/init"/>
		</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="../../../com/commonweb/js/dateHelper.js"/>
	</xhtml:head>
	<xhtml:body 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:742px; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1194px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<button id="btn_search" class="btn1_letter2" style="left:1125px; top:16px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					 var ddstr=ipt_basedd_s.value.substr(0,6);
					    	ipt_basedd.value =ddstr;
					    	ipt_basepayappmm.value=ddstr;
					    	if(ipt_basedd.value ==""){
					    		messageBox("기준년월은","I003");
					    		return;
					    	}
					    	     model.setValue("/root/send/getcond/workgbn","P");
							misfMsterDetailRetrieve(); 
							 grd_clubclublist.subtotalposition = "below";
						grd_clubclublist.subtotal("clear", 0, 0);     
						grd_clubclublist.subtotal("sum",grd_clubclublist.colRef("payinst") , grd_clubclublist.colRef("totmancnt"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");	
					     grd_clubclublist.subtotal("sum",grd_clubclublist.colRef("payinst") , grd_clubclublist.colRef("holdmembcnt"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "");	
					     grd_clubclublist.subtotal("sum",grd_clubclublist.colRef("payinst") , grd_clubclublist.colRef("totmmconvnt"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "");	
					    	grd_clubclublist.subtotal("sum",grd_clubclublist.colRef("payinst") , grd_clubclublist.colRef("paymmconvnt"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "");	
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1110px; y1:16px; x2:1110px; y2:38px; "/>
			<group id="group4" style="left:495px; top:50px; width:695px; height:690px; ">
				<caption id="caption1" class="tit_2" style="left:0px; top:15px; width:170px; height:13px; ">동호회원 LIST</caption>
				<line id="line3" class="line_1" style="x1:0px; y1:30px; x2:695px; y2:30px; "/>
				<datagrid id="grd_clubdedulist" nodeset="/root/main/deducorddetail/clubdedulist" caption="순번^급여기관명^사번^성명^근무부서^등급^회비^공제대상^급여반영여부^비 고" colsep="^" colwidth="36, 88, 63, 59, 85, 45, 74, 58, 80, 67, 100, 100, 100, 100, 100" ellipsis="true" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" tooltip="true" style="left:0px; top:35px; width:694px; height:650px; ">
					<col ref="numno" style="padding-left:5; "/>
					<col ref="posinstnm"/>
					<col ref="emplno" style="text-align:center; "/>
					<col ref="emplnm" style="text-align:center; "/>
					<col ref="deptnm"/>
					<col ref="reglmbrgrdenm"/>
					<col ref="clubcost" format="#,###" style="text-align:right; "/>
					<col ref="paydedutrgtmanyn" style="text-align:center; "/>
					<col ref="payappyn" style="text-align:center; "/>
					<col ref="cmt"/>
					<col ref="seqno" visibility="hidden"/>
					<col ref="cmninstcd" visibility="hidden" _key="true"/>
					<col ref="payappmm" visibility="hidden"/>
					<col ref="cmntcd" visibility="hidden"/>
					<col ref="payinst" visibility="hidden"/>
					<script type="javascript" ev:event="onaftersort">
						<![CDATA[
						grd_clubdedulist.gridToInstance();
						]]>
					</script>
				</datagrid>
			</group>
			<group id="group3" style="left:0px; top:50px; width:490px; height:690px; ">
				<caption id="caption2" class="tit_2" style="left:0px; top:15px; width:109px; height:13px; ">동호회 LIST</caption>
				<line id="line2" class="line_1" style="x1:0px; y1:30px; x2:490px; y2:30px; "/>
				<datagrid id="grd_clubclublist" nodeset="/root/main/deducord/clubclublist" caption="^기관명^동호회명^총인원^보류인원^공제대상액^급여반영액" colsep="^" colwidth="33, 88, 85, 50, 56, 68, 71, 60, 70, 70, 100, 100, 100, 100, 100, 100" ellipsis="true" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" tooltip="true" style="left:0px; top:35px; width:490px; height:650px; ">
					<col checkvalue="Y,N" ref="selyn" type="checkbox"/>
					<col ref="instnm"/>
					<col ref="cmntnm"/>
					<col ref="totmancnt" style="text-align:right; "/>
					<col ref="holdmembcnt" style="text-align:right; "/>
					<col ref="totmmconvnt" format="#,###" style="text-align:right; "/>
					<col ref="paymmconvnt" format="#,###" style="text-align:right; "/>
					<col ref="cmninstcd" visibility="hidden"/>
					<col ref="instnm" visibility="hidden"/>
					<col ref="cmntcd" visibility="hidden"/>
					<col ref="basedd" visibility="hidden"/>
					<col ref="paydeducretyn" visibility="hidden"/>
					<col ref="paydeducretendyn" visibility="hidden"/>
					<col ref="payrefmembcnt" visibility="hidden"/>
					<col ref="workgbn" visibility="hidden"/>
					<col ref="payinst" visibility="hidden"/>
					<script type="javascript" ev:event="onrowchanged">
						<![CDATA[
								var cmntcd = grd_clubclublist.valueMatrix(grd_clubclublist.row, grd_clubclublist.colRef("cmntcd"));
								var cmninstcd = grd_clubclublist.valueMatrix(grd_clubclublist.row, grd_clubclublist.colRef("cmninstcd"));
								var basedd = grd_clubclublist.valueMatrix(grd_clubclublist.row, grd_clubclublist.colRef("basedd"));
								
								model.setValue("/root/send/deducord/cmntcd",cmntcd);
								model.setValue("/root/send/deducord/cmninstcd",cmninstcd);
								model.setValue("/root/send/deducord/basedd",basedd);
								model.setValue("/root/send/deducord/selyn","Y");
								
								//misfMsterDetailRetrieve(); 	
								
								submit("TRRPA02603");
						   		for(i=grd_clubdedulist.fixedRows; i< grd_clubdedulist.rows;i++){
								var paydedutrgtmanyn= grd_clubdedulist.valueMatrix(i,grd_clubdedulist.colRef("paydedutrgtmanyn"));
								var payappyn= grd_clubdedulist.valueMatrix(i,grd_clubdedulist.colRef("payappyn"));
								var null_check3 = model.getValue(grd_clubdedulist.attribute("nodeset")+"[" + i + "]/payrefmembcnt");
								if(null_check3 !='0' && paydedutrgtmanyn =='Y' && payappyn=='N'){
								grd_clubdedulist.rowStyle(i, "all", "background-color") = "#ffcccc";
								}else{
									grd_clubdedulist.rowStyle(i, "all", "background-color") = "#ffffff";
								}
							}		
							 grd_clubdedulist.subtotalposition = "below";
						grd_clubdedulist.subtotal("clear", 0, 0);     
						grd_clubdedulist.subtotal("sum",grd_clubdedulist.colRef("payinst") , grd_clubdedulist.colRef("clubcost"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");						
						
				
						grd_clubclublist.dispatch("onmouseup");
						]]>
					</script>
				</datagrid>
			</group>
			<input id="ipt_basedd_s" ref="/root/send/basedd_s" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:90px; top:18px; width:125px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var instcd = cmb_cmninstcd.value;
						if( getStringLength(ipt_basedd_s.value) == "6" ) {
							model.removeNodeset(cmb_cmninstcd.attribute("ref"));
							model.makeNode("/root/send/getcond/cmninstcd");
							misfComboInstCdListMulti("cmb_cmninstcd",ipt_basedd_s.value,"","Y");
							cmb_cmninstcd.value = instcd;
							model.refresh();
						}						
					]]>
				</script>
			</input>
			<input id="ipt_basedd" ref="/root/send/getcond/basedd" visibility="hidden"/>
			<caption id="caption8" class="search_name" style="left:6px; top:19px; width:81px; height:17px; vertical-align:middle; ">기준년월:</caption>
			<input id="ipt_basepayappmm" ref="/root/send/clubdedusave/basepayappmm"/>
			<input id="input1" ref="/root/send/clubdedusave/workgbn" visibility="hidden"/>
			<caption id="caption3" class="search_name" style="left:235px; top:20px; width:81px; height:17px; vertical-align:middle; ">기    관:</caption>
			<select1 id="cmb_cmninstcd" ref="/root/send/getcond/cmninstcd" class="combo_default" appearance="minimal" style="left:320px; top:20px; width:160px; height:19px; ">
				<choices>
					<itemset nodeset="/root/main/init">
						<label ref="cnstnm"/>
						<value ref="cnstcd"/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					    var instcd = model.getValue(cmb_cmninstcd.attribute("ref"));
								misfComboClubCdList(instcd,cmb_cmntcd_s,"Y");
								model.refresh();
					]]>
				</script>
			</select1>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12; width:1195px; height:27px; ">
			<line id="line1" class="line_6" style="x1:0px; y1:25; x2:1195px; y2:25; "/>
			<button id="button5" class="btn4_letter2" style="left:1135px; top:2px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					if(ipt_basedd_s.value ==""){
					    		messageBox("기준년월은","I003");
					    		return;
					    	}
//					model.setValue("/root/send/repotsend/basedd",ipt_basedd_s.value );
//					model.setValue("/root/send/repotsend/cmninstcd",getUserInfo("dutplceinstcd"));
//					model.setValue("/root/send/repotsend/cmntcd","");
					
					for (var i = grd_clubclublist.fixedRows; i < grd_clubclublist.rows; i++) {
						if (grd_clubclublist.valueMatrix(i, grd_clubclublist.colRef("selyn")) == "Y") {
							grd_clubclublist.rowStatus(i) = "2";
						}
					}
					
					model.setValue("/root/send/clubclublist", grd_clubclublist.getUpdateData());
					submit("TRRPA02605");
				     exeReportPreview("RPRPA02601", "XMLSTR", "/root/send/report");
					]]>
				</script>
			</button>
		</group>
		<caption id="caption4" class="search_name" style="left:510px; top:59px; width:81px; height:17px; vertical-align:middle; ">동호회명:</caption>
		<select1 id="cmb_cmntcd" ref="/root/send/getcond/cmntcd" class="combo_search" appearance="minimal" style="left:595px; top:59px; width:160px; height:19px; ">
			<choices>
				<itemset nodeset="/root/main/init">
					<label ref="cnstnm"/>
					<value ref="cnstcd"/>
				</itemset>
			</choices>
		</select1>
	</xhtml:body>
</xhtml:html>