YNU_JEUS/app_home/himed/xpapps/mis/slipxp/xp/SPRAD00107_편성내역조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPRAD00107" position="absolute 0 0 843 561" titletext="예산편성내역 HELP" oninit="SPRAD00107_oninit" onload="SPRAD00107_onload">
    <Layouts>
      <Layout>
        <Div id="group2" taborder="0" class="div_SA2" position="absolute 0 0 840 40" anchor="left top right">
          <Layouts>
            <Layout>
              <Edit id="ipt_refcond" taborder="1" class="input_s_essential" visible="false" position="absolute 323 11 555 30" autoselect="true" autoskip="true" onkeydown="group2_ipt_refcond_onkeydown"/>
              <Button id="btn_search" taborder="2" text="조회" class="btn1" position="absolute 771 9 827 31" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 755 6 761 34" anchor="top right"/>
              <Static id="caption2" text="조회조건 :" class="search_name" visible="false" position="absolute 235 12 326 29"/>
              <Static id="caption3" text="조회조건 :" class="search_name" visible="false" position="absolute 6 12 97 29"/>
              <Radio id="rdo_refcond" taborder="3" columncount="2" rowcount="0" innerdataset="@ds_init_refcond" codecolumn="value" datacolumn="label" class="radio_search" visible="false" position="absolute 91 10 224 30" onitemchanged="group2_rdo_refcond_onitemchanged"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption1" text="예산 편성 리스트" class="tit_2" position="absolute 0 46 145 68"/>
        <Shape id="line1" class="line_10" position="absolute 0 62 838 68" anchor="left top right"/>
        <Grid id="grd_bugtorgnzlist" class="grd_bugtorgnzlist" taborder="1" binddataset="ds_main_list_bugtorgnzlist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 67 838 530" anchor="all" oncelldblclick="grd_bugtorgnzlist_oncelldblclick" onexpanddown="grd_bugtorgnzlist_onexpanddown">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="27"/>
                <Column size="0"/>
                <Column size="50"/>
                <Column size="70"/>
                <Column size="230"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="120"/>
                <Column size="35"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="예산구분flag"/>
                <Cell col="2" text="구분"/>
                <Cell col="3" text="계정코드"/>
                <Cell col="4" text="계정명"/>
                <Cell col="5" text="예산코드"/>
                <Cell col="6" text="예산코드명"/>
                <Cell col="7" text="프로젝트ID"/>
                <Cell col="8" text="프로젝트명"/>
                <Cell col="9" text="본예산액(A)"/>
                <Cell col="10" text="추산액(B)"/>
                <Cell col="11" text="집행액(C)"/>
                <Cell col="12" text="예산가용액(A-B-C)"/>
                <Cell col="13" text="조회"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" text="bind:bugtflag"/>
                <Cell col="2" text="bind:bugtflagnm"/>
                <Cell col="3" text="bind:acntcd"/>
                <Cell col="4" text="bind:acntnm"/>
                <Cell col="5" text="bind:bugtcd"/>
                <Cell col="6" text="bind:bugtnm"/>
                <Cell col="7" text="bind:projectid"/>
                <Cell col="8" text="bind:projectnm"/>
                <Cell col="9" displaytype="number" text="bind:orgbugtamtsum"/>
                <Cell col="10" displaytype="number" text="bind:revbugtamtsum"/>
                <Cell col="11" displaytype="number" text="bind:bugtexecamtsum"/>
                <Cell col="12" displaytype="number" text="bind:bugtamt"/>
                <Cell col="13" displaytype="text" edittype="text" text="bind:bugtsearch" editautoselect="true" expandshow="show"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line32" class="line_6" position="absolute 0 533 787 539" anchor="left right bottom"/>
        <Button id="btn_confirm" taborder="2" text="확인" class="btn4" position="absolute 725 537 781 559" anchor="right bottom" onclick="btn_confirm_onclick"/>
        <Button id="btn_cancel" taborder="3" text="취소" class="btn4" position="absolute 782 537 838 559" anchor="right bottom" onclick="btn_cancel_onclick"/>
      </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="retrnm" type="STRING" size="256"/>
          <Column id="refcond" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="unsldd" type="STRING" size="256"/>
          <Column id="sqlkind" type="STRING" size="256"/>
          <Column id="drcrflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="retrnm"/>
            <Col id="refcond"/>
            <Col id="deptcd"/>
            <Col id="unsldd"/>
            <Col id="sqlkind">origin</Col>
            <Col id="drcrflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_bugtorgnzlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="bugtflagnm" type="STRING" size="256" sumtext="예산구분flag"/>
          <Column id="bugtflag" type="STRING" size="256" sumtext="예산구분"/>
          <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
          <Column id="bugtcd" type="STRING" size="256" sumtext="예산코드"/>
          <Column id="bugtnm" type="STRING" size="256" sumtext="예산명"/>
          <Column id="projectid" type="STRING" size="256" sumtext="프로젝트ID"/>
          <Column id="projectnm" type="STRING" size="256" sumtext="프로젝트명"/>
          <Column id="orgbugtamtsum" type="BIGDECIMAL" size="256" sumtext="본예산액"/>
          <Column id="revbugtamtsum" type="BIGDECIMAL" size="256" sumtext="추산액"/>
          <Column id="bugtexecamtsum" type="BIGDECIMAL" size="256" sumtext="예산집행액"/>
          <Column id="bugtamt" type="BIGDECIMAL" size="256" sumtext="잔액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_refcond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">코드명</Col>
            <Col id="value">codenm</Col>
          </Row>
          <Row>
            <Col id="label">코드</Col>
            <Col id="value">code</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_target_defaultvalue" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_target_recvitem" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_target" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_source_bugtlist" 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="deptcd" type="STRING" size="256"/>
          <Column id="acntcd" type="STRING" size="256"/>
          <Column id="projectid" type="STRING" size="256"/>
          <Column id="bugtflag" type="STRING" size="256"/>
          <Column id="unsldd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="deptcd"/>
            <Col id="acntcd"/>
            <Col id="projectid"/>
            <Col id="bugtflag"/>
            <Col id="unsldd"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <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 SPRAD00107_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPRAD00107_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_bugtorgnzlist);
	
	try 
	{
		ds_target_defaultvalue.copyData(arg_ds_target_defaultvalue);
	} 
	catch (e) 
	{}
	try 
	{
		ds_target_recvitem.copyData(arg_ds_target_recvitem);
	} 
	catch (e) 
	{}
	try 
	{
		ds_target.copyData(arg_ds_target);
	} 
	catch (e)
	{}
	
	fInit();
}

