YNU_JEUS/app_home/himed/xpapps/pam/rcptteamstatsxp/xp/SPPAS00730_년도별미수조회및출력.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPPAS00730" position="absolute 0 0 800 796" titletext="미수금 조회 및 출력" onload="SPPAS00730_onload">
    <Layouts>
      <Layout>
        <Div id="group2" position="absolute 0 23 800 60" style="" class="div_SA">
          <Layouts>
            <Layout width="800" height="37">
              <Button id="btn_search" class="btn1" position="absolute 730 8 786 30" style="" text="조회" onclick="group2_btn_search_onclick"/>
              <Shape id="line1" class="line_4" linetype="vertical" position="absolute 720 8 723 30" style="border: solid #ffe4bb #ffe4bb;" anchor="default"/>
              <Static id="caption4" class="search_name" position="absolute 10 10 101 27" style="" text="미수기간 :"/>
              <Calendar id="input1" mask="yyyy" position="absolute 102 9 207 28" style="" anchor="default" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" value="null"/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group3" position="absolute 0 0 800 25" style="">
          <Layouts>
            <Layout>
              <Static id="caption60" class="tit_1" position="absolute 0 0 183 23" style="align:left middle;font:Dotum,9,bold;" text="미수 조회및 출력"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption2" class="tit_2" position="absolute 10 66 117 82" style="" text="미수내역 현황"/>
        <Button id="button1" class="btn2" position="absolute 683 64 725 83" style="" text="출력" onclick="button1_onclick"/>
        <Grid id="grd_uncolist" binddataset="ds_list_uncolist" position="absolute 0 85 795 780" style="align:center ;">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="76"/>
                <Column size="120"/>
                <Column size="100"/>
                <Column size="100"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="년도"/>
                <Cell col="1" text="등록번호"/>
                <Cell col="2" text="성명"/>
                <Cell col="3" text="발생일자"/>
                <Cell col="4" text="총금액"/>
                <Cell col="5" text="미납금"/>
              </Band>
              <Band id="body">
                <Cell text="bind:yyyy"/>
                <Cell col="1" text="bind:pid"/>
                <Cell col="2" text="bind:hngnm"/>
                <Cell col="3" displaytype="date" text="bind:rcptexecdd" mask="yyyy-MM-dd hh:mm:ss" calendardisplaynulltype="none"/>
                <Cell col="4" displaytype="number" text="bind:uncoamt" mask="9,999"/>
                <Cell col="5" displaytype="number" text="bind:rcptamt" mask="9,999"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="button2" class="btn2" position="absolute 729 64 793 83" style="" text="엑셀저장" onclick="button2_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="uncolist" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_source" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="source" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="source"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="main" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="main"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_result" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="result" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="result"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="temp" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="temp"/>
          </Row>
        </Rows>
      </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="sendflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="sendflag"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.input1" propid="value" datasetid="ds_send" columnid="fromdd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[include 'com_commonxp::comm_main.xjs';
include 'com_basiccodexp::ZBC001.xjs';
include 'com_zipcodexp::ZBP001.xjs';
include 'pam_outordamtmngtxp::SMPAO00100.xjs';

function SPPAS00730_onload(obj: Form, e: LoadEventInfo) {
  frmf_initForm(obj);
  grdf_setGridSort(grd_uncolist);

  ds_send.setColumn(0, "sendflag", "yyyy");
}

function group2_btn_search_onclick(obj: Button, e: ClickEventInfo) {
  ds_list_uncolist.clearData();
  
  var oParam = {};
  oParam.id = "TRPAS00810";
  oParam.service = "rcptteamstatsapp.rcptTeamOrdStats";
  oParam.method = "reqGetUncoPrint";
  oParam.inds = "req=ds_send";
  oParam.outds = "ds_list_uncolist=uncolist";
  oParam.async = false;
  tranf_submit(oParam);

}

function button2_onclick(obj: Button, e: ClickEventInfo) {
  grdf_exportExcel(grd_uncolist, "년도별미수조회및출력", "Sheet1", true, "", 'user', true);
}


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

}
]]></Script>
  </Form>
</FDL>