YNU_JEUS/app_home/himed/xpapps/mis/slipxp/xp/SMRAD04200_계정별보조부.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAD04200" position="absolute 0 0 1212 781" titletext="계정별보조부" oninit="SMRAD04200_oninit" onload="SMRAD04200_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="계정별보조부" class="tit_1" position="absolute 0 0 280 23"/>
        <Div id="grp_sea" taborder="1" position="absolute 0 23 1209 83" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="cap_payinst" text="소속기관:" class="search_name" position="absolute 6 8 92 25" anchor="default"/>
              <Static id="caption8" text="소속기관:" class="search_name" position="absolute 6 38 92 55" anchor="default"/>
              <Radio id="radio1" taborder="1" columncount="-1" rowcount="-1" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 84 37 249 54" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">보조부</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">보조부(편철용)</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Combo id="cmb_instcd" taborder="2" class="combo_s_essential" enable="false" position="absolute 85 7 239 26" anchor="default"/>
              <Static id="caption22" text="기준일자:" class="search_name" position="absolute 257 8 330 25" anchor="default"/>
              <Calendar id="ipt_payym" taborder="3" class="input_default" position="absolute 336 6 441 25" mask="yyyy-mm-dd" anchor="default" autoselect="true" autoskip="true"/>
              <Static id="caption3" text="LINE수:" class="search_name" position="absolute 257 38 328 55" anchor="default"/>
              <Edit id="input2" taborder="4" position="absolute 336 35 391 54" anchor="default" autoselect="true" autoskip="true"/>
              <Static id="caption5" text="출력구분:" class="search_name" position="absolute 413 37 499 54" anchor="default"/>
              <Combo id="cmb_prntflag" taborder="5" innerdataset="@ds_init_code_codelist" codecolumn="cdid" datacolumn="cdnm" position="absolute 496 35 561 54" anchor="default"/>
              <Static id="caption2" text="계정과목:" class="search_name" position="absolute 584 7 678 24" anchor="default"/>
              <Calendar id="input1" taborder="6" class="input_default" position="absolute 456 6 561 25" mask="yyyy-mm-dd" anchor="default" autoselect="true" autoskip="true"/>
              <Static id="caption4" text="~" position="absolute 442 6 457 26" anchor="default"/>
              <Edit id="ipt_acntcd" taborder="7" class="input_essential" position="absolute 668 7 773 26" anchor="default" autoselect="true" autoskip="true" onkeydown="grp_sea_ipt_acntcd_onkeydown"/>
              <Edit id="input4" taborder="8" class="input_essential" position="absolute 669 36 774 55" anchor="default" autoselect="true" autoskip="true" onkeydown="grp_sea_input4_onkeydown"/>
              <Button id="button1" taborder="9" class="icon_search" position="absolute 780 37 796 53" anchor="default" onclick="grp_sea_button1_onclick"/>
              <Edit id="ipt_acntnm" taborder="10" class="input_default" position="absolute 799 7 1019 26" anchor="default" autoselect="true" autoskip="true" onkeydown="grp_sea_ipt_acntnm_onkeydown"/>
              <Button id="btn_fine2" taborder="11" class="icon_search" position="absolute 779 8 795 24" anchor="default" onclick="grp_sea_btn_fine2_onclick"/>
              <Edit id="input3" taborder="12" class="input_default" position="absolute 800 36 1020 55" anchor="default" autoselect="true" autoskip="true" onkeydown="grp_sea_input3_onkeydown"/>
              <Button id="button3" taborder="15" text="엑셀출력" class="btn7" position="absolute 1037 35 1117 54" anchor="default" onclick="grp_sea_button3_onclick"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1123 5 1129 59" anchor="top right"/>
              <Button id="btn_search" taborder="16" text="조회" class="btn1" position="absolute 1140 19 1196 41" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Static id="caption7" text="~" position="absolute 1025 8 1040 28" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Combo id="combo2" taborder="2" innerdataset="@ds_init_combo3_acntcmb" codecolumn="acntcd" datacolumn="acntnm" visible="false" position="absolute 924 82 1039 101"/>
        <Static id="caption1" text="~" visible="false" position="absolute 1044 84 1059 104"/>
        <Combo id="combo3" taborder="3" innerdataset="@ds_init_combo3_acntcmb" codecolumn="acntcd" datacolumn="acntnm" visible="false" position="absolute 1064 82 1179 101"/>
        <Static id="caption28" text="계정별내역" class="tit_2" position="absolute 0 118 209 139"/>
        <Shape id="line193" class="line_10" position="absolute -1 134 1205 140" anchor="left top right"/>
        <Grid id="datagrid1" taborder="4" binddataset="ds_main_grnt_grntlist1" useinputpanel="false" position="absolute 82 196 902 246">
          <Formats>
            <Format id="default">
              <Columns>
                <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="caption1"/>
                <Cell col="1" text="caption2"/>
                <Cell col="2" text="caption3"/>
                <Cell col="3" text="caption4"/>
                <Cell col="4" text="caption5"/>
                <Cell col="5" text="caption6"/>
                <Cell col="6" text="caption7"/>
                <Cell col="7" text="caption8"/>
                <Cell col="8" text="caption9"/>
                <Cell col="9" text="caption10"/>
                <Cell col="10" text="caption11"/>
                <Cell col="11" text="caption12"/>
                <Cell col="12" text="caption13"/>
                <Cell col="13" text="caption14"/>
                <Cell col="14" text="caption15"/>
                <Cell col="15" text="caption16"/>
                <Cell col="16"/>
              </Band>
              <Band id="body">
                <Cell text="bind:instcd"/>
                <Cell col="1" text="bind:chr01"/>
                <Cell col="2" text="bind:chr02"/>
                <Cell col="3" text="bind:chr03"/>
                <Cell col="4" text="bind:chr04"/>
                <Cell col="5" text="bind:chr05"/>
                <Cell col="6" text="bind:chr06"/>
                <Cell col="7" text="bind:chr07"/>
                <Cell col="8" text="bind:chr08"/>
                <Cell col="9" text="bind:chr09"/>
                <Cell col="10" text="bind:chr10"/>
                <Cell col="11" text="bind:rmrk"/>
                <Cell col="12" text="bind:inamt"/>
                <Cell col="13" text="bind:outamt"/>
                <Cell col="14" text="bind:janamt"/>
                <Cell col="15" text="bind:acntnm"/>
                <Cell col="16" text="bind:title"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Div id="grp_biz" taborder="5" position="absolute 3 140 1203 771" anchor="all"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" 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"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="acntcd" type="STRING" size="256"/>
          <Column id="fromacntcd" type="STRING" size="256"/>
          <Column id="fromacntnm" type="STRING" size="256"/>
          <Column id="toacntcd" type="STRING" size="256"/>
          <Column id="toacntnm" type="STRING" size="256"/>
          <Column id="fromcustcode" type="STRING" size="256"/>
          <Column id="tocustcode" type="STRING" size="256"/>
          <Column id="fromcustnm" type="STRING" size="256"/>
          <Column id="tocustnm" type="STRING" size="256"/>
          <Column id="custcode" type="STRING" size="256"/>
          <Column id="line" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="prntflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="instcd"/>
            <Col id="acntcd"/>
            <Col id="fromacntcd"/>
            <Col id="fromacntnm"/>
            <Col id="toacntcd"/>
            <Col id="toacntnm"/>
            <Col id="fromcustcode"/>
            <Col id="tocustcode"/>
            <Col id="fromcustnm"/>
            <Col id="tocustnm"/>
            <Col id="custcode"/>
            <Col id="line"/>
            <Col id="gubun"/>
            <Col id="prntflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_code_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_combo3_acntcmb" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="acntnm" type="STRING" size="256"/>
          <Column id="acntcd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_grnt_grntlist1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256" sumtext="항목1"/>
          <Column id="chr01" type="STRING" size="256" sumtext="항목1"/>
          <Column id="chr02" type="STRING" size="256" sumtext="항목1"/>
          <Column id="chr03" type="STRING" size="256" sumtext="항목1"/>
          <Column id="chr04" type="STRING" size="256" sumtext="항목1"/>
          <Column id="chr05" type="STRING" size="256" sumtext="항목1"/>
          <Column id="chr06" type="STRING" size="256" sumtext="항목1"/>
          <Column id="chr07" type="STRING" size="256" sumtext="항목1"/>
          <Column id="chr08" type="STRING" size="256" sumtext="항목1"/>
          <Column id="chr09" type="STRING" size="256" sumtext="항목1"/>
          <Column id="chr10" type="STRING" size="256" sumtext="항목1"/>
          <Column id="rmrk" type="STRING" size="256" sumtext="적요"/>
          <Column id="inamt" type="STRING" size="256" sumtext="입금액"/>
          <Column id="outamt" type="STRING" size="256" sumtext="출금액"/>
          <Column id="janamt" type="STRING" size="256" sumtext="잔액"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
          <Column id="title" type="STRING" size="256" sumtext="타이틀"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="resultflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.cmb_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
      <BindItem id="item1" compid="grp_sea.ipt_payym" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item2" compid="grp_sea.input1" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item3" compid="grp_sea.ipt_acntcd" propid="value" datasetid="ds_send" columnid="fromacntcd"/>
      <BindItem id="item4" compid="grp_sea.ipt_acntnm" propid="value" datasetid="ds_send" columnid="fromacntnm"/>
      <BindItem id="item5" compid="grp_sea.input2" propid="value" datasetid="ds_send" columnid="line"/>
      <BindItem id="item6" compid="grp_sea.cmb_prntflag" propid="value" datasetid="ds_send" columnid="prntflag"/>
      <BindItem id="item7" compid="grp_sea.input4" propid="value" datasetid="ds_send" columnid="toacntcd"/>
      <BindItem id="item8" compid="grp_sea.input3" propid="value" datasetid="ds_send" columnid="toacntnm"/>
      <BindItem id="item9" compid="combo2" propid="value" datasetid="ds_send" columnid="fromacntcd"/>
      <BindItem id="item10" compid="combo3" propid="value" datasetid="ds_send" columnid="toacntcd"/>
      <BindItem id="item11" compid="grp_sea.radio1" propid="value" datasetid="ds_send" columnid="gubun"/>
    </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";
