YNU_JEUS/app_home/himed/xpapps/ast/pharmacydrugsumxp/xp/SMADT12170_마약류현재고조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMADT12170" classname="SMADT12170_마약류현재고조회" inheritanceid="" position="absolute 0 0 1200 780" titletext="마약류 현재고 조회" onload="SMADT12170_onload" oninit="SMADT12170_oninit">
    <Layouts>
      <Layout>
        <Static id="caption6" text="마약류 현재고 조회" class="tit_1" position="absolute 0 0 150 25"/>
        <Div id="grp_search" anchor="left top right" taborder="1" class="div_SA" position="absolute 0 50 1195 85">
          <Layouts>
            <Layout>
              <Static id="caption2" text="저장소 :" class="search_name" position="absolute 21 10 83 27" anchor="default"/>
              <Button id="btn_search" taborder="58" text="조회" class="btn1" position="absolute 896 7 952 29" anchor="default" onclick="grp_search_btn_search_onclick"/>
              <Combo id="cmb_storge_no" taborder="61" innerdataset="@ds_storgelist" codecolumn="storge_no" datacolumn="storge_nonm" class="combo_default" position="absolute 85 8 227 27"/>
              <Static id="caption03" text="약품코드 :" class="search_name" position="absolute 413 10 488 27"/>
              <Edit id="ipt_gtin" taborder="62" autoselect="true" class="input_search" position="absolute 795 13 888 32" visible="false"/>
              <Button id="btn_gtin" taborder="63" class="icon_search" position="absolute 586 10 602 26" onclick="grp_search_btn_gtin_onclick"/>
              <Edit id="opt_hngnm" taborder="64" readonly="true" autoselect="true" class="output" position="absolute 607 9 880 28"/>
              <Edit id="ipt_drugcd" taborder="68" autoselect="true" class="input_search" position="absolute 489 9 582 28" inputmode="upper" imemode="alpha" onkeydown="grp_search_ipt_drugcd_onkeydown"/>
              <Static id="caption05" text="관리구분 :" class="search_name" position="absolute 246 10 321 27"/>
              <Combo id="cmb_prtm_se_nm" taborder="69" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_search" position="absolute 324 8 395 27">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn"/>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">중점</Col>
                      <Col id="datacolumn">중점</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">일반</Col>
                      <Col id="datacolumn">일반</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption01" text="현재고" class="tit_2" position="absolute -1 99 170 120"/>
        <Grid id="grd_stoclist" taborder="17" boutddataset="ds_stoclist" autoenter="select" useinputpanel="false" selecttype="row" cellsizingtype="both" position="absolute 0 121 1195 768" anchor="all" binddataset="ds_stoclist">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="70"/>
                <Column size="83"/>
                <Column size="96"/>
                <Column size="260"/>
                <Column size="51"/>
                <Column size="44"/>
                <Column size="132"/>
                <Column size="39"/>
              </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" colspan="2" text="낱개단위 수" taborder="undefined"/>
                <Cell col="7" text="유통단위별 낱개수량"/>
                <Cell col="8" text="구분"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow+1"/>
                <Cell col="1" style="align:left;" text="bind:storge_nm"/>
                <Cell col="2" style="align:left;" text="bind:drugcd"/>
                <Cell col="3" text="bind:gtin"/>
                <Cell col="4" style="align:left;" text="bind:hngnm"/>
                <Cell col="5" displaytype="normal" edittype="none" editfilter="number" style="align:center;" text="bind:pce_qy" editautoselect="true"/>
                <Cell col="6" text="bind:prd_pce_unit"/>
                <Cell col="7" text="bind:trans_unit"/>
                <Cell col="8" text="bind:prtm_se_nm"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line7" class="line_10" position="absolute 0 116 1195 122" anchor="left top right"/>
        <Div id="grp_button" anchor="left top right" taborder="40" position="absolute 0 13 1195 45">
          <Layouts>
            <Layout>
              <Shape id="line2" class="line_6" position="absolute 0 25 1195 31" anchor="left top right"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_download" taborder="41" text="엑셀 Download" class="btn2" position="absolute 1087 96 1195 115" anchor="top right" onclick="btn_download_onclick"/>
      </Layout>
    </Layouts>
    <Bind>
      <BindItem id="item12" compid="SMADT12170" propid="text" datasetid="ds_main_prntlist_patinfo" columnid=""/>
      <BindItem id="item0" compid="grp_search.cmb_storge_no" propid="value" datasetid="ds_send_search" columnid="storge_no"/>
      <BindItem id="item5" compid="grp_search.ipt_gtin" propid="value" datasetid="ds_send_search" columnid="gtin"/>
      <BindItem id="item22" compid="grp_search.opt_hngnm" propid="value" datasetid="ds_send_search" columnid="hngnm"/>
      <BindItem id="item2" compid="grp_search.ipt_drugcd" propid="value" datasetid="ds_send_search" columnid="drugcd"/>
      <BindItem id="item26" compid="grp_search.cmb_prtm_se_nm" propid="value" datasetid="ds_send_search" columnid="prtm_se_nm"/>
    </Bind>
    <Objects>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_search_oncolumnchanged">
        <ColumnInfo>
          <Column id="indd_from" type="STRING" size="256"/>
          <Column id="indd_to" type="STRING" size="256"/>
          <Column id="storge_no" type="STRING" size="256" sumtext="연도"/>
          <Column id="prtm_se_nm" type="STRING" size="256"/>
          <Column id="gtin" type="STRING" size="256"/>
          <Column id="hngnm" type="STRING" size="256"/>
          <Column id="outdd" type="STRING" size="256"/>
          <Column id="drugcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_storgelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="storge_no" type="STRING" size="256"/>
          <Column id="storge_nm" type="STRING" size="256"/>
          <Column id="storge_nonm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_stoclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_stoclist_oncolumnchanged">
        <ColumnInfo>
          <Column id="gtin" type="STRING" size="256"/>
          <Column id="prd_pce_unit" type="STRING" size="256"/>
          <Column id="pce_qy" type="STRING" size="256"/>
          <Column id="trans_unit" type="STRING" size="256"/>
          <Column id="prtm_se_nm" type="STRING" size="256"/>
          <Column id="hngnm" type="STRING" size="256"/>
          <Column id="drugcd" type="STRING" size="256"/>
          <Column id="storge_nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_temp_receivedata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="receiveref" type="STRING" size="256"/>
          <Column id="receive_drugcd" type="STRING" size="256"/>
          <Column id="receive_hngnm" type="STRING" size="256"/>
          <Column id="receive_gtin" type="STRING" size="256"/>
          <Column id="receive_prtm_se_nm" type="STRING" size="256"/>
          <Column id="receive_prd_min_distb_qy" type="STRING" size="256"/>
          <Column id="receive_prd_min_distb_unit" type="STRING" size="256"/>
          <Column id="receive_prd_tot_pce_qy" type="STRING" size="256"/>
          <Column id="receive_prd_pce_unit" type="STRING" size="256"/>
          <Column id="basedd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************
 * System Name		:	경대 의료정보시스템
 * Job Name 		:	ast_pharmacydrugsumxp-> SMADT12170
 * Creator			:	pjb
 * Make Date 		:	2018-04-11
 * Description		:	
 *---------------------------------------------------------------------------------------
 * Modify Date		Modifier		Modify Description
 *---------------------------------------------------------------------------------------
 * 2018-04-11		pjb				XP개발
 * 
 *---------------------------------------------------------------------------------------
 ****************************************************************************************/


