YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SPRSD08401_세금계산서중복조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPRSD08401" position="absolute 0 0 706 454" titletext="임차장비 리스트" oninit="SPRSD08401_oninit" onload="SPRSD08401_onload">
    <Layouts>
      <Layout>
        <Shape id="line1" class="line_10" position="absolute -1 30 699 36"/>
        <Grid id="grd_taxulist" taborder="1" binddataset="ds_main_taxulist" useinputpanel="false" position="absolute -1 35 699 422" autoenter="select" autofittype="col" cellsizingtype="col" oncelldblclick="grd_taxulist_oncelldblclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="150"/>
                <Column size="60"/>
                <Column size="120"/>
                <Column size="60"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="기준일자"/>
                <Cell col="2" text="작성일자"/>
                <Cell col="3" text="사업자등록번호"/>
                <Cell col="4" text="상호"/>
                <Cell col="5" text="대표자"/>
                <Cell col="6" text="총금액"/>
                <Cell col="7" text="중복건수"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="date" text="bind:basedd" mask="yyyy-MM" calendardisplaynulltype="nulltext"/>
                <Cell col="2" displaytype="date" text="bind:acptdd" mask="yyyy-MM" calendardisplaynulltype="nulltext"/>
                <Cell col="3" displaytype="date" text="bind:entrregno" calendardisplaynulltype="nulltext"/>
                <Cell col="4" text="bind:cmpynm" maskchar="-"/>
                <Cell col="5" text="bind:prsdnm"/>
                <Cell col="6" displaytype="number" text="bind:totamt"/>
                <Cell col="7" text="bind:cnt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption1" text="국세청 세금계산서 중복리스트" class="tit_2" position="absolute 0 -1 240 20"/>
        <Button id="button3" taborder="2" text="Excel 저장" class="btn5" position="absolute 621 11 696 30" onclick="button3_onclick"/>
        <Shape id="line32" class="line_6" position="absolute 0 421 700 427"/>
        <Button id="btn_cancel" taborder="3" text="닫기" class="btn4" position="absolute 643 425 699 447" onclick="btn_cancel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_taxulist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="basedd" type="STRING" size="256" sumtext="기준일자"/>
          <Column id="acptdd" type="STRING" size="256" sumtext="작성일자(검수일자)"/>
          <Column id="entrregno" type="STRING" size="256" sumtext="사업자등록번호"/>
          <Column id="cmpynm" type="STRING" size="256" sumtext="상호"/>
          <Column id="prsdnm" type="STRING" size="256" sumtext="대표자"/>
          <Column id="totamt" type="STRING" size="256" sumtext="합계금액"/>
          <Column id="cnt" type="STRING" size="256" sumtext="중복건수"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="ubasedd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="ubasedd"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-06-19
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
function SPRSD08401_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPRSD08401_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_taxulist);
	try
	{
		ds_init.copyData(arg_ds_init);
	}
	catch(e)
	{
	}
	
	fInitialize();
}

function fInitialize()
{
	ds_send.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_send.setColumn(0, "ubasedd", ds_init.getColumn(0, "ubasedd"));
	
	misfGridInit(grd_taxulist);
	
	var oParam = {};
		oParam.id          = "TRRSC08402";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetProTaxLst";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_taxulist=taxulist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRSC08402";

	tranf_submit(oParam);
}		

function grd_taxulist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	var basedd  = ds_main_taxulist.getColumn(ds_main_taxulist.rowposition, "basedd");
	var acptdd  = ds_main_taxulist.getColumn(ds_main_taxulist.rowposition, "acptdd");
	var entrregno  = ds_main_taxulist.getColumn(ds_main_taxulist.rowposition, "entrregno");
	var totamt  = ds_main_taxulist.getColumn(ds_main_taxulist.rowposition, "totamt");

	var receiveref = eval("opener.ds_copynode");
	
	if (frmf_checkOpener())
	{
		opener.dsf_makeValue(receiveref, "para_basedd", "string", basedd, 0);
		opener.dsf_makeValue(receiveref, "para_acptdd", "string", acptdd, 0);
		opener.dsf_makeValue(receiveref, "para_entrregno", "string", entrregno, 0);
		opener.dsf_makeValue(receiveref, "para_totamt", "string", totamt, 0);
		opener.dsf_makeValue(receiveref, "para_flag", "string", "F", 0);								
	}
	else 
	{
		var rtn = sysf_messageBox("상위화면을 찾을 수", "E001");
	}
	this.close();		
}

function btn_cancel_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();	
}

function button3_onclick(obj:Button,  e:ClickEventInfo)
{
	if( ds_main_taxulist.rowcount > 0)
	{
		grdf_exportExcel(grd_taxulist, "세금계산서 검증리스트_" + utlf_getCurrentDate(), "세금계산서 검증", "true", "", "");
	} 
	else 
	{
		sysf_messageBox("저장 데이터가","I004");
	}
}
]]></Script>
  </Form>
</FDL>