YNU_JEUS/app_home/himed/xpapps/crm/channelxp/xp/SPCNS00500_SMS예약전송관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPCNS00500" position="absolute 0 0 1010 700" titletext="SMS 예약전송관리" oninit="SPCNS00500_oninit" onload="SPCNS00500_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 23 1005 82" align="align:center top;" id="grp_johe" class="div_SA" taborder="2">
          <Layouts>
            <Layout>
              <Static text="발  송  일  :" position="absolute 15 9 105 26" id="caption2" class="search_name"/>
              <Calendar position="absolute 108 8 218 27" id="ipt_rgstfromdd" class="input_search" autoselect="true" autoskip="true" onkillfocus="grp_johe_ipt_rgstfromdd_onkillfocus"/>
              <Static text="~" position="absolute 223 9 235 26" id="caption3" class="search_no_b"/>
              <Calendar position="absolute 238 8 348 27" id="ipt_rgsttodd" class="input_search" onkillfocus="grp_johe_ipt_rgsttodd_onkillfocus" autoselect="true"/>
              <Static text="휴대폰 번호 :" position="absolute 384 9 480 26" id="caption5" class="search_name"/>
              <Combo position="absolute 459 33 569 52" id="cmb_msgstate" class="combo_search" innerdataset="@ds_init_C0046list_C0046" datacolumn="cdnm" codecolumn="cdid" onitemchanged="grp_johe_cmb_msgstate_onitemchanged"/>
              <Combo position="absolute 573 33 700 52" id="cmb_trsmrsltcd" class="combo_search" enable="false" codecolumn="codecolumn" datacolumn="datacolumn">
                <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">6</Col>
                      <Col id="datacolumn">결번(잘못된번호)</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">4</Col>
                      <Col id="datacolumn">무응답</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">51</Col>
                      <Col id="datacolumn">단말기 오류</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">22</Col>
                      <Col id="datacolumn">메시지수신거부</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">47</Col>
                      <Col id="datacolumn">재전송오류</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">38</Col>
                      <Col id="datacolumn">TXQ EXPIRE</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">0</Col>
                      <Col id="datacolumn">기타 오류</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static text="업 무 구 분 :" position="absolute 15 33 110 50" id="caption6" class="search_name"/>
              <Combo position="absolute 108 32 198 51" id="cmb_bizflag" class="combo_search" codecolumn="codecolumn" datacolumn="datacolumn">
                <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">3</Col>
                      <Col id="datacolumn">예약</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Shape position="absolute 912 8 918 54" linetype="vertical" id="line1" class="line_4"/>
              <Button position="absolute 930 18 986 40" id="btn_search" class="btn1" text="조회" onclick="grp_johe_btn_search_onclick"/>
              <Static text="수신결과 :" position="absolute 384 35 455 52" id="caption8" class="search_name"/>
              <Edit position="absolute 750 7 880 26" id="ipt_recvrtelno" class="input_search" onkeyup="grp_johe_ipt_recvrtelno_onkeyup" autoselect="true"/>
              <Edit position="absolute 478 7 608 26" id="ipt_recvrnm" class="input_search" onkeyup="grp_johe_ipt_recvrnm_onkeyup" autoselect="true"/>
              <Combo position="absolute 203 32 348 51" id="cmb_bizdetlcd" class="combo_search" innerdataset="@ds_init_C0033list_C0033" datacolumn="cdnm" codecolumn="cdid"/>
              <Static text="수신인 이름 :" position="absolute 654 9 750 26" id="caption4" class="search_name"/>
              <Static text="등록번호 :" position="absolute 725 35 801 52" id="caption22" class="search_name"/>
              <Edit position="absolute 800 33 880 52" id="input4" class="input_search" onkeyup="grp_johe_input4_onkeyup" autoselect="true"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid id="grd_smstrsmrsltlist" taborder="3" binddataset="ds_main_list_smstrsmrsltlist" useinputpanel="false" position="absolute 0 111 1005 535" autoenter="select" cellsizingtype="col" oncelldblclick="grd_smstrsmrsltlist_oncelldblclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="37" band="left"/>
                <Column size="120" band="left"/>
                <Column size="0" band="left"/>
                <Column size="120" band="left"/>
                <Column size="100" band="left"/>
                <Column size="80" band="left"/>
                <Column size="80" band="left"/>
                <Column size="269"/>
                <Column size="110"/>
                <Column size="80"/>
                <Column size="121"/>
                <Column size="50"/>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="40"/>
                <Column size="90"/>
                <Column size="80"/>
                <Column size="40"/>
                <Column size="0"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="38" 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" text="전송처리상태"/>
                <Cell col="11" text="건수"/>
                <Cell col="12" text="전송부서"/>
                <Cell col="13" text="예약발송요청일" wordwrap="word"/>
                <Cell col="14" text="예약발송요청시간" wordwrap="word"/>
                <Cell col="15" text="등록자"/>
                <Cell col="16" text="진료/검사예약일" wordwrap="word"/>
                <Cell col="17" text="진료/검사예약시간" wordwrap="word"/>
                <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="회신전화번호"/>
                <Cell col="25" text="즉시/예약 구분"/>
                <Cell col="26" text="전송여부"/>
                <Cell col="27" text="메시지대분류코드"/>
                <Cell col="28" text="메시지중분류코드"/>
                <Cell col="29" text="메시지소분류코드"/>
                <Cell col="30" text="전송부서코드"/>
                <Cell col="31" text="검사대분류명"/>
                <Cell col="32" text="검사중분류명"/>
                <Cell col="33" text="검사실명"/>
                <Cell col="34" text="처방코드"/>
                <Cell col="35" text="사용여부"/>
                <Cell col="36" text="HIS요청일시"/>
                <Cell col="37" text="HIS요청일"/>
                <Cell col="38" text="Agent읽은시간"/>
                <Cell col="39" text="Agent결과입력시간"/>
                <Cell col="40" text="DB반영일시"/>
                <Cell col="41" text="전송결과받은시간"/>
                <Cell col="42" text="메시지일련번호"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" text="bind:mtstrsmdt" mask="expr:utlf_isNull(mtstrsmdt) ? '' : '####-##-## ##:##'"/>
                <Cell col="2" text="bind:bizflag"/>
                <Cell col="3" displaytype="combo" style="align:center middle;" text="bind:bizdetlcd" combodataset="ds_init_C0033list_C0033" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                <Cell col="4" text="bind:recvrtelno"/>
                <Cell col="5" text="bind:recvrnm"/>
                <Cell col="6" text="bind:recvrpid"/>
                <Cell col="7" style="align:left middle;padding:0 3 0 3;" text="bind:msgcnts"/>
                <Cell col="8" text="bind:fstrgstdt" mask="expr:utlf_isNull(fstrgstdt) ? '' : '####-##-## ##:##'"/>
                <Cell col="9" displaytype="combo" style="align:center middle;" text="bind:msgstate" combodataset="ds_init_C0046list_C0046" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                <Cell col="10" displaytype="combo" style="align:center middle;" text="bind:trsmrsltcd" combodataset="ds_init_Z0010list_Z0010" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                <Cell col="11" text="bind:divcnt"/>
                <Cell col="12" style="align:left middle;padding:0 3 0 3;" text="bind:deptnm"/>
                <Cell col="13" displaytype="date" text="bind:delivedd" calendardisplaynulltype="none"/>
                <Cell col="14" text="bind:delivereqtm" mask="expr:utlf_isNull(delivereqtm) ? '' : '##:##'"/>
                <Cell col="15" text="bind:fstrgstrid"/>
                <Cell col="16" displaytype="date" text="bind:rsrvdd" calendardisplaynulltype="none"/>
                <Cell col="17" text="bind:rsrvtm" mask="expr:utlf_isNull(rsrvtm) ? '' : '##:##'"/>
                <Cell col="18" text="bind:orddrnm"/>
                <Cell col="19" text="bind:aprvflag"/>
                <Cell col="20" text="bind:cnclyn"/>
                <Cell col="21" text="bind:urgntflag"/>
                <Cell col="22" text="bind:cmpnnm"/>
                <Cell col="23" text="bind:cmpncd"/>
                <Cell col="24" text="bind:replytelno"/>
                <Cell col="25" text="bind:rsrvyn"/>
                <Cell col="26" text="bind:trsmyn"/>
                <Cell col="27" text="bind:msglrgcd"/>
                <Cell col="28" text="bind:msgmdlcd"/>
                <Cell col="29" text="bind:msgsmlcd"/>
                <Cell col="30" text="bind:deptcd"/>
                <Cell col="31" text="bind:earncls1nm"/>
                <Cell col="32" text="bind:earncls2nm"/>
                <Cell col="33" text="bind:basecdflagdesc"/>
                <Cell col="34" text="bind:prcpcd"/>
                <Cell col="35" text="bind:useyn"/>
                <Cell col="36" text="bind:trsmdt"/>
                <Cell col="37" text="bind:trsmdd"/>
                <Cell col="38" text="bind:smstrsmstartdt"/>
                <Cell col="39" text="bind:smstrsmenddt"/>
                <Cell col="40" text="bind:feedbackdt"/>
                <Cell col="41" text="bind:rsltrecvtm"/>
                <Cell col="42" text="bind:seqno"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption9" text="SMS 전송결과" class="tit_2" position="absolute 0 90 150 106"/>
        <Static id="caption51" text="- 수신결과 및 전송처리상태 상세 설명 -" position="absolute 395 86 656 107" tooltiptype="hover,mouseleave" tooltiptext="----------------------  수 신 결 과  ------------------------------------------   &#13;&#10;&#13;&#10;전송대기        : 메시지 발송 대기상태임.                                                                  &#13;&#10;번호오류        : 휴대폰 번호 없음, 집 전화번호 등 휴대폰 번호가 아님.(자체필터링)         &#13;&#10;내용무           : 전송할 메시지 내용이 없음.(자체필터링)                                             &#13;&#10;중복메시지     : 동일휴대폰으로 똑같은 메시지를 보낸 경우임.(자체필터링)                    &#13;&#10;시간중복제외  : 동일내용으로 예약된 진료/검사 시간이 일정시간 이내임.(자체필터링)     &#13;&#10;&#13;&#10;---------------------  전 송 처 리 상 태  --------------------------------------    &#13;&#10;&#13;&#10;발송결과확인      : 수신자의 휴대폰에 문자가 도착함.                                                  &#13;&#10;결번(잘못된번호) : 수신자의 휴대폰번호가 결번(잘못된 번호)임.                                   &#13;&#10;무응답               : 무응답, 단말기 꺼짐, 음영지역, 메시지 FULL의 경우임.                     &#13;&#10;단말기 오류        : 전화번호가 바뀌어서 안내가 나오는 휴대폰 번호,                              &#13;&#10;                          요금을 내지 않아서 수신금지된 번호임.                                           &#13;&#10;메시지수신거부   : 수신자가 메시지 수신거부를 한 경우임.                                          &#13;&#10;재전송오류         : 10분 이내에 동일 수신자에게 같은 메시지를 전송 요청하는 경우임.     &#13;&#10;TXQ EXPIRE      : 13시간 30분 동안 전송 시도 후 지속적으로 전송되지 않는 경우임.        &#13;&#10;                          (실제로 이동통신사에서는 24시간 동안 전송 시도함.)                      " style="font:Dotum,9,bold;"/>
        <Static id="caption7" text="건" position="absolute 905 91 930 108"/>
        <Static id="caption35" text="전체 :" position="absolute 827 91 867 108"/>
        <Edit id="output1" taborder="4" readonly="true" position="absolute 859 89 902 108" style="background:transparent stretch 5,5;"/>
        <Button id="btn_smsexcel" taborder="5" text="엑셀저장" class="btn7" position="absolute 924 87 1004 106" onclick="btn_smsexcel_onclick"/>
        <Shape id="line3" class="line_10" position="absolute 0 106 1005 112"/>
        <Shape id="line2" class="line_10" position="absolute 0 556 1005 562"/>
        <Static id="caption10" text="SMS 전송 상세" class="tit_2" position="absolute 0 540 120 556"/>
        <Static id="cap_msgmdlcd" text="예약구분" class="cell_1" position="absolute 0 561 105 584"/>
        <Combo id="combo1" taborder="6" innerdataset="@ds_init_C0033list_C0033" codecolumn="cdid" datacolumn="cdnm" enable="false" position="absolute 108 563 232 582" style="color:#262626ff;"/>
        <Static id="caption11" text="휴대폰 번호" class="cell_1" position="absolute 0 587 105 610"/>
        <Edit id="output2" taborder="7" position="absolute 108 589 232 608" class="output" readonly="true"/>
        <Static id="caption12" text="수신자 이름" class="cell_1" position="absolute 250 587 355 610"/>
        <Edit id="input2" taborder="8" position="absolute 358 589 482 608" class="output" readonly="true"/>
        <Static id="caption13" text="수신자 등록번호" class="cell_1" position="absolute 500 587 605 610"/>
        <Edit id="input3" taborder="9" position="absolute 608 589 742 608" class="output" readonly="true"/>
        <Static id="caption14" text="회신전화번호" class="cell_1" position="absolute 762 587 867 610"/>
        <Edit id="output3" taborder="10" position="absolute 870 589 1004 608" class="output" readonly="true"/>
        <Shape id="line5" class="line_2" position="absolute 0 609 1005 615"/>
        <Static id="caption15" text="메시지 내용" class="cell_1" position="absolute 250 561 355 584"/>
        <Edit id="input5" taborder="11" position="absolute 358 563 952 582" class="output" readonly="true"/>
        <Edit id="input1" taborder="12" position="absolute 955 563 982 582" readonly="true"/>
        <Static id="caption16" text="건" position="absolute 985 562 1005 585"/>
        <Static id="caption17" text="휴대폰도착시간" class="cell_1" position="absolute 250 613 355 636"/>
        <MaskEdit id="input7" mask="####-##-## ##:##" trimtype="both" position="absolute 358 615 482 634" class="output" readonly="true" maskchar=" " taborder="1" type="string" style="align:left middle;"/>
        <Static id="caption18" text="발송등록일" class="cell_1" position="absolute 0 613 105 636"/>
        <MaskEdit id="opt_fstrgstdt" taborder="0" mask="####-##-## ##:##" trimtype="both" position="absolute 108 615 232 634" class="output" readonly="true" maskchar=" " type="string" style="align:left middle;"/>
        <Shape id="line7" class="line_2" position="absolute 0 635 1005 641"/>
        <Static id="caption21" text="진료의" class="cell_1" position="absolute 250 639 355 662"/>
        <Edit id="input10" taborder="13" position="absolute 358 641 482 660" class="output" readonly="true"/>
        <Static id="caption23" text="전송부서" class="cell_1" position="absolute 0 639 105 662"/>
        <Edit id="output4" taborder="14" position="absolute 108 641 232 660" class="output" readonly="true"/>
        <Static id="caption25" text="발송(예정)시간" class="cell_1" position="absolute 500 613 605 636"/>
        <MaskEdit id="input14" taborder="15" mask="####-##-## ##:##" trimtype="both" position="absolute 608 615 742 634" class="output" readonly="true" type="string" style="align:left middle;" maskchar=" "/>
        <Static id="caption19" text="수신결과" class="cell_1" position="absolute 762 613 867 636"/>
        <Combo id="combo2" taborder="16" innerdataset="@ds_init_C0046list_C0046" codecolumn="cdid" datacolumn="cdnm" class="combo_default" position="absolute 870 615 1004 634" enable="false"/>
        <Static id="caption26" text="진료/검사일시" class="cell_1" position="absolute 500 639 605 662"/>
        <MaskEdit id="input15" taborder="17" mask="####-##-## ##:##" trimtype="both" position="absolute 608 641 742 660" class="output" readonly="true" type="string" style="align:left middle;" maskchar=" "/>
        <Static id="caption20" text="전송처리상태" class="cell_1" position="absolute 762 639 867 662"/>
        <Combo id="combo3" taborder="18" innerdataset="@ds_init_Z0010list_Z0010" codecolumn="cdid" datacolumn="cdnm" class="combo_default" enable="false" position="absolute 870 641 1004 660"/>
        <Edit id="output7" taborder="19" readonly="true" position="absolute 870 667 1004 686" style="color:#262626ff;"/>
        <Edit id="output5" taborder="20" position="absolute 108 667 232 686" class="output" readonly="true"/>
        <Edit id="output8" taborder="21" position="absolute 235 667 355 686" class="output" readonly="true"/>
        <Edit id="output9" taborder="22" position="absolute 358 667 482 686" class="output" readonly="true"/>
        <Static id="caption24" text="검사분류" class="cell_1" position="absolute 0 665 105 688"/>
        <Edit id="output10" taborder="23" readonly="true" position="absolute 608 667 742 686"/>
        <Static id="caption27" text="전송여부" class="cell_1" position="absolute 500 665 605 688"/>
        <Shape id="line8" class="line_3" position="absolute 0 687 1005 693"/>
        <Static id="caption28" text="취소여부" class="cell_1" position="absolute 762 665 867 688"/>
        <Shape id="line4" class="line_2" position="absolute 0 583 1005 589"/>
        <Shape id="line6" class="line_2" position="absolute 0 661 1005 667"/>
        <Static id="caption1" text="예약안내 SMS 전송결과 관리" class="tit_1" position="absolute 0 0 210 25"/>
      </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="msgstate" type="STRING" size="256"/>
          <Column id="bizflag" type="STRING" size="256"/>
          <Column id="cmpncd" type="STRING" size="256"/>
          <Column id="cmpnnm" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="recvrset" type="STRING" size="256"/>
          <Column id="recvrnm" type="STRING" size="256"/>
          <Column id="recvrtelno" type="STRING" size="256"/>
          <Column id="trsmrsltcd" type="STRING" size="256"/>
          <Column id="bizdetlcd" type="STRING" size="256"/>
          <Column id="fstrgstdt" type="STRING" size="256"/>
          <Column id="recvrpid" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="rgstfromdd"/>
            <Col id="rgsttodd"/>
            <Col id="msgstate"/>
            <Col id="bizflag">3</Col>
            <Col id="cmpncd"/>
            <Col id="cmpnnm"/>
            <Col id="deptnm"/>
            <Col id="deptcd"/>
            <Col id="recvrset"/>
            <Col id="recvrnm"/>
            <Col id="recvrtelno"/>
            <Col id="trsmrsltcd"/>
            <Col id="bizdetlcd"/>
            <Col id="fstrgstdt"/>
            <Col id="recvrpid"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_C0033list_C0033" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_C0046list_C0046" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_Z0010list_Z0010" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_list_smstrsmrsltlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="aprvcd" type="INT" size="256" sumtext="승인코드"/>
          <Column id="trsmdd" type="STRING" size="256" sumtext="발송요청일"/>
          <Column id="bizflag" type="STRING" size="256" sumtext="업무구분"/>
          <Column id="bizdetlcd" type="STRING" size="256" sumtext="업무상세구분"/>
          <Column id="rsrvdd" type="STRING" size="256" sumtext="진료검사예약일자"/>
          <Column id="rsrvtm" type="STRING" size="256" sumtext="진료검사예약시간"/>
          <Column id="recvrnm" type="STRING" size="256" sumtext="수신자명"/>
          <Column id="recvrtelno" type="STRING" size="256" sumtext="수신자전화번호"/>
          <Column id="replytelno" type="STRING" size="256" sumtext="회신자전화번호"/>
          <Column id="msglrgcd" type="INT" size="256" sumtext="메시지대분류코드"/>
          <Column id="msgmdlcd" type="INT" size="256" sumtext="메시지중분류코드"/>
          <Column id="msgsmlcd" type="INT" size="256" sumtext="메시지소분류코드"/>
          <Column id="rsrvyn" type="STRING" size="256" sumtext="예약전송여부"/>
          <Column id="recvrpid" type="STRING" size="256" sumtext="수신자등록번호"/>
          <Column id="urgntflag" type="STRING" size="256" sumtext="긴급여부"/>
          <Column id="delivedd" type="STRING" size="256" sumtext="예약전송일자"/>
          <Column id="delivereqtm" type="STRING" size="256" sumtext="예약전송시간"/>
          <Column id="trsmdt" type="STRING" size="256" sumtext="발송요청일시"/>
          <Column id="cmpncd" type="STRING" size="256" sumtext="캠페인코드"/>
          <Column id="cmpnnm" type="STRING" size="256" sumtext="캠페인명"/>
          <Column id="prcpcd" type="STRING" size="256" sumtext="처방코드"/>
          <Column id="deptcd" type="STRING" size="256" sumtext="작업부서코드"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="작업부서명"/>
          <Column id="msgstate" type="STRING" size="256" sumtext="메시지상태"/>
          <Column id="trsmrsltcd" type="STRING" size="256" sumtext="전송결과정보"/>
          <Column id="smstrsmstartdt" type="STRING" size="256" sumtext="Agent가메시지를읽어간일시"/>
          <Column id="mtstrsmdt" type="STRING" size="256" sumtext="이통사메시지전송일시"/>
          <Column id="smstrsmenddt" type="STRING" size="256" sumtext="Agent가처리결과SMS서버반영일시"/>
          <Column id="feedbackdt" type="STRING" size="256" sumtext="DB반영일시"/>
          <Column id="rsltrecvtm" type="STRING" size="256" sumtext="전송결과받은시간"/>
          <Column id="trsmyn" type="STRING" size="256" sumtext="전송여부"/>
          <Column id="rsltyn" type="STRING" size="256" sumtext="전송결과여부"/>
          <Column id="cnclyn" type="STRING" size="256" sumtext="취소여부"/>
          <Column id="useyn" type="STRING" size="256" sumtext="사용여부"/>
          <Column id="aprvflag" type="STRING" size="256" sumtext="승인구분"/>
          <Column id="earncls1nm" type="STRING" size="256" sumtext="검사대분류명"/>
          <Column id="earncls2nm" type="STRING" size="256" sumtext="검사중분류명"/>
          <Column id="basecdflagdesc" type="STRING" size="256" sumtext="검사실명"/>
          <Column id="fstrgstrid" type="STRING" size="256" sumtext="최초등록자"/>
          <Column id="fstrgstdt" type="STRING" size="256" sumtext="최초등록일시"/>
          <Column id="msgcnts" type="STRING" size="256" sumtext="단문메시지내용"/>
          <Column id="seqno" type="INT" size="256" sumtext="메시지일련번호"/>
          <Column id="divcnt" type="INT" size="256" sumtext="메시지분할건수"/>
          <Column id="orddrnm" type="STRING" size="256" sumtext="진료의"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main" 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_smstrsmrsltdetl" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="seqno" type="STRING" size="256"/>
          <Column id="bizflag" type="STRING" size="256"/>
          <Column id="bizdetlcd" type="STRING" size="256"/>
          <Column id="msgcnts" type="STRING" size="256"/>
          <Column id="divcnt" type="STRING" size="256"/>
          <Column id="recvrtelno" type="STRING" size="256"/>
          <Column id="recvrnm" type="STRING" size="256"/>
          <Column id="recvrpid" type="STRING" size="256"/>
          <Column id="replytelno" type="STRING" size="256"/>
          <Column id="fstrgstdt" type="STRING" size="256"/>
          <Column id="mtstrsmdt" type="STRING" size="256"/>
          <Column id="delivereqdt" type="STRING" size="256"/>
          <Column id="msgstate" type="STRING" size="256"/>
          <Column id="trsmrsltcd" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="orddrnm" type="STRING" size="256"/>
          <Column id="rsrvdt" type="STRING" size="256"/>
          <Column id="earncls1nm" type="STRING" size="256"/>
          <Column id="earncls2nm" type="STRING" size="256"/>
          <Column id="basecdflagdesc" type="STRING" size="256"/>
          <Column id="trsmyn" type="STRING" size="256"/>
          <Column id="rsrvyn" type="STRING" size="256"/>
          <Column id="cnclyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="seqno"/>
            <Col id="bizflag"/>
            <Col id="bizdetlcd"/>
            <Col id="msgcnts"/>
            <Col id="divcnt"/>
            <Col id="recvrtelno"/>
            <Col id="recvrnm"/>
            <Col id="recvrpid"/>
            <Col id="replytelno"/>
            <Col id="fstrgstdt"/>
            <Col id="mtstrsmdt"/>
            <Col id="delivereqdt"/>
            <Col id="msgstate"/>
            <Col id="trsmrsltcd"/>
            <Col id="deptnm"/>
            <Col id="orddrnm"/>
            <Col id="rsrvdt"/>
            <Col id="earncls1nm"/>
            <Col id="earncls2nm"/>
            <Col id="basecdflagdesc"/>
            <Col id="trsmyn"/>
            <Col id="rsrvyn"/>
            <Col id="cnclyn"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_johe.ipt_rgstfromdd" propid="value" datasetid="ds_send_data" columnid="rgstfromdd"/>
      <BindItem id="item1" compid="grp_johe.ipt_rgsttodd" propid="value" datasetid="ds_send_data" columnid="rgsttodd"/>
      <BindItem id="item2" compid="grp_johe.cmb_bizflag" propid="value" datasetid="ds_send_data" columnid="bizflag"/>
      <BindItem id="item3" compid="grp_johe.cmb_bizdetlcd" propid="value" datasetid="ds_send_data" columnid="bizdetlcd"/>
      <BindItem id="item4" compid="grp_johe.ipt_recvrnm" propid="value" datasetid="ds_send_data" columnid="recvrtelno"/>
      <BindItem id="item5" compid="grp_johe.cmb_msgstate" propid="value" datasetid="ds_send_data" columnid="msgstate"/>
      <BindItem id="item6" compid="grp_johe.cmb_trsmrsltcd" propid="value" datasetid="ds_send_data" columnid="trsmrsltcd"/>
      <BindItem id="item7" compid="grp_johe.ipt_recvrtelno" propid="value" datasetid="ds_send_data" columnid="recvrnm"/>
      <BindItem id="item8" compid="grp_johe.input4" propid="value" datasetid="ds_send_data" columnid="recvrpid"/>
      <BindItem id="item9" compid="output1" propid="value" datasetid="ds_main" columnid="countnode"/>
      <BindItem id="item10" compid="combo1" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="bizdetlcd"/>
      <BindItem id="item11" compid="output2" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="recvrtelno"/>
      <BindItem id="item19" compid="input2" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="recvrnm"/>
      <BindItem id="item21" compid="input3" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="recvrpid"/>
      <BindItem id="item28" compid="output3" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="replytelno"/>
      <BindItem id="item20" compid="input5" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="msgcnts"/>
      <BindItem id="item29" compid="input1" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="divcnt"/>
      <BindItem id="item18" compid="input7" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="mtstrsmdt"/>
      <BindItem id="item12" compid="opt_fstrgstdt" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="fstrgstdt"/>
      <BindItem id="item17" compid="input10" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="orddrnm"/>
      <BindItem id="item13" compid="output4" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="deptnm"/>
      <BindItem id="item22" compid="input14" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="delivereqdt"/>
      <BindItem id="item27" compid="combo2" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="msgstate"/>
      <BindItem id="item23" compid="input15" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="rsrvdt"/>
      <BindItem id="item26" compid="combo3" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="trsmrsltcd"/>
      <BindItem id="item25" compid="output7" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="cnclyn"/>
      <BindItem id="item14" compid="output5" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="earncls1nm"/>
      <BindItem id="item15" compid="output8" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="earncls2nm"/>
      <BindItem id="item16" compid="output9" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="basecdflagdesc"/>
      <BindItem id="item24" compid="output10" propid="value" datasetid="ds_main_smstrsmrsltdetl" columnid="trsmyn"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************
 * System Name		:	경대 의료정보시스템
 * Job Name 		:	crm_channelxp -> SPCNS00500
 * Creator			:	yjh
 * Make Date 		:	2016-10-31
 * Description		:	
 *---------------------------------------------------------------------------------------
 * Modify Date		Modifier		Modify Description
 *---------------------------------------------------------------------------------------
 * 2016-10-31		yjh				TF->XP
 * 
 *---------------------------------------------------------------------------------------
 ****************************************************************************************/