function SMRAD04200_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAD04200_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(datagrid1);
	
	misfComboInstCdListMulti("grp_sea.cmb_instcd",utlf_getCurrentDate(),"","N");

	misfComboComCdList("R0531", grp_sea.cmb_prntflag, sysf_getUserInfo("dutplceinstcd"));
	
	var today = utlf_getCurrentDate();
	var cur_yymm = parseInt(String(today).substr(0, 6));
	
	ds_send.setColumn(0, "fromdd", today);
	ds_send.setColumn(0, "todd", today);
	
	var oParam = {};
		oParam.id          = "TRRAD01504";
		oParam.service     = "slipapp.AccBook";
		oParam.method      = "reqGetAcntcdAllList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_init_combo3_acntcmb=acntcmb";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAD01504";

	tranf_submit(oParam);

	grp_sea.cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");
	grp_sea.cmb_prntflag.value = sysf_getUserInfo("dutplceinstcd");
	
	ds_send.setColumn(0, "gubun", "1");
	
	var objDOM = rptf_createDOM();
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source;	
	
	var option = "open=1;save=1;directprint=0;print=1;zoom=0;";	
	rptf_exeReportPreview30(["RPRAD04201"],[objParam], option, "", "grp_biz")
	
	grp_sea.ipt_payym.setFocus();
}

