YNU_JEUS/app_home/himed/xpapps/crm/statisticsxp/xp/SMCSN00500_기관별SMS전송통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMCSN00500" position="absolute 0 0 1199 781" titletext="Untitle" oninit="SMCSN00500_oninit" onload="SMCSN00500_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="기관별 SMS 전송통계" class="tit_1" position="absolute 0 0 189 24"/>
        <Static id="caption26" text="SMS 전송통계" class="tit_2" position="absolute 0 111 174 132"/>
        <Shape id="line9" class="line_10" position="absolute 0 127 1195 133" anchor="left top right"/>
        <Shape id="line12" linetype="horizontal" class="line_3" position="absolute 0 745 1194 751" anchor="left right bottom"/>
        <Grid id="grd_statlist" taborder="2" binddataset="ds_main_list_statlist" useinputpanel="false" position="absolute 0 132 1195 746" autoenter="select" cellsizingtype="col" anchor="all" onkeydown="grd_statlist_onkeydown" selecttype="multirow">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="140"/>
                <Column size="91"/>
                <Column size="70"/>
                <Column size="70"/>
                <Column size="77"/>
                <Column size="55"/>
                <Column size="70"/>
                <Column size="70"/>
                <Column size="70"/>
                <Column size="61"/>
                <Column size="66"/>
                <Column size="72"/>
                <Column size="90"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="82"/>
                <Column size="82"/>
                <Column size="83"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" text="일자" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="발송전체건수" taborder="undefined"/>
                <Cell col="2" colspan="2" text="업무구분" taborder="undefined"/>
                <Cell col="4" rowspan="2" text="성공건수" taborder="undefined"/>
                <Cell col="5" rowspan="2" text="성공율" taborder="undefined"/>
                <Cell col="6" colspan="3" text="기타" taborder="undefined"/>
                <Cell col="9" rowspan="2" text="전송중" taborder="undefined"/>
                <Cell col="10" rowspan="2" text="전송실패" taborder="undefined"/>
                <Cell col="11" colspan="8" text="전송실패 세부내역" taborder="undefined"/>
                <Cell row="1" col="2" text="예약전송"/>
                <Cell row="1" col="3" text="수동전송"/>
                <Cell row="1" col="6" text="번호오류"/>
                <Cell row="1" col="7" text="시간중복"/>
                <Cell row="1" col="8" text="중복메시지"/>
                <Cell row="1" col="11" text="결번"/>
                <Cell row="1" col="12" text="단말기오류"/>
                <Cell row="1" col="13" text="무응답"/>
                <Cell row="1" col="14" text="메시지수신거부"/>
                <Cell row="1" col="15" text="재전송오류"/>
                <Cell row="1" col="16" text="TXQ Expire"/>
                <Cell row="1" col="17" text="거부됨"/>
                <Cell row="1" col="18" text="기타오류"/>
              </Band>
              <Band id="body">
                <Cell style="align:center middle;" text="bind:delivedd"/>
                <Cell col="1" displaytype="text" style="align:center middle;" text="bind:trsmcntcnt"/>
                <Cell col="2" displaytype="text" style="align:center middle;" text="bind:rsrtrsmcnt"/>
                <Cell col="3" displaytype="text" style="align:center middle;" text="bind:pssvtytrsmcnt"/>
                <Cell col="4" displaytype="text" style="align:center middle;" text="bind:succdcntcnt"/>
                <Cell col="5" displaytype="text" style="align:center middle;" text="bind:succdrate"/>
                <Cell col="6" displaytype="text" style="align:center middle;" text="bind:numbererrcnt"/>
                <Cell col="7" displaytype="text" style="align:center middle;" text="bind:timeoverlapexemptcnt"/>
                <Cell col="8" displaytype="text" style="align:center middle;" text="bind:overlapmsgcnt"/>
                <Cell col="9" displaytype="text" style="align:center middle;" text="bind:trsmingcnt"/>
                <Cell col="10" displaytype="text" style="align:center middle;" text="bind:errcnt"/>
                <Cell col="11" displaytype="text" style="align:center middle;" text="bind:wrongnumcnt"/>
                <Cell col="12" displaytype="text" style="align:center middle;" text="bind:termerrcnt"/>
                <Cell col="13" displaytype="text" style="align:center middle;" text="bind:norespcnt"/>
                <Cell col="14" displaytype="text" style="align:center middle;" text="bind:mrejectcnt"/>
                <Cell col="15" displaytype="text" style="align:center middle;" text="bind:retrsmcnt"/>
                <Cell col="16" displaytype="text" style="align:center middle;" text="bind:txqexpirecnt"/>
                <Cell col="17" displaytype="text" style="align:center middle;" text="bind:rrejectcnt"/>
                <Cell col="18" displaytype="text" style="align:center middle;" text="bind:etc"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Div id="group2" taborder="3" class="div_SA" position="absolute 0 24 1195 84" anchor="left top right">
          <Layouts>
            <Layout>
              <Button id="btn_search" taborder="1" text="조회" class="btn1" position="absolute 1116 19 1172 41" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Shape id="line1" linetype="vertical" class="line_4" position="absolute 1097 10 1103 52" anchor="top right"/>
              <Calendar id="ipt_fromdd" taborder="2" class="input_search" position="absolute 92 9 193 28" mask="yyyy-mm-dd" tooltiptext="전송일자는 1년 미만의 기간을 입력하셔야 합니다." autoselect="true" autoskip="true"/>
              <Static id="cap_trsmdate" text="전송일자" class="search_name" position="absolute 14 9 93 26"/>
              <Calendar id="ipt_todd" taborder="3" class="input_search" position="absolute 216 9 317 28" mask="yyyy-mm-dd" autoselect="true" tooltiptext="전송일자는 1년 미만의 기간을 입력하셔야 합니다."/>
              <Static id="caption1" text="~" position="absolute 198 9 218 29"/>
              <Combo id="cmb_years" taborder="4" innerdataset="@ds_hidden_itemset_item" codecolumn="val" datacolumn="lbl" class="combo_s_essential" enable="false" position="absolute 414 9 499 28"/>
              <CheckBox id="chk_srchcond" taborder="5" text="연도/월" truevalue="Y" position="absolute 325 7 401 28" style="font:Dotum,9,bold;" onclick="group2_chk_srchcond_onclick"/>
              <Static id="caption2" text="년" position="absolute 503 7 524 32" style="font:Dotum,9,bold;"/>
              <Combo id="cmb_month" taborder="6" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_s_essential" enable="false" position="absolute 524 9 574 28">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">01</Col>
                      <Col id="datacolumn">1</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">02</Col>
                      <Col id="datacolumn">2</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">03</Col>
                      <Col id="datacolumn">3</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">04</Col>
                      <Col id="datacolumn">4</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">05</Col>
                      <Col id="datacolumn">5</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">06</Col>
                      <Col id="datacolumn">6</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">07</Col>
                      <Col id="datacolumn">7</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">08</Col>
                      <Col id="datacolumn">8</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">09</Col>
                      <Col id="datacolumn">9</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">10</Col>
                      <Col id="datacolumn">10</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">11</Col>
                      <Col id="datacolumn">11</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">12</Col>
                      <Col id="datacolumn">12</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption3" text="월" position="absolute 579 7 600 32" style="font:Dotum,9,bold;"/>
              <Static id="caption5" text="업무구분" class="search_name" position="absolute 14 38 93 55"/>
              <Combo id="cmb_BizFlag" taborder="7" innerdataset="@ds_init_C0028list_C0028" codecolumn="cdid" datacolumn="cdnm" class="combo_search" position="absolute 92 35 222 54" onitemchanged="group2_cmb_BizFlag_onitemchanged"/>
              <Combo id="cmb_BizDetlCd" taborder="8" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_search" enable="false" position="absolute 226 35 366 54">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn"/>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">01</Col>
                      <Col id="datacolumn">외래예약</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">03</Col>
                      <Col id="datacolumn">검사예약</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">04</Col>
                      <Col id="datacolumn">건진예약</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">02</Col>
                      <Col id="datacolumn">가예약</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption4" text="해당기관 :" class="search_name" position="absolute 630 10 709 27"/>
              <Combo id="cmb_SrchVsInsrcd" taborder="9" innerdataset="@ds_init_A0607list_A0607" codecolumn="cdid" datacolumn="cdnm" class="combo_search" position="absolute 716 9 846 28"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_save_excel" taborder="4" text="엑셀저장" class="btn7" position="absolute 1115 108 1195 127" anchor="top right" onclick="btn_save_excel_onclick"/>
        <Button id="button1" taborder="5" text="도움말" class="btn2" position="absolute 1061 108 1114 127" anchor="top right" onclick="button1_onclick"/>
        <Button id="btn_report13" taborder="6" text="보고서" class="btn4" visible="false" position="absolute 1042 757 1110 779" anchor="right bottom"/>
        <Button id="btn_init" taborder="7" text="초기화" class="btn4" position="absolute 1126 757 1194 779" anchor="right bottom" onclick="btn_init_onclick"/>
        <Shape id="line32" class="line_6" position="absolute 0 753 1194 759" anchor="left right bottom"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="srchvsinstcd" type="STRING" size="256"/>
          <Column id="srchcond" type="STRING" size="256"/>
          <Column id="year" type="STRING" size="256"/>
          <Column id="month" type="STRING" size="256"/>
          <Column id="srchbizflag" type="STRING" size="256"/>
          <Column id="srchbizdetlcd" type="STRING" size="256"/>
          <Column id="logo_pic" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="srchvsinstcd"/>
            <Col id="srchcond"/>
            <Col id="year"/>
            <Col id="month"/>
            <Col id="srchbizflag"/>
            <Col id="srchbizdetlcd"/>
            <Col id="logo_pic"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_A0607list_A0607" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_C0028list_C0028" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_list_statlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="delivedd" type="STRING" size="256" sumtext="체크"/>
          <Column id="trsmcntcnt" type="STRING" size="256" sumtext="적용"/>
          <Column id="rsrtrsmcnt" type="STRING" size="256" sumtext="예고"/>
          <Column id="pssvtytrsmcnt" type="STRING" size="256" sumtext="평가종류코드"/>
          <Column id="succdcntcnt" type="STRING" size="256" sumtext="평가종류명칭"/>
          <Column id="succdrate" type="STRING" size="256" sumtext="진료과명"/>
          <Column id="numbererrcnt" type="STRING" size="256" sumtext="환자번호"/>
          <Column id="timeoverlapexemptcnt" type="STRING" size="256" sumtext="환자이름"/>
          <Column id="overlapmsgcnt" type="STRING" size="256" sumtext="성별"/>
          <Column id="trsmingcnt" type="STRING" size="256" sumtext="나이"/>
          <Column id="errcnt" type="STRING" size="256" sumtext="유형"/>
          <Column id="wrongnumcnt" type="STRING" size="256" sumtext="메모"/>
          <Column id="termerrcnt" type="STRING" size="256" sumtext="입원일자"/>
          <Column id="norespcnt" type="STRING" size="256" sumtext="퇴원일자"/>
          <Column id="mrejectcnt" type="STRING" size="256" sumtext="심사상병"/>
          <Column id="retrsmcnt" type="STRING" size="256" sumtext="진료상병"/>
          <Column id="txqexpirecnt" type="STRING" size="256" sumtext="관련처방"/>
          <Column id="rrejectcnt" type="STRING" size="256" sumtext="처방명"/>
          <Column id="etc" type="STRING" size="256" sumtext="심사자"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_hidden_itemset_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.ipt_fromdd" propid="value" datasetid="ds_send_data" columnid="fromdd"/>
      <BindItem id="item1" compid="group2.ipt_todd" propid="value" datasetid="ds_send_data" columnid="todd"/>
      <BindItem id="item2" compid="group2.chk_srchcond" propid="value" datasetid="ds_send_data" columnid="srchcond"/>
      <BindItem id="item3" compid="group2.cmb_years" propid="value" datasetid="ds_send_data" columnid="year"/>
      <BindItem id="item4" compid="group2.cmb_month" propid="value" datasetid="ds_send_data" columnid="month"/>
      <BindItem id="item5" compid="group2.cmb_SrchVsInsrcd" propid="value" datasetid="ds_send_data" columnid="srchvsinstcd"/>
      <BindItem id="item6" compid="group2.cmb_BizFlag" propid="value" datasetid="ds_send_data" columnid="srchbizflag"/>
      <BindItem id="item7" compid="group2.cmb_BizDetlCd" propid="value" datasetid="ds_send_data" columnid="srchbizdetlcd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2016-05-24
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-05-24      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
function SMCSN00500_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMCSN00500_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_statlist);
	
	// 공통코드 조회
	var arrParam = [{dsNm: "ds_init_A0607list_A0607", cdGrpId: "A0607"}
				   ,{dsNm: "ds_init_C0028list_C0028", cdGrpId: "C0028"}]
	appf_getCodeList(arrParam); 
	
	ds_init_C0028list_C0028.insertRow(0);
	ds_init_C0028list_C0028.setColumn(0, "cdid", "");
	ds_init_C0028list_C0028.setColumn(0, "cdnm", "전체");
	
	var syscd = "CRM" + sysf_getUserInfo("dutplceinstcd");
	var piclogo = rptf_getLogoImageURL(syscd);
	ds_send_data.setColumn(0, "logo_pic", piclogo);
	
	fInitialize();
}

