YNU_JEUS/app_home/himed/xpapps/mis/acntknuhxp/xp/SMRAH02800_진료과정산비등록.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAH02800" position="absolute 0 0 1199 782" titletext="정산비등록(의국)" oninit="SMRAH02800_oninit" onload="SMRAH02800_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="정산비등록(의국)" class="tit_1" position="absolute 0 0 293 25"/>
        <Button id="button3" taborder="1" text="출력" class="btn6" position="absolute 1078 25 1134 47" onclick="button3_onclick" anchor="top right"/>
        <Button id="btn_save" taborder="2" text="저장" class="btn4" position="absolute 1136 25 1192 47" onclick="btn_save_onclick" anchor="top right"/>
        <Shape id="line2" class="line_6" position="absolute 0 46 1194 52" anchor="left top right"/>
        <Div id="grp_sea" taborder="3" class="div_SA2" position="absolute 0 50 1195 130" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption7" text="년도 및 월 :" class="search_name" position="absolute 16 6 125 23"/>
              <Shape id="line30" linetype="vertical" class="line_4" position="absolute 1071 3 1077 28" anchor="top right"/>
              <Button id="btn_search" taborder="1" text="조회" class="btn1" position="absolute 1091 5 1147 27" onclick="grp_sea_btn_search_onclick" anchor="top right"/>
              <Edit id="input1" taborder="2" position="absolute 119 5 190 24" autoselect="true" autoskip="true" onkeydown="grp_sea_input1_onkeydown"/>
              <Combo id="cmb_dateflag" taborder="3" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_default" position="absolute 194 5 244 24" onitemchanged="grp_sea_cmb_dateflag_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">01</Col>
                      <Col id="datacolumn">01</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">02</Col>
                      <Col id="datacolumn">02</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">03</Col>
                      <Col id="datacolumn">03</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">04</Col>
                      <Col id="datacolumn">04</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">05</Col>
                      <Col id="datacolumn">05</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">06</Col>
                      <Col id="datacolumn">06</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">07</Col>
                      <Col id="datacolumn">07</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">08</Col>
                      <Col id="datacolumn">08</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">09</Col>
                      <Col id="datacolumn">09</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">10</Col>
                      <Col id="datacolumn">10</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">11</Col>
                      <Col id="datacolumn">11</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">12</Col>
                      <Col id="datacolumn">12</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption3" text="정산구분 :" class="search_name" position="absolute 300 6 395 23"/>
              <Combo id="combo1" taborder="4" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_default" enable="false" position="absolute 390 5 525 24">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">부서경비</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">특정업무비</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption5" text="정산부서 :" class="search_name" position="absolute 560 6 655 23"/>
              <Combo id="combo2" taborder="5" innerdataset="@ds_init_deptinfo_deptlist" codecolumn="deptcd" datacolumn="deptnm" class="combo_default" position="absolute 650 5 840 24" onitemchanged="grp_sea_combo2_onitemchanged"/>
              <Combo id="combo3" taborder="6" innerdataset="@ds_init_emplnoinfo_emplnolist" codecolumn="emplno" datacolumn="emplnm" class="combo_default" enable="false" position="absolute 933 5 1045 24" onitemchanged="grp_sea_combo3_onitemchanged"/>
              <Static id="caption8" text="정산자 :" class="search_name" position="absolute 855 6 930 23"/>
              <Static id="caption9" text="월사용가능액 :" class="search_name" position="absolute 16 31 133 48"/>
              <Static id="caption10" text="년사용가능누계 :" class="search_name" position="absolute 16 56 159 73"/>
              <MaskEdit id="input3" taborder="7" mask="(-)#,###" enable="false" position="absolute 145 55 275 74"/>
              <Static id="caption11" text="년정산누계 :" class="search_name" position="absolute 300 56 400 73"/>
              <MaskEdit id="input4" taborder="8" mask="(-)#,###" enable="false" position="absolute 405 30 535 49"/>
              <MaskEdit id="input5" taborder="9" mask="(-)#,###" enable="false" position="absolute 405 56 535 75"/>
              <Static id="caption12" text="월정산금액 :" class="search_name" position="absolute 300 31 400 48"/>
              <Static id="caption13" text="년지급액누계 :" class="search_name" position="absolute 560 56 675 73"/>
              <Static id="caption14" text="당월지급금액 :" class="search_name" position="absolute 560 31 677 48"/>
              <MaskEdit id="input6" taborder="10" mask="(-)#,###" enable="false" position="absolute 675 30 805 49"/>
              <MaskEdit id="input7" taborder="11" mask="(-)#,###" enable="false" position="absolute 675 56 805 75"/>
              <Static id="caption15" text="최종저장 :" class="search_name" position="absolute 855 56 950 73"/>
              <CheckBox id="bool1" taborder="12" position="absolute 936 53 961 73" truevalue="Y" falsevalue="N"/>
              <Static id="caption2" text="직전월 년지급액누계 :" class="search_name" position="absolute 855 32 1015 49"/>
              <MaskEdit id="input8" taborder="13" mask="(-)#,###" enable="false" position="absolute 1020 31 1150 50"/>
              <MaskEdit id="output1" taborder="14" readonly="true" mask="(-)#,###" position="absolute 145 30 275 49"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line1" class="line_10" position="absolute 0 180 1195 186" anchor="left top right"/>
        <Button id="button1" taborder="4" text="행추가" class="btn2" position="absolute 1087 161 1140 180" onclick="button1_onclick" anchor="top right"/>
        <Button id="button2" taborder="5" text="행삭제" class="btn2" position="absolute 1141 161 1194 180" onclick="button2_onclick" anchor="top right"/>
        <Static id="caption1" text="정산비등록" class="tit_2" position="absolute 0 164 121 186"/>
        <Grid id="grd_acntinoutlist" taborder="6" binddataset="ds_main_datalist_jungsan" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 185 1194 775" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="26"/>
                <Column size="38"/>
                <Column size="37"/>
                <Column size="108"/>
                <Column size="75"/>
                <Column size="40"/>
                <Column size="164"/>
                <Column size="361"/>
                <Column size="126"/>
                <Column size="205"/>
                <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/>
                <Cell col="1" text="NO"/>
                <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="caption1"/>
                <Cell col="11" text="caption2"/>
                <Cell col="12" text="caption3"/>
                <Cell col="13" text="caption4"/>
                <Cell col="14" text="caption5"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:seq2"/>
                <Cell col="2" text="bind:seq"/>
                <Cell col="3" displaytype="date" edittype="date" text="bind:baldate" calendardisplaynulltype="nulltext"/>
                <Cell col="4" displaytype="text" edittype="text" style="align:center middle;" text="bind:baltime" mask="##:##" maskchar=" "/>
                <Cell col="5" text="bind:day"/>
                <Cell col="6" displaytype="combo" edittype="combo" text="bind:youngdo" combodataset="ds_cmb_youngdo" combocodecol="value" combodatacol="label"/>
                <Cell col="7" displaytype="text" edittype="text" text="bind:kdesc"/>
                <Cell col="8" displaytype="number" edittype="normal" text="bind:amt"/>
                <Cell col="9" displaytype="combo" edittype="combo" text="bind:jeungbing" combodataset="ds_cmb_jeungbing" combocodecol="value" combodatacol="label"/>
                <Cell col="10" text="bind:year"/>
                <Cell col="11" text="bind:mm"/>
                <Cell col="12" text="bind:buseocode"/>
                <Cell col="13" text="bind:sabun"/>
                <Cell col="14" text="bind:gubun"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excelinput" taborder="7" text="엑셀입력" class="btn7" position="absolute 1006 161 1086 180" onclick="btn_excelinput_onclick" anchor="top right"/>
        <Button id="btn_excelsave" taborder="8" text="엑셀샘플" class="btn7" position="absolute 925 161 1005 180" onclick="btn_excelsave_onclick" anchor="top right"/>
        <Grid id="datagrid1" taborder="9" binddataset="ds_sampledata" useinputpanel="false" visible="false" position="absolute 370 290 860 380">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="23"/>
                <Column size="38"/>
                <Column size="37"/>
                <Column size="160"/>
                <Column size="71"/>
                <Column size="113"/>
                <Column size="167"/>
                <Column size="361"/>
                <Column size="150"/>
                <Column size="205"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="NO"/>
                <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="증빙유형"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:seq2"/>
                <Cell col="2" text="bind:seq"/>
                <Cell col="3" text="bind:baldate"/>
                <Cell col="4" text="bind:baltime"/>
                <Cell col="5" text="bind:day"/>
                <Cell col="6" displaytype="combo" edittype="combo" text="bind:youngdo"/>
                <Cell col="7" displaytype="text" edittype="text" text="bind:kdesc"/>
                <Cell col="8" displaytype="number" edittype="normal" text="bind:amt"/>
                <Cell col="9" displaytype="combo" edittype="combo" text="bind:jeungbing"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_dedu" taborder="10" text="직원인건비내역등록" class="btn2" position="absolute 797 161 924 180" onclick="btn_dedu_onclick" anchor="top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_retrparam" 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="yyyy" type="STRING" size="256"/>
          <Column id="mm" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="buseocode" type="STRING" size="256"/>
          <Column id="sabun" type="STRING" size="256"/>
          <Column id="depthngnm" type="STRING" size="256"/>
          <Column id="oksign" type="STRING" size="256"/>
          <Column id="userid" type="STRING" size="256"/>
          <Column id="poweryn" type="STRING" size="256"/>
          <Column id="sanyn" type="STRING" size="256"/>
          <Column id="srchsabun" type="STRING" size="256"/>
          <Column id="buseoname" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="yyyy"/>
            <Col id="mm"/>
            <Col id="gubun"/>
            <Col id="buseocode"/>
            <Col id="sabun"/>
            <Col id="depthngnm"/>
            <Col id="oksign"/>
            <Col id="userid"/>
            <Col id="poweryn"/>
            <Col id="sanyn"/>
            <Col id="srchsabun"/>
            <Col id="buseoname"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_datalist_jungsan" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_datalist_jungsan_oncolumnchanged">
        <ColumnInfo>
          <Column id="seq" type="STRING" size="256" sumtext="순번"/>
          <Column id="seq2" type="STRING" size="256" sumtext="순번"/>
          <Column id="baldate" type="STRING" size="256" sumtext="발생일자"/>
          <Column id="baltime" type="STRING" size="256" sumtext="발생시각"/>
          <Column id="youngdo" type="STRING" size="256" sumtext="용도"/>
          <Column id="kdesc" type="STRING" size="256" sumtext="지출내역"/>
          <Column id="amt" type="STRING" size="256" sumtext="금액"/>
          <Column id="jeungbing" type="STRING" size="256" sumtext="증빙유형"/>
          <Column id="year" type="STRING" size="256" sumtext="년도"/>
          <Column id="mm" type="STRING" size="256" sumtext="분기"/>
          <Column id="buseocode" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="sabun" type="STRING" size="256" sumtext="사번"/>
          <Column id="gubun" type="STRING" size="256" sumtext="구분"/>
          <Column id="day" type="STRING" size="256" sumtext="요일"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_sampledata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="baldate" type="STRING" size="256"/>
          <Column id="baltime" type="STRING" size="256"/>
          <Column id="day" type="STRING" size="256"/>
          <Column id="kdesc" type="STRING" size="256"/>
          <Column id="youngdo" type="STRING" size="256"/>
          <Column id="jeungbing" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_datalist_amtinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="ableamt" type="STRING" size="256"/>
          <Column id="ablesum" type="STRING" size="256"/>
          <Column id="useamt" type="STRING" size="256"/>
          <Column id="usesum" type="STRING" size="256"/>
          <Column id="payamt" type="STRING" size="256"/>
          <Column id="paysum" type="STRING" size="256"/>
          <Column id="prevpaysum" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="ableamt"/>
            <Col id="ablesum"/>
            <Col id="useamt"/>
            <Col id="usesum"/>
            <Col id="payamt"/>
            <Col id="paysum"/>
            <Col id="prevpaysum"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_datalist_managerinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="year" type="STRING" size="256" sumtext="년도"/>
          <Column id="mm" type="STRING" size="256" sumtext="월"/>
          <Column id="seqno" type="STRING" size="256" sumtext="순번"/>
          <Column id="gubun" type="STRING" size="256" sumtext="구분"/>
          <Column id="buseocode" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="sabun" type="STRING" size="256" sumtext="사번"/>
          <Column id="oksign" type="STRING" size="256" sumtext="승인여부"/>
          <Column id="m" type="STRING" size="256" sumtext="수정구분"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_deptinfo_deptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_emplnoinfo_emplnolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="emplnm" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_youngdo" 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">1.인건비</Col>
            <Col id="value">1</Col>
          </Row>
          <Row>
            <Col id="label">2.초빙강사료</Col>
            <Col id="value">2</Col>
          </Row>
          <Row>
            <Col id="label">3.회의및행사비</Col>
            <Col id="value">3</Col>
          </Row>
          <Row>
            <Col id="label">4.학회참가경비</Col>
            <Col id="value">4</Col>
          </Row>
          <Row>
            <Col id="label">5.도서인쇄비</Col>
            <Col id="value">5</Col>
          </Row>
          <Row>
            <Col id="label">6.소모품비</Col>
            <Col id="value">6</Col>
          </Row>
          <Row>
            <Col id="label">7.경조사비</Col>
            <Col id="value">7</Col>
          </Row>
          <Row>
            <Col id="label">8.우편통신비</Col>
            <Col id="value">8</Col>
          </Row>
          <Row>
            <Col id="label">9.자산구입비</Col>
            <Col id="value">9</Col>
          </Row>
          <Row>
            <Col id="label">X.기타</Col>
            <Col id="value">X</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_jeungbing" 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">1.세금계산서</Col>
            <Col id="value">1</Col>
          </Row>
          <Row>
            <Col id="label">2.계산서</Col>
            <Col id="value">2</Col>
          </Row>
          <Row>
            <Col id="label">3.인건비영수증</Col>
            <Col id="value">3</Col>
          </Row>
          <Row>
            <Col id="label">4.자산등록요청서</Col>
            <Col id="value">4</Col>
          </Row>
          <Row>
            <Col id="label">5.부서법인카드</Col>
            <Col id="value">5</Col>
          </Row>
          <Row>
            <Col id="label">6.현금영수증</Col>
            <Col id="value">6</Col>
          </Row>
          <Row>
            <Col id="label">7.원천징수영수증</Col>
            <Col id="value">7</Col>
          </Row>
          <Row>
            <Col id="label">X.기타</Col>
            <Col id="value">X</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp_jungsanjayn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="sanyn" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_sanynlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="sanyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_powerlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="poweryn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp_powerinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="poweryn" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_datalist_prntinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="amt1" type="STRING" size="256" sumtext="년도"/>
          <Column id="amt2" type="STRING" size="256" sumtext="분기"/>
          <Column id="amt3" type="STRING" size="256" sumtext="순번"/>
          <Column id="amt4" type="STRING" size="256" sumtext="순번"/>
          <Column id="serial" type="STRING" size="256" sumtext="순번"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_datalist_textinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="text" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main2_managerinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.input1" propid="value" datasetid="ds_send_retrparam" columnid="yyyy"/>
      <BindItem id="item1" compid="grp_sea.cmb_dateflag" propid="value" datasetid="ds_send_retrparam" columnid="mm"/>
      <BindItem id="item2" compid="grp_sea.combo1" propid="value" datasetid="ds_send_retrparam" columnid="gubun"/>
      <BindItem id="item3" compid="grp_sea.combo2" propid="value" datasetid="ds_send_retrparam" columnid="buseocode"/>
      <BindItem id="item4" compid="grp_sea.combo3" propid="value" datasetid="ds_send_retrparam" columnid="sabun"/>
      <BindItem id="item5" compid="grp_sea.output1" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="ableamt"/>
      <BindItem id="item6" compid="grp_sea.input4" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="useamt"/>
      <BindItem id="item7" compid="grp_sea.input8" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="prevpaysum"/>
      <BindItem id="item8" compid="grp_sea.input6" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="payamt"/>
      <BindItem id="item9" compid="grp_sea.input7" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="paysum"/>
      <BindItem id="item10" compid="grp_sea.bool1" propid="value" datasetid="ds_main_datalist_managerinfo" columnid="oksign"/>
      <BindItem id="item11" compid="grp_sea.input5" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="usesum"/>
      <BindItem id="item12" compid="grp_sea.input3" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="ablesum"/>
    </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";
