YNU_JEUS/app_home/himed/xpapps/lis/statsmngtxp/xp/SMLLS01100_부서별통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMLLS01100" position="absolute 0 0 1211 810" titletext="부서별 통계" onload="SMLLS01100_onload">
    <Layouts>
      <Layout>
        <Tab id="swt_statflag" class="sw_box" position="absolute 0 132 1208 805" anchor="all" positiontype="position" onchanged="swt_statflag_onchanged" visible="true">
          <Tabpages>
            <Tabpage id="dd" text="일별 통계">
              <Layouts>
                <Layout width="1216" height="646">
                  <Grid id="grd_dd" position="absolute 0 0 1207 646" style="align:center middle;" anchor="all" positiontype="position" onclick="grd_dd_onclick" binddataset="ds_grid_grd_dd" oncellclick="swt_statflag_dd_grd_dd_oncellclick" cellsizingtype="col">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="30" band="left"/>
                          <Column size="100" band="left"/>
                          <Column size="200" band="left"/>
                          <Column size="80" band="left"/>
                          <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="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="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                          <Column size="60"/>
                        </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="Total"/>
                          <Cell col="4" text="01"/>
                          <Cell col="5" text="02"/>
                          <Cell col="6" text="03"/>
                          <Cell col="7" text="04"/>
                          <Cell col="8" text="05"/>
                          <Cell col="9" text="06"/>
                          <Cell col="10" text="07"/>
                          <Cell col="11" text="08"/>
                          <Cell col="12" text="09"/>
                          <Cell col="13" text="10"/>
                          <Cell col="14" text="11"/>
                          <Cell col="15" text="12"/>
                          <Cell col="16" text="13"/>
                          <Cell col="17" text="14"/>
                          <Cell col="18" text="15"/>
                          <Cell col="19" text="16"/>
                          <Cell col="20" text="17"/>
                          <Cell col="21" text="18"/>
                          <Cell col="22" text="19"/>
                          <Cell col="23" text="20"/>
                          <Cell col="24" text="21"/>
                          <Cell col="25" text="22"/>
                          <Cell col="26" text="23"/>
                          <Cell col="27" text="24"/>
                          <Cell col="28" text="25"/>
                          <Cell col="29" text="26"/>
                          <Cell col="30" text="27"/>
                          <Cell col="31" text="28"/>
                          <Cell col="32" text="29"/>
                          <Cell col="33" text="30"/>
                          <Cell col="34" text="31"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="expr:currow+1"/>
                          <Cell col="1" text="bind:sectnm"/>
                          <Cell col="2" style="align:left middle;" text="bind:tclsscrnnm"/>
                          <Cell col="3" style="align:right middle;" text="bind:total"/>
                          <Cell col="4" style="align:right middle;" text="bind:d01"/>
                          <Cell col="5" style="align:right middle;" text="bind:d02"/>
                          <Cell col="6" style="align:right middle;" text="bind:d03"/>
                          <Cell col="7" style="align:right middle;" text="bind:d04"/>
                          <Cell col="8" style="align:right middle;" text="bind:d05"/>
                          <Cell col="9" style="align:right middle;" text="bind:d06"/>
                          <Cell col="10" style="align:right middle;" text="bind:d07"/>
                          <Cell col="11" style="align:right middle;" text="bind:d08"/>
                          <Cell col="12" style="align:right middle;" text="bind:d09"/>
                          <Cell col="13" style="align:right middle;" text="bind:d10"/>
                          <Cell col="14" style="align:right middle;" text="bind:d11"/>
                          <Cell col="15" style="align:right middle;" text="bind:d12"/>
                          <Cell col="16" style="align:right middle;" text="bind:d13"/>
                          <Cell col="17" style="align:right middle;" text="bind:d14"/>
                          <Cell col="18" style="align:right middle;" text="bind:d15"/>
                          <Cell col="19" style="align:right middle;" text="bind:d16"/>
                          <Cell col="20" style="align:right middle;" text="bind:d17"/>
                          <Cell col="21" style="align:right middle;" text="bind:d18"/>
                          <Cell col="22" style="align:right middle;" text="bind:d19"/>
                          <Cell col="23" style="align:right middle;" text="bind:d20"/>
                          <Cell col="24" style="align:right middle;" text="bind:d21"/>
                          <Cell col="25" style="align:right middle;" text="bind:d22"/>
                          <Cell col="26" style="align:right middle;" text="bind:d23"/>
                          <Cell col="27" style="align:right middle;" text="bind:d24"/>
                          <Cell col="28" style="align:right middle;" text="bind:d25"/>
                          <Cell col="29" style="align:right middle;" text="bind:d26"/>
                          <Cell col="30" style="align:right middle;" text="bind:d27"/>
                          <Cell col="31" style="align:right middle;" text="bind:d28"/>
                          <Cell col="32" style="align:right middle;" text="bind:d29"/>
                          <Cell col="33" style="align:right middle;" text="bind:d30"/>
                          <Cell col="34" style="align:right middle;" text="bind:d31"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="mm" text="월별 통계">
              <Layouts>
                <Layout>
                  <Grid id="grd_mm" position="absolute 0 0 1208 646" style="align:center middle;" anchor="all" positiontype="position" onclick="grd_mm_onclick" autofittype="col" binddataset="ds_grid_grd_mm" oncellclick="swt_statflag_mm_grd_mm_oncellclick">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="30"/>
                          <Column size="100"/>
                          <Column size="200"/>
                          <Column size="80"/>
                          <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"/>
                        </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="Total"/>
                          <Cell col="4" text="01"/>
                          <Cell col="5" text="02"/>
                          <Cell col="6" text="03"/>
                          <Cell col="7" text="04"/>
                          <Cell col="8" text="05"/>
                          <Cell col="9" text="06"/>
                          <Cell col="10" text="07"/>
                          <Cell col="11" text="08"/>
                          <Cell col="12" text="09"/>
                          <Cell col="13" text="10"/>
                          <Cell col="14" text="11"/>
                          <Cell col="15" text="12"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="currow+1"/>
                          <Cell col="1" text="bind:sectnm"/>
                          <Cell col="2" style="align:left middle;" text="bind:tclsscrnnm"/>
                          <Cell col="3" style="align:right middle;" text="bind:total"/>
                          <Cell col="4" style="align:right middle;" text="bind:d01"/>
                          <Cell col="5" style="align:right middle;" text="bind:d02"/>
                          <Cell col="6" style="align:right middle;" text="bind:d03"/>
                          <Cell col="7" style="align:right middle;" text="bind:d04"/>
                          <Cell col="8" style="align:right middle;" text="bind:d05"/>
                          <Cell col="9" style="align:right middle;" text="bind:d06"/>
                          <Cell col="10" style="align:right middle;" text="bind:d07"/>
                          <Cell col="11" style="align:right middle;" text="bind:d08"/>
                          <Cell col="12" style="align:right middle;" text="bind:d09"/>
                          <Cell col="13" style="align:right middle;" text="bind:d10"/>
                          <Cell col="14" style="align:right middle;" text="bind:d11"/>
                          <Cell col="15" style="align:right middle;" text="bind:d12"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="yy" text="연별 통계">
              <Layouts>
                <Layout>
                  <Grid id="grd_yy" position="absolute 0 0 1208 646" anchor="all" positiontype="position" onclick="grd_yy_onclick" autofittype="none" binddataset="ds_grid_grd_yy" oncellclick="swt_statflag_yy_grd_yy_oncellclick">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="30"/>
                          <Column size="100"/>
                          <Column size="200"/>
                          <Column size="80"/>
                          <Column size="80"/>
                          <Column size="80"/>
                          <Column size="80"/>
                          <Column size="80"/>
                          <Column size="80"/>
                          <Column size="80"/>
                          <Column size="80"/>
                          <Column size="80"/>
                          <Column size="80"/>
                          <Column size="80"/>
                        </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="Total"/>
                          <Cell col="4" displaytype="normal" text="expr:lf_column(4)"/>
                          <Cell col="5" text="expr:lf_column(5)"/>
                          <Cell col="6" text="expr:lf_column(6)"/>
                          <Cell col="7" text="expr:lf_column(7)"/>
                          <Cell col="8" text="expr:lf_column(8)"/>
                          <Cell col="9" text="expr:lf_column(9)"/>
                          <Cell col="10" text="expr:lf_column(10)"/>
                          <Cell col="11" text="expr:lf_column(11)"/>
                          <Cell col="12" text="expr:lf_column(12.)"/>
                          <Cell col="13" text="expr:lf_column(13)"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="currow+1"/>
                          <Cell col="1" text="bind:sectnm"/>
                          <Cell col="2" text="bind:tclsscrnnm"/>
                          <Cell col="3" style="align:right middle;" text="bind:total"/>
                          <Cell col="4" style="align:right middle;" text="bind:d01"/>
                          <Cell col="5" style="align:right middle;" text="bind:d02"/>
                          <Cell col="6" style="align:right middle;" text="bind:d03"/>
                          <Cell col="7" style="align:right middle;" text="bind:d04"/>
                          <Cell col="8" style="align:right middle;" text="bind:d05"/>
                          <Cell col="9" style="align:right middle;" text="bind:d06"/>
                          <Cell col="10" style="align:right middle;" text="bind:d07"/>
                          <Cell col="11" style="align:right middle;" text="bind:d08"/>
                          <Cell col="12" text="bind:d09"/>
                          <Cell col="13" style="align:right middle;" text="bind:d10"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Static id="caption6" class="tit_1" position="absolute 0 0 106 25" anchor="default" positiontype="position" text="검사 통계"/>
        <Shape id="line2" class="line_2" position="absolute 0 25 1195 25" anchor="default" positiontype="position" linetype="horizontal"/>
        <Edit id="output4" taborder="11" readonly="true" position="absolute 704 30 769 50" mask="#,###" visible="true" positiontype="position"/>
        <Static id="caption11" text="총수혈환자수" class="cell_1" position="absolute 605 28 700 52" style="align:center middle;" visible="true" positiontype="position"/>
        <Edit id="output3" taborder="12" readonly="true" position="absolute 537 30 602 50" mask="#,###" visible="true" positiontype="position"/>
        <Static id="caption10" text="총수혈건수" class="cell_1" position="absolute 454 28 534 52" style="align:center middle;" visible="true" positiontype="position"/>
        <Edit id="output2" taborder="13" readonly="true" position="absolute 386 30 451 50" mask="#,###" visible="true" positiontype="position"/>
        <Static id="caption8" text="총환자수" class="cell_1" position="absolute 303 28 383 52" style="align:center middle;" visible="true" positiontype="position"/>
        <Edit id="output1" taborder="14" readonly="true" position="absolute 235 30 300 50" mask="#,###" visible="true" positiontype="position"/>
        <Static id="caption2" text="총바코드수" class="cell_1" position="absolute 152 28 232 52" style="align:center middle;" visible="true" positiontype="position"/>
        <Edit id="output26" taborder="15" readonly="true" position="absolute 84 30 149 50" mask="" visible="true" positiontype="position"/>
        <Static id="caption101" text="총검사건수" class="cell_1" position="absolute 1 28 81 52" style="align:center middle;" visible="true" positiontype="position"/>
        <Div id="grp_sea" anchor="left top right" taborder="16" style="align:center top;" class="div_SA2" position="absolute 0 55 1208 122">
          <Layouts>
            <Layout>
              <Static id="caption5" text="입원/외래" class="search_name" position="absolute 8 35 102 55" anchor="default" visible="true" positiontype="position"/>
              <Combo id="combo2" taborder="1" position="absolute 94 10 186 30" anchor="default" codecolumn="codecolumn" datacolumn="datacolumn" positiontype="position">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">보고일</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">접수일</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Combo id="cmb_rtnabnflag" taborder="2" position="absolute 94 35 187 55" anchor="default" visible="true" codecolumn="codecolumn" datacolumn="datacolumn" positiontype="position">
                <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">I</Col>
                      <Col id="datacolumn">입원</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">O</Col>
                      <Col id="datacolumn">외래</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">E</Col>
                      <Col id="datacolumn">응급</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">S</Col>
                      <Col id="datacolumn">건진</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Static id="caption4" text="통계 희망일" class="search_name" position="absolute 210 10 299 30" anchor="default" positiontype="position"/>
              <CheckBox id="checkbox1" taborder="3" text="검사항목 제외" truevalue="Y" position="absolute 210 35 312 55" anchor="default" positiontype="position"/>
              <Static id="caption9" text="~" class="search_no_b" visible="false" position="absolute 372 10 388 30" style="align:center middle;font:Dotum,9;" anchor="default" positiontype="position"/>
              <Calendar id="ipt_workfromdd" taborder="4" class="input_search" position="absolute 301 10 371 30" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" positiontype="position"/>
              <Calendar id="ipt_worktodd" taborder="6" class="input_search" visible="true" position="absolute 387 10 457 30" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" positiontype="position"/>
              <Static id="caption12" text=".... :" class="search_name" visible="false" position="absolute 430 35 540 52" anchor="default" positiontype="position"/>
              <Static id="caption1" text="부서" class="search_name" position="absolute 481 10 543 30" anchor="default" positiontype="position"/>
              <Combo id="combo1" taborder="7" position="absolute 528 10 650 30" anchor="default" innerdataset="@ds_init_lb0111" codecolumn="cd" datacolumn="nm" index="-1" positiontype="position"/>
              <Radio id="radio2" taborder="8" columncount="3" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 674 10 839 30" style="align:center middle;" anchor="default" positiontype="position">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">T</Col>
                      <Col id="datacolumn">검사</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">P</Col>
                      <Col id="datacolumn">환자</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">B</Col>
                      <Col id="datacolumn">바코드</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Static id="caption3" text="|" position="absolute 847 10 862 30" style="align:center middle;" anchor="default" positiontype="position"/>
              <Radio id="radio1" taborder="9" columncount="3" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 870 10 1015 30" anchor="default" onitemclick="grp_sea_radio1_onitemclick" positiontype="position">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">D</Col>
                      <Col id="datacolumn">주간</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">N</Col>
                      <Col id="datacolumn">야간</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">A</Col>
                      <Col id="datacolumn">All</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Button id="btn_ref" taborder="10" text="조회" class="btn1" position="absolute 1141 10 1197 32" anchor="top right" onclick="grp_sea_btn_ref_onclick" positiontype="position"/>
              <Static id="caption13" text="통계기준일" class="search_name" position="absolute 8 10 107 30" anchor="default" positiontype="position"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_excel" taborder="17" text="EXCEL저장" class="btn7" position="absolute 1106 130 1208 152" anchor="top right" onclick="btn_excel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_grid_grd_dd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="sectnm" type="STRING"/>
          <Column id="tclsscrnnm" type="STRING"/>
          <Column id="total" type="STRING"/>
          <Column id="d01" type="STRING"/>
          <Column id="d02" type="STRING"/>
          <Column id="d03" type="STRING"/>
          <Column id="d04" type="STRING"/>
          <Column id="d05" type="STRING"/>
          <Column id="d06" type="STRING"/>
          <Column id="d07" type="STRING"/>
          <Column id="d08" type="STRING"/>
          <Column id="d09" type="STRING"/>
          <Column id="d10" type="STRING"/>
          <Column id="d11" type="STRING"/>
          <Column id="d12" type="STRING"/>
          <Column id="d13" type="STRING"/>
          <Column id="d14" type="STRING"/>
          <Column id="d15" type="STRING"/>
          <Column id="d16" type="STRING"/>
          <Column id="d17" type="STRING"/>
          <Column id="d18" type="STRING"/>
          <Column id="d19" type="STRING"/>
          <Column id="d20" type="STRING"/>
          <Column id="d21" type="STRING"/>
          <Column id="d22" type="STRING"/>
          <Column id="d23" type="STRING"/>
          <Column id="d24" type="STRING"/>
          <Column id="d25" type="STRING"/>
          <Column id="d26" type="STRING"/>
          <Column id="d27" type="STRING"/>
          <Column id="d28" type="STRING"/>
          <Column id="d29" type="STRING"/>
          <Column id="d30" type="STRING"/>
          <Column id="d31" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grid_grd_mm" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="sectnm" type="STRING"/>
          <Column id="tclsscrnnm" type="STRING"/>
          <Column id="total" type="STRING"/>
          <Column id="d01" type="STRING"/>
          <Column id="d02" type="STRING"/>
          <Column id="d03" type="STRING"/>
          <Column id="d04" type="STRING"/>
          <Column id="d05" type="STRING"/>
          <Column id="d06" type="STRING"/>
          <Column id="d07" type="STRING"/>
          <Column id="d08" type="STRING"/>
          <Column id="d09" type="STRING"/>
          <Column id="d10" type="STRING"/>
          <Column id="d11" type="STRING"/>
          <Column id="d12" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grid_grd_yy" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="sectnm" type="STRING"/>
          <Column id="tclsscrnnm" type="STRING"/>
          <Column id="total" type="STRING"/>
          <Column id="d01" type="STRING"/>
          <Column id="d02" type="STRING"/>
          <Column id="d03" type="STRING"/>
          <Column id="d04" type="STRING"/>
          <Column id="d05" type="STRING"/>
          <Column id="d06" type="STRING"/>
          <Column id="d07" type="STRING"/>
          <Column id="d08" type="STRING"/>
          <Column id="d09" type="STRING"/>
          <Column id="d10" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0111" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grid_send_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="sectcd" type="STRING" size="256"/>
          <Column id="workgbn" type="STRING" size="256"/>
          <Column id="cntgbn" type="STRING" size="256"/>
          <Column id="itemgbn" type="STRING" size="256"/>
          <Column id="ioflag" type="STRING" size="256"/>
          <Column id="statshopefromdd" type="STRING" size="256"/>
          <Column id="statshopetodd" type="STRING" size="256"/>
          <Column id="refflag" type="STRING" size="256"/>
          <Column id="ddstandard" type="STRING" size="256"/>
          <Column id="panelgbn" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cond_total" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="totaltest" type="STRING" size="256"/>
          <Column id="totalbcno" type="STRING" size="256"/>
          <Column id="totalpid" type="STRING" size="256"/>
          <Column id="totalblood" type="STRING" size="256"/>
          <Column id="totaltranspid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cond_send_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="refdd" type="STRING" size="256"/>
          <Column id="refflag" type="STRING" size="256"/>
          <Column id="sectcd" type="STRING" size="256"/>
          <Column id="workgbn" type="STRING" size="256"/>
          <Column id="cntgbn" type="STRING" size="256"/>
          <Column id="itemgbn" type="STRING" size="256"/>
          <Column id="ioflag" type="STRING" size="256"/>
          <Column id="ddstandard" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <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 "lis_commonxp::LLZ001.xjs";
	
