YNU_JEUS/app_home/himed/xpapps/crm/rulexp/xp/SMCRC00100_연동정보관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMCRC00100" position="absolute 0 0 1197 783" titletext="데이터 연동설정 관리" oninit="SMCRC00100_oninit" onload="SMCRC00100_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="프로그램 ID :" position="absolute 16 11 120 28" id="caption3" class="search_name" anchor="left top"/>
              <Edit position="absolute 125 10 270 29" id="ipt_prgmid" class="input_search" anchor="left top"/>
              <Button position="absolute 275 11 291 27" id="btn_prgmsrch" class="icon_search" text="" anchor="left top" onclick="group2_btn_prgmsrch_onclick"/>
              <Static text="연동테이블명 :" position="absolute 331 11 450 28" id="caption4" class="search_name" anchor="left top"/>
              <Edit position="absolute 450 10 595 29" id="ipt_tablenm" class="input_search" anchor="left top"/>
              <Button position="absolute 600 11 616 27" id="btn_tablesrch" class="icon_search" text="" anchor="left top" onclick="group2_btn_tablesrch_onclick"/>
              <Static text="사용여부 :" position="absolute 910 13 996 30" id="caption5" class="search_name" anchor="top right"/>
              <Combo position="absolute 1005 11 1090 30" id="cmb_useyn" class="combo_search" innerdataset="@ds_init_comncdlist_C0022list" datacolumn="cdnm" codecolumn="cdid" anchor="top right" index="-1"/>
              <Shape position="absolute 1104 11 1110 33" linetype="vertical" id="line1" class="line_4" anchor="top right"/>
              <Button position="absolute 1123 11 1179 33" 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 165 25" anchor="left top"/>
        <Static id="caption2" text="데이터 연동정보 설정" class="tit_2" position="absolute 0 77 148 93" anchor="left top"/>
        <Button id="btn_syncadd" taborder="1" text="항목추가" class="btn2" position="absolute 983 74 1047 93" anchor="top right" onclick="btn_syncadd_onclick" enable="true"/>
        <Button id="btn_syncdel" taborder="2" text="항목삭제" class="btn2" position="absolute 1050 74 1114 93" anchor="top right" onclick="btn_syncdel_onclick"/>
        <Button id="btn_saveexcel" taborder="3" text="엑셀저장" class="btn7" position="absolute 1117 74 1193 93" anchor="top right" onclick="btn_saveexcel_onclick"/>
        <Shape id="line2" linetype="horizontal" class="line_10" position="absolute 0 93 1194 99" anchor="left top right"/>
        <Grid id="grd_synclist" taborder="4" binddataset="ds_main_list_synclist" useinputpanel="false" position="absolute 0 98 1194 756" anchor="all" autoenter="select" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="70"/>
                <Column size="60"/>
                <Column size="90"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="70"/>
                <Column size="60"/>
                <Column size="70"/>
              </Columns>
              <Rows>
                <Row size="24" 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="연동간격"/>
                <Cell col="5" text="연동단위"/>
                <Cell col="6" text="실행시작"/>
                <Cell col="7" text="실행종료"/>
                <Cell col="8" text="접속 IP"/>
                <Cell col="9" text="접속 DB"/>
                <Cell col="10" text="접속 ID"/>
                <Cell col="11" text="접속 PW"/>
                <Cell col="12" text="접속 Port"/>
                <Cell col="13" text="사용여부"/>
                <Cell col="14" text="속성구분"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="text" edittype="text" text="bind:prgmid"/>
                <Cell col="2" displaytype="text" edittype="text" text="bind:synctablenm"/>
                <Cell col="3" displaytype="text" edittype="text" text="bind:tableinfo"/>
                <Cell col="4" displaytype="combo" edittype="combo" style="align:center middle;" class="text_center" text="bind:syncintvl" combodataset="ds_init_comncdlist_C0035list" combocodecol="cdid" combodatacol="cdnm" combodisplayrowcount="20"/>
                <Cell col="5" displaytype="text" edittype="text" style="align:center middle;" class="text_center" text="bind:syncunit"/>
                <Cell col="6" displaytype="text" edittype="expr:fromdt_edittype" style="align:center middle;" class="text_center" text="bind:fromdt" mask="##:##" maskchar=" "/>
                <Cell col="7" displaytype="text" edittype="expr:fcsttodt_edittype" style="align:center middle;" class="text_center" text="bind:fcsttodt" mask="##:##" maskchar=" "/>
                <Cell col="8" displaytype="text" edittype="text" class="text_center" text="bind:connip"/>
                <Cell col="9" displaytype="text" edittype="text" style="align:center middle;" class="text_center" text="bind:conndb"/>
                <Cell col="10" displaytype="text" edittype="text" style="align:center middle;" class="text_center" text="bind:connacnt"/>
                <Cell col="11" displaytype="text" edittype="text" style="align:left middle;padding:0 0 0 5;" class="text_center" text="bind:connpwd_mask" maskchar=" " editclipmode="excludespace"/>
                <Cell col="12" displaytype="text" edittype="text" style="align:center middle;" class="text_center" text="bind:connport"/>
                <Cell col="13" displaytype="combo" edittype="combo" style="align:center middle;" class="text_center" text="bind:useyn" combodataset="ds_init_comncdlist_C0022list" combocodecol="cdid" combodatacol="cdnm"/>
                <Cell col="14" displaytype="combo" edittype="combo" class="text_center" text="bind:attrflag" combodataset="ds_init_comncdlist_C0025list" combocodecol="cdid" combodatacol="cdnm"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_navi" taborder="5" text="연동내역정보" class="btn3" position="absolute 0 758 104 780" anchor="left bottom" onclick="btn_navi_onclick"/>
        <Button id="btn_save" taborder="6" text="저장" class="btn4" position="absolute 1068 758 1124 780" anchor="right bottom" onclick="btn_save_onclick"/>
        <Button id="btn_init" taborder="7" text="초기화" class="btn4" position="absolute 1127 758 1195 780" anchor="right bottom" onclick="btn_init_onclick"/>
        <Button id="btn_hospinfo" taborder="8" text="병원정보설정" class="btn3" position="absolute 108 758 212 780" anchor="left bottom" onclick="btn_hospinfo_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_comncdlist_C0022list" 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_C0025list" 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_C0035list" 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_send_srch" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="prgmid" type="STRING" size="256"/>
          <Column id="tablenm" type="STRING" size="256"/>
          <Column id="useyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_synclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="prgmid" type="STRING"/>
          <Column id="synctablenm" type="STRING"/>
          <Column id="tableinfo" type="STRING"/>
          <Column id="syncintvl" type="STRING"/>
          <Column id="syncunit" type="STRING"/>
          <Column id="fromdt" type="STRING"/>
          <Column id="fcsttodt" type="STRING"/>
          <Column id="connip" type="STRING"/>
          <Column id="conndb" type="STRING"/>
          <Column id="connacnt" type="STRING"/>
          <Column id="connpwd" type="STRING"/>
          <Column id="connport" type="STRING"/>
          <Column id="useyn" type="STRING"/>
          <Column id="attrflag" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="synclist" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.cmb_useyn" propid="value" datasetid="ds_send_srch" columnid="useyn"/>
      <BindItem id="item1" compid="group2.ipt_tablenm" propid="value" datasetid="ds_send_srch" columnid="tablenm"/>
      <BindItem id="item2" compid="group2.ipt_prgmid" propid="value" datasetid="ds_send_srch" columnid="prgmid"/>
    </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 SMCRC00100_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMCRC00100_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_synclist);
	grdf_setRowTypeIcon(grd_synclist, 0);
	
	var arrParam = [ {dsNm : "ds_init_comncdlist_C0022list", cdGrpId: "C0022"},
	                 {dsNm : "ds_init_comncdlist_C0025list", cdGrpId: "C0025"},
	                 {dsNm : "ds_init_comncdlist_C0035list", cdGrpId: "C0035"}];
	appf_getCodeList(arrParam); 

	frmf_addComboItemAll("group2.cmb_useyn");
	group2.cmb_useyn.index = 0;

 	fCheckAuth();
 	fInitSyncList();
 	
	var oParam = {};
		oParam.id          = "TRCRC00101";
		oParam.service     = "rulemngtapp.RuleMngt";
		oParam.method      = "reqGetSyncList";
		oParam.inds        = "req=ds_send_srch";
		oParam.outds       = "ds_main_list_synclist=synclist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRCRC00101";
	tranf_submit(oParam);
	passwordMask();
 	fGetSyncdtSet();
}

