YNU_JEUS/app_home/himed/xpapps/mis/slipxp/xp/SMRAD04600_계정관리항목별보조부.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAD04600" position="absolute 0 0 1218 799" titletext="계정/관리항목별보조부" oninit="SMRAD04600_oninit" onload="SMRAD04600_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 2 116 1205 784" id="grp_biz" scrollbars="autoboth" anchor="all">
          <Layouts>
            <Layout/>
          </Layouts>
        </Div>
        <Grid id="datagrid1" taborder="2" binddataset="ds_main_grnt_grntlist1" useinputpanel="false" visible="false" position="absolute 135 230 1025 290">
          <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"/>
              </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"/>
              </Band>
              <Band id="body">
                <Cell text="bind:chr01"/>
                <Cell col="1" text="bind:chr02"/>
                <Cell col="2" text="bind:chr03"/>
                <Cell col="3" text="bind:chr04"/>
                <Cell col="4" text="bind:chr05"/>
                <Cell col="5" text="bind:chr06"/>
                <Cell col="6" text="bind:chr07"/>
                <Cell col="7" text="bind:chr08"/>
                <Cell col="8" text="bind:chr09"/>
                <Cell col="9" text="bind:chr10"/>
                <Cell col="10" text="bind:rmrk"/>
                <Cell col="11" text="bind:inamt"/>
                <Cell col="12" text="bind:outamt"/>
                <Cell col="13" text="bind:janamt"/>
                <Cell col="14" text="bind:acntnm"/>
                <Cell col="15" text="bind:title"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Div position="absolute 0 13 1195 38" id="grp_btn" scrollbars="autoboth">
          <Layouts>
            <Layout/>
          </Layouts>
        </Div>
        <Static id="caption6" text="계정/관리항목별보조부" class="tit_1" position="absolute 0 0 240 23"/>
        <Div id="grp_sea" taborder="1" position="absolute 0 23 1207 83" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="cap_payinst" text="소속기관:" class="search_name" position="absolute 13 9 99 26" anchor="default"/>
              <Static id="caption3" text="LINE수:" class="search_name" position="absolute 13 36 92 53" anchor="default"/>
              <Edit id="input2" taborder="1" position="absolute 94 35 129 54" autoselect="true" autoskip="true" anchor="default"/>
              <Combo id="cmb_instcd" taborder="2" class="combo_s_essential" enable="false" position="absolute 94 8 243 27" anchor="default"/>
              <Static id="caption22" text="기준일자:" class="search_name" position="absolute 269 8 350 25" anchor="default"/>
              <Static id="caption2" text="계정과목:" class="search_name" position="absolute 268 36 362 53" anchor="default"/>
              <Calendar id="ipt_payym" taborder="3" class="input_default" position="absolute 353 8 458 27" mask="yyyy-mm-dd" autoselect="true" autoskip="true" anchor="default"/>
              <Static id="caption4" text="~" position="absolute 461 9 476 29" anchor="default"/>
              <Calendar id="input1" taborder="4" class="input_default" position="absolute 473 8 578 27" mask="yyyy-mm-dd" autoselect="true" autoskip="true" anchor="default"/>
              <Combo id="combo2" taborder="5" innerdataset="@ds_init_combo3_acntcmb" codecolumn="acntcd" datacolumn="acntnm" position="absolute 353 35 578 54" anchor="default"/>
              <Static id="caption1" text="관리항목:" class="search_name" position="absolute 598 8 683 25" anchor="default"/>
              <Static id="caption5" text="~" position="absolute 663 37 678 57" anchor="default"/>
              <Edit id="input3" taborder="6" class="input_default" position="absolute 683 34 783 53" autoselect="true" autoskip="true" anchor="default"/>
              <Edit id="input17" taborder="7" class="input_default" position="absolute 683 7 783 26" autoselect="true" autoskip="true" anchor="default"/>
              <Button id="button6" taborder="8" class="icon_search" position="absolute 785 8 801 24" onclick="grp_sea_button6_onclick" anchor="default"/>
              <Button id="button1" taborder="9" class="icon_search" position="absolute 785 35 801 51" onclick="grp_sea_button1_onclick" anchor="default"/>
              <Edit id="input4" taborder="10" class="input_essential" enable="false" position="absolute 803 34 993 53" anchor="default"/>
              <Edit id="input18" taborder="11" class="input_essential" enable="false" position="absolute 803 7 993 26" anchor="default"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1039 5 1045 55" anchor="top right"/>
              <Button id="btn_search" taborder="12" text="조회" class="btn1" position="absolute 1057 18 1113 40" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Button id="button3" taborder="13" text="엑셀출력" class="btn7" position="absolute 1115 19 1195 41" anchor="top right" onclick="grp_sea_button3_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption28" text="계정별내역" class="tit_2" position="absolute 0 92 153 113"/>
        <Shape id="line193" class="line_10" position="absolute -1 108 1205 114" anchor="left top right"/>
      </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="toacntcd" 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="frombojo" type="STRING" size="256"/>
          <Column id="tobojo" type="STRING" size="256"/>
          <Column id="line" type="STRING" size="256"/>
          <Column id="frombojonm" type="STRING" size="256"/>
          <Column id="tobojonm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="instcd"/>
            <Col id="acntcd"/>
            <Col id="fromacntcd"/>
            <Col id="toacntcd"/>
            <Col id="fromcustcode"/>
            <Col id="tocustcode"/>
            <Col id="fromcustnm"/>
            <Col id="tocustnm"/>
            <Col id="custcode"/>
            <Col id="frombojo"/>
            <Col id="tobojo"/>
            <Col id="line"/>
            <Col id="frombojonm"/>
            <Col id="tobojonm"/>
          </Row>
        </Rows>
      </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="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_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_pop3data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="xrwseq" 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.input17" propid="value" datasetid="ds_send" columnid="frombojo"/>
      <BindItem id="item4" compid="grp_sea.input18" propid="value" datasetid="ds_send" columnid="frombojonm"/>
      <BindItem id="item5" compid="grp_sea.input2" propid="value" datasetid="ds_send" columnid="line"/>
      <BindItem id="item6" compid="grp_sea.combo2" propid="value" datasetid="ds_send" columnid="fromacntcd"/>
      <BindItem id="item7" compid="grp_sea.input3" propid="value" datasetid="ds_send" columnid="tobojo"/>
      <BindItem id="item8" compid="grp_sea.input4" propid="value" datasetid="ds_send" columnid="tobojonm"/>
    </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 SMRAD04600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAD04600_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(datagrid1);
	
	misfComboInstCdListMulti("grp_sea.cmb_instcd",utlf_getCurrentDate(),"","N");
	
	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");
	
	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(["RPRAD04601"],[objParam], option, "", "grp_biz")
	
	grp_sea.ipt_payym.setFocus();
}

function grp_sea_button6_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_pop3data.setColumn(0, "xrwseq", "2");

	var objArg = new Object();
		objArg.arg_ds_pop3data = ds_pop3data;
	frmf_modal("SMRPQ02000", "SMRPQ02000", objArg, "", "", "", "", "", "", "", "", "", "M");
}

function grp_sea_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_pop3data.setColumn(0, "xrwseq", "3");
	
	var objArg = new Object();
		objArg.arg_ds_pop3data = ds_pop3data;
	frmf_modal("SMRPQ02000", "SMRPQ02000", objArg, "", "", "", "", "", "", "", "", "", "M");
}

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

	tranf_submit(oParam);
	
	var objDOM = rptf_createDOM();
	var objParam = new Object();
		rptf_setNodeListToDOM(objDOM, "/root/main/grnt/grntlist1", ds_main_grnt_grntlist1);
	var option = "open=1;save=1;directprint=0;print=1;zoom=0;";	
		objParam.xml_data_XML1 = objDOM.documentElement.source;
	rptf_exeReportPreview30(["RPRAD04601"],[objParam], option, "", "grp_biz");
}

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