YNU_JEUS/app_home/himed/xpapps/mis/yyendtaxadstxp/xp/SMRWY04500_연말정산(감면적용)내역조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRWY04500" position="absolute 0 0 1203 777" titletext="연말정산(감면적용) 내역 조회" oninit="SMRWY04500_oninit" onload="SMRWY04500_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="연말정산(감면적용) 내역 조회" class="tit_1" position="absolute 0 0 243 25"/>
        <Div id="grp_search" taborder="1" class="div_SA" position="absolute 0 25 1195 65" anchor="left top right">
          <Layouts>
            <Layout>
              <Button id="btn_search" taborder="22" text="조회" class="btn1" position="absolute 447 9 503 31" anchor="default" onclick="grp_search_btn_search_onclick"/>
              <Shape id="line30" linetype="vertical" class="line_4" position="absolute 425 6 431 33" anchor="default"/>
              <Edit id="ipt_emplnm" taborder="23" class="input_default" position="absolute 212 10 412 29" anchor="default" autoselect="true" autoskip="true" onkeyup="grp_search_ipt_emplnm_onkeyup"/>
              <Static id="cap_emplno" text="사원번호" class="search_name" position="absolute 59 11 135 28" anchor="default"/>
              <Edit id="ipt_emplno" taborder="24" class="input_default" position="absolute 139 10 190 29" anchor="default" autoselect="true" autoskip="true" onkeyup="grp_search_ipt_emplno_onkeyup"/>
              <Button id="btn_emplsearch" taborder="25" class="icon_search" position="absolute 193 11 209 27" anchor="default" onclick="grp_search_btn_emplsearch_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid id="grd_cmplist" taborder="2" binddataset="ds_main_cmp_cmplist" useinputpanel="false" position="absolute 0 97 1195 231" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all" oncellclick="grd_cmplist_oncellclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="49"/>
                <Column size="70"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="30"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="31"/>
                <Column size="74"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="3" text="년도" taborder="undefined"/>
                <Cell col="1" rowspan="3" text="의료비&#10;감면액" taborder="undefined"/>
                <Cell col="2" colspan="8" text="감   면   적   용   ( 전 )" taborder="undefined"/>
                <Cell col="10" colspan="8" text="감   면   적   용   ( 후 )" taborder="undefined"/>
                <Cell col="18" rowspan="3" text="차감징수&#10;세액&#10;합계" taborder="undefined"/>
                <Cell row="1" col="2" colspan="2" text="결정세액" taborder="undefined"/>
                <Cell row="1" col="4" colspan="2" text="기납부세액" taborder="undefined"/>
                <Cell row="1" col="6" colspan="3" text="차감징수세액" taborder="undefined"/>
                <Cell row="1" col="9" rowspan="2" text="상세&#13;&#10;조회" taborder="undefined"/>
                <Cell row="1" col="10" colspan="2" text="결정세액" taborder="undefined"/>
                <Cell row="1" col="12" colspan="2" text="기납부세액" taborder="undefined"/>
                <Cell row="1" col="14" colspan="3" text="차감징수세액" taborder="undefined"/>
                <Cell row="1" col="17" rowspan="2" text="상세&#13;&#10;조회" taborder="undefined"/>
                <Cell row="2" col="2" text="소득세"/>
                <Cell row="2" col="3" text="주민세"/>
                <Cell row="2" col="4" text="소득세"/>
                <Cell row="2" col="5" text="주민세"/>
                <Cell row="2" col="6" text="소득세"/>
                <Cell row="2" col="7" text="주민세"/>
                <Cell row="2" col="8" text="계"/>
                <Cell row="2" col="10" text="소득세"/>
                <Cell row="2" col="11" text="주민세"/>
                <Cell row="2" col="12" text="소득세"/>
                <Cell row="2" col="13" text="주민세"/>
                <Cell row="2" col="14" text="소득세"/>
                <Cell row="2" col="15" text="주민세"/>
                <Cell row="2" col="16" text="계"/>
              </Band>
              <Band id="body">
                <Cell text="bind:yyyy"/>
                <Cell col="1" displaytype="number" text="bind:dcamt"/>
                <Cell col="2" displaytype="number" text="bind:jingsuhal_gabkun_b"/>
                <Cell col="3" displaytype="number" text="bind:jingsuhal_jumin_b"/>
                <Cell col="4" displaytype="number" text="bind:jingsuhan_gabkun_b"/>
                <Cell col="5" displaytype="number" text="bind:jingsuhan_jumin_b"/>
                <Cell col="6" displaytype="number" text="bind:cha_jingsu_gabkun_b"/>
                <Cell col="7" displaytype="number" text="bind:cha_jingsu_jumin_b"/>
                <Cell col="8" displaytype="number" text="bind:sum_b"/>
                <Cell col="9" displaytype="checkbox" edittype="checkbox" text="bind:detail_b" expr="expr:detail_b == 'true' ? 1 : 0"/>
                <Cell col="10" displaytype="number" text="bind:jingsuhal_gabkun_a"/>
                <Cell col="11" displaytype="number" text="bind:jingsuhal_jumin_a"/>
                <Cell col="12" displaytype="number" text="bind:jingsuhan_gabkun_a"/>
                <Cell col="13" displaytype="number" text="bind:jingsuhan_jumin_a"/>
                <Cell col="14" displaytype="number" text="bind:cha_jingsu_gabkun_a"/>
                <Cell col="15" displaytype="number" text="bind:cha_jingsu_jumin_a"/>
                <Cell col="16" displaytype="number" text="bind:sum_a"/>
                <Cell col="17" displaytype="checkbox" edittype="checkbox" text="bind:detail_a" expr="expr:detail_a == 'true' ? 1 : 0"/>
                <Cell col="18" displaytype="number" text="bind:sum_all"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line1" class="line_10" position="absolute 0 92 1195 98" anchor="left top right"/>
        <Static id="caption1" text="내역 비교 (2009~2011년 의료비 감면내역)" class="tit_2" position="absolute 0 76 279 98"/>
        <Static id="caption2" text="기 차감징수한 세액의 합계 :" class="tit_2" position="absolute 892 249 1085 270" anchor="right bottom"/>
        <MaskEdit id="opt_sum" taborder="3" readonly="true" mask="9,9999999999999" position="absolute 1085 246 1176 265" anchor="right bottom" maskchar=" "/>
        <Shape id="line3" class="line_10" position="absolute 0 265 1195 271" anchor="left right bottom"/>
        <Grid id="grd_cmplist2" taborder="4" binddataset="ds_main_cmp_cmplist2" useinputpanel="false" position="absolute 0 270 1195 450" autoenter="select" autofittype="col" cellsizingtype="col" anchor="left right bottom" oncellclick="grd_cmplist2_oncellclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="49"/>
                <Column size="70"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="30"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="67"/>
                <Column size="31"/>
                <Column size="74"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="3" text="년도" taborder="undefined"/>
                <Cell col="1" rowspan="3" text="감면액" taborder="undefined"/>
                <Cell col="2" colspan="8" text="감   면   적   용   ( 전 )" taborder="undefined"/>
                <Cell col="10" colspan="8" text="감   면   적   용   ( 후 )" taborder="undefined"/>
                <Cell col="18" rowspan="3" text="차감징수&#10;세액&#10;합계" taborder="undefined"/>
                <Cell row="1" col="2" colspan="2" text="결정세액" taborder="undefined"/>
                <Cell row="1" col="4" colspan="2" text="기납부세액" taborder="undefined"/>
                <Cell row="1" col="6" colspan="3" text="차감징수세액" taborder="undefined"/>
                <Cell row="1" col="9" rowspan="2" text="상세&#13;&#10;조회" taborder="undefined"/>
                <Cell row="1" col="10" colspan="2" text="결정세액" taborder="undefined"/>
                <Cell row="1" col="12" colspan="2" text="기납부세액" taborder="undefined"/>
                <Cell row="1" col="14" colspan="3" text="차감징수세액" taborder="undefined"/>
                <Cell row="1" col="17" rowspan="2" text="상세&#13;&#10;조회" taborder="undefined"/>
                <Cell row="2" col="2" text="소득세"/>
                <Cell row="2" col="3" text="주민세"/>
                <Cell row="2" col="4" text="소득세"/>
                <Cell row="2" col="5" text="주민세"/>
                <Cell row="2" col="6" text="소득세"/>
                <Cell row="2" col="7" text="주민세"/>
                <Cell row="2" col="8" text="계"/>
                <Cell row="2" col="10" text="소득세"/>
                <Cell row="2" col="11" text="주민세"/>
                <Cell row="2" col="12" text="소득세"/>
                <Cell row="2" col="13" text="주민세"/>
                <Cell row="2" col="14" text="소득세"/>
                <Cell row="2" col="15" text="주민세"/>
                <Cell row="2" col="16" text="계"/>
              </Band>
              <Band id="body">
                <Cell text="bind:yyyy"/>
                <Cell col="1" displaytype="number" text="bind:dcamt"/>
                <Cell col="2" displaytype="number" text="bind:jingsuhal_gabkun_b"/>
                <Cell col="3" displaytype="number" text="bind:jingsuhal_jumin_b"/>
                <Cell col="4" displaytype="number" text="bind:jingsuhan_gabkun_b"/>
                <Cell col="5" displaytype="number" text="bind:jingsuhan_jumin_b"/>
                <Cell col="6" displaytype="number" text="bind:cha_jingsu_gabkun_b"/>
                <Cell col="7" displaytype="number" text="bind:cha_jingsu_jumin_b"/>
                <Cell col="8" displaytype="number" text="bind:sum_b"/>
                <Cell col="9" displaytype="checkbox" edittype="checkbox" text="bind:detail_b" expr="expr:detail_b == 'true' ? 1 : 0"/>
                <Cell col="10" displaytype="number" text="bind:jingsuhal_gabkun_a"/>
                <Cell col="11" displaytype="number" text="bind:jingsuhal_jumin_a"/>
                <Cell col="12" displaytype="number" text="bind:jingsuhan_gabkun_a"/>
                <Cell col="13" displaytype="number" text="bind:jingsuhan_jumin_a"/>
                <Cell col="14" displaytype="number" text="bind:cha_jingsu_gabkun_a"/>
                <Cell col="15" displaytype="number" text="bind:cha_jingsu_jumin_a"/>
                <Cell col="16" displaytype="number" text="bind:sum_a"/>
                <Cell col="17" displaytype="checkbox" edittype="checkbox" text="bind:detail_a" expr="expr:detail_a == 'true' ? 1 : 0"/>
                <Cell col="18" displaytype="number" text="bind:sum_all"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption5" text="내역 비교 (2009~2011년 건진,장례 감면내역 + 2012~2013년 의료비,건진,장례 감면내역)" class="tit_2" position="absolute 0 249 561 270" anchor="left bottom"/>
        <Static id="caption3" text="원" position="absolute 1178 247 1195 267" anchor="right bottom"/>
        <Grid id="grd_dclist2013" taborder="5" binddataset="ds_main_cmb_dclist2013" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 960 496 1195 771" anchor="left right bottom">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="93"/>
                <Column size="47"/>
                <Column size="63"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell colspan="4" text="2013 년" taborder="undefined"/>
                <Cell row="1" text="구분"/>
                <Cell row="1" col="1" text="주민번호"/>
                <Cell row="1" col="2" text="성명"/>
                <Cell row="1" col="3" text="감면액"/>
              </Band>
              <Band id="body">
                <Cell text="bind:gubunnm"/>
                <Cell col="1" text="bind:famyrregno" mask="######-#######" maskchar=" "/>
                <Cell col="2" text="bind:fname"/>
                <Cell col="3" displaytype="number" text="bind:dcamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption7" text="추가로 차감징수할 세액의 합계 :" class="tit_2" position="absolute 865 475 1079 496" anchor="right bottom"/>
        <Grid id="grd_dclist2012" taborder="6" binddataset="ds_main_cmb_dclist2012" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 720 496 955 771" anchor="left bottom">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="93"/>
                <Column size="47"/>
                <Column size="63"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell colspan="4" text="2012 년" taborder="undefined"/>
                <Cell row="1" text="구분"/>
                <Cell row="1" col="1" text="주민번호"/>
                <Cell row="1" col="2" text="성명"/>
                <Cell row="1" col="3" text="감면액"/>
              </Band>
              <Band id="body">
                <Cell text="bind:gubunnm"/>
                <Cell col="1" displaytype="number" edittype="mask" text="bind:famyrregno" mask="######-#######" maskchar=" "/>
                <Cell col="2" text="bind:fname"/>
                <Cell col="3" displaytype="number" text="bind:dcamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid id="grd_dclist2011" taborder="7" binddataset="ds_main_cmb_dclist2011" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 480 496 715 771" anchor="left bottom">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="93"/>
                <Column size="47"/>
                <Column size="63"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell colspan="4" text="2011 년" taborder="undefined"/>
                <Cell row="1" text="구분"/>
                <Cell row="1" col="1" text="주민번호"/>
                <Cell row="1" col="2" text="성명"/>
                <Cell row="1" col="3" text="감면액"/>
              </Band>
              <Band id="body">
                <Cell text="bind:gubunnm"/>
                <Cell col="1" displaytype="number" edittype="mask" text="bind:famyrregno" mask="######-#######" maskchar=" "/>
                <Cell col="2" text="bind:fname"/>
                <Cell col="3" displaytype="number" text="bind:dcamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid id="grd_dclist2010" taborder="8" binddataset="ds_main_cmb_dclist2010" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 240 496 475 771" anchor="left bottom">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="93"/>
                <Column size="47"/>
                <Column size="63"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell colspan="4" text="2010 년" taborder="undefined"/>
                <Cell row="1" text="구분"/>
                <Cell row="1" col="1" text="주민번호"/>
                <Cell row="1" col="2" text="성명"/>
                <Cell row="1" col="3" text="감면액"/>
              </Band>
              <Band id="body">
                <Cell text="bind:gubunnm"/>
                <Cell col="1" displaytype="number" edittype="mask" text="bind:famyrregno" mask="######-#######" maskchar=" "/>
                <Cell col="2" text="bind:fname"/>
                <Cell col="3" displaytype="number" text="bind:dcamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid id="grd_dclist2009" taborder="9" binddataset="ds_main_cmb_dclist2009" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 496 235 771" anchor="left bottom">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="93"/>
                <Column size="47"/>
                <Column size="63"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell colspan="4" text="2009 년" taborder="undefined"/>
                <Cell row="1" text="구분"/>
                <Cell row="1" col="1" text="주민번호"/>
                <Cell row="1" col="2" text="성명"/>
                <Cell row="1" col="3" text="감면액"/>
              </Band>
              <Band id="body">
                <Cell text="bind:gubunnm"/>
                <Cell col="1" displaytype="number" edittype="mask" text="bind:famyrregno" mask="######-#######" maskchar=" "/>
                <Cell col="2" text="bind:fname"/>
                <Cell col="3" displaytype="number" text="bind:dcamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line2" class="line_10" position="absolute 0 491 1195 497" anchor="left right bottom"/>
        <Static id="caption4" text="감면 상세 내역" class="tit_2" position="absolute 0 475 180 496" anchor="left bottom"/>
        <MaskEdit id="opt_sum2" taborder="10" readonly="true" position="absolute 1083 472 1174 491" anchor="right bottom" mask="9,9999999999999999" maskchar=" "/>
        <Static id="caption8" text="원" position="absolute 1176 472 1195 492" anchor="right bottom"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_search_oncolumnchanged">
        <ColumnInfo>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="emplnm" type="STRING" size="256"/>
          <Column id="sum" type="STRING" size="256"/>
          <Column id="sum2" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="emplno"/>
            <Col id="emplnm"/>
            <Col id="sum"/>
            <Col id="sum2"/>
            <Col id="instcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_cmp_cmplist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_cmp_cmplist_oncolumnchanged">
        <ColumnInfo>
          <Column id="yyyy" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="jingsuhal_gabkun_b" type="STRING" size="256" sumtext="갑근세 납부할 세액_감면전"/>
          <Column id="jingsuhal_jumin_b" type="STRING" size="256" sumtext="주민세 납부할 세액_감면전"/>
          <Column id="jingsuhan_gabkun_b" type="STRING" size="256" sumtext="갑근세 기납부액_감면전"/>
          <Column id="jingsuhan_jumin_b" type="STRING" size="256" sumtext="주민세 기납부액_감면전"/>
          <Column id="cha_jingsu_gabkun_b" type="STRING" size="256" sumtext="갑근세 차감징수세액_감면전"/>
          <Column id="cha_jingsu_jumin_b" type="STRING" size="256" sumtext="주민세 차감징수세액_감면전"/>
          <Column id="sum_b" type="STRING" size="256" sumtext="감면적용전 합계"/>
          <Column id="jingsuhal_gabkun_a" type="STRING" size="256" sumtext="갑근세 납부할 세액_감면후"/>
          <Column id="jingsuhal_jumin_a" type="STRING" size="256" sumtext="주민세 납부할 세액_감면후"/>
          <Column id="jingsuhan_gabkun_a" type="STRING" size="256" sumtext="갑근세 기납부액_감면후"/>
          <Column id="jingsuhan_jumin_a" type="STRING" size="256" sumtext="주민세 기납부액_감면후"/>
          <Column id="cha_jingsu_gabkun_a" type="STRING" size="256" sumtext="갑근세 차감징수세액_감면후"/>
          <Column id="cha_jingsu_jumin_a" type="STRING" size="256" sumtext="주민세 차감징수세액_감면후"/>
          <Column id="sum_a" type="STRING" size="256" sumtext="감면적용후 합계"/>
          <Column id="sum_all" type="STRING" size="256" sumtext="년별 차감징수세액 합계"/>
          <Column id="dcamt" type="STRING" size="256" sumtext="의료비감면액 합계"/>
          <Column id="detail_a" type="STRING" size="256"/>
          <Column id="detail_b" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cmp_cmplist2" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_cmp_cmplist2_oncolumnchanged">
        <ColumnInfo>
          <Column id="yyyy" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="jingsuhal_gabkun_b" type="STRING" size="256" sumtext="갑근세 납부할 세액_감면전"/>
          <Column id="jingsuhal_jumin_b" type="STRING" size="256" sumtext="주민세 납부할 세액_감면전"/>
          <Column id="jingsuhan_gabkun_b" type="STRING" size="256" sumtext="갑근세 기납부액_감면전"/>
          <Column id="jingsuhan_jumin_b" type="STRING" size="256" sumtext="주민세 기납부액_감면전"/>
          <Column id="cha_jingsu_gabkun_b" type="STRING" size="256" sumtext="갑근세 차감징수세액_감면전"/>
          <Column id="cha_jingsu_jumin_b" type="STRING" size="256" sumtext="주민세 차감징수세액_감면전"/>
          <Column id="sum_b" type="STRING" size="256" sumtext="감면적용전 합계"/>
          <Column id="jingsuhal_gabkun_a" type="STRING" size="256" sumtext="갑근세 납부할 세액_감면후"/>
          <Column id="jingsuhal_jumin_a" type="STRING" size="256" sumtext="주민세 납부할 세액_감면후"/>
          <Column id="jingsuhan_gabkun_a" type="STRING" size="256" sumtext="갑근세 기납부액_감면후"/>
          <Column id="jingsuhan_jumin_a" type="STRING" size="256" sumtext="주민세 기납부액_감면후"/>
          <Column id="cha_jingsu_gabkun_a" type="STRING" size="256" sumtext="갑근세 차감징수세액_감면후"/>
          <Column id="cha_jingsu_jumin_a" type="STRING" size="256" sumtext="주민세 차감징수세액_감면후"/>
          <Column id="sum_a" type="STRING" size="256" sumtext="감면적용후 합계"/>
          <Column id="sum_all" type="STRING" size="256" sumtext="년별 차감징수세액 합계"/>
          <Column id="dcamt" type="STRING" size="256" sumtext="의료비감면액 합계"/>
          <Column id="detail_a" type="STRING" size="256"/>
          <Column id="detail_b" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cmb_dclist2009" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="gubunnm" type="STRING" size="256" sumtext="구분명"/>
          <Column id="famyrregno" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="fname" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="dcamt" type="STRING" size="256" sumtext="감면금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cmb_dclist2010" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="gubunnm" type="STRING" size="256" sumtext="구분명"/>
          <Column id="famyrregno" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="fname" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="dcamt" type="STRING" size="256" sumtext="감면금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cmb_dclist2011" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="gubunnm" type="STRING" size="256" sumtext="구분명"/>
          <Column id="famyrregno" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="fname" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="dcamt" type="STRING" size="256" sumtext="감면금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cmb_dclist2012" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="gubunnm" type="STRING" size="256" sumtext="구분명"/>
          <Column id="famyrregno" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="fname" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="dcamt" type="STRING" size="256" sumtext="감면금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cmb_dclist2013" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="gubunnm" type="STRING" size="256" sumtext="구분명"/>
          <Column id="famyrregno" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="fname" type="STRING" size="256" sumtext="정산년도"/>
          <Column id="dcamt" type="STRING" size="256" sumtext="감면금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_popparams" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="yyyy" type="STRING" size="256"/>
          <Column id="baflag" type="STRING" size="256"/>
          <Column id="phase" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="emplno"/>
            <Col id="yyyy"/>
            <Col id="baflag"/>
            <Col id="phase"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_search.ipt_emplno" propid="value" datasetid="ds_send_search" columnid="emplno"/>
      <BindItem id="item1" compid="grp_search.ipt_emplnm" propid="value" datasetid="ds_send_search" columnid="emplnm"/>
      <BindItem id="item2" compid="opt_sum2" propid="value" datasetid="ds_send_search" columnid=""/>
      <BindItem id="item3" compid="opt_sum" propid="value" datasetid="ds_send_search" columnid="sum"/>
    </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_humtrafactmngtxp::RPB001.xjs";
