YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SMRFC00405_재물조사결과조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRFC00405" position="absolute 0 0 1188 800" titletext="재물조사결과조회" oninit="SMRFC00405_oninit" onload="SMRFC00405_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="재물조사 결과 조회" class="tit_1" position="absolute 0 0 186 25"/>
        <Shape id="line16" class="line_2" position="absolute 0 43 1185 49" anchor="left top right"/>
        <Button id="btn_clear" taborder="1" text="초기화" class="btn4" position="absolute 1060 22 1128 44" anchor="top right" onclick="btn_clear_onclick"/>
        <Button id="btn_save" taborder="2" text="저장" class="btn4" position="absolute 1130 22 1186 44" anchor="top right" onclick="btn_save_onclick"/>
        <Div id="grp_sea" taborder="3" position="absolute 0 47 1185 107" class="div_SA2" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="cap_instcd" text="기관코드 :" class="search_name" position="absolute 15 9 101 26" anchor="default"/>
              <Shape id="line1" linetype="vertical" class="line_4" position="absolute 1066 9 1072 51" anchor="top right"/>
              <Button id="btn_search" taborder="6" text="조회" class="btn1" position="absolute 1085 19 1141 41" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Combo id="cmb_instcd" taborder="7" class="combo_essential" enable="false" position="absolute 108 8 255 27" anchor="default" onitemchanged="grp_sea_cmb_instcd_onitemchanged"/>
              <Edit id="ipt_mngtdeptcd_search" taborder="8" class="input_search" position="absolute 115 34 210 53" anchor="default" autoselect="true" autoskip="true" style="align:center middle;"/>
              <Button id="btn_mngtdeptcd_search" taborder="9" class="icon_search" position="absolute 213 34 229 50" anchor="default" onclick="grp_sea_btn_mngtdeptcd_search_onclick"/>
              <Static id="caption9" text="사용부서 :" class="search_name" position="absolute 15 35 107 52" anchor="default"/>
              <Edit id="ipt_mngtdeptnm_search" taborder="10" position="absolute 232 34 382 53" anchor="default" class="output" readonly="true"/>
              <Edit id="ipt_acntcd_search" taborder="11" class="input_search" position="absolute 640 8 725 27" anchor="default" autoselect="true" autoskip="true" style="align:center middle;"/>
              <Edit id="ipt_acntnm_search" taborder="12" position="absolute 748 8 945 27" anchor="default" class="output" readonly="true"/>
              <Button id="btn_acntcd_search" taborder="13" class="icon_search" position="absolute 729 11 745 27" anchor="default" onclick="grp_sea_btn_acntcd_search_onclick"/>
              <Static id="caption5" text="계정:" class="search_name" position="absolute 575 10 640 27" anchor="default"/>
              <Static id="caption1" text="기준년도 :" class="search_name" position="absolute 330 10 416 27" anchor="default"/>
              <Edit id="ipt_installplcecd_search" taborder="14" class="input_search" position="absolute 515 34 610 53" anchor="default" autoselect="true" autoskip="true" style="align:center middle;"/>
              <Button id="btn_installplcecd_search" taborder="15" class="icon_search" position="absolute 613 34 629 50" anchor="default" onclick="grp_sea_btn_installplcecd_search_onclick"/>
              <Static id="caption2" text="설치장소 :" class="search_name" position="absolute 415 35 507 52" anchor="default"/>
              <Edit id="ipt_installplcenm_search" taborder="16" position="absolute 632 34 782 53" anchor="default" class="output" readonly="true"/>
              <Static id="caption3" text="보유상태 :" class="search_name" position="absolute 825 35 917 52" anchor="default"/>
              <Combo id="cmb_status" taborder="17" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 915 34 1015 53" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn"/>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <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>
                  </Rows>
                </Dataset>
              </Combo>
              <Spin id="ipt_yyyy" taborder="19" position="absolute 422 7 477 26" max="9999" style="align:center middle;" onkeydown="grp_sea_ipt_yyyy_onkeydown"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption13" text="기준일자 :" position="absolute 905 132 995 150" style="background:#c4e693ff;align:center middle;" align="align:center middle;" anchor="top right"/>
        <Edit id="input10" taborder="4" enable="false" position="absolute 998 131 1090 150" anchor="top right" style=":disabled {align:center middle;}"/>
        <Button id="button4" taborder="5" text="엑셀저장" class="btn7" position="absolute 1099 131 1185 150" anchor="top right" onclick="button4_onclick"/>
        <Shape id="line3" class="line_10" position="absolute 0 150 1185 156" anchor="left top right"/>
        <Grid id="grd_degolist" taborder="6" binddataset="ds_main_grid_degolist" useinputpanel="false" position="absolute 0 155 1185 751" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="20"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="216"/>
                <Column size="131"/>
                <Column size="35"/>
                <Column size="75"/>
                <Column size="70"/>
                <Column size="75"/>
                <Column size="0"/>
                <Column size="60"/>
                <Column size="0"/>
                <Column size="90"/>
                <Column size="90"/>
                <Column size="115"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </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="잔존가"/>
                <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="부서확인(fromdd)"/>
                <Cell col="19" text="부서확인(todd)"/>
                <Cell col="20" text="사용여부"/>
                <Cell col="21" text="기준금액(min)"/>
                <Cell col="22" text="기준금액(max)"/>
                <Cell col="23" text="사용부서코드"/>
                <Cell col="24" text="부서장승인자명"/>
                <Cell col="25" text="최종제출일자"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:acntcd"/>
                <Cell col="2" style="align:top;padding:4 2 2 2;" text="bind:acntnm" wordwrap="word"/>
                <Cell col="3" text="bind:fixasetcd"/>
                <Cell col="4" style="align:left middle;padding:0 0 0 10;" text="bind:goodflaghngnm"/>
                <Cell col="5" style="align:left top;padding:4 2 2 2;" text="bind:goodspec" wordwrap="word"/>
                <Cell col="6" style="align:center middle;" text="bind:goodqty"/>
                <Cell col="7" displaytype="number" text="bind:possnamt"/>
                <Cell col="8" displaytype="date" text="bind:possndd" calendardisplaynulltype="nulltext"/>
                <Cell col="9" displaytype="number" text="bind:janjonsak"/>
                <Cell col="10" displaytype="combo" edittype="combo" text="bind:status" enable="false"/>
                <Cell col="11" displaytype="combo" edittype="combo" style="align:center middle;" text="bind:silstatus" combodataset="ds_cmb_silstatus" combocodecol="value" combodatacol="label"/>
                <Cell col="12" text="bind:remark"/>
                <Cell col="13" style="align:center top;padding:4 2 2 2;" text="bind:mngtdeptnm" wordwrap="word"/>
                <Cell col="14" style="align:center top;padding:4 2 2 2;" text="bind:installplcenm" wordwrap="word"/>
                <Cell col="15" displaytype="text" edittype="text" style="align:center;" text="bind:silcmt"/>
                <Cell col="16" text="bind:yyyy"/>
                <Cell col="17" text="bind:basedd"/>
                <Cell col="18" text="bind:dfromdd"/>
                <Cell col="19" text="bind:dtodd"/>
                <Cell col="20" text="bind:useyn"/>
                <Cell col="21" text="bind:passnmin"/>
                <Cell col="22" text="bind:passnmax"/>
                <Cell col="23" text="bind:mngtdeptcd"/>
                <Cell col="24" text="bind:deptaprvnm"/>
                <Cell col="25" text="bind:senddd"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption10" text="재물조사 결과 리스트" class="tit_2" position="absolute 0 134 205 155"/>
        <Static id="caption4" text="* 잔존가 기준 : 기준년도의 6월달" position="absolute 566 128 767 148" style="background:#ffffccff;"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="yyyy" type="STRING" size="256"/>
          <Column id="mngtdeptcd_search" type="STRING" size="256"/>
          <Column id="mngtdeptnm_search" type="STRING" size="256"/>
          <Column id="basedd" type="STRING" size="256"/>
          <Column id="acntcd" type="STRING" size="256"/>
          <Column id="acntnm" type="STRING" size="256"/>
          <Column id="installplcecd" type="STRING" size="256"/>
          <Column id="installplcenm" type="STRING" size="256"/>
          <Column id="status" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="yyyy"/>
            <Col id="mngtdeptcd_search"/>
            <Col id="mngtdeptnm_search"/>
            <Col id="basedd"/>
            <Col id="acntcd"/>
            <Col id="acntnm"/>
            <Col id="installplcecd"/>
            <Col id="installplcenm"/>
            <Col id="status"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_grid_degolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
          <Column id="fixasetcd" type="STRING" size="256" sumtext="자산코드"/>
          <Column id="goodflaghngnm" type="STRING" size="256" sumtext="자산명"/>
          <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
          <Column id="goodqty" type="STRING" size="256" sumtext="수량"/>
          <Column id="possnamt" type="STRING" size="256" sumtext="취득금액"/>
          <Column id="possndd" type="STRING" size="256" sumtext="취득일자"/>
          <Column id="janjonsak" type="STRING" size="256" sumtext="잔존가액"/>
          <Column id="status" type="STRING" size="256" sumtext="보유상태"/>
          <Column id="remark" type="STRING" size="256" sumtext="부서비고"/>
          <Column id="mngtdeptnm" type="STRING" size="256" sumtext="사용부서"/>
          <Column id="installplcenm" type="STRING" size="256" sumtext="설치부서"/>
          <Column id="silstatus" type="STRING" size="256" sumtext="실사결과"/>
          <Column id="silcmt" type="STRING" size="256" sumtext="실사비고"/>
          <Column id="yyyy" type="STRING" size="256" sumtext="년도"/>
          <Column id="basedd" type="STRING" size="256" sumtext="기준일자"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_status" 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_silstatus" 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>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.cmb_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
      <BindItem id="item1" compid="grp_sea.ipt_mngtdeptcd_search" propid="value" datasetid="ds_send" columnid="mngtdeptcd_search"/>
      <BindItem id="item2" compid="grp_sea.ipt_mngtdeptnm_search" propid="value" datasetid="ds_send" columnid="mngtdeptnm_search"/>
      <BindItem id="item4" compid="grp_sea.ipt_acntcd_search" propid="value" datasetid="ds_send" columnid="acntcd"/>
      <BindItem id="item5" compid="grp_sea.ipt_acntnm_search" propid="value" datasetid="ds_send" columnid="acntnm"/>
      <BindItem id="item6" compid="grp_sea.cmb_status" propid="value" datasetid="ds_send" columnid="status"/>
      <BindItem id="item7" compid="grp_sea.ipt_installplcenm_search" propid="value" datasetid="ds_send" columnid="installplcenm"/>
      <BindItem id="item8" compid="grp_sea.ipt_installplcecd_search" propid="value" datasetid="ds_send" columnid="installplcecd"/>
      <BindItem id="item9" compid="input10" propid="value" datasetid="ds_send" columnid="basedd"/>
      <BindItem id="item10" compid="grp_sea.ipt_yyyy" propid="value" datasetid="ds_send" columnid="yyyy"/>
    </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_miscommonxp::RSZ001.xjs";
