YNU_JEUS/app_home/himed/xpapps/crm/dataminingxp/xp/SMCDT00200_데이터마이닝목록조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMCDT00200" position="absolute 0 0 1199 805" titletext="고객정보마이닝 목록검색" oninit="SMCDT00200_oninit" onload="SMCDT00200_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 221 33 1191 93" align="align:center top;" id="grp_johe" class="div_SA2" anchor="left top right">
          <Layouts>
            <Layout>
              <Static text="등  록  일  :" position="absolute 15 9 115 26" id="caption2" class="search_name" anchor="default"/>
              <Calendar position="absolute 118 8 238 27" id="ipt_rgstfromdd" class="input_search" anchor="default" onchanged="grp_johe_ipt_rgstfromdd_onchanged"/>
              <Static text="~" position="absolute 243 9 255 26" id="caption3" class="search_no_b" anchor="default"/>
              <Calendar position="absolute 258 8 378 27" id="ipt_rgsttodd" class="input_search" anchor="default" onchanged="grp_johe_ipt_rgsttodd_onchanged"/>
              <Static text="탬플릿명 :" position="absolute 394 9 481 26" id="caption4" class="search_name" anchor="default"/>
              <Edit position="absolute 477 8 607 25" id="ipt_s_dtmntitl" class="input_search" autoselect="true" anchor="default"/>
              <Static text="등  록  자 :" position="absolute 640 9 740 26" id="caption5" class="search_name" anchor="default"/>
              <Edit position="absolute 727 9 857 26" id="ipt_fstrgstnm" class="input_search" autoselect="true" anchor="default"/>
              <Static text="자동실행 여부 :" position="absolute 15 34 145 51" id="caption6" class="search_name" anchor="default"/>
              <Radio position="absolute 137 33 279 52" id="rdo_autoexecflag" columncount="-1" codecolumn="codecolumn" datacolumn="datacolumn" rowcount="-1" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">
                      </Col>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">A</Col>
                      <Col id="datacolumn">자동</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">M</Col>
                      <Col id="datacolumn">수동</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Static text="캠페인 연결 여부:" position="absolute 394 35 531 52" id="caption8" class="search_name" anchor="default"/>
              <Radio position="absolute 531 33 715 52" id="rdo_cmpnlnkyn" columncount="-1" codecolumn="codecolumn" datacolumn="datacolumn" rowcount="-1" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">radio1</Col>
                      <Col id="datacolumn">무관</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">radio2</Col>
                      <Col id="datacolumn">연결</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">radio3</Col>
                      <Col id="datacolumn">연결되지않음</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Shape position="absolute 880 7 886 53" linetype="vertical" id="line1" class="line_4" anchor="top right"/>
              <Button position="absolute 893 17 949 39" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="grp_johe_btn_search_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption1" text="고객정보마이닝 목록검색" class="tit_1" position="absolute 0 0 180 21"/>
        <Static id="caption30" text="데이터마아닝 템플릿" class="tit_2" position="absolute 0 32 215 53"/>
        <Div id="import1" taborder="1" url="./SSCDT00400_데이터마이닝그룹트리.xfdl" position="absolute 0 48 215 792" anchor="left top bottom"/>
        <Static id="caption9" text="데이터마이닝 템플릿" class="tit_2" position="absolute 222 103 372 124"/>
        <Shape id="line2" class="line_10" position="absolute 222 119 1192 125" anchor="left top right"/>
        <Grid id="grd_dtmnlist" class="text_center" taborder="3" binddataset="ds_main_list_dtmnlist" useinputpanel="false" position="absolute 222 124 1192 767" autoenter="select" cellsizingtype="col" anchor="all" oncelldblclick="grd_dtmnlist_oncelldblclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="22"/>
                <Column size="165"/>
                <Column size="110"/>
                <Column size="95"/>
                <Column size="90"/>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="75"/>
                <Column size="90"/>
                <Column size="100"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <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="최종실행건수"/>
                <Cell col="9" text="최종실행일"/>
                <Cell col="10"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" style="align:center top;padding:5 2 3 1;" text="bind:dtmntitl" wordwrap="word"/>
                <Cell col="2" text="bind:dtmnsmltitl"/>
                <Cell col="3" displaytype="combo" style="align:center middle;" text="bind:lnktmplyn" combodataset="ds_cmb_lnktmplyn" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="4" displaytype="combo" style="align:center middle;" text="bind:autexecflag" combodataset="ds_init_C0030list_C0030" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                <Cell col="5" displaytype="date" text="bind:fstrgstdt" mask="yyyy-MM-dd hh:mm" calendardisplaynulltype="nulltext"/>
                <Cell col="6" text="bind:fstrgstnm"/>
                <Cell col="7" text="bind:examcnt"/>
                <Cell col="8" text="bind:lastexamcnt"/>
                <Cell col="9" text="bind:lastexamdd"/>
                <Cell col="10" text="bind:dtmnkey"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption35" text="전체 템플릿 수 :" position="absolute 957 100 1047 119" anchor="top right"/>
        <Edit id="output1" taborder="4" readonly="true" position="absolute 1047 99 1077 118" anchor="top right" autoselect="true" style="background:transparent stretch 5,5;align:center middle;"/>
        <Static id="caption7" text="건" position="absolute 1087 100 1117 119" anchor="top right"/>
        <Button id="btn_saveexcel" taborder="5" text="엑셀저장" class="btn7" position="absolute 1112 100 1192 119" anchor="top right" onclick="btn_saveexcel_onclick"/>
        <Button id="button40" taborder="6" text="정보보기" class="btn2" position="absolute 1127 768 1191 787" onclick="button40_onclick" anchor="right bottom"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="rgstfromdd" type="STRING" size="256"/>
          <Column id="rgsttodd" type="STRING" size="256"/>
          <Column id="dtmnnm" type="STRING" size="256"/>
          <Column id="rgstnm" type="STRING" size="256"/>
          <Column id="autexecflag" type="STRING" size="256"/>
          <Column id="cmpnlnkyn" type="STRING" size="256"/>
          <Column id="dtmnsmlcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="rgstfromdd"/>
            <Col id="rgsttodd"/>
            <Col id="dtmnnm"/>
            <Col id="rgstnm"/>
            <Col id="autexecflag"/>
            <Col id="cmpnlnkyn"/>
            <Col id="dtmnsmlcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_dtmnlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="dtmntitl" type="STRING" size="256" sumtext="탬플릿명"/>
          <Column id="dtmnsmltitl" type="STRING" size="256" sumtext="그룹"/>
          <Column id="lnktmplyn" type="STRING" size="256" sumtext="연결캠페인 여부"/>
          <Column id="autexecflag" type="STRING" size="256" sumtext="자동실행 여부"/>
          <Column id="fstrgstdt" type="STRING" size="256" sumtext="등록일시"/>
          <Column id="fstrgstnm" type="STRING" size="256" sumtext="등록자"/>
          <Column id="examcnt" type="STRING" size="256" sumtext="총실행건수"/>
          <Column id="lastexamcnt" type="STRING" size="256" sumtext="최종실행건수"/>
          <Column id="lastexamdd" type="STRING" size="256" sumtext="최종실행일"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="등록부서"/>
          <Column id="dtmnkey" type="STRING" size="256" sumtext="데이터마이닝코드"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="countnode" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_lnktmplyn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">연결</Col>
            <Col id="value">Y</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_C0030list_C0030" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="refmode" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_key" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="scrnflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="scrnflag">L</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="output1" propid="value" datasetid="ds_temp" columnid="countnode"/>
      <BindItem id="item1" compid="grp_johe.ipt_rgstfromdd" propid="value" datasetid="ds_send_data" columnid="rgstfromdd"/>
      <BindItem id="item2" compid="grp_johe.ipt_rgsttodd" propid="value" datasetid="ds_send_data" columnid="rgsttodd"/>
      <BindItem id="item3" compid="grp_johe.rdo_autoexecflag" propid="value" datasetid="ds_send_data" columnid="autexecflag"/>
      <BindItem id="item4" compid="grp_johe.ipt_s_dtmntitl" propid="value" datasetid="ds_send_data" columnid="dtmnnm"/>
      <BindItem id="item5" compid="grp_johe.rdo_cmpnlnkyn" propid="value" datasetid="ds_send_data" columnid="cmpnlnkyn"/>
      <BindItem id="item6" compid="grp_johe.ipt_fstrgstnm" propid="value" datasetid="ds_send_data" columnid="rgstnm"/>
    </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";
