YNU_JEUS/app_home/himed/xpapps/ast/dietxp/xp/SMANB01000_식품별입출고현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMANB01000" position="absolute 0 0 1110 790" titletext="식품월재고마감처리" oninit="SMANB01000_oninit" onload="SMANB01000_onload">
    <Layouts>
      <Layout>
        <Static text="식품별 입출고 현황" position="absolute 0 0 147 23" id="caption6" class="tit_1"/>
        <Grid position="absolute 0 97 1090 775" id="grd_foodstocrsltlist" binddataset="ds_main_stocinfo_foodstocrsltlist" autofittype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="20" band="left"/>
                <Column size="100"/>
                <Column size="270"/>
                <Column size="70"/>
                <Column size="100"/>
                <Column size="70"/>
                <Column size="100"/>
                <Column size="70"/>
                <Column size="100"/>
                <Column size="70"/>
                <Column size="100"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="식품코드" taborder="undefined"/>
                <Cell col="2" rowspan="2" text="식품명" taborder="undefined"/>
                <Cell col="3" rowspan="2" text=" 이월수량" taborder="undefined"/>
                <Cell col="4" rowspan="2" text=" 전월이월금액" taborder="undefined"/>
                <Cell col="5" rowspan="2" text=" 입고수량" taborder="undefined"/>
                <Cell col="6" rowspan="2" text=" 입고금액" taborder="undefined"/>
                <Cell col="7" rowspan="2" text="출고수량" taborder="undefined"/>
                <Cell col="8" rowspan="2" text=" 출고금액" taborder="undefined"/>
                <Cell col="9" rowspan="2" text=" 재고수량" taborder="undefined"/>
                <Cell col="10" rowspan="2" text="재고금액" taborder="undefined"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="expr:currow + 1"/>
                <Cell col="1" text="bind:goodcd"/>
                <Cell col="2" style="align:left;" text="bind:goodnm"/>
                <Cell col="3" displaytype="number" style="align:center;" text="bind:beftotqty" mask="#,##0.##"/>
                <Cell col="4" displaytype="number" style="padding:0 10 0 0;" text="bind:beftotamt" mask="#,##0.##"/>
                <Cell col="5" displaytype="number" style="align:center;" text="bind:inputqty" mask="#,##0.##"/>
                <Cell col="6" displaytype="number" style="padding:0 10 0 0;" text="bind:inputamt" mask="#,##0.##"/>
                <Cell col="7" displaytype="number" style="align:center;" text="bind:outputqty" mask="#,##0.##"/>
                <Cell col="8" displaytype="number" style="padding:0 10 0 0;" text="bind:outputamt" mask="#,##0.##"/>
                <Cell col="9" displaytype="number" style="align:center;" text="bind:apptotqty" mask="#,##0.##"/>
                <Cell col="10" displaytype="number" style="padding:0 10 0 0;" text="bind:apptotamt" mask="#,##0.##"/>
              </Band>
              <Band id="summary">
                <Cell expr="expr:ds_main_stocinfo_foodstocrsltlist.rowcount + 1"/>
                <Cell col="1" style="font:arial,9,bold;" text="총계"/>
                <Cell col="2"/>
                <Cell col="3" displaytype="number" style="align:center;font:arial,9,bold;" expr="expr:getSum('beftotqty')" mask="#,##0.##"/>
                <Cell col="4" displaytype="number" style="align:center;font:arial,9,bold;" expr="expr:getSum('beftotamt')" mask="#,##0.##"/>
                <Cell col="5" displaytype="number" style="align:center;font:arial,9,bold;" expr="expr:getSum('inputqty')" mask="#,##0.##"/>
                <Cell col="6" displaytype="number" style="align:center;font:arial,9,bold;" expr="expr:getSum('inputamt')" mask="#,##0.##"/>
                <Cell col="7" displaytype="number" style="align:center;font:arial,9,bold;" expr="expr:getSum('outputqty')" mask="#,##0.##"/>
                <Cell col="8" displaytype="number" style="align:center;font:arial,9,bold;" expr="expr:getSum('outputamt')" mask="#,##0.##"/>
                <Cell col="9" displaytype="number" style="align:center;font:arial,9,bold;" expr="expr:getSum('apptotqty')" mask="#,##0.##"/>
                <Cell col="10" displaytype="number" style="align:center;font:arial,9,bold;" expr="expr:getSum('apptotamt')" mask="#,##0.##"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static text="식품별 리스트" position="absolute 0 75 140 95" id="caption18" class="tit_2"/>
        <Button position="absolute 1049 70 1091 92" id="button4" class="btn2" text="엑셀" onclick="button4_onclick"/>
        <Div position="absolute 0 20 1100 60" align="align:center top;" id="group3" class="div_SA">
          <Layouts>
            <Layout>
              <Static text="기관코드 :" position="absolute 5 11 84 28" id="caption17" class="search_name"/>
              <Edit readonly="true" position="absolute 85 10 115 29" id="output2" class="output"/>
              <Edit readonly="true" position="absolute 118 10 320 29" align="align:center middle;" id="output3" class="output"/>
              <Button position="absolute 1010 10 1066 32" id="button9" class="btn4" text="조회" onclick="group3_button9_onclick"/>
              <Static text="기간 :" position="absolute 355 12 406 29" id="caption19" class="search_name"/>
              <Calendar position="absolute 406 11 503 30" align="align:center middle;" id="input4" class="input_s_essential" mask="yyyy-mm" autoselect="true" editformat="yyyy-MM-dd" dateformat="yyyy-MM-dd" value="null" style="align:center middle;"/>
              <Shape position="absolute 987 5 993 33" linetype="vertical" id="line14" class="line_4"/>
              <Static text="~" position="absolute 511 11 523 28" id="caption11" class="search_no_b"/>
              <Calendar position="absolute 526 11 623 30" align="align:center middle;" id="input5" class="input_s_essential" mask="yyyy-mm" autoselect="true" editformat="yyyy-MM-dd" dateformat="yyyy-MM-dd" value="null" style="align:center middle;"/>
              <Static text="구분 :" position="absolute 685 12 740 29" id="caption1" class="search_name"/>
              <Radio position="absolute 738 11 872 30" id="rdo_diet" class="radio_search" columncount="4" rowcount="1" codecolumn="codecolumn" datacolumn="datacolumn">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">P</Col>
                      <Col id="datacolumn">환자식</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">E</Col>
                      <Col id="datacolumn">직원식</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
            </Layout>
          </Layouts>
        </Div>
        <Button position="absolute 985 70 1041 92" id="button13" class="btn6" text="출력" onclick="button13_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="fromdd" type="STRING" size="256" sumtext="시작년월"/>
          <Column id="todd" type="STRING" size="256" sumtext="종료년월"/>
          <Column id="pat_emp" type="STRING" size="256" sumtext="구분"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_stocinfo_foodstocrsltlist" 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="beftotqty" type="STRING" size="256" sumtext="이월수량"/>
          <Column id="beftotamt" type="STRING" size="256" sumtext="전월이월금액"/>
          <Column id="inputqty" type="STRING" size="256" sumtext="입고수량"/>
          <Column id="inputamt" type="STRING" size="256" sumtext="입고금액"/>
          <Column id="outputqty" type="STRING" size="256" sumtext="출고수량"/>
          <Column id="outputamt" type="STRING" size="256" sumtext="출고금액"/>
          <Column id="apptotqty" type="STRING" size="256" sumtext="재고수량"/>
          <Column id="apptotamt" type="STRING" size="256" sumtext="재고금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cond_srch2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_cond_srch2_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="instnm" type="STRING" size="256"/>
          <Column id="pat_emp" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group3.output2" propid="value" datasetid="ds_cond_srch2" columnid="instcd"/>
      <BindItem id="item1" compid="group3.output3" propid="value" datasetid="ds_cond_srch2" columnid="instnm"/>
      <BindItem id="item2" compid="group3.input4" propid="value" datasetid="ds_cond_srch2" columnid="fromdd"/>
      <BindItem id="item3" compid="group3.input5" propid="value" datasetid="ds_cond_srch2" columnid="todd"/>
      <BindItem id="item4" compid="group3.rdo_diet" propid="value" datasetid="ds_cond_srch2" columnid="pat_emp"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************
 * System Name		:	경대 의료정보시스템
 * Job Name 		:	ast_dietxp -> SMANB01000
 * Creator			:	yjh
 * Make Date 		:	2017-10-26
 * Description		:	
 *---------------------------------------------------------------------------------------
 * Modify Date		Modifier		Modify Description
 *---------------------------------------------------------------------------------------
 * 2017-10-26		yjh				TF->XP
 * 
 *---------------------------------------------------------------------------------------
 ****************************************************************************************/


