YNU_JEUS/app_home/himed/xpapps/mis/slipxp/xp/SPRAD00125_예산가용액조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPRAD00125" position="absolute 0 0 895 387" titletext="예산가용액조회" oninit="SPRAD00125_oninit" onload="SPRAD00125_onload">
    <Layouts>
      <Layout>
        <Grid id="grd_bugtlist" taborder="0" binddataset="ds_main_list_bugtlist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 25 890 355">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="22"/>
                <Column size="120"/>
                <Column size="0"/>
                <Column size="120"/>
                <Column size="70"/>
                <Column size="0"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <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="기관코드"/>
                <Cell col="1" text="미결전표일자"/>
                <Cell col="2" text="일련번호"/>
                <Cell col="3" text="예산귀속부서코드"/>
                <Cell col="4"/>
                <Cell col="5" text="귀속부서"/>
                <Cell col="6" text="계정코드"/>
                <Cell col="7" text="계정명"/>
                <Cell col="8" text="Project ID"/>
                <Cell col="9" text="잔액구분"/>
                <Cell col="10" text="수익비용구분"/>
                <Cell col="11" text="예산구분"/>
                <Cell col="12" text="본예산액"/>
                <Cell col="13" text="추경예산액"/>
                <Cell col="14" text="계정대체"/>
                <Cell col="15" text="이월조정예산"/>
                <Cell col="16" text="조정예산"/>
                <Cell col="17" text="추산액"/>
                <Cell col="18" text="집행액"/>
                <Cell col="19" text="전표금액"/>
                <Cell col="20" text="사용전 예산"/>
                <Cell col="21" text="사용후 예산"/>
              </Band>
              <Band id="body">
                <Cell text="bind:instcd"/>
                <Cell col="1" text="bind:unsldd"/>
                <Cell col="2" text="bind:unslno"/>
                <Cell col="3" text="bind:costcntrdeptcd"/>
                <Cell col="4" celltype="head"/>
                <Cell col="5" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:costcntrdeptnm"/>
                <Cell col="6" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:acntcd"/>
                <Cell col="7" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:acntnm"/>
                <Cell col="8" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:projectid"/>
                <Cell col="9" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:balflag"/>
                <Cell col="10" displaytype="combo" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:bugtearncostflag" combodataset="ds_cmb_bugtearncostflag" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="11" displaytype="combo" edittype="combo" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:bugtflag" combodataset="ds_cmb_bugtflag" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="12" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:orgbugtamt" mask="#,###"/>
                <Cell col="13" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:revsupmbugtamt" mask="#,###"/>
                <Cell col="14" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:orgbugtupdtamt" mask="#,###"/>
                <Cell col="15" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:orgbugtadjtamt" mask="#,###"/>
                <Cell col="16" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:revsupmbugtadjtamt" mask="#,###"/>
                <Cell col="17" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:bugtexpcamt" mask="#,###"/>
                <Cell col="18" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:bugtexecamt" mask="#,###"/>
                <Cell col="19" displaytype="number" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:amt"/>
                <Cell col="20" displaytype="number" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:sumbugtamt"/>
                <Cell col="21" displaytype="number" style="background:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');background2:EXPR(resultamt &lt; 0 ? '#ffff00' : '#ffffff');" text="bind:resultamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line3" class="line_10" position="absolute 0 20 890 26"/>
        <Static id="caption1" text="예산 가용액 조회" class="tit_2" position="absolute 0 4 183 25"/>
        <Button id="btn_hidden" taborder="1" text="자세히" class="btn2" position="absolute 837 1 890 20" onclick="btn_hidden_onclick"/>
        <Shape id="line32" class="line_6" position="absolute 1 354 891 360"/>
        <Button id="btn_cancel" taborder="2" text="닫기" class="btn4" position="absolute 834 359 890 381" anchor="right bottom" onclick="btn_cancel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_list_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" sumtext="기관코드"/>
          <Column id="unsldd" type="STRING" size="256" sumtext="미결전표일자"/>
          <Column id="unslno" type="STRING" size="256" sumtext="미결전표번호"/>
          <Column id="costcntrdeptcd" type="STRING" size="256" sumtext="귀속부서코드"/>
          <Column id="costcntrdeptnm" type="STRING" size="256" sumtext="귀속부서명"/>
          <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
          <Column id="projectid" type="STRING" size="256" sumtext="프로젝트ID"/>
          <Column id="balflag" type="STRING" size="256" sumtext="잔액구분"/>
          <Column id="bugtearncostflag" type="STRING" size="256" sumtext="예산수익비용구분"/>
          <Column id="bugtflag" type="STRING" size="256" sumtext="예산구분"/>
          <Column id="orgbugtamt" type="STRING" size="256" sumtext="본예산"/>
          <Column id="revsupmbugtamt" type="STRING" size="256" sumtext="추경예산"/>
          <Column id="orgbugtupdtamt" type="STRING" size="256" sumtext="계정대체"/>
          <Column id="orgbugtadjtamt" type="STRING" size="256" sumtext="이월조정예산"/>
          <Column id="revsupmbugtadjtamt" type="STRING" size="256" sumtext="조정예산"/>
          <Column id="bugtexpcamt" type="STRING" size="256" sumtext="추산액"/>
          <Column id="bugtexecamt" type="STRING" size="256" sumtext="집행액"/>
          <Column id="amt" type="STRING" size="256" sumtext="전표금액"/>
          <Column id="sumbugtamt" type="STRING" size="256" sumtext="예산가용총액"/>
          <Column id="resultamt" type="STRING" size="256" sumtext="전송후예산가용금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_bugtearncostflag" 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">1</Col>
          </Row>
          <Row>
            <Col id="label">비용</Col>
            <Col id="value">2</Col>
          </Row>
          <Row>
            <Col id="label">수익/비용</Col>
            <Col id="value">3</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_bugtflag" 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">1</Col>
          </Row>
          <Row>
            <Col id="label">비용</Col>
            <Col id="value">2</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_target_availablebugtinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_condition" 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="unsldd" type="STRING" size="256"/>
          <Column id="unslno" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="unsldd"/>
            <Col id="unslno"/>
          </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 SPRAD00125_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPRAD00125_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_bugtlist);
	grdf_setRowTypeIcon(grd_bugtlist, 4);
	
	try
	{
		ds_target_availablebugtinfo.copyData(arg_ds_target);
	}
	fOpenForm();
}

