YNU_JEUS/app_home/himed/xpapps/mis/acntknuhxp/xp/SMRAH04800_QI활동비정산비등록(관리부서용).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAH04800" position="absolute 0 0 1199 759" titletext="QI활동비 정산비등록(관리부서용)" oninit="SMRAH04800_oninit" onload="SMRAH04800_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="QI활동비 정산비등록(관리부서용)" class="tit_1" position="absolute 0 0 293 25"/>
        <Div id="grp_sea" anchor="left top right" taborder="1" class="div_SA2" position="absolute 0 52 1195 112">
          <Layouts>
            <Layout>
              <Shape id="line30" linetype="vertical" class="line_4" position="absolute 881 5 887 32"/>
              <Button id="btn_search" taborder="5" text="조회" class="btn1" position="absolute 901 8 957 30" onclick="grp_sea_btn_search_onclick"/>
              <Static id="caption15" text="최종저장 :" class="search_name" position="absolute 745 35 819 52"/>
              <CheckBox id="bool1" taborder="6" position="absolute 835 33 860 53" truevalue="Y" falsevalue="N"/>
              <Static id="caption12" text="정산금액 :" class="search_name" position="absolute 280 33 370 50"/>
              <Static id="caption14" text="차액 :" class="search_name" position="absolute 515 33 580 50"/>
              <MaskEdit id="opt_ableamt" taborder="7" readonly="true" mask="(-)#,###" position="absolute 135 33 265 52"/>
              <MaskEdit id="ipt_useamt" taborder="8" mask="(-)#,###" enable="false" position="absolute 370 33 500 52"/>
              <Static id="caption9" text="수령금액 :" class="search_name" position="absolute 45 33 134 50"/>
              <MaskEdit id="ipt_remamt" taborder="9" mask="(-)#,###" enable="false" position="absolute 580 33 710 52"/>
              <Combo id="cmb_cdid" taborder="10" innerdataset="@ds_init_dtlcodeinfo_codelist" codecolumn="cdid" datacolumn="cdnm" enable="false" position="absolute 465 6 549 25" onitemchanged="grp_sea_cmb_cdid_onitemchanged"/>
              <Static id="caption2" text="년도 :" class="search_name" position="absolute 45 7 105 24"/>
              <Static id="caption3" text="구분 :" class="search_name" position="absolute 170 6 235 23"/>
              <Static id="caption5" text="정산부서 :" class="search_name" position="absolute 575 6 661 23"/>
              <Static id="caption7" text="상세구분 :" class="search_name" position="absolute 375 7 461 24"/>
              <MaskEdit id="ipt_year" taborder="11" mask="####" position="absolute 110 6 151 25" maskchar=" " type="string" trimtype="both" style="align:center middle;" autoselect="true" autoskip="true"/>
              <Combo id="cmb_buseocode" taborder="12" innerdataset="@ds_init_deptinfo_deptlist" codecolumn="deptcd" datacolumn="deptnm" class="combo_default" enable="false" position="absolute 665 6 855 25"/>
              <Combo id="cmb_flagcd" taborder="13" innerdataset="@ds_init_codeinfo_codelist" codecolumn="cdid" datacolumn="cdnm" class="combo_default" position="absolute 235 6 355 25" onitemchanged="grp_sea_cmb_flagcd_onitemchanged"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line1" class="line_10" position="absolute 0 152 1195 158" anchor="left top right"/>
        <Button id="btn_delete" taborder="2" text="행삭제" class="btn2" position="absolute 1142 133 1195 152" anchor="top right" onclick="btn_delete_onclick"/>
        <Static id="caption1" text="정산비등록" class="tit_2" position="absolute 0 136 121 157"/>
        <Tab id="switch1" taborder="3" tabindex="0" class="tab_Normal" position="absolute 0 143 1195 753" anchor="all">
          <Tabpages>
            <Tabpage id="case1">
              <Layouts>
                <Layout>
                  <Grid id="datagrid1" taborder="1" binddataset="ds_main_datalist_itemlist" useinputpanel="false" position="absolute 0 1 1195 566" autoenter="select" cellsizingtype="col" anchor="all" oncelldblclick="switch1_case1_datagrid1_oncelldblclick">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="18"/>
                          <Column size="0"/>
                          <Column size="205"/>
                          <Column size="122"/>
                          <Column size="122"/>
                          <Column size="122"/>
                          <Column size="0"/>
                          <Column size="100"/>
                          <Column size="92"/>
                          <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="부서코드"/>
                          <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="year"/>
                          <Cell col="10" text="flagcd"/>
                          <Cell col="11" text="cdid"/>
                          <Cell col="12" text="체크"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head"/>
                          <Cell col="1" text="bind:buseocode"/>
                          <Cell col="2" style="align:left middle;padding:0 0 0 3;" text="bind:deptnm"/>
                          <Cell col="3" displaytype="number" text="bind:ableamt"/>
                          <Cell col="4" displaytype="number" text="bind:useamt"/>
                          <Cell col="5" displaytype="number" text="bind:remamt"/>
                          <Cell col="6" text="bind:fromdate" mask="yyyy-mm-dd"/>
                          <Cell col="7" displaytype="date" text="bind:todate" calendardisplaynulltype="nulltext"/>
                          <Cell col="8" displaytype="checkbox" edittype="checkbox" text="bind:cnfmflag" expr="expr:cnfmflag == 'Y' ? 1 : 0"/>
                          <Cell col="9" text="bind:year"/>
                          <Cell col="10" text="bind:flagcd"/>
                          <Cell col="11" text="bind:cdid"/>
                          <Cell col="12" text="bind:checkyn"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Static id="caption13" text="총수령금액 :" position="absolute 215 570 295 590" style="font:Dotum,9,bold;" anchor="left bottom"/>
                  <MaskEdit id="ipt_ablesum" taborder="2" mask="(-)#,##0" position="absolute 295 570 415 589" anchor="left bottom"/>
                  <Static id="caption10" text="총정산금액 :" position="absolute 430 570 510 590" style="font:Dotum,9,bold;" anchor="left bottom"/>
                  <MaskEdit id="ipt_usesum" taborder="3" mask="(-)#,##0" position="absolute 510 570 630 589" anchor="left bottom"/>
                  <Static id="caption11" text="총차액 :" position="absolute 645 570 700 590" style="font:Dotum,9,bold;" anchor="left bottom"/>
                  <MaskEdit id="ipt_remsum" taborder="4" mask="(-)#,##0" position="absolute 700 570 820 589" anchor="left bottom"/>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="case2">
              <Layouts>
                <Layout>
                  <Grid id="grd_acntinoutlist" taborder="0" binddataset="ds_main_datalist_jungsan" useinputpanel="false" position="absolute 0 1 1195 591" autoenter="select" cellsizingtype="col" anchor="all" oncelldblclick="switch1_case2_grd_acntinoutlist_oncelldblclick">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="21"/>
                          <Column size="0"/>
                          <Column size="109"/>
                          <Column size="40"/>
                          <Column size="217"/>
                          <Column size="361"/>
                          <Column size="150"/>
                          <Column size="205"/>
                          <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="순번"/>
                          <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="year"/>
                          <Cell col="9" text="flagcd"/>
                          <Cell col="10" text="cdid"/>
                          <Cell col="11" text="buseocode"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head"/>
                          <Cell col="1" text="bind:seq"/>
                          <Cell col="2" displaytype="date" edittype="date" text="bind:baldate" calendardisplaynulltype="nulltext"/>
                          <Cell col="3" text="bind:day"/>
                          <Cell col="4" displaytype="combo" edittype="combo" style="padding:0 0 0 3;" text="bind:youngdo" combodataset="ds_cmb_youngdo" combocodecol="value" combodatacol="label" combodisplayrowcount="10"/>
                          <Cell col="5" displaytype="text" edittype="text" text="bind:kdesc"/>
                          <Cell col="6" displaytype="number" edittype="normal" text="bind:amt"/>
                          <Cell col="7" displaytype="combo" edittype="combo" style="align:left middle;padding:0 0 0 3;" text="bind:jeungbing" combodataset="ds_cmb_jeungbing" combocodecol="value" combodatacol="label" combodisplayrowcount="10"/>
                          <Cell col="8" text="bind:year"/>
                          <Cell col="9" text="bind:flagcd"/>
                          <Cell col="10" text="bind:cdid"/>
                          <Cell col="11" text="bind:buseocode"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Button id="btn_excel" taborder="4" text="엑셀출력" class="btn7" position="absolute 1061 133 1141 152" anchor="top right" onclick="btn_excel_onclick"/>
        <Button id="btn_dedu" taborder="5" text="직원인건비내역등록" class="btn2" position="absolute 925 133 1060 152" anchor="top right" onclick="btn_dedu_onclick"/>
        <Button id="btn_insert" taborder="6" text="행추가" class="btn2" position="absolute 1088 133 1141 152" anchor="top right" onclick="btn_insert_onclick"/>
        <Static id="caption8" text="※ 관리부서 확인 여부는 저장버튼을 누르지 않아도 Click시 즉시 처리됩니다." position="absolute 504 134 922 154" style="color:#ff0000ff;"/>
        <Button id="btn_save" taborder="7" text="저장" class="btn4" position="absolute 1138 27 1194 49" anchor="top right" onclick="btn_save_onclick"/>
        <Shape id="line2" class="line_6" position="absolute 0 48 1195 54" anchor="left top right"/>
        <Button id="btn_print" taborder="8" text="출력" class="btn6" position="absolute 1080 27 1136 49" anchor="top right" onclick="btn_print_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <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" sumtext="수령금액"/>
          <Column id="useamt" type="STRING" size="256" sumtext="정산금액"/>
          <Column id="remamt" type="STRING" size="256" sumtext="차액"/>
          <Column id="dispseq" type="STRING" size="256" sumtext="display 순서"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="ableamt"/>
            <Col id="useamt"/>
            <Col id="remamt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_retrparam" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_retrparam_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="year" type="STRING" size="256"/>
          <Column id="flagcd" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="buseocode" type="STRING" size="256"/>
          <Column id="flagnm" type="STRING" size="256"/>
          <Column id="buseoname" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="year"/>
            <Col id="flagcd"/>
            <Col id="cdid"/>
            <Col id="buseocode"/>
            <Col id="flagnm"/>
            <Col id="buseoname"/>
            <Col id="cdnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_codeinfo_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_dtlcodeinfo_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_datalist_itemlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_datalist_itemlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="fromdate" type="STRING" size="256" sumtext="최초입력일"/>
          <Column id="todate" type="STRING" size="256" sumtext="최종수정일"/>
          <Column id="year" type="STRING" size="256" sumtext="년도"/>
          <Column id="flagcd" type="STRING" size="256" sumtext="정산구분"/>
          <Column id="cdid" type="STRING" size="256" sumtext="상세구분"/>
          <Column id="buseocode" type="STRING" size="256" sumtext="정산부서"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="정산부서"/>
          <Column id="checkyn" type="STRING" size="256" sumtext="확인"/>
          <Column id="cnfmflag" type="STRING" size="256" sumtext="재무확인여부"/>
          <Column id="ableamt" type="STRING" size="256" sumtext="수령금액"/>
          <Column id="useamt" type="STRING" size="256" sumtext="정산금액"/>
          <Column id="remamt" type="STRING" size="256" sumtext="차액"/>
        </ColumnInfo>
      </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="baldate" 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="flagcd" type="STRING" size="256" sumtext="정산구분"/>
          <Column id="cdid" type="STRING" size="256" sumtext="상세구분"/>
          <Column id="buseocode" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="day" 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"/>
      <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_hidden_savelist_iteminfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_retrparam2" 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="year" type="STRING" size="256"/>
          <Column id="flagcd" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="buseocode" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="year"/>
            <Col id="flagcd"/>
            <Col id="cdid"/>
            <Col id="buseocode"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main2_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="flagcd" type="STRING" size="256" sumtext="정산구분"/>
          <Column id="cdid" type="STRING" size="256" sumtext="상세구분"/>
          <Column id="buseocode" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="oksign" type="STRING" size="256" sumtext="승인여부"/>
          <Column id="cnfmflag" type="STRING" size="256" sumtext="관리부서확인여부"/>
          <Column id="m" type="STRING" size="256" sumtext="수정구분"/>
        </ColumnInfo>
      </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="flagcd" type="STRING" size="256" sumtext="정산구분"/>
          <Column id="cdid" type="STRING" size="256" sumtext="상세구분"/>
          <Column id="buseocode" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="oksign" type="STRING" size="256" sumtext="승인여부"/>
          <Column id="cnfmflag" type="STRING" size="256" sumtext="관리부서확인여부"/>
          <Column id="m" type="STRING" size="256" sumtext="수정구분"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_hidden_savelist_acntinoutlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_hidden_savelist_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.ipt_year" propid="value" datasetid="ds_send_retrparam" columnid="year"/>
      <BindItem id="item1" compid="grp_sea.cmb_flagcd" propid="value" datasetid="ds_send_retrparam" columnid="flagcd"/>
      <BindItem id="item2" compid="grp_sea.cmb_cdid" propid="value" datasetid="ds_send_retrparam" columnid="cdid"/>
      <BindItem id="item3" compid="grp_sea.cmb_buseocode" propid="value" datasetid="ds_send_retrparam" columnid="buseocode"/>
      <BindItem id="item4" compid="grp_sea.opt_ableamt" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="ableamt"/>
      <BindItem id="item5" compid="grp_sea.ipt_useamt" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="useamt"/>
      <BindItem id="item6" compid="grp_sea.ipt_remamt" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="remamt"/>
      <BindItem id="item7" compid="grp_sea.bool1" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="oksign"/>
    </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 SMRAH04800_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAH04800_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(switch1.case1.datagrid1);
	grdf_setRowTypeIcon(switch1.case1.datagrid1, 0);
	grdf_initGrid(switch1.case2.grd_acntinoutlist);
	grdf_setRowTypeIcon(switch1.case2.grd_acntinoutlist, 0);
	
	fResetForm();
}

