YNU_JEUS/app_home/himed/xpapps/com/basiccodexp/xp/SMZBC00300_코드관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMZBC00300" position="absolute 0 0 1195 805" titletext="코드 관리" oninit="SMZBC00300_oninit" onload="SMZBC00300_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 24 1195 59" align="align:center top;" id="grd_main" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape position="absolute 1103 8 1109 28" linetype="vertical" id="line13" anchor="top right"/>
              <Button position="absolute 1120 8 1176 28" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="grd_main_btn_search_onclick"/>
              <Static text="코드군 ID :" position="absolute 15 8 98 28" id="caption2" class="search_name" anchor="default"/>
              <Edit position="absolute 114 8 214 28" id="ipt_search" class="input_search" anchor="default" autoselect="true" onkeydown="grd_main_ipt_search_onkeydown" inputmode="upper"/>
              <Button id="btn_cdgrup_search_popup" taborder="1" position="absolute 221 8 241 28" class="icon_search" anchor="default" onclick="grd_main_btn_cdgrup_search_popup_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 627 1195 805" id="grd_general_bottom" anchor="left right bottom">
          <Layouts>
            <Layout>
              <Div position="absolute 1067 5 1195 25" id="grd_general_process" anchor="top right">
                <Layouts>
                  <Layout>
                    <Button position="absolute 0 0 42 20" id="btn_add" class="btn2" text="추가" anchor="top right" onclick="grd_general_bottom_grd_general_process_btn_add_onclick"/>
                    <Button position="absolute 43 0 85 20" id="btn_update" class="btn2" text="수정" anchor="top right" onclick="grd_general_bottom_grd_general_process_btn_update_onclick"/>
                    <Button position="absolute 86 0 128 20" id="btn_delete" class="btn2" text="삭제" anchor="top right" onclick="grd_general_bottom_grd_general_process_btn_delete_onclick"/>
                  </Layout>
                </Layouts>
              </Div>
              <Shape position="absolute 0 25 1195 31" id="line1" class="line_10" anchor="left top right"/>
              <Edit position="absolute 101 30 186 51" id="ipt_cdgrupid" class="input_essential" anchor="default" autoselect="true"/>
              <Static text="코드 ID" position="absolute 187 30 287 53" align="align:center middle;" id="caption1" class="cell_1" anchor="default"/>
              <Edit position="absolute 288 30 373 51" id="ipt_cdid" class="input_essential" anchor="default" autoselect="true"/>
              <Static text="코드이름" position="absolute 374 30 474 53" align="align:center middle;" id="caption3" class="cell_1" anchor="default"/>
              <Edit position="absolute 475 30 637 51" id="ipt_cdnm" class="input_essential" anchor="default" autoselect="true"/>
              <Static text="코드영문약어명" position="absolute 638 30 738 53" align="align:center middle;" id="caption4" class="cell_1" anchor="default"/>
              <Edit position="absolute 739 30 829 51" id="ipt_cdengabbrnm" class="input_essential" anchor="default" autoselect="true"/>
              <Static text="출력순서" position="absolute 830 30 894 53" align="align:center middle;" id="caption13" class="cell_1" anchor="default"/>
              <MaskEdit position="absolute 895 30 970 51" id="ipt_dispseq" class="input_essential" mask="999999-9999999" anchor="default" autoselect="true"/>
              <Static text="코드값" position="absolute 971 30 1031 53" align="align:center middle;" id="caption5" class="cell_1" anchor="default"/>
              <Edit position="absolute 1032 30 1195 51" id="ipt_cdval" class="input_essential" anchor="default" autoselect="true"/>
              <Shape position="absolute 0 52 1195 53" id="line5" class="line_10" anchor="left top right"/>
              <Edit position="absolute 101 54 186 75" id="ipt_minval" class="input_essential" anchor="default" autoselect="true"/>
              <Static text="최대값" position="absolute 187 54 287 77" align="align:center middle;" id="caption10" class="cell_1" anchor="default"/>
              <Edit position="absolute 288 54 373 75" id="ipt_maxval" class="input_essential" anchor="default" autoselect="true"/>
              <Static text="최소 연산자" position="absolute 374 54 474 77" align="align:center middle;" id="caption9" class="cell_1" anchor="default"/>
              <Combo position="absolute 475 54 520 75" id="cmb_minopercd" class="combo_essential" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">0</Col>
                      <Col id="datacolumn">&lt;</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">&lt;=</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static text="최대 연산자" position="absolute 521 53 621 76" align="align:center middle;" id="caption11" class="cell_1" anchor="default"/>
              <Combo position="absolute 622 54 667 75" id="cmb_maxopercd" class="combo_essential" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">0</Col>
                      <Col id="datacolumn">&lt;</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">&lt;=</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static text="유효시작일시" position="absolute 668 53 757 76" align="align:center middle;" id="caption14" class="cell_1" anchor="default"/>
              <Calendar position="absolute 758 54 861 75" id="ipt_valifromdd" class="input_search" anchor="default" autoselect="true"/>
              <Static text="유효종료일시" position="absolute 862 53 947 76" align="align:center middle;" id="caption15" class="cell_1" anchor="default"/>
              <Calendar position="absolute 948 54 1051 75" id="ipt_valitodd" class="input_search" anchor="default" autoselect="true"/>
              <Shape position="absolute 0 76 1195 77" id="line9" class="line_10" anchor="left top right"/>
              <TextArea position="absolute 101 78 1195 176" id="tar_detldesc" anchor="left top right"/>
              <Static id="opt_modellabel" position="absolute 0 8 332 28" class="tit_2" anchor="default"/>
              <Static id="caption24" text="코드군 ID" class="cell_1" position="absolute 0 30 100 53" anchor="default"/>
              <Static id="caption8" text="최소값" class="cell_1" position="absolute 0 54 100 77" anchor="default"/>
              <Shape id="line10" class="line_1" position="absolute 0 177 1195 178" anchor="left top right" type="triangle"/>
              <Static id="caption22" text="코드 상세설명" class="cell_1" position="absolute 0 78 100 178" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Static text="코드군 목록" position="absolute 30 73 148 93" id="caption_cdgrup_list" class="tit_2"/>
        <Shape position="absolute 0 90 1195 96" id="line8" class="line_10" anchor="left top right"/>
        <Grid position="absolute 0 95 340 622" id="grd_cdgruplist" binddataset="ds_grd_cdgruplist" anchor="left top bottom" treeusecheckbox="false" treeuseimage="false" oncelldblclick="grd_cdgruplist_oncelldblclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="125"/>
                <Column size="200"/>
                <Column size="60"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="코드군ID"/>
                <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="최초등록자ID"/>
                <Cell col="12" text="최초등록자이름"/>
                <Cell col="13" text="최초등록일시"/>
                <Cell col="14" text="최종수정자ID"/>
                <Cell col="15" text="최종수정자이름"/>
                <Cell col="16" text="최종수정일시"/>
                <Cell col="17" text="레 벨"/>
              </Band>
              <Band id="body">
                <Cell displaytype="tree" edittype="tree" text="bind:cdgrupid" treestartlevel="1" treelevel="bind:level"/>
                <Cell col="1" displaytype="text" text="bind:cdgrupnm"/>
                <Cell col="2" text="bind:cdlgth"/>
                <Cell col="3" text="bind:detldesc"/>
                <Cell col="4" text="bind:dispseq"/>
                <Cell col="5" text="bind:valifromdd" mask="yyyy-mm-dd"/>
                <Cell col="6" text="bind:valitodd" mask="yyyy-mm-dd"/>
                <Cell col="7" text="bind:authinstcd"/>
                <Cell col="8" text="bind:authinstnm"/>
                <Cell col="9" text="bind:authdeptcd"/>
                <Cell col="10" text="bind:authdeptnm"/>
                <Cell col="11" text="bind:fstrgstrid"/>
                <Cell col="12" text="bind:fstrgstrnm"/>
                <Cell col="13" text="bind:fstrgstdt" mask="yyyy-mm-dd hh:nn:ss"/>
                <Cell col="14" text="bind:lastupdtrid"/>
                <Cell col="15" text="bind:lastupdtrnm"/>
                <Cell col="16" text="bind:lastupdtdt" mask="yyyy-mm-dd hh:nn:ss"/>
                <Cell col="17" text="bind:level"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid position="absolute 375 95 1195 622" id="grd_cdlist" binddataset="ds_grd_cdlist" anchor="all" oncelldblclick="grd_cdlist_oncelldblclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="26" band="left"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="140"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="60"/>
                <Column size="130"/>
                <Column size="190"/>
                <Column size="68"/>
                <Column size="160"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="68"/>
                <Column size="68"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="150"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="150"/>
              </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="코드SID"/>
                <Cell col="4" text="코드군ID"/>
                <Cell col="5" text="코드군명"/>
                <Cell col="6" text="코드ID"/>
                <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" text="유효시작일자"/>
                <Cell col="18" text="유효종료일자"/>
                <Cell col="19" text="최초등록자ID"/>
                <Cell col="20" text="최초등록자명"/>
                <Cell col="21" text="최초등록일시"/>
                <Cell col="22" text="최종수정자ID"/>
                <Cell col="23" text="최종수정자명"/>
                <Cell col="24" text="최종수정일시"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:process"/>
                <Cell col="2" text="bind:class"/>
                <Cell col="3" displaytype="text" text="bind:cdsid"/>
                <Cell col="4" displaytype="text" text="bind:cdgrupid"/>
                <Cell col="5" displaytype="text" text="bind:cdgrupnm"/>
                <Cell col="6" displaytype="text" text="bind:cdid"/>
                <Cell col="7" text="bind:cdlgth"/>
                <Cell col="8" displaytype="text" text="bind:cdnm"/>
                <Cell col="9" displaytype="text" text="bind:detldesc"/>
                <Cell col="10" text="bind:dispseq"/>
                <Cell col="11" displaytype="text" text="bind:cdval"/>
                <Cell col="12" text="bind:minval"/>
                <Cell col="13" text="bind:maxval"/>
                <Cell col="14" text="bind:minopercd"/>
                <Cell col="15" text="bind:maxopercd"/>
                <Cell col="16" text="bind:cdengabbrnm"/>
                <Cell col="17" displaytype="text" style="align:center middle;" text="bind:valifromdd" mask="####-##-##"/>
                <Cell col="18" displaytype="text" style="align:center middle;" text="bind:valitodd" mask="####-##-##"/>
                <Cell col="19" text="bind:fstrgstrid"/>
                <Cell col="20" text="bind:fstrgstrnm"/>
                <Cell col="21" displaytype="date" text="bind:fstrgstdt" mask="yyyy-MM-dd hh:mm:ss"/>
                <Cell col="22" text="bind:lastupdtrid"/>
                <Cell col="23" text="bind:lastupdtrnm"/>
                <Cell col="24" displaytype="date" text="bind:lastupdtdt" mask="yyyy-MM-dd hh:mm:ss"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static text="코드 목록" position="absolute 405 73 523 93" id="caption_cd_list" class="tit_2"/>
        <Div position="absolute 989 70 1195 90" id="grp_excel_process" anchor="top right">
          <Layouts>
            <Layout>
              <Button position="absolute 0 0 64 20" id="button1" class="btn2" text="엑셀입력" anchor="top right" onclick="grp_excel_process_button1_onclick"/>
              <Button position="absolute 65 0 141 20" id="button2" class="btn7" text="엑셀출력" anchor="top right"/>
              <Button position="absolute 142 0 206 20" id="button3" class="btn2" text="행삭제" anchor="top right"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 1119 70 1195 90" id="grp_excel_save" anchor="top right">
          <Layouts>
            <Layout>
              <Button position="absolute 0 0 76 20" id="button4" class="btn7" text="엑셀출력" anchor="top right" onclick="grp_excel_save_button4_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 345 346 371 388" id="grd_reorg_sequence">
          <Layouts>
            <Layout>
              <Button id="btn_bottom" taborder="0" class="icon_bottom" position="absolute 0 22 26 42" anchor="default" onclick="grd_reorg_sequence_btn_bottom_onclick"/>
              <Button id="btn_top" taborder="1" class="icon_top" position="absolute 0 0 26 20" anchor="default" onclick="grd_reorg_sequence_btn_top_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption6" text="코드 관리" class="tit_1" position="absolute 0 0 93 25"/>
        <Button id="btn_save" taborder="1" text="저장" class="btn4" position="absolute 1068 3 1124 23" anchor="top right" onclick="btn_save_onclick"/>
        <Button id="btn_init" taborder="2" text="초기화" class="btn4" position="absolute 1127 3 1195 23" anchor="top right" onclick="btn_init_onclick"/>
        <Button id="btn_convert_general_process" taborder="3" position="absolute 0 72 26 89" class="icon_right" onclick="btn_convert_general_process_onclick"/>
        <Button id="btn_convert_import_excel" taborder="4" position="absolute 375 72 401 89" class="icon_left" onclick="btn_convert_import_excel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_grd_cdgruplist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdgrupid" type="STRING" size="256" sumtext="코드군ID"/>
          <Column id="cdgrupnm" type="STRING" size="256" sumtext="코드군이름"/>
          <Column id="cdlgth" type="STRING" size="256" sumtext="코드길이"/>
          <Column id="detldesc" type="STRING" size="256" sumtext="코드군상세설명"/>
          <Column id="dispseq" type="STRING" size="256" sumtext="출력순서"/>
          <Column id="aliasid" type="STRING" size="256" sumtext="참조코드군ID"/>
          <Column id="valifromdd" type="STRING" size="256" sumtext="유효시작일자"/>
          <Column id="valitodd" type="STRING" size="256" sumtext="유효종료일자"/>
          <Column id="authinstcd" type="STRING" size="256" sumtext="권한기관코드"/>
          <Column id="authinstnm" type="STRING" size="256" sumtext="권한기관명"/>
          <Column id="authdeptcd" type="STRING" size="256" sumtext="권한부서코드"/>
          <Column id="authdeptnm" type="STRING" size="256" sumtext="권한부서명"/>
          <Column id="fstrgstrid" type="STRING" size="256" sumtext="최초등록자ID"/>
          <Column id="fstrgstrnm" type="STRING" size="256" sumtext="최초등록자이름"/>
          <Column id="fstrgstdt" type="STRING" size="256" sumtext="최초등록일시"/>
          <Column id="lastupdtrid" type="STRING" size="256" sumtext="최종수정자ID"/>
          <Column id="lastupdtrnm" type="STRING" size="256" sumtext="최종수정자이름"/>
          <Column id="lastupdtdt" type="STRING" size="256" sumtext="최종수정일시"/>
          <Column id="level" type="STRING" size="256" sumtext="레벨"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grd_cdlist" updatecontrol="true">
        <ColumnInfo>
          <Column id="cdsid" type="STRING" size="255"/>
          <Column id="cdgrupid" type="STRING" size="255"/>
          <Column id="cdgrupnm" type="STRING" size="255"/>
          <Column id="cdlgth" type="BIGDECIMAL" size="255"/>
          <Column id="cdid" type="STRING" size="255"/>
          <Column id="cdnm" type="STRING" size="255"/>
          <Column id="detldesc" type="STRING" size="255"/>
          <Column id="dispseq" type="BIGDECIMAL" size="255"/>
          <Column id="cdval" type="STRING" size="255"/>
          <Column id="minval" type="STRING" size="255"/>
          <Column id="maxval" type="STRING" size="255"/>
          <Column id="minopercd" type="STRING" size="255"/>
          <Column id="maxopercd" type="STRING" size="255"/>
          <Column id="cdengabbrnm" type="STRING" size="255"/>
          <Column id="valifromdd" type="STRING" size="255"/>
          <Column id="valitodd" type="STRING" size="255"/>
          <Column id="fstrgstrid" type="STRING" size="255"/>
          <Column id="fstrgstrnm" type="STRING" size="255"/>
          <Column id="fstrgstdt" type="STRING" size="255"/>
          <Column id="lastupdtrid" type="STRING" size="255"/>
          <Column id="lastupdtrnm" type="STRING" size="255"/>
          <Column id="lastupdtdt" type="STRING" size="255"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="level" type="INT" size="256" sumtext="레벨"/>
          <Column id="supcdgrupid" type="STRING" size="256" sumtext="상위코드군 ID"/>
          <Column id="supcdgrupnm" type="STRING" size="256" sumtext="상위코드군 이름"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdgrupid" type="STRING" size="256" sumtext="코드군ID"/>
          <Column id="cdid" type="STRING" size="256" sumtext="코드ID"/>
          <Column id="cdnm" type="STRING" size="256" sumtext="코드이름"/>
          <Column id="sortfield" type="STRING" size="256" sumtext="출력순서"/>
          <Column id="join" type="STRING" size="256" sumtext="참조여부"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_status" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="retrived" type="STRING" size="256"/>
          <Column id="retrivedtitle" type="STRING" size="256"/>
          <Column id="process" type="STRING" size="256"/>
          <Column id="processtitle" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdsid" type="STRING" size="255"/>
          <Column id="cdgrupid" type="STRING" size="255"/>
          <Column id="cdgrupnm" type="STRING" size="255"/>
          <Column id="cdlgth" type="BIGDECIMAL" size="255"/>
          <Column id="cdid" type="STRING" size="255"/>
          <Column id="cdnm" type="STRING" size="255"/>
          <Column id="detldesc" type="STRING" size="255"/>
          <Column id="dispseq" type="BIGDECIMAL" size="255"/>
          <Column id="cdval" type="STRING" size="255"/>
          <Column id="minval" type="STRING" size="255"/>
          <Column id="maxval" type="STRING" size="255"/>
          <Column id="minopercd" type="STRING" size="255"/>
          <Column id="maxopercd" type="STRING" size="255"/>
          <Column id="cdengabbrnm" type="STRING" size="255"/>
          <Column id="valifromdd" type="STRING" size="255"/>
          <Column id="valitodd" type="STRING" size="255"/>
          <Column id="fstrgstrid" type="STRING" size="255"/>
          <Column id="fstrgstrnm" type="STRING" size="255"/>
          <Column id="fstrgstdt" type="STRING" size="255"/>
          <Column id="lastupdtrid" type="STRING" size="255"/>
          <Column id="lastupdtrnm" type="STRING" size="255"/>
          <Column id="lastupdtdt" type="STRING" size="255"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_mode" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="modestatus" type="STRING" size="256"/>
          <Column id="modelabel" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="modestatus"/>
            <Col id="modelabel"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_save_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdsid" type="STRING" size="255"/>
          <Column id="cdgrupid" type="STRING" size="255"/>
          <Column id="cdgrupnm" type="STRING" size="255"/>
          <Column id="cdlgth" type="BIGDECIMAL" size="255"/>
          <Column id="cdid" type="STRING" size="255"/>
          <Column id="cdnm" type="STRING" size="255"/>
          <Column id="detldesc" type="STRING" size="255"/>
          <Column id="dispseq" type="BIGDECIMAL" size="255"/>
          <Column id="cdval" type="STRING" size="255"/>
          <Column id="minval" type="STRING" size="255"/>
          <Column id="maxval" type="STRING" size="255"/>
          <Column id="minopercd" type="STRING" size="255"/>
          <Column id="maxopercd" type="STRING" size="255"/>
          <Column id="cdengabbrnm" type="STRING" size="255"/>
          <Column id="valifromdd" type="STRING" size="255"/>
          <Column id="valitodd" type="STRING" size="255"/>
          <Column id="fstrgstrid" type="STRING" size="255"/>
          <Column id="fstrgstrnm" type="STRING" size="255"/>
          <Column id="fstrgstdt" type="STRING" size="255"/>
          <Column id="lastupdtrid" type="STRING" size="255"/>
          <Column id="lastupdtrnm" type="STRING" size="255"/>
          <Column id="lastupdtdt" type="STRING" size="255"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="count" type="STRING" size="256" sumtext="count"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grd_main.ipt_search" propid="value" datasetid="ds_send_search" columnid="supcdgrupid"/>
      <BindItem id="item1" compid="grd_general_bottom.ipt_cdgrupid" propid="value" datasetid="ds_data" columnid="cdgrupid"/>
      <BindItem id="item2" compid="grd_general_bottom.ipt_cdid" propid="value" datasetid="ds_data" columnid="cdid"/>
      <BindItem id="item3" compid="grd_general_bottom.ipt_cdnm" propid="value" datasetid="ds_data" columnid="cdnm"/>
      <BindItem id="item4" compid="grd_general_bottom.ipt_cdengabbrnm" propid="value" datasetid="ds_data" columnid="cdengabbrnm"/>
      <BindItem id="item5" compid="grd_general_bottom.ipt_dispseq" propid="value" datasetid="ds_data" columnid="dispseq"/>
      <BindItem id="item6" compid="grd_general_bottom.ipt_cdval" propid="value" datasetid="ds_data" columnid="cdval"/>
      <BindItem id="item7" compid="grd_general_bottom.ipt_minval" propid="value" datasetid="ds_data" columnid="minval"/>
      <BindItem id="item8" compid="grd_general_bottom.ipt_maxval" propid="value" datasetid="ds_data" columnid="maxval"/>
      <BindItem id="item9" compid="grd_general_bottom.cmb_minopercd" propid="value" datasetid="ds_data" columnid="minopercd"/>
      <BindItem id="item10" compid="grd_general_bottom.cmb_maxopercd" propid="value" datasetid="ds_data" columnid="maxopercd"/>
      <BindItem id="item11" compid="grd_general_bottom.ipt_valifromdd" propid="value" datasetid="ds_data" columnid="valifromdd"/>
      <BindItem id="item12" compid="grd_general_bottom.ipt_valitodd" propid="value" datasetid="ds_data" columnid="valitodd"/>
      <BindItem id="item13" compid="grd_general_bottom.tar_detldesc" propid="value" datasetid="ds_data" columnid="detldesc"/>
      <BindItem id="item14" compid="grd_general_bottom.opt_modellabel" propid="text" datasetid="ds_mode" columnid="modelabel"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2014-10-31
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2014-10-31      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "com_basiccodexp::ZBC001.xjs";
include "com_basiccodexp::ZBC003.xjs";

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

