YNU_JEUS/app_home/himed/xpapps/mis/slipxp/xp/SMRAD00210_전표조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAD00210" position="absolute 0 0 1201 782" titletext="전표조회" oninit="SMRAD00210_oninit" onload="SMRAD00210_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="전표조회" class="tit_1" position="absolute 0 0 230 25"/>
        <Grid id="grd_slipdetlspec" taborder="1" binddataset="ds_main_slipdetlspec" autoenter="select" useinputpanel="false" cellsizingtype="col" position="absolute 0 458 959 756" anchor="left right bottom">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="21"/>
                <Column size="37"/>
                <Column size="63"/>
                <Column size="143"/>
                <Column size="129"/>
                <Column size="322"/>
                <Column size="115"/>
                <Column size="117"/>
                <Column size="150"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </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="기관코드"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow == ds_main_slipdetlspec.rowposition ? '▶' : ''"/>
                <Cell col="1" text="bind:unslseqno"/>
                <Cell col="2" text="bind:acntcd"/>
                <Cell col="3" text="bind:acntnm"/>
                <Cell col="4" text="bind:custnm"/>
                <Cell col="5" text="bind:etcnotefact"/>
                <Cell col="6" displaytype="number" text="bind:dramt"/>
                <Cell col="7" displaytype="number" text="bind:cramt"/>
                <Cell col="8" text="bind:nmbojo1"/>
                <Cell col="9" text="bind:amt"/>
                <Cell col="10" text="bind:unsldd"/>
                <Cell col="11" text="bind:unslno"/>
                <Cell col="12" text="bind:instcd"/>
              </Band>
              <Band id="summary">
                <Cell style="background:#00ffffff;background2:#00ffffff;"/>
                <Cell col="1" style="background:#00ffffff;background2:#00ffffff;color:#000000ff;color2:#000000ff;font:arial,9,bold;"/>
                <Cell col="2" style="background:#00ffffff;background2:#00ffffff;color:#000000ff;color2:#000000ff;font:arial,9,bold;"/>
                <Cell col="3" style="align:left middle;padding:0 0 0 3;background:#00ffffff;background2:#00ffffff;color:#000000ff;color2:#000000ff;font:arial,9,bold;" text="합   계"/>
                <Cell col="4" style="background:#00ffffff;background2:#00ffffff;color:#000000ff;color2:#000000ff;font:arial,9,bold;"/>
                <Cell col="5" style="background:#00ffffff;background2:#00ffffff;color:#000000ff;color2:#000000ff;font:arial,9,bold;"/>
                <Cell col="6" displaytype="number" style="background:#00ffffff;background2:#00ffffff;color:#000000ff;color2:#000000ff;font:arial,9,bold;" text="expr:getSum('dramt')"/>
                <Cell col="7" displaytype="number" style="background:#00ffffff;background2:#00ffffff;color:#000000ff;color2:#000000ff;font:arial,9,bold;" text="expr:getSum('cramt')"/>
                <Cell col="8" style="background:#00ffffff;background2:#00ffffff;color:#000000ff;color2:#000000ff;font:arial,9,bold;"/>
                <Cell col="9"/>
                <Cell col="10"/>
                <Cell col="11"/>
                <Cell col="12"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid id="grd_slipreflist" taborder="2" binddataset="ds_main_slipreflist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 138 1193 428" oncellclick="grd_slipreflist_oncellclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="22"/>
                <Column size="0"/>
                <Column size="75"/>
                <Column size="56"/>
                <Column size="119"/>
                <Column size="127"/>
                <Column size="72"/>
                <Column size="68"/>
                <Column size="100"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="80"/>
                <Column size="340"/>
                <Column size="59"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="30"/>
              </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="확인"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow == ds_main_slipreflist.rowposition ? '▶' : ''"/>
                <Cell col="1" text="bind:instcd"/>
                <Cell col="2" displaytype="date" text="bind:unsldd" calendardisplaynulltype="nulltext"/>
                <Cell col="3" text="bind:unslno"/>
                <Cell col="4" text="bind:slipflag"/>
                <Cell col="5" text="bind:slipdeptnm"/>
                <Cell col="6" text="bind:usernm"/>
                <Cell col="7" style="color:EXPR(slipstatus == '미전송' ? '#000000' : slipstatus == '미승인' ? '#0000FF' : '#FF0000');color2:EXPR(slipstatus == '미전송' ? '#000000' : slipstatus == '미승인' ? '#0000FF' : '#FF0000');" text="bind:slipstatus"/>
                <Cell col="8" displaytype="date" text="bind:defrayreqdd" calendardisplaynulltype="nulltext"/>
                <Cell col="9" text="bind:slipdd" mask="yyyy-mm-dd"/>
                <Cell col="10" text="bind:slipno"/>
                <Cell col="11" displaytype="number" text="bind:amt"/>
                <Cell col="12" style="align:left middle;padding:0 0 0 3;" text="bind:slipcmt" wordwrap="word"/>
                <Cell col="13" displaytype="combo" style="align:center;color2:EXPR(slipstatus == '미전송' ? '#000000' : slipstatus == '미승인' ? '#0000FF' : '#FF0000');" text="bind:slipkind" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="14" text="bind:slipdeptcd"/>
                <Cell col="15" text="bind:unslwrit"/>
                <Cell col="16" displaytype="checkbox" style="controlbackground:darkgray;controlborder:1 solid #808080ff ;" text="bind:checkyn" expr="expr:checkyn == 'Y' ? 1 : 0"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line1" class="line_10" position="absolute 0 133 1193 139"/>
        <Div id="group4" taborder="3" class="div_SA" position="absolute 0 25 1195 110">
          <Layouts>
            <Layout>
              <Combo id="cmb_ddkind" taborder="19" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 770 11 845 30">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">wd</Col>
                      <Col id="datacolumn">작성일자</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">od</Col>
                      <Col id="datacolumn">기표일자</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption5" text="작성일자 :" class="search_name" position="absolute 756 12 844 29"/>
              <Static id="caption7" text="전표상태 :" class="search_name" visible="false" position="absolute 424 60 515 77"/>
              <Shape id="line30" linetype="vertical" class="line_4" position="absolute 1076 12 1082 53"/>
              <Static id="caption8" text="전표유형 :" class="search_name" position="absolute 424 34 515 51"/>
              <Static id="caption37" text="작성부서 :" class="search_name" position="absolute 16 11 107 28"/>
              <Calendar id="input6" taborder="8" class="input_s_essential" position="absolute 845 11 945 30" autoselect="true" autoskip="true"/>
              <Calendar id="input2" taborder="9" class="input_s_essential" position="absolute 965 11 1065 30" autoselect="true" autoskip="true"/>
              <Static id="caption38" text="~" position="absolute 950 11 965 31"/>
              <Radio id="rdo_gubn" taborder="10" columncount="4" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" class="radio_search" visible="false" position="absolute 513 59 838 79">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">%</Col>
                      <Col id="datacolumn">전  체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">A</Col>
                      <Col id="datacolumn">승  인</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">U</Col>
                      <Col id="datacolumn">미승인</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">W</Col>
                      <Col id="datacolumn">미전송</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Radio id="rdo_slipkind" taborder="11" columncount="5" rowcount="0" class="radio_search" position="absolute 513 34 730 54"/>
              <Edit id="ipt_slipdeptnm" taborder="12" class="input_default" position="absolute 209 11 405 30" onkeydown="group4_ipt_slipdeptnm_onkeydown"/>
              <Button id="btn_slipdeptcd" taborder="13" class="icon_search" position="absolute 189 13 205 29" onclick="group4_btn_slipdeptcd_onclick"/>
              <Edit id="ipt_slipdeptcd" taborder="14" class="input_default" position="absolute 105 11 185 30" autoselect="true" autoskip="true" onkeydown="group4_ipt_slipdeptcd_onkeydown"/>
              <Button id="btn_search" taborder="15" text="조회" class="btn1" position="absolute 1095 23 1151 45" onclick="group4_btn_search_onclick"/>
              <MaskEdit id="input1" taborder="16" mask="9,999999999999999" class="input_default" position="absolute 845 34 945 53" autoselect="true" autoskip="true"/>
              <Static id="caption1" text="전표금액 :" class="search_name" position="absolute 756 34 847 51"/>
              <MaskEdit id="input3" taborder="17" mask="9,999999999999999" class="input_default" position="absolute 965 34 1065 53" autoselect="true" autoskip="true"/>
              <Static id="caption2" text="~" position="absolute 950 32 965 52"/>
              <Static id="caption22" text="전표구분 :" class="search_name" position="absolute 424 12 515 29"/>
              <Combo id="cmb_slipflag" taborder="18" innerdataset="@ds_init_R0008list_R0008" codecolumn="cdid" datacolumn="cdnm" class="combo_default" position="absolute 514 11 714 30"/>
              <Static id="caption9" text="작 성 자 :" class="search_name" position="absolute 16 34 107 51"/>
              <Edit id="ipt_name" taborder="20" class="input_default" position="absolute 209 34 405 53" onkeydown="group4_ipt_name_onkeydown"/>
              <Button id="btn_emplno" taborder="21" class="icon_search" position="absolute 189 36 205 52" onclick="group4_btn_emplno_onclick"/>
              <Edit id="ipt_emplno" taborder="22" class="input_default" position="absolute 105 34 185 53" onkeydown="group4_ipt_emplno_onkeydown"/>
              <Combo id="cmb_checkyn" taborder="23" codecolumn="codecolumn" datacolumn="datacolumn" visible="false" position="absolute 880 60 955 79">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn"/>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">Y</Col>
                      <Col id="datacolumn">확인</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">N</Col>
                      <Col id="datacolumn">미확인</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption11" text="전표적요 :" class="search_name" position="absolute 16 57 107 74"/>
              <Edit id="ipt_slipcmt" taborder="24" class="input_default" position="absolute 105 57 405 76"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line4" class="line_10" position="absolute 0 453 1193 459"/>
        <Static id="caption35" text="전표 목록" class="tit_2" position="absolute 0 117 118 138"/>
        <Static id="caption3" text="전표 세부 내역" class="tit_2" position="absolute 0 437 118 458"/>
        <Shape id="roundrect3" type="roundrectangle" class="roundrect_btnset" position="absolute 965 458 1195 756" anchor="right bottom"/>
        <Button id="btn_excel" taborder="4" text="세부내역 엑셀출력" class="btn7" position="absolute 831 434 958 453" anchor="right bottom" onclick="btn_excel_onclick"/>
        <Grid id="grd_excel" taborder="5" binddataset="ds_main_slipdetlspec" useinputpanel="false" visible="false" position="absolute 180 603 914 750">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="작성일자"/>
                <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="대변금액"/>
              </Band>
              <Band id="body">
                <Cell text="bind:unsldd"/>
                <Cell col="1" text="bind:unslno"/>
                <Cell col="2" text="bind:unslseqno"/>
                <Cell col="3" text="bind:acntcd"/>
                <Cell col="4" text="bind:acntnm"/>
                <Cell col="5" text="bind:custnm"/>
                <Cell col="6" text="bind:etcnotefact"/>
                <Cell col="7" text="bind:dramt" mask="(-)#,###"/>
                <Cell col="8" text="bind:cramt" mask="(-)#,###"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="button1" taborder="6" text="전체내역 엑셀출력" class="btn7" position="absolute 1066 434 1193 453" anchor="right bottom" onclick="button1_onclick"/>
        <Static id="caption10" text="※ 조회시 전표적요, 발의부서, 발의자를 입력할 경우, 자료가 누락된 결과를 보여줄 수 있음을 유의하십시요." position="absolute 0 758 586 778" anchor="left bottom" style="color:#ff0000ff;"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_hidden_condition" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_hidden_condition_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="slipfr" type="STRING" size="256"/>
          <Column id="slipto" type="STRING" size="256"/>
          <Column id="slipkind" type="STRING" size="256"/>
          <Column id="slipflag" type="STRING" size="256"/>
          <Column id="slipdeptcd" type="STRING" size="256"/>
          <Column id="slipdeptnm" type="STRING" size="256"/>
          <Column id="slipgubn" type="STRING" size="256"/>
          <Column id="framt" type="STRING" size="256"/>
          <Column id="toamt" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="emplnm" type="STRING" size="256"/>
          <Column id="ddkind" type="STRING" size="256"/>
          <Column id="checkyn" type="STRING" size="256"/>
          <Column id="slipcmt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="slipfr"/>
            <Col id="slipto"/>
            <Col id="slipkind"/>
            <Col id="slipflag"/>
            <Col id="slipdeptcd"/>
            <Col id="slipdeptnm"/>
            <Col id="slipgubn">%</Col>
            <Col id="framt"/>
            <Col id="toamt"/>
            <Col id="emplno"/>
            <Col id="emplnm"/>
            <Col id="ddkind"/>
            <Col id="checkyn"/>
            <Col id="slipcmt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_R0008list_R0008" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_slipkind" 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">1</Col>
          </Row>
          <Row>
            <Col id="label">입금</Col>
            <Col id="value">2</Col>
          </Row>
          <Row>
            <Col id="label">출금</Col>
            <Col id="value">3</Col>
          </Row>
          <Row>
            <Col id="label">지출대체</Col>
            <Col id="value">4</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_slipreflist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_slipreflist_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="unsldd" type="STRING" size="256" sumtext="발의일자"/>
          <Column id="unslno" type="STRING" size="256" sumtext="발의번호"/>
          <Column id="slipflag" type="STRING" size="256" sumtext="전표구분"/>
          <Column id="slipdeptnm" type="STRING" size="256" sumtext="발의부서명"/>
          <Column id="usernm" type="STRING" size="256" sumtext="발의자"/>
          <Column id="slipstatus" type="STRING" size="256" sumtext="전표상태"/>
          <Column id="slipdd" type="STRING" size="256" sumtext="승인일자"/>
          <Column id="slipno" type="STRING" size="256" sumtext="승인전표번호"/>
          <Column id="amt" type="STRING" size="256" sumtext="금액"/>
          <Column id="slipcmt" type="STRING" size="256" sumtext="전표적요"/>
          <Column id="slipkind" type="STRING" size="256" sumtext="전표유형"/>
          <Column id="slipdeptcd" type="STRING" size="256" sumtext="발의부서"/>
          <Column id="unslwrit" type="STRING" size="256" sumtext="발의자"/>
          <Column id="checkyn" type="STRING" size="256" sumtext="확인구분"/>
          <Column id="defrayreqdd" type="STRING" size="256" sumtext="기표일자"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_slipdetlspec" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="unslseqno" type="STRING" size="256" sumtext="발의일련번호"/>
          <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정과목"/>
          <Column id="custnm" type="STRING" size="256" sumtext="상대처명"/>
          <Column id="etcnotefact" type="STRING" size="256" sumtext="적요"/>
          <Column id="dramt" type="BIGDECIMAL" size="256" sumtext="차변금액"/>
          <Column id="cramt" type="BIGDECIMAL" size="256" sumtext="대변금액"/>
          <Column id="amt" type="BIGDECIMAL" size="256" sumtext="금액"/>
          <Column id="unsldd" type="STRING" size="256" sumtext="발의일자"/>
          <Column id="unslno" type="STRING" size="256" sumtext="발의번호"/>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="nmbojo1" type="STRING" size="256" sumtext="보조과목명"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_data3" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="mngtcd" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="mngtcd"/>
            <Col id="instcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_code_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256" sumtext="관리코드명"/>
          <Column id="cdnm" type="STRING" size="256" sumtext="비고"/>
          <Column id="cdgbn" type="STRING" size="256" sumtext="관리코드"/>
          <Column id="entrregno" type="STRING" size="256" sumtext="사업자등록번호"/>
          <Column id="custnm" type="STRING" size="256" sumtext="거래처명"/>
          <Column id="aactcd" type="STRING" size="256" sumtext="계좌코드"/>
          <Column id="aactno" type="STRING" size="256" sumtext="계좌번호"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_data1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="slipfr" type="STRING" size="256"/>
          <Column id="slipto" type="STRING" size="256"/>
          <Column id="slipkind" type="STRING" size="256"/>
          <Column id="slipflag" type="STRING" size="256"/>
          <Column id="slipdeptcd" type="STRING" size="256"/>
          <Column id="slipgubn" type="STRING" size="256"/>
          <Column id="framt" type="STRING" size="256"/>
          <Column id="toamt" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="ddkind" type="STRING" size="256"/>
          <Column id="checkyn" type="STRING" size="256"/>
          <Column id="slipcmt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="slipfr"/>
            <Col id="slipto"/>
            <Col id="slipkind"/>
            <Col id="slipflag"/>
            <Col id="slipdeptcd"/>
            <Col id="slipgubn"/>
            <Col id="framt"/>
            <Col id="toamt"/>
            <Col id="emplno"/>
            <Col id="ddkind"/>
            <Col id="checkyn"/>
            <Col id="slipcmt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_data2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="unsldd" type="STRING" size="256"/>
          <Column id="unslno" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="unsldd"/>
            <Col id="unslno"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group4.ipt_slipdeptcd" propid="value" datasetid="ds_hidden_condition" columnid="slipdeptcd"/>
      <BindItem id="item1" compid="group4.ipt_slipdeptnm" propid="value" datasetid="ds_hidden_condition" columnid="slipdeptnm"/>
      <BindItem id="item2" compid="group4.cmb_slipflag" propid="value" datasetid="ds_hidden_condition" columnid="slipflag"/>
      <BindItem id="item3" compid="group4.cmb_ddkind" propid="value" datasetid="ds_hidden_condition" columnid="ddkind"/>
      <BindItem id="item4" compid="group4.input6" propid="value" datasetid="ds_hidden_condition" columnid="slipfr"/>
      <BindItem id="item5" compid="group4.input2" propid="value" datasetid="ds_hidden_condition" columnid="slipto"/>
      <BindItem id="item6" compid="group4.input1" propid="value" datasetid="ds_hidden_condition" columnid="framt"/>
      <BindItem id="item7" compid="group4.input3" propid="value" datasetid="ds_hidden_condition" columnid="toamt"/>
      <BindItem id="item8" compid="group4.cmb_checkyn" propid="value" datasetid="ds_hidden_condition" columnid="checkyn"/>
      <BindItem id="item9" compid="group4.rdo_gubn" propid="value" datasetid="ds_hidden_condition" columnid="slipgubn"/>
      <BindItem id="item10" compid="group4.rdo_slipkind" propid="value" datasetid="ds_hidden_condition" columnid="slipkind"/>
      <BindItem id="item11" compid="group4.ipt_name" propid="value" datasetid="ds_hidden_condition" columnid="emplnm"/>
      <BindItem id="item12" compid="group4.ipt_emplno" propid="value" datasetid="ds_hidden_condition" columnid="emplno"/>
      <BindItem id="item13" compid="group4.ipt_slipcmt" propid="value" datasetid="ds_hidden_condition" columnid="slipcmt"/>
    </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";
