YNU_JEUS/app_home/himed/xpapps/mis/stocsumxp/xp/SMRSG06600_식수단가 집계(영양).xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRSG06600" position="absolute 0 0 1211 767" titletext="식수단가 집계" onload="SMRSG06600_onload">
    <Layouts>
      <Layout>
        <Div id="group1" position="absolute 0 0 1195 29" style="">
          <Layouts>
            <Layout>
              <Static id="caption6" class="tit_1" position="absolute 0 0 189 22" style="" text="식수단가 집계" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group5" scrollbars="autoboth" position="absolute 0 46 1195 757" style="">
          <Layouts>
            <Layout>
              <Div id="group6" position="absolute 0 10 1195 45" style="align: top;" anchor="default">
                <Layouts>
                  <Layout>
                    <Shape id="roundrect3" anchor="default" type="roundrectangle" position="absolute 0 0 1195 35" style="border:1 solid #ffd799 #ffd799;background:#fffbf2  ;"/>
                    <Static id="caption4" class="search_name" position="absolute 226 9 312 26" style="" text="조회년월 :" anchor="default"/>
                    <Static id="caption2" class="search_name" position="absolute 15 9 101 26" style="" text="기관코드 :" anchor="default"/>
                    <Button id="btn_search" class="btn1" position="absolute 1125 7 1181 29" style="" text="조회" onclick="group5_group6_btn_search_onclick" anchor="default"/>
                    <Shape id="line13" class="line_4" linetype="vertical" position="absolute 1110 7 1113 29" style="border:1 solid #ffe4bb #ffe4bb;" anchor="default"/>
                    <Combo innerdataset="" datacolumn="" codecolumn="" columncount="-1" rowcount="-1" id="cmb_instcd" class="combo_search" position="absolute 100 8 200 27" style="" anchor="default"/>
                    <Calendar id="ipt_stocym" class="input_essential" mask="yyyy-mm" position="absolute 312 8 412 27" style="align:center ;" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" autoselect="true"/>
                    <Edit id="ipt_goodflag" visible="false" position="absolute 632 9 683 28" style="" anchor="default"/>
                    <Edit id="ipt_stocdeptcd" visible="false" position="absolute 688 8 732 27" style="" anchor="default"/>
                  </Layout>
                </Layouts>
              </Div>
              <Tab id="sw_flag" position="absolute 0 51 1195 706" style="" anchor="default">
                <Tabpages>
                  <Tabpage id="case_grdmonthpr" selected="true" anchor="default" text="월별 식수 단가 집계">
                    <Layouts>
                      <Layout>
                        <Shape id="line15" class="line_1" linetype="horizontal" position="absolute 0 30 1192 33" style="" anchor="default"/>
                        <Button id="button14" class="btn7" position="absolute 1140 9 1190 28" style="" text="엑셀" onclick="group5_sw_flag_case_grdmonthpr_button14_onclick" anchor="default"/>
                        <Grid id="grd_monthcostlist" binddataset="ds_main_list_monthcostlist" position="absolute 0 32 1194 624" style="" anchor="default">
                          <Formats>
                            <Format id="default">
                              <Columns>
                                <Column size="24"/>
                                <Column size="65"/>
                                <Column size="120"/>
                                <Column size="88"/>
                                <Column size="88"/>
                                <Column size="95"/>
                                <Column size="88"/>
                                <Column size="88"/>
                                <Column size="95"/>
                                <Column size="88"/>
                                <Column size="88"/>
                                <Column size="95"/>
                                <Column size="78"/>
                                <Column size="65"/>
                                <Column size="0"/>
                                <Column size="0"/>
                                <Column size="0"/>
                                <Column size="0"/>
                                <Column size="0"/>
                                <Column size="0"/>
                              </Columns>
                              <Rows>
                                <Row size="25" band="head"/>
                                <Row size="25" band="head"/>
                                <Row size="25"/>
                              </Rows>
                              <Band id="head">
                                <Cell/>
                                <Cell col="1" colspan="2" style="font:bold,9;" text="코드분류" taborder="undefined"/>
                                <Cell col="3" colspan="3" style="font:bold,9;" text="전년동월" taborder="undefined"/>
                                <Cell col="6" colspan="3" style="font:bold,9;" text="전월" taborder="undefined"/>
                                <Cell col="9" colspan="3" style="font:bold,9;" text="당월" taborder="undefined"/>
                                <Cell col="12" colspan="2" style="font:bold,9;" text="증감율" taborder="undefined"/>
                                <Cell col="14"/>
                                <Cell col="15" text="코드"/>
                                <Cell col="16" text="품명"/>
                                <Cell col="17" text="환자식"/>
                                <Cell col="18" text="직원식"/>
                                <Cell col="19" text="계"/>
                                <Cell col="20" text="환자식"/>
                                <Cell col="21" text="직원식"/>
                                <Cell col="22" text="계"/>
                                <Cell col="23" text="환자식"/>
                                <Cell col="24" text="직원식"/>
                                <Cell col="25" text="계"/>
                                <Cell col="26" text="전년동월대비"/>
                                <Cell col="27" text="전월대비"/>
                                <Cell col="28"/>
                                <Cell row="1"/>
                                <Cell row="1" col="1" style="font:bold,9;" text="코드"/>
                                <Cell row="1" col="2" style="font:bold,9;" text="품명"/>
                                <Cell row="1" col="3" style="font:bold,9;" text="환자식"/>
                                <Cell row="1" col="4" style="font:bold,9;" text="직원식"/>
                                <Cell row="1" col="5" style="font:bold,9;" text="계"/>
                                <Cell row="1" col="6" style="font:bold,9;" text="환자식"/>
                                <Cell row="1" col="7" style="font:bold,9;" text="직원식"/>
                                <Cell row="1" col="8" style="font:bold,9;" text="계"/>
                                <Cell row="1" col="9" style="font:bold,9;" text="환자식"/>
                                <Cell row="1" col="10" style="font:bold,9;" text="직원식"/>
                                <Cell row="1" col="11" style="font:bold,9;" text="계"/>
                                <Cell row="1" col="12" style="font:bold,9;" text="전년동월대비"/>
                                <Cell row="1" col="13" style="font:bold,9;" text="전월대비"/>
                                <Cell row="1" col="14"/>
                              </Band>
                              <Band id="body">
                                <Cell celltype="head"/>
                                <Cell col="1" style="align:left middle;" text="bind:lrgcd"/>
                                <Cell col="2" style="align:right middle;" text="bind:lrgnm"/>
                                <Cell col="3" displaytype="number" text="bind:befyearpat"/>
                                <Cell col="4" displaytype="number" text="bind:befyearemp"/>
                                <Cell col="5" displaytype="number" text="bind:befyeartot"/>
                                <Cell col="6" displaytype="number" text="bind:befmonpat"/>
                                <Cell col="7" displaytype="number" text="bind:befmonemp"/>
                                <Cell col="8" displaytype="number" text="bind:befmontot"/>
                                <Cell col="9" displaytype="number" text="bind:realmonpat"/>
                                <Cell col="10" displaytype="number" text="bind:realmonemp"/>
                                <Cell col="11" displaytype="number" text="bind:realmontot"/>
                                <Cell col="12" displaytype="number" text="bind:befyearodds"/>
                                <Cell col="13" displaytype="number" text="bind:befmonodds"/>
                                <Cell col="14" text="bind:instcd"/>
                              </Band>
                            </Format>
                          </Formats>
                        </Grid>
                      </Layout>
                    </Layouts>
                  </Tabpage>
                  <Tabpage id="case_grdcostpr" anchor="default" text="기간별 식수단가 집계">
                    <Layouts>
                      <Layout>
                        <Shape id="line1" class="line_1" linetype="horizontal" position="absolute 0 30 1194 33" style="" anchor="default"/>
                        <Button id="button1" class="btn7" position="absolute 1142 10 1195 29" style="" text="엑셀" onclick="group5_sw_flag_case_grdcostpr_button1_onclick" anchor="default"/>
                        <Grid id="grd_costlist" binddataset="ds_main_list_costlist" position="absolute 0 32 1195 626" style="" anchor="default">
                          <Formats>
                            <Format id="default">
                              <Columns>
                                <Column size="24"/>
                                <Column size="80"/>
                                <Column size="145"/>
                                <Column size="97"/>
                                <Column size="97"/>
                                <Column size="95"/>
                                <Column size="97"/>
                                <Column size="97"/>
                                <Column size="95"/>
                                <Column size="110"/>
                                <Column size="110"/>
                                <Column size="120"/>
                                <Column size="0"/>
                                <Column size="0"/>
                                <Column size="0"/>
                                <Column size="0"/>
                                <Column size="0"/>
                                <Column size="0"/>
                                <Column size="0"/>
                                <Column size="0"/>
                              </Columns>
                              <Rows>
                                <Row size="25" band="head"/>
                                <Row size="25" band="head"/>
                                <Row size="25"/>
                              </Rows>
                              <Band id="head">
                                <Cell rowspan="2" taborder="undefined"/>
                                <Cell col="1" colspan="2" style="font:bold,9;" text="코드분류" taborder="undefined"/>
                                <Cell col="3" colspan="3" style="font:bold,9;" text="전월" taborder="undefined"/>
                                <Cell col="6" colspan="3" style="font:bold,9;" text="당월" taborder="undefined"/>
                                <Cell col="9" colspan="3" style="font:bold,9;" text="기간별합계" taborder="undefined"/>
                                <Cell col="12"/>
                                <Cell col="13" text="코드"/>
                                <Cell col="14" text="품명"/>
                                <Cell col="15" text="환자식"/>
                                <Cell col="16" text="직원식"/>
                                <Cell col="17" text="계"/>
                                <Cell col="18" text="환자식"/>
                                <Cell col="19" text="직원식"/>
                                <Cell col="20" text="계"/>
                                <Cell col="21" text="환자식"/>
                                <Cell col="22" text="직원식"/>
                                <Cell col="23" text="계"/>
                                <Cell col="24"/>
                                <Cell row="1" col="1" style="font:bold,9;" text="코드"/>
                                <Cell row="1" col="2" style="font:bold,9;" text="품명"/>
                                <Cell row="1" col="3" style="font:bold,9;" text="환자식"/>
                                <Cell row="1" col="4" style="font:bold,9;" text="직원식"/>
                                <Cell row="1" col="5" style="font:bold,9;" text="계"/>
                                <Cell row="1" col="6" style="font:bold,9;" text="환자식"/>
                                <Cell row="1" col="7" style="font:bold,9;" text="직원식"/>
                                <Cell row="1" col="8" style="font:bold,9;" text="계"/>
                                <Cell row="1" col="9" style="font:bold,9;" text="환자식"/>
                                <Cell row="1" col="10" style="font:bold,9;" text="직원식"/>
                                <Cell row="1" col="11" style="font:bold,9;" text="계"/>
                                <Cell row="1" col="12"/>
                              </Band>
                              <Band id="body">
                                <Cell celltype="head"/>
                                <Cell col="1" style="align:left middle;" text="bind:lrgcd"/>
                                <Cell col="2" style="align:right middle;" text="bind:lrgnm"/>
                                <Cell col="3" displaytype="number" text="bind:befmonpat"/>
                                <Cell col="4" displaytype="number" text="bind:befmonemp"/>
                                <Cell col="5" displaytype="number" text="bind:befmontot"/>
                                <Cell col="6" displaytype="number" text="bind:realmonpat"/>
                                <Cell col="7" displaytype="number" text="bind:realmonemp"/>
                                <Cell col="8" displaytype="number" text="bind:realmontot"/>
                                <Cell col="9" displaytype="number" text="bind:totcostpat"/>
                                <Cell col="10" displaytype="number" text="bind:totcostemp"/>
                                <Cell col="11" displaytype="number" text="bind:totcosttot"/>
                                <Cell col="12" text="bind:instcd"/>
                              </Band>
                            </Format>
                          </Formats>
                        </Grid>
                      </Layout>
                    </Layouts>
                  </Tabpage>
                </Tabpages>
              </Tab>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group4" scrollbars="none" position="absolute 0 20 1195 47" style="">
          <Layouts>
            <Layout>
              <Button id="button34" class="btn6" visible="false" position="absolute 0 3 56 25" style="" text="출력" anchor="default"/>
              <Shape id="line17" class="line_6" linetype="horizontal" position="absolute 0 25 1195 28" style="" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" 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="stocym" type="STRING" size="256"/>
          <Column id="goodflag" type="STRING" size="256"/>
          <Column id="stocdeptcd" type="STRING" size="256"/>
          <Column id="avgwinamtlist" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="stocym"/>
            <Col id="goodflag"/>
            <Col id="stocdeptcd"/>
            <Col id="avgwinamtlist"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="temp" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="temp"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="hidden" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="monthcostlist" type="STRING" size="256"/>
          <Column id="costlist" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="monthcostlist"/>
            <Col id="costlist"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="init" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="init"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_monthcostlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_list_costlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group5.group6.cmb_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
      <BindItem id="item1" compid="group5.group6.ipt_stocym" propid="value" datasetid="ds_send" columnid="stocym"/>
      <BindItem id="item2" compid="group5.group6.ipt_goodflag" propid="value" datasetid="ds_send" columnid="goodflag"/>
      <BindItem id="item3" compid="group5.group6.ipt_stocdeptcd" propid="value" datasetid="ds_send" columnid="stocdeptcd"/>
    </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";