function fInit()
{
	group2.rdo_refcond.index = 0;

	ds_main_list_bugtorgnzlist.clearData();
	
	ds_send.setColumn(0, "instcd", ds_target_defaultvalue.getColumn(0, "instcd"));
	ds_send.setColumn(0, "unsldd", ds_target_defaultvalue.getColumn(0, "unsldd"));
	ds_send.setColumn(0, "drcrflag", ds_target_defaultvalue.getColumn(0, "drcrflag"));
	
	ds_source_bugtlist.setColumn(0, "instcd", ds_target_defaultvalue.getColumn(0, "instcd"));
	ds_source_bugtlist.setColumn(0, "deptcd", ds_target_defaultvalue.getColumn(0, "deptcd"));
	ds_source_bugtlist.setColumn(0, "unsldd", ds_target_defaultvalue.getColumn(0, "unsldd"));
	
	//misfMsterDetailSet(grd_bugtorgnzlist, null, "TRRAD90107", "N", "byRow");

	var sColWidth;

	if(ds_target_defaultvalue.getColumn(0, "instcd") != "103")
	{
		sColWidth = "0, 60, 70, 150,0,0,0,0,115,115,115,135, 30";
		
		grd_bugtorgnzlist.setFormatColProperty(7, "size", 0);
		grd_bugtorgnzlist.setFormatColProperty(8, "size", 0);
	}
	else
	{
		sColWidth = "0, 50, 60, 135, 0, 0, 70, 95, 85, 85, 85, 105, 30"
	}
	
	var arrColWidth = sColWidth.split(",");
	
	for(var i = 0; i < arrColWidth.length; i++)
	{
		grd_bugtorgnzlist.getFormatColProperty(i, "size", parseFloat(arrColWidth[i]));
	}

	group2.btn_search.click();
	group2.ipt_refcond.setFocus();
}

function group2_rdo_refcond_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	group2.ipt_refcond.setFocus();
}

function group2_ipt_refcond_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		group2.btn_search.click();
	}
}

function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRAD90107";
		oParam.service     = "slipapp.AccBook";
		oParam.method      = "reqGetBugtOrgnzList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_list_bugtorgnzlist=bugtorgnzlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAD90107";

	tranf_submit(oParam);
}

function grd_bugtorgnzlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	misfPopUpListReturn(grd_bugtorgnzlist);
}

function grd_bugtorgnzlist_onexpanddown(obj:Grid, e:GridMouseEventInfo)
{
	ds_source_bugtlist.setColumn(0, "acntcd", ds_main_list_bugtorgnzlist.getColumn(e.row, "acntcd"));
	ds_source_bugtlist.setColumn(0, "projectid", ds_main_list_bugtorgnzlist.getColumn(e.row, "projectid"));
	ds_source_bugtlist.setColumn(0, "bugtflag", ds_main_list_bugtorgnzlist.getColumn(e.row, "bugtflag"));
	
	var objArg = new Object();
		objArg.arg_target = ds_source_bugtlist;
	frmf_modal("SPRAD00109", "SPRAD00109", objArg, "", "", "", "", "", "", "", "", "", "M");
}

function btn_confirm_onclick(obj:Button,  e:ClickEventInfo)
{
	misfPopUpListReturn(grd_bugtorgnzlist);
}

function btn_cancel_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();
}
]]></Script>
  </Form>
</FDL>