YNU_JEUS/app_home/himed/xpapps/pam/rcptteamstatsxp/xp/SMPAS00172_현금영수증거래내역관리.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPAS00172" position="absolute 0 0 1211 722" titletext="현금영수증거래내역관리" onload="SMPAS00172_onload">
    <Layouts>
      <Layout>
        <Tab id="switch1" position="absolute 0 25 1195 710" style="" anchor="all">
          <Tabpages>
            <Tabpage id="case1" selected="true" anchor="default" text="수납자별 현금영수증내역">
              <Layouts>
                <Layout>
                  <Div id="group2" position="absolute 0 4 1195 44" style="" class="div_SA2" anchor="left top right">
                    <Layouts>
                      <Layout>
                        <Static id="caption2" class="search_name" position="absolute 13 12 78 29" style="" text="기간 :" anchor="default"/>
                        <Shape id="line2" class="line_4" linetype="vertical" position="absolute 1113 8 1116 30" style="border: solid #ffe4bb #ffe4bb;" anchor="top right"/>
                        <Shape id="line1" class="line_4" linetype="vertical" position="absolute 1039 8 1042 30" style="border: solid #ffe4bb #ffe4bb;" anchor="top right"/>
                        <Button id="btn_case1_excel" class="btn7" position="absolute 952 8 1032 30" style="" text="엑셀저장" onclick="switch1_case1_group2_btn_case1_excel_onclick" anchor="top right"/>
                        <Button id="btn_case1_print" class="btn6" position="absolute 1047 8 1103 30" style="" text="출력" onclick="switch1_case1_group2_btn_case1_print_onclick" anchor="top right"/>
                        <Button id="btn_case1_search" class="btn1" position="absolute 1120 8 1176 30" style="" text="조회" onclick="switch1_case1_group2_btn_case1_search_onclick" anchor="top right"/>
                        <Calendar id="ipt_case1_fromdd" class="input_default" taborder="7" position="absolute 70 11 168 30" style="" anchor="default" onkeydown="switch1_case1_group2_ipt_case1_fromdd_onkeydown" dateformat="yyyy-MM-dd" value="null" autoselect="true" autoskip="true"/>
                        <Calendar id="ipt_case1_todd" class="input_default" taborder="7" position="absolute 189 11 287 30" style="" anchor="default" onkeydown="switch1_case1_group2_ipt_case1_todd_onkeydown" dateformat="yyyy-MM-dd" autoselect="true" autoskip="true"/>
                        <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="cmb_case1" visible="false" position="absolute 293 11 413 30" style="" anchor="default">
                          <Dataset id="innerdataset">
                            <ColumnInfo>
                              <Column id="codecolumn"/>
                              <Column id="datacolumn"/>
                            </ColumnInfo>
                            <Rows>
                              <Row>
                                <Col id="codecolumn">ALL</Col>
                                <Col id="datacolumn">전체</Col>
                              </Row>
                              <Row>
                                <Col id="codecolumn">DIV</Col>
                                <Col id="datacolumn">항목별</Col>
                              </Row>
                            </Rows>
                          </Dataset>
                        </Combo>
                        <Static id="caption3" position="absolute 170 13 190 28" style="align:center ;" text="~" anchor="default"/>
                      </Layout>
                    </Layouts>
                  </Div>
                  <Grid id="grd_case1" binddataset="ds_main_case1_h_cash_cash" position="absolute 0 54 1195 653" style="" oncelldblclick="switch1_case1_grd_case1_oncelldblclick" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="100"/>
                          <Column size="110"/>
                          <Column size="140"/>
                          <Column size="110"/>
                          <Column size="140"/>
                          <Column size="110"/>
                          <Column size="140"/>
                        </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="전체금액"/>
                        </Band>
                        <Band id="body">
                          <Cell style="align:left middle;" text="bind:rcptridnm"/>
                          <Cell col="1" displaytype="number" text="bind:cashamt_s_cnt" mask="#,##0"/>
                          <Cell col="2" displaytype="number" text="bind:cashamt_s" mask="#,##0"/>
                          <Cell col="3" displaytype="number" text="bind:cashamt_c_cnt" mask="#,##0"/>
                          <Cell col="4" displaytype="number" text="bind:cashamt_c" mask="#,##0"/>
                          <Cell col="5" displaytype="number" text="bind:cashamt_t_cnt" mask="#,##0"/>
                          <Cell col="6" displaytype="number" text="bind:cashamt_t" mask="#,##0"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Shape id="line8" class="line_10" linetype="horizontal" position="absolute 0 50 1195 54" style="" anchor="left top right"/>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Static id="caption1" class="tit_1" position="absolute 0 0 132 23" style="" text="현금영수증관리"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_case1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_init_PAM_P0008list_P0008" 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"/>
          <Column id="detl" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <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_PAM_P0008list" 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_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_init_PAM" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <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="session" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="session"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_case1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="ddflag" type="STRING" size="256"/>
          <Column id="fromdata" type="STRING" size="256"/>
          <Column id="todata" type="STRING" size="256"/>
          <Column id="datagubun" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="ddflag"/>
            <Col id="fromdata"/>
            <Col id="todata"/>
            <Col id="datagubun"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_case1_h_cash" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_main_case1_h_cash_cash" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="rcptrid" type="STRING" size="256"/>
          <Column id="rcptridnm" type="STRING" size="256"/>
          <Column id="cashamt_s_cnt" type="STRING" size="256"/>
          <Column id="cashamt_s" type="STRING" size="256"/>
          <Column id="cashamt_c_cnt" type="STRING" size="256"/>
          <Column id="cashamt_c" type="STRING" size="256"/>
          <Column id="cashamt_t_cnt" type="STRING" size="256"/>
          <Column id="cashamt_t" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="rcptrid"/>
            <Col id="rcptridnm"/>
            <Col id="cashamt_s_cnt"/>
            <Col id="cashamt_s"/>
            <Col id="cashamt_c_cnt"/>
            <Col id="cashamt_c"/>
            <Col id="cashamt_t_cnt"/>
            <Col id="cashamt_t"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_session" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="switch1.case1.group2.ipt_case1_fromdd" propid="value" datasetid="ds_send_case1" columnid="fromdata"/>
      <BindItem id="item1" compid="switch1.case1.group2.ipt_case1_todd" propid="value" datasetid="ds_send_case1" columnid="todata"/>
      <BindItem id="item2" compid="switch1.case1.group2.cmb_case1" propid="value" datasetid="ds_send_case1" columnid="datagubun"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[include 'com_commonxp::comm_main.xjs';
include 'com_basiccodexp::ZBC001.xjs';
include 'com_zipcodexp::ZBP001.xjs';
include 'pam_pamcomnxp::PAM001.xjs';

function SMPAS00172_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	grdf_initGrid(switch1.case1.grd_case1);
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	fGetUserInfo2();

	fReady_case1();
	
	switch1.tabindex = 0;

}

