YNU_JEUS/app_home/himed/xpapps/emr/anstrecxp/xp/SMMMR04000_SAPS3.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMMMR04000" position="absolute 0 0 1250 820" titletext="SAPS3 조회" oninit="SMMMR04000_oninit" onload="SMMMR04000_onload">
    <Layouts>
      <Layout>
        <Shape id="roundrect1" type="roundrectangle" position="absolute 10 25 1240 60"/>
        <Static text="SAPS3" position="absolute 10 0 86 25" id="caption6" class="tit_1"/>
        <Shape position="absolute 973 31 979 55" linetype="vertical" id="line13" class="line_4"/>
        <Static text="입실일자" position="absolute 298 34 363 51" id="caption2" class="search_name"/>
        <Shape position="absolute 12 61 1239 67" linetype="horizontal" id="line12" class="line_10"/>
        <Static text="중환자실" position="absolute 638 34 703 51" id="caption29" class="search_name"/>
        <Calendar position="absolute 370 33 463 52" id="ipt_reqstnddd" class="input_essential" mask="yyyy-mm-dd" onchanged="ipt_reqstnddd_onchanged" taborder="1"/>
        <Calendar position="absolute 469 33 562 52" id="ipt_reqenddd" class="input_essential" mask="yyyy-mm-dd" onchanged="ipt_reqenddd_onchanged" taborder="2"/>
        <Combo position="absolute 569 33 629 52" id="cmb_term" class="combo_search" codecolumn="codecolumn" datacolumn="datacolumn" onitemchanged="cmb_term_onitemchanged" taborder="3">
          <Dataset id="innerdataset">
            <ColumnInfo>
              <Column id="codecolumn"/>
              <Column id="datacolumn"/>
            </ColumnInfo>
            <Rows>
              <Row>
                <Col id="codecolumn">0</Col>
                <Col id="datacolumn">
                </Col>
              </Row>
              <Row>
                <Col id="codecolumn">90</Col>
                <Col id="datacolumn">3개월</Col>
              </Row>
              <Row>
                <Col id="codecolumn">180</Col>
                <Col id="datacolumn">6개월</Col>
              </Row>
              <Row>
                <Col id="codecolumn">270</Col>
                <Col id="datacolumn">9개월</Col>
              </Row>
              <Row>
                <Col id="codecolumn">365</Col>
                <Col id="datacolumn">1년</Col>
              </Row>
              <Row>
                <Col id="codecolumn">730</Col>
                <Col id="datacolumn">2년</Col>
              </Row>
            </Rows>
          </Dataset>
        </Combo>
        <Combo position="absolute 703 33 790 52" id="cmb_icu" class="combo_search" innerdataset="@ds_init_ward_icudept" datacolumn="deptnm" codecolumn="deptcd" onitemchanged="cmb_icu_onitemchanged" taborder="4"/>
        <Combo position="absolute 862 33 960 52" id="cmb_orddeptcd" class="combo_search" innerdataset="@ds_init_orddept_dept" datacolumn="depthngnm" codecolumn="deptcd" onitemchanged="cmb_orddeptcd_onitemchanged" taborder="5"/>
        <Button position="absolute 1171 32 1227 54" id="btn_excel" class="btn7" text="엑셀" onclick="btn_excel_onclick" taborder="6"/>
        <Static text="진 료 과" position="absolute 799 34 864 51" id="caption3" class="search_name"/>
        <Button position="absolute 1113 32 1169 54" id="button1" class="btn1" text="조회" onclick="button1_onclick" taborder="7"/>
        <Grid id="grd_list" taborder="8" binddataset="ds_main_list_item" useinputpanel="false" selecttype="multirow" oncelldblclick="grd_list_oncelldblclick" position="absolute 9 67 1239 814">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="20"/>
                <Column size="28"/>
                <Column size="64"/>
                <Column size="54"/>
                <Column size="36"/>
                <Column size="39"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="55"/>
                <Column size="40"/>
                <Column size="117"/>
                <Column size="120"/>
                <Column size="109"/>
                <Column size="114"/>
                <Column size="107"/>
                <Column size="64"/>
                <Column size="117"/>
                <Column size="74"/>
                <Column size="44"/>
                <Column size="100"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" displaytype="checkbox" edittype="checkbox"/>
                <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="cretno"/>
                <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" text="사망(ICU)"/>
                <Cell col="17" text="진료과"/>
                <Cell col="18" text="중환자실"/>
                <Cell col="19" text="점수"/>
                <Cell col="20" text="예측사망율(%)"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="expr:currow + 1"/>
                <Cell col="1" displaytype="checkbox" edittype="checkbox" text="bind:chk"/>
                <Cell col="2" text="bind:pid"/>
                <Cell col="3" style="align:left;" text="bind:hngnm"/>
                <Cell col="4" text="bind:age"/>
                <Cell col="5" text="bind:sex"/>
                <Cell col="6" text="bind:orddd"/>
                <Cell col="7" text="bind:fromdd"/>
                <Cell col="8" text="bind:cretno"/>
                <Cell col="9" style="align:left;" text="bind:insukind"/>
                <Cell col="10" text="bind:rn"/>
                <Cell col="11" style="align:left;" text="bind:indt"/>
                <Cell col="12" text="bind:ipsildt"/>
                <Cell col="13" text="bind:toisildt" mask="expr:(utlf_isNull(toisildt) || toisildt =='-')  ? '' : '####-##-## ##:##'"/>
                <Cell col="14" style="align:left;" text="bind:dschdt"/>
                <Cell col="15" text="bind:dethdt" mask="expr:utlf_isNull(dethdt) ? '' : '####-##-## ##:##'"/>
                <Cell col="16" text="bind:icudethyn"/>
                <Cell col="17" style="align:left top;padding:4 2 2 2;" text="bind:orddeptnm" wordwrap="word"/>
                <Cell col="18" style="align:left top;padding:2 2 2 2;" text="bind:wardnm" wordwrap="word"/>
                <Cell col="19" text="bind:sapsscore"/>
                <Cell col="20" text="bind:pom"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption00" text="입원일자" class="search_name" position="absolute 16 33 81 50"/>
        <Calendar id="ipt_infromdd" taborder="9" class="input_essential" position="absolute 94 31 187 50" mask="yyyy-mm-dd"/>
        <Calendar id="ipt_intodd" taborder="10" class="input_essential" position="absolute 195 31 288 50" mask="yyyy-mm-dd"/>
        <Button id="button00" taborder="11" text="표준화사망률" class="btn1" position="absolute 979 32 1083 54" onclick="button00_onclick"/>
        <Edit id="ed_jo" taborder="12" position="absolute 1039 4 1122 24" displaynulltext="숫자로 입력" inputtype="number"/>
        <Static id="Static00" text="조사망률" position="absolute 975 8 1029 20" style="font:dotum,9,bold;"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_ward_icudept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="deptnm" type="STRING"/>
          <Column id="deptcd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_orddept_dept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="depthngnm" type="STRING"/>
          <Column id="deptcd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="stnddd" type="STRING" size="256" sumtext="조회시작일자"/>
          <Column id="enddd" type="STRING" size="256" sumtext="조회종료일자"/>
          <Column id="ward" type="STRING" size="256"/>
          <Column id="orddept" type="STRING" size="256"/>
          <Column id="range" type="STRING" size="256"/>
          <Column id="infromdd" type="STRING" size="256"/>
          <Column id="intodd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp_initlist_icudept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="deptcd" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="부서명"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_list_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256" sumtext=""/>
          <Column id="pid" type="STRING" size="256" sumtext=""/>
          <Column id="hngnm" type="STRING" size="256" sumtext=""/>
          <Column id="sex" type="STRING" size="256" sumtext=""/>
          <Column id="age" type="STRING" size="256" sumtext=""/>
          <Column id="orddept" type="STRING" size="256" sumtext=""/>
          <Column id="ward" type="STRING" size="256" sumtext=""/>
          <Column id="orddeptnm" type="STRING" size="256" sumtext=""/>
          <Column id="wardnm" type="STRING" size="256" sumtext=""/>
          <Column id="fromdd" type="STRING" size="256" sumtext=""/>
          <Column id="todd" type="STRING" size="256" sumtext=""/>
          <Column id="toisildt" type="STRING" size="256" sumtext=""/>
          <Column id="ipsildt" type="STRING" size="256" sumtext="입실시각"/>
          <Column id="orddd" type="STRING" size="256" sumtext=""/>
          <Column id="cretno" type="STRING" size="256" sumtext=""/>
          <Column id="sapsscore" type="STRING" size="256" sumtext=""/>
          <Column id="pom" type="STRING" size="256" sumtext=""/>
          <Column id="condqry" type="STRING" size="256" sumtext=""/>
          <Column id="dethyn" type="STRING" size="256" sumtext=""/>
          <Column id="dethdt" type="STRING" size="256" sumtext=""/>
          <Column id="indt" type="STRING" size="256"/>
          <Column id="dschdt" type="STRING" size="256"/>
          <Column id="rn" type="STRING" size="256"/>
          <Column id="insukind" type="STRING" size="256"/>
          <Column id="chk" type="STRING" size="256"/>
          <Column id="icudethyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="ipt_reqstnddd" propid="value" datasetid="ds_cond" columnid="stnddd"/>
      <BindItem id="item1" compid="ipt_reqenddd" propid="value" datasetid="ds_cond" columnid="enddd"/>
      <BindItem id="item2" compid="cmb_term" propid="value" datasetid="ds_cond" columnid="range"/>
      <BindItem id="item3" compid="cmb_icu" propid="value" datasetid="ds_cond" columnid="ward"/>
      <BindItem id="item4" compid="cmb_orddeptcd" propid="value" datasetid="ds_cond" columnid="orddept"/>
      <BindItem id="item5" compid="ipt_infromdd" propid="value" datasetid="ds_cond" columnid="infromdd"/>
      <BindItem id="item6" compid="ipt_intodd" propid="value" datasetid="ds_cond" columnid="intodd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************
 * System Name		:	경대 의료정보시스템
 * Job Name 		:	emr_anstrecxp -> SMMMR04000
 * 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";