function SMZBC00300_onload(obj:Form, e:LoadEventInfo)
{
	fShiftCdListGridColumn();
	
	grdf_setRowTypeIcon(grd_cdlist, 0);
	
	btn_convert_general_process.visible = false;
	caption_cdgrup_list.position.x      = 0;
	grd_cdgruplist.visible              = true;
	grd_cdlist.position.left            = 375;
	btn_convert_import_excel.visible    = true;
	caption_cd_list.visible             = true;
	grd_general_bottom.visible          = true;
	grd_main.ipt_search.enable          = true;
	grd_main.btn_cdgrup_search_popup.enable = true;
	grd_main.btn_search.enable          = true;
	grp_excel_process.visible           = false;
	
	grd_main.ipt_search.setFocus();
}

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

function grd_main_btn_cdgrup_search_popup_onclick(obj:Button,  e:ClickEventInfo)
{
	var searchcondition = "cdgrupid";
	var searchterm 		= ds_send_search.getColumn(0, "supcdgrupid");
	
	var sReturn     = appf_openCodeGroupList(searchcondition, searchterm, true);
	var supcdgrupid = sReturn.cdgrupid;
	var supcdgrupnm = sReturn.cdgrupnm;
	
	if(!utlf_isNull(supcdgrupid))
		ds_send_search.setColumn(0,"supcdgrupid", supcdgrupid);
		
	if(!utlf_isNull(supcdgrupnm))
		ds_send_search.setColumn(0,"supcdgrupnm", supcdgrupnm);
}

