YNU_JEUS/app_home/himed/xpapps/crm/dataminingxp/xp/SPCDT01000_데이터마이닝수동실행.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPCDT01000" position="absolute 0 0 971 600" titletext="고객정보마이닝 수동실행" oninit="SPCDT01000_oninit" onload="SPCDT01000_onload">
    <Layouts>
      <Layout>
        <Static id="caption46" text="탬플릿 수동 실행 미리보기 결과" class="tit_2" position="absolute 0 0 251 21" onclick="caption46_onclick"/>
        <Button id="btn_sms" taborder="1" text="SMS전송" class="btn3" position="absolute 0 19 84 41" onclick="btn_sms_onclick"/>
        <Button id="btn_email" taborder="2" text="이메일발송" class="btn3" position="absolute 87 19 179 41" onclick="btn_email_onclick"/>
        <Button id="btn_dm" taborder="3" text="DM출력" class="btn3" position="absolute 182 19 262 41" onclick="btn_dm_onclick"/>
        <Static id="caption47" text="전체 인원수 :" position="absolute 684 24 764 41"/>
        <Edit id="opt_count" taborder="4" readonly="true" autoselect="true" position="absolute 767 22 797 41"/>
        <Static id="caption48" text="건" position="absolute 800 24 830 41"/>
        <Button id="btn_saveexcel" taborder="5" text="엑셀저장" class="btn7" position="absolute 825 22 905 41" onclick="btn_saveexcel_onclick"/>
        <Button id="btn_manlexec" taborder="6" text="수동실행" class="btn2" position="absolute 906 22 970 41" onclick="btn_manlexec_onclick"/>
        <Shape id="line27" class="line_10" position="absolute 0 41 970 47"/>
        <Grid id="grd_dtmnexec" taborder="7" binddataset="ds_main_list_dtmnexeclist" useinputpanel="false" position="absolute 0 46 970 571" autoenter="select" cellsizingtype="col" selecttype="multirow">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="26"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="100"/>
                <Column size="150"/>
                <Column size="100"/>
                <Column size="295"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="200"/>
                <Column size="100"/>
                <Column size="200"/>
                <Column size="100"/>
                <Column size="200"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
              </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="RH"/>
                <Cell col="6" text="나이"/>
                <Cell col="7" text="휴대폰"/>
                <Cell col="8" text="이메일"/>
                <Cell col="9" text="우편번호"/>
                <Cell col="10" text="주소"/>
                <Cell col="11" text="VIP등급"/>
                <Cell col="12" text="최종내원일"/>
                <Cell col="13" text="내원일자"/>
                <Cell col="14" text="내원경로"/>
                <Cell col="15" text="노블레스여부"/>
                <Cell col="16" text="상병일자"/>
                <Cell col="17" text="상병코드"/>
                <Cell col="18" text="처방일자"/>
                <Cell col="19" text="처방코드"/>
                <Cell col="20" text="검사일자"/>
                <Cell col="21" text="검사코드"/>
                <Cell col="22" text="참고치상한"/>
                <Cell col="23" text="참고치하한"/>
                <Cell col="24" text="판정마크"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" text="bind:hngnm"/>
                <Cell col="2" text="bind:pid"/>
                <Cell col="3" text="bind:sex"/>
                <Cell col="4" text="bind:btype"/>
                <Cell col="5" text="bind:rh"/>
                <Cell col="6" text="bind:age"/>
                <Cell col="7" text="bind:mpphontel"/>
                <Cell col="8" text="bind:email"/>
                <Cell col="9" text="bind:zipcd"/>
                <Cell col="10" text="bind:address"/>
                <Cell col="11" text="bind:vipgrde"/>
                <Cell col="12" text="bind:lastchosdt"/>
                <Cell col="13" text="bind:orddd"/>
                <Cell col="14" text="bind:chospath"/>
                <Cell col="15" text="bind:nblsyn"/>
                <Cell col="16" text="bind:diagdd"/>
                <Cell col="17" text="bind:diagcd"/>
                <Cell col="18" text="bind:prcpdd"/>
                <Cell col="19" text="bind:prcpcd"/>
                <Cell col="20" text="bind:lastreptdt"/>
                <Cell col="21" text="bind:testcd"/>
                <Cell col="22" text="bind:refh"/>
                <Cell col="23" text="bind:refl"/>
                <Cell col="24" text="bind:judgmark"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_select" taborder="8" text="전체선택" class="btn2" position="absolute 0 575 64 594" onclick="btn_select_onclick"/>
        <Button id="btn_release" taborder="9" text="전체해제" class="btn2" position="absolute 67 575 131 594" onclick="btn_release_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_list_dtmnexeclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="hngnm" type="STRING" size="256" sumtext="이름"/>
          <Column id="pid" type="STRING" size="256" sumtext="등록번호"/>
          <Column id="sex" type="STRING" size="256" sumtext="성별"/>
          <Column id="age" type="INT" size="256" sumtext="나이"/>
          <Column id="mpphontel" type="STRING" size="256" sumtext="휴대폰"/>
          <Column id="email" type="STRING" size="256" sumtext="이메일"/>
          <Column id="zipcd" type="STRING" size="256" sumtext="우편번호"/>
          <Column id="address" type="STRING" size="256" sumtext="주소"/>
          <Column id="vipgrde" type="STRING" size="256" sumtext="VIP등급"/>
          <Column id="btype" type="STRING" size="256" sumtext="혈액형"/>
          <Column id="rh" type="STRING" size="256" sumtext="RH혈액형"/>
          <Column id="lastchosdt" type="STRING" size="256" sumtext="최종내원일"/>
          <Column id="orddd" type="STRING" size="256" sumtext="내원일자"/>
          <Column id="chospath" type="STRING" size="256" sumtext="내원경로"/>
          <Column id="nblsyn" type="STRING" size="256" sumtext="노블레스여부"/>
          <Column id="diagdd" type="STRING" size="256" sumtext="상병일자"/>
          <Column id="diagcd" type="STRING" size="256" sumtext="상병코드"/>
          <Column id="prcpdd" type="STRING" size="256" sumtext="처방일자"/>
          <Column id="prcpcd" type="STRING" size="256" sumtext="처방코드"/>
          <Column id="lastperptdt" type="STRING" size="256" sumtext="검사일자"/>
          <Column id="testcd" type="STRING" size="256" sumtext="검사코드"/>
          <Column id="refh" type="STRING" size="256" sumtext="참고정치상한"/>
          <Column id="refl" type="STRING" size="256" sumtext="참고치하한"/>
          <Column id="judgmark" 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_main_dtmntmpl_area" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_agelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_chosordlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_snwlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_prcplist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_testlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_opordlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_tmpldefine" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_humtrainfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_chosinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_snwinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_prcpinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_testinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_opinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_dtmntmpl_oplist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_temp_emailinfo_recvrlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_temp_dminfo_recvrlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_temp_smsinfo_recvrlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="opt_count" propid="value" datasetid="ds_temp" columnid="countnode"/>
    </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 "crm_crmxp::CCZ001.xjs";