function fResetForm()
{
	ds_main_datalist_amtinfo.clearData();
	ds_main_datalist_amtinfo.addRow();
	ds_main_datalist_jungsan.clearData();
	ds_main_datalist_itemlist.clearData();
	
	switch1.tabindex = 0;
	
	btn_save.enable = false;
	btn_insert.visible = false; 
	btn_delete.visible = false; 
	btn_excel.visible = true;   
	btn_dedu.enable = false;
						
	ds_send_retrparam.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_send_retrparam.setColumn(0, "year", String(utlf_getCurrentDate()).substr(0,4));
	
	var oParam = {};
		oParam.id          = "TRRAH04302";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetQIComboList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_init_codeinfo_codelist=codelist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH04302";

	tranf_submit(oParam);
	var oParam = {};
		oParam.id          = "TRRAH01202";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetDeptList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_init_deptinfo_deptlist=deptlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH01202";

	tranf_submit(oParam);
}

function ds_send_retrparam_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "year")
	{
		grp_sea.ipt_year.value = e.newvalue;
		grp_sea.ipt_year.setFocus();
		misfGridInit(switch1.case1.datagrid1);
		misfGridInit(switch1.case2.grd_acntinoutlist);
		
		switch1.tabindex = 0;
		
		grp_sea.opt_ableamt.value = "";
		grp_sea.ipt_useamt.value = "";
		grp_sea.ipt_remamt.value = "";
		grp_sea.cmb_buseocode.value = "";
	}
}