function grp_sea_ipt_acntcd_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		
		misfValidationCheck("05", "", "fromacntcd,fromacntnm");
	}
}

function grp_sea_btn_fine2_onclick(obj:Button,  e:ClickEventInfo)
{
	misfOpenPopUpList("05", ds_send, "", "fromacntcd,fromacntnm");
}

function grp_sea_ipt_acntnm_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		
		misfValidationCheck("05", "", "fromacntcd,fromacntnm");
	}
}

function grp_sea_input4_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		
		misfValidationCheck("05", "", "toacntcd,toacntnm");
		grp_sea.input2.setFocus();
	}
}

function grp_sea_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	misfOpenPopUpList("05", ds_send, "", "toacntcd,toacntnm");
}

function grp_sea_input3_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		
		misfValidationCheck("05", "", "toacntcd,toacntnm");
		grp_sea.input2.setFocus();
	}
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRAD04201";
		oParam.service     = "slipapp.AccBook";
		oParam.method      = "reqGetBojobu1List";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_grnt_grntlist1=grntlist1";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAD04201";

	tranf_submit(oParam);

	ds_hidden.setColumn(0, "resultflag", grp_sea.cmb_prntflag.text);
	
	if(ds_send.getColumn(0, "gubun") == "1")
	{
		var objDOM = rptf_createDOM();
		var objParam = new Object();
			rptf_setNodeListToDOM(objDOM, "/root/main/grnt/grntlist1", ds_main_grnt_grntlist1);
			rptf_setNodeListToDOM(objDOM, "/root/hidden", ds_hidden);	
		var option = "open=1;save=1;directprint=0;print=1;zoom=0;";	
			objParam.xml_data_XML1 = objDOM.documentElement.source;
		rptf_exeReportPreview30(["RPRAD04201"],[objParam], option, "", "grp_biz");
	}
	else
	{
		var objDOM = rptf_createDOM();
		var objParam = new Object();
			rptf_setNodeListToDOM(objDOM, "/root/main/grnt/grntlist1", ds_main_grnt_grntlist1);
			rptf_setNodeListToDOM(objDOM, "/root/hidden", ds_hidden);
		var option = "open=1;save=1;directprint=0;print=1;zoom=0;";	
			objParam.xml_data_XML1 = objDOM.documentElement.source;
		rptf_exeReportPreview30(["RPRAD04301"],[objParam], option, "", "grp_biz");
	}
}

function grp_sea_button3_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(datagrid1, "excel", "see", "false");
}
]]></Script>
  </Form>
</FDL>