YNU_JEUS/app_home/himed/webapps/sts/stscmcnwweb/xrw/SMSDT03000_사회사업협의진료실적.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목   : SMSDT03000.사회사업 협의진료실적.xrw
	* 설    명   : 사회사업 협의진료실적
	* 작 성 자  : 김다영
	* 작 성 일  : 2008.09.16
	* 수정이력 : 
	* 기    타   : 
-->
<?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>
						<cnstinfo>
							<cnstlist>
								<cdnm/>
								<reqcnt/>
								<replcnt/>
								<avgrate/>
								<avgdayno/>
								<bfreqcnt/>
								<bfreplcnt/>
								<bfavgrate/>
								<bfavgdayno/>
								<comparereqcnt/>
								<comparereplcnt/>
								<comparereplper/>
								<comparerepldayno/>
							</cnstlist>
						</cnstinfo>
						<cond>
							<fromdd/>
							<todd/>
							<flag>2</flag>
						</cond>
					</main>
					<send>
						<reqdata>
						</reqdata>
					</send>
					<init/>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
			<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
			<script type="javascript" src="../../../ast/commonweb/js/AST.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[					
					fInit();					
				]]>
			</script>
			<submission id="TRSDT03001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/cnstinfo"/>
		</model>
		<script type="javascript">
			<![CDATA[
/**========================================================================================================================================
* 조회기간 그리드초기화
=========================================================================================================================================*/	
				function fInit(){
						
							
					model.removeNodeset("/root/main/cnstinfo/cnstlist");
					cmb_sumflag.select(0);	
					
					var currentDate = getCurrentDate();
					var LastDate=currentDate.toDate().getAddDate(-1,"M").getDateFormat();
					var LastDateYM=LastDate.substr(0,6);
					model.setValue("/root/main/cond/fromdd"	,LastDateYM );					
	               	model.setValue("/root/main/cond/todd"   	,LastDateYM );	               		
						               			               		
					// 그리드초기화
					model.removeNodeset(grd_cnst.nodeset);	
								
					model.refresh();
				}			
/**========================================================================================================================================
*  조회 
=========================================================================================================================================*/		
				function fGetSoclConfCnstInfo(){
					var fromdd = model.getValue("/root/main/cond/fromdd") +"01";
					var todd     = model.getValue("/root/main/cond/todd")+ "01";				
					var dateintval=getDateInterval(fromdd,todd);
					var fdate = model.getValue("/root/main/cond/fromdd");
					var todate     = model.getValue("/root/main/cond/todd");	
					//alert(dateintval);
					
					 if(isNull(fdate))
					{
						messageBox("조회시작일자는","I003");
						model.setFocus("ipt_fromdd");
						return;
					}
					if(isNull(todate))
					{
						messageBox("조회종료일자는","I003");
						model.setFocus("ipt_todd");
						return;
					}
					if(fdate>todate)
					{
						messageBox("조회시작일보다 큰 조회종료일을 입력하십시요.","I");
						model.setFocus("ipt_todd");
						return;
					}
						
					if(dateintval>=365)
					{
						messageBox("조회기간은 최대1년까지 할 수 있습니다.","I");
						model.setFocus("ipt_todd");
						return;
					}
					
					if(cmb_sumflag.value == '1'){
							grd_cnst.colHidden(5) 	= true;
							grd_cnst.colHidden(6) 	= true;
							grd_cnst.colHidden(7) 	= true;
							grd_cnst.colHidden(8) 	= true;
							grd_cnst.colHidden(9) 	= true;
							grd_cnst.colHidden(10) 	= true;
							grd_cnst.colHidden(11) 	= true;
							grd_cnst.colHidden(12) 	= true;
							grd_cnst.colHidden(13) 	= true;
							
					model.removeNodeset("/root/send/reqdata");
					model.makeNode("/root/send/reqdata");
					model.copyNode("/root/send/reqdata", "/root/main/cond");
					
					submit("TRSDT03001");
					//fSum() ;
				
						
					}
					else if(cmb_sumflag.value == '2'){
						    grd_cnst.colHidden(5) 	= false; 
							grd_cnst.colHidden(6) 	= false;
							grd_cnst.colHidden(7) 	= false;
							grd_cnst.colHidden(8) 	= false;
							grd_cnst.colHidden(9) 	= false;
							grd_cnst.colHidden(10) 	= false;
							grd_cnst.colHidden(11) 	= false;
							grd_cnst.colHidden(12) 	= false;
							grd_cnst.colHidden(13) 	= false;
							
					model.removeNodeset("/root/send/reqdata");
					model.makeNode("/root/send/reqdata");
					model.copyNode("/root/send/reqdata", "/root/main/cond");
					
					submit("TRSDT03001");
					fStat();
						
					//데이터가없을때 return 
					if (model.instances(0).selectNodes("/root/main/cnstinfo/cnstlist").length == 0){
						return;
					}
			
				}
			
					
/**========================================================================================================================================
* 합계
=========================================================================================================================================*/					
				function fSum() {	
					
					//데이터가없을때 return 
					if (model.instances(0).selectNodes("/root/main/cnstinfo/cnstlist").length == 0){
						return;
					}
					//합계계산
					var insRow = grd_cnst.rows ;
					grd_cnst.addRow(insRow,  false);
					grd_cnst.valueMatrix(insRow, grd_cnst.colRef("cdnm")) =  "합계";
					for(var i = grd_cnst.colRef("reqcnt") ; i <= grd_cnst.colRef("comparereplper") ; i++){
						var sSum = 0 ;
						for(var j = grd_cnst.fixedRows ; j < eval(grd_cnst.rows-1) ; j++){
							sSum += eval(grd_cnst.valueMatrix(j, i));			
						}
						grd_cnst.valueMatrix(insRow, i) = sSum;	
					}
					model.refresh();
				}

/**========================================================================================================================================
* 전년대비실적비교
=========================================================================================================================================*/					
				function fStat() {	
					
					//데이터가없을때 return 
					if(grd_cnst.rows - grd_cnst.fixedRows >1){
					var val = model.getValue("/root/main/cnstinfo/cnstlist/cdnm");
					if(isNull(val) == true) return;  
					
					//전년대비실적비교계산
					if(grd_cnst.rows - grd_cnst.fixedRows >1){
						var sStat = 0;
						var insRow = grd_cnst.rows;
						grd_cnst.addRow(insRow, false);
						grd_cnst.valueMatrix(insRow, grd_cnst.colRef("cdnm") ) = "전기간대비실적비교";
							
						for(var i= grd_cnst.colRef("reqcnt"); i<= grd_cnst.colRef("avgdayno"); i++){
							var bfResult = eval(grd_cnst.valueMatrix(insRow -1 , i));												
							var sSum = eval(grd_cnst.valueMatrix(insRow-2, i));		
																											
							sStat = eval(sSum)- eval(bfResult) ;							
							grd_cnst.valueMatrix(insRow, i ) = eval(sStat);								
							}					
						}
					}else{
					model.removeNodeset("/root/main/cnstinfo/cnstlist");		
					}
					model.refresh();
				}


/**========================================================================================================================================
* 엑셀저장 버튼 클릭시
=========================================================================================================================================*/					
				function fExcel() {
					if (grd_cnst.rows <= 1) {
						messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
						return;
					}
					
					var fileName = window.fileDialog("save", ",", false, "사회사업협의진료실적", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");  
					if (fileName != ""){
						 grd_cnst.saveExcel(fileName, "SheetName", false, false, "", "", false);
					}
				}
			}
			
				
					
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1195;1,1191;" 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:224px; height:14px; ">사회사업 협의진료 실적조회</caption>
		</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; "/>
			<button id="btn_search0" class="btn4_letter3" style="left:1126px; top:5px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fInit();
					]]>
				</script>
			</button>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:13px; width:1195px; height:744px; ">
			<caption id="caption21" class="tit_2" style="left:0px; top:55px; width:195px; height:14px; ">사회사업 협의진료 실적</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:73px; x2:1190px; y2:72px; "/>
			<group id="group4" style="left:0px; top:5px; width:1194px; height:35px; vertical-align:top; ">
				<shape id="roundrect3" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1194px; height:35px; "/>
				<button id="button2" class="btn1_letter2" navindex="4" style="left:1123px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fGetSoclConfCnstInfo();					
						]]>
					</script>
				</button>
				<caption id="caption23" class="search_name" style="left:15px; top:10px; width:86px; height:17px; ">조회구분 :</caption>
				<line id="line2" style="x1:1113px; y1:7px; x2:1113px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="cap1" style="left:430px; top:8px; width:25px; height:20px; text-align:center; ">~</caption>
				<input id="ipt_fromdd" ref="/root/main/cond/fromdd" class="input_search" navindex="2" inputtype="date" format="yyyy-mm" style="left:332px; top:8px; width:100px; height:19px; "/>
				<input id="ipt_todd" ref="/root/main/cond/todd" class="input_search" navindex="3" inputtype="date" format="yyyy-mm" style="left:455px; top:8px; width:100px; height:19px; "/>
				<caption id="caption1" class="search_name" style="left:240px; top:10px; width:100px; height:17px; ">조회기간 :</caption>
				<select1 id="cmb_sumflag" ref="/root/main/cond/flag" navindex="1" appearance="minimal" style="left:110px; top:10px; width:110px; height:19px; ">
					<choices>
						<item>
							<label>월별</label>
							<value>2</value>
						</item>
						<item>
							<label>업무분야별</label>
							<value>1</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							fGetSoclConfCnstInfo();	
						]]>
					</script>
				</select1>
			</group>
			<button id="btn_excel" class="btn2_letter4" navindex="5" style="left:1127px; top:51px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fExcel();
					]]>
				</script>
			</button>
			<datagrid id="grd_cnst" nodeset="/root/main/cnstinfo/cnstlist" class="datagrid2" caption="구분^ 사회사업         협진의뢰 건수^  사회사업         협진회신 건수^    사회사업       협진회신율^사회사업          협진평균 회신일^전월실적^전월실적^전월실적^전월실적^전월대비실적비교^전월대비실적비교^전월대비실적비교^전월대비실적비교^전월대비실적비교^장소^장소^장소^장소명^장소^담당자|구분^ 사회사업         협진의뢰 건수^  사회사업         협진회신 건수^    사회사업       협진회신율^사회사업          협진평균 회신일^협진의뢰건수^협진회신건수^협진회신율^협진평균회신일^협진의뢰건수^협진회신건수^협진회신율^협진평균회신일^협진의뢰평균회신일^장소^장소^장소^장소명^장소^담당자|구분^ 사회사업         협진의뢰 건수^  사회사업         협진회신 건수^    사회사업       협진회신율^사회사업          협진평균 회신일^협진의뢰건수^협진회신건수^협진회신율^협진평균회신일^협진의뢰건수^협진회신건수^협진회신율^협진평균회신일^협진의뢰평균회신일^장소^장소^장소^장소명^장소^담당자" colsep="^" colwidth="160, 90, 90, 90, 95, 80, 80, 80, 89, 80, 80, 80, 90" dataheight="25" mergecellsfixedrows="bycolrec" rowheight="25" rowsep="|" style="left:1px; top:76px; width:1190px; height:664px; text-align:center; ">
				<col ref="cdnm" format="yyyy-mm" style="text-align:center; "/>
				<col ref="reqcnt" style="text-align:center; "/>
				<col ref="replcnt" style="text-align:center; "/>
				<col ref="avgrate" style="text-align:center; "/>
				<col ref="avgdayno" style="text-align:center; "/>
				<col ref="bfreqcnt" style="text-align:center; "/>
				<col ref="bfreplcnt" style="text-align:center; "/>
				<col ref="bfavgrate" style="text-align:center; "/>
				<col ref="bfavgdayno" style="text-align:center; "/>
				<col ref="comparereqcnt" style="text-align:center; "/>
				<col ref="comparereplcnt" style="text-align:center; "/>
				<col ref="comparereplper" style="text-align:center; "/>
				<col ref="comparerepldayno" style="text-align:center; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>