include "mis_acntcommonxp::RAD001.xjs";
function SMRAD00210_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAD00210_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_slipreflist);
	grdf_initGrid(grd_slipdetlspec);
	
	fCheckAuth();
	fInitialize();	
}

var acntdept = ""; 
var bugtdept = ""; 
function fCheckAuth() 
{
	group4.btn_search.enable = frmf_checkAuth("R") ;	
}

function fInitialize() 
{
	var sToday = utlf_getCurrentDate().toString();
	var instcd = sysf_getUserInfo("dutplceinstcd");
	var deptcd = sysf_getUserInfo("dutplcecd");
	var deptnm = sysf_getUserInfo("dutplcenm");

	var arrParam = [{dsNm: "ds_init_R0008list_R0008", cdGrpId: "R0008"}]
    appf_getCodeList(arrParam); 
 
	ds_main_slipdetlspec.clearData();
	ds_main_slipreflist.clearData();
	
	ds_send_data3.setColumn(0, "instcd", instcd);
	ds_send_data3.setColumn(0, "mngtcd", "acntdept");
	
	var oParam = {};
		oParam.id          = "TRRAZ00001";
		oParam.service     = "acntcommonapp.AcntCommon";
		oParam.method      = "reqGetAcntMngtCodeList";
		oParam.inds        = "req=ds_send_data3";
		oParam.outds       = "ds_init_code_codelist=codelist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAZ00001";

	tranf_submit(oParam);
	
	acntdept = ds_init_code_codelist.getColumn(0, "cdid");
	
	ds_init_code_codelist.clearData();
	
	ds_send_data3.setColumn(0, "instcd", instcd);
	ds_send_data3.setColumn(0, "mngtcd", "bugtdept");
	
	var oParam = {};
		oParam.id          = "TRRAZ00001";
		oParam.service     = "acntcommonapp.AcntCommon";
		oParam.method      = "reqGetAcntMngtCodeList";
		oParam.inds        = "req=ds_send_data3";
		oParam.outds       = "ds_init_code_codelist=codelist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAZ00001";

	tranf_submit(oParam);
	
	bugtdept = ds_init_code_codelist.getColumn(0, "cdid");


	if(radfCheckInstMngt(sysf_getUserInfo("dutplceinstcd"), 'condition7') == "Y")
	{											
		misfComboComCdList("R0360", group4.rdo_slipkind, "Y");
	} 
	else
	{
		misfComboComCdList("R0359", group4.rdo_slipkind, "Y");
	}

	if (ds_init_code_codelist.rowcount != 0) 
	{
		if (!(deptcd == acntdept || deptcd == bugtdept)) 
		{
			group4.ipt_slipdeptnm.enable = false;
		}
	}
	
	ds_hidden_condition.setColumn(0, "slipfr", sToday);
	ds_hidden_condition.setColumn(0, "slipto", sToday);
	ds_hidden_condition.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_hidden_condition.setColumn(0, "ddkind", "wd");
	
	misfSetReadOnlyCol(grd_slipreflist, "checkyn", "true", "");
}

