YNU_JEUS/app_home/himed/xpapps/mis/sicksuxp/xp/SMRNB00400_식수조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRNB00400" inheritanceid="" position="absolute 0 0 1024 665" titletext="식수조회" onload="SMRNB00400_onload" ontimer="SMRNB00400_ontimer">
    <Layouts>
      <Layout>
        <Div id="grp_search" taborder="32" position="absolute 0 51 1024 111" class="div_SA2" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="cap_fromtodd" text="조회일자" class="search_name" position="absolute 10 10 84 27" anchor="default"/>
              <Shape id="line7" linetype="vertical" class="line_4" position="absolute 938 11 941 50" anchor="top right"/>
              <Calendar id="ipt_fromdd" taborder="0" autoselect="true" class="input_essential" position="absolute 87 7 197 28" anchor="default" value="null" dateformat="yyyy-MM-dd ddd"/>
              <Calendar id="ipt_todd" taborder="1" autoselect="true" dateformat="yyyy-MM-dd ddd" class="input_essential" position="absolute 215 7 325 28" anchor="default"/>
              <Static id="Static00" text="~" position="absolute 201 10 213 26" anchor="default"/>
              <Static id="cap_flag_search" text="식사구분" class="search_name" position="absolute 370 10 444 27" anchor="default"/>
              <Static id="cap_instcd_search" text="식사장소" class="search_name" position="absolute 10 35 84 52" anchor="default"/>
              <Static id="cap_gbn" text="대상구분" class="search_name" position="absolute 370 35 444 52" anchor="default"/>
              <Radio id="rdo_flag_search" taborder="3" columncount="4" position="absolute 450 7 686 27" codecolumn="codecolumn" datacolumn="datacolumn" style="textpadding:0 5 0 3;" index="-1" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">0</Col>
                      <Col id="datacolumn">조식</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">중식</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">석식</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn"/>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Combo id="cmb_instcd_search" taborder="2" position="absolute 87 33 235 53" codecolumn="cdid" datacolumn="cdnm" anchor="default" index="-1" innerdataset="@ds_init_placelist_search"/>
              <Button id="btn_search" taborder="6" text="조회" class="btn1" position="absolute 953 20 1009 42" style="align:center;" anchor="top right" onclick="grp_search_btn_search_onclick"/>
              <Radio id="rdo_gbn" taborder="4" columncount="2" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 450 31 568 51" style="textpadding:0 5 0 3;" index="-1" onitemchanged="grp_search_rdo_gbn_onitemchanged" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">P</Col>
                      <Col id="datacolumn">개인</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">A</Col>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Edit id="ipt_id_search" taborder="5" position="absolute 568 32 684 52" enable="false" autoselect="true" onkeydown="grp_search_ipt_id_search_onkeydown" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption6" text="식수조회" class="tit_1" position="absolute 0 0 100 25"/>
        <Shape id="roundrect1" type="roundrectangle" position="absolute 728 136 1022 384" anchor="top right"/>
        <Static id="cap_time" position="absolute 759 1 1024 24" style="background:darkseagreen;padding:0 0 0 4;align:center middle;font:Dotum,10,bold;" anchor="top right"/>
        <Button id="btn_save" taborder="30" text="저장" class="btn4" position="absolute 971 26 1024 48" anchor="top right" onclick="btn_save_onclick"/>
        <Static id="cap_messege_title" position="absolute 72 636 229 659" anchor="left bottom" style="background:lightblue;padding:0 0 0 4;"/>
        <Static id="cap_messege" position="absolute 231 636 948 659" anchor="left right bottom" style="background:lightblue;padding:0 0 0 4;font:Dotum,9,bold;"/>
        <Shape id="line7" class="line_6" position="absolute 0 47 1023 53" anchor="left top right"/>
        <Shape id="line1" class="line_10" position="absolute 2 135 1022 141" anchor="left top right"/>
        <Static id="caption1" text="식사내역" class="tit_2" position="absolute 2 119 159 135"/>
        <Static id="cap_date" text="년월일시" class="cell_1" position="absolute 744 200 834 224" anchor="top right"/>
        <Static id="cap_flag" text="식사구분" class="cell_1" position="absolute 744 248 834 272" anchor="top right"/>
        <Static id="cap_id" text="입력개인ID" class="cell_1" position="absolute 744 296 834 320" anchor="top right"/>
        <Radio id="rdo_flag" taborder="34" columncount="4" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 840 250 1020 270" style="textpadding:0 5 0 3;" anchor="top right" onitemchanged="rdo_flag_onitemchanged">
          <Dataset id="innerdataset">
            <ColumnInfo>
              <Column id="codecolumn" size="256"/>
              <Column id="datacolumn" size="256"/>
            </ColumnInfo>
            <Rows>
              <Row>
                <Col id="codecolumn">0</Col>
                <Col id="datacolumn">조식</Col>
              </Row>
              <Row>
                <Col id="codecolumn">1</Col>
                <Col id="datacolumn">중식</Col>
              </Row>
              <Row>
                <Col id="codecolumn">2</Col>
                <Col id="datacolumn">석식</Col>
              </Row>
            </Rows>
          </Dataset>
        </Radio>
        <Edit id="ipt_date" taborder="35" position="absolute 840 202 1004 222" class="input_essential" anchor="top right" maxlength="10" inputtype="number" autoselect="true"/>
        <Edit id="ipt_id" taborder="36" position="absolute 840 298 1004 318" class="input_essential" anchor="top right" autoselect="true" maxlength="8" useime="none" onkeydown="ipt_id_onkeydown"/>
        <Static id="cap_instcd" text="식사장소" class="cell_1" position="absolute 744 152 834 176" anchor="top right"/>
        <Combo id="cmb_instcd" taborder="37" codecolumn="cdid" datacolumn="cdnm" position="absolute 840 154 1004 174" class="combo_essential" anchor="top right" innerdataset="@ds_init_placelist"/>
        <Static id="cap_ex" position="absolute 841 222 1005 242" text="ex) 2017121312" style="color:red;font:Dotum,9,bold;" anchor="top right"/>
        <Static id="cap_name" text="성명" class="cell_1" position="absolute 744 344 834 368" anchor="top right"/>
        <Edit id="ipt_name" taborder="39" onkeydown="ipt_id_onkeydown" position="absolute 840 346 1004 366" anchor="top right" readonly="true" class="output"/>
        <Button id="btn_new" taborder="40" text="행추가" class="btn2" position="absolute 914 115 967 134" onclick="btn_new_onclick"/>
        <Button id="btn_delete" taborder="41" text="행삭제" class="btn2" position="absolute 969 115 1022 134" onclick="btn_delete_onclick"/>
        <Grid id="grd_foodnewtranslist" taborder="33" useinputpanel="false" position="absolute 2 140 1022 631" autofittype="col" summarytype="top" binddataset="ds_main_foodnewtranslist" anchor="all" autoenter="select" selecttype="multirow">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="25"/>
                <Column size="60"/>
                <Column size="19"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="100"/>
                <Column size="120"/>
                <Column size="120"/>
                <Column size="60"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1"/>
                <Cell col="2" colspan="2" text="년.월.일.시" taborder="undefined"/>
                <Cell col="4" text="식사구분"/>
                <Cell col="5" text="ID"/>
                <Cell col="6" text="성명"/>
                <Cell col="7" text="식사장소"/>
                <Cell col="8" text="병원구분"/>
                <Cell col="9" text="식사시간"/>
                <Cell col="10" text="잔량"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" celltype="head" text="expr:currow+1"/>
                <Cell col="2" displaytype="date" edittype="expr:getRowType(currow) == 2 ? 'date' : 'none'" style="align:right;line:1 solid #b0b0b0ff,0 none #b0b0b0ff,1 solid #b0b0b0ff,1 solid #b0b0b0ff;" text="bind:diet" editautoselect="true" calendardisplaynulltype="none"/>
                <Cell col="3" style="align:left;line:1 solid #b0b0b0ff,1 solid #b0b0b0ff,1 solid #b0b0b0ff,0 none #b0b0b0ff;" expr="expr:flag=='0'?'07':flag=='1'?'14':'19'" maskchar=" "/>
                <Cell col="4" displaytype="combo" edittype="expr:getRowType(currow) == 2 ? 'combo' : 'none'" style="align:center middle;" text="bind:flag" combodataset="ds_cmb_flag" combocodecol="cdid" combodatacol="cdnm"/>
                <Cell col="5" displaytype="text" edittype="expr:getRowType(currow) == 2 ? 'text' : 'none'" style="align:center;padding:1 2 1 5;" text="bind:id" edittrimtype="both" editautoselect="true"/>
                <Cell col="6" displaytype="text" style="align:center;" text="bind:name"/>
                <Cell col="7" displaytype="combo" edittype="expr:getRowType(currow) == 2 ? 'combo' : 'none'" style="align:center;padding:0 0 0 2;" text="bind:ocs_id" combodataset="ds_init_placelist" combocodecol="cdid" combodatacol="cdnm"/>
                <Cell col="8" displaytype="combo" style="align:center middle;" text="bind:instcd" combodataset="ds_cmb_instcd" combocodecol="cdid" combodatacol="cdnm"/>
                <Cell col="9" displaytype="date" text="bind:food_datetime" mask="expr:utlf_isNull(food_datetime) ? '' : 'yyyy-MM-dd HH:mm:ss'"/>
                <Cell col="10" displaytype="number" style="align:center;" text="bind:remain"/>
              </Band>
              <Band id="summary">
                <Cell celltype="head"/>
                <Cell col="1"/>
                <Cell col="2" style="line:1 solid #b0b0b0ff,0 none #b0b0b0ff,1 solid #b0b0b0ff,1 solid #b0b0b0ff;font:Dotum,9,bold;" text="Count : "/>
                <Cell col="3" style="line:1 solid #b0b0b0ff,1 solid #b0b0b0ff,1 solid #b0b0b0ff,0 none #b0b0b0ff;"/>
                <Cell col="4"/>
                <Cell col="5" displaytype="number" style="font:Dotum,9,bold;" expr="expr:rowcount"/>
                <Cell col="6"/>
                <Cell col="7"/>
                <Cell col="8"/>
                <Cell col="9"/>
                <Cell col="10"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_exceldown" taborder="42" text="다운로드" class="btn7" position="absolute 814 115 894 135" anchor="top right" onclick="btn_exceldown_onclick"/>
        <Button id="btn_excelup" taborder="43" text="업로드" class="btn7" position="absolute 709 115 789 135" anchor="top right" onclick="btn_excelup_onclick"/>
        <Grid id="grd_sampleexcel" taborder="44" binddataset="ds_sampleexcel" useinputpanel="false" visible="false" position="absolute 17 242 504 346">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="일자"/>
                <Cell col="1" text="식사구분"/>
                <Cell col="2" text="ID"/>
                <Cell col="3" text="성명"/>
                <Cell col="4" text="식사장소"/>
              </Band>
              <Band id="body">
                <Cell text="bind:diet" mask="####-##-##"/>
                <Cell col="1" text="bind:flagnm"/>
                <Cell col="2" text="bind:id"/>
                <Cell col="3" text="bind:name"/>
                <Cell col="4" text="bind:ocs_idnm"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excelsample" taborder="45" text="샘플다운" class="btn7" position="absolute 625 115 705 135" anchor="top right" onclick="btn_excelsample_onclick"/>
      </Layout>
    </Layouts>
    <Bind>
      <BindItem id="item15" compid="grp_search.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item20" compid="grp_search.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item0" compid="grp_search.cmb_instcd_search" propid="value" datasetid="ds_send" columnid="ocs_id"/>
      <BindItem id="item1" compid="grp_search.rdo_flag_search" propid="value" datasetid="ds_send" columnid="flag"/>
      <BindItem id="item2" compid="grp_search.rdo_gbn" propid="value" datasetid="ds_send" columnid="gbn"/>
      <BindItem id="item3" compid="grp_search.ipt_id_search" propid="value" datasetid="ds_send" columnid="userid"/>
      <BindItem id="item4" compid="cmb_instcd" propid="value" datasetid="ds_send_foodnewtrans" columnid="ocs_id"/>
      <BindItem id="item5" compid="ipt_date" propid="value" datasetid="ds_send_foodnewtrans" columnid="dietdate"/>
      <BindItem id="item6" compid="rdo_flag" propid="value" datasetid="ds_send_foodnewtrans" columnid="flag"/>
      <BindItem id="item7" compid="ipt_id" propid="value" datasetid="ds_send_foodnewtrans" columnid="id"/>
      <BindItem id="item8" compid="ipt_name" propid="value" datasetid="ds_temp_foodmaster" columnid="name"/>
    </Bind>
    <Objects>
      <Dataset id="ds_send" 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="userid" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="flag" type="STRING" size="256"/>
          <Column id="gbn" type="STRING" size="256"/>
          <Column id="ocs_id" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="userid"/>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="flag"/>
            <Col id="gbn"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_foodnewtranslist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_foodnewtranslist_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="dietdate" type="STRING" size="256"/>
          <Column id="flag" type="STRING" size="256"/>
          <Column id="id" type="STRING" size="256"/>
          <Column id="ocs_id" type="STRING" size="256"/>
          <Column id="food_datetime" type="STRING" size="256"/>
          <Column id="remain" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="diet" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_foodnewtrans" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_foodnewtrans_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="dietdate" type="STRING" size="256"/>
          <Column id="flag" type="STRING" size="256"/>
          <Column id="id" type="STRING" size="256"/>
          <Column id="ocs_id" type="STRING" size="256"/>
          <Column id="food_datetime" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_instcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cdid">031</Col>
            <Col id="cdnm">경북대학교병원</Col>
          </Row>
          <Row>
            <Col id="cdid">032</Col>
            <Col id="cdnm">칠곡경북대학교병원</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_flag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cdid">0</Col>
            <Col id="cdnm">조식</Col>
          </Row>
          <Row>
            <Col id="cdid">1</Col>
            <Col id="cdnm">중식</Col>
          </Row>
          <Row>
            <Col id="cdid">2</Col>
            <Col id="cdnm">석식</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp_foodmaster" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_placelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_placelist_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_req2" 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="id" type="STRING" size="256"/>
          <Column id="ocs_id" type="STRING" size="256"/>
          <Column id="flag" type="STRING" size="256"/>
          <Column id="dietdate" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_sicksucnt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cnt" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_uploadexcel" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="diet" type="STRING" size="256"/>
          <Column id="flagnm" type="STRING" size="256"/>
          <Column id="id" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="ocs_idnm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_sampleexcel" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="diet" type="STRING" size="256"/>
          <Column id="flagnm" type="STRING" size="256"/>
          <Column id="id" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="ocs_idnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="diet">00000000</Col>
            <Col id="flagnm">중식</Col>
            <Col id="id">00000</Col>
            <Col id="ocs_idnm">직원식당</Col>
            <Col id="name">홍길동</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-12-04
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";

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

