YNU_JEUS/app_home/himed/webapps/mis/stocsumweb/xrw/SMRSG02700_월별 1식당 평균단가(영양).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="">
					<init/>
					<send>
						<instcd/>
						<stocfrym/>
						<goodflag/>
						<reqdeptcd/>
						<stoctoym/>
						<avgwinamtlist/>
					</send>
					<temp/>
					<main>
						<list>
							<avgwinamtlist/>
						</list>
					</main>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					//화면 Control을 초기화한다
					fInitialize();	
				]]>
			</script>
			<submission id="TRRSG02701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/list"/>
			<submission id="TXRSG02701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/avgwinamtlist" resultref="/root/hidden"/>
		</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/miscommonweb/js/RSZ001.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript">
			<![CDATA[
			var RetrYn = "Y";
			function fInitialize() {		
			
				misfGridInit(grd_avgwinamtlist);
				
				grd_avgwinamtlist.rowHeight(0) = "20";
				grd_avgwinamtlist.rowHeight(1) = "20";

				rszfUserInstList(cmb_instcd,getUserInfo("userid"));

				misfMsterDetailSet(grd_avgwinamtlist,null, "TRRSG02701" ,"N"); 
				
				var curdate = getCurrentDate();
				
				model.setValue(ipt_stocfrym.attribute("ref") ,curdate);
                model.setValue(ipt_stoctoym.attribute("ref") ,curdate);
           		// [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH) 
				model.setValue(ipt_goodflag.attribute("ref"),"PH");
				
				// hidden column
				// [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= S) => (goodflag= SF) 
				model.setValue(ipt_goodflag.attribute("ref"),'SF');
				//model.setValue(ipt_stocdeptcd.attribute("ref") ,"3251000000"); // getUserInfo("dutplcecd"));
				model.setValue(ipt_reqdeptcd.attribute("ref") , getUserInfo("dutplcecd"));
				

				model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
				
				model.refresh();
			}
				
			function fCheckRetrieveData(pmsg)
			{
				if(model.getValue(cmb_instcd.attribute("ref")).length== 0 )
				{
					if(pmsg == true)
					{
						messageBox("기관코드를 " ,"C002");
						model.setFocus("cmb_instcd");
					}
					return false;
				}				
				if(model.getValue(ipt_stocfrym.attribute("ref")).length== 0 )
				{
					if(pmsg == true)
					{
						messageBox("조회시작년월 " ,"C002");
						model.setFocus("ipt_stocfrym");
					}
					return false;
				}
				if(model.getValue(ipt_stoctoym.attribute("ref")).length== 0 )
				{
					if(pmsg == true)
					{
						messageBox("조회끝년월 " ,"C002");
						model.setFocus("ipt_stoctoym");
					}
					return false;
				}
				
				/*
				if(model.getValue(ipt_reqdeptcd.attribute("ref")).length== 0 )
				{
					if(pmsg == true)
					{
						messageBox("입고부서를 " ,"C001");
						model.setFocus("ipt_windeptcd");
					}
					return false;
				}

				if(model.getValue(ipt_winfrdd.attribute("ref")).length== 0 )
				{
					if(pmsg == true)
					{
						messageBox("입고시작일자를 " ,"C001");
						model.setFocus("ipt_winfrdd");
					}
					return false;
				}
				
				if(model.getValue(ipt_wintodd.attribute("ref")).length== 0 )
				{
					if(pmsg == true)
					{
						messageBox("입고종료일자를 " ,"C001");
						model.setFocus("ipt_wintodd");
					}
					return false;
				}
				*/
				return true;
			}	
		]]>
		</script>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1195; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:189px; height:14px; ">월별 1식당 평균단가</caption>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
			<caption id="caption21" class="tit_2" style="left:5px; top:54px; width:138px; height:14px; ">월별 1식당 평균단가</caption>
			<group id="group6" style="left:0px; top:10px; width:1195px; height:35px; vertical-align:top; ">
				<shape id="roundrect3" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
				<caption id="caption4" class="search_name" style="left:226px; top:9px; width:86px; height:17px; ">조회년월 :</caption>
				<caption id="caption2" class="search_name" style="left:15px; top:9px; width:86px; height:17px; ">기관코드 :</caption>
				<button id="btn_search" class="btn1_letter2" style="left:1125px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[	
						//if(fCheckRetrieveData(false) == false)return;
						misfMsterDetailRetrieve();	
						//fAfterRetrieve();
					]]>
					</script>
				</button>
				<line id="line13" class="line_4" style="x1:1110px; y1:7px; x2:1110px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
				<select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_search" appearance="minimal" style="left:100px; top:8; width:100; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<input id="ipt_stocfrym" ref="/root/send/stocfrym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:312px; top:8px; width:100; height:19px; text-align:center; "/>
				<input id="ipt_goodflag" ref="/root/send/goodflag" visibility="hidden" style="left:632px; top:9px; width:51px; height:19px; "/>
				<input id="ipt_reqdeptcd" ref="/root/send/reqdeptcd" visibility="hidden" style="left:688px; top:8px; width:44px; height:19px; "/>
				<caption id="caption1" style="left:415px; top:5px; width:25px; height:25px; font-weight:bold; vertical-align:middle; ">~</caption>
				<input id="ipt_stoctoym" ref="/root/send/stoctoym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:430px; top:8px; width:100px; height:19px; text-align:center; "/>
			</group>
			<line id="line15" class="line_1" style="x1:0px; y1:69px; x2:1195px; y2:69px; "/>
			<button id="button14" class="btn2_letter2" style="left:1153px; top:48px; width:42px; height:19px; ">
				<caption>엑셀</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					misfSaveExcel(grd_avgwinamtlist,"월별 1식당 평균단가");
					]]>
				</script>
			</button>
			<datagrid id="grd_avgwinamtlist" nodeset="/root/main/list/avgwinamtlist" caption="년월^환자식^환자식^환자식^환자식^환자식^환자식^직원식^직원식^직원식^직원식^직원식^직원식^평균단가^|년월^일반식(G)^일반식(G)^일반식(G)^치료식(T)^치료식(T)^치료식(T)^직원식(S)^직원식(S)^직원식(S)^야식(N)^야식(N)^야식(N)^평균단가^|년월^급식비^식수^1식단가^급식비^식수^1식단가^급식비^식수^1식단가^급식비^식수^1식단가^평균단가^" colsep="^" colwidth="80, 90, 80, 80,90, 80, 80,90, 80, 80, 90, 80, 80,92,0,0,0,0,0" dataheight="25" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:74px; width:1195px; height:660px; ">
				<col ref="winym" format="yyyy-mm"/>
				<col ref="custpatwinamt" format="###,###,###" style="text-align:right; "/>
				<col ref="custpatmonqty" type="input" format="###,###,###" style="text-align:right; "/>
				<col ref="custpatdayamt" format="###,###,###" style="text-align:right; "/>
				<col ref="custcurwinamt" format="###,###,###" style="text-align:right; "/>
				<col ref="custcurmonqty" type="input" format="###,###,###" style="text-align:right; "/>
				<col ref="custcurdayamt" format="###,###,###" style="text-align:right; "/>
				<col ref="custempwinamt" format="###,###,###" style="text-align:right; "/>
				<col ref="custempmonqty" type="input" format="###,###,###" style="text-align:right; "/>
				<col ref="custempdayamt" format="###,###,###" style="text-align:right; "/>
				<col ref="custempnigtwinamt" format="###,###,###" style="text-align:right; "/>
				<col ref="custempnigtmonqty" type="input" format="###,###,###" style="text-align:right; "/>
				<col ref="custempnigtdayamt" format="###,###,###" style="text-align:right; "/>
				<col ref="custtotavgamt" format="###,###,###.##" style="text-align:right; "/>
				<col ref="instcd" visiable="hidden" style="text-align:right; "/>
				<col ref="reqdeptcd" visiable="hidden" style="text-align:right; "/>
				<col ref="goodflag" visiable="hidden" style="text-align:right; "/>
				<col ref="totwinamt" visibility="hidden" format="###,###,###.##" style="text-align:right; "/>
				<col ref="totavgcout" visiable="hidden" style="text-align:right; "/>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					      if(grd_avgwinamtlist.col == grd_avgwinamtlist.colRef("custpatmonqty")  &&  grd_avgwinamtlist.valueMatrix(grd_avgwinamtlist.row, grd_avgwinamtlist.colRef("custpatmonqty")).length> 0 && model.getValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custpatmonqty") != 0) {
					
							var custpatwinamt =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custpatwinamt")));
                            //식수cout가 0일 경우
							if(custpatwinamt == 0) 
							  {
							
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custpatmonqty", 0);
								
							  } else {
								var custpatmonqty = parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custpatmonqty")));
								var custpatdayamt = 0;
							
								//alert(custpatwinamt + ":"+custpatmonqty+":");
								//alert(custpatwinamt / custpatmonqty +":"+ Math.round(custpatwinamt / custpatmonqty));
								
								custpatdayamt = parseFloat(Math.round(custpatwinamt / custpatmonqty));
								
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custpatdayamt", custpatdayamt);
								
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/reqdeptcd", model.getValue(ipt_reqdeptcd.attribute("ref")));
								grd_avgwinamtlist.rowStatus(grd_avgwinamtlist.row) = "2";
								
								//평균단가를 구하기 위해서
								var custcurmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custcurmonqty")));
								var custempmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custempmonqty")));
								var custempnigtmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custempnigtmonqty")));
								
								var totwinamt = parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("totwinamt")));
								var totmonqty = custpatmonqty+ custcurmonqty +  custempmonqty + custempnigtmonqty ;
								
								
								totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custtotavgamt", totavgamt);
								
							  }
					         
						  } else if(grd_avgwinamtlist.col == grd_avgwinamtlist.colRef("custcurmonqty")  &&  grd_avgwinamtlist.valueMatrix(grd_avgwinamtlist.row, grd_avgwinamtlist.colRef("custcurmonqty")).length> 0) {
							 
							
							var custcurwinamt = parseFloat(grd_avgwinamtlist.valueMatrix(grd_avgwinamtlist.row , grd_avgwinamtlist.colRef("custcurwinamt")));
						    //식수cout가 0일 경우
						     if(custcurwinamt == 0) 
							  {
							
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custcurmonqty", 0);
								
							  } else {
								var custcurmonqty = parseFloat(grd_avgwinamtlist.valueMatrix(grd_avgwinamtlist.row ,grd_avgwinamtlist.colRef("custcurmonqty")));
								var custcurdayamt = 0;
								 
								
								custcurdayamt = parseFloat(Math.round(custcurwinamt / custcurmonqty));
								
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custcurdayamt", custcurdayamt);
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/reqdeptcd", model.getValue(ipt_reqdeptcd.attribute("ref")));
								grd_avgwinamtlist.rowStatus(grd_avgwinamtlist.row ) = "2"; 
								
								//평균단가를 구하기 위해서
								var custpatmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custpatmonqty")));
								var custempmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custempmonqty")));
								var custempnigtmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custempnigtmonqty")));
								
								var totwinamt = parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("totwinamt")));
								var totmonqty = custpatmonqty+ custcurmonqty +  custempmonqty + custempnigtmonqty ;
								
								
								totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custtotavgamt", totavgamt);
								
							  }	
							  
						  } else if(grd_avgwinamtlist.col == grd_avgwinamtlist.colRef("custempmonqty")  &&  grd_avgwinamtlist.valueMatrix(grd_avgwinamtlist.row, grd_avgwinamtlist.colRef("custempmonqty")).length> 0) {
						
						       var custempwinamt = parseFloat(grd_avgwinamtlist.valueMatrix(grd_avgwinamtlist.row ,grd_avgwinamtlist.colRef("custempwinamt")));
							//식수cout가 0일 경우   
							   if(custempwinamt == 0) 
							  {
							
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custempmonqty", 0);
								
							  } else {
							
									var custempmonqty = parseFloat(grd_avgwinamtlist.valueMatrix(grd_avgwinamtlist.row ,grd_avgwinamtlist.colRef("custempmonqty")));
									var custempdayamt = 0;
							
									
									custempdayamt = parseFloat(Math.round(custempwinamt / custempmonqty));
									
									model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custempdayamt", custempdayamt);
									model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1)+"]/reqdeptcd", model.getValue(ipt_reqdeptcd.attribute("ref")));
									grd_avgwinamtlist.rowStatus(grd_avgwinamtlist.row) = "2";   
									
									//평균단가를 구하기 위해서
								
									var custpatmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custpatmonqty")));
									var custcurmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custcurmonqty")));
									var custempnigtmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custempnigtmonqty")));
								
									var totwinamt = parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("totwinamt")));
									var totmonqty = custpatmonqty+ custcurmonqty +  custempmonqty + custempnigtmonqty ;
								
								
								totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custtotavgamt", totavgamt);
								
							  }
						 } else if(grd_avgwinamtlist.col == grd_avgwinamtlist.colRef("custempnigtmonqty")  &&  grd_avgwinamtlist.valueMatrix(grd_avgwinamtlist.row, grd_avgwinamtlist.colRef("custempnigtmonqty")).length> 0) {
							
							//alert("1");
							var custempnigtwinamt = parseFloat(grd_avgwinamtlist.valueMatrix(grd_avgwinamtlist.row ,grd_avgwinamtlist.colRef("custempnigtwinamt")));
							//alert( custempnigtwinamt);
							//식수cout가 0일 경우
							if(custempnigtwinamt == 0) 
							  {
							  
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custempnigtmonqty", 0);
								
							  } else {
							
								var custempnigtmonqty = parseFloat(grd_avgwinamtlist.valueMatrix(grd_avgwinamtlist.row ,grd_avgwinamtlist.colRef("custempnigtmonqty")));
								var custempnigtdayamt = 0;
							     
								custempnigtdayamt = parseFloat(Math.round(custempnigtwinamt / custempnigtmonqty));
								
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custempnigtdayamt", custempnigtdayamt);
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/reqdeptcd", model.getValue(ipt_reqdeptcd.attribute("ref")));
								grd_avgwinamtlist.rowStatus(grd_avgwinamtlist.row ) = "2"; 
								
								//평균단가를 구하기 위해서
								var custpatmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custpatmonqty")));
								var custcurmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custcurmonqty")));
								var custempmonqty =  parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("custempmonqty")));
								
								var totwinamt = parseFloat(grd_avgwinamtlist.valueMatrix( grd_avgwinamtlist.row ,  grd_avgwinamtlist.colRef("totwinamt")));
								var totmonqty = custpatmonqty+ custcurmonqty +  custempmonqty + custempnigtmonqty ;
								
								
								totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
								model.setValue(grd_avgwinamtlist.nodeset + "["+(grd_avgwinamtlist.row - grd_avgwinamtlist.fixedRows + 1) +"]/custtotavgamt", totavgamt);
								
							  }	
						  }   
					]]>
				</script>
			</datagrid>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:12; width:1195px; height:27px; ">
			<button id="button34" class="btn6_letter2" visibility="hidden" style="left:0; top:3px; width:56px; height:22px; ">
				<caption>출력</caption>
			</button>
			<line id="line17" class="line_6" style="x1:0px; y1:25; x2:1195; y2:25; "/>
			<button id="btn_init" class="btn4_letter3" style="left:1127px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

						var data = getGridUpdateData(grd_rsthrstnlist);
						
						if(data != "")
						{
							if(messageBox("작업중인 Data 가 있습니다.","Q003") != 6 )return;
						}
						
						fInitialize();
					]]>
				</script>
			</button>
			<button id="btn_save" class="btn4_letter2" style="left:1070px; top:3px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
//						if(messageBox("","Q002") != 6) return;
						
						if(fCheckRetrieveData()== false) return;
						
						
						model.setValue("/root/send/avgwinamtlist", grd_avgwinamtlist.getUpdateData());
						misfSave("TXRSG02701");
						
						if (model.getValue(gvErrorMsgPath + "/type") != "error")btn_search.dispatch("DOMActivate");
					//	btn_search.dispatch("DOMActivate");						
						
					//	model.refresh();
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>