function SMRWY04500_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRWY04500_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_cmplist);
	grdf_initGrid(grd_cmplist2);
	grdf_initGrid(grd_dclist2009);
	grdf_initGrid(grd_dclist2010);
	grdf_initGrid(grd_dclist2011);
	grdf_initGrid(grd_dclist2012);
	grdf_initGrid(grd_dclist2013);
	
	grp_search.ipt_emplno.value = sysf_getUserInfo("userid"); 
	
	var logindeptcd = sysf_getUserInfo("dutplcecd"); 
	var loginid = sysf_getUserInfo("userid"); 
	var usernm = sysf_getUserInfo("usernm");
		
	misfGetUserAuth(); 
	
	if(DUTY_YYEN_YN == "Y")
	{
		grp_search.ipt_emplno.enable = true;
		grp_search.btn_emplsearch.enable = true;
		grp_search.ipt_emplnm.enable = true;
	}
	else 
	{
		grp_search.ipt_emplno.enable = false;
		grp_search.btn_emplsearch.enable = false;
		grp_search.ipt_emplnm.enable = false;
	}			

	grp_search.btn_search.click();
}

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

function ds_send_search_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "emplno")
	{
		grp_search.ipt_emplno.value = e.newvalue;
		grp_search.ipt_emplno.setFocus();
		var recv_list = "emplno,emplnm"; 
		rpbfValidationCheck("EMPLNO", recv_list);
	}

	if(e.columnid == "emplnm")
	{
		grp_search.ipt_emplnm.value = e.newvalue;
		grp_search.ipt_emplnm.setFocus();
		
		var recv_list = "emplno,emplnm"; 
		rpbfValidationCheck("EMPLNM", recv_list);
	}
}