function grd_main_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_send_search.setColumn(0, "level", 3);
							
	var oParam = {};
		oParam.id          = "TRZBC00107";
		oParam.service     = "basiccodeapp.BasicCodeAdmin";
		oParam.method      = "reqGetSubCodeGroupList";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "ds_grd_cdgruplist=cdgrup";
		oParam.async       = true;
		oParam.callback    = "cf_TRZBC00107";

	tranf_submit(oParam);
}

function cf_TRZBC00107(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
    
    ds_grd_cdlist.clearData();
    
	fInitMainData(true);
}

function grd_cdgruplist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	fInitMainData(true);
	
	var row      = e.row;
	var cdgrupid = ds_grd_cdgruplist.getColumn(row, "cdgrupid");
	
	ds_send_data.clearData();
	ds_send_data.addRow();
	
	ds_send_data.setColumn(0, "cdgrupid", cdgrupid);
	ds_send_data.setColumn(0, "sortfield", "dispseq");
	ds_send_data.setColumn(0, "cdid", "");
	ds_send_data.setColumn(0, "cdnm", "");
	ds_send_data.setColumn(0, "join", "true");
		
	var oParam = {};
		oParam.id          = "TRZBC00124";
		oParam.service     = "basiccodeapp.BasicCodeAdmin";
		oParam.method      = "reqGetCodeList";
		oParam.inds        = "req=ds_send_data";
		oParam.outds       = "ds_grd_cdlist=code";
		oParam.async       = true;

	tranf_submit(oParam);
}