/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화0
 ****************************************************************************************/
function SMRNB00400_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj);
	grdf_initGrid(grd_foodnewtranslist);
	grdf_setRowTypeIcon(grd_foodnewtranslist, 0);
	
	if( sysf_getUserInfo("dutplceinstcd") == "031" ){
		grd_foodnewtranslist.setCellProperty("body", grd_foodnewtranslist.getBindCellIndex("body", "flag"), "edittype", "none");
	}
	
	dsf_createDsRow("ds_req", 	[
								{col:"lrgcd", type:"STRING", size:256, val:"ES"}
								]);
	var oParam = {};
		oParam.id          = "TRRNB00015";
		oParam.service     = "sicksuapp.SicksuMngt";
		oParam.method      = "reqGetPlaceList";
		oParam.inds        = "req=ds_req";
		oParam.outds       = "ds_init_placelist=placelist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRNB00015";

	tranf_submit(oParam);
	
	ds_init_placelist_search.copyData(ds_init_placelist);
	frmf_addComboItem( "grp_search.cmb_instcd_search", "전체", "");
	var sInstCd = sysf_getUserInfo("dutplceinstcd");
	
	ds_send.setColumn(0, "instcd", sInstCd);
	ds_send.setColumn(0, "fromdd", utlf_getCurrentDate());
	ds_send.setColumn(0, "todd"	 , utlf_getCurrentDate());
	ds_send.setColumn(0, "gbn"	 , "A");
	
	grp_search.cmb_instcd_search.index = 0;
	
	//lf_userAuth();
	
	lf_setTime();
	this.setTimer(0, 1000);
}


