YNU_JEUS/app_home/himed/xpapps/com/securityxp/xp/SMZSE00200_계정비밀번호관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMZSE00200" classname="SMZSE00200_계정비밀번호관리" inheritanceid="" position="absolute 0 0 883 638" titletext="계정비밀번호관리" oninit="SMZSE00200_oninit" onload="SMZSE00200_onload">
    <Layouts>
      <Layout>
        <Static id="Static00" text="계정비밀번호관리" position="absolute 0 0 134 25" class="tit_1"/>
        <Div id="div_search" taborder="1" position="absolute 0 24 883 165" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Grid id="grd_search_oper" taborder="0" useinputpanel="false" position="absolute 9 10 119 132" binddataset="ds_maindb" anchor="default">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="30"/>
                      <Column size="80"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell displaytype="checkbox" edittype="checkbox" taborder="undefined"/>
                      <Cell col="1" displaytype="normal" text="운영" taborder="undefined"/>
                    </Band>
                    <Band id="body">
                      <Cell displaytype="checkbox" edittype="checkbox" text="bind:value" expr="expr:(value == &quot;true&quot; || value == 1) ? 1 : 0"/>
                      <Cell col="1" displaytype="normal" text="bind:name"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Static id="stt_newpwd" position="absolute 452 8 872 36" style="color:#ff0000ff;align:right middle;font:Dotum,12,bold underline;" anchor="top right"/>
              <Static id="Static00" text="사번 :" position="absolute 623 57 671 77" class="search_name" anchor="top right"/>
              <Edit id="edt_emplno" taborder="1" position="absolute 678 57 778 77" onkeydown="div_search_edt_emplno_onkeydown" anchor="top right" autoselect="true"/>
              <Button id="btn_search" taborder="2" text="조회" position="absolute 786 57 842 77" class="btn1" onclick="div_search_btn_search_onclick" anchor="top right"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_lock_clear" taborder="2" text="비번잠금해제" position="absolute 683 2 787 22" class="btn4" onclick="btn_lock_clear_onclick" anchor="top right"/>
        <Button id="btn_pwd_init" taborder="3" text="비번초기화" class="btn4" position="absolute 792 2 883 22" onclick="btn_pwd_init_onclick" anchor="top right"/>
        <Grid id="grd_accountlist" taborder="4" useinputpanel="false" position="absolute 0 171 883 437" binddataset="ds_accountlist" anchor="all" autofittype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="90"/>
                <Column size="60"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="70"/>
                <Column size="70"/>
                <Column size="130"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" displaytype="normal" taborder="undefined"/>
                <Cell col="1" displaytype="normal" text="dbinstcd"/>
                <Cell col="2" displaytype="normal" text="dbid"/>
                <Cell col="3" rowspan="2" displaytype="normal" text="시스템" taborder="undefined"/>
                <Cell col="4" rowspan="2" displaytype="normal" text="사번" taborder="undefined"/>
                <Cell col="5" rowspan="2" displaytype="normal" text="사용자명" taborder="undefined"/>
                <Cell col="6" rowspan="2" displaytype="normal" text="전화번호" taborder="undefined"/>
                <Cell col="7" rowspan="2" displaytype="normal" text="휴대폰번호" taborder="undefined"/>
                <Cell col="8" rowspan="2" displaytype="normal" text="직종" taborder="undefined"/>
                <Cell col="9" rowspan="2" displaytype="normal" text="직위" taborder="undefined"/>
                <Cell col="10" colspan="2" displaytype="normal" text="비밀번호실패" taborder="undefined"/>
                <Cell col="12" rowspan="2" taborder="undefined">
                  <Cell displaytype="normal" text="비밀번호변경"/>
                  <Cell row="1" text="최종수정일시"/>
                </Cell>
                <Cell row="1" col="1"/>
                <Cell row="1" col="2"/>
                <Cell row="1" col="10" text="잠김여부"/>
                <Cell row="1" col="11" text="실패횟수"/>
              </Band>
              <Band id="body">
                <Cell displaytype="checkbox" edittype="checkbox" text="bind:flag"/>
                <Cell col="1" displaytype="normal" text="bind:dbinstcd"/>
                <Cell col="2" displaytype="normal" text="bind:dbid"/>
                <Cell col="3" displaytype="normal" text="bind:dbname"/>
                <Cell col="4" displaytype="normal" text="bind:userid"/>
                <Cell col="5" displaytype="normal" text="bind:usernm"/>
                <Cell col="6" displaytype="normal" text="bind:pdano"/>
                <Cell col="7" displaytype="normal" text="bind:mpphonno"/>
                <Cell col="8" displaytype="normal" text="bind:jobkindnm"/>
                <Cell col="9" displaytype="normal" text="bind:jobposnm"/>
                <Cell col="10" displaytype="combo" style="align:center middle;" text="bind:lockyn" combodataset="ds_lock" combocodecol="value" combodatacol="label"/>
                <Cell col="11" displaytype="normal" text="bind:incorrectpwdcnt"/>
                <Cell col="12" displaytype="date" text="bind:lastpwdchgdt" mask="yyyy-MM-dd HH:mm:ss"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="Static01" text="* &lt; 비밀번호 초기화 설명 &gt;&#13;&#10;&#13;&#10;   1) 숫자 5자리로 구성된 사번&#13;&#10;       - &quot;@@knuh+사번(앞에서 4자리만)&quot; 으로 초기화&#13;&#10;       예) 사번이 '01234' -&gt; '@@knuh0123'&#13;&#10;&#13;&#10;   2) 그 이외의 사번&#13;&#10;       - &quot;사번&quot;으로만 초기화 (대문자는 모두 소문자로 저장되고 초기화 후 재로그인 시에 비밀번호 변경 하라는 팝업이 뜨게 됨).&#13;&#10;       예1) 사번이 'COM'     -&gt; 'com'&#13;&#10;       예2) 사번이 'AB01'     -&gt; 'ab01'&#13;&#10;       예3) 사번이 'ABC001' -&gt; 'abc001'" position="absolute 0 442 883 638" style="background:@gradation;border:2 solid lightslategray ;color:black;padding:10 10 10 10;bordertype:round 5 5 ;font:Dotum,11;gradation:linear 50,0 lavender 50,3 lightskyblue;" anchor="left bottom"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="userid" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_operdb" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_operdb" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="name" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="id" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="name">본원운영</Col>
            <Col id="instcd">031</Col>
            <Col id="id">his031</Col>
            <Col id="value">true</Col>
          </Row>
          <Row>
            <Col id="name">칠곡운영</Col>
            <Col id="instcd">032</Col>
            <Col id="id">his032</Col>
            <Col id="value">true</Col>
          </Row>
          <Row>
            <Col id="name">MIS운영</Col>
            <Col id="instcd">030</Col>
            <Col id="id">mis030</Col>
            <Col id="value">true</Col>
          </Row>
          <Row>
            <Col id="name">CRM운영</Col>
            <Col id="instcd">030</Col>
            <Col id="id">crm030</Col>
            <Col id="value">true</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_accountlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="flag" type="STRING" size="256" sumtext="flag"/>
          <Column id="dbinstcd" type="STRING" size="256"/>
          <Column id="dbid" type="STRING" size="256"/>
          <Column id="dbname" type="STRING" size="256"/>
          <Column id="userid" type="STRING" size="256" sumtext="사용자ID"/>
          <Column id="usernm" type="STRING" size="256" sumtext="사용자명"/>
          <Column id="pdano" type="STRING" size="256" sumtext="사용자명"/>
          <Column id="mpphonno" type="STRING" size="256" sumtext="사용자명"/>
          <Column id="incorrectpwdcnt" type="STRING" size="256" sumtext="실패회수"/>
          <Column id="lockyn" type="STRING" size="256" sumtext="잠금여부"/>
          <Column id="incorrectpwdlastip" type="STRING" size="256" sumtext="최종실패IP"/>
          <Column id="incorrectpwdlastdt" type="STRING" size="256" sumtext="최종실패일시"/>
          <Column id="lockdt" type="STRING" size="256" sumtext="잠금일시"/>
          <Column id="lastpwdchgdt" type="STRING" size="256" sumtext="최종변경일시"/>
          <Column id="jobkindcd" type="STRING" size="256" sumtext="직종코드"/>
          <Column id="jobposcd" type="STRING" size="256" sumtext="직위코드"/>
          <Column id="jobkindnm" type="STRING" size="256" sumtext="직종코드"/>
          <Column id="jobposnm" type="STRING" size="256" sumtext="직위코드"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_releaselock" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_result" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="newpwd" type="STRING" size="256" sumtext="변경된비밀번호"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_initializepwd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_edudb" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="name" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="id" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="name">본원교육</Col>
            <Col id="instcd">031</Col>
            <Col id="id">his031</Col>
            <Col id="value">true</Col>
          </Row>
          <Row>
            <Col id="name">칠곡교육</Col>
            <Col id="instcd">032</Col>
            <Col id="id">his032</Col>
            <Col id="value">true</Col>
          </Row>
          <Row>
            <Col id="name">MIS교육</Col>
            <Col id="instcd">030</Col>
            <Col id="id">mis030</Col>
            <Col id="value">true</Col>
          </Row>
          <Row>
            <Col id="name">CRM교육</Col>
            <Col id="instcd">030</Col>
            <Col id="id">crm030</Col>
            <Col id="value">true</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_maindb" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_maindb_oncolumnchanged"/>
      <Dataset id="ds_init_operdb_dent" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="name" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="id" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="name">치과운영</Col>
            <Col id="instcd">031</Col>
            <Col id="id">his031</Col>
            <Col id="value">true</Col>
          </Row>
          <Row>
            <Col id="name">MIS치과운영</Col>
            <Col id="instcd">030</Col>
            <Col id="id">mis030</Col>
            <Col id="value">true</Col>
          </Row>
          <Row>
            <Col id="name">치과CRM운영</Col>
            <Col id="instcd">030</Col>
            <Col id="id">crm030</Col>
            <Col id="value">true</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_edudb_dent" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="name" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="id" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="name">치과교육</Col>
            <Col id="instcd">031</Col>
            <Col id="id">his031</Col>
            <Col id="value">true</Col>
          </Row>
          <Row>
            <Col id="name">MIS치과교육</Col>
            <Col id="instcd">030</Col>
            <Col id="id">mis030</Col>
            <Col id="value">true</Col>
          </Row>
          <Row>
            <Col id="name">CRM치과교육</Col>
            <Col id="instcd">030</Col>
            <Col id="id">crm030</Col>
            <Col id="value">true</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_lock" 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">Y</Col>
          </Row>
          <Row>
            <Col id="value">N</Col>
            <Col id="label"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="div_search.edt_emplno" propid="value" datasetid="ds_search" columnid="userid"/>
      <BindItem id="item1" compid="div_search.stt_newpwd" propid="text" datasetid="ds_main_result" columnid="newpwd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[include "com_commonxp::comm_main.xjs";