include "emr_anstrecxp::MMR04000.xjs";	//yjh : 커밋
include "emr_prcpmngtxp::MMOCommon.xjs";


//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------
var arErrorCode = new HashArray();


//=======================================================================================
// Function
//---------------------------------------------------------------------------------------



//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Components ID	: SMMMR04000
 * Event			: oninit
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 화면 처음 초기화시
 ****************************************************************************************/
function SMMMR04000_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	//폼 초기화

	
}

/****************************************************************************************
 * Components		: Form
 * Components ID	: SMMMR04000
 * Event			: onload
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 화면 로딩 완료시
 ****************************************************************************************/
function SMMMR04000_onload(obj:Form, e:LoadEventInfo)
{
	fIni();
}

/****************************************************************************************
 * Components		: Grid
 * Components ID	: grd_list
 * Event			: oncelldblclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 그리드 셀 더블클릭시
 ****************************************************************************************/
function grd_list_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	fSAPS();
}

/****************************************************************************************
 * Components		: Calendar
 * Components ID	: ipt_reqstnddd
 * Event			: onchanged
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 달력 값 변경시
 ****************************************************************************************/
function ipt_reqstnddd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_cond.setColumn(0, "stnddd", ds_cond.getColumn(0, "stnddd"));
}

/****************************************************************************************
 * Components		: Calendar
 * Components ID	: ipt_reqenddd
 * Event			: onchanged
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 달력 값 변경시
 ****************************************************************************************/