function SMLLS01100_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj);  // 화면공통
	lf_initDataSet();
	lf_setInit();	
}

function  lf_initDataSet(){
	lf_getDbDeptcd("0000|0111|");
}
				
				
//화면 open시 초기화
function lf_setInit() {
	grp_sea.combo2.value ="1";
	grp_sea.ipt_workfromdd.value= utlf_getCurrentDate();
	grp_sea.ipt_worktodd.value=utlf_getCurrentDate();
	grp_sea.combo1.value="00";
	grp_sea.cmb_rtnabnflag.value="0";
	grp_sea.radio2.value="T";
	grp_sea.radio1.value="A";
	
	grp_sea.caption9.visible = false;
	grp_sea.ipt_worktodd.visible = false;
}	
	
function lf_checkSaerch(){
	var sFromdd = new String(grp_sea.ipt_workfromdd.value);
	var sTodd = new String(grp_sea.ipt_worktodd.value);

	var fromdd = sFromdd.substring(0,4); 
 	var todd = sTodd.substring(0,4);

	if(swt_statflag.tabindex == "2"){        //연별 통계 조회시 10년 이내로 조회
		if(todd - fromdd > 9){
			sysf_messageBox("10년 이내로 조회 가능합니다\n조회기간을 다시 선택하세요", "I");
 			return;
		}
	}

	if(sFromdd > sTodd){
			sysf_messageBox("통계 희망일 시작시간이 종료시간보다 작아야 합니다. ", "I");
			return;
	}
	
	lf_getStats(); // 조회							
}