function fOpenForm()
{
	ds_send_condition.setColumn(0, "instcd", ds_target_availablebugtinfo.getColumn(0, "instcd"));
	ds_send_condition.setColumn(0, "unsldd", ds_target_availablebugtinfo.getColumn(0, "unsldd"));
	ds_send_condition.setColumn(0, "unslno", ds_target_availablebugtinfo.getColumn(0, "unslno"));
	
	var oParam = {};
		oParam.id          = "TRRAD00125";
		oParam.service     = "slipapp.Slip";
		oParam.method      = "reqGetAvailableBugtList";
		oParam.inds        = "req=ds_send_condition";
		oParam.outds       = "ds_main_list_bugtlist=bugtlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAD00125";

	tranf_submit(oParam);	
}

function btn_hidden_onclick(obj:Button,  e:ClickEventInfo)
{
	var vHiddenYN = 0;
					
	if(btn_hidden.text == "자세히")
	{
		vHiddenYN = 100;
		btn_hidden.text = "간단히";												
	}
	else if(btn_hidden.text == "간단히")
	{
		vHiddenYN = 0;
		btn_hidden.text = "자세히";						
	}
	
	grd_bugtlist.setFormatColProperty(grd_bugtlist.getBindCellIndex("Body", "orgbugtamt"), "size",  vHiddenYN);
	grd_bugtlist.setFormatColProperty(grd_bugtlist.getBindCellIndex("Body", "revsupmbugtamt"), "size",  vHiddenYN);
	grd_bugtlist.setFormatColProperty(grd_bugtlist.getBindCellIndex("Body", "orgbugtupdtamt"), "size",  vHiddenYN);
	grd_bugtlist.setFormatColProperty(grd_bugtlist.getBindCellIndex("Body", "orgbugtadjtamt"), "size",  vHiddenYN);
	grd_bugtlist.setFormatColProperty(grd_bugtlist.getBindCellIndex("Body", "revsupmbugtadjtamt"), "size",  vHiddenYN);
	grd_bugtlist.setFormatColProperty(grd_bugtlist.getBindCellIndex("Body", "bugtexpcamt"), "size",  vHiddenYN);	
}

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