function grp_search_btn_emplsearch_onclick(obj:Button,  e:ClickEventInfo)
{
	var recv_list = "emplno,emplnm";
	rpbfOpenPopUpList("SPRPB00101", ds_send_search, recv_list,"","N");
	
	if (!utlf_isNull(grp_search.ipt_emplno.value))
	{
		grp_search.btn_search.click();
	}
}

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

function grp_search_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if(grp_search.ipt_emplno.value.toString().length == 0) 
	{
		sysf_messageBox("사원번호가 선택되지 않았습니다. \n\n먼저 사원번호를 선택하십시요.", "E999", "");							
		grp_search.ipt_emplno.setFocus();
		return;
	}
		
	opt_sum.value = "";	
	opt_sum2.value = "";	
	
	ds_main_cmb_dclist2009.clearData();
	ds_main_cmb_dclist2010.clearData();
	ds_main_cmb_dclist2011.clearData();
	ds_main_cmb_dclist2012.clearData();
	ds_main_cmb_dclist2013.clearData();
	ds_main_cmp_cmplist.clearData();
	ds_main_cmp_cmplist2.clearData();
	
	var oParam = {};
		oParam.id          = "TRRWY04501";
		oParam.service     = "yyendtaxadstapp.YYEndTaxAdstWork";
		oParam.method      = "reqGetCmpList";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "ds_main_cmp_cmplist=cmplist ds_main_cmp_cmplist2=cmplist2 ds_main_cmb_dclist2009=dclist2009 ds_main_cmb_dclist2010=dclist2010"
							+ "ds_main_cmb_dclist2011=dclist2011 ds_main_cmb_dclist2012=dclist2012 ds_main_cmb_dclist2013=dclist2013";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRWY04501";

	tranf_submit(oParam);
	
	if (ds_main_cmp_cmplist.rowcount == 0)
	{
		opt_sum.value = 0;
	} 
	else 
	{
		var v_total = 0;
		
		for(var i = 0; i < ds_main_cmp_cmplist.rowcount; i++) 
		{			
			var v_sum_a = (utlf_isNull(ds_main_cmp_cmplist.getColumn(i, "sum_a")))? "0" : ds_main_cmp_cmplist.getColumn(i, "sum_a");
			var v_sum_b = (utlf_isNull(ds_main_cmp_cmplist.getColumn(i, "sum_b")))? "0" : ds_main_cmp_cmplist.getColumn(i, "sum_b");
			
			v_total += parseFloat(v_sum_a) - parseFloat(v_sum_b);
		}
		opt_sum.value = v_total;	
	}	

	if (ds_main_cmp_cmplist2.rowcount == 0)
	{
		opt_sum2.value = 0;
	}
	else 
	{
		var v_total = 0;
		
		for(var i = 0; i < ds_main_cmp_cmplist2.rowcount; i++)
		{
			var v_sum_a = (utlf_isNull(ds_main_cmp_cmplist2.getColumn(i, "sum_a")))? "0" : ds_main_cmp_cmplist2.getColumn(i, "sum_a");
			var v_sum_b = (utlf_isNull(ds_main_cmp_cmplist2.getColumn(i, "sum_b")))? "0" : ds_main_cmp_cmplist2.getColumn(i, "sum_b");
			
			v_total += parseFloat(v_sum_a) - parseFloat(v_sum_b);
		}
		opt_sum2.value = v_total;	
	}	
}