function grd_cdlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	var modestatus = ds_mode.getColumn(0, "modestatus");
	if(modestatus != "importexcel"){
		fInitMainDataControls(false);
		var row = e.row;		
		
		ds_data.clearData();
		ds_data.addRow();
		ds_data.copyRow(0, ds_grd_cdlist, row);
		
		ds_mode.setColumn(0, "modelabel", "코드관리 > 코드상세보기");
		ds_mode.setColumn(0, "modestatus", "view");
		
		fInitMainDataControls(true);
	}
}

function grd_general_bottom_grd_general_process_btn_add_onclick(obj:Button,  e:ClickEventInfo)
{
	var row = ds_grd_cdgruplist.rowposition;
	if(row < 0){
		sysf_messageBox('추가할 대상 코드군을', 'C002');
		return;
	}
	
	var authinstcd = ds_grd_cdgruplist.getColumn(row, "authinstcd");
	var authdeptcd = ds_grd_cdgruplist.getColumn(row, "authdeptcd");

	var authrized = fAuthorize(authinstcd, authdeptcd);
	
	if(authrized){
		var cdgrupid = ds_grd_cdgruplist.getColumn(row, "cdgrupid");
		fInitMainData(false);
		
		ds_mode.setColumn(0, "modelabel",  "코드관리 > 코드추가");
		ds_mode.setColumn(0, "modestatus", "insert");
		ds_data.setColumn(0, "cdgrupid",   cdgrupid);
		ds_data.setColumn(0, "dispseq",    ds_grd_cdlist.rowcount);
		ds_data.setColumn(0, "valifromdd", utlf_getCurrentDate());
		ds_data.setColumn(0, "valitodd",   "99991231");
		grd_general_bottom.ipt_cdgrupid.enable = false;
	}else{
		var userinfo = fGetUserInfo();
		sysf_messageBox(userinfo+" 는 추가할", "E002") ;
		return;
	}
}