function ipt_reqenddd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_cond.setColumn(0, "enddd", ds_cond.getColumn(0, "enddd"));
}

/****************************************************************************************
 * Components		: Combo
 * Components ID	: cmb_term
 * Event			: onitemchanged
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 콤보 값 변경시
 ****************************************************************************************/
function cmb_term_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	var date2 = ipt_reqenddd.value;
	var term = cmb_term.value;
	ipt_reqstnddd.value = (date2+"").toDate().getAddDate(-term, "D").getDateFormat("YYYYMMDD");
}

/****************************************************************************************
 * Components		: Combo
 * Components ID	: cmb_icu
 * Event			: onitemchanged
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 콤보 값 변경시
 ****************************************************************************************/
function cmb_icu_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	ds_cond.setColumn(0, "ward", ds_cond.getColumn(0, "ward"));
}

/****************************************************************************************
 * Components		: Combo
 * Components ID	: cmb_orddeptcd
 * Event			: onitemchanged
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 콤보 값 변경시
 ****************************************************************************************/
function cmb_orddeptcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	ds_cond.setColumn(0, "orddept", ds_cond.getColumn(0, "orddept"));
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: btn_excel
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 엑셀버튼 클릭시
 ****************************************************************************************/
function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	if( grd_list.rowcount > 0 ){
		grdf_exportExcel(grd_list, "SAPS3", "SAPS3", false, "", "user", false);
	} else {
		sysf_messageBox("조회된 데이터가 ", "I004");
		return;
	}
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: button1
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 조회버튼 클릭시
 ****************************************************************************************/