function SMRFC00405_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRFC00405_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_degolist);
	grdf_setRowTypeIcon(grd_degolist, 0);
	
	fInitialize();
}

function fInitialize()
{
	misfGridInit(grd_degolist);
	
	misfComboComCdList("C0048",grp_sea.cmb_instcd,"Y"); 
	grp_sea.cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");
	
	ds_send.setColumn(0, "yyyy", String(utlf_getCurrentDate()).substring(0, 4));
	
	grp_sea.ipt_acntcd_search.value = "";
	grp_sea.ipt_acntnm_search.value = "";
	grp_sea.ipt_installplcecd_search.value = "";
	grp_sea.ipt_installplcenm_search.value = "";

	var dutplcecd = sysf_getUserInfo("dutplcecd");	
	if(dutplcecd == "4020334000" || sysf_getUserInfo("userid") == "MIS"  || sysf_getUserInfo("userid") == "99207"   )
	{	
	}
	else
	{
		sysf_messageBox("물류팀외 조회할 수","I004");
		grp_sea.btn_search.enable = false;
		btn_save.enable = false;
		grp_sea.ipt_yyyy.enable = false;
		grp_sea.btn_mngtdeptcd_search.enable = false;
		grp_sea.ipt_mngtdeptcd_search.enable = false;
	}
}

