YNU_JEUS/app_home/himed/xpapps/pam/opatmngtxp/xp/SMPMO01500_전화예약통계.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPMO01500" position="absolute 0 0 1196 715" titletext="전화예약통계" onload="SMPMO01500_onload" oninit="SMPMO01500_oninit">
    <Layouts>
      <Layout>
        <Static id="caption6" text="전화예약통계" class="tit_1" position="absolute 0 0 120 25"/>
        <Tab id="swt_outpatient" anchor="all" taborder="2" tabindex="2" class="tab_Normal" position="absolute 0 73 1195 687" style="border: solid #c7a3cf #c7a3cf;">
          <Tabpages>
            <Tabpage id="case2"/>
            <Tabpage id="case_reservation">
              <Layouts>
                <Layout>
                  <Shape id="line1" class="line_1" position="absolute 0 25 1195 29" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
                  <Button id="btn_updtexcel" taborder="1" text="엑셀저장" class="btn7" position="absolute 1115 2 1195 24" anchor="top right" onclick="swt_outpatient_case_reservation_btn_updtexcel_onclick"/>
                  <Grid id="grd_reservationstatistic" class="datagrid1" taborder="2" binddataset="ds_main_reservationstatistic_reservationstatisticlist" useinputpanel="false" autofittype="col" position="absolute 0 29 1195 595" style="align:center ;" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="25" band="left"/>
                          <Column size="260"/>
                          <Column size="300"/>
                          <Column size="300"/>
                          <Column size="300"/>
                          <Column size="0"/>
                        </Columns>
                        <Rows>
                          <Row size="23" band="head"/>
                          <Row size="48"/>
                          <Row size="50" band="summ"/>
                        </Rows>
                        <Band id="head">
                          <Cell/>
                          <Cell col="1" text="진료과"/>
                          <Cell col="2" text="초진"/>
                          <Cell col="3" text="재진"/>
                          <Cell col="4" text="합계"/>
                          <Cell col="5" text="caption1"/>
                          <Cell col="6" text="최종수정일시"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="expr:currow + 1"/>
                          <Cell col="1" text="bind:orddeptcd"/>
                          <Cell col="2" text="bind:fstord"/>
                          <Cell col="3" text="bind:reord"/>
                          <Cell col="4" text="bind:sum"/>
                          <Cell col="5" text="bind:subtotal"/>
                        </Band>
                        <Band id="summary">
                          <Cell style="background:#99ff99ff;background2:#99ff99ff;"/>
                          <Cell col="1" style="align:center middle;background:#99ff99ff;background2:#99ff99ff;" text="합계"/>
                          <Cell col="2" displaytype="number" style="align:center middle;background:#99ff99ff;background2:#99ff99ff;" expr="expr:getSum('fstord')"/>
                          <Cell col="3" displaytype="number" style="align:center middle;background:#99ff99ff;background2:#99ff99ff;" expr="expr:getSum('reord')"/>
                          <Cell col="4" displaytype="number" style="align:center middle;background:#99ff99ff;background2:#99ff99ff;" expr="expr:getSum('sum')"/>
                          <Cell col="5"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="case_change">
              <Layouts>
                <Layout>
                  <Shape id="line2" class="line_1" position="absolute 0 25 1195 29" anchor="left top right" style="strokepen:3 solid #33bbbbff;"/>
                  <Button id="btn_cnclexcel" taborder="1" text="엑셀저장" class="btn7" position="absolute 1115 2 1195 24" anchor="top right" onclick="swt_outpatient_case_change_btn_cnclexcel_onclick"/>
                  <Grid id="grd_change" class="datagrid2" taborder="2" binddataset="ds_main_reservationstatistic_reservationstatisticlist" useinputpanel="false" autofittype="col" position="absolute 0 29 1195 595" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="25"/>
                          <Column size="260"/>
                          <Column size="300"/>
                          <Column size="300"/>
                          <Column size="300"/>
                          <Column size="0"/>
                        </Columns>
                        <Rows>
                          <Row size="23" band="head"/>
                          <Row size="25"/>
                          <Row size="24" band="summ"/>
                        </Rows>
                        <Band id="head">
                          <Cell/>
                          <Cell col="1" text="진료과"/>
                          <Cell col="2" text="초진"/>
                          <Cell col="3" text="재진"/>
                          <Cell col="4" text="합계"/>
                          <Cell col="5" text="caption1"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="expr:currow + 1"/>
                          <Cell col="1" style="align:left middle;padding:0 0 0 3;" text="bind:orddeptcd"/>
                          <Cell col="2" style="align:left middle;padding:0 0 0 3;" text="bind:fstord"/>
                          <Cell col="3" style="align:left middle;padding:0 0 0 3;" text="bind:reord"/>
                          <Cell col="4" style="align:left middle;padding:0 0 0 3;" text="bind:sum"/>
                          <Cell col="5" text="bind:subtotal"/>
                        </Band>
                        <Band id="summary">
                          <Cell style="background:#99ff99ff;background2:#99ff99ff;"/>
                          <Cell col="1" style="align:left middle;padding:0 0 0 3;background:#99ff99ff;background2:#99ff99ff;" text="합계"/>
                          <Cell col="2" displaytype="number" style="align:left middle;padding:0 0 0 3;background:#99ff99ff;background2:#99ff99ff;" expr="expr:getSum('fstord')"/>
                          <Cell col="3" displaytype="number" style="align:left middle;padding:0 0 0 3;background:#99ff99ff;background2:#99ff99ff;" expr="expr:getSum('reord')"/>
                          <Cell col="4" displaytype="number" style="align:left middle;padding:0 0 0 3;background:#99ff99ff;background2:#99ff99ff;" expr="expr:getSum('sum')"/>
                          <Cell col="5"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="case_cancel">
              <Layouts>
                <Layout>
                  <Button id="button2" taborder="1" text="엑셀저장" class="btn7" position="absolute 1115 2 1195 24" anchor="top right" onclick="swt_outpatient_case_cancel_button2_onclick"/>
                  <Grid id="grd_cancel" class="datagrid1" taborder="2" binddataset="ds_main_reservationstatistic_reservationstatisticlist" useinputpanel="false" autofittype="col" position="absolute 0 29 1195 595" style="align:center ;" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="25"/>
                          <Column size="260"/>
                          <Column size="300"/>
                          <Column size="300"/>
                          <Column size="300"/>
                          <Column size="0"/>
                        </Columns>
                        <Rows>
                          <Row size="23" band="head"/>
                          <Row size="46"/>
                          <Row size="48" band="summ"/>
                        </Rows>
                        <Band id="head">
                          <Cell/>
                          <Cell col="1" text="진료과"/>
                          <Cell col="2" text="초진"/>
                          <Cell col="3" text="재진"/>
                          <Cell col="4" text="합계"/>
                          <Cell col="5" text="caption1"/>
                          <Cell col="6" text="최종수정일시"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="expr:currow + 1"/>
                          <Cell col="1" text="bind:orddeptcd"/>
                          <Cell col="2" text="bind:fstord"/>
                          <Cell col="3" text="bind:reord"/>
                          <Cell col="4" text="bind:sum"/>
                          <Cell col="5" text="bind:subtotal"/>
                        </Band>
                        <Band id="summary">
                          <Cell style="background:#99ff99ff;background2:#99ff99ff;"/>
                          <Cell col="1" style="background:#99ff99ff;background2:#99ff99ff;" text="합계"/>
                          <Cell col="2" displaytype="number" style="align:center middle;background:#99ff99ff;background2:#99ff99ff;" expr="expr:getSum('fstord')"/>
                          <Cell col="3" displaytype="number" style="align:center middle;background:#99ff99ff;background2:#99ff99ff;" expr="expr:getSum('reord')"/>
                          <Cell col="4" displaytype="number" style="align:center middle;background:#99ff99ff;background2:#99ff99ff;" expr="expr:getSum('sum')"/>
                          <Cell col="5"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Shape id="line2" class="line_1" position="absolute 0 25 1195 29" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="case_break">
              <Layouts>
                <Layout>
                  <Shape id="line10" class="line_1" position="absolute 0 25 1195 30" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
                  <Button id="btn_rgstexcel" taborder="1" text="엑셀저장" class="btn7" position="absolute 1115 2 1195 24" anchor="top right" onclick="swt_outpatient_case_break_btn_rgstexcel_onclick"/>
                  <Grid id="grd_break" class="datagrid2" taborder="2" binddataset="ds_main_breakstatistic_breakstatisticlist" useinputpanel="false" autofittype="col" position="absolute 0 29 1195 595" style="align:center ;" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="25"/>
                          <Column size="165"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="130"/>
                          <Column size="100"/>
                          <Column size="100"/>
                          <Column size="130"/>
                          <Column size="0"/>
                          <Column size="150"/>
                          <Column size="180"/>
                          <Column size="0"/>
                        </Columns>
                        <Rows>
                          <Row size="23" band="head"/>
                          <Row size="23"/>
                        </Rows>
                        <Band id="head">
                          <Cell/>
                          <Cell col="1" text="진료과"/>
                          <Cell col="2" text="초진예약"/>
                          <Cell col="3" text="초진부도자"/>
                          <Cell col="4" text="초진부도율(%)"/>
                          <Cell col="5" text="재진예약"/>
                          <Cell col="6" text="재진부도자"/>
                          <Cell col="7" text="재진부도율(%)"/>
                          <Cell col="8" text="예약합계"/>
                          <Cell col="9" text="부도자합계"/>
                          <Cell col="10" text="부도율(%)"/>
                          <Cell col="11" text="caption1"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="expr:currow + 1"/>
                          <Cell col="1" style="background:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');background2:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');" text="bind:orddeptcd"/>
                          <Cell col="2" style="background:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');background2:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');" text="bind:freserve"/>
                          <Cell col="3" style="background:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');background2:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');" text="bind:fstord"/>
                          <Cell col="4" style="background:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '#dfdfdfff');background2:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '#dfdfdfff');" text="bind:fstordrate"/>
                          <Cell col="5" style="background:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');background2:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');" text="bind:rereserve"/>
                          <Cell col="6" style="background:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');background2:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');" text="bind:reord"/>
                          <Cell col="7" style="background:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '#dfdfdfff');background2:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '#dfdfdfff');" text="bind:reordrate"/>
                          <Cell col="8" text="bind:tmpsumreserve"/>
                          <Cell col="9" style="background:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');background2:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '');" text="bind:sum"/>
                          <Cell col="10" style="background:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '#dfdfdfff');background2:EXPR(orddeptcd == '합계(부도자)' ? '#99ff99' : '#dfdfdfff');" text="bind:sumrate"/>
                          <Cell col="11" text="bind:subtotal"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="case_tel" selected="true">
              <Layouts>
                <Layout>
                  <Grid id="datagrid1" class="datagrid2" taborder="1" binddataset="ds_main_telstatisticnum_telstatisticnumlist" useinputpanel="false" autofittype="col" position="absolute 0 29 1195 595" style="align:center ;" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="25"/>
                          <Column size="159"/>
                          <Column size="160"/>
                          <Column size="140"/>
                          <Column size="140"/>
                          <Column size="140"/>
                          <Column size="140"/>
                          <Column size="140"/>
                          <Column size="140"/>
                          <Column size="0"/>
                        </Columns>
                        <Rows>
                          <Row size="23" band="head"/>
                          <Row size="23"/>
                          <Row size="24" band="summ"/>
                        </Rows>
                        <Band id="head">
                          <Cell/>
                          <Cell col="1" text="사용자"/>
                          <Cell col="2" text="합계"/>
                          <Cell col="3" text="초진예약"/>
                          <Cell col="4" text="재진예약"/>
                          <Cell col="5" text="초진변경"/>
                          <Cell col="6" text="재진변경"/>
                          <Cell col="7" text="초진취소"/>
                          <Cell col="8" text="재진취소"/>
                          <Cell col="9" text="subtotal"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="expr:currow + 1"/>
                          <Cell col="1" text="bind:lastupdtrid"/>
                          <Cell col="2" text="bind:sum"/>
                          <Cell col="3" text="bind:fstord"/>
                          <Cell col="4" text="bind:reord"/>
                          <Cell col="5" text="bind:fstchanage"/>
                          <Cell col="6" text="bind:rechange"/>
                          <Cell col="7" text="bind:fstcancel"/>
                          <Cell col="8" text="bind:recancel"/>
                          <Cell col="9" text="bind:subtotal"/>
                        </Band>
                        <Band id="summary">
                          <Cell/>
                          <Cell col="1" text="합계"/>
                          <Cell col="2" displaytype="number" style="align:center middle;" expr="expr:getSum('sum')" mask="9,999"/>
                          <Cell col="3" displaytype="number" style="align:center middle;" expr="expr:getSum('fstord')" mask="9,999"/>
                          <Cell col="4" displaytype="number" style="align:center middle;" expr="expr:getSum('reord')" mask="9,999"/>
                          <Cell col="5" displaytype="number" style="align:center middle;" expr="expr:getSum('fstchanage')" mask="9,999"/>
                          <Cell col="6" displaytype="number" style="align:center middle;" expr="expr:getSum('rechange')" mask="9,999"/>
                          <Cell col="7" displaytype="number" style="align:center middle;" expr="expr:getSum('fstcancel')" mask="9,999"/>
                          <Cell col="8" displaytype="number" style="align:center middle;" expr="expr:getSum('recancel')" mask="9,999"/>
                          <Cell col="9"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Button id="button3" taborder="2" text="엑셀저장" class="btn7" position="absolute 1115 2 1195 24" anchor="top right" onclick="swt_outpatient_case_tel_button3_onclick"/>
                  <Shape id="line10" class="line_10" position="absolute 0 25 1194 30" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Shape id="line88" class="line_6" position="absolute 0 682 1195 685" anchor="left right bottom"/>
        <Button id="btn_clear" taborder="3" text="초기화" class="btn4" position="absolute 1126 687 1195 709" anchor="right bottom" onclick="btn_clear_onclick"/>
        <Div id="group5" taborder="1" style="align: top;" class="div_SA" position="absolute 0 25 1195 85" anchor="left top right">
          <Layouts>
            <Layout>
              <Button id="button1" taborder="1" text="조회" class="btn1" position="absolute 1122 19 1178 41" anchor="top right" onclick="group5_button1_onclick"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1106 11 1109 50" anchor="top right" style="border: solid #ffe4bb #ffe4bb;"/>
              <Static id="caption83" text="~" position="absolute 211 34 220 51" style="font:,,bold;" anchor="default"/>
              <Static id="caption1" text="진료과 :" class="search_name" position="absolute 390 10 476 27" anchor="default"/>
              <Combo id="cmb_orddept" taborder="2" innerdataset="@ds_init_orddeptcd_orddeptcdlist" codecolumn="cd" datacolumn="nm" class="combo_search" position="absolute 475 9 617 28" columncount="-1" rowcount="-1" anchor="default" onitemchanged="group5_cmb_orddept_onitemchanged"/>
              <Static id="caption3" text="진료의 :" class="search_name" position="absolute 390 34 476 51" anchor="default"/>
              <Combo id="cmb_orddr" taborder="3" innerdataset="@ds_init_orddrid_orddridlist" codecolumn="cd" datacolumn="nm" class="combo_search" position="absolute 475 33 575 52" columncount="-1" rowcount="-1" anchor="default"/>
              <Calendar id="ipt_fromdd" taborder="4" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" class="input_essential" position="absolute 112 33 207 52" anchor="default"/>
              <Calendar id="ipt_todd" taborder="5" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" class="input_essential" position="absolute 224 33 319 52" anchor="default"/>
              <Static id="caption7" text="부서      :" class="search_name" position="absolute 17 10 103 27" anchor="default"/>
              <Static id="caption9" text="조회날자 :" class="search_name" position="absolute 17 34 103 51" anchor="default"/>
              <Static id="caption2" text="통계 구분 :" class="search_name" position="absolute 680 10 760 27" anchor="default"/>
              <Radio id="statistic_gooboon" taborder="6" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 767 9 1030 29" style="textpadding:0 3 0 3;" anchor="default" columncount="-1" rowcount="-1" onitemchanged="group5_statistic_gooboon_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <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>
                    <Row>
                      <Col id="codecolumn">4</Col>
                      <Col id="datacolumn">부도자</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">5</Col>
                      <Col id="datacolumn">통화건수</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Combo id="cmb_department" taborder="7" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_search" position="absolute 112 9 192 28" columncount="-1" rowcount="-1" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">A</Col>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">전화예약</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">5</Col>
                      <Col id="datacolumn">인터넷</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">C</Col>
                      <Col id="datacolumn">의뢰</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">협력</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">K</Col>
                      <Col id="datacolumn">병동</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
            </Layout>
          </Layouts>
        </Div>
      </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="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="orddept" type="STRING" size="256"/>
          <Column id="orddr" type="STRING" size="256"/>
          <Column id="statisticgooboon" type="STRING" size="256"/>
          <Column id="department" type="STRING" size="256"/>
          <Column id="teldept" type="STRING" size="256"/>
          <Column id="coopdept" type="STRING" size="256"/>
          <Column id="pid" type="STRING" size="256"/>
          <Column id="hngnm" type="STRING" size="256"/>
          <Column id="rrgstno1" type="STRING" size="256"/>
          <Column id="rrgstno2" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="orddept"/>
            <Col id="orddr"/>
            <Col id="statisticgooboon"/>
            <Col id="department"/>
            <Col id="teldept"/>
            <Col id="coopdept"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_orddeptcd_orddeptcdlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_orddrid_orddridlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_reservationstatistic_reservationstatisticlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="orddeptcd" type="STRING" size="256" sumtext="부서"/>
          <Column id="fstord" type="STRING" size="256" sumtext="초진"/>
          <Column id="reord" type="STRING" size="256" sumtext="재진"/>
          <Column id="sum" type="STRING" size="256" sumtext="합계"/>
          <Column id="subtotal" type="STRING" size="256" sumtext="합계"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_breakstatistic_breakstatisticlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="orddeptcd" type="STRING" size="256" sumtext="부서"/>
          <Column id="fstord" type="STRING" size="256" sumtext="초진"/>
          <Column id="freserve" type="STRING" size="256" sumtext="초진"/>
          <Column id="fstordrate" type="STRING" size="256" sumtext="초진율"/>
          <Column id="reord" type="STRING" size="256" sumtext="재진"/>
          <Column id="rereserve" type="STRING" size="256" sumtext="초진"/>
          <Column id="reordrate" type="STRING" size="256" sumtext="재진율"/>
          <Column id="sum" type="STRING" size="256" sumtext="합계"/>
          <Column id="tmpsumreserve" type="STRING" size="256" sumtext="합계"/>
          <Column id="sumrate" type="STRING" size="256" sumtext="합계율"/>
          <Column id="subtotal" type="STRING" size="256" sumtext="합계"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_telstatisticnum_telstatisticnumlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="lastupdtrid" type="STRING" size="256" sumtext="부서"/>
          <Column id="sum" type="STRING" size="256" sumtext="합계"/>
          <Column id="fstord" type="STRING" size="256" sumtext="초진예약"/>
          <Column id="reord" type="STRING" size="256" sumtext="재진예약"/>
          <Column id="fstchanage" type="STRING" size="256" sumtext="초진변경"/>
          <Column id="rechange" type="STRING" size="256" sumtext="재진변경"/>
          <Column id="fstcancel" type="STRING" size="256" sumtext="초진취소"/>
          <Column id="recancel" type="STRING" size="256" sumtext="재진취소"/>
          <Column id="subtotal" type="STRING" size="256" sumtext="재진취소"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_temp_orddeptcd_orddeptcdlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_temp_orddrid_orddridlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_rsrvdeptcd_rsrvdeptcdlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group5.cmb_department" propid="value" datasetid="ds_send" columnid="department"/>
      <BindItem id="item1" compid="group5.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item2" compid="group5.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item3" compid="group5.cmb_orddept" propid="value" datasetid="ds_send" columnid="orddept"/>
      <BindItem id="item4" compid="group5.cmb_orddr" propid="value" datasetid="ds_send" columnid="orddr"/>
      <BindItem id="item5" compid="group5.statistic_gooboon" propid="value" datasetid="ds_send" columnid="statisticgooboon"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2016-05-24
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-05-24      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "com_basiccodexp::ZBC001.xjs";
include "pam_pamcomnxp::PAM.xjs";
include "pam_opatmngtxp::PMOCOM.xjs";
include "com_commodulexp::SSZFM00701.xjs";	    // Tab Page 없애기 위해
function SMPMO01500_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}
function SMPMO01500_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(swt_outpatient.case_reservation.grd_reservationstatistic); 
	grdf_initGrid(swt_outpatient.case_break.grd_break);
	grdf_initGrid(swt_outpatient.case_cancel.grd_cancel);
	grdf_initGrid(swt_outpatient.case_change.grd_change);
	grdf_initGrid(swt_outpatient.case_tel.datagrid1);
	
	var arrParam = [{dsNm: "ds_init_comncdlist_P0008list", cdGrpId: "P0008"}
				   ,{dsNm: "ds_init_comncdlist_P0021list", cdGrpId: "P0021"}
				   ,{dsNm: "ds_init_comncdlist_P0341list", cdGrpId: "P0341"}
				   ,{dsNm: "ds_init_comncdlist_P0022list", cdGrpId: "P0022"}
				   ,{dsNm: "ds_init_comncdlist_P0020list", cdGrpId: "P0020"}
				   ,{dsNm: "ds_init_comncdlist_P0029list", cdGrpId: "P0029"}
				   ,{dsNm: "ds_init_comncdlist_P0344list", cdGrpId: "P0344"}
				   ,{dsNm: "ds_init_comncdlist_P0010list", cdGrpId: "P0010"}]
	appf_getCodeList(arrParam); 
	
	//진료과코드 진료의사ID 조회
	pamGetDeptCDDrIDList();
	ds_init_orddeptcd_orddeptcdlist.copyData(ds_init_orddeptcdlist);
	ds_init_orddrid_orddridlist.copyData(ds_init_orddridlist);
	//초기화 및 날자   입력 항목에 오늘 날자 세팅
	fInitialize();
	
	dsf_makeValue(ds_init_temp_orddeptcd_orddeptcdlist, "cd", "string", "");
	dsf_makeValue(ds_init_temp_orddeptcd_orddeptcdlist, "nm", "string", "");
	
	dsf_copyDs(ds_init_orddeptcd_orddeptcdlist, ds_init_temp_orddeptcd_orddeptcdlist, "before")
	
	dsf_makeValue(ds_init_temp_orddrid_orddridlist, "cd", "string", "");
	dsf_makeValue(ds_init_temp_orddrid_orddridlist, "nm", "string", "");
	
	dsf_copyDs(ds_init_orddrid_orddridlist, ds_init_temp_orddrid_orddridlist, "before")
	
	if (frmf_checkOpener())
	{		//팝업화면으로 사용될 때	
		ds_send.setColumn(0, "pid",  opener.frmf_getParameter("pid"));	
		ds_send.setColumn(0, "hngnm",  opener.frmf_getParameter("hngnm"));	
		ds_send.setColumn(0, "rrgstno1",  opener.frmf_getParameter("rrgstno1"));	
		ds_send.setColumn(0, "rrgstno2",  opener.frmf_getParameter("rrgstno2"));	
		ds_send.setColumn(0, "fromdd",  opener.frmf_getParameter("orddd"));	
		ds_send.setColumn(0, "todd",  opener.frmf_getParameter("orddd"));	
		ds_send.setColumn(0, "orddept",  opener.frmf_getParameter("orddeptcd"));	
		ds_send.setColumn(0, "orddr",  opener.frmf_getParameter("orddrid"));	
		ds_send.setColumn(0, "specordyn",  opener.frmf_getParameter("specordyn"));	
		ds_send.setColumn(0, "rsrvflag",  opener.frmf_getParameter("rsrvflag"));	
		ds_send.setColumn(0, "insukind",  opener.frmf_getParameter("insukind"));	
		ds_send.setColumn(0, "acptdd",  opener.frmf_getParameter("acptdd"));	
		ds_send.setColumn(0, "acptno",  opener.frmf_getParameter("acptno"));	
		ds_send.setColumn(0, "tablename",  opener.frmf_getParameter("tablename"));	
		
		swt_outpatient.tabindex = 2;
		group5.button1.click();
	}
	//예약 통계 관련 부서코드 조회
	GetGetRsrvDeptCD();
}

