YNU_JEUS/app_home/himed/xpapps/mis/slipxp/xp/SPRAD00200_전자외상매출채권upload.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPRAD00200" position="absolute 0 0 500 530" titletext="전자외상매출채권 upload" onload="SPRAD00200_onload">
    <Layouts>
      <Layout>
        <Shape position="absolute 0 74 500 80" id="line8" class="line_10"/>
        <Static text="전자외상매출채권" position="absolute 0 58 379 76" id="caption20" class="tit_2"/>
        <Grid position="absolute 0 79 500 507" id="grd_list" visible="true" binddataset="ds_main_list">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="130"/>
                <Column size="134"/>
                <Column size="122"/>
              </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="물품인수일"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow+1"/>
                <Cell col="1" displaytype="number" text="bind:keumak"/>
                <Cell col="2" text="bind:entrregno" mask="###-##-#####"/>
                <Cell col="3" text="bind:ibgoymd" mask="####-##-##"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button position="absolute 361 26 441 48" id="btn_upload" class="btn4" text="upload" onclick="btn_upload_onclick"/>
        <Button position="absolute 444 26 500 48" id="btn_acc" class="btn4" text="반영" onclick="btn_acc_onclick"/>
        <Button position="absolute 302 26 358 48" id="btn_close" class="btn4" text="닫기" onclick="btn_close_onclick"/>
        <Static text="※ upload 한 자료의 이상여부를 반드시 확인하신 후에 반영버튼을 누르십시요." position="absolute 4 508 477 528" id="caption3"/>
        <Static id="caption2" text="전자외상매출채권 upload" class="tit_1" position="absolute 0 0 217 25"/>
        <Shape id="line1" class="line_6" position="absolute 0 47 500 53"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="send" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="send"/>
          </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_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="hidden" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="hidden"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep"/>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="init" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="init"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-12-04
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
include "mis_humtrafactmngtxp::RPB001.xjs";

//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------
var arErrorCode = new HashArray();

//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------
/*-**************************************************************************************
 * Argument			: N/A
 * Description		: 
 ****************************************************************************************/
 
//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화
 ****************************************************************************************/
function SPRAD00200_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj); 
	//grdf_initGrid(grd_XXX); 
	//grdf_setGridSort(grd_list); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	misfGridInit(grd_list);
}

/****************************************************************************************
 * Components		: Button
 * Description		: upload
 ****************************************************************************************/
function btn_upload_onclick(obj:Button, e:ClickEventInfo) {
// 	var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
// 	grd_list.loadExcel(fileName, 1, true);
	grdf_ImportExcel("ds_main_list", 2, grd_list, 0);

	//금액, 사업자번호, 물품인수일에 ',' 나 '-' 문자가 있으면 없애준다.
	for(var i = 0; i < ds_main_list.rowcount; i++) {
		ds_main_list.setColumn(i, "keumak", ds_main_list.getColumn(i, "keumak").replace(",","").replace("-",""));
		ds_main_list.setColumn(i, "entrregno", ds_main_list.getColumn(i, "entrregno").replace(",","").replace("-",""));
		ds_main_list.setColumn(i, "ibgoymd", ds_main_list.getColumn(i, "ibgoymd").replace(",","").replace("-",""));
	}	
}

/****************************************************************************************
 * Components		: Button
 * Description		: 반영
 ****************************************************************************************/
function btn_acc_onclick(obj:Button, e:ClickEventInfo) {
	if( ds_main_list.rowcount < 1 ) {
		sysf_messageBox("전자외상매출채권 자료가 upload되지 않았습니다.", "E999", "");
		return;
	}

	if( sysf_messageBox("upload한 자료를 기초로 지급처를 변경하시겠습니까?" , "Q99" ) != 6 ){
		return;					
	}	

	var cnt = 0;  //지급처가 변경될 row의 건수
	var dsName = opener.grd_grntpsn1.binddataset;
	var objDs = opener.objects[dsName];
	for(var i = 0; i < ds_main_list.rowcount; i++) { //본 화면에서의 loop
		for(var k = 0; k < objDs.rowcount; k++) { //opener 에서의 loop
			//기표된 것을 대상으로, 금액, 사업자번호, 검수일자가 같으면 지급처를 전자로 변경한다.
			if(objDs.getColumn(k, "flag") == "Y" && !utlf_isNull(objDs.getColumn(k, "gipyoymd")) && objDs.getColumn(k, "keumak") == ds_main_list.getColumn(i, "keumak") 
				&& objDs.getColumn(k, "entrregno") == ds_main_list.getColumn(i, "entrregno") && objDs.getColumn(k, "ibgoymd") == ds_main_list.getColumn(i, "ibgoymd") 
				&& objDs.getColumn(k, "flagbank") != "4"  //4:전자
			) {
				objDs.setColumn(k, "flagbank", "4");  //4:전자
				grdf_setStatus(opener.grd_grntpsn1, "U", [k]);
				cnt = cnt + 1;
			}
		}	
	}

	sysf_messageBox(cnt + " 건의 자료가 변경되었습니다. ", "I999", "");

	this.close();
}

/****************************************************************************************
 * Components		: Button
 * Description		: 닫기
 ****************************************************************************************/
function btn_close_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();
}
]]></Script>
  </Form>
</FDL>