YNU_JEUS/app_home/himed/xpapps/mis/accountinginfoxp/xp/SMRAR00100_가수금입력.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAR00100" position="absolute 0 0 1223 791" titletext="가수금입력" onload="SMRAR00100_onload">
    <Layouts>
      <Layout>
        <Div id="group1" position="absolute 0 0 1195 21" style="" scrollbars="none">
          <Layouts>
            <Layout>
              <Static id="caption6" class="tit_1" position="absolute 0 0 143 22" style="" text="가수금 입력" anchor="default"/>
              <Static id="caption4" class="patient_text_black" position="absolute 922 0 1194 200" style="" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group3" scrollbars="autoboth" position="absolute 0 40 1195 784" style="">
          <Layouts>
            <Layout>
              <Div id="grp_sea" position="absolute 0 10 1195 48" style="align: top;">
                <Layouts>
                  <Layout>
                    <Shape id="roundrect1" anchor="default" class="roundrect_search" type="roundrectangle" position="absolute 0 0 1195 38" style="border:1 solid #ffd799 #ffd799;background:#fffbf2  ;"/>
                    <Static id="caption3" class="search_name" position="absolute 11 10 90 26" style="" text="예금계좌"/>
                    <Combo innerdataset="ds_init_bankinfo" datacolumn="aactno" codecolumn="aactcd" columncount="-1" rowcount="-1" id="cmb_aactno" class="combo_s_essential" taborder="1" position="absolute 90 9 220 28" style="" onitemchanged="group3_grp_sea_cmb_aactno_onitemchanged"/>
                    <Edit id="opt_aactcd" class="output_fix" position="absolute 220 9 260 28" style="align:center ;" anchor="default" readonly="true"/>
                    <Static id="cap_codeflag" class="search_name" position="absolute 275 10 365 27" style="" text="가수금일자"/>
                    <Calendar id="ipt_gadate" class="input_s_essential" mask="yyyy-mm-dd" position="absolute 368 9 463 28" style="" anchor="default" onkillfocus="group3_grp_sea_ipt_gadate_onkillfocus" autoskip="true" autoselect="true"/>
                    <Edit id="opt_seqline" class="input_s_essential" position="absolute 463 9 493 28" style="align:center ;" anchor="default" autoskip="true" onkeydown="group3_grp_sea_opt_seqline_onkeydown" autoselect="true" onkeyup="group3_grp_sea_opt_seqline_onkeyup" onlbuttonup="group3_grp_sea_opt_seqline_onlbuttonup" onlbuttondown="group3_grp_sea_opt_seqline_onlbuttondown"/>
                    <Static id="caption7" class="search_name" position="absolute 810 8 915 25" style="" text="최종예금잔액" visible="false"/>
                    <Edit id="ipt_janamt" class="output_fix" position="absolute 915 7 1020 26" style="align:right ;" anchor="default" readonly="true" visible="false"/>
                    <MaskEdit id="ipt_janamtup" class="input_s_essential" visible="false" mask="(-)#,###" position="absolute 1020 7 1125 26" style="align:right ;" anchor="default"/>
                    <Button id="btn_janamtsave" class="btn2" visible="false" position="absolute 1127 7 1191 26" style="" text="잔액수정" onclick="group3_grp_sea_btn_janamtsave_onclick"/>
                    <Static id="caption8" class="search_name" position="absolute 510 10 615 27" style="" text="예금출고금액"/>
                    <MaskEdit id="ipt_chulamt" class="input_s_essential" mask="(-)#,###" position="absolute 615 9 715 28" style="align:right ;" anchor="default" onsetfocus="group3_grp_sea_ipt_chulamt_onsetfocus" onkillfocus="group3_grp_sea_ipt_chulamt_onkillfocus"/>
                    <Shape id="line5" class="line_4" linetype="vertical" position="absolute 732 8 735 30" style="border:1 solid #ffe4bb #ffe4bb;" anchor="default"/>
                    <Button id="button2" class="btn1" taborder="4" position="absolute 743 8 799 30" style="align:left ;" text="조회" onclick="group3_grp_sea_button2_onclick"/>
                  </Layout>
                </Layouts>
              </Div>
              <Shape id="line3" class="line_1" linetype="horizontal" position="absolute 0 75 1194 78" style="" anchor="default"/>
              <Button id="button18" class="btn2" position="absolute 1137 54 1190 73" style="" text="행삭제" onclick="group3_button18_onclick"/>
              <Button id="btn_addrow" class="btn2" position="absolute 1082 54 1135 73" style="" text="행추가" onclick="group3_btn_addrow_onclick"/>
              <Grid id="grd_main" binddataset="ds_main_search_maindatalist" position="absolute 0 80 1194 715" style="" onaftersort="group3_grd_main_onaftersort" cellsizingtype="col" autoenter="select" ontextchanged="group3_grd_main_ontextchanged" onkillfocus="group3_grd_main_onkillfocus" onkeydown="group3_grd_main_onkeydown">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="26"/>
                      <Column size="80"/>
                      <Column size="153"/>
                      <Column size="150"/>
                      <Column size="350"/>
                      <Column size="100"/>
                      <Column size="90"/>
                      <Column size="90"/>
                      <Column size="79"/>
                      <Column size="0"/>
                      <Column size="0"/>
                      <Column size="0"/>
                      <Column size="0"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <Cell col="1" text="NO"/>
                      <Cell col="2" text="구분"/>
                      <Cell col="3" text="가수금"/>
                      <Cell col="4" text="적요"/>
                      <Cell col="5" text="가수금일자"/>
                      <Cell col="6" text="미결전표번호"/>
                      <Cell col="7" text="승인전표번호"/>
                      <Cell col="8" text="상계건수"/>
                      <Cell col="9" text="계좌코드"/>
                      <Cell col="10" text="sangflag"/>
                      <Cell col="11" text="instcd"/>
                      <Cell col="12" text="seqline"/>
                      <Cell col="13" text="상계여부"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head"/>
                      <Cell col="1" text="bind:line"/>
                      <Cell col="2" edittype="text" text="bind:gubun" editautoselect="true"/>
                      <Cell col="3" displaytype="number" edittype="masknumber" text="bind:gaamt" editautoselect="true"/>
                      <Cell col="4" edittype="text" style="align:left middle;" text="bind:rmrk" editautoselect="true"/>
                      <Cell col="5" displaytype="date" text="bind:gadate" mask="yyyy-MM-dd" calendardisplaynulltype="nulltext"/>
                      <Cell col="6" displaytype="text" style="align:center middle;" text="bind:unslno"/>
                      <Cell col="7" displaytype="text" style="align:center middle;" text="bind:sanctslipno"/>
                      <Cell col="8" text="bind:sangcnt"/>
                      <Cell col="9" text="bind:aactcd"/>
                      <Cell col="10" text="bind:sangflag"/>
                      <Cell col="11" text="bind:instcd"/>
                      <Cell col="12" text="bind:seqline"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Button id="ipt_excsave" class="btn2" position="absolute 1016 54 1080 73" style="" text="엑셀저장" onclick="group3_ipt_excsave_onclick"/>
              <Static id="caption21" class="tit_2" position="absolute 5 55 136 76" style="" text="출력 목록"/>
              <Button id="ipt_excadd" class="btn2" position="absolute 950 54 1014 73" style="" text="엑셀입력" onclick="group3_ipt_excadd_onclick"/>
              <Edit id="ipt_unslno" class="output_fix" position="absolute 770 50 820 69" style="" anchor="default" readonly="true" visible="false"/>
              <Edit id="ipt_sanctslipno" class="output_fix" position="absolute 825 50 875 69" style="" anchor="default" readonly="true" visible="false"/>
              <MaskEdit id="cpt_gaamtsum" taborder="1" position="absolute 263 717 419 737" mask="999,999,999,9990" style="background:#ffccccff;"/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group4" scrollbars="none" position="absolute 0 13 1195 40" style="">
          <Layouts>
            <Layout>
              <Button id="button39" class="btn4" position="absolute 1137 3 1193 25" style="" text="저장" onclick="group4_button39_onclick"/>
              <Shape id="line2" class="line_6" linetype="horizontal" position="absolute 0 25 1194 28" style="" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption1" class="cell_1" position="absolute 134 757 254 780" style="align:center middle;" text="가수금합계"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="save" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_gaamtsum" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="gaamtsum" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="gaamtsum"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_etcinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="seqline" type="STRING" size="256"/>
          <Column id="janamt" type="STRING" size="256"/>
          <Column id="chulamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="seqline"/>
            <Col id="janamt"/>
            <Col id="chulamt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_main_search_maindatalist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="line" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="rmrk" type="STRING" size="256"/>
          <Column id="gaamt" type="STRING" size="256"/>
          <Column id="gadate" type="STRING" size="256"/>
          <Column id="aactcd" type="STRING" size="256"/>
          <Column id="sangflag" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="seqline" type="STRING" size="256"/>
          <Column id="unslno" type="STRING" size="256"/>
          <Column id="sanctslipno" type="STRING" size="256"/>
          <Column id="sangcnt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="line"/>
            <Col id="gubun"/>
            <Col id="rmrk"/>
            <Col id="gaamt"/>
            <Col id="gadate"/>
            <Col id="aactcd"/>
            <Col id="sangflag"/>
            <Col id="instcd"/>
            <Col id="seqline"/>
            <Col id="unslno"/>
            <Col id="sanctslipno"/>
            <Col id="sangcnt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_hidden_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="code" type="STRING" size="256"/>
          <Column id="prntnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="code"/>
            <Col id="prntnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="temp" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_init_bankinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="acctno" type="STRING" size="256"/>
          <Column id="acctcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="acctno"/>
            <Col id="acctcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="gadate" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="aactno" type="STRING" size="256"/>
          <Column id="aactcd" type="STRING" size="256"/>
          <Column id="seqline" type="STRING" size="256"/>
          <Column id="janamt" type="STRING" size="256"/>
          <Column id="chulamt" type="STRING" size="256"/>
          <Column id="unslno" type="STRING" size="256"/>
          <Column id="sanctslipno" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="gadate"/>
            <Col id="instcd"/>
            <Col id="aactno"/>
            <Col id="aactcd"/>
            <Col id="seqline"/>
            <Col id="janamt"/>
            <Col id="chulamt"/>
            <Col id="unslno"/>
            <Col id="sanctslipno"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="gadate" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="aactno" type="STRING" size="256"/>
          <Column id="aactcd" type="STRING" size="256"/>
          <Column id="seqline" type="STRING" size="256"/>
          <Column id="janamt" type="STRING" size="256"/>
          <Column id="chulamt" type="STRING" size="256"/>
          <Column id="unslno" type="STRING" size="256"/>
          <Column id="sanctslipno" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="gadate"/>
            <Col id="instcd"/>
            <Col id="aactno"/>
            <Col id="aactcd"/>
            <Col id="seqline"/>
            <Col id="janamt"/>
            <Col id="chulamt"/>
            <Col id="unslno"/>
            <Col id="sanctslipno"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_apsl" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="sumgaamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="sumgaamt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_search_maindatalist_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="line" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="rmrk" type="STRING" size="256"/>
          <Column id="gaamt" type="STRING" size="256"/>
          <Column id="gadate" type="STRING" size="256"/>
          <Column id="aactcd" type="STRING" size="256"/>
          <Column id="sangflag" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="seqline" type="STRING" size="256"/>
          <Column id="unslno" type="STRING" size="256"/>
          <Column id="sanctslipno" type="STRING" size="256"/>
          <Column id="sangcnt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="line"/>
            <Col id="gubun"/>
            <Col id="rmrk"/>
            <Col id="gaamt"/>
            <Col id="gadate"/>
            <Col id="aactcd"/>
            <Col id="sangflag"/>
            <Col id="instcd"/>
            <Col id="seqline"/>
            <Col id="unslno"/>
            <Col id="sanctslipno"/>
            <Col id="sangcnt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_line" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group3.grp_sea.cmb_aactno" propid="value" datasetid="ds_search" columnid="aactcd"/>
      <BindItem id="item1" compid="group3.grp_sea.opt_aactcd" propid="value" datasetid="ds_search" columnid="aactcd"/>
      <BindItem id="item2" compid="group3.grp_sea.ipt_gadate" propid="value" datasetid="ds_search" columnid="gadate"/>
      <BindItem id="item3" compid="group3.grp_sea.opt_seqline" propid="value" datasetid="ds_search" columnid="seqline"/>
      <BindItem id="item4" compid="group3.grp_sea.ipt_janamt" propid="value" datasetid="ds_search" columnid="janamt"/>
      <BindItem id="item5" compid="group3.grp_sea.ipt_janamtup" propid="value" datasetid="ds_send" columnid="janamt"/>
      <BindItem id="item6" compid="group3.grp_sea.ipt_chulamt" propid="value" datasetid="ds_search" columnid="chulamt"/>
      <BindItem id="item7" compid="group3.ipt_unslno" propid="value" datasetid="ds_search" columnid="unslno"/>
      <BindItem id="item8" compid="group3.ipt_sanctslipno" propid="value" datasetid="ds_search" columnid="sanctslipno"/>
    </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 "com_basiccodexp::ZBC001.xjs";
