YNU_JEUS/app_home/himed/xpapps/mis/acntknuhxp/xp/SMRAH03600_특별정산비등록.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAH03600" position="absolute 0 0 1203 776" titletext="정산비등록(의국)" oninit="SMRAH03600_oninit" onload="SMRAH03600_onload">
    <Layouts>
      <Layout>
        <Button position="absolute 1136 17 1192 39" id="btn_save" class="btn4" text="저장" anchor="top right" onclick="btn_save_onclick"/>
        <Static id="caption6" text="정산비등록(특별정산)" class="tit_1" position="absolute 0 0 293 25"/>
        <Shape id="line2" class="line_6" position="absolute 0 38 1194 44" anchor="left top right"/>
        <Button id="button3" taborder="1" text="출력" class="btn6" position="absolute 1078 17 1134 39" anchor="top right" onclick="button3_onclick"/>
        <Div id="grp_sea" taborder="2" class="div_SA2" position="absolute 0 42 1195 102" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line30" linetype="vertical" class="line_4" position="absolute 961 5 967 30" anchor="top right"/>
              <Button id="btn_search" taborder="1" text="조회" class="btn1" position="absolute 981 7 1037 29" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Static id="caption3" text="정산구분 :" class="search_name" position="absolute 45 9 140 26"/>
              <Combo id="combo1" taborder="2" innerdataset="@ds_init_codeinfo_codelist" codecolumn="cdid" datacolumn="cdnm" class="combo_default" position="absolute 135 8 440 27" onitemchanged="grp_sea_combo1_onitemchanged"/>
              <Static id="caption5" text="정산부서 :" class="search_name" position="absolute 455 9 550 26"/>
              <Combo id="combo2" taborder="3" innerdataset="@ds_init_deptinfo_deptlist" codecolumn="deptcd" datacolumn="deptnm" class="combo_default" position="absolute 545 8 735 27" onitemchanged="grp_sea_combo2_onitemchanged"/>
              <Combo id="combo3" taborder="4" innerdataset="@ds_init_emplnoinfo_emplnolist" codecolumn="emplno" datacolumn="emplnm" class="combo_default" enable="false" position="absolute 828 8 940 27" onitemchanged="grp_sea_combo3_onitemchanged"/>
              <Static id="caption8" text="정산자 :" class="search_name" position="absolute 750 9 825 26"/>
              <Static id="caption9" text="수령금액 :" class="search_name" position="absolute 45 33 134 50"/>
              <MaskEdit id="input4" taborder="5" mask="(-)#,###" enable="false" position="absolute 370 33 500 52"/>
              <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="input6" taborder="6" mask="(-)#,###" enable="false" position="absolute 580 32 710 51"/>
              <Static id="caption15" text="최종저장 :" class="search_name" position="absolute 750 34 845 51"/>
              <CheckBox id="bool1" taborder="7" position="absolute 839 31 864 51" truevalue="Y" falsevalue="N"/>
              <MaskEdit id="output1" taborder="8" readonly="true" mask="(-)#,###" position="absolute 135 33 265 52"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line1" class="line_10" position="absolute 0 150 1195 156" anchor="left top right"/>
        <Button id="button1" taborder="3" text="행추가" class="btn2" position="absolute 1085 131 1138 150" anchor="top right" onclick="button1_onclick"/>
        <Button id="button2" taborder="4" text="행삭제" class="btn2" position="absolute 1141 131 1194 150" anchor="top right" onclick="button2_onclick"/>
        <Static id="caption1" text="정산비등록" class="tit_2" position="absolute 0 134 121 155"/>
        <Grid id="grd_acntinoutlist" taborder="5" binddataset="ds_main_datalist_jungsan" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 155 1194 770" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25"/>
                <Column size="38"/>
                <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"/>
              </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="flagcd"/>
                <Cell col="10" text="buseocode"/>
                <Cell col="11" text="sabun"/>
              </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" editautoselect="true" calendardisplaynulltype="nulltext"/>
                <Cell col="4" text="bind:day" editautoselect="true"/>
                <Cell col="5" displaytype="combo" edittype="combo" text="bind:youngdo" editautoselect="true" combodataset="ds_cmb_youngdo" combocodecol="value" combodatacol="label"/>
                <Cell col="6" displaytype="text" edittype="text" text="bind:kdesc" editautoselect="true"/>
                <Cell col="7" displaytype="number" edittype="normal" text="bind:amt" editautoselect="true"/>
                <Cell col="8" displaytype="combo" edittype="combo" text="bind:jeungbing" editautoselect="true" combodataset="ds_cmb_jeungbing" combocodecol="value" combodatacol="label"/>
                <Cell col="9" text="bind:flagcd"/>
                <Cell col="10" text="bind:buseocode"/>
                <Cell col="11" text="bind:sabun"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excelinput" taborder="6" text="엑셀입력" class="btn7" position="absolute 1002 131 1082 150" anchor="top right" onclick="btn_excelinput_onclick"/>
        <Button id="btn_excelsave" taborder="7" text="엑셀샘플" class="btn7" position="absolute 919 131 999 150" anchor="top right" onclick="btn_excelsave_onclick"/>
        <Grid id="datagrid1" taborder="8" binddataset="ds_datagrid1" useinputpanel="false" visible="false" position="absolute 370 290 860 380">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="38"/>
                <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 text="NO"/>
                <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 text="bind:seq2"/>
                <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_jeungbing" combocodecol="value" combodatacol="label"/>
                <Cell col="5" displaytype="text" edittype="text" text="bind:kdesc"/>
                <Cell col="6" displaytype="number" edittype="text" 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 789 131 916 150" 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">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="flagcd" 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"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="flagnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="flagcd"/>
            <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"/>
            <Col id="gubun"/>
            <Col id="flagnm"/>
          </Row>
        </Rows>
      </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="flagcd" type="STRING" size="256" sumtext="구분코드"/>
          <Column id="seqno" 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_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="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="flagcd" type="STRING" size="256" sumtext="구분코드"/>
          <Column id="buseocode" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="sabun" 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_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_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_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"/>
      <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"/>
      <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.combo1" propid="value" datasetid="ds_send_retrparam" columnid="flagcd"/>
      <BindItem id="item1" compid="grp_sea.combo2" propid="value" datasetid="ds_send_retrparam" columnid="buseocode"/>
      <BindItem id="item2" compid="grp_sea.combo3" propid="value" datasetid="ds_send_retrparam" columnid="sabun"/>
      <BindItem id="item3" compid="grp_sea.output1" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="ableamt"/>
      <BindItem id="item4" compid="grp_sea.input4" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="useamt"/>
      <BindItem id="item5" compid="grp_sea.input6" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="remamt"/>
      <BindItem id="item6" 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 SMRAH03600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

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

