YNU_JEUS/app_home/himed/xpapps/ast/examcurestatsxp/xp/SMAES02700_핵의학체내기간별통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAES02700" position="absolute 0 0 1194 776" titletext="기간별 통계" oninit="SMAES02700_oninit" onload="SMAES02700_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="기간별 통계" class="tit_1" position="absolute 0 0 200 23"/>
        <Div id="group1" taborder="1" class="div_SA" position="absolute 0 24 1187 54" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line2" linetype="vertical" class="line_4" position="absolute 1094 5 1100 25" anchor="top right"/>
              <Button id="button1" taborder="3" text="조회" class="btn1" position="absolute 1107 4 1163 26" anchor="top right" onclick="group1_button1_onclick"/>
              <Static id="caption2" text="조회기간 :" class="search_name" position="absolute 10 7 96 24" anchor="default"/>
              <Calendar id="ipt_todd" taborder="4" class="input_default" position="absolute 202 6 282 25" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="group1_ipt_todd_onchanged" autoselect="true"/>
              <Static id="caption5" text="~" class="search_no_b" position="absolute 187 6 199 23" anchor="default"/>
              <Calendar id="ipt_fromdd" taborder="5" class="input_default" position="absolute 104 6 184 25" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="group1_ipt_fromdd_onchanged" autoselect="true"/>
              <Combo id="cmb_excuroomgrp" taborder="6" innerdataset="@ds_init_initexcuroomgrp" codecolumn="basecdcnts" datacolumn="basecdcnts2" class="combo_default" position="absolute 390 6 508 25" anchor="default"/>
              <Static id="caption7" text="검사실 :" class="search_name" position="absolute 310 7 390 24" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Tab id="switch1" taborder="2" tabindex="0" position="absolute 0 73 1185 769" anchor="all">
          <Tabpages>
            <Tabpage id="case1" text="검사">
              <Layouts>
                <Layout>
                  <Grid id="grd_examlist" taborder="0" binddataset="ds_main_list_item" useinputpanel="false" cellsizingtype="col" position="absolute 0 15 1183 637" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="22"/>
                          <Column size="100"/>
                          <Column size="240"/>
                          <Column size="40"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="47"/>
                          <Column size="64"/>
                          <Column size="71"/>
                          <Column size="64"/>
                        </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" text="2006년" taborder="undefined"/>
                          <Cell col="5" text="2006년" taborder="undefined"/>
                          <Cell col="6" text="2006년" taborder="undefined"/>
                          <Cell col="7" text="2006년" taborder="undefined"/>
                          <Cell col="8" text="2006년" taborder="undefined"/>
                          <Cell col="9" text="2006년" taborder="undefined"/>
                          <Cell col="10" text="2006년" taborder="undefined"/>
                          <Cell col="11" text="2006년" taborder="undefined"/>
                          <Cell col="12" text="2006년" taborder="undefined"/>
                          <Cell col="13" text="2006년" taborder="undefined"/>
                          <Cell col="14" text="2007년" taborder="undefined"/>
                          <Cell col="15" text="2007년" taborder="undefined"/>
                          <Cell col="16" rowspan="2" text="합계" taborder="undefined"/>
                          <Cell col="17" rowspan="2" text="비교기간&#13;&#10;내건수" taborder="undefined"/>
                          <Cell col="18" rowspan="2" text="증감율" taborder="undefined"/>
                          <Cell row="1" col="4" text="3월"/>
                          <Cell row="1" col="5" text="4월"/>
                          <Cell row="1" col="6" text="5월"/>
                          <Cell row="1" col="7" text="6월"/>
                          <Cell row="1" col="8" text="7월"/>
                          <Cell row="1" col="9" text="8월"/>
                          <Cell row="1" col="10" text="9월"/>
                          <Cell row="1" col="11" text="10월"/>
                          <Cell row="1" col="12" text="11월"/>
                          <Cell row="1" col="13" text="12월"/>
                          <Cell row="1" col="14" text="1월"/>
                          <Cell row="1" col="15" text="2월"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="currow+1"/>
                          <Cell col="1" text="bind:excuroomnm"/>
                          <Cell col="2" text="bind:prcpnm"/>
                          <Cell col="3" text="bind:flag"/>
                          <Cell col="4" text="bind:month1"/>
                          <Cell col="5" text="bind:month2"/>
                          <Cell col="6" text="bind:month3"/>
                          <Cell col="7" text="bind:month4"/>
                          <Cell col="8" text="bind:month5"/>
                          <Cell col="9" text="bind:month6"/>
                          <Cell col="10" text="bind:month7"/>
                          <Cell col="11" text="bind:month8"/>
                          <Cell col="12" text="bind:month9"/>
                          <Cell col="13" text="bind:month10"/>
                          <Cell col="14" text="bind:month11"/>
                          <Cell col="15" text="bind:month12"/>
                          <Cell col="16" text="bind:sumcnt"/>
                          <Cell col="17" text="bind:comparecnt"/>
                          <Cell col="18" text="bind:comparerate"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="case2" text="치료">
              <Layouts>
                <Layout>
                  <Grid id="grd_isublist" taborder="1" binddataset="ds_main_isublist_item" useinputpanel="false" position="absolute 0 470 258 610" autofittype="col" cellsizingtype="col">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="75"/>
                          <Column size="90"/>
                          <Column size="90"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell text="구분"/>
                          <Cell col="1" text="처방량"/>
                          <Cell col="2" text="건수"/>
                        </Band>
                        <Band id="body">
                          <Cell displaytype="combo" edittype="combo" text="bind:ioflag" combodataset="ds_cmb_ioflag" combocodecol="value" combodatacol="label" enable="false"/>
                          <Cell col="1" text="bind:drugqty"/>
                          <Cell col="2" text="bind:cnt"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Grid id="grd_osublist" taborder="2" binddataset="ds_main_osublist_item" useinputpanel="false" position="absolute 260 470 518 610" autofittype="col" cellsizingtype="col">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="75"/>
                          <Column size="90"/>
                          <Column size="90"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell text="구분"/>
                          <Cell col="1" text="처방량"/>
                          <Cell col="2" text="건수"/>
                        </Band>
                        <Band id="body">
                          <Cell displaytype="combo" edittype="combo" text="bind:ioflag" combodataset="ds_cmb_ioflag" combocodecol="value" combodatacol="label" enable="false"/>
                          <Cell col="1" text="bind:drugqty"/>
                          <Cell col="2" text="bind:cnt"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Static id="caption1" text="외래합계" class="cell_1" position="absolute 260 613 387 636"/>
                  <Static id="caption4" text="총합계" class="cell_1" position="absolute 0 639 127 662"/>
                  <Edit id="input1" taborder="3" position="absolute 129 615 258 634"/>
                  <Edit id="input2" taborder="4" position="absolute 389 615 518 634"/>
                  <Edit id="input3" taborder="5" position="absolute 129 641 518 660"/>
                  <Static id="caption8" text="병실합계" class="cell_1" position="absolute 0 613 127 636"/>
                  <Grid id="grd_curelist" taborder="6" binddataset="ds_main_curelist_item" useinputpanel="false" position="absolute 0 15 1183 464" cellsizingtype="col">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="23"/>
                          <Column size="66"/>
                          <Column size="67"/>
                          <Column size="67"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="75"/>
                          <Column size="75"/>
                          <Column size="75"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                          <Row size="24" band="summ"/>
                        </Rows>
                        <Band id="head">
                          <Cell rowspan="2" taborder="undefined"/>
                          <Cell col="1" rowspan="2" text="구분" taborder="undefined"/>
                          <Cell col="2" rowspan="2" text="병실" taborder="undefined"/>
                          <Cell col="3" rowspan="2" text="처방량" taborder="undefined"/>
                          <Cell col="4" text="2006년" taborder="undefined"/>
                          <Cell col="5" text="2006년" taborder="undefined"/>
                          <Cell col="6" text="2006년" taborder="undefined"/>
                          <Cell col="7" text="2006년" taborder="undefined"/>
                          <Cell col="8" text="2006년" taborder="undefined"/>
                          <Cell col="9" text="2006년" taborder="undefined"/>
                          <Cell col="10" text="2006년" taborder="undefined"/>
                          <Cell col="11" text="2006년" taborder="undefined"/>
                          <Cell col="12" text="2006년" taborder="undefined"/>
                          <Cell col="13" text="2006년" taborder="undefined"/>
                          <Cell col="14" text="2007년" taborder="undefined"/>
                          <Cell col="15" text="2007년" taborder="undefined"/>
                          <Cell col="16" rowspan="2" text="합계" taborder="undefined"/>
                          <Cell col="17" rowspan="2" text="비교기간&#13;&#10;내건수" taborder="undefined"/>
                          <Cell col="18" rowspan="2" text="증감율" taborder="undefined"/>
                          <Cell row="1" col="4" text="3월"/>
                          <Cell row="1" col="5" text="4월"/>
                          <Cell row="1" col="6" text="5월"/>
                          <Cell row="1" col="7" text="6월"/>
                          <Cell row="1" col="8" text="7월"/>
                          <Cell row="1" col="9" text="8월"/>
                          <Cell row="1" col="10" text="9월"/>
                          <Cell row="1" col="11" text="10월"/>
                          <Cell row="1" col="12" text="11월"/>
                          <Cell row="1" col="13" text="12월"/>
                          <Cell row="1" col="14" text="1월"/>
                          <Cell row="1" col="15" text="2월"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="currow+1"/>
                          <Cell col="1" displaytype="combo" edittype="combo" text="bind:ioflag" combodataset="ds_cmb_ioflag" combocodecol="value" combodatacol="label" enable="false"/>
                          <Cell col="2" text="bind:roomcd"/>
                          <Cell col="3" text="bind:drugqty"/>
                          <Cell col="4" text="bind:month1"/>
                          <Cell col="5" text="bind:month2"/>
                          <Cell col="6" text="bind:month3"/>
                          <Cell col="7" text="bind:month4"/>
                          <Cell col="8" text="bind:month5"/>
                          <Cell col="9" text="bind:month6"/>
                          <Cell col="10" text="bind:month7"/>
                          <Cell col="11" text="bind:month8"/>
                          <Cell col="12" text="bind:month9"/>
                          <Cell col="13" text="bind:month10"/>
                          <Cell col="14" text="bind:month11"/>
                          <Cell col="15" text="bind:month12"/>
                          <Cell col="16" text="bind:sumcnt"/>
                          <Cell col="17" text="bind:comparecnt"/>
                          <Cell col="18" text="bind:comparerate"/>
                        </Band>
                        <Band id="summary">
                          <Cell/>
                          <Cell col="1" colspan="3" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="총계" taborder="undefined"/>
                          <Cell col="4" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month1')"/>
                          <Cell col="5" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month2')"/>
                          <Cell col="6" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month3')"/>
                          <Cell col="7" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month4')"/>
                          <Cell col="8" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month5')"/>
                          <Cell col="9" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month6')"/>
                          <Cell col="10" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month7')"/>
                          <Cell col="11" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month8')"/>
                          <Cell col="12" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month9')"/>
                          <Cell col="13" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month10')"/>
                          <Cell col="14" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month11')"/>
                          <Cell col="15" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('month12')"/>
                          <Cell col="16" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('sumcnt')"/>
                          <Cell col="17" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:getSum('comparecnt')"/>
                          <Cell col="18" displaytype="number" style="color:#0000ffff;color2:#0000ffff;font:arial,9,bold;" text="expr:Math.floor(((getSum('sumcnt') - getSum('comparecnt')) / getSum('comparecnt')) * 100)"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Button id="btn_excsave" taborder="3" text="엑셀저장" class="btn7" position="absolute 1105 76 1185 95" anchor="top right" onclick="btn_excsave_onclick"/>
        <Shape id="line1" class="line_10" position="absolute 0 110 1185 116" anchor="left top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="execfromdd" type="STRING" size="256"/>
          <Column id="exectodd" type="STRING" size="256"/>
          <Column id="excuroomgrpcdid" type="STRING" size="256"/>
          <Column id="comparefromdd" type="STRING" size="256"/>
          <Column id="comparetodd" type="STRING" size="256"/>
          <Column id="suppdeptcd" type="STRING" size="256"/>
          <Column id="systkey6" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="execfromdd"/>
            <Col id="exectodd"/>
            <Col id="excuroomgrpcdid"/>
            <Col id="comparefromdd"/>
            <Col id="comparetodd"/>
            <Col id="suppdeptcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_initexcuroomgrp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="basecdcnts" type="STRING" size="256" sumtext="검사그룹코드"/>
          <Column id="basecdcnts2" type="STRING" size="256" sumtext="검사그룹코드명"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_ioflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">입원</Col>
            <Col id="value">I</Col>
          </Row>
          <Row>
            <Col id="label">외래</Col>
            <Col id="value">O</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="excuroomnm" type="STRING" size="256" sumtext="검사실"/>
          <Column id="prcpnm" type="STRING" size="256" sumtext="검사항목"/>
          <Column id="flag" type="STRING" size="256" sumtext="구분"/>
          <Column id="month1" type="STRING" size="256" sumtext="1번째 월"/>
          <Column id="month2" type="STRING" size="256" sumtext="2번째 월"/>
          <Column id="month3" type="STRING" size="256" sumtext="3번째 월"/>
          <Column id="month4" type="STRING" size="256" sumtext="4번째 월"/>
          <Column id="month5" type="STRING" size="256" sumtext="5번째 월"/>
          <Column id="month6" type="STRING" size="256" sumtext="6번째 월"/>
          <Column id="month7" type="STRING" size="256" sumtext="7번째 월"/>
          <Column id="month8" type="STRING" size="256" sumtext="8번째 월"/>
          <Column id="month9" type="STRING" size="256" sumtext="9번째 월"/>
          <Column id="month10" type="STRING" size="256" sumtext="10번째 월"/>
          <Column id="month11" type="STRING" size="256" sumtext="11번째 월"/>
          <Column id="month12" type="STRING" size="256" sumtext="12번째 월"/>
          <Column id="sumcnt" type="STRING" size="256" sumtext="당해년계"/>
          <Column id="comparecnt" type="STRING" size="256" sumtext="비교기간건수"/>
          <Column id="comparerate" type="STRING" size="256" sumtext="증감율"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_curelist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="ioflag" type="STRING" size="256" sumtext="구분"/>
          <Column id="roomcd" type="STRING" size="256" sumtext="병실"/>
          <Column id="drugqty" type="STRING" size="256" sumtext="용량"/>
          <Column id="month1" type="STRING" size="256" sumtext="1번째 월"/>
          <Column id="month2" type="STRING" size="256" sumtext="2번째 월"/>
          <Column id="month3" type="STRING" size="256" sumtext="3번째 월"/>
          <Column id="month4" type="STRING" size="256" sumtext="4번째 월"/>
          <Column id="month5" type="STRING" size="256" sumtext="5번째 월"/>
          <Column id="month6" type="STRING" size="256" sumtext="6번째 월"/>
          <Column id="month7" type="STRING" size="256" sumtext="7번째 월"/>
          <Column id="month8" type="STRING" size="256" sumtext="8번째 월"/>
          <Column id="month9" type="STRING" size="256" sumtext="9번째 월"/>
          <Column id="month10" type="STRING" size="256" sumtext="10번째 월"/>
          <Column id="month11" type="STRING" size="256" sumtext="11번째 월"/>
          <Column id="month12" type="STRING" size="256" sumtext="12번째 월"/>
          <Column id="sumcnt" type="STRING" size="256" sumtext="당해년계"/>
          <Column id="comparecnt" type="STRING" size="256" sumtext="비교기간건수"/>
          <Column id="comparerate" type="STRING" size="256" sumtext="증감율"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_examsum" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="isum" type="STRING" size="256"/>
          <Column id="osum" type="STRING" size="256"/>
          <Column id="total" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_sublist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="ioflag" type="STRING" size="256" sumtext="IOFLAG"/>
          <Column id="drugqty" type="STRING" size="256" sumtext="처방량"/>
          <Column id="cnt" type="STRING" size="256" sumtext="건수"/>
          <Column id="total" type="STRING" size="256" sumtext="합계"/>
        </ColumnInfo>
      </Dataset>
      <FilteredDataset id="ds_main_isublist_item" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" filterstr="ioflag == 'I'" binddataset="@ds_main_sublist_item"/>
      <FilteredDataset id="ds_main_osublist_item" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" binddataset="@ds_main_sublist_item" filterstr="ioflag == 'O'"/>
      <Dataset id="ds_req" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="excuroomgrpcdid" type="STRING" size="256" sumtext="검사실그룹코드"/>
          <Column id="basesuppdeptcd" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="rbasecdflag" type="STRING" size="256" sumtext="검사실기본코드구분,검사실"/>
          <Column id="kbasecdflag" type="STRING" size="256" sumtext="검사실기본코드구분,장비코드"/>
          <Column id="nbasecdflag" type="STRING" size="256" sumtext="핵종코드"/>
          <Column id="initflag" type="STRING" size="256" sumtext="astlib,병동병실코드구분,1:병동조회"/>
          <Column id="alladdyn" type="STRING" size="256" sumtext="검사살전체선택"/>
          <Column id="flag" type="STRING" size="256" sumtext="검사살전체선택"/>
          <Column id="baseroomflag" type="STRING" size="256" sumtext="검사실구분코드"/>
          <Column id="srchflag" type="STRING" size="256" sumtext="조회구분"/>
          <Column id="basecdcnts" type="STRING" size="256" sumtext="검사실그룹코드"/>
          <Column id="ebasecdflag" type="STRING" size="256" sumtext="실시자기본코드구분"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="switch1.case2.input2" propid="value" datasetid="ds_main_examsum" columnid="osum"/>
      <BindItem id="item1" compid="switch1.case2.input1" propid="value" datasetid="ds_main_examsum" columnid="isum"/>
      <BindItem id="item2" compid="switch1.case2.input3" propid="value" datasetid="ds_main_examsum" columnid="total"/>
      <BindItem id="item3" compid="group1.ipt_fromdd" propid="value" datasetid="ds_send" columnid="execfromdd"/>
      <BindItem id="item4" compid="group1.ipt_todd" propid="value" datasetid="ds_send" columnid="exectodd"/>
      <BindItem id="item5" compid="group1.cmb_excuroomgrp" propid="value" datasetid="ds_send" columnid=""/>
    </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";
