YNU_JEUS/app_home/himed/webapps/mis/winweb/xrw/SMRSI03900_영양팀 계정별 입고 일계표.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>
						<rsihinnulist/>
					</main>
					<send>
						<instcd/>
						<goodflag/>
						<fromwindd/>
						<towindd/>
					</send>
					<init/>
					<temp/>
				</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/dateHelper.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" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
				]]>
			</script>
			<script type="javascript">
				<![CDATA[
					function fInitialize()
					{
						misfGridInit(grd_rsihinnulist);
						
						misfComboComCdList("Z0007", cmb_instcd);
						cmb_instcd.value =  getUserInfo("dutplceinstcd");
						opt_goodflag.value = "SF";
						
						// 현재 날짜 기본 입력(6개월 간격 설정)
						var reqdate = getCurrentDate().toDate("YYYYMMDD");
						model.setValue(ipt_fromwindd.attribute("ref"), reqdate.getDateFormat("YYYYMM") + "01" ); 
						model.setValue(ipt_towindd.attribute("ref"), getCurrentDate());
																		
						misfMsterDetailSet(grd_rsihinnulist, null, "TRRSI03901", "N");
						
						model.refresh();
					}
					
					function fGridGTSN(fGubun, fStart)
					{
						// GTSN
						misfGridIUD(grd_rsihinnulist, "A");
						
						//grd_rsihinnulist.insertRow(grd_rsihinnulist.rows-1, "above", "false", "true");
						grd_rsihinnulist.rowstyle(grd_rsihinnulist.row, "data", "background-color") = "#ccffff";
						grd_rsihinnulist.rowstyle(grd_rsihinnulist.row, "data", "font-weight") = "bold";
						
						var row = grd_rsihinnulist.row;
						var gubun = fGubun;
						
						grd_rsihinnulist.issubtotal(row) = true;
						
						
						if(fStart != "")
						{
							grd_rsihinnulist.valueMatrix(row, grd_rsihinnulist.colRef("windd")) = fStart;
						}
						
						
						
						grd_rsihinnulist.valueMatrix(row, grd_rsihinnulist.colRef("gubunnm")) = gubun;
						
						
						for(var r=0; r < grd_rsihinnulist.rows; r++)
						{
							if( grd_rsihinnulist.issubtotal(r) == false && row != r)
							{
								if(grd_rsihinnulist.valueMatrix(r, grd_rsihinnulist.colRef("gubunnm")) == gubun )
								{
									for(var c=3; c < grd_rsihinnulist.cols; c++)
									{
										grd_rsihinnulist.cellFormat(row, c) = '#,###';
										if(grd_rsihinnulist.valueMatrix(row, c) == '')
										{
											grd_rsihinnulist.valueMatrix(row, c) = 0;
										}
										
										grd_rsihinnulist.valueMatrix(row, c) = parseInt(grd_rsihinnulist.valueMatrix(row, c)) + parseInt(grd_rsihinnulist.valueMatrix(r, c));
									}
								}
							}
						}
					}
					
					function fGridTotal()
					{
						grd_rsihinnulist.subtotal("clear", 0, 0);
							
						for(var i=0; i < 16; i++)
						{
							grd_rsihinnulist.subTotal("sum", 1, i+3, "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");	
						}
						
						
						fGridGTSN('G', "총합");
						fGridGTSN('T');
						fGridGTSN('S');
						fGridGTSN('N');
						
						// 총합계
						for(var i=0; i < 16; i++)
						{
							grd_rsihinnulist.subTotal("sum", -1, i+3, "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "계");	
						}
					}
					
					function fGridMerge()
					{
						for(var i=2; i<grd_rsihinnulist.cols; i++)
						{
							grd_rsihinnulist.mergecol(i) = false;
						}
						
					}
				]]>
			</script>
			<submission id="TRRSI03901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/rsihinnulist"/>
		</model>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:173px; height:14px; ">영양팀 계정별 입고 일계표</caption>
		</group>
		<group id="grp_biz" scroll="auto" style="left:0px; top:38; width:1195px; height:744px; ">
			<group id="grp_sea" style="left:0px; top:10px; width:1195px; height:40px; vertical-align:top; ">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
				<caption id="cap_instcd" class="search_name" style="left:15px; top:9; width:99px; height:17px; ">기관코드 :</caption>
				<select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" appearance="minimal" style="left:105px; top:8px; width:205px; height:19px; text-align:center; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<input id="ipt_fromwindd" ref="/root/send/fromwindd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:456px; top:9px; width:134px; height:19px; text-align:center; "/>
				<caption id="cap_day" class="search_name" style="left:365px; top:10px; width:99px; height:17px; ">조회일자 :</caption>
				<line id="line30" class="line_4" style="x1:1110px; y1:9px; x2:1110px; y2:32px; "/>
				<button id="btn_search" class="btn1_letter2" style="left:1125px; top:10px; width:56px; height:22px; font-weight:bold; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						
							submit("TRRSI03901");
							
							fGridTotal();
							
							fGridMerge();

							grd_rsihinnulist.refresh();
						]]>
					</script>
				</button>
				<output id="opt_goodflag" ref="/root/send/goodflag" visibility="hidden" style="left:920px; top:10px; width:100px; height:19px; "/>
				<input id="ipt_towindd" ref="/root/send/towindd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:607px; top:9px; width:134px; height:19px; text-align:center; "/>
				<caption id="caption1" style="left:592px; top:10px; width:15px; height:20px; ">~</caption>
			</group>
			<caption id="cap_title" class="tit_2" style="left:5px; top:59px; width:206px; height:14px; ">영양팀 계정별 입고 일계표</caption>
			<line id="line2" class="line_1" style="x1:0px; y1:74px; x2:1195px; y2:74px; "/>
			<datagrid id="grd_rsihinnulist" nodeset="/root/main/rsihinnulist" caption="^^1^2^3^4^5^6^7^8^9^10^11^12^13^14^15^계|^^곡류^두류^견과 종실류^채소류^과실류^육류^난류^어패류^우유류^음료류^조미료류^특수의료용도식품류^기타^기타2^기타3^" colsep="^" colwidth="77, 26, 65, 65, 65, 65, 65, 65, 65, 65, 65, 65, 65, 65, 65, 65, 65, 65" ellipsis="true" extendlastcol="scroll" frozencols="2" mergecells="bycol" rowheader="seq" rowsep="|" subtotalposition="below" tooltip="true" style="left:0px; top:79px; width:1194px; height:664px; ">
				<col ref="windd" style="text-align:center; "/>
				<col ref="gubunnm" style="text-align:center; "/>
				<col ref="lrgcd01" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd02" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd03" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd04" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd05" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd06" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd07" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd08" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd09" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd10" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd11" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd12" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd13" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd14" format="#,###" style="text-align:right; "/>
				<col ref="lrgcd15" format="#,###" style="text-align:right; "/>
				<col ref="lrgcdtot" format="#,###" style="text-align:right; "/>
			</datagrid>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
			<line id="line19" class="line_2" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<line id="line22" class="line_6" style="x1:0px; y1:25; x2:1195px; 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[
						fInitialize();
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>