//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";


//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------



//=======================================================================================
// Function
//---------------------------------------------------------------------------------------
function saveGridToExcel(grdObj){
	grdf_exportExcel(grdObj, "excel", "SheetName", false, "", "user", false);
}


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

/****************************************************************************************
 * Components		: Form
 * Components ID	: SMANB01000
 * Event			: onload
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 화면 로딩 완료시
 ****************************************************************************************/
function SMANB01000_onload(obj:Form, e:LoadEventInfo)
{
	ds_main_stocinfo_foodstocrsltlist.clearData();
	
	ds_cond_srch2.setColumn(0, "instcd",	sysf_getUserInfo("dutplceinstcd"));   
	ds_cond_srch2.setColumn(0, "instnm",	sysf_getUserInfo("dutplceinstnm"));
	ds_cond_srch2.setColumn(0, "fromdd",	utlf_getCurrentDate().substring(0,8));
	ds_cond_srch2.setColumn(0, "todd",		utlf_getCurrentDate().substring(0,8));
	ds_cond_srch2.setColumn(0, "pat_emp", 	"P");
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: button4
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 엑셀버튼 클릭시
 ****************************************************************************************/
function button4_onclick(obj:Button,  e:ClickEventInfo)
{
	saveGridToExcel(grd_foodstocrsltlist);
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: button9
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 조회버튼 클릭시
 ****************************************************************************************/
function group3_button9_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_send_reqdata.setColumn(0, "instcd",	ds_cond_srch2.getColumn(0, "instcd"));
	ds_send_reqdata.setColumn(0, "fromdd",	ds_cond_srch2.getColumn(0, "fromdd"));
	ds_send_reqdata.setColumn(0, "todd",	ds_cond_srch2.getColumn(0, "todd"));
	ds_send_reqdata.setColumn(0, "pat_emp",	ds_cond_srch2.getColumn(0, "pat_emp"));
	
	var oParam = {};
		oParam.id          = "TRANB01001";
		oParam.service     = "dietsumapp.DietSum";
		oParam.method      = "reqGetFoodInOutTocm";
		oParam.inds        = "req=ds_send_reqdata";
		oParam.outds       = "ds_main_stocinfo_foodstocrsltlist=foodstocrsltlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRANB01001";

	tranf_submit(oParam);
	
	dsf_setTypeFormat(ds_main_stocinfo_foodstocrsltlist, "beftotqty:BIGDECIMAL^beftotamt:BIGDECIMAL^inputqty:BIGDECIMAL^inputamt:BIGDECIMAL^outputqty:BIGDECIMAL^outputamt:BIGDECIMAL^apptotqty:BIGDECIMAL^apptotamt:BIGDECIMAL");
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: button13
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 출력버튼 클릭시
 ****************************************************************************************/
function button13_onclick(obj:Button,  e:ClickEventInfo)
{
	var objDOM = rptf_createDOM();				                													// DOM 객체 설정	
	rptf_setNodeListToDOM(objDOM, "/root/main/stocinfo/foodstocrsltlist", ds_main_stocinfo_foodstocrsltlist);									// 데이터셋 1
	
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source;													// 최상의노드 XML 스트링 추출
		
	var option = "open=1;save=1;directprint=0;print=1;zoom=0;";
	
	rptf_exeReportPreview30(["RPANB01001"],[objParam], option);
}

function ds_cond_srch2_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	switch( e.columnid ){
		case "fromdd" :
		case "todd" :
			obj.setColumn(e.row, e.columnid, utlf_transNullToEmpty(e.newvalue).substr(0, 8));
			break;
			
		default :
			break;
	}
}
]]></Script>
  </Form>
</FDL>