YNU_JEUS/app_home/himed/xpapps/mis/stocsumxp/xp/SMRST03400_가중평균가용 입고내역조회.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRST03300" position="absolute 0 0 1000 700" titletext="가중평균가용 입고내역조회(약품)" onload="SMRST03300_onload">
    <Layouts>
      <Layout>
        <Div id="group4" taborder="1" scrollbars="none" position="absolute 0 20 907 47">
          <Layouts>
            <Layout>
              <Button id="btn_print" taborder="2" text="출력" onclick="group4_btn_print_onclick" class="btn6" position="absolute 0 3 60 25" visible="false"/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group1" taborder="2" scrollbars="none" position="absolute 0 0 1000 21">
          <Layouts>
            <Layout>
              <Static id="caption6" text="가중평균가용 입고내역조회" class="tit_1" position="absolute 0 0 189 22"/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group6" taborder="3" style="align: top;" class="div_SA" position="absolute 0 52 987 113">
          <Layouts>
            <Layout>
              <Button id="btn_search" taborder="37" text="조회" class="btn1" position="absolute 916 20 972 42" style="align:left ;" anchor="default" onclick="group6_btn_search_onclick"/>
              <Shape id="line14" linetype="vertical" class="line_4" position="absolute 901 9 904 52" style="border:1 solid #ffe4bb #ffe4bb;" anchor="default"/>
              <Static id="caption10" text="기관코드 :" class="search_name" position="absolute 15 9 112 26" anchor="default"/>
              <Static id="caption4" text="작업년월 :" class="search_name" position="absolute 15 36 101 53" anchor="default"/>
              <Static id="caption7" text="부     서 :" class="search_name" position="absolute 382 9 475 26" anchor="default"/>
              <Calendar id="ipt_frdd" taborder="39" autoselect="true" dateformat="yyyy-MM" editformat="yyyy-MM" onkillfocus="group5_group6_ipt_frdd_onkillfocus" class="input_essential" position="absolute 100 35 205 54" style="align:center middle;" mask="yyyy-mm" anchor="default"/>
              <Calendar id="ipt_todd" taborder="40" autoselect="true" dateformat="yyyy-MM" editformat="yyyy-MM" class="input_essential" position="absolute 228 35 333 54" style="align:center middle;" mask="yyyy-mm" anchor="default"/>
              <Static id="caption11" text="~" class="search_n_b" position="absolute 212 38 224 55" style="font:,,bolder;" anchor="default"/>
              <Edit id="ipt_goodcd" taborder="43" onkillfocus="group6_ipt_goodcd_onkillfocus" class="input_essential" position="absolute 467 35 546 54" anchor="default" onkeydown="group6_ipt_goodcd_onkeydown"/>
              <Static id="caption1" text="약품코드 :" class="search_name" position="absolute 382 36 477 53" anchor="default"/>
              <Combo id="cmb_deptcd" taborder="45" innerdataset="@ds_init_cmb_deptcd_deptcdlist" codecolumn="deptcd" datacolumn="deptnm" class="combo_essential" position="absolute 467 10 620 29" style="align:center ;" columncount="-1" rowcount="-1" anchor="default" onitemchanged="group6_cmb_deptcd_onitemchanged"/>
              <Edit id="opt_goodflag" taborder="46" readonly="true" visible="false" position="absolute 622 10 722 30" anchor="default"/>
              <Edit id="opt_instcd" taborder="47" readonly="true" class="output" visible="false" position="absolute 316 9 336 28" anchor="default"/>
              <Edit id="opt_instcdnm" taborder="48" readonly="true" class="output" position="absolute 100 8 250 27" anchor="default"/>
              <Static id="caption00" text="약품명 :" class="search_name" position="absolute 554 35 649 52" anchor="default"/>
              <Edit id="ipt_goodnm" taborder="49" onkillfocus="group5_group6_ipt_goodnm_onkillfocus" onkeydown="group5_group6_ipt_goodnm_onkeydown" class="input_fix" position="absolute 617 35 784 54" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption21" text="입고내역" class="tit_2" position="absolute 5 122 193 143"/>
        <Shape id="line1" class="line_1" position="absolute 0 139 988 142" style="strokepen:5 solid #33bbbbff;"/>
        <Grid id="grd_win" taborder="4" binddataset="ds_main_list_goodwin" useinputpanel="false" position="absolute 0 143 988 665">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="72"/>
                <Column size="44"/>
                <Column size="40"/>
                <Column size="68"/>
                <Column size="52"/>
                <Column size="64"/>
                <Column size="73"/>
                <Column size="120"/>
                <Column size="116"/>
                <Column size="82"/>
                <Column size="167"/>
                <Column size="71"/>
              </Columns>
              <Rows>
                <Row size="25" band="head"/>
                <Row size="25"/>
              </Rows>
              <Band id="head">
                <Cell text="입고일자"/>
                <Cell col="1" text="번호"/>
                <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="입고부서"/>
              </Band>
              <Band id="body">
                <Cell displaytype="date" edittype="date" text="bind:windd" calendardisplaynulltype="none"/>
                <Cell col="1" displaytype="text" edittype="none" style="align:center middle;" text="bind:winno"/>
                <Cell col="2" displaytype="text" edittype="none" style="align:center middle;" text="bind:winseqno"/>
                <Cell col="3" text="bind:iokindnm"/>
                <Cell col="4" displaytype="number" style="align:right middle;" text="bind:winqty"/>
                <Cell col="5" displaytype="number" style="align:right middle;" text="bind:winunitcost"/>
                <Cell col="6" displaytype="number" style="align:right middle;" text="bind:winamt"/>
                <Cell col="7" text="bind:suplplcenm"/>
                <Cell col="8" text="bind:subsuplplcenm"/>
                <Cell col="9" text="bind:goodcd"/>
                <Cell col="10" style="align:left;" text="bind:goodnm" tooltiptext="bind:goodnm"/>
                <Cell col="11" text="bind:windeptnm"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_init" taborder="5" text="초기화" onclick="group4_btn_init_onclick" class="btn4" position="absolute 919 27 987 49"/>
        <Shape id="line4" class="line_6" position="absolute 4 49 983 52"/>
        <Button id="btn_print00" taborder="6" text="엑셀저장" onclick="group4_btn_print_onclick" class="btn2" visible="true" position="absolute 919 116 987 138"/>
        <MaskEdit id="output2" taborder="7" mask="###,###,##0" enable="false" position="absolute 232 670 369 690"/>
        <MaskEdit id="output1" taborder="8" mask="###,###,##0" enable="false" position="absolute 88 670 225 690"/>
        <Static id="caption16" text="입고합계" class="cell_1" position="absolute 0 668 85 691" style="align: middle;"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_goodiolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="goodflag" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="goodcd" type="STRING" size="256"/>
          <Column id="goodnm" type="STRING" size="256"/>
          <Column id="goodspec" type="STRING" size="256"/>
          <Column id="goodmodel" type="STRING" size="256"/>
          <Column id="prodcmpynm" type="STRING" size="256"/>
          <Column id="iofrdd" type="STRING" size="256"/>
          <Column id="iotodd" type="STRING" size="256"/>
          <Column id="stocym" type="STRING" size="256"/>
          <Column id="lrgcd" type="STRING" size="256"/>
          <Column id="lrgnm" type="STRING" size="256"/>
          <Column id="flag" type="STRING" size="256"/>
          <Column id="instnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="goodflag"/>
            <Col id="deptcd"/>
            <Col id="goodcd"/>
            <Col id="goodnm"/>
            <Col id="goodspec"/>
            <Col id="goodmodel"/>
            <Col id="prodcmpynm"/>
            <Col id="iofrdd"/>
            <Col id="iotodd"/>
            <Col id="stocym"/>
            <Col id="lrgcd"/>
            <Col id="lrgnm"/>
            <Col id="flag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_cmb_deptcd_deptcdlist" 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="deptnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_list_goodwin" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="windd" type="STRING" size="256"/>
          <Column id="winno" type="STRING" size="256"/>
          <Column id="winseqno" type="STRING" size="256"/>
          <Column id="iokindnm" type="STRING" size="256"/>
          <Column id="winqty" type="STRING" size="256"/>
          <Column id="winunitcost" type="STRING" size="256"/>
          <Column id="winamt" type="STRING" size="256"/>
          <Column id="suplplcenm" type="STRING" size="256"/>
          <Column id="subsuplplcenm" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="windeptnm" type="STRING" size="256"/>
          <Column id="goodnm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_inpt_info" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="winqty" type="STRING" size="256"/>
          <Column id="winamt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item9" compid="group6.opt_goodflag" propid="value" datasetid="ds_send_goodiolist" columnid="goodflag"/>
      <BindItem id="item5" compid="group6.opt_instcd" propid="value" datasetid="ds_send_goodiolist" columnid="instcd"/>
      <BindItem id="item0" compid="group6.opt_instcdnm" propid="value" datasetid="ds_send_goodiolist" columnid="instnm"/>
      <BindItem id="item1" compid="group6.ipt_todd" propid="value" datasetid="ds_send_goodiolist" columnid="iotodd"/>
      <BindItem id="item2" compid="group6.ipt_frdd" propid="value" datasetid="ds_send_goodiolist" columnid="iofrdd"/>
      <BindItem id="item3" compid="group6.cmb_deptcd" propid="value" datasetid="ds_send_goodiolist" columnid="deptcd"/>
      <BindItem id="item4" compid="group6.ipt_goodcd" propid="value" datasetid="ds_send_goodiolist" columnid="goodcd"/>
      <BindItem id="item6" compid="group6.ipt_goodnm" propid="value" datasetid="ds_send_goodiolist" columnid="goodnm"/>
      <BindItem id="item12" compid="output2" propid="value" datasetid="ds_inpt_info" columnid="winamt"/>
      <BindItem id="item10" compid="output1" propid="value" datasetid="ds_inpt_info" columnid="winqty"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-06-19
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
include "mis_miscommonxp::RSZ001.xjs";


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