include "mis_miscommonxp::MIS.xjs";
//include "mis_humtrafactmngtxp::RPB001xjs";

function SMRAR00100_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	//grdf_initGrid(grd_XXX); 
	//grdf_setGridSort(grd_XXX); 
	grdf_setRowTypeIcon(group3.grd_main, 0); 

	var fdate = utlf_getCurrentDate();    
	ds_main_search_maindatalist.clearData();
	
	ds_search.setColumn( 0, "instcd",   sysf_getUserInfo("dutplceinstcd"));					
	ds_search.setColumn( 0, "gadate", fdate); 
	
	var oParam = {};
	oParam.id          = "TRRAR00101";
	oParam.service     = "accountinginfoapp.AccountingInfo";
	oParam.method      = "reqGetAccountCdList";
	oParam.inds        = "req=ds_search";
	oParam.outds       = "ds_init_bankinfo=bankinfo";
	oParam.async       = false;
	//oParam.callback    = "cf_TRRAR00101";

	tranf_submit(oParam);

	frmf_addComboItem("group3.grp_sea.cmb_aactno","--전체--","","");
	



}


//조회
function fGetMainDataList()	{

	if (utlf_isNull(group3.grp_sea.cmb_aactno.value)){
		sysf_messageBox("예금계좌를 ","C002");
		group3.grp_sea.cmb_aactno.setFocus();
		return false;
	}
	//2017.02.22 가수금일자가 잘못입력된 경우를 check하도록 수정
	//if (group3.grp_sea.ipt_gadate.value == ""){
	//	sysf_messageBox("가수금일자 ","C002");
	//	return false;
	//}
	var vGadate = ds_search.getColumn(0,"gadate");
	if (vGadate.length != 8){
		group3.grp_sea.ipt_gadate.setFocus();
		sysf_messageBox("가수금일자를 확인하십시요.", "E999", "");
		return false;
	}
	if (utlf_isNull(group3.grp_sea.opt_seqline.value)){
		group3.grp_sea.opt_seqline.setFocus();
		sysf_messageBox("일자별 SEQ ","C001");
		return false;
	}
	return true;
}	