function grp_sea_cmb_flagcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	misfGridInit(switch1.case1.datagrid1);
	misfGridInit(switch1.case2.grd_acntinoutlist);									
	switch1.tabindex = 0;
	grp_sea.opt_ableamt.value = "";
	grp_sea.ipt_useamt.value = "";
	grp_sea.ipt_remamt.value = "";
	grp_sea.cmb_buseocode.value = "";
	
	var oParam = {};
		oParam.id          = "TRRAH04602";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetQIDtlComboList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_init_dtlcodeinfo_codelist=codelist";
		oParam.async       = false;
		oParam.callback    = "cf_TRRAH04602";

	tranf_submit(oParam);
	
	grp_sea.cmb_cdid.value = "";
}

function cf_TRRAH04602(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) return;
    else
    {
		if(ds_init_dtlcodeinfo_codelist.rowcount > 0)
		{
			grp_sea.cmb_cdid.enable = true;
		}
		else 
		{
			grp_sea.cmb_cdid.enable = false;
		}
    }
}

function grp_sea_cmb_cdid_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	misfGridInit(switch1.case1.datagrid1);
	misfGridInit(switch1.case2.grd_acntinoutlist);									
	
	switch1.tabindex = 0;
	
	grp_sea.opt_ableamt.value = "";
	grp_sea.ipt_useamt.value = "";
	grp_sea.ipt_remamt.value = "";
	grp_sea.cmb_buseocode.value = "";
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if(String(grp_sea.ipt_year.value).length != 4) 
	{
		sysf_messageBox("년도를 확인하십시요. ", "E999", "");
		grp_sea.ipt_year.setFocus();
		return;
	}
	
	if(utlf_isNull(grp_sea.cmb_flagcd.value))
	{
		sysf_messageBox("구분을 선택하십시요. ", "E999", "");
		grp_sea.cmb_flagcd.setFocus();
		return;
	}	
						
	fRetrieve();
}