function fInitialize()
{
	ds_send.clearData();
	ds_send.addRow();
	
	//날자 입력 항목에 오늘 날자 세팅				
	var curDate = utlf_getCurrentDate();

	curDate = curDate.toDate().getAddDate(-1,"D");						
	var nextDate = curDate.getFullYear();
	
	nextDate = nextDate.toString() + (( curDate.getMonth() + 1 > 9 ) ? curDate.getMonth() + 1 : "0" + (curDate.getMonth() + 1));
	nextDate = nextDate.toString() + (( curDate.getDate()      > 9 ) ? curDate.getDate() : "0" + curDate.getDate()) ;

	ds_send.setColumn(0, "fromdd", nextDate);
	ds_send.setColumn(0, "todd", nextDate);

	group5.cmb_department.index = 0;
	
	ds_send.setColumn(0, "statisticgooboon", '1');
	group5.cmb_department.enable = true;
}

function GetGetRsrvDeptCD()
{
	var oParam = {};
		oParam.id          = "TRPMO00209";
		oParam.service     = "opatmngtapp.TelStatistic";
		oParam.method      = "reqGetRsrvDeptcd";
		oParam.inds        = "";
		oParam.outds       = "ds_init_rsrvdeptcd_rsrvdeptcdlist=rsrvdeptcdlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRPMO00209";

	tranf_submit(oParam);
}

