YNU_JEUS/app_home/himed/xpapps/emr/csrxp/xp/SPMNG04200_SET처방 상세내역.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPMNG04200" position="absolute 0 0 753 640" titletext="SET기구 처방 집계현황" oninit="SPMNG04200_oninit" onload="SPMNG04200_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 15 745 635" id="grp_biz" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Div position="absolute 0 10 745 45" align="align:center top;" id="grp_sea" anchor="default">
                <Layouts>
                  <Layout>
                    <Shape position="absolute 0 0 745 35" id="roundrect1" class="roundrect_search" type="roundrectangle" anchor="default"/>
                    <Static text="처방일자:" position="absolute 15 10 101 27" id="cap_instcd" class="search_name" anchor="default"/>
                    <Shape position="absolute 607 4 613 29" linetype="vertical" id="line13" class="line_4" anchor="default"/>
                    <Button position="absolute 620 7 676 29" id="btn_search" class="btn1" taborder="2" text="조회" anchor="default" onclick="grp_biz_grp_sea_btn_search_onclick"/>
                    <Calendar position="absolute 100 8 185 27" id="ipt_fromdd" anchor="default"/>
                    <Calendar position="absolute 195 8 280 27" id="ipt_todd" anchor="default"/>
                    <Static text="~" position="absolute 185 10 201 28" id="caption1" anchor="default"/>
                    <Button position="absolute 680 7 736 29" id="button1" class="btn7" taborder="2" text="엑셀" anchor="default" onclick="grp_biz_grp_sea_button1_onclick"/>
                    <Static text="물품코드 :" position="absolute 290 10 381 27" id="caption2" class="search_name" anchor="default"/>
                  </Layout>
                </Layouts>
              </Div>
              <Static text="SET처방 상세내역" position="absolute 2 58 203 76" id="caption8" class="tit_2" anchor="default"/>
              <Shape position="absolute 0 74 745 80" linetype="horizontal" id="line1" class="line_10" anchor="default"/>
              <Grid position="absolute 0 79 745 620" id="grd_sumlist" class="datagrid2" binddataset="ds_main_suminfo_sumlist" anchor="default" autofittype="col" cellsizingtype="col">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="0"/>
                      <Column size="24"/>
                      <Column size="44"/>
                      <Column size="63"/>
                      <Column size="65"/>
                      <Column size="75"/>
                      <Column size="75"/>
                      <Column size="111"/>
                      <Column size="75"/>
                      <Column size="118"/>
                      <Column size="40"/>
                      <Column size="40"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                      <Row size="24" band="summ"/>
                    </Rows>
                    <Band id="head">
                      <Cell text="부서명"/>
                      <Cell col="1"/>
                      <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="물품코드"/>
                      <Cell col="9" text="물품명"/>
                      <Cell col="10" text="수량"/>
                      <Cell col="11" text="집계&#10;구분"/>
                    </Band>
                    <Band id="body">
                      <Cell text="bind:deptnm"/>
                      <Cell col="1" celltype="head" expr="currow + 1"/>
                      <Cell col="2" text="bind:room"/>
                      <Cell col="3" text="bind:pid"/>
                      <Cell col="4" text="bind:patnm"/>
                      <Cell col="5" displaytype="date" text="bind:prcpdd" calendardisplaynulltype="none"/>
                      <Cell col="6" style="align:left top;padding:5 2 1 2;" text="bind:prcpcd" wordwrap="word"/>
                      <Cell col="7" style="align:left top;padding:5 2 1 2;" text="bind:prcpnm" wordwrap="word"/>
                      <Cell col="8" style="align:left top;padding:5 2 1 2;" text="bind:goodcd" wordwrap="word"/>
                      <Cell col="9" style="align:left top;padding:5 2 1 2;" text="bind:goodnm" wordwrap="word"/>
                      <Cell col="10" text="bind:sumcnt"/>
                      <Cell col="11" text="bind:sumflag"/>
                    </Band>
                    <Band id="summary">
                      <Cell/>
                      <Cell col="1"/>
                      <Cell col="2" style="font:arial,9,bold;" text="합계"/>
                      <Cell col="3"/>
                      <Cell col="4"/>
                      <Cell col="5"/>
                      <Cell col="6"/>
                      <Cell col="7"/>
                      <Cell col="8"/>
                      <Cell col="9"/>
                      <Cell col="10" style="font:arial,9,bold;" expr="expr:getSum(&quot;sumcnt&quot;)"/>
                      <Cell col="11"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Edit position="absolute 320 50 420 69" id="ipt_deptcd" visible="false" anchor="default"/>
              <Combo position="absolute 380 18 530 37" id="cmb_goodcd" innerdataset="@ds_init_R0435list" datacolumn="cdnm" codecolumn="cdid" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption6" text="부서별 Set처방 상세내역" class="tit_1" position="absolute 0 0 199 25"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_cond" 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="flag" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="deptflag" type="STRING" size="256"/>
          <Column id="goodcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="flag"/>
            <Col id="deptcd"/>
            <Col id="deptflag"/>
            <Col id="goodcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_suminfo_sumlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_R0435list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="Dataset00" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_biz.grp_sea.ipt_fromdd" propid="value" datasetid="ds_main_cond" columnid="fromdd"/>
      <BindItem id="item1" compid="grp_biz.grp_sea.ipt_todd" propid="value" datasetid="ds_main_cond" columnid="todd"/>
      <BindItem id="item2" compid="grp_biz.cmb_goodcd" propid="value" datasetid="ds_main_cond" columnid="goodcd"/>
      <BindItem id="item3" compid="grp_biz.ipt_deptcd" propid="value" datasetid="ds_main_cond" columnid="deptcd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-07-11
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-07-11      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";

