YNU_JEUS/app_home/himed/xpapps/pam/clamuncoxp/xp/SMPIF71200_청구현황(자보).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPIF71200" position="absolute 0 0 1206 771" titletext="청구현황(자보)" oninit="SMPIF71200_oninit" onload="SMPIF71200_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 13 1195 757" id="grp_biz" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Div position="absolute 1 11 1195 75" align="align:center top;" id="grp_sea" class="div_SA" anchor="default">
                <Layouts>
                  <Layout>
                    <Button position="absolute 1118 22 1174 44" id="button1" class="btn1" text="조회" anchor="default" onclick="grp_biz_grp_sea_button1_onclick"/>
                    <Shape position="absolute 1090 22 1096 44" linetype="vertical" id="line13" class="line_4" anchor="default"/>
                    <Calendar position="absolute 140 21 225 40" 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" autoselect="true"/>
                    <Radio position="absolute 727 18 872 41" id="radio1" class="radio_search" columncount="3" codecolumn="codecolumn" datacolumn="datacolumn" 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">I</Col>
                            <Col id="datacolumn">입원</Col>
                          </Row>
                          <Row>
                            <Col id="codecolumn">O</Col>
                            <Col id="datacolumn">외래</Col>
                          </Row>
                        </Rows>
                      </Dataset>
                    </Radio>
                    <Static text="내원유형 :" position="absolute 646 22 732 39" id="caption7" class="search_name" anchor="default"/>
                    <Static text="손 보 사 :" position="absolute 890 22 977 39" id="caption8" class="search_name" visible="true" anchor="default"/>
                    <Combo position="absolute 971 20 1071 39" id="cmb_insucmpymark" class="combo_search" visible="true" innerdataset="@ds_init_U0001list" datacolumn="nm" codecolumn="cd" anchor="default"/>
                    <Radio position="absolute 1008 1 1173 21" id="rdo_endyn" class="radio_search" visible="false" columncount="3" codecolumn="codecolumn" datacolumn="datacolumn" 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">Y</Col>
                            <Col id="datacolumn">완료</Col>
                          </Row>
                          <Row>
                            <Col id="codecolumn">N</Col>
                            <Col id="datacolumn">미완료</Col>
                          </Row>
                        </Rows>
                      </Dataset>
                    </Radio>
                    <Static text="완 료 여 부 :" position="absolute 910 4 1026 21" id="caption11" class="search_name" visible="false" anchor="default"/>
                    <Static text="기간 :" position="absolute 8 22 79 39" id="caption13" class="search_name" anchor="default"/>
                    <Edit position="absolute 255 39 333 58" id="input11" class="input_search" visible="false" anchor="default"/>
                    <Static text="사 고 번 호 :" position="absolute 150 40 262 57" id="caption17" class="search_name" visible="false" anchor="default"/>
                    <Radio position="absolute 62 10 135 52" id="radio2" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default" onitemchanged="grp_biz_grp_sea_radio2_onitemchanged">
                      <Dataset id="innerdataset">
                        <ColumnInfo>
                          <Column id="codecolumn"/>
                          <Column id="datacolumn"/>
                        </ColumnInfo>
                        <Rows>
                          <Row>
                            <Col id="codecolumn">B</Col>
                            <Col id="datacolumn">청구월</Col>
                          </Row>
                          <Row>
                            <Col id="codecolumn">C</Col>
                            <Col id="datacolumn">청구일자</Col>
                          </Row>
                        </Rows>
                      </Dataset>
                    </Radio>
                    <Combo position="absolute 226 21 284 40" id="cmb_clamdgfrom" class="combo_search" innerdataset="@ds_init_clamdgfrom_clamdglist" datacolumn="clamdgnm" codecolumn="clamdgcd" anchor="default" onitemchanged="grp_biz_grp_sea_cmb_clamdgfrom_onitemchanged"/>
                    <Combo position="absolute 539 20 624 39" id="cmb_clamtype" class="combo_search" innerdataset="@ds_init_P0155list" datacolumn="cdnm" codecolumn="cdid" anchor="default"/>
                    <Static text="청구구분 :" position="absolute 457 21 550 38" id="caption14" class="search_name" anchor="default"/>
                    <Combo position="absolute 383 21 441 40" id="cmb_clamdgto" class="combo_search" innerdataset="@ds_init_clamdgto_clamdglist" datacolumn="clamdgnm" codecolumn="clamdgcd" anchor="default"/>
                    <Static text="~" position="absolute 286 22 301 42" id="caption3" anchor="default"/>
                    <Calendar position="absolute 297 21 382 40" id="ipt_todd" class="input_search" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onkillfocus="grp_biz_grp_sea_ipt_todd_onkillfocus" autoselect="true"/>
                  </Layout>
                </Layouts>
              </Div>
              <Tab position="absolute 1 82 1195 725" id="switch1" class="sw_box" anchor="default" onchanged="grp_biz_switch1_onchanged">
                <Tabpages>
                  <Tabpage text="손보사별청구현황" id="case1">
                    <Layouts>
                      <Layout>
                        <Grid position="absolute 1 0 1192 613" id="datagrid1" binddataset="ds_main_list_datagrid1" anchor="default" cellsizingtype="col">
                          <Formats>
                            <Format id="default">
                              <Columns>
                                <Column size="62"/>
                                <Column size="140"/>
                                <Column size="46"/>
                                <Column size="72"/>
                                <Column size="76"/>
                                <Column size="70"/>
                                <Column size="108"/>
                                <Column size="80"/>
                                <Column size="52"/>
                                <Column size="100"/>
                                <Column size="60"/>
                                <Column size="78"/>
                                <Column size="78"/>
                                <Column size="62"/>
                                <Column size="90"/>
                                <Column size="134"/>
                                <Column size="86"/>
                              </Columns>
                              <Rows>
                                <Row size="24" band="head"/>
                                <Row size="24"/>
                                <Row size="24" band="summ"/>
                              </Rows>
                              <Band id="head">
                                <Cell text="코드"/>
                                <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="입원일"/>
                                <Cell col="12" text="퇴원일"/>
                                <Cell col="13" text="재원기간"/>
                                <Cell col="14" text="청구액"/>
                                <Cell col="15" text="사고접수번호"/>
                                <Cell col="16" text="청구일자"/>
                              </Band>
                              <Band id="body">
                                <Cell style="font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:insucd"/>
                                <Cell col="1" text="bind:insucmpymark" combodataset="ds_init_U0001list" combocodecol="cd" combodatacol="nm"/>
                                <Cell col="2" text="bind:ioflag"/>
                                <Cell col="3" text="bind:acptno"/>
                                <Cell col="4" text="bind:pid"/>
                                <Cell col="5" text="bind:patnm"/>
                                <Cell col="6" text="bind:patrrgstno"/>
                                <Cell col="7" displaytype="expr:getRowLevel(currow) == 1 ? 'normal' : 'date'" text="bind:clamym" mask="expr:getRowLevel(currow) == 1 ? '' : 'yyyy-MM-dd'"/>
                                <Cell col="8" text="bind:clamdg"/>
                                <Cell col="9" text="bind:orddeptcd"/>
                                <Cell col="10" text="bind:orddrid"/>
                                <Cell col="11" displaytype="expr:getRowLevel(currow) == 1 ? 'normal' : 'date'" text="bind:indd" mask="expr:getRowLevel(currow) == 1 ? '' : 'yyyy-MM-dd'"/>
                                <Cell col="12" displaytype="expr:getRowLevel(currow) == 1 ? 'textl' : 'date'" style="font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:dschdd" mask="expr:getRowLevel(currow) == 1 ? '' : 'yyyy-MM-dd'"/>
                                <Cell col="13" style="align:right middle;" text="bind:interm"/>
                                <Cell col="14" displaytype="number" style="font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:clamamt"/>
                                <Cell col="15" text="bind:acdacptno"/>
                                <Cell col="16" displaytype="expr:getRowLevel(currow) == 1 ? 'normal' : 'date'" text="bind:acptdd" mask="expr:getRowLevel(currow) == 1 ? '' : 'yyyy-MM-dd'"/>
                              </Band>
                              <Band id="summary">
                                <Cell/>
                                <Cell col="1"/>
                                <Cell col="2"/>
                                <Cell col="3"/>
                                <Cell col="4"/>
                                <Cell col="5"/>
                                <Cell col="6"/>
                                <Cell col="7"/>
                                <Cell col="8"/>
                                <Cell col="9"/>
                                <Cell col="10"/>
                                <Cell col="11"/>
                                <Cell col="12" style="font:arial,9,bold;" text="총합계"/>
                                <Cell col="13" displaytype="number" style="font:arial,9,bold;" text="expr:getSum('interm')"/>
                                <Cell col="14" displaytype="number" style="font:arial,9,bold;" text="expr:getSum('clamamt')" mask="9,999"/>
                                <Cell col="15"/>
                                <Cell col="16"/>
                              </Band>
                            </Format>
                          </Formats>
                        </Grid>
                      </Layout>
                    </Layouts>
                  </Tabpage>
                  <Tabpage text="월별청구현황" id="case2">
                    <Layouts>
                      <Layout>
                        <Grid position="absolute 1 0 1192 613" id="datagrid2" binddataset="ds_main_list_datagrid2" anchor="default" autofittype="col" cellsizingtype="col">
                          <Formats>
                            <Format id="default">
                              <Columns>
                                <Column size="80"/>
                                <Column size="48"/>
                                <Column size="60"/>
                                <Column size="72"/>
                                <Column size="124"/>
                                <Column size="80"/>
                                <Column size="66"/>
                                <Column size="110"/>
                              </Columns>
                              <Rows>
                                <Row size="24" band="head"/>
                                <Row size="24"/>
                                <Row size="24" band="summ"/>
                              </Rows>
                              <Band id="head">
                                <Cell text="청구월"/>
                                <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="청구액"/>
                              </Band>
                              <Band id="body">
                                <Cell displaytype="date" text="bind:clamym" mask="yyyy-MM"/>
                                <Cell col="1" text="bind:clamdg"/>
                                <Cell col="2" text="bind:ioflag"/>
                                <Cell col="3" text="bind:insucd"/>
                                <Cell col="4" text="bind:insucmpymark" combodataset="ds_init_P0155list" combocodecol="cdid" combodatacol="cdnm"/>
                                <Cell col="5" displaytype="date" text="bind:acptdd" mask="yyyy-MM-dd"/>
                                <Cell col="6" displaytype="number" text="bind:clamcnt"/>
                                <Cell col="7" displaytype="number" text="bind:clamamt"/>
                              </Band>
                              <Band id="summary">
                                <Cell/>
                                <Cell col="1"/>
                                <Cell col="2"/>
                                <Cell col="3"/>
                                <Cell col="4" style="align:left middle;font:arial,9,bold;" text="총합계"/>
                                <Cell col="5"/>
                                <Cell col="6" displaytype="number" style="align:right middle;font:arial,9,bold;" text="expr:getSum('clamcnt')"/>
                                <Cell col="7" displaytype="number" style="align:right middle;font:arial,9,bold;" text="expr:getSum('clamamt')"/>
                              </Band>
                            </Format>
                          </Formats>
                        </Grid>
                        <Grid position="absolute 165 70 942 521" id="datagrid4" visible="false" binddataset="ds_main_list_datagrid4" anchor="default" autofittype="col" cellsizingtype="col">
                          <Formats>
                            <Format id="default">
                              <Columns>
                                <Column size="68"/>
                                <Column size="80"/>
                                <Column size="100"/>
                                <Column size="154"/>
                                <Column size="80"/>
                                <Column size="66"/>
                                <Column size="110"/>
                                <Column size="108"/>
                              </Columns>
                              <Rows>
                                <Row size="24" band="head"/>
                                <Row size="24"/>
                              </Rows>
                              <Band id="head">
                                <Cell text="코드"/>
                                <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="청구일자"/>
                              </Band>
                              <Band id="body">
                                <Cell text="bind:insucd"/>
                                <Cell col="1" displaytype="date" text="bind:clamym" mask="yyyy-MM"/>
                                <Cell col="2" text="bind:insucmpymarkaddr"/>
                                <Cell col="3" text="bind:insucmpymark"/>
                                <Cell col="4" text="bind:seqno"/>
                                <Cell col="5" displaytype="number" text="bind:clamcnt"/>
                                <Cell col="6" displaytype="number" text="bind:clamamt"/>
                                <Cell col="7" displaytype="date" text="bind:acptdd" mask="yyyy-MM-dd"/>
                              </Band>
                            </Format>
                          </Formats>
                        </Grid>
                      </Layout>
                    </Layouts>
                  </Tabpage>
                  <Tabpage text="과별청구현황" id="case3">
                    <Layouts>
                      <Layout>
                        <Grid position="absolute 1 0 1192 613" id="datagrid3" binddataset="ds_main_list_datagrid3" anchor="default" autofittype="col" cellsizingtype="col">
                          <Formats>
                            <Format id="default">
                              <Columns>
                                <Column size="80"/>
                                <Column size="70"/>
                                <Column size="68"/>
                                <Column size="140"/>
                                <Column size="70"/>
                                <Column size="110"/>
                                <Column size="110"/>
                              </Columns>
                              <Rows>
                                <Row size="24" band="head"/>
                                <Row size="24"/>
                                <Row size="24" band="summ"/>
                              </Rows>
                              <Band id="head">
                                <Cell text="청구월"/>
                                <Cell col="1" text="청구차수"/>
                                <Cell col="2" text="내원유형"/>
                                <Cell col="3" text="진료과"/>
                                <Cell col="4" text="청구건수"/>
                                <Cell col="5" text="청구액"/>
                                <Cell col="6" text="건당평균진료비"/>
                              </Band>
                              <Band id="body">
                                <Cell text="bind:clamym"/>
                                <Cell col="1" text="bind:clamdg"/>
                                <Cell col="2" text="bind:ioflag"/>
                                <Cell col="3" text="bind:orddeptcd"/>
                                <Cell col="4" displaytype="number" text="bind:clamcnt"/>
                                <Cell col="5" displaytype="number" text="bind:clamamt"/>
                                <Cell col="6" displaytype="number" text="bind:avgordamt" expr="expr:Math.floor(avgordamt)"/>
                              </Band>
                              <Band id="summary">
                                <Cell/>
                                <Cell col="1"/>
                                <Cell col="2"/>
                                <Cell col="3" style="align:left middle;font:arial,9,bold;" text="총합계"/>
                                <Cell col="4" displaytype="number" style="align:right middle;font:arial,9,bold;" text="expr:getSum('clamcnt')"/>
                                <Cell col="5" displaytype="number" style="align:right middle;font:arial,9,bold;" text="expr:getSum('clamamt')"/>
                                <Cell col="6"/>
                              </Band>
                            </Format>
                          </Formats>
                        </Grid>
                      </Layout>
                    </Layouts>
                  </Tabpage>
                </Tabpages>
              </Tab>
              <Button position="absolute 489 85 542 104" id="button10" class="btn2" visible="false" text="열카피" anchor="default"/>
              <Button position="absolute 543 85 596 104" id="button11" class="btn2" visible="false" text="행카피" anchor="default"/>
              <Button position="absolute 1115 85 1195 104" id="button12" class="btn7" text="엑셀저장" anchor="default" onclick="grp_biz_button12_onclick"/>
              <Button position="absolute 435 85 488 104" id="button13" class="btn2" visible="false" text="셀카피" anchor="default"/>
              <Button position="absolute 936 85 1063 104" id="btn_carlist" class="btn7" visible="false" text="자보명단 액셀저장" anchor="default" onclick="grp_biz_btn_carlist_onclick"/>
              <Button position="absolute 771 85 935 104" id="btn_insulist" class="btn7" visible="false" text="손보사별청구액 엑셀저장" anchor="default" onclick="grp_biz_btn_insulist_onclick"/>
              <Edit position="absolute 690 85 768 104" id="ipt_seqno" class="input_search" visible="false" anchor="default"/>
              <Static text="일련번호 :" position="absolute 627 87 687 104" id="cap_seqno" anchor="default"/>
              <Button position="absolute 1064 85 1114 104" id="button2" class="btn6" text="출력" anchor="default" onclick="grp_biz_button2_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 729 1195 765" id="group1" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Button position="absolute 1137 8 1193 30" id="button45" class="btn4" text="닫기" anchor="default" 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="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="termflag" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="clamdgfrom" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="clamdgto" type="STRING" size="256"/>
          <Column id="clamflag" type="STRING" size="256"/>
          <Column id="ioflag" type="STRING" size="256"/>
          <Column id="certno" type="STRING" size="256"/>
          <Column id="endyn" type="STRING" size="256"/>
          <Column id="patunitsrch1" type="STRING" size="256"/>
          <Column id="patunitsrch2" type="STRING" size="256"/>
          <Column id="acdacptno" type="STRING" size="256"/>
          <Column id="insukind" type="STRING" size="256"/>
          <Column id="clamym" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="termflag">B</Col>
            <Col id="ioflag">A</Col>
            <Col id="endyn">A</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_excel" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="seqno" type="STRING" size="256"/>
          <Column id="printno" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="seqno"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_datagrid1" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="insucd" type="STRING" size="256" sumtext="손보사코드" prop="KEY"/>
          <Column id="insucmpymark" type="STRING" size="256" sumtext="손보사id"/>
          <Column id="acptdd" type="STRING" size="256" sumtext="접수일자"/>
          <Column id="ioflag" type="STRING" size="256" sumtext="내원유형"/>
          <Column id="pid" type="STRING" size="256" sumtext="등록번호"/>
          <Column id="patnm" type="STRING" size="256" sumtext="수진자명"/>
          <Column id="patrrgstno" type="STRING" size="256" sumtext="주민번호"/>
          <Column id="clamym" type="STRING" size="256" sumtext="청구년월"/>
          <Column id="clamdg" type="STRING" size="256" sumtext="청구차수"/>
          <Column id="orddeptcd" type="STRING" size="256" sumtext="진료과"/>
          <Column id="orddrid" type="STRING" size="256" sumtext="진료과"/>
          <Column id="indd" type="STRING" size="256" sumtext="입원일"/>
          <Column id="dschdd" type="STRING" size="256" sumtext="기관별소계" prop="TEXT"/>
          <Column id="interm" type="STRING" size="256" sumtext="재원기간"/>
          <Column id="acdacptno" type="STRING" size="256" sumtext="사고접수번호"/>
          <Column id="clamamt" type="BIGDECIMAL" size="256" sumtext="청구액"/>
          <Column id="acptno" type="STRING" size="256" sumtext="접수번호"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_list_datagrid2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="clamym" type="STRING" size="256" sumtext="청구년월"/>
          <Column id="uncoym" type="STRING" size="256" sumtext="미수년월"/>
          <Column id="ioflag" type="STRING" size="256" sumtext="내원유형"/>
          <Column id="insucd" type="STRING" size="256" sumtext="손보사코드"/>
          <Column id="insucmpymark" type="STRING" size="256" sumtext="손보사id"/>
          <Column id="insucmpymarkaddr" type="STRING" size="256" sumtext="손보사주소"/>
          <Column id="ordym" type="STRING" size="256" sumtext="진료과"/>
          <Column id="clamdg" type="STRING" size="256" sumtext="청구차수"/>
          <Column id="clamflagcd" type="STRING" size="256" sumtext="청구형태"/>
          <Column id="acptdd" type="STRING" size="256" sumtext="접수일자"/>
          <Column id="acptno" type="STRING" size="256" sumtext="접수번호"/>
          <Column id="clamcnt" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="clamamt" type="STRING" size="256" sumtext="청구금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_list_datagrid3" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="clamym" type="STRING" size="256" sumtext="청구년월"/>
          <Column id="uncoym" type="STRING" size="256" sumtext="미수년월"/>
          <Column id="clamdg" type="STRING" size="256" sumtext="청구차수"/>
          <Column id="orddeptcd" type="STRING" size="256" sumtext="진료과"/>
          <Column id="ioflag" type="STRING" size="256" sumtext="내원유형"/>
          <Column id="clamcnt" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="clamamt" type="STRING" size="256" sumtext="청구금액"/>
          <Column id="avgordamt" type="STRING" size="256" sumtext="건당평균진료비"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_list_datagrid4" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="insucd" type="STRING" size="256" sumtext="손보사코드"/>
          <Column id="clamym" type="STRING" size="256" sumtext="청구년월"/>
          <Column id="insucmpymarkaddr" type="STRING" size="256" sumtext="손보사주소"/>
          <Column id="insucmpymark" type="STRING" size="256" sumtext="손보사id"/>
          <Column id="seqno" type="STRING" size="256" sumtext="진료과"/>
          <Column id="acptno" type="STRING" size="256" sumtext="접수번호"/>
          <Column id="clamcnt" type="STRING" size="256" sumtext="청구건수"/>
          <Column id="clamamt" type="STRING" size="256" sumtext="청구금액"/>
          <Column id="acptdd" type="STRING" size="256" sumtext="접수일자"/>
        </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">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_clamdgfrom_clamdglist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="clamdgnm" type="STRING" size="256"/>
          <Column id="clamdgcd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_clamdgto_clamdglist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="clamdgnm" type="STRING" size="256"/>
          <Column id="clamdgcd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_U0001list" 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_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="ioflag" type="STRING" size="256"/>
          <Column id="insuno" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="termflag" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_tmp_datagrid1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="insucd" type="STRING" size="256" sumtext="손보사코드" prop="KEY"/>
          <Column id="insucmpymark" type="STRING" size="256" sumtext="손보사id"/>
          <Column id="acptdd" type="STRING" size="256" sumtext="접수일자"/>
          <Column id="ioflag" type="STRING" size="256" sumtext="내원유형"/>
          <Column id="pid" type="STRING" size="256" sumtext="등록번호"/>
          <Column id="patnm" type="STRING" size="256" sumtext="수진자명"/>
          <Column id="patrrgstno" type="STRING" size="256" sumtext="주민번호"/>
          <Column id="clamym" type="STRING" size="256" sumtext="청구년월"/>
          <Column id="clamdg" type="STRING" size="256" sumtext="청구차수"/>
          <Column id="orddeptcd" type="STRING" size="256" sumtext="진료과"/>
          <Column id="orddrid" type="STRING" size="256" sumtext="진료과"/>
          <Column id="indd" type="STRING" size="256" sumtext="입원일"/>
          <Column id="dschdd" type="STRING" size="256" sumtext="기관별소계" prop="TEXT"/>
          <Column id="interm" type="STRING" size="256" sumtext="재원기간"/>
          <Column id="acdacptno" type="STRING" size="256" sumtext="사고접수번호"/>
          <Column id="clamamt" type="BIGDECIMAL" size="256" sumtext="청구액"/>
          <Column id="acptno" type="STRING" size="256" sumtext="접수번호"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_biz.grp_sea.radio2" propid="value" datasetid="ds_send" columnid="termflag"/>
      <BindItem id="item1" compid="grp_biz.grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item2" compid="grp_biz.grp_sea.cmb_clamdgfrom" propid="value" datasetid="ds_send" columnid="clamdgfrom"/>
      <BindItem id="item3" compid="grp_biz.grp_sea.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item4" compid="grp_biz.grp_sea.cmb_clamdgto" propid="value" datasetid="ds_send" columnid="clamdgto"/>
      <BindItem id="item5" compid="grp_biz.grp_sea.cmb_clamtype" propid="value" datasetid="ds_send" columnid="clamflag"/>
      <BindItem id="item6" compid="grp_biz.grp_sea.radio1" propid="value" datasetid="ds_send" columnid="ioflag"/>
      <BindItem id="item7" compid="grp_biz.grp_sea.rdo_endyn" propid="value" datasetid="ds_send" columnid="endyn"/>
      <BindItem id="item8" compid="grp_biz.grp_sea.cmb_insucmpymark" propid="value" datasetid="ds_send" columnid="certno"/>
      <BindItem id="item9" compid="grp_biz.grp_sea.input11" propid="value" datasetid="ds_send" columnid="acdacptno"/>
      <BindItem id="item10" compid="grp_biz.ipt_seqno" propid="value" datasetid="ds_hidden_excel" columnid="seqno"/>
    </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 SMPIF71200_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMPIF71200_onload(obj:Form, e:LoadEventInfo)
{	
	grdf_initGrid(grp_biz.switch1.case1.datagrid1);
	grdf_initGrid(grp_biz.switch1.case2.datagrid2);
	grdf_initGrid(grp_biz.switch1.case3.datagrid3);
	
	CommCode_Load();
	
	if (frmf_checkOpener()) 
	{
		ds_temp.copyData(arg_ds_send);
		
		ds_send.setColumn(0, "fromdd", ds_temp.getColumn(0, "fromdd"));
		ds_send.setColumn(0, "todd", ds_temp.getColumn(0, "todd"));
		ds_send.setColumn(0, "termflag", ds_temp.getColumn(0, "termflag"));
	}
	else
	{
		ds_send.setColumn(0, "fromdd", String(utlf_getCurrentDate()).substr(0,6));
		ds_send.setColumn(0, "todd", String(utlf_getCurrentDate()).substr(0,6));
	}
		
	fGetClamdg();
}

