YNU_JEUS/app_home/himed/xpapps/pam/rcptteamstatsxp/xp/SMPAS00120_보관금현황.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml" />
  <Form id="SMPAS00120" position="absolute 0 0 1211 784" titletext="보관금현황" onload="SMPAS00120_onload">
    <Layouts>
      <Layout>
        <Div id="group3" position="absolute 0 0 1211 13" style="">
          <Layouts>
            <Layout>
              <Static id="caption60" class="tit_1" position="absolute 0 0 183 14" style="font:돋움,,돋움;align: middle;" text="입원보관금현황" />
            </Layout>
          </Layouts>
        </Div>
        <Div id="group2" position="absolute 4 23 1207 58" style="">
          <Layouts>
            <Layout>
              <Shape id="roundrect1" anchor="default" class="roundrect_search" type="roundrectangle" position="absolute 0 0 1202 35" style="border: solid #ffd799 #ffd799;background:#fffbf2  ;" />
              <Static id="caption2" class="search_name" position="absolute 15 9 213 26" style="" text="기간                           ~" />
              <Shape id="line2" class="line_4" linetype="vertical" position="absolute 1132 7 1135 29" style="border: solid #ffe4bb #ffe4bb;" anchor="default" />
              <Button id="btn_search" class="btn1_letter2" position="absolute 1139 7 1195 29" style="" text="조회" onclick="group2_btn_search_onclick" />
              <Calendar id="input7" class="input_default" taborder="7" position="absolute 70 8 190 27" style="" anchor="default" onkeydown="group2_input7_onkeydown" />
              <Calendar id="input1" class="input_default" taborder="7" position="absolute 215 8 335 27" style="" anchor="default" onkeydown="group2_input1_onkeydown" />
              <Button id="button95" class="btn6_letter4" position="absolute 976 7 1056 29" style="" text="액셀저장" onclick="group2_button95_onclick" />
              <Button id="btn_print" class="btn6_letter2" position="absolute 1070 7 1126 29" style="" text="출력" onclick="group2_btn_print_onclick" />
              <Combo innerdataset="ds_init_kpamcd" datacolumn="cdnm" codecolumn="cdid" columncount="-1" rowcount="-1" id="combo2" position="absolute 410 8 570 27" style="" />
            </Layout>
          </Layouts>
        </Div>
        <Grid id="datagrid1" binddataset="ds_main_kpamlist" position="absolute 4 70 1206 777" style="">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="81" />
                <Column size="129" />
                <Column size="119" />
                <Column size="70" />
                <Column size="119" />
                <Column size="70" />
                <Column size="119" />
                <Column size="119" />
              </Columns>
              <Rows>
                <Row size="24" band="head" />
                <Row size="24" />
              </Rows>
              <Band id="head">
                <Cell text="보관금 계정" />
                <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:keepkind" />
                <Cell col="1" text="bind:cdnm" />
                <Cell col="2" text="bind:befkeepamt" />
                <Cell col="3" text="bind:cnt" />
                <Cell col="4" text="bind:keepamt" />
                <Cell col="5" text="bind:dccnt" />
                <Cell col="6" text="bind:dckeepamt" />
                <Cell col="7" text="bind:orgkeepamt" />
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption9" position="absolute 380 33 410 46" style="font:,,bold;" text="계정" />
      </Layout>
    </Layouts>
    <Objects>
      <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_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo />
      </Dataset>
      <Dataset id="ds_main_kpamlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="keepkind" type="STRING" size="256" />
          <Column id="cdnm" type="STRING" size="256" />
          <Column id="befkeepamt" type="STRING" size="256" />
          <Column id="cnt" type="STRING" size="256" />
          <Column id="keepamt" type="STRING" size="256" />
          <Column id="dccnt" type="STRING" size="256" />
          <Column id="dckeepamt" type="STRING" size="256" />
          <Column id="orgkeepamt" type="STRING" size="256" />
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="keepkind"></Col>
            <Col id="cdnm"></Col>
            <Col id="befkeepamt"></Col>
            <Col id="cnt"></Col>
            <Col id="keepamt"></Col>
            <Col id="dccnt"></Col>
            <Col id="dckeepamt"></Col>
            <Col id="orgkeepamt"></Col>
          </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="fromdd" type="STRING" size="256" />
          <Column id="todd" type="STRING" size="256" />
          <Column id="kpamcd" type="STRING" size="256" />
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"></Col>
            <Col id="todd"></Col>
            <Col id="kpamcd">%</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_kpamcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256" />
          <Column id="cdid" type="STRING" size="256" />
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.input7" propid="value" datasetid="ds_send" columnid="fromdd" />
      <BindItem id="item1" compid="group2.input1" propid="value" datasetid="ds_send" columnid="todd" />
      <BindItem id="item2" compid="group2.combo2" propid="value" datasetid="ds_send" columnid="kpamcd" />
    </Bind>
    <Script type="xscript4.0"><![CDATA[function SMPAS00120_onload(obj:Form, e:LoadEventInfo) {
 frmf_initForm(obj); 
 //grdf_initGrid(grd_XXX); 
 //grdf_setGridSort(grd_XXX); 
 //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

					var vToday = new Date();
					var tmpYear = vToday.getYear();
					var tmpMonth = vToday.getMonth()+1;
					var tmpDate = vToday.getDate();

					if (tmpMonth < 10) { tmpMonth = "0"+tmpMonth; }
					if (tmpDate < 10) { tmpDate = "0"+tmpDate; }
					ds_send.setColumn( 0, "fromdd", tmpYear+""+tmpMonth+""+tmpDate);
					ds_send.setColumn( 0, "todd", tmpYear+""+tmpMonth+""+tmpDate);					

//model.refresh();

//group2.input7.refresh();

//group2.input1.refresh();

					datagrid1.explorerbar = "sort";

//					if (!submit("TRPAS00122")) {
var oParam = {};
    oParam.id          = "TRPAS00122";
    oParam.service     = "rcptteamstatsapp.rcptTeamOrdStats";
    oParam.method      = "reqGetKpamCdList";
    oParam.inds        = "req=ds_";
    oParam.outds       = "ds_=kpamcd";
    oParam.async       = false;
    oParam.callback    = "cf_TRPAS00122";

tranf_submit(oParam);
/*
function cf_TRPAS00122(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
}
function cf_TRPAS00122(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
}
arErrorCode.pop("TRPAS00122") > -1
arErrorCode.pop("TRPAS00122") < 0
*/


						sysf_messageBox("계정코드 조회 중 오류..!", "E999");
					}

}

include '../../.._com_commonweb_js_common.js'
include '../../.._com_commonweb_js_utilHelper.js'
include '../../.._com_commonweb_js_tfHelper.js'
include '../../.._com_commonweb_js_dateHelper.js'
include '../../.._com_commonweb_js_numericHelper.js'
include '../../.._com_commonweb_js_stringHelper.js'
include '../../.._com_basiccodeweb_js_ZBC001.js'
include '../../.._com_zipcodeweb_js_ZBP001.js'

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

//						submit("TRPAS00121");
var oParam = {};
    oParam.id          = "TRPAS00121";
    oParam.service     = "rcptteamstatsapp.rcptTeamOrdStats";
    oParam.method      = "reqGetInKpamList";
    oParam.inds        = "req=ds_";
    oParam.outds       = "ds_=kpamlist";
    oParam.async       = false;
    oParam.callback    = "cf_TRPAS00121";

tranf_submit(oParam);
/*
function cf_TRPAS00121(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
}
function cf_TRPAS00121(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
}
arErrorCode.pop("TRPAS00121") > -1
arErrorCode.pop("TRPAS00121") < 0
*/



}