var arErrorCode 	= new HashArray();
function SPMNG04200_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	//폼 초기화
}

function SPMNG04200_onload(obj:Form, e:LoadEventInfo)
{
	fInitialize();
}

// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
function fInitialize() {
		
	var arrParam = [{dsNm: "ds_init_R0435list", cdGrpId: "R0435"}
				   ]
	appf_getCodeList(arrParam);	
	
	frmf_addComboItem("grp_biz.cmb_goodcd", "전체", "", "above");
	grp_biz.cmb_goodcd.value = "";
	
	if(frmf_checkOpener()) {		
		grp_biz.grp_sea.ipt_fromdd.value 	= opener.frmf_getParameter("fromdd");
		grp_biz.grp_sea.ipt_todd.value 		= opener.frmf_getParameter("todd");
		if(utlf_isNull(opener.frmf_getParameter("goodcd"))){
			grp_biz.cmb_goodcd.value = "";
		}else{
			grp_biz.cmb_goodcd.value 			= opener.frmf_getParameter("goodcd");
		}
		grp_biz.ipt_deptcd.value 			= opener.frmf_getParameter("deptcd");
	} else {		
		grp_biz.grp_sea.ipt_fromdd.value 	= utlf_getCurrentDate();
		grp_biz.grp_sea.ipt_todd.value 		= utlf_getCurrentDate();
		grp_biz.cmb_goodcd.value 			= "";
		grp_biz.ipt_deptcd.value 			= sysf_getUserInfo("dutplcecd");
	}
	fSearch();
}

function fSearch(){	
	ds_send_reqdata.clearData();		
	ds_send_reqdata.copyData(ds_main_cond);
	
	var oParam = {};
		oParam.id          = "TRMNG04201";
		oParam.service     = "csrapp.CsrMngt";
		oParam.method      = "reqGetSumDetlList";
		oParam.inds        = "req=ds_send_reqdata";
		oParam.outds       = "ds_main_suminfo_sumlist=sumlist";
		oParam.async       = false;		

	tranf_submit(oParam);
	
	//ds_main_suminfo_sumlist.keystring = 
	//grd_sumlist.subtotal("sum", -1, grd_sumlist.colRef("sumcnt"), "#,###.##", "background-color:#99ff99; font-weight:bold", grd_sumlist.colRef("room"), "합계");
}
function grp_biz_grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fSearch();
}

function grp_biz_grp_sea_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_list, "부서별Enema SkinPrep" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
}
]]></Script>
  </Form>
</FDL>