YNU_JEUS/app_home/himed/xpapps/emr/csrxp/xp/SMMNG01600_물품별부서보유현황조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMMNG01600" position="absolute 0 0 1086 766" titletext="물품별 부서 보유현황 조회" oninit="SMMNG01600_oninit" onload="SMMNG01600_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 0 1035 26" id="grp_tle">
          <Layouts>
            <Layout>
              <Static text="물품별 부서 보유현황 조회" position="absolute 0 0 189 25" id="caption6" class="tit_1" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 23 1086 766" id="grp_biz" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Static text="물품내역" position="absolute 0 81 87 98" id="caption1" class="tit_2" anchor="default"/>
              <Shape position="absolute 0 98 716 104" linetype="horizontal" id="line1" class="line_10" anchor="default"/>
              <Shape position="absolute 720 97 1086 103" linetype="horizontal" id="line2" class="line_10" anchor="left top right"/>
              <Grid position="absolute 0 104 715 743" id="grd_deptgoodinfolist" class="datagrid2" binddataset="ds_main_deptgoodinfo_deptgoodinfolist" anchor="left top bottom" oncelldblclick="grp_biz_grd_deptgoodinfolist_oncelldblclick" cellsizebandtype="allband" cellsizingtype="col" autofittype="col">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="24"/>
                      <Column size="71"/>
                      <Column size="98"/>
                      <Column size="143"/>
                      <Column size="78"/>
                      <Column size="80"/>
                      <Column size="56"/>
                      <Column size="0"/>
                      <Column size="44"/>
                      <Column size="44"/>
                      <Column size="42"/>
                    </Columns>
                    <Rows>
                      <Row size="26" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <Cell col="1" text="Set구분"/>
                      <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="총&#10;보유량"/>
                      <Cell col="9" text="부서&#10;보유량"/>
                      <Cell col="10" text="CSR&#10;보유량"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head" expr="currow + 1"/>
                      <Cell col="1" displaytype="combo" edittype="combo" style="align:center middle;" text="bind:proddrugsetflag" combodataset="ds_cbo_proddrugsetflag" combocodecol="value" combodatacol="label"/>
                      <Cell col="2" displaytype="text" edittype="none" style="background2:URL('theme://images/bg_edit_est_N.png') stretch 9,9;" class="input_essential" text="bind:goodcd"/>
                      <Cell col="3" displaytype="text" edittype="none" style="align:left top;padding:5 2 0 2;" text="bind:goodnm" wordwrap="char"/>
                      <Cell col="4" style="align:left top;padding:5 2 0 2;" text="bind:goodspec" wordwrap="char"/>
                      <Cell col="5" style="align:left top;padding:5 2 0 2;" text="bind:goodmodel" wordwrap="char"/>
                      <Cell col="6" displaytype="combo" edittype="combo" style="align:center middle;" text="bind:dinfflag" combodataset="ds_M0586" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
                      <Cell col="7" displaytype="combo" edittype="combo" text="bind:dinfdivs"/>
                      <Cell col="8" style="align:right middle;padding:0 2 0 0;" text="bind:baseqty"/>
                      <Cell col="9" style="align:right middle;padding:0 2 0 0;" text="bind:safestocqty"/>
                      <Cell col="10" style="align:right middle;padding:0 2 0 0;" text="bind:csrbaseqty"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Grid position="absolute 720 103 1085 743" id="grd_deptgooddelinfolist" binddataset="ds_main_deptgooddelinfo_deptgooddelinfolist" anchor="all" autofittype="col">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="57"/>
                      <Column size="85"/>
                      <Column size="41"/>
                      <Column size="42"/>
                      <Column size="25"/>
                      <Column size="85"/>
                    </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="4" text="비품수량" taborder="undefined"/>
                      <Cell row="1" col="2" text="Total"/>
                      <Cell row="1" col="3" text="Single"/>
                      <Cell row="1" col="4" colspan="2" text="Set" taborder="undefined"/>
                    </Band>
                    <Band id="body">
                      <Cell displaytype="combo" edittype="combo" text="bind:csrreqdeptcd" combodataset="ds_temp_csrreqdeptlist" combocodecol="csrreqdeptcd" combodatacol="csrreqdeptnm" enable="false"/>
                      <Cell col="1" displaytype="text" edittype="none" style="align:left top;padding:5 2 0 2;" text="bind:deptnm" wordwrap="char"/>
                      <Cell col="2" displaytype="normal" edittype="none" text="bind:safestocqty"/>
                      <Cell col="3"/>
                      <Cell col="4"/>
                      <Cell col="5" displaytype="normal" edittype="none" text="bind:goodnm"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Static text="부서 보유 상세내역" position="absolute 720 81 887 98" id="caption3" class="tit_2" anchor="default"/>
              <Div id="Div00" taborder="9" position="absolute 0 1 1085 73" class="div_SA" anchor="left top right"/>
              <Radio id="rdo_reqflag" taborder="10" codecolumn="codecolumn" datacolumn="datacolumn" visible="false" position="absolute 130 44 466 60" anchor="default" style="textpadding:0 5 0 3;" columncount="-1" index="0" rowcount="-1">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn"/>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <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">4</Col>
                      <Col id="datacolumn">린넨</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">3</Col>
                      <Col id="datacolumn">멸균의뢰</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Static id="caption14" text="물품구분 :" class="search_name" visible="false" position="absolute 40 45 126 62" anchor="default"/>
              <Static id="caption13" text="분류구분 :" class="search_name" position="absolute 40 16 126 33" anchor="default"/>
              <Static id="caption2" text="Set구분  :" class="search_name" position="absolute 450 16 536 33" anchor="default"/>
              <Radio id="rdo_goodflag" taborder="11" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 540 45 688 61" anchor="default" style="textpadding:0 5 0 3;" columncount="2" index="0" value="01" rowcount="0">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">01</Col>
                      <Col id="datacolumn">물품코드</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">02</Col>
                      <Col id="datacolumn">물품명</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Edit id="ipt_reqdata" taborder="12" class="input_search" position="absolute 686 41 831 60" anchor="default"/>
              <Combo id="cmb_mdlcd" taborder="13" innerdataset="ds_init_mdllist" codecolumn="mdlcd" datacolumn="mdlnm" onitemchanged="grp_biz_cmb_mdlcd_onitemchanged" position="absolute 230 15 325 34" anchor="default"/>
              <Static id="cap_goodcd" text="검색구분 :" class="search_name" position="absolute 450 45 536 62" anchor="default"/>
              <Radio id="rdo_proddrugsetflag" taborder="14" index="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 540 15 726 31" anchor="default" style="textpadding:0 5 0 3;margin:0 0 0 0;padding:1 0 0 0;" columncount="3" rowcount="0">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn"/>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">Set</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">Single</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Combo id="cmb_smlcd" taborder="15" innerdataset="ds_init_smllist" codecolumn="smlcd" datacolumn="smlnm" position="absolute 335 15 430 34" anchor="default"/>
              <Combo id="cmb_lrgcd" taborder="16" innerdataset="ds_init_lrglist" codecolumn="lrgcd" datacolumn="lrgnm" onitemchanged="grp_biz_cmb_lrgcd_onitemchanged" position="absolute 130 15 225 34" anchor="default"/>
              <Button id="btn_search" taborder="17" text="조회" onclick="grp_biz_btn_search_onclick" class="btn1" position="absolute 1017 20 1073 42" anchor="top right"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 998 20 1004 42" anchor="top right"/>
              <Button id="btn_excel2" taborder="18" text="엑셀" class="btn7" position="absolute 1030 75 1086 97" anchor="top right" onclick="grp_biz_btn_excel2_onclick"/>
              <Button id="btn_excel1" taborder="19" text="엑셀" class="btn7" position="absolute 660 76 716 98" anchor="top right" onclick="grp_biz_btn_excel1_onclick"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="lrgcd" type="STRING" size="256"/>
          <Column id="mdlcd" type="STRING" size="256"/>
          <Column id="smlcd" type="STRING" size="256"/>
          <Column id="proddrugsetflag" type="STRING" size="256"/>
          <Column id="reqflag" type="STRING" size="256"/>
          <Column id="goodflag" type="STRING" size="256"/>
          <Column id="reqdata" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="goodflag">01</Col>
            <Col id="proddrugsetflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_deptgoodinfo_deptgoodinfolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_deptgooddelinfo_deptgooddelinfolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_cbo_proddrugsetflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">전체</Col>
            <Col id="value">-</Col>
          </Row>
          <Row>
            <Col id="label">Set</Col>
            <Col id="value">1</Col>
          </Row>
          <Row>
            <Col id="label">Single</Col>
            <Col id="value">2</Col>
          </Row>
          <Row>
            <Col id="label">Single Set</Col>
            <Col id="value">3</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_M0586" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_M0585" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_lrglist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_mdllist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_smllist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_goodreq" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_temp_csrreqdeptlist" 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.cmb_lrgcd" propid="value" datasetid="ds_cond" columnid="lrgcd"/>
      <BindItem id="item2" compid="grp_biz.cmb_smlcd" propid="value" datasetid="ds_cond" columnid="smlcd"/>
      <BindItem id="item3" compid="grp_biz.rdo_proddrugsetflag" propid="value" datasetid="ds_cond" columnid="proddrugsetflag"/>
      <BindItem id="item1" compid="grp_biz.cmb_mdlcd" propid="value" datasetid="ds_cond" columnid="mdlcd"/>
      <BindItem id="item6" compid="grp_biz.ipt_reqdata" propid="value" datasetid="ds_cond" columnid="reqdata"/>
      <BindItem id="item5" compid="grp_biz.rdo_goodflag" propid="value" datasetid="ds_cond" columnid="goodflag"/>
      <BindItem id="item4" compid="grp_biz.rdo_reqflag" propid="value" datasetid="ds_cond" columnid="reqflag"/>
    </Bind>
    <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 "com_basiccodexp::ZBC001.xjs";