function SMZSE00200_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
	
	grdf_initGrid(div_search.grd_search_oper);
	grdf_initGrid(grd_accountlist);
	
	div_search.grd_search_oper.setCellProperty("head", 0, "text", true);
}

function SMZSE00200_onload(obj:Form, e:LoadEventInfo)
{
	fInitialize();
}

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

function div_search_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_result.setColumn(0, "newpwd", "");
	
	fSearch();
}

function btn_lock_clear_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_result.setColumn(0, "newpwd", "");
	
	if(!fCheckSelectedItem())
		return;
		
	ds_accountlist.enableevent = false;
	ds_accountlist.filter("flag == true");	
	ds_send_releaselock.copyData(ds_accountlist, true);
	ds_accountlist.filter("");
	ds_accountlist.enableevent = true;
		
	var oParam = {};
		oParam.id          = "TXZSE00201";
		oParam.service     = "securityapp.AccountMngt";
		oParam.method      = "reqSetReleaseAccountLock";
		oParam.inds        = "req=ds_send_releaselock";
		oParam.alert       = true;
		oParam.async       = false;

	tranf_submit(oParam);
	
	fSearch();
}

function btn_pwd_init_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_result.setColumn(0, "newpwd", "");
	
	if(!fCheckSelectedItem())
		return;

	ds_accountlist.enableevent = false;
	ds_accountlist.filter("flag == true");	
	ds_send_initializepwd.copyData(ds_accountlist, true);
	ds_accountlist.filter("");
	ds_accountlist.enableevent = true;
	
	var oParam = {};
		oParam.id          = "TXZSE00202";
		oParam.service     = "securityapp.AccountMngt";
		oParam.method      = "reqExeInitializePwd";
		oParam.inds        = "req=ds_send_initializepwd";
		oParam.outds       = "ds_main_result=result";
		oParam.alert       = true;
		oParam.async       = false;

	tranf_submit(oParam);
	
	fSearch();
}