function fRetrieve()
{
	ds_main_datalist_itemlist.clearData();
	ds_main_datalist_amtinfo.clearData();
	ds_main_datalist_amtinfo.addRow();
	ds_main_datalist_jungsan.clearData();
	
	switch1.tabindex = 0;
	
	btn_save.enable = false;
	btn_insert.visible = false;     //행추가
	btn_delete.visible = false;     //행삭제
	btn_excel.visible = true;   //엑셀다운
	btn_dedu.enable = false;

	grp_sea.opt_ableamt.value = "";
	grp_sea.ipt_useamt.value = "";
	grp_sea.ipt_remamt.value = "";
	grp_sea.cmb_buseocode.value = "";

	var oParam = {};
		oParam.id          = "TRRAH03801";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetQIManagerJungSanList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_main_datalist_itemlist=itemlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH03801";

	tranf_submit(oParam);
}

function ds_main_datalist_itemlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "cnfmflag")
	{
		obj.setColumn(e.row, "cnfmflag", (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "N");
		
		ds_hidden_savelist_iteminfo.copyData(grdf_getGridUpdateData(switch1.case1.datagrid1));
		var oParam = {};
			oParam.id          = "TXRAH04801";
			oParam.service     = "acntknuhapp.Acntknuh";
			oParam.method      = "reqExeSaveQIManagerInfoList";
			oParam.inds        = "req=ds_hidden_savelist_iteminfo:u";
			oParam.outds       = "ds_=seqno";
			oParam.async       = false;
			oParam.callback    = "cf_TXRAH04801";

		tranf_submit(oParam);
	}
}

