YNU_JEUS/app_home/himed/xpapps/emr/opanstxp/xp/SMMNP03904_물품별수술방재고조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMMNP03904" position="absolute 0 0 1205 759" titletext="방재고 조회" oninit="SMMNP03904_oninit" onload="SMMNP03904_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="수술방 안전재고 조회" class="tit_1" position="absolute 0 0 203 25"/>
        <Static id="caption1" text="수술방 물품 안전재고 현황" class="tit_2" position="absolute 0 92 185 115"/>
        <Shape id="line2" class="line_10" position="absolute 0 108 1195 114" anchor="left top right"/>
        <Grid id="grd_stoclist" class="datagrid2" taborder="1" binddataset="ds_main_stocinfo_stoclist" useinputpanel="false" position="absolute 0 113 1195 753" autoenter="select" cellsizingtype="col" anchor="all" onkeydown="grd_stoclist_onkeydown" cellsizebandtype="allband">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="23" band="left"/>
                <Column size="93" band="left"/>
                <Column size="235" band="left"/>
                <Column size="109" band="left"/>
                <Column size="40" band="left"/>
              </Columns>
              <Rows>
                <Row size="41" 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="단위"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" text="bind:goodcd"/>
                <Cell col="2" style="align:left top;padding:4 2 2 2;" text="bind:goodnm" wordwrap="word"/>
                <Cell col="3" style="align:left top;padding:4 2 2 2;" text="bind:goodspec" wordwrap="word"/>
                <Cell col="4" style="align:left middle;padding:0 0 0 2;" text="bind:deliveunit"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Div id="grp_sea" anchor="left top right" taborder="2" class="div_SA" position="absolute 0 25 1194 85">
          <Layouts>
            <Layout>
              <Button id="btn_search" taborder="1" text="조회" class="btn1" position="absolute 1070 19 1126 41" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1057 13 1063 46" anchor="top right"/>
              <Static id="caption26" text="불출시기 :" class="search_name" position="absolute 230 34 316 51" anchor="default"/>
              <Static id="caption29" text="물품코드 :" class="search_name" position="absolute 550 9 644 26" anchor="default"/>
              <Static id="caption5" text="부서구분 :" class="search_name" position="absolute 5 10 99 27" anchor="default"/>
              <Static id="caption8" text="구매구분 :" class="search_name" position="absolute 230 9 324 26" anchor="default"/>
              <Radio id="radio3" taborder="2" columncount="4" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 320 9 500 29" anchor="default">
                <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">3</Col>
                      <Col id="datacolumn">가납</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Static id="caption9" text="처방구분 :" class="search_name" position="absolute 5 36 95 53" anchor="default"/>
              <Radio id="radio5" taborder="3" columncount="4" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 320 34 541 54" anchor="default">
                <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">3</Col>
                      <Col id="datacolumn">미불출</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Combo id="combo1" taborder="4" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 90 34 165 53" anchor="default">
                <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">Suture</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">Supplies</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">3</Col>
                      <Col id="datacolumn">Drug</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">4</Col>
                      <Col id="datacolumn">Instrument</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">5</Col>
                      <Col id="datacolumn">처치,행위</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">6</Col>
                      <Col id="datacolumn">린넨/소모품</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">7</Col>
                      <Col id="datacolumn">Sheet</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">8</Col>
                      <Col id="datacolumn">Glove</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">9</Col>
                      <Col id="datacolumn">일반물품</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">10</Col>
                      <Col id="datacolumn">린넨</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">11</Col>
                      <Col id="datacolumn">공용</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Combo id="combo2" taborder="5" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 90 9 200 28" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">O</Col>
                      <Col id="datacolumn">수술</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">A</Col>
                      <Col id="datacolumn">마취</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">R</Col>
                      <Col id="datacolumn">회복</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">E</Col>
                      <Col id="datacolumn">안과</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Radio id="rdo_goodflag" taborder="6" columncount="2" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 629 6 767 27" anchor="default" onitemchanged="grp_sea_rdo_goodflag_onitemchanged">
                <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>
              </Radio>
              <Edit id="ipt_goodcd" taborder="7" class="input_search" position="absolute 770 7 955 26" anchor="default" onkeydown="grp_sea_ipt_goodcd_onkeydown"/>
              <Edit id="ipt_goodnm" taborder="8" class="input_search" visible="false" position="absolute 770 7 955 26" anchor="default" onkeydown="grp_sea_ipt_goodnm_onkeydown"/>
              <Button id="button1" taborder="9" text="엑셀" class="btn1" position="absolute 1129 19 1185 41" anchor="top right" onclick="grp_sea_button1_onclick"/>
            </Layout>
          </Layouts>
        </Div>
      </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="oproomcd" type="STRING" size="256"/>
          <Column id="useflag" type="STRING" size="256"/>
          <Column id="goodcd" type="STRING" size="256"/>
          <Column id="goodnm" type="STRING" size="256"/>
          <Column id="allsizespecid" type="STRING" size="256"/>
          <Column id="lrgcd" type="STRING" size="256"/>
          <Column id="mdlcd" type="STRING" size="256"/>
          <Column id="smlcd" type="STRING" size="256"/>
          <Column id="goodflag" type="STRING" size="256"/>
          <Column id="tabflag" type="STRING" size="256"/>
          <Column id="deptflag" type="STRING" size="256"/>
          <Column id="prodcmpynm" type="STRING" size="256"/>
          <Column id="deliveyn" type="STRING" size="256"/>
          <Column id="delivepriod" type="STRING" size="256"/>
          <Column id="purcflag" type="STRING" size="256"/>
          <Column id="cureflag" type="STRING" size="256"/>
          <Column id="stocflag" type="STRING" size="256"/>
          <Column id="refflag" type="STRING" size="256"/>
          <Column id="cnfmyn" type="STRING" size="256"/>
          <Column id="variable" type="STRING" size="256"/>
          <Column id="oprosette" type="STRING" size="256"/>
          <Column id="refcnfmyn" type="STRING" size="256"/>
          <Column id="searflag" type="STRING" size="256"/>
          <Column id="delflag" type="STRING" size="256"/>
          <Column id="goodflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="oproomcd"/>
            <Col id="useflag"/>
            <Col id="goodcd"/>
            <Col id="goodnm"/>
            <Col id="allsizespecid"/>
            <Col id="lrgcd"/>
            <Col id="mdlcd"/>
            <Col id="smlcd"/>
            <Col id="goodflag">1</Col>
            <Col id="tabflag">CCR</Col>
            <Col id="deptflag">O</Col>
            <Col id="prodcmpynm"/>
            <Col id="deliveyn"/>
            <Col id="delivepriod"/>
            <Col id="purcflag"/>
            <Col id="cureflag"/>
            <Col id="stocflag">U</Col>
            <Col id="refflag"/>
            <Col id="cnfmyn"/>
            <Col id="variable"/>
            <Col id="oprosette"/>
            <Col id="refcnfmyn"/>
            <Col id="searflag"/>
            <Col id="delflag"/>
            <Col id="goodflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_stocinfo_stoclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="goodcd" type="STRING" size="256" sumtext="물품코드"/>
          <Column id="goodnm" type="STRING" size="256" sumtext="물품명"/>
          <Column id="goodspec" type="STRING" size="256" sumtext="물품규격"/>
          <Column id="deliveunit" type="STRING" size="256" sumtext="물품단위"/>
          <Column id="room0000" type="STRING" size="256" sumtext="roomCCR"/>
          <Column id="room0001" type="STRING" size="256" sumtext="room1"/>
          <Column id="room0002" type="STRING" size="256" sumtext="room2"/>
          <Column id="room0003" type="STRING" size="256" sumtext="room3"/>
          <Column id="room0004" type="STRING" size="256" sumtext="room4"/>
          <Column id="room0005" type="STRING" size="256" sumtext="room5"/>
          <Column id="room0006" type="STRING" size="256" sumtext="room6"/>
          <Column id="room0007" type="STRING" size="256" sumtext="room7"/>
          <Column id="room0008" type="STRING" size="256" sumtext="room8"/>
          <Column id="room0009" type="STRING" size="256" sumtext="room9"/>
          <Column id="room0010" type="STRING" size="256" sumtext="room10"/>
          <Column id="room0011" type="STRING" size="256" sumtext="room11"/>
          <Column id="room0012" type="STRING" size="256" sumtext="room12"/>
          <Column id="room0013" type="STRING" size="256" sumtext="room13"/>
          <Column id="room0014" type="STRING" size="256" sumtext="room14"/>
          <Column id="room0015" type="STRING" size="256" sumtext="room15"/>
          <Column id="room0016" type="STRING" size="256" sumtext="room16"/>
          <Column id="room0017" type="STRING" size="256" sumtext="room17"/>
          <Column id="room0018" type="STRING" size="256" sumtext="room18"/>
          <Column id="room0019" type="STRING" size="256" sumtext="room19"/>
          <Column id="room0020" type="STRING" size="256" sumtext="room20"/>
          <Column id="room0021" type="STRING" size="256" sumtext="room21"/>
          <Column id="room0022" type="STRING" size="256" sumtext="room22"/>
          <Column id="room0023" type="STRING" size="256" sumtext="room23"/>
          <Column id="room0024" type="STRING" size="256" sumtext="room24"/>
          <Column id="room0025" type="STRING" size="256" sumtext="room25"/>
          <Column id="room0026" type="STRING" size="256" sumtext="room26"/>
          <Column id="room0027" type="STRING" size="256" sumtext="room27"/>
          <Column id="room0028" type="STRING" size="256" sumtext="room28"/>
          <Column id="room0029" type="STRING" size="256" sumtext="room29"/>
          <Column id="room0030" type="STRING" size="256" sumtext="room30"/>
          <Column id="room0031" type="STRING" size="256" sumtext="room31"/>
          <Column id="room0032" type="STRING" size="256" sumtext="room32"/>
          <Column id="room0033" type="STRING" size="256" sumtext="room33"/>
          <Column id="room0034" type="STRING" size="256" sumtext="room34"/>
          <Column id="room0035" type="STRING" size="256" sumtext="room35"/>
          <Column id="room0036" type="STRING" size="256" sumtext="room36"/>
          <Column id="room0037" type="STRING" size="256" sumtext="room37"/>
          <Column id="room0038" type="STRING" size="256" sumtext="room38"/>
          <Column id="room0039" type="STRING" size="256" sumtext="room39"/>
          <Column id="room0040" type="STRING" size="256" sumtext="room40"/>
          <Column id="room9998" type="STRING" size="256" sumtext="room40"/>
          <Column id="room9999" type="STRING" size="256" sumtext="room40"/>
          <Column id="room8888" type="STRING" size="256" sumtext="room40"/>
          <Column id="room1111" type="STRING" size="256" sumtext="room40"/>
          <Column id="total" type="STRING" size="256" sumtext="room40"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_stocinfo_titlelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="roomnm" type="STRING" size="256" sumtext="방이름"/>
          <Column id="roomcd" type="STRING" size="256" sumtext="방이름"/>
          <Column id="roomcnt" type="STRING" size="256" sumtext="방갯수"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.combo2" propid="value" datasetid="ds_main_cond" columnid="deptflag"/>
      <BindItem id="item1" compid="grp_sea.radio3" propid="value" datasetid="ds_main_cond" columnid="purcflag"/>
      <BindItem id="item2" compid="grp_sea.rdo_goodflag" propid="value" datasetid="ds_main_cond" columnid="goodflag"/>
      <BindItem id="item3" compid="grp_sea.ipt_goodnm" propid="value" datasetid="ds_main_cond" columnid="goodnm"/>
      <BindItem id="item4" compid="grp_sea.ipt_goodcd" propid="value" datasetid="ds_main_cond" columnid="goodcd"/>
      <BindItem id="item5" compid="grp_sea.combo1" propid="value" datasetid="ds_main_cond" columnid="cureflag"/>
      <BindItem id="item6" compid="grp_sea.radio5" propid="value" datasetid="ds_main_cond" columnid="delivepriod"/>
    </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";
