YNU_JEUS/app_home/himed/xpapps/com/userdeptinfoxp/xp/SPZSU00800_전화번호.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPZSU00800" classname="SPZSU00800_전화번호" inheritanceid="" position="absolute 0 0 600 440" titletext="전화번호 검색" class="frm_POP" oninit="SPZSU00800_oninit" onload="SPZSU00800_onload">
    <Layouts>
      <Layout>
        <Static id="stt_titleText" text="전화번호 검색" onclick="caption00_onclick" class="sta_POP_title" position="absolute 12 8 159 31"/>
        <Button id="btn_close" taborder="1" onclick="btn_close_onclick" class="btn_POP_cls" position="absolute 574 12 588 25" anchor="top right"/>
        <Div id="div_search" anchor="left top right" taborder="2" style="align:center top;" class="div_SA" position="absolute 12 46 588 109">
          <Layouts>
            <Layout>
              <Button id="btn_search" taborder="1" text="조회" onclick="div_search_btn_search_onclick" class="btn1" position="absolute 445 22 501 42" anchor="top right"/>
              <Static id="caption2" text="검색조건" class="search_name" position="absolute 8 10 82 30" anchor="default"/>
              <Radio id="rdo_condflag2" taborder="2" codecolumn="codecolumn" datacolumn="datacolumn" onitemchanged="div_search_rd_searchCondition_onitemchanged" position="absolute 229 10 399 30" anchor="default" index="-1" columncount="2">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">사용자ID</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">사용자명</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Static id="caption00" text="검색어" class="search_name" position="absolute 8 34 82 54" anchor="default"/>
              <Edit id="ed_ipt_data" taborder="0" imemode="hangul" onkeydown="div_search_ed_searchValue_onkeydown" position="absolute 75 34 213 54" anchor="default"/>
              <Static id="caption01" text="기관" class="search_name" position="absolute 232 34 306 54" anchor="default" visible="false"/>
              <Combo id="cmb_instcd" taborder="3" position="absolute 275 33 377 54" index="0" anchor="default" codecolumn="codecolumn" datacolumn="datacolumn" visible="false" onitemchanged="div_search_cmb_instcd_onitemchanged" value="031" text="본원" onkeydown="div_search_cmb_instcd_onkeydown">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">031</Col>
                      <Col id="datacolumn">본원</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">032</Col>
                      <Col id="datacolumn">칠곡</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">033</Col>
                      <Col id="datacolumn">치과</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Button id="btn_save" taborder="4" text="저장" class="btn3" position="absolute 509 22 565 42" anchor="top right" visible="false" onclick="div_search_btn_save_onclick"/>
              <Combo id="cmb_flag" taborder="5" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 75 9 177 30" onitemchanged="div_search_cmb_flag_onitemchanged" index="-1">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">D</Col>
                      <Col id="datacolumn">부서</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">U</Col>
                      <Col id="datacolumn">사용자</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Radio id="rdo_condflag" taborder="6" columncount="2" rowcount="0" index="0" codecolumn="codecolumn" datacolumn="datacolumn" value="2" onitemchanged="div_search_rd_searchCondition_onitemchanged" position="absolute 229 10 440 30" visible="false" onitemclick="div_search_rdo_condflag_onitemclick">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">부서/전화위치</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">3</Col>
                      <Col id="datacolumn">전화번호</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
            </Layout>
          </Layouts>
        </Div>
        <Grid id="gd_TelNumList" taborder="3" binddataset="ds_userList" useinputpanel="false" cellsizingtype="col" cellsizebandtype="allband" onkeydown="gd_codeList_onkeydown" oncelldblclick="gd_codeList_oncelldblclick" position="absolute 12 137 588 427" anchor="all" selecttype="row" autofittype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24"/>
                <Column size="52"/>
                <Column size="188"/>
                <Column size="61"/>
                <Column size="70"/>
                <Column size="90"/>
                <Column size="90"/>
              </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="사용자ID"/>
                <Cell col="4" text="사용자명"/>
                <Cell col="5" text="휴대폰번호"/>
                <Cell col="6" text="nzone"/>
              </Band>
              <Band id="body">
                <Cell/>
                <Cell col="1" displaytype="combo" edittype="none" style="align:center middle;" text="bind:instcd" combodataset="ds_instcd" combocodecol="value" combodatacol="label"/>
                <Cell col="2" displaytype="text" style="padding:0 2 0 10;" text="bind:deptnm"/>
                <Cell col="3" text="bind:userid" mask="@@@{@}{@}" maskchar="_"/>
                <Cell col="4" text="bind:usernm"/>
                <Cell col="5" text="bind:mpphon"/>
                <Cell col="6" text="bind:nzone"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption3" text="전화번호조회" position="absolute 12 119 126 135" class="tit_2"/>
        <Button id="btn_row_add" taborder="4" text="행추가" class="btn2" position="absolute 475 116 530 136" onclick="btn_row_add_onclick" visible="false"/>
        <Button id="btn_row_del" taborder="5" text="행삭제" class="btn2" position="absolute 533 116 588 136" onclick="btn_row_del_onclick" visible="false"/>
        <Grid id="gd_TelNumList2" taborder="6" binddataset="ds_userList2" useinputpanel="false" cellsizingtype="col" cellsizebandtype="allband" oncelldblclick="gd_codeList_oncelldblclick" position="absolute 12 137 588 427" anchor="all" visible="false" onenterdown="gd_TelNumList2_onenterdown" autofittype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24"/>
                <Column size="94"/>
                <Column size="188"/>
                <Column size="168"/>
                <Column size="101"/>
              </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="전화번호"/>
              </Band>
              <Band id="body">
                <Cell/>
                <Cell col="1" displaytype="combo" edittype="none" style="align:center middle;" text="bind:instcd" combodataset="ds_instcd" combocodecol="value" combodatacol="label"/>
                <Cell col="2" displaytype="text" edittype="text" style="padding:0 2 0 10;" text="bind:centnm" editlimit="-1" edittrimtype="both" editacceptsenter="false"/>
                <Cell col="3" displaytype="text" edittype="text" style="padding:0 2 0 10;" text="bind:deptnm"/>
                <Cell col="4" edittype="normal" text="bind:telno"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_userList" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="seq" type="STRING" size="256" sumtext="순번"/>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="instnm" type="STRING" size="256" sumtext="기관명"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="userid" type="STRING" size="256" sumtext="사용자ID"/>
          <Column id="jobkindnm" type="STRING" size="256" sumtext="사용자ID"/>
          <Column id="usernm" type="STRING" size="256" sumtext="사용자명"/>
          <Column id="mpphon" type="STRING" size="256" sumtext="전화번호"/>
          <Column id="nzone" type="STRING" size="256" sumtext="NZONE"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_userList2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="seq" type="STRING" size="256" sumtext="순번"/>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="instnm" type="STRING" size="256" sumtext="기관명"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="centnm" type="STRING" size="256" sumtext="사용자ID"/>
          <Column id="telno" type="STRING" size="256"/>
          <Column id="fstrgstrid" type="STRING" size="256"/>
          <Column id="lastupdtrid" type="STRING" size="256"/>
          <Column id="lastupdtdt" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="condflag" type="STRING" size="256"/>
          <Column id="data" type="STRING" size="256"/>
          <Column id="flag" type="STRING" size="256"/>
          <Column id="condflag2" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="flag">U</Col>
            <Col id="condflag">2</Col>
            <Col id="condflag2">2</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_instcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="value" type="STRING" size="256"/>
          <Column id="label" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="value">031</Col>
            <Col id="label">본원</Col>
          </Row>
          <Row>
            <Col id="value">032</Col>
            <Col id="label">칠곡</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_savedata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="div_search.ed_ipt_data" propid="value" datasetid="ds_main_cond" columnid="data"/>
      <BindItem id="item1" compid="div_search.cmb_flag" propid="value" datasetid="ds_main_cond" columnid="flag"/>
      <BindItem id="item2" compid="div_search.rdo_condflag2" propid="value" datasetid="ds_main_cond" columnid="condflag2"/>
      <BindItem id="item3" compid="div_search.rdo_condflag" propid="value" datasetid="ds_main_cond" columnid="condflag"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[include "com_commonxp::comm_main.xjs";

function SPZSU00800_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
	
	
}

