YNU_JEUS/app_home/himed/xpapps/ast/healexamstatxp/xp/SMAHS00600_신용카드사별수익실적.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHS00600" position="absolute 0 0 1211 784" titletext="건진일평균인원현황" oninit="SMAHS00600_oninit" onload="SMAHS00600_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 25 1195 65" id="group2" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape position="absolute 1118 9 1124 31" linetype="vertical" id="line2" class="line_4" anchor="top right"/>
              <Button position="absolute 1128 9 1184 31" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Calendar position="absolute 82 11 187 30" id="ipt_fromdd" class="input_search" taborder="7" anchor="default" autoskip="true" autoselect="true"/>
              <Button position="absolute 965 9 1045 31" id="btn_excelsave" class="btn7" visible="true" text="엑셀저장" anchor="top right" onclick="group2_btn_excelsave_onclick"/>
              <Button position="absolute 1059 9 1115 31" id="btn_prt" class="btn6" text="출력" anchor="top right" onclick="group2_btn_prt_onclick"/>
              <Shape position="absolute 1049 9 1055 31" linetype="vertical" id="line3" class="line_4" visible="false" anchor="top right"/>
              <Static text="~" position="absolute 193 13 205 30" id="caption93" class="search_n_b" anchor="default"/>
              <Calendar position="absolute 210 11 315 30" id="input1" class="input_search" taborder="7" anchor="default" autoskip="true" autoselect="true"/>
              <Static text="기간 :" position="absolute 15 12 88 29" id="caption2" class="search_name" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Tab position="absolute 0 73 1195 764" id="swt_card" anchor="all">
          <Tabpages>
            <Tabpage text="카드사별수입" id="case_card">
              <Layouts>
                <Layout>
                  <Grid position="absolute 0 3 1195 658" id="grd_cardlst" binddataset="ds_main_cardlst_card" autoenter="select" cellsizingtype="col" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="120"/>
                          <Column size="60"/>
                          <Column size="130"/>
                          <Column size="130"/>
                          <Column size="130"/>
                          <Column size="0"/>
                          <Column size="130"/>
                          <Column size="200"/>
                        </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="비고"/>
                        </Band>
                        <Band id="body">
                          <Cell style="align:left middle;padding:0 0 0 5;" text="bind:cardcmpynm"/>
                          <Cell col="1" style="align:right middle;padding:0 5 0 0;" text="bind:cardcnt"/>
                          <Cell col="2" displaytype="number" style="padding:0 5 0 0;" text="bind:crtcardamt"/>
                          <Cell col="3" displaytype="number" style="padding:0 5 0 0;" text="bind:comsamt"/>
                          <Cell col="4" displaytype="number" style="padding:0 5 0 0;" text="bind:depoamt"/>
                          <Cell col="5" text="bind:uncoamt" mask="(-,+)#,###"/>
                          <Cell col="6" displaytype="date" text="bind:depodd" calendardisplaynulltype="nulltext"/>
                          <Cell col="7" displaytype="text" edittype="text" style="padding:0 0 0 5;" text="bind:remfact"/>
                        </Band>
                        <Band id="summary">
                          <Cell style="align:left middle;padding:0 0 0 5;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="총계"/>
                          <Cell col="1" displaytype="number" style="align:right middle;padding:0 5 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('cardcnt')"/>
                          <Cell col="2" displaytype="number" style="padding:0 5 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('crtcardamt')"/>
                          <Cell col="3" displaytype="number" style="padding:0 5 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('comsamt')"/>
                          <Cell col="4" displaytype="number" style="padding:0 5 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('depoamt')"/>
                          <Cell col="5" style="padding:0 5 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('uncoamt')"/>
                          <Cell col="6" style="padding:0 5 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;"/>
                          <Cell col="7" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage text="카드사별수입내역" id="case_carddetl">
              <Layouts>
                <Layout>
                  <Grid position="absolute 0 3 1195 658" id="grd_carddetllst" binddataset="ds_main_cardlst_carddetl" anchor="all" autoenter="select" cellsizingtype="col">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="120"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="130"/>
                          <Column size="130"/>
                          <Column size="130"/>
                          <Column size="200"/>
                          <Column size="100"/>
                        </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 style="align:left middle;padding:0 0 0 3;background:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');color:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');color2:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:cardcmpynm" suppress="1" suppressalign="middle,over"/>
                          <Cell col="1" displaytype="date" style="background:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');color:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');color2:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:rcptexecdd" calendardisplaynulltype="nulltext"/>
                          <Cell col="2" style="background:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');color:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');color2:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:rcptid"/>
                          <Cell col="3" style="background:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');color:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');color2:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:rcptnm"/>
                          <Cell col="4" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');color:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');color2:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:crtcardamt"/>
                          <Cell col="5" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');color:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');color2:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:comsamt"/>
                          <Cell col="6" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');color:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');color2:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:depoamt"/>
                          <Cell col="7" style="align:right middle;padding:0 5 0 0;background:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');color:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');color2:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:cardno"/>
                          <Cell col="8" style="align:right middle;padding:0 5 0 0;background:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#7CBBDD' : '');color:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');color2:EXPR(getRowLevel(currow) == 1 ? '#ffffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:aprvno"/>
                        </Band>
                        <Band id="summary">
                          <Cell style="align:left middle;padding:0 0 0 5;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="총계"/>
                          <Cell col="1" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="2" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="3" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="4" displaytype="number" style="padding:0 5 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('crtcardamt')"/>
                          <Cell col="5" displaytype="number" style="padding:0 5 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('comsamt')"/>
                          <Cell col="6" displaytype="number" style="padding:0 5 0 0;background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('depoamt')"/>
                          <Cell col="7" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="8" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <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="srchfromdd" type="STRING" size="256"/>
          <Column id="srchtodd" type="STRING" size="256"/>
          <Column id="srchinstcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="srchfromdd"/>
            <Col id="srchtodd"/>
            <Col id="srchinstcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_cardlst_card" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cardcmpynm" type="STRING" size="256" sumtext="카드사명"/>
          <Column id="cardcnt" type="INT" size="256" sumtext="건수"/>
          <Column id="crtcardamt" type="INT" size="256" sumtext="발생금액"/>
          <Column id="comsamt" type="INT" size="256" sumtext="수수료"/>
          <Column id="depodd" type="STRING" size="256" sumtext="입금일"/>
          <Column id="depoamt" type="INT" size="256" sumtext="입금액"/>
          <Column id="uncoamt" type="INT" size="256" sumtext="미수액"/>
          <Column id="remfact" type="STRING" size="256" sumtext="비고"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cardlst_carddetl" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cardcmpynm" type="STRING" size="256" sumtext="소계" prop="TEXT"/>
          <Column id="rcptexecdd" type="STRING" size="256" sumtext="입금일자"/>
          <Column id="rcptid" type="STRING" size="256" sumtext="등록번호"/>
          <Column id="rcptnm" type="STRING" size="256" sumtext="성명" prop="COUNT"/>
          <Column id="crtcardamt" type="BIGDECIMAL" size="256" sumtext="발생금액"/>
          <Column id="comsamt" type="BIGDECIMAL" size="256" sumtext="수수료"/>
          <Column id="depoamt" type="BIGDECIMAL" size="256" sumtext="입금액"/>
          <Column id="cardno" type="STRING" size="256" sumtext="카드번호"/>
          <Column id="aprvno" type="STRING" size="256" sumtext="승인번호"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_baseinfo_healexamflaglist_A0068" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_baseinfo_healexamdetlflaglist_A0069" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_baseinfo_healexamdetlflaglist2_A0070" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_temp_cardlst_carddetl" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.ipt_fromdd" propid="value" datasetid="ds_send" columnid="srchfromdd"/>
      <BindItem id="item1" compid="group2.input1" propid="value" datasetid="ds_send" columnid="srchtodd"/>
    </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 SMAHS00600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAHS00600_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(swt_card.case_card.grd_cardlst);
	grdf_initGrid(swt_card.case_carddetl.grd_carddetllst);
	
	ds_send.setColumn(0, "srchfromdd" , utlf_getCurrentDate());
	ds_send.setColumn(0, "srchtodd" , utlf_getCurrentDate());
	ds_send.setColumn(0, "srchinstcd" , sysf_getUserInfo("posinstcd"));

	var arrParam = [{dsNm: "ds_init_baseinfo_healexamflaglist_A0068", cdGrpId: "A0068"}
				   ,{dsNm: "ds_init_baseinfo_healexamdetlflaglist_A0069", cdGrpId: "A0069"}
				   ,{dsNm: "ds_init_baseinfo_healexamdetlflaglist2_A0070", cdGrpId: "A0070"}]
	appf_getCodeList(arrParam); 
}