//통계희망일, 검사시행부서, 장비, 조회구분(일,월,연) 에 따른 조회   --- 2008-12-12  
function lf_getStats() {  
	ds_grid_send_data.addRow();
	
	ds_grid_send_data.setColumn(0,"sectcd",grp_sea.combo1.value);   //계코드 부서콤보
	ds_grid_send_data.setColumn(0,"workgbn",grp_sea.radio1.value);  //근무구분  D주간 N야간 ΟAll
	ds_grid_send_data.setColumn(0,"cntgbn",grp_sea.radio2.value);  // T검사 P환자 B바코드
	ds_grid_send_data.setColumn(0,"itemgbn",grp_sea.checkbox1.value);   //검사항목제외
	ds_grid_send_data.setColumn(0,"ioflag",grp_sea.cmb_rtnabnflag.value);    //입원/외래구분   I, O, E, S
	ds_grid_send_data.setColumn(0,"statshopefromdd",grp_sea.ipt_workfromdd.value);   //통계희망시작일
	ds_grid_send_data.setColumn(0,"statshopetodd",grp_sea.ipt_worktodd.value);  //통계희망종료일
	ds_grid_send_data.setColumn(0,"ddstandard",grp_sea.combo2.value);   //통계기준일  1= 접수일 2=보고일 

	if(swt_statflag.tabindex == "0"){
		ds_grid_send_data.setColumn(0,"refflag","dd");
		
		var oParam = {};
			oParam.id          = "TRLLS01101";
			oParam.service     = "statsmngtapp.GeneralTestStatsRefMngt";
			oParam.method      = "reqGetSectTestStats";
			oParam.inds        = "cond=ds_grid_send_data";
			oParam.outds       = "ds_grid_grd_dd=getSectTestStats ds_=getSectTestStatsTotal ds_=getSectTestStatsTotalB";
			oParam.async       = false;

		tranf_submit(oParam);
		
		lf_changeColor(); // row 색 변경
	
	}else if(swt_statflag.tabindex == "1"){
		ds_grid_send_data.setColumn(0,"refflag","mm");
		var oParam = {};
			oParam.id          = "TRLLS01103";
			oParam.service     = "statsmngtapp.GeneralTestStatsRefMngt";
			oParam.method      = "reqGetSectTestmmStats";
			oParam.inds        = "cond=ds_grid_send_data";
			oParam.outds       = "ds_grid_grd_mm=getSectTestmmStats ds_=getSectTestStatsTotal ds_=getSectTestStatsTotalB";
			oParam.async       = false;

		tranf_submit(oParam);
		
		lf_changeColor();  // row 색 변경
		
	}else{
		lf_setyygrid();
		var sFromdd = new String(grp_sea.ipt_workfromdd.value);
		var sTodd = new String(grp_sea.ipt_worktodd.value);

		var fromdd = sFromdd.substring(0,4); 
		var todd = sTodd.substring(0,4);
		
		ds_grid_send_data.setColumn(0,"statshopefromdd",fromdd);   //통계희망시작일
		ds_grid_send_data.setColumn(0,"statshopetodd",todd);  //통계희망종료일
		ds_grid_send_data.setColumn(0,"refflag","yy");
		
		var oParam = {};
			oParam.id          = "TRLLS01104";
			oParam.service     = "statsmngtapp.GeneralTestStatsRefMngt";
			oParam.method      = "reqGetSectTestyy1Stats";
			oParam.inds        = "cond=ds_grid_send_data";
			oParam.outds       = "ds_grid_grd_yy=getSectTestyyStats ds_=getSectTestStatsTotal ds_=getSectTestStatsTotalB";
			oParam.async       = false;

		tranf_submit(oParam);
		
		lf_changeColor(); // row 색 변경
	}
}	


