YNU_JEUS/app_home/himed/xpapps/pam/clamuncoxp/xp/SPPIF80203_과별삭감현황조회(전월대비).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPPIF80203" position="absolute 0 0 1204 791" titletext="과별삭감현황조회(전월대비)" oninit="SPPIF80203_oninit" onload="SPPIF80203_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 1 13 1196 757" id="grp_biz" scrollbars="autoboth" anchor="all">
          <Layouts>
            <Layout>
              <Div position="absolute 0 11 1194 49" align="align:center top;" id="grp_sea" class="div_SA" anchor="left top right">
                <Layouts>
                  <Layout>
                    <Button position="absolute 1123 7 1179 29" id="button1" class="btn1" text="조회" anchor="top right" onclick="grp_biz_grp_sea_button1_onclick"/>
                    <Shape position="absolute 1095 7 1101 29" linetype="vertical" id="line13" class="line_4" anchor="top right"/>
                    <Calendar position="absolute 96 9 166 28" id="ipt_fromdd" class="input_search" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="grp_biz_grp_sea_ipt_fromdd_onchanged"/>
                    <Static text="기준년월 :" position="absolute 10 11 92 28" id="caption13" class="search_name" anchor="default"/>
                    <Static text="진료과 :" position="absolute 667 10 742 27" id="caption1" class="search_name" anchor="default"/>
                    <Static text="보험유형 :" position="absolute 245 11 335 28" id="caption2" class="search_name" anchor="default"/>
                    <Static text="청구분야 :" position="absolute 882 10 991 27" id="caption4" class="search_name" anchor="default"/>
                    <Combo position="absolute 740 8 855 27" id="combo1" class="combo_search" innerdataset="@ds_init_list1_deptlist" datacolumn="depthngnm" codecolumn="deptcd" anchor="default"/>
                    <Combo position="absolute 968 8 1083 27" id="cmb_orddeptcd" class="combo_search" innerdataset="@ds_init_P0458list" datacolumn="cdnm" codecolumn="cdid" anchor="default"/>
                    <cp_checkboxList id="checkbox1" titletext="CheckBox List" taborder="1" text="cp_checkboxList00" scrollbars="none" position="absolute 326 9 600 31" style="background:transparent; " col="1" row="1" cellspacing="2" vcellspacing="0" itemWidth="100" itemHeight="20" overflow="visible" anchor="default"/>
                  </Layout>
                </Layouts>
              </Div>
              <Button position="absolute 1115 57 1195 76" id="button12" class="btn7" text="엑셀저장" anchor="top right" onclick="grp_biz_button12_onclick"/>
              <Shape position="absolute 0 76 1195 82" linetype="horizontal" id="line2" class="line_1" anchor="left top right" style="strokepen:3 solid #33bbbbff;"/>
              <Static text="과별삭감현황조회(전월대비)" position="absolute 0 60 265 83" id="caption10" class="tit_2" anchor="default"/>
              <Button position="absolute 1064 57 1114 76" id="button2" class="btn6" visible="false" text="출력" anchor="top right" onclick="grp_biz_button2_onclick"/>
              <Grid position="absolute 0 81 1195 741" id="multilinegrid1" anchor="all" binddataset="ds_main_list_deptitemcutamtlist" cellsizingtype="col">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="93" band="left"/>
                      <Column size="40"/>
                      <Column size="65"/>
                      <Column size="88"/>
                      <Column size="97"/>
                      <Column size="54"/>
                      <Column size="69"/>
                      <Column size="59"/>
                      <Column size="63"/>
                      <Column size="67"/>
                      <Column size="40"/>
                      <Column size="40"/>
                      <Column size="57"/>
                      <Column size="91"/>
                      <Column size="105"/>
                      <Column size="52"/>
                      <Column size="75"/>
                      <Column size="60"/>
                      <Column size="69"/>
                      <Column size="64"/>
                      <Column size="43"/>
                      <Column size="60"/>
                      <Column size="55"/>
                      <Column size="72"/>
                      <Column size="69"/>
                      <Column size="86"/>
                      <Column size="58"/>
                      <Column size="40"/>
                      <Column size="40"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24" band="head"/>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                      <Row size="24"/>
                      <Row size="24"/>
                      <Row size="24" band="summ"/>
                      <Row size="24" band="summ"/>
                      <Row size="24" band="summ"/>
                    </Rows>
                    <Band id="head">
                      <Cell rowspan="3" text="과" taborder="undefined"/>
                      <Cell col="1" rowspan="3" text="구분" taborder="undefined"/>
                      <Cell col="2" colspan="10" text="현월" taborder="undefined"/>
                      <Cell col="12" colspan="10" text="전월" taborder="undefined"/>
                      <Cell col="22" colspan="7" text="전월대비증감" taborder="undefined"/>
                      <Cell row="1" col="2" rowspan="2" text="청구건수" taborder="undefined"/>
                      <Cell row="1" col="3" rowspan="2" text="청구총진료비" taborder="undefined"/>
                      <Cell row="1" col="4" rowspan="2" text="청구액" taborder="undefined"/>
                      <Cell row="1" col="5" colspan="6" text="삭감액" taborder="undefined"/>
                      <Cell row="1" col="11" rowspan="2" text="삭감율" taborder="undefined"/>
                      <Cell row="1" col="12" rowspan="2" text="청구건수" taborder="undefined"/>
                      <Cell row="1" col="13" rowspan="2" text="청구총진료비" taborder="undefined"/>
                      <Cell row="1" col="14" rowspan="2" text="청구액" taborder="undefined"/>
                      <Cell row="1" col="15" colspan="6" text="삭감액" taborder="undefined"/>
                      <Cell row="1" col="21" rowspan="2" text="삭감율" taborder="undefined"/>
                      <Cell row="1" col="22" colspan="6" text="삭감증감액" taborder="undefined"/>
                      <Cell row="1" col="28" rowspan="2" text="증감율" taborder="undefined"/>
                      <Cell row="2" col="5" text="총건수"/>
                      <Cell row="2" col="6" text="삭감액소계"/>
                      <Cell row="2" col="7" text="원내건수"/>
                      <Cell row="2" col="8" text="원내"/>
                      <Cell row="2" col="9" text="원외건수"/>
                      <Cell row="2" col="10" text="원외"/>
                      <Cell row="2" col="15" text="총건수"/>
                      <Cell row="2" col="16" text="삭감액소계"/>
                      <Cell row="2" col="17" text="원내건수"/>
                      <Cell row="2" col="18" text="원내"/>
                      <Cell row="2" col="19" text="원외건수"/>
                      <Cell row="2" col="20" text="원외"/>
                      <Cell row="2" col="22" text="총건수"/>
                      <Cell row="2" col="23" text="삭감액소계"/>
                      <Cell row="2" col="24" text="원내건수"/>
                      <Cell row="2" col="25" text="원내"/>
                      <Cell row="2" col="26" text="원외건수"/>
                      <Cell row="2" col="27" text="원외"/>
                    </Band>
                    <Band id="body">
                      <Cell rowspan="3" celltype="head" text="bind:orddeptnm" taborder="undefined"/>
                      <Cell col="1" text="bind:ioflag_a"/>
                      <Cell col="2" displaytype="number" style="align:right middle;" text="bind:totcnt_a"/>
                      <Cell col="3" displaytype="number" style="align:right middle;" text="bind:totamt_a"/>
                      <Cell col="4" displaytype="number" style="align:right middle;" text="bind:totclamamt_a"/>
                      <Cell col="5" displaytype="number" style="align:right middle;" text="bind:totcutcnt_a"/>
                      <Cell col="6" displaytype="number" style="align:right middle;" text="bind:totadjtamt_a"/>
                      <Cell col="7" displaytype="number" style="align:right middle;" text="bind:totcnt_in_a"/>
                      <Cell col="8" displaytype="number" style="align:right middle;" text="bind:totadjtamt_in_a"/>
                      <Cell col="9" displaytype="number" style="align:right middle;" text="bind:totcnt_out_a"/>
                      <Cell col="10" displaytype="number" style="align:right middle;" text="bind:totadjtamt_out_a"/>
                      <Cell col="11" displaytype="number" style="align:right middle;" text="bind:totadjtamtper_a"/>
                      <Cell col="12" displaytype="number" style="align:right middle;" text="bind:bftotcnt_a"/>
                      <Cell col="13" displaytype="number" style="align:right middle;" text="bind:bftotamt_a"/>
                      <Cell col="14" displaytype="number" style="align:right middle;" text="bind:bftotclamamt_a"/>
                      <Cell col="15" displaytype="number" style="align:right middle;" text="bind:bftotcutcnt_a"/>
                      <Cell col="16" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_a"/>
                      <Cell col="17" displaytype="number" style="align:right middle;" text="bind:bftotcnt_in_a"/>
                      <Cell col="18" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_in_a"/>
                      <Cell col="19" displaytype="number" style="align:right middle;" text="bind:bftotcnt_out_a"/>
                      <Cell col="20" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_out_a"/>
                      <Cell col="21" displaytype="number" style="align:right middle;" text="bind:bftotadjtamtper_a"/>
                      <Cell col="22" displaytype="number" style="align:right middle;" text="bind:cptotcutcnt_a"/>
                      <Cell col="23" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_a"/>
                      <Cell col="24" displaytype="number" style="align:right middle;" text="bind:cptotcnt_in_a"/>
                      <Cell col="25" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_in_a"/>
                      <Cell col="26" displaytype="number" style="align:right middle;" text="bind:cptotcnt_out_a"/>
                      <Cell col="27" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_out_a"/>
                      <Cell col="28" displaytype="number" style="align:right middle;" text="bind:cptotadjtamtper_a"/>
                      <Cell row="1" col="1" text="bind:ioflag_i"/>
                      <Cell row="1" col="2" displaytype="number" style="align:right middle;" text="bind:totcnt_i"/>
                      <Cell row="1" col="3" displaytype="number" style="align:right middle;" text="bind:totalamt_i"/>
                      <Cell row="1" col="4" displaytype="number" style="align:right middle;" text="bind:clamamt_i"/>
                      <Cell row="1" col="5" displaytype="number" style="align:right middle;" text="bind:totcutcnt_i"/>
                      <Cell row="1" col="6" displaytype="number" style="align:right middle;" text="bind:totadjtamt_i"/>
                      <Cell row="1" col="7" displaytype="number" style="align:right middle;" text="bind:totcnt_in_i"/>
                      <Cell row="1" col="8" displaytype="number" style="align:right middle;" text="bind:totadjtamt_in_i"/>
                      <Cell row="1" col="9" displaytype="number" style="align:right middle;" text="bind:totcnt_out_i"/>
                      <Cell row="1" col="10" displaytype="number" style="align:right middle;" text="bind:totadjtamt_out_i"/>
                      <Cell row="1" col="11" displaytype="number" style="align:right middle;" text="bind:totadjtamt_iper"/>
                      <Cell row="1" col="12" displaytype="number" style="align:right middle;" text="bind:bftotcnt_i"/>
                      <Cell row="1" col="13" displaytype="number" style="align:right middle;" text="bind:bftotalamt_i"/>
                      <Cell row="1" col="14" displaytype="number" style="align:right middle;" text="bind:bfclamamt_i"/>
                      <Cell row="1" col="15" displaytype="number" style="align:right middle;" text="bind:bftotcutcnt_i"/>
                      <Cell row="1" col="16" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_i"/>
                      <Cell row="1" col="17" displaytype="number" style="align:right middle;" text="bind:bftotcnt_in_i"/>
                      <Cell row="1" col="18" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_in_i"/>
                      <Cell row="1" col="19" displaytype="number" style="align:right middle;" text="bind:bftotcnt_out_i"/>
                      <Cell row="1" col="20" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_out_i"/>
                      <Cell row="1" col="21" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_iper_i"/>
                      <Cell row="1" col="22" displaytype="number" style="align:right middle;" text="bind:cptotcnt_i"/>
                      <Cell row="1" col="23" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_i"/>
                      <Cell row="1" col="24" displaytype="number" style="align:right middle;" text="bind:cptotcnt_in_i"/>
                      <Cell row="1" col="25" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_in_i"/>
                      <Cell row="1" col="26" displaytype="number" style="align:right middle;" text="bind:cptotcnt_out_i"/>
                      <Cell row="1" col="27" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_out_i"/>
                      <Cell row="1" col="28" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_iper_i"/>
                      <Cell row="2" col="1" text="bind:ioflag_o"/>
                      <Cell row="2" col="2" displaytype="number" style="align:right middle;" text="bind:totcnt_o"/>
                      <Cell row="2" col="3" displaytype="number" style="align:right middle;" text="bind:totalamt_o"/>
                      <Cell row="2" col="4" displaytype="number" style="align:right middle;" text="bind:clamamt_o"/>
                      <Cell row="2" col="5" displaytype="number" style="align:right middle;" text="bind:totcutcnt_o"/>
                      <Cell row="2" col="6" displaytype="number" style="align:right middle;" text="bind:totadjtamt_o"/>
                      <Cell row="2" col="7" displaytype="number" style="align:right middle;" text="bind:totcnt_in_o"/>
                      <Cell row="2" col="8" displaytype="number" style="align:right middle;" text="bind:totadjtamt_in_o"/>
                      <Cell row="2" col="9" displaytype="number" style="align:right middle;" text="bind:totcnt_out_o"/>
                      <Cell row="2" col="10" displaytype="number" style="align:right middle;" text="bind:totadjtamt_out_o"/>
                      <Cell row="2" col="11" displaytype="number" style="align:right middle;" text="bind:totadjtamt_oper"/>
                      <Cell row="2" col="12" displaytype="number" style="align:right middle;" text="bind:bftotcnt_o"/>
                      <Cell row="2" col="13" displaytype="number" style="align:right middle;" text="bind:bftotalamt_o"/>
                      <Cell row="2" col="14" displaytype="number" style="align:right middle;" text="bind:bfclamamt_o"/>
                      <Cell row="2" col="15" displaytype="number" style="align:right middle;" text="bind:bftotcutcnt_o"/>
                      <Cell row="2" col="16" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_o"/>
                      <Cell row="2" col="17" displaytype="number" style="align:right middle;" text="bind:bftotcnt_in_o"/>
                      <Cell row="2" col="18" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_in_o"/>
                      <Cell row="2" col="19" displaytype="number" style="align:right middle;" text="bind:bftotcnt_out_o"/>
                      <Cell row="2" col="20" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_out_o"/>
                      <Cell row="2" col="21" displaytype="number" style="align:right middle;" text="bind:bftotadjtamt_oper_o"/>
                      <Cell row="2" col="22" displaytype="number" style="align:right middle;" text="bind:cptotcutcnt_o"/>
                      <Cell row="2" col="23" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_o"/>
                      <Cell row="2" col="24" displaytype="number" style="align:right middle;" text="bind:cptotcnt_in_o"/>
                      <Cell row="2" col="25" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_in_o"/>
                      <Cell row="2" col="26" displaytype="number" style="align:right middle;" text="bind:cptotcnt_out_o"/>
                      <Cell row="2" col="27" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_out_o"/>
                      <Cell row="2" col="28" displaytype="number" style="align:right middle;" text="bind:cptotadjtamt_oper_o"/>
                    </Band>
                    <Band id="summary">
                      <Cell rowspan="3" celltype="head" text="전체" taborder="undefined"/>
                      <Cell col="1" text="합계"/>
                      <Cell col="2" displaytype="number" style="align:right middle;" text="expr:getSum('totcnt_a')" mask="9,999"/>
                      <Cell col="3" displaytype="number" style="align:right middle;" text="expr:getSum('totamt_a')"/>
                      <Cell col="4" displaytype="number" style="align:right middle;" text="expr:getSum('totclamamt_a')"/>
                      <Cell col="5" displaytype="number" style="align:right middle;" text="expr:getSum('totcutcnt_a')"/>
                      <Cell col="6" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_a')"/>
                      <Cell col="7" displaytype="number" style="align:right middle;" text="expr:getSum('totcnt_in_a')"/>
                      <Cell col="8" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_in_a')"/>
                      <Cell col="9" displaytype="number" style="align:right middle;" text="expr:getSum('totcnt_out_a')"/>
                      <Cell col="10" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_out_a')"/>
                      <Cell col="11" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamtper_a')"/>
                      <Cell col="12" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcnt_a')"/>
                      <Cell col="13" displaytype="number" style="align:right middle;" text="expr:getSum('bftotamt_a')"/>
                      <Cell col="14" displaytype="number" style="align:right middle;" text="expr:getSum('bftotclamamt_a')"/>
                      <Cell col="15" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcutcnt_a')"/>
                      <Cell col="16" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_a')"/>
                      <Cell col="17" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcnt_in_a')"/>
                      <Cell col="18" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_in_a')"/>
                      <Cell col="19" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcnt_out_a')"/>
                      <Cell col="20" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_out_a')"/>
                      <Cell col="21" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamtper_a')"/>
                      <Cell col="22" displaytype="number" style="align:right middle;" text="expr:getSum('cptotcutcnt_a')"/>
                      <Cell col="23" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_a')"/>
                      <Cell col="24" displaytype="number" style="align:right middle;" text="expr:getSum('cptotcnt_in_a')"/>
                      <Cell col="25" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_in_a')"/>
                      <Cell col="26" displaytype="number" style="align:right middle;" text="expr:getSum('cptotcnt_out_a')"/>
                      <Cell col="27" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_out_a')"/>
                      <Cell col="28" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamtper_a')"/>
                      <Cell row="1" col="1" text="입원"/>
                      <Cell row="1" col="2" displaytype="number" style="align:right middle;" text="expr:getSum('totcnt_i')" mask="9,999"/>
                      <Cell row="1" col="3" displaytype="number" style="align:right middle;" text="expr:getSum('totalamt_i')"/>
                      <Cell row="1" col="4" displaytype="number" style="align:right middle;" text="expr:getSum('clamamt_i')"/>
                      <Cell row="1" col="5" displaytype="number" style="align:right middle;" text="expr:getSum('totcutcnt_i')"/>
                      <Cell row="1" col="6" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_i')"/>
                      <Cell row="1" col="7" displaytype="number" style="align:right middle;" text="expr:getSum('totcnt_in_i')"/>
                      <Cell row="1" col="8" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_in_i')"/>
                      <Cell row="1" col="9" displaytype="number" style="align:right middle;" text="expr:getSum('totcnt_out_i')"/>
                      <Cell row="1" col="10" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_out_i')"/>
                      <Cell row="1" col="11" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_iper')"/>
                      <Cell row="1" col="12" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcnt_i')"/>
                      <Cell row="1" col="13" displaytype="number" style="align:right middle;" text="expr:getSum('bftotalamt_i')"/>
                      <Cell row="1" col="14" displaytype="number" style="align:right middle;" text="expr:getSum('bfclamamt_i')"/>
                      <Cell row="1" col="15" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcutcnt_i')"/>
                      <Cell row="1" col="16" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_i')"/>
                      <Cell row="1" col="17" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcnt_in_i')"/>
                      <Cell row="1" col="18" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_in_i')"/>
                      <Cell row="1" col="19" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcnt_out_i')"/>
                      <Cell row="1" col="20" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_out_i')"/>
                      <Cell row="1" col="21" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_iper_i')"/>
                      <Cell row="1" col="22" displaytype="number" style="align:right middle;" text="expr:getSum('cptotcnt_i')"/>
                      <Cell row="1" col="23" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_i')"/>
                      <Cell row="1" col="24" displaytype="number" style="align:right middle;" text="expr:getSum('cptotcnt_in_i')"/>
                      <Cell row="1" col="25" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_in_i')"/>
                      <Cell row="1" col="26" displaytype="number" style="align:right middle;" text="expr:getSum('cptotcnt_out_i')"/>
                      <Cell row="1" col="27" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_out_i')"/>
                      <Cell row="1" col="28" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_iper_i')"/>
                      <Cell row="2" col="1" text="외래"/>
                      <Cell row="2" col="2" displaytype="number" style="align:right middle;" text="expr:getSum('totcnt_o')" mask="9,999"/>
                      <Cell row="2" col="3" displaytype="number" style="align:right middle;" text="expr:getSum('totamt_o')"/>
                      <Cell row="2" col="4" displaytype="number" style="align:right middle;" text="expr:getSum('clamamt_o')"/>
                      <Cell row="2" col="5" displaytype="number" style="align:right middle;" text="expr:getSum('totcutcnt_o')"/>
                      <Cell row="2" col="6" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_o')"/>
                      <Cell row="2" col="7" displaytype="number" style="align:right middle;" text="expr:getSum('totcnt_in_o')"/>
                      <Cell row="2" col="8" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_in_o')"/>
                      <Cell row="2" col="9" displaytype="number" style="align:right middle;" text="expr:getSum('totcnt_out_o')"/>
                      <Cell row="2" col="10" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_out_o')"/>
                      <Cell row="2" col="11" displaytype="number" style="align:right middle;" text="expr:getSum('totadjtamt_oper')"/>
                      <Cell row="2" col="12" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcnt_o')"/>
                      <Cell row="2" col="13" displaytype="number" style="align:right middle;" text="expr:getSum('bftotalamt_o')"/>
                      <Cell row="2" col="14" displaytype="number" style="align:right middle;" text="expr:getSum('bfclamamt_o')"/>
                      <Cell row="2" col="15" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcutcnt_o')"/>
                      <Cell row="2" col="16" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_o')"/>
                      <Cell row="2" col="17" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcnt_in_o')"/>
                      <Cell row="2" col="18" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_in_o')"/>
                      <Cell row="2" col="19" displaytype="number" style="align:right middle;" text="expr:getSum('bftotcnt_out_o')"/>
                      <Cell row="2" col="20" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_out_o')"/>
                      <Cell row="2" col="21" displaytype="number" style="align:right middle;" text="expr:getSum('bftotadjtamt_oper_o')"/>
                      <Cell row="2" col="22" displaytype="number" style="align:right middle;" text="expr:getSum('cptotcutcnt_o')"/>
                      <Cell row="2" col="23" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_o')"/>
                      <Cell row="2" col="24" displaytype="number" style="align:right middle;" text="expr:getSum('cptotcnt_in_o')"/>
                      <Cell row="2" col="25" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_in_o')"/>
                      <Cell row="2" col="26" displaytype="number" style="align:right middle;" text="expr:getSum('cptotcnt_out_o')"/>
                      <Cell row="2" col="27" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_out_o')"/>
                      <Cell row="2" col="28" displaytype="number" style="align:right middle;" text="expr:getSum('cptotadjtamt_oper_o')"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Static text="※청구월 기준 조회 입니다." position="absolute 205 55 365 75" id="caption5" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 757 1195 784" id="grp_btn"/>
        <Div position="absolute 0 755 1195 783" id="group1" scrollbars="autoboth" anchor="left right bottom">
          <Layouts>
            <Layout>
              <Button position="absolute 1138 5 1194 27" id="button45" class="btn4" text="닫기" anchor="right bottom" onclick="group1_button45_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption6" text="과별삭감현황조회(전월대비)" class="tit_1" position="absolute 1 0 249 23"/>
      </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="ioflag" type="STRING" size="256"/>
          <Column id="insukind" type="STRING" size="256"/>
          <Column id="ordfildcd" type="STRING" size="256"/>
          <Column id="orddeptcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="ioflag">I</Col>
            <Col id="insukind">11^21^22^41</Col>
            <Col id="ordfildcd">-</Col>
            <Col id="orddeptcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_chk_checkbox1" 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">11</Col>
          </Row>
          <Row>
            <Col id="label">의료급여1종</Col>
            <Col id="value">21</Col>
          </Row>
          <Row>
            <Col id="label">의료급여2종</Col>
            <Col id="value">22</Col>
          </Row>
          <Row>
            <Col id="label">산재</Col>
            <Col id="value">41</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_deptitemcutamtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="orddeptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="ioflag_a" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="totcnt_a" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="totamt_a" type="STRING" size="256" sumtext="총진료비"/>
          <Column id="totclamamt_a" type="STRING" size="256" sumtext="청구액"/>
          <Column id="totcutcnt_a" type="STRING" size="256" sumtext="총건수"/>
          <Column id="totadjtamt_a" type="STRING" size="256" sumtext="삭감액소계"/>
          <Column id="totcnt_in_a" type="STRING" size="256" sumtext="원내건수"/>
          <Column id="totadjtamt_in_a" type="STRING" size="256" sumtext="원내금액"/>
          <Column id="totcnt_out_a" type="STRING" size="256" sumtext="원외건수"/>
          <Column id="totadjtamt_out_a" type="STRING" size="256" sumtext="원외금액"/>
          <Column id="totadjtamtper_a" type="STRING" size="256" sumtext="삭감율"/>
          <Column id="bftotcnt_a" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="bftotamt_a" type="STRING" size="256" sumtext="총진료비"/>
          <Column id="bftotclamamt_a" type="STRING" size="256" sumtext="청구액"/>
          <Column id="bftotcutcnt_a" type="STRING" size="256" sumtext="총건수"/>
          <Column id="bftotadjtamt_a" type="STRING" size="256" sumtext="삭감액소계"/>
          <Column id="bftotcnt_in_a" type="STRING" size="256" sumtext="원내건수"/>
          <Column id="bftotadjtamt_in_a" type="STRING" size="256" sumtext="원내금액"/>
          <Column id="bftotcnt_out_a" type="STRING" size="256" sumtext="원외건수"/>
          <Column id="bftotadjtamt_out_a" type="STRING" size="256" sumtext="원외금액"/>
          <Column id="bftotadjtamtper_a" type="STRING" size="256" sumtext="삭감율"/>
          <Column id="cptotcutcnt_a" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="cptotadjtamt_a" type="STRING" size="256" sumtext="삭감액소계"/>
          <Column id="cptotcnt_in_a" type="STRING" size="256" sumtext="원내건수"/>
          <Column id="cptotadjtamt_in_a" type="STRING" size="256" sumtext="원내금액"/>
          <Column id="cptotcnt_out_a" type="STRING" size="256" sumtext="원외건수"/>
          <Column id="cptotadjtamt_out_a" type="STRING" size="256" sumtext="원외금액"/>
          <Column id="cptotadjtamtper_a" type="STRING" size="256" sumtext="삭감율"/>
          <Column id="ioflag_i" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="totcnt_i" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="totalamt_i" type="STRING" size="256" sumtext="총진료비"/>
          <Column id="clamamt_i" type="STRING" size="256" sumtext="청구액"/>
          <Column id="totcutcnt_i" type="STRING" size="256" sumtext="총건수"/>
          <Column id="totadjtamt_i" type="STRING" size="256" sumtext="삭감액소계"/>
          <Column id="totcnt_in_i" type="STRING" size="256" sumtext="원내건수"/>
          <Column id="totadjtamt_in_i" type="STRING" size="256" sumtext="원내금액"/>
          <Column id="totcnt_out_i" type="STRING" size="256" sumtext="원외건수"/>
          <Column id="totadjtamt_out_i" type="STRING" size="256" sumtext="원외금액"/>
          <Column id="totadjtamt_iper" type="STRING" size="256" sumtext="삭감율"/>
          <Column id="bftotcnt_i" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="bftotalamt_i" type="STRING" size="256" sumtext="총진료비"/>
          <Column id="bfclamamt_i" type="STRING" size="256" sumtext="청구액"/>
          <Column id="bftotcutcnt_i" type="STRING" size="256" sumtext="총건수"/>
          <Column id="bftotadjtamt_i" type="STRING" size="256" sumtext="삭감액소계"/>
          <Column id="bftotcnt_in_i" type="STRING" size="256" sumtext="원내건수"/>
          <Column id="bftotadjtamt_in_i" type="STRING" size="256" sumtext="원내금액"/>
          <Column id="bftotcnt_out_i" type="STRING" size="256" sumtext="원외건수"/>
          <Column id="bftotadjtamt_out_i" type="STRING" size="256" sumtext="원외금액"/>
          <Column id="bftotadjtamt_iper_i" type="STRING" size="256" sumtext="삭감율"/>
          <Column id="cptotcnt_i" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="cptotadjtamt_i" type="STRING" size="256" sumtext="삭감액소계"/>
          <Column id="cptotcnt_in_i" type="STRING" size="256" sumtext="원내건수"/>
          <Column id="cptotadjtamt_in_i" type="STRING" size="256" sumtext="원내금액"/>
          <Column id="cptotcnt_out_i" type="STRING" size="256" sumtext="원외건수"/>
          <Column id="cptotadjtamt_out_i" type="STRING" size="256" sumtext="원외금액"/>
          <Column id="cptotadjtamt_iper_i" type="STRING" size="256" sumtext="삭감율"/>
          <Column id="ioflag_o" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="totcnt_o" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="totalamt_o" type="STRING" size="256" sumtext="총진료비"/>
          <Column id="clamamt_o" type="STRING" size="256" sumtext="청구액"/>
          <Column id="totcutcnt_o" type="STRING" size="256" sumtext="총건수"/>
          <Column id="totadjtamt_o" type="STRING" size="256" sumtext="삭감액소계"/>
          <Column id="totcnt_in_o" type="STRING" size="256" sumtext="원내건수"/>
          <Column id="totadjtamt_in_o" type="STRING" size="256" sumtext="원내금액"/>
          <Column id="totcnt_out_o" type="STRING" size="256" sumtext="원외건수"/>
          <Column id="totadjtamt_out_o" type="STRING" size="256" sumtext="원외금액"/>
          <Column id="totadjtamt_oper" type="STRING" size="256" sumtext="삭감율"/>
          <Column id="bftotcnt_o" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="bftotalamt_o" type="STRING" size="256" sumtext="총진료비"/>
          <Column id="bfclamamt_o" type="STRING" size="256" sumtext="청구액"/>
          <Column id="bftotcutcnt_o" type="STRING" size="256" sumtext="총건수"/>
          <Column id="bftotadjtamt_o" type="STRING" size="256" sumtext="삭감액소계"/>
          <Column id="bftotcnt_in_o" type="STRING" size="256" sumtext="원내건수"/>
          <Column id="bftotadjtamt_in_o" type="STRING" size="256" sumtext="원내금액"/>
          <Column id="bftotcnt_out_o" type="STRING" size="256" sumtext="원외건수"/>
          <Column id="bftotadjtamt_out_o" type="STRING" size="256" sumtext="원외금액"/>
          <Column id="bftotadjtamt_oper_o" type="STRING" size="256" sumtext="삭감율"/>
          <Column id="cptotcutcnt_o" type="STRING" size="256" sumtext="총건수"/>
          <Column id="cptotadjtamt_o" type="STRING" size="256" sumtext="삭감액소계"/>
          <Column id="cptotcnt_in_o" type="STRING" size="256" sumtext="원내건수"/>
          <Column id="cptotadjtamt_in_o" type="STRING" size="256" sumtext="원내금액"/>
          <Column id="cptotcnt_out_o" type="STRING" size="256" sumtext="원외건수"/>
          <Column id="cptotadjtamt_out_o" type="STRING" size="256" sumtext="원외금액"/>
          <Column id="cptotadjtamt_oper_o" type="STRING" size="256" sumtext="삭감율"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_P0458list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_list1_deptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="depthngnm" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_P0028list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_P0155list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_M0029list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_M0530list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_P0443list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_biz.grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item1" compid="grp_biz.grp_sea.combo1" propid="value" datasetid="ds_send" columnid="orddeptcd"/>
      <BindItem id="item2" compid="grp_biz.grp_sea.cmb_orddeptcd" propid="value" datasetid="ds_send" columnid="ordfildcd"/>
    </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 "pam_pamcomnxp::PAM001.xjs";