function group5_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	var fromdd = ds_send.getColumn(0, "fromdd");
	var todd = ds_send.getColumn(0, "todd");
	var orddept = ds_send.getColumn(0, "orddept");
	var orddr = ds_send.getColumn(0, "orddr");
	
	var cnt  = ds_init_rsrvdeptcd_rsrvdeptcdlist.rowcount;
	
	//1은 전화예약 2은 의료협력 
	for( var i = 0; i < cnt; i++)
	{
		if(ds_init_rsrvdeptcd_rsrvdeptcdlist.getColumn(i, "cdid") == "1")
		{
			ds_send.setColumn(0, "teldept",  ds_init_rsrvdeptcd_rsrvdeptcdlist.getColumn(i, "cdnm"));
		}
		
		if(ds_init_rsrvdeptcd_rsrvdeptcdlist.getColumn(i, "cdid") == "2")
		{
			ds_send.setColumn(0, "coopdept",  ds_init_rsrvdeptcd_rsrvdeptcdlist.getColumn(i, "cdnm"));
		}
	}
	
	if( utlf_getDateInterval(fromdd, todd) < 0 )
	{
		sysf_messageBox("일자구분에서 시작일자가 종료일자보다 미래일자 입니다. 확인하세요!", "E999", "");
		return false;
	}
	if( utlf_getDateInterval(fromdd, todd) > 183 )
	{		
			if(sysf_messageBox("반년 이상의 데이터를 조회 하시면 시스템에 과부하가 발생 할 수도 있습니다. 계속 진행 하시겠습니까", "Q999", "") != 6)
			{
				return false;
			}
	}
	
	if( fCheckSearchValues())
	{ 
		if (group5.statistic_gooboon.value == "1") 
		{
			swt_outpatient.tabindex = 1;
				
			var oParam = {};
				oParam.id          = "TRPMO01500";
				oParam.service     = "opatmngtapp.TelStatistic";
				oParam.method      = "reqGetTelReservationStatistic";
				oParam.inds        = "req=ds_send";
				oParam.outds       = "ds_main_reservationstatistic_reservationstatisticlist=reservationstatisticlist";
				oParam.async       = false;
				//oParam.callback    = "cf_TRPMO01500";

			tranf_submit(oParam);			
		}
		else if (group5.statistic_gooboon.value == "2" ) 
		{
			swt_outpatient.tabindex = 2;
			var oParam = {};
				oParam.id          = "TRPMO01500";
				oParam.service     = "opatmngtapp.TelStatistic";
				oParam.method      = "reqGetTelReservationStatistic";
				oParam.inds        = "req=ds_send";
				oParam.outds       = "ds_main_reservationstatistic_reservationstatisticlist=reservationstatisticlist";
				oParam.async       = false;
				//oParam.callback    = "cf_TRPMO01500";

			tranf_submit(oParam);
		}
		else if (group5.statistic_gooboon.value == "3" ) 
		{
			swt_outpatient.tabindex = 3;
			var oParam = {};
				oParam.id          = "TRPMO01500";
				oParam.service     = "opatmngtapp.TelStatistic";
				oParam.method      = "reqGetTelReservationStatistic";
				oParam.inds        = "req=ds_send";
				oParam.outds       = "ds_main_reservationstatistic_reservationstatisticlist=reservationstatisticlist";
				oParam.async       = false;
				//oParam.callback    = "cf_TRPMO01500";

			tranf_submit(oParam);
		}
		else if (group5.statistic_gooboon.value == "4") 
		{
			swt_outpatient.tabindex = 4;
			var oParam = {};
				oParam.id          = "TRPMO01503";
				oParam.service     = "opatmngtapp.TelStatistic";
				oParam.method      = "reqGetBreakStatistic";
				oParam.inds        = "req=ds_send";
				oParam.outds       = "ds_main_breakstatistic_breakstatisticlist=breakstatisticlist";
				oParam.async       = false;
				//oParam.callback    = "cf_TRPMO01503";

			tranf_submit(oParam);
					
			var addRow = ds_main_breakstatistic_breakstatisticlist.addRow();
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "orddeptcd", "합계(부도자)");
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "freserve", ds_main_breakstatistic_breakstatisticlist.getSum("freserve"));
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "fstord", ds_main_breakstatistic_breakstatisticlist.getSum("fstord"));
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "fstordrate", ds_main_breakstatistic_breakstatisticlist.getSum("fstordrate"));
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "rereserve", ds_main_breakstatistic_breakstatisticlist.getSum("rereserve"));
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "reord", ds_main_breakstatistic_breakstatisticlist.getSum("reord"));
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "reordrate", ds_main_breakstatistic_breakstatisticlist.getSum("reordrate"));
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "tmpsumreserve", ds_main_breakstatistic_breakstatisticlist.getSum("tmpsumreserve"));
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "sum", ds_main_breakstatistic_breakstatisticlist.getSum("sum"));
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "sumrate", ds_main_breakstatistic_breakstatisticlist.getSum("sumrate"));
			ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "subtotal", ds_main_breakstatistic_breakstatisticlist.getSum("subtotal"));
			
			var endRow = ds_main_breakstatistic_breakstatisticlist.rowcount;
			var row2 = parseInt(ds_main_breakstatistic_breakstatisticlist.getColumn(endRow-1, "freserve"));
			var row3 = parseInt(ds_main_breakstatistic_breakstatisticlist.getColumn(endRow-1, "fstord"));
			var row5 = parseInt(ds_main_breakstatistic_breakstatisticlist.getColumn(endRow-1, "rereserve"));
			var row6 = parseInt(ds_main_breakstatistic_breakstatisticlist.getColumn(endRow-1, "reord"));
			var row8 = parseInt(ds_main_breakstatistic_breakstatisticlist.getColumn(endRow-1, "tmpsumreserve"));
			var row9 = parseInt(ds_main_breakstatistic_breakstatisticlist.getColumn(endRow-1, "sum"));
			
			var freserverate;

			if(row2 == "0" || row3 == "0")
			{
				ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "fstordrate", "0");
			}
			else
			{
				freserverate = Math.round(row3/row2*100);
				ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "fstordrate", freserverate);
			}

			var rereserverate;

			if(row5 == "0" || row6 == "0")
			{
				ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "reordrate", "0");
			}
			else
			{
				rereserverate = Math.round(row6/row5*100);
				ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "reordrate", rereserverate);
			}
												
			var totalrate;

			if(row8 == "0" || row9 == "0")
			{
				ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "sumrate", "0");
			}
			else
			{
				totalrate = Math.round(row9/row8*100);
				ds_main_breakstatistic_breakstatisticlist.setColumn(addRow, "sumrate", totalrate);
			}
		}
		else if (group5.statistic_gooboon.value == "5") 
		{
			swt_outpatient.tabindex = 5;
			var oParam = {};
				oParam.id          = "TRPMO01501";
				oParam.service     = "opatmngtapp.TelStatistic";
				oParam.method      = "reqGetTelStatisticNum";
				oParam.inds        = "req=ds_send";
				oParam.outds       = "ds_main_telstatisticnum_telstatisticnumlist=telstatisticnumlist";
				oParam.async       = false;
				//oParam.callback    = "cf_TRPMO01501";

			tranf_submit(oParam);
		}
	}
}

