YNU_JEUS/app_home/himed/webapps/mis/reqweb/xrw/SMRSD10200_부가가치세 물품내역 조회(경북대).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: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="">
					<cond>
						<instcd/>
						<instnm/>
						<srchfromdd/>
						<srchtodd/>
						<goodflag>A</goodflag>
						<goodcd/>
						<suplplcecd/>
						<suplplcenm/>
					</cond>
					<main>
						<list>
							<addtaxsumgoodinfo>
								<addtaxsumgoodlist/>
							</addtaxsumgoodinfo>
						</list>
					</main>
					<init>
						<totalsumqty/>
						<totalsumamt/>
					</init>
					<send>
						<reqdata/>
					</send>
					<hidden>
					</hidden>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					//화면 Control을 초기화한다
					fInitialize();	
				]]>
			</script>
			<submission id="TRRSD10201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/cond" 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[
			// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
			function fInitialize() {	
				
				misfGridInit(grd_addtaxsumgoodlist);			
				var curdate = getCurrentDate();
				var cvtdate = curdate.toDate("YYYYMMDD");
				model.setValue("/root/cond/instcd",getUserInfo("dutplceinstcd"));
				model.setValue("/root/cond/instnm",getUserInfo("dutplceinstnm"));
				
				model.setValue(ipt_srchfromdd.attribute("ref"),cvtdate.getAddDate(-1,"D").getDateFormat("YYYYMMDD"));
				model.setValue(ipt_srchtodd.attribute("ref")  ,curdate);
				
				
				model.refresh();
			}
			
			function fGridChange(){
				var gridCaption = grd_addtaxsumgoodlist.caption;
				
				if(rdo_goodflag.value == "A"){
					gridCaption = gridCaption.replace("약품코드","물품코드");
					gridCaption = gridCaption.replace("약품명","물품명");
					
					grd_addtaxsumgoodlist.colHidden(grd_addtaxsumgoodlist.colRef("goodspec")) = false;
					grd_addtaxsumgoodlist.colHidden(grd_addtaxsumgoodlist.colRef("goodmodel")) = false;
					grd_addtaxsumgoodlist.colHidden(grd_addtaxsumgoodlist.colRef("cnst")) = true;
					grd_addtaxsumgoodlist.colHidden(grd_addtaxsumgoodlist.colRef("costconyn")) = false;
				}else{
					gridCaption = gridCaption.replace("물품코드","약품코드");
					gridCaption = gridCaption.replace("물품명","약품명");
					
					grd_addtaxsumgoodlist.colHidden(grd_addtaxsumgoodlist.colRef("goodspec")) = true;
					grd_addtaxsumgoodlist.colHidden(grd_addtaxsumgoodlist.colRef("goodmodel")) = true;
					grd_addtaxsumgoodlist.colHidden(grd_addtaxsumgoodlist.colRef("cnts")) = false;
					grd_addtaxsumgoodlist.colHidden(grd_addtaxsumgoodlist.colRef("costconyn")) = true;
				}
				
				grd_addtaxsumgoodlist.caption = gridCaption;
				
				grd_addtaxsumgoodlist.refresh();
			}
			
			
			]]>
		</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:201px; height:14px; ">부가가치세 집계물품내역 조회</caption>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:38; width:1195; height:744; ">
			<group id="group6" style="left:0px; top:10px; width:1195px; height:65px; vertical-align:top; ">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line2" class="line_4" style="x1:1079px; y1:7px; x2:1079px; y2:50px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption5" class="search_name" style="left:360px; top:10px; width:101px; height:17px; ">발생일자 :</caption>
				<caption id="cap_goodcdA" class="search_name" style="left:360px; top:35px; width:99px; height:17px; ">물품코드 :</caption>
				<caption id="cap_goodcdB" class="search_name" visibility="hidden" style="left:360px; top:35px; width:99px; height:17px; ">약품코드 :</caption>
				<button id="btn_search" class="btn1_letter2" navindex="4" style="left:1094px; top:17px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

						if(submit("TRRSD10201")){
							fGridChange();
							var tGrid = grd_addtaxsumgoodlist;
							var totalSumQty = 0;
							var totalSumAmt = 0;
							for(var i=tGrid.fixedRows ; i<tGrid.rows ; i++ ){
								totalSumQty += parseFloat(tGrid.valueMatrix(i , tGrid.colRef("totsumqty")));
								totalSumAmt += parseFloat(tGrid.valueMatrix(i , tGrid.colRef("totsumamt")));
							}
							model.setValue("/root/init/totalsumqty",totalSumQty);
							model.setValue("/root/init/totalsumamt",totalSumAmt);
							//alert("totalSumQty := " + totalSumQty + "\ntotalSumAmt := " + totalSumAmt);
							opt_totalsumqty.refresh();
							opt_totalsumamt.refresh();
							
						}
					]]>
					</script>
				</button>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					//btn_search.dispatch("DOMActivate");
					]]>
				</script>
				<caption id="caption2" class="search_name" style="left:20px; top:35px; width:101px; height:17px; ">집계구분 :</caption>
				<caption id="cap_instcd" class="search_name" style="left:20px; top:10px; width:86px; height:17px; ">기관코드 :</caption>
				<output id="opt_instcd" ref="/root/cond/instcd" class="output_fix" visibility="hidden" style="left:10px; top:10px; width:30px; height:19px; "/>
				<output id="opt_instcdnm" ref="/root/cond/instnm" class="output_fix" style="left:110px; top:10px; width:180px; height:19px; "/>
				<input id="ipt_srchfromdd" ref="/root/cond/srchfromdd" class="input_s_essential" navindex="1" inputtype="date" style="left:452px; top:10px; width:100px; height:19px; text-align:center; "/>
				<caption id="caption11" class="search_no_b" style="left:555px; top:12px; width:12px; height:17px; ">~</caption>
				<input id="ipt_srchtodd" ref="/root/cond/srchtodd" class="input_s_essential" navindex="2" inputtype="date" style="left:570px; top:10px; width:100px; height:19px; text-align:center; "/>
				<select1 id="rdo_goodflag" ref="/root/cond/goodflag" overflow="visible" appearance="full" cols="2" style="left:110px; top:35px; width:100px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>재료</label>
							<value>A</value>
						</item>
						<item>
							<label>약품</label>
							<value>B</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							if(rdo_goodflag.value== "A"){
								cap_goodcdA.visible = true;
								cap_goodcdB.visible = false;
							}else{
								cap_goodcdA.visible = false;
								cap_goodcdB.visible = true;
							}
						]]>
					</script>
				</select1>
				<input id="ipt_goodcd" ref="/root/cond/goodcd" class="input_search" imemode="disabled" _chartype="upper" style="left:452px; top:35px; width:145px; height:19px; ">
					<script type="javascript" ev:event="onkeyup">
						<![CDATA[
							inputEnterKey("btn_search", "DOMActivate");
						]]>
					</script>
				</input>
				<caption id="caption1" class="search_name" style="left:720px; top:12px; width:75px; height:17px; ">거래처 :</caption>
				<input id="ipt_suplplcecd" ref="/root/cond/suplplcecd" class="input_search" navindex="19" style="left:800px; top:10px; width:65px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

						if(ipt_suplplcecd.value.length == 0) 
							opt_suplplcenm.value = "";
						else{
							rszfValidationCheck("TRRSD00221", "reqcustomlist", "instcd,refcond,retrnm", 
											model.getValue(opt_instcd.attribute("ref")) +",," + model.getValue(ipt_suplplcecd.attribute("ref")),"","suplplcecd,suplplcenm" ,
											ipt_suplplcecd,"SPRSD00220","instcd","opt_instcd");
							if(model.getValue("/root/init/main/reqcustomlist/custcode") != ""){
								ipt_suplplcecd.value = model.getValue("/root/init/main/reqcustomlist/custcode");
							}
						}
						model.refresh();	
						
						]]>
					</script>
				</input>
				<button id="btn_suplplcecd" class="icon_search" style="left:870px; top:13px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						rszfOpenPopUpListByWndName(ipt_suplplcecd,"","suplplcecd,suplplcenm","SPRSD00220","instcd","opt_instcd");
						model.refresh();
						]]>
					</script>
				</button>
				<output id="opt_suplplcenm" ref="/root/cond/suplplcenm" class="output_fix" style="left:890px; top:10px; width:155px; height:19px; text-align:left; padding-left:10; "/>
			</group>
			<datagrid id="grd_addtaxsumgoodlist" nodeset="/root/main/list/addtaxsumgoodinfo/addtaxsumgoodlist" class="datagrid2" caption="발생일자^물품코드^물품명^규격^모델^함량^거래처^단가계약^총수량^단가^금액^금액(부가세적용)^원무부가세^구매집계여부^품의일자^품의번호" colsep="^" colwidth="100, 113, 258, 136, 94, 100, 100, 64, 63, 91, 91, 100, 82, 82, 75, 55" dataheight="23" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="23" rowsep="|" style="left:0px; top:104px; width:1195px; height:631px; ">
				<col ref="genrdd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="goodcd" style="text-align:center; "/>
				<col ref="goodnm" style="text-align:left; "/>
				<col ref="goodspec" style="text-align:left; "/>
				<col ref="goodmodel" style="text-align:left; "/>
				<col ref="cnts" visibility="hidden" style="text-align:center; "/>
				<col ref="suplplcenm" style="text-align:left; "/>
				<col ref="costconyn" style="text-align:center; "/>
				<col ref="totsumqty" format="#,###.##" style="text-align:right; "/>
				<col ref="goodunitcost" format="#,###.##" style="text-align:right; "/>
				<col ref="totsumamt" format="#,###.##" style="text-align:right; "/>
				<col ref="totsumamttax" visibility="hidden" style="text-align:right; "/>
				<col ref="totsumamtpamtax" visibility="hidden" style="text-align:right; "/>
				<col ref="purcflag" style="text-align:center; "/>
				<col ref="purccnsttndd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="purccnsttnno" style="text-align:center; "/>
			</datagrid>
			<caption id="caption35" class="tit_2" style="left:5px; top:84px; width:185px; height:13px; ">부가가치세 집계물품내역</caption>
			<line id="line15" class="line_1" style="x1:0px; y1:101px; x2:1195px; y2:100px; "/>
			<output id="opt_totalsumamt" ref="/root/init/totalsumamt" class="output_default" format="#,###" style="left:910px; top:77px; width:110px; height:19px; font-weight:bold; "/>
			<caption id="caption39" class="tit_2" style="left:832px; top:81px; width:80px; height:13px; vertical-align:middle; ">총 금액 :</caption>
			<button id="button1" class="btn5_letter5" navindex="12" style="left:1115px; top:77px; width:75px; height:19px; ">
				<caption>Excel 저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
				
					   var fileName = window.fileDialog("save", ",", false, "부가가치세 집계물품내역", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
								
						if (fileName != "")
						{
							grd_addtaxsumgoodlist.saveExcel(fileName);
						}		
					]]>
				</script>
			</button>
			<output id="opt_totalsumqty" ref="/root/init/totalsumqty" class="output_default" format="#,###" style="left:770px; top:77px; width:55px; height:19px; font-weight:bold; "/>
			<caption id="caption3" class="tit_2" style="left:692px; top:81px; width:80px; height:13px; vertical-align:middle; ">총 수량 :</caption>
		</group>
		<group id="group4" ref="/root/init/instcd" style="left:0px; top:12; width:1195; height:26px; ">
			<button id="button8" class="btn6_letter2" visibility="hidden" style="left:0px; top:3px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
					]]>
				</script>
			</button>
			<line id="line17" class="line_6" style="x1:0px; y1:25px; x2:1195; y2:25px; "/>
			<button id="button2" class="btn6_letter4" visibility="hidden" style="left:60px; top:3px; width:56px; height:22px; ">
				<caption>미리보기</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>