function SMRAH02800_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAH02800_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_acntinoutlist);
	grdf_setRowTypeIcon(grd_acntinoutlist, 0);
	
	fResetForm();
}

function fResetForm()
{
	dsf_makeValue(ds_send_retrparam, "opener", "string", "SMRAH02800", 0);
	frmf_modal("SMRAH01800", "SMRAH01800", "", "", "", "", "", "", "", "", "", "", "M");
	
	ds_send_retrparam.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_send_retrparam.setColumn(0, "yyyy", String(utlf_getCurrentDate()).substr(0,4));
	ds_send_retrparam.setColumn(0, "mm", String(utlf_getCurrentDate()).substr(4,2));
	
	var oParam = {};
		oParam.id          = "TRRAH01203";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetEmplnoList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_init_emplnoinfo_emplnolist=emplnolist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH01203";

	tranf_submit(oParam);
	
	var Emplno = sysf_getUserInfo("userid");
	var Deptcd = sysf_getUserInfo("dutplcecd");
	
	ds_send_retrparam.setColumn(0, "userid", Emplno);
	ds_send_retrparam.setColumn(0, "sabun", Emplno);
	ds_send_retrparam.setColumn(0, "buseocode", Deptcd);
	ds_send_retrparam.setColumn(0, "gubun", "1");

	var oParam = {};
		oParam.id          = "TRRAH01302";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetSanjaynList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_temp_jungsanjayn=jungsanjayn";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH01302";

	tranf_submit(oParam);
	
	ds_sanynlist.setColumn(0, "sanyn", ds_temp_jungsanjayn.getColumn(0, "sanyn"));
	ds_send_retrparam.setColumn(0, "sanyn", ds_temp_jungsanjayn.getColumn(0, "sanyn"));
	
	var oParam = {};
		oParam.id          = "TRRAH01304";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetSanjaPowerList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_temp_powerinfo=powerinfo";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH01304";

	tranf_submit(oParam);		
	
	ds_powerlist.setColumn(0, "poweryn", ds_temp_powerinfo.getColumn(0, "poweryn"));
	ds_send_retrparam.setColumn(0, "poweryn", ds_temp_powerinfo.getColumn(0, "poweryn"));
	
	var oParam = {};
		oParam.id          = "TRRAH02803";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetSanjaMmdeptList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_init_deptinfo_deptlist=deptlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH02803";

	tranf_submit(oParam);
	
	var poweryn = ds_powerlist.getColumn(0, "poweryn");
	var oksign = ds_main_datalist_managerinfo.getColumn(0, "oksign");
	
	var sanyn = ds_sanynlist.getColumn(0, "sanyn");
	
	if(sanyn == "Y")
	{
		ds_powerlist.setColumn(0, "poweryn", "Y");
		ds_send_retrparam.setColumn(0, "poweryn", "Y");
	}
	if(oksign != "Y")
	{
		if(poweryn == "Y")
		{
			grp_sea.bool1.enable = true;
		}
		else if (sanyn == "Y")
		{		  
			grp_sea.bool1.enable = true;
		}
		else
		{
			grp_sea.bool1.enable = false;
		}
	}
	else
	{
		grp_sea.bool1.enable = false;
		
		//model.getValue("/root/main/datalist/jungsan").disabled = true;   //????
	}

	ds_send_retrparam.setColumn(0, "sabun", "00000");
	
	if(ds_init_deptinfo_deptlist.rowcount == 0)
	{
		ds_send_retrparam.setColumn(0, "buseocode", "");
	}
	else 
	{
		grp_sea.combo2.index = 0;
	}	

	fRetrieve();
}