function grd_cmplist_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	if( ds_main_cmp_cmplist.rowcount == 0 || ds_main_cmp_cmplist.rowposition < 0)
	{
		return;
	}
	
	if( e.cell == grd_cmplist.getBindCellIndex("Body", "detail_a"))
	{
		for(var i = 0; i < ds_main_cmp_cmplist.rowcount; i++)
		{
			ds_main_cmp_cmplist.setColumn(i, "detail_b", "false");
		}
	}
	else if( e.cell == grd_cmplist.getBindCellIndex("Body", "detail_b"))
	{
		for(var i = 0; i < ds_main_cmp_cmplist.rowcount; i++)
		{
			ds_main_cmp_cmplist.setColumn(i, "detail_a", "false");
		}
	}
	
	var selectedyyyy = ds_main_cmp_cmplist.getColumn(ds_main_cmp_cmplist.rowposition, "yyyy");
	
	if( selectedyyyy == "2009" || selectedyyyy == "2010" ) 
	{	
		if( e.cell == grd_cmplist.getBindCellIndex("Body", "detail_b"))
		{
			ds_popparams.setColumn(0, "emplno", grp_search.ipt_emplno.value);
			ds_popparams.setColumn(0, "yyyy", ds_main_cmp_cmplist.getColumn(e.row, "yyyy"));
			ds_popparams.setColumn(0, "baflag", "b");
			ds_popparams.setColumn(0, "phase", "1");
			
			var objArg = new Object();
				objArg.arg_ds_popparams = ds_popparams;
			frmf_modal("SMRWY04600", "SMRWY04600", objArg, "", "", "", "", "", "", "", "", "", "M");	
		}
		else if( e.cell == grd_cmplist.getBindCellIndex("Body", "detail_a"))
		{
			ds_popparams.setColumn(0, "emplno", grp_search.ipt_emplno.value);
			ds_popparams.setColumn(0, "yyyy", ds_main_cmp_cmplist.getColumn(e.row, "yyyy"));
			ds_popparams.setColumn(0, "baflag", "a");
			ds_popparams.setColumn(0, "phase", "1");
			
			var objArg = new Object();
				objArg.arg_ds_popparams = ds_popparams;
			frmf_modal("SMRWY04600", "SMRWY04600", objArg, "", "", "", "", "", "", "", "", "", "M");
		}
	} 
	else if (selectedyyyy == "2011" ) 
	{
		if( e.cell == grd_cmplist.getBindCellIndex("Body", "detail_b"))
		{
			ds_popparams.setColumn(0, "emplno", grp_search.ipt_emplno.value);
			ds_popparams.setColumn(0, "yyyy", ds_main_cmp_cmplist.getColumn(e.row, "yyyy"));
			ds_popparams.setColumn(0, "baflag", "b");
			ds_popparams.setColumn(0, "phase", "1");
			
			var objArg = new Object();
				objArg.arg_ds_popparams = ds_popparams;
			frmf_modal("SMRWY04600", "SMRWY04600", objArg, "", "", "", "", "", "", "", "", "", "M");
		} 
		else if( e.cell == grd_cmplist.getBindCellIndex("Body", "detail_a"))
		{
			ds_popparams.setColumn(0, "emplno", grp_search.ipt_emplno.value);
			ds_popparams.setColumn(0, "yyyy", ds_main_cmp_cmplist.getColumn(e.row, "yyyy"));
			ds_popparams.setColumn(0, "baflag", "a");
			ds_popparams.setColumn(0, "phase", "1");
			
			var objArg = new Object();
				objArg.arg_ds_popparams = ds_popparams;
			frmf_modal("SMRWY04600", "SMRWY04600", objArg, "", "", "", "", "", "", "", "", "", "M");
		}
	}
	grd_cmplist.setCellPos(grd_cmplist.getBindCellIndex("body", e.col));
	grd_cmplist.showEditor(true);
}

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

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