//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
//include "mis_miscommonxp::MIS.xjs";
//include "mis_humtrafactmngtxp::RPB001.xjs";

//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------
var arErrorCode 	= new HashArray();


//=======================================================================================
// Function
//---------------------------------------------------------------------------------------


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

/****************************************************************************************
 * Components		: Form
 * Components ID	: SMADT12170
 * Event			: onload
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 화면 로딩 완료시
 ****************************************************************************************/
function SMADT12170_onload(obj:Form, e:LoadEventInfo)
{
	//grdf_setRowTypeIcon(grd_stoclist, 0);
	grdf_setGridSort(grd_stoclist);

	//ds_movinfo.setColumn(0, "status", "i"); // 작업구분(i, u, d)
	
	//저장소 목록 조회
	var oParam = {};
		oParam.id          = "TRADT12112";
		oParam.service     = "pharmacydrugsumapp.NarcManagent";
		oParam.method      = "reqGetStorgeList";
		oParam.inds        = "req=";
		oParam.outds       = "ds_storgelist=storgelist";
		oParam.async       = false;
	//	oParam.callback    = "cf_TRADT12112";

	tranf_submit(oParam);
	
	//frmf_addComboItem("grp_search.cmb_storge_no","전체","","above");
	ds_send_search.setColumn(0, "storge_no", "S0001");  //default setting : S0001 기본저장소
	ds_send_search.setColumn(0, "prtm_se_nm", "");  //default setting : 관리구분
		
	grp_search.cmb_storge_no.setFocus(); 

}



