YNU_JEUS/app_home/himed/xpapps/crm/rulexp/xp/SMCRC00200_연동내역정보.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMCRC00200" position="absolute 0 0 1198 777" titletext="데이터 연동 내역" oninit="SMCRC00200_oninit" onload="SMCRC00200_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 25 1194 65" align="align:center top;" id="group2" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static text="연동일시 :" position="absolute 16 11 120 28" id="caption3" class="search_name" anchor="left top"/>
              <Calendar position="absolute 108 10 208 29" id="ipt_syncfromdd" class="input_search" anchor="left top"/>
              <Static text="~" position="absolute 213 11 225 28" id="caption6" class="search_no_b" anchor="left top"/>
              <Calendar position="absolute 230 10 330 29" id="ipt_synctodd" class="input_search" anchor="left top"/>
              <Static text="프로그램 ID :" position="absolute 386 11 568 28" id="caption4" class="search_name" anchor="left top"/>
              <Edit position="absolute 495 10 640 29" id="ipt_tablenm" class="input_search" anchor="left top"/>
              <Button position="absolute 645 11 661 27" id="btn_prgmsrch" class="icon_search" text="" anchor="left top" onclick="group2_btn_prgmsrch_onclick"/>
              <Static text="정상종료여부 :" position="absolute 885 12 997 29" id="caption5" class="search_name" anchor="top right"/>
              <Combo position="absolute 1005 10 1090 29" id="cmb_useyn" class="combo_search" innerdataset="@ds_init_comncdlist_C0023list" datacolumn="cdnm" codecolumn="cdid" anchor="top right" index="-1"/>
              <Shape position="absolute 1103 9 1109 31" linetype="vertical" id="line1" class="line_4" anchor="top right"/>
              <Button position="absolute 1122 9 1178 31" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="group2_btn_search_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption1" text="데이터 연동내역 조회" class="tit_1" position="absolute 0 0 157 25" anchor="left top"/>
        <Static id="caption2" text="데이터 연동 내역" class="tit_2" position="absolute 0 73 128 89" anchor="left top"/>
        <Button id="btn_saveexcel" taborder="1" text="엑셀저장" class="btn7" position="absolute 1120 70 1194 89" onclick="btn_saveexcel_onclick" anchor="top right"/>
        <Shape id="line2" linetype="horizontal" class="line_10" position="absolute 0 89 1194 95" anchor="left top right"/>
        <Grid id="grd_synclist" class="datagrid2" taborder="2" binddataset="ds_main_list_synclist" useinputpanel="false" position="absolute 0 94 1194 752" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="90"/>
                <Column size="60"/>
                <Column size="70"/>
                <Column size="130"/>
                <Column size="130"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="70"/>
              </Columns>
              <Rows>
                <Row size="31" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="프로그램 ID"/>
                <Cell col="2" text="연동 정보"/>
                <Cell col="3" text="연동번호"/>
                <Cell col="4" text="일련&#10;번호"/>
                <Cell col="5" text="실행구분"/>
                <Cell col="6" text="연동시작일시"/>
                <Cell col="7" text="연동종료일시"/>
                <Cell col="8" text="총&#10;건수"/>
                <Cell col="9" text="실행&#10;건수"/>
                <Cell col="10" text="추가&#10;건수"/>
                <Cell col="11" text="수정&#10;건수"/>
                <Cell col="12" text="삭제&#10;건수"/>
                <Cell col="13" text="정상여부"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="expr:currow+1"/>
                <Cell col="1" style="align:left middle;padding:0 0 0 3;" text="bind:trsmtablenm"/>
                <Cell col="2" style="align:left middle;padding:0 0 0 3;" text="bind:tableinfo"/>
                <Cell col="3" displaytype="text" text="bind:synctabledivsetno"/>
                <Cell col="4" displaytype="text" style="align:center middle;" class="text_center" text="bind:syncseq"/>
                <Cell col="5" displaytype="combo" style="align:center middle;" class="text_center" text="bind:execflag" combodataset="ds_init_comncdlist_C0024list" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                <Cell col="6" displaytype="date" class="text_center" text="bind:trsmusdt" mask="yyyy-MM-dd hh:mm:ss" maskchar=" " calendardisplaynulltype="nulltext"/>
                <Cell col="7" displaytype="date" class="text_center" text="bind:trsmuedt" mask="yyyy-MM-dd hh:mm:ss" maskchar=" " calendardisplaynulltype="nulltext"/>
                <Cell col="8" displaytype="number" class="text_right" text="bind:totcnt"/>
                <Cell col="9" displaytype="number" class="text_right" text="bind:execcnt"/>
                <Cell col="10" displaytype="number" class="text_right" text="bind:addcnt"/>
                <Cell col="11" displaytype="number" class="text_right" text="bind:updtcnt"/>
                <Cell col="12" displaytype="number" class="text_right" text="bind:delcnt"/>
                <Cell col="13" displaytype="combo" style="align:center middle;" class="text_center" text="bind:nrmlendyn" combodataset="ds_init_comncdlist_C0023list" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_navi" taborder="3" text="연동정보관리" class="btn3" position="absolute 0 753 104 775" onclick="btn_navi_onclick" anchor="left bottom"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_comncdlist_C0023list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING"/>
          <Column id="cdid" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_comncdlist_C0024list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING"/>
          <Column id="cdid" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_list_synclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="trsmtablenm" type="STRING"/>
          <Column id="tableinfo" type="STRING"/>
          <Column id="synctabledivsetno" type="STRING"/>
          <Column id="syncseq" type="STRING"/>
          <Column id="execflag" type="STRING"/>
          <Column id="trsmusdt" type="STRING"/>
          <Column id="trsmuedt" type="STRING"/>
          <Column id="totcnt" type="STRING"/>
          <Column id="execcnt" type="STRING"/>
          <Column id="addcnt" type="STRING"/>
          <Column id="updtcnt" type="STRING"/>
          <Column id="delcnt" type="STRING"/>
          <Column id="nrmlendyn" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_srch" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="syncfromdd" type="STRING" size="256"/>
          <Column id="synctodd" type="STRING" size="256"/>
          <Column id="tablenm" type="STRING" size="256"/>
          <Column id="nrmlendyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.ipt_syncfromdd" propid="value" datasetid="ds_send_srch" columnid="syncfromdd"/>
      <BindItem id="item1" compid="group2.ipt_synctodd" propid="value" datasetid="ds_send_srch" columnid="synctodd"/>
      <BindItem id="item2" compid="group2.ipt_tablenm" propid="value" datasetid="ds_send_srch" columnid="tablenm"/>
      <BindItem id="item3" compid="group2.cmb_useyn" propid="value" datasetid="ds_send_srch" columnid="nrmlendyn"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2016-05-24
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-05-24      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/