function cf_TXRAH04801(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) return;
    else
    {
		ds_main_datalist_itemlist.setColumn(ds_main_datalist_itemlist.rowposition, "checkyn", "u")
    }
}

function switch1_case2_grd_acntinoutlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{

}

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",utlf_getDateTime(sDate.toDate(), "W"));
		}
	}	
}

function btn_dedu_onclick(obj:Button,  e:ClickEventInfo)
{
	var Ableamt = ds_main_datalist_amtinfo.getColumn(0, "ableamt");
	if( Ableamt == "0" || utlf_isNull(Ableamt))
	{
		sysf_messageBox("수령금액이 존재하지 않습니다. \n조회 후 등록하십시요. ", "E999", "");
		return;
	}	
			
	dsf_makeValue(ds_send_retrparam, "flagnm", "string", grp_sea.cmb_flagcd.text, 0);
	dsf_makeValue(ds_send_retrparam, "cdnm", "string", grp_sea.cmb_cdid.text, 0);
	dsf_makeValue(ds_send_retrparam, "buseoname", "string", grp_sea.cmb_buseocode.text, 0);
	dsf_makeValue(ds_send_retrparam, "opener", "string", "SMRAH04700", 0);
	
// 	var objArg = new Object();
// 		objArg.arg_ds_target = ds_send_retrparam;
	frmf_modal("SMRAH04900", "SMRAH04900", "", "", "", "", "", "", "", "", "", "", "M");
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(switch1.case1.datagrid1, "excel", "sheetname", "true", "", "");
}

