YNU_JEUS/app_home/himed/webapps/mis/stocsumweb/xrw/SMRSG02200_환자식및직원식지출현황.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/>
						<stocym/>
						<goodflag/>
						<stocdeptcd/>
					</send>
					<temp/>
					<main>
						<list>
							<nutrstocgubunamt/>
						</list>
					</main>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					//화면 Control을 초기화한다
					fInitialize();	
				]]>
			</script>
			<submission id="TRRSG02201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/list"/>
		</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_nutrstocgubunamt);
				
				grd_nutrstocgubunamt.rowHeight(0) = "20";
				grd_nutrstocgubunamt.rowHeight(1) = "20";

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

				misfMsterDetailSet(grd_nutrstocgubunamt,null, "TRRSG02201" ,"N"); 
				
				var curdate = getCurrentDate();
				
				model.setValue(ipt_stocym.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_stocdeptcd.attribute("ref") , getUserInfo("dutplcecd"));
				

				model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));

//				grd_nutrstocgubunamt.mergecells = "bycol";	

                             // grid sum
				grd_nutrstocgubunamt.subtotalposition = "after";
				
				
				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_stocym.attribute("ref")).length== 0 )
				{
					if(pmsg == true)
					{
						messageBox("기준년월 " ,"C002");
						model.setFocus("ipt_stocym");
					}
					return false;
				}
				
				/*
				if(model.getValue(ipt_suplplcecd.attribute("ref")).length== 0 )
				{
					if(pmsg == true)
					{
						messageBox("공급처를 " ,"C001");
						model.setFocus("ipt_suplplcecd");
					}
					return false;
				}
				*/
				
				if(model.getValue(ipt_windeptcd.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; ">환자식 및 직원식 지출현황</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:188px; height:14px; ">환자식 및 직원식 지출현황</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:224px; 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="button1" 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();	
						
						// merge가 안되네..
						//grd_nutrstocgubunamt.mergecol(2) = true;
						
						grd_nutrstocgubunamt.subtotal("clear", 0, 0);
						
/*						
						grd_nutrstocgubunamt.subtotal("sum", 2, 5, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ",  true);
						grd_nutrstocgubunamt.subtotal("sum", 2, 6, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ",  true);
						grd_nutrstocgubunamt.subtotal("sum", 2, 7, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ",  true);
						grd_nutrstocgubunamt.subtotal("sum", 2, 8, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ",  true);
*/						
						// 총합계 ( sub합계보다 먼저 선언되어야한다.)
						grd_nutrstocgubunamt.subtotal("sum", 1, 5, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ", 2, "TOTAL");
						grd_nutrstocgubunamt.subtotal("sum", 1, 6, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ", 2, "TOTAL");
						grd_nutrstocgubunamt.subtotal("sum", 1, 7, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ", 2, "TOTAL");
						grd_nutrstocgubunamt.subtotal("sum", 1, 8, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ", 2, "TOTAL");
						
						// 구분별 합계 ( total 합계가 먼저 선언되어야한다)
						grd_nutrstocgubunamt.subtotal("sum", 2, 5, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ", 3, "SUB합계");
						grd_nutrstocgubunamt.subtotal("sum", 2, 6, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ", 3, "SUB합계");
						grd_nutrstocgubunamt.subtotal("sum", 2, 7, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ", 3, "SUB합계");
						grd_nutrstocgubunamt.subtotal("sum", 2, 8, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ", 3, "SUB합계");
						//fAfterRetrieve();
						
						
						model.refresh();
						
					]]>
					</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:8px; width:100; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<input id="ipt_stocym" ref="/root/send/stocym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:310px; top:8px; width:100px; height:19px; text-align:center; "/>
				<input id="ipt_goodflag" ref="/root/send/goodflag" visibility="hidden" style="left:516px; top:8px; width:100px; height:19px; "/>
				<input id="ipt_stocdeptcd" ref="/root/send/stocdeptcd" visibility="hidden" style="left:618px; top:8px; width:100px; height:19px; "/>
			</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_nutrstocgubunamt,"환자식및직원식지출현황");
					]]>
				</script>
			</button>
			<datagrid id="grd_nutrstocgubunamt" nodeset="/root/main/list/nutrstocgubunamt" caption="subtotal용임시^구분^대분류^대분류^전월재고액^당월구입액^당월소모액^당월잔고액^비고^" colsep="^" colwidth="18, 103, 69, 114, 189, 163, 183, 204, 312" dataheight="25" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:74px; width:1195px; height:660px; ">
				<col ref="tmpsum" visibility="hidden"/>
				<col ref="gubun" style="text-align:center; "/>
				<col ref="lrgcd"/>
				<col ref="lrgnm"/>
				<col ref="brngfwrdamt" format="###,###,###.##" style="text-align:right; "/>
				<col ref="winamt" format="###,###,###.##" style="text-align:right; "/>
				<col ref="deliveamt" format="###,###,###.##" style="text-align:right; "/>
				<col ref="stocamt" format="###,###,###.##" style="text-align:right; "/>
				<col/>
			</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; "/>
		</group>
	</xhtml:body>
</xhtml:html>