function CommCode_Load()
{
	var arrParam = [ {dsNm: "ds_init_P0028list", cdGrpId: "P0028"}
					,{dsNm: "ds_init_P0155list", cdGrpId: "P0155"}]
				   
	appf_getCodeList(arrParam);	
	
	ds_init_P0155list.insertRow(0);
	
	var oParam = {};
		oParam.id          = "TRPIF70305";
		oParam.service     = "clamuncoapp.ClamUnco";
		oParam.method      = "reqGetInsuComp";
		oParam.inds        = "";
		oParam.outds       = "ds_init_U0001list=U0001";
		oParam.async       = false;
		//oParam.callback    = "cf_TRPIF70305";

	tranf_submit(oParam);
		
	frmf_addComboItem("grp_biz.grp_sea.cmb_insucmpymark","전체","","above");
	
	ds_send.setColumn(0, "certno", "");
}

function fGetClamdg()
{
	var check = ds_send.getColumn(0, "termflag");
		
	if(ds_send.getColumn(0, "fromdd") > ds_send.getColumn(0, "todd"))
	{
		sysf_messageBox("종료일은 시작일보다 클 수 ", "I004");
		ds_send.setColumn(0, "todd", "");
	}
	
	if(check == "B")
	{
		if(!utlf_isNull(ds_send.getColumn(0, "fromdd")) || !utlf_isNull(ds_send.getColumn(0, "todd")))
		{
			ds_send.setColumn(0, "clamym", ds_send.getColumn(0, "fromdd"));
			ds_send.setColumn(0, "insukind", "31");

			var oParam = {};
				oParam.id          = "TRPID20407";
				oParam.service     = "aftjudgapp.InAftJudgTrgtMan";
				oParam.method      = "reqGetClamdg";
				oParam.inds        = "req=ds_send";
				oParam.outds       = "ds_init_clamdgfrom_clamdglist=clamdg";
				oParam.async       = false;
				//oParam.callback    = "cf_TRPID20407";

			tranf_submit(oParam);
			
			ds_send.setColumn(0, "clamym", ds_send.getColumn(0, "todd"));
			ds_send.setColumn(0, "insukind", "31");
			
			var oParam = {};
				oParam.id          = "TRPID20407";
				oParam.service     = "aftjudgapp.InAftJudgTrgtMan";
				oParam.method      = "reqGetClamdg";
				oParam.inds        = "req=ds_send";
				oParam.outds       = "ds_init_clamdgto_clamdglist=clamdg";
				oParam.async       = false;
				//oParam.callback    = "cf_TRPID20407";

			tranf_submit(oParam);
			
			frmf_addComboItem("grp_biz.grp_sea.cmb_clamdgfrom","전체","","above");
			frmf_addComboItem("grp_biz.grp_sea.cmb_clamdgto","전체","","above");			
		}
	}	
	grp_biz.grp_sea.cmb_clamdgfrom.index = 0;
	grp_biz.grp_sea.cmb_clamdgto.index = 0;
}