function SPZSU00800_onload(obj:Form, e:LoadEventInfo)
{
	grdf_setRowTypeIcon(gd_TelNumList,  0);
	grdf_setRowTypeIcon(gd_TelNumList2, 0);
	
	stt_titleText.text = "전화번호 검색";
	
	var dutplceinstcd = sysf_getUserInfo("dutplceinstcd");
	div_search.cmb_instcd.value = dutplceinstcd;
	
	div_search.ed_ipt_data.setFocus();
}

function div_search_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fReqConcTypeCD();
}

function div_search_btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	fSaveConcTypeCD();
	fReqConcTypeCD();
}

function btn_row_add_onclick(obj:Button,  e:ClickEventInfo)
{
	fAddConcTypeCd();
}

function btn_row_del_onclick(obj:Button,  e:ClickEventInfo)
{
	fDelConcTypeCD();
}

function div_search_cmb_flag_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	var flag = obj.value;
	
	if(flag == "D"){
		div_search.rdo_condflag.visible=true;
		div_search.rdo_condflag2.visible=false;
		gd_TelNumList.visible=false;
		gd_TelNumList2.visible=true;		
		div_search.caption01.visible=true;
		div_search.cmb_instcd.visible=true;
		div_search.btn_save.visible=true;
		btn_row_add.visible=true;
		btn_row_del.visible=true;
	}else if(flag == "U"){
		div_search.rdo_condflag.visible=false;
		div_search.rdo_condflag2.visible=true;
		gd_TelNumList.visible=true;
		gd_TelNumList2.visible=false;
		div_search.cmb_instcd.visible = false;
		div_search.caption01.visible=false;
		div_search.btn_save.visible = false;
		btn_row_add.visible=false;
		btn_row_del.visible = false;
	}
	
	div_search.ed_ipt_data.value="";
	
	
}

