YNU_JEUS/app_home/himed/xpapps/emr/unprepmngtxp/xp/SMMRI01301_퇴원기간별 미비통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMMRI01301" position="absolute 0 0 1256 805" titletext="미비항목별 통계" oninit="SMMRI01301_oninit" onload="SMMRI01301_onload">
    <Layouts>
      <Layout>
        <Static text="퇴원기간별 의사별 미비 통계[퇴원과, 담당(교수)의 기준]" position="absolute 0 0 440 25" id="cap_title" class="tit_1"/>
        <Div id="Div00" taborder="1" position="absolute 0 25 1256 75" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption3" text="퇴원일자" class="search_name" position="absolute 13 16 99 36" anchor="default"/>
              <Calendar id="ipt_dschfromdd" taborder="1" position="absolute 95 16 185 36" anchor="default" dateformat="yyyy-MM-dd" value="null"/>
              <Static id="caption1" text="~" position="absolute 189 16 204 36" anchor="default"/>
              <Calendar id="ipt_dschtodd" taborder="2" position="absolute 205 16 295 36" anchor="default" dateformat="yyyy-MM-dd" value="null"/>
              <Combo id="combo4" taborder="3" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 302 16 385 36" anchor="default" onitemchanged="Div00_combo4_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">최근30일</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">당해년도</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">3</Col>
                      <Col id="datacolumn">전년도</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">4</Col>
                      <Col id="datacolumn">전전년도</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption2" text="퇴원과" class="search_name" position="absolute 423 16 486 36" anchor="default"/>
              <Static id="caption4" text="담당교수" class="search_name" position="absolute 643 16 708 36" anchor="default"/>
              <Combo id="cmb_orddeptcd" taborder="6" innerdataset="@ds_orddept" codecolumn="deptcd" datacolumn="depthngnm" position="absolute 490 16 597 36" anchor="default" onitemchanged="Div00_cmb_orddeptcd_onitemchanged"/>
              <Combo id="cmb_medispclid" taborder="7" innerdataset="@ds_userlist" codecolumn="userid" datacolumn="usernm" position="absolute 720 16 820 36" anchor="default"/>
              <Button id="btn_ex" taborder="5" text="엑셀" class="btn7" position="absolute 1111 16 1161 36" anchor="top right" onclick="Div00_btn_ex_onclick"/>
              <Button id="btn_req" taborder="4" text="조회" class="btn1" position="absolute 1181 16 1237 36" anchor="top right" onclick="Div00_btn_req_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Tab position="absolute 0 87 1256 805" id="switch1" anchor="all">
          <Tabpages>
            <Tabpage text="과별리스트" position="absolute 0 0 1190 680" id="case1">
              <Layouts>
                <Layout>
                  <Grid position="absolute 0 0 1256 691" id="datagrid1" scrollbars="fixedvert" binddataset="ds_itemclsstatic" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="150"/>
                          <Column size="100"/>
                          <Column size="83"/>
                          <Column size="78"/>
                          <Column size="86"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell text="퇴원과"/>
                          <Cell col="1" text="담당교수"/>
                          <Cell col="2" text="퇴원환자수"/>
                          <Cell col="3" text="미비환자수"/>
                          <Cell col="4" text="비율(%)"/>
                        </Band>
                        <Band id="body">
                          <Cell style="align:left middle;" text="bind:orddept"/>
                          <Cell col="1" style="align:left middle;" text="bind:medispcl"/>
                          <Cell col="2" text="bind:dschcnt"/>
                          <Cell col="3" text="bind:mibicnt"/>
                          <Cell col="4" text="bind:percent"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage text="통합" position="absolute 0 0 1190 680" id="case2">
              <Layouts>
                <Layout>
                  <Grid position="absolute 0 1 1256 691" id="datagrid2" scrollbars="fixedvert" binddataset="ds_itemclsstatic2" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="94"/>
                          <Column size="64"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                          <Column size="70"/>
                        </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="최근30일" taborder="undefined"/>
                          <Cell col="4" colspan="2" text="당해년도~최근31일" taborder="undefined"/>
                          <Cell col="6" colspan="2" text="작년" taborder="undefined"/>
                          <Cell col="8" colspan="2" text="재작년" taborder="undefined"/>
                          <Cell col="10" colspan="2" text="그외" taborder="undefined"/>
                          <Cell col="12" colspan="3" text="합계" taborder="undefined"/>
                          <Cell row="1" col="2" text="퇴원환자"/>
                          <Cell row="1" col="3" text="미비환자"/>
                          <Cell row="1" col="4" text="퇴원환자"/>
                          <Cell row="1" col="5" text="미비환자"/>
                          <Cell row="1" col="6" text="퇴원환자"/>
                          <Cell row="1" col="7" text="미비환자"/>
                          <Cell row="1" col="8" text="퇴원환자"/>
                          <Cell row="1" col="9" text="미비환자"/>
                          <Cell row="1" col="10" 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="비율(%)"/>
                        </Band>
                        <Band id="body">
                          <Cell text="bind:orddept"/>
                          <Cell col="1" text="bind:medispcl"/>
                          <Cell col="2" text="bind:col1_dsch"/>
                          <Cell col="3" text="bind:col1_mibi"/>
                          <Cell col="4" text="bind:col2_dsch"/>
                          <Cell col="5" text="bind:col2_mibi"/>
                          <Cell col="6" text="bind:col3_dsch"/>
                          <Cell col="7" text="bind:col3_mibi"/>
                          <Cell col="8" text="bind:col4_dsch"/>
                          <Cell col="9" text="bind:col4_mibi"/>
                          <Cell col="10" text="bind:col5_dsch"/>
                          <Cell col="11" text="bind:col5_mibi"/>
                          <Cell col="12" text="bind:dschcnt"/>
                          <Cell col="13" text="bind:mibicnt"/>
                          <Cell col="14" text="bind:percent"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_orddept" 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_userlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="usernm" type="STRING"/>
          <Column id="userid" 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="srchflag" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="deptflag" type="STRING" size="256"/>
          <Column id="orddeptcd" type="STRING" size="256"/>
          <Column id="medispclid" type="STRING" size="256"/>
          <Column id="datediff" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="srchflag">unprep</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_mibiuser" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_itemclsstatic" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="orddept" type="STRING" size="256" sumtext="퇴원과"/>
          <Column id="medispcl" type="STRING" size="256" sumtext="담당교수"/>
          <Column id="dschcnt" type="STRING" size="256" sumtext="퇴원환자수"/>
          <Column id="mibicnt" type="STRING" size="256" sumtext="미비환자수"/>
          <Column id="percent" type="STRING" size="256" sumtext="비율"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_itemclsstatic2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="orddept" type="STRING" size="256" sumtext="퇴원과"/>
          <Column id="medispcl" type="STRING" size="256" sumtext="담당교수"/>
          <Column id="col1_mibi" type="STRING" size="256" sumtext="미비환자수"/>
          <Column id="col2_mibi" type="STRING" size="256" sumtext="미비환자수"/>
          <Column id="col3_mibi" type="STRING" size="256" sumtext="미비환자수"/>
          <Column id="col4_mibi" type="STRING" size="256" sumtext="미비환자수"/>
          <Column id="col5_mibi" type="STRING" size="256" sumtext="미비환자수"/>
          <Column id="col1_dsch" type="STRING" size="256" sumtext="퇴원환자수"/>
          <Column id="col2_dsch" type="STRING" size="256" sumtext="퇴원환자수"/>
          <Column id="col3_dsch" type="STRING" size="256" sumtext="퇴원환자수"/>
          <Column id="col4_dsch" type="STRING" size="256" sumtext="퇴원환자수"/>
          <Column id="col5_dsch" type="STRING" size="256" sumtext="퇴원환자수"/>
          <Column id="mibicnt" type="STRING" size="256" sumtext="미비환자수"/>
          <Column id="dschcnt" type="STRING" size="256" sumtext="퇴원환자수"/>
          <Column id="percent" type="STRING" size="256" sumtext="비율"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="Div00.ipt_dschfromdd" propid="value" datasetid="ds_cond" columnid="fromdd"/>
      <BindItem id="item1" compid="Div00.ipt_dschtodd" propid="value" datasetid="ds_cond" columnid="todd"/>
      <BindItem id="item2" compid="Div00.combo4" propid="value" datasetid="ds_cond" columnid="datediff"/>
      <BindItem id="item3" compid="Div00.cmb_orddeptcd" propid="value" datasetid="ds_cond" columnid="orddeptcd"/>
      <BindItem id="item4" compid="Div00.cmb_medispclid" propid="value" datasetid="ds_cond" columnid="medispclid"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2014-10-07
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2014-10-07      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "emr_prcpmngtxp::MMO001.xjs";

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

