YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SMRFC00919_년도별자산현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRFC00919" position="absolute 0 0 1200 756" titletext="년도별자산현황" oninit="SMRFC00919_oninit" onload="SMRFC00919_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="년도별 자산현황" class="tit_1" position="absolute 0 0 186 25"/>
        <Shape id="line14" class="line_6" position="absolute 0 38 1195 44" anchor="left top right"/>
        <Button id="btn_init" taborder="1" text="초기화" class="btn4" position="absolute 1127 17 1195 39" anchor="top right" onclick="btn_init_onclick"/>
        <Div id="group5" anchor="left top right" taborder="2" class="div_SA2" position="absolute 0 42 1195 102">
          <Layouts>
            <Layout>
              <Edit id="ipt_mngtdeptcd_search" taborder="21" class="input_search" position="absolute 95 32 180 51" onkeyup="group5_ipt_mngtdeptcd_search_onkeyup"/>
              <Button id="btn_mngtdeptcd_search" taborder="22" class="icon_search" position="absolute 184 33 200 49" onclick="group5_btn_mngtdeptcd_search_onclick"/>
              <Edit id="ipt_mngtdeptnm_search" taborder="23" class="input_search" position="absolute 203 32 400 51" onkeyup="group5_ipt_mngtdeptnm_search_onkeyup"/>
              <Static id="cap_possndd_search" text="취득일자 :" class="search_name" position="absolute 486 6 580 23"/>
              <Calendar id="ipt_possnfrdd_search" taborder="24" class="input_default" position="absolute 576 4 674 23" mask="yyyy-mm-dd"/>
              <Button id="btn_search" taborder="25" text="조회" class="btn1" position="absolute 1120 19 1176 41" anchor="top right" onclick="group5_btn_search_onclick"/>
              <Static id="cap_instcd_search" text="기관코드 :" class="search_name" position="absolute 7 6 108 23"/>
              <Combo id="cmb_instcd_search" taborder="26" class="combo_essential" enable="false" position="absolute 95 4 290 23"/>
              <Shape id="line12" linetype="vertical" class="line_4" position="absolute 1102 6 1108 52" anchor="top right"/>
              <Calendar id="ipt_possntodd_search" taborder="27" class="input_default" position="absolute 699 4 797 23" mask="yyyy-mm-dd"/>
              <Static id="caption2" text="~" position="absolute 681 5 696 25"/>
              <Static id="cap_installplcecd" text="운용부서 :" class="search_name" position="absolute 7 32 83 49"/>
              <Combo id="cmb_deptflag_search" taborder="28" position="absolute 937 4 1017 23"/>
              <Static id="caption1" text="부서구분 :" class="search_name" position="absolute 847 6 963 23"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line16" linetype="vertical" class="line_1" position="absolute 0 193 1190 194"/>
        <Tab id="switch1" taborder="4" tabindex="0" position="absolute 0 120 1195 750" class="tab_Normal" anchor="all">
          <Tabpages>
            <Tabpage id="case_fixasetlist">
              <Layouts>
                <Layout>
                  <Grid id="grd_fixasetlist" class="datagrid2" taborder="0" binddataset="ds_main_list_fixaset_fixasetlist" useinputpanel="false" position="absolute 0 0 1195 601" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="26"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="75"/>
                          <Column size="60"/>
                          <Column size="45"/>
                          <Column size="60"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="75"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="75"/>
                          <Column size="60"/>
                          <Column size="60"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24" band="head"/>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                          <Row size="24" band="summ"/>
                        </Rows>
                        <Band id="head">
                          <Cell rowspan="3" taborder="undefined"/>
                          <Cell col="1" rowspan="3" text="년도/분류" taborder="undefined"/>
                          <Cell col="2" colspan="6" text="컴퓨터" taborder="undefined"/>
                          <Cell col="8" colspan="5" text="모니터" taborder="undefined"/>
                          <Cell col="13" colspan="5" text="프린터" taborder="undefined"/>
                          <Cell row="1" col="2" colspan="3" text="정리" taborder="undefined"/>
                          <Cell row="1" col="5" text="미비"/>
                          <Cell row="1" col="6" rowspan="2" text="노트북" taborder="undefined"/>
                          <Cell row="1" col="7" rowspan="2" text="계" taborder="undefined"/>
                          <Cell row="1" col="8" colspan="3" text="정리" taborder="undefined"/>
                          <Cell row="1" col="11" text="미비"/>
                          <Cell row="1" col="12" rowspan="2" text="계" taborder="undefined"/>
                          <Cell row="1" col="13" colspan="3" text="정리" taborder="undefined"/>
                          <Cell row="1" col="16" text="미비"/>
                          <Cell row="1" col="17" rowspan="2" text="계" taborder="undefined"/>
                          <Cell row="2" col="2" text="10.01(정상)"/>
                          <Cell row="2" col="3" text="10.05(기금)"/>
                          <Cell row="2" col="4" text="10.91(CDIS)"/>
                          <Cell row="2" col="5" text="03.11"/>
                          <Cell row="2" col="8" text="10.02(정상)"/>
                          <Cell row="2" col="9" text="10.05(기금)"/>
                          <Cell row="2" col="10" text="10.91(CDIS)"/>
                          <Cell row="2" col="11" text="03.26"/>
                          <Cell row="2" col="13" text="10.03(정상)"/>
                          <Cell row="2" col="14" text="10.05(기금)"/>
                          <Cell row="2" col="15" text="10.91(CDIS)"/>
                          <Cell row="2" col="16" text="03.09"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="currow+1"/>
                          <Cell col="1" style="align:center middle;" text="bind:year"/>
                          <Cell col="2" style="align:center middle;" text="bind:com1_qty"/>
                          <Cell col="3" style="align:center middle;" text="bind:com2_qty"/>
                          <Cell col="4" style="align:center middle;" text="bind:com3_qty"/>
                          <Cell col="5" style="align:center middle;" text="bind:com4_qty"/>
                          <Cell col="6" style="align:center middle;" text="bind:com5_qty"/>
                          <Cell col="7" displaytype="number" style="align:center middle;" text="bind:comt_qty"/>
                          <Cell col="8" style="align:center middle;" text="bind:mon1_qty"/>
                          <Cell col="9" style="align:center middle;" text="bind:mon2_qty"/>
                          <Cell col="10" style="align:center middle;" text="bind:mon3_qty"/>
                          <Cell col="11" style="align:center middle;" text="bind:mon4_qty"/>
                          <Cell col="12" displaytype="number" style="align:center middle;" text="bind:mont_qty"/>
                          <Cell col="13" style="align:center middle;" text="bind:prt1_qty"/>
                          <Cell col="14" style="align:center middle;" text="bind:prt2_qty"/>
                          <Cell col="15" style="align:center middle;" text="bind:prt3_qty"/>
                          <Cell col="16" style="align:center middle;" text="bind:prt4_qty"/>
                          <Cell col="17" displaytype="number" style="align:center middle;" text="bind:prtt_qty"/>
                        </Band>
                        <Band id="summary">
                          <Cell style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;"/>
                          <Cell col="1" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="총계"/>
                          <Cell col="2" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('com1_qty')"/>
                          <Cell col="3" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('com2_qty')"/>
                          <Cell col="4" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('com3_qty')"/>
                          <Cell col="5" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('com4_qty')"/>
                          <Cell col="6" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('com5_qty')"/>
                          <Cell col="7" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('comt_qty')"/>
                          <Cell col="8" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('mon1_qty')"/>
                          <Cell col="9" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('mon2_qty')"/>
                          <Cell col="10" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('mon3_qty')"/>
                          <Cell col="11" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('mon4_qty')"/>
                          <Cell col="12" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('mont_qty')"/>
                          <Cell col="13" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('prt1_qty')"/>
                          <Cell col="14" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('prt2_qty')"/>
                          <Cell col="15" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('prt3_qty')"/>
                          <Cell col="16" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('prt4_qty')"/>
                          <Cell col="17" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('prtt_qty')"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="case_fixasetmodel"/>
          </Tabpages>
        </Tab>
        <Button id="btn_excel" taborder="3" text="Excel 저장" class="btn5" position="absolute 1120 110 1195 129" anchor="top right" onclick="btn_excel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_fixasetlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_fixasetlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="mngtdeptcd" type="STRING" size="256"/>
          <Column id="mngtdeptnm" type="STRING" size="256"/>
          <Column id="possnfrdd" type="STRING" size="256"/>
          <Column id="possntodd" type="STRING" size="256"/>
          <Column id="deptflag" type="STRING" size="256"/>
          <Column id="mdlcd" type="STRING" size="256"/>
          <Column id="smlcd" type="STRING" size="256"/>
          <Column id="possndd" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="mngtdeptcd"/>
            <Col id="mngtdeptnm"/>
            <Col id="possnfrdd"/>
            <Col id="possntodd"/>
            <Col id="deptflag"/>
            <Col id="mdlcd"/>
            <Col id="smlcd"/>
            <Col id="possndd"/>
            <Col id="gubun"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_fixaset_fixasetlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="year" type="STRING" size="256" sumtext="년도              "/>
          <Column id="com1_qty" type="STRING" size="256" sumtext="컴퓨터10.01 "/>
          <Column id="com2_qty" type="STRING" size="256" sumtext="컴퓨터10.05 "/>
          <Column id="com3_qty" type="STRING" size="256" sumtext="컴퓨터10.91 "/>
          <Column id="com4_qty" type="STRING" size="256" sumtext="컴퓨터03.11 "/>
          <Column id="com5_qty" type="STRING" size="256" sumtext="노트북            "/>
          <Column id="comt_qty" type="STRING" size="256" sumtext="컴퓨터계        "/>
          <Column id="mon1_qty" type="STRING" size="256" sumtext="모니터10.02 "/>
          <Column id="mon2_qty" type="STRING" size="256" sumtext="모니터10.05 "/>
          <Column id="mon3_qty" type="STRING" size="256" sumtext="모니터10.91 "/>
          <Column id="mon4_qty" type="STRING" size="256" sumtext="모니터03.26 "/>
          <Column id="mont_qty" type="STRING" size="256" sumtext="모니터계         "/>
          <Column id="prt1_qty" type="STRING" size="256" sumtext="프린터10.03 "/>
          <Column id="prt2_qty" type="STRING" size="256" sumtext="프린터10.05 "/>
          <Column id="prt3_qty" type="STRING" size="256" sumtext="프린터10.91 "/>
          <Column id="prt4_qty" type="STRING" size="256" sumtext="프린터03.09 "/>
          <Column id="prtt_qty" type="STRING" size="256" sumtext="프린터계         "/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_fixasetdet_fixasettmplist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group5.cmb_instcd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="instcd"/>
      <BindItem id="item1" compid="group5.ipt_mngtdeptcd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="mngtdeptcd"/>
      <BindItem id="item2" compid="group5.ipt_mngtdeptnm_search" propid="value" datasetid="ds_send_fixasetlist" columnid="mngtdeptnm"/>
      <BindItem id="item3" compid="group5.ipt_possnfrdd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="possnfrdd"/>
      <BindItem id="item4" compid="group5.ipt_possntodd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="possntodd"/>
      <BindItem id="item5" compid="group5.cmb_deptflag_search" propid="value" datasetid="ds_send_fixasetlist" columnid="deptflag"/>
    </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 SMRFC00919_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRFC00919_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(switch1.case_fixasetlist.grd_fixasetlist);
	fInitialize();	
}