//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Argument			: N/A
 * Description		: 시간설정
 ****************************************************************************************/
function lf_setTime() {
	var cTime = utlf_getCurrentDateTime();
	cap_time.text = cTime.substr(0,4)+"/"+cTime.substr(4,2)+"/"+cTime.substr(6,2)+"  "+cTime.substr(9,2)+":"+cTime.substr(11,2)+":"+cTime.substr(13,2);
}

/****************************************************************************************
 * Argument			: N/A
 * Description		: 식권정보 조회
 ****************************************************************************************/
function call_TRRNB00001() {
	var oParam = {};
		oParam.id          = "TRRNB00001";
		oParam.service     = "sicksuapp.SicksuMngt";
		oParam.method      = "reqGetFoodmaster";
		oParam.inds        = "req=ds_req";
		oParam.outds       = "ds_temp_foodmaster=foodmaster";
		oParam.async       = false;
		oParam.callback    = "cf_TRRNB00001";

	tranf_submit(oParam);
	
	if(arErrorCode.pop("TRRNB00001") > -1) {
		dsf_setTypeFormat(ds_temp_foodmaster, "payfood:INT^expandfood:INT^remain:INT^hiredate:DATE^restdate:DATE^resumpdate:DATE^retiredate:DATE");
	}
}

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

