YNU_JEUS/app_home/himed/xpapps/pam/pamendstatsxp/xp/SMPAE00202_무인수납기수납내역.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPAE00202" position="absolute 0 0 1195 785" titletext="무인수납기 수납 내역" onload="SMPAE00202_onload">
    <Layouts>
      <Layout>
        <Div id="grp" taborder="4" position="absolute 0 25 1195 60" class="div_SA2">
          <Layouts>
            <Layout>
              <Button id="btn_search" taborder="0" text="조회" onclick="btn_search_onclick" class="btn1" position="absolute 1135 5 1191 30" anchor="default"/>
              <Static id="caption35" text="수납일자 :" class="search_name" position="absolute 5 5 79 30" anchor="default"/>
              <Calendar id="ipt_fromdd" taborder="1" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" position="absolute 89 5 179 30" anchor="default"/>
              <Static id="caption4" text="~" position="absolute 182 5 197 30" style="align:center ;" anchor="default"/>
              <Calendar id="ipt_todd" taborder="2" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" position="absolute 200 5 290 30" anchor="default"/>
              <CheckBox id="chk_magmflag" taborder="3" text="마감 건수 조회" truevalue="Y" position="absolute 315 5 420 30" innerdataset="[object Dataset]" datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">Y</Col>
                      <Col id="datacolumn">마감 건수 조회</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </CheckBox>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption6" class="tit_1" position="absolute 0 0 160 25" style="" text="무인수납기 수납 내역"/>
        <Static id="caption77" class="tit_2" position="absolute 0 70 112 89" style="" text="무인 수납 내역"/>
        <Grid id="grd_rcpt" binddataset="ds_main_rcptlist_rcptinfo" position="absolute 0 90 1195 780" style="">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="70" band="left"/>
                <Column size="42" band="left"/>
                <Column size="70" band="left"/>
                <Column size="70" band="left"/>
                <Column size="80" band="left"/>
                <Column size="80" band="left"/>
                <Column size="42"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="42"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="42"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="42"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" text="무인수납기" taborder="undefined"/>
                <Cell col="1" colspan="5" text="합계" taborder="undefined"/>
                <Cell col="6" colspan="3" text="접수" taborder="undefined"/>
                <Cell col="9" colspan="3" text="예약" taborder="undefined"/>
                <Cell col="12" colspan="3" text="수납" taborder="undefined"/>
                <Cell col="15" rowspan="2" text="미수금" taborder="undefined"/>
                <Cell col="16" colspan="3" text="미수입금" taborder="undefined"/>
                <Cell col="19" rowspan="2" text="차상위" taborder="undefined"/>
                <Cell col="20" rowspan="2" text="희귀난치" taborder="undefined"/>
                <Cell col="21" rowspan="2" text="건강유지비" taborder="undefined"/>
                <Cell col="22" rowspan="2" text="산전지원금" taborder="undefined"/>
                <Cell col="23" text="무인수납기"/>
                <Cell col="24" text="건수"/>
                <Cell col="25" text="사용률(%)"/>
                <Cell col="26" text="점유율(%)"/>
                <Cell col="27" text="현금"/>
                <Cell col="28" text="카드"/>
                <Cell col="29" text="건수"/>
                <Cell col="30" text="현금"/>
                <Cell col="31" text="카드"/>
                <Cell col="32" text="건수"/>
                <Cell col="33" text="현금"/>
                <Cell col="34" text="카드"/>
                <Cell col="35" text="건수"/>
                <Cell col="36" text="현금"/>
                <Cell col="37" text="카드"/>
                <Cell col="38" text="미수금"/>
                <Cell col="39" text="건수"/>
                <Cell col="40" text="현금"/>
                <Cell col="41" text="카드"/>
                <Cell col="42" text="차상위"/>
                <Cell col="43" text="희귀난치"/>
                <Cell col="44" text="건강유지비"/>
                <Cell col="45" text="산전지원금"/>
                <Cell row="1" col="1" text="건수"/>
                <Cell row="1" col="2" text="사용률(%)"/>
                <Cell row="1" col="3" text="점유율(%)"/>
                <Cell row="1" col="4" text="현금"/>
                <Cell row="1" col="5" text="카드"/>
                <Cell row="1" col="6" text="건수"/>
                <Cell row="1" col="7" text="현금"/>
                <Cell row="1" col="8" text="카드"/>
                <Cell row="1" col="9" text="건수"/>
                <Cell row="1" col="10" text="현금"/>
                <Cell row="1" col="11" text="카드"/>
                <Cell row="1" col="12" text="건수"/>
                <Cell row="1" col="13" text="현금"/>
                <Cell row="1" col="14" text="카드"/>
                <Cell row="1" col="16" text="건수"/>
                <Cell row="1" col="17" text="현금"/>
                <Cell row="1" col="18" text="카드"/>
              </Band>
              <Band id="body">
                <Cell style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:ktrmnno"/>
                <Cell col="1" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:tot_cnt"/>
                <Cell col="2" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:userate"/>
                <Cell col="3" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:occrate"/>
                <Cell col="4" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:tot_cashamt"/>
                <Cell col="5" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:tot_cardamt"/>
                <Cell col="6" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:acpt_cnt"/>
                <Cell col="7" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:acpt_cashamt"/>
                <Cell col="8" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:acpt_cardamt"/>
                <Cell col="9" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:rsrv_cnt"/>
                <Cell col="10" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:rsrv_cashamt"/>
                <Cell col="11" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:rsrv_cardamt"/>
                <Cell col="12" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:rcpt_cnt"/>
                <Cell col="13" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:rcpt_cashamt"/>
                <Cell col="14" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:rcpt_cardamt"/>
                <Cell col="15" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:uncoamt"/>
                <Cell col="16" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:uncr_cnt"/>
                <Cell col="17" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:uncr_cashamt"/>
                <Cell col="18" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:uncr_cardamt"/>
                <Cell col="19" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:rareobstamt"/>
                <Cell col="20" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:suppamt"/>
                <Cell col="21" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:heallifeamtclamamt"/>
                <Cell col="22" displaytype="number" style="background:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');background2:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? '#ffffc8ff' : '');font:EXPR(getColumn(currow, 'ktrmnno') == '합계' ? 'Dotum,9,bold' : 'Dotum,9');" text="bind:pregdmndamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_xls" class="btn2" position="absolute 1150 64 1195 89" text="엑셀" onclick="btn_xls_onclick"/>
        <Button id="btn_prt" class="btn2" position="absolute 1105 64 1149 89" text="출력" onclick="btn_prt_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_rcptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_main_rcptlist_rcptinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="ktrmnno" type="STRING" size="256"/>
          <Column id="tot_cnt" type="STRING" size="256"/>
          <Column id="userate" type="STRING" size="256"/>
          <Column id="occrate" type="STRING" size="256"/>
          <Column id="tot_cashamt" type="STRING" size="256"/>
          <Column id="tot_cardamt" type="STRING" size="256"/>
          <Column id="acpt_cnt" type="STRING" size="256"/>
          <Column id="acpt_cashamt" type="STRING" size="256"/>
          <Column id="acpt_cardamt" type="STRING" size="256"/>
          <Column id="rsrv_cnt" type="STRING" size="256"/>
          <Column id="rsrv_cashamt" type="STRING" size="256"/>
          <Column id="rsrv_cardamt" type="STRING" size="256"/>
          <Column id="rcpt_cnt" type="STRING" size="256"/>
          <Column id="rcpt_cashamt" type="STRING" size="256"/>
          <Column id="rcpt_cardamt" type="STRING" size="256"/>
          <Column id="uncoamt" type="STRING" size="256"/>
          <Column id="uncr_cnt" type="STRING" size="256"/>
          <Column id="uncr_cashamt" type="STRING" size="256"/>
          <Column id="uncr_cardamt" type="STRING" size="256"/>
          <Column id="rareobstamt" type="STRING" size="256"/>
          <Column id="suppamt" type="STRING" size="256"/>
          <Column id="heallifeamtclamamt" type="STRING" size="256"/>
          <Column id="pregdmndamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="ktrmnno"/>
            <Col id="tot_cnt"/>
            <Col id="userate"/>
            <Col id="occrate"/>
            <Col id="tot_cashamt"/>
            <Col id="tot_cardamt"/>
            <Col id="acpt_cnt"/>
            <Col id="acpt_cashamt"/>
            <Col id="acpt_cardamt"/>
            <Col id="rsrv_cnt"/>
            <Col id="rsrv_cashamt"/>
            <Col id="rsrv_cardamt"/>
            <Col id="rcpt_cnt"/>
            <Col id="rcpt_cashamt"/>
            <Col id="rcpt_cardamt"/>
            <Col id="uncoamt"/>
            <Col id="uncr_cnt"/>
            <Col id="uncr_cashamt"/>
            <Col id="uncr_cardamt"/>
            <Col id="rareobstamt"/>
            <Col id="suppamt"/>
            <Col id="heallifeamtclamamt"/>
            <Col id="pregdmndamt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_report" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_report_prtinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="prtdt" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="endid" type="STRING" size="256"/>
          <Column id="enddd" type="STRING" size="256"/>
          <Column id="magmflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="endid"/>
            <Col id="enddd"/>
            <Col id="magmflag"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item1" compid="grp.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item2" compid="grp.chk_magmflag" propid="value" datasetid="ds_send" columnid="magmflag"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[include 'com_commonxp::comm_main.xjs';