function grp_biz_grp_sea_radio2_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	if(ds_send.getColumn(0, "termflag") != "C")
	{
		ds_send.setColumn(0, "fromdd", "");
		ds_send.setColumn(0, "todd", "");
		
		grp_biz.grp_sea.ipt_fromdd.dateformat = "yyyy-MM";
		grp_biz.grp_sea.ipt_fromdd.editformat = "yyyy-MM";
		
		grp_biz.grp_sea.ipt_todd.dateformat = "yyyy-MM";
		grp_biz.grp_sea.ipt_todd.editformat = "yyyy-MM";
	}
	else
	{
		ds_send.setColumn(0, "fromdd", "");
		ds_send.setColumn(0, "todd", "");
		
		grp_biz.grp_sea.ipt_fromdd.dateformat = "yyyy-MM-dd";
		grp_biz.grp_sea.ipt_fromdd.editformat = "yyyy-MM-dd";
		
		grp_biz.grp_sea.ipt_todd.dateformat = "yyyy-MM-dd";
		grp_biz.grp_sea.ipt_todd.editformat = "yyyy-MM-dd";
	}
	
	if(ds_send.getColumn(0, "termflag") == "B")
	{
		grp_biz.grp_sea.cmb_clamdgfrom.enable = true;
		grp_biz.grp_sea.cmb_clamdgto.enable = true;
		
		grp_biz.grp_sea.cmb_clamdgfrom.index = 0;
		grp_biz.grp_sea.cmb_clamdgto.index = 0;
	} 
	else 
	{
		ds_send.setColumn(0, "clamdgfrom", "");
		ds_send.setColumn(0, "clamdgto", "");
		
		grp_biz.grp_sea.cmb_clamdgfrom.enable = false;
		grp_biz.grp_sea.cmb_clamdgto.enable = false;
	}
}