/****************************************************************************************
 * Argument			: N/A
 * Description		: 식권정보 처리
 ****************************************************************************************/
function call_TXRNB00002() {
	var oParam = {};
		oParam.id          = "TXRNB00002";
		oParam.service     = "sicksuapp.SicksuMngt";
		oParam.method      = "reqSetFoodInfo";
		oParam.inds        = "foodmaster=ds_temp_foodmaster foodnewtrans=ds_save_foodnewtrans";
		//oParam.outds       = "ds_main_foodmaster=foodmaster";
		oParam.async       = false;
		oParam.callback    = "cf_TXRNB00002";

	tranf_submit(oParam);
}

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

/****************************************************************************************
 * Argument			: N/A
 * Description		: 사용자 정보 조회
 ****************************************************************************************/
function lf_userConf() {
	dsf_createDsRow("ds_req", 	[
								{col:"userid", type:"STRING", size:256, val:ds_temp_foodmaster.getColumn(0, "id")}
								]);
	var oParam = {};
		oParam.id          = "TRRNB00002";
		oParam.service     = "sicksuapp.SicksuMngt";
		oParam.method      = "reqGetFoodUserInfo";
		oParam.inds        = "req=ds_req";
		oParam.outds       = "ds_hidden=userinfo";
		oParam.async       = false;
		oParam.callback    = "cf_TRRNB00002";

	tranf_submit(oParam);
}

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

/****************************************************************************************
 * Argument			: N/A
 * Description		: 조회함수
 ****************************************************************************************/
function lf_userAuth() {
	if(sysf_getUserInfo("userid").substr(0,4).toUpperCase() == "EVER") {
		btn_delete.enable = false;
		btn_new.enable = false;
		btn_save.enable = false;
	}
}

//=======================================================================================
// Event
//---------------------------------------------------------------------------------------


/****************************************************************************************
 * Components		: Form
 * Description		: 화면 타이머 설정 시계표시
 ****************************************************************************************/
function SMRNB00400_ontimer(obj:Form, e:TimerEventInfo)
{
	if(e.timerid == 0) {
		lf_setTime();
	}
}

/****************************************************************************************
 * Components		: Button
 * Description		: 조회
 ****************************************************************************************/
function grp_search_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRNB00006";
		oParam.service     = "sicksuapp.SicksuMngt";
		oParam.method      = "reqGetFoodnewtranslist";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_foodnewtranslist=foodnewtranslist";
		oParam.async       = false;

	tranf_submit(oParam);	
	
	ds_temp_foodmaster.clearData();
	
	cap_messege_title.style.background = "lightblue";
	cap_messege.text = "조회되었습니다!"
}

/****************************************************************************************
 * Components		: Radio
 * Description		: 대상구분 개인선택시 ID입력
 ****************************************************************************************/
function grp_search_rdo_gbn_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	if(e.postvalue == "P") {
		grp_search.ipt_id_search.enable = true;
		grp_search.ipt_id_search.setFocus();
	}else{
		grp_search.ipt_id_search.enable = false;
		ds_send.setColumn(0, "userid", "");
	}
}

/****************************************************************************************
 * Components		: Edit
 * Description		: ID입력후 조회
 ****************************************************************************************/
function grp_search_ipt_id_search_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13) {
		obj.updateToDataset();
		grp_search.btn_search.click();
	}
}

/****************************************************************************************
 * Components		: Button
 * Description		: 삭제
 ****************************************************************************************/