include "pam_pamcomnxp::PAM.xjs";

function SPPIF80203_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPPIF80203_onload(obj:Form, e:LoadEventInfo)
{
	var sProp="col=4,row=1,cellspacing=4,vcellspacing=0,itemWidth=-1,itemHeight=20,overflow='visible'";
	grp_biz.grp_sea.checkbox1.setInitComp(sProp, ds_chk_checkbox1,"value","label","fn_cmpEvent");
	
	grp_biz.grp_sea.checkbox1.setCheckAll(false);//초기화
	var insukind = ds_send.getColumn(0, "insukind");
	grp_biz.grp_sea.checkbox1.setData(utlf_transNullToEmpty(insukind).split("^"), "", false);
	
	CommCode_Load();
	
	ds_main_list_deptitemcutamtlist.clearData();
	
	ds_send.setColumn(0, "fromdd", String(utlf_getCurrentDate()).substr(0,6));
	
	frmf_addComboItem("grp_biz.grp_sea.cmb_orddeptcd","의과전체","A","above");
}

function CommCode_Load()
{
	dsf_createDsRow("ds_tmp", [ {col:"instcd", type:"STRING", size:256, val: sysf_getUserInfo("dutplceinstcd")}
							,	{col:"ordfildcd", type:"STRING", size:256, val: ""}
							,	{col:"ordflag", type:"STRING", size:256, val: ""}]);	
							
	var oParam = {};
		oParam.id          = "TRPIJ00203";
		oParam.service     = "bfjudgapp.InHospJudgTrgtMan";
		oParam.method      = "reqGetDeptList";
		oParam.inds        = "req=ds_tmp";
		oParam.outds       = "ds_init_list1_deptlist=deptlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRPIJ00203";

	tranf_submit(oParam);
	
	var arrParam = [{dsNm: "ds_init_P0028list", cdGrpId: "P0028"}
				   ,{dsNm: "ds_init_P0155list", cdGrpId: "P0155"}
				   ,{dsNm: "ds_init_M0530list", cdGrpId: "M0530"}
				   ,{dsNm: "ds_init_M0029list", cdGrpId: "M0029"}
				   ,{dsNm: "ds_init_P0443list", cdGrpId: "P0443"}
				   ,{dsNm: "ds_init_P0458list", cdGrpId: "P0458"}]
				   
	appf_getCodeList(arrParam);	
}

