YNU_JEUS/app_home/himed/webapps/ast/voluntractweb/xrw/SMAAA03800_자원봉사자종교별통계.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>
						<search>
							<fromdd/>
							<actdeptcd/>
						</search>
						<voluntractrelign>
							<voluntractreligninfo>
								<actdeptcd/>
								<voluntractdwcd/>
								<religncd01m/>
								<religncd01f/>
								<religncd02m/>
								<religncd02f/>
								<religncd03m/>
								<religncd03f/>
								<religncd04m/>
								<religncd04f/>
								<total/>
							</voluntractreligninfo>
						</voluntractrelign>
					</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="TRAAA03801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" resultref="/root/main/voluntractrelign"/>
		</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"/>
		<script type="javascript" src="../../../ast/soclworkweb/js/AWMCommon.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.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();
			var currentYM=CurrentDate.substr(0,6);
			
			model.makeValue("/root/main/search/fromdd",CurrentDate);
			addComboItem("cmb_actdeptcd","","","above");
			model.removeNodeset("/root/main/voluntractrelign");
			model.refresh();

		}
		//통계조회 
		function fVoluntrStatReq()
		{
			model.removeNodeset("/root/send/reqdata");
			model.makeNode("/root/send/reqdata");
			
			var fromdd=model.getValue("/root/main/search/fromdd");
			var actdeptcd=model.getValue("/root/main/search/actdeptcd");
		
			if(isNull(fromdd))
			{
				messageBox("조회시작일은","I003");
				return;
			}
			else
			{
				model.makeValue("/root/send/reqdata/fromdd",fromdd);
			}
			if(isNull(actdeptcd))
			{
				model.makeValue("/root/send/reqdata/actdeptcd","%");
			}
			else
			{
				model.makeValue("/root/send/reqdata/actdeptcd",actdeptcd);
			}
			
			submit("TRAAA03801");
			
			var i=grd_voluntractreligninfo.rows-grd_voluntractreligninfo.fixedRows;
			if(i!='0')
			{
			// 마지막 행의 숫자 값을 변수에 담는다. 
			var total=model.getValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+i+"]/total");
			var religncd01m=model.getValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+i+"]/religncd01m");
			var religncd01f=model.getValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+i+"]/religncd01f");
			var religncd02m=model.getValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+i+"]/religncd02m");
			var religncd02f=model.getValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+i+"]/religncd02f");
			var religncd03m=model.getValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+i+"]/religncd03m");
			var religncd03f=model.getValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+i+"]/religncd03f");
			var religncd04m=model.getValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+i+"]/religncd04m");
			var religncd04f=model.getValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+i+"]/religncd04f");
			
			
			//grd_voluntractageinfo.addRow();   //행추가 
			var religncd01mper=religncd01m/total*100;
			var religncd01fper=religncd01f/total*100;
			var religncd02mper=religncd02m/total*100;
			var religncd02fper=religncd02f/total*100;
			var religncd03mper=religncd03m/total*100;
			var religncd03fper=religncd03f/total*100;
			var religncd04mper=religncd04m/total*100;
			var religncd04fper=religncd04f/total*100;
			
			var totalper=total/total*100;
			//grd_voluntractageinfo.addItem();
			//grd_voluntractageinfo.addRow();
			
			var j=i+1;
			// 백분율 데이터 마지막에 추가 함 
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/actdeptcd","백분율(%)");
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/voluntractdwcd","백분율(%)");
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/religncd01m",religncd01mper);
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/religncd01f",religncd01fper);
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/religncd02m",religncd02mper);
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/religncd02f",religncd02fper);
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/religncd03m",religncd03mper);
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/religncd03f",religncd03fper);
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/religncd04m",religncd04mper);
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/religncd04f",religncd04fper);
			model.makeValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+j+"]/total",totalper);
			
			}
			else
			{
				return;
			}
			model.refresh();
			
			var idxRows=grd_voluntractreligninfo.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/voluntractrelign/voluntractreligninfo"+"["+i+"]/actdeptcd");
					var voluntractdwcd=model.getValue("/root/main/voluntractrelign/voluntractreligninfo"+"["+i+"]/voluntractdwcd");
					if(voluntractdwcd=="소계")
					{
						grd_voluntractreligninfo.cellStyle("background-color",i+1,2, i+1, 11) = "#ccffcc";    

					}
					else if(actdeptcd=="합계")
					{
						grd_voluntractreligninfo.cellStyle("background-color",i+1,1, i+1, 11) = "#ccffff";     
					}
					else if(actdeptcd=="백분율(%)")
					{
						grd_voluntractreligninfo.cellStyle("background-color",i+1,1, i+1, 11) = "#fccccc";     
					}
					else
					{
						grd_voluntractreligninfo.cellStyle("background-color",i+1,0, i+1, 11) = "#ffffff";   
					}
				}
			}

			model.refresh();
			
			
		}
		// 초기화 함수 
		function fResetVoluntrAgeStat()
		{
			var btn=messageBox("초기화를","Q004");
			if(btn=="6")
			{
				model.removeNodeset("/root/main/voluntractrelign");
			}
			else
			{
				return;
			}
			
			model.refresh();
			
		}
		
		
		//엑셀저장 버튼 클릭시
		function fExcelVoluntrAgeStat() 
		{	
			 var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
			if (fileName != "")
			{
				grd_voluntractreligninfo.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" navindex="3" 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_fromdd" ref="/root/main/search/fromdd" class="input_default" navindex="1" 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>
			<datagrid id="grd_voluntractreligninfo" nodeset="/root/main/voluntractrelign/voluntractreligninfo" caption="활동그룹^활동요일/시간대^가톨릭^가톨릭^기독교^기독교^불교^불교^기타^기타^합계|활동그룹^활동요일/시간대^남^여^남^여^남^여^남^여^합계" colsep="^" colwidth="127, 99, 64, 60, 65, 64, 44, 55, 51, 64, 100" dataheight="25" extendlastcol="scroll" frozencols="7" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:78px; width:820px; height:662px; ">
				<col ref="actdeptcd"/>
				<col ref="voluntractdwcd"/>
				<col ref="religncd01m" format="#.99" style="text-align:center; "/>
				<col ref="religncd01f" format="#.99" style="text-align:center; "/>
				<col ref="religncd02m" format="#.99" style="text-align:center; "/>
				<col ref="religncd02f" format="#.99" style="text-align:center; "/>
				<col ref="religncd03m" format="#.99" style="text-align:center; "/>
				<col ref="religncd03f" format="#.99" style="text-align:center; "/>
				<col ref="religncd04m" format="#.99" style="text-align:center; "/>
				<col ref="religncd04f" format="#.99" style="text-align:center; "/>
				<col ref="total" format="#.99" style="text-align:center; "/>
			</datagrid>
		</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>