function grp_biz_grp_sea_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var date = obj.value;
	
	if(ds_send.getColumn(0, "termflag") == "B")
	{
		ds_send.setColumn(0, "fromdd", String(date).substr(0,6));
		ds_send.setColumn(0, "todd", String(date).substr(0,6));
	}
	else
	{
		ds_send.setColumn(0, "fromdd", date);
		ds_send.setColumn(0, "todd", date);
	}
	
	fGetClamdg();
}

function grp_biz_grp_sea_cmb_clamdgfrom_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	ds_send.setColumn(0, "clamdgto", obj.value);
}

function grp_biz_grp_sea_ipt_todd_onkillfocus(obj:Calendar, e:KillFocusEventInfo)
{
	fGetClamdg();
}

function grp_biz_grp_sea_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRPIF71201";
		oParam.service     = "clamuncoapp.ClamUnco";
		oParam.method      = "reqGetClamStatAutmbInsu";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_list_datagrid1=datagrid1 ds_main_list_datagrid2=datagrid2 ds_main_list_datagrid3=datagrid3 ds_main_list_datagrid4=datagrid4";
		oParam.async       = false;
		//oParam.callback    = "cf_TRPIF71201";

	tranf_submit(oParam);
	
	ds_main_list_datagrid1.keystring = "G:insucd";											
}