include "ast_examcurexp::AEZ0001.xjs";
var vSuppdeptcd;
function SMAES02700_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAES02700_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(switch1.case1.grd_examlist);
	grdf_initGrid(switch1.case2.grd_curelist);
	grdf_initGrid(switch1.case2.grd_isublist);
	grdf_initGrid(switch1.case2.grd_osublist);
	
	lf_aezfSetSuppDeptcd();
	
	vSuppdeptcd = frmf_getPrestDeptCd();
	
	ds_send.setColumn(0, "suppdeptcd", vSuppdeptcd);
	var fromdd01 = utlf_getCurrentDate().substr(0,4) + "0101";
	var todd12 = utlf_getCurrentDate().substr(0,4) + "1231";
	
	ds_send.setColumn(0, "execfromdd", fromdd01.toDate().getDateFormat("YYYYMM"));
	ds_send.setColumn(0, "exectodd", todd12.toDate().getDateFormat("YYYYMM"));
	
	ds_req.setColumn(0, "basesuppdeptcd", vSuppdeptcd);
	
	dsf_setFixVal(ds_req, "rbasecdflag:R,kbasecdflag:J,nbasecdflag:N,initflag:1,alladdyn:Y,baseroomflag:1,srchflag:A");
                                                       
	var oParam = {};
		oParam.id          = "TRAES09001";
		oParam.service     = "examcurestatsapp.NmedStats";
		oParam.method      = "reqGetCode";
		oParam.inds        = "req=ds_req";
		oParam.outds       = "ds_init_initexcuroomgrp=initexcuroomgrp";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAES09001";

	tranf_submit(oParam);
	
	frmf_addComboItem("group1.cmb_excuroomgrp","--전체--","","above");
	group1.cmb_excuroomgrp.index = 0;
	
	setTitle();
}

