YNU_JEUS/app_home/himed/webapps/ast/healexamstatweb/xrw/SMAHS00100_패키지별실적현황.xrw

<?xml version="1.0" encoding="UTF-16"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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>
						<pkglist>
							<cmpyflag/>
							<pkgcd/>
							<pkgnm/>
							<pkgamt/>
							<jan/>
							<feb/>
							<scnd/>
							<apr/>
							<may/>
							<jun/>
							<jul/>
							<aug/>
							<sep/>
							<oct/>
							<nov/>
							<dec/>
							<pkgcnt/>
							<pkgavgamt/>
							<pkgtotamt/>
							<pkgdiscamt/>
						</pkglist>
						<export/>
					</main>
					<send>
						<srchfromdd/>
						<srchtodd/>
						<srchhealexamflag/>
						<srchhealexamdetlflag/>
						<srchstatflag/>
					</send>
					<hidden>
					</hidden>
					<init>
						<baseinfo>
							<healexamflaglist>
								<A0068>
									<cdid/>
									<cdnm>전체</cdnm>
								</A0068>
							</healexamflaglist>
							<healexamdetlflaglist>
								<A0070>
									<cdid/>
									<cdnm>전체</cdnm>
								</A0070>
							</healexamdetlflaglist>
							<statflaglist>
							</statflaglist>
							<healexamdetlflaglist1>
								<A0069>
									<cdid/>
									<cdnm>전체</cdnm>
								</A0069>
							</healexamdetlflaglist1>
						</baseinfo>
					</init>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					zbcfGetCodeList( new Array("A0068","A0070","A0107","A0069"),
						new Array("/root/init/baseinfo/healexamflaglist" ,"/root/init/baseinfo/healexamdetlflaglist" ,"/root/init/baseinfo/statflaglist","/root/init/baseinfo/healexamdetlflaglist1") );          
					model.setValue("/root/send/srchfromdd", getCurrentDate());
					model.setValue("/root/send/srchtodd", getCurrentDate());
					cmb_srchhealexamflag.refresh();
					cmb_srchhealexamdetlflag.refresh();
	
					//cmb_statflag.refresh();
					ckb_statflag.refresh();
				     
					/*	
					var vToday = new Date();
					var tmpYear = vToday.getYear();
					var tmpMonth = vToday.getMonth()+1;
					var tmpDate = vToday.getDate();
					
					if (tmpMonth < 10) { tmpMonth = "0"+tmpMonth; }
					if (tmpDate < 10) { tmpDate = "0"+tmpDate; }
					model.setValue("/root/main/search/fromdata", tmpYear+""+tmpMonth+""+tmpDate-1);
					model.setValue("/root/main/search/todata", tmpYear+""+tmpMonth+""+tmpDate);
					input7.refresh();
					input1.refresh();
					datagrid1.explorerbar = "sort";
					*/
					model.refresh();
					model.setFocus("ipt_fromdd");
				]]>
			</script>
			<submission id="TRZBC00101"/>
			<submission id="TRAHS00101" method="post" ref="/root/send" resultref="/root/main"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
		<script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784">
		<group id="group3" style="left:0px; top:0px; width:1211px; height:13px; ">
			<caption id="caption60" class="tit_1" style="left:0px; top:0px; width:183px; height:14px; font-family:돋움; vertical-align:middle; ">패키지별실적현황</caption>
		</group>
		<group id="group2" style="left:4px; top:23px; width:1203px; height:48px; ">
			<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1202px; height:46px; background-color:#fffbf2; border-color:#ffd799; "/>
			<caption id="caption2" class="search_name" style="left:15px; top:15px; width:198px; height:17px; ">기간                           ~</caption>
			<line id="line2" class="line_4" style="x1:1132px; y1:14px; x2:1132px; y2:36px; border-color:#ffe4bb; border-left-style:solid; "/>
			<button id="btn_search" class="btn1_letter2" style="left:1139px; top:14px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						/*	
						model.removeNodeset("/root/main/monthbloodlist/monthbloodstats");
						var  fromdata =  model.getValue("/root/main/search/fromdata");
						var  todata     =  model.getValue("/root/main/search/todata");
						if(fromdata==""||fromdata==null){
							messageBox("시작일을 입력","E007");
							model.setFocus("input7");
							return false;
						}
						if(todata==""|| todata==null){
							messageBox("끝일을 입력","E007");
							model.setFocus("input1");
							return false;
						}
						if(fromdata > todata){
							messageBox("시작일이 끝일자보다 클수 ", "C001")
							return false;
						}else{
							model.setValue("/root/send/fromdata",model.getValue("/root/main/search/fromdata"));	
							model.setValue("/root/send/todata",model.getValue("/root/main/search/todata"));			
							model.setValue("/root/send/datagubun",model.getValue("/root/main/search/datagubun"));			
							model.removeNodeset("/root/main/frontamtlist");							
							
							submit("");
						}
						model.refresh();
						*/
						
						/*
						20100701 JHP 상태 컨트롤 체크박스 변경에 따른 in형식으로 하게끔 수정
						쿼리에서 해당내용이 안먹어서 내용 주석처리
						var stat = model.getValue("/root/send/srchstatflag");
						var result = "";
						if(stat  != null || stat != "" || stat != " "){
							var leng = stat.length;
							for(var i = 0; i < leng; i++){
								var chng = stat.substr(i,1);
								if(chng != " "){
									if(result == null || result == ""){
										result = chng;
									}else{
										result = result+"','"+chng;
									}
								}
							}
							model.setValue("/root/send/srchstatflag",result);
						}
						*/
					
						/* 20110413 서원식 검색기능 IN형 조회 수정 */
						var stat = model.getValue("/root/send/srchstatflag");
						var j = 1;
						
						if(stat  != null || stat != "" || stat != " "){
							for(var i = 0; i<stat.length; i++){
								var chng = stat.substr(i, 1);
								if(chng != " "){
									model.makeValue("/root/send/srchstatflag"+ j + "",chng);
									j = j+1;
								}
							}
						}
	
						submit("TRAHS00101");
	
						grd_pkglist.subtotalPosition = "below";
						for(var i =0; i < grd_pkglist.cols ; i++) {
							if(i >= grd_pkglist.colRef("jan") && i <= grd_pkglist.colRef("pkgcnt")) {
								grd_pkglist.subtotal("sum", -1, i, "format:#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold; ", 1, "총계", false);
							}
						}

						// 화면 merge														
						if( i ==  grd_pkglist.colRef("jan")) {
							grd_pkglist.mergeCol(i) = true;
						}else{
							grd_pkglist.mergeCol(i) = false;
						}
						model.refresh();
					]]>
				</script>
			</button>
			<input id="ipt_fromdd" ref="/root/send/srchfromdd" class="input_default" navindex="1" inputtype="date" style="left:70px; top:14px; width:120px; height:19px; ">
				<script type="javascript" ev:event="onkeydown">
					<![CDATA[
				/*
				if( event.keyCode == 13 ) {
					var pCurTargetObj = event.ptarget.parent;
					if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
						event.keyCode = 9;
						pCurTargetObj.dispatch("onkeydown");
					}else{
						event.keyCode = 9;	
					}
				}
				event.stopPropagation();							*/
				]]>
				</script>
			</input>
			<input id="input1" ref="/root/send/srchtodd" class="input_default" navindex="2" inputtype="date" style="left:215px; top:14px; width:120px; height:19px; ">
				<script type="javascript" ev:event="onkeydown">
					<![CDATA[
				/*
				if( event.keyCode == 13 ) {
					var pCurTargetObj = event.ptarget.parent;
					if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
						event.keyCode = 9;
						pCurTargetObj.dispatch("onkeydown");
					}else{
						event.keyCode = 9;	
					}
				}
				event.stopPropagation();
				*/
				]]>
				</script>
			</input>
			<select1 id="cmb_srchhealexamdetlflag" ref="/root/send/srchhealexamdetlflag" class="combo_search" appearance="minimal" style="left:560px; top:14px; width:100px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/baseinfo/healexamdetlflaglist/A0070">
						<label ref="cdnm"/>
						<value ref="cdid"/>
					</itemset>
				</choices>
			</select1>
			<select1 id="cmb_srchhealexamflag" ref="/root/send/srchhealexamflag" class="combo_search" appearance="minimal" style="left:440px; top:14px; width:110px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/baseinfo/healexamflaglist/A0068">
						<label ref="cdnm"/>
						<value ref="cdid"/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					if(cmb_srchhealexamflag.value == "C"){
						cmb_srchhealexamdetlflag.choices.itemset.attribute("nodeset") = "/root/init/baseinfo/healexamdetlflaglist1/A0069";
					}else if(cmb_srchhealexamflag.value == "G"){
						cmb_srchhealexamdetlflag.choices.itemset.attribute("nodeset") = "/root/init/baseinfo/healexamdetlflaglist/A0070";
					}
					model.refresh();
				]]>
				</script>
			</select1>
			<!--
			<select1 id="cmb_statflag" ref="/root/send/srchstatflag" class="combo_search" visibility="hidden" appearance="minimal" style="left:1084px; top:14px; width:40px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/baseinfo/statflaglist/A0107">
						<label ref="cdnm"/>
						<value ref="cdid"/>
					</itemset>
				</choices>
			</select1>
			-->
			<caption id="caption3" class="search_name" style="left:675px; top:15px; width:86px; height:17px; ">상태 :</caption>
			<select id="ckb_statflag" ref="/root/send/srchstatflag" overflow="visible" appearance="full" cols="5" rows="2" style="left:740px; top:8px; width:324px; height:32px; padding:0; border-style:none; ">
				<choices>
					<itemset nodeset="/root/init/baseinfo/statflaglist/A0107">
						<label ref="cdnm"/>
						<value ref="cdid"/>
					</itemset>
				</choices>
			</select>
		</group>
		<datagrid id="grd_pkglist" nodeset="/root/main/pkglist" caption="패키지코드^패키지코드^패키지명^금액^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^패키지별건수" colsep="^" colwidth="40, 110, 200, 100, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 87" mergecellsfixedcols="bycol" mergecellsfixedrows="byrowrec" rowheader="seq" rowsep="|" style="left:5px; top:100px; width:1203px; height:677px; text-align:center; ">
			<col disabled="true" ref="cmpyflag" type="combo">
				<choices>
					<item>
						<label>개인</label>
						<value>N</value>
					</item>
					<item>
						<label>단체</label>
						<value>Y</value>
					</item>
				</choices>
			</col>
			<col explorerbar="sortshow" ref="pkgcd" style="text-align:left; "/>
			<col explorerbar="sortshow" ref="pkgnm" style="text-align:left; "/>
			<col explorerbar="sortshow" ref="pkgamt" format="#,###" style="text-align:right; "/>
			<col ref="jan"/>
			<col ref="feb"/>
			<col ref="scnd"/>
			<col ref="apr"/>
			<col ref="may"/>
			<col ref="jun"/>
			<col ref="jul"/>
			<col ref="aug"/>
			<col ref="sep"/>
			<col ref="oct"/>
			<col ref="nov"/>
			<col ref="dec"/>
			<col explorerbar="sortshow" ref="pkgcnt"/>
			<script type="javascript" ev:event="onaftersort">
				<![CDATA[
				grd_pkglist.gridToInstance();
			]]>
			</script>
		</datagrid>
		<caption id="caption1" class="search_name" style="left:350px; top:38px; width:86px; height:17px; ">건진구분 :</caption>
		<button id="button1" class="btn2_letter4" style="left:1143px; top:75px; width:64px; height:19px; ">
			<caption>액셀저장</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
			/*	
			var vToday = new Date();
			var tmpYear = vToday.getYear();
			var tmpMonth = vToday.getMonth()+1;
			var tmpDate = vToday.getDate();
			if (tmpMonth < 10) { tmpMonth = "0"+tmpMonth; }
			if (tmpDate < 10) { tmpDate = "0"+tmpDate; }
							
			//엑셀저장 여부(타이틀별)
			var fileName = window.fileDialog("save", "", false, "수혈대체현황"+tmpYear+tmpMonth+tmpDate, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
			if (fileName != ""){
				datagrid1.saveExcel(fileName, "수혈대체현황"+tmpYear+tmpMonth+tmpDate, true, true, "", "", true);
			}
			*/
			var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*"); 
			grd_pkglist.saveExcel(fileName, "SheetName", true, true, "", "", false);
			]]>
			</script>
		</button>
		<button id="button2" class="btn2_letter2" visibility="visible" style="left:1100px; top:75px; width:42px; height:19px; ">
			<caption>출력</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
				model.makeValue("/root/main/export/srchfromdd" , model.getValue("/root/send/srchfromdd").toDate().getDateFormat("YYYY/MM/DD"));
				model.makeValue("/root/main/export/srchtodd" , model.getValue("/root/send/srchtodd").toDate().getDateFormat("YYYY/MM/DD"));
				exeReportPreview("RPAHS00101", "XMLSTR", "/root/main/export","", "false","","","","","false");	
			]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>