var RetrYn = "Y";
 
 function SMRSG06600_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	grdf_setRowTypeIcon(group5.sw_flag.case_grdmonthpr.grd_monthcostlist, 0);
	grdf_setRowTypeIcon(group5.sw_flag.case_grdcostpr.grd_costlist, 0);
	//grdf_initGrid(grd_XXX); 
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	//화면 Control을 초기화한다
	fInitialize();	

}

function fInitialize() {		

	grdf_initGrid(group5.sw_flag.case_grdmonthpr.grd_monthcostlist);
	grdf_initGrid(group5.sw_flag.case_grdcostpr.grd_costlist);

// 	group5.sw_flag.case_grdmonthpr.grd_monthcostlist.rowHeight(0) = "20";
// 	group5.sw_flag.case_grdmonthpr.grd_monthcostlist.rowHeight(1) = "20";
// 	group5.sw_flag.case_grdcostpr.grd_costlist.rowHeight(0) = "20";
// 	group5.sw_flag.case_grdcostpr.grd_costlist.rowHeight(1) = "20";

	rszfUserInstList(group5.group6.cmb_instcd,sysf_getUserInfo("userid"));

	//misfMsterDetailSet(group5.sw_flag.case_grdmonthpr.grd_monthcostlist,null, "TRRSG06601" ,"N"); 

	var curdate = utlf_getCurrentDate();

 	ds_send.setColumn(0,"stocym" ,curdate.substr(0,6));
 	// [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)            
 	ds_send.setColumn(0,"goodflag","PH");

 	// hidden column
 	// [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= S) => (goodflag= SF) 
 	ds_send.setColumn(0,"goodflag","SF");
 	//model.setValue(group5.group6.ipt_stocdeptcd.attribute("ref") ,"3251000000"); // sysf_getUserInfo("dutplcecd"));
 	ds_send.setColumn(0,"stocdeptcd", sysf_getUserInfo("dutplcecd"));
 
 	ds_send.setColumn(0,"instcd" , sysf_getUserInfo("dutplceinstcd"));
	group5.sw_flag.tabindex = 0;


}