//종료된 데이타 색깔 바꾸기
function lf_changeColor(){
	var i =0;
	var j =0;
	
	// 일별통계
	if(swt_statflag.tabindex == "0"){
		ds_grid_grd_dd.addColumn("checkcolor","String");
		if (ds_grid_grd_dd.rowcount == 0) return;
		var sExpr = "EXPR(checkcolor)";
		//Row색깔 투입
		ds_grid_grd_dd.updatecontrol = false ;
	
		for(j=0; j < ds_grid_grd_dd.rowcount; j++){
			if(ds_grid_grd_dd.getColumn(j,"tclsscrnnm") == "소계" && grp_sea.checkbox1.value != "Y"){
				ds_grid_grd_dd.setColumn(j, "checkcolor", "#B2EBF4");
			}else if (ds_grid_grd_dd.getColumn(j,"tclsscrnnm") == "부서계") {
				ds_grid_grd_dd.setColumn(j, "checkcolor", "#E4F7BA");			
			}else if(ds_grid_grd_dd.getColumn(j,"tclsscrnnm") == "부서합계"){
				ds_grid_grd_dd.setColumn(j, "checkcolor", "#E4F7BA");	
			}else if(ds_grid_grd_dd.getColumn(j,"sectnm") == "합계"){
				ds_grid_grd_dd.setColumn(j, "checkcolor", "#73EDFF");	
			}else{
				ds_grid_grd_dd.setColumn(j, "checkcolor", "default");	
			}
			ds_grid_grd_dd.setRowType(j,"1");	
		}	
		ds_grid_grd_dd.updatecontrol = true ;
	
		//색깔변경
		for (i=0; i < swt_statflag.dd.grd_dd.getCellCount('Head'); i++ ) {  						
			swt_statflag.dd.grd_dd.setCellProperty("Body",i,"background", sExpr); 
			swt_statflag.dd.grd_dd.setCellProperty("Body",i,"background2", sExpr); 		
		}
		
		swt_statflag.dd.grd_dd.setCellProperty("Body",3,"background", "#ffe79d");
		swt_statflag.dd.grd_dd.setCellProperty("Body",3,"background2", "#ffe79d"); 
			
	//월별통계
	}else if(swt_statflag.tabindex == "1"){
		ds_grid_grd_mm.addColumn("checkcolor","String");
		if (ds_grid_grd_mm.rowcount == 0) return;
		var sExpr = "EXPR(checkcolor)";
		//Row색깔 투입
		ds_grid_grd_mm.updatecontrol = false ;
	
		for(j=0; j < ds_grid_grd_mm.rowcount; j++){
			if(ds_grid_grd_mm.getColumn(j,"tclsscrnnm") == "소계" && grp_sea.checkbox1.value != "Y"){
				ds_grid_grd_mm.setColumn(j, "checkcolor", "#B2EBF4");
			}else if (ds_grid_grd_mm.getColumn(j,"tclsscrnnm") == "부서계") {
				ds_grid_grd_mm.setColumn(j, "checkcolor", "#E4F7BA");			
			}else if(ds_grid_grd_mm.getColumn(j,"tclsscrnnm") == "부서합계"){
				ds_grid_grd_mm.setColumn(j, "checkcolor", "#E4F7BA");	
			}else if(ds_grid_grd_mm.getColumn(j,"sectnm") == "합계"){
				ds_grid_grd_mm.setColumn(j, "checkcolor", "#73EDFF");	
			}else{
				ds_grid_grd_mm.setColumn(j, "checkcolor", "default");	
			}
			ds_grid_grd_mm.setRowType(j,"1");	
		}	
		ds_grid_grd_mm.updatecontrol = true ;
	
		//색깔변경
		for (i=0; i < swt_statflag.mm.grd_mm.getCellCount('Head'); i++ ) {  						
			swt_statflag.mm.grd_mm.setCellProperty("Body",i,"background", sExpr); 
			swt_statflag.mm.grd_mm.setCellProperty("Body",i,"background2", sExpr); 		
		}
			
	//연별통계
	}else if(swt_statflag.tabindex == "2"){
		ds_grid_grd_yy.addColumn("checkcolor","String");
		if (ds_grid_grd_yy.rowcount == 0) return;
		var sExpr = "EXPR(checkcolor)";
		//Row색깔 투입
		ds_grid_grd_yy.updatecontrol = false ;
	
		for(j=0; j < ds_grid_grd_yy.rowcount; j++){
			if(ds_grid_grd_yy.getColumn(j,"tclsscrnnm") == "소계" && grp_sea.checkbox1.value != "Y"){
				ds_grid_grd_yy.setColumn(j, "checkcolor", "#B2EBF4");
			}else if (ds_grid_grd_yy.getColumn(j,"tclsscrnnm") == "부서계") {
				ds_grid_grd_yy.setColumn(j, "checkcolor", "#E4F7BA");			
			}else if(ds_grid_grd_yy.getColumn(j,"tclsscrnnm") == "부서합계"){
				ds_grid_grd_yy.setColumn(j, "checkcolor", "#E4F7BA");	
			}else if(ds_grid_grd_yy.getColumn(j,"sectnm") == "합계"){
				ds_grid_grd_yy.setColumn(j, "checkcolor", "#73EDFF");	
			}else{
				ds_grid_grd_yy.setColumn(j, "checkcolor", "default");	
			}
			ds_grid_grd_yy.setRowType(j,"1");	
		}	
		ds_grid_grd_yy.updatecontrol = true ;
	
		//색깔변경
		for (i=0; i < swt_statflag.yy.grd_yy.getCellCount('Head'); i++ ) {  						
			swt_statflag.yy.grd_yy.setCellProperty("Body",i,"background", sExpr); 
			swt_statflag.yy.grd_yy.setCellProperty("Body",i,"background2", sExpr); 		
		}	
	}
}


				
//switch 버튼 클릭시 그리드 초기화  
function lf_gridInit() {
	
	if(swt_statflag.tabindex == "0" || swt_statflag.tabindex == "1" ){                 //일별, 월별
		grp_sea.ipt_workfromdd.dateformat = "yyyy-MM";
		grp_sea.ipt_workfromdd.editformat =  "yyyy-MM";
		grp_sea.ipt_worktodd.dateformat = "yyyy-MM";
		grp_sea.ipt_worktodd.editformat =  "yyyy-MM"
		
		grp_sea.caption9.visible = false;
		grp_sea.ipt_worktodd.visible = false;
		
		grp_sea.ipt_workfromdd.value = utlf_getCurrentDate();

	}else{	                                                                          //년도별
		grp_sea.caption9.visible = true;
		grp_sea.ipt_worktodd.visible = true;
		grp_sea.ipt_workfromdd.dateformat = "yyyy";
		grp_sea.ipt_workfromdd.editformat =  "yyyy";
		grp_sea.ipt_worktodd.dateformat = "yyyy";
		grp_sea.ipt_worktodd.editformat =  "yyyy";
		
		grp_sea.ipt_workfromdd.value = utlf_getCurrentDate();
		grp_sea.ipt_worktodd.value = utlf_getCurrentDate();
		
		lf_setyytitle();
	}

}
				