function btn_delete_onclick(obj:Button,  e:ClickEventInfo)
{
	var nRow     = null;
	var nStatus  = null;
	var selectedRows = grdf_getSelectedRows(grd_foodnewtranslist);
	
	for( var i = selectedRows.length - 1; i >= 0; i--) {
		nRow    = selectedRows[i];
		nStatus = ds_main_foodnewtranslist.getRowType(nRow);
		
		if(nStatus == 1) { // 기존데이터
			ds_main_foodnewtranslist.enableevent   = false;
			ds_main_foodnewtranslist.updatecontrol = false;
			
			ds_main_foodnewtranslist.setRowType(nRow, "D");
			
			ds_main_foodnewtranslist.updatecontrol = true;
			ds_main_foodnewtranslist.enableevent   = true;
		} else if (nStatus == 2) { // 신규데이터
			ds_main_foodnewtranslist.deleteRow(nRow);
		} else if (nStatus == 8) { // 삭제데이터
			ds_main_foodnewtranslist.enableevent   = false;
			ds_main_foodnewtranslist.updatecontrol = false;
			
			ds_main_foodnewtranslist.setRowType(nRow, "");
			
			ds_main_foodnewtranslist.updatecontrol = true;
			ds_main_foodnewtranslist.enableevent   = true;
		}	
	}
}

/****************************************************************************************
 * Components		: Button
 * Description		: 신규입력
 ****************************************************************************************/
function btn_new_onclick(obj:Button,  e:ClickEventInfo)
{
	var sFlag   = ds_send.getColumn(0, "flag");
	var sOcsId  = ds_send.getColumn(0, "ocs_id");
	var sFromDd = ds_send.getColumn(0, "fromdd");
	
	ds_main_foodnewtranslist.insertRow(0);
	ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "instcd", 	      sysf_getUserInfo("dutplceinstcd"));
	ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "dietdate",      sFromDd + "07");
	ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "diet", 	      sFromDd);
	ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "food_datetime", sFromDd + "070000");
	
	if(utlf_isNull(sFlag)) {
		ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "flag",       "1");
	} else {
		ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "flag",       sFlag);
	}
	
	if(!utlf_isNull(sOcsId)) {
		ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "ocs_id",     sOcsId);
	}
}

/****************************************************************************************
 * Components		: Button
 * Description		: 신규입력저장
 ****************************************************************************************/
function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	dsf_createDs("ds_send_savedata");
	var updateData = grdf_getGridUpdateData(grd_foodnewtranslist);
	
	grdf_setStatusColumn(updateData, "status");
	ds_send_savedata.copyData(updateData, true);

	var oParam = {};
		oParam.id          = "TXRNB00003";
		oParam.service     = "sicksuapp.SicksuMngt";
		oParam.method      = "reqExeFoodInfo";
		oParam.inds        = "req=ds_send_savedata";
		oParam.outds       = "";
		oParam.async       = false;

	if(tranf_submit(oParam)) {
		grp_search.btn_search.click();
	}
}