function fRetrieve()
{
	ds_main_datalist_amtinfo.clearData();
	ds_main_datalist_jungsan.clearData();
	ds_main_datalist_managerinfo.clearData();
	
	var oParam = {};
		oParam.id          = "TRRAH02801";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetJungSanMmList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_main_datalist_jungsan=jungsan ds_main_datalist_amtinfo=amtinfo ds_main_datalist_managerinfo=managerinfo ds_main_datalist_prntinfo=prntinfo ds_main_datalist_textinfo=textinfo";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH02801";

	tranf_submit(oParam);

	ds_main2_managerinfo.copyData(ds_main_datalist_managerinfo);
	
	var oksign = ds_main_datalist_managerinfo.getColumn(0, "oksign");
	
	if(oksign == "Y")
	{
		grp_sea.bool1.enable = false;
		button1.enable = false;
		button2.enable = false;
		btn_save.enable = false;
		
		grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "baldate"), "edittype", "none");
		grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "youngdo"), "edittype", "none");
		grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "kdesc"), "edittype", "none");
		grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "amt"), "edittype", "none");
		grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "jeungbing"), "edittype", "none");
	}
	else
	{
		grp_sea.bool1.enable = true;
		button1.enable = true;
		button2.enable = true;
		btn_save.enable = true;
		
		grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "baldate"), "edittype", "date");
		grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "youngdo"), "edittype", "combo");
		grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "kdesc"), "edittype", "text");
		grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "amt"), "edittype", "normal");
		grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "jeungbing"), "edittype", "combo");
	}
}