function fInitialize()
{
	misfGridInit(switch1.case_fixasetlist.grd_fixasetlist);
					
	misfComboComCdListMulti("C0048,R0480", "group5.cmb_instcd_search,group5.cmb_deptflag_search");

	frmf_addComboItem("group5.cmb_deptflag_search", "전체", "", "above" );				
	ds_send_fixasetlist.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd")); // 기관 설정
	
	ds_main_fixasetdet_fixasettmplist.clearData();
	ds_main_list_fixaset_fixasetlist.clearData();

	//misfMsterDetailSet(grd_fixasetlist, null, "TRRFC00919", "Y" , "byrow");
	
	var curdate = utlf_getCurrentDate();
	
	group5.ipt_possnfrdd_search.value = "20040101";
	group5.ipt_possntodd_search.value = curdate;
}		

function ds_send_fixasetlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "mngtdeptcd")
	{
		group5.ipt_mngtdeptnm_search.setFocus();
		misfSearchDept(group5.ipt_mngtdeptnm_search);
	}
}

function group5_ipt_mngtdeptcd_search_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
	}
}

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

function group5_btn_mngtdeptcd_search_onclick(obj:Button,  e:ClickEventInfo)
{
	misfOpenPopUpList("02", group5.ipt_mngtdeptcd_search,"","mngtdeptcd,mngtdeptnm");
}

