YNU_JEUS/app_home/himed/xpapps/lis/statsmngtxp/xp/SMLMS00100_미생물통계조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMLMS00100" position="absolute 0 0 1256 805" titletext="미생물통계조회" oninit="SMLMS00100_oninit" onload="SMLMS00100_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="미생물통계조회" class="tit_1" position="absolute 0 0 122 25" anchor="left top"/>
        <Button id="btn_cle" taborder="1" text="초기화" class="btn4" position="absolute 1127 20 1195 42" onclick="btn_cle_onclick" anchor="top right"/>
        <Static id="caption16" text="환자목록" class="tit_2" position="absolute 3 241 75 257" anchor="left top"/>
        <Grid id="grd_patList" taborder="2" binddataset="ds_grd_patList" useinputpanel="false" position="absolute 0 261 460 769" anchor="left top bottom">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="29"/>
                <Column size="137"/>
                <Column size="74"/>
                <Column size="65"/>
                <Column size="73"/>
                <Column size="82"/>
              </Columns>
              <Rows>
                <Row size="24" 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="병동"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow + 1"/>
                <Cell col="1" displaytype="normal" style="align:left middle;" text="bind:workno" mask="########-AA-AA-###"/>
                <Cell col="2" style="align:left middle;" text="bind:pid"/>
                <Cell col="3" style="align:left middle;" text="bind:patnm"/>
                <Cell col="4" text="bind:orddeptnm"/>
                <Cell col="5" style="align:left middle;" text="bind:wardroom"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption11" text="균별 통계" class="tit_2" position="absolute 467 52 546 68" anchor="left top"/>
        <Static id="caption12" text="항균제별 통계" class="tit_2" position="absolute 766 52 872 69" anchor="top right"/>
        <Button id="button2" taborder="3" text="엑셀" class="btn7" position="absolute 710 46 760 65" onclick="button2_onclick" anchor="top right"/>
        <Button id="button1" taborder="4" text="엑셀" class="btn7" position="absolute 1144 46 1194 65" onclick="button1_onclick" anchor="top right"/>
        <Div id="group2" taborder="5" position="absolute 1 52 461 232" anchor="left top" class="div_SA2">
          <Layouts>
            <Layout>
              <Button id="button6" taborder="1" text="조회" class="btn1" position="absolute 374 150 430 172" onclick="group2_button6_onclick" anchor="left top"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 356 150 362 172" anchor="left top"/>
              <Static id="caption10" text="결 과 값  :" class="search_name" position="absolute 230 125 318 142" anchor="left top"/>
              <Static id="caption1" text="검 체 명  :" class="search_name" position="absolute 15 78 103 95" anchor="left top"/>
              <Static id="caption2" text="~" class="search_no_b" position="absolute 314 9 329 29" anchor="left top"/>
              <Combo id="combo1" taborder="2" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_search" position="absolute 105 8 205 27" anchor="left top">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">보고일자</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">접수일자</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Combo id="combo2" taborder="3" innerdataset="ds_init_combo2" codecolumn="cd" datacolumn="nm" class="combo_search" position="absolute 105 77 430 96" anchor="left top"/>
              <Static id="caption3" text="병     동 :" class="search_name" position="absolute 230 32 319 49" anchor="left top"/>
              <Static id="caption4" text="외래/입원:" class="search_name" position="absolute 15 32 104 49" anchor="left top"/>
              <Combo id="combo3" taborder="4" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_search" position="absolute 105 31 205 50" anchor="left top">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">[-]전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">외래</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">3</Col>
                      <Col id="datacolumn">병동</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption5" text="진 료 과  :" class="search_name" position="absolute 15 55 109 72" anchor="left top"/>
              <Combo id="combo4" taborder="5" innerdataset="ds_init_combo4" codecolumn="cd" datacolumn="nm" class="combo_search" position="absolute 330 31 430 50" anchor="left top"/>
              <Combo id="combo5" taborder="6" innerdataset="ds_init_combo5" codecolumn="cd" datacolumn="nm" class="combo_search" position="absolute 105 54 205 73" onitemchanged="group2_combo5_onitemchanged" anchor="left top"/>
              <Calendar id="input1" taborder="7" class="input_search" position="absolute 210 8 310 27" anchor="left top"/>
              <Combo id="combo6" taborder="8" innerdataset="ds_init_combo6" codecolumn="cd" datacolumn="nm" class="combo_search" position="absolute 330 54 430 73" anchor="left top"/>
              <Static id="caption7" text="의뢰의사 :" class="search_name" position="absolute 230 54 319 71" anchor="left top"/>
              <Calendar id="input2" taborder="9" class="input_search" position="absolute 330 8 430 27" onkeyup="group2_input2_onkeyup" anchor="left top"/>
              <Combo id="combo7" taborder="10" innerdataset="ds_init_combo7" codecolumn="cd" datacolumn="nm" class="combo_search" position="absolute 105 100 430 119" anchor="left top"/>
              <Static id="caption8" text="균         :" class="search_name" position="absolute 15 101 102 118" anchor="left top"/>
              <Combo id="combo8" taborder="11" innerdataset="ds_init_combo8" codecolumn="cd" datacolumn="nm" class="combo_search" position="absolute 105 123 205 142" anchor="left top"/>
              <Static id="caption9" text="항 균 제  :" class="search_name" position="absolute 15 124 103 141" anchor="left top"/>
              <Static id="caption18" text="검색구분 :" class="search_name" position="absolute 15 9 104 26" anchor="left top"/>
              <Combo id="combo9" taborder="12" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_search" position="absolute 330 124 430 143" anchor="left top">
                <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">S</Col>
                      <Col id="datacolumn">S</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">R</Col>
                      <Col id="datacolumn">R</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">I</Col>
                      <Col id="datacolumn">I</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
            </Layout>
          </Layouts>
        </Div>
        <ActiveX id="object1" visible="false" position="absolute 1070 677 1165 752" progid="A4BF7E18-5F67-4868-A726-EED421632374" useautobitmapcache="1" anchor="default" taborder="6"/>
        <Button id="button3" taborder="7" text="조회 ##" class="btn2" visible="false" position="absolute 620 47 684 66" anchor="left top right"/>
        <Button id="button4" taborder="8" text="조회 rexport" class="btn2" visible="false" position="absolute 315 237 401 256" anchor="left top"/>
        <CheckBox id="chk_pat" taborder="9" position="absolute 83 241 127 256" text="선택" anchor="left top"/>
        <CheckBox id="chk_bac" taborder="10" position="absolute 550 50 600 65" text="선택" anchor="left top"/>
        <CheckBox id="chk_anti" taborder="11" position="absolute 879 52 923 67" text="선택" anchor="top right"/>
        <Grid id="grd_bac" taborder="12" binddataset="ds_grd_bac" useinputpanel="false" position="absolute 465 72 760 769" anchor="all" autosizingtype="none" autosizemergetype="nomerge" autofittype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="33"/>
                <Column size="135"/>
                <Column size="81"/>
                <Column size="78"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="균명"/>
                <Cell col="2" text="%"/>
                <Cell col="3" text="건수"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow + 1"/>
                <Cell col="1" text="bind:bacnm"/>
                <Cell col="2" text="bind:brate"/>
                <Cell col="3" text="bind:bcnt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="button5" taborder="13" text="엑셀" class="btn7" position="absolute 408 237 458 256" onclick="button5_onclick" anchor="left top"/>
        <Grid id="grd_antibio" taborder="14" binddataset="ds_grd_antibio" useinputpanel="false" position="absolute 765 72 1194 769" anchor="top right bottom">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="28"/>
                <Column size="100"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="73"/>
                <Column size="74"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="항균제명"/>
                <Cell col="2" text="S(%)"/>
                <Cell col="3" text="R(%)"/>
                <Cell col="4" text="I(%)"/>
                <Cell col="5" text="총건수"/>
                <Cell col="6" text="예외건수"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow + 1"/>
                <Cell col="1" text="bind:antibionm"/>
                <Cell col="2" text="bind:scnt"/>
                <Cell col="3" text="bind:rcnt"/>
                <Cell col="4" text="bind:icnt"/>
                <Cell col="5" text="bind:tcnt"/>
                <Cell col="6" text="bind:ecnt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_grd_patList" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="workno" type="STRING"/>
          <Column id="pid" type="STRING"/>
          <Column id="patnm" type="STRING"/>
          <Column id="orddeptnm" type="STRING"/>
          <Column id="wardroom" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_combo2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="nm" type="STRING"/>
          <Column id="cd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_combo4" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="nm" type="STRING"/>
          <Column id="cd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_combo5" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="nm" type="STRING"/>
          <Column id="cd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_combo6" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="nm" type="STRING"/>
          <Column id="cd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_combo7" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="nm" type="STRING"/>
          <Column id="cd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_combo8" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="nm" type="STRING"/>
          <Column id="cd" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grd_bac" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="bacnm" type="STRING"/>
          <Column id="brate" type="STRING"/>
          <Column id="bcnt" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grd_antibio" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="antibionm" type="STRING"/>
          <Column id="scnt" type="STRING"/>
          <Column id="rcnt" type="STRING"/>
          <Column id="icnt" type="STRING"/>
          <Column id="tcnt" type="STRING"/>
          <Column id="ecnt" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="report" type="STRING" size="256"/>
          <Column id="codeflag" type="STRING" size="256"/>
          <Column id="orddeptcd" type="STRING" size="256"/>
          <Column id="refflag" type="STRING" size="256"/>
          <Column id="reffromdd" type="STRING" size="256"/>
          <Column id="reftodd" type="STRING" size="256"/>
          <Column id="ioflag" type="STRING" size="256"/>
          <Column id="ward" type="STRING" size="256"/>
          <Column id="orddept" type="STRING" size="256"/>
          <Column id="orddr" type="STRING" size="256"/>
          <Column id="spcnm" type="STRING" size="256"/>
          <Column id="bacteria" type="STRING" size="256"/>
          <Column id="hg" type="STRING" size="256"/>
          <Column id="rslt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-11-13
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-11-13      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/