//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";


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

function SPCNS00500_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_smstrsmrsltlist);
	grdf_setToolTipBind(grd_smstrsmrsltlist)
	// 전송결과 그리드를 초기화한다.
	ds_main_list_smstrsmrsltlist.clearData();

	// 공통코드를 호출하여 자료(메시지상태,단문메시지전송결과,업무구분)를 가져온다 
	var arrParam = [{dsNm: "ds_init_C0046list_C0046", cdGrpId: "C0046"}
				   ,{dsNm: "ds_init_Z0010list_Z0010", cdGrpId: "Z0010"}
				   ,{dsNm: "ds_init_C0033list_C0033", cdGrpId: "C0033"}]
	appf_getCodeList(arrParam); 
	
	// 빈 row 추가함
	ds_init_C0046list_C0046.insertRow(0);
	ds_init_C0033list_C0033.insertRow(0);
	
	// 콤보타입의 검색조건에 "전체" 추가
	ds_init_Z0010list_Z0010.insertRow(0);
	ds_init_Z0010list_Z0010.setColumn(0, "cdnm", "발송결과확인");   //업무구분 콤보 "전체"추가
	ds_init_Z0010list_Z0010.setColumn(0, "cdid", "AA00");

	// 등록일의 값이 없으면 최근한달로 셋팅한다.
	var rgstfromdd = ds_send_data.getColumn(0, "rgstfromdd");
	var rgsttodd = ds_send_data.getColumn(0, "rgsttodd");

	if (utlf_isNull(rgstfromdd))
	{
		ds_send_data.setColumn(0, "rgstfromdd",utlf_getCurrentDate().toDate().getAddDate(-7,"D").getDateFormat());
	}
	if (utlf_isNull(rgsttodd))
	{
		ds_send_data.setColumn(0, "rgsttodd", utlf_getCurrentDate());
	}
	fCheckAuth();
}


