YNU_JEUS/app_home/himed/xpapps/mis/accountinginfoxp/xp/SMRAR00300_가수금상계조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAR00300" position="absolute 0 0 1199 787" titletext="가수금 상계 조회" oninit="SMRAR00300_oninit" onload="SMRAR00300_onload">
    <Layouts>
      <Layout>
        <MaskEdit id="cpt_gaamtsum" taborder="5" position="absolute 978 759 1098 782" style="background:#ffccccff;" anchor="right bottom" mask="9,999999999"/>
        <Button position="absolute 1139 25 1195 47" id="btn_print" class="btn4" visible="true" text="출력" anchor="top right" onclick="btn_print_onclick"/>
        <Static id="caption6" text="가수금 상계 조회" class="tit_1" position="absolute 0 0 293 25"/>
        <Shape id="line2" class="line_6" position="absolute 0 46 1195 52" anchor="left top right" onclick="line2_onclick"/>
        <Div id="grp_sea" anchor="left top right" taborder="1" class="div_SA2" position="absolute 0 50 1195 90">
          <Layouts>
            <Layout>
              <Button id="button2" taborder="2" text="조회" class="btn1" position="absolute 720 10 776 32" onclick="grp_sea_button2_onclick"/>
              <Shape id="line5" linetype="vertical" class="line_4" position="absolute 701 9 707 31"/>
              <Calendar id="ipt_gadate_fr" taborder="3" autoselect="true" autoskip="true" class="input_s_essential" position="absolute 457 10 562 29" mask="yyyy-mm-dd"/>
              <Static id="caption2" text="~" position="absolute 566 12 581 29"/>
              <Calendar id="ipt_gadate_to" taborder="4" autoselect="true" autoskip="true" class="input_s_essential" position="absolute 582 10 684 29" mask="yyyy-mm-dd"/>
              <Static id="caption3" text="가수금일자 :" class="search_name" position="absolute 356 10 460 27"/>
              <Edit id="opt_aactcd" taborder="5" readonly="true" class="output" position="absolute 270 10 325 29"/>
              <Static id="caption5" text="예금계좌 :" class="search_name" position="absolute 31 10 135 27"/>
              <Combo id="cmb_aactno" taborder="6" innerdataset="@ds_init_bankinfo" codecolumn="aactcd" datacolumn="aactno" class="combo_s_essential" position="absolute 120 10 270 29" onitemchanged="grp_sea_cmb_aactno_onitemchanged"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line3" class="line_10" position="absolute 0 115 1195 121" anchor="left top right"/>
        <Grid id="grd_main" taborder="2" binddataset="ds_main_maindatalist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 120 1195 755" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25"/>
                <Column size="0"/>
                <Column size="130"/>
                <Column size="50"/>
                <Column size="74"/>
                <Column size="56"/>
                <Column size="238"/>
                <Column size="77"/>
                <Column size="77"/>
                <Column size="80"/>
                <Column size="102"/>
                <Column size="59"/>
                <Column size="0"/>
                <Column size="228"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="기관코드"/>
                <Cell col="2" text="예금계좌"/>
                <Cell col="3" text="보조과목"/>
                <Cell col="4" text="가수금일자"/>
                <Cell col="5" text="구분"/>
                <Cell col="6" text="적  요"/>
                <Cell col="7" text="전표작성일자"/>
                <Cell col="8" text="승인전표번호"/>
                <Cell col="9" text="asis전표번호"/>
                <Cell col="10" text="상계금액"/>
                <Cell col="11" text="Row No."/>
                <Cell col="12" text="미결전표번호"/>
                <Cell col="13" text="전표적요"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:instcd"/>
                <Cell col="2" text="bind:aactno"/>
                <Cell col="3" text="bind:aactcd"/>
                <Cell col="4" displaytype="date" text="bind:gadate" calendardisplaynulltype="nulltext"/>
                <Cell col="5" text="bind:gubun"/>
                <Cell col="6" style="align:left middle;padding:0 0 0 3;" text="bind:rmrk"/>
                <Cell col="7" displaytype="date" text="bind:ymdwrite" calendardisplaynulltype="nulltext"/>
                <Cell col="8" text="bind:sanctslipno"/>
                <Cell col="9" text="bind:seqwrite"/>
                <Cell col="10" displaytype="number" text="bind:janamt"/>
                <Cell col="11" text="bind:rowcnt"/>
                <Cell col="12" text="bind:unslno"/>
                <Cell col="13" style="align:left middle;padding:0 0 0 3;" text="bind:slipcmt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="ipt_excsave" taborder="3" text="엑셀저장" class="btn7" position="absolute 1115 96 1195 115" anchor="top right" onclick="ipt_excsave_onclick"/>
        <Button id="button18" taborder="4" text="전표취소" class="btn2" position="absolute 1050 96 1114 115" anchor="top right" onclick="button18_onclick"/>
        <Static id="caption21" text="출력 목록" class="tit_2" position="absolute 0 99 131 120"/>
        <Static id="caption7" text="(* 100,000건 이상 조회가 안됩니다. 계좌와 가수금일자를 선택하신 후 조회 해 주세요.)" position="absolute 85 99 585 112"/>
        <Static id="caption1" text="합  계" class="cell_1" position="absolute 877 759 977 782" anchor="right bottom"/>
      </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="instcd" type="STRING" size="256"/>
          <Column id="gadate_fr" type="STRING" size="256"/>
          <Column id="gadate_to" type="STRING" size="256"/>
          <Column id="aactno" type="STRING" size="256"/>
          <Column id="aactcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="gadate_fr"/>
            <Col id="gadate_to"/>
            <Col id="aactno"/>
            <Col id="aactcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_maindatalist" 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="기관코드"/>
          <Column id="aactcd" type="STRING" size="256" sumtext="계좌코드"/>
          <Column id="gadate" type="STRING" size="256" sumtext="가수금일자"/>
          <Column id="gubun" type="STRING" size="256" sumtext="구분"/>
          <Column id="rmrk" type="STRING" size="256" sumtext="적요"/>
          <Column id="gaamt" type="STRING" size="256" sumtext="가수금"/>
          <Column id="janamt" type="STRING" size="256" sumtext="잔액"/>
          <Column id="sangflag" type="STRING" size="256" sumtext="상계여부"/>
          <Column id="line" type="STRING" size="256" sumtext="NO."/>
          <Column id="seqline" type="STRING" size="256" sumtext="SEQ NO."/>
          <Column id="ymdwrite" type="STRING" size="256" sumtext="전표일자"/>
          <Column id="unslno" type="STRING" size="256" sumtext="미결전표번호"/>
          <Column id="sanctslipno" type="STRING" size="256" sumtext="승인전표번호"/>
          <Column id="aactno" type="STRING" size="256" sumtext="계좌번호"/>
          <Column id="seqwrite" type="STRING" size="256" sumtext="구버전번호"/>
          <Column id="rowcnt" type="STRING" size="256" sumtext="row cnt"/>
          <Column id="slipcmt" type="STRING" size="256" sumtext="전표적요"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_bankinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="aactcd" type="STRING" size="256" sumtext="계좌코드"/>
          <Column id="aactno" type="STRING" size="256" sumtext="계좌번호"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_hidden_apsl" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="sumjanamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.cmb_aactno" propid="value" datasetid="ds_send" columnid=""/>
      <BindItem id="item1" compid="grp_sea.opt_aactcd" propid="value" datasetid="ds_send" columnid="aactcd"/>
      <BindItem id="item2" compid="grp_sea.ipt_gadate_to" propid="value" datasetid="ds_send" columnid="gadate_to"/>
      <BindItem id="item3" compid="grp_sea.ipt_gadate_fr" propid="value" datasetid="ds_send" columnid="gadate_fr"/>
      <BindItem id="item5" compid="cpt_gaamtsum" propid="value" datasetid="ds_hidden_apsl" columnid="sumjanamt"/>
    </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 SMRAR00300_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAR00300_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_main);
	grdf_setRowTypeIcon(grd_main, 0);
	
	var fdate = utlf_getCurrentDate();    
	
	ds_send.setColumn(0, "instcd",   sysf_getUserInfo("dutplceinstcd"));					
	ds_send.setColumn(0, "gadate_fr", String(fdate).substr(0,4)+"0101" ); 
	ds_send.setColumn(0, "gadate_to", fdate); 

	var oParam = {};
		oParam.id          = "TRRAR00101";
		oParam.service     = "accountinginfoapp.AccountingInfo";
		oParam.method      = "reqGetAccountCdList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_init_bankinfo=bankinfo";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAR00101";

	tranf_submit(oParam);

	frmf_addComboItem("grp_sea.cmb_aactno","--전체--","","above");
	grp_sea.cmb_aactno.index = 0;
}