/****************************************************************************************
 * Components		: Button
 * Components ID	: grp_search_btn_search
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 조회버튼 클릭시
 ****************************************************************************************/
function grp_search_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{	
	
	//현재고 조회
	var oParam = {};
		oParam.id          = "TRADT12171";
		oParam.service     = "pharmacydrugsumapp.NarcManagent";
		oParam.method      = "reqGetPrdStocList";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "ds_stoclist=stoclist";
		oParam.async       = false;
		oParam.callback    = "cf_TRADT12171";

	tranf_submit(oParam);	
	
	
	if (arErrorCode.pop("TRADT12171") > -1){
	
	}
	
}

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

/****************************************************************************************
 * Components		: Dataset
 * Components ID	: ds_send_search
 * Event			: oncolumnchanged
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 컬럼의 값 변경시
 ****************************************************************************************/
function ds_send_search_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "indd_from" || e.columnid == "indd_to" || e.columnid == "storge_no" || e.columnid == "prtm_se_nm" ) {

		//Grid Clear
		ds_stoclist.clearData();
	}
	else if(e.columnid == "drugcd") {
		if(e.newvalue != e.oldvalue) {
			obj.setColumn(0, "hngnm", "");
			obj.setColumn(0, "gtin", "");
		}
	}

}

/****************************************************************************************
 * Components		: Button
 * Components ID	: btn_gtin
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 제품코드 버튼 Click시
 ****************************************************************************************/
function grp_search_btn_gtin_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_temp_receivedata.setColumn(0,"receiveref","ds_send_search");
	ds_temp_receivedata.setColumn(0,"receive_drugcd","drugcd");
	ds_temp_receivedata.setColumn(0,"receive_hngnm","hngnm");
	ds_temp_receivedata.setColumn(0,"receive_gtin","gtin");
	ds_temp_receivedata.setColumn(0,"receive_prtm_se_nm",""); //prtm_se_nm
	ds_temp_receivedata.setColumn(0,"receive_prd_min_distb_qy","prd_min_distb_qy");
	ds_temp_receivedata.setColumn(0,"receive_prd_min_distb_unit","prd_min_distb_unit");
	ds_temp_receivedata.setColumn(0,"receive_prd_tot_pce_qy","prd_tot_pce_qy");
	ds_temp_receivedata.setColumn(0,"receive_prd_pce_unit","prd_pce_unit");
	ds_temp_receivedata.setColumn(0,"basedd",""); //utlf_getCurrentDate() //ds_send_search.getColumn(0, "indd_to")

	var objArg = new Object();
	objArg.arg_ds_temp_receivedata = ds_temp_receivedata;
	frmf_modal("SMADT12120","SMADT12120", objArg, "", "", 100, 150, "", "", "", "", "", "M");	

}

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

function btn_download_onclick(obj:Button,  e:ClickEventInfo)
{
	//조회된 자료가 없으면 먼저 조회하라고 message
	if(ds_stoclist.rowcount < 1) {
		sysf_messageBox("조회된 결과가 존재하지 않습니다. \n\n먼저 조회 후 Download 하십시요. ", "E999", "");							
		return;
	}
																							
	grdf_exportExcel(grd_stoclist, "excel", "savetype", false, "", "user", false);
	
}
]]></Script>
  </Form>
</FDL>