function grp_sea_cmb_instcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	grp_sea.btn_search.click();
}

function ds_send_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "acntcd")
	{
		grp_sea.ipt_acntcd_search.value = e.newvalue;
		grp_sea.ipt_acntcd_search.setFocus();
		if(!utlf_isNull(e.newvalue))
		{
			rszfValidationCheck("TRRAC00111", "acntlist", "acntflag,useyn,jobgb,srhtxt", ",Y,2," + e.newvalue, "", "acntcd,acntnm",
								grp_sea.ipt_acntcd_search, "PPRAC00100", "useyn,acntcd","Y,grp_sea.ipt_acntcd_search");
		}
		else
		{
			grp_sea.ipt_acntnm_search.value = "";
		}
	}
	if(e.columnid == "mngtdeptcd_search")
	{
		grp_sea.ipt_mngtdeptcd_search.value = e.newvalue;
		grp_sea.ipt_mngtdeptcd_search.setFocus();
		misfSearchDept(grp_sea.ipt_mngtdeptnm_search);
	}
	if(e.columnid == "installplcecd")
	{
		grp_sea.ipt_installplcecd_search.value = e.newvalue;
		grp_sea.ipt_installplcecd_search.setFocus();
		misfSearchDept(grp_sea.ipt_installplcenm_search);
	}
}

