YNU_JEUS/app_home/himed/xpapps/mis/acntknuhxp/xp/SMRAH04700_QI활동비정산비등록.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAH04700" position="absolute 0 0 1200 774" titletext="QI활동비 정산비등록" oninit="SMRAH04700_oninit" onload="SMRAH04700_onload">
    <Layouts>
      <Layout>
        <Button position="absolute 1136 16 1192 38" id="btn_save" class="btn4" text="저장" anchor="top right" onclick="btn_save_onclick"/>
        <Static id="caption6" text="QI활동비 정산비등록" class="tit_1" position="absolute 0 0 293 25"/>
        <Shape id="line2" class="line_6" position="absolute 0 37 1194 43" anchor="left top right"/>
        <Button id="button3" taborder="1" text="출력" class="btn6" position="absolute 1078 16 1134 38" anchor="top right" onclick="button3_onclick"/>
        <Div id="grp_sea" taborder="2" class="div_SA2" position="absolute 0 41 1195 101" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line30" linetype="vertical" class="line_4" position="absolute 881 6 887 31" anchor="top right"/>
              <Button id="btn_search" taborder="5" text="조회" class="btn1" position="absolute 901 8 957 30" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Static id="caption3" text="구분 :" class="search_name" position="absolute 170 9 235 26"/>
              <Combo id="cmb_flagcd" taborder="6" innerdataset="@ds_init_codeinfo_codelist" codecolumn="cdid" datacolumn="cdnm" class="combo_default" position="absolute 235 9 355 28" onitemchanged="grp_sea_cmb_flagcd_onitemchanged"/>
              <Static id="caption5" text="정산부서 :" class="search_name" position="absolute 575 9 661 26"/>
              <Combo id="cmb_buseocode" taborder="7" innerdataset="@ds_init_deptinfo_deptlist" codecolumn="deptcd" datacolumn="deptnm" class="combo_default" position="absolute 665 9 855 28" onitemchanged="grp_sea_cmb_buseocode_onitemchanged"/>
              <Static id="caption9" text="수령금액 :" class="search_name" position="absolute 45 34 134 51"/>
              <MaskEdit id="ipt_useamt" taborder="8" mask="(-)#,###" enable="false" position="absolute 370 34 500 53"/>
              <Static id="caption12" text="정산금액 :" class="search_name" position="absolute 280 34 370 51"/>
              <Static id="caption14" text="차액 :" class="search_name" position="absolute 515 34 580 51"/>
              <MaskEdit id="ipt_remamt" taborder="9" mask="(-)#,###" enable="false" position="absolute 580 34 710 53"/>
              <Static id="caption15" text="최종저장 :" class="search_name" position="absolute 745 35 840 52"/>
              <CheckBox id="bool1" taborder="10" position="absolute 835 33 860 53" truevalue="Y" falsevalue="N"/>
              <MaskEdit id="opt_ableamt" taborder="11" readonly="true" mask="(-)#,###" position="absolute 135 34 265 53"/>
              <Static id="caption2" text="년도 :" class="search_name" position="absolute 45 10 105 27"/>
              <MaskEdit id="ipt_year" taborder="12" mask="####" position="absolute 110 9 151 28" autoselect="true" autoskip="true"/>
              <Static id="caption7" text="상세구분 :" class="search_name" position="absolute 375 10 461 27"/>
              <Combo id="cmb_cdid" taborder="13" innerdataset="@ds_init_dtlcodeinfo_codelist" codecolumn="cdid" datacolumn="cdnm" enable="false" position="absolute 465 9 549 28" onitemchanged="grp_sea_cmb_cdid_onitemchanged"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line1" class="line_10" position="absolute 0 147 1195 153" anchor="left top right"/>
        <Button id="button1" taborder="3" text="행추가" class="btn2" position="absolute 1085 128 1138 147" anchor="top right" onclick="button1_onclick"/>
        <Button id="button2" taborder="4" text="행삭제" class="btn2" position="absolute 1141 128 1194 147" anchor="top right" onclick="button2_onclick"/>
        <Static id="caption1" text="정산비등록" class="tit_2" position="absolute 0 131 121 152"/>
        <Grid id="grd_acntinoutlist" taborder="5" binddataset="ds_main_datalist_jungsan" useinputpanel="false" position="absolute 0 152 1194 767" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25"/>
                <Column size="37"/>
                <Column size="108"/>
                <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" text="bind:youngdo" combodataset="ds_cmb_youngdo" combocodecol="value" combodatacol="label"/>
                <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" text="bind:jeungbing" combodataset="ds_cmb_jeungbing" combocodecol="value" combodatacol="label"/>
                <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>
        <Button id="btn_excelinput" taborder="6" text="엑셀입력" class="btn7" position="absolute 1002 128 1082 147" anchor="top right" onclick="btn_excelinput_onclick"/>
        <Button id="btn_excelsave" taborder="7" text="엑셀샘플" class="btn7" position="absolute 920 128 1000 147" anchor="top right" onclick="btn_excelsave_onclick"/>
        <Grid id="datagrid1" taborder="8" binddataset="ds_sampledata" useinputpanel="false" visible="false" position="absolute 370 289 860 379">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="31"/>
                <Column size="37"/>
                <Column size="160"/>
                <Column size="113"/>
                <Column size="217"/>
                <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="순번"/>
                <Cell col="2" text="발생일자"/>
                <Cell col="3" text="요일"/>
                <Cell col="4" text="계정구분"/>
                <Cell col="5" text="지출내역"/>
                <Cell col="6" text="금액"/>
                <Cell col="7" text="증빙유형"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:seq"/>
                <Cell col="2" text="bind:baldate"/>
                <Cell col="3" text="bind:day"/>
                <Cell col="4" displaytype="combo" edittype="combo" text="bind:youngdo" combodataset="ds_cmb_youngdo" combocodecol="value" combodatacol="label"/>
                <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" text="bind:jeungbing" combodataset="ds_cmb_jeungbing" combocodecol="value" combodatacol="label"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_dedu" taborder="9" text="직원인건비내역등록" class="btn2" position="absolute 790 128 917 147" anchor="top right" onclick="btn_dedu_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <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="sabun" 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="oksign" 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="sabun"/>
            <Col id="userid"/>
            <Col id="poweryn"/>
            <Col id="sanyn"/>
            <Col id="oksign"/>
            <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">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_dtlcodeinfo_codelist" 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_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_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="useamt" type="STRING" size="256"/>
          <Column id="remamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="ableamt"/>
            <Col id="useamt"/>
            <Col id="remamt"/>
          </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="oksign" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </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_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"/>
      <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_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_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_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>
      </Dataset>
    </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_managerinfo" 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 SMRAH04700_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

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

