YNU_JEUS/app_home/himed/xpapps/mis/dligclaznsmngtxp/xp/SMRPD12300_해외연수기간별조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRPD12300" position="absolute 0 0 1201 799" titletext="근태 집계 조회" oninit="SMRPD12300_oninit" onload="SMRPD12300_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="해외연수기간별조회" class="tit_1" position="absolute 0 0 304 25"/>
        <Shape id="line4" class="line_6" position="absolute 0 43 1195 49" anchor="left top right"/>
        <Div id="group4" anchor="left top right" taborder="1" class="div_SA2" position="absolute 0 47 1195 87">
          <Layouts>
            <Layout>
              <Static id="caption1" text="기간 :" class="search_name" position="absolute 30 12 116 29"/>
              <Calendar id="ipt_dutym" taborder="1" class="input_search" position="absolute 95 10 200 29" mask="yyyy-mm-dd" autoskip="true" autoselect="true"/>
              <Static id="caption3" text="~" position="absolute 206 14 221 26"/>
              <Calendar id="input1" taborder="2" class="input_search" position="absolute 220 10 325 29" mask="yyyy-mm-dd" autoskip="true" autoselect="true"/>
              <Button id="btn_search" taborder="3" text="조회" class="btn1" position="absolute 1125 9 1181 31" onclick="group4_btn_search_onclick" anchor="top right"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1107 8 1113 30" anchor="top right"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_excsave" taborder="2" text="엑셀저장" class="btn7" position="absolute 1115 101 1195 120" onclick="btn_excsave_onclick" anchor="top right"/>
        <Static id="caption278" text="해외연수내역" class="tit_2" position="absolute 0 104 162 126"/>
        <Shape id="line207" class="line_10" position="absolute 0 120 1195 126" anchor="left top right"/>
        <Grid id="grd_dutsumlist" taborder="3" binddataset="ds_main_list_dutsumlist" useinputpanel="false" position="absolute 0 125 1195 792" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24"/>
                <Column size="122"/>
                <Column size="67"/>
                <Column size="85"/>
                <Column size="85"/>
                <Column size="90"/>
                <Column size="100"/>
                <Column size="332"/>
                <Column size="162"/>
                <Column size="110"/>
              </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="기간(from-to)"/>
                <Cell col="5" text="기간(from-to)"/>
                <Cell col="6" text="국가"/>
                <Cell col="7" text="교육목적"/>
                <Cell col="8" text="교육기관"/>
                <Cell col="9" text="지급액"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" style="align:left middle;padding:0 0 0 5;" text="bind:stdkind"/>
                <Cell col="2" style="align:left middle;padding:0 0 0 5;" text="bind:emplno"/>
                <Cell col="3" style="align:left middle;padding:0 0 0 5;" text="bind:emplnm"/>
                <Cell col="4" displaytype="date" text="bind:giganfrom" calendardisplaynulltype="nulltext"/>
                <Cell col="5" displaytype="date" text="bind:giganto" calendardisplaynulltype="nulltext"/>
                <Cell col="6" style="align:left middle;padding:0 0 0 5;" text="bind:nationcd"/>
                <Cell col="7" style="align:left middle;padding:0 0 0 5;" text="bind:stdobject"/>
                <Cell col="8" text="bind:gigwancd"/>
                <Cell col="9" displaytype="number" text="bind:jigeubamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_retrparams" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_dutsumlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="giganfrom" type="STRING" size="256" sumtext="시작일자"/>
          <Column id="giganto" type="STRING" size="256" sumtext="종료일자"/>
          <Column id="stdkind" type="STRING" size="256" sumtext="교육종류"/>
          <Column id="nationcd" type="STRING" size="256" sumtext="국가"/>
          <Column id="stdobject" type="STRING" size="256" sumtext="교육목적"/>
          <Column id="gigwancd" type="STRING" size="256" sumtext="교육기관"/>
          <Column id="jigeubamt" type="STRING" size="256" sumtext="지급액"/>
          <Column id="emplno" type="STRING" size="256" sumtext="사번"/>
          <Column id="emplnm" type="STRING" size="256" sumtext="성명"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group4.ipt_dutym" propid="value" datasetid="ds_send_retrparams" columnid="fromdd"/>
      <BindItem id="item1" compid="group4.input1" propid="value" datasetid="ds_send_retrparams" columnid="todd"/>
    </Bind>
    <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";
include "mis_humtrafactmngtxp::RPB001.xjs";
function SMRPD12300_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRPD12300_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_dutsumlist);
	
	fInitialize();
}

function fInitialize()
{
	ds_main_list_dutsumlist.clearData();
	
	ds_send_retrparams.setColumn(0, "fromdd", String(utlf_getCurrentDate()).substr(0, 6) + "01");
	ds_send_retrparams.setColumn(0, "todd", utlf_getCurrentDate());
	
	group4.ipt_dutym.setFocus();
}

function group4_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRPD12301";
		oParam.service     = "dligclaznsmngtapp.DutScheMngt";
		oParam.method      = "reqGetYonsuEduList";
		oParam.inds        = "req=ds_send_retrparams";
		oParam.outds       = "ds_main_list_dutsumlist=dutsumlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRPD12301";

	tranf_submit(oParam);
}

function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	misfSaveExcel(grd_dutsumlist);
}
]]></Script>
  </Form>
</FDL>