YNU_JEUS/app_home/himed/webapps/ast/astctlweb/xrw/SMAER09200_검사월별실적조회(컨트롤타워).xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?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>
						<subordlist>
							<subordlist1>
								<excugrpcd/>
								<eqipcnt/>
								<gubun/>
								<monthamt1/>
								<monthamt2/>
								<monthamt3/>
								<monthamt4/>
								<monthamt5/>
								<monthamt6/>
								<monthamt7/>
								<monthamt8/>
								<monthamt9/>
								<monthamt10/>
								<monthamt11/>
								<monthamt12/>
								<totalamt/>
							</subordlist1>
						</subordlist>
					</main>
					<send>
						<fromdd/>
						<todd/>
						<cntflag/>
						<globalinstance>
							<instance1/>
						</globalinstance>
						<pagesize>999</pagesize>
						<ioflag/>
					</send>
					<init>
						<baseinfo>
							<initexecprcpstatcd/>
							<initprcpgenrflagcd/>
						</baseinfo>
					</init>
					<temp>
						<userinfolist/>
						<userpopupinfo>
							<param/>
							<flag/>
							<searchitem/>
						</userpopupinfo>
					</temp>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				
					//aezfSetSuppDeptcd();
					//ipt_fromdd.value = getCurrentDate();
					//ipt_todd.value = getCurrentDate();
				
					//btn_sea.dispatch("DOMActivate");
					
					
					aezfSetSuppDeptcd();
					
					var fromdd = getCurrentDate().substr(0,6);
					var todd = getCurrentDate().substr(0,6);
					
					model.setValue("/root/send/fromdd", fromdd);
					model.setValue("/root/send/todd", todd);
					model.setValue("/root/send/cntflag", "P");
					model.setValue("/root/send/ioflag", "O");
					
					setTitle();
					
					model.refresh();
					
					btn_sea.dispatch("DOMActivate");

				]]>
			</script>
			<submission id="TRAER09201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" add="bottom" resultref="/root/main/subordlist"/>
			<submission id="TRZBC00101"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../ast/examcureweb/js/AEZ0001.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/departmentcodeweb/js/ZSD001.js"/>
		<script type="javascript">
			<![CDATA[
			
			
					function setTitle() {
						
						model.removenode("/root/main/subordlist/subordlist1");
						
						var stYearMonth = model.getValue("/root/send/fromdd") + "01";
						var dtYearMonth = stYearMonth.toDate();
						var stEndMonth = model.getValue("/root/send/todd") + "01";
						var dtEndMonth = stEndMonth.toDate();
						
						var stYearHeader = "검사종류^장비수^구분^";
						var stMonthHeader = "검사종류^장비수^구분^";
						
						for (var i = 2; i <= 13; i++) {
							
							// 년도
							var stYear = dtYearMonth.getDateFormat("YYYY");
							// 월
							var stMonth = dtYearMonth.getDateFormat("MM");
							
							stYearHeader = stYearHeader + stYear + "년^";
							stMonthHeader = stMonthHeader + stMonth + "월^";
							
							if(dtYearMonth.getDateFormat("YYYYMM") > dtEndMonth.getDateFormat("YYYYMM")) {
								datagrid1.colHidden(1 + i) = true;
							} else {
								datagrid1.colHidden(1 + i) = false;
							}
							dtYearMonth.getAddDate(1, "M");
							
						}
						stYearHeader = stYearHeader + "계|";
						stMonthHeader = stMonthHeader + "계";
						
						datagrid1.caption = stYearHeader + stMonthHeader;
					}
					
				function readfunc() {
					
					model.removeNodeset("/root/main/subordlist/subordlist1");
					//submit("TRAER09101");
					
					
					
					if (submit("TRAER09201")) {

						//if (model.getValue("/root/main/subordlist/subordlist1[" + 1 + "]/excugrpcd") == ""){
						//	datagrid1.deleteRow(2);
						//}

						//var cnt = getNodesetCount("/root/main/subordlist/subordlist1");
						
						//for ( var i = 1; i <= datagrid1.rows; i++ ) {  
							//datagrid1.valueMatrix(i, grd_list.colRef("excugrpcd"));
							//datagrid1.subtotal("sum", -1, i, "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ", 2, "총계");
						//}
						/*
						if (cnt > 1) {
							
							datagrid1.colSort(0) = "asc";
							datagrid1.sort(0, 0, datagrid1.rows, datagrid1.cols) = "usersort";
									
							for(i=2; i<datagrid1.cols; i++) {
								datagrid1.subtotal("sum", -1, i, "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ", 2, "총계");
							}
									
						}
						*/
					}
					
					model.refresh();
							
				}

			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1195;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group3" scroll="auto" style="left:0px; top:13px; width:1195px; height:747px; ">
			<group id="group2" style="left:0px; top:5px; width:1195px; height:42px; vertical-align:top; ">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line1" style="x1:1045px; y1:5px; x2:1045px; y2:32px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption1" class="search_name" style="left:10px; top:10px; width:72px; height:17px; text-align:left; ">기간 :</caption>
				<button id="btn_sea" class="btn1_letter2" style="left:1065px; top:10px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
                            setTitle();
							
							openLoadingBar("검사별 실적을 조회 중입니다....") ;
							
							
							readfunc();
							
							model.refresh();
							
							closeLoadingBar() ;//처리중 화면을 close한다.    
						]]>
					</script>
				</button>
				<input id="ipt_fromdd" ref="/root/send/fromdd" navindex="1" inputtype="date" format="yyyy-mm" style="left:80px; top:10px; width:75px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var fromdd = (model.getValue("/root/send/fromdd") + "01").toDate();
							var todd = (model.getValue("/root/send/todd") + "01").toDate();
							
							if(fromdd < todd.getAddDate(-11, "M")) 
							{
								messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
								fromdd = todd;
							}
							model.setValue("/root/send/fromdd", fromdd.getDateFormat("YYYYMM"));
							fromdd = fromdd.getAddDate(-12, "M");
							fromdd = fromdd.getDateFormat("YYYYMM");
							
							//model.setValue("/root/send/comparefromdd", execfromdd);
							
							model.refresh();
						]]>
					</script>
				</input>
				<input id="ipt_todd" ref="/root/send/todd" navindex="1" inputtype="date" format="yyyy-mm" style="left:175px; top:11px; width:75px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var fromdd = (model.getValue("/root/send/fromdd") + "01").toDate();
							var todd = (model.getValue("/root/send/todd") + "01").toDate();
							
							if(fromdd.getAddDate(11, "M") < todd) 
							{
								messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
								todd = fromdd;
							}
							
							model.setValue("/root/send/todd", todd.getDateFormat("YYYYMM"));
							todd = todd.getAddDate(-12, "M");
							todd = todd.getDateFormat("YYYYMM");
							
							setTitle();
							
							model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption2" style="left:157px; top:10px; width:15px; height:20px; text-align:center; ">~</caption>
				<caption id="caption3" class="search_name" visibility="hidden" style="left:735px; top:10px; width:72px; height:17px; text-align:left; ">구분 :</caption>
				<select1 id="radio1" ref="/root/send/cntflag" visibility="hidden" appearance="full" cols="5" overflow="visible" style="left:805px; top:10px; width:235px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>환자수</label>
							<value>P</value>
						</item>
						<item>
							<label>촬영건수</label>
							<value>C</value>
						</item>
					</choices>
				</select1>
				<caption id="caption4" class="search_name" style="left:300px; top:10px; width:72px; height:17px; text-align:left; ">구분 :</caption>
				<select1 id="radio2" ref="/root/send/ioflag" visibility="visible" appearance="full" cols="5" overflow="visible" style="left:370px; top:10px; width:235px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>외래</label>
							<value>O</value>
						</item>
						<item>
							<label>입원</label>
							<value>I</value>
						</item>
						<item>
							<label>전체</label>
							<value></value>
						</item>
					</choices>
				</select1>
			</group>
			<line id="line2" class="line_1" style="x1:0px; y1:47px; x2:1195px; y2:47px; "/>
			<datagrid id="datagrid1" nodeset="/root/main/subordlist/subordlist1" caption="검사종류^장비수^구분^월별 실적^월별 실적^월별 실적^월별 실적^월별 실적^월별 실적^월별 실적^월별 실적^월별 실적^월별 실적^월별 실적^월별 실적^계|검사종류^장비수^구분^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^계" colsep="^" colwidth="172, 52, 63, 85, 85, 85, 85, 85, 85, 85, 85, 85, 85, 85, 85, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:50px; width:1195px; height:695px; ">
				<col ref="excugrpcd"/>
				<col ref="eqipcnt" style="text-align:center; "/>
				<col ref="gubun"/>
				<col ref="monthamt1" format="#,###" style="text-align:right; "/>
				<col ref="monthamt2" format="#,###" style="text-align:right; "/>
				<col ref="monthamt3" format="#,###" style="text-align:right; "/>
				<col ref="monthamt4" format="#,###" style="text-align:right; "/>
				<col ref="monthamt5" format="#,###" style="text-align:right; "/>
				<col ref="monthamt6" format="#,###" style="text-align:right; "/>
				<col ref="monthamt7" format="#,###" style="text-align:right; "/>
				<col ref="monthamt8" format="#,###" style="text-align:right; "/>
				<col ref="monthamt9" format="#,###" style="text-align:right; "/>
				<col ref="monthamt10" format="#,###" style="text-align:right; "/>
				<col ref="monthamt11" format="#,###" style="text-align:right; "/>
				<col ref="monthamt12" format="#,###" style="text-align:right; "/>
				<col ref="totalamt" format="#,###" style="text-align:right; "/>
			</datagrid>
		</group>
		<group id="group1" style="left:0px; top:0px; width:1194px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:142px; height:14px; ">검사월별실적</caption>
		</group>
		<button id="btn_excel1" class="btn2_letter2" style="left:1140px; top:30px; width:42px; height:19px; ">
			<caption>엑셀</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
				// 20091210_
					var filename = window.fileDialog("save", ",", false, "검사월별실적조회(진료지원_검사치료)"+"_"+model.getValue("/root/send/fromdd")+"_"+model.getValue("/root/send/todd"), "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					if (filename != "") {
						datagrid1.saveExcel(filename, "datagrid1", true, false, "", "", "");
					}
					]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>