123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322 |
- <?xml version="1.0" encoding="utf-8"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SPRPC90500" position="absolute 0 0 1010 545" titletext="근로소득자조회HELP" oninit="SPRPC90500_oninit" onload="SPRPC90500_onload">
- <Layouts>
- <Layout>
- <Div id="group2" taborder="0" class="div_SA" position="absolute 0 0 1000 35">
- <Layouts>
- <Layout>
- <Edit id="ipt_refcond" taborder="1" class="input_s_essential" position="absolute 252 8 387 27" autoselect="true" autoskip="true" onkeydown="group2_ipt_refcond_onkeydown"/>
- <Button id="btn_search" taborder="2" text="조회" class="btn1" position="absolute 929 7 985 29" onclick="group2_btn_search_onclick"/>
- <Shape id="line13" linetype="vertical" class="line_4" position="absolute 911 4 917 30"/>
- <Static id="caption2" text="조회조건 :" class="search_name" position="absolute 166 10 252 27"/>
- <Radio id="rdo_refcond" taborder="3" columncount="2" rowcount="0" innerdataset="@ds_init_refcond" codecolumn="value" datacolumn="label" class="radio_search" position="absolute 15 7 140 27" onitemchanged="group2_rdo_refcond_onitemchanged"/>
- <Static id="caption3" text="바탕색이 회색인 것은 퇴직자를 의미합니다." position="absolute 405 8 847 28" style="color:#0000ffff;font:Dotum,9,bold;"/>
- </Layout>
- </Layouts>
- </Div>
- <Static id="caption1" text="인사정보" class="tit_2" position="absolute 0 43 95 64"/>
- <Shape id="line1" class="line_10" position="absolute 0 59 1000 65"/>
- <Grid id="grd_empllist" class="grd_empllist" taborder="1" binddataset="ds_main_empllist" useinputpanel="false" position="absolute 0 64 1000 512" autoenter="select" cellsizingtype="col" oncelldblclick="grd_empllist_oncelldblclick">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="25"/>
- <Column size="96"/>
- <Column size="88"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="100"/>
- <Column size="80"/>
- <Column size="100"/>
- <Column size="90"/>
- <Column size="84"/>
- <Column size="79"/>
- <Column size="81"/>
- <Column size="100"/>
- <Column size="85"/>
- <Column size="79"/>
- <Column size="100"/>
- <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"/>
- </Band>
- <Band id="body">
- <Cell celltype="head" expr="currow+1"/>
- <Cell col="1" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:emplno"/>
- <Cell col="2" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:emplnm"/>
- <Cell col="3" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:rregno"/>
- <Cell col="4" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:deptcd"/>
- <Cell col="5" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:deptnm"/>
- <Cell col="6" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:dutdeptcd"/>
- <Cell col="7" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:dutdeptnm"/>
- <Cell col="8" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:teamnm"/>
- <Cell col="9" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:unitnm"/>
- <Cell col="10" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:grupjoblnnm"/>
- <Cell col="11" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:joblnnm"/>
- <Cell col="12" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:jobkindnm"/>
- <Cell col="13" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:jobposnm"/>
- <Cell col="14" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:jobrespnm"/>
- <Cell col="15" style="background:EXPR(retireyn == 'Y' ? '#999999' : '');background2:EXPR(retireyn == 'Y' ? '#999999' : '');" text="bind:dutplceinstnm"/>
- <Cell col="16" text="bind:retireyn"/>
- <Cell col="17" text="bind:payinst"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Shape id="line32" class="line_6" position="absolute 0 512 1000 518"/>
- <Button id="btn_confirm" taborder="2" text="확인" class="btn4" position="absolute 886 517 942 539" onclick="btn_confirm_onclick"/>
- <Button id="btn_cancel" taborder="3" text="취소" class="btn4" position="absolute 944 517 1000 539" onclick="btn_cancel_onclick"/>
- </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="refcond" type="STRING" size="256"/>
- <Column id="name" type="STRING" size="256"/>
- <Column id="emplno" type="STRING" size="256"/>
- <Column id="dutplcedeptcd" type="STRING" size="256"/>
- <Column id="instcd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="refcond"/>
- <Col id="name"/>
- <Col id="emplno"/>
- <Col id="dutplcedeptcd"/>
- <Col id="instcd"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_refcond" 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">emplno</Col>
- </Row>
- <Row>
- <Col id="label">성명</Col>
- <Col id="value">name</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_empllist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="emplno" type="STRING" size="256" sumtext="사원번호"/>
- <Column id="emplnm" type="STRING" size="256" sumtext="성명"/>
- <Column id="holyordflag" type="STRING" size="256" sumtext="성직구분"/>
- <Column id="prfshipflag" type="STRING" size="256" sumtext="교직구분"/>
- <Column id="rregno" type="STRING" size="256" sumtext="주민번호"/>
- <Column id="instcd" type="STRING" size="256" sumtext="기관"/>
- <Column id="deptcd" type="STRING" size="256" sumtext="부서"/>
- <Column id="deptnm" type="STRING" size="256" sumtext="부서명"/>
- <Column id="grupjoblncd" type="STRING" size="256" sumtext="직군"/>
- <Column id="grupjoblnnm" type="STRING" size="256" sumtext="직군명"/>
- <Column id="joblncd" type="STRING" size="256" sumtext="직렬"/>
- <Column id="joblnnm" type="STRING" size="256" sumtext="직렬명"/>
- <Column id="jobkindcd" type="STRING" size="256" sumtext="직종"/>
- <Column id="jobkindnm" type="STRING" size="256" sumtext="직종명"/>
- <Column id="jobposcd" type="STRING" size="256" sumtext="직위"/>
- <Column id="jobposnm" type="STRING" size="256" sumtext="직위명"/>
- <Column id="jobrespcd" type="STRING" size="256" sumtext="직책"/>
- <Column id="jobrespnm" type="STRING" size="256" sumtext="직책명"/>
- <Column id="ojobgradcd" type="STRING" size="256" sumtext="구직급"/>
- <Column id="ojobgradnm" type="STRING" size="256" sumtext="구직급명"/>
- <Column id="njobgradcd" type="STRING" size="256" sumtext="신직급"/>
- <Column id="njobgradnm" type="STRING" size="256" sumtext="신직급명"/>
- <Column id="payclscd" type="STRING" size="256" sumtext="호봉"/>
- <Column id="anual" type="STRING" size="256" sumtext="년차"/>
- <Column id="rregno" type="STRING" size="256" sumtext="주민번호"/>
- <Column id="teamcd " type="STRING" size="256" sumtext="팀코드"/>
- <Column id="teamnm" type="STRING" size="256" sumtext="팀명"/>
- <Column id="unitcd" type="STRING" size="256" sumtext="유닛코드"/>
- <Column id="unitnm" type="STRING" size="256" sumtext="유닛명"/>
- <Column id="instnm" type="STRING" size="256" sumtext="기관명"/>
- <Column id="teamunitnm " type="STRING" size="256" sumtext="팀유닛명"/>
- <Column id="entcodd" type="STRING" size="256" sumtext="입사일자"/>
- <Column id="retiredd" type="STRING" size="256" sumtext="퇴사일자"/>
- <Column id="dutplcedeptcd" type="STRING" size="256" sumtext="근무지"/>
- <Column id="dutplcedeptnm" type="STRING" size="256" sumtext="근무지??"/>
- <Column id="payinst" type="STRING" size="256" sumtext=""/>
- <Column id="dutplceinst" type="STRING" size="256" sumtext=""/>
- <Column id="dutplceinstnm" type="STRING" size="256" sumtext=""/>
- <Column id="dutdeptcd" type="STRING" size="256" sumtext="근무부서"/>
- <Column id="dutdeptnm" type="STRING" size="256" sumtext="근무부서명"/>
- <Column id="dutteamcd" type="STRING" size="256" sumtext="근무팀"/>
- <Column id="dutteamnm" type="STRING" size="256" sumtext="근무팀명"/>
- <Column id="dutunitcd" type="STRING" size="256" sumtext="근무유닛"/>
- <Column id="dutunitnm" type="STRING" size="256" sumtext="근무유닛명"/>
- <Column id="orginstcd" type="STRING" size="256" sumtext=""/>
- <Column id="orgdeptcd" type="STRING" size="256" sumtext=""/>
- <Column id="orgdetlinst" type="STRING" size="256" sumtext=""/>
- <Column id="orgteamcd" type="STRING" size="256" sumtext=""/>
- <Column id="orgunitcd" type="STRING" size="256" sumtext=""/>
- <Column id="retireyn" type="STRING" size="256" sumtext="퇴사여부"/>
- </ColumnInfo>
- </Dataset>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="group2.rdo_refcond" propid="value" datasetid="ds_send" columnid="refcond"/>
- <BindItem id="item1" compid="group2.ipt_refcond" propid="value" datasetid="ds_send" columnid="name"/>
- </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_acntcommonxp::RAD001.xjs";
- include "mis_miscommonxp::RAC001.xjs";
- function SPRPC90500_oninit(obj:Form, e:InitEventInfo)
- {
- frmf_initForm(obj);
- }
- function SPRPC90500_onload(obj:Form, e:LoadEventInfo)
- {
- grdf_initGrid(grd_empllist);
-
- try
- {
- if(arg_ds_target_defaultvalue.rowcount > 0)
- {
- ds_send.setColumn(0, "dutplcedeptcd", arg_ds_target_defaultvalue.getColumn(0, "dutplcedeptcd"));
- ds_send.setColumn(0, "instcd", arg_ds_target_defaultvalue.getColumn(0, "instcd"));
- }
- }
- catch (e)
- {}
-
- group2.rdo_refcond.value = "name";
- group2.ipt_refcond.setFocus();
- }
- function group2_rdo_refcond_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
- {
- if(obj.value == "name")
- {
- group2.ipt_refcond.imemode = "hangul";
- }
- else if (obj.value == "emplno")
- {
- group2.ipt_refcond.imemode = "none";
- }
- else
- {
- group2.ipt_refcond.imemode = "none";
- }
-
- group2.ipt_refcond.setFocus();
- }
- function group2_ipt_refcond_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
-
- group2.btn_search.click();
- }
- }
- function group2_btn_search_onclick(obj:Button, e:ClickEventInfo)
- {
- if(!utlf_isNull(group2.ipt_refcond.value))
- {
- if(group2.rdo_refcond.value == "name")
- {
- ds_send.setColumn(0, "name", group2.ipt_refcond.text);
- ds_send.setColumn(0, "emplno", "");
- }
- else
- {
- ds_send.setColumn(0, "emplno", group2.ipt_refcond.text);
- ds_send.setColumn(0, "name", "");
- }
-
- var oParam = {};
- oParam.id = "TRRPC90201";
- oParam.service = "miscommoncdrefapp.CommonCdRef";
- oParam.method = "reqGetOrcnlList";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_main_empllist=empllist";
- oParam.async = false;
- //oParam.callback = "cf_TRRPC90201";
- tranf_submit(oParam);
- }
- else
- {
- sysf_messageBox("조회조건을 ","C001");
- return;
- }
- }
- function grd_empllist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
- {
- btn_confirm.click();
- }
- function btn_confirm_onclick(obj:Button, e:ClickEventInfo)
- {
- if(utlf_isNull(ds_main_empllist.getColumn(ds_main_empllist.rowposition, "payinst")))
- {
- sysf_messageBox("급여기관이 없습니다. 근로소득을 지급할 수 없습니다..","I000");
- return false;
- }
-
- if(ds_main_empllist.getColumn(ds_main_empllist.rowposition, "retireyn") == "Y")
- {
- if(sysf_messageBox("퇴직자 입니다. 선택 하시겠습니까?","Q000") != "6")
- {
- return false;
- }
- }
- misfPopUpListReturn(grd_empllist);
- }
- function btn_cancel_onclick(obj:Button, e:ClickEventInfo)
- {
- misfPopUpListCancel();
- }
- ]]></Script>
- </Form>
- </FDL>
|