function btn_insert_onclick(obj:Button,  e:ClickEventInfo)
{
	var Ableamt = ds_main_datalist_amtinfo.getColumn(0, "ableamt");
	if( Ableamt == "0" || utlf_isNull(Ableamt))
	{
		sysf_messageBox("수령금액이 존재하지 않습니다. \n조회 후 확인하십시요. ", "E999", "");
		grp_sea.cmb_flagcd.setFocus();
		return;
	}	
	
	var addRow = ds_main_datalist_jungsan.addRow()
	ds_main_datalist_jungsan.setColumn(addRow, "baldate", utlf_getCurrentDate());
	ds_main_datalist_jungsan.setColumn(addRow, "year", ds_send_retrparam2.getColumn(0, "year"));
	ds_main_datalist_jungsan.setColumn(addRow, "flagcd", ds_send_retrparam2.getColumn(0, "flagcd"));
	ds_main_datalist_jungsan.setColumn(addRow, "cdid", ds_send_retrparam2.getColumn(0, "cdid"));
	ds_main_datalist_jungsan.setColumn(addRow, "buseocode", ds_send_retrparam2.getColumn(0, "buseocode"));
	
	if(ds_main_datalist_jungsan.rowposition == 0)
	{
		ds_main_datalist_jungsan.setColumn(ds_main_datalist_jungsan.rowposition, "seq", "1");
	}
	else
	{		
		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 (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", utlf_getDateTime(sDate.toDate(), "W"));
	}
}

function btn_delete_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, "");
		ds_main_datalist_jungsan.updatecontrol = true;
	}	
}

function btn_print_onclick(obj:Button,  e:ClickEventInfo)
{
	dsf_makeValue(ds_send_retrparam, "flagnm", "string", grp_sea.cmb_flagcd.text, 0);
	dsf_makeValue(ds_send_retrparam, "cdnm", "string", grp_sea.cmb_cdid.text, 0);
	dsf_makeValue(ds_send_retrparam, "deptnm", "string", grp_sea.cmb_buseocode.text, 0);
	
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/send/retrparam", ds_send_retrparam);
		rptf_setNodeListToDOM(objDOM, "/root/main/datalist/jungsan", ds_main_datalist_jungsan);
		rptf_setNodeListToDOM(objDOM, "/root/main/datalist/amtinfo", ds_main_datalist_amtinfo);
		rptf_setNodeListToDOM(objDOM, "/root/main/datalist/managerinfo", ds_main_datalist_managerinfo);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
	var option = ""; 
	rptf_exeReportPreview30(["SMRAH04701"],[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( String(ds_main_datalist_jungsan.getColumn(i, "baldate").length) != "8")
		{
			sysf_messageBox("[ " + parseInt(i+1) + " ]번째 행의 발생일자가 정확하지 않습니다. ", "E000");
			return;
		} 
		
		if( utlf_isNull(ds_main_datalist_jungsan.getColumn(i, "youngdo")))
		{
			sysf_messageBox("[ " + parseInt(i+1) + " ]번째 행의 계정구분값이 누락되었습니다. \n계정구분값은 필수 입력값입니다. ", "E000");
			return;
		} 
		
		if( utlf_isNull(ds_main_datalist_jungsan.getColumn(i, "jeungbing")))
		{
			sysf_messageBox("[ " + parseInt(i+1) + " ]번째 행의 증빙유형값이 누락되었습니다. \n증빙유형값은 필수 입력값입니다. ", "E000");
			return;
		} 						
	}

	fSaveData();	
}

function fSaveData()
{
	if(ds_main2_managerinfo.getColumn(0, "cnfmflag") == "Y" && ds_main2_managerinfo.getColumn(0, "oksign") == "Y" &&
	   ds_main_datalist_managerinfo.getColumn(0, "oksign") != "Y" ) 
	{
		sysf_messageBox("관리부서 확인 처리된 자료는 최종저장 여부를 수정할 수 없습니다.\n\n" +
							  "다시 조회 후 관리부서 확인 여부를 수정하여 처리하십시요.", "E999", "");
		grp_sea.bool1.value = "Y"; 
		return;
	}	
		
	
	var updtdata = grdf_getGridUpdateData(switch1.case2.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 ) continue;  
		
		var balyear = String(ds_main_datalist_jungsan.getColumn(i, "baldate")).substr(0,4); 
		var year = ds_send_retrparam.getColumn(0, "year");

		if(year != balyear)
		{
			sysf_messageBox("[ " + parseInt(i+1) + " ]번째 행의 발생일자가 적합하지 않습니다.", "I000");
			return;
		}

		var amt = ds_main_datalist_jungsan.getColumn(i, "amt");
		if(utlf_isNull(amt))
		{
			sysf_messageBox("[ " + parseInt(i+1) + " ]번째 행의 금액이 누락되었습니다. \n금액은 필수 입력값입니다. ", "E000");
			return;							
		} 							
	}

	if( sysf_messageBox("정산 내역을", "Q002")  != 6 ) return ;
	
	ds_hidden_savelist_iteminfo.clearData();
	fSave();
	
	var oParam = {};
		oParam.id          = "TXRAH04701";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqExeSaveQIJungSanList";
		oParam.inds        = "req=ds_main_datalist_jungsan:u req2=ds_main_datalist_managerinfo";
		oParam.outds       = "ds_=seqno";
		oParam.typeStr     = "status";
		oParam.async       = false;
		oParam.callback    = "cf_TXRAH04701";

	tranf_submit(oParam);
}

