YNU_JEUS/app_home/himed/webapps/ast/voluntractweb/xrw/SMAAA01000_자원봉사자개인별실적조회.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="">
					<send>
						<reqdata/>
					</send>
					<main>
						<search>
							<fromdd/>
							<todd/>
							<actdeptcd/>
							<voluntractdwcd/>
							<voluntractteamcd/>
							<fromlstdd/>
						</search>
						<voluntrindachivlist>
							<voluntrindachivinfo>
								<voluntractteamcd/>
								<voluntractdwcd/>
								<voluntrnm/>
								<voluntrid/>
								<baptnm/>
								<jobrespcd/>
								<actdeptcd/>
								<joinorgdd/>
								<lstmnthservtm/>
								<servtm/>
								<totalservtm/>
								<attdabsnflag1/>
								<attdabsnflag2/>
								<attdabsnflag3/>
								<attdabsnflag4/>
								<attdabsnflag5/>
							</voluntrindachivinfo>
						</voluntrindachivlist>
					</main>
					<hidden>
						<init>
							<comcd/>
						</init>
					</hidden>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
						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="TRZBC00105" mediatype="application/x-www-form-urlencoded" method="post"/>
			<submission id="TRAAA01001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" resultref="/root/main/voluntrindachivlist"/>
		</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"/>
	</xhtml:head>
	<script type="javascript">
		<![CDATA[
		
				function fInit()
				{
						
						zbcfGetCodeList( new Array("A0360","A0359","A0504","A0503"),  
						new Array("/root/hidden/init/comcd","/root/hidden/init/comcd","/root/hidden/init/comcd","/root/hidden/init/comcd"));           //  관계코드 설정   
						
						var CurrentDate=getCurrentDate();  //현재 일자
						var CurrentYYMM=CurrentDate.substr(0,6); //현재 년월 저장 
						model.makeValue("/root/main/search/fromdd",CurrentYYMM);
						model.makeValue("/root/main/search/todd",CurrentYYMM);
						model.makeValue("/root/main/search/actdeptcd","01");
						//model.makeValue("/root/main/search/voluntractdwcd","2");
						//model.makeValue("/root/main/search/voluntractteamcd","1");
						model.removeNodeset("/root/main/voluntrindachivlist/voluntrindachivinfo");
						
						addComboItem("cmb_voluntractdwcd","","","above");
						addComboItem("cmb_voluntractteamcd","","","above");
						
						model.refresh();				
				}
				// 실적 조회 함수 
				function fVoluntrIndAchivReq()
				{
					model.removeNodeset("/root/send/reqdata");
					model.makeNode("/root/send/reqdata");
					
					var fromdd=model.getValue("/root/main/search/fromdd");
					var todd=model.getValue("/root/main/search/todd");
					var actdeptcd=model.getValue("/root/main/search/actdeptcd");
					var voluntractdwcd=model.getValue("/root/main/search/voluntractdwcd");
					var voluntractteamcd=model.getValue("/root/main/search/voluntractteamcd");
					
					var dateintval=getDateInterval(fromdd+"01",todd+"31");
					// 조회종료일자와 조회시작일자사이의 길이, 3개월을 넘지 못하게 제약한다. 
					//alert(dateintval);
					if(fromdd>todd)
					{
						messageBox("조회 시작일자보다 큰 조회 종료일자를 입력하십시요.","I");
						model.setFocus("ipt_todd");
						return;
					}
					if(dateintval>"396")
					{
						messageBox("조회기간은 1년을 넘을 수 ","I004");
						model.setFocus("ipt_todd");
						return;
					}
					else
					{
						model.makeValue("/root/send/reqdata/fromdd",fromdd);
						model.makeValue("/root/send/reqdata/todd",todd);
						
					}
					if(isNull(voluntractdwcd))
					{
						model.makeValue("/root/send/reqdata/voluntractdwcd","%");
					}
					else
					{
						model.makeValue("/root/send/reqdata/voluntractdwcd",model.getValue("/root/main/search/voluntractdwcd"));
					}
					if(isNull(voluntractteamcd))
					{
						model.makeValue("/root/send/reqdata/voluntractteamcd","%");
					}
					else
					{
						model.makeValue("/root/send/reqdata/voluntractteamcd",model.getValue("/root/main/search/voluntractteamcd"));
					}
					
					model.makeValue("/root/send/reqdata/actdeptcd",model.getValue("/root/main/search/actdeptcd"));
					//alert(dateintval);
					
					/*if(fromdd!=todd)
					{
						messageBox("조회시작일자와 같은 조회종료일자를 입력하십시요.","I");
						model.setFocus("ipt_todd");
						return;
					}*/
					var fromdd=ipt_fromdd.currentText;  // 조회시작일자
					var fromddyy=fromdd.substr(0,4);	  // 조회시작년도
					var fromddlastyy=fromddyy-1;		  // 조회종료년도의 전년도 
					
					var fromddmth=fromdd.substr(5,2);   // 조회시작월
					var fromlstmth=eval(fromddmth-1);	  // 조회시작전월
					//alert(fromlstmth);
					if(fromlstmth=="00")
					{
						model.makeValue("/root/send/reqdata/fromlstdd",fromddlastyy+"12"); //봉사월이 1월일때 전월은 작년 12월로 셋팅 
					}
					else if(fromlstmth>="01"&&fromlstmth<="9")
					{
						model.makeValue("/root/send/reqdata/fromlstdd",fromddyy+"0"+fromlstmth); //봉사월이 2월부터 10월일때는 현재년도+"01~09"로 셋팅 
					}
					else
					{
						model.makeValue("/root/send/reqdata/fromlstdd",fromddyy+fromlstmth);   //봉사월이 11,12월일때는 10,11월 셋팅 
					}
					
					//model.copyNode("/root/send/reqdata","/root/main/search");
					if(submit("TRAAA01001")==true)
					{
						model.setFocus("caption1");
					}
					//submit("TRAAA01001");
					
					/*var idxRows=grd_voluntrindachivinfo.rows;
					var idxFixedRow=grd_voluntrindachivinfo.fixedRows;
					
					for(i=1;i<=idxRows-idxFixedRow;i++)
					{
						var lstmnthservtm=model.getValue("/root/main/voluntrindachivlist/voluntrindachivinfo"+"["+i+"]/lstmnthservtm");
						var  servtm=model.getValue("/root/main/voluntrindachivlist/voluntrindachivinfo"+"["+i+"]/servtm");

						model.makeValue("/root/main/voluntrindachivlist/voluntrindachivinfo"+"["+i+"]/totalservtm",eval(lstmnthservtm)+ eval(servtm));
							
						model.refresh();
					}*/
				     
					
					model.refresh();
				}
				//엑셀 저장 함수 
				function fSaveExcel()
				{
					var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
						
						if (fileName != "")
						{
							grd_voluntrindachivinfo.saveExcel(fileName, "SheetName", false, false, "", "", false);
						}
				}
				
				//초기화 함수
				function fVoluntrIndAchivReSet()
				{
					var btn=messageBox("초기화를","Q004");
					if(btn=="6")
					{
						model.removeNodeset("/root/main/voluntrindachivlist");
						model.refresh();
					}
					else
					{
						return;
					}	
				}
		
	    ]]>
	</script>
	<xhtml:body guideline="1,1194;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:181px; height:14px; ">자원봉사자개인별실적조회</caption>
		</group>
		<group id="group3" scroll="auto" style="left:0px; top:13px; width:1195px; height:744px; ">
			<group id="grp_sea" style="left:0px; top:10px; width:1194px; height:35px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1194px; height:35px; "/>
				<button id="button1" class="btn1_letter2" style="left:1123px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
								fVoluntrIndAchivReq();
						]]>
					</script>
				</button>
				<line id="line13" class="line_4" style="x1:1107px; y1:7px; x2:1107px; y2:29px; "/>
				<caption id="caption3" class="search_name" style="left:20px; top:10px; width:94px; height:17px; ">조회기간 :</caption>
				<caption id="caption5" class="search_no_b" style="left:193px; top:10px; width:12px; height:17px; ">~</caption>
				<input id="ipt_todd" ref="/root/main/search/todd" class="input_search" navindex="2" inputtype="date" format="yyyy-mm" style="left:215px; top:10px; width:70px; height:19px; "/>
				<input id="ipt_fromdd" ref="/root/main/search/fromdd" class="input_search" navindex="1" inputtype="date" format="yyyy-mm" style="left:115px; top:10px; width:70px; height:19px; "/>
				<caption id="caption2" class="search_name" style="left:375px; top:10px; width:100px; height:17px; ">활동그룹 :</caption>
				<caption id="caption4" class="search_name" style="left:650px; top:10px; width:127px; height:17px; ">활동요일/시간대:</caption>
				<select1 id="cmb_voluntractdwcd" ref="/root/main/search/voluntractdwcd" class="combo_search" disabled="false" navindex="4" appearance="minimal" style="left:785px; top:9px; width:65px; height:19px; ">
					<choices>
						<itemset nodeset="/root/hidden/init/comcd/A0359">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
								fVoluntrIndAchivReq();				
						]]>
					</script>
				</select1>
				<select1 id="cmb_voluntractteamcd" ref="/root/main/search/voluntractteamcd" class="combo_search" navindex="5" appearance="minimal" style="left:860px; top:9px; width:90px; height:19px; ">
					<choices>
						<itemset nodeset="/root/hidden/init/comcd/A0360">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
								fVoluntrIndAchivReq();				
						]]>
					</script>
				</select1>
				<select1 id="cmb_posteam2" ref="/root/main/search/actdeptcd" class="combo_search" navindex="3" appearance="minimal" style="left:468px; top:9px; width:90px; 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[
								fVoluntrIndAchivReq();				
						]]>
					</script>
				</select1>
			</group>
			<datagrid id="grd_voluntrindachivinfo" nodeset="/root/main/voluntrindachivlist/voluntrindachivinfo" caption="활동그룹^활동시간대^활동요일^성명^번호^본명^직책^입단일^탈단일^전월누계^당월계^총시간계^출석^대근^결석^휴가^병가" colsep="^" colwidth="80, 76, 61, 97, 72, 97, 72, 77, 77, 74, 48, 76, 50, 50, 50, 50, 50" dataheight="25" explorerbar="sort" extendlastcol="scroll" frozencols="9" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:76px; width:1194px; height:665px; ">
				<col disabled="true" ref="actdeptcd" type="combo">
					<choices>
						<itemset nodeset="/root/hidden/init/comcd/A0503">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</col>
				<col disabled="true" ref="voluntractteamcd" type="combo" style="text-align:center; ">
					<choices>
						<itemset nodeset="/root/hidden/init/comcd/A0360">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</col>
				<col disabled="true" ref="voluntractdwcd" type="combo" style="text-align:center; ">
					<choices>
						<itemset nodeset="/root/hidden/init/comcd/A0359">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</col>
				<col ref="voluntrnm"/>
				<col ref="voluntrid" style="text-align:center; "/>
				<col ref="baptnm"/>
				<col disabled="true" ref="jobrespcd">
					<choices>
						<itemset nodeset="/root/hidden/init/comcd/A0504">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</col>
				<col ref="joinorgdd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="quitorgdd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="lstmnthservtm" format="#,###.9" style="text-align:right; "/>
				<col ref="servtm" format="#,###.9" style="text-align:right; "/>
				<col ref="totalservtm" format="#,###.9" style="text-align:right; "/>
				<col ref="attdabsnflag1" format="#,###" style="text-align:center; "/>
				<col ref="attdabsnflag2" format="#,###" style="text-align:center; "/>
				<col ref="attdabsnflag3" format="#,###" style="text-align:center; "/>
				<col ref="attdabsnflag4" format="#,###" style="text-align:center; "/>
				<col ref="attdabsnflag5" format="#,###" style="text-align:center; "/>
			</datagrid>
			<button id="button14" class="btn2_letter4" style="left:1121px; top:50px; width:64px; height:19px; text-align:right; ">
				<caption>액셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						//엑셀 저장 함수 
						fSaveExcel();

					]]>
				</script>
			</button>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:757px; width:1195px; height:27px; ">
			<line id="line37" class="line_6" style="x1:0px; y1:0px; x2:1194px; y2:0px; "/>
		</group>
		<caption id="caption1" class="tit_2" style="left:5px; top:71px; width:186px; height:14px; ">자원봉사자개인별실적리스트</caption>
		<line id="line1" class="line_1" style="x1:0px; y1:86px; x2:1194px; y2:86px; "/>
		<button id="btn_delete" class="btn4_letter3" style="left:1121px; top:760px; width:68px; height:22px; ">
			<caption>초기화</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						fVoluntrIndAchivReSet();
					]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>