function group4_ipt_slipdeptcd_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		group4.btn_search.setFocus();
	}
}

function fValidationCheck(vgbn, recvlist, pcdgrupid, pNextIndex, pValueControl, pNodeName)
{
	misfValidationCheck(vgbn, pcdgrupid, recvlist, pValueControl, pNodeName);
	eval(pNextIndex).setFocus();
}

function ds_hidden_condition_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "slipdeptcd")
	{
		group4.ipt_slipdeptcd.value = e.newvalue;
		group4.ipt_slipdeptcd.setFocus();
		
		fValidationCheck("02", "slipdeptcd,slipdeptnm", "", "group4.btn_search");		
	}
	if(e.columnid == "slipdeptnm")
	{
		group4.ipt_slipdeptnm.value = e.newvalue;
		group4.ipt_slipdeptnm.setFocus();
		
		fValidationCheck("02", "slipdeptcd,slipdeptnm", "", "group4.btn_search");
	}
	if(e.columnid == "emplno")
	{
		group4.ipt_emplno.value = e.newvalue;
		group4.ipt_emplno.setFocus();
		
		rpbfValidationCheck("EMPLNO", "emplno,emplnm");
	}
	if(e.columnid == "emplnm")
	{
		group4.ipt_name.value = e.newvalue;
		group4.ipt_name.setFocus();
		
		rpbfValidationCheck("EMPLNM", "emplno,emplnm");
	}
}