function grp_sea_input1_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		grp_sea.cmb_dateflag.setFocus();
		
		grp_sea.btn_search.click();
	}
}

function grp_sea_cmb_dateflag_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	grp_sea.btn_search.click();
	grp_sea.combo1.setFocus();
}

function grp_sea_combo2_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	grp_sea.btn_search.click();
	grp_sea.combo3.setFocus();
}

function grp_sea_combo3_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	misfGridInit(grd_acntinoutlist);
	grp_sea.btn_search.click();
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fRetrieve();
}

function ds_main_datalist_jungsan_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "baldate")
	{
		var sDate = obj.getColumn(e.row, "baldate");
		
		if (String(sDate).length < 8) 
		{
			obj.setColumn(e.row, "day", "");
		} 
		else 
		{
			obj.setColumn(e.row, "day", getDateTime(sDate.toDate(), "W"));
		}
	}	
}

function btn_dedu_onclick(obj:Button,  e:ClickEventInfo)
{
	if (grp_sea.combo1.value != "1") 
	{
		sysf_messageBox("부서경비의 경우에만 직원인건비 내역 등록이 가능합니다. ", "E000");
		return;
	}							

	if (utlf_isNull(grp_sea.combo2.text))
	{
		sysf_messageBox("정산부서가 선택되지 않았습니다. ", "E000");
		return;
	}	
	
	dsf_makeValue(ds_send_retrparam, "buseoname", "string", grp_sea.combo2.text, 0);
	dsf_makeValue(ds_send_retrparam, "opener", "string", "SMRAH02800", 0);
	frmf_modal("SMRAH02900", "SMRAH02900", "", "", "", "", "", "", "", "", "", "", "M");
}