include "emr_prcpmngtxp::MMOCommon.xjs";
 var arErrorCode 	= new HashArray();

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

function SMMNG01600_onload(obj:Form, e:LoadEventInfo)
{
	var arrParam = [{dsNm: "ds_M0585", cdGrpId: "M0585"},
					{dsNm: "ds_M0586", cdGrpId: "M0586"}
				   ]
	appf_getCodeList(arrParam);					
					
	ds_main_deptgoodinfo_deptgoodinfolist.clearData();				
	ds_main_deptgooddelinfo_deptgooddelinfolist.clearData();					
	
	dsf_makeValue(ds_send_goodreq, "instcd", "string", sysf_getUserInfo("dutplceinstcd"));
	dsf_makeValue(ds_send_goodreq, "useyn",  "string", "Y");
		
	var oParam = {};
		oParam.id          = "TRMNG00401";
		oParam.service     = "csrapp.CsrMngt";
		oParam.method      = "reqGetDeptFlagList";
		oParam.inds        = "req=ds_send_goodreq";
		oParam.outds       = "ds_temp_csrreqdeptlist=csrreqdeptlist";
		oParam.async       = false;

	tranf_submit(oParam);

	var oParam = {};
		oParam.id          = "TRMNG00101";
		oParam.service     = "csrapp.CsrMngt";
		oParam.method      = "reqGetLrgcdList";
		oParam.inds        = "req=ds_send_goodreq";
		oParam.outds       = "ds_init_lrglist=lrglist";
		oParam.async       = false;		

	tranf_submit(oParam);
	
	frmf_addComboItem( "grp_biz.cmb_lrgcd", "전체", "", "above"); 
	grp_biz.cmb_lrgcd.value = "";		
}