function SMCDT00200_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMCDT00200_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_dtmnlist);
	
	try
	{
		var objParam = frmf_getMainFormParam();
		ds_send.setColumn(0, "refmode", objParam.refmode);
	}
	catch(e){}
	
	// 공통코드를 호출하여 자료(자동실행여부)를 가져온다 
	var arrParam = [{dsNm: "ds_init_C0030list_C0030", cdGrpId: "C0030"}]
	appf_getCodeList(arrParam); 

	// 데이터마이닝 템플릿 그리드의 col을 초기화 시켜준다.
	ds_main_list_dtmnlist.clearData();
	
	var refmode = ds_send.getColumn(0, "refmode");
	var dtmn_smlcd = ds_send_data.getColumn(0, "dtmnsmlcd");
	// 목록조회 페이지를 바로 열었을 경울 refmode를 L 로 설정 (내용페이지에서 넘어올 경우 C로 표시)
	if (utlf_isNull(refmode))
	{
		ds_send.setColumn(0, "refmode","L");
	}
	else if (refmode == "C") 
	{	
		fGetDtmnList();
	}

	if (parseInt(dtmn_smlcd) > 0)
	{
		fGetDtmnList();
		dsf_makeValue(ds_send_data, "dtmnsmlcd", "string","");
	}

	fCheckAuth();
}

