YNU_JEUS/app_home/himed/webapps/ast/voluntractweb/xrw/SMAAA03700_자원봉사자연령별통계.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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>
						<search>
							<fromdd/>
							<actdeptcd/>
						</search>
						<voluntractage>
							<voluntractageinfo>
								<actdeptcd/>
								<voluntractdwcd/>
								<voluntractteamcd/>
								<twenty/>
								<thirty/>
								<forty/>
								<fifty/>
								<sixty/>
								<etc/>
								<total/>
							</voluntractageinfo>
						</voluntractage>
					</main>
					<init>
						<vacatflagcd>
						</vacatflagcd>
						<actdeptcd/>
						<voluntractteamcd/>
					</init>
					<send>
						<reqdata/>
					</send>
					<hidden>
						<init>
							<comcd/>
						</init>
					</hidden>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					//grd_studvoluntrlist.fixedcellcheckbox(0,1) = "true";
					fInit();
				]]>
			</script>
			<submission id="TRZBC00101" mediatype="application/x-www-form-urlencoded" method="post"/>
			<submission id="TRZBC00102" mediatype="application/x-www-form-urlencoded" method="post"/>
			<submission id="TRZBP00102" mediatype="application/x-www-form-urlencoded" method="post"/>
			<submission id="TRAAA03701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" resultref="/root/main/voluntractage"/>
		</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/stringHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
		<script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
	</xhtml:head>
	<script type="javascript">
		<![CDATA[
		//초기화
		function fInit() {
			
			zbcfGetCodeList(new Array("A0503","A0359","A0360"),new Array("/root/hidden/init/comcd","/root/hidden/init/comcd","/root/hidden/init/comcd"));
			
			var CurrentDate=getCurrentDate();
			
			model.makeValue("/root/main/search/fromdd",CurrentDate);
			
			addComboItem("cmb_actdeptcd","","","above");
			model.removeNodeset("/root/main/voluntractage");
			
			model.refresh();

		}
		//통계조회 
		function fVoluntrStatReq()
		{
			model.removeNodeset("/root/send/reqdata");
			model.makeNode("/root/send/reqdata");
			
			var actdeptcd=model.getValue("/root/main/search/actdeptcd");
			var fromdd=model.getValue("/root/main/search/fromdd");
			var todd=model.getValue("/root/main/search/todd");
			
			if(isNull(actdeptcd))
			{
				model.makeValue("/root/send/reqdata/actdeptcd","%");
			}
			else
			{
				model.makeValue("/root/send/reqdata/actdeptcd",actdeptcd);
			}
			if(isNull(fromdd))
			{
				messageBox("조회일자는","I003");
				return;
			}
			else
			{
				model.makeValue("/root/send/reqdata/fromdd",fromdd);
			}
			
			
			//model.copyNode("/root/send/reqdata","/root/main/search");
			
			submit("TRAAA03701");
			
			
			var i=grd_voluntractageinfo.rows-grd_voluntractageinfo.fixedRows;
			
			if(i!='0')
			{
				
			// 마지막 행의 숫자 값을 변수에 담는다. 
			var total=model.getValue("/root/main/voluntractage/voluntractageinfo"+"["+i+"]/total");
			var twenty=model.getValue("/root/main/voluntractage/voluntractageinfo"+"["+i+"]/twenty");
			var thirty=model.getValue("/root/main/voluntractage/voluntractageinfo"+"["+i+"]/thirty");
			var forty=model.getValue("/root/main/voluntractage/voluntractageinfo"+"["+i+"]/forty");
			var fifty=model.getValue("/root/main/voluntractage/voluntractageinfo"+"["+i+"]/fifty");
			var sixty=model.getValue("/root/main/voluntractage/voluntractageinfo"+"["+i+"]/sixty");
			var etc=model.getValue("/root/main/voluntractage/voluntractageinfo"+"["+i+"]/etc");
			
			//grd_voluntractageinfo.addRow();   //행추가 
			var twentyper=twenty/total*100;
			var thirtyper=thirty/total*100;
			var fortyper=forty/total*100;
			var fiftyper=fifty/total*100;
			var sixtyper=sixty/total*100;
			var etcper=etc/total*100;
			var totalper=total/total*100;
			//grd_voluntractageinfo.addItem();
			//grd_voluntractageinfo.addRow();
			
			var j=i+1;
			// 백분율 데이터 마지막에 추가 함 
			model.makeValue("/root/main/voluntractage/voluntractageinfo"+"["+j+"]/actdeptcd","백분율(%)");
			model.makeValue("/root/main/voluntractage/voluntractageinfo"+"["+j+"]/voluntractdwcd","백분율(%)");
			model.makeValue("/root/main/voluntractage/voluntractageinfo"+"["+j+"]/twenty",twentyper);
			model.makeValue("/root/main/voluntractage/voluntractageinfo"+"["+j+"]/thirty",thirtyper);
			model.makeValue("/root/main/voluntractage/voluntractageinfo"+"["+j+"]/forty",fortyper);
			model.makeValue("/root/main/voluntractage/voluntractageinfo"+"["+j+"]/fifty",fiftyper);
			model.makeValue("/root/main/voluntractage/voluntractageinfo"+"["+j+"]/sixty",sixtyper);
			model.makeValue("/root/main/voluntractage/voluntractageinfo"+"["+j+"]/etc",etcper);
			model.makeValue("/root/main/voluntractage/voluntractageinfo"+"["+j+"]/total",totalper);
			
			
			
			}
			else
			{
				return;
			}
			model.refresh();
			
			var idxRows=grd_voluntractageinfo.rows;
			
			if(idxRows!='0')
			{
				for(i=1;i<=idxRows;i++)
				{
					
						//grd_voluntractteaminfo.cellStyle("background-color",3,2, 3, 5) = "#ccffcc";   
					var actdeptcd=model.getValue("/root/main/voluntractage/voluntractageinfo"+"["+i+"]/actdeptcd");
					var voluntractdwcd=model.getValue("/root/main/voluntractage/voluntractageinfo"+"["+i+"]/voluntractdwcd");
					if(voluntractdwcd=="소계")
					{
						grd_voluntractageinfo.cellStyle("background-color",i+1,2, i+1, 9) = "#ccffcc";    

					}
					else if(actdeptcd=="합계")
					{
						grd_voluntractageinfo.cellStyle("background-color",i+1,1, i+1, 9) = "#ccffff";     
					}
					else if(actdeptcd=="백분율(%)")
					{
						grd_voluntractageinfo.cellStyle("background-color",i+1,1, i+1, 9) = "#fccccc";     
					}
					else
					{
						grd_voluntractageinfo.cellStyle("background-color",i+1,0, i+1, 9) = "#ffffff";   
					}
				}
			}
			
			model.refresh();
			
			
		}
		// 초기화 함수 
		function fResetVoluntrAgeStat()
		{
			var btn=messageBox("초기화를","Q004");
			if(btn=="6")
			{
				model.removeNodeset("/root/main/voluntractage");
			}
			else
			{
				return;
			}
			
			model.refresh();
			
		}
		
		
		//엑셀저장 버튼 클릭시
		function fExcelVoluntrAgeStat() 
		{	
			 var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
			if (fileName != "")
			{
				grd_voluntractageinfo.saveExcel(fileName, "SheetName", false, false, "", "", false);
			}		
				
		}
		
		
		]]>
	</script>
	<xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:815px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:207px; height:14px; ">자원봉사자통계</caption>
		</group>
		<group id="group3" scroll="auto" style="left:0px; top:13px; width:825px; height:744px; ">
			<group id="grp_sea" style="left:0px; top:10px; width:820px; height:35px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:820px; height:35px; "/>
				<button id="button1" class="btn1_letter2" style="left:753px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[						
							fVoluntrStatReq();										
						]]>
					</script>
				</button>
				<line id="line13" class="line_4" style="x1:742px; y1:7px; x2:742px; y2:29px; "/>
				<caption id="caption3" class="search_name" style="left:20px; top:10px; width:94px; height:17px; ">조회일자 :</caption>
				<input id="ipt_year" ref="/root/main/search/fromdd" class="input_default" inputtype="date" format="yyyy-mm-dd" appearance="minimal" style="left:114px; top:9px; width:86px; height:19px; "/>
				<caption id="caption2" class="search_name" style="left:325px; top:10px; width:94px; height:17px; ">활동그룹 :</caption>
				<select1 id="cmb_actdeptcd" ref="/root/main/search/actdeptcd" appearance="minimal" style="left:420px; top:10px; width:100px; height:19px; ">
					<choices>
						<itemset nodeset="/root/hidden/init/comcd/A0503">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
									fVoluntrStatReq();				
						]]>
					</script>
				</select1>
			</group>
			<button id="button3" class="btn2_letter4" disable.background-image="../../../com/commonweb/images/dis_btn2_letter4.gif" style="left:748px; top:51px; width:64px; height:19px; background-image:../../../com/commonweb/images/btn2_letter4.gif; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[																
						fExcelVoluntrAgeStat();						
					]]>
				</script>
			</button>
			<switch id="swt_studstats" style="left:0px; top:77px; width:820px; height:663px; border-style:solid; ">
				<case id="case_sch" selected="true">
					<datagrid id="grd_voluntractageinfo" nodeset="/root/main/voluntractage/voluntractageinfo" caption="활동그룹^활동요일/시간대^20대^30대^40대^50대^60대^기타^합계^합계|활동그룹^활동요일/시간대^20대^30대^40대^50대^60대^기타^합계^합계" colsep="^" colwidth="130, 104, 80, 80, 80, 85, 79, 80, 79" dataheight="25" extendlastcol="scroll" frozencols="7" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:0px; width:815px; height:660px; ">
						<col ref="actdeptcd" style="text-align:center; "/>
						<col ref="voluntractdwcd" style="text-align:center; "/>
						<col ref="twenty" format="#.99" style="text-align:center; "/>
						<col ref="thirty" format="#.99" style="text-align:center; "/>
						<col ref="forty" format="#.99" style="text-align:center; "/>
						<col ref="fifty" format="#.99" style="text-align:center; "/>
						<col ref="sixty" format="#.99" style="text-align:center; "/>
						<col ref="etc" format="#.99" style="text-align:center; "/>
						<col ref="total" format="#.99" style="text-align:center; "/>
					</datagrid>
				</case>
			</switch>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:757px; width:820px; height:27px; ">
			<line id="line37" class="line_6" style="x1:0px; y1:0px; x2:820px; y2:0px; "/>
		</group>
		<caption id="caption1" class="tit_2" style="left:5px; top:71px; width:309px; height:14px; ">자원봉사자 연령별 통계</caption>
		<line id="line1" class="line_1" style="x1:0px; y1:86px; x2:820px; y2:86px; "/>
		<button id="button10" class="btn4_letter3" disable.background-image="../../../com/commonweb/images/dis_btn4_letter3.gif" style="left:743px; top:760px; width:68px; height:22px; background-image:../../../com/commonweb/images/btn4_letter3.gif; ">
			<caption>초기화</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						fResetVoluntrAgeStat();		
					]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>