include "com_commonxp::comm_main.xjs";
include "lis_commonxp::LLZ001.xjs";

//콜백
function cf_TRLZZ00101(strSvcID, nErrorCode, strErrorMag)
{
	if(nErrorCode != 0) sysf_messageBox("ID: " + strSvcID + "  Error: " + strErrorMag, "E009", "");
}

function SMLMS00100_oninit(obj:Form, e:InitEventInfo)
{
	//폼 초기화 함수
	frmf_initForm(obj);
}

function SMLMS00100_onload(obj:Form, e:LoadEventInfo)
{	
	grdf_initGrid(grd_patList);
	grdf_initGrid(grd_bac);
	grdf_initGrid(grd_antibio);
	
	fSetClear();
	 
	var sInDsName = dsf_createDsRow("ds_temp_search", [{col: "codeflag", val: "0114|0002|0105|0205|0206|"}]);
								
	// 서브밋호출
	var oParam = {};
    oParam.id          = "TRLZZ00101";
    oParam.service     = "diagtestapplib.DiagTestBaseInfoMngt";
    oParam.method      = "reqGetInitCodeInfo";
    oParam.inds        = "cond=" + sInDsName;
    oParam.outds       = "ds_init_combo2=0105 ds_init_combo4=0114 ds_init_combo5=0002 ds_init_combo7=0205 ds_init_combo8=0206";
    oParam.async       = false;
    oParam.callback    = "cf_TRLZZ00101";
	tranf_submit(oParam);
	
	group2.combo1.value = 2;
	group2.combo2.value = 00;
	group2.combo3.value = 1;
	group2.combo4.value = 000000;
	group2.combo5.value = 00;
	group2.combo7.value = 00;
	group2.combo8.value = 00;
	group2.combo9.value = "-";
	fGetOrddrNm();
	group2.combo6.value = 00; 
}