function btn_save_onclick_backup(obj:Button,  e:ClickEventInfo)	{
	var dsUpdate = grdf_getGridUpdateData(grd_foodnewtranslist, "all");
	
	if( !utlf_isNull(dsUpdate) && dsUpdate.rowcount > 1 ){
		sysf_messageBox("2건이상은 처리", "E001");
		
		return false;
	}
	
	if( !utlf_isNull(dsUpdate) && dsUpdate.rowcount == 1 ){
		//삭제시
		if( dsUpdate.getRowType(0) == 8 ){
			dsf_createDsRow("ds_req", 	[
										{col:"userid", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(ds_main_foodnewtranslist.rowposition,"id")}
									   ,{col:"instcd", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(ds_main_foodnewtranslist.rowposition,"instcd")}
										]);
			call_TRRNB00001();
			
			dsf_createDsRow("ds_save_foodnewtrans", [
													{col:"id", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(ds_main_foodnewtranslist.rowposition,"id")}
												   ,{col:"instcd", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(ds_main_foodnewtranslist.rowposition,"instcd")}
												   ,{col:"dietdate", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(ds_main_foodnewtranslist.rowposition,"dietdate")}
												   ,{col:"ocs_id", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(ds_main_foodnewtranslist.rowposition,"ocs_id")}
												   ,{col:"flag", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(ds_main_foodnewtranslist.rowposition,"flag")}
												   ,{col:"status", type:"STRING", size:256, val:"d"}
													]);
			var sRemain 	= ds_temp_foodmaster.getColumn(0, "remain");
			var sExpanfood	= ds_temp_foodmaster.getColumn(0, "expandfood");
			var sUserid		= ds_temp_foodmaster.getColumn(0, "id");
			
			if(utlf_isNull(sRemain)) sRemain = 0;
			if(utlf_isNull(sExpanfood)) sExpanfood = 0;
			
			//식사정보 업데이트
			//비정규직
			if(sUserid.length > 5 && ((sUserid.length == 8 && sUserid > "82000070" && sUserid <= "82000211") 
									|| sUserid == "82000213" || sUserid.substr(0,1) == "9" || sUserid.substr(0,1) == "A" || sUserid.substr(0,1) == "7")
			) {	
				ds_temp_foodmaster.setColumn(0, "expandfood", (sExpanfood - 1));
				ds_temp_foodmaster.setColumn(0, "remain", (sRemain + 1));
			} 
			//새마을금고 직원
			else if(sUserid.length == 5 && sUserid.substr(0,2) == "90"){
				if(sRemain <= 0) {
					ds_temp_foodmaster.setColumn(0, "expandfood", (sExpanfood - 1));
				} else {
					ds_temp_foodmaster.setColumn(0, "remain", (sRemain + 1));
				}
			}
			//재직직원
			else {
				ds_temp_foodmaster.setColumn(0, "expandfood", (sExpanfood - 1));
			}
				
			dsf_makeValue(ds_temp_foodmaster, "instcd", "string", ds_main_foodnewtranslist.getColumn(ds_main_foodnewtranslist.rowposition,"instcd"));
				
			call_TXRNB00002();
			
			if(arErrorCode.pop("TXRNB00002") > -1) {
				cap_messege_title.style.background = "lightblue";
				cap_messege.text = "데이터 삭제 처리되었습니다!"
				grp_search.btn_search.click();
			} else {
				cap_messege_title.style.background = "red";
				cap_messege.text = "데이터 처리에 실패하였습니다!"
			}
		//신규시
		}else if( dsUpdate.getRowType(0) == 2 ){
			var nTarRow = grdf_getUpdateRows("grd_foodnewtranslist", "insert");
			
			if( utlf_isNull(ds_main_foodnewtranslist.getColumn(nTarRow, "ocs_id")) ){
				ds_main_foodnewtranslist.rowposition = nTarRow;
				grd_foodnewtranslist.setCellPos(5);
				grd_foodnewtranslist.setFocus();
				
				sysf_messageBox("식사장소는", "I003");
				
				return false;
			}
			if( utlf_isNull(ds_main_foodnewtranslist.getColumn(nTarRow, "dietdate")) || utlf_transNullToEmpty(ds_main_foodnewtranslist.getColumn(nTarRow, "dietdate")).length != 10 ){
				ds_main_foodnewtranslist.rowposition = nTarRow;
				grd_foodnewtranslist.setCellPos(7);
				grd_foodnewtranslist.setFocus();
				
				sysf_messageBox("년월일시는 10자리만", "C001");
				
				return false;
			}
			if( utlf_isNull(ds_main_foodnewtranslist.getColumn(nTarRow, "id")) || utlf_transNullToEmpty(ds_main_foodnewtranslist.getColumn(nTarRow, "id")).length < 5 ){
				ds_main_foodnewtranslist.rowposition = nTarRow;
				grd_foodnewtranslist.setCellPos(3);
				grd_foodnewtranslist.setFocus();
				
				sysf_messageBox("ID는 5자리이상", "C001");
				
				return false;
			}
			if( utlf_isNull(ds_main_foodnewtranslist.getColumn(nTarRow, "name")) ){
				ds_main_foodnewtranslist.rowposition = nTarRow;
				grd_foodnewtranslist.setCellPos(4);
				grd_foodnewtranslist.setFocus();
				
				sysf_messageBox("성명은", "I003");
				
				return false;
			}
			if( !utlf_isValidDateTime(ds_main_foodnewtranslist.getColumn(nTarRow, "dietdate").substr(0,8), "YYYYMMDD")) {
				ds_main_foodnewtranslist.rowposition = nTarRow;
				grd_foodnewtranslist.setCellPos(7);
				grd_foodnewtranslist.setFocus();
				
				sysf_messageBox("식사일시 형식이 맞지 않습니다. ","I007");
				
				return false;
			}
			
			ds_req2.setColumn(0, "instcd", ds_main_foodnewtranslist.getColumn(nTarRow, "instcd"));
			ds_req2.setColumn(0, "id", ds_main_foodnewtranslist.getColumn(nTarRow, "id"));
			ds_req2.setColumn(0, "ocs_id", ds_main_foodnewtranslist.getColumn(nTarRow, "ocs_id"));
			ds_req2.setColumn(0, "flag", ds_main_foodnewtranslist.getColumn(nTarRow, "flag"));
			ds_req2.setColumn(0, "dietdate", utlf_transNullToEmpty(ds_main_foodnewtranslist.getColumn(nTarRow, "dietdate")).substr(0, 8));
			
			var oParam = {};
				oParam.id		= "TRRSC20105";
				oParam.service	= "sicksuapp.SicksuMngt";
				oParam.method	= "reqGetSicksuCnt";
				oParam.inds		= "req=ds_req2";
				oParam.outds	= "ds_sicksucnt=sicksucnt";
				oParam.async	= false;
				oParam.callback	= "cf_TRRSC20105";
			
			tranf_submit(oParam);
			
			if( arErrorCode.pop("TRRSC20105") > -1 ){
				if( ds_sicksucnt.getColumn(0, "cnt") > 0 ){
					ds_main_foodnewtranslist.rowposition = nTarRow;
					grd_foodnewtranslist.setCellPos(1);
					grd_foodnewtranslist.setFocus();
					
					sysf_messageBox("데이터가","E006");
					
					return false;
				}
			}else{
				return false;
			}
			
			var sRemain 	= ds_temp_foodmaster.getColumn(0, "remain");
			var sExpanfood	= ds_temp_foodmaster.getColumn(0, "expandfood");
			var sUserid		= ds_temp_foodmaster.getColumn(0, "id");
			var sUseYn		= ds_temp_foodmaster.getColumn(0, "use_flag");
			
			if(utlf_isNull(sRemain)) sRemain = 0;
			if(utlf_isNull(sExpanfood)) sExpanfood = 0;
			
			if(utlf_isNull(sUserid)) {
				cap_messege_title.style.background = "red";
				cap_messege.text = "등록되지 않은 ID 입니다 .확인후 처리 하세요.!"
			}
			
			if(sUseYn == "N") {
				cap_messege_title.style.background = "red";
				cap_messege.text = "사용이 중지된 ID 입니다 .확인후 처리 하세요.!"
			}
			
			//직원체크
			//비정규직
			if(sUserid.length > 5 && ((sUserid.length == 8 && sUserid > "82000070" && sUserid <= "82000211") 
									|| sUserid == "82000213" || sUserid.substr(0,1) == "9" || sUserid.substr(0,1) == "A" || sUserid.substr(0,1) == "7")
			) {	
			} 
			//새마을금고 직원
			else if(sUserid.length == 5 && sUserid.substr(0,2) == "90"){
			}
			//재직직원
			else {
				lf_userConf();
				
				if(arErrorCode.pop("TRRNB00002") > -1) {
					if(ds_hidden.rowcount > 0 && parseInt(ds_hidden.getColumn(0, "cnt")) == 0) {
		//				lf_sorry();
						cap_messege.text = "재직 직원이 아닙니다. 확인 해 주십시오!";
						return;
					}
				}
			}
			
			//식사정보 업데이트
			//비정규직
			if(sUserid.length > 5 && ((sUserid.length == 8 && sUserid > "82000070" && sUserid <= "82000211") 
									|| sUserid == "82000213" || sUserid.substr(0,1) == "9" || sUserid.substr(0,1) == "A" || sUserid.substr(0,1) == "7")
			) {	
				ds_temp_foodmaster.setColumn(0, "expandfood", (sExpanfood + 1));
				ds_temp_foodmaster.setColumn(0, "remain", (sRemain - 1));
			} 
			//새마을금고 직원
			else if(sUserid.length == 5 && sUserid.substr(0,2) == "90"){
				if(sRemain <= 0) {
					ds_temp_foodmaster.setColumn(0, "expandfood", (sExpanfood + 1));
				} else {
					ds_temp_foodmaster.setColumn(0, "remain", (sRemain - 1));
				}
			}
			//재직직원
			else {
				ds_temp_foodmaster.setColumn(0, "expandfood", (sExpanfood + 1));
			}	
			
			dsf_makeValue(ds_temp_foodmaster, "instcd", "string", ds_main_foodnewtranslist.getColumn(nTarRow,"instcd"));
			var sInstcd = ds_main_foodnewtranslist.getColumn(nTarRow, "instcd");
			dsf_createDsRow("ds_save_foodnewtrans", [
													{col:"id", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(nTarRow,"id")}
												   ,{col:"instcd", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(nTarRow,"instcd")}
												   ,{col:"dietdate", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(nTarRow,"dietdate")}
												   ,{col:"ocs_id", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(nTarRow,"ocs_id")}
												   ,{col:"flag", type:"STRING", size:256, val:ds_main_foodnewtranslist.getColumn(nTarRow,"flag")}
												   ,{col:"food_datetime", type:"STRING", size:256, val:utlf_rPad(ds_main_foodnewtranslist.getColumn(nTarRow,"dietdate"), 14, "0")}
												   ,{col:"status", type:"STRING", size:256, val:"i"}
													]);
			call_TXRNB00002();
			
			if(arErrorCode.pop("TXRNB00002") > -1) {
				cap_messege_title.style.background = "lightblue";
				cap_messege.text = "데이터 저장 처리되었습니다!"
				//ds_send_foodnewtrans.clearData();		
				grp_search.btn_search.click();		
			} else {
				cap_messege_title.style.background = "red";
				cap_messege.text = "데이터 처리에 실패하였습니다!"
			}
		}
	}
}

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