function ds_maindb_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "value")
		obj.setColumn(e.row, e.columnid, (e.newvalue == "true" || e.newvalue == 1) ? "true" : "false");
}

function fInitialize() {
	var systeminstnm = sysf_getUserInfo("systeminstnm");
	if(systeminstnm.indexOf("운영") >= 0) {
		if(systeminstnm.indexOf("치과") >= 0) {
			ds_maindb.copyData(ds_init_operdb_dent);
		} else {
			ds_maindb.copyData(ds_init_operdb);
		}
		
		div_search.grd_search_oper.setCellProperty("head", 1, "text", "운영");
	} else {
		if(systeminstnm.indexOf("치과") >= 0) {
			ds_maindb.copyData(ds_init_edudb_dent);
		} else {
			ds_maindb.copyData(ds_init_edudb);
		}
		
		div_search.grd_search_oper.setCellProperty("head", 1, "text", "교육");
	}
	
	div_search.edt_emplno.setFocus();
}

function fSearch() {
	ds_send_operdb.copyData(ds_maindb);
				
	var oParam = {};
		oParam.id          = "TRZSE00201";
		oParam.service     = "securityapp.AccountMngt";
		oParam.method      = "reqGetAccountList";
		oParam.inds        = "req_operdb=ds_send_operdb req=ds_search";
		oParam.outds       = "ds_accountlist=accountlist";
		oParam.async       = true;
		oParam.callback    = "cf_TRZSE00201";

	tranf_submit(oParam);
}

function cf_TRZSE00201(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
    
    ds_accountlist.rowposition = -1;
}

function fCheckSelectedItem() {
	if(ds_accountlist.getCaseCount("flag == true") > 0) {
		return true;
	} else {
		sysf_messageBox("선택된 아이템이 없습니다.\n변경 할 아이템을 체크 하시고 버튼을 눌러주세요.", "I999");
		return false;
	}				
}]]></Script>
  </Form>
</FDL>