YNU_JEUS/app_home/himed/xpapps/ast/dietxp/xp/SMANB00900_식품월재고마감관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMANB00900" position="absolute 0 0 1096 750" titletext="식품월재고마감처리" oninit="SMANB00900_oninit" onload="SMANB00900_onload">
    <Layouts>
      <Layout>
        <Static text="식품월재고마감처리" position="absolute 0 0 152 24" id="caption6" class="tit_1"/>
        <Tab position="absolute 0 25 1090 749" id="switch1" tabindex="1">
          <Tabpages>
            <Tabpage text="재고마감처리" position="absolute 0 0 1133 703" id="cse_cretstoc">
              <Layouts>
                <Layout>
                  <Div position="absolute 0 5 470 210" id="group1" style="border:1 solid #808080ff ;">
                    <Layouts>
                      <Layout>
                        <Static text="식품월재고마감처리" position="absolute 40 34 197 50" id="caption61" class="tit_2"/>
                        <Shape position="absolute 40 124 417 130" linetype="horizontal" id="line23" class="line_2"/>
                        <Shape position="absolute 40 130 417 136" linetype="horizontal" id="line35" class="line_3"/>
                        <Button position="absolute 329 142 371 161" id="btn_del" class="btn2" text="삭제" onclick="switch1_cse_cretstoc_group1_btn_del_onclick"/>
                        <Shape position="absolute 40 75 417 81" linetype="horizontal" id="line1" class="line_2"/>
                        <Button position="absolute 374 142 416 161" id="btn_gen" class="btn2" text="실행" onclick="switch1_cse_cretstoc_group1_btn_gen_onclick"/>
                        <Shape position="absolute 40 99 417 105" linetype="horizontal" id="line19" class="line_2"/>
                        <Static text="기관코드" position="absolute 40 55 148 78" align="align:center middle;" id="caption7" class="cell_1"/>
                        <Shape position="absolute 40 50 417 56" linetype="horizontal" id="line7" class="line_10"/>
                        <Calendar position="absolute 150 81 270 100" align="align:center middle;" id="input1" class="input_default" mask="yyyy-mm" autoselect="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" style="align:center middle;"/>
                        <Static text="작업년월" position="absolute 40 79 148 102" align="align:center middle;" id="caption5" class="cell_1"/>
                        <Static text="작업자" position="absolute 40 104 148 127" align="align:center middle;" id="caption2" class="cell_1"/>
                        <Edit position="absolute 150 106 229 125" id="input2" class="input_default" autoselect="true"/>
                        <Edit position="absolute 233 106 363 125" id="input3" class="input_default" autoselect="true"/>
                        <Edit readonly="true" position="absolute 369 55 399 74" id="output1" visible="false" class="output"/>
                        <Edit readonly="true" position="absolute 149 55 361 74" align="align:center middle;" id="output4" class="output" style="align:center middle;"/>
                      </Layout>
                    </Layouts>
                  </Div>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="cse_stocrslt" text="처리결과">
              <Layouts>
                <Layout>
                  <Static id="caption18" text="재고마감 처리결과" class="tit_2" position="absolute 0 45 140 61"/>
                  <Button id="button4" taborder="1" text="엑셀" onclick="switch1_cse_stocrslt_button4_onclick" class="btn2" position="absolute 1044 42 1086 61"/>
                  <Div id="group3" taborder="2" class="div_SA" position="absolute 0 0 1090 40">
                    <Layouts>
                      <Layout>
                        <Static id="caption17" text="기관코드 :" class="search_name" position="absolute 5 11 84 28"/>
                        <Edit id="output2" taborder="1" readonly="true" class="output" position="absolute 85 10 115 29"/>
                        <Edit id="output3" taborder="2" readonly="true" class="output" position="absolute 118 10 320 29" style="align:center middle;"/>
                        <Button id="button9" taborder="3" text="조회" onclick="switch1_cse_stocrslt_group3_button9_onclick" class="btn4" position="absolute 970 10 1026 32"/>
                        <Static id="caption19" text="작업년월 :" class="search_name" position="absolute 355 11 436 28"/>
                        <Calendar id="input4" taborder="4" autoselect="true" class="input_s_essential" position="absolute 435 10 532 29" mask="yyyy-mm" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
                        <Shape id="line14" linetype="vertical" class="line_4" position="absolute 947 5 953 33"/>
                        <Static id="caption11" text="~" class="search_no_b" position="absolute 540 10 552 27"/>
                        <Calendar id="input5" taborder="5" autoselect="true" class="input_s_essential" position="absolute 555 10 652 29" mask="yyyy-mm" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
                        <CheckBox id="checkbox1" taborder="6" text="월별합계" truevalue="Y" position="absolute 675 10 745 30" onclick="switch1_cse_stocrslt_group3_checkbox1_onclick"/>
                      </Layout>
                    </Layouts>
                  </Div>
                  <Button id="button13" taborder="3" text="출력" onclick="switch1_cse_stocrslt_button13_onclick" class="btn6" position="absolute 980 40 1036 62"/>
                  <Grid id="grd_foodstocrsltlist" taborder="4" binddataset="ds_main_stocinfo_foodstocrsltlist" useinputpanel="false" position="absolute 0 62 1090 697">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="20" band="left"/>
                          <Column size="57"/>
                          <Column size="94"/>
                          <Column size="82"/>
                          <Column size="113"/>
                          <Column size="112"/>
                          <Column size="113"/>
                          <Column size="98"/>
                          <Column size="127"/>
                          <Column size="91"/>
                          <Column size="118"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </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=" 전월이월&#10;금액" 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" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:stocym" expr="expr:getRowLevel(currow) == 1 &amp;&amp; ds_cond_srch3.getColumn(0, 'sumflag') != 'Y' ? '합계' : stocym" mask="expr:utlf_isNull(stocym) ? '' : '####-##'"/>
                          <Cell col="2" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:acntnm" expr="expr:getRowLevel(currow) == 1 &amp;&amp; ds_cond_srch3.getColumn(0, 'sumflag') == 'Y' ? '합계' : acntnm"/>
                          <Cell col="3" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:beftotqty" mask="#,##0.##"/>
                          <Cell col="4" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:beftotamt" mask="#,##0.##"/>
                          <Cell col="5" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:inputqty" mask="#,##0.##"/>
                          <Cell col="6" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:inputamt" mask="#,##0.##"/>
                          <Cell col="7" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:outputqty" mask="#,##0.##"/>
                          <Cell col="8" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:outputamt" mask="#,##0.##"/>
                          <Cell col="9" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:apptotqty" mask="#,##0.##"/>
                          <Cell col="10" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ffff99' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:apptotamt" mask="#,##0.##"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
      </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="strmm" type="STRING" size="256" sumtext="시작년월"/>
          <Column id="endmm" type="STRING" size="256" sumtext="종료년월"/>
          <Column id="sumflag" 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="stocym" type="STRING" size="256" sumtext="작업년월"/>
          <Column id="acntnm" 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_send_savedata" 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="iudflag" type="STRING" size="256" sumtext="작업구분"/>
          <Column id="strmm" type="STRING" size="256" sumtext="작업년월"/>
          <Column id="userid" type="STRING" size="256" sumtext="작업자"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_certinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="certflag" 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="strmm" type="STRING" size="256"/>
          <Column id="endmm" type="STRING" size="256"/>
          <Column id="sumflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_cond_srch1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_cond_srch1_oncolumnchanged">
        <ColumnInfo>
          <Column id="instnm" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="strmm" type="STRING" size="256"/>
          <Column id="userid" type="STRING" size="256"/>
          <Column id="usernm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_cond_srch3" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="instnm" type="STRING" size="256"/>
          <Column id="strmm" type="STRING" size="256"/>
          <Column id="endmm" type="STRING" size="256"/>
          <Column id="sumflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_stocinfo_foodstocrsltlist2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="stocym" type="STRING" size="256" sumtext="작업년월"/>
          <Column id="acntnm" 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>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="switch1.cse_stocrslt2.group3.output2" propid="value" datasetid="ds_cond_srch2" columnid="instcd"/>
      <BindItem id="item1" compid="switch1.cse_stocrslt2.group3.output3" propid="value" datasetid="ds_cond_srch2" columnid="instnm"/>
      <BindItem id="item2" compid="switch1.cse_stocrslt2.group3.input4" propid="value" datasetid="ds_cond_srch2" columnid="strmm"/>
      <BindItem id="item3" compid="switch1.cse_stocrslt2.group3.input5" propid="value" datasetid="ds_cond_srch2" columnid="endmm"/>
      <BindItem id="item4" compid="switch1.cse_stocrslt2.group3.checkbox1" propid="value" datasetid="ds_cond_srch2" columnid="sumflag"/>
      <BindItem id="item5" compid="switch1.cse_cretstoc.group1.output4" propid="value" datasetid="ds_cond_srch1" columnid="instnm"/>
      <BindItem id="item6" compid="switch1.cse_cretstoc.group1.output1" propid="value" datasetid="ds_cond_srch1" columnid="instcd"/>
      <BindItem id="item7" compid="switch1.cse_cretstoc.group1.input1" propid="value" datasetid="ds_cond_srch1" columnid="strmm"/>
      <BindItem id="item8" compid="switch1.cse_cretstoc.group1.input2" propid="value" datasetid="ds_cond_srch1" columnid="userid"/>
      <BindItem id="item9" compid="switch1.cse_cretstoc.group1.input3" propid="value" datasetid="ds_cond_srch1" columnid="usernm"/>
      <BindItem id="item10" compid="switch1.cse_stocrslt.group3.output2" propid="value" datasetid="ds_cond_srch2" columnid="instcd"/>
      <BindItem id="item11" compid="switch1.cse_stocrslt.group3.output3" propid="value" datasetid="ds_cond_srch2" columnid="instnm"/>
      <BindItem id="item12" compid="switch1.cse_stocrslt.group3.input4" propid="value" datasetid="ds_cond_srch2" columnid="strmm"/>
      <BindItem id="item13" compid="switch1.cse_stocrslt.group3.input5" propid="value" datasetid="ds_cond_srch2" columnid="endmm"/>
      <BindItem id="item14" compid="switch1.cse_stocrslt.group3.checkbox1" propid="value" datasetid="ds_cond_srch2" columnid="sumflag"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************
 * System Name		:	경대 의료정보시스템
 * Job Name 		:	ast_dietxp -> SMANB00900
 * Creator			:	yjh
 * Make Date 		:	2017-11-08
 * Description		:	
 *---------------------------------------------------------------------------------------
 * Modify Date		Modifier		Modify Description
 *---------------------------------------------------------------------------------------
 * 2017-11-08		yjh				TF->XP
 * 
 *---------------------------------------------------------------------------------------
 ****************************************************************************************/


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


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


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


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