//정렬 순서로 sort함.
function fGetSortSeq(){
	var num = group3.grd_main.rows- 1;
	if(rdo_seq.value == 1){
		group3.grd_main.sort(1, 2, num, 2) = "asc";
	}else{
		group3.grd_main.sort(1, 3, num, 3) = "asc";
	}

//model.refresh();

}

//출력물순서 저장

//엑셀 입력
function fInputExcel(pGrid) {    // 엑셀 샘플 자료 필요
	var fd = new FileDialog();
	var fileName = fd.open("open", FileDialog.LOAD,"%MYDOCUMENT%");
	//var regExp = /.dat$/gi;
	
	ds_main_search_maindatalist.clearData();
	ds_main_search_maindatalist_temp.clearData();
    
    if(!utlf_isNull(fileName))  //
	{
		var objExtCommon = new ExtCommon();
		objExtCommon.excelImportByIndex(fileName.fullpath, 0,"ds_main_search_maindatalist_temp");
		
	}	
	
	var tSum = 0;
	for(var j = 1; j < ds_main_search_maindatalist_temp.rowcount; j++)
	{
		var aRow = ds_main_search_maindatalist.addRow();
		
		
		ds_main_search_maindatalist.setColumn(aRow, "gadate",  	  ds_main_search_maindatalist_temp.getColumn(j, "Col01"));   
		ds_main_search_maindatalist.setColumn(aRow, "aactcd",  	  ds_main_search_maindatalist_temp.getColumn(j, "Col02"));   
		ds_main_search_maindatalist.setColumn(aRow, "sangflag",   ds_main_search_maindatalist_temp.getColumn(j, "Col03"));   
		ds_main_search_maindatalist.setColumn(aRow, "instcd",  	  sysf_getUserInfo("dutplceinstcd"));   
		ds_main_search_maindatalist.setColumn(aRow, "seqline",    ds_search.getColumn(0, "seqline"));   
		ds_main_search_maindatalist.setColumn(aRow, "aactcd",  	  ds_search.getColumn(0, "aactcd"));    
		ds_main_search_maindatalist.setColumn(aRow, "sangcnt",    sysf_getUserInfo("dutplceinstcd"));   
		//trace('aaa   :'+parseInt(ds_main_upload_uploadlist_temp.getColumn(j, "Col04")));
		//tSum = parseInt(tSum) + parseInt(ds_main_upload_uploadlist_temp.getColumn(j, "Col04"));
		//trace('aaa   :'+parseInt(ds_main_upload_uploadlist_temp.getColumn(j, "Col04"))+"/"+tSum);
		
	}
	
	
	// 		for(var i = 1 ; i <= model.instance1.selectNodes(group3.grd_main.nodeset).length ; i++)
// 		{
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_gadate", group3.grp_sea.ipt_gadate.value);
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_aactcd", group3.grp_sea.opt_aactcd.value);
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_sangflag", "N");
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_instcd", sysf_getUserInfo("dutplceinstcd"));
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_seqline", group3.grp_sea.opt_seqline.value);
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_sangcnt", 0);
// 		}
//	}

	
	group3.cpt_gaamtsum.value = tSum;
	
}