function fGetDeptGoodinfoSearch(){
	var oParam = {};
		oParam.id          = "TRMNG01601";
		oParam.service     = "csrapp.CsrMngt";
		oParam.method      = "reqGetDeptCsrGoodInfo";
		oParam.inds        = "cond=ds_cond";
		oParam.outds       = "ds_main_deptgoodinfo_deptgoodinfolist=deptgoodinfolist";
		oParam.async       = false;		

	tranf_submit(oParam);		
}

function grp_biz_grd_deptgoodinfolist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{	
	if( e.row < -1 && e.col < -1 ) return;	
	
	var iRow = ds_main_deptgoodinfo_deptgoodinfolist.rowposition;

	dsf_makeValue(ds_send_reqdata, "goodcd", "string", ds_main_deptgoodinfo_deptgoodinfolist.getColumn(iRow, "goodcd"));

	var oParam = {};
		oParam.id          = "TRMNG01602";
		oParam.service     = "csrapp.CsrMngt";
		oParam.method      = "reqGetDeptCsrGoodDelInfo";
		oParam.inds        = "req=ds_send_reqdata";
		oParam.outds       = "ds_main_deptgooddelinfo_deptgooddelinfolist=deptgooddelinfolist";
		oParam.async       = false;
		oParam.callback    = "cf_TRMNG01602";

	tranf_submit(oParam);
	if(arErrorCode.pop("TRMNG01602") > -1){		
		ds_send_reqdata.clearData();
	}
}

