YNU_JEUS/app_home/himed/xpapps/ast/dietxp/xp/SMANT02600_직원식상세현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMANT02600" position="absolute 0 0 1201 793" titletext="직원식상세현황" oninit="SMANT02600_oninit" onload="SMANT02600_onload">
    <Layouts>
      <Layout>
        <Tab position="absolute 0 26 1194 763" id="switch1" onchanged="switch1_onchanged">
          <Tabpages>
            <Tabpage text="ID카드식수" id="case1">
              <Layouts>
                <Layout>
                  <Div position="absolute 5 10 1187 45" align="align:center top;" id="group2" class="div_SA">
                    <Layouts>
                      <Layout>
                        <Static text="사원번호 :" position="absolute 866 10 955 27" id="caption2" class="search_name"/>
                        <Edit position="absolute 955 8 1040 27" id="ipt_emplno" class="input_search" autoselect="true" onkeydown="switch1_case1_group2_ipt_emplno_onkeydown"/>
                        <Button position="absolute 1122 7 1178 29" id="btn_search1" class="btn1" text="조회" onclick="switch1_case1_group2_btn_search1_onclick"/>
                        <Shape position="absolute 1103 7 1109 29" linetype="vertical" id="line13"/>
                        <Static text="일자 :" position="absolute 31 10 95 27" id="caption3" class="search_name"/>
                        <Calendar position="absolute 90 7 180 26" id="ipt_eatfromdd" class="input_s_essential" autoselect="true"/>
                        <Static text="~" position="absolute 185 9 197 26" id="caption11" class="search_n_b"/>
                        <Calendar position="absolute 200 7 290 26" id="ipt_eattodd" class="input_s_essential" autoselect="true"/>
                        <Static text="끼니 :" position="absolute 336 10 400 27" id="caption4" class="search_name"/>
                        <Radio position="absolute 398 8 595 27" id="rdo_mealflag" class="radio_search" columncount="4" rowcount="1" codecolumn="codecolumn" datacolumn="datacolumn">
                          <Dataset id="innerdataset">
                            <ColumnInfo>
                              <Column id="codecolumn"/>
                              <Column id="datacolumn"/>
                            </ColumnInfo>
                            <Rows>
                              <Row>
                                <Col id="codecolumn">-</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">3</Col>
                                <Col id="datacolumn">석식</Col>
                              </Row>
                            </Rows>
                          </Dataset>
                        </Radio>
                        <Static text="사원명 :" position="absolute 650 10 736 27" id="caption12" class="search_name"/>
                        <Edit position="absolute 725 8 805 27" id="ipt_hngnm" class="input_search" autoselect="true" onkeydown="switch1_case1_group2_ipt_hngnm_onkeydown"/>
                      </Layout>
                    </Layouts>
                  </Div>
                  <Shape position="absolute 5 69 1188 75" linetype="horizontal" id="line1" class="line_10"/>
                  <Grid position="absolute 5 74 1188 710" align="align:center middle;" id="grd_emplidcard" binddataset="ds_main_emplidcard_data">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="24"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="0"/>
                          <Column size="100"/>
                          <Column size="0"/>
                          <Column size="100"/>
                          <Column size="0"/>
                          <Column size="100"/>
                          <Column size="0"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell/>
                          <Cell col="1" text="일자"/>
                          <Cell col="2" text="사원명"/>
                          <Cell col="3" text="사원번호"/>
                          <Cell col="4" text="카드ID"/>
                          <Cell col="5" text="조식"/>
                          <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" expr="currow + 1"/>
                          <Cell col="1" displaytype="date" text="bind:eatdd" calendardisplaynulltype="none"/>
                          <Cell col="2" text="bind:hngnm"/>
                          <Cell col="3" text="bind:emplno"/>
                          <Cell col="4" text="bind:cardid"/>
                          <Cell col="5" text="bind:breakmeal"/>
                          <Cell col="6" text="bind:breakmealtm" mask="hh:nn:ss"/>
                          <Cell col="7" text="bind:lunchmeal"/>
                          <Cell col="8" text="bind:lunchmealtm" mask="hh:nn:ss"/>
                          <Cell col="9" text="bind:dinnermeal"/>
                          <Cell col="10" text="bind:dinnermealtm" mask="hh:nn:ss"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Button position="absolute 1025 47 1129 69" id="button1" class="btn1" text="자료가져오기" onclick="switch1_case1_button1_onclick"/>
                  <Grid position="absolute 20 200 1170 635" id="datagrid1" visible="false" binddataset="ds_main_empllist_emplinfo">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="60"/>
                          <Column size="100"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell text="caption1"/>
                          <Cell col="1" text="caption2"/>
                          <Cell col="2" text="caption3"/>
                          <Cell col="3" text="caption4"/>
                          <Cell col="4" text="caption5"/>
                          <Cell col="5" text="caption6"/>
                          <Cell col="6" text="caption7"/>
                          <Cell col="7" text="caption8"/>
                          <Cell col="8" text="caption9"/>
                          <Cell col="9" text="caption10"/>
                          <Cell col="10" text="emplflag"/>
                          <Cell col="11" text="usrnm"/>
                        </Band>
                        <Band id="body">
                          <Cell text="bind:instcd"/>
                          <Cell col="1" text="bind:emplinstcd"/>
                          <Cell col="2" text="bind:mealflag"/>
                          <Cell col="3" text="bind:seqno"/>
                          <Cell col="4" text="bind:emplno"/>
                          <Cell col="5" text="bind:cardid"/>
                          <Cell col="6" text="bind:eatdd"/>
                          <Cell col="7" text="bind:eattm"/>
                          <Cell col="8" text="bind:eatamt"/>
                          <Cell col="9" text="bind:readyn"/>
                          <Cell col="10" text="bind:emplflag"/>
                          <Cell col="11" text="bind:usrnm"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage text="기타식수관리" id="case2">
              <Layouts>
                <Layout>
                  <Div position="absolute 5 10 1187 45" align="align:center top;" id="group3" class="div_SA">
                    <Layouts>
                      <Layout>
                        <Static text="조회년월 :" position="absolute 31 10 120 27" id="caption5" class="search_name"/>
                        <MaskEdit position="absolute 120 8 205 27" align="align:center middle;" id="ipt_yyyymm" mask="####-##" autoselect="true" onkeydown="switch1_case2_group3_ipt_yyyymm_onkeydown" maskchar=" " type="string" style="align:center middle;"/>
                        <Button position="absolute 208 10 221 25" id="btn_before" class="icon_pre" text="" onclick="switch1_case2_group3_btn_before_onclick"/>
                        <Button position="absolute 223 10 236 25" id="btn_next" class="icon_next" text="" onclick="switch1_case2_group3_btn_next_onclick"/>
                        <Button position="absolute 1112 7 1168 29" id="btn_search2" class="btn1" text="조회" onclick="switch1_case2_group3_btn_search2_onclick"/>
                        <Shape position="absolute 1093 7 1099 29" linetype="vertical" id="line2"/>
                      </Layout>
                    </Layouts>
                  </Div>
                  <Shape position="absolute 5 69 1188 75" linetype="horizontal" id="line3" class="line_10"/>
                  <Grid position="absolute 5 74 1188 709" align="align:center middle;" id="grd_empletc" binddataset="ds_main_empletc_data">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="24"/>
                          <Column size="0"/>
                          <Column size="70"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="50"/>
                          <Column size="70"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24" band="head"/>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                          <Row size="24" band="summ"/>
                        </Rows>
                        <Band id="head">
                          <Cell rowspan="3" taborder="undefined"/>
                          <Cell col="1" rowspan="3" text="년월일" taborder="undefined"/>
                          <Cell col="2" rowspan="3" text="일자" taborder="undefined"/>
                          <Cell col="3" colspan="10" text="조식" taborder="undefined"/>
                          <Cell col="13" colspan="10" text="중식" taborder="undefined"/>
                          <Cell col="23" colspan="10" text="석식" taborder="undefined"/>
                          <Cell col="33" rowspan="3" text="총계" taborder="undefined"/>
                          <Cell row="1" col="3" colspan="3" text="본원" taborder="undefined"/>
                          <Cell row="1" col="6" colspan="6" text="외부" taborder="undefined"/>
                          <Cell row="1" col="12" rowspan="2" text="합계" taborder="undefined"/>
                          <Cell row="1" col="13" colspan="3" text="본원" taborder="undefined"/>
                          <Cell row="1" col="16" colspan="6" text="외부" taborder="undefined"/>
                          <Cell row="1" col="22" rowspan="2" text="합계" taborder="undefined"/>
                          <Cell row="1" col="23" colspan="3" text="본원" taborder="undefined"/>
                          <Cell row="1" col="26" colspan="6" text="외부" taborder="undefined"/>
                          <Cell row="1" col="32" rowspan="2" text="합계" taborder="undefined"/>
                          <Cell row="2" col="3" text="현금"/>
                          <Cell row="2" col="4" text="공용"/>
                          <Cell row="2" col="5" text="소계"/>
                          <Cell row="2" col="6" text="성의"/>
                          <Cell row="2" col="7" text="성모"/>
                          <Cell row="2" col="8" text="의정부"/>
                          <Cell row="2" col="9" text="부천"/>
                          <Cell row="2" col="10" text="기타"/>
                          <Cell row="2" col="11" text="소계"/>
                          <Cell row="2" col="13" text="현금"/>
                          <Cell row="2" col="14" text="공용"/>
                          <Cell row="2" col="15" text="소계"/>
                          <Cell row="2" col="16" text="성의"/>
                          <Cell row="2" col="17" text="성모"/>
                          <Cell row="2" col="18" text="의정부"/>
                          <Cell row="2" col="19" text="부천"/>
                          <Cell row="2" col="20" text="기타"/>
                          <Cell row="2" col="21" text="소계"/>
                          <Cell row="2" col="23" text="현금"/>
                          <Cell row="2" col="24" text="공용"/>
                          <Cell row="2" col="25" text="소계"/>
                          <Cell row="2" col="26" text="성의"/>
                          <Cell row="2" col="27" text="성모"/>
                          <Cell row="2" col="28" text="의정부"/>
                          <Cell row="2" col="29" text="부천"/>
                          <Cell row="2" col="30" text="기타"/>
                          <Cell row="2" col="31" text="소계"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="currow + 1"/>
                          <Cell col="1" text="bind:appdd"/>
                          <Cell col="2" displaytype="text" style="align:center middle;" text="bind:appmmdd" mask="##-##" maskchar=" "/>
                          <Cell col="3" displaytype="number" edittype="text" text="bind:psnno1"/>
                          <Cell col="4" displaytype="number" edittype="text" text="bind:psnno2"/>
                          <Cell col="5" displaytype="number" text="bind:insum1"/>
                          <Cell col="6" displaytype="number" edittype="text" text="bind:psnno3"/>
                          <Cell col="7" displaytype="number" edittype="text" text="bind:psnno4"/>
                          <Cell col="8" displaytype="number" edittype="text" text="bind:psnno5"/>
                          <Cell col="9" displaytype="number" edittype="text" text="bind:psnno6"/>
                          <Cell col="10" displaytype="number" edittype="text" text="bind:psnno7"/>
                          <Cell col="11" displaytype="number" text="bind:outsum1"/>
                          <Cell col="12" displaytype="number" text="bind:sum1"/>
                          <Cell col="13" displaytype="number" edittype="text" text="bind:psnno8"/>
                          <Cell col="14" displaytype="number" edittype="text" text="bind:psnno9"/>
                          <Cell col="15" displaytype="number" text="bind:insum2"/>
                          <Cell col="16" displaytype="number" edittype="text" text="bind:psnno10"/>
                          <Cell col="17" displaytype="number" edittype="text" text="bind:psnno11"/>
                          <Cell col="18" displaytype="number" edittype="text" text="bind:psnno12"/>
                          <Cell col="19" displaytype="number" edittype="text" text="bind:psnno13"/>
                          <Cell col="20" displaytype="number" edittype="text" text="bind:psnno14"/>
                          <Cell col="21" displaytype="number" text="bind:outsum2"/>
                          <Cell col="22" displaytype="number" text="bind:sum2"/>
                          <Cell col="23" displaytype="number" edittype="text" text="bind:psnno15"/>
                          <Cell col="24" displaytype="number" edittype="text" text="bind:psnno16"/>
                          <Cell col="25" displaytype="number" text="bind:insum3"/>
                          <Cell col="26" displaytype="number" edittype="text" text="bind:psnno17"/>
                          <Cell col="27" displaytype="number" edittype="text" text="bind:psnno18"/>
                          <Cell col="28" displaytype="number" edittype="text" text="bind:psnno19"/>
                          <Cell col="29" displaytype="number" edittype="text" text="bind:psnno20"/>
                          <Cell col="30" displaytype="number" edittype="text" text="bind:psnno21"/>
                          <Cell col="31" displaytype="number" text="bind:outsum3"/>
                          <Cell col="32" displaytype="number" text="bind:sum3"/>
                          <Cell col="33" displaytype="number" text="bind:totalsum"/>
                        </Band>
                        <Band id="summary">
                          <Cell/>
                          <Cell col="1"/>
                          <Cell col="2" text="계"/>
                          <Cell col="3" style="align:right middle;" expr="expr:getSum(&quot;psnno1&quot;)"/>
                          <Cell col="4" style="align:right middle;" expr="expr:getSum(&quot;psnno2&quot;)"/>
                          <Cell col="5" style="align:right middle;" expr="expr:getSum(&quot;insum1&quot;)"/>
                          <Cell col="6" style="align:right middle;" expr="expr:getSum(&quot;psnno3&quot;)"/>
                          <Cell col="7" style="align:right middle;" expr="expr:getSum(&quot;psnno4&quot;)"/>
                          <Cell col="8" style="align:right middle;" expr="expr:getSum(&quot;psnno5&quot;)"/>
                          <Cell col="9" style="align:right middle;" expr="expr:getSum(&quot;psnno6&quot;)"/>
                          <Cell col="10" style="align:right middle;" expr="expr:getSum(&quot;psnno7&quot;)"/>
                          <Cell col="11" style="align:right middle;" expr="expr:getSum(&quot;outsum1&quot;)"/>
                          <Cell col="12" style="align:right middle;" expr="expr:getSum(&quot;sum1&quot;)"/>
                          <Cell col="13" style="align:right middle;" expr="expr:getSum(&quot;psnno8&quot;)"/>
                          <Cell col="14" style="align:right middle;" expr="expr:getSum(&quot;psnno9&quot;)"/>
                          <Cell col="15" style="align:right middle;" expr="expr:getSum(&quot;insum2&quot;)"/>
                          <Cell col="16" style="align:right middle;" expr="expr:getSum(&quot;psnno10&quot;)"/>
                          <Cell col="17" style="align:right middle;" expr="expr:getSum(&quot;psnno11&quot;)"/>
                          <Cell col="18" style="align:right middle;" expr="expr:getSum(&quot;psnno12&quot;)"/>
                          <Cell col="19" style="align:right middle;" expr="expr:getSum(&quot;psnno13&quot;)"/>
                          <Cell col="20" style="align:right middle;" expr="expr:getSum(&quot;psnno14&quot;)"/>
                          <Cell col="21" style="align:right middle;" expr="expr:getSum(&quot;outsum2&quot;)"/>
                          <Cell col="22" style="align:right middle;" expr="expr:getSum(&quot;sum2&quot;)"/>
                          <Cell col="23" style="align:right middle;" expr="expr:getSum(&quot;psnno15&quot;)"/>
                          <Cell col="24" style="align:right middle;" expr="expr:getSum(&quot;psnno16&quot;)"/>
                          <Cell col="25" style="align:right middle;" expr="expr:getSum(&quot;insum3&quot;)"/>
                          <Cell col="26" style="align:right middle;" expr="expr:getSum(&quot;psnno17&quot;)"/>
                          <Cell col="27" style="align:right middle;" expr="expr:getSum(&quot;psnno18&quot;)"/>
                          <Cell col="28" style="align:right middle;" expr="expr:getSum(&quot;psnno19&quot;)"/>
                          <Cell col="29" style="align:right middle;" expr="expr:getSum(&quot;psnno20&quot;)"/>
                          <Cell col="30" style="align:right middle;" expr="expr:getSum(&quot;psnno21&quot;)"/>
                          <Cell col="31" style="align:right middle;" expr="expr:getSum(&quot;outsum3&quot;)"/>
                          <Cell col="32" style="align:right middle;" expr="expr:getSum(&quot;sum3&quot;)"/>
                          <Cell col="33" style="align:right middle;" expr="expr:getSum(&quot;totalsum&quot;)"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Button position="absolute 1132 102 1187 121" id="btn_excel" class="btn7" text="엑셀" onclick="btn_excel_onclick"/>
        <Static id="caption1" text="직원식상세현황" class="tit_1" position="absolute 0 0 189 25"/>
        <Button id="btn_save" taborder="1" text="저장" class="btn4" position="absolute 1133 766 1189 788" onclick="btn_save_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_emplidcard_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="eatdd" type="STRING" size="256"/>
          <Column id="hngnm" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="cardid" type="STRING" size="256"/>
          <Column id="breakmeal" type="STRING" size="256"/>
          <Column id="breakmealtm" type="STRING" size="256"/>
          <Column id="lunchmeal" type="STRING" size="256"/>
          <Column id="lunchmealtm" type="STRING" size="256"/>
          <Column id="dinnermeal" type="STRING" size="256"/>
          <Column id="dinnermealtm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="eatdd"/>
            <Col id="hngnm"/>
            <Col id="emplno"/>
            <Col id="cardid"/>
            <Col id="breakmeal"/>
            <Col id="breakmealtm"/>
            <Col id="lunchmeal"/>
            <Col id="lunchmealtm"/>
            <Col id="dinnermeal"/>
            <Col id="dinnermealtm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_empletc_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="appdd" type="STRING" size="256"/>
          <Column id="appmmdd" type="STRING" size="256"/>
          <Column id="psnno1" type="STRING" size="256"/>
          <Column id="psnno2" type="STRING" size="256"/>
          <Column id="insum1" type="STRING" size="256"/>
          <Column id="psnno3" type="STRING" size="256"/>
          <Column id="psnno4" type="STRING" size="256"/>
          <Column id="psnno5" type="STRING" size="256"/>
          <Column id="psnno6" type="STRING" size="256"/>
          <Column id="psnno7" type="STRING" size="256"/>
          <Column id="outsum1" type="STRING" size="256"/>
          <Column id="sum1" type="STRING" size="256"/>
          <Column id="psnno8" type="STRING" size="256"/>
          <Column id="psnno9" type="STRING" size="256"/>
          <Column id="insum2" type="STRING" size="256"/>
          <Column id="psnno10" type="STRING" size="256"/>
          <Column id="psnno11" type="STRING" size="256"/>
          <Column id="psnno12" type="STRING" size="256"/>
          <Column id="psnno13" type="STRING" size="256"/>
          <Column id="psnno14" type="STRING" size="256"/>
          <Column id="outsum2" type="STRING" size="256"/>
          <Column id="sum2" type="STRING" size="256"/>
          <Column id="psnno15" type="STRING" size="256"/>
          <Column id="psnno16" type="STRING" size="256"/>
          <Column id="insum3" type="STRING" size="256"/>
          <Column id="psnno17" type="STRING" size="256"/>
          <Column id="psnno18" type="STRING" size="256"/>
          <Column id="psnno19" type="STRING" size="256"/>
          <Column id="psnno20" type="STRING" size="256"/>
          <Column id="psnno21" type="STRING" size="256"/>
          <Column id="outsum3" type="STRING" size="256"/>
          <Column id="sum3" type="STRING" size="256"/>
          <Column id="totalsum" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="appdd"/>
            <Col id="appmmdd"/>
            <Col id="psnno1"/>
            <Col id="psnno2"/>
            <Col id="insum1"/>
            <Col id="psnno3"/>
            <Col id="psnno4"/>
            <Col id="psnno5"/>
            <Col id="psnno6"/>
            <Col id="psnno7"/>
            <Col id="outsum1"/>
            <Col id="sum1"/>
            <Col id="psnno8"/>
            <Col id="psnno9"/>
            <Col id="insum2"/>
            <Col id="psnno10"/>
            <Col id="psnno11"/>
            <Col id="psnno12"/>
            <Col id="psnno13"/>
            <Col id="psnno14"/>
            <Col id="outsum2"/>
            <Col id="sum2"/>
            <Col id="psnno15"/>
            <Col id="psnno16"/>
            <Col id="insum3"/>
            <Col id="psnno17"/>
            <Col id="psnno18"/>
            <Col id="psnno19"/>
            <Col id="psnno20"/>
            <Col id="psnno21"/>
            <Col id="outsum3"/>
            <Col id="sum3"/>
            <Col id="totalsum"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_empllist_emplinfo" 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="emplinstcd" type="STRING" size="256"/>
          <Column id="mealflag" type="STRING" size="256"/>
          <Column id="seqno" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="cardid" type="STRING" size="256"/>
          <Column id="eatdd" type="STRING" size="256"/>
          <Column id="eattm" type="STRING" size="256"/>
          <Column id="eatamt" type="STRING" size="256"/>
          <Column id="readyn" type="STRING" size="256"/>
          <Column id="emplflag" type="STRING" size="256"/>
          <Column id="usrnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="emplinstcd"/>
            <Col id="mealflag"/>
            <Col id="seqno"/>
            <Col id="emplno"/>
            <Col id="cardid"/>
            <Col id="eatdd"/>
            <Col id="eattm"/>
            <Col id="eatamt"/>
            <Col id="readyn"/>
            <Col id="emplflag"/>
            <Col id="usrnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_searchitem" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="eatfromdd" type="STRING" size="256"/>
          <Column id="eattodd" type="STRING" size="256"/>
          <Column id="mealflag" type="STRING" size="256"/>
          <Column id="hngnm" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="yyyymm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="eatfromdd"/>
            <Col id="eattodd"/>
            <Col id="mealflag"/>
            <Col id="hngnm"/>
            <Col id="emplno"/>
            <Col id="yyyymm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_data_empletc" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_data1_emplinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_basecode_meal_A0055" 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"/>
            <Col id="cdnm"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="switch1.case1.group2.ipt_eatfromdd" propid="value" datasetid="ds_send_searchitem" columnid="eatfromdd"/>
      <BindItem id="item1" compid="switch1.case1.group2.ipt_eattodd" propid="value" datasetid="ds_send_searchitem" columnid="eattodd"/>
      <BindItem id="item2" compid="switch1.case1.group2.rdo_mealflag" propid="value" datasetid="ds_send_searchitem" columnid="mealflag"/>
      <BindItem id="item3" compid="switch1.case1.group2.ipt_hngnm" propid="value" datasetid="ds_send_searchitem" columnid="hngnm"/>
      <BindItem id="item4" compid="switch1.case1.group2.ipt_emplno" propid="value" datasetid="ds_send_searchitem" columnid="emplno"/>
      <BindItem id="item5" compid="switch1.case2.group3.ipt_yyyymm" propid="value" datasetid="ds_send_searchitem" columnid="yyyymm"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-11-13
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-11-13      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";