function btn_excelsave_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridInit(datagrid1);
						
	var addRow = ds_sampledata.addRow();
	
	ds_sampledata.setColumn(addRow, "baldate", "20170301");
	ds_sampledata.setColumn(addRow, "baltime", "1630");
	ds_sampledata.setColumn(addRow, "day", "입력 불필요");
	ds_sampledata.setColumn(addRow, "kdesc", "NO,순번은 순서대로 입력해 주세오.예)1,2,3");
	ds_sampledata.setColumn(addRow, "youngdo", "코드로 입력");
	ds_sampledata.setColumn(addRow, "jeungbing", "코드로 입력");	
	
	grdf_exportExcel(datagrid1, "정산비등록_Sample", "정산비등록_Sample", false, "", "user", false);
}

function btn_excelinput_onclick(obj:Button,  e:ClickEventInfo)
{
	if(utlf_isNull(ds_main_datalist_amtinfo.getColumn(0, "ableamt"))) 
	{
		sysf_messageBox("월사용가능액이 존재하지 않습니다. \n정산년월을 확인하십시요. ", "E999", "");
		return;
	}	

	sysf_messageBox("엑셀입력을 하실 때 꼭 샘플양식에 맞게 입력해주세요.","I999", "");
		
	grdf_ImportExcel("ds_main_datalist_jungsan", 2, grd_acntinoutlist)
	
	ds_main_datalist_jungsan.updatecontrol = false;
	for(var i = 0; i < ds_main_datalist_jungsan.rowcount; i++)
	{
		ds_main_datalist_jungsan.setColumn(i, "gubun", "0");
	
		ds_main_datalist_jungsan.setRowType(i, "i");
		
		ds_main_datalist_jungsan.setColumn(i, "year", ds_send_retrparam.getColumn(0, "yyyy"));
		ds_main_datalist_jungsan.setColumn(i, "bungi", ds_send_retrparam.getColumn(0, "quarter"));
		ds_main_datalist_jungsan.setColumn(i, "buseocode", ds_send_retrparam.getColumn(0, "buseocode"));
		ds_main_datalist_jungsan.setColumn(i, "sabun", ds_send_retrparam.getColumn(0, "sabun"));
		ds_main_datalist_jungsan.setColumn(i, "gubun", ds_send_retrparam.getColumn(0, "gubun"));
		
		var sDate = ds_main_datalist_jungsan.getColumn(i, "baldate");
		
		if (String(sDate).length < 8) 
		{
			ds_main_datalist_jungsan.setColumn(i, "day", "");
		}
		else 
		{
			ds_main_datalist_jungsan.setColumn(i, "day",  getDateTime(sDate.toDate(), "W"));
		}
	}
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	if(utlf_isNull(ds_main_datalist_amtinfo.getColumn(0, "ableamt")))
	{
		sysf_messageBox("월사용가능액이 존재하지 않습니다. \n정산년월을 확인하십시요. ", "E999", "");
		grp_sea.cmb_dateflag.setFocus();
		return;
	}
	
	var addRow = ds_main_datalist_jungsan.addRow();
	
	ds_main_datalist_jungsan.setColumn(addRow, "baldate", utlf_getCurrentDate());
	ds_main_datalist_jungsan.setColumn(addRow, "baltime", "0000");
	
	ds_main_datalist_jungsan.setColumn(addRow, "year", ds_send_retrparam.getColumn(0, "yyyy"));
	ds_main_datalist_jungsan.setColumn(addRow, "bungi", ds_send_retrparam.getColumn(0, "quarter"));
	ds_main_datalist_jungsan.setColumn(addRow, "buseocode", ds_send_retrparam.getColumn(0, "buseocode"));
	ds_main_datalist_jungsan.setColumn(addRow, "sabun", ds_send_retrparam.getColumn(0, "sabun"));
	ds_main_datalist_jungsan.setColumn(addRow, "gubun", ds_send_retrparam.getColumn(0, "gubun"));
	
	if(ds_main_datalist_jungsan.rowposition == 0)
	{
		ds_main_datalist_jungsan.setColumn(0, "seq", "1");
		ds_main_datalist_jungsan.setColumn(0, "seq2", "1");
	}
	else
	{
		ds_main_datalist_jungsan.setColumn(ds_main_datalist_jungsan.rowposition, "seq2", parseInt(ds_main_datalist_jungsan.getColumn(ds_main_datalist_jungsan.rowposition-1, "seq2"))+1);
		
		var ll_seq_max = 0;
		var ll_seq = 0;
		
		for(var i = 0; i < ds_main_datalist_jungsan.rowcount; i++)
		{
			ll_seq = parseInt(ds_main_datalist_jungsan.getColumn(i, "seq"));
			
			if (ll_seq > ll_seq_max) 
			{
				ll_seq_max = ll_seq ; 
			}		
		}
		ds_main_datalist_jungsan.setColumn(ds_main_datalist_jungsan.rowposition, "seq", ll_seq_max + 1);
	}

	var sDate = ds_main_datalist_jungsan.getColumn(ds_main_datalist_jungsan.rowposition, "baldate");
	
	if (String(sDate).length < 8) 
	{
		ds_main_datalist_jungsan.setColumn(ds_main_datalist_jungsan.rowposition, "day", "");
	} 
	else 
	{
		ds_main_datalist_jungsan.setColumn(ds_main_datalist_jungsan.rowposition, "day", getDateTime(sDate.toDate(), "W"));
	}
}