function cf_TRMNG01602(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
}

function grp_biz_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetDeptGoodinfoSearch();
}

function grp_biz_cmb_lrgcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	var oParam = {};
		oParam.id          = "TRMNG00102";
		oParam.service     = "csrapp.CsrMngt";
		oParam.method      = "reqGetMdlcdList";
		oParam.inds        = "req=ds_cond";
		oParam.outds       = "ds_init_mdllist=mdllist";
		oParam.async       = false;

	tranf_submit(oParam);
	
	//var nodelist = instance1.selectNodes("/root/init/mdllist");	
	ds_cond.setColumn(0, "mdlcd", "");
	ds_cond.setColumn(0, "smlcd", "");
	
	if(ds_init_mdllist.rowcount == 0){
		ds_init_mdllist.clearData();
		ds_init_smllist.clearData();
	}else{
		frmf_addComboItem( "grp_biz.cmb_mdlcd", "전체", "", "above");
		grp_biz.cmb_mdlcd.value = "";
	}
}

function grp_biz_cmb_mdlcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	var oParam = {};
		oParam.id          = "TRMNG00103";
		oParam.service     = "csrapp.CsrMngt";
		oParam.method      = "reqGetSmlcdList";
		oParam.inds        = "req=ds_cond";
		oParam.outds       = "ds_init_smllist=smllist";
		oParam.async       = false;		

	tranf_submit(oParam);
	
	ds_cond.setColumn(0, "smlcd", "");
	
	if(ds_init_smllist.rowcount == 0){		
		ds_init_smllist.clearData();
	}else{
		frmf_addComboItem( "grp_biz.cmb_smlcd", "전체", "", "above");		
		grp_biz.cmb_smlcd.value = "";
	}
}

//20180503 이돈희 : 엑셀 출력 기능 추가
function grp_biz_btn_excel1_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grp_biz.grd_deptgoodinfolist, "물품내역", "물품내역", false, "", "user", false);
}

//20180503 이돈희 : 엑셀 출력 기능 추가
function grp_biz_btn_excel2_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grp_biz.grd_deptgooddelinfolist, "부서보유상세내역", "부서보유상세내역", false, "", "user", false);
}
]]></Script>
  </Form>
</FDL>