// 연도별 선택시 2014년도 컬럼 외 년도는 size 0
function lf_setyytitle(){
	for (var i=5 ; i<=13 ; i++){
		swt_statflag.yy.grd_yy.setFormatColProperty(i,"size",0);
	}
}
				
		
// 연별조회시  그리드 타이틀 설정 
function lf_setyygrid(){
		
	var sFromdd = new String(grp_sea.ipt_workfromdd.value);
	var sTodd = new String(grp_sea.ipt_worktodd.value);
	var fromdd = sFromdd.substring(0,4); 
 	var todd = sTodd.substring(0,4);

 	var i = 4;
	for (var j=0 ; j<todd-fromdd+1; j++){        // 5번째컬럼부터 조회되는 년도 컬럼 size 80
		swt_statflag.yy.grd_yy.setFormatColProperty(i,"size",80); 
		i++;
	}
	
	for (var k = todd-fromdd ; k<9; k++){     // 조회되지 않는 컬럼 size  0
		swt_statflag.yy.grd_yy.setFormatColProperty(i,"size",0);
		i++;
	}
}
	
				
 // 그리드 선택시  총검사건수, 총바코드수, 총환자수, 총수혈건수, 총수혈환자수 조회  2008-12-12 
 function lf_getSelectTotacnts(){
	ds_cond_send_data.clearData();
	ds_cond_send_data.addRow();
	var sFromdd = new String(grp_sea.ipt_workfromdd.value);
	var fromdd = sFromdd.substring(0,6); 

	if(swt_statflag.tabindex == "0"){
		var fromdd = sFromdd.substring(0,6);
		var DD = swt_statflag.dd.grd_dd.currentcol - 3;
		if(DD<10){
			var s = utlf_lPad(DD,"2","0");
			var dd = utlf_lPad(s,"3",fromdd);
		}else if(DD>=10){
			var dd = utlf_lPad(DD,"3",fromdd);
		}
		
		ds_cond_send_data.setColumn(0,"refdd",dd);     
		ds_cond_send_data.setColumn(0,"refflag","dd");

	}else if(swt_statflag.tabindex == "1"){
		var fromdd = sFromdd.substring(0,4); 
		var MM = swt_statflag.mm.grd_mm.currentcol - 3;
		
		if(MM<10){
			var s = utlf_lPad(MM,"2","0");
			var mm = utlf_lPad(s,"3",fromdd);
		}else if(MM>=10){
			var mm = utlf_lPad(MM,"3",fromdd);
		}
	
		ds_cond_send_data.setColumn(0,"refdd",mm);    
		ds_cond_send_data.setColumn(0,"refflag","mm");

	}else if(swt_statflag.tabindex == "2"){
		var yy = lf_column(swt_statflag.yy.grd_yy.currentcol);
		ds_cond_send_data.setColumn(0,"refdd",yy);             
		ds_cond_send_data.setColumn(0,"refflag","yy"); 
	}
	
	ds_cond_send_data.setColumn(0,"sectcd",grp_sea.combo1.value);   //계코드 부서콤보
	ds_cond_send_data.setColumn(0,"workgbn",grp_sea.radio1.value);  //근무구분  D주간 N야간 ΟAll
	ds_cond_send_data.setColumn(0,"cntgbn",grp_sea.radio2.value);  // T검사 P환자 B바코드
	ds_cond_send_data.setColumn(0,"itemgbn",grp_sea.checkbox1.value);   //검사항목제외
	ds_cond_send_data.setColumn(0,"ioflag",grp_sea.cmb_rtnabnflag.value);    //입원/외래구분   I, O, E, S
	ds_cond_send_data.setColumn(0,"ddstandard",grp_sea.combo2.value);   //통계기준일  1= 접수일 2=보고일 
	
	var oParam = {};
		oParam.id          = "TRLLS01105";
		oParam.service     = "statsmngtapp.GeneralTestStatsRefMngt";
		oParam.method      = "reqGetSelectTotacnts";
		oParam.inds        = "cond=ds_cond_send_data";
		oParam.outds       = "ds_cond_total=getSelectTotacnts";
		oParam.async       = false;

	tranf_submit(oParam);

	// 총검사건수
	if(ds_cond_total.getColumn(0,"totaltest") != null){
		output26.value= utlf_setComma(ds_cond_total.getColumn(0,"totaltest"));
	}else{
		output26.value = " " ;
	}
	
	// 총바코드수
	if(ds_cond_total.getColumn(0,"totalbcno") != null){
		output1.value= utlf_setComma(ds_cond_total.getColumn(0,"totalbcno"));
	}else{
		output1.value = " ";
	}
	
	// 총환자수
	if(ds_cond_total.getColumn(0,"totalpid") != null){
		output2.value= utlf_setComma(ds_cond_total.getColumn(0,"totalpid"));
	}else{
		output2.value = " ";
	}
	
	//총수혈건수
	if(ds_cond_total.getColumn(0,"totalblood") != null){
		output3.value= utlf_setComma(ds_cond_total.getColumn(0,"totalblood"));
	}else{
		output3.value = " ";
	}
	
	//총수혈환자수
	if(ds_cond_total.getColumn(0,"totaltranspid") != null){
		output4.value= utlf_setComma(ds_cond_total.getColumn(0,"totaltranspid"));
	}else{
		output4.value= " ";
	}
 }
								