//최종예금잔액계산
function fn_janamtaccount(){
	//JANAMT <= 최종예금잔액before - (예금출고금액-예금출고금액before) + (가수금합계-가수금합계before)
}

//저장시 입력data checking logic..
function fSetChackValue() 
{
	var updtdata = grdf_getGridUpdateData(group3.grd_main);
	if (utlf_isNull(updtdata)){
		sysf_messageBox("변경된 데이터가","I004");
		return false;
	}

	var row = group3.grd_main.rowcount;
	for ( var i = 0; i < row; i++ ) {
		//rowStatus=2:insert, 4:update, 8:delete
		var nRowstatus = ds_main_search_maindatalist.getRowType(i);
		
		//if ( group3.grd_main.rowStatus(i)=='1' || group3.grd_main.rowStatus(i)=='2' || group3.grd_main.rowStatus(i)=='4' ) {
		if ( nRowstatus == "2" || nRowstatus == "4" || nRowstatus == "8" ) {
			if ( ds_main_search_maindatalist.getColumn(i,"sangcnt") > 0 ){
				alert("상계건수가 있는 Data는 수정 또는 삭제 할 수 없습니다.");
				//group3.grd_main.row = i;
				return false;
			}
			if ( ds_main_search_maindatalist.getColumn(i,"line").length ==0 ){
				alert("NO 가 없는 Data는 입력할 수 없습니다. 입력해 주세요");
				//group3.grd_main.row = i;
				return false;
			}
			if (utlf_isNull(ds_main_search_maindatalist.getColumn(i,"gaamt"))){
				alert("가수금이 없는 Data는 입력할 수 없습니다. 입력해 주세요");
				//group3.grd_main.row = i;
				group3.grd_main.col  = group3.grd_main.colRef("gaamt");
				group3.grd_main.editCell();
				return false;
			}
			if ( ds_main_search_maindatalist.getColumn(i,"gadate").length ==0 ){
				alert("가수금일자가 없는 Data는 입력할 수 없습니다. 입력해 주세요");
				//group3.grd_main.row = i;
				return false;
			}
			if ( ds_main_search_maindatalist.getColumn(i,"gadate").length !=8 ){
				alert("가수금일자는 8자리여야 됩니다. 다시 입력해 주세요");
				//group3.grd_main.row = i;
				return false;
			}								
		}
	}
	//rtn = sysf_messageBox("", "Q002");
	//if(rtn != "6" ) return false;
	return true;
}					





