YNU_JEUS/app_home/himed/webapps/pam/pamendstatsweb/xrw/SMPAE00201_수납자별마감금액비교.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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" xmlns:cs="http://www.comsquare.co.kr/xforms">
	<xhtml:head>
		<xhtml:title>수납자별 마감 금액 비교</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<complist>
							<compinfo>
								<enddd/>
								<compflag/>
								<cashflag/>
								<cash_out/>
								<cash_in/>
								<cash_hi/>
								<cash_sum/>
								<card_out/>
								<card_in/>
								<card_hi/>
								<card_sum/>
								<online_out/>
								<online_in/>
								<online_hi/>
								<online_sum/>
								<unco_out/>
								<unco_in/>
								<unco_hi/>
								<unco_sum/>
								<old_tot/>
								<rcptrid/>
								<rcptrnm/>
								<new_tot/>
								<cash_mgsm/>
								<card_mgsm/>
								<online_mgsm/>
								<unco_mgsm/>
							</compinfo>
						</complist>
					</main>
					<send>
						<fromdd/>
						<todd/>
					</send>
					<hidden>
						<compflag/>
						<cashflag/>
					</hidden>
				</root>
			</instance>
			<submission id="TRPAE00202" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/complist"/>
		</model>
		<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/numericHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" ev:event="xforms-ready">
			<![CDATA[
				var fromdd = getCurrentDate().toDate().getAddDate(-1).getDateFormat();
				model.setValue("/root/send/fromdd", fromdd);
				model.setValue("/root/send/todd", fromdd);
				ipt_fromdd.refresh();
				ipt_todd.refresh();
				
				fSetColWidth("", false);
			]]>
		</script>
		<script type="javascript">
			<![CDATA[
				function fSetColWidth(amt, expand) {
					
					var width = expand ? 90 : 0;
					
					if (amt == null || amt == "") {
						grd_comp.colWidth(grd_comp.colRef("cash_out")) = width;
						grd_comp.colWidth(grd_comp.colRef("cash_in")) = width;
						grd_comp.colWidth(grd_comp.colRef("cash_hi")) = width;
						
						grd_comp.colWidth(grd_comp.colRef("card_out")) = width;
						grd_comp.colWidth(grd_comp.colRef("card_in")) = width;
						grd_comp.colWidth(grd_comp.colRef("card_hi")) = width;
						
						grd_comp.colWidth(grd_comp.colRef("online_out")) = width;
						grd_comp.colWidth(grd_comp.colRef("online_in")) = width;;
						grd_comp.colWidth(grd_comp.colRef("online_hi")) = width;;
						
						grd_comp.colWidth(grd_comp.colRef("unco_out")) = width;;
						grd_comp.colWidth(grd_comp.colRef("unco_in")) = width;;
						grd_comp.colWidth(grd_comp.colRef("unco_hi")) = width;;
					} else {
						grd_comp.colWidth(grd_comp.colRef(amt + "_out")) = width;;
						grd_comp.colWidth(grd_comp.colRef(amt + "_in")) = width;;
						grd_comp.colWidth(grd_comp.colRef(amt + "_hi")) = width;;
					}
				}
				
				function fSetCompflag() {
					if (model.getValue("/root/hidden/cashflag") == "Y") {
						grd_comp.nodeset = "/root/main/complist/compinfo[cashflag = 'N']";	
					} else if (model.getValue("/root/hidden/compflag") == "Y") {
						grd_comp.nodeset = "/root/main/complist/compinfo[compflag = 'N']";
					} else {
						grd_comp.nodeset = "/root/main/complist/compinfo";
					}
						
					var path = "/root/main/complist/compinfo";
					var cnt = instance1.selectNodes(path).length;
					for (var i = 1; i <= cnt; i++) {
						if (model.getValue(path + "[" + i + "]/compflag") != "Y") {
							
							var row = grd_comp.findRow(model.getValue(path + "[" + i + "]/seq"), 2, grd_comp.colRef("seq"), false, true);
							
							grd_comp.cellStyle("font-weight", row, grd_comp.colRef("rcptrnm")) = "bold";
							
							grd_comp.cellStyle("background-color", row, grd_comp.colRef("new_tot")) = "#ffffd2";
							grd_comp.cellStyle("color", row, grd_comp.colRef("new_tot")) = "#b40000";
							grd_comp.cellStyle("font-weight", row, grd_comp.colRef("new_tot")) = "bold";
							
							grd_comp.cellStyle("background-color", row, grd_comp.colRef("rcptrnm")) = "#ffffa0";
							grd_comp.cellStyle("font-weight", row, grd_comp.colRef("rcptrnm")) = "bold";
							
							grd_comp.cellStyle("background-color", row, grd_comp.colRef("old_tot")) = "#ffffd2";
							grd_comp.cellStyle("color", row, grd_comp.colRef("old_tot")) = "#b40000";
							grd_comp.cellStyle("font-weight", row, grd_comp.colRef("old_tot")) = "bold";
							
							if (model.getValue(path + "[" + i + "]/cash_mgsm") != model.getValue(path + "[" + i + "]/cash_sum")) {
								grd_comp.cellStyle("background-color", row, grd_comp.colRef("cash_mgsm")) = "#ffffa0";
								grd_comp.cellStyle("color", row, grd_comp.colRef("cash_mgsm")) = "red";
								grd_comp.cellStyle("font-weight", row, grd_comp.colRef("cash_mgsm")) = "bold";
								
								grd_comp.cellStyle("background-color", row, grd_comp.colRef("cash_sum")) = "#ffffa0";
								grd_comp.cellStyle("color", row, grd_comp.colRef("cash_sum")) = "red";
								grd_comp.cellStyle("font-weight", row, grd_comp.colRef("cash_sum")) = "bold";
							}
							
							if (model.getValue(path + "[" + i + "]/card_mgsm") != model.getValue(path + "[" + i + "]/card_sum")) {
								grd_comp.cellStyle("background-color", row, grd_comp.colRef("card_mgsm")) = "#ffffa0";
								grd_comp.cellStyle("color", row, grd_comp.colRef("card_mgsm")) = "red";
								grd_comp.cellStyle("font-weight", row, grd_comp.colRef("card_mgsm")) = "bold";
								
								grd_comp.cellStyle("background-color", row, grd_comp.colRef("card_sum")) = "#ffffa0";
								grd_comp.cellStyle("color", row, grd_comp.colRef("card_sum")) = "red";
								grd_comp.cellStyle("font-weight", row, grd_comp.colRef("card_sum")) = "bold";
							}
							
							if (model.getValue(path + "[" + i + "]/online_mgsm") != model.getValue(path + "[" + i + "]/online_sum")) {
								grd_comp.cellStyle("background-color", row, grd_comp.colRef("online_mgsm")) = "#ffffa0";
								grd_comp.cellStyle("color", row, grd_comp.colRef("online_mgsm")) = "red";
								grd_comp.cellStyle("font-weight", row, grd_comp.colRef("online_mgsm")) = "bold";
								
								grd_comp.cellStyle("background-color", row, grd_comp.colRef("online_sum")) = "#ffffa0";
								grd_comp.cellStyle("color", row, grd_comp.colRef("online_sum")) = "red";
								grd_comp.cellStyle("font-weight", row, grd_comp.colRef("online_sum")) = "bold";
							}
							
							if (model.getValue(path + "[" + i + "]/unco_mgsm") != model.getValue(path + "[" + i + "]/unco_sum")) {
								grd_comp.cellStyle("background-color", row, grd_comp.colRef("unco_mgsm")) = "#ffffa0";
								grd_comp.cellStyle("color", row, grd_comp.colRef("unco_mgsm")) = "red";
								grd_comp.cellStyle("font-weight", row, grd_comp.colRef("unco_mgsm")) = "bold";
								
								grd_comp.cellStyle("background-color", row, grd_comp.colRef("unco_sum")) = "#ffffa0";
								grd_comp.cellStyle("color", row, grd_comp.colRef("unco_sum")) = "red";
								grd_comp.cellStyle("font-weight", row, grd_comp.colRef("unco_sum")) = "bold";
							}
						}
					}
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:254px; height:14px; ">수납자별 마감 금액 비교 (개편 vs 기존)</caption>
		<shape id="roundrect1" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:0px; top:20px; width:755px; height:40px; "/>
		<button id="btn_search" class="btn1_letter2" navindex="3" style="left:335px; top:29px; width:56px; height:22px; background-image:../../../com/commonweb/images/btn1_letter2.gif; ">
			<caption>조회</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					grd_comp.rebuildStyle();
					submit("TRPAE00202");
					fSetCompflag();
				]]>
			</script>
		</button>
		<caption id="caption35" class="search_name" style="left:5px; top:31px; width:90px; height:17px; ">마감일자 :</caption>
		<input id="ipt_fromdd" ref="/root/send/fromdd" navindex="1" inputtype="date" style="left:97px; top:30px; width:90px; height:19px; "/>
		<caption id="caption4" style="left:189px; top:34px; width:15px; height:15px; text-align:center; ">~</caption>
		<input id="ipt_todd" ref="/root/send/todd" navindex="2" inputtype="date" style="left:205px; top:30px; width:90px; height:19px; "/>
		<line id="line14" class="line_4" style="x1:315px; y1:28px; x2:315px; y2:53px; font-family:돋움체; border-color:#ffd799; "/>
		<caption id="caption77" class="tit_2" style="left:0px; top:70px; width:144px; height:13px; ">수납자별 마감내역</caption>
		<datagrid id="grd_comp" nodeset="/root/main/complist/compinfo" backcoloralternate="transparent" caption="seq^마감일^비교결과^비교결과(현금)^현금^카드^온라인^미수^합계^수납자ID^수납자^합계^현금^현금^현금^현금^카드^카드^카드^카드^온라인^온라인^온라인^온라인^미수^미수^미수^미수|seq^마감일^비교결과^비교결과(현금)^현금^카드^온라인^미수^합계^수납자ID^수납자^합계^외래^입원^건진^계^외래^입원^건진^계^외래^입원^건진^계^외래^입원^건진^계" colsep="^" colwidth="0,75,0,0,90,90,90,90,90,0,50,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90" frozencols="12" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:90px; width:1195px; height:690px; ">
			<col ref="seq"/>
			<col ref="enddd" format="yyyy-mm-dd" style="text-align:center; "/>
			<col ref="compflag"/>
			<col ref="cashflag"/>
			<col ref="cash_mgsm" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="card_mgsm" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="online_mgsm" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="unco_mgsm" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="new_tot" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="rcptrid"/>
			<col ref="rcptrnm" style="text-align:center; "/>
			<col ref="old_tot" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="cash_out" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="cash_in" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="cash_hi" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="cash_sum" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="card_out" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="card_in" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="card_hi" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="card_sum" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="online_out" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="online_in" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="online_hi" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="online_sum" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="unco_out" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="unco_in" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="unco_hi" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<col ref="unco_sum" format="(-)#,###" style="text-align:right; padding-right:1; "/>
			<script type="javascript" ev:event="ondblclick">
				<![CDATA[
					if (grd_comp.row < 2) {
						
						var amt = "";
						var expand = true;
						
						if (grd_comp.col >= grd_comp.colRef("cash_out") && grd_comp.col <= grd_comp.colRef("cash_sum")) {
							amt = "cash";
							expand = grd_comp.colWidth(grd_comp.colRef("cash_out")) > 0 ? false : true;
						} else if (grd_comp.col >= grd_comp.colRef("card_out") && grd_comp.col <= grd_comp.colRef("card_sum")) {
							amt = "card";
							expand = grd_comp.colWidth(grd_comp.colRef("card_out")) > 0 ? false : true;
						} else if (grd_comp.col >= grd_comp.colRef("online_out") && grd_comp.col <= grd_comp.colRef("online_sum")) {
							amt = "online";
							expand = grd_comp.colWidth(grd_comp.colRef("online_out")) > 0 ? false : true;
						} else if (grd_comp.col >= grd_comp.colRef("unco_out") && grd_comp.col <= grd_comp.colRef("unco_sum")) {
							amt = "unco";
							expand = grd_comp.colWidth(grd_comp.colRef("unco_out")) > 0 ? false : true;
						} else if (grd_comp.col == grd_comp.colRef("old_tot")) {
							
							if (grd_comp.colWidth(grd_comp.colRef("cash_out"))   > 0 ||
							    grd_comp.colWidth(grd_comp.colRef("card_out"))   > 0 ||
								grd_comp.colWidth(grd_comp.colRef("online_out")) > 0 ||
								grd_comp.colWidth(grd_comp.colRef("unco_out"))   > 0) {
								
								expand = false;
							} else {
								expand = true;
							}
							fSetColWidth("", expand);
						}
						
						if (amt != "") {
							fSetColWidth(amt, expand);
						}
					}
				]]>
			</script>
		</datagrid>
		<button id="btn_xls" class="btn2_letter2" style="left:1153px; top:65px; width:42px; height:19px; ">
			<caption>엑셀</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					var file = window.fileDialog("save", "", "false", "수납자별 마감금액비교", "xls", "Excel Files(*.xls)|*.xls");
					grd_rcptlist.saveExcel(file);
				]]>
			</script>
		</button>
		<line id="line_comp" class="line_1" style="x1:0px; y1:85px; x2:1195px; y2:85px; "/>
		<select id="chk_compflag" ref="/root/hidden/compflag" navindex="4" overflow="visible" appearance="full" style="left:415px; top:32px; width:155px; height:20px; border-style:none; ">
			<choices>
				<item>
					<label>금액이 다른 항목만 보기</label>
					<value>Y</value>
				</item>
			</choices>
			<script type="javascript" ev:event="xforms-value-changed">
				<![CDATA[
					grd_comp.rebuildStyle();
					fSetCompflag();
				]]>
			</script>
		</select>
		<select id="chk_cashflag" ref="/root/hidden/cashflag" navindex="5" overflow="visible" appearance="full" style="left:580px; top:32px; width:155px; height:20px; border-style:none; ">
			<choices>
				<item>
					<label>현금이 다른 항목만 보기</label>
					<value>Y</value>
				</item>
			</choices>
			<script type="javascript" ev:event="xforms-value-changed">
				<![CDATA[
					grd_comp.rebuildStyle();
					fSetCompflag();
				]]>
			</script>
		</select>
		<line id="line1" style="x1:575px; y1:67px; x2:575px; y2:82px; border-color:#b0b0b0; "/>
		<caption id="caption1" style="left:577px; top:67px; width:48px; height:15px; color:#787878; ">▶ 기존</caption>
		<line id="line2" style="x1:525px; y1:67px; x2:525px; y2:82px; border-color:#b0b0b0; "/>
		<caption id="caption2" style="left:482px; top:67px; width:42px; height:15px; color:#787878; text-align:right; ">개편 ◀</caption>
		<caption id="caption3" style="left:910px; top:33px; width:235px; height:50px; color:#787878; text-align:left; line-spacing:2; ">
			<![CDATA[※ 기존 금액의 칼럼 헤더를 더블 클릭하면
    각 금액별로 확장 및 축소가 가능합니다.
    (합계 : 전체 확장 / 축소)]]>
		</caption>
	</xhtml:body>
</xhtml:html>