YNU_JEUS/app_home/himed/xpapps/crm/reservexp/xp/SMCFA00400_건진예약현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMCFA00400" position="absolute 0 0 1199 785" titletext="종합건진 예약현황" oninit="SMCFA00400_oninit" onload="SMCFA00400_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 23 1195 83" align="align:center top;" id="group2" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static text="예약일자 :" position="absolute 16 10 102 27" id="caption3" class="search_name"/>
              <Calendar position="absolute 108 9 228 28" id="ipt_ordfromdd" class="input_search" autoskip="true" autoselect="true"/>
              <Static text="~" position="absolute 233 10 245 27" id="caption4" class="search_no_b"/>
              <Calendar position="absolute 248 9 368 28" id="ipt_ordtodd" class="input_search" autoselect="true"/>
              <Static text="사업체 :" position="absolute 406 10 492 27" id="caption5" class="search_name"/>
              <Edit position="absolute 485 8 585 27" id="ipt_cmpycd" class="input_search" autoselect="true" maxlength="50"/>
              <Button position="absolute 590 10 606 26" id="btn_cmpy_srch" class="icon_search" text="" onclick="group2_btn_cmpy_srch_onclick"/>
              <Static text="패키지 :" position="absolute 641 10 727 27" id="caption6" class="search_name"/>
              <Edit position="absolute 720 8 820 27" id="ipt_pkgcd" class="input_search" autoselect="true" maxlength="50"/>
              <Button position="absolute 825 10 841 26" id="btn_pkg_srch" class="icon_search" text="" onclick="group2_btn_pkg_srch_onclick"/>
              <Static text="건진분류 :" position="absolute 875 11 961 28" id="caption7" class="search_name"/>
              <Combo position="absolute 965 8 1075 27" id="cmb_rsrvflag" class="combo_search" innerdataset="@ds_init_comncdlist_A0069list_A0069" datacolumn="cdnm" codecolumn="cdid"/>
              <Static text="등록번호 :" position="absolute 16 34 102 51" id="caption8" class="search_name"/>
              <Edit position="absolute 108 33 228 52" id="ipt_pid" class="input_search" autoselect="true"/>
              <Button position="absolute 233 35 249 51" id="btn_pid_srch" class="icon_search" text="" onclick="group2_btn_pid_srch_onclick"/>
              <Static text="주민등록번호 :" position="absolute 296 34 410 51" id="caption9" class="search_name"/>
              <MaskEdit position="absolute 415 33 485 52" id="ipt_rrgst1" class="input_search" mask="######" autoselect="true" maskchar=" " type="string" trimtype="both" style="align:center middle;"/>
              <Static text="-" position="absolute 490 34 502 51" id="caption10" class="search_no_b"/>
              <MaskEdit position="absolute 505 33 585 52" id="ipt_rrgst2" class="input_search" mask="#######" style="align:center middle;" maskchar=" " autoselect="true" type="string" trimtype="both"/>
              <Static text="환자명 :" position="absolute 641 34 727 51" id="caption11" class="search_name"/>
              <Edit position="absolute 720 33 820 52" id="ipt_patnm" class="input_search" autoselect="true" maxlength="50"/>
              <Static text="전송상태 :" position="absolute 875 34 961 51" id="caption12" class="search_name"/>
              <Combo position="absolute 965 33 1075 52" id="cmb_trsmstat" class="combo_search" innerdataset="@ds_init_comncdlist_C0019list_C0019" datacolumn="cdnm" codecolumn="cdid"/>
              <Shape position="absolute 1103 8 1109 54" linetype="vertical" id="line1" class="line_4" anchor="top right"/>
              <Button position="absolute 1122 20 1178 42" 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 189 24"/>
        <Button id="btn_email" taborder="1" text="이메일발송" class="btn3" position="absolute 86 752 178 774" onclick="btn_email_onclick"/>
        <Button id="btn_sms" taborder="2" text="SMS전송" class="btn3" position="absolute 0 752 84 774" onclick="btn_sms_onclick"/>
        <Button id="btn_save" taborder="3" text="저장" class="btn4" position="absolute 1068 752 1124 774" onclick="btn_save_onclick"/>
        <Button id="btn_init" taborder="4" text="초기화" class="btn4" position="absolute 1127 752 1195 774" onclick="btn_init_onclick"/>
        <Grid id="grd_rsrvlist" class="text_center" taborder="5" binddataset="ds_main_list_rsrvlist" autoenter="select" useinputpanel="false" cellsizingtype="col" position="absolute 0 117 1195 747" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24" band="left"/>
                <Column size="25" band="left"/>
                <Column size="100" band="left"/>
                <Column size="100" band="left"/>
                <Column size="55" band="left"/>
                <Column size="90" band="left"/>
                <Column size="120" band="left"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="70"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="450"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1"/>
                <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" text="예약상태"/>
                <Cell col="11" text="고객등급"/>
                <Cell col="12" text="단체"/>
                <Cell col="13" text="사업체"/>
                <Cell col="14" text="건진분류"/>
                <Cell col="15" text="예약 메시지"/>
                <Cell col="16"/>
                <Cell col="17"/>
                <Cell col="18"/>
                <Cell col="19"/>
                <Cell col="20"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" class="update_n" text="bind:update"/>
                <Cell col="2" displaytype="combo" style="align:center middle;" text="bind:trsmstat" combodataset="ds_init_comncdlist_C0019list_C0019" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                <Cell col="3" displaytype="date" style="align:center middle;" text="bind:hopedd" calendardisplaynulltype="nulltext"/>
                <Cell col="4" style="align:center middle;" text="bind:rsrvtm" mask="##:##" maskchar=" "/>
                <Cell col="5" style="align:center middle;" text="bind:pid"/>
                <Cell col="6" style="align:center middle;" text="bind:hngnm"/>
                <Cell col="7" style="align:center middle;" text="bind:rrgstno" mask="######-#{******}" maskchar="*"/>
                <Cell col="8" style="align:center middle;" text="bind:mpphontel"/>
                <Cell col="9" style="align:center middle;" text="bind:pkgcd"/>
                <Cell col="10" displaytype="combo" style="align:center middle;" text="bind:statflag" combodataset="ds_init_comncdlist_A0107list_A0107" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                <Cell col="11" displaytype="combo" edittype="combo" style="align:center middle;" text="bind:clntgrde" combodataset="ds_init_comncdlist_A0118list_A0118" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                <Cell col="12" style="align:center middle;" text="bind:cmpyflag"/>
                <Cell col="13" style="align:center middle;" text="bind:cmpycd"/>
                <Cell col="14" displaytype="combo" edittype="combo" style="align:center middle;" text="bind:healexamdetlflag" enable="false"/>
                <Cell col="15" style="align:left middle;padding:0 0 0 3;" text="bind:smsmsg"/>
                <Cell col="16" text="bind:healexamflag"/>
                <Cell col="17" text="bind:rsrvdd"/>
                <Cell col="18" text="bind:rsrvno"/>
                <Cell col="19" text="bind:email"/>
                <Cell col="20" text="bind:lastchosdt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_trsmstat" taborder="6" text="전송제외" class="btn2" position="absolute 1049 93 1113 112" anchor="top right" onclick="btn_trsmstat_onclick"/>
        <Button id="btn_saveexcel" taborder="7" text="엑셀저장" class="btn7" position="absolute 1115 93 1195 112" anchor="top right" onclick="btn_saveexcel_onclick"/>
        <Static id="caption2" text="예약 전송 목록" class="tit_2" position="absolute 0 96 122 118"/>
        <Shape id="line2" class="line_10" position="absolute 0 112 1195 118" anchor="left top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_srch" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="rsrvfromdd" type="STRING" size="256"/>
          <Column id="rsrvtodd" type="STRING" size="256"/>
          <Column id="cmpynm" type="STRING" size="256"/>
          <Column id="cmpycd" type="STRING" size="256"/>
          <Column id="pkgnm" type="STRING" size="256"/>
          <Column id="pkgcd" type="STRING" size="256"/>
          <Column id="healexamdetlflag" type="STRING" size="256"/>
          <Column id="pid" type="STRING" size="256"/>
          <Column id="rrgstno1" type="STRING" size="256"/>
          <Column id="rrgstno2" type="STRING" size="256"/>
          <Column id="patnm" type="STRING" size="256"/>
          <Column id="trsmstat" type="STRING" size="256"/>
          <Column id="healexamflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="rsrvfromdd"/>
            <Col id="rsrvtodd"/>
            <Col id="cmpynm"/>
            <Col id="cmpycd"/>
            <Col id="pkgnm"/>
            <Col id="pkgcd"/>
            <Col id="healexamdetlflag"/>
            <Col id="pid"/>
            <Col id="rrgstno1"/>
            <Col id="rrgstno2"/>
            <Col id="patnm"/>
            <Col id="trsmstat"/>
            <Col id="healexamflag">C</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_comncdlist_A0118list_A0118" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_comncdlist_A0107list_A0107" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_comncdlist_C0019list_C0019" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_comncdlist_A0069list_A0069" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_list_rsrvlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="hopedd" type="STRING" size="256" sumtext="예약희망일자"/>
          <Column id="rsrvtm" type="STRING" size="256" sumtext="예약시간"/>
          <Column id="pid" type="STRING" size="256" sumtext="등록번호"/>
          <Column id="hngnm" type="STRING" size="256" sumtext="환자이름"/>
          <Column id="rrgstno" type="STRING" size="256" sumtext="주민등록번호"/>
          <Column id="clntgrde" type="STRING" size="256" sumtext="고객등급"/>
          <Column id="cmpyflag" type="STRING" size="256" sumtext="단체여부"/>
          <Column id="cmpycd" type="STRING" size="256" sumtext="사업체"/>
          <Column id="pkgcd" type="STRING" size="256" sumtext="패키지"/>
          <Column id="healexamdetlflag" type="STRING" size="256" sumtext="건진상세분류"/>
          <Column id="statflag" type="STRING" size="256" sumtext="예약상태"/>
          <Column id="trsmstat" type="INT" size="256" sumtext="전송여부"/>
          <Column id="mpphontel" type="STRING" size="256" sumtext="휴대전화번호"/>
          <Column id="smsmsg" type="STRING" size="256" sumtext="문자메시지"/>
          <Column id="healexamflag" type="STRING" size="256" sumtext="건진분류(키)"/>
          <Column id="rsrvdd" type="STRING" size="256" sumtext="예약일자(키)"/>
          <Column id="rsrvno" type="INT" size="256" sumtext="예약번호(키)"/>
          <Column id="email" type="STRING" size="256" sumtext="이메일"/>
          <Column id="lastchosdt" type="STRING" size="256" sumtext="최종내원일시"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_rsrvrule" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="rsrvflag" type="STRING" size="256"/>
          <Column id="itemflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="rsrvflag">4</Col>
            <Col id="itemflag">H</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_rsrvrule" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_rsrvlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.cmb_rsrvflag" propid="value" datasetid="ds_send_srch" columnid="healexamdetlflag"/>
      <BindItem id="item1" compid="group2.cmb_trsmstat" propid="value" datasetid="ds_send_srch" columnid="trsmstat"/>
      <BindItem id="item2" compid="group2.ipt_patnm" propid="value" datasetid="ds_send_srch" columnid=""/>
      <BindItem id="item3" compid="group2.ipt_pkgcd" propid="value" datasetid="ds_send_srch" columnid="pkgnm"/>
      <BindItem id="item4" compid="group2.ipt_cmpycd" propid="value" datasetid="ds_send_srch" columnid=""/>
      <BindItem id="item5" compid="group2.ipt_rrgst2" propid="value" datasetid="ds_send_srch" columnid=""/>
      <BindItem id="item6" compid="group2.ipt_rrgst1" propid="value" datasetid="ds_send_srch" columnid=""/>
      <BindItem id="item7" compid="group2.ipt_ordtodd" propid="value" datasetid="ds_send_srch" columnid="rsrvtodd"/>
      <BindItem id="item8" compid="group2.ipt_ordfromdd" propid="value" datasetid="ds_send_srch" columnid="rsrvfromdd"/>
      <BindItem id="item9" compid="group2.ipt_pid" propid="value" datasetid="ds_send_srch" columnid="pid"/>
    </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";