function fCheckAuth() 
{
	// 권한체크
	if (!frmf_checkAuth("r")) 
	{
		grp_johe.btn_search.enable = false;
	}
	
	if (!frmf_checkAuth("p")) 
	{
		btn_smsexcel.enable = false;
	}
}

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

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

function grp_johe_ipt_recvrnm_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		grp_johe.btn_search.click();
	}
}

function grp_johe_ipt_recvrtelno_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		grp_johe.btn_search.click();
	}
}

function grp_johe_cmb_msgstate_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	var rmsgstate = obj.value;
	if(rmsgstate == "ZM02")
	{
		grp_johe.cmb_trsmrsltcd.enable = true;
		grp_johe.cmb_trsmrsltcd.value = "";
	}
	else
	{
		grp_johe.cmb_trsmrsltcd.enable = false;
		grp_johe.cmb_trsmrsltcd.value = "";
	}
}

function grp_johe_input4_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		grp_johe.btn_search.click();
	}
}

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

function fGetSMSList() 
{
	ds_main_list_smstrsmrsltlist.clearData();
	
	var oParam = {};
		oParam.id          = "TRCNS00101";
		oParam.service     = "chnlmngtapp.ChnlMngt";
		oParam.method      = "reqGetSMSList";
		oParam.inds        = "req=ds_send_data";
		oParam.outds       = "ds_main_list_smstrsmrsltlist=smstrsmrsltlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRCNS00101";

	tranf_submit(oParam);
	
	var grid_rows = ds_main_list_smstrsmrsltlist.rowcount;
	ds_main.setColumn(0, "countnode" , grid_rows);
	ds_main_smstrsmrsltdetl.clearData();
	ds_main_smstrsmrsltdetl.addRow();
}

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