function setTitle() 
{
	ds_main_list_item.clearData();
	ds_main_curelist_item.clearData();
	ds_main_isublist_item.clearData();
	ds_main_osublist_item.clearData();
	ds_main_examsum.clearData();
	
	var stYearMonth = ds_send.getColumn(0, "execfromdd") + "01";
	var dtYearMonth = stYearMonth.toDate();
	var stEndMonth = ds_send.getColumn(0, "exectodd") + "01";
	var dtEndMonth = stEndMonth.toDate();
	
	var stYearHeader = "";
	var stMonthHeader = "";
	
	for (var i = 4; i < 16; i++) 
	{	
		var stYear = dtYearMonth.getDateFormat("YYYY");
		var stMonth = dtYearMonth.getDateFormat("MM");
	
		stYearHeader = stYear + "년";
		stMonthHeader = stMonth + "월";
		
		if(dtYearMonth.getDateFormat("YYYYMM") > dtEndMonth.getDateFormat("YYYYMM")) 
		{
			switch1.case1.grd_examlist.setFormatColProperty(i, "size", 0);
		} 
		else 
		{
			switch1.case1.grd_examlist.setCellProperty("Head", i, "text", stYearHeader);
			switch1.case1.grd_examlist.setCellProperty("Head", i+15, "text", stMonthHeader);
			switch1.case1.grd_examlist.setFormatColProperty(i, "size", 47);
		}
		dtYearMonth.getAddDate(1, "M");
 	}
 	
	ds_send.setColumn(0, "comparefromdd",  stYearMonth.toDate().getAddDate(-12, "M").getDateFormat("YYYYMM"));
	ds_send.setColumn(0, "comparetodd",  stEndMonth.toDate().getAddDate(-12, "M").getDateFormat("YYYYMM"));
	
	var comparefromdd = ds_send.getColumn(0, "comparefromdd");
	var comparetodd = ds_send.getColumn(0, "comparetodd");
	
	var stYearMonth = ds_send.getColumn(0, "execfromdd") + "01";
	var dtYearMonth = stYearMonth.toDate();
	var stEndMonth = ds_send.getColumn(0, "exectodd") + "01";
	var dtEndMonth = stEndMonth.toDate();
	
	var stYearHeader = "";
	var stMonthHeader = "";
		
	for (var i = 4; i < 16; i++) 
	{
		var stYear = dtYearMonth.getDateFormat("YYYY");
		var stMonth = dtYearMonth.getDateFormat("MM");
		
		stYearHeader = stYear + "년";
		stMonthHeader = stMonth + "월";
		
		if(dtYearMonth.getDateFormat("YYYYMM") > dtEndMonth.getDateFormat("YYYYMM")) 
		{
			switch1.case2.grd_curelist.setFormatColProperty(1+i, "size", 0);
		} 
		else 
		{
			switch1.case2.grd_curelist.setCellProperty("Head", i, "text", stYearHeader);
			switch1.case2.grd_curelist.setCellProperty("Head", i+15, "text", stMonthHeader);
			switch1.case2.grd_curelist.setFormatColProperty(1+i, "size", 60);
		}
		dtYearMonth.getAddDate(1, "M");
	}
}

