YNU_JEUS/app_home/himed/xpapps/mis/accountinginfoxp/xp/SMRAR00700_총계정원장.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAR00700" position="absolute 0 0 1196 800" titletext="총계정원장" onload="SMRAR00700_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="총계정원장" class="tit_1" position="absolute 0 0 100 25"/>
        <Div id="group4" taborder="1" class="div_SA" position="absolute 0 25 1195 85" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption24" text="(class)" class="search_name" visible="false" position="absolute 441 34 511 51" anchor="default"/>
              <Shape id="line30" linetype="vertical" class="line_4" position="absolute 1106 11 1112 50" anchor="right"/>
              <Button id="btn_search" taborder="18" text="조회" class="btn1" position="absolute 1125 19 1181 41" anchor="right" onclick="group4_btn_search_onclick"/>
              <Combo id="cmb_acntclsflag" taborder="19" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_essential" position="absolute 448 33 511 52" anchor="default" onitemchanged="group4_cmb_acntclsflag_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">4</Col>
                      <Col id="datacolumn">대분류</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">3</Col>
                      <Col id="datacolumn">관</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">항</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">목</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">0</Col>
                      <Col id="datacolumn">세목</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Button id="btn_toacnthelp2" taborder="20" class="icon_search" position="absolute 596 33 612 49" anchor="default" onclick="group4_btn_toacnthelp2_onclick"/>
              <Button id="btn_fracnthelp2" taborder="21" class="icon_search" position="absolute 596 10 612 26" anchor="default" onclick="group4_btn_fracnthelp2_onclick"/>
              <Edit id="ipt_fracntcd" taborder="22" class="input_essential" position="absolute 517 10 592 29" anchor="default" onkillfocus="group4_ipt_fracntcd_onkillfocus" onkeydown="Edit_onkeydown"/>
              <Static id="caption28" text="계정과목 :" class="search_name" position="absolute 441 11 515 28" anchor="default"/>
              <Edit id="ipt_toacntcd" taborder="23" class="input_essential" position="absolute 517 33 592 52" anchor="default" onkeydown="Edit_onkeydown" onkillfocus="group4_ipt_toacntcd_onkillfocus"/>
              <Edit id="ipt_fracntnm" taborder="24" class="input_essential" position="absolute 614 10 790 29" anchor="default" onkillfocus="group4_ipt_fracntnm_onkillfocus" onkeydown="Edit_onkeydown"/>
              <Edit id="ipt_toacntnm" taborder="25" class="input_essential" position="absolute 614 33 790 52" anchor="default" onkeydown="Edit_onkeydown" onkillfocus="group4_ipt_toacntnm_onkillfocus"/>
              <Static id="caption2" text="기     간 :" class="search_name" position="absolute 12 11 90 28" anchor="default"/>
              <Calendar id="ipt_frdate1" taborder="26" class="input_essential" position="absolute 86 10 186 29" mask="yyyy-mm-dd" anchor="default" dateformat="yyyy-MM-dd" value="null"/>
              <Static id="caption1" text="~" position="absolute 187 12 202 27" anchor="default"/>
              <Calendar id="ipt_todate1" taborder="27" class="input_essential" position="absolute 198 10 299 29" mask="yyyy-mm-dd" anchor="default" dateformat="yyyy-MM-dd"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line193" class="line_10" position="absolute 0 109 1195 115" anchor="left top right"/>
        <Static id="caption7" text="총계정원장" class="tit_2" position="absolute 0 93 260 110"/>
        <Grid id="datagrid1" taborder="2" binddataset="ds_main_maindatalist" useinputpanel="false" position="absolute 60 165 1035 215" 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"/>
              </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"/>
              </Band>
              <Band id="body">
                <Cell text="bind:acntcd"/>
                <Cell col="1" text="bind:acntnm"/>
                <Cell col="2" text="bind:frdate"/>
                <Cell col="3" text="bind:todate"/>
                <Cell col="4" text="bind:ymdwrite"/>
                <Cell col="5" text="bind:rmrk"/>
                <Cell col="6" text="bind:inamt"/>
                <Cell col="7" text="bind:outamt"/>
                <Cell col="8" text="bind:janamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="button3" taborder="3" text="엑셀출력" class="btn7" position="absolute 1115 87 1195 109" anchor="right" onclick="button3_onclick"/>
        <Div id="grp_main" anchor="all" taborder="4" scrollbars="none" position="absolute 2 114 1194 797"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_params" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep" oncolumnchanged="ds_send_params_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="frdate" type="STRING" size="256"/>
          <Column id="todate" type="STRING" size="256"/>
          <Column id="fracntcd" type="STRING" size="256"/>
          <Column id="fracntnm" type="STRING" size="256"/>
          <Column id="toacntcd" type="STRING" size="256"/>
          <Column id="toacntnm" type="STRING" size="256"/>
          <Column id="acntclsflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="frdate"/>
            <Col id="todate"/>
            <Col id="fracntcd"/>
            <Col id="fracntnm"/>
            <Col id="toacntcd"/>
            <Col id="toacntnm"/>
            <Col id="acntclsflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_maindatalist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="acntcd" type="STRING" size="256"/>
          <Column id="acntnm" type="STRING" size="256"/>
          <Column id="frdate" type="STRING" size="256"/>
          <Column id="todate" type="STRING" size="256"/>
          <Column id="ymdwrite" 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"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="acntcd"/>
            <Col id="acntnm"/>
            <Col id="frdate"/>
            <Col id="todate"/>
            <Col id="ymdwrite"/>
            <Col id="rmrk"/>
            <Col id="inamt"/>
            <Col id="outamt"/>
            <Col id="janamt"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group4.cmb_acntclsflag" propid="value" datasetid="ds_send_params" columnid="acntclsflag"/>
      <BindItem id="item1" compid="group4.ipt_fracntcd" propid="value" datasetid="ds_send_params" columnid="fracntcd"/>
      <BindItem id="item2" compid="group4.ipt_toacntcd" propid="value" datasetid="ds_send_params" columnid="toacntcd"/>
      <BindItem id="item3" compid="group4.ipt_fracntnm" propid="value" datasetid="ds_send_params" columnid="fracntnm"/>
      <BindItem id="item4" compid="group4.ipt_toacntnm" propid="value" datasetid="ds_send_params" columnid="toacntnm"/>
      <BindItem id="item5" compid="group4.ipt_frdate1" propid="value" datasetid="ds_send_params" columnid="frdate"/>
      <BindItem id="item6" compid="group4.ipt_todate1" propid="value" datasetid="ds_send_params" columnid="todate"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-12-04
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
include "mis_miscommonxp::RAC001.xjs";
include "mis_acntcommonxp::RAD001.xjs";