//로그인한 사용자 정보조회
function fGetUserInfo2(){

	var sUserInfosS = sysf_getUserInfos(); 

	sUserInfosS = sUserInfosS + "|";
	var UserInfosS_Array = sUserInfosS.split("|");

	var userid        	 = UserInfosS_Array[0];  //사용자번호
	var usernm        = UserInfosS_Array[1];  //사용자이름
	var posinstcd     = UserInfosS_Array[2];  //소속기관코드
	var posinstnm     = UserInfosS_Array[3];  //소속기관명
	var dutplcecd     = UserInfosS_Array[4];  //근무지부서코드
	var dutplcenm     = UserInfosS_Array[5];  //근무지부서명
	var dutinstnm      = UserInfosS_Array[7];  //근무지기관명

	dsf_makeValue( ds_hidden_session, "userid", "string", userid);
	dsf_makeValue( ds_hidden_session, "usernm", "string", usernm);
	dsf_makeValue( ds_hidden_session, "dutinstnm", "string", dutinstnm);		
}

function fReady_case1(){

	var arrParam = [ {dsNm: "ds_init_PAM_P0008list_P0008", cdGrpId: "P0008" } ];
	pamfGetCodeList(arrParam);

	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_case1.setColumn( 0, "fromdata", tmpYear+""+tmpMonth+""+tmpDate);
	ds_send_case1.setColumn( 0, "todata", tmpYear+""+tmpMonth+""+tmpDate);		

	ds_send_case1.setColumn( 0, "datagubun" , "ALL");

//switch1.case1.group2.ipt_case1_fromdd.refresh();

//switch1.case1.group2.ipt_case1_todd.refresh();

//cmb_switch1.case1.refresh();

//	grd_switch1.case1.explorerbar = "sort";

}

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