/****************************************************************************************
 * Components		: Form
 * Components ID	: SMANB00900
 * Event			: onload
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 화면 로딩 완료시
 ****************************************************************************************/
function SMANB00900_onload(obj:Form, e:LoadEventInfo)
{
	ds_cond_srch1.setColumn(0, "instcd",sysf_getUserInfo("dutplceinstcd"));   
	ds_cond_srch1.setColumn(0, "instnm",sysf_getUserInfo("dutplceinstnm"));
	ds_cond_srch1.setColumn(0, "strmm"	,utlf_getCurrentDate().substring(0,6));
	ds_cond_srch1.setColumn(0, "userid",sysf_getUserInfo("userid"));   
	ds_cond_srch1.setColumn(0, "usernm",sysf_getUserInfo("usernm"));   
	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, "strmm"	,utlf_getCurrentDate().substring(0,6));
	ds_cond_srch2.setColumn(0, "endmm"	,utlf_getCurrentDate().substring(0,6));
}

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

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

	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");
	
	if(arErrorCode.pop("TRANB00901") > -1){
		var sumflag = ds_cond_srch2.getColumn(0, "sumflag");
		
		ds_cond_srch3.setColumn(0, "sumflag", ds_cond_srch2.getColumn(0, "sumflag"));
		
		if(sumflag=="Y"){
			ds_main_stocinfo_foodstocrsltlist.keystring = "G:-acntnm";
// 			grd_foodstocrsltlist.subtotal("clear", 0, 0);
// 			for(iCol =  1; iCol <=grd_foodstocrsltlist.cols ; iCol++){
// 				if((grd_foodstocrsltlist.colRef("stocym")!= iCol)&&(grd_foodstocrsltlist.colRef("acntnm")!= iCol)) {
// 					grd_foodstocrsltlist.subtotal("sum", 2, iCol, "format:#,###.##; ", "background-color:#ffff99; font-weight:bold; ", grd_foodstocrsltlist.colRef("acntnm"), "합계");	
// 				}
// 			}
		}else{
			ds_main_stocinfo_foodstocrsltlist.keystring = "G:+stocym";
// 			grd_foodstocrsltlist.subtotal("clear", 0, 0);
// 			for(iCol =  1; iCol <=grd_foodstocrsltlist.cols ; iCol++){
// 				if((grd_foodstocrsltlist.colRef("stocym")!= iCol)&&(grd_foodstocrsltlist.colRef("acntnm")!= iCol)) {
// 					grd_foodstocrsltlist.subtotal("sum", 1, iCol, "format:#,###.##; ", "background-color:#ffff99; font-weight:bold; ", grd_foodstocrsltlist.colRef("stocym"), "합계");	
// 				}
// 			}
			
		}
		
	}
}

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