function group3_grp_sea_ipt_gadate_onkillfocus(obj:Calendar, e:KillFocusEventInfo) {

	//seqline, janamt, chulamt 가져오기위한 sql..
	var oParam = {};
    oParam.id          = "TRRAR00102";
    oParam.service     = "accountinginfoapp.AccountingInfo";
    oParam.method      = "reqGetSeqlineETC";
    oParam.inds        = "req=ds_search";
    oParam.outds       = "ds_init_etcinfo=etcinfo";
    oParam.async       = false;
    //oParam.callback    = "cf_TRRAR00102";

	tranf_submit(oParam);


	ds_search.setColumn( 0, "seqline",  ds_init_etcinfo.getColumn(0, "seqline"));
	ds_search.setColumn( 0, "janamt",   ds_init_etcinfo.getColumn(0, "janamt"));
	ds_search.setColumn( 0, "chulamt", ds_init_etcinfo.getColumn(0, "chulamt"));	
	//alert("seqline ==> "+ds_init_etcinfo.getColumn(0, "seqline")+"\n janamt ==> "+ds_init_etcinfo.getColumn(0, "janamt")+"\n chulamt ==> "+ds_init_etcinfo.getColumn(0, "chulamt")+"\n" );
	group3.grp_sea.ipt_chulamt.enable = true;

//model.refresh();

	group3.grp_sea.button2.click();

}