function grp_biz_switch1_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
{
	if(obj.tabindex == 0)
	{
		grp_biz.btn_carlist.visible = true;
		grp_biz.cap_seqno.visible = false;
		grp_biz.ipt_seqno.visible = false;
		grp_biz.btn_insulist.visible = false;
	}
	else if(obj.tabindex == 1)
	{
		grp_biz.btn_carlist.visible = false;
		grp_biz.cap_seqno.visible = true;
		grp_biz.ipt_seqno.visible = true;
		grp_biz.btn_insulist.visible = true;
	}
	else if(obj.tabindex == 2)
	{
		grp_biz.btn_carlist.visible = false;
		grp_biz.cap_seqno.visible = false;
		grp_biz.ipt_seqno.visible = false;
		grp_biz.btn_insulist.visible = false;
	}
}

function grp_biz_btn_insulist_onclick(obj:Button,  e:ClickEventInfo)
{
	if (utlf_isNull(ds_hidden_excel.getColumn(0, "seqno")))
	{
		alert("일련번호를 입력하세요");
		grp_biz.ipt_seqno.setFocus();
		
		return false;
	} 
	else 
	{
		for(var i = 0; i < ds_main_list_datagrid4.rowcount; i++) 
		{
			ds_main_list_datagrid4.setColumn(i, "seqno", ds_hidden_excel.getColumn(0, "seqno"));
		}
	}
	
	if(ds_main_list_datagrid4.rowcount == 0)
	{
		sysf_messageBox("엑셀저장할 내역이", "I004");
	}
	else
	{
		grdf_exportExcel(grp_biz.switch1.case2.datagrid4, "손보사별청구현황", "see");
	}
}