function SMMRI01301_onload(obj:Form, e:LoadEventInfo)
{
	fInit();
}

function Div00_combo4_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	fAddDateReq(obj.value);
}

function Div00_cmb_orddeptcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{	
	lf_mmbfGetUserComboList(ds_userlist, obj.value, "0330");
	
	frmf_addComboItem("Div00.cmb_medispclid");	//의사콤보 전체항목 추가		
	Div00.cmb_medispclid.value = "-"
}

function Div00_btn_ex_onclick(obj:Button,  e:ClickEventInfo)
{
	fExcel();
}

function Div00_btn_req_onclick(obj:Button,  e:ClickEventInfo)
{
	fSearch();
}

function fInit() { 
	var MENUPARAM = frmf_getMenuParam();
	
	lf_gethardcdArrayList(new Array(
									"mibiuser|5801"
								   ),
						  new Array(
								    "ds_mibiuser"
								   )
						  );
					
	var userid = sysf_getUserInfo("userid");
	var mibiuserCnt = ds_mibiuser.findRow("hardcd", userid);  //미비 관리용 통계 대상자

	lf_mmbfGetDeptCodeComboList(ds_orddept, "A");
	frmf_addComboItem("Div00.cmb_orddeptcd");
	frmf_addComboItem("Div00.cmb_medispclid");

	if (MENUPARAM == "A" || mibiuserCnt > -1) {
		Div00.cmb_orddeptcd.enable = true;
	} else {
		switch1.removeTabpage(1);
		Div00.cmb_orddeptcd.enable = false;
	}

	if (MENUPARAM == "A" ) {
		ds_cond.setColumn(0, "orddeptcd", "-");
		ds_cond.setColumn(0, "medispclid", "-");
	} else {
		ds_cond.setColumn(0, "orddeptcd", sysf_getUserInfo("dutplcecd"));
		ds_cond.setColumn(0, "medispclid", sysf_getUserInfo("userid"));
		Div00.cmb_orddeptcd.onitemchanged.fireEvent(Div00.cmb_orddeptcd, new ItemChangeEventInfo());
	}

	ds_cond.setColumn(0, "datediff", 1);  
	fAddDateReq("1");

	if (MENUPARAM == "A"){
		return;
	} else {
		fSearch();
	}  
}