function group3_grp_sea_opt_seqline_onkillfocus(obj:Edit, e:KillFocusEventInfo) {
    
    obj.updateToDataset();
	if ( group3.grp_sea.opt_seqline.value != 1){
		group3.grp_sea.ipt_chulamt.value = 0;
		group3.grp_sea.ipt_chulamt.enable = false;
	}else{
		group3.grp_sea.ipt_chulamt.enable = true;
	}			
	
	group3.grp_sea.button2.click();

}

function group3_grp_sea_btn_janamtsave_onclick(obj:Button, e:ClickEventInfo) {

	//alert( group3.grp_sea.ipt_janamt.value );
	//ds_send.copyData(ds_search); 
	setAlertOn();						
//						submit("TXRAR00101")
	var oParam = {};
    oParam.id          = "TXRAR00101";
    oParam.service     = "accountinginfoapp.AccountingInfo";
    oParam.method      = "reqExeSaveJanAmt";
    oParam.inds        = "req=ds_main_search_maindatalist";
    oParam.outds       = "";
    oParam.async       = false;
    //oParam.callback    = "cf_TXRAR00101";

	tranf_submit(oParam);



}

function group3_grp_sea_ipt_chulamt_onsetfocus(obj:MaskEdit, e:SetFocusEventInfo) {

	if (ds_search.getColumn(0, "seqline") != 1){
		alert("SEQ NO가 1일 경우에만 출금액을 사용할 수 있습니다.");
		group3.grp_sea.ipt_chulamt.value = 0;
		group3.grp_sea.ipt_chulamt.enable = false;
	}else{
		group3.grp_sea.ipt_chulamt.enable = true;
	}

}

function group3_grp_sea_ipt_chulamt_onkillfocus(obj:MaskEdit, e:KillFocusEventInfo) {

	//최종예금잔액계산
	fn_janamtaccount();										

}

function group3_grp_sea_button2_onclick(obj:Button, e:ClickEventInfo) {

	if( fGetMainDataList()  ) {	
					 			
		var oParam = {};
		oParam.id          = "TRRAR00103";
		oParam.service     = "accountinginfoapp.AccountingInfo";
		oParam.method      = "reqGetRADMSUSAlist";
		oParam.inds        = "req=ds_search";
		oParam.outds       = "ds_main_search_maindatalist=maindatalist ds_main_gaamtsum=gaamtsum";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAR00103";

		tranf_submit(oParam);

		ds_search.setColumn( 0, "unslno",      ds_main_search_maindatalist.getColumn(0,"unslno") );
		ds_search.setColumn( 0, "sanctslipno", ds_main_search_maindatalist.getColumn(0,"sanctslipno") );
		
		if (ds_main_gaamtsum.rowcount > 0 ) {
		    group3.cpt_gaamtsum.value = ds_main_gaamtsum.getColumn(0,"gaamtsum");
		}
    }

}