function div_search_cmb_instcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	
}

/**
 * @desc   : 전화번호 조회
 * @
 * @param  :
 * @return :
 * @authur : 
 * @---------------------------------------------------
 */
function fReqConcTypeCD(){
	var flag = div_search.cmb_flag.value;
			
	if(flag == "U"){
						
		var oParam = {};
			oParam.id          = "TRZSU00801";
			oParam.service     = "userdeptinfoapp.UserDeptInfo";
			oParam.method      = "reqGetUserPhoneNo";
			oParam.inds        = "req=ds_main_cond";
			oParam.outds       = "ds_userList=userinfo";
			oParam.async       = true;				
	}else{
		ds_main_cond.setColumn(0,"instcd",div_search.cmb_instcd.value);
	
		var oParam = {};
			oParam.id          = "TRZSU00802";
			oParam.service     = "userdeptinfoapp.UserDeptInfo";
			oParam.method      = "reqGetDeptPhoneNo";
			oParam.inds        = "req=ds_main_cond";
			oParam.outds       = "ds_userList2=telinfo";
			oParam.async       = true;
	}
	
	tranf_submit(oParam);	
}

/**
 * @desc   : 전화번호 추가
 * @
 * @param  :
 * @return :
 * @---------------------------------------------------
 */
function fAddConcTypeCd(){

	var iRow = ds_userList2.rowcount;
	
	if(iRow > 0){
		ds_userList2.insertRow(0);			
		ds_userList2.setColumn(0, "instcd", div_search.cmb_instcd.value);		
		gd_TelNumList2.setEditText(ds_userList2.getColumn(0, "instcd"));
		gd_TelNumList2.show();
	}
}

/**
 * @desc   : 전화번호 저장
 * @
 * @param  :
 * @return :
 * @---------------------------------------------------
 */
