YNU_JEUS/app_home/himed/xpapps/ast/healexamstatxp/xp/SMAHS01400_월별수납현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHS01400" position="absolute 0 0 1202 791" titletext="월별수입현황" oninit="SMAHS01400_oninit" onload="SMAHS01400_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 25 1195 65" id="group2" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static text="조회월 :" position="absolute 230 12 303 29" id="caption2" class="search_name" anchor="default"/>
              <Shape position="absolute 1119 10 1125 32" linetype="vertical" id="line2" class="line_4" anchor="top right"/>
              <Button position="absolute 1129 10 1185 32" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Calendar position="absolute 307 11 412 30" id="ipt_fromdd" class="input_search" taborder="7" mask="yyyy-mm" anchor="default" autoselect="true" autoskip="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="group2_ipt_fromdd_onchanged"/>
              <Button position="absolute 1035 9 1115 31" id="btn_excelsave" class="btn7" visible="true" text="엑셀저장" anchor="top right" onclick="group2_btn_excelsave_onclick"/>
              <Combo position="absolute 115 12 215 31" id="cmb_healexamflag" innerdataset="ds_init_baseinfo_healexamflaglist_A0068" datacolumn="cdnm" codecolumn="cdid" anchor="default"/>
              <Static text="건진구분 :" position="absolute 25 13 112 30" id="caption7" class="search_name" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid position="absolute 0 76 1195 783" align="align:center middle;" id="grd_dyrcptlst" binddataset="ds_main_rcptlst_item" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="150"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </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="당일총수입"/>
                <Cell col="8" text="누  계"/>
              </Band>
              <Band id="body">
                <Cell displaytype="date" text="bind:rcptdd" calendardisplaynulltype="nulltext"/>
                <Cell col="1" text="bind:c01cnt"/>
                <Cell col="2" text="bind:g02cnt"/>
                <Cell col="3" text="bind:g05cnt"/>
                <Cell col="4" displaytype="number" style="padding:0 10 0 0;" text="bind:cardamt"/>
                <Cell col="5" displaytype="number" style="padding:0 10 0 0;" text="bind:cashamt"/>
                <Cell col="6" displaytype="number" style="padding:0 10 0 0;" text="bind:cmpyamt"/>
                <Cell col="7" displaytype="number" style="padding:0 10 0 0;" text="bind:totamt"/>
                <Cell col="8" displaytype="number" style="padding:0 10 0 0;" text="bind:sumtotamt"/>
              </Band>
              <Band id="summary">
                <Cell style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;"/>
                <Cell col="1" displaytype="number" style="padding:0 10 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('c01cnt')"/>
                <Cell col="2" displaytype="number" style="padding:0 10 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('g02cnt')"/>
                <Cell col="3" displaytype="number" style="padding:0 10 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('g05cnt')"/>
                <Cell col="4" displaytype="number" style="padding:0 10 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('cardamt')"/>
                <Cell col="5" displaytype="number" style="padding:0 10 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('cashamt')"/>
                <Cell col="6" displaytype="number" style="padding:0 10 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('cmpyamt')"/>
                <Cell col="7" displaytype="number" style="padding:0 10 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('totamt')"/>
                <Cell col="8" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption60" text="월별수입현황" class="tit_1" position="absolute 0 0 183 25"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="srchdd" type="STRING" size="256"/>
          <Column id="srchinstcd" type="STRING" size="256"/>
          <Column id="srchpid" type="STRING" size="256"/>
          <Column id="srchhealexamflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="srchdd"/>
            <Col id="srchinstcd"/>
            <Col id="srchpid"/>
            <Col id="srchhealexamflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_rcptlst_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="rcptdd" type="STRING" size="256" sumtext="수납일"/>
          <Column id="c01cnt" type="STRING" size="256" sumtext="종건인원"/>
          <Column id="g02cnt" type="STRING" size="256" sumtext="비자인원"/>
          <Column id="g05cnt" type="STRING" size="256" sumtext="비자인원"/>
          <Column id="cardamt" type="STRING" size="256" sumtext="카드금액"/>
          <Column id="cashamt" type="STRING" size="256" sumtext="현금금액"/>
          <Column id="cmpyamt" type="STRING" size="256" sumtext="대체금액"/>
          <Column id="totamt" type="STRING" size="256" sumtext="전체금액"/>
          <Column id="sumtotamt" type="STRING" size="256" sumtext="누계"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.cmb_healexamflag" propid="value" datasetid="ds_send" columnid="srchhealexamflag"/>
      <BindItem id="item1" compid="group2.ipt_fromdd" propid="value" datasetid="ds_send" columnid="srchdd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-11-13
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-11-13      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
function SMAHS01400_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAHS01400_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_dyrcptlst);

	ds_send.setColumn(0, "srchdd", String(utlf_getCurrentDate()).substr(0,6));
	
	var arrParam = [{dsNm: "ds_init_baseinfo_healexamflaglist_A0068", cdGrpId: "A0068"}
				   ,{dsNm: "ds_init_baseinfo_healexamflaglist_A0069", cdGrpId: "A0069"}
				   ,{dsNm: "ds_init_baseinfo_healexamdetlflaglist2_A0070", cdGrpId: "A0070"}
				   ,{dsNm: "ds_init_baseinfo_srchhealexamflag_A0069", cdGrpId: "A0069"}]
	appf_getCodeList(arrParam); 
 
	frmf_addComboItem("group2.cmb_healexamflag","전체","%","above"); 
	group2.cmb_healexamflag.innerdataset = "ds_init_baseinfo_healexamflaglist_A0068";
	group2.cmb_healexamflag.datacolumn = "cdnm";
	group2.cmb_healexamflag.codecolumn = "cdid";
	
	group2.cmb_healexamflag.index = 0;
}

function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRAHS01401";
		oParam.service     = "healexamstatapp.StatRef";
		oParam.method      = "reqGetMnthRcptList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_rcptlst_item=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAHS01401";

	tranf_submit(oParam);
}

function group2_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send.setColumn(0, "srchdd", String(obj.value).substr(0,6));
}

function group2_btn_excelsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_dyrcptlst, "excel", "SheetName", "true", "", "");
}
]]></Script>
  </Form>
</FDL>