function fCheckAuth()
{
	if (!frmf_checkAuth("r"))
	{
		group2.btn_search.enable = false;
	}
	if (!frmf_checkAuth("x"))
	{
		btn_syncadd.enable=false;
		btn_syncdel.enable=false;
		btn_save.enable=false;
	}
	if (!frmf_checkAuth("p"))
	{
		btn_saveexcel.enable = false;
	}
}

//초기화
function fInitSyncList()
{
	// 그리드 초기화
	ds_main_list_synclist.clearData();
}

//================================================================//
//예약관련 프로세스만 실행시간을 수정할 수 있도록 한다.    //
//===============================================================//				
function fGetSyncdtSet()
{
	if(ds_main_list_synclist.rowcount > 0)
	{
		for(i = 0; ds_main_list_synclist.rowcount > i ;i++)
		{
			if(ds_main_list_synclist.getColumn(i, "prgmid") == "SCHEDULE_MNG" || ds_main_list_synclist.getColumn(i, "prgmid") == "SCHEDULE_MNG_MAPPING")
			{
				ds_main_list_synclist.updatecontrol = false;
				dsf_makeValue(ds_main_list_synclist, "fromdt_edittype", "string", "text", i);
				dsf_makeValue(ds_main_list_synclist, "fcsttodt_edittype", "string", "text", i);
				ds_main_list_synclist.updatecontrol = true;
			}
			else
			{	
				ds_main_list_synclist.updatecontrol = false;
				dsf_makeValue(ds_main_list_synclist, "fromdt_edittype", "string", "none", i);
				dsf_makeValue(ds_main_list_synclist, "fcsttodt_edittype", "string", "none", i);
				ds_main_list_synclist.updatecontrol = true;
				
			}
		}
	}
}

