YNU_JEUS/app_home/himed/xpapps/emr/wardcarexp/xp/SPMNW18010_기자재현황통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPMNW18010" position="absolute 0 0 760 750" titletext="장비이용도 사용현황 통계" oninit="SPMNW18010_oninit" onload="SPMNW18010_onload" ontimer="SPMNW18010_ontimer">
    <Layouts>
      <Layout>
        <Div position="absolute 0 0 750 740" id="group3" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Static text="장비이용도 사용현황 통계" position="absolute 0 0 191 20" id="cpt_title" class="tit_1" anchor="default"/>
              <Div position="absolute 0 20 750 60" align="align:center top;" id="grp_sea" class="div_SA" anchor="default">
                <Layouts>
                  <Layout>
                    <Button position="absolute 630 11 686 33" id="btn_ref" class="btn1" taborder="7" text="조회" anchor="default" onclick="group3_grp_sea_btn_ref_onclick"/>
                    <Static text="업무일자 :" position="absolute 205 12 280 29" id="caption3" class="search_name" anchor="default"/>
                    <Shape position="absolute 617 10 623 31" linetype="vertical" id="line2" class="line_4" anchor="default"/>
                    <Calendar position="absolute 280 10 368 29" id="ipt_fromdd" class="input_s_essential" taborder="2" autoselect="true" anchor="default" onchanged="group3_grp_sea_ipt_fromdd_onchanged"/>
                    <Static text="부 서 :" position="absolute 10 12 67 29" id="caption29" class="search_name" anchor="default"/>
                    <Combo position="absolute 65 11 180 30" id="cmb_deptcd" class="combo_s_essential" taborder="1" innerdataset="@ds_init_dept_dept" datacolumn="depthngnm" codecolumn="deptcd" anchor="default" onitemchanged="group3_grp_sea_cmb_deptcd_onitemchanged"/>
                    <Static text="자산명 :" position="absolute 410 12 473 29" id="caption1" class="search_name" anchor="default"/>
                    <Button position="absolute 688 11 744 33" id="button2" class="btn7" taborder="8" text="엑셀" anchor="default" onclick="group3_grp_sea_button2_onclick"/>
                    <Combo position="absolute 470 11 585 30" id="cmb_goodcd" class="combo_s_essential" taborder="1" innerdataset="@ds_codelist" datacolumn="cdnm" codecolumn="supcdid" anchor="default" onitemchanged="group3_grp_sea_cmb_goodcd_onitemchanged"/>
                  </Layout>
                </Layouts>
              </Div>
              <Shape position="absolute 0 65 750 71" linetype="horizontal" id="line1" class="line_10" anchor="default"/>
              <Grid position="absolute 0 70 750 740" id="grd_goodinfo" class="datagrid2" binddataset="ds_main_goodinfo_goodlist" anchor="default" cellsizingtype="col" scrollpixel="all" cellsizebandtype="allband">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="20" band="left"/>
                      <Column size="162"/>
                      <Column size="0"/>
                      <Column size="0"/>
                      <Column size="200"/>
                      <Column size="90"/>
                      <Column size="65"/>
                      <Column size="65"/>
                      <Column size="65"/>
                      <Column size="65"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <Cell col="1" text="병동"/>
                      <Cell col="2" text="wardcd"/>
                      <Cell col="3" text="lrgcd"/>
                      <Cell col="4" text="자산명"/>
                      <Cell col="5" text="규격"/>
                      <Cell col="6" text="보유재고"/>
                      <Cell col="7" text="사용"/>
                      <Cell col="8" text="미사용"/>
                      <Cell col="9" text="사용률(%)"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head" expr="expr:currow + 1"/>
                      <Cell col="1" text="bind:wardnm"/>
                      <Cell col="2" text="bind:wardcd"/>
                      <Cell col="3" text="bind:lrgcd"/>
                      <Cell col="4" text="bind:goodnm"/>
                      <Cell col="5" text="bind:goodspec"/>
                      <Cell col="6" text="bind:tot"/>
                      <Cell col="7" text="bind:using"/>
                      <Cell col="8" text="bind:remain"/>
                      <Cell col="9" edittype="none" text="bind:percent"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_dept_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_main_goodinfo_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="wardnm" type="STRING"/>
          <Column id="wardcd" type="STRING"/>
          <Column id="lrgcd" type="STRING"/>
          <Column id="goodnm" type="STRING"/>
          <Column id="goodspec" type="STRING"/>
          <Column id="tot" type="STRING"/>
          <Column id="using" type="STRING"/>
          <Column id="remain" type="STRING"/>
          <Column id="percent" 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="cdgrupid" type="STRING" size="256" sumtext="코드그룹ID"/>
          <Column id="srchdd" type="STRING" size="256" sumtext="조회기준일자"/>
          <Column id="flag" type="STRING" size="256" sumtext="조회기준일자"/>
          <Column id="allflag" type="STRING" size="256" sumtext="모두조회여부"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdgrupid" type="STRING" size="255"/>
          <Column id="cdid" type="STRING" size="255"/>
          <Column id="cdnm" type="STRING" size="255"/>
          <Column id="grupdetldesc" type="STRING" size="255"/>
          <Column id="supcdid" type="STRING" size="255"/>
          <Column id="sortseq" type="BIGDECIMAL" size="255"/>
          <Column id="valifromdd" type="STRING" size="255"/>
          <Column id="valitodd" type="STRING" size="255"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="fromdd" type="STRING" size="256" sumtext="기간FROM"/>
          <Column id="deptcd" type="STRING" size="256" sumtext="부서"/>
          <Column id="goodcd" type="STRING" size="256" sumtext="기자재코드"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="goodcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group3.grp_sea.cmb_deptcd" propid="value" datasetid="ds_main_cond" columnid="deptcd"/>
      <BindItem id="item1" compid="group3.grp_sea.ipt_fromdd" propid="value" datasetid="ds_main_cond" columnid="fromdd"/>
      <BindItem id="item2" compid="group3.grp_sea.cmb_goodcd" propid="value" datasetid="ds_main_cond" columnid="goodcd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************
 * System Name		:	경대 의료정보시스템
 * Job Name 		:	emr_wardcarexp -> SPMNW18010
 * Creator			:	yjh
 * Make Date 		:	2017-01-12
 * Description		:	
 *---------------------------------------------------------------------------------------
 * Modify Date		Modifier		Modify Description
 *---------------------------------------------------------------------------------------
 * 2017-01-12		yjh				TF->XP
 * 
 *---------------------------------------------------------------------------------------
 ****************************************************************************************/


