YNU_JEUS/app_home/himed/webapps/mis/reqweb/xrw/SMRSD00800_안전재고량 조회(약국).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>
						<cond>
							<instcd/>
							<fromdd/>
							<todd/>
							<goodcd/>
						</cond>
						<goodbaseqtyinfo>
							<goodbaseqtylist/>
						</goodbaseqtyinfo>
					</main>
					<send/>
					<init/>
					<hidden/>
					<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="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
				
					rszfUserInstList(cmb_instcd,getUserInfo("userid"));
					model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
					model.refresh();
				]]>
			</script>
			<submission id="TRRSD00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retvcond" resultref="/root/main/reqlist"/>
			<submission id="TRRSD00102" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdeptlist" resultref="/root/main/goodbaseqtylist"/>
			<submission id="TRRSD00801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/cond" resultref="/root/main/goodbaseqtyinfo"/>
			<submission id="TXRSD00801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/cond" resultref="/root/hidden"/>
		</model>
		<script type="javascript">
			<![CDATA[
				// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
				function fInitialize() {
					model.resetInstanceNode("/root/send");
					
					
					model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));

					model.refresh();
				}
				
 			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="2,717;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<datagrid id="grd_goodbaseqtylist" nodeset="/root/main/goodbaseqtyinfo/goodbaseqtylist" class="text_center" caption="약품코드^약품명^부서명1^부서명1^부서명2^부서명2^부서명3^부서명3^부서명4^부서명4^부서명5^부서명5^부서명6^부서명6^부서명7^부서명7^부서명8^부서명8^부서명9^부서명9^부서명10^부서명10^color|약품코드^약품명^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^color" colsep="^" colwidth="111, 152, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 63, 0" dataheight="25" ellipsis="true" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" tooltip="true" style="left:0px; top:85px; width:1195px; height:632px; ">
			<col disabled="true" ref="goodcd"/>
			<col disabled="true" ref="goodnm" style="text-align:left; "/>
			<col ref="dept1totqty"/>
			<col ref="dept1baseqty"/>
			<col ref="dept2totqty"/>
			<col ref="dept2baseqty"/>
			<col ref="dept3totqty"/>
			<col ref="dept3baseqty"/>
			<col ref="dept4totqty"/>
			<col ref="dept4baseqty"/>
			<col ref="dept5totqty"/>
			<col ref="dept5baseqty"/>
			<col ref="dept6totqty"/>
			<col ref="dept6baseqty"/>
			<col ref="dept7totqty"/>
			<col ref="dept7baseqty"/>
			<col ref="dept8totqty"/>
			<col ref="dept8baseqty"/>
			<col ref="dept9totqty"/>
			<col ref="dept9baseqty"/>
			<col ref="dept10totqty"/>
			<col ref="dept10baseqty"/>
			<col ref="color" visibility="hidden"/>
			<script type="javascript" ev:event="onaftersort">
				<![CDATA[
					grd_goodbaseqtylist.gridToInstance();
				]]>
			</script>
		</datagrid>
		<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:15px; width:1195px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
		<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:186px; height:14px; ">약품 안전재고량 관리</caption>
		<select1 id="cmb_instcd" ref="/root/main/cond/instcd" class="combo_s_essential" appearance="minimal" style="left:100px; top:25px; width:165px; height:19px; ">
			<choices>
				<itemset>
					<label/>
					<value/>
				</itemset>
			</choices>
		</select1>
		<input id="ipt_reqdd" ref="/root/main/cond/fromdd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:375px; top:25px; width:94px; height:19px; "/>
		<caption id="caption1" style="left:480px; top:25px; width:20px; height:15px; ">~</caption>
		<caption id="caption2" class="search_name" style="left:15px; top:25px; width:89px; height:17px; ">기관코드 :</caption>
		<caption id="caption4" class="tit_2" style="left:1px; top:65px; width:190px; height:13px; ">부서별 안전재고량</caption>
		<line id="line1" class="line_1" style="x1:1px; y1:80px; x2:1191px; y2:80px; "/>
		<input id="input1" ref="/root/main/cond/todd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:495px; top:25px; width:94px; height:19px; "/>
		<line id="line3" class="line_4" style="x1:1048px; y1:20px; x2:1048px; y2:47px; border-color:#ffe4bb; border-left-style:solid; "/>
		<caption id="caption16" class="search_name" style="left:290px; top:25px; width:86px; height:17px; ">조회일자</caption>
		<button id="btn_save" class="btn4_letter2" style="left:1060px; top:25px; width:56px; height:22px; ">
			<caption>저장</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						if (submit("TXRSD00801")) {
							messageBox("저장되었습니다.", "I");
						}
					]]>
			</script>
		</button>
		<button id="btn_search" class="btn1_letter2" style="left:1125px; top:25px; width:56px; height:22px; ">
			<caption>조회</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					submit("TRRSD00801");	
					var caption = model.getValue("/root/main/goodbaseqtyinfo/deptlist/grd_deptcd");
					var size = model.getValue("/root/main/goodbaseqtyinfo/deptlist/grd_size");
					var hiddencols = size * 2 + 3;
					
					grd_goodbaseqtylist.caption = "약품코드^약품명^" + caption + "^color|약품코드^약품명^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^총합^안전재고량^color"
					for(var currow = 0; currow < grd_goodbaseqtylist.rows; currow++){
						var color = model.getValue("/root/main/goodbaseqtyinfo/goodbaseqtylist[" + currow + "]/color");
						var grd_color= "FFFFFF"
						if(color == "Y"){
							grd_color  = "#ff00ff"
						} 
						grd_goodbaseqtylist.rowStyle(currow+ 1, "data", "background-color") = "#" + grd_color;
					}
					//넘어온 부서 수만큼만 화면에 보여줌. 아닌것들은 숨김.
					for(var i = 1; i <= grd_goodbaseqtylist.cols; i++) {
						if(i < hiddencols) {
							grd_goodbaseqtylist.colHidden(i) = false;
						} else {
							grd_goodbaseqtylist.colHidden(i) = true;
						}
					}

					grd_goodbaseqtylist.refresh();
					
				]]>
			</script>
		</button>
		<button id="button2" class="btn2_letter2" navindex="7" style="left:1145px; top:60px; width:42px; height:19px; text-align:left; ">
			<caption>엑셀</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[	
							
							if(grd_goodbaseqtylist.rows == "1") {
								messageBox("엑셀로 저장할 데이터가 존재하지않습니다.", "E");
								return;
							}
							var fileName = window.fileDialog("save", ",", false, "부서별 안전재고량", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
									
							if (fileName != "")
							{
								grd_goodbaseqtylist.saveExcel(fileName);
							}		
						]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>