function fInitialize()
{					
	// 그리드 공라인 없애기
	
	var curDate = utlf_getCurrentDate();
	var currentYear = utlf_getNewDate().getFullYear();
	var currentMonth= utlf_getNewDate().getMonth() + 1;
	var currentMonth   = (("" + currentMonth).length == 1) ? "0" + currentMonth : "" + currentMonth;
	var piclogo = rptf_getLogoImageURL();
	
	makeSrchYearItem();
	
	ds_send_data.setColumn(0, "fromdd",curDate);
	ds_send_data.setColumn(0, "todd",curDate);
	ds_send_data.setColumn(0, "year",currentYear);
	ds_send_data.setColumn(0, "month",currentMonth);
	ds_send_data.setColumn(0, "logo_pic",piclogo);
}

function makeSrchYearItem()
{
	ds_hidden_itemset_item.clearData(); // item 초기화
	
	// 현재 Year
	var curYear = utlf_getNewDate().getFullYear();
	// 초기 데이타가 2007년부터 있으므로
	var minYear = "2007"
	// Item Node
	var itemNode = null;
	var count = 0;
	for( var i = curYear; i >= minYear; i-- ) 
	{
		dsf_makeValue(ds_hidden_itemset_item, "lbl", "string", i, count);
		dsf_makeValue(ds_hidden_itemset_item, "val", "string", i, count);
		
		count++;
	}
}
function group2_chk_srchcond_onclick(obj:CheckBox,  e:ClickEventInfo)
{
	if(obj.value == "Y")
	{
		// 전송일자 비활성화
		group2.ipt_fromdd.enable = false;
		group2.ipt_todd.enable = false;
		
		// 연도/월 활성화
		group2.cmb_years.enable = true;
		group2.cmb_month.enable = true;
	}
	else
	{
		ds_send_data.setColumn(0, "srchcond", "");
		
		// 전송일자 비활성화
		group2.ipt_fromdd.enable = true;
		group2.ipt_todd.enable = true;
		
		// 연도/월 활성화
		group2.cmb_years.enable = false;
		group2.cmb_month.enable = false;
	}
}