function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	fSearch();
	
	
}

function button00_onclick(obj:Button,  e:ClickEventInfo)
{
// 	var C0 = 18;
// 	var C1 = 4;
// 	var C2 = 4.44;
// 	var C3 = 22.22;
// 	var C4 = 24.70;
// 	var C5 = 16.9;
// 	var C6 = 15.20;
	
	var rowcount = ds_main_list_item.rowcount;
	var chk = "";
	var sum = 0;
	var pom = 0;
	var tmp = 0;
	var tmp2 = 0;
	
	//선택환자수
	C0 = ds_main_list_item.getCaseCount("chk == 1");
	
	//조사망률
	C5 = ed_jo.value;
	
	if (C0 == 0 ) {
	  sysf_messageBox("선택된 행이 없습니다","I");
	  return;
	 }
	 
	 if (utlf_isNull(C5)) {
	  sysf_messageBox("조사망률이 입력되지 않았습니다","I");
	  return;
	 }
	
	//실제 사망자수
	C1 = ds_main_list_item.getCaseCount("chk == 1 && icudethyn == 'Y'");
	 
	for ( var i = 0 ; i < rowcount ; i++ )
	{
		chk = ds_main_list_item.getColumn(i,"chk");
		
		if (chk == 1) {
		    pom = ds_main_list_item.getColumn(i,"pom")
			if (!utlf_isNull(pom)){
				tmp =  parseFloat(pom)/100;
				//tmp2 = Math.round(tmp * 100000000)/100000000;
				sum = sum + tmp
			}
		}
	}
	
	//기대 사망자수
	C2 = Math.round(sum * 100000000)/100000000;
	
	//실제 사망률
	C3 = Math.round(C1/C0 * 100 * 100)/100;
	
	//기대 사망률
	C4 = Math.round(C2/C0 * 100 * 100)/100;
	
	//표준화 사망률
	C6  = Math.round(C3/C4 * C5 * 100)/100;
	    
    frmf_setParameter("SPMMR04003_C0", C0);
    frmf_setParameter("SPMMR04003_C1", C1);
    frmf_setParameter("SPMMR04003_C2", C2);
    frmf_setParameter("SPMMR04003_C3", C3);
    frmf_setParameter("SPMMR04003_C4", C4);
    frmf_setParameter("SPMMR04003_C5", C5);
    frmf_setParameter("SPMMR04003_C6", C6);
    
	frmf_modal("SPMMR04003", "SPMMR04003", null, null, null, null, null, null, null, null, null, null, "M");
	
}
]]></Script>
  </Form>
</FDL>