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 1202 776" titletext="계정별보조부(편철용)" oninit="SMRAD04200_oninit" onload="SMRAD04200_onload">
    <Layouts>
      <Layout>
        <Div id="grp_biz" taborder="3" position="absolute 2 114 1188 771">
          <Layouts>
            <Layout width="1186" height="657"/>
          </Layouts>
        </Div>
        <Shape position="absolute 0 25 1193 85" id="roundrect1" type="roundrectangle" anchor="default"/>
        <Button position="absolute 1130 42 1186 64" id="btn_search" class="btn1" text="조회" anchor="default" onclick="btn_search_onclick"/>
        <Shape position="absolute 1117 30 1123 79" linetype="vertical" id="line13" class="line_4" anchor="default"/>
        <Static text="소속기관:" position="absolute 15 34 101 51" id="cap_payinst" class="search_name" anchor="default"/>
        <Combo position="absolute 96 33 250 52" id="cmb_instcd" class="combo_essential" enable="false" anchor="default"/>
        <Static text="기준일자:" position="absolute 295 33 376 50" id="caption22" class="search_name" anchor="default"/>
        <Calendar position="absolute 380 33 470 52" align="align:center middle;" id="ipt_payym" class="input_default" taborder="1" mask="yyyy-mm-dd" anchor="default" autoselect="true"/>
        <Static text="계정별내역" position="absolute 1 91 210 109" id="caption28" class="tit_2" anchor="default"/>
        <Shape position="absolute 2 107 1192 113" linetype="horizontal" id="line193" class="line_10" anchor="default"/>
        <Static text="계정과목:" position="absolute 635 33 729 50" id="caption2" class="search_name" anchor="default"/>
        <Calendar position="absolute 485 33 575 52" align="align:center middle;" id="input1" class="input_default" taborder="2" mask="yyyy-mm-dd" anchor="default" autoselect="true"/>
        <Static text="~" position="absolute 470 35 485 55" align="align:center middle;" id="caption4" anchor="default"/>
        <Combo position="absolute 720 33 880 52" id="combo2" innerdataset="@ds_init_combo3_acntcmb" datacolumn="acntnm" codecolumn="acntcd" anchor="default"/>
        <Combo position="absolute 895 33 1055 52" id="combo3" innerdataset="@ds_init_combo3_acntcmb" datacolumn="acntnm" codecolumn="acntcd" anchor="default"/>
        <Static text="~" position="absolute 880 35 895 55" align="align:center middle;" id="caption1" anchor="default"/>
        <Static text="LINE수 :" position="absolute 295 59 374 76" id="caption3" class="search_name" anchor="default"/>
        <Edit position="absolute 380 59 430 78" id="input2" anchor="default" autoselect="true"/>
        <Static text="출력구분:" position="absolute 635 59 729 76" id="caption5" class="search_name" anchor="default"/>
        <Combo position="absolute 720 59 785 78" id="cmb_prntflag" innerdataset="@ds_init_code_codelist" datacolumn="cdnm" codecolumn="cdid" anchor="default"/>
        <Grid position="absolute 85 175 685 250" id="datagrid1" binddataset="ds_main_grnt_grntlist1" anchor="default" 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"/>
                <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>
        <Button position="absolute 1125 88 1189 107" align="align:left middle;" id="button3" class="btn2" text="엑셀출력" anchor="default" onclick="button3_onclick"/>
        <Static id="caption6" text="계정별보조부(편철용)" class="tit_1" position="absolute 0 0 168 25"/>
      </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="instcd" type="STRING" size="256"/>
          <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="instcd"/>
            <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_init_code_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <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="line" 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="toacntcd"/>
            <Col id="fromcustcode"/>
            <Col id="tocustcode"/>
            <Col id="fromcustnm"/>
            <Col id="tocustnm"/>
            <Col id="custcode"/>
            <Col id="line"/>
            <Col id="prntflag"/>
          </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_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>
      </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="combo3" propid="value" datasetid="ds_send" columnid="toacntcd"/>
      <BindItem id="item6" compid="cmb_prntflag" propid="value" datasetid="ds_send" columnid="prntflag"/>
    </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 SMRAD04200_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	//폼 초기화
}

function SMRAD04200_onload(obj:Form, e:LoadEventInfo)
{
	misfComboInstCdListMulti("cmb_instcd", utlf_getCurrentDate(),"","N");
	//makeReportPreview(5,145,1190,630);
	//2015.11.12 박준범 - 치과병원 분리를 위해 출력구분을 공통코드로 변경처리
	misfComboComCdList("R0531", cmb_prntflag, sysf_getUserInfo("dutplceinstcd"));
	
	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;
	combo3.index = -1;
	
	ds_send.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_send.setColumn(0, "prntflag", sysf_getUserInfo("dutplceinstcd"));
		
	ipt_payym.setFocus();
}

function 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;		

	tranf_submit(oParam);
	
	ds_hidden.setColumn(0, "resultflag",cmb_prntflag.text);
	
	var objDOM = rptf_createDOM();			
	rptf_setNodeListToDOM(objDOM, "root/hidden", ds_hidden);	// 데이터셋 1	
	rptf_setNodeListToDOM(objDOM, "root/main/grnt/grntlist1", ds_main_grnt_grntlist1);		// 데이터셋 2

	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(["RPRAD04301"],[objParam], option, "", "grp_biz");
}

function button3_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(datagrid1, "계정별보조부(편철용)" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
}
]]></Script>
  </Form>
</FDL>