function group3_button18_onclick(obj:Button, e:ClickEventInfo) {


   misfGridIUD(group3.grd_main, "D");

	//2016.08.04 박준범 
	//- 가수금입력(UPLOAD) 프로그램과 비교에는 single row 삭제 방식이고 본 프로그램은 multi row 삭제 방식이라
	//   가수금입력(UPLOAD) 프로그램을 multi row 방식으로 변경해달라는 요청이었으나,
	//   multi row 방식이 오류가 있는 방식이라, 도리어 본 프로그램을 single row 삭제 방식으로 아래와 같이 변경처리함.
	//misfGridIUD(group3.grd_main, "D");
	//
//model.refresh();

	/*
		- 0 : read      : 조회시
		- 1 : insert    : 행추가시
		- 2 : update  : 조회한 것을 수정시
		- 3 : insert & new : 행추가한 것을 수정시
		- 4 : delete 
		- 5 : delete & insert 
		- 6 : delete & update 
	*/					       
// 	var status = group3.grd_main.rowStatus(group3.grd_main.row) ; 
// 
// 	if(status == 0) { 
// 		group3.grd_main.addStatus(group3.grd_main.row, "delete");
// 	}else if(status == 1) {
// 		group3.grd_main.deleteRow(group3.grd_main.row);
// 	}else if(status == 2) {
// 		group3.grd_main.addStatus(group3.grd_main.row, "delete");
// 	}else if(status == 3) {
// 		group3.grd_main.deleteRow(group3.grd_main.row);
// 	}else if(status == 4) {
// 		group3.grd_main.removeStatus(group3.grd_main.row, "delete");
// 	}else if(status == 5) { // insert된 data는 삭제시 위에서 addStatus("delete")하지 않고, 바로 deleteRow했기 때문에 5의 경우는 발생하지 않음.
// 		group3.grd_main.removeStatus(group3.grd_main.row, "delete");
// 	}else if(status == 6) {
// 		group3.grd_main.removeStatus(group3.grd_main.row, "delete");
// 	}

}

function group3_btn_addrow_onclick(obj:Button, e:ClickEventInfo) {

	if( fGetMainDataList()  ) {							
		misfGridIUD(group3.grd_main, "A");						

        var nRow = ds_main_search_maindatalist.rowposition;
 		if(group3.grd_main.rowcount == 1){
 			ds_main_search_maindatalist.setColumn(0,"line",1);
 		}else{
 		    var nLine = parseInt(ds_main_search_maindatalist.getColumn(nRow-1,"line")) + 1;
 		     		    
 		    ds_main_search_maindatalist.setColumn(nRow,"line",nLine);
		}
		ds_main_search_maindatalist.setColumn(nRow,"gadate",group3.grp_sea.ipt_gadate.value);
		ds_main_search_maindatalist.setColumn(nRow,"aactcd",group3.grp_sea.opt_aactcd.value);
		ds_main_search_maindatalist.setColumn(nRow,"sangflag","N");
		ds_main_search_maindatalist.setColumn(nRow,"instcd",sysf_getUserInfo("dutplceinstcd"));
		ds_main_search_maindatalist.setColumn(nRow,"seqline",group3.grp_sea.opt_seqline.value);
		ds_main_search_maindatalist.setColumn(nRow,"sangcnt",0);
		
	}		                         

}



function group3_ipt_excsave_onclick(obj:Button, e:ClickEventInfo) {

	misfSaveExcel(group3.grd_main);

}

function group3_ipt_excadd_onclick(obj:Button, e:ClickEventInfo) {

	if( fGetMainDataList()  ) {	

		fInputExcel(group3.grd_main);

		

// 		for(var i = 1 ; i <= model.instance1.selectNodes(group3.grd_main.nodeset).length ; i++)
// 		{
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_gadate", group3.grp_sea.ipt_gadate.value);
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_aactcd", group3.grp_sea.opt_aactcd.value);
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_sangflag", "N");
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_instcd", sysf_getUserInfo("dutplceinstcd"));
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_seqline", group3.grp_sea.opt_seqline.value);
// 			model.setValue(group3.grd_main.nodeset + "[" + i + "]_sangcnt", 0);
// 		}
	}

}