function button2_onclick(obj:Button,  e:ClickEventInfo)
{
	var status = ds_main_datalist_jungsan.getRowType(ds_main_datalist_jungsan.rowposition);
	
	if(status == 1)
	{
		ds_main_datalist_jungsan.updatecontrol = false;
		ds_main_datalist_jungsan.setRowType(ds_main_datalist_jungsan.rowposition, "d");
		ds_main_datalist_jungsan.updatecontrol = true;
	}
	else if(status == 2) 
	{
		ds_main_datalist_jungsan.deleteRow(ds_main_datalist_jungsan.rowposition);
	}
	else if(status == 4) 
	{
		ds_main_datalist_jungsan.updatecontrol = false;
		ds_main_datalist_jungsan.setRowType(ds_main_datalist_jungsan.rowposition, "d");
		ds_main_datalist_jungsan.updatecontrol = true;
	}
	else if(status == 8) 
	{
		ds_main_datalist_jungsan.updatecontrol = false;
		ds_main_datalist_jungsan.setRowType(ds_main_datalist_jungsan.rowposition, "d");
		ds_main_datalist_jungsan.updatecontrol = true;
	}			
}

function button3_onclick(obj:Button,  e:ClickEventInfo)
{
	dsf_makeValue(ds_send_retrparam, "deptnm", "string", grp_sea.combo2.text, 0);
	dsf_makeValue(ds_send_retrparam, "emplnm", "string", grp_sea.combo3.text, 0);
	
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/main/datalist/jungsan", ds_main_datalist_jungsan);
		rptf_setNodeListToDOM(objDOM, "/root/main/datalist/prntinfo", ds_main_datalist_prntinfo);
		rptf_setNodeListToDOM(objDOM, "/root/main/datalist/textinfo", ds_main_datalist_textinfo);
		rptf_setNodeListToDOM(objDOM, "/root/send/retrparam", ds_send_retrparam);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
	var option = ""; 
	rptf_exeReportPreview30(["SMRAH02801"],[objParam], option);
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	var cnt = ds_main_datalist_jungsan.rowcount;
	
	for( var i = 0 ; i < cnt ; i++)
	{
		if(utlf_isNull(ds_main_datalist_jungsan.getColumn(i, "youngdo")))
		{
			sysf_messageBox("[ " + i+1 + " ]번째 행의 계정구분값이 누락되었습니다. \n계정구분값은 필수 입력값입니다. ", "E000");
			return;
		} 
		
		if(utlf_isNull(ds_main_datalist_jungsan.getColumn(i, "jeungbing")))
		{
			sysf_messageBox("[ " + i+1 + " ]번째 행의 증빙유형값이 누락되었습니다. \n증빙유형값은 필수 입력값입니다. ", "E000");
			return;							
		} 							
	}
	
	fSaveData();	
}