include "crm_reservexp::CFZ001.xjs";
function SMCFA00400_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMCFA00400_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_rsrvlist);
	grdf_setRowTypeIcon(grd_rsrvlist, 1);
	grdf_setToolTipBind(grd_rsrvlist);

	// A0068: 건진구분1, A0069: 건진구분2, A0070: 건진구분3, A0107: 건진상태구분, A0118: 종합건진고객등급, C0019: 전송상태
	var arrParam = [{dsNm: "ds_init_comncdlist_A0069list_A0069", cdGrpId: "A0069"}
				   ,{dsNm: "ds_init_comncdlist_A0107list_A0107", cdGrpId: "A0107"}
				   ,{dsNm: "ds_init_comncdlist_A0118list_A0118", cdGrpId: "A0118"}
				   ,{dsNm: "ds_init_comncdlist_C0019list_C0019", cdGrpId: "C0019"}]
	appf_getCodeList(arrParam); 
	
	var oParam = {};
		oParam.id          = "TRCFA00102";
		oParam.service     = "rsrvinfoapp.RsrvInfo";
		oParam.method      = "reqGetRsrvRule";
		oParam.inds        = "req=ds_send_rsrvrule";
		oParam.outds       = "ds_init_rsrvrule=rsrvrule";
		oParam.async       = false;
		//oParam.callback    = "cf_TRCFA00102";

	tranf_submit(oParam);

	var delive_dd = ds_init_rsrvrule.getColumn(0, "delivedd");
	var rsrv_dd = utlf_getCurrentDate().toDate().getAddDate(parseInt(delive_dd), "D").getDateFormat("YYYYMMDD");
	ds_send_srch.setColumn(0, "rsrvfromdd", rsrv_dd);
	ds_send_srch.setColumn(0, "rsrvtodd", rsrv_dd);

	var comboIDs = "group2.cmb_trsmstat|group2.cmb_rsrvflag";
	frmf_addComboItemAll( comboIDs, "- 전 체 -", "all");
	
	group2.cmb_trsmstat.index = 0;
	group2.cmb_rsrvflag.index = 0;
	
	fCheckAuth();
	fInitRsrvList();
}