function SPCDT01000_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPCDT01000_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_dtmnexec);
			
	try
	{
		ds_main_dtmntmpl_area.copyData(arg_ds_main_dtmntmpl_area);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_agelist.copyData(arg_ds_main_dtmntmpl_agelist);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_chosordlist.copyData(arg_ds_main_dtmntmpl_chosordlist);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_snwlist.copyData(arg_ds_main_dtmntmpl_snwlist);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_prcplist.copyData(arg_ds_main_dtmntmpl_prcplist);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_testlist.copyData(arg_ds_main_dtmntmpl_testlist);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_oplist.copyData(arg_ds_main_dtmntmpl_oplist);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_opordlist.copyData(arg_ds_main_dtmntmpl_opordlist);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_tmpldefine.copyData(arg_ds_main_dtmntmpl_tmpldefine);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_humtrainfo.copyData(arg_ds_main_dtmntmpl_humtrainfo);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_chosinfo.copyData(arg_ds_main_dtmntmpl_chosinfo);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_snwinfo.copyData(arg_ds_main_dtmntmpl_snwinfo);
	}
	catch(e){}
	try
	{
		ds_main_dtmntmpl_prcpinfo.copyData(arg_ds_main_dtmntmpl_prcpinfo);
	}
	catch(e){}
	
}

function btn_sms_onclick(obj:Button,  e:ClickEventInfo)
{
	cczfSMSTrsmOpen("grid",grd_dtmnexec,"hngnm","mpphontel","","");
}

function btn_email_onclick(obj:Button,  e:ClickEventInfo)
{
	cczfEmailTrsmOpen("grid",grd_dtmnexec,"email","");
}

function btn_dm_onclick(obj:Button,  e:ClickEventInfo)
{
	cczfDMTrsmOpen(grd_dtmnexec,"hngnm","zipcd","address","pid");
}

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

function btn_manlexec_onclick(obj:Button,  e:ClickEventInfo)
{
	fDtMnExec();      //데이터마이닝 수동실행
}

function fDtMnExec()
{
	var oParam = {};
		oParam.id          = "TRCDT00112";
		oParam.service     = "dtmnmngtapp.DtmnMngt";
		oParam.method      = "reqGetDtmnExec";
		oParam.inds        = "tmpldefine=ds_main_dtmntmpl_tmpldefine "
							+"humtrainfo=ds_main_dtmntmpl_humtrainfo "
							+"area=ds_main_dtmntmpl_area "
							+"agelist=ds_main_dtmntmpl_agelist "
							+"chosinfo=ds_main_dtmntmpl_chosinfo "
							+"chosordlist=ds_main_dtmntmpl_chosordlist "
							+"snwinfo=ds_main_dtmntmpl_snwinfo "
							+"snwlist=ds_main_dtmntmpl_snwlist "
							+"prcpinfo=ds_main_dtmntmpl_prcpinfo "
							+"prcplist=ds_main_dtmntmpl_prcplist "
							+"prcpordlist=ds_ "
							+"testinfo=ds_main_dtmntmpl_testinfo "
							+"testlist=ds_main_dtmntmpl_testlist "
							+"testordlist=ds_ "
							+"opinfo=ds_main_dtmntmpl_opinfo "
							+"oplist=ds_main_dtmntmpl_oplist "
							+"opordlist=ds_main_dtmntmpl_opordlist ";
		oParam.outds       = "ds_main_list_dtmnexeclist=dtmnexeclist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRCDT00112";

	tranf_submit(oParam);
	
	grd_dtmnexec.setFocus();
	
	var grid_rows = ds_main_list_dtmnexeclist.rowcount;
	ds_temp.setColumn(0, "countnode" , grid_rows);
}

function btn_select_onclick(obj:Button,  e:ClickEventInfo)
{
	grd_dtmnexec.selectAll();
}

function btn_release_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_list_dtmnexeclist.clearSelect();
}
]]></Script>
  </Form>
</FDL>