function rdo_flag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	var flag = e.postvalue=="0"?"07":e.postvalue=="1"?"14":"19";
	if(ds_send_foodnewtrans.getColumn(0, "dietdate").length < 8) {
		ds_send_foodnewtrans.setColumn(0, "dietdate", utlf_getCurrentDate());
	}
	ds_send_foodnewtrans.setColumn(0, "dietdate", ds_send_foodnewtrans.getColumn(0, "dietdate").substr(0,8) + flag);
}

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

function ds_send_foodnewtrans_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "id") {
		ds_temp_foodmaster.clearData();
		if(!utlf_isNull(e.newvalue)) {
			dsf_createDsRow("ds_req", 	[
										{col:"userid", type:"STRING", size:256, val:obj.getColumn(0,"id")}
									   ,{col:"instcd", type:"STRING", size:256, val:obj.getColumn(0,"instcd")}
										]);
			call_TRRNB00001();
			
			
		}
	}else if( e.columnid == "dietdate" ){
		if( utlf_transNullToEmpty(e.newvalue).length != 10 ){
			ipt_date.setFocus();
			sysf_messageBox("년월일시는 10자리만", "C001");
			obj.setColumn(e.row, e.columnid, e.oldvalue);
			
			return false;
		}
	}
}

function ds_main_foodnewtranslist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if( e.columnid == "flag" ){
		var flag = e.newvalue=="0"?"07":e.newvalue=="1"?"14":"19";
		if(obj.getColumn(e.row, "dietdate").length < 8) {
			obj.setColumn(e.row, "dietdate", utlf_getCurrentDate());
		}
		obj.setColumn(e.row, "dietdate",      obj.getColumn(e.row, "dietdate").substr(0,8) + flag);
		obj.setColumn(e.row, "food_datetime", obj.getColumn(e.row, "dietdate").substr(0,8) + flag + "0000");
	}else if(e.columnid == "id") {
		if( utlf_isNull(obj.getColumn(e.row, "id")) || utlf_transNullToEmpty(obj.getColumn(e.row, "id")).length < 5 ){
			grd_foodnewtranslist.setCellPos(3);
			grd_foodnewtranslist.setFocus();
			
			sysf_messageBox("ID는 5자리이상", "C001");
			
			return false;
		}
		
		ds_temp_foodmaster.clearData();
		
		if(!utlf_isNull(e.newvalue)) {
			dsf_createDsRow("ds_req", 	[
										{col:"userid", type:"STRING", size:256, val:obj.getColumn(e.row,"id")}
									   ,{col:"instcd", type:"STRING", size:256, val:obj.getColumn(e.row,"instcd")}
										]);
			call_TRRNB00001();
			
			obj.setColumn(e.row, "name", utlf_transNullToEmpty(ds_temp_foodmaster.getColumn(0, "name")).trim());
		}
// 	}else if( e.columnid == "dietdate" ){
// 		if( utlf_transNullToEmpty(e.newvalue).length != 10 ){
// 			grd_foodnewtranslist.setCellPos(1);
// 			grd_foodnewtranslist.setFocus();
// 			
// 			sysf_messageBox("년월일시는 10자리만", "C001");
// 			obj.setColumn(e.row, e.columnid, e.oldvalue);
// 			
// 			return false;
// 		}
// 		if( !utlf_isValidDateTime(obj.getColumn(e.row, "dietdate").substr(0,8), "YYYYMMDD")) {
// 			grd_foodnewtranslist.setCellPos(7);
// 			grd_foodnewtranslist.setFocus();
// 			
// 			sysf_messageBox("식사일시 형식이 맞지 않습니다. ","I007");
// 			obj.setColumn(e.row, e.columnid, e.oldvalue);
// 			
// 			return false;
// 		}
	}else if( e.columnid == "diet" ){
		obj.setColumn(e.row, "dietdate", e.newvalue+obj.getColumn(e.row, "dietdate").substr(8, 2));
	}
}


