YNU_JEUS/app_home/himed/webapps/pam/clamuncoweb/xrw/SMPIF72200_진료비총집계표(자보).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>
						<termflag>B</termflag>
						<fromdd/>
						<todd/>
						<clamym/>
						<clamdgfrom/>
						<clamdgto/>
						<ioflag>A</ioflag>
						<endyn>A</endyn>
						<patunitsrch1/>
						<patunitsrch2/>
						<certno/>
						<clamflag/>
						<insukind/>
					</send>
					<main>
						<list>
							<datagrid1>
								<insucmpymark/>
								<clamym/>
								<clamamt/>
								<depoamt/>
								<fstcutamt/>
								<orgcutamt/>
								<uncoamt/>
							</datagrid1>
							<datagrid2>
								<insucmpymark/>
								<clamamt/>
								<depoamt/>
								<fstcutamt/>
								<orgcutamt/>
								<uncoamt/>
							</datagrid2>
						</list>
						<patinfo>
							<patinfolist/>
						</patinfo>
					</main>
					<init>
						<U0001list>
							<U0001>
								<cd/>
								<nm/>
							</U0001>
						</U0001list>
						<P0028list>
							<P0028>
								<cdid/>
								<cdnm/>
							</P0028>
						</P0028list>
						<P0155list>
							<P0155>
								<cdid/>
								<cdnm/>
							</P0155>
						</P0155list>
					</init>
					<hidden>
						<U0001>
							<cd/>
							<nm>전체</nm>
						</U0001>
						<U0002list>
							<U0002>
								<cdid/>
								<cdnm/>
							</U0002>
						</U0002list>
						<sppmc02500>
							<cond>
								<srchcond/>
								<pid/>
								<hngnm/>
								<rrgstno1/>
								<rrgstno2/>
								<insukind/>
							</cond>
						</sppmc02500>
					</hidden>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				
				CommCode_Load();
				
				// 그리드 초기화(행을 모두 삭제한다.)
				model.removeNodeset("/root/main/list/datagrid1");
				model.removeNodeset("/root/main/list/datagrid2");

				//model.setValue("/root/send/fromdd", getCurrentDate().toDate().getAddDate(-90).getDateFormat("YYYYMM"));
				//cmb_clamtype.select(1);
									
				model.setValue("/root/send/fromdd", getCurrentDate().substr(0, 6));
				model.setValue("/root/send/todd", getCurrentDate().substr(0, 6));
				
				model.refresh();
				
				addComboItem("cmb_clamdgfrom","1","1","");
				addComboItem("cmb_clamdgfrom","전체","","above");
				
				addComboItem("cmb_clamdgto","1","1","");
				addComboItem("cmb_clamdgto","전체","","above");
							
				//fGetClamdg();									
				// 손보사 코드 조회