function fSaveConcTypeCD(){
  	
  	var oDsUpdate = grdf_getGridUpdateData(gd_TelNumList2);

	//sysf_trace(oDsUpdate.rowcount);
	
	if( oDsUpdate.rowcount < 1 )	{	// utlf_isNull(oDsUpdate) 
		sysf_messageBox("입력","E013");    // 그리드에 데이터가 업데이트 되지 않으면 "입력된 데이터가 없습니다."는 메시지 출력
		return ;
	}
	
	if(fValidSaveInfo()==true){
		grdf_setStatusColumn(oDsUpdate, "status");			// 각행의 status에 rowType 값에 따라 'i', 'u', 'd'로 업데이트 시켜준다
		ds_savedata.copyData(oDsUpdate, true);

		var oParam = {};
		oParam.id      = "TXZSU00801";
		oParam.service = "userdeptinfoapp.UserDeptInfo";
		oParam.method  = "reqExeSaveDeptPhoneNo";
		oParam.inds    = "req=" + "ds_savedata";
		oParam.outds   = "gd_TelNumList2=deptlistdata";
		oParam.async   = false;

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

/**
 * @desc   : 전화번호 저장 정보 유효성 확인
 * @
 * @param  :
 * @return :
 * @authur :
 * @---------------------------------------------------
 */
function fValidSaveInfo(){	
	var totrow = ds_userList2.rowcount;
	for(var i = 0; i < totrow; i++){
		var status = ds_userList2.getRowType(i);
		if(status == 2){ //신규인 경우, 관심분류명을 확인, 분류명이 없는 경우 error!
			var centnm = ds_userList2.getColumn(i, "centnm");
			var deptnm = ds_userList2.getColumn(i, "deptnm");
			var telno = ds_userList2.getColumn(i, "telno");
			if(utlf_isNull(centnm)){
				sysf_messageBox("부서명을", "C001");
				ds_userList2.rowposition = i;
				gd_TelNumList2.setCellPos(gd_TelNumList2.getBindCellIndex("body", "centnm"));
				gd_TelNumList2.showEditor(true);
				return false;
			}else if(utlf_isNull(deptnm)){
				sysf_messageBox("전화위치를", "C001");
				ds_userList2.rowposition = i;
				gd_TelNumList2.setCellPos(gd_TelNumList2.getBindCellIndex("body", "deptnm"));
				gd_TelNumList2.showEditor(true);
				return false;
			}else if(utlf_isNull(telno)){
				sysf_messageBox("전화번호를", "C001");
				ds_userList2.rowposition = i;
				gd_TelNumList2.setCellPos(gd_TelNumList2.getBindCellIndex("body", "telno"));
				gd_TelNumList2.showEditor(true);
				return false;
			}
		}
	}
	return true;
}

/**
 * @desc   : 전화번호 삭제
 * @
 * @param  :
 * @return :
 * @---------------------------------------------------
 */
function fDelConcTypeCD(){
	
	var iRow = ds_userList2.rowposition;
	
	if(iRow < 0){
		return;
	}
	
	var status = ds_userList2.getRowType(iRow);

	if(status == Dataset.ROWTYPE_INSERT){
		ds_userList2.deleteRow(iRow);
	}else{
		var arrPostion = new Array();
		arrPostion[0] = iRow;
		grdf_setStatus(gd_TelNumList2, "D", arrPostion);
	}
}

// 검색어 입력 후 enter로 조회 가능
function div_search_ed_searchValue_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13){
		obj.updateToDataset();
		fReqConcTypeCD();
	}
}

// grid에서 enter로 편집 가능
function gd_TelNumList2_onenterdown(obj:Grid, e:GridEditEventInfo)
{
	if(obj.getEditText() != undefined)
		obj.showEditor(false);
}

// 기관 변경 후 enter로 조회 가능
function div_search_cmb_instcd_onkeydown(obj:Combo, e:KeyEventInfo)
{
	if(e.keycode == 13){
		obj.updateToDataset();
		fReqConcTypeCD();
	}
}

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