YNU_JEUS/app_home/himed/webapps/mis/stocsumweb/xrw/SMRST03200_거래처별입고금액(약국).xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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>
						<winsuplplcecdamtlist/>
						<list>
							<goodwin>
								<goodwinlist/>
							</goodwin>
						</list>
					</main>
					<send>
						<instcd/>
						<goodflag/>
						<winfrdd/>
						<stocdeptcd/>
						<lrgcd/>
						<instcdnm/>
						<wintodd/>
						<bnscd/>
						<windeptcdyn>Y</windeptcdyn>
						<lrgcdyn>Y</lrgcdyn>
						<winpsnyn>Y</winpsnyn>
						<goodwin>
							<instcd/>
							<goodflag/>
							<lrgcd/>
							<lrgnm/>
							<windeptcd/>
							<windeptnm/>
							<suplplcecd/>
							<suplplcenm/>
							<goodcd/>
							<goodnm/>
							<winfrdd/>
							<wintodd/>
						</goodwin>
					</send>
					<init>
					</init>
					<temp/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					//화면 Control을 초기화한다
					fInitialize();	
				]]>
			</script>
			<submission id="TRRST03201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/rsthssstlist"/>
			<submission id="TRRSI00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/goodwin" resultref="/root/main/list/goodwin"/>
		</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[
			
			// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
			function fInitialize() 
			{	
			
				model.resetInstanceNode("/root/send");
			
				misfGridInit(grd_goodwin);
				misfGridInit(grd_winsuplplcecdamtlist);
				// [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
				rszfComboStockArthDeptcdList(cmb_stocdeptcd,getUserInfo("dutplceinstcd"),"PH","Y" );
				
				//misfComboComCdListMulti("R0025","cmb_goodflag");


				misfMsterDetailSet(grd_winsuplplcecdamtlist, null, "TRRST03201", "N");
				

				model.setValue(opt_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
				model.setValue(opt_instcdnm.attribute("ref") , getUserInfo("dutplceinstnm"));
				// [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH) 
				model.setValue(opt_goodflag.attribute("ref"), "PH");
				
				var curdd = getCurrentDate();
				
				model.setValue(ipt_winfrdd.attribute("ref") , getCurrentDate());
				model.setValue(ipt_wintodd.attribute("ref") , getCurrentDate());

				model.setValue(ckb_windeptcdyn.attribute("ref") , "Y") ;  // 입고부서여부
				model.setValue(ckb_lrgcdyn.attribute("ref")        , "Y");   // 대분류여부  
				model.setValue(ckb_winpsnyn.attribute("ref")     , "Y");   // 입고자여부  
				// [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
				rszfGridComboLrgcdList("PH", cmb_lrgcd, "lrgcd","Y");

				model.refresh();
			}
			
			function fCheckRetrieveData()
			{
				if(!isRequiredControls("opt_instcd") )return false;		// 물품구분
				if(!isRequiredControls("opt_goodflag") )return false;		// 물품구분
				if(!isRequiredControls("ipt_winfrdd") )return false;		// 작업년월
				if(!isRequiredControls("ipt_wintodd") )return false;		// 작업년월
				//if(!isRequiredControls("cmb_stocdeptcd") )return false;		// 부서코드
			}
			// --------------------------------------------------   
			// View Option  처리하는 함수 
			// --------------------------------------------------   
			function fSumViewOption(pGrid, pOption, pCol) {
  
						grd_winsuplplcecdamtlist.colHidden(grd_winsuplplcecdamtlist.colRef(pCol)) = (pOption.value =="Y") ?  false : true; 
			}      
				
			]]>
		</script>
	</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:243px; height:14px; ">거래처별 입고금액 현황(약품)</caption>
		</group>
		<group id="grp_biz" scroll="auto" style="left:0px; top:38; width:1195; height:744; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:61px; background-color:#fffbf2; border-color:#ffd799; "/>
			<line id="line1" class="line_1" style="x1:0px; y1:95px; x2:1190px; y2:95px; "/>
			<datagrid id="grd_winsuplplcecdamtlist" nodeset="/root/main/winsuplplcecdamtlist" caption="입고부서^입고부서^대분류^대분류^거래처코드^거래처명칭^입고수량^입고금액^입고자^입고자^비고" colsep="^" colwidth="98, 150, 30, 152, 109, 173, 85, 126, 70, 70, 80, 100" dataheight="25" ellipsis="true" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:100px; width:1190px; height:255px; ">
				<col ref="windeptcd"/>
				<col ref="windeptcdnm"/>
				<col ref="lrgcd"/>
				<col ref="lrgcdnm"/>
				<col ref="suplplcecd" format="999-99-99999" _key="true" style="left:161px; top:25px; width:115px; height:25px; text-align:center; "/>
				<col ref="suplplcenm" style="text-align:left; "/>
				<col ref="winqty" format="#,###" style="text-align:right; "/>
				<col ref="winamt" format="#,###" style="text-align:right; "/>
				<col ref="winpsn" style="text-align:center; "/>
				<col ref="winpsnnm" style="text-align:center; "/>
				<col/>
				<col ref="instcd" visibility="hidden"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
									sPath = "/root/send/"; 
									tPath = "/root/send/goodwin/"; 
									
									// alert(grd_winsuplplcecdamtlist.row+"=="+grd_winsuplplcecdamtlist.rows);
									
									vSuplplcecd = model.getValue(grd_winsuplplcecdamtlist.nodeset+"["+grd_winsuplplcecdamtlist.row +"]/suplplcecd");   
									
                                    if (vSuplplcecd == "") return;
									
									model.setValue(tPath+"instcd"        , model.getValue(sPath+"instcd"    )); 
									model.setValue(tPath+"goodflag"    , model.getValue(sPath+"goodflag"  )); 
									model.setValue(tPath+"winfrdd"       , model.getValue(sPath+"winfrdd"   )); 
									model.setValue(tPath+"wintodd"      , model.getValue(sPath+"wintodd"   )); 
									model.setValue(tPath+"windeptcd"   , model.getValue(sPath+"stocdeptcd")); 
									model.setValue(tPath+"lrgcd"          , model.getValue(sPath+"lrgcd"     )); 
									model.setValue(tPath+"suplplcecd" , vSuplplcecd);   
									
									misfGridInit(grd_goodwin);
						
									submit("TRRSI00401");
									
					
					]]>
				</script>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
					                grd_winsuplplcecdamtlist.gridToInstance();
					]]>
				</script>
			</datagrid>
			<caption id="caption3" class="tit_2" style="left:5px; top:80px; width:183px; height:14px; ">거래처별 입고금액 리스트</caption>
			<button id="btn_search" class="btn1_letter2" style="left:1125px; top:29px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						
						
						misfGridInit(grd_winsuplplcecdamtlist);
						
						if(fCheckRetrieveData(false) == false)return;	
						
						submit("TRRST03201");

						grd_winsuplplcecdamtlist.subtotalposition = "below";
						grd_winsuplplcecdamtlist.subtotal("clear", 0, 0);     
						grd_winsuplplcecdamtlist.subtotal("sum",grd_winsuplplcecdamtlist.colRef("instcd") , grd_winsuplplcecdamtlist.colRef("winqty"), "format:(-)#,###; ", "background-color:#ffff88; font-weight:bold; ", grd_winsuplplcecdamtlist.colRef("suplplcecd") , "- 총계");	
						grd_winsuplplcecdamtlist.subtotal("sum",grd_winsuplplcecdamtlist.colRef("instcd") , grd_winsuplplcecdamtlist.colRef("winamt"), "format:(-)#,###; ", "background-color:#ffff88; font-weight:bold; ", grd_winsuplplcecdamtlist.colRef("suplplcecd") , "- 총계");	
						//grd_winsuplplcecdamtlist.subtotal("sum",grd_winsuplplcecdamtlist.colRef("suplplcecd") , grd_winsuplplcecdamtlist.colRef("winqty"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "- 합계");	
						//grd_winsuplplcecdamtlist.subtotal("sum",grd_winsuplplcecdamtlist.colRef("suplplcecd") , grd_winsuplplcecdamtlist.colRef("winamt"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "- 합계");	
												
						model.refresh();
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1110px; y1:16px; x2:1110px; y2:61px; "/>
			<caption id="cap_instcd" class="search_name" style="left:15; top:19; width:86px; height:17px; ">기관코드 :</caption>
			<caption id="cap_winfrdd" class="search_name" style="left:15px; top:45px; width:101px; height:17px; ">입고일자 :</caption>
			<caption id="cap_stocdeptcd" class="search_name" style="left:416px; top:46px; width:99px; height:17px; ">부     서 :</caption>
			<select1 id="cmb_stocdeptcd" ref="/root/send/stocdeptcd" class="combo_s_essential" appearance="minimal" style="left:502px; top:46px; width:153px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<output id="opt_instcdnm" ref="/root/send/instcdnm" class="output_fix" style="left:100px; top:18px; width:150px; height:19px; "/>
			<output id="opt_instcd" ref="/root/send/instcd" class="output_fix" visibility="hidden" style="left:254px; top:19px; width:20px; height:19px; "/>
			<input id="ipt_wintodd" ref="/root/send/wintodd" class="input_s_essential" inputtype="date" style="left:238px; top:46px; width:114px; height:19px; "/>
			<input id="ipt_winfrdd" ref="/root/send/winfrdd" class="input_s_essential" inputtype="date" style="left:100px; top:46px; width:114px; height:19px; "/>
			<caption id="caption22" style="left:220px; top:47px; width:15px; height:20px; font-weight:bold; vertical-align:middle; ">~</caption>
			<output id="opt_goodflag" ref="/root/send/goodflag" visibility="hidden" style="left:1085px; top:15px; width:20px; height:19px; "/>
			<select1 id="cmb_lrgcd" ref="/root/send/lrgcd" class="combo_s_essential" appearance="minimal" style="left:502px; top:19px; width:153px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption40" class="search_name" style="left:416px; top:20px; width:89px; height:17px; ">대 분 류 :</caption>
			<button id="btn_excel" class="btn2_letter2" style="left:1146px; top:75px; width:42px; height:19px; ">
				<caption>엑셀</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					misfSaveExcel(grd_winsuplplcecdamtlist);
					]]>
				</script>
			</button>
			<select1 id="rdo_prtflag" ref="/root/send/bnscd" appearance="full" cellspacing="5" cols="5" overflow="visible" style="left:805px; top:45px; width:280px; height:20px; border-style:none; ">
				<choices>
					<item>
						<label>전체</label>
						<value/>
					</item>
					<item>
						<label>보나에스거래</label>
						<value>2158155746</value>
					</item>
					<item>
						<label>기타거래</label>
						<value>O</value>
					</item>
				</choices>
			</select1>
			<caption id="cap_prtflag" class="search_name" style="left:692px; top:44px; width:93px; height:17px; ">조회구분 :</caption>
			<select id="ckb_winpsnyn" ref="/root/send/winpsnyn" overflow="visible" appearance="full" style="left:581px; top:75px; width:85px; height:20px; border-style:none; ">
				<choices>
					<item>
						<label>입고자</label>
						<value>Y</value>
					</item>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
										 fSumViewOption("",ckb_winpsnyn, "winpsn");
										 fSumViewOption("",ckb_winpsnyn, "winpsnnm");
								
								]]>
				</script>
			</select>
			<caption id="caption10" class="search_name" style="left:295px; top:75px; width:121px; height:17px; ">LIST 포함조건 :</caption>
			<select id="ckb_lrgcdyn" ref="/root/send/lrgcdyn" overflow="visible" appearance="full" style="left:505px; top:75px; width:70px; height:20px; border-style:none; ">
				<choices>
					<item>
						<label>대분류</label>
						<value>Y</value>
					</item>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
										 fSumViewOption("",ckb_lrgcdyn, "lrgcd");
										 fSumViewOption("",ckb_lrgcdyn, "lrgcdnm");
								]]>
				</script>
			</select>
			<select id="ckb_windeptcdyn" ref="/root/send/windeptcdyn" overflow="visible" appearance="full" style="left:420px; top:75px; width:75px; height:20px; border-style:none; ">
				<choices>
					<item>
						<label>입고부서</label>
						<value>Y</value>
					</item>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
										 fSumViewOption("",ckb_windeptcdyn, "windeptcd");
										 fSumViewOption("",ckb_windeptcdyn, "windeptcdnm");
								]]>
				</script>
			</select>
			<group id="group2" style="left:0px; top:365px; width:1190px; height:376px; ">
				<datagrid id="grd_goodwin" nodeset="/root/main/list/goodwin/goodwinlist" caption="입고일자^입고부서^순번^주거래처^입고유형^약품코드^약품명^함량^제조회사^낱개^낱개^포장^포장^입고금액^입고번호^발주번호^입고자^입고정보|입고일자^입고부서^순번^주거래처^입고유형^약품코드^약품명^함량^제조회사^수량^단가^수량^구입가^입고금액^입고번호^발주번호^입고자^입고정보" colsep="^" colwidth="82, 81, 49, 83, 74, 84, 280, 26, 0, 64, 64, 65, 85, 100, 100, 100, 93, 130, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" dataheight="23" ellipsis="true" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="23" rowsep="|" tooltip="true" style="left:0px; top:40px; width:1187px; height:329px; ">
					<col ref="windd" format="yyyy-mm-dd" style="text-align:center; "/>
					<col ref="windeptnm"/>
					<col ref="winseqno" style="text-align:center; "/>
					<col ref="suplplcenm"/>
					<col ref="iokindnm"/>
					<col ref="goodcd"/>
					<col ref="goodnm"/>
					<col ref="goodspec" visibility="hidden"/>
					<col ref="prodcmpynm"/>
					<col ref="winqty" format="#,###" style="text-align:right; "/>
					<col ref="winunitcost" format="#,###" style="text-align:right; "/>
					<col ref="winpackqty" format="#,###" style="text-align:right; "/>
					<col ref="goodpurccost" format="#,###" style="text-align:right; "/>
					<col ref="winamt" format="#,###" style="text-align:right; "/>
					<col ref="winno" visibility="hidden" style="left:1135px; top:23px; width:100px; height:23px; text-align:center; "/>
					<col ref="deliveno" visibility="hidden" style="text-align:center; "/>
					<col ref="winpsnnm" style="text-align:center; "/>
					<col ref="winputno"/>
					<col ref="goodmodel" visibility="hidden"/>
					<col ref="winpackunit" visibility="hidden"/>
					<col ref="winpackcntperunit" visibility="hidden" format="#,###" style="text-align:right; "/>
					<col ref="winunit" visibility="hidden"/>
					<col ref="delivedeptqty" visibility="hidden" format="#,###" style="text-align:right; "/>
					<col ref="stocqty" visibility="hidden" format="#,###" style="text-align:right; "/>
					<col ref="instcd" visibility="hidden"/>
					<col ref="goodflag" visibility="hidden"/>
					<col ref="winpsn" visibility="hidden"/>
					<col ref="windeptcd" visibility="hidden"/>
					<col ref="installplcecd" visibility="hidden"/>
					<col ref="paycond" visibility="hidden"/>
					<col ref="temppay" visibility="hidden"/>
					<col ref="calcdocukind" visibility="hidden"/>
					<col ref="elctstmntyn" visibility="hidden"/>
					<col ref="iokind" visibility="hidden"/>
					<col ref="suplplcecd" visibility="hidden"/>
					<col ref="purcdmnddd" visibility="hidden"/>
					<col ref="purcdmndno" visibility="hidden"/>
					<col ref="purcdmndseq" visibility="hidden"/>
					<col ref="deliveseqno" visibility="hidden"/>
					<col ref="bnscd" visibility="hidden"/>
					<col ref="calcdocudd" visibility="hidden"/>
					<col ref="profno" visibility="hidden"/>
					<col ref="acntcd" visibility="hidden"/>
					<col ref="reqdd" visibility="hidden"/>
					<col ref="reqno" visibility="hidden"/>
					<col ref="reqseqno" visibility="hidden"/>
					<col ref="valiterm" visibility="hidden"/>
					<col ref="stocynindx" visibility="hidden"/>
					<col ref="chkdd" visibility="hidden"/>
					<col ref="chkpsn" visibility="hidden"/>
					<col ref="chkyn" visibility="hidden"/>
					<col ref="slipdd" visibility="hidden"/>
					<col ref="slipno" visibility="hidden"/>
					<col ref="suppcustcd" visibility="hidden"/>
					<col ref="cmt" visibility="hidden"/>
					<col ref="prewinqty" visibility="hidden"/>
					<col ref="minexch" visibility="hidden"/>
					<col ref="suppcustnm" visibility="hidden"/>
					<script type="javascript" ev:event="onrowchanged">
						<![CDATA[
					misfMsterDetailRetrieve();	
										]]>
					</script>
					<script type="javascript" ev:event="onaftersort">
						<![CDATA[
						grd_goodwin.gridToInstance();
					]]>
					</script>
				</datagrid>
				<line id="line15" class="line_1" style="x1:0px; y1:35px; x2:1187px; y2:35px; "/>
				<caption id="caption35" class="tit_2" style="left:0px; top:18px; width:95px; height:13px; ">입고내역</caption>
				<button id="button1" class="btn2_letter2" style="left:1138px; top:14px; width:42px; height:19px; ">
					<caption>엑셀</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
					misfSaveExcel(grd_goodwin);
					]]>
					</script>
				</button>
			</group>
		</group>
		<group id="group1" style="left:0px; top:12; width:1195px; height:27px; ">
			<button id="btn_print" class="btn6_letter5" disabled="false" visibility="hidden" style="left:0px; top:3px; width:92px; height:22px; ">
				<caption>리스트출력</caption>
			</button>
			<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>
			<line id="line17" class="line_6" style="x1:0px; y1:25px; x2:1195px; y2:25px; "/>
		</group>
	</xhtml:body>
</xhtml:html>