function fResetForm()
{
	dsf_makeValue(ds_send_retrparam, "opener", "string", "SMRAH03600", 0);
	
	ds_send_retrparam.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	
	var oParam = {};
		oParam.id          = "TRRAH03502";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetSpecialComboList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_init_codeinfo_codelist=codelist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH03502";

	tranf_submit(oParam);
	
	if(ds_init_codeinfo_codelist.rowcount > 0) 
	{
		grp_sea.combo1.index = ds_init_codeinfo_codelist.rowcount-1
	}	
	
	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          = "TRRAH03603";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetSanjaSpcList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_init_deptinfo_deptlist=deptlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH03603";

	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          = "TRRAH03601";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetJungSanSpcList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_main_datalist_jungsan=jungsan ds_main_datalist_amtinfo=amtinfo ds_main_datalist_managerinfo=managerinfo";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH03601";

	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_combo1_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	grp_sea.btn_search.click();
	grp_sea.combo2.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)
{
	if(utlf_isNull(grp_sea.combo1.value))
	{
		sysf_messageBox("정산구분이 선택되지 않았습니다. ", "E999", "");
		return;
	}	

	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(utlf_isNull(grp_sea.combo1.value))
	{
		sysf_messageBox("정산구분이 선택되지 않았습니다. ", "E999", "");
		return;
	}	
	if(utlf_isNull(grp_sea.combo2.value))
	{
		sysf_messageBox("정산부서가 선택되지 않았습니다. ", "E999", "");
		return;
	}	
	
	dsf_makeValue(ds_send_retrparam, "flagnm", "string", grp_sea.combo1.text, 0);
	dsf_makeValue(ds_send_retrparam, "buseoname", "string", grp_sea.combo2.text, 0);
	dsf_makeValue(ds_send_retrparam, "opener", "string", "SMRAH03600", 0);
	frmf_modal("SMRAH03700", "SMRAH03700", "", "", "", "", "", "", "", "", "", "", "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(ds_main_datalist_amtinfo.getColumn(0, "ableamt") == 0) 
	{
		sysf_messageBox("수령금액이 존재하지 않습니다. \n조회조건을 다시 확인하십시요. ", "E999", "");
		grp_sea.combo1.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, "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, "sabun", ds_send_retrparam.getColumn(0, "sabun"));
		
		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(ds_main_datalist_amtinfo.getColumn(0, "ableamt") == 0) 
	{
		sysf_messageBox("수령금액이 존재하지 않습니다. \n조회조건을 다시 확인하십시요. ", "E999", "");
		grp_sea.combo1.setFocus();
		return;
	}	
	
	var addRow = ds_main_datalist_jungsan.addRow();
	
	ds_main_datalist_jungsan.setColumn(addRow, "baldate", utlf_getCurrentDate());
	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, "sabun", ds_send_retrparam.getColumn(0, "sabun"));
	
	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, "flagnm", "string", grp_sea.combo1.text, 0);
	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/amtinfo", ds_main_datalist_amtinfo);
		rptf_setNodeListToDOM(objDOM, "/root/send/retrparam", ds_send_retrparam);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
	var option = ""; 
	rptf_exeReportPreview30(["SMRAH03601"],[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+1 + " ]번째 행의 발생일자가 정확하지 않습니다. ", "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 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");
	}
	
	var oParam = {};
		oParam.id          = "TXRAH03601";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqExeSaveJungSanSpcList";
		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_TXRAH03601";

	tranf_submit(oParam);
}

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