function fResetForm()
{
	dsf_makeValue(ds_send_retrparam, "opener", "string", "SMRAH04700", 0);
	
	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);
}

function ds_send_retrparam_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "year")
	{
		grp_sea.opt_ableamt.value = "";
		grp_sea.ipt_useamt.value = "";
		grp_sea.ipt_remamt.value = "";
	}
}

function grp_sea_cmb_flagcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	misfGridInit(grd_acntinoutlist);
	grp_sea.opt_ableamt.value = "";
	grp_sea.ipt_useamt.value = "";
	grp_sea.ipt_remamt.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 = "";

	var Emplno = sysf_getUserInfo("userid");
	var Deptcd = sysf_getUserInfo("dutplcecd");
	
	ds_send_retrparam.setColumn(0, "userid", Emplno);
	ds_send_retrparam.setColumn(0, "sabun", Emplno);
	
	var oParam = {};
		oParam.id          = "TRRAH04701";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetQISanjaynList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_temp_jungsanjayn=jungsanjayn";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH04701";

	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          = "TRRAH04702";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetQISanjaList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_init_deptinfo_deptlist=deptlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH04702";

	tranf_submit(oParam);

	grp_sea.cmb_buseocode.value = "";

	var sanyn = ds_sanynlist.getColumn(0, "sanyn");
	
	if(sanyn == "Y")
	{
		ds_powerlist.setColumn(0, "poweryn", "Y");
		ds_send_retrparam.setColumn(0, "poweryn", "Y");
	}
	
	frmf_modal("SMRAH01800", "SMRAH01800", "", "", "", "", "", "", "", "", "", "", "M");
}

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(grd_acntinoutlist);
	grp_sea.opt_ableamt.value = "";
	grp_sea.ipt_useamt.value = "";
	grp_sea.ipt_remamt.value = "";
}

function grp_sea_cmb_buseocode_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	misfGridInit(grd_acntinoutlist);
	grp_sea.opt_ableamt.value = "";
	grp_sea.ipt_useamt.value = "";
	grp_sea.ipt_remamt.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;
	}	

	if(utlf_isNull(grp_sea.cmb_buseocode.value))
	{
		sysf_messageBox("정산부서를 선택하십시요. ", "E999", "");
		grp_sea.cmb_buseocode.setFocus();
		return;
	}	

	fRetrieve();
}

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);
	frmf_modal("SMRAH04900", "SMRAH04900", "", "", "", "", "", "", "", "", "", "", "M");
}

function btn_excelsave_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridInit(datagrid1);
						
	var addRow = ds_sampledata.addRow();
	
	ds_sampledata.setColumn(addRow, "baldate", "20150301");
	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, "QI활동비정산비등록_Sample", "QI활동비정산비등록_Sample", false, "", "user", false);
}

function btn_excelinput_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;
	}	
	
	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, "year"));
		ds_main_datalist_jungsan.setColumn(i, "flagcd", ds_send_retrparam.getColumn(0, "flagcd"));
		ds_main_datalist_jungsan.setColumn(i, "buseocode", ds_send_retrparam.getColumn(0, "buseocode"));
		ds_main_datalist_jungsan.setColumn(i, "cdid", ds_send_retrparam.getColumn(0, "cdid"));
		
		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)
{
	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_retrparam.getColumn(0, "year"));
	ds_main_datalist_jungsan.setColumn(addRow, "flagcd", ds_send_retrparam.getColumn(0, "flagcd"));
	ds_main_datalist_jungsan.setColumn(addRow, "buseocode", ds_send_retrparam.getColumn(0, "buseocode"));
	ds_main_datalist_jungsan.setColumn(addRow, "cdid", ds_send_retrparam.getColumn(0, "cdid"));
	
	if(ds_main_datalist_jungsan.rowposition == 0)
	{
		ds_main_datalist_jungsan.setColumn(0, "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 (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, "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/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);
		rptf_setNodeListToDOM(objDOM, "/root/send/retrparam", ds_send_retrparam);
	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("[ " + i + " ]번째 행의 발생일자가 정확하지 않습니다. ", "E000");
			return;
		} 
		
		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 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("[ " + 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 ;
	}												

	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:u";
		oParam.outds       = "ds_=seqno";
		oParam.async       = false;
		oParam.callback    = "cf_TXRAH04701";

	tranf_submit(oParam);	
}

function cf_TXRAH04701(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		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"));
		}
	}	
}
]]></Script>
  </Form>
</FDL>