/****************************************************************************************
 * Components		: Button
 * Components ID	: button13
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 출력버튼 클릭시
 ****************************************************************************************/
function switch1_cse_stocrslt_button13_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_stocinfo_foodstocrsltlist2.assign(ds_main_stocinfo_foodstocrsltlist);
	
	var objDOM = rptf_createDOM();				                													// DOM 객체 설정	
	rptf_setNodeListToDOM(objDOM, "/root/main/stocinfo/foodstocrsltlist", ds_main_stocinfo_foodstocrsltlist2);									// 데이터셋 1
	rptf_setNodeListToDOM(objDOM, "/root/send/reqdata", ds_send_reqdata);									// 데이터셋 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(["RPANB00901"],[objParam], option);
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: btn_del
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 삭제버튼 클릭시
 ****************************************************************************************/
function switch1_cse_cretstoc_group1_btn_del_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_send_savedata.setColumn(0, "iudflag"	,"D");
	ds_send_savedata.setColumn(0, "instcd"	,ds_cond_srch1.getColumn(0, "instcd"));
	ds_send_savedata.setColumn(0, "strmm"		,ds_cond_srch1.getColumn(0, "strmm"));
	ds_send_savedata.setColumn(0, "userid"	,ds_cond_srch1.getColumn(0, "userid"));
	
	var oParam = {};
		oParam.id          = "TXANB00901";
		oParam.service     = "dietsumapp.DietSum";
		oParam.method      = "reqExeCretFoodStocInfo";
		oParam.inds        = "req=ds_send_savedata";
		oParam.outds       = "ds_hidden_certinfo=certinfo";
		oParam.async       = false;
		oParam.callback    = "cf_TXANB00901";

	tranf_submit(oParam);
	
	if(arErrorCode.pop("TXANB00901") > -1){
		var certflag = ds_hidden_certinfo.getColumn(0, "certflag");
		if(certflag=="N"){
			sysf_messageBox("재고마감 삭제가","I001");
			return;
		}else{
			sysf_messageBox("재고마감 삭제가 실패하였습니다\n다시한번","C003");
			return;
		}
		
	}
}