function grd_general_bottom_grd_general_process_btn_update_onclick(obj:Button,  e:ClickEventInfo)
{
	var row = ds_grd_cdlist.rowposition;
	if(row < 0){
		sysf_messageBox('수정할 대상 코드군을', 'C002');
		return;
	}

	var authinstcd = ds_grd_cdgruplist.getColumn(row, "authinstcd");
	var authdeptcd = ds_grd_cdgruplist.getColumn(row, "authdeptcd");
	
	var authrized = fAuthorize(authinstcd, authdeptcd);
	
	if(authrized){
		ds_data.clearData();
		ds_data.addRow();
		ds_data.copyRow(0, ds_grd_cdlist, row);
		
		ds_mode.setColumn(0, "modelabel", "코드관리 > 코드수정");
		ds_mode.setColumn(0, "modestatus", "update");
		
		fInitMainDataControls(false);
		grd_general_bottom.ipt_cdgrupid.enable = false;
		grd_general_bottom.ipt_cdid.enabl      = false;
	}else{
		var userinfo = fGetUserInfo();
		sysf_messageBox(userinfo+" 는 수정할", "E002") ;
		return;
	}
}

function grd_general_bottom_grd_general_process_btn_delete_onclick(obj:Button,  e:ClickEventInfo)
{
	var row = ds_grd_cdlist.rowposition;
	if(row < 0){
		sysf_messageBox('삭제할 대상 코드군을', 'C002');
		return;
	}

	var authinstcd = ds_grd_cdgruplist.getColumn(row, "authinstcd");
	var authdeptcd = ds_grd_cdgruplist.getColumn(row, "authdeptcd");
	
	var authrized = fAuthorize(authinstcd, authdeptcd);
	if(authrized){
		ds_data.clearData();
		ds_data.addRow();
		ds_data.copyRow(0, ds_grd_cdlist, row);
		
		ds_mode.setColumn(0, "modelabel",  "코드관리 > 코드삭제");
		ds_mode.setColumn(0, "modestatus", "delete");
		
		ds_grd_cdlist.updatecontrol = false;
		ds_grd_cdlist.setRowType(row, Dataset.ROWTYPE_DELETE);
		ds_grd_cdlist.updatecontrol = true;
		
		fInitMainDataControls(true);
	}else{
		var userinfo = fGetUserInfo();
		sysf_messageBox(userinfo+" 는 수정할", "E002") ;
		return;
	}
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	var result;
	var modestatus = ds_mode.getColumn(0, "modestatus");
	var cdsid;
	if(modestatus == "view"){
		sysf_messageBox("조회중인 정보를 저장", 'E001') ;
		return;
	}else if(modestatus == "insert"){
		if(!fValidateMainData()) return false;
		var cdgrupid = ds_data.getColumn(0, "cdgrupid");
		var cdid     = ds_data.getColumn(0, "cdid");
		var cdnm     = ds_data.getColumn(0, "cdnm");
		var cdsid    = cdgrupid + cdid;
		if(cdnm == ""){
			ds_data.setColumn(0, "detldesc", cdnm);
		}
		result = sysf_messageBox( "[코드군 ID : "+cdgrupid+",코드 ID : "+cdid+", 코드 이름: "+cdnm+"]을 추가", "S001");
		
		ds_data.setColumn(0, "cdsid", cdsid);
		
		if( result == 7 || result == 2 ) return;
		
		ds_save_data.copyData(ds_data);
		
		// 코드이름 중복체크 
		ds_hidden_temp.clearData();
		
		var oParam = {};
			oParam.id          = "TRZBC00126";
			oParam.service     = "basiccodeapp.BasicCodeAdmin";
			oParam.method      = "reqGetCodeNameCount";
			oParam.inds        = "req=ds_save_data";
			oParam.outds       = "ds_hidden_temp=count";
			oParam.async       = false;

		tranf_submit(oParam);
		
		var count = ds_hidden_temp.getColumn(0, "count");
		if (count > 0) {
			result = sysf_messageBox( "[코드군 ID : "+cdgrupid+"]에 동일한  코드 이름이 존재합니다. ["+cdnm+"]을 추가", "S001");
			if( result == 7 || result == 2 ) return;
		}
		
		var oParam = {};
			oParam.id          = "TRZBC00109";
			oParam.service     = "basiccodeapp.BasicCodeAdmin";
			oParam.method      = "reqInsCode";
			oParam.inds        = "req=ds_save_data";
			oParam.async       = false;

		tranf_submit(oParam);
	}else if(modestatus == "update"){
		var cdgrupid = ds_data.getColumn(0, "cdgrupid");
		var cdid     = ds_data.getColumn(0, "cdid");
		cdsid        = cdgrupid+cdid;
		var cdnm	     =  ds_data.getColumn(0, "cdnm");
		result = sysf_messageBox( "[코드군 ID : "+cdgrupid+",코드 ID : "+cdid+", 코드 이름 : "+cdnm+"]을 수정", "S001");
		if( result == 7 || result == 2 ) return;
		
		ds_save_data.copyData(ds_data);
		
		var oParam = {};
			oParam.id          = "TRZBC00109";
			oParam.service     = "basiccodeapp.BasicCodeAdmin";
			oParam.method      = "reqSetCode";
			oParam.inds        = "req=ds_save_data";
			oParam.async       = false;

		tranf_submit(oParam);
	}else if(modestatus == "delete"){
		var cdgrupid = ds_data.getColumn(0, "cdgrupid");
		var cdid = ds_data.getColumn(0, "cdid");
		cdsid = cdgrupid+cdid;
		var cdnm = ds_data.getColumn(0, "cdnm");
		result = sysf_messageBox( "[코드군 ID : "+cdgrupid+",코드 ID : "+cdid+", 코드 이름 : "+cdnm+"]을 삭제", "S001");
		if( result == 7 || result == 2 ) return;						
		
		ds_save_data.copyData(ds_data);		
		ds_save_data.setColumn(0, "cdsid", cdsid);
		
		var oParam = {};
			oParam.id          = "TXZBC00111";
			oParam.service     = "basiccodeapp.BasicCodeAdmin";
			oParam.method      = "reqDelCode";
			oParam.inds        = "req=ds_save_data";
			oParam.async       = false;

		tranf_submit(oParam);
	}else if(modestatus == "importexcel"){
		var oDsUpdate = grdf_getGridUpdateData(grd_cdlist);
		grdf_setStatusColumn(oDsUpdate, "rowstatus");		
		ds_save_data.copyData(oDsUpdate, true);
		
		var oParam = {};
			oParam.id          = "TXZBC00119";
			oParam.service     = "basiccodeapp.BasicCodeAdmin";
			oParam.method      = "reqInsCodeList";
			oParam.inds        = "req=ds_save_data";
			oParam.async       = false;
			oParam.callback    = "cf_TXZBC00119";

		tranf_submit(oParam);
	}else if(modestatus == "swapsequence"){
		var oDsUpdate = grdf_getGridUpdateData(grd_cdlist);		
		ds_save_data.copyData(oDsUpdate, true);
		
		var oParam = {};
			oParam.id          = "TXZBC00120";
			oParam.service     = "basiccodeapp.BasicCodeAdmin";
			oParam.method      = "reqExeSwapCodeSequence";
			oParam.inds        = "req=ds_save_data";
			oParam.async       = false;

		tranf_submit(oParam);
	}else{
		sysf_messageBox('처리 모드를', 'C002');
		return;
	}

	if(modestatus != "importexcel"){
		
		fInitMainData(true);
		var row      = ds_grd_cdgruplist.rowposition;
		var cdgrupid = ds_grd_cdgruplist.getColumn(row, "cdgrupid");
		
		var cdRow    = ds_grd_cdlist.rowposition;
		
		ds_send_data.clearData();
		ds_send_data.addRow();
		
		ds_send_data.setColumn(0, "cdgrupid",  cdgrupid);
		ds_send_data.setColumn(0, "sortfield", "dispseq");
		ds_send_data.setColumn(0, "cdid", "");
		ds_send_data.setColumn(0, "cdnm", "");
		ds_send_data.setColumn(0, "join", "true");
		
		var oParam = {};
			oParam.id          = "TRZBC00124";
			oParam.service     = "basiccodeapp.BasicCodeAdmin";
			oParam.method      = "reqGetCodeList";
			oParam.inds        = "req=ds_send_data";
			oParam.outds       = "ds_grd_cdlist=code";
			oParam.async       = false;

		tranf_submit(oParam);
		
		fInitMainDataControls(false);
		
		if(modestatus != "delete" && modestatus != "swapsequence"){
			row = ds_grd_cdlist.findRow("cdsid", cdsid);
			
			if(row >= 0) {
				ds_data.clearData();
				ds_data.addRow();
				ds_data.copyRow(0, ds_grd_cdlist, row);
			
				ds_mode.setColumn(0, "modelabel",  "코드관리 > 코드상세보기");
				ds_mode.setColumn(0, "modestatus", "view");			
			}
		}
		
		fInitMainDataControls(true);							
	}
}