function group5_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var mngtdeptcd = ds_send_fixasetlist.getColumn(0, "mngtdeptcd");
	var deptflag = ds_send_fixasetlist.getColumn(0, "deptflag");
	
	if (utlf_isNull(mngtdeptcd))
	{	
		ds_send_fixasetlist.setColumn(0, "mngtdeptcd",'%%');
	}
	if(utlf_isNull(deptflag))
	{
		ds_send_fixasetlist.setColumn(0, "deptflag",'%%');
	}
	
	misfGridInit(switch1.case_fixasetlist.grd_fixasetlist);
	
	var oParam = {};
		oParam.id          = "TXRFC00919";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetYearFixAsetList";
		oParam.inds        = "req=ds_send_fixasetlist";
		oParam.outds       = "";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRFC00919";

	tranf_submit(oParam);
	
	var oParam = {};
		oParam.id          = "TRRFC00919";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetYearRfcmrepList";
		oParam.inds        = "req=ds_send_fixasetlist";
		oParam.outds       = "ds_main_list_fixaset_fixasetlist=fixasetlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRFC00919";

	tranf_submit(oParam);
								
	if(ds_main_list_fixaset_fixasetlist.rowcount > 0)
	{
		ds_main_list_fixaset_fixasetlist.rowposition = 0;
	}
	else
	{
		ds_main_fixasetdet_fixasettmplist.clearData();
	}
}

function btn_init_onclick(obj:Button,  e:ClickEventInfo)
{
	fInitialize();
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	if( ds_main_list_fixaset_fixasetlist.rowcount > 0)
	{
		var fileName = "년도별 자산현황_" + utlf_getCurrentDate();
		grdf_exportExcel(switch1.case_fixasetlist.grd_fixasetlist, fileName, "Sheet", "true", "", "");
	}
	else 
	{
		sysf_messageBox("저장 데이터가","I004");
	}
}
]]></Script>
  </Form>
</FDL>