include "com_commonxp::comm_main.xjs";
include "com_basiccodexp::ZBC001.xjs";
include "crm_rulexp::CRZ001.xjs";


function SMCRC00200_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMCRC00200_onload(obj:Form, e:LoadEventInfo)
{
	var arrParam = [ {dsNm : "ds_init_comncdlist_C0023list", cdGrpId: "C0023"},
	                 {dsNm : "ds_init_comncdlist_C0024list", cdGrpId: "C0024"}];
	appf_getCodeList(arrParam); 
				
	var sync_dd = utlf_getCurrentDate();
	ds_send_srch.setColumn(0, "syncfromdd", sync_dd);
	ds_send_srch.setColumn(0, "synctodd", sync_dd);
	
	frmf_addComboItemAll("group2.cmb_useyn");
	group2.cmb_useyn.index = 0;
	
	fCheckAuth();
	fInitSyncList();
}

function fCheckAuth()
{
	// 권한체크
	if (!frmf_checkAuth("r"))
	{
		group2.btn_search.enable = false;
	}
	if (!frmf_checkAuth("p"))
	{
		btn_saveexcel.enable = false;
	}
}
	
function fInitSyncList()
{
	// 그리드 초기화
	ds_main_list_synclist.clearData();
}

//조회
function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRCRC00201";
		oParam.service     = "rulemngtapp.RuleMngt";
		oParam.method      = "reqGetSyncHistory";
		oParam.inds        = "req=ds_send_srch";
		oParam.outds       = "ds_main_list_synclist=synclist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRCRC00201";
	tranf_submit(oParam);

}

//엑셀저장
function btn_saveexcel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_synclist, "excel", "SheetName", "true", "", "");
}

//연동정보관리
function btn_navi_onclick(obj:Button,  e:ClickEventInfo)
{
	frmf_open("SMCRC00100", "SMCRC00100", "", "", "", "", "", "", "", "", "", "", "M");
}

//프로그램ID 조회
function group2_btn_prgmsrch_onclick(obj:Button,  e:ClickEventInfo)
{
	var srch_condition = "P";
	var srch_term = ds_send_srch.getColumn(0, "tablenm");
	var param = crzfOpenSelectPrgm(srch_condition, srch_term);
	ds_send_srch.setColumn(0, "tablenm", param.tablenm);	
}
]]></Script>
  </Form>
</FDL>