function group2_cmb_BizFlag_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	if (obj.value == "3")
	{
		group2.cmb_BizDetlCd.enable = true;
	}
	else 
	{
		group2.cmb_BizDetlCd.enable = false;
		ds_send_data.setColumn(0, "srchbizdetlcd", "");
	}
}

function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetStatList();
}

function fGetStatList()
{				
	// 전송할 send 데이터 작성
	var year 		= ds_send_data.getColumn(0, "year");
	var month 		= ds_send_data.getColumn(0, "month");
	var srchcond 	= ds_send_data.getColumn(0, "srchcond");
	var fromdd 		= ds_send_data.getColumn(0, "fromdd");
	var todd 		= ds_send_data.getColumn(0, "todd");

	if (srchcond != "Y") // 전송일자일 경우
	{
		if (utlf_isNull(fromdd) && utlf_isNull(todd))
		{
			sysf_messageBox("전송일자를 ", "C001");
			return; // 리턴함
		}
		else if (fromdd  >  todd)
		{
			sysf_messageBox("시작일자가 종료일자보다 앞서있습니다. 수정해주십시오.", "E999");
			return;// 리턴함
		}
		else if (todd - fromdd > 10000)
		{
			sysf_messageBox("검색기간은 1년을 초과할 수 없습니다. 수정해주십시오.", "E999");
			return;// 리턴함
		}

	}
	else // 년/월일경우
	{
		// 해당월의 처음일자
		fromdd = year.toString() + month.toString() + "01";

		// 해당월의 마지막일자
		newDateObj = new Date(year, month, 0) ;

		todd = year.toString() + month.toString() + newDateObj.getDate();
	}
	
	//전송 할 값을 세팅
	ds_send_data.setColumn(0, "srchcond", fromdd);
	ds_send_data.setColumn(0, "todd", todd);

	var oParam = {};
		oParam.id          = "TRPIJ02801";
		oParam.service     = "statsmngtapp.StatsMngt";
		oParam.method      = "reqGetInstSmsTrnsStats";
		oParam.inds        = "req=ds_send_data";
		oParam.outds       = "ds_main_list_statlist=statlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRPIJ02801";

	tranf_submit(oParam);
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	frmf_modal("SPZMS00200", "SPZMS00200", "", "", "", "", "", "", "", "", "", "", "M");
}

function btn_save_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	var fromdd = ds_send_data.getColumn(0, "fromdd");
	var todd = ds_send_data.getColumn(0, "todd");
	var system = ds_send_data.getColumn(0, "srchvsinstcd");
	
	if(utlf_isNull(system)) system = "전체"
	
	var excelFileName = "기관별SMS전송통계("+system+")_"+fromdd+"~"+ todd;
	
	grdf_exportExcel(grd_statlist, excelFileName, "Sheet1", "true", "", "");
}

function grd_statlist_onkeydown(obj:Grid, e:KeyEventInfo)
{
	if (e.ctrlKey == true && e.keycode == 67 )
	{
		grdf_clipboardCopy(obj);
	}
}

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