function fn_cmpEvent()
{
	var insukind = grp_biz.grp_sea.checkbox1.getData();
	ds_send.setColumn(0, "insukind", chk);
}

function grp_biz_grp_sea_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var date = obj.value;
	
	ds_send.setColumn(0, "fromdd", String(date).substr(0,6));
}

function grp_biz_grp_sea_button1_onclick(obj:Button,  e:ClickEventInfo)
{
// 	var sWindowMsg = "데이터 조회 중입니다...";
// 	callLoadingWindow(sWindowMsg);
// 
// 	asyncSend("TRPIF80204", "/root/send", "/root/main/list", "responseHandlerTRPIF80204");

	var oParam = {};
		oParam.id          = "TRPIF80104";
		oParam.service     = "clamuncoapp.ClamUnco";
		oParam.method      = "reqGetDeptBeforMonCutamtList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_list_deptitemcutamtlist=deptitemcutamtlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRPIF80104";

	tranf_submit(oParam);
	
	dsf_setDefaultVal(ds_main_list_deptitemcutamtlist, "ioflag_a:합계,ioflag_i:입원,ioflag_o:외래");

}

function grp_biz_button2_onclick(obj:Button,  e:ClickEventInfo)
{
	var objDOM = rptf_createDOM();	// DOM 객체 설정
	rptf_setNodeListToDOM(objDOM, "/root/main/list/deptcutamtlist", ds_main_list_deptcutamtlist);
	rptf_setNodeListToDOM(objDOM, "/root/send", ds_send);
	
	var objParam = new Object();
	objParam.xml_data_XML1 = objDOM.documentElement.source;
	
	var option =// "open=1;save=1;directprint=0;printdialog=0;print=1;zoom=0;";	
	
	rptf_exeReportPreview30(["RPPIF80200"],[objParam], option);
}

function grp_biz_button12_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_main_list_deptitemcutamtlist.rowcount == 0)
	{
		sysf_messageBox("엑셀저장할 내역이", "I004");
	}
	else
	{
		grdf_exportExcel(grp_biz.multilinegrid1, "과별삭감현황조회(전월대비)", "see");
	}
}

function group1_button45_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();
}
]]></Script>
  </Form>
</FDL>