function fCheckAuth() 
{
	// 권한체크
	if (!frmf_checkAuth("r")) 
	{
		group2.btn_search.enable = false;
	}
	if (!frmf_checkAuth("x")) 
	{
		btn_save.enable = false;
		btn_trsmstat.enable = false;
		btn_sms.enable = false;
		btn_email.enable = false;
	}
	if (!frmf_checkAuth("p")) 
	{
		btn_saveexcel.enable = false;
	}
}

function fInitRsrvList()
{
	// 그리드 초기화
	ds_main_list_rsrvlist.clearData();
}
function group2_btn_cmpy_srch_onclick(obj:Button,  e:ClickEventInfo)
{
	fCmpyCodeList();
}

function fCmpyCodeList()
{
// 사업장검색 팝업창 호출
	var rtn = frmf_modal("SPCHI00200", "SPCHI00200", "", "", "", "", "", "", "", "", "", "", "M");
	ds_send_srch.setColumn(0, "cmpynm", rtn.cmpynm);
	ds_send_srch.setColumn(0, "cmpycd", rtn.cmpycd);
}
function group2_btn_pkg_srch_onclick(obj:Button,  e:ClickEventInfo)
{
	fPkgCodeList();
}

function fPkgCodeList(receive_pkgcd_path, receive_pkgnm_path)
{
	// 패키지검색 팝업창 호출
	var rtn = frmf_modal("SPCHI00700", "SPCHI00700", "", "", "", "", "", "", "", "", "", "", "M");
	ds_send_srch.setColumn(0, "pkgnm", rtn.pkgnm);
	ds_send_srch.setColumn(0, "pkgcd", rtn.pkgcd);
}