var arErrorCode 	= new HashArray();

function SMANT02600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	//폼 초기화
}

function SMANT02600_onload(obj:Form, e:LoadEventInfo)
{
	finit();
	switch1.case1.group2.btn_search1.enable = frmf_checkAuth("R");
	switch1.case2.group3.btn_search2.enable = frmf_checkAuth("R");
	btn_save.enable = frmf_checkAuth("X");
	btn_excel.enable = frmf_checkAuth("P");
	btn_save.visible = false;
}

//초기화
function finit() {
	// 화면open시 공통코드 setting	
	var arrParam = [{dsNm: "ds_init_basecode_meal_A0055", cdGrpId: "A0055"}]
	appf_getCodeList(arrParam);
		
	ds_send_searchitem.setColumn(0, "eatfromdd", utlf_getCurrentDate());
	ds_send_searchitem.setColumn(0, "eattodd", utlf_getCurrentDate());
	ds_send_searchitem.setColumn(0, "mealflag", "-");
	ds_send_searchitem.setColumn(0, "yyyymm", utlf_getCurrentDate().substr(0,6));	
	ds_send_data1_emplinfo.clearData();
	ds_main_emplidcard_data.clearData();
	ds_main_empletc_data.clearData();		
	switch1.tabindex = 0;
}

