YNU_JEUS/app_home/himed/webapps/mis/purcstatsweb/xrw/SMRSG04400_월간구매현황.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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:ms="urn:schemas-microsoft-com:xslt" xmlns:my="http://www.comsquare.co.kr/example" 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>
						<printdatalist1/>
					</main>
					<send>
						<instcd/>
						<reqym/>
						<goodflag/>
						<ioflag/>
						<prtflag>A</prtflag>
						<reqflag>9</reqflag>
						<purcacntcd/>
					</send>
					<init>
						<goodflag>
							<label>전체</label>
							<value/>
							<label>의료소모품</label>
							<value>Y</value>
							<label>일반소모품</label>
							<value>Z</value>
							<label>의료비품</label>
							<value>U</value>
							<label>일반비품</label>
							<value>G</value>
							<label>의료장비</label>
							<value>E</value>
						</goodflag>
						<ioflag>
							<label>정상</label>
							<value>1</value>
							<label>지불필</label>
							<value>2</value>
							<label>외자</label>
							<value>3</value>
							<label>기증(기타)</label>
							<value>4</value>
						</ioflag>
					</init>
					<temp>
						<goodflag/>
						<usernm/>
						<reqym/>
					</temp>
					<print/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[

					fInitialize();
				
				]]>
			</script>
			<submission id="TRRSG04401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/printdatalist1"/>
		</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/dateHelper.js"/>
		<script type="javascript">
			<![CDATA[
				function fInitialize()
				{
					misfComboComCdList("Z0007", cmb_instcd);
					
					ipt_reqym.value = getCurrentDate().toDate("YYYYMMDD").getDateFormat("YYYYMM");
										
					cmb_instcd.value = getUserInfo("dutplceinstcd");  
					
					// makeReportPreview(0,140,1195,640);
					
					cmb_goodflag.select(0);
					cmb_ioflag.select(0);
					
					model.refresh();
					
					cmb_goodflag.dispatch("xforms-value-changed");
					
				}
				
				function fSetInfo()
				{
					model.setValue("/root/temp/goodflag", cmb_goodflag.label);
					model.setValue("/root/temp/usernm", getUserInfo("usernm"));
					model.setValue("/root/temp/reqym", ipt_reqym.value);
					
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1194;" 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:189px; height:14px; ">월간구매현황</caption>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
			<line id="line12" class="line_6" style="x1:0px; y1:25; x2:1194px; y2:25; "/>
			<button id="btn_init" class="btn4_letter3" style="left:1126; top:3; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fInitialize();
					]]>
				</script>
			</button>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
			<group id="group6" style="left:0px; top:10px; width:1194; height:59; vertical-align:top; ">
				<shape id="roundrect3" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1194; height:59.; "/>
				<caption id="cap_reqym" class="search_name" style="left:15px; top:35px; width:86px; height:17px; ">기준년월 :</caption>
				<button id="btn_search" class="btn1_letter2" navindex="4" style="left:1125px; top:20px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							if(!isRequiredControls("cmb_instcd"))return;
							if(!isRequiredControls("cmb_ioflag"))return;
							if(!isRequiredControls("ipt_reqym"))return;
							if(!isRequiredControls("rdd_prtflag"))return;

							submit("TRRSG04401");  

										// grd_source.colHidden(grd_source.colRef("custnm"      )) = true;   // 거래처        
										// grd_source.colHidden(grd_source.colRef("suplplcecd"  )) = true;   // 사업자등록번호
										  
										  grd_source.colHidden(grd_source.colRef("winno"       )) = true    // 입고번호      
										  grd_source.colHidden(grd_source.colRef("goodcd"      )) = true;   // 자재코드      
										  grd_source.colHidden(grd_source.colRef("goodnm"      )) = true;   // 품명          
										  grd_source.colHidden(grd_source.colRef("goodspec"    )) = true;   // 규격          
										  grd_source.colHidden(grd_source.colRef("winunitcost" )) = true;   // 입고단가      
										  grd_source.colHidden(grd_source.colRef("winqty"      )) = true;   // 입고수량      
										  grd_source.colHidden(grd_source.colRef("winamt"      )) = true;   // 입고금액      
										  grd_source.colHidden(grd_source.colRef("prsdnm"      )) = true;   // 대표자명      
										  grd_source.colHidden(grd_source.colRef("totamt"      )) = true;   // 총금액        
										  grd_source.colHidden(grd_source.colRef("chaamt"      )) = true;   // 차감금액      
										  grd_source.colHidden(grd_source.colRef("payamt"      )) = true;   // 지불금액      
										  grd_source.colHidden(grd_source.colRef("rsvd"        )) = true;   // 비고          
										  grd_source.colHidden(grd_source.colRef("instcd"      )) = true;   // 기관코드      
										  grd_source.colHidden(grd_source.colRef("instnm"      )) = true;   // 기관코드명    
										  grd_source.colHidden(grd_source.colRef("goodflag"    )) = true;   // 물품구분      
										  grd_source.colHidden(grd_source.colRef("goodflagnm"  )) = true;   // 물품구분명    
										  grd_source.colHidden(grd_source.colRef("paycond"     )) = true;   // 지불구분      
										  grd_source.colHidden(grd_source.colRef("purcacntcd"  )) = true;   // 계정코드      
										  grd_source.colHidden(grd_source.colRef("windd"       )) = true;   // 입고일자      
										  grd_source.colHidden(grd_source.colRef("calcdocukind")) = true;   // 계산서구분    
										  grd_source.colHidden(grd_source.colRef("taxamt"      )) = true;   // 부가세        
										  grd_source.colHidden(grd_source.colRef("item"        )) = true;   // item          
										  grd_source.colHidden(grd_source.colRef("bizcont"     )) = true;   // bizcont       
										  
										  if(rdo_prtflag.value == "A") {       // 월간계정별 구매현황 
										           grd_source.colwidth( grd_source.colRef("custnm"      )) = 203;   // 거래처       
										           grd_source.colwidth( grd_source.colRef("winno"       )) = 112;   // 입고번호       
										           grd_source.colwidth( grd_source.colRef("goodcd"      )) = 68 ;   // 자재코드       
										           grd_source.colwidth( grd_source.colRef("goodnm"      )) = 200;   // 품명           
										           grd_source.colwidth( grd_source.colRef("goodspec"    )) = 110;   // 규격    
										                  
										           grd_source.colHidden(grd_source.colRef("goodflagnm"  )) = false;  // 물품구분명    
										           grd_source.colHidden(grd_source.colRef("winno"       )) = false;  // 입고번호      
										           grd_source.colHidden(grd_source.colRef("goodcd"      )) = false;  // 자재코드      
										           grd_source.colHidden(grd_source.colRef("goodnm"      )) = false;  // 품명          
										           grd_source.colHidden(grd_source.colRef("goodspec"    )) = false;  // 규격          
										           grd_source.colHidden(grd_source.colRef("winunitcost" )) = false;  // 입고단가      
										           grd_source.colHidden(grd_source.colRef("winqty"      )) = false;  // 입고수량      
										           grd_source.colHidden(grd_source.colRef("winamt"      )) = false;  // 입고금액      
										 }else if(rdo_prtflag.value == "B"){  // 거래처별 물대LIST 
										           grd_source.colwidth( grd_source.colRef("custnm"      )) = 285;   // 거래처       
										           grd_source.colwidth( grd_source.colRef("goodcd"      )) = 68   ;  // 자재코드      
										           grd_source.colwidth( grd_source.colRef("goodnm"      )) = 270  ;  // 품명          
										           grd_source.colwidth( grd_source.colRef("goodspec"    )) = 151  ;  // 규격
										           
										           grd_source.colHidden(grd_source.colRef("goodcd"      )) = false;  // 자재코드      
										           grd_source.colHidden(grd_source.colRef("goodnm"      )) = false;  // 품명          
										           grd_source.colHidden(grd_source.colRef("goodspec"    )) = false;  // 규격          
										           grd_source.colHidden(grd_source.colRef("winunitcost" )) = false;  // 입고단가      
										           grd_source.colHidden(grd_source.colRef("winqty"      )) = false;  // 입고수량      
										           grd_source.colHidden(grd_source.colRef("winamt"      )) = false;  // 입고금액      
										 }else if(rdo_prtflag.value == "C"){  // 거래처별 구매대장 

										           grd_source.colwidth( grd_source.colRef("custnm"      )) = 285;   // 거래처       
										           grd_source.colHidden(grd_source.colRef("prsdnm"      )) = false;   // 대표자명      
										           grd_source.colHidden(grd_source.colRef("totamt"      )) = false;   // 총금액        
										           grd_source.colHidden(grd_source.colRef("chaamt"      )) = false;   // 차감금액      
										           grd_source.colHidden(grd_source.colRef("payamt"      )) = false;   // 지불금액      
										           grd_source.colHidden(grd_source.colRef("rsvd"        )) = false;   // 비고          
										 }


							model.refresh();
						]]>
					</script>
				</button>
				<line id="line14" class="line_4" style="x1:1107px; y1:7; x2:1107px; y2:52; border-color:#ffe4bb; border-left-style:solid; "/>
				<input id="ipt_reqym" ref="/root/send/reqym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:104px; top:34px; width:141px; height:19px; "/>
				<caption id="cap_instcd" class="search_name" style="left:15; top:9; width:86px; height:17px; ">기관코드 :</caption>
				<select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" appearance="minimal" style="left:104px; top:8px; width:141px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<select1 id="cmb_goodflag" ref="/root/send/goodflag" class="combo_s_essential" appearance="minimal" style="left:389px; top:8px; width:121px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/goodflag">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							
							if(cmb_goodflag.value != '')
							{								
								cmd_purcacntcd.disabled = false;
								rszfPuacGetComboList( cmb_instcd.value, cmb_goodflag.value , "cmd_purcacntcd");
								
							}else{								
								cmd_purcacntcd.value = '';
								cmd_purcacntcd.disabled = true;
							}
							
							// btn_search.dispatch("DOMActivate");
							
						]]>
					</script>
				</select1>
				<caption id="cap_goodflag" class="search_name" style="left:300px; top:9px; width:86px; height:17px; ">물품구분 :</caption>
				<caption id="cap_ioflag" class="search_name" style="left:300px; top:35px; width:86px; height:17px; ">입고구분 :</caption>
				<select1 id="cmb_ioflag" ref="/root/send/ioflag" class="combo_s_essential" appearance="minimal" style="left:389px; top:34px; width:121px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/ioflag">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</select1>
				<caption id="cap_prtflag" class="search_name" style="left:685px; top:9px; width:86px; height:17px; ">출력구분 :</caption>
				<select1 id="rdo_prtflag" ref="/root/send/prtflag" appearance="full" cellspacing="20" cols="3" overflow="visible" style="left:775px; top:9px; width:280px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>계정</label>
							<value>A</value>
						</item>
						<item>
							<label>거래처</label>
							<value>B</value>
						</item>
						<item>
							<label>거래처합계</label>
							<value>C</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
			                             misfGridInit(grd_source);
										 
										// grd_source.colHidden(grd_source.colRef("custnm"      )) = true;   // 거래처        
										// grd_source.colHidden(grd_source.colRef("suplplcecd"  )) = true;   // 사업자등록번호
										  
										  grd_source.colHidden(grd_source.colRef("winno"       )) = true    // 입고번호      
										  grd_source.colHidden(grd_source.colRef("goodcd"      )) = true;   // 자재코드      
										  grd_source.colHidden(grd_source.colRef("goodnm"      )) = true;   // 품명          
										  grd_source.colHidden(grd_source.colRef("goodspec"    )) = true;   // 규격          
										  grd_source.colHidden(grd_source.colRef("winunitcost" )) = true;   // 입고단가      
										  grd_source.colHidden(grd_source.colRef("winqty"      )) = true;   // 입고수량      
										  grd_source.colHidden(grd_source.colRef("winamt"      )) = true;   // 입고금액      
										  grd_source.colHidden(grd_source.colRef("prsdnm"      )) = true;   // 대표자명      
										  grd_source.colHidden(grd_source.colRef("totamt"      )) = true;   // 총금액        
										  grd_source.colHidden(grd_source.colRef("chaamt"      )) = true;   // 차감금액      
										  grd_source.colHidden(grd_source.colRef("payamt"      )) = true;   // 지불금액      
										  grd_source.colHidden(grd_source.colRef("rsvd"        )) = true;   // 비고          
										  grd_source.colHidden(grd_source.colRef("instcd"      )) = true;   // 기관코드      
										  grd_source.colHidden(grd_source.colRef("instnm"      )) = true;   // 기관코드명    
										  grd_source.colHidden(grd_source.colRef("goodflag"    )) = true;   // 물품구분      
										  grd_source.colHidden(grd_source.colRef("goodflagnm"  )) = true;   // 물품구분명    
										  grd_source.colHidden(grd_source.colRef("paycond"     )) = true;   // 지불구분      
										  grd_source.colHidden(grd_source.colRef("purcacntcd"  )) = true;   // 계정코드      
										  grd_source.colHidden(grd_source.colRef("windd"       )) = true;   // 입고일자      
										  grd_source.colHidden(grd_source.colRef("calcdocukind")) = true;   // 계산서구분    
										  grd_source.colHidden(grd_source.colRef("taxamt"      )) = true;   // 부가세        
										  grd_source.colHidden(grd_source.colRef("item"        )) = true;   // item          
										  grd_source.colHidden(grd_source.colRef("bizcont"     )) = true;   // bizcont       
										  
										  if(rdo_prtflag.value == "A") {       // 월간계정별 구매현황 
										           grd_source.colwidth( grd_source.colRef("custnm"      )) = 203;   // 거래처       
										           grd_source.colwidth( grd_source.colRef("winno"       )) = 112;   // 입고번호       
										           grd_source.colwidth( grd_source.colRef("goodcd"      )) = 68 ;   // 자재코드       
										           grd_source.colwidth( grd_source.colRef("goodnm"      )) = 200;   // 품명           
										           grd_source.colwidth( grd_source.colRef("goodspec"    )) = 110;   // 규격    
										                  
										           grd_source.colHidden(grd_source.colRef("goodflagnm"  )) = false;  // 물품구분명    
										           grd_source.colHidden(grd_source.colRef("winno"       )) = false;  // 입고번호      
										           grd_source.colHidden(grd_source.colRef("goodcd"      )) = false;  // 자재코드      
										           grd_source.colHidden(grd_source.colRef("goodnm"      )) = false;  // 품명          
										           grd_source.colHidden(grd_source.colRef("goodspec"    )) = false;  // 규격          
										           grd_source.colHidden(grd_source.colRef("winunitcost" )) = false;  // 입고단가      
										           grd_source.colHidden(grd_source.colRef("winqty"      )) = false;  // 입고수량      
										           grd_source.colHidden(grd_source.colRef("winamt"      )) = false;  // 입고금액      
										 }else if(rdo_prtflag.value == "B"){  // 거래처별 물대LIST 
										           grd_source.colwidth( grd_source.colRef("custnm"      )) = 285;   // 거래처       
										           grd_source.colwidth( grd_source.colRef("goodcd"      )) = 68   ;  // 자재코드      
										           grd_source.colwidth( grd_source.colRef("goodnm"      )) = 270  ;  // 품명          
										           grd_source.colwidth( grd_source.colRef("goodspec"    )) = 151  ;  // 규격
										           
										           grd_source.colHidden(grd_source.colRef("goodcd"      )) = false;  // 자재코드      
										           grd_source.colHidden(grd_source.colRef("goodnm"      )) = false;  // 품명          
										           grd_source.colHidden(grd_source.colRef("goodspec"    )) = false;  // 규격          
										           grd_source.colHidden(grd_source.colRef("winunitcost" )) = false;  // 입고단가      
										           grd_source.colHidden(grd_source.colRef("winqty"      )) = false;  // 입고수량      
										           grd_source.colHidden(grd_source.colRef("winamt"      )) = false;  // 입고금액      
										 }else if(rdo_prtflag.value == "C"){  // 거래처별 구매대장 

										           grd_source.colwidth( grd_source.colRef("custnm"      )) = 285;   // 거래처       
										           grd_source.colHidden(grd_source.colRef("prsdnm"      )) = false;   // 대표자명      
										           grd_source.colHidden(grd_source.colRef("totamt"      )) = false;   // 총금액        
										           grd_source.colHidden(grd_source.colRef("chaamt"      )) = false;   // 차감금액      
										           grd_source.colHidden(grd_source.colRef("payamt"      )) = false;   // 지불금액      
										           grd_source.colHidden(grd_source.colRef("rsvd"        )) = false;   // 비고          
										 }
						
							//btn_search.dispatch("DOMActivate");
						]]>
					</script>
				</select1>
				<select1 id="rdo_reqflag" ref="/root/send/reqflag" appearance="full" cellspacing="10" cols="4" overflow="visible" style="left:775px; top:30px; width:320px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>전체</label>
							<value>9</value>
						</item>
						<item>
							<label>평화드림</label>
							<value>1</value>
						</item>
						<item>
							<label>하이드로메디</label>
							<value>2</value>
						</item>
						<item>
							<label>일반 품목</label>
							<value>3</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							//btn_search.dispatch("DOMActivate");
						]]>
					</script>
				</select1>
				<select1 id="cmd_purcacntcd" ref="/root/send/purcacntcd" class="combo_search" appearance="minimal" style="left:513px; top:8px; width:145px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						//btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</group>
			<caption id="caption22" class="tit_2" style="left:5px; top:79px; width:113px; height:14px; ">월간구매현황</caption>
			<line id="line19" class="line_1" style="x1:0px; y1:94; x2:1194px; y2:94+; "/>
			<datagrid id="grd_source" nodeset="/root/main/printdatalist1" caption="물품구분^거래처^사업자등록번호^입고번호^자재코드^품명^규격^입고단가^입고수량^입고금액^대표자명^총금액^차감금액^지불금액^비고^기관코드^기관코드명^물품구분^지불구분^계정코드^입고일자^계산서구분^부가세^item^bizcont" colsep="^" colwidth="83, 203, 97, 112, 68, 200, 110, 90, 70, 100, 105, 140, 140, 140, 233, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:99px; width:1194px; height:642px; ">
				<col ref="goodflagnm"/>
				<col ref="custnm"/>
				<col ref="suplplcecd" format="999-99-99999" style="text-align:center; "/>
				<col ref="winno" style="text-align:center; "/>
				<col ref="goodcd" style="text-align:center; "/>
				<col ref="goodnm"/>
				<col ref="goodspec"/>
				<col ref="winunitcost" format="(-)#,###" style="text-align:right; "/>
				<col ref="winqty" format="(-)#,###" style="text-align:right; "/>
				<col ref="winamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="prsdnm" visibility="hidden" style="text-align:center; "/>
				<col ref="totamt" visibility="hidden" format="(-)#,###" style="text-align:right; "/>
				<col ref="chaamt" visibility="hidden" format="(-)#,###" style="text-align:right; "/>
				<col ref="payamt" visibility="hidden" format="(-)#,###" style="text-align:right; "/>
				<col ref="rsvd" visibility="hidden"/>
				<col ref="instcd" visibility="hidden" style="text-align:center; "/>
				<col ref="instnm" visibility="hidden"/>
				<col ref="goodflag" visibility="hidden" style="text-align:center; "/>
				<col ref="paycond" visibility="hidden" style="text-align:center; "/>
				<col ref="purcacntcd" visibility="hidden" style="text-align:center; "/>
				<col ref="windd" visibility="hidden" style="text-align:center; "/>
				<col ref="calcdocukind" visibility="hidden" style="text-align:center; "/>
				<col ref="taxamt" visibility="hidden" format="(-)#,###" style="text-align:right; "/>
				<col ref="item" visibility="hidden"/>
				<col ref="bizcont" visibility="hidden"/>
			</datagrid>
			<button id="btn_excel" class="btn5_letter3" style="left:1129px; top:72px; width:53px; height:19px; ">
				<caption>Excel</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
								misfSaveExcel(grd_source);
							]]>
				</script>
			</button>
			<button id="btn_print" class="btn6_letter2" visibility="visible" style="left:1064px; top:71px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
							 fSetInfo();
							
							if(rdo_prtflag.value == 'A')
							{
								exeReportPreview("RPRSG04401", "XMLSTR");
							}else if(rdo_prtflag.value == 'B'){
								exeReportPreview("RPRSG04402", "XMLSTR");
							}else if(rdo_prtflag.value == 'C'){
								exeReportPreview("RPRSG04403", "XMLSTR");
							}
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>