YNU_JEUS/app_home/himed/webapps/sts/stscmcnwweb/xrw/SMSDT04000_사회사업협의뢰및회신실적.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목   : SMSDT04000.사회사업협진의뢰및회신실적.xrw
	* 설    명   : 사회사업협진의뢰및회신실적
	* 작 성 자  : 김다영
	* 작 성 일  : 2008.09.17
	* 수정이력 : 
	* 기    타   : 
-->
<?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>
						<cnstinfo>
							<cnstlist>
								<dispseq/>
								<cdnm/>
								<usernm/>
								<userdispseq/>
								<reqcnt1/>
								<replcnt1/>
								<reqcnt2/>
								<replcnt2/>
								<reqcnt3/>
								<replcnt3/>
								<reqcnt4/>
								<replcnt4/>
								<reqcnt5/>
								<replcnt5/>
								<reqtot/>
								<repltot/>
								<bfreqcnt/>
								<bfreplcnt/>
								<bfreqcntconsult/>
								<bfreplcntreply/>
							</cnstlist>
						</cnstinfo>
						<cond>
							<fromdd/>
							<todd/>
							<sumflag>1</sumflag>
						</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="TRSDT04001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/cnstinfo"/>
			<submission id="TRSDT04002" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/cnstinfo"/>
			<bind id="bfreqcntconsult" ref="/root/main/cnstinfo/cnstlist/bfreqcntconsult" calculate="../reqtot -    ../bfreqcnt"/>
			<bind id="bfreplcntreply" ref="/root/main/cnstinfo/cnstlist/bfreplcntreply" calculate="../repltot -    ../bfreplcnt"/>
		</model>
		<script type="javascript">
			<![CDATA[
/**========================================================================================================================================
* 조회기간 그리드초기화
=========================================================================================================================================*/	
				function fInit(){
					
					model.removeNodeset("/root/main/cnstinfo/cnstlist");
					//grd_cnst.colHidden(1) 	= true;

					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 fdate=model.getValue("/root/main/cond/fromdd");
					var todate=model.getValue("/root/main/cond/todd");
					
					var fromdd = model.getValue("/root/main/cond/fromdd") +"01";
					var todd     = model.getValue("/root/main/cond/todd")+ "01";				
					var dateintval=getDateInterval(fromdd,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 == '2'){
							grd_cnst.mergeCells = "bycolrec";
							grd_cnst.mergeCol(0) = true;
							grd_cnst.mergeCol(1) = true;
							grd_cnst.mergeCol(2) = false;
							grd_cnst.mergeCol(3) = false;
							grd_cnst.mergeCol(4) = false;
							grd_cnst.mergeCol(5) = false;
							grd_cnst.mergeCol(6) = false;
							grd_cnst.mergeCol(7) = false;
							grd_cnst.mergeCol(8) = false;
							grd_cnst.mergeCol(9) = false;
							grd_cnst.mergeCol(10) = false;
							grd_cnst.mergeCol(11) = false;
							grd_cnst.mergeCol(12) = false;
							grd_cnst.mergeCol(13) = false;
							grd_cnst.mergeCol(14) = false;
							grd_cnst.mergeCol(15) = false;
							grd_cnst.mergeCol(16) = false;
							grd_cnst.mergeCol(17) = false;
							
							//grd_cnst.colHidden(1) 	= false;
							grd_cnst.colHidden(14) 	= true;
							grd_cnst.colHidden(15) 	= true;
							grd_cnst.colHidden(16) 	= true;
							grd_cnst.colHidden(17) 	= true;
							
							
					model.removeNodeset("/root/send/reqdata");

					model.makeNode("/root/send/reqdata");
					model.copyNode("/root/send/reqdata", "/root/main/cond");
					//model.refresh();
					
					submit("TRSDT04001");
	
					}
					
					//월별
					else if(cmb_sumflag.value == '1') {
					model.removeNodeset("/root/send/reqdata")
					
					model.makeNode("/root/send/reqdata");
					model.copyNode("/root/send/reqdata", "/root/main/cond");
					submit("TRSDT04002");
					fStat();
					
							grd_cnst.mergeCells = "byrestricrow";
							grd_cnst.mergeCol(0) = true;
							grd_cnst.mergeCol(1) = true;
							grd_cnst.mergeCol(2) = false;
							grd_cnst.mergeCol(3) = false;
							grd_cnst.mergeCol(4) = false;
							grd_cnst.mergeCol(5) = false;
							grd_cnst.mergeCol(6) = false;
							grd_cnst.mergeCol(7) = false;
							grd_cnst.mergeCol(8) = false;
							grd_cnst.mergeCol(9) = false;
							grd_cnst.mergeCol(10) = false;
							grd_cnst.mergeCol(11) = false;
							grd_cnst.mergeCol(12) = false;
							grd_cnst.mergeCol(13) = false;
							grd_cnst.mergeCol(14) = false;
							grd_cnst.mergeCol(15) = false;
							grd_cnst.mergeCol(16) = false;
							grd_cnst.mergeCol(17) = false;
							
							//grd_cnst.colHidden(1) 	= true;
							grd_cnst.colHidden(14) 	= false;
							grd_cnst.colHidden(15) 	= false;
							grd_cnst.colHidden(16) 	= false;
							grd_cnst.colHidden(17) 	= false;
							

					//model.refresh();

					}		
					
				
				}

/**========================================================================================================================================
* 전년대비실적비교 계산
=========================================================================================================================================*/					
				function fStat() {	
					
					//데이터가없을때 return 
					//if (model.instances(0).selectNodes("/root/main/cnstinfo/cnstlist").length == 0){
					//	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") ) = "전기간대비실적비교";
						grd_cnst.valueMatrix(insRow, grd_cnst.colRef("usernm") ) = "전기간대비실적비교";
							
						for(var i= grd_cnst.colRef("reqcnt1"); i<= grd_cnst.colRef("repltot"); 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);								
						}					
						grd_cnst.valueMatrix(insRow-1, grd_cnst.colRef("bfreqcntconsult")) = "";
						grd_cnst.valueMatrix(insRow, grd_cnst.colRef("bfreqcntconsult")) = "";
						grd_cnst.valueMatrix(insRow-1, grd_cnst.colRef("bfreplcntreply")) = "";
						grd_cnst.valueMatrix(insRow, grd_cnst.colRef("bfreplcntreply")) = "";	
					}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:230px; 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:232px; 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" 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" 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" 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/sumflag" appearance="minimal" style="left:110px; top:10px; width:110px; height:19px; ">
					<choices>
						<item>
							<label>월별</label>
							<value>1</value>
						</item>
						<item>
							<label>임상주치의별</label>
							<value>2</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-select">
						<![CDATA[
							fGetSoclConfCnstInfo();				
						]]>
					</script>
				</select1>
			</group>
			<button id="btn_excel" class="btn2_letter4" style="left:1126px; top:50px; 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="구분^구분^일반진료^일반진료^재활의료^재활의료^정신의료^정신의료^장기이식^장기이식^호스피스^호스피스^합계^합계^전월실적^전월실적^전월대비실적비교^전월대비실적비교^장소^장소^장소^장소명^장소^담당자|구분^구분^consult^reply^consult^reply^consult^reply^consult^reply^consult^reply^consult^reply^consult^reply^consult^reply^장소^장소^장소^장소명^장소^담당자|구분^구분^consult^reply^consult^reply^consult^reply^consult^reply^consult^reply^consult^reply^consult^reply^consult^reply^장소^장소^장소^장소명^장소^담당자" colsep="^" colwidth="121, 96, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 64, 64" dataheight="25" mergecellsfixedrows="bycolrec" rowheight="25" rowsep="|" style="left:1px; top:76px; width:1190px; height:664px; ">
				<col ref="cdnm" style="text-align:center; "/>
				<col ref="usernm" style="text-align:center; "/>
				<col ref="reqcnt1" style="text-align:center; "/>
				<col ref="replcnt1" style="text-align:center; "/>
				<col ref="reqcnt2" style="text-align:center; "/>
				<col ref="replcnt2" style="text-align:center; "/>
				<col ref="reqcnt3" style="text-align:center; "/>
				<col ref="replcnt3" style="text-align:center; "/>
				<col ref="reqcnt4" style="text-align:center; "/>
				<col ref="replcnt4" style="text-align:center; "/>
				<col ref="reqcnt5" style="text-align:center; "/>
				<col ref="replcnt5" style="text-align:center; "/>
				<col ref="reqtot" style="text-align:center; "/>
				<col ref="repltot" style="text-align:center; "/>
				<col ref="bfreqcnt" style="text-align:center; "/>
				<col ref="bfreplcnt" style="text-align:center; "/>
				<col ref="bfreqcntconsult" style="text-align:center; "/>
				<col ref="bfreplcntreply" style="text-align:center; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>