YNU_JEUS/app_home/himed/xpapps/ast/healexamstatxp/xp/SMAHS02400_수입금명세서.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHS02400" position="absolute 0 0 1206 774" titletext="수입금명세서" oninit="SMAHS02400_oninit" onload="SMAHS02400_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 26 1203 61" id="group2" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static text="건진일자 :" position="absolute 10 10 82 27" id="caption1" class="search_name" anchor="left top"/>
              <Shape position="absolute 1129 7 1135 29" linetype="vertical" id="line2" class="line_4" anchor="top right"/>
              <Button position="absolute 1139 7 1195 29" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Button position="absolute 1046 7 1126 29" id="btn_excelsave" class="btn7" visible="true" text="액셀저장" anchor="top right" onclick="group2_btn_excelsave_onclick"/>
              <Calendar position="absolute 102 8 207 27" id="ipt_fromdd" class="input_search" taborder="7" anchor="left top" autoselect="true" autoskip="true"/>
              <Calendar position="absolute 232 8 337 27" id="ipt_todd" class="input_search" taborder="7" anchor="left top" autoselect="true" autoskip="true"/>
              <Static id="caption2" text="~" position="absolute 214 12 229 27" anchor="left top"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid position="absolute 1 63 1204 770" align="align:center middle;" id="grd_earnspeclst" binddataset="ds_main_earnspeclst_item" autofittype="col" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="80"/>
                <Column size="60"/>
                <Column size="90"/>
                <Column size="90"/>
                <Column size="60"/>
                <Column size="90"/>
                <Column size="90"/>
                <Column size="60"/>
                <Column size="90"/>
                <Column size="90"/>
                <Column size="90"/>
                <Column size="80"/>
                <Column size="110"/>
                <Column size="110"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" text="건진일자" taborder="undefined"/>
                <Cell col="1" colspan="3" text="비자건진" taborder="undefined"/>
                <Cell col="4" colspan="3" text="채용건진" taborder="undefined"/>
                <Cell col="7" colspan="4" text="공단건진" taborder="undefined"/>
                <Cell col="11" colspan="3" text="합계" taborder="undefined"/>
                <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="수납금액"/>
              </Band>
              <Band id="body">
                <Cell displaytype="normal" style="align:center middle;" text="bind:hopedd"/>
                <Cell col="1" displaytype="normal" style="align:center middle;" text="bind:visacnt"/>
                <Cell col="2" displaytype="normal" style="align:center middle;" text="bind:visatotamt"/>
                <Cell col="3" displaytype="normal" style="align:center middle;" text="bind:visarcptamt"/>
                <Cell col="4" displaytype="normal" style="align:center middle;" text="bind:appcnt"/>
                <Cell col="5" displaytype="normal" style="align:center middle;" text="bind:apptotamt"/>
                <Cell col="6" displaytype="normal" style="align:center middle;" text="bind:apprcptamt"/>
                <Cell col="7" displaytype="normal" style="align:center middle;" text="bind:gnrlcnt"/>
                <Cell col="8" displaytype="normal" style="align:center middle;" text="bind:gnrltotamt"/>
                <Cell col="9" displaytype="normal" style="align:center middle;" text="bind:gnrluncoamt"/>
                <Cell col="10" displaytype="normal" style="align:center middle;" text="bind:gnrlrcptamt"/>
                <Cell col="11" displaytype="normal" style="align:center middle;" text="bind:totcnt"/>
                <Cell col="12" displaytype="normal" style="align:center middle;" text="bind:totamt"/>
                <Cell col="13" displaytype="normal" style="align:center middle;" text="bind:totrcptamt"/>
              </Band>
              <Band id="summary">
                <Cell text="총계"/>
                <Cell col="1" displaytype="number" style="align:center middle;" text="expr:getSum('visacnt')" mask="@@@,@@@,@@@"/>
                <Cell col="2" displaytype="number" style="align:center middle;" text="expr:getSum('visatotamt')" mask="@@@,@@@,@@@"/>
                <Cell col="3" displaytype="number" style="align:center middle;" text="expr:getSum('visarcptamt')" mask="@@@,@@@,@@@"/>
                <Cell col="4" displaytype="number" style="align:center middle;" text="expr:getSum('appcnt')" mask="@@@,@@@,@@@"/>
                <Cell col="5" displaytype="number" style="align:center middle;" text="expr:getSum('apptotamt')" mask="@@@,@@@,@@@"/>
                <Cell col="6" displaytype="number" style="align:center middle;" text="expr:getSum('apprcptamt')" mask="@@@,@@@,@@@"/>
                <Cell col="7" displaytype="number" style="align:center middle;" text="expr:getSum('gnrlcnt')" mask="@@@,@@@,@@@"/>
                <Cell col="8" displaytype="number" style="align:center middle;" text="expr:getSum('gnrltotamt')" mask="@@@,@@@,@@@"/>
                <Cell col="9" displaytype="number" style="align:center middle;" text="expr:getSum('gnrluncoamt')" mask="@@@,@@@,@@@"/>
                <Cell col="10" displaytype="number" style="align:center middle;" text="expr:getSum('gnrlrcptamt')" mask="@@@,@@@,@@@"/>
                <Cell col="11" displaytype="number" style="align:center middle;" text="expr:getSum('totcnt')" mask="@@@,@@@,@@@"/>
                <Cell col="12" displaytype="number" style="align:center middle;" text="expr:getSum('totamt')" mask="@@@,@@@,@@@"/>
                <Cell col="13" displaytype="number" style="align:center middle;" text="expr:getSum('totrcptamt')" mask="@@@,@@@,@@@"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption60" text="수입금명세서" class="tit_1" position="absolute 0 0 183 25" anchor="left top"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_earnspeclst_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="hopedd" type="STRING"/>
          <Column id="visacnt" type="STRING"/>
          <Column id="visatotamt" type="STRING"/>
          <Column id="visarcptamt" type="STRING"/>
          <Column id="appcnt" type="STRING"/>
          <Column id="apptotamt" type="STRING"/>
          <Column id="apprcptamt" type="STRING"/>
          <Column id="gnrlcnt" type="STRING"/>
          <Column id="gnrltotamt" type="STRING"/>
          <Column id="gnrluncoamt" type="STRING"/>
          <Column id="gnrlrcptamt" type="STRING"/>
          <Column id="totcnt" type="STRING"/>
          <Column id="totamt" type="STRING"/>
          <Column id="totrcptamt" type="STRING"/>
        </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="srchfromdd" type="STRING" size="256"/>
          <Column id="srchtodd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.ipt_fromdd" propid="value" datasetid="ds_send" columnid="srchfromdd"/>
      <BindItem id="item1" compid="group2.ipt_todd" propid="value" datasetid="ds_send" columnid="srchtodd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-11-13
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-11-13      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/

include "com_commonxp::comm_main.xjs";
include "com_basiccodexp::ZBC001.xjs";
include "com_zipcodexp::ZBP001.xjs";

function SMAHS02400_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAHS02400_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_earnspeclst);
	ds_send.setColumn(0, "srchfromdd", utlf_getCurrentDate());
	ds_send.setColumn(0, "srchtodd", utlf_getCurrentDate());
	ds_send.setColumn(0, "srchfromdd", "20180101");
	ds_send.setColumn(0, "srchtodd", "20180105");
	group2.btn_search.click();
}

function group2_btn_excelsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_earnspeclst, "수입금명세서", "sheet1", false);
}

function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRAHS02401";
		oParam.service     = "healexamstatapp.StatRef";
		oParam.method      = "reqGetSumEarnSpecList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_earnspeclst_item=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAHS02401";
	tranf_submit(oParam);
}
]]></Script>
  </Form>
</FDL>