function group1_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var execfromdd = (ds_send.getColumn(0, "execfromdd") + "01").toDate();
	var exectodd = (ds_send.getColumn(0, "exectodd") + "01").toDate();
	
	if(execfromdd < exectodd.getAddDate(-11, "M")) 
	{
		sysf_messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
		execfromdd = exectodd;
	}
	
	ds_send.setColumn(0, "execfromdd", execfromdd.getDateFormat("YYYYMM"));
	execfromdd = execfromdd.getAddDate(-12, "M");
	execfromdd = execfromdd.getDateFormat("YYYYMM");

	setTitle();
}

function group1_ipt_todd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var execfromdd = (ds_send.getColumn(0, "execfromdd") + "01").toDate();
	var exectodd = (ds_send.getColumn(0, "exectodd") + "01").toDate();
	
	if(execfromdd.getAddDate(11, "M") < exectodd) 
	{
		sysf_messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
		exectodd = execfromdd;
	}
	
	ds_send.setColumn(0, "exectodd", exectodd.getDateFormat("YYYYMM"));
	exectodd = exectodd.getAddDate(-12, "M");
	exectodd = exectodd.getDateFormat("YYYYMM");
	
	setTitle();
}

function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	if(switch1.tabindex == 0)
	{
		grdf_exportExcel(switch1.case1.grd_examlist, "", "");
	}
	else
	{
		grdf_exportExcel(switch1.case2.grd_curelist, "", "");
	}
}

