YNU_JEUS/app_home/himed/webapps/mis/pubwelfmngtweb/xrw/SMRPA07100_월별경조사등록.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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>
						<congraamtreqlist>
							<baseym/>
							<congraymd/>
							<emplno/>
							<emplnm/>
							<utplceinst/>
							<dutplcedeptnm/>
							<rregno/>
							<famyname/>
							<famyrel/>
							<cmt/>
							<seqno/>
							<dutplcedeptcd/>
						</congraamtreqlist>
					</main>
					<send>
						<search>
							<dutplceinst/>
							<baseym/>
							<emplno/>
							<emplnm/>
							<emplno_g/>
							<famydoduyn/>
							<workgbn/>
						</search>
						<savelist>
							<congraamtreqlist/>
						</savelist>
					</send>
					<init>
						<checkbox1>
							<label>중복여부</label>
							<value>Y</value>
						</checkbox1>
						<systemflag/>
					</init>
					<temp/>
					<dataynlist>
						<baseamtyn/>
						<requestyn/>
						<creatyn/>
						<endyn/>
						<payrefltyn/>
					</dataynlist>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
					misfGridInit(grd_congraamtreqlist);
					misfMsterDetailSet(grd_congraamtreqlist,null,"TRRPA07101","Y");
					btn_save.disabled = !(checkAuth("X"));
					// 공통코드 바인딩   silver
				    misfComboComCdList('Z0007', cmb_dutplceinst,"Y");
				    //misfComboComCdList('Z0007', grd_congraamtreqlist.dutplceinst,"");
					misfComboInstCdListMulti("grd_congraamtreqlist.dutplceinst",getCurrentDate(),"","Y"); 
				    //  	misfComboCopyItemSet(cmb_dutplceinst, "", grd_congraamtreqlist, "dutplceinst");
				    //  	var dutplceinst = getUserInfo("dutplceinstcd");
				    // 	   cmb_dutplceinst.value=dutplceinst;
					
					if (getUserInfo("dutplceinstcd") == "017") {
						cmb_dutplceinst.value = "017";
						cmb_dutplceinst.disabled = true;
					}
					
					btn_search.dispatch("DOMActivate");		
					ipt_systemflag.value = "C";
				
				]]>
			</script>
			<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/humtrafactmngtweb/js/RPB001.js"/>
			<script type="javascript">
				<![CDATA[

					// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
					function fInitialize() {
						model.removeNodeset("/root/main/congraamtreqlist");
						model.resetInstanceNode("/root/send");
						model.refresh();
						  //  var dutplceinst = getUserInfo("dutplceinstcd");
						  //   cmb_dutplceinst.value=dutplceinst;
						     var curDate = getCurrentDate().toDate();
					model.setValue("/root/send/search/baseym", curDate.getDateFormat('YYYYMM'));
					}

					function fsaveCheckValue(){
		                           var iInsCnt = 0;
					var iDupCnt = 0;
					var bDel	= false;  
					 
					var icolidx=grd_congraamtreqlist.colRef("congraymd"); 
					var icolidx1=grd_congraamtreqlist.colRef("emplno");  
					var icolidx2=grd_congraamtreqlist.colRef("rregno");  
					
					for(var i=0; i<grd_congraamtreqlist.rows; i++)
					{
						if(grd_congraamtreqlist.rowStatus(i) == 1 || grd_congraamtreqlist.rowStatus(i) == 3)
						{
							iInsCnt = i;
							break;
						}
					}

		                            for(var i=iInsCnt; i<grd_congraamtreqlist.rows; i++)
						{
							for(var j=1; j<i; j++)
							{
								if(grd_congraamtreqlist.valueMatrix(i, icolidx) == grd_congraamtreqlist.valueMatrix(j, icolidx) && grd_congraamtreqlist.valueMatrix(i, icolidx1) == grd_congraamtreqlist.valueMatrix(j, icolidx1) && grd_congraamtreqlist.valueMatrix(i, icolidx2) == grd_congraamtreqlist.valueMatrix(j, icolidx2))
								{
									if(grd_congraamtreqlist.rowStatus(i) == 1 || grd_congraamtreqlist.rowStatus(i) == 3)
									{  var ret= messageBox("중복된 행을 삭제", "Q001");	
										if (ret != 6) { // not OK
										bDel = false;
											return false;
										}else{
										grd_congraamtreqlist.deleteItem(i);
										iDupCnt++;
										bDel = true;
										}
									}
								}
							}
							
							if(bDel)
							{
								bDel = false;
								i--;
							}
						}
						
						if(iDupCnt > 0)
						{
							messageBox("[ " + iDupCnt + " ]" + " 건의 중복된 행이 삭제", "I001");		
						}
						
						return true;
				}	
				]]>
			</script>
			<submission id="TRRPA07101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/main/congraamtreqlist"/>
			<submission id="TXRPA07101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/savelist" resultref="/root/temp"/>
			<submission id="TXRPA07102" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/temp"/>
			<submission id="TRRPA07102" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/dataynlist"/>
		</model>
	</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:744px; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:35px; "/>
			<caption id="cap_dutplceinst" class="search_name" style="left:215px; top:19px; width:86px; height:17px; ">기     관 :</caption>
			<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[
						if(!isRequiredControls("ipt_baseym"))return;	
						//var famydoduyn=model.getValue("/root/send/search/famydoduyn");
						//if(famydoduyn =='Y'){
						//	model.setValue("/root/send/search/baseym","");
						//}
						submit("TRRPA07101");	
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1110px; y1:16px; x2:1110px; y2:38px; "/>
			<line id="line207" class="line_1" style="x1:0; y1:69; x2:1195; y2:69px; "/>
			<datagrid id="grd_congraamtreqlist" nodeset="/root/main/congraamtreqlist" caption="기준년월^사원번호^성 명^근무기관명^근무지부서명^가족관계^가족관계^가족관계^경조사일자^비고|기준년월^사원번호^성 명^근무기관명^근무지부서명^주민등록번호^성명^관계^경조사일자^비고" colsep="^" colwidth="92, 101, 100, 168, 104, 126, 78, 97, 100, 157, 100, 100, 100" dataheight="25" ellipsis="true" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" tooltip="true" style="left:0px; top:74px; width:1194px; height:670px; ">
				<col ref="baseym" format="yyyy-mm"/>
				<col ref="emplno" type="inputbutton" _key="true" style="text-align:center; "/>
				<col ref="emplnm" style="text-align:center; "/>
				<col id="dutplceinst" disabled="true" ref="dutplceinst" type="combo" _key="true" style="text-align:center; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col ref="dutplcedeptnm"/>
				<col ref="rregno" type="inputbutton" format="999999-9999999" _key="true" style="text-align:center; "/>
				<col ref="famyname" style="text-align:center; "/>
				<col ref="famyrelnm" style="text-align:center; "/>
				<col ref="congraymd" type="inputdate" format="yyyy-mm-dd" _key="true" style="text-align:center; "/>
				<col imemode="hangul" ref="cmt" type="input"/>
				<col ref="seqno" visibility="hidden"/>
				<col ref="famyrel" visibility="hidden"/>
				<col ref="dutplcedeptcd" visibility="hidden"/>
				<script type="javascript" ev:event="onbuttonclick">
					<![CDATA[
						if (grd_congraamtreqlist.col == 2) {//사원번호 버튼을 눌렀을 때
							var recv_list = "emplno,emplnm,dutplceinst,dutplcedeptcd,dutplcedeptnm";
							 	
							//rpbfOpenPopUpList("SPRPB00101", grd_congraamtreqlist, recv_list,"","N","Y");
							rpbfOpenPopUpList("SPRPB00101", grd_congraamtreqlist, recv_list,"ipt_systemflag","N");
							model.refresh();
						}
						
						if (grd_congraamtreqlist.col == 6) {//가족사항 조회
						var emplno= grd_congraamtreqlist.valueMatrix(grd_congraamtreqlist.row,2);
						if(emplno ==""){
							messageBox("해당 사원을 ","C001");
							return
						}else{
							var emplno= grd_congraamtreqlist.valueMatrix(grd_congraamtreqlist.row,2);
							ipt_emplno_g.value=emplno;
							var recv_list = "rregno,famyname,famyrelnm,famyrel";
							misfOpenPopUpList("32", grd_congraamtreqlist,"",recv_list);
							model.refresh();
						}	
						}			
					]]>
				</script>
			</datagrid>
			<select1 id="cmb_dutplceinst" ref="/root/send/search/dutplceinst" class="combo_s_essential" appearance="minimal" style="left:300px; top:18px; width:190px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<button id="btn_grddel" class="btn2_letter3" style="left:1069px; top:48px; width:53px; height:19px; ">
				<caption>행삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridIUD(grd_congraamtreqlist,"D");
						model.refresh();		
					]]>
				</script>
			</button>
			<button id="btn_grdadd" class="btn2_letter3" style="left:1013px; top:48px; width:53px; height:19px; ">
				<caption>행추가</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridIUD(grd_congraamtreqlist, "A");	
						   var cur_row=grd_congraamtreqlist.row;  
					]]>
				</script>
			</button>
			<caption id="caption9" class="tit_2" style="left:0px; top:54px; width:183px; height:14px; ">월별 경조사 내역</caption>
			<input id="ipt_baseym" ref="/root/send/search/baseym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:100px; top:18px; width:100px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					btn_search.dispatch("DOMActivate");
					
					var instcd = cmb_dutplceinst.value;
					if( getStringLength(ipt_baseym.value) == "6" ) {
						model.removeNodeset(cmb_dutplceinst.attribute("ref"));
						model.makeNode("/root/send/search/dutplceinst");
						misfComboInstCdListMulti("cmb_dutplceinst",ipt_baseym.value,"","Y");
						cmb_dutplceinst.value = instcd;
						model.refresh();
					}	
					]]>
				</script>
			</input>
			<caption id="cap_baseym" class="search_name" style="left:15px; top:19px; width:91px; height:17px; ">기준년월:</caption>
			<input id="ipt_emplnm" ref="/root/send/search/emplnm" class="input_search" navindex="21" style="left:699px; top:18px; width:106px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
							inputEnterKey("btn_search", "DOMActivate");	
					]]>
				</script>
			</input>
			<caption id="cap_emplno" class="search_name" style="left:513px; top:19px; width:99px; height:17px; ">사원번호 :</caption>
			<input id="ipt_emplno" ref="/root/send/search/emplno" class="input_search" navindex="20" style="left:604px; top:18px; width:69px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
							inputEnterKey("btn_search", "DOMActivate");	
					]]>
				</script>
			</input>
			<button id="btn_emplsearch" class="icon_search" style="left:679px; top:18px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					        	var recv_list = "emplno,emplnm";
							 	
							//rpbfOpenPopUpList("SPRPB00101", grd_congraamtreqlist, recv_list,"","N","Y");
							rpbfOpenPopUpList("SPRPB00101", ipt_emplno, recv_list,"ipt_systemflag","N");
							model.refresh();
					]]>
				</script>
			</button>
			<input id="ipt_emplno_g" ref="/root/send/search/emplno_g" visibility="hidden" style="left:930px; top:20px; width:55px; height:19px; "/>
			<select id="ckb_famydoduyn" ref="/root/send/search/famydoduyn" class="checkbox_search" overflow="visible" appearance="full" style="left:825px; top:20px; width:95px; height:15px; ">
				<choices>
					<itemset nodeset="/root/init/checkbox1">
						<label ref="label"/>
						<value ref="value"/>
					</itemset>
				</choices>
			</select>
			<input id="input1" ref="/root/send/search/workgbn" visibility="hidden" style="left:1000px; top:20px; width:55px; height:19px; "/>
			<input id="ipt_systemflag" ref="/root/init/systemflag" visibility="hidden" style="left:1020px; top:20px; width:55px; height:19px; "/>
			<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", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
						if (fileName != "")
						{
							grd_congraamtreqlist.saveExcel(fileName, "SheetName", true, true, "", "");
						}		
					]]>
				</script>
			</button>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
			<line id="line11" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="btn_save" class="btn4_letter2" style="left:1134px; top:3px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var updtdata = getGridUpdateData(grd_congraamtreqlist);

						if (updtdata == "" ) {
							messageBox("변경된 데이터가","I004");
							return;
						}
						var retMes =  messageBox("저장 하시겠습니까?", "Q999");
						if ( retMes != 6) {
							return;
						}
						submit("TRRPA07102");
						var creatyn=model.getValue("/root/dataynlist/creatyn");
						if(creatyn =='Y'){
							messageBox("공제생성이 완료된 자료는 저장 ","E001");
						return;
						}
						 if(!checkKeyColumn("grd_congraamtreqlist"))return;
						//if(!fsaveCheckValue())return;
						misfSave("TXRPA07101");
					]]>
				</script>
			</button>
			<button id="btn_clear" class="btn4_letter4" style="left:1052px; top:3px; width:80px; height:22px; ">
				<caption>생성취소</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var updtdata = getGridUpdateData(grd_congraamtreqlist);
					if (updtdata != "" ) {
						var ret = messageBox("그리드에 작업 중인 내용이 있습니다. 초기화 작업을","Q003");
						if (ret != 6) { // not OK
							return;
						}
					}
					var retMes =  messageBox("생성된 경조금공제자료를 ", "Q007");
						if ( retMes != 6) {
							return;
						}
					submit("TRRPA07102");

					var creatyn=model.getValue("/root/dataynlist/creatyn");
					var endyn= model.getValue("/root/dataynlist/endyn");
					var payrefltyn=model.getValue("/root/dataynlist/payrefltyn");

					if(creatyn !='Y'){
						messageBox("취소할 자료가 ","I004");
						return;
					}
					if(endyn =='Y'){
						messageBox("마감된 자료는 취소할 수  ","I004");
						return;
					}
					model.setValue("/root/send/search/workgbn","D");
					submit("TXRPA07102");
					if (model.getValue(gvErrorMsgPath + "/type") != "error"){
						messageBox("경조금 공제취소 작업이 ","I001");
						}
					]]>
				</script>
			</button>
			<button id="button1" class="btn4_letter3" style="left:900px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var updtdata = getGridUpdateData(grd_congraamtreqlist);
					if (updtdata != "" ) {
						var ret = messageBox("그리드에 작업 중인 내용이 있습니다. 초기화 작업을","Q003");
						if (ret != 6) { // not OK
							return;
						}
					}
					fInitialize();	
					]]>
				</script>
			</button>
			<button id="button2" class="btn4_letter4" style="left:970px; top:3px; width:80px; height:22px; ">
				<caption>공제생성</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var updtdata = getGridUpdateData(grd_congraamtreqlist);
					if (updtdata != "" ) {
						var ret = messageBox("그리드에 작업 중인 내용이 있습니다. 초기화 작업을","Q003");
						if (ret != 6) { // not OK
							return;
						}
					}
					var retMes =  messageBox("경조금 공제를 ", "Q004");
						if ( retMes != 6) {
							return;
						}
						var dutplceinst = '103';//getUserInfo("dutplceinstcd");
						model.setValue("/root/send/search/dutplceinst",dutplceinst);
					submit("TRRPA07102");
					var baseamtyn=model.getValue("/root/dataynlist/baseamtyn");
					var requestyn=model.getValue("/root/dataynlist/requestyn");
					var creatyn=model.getValue("/root/dataynlist/creatyn");
					var endyn= model.getValue("/root/dataynlist/endyn");
					var payrefltyn=model.getValue("/root/dataynlist/payrefltyn");
					if(baseamtyn !='Y'){
						messageBox("직급별 공제금액이 입력되지 ","E007");
						return;
					}
					if(requestyn !='Y'){
						messageBox("생성할 자료가  ","I004");
						return;
					}
					model.setValue("/root/send/search/dutplceinst",'103');
					model.setValue("/root/send/search/baseym",ipt_baseym.value);
					model.setValue("/root/send/search/workgbn","C");
					submit("TXRPA07102");
					if (model.getValue(gvErrorMsgPath + "/type") != "error"){
						messageBox("경조금 공제생성 작업이 ","I001");
						}
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>