function grp_sea_cmb_aactno_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	ds_send.setColumn(0, "aactcd", obj.value);
}

function grp_sea_button2_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRAR00301";
		oParam.service     = "accountinginfoapp.AccountingInfo";
		oParam.method      = "getSanggyeHistory";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_maindatalist=maindatalist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAR00301";

	tranf_submit(oParam);
	
	ds_hidden_apsl.setColumn(0, "sumjanamt", ds_main_maindatalist.getSum("janamt"));
}

function ipt_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	misfSaveExcel(grd_main);	
}

function button18_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridIUD(grd_main, "D");	

	var cnt = 0;
	for ( var i = 0; i < ds_main_maindatalist.rowcount; i++ ) 
	{
		if ( ds_main_maindatalist.getRowType(i) == 8)
		{
			cnt = cnt + 1;
		}
	}
	if ( cnt > 1)
	{
		alert("동시에 여러건을 선택해서 취소 처리 할 수 없습니다.\n\n한 건만 선택해 주세요.");
		grp_sea.button2.click();
		return false;
	}

	if ( String(ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "ymdwrite")).length == 0 || String(ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "sanctslipno")).length== 0 )
	{
		alert("전표작성일자 또는 승인전표번호가 없는 상계건은 이 화면에서 취소 처리 할 수 없습니다.");
		grp_sea.button2.click();
		return false;
	}

	rtn = sysf_messageBox(" 다음 전표를 삭제하고, 해당건의 가수금 상계를 취소하시겠습니까? " + "\n\n"  +
							   "    - 전표작성일자 : "+ ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "ymdwrite")  + "\n" +
							   "    - 전표번호 : "+ ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "sanctslipno") + "\n\n" +
							   "[주의사항]" + "\n\n" +
							   " 먼저 전표발의등록 프로그램을 통해 해당 전표가  작업 대상 전표의 내용이 맞는지 반드시 확인부탁드립니다. " + "\n\n" +
							  "혹시 해당 전표일자, 전표번호가 다른 내용의 전표이면 작업을 중단하시고, 전산실 담당자에게 연락부탁드립니다.   "  ,"Q99");
	if ( rtn == "6" )
	{
		var oParam = {};
			oParam.id          = "TXRAR00301";
			oParam.service     = "accountinginfoapp.AccountingInfo";
			oParam.method      = "reqExeSanggyeCancel";
			oParam.inds        = "req=ds_main_maindatalist:u";
			oParam.outds       = "ds_=unsllist";
			oParam.async       = false;
			//oParam.callback    = "cf_TXRAR00301";

		tranf_submit(oParam);
		grp_sea.button2.click();
	}
	else
	{
		grp_sea.button2.click();
	}
}

function btn_print_onclick(obj:Button,  e:ClickEventInfo)
{
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/main/maindatalist", ds_main_maindatalist);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
	var option = null; 
	rptf_exeReportPreview30(["SMRAR00301"],[objParam], option);

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