// 	var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
// 
// 	if (fileName != "")
// 	{
		grdf_exportExcel(switch1.case1.grd_case1, "Sheet1", "현금영수증거래내역관리", false, "" , 'user' , true);
//	}

}

function switch1_case1_group2_btn_case1_print_onclick(obj:Button, e:ClickEventInfo) {
    var objDOM = rptf_createDOM();
    var objParam = new Object();
    rptf_setNodeListToDOM(objDOM, "root/main/case1/h_cash/cash" , ds_main_case1_h_cash_cash);
    rptf_setNodeListToDOM(objDOM, "root/hidden/session" , ds_hidden_session);
    rptf_setNodeListToDOM(objDOM, "root/send/case1" , ds_send_case1);
    objParam.xml_data_XML1 	= objDOM.documentElement.source;
    var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
    rptf_exeReportPreview30(["RPPAS00173"],[objParam], option);	

}

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

	var  fromdata =  ds_send_case1.getColumn(0, "fromdata");
	var  todata     =  ds_send_case1.getColumn(0, "todata");
	if(utlf_isNull(fromdata))
	{
		sysf_messageBox("시작일을 입력","E007");
		input7.setFocus();
		return false;
	}
	if(utlf_isNull(todata))
	{
		sysf_messageBox("끝일을 입력","E007");
		input1.setFocus();
		return false;
	}
	if(fromdata > todata)
	{
		sysf_messageBox("시작일이 끝일자보다 클수 ", "C001")
		return false;
	}
	else
	{

		//submit("TRPAS00176");							
		var oParam = {};
		oParam.id          = "TRPAS00176";
		oParam.service     = "rcptteamstatsapp.rcptTeamOrdStats";
		oParam.method      = "reqGetCashamtList";
		oParam.inds        = "req=ds_send_case1";
		oParam.outds       = "ds_main_case1_h_cash_cash=cash";
		oParam.async       = false;
		tranf_submit(oParam);

		grdf_setRowStyle(switch1.case1.grd_case1, "2" , "합계" , "rcptridnm" , "equal");

	}				

}

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

	if( e.keycode == 13 ) {	
		switch1.case1.group2.ipt_case1_todd.setFocus();
// 		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 switch1_case1_group2_ipt_case1_todd_onkeydown(obj:Calendar, e:KeyEventInfo) {

	if( e.keycode == 13 ) {	
		switch1.case1.group2.btn_case1_search.setFocus();
// 		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 switch1_case1_grd_case1_oncelldblclick(obj:Grid, e:GridClickEventInfo) {

	var row = ds_main_case1_h_cash_cash.rowposition; 

	var rcptrid = ds_main_case1_h_cash_cash.getColumn(row, "rcptrid");

	if(rcptrid == "합계") rcptrid = "합계";

	var parm = ds_send_case1.getColumn(0, "fromdata") 	+ "▦" +	//시작일자
			   ds_send_case1.getColumn(0, "todata") 	 	+ "▦" +	//종료일자
			   ds_main_case1_h_cash_cash.getColumn(row, "rcptrid") + "▦";

	frmf_setParameter("SMPAS00172_PARM", parm);

	frmf_modal("SPPAO00403", "SPPAO00403", "", "", "", "", "", "", "", "", "", "", "M");  //현금영수증전표

}

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