function switch1_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
{
	if(switch1.tabindex == 0){
		btn_save.visible = false;
	}else if(switch1.tabindex == 1){
		btn_save.visible = true;
	}
}

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

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

function switch1_case1_group2_btn_search1_onclick(obj:Button,  e:ClickEventInfo)
{
	var fromdd = 	ds_send_searchitem.getColumn(0, "eatfromdd");
	var todd = 		ds_send_searchitem.getColumn(0, "eattodd");
	if (utlf_getDateInterval(fromdd, todd) < 0) {
		sysf_messageBox("조회 시작일은 종료일보다 클 수", "I004");
		return;
	} else {
		var oParam = {};
			oParam.id          = "TRANT02601";
			oParam.service     = "dietsumapp.DietSum";
			oParam.method      = "reqGetEmplDietDetl";
			oParam.inds        = "req=ds_send_searchitem";
			oParam.outds       = "ds_main_emplidcard_data=ret";
			oParam.async       = false;

		tranf_submit(oParam);
	}
}

function switch1_case1_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	var fromdd = 	ds_send_searchitem.getColumn(0, "eatfromdd");
	var todd = 		ds_send_searchitem.getColumn(0, "eattodd");
	if (utlf_getDateInterval(fromdd, todd) < 0) {
		sysf_messageBox("조회 시작일은 종료일보다 클 수", "I004");
		return;
	} else {		
		ds_main_empllist_emplinfo.clearData();
		
		var oParam = {};
			oParam.id          = "TRANT02603";
			oParam.service     = "dietsumapp.DietSum";
			oParam.method      = "reqGetEmplDiet";
			oParam.inds        = "req=ds_send_searchitem";
			oParam.outds       = "ds_main_empllist_emplinfo=emplinfo";
			oParam.async       = false;
			oParam.callback    = "cf_TRANT02603";

		tranf_submit(oParam);

		if (arErrorCode.pop("TRANT02603") > -1){			
			var updateData = grdf_getGridUpdateData(switch1.case1.datagrid1, "insert");
			ds_send_data1_emplinfo.copyData(updateData, true);
					
			var oParam = {};
				oParam.id          = "TXANT02602";
				oParam.service     = "dietsumapp.DietSum";
				oParam.method      = "reqExeEmplDiet";
				oParam.inds        = "req=ds_send_searchitem req1=ds_send_data1_emplinfo";
				oParam.outds       = "";
				oParam.async       = false;

			tranf_submit(oParam);
			
			var oParam = {};
				oParam.id          = "TRANT02601";
				oParam.service     = "dietsumapp.DietSum";
				oParam.method      = "reqGetEmplDietDetl";
				oParam.inds        = "req=ds_send_searchitem";
				oParam.outds       = "ds_main_emplidcard_data=ret";
				oParam.async       = false;				

			tranf_submit(oParam);
		}
	}
}

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

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	if ( switch1.tabindex == 0 ) {		
		grdf_exportExcel(switch1.case1.grd_emplidcard, "직원식ID카드현황" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);		
	} else if ( switch1.tabindex == 1 ) {		
		grdf_exportExcel(switch1.case2.grd_empletc, "직원식기타현황" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
	}
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{	
	var temp = grdf_getGridUpdateData(switch1.case2.grd_empletc);
	
	if ( temp.rowcount == 0) {
		sysf_messageBox("저장할 데이터가", "I004");
		return;						
	} else {
		if ( sysf_messageBox("", "Q002") == 6 ) {			
			ds_send_data_empletc.copyData(temp, true);
									
			var oParam = {};
				oParam.id          = "TXANT02601";
				oParam.service     = "dietsumapp.DietSum";
				oParam.method      = "reqExeEmplDietEtc";
				oParam.inds        = "req=ds_send_data_empletc";
				oParam.outds       = "";
				oParam.async       = false;				

			tranf_submit(oParam);
						
			switch1_case2_group3_btn_search2_onclick();//저장후 재조회			
		} else { return; }
	}
}

function switch1_case2_group3_btn_search2_onclick(obj:Button,  e:ClickEventInfo)
{
	if (utlf_isValidDateTime(ds_send_searchitem.getColumn(0, "yyyymm"), "YYYYMM") == false) {
		sysf_messageBox("조회년월의 형식이", "E016");		
		switch1.case2.group3.ipt_yyyymm.setFocus();
		return;
	}
	else {
		var oParam = {};
			oParam.id          = "TRANT02602";
			oParam.service     = "dietsumapp.DietSum";
			oParam.method      = "reqGetEmplDietEtc";
			oParam.inds        = "req=ds_send_searchitem";
			oParam.outds       = "ds_main_empletc_data=ret";
			oParam.async       = false;			

		tranf_submit(oParam);

		//row status가 null이기 때문에 무조건 'insert'로 초기화
		ds_main_empletc_data.enableevent = false;
		ds_main_empletc_data.updatecontrol = false;
		
		if(utlf_isNull(ds_main_empletc_data.getColumnInfo("insum1"))){
			ds_main_empletc_data.addColumn("insum1", "string");
			ds_main_empletc_data.addColumn("outsum1", "string");
			ds_main_empletc_data.addColumn("sum1", "string");
			
			ds_main_empletc_data.addColumn("insum2", "string");
			ds_main_empletc_data.addColumn("outsum2", "string");
			ds_main_empletc_data.addColumn("sum2", "string");
			
			ds_main_empletc_data.addColumn("insum3", "string");
			ds_main_empletc_data.addColumn("outsum3", "string");
			ds_main_empletc_data.addColumn("sum3", "string");
			
			ds_main_empletc_data.addColumn("totalsum", "string");
		}
		
		for (var i = 0; i < ds_main_empletc_data.rowcount; i++) {						
			
			ds_main_empletc_data.setRowType(i, 2);
		}
		ds_main_empletc_data.updatecontrol = true;
		ds_main_empletc_data.enableevent = true;
		
		fsum();     //소계,합계,총계 구하기
		
		//grd_empletc.subtotalPosition = "below";
// 		for (var i = 3; i <= 33; i++) {
// 			grd_empletc.subtotal("sum", -1, i, "#,###", "", 2, "계");
// 		}
		
	}
}

function fsum() {
	var val = 0;
	var temp = 0;
	var sum = 0;
	var totalsum = 0;
	for (var i = 0; i < ds_main_empletc_data.rowcount; i++) {
		//조식
		for (var k = 1; k <= 7; k++) {
			val = ds_main_empletc_data.getColumn(i, "psnno" + k);
			if (eval(val) > 0) {
				temp = parseInt(temp) + parseInt(val);
			}
			if (k == 2) {
				ds_main_empletc_data.setColumn(i, "insum1", temp);
				sum = sum + temp;
				temp = 0;
			} else if (k == 7) {
				ds_main_empletc_data.setColumn(i, "outsum1", temp);
				ds_main_empletc_data.setColumn(i, "sum1", sum + temp);
				totalsum = totalsum + sum + temp;
			}
		}
		temp = 0;
		sum = 0;
		//중식
		for (var k = 8; k <= 14; k++) {
			val = ds_main_empletc_data.getColumn(i, "psnno" + k);
			if (val > 0) {
				temp = parseInt(temp) + parseInt(val);
			}
			if (k == 9) {
				ds_main_empletc_data.setColumn(i, "insum2", temp);
				sum = sum + temp;
				temp = 0;
			} else if (k == 14) {
				ds_main_empletc_data.setColumn(i, "outsum2", temp);
				ds_main_empletc_data.setColumn(i, "sum2", sum + temp);
				totalsum = totalsum + sum + temp;
			}
		}
		temp = 0;
		sum = 0;
		//석식
		for (var k = 15; k <= 21; k++) {
			val = ds_main_empletc_data.getColumn(i, "psnno" + k);
			if (val > 0) {
				temp = parseInt(temp) + parseInt(val);
			}
			if (k == 16) {
				ds_main_empletc_data.setColumn(i, "insum3", temp);
				sum = sum + temp;
				temp = 0;
			} else if (k == 21) {
				ds_main_empletc_data.setColumn(i, "outsum3", temp);
				ds_main_empletc_data.setColumn(i, "sum3", sum + temp);
				totalsum = totalsum + sum + temp;
			}
		}
		temp = 0;
		sum = 0;
		ds_main_empletc_data.setColumn(i, "totalsum", totalsum);
		totalsum = 0;
	}	
}

function switch1_case2_group3_ipt_yyyymm_onkeydown(obj:MaskEdit, e:KeyEventInfo)
{
	if(e.keycode == 13){
		switch1_case2_group3_btn_search2_onclick();
	}
}

function switch1_case2_group3_btn_before_onclick(obj:Button,  e:ClickEventInfo)
{
	var dd = ds_send_searchitem.getColumn(0, "yyyymm") + "01";
	dd = dd.toDate().getAddDate(-1, "M");
	dd = dd.getDateFormat("YYYYMM");
	ds_send_searchitem.setColumn(0, "yyyymm", dd);	
}

function switch1_case2_group3_btn_next_onclick(obj:Button,  e:ClickEventInfo)
{
	var dd = ds_send_searchitem.getColumn(0, "yyyymm") + "01";
	dd = dd.toDate().getAddDate(1, "M");
	dd = dd.getDateFormat("YYYYMM");
	ds_send_searchitem.setColumn(0, "yyyymm", dd);
}
]]></Script>
  </Form>
</FDL>