YNU_JEUS/app_home/himed/webapps/mis/paydedufactmngtweb/xrw/SMRWD03400_간호부공제자료등록(성가Excel).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>간호부공제자료등록(Excel)</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<nursededu>
							<nursededulist/>
						</nursededu>
						<nurseempl>
							<nurseempllist/>
						</nurseempl>
						<payendyn>
							<payendynlist/>
						</payendyn>
					</main>
					<send>
						<nursededu>
							<dedumm/>
							<deduitemcd/>
							<emplno/>
						</nursededu>
						<save>
							<nursededulist/>
						</save>
					</send>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					misfGridInit(grd_nursededulist);
					misfMsterDetailSet(grd_nursededulist,null, "TRRWD03001" ,"Y"); 	
					
					var curdate = getCurrentDate();
					
					model.setValue(ipt_paydedumm.attribute("ref") , curdate.substr(0,6));
				
					cmb_deduitemcd.select(0);
					//misfComboComCdListMulti("Z0007,R0099,R0112,R0130","cmb_instcd,cmb_paydeduflag,cmb_SalDfrayFlag,grd_paydedulist.timsamtflag");
					model.refresh();
					
					ipt_paydedumm.dispatch("xforms-value-changed");
				]]>
			</script>
			<submission id="TRRWD03001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/nursededu" resultref="/root/main/nursededu"/>
			<submission id="TXRWD03001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" resultref="/root/hidden/temp"/>
			<submission id="TRRWD03002" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/nursededu" resultref="/root/main/nurseempl"/>
			<script type="javascript">
				<![CDATA[
					function fcheckpaydedu()
					{
						var erroryn = "N";
						model.setValue("/root/send/nursededu/emplno", grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("emplno")));
							submit("TRRWD03002");
							
							var prfshipflag = model.getValue("/root/main/nurseempl/nurseempllist/prfshipflag");
							var jobkindcd = model.getValue("/root/main/nurseempl/nurseempllist/jobkindcd");
							var relign = model.getValue("/root/main/nurseempl/nurseempllist/relign");
							var gndr =  model.getValue("/root/main/nurseempl/nurseempllist/gndr");
							var scholflag =  model.getValue("/root/main/nurseempl/nurseempllist/scholflag");
							var schoolcd =  model.getValue("/root/main/nurseempl/nurseempllist/schoolcd");
							var frmrmert =  model.getValue("/root/main/nurseempl/nurseempllist/frmrmert");
							var jobrespcd =  model.getValue("/root/main/nurseempl/nurseempllist/jobrespcd");
							var retireyn =  model.getValue("/root/main/nurseempl/nurseempllist/retireyn");
							var payinst = model.getValue("/root/main/nurseempl/nurseempllist/payinst");
							var jobposcd = model.getValue("/root/main/nurseempl/nurseempllist/jobposcd");
							var preststatcd = model.getValue("/root/main/nurseempl/nurseempllist/preststatcd");
							var deptcd = model.getValue("/root/main/nurseempl/nurseempllist/deptcd");
							var holyordflag = model.getValue("/root/main/nurseempl/nurseempllist/holyordflag");
							var licnyn = model.getValue("/root/main/nurseempl/nurseempllist/licnyn");
							var gvnoffcorddetlflag  = model.getValue("/root/main/nurseempl/nurseempllist/gvnoffcorddetlflag");
							
							if (retireyn == "Y") {
								messageBox("퇴직상태 이므로   추가할수","I004");
								erroryn = "Y";
							}
							
							if (payinst != getUserInfo("dutplceinstcd")) {
								messageBox("급여 공제기관이 다르므로   추가할수","I004");
								erroryn = "Y";
							}
							
//							if (preststatcd != "01") {
//								messageBox("휴직 상태므로   추가할수","I004");
//								erroryn = "Y";
//							}
							
							if (jobposcd == "1844") {
								messageBox("파견직 이므로   추가할수","I004");
								erroryn = "Y";
							}
							
							if (jobposcd == "1797") {
								messageBox("교육연구조교 이므로   추가할수","I004");
								erroryn = "Y";
							}
							
							
							if (grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  != "06"  && jobposcd == "1775") {
								messageBox("임시직 이므로   추가할수","I004");
								erroryn = "Y";
							}
							
							if (gvnoffcorddetlflag == "065") {
								messageBox("수습상태 이므로   추가할수","I004");
								erroryn = "Y";
							}
							
							if (gvnoffcorddetlflag == "053") {
								messageBox("무급 휴직 상태 이므로   추가할수","I004");
								erroryn = "Y";
							}
							

							if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "01" ) { //간호사회
								if (prfshipflag != "41") {
									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (licnyn != "Y") {
									messageBox("간호사 자격증이 없으므로   추가할수","I004");
									erroryn = "Y";
								}
							}
							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "02" ) { //가톨릭회
								if (prfshipflag != "41") {
									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (licnyn != "Y") {
									messageBox("간호사 자격증이 없으므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (relign != "02") {
									messageBox("천주교가 아니므로   추가할수","I004");
									erroryn = "Y";
								}
							}
//							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "03" ) { //병원간호사회
//								if (prfshipflag != "41") {
//									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
//									erroryn = "Y";
//								}
//								
//								if (jobkindcd != "1140") {
//									messageBox("직종이 간호직이 아니므로   추가할수","I004");
//									erroryn = "Y";
//								}
//							}
							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "04" ) { //초록회
								if (prfshipflag != "41") {
									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (deptcd != "3040200000") {
									messageBox("간호부가 아니므로   추가할수","I004");
									erroryn = "Y";
								}
							
								if (jobkindcd != "2820") {
									messageBox("병원지원직이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (gndr != "F") {
									messageBox("여자가 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
							}
							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "05" ) { //수녀님병동회비
								if (prfshipflag != "41") {
									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								 if (holyordflag != "3") {
									messageBox("수녀님이 아니므로  추가할수","I004");
									erroryn = "Y";
								}
							
								if (deptcd != "3040200000") {
									messageBox("간호부가 아니므로   추가할수","I004");
									erroryn = "Y";
								}

								
							}
							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "06" ) { //대한간호협회
								if (prfshipflag != "41" && prfshipflag != "51") {
									messageBox("교직구분이 직원, 비정규직이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (licnyn != "Y") {
									messageBox("간호사 자격증이 없으므로   추가할수","I004");
									erroryn = "Y";
								}
								
							}
							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "07" ) { //부천시간호사회
								if (prfshipflag != "41") {
									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (licnyn != "Y") {
									messageBox("간호사 자격증이 없으므로   추가할수","I004");
									erroryn = "Y";
								}

							}
							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "08" ) { //UM회비
								if (prfshipflag != "41") {
									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (deptcd != "3040200000") {
									messageBox("간호부가 아니므로   추가할수","I004");
									erroryn = "Y";
								}

								if (jobrespcd != "1070" && jobrespcd != "1080" && jobrespcd != "1901" && jobrespcd != "2010") {
									messageBox("직책이 UM이상이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
							}
//							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "09" ) { //기타1
//								if (prfshipflag != "41") {
//									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
//									erroryn = "Y";
//								}
//								
//								if (jobkindcd != "1140") {
//									messageBox("직종이 간호직이 아니므로   추가할수","I004");
//									erroryn = "Y";
//								}
//							}
//							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "10" ) { //기타2
//								if (prfshipflag != "41") {
//									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
//									erroryn = "Y";
//								}
//								
//								if (jobkindcd != "1140") {
//									messageBox("직종이 간호직이 아니므로   추가할수","I004");
//									erroryn = "Y";
//								}
//							}
							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "11" ) { //청의회
								if (prfshipflag != "41") {
									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (deptcd != "3040200000") {
									messageBox("간호부가 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (jobkindcd != "2820") {
									messageBox("병원지원직이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (gndr != "M") {
									messageBox("남자가 아니므로   추가할수","I004");
									erroryn = "Y";
								}
							}
							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "12" ) { //간호사입회비
								if (prfshipflag != "41") {
									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
									erroryn = "Y";
								}
								
								if (licnyn != "Y") {
									messageBox("간호사 자격증이 없으므로   추가할수","I004");
									erroryn = "Y";
								}
							}
//							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "13" ) { //꽃동네회비
//								if (prfshipflag != "41") {
//									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
//									erroryn = "Y";
//								}
//								
//								if (jobkindcd != "1140" && jobkindcd != "2820") {
//									messageBox("직종이 간호직, 병원지원직이 아니므로   추가할수","I004");
//									erroryn = "Y";
//								}
//							}
//							else if ( grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("deduitemcd"))  == "14" ) { //기숙사회비
//								if (prfshipflag != "41") {
//									messageBox("교직구분이 직원이 아니므로   추가할수","I004");
//									erroryn = "Y";
//								}
//								
//								if (jobkindcd != "1140" && jobkindcd != "2820") {
//									messageBox("직종이 간호직, 병원지원직이 아니므로   추가할수","I004");
//									erroryn = "Y";
//								}
//							}
							
							if (erroryn == "Y") {
								grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("emplno")) = "";
								grd_nursededulist.valueMatrix(grd_nursededulist.row, grd_nursededulist.colRef("emplnm")) = "";
							}
					}
				]]>
			</script>
			<submission id="TRRWD03103" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/nursededu" resultref="/root/main/payendyn"/>
		</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="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/paybaseinfomngtweb/js/RWC001.js"/>
		<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
		<script type="javascript" src="../../../mis/paybaseinfomngtweb/js/RWC001.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; ">간호부 공제 자료 등록(Excel)</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:1194px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<button id="btn_search" class="btn1_letter2" style="left:1128px; top:16px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfMsterDetailRetrieve(); 
						var endyn = model.getValue("/root/main/payendyn/payendynlist/endyn");
						
						if (endyn != "Y" ) {
							if (grd_nursededulist.rows - grd_nursededulist.fixedRows > 0) {
								if (grd_nursededulist.valueMatrix(grd_nursededulist.fixedRows, grd_nursededulist.colRef("payrefltyn")) == "Y") {
									btn_save.disabled = true;
									btn_grdaddnursededulist.disabled = true;
									btn_grddelnursededulist.disabled = true;
									btn_inputexcel.disabled = true;
									
									
								}
								else if (grd_nursededulist.valueMatrix(grd_nursededulist.fixedRows, grd_nursededulist.colRef("endyn")) == "Y") {
									btn_save.disabled = true;
									btn_grdaddnursededulist.disabled = true;
									btn_grddelnursededulist.disabled = true;
									btn_inputexcel.disabled = true;
								}
								else {
									
									btn_save.disabled = false;
									btn_grdaddnursededulist.disabled = false;
									btn_grddelnursededulist.disabled = false;
									btn_inputexcel.disabled = false;
								}
								
							}
						}
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1121px; y1:16px; x2:1121px; y2:38px; "/>
			<line id="line1" class="line_1" style="x1:0px; y1:71px; x2:1192px; y2:71px; "/>
			<caption id="caption1" class="tit_2" style="left:2px; top:56px; width:211px; height:14px; ">간호부 공제 자료(Excel) List</caption>
			<button id="btn_grdaddnursededulist" class="btn2_letter3" style="left:1018px; top:50px; width:53px; height:19px; ">
				<caption>행추가</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridIUD(grd_nursededulist, "A");
					]]>
				</script>
			</button>
			<button id="btn_inputexcel" class="btn2_letter4" style="left:1130px; top:50px; width:64px; height:19px; ">
				<caption>엑셀입력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridInit(grd_nursededulist);
						
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						grd_nursededulist.loadExcel(fileName, 1, true);
						//grd_paydedulist.deleteRow(grd_paydedulist.fixedRows);
						grd_nursededulist.refresh();	
						
						var dedumm = ipt_paydedumm.value;
						var deduitemcd = cmb_deduitemcd.value;
												
						for (var i = grd_nursededulist.fixedRows; i < grd_nursededulist.rows; i++) {
							grd_nursededulist.valueMatrix(i, grd_nursededulist.colRef("dedumm")) = dedumm;
							//grd_nursededulist.valueMatrix(i, grd_nursededulist.colRef("deduitemcd")) = deduitemcd;
							grd_nursededulist.rowStatus(i) = 1;
						}
						
						cmb_deduitemcd.dispatch("xforms-value-changed");
						
						model.refresh();
					]]>
				</script>
			</button>
			<button id="btn_grddelnursededulist" class="btn2_letter3" style="left:1074px; top:50px; width:53px; height:19px; ">
				<caption>행삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridIUD(grd_nursededulist, "D");		
					]]>
				</script>
			</button>
			<caption id="caption3" class="search_name" style="left:10px; top:19px; width:74px; height:17px; ">공제월:</caption>
			<input id="ipt_paydedumm" ref="/root/send/nursededu/dedumm" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:86px; top:18px; width:100px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						submit("TRRWD03103");
						
						var endyn = model.getValue("/root/main/payendyn/payendynlist/endyn");
						
						if (	endyn == "Y" ) {
							messageBox("급여 마감이 되어서 저장 ","E001");
							btn_save.disabled = true;
							btn_grdaddnursededulist.disabled = true;
							btn_grddelnursededulist.disabled = true;
							btn_inputexcel.disabled = true;
							
						}
						else {
							btn_save.disabled = false;
							btn_grdaddnursededulist.disabled = false;
							btn_grddelnursededulist.disabled = false;
							btn_inputexcel.disabled = false;
						}			
					]]>
				</script>
			</input>
			<datagrid id="grd_nursededulist" nodeset="/root/main/nursededu/nursededulist" caption="사원번호^공제금액^성명^근무부서^근무지^비고^공제월^공제항목코드^완료여부^급여반영여부|사원번호^공제금액^성명^근무부서^근무지^비고^공제월^공제항목코드^완료여부^급여반영여부" colsep="^" colwidth="96, 104, 112, 170, 159, 507, 49, 80, 40, 80" dataheight="25" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:77px; width:1192px; height:663px; ">
				<col ref="emplno" type="inputbutton"/>
				<col ref="deduamt" type="input" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="emplnm"/>
				<col ref="deptnm"/>
				<col ref="dutplcenm"/>
				<col ref="cmt" type="input"/>
				<col ref="dedumm" visibility="hidden"/>
				<col ref="deduitemcd" visibility="hidden"/>
				<col ref="endyn" visibility="hidden"/>
				<col ref="payrefltyn" visibility="hidden"/>
				<col ref="jobkindcd" visibility="hidden"/>
				<col ref="deptcd" visibility="hidden"/>
				<script type="javascript" ev:event="onbuttonclick">
					<![CDATA[
						if (grd_nursededulist.colAttribute(grd_nursededulist.col,"ref") == "emplno" ) { //계산기준코드
							var recv_list = "emplno,emplnm";
							 	
							rpbfOpenPopUpList("SPRPB00101", grd_nursededulist, recv_list,"","N");
							
							model.refresh();
							
							fcheckpaydedu();
						 }				
					]]>
				</script>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						if (grd_nursededulist.colAttribute(grd_nursededulist.col,"ref") == "emplno" ) { //계산기준코드
							var recv_list = "emplno,emplnm";
							misfValidationCheck("01-1", "", recv_list);
							model.refresh();
							
							fcheckpaydedu();
						}			
					]]>
				</script>
			</datagrid>
			<caption id="caption5" class="search_name" style="left:265px; top:18px; width:86px; height:17px; ">공제종류:</caption>
			<select1 id="cmb_deduitemcd" ref="/root/send/nursededu/deduitemcd" class="combo_s_essential" appearance="minimal" style="left:346px; top:17px; width:194px; height:19px; ">
				<choices>
					<item>
						<label>간호사회</label>
						<value>01</value>
					</item>
					<item>
						<label>가톨릭간호사회</label>
						<value>02</value>
					</item>
					<item>
						<label>대한간호협회</label>
						<value>06</value>
					</item>
					<item>
						<label>부천시간호사회</label>
						<value>07</value>
					</item>
					<item>
						<label>수녀님병동회비</label>
						<value>05</value>
					</item>
					<item>
						<label>UM회비</label>
						<value>08</value>
					</item>
					<item>
						<label>초록회</label>
						<value>04</value>
					</item>
					<item>
						<label>청의회</label>
						<value>11</value>
					</item>
					<item>
						<label>간호사입회비</label>
						<value>12</value>
					</item>
					<item>
						<label>보수교육비</label>
						<value>13</value>
					</item>
					<item>
						<label>기타1</label>
						<value>09</value>
					</item>
					<item>
						<label>기타2</label>
						<value>10</value>
					</item>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var deduitemcd = cmb_deduitemcd.value;
						
						for (var i = grd_nursededulist.fixedRows; i < grd_nursededulist.rows; i++ ) {
							if (grd_nursededulist.rowStatus(i) == 1 || grd_nursededulist.rowStatus(i) == 3 ) {
								grd_nursededulist.valueMatrix(i, grd_nursededulist.colRef("deduitemcd")) = deduitemcd;
							}
						}
					]]>
				</script>
			</select1>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12; width:1195px; height:27px; ">
			<button id="btn_save" class="btn4_letter2" style="left:1139px; top:3; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfSave("TXRWD03001");
						
						btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</button>
			<button id="button35" class="btn4_letter3" style="left:1069px; top:3; width:68px; height:22px; ">
				<caption>초기화</caption>
			</button>
			<line id="line9" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
		</group>
	</xhtml:body>
</xhtml:html>