function cf_TXZBC00119(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
    
    alert("["+(ds_grd_cdlist.rowcount - 1)+"]개의 코드군을 엑셀로 부터 추출하여 성공적으로 서버에 적용하였습니다.");
    
    ds_grd_cdlist.applyChange();
}

function grd_reorg_sequence_btn_top_onclick(obj:Button,  e:ClickEventInfo)
{
	var selected_row = ds_grd_cdlist.rowposition;
	var up_row = selected_row - 1;
	
	if(selected_row >= 0){
		if(up_row >= 0){
			fSwapCodeSequence(ds_grd_cdlist, selected_row, up_row);
			
			ds_mode.setColumn(0, "modestatus", "swapsequence");
		}else{
			sysf_messageBox("더이상 위로 이동할수 없습니다.", "C");
		}
	}else{
		sysf_messageBox("선택된 행이 없습니다.", "C");
	}
}

function grd_reorg_sequence_btn_bottom_onclick(obj:Button,  e:ClickEventInfo)
{
	var selected_row = ds_grd_cdlist.rowposition;
	var dn_row = selected_row + 1;
	
	if(selected_row >= 0){
		if(dn_row < ds_grd_cdlist.rowcount){
			fSwapCodeSequence(ds_grd_cdlist, selected_row, dn_row);
			
			ds_mode.setColumn(0, "modestatus", "swapsequence");
		}else{
			sysf_messageBox("더이상 아래로 이동할수 없습니다.", "C");
		}
	}else{
		sysf_messageBox("선택된 행이 없습니다.", "C");
	}
}