//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
include "emr_carecomxp::CareCom.xjs";


//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------



//=======================================================================================
// Function
//---------------------------------------------------------------------------------------
function fSearch() {
//				model.removenode("/root/send");
//				model.makeNode("/root/send");
	ds_send_reqdata.copyData(ds_main_cond);
	
	var oParam = {};
		oParam.id          = "TRMNW19301";
		oParam.service     = "wardcareapp.TranMngt";
		oParam.method      = "reqGetGoodStaticInfo";
		oParam.inds        = "req=ds_send_reqdata";
		oParam.outds       = "ds_main_goodinfo_goodlist=goodlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRMNW19301";

	tranf_submit(oParam);
	
	ds_main_goodinfo_goodlist.rowposition = -1;
	
	/*
	var nodePath = grd_ivinfo.nodeset;
	
	for(var i = grd_ivinfo.fixedRows; i < grd_ivinfo.rows; i++) {
		if (model.getValue(nodePath + "["+i+"]/disp1") == "Y") {
			grd_ivinfo.cellstyle("background-image", i, grd_ivinfo.colRef("disp1img")) = "../../../com/hismainweb/images/btn_top_infection0.gif";
		}else{
			grd_ivinfo.cellstyle("background-image", i, grd_ivinfo.colRef("disp1img")) = "";
		}
		if (model.getValue(nodePath + "["+i+"]/disp2") == "Y") {
			grd_ivinfo.cellstyle("background-image", i, grd_ivinfo.colRef("disp2img")) = "../../../com/hismainweb/images/btn_top_infection1.gif";
		}else{
			grd_ivinfo.cellstyle("background-image", i, grd_ivinfo.colRef("disp2img")) = "";
		}
		if (model.getValue(nodePath + "["+i+"]/disp3") == "Y") {
			grd_ivinfo.cellstyle("background-image", i, grd_ivinfo.colRef("disp3img")) = "../../../com/hismainweb/images/btn_top_infection2.gif";
		}else{
			grd_ivinfo.cellstyle("background-image", i, grd_ivinfo.colRef("disp3img")) = "";
		}
	}
	*/
}


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

