YNU_JEUS/app_home/himed/xpapps/pam/rcptteamstatsxp/xp/SPPAS00771_미수총괄표(NEW).xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPPAS00771" position="absolute 0 0 1200 784" titletext="미수총괄표" onload="SPPAS00771_onload">
    <Layouts>
      <Layout>
        <Div id="group2" position="absolute 0 23 1195 60" style="" class="div_SA">
          <Layouts>
            <Layout>
              <Button id="btn_search" class="btn1_letter2" position="absolute 1130 7 1186 29" 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 210 11 230 26" style="align:center ;" text="~"/>
              <Calendar id="input2" position="absolute 230 9 335 28" style="" anchor="default"/>
              <Button id="button1" class="btn3_letter4" position="absolute 1035 7 1115 29" 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"/>
              <Button id="button2" class="btn3_letter4" position="absolute 950 7 1030 29" 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 83" 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 7 85 1192 740" 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" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="totunco" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="totunco"/>
          </Row>
        </Rows>
      </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 SPPAS00771_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	grdf_initGrid(this.datagrid1); 
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	
	ds_send.setColumn( 0, "fromdd" 	, "19000101");
	ds_send.setColumn( 0, "todd" 		, utlf_getCurrentDate());
	ds_send.setColumn( 0, "condd" 		, utlf_getCurrentDate());
	//group2.btn_search.dispatch("DOMActivate");

	//model.refresh();

}

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

	//submit("TRPAS00851");
	var oParam = {};
		oParam.id          = "TRPAS00851";
		oParam.service     = "rcptteamstatsapp.rcptTeamOrdStats";
		oParam.method      = "reqGetTotalUncoTable_New";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_list_totunco=totunco";
		oParam.async       = false;
		oParam.callback    = "cf_TRPAS00851";

	tranf_submit(oParam);

	//exeReportPreview("RPPAS00780", "XMLSTR", "","","false", "", "", "", "", "false", "",  "switch1.case1");
	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 ){
		//							submit("TRPAS00851");
		var oParam = {};
			oParam.id          = "TRPAS00851";
			oParam.service     = "rcptteamstatsapp.rcptTeamOrdStats";
			oParam.method      = "reqGetTotalUncoTable_New";
			oParam.inds        = "req=ds_send";
			oParam.outds       = "ds_list_totunco=totunco";
			oParam.async       = false;
		tranf_submit(oParam);


	}
	//var fileName = window.fileDialog("save", ",", false, "미수총괄표", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");		
	//if(fileName != ""){
		//datagrid1.saveExcel(fileName, "SheetName", false, false, "", "", "false");
		grdf_exportExcel(datagrid1, "Sheet1", "미수총괄표", false, "" , 'user' , true);
	//}

}

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

	frmf_open("SPPAS00721", "SPPAS00721", "", "", "", "", "", "", "", "", "", "", "M");
	//	frmf_open("SPPAS00721", "", ""-"", "", "2", "200", "", "", "", "width:840px; height:950px; caption:visible; resize:false;", "", "", "M");

}

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