function btn_init_onclick(obj:Button,  e:ClickEventInfo)
{
	reload();
}

function grp_excel_process_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_grd_cdlist.rowcount > 0)
	{
		return;		
	}
	
	grdf_ImportExcel("ds_grd_cdlist", 2, grd_cdlist, 0); // 타이틀 제외한 2열부터 입력
}

function btn_convert_import_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	fShiftCdListGridColumn("excel");
	
	grd_cdgruplist.visible                  = false;
	grd_main.enable                         = false;
	btn_convert_import_excel.visible        = false;
	grp_excel_process.visible               = true;
	grp_excel_save.visible                  = false;
	caption_cd_list.visible                 = false;
	grd_cdlist.position.left                = 0;
	grd_cdlist.position.bottom              = grd_general_bottom.position.bottom;
	grd_reorg_sequence.visible              = false;
	grd_general_bottom.visible              = false;
	btn_convert_general_process.visible     = true;
	caption_cdgrup_list.visible             = true;
	caption_cdgrup_list.position.x          = 30;
	
	ds_grd_cdlist.clearData();
	
	ds_mode.setColumn(0, "modestatus", "importexcel");
}

function btn_convert_general_process_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_grd_cdlist.clearData();
	
	btn_convert_general_process.visible = false;
	caption_cdgrup_list.position.x      = 0;
	grd_cdgruplist.visible              = true;
	grd_cdlist.position.left            = 375;
	grd_cdlist.position.bottom          = grd_general_bottom.position.y - 5;
	btn_convert_import_excel.visible    = true;
	caption_cd_list.visible             = true;
	grd_general_bottom.visible          = true;
	grd_main.enable                     = true;
	grp_excel_process.visible           = false;
	grp_excel_save.visible              = true;
	grd_reorg_sequence.visible          = true;
	ds_mode.setColumn(0, "modestatus", "");
	
	fShiftCdListGridColumn();
}

function grp_excel_save_button4_onclick(obj:Button,  e:ClickEventInfo)
{
	var row      = ds_grd_cdgruplist.rowposition;
	var cdgrupid = ds_grd_cdgruplist.getColumn(row, "cdgrupid");
	var cdgrupnm = ds_grd_cdgruplist.getColumn(row, "cdgrupnm");
	
	var excelFileName = cdgrupnm + "코드_" + cdgrupid;
	grdf_exportExcel(grd_cdlist, excelFileName, excelFileName, true, "", "user", true );
}
]]></Script>
  </Form>
</FDL>