function grd_cmplist2_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	if( ds_main_cmp_cmplist2.rowcount == 0 || ds_main_cmp_cmplist2.rowposition < 0)
	{
		return;
	}
	
	if(e.cell == grd_cmplist2.getBindCellIndex("Body", "detail_a"))
	{
		for(var i = 0; i < ds_main_cmp_cmplist2.rowcount; i++)
		{
			ds_main_cmp_cmplist2.setColumn(i, "detail_b", "false");
		}
	}
	else if( e.cell == grd_cmplist2.getBindCellIndex("Body", "detail_b"))
	{
		for(var i = 0; i < ds_main_cmp_cmplist2.rowcount; i++) 
		{
			ds_main_cmp_cmplist2.setColumn(i, "detail_a", "false");
		}	
	}
		
	var selectedyyyy = ds_main_cmp_cmplist2.getColumn(ds_main_cmp_cmplist2.rowposition, "yyyy")
	
	if( selectedyyyy == "2009" || selectedyyyy == "2010" ) 
	{	
		if( e.cell == grd_cmplist2.getBindCellIndex("Body", "detail_b"))
		{
			ds_popparams.setColumn(0, "emplno", grp_search.ipt_emplno.value);
			ds_popparams.setColumn(0, "yyyy", ds_main_cmp_cmplist2.getColumn(e.row, "yyyy"));
			ds_popparams.setColumn(0, "baflag", "b");
			ds_popparams.setColumn(0, "phase", "2");
			
			var objArg = new Object();
				objArg.arg_ds_popparams = ds_popparams;
			frmf_modal("SMRWY04600", "SMRWY04600", objArg, "", "", "", "", "", "", "", "", "", "M");
		} 
		else if( e.cell == grd_cmplist2.colRef("detail_a"))
		{
			ds_popparams.setColumn(0, "emplno", grp_search.ipt_emplno.value);
			ds_popparams.setColumn(0, "yyyy", ds_main_cmp_cmplist2.getColumn(e.row, "yyyy"));
			ds_popparams.setColumn(0, "baflag", "a");
			ds_popparams.setColumn(0, "phase", "2");
			
			var objArg = new Object();
				objArg.arg_ds_popparams = ds_popparams;
			frmf_modal("SMRWY04600", "SMRWY04600", objArg, "", "", "", "", "", "", "", "", "", "M");				
		}
	} 
	else if (selectedyyyy == "2011" || selectedyyyy == "2012" || selectedyyyy == "2013") 
	{
		if( e.cell == grd_cmplist2.getBindCellIndex("Body","detail_b"))
		{
			ds_popparams.setColumn(0, "emplno", grp_search.ipt_emplno.value);
			ds_popparams.setColumn(0, "yyyy", ds_main_cmp_cmplist2.getColumn(e.row, "yyyy"));
			ds_popparams.setColumn(0, "baflag", "b");
			ds_popparams.setColumn(0, "phase", "2");
			
			var objArg = new Object();
				objArg.arg_ds_popparams = ds_popparams;
			frmf_modal("SMRWY04600", "SMRWY04600", objArg, "", "", "", "", "", "", "", "", "", "M");				
		}
		else if( e.cell == grd_cmplist2.getBindCellIndex("Body","detail_a"))
		{
			ds_popparams.setColumn(0, "emplno", grp_search.ipt_emplno.value);
			ds_popparams.setColumn(0, "yyyy", ds_main_cmp_cmplist2.getColumn(e.row, "yyyy"));
			ds_popparams.setColumn(0, "baflag", "a");
			ds_popparams.setColumn(0, "phase", "2");
			
			var objArg = new Object();
				objArg.arg_ds_popparams = ds_popparams;
			frmf_modal("SMRWY04600", "SMRWY04600", objArg, "", "", "", "", "", "", "", "", "", "M");		
		}		
	}
	grd_cmplist2.setCellPos(grd_cmplist2.getBindCellIndex("body", e.col));
	grd_cmplist2.showEditor(true);
}
]]></Script>
  </Form>
</FDL>