function fAddDateReq(termflag)
{
	var todd = utlf_getCurrentDate();
	var today = todd.toDate();
	var fromday = new Date();
		
	if ( termflag == "1") {
		fromday = today.getAddDate(-30);
		fromdd = fromday.getDateFormat();
	} else if (termflag == "2") {
		fromdd = todd.substr(0,4)+"0101" ;
	} else if (termflag == "3") {
		fromday = today.getAddDate(-1,"Y");
		fromdd = fromday.getDateFormat();
		todd = fromdd.substr(0,4)+"1231";
		fromdd = todd.substr(0,4)+"0101";
	} else if (termflag == "4") {
		fromday = today.getAddDate(-2,"Y");
		fromdd = fromday.getDateFormat();
		todd = fromdd.substr(0,4)+"1231";
		fromdd = todd.substr(0,4)+"0101";
	}
	
	ds_cond.setColumn(0, "fromdd", fromdd);
	ds_cond.setColumn(0, "todd", todd);
}

function fSearch() {
	ds_reqdata.copyData(ds_cond);
	
	var oParam = {};
		oParam.service  = "unprepmngtapp.ChrtUnprepMngt";
		oParam.inds     = "req=ds_reqdata";
		oParam.async    = true;
		
	if (switch1.tabindex == 0) {		
		oParam.id       = "TRMRI01303";			
		oParam.method   = "reqGetStaffMibiStat";			
		oParam.outds    = "ds_itemclsstatic=itemclsstatic";
	} else{
		oParam.id       = "TRMRI01304";			
		oParam.method   = "reqGetStaffMibiStatAll";			
		oParam.outds    = "ds_itemclsstatic2=itemclsstatic";
	}
	
	tranf_submit(oParam);
}

function fExcel() {
	if (switch1.tabindex == 0) {
		grdf_exportExcel(switch1.case1.datagrid1, "excel", "Sheet1", true);
	} else{
		grdf_exportExcel(switch1.case2.datagrid2, "excel", "Sheet1", true);
	}
}]]></Script>
  </Form>
</FDL>