function fSaveData()
{
	var updtdata = grdf_getGridUpdateData(grd_acntinoutlist).rowcount;		
	var copydata = ds_main2_managerinfo.getColumn(0, "oksign");
	var data = ds_main_datalist_managerinfo.getColumn(0, "oksign");
	
	if (updtdata == 0 && data == copydata)
	{
		sysf_messageBox("변경된 데이터가","I004");
		return;
	}
	for(var i = 0; i < ds_main_datalist_jungsan.rowcount; i++)
	{
		if(ds_main_datalist_jungsan.getRowType(i) == 8)
		{
			return;
		}
		
		var baldate = String(ds_main_datalist_jungsan.getColumn(i, "baldate")).substr(4,2);
		var balyear = String(ds_main_datalist_jungsan.getColumn(i, "baldate")).substr(0,4);
		var yyyy = ds_send_retrparam.getColumn(0, "yyyy");
		
		var quarter = grp_sea.cmb_dateflag.value;
		
		if(yyyy != balyear)
		{
			sysf_messageBox("[ " + i+1 + " ]번째 행의 발생일자가 적합하지 않습니다.", "I000");
			return;
		}
		if(mm != baldate)
		{
			sysf_messageBox("[ " + i+1 + " ]번째 행의 발생일자가 적합하지 않습니다.", "I000");
			return;
		}
		
		var baltime= ds_main_datalist_jungsan.getColumn(i, "baltime");
		if(String(baltime).length != 4)
		{
			sysf_messageBox("[ " + i+1 + " ]번째 행의 발생시각이 적합하지 않습니다.", "I000");
			return;
		}												
		
		var amt = ds_main_datalist_jungsan.getColumn(i, "amt");
		if( utlf_isNull(amt))
		{
			sysf_messageBox("[ " + i+1 + " ]번째 행의 금액이 누락되었습니다. \n금액은 필수 입력값입니다. ", "E000");
			return;							
		}						
	}
	if( sysf_messageBox("정산 내역을", "Q002")  != 6 ) 
	{
		return ;
	}
								
	var seq_no = ds_main_datalist_managerinfo.getColumn(0, "seqno");
	
	if(utlf_isNull(seq_no))
	{
		ds_main_datalist_managerinfo.setColumn(0, "seqno", "1");
	}

	ds_main_datalist_managerinfo.setColumn(0, "bungi", ds_send_retrparam.getColumn(0, "quarter"));
	
	var oParam = {};
		oParam.id          = "TXRAH02801";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqExeSaveJungSanMmList";
		oParam.inds        = "req=ds_main_datalist_jungsan:u req2=ds_main_datalist_managerinfo:u";
		oParam.outds       = "ds_=seqno";
		oParam.typeStr     = "m";
		oParam.async       = false;
		oParam.callback    = "cf_TXRAH02801";

	tranf_submit(oParam);
}

function cf_TXRAH02801(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		fRetrieve();
	}
}]]></Script>
  </Form>
</FDL>