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

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAD04400" position="absolute 0 0 1198 805" titletext="계정/보조과목별보조부" oninit="SMRAD04400_oninit" onload="SMRAD04400_onload">
    <Layouts>
      <Layout>
        <Div id="grp_biz" taborder="13" position="absolute 2 109 1181 791" scrollbars="none"/>
        <Static id="caption6" text="계정/보조과목별보조부" class="tit_1" position="absolute 0 0 171 25"/>
        <Shape id="roundrect1" type="roundrectangle" position="absolute 0 25 1193 85"/>
        <Button id="btn_search" taborder="3" text="조회" class="btn1" position="absolute 1130 47 1186 69" onclick="btn_search_onclick"/>
        <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1117 25 1123 84"/>
        <Static id="cap_payinst" text="소속기관:" class="search_name" position="absolute 15 34 101 51"/>
        <Combo id="cmb_instcd" taborder="4" class="combo_s_essential" enable="false" position="absolute 96 33 221 52"/>
        <Static id="caption22" text="기준일자:" class="search_name" position="absolute 271 33 352 50"/>
        <Calendar id="ipt_payym" taborder="5" class="input_default" position="absolute 355 33 460 52" mask="yyyy-mm-dd" autoselect="true"/>
        <Static id="caption28" text="계정별내역" class="tit_2" position="absolute 1 86 210 103"/>
        <Shape id="line193" linetype="horizontal" class="line_10" position="absolute 0 102 1194 108"/>
        <Static id="caption2" text="계정과목:" class="search_name" position="absolute 270 58 364 75"/>
        <Calendar id="input1" taborder="6" class="input_default" position="absolute 475 33 580 52" mask="yyyy-mm-dd" autoselect="true"/>
        <Static id="caption4" text="~" position="absolute 460 35 475 55"/>
        <Combo id="combo2" taborder="7" innerdataset="@ds_init_combo3_acntcmb" codecolumn="acntcd" datacolumn="acntnm" position="absolute 355 58 515 77" onitemchanged="combo2_onitemchanged"/>
        <Static id="caption3" text="LINE수:" class="search_name" position="absolute 615 33 694 50"/>
        <Edit id="input2" taborder="8" position="absolute 690 33 725 52" autoselect="true"/>
        <Static id="caption1" text="보조과목:" class="search_name" position="absolute 530 58 624 75"/>
        <Combo id="combo1" taborder="9" innerdataset="@ds_init_combo4_acntcmb" codecolumn="bojocd" datacolumn="bojonm" position="absolute 615 58 750 77"/>
        <Combo id="combo3" taborder="10" innerdataset="@ds_init_combo4_acntcmb" codecolumn="bojocd" datacolumn="bojonm" position="absolute 770 58 905 77"/>
        <Static id="caption5" text="~" position="absolute 753 58 768 78"/>
        <Grid id="datagrid1" taborder="11" binddataset="ds_main_grnt_grntlist1" useinputpanel="false" position="absolute 170 155 955 250" visible="false">
          <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>
        <Button id="button3" taborder="12" text="엑셀출력" class="btn2" position="absolute 1050 60 1114 79" onclick="button3_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <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"/>
          <Column id="chr02" type="STRING" size="256"/>
          <Column id="chr03" type="STRING" size="256"/>
          <Column id="chr04" type="STRING" size="256"/>
          <Column id="chr05" type="STRING" size="256"/>
          <Column id="chr06" type="STRING" size="256"/>
          <Column id="chr07" type="STRING" size="256"/>
          <Column id="chr08" type="STRING" size="256"/>
          <Column id="chr09" type="STRING" size="256"/>
          <Column id="chr10" type="STRING" size="256"/>
          <Column id="rmrk" type="STRING" size="256"/>
          <Column id="inamt" type="STRING" size="256"/>
          <Column id="outamt" type="STRING" size="256"/>
          <Column id="janamt" type="STRING" size="256"/>
          <Column id="acntnm" type="STRING" size="256"/>
          <Column id="title" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="chr01"/>
            <Col id="chr02"/>
            <Col id="chr03"/>
            <Col id="chr04"/>
            <Col id="chr05"/>
            <Col id="chr06"/>
            <Col id="chr07"/>
            <Col id="chr08"/>
            <Col id="chr09"/>
            <Col id="chr10"/>
            <Col id="rmrk"/>
            <Col id="inamt"/>
            <Col id="outamt"/>
            <Col id="janamt"/>
            <Col id="acntnm"/>
            <Col id="title"/>
          </Row>
        </Rows>
      </Dataset>
      <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"/>
        </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"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_custinfo_custlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="aactno" type="STRING" size="256"/>
          <Column id="bankcd" type="STRING" size="256"/>
          <Column id="depor" type="STRING" size="256"/>
          <Column id="custnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="aactno"/>
            <Col id="bankcd"/>
            <Col id="depor"/>
            <Col id="custnm"/>
          </Row>
        </Rows>
      </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="acntcd" type="STRING" size="256"/>
          <Column id="acntnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="acntcd"/>
            <Col id="acntnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_combo4_acntcmb" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="bojocd" type="STRING" size="256"/>
          <Column id="bojonm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="bojocd"/>
            <Col id="bojonm"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="cmb_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
      <BindItem id="item1" compid="ipt_payym" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item2" compid="input1" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item3" compid="input2" propid="value" datasetid="ds_send" columnid="line"/>
      <BindItem id="item4" compid="combo2" propid="value" datasetid="ds_send" columnid="fromacntcd"/>
      <BindItem id="item5" compid="combo1" propid="value" datasetid="ds_send" columnid="frombojo"/>
      <BindItem id="item6" compid="combo3" propid="value" datasetid="ds_send" columnid="tobojo"/>
    </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_miscommonxp::PIC002.xjs";