function btn_exceldown_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_foodnewtranslist, "식수조회", "식수", false, "", "user");	
}

function btn_excelup_onclick(obj:Button,  e:ClickEventInfo)
{	
	var sDiet     = "";
	var sDietDate = "";
	var sFlag     = "";
	var sFlagNm   = "";
	var sID       = "";
	var sName     = "";
	var sOcsId    = "";
	var sOcsIdNm  = "";
	var sInstCd   = "";
	var findRow   = -1;
	
	ds_uploadexcel.clearData();
	if( grdf_ImportExcel("ds_uploadexcel", 2, "") != false){
    	var rows = ds_uploadexcel.rowcount;
    	
    	if( rows <= 0 ){
    		sysf_messageBox("등록된 식수 정보가 없습니다","");
    		return;
    	}
    	
    	sInstCd = sysf_getUserInfo("dutplceinstcd");
    	
    	for( var i = rows - 1; i >= 0; i--) {
    	    sDiet    = ds_uploadexcel.getColumn(i, "diet");
    		sFlagNm  = ds_uploadexcel.getColumn(i, "flagnm");
    		sID      = ds_uploadexcel.getColumn(i, "id");
    		sName    = ds_uploadexcel.getColumn(i, "name");
    		sOcsIdNm = ds_uploadexcel.getColumn(i, "ocs_idnm");
    		
    		if(utlf_isNull(sDiet)){
				continue;
    		}
    		
    		sDiet = sDiet.replace("-", "");
    		if(utlf_isNull(sDiet) || sDiet.length < 8){
				sysf_messageBox("일자값이 잘못 등록되었습니다.","");
				return;
    		}
    		
    		sDiet = sDiet.substring(0, 8);
    		if(!utlf_isValidDateTime(sDiet, "YYYYMMDD")) {
    			sysf_messageBox("일자값이 유효한 날짜가 아닙니다.","");
				return;
    		}
    		
    		if(sDiet > utlf_getCurrentDate()) {
    			sysf_messageBox("오늘 이후 일자는 입력할수 없습니다.","");
				return;
    		}
    		
    		
    		if(sFlagNm == "조식") {
				sFlag     = "0";
				sDietDate = sDiet + "07";
    		} else if(sFlagNm == "중식") {
				sFlag     = "1";
				sDietDate = sDiet + "14";
    		} else if(sFlagNm == "석식") {
				sFlag     = "2";
				sDietDate = sDiet + "19";
    		} else {
				sysf_messageBox("식사구분이 잘못 입력 되었습니다.","");
				return;
    		}
    		
    		findRow = ds_init_placelist.findRow("cdnm", sOcsIdNm);
			sOcsId  = (findRow == -1) ? "" : ds_init_placelist.getColumn(findRow, "cdid");
			
			if(utlf_isNull(sOcsId)) {
				sysf_messageBox("식사장소가 잘못 입력 되었습니다.","");
				return;
			}

			ds_main_foodnewtranslist.insertRow(0);
			ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "instcd", 	 sInstCd);
			ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "dietdate", sDietDate);
			ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "diet", 	 sDiet);
			ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "flag",     sFlag);
			ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "id",       sID);
			ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "name",     sName);
			ds_main_foodnewtranslist.setColumn(ds_main_foodnewtranslist.rowposition, "ocs_id",   sOcsId);
		}
    }
}

function btn_excelsample_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_sampleexcel, "식수 업로드", "식수", false, "", "user");	
}
]]></Script>
  </Form>
</FDL>