YNU_JEUS/app_home/himed/xpapps/mis/slipxp/xp/SMRAD03300_구매검수자료내역조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAD03300" position="absolute 0 0 1196 800" titletext="구매검수자료내역조회" onload="SMRAD03300_onload">
    <Layouts>
      <Layout>
        <Div id="grp_sea" anchor="left top right" taborder="7" class="div_SA" position="absolute 0 25 1195 65"/>
        <Static id="caption6" text="구매검수자료내역조회" class="tit_1" position="absolute 0 0 184 25"/>
        <Button id="btn_search" taborder="1" text="조회" class="btn1" position="absolute 1126 35 1182 57" anchor="right" onclick="btn_search_onclick"/>
        <Shape id="line13" linetype="vertical" class="line_4" visible="false" position="absolute 1110 35 1116 57" anchor="right"/>
        <Shape id="line1" class="line_10" position="absolute 0 89 1195 95" anchor="left top right"/>
        <Combo id="cmb_instcd" taborder="2" class="combo_essential" enable="false" position="absolute 78 36 193 55"/>
        <Static id="caption2" text="기관 :" class="search_name" position="absolute 12 37 73 54"/>
        <Grid id="grd_grntpsn1" taborder="3" binddataset="ds_main_grnt_grntlist2" useinputpanel="false" position="absolute 0 94 1195 799" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="106"/>
                <Column size="49"/>
                <Column size="107"/>
                <Column size="59"/>
                <Column size="76"/>
                <Column size="230"/>
                <Column size="58"/>
                <Column size="303"/>
                <Column size="156"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" colspan="2" text="계약일자" taborder="undefined"/>
                <Cell col="3" colspan="2" text="입고일자" taborder="undefined"/>
                <Cell col="5" colspan="2" text="품목계정" taborder="undefined"/>
                <Cell col="7" colspan="2" text="거래처" taborder="undefined"/>
                <Cell col="9" text="금액"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow+1"/>
                <Cell col="1" text="bind:kydate" mask="####-##-##"/>
                <Cell col="2" text="bind:kyseq"/>
                <Cell col="3" text="bind:ibgoymd" mask="####-##-##"/>
                <Cell col="4" text="bind:ibgoseq"/>
                <Cell col="5" text="bind:acctid"/>
                <Cell col="6" displaytype="text" text="bind:acntnm"/>
                <Cell col="7" text="bind:custcode"/>
                <Cell col="8" displaytype="text" text="bind:custnm"/>
                <Cell col="9" displaytype="number" text="bind:keumak"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Calendar id="ipt_unsldd" taborder="4" class="input_essential" position="absolute 355 36 439 55" mask="yyyy-mm" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onkillfocus="ipt_unsldd_onkillfocus"/>
        <Static id="caption1" text="구매검수현황" class="tit_2" position="absolute 0 73 131 90"/>
        <Static id="caption4" text="총금액" position="absolute 924 71 969 91" style="font:Dotum,9,bold;" anchor="right"/>
        <MaskEdit id="input2" taborder="5" mask="(-)#,###" position="absolute 973 70 1112 89" anchor="right"/>
        <Static id="caption3" text="기준년월 :" class="search_name" position="absolute 265 37 351 54"/>
        <Button id="btn_savegrntpsn1excel" taborder="6" text="엑셀저장" class="btn7" position="absolute 1115 67 1195 89" anchor="right" onclick="btn_savegrntpsn1excel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_save_grntlist1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="grntlist1" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="grntlist1"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_custinfo_custlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="aactno" type="STRING" size="256"/>
          <Column id="bankcd" type="STRING" size="256"/>
          <Column id="depor" type="STRING" size="256"/>
          <Column id="custnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="aactno"/>
            <Col id="bankcd"/>
            <Col id="depor"/>
            <Col id="custnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_paydedu" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="totamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="totamt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_acntinfo_acntlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="acntnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="acntnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_grnt_grntlist2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="kydate" type="STRING" size="256"/>
          <Column id="kyseq" type="STRING" size="256"/>
          <Column id="ibgoymd" type="STRING" size="256"/>
          <Column id="ibgoseq" type="STRING" size="256"/>
          <Column id="acctid" type="STRING" size="256"/>
          <Column id="acntnm" type="STRING" size="256"/>
          <Column id="custcode" type="STRING" size="256"/>
          <Column id="custnm" type="STRING" size="256"/>
          <Column id="keumak" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="kydate"/>
            <Col id="kyseq"/>
            <Col id="ibgoymd"/>
            <Col id="ibgoseq"/>
            <Col id="acctid"/>
            <Col id="acntnm"/>
            <Col id="custcode"/>
            <Col id="custnm"/>
            <Col id="keumak"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="pumno" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="cmb_instcd" propid="value" datasetid="ds_send_paydedu" columnid="instcd"/>
      <BindItem id="item1" compid="ipt_unsldd" propid="value" datasetid="ds_send_paydedu" columnid="fromdd"/>
      <BindItem id="item2" compid="input2" propid="value" datasetid="ds_send_paydedu" columnid="totamt"/>
    </Bind>
    <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_paybaseinfomngtxp::RWC001.xjs";
include "mis_humtrafactmngtxp::RPB001.xjs";
include "mis_miscommonxp::RAC001.xjs";
include "mis_acntcommonxp::RAD001.xjs";

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

//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------
/*-**************************************************************************************
 * Argument			: N/A
 * Description		: 초기화
 ****************************************************************************************/
function initialize(){
	misfGridInit(grd_grntpsn1);
	misfMsterDetailSet(grd_grntpsn1,null, "TRRAD03301" ,"Y"); 	

	var curdate = utlf_getCurrentDate();

	cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");
	var deptcd = sysf_getUserInfo("dutplcecd");
	var deptnm = sysf_getUserInfo("dutplcenm");
	ds_send_paydedu.setColumn( 0, "fromdd", curdate.substr(0, 6));
	
	misfComboInstCdListMulti("cmb_instcd",utlf_getCurrentDate(),"","N");
	ipt_unsldd.setFocus();
}
 
//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화
 ****************************************************************************************/
function SMRAD03300_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj); 
	//grdf_initGrid(grd_XXX); 
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	initialize();	
}

/****************************************************************************************
 * Components		: Button
 * Description		: 조회
 ****************************************************************************************/
function btn_search_onclick(obj:Button, e:ClickEventInfo) {
	misfMsterDetailRetrieve(); 
	
	var totamt = 0;
	var amt = 0;
	for (var i = 0; i < ds_main_grnt_grntlist2.rowcount; i++){
		amt = dsf_getColumnNullToEmpty(ds_main_grnt_grntlist2, i, "keumak");
		if (isNaN(amt) || amt == ""){
			amt = 0;
		}
		totamt = parseFloat(totamt) + parseFloat(amt);
	}
	ds_send_paydedu.setColumn( 0, "totamt", totamt);
}

/****************************************************************************************
 * Components		: Button
 * Description		: 엑셀저장
 ****************************************************************************************/
function btn_savegrntpsn1excel_onclick(obj:Button, e:ClickEventInfo) {
	misfSaveExcel(grd_grntpsn1, "excel");
}

function ipt_unsldd_onkillfocus(obj:Calendar, e:KillFocusEventInfo)
{
	ds_send_paydedu.setColumn(0, "fromdd", obj.text);
}
]]></Script>
  </Form>
</FDL>