function group2_input7_onkeydown(obj:Calendar, e:KeyEventInfo) {

						if( event.keyCode == 13 ) {

							var pCurTargetObj = event.ptarget.parent;

							if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
								event.keyCode = 9;
								pCurTargetObj.dispatch("onkeydown");
							}
							else {

								event.keyCode = 9;	
							}
						}
						event.stopPropagation();							

}

function group2_input1_onkeydown(obj:Calendar, e:KeyEventInfo) {

						if( event.keyCode == 13 ) {

							var pCurTargetObj = event.ptarget.parent;

							if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
								event.keyCode = 9;
								pCurTargetObj.dispatch("onkeydown");
							}
							else {

								event.keyCode = 9;	
							}
						}
						event.stopPropagation();							

}

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

					var vToday = new Date();
					var tmpYear = vToday.getYear();
					var tmpMonth = vToday.getMonth()+1;
					var tmpDate = vToday.getDate();

//					
//					 ds_documenttitle.setColumn( 0, "title",document.title);
//                                      
//model.refresh();

//					var  subjectTitle = ds_documenttitle.getColumn(0, "title");

					//엑셀저장 여부(타이틀별)
					var fileName = window.fileDialog("save", "", false, "보관금현황"+tmpYear+tmpMonth+tmpDate, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");

						if (fileName != "")
						{
							datagrid1.saveExcel(fileName, "보관금현황"+tmpYear+tmpMonth+tmpDate, true, true, "", "", true);
						}

}

function group2_btn_print_onclick(obj:Button, e:ClickEventInfo) {
    var objDOM = rptf_createDOM();
    var objParam = new Object();
    rptf_setNodeListToDOM(objDOM, "/root/XXX" , ds_XXX);
    objParam.xml_data_XML1 	= objDOM.documentElement.source;
    var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
    rptf_exeReportPreview30(["RPPAS00121"],[objParam], option);	

}

]]></Script>
  </Form>
</FDL>