//전체에서 event와 src를 제외한  script 를 모두포함.

// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
function fInitialize() {	

	//rszfUserGoodFlagList(cmb_goodflag,sysf_getUserInfo("userid"));
	//hidden col
	// [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH) 
	ds_send_goodiolist.setColumn(0,"goodflag", "PH");
	
	//rszfUserInstList(group6.cmb_instcd,sysf_getUserInfo("userid"));
	ds_send_goodiolist.setColumn(0,"instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_send_goodiolist.setColumn(0,"instnm", sysf_getUserInfo("dutplceinstnm"));
	
	rszfComboStockArthDeptcdList("group6.cmb_deptcd",sysf_getUserInfo("dutplceinstcd"),group6.opt_goodflag.value );
	
	ds_init_cmb_deptcd_deptcdlist.insertRow(0);	
	ds_init_cmb_deptcd_deptcdlist.setColumn(0,"deptnm", "-전 체-");
	ds_init_cmb_deptcd_deptcdlist.setColumn(0,"deptcd", "");
	
	ds_send_goodiolist.setColumn(0, "deptcd", "");

	if(ds_init_cmb_deptcd_deptcdlist.rowcount == 1){
		ds_send_goodiolist.setColumn( 0, "deptcd",ds_init_cmb_deptcd_deptcdlist.getColumn(0,"deptcd"));
	}

	var curdate = utlf_getCurrentDate().substring(0,6);

	group6.ipt_frdd.value = curdate;
	group6.ipt_todd.value = curdate;
	
}

function fRetrevie()
{
	if(fCheckRetrieveData() == false)return;
	
	ds_send_goodiolist.setColumn(0,"iofrdd",ds_send_goodiolist.getColumn(0,"iofrdd").substring(0,6));
	ds_send_goodiolist.setColumn(0,"iotodd",ds_send_goodiolist.getColumn(0,"iotodd").substring(0,6));
	ds_send_goodiolist.setColumn(0, "flag", "insearch");
	
	
	var oParam = {};
		oParam.id          = "TRRST01302";
		oParam.service     = "stocsumapp.StocSumMngt";
		oParam.method      = "reqGetGoodStocByWin";
		oParam.inds        = "req=ds_send_goodiolist";
		oParam.outds       = "ds_main_list_goodwin=goodwinlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRST01302";

	tranf_submit(oParam);
	
	 var winqty   = 0;
	 var winamt   = 0; 
	
	 for(var k =0; k <ds_main_list_goodwin.rowcount;k++){ 		 
		 winqty 	 = winqty+parseFloat(ds_main_list_goodwin.getColumn(k,"winqty"));
		 winamt 	 = winamt+parseFloat(ds_main_list_goodwin.getColumn(k,"winamt"));		 
		 
	 }
	 ds_inpt_info.setColumn(0, "winqty", winqty);
	 ds_inpt_info.setColumn(0, "winamt", winamt);
}


function fCheckRetrieveData()
{	
	if(utlf_isNull(group6.ipt_frdd.value))
	{
		group6.ipt_frdd.setFocus();
		return false;
	}	

	if(utlf_isNull(group6.ipt_todd.value))
	{
		group6.ipt_todd.setFocus();
		return false;
	}	

}


function group6_btn_searchgoodcd_onclick(obj:Button, e:ClickEventInfo) {

//							if (submit("TRRSD00192") == true) {
	var oParam = {};
    oParam.id          = "TRRSD00192";
    oParam.service     = "purccommonapp.PurcCommon";
    oParam.method      = "reqGetPhamGoodListByCond";
    oParam.inds        = "req=ds_send_goodiolist";
    oParam.outds       = "ds_init_main_goodlist=goodlist";
    oParam.async       = false;
    oParam.callback    = "cf_TRRSD00192";

	tranf_submit(oParam);
}

function cf_TRRSD00192(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;

    ds_init_main_goodlist.addColumn("goodspec","string");
    ds_init_main_goodlist.addColumn("goodmodel","string");
    ds_init_main_goodlist.addColumn("prodcmpynm","string");
    
	var nodecnts = ds_init_main_goodlist.rowcount;

	if (nodecnts >=  2) {
		group5.group2.visible = true;
	} else if (nodecnts == 1) {

		var goodcd 			= ds_init_main_goodlist.getColumn(0, "goodcd");
		var goodnm 			= ds_init_main_goodlist.getColumn(0, "goodnm");
		var goodspec 		= ds_init_main_goodlist.getColumn(0, "goodspec");
		var goodmodel 		= ds_init_main_goodlist.getColumn(0, "goodmodel");
		var prodcmpynm 	= ds_init_main_goodlist.getColumn(0, "prodcmpynm");

		dsf_makeValue( ds_send_goodiolist, "goodcd", "string",  goodcd)
		dsf_makeValue( ds_send_goodiolist, "goodnm", "string",  goodnm)
		dsf_makeValue( ds_send_goodiolist, "goodspec", "string",  goodspec)
		dsf_makeValue( ds_send_goodiolist, "goodmodel", "string",  goodmodel)
		dsf_makeValue( ds_send_goodiolist, "prodcmpynm", "string",  prodcmpynm)

	} else { 
		sysf_messageBox("검색된 코드가 없습니다.", "I");
	}

}

function group6_ipt_goodcd_onkeydown(obj:Edit, e:KeyEventInfo) {

	if (e.keyCode == 13)
	{
		group6.ipt_goodcd.value = group5.group6.ipt_goodcd.text;

		group6.btn_search.click();
	}

}

function group6_ipt_goodnm_onkillfocus(obj:Edit, e:KillFocusEventInfo) {

	if(group6.ipt_goodnm.value.length == 0) 
	{
		group6.ipt_goodcd.value = "";		
	}
	else {
		ds_send_goodiolist.setColumn( 0, "goodcd"				,  "")								
		ds_send_goodiolist.setColumn( 0, "flag", "N");
		group6.btn_searchgoodcd.dispatch("DOMActivate");
//								submit("TRRSD00192");
	}
//								rszfValidationCheck("TRRSD00191", "goodlist" , "refcond,instcd,goodflag,goodnm",
//												"goodnm," + model.getValue(group5.group6.cmb_instcd.attribute("ref")) + "," + model.getValue(group5.group6.opt_goodflag.attribute("ref")) + "," +  model.getValue(group5.group6.ipt_goodnm.attribute("ref")) ,"","goodcd,goodnm,goodspec,goodmodel,prodcmpynm",
//												ipt_goodcd,"SPRSD00210","instcd,goodflag,goodnm","cmb_instcd,group5.group6.opt_goodflag,ipt_goodnm","Y");

//model.refresh();

}

function group6_ipt_goodnm_onkeydown(obj:Edit, e:KeyEventInfo) {

	if (event.keyCode == 13)
	{
		group6.ipt_goodnm.value = group5.group6.ipt_goodnm.text;

//group5.group6.ipt_goodnm.refresh();

		group6.ipt_goodnm.dispatch("xforms-value-changed");
	}

}

function group6_ipt_goodcd_onkeyup(obj:Edit, e:KeyEventInfo)
{
		if(utlf_isNull(group6.ipt_goodcd.value)) 
	{
		group6.ipt_goodnm.value = "";
	}
	else {
		ds_send_goodiolist.setColumn( 0, "goodnm"				,  "")								
		ds_send_goodiolist.setColumn( 0, "flag", "C");
		group6.btn_search.click();
//								rszfValidationCheck("TRRSD00191", "goodlist" , "refcond,instcd,goodflag,goodcd,goodnm,indexgb,indexnm",
//												"goodcd," + model.getValue(group5.group6.cmb_instcd.attribute("ref")) + "," +model.getValue(group5.group6.opt_goodflag.attribute("ref")) + "," +  model.getValue(group5.group6.ipt_goodcd.attribute("ref")) + ",,,," ,"","goodcd,goodnm,goodspec,goodmodel,prodcmpynm",
//												ipt_goodcd,"SPRSD00210","instcd,goodflag,goodcd","cmb_instcd,group5.group6.opt_goodflag,ipt_goodcd" ,"Y");
	}

}

function group6_cmb_deptcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	
}

function group6_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fRetrevie();
}

function group6_ipt_goodcd_onkillfocus(obj:Edit, e:KillFocusEventInfo)
{
	
}



function group5_group6_btn_searchgoodcd_onclick(obj:Button,  e:ClickEventInfo)
{
		var oParam = {};
    oParam.id          = "TRRSD00192";
    oParam.service     = "purccommonapp.PurcCommon";
    oParam.method      = "reqGetPhamGoodListByCond";
    oParam.inds        = "req=ds_send_goodiolist";
    oParam.outds       = "ds_init_main_goodlist=goodlist";
    oParam.async       = false;
    oParam.callback    = "cf_TRRSD00192";

	tranf_submit(oParam);
}

function group4_btn_print_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_win, "가중평균가용입고내역", "가중평균가용입고내역1", "true", "", "");
}
]]></Script>
  </Form>
</FDL>