function fCheckRetrieveData(pmsg)
{
	if(model.getValue(group5.group6.cmb_instcd.attribute("ref")).length== 0 )
	{
		if(pmsg == true)
		{
			sysf_messageBox("기관코드를 " ,"C002");
			group5.group6.cmb_instcd.setFocus();
		}
		return false;
	}				
	if(model.getValue(group5.group6.ipt_stocym.attribute("ref")).length== 0 )
	{
		if(pmsg == true)
		{
			sysf_messageBox("조회시작년월 " ,"C002");
			ipt_stocfrym.setFocus();
		}
		return false;
	}

	return true;
}	


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

     ds_send.setColumn(0,"stocym",ds_send.getColumn(0,"stocym").substring(0,6));
	 if (group5.sw_flag.tabindex == 0) 
	 {   
		var oParam = {};
		oParam.id          = "TRRSG06601";
		oParam.service     = "stocsumapp.StocSumMngt";
		oParam.method      = "reqGetMonthCostList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_list_monthcostlist=monthcostlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRSG06601";

	    tranf_submit(oParam);


	 } else {

		var oParam = {};
		oParam.id          = "TRRSG06602";
		oParam.service     = "stocsumapp.StocSumMngt";
		oParam.method      = "reqGetCostList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_list_costlist=costlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRSG06602";

		tranf_submit(oParam);

	}	  


}

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

	
	grdf_exportExcel(group5.sw_flag.case_grdmonthpr.grd_monthcostlist, "월별 식수단가 집계_"+ds_send.getColumn(0, "stocym"), "sheet", "true", "", "");

}

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

    grdf_exportExcel(group5.sw_flag.case_grdcostpr.grd_costlist, "기간별 식수단가 집계_"+ds_send.getColumn(0, "stocym"), "sheet", "true", "", "");

}

]]></Script>
  </Form>
</FDL>