// 초기화
function fSetClear()
{	
	group2.input1.value = utlf_getCurrentDate();
	group2.input2.value = utlf_getCurrentDate();
	chk_pat.value = 1;
}

function fGetOrddrNm()
{
	
	//var orddept = model.getValue("/root/hidden/ref/orddept");
	var orddept = group2.combo5.value;
	
	//model.setValue("/root/send/orddeptcd", orddept);
	ds_send.setColumn(0, "orddeptcd", orddept);
	
	
	//submit("TRLMS00103");
	var oParam = {};
    oParam.id          = "TRLMS00103";
    oParam.service     = "statsmngtapp.MicroStatsRefMngt";
    oParam.method      = "reqGetOrdDrNm";
    oParam.inds        = "cond=ds_send";
    oParam.outds       = "ds_init_combo6=getorddrnm";
    oParam.async       = false;
    //oParam.callback    = "cf_TRLMS00103";

	tranf_submit(oParam);
	
}

function fGetRef()
{				
	// 그리드 체크박스 선택
	//model.setValue("/root/send/refflag",      model.getValue("/root/hidden/ref/refflag"));
	ds_send.setColumn(0, "refflag", group2.combo1.value);
	//model.setValue("/root/send/reffromdd", model.getValue("/root/hidden/ref/reffromdd"));
	ds_send.setColumn(0, "reffromdd", group2.input1.value);
	//model.setValue("/root/send/reftodd",     model.getValue("/root/hidden/ref/reftodd"));
	ds_send.setColumn(0, "reftodd", group2.input2.value);
	//model.setValue("/root/send/ioflag",      model.getValue("/root/hidden/ref/IOflag"));
	ds_send.setColumn(0, "ioflag", group2.combo3.value);
	//model.setValue("/root/send/ward",       model.getValue("/root/hidden/ref/ward"));
	ds_send.setColumn(0, "ward", group2.combo4.value);
	//model.setValue("/root/send/orddept",   model.getValue("/root/hidden/ref/orddept"));
	ds_send.setColumn(0, "orddept", group2.combo5.value);
	//model.setValue("/root/send/orddr",      model.getValue("/root/hidden/ref/orddr"));
	ds_send.setColumn(0, "orddr", group2.combo6.value);
	//model.setValue("/root/send/spcnm",   model.getValue("/root/hidden/ref/spcnm"));
	ds_send.setColumn(0, "spcnm", group2.combo2.value);
	//model.setValue("/root/send/bacteria", model.getValue("/root/hidden/ref/bacteria"));
	ds_send.setColumn(0, "bacteria", group2.combo7.value);
	//model.setValue("/root/send/hg",         model.getValue("/root/hidden/ref/hg"));
	ds_send.setColumn(0, "hg", group2.combo8.value);
	//model.setValue("/root/send/rslt",        model.getValue("/root/hidden/ref/rslt"));
	ds_send.setColumn(0, "rslt", group2.combo9.value);
	
	//if(model.getValue("/root/hidden/select/pat")=="1")
	if(chk_pat.value == 1)
	{
		// 환자목록 조회
		//submit("TRLMS00100");
		var oParam = {};
			oParam.id          = "TRLMS00100";
			oParam.service     = "statsmngtapp.MicroStatsRefMngt";
			oParam.method      = "reqGetMicroPatList";
			oParam.inds        = "cond=ds_send";
			oParam.outds       = "ds_grd_patList=getmicropatlist";
			oParam.async       = false;
			//oParam.callback    = "cf_TRLMS00100";

			tranf_submit(oParam);
	}
	
	//if(model.getValue("/root/hidden/select/bac")=="2")
	if(chk_bac.value == 1)
	{
		//submit("TRLMS00102");
		var oParam = {};
			oParam.id          = "TRLMS00102";
			oParam.service     = "statsmngtapp.MicroStatsRefMngt";
			oParam.method      = "reqGetMicroBacList";
			oParam.inds        = "cond=ds_send";
			oParam.outds       = "ds_grd_bac=getmicrobaclist";
			oParam.async       = false;
			//oParam.callback    = "cf_TRLMS00102";

			tranf_submit(oParam);
	}
	
	if(chk_anti.value == 1)
	{
		//submit("TRLMS00104");
		var oParam = {};
			oParam.id          = "TRLMS00104";
			oParam.service     = "statsmngtapp.MicroStatsRefMngt";
			oParam.method      = "reqGetAntiBio";
			oParam.inds        = "cond=ds_send";
			oParam.outds       = "ds_grd_antibio=getAntiBio";
			oParam.async       = false;
			//oParam.callback    = "cf_TRLMS00104";

			tranf_submit(oParam);
	}
}

//진료과 변경
function group2_combo5_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	fGetOrddrNm();
}

//초기화
function btn_cle_onclick(obj:Button,  e:ClickEventInfo)
{
	fSetClear();
}

//조회
function group2_button6_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetRef();
}

function group2_input2_onkeyup(obj:Calendar, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		fGetRef();
	}
}

function button5_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_patList, lf_lisGetTitle(this), "see");
}

function button2_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_bac, lf_lisGetTitle(this), "see");
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_antibio, lf_lisGetTitle(this), "see");
}
]]></Script>
  </Form>
</FDL>