function fCheckSearchValues()
{
	if( !utlf_isNull(ds_send.getColumn(0, "pid")) || !utlf_isNull(ds_send.getColumn(0, "hngnm")) || !utlf_isNull(ds_send.getColumn(0, "rrgstno1")) || 
		!utlf_isNull(ds_send.getColumn(0, "rrgstno2")) || !utlf_isNull(ds_send.getColumn(0, "fromdd")) || !utlf_isNull(ds_send.getColumn(0, "todd")) || 
		!utlf_isNull(ds_send.getColumn(0, "orddept")) || !utlf_isNull(ds_send.getColumn(0, "orddr")) || !utlf_isNull(ds_send.getColumn(0, "statisticgooboon")) ||
		!utlf_isNull(ds_send.getColumn(0, "department")))
	{
		return true;	
	}
	else
	{	
		return false;	
	}
}

function group5_cmb_orddept_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	ds_init_orddrid_orddridlist.filterstr = "dp == '"+obj.value+"'";
	ds_send.setColumn(0, "orddr", "");
}

function group5_statistic_gooboon_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	switch(obj.value)
	{
		case 1 : 	swt_outpatient.tabindex = 1;
	}
	
	if(obj.value == "5")
	{
		ds_send.setColumn(0, "department", "2");
		group5.cmb_department.enable = false;
	}
	else
	{
		group5.cmb_department.enable = true;
	}
}

function swt_outpatient_case_reservation_btn_updtexcel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(swt_outpatient.case_reservation.grd_reservationstatistic, "excel", "SheetName", "true", "", "open");
}

function swt_outpatient_case_change_btn_cnclexcel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(swt_outpatient.case_change.grd_change, "excel", "SheetName", "true", "", "open");
}

function swt_outpatient_case_cancel_button2_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(swt_outpatient.case_cancel.grd_cancel, "excel", "SheetName", "true", "", "open");
}

function swt_outpatient_case_break_btn_rgstexcel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(swt_outpatient.case_break.grd_break, "excel", "SheetName", "true", "", "open");
}

function swt_outpatient_case_tel_button3_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(swt_outpatient.case_tel.datagrid1, "excel", "SheetName", "true", "", "open");
}

function btn_clear_onclick(obj:Button,  e:ClickEventInfo)
{
	fInitialize();
}
]]></Script>
  </Form>
</FDL>