function grd_smstrsmrsltlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	fGetSMSTrsmRsltAttr(); // SMS메시지 정보조회
}

function fGetSMSTrsmRsltAttr() 
{
	var row = ds_main_list_smstrsmrsltlist.rowposition;

	// 선택한 채널관리 리스트항목의 내용을 뿌려준다.
	ds_main_smstrsmrsltdetl.copyData(ds_main_list_smstrsmrsltlist);
	ds_main_smstrsmrsltdetl.clearData();
	ds_main_smstrsmrsltdetl.copyRow(ds_main_smstrsmrsltdetl.addRow(), ds_main_list_smstrsmrsltlist, row);	

	var delivedd = ds_main_smstrsmrsltdetl.getColumn(0, "delivedd");
	var delivereqtm = ds_main_smstrsmrsltdetl.getColumn(0, "delivereqtm");
	dsf_makeValue(ds_main_smstrsmrsltdetl, "delivereqdt", "string", delivedd+delivereqtm);		// 예약발송요청일
	
	var rsrvdd = ds_main_smstrsmrsltdetl.getColumn(0, "rsrvdd");
	var rsrvtm = ds_main_smstrsmrsltdetl.getColumn(0, "rsrvtm");
	dsf_makeValue(ds_main_smstrsmrsltdetl, "rsrvdt", "string", rsrvdd+rsrvtm);					// 진료/검시일

	
// 	var seqno = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("seqno"));
// 	model.setValue("/root/main/smstrsmrsltdetl/seqno",seqno);										// 메시지 일련번호
// 	var bizflag = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("bizflag"));
// 	model.setValue("/root/main/smstrsmrsltdetl/bizflag",bizflag);										// 업무구분
// 	var bizdetlcd = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("bizdetlcd"));
// 	model.setValue("/root/main/smstrsmrsltdetl/bizdetlcd",bizdetlcd);									// 예약상세
// 	var msgcnts = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("msgcnts"));
// 	model.setValue("/root/main/smstrsmrsltdetl/msgcnts",msgcnts);									// 메시지 내용
// 	var divcnt = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("divcnt"));
// 	model.setValue("/root/main/smstrsmrsltdetl/divcnt",divcnt);										// 건수
// 	var recvrtelno = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("recvrtelno"));
// 	model.setValue("/root/main/smstrsmrsltdetl/recvrtelno",recvrtelno);									// 수신자전화번호
// 	var recvrnm = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("recvrnm"));
// 	model.setValue("/root/main/smstrsmrsltdetl/recvrnm",recvrnm);									// 수신자명
// 	var recvrpid = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("recvrpid"));
// 	model.setValue("/root/main/smstrsmrsltdetl/recvrpid",recvrpid);									// 수신자등록번호
// 	var replytelno = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("replytelno"));
// 	model.setValue("/root/main/smstrsmrsltdetl/replytelno",replytelno);									// 회신전화번호
// 	var fstrgstdt = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("fstrgstdt"));
// 	model.setValue("/root/main/smstrsmrsltdetl/fstrgstdt",fstrgstdt);									// 발송등록일
// 	var mtstrsmdt = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("mtstrsmdt"));
// 	model.setValue("/root/main/smstrsmrsltdetl/mtstrsmdt",mtstrsmdt);									// 휴대폰 도착시간
// 	var msgstate = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("msgstate"));
// 	model.setValue("/root/main/smstrsmrsltdetl/msgstate",msgstate);									// 메시지상태
// 	var trsmrsltcd = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("trsmrsltcd"));
// 	model.setValue("/root/main/smstrsmrsltdetl/trsmrsltcd",trsmrsltcd);									// 전송상태코드
// 	var deptnm = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("deptnm"));
// 	model.setValue("/root/main/smstrsmrsltdetl/deptnm",deptnm);										// 부서명
// 	var orddrnm = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("orddrnm"));
// 	model.setValue("/root/main/smstrsmrsltdetl/orddrnm",orddrnm);									// 진료의
// 	var rsrvdd = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("rsrvdd"));
// 	var rsrvtm = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("rsrvtm"));
// 	model.setValue("/root/main/smstrsmrsltdetl/rsrvdt",rsrvdd+rsrvtm);									// 진료/검시일
// 	var earncls1nm = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("earncls1nm"));
// 	model.setValue("/root/main/smstrsmrsltdetl/earncls1nm",earncls1nm);								// 검사대분류
// 	var earncls2nm = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("earncls2nm"));
// 	model.setValue("/root/main/smstrsmrsltdetl/earncls2nm",earncls2nm);								// 검사중분류
// 	var basecdflagdesc = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("basecdflagdesc"));
// 	model.setValue("/root/main/smstrsmrsltdetl/basecdflagdesc",basecdflagdesc);						// 검사실
// 	var trsmyn = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("trsmyn"));
// 	model.setValue("/root/main/smstrsmrsltdetl/trsmyn",trsmyn);										// 전송여부
// 	var rsrvyn = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("rsrvyn"));
// 	model.setValue("/root/main/smstrsmrsltdetl/rsrvyn",rsrvyn);										// 즉시/예약
// 	var cnclyn = grd_smstrsmrsltlist.valueMatrix(row, grd_smstrsmrsltlist.colRef("cnclyn"));
// 	model.setValue("/root/main/smstrsmrsltdetl/cnclyn",cnclyn);										// 취소여부
}]]></Script>
  </Form>
</FDL>