function group1_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	setTitle();
	
	dsf_setFixVal(ds_send, "systkey6:701");

	var oParam = {};
		oParam.id          = "TRAES02701";
		oParam.service     = "examcurestatsapp.NmedStats";
		oParam.method      = "reqGetNmedStatsTermCaseList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_list_item=item ds_main_curelist_item=curelist ds_main_sublist_item=sublist";
		oParam.async       = false;
		oParam.callback    = "cf_TRAES02701";

	tranf_submit(oParam);
}

function cf_TRAES02701(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
	{	
		return;
	}
	else
	{
		var cnt = ds_main_curelist_item.rowcount;
								
		if (cnt > 0) 
		{
			var ioflag = "";
			var iSum = 0;
			var oSum = 0;
			var total = 0;
			var rowCnt = ds_main_sublist_item.rowcount;
			
			if (cnt > 0) 
			{
				for (var i = 0; i < rowCnt; i++) 
				{					
					ioflag = ds_main_sublist_item.getColumn(i, "ioflag");
					
					if (ioflag == "I") 
					{
						iSum = iSum + eval(ds_main_sublist_item.getColumn(i, "cnt"));
					} 
					else  if (ioflag == "O") 
					{
						oSum = oSum + eval(ds_main_sublist_item.getColumn(i, "cnt"));
					}
				}
				total = eval(iSum) + eval(oSum);
				
				ds_main_examsum.setColumn(0, "isum", iSum);
				ds_main_examsum.setColumn(0, "osum", osum);
				ds_main_examsum.setColumn(0, "total", total);
			}
		}
	}
}]]></Script>
  </Form>
</FDL>