/****************************************************************************************
 * Components		: Button
 * Components ID	: btn_gen
 * Event			: onclick
 * Argument			: 01.obj	: Object Event has occurred
 *					: 02.e		: Event Object
 * Description		: 실행버튼 클릭시
 ****************************************************************************************/
function switch1_cse_cretstoc_group1_btn_gen_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_send_savedata.setColumn(0, "iudflag"	,"I");
	ds_send_savedata.setColumn(0, "instcd"	 	,ds_cond_srch1.getColumn(0, "instcd"));
	ds_send_savedata.setColumn(0, "strmm"		,ds_cond_srch1.getColumn(0, "strmm"));
	ds_send_savedata.setColumn(0, "userid"		,ds_cond_srch1.getColumn(0, "userid"));
	
	var oParam = {};
		oParam.id          = "TXANB00901";
		oParam.service     = "dietsumapp.DietSum";
		oParam.method      = "reqExeCretFoodStocInfo";
		oParam.inds        = "req=ds_send_savedata";
		oParam.outds       = "ds_hidden_certinfo=certinfo";
		oParam.async       = false;
		oParam.callback    = "cf_TXANB00901";

	tranf_submit(oParam);
	
	if(arErrorCode.pop("TXANB00901") > -1){
		var certflag = ds_hidden_certinfo.getColumn(0, "certflag");
		if(certflag=="Y"){
			sysf_messageBox("재고마감 생성이","I001");	
			return;
		}else{
			sysf_messageBox("재고마감 생성이 실패하였습니다\n다시한번","C003");
			return;
		}
	}
}

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

function switch1_cse_stocrslt_group3_checkbox1_onclick(obj:CheckBox,  e:ClickEventInfo)
{
	if( obj.value != "Y" ){
		ds_cond_srch2.setColumn(0, "sumflag", "");
	}
}

function ds_cond_srch1_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	switch( e.columnid ){
		case "strmm" :
			obj.setColumn(e.row, e.columnid, utlf_transNullToEmpty(e.newvalue).substr(0, 6));
			break;
			
		default :
			break;
	}
}

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