function grp_sea_btn_acntcd_search_onclick(obj:Button,  e:ClickEventInfo)
{
	rszfOpenPopUpListByWndName(grp_sea.ipt_acntcd_search, "", "acntcd,acntnm","PPRAC00100","","");
}

function grp_sea_btn_mngtdeptcd_search_onclick(obj:Button,  e:ClickEventInfo)
{
	misfOpenPopUpList("02", grp_sea.ipt_mngtdeptcd_search,"","mngtdeptcd_search,mngtdeptnm_search");
}

function grp_sea_btn_installplcecd_search_onclick(obj:Button,  e:ClickEventInfo)
{
	misfOpenPopUpList("02", grp_sea.ipt_installplcecd_search,"","installplcecd,installplcenm");
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRFC00406";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetResultDegolist";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_grid_degolist=degolist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRFC00406";

	tranf_submit(oParam);
		
	var yyyy = utlf_transNullToEmpty(ds_main_grid_degolist.getColumn(0, "yyyy"));
	var basedd = String(utlf_transNullToEmpty(ds_main_grid_degolist.getColumn(0, "basedd")));
	var tbasedd = yyyy + "-" + basedd.substr(0,2)  + "-" + basedd.substr(2,2);
	
	ds_send.setColumn(0, "basedd", tbasedd);
}

function button4_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_main_grid_degolist.rowcount > 0)
	{
		var fileName ="재물조사결과조회_" + utlf_getCurrentDate();
		grdf_exportExcel(grd_degolist, fileName, "Sheet", "true", "", "");
	}
	else 
	{
		sysf_messageBox("저장 데이터가","I004");
	}					
}

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

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	var updtdata = grdf_getGridUpdateData(grd_degolist).rowcount;
													
	if (updtdata == 0) 
	{
		sysf_messageBox("변경된 데이터가","I004");
		return;
	}

	var oParam = {};
		oParam.id          = "TXRFC00405";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "setDegolist";
		oParam.inds        = "req=ds_main_grid_degolist:u";
		oParam.outds       = "";
		oParam.typeStr     = "mode";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRFC00405";

	tranf_submit(oParam);
	
	grp_sea.btn_search.click();
	sysf_messageBox("저장", "I002");
}

function grp_sea_ipt_yyyy_onkeydown(obj:Spin, e:KeyEventInfo)
{
	if( e.keycode == 13 ){
		grp_sea.btn_search.click();
	}
}
]]></Script>
  </Form>
</FDL>