function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRAHS00601";
		oParam.service     = "healexamstatapp.StatRef";
		oParam.method      = "reqGetCardList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_cardlst_card=card ds_main_cardlst_carddetl=carddetl";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAHS00601";

	tranf_submit(oParam);
	
	ds_temp_cardlst_carddetl.copyData(ds_main_cardlst_carddetl);
	ds_main_cardlst_carddetl.keystring = "G:cardcmpynm";
}

function group2_btn_excelsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(swt_card.case_card.grd_cardlst, "excel", "SheetName", "true", "", "");
}

function group2_btn_prt_onclick(obj:Button,  e:ClickEventInfo)
{
	var idx = swt_card.tabindex;

// 	model.makeValue("/root/main/export/srchfromdd" ,  model.getValue("/root/send/srchfromdd").toDate().getDateFormat("YYYY/MM/DD"));
// 	model.makeValue("/root/main/export/srchtodd" ,  model.getValue("/root/send/srchtodd").toDate().getDateFormat("YYYY/MM/DD"));
	
	if(idx == 0) 
	{
		var objDOM = rptf_createDOM();
			rptf_setNodeListToDOM(objDOM, "/root/main/cardlst/card", ds_main_cardlst_card);
		var objParam = new Object();
			objParam.xml_data_XML1 = objDOM.documentElement.source; 
			objParam.srchfromdd = ds_send.getColumn(0, "srchfromdd").toDate().getDateFormat("YYYY/MM/DD");
			objParam.srchtodd = ds_send.getColumn(0, "srchtodd").toDate().getDateFormat("YYYY/MM/DD")
			
		var option = ""; 
		rptf_exeReportPreview30(["RPAHS00601"],[objParam], option);
	}
	else if(idx == 1)
	{
		var objDOM = rptf_createDOM();
			rptf_setNodeListToDOM(objDOM, "/root/main/cardlst/carddetl", ds_temp_cardlst_carddetl);
		var objParam = new Object();
			objParam.xml_data_XML1 = objDOM.documentElement.source; 
			objParam.srchfromdd = ds_send.getColumn(0, "srchfromdd").toDate().getDateFormat("YYYY/MM/DD");
			objParam.srchtodd = ds_send.getColumn(0, "srchtodd").toDate().getDateFormat("YYYY/MM/DD")
			
		var option = ""; 
		rptf_exeReportPreview30(["RPAHS00602"],[objParam], option);
	}
}
]]></Script>
  </Form>
</FDL>