YNU_JEUS/app_home/himed/webapps/com/projprcsweb/xrw/SMZTP00901_프로젝트진척관리(개인별공정율조회).xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
<?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>
						<projlist>
							<list>
								<proj>
									<subteam/>
									<dev/>
									<usernm/>
									<funccnt/>
									<viewcnt/>
									<reptcnt/>
									<quota/>
									<funcficnt/>
									<viewficnt/>
									<reptficnt/>
									<quotafi/>
									<quotafiper/>
									<funcrmcnt/>
									<viewrmcnt/>
									<reptrmcnt/>
								</proj>
							</list>
						</projlist>
					</main>
					<send>
						<search>
							<appdd/>
							<subteam/>
							<endrate/>
							<acptdd/>
							<prcsyn/>
							<posinstcd/>
						</search>
					</send>
					<init>
						<endrate>
							<item>
								<name>80</name>
								<id>80</id>
							</item>
							<item>
								<name>100</name>
								<id>100</id>
							</item>
						</endrate>
						<prcsyn>
							<item>
								<name>전체</name>
								<id>-</id>
							</item>
							<item>
								<name>Y</name>
								<id>Y</id>
							</item>
							<item>
								<name>N</name>
								<id>N</id>
							</item>
						</prcsyn>
						<posinstcd>
							<item>
								<name>전체</name>
								<id>-</id>
							</item>
							<item>
								<name>HIT</name>
								<id>H</id>
							</item>
							<item>
								<name>평화IS</name>
								<id>P</id>
							</item>
						</posinstcd>
					</init>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					model.removeNodeset("/root/main/projlist/list/proj");		
					
					// 업무팀,적용기준일 리스트를 가져 와서 콤보 박스에 뿌려 준다.
					// 적용 기준일의 경우 조건 검색시 null을 제외 했기 때문에 전체 건수와 차이가 난다.
					submit("TRZTP00802");
					submit("TRZTP00902");			
					
					addComboItem("combo1", "-전체-", "-", "above");
					addComboItem("combo2", "-전체-", "-", "above");
										
					
					combo1.select(0);
					combo2.select(0);
					combo3.select(1);
					combo4.select(0);
					combo5.select(1);
					var today = getCurrentDate();
					var masktoday = today.substr(0, 4) + "-" + today.substr(4, 2) + "-" + today.substr(6, 2);
					model.setValue("/root/send/search/acptdd", masktoday);
					model.refresh();							
				]]>
			</script>
			<submission id="TRZTP00802" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search/appdd" resultref="/root/temp"/>
			<submission id="TRZTP00911" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/main/projlist/list"/>
			<submission id="TRZTP00902" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/subtemp"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../commonweb/js/dateHelper.js"/>
	</xhtml:head>
	<xhtml:body guideline="1,1195;2,782;" 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="caption1" class="tit_1" style="left:0px; top:0px; width:250px; height:13px; ">프로젝트진척관리(개인별공정율조회)</caption>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:45px; width:1195px; height:730px; ">
			<group id="group6" style="left:0px; top:10px; width:1194px; height:35px; vertical-align:top; ">
				<shape id="roundrect3" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1194px; height:35px; "/>
				<line id="line18" class="line_4" style="x1:1090px; y1:5px; x2:1090px; y2:27px; border-left-style:solid; "/>
				<button id="button1" class="btn1_letter2" style="left:1115px; top:7px; width:56px; height:22px; background-image:../../../com/commonweb/images/btn1_letter2.gif; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							submit("TRZTP00911");
							
							// 할당량 합계, 완료건수 합계/합계(%) 입력
							for (i=grd_projlist.fixedRows; i<grd_projlist.rows; i++)
							{
								grd_projlist.textmatrix(i,7) =  parseInt(grd_projlist.textmatrix(i,4)) +  parseInt(grd_projlist.textmatrix(i,5)) + parseInt(grd_projlist.textmatrix(i,6)); 
								grd_projlist.textmatrix(i,11) = parseInt(grd_projlist.textmatrix(i,8)) +  parseInt(grd_projlist.textmatrix(i,9)) + parseInt(grd_projlist.textmatrix(i,10)); 
								grd_projlist.textmatrix(i,12) = grd_projlist.textmatrix(i,11) / grd_projlist.textmatrix(i,7) * 100;
								grd_projlist.cellStyle("background-color", i, 7) = "#FFFDBF";
								grd_projlist.cellStyle("background-color", i, 11) = "#FFFDBF";
								grd_projlist.cellStyle("background-color", i, 12) = "#D0FFD0";
							}
														
							// 잔여 건수 입력,TF에서 계산 함.
							for (i=grd_projlist.fixedRows; i<grd_projlist.rows; i++)
							{
								grd_projlist.textmatrix(i, 13) = grd_projlist.textmatrix(i, 4) - grd_projlist.textmatrix(i, 8);
								grd_projlist.textmatrix(i, 14) = grd_projlist.textmatrix(i, 5) - grd_projlist.textmatrix(i, 9)
								grd_projlist.textmatrix(i, 15) = grd_projlist.textmatrix(i, 6) - grd_projlist.textmatrix(i, 10);
							}
							
							// 총계,소계 입력								
							// 최상단에 출력				
							grd_projlist.subtotalposition="above";
														
							// 총계를 내기 위해 계산할 그룹을 -1로 잡는다.
							grd_projlist.subtotal("sum", -1, 4, "#,###", "background-color:#FFD9B3 ", 1, "총계", true);	
							grd_projlist.subtotal("sum", -1, 5, "#,###", "background-color:#FF99FF ", 1, "총계", true);					
							grd_projlist.subtotal("sum", -1, 6, "#,###", "background-color:#FF99FF ", 1, "총계", true);	
							grd_projlist.subtotal("sum", -1, 7, "#,###", "background-color:#FF99FF ", 1, "총계", true);									
							grd_projlist.subtotal("sum", -1, 8, "#,###", "background-color:#FF99FF ", 1, "총계", true);
							grd_projlist.subtotal("sum", -1, 9, "#,###", "background-color:#FF99FF ", 1, "총계", true);	
							grd_projlist.subtotal("sum", -1, 10, "#,###", "background-color:#FF99FF ", 1, "총계", true);			
							grd_projlist.subtotal("sum", -1, 11, "#,###", "background-color:#FF99FF ", 1, "총계", true);	
							grd_projlist.subtotal("sum", -1, 12, "###%", "background-color:#FF99FF ", 1, "총계", true);	
							grd_projlist.subtotal("sum", -1, 13, "#,###", "background-color:#FF99FF ", 1, "총계", true);
							grd_projlist.subtotal("sum", -1, 14, "#,###", "background-color:#FF99FF ", 1, "총계", true);	
							grd_projlist.subtotal("sum", -1, 15, "#,###", "background-color:#FF99FF ", 1, "총계", true);		
							
							grd_projlist.subtotalposition="below";						
							// subteam별로 그룹을 준다.
							grd_projlist.subtotal("sum", 1, 4, "#,###", "background-color:#FF99FF ", 1, "소계", true);		
							grd_projlist.subtotal("sum", 1, 5, "#,###", "background-color:#E294DF ", 1, "소계", true);											
							grd_projlist.subtotal("sum", 1, 6, "#,###", "background-color:#E294DF ", 1, "소계", true);		
							grd_projlist.subtotal("sum", 1, 7, "#,###", "background-color:#E294DF ", 1, "소계", true);
							grd_projlist.subtotal("sum", 1, 8, "#,###", "background-color:#E294DF ", 1, "소계", true);
							grd_projlist.subtotal("sum", 1, 9, "#,###", "background-color:#E294DF ", 1, "소계", true);		
							grd_projlist.subtotal("sum", 1, 10, "#,###", "background-color:#E294DF ", 1, "소계", true);					
							grd_projlist.subtotal("sum", 1, 11, "#,###", "background-color:#E294DF ", 1, "소계", true);
							grd_projlist.subtotal("sum", 1, 12, "###%", "background-color:#E294DF ", 1, "소계", true);
							grd_projlist.subtotal("sum", 1, 13, "#,###", "background-color:#E294DF ", 1, "소계", true);
							grd_projlist.subtotal("sum", 1, 14, "#,###", "background-color:#E294DF ", 1, "소계", true);
							grd_projlist.subtotal("sum", 1, 15, "#,###", "background-color:#E294DF ", 1, "소계", true);
							
							
							var rows = grd_projlist.rows;						
							var i;
							
							//  소계, 총계 퍼센트 구하기 (따로 계산해 줘야 한다)
							for(i = 1; i <= rows; i++){
								if(grd_projlist.textmatrix(i, 1) == "소계" || grd_projlist.textmatrix(i, 1) == "총계"){
									
									if(grd_projlist.textmatrix(i,  7) == 0){
									// 화면수가 0 이면 분모가 0이 되므로 0을 넣는다
										 grd_projlist.textmatrix(i, 12) = 0; 										
									}else{			// 소계, 총계의 완료율 구하기																			
										grd_projlist.textmatrix(i,12) = grd_projlist.textmatrix(i,11) / grd_projlist.textmatrix(i,7) * 100;		// 완료건수 / 화면수																
									
									}
														
								}
							}
							
							// 숫자 컬럼들은 오른쪽 정렬
							for (var i = 4; i <= 15; i++){
								grd_projlist.colstyle(i, "data", "text-align") = "right";	
							}				
															
						]]>
					</script>
				</button>
				<caption id="caption2" class="search_name" style="left:6px; top:8px; width:64px; height:17px; ">업무팀</caption>
				<select1 id="combo2" ref="/root/send/search/subteam" class="combo_search" appearance="minimal" style="left:75px; top:7px; width:109px; height:19px; ">
					<choices>
						<itemset nodeset="/root/subtemp/combo">
							<label ref="subteam"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption3" class="search_name" style="left:196px; top:8px; width:89px; height:17px; ">적용기준일</caption>
				<select1 id="combo1" ref="/root/send/search/appdd" class="combo_search" appearance="minimal" style="left:287px; top:7px; width:85px; height:19px; ">
					<choices>
						<itemset nodeset="/root/temp/combo">
							<label ref="appdd"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption6" class="search_name" style="left:380px; top:8px; width:90px; height:17px; ">완료 비율</caption>
				<select1 id="combo5" ref="/root/send/search/endrate" class="combo_search" appearance="minimal" style="left:465px; top:7px; width:65px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/endrate/item">
							<label ref="name"/>
							<value ref="id"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption7" class="search_name" style="left:541px; top:8px; width:80px; height:17px; ">접수일</caption>
				<input id="input1" ref="/root/send/search/acptdd" class="input_serarch" inputtype="date" mask="include" style="left:611px; top:7px; width:100px; height:19px; "/>
				<caption id="caption4" class="search_name" style="left:720px; top:8px; width:125px; height:17px; ">공정율 적용여부</caption>
				<select1 id="combo3" ref="/root/send/search/prcsyn" class="combo_search" appearance="minimal" style="left:845px; top:7px; width:52px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/prcsyn/item">
							<label ref="name"/>
							<value ref="id"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption9" class="search_name" style="left:906px; top:8px; width:94px; height:17px; ">개발자 소속</caption>
				<select1 id="combo4" ref="/root/send/search/posinstcd" class="combo_search" appearance="minimal" style="left:1005px; top:7px; width:70px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/posinstcd/item">
							<label ref="name"/>
							<value ref="id"/>
						</itemset>
					</choices>
				</select1>
			</group>
			<line id="line20" class="line_1" style="x1:0px; y1:81px; x2:1194px; y2:81px; "/>
			<caption id="caption8" class="tit_2" style="left:5px; top:66px; width:195px; height:13px; ">프로젝트 진척관리 완료내역</caption>
			<group id="group2" style="left:800px; top:55px; width:395px; height:25px; ">
				<button id="button3" class="btn2_letter4" disable.background-image="../../../com/commonweb/images/dis_btn2_letter4.gif" style="left:325px; top:5px; width:64px; height:19px; background-image:../../../com/commonweb/images/btn2_letter4.gif; ">
					<caption>엑셀저장</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							var fileName = window.fileDialog("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
		
							if (fileName != "")
							{
								grd_projlist.saveExcel(fileName);
							}
						]]>
					</script>
				</button>
			</group>
			<datagrid id="grd_projlist" nodeset="/root/main/projlist/list/proj" caption="SUBTEAM^개인별^개인별^할당량^할당량^할당량^할당량^완료건수^완료건수^완료건수^완료건수^완료건수^잔여건수^잔여건수^잔여건수|SUBTEAM^ID^NAME^기능^화면^보고서^소계^기능^화면^보고서^소계^완료율(%)^기능^화면^보고서" colsep="^" colwidth="173, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70" dataheight="23" defaultrows="0" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="23" rowsep="|" tooltip="true" style="left:0px; top:85px; width:1195px; height:640px; ">
				<col ref="subteam"/>
				<col ref="dev"/>
				<col ref="usernm"/>
				<col ref="funccnt" format="#,###"/>
				<col ref="viewcnt" format="#,###"/>
				<col ref="reptcnt" format="#,###"/>
				<col ref="quota" format="#,###"/>
				<col ref="funcficnt" format="#,###"/>
				<col ref="viewficnt" format="#,###"/>
				<col ref="reptficnt" format="#,###"/>
				<col ref="quotafi" format="#,###"/>
				<col ref="quotafiper" format="###%"/>
				<col ref="funcrmcnt" format="#,###"/>
				<col ref="viewrmcnt" format="#,###"/>
				<col ref="reptrmcnt" format="#,###"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[							
						// 데이터 컬럼이 아니라면 실행 하지 않는다. isDataCell 공통 함수
						// 컬럼헤드, 총계, 소계 일 경우 실행하지 않는다. 		
						if( isDataCell() )
						{				
							if (grd_projlist.textmatrix(grd_projlist.row,1) != "총계" && grd_projlist.textmatrix(grd_projlist.row,1) != "소계" 	 && grd_projlist.row > 1)
								modal("SPZTP01100", "1", "100", "100", "SPZTP01100", "", "", "left:100; top:100; width:1200; height:650; sysmenu:visible; min:visible; max:true; resize:true; caption:visible;" , false);										
						}
					]]>
				</script>
			</datagrid>
		</group>
		<group id="group3" style="left:0px; top:13px; width:1190px; height:27px; ">
			<button id="button7" class="btn4_letter3" disable.background-image="../../../com/commonweb/images/dis_btn4_letter3.gif" style="left:1120px; top:2px; width:68px; height:22px; background-image:../../../com/commonweb/images/btn4_letter3.gif; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.removeNodeset("/root/main/projlist/list/proj");
						model.resetInstanceNode("/root/send");
						//model.resetInstanceNode("/root/main/item");				
						
						combo2.select(0);
						combo1.select(0);
						combo3.select(1);
						combo4.select(0);
						combo5.select(1);
						var today = getCurrentDate();
						var masktoday = today.substr(0, 4) + "-" + today.substr(4, 2) + "-" + today.substr(6, 2);
						model.setValue("/root/send/search/acptdd", masktoday);
						model.refresh();								 	
					]]>
				</script>
			</button>
			<line id="line1" class="line_6" style="x1:0px; y1:25px; x2:1189px; y2:25px; "/>
		</group>
	</xhtml:body>
</xhtml:html>