function group2_btn_pid_srch_onclick(obj:Button,  e:ClickEventInfo)
{
	var search_condition = "pid";
	var search_term = ds_send_srch.getColumn(0, "pid");
	
	var rtn = cczfOpenSelectClnt2(search_condition, search_term);
	ds_send_srch.setColumn(0, "pid", rtn.pid);
	ds_send_srch.setColumn(0, "patnm", rtn.hngnm);
}

function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRCFA00401";
		oParam.service     = "rsrvinfoapp.RsrvInfo";
		oParam.method      = "reqGetHealRsrv";
		oParam.inds        = "req=ds_send_srch";
		oParam.outds       = "ds_main_list_rsrvlist=rsrvlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRCFA00401";

	tranf_submit(oParam);
}

function btn_trsmstat_onclick(obj:Button,  e:ClickEventInfo)
{
	// 전송상태(trsmstat)를 '전송대기(0)'인 데이터만 '전송제외(2)'로 변경
	var grid = grd_rsrvlist;
	var trsmstat_col = "trsmstat";
	cfzfChangeTrsmStat(grid, trsmstat_col);
}

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

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

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

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	fSaveRsrvList();
}

function fSaveRsrvList() 
{
	// 예약메시지 전송에서 제외한 목록 저장
	var grid = grd_rsrvlist;
	var updt_list = grdf_getGridUpdateData(grid);
	if (updt_list.rowcount != 0) 
	{
		grdf_setStatusColumn(updt_list, "status");
		ds_send_rsrvlist.copyData(updt_list, true);
	}
	var oParam = {};
		oParam.id          = "TXCFA00401";
		oParam.service     = "rsrvinfoapp.RsrvInfo";
		oParam.method      = "reqExeHealRsrv";
		oParam.inds        = "rsrvlist=ds_send_rsrvlist";
		oParam.outds       = "";
		oParam.async       = false;
		oParam.callback    = "cf_TXCFA00401";

	tranf_submit(oParam);
}

function cf_TXCFA00401(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) return;
    else
    {
		ds_main_list_rsrvlist.applyChange();
		ds_send_rsrvlist.clearData();
		sysf_messageBox("전송상태 저장이","I002");
    }
}

function btn_init_onclick(obj:Button,  e:ClickEventInfo)
{
	fInitRsrvList();
}
]]></Script>
  </Form>
</FDL>