YNU_JEUS/app_home/himed/webapps/mis/purcbaseweb/xrw/SMRSM00500_물류MSDS물품일괄등록.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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" xmlns:cs="http://www.comsquare.co.kr/xforms">
	<xhtml:head>
		<xhtml:title>신규물질 등록 조회(물류)</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<condition>
							<fromdd/>
							<todd/>
						</condition>
						<goodlist>
							<checkflag/>
							<matrnm/>
							<goodcd/>
							<goodnm/>
							<goodspec/>
							<prodcmpycd/>
							<prodcmpynm/>
							<maincustlastsuplplce/>
							<maincustlastsuplplcenm/>
							<frgstdd/>
							<cmt/>
						</goodlist>
						<goodinfo>
							<matrnm/>
							<goodcd/>
							<goodnm/>
							<goodspec/>
							<prodcmpycd/>
							<prodcmpynm/>
							<maincustlastsuplplce/>
							<maincustlastsuplplcenm/>
							<frgstdd/>
							<cmt/>
						</goodinfo>
					</main>
					<send/>
					<init/>
					<hidden>
					</hidden>
					<temp>
					</temp>
					<popgood>
						<instcd/>
						<wareflag/>
						<goodcd/>
						<goodnm/>
						<returntype/>
						<selectyn/>
					</popgood>
					<popdata>
						<matrcd/>
					</popdata>
				</root>
			</instance>
			<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/stringHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
			<script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
			<!--script type="javascript" src="../../../mis/purcbaseweb/js/SMRSC05302.js"/-->
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fOpenForm();
					
				]]>
			</script>
			<script type="javascript">
				<![CDATA[
				
				//========================================================================================
				//화면 로드시 초기화 함수
				//========================================================================================
				function fOpenForm() {
					//model.removenode("/root/main/goodlist");	
					//model.removenode("/root/main/deptlist");	
					//model.refresh();
					
					misfGridInit(grd_goodlist);

    				model.setValue("/root/main/condition/fromdd" , getCurrentDate().toDate().getAddDate(-1, "M").getDateFormat("YYYYMMDD") );  //기간 설정 //getCurrentDate() //.substr(0,6)); //.toDate().getAddDate(-1, "D").getDateFormat("YYYYMMDD")
     				model.setValue("/root/main/condition/todd" , getCurrentDate() ); //기간 설정 //.substr(0,6));

					model.refresh();

					//2014.07.09 박준범 - 화면 open시 지연되는 것 방지위해 조회는 comment처리
					//fGetGoodList();//코드 목록 조회
					
					
					
					
					
					
					
//					if(model.getValue("/root/main/goodlist[1]/matrcd") != "") {
//						grd_goodlist.isSelected(1) = true;
//						fGetGoodInfo(1);						
//					}else {
//						fCopyInstance();
//					}
				}

				//========================================================================================
				//인스턴스  Copy 함수
				//========================================================================================
				function fCopyInstance() {
					//----model.copyNode("/root/hidden/goodinfo", "/root/main/goodinfo");
										
					model.refresh();
				}

				//========================================================================================
				//코드 목록 조회 함수					
				//========================================================================================					
				function fGetGoodList() { 
					misfGridInit(grd_goodlist);
					model.resetInstanceNode("/root/main/goodinfo");//조회시 기존 데이터 삭제								
					
					model.copyNode("/root/send", "/root/main/condition");
					submit("TRRSM00501");
					model.refresh();
				}
				
				//========================================================================================
				//목록 -> 상세내역
				//========================================================================================
				function fGetGoodInfo(pRow) {					
					if ( pRow > 0 ) {
						
						model.copyNode("/root/main/goodinfo", "/root/main/goodlist[" + pRow + "]");
						//model.refresh();
						
						ipt_matrnm.refresh();
						opt_goodcd.refresh();
						opt_goodnm.refresh();
						opt_goodspec.refresh();
						ipt_prodcmpycd.refresh();
						ipt_prodcmpynm.refresh();
						ipt_maincustlastsuplplce.refresh();
						opt_maincustlastsuplplcenm.refresh();
						ipt_frgstdd.refresh();
						ta_cmt.refresh();
						
						
					}
				}
				
				//========================================================================================
				//상세내역 -> 목록
				//========================================================================================
				function fPutGoodInfo() {					
					if ( true ) {
						
						var iRow = grd_goodlist.findRow(opt_goodcd.value, 1, grd_goodlist.colRef("goodcd"), true, true);
						
						//alert(iRow);
						
						model.setValue(grd_goodlist.nodeset + "[" + iRow + "]/matrnm", ipt_matrnm.value.getTrim());
						model.setValue(grd_goodlist.nodeset + "[" + iRow + "]/prodcmpycd", ipt_prodcmpycd.value.getTrim());
						model.setValue(grd_goodlist.nodeset + "[" + iRow + "]/prodcmpynm", ipt_prodcmpynm.value);
						model.setValue(grd_goodlist.nodeset + "[" + iRow + "]/maincustlastsuplplce", ipt_maincustlastsuplplce.value.getTrim());
						model.setValue(grd_goodlist.nodeset + "[" + iRow + "]/maincustlastsuplplcenm", opt_maincustlastsuplplcenm.value);
						model.setValue(grd_goodlist.nodeset + "[" + iRow + "]/frgstdd", ipt_frgstdd.value);
						model.setValue(grd_goodlist.nodeset + "[" + iRow + "]/cmt", ta_cmt.value);
						
						//model.refresh();
						grd_goodlist.refresh();

					}
				}

//========================================================================================
				//신규 버턴 클릭시 인스턴스 초기화
				//========================================================================================
				function fSetMatrInfo() {
					ipt_matrcd.disabled = false; 
					// 아래 두줄로 변경
					//model.resetInstanceNode("/root/main/goodinfo");
					model.resetInstanceNode("/root/main/goodinfo");
					//model.resetInstanceNode("/root/main/goodinfo/deptlist");
					misfGridInit(grd_deptlist);
					
					//return;
					
					model.setFocus("ipt_matrcd");
					model.setValue("/root/main/goodinfo/status", "i");
					model.setValue("/root/main/goodinfo/msdsflag", "Y");

					// 서식에서 징수의무자 상호(법인명)으로 쓰임. 기본값으로 경북대학교병원장 셋팅.
					//model.setValue("/root/main/goodinfo/prntnm1" , "경북대학교병원장");										
					fCopyInstance();

				}
				
				//========================================================================================
				// 저장버튼 클릭시 저장 수행 함수
				//========================================================================================
				function fClickSaveBtn() {

					var iCheckCount = 0;
					for(var i = 1; i < grd_goodlist.rows; i++) {
							if(grd_goodlist.valueMatrix(i, grd_goodlist.colRef("checkflag")) == "Y") {
								iCheckCount = 1;
								break;
							}	
					}	
					if(iCheckCount == 0) {
						messageBox("선택된 물품이 없습니다. 먼저 코드 등록할 물품을 선택하십시요. ", "E999", "");
						return false;
					}	
					
					
					if(opt_goodcd.value != "") {
						fPutGoodInfo();
					}	
					
					
					if(!fIsValidForSave())//저장전 유효성 검사
						return;
					
					
					//model.resetInstanceNode("/root/send");
					
					//model.makeNode("root/send/detail");
					//model.copyNode("/root/send", "/root/main/goodinfo");
					
					model.makeValue("/root/send/goodlist", grd_goodlist.getUpdateData());
					
					//return;
					
					if(submit("TXRSM00501")) {

							btn_search.dispatch("DOMActivate");

							//fGetGoodList();//코드 목록 재조회

							//model.copyNode("/root/send", "/root/main/goodinfo");
							//submit("TRRSM00102"); //상세내역 및 조사표 재조회

							//model.setValue("/root/main/goodinfo/status", "-");
							//grd_deptlist.clearStatus();

							//--model.makeNode("/root/hidden/goodinfo");
							//model.makeNode("/root/hidden/goodinfo");
							//fCopyInstance();
							
							//ipt_matrcd.disabled = true;
							messageBox("정상적으로 처리되었습니다. .", "I999", "");	
							

					}
				}
				
				//========================================================================================
				//저장전 유효성 검사
				//========================================================================================
				function fIsValidForSave() {
					//필수 입력 항목 체크(공통 ftHelper.js)
					//if(!isRequiredControls("ipt_matrcd","ipt_matrnm")) {   //,"ipt_prodcmpycd"
					//	return false;
					//}
					
					//var sStatus = model.getValue("/root/main/goodinfo/status");
					//var sNewData = fGetNodeText("/root/main/goodinfo");
					//var sOldData = fGetNodeText("/root/hidden/goodinfo");
					
					for(var i = 1; i < grd_goodlist.rows; i++) {
						if(grd_goodlist.valueMatrix(i, grd_goodlist.colRef("checkflag")) == "N") continue;
						
						if(grd_goodlist.valueMatrix(i, grd_goodlist.colRef("matrnm")) == "" ){
							messageBox("물품코드 " + grd_goodlist.valueMatrix(i, grd_goodlist.colRef("goodcd")) + " 의 물질명이 등록되지 않았습니다. ", "E999", "");
							return false;
						}	

						/*
						if(grd_goodlist.valueMatrix(i, grd_goodlist.colRef("prodcmpycd")) == "" ){
							messageBox("물품코드 " + grd_goodlist.valueMatrix(i, grd_goodlist.colRef("goodcd")) + " 의 제조회사가 등록되지 않았습니다. ", "E999", "");
							return false;
						}
						*/
					}
					
					return true;
					
					
					
					
					
					
					/*
					//상세내역에 변경된 정보가 있는지 확인
					if(sNewData != sOldData && sStatus == "-") { // 데이터 수정일 경우
						model.setValue("/root/main/goodinfo/status","u");
						return true;
					} else if(sNewData == sOldData && sStatus == "-" ) { //변경된 값이 없을경우
						//messageBox("변경된 정보가 ", "I004");
						//return false;
						return true;
					}else if(sStatus == "i") { //데이터 입력일 경우
						return true;
					}else if(sStatus = "d") { //데이터 삭제일 경우
						return true;
					}
					*/
				}
								
				//========================================================================================
				//엑셀입력(excel file을 그리드에 입력)
				//========================================================================================
				function fInputExcel(pGrid) {
					var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
					if(fileName != "") {
						pGrid.loadExcel(fileName, 1, true);
						pGrid.deleteRow(1);
						pGrid.refresh();
					}
				}
				
				//========================================================================================
				//동일한 Depth의 인스턴스의 값을 스트링형으로 변환
				//========================================================================================
				function fGetNodeText(pNode) {
					var trgNdoe = instance1.selectSingleNode(pNode);
					var trgNdoeList = trgNdoe.childNodes;
					var childNode;
					var allText = "";
					while( childNode = trgNdoeList.nextNode() ) {
					
						allText += childNode.text;	
					}
					return allText;
				}
				
				function fOpenPopupDeptHelp(pControl, pInstance)
				{				
					misfOpenPopUpList("02", pControl, "", pInstance);
					model.refresh();
				}
				
				
				]]>
			</script>
			<submission id="TRRSM00501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/goodlist"/>
			<submission id="TXRSM00501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
		</model>
	</xhtml:head>
	<xhtml:body guideline="1,1193;1,1406;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:331px; height:14px; ">신규물질 등록 조회(물류)</caption>
			<caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
		</group>
		<group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
			<group id="grp_sea" style="left:0px; top:10px; width:1194; height:35px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1194; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
				<caption id="caption7" class="search_name" style="left:56px; top:9px; width:194px; height:17px; ">물품코드 최종 Update 일자</caption>
				<line id="line5" class="line_4" style="x1:480px; y1:6px; x2:480px; y2:28px; border-color:#ffe4bb; border-left-style:solid; "/>
				<button id="btn_search" class="btn1_letter2" navindex="4" style="left:498px; top:7px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fGetGoodList();
						]]>
					</script>
				</button>
				<caption id="caption1" style="left:347px; top:10px; width:11px; height:15px; ">~</caption>
				<input id="ipt_fromdd" ref="/root/main/condition/fromdd" class="input_default" navindex="1" inputtype="date" format="yyyy-mm-dd" style="left:254px; top:8px; width:91px; height:19px; text-align:center; "/>
				<input id="ipt_todd" ref="/root/main/condition/todd" class="input_default" navindex="1" inputtype="date" format="yyyy-mm-dd" style="left:361px; top:8px; width:91px; height:19px; text-align:center; "/>
			</group>
			<line id="line3" class="line_1" style="x1:0px; y1:75px; x2:765px; y2:75px; "/>
			<line id="line1" class="line_1" style="x1:770px; y1:75px; x2:1190px; y2:75px; "/>
			<caption id="caption21" class="tit_2" style="left:5px; top:60px; width:214px; height:14px; ">미등록된 물류 MSDS물품 목록</caption>
			<caption id="caption20" class="tit_2" style="left:774px; top:60px; width:84px; height:13px; ">상세내역</caption>
			<datagrid id="grd_goodlist" nodeset="/root/main/goodlist" caption="선택^물품코드^물품명^규격^제조회사^주거래처^물질명^제조회사코드^주거래처코드^최초등록일^비고" colsep="^" colwidth="30, 77, 188, 86, 94, 94, 157, 65, 46, 77, 100" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" navindex="5" style="left:0px; top:80px; width:765px; height:630px; ">
				<col class="text_center" checkvalue="Y,N" ref="checkflag" type="checkbox"/>
				<col class="text_center" ref="goodcd" style="text-align:center; "/>
				<col ref="goodnm"/>
				<col ref="goodspec"/>
				<col ref="prodcmpynm"/>
				<col ref="maincustlastsuplplcenm"/>
				<col ref="matrnm"/>
				<col ref="prodcmpycd" visibility="hidden"/>
				<col ref="maincustlastsuplplce" visibility="hidden"/>
				<col ref="frgstdd" visibility="hidden"/>
				<col ref="cmt" visibility="hidden"/>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						if(grd_goodlist.row == 0 || grd_goodlist.col < 1) return;
						
						if(opt_goodcd.value != "") {
							fPutGoodInfo();
						}	
					
						var cur_row = grd_goodlist.row;
						fGetGoodInfo(cur_row);

					]]>
				</script>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_goodlist.gridToInstance();
					]]>
				</script>
			</datagrid>
			<caption id="cap_matrnm" class="cell_1" style="left:770px; top:80px; width:108px; height:25px; text-align:center; vertical-align:middle; ">물 질 명</caption>
			<input id="ipt_matrnm" ref="/root/main/goodinfo/matrnm" class="input_essential" navindex="7" style="left:880px; top:83px; width:305px; height:19px; "/>
			<line id="line4" class="line_2" style="x1:770; y1:105px; x2:1191px; y2:105px; "/>
			<line id="line17" class="line_2" style="x1:770; y1:267px; x2:1190px; y2:267px; "/>
			<line id="line18" class="line_2" style="x1:770; y1:327px; x2:1190px; y2:327px; "/>
			<caption id="caption25" class="cell_1" style="left:770px; top:107px; width:108px; height:25px; text-align:center; vertical-align:middle; ">(물류)물품코드</caption>
			<caption id="caption27" class="cell_1" style="left:770px; top:269px; width:108px; height:58px; text-align:center; vertical-align:middle; ">비 고</caption>
			<caption id="caption29" class="cell_1" style="left:770px; top:242px; width:108px; height:25px; text-align:center; vertical-align:middle; ">최초등록일</caption>
			<input id="ipt_frgstdd" ref="/root/main/goodinfo/frgstdd" class="input_default" navindex="18" inputtype="date" format="yyyy-mm-dd" style="left:881px; top:245px; width:90px; height:19px; "/>
			<line id="line19" class="line_2" style="x1:770; y1:132px; x2:1190px; y2:132px; "/>
			<caption id="caption2" class="cell_1" style="left:770px; top:134px; width:108px; height:25px; text-align:center; vertical-align:middle; ">(물류)물품명</caption>
			<line id="line7" class="line_2" style="x1:770; y1:159px; x2:1191px; y2:159px; "/>
			<line id="line20" class="line_2" style="x1:770; y1:186px; x2:1191px; y2:186px; "/>
			<caption id="caption11" class="cell_1" style="left:770px; top:161px; width:108px; height:25px; text-align:center; vertical-align:middle; ">규 격</caption>
			<line id="line9" class="line_2" style="x1:770; y1:213px; x2:1191px; y2:213px; "/>
			<caption id="caption8" class="cell_1" style="left:770px; top:188px; width:108px; height:25px; text-align:center; vertical-align:middle; ">제조회사</caption>
			<line id="line10" class="line_2" style="x1:770; y1:240px; x2:1191px; y2:240px; "/>
			<caption id="caption12" class="cell_1" style="left:770px; top:215px; width:108px; height:25px; text-align:center; vertical-align:middle; ">주거래처</caption>
			<button id="btn_prodcmpycd" class="icon_search" navindex="13" style="left:935px; top:192px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
							rszfOpenPopUpListByWndName(ipt_prodcmpycd,"","prodcmpycd,prodcmpynm","SPRSD00160","","");
							model.refresh();
						]]>
				</script>
			</button>
			<input id="ipt_prodcmpycd" ref="/root/main/goodinfo/prodcmpycd" class="input_default" navindex="12" style="left:881px; top:191px; width:50px; height:19px; ">
				<!--script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					if ( model.getValue(ipt_prodcmpycd.attribute("ref")).length == 0 ) model.setValue(opt_prodcmpynm.attribute("ref"),"");
					else rszfValidationCheck("TRRSD00161", "prodcmpylist", "refcond,prodcmpycd,prodcmpynm","prodcmpycd," + model.getValue(ipt_prodcmpycd.attribute("ref"))+"," ,"","prodcmpycd,prodcmpynm" ,ipt_prodcmpycd,"SPRSD00160","","");
					model.refresh();	
					]]>
				</script>
				<script type="javascript" ev:event="onkeydown">
					<![CDATA[
					if(event.keyCode == 9)
					{
						if(event.shiftKey)model.setFocus("cmb_prodplce");	
						else model.setFocus("ipt_goodmodel");	
					}
					]]>
				</script-->
			</input>
			<output id="opt_maincustlastsuplplcenm" ref="/root/main/goodinfo/maincustlastsuplplcenm" class="output_fix" appearance="output" style="left:955px; top:218px; width:230px; height:19px; "/>
			<input id="ipt_maincustlastsuplplce" ref="/root/main/goodinfo/maincustlastsuplplce" class="input_default" navindex="14" style="left:881px; top:218px; width:50px; height:19px; text-align:center; "/>
			<button id="btn_maincustlastsuplplce" class="icon_search" navindex="15" style="left:935px; top:219px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					//rszfOpenPopUpListByWndName(ipt_maincustlastsuplplce,"","maincustlastsuplplce,maincustlastsuplplcenm","SPRSD00180","goodflag,prodcmpycd,prodcmpynm","cmb_goodflag,ipt_prodcmpycd,opt_prodcmpynm");
					rszfOpenPopUpListByWndName(ipt_maincustlastsuplplce,"","maincustlastsuplplce,maincustlastsuplplcenm","SPRSD00220"); // ,"instcd","opt_instcd");
					model.refresh();
					]]>
				</script>
			</button>
			<output id="opt_goodcd" ref="/root/main/goodinfo/goodcd" class="output_fix" appearance="output" style="left:881px; top:110px; width:93px; height:19px; "/>
			<output id="opt_goodnm" ref="/root/main/goodinfo/goodnm" class="output_fix" appearance="output" style="left:880px; top:137px; width:305px; height:19px; "/>
			<output id="opt_goodspec" ref="/root/main/goodinfo/goodspec" class="output_fix" appearance="output" style="left:880px; top:163px; width:305px; height:19px; "/>
			<textarea id="ta_cmt" ref="/root/main/goodinfo/cmt" navindex="20" style="left:880px; top:272px; width:305px; height:52px; padding-left:4; padding-top:4; padding-right:4; padding-bottom:4; "/>
			<caption id="caption3" style="left:5px; top:715px; width:1050px; height:20px; color:#ff0000; ">※ 물류 물품마스터에서 물품코드의 제조회사를 변경하였을 경우, 해당 물품코드가 화학물질코드로 기등록된 것이면 제조회사와 무관하게 위의 목록 상에는 나타나지 않음을 양지하시기 바랍니다.</caption>
			<input id="ipt_prodcmpynm" ref="/root/main/goodinfo/prodcmpynm" class="input_default" navindex="15" style="left:955px; top:191px; width:230px; height:19px; "/>
			<button id="btn_excel" class="btn2_letter4" style="left:698px; top:54px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀출력</caption>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						//radfSaveExcel(grd_goodlist);
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*"); 
						if (fileName != "") {
							grd_goodlist.saveExcel(fileName,"sheetname:savetype");
						}	

					]]>
				</script>
			</button>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
			<line id="line2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
			<button id="btn_save" class="btn4_letter4" style="left:1112px; top:3px; width:80px; height:22px; ">
				<caption>일괄등록</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fClickSaveBtn();
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>