//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------
var arErrorCode = new HashArray();

//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------
/*-**************************************************************************************
 * Argument			: N/A
 * Description		: 체크
 ****************************************************************************************/
function fCheckAcntCdNull()
{
	var bRet = true;					
	if(utlf_isNull(ds_send_params.getColumn(0, "fracntcd")) && utlf_isNull(ds_send_params.getColumn(0, "toacntcd"))) {
		sysf_messageBox("선택된 계정과목이 ", "I004");
		return false;
	}					
	if(!utlf_isNull(ds_send_params.getColumn(0, "fracntcd")) && utlf_isNull(ds_send_params.getColumn(0, "toacntcd"))) {
		ds_send_params.setColumn( 0, "toacntcd", ds_send_params.getColumn(0, "fracntcd"));
		ds_send_params.setColumn( 0, "toacntnm", ds_send_params.getColumn(0, "fracntnm"));
	}else if(utlf_isNull(ds_send_params.getColumn(0, "fracntcd")) && !utlf_isNull(ds_send_params.getColumn(0, "toacntcd"))){
		ds_send_params.setColumn( 0, "fracntcd", ds_send_params.getColumn(0, "toacntcd"));
		ds_send_params.setColumn( 0, "fracntnm", ds_send_params.getColumn(0, "toacntnm"));
	}					
	return bRet;
}

/*-**************************************************************************************
 * Argument			: vgbn, recvlist, pcdgrupid, pNextIndex, pValueControl, pNodeName, pRetrKind
 * Description		: 코드 Validation Check
 ****************************************************************************************/
function fValidationCheck(vgbn, recvlist, pcdgrupid, pNextIndex, pValueControl, pNodeName, pRetrKind)
{
	misfValidationCheck(vgbn, pcdgrupid, recvlist, pValueControl, pNodeName, pRetrKind);
}