function SMMNP03904_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMMNP03904_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_stoclist);
	
	grp_sea.rdo_goodflag.value = 1;
	
	fSearch();
}

var cnt = 0;
function fSearch()
{
	ds_send_reqdata.clearData();
	ds_send_reqdata.copyData(ds_main_cond)
	dsf_makeValue(ds_send_reqdata, "flag", "string", "1", 0);
	ds_main_stocinfo_stoclist.clearData();
	
	var oParam = {};
		oParam.id          = "TRMNP03907";
		oParam.service     = "opanstapp.OpAnstStocMngt";
		oParam.method      = "reqGetReqStocInfoList";
		oParam.inds        = "req=ds_send_reqdata";
		oParam.outds       = "ds_main_stocinfo_titlelist=titlelist ds_main_stocinfo_stoclist=stoclist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRMNP03907";

	tranf_submit(oParam);
// 	
// 	//var iCol = grd_stoclist.colRef("goodspec");
// 	
	var cap = ds_main_stocinfo_titlelist.getColumn(0, "roomnm");
	var cap_nm = cap.split("^");
	
	var existroom = ds_main_stocinfo_titlelist.getColumn(0, "roomcd");
	
	var roomcnt = parseInt(ds_main_stocinfo_titlelist.getColumn(0, "roomcnt"));
	var bind_nm = existroom.split(",");
	
	var nm;
	var hiddenidx;
	
	if(cnt == 0)
	{
		for(var i = 0; i < cap_nm.length; i++) 
		{
			nm = cap_nm[i];
			arr = bind_nm[i];
			
			grd_stoclist.appendContentsCol();
			grd_stoclist.setCellProperty("Head", parseInt(i+5), "text", nm);
			grd_stoclist.setCellProperty("Head", parseInt(i+5), "wordwrap", "word");
			grd_stoclist.setCellProperty("Body", parseInt(i+5), "text", "bind:room"+arr);
			
			grd_stoclist.setFormatColProperty(parseInt(i+5), "size", 45);
			grd_stoclist.setCellProperty("Body", parseInt(i+5), "displaytype", "number");
			grd_stoclist.setCellProperty("Body", parseInt(i+5), "edittype", "none");
			grd_stoclist.setCellProperty("Body", parseInt(i+5), "align", "center middle");
		}
		
		var sCol = grd_stoclist.appendContentsCol();
		grd_stoclist.setCellProperty("Head", sCol, "text", "합계");
		grd_stoclist.setCellProperty("Body", parseInt(i+5), "text", "bind:total");
		grd_stoclist.setFormatColProperty(sCol, "size", 45);
		grd_stoclist.setCellProperty("Body", sCol, "displaytype", "number");
		grd_stoclist.setCellProperty("Body", sCol, "edittype", "none");
		grd_stoclist.setCellProperty("Body", sCol, "align", "center middle");
	}
	
	cnt++;
}

function grp_sea_rdo_goodflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	if(obj.value == "1") 
	{
		grp_sea.ipt_goodcd.visible = true;
		grp_sea.ipt_goodnm.visible = false;
		grp_sea.ipt_goodnm.value= "";
	}
	else 
	{
		grp_sea.ipt_goodcd.visible = false;
		grp_sea.ipt_goodcd.value= "";
		grp_sea.ipt_goodnm.visible = true
	}
}

function grp_sea_ipt_goodnm_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		grp_sea.btn_search();
	}
}

function grp_sea_ipt_goodcd_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		grp_sea.btn_search.click();
	}
}

function grp_sea_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	var name = "수술방안전재고조회"
	
	grdf_exportExcel(grd_stoclist, name, "SheetName", "true", "", "");
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fSearch();
}
]]></Script>
  </Form>
</FDL>