//프로그램 ID검색
function group2_btn_prgmsrch_onclick(obj:Button,  e:ClickEventInfo)
{
	var srch_condition = "P";
	var srch_term = ds_send_srch.getColumn(0, "prgmid");
	
	var param = crzfOpenSelectPrgm(srch_condition, srch_term);
	ds_send_srch.setColumn(0, "prgmid", param.prgmid);	
}

//연동테이블명 검색
function group2_btn_tablesrch_onclick(obj:Button,  e:ClickEventInfo)
{
	var srch_condition = "T";
	var srch_term = ds_send_srch.getColumn(0, "tablenm");
	
	var param = crzfOpenSelectPrgm(srch_condition, srch_term);
	ds_send_srch.setColumn(0, "tablenm", param.tablenm);
}

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

function passwordMask()
{
	if(utlf_isNull(ds_main_list_synclist.getColumnInfo("connpwd_mask")))
	{
		ds_main_list_synclist.addColumn("connpwd_mask", "string");
	}
	
	var mask = "";
	ds_main_list_synclist.enableevent = false;
	ds_main_list_synclist.updatecontrol = false;
	for(var i = 0; i < ds_main_list_synclist.rowcount; i++)
	{
		var length = utlf_transNullToEmpty(ds_main_list_synclist.getColumn(i, "connpwd")).length;
		mask = "";
		for(var j = 0; j < length ;j++)
		{
			mask += "*";
		}
		if(!utlf_isNull(mask))
		{
			ds_main_list_synclist.setColumn(i, "connpwd_mask", mask);
		}
	}	
	ds_main_list_synclist.updatecontrol = true;
	ds_main_list_synclist.enableevent = true;
}

//항목추가
function btn_syncadd_onclick(obj:Button,  e:ClickEventInfo)
{
	var addRow = ds_main_list_synclist.addRow();
	ds_main_list_synclist.updatecontrol = false;
	dsf_makeValue(ds_main_list_synclist, "fromdt_edittype", "string", "text", addRow);
	dsf_makeValue(ds_main_list_synclist, "fcsttodt_edittype", "string", "text", addRow);
	ds_main_list_synclist.updatecontrol = true;
	
	grd_synclist.setCellPos(grd_synclist.getBindCellIndex("Body", "prgmid"));
	grd_synclist.setFocus();
}

//항목삭제
function btn_syncdel_onclick(obj:Button,  e:ClickEventInfo)
{
	dsf_deleteSelectedRows(grd_synclist, true)
}

//엑셀저장
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("SMCRC00200", "SMCRC00200", "", "", "", "", "", "", "", "", "", "", "M");
}

function btn_hospinfo_onclick(obj:Button,  e:ClickEventInfo)
{
	//window.load("SPCRC00400_병원정보설정.xrw", "modal", "hosp_pop", "align:center;", "", "");
	frmf_modal("SPCRC00400", "SPCRC00400", "", "", "", "", "", "", "", "", "", "", "M");
}

//저장버튼
function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	fSaveSyncList();
}

//저장
function fSaveSyncList()
{
	var grid = grd_synclist;
	var updt_list = grdf_getGridUpdateData(grid);
	
	var oParam = {};
		oParam.id          = "TXCRC00101";
		oParam.service     = "rulemngtapp.RuleMngt";
		oParam.method      = "reqExeSyncList";
		oParam.inds        = "synclist=ds_main_list_synclist:A";
		oParam.outds       = "";
		oParam.async       = false;
		oParam.callback    = "cf_TXCRC00101";

	tranf_submit(oParam);
}

function cf_TXCRC00101(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0)
    {
		return;
	}
	else
	{
		var oParam = {};
			oParam.id          = "TRCRC00101";
			oParam.service     = "rulemngtapp.RuleMngt";
			oParam.method      = "reqGetSyncList";
			oParam.inds        = "req=ds_send_srch";
			oParam.outds       = "ds_main_list_synclist=synclist";
			oParam.async       = false;
			//oParam.callback    = "cf_TRCRC00101";
		tranf_submit(oParam);
		passwordMask();
		fGetSyncdtSet();
	}
}

//초기화버튼
function btn_init_onclick(obj:Button,  e:ClickEventInfo)
{
	fInitSyncList();
}
]]></Script>
  </Form>
</FDL>