var arErrorCode = new HashArray();

function SMPAE00202_onload(obj:Form, e:LoadEventInfo) {
	
	frmf_initForm(obj); 
	
	grdf_initGrid(this.grd_rcpt); 
	
	var fromdd = opener.frmf_getParameter("SMPAE00202_fromdd");
	
	if (utlf_isNull(fromdd)) {
		var fromdd = utlf_getCurrentDate();	
	}
	
	ds_send.setColumn(0, "fromdd", fromdd);
	ds_send.setColumn(0, "todd",   fromdd);
	ds_send.setColumn(0, "enddd",  utlf_getCurrentDate());
	
	grp.btn_search.click(); 
}

function btn_search_onclick(obj:Button, e:ClickEventInfo) {

	var oParam = {};
	oParam.id      = "TRPAE00112";
	oParam.service = "pamendstatsapp.PamEndStats";
	oParam.method  = "reqGetKioskRcptList";
	oParam.inds    = "req=ds_send";
	oParam.outds   = "ds_main_rcptlist_rcptinfo=rcptinfo";
	oParam.async   = false;
	
	tranf_submit(oParam);
}

function btn_xls_onclick(obj:Button, e:ClickEventInfo) {
	grdf_exportExcel(grd_rcpt, "무인수납기 수납내역", "Sheet1", true, "" , 'user' , true);
}

function btn_prt_onclick(obj:Button, e:ClickEventInfo) {
	
	var oParam = {};
	oParam.id      = "TRPAE00107";
	oParam.service = "pamendstatsapp.PamEndStats";
	oParam.method  = "reqGetRcptPrtInfo";
	oParam.inds    = "req=ds_send";
	oParam.outds   = "ds_report_prtinfo=prtinfo";
	oParam.async   = false;
	
	tranf_submit(oParam);
	
	dsf_makeValue(ds_report_prtinfo, "fromdd", "STRING", ds_send.getColumn(0, "fromdd"));
	dsf_makeValue(ds_report_prtinfo, "todd",   "STRING", ds_send.getColumn(0, "todd"));
	
	var objDOM = rptf_createDOM();
	var objParam = new Object();
	
	rptf_setNodeListToDOM(objDOM, "root/main/rcptlist/rcptinfo", ds_main_rcptlist_rcptinfo);
	rptf_setNodeListToDOM(objDOM, "root/report/prtinfo",         ds_report_prtinfo);
	
	objParam.xml_data_XML1 	= objDOM.documentElement.source;
	
	var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
	
	rptf_exeReportPreview30(["RPPAE00103"],[objParam], option);
}]]></Script>
  </Form>
</FDL>