//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화
 ****************************************************************************************/
function SMRAR00700_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	//grdf_initGrid(grd_XXX); 
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	ds_main_maindatalist.clearData();

	var dt = new Date();
	var lastdt = new Date(dt.getYear(), dt.getMonth()+1, 0);
	group4.ipt_frdate1.value = utlf_getCurrentDate().substr(0, 6) + "01";
	group4.ipt_todate1.value = utlf_getCurrentDate().substr(0, 6) + lastdt.getDate();

	ds_send_params.setColumn( 0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	group4.ipt_fracntcd.setFocus();
}

/****************************************************************************************
 * Components		: Button
 * Description		: 조회
 ****************************************************************************************/
function group4_btn_search_onclick(obj:Button, e:ClickEventInfo) {
	if(!fCheckAcntCdNull())
	{
		return;
	}

	ds_main_maindatalist.clearData();
	var oParam = {};
		oParam.id          = "TRRAR00701";
		oParam.service     = "accountinginfoapp.AccountingInfo";
		oParam.method      = "getGeneralLedger";
		oParam.inds        = "req=ds_send_params";
		oParam.outds       = "ds_main_maindatalist=maindatalist";
		oParam.async       = false;
		oParam.callback    = "cf_TRRAR00701";

	tranf_submit(oParam);
	if(arErrorCode.pop("TRRAR00701") > -1) {
		var objDOM = rptf_createDOM();
		var objParam = new Object();
		rptf_setNodeListToDOM(objDOM, "/root/main/maindatalist" , ds_main_maindatalist);
		objParam.xml_data_XML1 	= objDOM.documentElement.source;
		var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
		rptf_exeReportPreview30(["SMRAR00701"],[objParam], option, "", "grp_main");
	}							
}
function cf_TRRAR00701(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
}

/****************************************************************************************
 * Components		: Combo
 * Description		: 과목분류 변경
 ****************************************************************************************/
function group4_cmb_acntclsflag_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
	ds_send_params.setColumn( 0, "fracntcd", "");								
	ds_send_params.setColumn( 0, "fracntnm", "");
	ds_send_params.setColumn( 0, "toacntcd", "");
	ds_send_params.setColumn( 0, "toacntnm", "");
}

/****************************************************************************************
 * Components		: Button
 * Description		: 계정과목 조회 팝업
 ****************************************************************************************/
function group4_btn_toacnthelp2_onclick(obj:Button, e:ClickEventInfo) {
	misfOpenPopUpList("05", group4.ipt_fracntcd, "", "toacntcd,toacntnm", "group4.cmb_acntclsflag", "acntclsflag");	
}

/****************************************************************************************
 * Components		: Button
 * Description		: 계정과목 조회 팝업
 ****************************************************************************************/
function group4_btn_fracnthelp2_onclick(obj:Button, e:ClickEventInfo) {
	misfOpenPopUpList("05", group4.ipt_fracntcd, "", "fracntcd,fracntnm", "group4.cmb_acntclsflag", "acntclsflag");	
}

/****************************************************************************************
 * Components		: Edit
 * Description		: 포커스 이동
 ****************************************************************************************/
 function Edit_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13) {
		obj.updateToDataset();
		group4.btn_search.setFocus();
	}
}

/****************************************************************************************
 * Components		: Dataset
 * Description		: 계정과목 변경시 체크
 ****************************************************************************************/
function ds_send_params_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(utlf_isNull(e.newvalue)) return;
	
	if(e.columnid == "fracntcd" || e.columnid == "fracntnm") fValidationCheck("05", "fracntcd,fracntnm", "", "", "group4.cmb_acntclsflag", "acntclsflag");
	if(e.columnid == "toacntcd" || e.columnid == "toacntnm") fValidationCheck("05", "toacntcd,toacntnm", "", "", "group4.cmb_acntclsflag", "acntclsflag");
}

/****************************************************************************************
 * Components		: Button
 * Description		: 엑셀저장
 ****************************************************************************************/
function button3_onclick(obj:Button, e:ClickEventInfo) {
	misfSaveExcel(datagrid1, "excel");
}


]]></Script>
  </Form>
</FDL>