YNU_JEUS/app_home/himed/xpapps/mis/bugtexecxp/xp/SMRBP00900_예산집행실적내역총괄(과별).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRBP00900" position="absolute 0 0 1199 771" titletext="예산집행실적내역총괄(과별)" oninit="SMRBP00900_oninit" onload="SMRBP00900_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="예산집행실적내역총괄(과별)" class="tit_1" position="absolute 0 0 250 25"/>
        <Shape id="line5" class="line_6" position="absolute 0 44 1194 50" anchor="left top right"/>
        <Button id="btn_print" taborder="1" text="출력" class="btn4" position="absolute 1136 23 1192 45" anchor="top right" onclick="btn_print_onclick"/>
        <Div id="group2" taborder="2" class="div_SA2" position="absolute 0 48 1190 88" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption9" text="예산년월 :" class="search_name" position="absolute 280 12 373 29"/>
              <Button id="btn_search" taborder="28" text="조회" class="btn1" position="absolute 1123 9 1179 31" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Shape id="line2" linetype="vertical" class="line_4" position="absolute 1104 8 1110 31" anchor="top right"/>
              <Combo id="cmb_instcd" taborder="29" class="combo_search" position="absolute 100 10 253 29"/>
              <Static id="caption8" text="소속기관 :" class="search_name" position="absolute 14 12 100 29"/>
              <Radio id="rdo_bugtflag" taborder="30" columncount="4" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 579 10 785 30" onitemchanged="group2_rdo_bugtflag_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">수입</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">비용</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">3</Col>
                      <Col id="datacolumn">구매</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">4</Col>
                      <Col id="datacolumn">자본</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Static id="caption5" text="예산구분 :" class="search_name" position="absolute 490 12 577 29"/>
              <Calendar id="ipt_acntyy" taborder="31" class="input_s_essential" position="absolute 367 10 467 29" mask="yyyy-mm-dd" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" value="null" editformat="yyyy-MM-dd" onchanged="group2_ipt_acntyy_onchanged"/>
              <Button id="button4" taborder="32" text="찾기" class="btn2" position="absolute 1010 10 1052 29" onclick="group2_button4_onclick"/>
              <Static id="caption1" text="조 회 :" class="search_name" position="absolute 810 12 921 29"/>
              <Edit id="input1" taborder="33" class="input_s_essential" position="absolute 875 10 1005 29" autoselect="true" autoskip="true" onkeydown="group2_input1_onkeydown"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid id="grd_bugtexecist" taborder="3" binddataset="ds_main_list_datalist" useinputpanel="false" position="absolute 0 119 1190 764" autoenter="select" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="21"/>
                <Column size="90"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="140"/>
                <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="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="부서명" taborder="undefined"/>
                <Cell col="2" colspan="4" text="계정과목" taborder="undefined"/>
                <Cell col="6" rowspan="2" text="예산액" taborder="undefined"/>
                <Cell col="7" rowspan="2" text="추경후예산액" taborder="undefined"/>
                <Cell col="8" rowspan="2" text="조정후예산액" taborder="undefined"/>
                <Cell col="9" rowspan="2" text="배정누계" taborder="undefined"/>
                <Cell col="10" rowspan="2" text="집행실적" taborder="undefined"/>
                <Cell col="11" rowspan="2" text="집행잔액" taborder="undefined"/>
                <Cell col="12" rowspan="2" text="배정잔액" taborder="undefined"/>
                <Cell col="13" rowspan="2" text="집행율" taborder="undefined"/>
                <Cell col="14" text="기관코드"/>
                <Cell col="15" text="구분"/>
                <Cell col="16" text="예산연도"/>
                <Cell col="17" text="부서코드"/>
                <Cell row="1" col="2" text="관"/>
                <Cell row="1" col="3" text="항"/>
                <Cell row="1" col="4" text="목"/>
                <Cell row="1" col="5" text="세목"/>
                <Cell row="1" col="14" text="기관코드"/>
                <Cell row="1" col="15" text="구분"/>
                <Cell row="1" col="16" text="예산연도"/>
                <Cell row="1" col="17" text="부서코드"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" style="align:left middle;padding:2 2 2 2;background:#ffcc99ff;background2:#ffcc99ff;" text="bind:depthngnm" editautoselect="true" suppress="1" suppressalign="first,over"/>
                <Cell col="2" style="align:left middle;padding:2 2 2 2;background:#ffcc99ff;background2:#ffcc99ff;" text="bind:supacntnm2" editautoselect="true" suppress="2" suppressalign="first,over"/>
                <Cell col="3" style="align:left middle;padding:2 2 2 2;background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:supacntnm3" editautoselect="true" suppress="3" suppressalign="first,over"/>
                <Cell col="4" style="align:left middle;padding:2 2 2 2;background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:supacntnm4" editautoselect="true" suppress="4" suppressalign="first,over"/>
                <Cell col="5" style="align:left middle;padding:2 2 2 2;background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:acntnm" editautoselect="true"/>
                <Cell col="6" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:totalorgbugtamt" editautoselect="true"/>
                <Cell col="7" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:totalrevsupmbugtamt" editautoselect="true"/>
                <Cell col="8" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:jojungamt" editautoselect="true"/>
                <Cell col="9" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:aggregate" editautoselect="true"/>
                <Cell col="10" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:actionresult" editautoselect="true"/>
                <Cell col="11" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:actionbalance" editautoselect="true"/>
                <Cell col="12" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:balance" editautoselect="true"/>
                <Cell col="13" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#cc99ff' : gubn == '5' ? '' : '');" text="bind:quarterexecut" editautoselect="true"/>
                <Cell col="14" text="bind:instcd"/>
                <Cell col="15" text="bind:gubn"/>
                <Cell col="16" text="bind:acntyy"/>
                <Cell col="17" text="bind:deptcd"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line1" class="line_10" position="absolute 0 114 1190 120" anchor="left top right"/>
        <Static id="caption2" text="예산집행실적내역총괄(과별)" class="tit_2" position="absolute 0 98 193 120"/>
        <Button id="btn_5" taborder="4" text="엑셀출력" class="btn7" position="absolute 1111 95 1191 114" anchor="top right" onclick="btn_5_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_retrparams" 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="acntyy" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="depthngnm" type="STRING" size="256"/>
          <Column id="bugtflag" type="STRING" size="256"/>
          <Column id="quarter" type="STRING" size="256"/>
          <Column id="todate" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="acntyy"/>
            <Col id="deptcd"/>
            <Col id="depthngnm"/>
            <Col id="bugtflag"/>
            <Col id="quarter"/>
            <Col id="todate"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_datalist" 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="acntyy" type="STRING" size="256" sumtext="회계년도"/>
          <Column id="deptcd" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="depthngnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="gubn" type="STRING" size="256" sumtext="구분"/>
          <Column id="supacntcd2" type="STRING" size="256" sumtext="관"/>
          <Column id="supacntnm2" type="STRING" size="256" sumtext="관명칭"/>
          <Column id="supacntcd3" type="STRING" size="256" sumtext="항"/>
          <Column id="supacntnm3" type="STRING" size="256" sumtext="항명칭"/>
          <Column id="supacntcd4" type="STRING" size="256" sumtext="목"/>
          <Column id="supacntnm4" type="STRING" size="256" sumtext="목명칭"/>
          <Column id="acntcd" type="STRING" size="256" sumtext="세세목"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="세세목명"/>
          <Column id="totalorgbugtamt" type="STRING" size="256" sumtext="본예산액"/>
          <Column id="totalrevsupmbugtamt" type="STRING" size="256" sumtext="추경예산액합계"/>
          <Column id="aggregate" type="STRING" size="256" sumtext="배정누계"/>
          <Column id="actionresult" type="STRING" size="256" sumtext="집행실적"/>
          <Column id="actionbalance" type="STRING" size="256" sumtext="집행잔액"/>
          <Column id="balance" type="STRING" size="256" sumtext="배정잔액"/>
          <Column id="quarterexecut" type="STRING" size="256" sumtext="집행율"/>
          <Column id="jojungamt" type="STRING" size="256" sumtext="집행율"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.cmb_instcd" propid="value" datasetid="ds_send_retrparams" columnid="instcd"/>
      <BindItem id="item1" compid="group2.ipt_acntyy" propid="value" datasetid="ds_send_retrparams" columnid="todate"/>
      <BindItem id="item2" compid="group2.rdo_bugtflag" propid="value" datasetid="ds_send_retrparams" columnid="bugtflag"/>
      <BindItem id="item3" compid="group2.input1" propid="value" datasetid="ds_send_search" columnid="nm"/>
    </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_acntcommonxp::RAD001.xjs";