/****************************************************************************************
 * Components		: Form
 * Components ID	: SPMNW18010
 * Event			: onload
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 화면 로딩 완료시
 ****************************************************************************************/
function SPMNW18010_onload(obj:Form, e:LoadEventInfo)
{
	// 간호 하드코딩 조회
	ds_send.setColumn(0, "cdgrupid", "'402'");
	ds_send.setColumn(0, "srchdd"  , utlf_getCurrentDate());  // 조회기준일자  
	
	var oParam = {};
		oParam.id          = "TRMNW00001";
		oParam.service     = "wardcareapp.WardCareMngt";
		oParam.method      = "reqGetNursHardCdInfo";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_codelist=codelist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRMNW00001";

	tranf_submit(oParam);
	
	// 부서(병동) 목록 조회
	var instcd = sysf_getUserInfo("dutplceinstcd");
	var standard_yn = "orduseyn";
	var ord_deptflag = 'W';
	var rslt_ref  = "ds_init_dept_dept";
	var sort_field = "depthngnm";
	var sort_method = "asc";
	var dt = utlf_getCurrentDate();
	
	appf_getDeptCodeList(instcd, standard_yn, ord_deptflag, sort_field, sort_method, dt, "", "", rslt_ref);
	//model.setValue(cmb_deptcd.attribute("ref"), getUserInfo("dutplcecd"));
	ds_main_cond.setColumn(0, "deptcd", "");
	ds_main_cond.setColumn(0, "goodcd", "");
	
	//submit("TRMNW11001", false);  // 전체 부서조회
	frmf_addComboItem("group3.grp_sea.cmb_deptcd", "전  체", "", "above");
	ds_main_cond.setColumn(0, "fromdd", getDateAddc(utlf_getCurrentDate(),-1));
	
	//model.setValue(ipt_fromdd.attribute("ref"), getCurrentDate());
	
	
//					grd_goodinfo.mergeCol(1) = false;
//					grd_goodinfo.mergeCol(2) = false;
//					grd_goodinfo.mergeCol(3) = false;
//					//grd_goodinfo.mergeCol(4) = false;
//					grd_goodinfo.mergeCol(5) = false;
//					grd_goodinfo.mergeCol(6) = false;
//					grd_goodinfo.mergeCol(7) = false;
//					grd_goodinfo.mergeCol(8) = false;
//					grd_goodinfo.mergeCol(9) = false;
	
	/*
	if(model.getValue("/root/init/codeinfo/codelist[cdgrupid='I07' and supcdid ='"+userid+"']/supcdid") == userid) {
		
	} else { // IV팀이 아니면 비활성화
		
		if(getUserInfo("userid") == "ENR") {
			model.setValue(cmb_deptcd.attribute("ref"), "");
			cmb_deptcd.refresh();
		} else {
	
			model.setValue(cmb_deptcd.attribute("ref"), getUserInfo("dutplcecd"));
			cmb_deptcd.refresh();
		}
	}
	*/
	//fSearch();
	this.setTimer(0, 100);
}

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

/****************************************************************************************
 * Components		: Calendar
 * Components ID	: ipt_fromdd
 * Event			: onchanged
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 달력 값 변경시
 ****************************************************************************************/
function group3_grp_sea_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	fSearch();
}

/****************************************************************************************
 * Components		: Combo
 * Components ID	: cmb_deptcd
 * Event			: onitemchanged
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 콤보 값 변경시
 ****************************************************************************************/
function group3_grp_sea_cmb_deptcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	fSearch();
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: button2
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 엑셀버튼 클릭시
 ****************************************************************************************/
function group3_grp_sea_button2_onclick(obj:Button,  e:ClickEventInfo)
{
	if( group3.grd_goodinfo.rowcount > 0 ){
		grdf_exportExcel(group3.grd_goodinfo, "기자재사용현황통계", "SheetName", false, "", "user", false);
	} else {
		sysf_messageBox("조회된 데이터가 ", "I004");
		return;
	}
}

/****************************************************************************************
 * Components		: Combo
 * Components ID	: cmb_goodcd
 * Event			: onitemchanged
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 콤보 값 변경시
 ****************************************************************************************/
function group3_grp_sea_cmb_goodcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	fSearch();
}

function SPMNW18010_ontimer(obj:Form, e:TimerEventInfo)
{
	if( e.timerid == 0 ){
		this.killTimer(0);
		
		fSearch();
	}
}
]]></Script>
  </Form>
</FDL>