function fOpenPopupHelp(pHelper, pControl, pInstance, pCdgrupid, pValueControl, pNodeName)
{
	misfOpenPopUpList(pHelper, pControl, pCdgrupid, pInstance, pValueControl, pNodeName);
}

function group4_btn_slipdeptcd_onclick(obj:Button,  e:ClickEventInfo)
{
	fOpenPopupHelp("02", group4.ipt_slipdeptcd, "slipdeptcd,slipdeptnm", "");
}

function group4_ipt_slipdeptnm_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		group4.btn_search.setFocus();
	}
}

function group4_ipt_emplno_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		group4.btn_search.setFocus();
	}
}

function group4_btn_emplno_onclick(obj:Button,  e:ClickEventInfo)
{
	rpbfOpenPopUpList("SPRPB00101", group4.ipt_emplno, "emplno,emplnm", "", "N");
}

function group4_ipt_name_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		group4.btn_search.setFocus();
	}
}

function group4_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_send_data1.setColumn(0, "instcd", ds_hidden_condition.getColumn(0, "instcd"));
	ds_send_data1.setColumn(0, "slipfr", ds_hidden_condition.getColumn(0, "slipfr"));
	ds_send_data1.setColumn(0, "slipto", ds_hidden_condition.getColumn(0, "slipto"));
	ds_send_data1.setColumn(0, "slipkind", ds_hidden_condition.getColumn(0, "slipkind"));
	ds_send_data1.setColumn(0, "slipflag", ds_hidden_condition.getColumn(0, "slipflag"));
	ds_send_data1.setColumn(0, "checkyn", ds_hidden_condition.getColumn(0, "checkyn"));
	ds_send_data1.setColumn(0, "slipdeptcd", ds_hidden_condition.getColumn(0, "slipdeptcd"));
	ds_send_data1.setColumn(0, "slipgubn", ds_hidden_condition.getColumn(0, "slipgubn"));
	ds_send_data1.setColumn(0, "framt", ds_hidden_condition.getColumn(0, "framt"));
	ds_send_data1.setColumn(0, "toamt", ds_hidden_condition.getColumn(0, "toamt"));
	ds_send_data1.setColumn(0, "ddkind", ds_hidden_condition.getColumn(0, "ddkind"));
	ds_send_data1.setColumn(0, "emplno", ds_hidden_condition.getColumn(0, "emplno"));
	ds_send_data1.setColumn(0, "slipcmt", ds_hidden_condition.getColumn(0, "slipcmt"));
	
	ds_main_slipdetlspec.clearData();
	
	var oParam = {};
		oParam.id          = "TRRAD00211";
		oParam.service     = "slipapp.Slip";
		oParam.method      = "reqGetSlipRefList";
		oParam.inds        = "req=ds_send_data1";
		oParam.outds       = "ds_main_slipreflist=slipreflist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAD00211";

	tranf_submit(oParam);
}

function grd_slipreflist_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	var cur_row = ds_main_slipreflist.rowposition;
						
	if ( cur_row > -1) 
	{
		ds_send_data2.setColumn(0, "instcd", ds_main_slipreflist.getColumn(cur_row, "instcd"));
		ds_send_data2.setColumn(0, "unsldd", ds_main_slipreflist.getColumn(cur_row, "unsldd"));
		ds_send_data2.setColumn(0, "unslno", ds_main_slipreflist.getColumn(cur_row, "unslno"));
		
		var oParam = {};
			oParam.id          = "TRRAD00212";
			oParam.service     = "slipapp.Slip";
			oParam.method      = "reqGetSlipDetlSpec";
			oParam.inds        = "req=ds_send_data2";
			oParam.outds       = "ds_main_slipdetlspec=slipdetlspec";
			oParam.async       = false;
			//oParam.callback    = "cf_TRRAD00212";

		tranf_submit(oParam);
	}
}

function ds_main_slipreflist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "checkyn")
	{
		obj.setColumn(e.row, "checkyn", (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "N");
	}
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	misfSaveExcel(grd_excel);
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	radfSaveExcel(grd_slipreflist);
}
]]></Script>
  </Form>
</FDL>