//엑셀저장
function lf_exeSaveToExcel() {
	if(swt_statflag.tabindex == "0"){
		grdf_exportExcel(swt_statflag.dd.grd_dd, lf_lisGetTitle(this), "sheet1", false);
	}else if(swt_statflag.tabindex == "1"){
		grdf_exportExcel(swt_statflag.mm.grd_mm, lf_lisGetTitle(this), "sheet1", false);
	}else if(swt_statflag.tabindex == "2"){
		grdf_exportExcel(swt_statflag.yy.grd_yy, lf_lisGetTitle(this), "sheet1", false);
	}
}
				
				
// 그리드 선택시 Column 색 변화
function lf_columnColorChange(){
	lf_changeColor();
	var col = 0;
	if(swt_statflag.tabindex == "0"){
	    col = swt_statflag.dd.grd_dd.currentcol;
		swt_statflag.dd.grd_dd.setCellProperty("Body",col,"background", "lavender");
		swt_statflag.dd.grd_dd.setCellProperty("Body",col,"background2", "lavender");
	}else if(swt_statflag.tabindex == "1"){
		col = swt_statflag.mm.grd_mm.currentcol;
		swt_statflag.mm.grd_mm.setCellProperty("Body",col,"background", "lavender");
		swt_statflag.mm.grd_mm.setCellProperty("Body",col,"background2", "lavender");
	}else if(swt_statflag.tabindex == "1"){
		col = swt_statflag.yy.grd_yy.currentcol;
		swt_statflag.yy.grd_yy.setCellProperty("Body",col,"background", "lavender");
		swt_statflag.yy.grd_yy.setCellProperty("Body",col,"background2", "lavender");
	}
	
	lf_getSelectTotacnts();
}


// 연별 통계 조회시 그리드 컬럼명 변경
function lf_column(curcol){
	var sFrom = new String(grp_sea.ipt_workfromdd.value);
	var fromdd = sFrom.substring(0,4);
	var yy = fromdd- 4 + curcol;        // 컬럼 title
	return yy;
}

//조회
function grp_sea_btn_ref_onclick(obj:Button,  e:ClickEventInfo)
{
	lf_checkSaerch();
}

// 탭 선택시
function swt_statflag_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
{
	lf_gridInit();
	lf_checkSaerch();
}

// 일별 통계 그리드 클릭시 색변화, 총검사건수, 총바코드수 등 가져오기
function swt_statflag_dd_grd_dd_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	lf_columnColorChange();
}

// 월별 통계 그리드 클릭시 색변화, 총검사건수, 총바코드수 등 가져오기
function swt_statflag_mm_grd_mm_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	lf_columnColorChange();
}

// 연별 통계 그리드 클릭시 색변화, 총검사건수, 총바코드수 등 가져오기
function swt_statflag_yy_grd_yy_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	lf_columnColorChange();
}

//엑셀 저장
function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	lf_exeSaveToExcel();
}

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