include "mis_miscommonxp::RAC001.xjs";
include "mis_miscommonxp::RBC001.xjs";
include "mis_miscommonxp::RSZ001.xjs";

var arErrorCode 	= new HashArray();

function SMRAD04400_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	//폼 초기화
}

function SMRAD04400_onload(obj:Form, e:LoadEventInfo)
{
	misfComboInstCdListMulti("cmb_instcd",utlf_getCurrentDate(),"","N");
	//makeReportPreview(0,110,1195,650);	
	var today = utlf_getCurrentDate();
	var cur_yymm = parseInt(today.substring(0, 6));
		
	ds_send.setColumn(0, "fromdd", today);
	ds_send.setColumn(0, "todd", today);
	//ipt_payym.refresh();
	//submit("TRRAD01504");
	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;		

	tranf_submit(oParam);
	
	combo2.index = -1;
	combo1.index = -1;
	combo3.index = -1;
		
	ds_send.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));	
	ipt_payym.setFocus();
}

function btn_search_onclick(obj:Button,  e:ClickEventInfo)
{	
	var oParam = {};
		oParam.id          = "TRRAD04401";
		oParam.service     = "slipapp.AccBook";
		oParam.method      = "reqGetBojobu2List";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_grnt_grntlist1=grntlist1";
		oParam.async       = false;		

	tranf_submit(oParam);						
						
	var objDOM = rptf_createDOM();				
	rptf_setNodeListToDOM(objDOM, "root/main/grnt/grntlist1", ds_main_grnt_grntlist1);		// 데이터셋 1

	var objParam = new Object();
	objParam.xml_data_XML1 = objDOM.documentElement.source;														// 최상의노드 XML 스트링 추출

	var option = "open=1;save=1;directprint=0;print=1;zoom=0;";	
	//var option = "open=1;save=1;directprint=1;printdialog=0;print=1;zoom=0;";
	rptf_exeReportPreview30(["RPRAD04401"],[objParam], option, "", "grp_biz");
}

function combo2_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	ds_send.setColumn(0, "acntcd", ds_send.getColumn(0, "fromacntcd"));
	ds_send.setColumn(0, "frombojo", "");
	ds_send.setColumn(0, "tobojo", "");
	//submit("TRRAD01701");
	var oParam = {};
		oParam.id          = "TRRAD01701";
		oParam.service     = "slipapp.AccBook";
		oParam.method      = "reqGetBojocdAllList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_init_combo4_acntcmb=acntcmb";
		oParam.async       = false;		

	tranf_submit(oParam);
}

function button3_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(datagrid1, caption6.text + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
}
]]></Script>
  </Form>
</FDL>