YNU_JEUS/app_home/himed/xpapps/pam/rcptteamstatsxp/xp/SPPAS00770_미수총괄표.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPPAS00770" position="absolute 0 0 1200 784" titletext="미수총괄표" onload="SPPAS00770_onload">
    <Layouts>
      <Layout>
        <Div id="group2" position="absolute 0 23 1195 60" style="" class="div_SA">
          <Layouts>
            <Layout>
              <Button id="btn_search" class="btn1" position="absolute 1130 6 1186 28" style="" text="조회" onclick="group2_btn_search_onclick"/>
              <Shape id="line1" class="line_4" linetype="vertical" position="absolute 1120 6 1123 28" style="border: solid #ffe4bb #ffe4bb;" anchor="default"/>
              <Static id="caption4" class="search_name" position="absolute 10 10 101 27" style="" text="기간 :"/>
              <Calendar id="input1" position="absolute 102 9 207 28" style="" anchor="default"/>
              <Static id="caption1" position="absolute 213 11 223 26" style="align:center ;" text="~"/>
              <Calendar id="input2" position="absolute 229 9 334 28" style="" anchor="default"/>
              <Button id="button1" class="btn3" position="absolute 1035 6 1115 28" style="" text="엑셀출력" onclick="group2_button1_onclick"/>
              <Static id="caption3" class="search_name" position="absolute 370 10 445 27" style="" text="기준일:"/>
              <Calendar id="input3" position="absolute 445 9 530 28" style="" anchor="default" dateformat="yyyy-MM-dd" value="null"/>
              <Button id="button2" class="btn3" position="absolute 950 6 1030 28" style="" text="상세내역" onclick="group2_button2_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group3" position="absolute 0 0 1195 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 150 80" style="" text="미수총괄표"/>
        <Grid id="datagrid1" binddataset="ds_list_totunco" visible="false" position="absolute 220 85 1070 225" style="">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <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="1999까지"/>
                <Cell col="2" text="2000"/>
                <Cell col="3" text="2001"/>
                <Cell col="4" text="2002"/>
                <Cell col="5" text="2003"/>
                <Cell col="6" text="2004"/>
                <Cell col="7" text="2005"/>
                <Cell col="8" text="2006"/>
                <Cell col="9" text="2007"/>
                <Cell col="10" text="2008"/>
                <Cell col="11" text="2009"/>
                <Cell col="12" text="2010"/>
                <Cell col="13" text="2011"/>
                <Cell col="14" text="2012"/>
                <Cell col="15" text="2013"/>
                <Cell col="16" text="2014"/>
                <Cell col="17" text="합계"/>
              </Band>
              <Band id="body">
                <Cell text="bind:nm"/>
                <Cell col="1" text="bind:y99"/>
                <Cell col="2" text="bind:y00"/>
                <Cell col="3" text="bind:y01"/>
                <Cell col="4" text="bind:y02"/>
                <Cell col="5" text="bind:y03"/>
                <Cell col="6" text="bind:y04"/>
                <Cell col="7" text="bind:y05"/>
                <Cell col="8" text="bind:y06"/>
                <Cell col="9" text="bind:y07"/>
                <Cell col="10" text="bind:y08"/>
                <Cell col="11" text="bind:y09"/>
                <Cell col="12" text="bind:y10"/>
                <Cell col="13" text="bind:y11"/>
                <Cell col="14" text="bind:y12"/>
                <Cell col="15" text="bind:y13"/>
                <Cell col="16" text="bind:y14"/>
                <Cell col="17" text="bind:tot"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Tab id="switch1" position="absolute 8 84 1193 739" style="buttonbackground:stretch 10,10;background:white stretch 10,26;" anchor="default">
          <Tabpages>
            <Tabpage id="case1" anchor="default"/>
          </Tabpages>
        </Tab>
        <Div id="group1" position="absolute 5 760 1190 775" style=""/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_list_totunco" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <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_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="init" type="STRING" size="256"/>
        </ColumnInfo>
      </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="condd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="condd"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.input1" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item1" compid="group2.input2" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item2" compid="group2.input3" propid="value" datasetid="ds_send" columnid="condd"/>
    </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 SPPAS00770_onload(obj: Form, e: LoadEventInfo) {
  frmf_initForm(obj);
  grdf_initGrid(this.datagrid1);

  ds_send.setColumn(0, "fromdd", "19000101");
  ds_send.setColumn(0, "todd", utlf_getCurrentDate());
  ds_send.setColumn(0, "condd", utlf_getCurrentDate());
}

function group2_btn_search_onclick(obj: Button, e: ClickEventInfo) {
  var oParam = {};
  oParam.id = "TRPAS00850";
  oParam.service = "rcptteamstatsapp.rcptTeamOrdStats";
  oParam.method = "reqGetTotalUncoTable";
  oParam.inds = "req=ds_send";
  oParam.outds = "ds_list_totunco=totunco";
  oParam.async = false;

  tranf_submit(oParam);

  var objDOM = rptf_createDOM();
  var objParam = new Object();
  rptf_setNodeListToDOM(objDOM, "root/list/totunco", ds_list_totunco);
  objParam.xml_data_XML1 = objDOM.documentElement.source;
  var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
  rptf_exeReportPreview30(["RPPAS00780"], [objParam], option);

}

function group2_button1_onclick(obj: Button, e: ClickEventInfo) {
  if (ds_list_totunco.rowcount < 1) {
    ds_list_totunco.clearData();

    var oParam = {};
    oParam.id = "TRPAS00850";
    oParam.service = "rcptteamstatsapp.rcptTeamOrdStats";
    oParam.method = "reqGetTotalUncoTable";
    oParam.inds = "req=ds_send";
    oParam.outds = "ds_list_totunco=totunco";
    oParam.async = false;
    tranf_submit(oParam);
  }
  grdf_exportExcel(datagrid1, "미수총괄표", "Sheet1", true, "", 'user', true);
}

function group2_button2_onclick(obj: Button, e: ClickEventInfo) {
  frmf_open("SPPAS00721", "SPPAS00721", "", "", "", "", "", "", "", "", "", "", "M");
}
]]></Script>
  </Form>
</FDL>