function fCheckAuth() 
{
	if (!frmf_checkAuth("r")) 
	{
		grp_johe.btn_search.enable = false;
	}
	if (!frmf_checkAuth("p")) 
	{
		btn_saveexcel.enable = false;
	}
}

function fGetDtmnList() 
{
	ds_main_list_dtmnlist.clearData();
	
	var oParam = {};
		oParam.id          = "TRCDT00201";
		oParam.service     = "dtmnmngtapp.DtmnMngt";
		oParam.method      = "reqGetDtmnList";
		oParam.inds        = "req=ds_send_data";
		oParam.outds       = "ds_main_list_dtmnlist=dtmnlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRCDT00201";

	tranf_submit(oParam);

	var grid_rows = ds_main_list_dtmnlist.rowcount;
	ds_temp.setColumn(0, "countnode" , grid_rows);
}

function grp_johe_ipt_rgstfromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var rgstfromdd = String(obj.value);
	
	if (!utlf_isNull(rgstfromdd) && !utlf_isValidDateTime(rgstfromdd,"YYYYMMDD")) 
	{
		sysf_messageBox("날짜가 바르게 입력되지","E007");
		obj.setFocus();
	}
}

function grp_johe_ipt_rgsttodd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var rgsttodd = String(obj.value);
	if (!utlf_isNull(rgsttodd) && !utlf_isValidDateTime(rgsttodd,"YYYYMMDD")) 
	{
		sysf_messageBox("날짜가 바르게 입력되지","E007");
		obj.setFocus();
	}
}

function grp_johe_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetDtmnList();
}

function grd_dtmnlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	fGetDtmnAttr(); // 데이터마이닝 정보조회
}

function fGetDtmnAttr()
{
	var row = ds_main_list_dtmnlist.rowposition;
	var receive_dtmnkey = ds_main_list_dtmnlist.getColumn(row, "dtmnkey");

	dsf_makeValue(ds_send_key, "dtmnkey", "string", receive_dtmnkey);
	
	var objArg = new Object();
		objArg.dtmnkey = receive_dtmnkey;
		objArg.refmode = ds_send.getColumn(0, "refmode");
	frmf_openForm("SMCDT00100", "", objArg);
}

function button40_onclick(obj:Button,  e:ClickEventInfo)
{
	if( ds_main_list_dtmnlist.rowposition >= 0 )
	{
		fGetDtmnAttr(); // 데이터마이닝 정보조회
	} 
	else 
	{
		sysf_messageBox("조회하신 후 목록을 ","C002");
		grd_dtmnlist.setFocus();
	}
}

function btn_saveexcel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_dtmnlist, "excel", "SheetName", "true", "", "");
}



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