function cf_TXRAH04701(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0) return;
    else
    {
		var oParam = {};
			oParam.id          = "TRRAH04802";
			oParam.service     = "acntknuhapp.Acntknuh";
			oParam.method      = "reqGetQIMasterjungsanList";
			oParam.inds        = "req=ds_send_retrparam2";
			oParam.outds       = "ds_main_datalist_jungsan=jungsan ds_main_datalist_amtinfo=amtinfo ds_main_datalist_managerinfo=managerinfo";
			oParam.async       = false;
			//oParam.callback    = "cf_TRRAH04802";

		tranf_submit(oParam);
    }
}

function fSave()
{				           
	 var tPath = "ds_hidden_savelist_managerinfo";
	 var vData    = "";                       
	 var vHeader  = "m"            + "▦"      // 01. 상태
				  + "year"              + "▦"      // 02. 년도
				  + "flagcd"            + "▦"      // 03. 구분코드
				  + "cdid"              + "▦"      // 04. 상세코드 
				  + "buseocode"     	+ "▦"      // 05. 부서코드
				  + "oksign"            + "▩"      // 06. 승인여부;
					  
	vData   += ds_main_datalist_managerinfo.getColumn(0, "m")     	  	+ "▦"         
			+ ds_main_datalist_managerinfo.getColumn(0, "year")		  	+ "▦" 
			+ ds_main_datalist_managerinfo.getColumn(0, "flagcd")       + "▦"  
			+ ds_main_datalist_managerinfo.getColumn(0, "cdid")         + "▦"   
			+ ds_main_datalist_managerinfo.getColumn(0, "buseocode")	+ "▦" 
			+ ds_main_datalist_managerinfo.getColumn(0, "oksign")       + "▦" ;

	dsf_setCSVToDs(tPath, vHeader+vData);
}

function switch1_case1_datagrid1_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	if(ds_main_datalist_itemlist.rowposition < 0) return;

	ds_send_retrparam2.setColumn(0, "year", ds_main_datalist_itemlist.getColumn(ds_main_datalist_itemlist.rowposition, "year"));
	ds_send_retrparam2.setColumn(0, "flagcd", ds_main_datalist_itemlist.getColumn(ds_main_datalist_itemlist.rowposition, "flagcd"));
	ds_send_retrparam2.setColumn(0, "cdid", ds_main_datalist_itemlist.getColumn(ds_main_datalist_itemlist.rowposition, "cdid"));
	ds_send_retrparam2.setColumn(0, "buseocode", ds_main_datalist_itemlist.getColumn(ds_main_datalist_itemlist.rowposition, "buseocode"));
	
	switch1.tabindex = 1;
	
	btn_save.enable = true;
	btn_insert.visible = true;     //행추가
	btn_delete.visible = true;     //행삭제
	btn_excel.visible = false;   //엑셀다운
	btn_dedu.enable = true;
	
	var oParam = {};
		oParam.id          = "TRRAH04802";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetQIMasterjungsanList";
		oParam.inds        = "req=ds_send_retrparam2";
		oParam.outds       = "ds_main_datalist_jungsan=jungsan ds_main_datalist_amtinfo=amtinfo ds_main_datalist_managerinfo=managerinfo";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH04802";

	tranf_submit(oParam);
	
	ds_main2_managerinfo.clearData();
	ds_main2_managerinfo.copyData(ds_main_datalist_managerinfo);
	
	ds_send_retrparam.setColumn(0, "buseocode", ds_send_retrparam2.getColumn(0, "buseocode"));
}
]]></Script>
  </Form>
</FDL>