123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467 |
- <?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>Untitle</xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <send>
- <fromdd/>
- <todd/>
- <clamflag/>
- <insukind>11</insukind>
- <ioflag>A</ioflag>
- <selectflag>1</selectflag>
- </send>
- <main>
- <list01>
- <griddepoamt1>
- <depodd/>
- <depoflag/>
- <bankcd/>
- <banknm/>
- <acntcd/>
- <depoamt/>
- </griddepoamt1>
- <griddepoamt2>
- <depodd/>
- <bankcd/>
- <banknm/>
- <acntcd/>
- <depoamt/>
- </griddepoamt2>
- <griddepoamt2>
- <acptno/>
- <depodd/>
- <bankcd/>
- <banknm/>
- <acntcd/>
- <depoamt/>
- </griddepoamt2>
- </list01>
- </main>
- <init>
- <P0266list>
- <P0266>
- <cdid/>
- <cdnm/>
- </P0266>
- </P0266list>
- <U0001list>
- <U0001>
- <judgdg/>
- </U0001>
- </U0001list>
- <U0002list>
- <U0002>
- <cdid/>
- <cdnm/>
- </U0002>
- </U0002list>
- <R0001list>
- <R0001>
- <cdid/>
- <cdnm/>
- </R0001>
- </R0001list>
- <bankinfo>
- <bankinfolist>
- <cdid/>
- <cdnm/>
- </bankinfolist>
- </bankinfo>
- </init>
- </root>
- </instance>
- <submission id="TRZBC00101" mediatype="application/x-www-form-urlencoded" method="post"/>
- <submission id="TRPIF31901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/list01"/>
- <submission id="TRPIF30309" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/init/bankinfo"/>
- <submission id="TRPIF31902" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/print/send" resultref="/root/prntlist"/>
- </model>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
- <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- // 공통코드 Load작업
- zbcfGetCodeList(new Array("P0266"), new Array( "/root/init/P0266list")); // 입금구분
- zbcfGetCodeList(new Array("R0001"), new Array( "/root/init/R0001list")); // 은행구분
-
-
- //기관별 은행및 은행계좌조회
- submit("TRPIF30309");
-
- model.setValue("/root/send/fromdd", getCurrentDate());
- model.setValue("/root/send/todd", getCurrentDate());
- model.refresh();
-
- model.setFocus("ipt_fromdd");
-
- ]]>
- </script>
- <script type="javascript">
- <![CDATA[
- // 셀 합치기 2010.01.14
- // 청구내역 1개당 입급내역이 다수이므로 동일한 청구내역은 셀 합치기 함.
- function fMergeCells() {
-
- var rows = 0;
- var forCnt = 0, fromCnt1 = 0, toCnt1 = 0;
-
- // 보험 보호 구분에 따른 로우 건수 및 입금예정액 컬럼 번호
- if ( rdo_insukind.value == "11" ) {
- rows = grd_depospecbydept.rows;
- forCnt = grd_depospecbydept.colRef("jrhandicaprfund");
- fromCnt1 = grd_depospecbydept.colRef("rrgstnoretecnt");
- toCnt1 = grd_depospecbydept.colRef("judgretehandicap");
- } else if(rdo_insukind.value == "21") {
- rows = datagrid1.rows;
- forCnt = datagrid1.colRef("jrhandicaprfund");
- fromCnt1 = datagrid1.colRef("pretecnt");
- toCnt1 = datagrid1.colRef("judgretehandicap");
- }
-
- var pre_clamym = "";
- var pre_acptno = "";
- var pre_judgdg = "";
- var pre_ordfildcd = "";
- var pre_clamdeptcd = "";
- var pre_clamflag = "";
-
- var clamym;
- var acptno;
- var judgdg;
- var ordfildcd;
- var clamdeptcd;
- var clamflag;
-
- for ( var i = 1 ; i < rows ; i++ ) {
- // 보험 보호에 따라 그리드 아이디가 바뀐다.
- if ( rdo_insukind.value == "11" ) {
- clamym = grd_depospecbydept.valueMatrix(i, grd_depospecbydept.colRef("clamym"));
- acptno = grd_depospecbydept.valueMatrix(i, grd_depospecbydept.colRef("acptno"));
- judgdg = grd_depospecbydept.valueMatrix(i, grd_depospecbydept.colRef("judgdg"));
- ordfildcd = grd_depospecbydept.valueMatrix(i, grd_depospecbydept.colRef("ordfildcd"));
- clamdeptcd = grd_depospecbydept.valueMatrix(i, grd_depospecbydept.colRef("clamdeptcd"));
- clamflag = grd_depospecbydept.valueMatrix(i, grd_depospecbydept.colRef("clamflag"));
- } else if(rdo_insukind.value == "21") {
- clamym = datagrid1.valueMatrix(i, datagrid1.colRef("clamym"));
- acptno = datagrid1.valueMatrix(i, datagrid1.colRef("acptno"));
- judgdg = datagrid1.valueMatrix(i, datagrid1.colRef("judgdg"));
- ordfildcd = datagrid1.valueMatrix(i, datagrid1.colRef("ordfildcd"));
- clamdeptcd = datagrid1.valueMatrix(i, datagrid1.colRef("clamdeptcd"));
- clamflag = datagrid1.valueMatrix(i, datagrid1.colRef("clamflag"));
- }
-
- if ( pre_clamym == clamym && pre_acptno == acptno && pre_judgdg == judgdg && pre_ordfildcd == ordfildcd && pre_clamdeptcd == clamdeptcd && pre_clamflag == clamflag) {
- if ( rdo_insukind.value == "11" ) {
- // 첫번째 컬럼 부터 입금예정액 컬럼 까지 합쳐요.
- for ( var k = 1 ; k <= forCnt ; k++ ) {
- grd_depospecbydept.mergeByFree(i - 1, k, i, k);
- }
- // 입금내역 이후 입금구분에 따라서 따로 보여줌 2010.05.10
- // for ( var k = fromCnt1 ; k <= toCnt1 ; k++ ) {
- // grd_depospecbydept.mergeByFree(i - 1, k, i, k);
- // }
- } else if(rdo_insukind.value == "21") {
- // 첫번째 컬럼 부터 입금예정액 컬럼 까지 합쳐요.
- for ( var k = 1 ; k <= forCnt ; k++ ) {
- datagrid1.mergeByFree(i - 1, k, i, k);
- }
- for ( var k = fromCnt1 ; k <= toCnt1 ; k++ ) {
- datagrid1.mergeByFree(i - 1, k, i, k);
- }
- }
- }
-
- pre_clamym = clamym;
- pre_acptno = acptno;
- pre_judgdg = judgdg;
- pre_ordfildcd = ordfildcd;
- pre_clamdeptcd = clamdeptcd;
- pre_clamflag = clamflag;
- }
-
- // 소계, 환수, 정산 환수 일 경우 색칠해요.
- initGridStyle("grd_depospecbydept");
- setRowStyle("grd_depospecbydept", "1", "[ 소 계 ]", "clamdeptcd", "equal");
- setRowStyle("grd_depospecbydept", "2", "[ 환 수 ]", "clamdeptcd", "equal");
- setRowStyle("grd_depospecbydept", "3", "[정산 환수]", "clamdeptcd", "equal");
-
- initGridStyle("datagrid1");
- setRowStyle("datagrid1", "1", "[ 소 계 ]", "clamdeptcd", "equal");
- setRowStyle("datagrid1", "2", "[ 환 수 ]", "clamdeptcd", "equal");
- setRowStyle("datagrid1", "3", "[정산 환수]", "clamdeptcd", "equal");
-
- }
- ]]>
- </script>
- </xhtml:head>
- <xhtml:body class="datagrid2" guideline="1,1195;" 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:60px; vertical-align:top; ">
- <shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1194px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
- <button id="button1" class="btn1_letter2" style="left:1111px; top:18px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- if (ipt_fromdd.value == "" || ipt_todd.value == "") {
- messageBox("시작일과 종료일은","I003");
- model.setFocus("ipt_fromdd");
- return false;
- }
-
- submit("TRPIF31901");
-
- if(rdo_selectflag.value == "1") {
- btn_depospecbyinsu.selected = true;
- model.toggle("case1");
-
- grd_depoamt1.subtotalPosition = "below";
- grd_depoamt1.subtotal("sum", 1, grd_depoamt1.colRef("depoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", grd_depoamt1.colRef("acntcd"), "소계", true);
- grd_depoamt1.subtotal("sum", -1, grd_depoamt1.colRef("depoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", grd_depoamt1.colRef("acntcd"), "총합계", true);
- } else if(rdo_selectflag.value == "2") {
- btn_depospecbyinsu.selected = true;
- model.toggle("case1");
-
- grd_depoamt1.subtotalPosition = "below";
- grd_depoamt1.subtotal("sum", 1, grd_depoamt1.colRef("depoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", grd_depoamt1.colRef("acntcd"), "소계", true);
- grd_depoamt1.subtotal("sum", -1, grd_depoamt1.colRef("depoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", grd_depoamt1.colRef("acntcd"), "총합계", true);
- } else if(rdo_selectflag.value == "3") {
- btn_depospecbyproc.selected = true;
- model.toggle("case2");
-
- grd_depoamt2.subtotalPosition = "below";
- grd_depoamt2.subtotal("sum", -1, grd_depoamt2.colRef("depoamt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#f4f4f4; font-weight:bold; ", grd_depoamt2.colRef("acntcd"), "총합계", true);
- }
-
-
- ]]>
- </script>
- </button>
- <line id="line13" class="line_4" style="x1:1084px; y1:18px; x2:1084px; y2:40px; "/>
- <caption id="caption4" class="search_name" style="left:334px; top:20px; width:86px; height:17px; vertical-align:top; ">보험유형</caption>
- <input id="ipt_fromdd" ref="/root/send/fromdd" class="input_s_essential" inputtype="date" maxlength="8" format="yyyy-mm-dd" style="left:105px; top:20px; width:97px; height:19px; ">
- <script type="javascript" ev:event="DOMFocusOut">
- <![CDATA[
- //ipt_todd.value = ipt_fromdd.value;
- ]]>
- </script>
- </input>
- <input id="ipt_todd" ref="/root/send/todd" class="input_s_essential" inputtype="date" maxlength="8" format="yyyy-mm-dd" style="left:222px; top:20px; width:97px; height:19px; "/>
- <caption id="caption7" style="left:206px; top:23px; width:15px; height:15px; ">~</caption>
- <caption id="caption8" class="search_name" style="left:596px; top:20px; width:86px; height:17px; vertical-align:top; ">내원유형</caption>
- <select1 id="rdo_ioflag" ref="/root/send/ioflag" overflow="visible" appearance="full" cols="3" rows="1" style="left:678px; top:20px; width:134px; 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>
- <select1 id="rdo_insukind" ref="/root/send/insukind" overflow="visible" appearance="full" cols="4" rows="1" style="left:414px; top:19px; width:176px; height:15px; border-style:none; ">
- <choices>
- <item>
- <label>보험</label>
- <value>11</value>
- </item>
- <item>
- <label>보호</label>
- <value>21</value>
- </item>
- <item>
- <label>산재</label>
- <value>41</value>
- </item>
- <item>
- <label>기타</label>
- <value>99</value>
- </item>
- </choices>
- </select1>
- <caption id="caption3" class="search_name" style="left:15px; top:21px; width:86px; height:17px; vertical-align:top; ">입금일자</caption>
- <select1 id="rdo_selectflag" ref="/root/send/selectflag" overflow="visible" appearance="full" cols="3" rows="1" style="left:879px; top:20px; width:201px; height:15px; border-style:none; ">
- <choices>
- <item>
- <label>일자별</label>
- <value>1</value>
- </item>
- <item>
- <label>일자별sum</label>
- <value>2</value>
- </item>
- <item>
- <label>접수번호</label>
- <value>3</value>
- </item>
- </choices>
- <script type="javascript" ev:event="xforms-select">
- <![CDATA[
-
- if ( rdo_selectflag.value == "1" ) {
- btn_depospecbyinsu.selected = true;
- model.toggle("case1");
- } else if ( rdo_selectflag.value == "2" ) {
- btn_depospecbyinsu.selected = true;
- model.toggle("case1");
- } else if ( rdo_selectflag.value == "3" ) {
- btn_depospecbyproc.selected = true;
- model.toggle("case2");
- };
- ]]>
- </script>
- </select1>
- <caption id="caption1" class="search_name" style="left:822px; top:20px; width:51px; height:17px; vertical-align:top; ">구분</caption>
- </group>
- <button id="button4" class="btn2_letter4" style="left:1125px; top:80px; width:64px; height:19px; ">
- <caption>엑셀저장</caption>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- var today = new Date();
-
- var yy = today.getYear()+"";
- var mm = today.getMonth()+1;
- var dd = today.getDate();
-
- if(mm < 10) { mm = "0"+mm; } else { mm = mm+""; }
- if(dd < 10) { dd = "0" + dd; } else { dd = dd + ""; }
-
- var tmp = yy+mm+dd;
-
- var fileName = "";
-
- // 선택된 탭에 따라서 엑셀저장될 그리드를 지정한다.
- if ( rdo_selectflag.value == "1" ) {
- fileName = window.fileDialog("save", "|", true, "일자별 가수금내역_"+tmp, "", "Excel Files(*.xls)|*.xls");
- if (fileName != "") {
- grd_depoamt1.saveExcel(fileName, "SheetName", true, true, "", "", "");
- }
- } else if ( rdo_selectflag.value == "2" ) {
- fileName = window.fileDialog("save", "|", true, "일자별sum 가수금내역_"+tmp, "", "Excel Files(*.xls)|*.xls");
- if (fileName != "") {
- grd_depoamt1.saveExcel(fileName, "SheetName", true, true, "", "", "");
- }
- } else if ( rdo_selectflag.value == "3" ) {
- fileName = window.fileDialog("save", "|", true, "접수번호별 가수금내역_"+tmp, "", "Excel Files(*.xls)|*.xls");
- if (fileName != "") {
- grd_depoamt2.saveExcel(fileName, "SheetName", true, true, "", "", "");
- }
- }
- ]]>
- </script>
- </button>
- <switch id="switch1" class="sw_box" style="left:0px; top:100px; width:1194px; height:639px; ">
- <case id="case1" selected="true">
- <datagrid id="grd_depoamt1" nodeset="/root/main/list01/griddepoamt1" class="datagrid2" caption="구분^입금일자^접수번호^입금구분^입금은행^계좌번호^입금금액" colsep="^" colwidth="100,110, 120, 100, 112, 197, 170" dataheight="25" defaultrows="1" extendlastcol="false" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:5px; top:7px; width:1184px; height:623px; ">
- <col ref="depoflag2" type="output" visibility="hidden" style="text-align:center; "/>
- <col ref="depodd" format="yyyy-mm-dd" maxlength="8" style="text-align:center; "/>
- <col ref="acptno" type="output" style="text-align:center; "/>
- <col ref="depoflag" type="output" style="text-align:center; "/>
- <col autonext="true" disabled="true" ref="bankcd" type="combo" style="text-align:center; ">
- <choices>
- <itemset nodeset="/root/init/R0001list/R0001">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- </col>
- <col ref="acntcd" type="input" style="text-align:center; "/>
- <col ref="depoamt" type="input" format="#,###" style="text-align:right; "/>
- <script type="javascript" ev:event="oncopy">
- <![CDATA[
- grid_oncopy();
- ]]>
- </script>
- </datagrid>
- </case>
- <case id="case2">
- <datagrid id="grd_depoamt2" nodeset="/root/main/list01/griddepoamt2" class="datagrid2" caption="접수번호^입금은행^계좌번호^입금금액" colsep="^" colwidth="110, 112, 197, 174" dataheight="25" defaultrows="1" extendlastcol="false" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:5px; top:7px; width:1184px; height:623px; ">
- <col ref="acptno" maxlength="8" style="text-align:center; "/>
- <col autonext="true" disabled="true" ref="bankcd" type="combo" style="text-align:center; ">
- <choices>
- <itemset nodeset="/root/init/R0001list/R0001">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- </col>
- <col ref="acntcd" type="input" style="text-align:center; "/>
- <col ref="depoamt" type="input" format="#,###" style="text-align:right; "/>
- <script type="javascript" ev:event="oncopy">
- <![CDATA[
- grid_oncopy();
- ]]>
- </script>
- </datagrid>
- </case>
- </switch>
- <button id="btn_depospecbyproc" class="btn_sw" group="tab" style="left:170px; top:79px; width:170px; height:22px; ">
- <caption>접수번호별 가수금내역</caption>
- <toggle case="case2" ev:event="onclick"/>
- </button>
- <button id="btn_depospecbyinsu" class="btn_sw" group="tab" selected="true" style="left:0px; top:79px; width:170px; height:22px; ">
- <caption>일자별 가수금내역</caption>
- <toggle case="case1" ev:event="onclick"/>
- </button>
- <button id="button2" class="btn2_letter2" style="left:1082px; top:80px; width:42px; height:19px; ">
- <caption>출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- if(btn_depospecbyinsu.selected == true){
- exeReportPreview("RPPIF31900", "XMLSTR", "","", "false","","","","","false");
- }else if(btn_depospecbyproc.selected == true) {
- exeReportPreview("RPPIF31910", "XMLSTR", "","", "false","","","","","false");
- }
- ]]>
- </script>
- </button>
- <button id="button3" class="btn5_letter9" style="left:960px; top:80px; width:119px; height:19px; ">
- <caption>가수금입금내역출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- model.makeNode("/root/print/send/srchym");
- model.makeNode("/root/print/send/rexid");
- model.makeNode("/root/print/send/userid");
- model.makeNode("/root/print/send/acntno");
-
- model.setValue("/root/print/send/rexid", "RPPIF31901");
- model.setValue("/root/print/send/userid", getUserId());
- var srchym = ipt_fromdd.value;
- model.setValue("/root/print/send/srchym", srchym.substring(0, 6));
-
- var cnt = getNodesetCount("/root/init/bankinfo/bankinfolist");
- var bankacount;
-
- for( var i = 1; i <= cnt; i++){
-
- if(model.getValue("/root/init/bankinfo/bankinfolist["+ i +"]/cdid") == "20"){
- bankacount = model.getValue("/root/init/bankinfo/bankinfolist["+ i +"]/cdnm");
- break;
- }
- }
-
- model.setValue("/root/print/send/acntno",bankacount);
-
- if(submit("TRPIF31902")){
- exeReportPreview("RPPIF31901", "XMLSTR");
- }
- ]]>
- </script>
- </button>
- </group>
- <group id="grp_btn" style="left:0px; top:757px; width:1195px; height:27px; "/>
- </xhtml:body>
- </xhtml:html>
|