function group4_button39_onclick(obj:Button, e:ClickEventInfo) {

	if( fSetChackValue()  ) {		//저장시 입력data checking logic..
		//중복체크에 대한 부부이 빠져있음.
		//ds_hidden.setColumn( 0, "save",group3.grd_main.getUpdateData());
		//rtn = sysf_messageBox("", "Q002");
		//if(rtn != "6" ) return false;
		//RADMSUSA 테이블에 저장												
//						if(submit("TXRAR00102"))	{
		var oParam = {};
		oParam.id          = "TXRAR00102";
		oParam.service     = "accountinginfoapp.AccountingInfo";
		oParam.method      = "reqExeSaveRADMSUSA";
		oParam.inds        = "req=ds_main_search_maindatalist:U";
		oParam.outds       = "ds_main_save_line=line";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRAR00102";

		tranf_submit(oParam);

							//전표처리 하기위한 프로시저 실행..
							
		var oParam = {};
		oParam.id          = "TXRAR00103";
		oParam.service     = "accountinginfoapp.AccountingInfo";
		oParam.method      = "reqProcGaamt";
		oParam.inds        = "req=ds_search";
		oParam.outds       = "ds_main_save_line=line";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRAR00103";

		tranf_submit(oParam);


		group3.grp_sea.button2.click();
					
	}	

}


function group3_grp_sea_cmb_aactno_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	obj.updateToDataset();
	
	ds_search.setColumn( 0, "aactno",group3.grp_sea.cmb_aactno.label);

	
	var oParam = {};
    oParam.id          = "TRRAR00102";
    oParam.service     = "accountinginfoapp.AccountingInfo";
    oParam.method      = "reqGetSeqlineETC";
    oParam.inds        = "req=ds_search";
    oParam.outds       = "ds_init_etcinfo=etcinfo";
    oParam.async       = false;
    //oParam.callback    = "cf_TRRAR00102";

	tranf_submit(oParam);


	ds_search.setColumn( 0, "seqline",  ds_init_etcinfo.getColumn(0, "seqline"));
	ds_search.setColumn( 0, "janamt",   ds_init_etcinfo.getColumn(0, "janamt"));
	ds_search.setColumn( 0, "chulamt", ds_init_etcinfo.getColumn(0, "chulamt"));	
	//alert("seqline ==> "+ds_init_etcinfo.getColumn(0, "seqline")+"\n janamt ==> "+ds_init_etcinfo.getColumn(0, "janamt")+"\n chulamt ==> "+ds_init_etcinfo.getColumn(0, "chulamt")+"\n" );
	group3.grp_sea.ipt_chulamt.enable = true;

//model.refresh();

	group3.grp_sea.button2.click();
}

function group3_grp_sea_opt_seqline_onkeydown(obj:Edit, e:KeyEventInfo)
{
    if (e.keycode == "13") {
		obj.updateToDataset();
		if ( group3.grp_sea.opt_seqline.value != 1){
			group3.grp_sea.ipt_chulamt.value = 0;
			group3.grp_sea.ipt_chulamt.enable = false;
		}else{
			group3.grp_sea.ipt_chulamt.enable = true;
		}			
		group3.grp_sea.button2.click();
	}
}

function group3_grd_main_ontextchanged(obj:Grid, e:GridEditTextChangedEventInfo)
{
   
	if(e.col == "3") {
	   obj.updateToDataset();
	   
	   var tSum = 0;
	   for (i=0; i< ds_main_search_maindatalist.rowcount; i++); {
           tSum = parseInt(tSum) + parseInt(ds_main_search_maindatalist.getColumn(i, "gagamt"));
	   }
	   group3.cpt_gaamtsum.value = tSum;
	}
}

function group3_grd_main_onkillfocus(obj:Grid, e:KillFocusEventInfo)
{
    if(e.col == "3") {
    trace('ki');
    }
	
}

function group3_grd_main_onkeydown(obj:Grid, e:KeyEventInfo)
{
	if(e.col == "3")  {
	  if (e.keycode == "13") {
		   obj.updateToDataset();
		   
		   var tSum = 0;
		   for (i=0; i< ds_main_search_maindatalist.rowcount; i++); {
			   tSum = parseInt(tSum) + parseInt(ds_main_search_maindatalist.getColumn(i, "gagamt"));
		   }
		   group3.cpt_gaamtsum.value = tSum;
	  }
	}
}

// function group3_grp_sea_opt_seqline_onkeyup(obj:Edit, e:KeyEventInfo)
// {
// 	e.
// }
// 
// function group3_grp_sea_opt_seqline_onlbuttonup(obj:Edit, e:MouseEventInfo)
// {
// 	e.
// }
// 
// function group3_grp_sea_opt_seqline_onlbuttondown(obj:Edit, e:MouseEventInfo)
// {
// 	e.
// }
]]></Script>
  </Form>
</FDL>