include "mis_miscommonxp::RAC001.xjs";
include "mis_bugtcommonxp::RBC001.xjs";

var acntdept = "";
var bugtdept = "";
var Deptcd 	= sysf_getUserInfo("dutplcecd");
var Deptnm 	= sysf_getUserInfo("dutplcenm");
function SMRBP00900_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRBP00900_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_bugtexecist);
	
	fQuarterChange();
	fCheckAuth();
	fInitialize();
	group2.btn_search.click();
}

function fQuarterChange()
{				
	if (group2.ipt_acntyy.value >= String(group2.ipt_acntyy.value).substr(0,4) + "0101" && group2.ipt_acntyy.value <= String(group2.ipt_acntyy.value).substr(0,4) + "0331")
	{
		ds_send_retrparams.setColumn(0, "quarter", "1");
	}
	else if (group2.ipt_acntyy.value >= String(group2.ipt_acntyy.value).substr(0,4) + "0401" && group2.ipt_acntyy.value <= String(group2.ipt_acntyy.value).substr(0,4) + "0630")
	{
		ds_send_retrparams.setColumn(0, "quarter", "2");
	}
	else if (group2.ipt_acntyy.value >= String(group2.ipt_acntyy.value).substr(0,4) + "0701" && group2.ipt_acntyy.value <= String(group2.ipt_acntyy.value).substr(0,4) + "0930")
	{
		ds_send_retrparams.setColumn(0, "quarter", "3");
	}
	else if (group2.ipt_acntyy.value >= String(group2.ipt_acntyy.value).substr(0,4) + "1001" && group2.ipt_acntyy.value <= String(group2.ipt_acntyy.value).substr(0,4) + "1231")
	{
		ds_send_retrparams.setColumn(0, "quarter", "4");
	}
	ds_send_retrparams.setColumn(0, "acntyy", String(group2.ipt_acntyy.value).substr(0,4));
}