//				submit("TRPIF70305");
				]]>
			</script>
			<submission id="TRZBC00101" mediatype="application/x-www-form-urlencoded" method="post"/>
			<submission id="TRPIF30903" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/init/U0002list"/>
			<!-- 손보사 리스트 조회 -->
			<submission id="TRPIF70305" mediatype="application/x-www-form-urlencoded" method="post" resultref="/root/init/U0001list"/>
			<!--  손보사별 진료비총집계표 -->
			<submission id="TRPIF72201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/list"/>
			<!-- 청구차수조회 -->
			<submission id="TRPID20407" mediatype="application/x-www-form-urlencoded" method="post" ref="root/send" resultref="/root/init/clamdg"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.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/numericHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
		<script type="javascript">
			<![CDATA[
				// 공통코드 Load작업
				function CommCode_Load() {
				 	// 관련 Control 초기화
					zbcfGetCodeList(new Array("P0028", "P0155"), new Array("/root/init/P0028list", "/root/init/P0155list"));
					//손보사 콤보 data 조회(자보미수관리 참조)
					submit("TRPIF70305");
					
					// 손보자 조회 조건에 전체가없어서 추가 해달라고 했는데 해당 조회 쿼리는 공통으로 쓰는거라
					// 임의로 추가함.
					// 20090108. JHP
					var node      = root.init.U0001list;
					var addnode = root.hidden.U0001;
					var refnode   = root.init.U0001list.U0001;
					node.insertbefore(addnode,refnode);					
					
				}
				    

				
				// 청구차수 함수
				function fGetClamdg() {							
					
					var check = model.getValue("/root/send/termflag");
					
					if ( model.getValue("/root/send/fromdd") > model.getValue("/root/send/todd") ) {
						messageBox("종료일은 시작일보다 클 수 ", "I004");
						model.setValue("/root/send/todd","")
					}
					
					// 청구월일 경우
					if(check == "B"){
						if(model.getValue("/root/send/fromdd") != "" || model.getValue("/root/send/todd") != ""){
							model.removeNodeset("/root/init/clamdg");
							model.removenode("/root/init/clamdgfrom");
							model.removenode("/root/init/clamdgto");							
							model.makeNode("/root/init/clamdg");	
							model.setValue("/root/send/clamym",model.getValue("/root/send/fromdd"));
							model.setValue("/root/send/insukind","21");

							submit("TRPID20407");
							model.makeNode("/root/init/clamdgfrom");
							model.copyNode("/root/init/clamdgfrom","/root/init/clamdg");							
							cmb_clamdgfrom.refresh();
							
							
							model.setValue("/root/send/clamym",model.getValue("/root/send/todd"));
							model.setValue("/root/send/insukind","21");
							submit("TRPID20407");
							model.makeNode("/root/init/clamdgto");
							model.copyNode("/root/init/clamdgto","/root/init/clamdg");							
							addComboItem("cmb_clamdgfrom","전체","","above");
							addComboItem("cmb_clamdgto","전체","","above");
							cmb_clamdgto.refresh();
						}
					}
					
				}
				
				// 청구년월 차수 기간 체크, 동일한 월에 한에서만 차수로 검색이 가능하다.
				function fChkClamym() {
					var fromym = model.getValue("/root/send/fromacptym");
					var toym = model.getValue("/root/send/toacptym");
					var check = model.getValue("/root/send/termflag");				
					
					if(check == "2"){
						if ( fromym != toym ){
							
							cmb_clamdgfrom.value = "";
							cmb_clamdgto.value = "";
							cmb_clamdgfrom.disabled = true;
							cmb_clamdgto.disabled = true;		
							
						}else{
							cmb_clamdgfrom.disabled = false;
							cmb_clamdgto.disabled = false;		
							cmb_clamdgfrom.select(0);
							cmb_clamdgto.select(0);						
						}
						cmb_clamdgto.refresh();
						cmb_clamdgfrom.refresh();
					}
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body class="datagrid2" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:311px; height:14px; ">진료비총집계표(자보)</caption>
		</group>
		<group id="grp_biz" 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" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1194px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="button1" class="btn1_letter2" style="left:1118px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							
							/*							
							if(model.getValue("/root/send/clamdgfrom") == "") {
								messageBox("청구차수를","C002");
								model.setFocus("cmb_clamdgfrom");
								return false;
							}
							*/
							
							/*
							if(model.getValue("/root/send/clamflag") == "") {
								messageBox("청구구분을","C002");
								model.setFocus("cmb_clamtype");
								return false;
							}	
							*/						
							
							submit("TRPIF72201");
							
							if( getNodesetCount("/root/main/list/datagrid1/insucmpymark") > 0 ){
								//datagrid1.multiTotals = true;
								datagrid1.subtotalPosition = "below";								
								datagrid1.subtotal("sum", datagrid1.colRef("clamym"), datagrid1.colRef("clamamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid1.colRef("insucmpymark"), "월별소계", false);
								datagrid1.subtotal("sum", datagrid1.colRef("clamym"), datagrid1.colRef("depoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid1.colRef("insucmpymark"), "월별소계", false);
								datagrid1.subtotal("sum", datagrid1.colRef("clamym"), datagrid1.colRef("fstcutamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid1.colRef("insucmpymark"), "월별소계", false);
								datagrid1.subtotal("sum", datagrid1.colRef("clamym"), datagrid1.colRef("orgcutamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid1.colRef("insucmpymark"), "월별소계", false);
								datagrid1.subtotal("sum", datagrid1.colRef("clamym"), datagrid1.colRef("uncoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid1.colRef("insucmpymark"), "월별소계", false);	
								
								datagrid1.subtotal("sum", -1, datagrid1.colRef("clamamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid1.colRef("insucmpymark"), "총합계", false);
								datagrid1.subtotal("sum", -1, datagrid1.colRef("depoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid1.colRef("insucmpymark"), "총합계", false);
								datagrid1.subtotal("sum", -1, datagrid1.colRef("fstcutamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid1.colRef("insucmpymark"), "총합계", false);
								datagrid1.subtotal("sum", -1, datagrid1.colRef("orgcutamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid1.colRef("insucmpymark"), "총합계", false);
								datagrid1.subtotal("sum", -1, datagrid1.colRef("uncoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid1.colRef("insucmpymark"), "총합계", false);																																						

								
								
							}
							if( getNodesetCount("/root/main/list/datagrid2/insucmpymark") > 0 ){
								datagrid2.multiTotals = true;
								datagrid2.subtotalPosition = "below";
								datagrid2.subtotal("sum", -1, datagrid2.colRef("clamamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid2.colRef("insucmpymark"), "총합계", true);
								datagrid2.subtotal("sum", -1, datagrid2.colRef("depoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid2.colRef("insucmpymark"), "총합계", true);
								datagrid2.subtotal("sum", -1, datagrid2.colRef("fstcutamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid2.colRef("insucmpymark"), "총합계", true);
								datagrid2.subtotal("sum", -1, datagrid2.colRef("orgcutamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid2.colRef("insucmpymark"), "총합계", true);
								datagrid2.subtotal("sum", -1, datagrid2.colRef("uncoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", datagrid2.colRef("insucmpymark"), "총합계", true);
							}
						]]>
					</script>
				</button>
				<line id="line13" class="line_4" style="x1:1093px; y1:8px; x2:1093px; y2:30px; "/>
				<input id="ipt_fromdd" ref="/root/send/fromdd" class="input_search" inputtype="date" format="yyyy-mm" style="left:92px; top:8px; width:85px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							ipt_todd.value = ipt_fromdd.value;
							model.refreshpart("/root/send/todd");						
							//fGetClamdg();
							fChkClamym();			
						]]>
					</script>
				</input>
				<select1 id="radio1" ref="/root/send/ioflag" class="radio_search" appearance="full" cellspacing="5" cols="3" overflow="visible" style="left:698px; top:10px; width:145px; height:15px; border-style:none; ">
					<choices>
						<item>
							<label>전체</label>
							<value>A</value>
						</item>
						<item>
							<label>입원</label>
							<value>I</value>
						</item>
						<item>
							<label>외래</label>
							<value>O</value>
						</item>
					</choices>
				</select1>
				<caption id="caption7" class="search_name" style="left:611px; top:9px; width:86px; height:17px; ">내원유형 :</caption>
				<caption id="caption8" class="search_name" visibility="visible" style="left:865px; top:9px; width:87px; height:17px; ">손 보 사 :</caption>
				<select1 id="cmb_insucmpymark" ref="/root/send/certno" class="combo_search" visibility="visible" appearance="minimal" style="left:952px; top:8px; width:100px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/U0001list/U0001">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<select1 id="rdo_endyn" ref="/root/send/endyn" class="radio_search" visibility="hidden" appearance="full" cols="3" overflow="visible" style="left:990px; top:0px; width:149px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>전체</label>
							<value>A</value>
						</item>
						<item>
							<label>완료</label>
							<value>Y</value>
						</item>
						<item>
							<label>미완료</label>
							<value>N</value>
						</item>
					</choices>
				</select1>
				<caption id="caption11" class="search_name" visibility="hidden" style="left:885px; top:0px; width:116px; height:17px; ">완 료 여 부 :</caption>
				<caption id="caption13" class="search_name" style="left:10px; top:7px; width:73px; height:17px; ">청구월 :</caption>
				<select1 id="cmb_clamdgfrom" ref="/root/send/clamdgfrom" class="combo_search" appearance="minimal" style="left:182px; top:8px; width:50px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/clamdgfrom/clamdglist">
							<label ref="clamdgnm"/>
							<value ref="clamdgcd"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							cmb_clamdgto.value = cmb_clamdgfrom.value;
							model.refreshpart("/root/send/clamdgto");				
						]]>
					</script>
				</select1>
				<select1 id="cmb_clamtype" ref="/root/send/clamflag" class="combo_search" appearance="minimal" style="left:502px; top:7px; width:85px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/P0155list/P0155">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption14" class="search_name" style="left:412px; top:8px; width:93px; height:17px; ">청구구분 :</caption>
				<select1 id="cmb_clamdgto" ref="/root/send/clamdgto" class="combo_search" appearance="minimal" style="left:338px; top:8px; width:50px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/clamdgto/clamdglist">
							<label ref="clamdgnm"/>
							<value ref="clamdgcd"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption3" style="left:235px; top:9px; width:15px; height:20px; ">~</caption>
				<input id="ipt_todd" ref="/root/send/todd" class="input_search" inputtype="date" format="yyyy-mm" style="left:249px; top:8px; width:85px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							//fGetClamdg();
							fChkClamym();
						]]>
					</script>
				</input>
			</group>
			<switch id="switch1" class="sw_box" style="left:0px; top:75px; width:1194px; height:664px; ">
				<case id="case1" selected="true">
					<datagrid id="datagrid1" nodeset="/root/main/list/datagrid1" caption="손보사^청구월^청구액^입금액^1차삭감액^현삭감액^미수액" colsep="^" colwidth="150, 80, 120, 120, 120, 120, 120" dataheight="25" defaultrows="2" ellipsis="true" explorerbar="sortshow" extendlastcol="false" mergecellsfixedrows="bycolrec" rowheight="25" rowsep="|" tooltip="true" style="left:0px; top:0px; width:1190px; height:660px; ">
						<col ref="insucmpymark" style="text-align:left; "/>
						<col ref="clamym" format="yyyy-mm" style="text-align:center; "/>
						<col ref="clamamt" format="#,###" style="text-align:right; "/>
						<col ref="depoamt" format="#,###" style="text-align:right; "/>
						<col ref="fstcutamt" format="#,###" style="text-align:right; "/>
						<col ref="orgcutamt" format="#,###" style="text-align:right; "/>
						<col ref="uncoamt" format="#,###" style="text-align:right; "/>
						<script type="javascript" ev:event="oncopy">
							<![CDATA[
							grid_oncopy();
							]]>
						</script>
					</datagrid>
				</case>
				<case id="case2">
					<datagrid id="datagrid2" nodeset="/root/main/list/datagrid2" caption="손보사^청구액^입금액^1차삭감액^현삭감액^미수액" colsep="^" colwidth="150, 120, 120, 120, 120, 120" dataheight="25" defaultrows="2" ellipsis="true" explorerbar="sortshow" extendlastcol="false" mergecellsfixedrows="bycolrec" rowheight="25" rowsep="|" tooltip="true" style="left:0px; top:0px; width:1190px; height:660px; ">
						<col ref="insucmpymark" style="text-align:left; "/>
						<col ref="clamamt" format="#,###" style="text-align:right; "/>
						<col ref="depoamt" format="#,###" style="text-align:right; "/>
						<col ref="fstcutamt" format="#,###" style="text-align:right; "/>
						<col ref="orgcutamt" format="#,###" style="text-align:right; "/>
						<col ref="uncoamt" format="#,###" style="text-align:right; "/>
						<script type="javascript" ev:event="oncopy">
							<![CDATA[
							grid_oncopy();
							]]>
						</script>
					</datagrid>
				</case>
			</switch>
			<button id="btn_rtndetl1" class="btn_sw" group="tab" selected="true" style="left:0px; top:53px; width:175px; height:22px; ">
				<caption>월별 진료비 총집계표</caption>
				<toggle case="case1" ev:event="onclick"/>
			</button>
			<button id="btn_rtndetl2" class="btn_sw" group="tab" style="left:175px; top:53px; width:175px; height:22px; ">
				<caption>손보사별 진료비 총집계표</caption>
				<toggle case="case2" ev:event="onclick"/>
			</button>
			<button id="button12" class="btn2_letter4" style="left:1129px; top:55px; width:64px; height:19px; ">
				<caption>액셀저장</caption>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						if(btn_rtndetl1.selected == true){
							var fileName = window.fileDialog("save", ",", false, '월별 진료비총집계표', "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
							if (fileName != "") { 
								datagrid1.saveExcel(fileName, "SheetName", true, true, "", "", ""); 
							}
						}else if(btn_rtndetl2.selected == true){
							var fileName = window.fileDialog("save", ",", false, '손보사별 진료비총집계표', "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
							if (fileName != "") { 
								datagrid2.saveExcel(fileName, "SheetName", true, true, "", "", ""); 
							}
						}
					]]>
				</script>
			</button>
			<button id="button2" class="btn2_letter2" style="left:1085px; top:55px; width:42px; height:19px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
				if(btn_rtndetl1.selected == true) {
					exeReportPreview("RPPIF72200", "XMLSTR", "", "", "false", "", "", "", "", "","", "", "", "", "", "1", "");
				}else if(btn_rtndetl2.selected == true) {
					exeReportPreview("RPPIF72210", "XMLSTR", "", "", "false", "", "", "", "", "","", "", "", "", "", "1", "");
				}
				]]>
				</script>
			</button>
		</group>
		<group id="grp_btn" style="left:0px; top:757px; width:1195px; height:27px; "/>
		<group id="group1" scroll="auto" style="left:0px; top:752px; width:1195px; height:28px; ">
			<button id="button45" class="btn4_letter2" visibility="hidden" style="left:1138px; top:5px; width:56px; height:22px; ">
				<caption>닫기</caption>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						window.close();
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>