YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SMRFC00401_재물기준정보관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRFC00401" position="absolute 0 0 1200 784" titletext="재물기준정보관리" oninit="SMRFC00401_oninit" onload="SMRFC00401_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="재물조사 기준정보 설정" class="tit_1" position="absolute 0 0 234 25"/>
        <Shape id="line16" class="line_2" position="absolute 0 44 1195 50" anchor="left top right"/>
        <Button id="btn_save" taborder="1" text="저장" class="btn4" position="absolute 1069 23 1125 45" anchor="top right" onclick="btn_save_onclick"/>
        <Button id="btn_clear" taborder="2" text="초기화" class="btn4" position="absolute 1127 23 1195 45" anchor="top right" onclick="btn_clear_onclick"/>
        <Div id="grp_sea" anchor="left top right" taborder="3" class="div_SA2" position="absolute 0 48 1195 88">
          <Layouts>
            <Layout>
              <Static id="cap_instcd" text="기관코드 :" class="search_name" position="absolute 15 10 101 27"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1106 7 1112 32" anchor="top right"/>
              <Static id="cap_deptcd" text="기준년도 :" class="search_name" position="absolute 511 10 601 27"/>
              <Button id="btn_search" taborder="3" text="조회" class="btn1" position="absolute 1124 8 1180 30" onclick="grp_sea_btn_search_onclick" anchor="top right"/>
              <Combo id="cmb_instcd" taborder="4" class="combo_essential" enable="false" position="absolute 108 9 346 28" onitemchanged="grp_sea_cmb_instcd_onitemchanged"/>
              <Spin id="ipt_yyyy" taborder="6" max="9999" position="absolute 605 9 710 28" style="align:center middle;" onkeydown="grp_sea_ipt_yyyy_onkeydown"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line2" class="line_10" position="absolute 0 131 1195 137" anchor="left top right"/>
        <Static id="caption8" text="기준정보 리스트" class="tit_2" position="absolute 0 115 133 138"/>
        <Button id="btn_grdadd" taborder="4" text="행추가" class="btn2" position="absolute 1087 112 1140 131" onclick="btn_grdadd_onclick" anchor="top right"/>
        <Button id="btn_grddel" taborder="5" text="행삭제" class="btn2" position="absolute 1141 112 1194 131" anchor="top right" onclick="btn_grddel_onclick"/>
        <Grid id="grd_propllist" taborder="6" binddataset="ds_main_grid_propllist" autoenter="select" useinputpanel="false" cellsizingtype="both" position="absolute 0 136 1195 780" anchor="all" extendsizetype="row" autofittype="col" autosizingtype="row" onexpanddown="grd_propllist_onexpanddown">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="23"/>
                <Column size="60"/>
                <Column size="109"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="90"/>
                <Column size="289"/>
                <Column size="300"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="년도"/>
                <Cell col="2" text="기준일자(MMDD)"/>
                <Cell col="3" colspan="2" text="부서확인기간(FROM~TO)" taborder="undefined"/>
                <Cell col="5" colspan="2" text="기준금액(MIN~MAX)" taborder="undefined"/>
                <Cell col="7" text="계정과목"/>
                <Cell col="8" text="비고"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="text" edittype="text" style="align:center middle;" text="bind:yyyy"/>
                <Cell col="2" displaytype="text" edittype="text" style="align:center middle;" text="bind:basedd" mask="##-##" maskchar=" "/>
                <Cell col="3" displaytype="date" edittype="date" style="align:center middle;" text="bind:dfromdd" calendardisplaynulltype="nulltext"/>
                <Cell col="4" displaytype="date" edittype="date" style="align:center middle;" text="bind:dtodd" calendardisplaynulltype="nulltext"/>
                <Cell col="5" displaytype="number" edittype="text" style="align:center middle;" text="bind:passnmin"/>
                <Cell col="6" displaytype="number" edittype="text" style="align:center middle;" text="bind:passnmax"/>
                <Cell col="7" displaytype="text" edittype="text" text="bind:acntnm" expandshow="show" autosizerow="limitmin" enable="true"/>
                <Cell col="8" displaytype="text" edittype="text" text="bind:cmt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="button1" taborder="7" text="엑셀저장" class="btn7" position="absolute 1006 112 1086 131" onclick="button1_onclick" anchor="top right"/>
        <Static id="caption1" text="* 계정과목을 먼저 저장 후에 기준정보를 저장하시기 바랍니다.*" position="absolute 130 109 525 129" style="background:#ffff99ff;font:Dotum,9,bold;"/>
      </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="yyyy" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_grid_propllist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="yyyy" type="STRING" size="256" sumtext="년도"/>
          <Column id="basedd" type="STRING" size="256" sumtext="기준일자"/>
          <Column id="dfromdd" type="STRING" size="256" sumtext="부서확인(fromdd)"/>
          <Column id="dtodd" type="STRING" size="256" sumtext="부서확인(todd)"/>
          <Column id="useyn" type="STRING" size="256" sumtext="사용여부"/>
          <Column id="passnmin" type="STRING" size="256" sumtext="기준금액(Min)"/>
          <Column id="passnmax" type="STRING" size="256" sumtext="기준금액(Max)"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정과목"/>
          <Column id="cmt" type="STRING" size="256" sumtext="비고"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_useyn" 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">Y</Col>
            <Col id="value">Y</Col>
          </Row>
          <Row>
            <Col id="label">N</Col>
            <Col id="value">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_popacnt" 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="yyyy" type="STRING" size="256"/>
          <Column id="selectyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="yyyy"/>
            <Col id="selectyn"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_popacntlist_acntlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.cmb_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
      <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";