function fCheckAuth()
{
	group2.btn_search.enable = frmf_checkAuth("R");
}

function fInitialize()
{
	misfComboComCdListMulti("Z0007","group2.cmb_instcd");

	ds_send_retrparams.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_send_retrparams.setColumn(0, "todate", utlf_getCurrentDate());
	ds_send_retrparams.setColumn(0, "deptcd", Deptcd);
	ds_send_retrparams.setColumn(0, "depthngnm", Deptnm);
	
	group2.rdo_bugtflag.value = "2";
}
	
function group2_ipt_acntyy_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	group2.btn_search.click();
}

function group2_rdo_bugtflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	group2.btn_search.click();
}

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

function group2_button4_onclick(obj:Button,  e:ClickEventInfo)
{
	var vPrntnmCol = "depthngnm";
	var searchnm = ds_send_search.getColumn(0, "nm");
	
	var findRow = ds_main_list_datalist.findRow(vPrntnmCol, searchnm);
	ds_main_list_datalist.rowposition = findRow;
}

function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_list_datalist.clearData();
	
	fQuarterChange();
	
	var oParam = {};
		oParam.id          = "TRRBP00901";
		oParam.service     = "bugtexecapp.BugtExec";
		oParam.method      = "reqGetBugtResultSumList";
		oParam.inds        = "req=ds_send_retrparams";
		oParam.outds       = "ds_main_list_datalist=datalist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRBP00901";

	tranf_submit(oParam);
	
	ds_main_list_datalist.rowposition = -1;
}

function btn_5_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_bugtexecist, "excel", "see", false);
}

function btn_print_onclick(obj:Button,  e:ClickEventInfo)
{
	fPrint();
}

function fPrint()
{
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/main/list/datalist", ds_main_list_datalist);
		rptf_setNodeListToDOM(objDOM, "/root/send/retrparams", ds_send_retrparams);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source;  
	var option = ""; 
	rptf_exeReportPreview30(["RPRBP00901"],[objParam], option);
}]]></Script>
  </Form>
</FDL>