function grp_biz_btn_carlist_onclick(obj:Button,  e:ClickEventInfo)
{
	for(var i = 0; i < ds_main_list_datagrid1.rowcount; i++) 
	{
		if(utlf_isNull(ds_main_list_datagrid1.getColumn(i, "pid")))
		{
			grp_biz.switch1.case1.datagrid1.setFormatRowProperty(i, "size", 0); //datagrid1.rowHidden(i) = true;
		}
	}

	if(ds_main_list_datagrid1.rowcount == 0)
	{
		sysf_messageBox("엑셀저장할 내역이", "I004");
	}
	else
	{
		grdf_exportExcel(grp_biz.switch1.case1.datagrid1, "자동차보험청구명단", "see");
	}
	
	
	for(var i = 0; i < ds_main_list_datagrid1.rowcount; i++) 
	{
		var rowhidden = grp_biz.switch1.case1.datagrid1.getFormatRowProperty(i, "size");
		
		if(rowhidden == 0)
		{
			grp_biz.switch1.case1.datagrid1.setFormatRowProperty(i, "size", 24); //datagrid1.rowHidden(i) = false;
		}
	}			
}

function grp_biz_button2_onclick(obj:Button,  e:ClickEventInfo)
{
	if(grp_biz.switch1.tabindex == 0)
	{
		ds_tmp_datagrid1.clearData();
		
		for(var i = 0; i < ds_main_list_datagrid1.rowcount; i++)
		{
			if(ds_main_list_datagrid1.getColumn(i, "dschdd") != "기관별소계")
			{
				var row = ds_tmp_datagrid1.addRow();
				
				ds_tmp_datagrid1.copyRow(row, ds_main_list_datagrid1, i);
			}
		}
		
		var objDOM = rptf_createDOM();	// DOM 객체 설정
			rptf_setNodeListToDOM(objDOM, "/root/main/list/datagrid1", ds_tmp_datagrid1);
			
		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(["RPPIF71200"],[objParam], option);
	}
	else if(grp_biz.switch1.tabindex == 1)
	{
		var objDOM = rptf_createDOM();	// DOM 객체 설정
			rptf_setNodeListToDOM(objDOM, "/root/main/list/datagrid2", ds_main_list_datagrid2);
			rptf_setNodeListToDOM(objDOM, "/root/hidden/excel", ds_hidden_excel);
			
		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(["RPPIF80300"],[objParam], option);
	}
}

function grp_biz_button12_onclick(obj:Button,  e:ClickEventInfo)
{
	if(grp_biz.switch1.tabindex == 0)
	{
		if(ds_main_list_datagrid1.rowcount == 0)
		{
			sysf_messageBox("엑셀저장할 내역이", "I004");
		}
		else
		{
			grdf_exportExcel(grp_biz.switch1.case1.datagrid1, "청구현황_손보사별청구현황", "see");
		}
	}
	else if(grp_biz.switch1.tabindex == 1)
	{
		if(ds_main_list_datagrid2.rowcount == 0)
		{
			sysf_messageBox("엑셀저장할 내역이", "I004");
		}
		else
		{
			grdf_exportExcel(grp_biz.switch1.case2.datagrid2, "청구현황_월별청구현황", "see");
		}
	}
	else if(grp_biz.switch1.tabindex == 2)
	{
		if(ds_main_list_datagrid3.rowcount == 0)
		{
			sysf_messageBox("엑셀저장할 내역이", "I004");
		}
		else
		{
			grdf_exportExcel(grp_biz.switch1.case3.datagrid3, "청구현황_과별청구현황", "see");
		}
	}
}

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