function SMRFC00401_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

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

function fInitialize() 
{
	misfGridInit(grd_propllist);
	
	misfComboComCdList("C0048",grp_sea.cmb_instcd,"Y");
	misfMsterDetailSet(grd_propllist, null, "TRRFC00410","Y");
	
	grp_sea.cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");
	ds_send.setColumn(0, "yyyy", String(utlf_getCurrentDate()).substr(0,4));
	
	var dutplcecd = sysf_getUserInfo("dutplcecd");	
	if(dutplcecd == "4020334000" || sysf_getUserInfo("userid") == "MIS" || sysf_getUserInfo("userid") == "99207"    )
	{
		grp_sea.btn_search.click();
	}
	else
	{
		sysf_messageBox("물류팀외 조회할 수","I004");
		grp_sea.btn_search.enable = false;
		btn_save.enable = false;
		btn_clear.enable = false;
		grp_sea.ipt_yyyy.enable = false;
	}					
}

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

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fsearch();	
}

function fsearch()
{	
	arrCompId = new Array("grp_sea.cmb_instcd");
	if(!frmf_isRequiredControls(arrCompId)) return;
 
	misfMsterDetailRetrieve();
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_propllist, "excel", "Sheet1", "true", "", "");
}

function btn_grdadd_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridIUD(grd_propllist, "A");
	var acntnm = ds_main_grid_propllist.getColumn(ds_main_grid_propllist.rowposition, "acntnm");
	ds_main_grid_propllist.setColumn(ds_main_grid_propllist.rowposition, "yyyy", String(utlf_getCurrentDate()).substr(0,4));
	ds_main_grid_propllist.setColumn(ds_main_grid_propllist.rowposition, "useyn", "Y");
	
	ds_popacnt.copyRow(0, ds_main_grid_propllist, ds_main_grid_propllist.rowposition);
	
	if(utlf_isNull(acntnm))
	{
		var objArg = new Object();
			objArg.arg_ds_popdata = ds_popacnt;
			
		frmf_modal("SPRFC04000", "SPRFC04000", objArg, "", "", "", "", "", "", "", "", "", "M");
	 }
}

function btn_grddel_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridIUD(grd_propllist, "D");
}

function grd_propllist_onexpanddown(obj:Grid, e:GridMouseEventInfo)
{
	if(e.cell == grd_propllist.getBindCellIndex("Body","acntnm"))	
	{
		ds_popacnt.setColumn(0, "instcd", grp_sea.cmb_instcd.value);
		ds_popacnt.setColumn(0, "yyyy", ds_main_grid_propllist.getColumn(ds_main_grid_propllist.rowposition, "yyyy"));
		ds_popacnt.setColumn(0, "selectyn", "");
		
		var objArg = new Object();
			objArg.arg_ds_popdata = ds_popacnt;
			
		frmf_modal("SPRFC04000", "SPRFC04000", objArg, "", "", "", "", "", "", "", "", "", "M");
		
		grp_sea.btn_search.click();
		
		grd_propllist.setCellPos(8);
	}
}

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

	//if(!checkKeyColumn("grd_propllist")) return;

	rtn = sysf_messageBox("", "Q002");
	if(rtn != "6" ) return false;

	var oParam = {};
		oParam.id          = "TXRFC00403";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "setProplist";
		oParam.inds        = "req=ds_main_grid_propllist:u";
		oParam.outds       = "";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRFC00403";

	tranf_submit(oParam);
	
	grp_sea.btn_search.click();
}

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

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